We appreciate your effort in trying to resolve the incorrect balance on your Accounts Payable, @tam1946. I'm here to work with you on this to keep the account in order.
Running the Verify and Rebuild Utility Tools will help resolve common data integrity issues on your desktop.
Based on your scenario, I recommend viewing the Vendor Transaction Detail report to know what's causing the balance to appear erroneously. You can then manually fix the root cause transaction. Here's how:
- Open Reports, then choose Company & Financial.
- Click on Balance Sheet Standard.
- Hit Customize Report.
- Go to the Display tab, for Report Basis, and pick Cash.
- Remove the From date, keep the To date, and hit OK.
- To access the Transactions by Account report, double-click (QuickZoom) the A/P amount.
- Choose Customize Report.
- Go to the Display tab, remove the From date and keep the To date.
- Choose Advanced, choose the Open Balance / Aging Report Date option, and hit OK.
- Go to the Total by field, and select Vendor.
- Click the Filters tab:
- Go to the Filter list, and choose Account.
- Click on the Account drop-down and choose All Accounts Payable.
- For Include Split Detail then hit No.
- Go to the Filter list, choose Paid Status, select Open, and then hit OK.
- (Optional) Choose Memorize to save this report to use again.
- Each non-zero vendor subtotal affects the A/P balance.
I'd also recommend getting in touch with your accountant to know if there are other options you can do aside from creating journal entries to fix the balance.
Once everything is good, feel free to review this guide on how you can fix differences between the bank and QuickBooks balance: Reconcile an account in QuickBooks Desktop.
We're always here to assist you further with this matter or the software in general. Take the best care!
