QuickBooks HelpQuickBooksHelpIntuit

About Balance Sheet and Accounts Payable Ageing report disagreement

SOLVEDby QuickBooks1Updated March 20, 2023

Disagreement between your Balance Sheet and your Accounts Payable Ageing report could be the result of future payments made against current bills.

The Accounts Payable Ageing report, like other Accounts Payable Detail reports, doesn't include bills with a status of Paid, so, while they may seem to disagree, both the Balance Sheet and the Accounts Payable Ageing Detail reports are correct because the bill is no longer open.

If necessary, you can generate a Supplier Balance report that agrees with the Balance Sheet. To do this, customise the Supplier Balance report to run as of the date on the Balance Sheet, and change its Ageing method to Report Date.

Alternatively, you can customise the Accounts Payable Ageing report to the As of Report Date. The report will then agree with the Balance Sheet as long as the Balance Sheet follows the accrual reporting method for the same date range.

For more information: Follow these steps to match mismatched Ageing Reports in QuickBooks Online.

Was this helpful?

You must sign in to vote, reply, or post
QuickBooks Online EssentialsQuickBooks Online PlusQuickBooks Online Simple Start

Sign in for the best experience

Ask questions, get answers, and join our large community of QuickBooks users.

More like this