Bank Transaction Reconciliation

Find and review bank-to-ledger candidates by exact amounts, dates and references, including split payments.

On-device No sign-up Free to use

Reconcile transactions controls

Showing an example. Edit to see your own.

?

Paste UTF-8 CSV with headers, or choose a file below. Up to 2 MiB.

Drop your CSV file here

or choose one from your device

One file · CSV and TSV only

    ?

    Paste UTF-8 CSV with headers, or choose a file below. Up to 2 MiB.

    Drop your CSV file here

    or choose one from your device

    One file · CSV and TSV only

      ?

      ?

      ?

      Download the review template and fill accept or reject, then paste it here. Keep the complete candidate ID, including its input hash. Blank decisions remain proposed.

      Processed in your browser. Your inputs stay on this device.

      Result

      Showing an example.

      A 100.00 bank transaction proposes a match with ledger rows of 60.00 and 40.00.

      One proposed candidate beginning C1- links bank B1 (100.00) to ledger L1 + L2 (60.00 + 40.00), difference 0.00. All three transactions remain unresolved until its complete input-bound ID is accepted.

      Loading the tool. Your result will appear here.

      https://usefreetools.net/bank-transaction-reconciliation · 20 November 2026

      Was this helpful?

      How to use Bank Transaction Reconciliation

      1. Paste or upload bank and ledger CSVs with id, date, amount and reference columns. Use one currency and a consistent signed-amount convention.
      2. Choose date and amount tolerances and the maximum number of transactions in a split, then run the comparison.
      3. Inspect the candidates and download the review-decisions CSV template. Enter accept or reject beside each complete candidate ID you have reviewed.
      4. Paste the completed CSV into Reviewed decisions CSV and run again with the same data and settings. Download the reviewed matches and unresolved transaction IDs.

      Example: Bank Transaction Reconciliation

      A 100.00 bank transaction proposes a match with ledger rows of 60.00 and 40.00.

      You add
      Bank transactions: id,date,amount,reference B1,2026-01-05,100.00,invoice-1 Ledger transactions: id,date,amount,reference L1,2026-01-05,60.00,invoice-1 L2,2026-01-06,40.00,invoice-1 Date tolerance in calendar days: 3 Amount tolerance in one currency: 0 Maximum transactions in a split: 2
      You get
      One proposed candidate beginning C1- links bank B1 (100.00) to ledger L1 + L2 (60.00 + 40.00), difference 0.00. All three transactions remain unresolved until its complete input-bound ID is accepted.

      Supported inputs and limits

      • Two CSV inputs, each up to 2 MiB and 80 rows.
      • Amounts have at most two decimal places; use one currency and one signed-amount convention.
      • Dates are YYYY-MM-DD from 1900 through 2200.
      • Search is limited to 150,000 combinations and 2,000 candidates.
      • One transaction may match up to three on the other side; many-to-many search is unsupported.
      More details

      Only accepted non-overlapping decisions resolve rows.

      Changing data or options requires fresh review IDs.

      Where your input is processed

      This tool does not upload your inputs. See the limits for anything saved on your device.

      Questions about Bank Transaction Reconciliation

      Will suggested matches clear my unresolved list?

      Only an explicit accept decision clears the linked transactions in this report. A matching total or reference is evidence to review, not permission to alter the ledger.

      Can a payment cover several invoices?

      Choose a group size of two or three. Each candidate compares one bank transaction with a group of ledger rows, or the reverse. Individual candidate approvals cannot reuse a transaction.

      Why did the search stop before listing every candidate?

      The combination and candidate caps prevent a large ambiguous match search from monopolizing the browser. Narrow the dates, tolerances, group size or source rows and review the smaller set.

      Page updated · Project managed by Tony Hines · Report a problem with Bank Transaction Reconciliation