1. Amount, Date & Memo Matching
Configurable ±0 to 31 Day Window
Pair entries by exact amount and flow direction within your chosen tolerance window, boosted by narration similarity and reference ID scoring.
Upload digital or scanned PDFs, statement images, CSV, or XLSX files to reconcile bank statement records against your business ledger, corporate card export, or cash book. Spot gaps, duplicates, and mismatches instantly—then export clean XLSX or CSV reports.
To reconcile bank statement records accurately without brittle spreadsheet formulas, upload both files, set your clearing window, and review every flagged exception before export.
Stop spending hours reconciling bank statements row by row in Excel. reconcilebankstatement separates explained timing items and unrecorded wire fees from unexplained residual variance automatically.
Submit digital or scanned PDFs, statement images, CSV/TSV/TXT exports, or XLSX/XLSM workbooks directly—up to 100 MB per file with optional in-memory PDF password unlocking.
Configurable ±0 to 31 Day Window
Pair entries by exact amount and flow direction within your chosen tolerance window, boosted by narration similarity and reference ID scoring.
Running-Balance Continuity Check
Independently verify opening and closing math on both records, catch mid-statement running-balance breaks, and confirm book-to-bank tie-outs.
Dr/Cr Sign & Amount Delta Detection
Surface suspected duplicate groups on either file, near-matches with digit transpositions, and inverted debit or credit entries in seconds.
Clear financial controls start with knowing why books and bank statements diverge—and resolving each exception systematically before period close.
At its core, accounting account reconciliation proves that internal general ledger balances agree with independent external statements. In everyday practice, this verification check comes down to one clear standard: every recorded inflow, outflow, and ending cash figure must match verifiable source documents.
Teams that regularly reconcile bank statement balances catch unrecorded wire fees, duplicate postings, and timing lags before month-end close. Modern financial reconciliation software replaces manual tick-and-tie checklists with deterministic matching, running-balance verification, and clean audit trails.
Instead of reading hundreds of matching rows line by line, reconcilebankstatement verifies pairs automatically and brings only four actionable exception groups—timing gaps, unrecorded fees, suspected duplicates, and amount or sign mismatches—to the front.
When reconciling bank statements across active operating accounts, four recurring issues explain nearly every closing difference. Manual reviews often miss subtle posting mistakes that dedicated financial reconciliation software surfaces immediately:
Payments recorded in your cash book at month-end often settle at the bank 1 to 3 business days later, creating temporary gaps.
Configure date tolerances up to ±31 days to match delayed settlements, while true period-end cutoffs isolate cleanly in Unmatched Ledger.
Wire charges, monthly maintenance fees, bounced customer checks, and earned interest appear on bank statements before reaching your ledger.
Every unposted bank line surfaces in Unmatched Bank with exact dates, amounts, and descriptions ready for adjusting journal entries.
Manual keying swaps digits (like $850 vs. $840) or logs a withdrawal as a deposit when switching between bank and book conventions.
Automatic direction convention detection and near-match analysis isolate exact amount deltas and Dr/Cr sign inversions in Amount Mismatches.
Overlapping CSV exports or missing OCR rows introduce duplicate transactions and break statement math mid-period.
Possible Duplicates groups suspect repeats on either record, while row-by-row running-balance checks pinpoint the exact row of any break.
Reliable reconciliation for accounting teams requires clear exception handling across US, UK, and EU statement formats—whether you check daily cash books, corporate cards, or month-end schedules.
Compare checking, savings, and treasury statements against your cash book to isolate wire fees, NSF checks, and timing items.
Checking, Savings & Cash Books
Filter unmatched lines directly to track deposits in transit and uncleared payments.
Match corporate Visa, Mastercard, or Amex PDF/CSV statements against expense ledgers to catch duplicate billings and FX fees.
Corporate Card Statements
Widen tolerance days for delayed posting and spot reversed refund directions.
Substantiate cash, clearing, and subledger balances against external source statements before month-end close and audits.
Month-End Close Proof
Verify opening + net flow = closing balance with downloadable XLSX audit trails.
Both sides prove out toward the same ending cash figure while keeping timing differences, unrecorded fees, and errors transparent.
Timing Items vs. Book Adjustments
Parses English, German, French, Spanish, Portuguese, and Dutch headers plus UTF-16 Unicode and HTML/XML bank exports across USD, GBP, and EUR.
Currency Normalization
Preserves decimal precision across European, UK, and US bank export conventions.
Unlike heavy account reconciliation software locked behind sales demos and ERP migrations, reconcilebankstatement runs directly from your exported files—pairing transactions, isolating exceptions, and exporting clean tie-outs in minutes.
Replace error-prone VLOOKUP sheets with deterministic amount, direction, reference, and date-tolerance matching.
Verify opening plus net flow equals closing balance on both records and catch mid-statement running-balance breaks.
Never link live banking logins. Upload exported statements directly—including encrypted PDFs unlocked strictly in memory.
Parse ISO 4217 currencies, parentheses or Dr/Cr signs, UTF-16 exports, and English, German, French, Spanish, Portuguese, and Dutch headers.
Bank settlement dates often trail ledger postings by 1–3 business days. Adjust date_tolerance_days between 0 and 31 days and toggle description_matching to rank candidate pairs with explicit confidence scores.
Every completed run classifies transactions into auditable buckets and runs independent math checks across both your bank statement and business ledger.
Confidence score, date gap, and match basis
Separate unmatched bank vs. unmatched book rows
Grouped suspected repeats with transaction IDs
Near-matches with deltas or inverted Dr/Cr signs
Quantifies explained discrepancy differences versus residual unexplained variance automatically.
Download structured Excel workbooks or clean CSV reports straight from any completed run.
Compare spreadsheets and basic converters against dedicated financial reconciliation software built for direct statement verification.
| Capability | Manual Spreadsheets | Generic PDF Tools | Enterprise Suites | reconcilebankstatement Utility |
|---|---|---|---|---|
| Access & Setup | Manual formula & tab setup | Converter limits or paywalls | Weeks of ERP onboarding & sales demos | Instant browser utility — no subscription |
| Scanned & Locked PDFs | Manual re-keying line by line | Must unlock PDFs separately first | Requires clean ERP or bank feeds | Built-in PDF OCR + in-memory unlock |
| Date Tolerance & Matching | Fragile exact VLOOKUP formulas | No ledger comparison engine | Complex custom rule scripting | ±0–31 day window + reference & memo scoring |
| Duplicates & Sign Flips | Missed without custom pivots | Not checked | Batch rules after feed sync | Dedicated duplicates & Dr/Cr flip alerts |
| Balance & Variance Proof | Manual ending tie-out formulas | Raw table dump only | Tied to full close platform | Opening/closing, running balance & proof |
| Export Deliverable | Ad-hoc copy-paste sheets | Unstructured CSV dump | Proprietary close workspace | Clean XLSX workbook & CSV report export |
From byte-level format detection and PDF OCR to running-balance continuity checks and XLSX/CSV export, explore what runs inside every tie-out.
Detects true document format from file bytes—not just extensions—routing PDFs and images through OCR while parsing CSV, TSV, TXT, XLSX, and XLSM directly.
Recognizes English, German, French, Spanish, Portuguese, and Dutch bank headers automatically
Core Engine Capabilities
Extracts transaction tables from native or scanned PDFs with multi-pass OCR fallback, and unlocks password-protected PDFs in memory without storing passwords.
Reads UTF-16 Unicode text exports, split two-row headers, and HTML/XML bank exports saved with spreadsheet extensions up to 100,000 rows.
Parses currency codes/symbols, trailing minus signs, accounting parentheses, and Dr/Cr suffixes consistently across statements and cash books.
Automatically picks up Balance B/F, Brought Forward, Balance C/F, and Carried Forward rows from both statements and ledgers.
Follow these five steps to compare your bank statement and business ledger from document upload to XLSX or CSV export.
Drop your bank or card statement in PDF (digital or scanned), image, CSV, TSV, TXT, or XLSX/XLSM format.
Add your matching cash book, general ledger export, or invoice/receipt PDF (supply PDF passwords if locked).
Set your date window (0–31 days) and toggle description similarity scoring to reflect settlement timing.
Inspect matched pairs, bank-only fees, book-only timing items, possible duplicates, mismatches, and balance checks.
Download your complete reconciliation workbook as XLSX or CSV, or save your reconciliation ID to reopen later.
Use this three-stage checklist to prepare files, inspect exceptions, and confirm final balance tie-outs.
Ensure the bank statement and business ledger cover overlapping statement periods in the same currency with clear date and amount columns.
If either PDF is encrypted, provide its password before or when prompted; it is decrypted in memory only and never saved.
Filter directly to Unmatched Bank (wires, fees, interest) and Unmatched Ledger (deposits in transit, uncashed checks).
Check flagged duplicate groups and rows with amount differences or reversed debit/credit directions side by side.
Verify both statement and ledger math checks pass, including line-by-line running balance continuity.
Export your finished reconciliation workbook immediately for review or archival without locking into any platform.
Everything you need to know about using reconcilebankstatement, supported document formats, matching tolerances, and reconciliation best practices.
Open the Reconciliation Tool page (/reconcile), drop your bank statement (PDF, image, CSV, TSV, TXT, or XLSX/XLSM) into Slot 1 and your business ledger or cash book into Slot 2, adjust the date tolerance window (0–31 days, default ±2 days) and description similarity toggle, and click Run Bank Reconciliation. Once processing completes, review Matched, Unmatched Bank, Unmatched Ledger, Duplicates, and Mismatches, verify the balance checks, and export your XLSX or CSV report. You can also click Load Sample CSV Pair to test the workflow instantly.
Open the reconcilebankstatement workbench to reconcile bank statement PDFs, images, CSV, or XLSX files against your business ledger and review matches, gaps, duplicates, and balance proofs in one run.