MorningSync

QUICKBOOKS ONLINE KPIs IN EXCEL

Your QuickBooks Online KPIs in Excel, worked out every morning

MorningSync reads your QuickBooks Online company and keeps a Metrics file in your own folder: cash, margins, who owes you, what you owe, days to get paid and more. No formulas to build, no reports to export.

14 days free · No card needed · Only reads your books
Your Excel files
Synced 6:00 AM · next 7:00 AM
XLSX
Reports
P&L, balance sheet, trial balance and aging, laid out like QuickBooks
XLSX
Raw Data
Transactions, customers, vendors and accounts as flat tables
XLSX
MetricsExample numbers
Your key numbers, worked out for you
Cash
$84,200
Gross margin
62%
Overdue receivables
$12,400
Days to get paid
38

Why QuickBooks KPIs usually end up in a spreadsheet

QuickBooks Online has the raw numbers, but most of the ratios people check every month aren’t one report away.

Ratios need several reports

Days to get paid needs the A/R aging and the P&L side by side. Runway needs bank balances and three months of cash flow.

So someone copies and pastes

Export four reports, paste them into a workbook, fix the formulas when a column moves. Every month, for every company.

MorningSync does that part

The answers land in an Excel file in your own folder, worked out the same way every time, where you already work.

What's in the Metrics file

For the period, following the dates and basis you pick for your P&L. Each metric shows this period, the period before and the change, and a Trend sheet shows the last 14 months.

Every metric with a plain-words definition →

And as of today

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

How it works

Set up once in about three minutes. After that, there’s nothing to remember.

1

Connect QuickBooks

Sign in on Intuit’s own page. MorningSync only reads; it never creates, edits or deletes anything in your books.

2

Pick your dates

A ready-made period or your own, up to 3 years back, accrual or cash.

3

Open the Metrics file

It updates hourly, daily or weekly in your SharePoint folder, with your Reports and Raw Data files alongside it.

For firms, and what it costs

The same numbers for every client, and no surprise charges.

Built for firms

On Firm 25 and Firm 75, every client gets their own Metrics file, worked out the same way, so a monthly review starts with the numbers done. For accounting firms →

On every plan

Metrics come with every plan, from $35/month, and use no extra sync credits. Compare plans →

Your data stays yours

Worked out inside MorningSync, saved only to your own folder, never shared or compared with other clients. Security →

Common questions

No. It’s an Excel file with the numbers in rows and columns. Build your own charts on top if you want them.

No. MorningSync only reads. It never creates, edits or deletes anything in your books.

Yes. Each metric lists how it’s worked out (for example, DSO = accounts receivable today ÷ revenue for the period × days in the period), and your Reports file has the P&L, balance sheet and aging it comes from.

Not today. It reports what’s in your books.

QuickBooks Online Simple Start, Essentials, Plus and Advanced. QuickBooks Desktop isn’t supported.

See your own KPIs tomorrow morning

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