Bank Reconciliation

Match bank statement lines to general ledger entries and produce a month-end reconciliation report.

Overview

This app helps accounting teams reconcile the bank account against the books. View bank statement and GL transactions side by side in AG Grids, match pairs automatically or manually, and see unmatched items highlighted in color. KPI cards and a reconciliation report panel show deposits in transit, outstanding checks, and the reconciling difference. Excel import supports both sides; export and PDF reporting support month-end close. Everything runs in a single self-contained HTML page with data saved locally in your browser.

Key features

Dual transaction grids

• Bank statement grid — Date, description, reference, amount, and status for each bank line.
• Books (GL) grid — Same columns for general ledger cash entries.
• View tabs — Show both sides, bank only, or books only.
• Sample data — Eight bank lines and eight book entries with four pre-matched pairs and outstanding items on each side.

Matching & status

• Auto-match — Pairs lines with the same amount and matching reference or date within five days.
• Manual match — Select one row from each grid and click Match selected.
• Unmatch — Break an existing pair on the selected row.
• Reconciliation status — Balanced, Out of balance, or In progress badge updates live.

Difference highlighting

• Color-coded rows — Red for unmatched, green for matched, amber when amounts differ between a matched pair.
• Visual legend — Quick reference for row highlight meanings.

Import & export

• Import bank — Load bank statement lines from Excel.
• Import books — Load GL entries from a separate spreadsheet.
• Export Excel — Bank Statement, Books, and Reconciliation summary sheets via SheetJS.
• PDF report — jsPDF reconciliation report with summary and unmatched line lists.

Reconciliation report

• KPI cards — Bank ending balance, book balance, outstanding item count, and reconciling difference.
• Report panel — Beginning balance, deposits in transit, outstanding checks, adjusted bank balance, and book balance with difference.

Data management

• localStorage — Bank lines, book entries, match pairs, and dark-mode preference persist across sessions.
• Reset data — Restore sample reconciliation with confirmation.
• Dark mode — Toggle light/dark theme; AG Grid adapts; preference is remembered.

Data & persistence

Sample data starts with a $125,000 beginning balance, eight bank transactions, eight GL entries, and four pre-matched pairs. State saves to `localStorage` under `bank-reconciliation-data` and `bank-reconciliation-dark`.

Charts & reporting

The reconciliation report panel and PDF export show adjusted bank balance versus book balance, deposits in transit (unmatched positive book entries), and outstanding checks (unmatched negative bank lines). Excel export includes a dedicated Reconciliation summary sheet.

Built with

Tailwind CSS (CDN), AG Grid Community, Alpine.js, SheetJS, and jsPDF — all loaded from CDN in a single HTML file.

Try the interactive walkthrough below. Click Walk through features and use Next / Back (or arrow keys) to explore every feature.