AP Aging Total Does Not Equal AP on Balance Sheet

I appreciate for sharing detailed information about your concern, cgendron.

I'll share some insights as to why they're not equal. There are a few factors this difference may happen:

• Balance Sheet is reporting on a Cash Basis, while AP Summary Reports always report on an Accrual Basis
• Date ranges are different. Note: All Dates settings will show transactions that are dated forward of the current date.
• Corruption in the company file.

To fix this, run the balance sheet report and set it on an accrual basis. 

1. Go to the Reports menu, select Company & Financial, and then Balance Sheet Summary.
2. Select Customize Report.
3. On the Display tab, select Accrual under Report Basis.
4. Select OK.

Once done, locate the date when the report went out of balance. You can refer to this article and proceed to the next steps provided: Fix the Balance Sheet that's out of balance.

I also added an article on personalizing your report to the data needed: Customize reports in QuickBooks Desktop.

Feel free to add any information if you need more help. I'll be happy to assist you.

I've explored the balance sheet accrual vs cash, and the options under current report date vs report date with no luck.

Is there anything I can do if it's corruption in the file causing an error? As far as I know, this is the only issue with the file. 

Thanks!

Hello @cgendron,

Thank you for sharing updates here in the Community about the steps you've taken to resolve the issue. I can help you check the company file for any corrupted components and data in QuickBooks Desktop.

Yes, there are troubleshooting steps you can perform to fix possible corrupted company files. We have tools within the program that can scan and self-resolve data issues.

Before you start, I suggest updating QuickBooks Desktop to the latest release. Aside from improving the software's performance, it also fixes common and complicated errors.

Here's how:

1. Click the Help tab in the upper-right corner, then select Update QuickBooks Desktop.
2. Go to the Update Now tab.
3. Select the updates you want to include.
4. Put a checkmark on the box beside Reset Update.
5. Hit Get Updates.
6. Close and re-open QuickBooks.

Once done, you can utilize the Verify Data and Verify Rebuild tools. These features in QuickBooks will help self-identify data issues within a company file and resolve them automatically using Rebuild Data. 

To run Verify Data:

1. Click the File tab at the top menu bar.
2. Hover your cursor to Utilities.
3. Select Verify Data.

Next, please run the Rebuild Data option through these steps:

1. Click the File tab at the top menu bar.
2. Hover your cursor to Utilities.
3. Select Verify Rebuild.

After performing the suggested solutions, restart your QuickBooks and compare your reports. Your reports should show using your accurate data within the company file.

Also, we have an add-on tool you can download to scan and fix different problems and errors within a file in QuickBooks. You can use this link to learn how to run and diagnose a company file for any unusual behavior: Fix common problems and errors with the QuickBooks Desktop Tool Hub.

Drop me a comment if the problem persists or if you need further assistance fixing the report. I'll be happy to help you some more. Take care.

May have something to do with a bill and applied payment in prior years that was entered after the vendor was checked inactive.  If there are active vendors with open credit in prior years, mark inactive and run AP aging.  Then make vendor active again and run AP aging. 

Might have something to do with a bill and applied payment entered after the vendor was made inactive.  Drill into open credit if any on AP aging. See if open balance on credit is the same as on AP Aging.  If not them make the vendor inactive and run AP aging.  Then make vendor active again and should correct.