MorningSync

PROFIT AND LOSS REPORT

Your QuickBooks Profit and Loss in Excel, fresh every morning

MorningSync reads your P&L from QuickBooks Online and lays it out the way you’d build it yourself: this month against last month and last year, the last 12 months side by side, and year to date. No exports, no copy and paste.

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

What the P&L looks like

From the sample Management Report. Every name and number belongs to the invented Larkspur Design Co.

Profit and Loss
Larkspur Design Co. · Nov 2026 (to 21 Nov)
Nov 2026 (to 21 Nov)Oct 2026Nov 2025Year to date 2026 (to 21 Nov)
INCOME
Consulting10,4677,8449,17492,673
Design Services48,61853,07929,189485,271
Product Sales7,8496,5572,47545,853
Total income66,93467,48040,838623,796
COST OF SALES
Printing and Materials5,7185,1873,36650,154
Subcontractors9,88810,3575,04584,492
Total cost of sales15,60615,5448,411134,646
Gross profit51,32851,93632,428489,150
EXPENSES
Advertising and Marketing2,0181,5861,18921,336
Bank Fees03535350

P&L
This month against last month, the same month last year and year to date, with % of revenue

Profit and Loss by Month
Larkspur Design Co. · Dec 2025 to Nov 2026 (to 21 Nov)
Aug 2026Sep 2026Oct 2026Nov 2026 (to 21 Nov)Total
INCOME
Consulting4,79414,2777,84410,46797,697
Design Services37,58454,13053,07948,618527,056
Product Sales2,5434,0136,5577,84946,263
Total income44,92072,42067,48066,934671,016
COST OF SALES
Printing and Materials4,3165,2365,1875,71854,711
Subcontractors6,6688,94810,3579,88889,581
Total cost of sales10,98414,18415,54415,606144,292
Gross profit33,93558,23651,93651,328526,724
EXPENSES
Advertising and Marketing2,1002,7881,5862,01823,450
Bank Fees3535350385

P&L by Month
The last 12 months side by side, with a total and % of revenue

Four ways to use your P&L

The same numbers, laid out for the job in hand. All of them update on your sync schedule.

Management Report: P&L

This month, last month, the same month last year and year to date, each with the change. Ready to read, print or send.

For: month-end review

Management Report: P&L by Month

Every income and expense line for the last 12 months, a total and each line as a % of revenue.

For: spotting trends

Raw Data: QBO_PnL

The QuickBooks P&L as a flat table, by month, with each line’s level and type. Point pivots, Power Query or your own model at it.

For: building your own reports

Reports page in your portal

P&L by month, against last year, as % of revenue, or by class or location. Pick the period and filters, then export to Excel, CSV or PDF.

For: quick answers and one-off exports

Your dates, your basis

Set it once in your portal. Every sync rebuilds the P&L for those settings.

Questions about the P&L

Yes. MorningSync reads the Profit and Loss report from QuickBooks Online for the same dates and basis, so the totals match what QuickBooks shows.

Yes. The Management Report keeps the sheets and formulas you add. Raw Data’s QBO_ sheets are replaced on every sync, so build on top of them in your own sheets.

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

As fresh as your last sync: daily or weekly on every plan, hourly on Plus or with the hourly add-on. You can also press Refresh now a few times a day.

Comparing tools? Read our QuickBooks reporting software buyer's guide.

See your own P&L in Excel tomorrow morning

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