REPORTS & METRICS

Every report and key number MorningSync puts in Excel

Three Excel files, updated on their own, in your own folder. Here is exactly what is in each one, and what every number means.

14 days free · No card needed · Only reads your books

Three files, three jobs

Use the one you need, or all three. Each file updates on the schedule you pick.

Reports

P&L, balance sheet, trial balance, general ledger, and A/R and A/P aging, laid out the way QuickBooks exports them.

For: owners, bookkeepers and month-end packs.

Raw Data

Transactions (one row per line), customers, vendors and chart of accounts as flat tables.

For: anyone building pivots, Power Query or Power BI.

Metrics

Cash, margins, who owes you, what you owe, days to get paid and more, worked out from your QuickBooks data.

For: owners, CFOs and firms preparing client reviews.

Metrics for the period

These follow the dates and basis (accrual or cash) you pick for your P&L, so they always match your Reports file. Each one shows this period, the period before and the change, and a Trend sheet shows the last 14 months.

Revenue, gross profit, gross margin %: what you sold, what was left after direct costs, and that as a share of sales
Operating expenses, net income, net margin %: what was left after all costs
Revenue growth: change vs last month and vs the same month last year
Net cash flow and monthly burn: cash in minus cash out; burn shows only when it is negative
DSO: how many days, on average, customers take to pay you
DPO: how many days, on average, you take to pay suppliers
Top 10 customers by revenue, and their share of the total
Top 10 vendors by spend
Invoices: how many you issued, the average value, and % paid on time
Expenses by main category, each as a % of revenue

Metrics as of today

A snapshot of where things stand on the day of each sync.

Cash across all your bank accounts
Runway: how many months your cash lasts at your average burn over the last 3 months
Money owed to you: total, overdue, and by 0–30, 31–60, 61–90 and 90+ days
Money you owe: total, overdue, and by the same age bands
Current ratio, quick ratio, working capital: whether you can cover what is due soon

Open the real files

Three sample files built by MorningSync for an invented company, so every name and number is made up. Open them in Excel to see exactly what you would get.

Or one at a time: Reports · Raw Data · Metrics

Good to know

Every metric is labelled Period (covers a stretch of time, like revenue for September) or As of (a snapshot, like cash in the bank right now), so you always know which you are looking at.

See pricing →

Dates and basis

Go back up to 3 years. Accrual or cash. Columns by month, quarter or total. Leave the end date blank and each sync runs up to that day.

On every plan

Metrics are worked out from data MorningSync already reads, so they use no extra sync credits.

Only your data

Calculated inside MorningSync, saved only to your own folder, and never shared or compared with other clients.

Not built yet

No forecasts or budgets. Metrics are numbers in Excel, not charts, so you can build your own charts on top.

See your own numbers tomorrow morning

Plans from $35/month. Try any plan free for 14 days, no card needed.