Find vendor invoices missing from QuickBooks

Disclosure: Bloombilt makes Operations, which does the check in this post automatically. The manual method comes first and works without it.

The short answer

Make a list of every vendor invoice you received for a period. Export every bill QuickBooks Online has for the same period. Match the two on vendor and invoice number. Whatever’s left over is your answer:

On your list but not in QuickBooks: never entered.
In QuickBooks two times: entered twice.
On both, with different amounts: entered with a different total.

The first pass is slow. It’s worth doing, because each of these costs real money. A missed invoice turns into a late fee or a supplier who stops shipping. A duplicate gets paid twice. A wrong total means your books are off and nobody knows why.

Why invoices go missing in the first place

Invoice data entry is the weak spot. Invoices arrive in someone’s inbox, a shared AP inbox, a vendor portal, or the truck’s glovebox. Somebody types each one into QuickBooks as a bill. That person goes on vacation, an email gets read on a phone and marked done, a vendor sends the same invoice twice as a reminder, or a credit gets entered once by the office and once by the bookkeeper.

None of that shows up in QuickBooks, because QuickBooks only knows about what was entered. You find out when a vendor calls about an overdue balance.

Step 1: List what you actually received

Pick a period. A month is a good start. Then build a spreadsheet with one row per invoice and four columns: vendor, invoice number, invoice date, and total.

Pull the rows from wherever invoices arrive. Search the AP inbox for the month. Check vendor portals you log into. Gather the paper.

The most reliable source is the vendor. Ask your bigger suppliers for a statement of account for the period. A statement lists every invoice and credit they think you owe, so it catches invoices that never reached your inbox at all.

Step 2: Export what QuickBooks has

QuickBooks Online lists its standard reports in Intuit’s report guide, checked November 8, 2026. Three of them do this job.

Transaction List by Vendor (under “Expenses and vendors”) is the one to export. Every transaction, grouped by vendor. In an Intuit community answer, checked the same day, a community moderator walks through narrowing it to bills. Open the report, switch to classic view, choose Customize, and set the Transaction Type filter to Bill. Add Vendor Credit too if you want credits in the same sheet. Set the report period to Custom and enter your dates.

Make sure the No. column (the bill number) is showing, then use Export and choose Export to Excel. Intuit’s help article on vendor totals covers the report period and export menus.

Vendor Balance Detail (under “What you owe”) shows each vendor’s open bills and running balance. That’s the report to hold up against a vendor’s statement.

Unpaid Bills (also under “What you owe”) is useful for one specific check: a bill showing as unpaid that you know you paid can be a duplicate of the one that was paid.

One plan note. Bills and these payables reports need a QuickBooks plan that includes bills, and Intuit’s pages don’t agree on whether Simple Start does. The Simple Start page says Essentials “adds the ability to manage bills,” while the Bill Pay page says “All QuickBooks Online plans come with basic bill management features.” Both checked November 8, 2026. If you’re on Simple Start and can’t find these reports, that’s why.

Step 3: Match the two lists

Paste the QuickBooks export next to your received list. Make a key column on both sheets by joining the vendor name and the invoice number. Then use a lookup (XLOOKUP in Excel, or VLOOKUP) from each list into the other.

Never entered. Rows on your received list with no match in QuickBooks. Sort them by invoice date. The old ones are the urgent ones, because their due dates have probably passed.

Entered twice. Count each key in the QuickBooks sheet (COUNTIF does it). Anything above one is a duplicate. Then look for the duplicates the key misses: the same vendor, same amount and same date with two different bill numbers. That’s usually one invoice typed in twice, once with a typo in the number. Credits get duplicated the same way, and a doubled credit is easy to miss because it makes the vendor’s balance look smaller, not bigger.

Different total. Rows that match on the key but not on the amount. Some are typos. Some are an invoice entered from the order confirmation instead of the final invoice, or a freight charge that got left off.

Step 4: Check balances against vendor statements

For each vendor that sent a statement, put the statement’s closing balance next to that vendor’s balance on the Vendor Balance Detail report as of the same date. If they match, move on. If they don’t, the difference is made of the rows from step 3, plus any payment one side has recorded and the other hasn’t.

That’s vendor invoice reconciliation in the plain sense. Your record of what you owe goes up against theirs.

Turn on the duplicate warning

QuickBooks Online can warn you when someone enters a bill number that’s already been used for the same vendor. Intuit’s community answers put the setting under the gear icon, then Account and Settings, then Advanced, then Other preferences. One thread, checked November 8, 2026, names it “Warn me when I enter a bill number that’s already been used for that vendor.” It’s a warning, not a block, and it only compares bill numbers for the same vendor. A typo in the number, or the same invoice entered under two vendor names, gets through.

Intuit’s Bill Pay page also lists “flagging duplicate bills” among its fraud protections, checked the same day. The page doesn’t say how it decides two bills are the same, so don’t treat it as a substitute for the match above.

How often to do it

Once a month, before you close the books, while the vendor still remembers the invoice. The first time, go back as far as your oldest open vendor balance, vendor by vendor, starting with the ones you spend the most with.

What automating it looks like

The manual method has one flaw. It depends on step 1, and step 1 is the same person, reading the same inbox, that let the invoices go missing.

Invoice reconciliation software takes that part away. The invoices arrive somewhere a system can read every one, and the system does the matching instead of a person with two spreadsheets.

That’s what Bloombilt Operations does for accounts payable. Vendors keep emailing invoices to the address they use now, and you forward that address. Operations reads the bills already in QuickBooks and shows you which invoices were never entered, which were entered twice, and which went in with a different total. It can start that way, read-only, before it writes anything to your books.

The first time we ran it for a customer, it found 54 invoices that had never been entered, most of them more than a week late, and vendor credits that had been entered twice.

From there it can do the entry too. Every price is checked against the vendor’s list or what they charged last time, a price increase gets flagged, and the bill goes into QuickBooks Online once someone signs off. Whoever you name gets an email or a text when an invoice needs them.

If you’d rather compare it with capture tools like Dext or bill pay tools like BILL first, we wrote up how to stop typing vendor bills into QuickBooks Online. Or book a call and we’ll start with the read-only check on your own books.