Manaz Afzal Book a consultation

Work snippet

Looker Studio branch dashboard from Xero

Concept DesignIllustrative integration walkthrough. Business details, figures and records are worked examples.

Branch managers in this service group were rebuilding the month’s figures from exports. A single Looker Studio view now covers revenue, margin, job count and money owed for each branch, with a written definition behind every number and a trace back to its source.

The problemEach month the branch pack is rebuilt by hand from exports.

What changesOne dashboard, by branch, with every figure defined and traceable.

Area
Dashboards
Tools
Looker Studio · Xero · ServiceM8 or Jobber
Typical scope
US$400-900
Timeline
About 6 weeks · fixed milestones

The problem

If managers doubt a dashboard they go back to their spreadsheets. The real work is agreeing definitions and showing the totals reconcile to Xero.

  • A monthly pack that is late and different every time
  • Branch margins that the finance lead and the managers argue about
  • Completed jobs that were never invoiced, found weeks later
  • No way to give each manager only their own numbers

Approach

  1. Look

    A read-only review of the monthly pack, the job system exports and the Xero reports.

  2. Define

    Every figure gets a written definition, a source, an owner and a refresh time.

  3. Build and connect

    The loads, the reporting data and the dashboard are built together, one page at a time.

  4. Check

    Dashboard totals are compared with Xero and the job system for three closed months.

Exhibit

Branch dashboard, one month (Looker Studio, light theme)
Branch: All branchesMonth: Typical monthData: Xero and ServiceM8
Revenue$412,600ex GST, by invoice date
Gross margin38.4%Revenue less direct costs
Jobs completed1,184
Completed, not invoiced$21,350after 3 days
Debtor days36last 90 days

Revenue by branch

North$148.2kCentral$96.4kEast$71.3kSouth$52.7kWest$31.9kUnallocated$12.1k

Revenue, last six months ($k)

May$318kJunJulAugSepOct$413k
BranchRevenueMargin %Jobs
North148,20041.2%412
Central96,40037.5%298
East71,30036.1%221
South52,70039.8%144
West31,90033.4%109
Unallocated12,100-0
Data quality 7 invoices with no Branch, shown in their own bar · last good refresh 06:10 · 3 completed jobs with no Xero invoice
Branch dashboard: revenue $412,600, gross margin 38.4%, revenue by branch bar chart.

How to read it

  1. Revenue by branch shows an Unallocated bar for invoices with no branch, so nothing disappears.
  2. Each figure is tied to a written definition, one click away in the dashboard.
  3. A data quality line shows missing tracking and failed loads, so the dashboard reports its own gaps.

Scope

AreaIncluded
ReviewThe current pack, exports and Xero reports, with findings
DefinitionsA written definition for every figure, agreed with the finance lead
Data loadsScheduled loads from Xero and the job system into a reporting sheet or dataset
DashboardExecutive, branch, jobs and cash pages in Looker Studio, with one filter bar
AccessManagers see only their own branch
CheckTotals compared with Xero and the job system for three closed months
HandoverA walkthrough and the files, which you own

Milestones and fee

MilestoneDeliverableTimingShare of fee
M1 Review and definitionsFindings and written KPI definitionsWeeks 1 to 220%
M2 Data loadsLoads running and totals tiedWeeks 3 to 435%
M3 DashboardPages built and checked on three monthsWeek 530%
M4 HandoverAccess, walkthrough and filesWeek 615%

Typical scope for this kind of project: US$400-900

About 6 weeks · fixed milestones. The systems health check (US$150, fixed) comes first and confirms the scope. Extra hourly work is US$35 per hour, agreed before it starts.

Discuss an engagement.

Outline the operational problem through the contact form. I respond with a recommended starting point, including whether the US$150 systems health check is the appropriate first step.

Related work snippets

Next step

Bring me the work that repeats.

I scope it in writing, test it against your current process on your own data and hand over everything I build.

Book a consultation