Why do mismatched invoices and POs still require manual review?
Three-way matching rules and difference tolerances frequently trigger discrepancies where received quantities do not match vendor bills. This forces accounts payable teams to manually cross-reference purchase orders, invoices, and payment applications across multiple pages, eating up hours of their morning.
What people tried
Every workaround mentioned in the threads below. We haven’t tested any of them — and nobody here is claiming they worked.
- 1Hiring people to manually review, adjust, and approve transactions when automation fails due to discrepancies.
- 2Manually searching for each invoice across the system
- 3Exporting remittance and invoice data into Excel and using VLOOKUP to cross-reference
- 4Using an ERP or AR automation tool with bank feeds to auto-match clean hits and flag exceptions
In their words
Unedited, grouped by where they were said, most upvoted first within each place, each linked to the thread it came from.
“At my company, I have to manually go from the remittance > PO > invoice > payment application, and I'm wondering how common that workflow is.”source ↗
“Manually matching across three levels sounds like a recipe for a headache, especially when you've got a stack of them to get through. We were doing the same song and dance until about a year ago, it eats up so much of the morning”source ↗
“Its more when I get the ones that are several pages long and i have multiple in queue.”source ↗
“Because they still need to review and approve the transactions, especially when the use case involves more complex conditions such as three-way matching and difference tolerances.”source ↗
“transactions with discrepancies such as when the quantity received does not match the quantity on the vendor bill then still require the AP team to review, make the necessary adjustments, and approve the transaction before it can proceed.”source ↗
Where this came up
People with this problem also raised
- 2How do you audit 3PL invoices with endless line item codes?
- 7How to get a vendor to actually fix a billing error
- 5How to fix journal entries moving income to expense accounts
- 2Why do I have to type the same invoice into multiple systems?
- 4Why do invoice automation tools fail on minor text mismatches?
- 11Why is QuickBooks still taking credit card fees from my bank account?