QuickBooks Comparative Balance Sheet: How to Run and Read It

To run a comparative balance sheet in QuickBooks, open Reports, choose Balance Sheet Comparison (or run the standard Balance Sheet and set Display columns by to a comparison period), and QuickBooks shows the current balances beside a prior period with dollar-change and percent-change columns. In QuickBooks Online use the Balance Sheet Comparison report; in QuickBooks Desktop customize the Balance Sheet and check the previous-period or previous-year comparison boxes. It is the fastest way to see how assets, liabilities and equity moved between two dates.

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 how to run it in both QuickBooks versions, how to read the change columns, and the settings that make the report tie out.

How do I run a comparative balance sheet in QuickBooks Online?

Open Reports from the left menu and search for Balance Sheet Comparison, or 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.

How do I read the change columns?

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.

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.