TRUE BEARINGDATA
QuickBooks Online reporting

A QuickBooks Online dashboard that shows every location on one page.

QuickBooks Online holds the truth about your money, but its reports answer one question at a time. A location dashboard pulls your books every night and shows revenue, margin and cash for every location side by side.

Why QuickBooks reports stop being enough

QuickBooks Online can tag transactions by Location or Class (on plans that include those features), and the built-in Profit and Loss by Location report is a good start. The trouble comes when an owner wants more than one view at once: margin by location, which customers are 60 days late, which bills are due this week, and whether any of last month's numbers quietly changed.

That usually turns into a monthly export to Excel, a pivot table, and a spreadsheet that one person understands. A dashboard does the same work automatically and the same way every time.

What the scorecard shows

  • Revenue, gross margin and net income by location or class, month over month
  • Receivables aging: who owes you, how much, and for how long
  • Bills and payables coming due in the next 7 and 30 days
  • Voided, deleted and back-dated transactions flagged automatically, so a closed month that changes gets noticed
  • A Monday email summary for owners who would rather not log in

How it connects

You sign in to QuickBooks Online once and approve read-only reporting access through Intuit's standard connection screen. Each night a pipeline copies new and changed transactions into a reporting database, then rebuilds the scorecard. Your bookkeeper does not change how they work.

If you already tag transactions by Location or Class, the scorecard uses those tags. If you don't, we can map accounts or customers to locations as part of setup, and write down the rule so everyone reads the numbers the same way.

A synthetic example

Our sample company, Bluebird Home Services, is a fictional four-location business. Its scorecard shows one location with the highest revenue and the lowest margin, and a handful of customers who make up most of the 60+ day receivables. Those are the two conversations the owner needs to have that week, and they are on the first screen. Every name and number in the sample is invented.

Frequently asked questions

Can QuickBooks Online report by location?

Yes. QuickBooks Online Plus and Advanced let you tag transactions with Locations or Classes and run Profit and Loss by Location or by Class. A dashboard builds on those tags so you can compare locations over time and alongside receivables, payables and other systems.

Do I need QuickBooks Online Advanced?

No. Location and Class tracking are available on Plus as well. If your plan does not include them, locations can be mapped from accounts or customers instead.

Will this change anything in my books?

No. The connection is used to read data for reporting. Nothing is written back to QuickBooks.

Can it combine QuickBooks with my POS or field software?

Yes. A common setup is QuickBooks next to the system the work happens in, such as Square or Jobber, with the same location names on one page.

See what your own numbers would show.

Tell us which systems you run and the report you rebuild every week. We'll give you an honest read on what would help.