• Home
  • About Us
  • Services
    Odoo Implementation

    At Accountrix Solutions, we provide reliable Odoo implementation services that align Odoo...

    Odoo Customization

    we understand that every business follows different processes and faces unique...

    Odoo Integration

    Odoo is a free ERP system with various business apps to assist with different operational needs. Powerful...

    Odoo Migration

    Looking to upgrade or switch your Odoo ERP version without losing critical data...

    Digital invoicing

    Generate, dispatch, and monitor invoices promptly – designed for enterprises...

    Odoo Bookkeeping

    Managing your finances doesn’t have to be overwhelming. Our Odoo accounting and bookkeeping...

    Quickbooks Bookkeeping

    At Accountrix Solutions, we tailor our QuickBooks bookkeeping services around your unique...

    Zoho Bookkeeping

    Balancing your finances in Zoho Books alongside managing your business can be overwhelming. That is where...

  • Blog
  • Contact Us
LEt's talk

Zoho Books Reconciliation Not Matching? 7 Causes and How to Fix Them

HomeBlogZoho Books Reconciliation Not Matching? 7 Causes and How to Fix Them
zoho books reconciliation
  • November 9, 2026
  • Blog
  • 14 Views

Zoho Books Reconciliation Not Matching? 7 Causes and How to Fix Them

If your Zoho Books reconciliation will not match, the cause is almost always one of seven things: bank lines that were never matched or categorized, bank feed history that only reaches back 90 days, a wrong opening balance, a duplicate entry, a transaction dated outside the period, an amount that is slightly wrong, or a change to a transaction that was already reconciled. Find the exact difference first, then work through the causes in the order below, and the difference shrinks to zero. This guide shows how, with a worked example and a routine you can follow every month.

How Zoho Books reconciliation works, and where it goes wrong

Zoho Books reconciliation compares the transactions in your bank account with the ones you have recorded in Zoho Books, for a period you choose. Zoho’s help notes that the opening balance should be correct before you reconcile anything, and that is where many problems begin. This is the basic flow:

  1. Go to Banking in the left sidebar and select the account.
  2. Click the gear icon in the top right corner and choose Reconcile Account.
  3. Click Initiate Reconciliation.
  4. Enter the start date, the end date and the closing balance from your bank statement.
  5. Click Start Reconciliation, then select the transactions that appear on the statement.
  6. Click Reconcile when the difference is zero, or use Save and Reconcile Later if you need to stop.

Two different jobs share the same name, and mixing them up causes trouble:

MatchingLinking each bank feed line to a transaction already in your books, or categorizing it as a new one. Do it weekly, or even daily.
ReconcilingComparing everything in your books for a period with your official bank statement. Do it monthly, when the statement arrives.

Start here: find the exact difference

Do not start fixing before you know what you are looking for. Write down three things:

  • The difference Zoho Books shows, with its sign (too high or too low)
  • The statement’s start date, end date and closing balance you entered
  • Whether the opening balance equals last month’s closing balance

The exact amount is your clue. A difference that equals one transaction points to a duplicate or a missing line. A difference that stays the same every month points to the opening balance. Use these questions in order:

1. Does the opening balance equal last month’s closing balance?
No: fix the opening balance firstYes: go on
2. Are there bank feed lines that are not matched or categorized?
Yes: match or categorize themNo: go on
3. Does any single transaction equal the difference?
Yes: it is a duplicate or a missing lineNo: go on
4. Are any transactions dated outside the statement period?
Yes: correct the dateNo: go on
5. Was a transaction edited or deleted after an earlier reconciliation?
Yes: undo, correct and reconcile againNo: check amounts, fees and splits

7 causes of a Zoho Books reconciliation that will not match

1. Bank lines were never matched

Symptom

The books show fewer transactions than the statement.

Fix

Open the feed and match each line to an existing entry, or categorize it as a new one. Transaction rules can handle the repeats.

2. The feed only covers 90 days

Symptom

The balance is off by about the amount of older activity.

Fix

Zoho’s help says feeds can be fetched for the last 90 days. Add earlier transactions manually or import a statement file.

3. The opening balance is wrong

Symptom

The same difference appears every month.

Fix

Compare the opening balance with the bank’s balance on the day you started. Zoho’s help describes using an Opening Balance Offset account to correct it. Ask your accountant first.

4. A transaction was entered twice

Symptom

One amount appears two times, usually once by hand and once from the feed.

Fix

Delete or merge the duplicate, and keep the one that matches the statement.

5. A date is outside the period

Symptom

A transaction is on the statement, but missing from the list for your dates.

Fix

Correct the date so it falls inside the statement period.

6. An amount is slightly wrong

Symptom

A small difference such as a fee, a rounding or a currency gap.

Fix

Compare each line with the statement. Record fees as their own transactions.

7. A reconciled transaction was changed

Symptom

A past month that balanced now shows a difference.

Fix

Undo that reconciliation, correct the transaction, and reconcile again.

A worked example: chasing a $150 difference to zero

These numbers are made up. A business reconciles a month, enters a closing balance of $12,480.00 from the bank statement, and selects every transaction in Zoho Books. The selected total is $12,630.00, so the difference is $150.00. Here is how the search goes:

StepWhat you checkDifference left
StartClosing balance $12,480.00 vs selected transactions $12,630.00$150.00
1Opening balance equals last month’s closing balance$150.00
2Every feed line is matched or categorized$150.00
3One transaction equals $150.00: a customer payment entered by hand and again from the feed$150.00
FixDelete the manual copy and reconcile$0.00

The search took four questions, because the difference pointed at one transaction. Most differences are this small. They look scary only until you know the exact amount.

Special cases: credit cards, payment gateways and other currencies

The steps above work the same way for most accounts, but three cases need extra care.

  • Credit cards. Reconcile them the same way, using the statement’s closing balance. A card balance is money you owe, so a wrong sign on one amount, such as a refund recorded as a purchase, creates a difference that is exactly double that amount.
  • Payment gateways and marketplaces. These pay you in one lump that is smaller than the sales behind it, because fees and refunds come out first. One bank line then matches several customer payments and a fee. Match the line to all of them together, and record the fee as its own transaction.
  • Other currencies. If an account is in a foreign currency, differences of a few cents can come from the exchange rate on the day of payment. Compare the amounts in the account’s own currency, and review the rate on any transaction that is off.

Whatever the account, the method does not change: find the exact difference, then ask which transaction or which balance explains it.

Undo, edit and redo safely

If a reconciled month needs a correction, Zoho Books lets you undo it. Open the account, go to Reconcile Account, and choose the period you want to undo. Zoho’s help says you can then edit your transactions and reconcile the account again. You can also delete a reconciliation you no longer need. Before you do:

  • Note the period, the closing balance and what you plan to change.
  • Check whether a tax return or report already used that month, and if it did, tell your accountant first.
  • After the fix, attach the statement to the reconciliation for the record.
One rule helps more than any other: change as little as possible. Fix the one transaction that caused the difference, then reconcile again. Do not rebuild a month because one line is wrong.

Mistakes that make a reconciliation harder

  • Forcing the balance. Adding an adjustment so the difference reads zero hides the cause and moves the error into next month.
  • Using the wrong closing balance or end date. The numbers you enter must come from the statement for exactly that period.
  • Deleting a reconciled transaction. Undo the reconciliation first, then correct the transaction and reconcile again.
  • Importing the same file twice. Overlapping dates create duplicate lines, so check the dates before you upload.
  • Mixing feed and manual entry for one account. Pick one main way to bring lines in, and match against it.
  • Changing the opening balance without telling your accountant. It changes every period after it.

How to stop it from happening again

How oftenWhat to do
WeeklyMatch the bank feed. Use transaction rules for lines that repeat, like fees and subscriptions.
MonthlyReconcile every account when the statement arrives, and attach the statement.
MonthlyCheck that the opening balance equals last month’s closing balance before you start.
Every quarterReview which transaction rules still make sense.

If your bank is not connected, importing a statement file works the same way. Matching and reconciling follow the same steps whether the lines arrive by feed or by import.

When to hand your Zoho Books reconciliation to a bookkeeper

You can fix most differences yourself. Consider help when:

  • You are more than two or three months behind
  • The same difference returns every month
  • Several accounts or currencies are involved
  • You are not sure whether the opening balances are right
  • A tax deadline or loan application is close

A bookkeeper who works in Zoho Books every day will usually find the cause faster, and will leave a record of what changed. Our Zoho bookkeeping services team can reconcile past months and set up a routine, so it does not come back.

What to prepare before you ask for help

A short list makes any review faster. Gather:

  • The months and accounts that do not reconcile
  • The exact difference for each one
  • Your bank statements for those months
  • A note of what you already tried
  • The date of your next deadline

With these in hand, the people at Accountrix Solutions can tell you quickly how big the job is.

Frequently asked questions

Why is my Zoho Books reconciliation not matching?

The most common causes are bank lines that were never matched or categorized, feed history that only covers the last 90 days, a wrong opening balance, duplicate entries, transactions dated outside the period, small amount errors, and changes to transactions that were already reconciled.

How do I start a bank reconciliation in Zoho Books?

Go to Banking, select the account, click the gear icon and choose Reconcile Account. Click Initiate Reconciliation, enter the start date, end date and closing balance from your statement, click Start Reconciliation, select the transactions on the statement, and click Reconcile.

Can I undo a reconciliation in Zoho Books?

Yes. Open the account’s Reconcile Account page, choose the reconciled period and undo it. The transactions return to the unreconciled list, so you can edit them and reconcile again.

Why does my Zoho Books balance differ from my bank balance?

Zoho’s help lists uncategorized transactions that were never matched, bank feeds that only fetch the last 90 days, and an opening balance that does not agree with the account. Check the opening balance first.

How far back can the Zoho Books bank feed go?

According to Zoho’s help, you can fetch feeds for the last 90 days when you add a bank account. Earlier activity has to be added manually or imported from a statement file.

What is the difference between matching and reconciling?

Matching links each bank feed line to a transaction in your books, or categorizes it as a new one. Reconciling compares everything in your books for a period with your bank statement. Match often, and reconcile once a month.

How often should I reconcile in Zoho Books?

Match feed lines weekly or daily, and reconcile each account monthly when the statement arrives, before you close the month.

Final thoughts

A Zoho Books reconciliation that will not match is nearly always one small thing with a clear cause. Write down the exact difference, check the opening balance, match what is waiting in the feed, look for a duplicate or a wrong date, and undo a past month only when you must. Then keep a simple weekly and monthly routine, and the difference stops coming back.

Still stuck on a difference that will not close? Tell us the account, the month and the amount, and we will tell you where to look.

Tell us what your Zoho Books shows today

Leave a comment Cancel reply

Top Category

  • Blog (37)

Recent Posts

November 3, 2026

Odoo Timesheets to Invoices: How to Bill Clients by the Hour Without Spreadsheets

November 21, 2026

Odoo Year-End Closing: Fiscal Year, Lock Dates and Opening Entries Explained

Odoo Expenses
November 2, 2026

Odoo Expenses: How to Set Up Employee Reimbursements, Receipts and Corporate Cards

Popular Tag

Odoo Upgrade Odoo

Related Articles

Odoo Year-End Closing: Fiscal Year, Lock Dates and Opening Entries Explained

  • Blog
  • November 21, 2026
  • 5 Views

FBR vs PRA vs SRB: Which E-Invoicing System Does Your Business Actually Need?

  • Blog
  • November 20, 2026
  • 8 Views
FBR vs PRA vs SRB

FBR Digital Invoice Error Codes Explained: What Each API Error Means and How to Fix It

  • Blog
  • November 19, 2026
  • 15 Views
fbr digital invoice error codes

ACCOUNTRIX SOLUTIONS

Transforming workflows with tailored digital and accounting solutions.

Know More
Contact US

Get Started

  • Home
  • About Us
  • Blog
  • Contact

Odoo Services

  • Odoo Implementation
  • Odoo Customization
  • Odoo Integration
  • Odoo Migration

Bookkeeping Services

  • Digital invoicing
  • Odoo Bookkeeping
  • Quickbooks Bookkeeping
  • Zoho Bookkeeping

© 2026 All Rights Reserved | Designed by Ruman

Facebook Twitter Google-plus