PageFinderv4.2.11.22Sign in

Blog

Cross-checking invoices against payment records, without a week of lookups

A bookkeeper’s month-end at a freight company: three hundred invoices, many of them scans, one bank export, and the transposed digit that cost an hour. A composite case, and where an agent that reads the invoices fits.

November 22, 2026 · 7 min read · PageFinder team

Invoices (PDF, some scanned)INV-203112025-02-28 · $8,350INV-203772025-03-31 · $11,050INV-204182025-04-30 · $12,400DUEINV-204552025-05-15 · $4,900Payments-Q1.xlsxRefDateAmountINV-2031103-048,350INV-2037704-0211,050INV-2045505-204,900INV-2029002-102,2003 matched · 1 invoice unpaid · 1 payment with no invoice in the folder

A composite of situations we have seen while building a document tool; the names are invented. The numbers are the kind we see.

Dana keeps the books for a regional freight company: nine trucks, about forty regular suppliers, three hundred supplier invoices in a normal month. The invoices arrive every way an invoice can. Fuel and tyres come as proper PDFs from the suppliers' systems. The smaller suppliers — a tyre fitter, two garages, a pallet company — hand paper to the yard, and someone in the yard scans it on the office copier into a folder called Scans. A few arrive as photographs from a driver's phone.

The last Friday of the month, Dana answers one question for the owner: which invoices are still unpaid, and which payments went out with no invoice behind them. The bank export is a tidy table. The invoices are not a table at all.

Where the day goes

For the system-generated invoices, the number, date and amount can be copied from the PDF. For the scans, they have to be read off the page: a date stamp, a handwritten total, an invoice number that may be printed, stamped or missing. Dana's spreadsheet of invoices is typed, by her, one row at a time, and it takes most of the day before any matching happens.

The matching is the quick part — an XLOOKUP from invoices into the bank export and another back the other way — once the references on both sides have been cleaned, because the tyre fitter writes INV 20418 and the bank export says 20418/TYRE.

In April the reconciliation showed a missing payment of £1,240 to the pallet company. The supplier's statement said it was paid. It took Dana and the supplier's bookkeeper an hour on the phone to find the cause: a transposed digit when the invoice number was typed from the scan. Not the matching. The typing.

What she tried

Power Query, so the bank export refreshed itself each month: good, and it did nothing for the invoice side. Asking the yard to type the invoice details into a form when they scan: it lasted three weeks. A scanning app that reads invoices automatically: it was confident about the clean PDFs, which were never the problem, and guessed on the stamped ones, which were.

What Dana wanted was simple to say. "Read the invoices in that folder, every one of them, and give me the table." Then she would do the matching and the judgement, which she is good at and which take an hour.

Where we think a tool like ours helps

That sentence is almost exactly what you type into PageFinder. With the Invoices and Scans folders in the company's OneDrive connected read-only, and the bank export in the same place, the question is: Which invoices from April are unpaid, and for how much? Cross-check against Bank-April.xlsx. The agent finds the invoices, opens each one — the scans read from the page image — takes the number, date and amount off the page, reads the export as a table, matches them both ways, and answers with the unpaid invoices and the total. Each figure is cited to the page it came from, so the pallet company's £1,240 is one click from its invoice, and the matched table comes back as an Excel file with the trail of how each row was found.

It does not replace Dana. Partial payments, credit notes, one payment covering two invoices and a stamp that genuinely cannot be read still land in front of her as exceptions. The difference is that on the last Friday of the month the exceptions are the whole job, not the last hour of it, and the digit nobody typed cannot be transposed.

If your month-end looks like Dana's, try it on one month's folder: PageFinder for OneDrive.