Bank Reconciliation

Match your books to your bank statement for accuracy.

Starting a Reconciliation

  1. Go to Chart of Accounts
  2. Click Reconcile next to your bank account
  3. The start screen shows your last reconciliation date and its statement balance at the top, so you can confirm you're picking up right where the previous statement left off
  4. Enter:
    • Statement Date: End date on your bank statement
    • New Statement Ending Balance: Balance shown on this statement
    • Interest Earned (optional): interest the bank paid you this period, with a dropdown to pick the income account
    • Bank Service Charges (optional): fees the bank charged this period, with a dropdown to pick the expense account
  5. Click Start Reconciliation

Interest & Service Charges Up Front

Coming from QuickBooks? This screen works the way you're used to. Any interest or service-charge amount you enter on the start screen is recorded as a proper double-entry transaction and pre-cleared on the reconciliation - you won't need to add it as an adjustment later.

Importing a PDF Statement (AI)

Instead of typing the balance and clearing each line yourself, hand the work to BizBooks Pro's AI:

  1. On the start screen, drag the PDF statement from your bank onto the upload box (or click to choose a file)
  2. Kantivo Core AI (powered by Claude from Anthropic) reads it, then populates the statement date and ending balance and records every transaction it finds
  3. Click Begin - BizBooks Pro checks off the ledger entries that line up with the statement and recalculates the difference toward $0.00
  4. Anything that couldn't be matched is listed so you can add or correct it
Better accuracy option: The reader uses the AI allowance included with your plan. To get the sharpest results on hard-to-read statements, enter your own Anthropic API key and choose Claude Opus under Settings → AI Assistant; BizBooks Pro then uses your key rather than your included credits.
Nothing is finalized automatically: The import selects the matches and gets you to a zero (or near-zero) difference, then hands control back to you to review and click Finish Reconciliation.

Matching Transactions

You'll see two lists:

For each transaction on your bank statement:

  1. Find the matching transaction in BizBooks Pro
  2. Click to mark it as Cleared
  3. The "Difference" amount updates in real-time
Tip: Sort by amount to quickly find matching transactions. The amount should match exactly.

Handling Discrepancies

Missing Transactions

If a transaction appears on your statement but not in BizBooks:

  1. Click Add Transaction
  2. Enter the missing transaction
  3. It will be marked as cleared automatically

Wrong Amounts

If amounts don't match:

  1. Check for typos in your entry
  2. Edit the transaction if needed
  3. Or create an adjustment entry

Duplicate Transactions

If you have duplicates, void or delete the extra entry.

Completing Reconciliation

When the Difference shows $0.00:

  1. Click Finish Reconciliation
  2. All cleared transactions are locked
  3. A reconciliation record is saved

Right after finishing, BizBooks Pro offers to print the reconciliation report described below.

Printing the Reconciliation Report

BizBooks Pro creates a QuickBooks-style reconciliation report for your files or your accountant. It shows the statement summary, the cleared balance and difference, and a line-by-line list of the cleared payments and deposits.

  1. Say yes to the print prompt shown when a reconciliation completes, or
  2. Go to Reconciliation History and click Print on any earlier session to regenerate its report whenever you need it
Warning: Once reconciled, you shouldn't edit those transactions. If you must, you'll need to undo the reconciliation first.
Tip: Reconcile monthly when you receive your bank statement. This catches errors early and keeps your books accurate.