Management Reports and KPI Dashboards from QuickBooks Online Data#
Many business owners see their numbers once a year, when the tax preparer asks for them. By then the numbers are too old to act on. A monthly management pack fixes that, but only if someone builds it the same way every month and the books behind it are sound. This article sets out what such a pack contains, how the KPIs are calculated, and which parts an offshore team can prepare for you.
What a monthly management pack contains#
A practical pack is short. Ours is built from the QuickBooks Online file and usually has these parts:
- Profit and loss with comparatives. The current month against the prior month and the same month last year, where there is history.
- Balance sheet. At month end, with the prior month beside it.
- Cash flow statement. Where cash came from and where it went.
- Budget versus actual. Where a budget exists, with the variance in amount and percent.
- Receivables and payables aging. Who owes the business and who the business owes, by age band.
- A short KPI page. Five to eight measures, defined once and calculated the same way each month.
- A management summary. A few lines on what changed and what looks unusual.
For businesses with more than one entity or location, the same pack can be consolidated across QuickBooks Online files.
Close and reconcile first#
A report is only as good as the books behind it. Before a pack is built, the month needs to be closed:
- Bank, credit card and loan accounts reconciled to statements.
- Receivables and payables agree to the aging reports.
- Uncategorized and "Ask My Accountant" balances cleared or listed.
- Undeposited funds cleared.
If these are not done, the KPIs will be wrong in ways that are hard to see. A gross margin figure built on miscategorized costs looks like a margin figure. This is why reporting sits on top of bookkeeping and month-end close, and why we work directly inside the QuickBooks Online file: the report matches what is actually in the ledger.
How the KPIs are defined#
The formulas below are standard. Each one needs a clear rule about what goes into it, and that rule should be written down so the number means the same thing every month.
| KPI | Formula |
|---|---|
| Gross margin | (Revenue minus cost of sales) divided by revenue |
| Net margin | Net profit divided by revenue |
| Days sales outstanding (DSO) | Accounts receivable divided by credit sales for the period, multiplied by days in the period |
| Current ratio | Current assets divided by current liabilities |
| Average monthly net burn | Cash out minus cash in, averaged over recent months, when cash out is higher |
| Cash runway (months) | Cash balance divided by average monthly net burn |
We do not quote benchmarks for any of these. What counts as a good figure depends on the business, its sector and its stage, and that judgment belongs to the owner and the firm advising them.
Illustrative example#
Take a small services business for one month (illustrative figures only):
| Item | Amount |
|---|---|
| Revenue | 100,000 |
| Cost of sales | 40,000 |
| Net profit | 12,000 |
| Accounts receivable at month end | 60,000 |
| Cash balance | 90,000 |
| Average monthly net burn | 15,000 |
- Gross margin: (100,000 minus 40,000) divided by 100,000 = 60 percent.
- Net margin: 12,000 divided by 100,000 = 12 percent.
- DSO, taking all revenue as credit sales over a 30 day month: 60,000 divided by 100,000 multiplied by 30 = 18 days.
- Cash runway: 90,000 divided by 15,000 = 6 months.
The numbers are simple. The work is in making sure revenue, cost of sales and receivables are recorded correctly and the same way each month. A runway figure also assumes burn stays where it is, so it is a reading of the past, not a forecast.
Which KPIs fit which industry#
The same pack format works across sectors, but the KPI page changes. These pairings follow the kinds of data each sector's books already hold:
| Industry | KPIs worth tracking from the ledger |
|---|---|
| E-commerce | Gross margin by sales channel, refunds as a share of sales, cost of goods sold |
| Nonprofits | Spend against budget by grant or fund, restricted and unrestricted balances |
| Construction and trades | Job profitability, retainage outstanding, work in progress |
| Real estate and property management | Profit and loss by property, receipts against rent roll |
| Restaurants and hospitality | Sales by category, food and beverage costs as a share of sales, delivery platform fees |
| Logistics and trucking | Profit by truck, fuel cost, factoring fees |
| Medical and dental practices | Collections by payer type, receivables against the practice system |
| Professional services | Receivables aging, revenue by client or service line, unbilled work |
Pick a few that matter to the owner. A KPI page with twenty measures is rarely read.
What can be handed to an offshore team#
An offshore team can prepare the pack: set up the templates against your chart of accounts, pull the figures, build the comparatives and budget-versus-actual, prepare the aging reports, and write a first-pass summary of notable changes. A Chartered Accountant reviews it before it is returned to you.
What stays with your firm or the business owner:
- Deciding which KPIs matter and what the targets are.
- Reading the pack with the client and explaining it.
- Advice on what to do about the numbers.
- Tax returns and tax positions.
- Forward-looking forecasts and financial modeling. This service covers budgets, historical statements and management reporting, not projections.
What to send#
- Access to the QuickBooks Online file as an accountant user.
- Your preferred layout, if the client already receives a report you want matched.
- The budget, if one exists, in whatever form you have it.
- The list of KPIs the owner cares about, or a note that you want a suggestion.
- The reporting schedule: monthly or quarterly.
What comes back#
- The monthly or quarterly pack described above, on the agreed schedule.
- Custom Excel reports where the client wants a specific format.
- A short management summary pointing out notable changes period over period.
- A list of any open items in the books that affect the numbers.
Review checks before the pack goes to your client#
| Check | What to look for |
|---|---|
| Balance sheet balances | Total assets equal liabilities plus equity |
| Cash agrees | Bank balance on the balance sheet equals the reconciled statement balance |
| Aging agrees | Aging totals equal the receivables and payables on the balance sheet |
| Comparatives | Prior period columns match the pack issued last time |
| Unusual movements | Each large variance has a one-line reason or an open question |
| KPI definitions | Formulas unchanged from last month, or the change is noted |
Frequently asked questions#
Can you build a report in the format our client already uses? Yes. Custom Excel reports are built to the format and KPIs the client's management asks for.
Do you produce forecasts? No. This service covers budgets, historical statements and management reporting, not forward-looking projections.
How often is the pack delivered? Monthly or quarterly, agreed in advance.
What if the books are not up to date? The books need to be brought current first. That is cleanup work, and it comes before reporting.
See the financial reporting and management reports service, the page for accounting and CPA firms and the industries we work with.
