Invoice paid but still on the vendor statement? How to find and fix it
How to find invoices you already paid in QuickBooks Online that a vendor still shows as open - using the Transaction List by Vendor - and what to send the vendor so they apply your payment.
It's one of the most common lines on a vendor statement: an invoice the vendor shows as open, that QuickBooks Online says you've already paid. Handle it wrong and you either pay it twice or keep getting reminders for money you don't owe.
Why it happens
- The payment is still in transit - a mailed check, or an ACH that hasn't posted on the vendor's side.
- The vendor applied it to another invoice, or holds it as unapplied cash on your account.
- A short or partial payment left part of the invoice open.
- A credit you used in QuickBooks Online (applied to bills) that the vendor hasn't applied yet.
How to find them in QuickBooks Online
- Run Reports → A/P Aging Detail as of the statement date. These are your open bills.
- Run Reports → Transaction List by Vendor with the report period set to All Dates. This is every bill and credit you ever entered for the vendor, paid or not.
- For each invoice on the statement that is not in your aging, look it up in the transaction list: - Found: it was entered and is no longer open in your books - it's been paid or credited. This is your "already paid" line. - Not found: it was never entered. Enter it, or ask the vendor for a copy first. - Older than the transaction list goes back: you can't tell from the report; look the bill up in QuickBooks Online directly.
The trap: a bill entered after you ran the aging
If you run the A/P Aging Detail in the morning, enter a few bills, and run the Transaction List by Vendor in the afternoon, those new bills are in the history but not in the aging - so they look paid when they're actually open.
- To avoid it: run both reports on the same day, one straight after the other.
- To spot it: payments usually clear the oldest bills first. If an "already paid" invoice is much newer than bills that are still open, check it in QuickBooks Online before you write to the vendor.
What to send the vendor
A short email with the payment details is usually all it takes:
| Invoice | Invoice amount | Paid on | Amount paid | Payment reference |
|---|---|---|---|---|
| 51200588 | 220.00 | 09/21/2026 | 220.00 | Check CHK-2201 |
(The figures are from a made-up example.) Ask the vendor to apply the payment and send an updated statement, and keep the email with your reconciliation. The payment date and reference are in QuickBooks Online - open the bill and look at its linked payment.
Credits work the same way
A vendor credit you have already used in your books, but which is still open on the vendor's statement, is the same problem from the other direction: ask the vendor to show the credit as applied, and tell them which bills it was used against.
Let Wefinly sort them for you
Upload the vendor's statement, your A/P Aging Detail and the Transaction List by Vendor to Wefinly. Invoices you already paid get their own list, separate from bills you never entered - with the payment quoted when your history shows it - and any line that looks entered late is marked Check first. It's free while in beta, and your files never leave your browser.
More on the other differences you'll meet: Why your A/P aging doesn't match the vendor statement.