Check your supplier bills
Add your purchase orders and supplier bills. Add your receiving log too, to catch things you paid for but never got.
Add your purchase orders and supplier bills to start.
| Supplier | Issues | Bills affected | To recover | Recovered |
|---|
Getting your files out of your system
Purchase orders
Most accounting and inventory systems have a purchase order report or list. Include the line items (PO number, supplier, item, quantity and price), then export it to Excel or CSV.
Supplier bills
Use a bill or invoice detail report with one row per line item. If the PO number is on the bill, include it; it makes matching far more reliable.
Receiving log
Optional. Any list of what arrived per PO and item works, from your system or a spreadsheet you keep at the back door.
Columns can have any names and be in any order. BillMatch works out which is which, and you can adjust it. Works with .xlsx, .csv and .txt files up to 15 MB.