# Ledger Reconciliation

Books & closing · Live

Ledger Reconciliation is a browser tool that reconciles two ledgers, such as your cash book and a bank statement, from Excel, CSV or a text PDF. It clears the entries that agree, explains the rest, and builds a reconciliation statement that says whether the two balances tie.

Two ledgers in, a reconciliation statement out. It clears the lines that agree, explains the ones that do not, and tells you whether the two balances tie.

Most of a reconciliation is matching, and most matching follows rules. The software does that part in a few seconds. What is left is the handful of lines that need somebody to think about them, and each one arrives with a note saying why it is there.

## What it does

- Reads Excel, CSV and text PDFs, including the bank statements that print as tables with no lines around them.
- Works out what each column is from its heading, and lets you fix it when the two files use different words for the same thing.
- Matches on the reference first, then on the description and the amount, then on the amount alone. A cheque number counts for more than a round figure that happens to turn up twice.
- Copes with a bank statement being the mirror of your cash book, where every debit in one is a credit in the other. It works that out from the entries themselves.
- Builds the statement in the usual Add and Less form and says whether the two balances tie out.
- Says in plain words why each remaining line is there, and names the likely cause of an amount difference: rounding, a decimal point in the wrong place, or a multiple.
- A PDF for the file, an Excel workbook for the follow up, and a copy kept in your own history.
- The two files are read inside your browser and never uploaded. What gets kept is the statement you produced, in a history only you can open.

- **Goes in:** Two ledgers, as Excel, CSV or a text PDF
- **Comes out:** A reconciliation statement, and the lines to look at

Open it: https://www.thefinanceintelligence.com/reconcile

## Questions

### What is Ledger Reconciliation?

Ledger Reconciliation is a browser tool that reconciles two ledgers, such as your cash book and a bank statement, from Excel, CSV or a text PDF. It clears the entries that agree, explains the rest, and builds a reconciliation statement that says whether the two balances tie.

### How do I make a bank reconciliation statement with it?

Load your cash book and the bank statement as Excel, CSV or a text PDF. It matches the entries, lists the ones that do not agree with the reason for each, and builds the statement in the usual Add and Less form, saying whether the two balances tie.

### How does it match entries?

On the reference first, then on the description and the amount, then on the amount alone. It also copes with a bank statement that mirrors your cash book, where every debit in one is a credit in the other.

### Are my files uploaded anywhere?

No. The two files are read inside your browser and never uploaded. What is kept is the statement you produced, in a history only you can open.

### What do I get at the end?

A PDF for the file, an Excel workbook for the follow up, and a plain note on why each remaining line is there, including the likely cause of an amount difference such as rounding or a misplaced decimal point.

---

Source: https://www.thefinanceintelligence.com/tools/ledger-reconciliation
The Finance Intelligence is a set of web tools, free calculators and guides for finance work in India, built by chartered accountants. Contact: team@thefinanceintelligence.com.
