The Reconciler · Flagship product

Bank reconciliation software for small business and their bookkeepers.

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

Built for the reconciliations that repeat.

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.

  • Bookkeeping & accounting firms
  • Trust and benefits accounting teams
  • Businesses that write many checks
  • Teams on QuickBooks Desktop

Pinch points it removes

Statements in. A finished reconciliation out.

The parts of a bank reconciliation that eat the most hours are the parts a program does best.

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.

Balances nobody proved

Every statement is proven to tie: opening balance plus activity equals the closing balance, month after month.

Matching checks by hand

Checks are matched by number, outstanding and stale-dated checks are carried forward, and voided checks and deposits in transit are handled.

Workbooks no one can audit

Every total in the Excel workbook is a formula of its items, so a reviewer can check each row.

Adjustments keyed in twice

Adjustments come out as a QuickBooks Desktop import file (IIF), ready to bring into your books.

Data leaving the building

It runs on your computer and blocks network connections. Nothing is uploaded.

What it does

Read, match, deliver.

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

Your statements stay on your computer.

  • Runs on your computer. It blocks network connections, so nothing is uploaded.
  • Masked to the last 4. Account numbers are masked in every file it writes.
  • Encrypted. Statement text is encrypted on disk, with a key Windows protects.
  • Audit log. Every action is recorded in a tamper-evident log.
  • 1,400+ tests. Each release is tested, then installed and tested on a separate Windows computer.

How an engagement runs

Prove it on your own statements first.

  1. 01

    Free consultation

    Tell us which banks, how many accounts and which QuickBooks reports you work with.

  2. 02

    Fixed-fee pilot

    The pilot is a fixed fee, quoted up front based on how many accounts and months it covers.

  3. 03

    Tuned and run

    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.

  4. 04

    License

    If you go forward with a license, the full pilot fee is credited toward your first year.

Who builds it

Software from a team that does the work.

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.

FAQ

Questions we hear often.

Something else on your mind? Email hello@adconsultinghq.com.

What is bank reconciliation software?

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.

Which files does The Reconciler read?

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.

How does The Reconciler pilot work, and how is it priced?

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.

Is our data safe?

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.

Find the pinch. Fix it.

Tell us which banks, how many accounts and which QuickBooks reports you reconcile. We reply within one business day.