How it works
Aggregate signed amounts by exact reference on each side; list each reference with its two totals and difference.
Input definitions
- First ledger: CSV reference,signed amount
- Plain text; maximum 200,000 characters.
- Second ledger: CSV reference,signed amount
- Plain text; maximum 200,000 characters.
A worked example
- First ledger: CSV reference,signed amount
- reference,amount A,100 B,50
- Second ledger: CSV reference,signed amount
- reference,amount A,100 B,40 C,20
Assumptions & limits
Up to 1,000 input rows per table. Exact case-sensitive references; no fuzzy matching or automatic bank access.
Sources & review
Maintained by AnsRio. Methods and examples use automated checks; this does not imply independent professional certification.
Method updated 2026-10-17. Content checked against the stated method and examples. Our verification approach.
Common questions
Can duplicate references be reconciled?
Yes. Amounts with the same exact reference are summed on each side. Equal aggregate totals may still hide different underlying transactions, so inspect originals.
How does Reconcile two ledgers by reference work?
Aggregate signed amounts by exact reference on each side; list each reference with its two totals and difference.
What are the limits of Reconcile two ledgers by reference?
Up to 1,000 input rows per table. Exact case-sensitive references; no fuzzy matching or automatic bank access.
How do I keep the full worksheet?
Run the tool and choose Download file. The on-page table is a preview and may show only the first 20 rows; the downloaded file contains the full result. CSV downloads escape spreadsheet formula prefixes. Inputs and files are processed on your device.