A.D. Consulting

Bookkeeping · Reconciliation · Software · Sacramento, CA

Business solutions for all.

We keep your books accurate, tie every bank account to its statement each month, and build software that takes the busywork out of month-end, so your team reviews the work instead of building it.

Schedule a consultation See The Reconciler
Statements firstEvery account tied to the bank statement
Fixed-fee pilotsProven on your own files before you commit
Plain EnglishEvery difference explained in writing
QuickBooksOnline and Desktop

Services

What we do

Bookkeeping

Accurate monthly books in QuickBooks Online or QuickBooks Desktop.

  • Monthly bookkeeping and close
  • Catch-up and clean-up of past years
  • Books ready for your CPA or EA at tax time

Bank reconciliation

Every account proven against its statement, every month.

  • Outstanding checks and deposits in transit carried month to month
  • High-volume check accounts matched by check number
  • A written list of every difference and how it was resolved

The Reconciler: licensing & tailoring

Our own reconciliation software, licensed to your team and tuned to how you work.

  • Set up for your banks, workbook layouts and account names
  • Every change tested on your own statements first
  • Starts with a fixed-fee pilot

Process automation

We find the repetitive work slowing your month-end and build tools to handle it.

  • Statement collection, naming and filing
  • Invoices built from time records
  • Reports your team rebuilds by hand every month

Software

The Reconciler

A Windows program that builds the monthly bank reconciliation: it reads your statements and your QuickBooks report, matches every item, and hands your team a finished workbook to review.

What it does today

  • Reads bank statements in PDF, Excel, CSV and the common bank download formats (OFX, QFX, QIF), and splits statements that hold several accounts.
  • Proves every statement ties out: opening balance plus activity equals the closing balance, month after month. Anything that does not tie is flagged.
  • Reads QuickBooks Desktop reports ("Transaction Detail by Account" or "Check Detail", saved to Excel or CSV) as the books side.
  • Builds the month-end reconciliation: checks matched by number, outstanding and stale-dated checks carried forward, voided checks and deposits in transit handled.
  • Delivers an Excel workbook where every total is a formula of its items, so a reviewer can audit each row.
  • Handles volume: tested on sample months of up to 14,500 checks.
  • Writes a QuickBooks Desktop import file (IIF) for adjustments.

Built around your data

  • Runs entirely on your own Windows computer, and blocks network connections. Nothing is uploaded.
  • Account numbers are masked to the last 4 digits in every file it writes.
  • Statement text kept on disk is encrypted with a key Windows protects.
  • Every action goes into a tamper-evident audit log.
  • Each release passes more than 1,400 automated tests and is installed and tested on a separate Windows computer before it ships.

Tailored, starting with a pilot

We tune the Reconciler to your banks, workbook layouts and QuickBooks account names. A short pilot proves it on your own statements for a fixed fee, credited toward the first-year license if you go forward.

Ask about a pilot

How we work

Clear scope, your equipment, written results

  1. Consultation. A free conversation about how your books and month-end run today.
  2. Written proposal. A fixed scope, price and timeline before any work starts.
  3. On-site or on your systems. We work at your office or in your own software. Client data stays on client machines.
  4. Review and sign-off. You get the finished work with every difference explained in writing.

Who we help

Built for businesses that run on accurate books

  • Bookkeeping & accounting firms
  • Trust and benefits accounting teams
  • Restaurants & hospitality
  • Farms & agriculture
  • Trades & home services
  • Homeowners associations

About

A.D. Consulting

A.D. Consulting is a Sacramento bookkeeping and reconciliation firm founded by Andrew Duarte. We do the work by hand where judgment matters, and we build our own software where the work repeats every month. The Reconciler grew out of our own client reconciliations and is used on real client work.

Big companies have whole departments for this. We believe every business deserves the same accuracy at a price it can live with. That is what we mean by business solutions for all.

  • FounderAndrew Duarte
  • Based inSacramento, California
  • ServingGreater Sacramento on-site, anywhere remote
  • Works withQuickBooks Online and QuickBooks Desktop

Schedule a consultation

Tell us about your books and your month-end. We reply within one business day.

Email us