Reconcile two lists
A bank statement and the general ledger, a customer file and the CRM export: each row looks for its row in the other list, by a shared reference or, failing that, by amount and the closest date. What remains are the differences, to review one by one.
What this tool does
- By reference (invoice or document number) or by amount and date, with a tolerance in days.
- An amount tolerance, and reversed signs from one list to the other (debit and credit).
- Each row is used only once: two payments of the same amount do not match the same receipt.
- Both lists' totals and their difference; a workbook with one sheet per category.
What it does not do: Matching by amount does not know that one 300 payment covers three of 100: groupings are still done by hand. Differences are shown, not corrected.
No file is uploaded. Turn off your network once this page has loaded: the tool keeps working. How to check it yourself.
Other tools
- Merge Excel files : Files and sheets in a single table, even when the columns are not in the same order.
- Look up between two files : VLOOKUP between files, without a formula, and the list of what found nothing.
- Split a file : One file per branch, per sales rep, or per batch of rows, header repeated.
- Compare two Excel files : Two versions of the same table: added rows, removed rows, changed cells.
- Workbook health check : Size, phantom rows, styles, links, errors, hidden content: all of it, with one-click fixes.