To reconcile bank statements, compare what is recorded in your accounting software with the transaction on your bank statement, according to Patriot Software.
Key takeaways for how to reconcile bank statements in accounting software
- Select the right import format: If your bank offers none of the other options, use *.csv format for manual imports, according to Manager.
- Connect accounts for feeds: Once you add an account from the list of banks available, you will receive bank feeds to your Zoho Books account by default, according to Zoho.
- Enter the correct balance: You must enter the Closing Balance of your bank account, as instructed by Zoho.
- Verify zero differences: To reconcile your accounts, you need to make sure that the Closing Balance and Cleared Amount are the same and the difference is zero, according to Zoho.
- Finalize the record: After you finish reconciling your account, click Reconcile to finish the process, as noted by Zoho.
How to prepare your bank statement for import
Select the correct file format before uploading your statement to your accounting software. According to Manager, use *.csv format only if your bank offers none of the other options. This rule applies specifically to the import process described in the Manager guide for bank statements. If your bank provides other export formats, choose one of those instead of defaulting to CSV. The format you select determines how the software reads the transaction data, so matching the available options is a practical first step. For more, see manual bank import formats and date settings.
Set your date range to cover the exact period you want to reconcile. PracticePanther explains that for a trust account reconciliation for April 2025, the start date could be 4/1/2025 and the end date would be 4/30/25. This example shows how to define the boundaries of the statement period you are importing. When preparing your own statement, align the start and end dates with the specific month or period you are reviewing. This ensures the imported data matches the timeframe you intend to verify against your internal records.
Before you begin the import, confirm that your statement file contains the transactions for the selected date range. Check that the file is not corrupted and that the column headers match what your software expects. If you are using a manual import, review the file in a spreadsheet program first to verify the data structure. This preparation step reduces the chance of import errors that would require re-downloading the statement. Keep the original bank statement document available for reference during the reconciliation process.
Setting up automatic bank feeds and connections
Connecting your bank account to your accounting software allows you to fetch bank statements automatically, provided your bank supports this feature. Zoho states that if your bank supports bank feeds, you can use the bank feeds feature in Zoho Books to fetch your bank statements automatically. This capability depends on the specific banking institution you use, so you should verify whether your bank is included in the list of available banks before attempting to set up a connection.
When you add an account from the list of banks available, you will receive bank feeds to your Zoho Books account by default, according to Zoho. This default behavior simplifies the initial setup process for users whose banks are already integrated into the platform.
Zoho Books uses Plaid to connect your bank accounts, a service that lets you fetch your bank feeds from your bank and sync them with Zoho Books, as described by Zoho. This integration facilitates the synchronization of transaction data between your financial institution and your accounting records. The use of a third-party service like Plaid helps streamline the data transfer process, ensuring that your bank feeds are retrieved efficiently.
A critical requirement for automatic feed fetching is authentication. Unless the authentication is cleared, the bank will not allow Zoho Books to fetch the feeds automatically, as noted by Zoho. You must complete the authentication process to grant the software permission to access your account data.
To set up this connection, start by navigating to the banking section of your accounting software. Select the option to add a new bank account and choose your bank from the available list. Complete the authentication prompts to authorize the connection. Once authenticated, the software will begin fetching your bank feeds automatically. If your bank is not listed, you may need to use a manual import method instead, which involves downloading a statement file and uploading it to the software. For a comparison, see bank statement import rules across apps.
Matching transactions and adjusting records
Once you have imported your statement or connected your feed, the core task is aligning your internal records with the bank data. In Patriot Software, the software displays all recorded transactions for that account with dates on or before your statement date that have not previously been accounted for in a bank reconciliation. You will be checking off all transactions that are a match, and reviewing any that are not so your accounting entries align with your bank statement. Cleared entries are matched line by line against the bank document, while legitimate outstanding transactions may stay unmatched because of timing differences.
For legal professionals using trust accounts, PracticePanther advises accessing an up-to-date version of your bank account history from your bank and reviewing your records in PracticePanther alongside them. This side-by-side review allows you to identify mismatches between your software records and the bank's official record. When a transaction in your software does not appear on the bank statement, or a bank item is missing from your software, investigate before changing anything: correct actual errors or omissions, and keep valid outstanding transactions as they are.
To perform this matching effectively, follow these steps:
- Identify unmatched items: Scan the list of transactions provided by your software. In Patriot Software, these are the entries with dates on or before the statement date that have not been previously reconciled.
- Verify matches: Check off each transaction that appears identically in both your software and the bank statement.
- Investigate discrepancies: If a transaction amount or date differs, find the cause first, and correct the entry only if it is a confirmed recording error.
- Review alongside the bank record: As recommended by PracticePanther, keep the bank's up-to-date account history visible while you review your software records to catch any omissions.
Do not assume that a small difference is automatically a timing issue; verify each item against the source document. If a transaction is missing from your software, add it manually. If it is missing from the bank statement, investigate whether it is a pending item or an error. The goal is to make your accounting entries align with your bank statement, as stated by Patriot Software.
Illustrative example: a $50 gap
Suppose the statement shows a closing balance of $320, but your software shows $270. The $50 gap could come from a deposit that the bank has credited but you have not yet recorded. Check the statement line by line. If the deposit is genuine, record it. If an item is valid but has not cleared, leave it unchanged. Once the cleared amounts agree, the difference is zero.
Reconciliation features by publisher
The table below lists specific reconciliation rules and features documented by five publishers. Each row cites the source that states the rule, keeping the guidance tied to the named platform.
| Publisher | Reconciliation Feature or Rule | Source Detail |
|---|---|---|
| Patriot Software | Definition of reconciliation | Patriot Software states that reconciling accounts is comparing what is recorded in the software with the transaction on your bank statement. |
| Sage | Example balance discrepancy | Sage provides an example where the bank statement shows a closing balance of $14,200, but the internal books show $12,850. |
| Zoho | Default bank feed setup | Zoho notes that once you add an account from the list of available banks, you receive bank feeds to your Zoho Books account by default. |
| Manager | Fallback file format rule | Manager advises using *.csv format only if your bank offers none of the other options. |
| Zoho | Entering closing balance | Zoho instructs users to enter the Closing Balance of your bank account during the process. |
| PracticePanther | True reconciliation availability | PracticePanther confirms that true bank reconciliation is available in PracticePanther. |
Review each row to identify which specific rule applies to your current software setup.
Verifying the final balance and closing the process
Once you have matched your transactions, the final step is to confirm that your internal records align with your bank statement. In Zoho Books, you begin this verification by entering the Closing Balance of your bank account directly into the software. This specific figure serves as the baseline for your final check.
To complete the reconciliation in Zoho Books, you need to make sure that the Closing Balance and Cleared Amount are the same and the difference is zero. If these two figures do not match, the process is not yet finished. You must review any remaining unmatched items until the discrepancy is resolved.
Sage illustrates this concept with a practical example where the original $1,350 difference between the bank statement and the company’s books was fully explained by timing differences and transactions that had not yet been recorded internally. In their scenario, both adjusted balances now match at $13,800, confirming that the reconciliation is complete. This demonstrates that a zero difference is the definitive indicator of a successful match.
After you finish reconciling your account in Zoho Books, click Reconcile to finish the process. Before you click this button, take a moment to review your work. Ensure that every transaction on the statement is either matched or a known outstanding item.
If you are using a different platform, the specific button labels may vary, but the underlying requirement remains the same. Confirm that the reconciled balance accounts for the opening balance, the cleared transactions and any reconciliation adjustments, since the cleared total alone need not equal the ending balance. Do not proceed until you are confident that the numbers align. A small error now can create confusion in your financial reports later.
Your next step: download your latest bank statement and compare its closing balance with the balance shown in your accounting software.
FAQ: how to reconcile bank statements in accounting software
What is the difference between managing imported transactions and reconciling accounts?
Managing imported transactions handles how bank data enters your system, while Patriot Software describes reconciling as checking your records against the bank statement.
Which file format should I use if my bank does not offer specific export options?
Manager advises using the *.csv format only if your bank offers none of the other options. This serves as a fallback when specific bank-supported formats are unavailable for manual statement imports.
How do I know if my bank reconciliation is complete?
The reconciliation is complete when the Closing Balance and Cleared Amount match and the difference is zero, as Zoho states. Once these values match, you can click Reconcile to finish the process.
What should I do if the closing balance in my software does not match the bank statement?
Investigate the difference before you finalize, because Sage notes that timing differences and unrecorded transactions can explain it. Both adjusted balances must match to confirm completion.
Can I reconcile accounts if my bank does not support electronic feeds?
Yes, you can still reconcile through manual import, since Zoho allows automatic fetching only if the bank supports feeds. If your bank does not support electronic feeds, manual import is the alternative method for bringing statements into your accounting software.