Order vs payment reconciliation

Match the order table against the payment ledger by order number, flag unpaid / amount mismatch / duplicate payment / extra payment, then produce a monthly summary and export the reconciliation sheet. The table below is sample data (30 orders / 16 payments); you can upload your own CSVs.

Order total—

Received—

Unpaid—

Discrepancies—

Upload orders CSV Upload payments CSV

All

Unpaid

Amount mismatch

Over-paid

Cleared

Order no.	Date	Counterparty	Order amount	Payment amount	Difference	Status	Payments

Sample data only demonstrates the format and the rules; multiple tables, counterparty/month summaries and multi-sheet export are supported.

Data notes and boundaries
· Sample set: 30 orders + 16 payments, four discrepancy classes detected (unpaid / mismatch / duplicate / extra).
· Real use needs just two tables: an order export (no., date, counterparty, amount) and a payment ledger (no., amount).
· This is not bookkeeping: no bank or invoice integration, only reconciliation results and CSV output.