Why your QuickBooks Online Balance Sheet doesn't match your other reports
In QuickBooks Online, a Balance Sheet figure that disagrees with another report is usually a matter of dates or report design, not damaged data. A deposit dated before the payment inside it, or a bill payment dated in the future, will each produce a difference that looks like an error. This page covers the discrepancies that come up most often, what each one means, and when a figure is actually wrong.
Why does Undeposited Funds show a negative balance?
Undeposited Funds is a holding account. Payments sit in it until the deposit that moves them to the bank is recorded. The account can show a negative balance when that deposit is dated earlier than the payment it contains.
Run the Balance Sheet for a date between the two. It shows the funds leaving on the deposit date before they arrive on the payment date, so the account dips below zero for that stretch of time. The data is intact; the dates simply overlap in an unusual order.
If the earlier deposit date was intentional, the report is describing your data correctly and nothing needs fixing. If it was a slip, open the payment and the deposit and correct the dates so the payment comes first.
Why does Accounts Payable differ from the A/P aging?
Both reports can be set to accrual basis and still disagree. The usual cause is a bill payment dated in the future.
The A/P aging and the Vendor Balance Detail report treat a bill as paid as soon as a payment exists, whatever that payment’s date is. A future-dated payment therefore removes the bill from those reports today. The Balance Sheet carries the liability until the payment date actually arrives, so the two figures part ways in the meantime.
To confirm the cause, run the Balance Sheet and the Vendor Balance Detail report with an as-of date about a year ahead. If the figures match at that date, a future-dated payment is the explanation, and the Balance Sheet was right all along.
A vendor report that matches the Balance Sheet
When you need a vendor report that lines up with the Balance Sheet exactly, customize the Vendor Balance Detail report. Set its report date to the Balance Sheet date, and set the aging method so transactions age as of the report date rather than the current date. With those two settings, the report counts the same bills the Balance Sheet counts.
The balance column on the vendor list can still differ, because it reflects each vendor’s position today rather than on your report date. The same future-dated payments explain most of those gaps.
Limits of the Balance Sheet by Class or Location
QuickBooks Online can break the Balance Sheet down by Class or by Location, and the report carries two limits worth knowing.
First, it filters by Class or Location but not by account. Excluding selected accounts would throw the report out of balance, so the option is not offered.
Second, the Accounts Receivable and Accounts Payable lines on the Class version can be wrong. Those balances come from invoices, payments, bills, and bill payments that do not always carry a class. The report attributes them correctly only when every related transaction is a general journal entry with a class on each line. Treat the A/R and A/P lines as approximate, and rely on the standard Balance Sheet for the figures that matter.
If the numbers still disagree
Before digging further, check the accounting basis in each report’s customization settings. A Balance Sheet run on cash basis beside a vendor report on accrual will never agree. Confirm the as-of dates match as well, since a single day’s difference changes what each report counts.
If basis and dates line up and a figure still cannot be explained, reproduce it in a second report before assuming data damage. Persistent unexplained differences in Accounts Payable or receivable are worth raising with Intuit’s support team, since the underlying records sit in Intuit’s systems.