A clear view of what doesn’t line up
Two files.
One exception list.
Compare invoice and payment exports by a shared identifier. Keep your existing spreadsheets. Save the setup for the next run.
01 / Set up the comparison
Choose your two exports
XLSX or comma-delimited CSV · up to 5 MB and 10,000 data rows per file. Header row first. For Excel, use a sheet with values rather than formulas.
Choose a file, or try the example.
Choose a file, or try the example.
Use a decimal point and up to four decimals; negative amounts and (parentheses) are supported. No currency conversion. Date, currency and method must be mapped on both sides or unused on both. Repeated IDs are review groups, never automatic matches.
Profiles save column names and settings in this browser, not transaction data. Private browsing or clearing site data removes them.
Your reconciliation review
Totals cover all readable input amounts, including exceptions. Invalid amounts are excluded and counted. A zero difference alone does not prove reconciliation.
| Reviewed | ID / result | Left records | Right records | What to check |
|---|
No groups match this view.
A saved review file contains the imported tables, filenames, configuration and review marks. Keep it private. Reloading clears transaction data unless you open that file again.
The useful boundary
Find the exception. Make the decision.
This compares exports; it does not update your books. Split payments, repeated invoice IDs, pooled settlements and uncertain records require your review. No guessed pairings, accounting entries or bank access.