Loading this page.
Loading this page.
Upload your purchase orders, your goods receipts and your invoice register (CSV each). F20 sorts every row of all three into one of seven states — matched three ways, received but not invoiced, invoiced but never received, received and invoiced with no order, or each document standing alone — and reports quantity and price variances separately.
Free three-way match: match purchase orders to goods receipts to invoices and name every document the other two do not account for. Upload the file this page names, review the result in the browser, and download CSV or Excel when offered.
Partitions all three documents' rows into seven exhaustive states — matched three ways, received not invoiced, invoiced not received, received and invoiced with no order, and each document standing alone — so every row lands in exactly one state and the state counts sum to the total row count, a completeness property enforced by tests rather than asserted in a comment. Quantity variance and price variance are reported separately, because an invoice that agrees on quantity but not unit price is a different exception from one that agrees on price but not quantity. A document with no counterpart is reported as unmeasured, never as matched, and variances are compared exactly rather than scaled by document size, so materiality stays the Controller's call.
It partitions purchase orders, goods receipts and invoices into seven states so every row lands in exactly one. Quantity variance and price variance are reported separately.
Open the page, drop the PO, the goods receipt and the invoice, and read the result in the browser. Download CSV or Excel when the tool offers those exports.
Yes. There is no charge and no account required. Every tool on F20 FinanceOps runs without signing in. A run made without an account is not recorded.
No. Uploaded files are processed in memory and dropped when the response is sent. Nothing is written to disk. They are never stored.
Have the purchase orders, the goods receipts and the invoices. Quantity variance and price variance are reported separately, so you do not need to pre-net them.
Work documents the other two do not account for, then hunt duplicate invoices if the same bill arrived twice. AP rec is the later step if payments vs open bills is the next question.
Three-way match is the AP control before you pay: PO, receipt, invoice, each row in exactly one of seven states. The partition is deterministic. It does not approve a payment.