Bank reconciliation is not the most exciting part of running a business, but skipping it is how errors, duplicates, and missing transactions quietly pile up. In Zoho Books, the process has three distinct parts: importing your statement, matching transactions throughout the month, and running the final reconciliation against your official closing balance.
This guide walks through the complete process from start to finish, using a credit card account as the working example. The downloadable practice files referenced in the video are available in the description if you want to follow along step by step. Whether you are setting this up for the first time or tightening up a workflow that has gotten a little loose, the same fundamentals apply.
What You’ll Learn
- Reconciliation vs. matching: what each process does, how they relate, and why doing both leads to cleaner books.
- Importing a bank statement: how to upload a CSV or Excel file, map your columns correctly, and avoid common file format pitfalls.
- Categorizing transactions: how to post expenses, refunds, owner draws, card payments, and credit card rewards directly from the banking screen.
- Matching complex transactions: how to handle a single bank line that corresponds to multiple bills or payments already in Zoho Books.
- Running the final reconciliation: how to use the reconciliation screen, handle unchecked transactions, and know when it is safe to hit Reconcile.
Main takeaway: Matching is the regular housekeeping you do throughout the month; reconciliation is the deep clean you do when the statement arrives. Keeping up with matching means the final reconciliation should take minutes, not hours.
What Is Reconciliation?
Reconciliation is the act of comparing what is in your bank account to what is in your books. In Zoho Books, that means taking the statement from your bank or credit card provider and checking it against the transactions recorded in the system. You work through both lists simultaneously, confirming that every transaction appears in both places, and then investigate anything that does not line up.
The reconciliation screen in Zoho Books shows each transaction with a checkbox. You check off entries as you confirm them against your statement, and when you finish, anything left unchecked becomes your investigation list. Some of those unchecked items will be transactions that belong to the following month; others may be duplicates or errors you need to delete or adjust.
Matching vs. Reconciling: What Is the Difference?
These two processes are closely related but serve different purposes, and understanding the distinction will save you a lot of confusion.
Matching is the process of taking a transaction from an imported bank feed and linking it to an existing transaction already in Zoho Books, confirming they represent the same event. Matching does not check for duplicates or errors in Zoho. It simply confirms that everything arriving from the bank feed has a corresponding entry in your books.
Reconciling goes further. It compares what is in Zoho Books against your official bank statement, which means it will surface anything in your books that did not actually happen in the bank, including duplicate entries, incorrectly dated transactions, or amounts that do not match.
| Process | What It Checks | Typical Frequency |
|---|---|---|
| Matching | Bank feed transactions vs. existing Zoho Books entries. Confirms everything from the bank has a match in your books. | Daily or weekly throughout the month |
| Reconciling | Everything in Zoho Books vs. your official bank statement. Confirms nothing extra or incorrect is sitting in your books. | Monthly, when the statement arrives |
How they work together: any transaction you matched during the month appears pre-checked when you open the reconciliation screen. Consistent matching throughout the month cuts down the work at month end significantly. Think of matching as sweeping regularly so the deep clean is quick.
How to Import a Bank Statement into Zoho Books
If you do not have a live bank feed connected, you will import your statement manually. Navigate to the Banking section in Zoho Books, select the account you want to work with, and open the Settings menu. From there, choose Import Statement and either drag your file into the upload area or click to browse for it.
You can also check the status of a bank feed from the Banking overview. An account with a green symbol next to it has an active live feed pulling data in automatically. A gray symbol indicates an inactive feed. Accounts with no symbol have no automatic feed configured, which means manual import is your method.
Live feed vs. manual import: a live bank feed brings in transaction data automatically for you to match against, but it does not post anything on its own. Manual import achieves the same result; it just requires you to download and upload the file yourself. The matching and reconciliation steps are identical either way.
File Format and Amount Column Types
This is where most import problems originate, so it is worth understanding before you upload anything. Zoho Books handles bank statement files differently depending on the format and how amounts are structured in the file.
Excel files (.xlsx) work in Zoho Books only if your amounts are split into two separate columns, one for charges and one for payments. If your bank provides an Excel file with all amounts in a single column using positive and negative values, you will need to save it as a CSV before importing.
When you upload a CSV, Zoho Books will ask you to specify the amount column type. There are three options:
- Double column: separate columns for charges and payments (positive values in each).
- Single column with amount type: one column of positive values and a second column indicating Debit or Credit (or similar labels like In/Out).
- Single column with negative values: one column containing both positive and negative values. This is the most common format from banks and credit card providers.
Credit card sign conventions: many credit card statements show purchases as positive values and payments or refunds as negative. Zoho Books interprets this as the opposite of your intent, so those purchases will appear as deposits. The fix is to negate the amount column in your CSV before importing: multiply each value by -1, undo the original import, and re-upload the corrected file.
If you need to manipulate values in your downloaded file, do so carefully. Any errors introduced during that step will carry through into your books and may not surface until reconciliation. When in doubt, re-download the original from your bank rather than editing a file you have already touched.
Mapping Your Import Columns
After uploading your file and selecting the amount column type, Zoho Books presents a column-mapping screen. Here you match the columns in your file to the corresponding fields in Zoho Books.
The required fields are Date, Charges, and Payment/Refunds. Description, Reference Number, and Payee are optional but recommended. Having a description pulled from your bank statement makes it much easier to identify transactions during matching, especially for vague entries.
Set the date format to match whatever format your file uses. If your file contains dates formatted as MM/DD/YYYY, select that exact pattern. A mismatch here will generate import errors. Zoho Books offers a wide range of date format options; if yours is not listed, reformat the column in your file before uploading.
Confirming the Import
Save your column mapping: check the “Save these selections for use during future imports” option before clicking Next. This stores your mapping so the next time you upload a file from the same source, the columns are pre-matched for you. You will typically only need to configure this once per account.
On the confirmation screen before importing, verify that the number of statement lines ready to import matches the number of data rows in your file. Review any errors listed under “Statement lines that contain errors” and check the unmatched fields to confirm they are columns you intentionally left blank. Once everything looks correct, click Import.
Categorizing Transactions Manually
After importing, your transactions appear in the Uncategorized Transactions queue. For each one, you have two choices: match it to an existing Zoho Books transaction, or categorize it to create a new one.
Use Match when the transaction is already in your books (for example, a bill you already posted or an invoice payment already recorded). Use Categorize when the transaction does not yet exist in Zoho Books and you need to create it now.
For most credit card accounts, the large majority of uncategorized transactions will be straightforward expenses you categorize manually. Here is how each common transaction type works:
Standard Expense
Select the Expense category, choose the appropriate expense account, set the date (Zoho Books pre-fills it from the import), and optionally assign a vendor or employee. Add any descriptive notes that will help with future reference, and attach a receipt if you have one. Click Save.
Expense Refund
Select Expense Refund as the category and choose the same expense account you posted the original charge to. This offsets the original expense. Update the “Received via” field to reflect how the refund came in (for a credit card, select Credit Card). This field is mostly for reporting purposes, so forgetting to update it will not affect the transaction itself unless you have internal reporting that relies on it.
Owner’s Draw or Personal Expense
If a transaction on a business account is a personal expense, categorize it under Owner’s Drawings and assign it to your owner’s draw or personal expense equity account. This keeps personal spending clearly separate from business expenses in your reports.
Credit Card Rewards
Cashback or rewards deposits typically go under Credits or Refunds Received. Assign them to an Other Income account set up for rewards points or similar income. Update “Received via” to Credit Card.
Credit Card Payment
A payment toward the credit card balance goes under the Card Payment category. The “To Account” field locks to the credit card account you are currently working in. Set the “From Account” to whichever bank account made the payment. If the transaction description does not identify the source account, check the bank account it was paid from, or wait until you reconcile that account and then match the transaction at that point.
Reconciliation rules: Zoho Books will prompt you to create a rule each time you save a categorized transaction. Rules can automatically categorize or flag recurring transactions based on criteria like vendor name or amount range. If you have high transaction volume or predictable recurring charges, rules are worth setting up. They are skipped in this walkthrough to show the full manual process, but they can significantly reduce the time spent on future months.
Matching Complex Transactions: Bills and Split Payments
Sometimes a single line item on your bank statement corresponds to multiple transactions already in Zoho Books, for example a payment that covers two separate vendor bills. In this case, use the Match feature with multiple selections rather than categorizing the transaction.
Click into the transaction and select Match. Use the search filters to narrow down the candidates. You can filter by date range, amount range, contact, and transaction type. This is particularly useful when the transaction description does not make the source obvious.
Handling an Amount Pending
When you select transactions to match against, Zoho Books shows a running “Amount Pending” figure. If the selected transactions add up to less than the bank statement amount, you need to account for that difference. Either find the missing transaction already in your books, or use the Create New Transaction option within the matching screen.
Use Create New Transaction with caution: this option exists for situations where you genuinely know why an additional transaction needs to be created. Using it simply to clear the pending balance and move on is bad practice. Only post a new transaction here if you have a direct reference for it. A reference number is strongly recommended when you do use it.
Be deliberate when selecting bills during matching: if you select a bill rather than a payment, Zoho Books will post a new payment on your behalf. This is a valid workflow if you intend it, but if the payment was already posted separately, selecting the bill instead of the payment creates a duplicate. Always confirm whether you are looking at a bill or a vendor payment before matching.
Once the Amount Pending shows zero, click Match. Zoho Books removes the transaction from the uncategorized queue and marks it as matched.
Running the Final Reconciliation
When all transactions are matched or categorized, you are ready to reconcile. Two conditions should be true before you start:
- No uncategorized transactions remain for the period you are closing.
- You have your official bank or credit card statement in hand for that period.
If you have a live bank feed: an orange or gray feed status indicator means data is not coming in correctly. An empty uncategorized queue in this case may mean no data arrived, not that everything is categorized. Confirm the feed status before concluding there is nothing to reconcile.
Starting the Reconciliation
Click the gear icon on the account and select Reconcile Account. If this is the first reconciliation for the account, the list will be empty. Click Reconcile Now. Enter the closing balance from your bank statement (often labeled “New Balance” or “Ending Balance”). Click Start Reconciling.
The reconciliation screen shows all transactions for the period. Transactions you matched during the month appear already checked. Work through the remaining unchecked entries, comparing them against your printed or PDF statement. When the Difference at the bottom of the screen shows zero, click Reconcile.
Handling Unchecked Transactions
It is common to open the reconciliation screen and find transactions that are not checked off and do not appear on your current statement. Do not ignore them, but do not delete them reflexively either.
Right-click any unchecked transaction and open it in a new tab to investigate without losing your reconciliation progress. Common reasons for unchecked transactions include:
- A duplicate entry where the same charge was posted twice.
- A transaction posted without taxes or fees, then re-posted with them included.
- A payment entered early in anticipation but not yet cleared by the bank.
- A matched transaction from late in the month that the bank did not process until the following statement period.
For transactions dated at the very end of the statement period, the bank posting often shows up on the following month’s statement. Leave these unchecked; they will remain available for the next reconciliation cycle and appear automatically when you reconcile next month.
Timing Mismatches
Already-checked transactions causing a difference: if you matched a transaction dated in the current period but the bank did not process it until after the statement cutoff, it shows as checked but creates a difference. Simply uncheck it. The match stays intact and the transaction appears automatically when you reconcile the following month.
Cleaning Up Old Transactions
Any transaction older than two months without a clear explanation should be resolved. The most common legitimate exception is a refund check you have sent out to someone that has not been cashed yet. Beyond that, old lingering transactions almost always indicate a posting error or duplicate that needs cleaning up.
You can save a reconciliation in progress at any time. It appears with an “In Progress” status in the reconciliation list, and you can return to it after making adjustments elsewhere in Zoho Books.
Frequently Asked Questions
What is the difference between matching and reconciling in Zoho Books?
Matching compares transactions from an imported bank feed against what is already in Zoho Books, and is typically done daily or weekly. Reconciling is a deeper monthly process where you compare everything in Zoho Books against your official bank statement, checking for duplicates, errors, and missing transactions. Matching is the ongoing housekeeping; reconciling is the month-end sign-off.
Do I have to match transactions before reconciling in Zoho Books?
No, matching is optional. However, completing your matching throughout the month means those transactions are already checked off when you reconcile, making the final reconciliation much faster. Skipping matching means doing all the work at once during reconciliation instead of spreading it across the month.
What file format should I use to import a bank statement into Zoho Books?
CSV is the most reliable format. Excel files can work, but they require separate columns for charges and payments or refunds. If your bank provides an Excel file with positive and negative values in a single amount column, save it as a CSV before importing.
Why are my credit card charges showing as deposits in Zoho Books?
Credit card statements often use the opposite sign convention from what Zoho Books expects. If your purchases appear as positive values in the file, Zoho Books may interpret them as credits. Negate the amount column in your CSV (multiply each value by -1) before importing, then undo the original import and re-upload the corrected file.
What should I do with unchecked transactions during reconciliation?
Investigate each one. Common causes include duplicate postings, amounts that were re-entered with taxes or fees, and payments that were anticipated but have not yet cleared. For transactions at the very end of the statement period, they may simply post on the following month’s statement and can be left unchecked safely.
How long should a transaction be allowed to linger before I clean it up?
In most cases, any transaction older than two months without a clear explanation should be investigated and resolved. A common legitimate exception is a refund check you have sent out to someone that has not been cashed yet. Beyond that, old lingering transactions almost always represent a posting error or duplicate.
What is the difference between categorizing and matching a transaction in Zoho Books?
Matching links a bank feed transaction to a transaction that already exists in Zoho Books. Categorizing creates a new transaction in Zoho Books at the same time you confirm the bank feed item. If a transaction is already posted in your books, match it. If it is not yet in your books and is a straightforward charge, categorize it directly from the uncategorized transactions queue.
Can I undo a bank statement import in Zoho Books?
Yes. From the uncategorized transactions page, use Undo Last Import to remove all transactions from that import batch. You can also exclude individual transactions and restore them later from the Excluded tab. Note that fully undoing an import removes those transactions entirely, while excluding them allows restoration.
What closing balance do I enter when starting a reconciliation?
Enter the ending or new balance shown on your official bank or credit card statement for the period you are reconciling. Zoho Books will display a running difference as you check off transactions; when that difference reaches zero, you are ready to finalize.
What are reconciliation rules in Zoho Books?
Rules let you automatically categorize or flag recurring transactions based on criteria such as vendor name or transaction amount. If you have high transaction volume or predictable recurring charges, setting up rules can significantly reduce the manual work required each month during the matching and categorization steps.
Want Someone to Handle Your Zoho Books Reconciliation for You?
Zenatta’s bookkeeping team can take over the entire reconciliation process, or help you set up rules and automation to make it faster and more consistent every month.
Talk to Zenatta