Is this month better or worse than last month?
The simplest trend question. But answering it properly means comparing more than just revenue. Here's how to do a real month-over-month comparison.
The short answer
Better or worse? Compare five things: revenue, net income, cash position, pipeline value, and new leads. If three or more improved, the month was better. If three or more declined, it was worse. Revenue alone does not tell the whole story.
Revenue can go up while everything else gets worse
Revenue was $95K this month, up from $88K last month. Feels like progress. But expenses also jumped from $80K to $89K. Net income dropped from $8K to $6K. Cash reserves fell. Three invoices are now overdue. And your pipeline has fewer deals than last month.
If you only look at revenue, this month was better. If you look at the full picture, this month was worse. The business made more money and kept less of it, burned through cash, and has a weaker outlook for next month.
A proper month-over-month comparison requires looking at multiple dimensions. It takes more time, but it gives you a real answer instead of a misleading one.
How to compare this month to last month properly
- 1Compare revenue and net income
In QuickBooks, run Profit and Lossfor this month and last month. Compare Total Income and Net Income. In Xero, use the built-in “Compare with: Previous Period” option.
- 2Compare cash position
In QuickBooks, run Balance Sheet for today and for the same day last month. Compare Total Bank Accounts. In Xero, check the Balance Sheet report for both dates. Did cash go up or down?
- 3Compare pipeline value
In your CRM, check the total value of open deals this month vs. last month. In HubSpot, go to Sales → Deals and note the pipeline total. A shrinking pipeline today means less revenue next month.
- 4Compare new leads
In your CRM, count leads created this month vs. last month. Fewer new leads today means a weaker pipeline in 30-60 days.
- 5Score the month
Count how many of the five metrics improved. Three or more means the month was better overall. Two or fewer means it was worse. This gives you a balanced view instead of reacting to one number.
Total time: about 20 minutes. You need your accounting software and CRM. The comparison is simple but requires pulling data from multiple places.
Do this comparison on the first of every month
Make it a habit. First of the month, 20 minutes, five metrics. Over time you will start to see patterns: which metrics tend to move together, which ones are leading indicators, and what a “real improvement” looks like versus a one-time spike.
Or see the full comparison automatically every month
Bottomline compares all five dimensions every month and gives you a single summary at the top of your report. Better, same, or worse, backed by the specific numbers that changed.
One glance tells you whether the month was genuinely better. No cherry-picking one metric. No false comfort from revenue alone. Just a balanced scorecard built from your real data.