Check supplier bills against what you ordered and received
A three-way match compares each supplier bill with the purchase order and the receipt before you pay it. Drop in the three lists and see every line that does not agree, with the amount to question. It is free, there is no sign-up, and your files never leave this page.
1. Purchase orders
What you ordered: PO number, item, quantity and price.
2. Receipts
What arrived: PO number, item and quantity received. Leave it out to check bills against orders only.
3. Supplier bills
What you were charged: bill number, PO number, item, quantity and price.
The check runs as soon as the purchase orders and the bills are in. Each file is a CSV or Excel list with a row of headings and one row for each line.
- The files are opened by your browser and are not uploaded or stored anywhere.
- The page counts visits and nothing more. It does not record your screen or what is in your files.
- Close the tab and the numbers are gone.
Lines to look at
Choose a line to see the numbers behind it. Lines with no amount are notes, not money at risk.
Who to ask
Received, not billed yet
Goods that arrived with no bill so far. Expect these bills, and count them if you are closing the month.
Columns used
If a result looks wrong, check that each item points at the right column in your file.
How it is worked out
Lines are paired by purchase order number and item. A bill line is questioned when it charges for more than was received, charges a higher price than the purchase order by more than the difference you allow, points at a purchase order or item that is not in your file, or repeats a line already on the same bill. These are plain comparisons on your files. No AI is involved, and nothing is estimated.
Made with the free three-way match checker at handledbymorning.com/three-way-match
Want every bill checked before it is paid?
I connect your purchasing and accounting systems read-only and send one page each morning: the bills that do not match, what they add up to, and who to ask. A free 30-minute look shows what your systems could answer today.
What a three-way match is
Before a supplier bill is paid, three records should agree: the purchase order says what you asked for and at what price, the receipt says what arrived, and the bill says what you are being charged. A three-way match in accounts payable is the check that they do.
When they agree, the bill is clear to pay. When they do not, somebody asks the supplier before the money leaves. A two-way match skips the receipt and compares the bill with the purchase order only, which is common for services.
What it catches
- A higher price than you agreed. The bill charges more for each unit than the purchase order.
- More billed than received. You are charged for 40 and 32 arrived, or nothing arrived at all.
- No purchase order behind the bill. The PO number is missing, is not in your records, or does not list that item.
- The same line billed twice. A line repeated on one bill.
- Goods received with no bill yet. Not a problem to chase, but a cost to expect.
Questions
Are my files uploaded?
No. The page reads the files inside your browser and never sends them anywhere.
What do the files need to contain?
One row for each line, with a heading row. Purchase orders need a PO number, a quantity and a price or line total. Receipts need a PO number and a quantity received. Bills need a quantity and a price or line total, and a PO number where there is one. An item or description column in all of them lets the check run line by line; without it, quantities are added up for each purchase order.
Do PO numbers have to be written the same way?
No. PO-0100, PO 100 and 100 are treated as the same purchase order. Item names do need to match, apart from capital letters and extra spaces.
What is a price tolerance?
A small difference you are willing to let through without a question, so that rounding does not flag every line. The tool starts at 1% and you can set it to none, 2% or 5%.
What about partial deliveries?
They work. Receipts and bills for the same purchase order line are added up, so a bill for the part that arrived matches, and the part still to come is left alone.
Who made this?
Handled by Morning sets up private reporting and AI on a company's own books for businesses of about 10 to 100 people. This tool is a small, free piece of that work, like the aging report.