Handled by Morning Book a free look

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.

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.

This sends your email address and nothing else. Nothing you put into the tool is sent.

Book a free look

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.