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.