Bank Reconciliation
Match your books to your bank statement for accuracy.
Starting a Reconciliation
- Go to Chart of Accounts
- Click Reconcile next to your bank account
- 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
- 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
- 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.
- Both fields default to $0.00 - leave them alone if your statement has neither
- BizBooks Pro remembers which income and expense accounts you chose and pre-selects them on your next reconciliation
- Spot a fee only after you've started? No problem - use Add Adjustment inside the reconciliation workspace, which does the same thing mid-session
Importing a PDF Statement (AI)
Instead of typing the balance and clearing each line yourself, hand the work to BizBooks Pro's AI:
- On the start screen, drag the PDF statement from your bank onto the upload box (or click to choose a file)
- Kantivo Core AI (powered by Claude from Anthropic) reads it, then populates the statement date and ending balance and records every transaction it finds
- Click Begin - BizBooks Pro checks off the ledger entries that line up with the statement and recalculates the difference toward $0.00
- Anything that couldn't be matched is listed so you can add or correct it
Matching Transactions
You'll see two lists:
- Deposits/Credits: Money coming in
- Checks/Debits: Money going out
For each transaction on your bank statement:
- Find the matching transaction in BizBooks Pro
- Click to mark it as Cleared
- The "Difference" amount updates in real-time
Handling Discrepancies
Missing Transactions
If a transaction appears on your statement but not in BizBooks:
- Click Add Transaction
- Enter the missing transaction
- It will be marked as cleared automatically
Wrong Amounts
If amounts don't match:
- Check for typos in your entry
- Edit the transaction if needed
- 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:
- Click Finish Reconciliation
- All cleared transactions are locked
- 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.
- Say yes to the print prompt shown when a reconciliation completes, or
- Go to Reconciliation History and click Print on any earlier session to regenerate its report whenever you need it