· 8 min read · AIStatements editorial
Comparative Balance Sheet: Example, Analysis and How to Run One in QuickBooks
Free demo pack used
Your one free pack is built. Starter keeps going: every close, every statement, the AI analysis on each pack, PDF and XLSX exports, for $39 a month billed yearly.
Generate statements from your own books · sample CSV
Software, not advice · Files parse in your browser, nothing is uploaded
Try it on a sample company, or upload your own CSV
A comparative balance sheet presents two or more period ends side by side, with a dollar-change and a percent-change column between them, so a static snapshot becomes a trend. It carries the same assets, liabilities and equity as a standard balance sheet; the comparison columns are the point. Public companies present two years of balance sheet data by SEC requirement, and private companies typically compare this month against last month or against the same month a year earlier.
A single-date balance sheet tells you where the business stands. A comparative one tells you what changed, which is usually the more useful question. Below is a worked two-year example, how to analyze the change columns, and how to run the report in QuickBooks Online and Desktop.
What does a comparative balance sheet look like?
Here is a two-year comparative balance sheet for a small distribution business, with the dollar change and percent change calculated on every line. Parentheses indicate a decrease. Both years foot: total liabilities and equity equals total assets in each column, which is the first thing to check before you read anything else.
| Line | 2025 | 2024 | $ change | % change |
|---|---|---|---|---|
| Cash | 148,200 | 96,500 | 51,700 | 53.6% |
| Accounts receivable | 214,600 | 168,300 | 46,300 | 27.5% |
| Inventory | 132,400 | 141,900 | (9,500) | (6.7%) |
| Prepaid expenses | 18,700 | 16,200 | 2,500 | 15.4% |
| Total current assets | 513,900 | 422,900 | 91,000 | 21.5% |
| Property and equipment, net | 286,500 | 310,800 | (24,300) | (7.8%) |
| Total assets | 800,400 | 733,700 | 66,700 | 9.1% |
| Accounts payable | 121,300 | 98,700 | 22,600 | 22.9% |
| Accrued liabilities | 34,800 | 31,500 | 3,300 | 10.5% |
| Current portion of long-term debt | 45,000 | 45,000 | 0 | 0.0% |
| Total current liabilities | 201,100 | 175,200 | 25,900 | 14.8% |
| Long-term debt | 172,500 | 217,500 | (45,000) | (20.7%) |
| Total liabilities | 373,600 | 392,700 | (19,100) | (4.9%) |
| Common stock | 50,000 | 50,000 | 0 | 0.0% |
| Retained earnings | 376,800 | 291,000 | 85,800 | 29.5% |
| Total equity | 426,800 | 341,000 | 85,800 | 25.2% |
| Total liabilities and equity | 800,400 | 733,700 | 66,700 | 9.1% |
Read that example and a story falls out of it in about thirty seconds. Cash is up 53.6 percent and long-term debt is down $45,000, so the business generated enough to fund a scheduled principal repayment and still build a cash cushion. Retained earnings grew $85,800, which is net income for the year less any distributions, so profitability was real. Property and equipment fell $24,300 with no offsetting addition, meaning the year's depreciation exceeded capital spending, which is fine for a year or two and becomes an aging asset base if it continues.
The line worth a question is receivables, up 27.5 percent. If sales grew by roughly that much, it is proportional and unremarkable. If sales grew 8 percent, then collections have slowed and roughly $30,000 of the year's revenue is sitting in customer hands rather than in the bank. That is the essential move in comparative analysis: no line means anything on its own, only against the line it should have moved with. Payables up 22.9 percent alongside inventory down 6.7 percent is the same kind of pairing, and it points at payment terms stretching rather than at buying more.
How do I run a comparative balance sheet in QuickBooks Online?
Open Reports, choose Balance Sheet Comparison, and QuickBooks shows current balances beside a prior period with dollar-change and percent-change columns already calculated. Alternatively, run the standard Balance Sheet and open the customize panel. Set the report date to the period end you want, then use the comparison options to add a previous period or previous year column. Turn on the change and percent-change columns so QuickBooks does the variance math for you. Run the report and each account shows the current balance, the comparison balance, the dollar difference and the percent difference side by side.
The comparison you choose changes the story. A previous-period comparison (this month versus last month) surfaces short-term swings; a previous-year comparison (this month versus the same month last year) strips out seasonality and shows the real trend. Pick the one that matches the question you are answering, and save the configured report as a custom report so you do not rebuild the settings each time.
How do I run it in QuickBooks Desktop?
In QuickBooks Desktop, go to Reports, then Company & Financial, and open the Balance Sheet Standard. Click Customize Report and, on the Display tab, check the boxes under previous period or previous year for the amount and the percent change. Desktop uses slightly different menu labels than QuickBooks Online, but the underlying report is the same: current balances beside a comparison column with the differences calculated.
Desktop also lets you column the balance sheet by month, quarter or year through the Display columns by setting, which turns a single report into a running comparison across several period ends at once. That view is useful for spotting a balance that has been drifting steadily rather than jumping in one period, such as inventory creeping up or a receivable balance that keeps growing.
Why doesn't my comparative balance sheet balance?
A balance sheet that does not balance almost always points to one of a few causes. The most common is the accounting method: switching between cash and accrual changes which transactions are recognized, and a comparison that mixes methods across the two columns will look off. Next is the date range, where a comparison period set to the wrong end date pulls balances that do not correspond. Then there are the data problems: an unreconciled bank account, a journal entry posted to only one side, or transactions dated outside the period you think you are viewing.
Payables and receivables are frequent culprits in the change columns. If a large share of your bills arrives as PDF invoices that get entered by hand, a miskeyed date or amount lands the liability in the wrong period and the accounts-payable line jumps for no real reason. Converting those invoices into a clean spreadsheet before posting cuts the data-entry errors that distort the period-over-period comparison. Reconcile every account before you trust the report, and most phantom swings disappear. The faster way to find the culprit is usually to run a QuickBooks trial balance at each of the two dates, because every account and its balance sits on one page there rather than inside collapsed balance sheet subtotals.
How do you analyze a comparative balance sheet?
Read the percent-change column first, then explain the dollars. A line that moved sharply against the comparison period is either a real event or an error, and the comparative format exists to make you ask which. Rising receivables against flat sales can mean collections are slowing. Growing payables can mean cash is tight or simply that a big bill posted late. Equity should move by net income less any distributions, so if it moved by something else, a posting went where it should not have.
The point of the comparison is to turn a static snapshot into a trend you can act on. For the full read of what each section means, our guide on how to read a balance sheet covers assets, liabilities and equity in depth, and the QuickBooks balance sheet versus profit and loss explains how the two reports connect through net income.
| Option | Where | What it shows |
|---|---|---|
| Balance Sheet Comparison | QBO Reports | Current vs prior period, ready-made |
| Previous period / year columns | Customize panel | Adds comparison + change columns |
| % change | Customize panel | Each line as a percent difference |
| Display columns by (Desktop) | Customize report | Multiple period ends side by side |
| Accounting method | Customize panel | Cash vs accrual placement |
Turning the comparison into a pack you can send
A comparative balance sheet is great for review on screen, but a lender, investor or board usually wants the full pack: the balance sheet alongside a P&L and cash flow, formatted and explained. QuickBooks runs each report separately and leaves the assembly and the written commentary to you. Our guide to the QuickBooks balance sheet covers the single report in depth, and running all three QuickBooks financial statements shows how they tie together.
To skip the manual assembly, connect QuickBooks to the balance sheet generator. It pulls the ledger and returns all three statements formatted, footed, tied and analyzed in plain English in about a minute, including the period-over-period changes worth flagging, so you review a finished document instead of stitching comparison columns into a report by hand.
One honest note: this is a how-to guide, not accounting or tax advice. For statements you file or hand to a lender, have a licensed professional review them first.