Account Payable Incorrect Open Items

Hi, Meghan. I know this feels overwhelming, but let's get your balance sheet corrected step by step.

A data rebuild can sometimes create or expose mislinked payments to bills, causing open items to show as unpaid even though they were actually paid. Because you’re seeing checks counted as unpaid bills going back to 2020, you most likely have a mix of paid bills that aren’t linked to their payments or payments that were misapplied.

To start resolving this, I recommend running an Accounts Payable Aging Report to identify any open bills that should have been paid.

1. Go to Reports and select Vendors & Payables.
2. Choose Accounts Payable Aging Detail.
3. Look for bills with dates and amounts that match the Bill Payment Checks and see if they align.

Next, generate a Transaction List by Vendor and filter it for Bill Payment – Checks. Confirm whether those checks correspond to any bills that are still showing as unpaid.

If QuickBooks has detached the link between the Bill Payment Checks and the related bills, you may need to manually re-link them.

1. Locate the affected Bill Payment Checks.
2. Open each Bill Payment Check.
3. If the check has no bills linked, you can delete and then recreate the payment, applying it to the correct bills.

If the issue persists even after these steps, I recommend contacting our live support team for further assistance. They have specialized tools to securely access your company file, review the affected transactions in detail, and help ensure your balances are corrected.

I’ll ensure this conversation remains open for any future updates and discussions.

I went back through my backup that was made prior to the data rebuild and discovered that over 100 invoices had just been deleted from my Quickbooks. I just had to manually re-enter them in my current QuickBooks and then apply them to the payments they were originally on. I have never had a data rebuild delete data before.