My A/P age analysis does not match my accounts payable account in the trial balance, what could be the reason for this?

Thanks for reaching out here in the Community space today, Kerissa.

We can see the importance of this matter and want to ensure you can get through this situation. Before anything else, we'd like to take this opportunity to thank you for allowing us to help you with your concerns. It may have something to do with your filters and details added when running the report. That said, you'll want to review the data and ensure you've selected the correct report period, ageing method, and other details inside the data. We'll write down the steps to get you going:

1. Access your QuickBooks Online company.
2. On the left navigational bar, go to the Reports tab.
3. Open the A/P aging report, and click Customize.
4. Select Aging.
5. Under Aging Method, choose Report Date.
6. Once done, click the Run report button.

If the issue persists, you'll want to review your Trial balance report and ensure you've selected the correct reporting period and the accounting method. Know that results will differ depending on the accounting method that you've selected when running the trial balance. You can visit this page for more details: Choose between cash and accrual accounting methods in reports.

Moreover, we've got these articles to help you add more details to your business report, and learn how to create scheduled reports inside the program:

• Customise reports in QuickBooks Online.
• Set schedule and email information for a memorised report.

Kerrisa, don't hesitate to mention my name in the comment section if you need further assistance with this. You can also visit the Community space if you have any other questions related to QuickBooks. We're ready to help you right away. Take care, and have a nice day!

Thank you, But unfortunately this hasn't helped.

I have some information that I want to share so you'll know why this is happening, Kerissa.

Generally, the Accounts Payable Aging report is not going to match with the Trial balance. Like any other Accounts Payable Detail report, the Aging report doesn't include bills with a status of Paid. 

The Trial Balance pulls up from the General Ledger that will take into account all transactions to that specific account including manual Journal entries and posting from other accounts. Whereas the A/P Ageing or the Aged Accounts Payable report will pull only those invoices that are outstanding and are recorded in the A/P account.

You'll want to run other vendors' reports so you'll be able to get the data you need. Just make sure to customize them so it shows up the information on the different areas needed for your business. Here are the reports that are exclusively included with your subscription. Go through this article for more details: Reports Included In Your QuickBooks Online Subscription.

Please keep in touch if you have any questions when running reports. I'm always one post away if you need further assistance.

Hi,

Thank you for the assistance. However, I am not sure that I agree. On a transaction by transaction basis the A/P ageing will not match the ledger but the balance should. If the A/P ageing at a certain date says 10 000 is outstanding the balance sheet and trial balance should reflect that 10 000 is outstanding at the same date.