Two Lists That Should Agree, and the Reasons They Do Not RECONCILE
A lookup formula finds the exact matches and silently leaves out everything interesting, because the interesting cases are the near misses: right reference and wrong amount, or one payment covering three invoices.
The two lists
Where it landed
The exceptions
The output that matters: the short list a person has to look at, with the reason each one is on it.
How it matched
In passes, hardest evidence first, so a pairing found on a reference is never overwritten later by a coincidence of amount.
The report
Questions people ask about RECONCILE
Related tools
- LEDGERA cash book that adds up, with the summary an accountant wants
- INVOICESBill people without telling a service
- SPLITCut a CSV about without a spreadsheet
- FIGURESDescribe a column of numbers honestly
- SETTLEWho owes whom, in as few payments as possible
- CASHFLOWWhen the money runs out, and what breaks it