Retyping statements
It reads bank statements in PDF, Excel, CSV and the common bank download formats (OFX, QFX, QIF), including statements that hold several accounts.
The Reconciler · Flagship product
The Reconciler is bank reconciliation software for Windows. It reads your bank statements and your QuickBooks report, proves each statement ties, matches every item, and hands your team an Excel workbook to review. It runs on your own computer with network connections blocked, and starts with a fixed-fee pilot on your own statements.
Who it's for
The Reconciler is for teams that reconcile the same accounts every month and spend days doing it by hand: bookkeeping and accounting firms, trust and benefits accounting teams, and businesses that write a high volume of checks. It is licensed to your team and tuned to your banks, workbook layouts and QuickBooks account names.
Pinch points it removes
The parts of a bank reconciliation that eat the most hours are the parts a program does best.
It reads bank statements in PDF, Excel, CSV and the common bank download formats (OFX, QFX, QIF), including statements that hold several accounts.
Every statement is proven to tie: opening balance plus activity equals the closing balance, month after month.
Checks are matched by number, outstanding and stale-dated checks are carried forward, and voided checks and deposits in transit are handled.
Every total in the Excel workbook is a formula of its items, so a reviewer can check each row.
Adjustments come out as a QuickBooks Desktop import file (IIF), ready to bring into your books.
It runs on your computer and blocks network connections. Nothing is uploaded.
What it does
Read. Bank statements in PDF, Excel, CSV, OFX, QFX and QIF, including multi-account statements. On the books side it reads QuickBooks Desktop "Transaction Detail by Account" or "Check Detail" reports saved to Excel or CSV.
Match. Each statement is proven to tie before matching starts. Checks are matched by number; outstanding and stale-dated checks are carried forward; voided checks and deposits in transit are handled. It has been tested on sample months of up to 14,500 checks.
Deliver. An Excel reconciliation workbook where every total is a formula of its items, a QuickBooks Desktop import file (IIF) for adjustments, and an audit log of every action.
See it work with sample data in the live demo on our home page.
Security
How an engagement runs
Tell us which banks, how many accounts and which QuickBooks reports you work with.
The pilot is a fixed fee, quoted up front based on how many accounts and months it covers.
We tune The Reconciler to your banks, workbook layouts and QuickBooks account names, then run it on real months of your statements so you can check every result.
If you go forward with a license, the full pilot fee is credited toward your first year.
Who builds it
The Reconciler is built and supported by A.D. Consulting in Sacramento, the same team behind our bookkeeping and bank reconciliation services and backed by 16 years of hands-on operations experience. It is the first of a family of tools for the work that repeats.
Service area: on-site in Sacramento, Midtown, Elk Grove, Folsom, Davis and Roseville, and across the greater Sacramento area. Remote anywhere, by video call and screen share, inside your own systems.
It compares your bank statements with your accounting records and shows what matches and what does not. The Reconciler reads the statements and your QuickBooks report, proves each statement ties, matches every item and delivers an Excel workbook your team can review.
Bank statements in PDF, Excel, CSV and the common bank download formats (OFX, QFX, QIF), including statements that hold several accounts. On the books side it reads QuickBooks Desktop "Transaction Detail by Account" or "Check Detail" reports saved to Excel or CSV.
We tune The Reconciler to your banks, workbook layouts and QuickBooks account names, then run it on real months of your own statements so you can check every result. The pilot is a fixed fee, quoted up front based on how many accounts and months it covers. If you go forward with a license, the full pilot fee is credited toward your first year.
Yes. The Reconciler runs on your computer with network connections blocked, so nothing is uploaded. Account numbers are masked to the last four digits in every file it writes, statement text is encrypted on disk, and every action is recorded in a tamper-evident audit log.
Tell us which banks, how many accounts and which QuickBooks reports you reconcile. We reply within one business day.