Client bank reconciliation with 4 balance checks

• Check the statement period, opening balance, closing balance, and remaining difference at month-end.
• In Reconciliation | Help | Zoho Books, enter the Start Date and End date of the period you would like to reconcile according to Zoho.
• Note that the opening balance cannot be edited once the transactions have been reconciled according to Zoho.
• To reconcile your accounts, make sure the Closing Balance and Cleared Amount are the same and the difference is zero according to Zoho.
• In Reconciling Your Accounts with Patriot Software, the difference must be $0 before you can continue from this page and finish your reconciliation according to Patriot Software.

Zoho documents that the opening balance cannot be edited once transactions have been reconciled.

These four checks form the editorial review structure for month-end bank reconciliation. They are not a shared four-step vendor standard but a practical sequence for verifying record integrity. The first check confirms the statement period matches the intended reconciliation window. The second verifies the opening balance aligns with the prior period’s closing figure. The third compares the closing balance against the sum of transactions and uncleared items. The fourth isolates any remaining difference for investigation without forcing agreement.

In Zoho Books, the reconciliation window requires entering the Start Date and End date of the period you would like to reconcile. This step ensures the period scope is explicit before matching begins. The same documentation notes that the opening balance cannot be edited once the transactions have been reconciled. This constraint means the opening balance must be verified before the reconciliation process is finalized. If the opening balance is incorrect, it cannot be adjusted after transactions are marked as reconciled.

A client statement covers 1 month. The opening balance is 240. You match 4 items and the statement closing balance is 280. The cleared amount is also 280, so the remaining difference is 0. On a second look, the closing balance is still 280 but the cleared amount is 240. You do not change a figure to force 0. You list the gap, search for a missing deposit, a fee, or an item dated after the statement date, and you leave the difference in place until the records support a match.

Before matching any transactions, verify the date range and the starting figure for the client’s account. In Zoho Books, the user must enter the Start Date and End date of the period they would like to reconcile, as stated in the "Reconciliation | Help | Zoho Books" documentation Zoho. This step defines the specific window of activity that the software will process. If the dates are incorrect, the reconciliation window will not align with the actual bank statement provided by the client.

Gather the statement and the prior closing figure with the Accounting Client Intake Checklist for a Clear Handoff before you enter dates.

For FreshBooks, the setup process begins with establishing the opening balance. The documentation for "How do I set up bank reconciliation?" notes that once the opening balance is set, the user can then start reconciling transactions FreshBooks. This indicates that the opening balance is a prerequisite for the matching process in this specific product. The documentation further instructs users to put the opening Date into FreshBooks' Bank Rec as their Reconciliation Start Date FreshBooks. The source provides an example where, if the statement period is July 1 to July 31, the user puts in July 1 FreshBooks. This example illustrates the mechanical input required for the start date field but does not imply that July 1 is a universal or recommended date for all clients.

The opening balance serves as the anchor point for the reconciliation. In Zoho Books, the period is defined by explicit start and end dates entered by the user. In FreshBooks, the period begins with the Reconciliation Start Date, which is derived from the statement’s opening date. Both systems require the user to manually input these date values to initiate the reconciliation workflow. The user should ensure that the dates entered match the exact period covered by the bank statement. A mismatch between the entered dates and the statement period will result in transactions falling outside the reconciliation window.

Matching the closing balance requires verifying that the Cleared Amount equals the Closing Balance. In Zoho Books, the system displays a specific subset of data during this process. According to Zoho, "Only the matched, categorized and manually added transactions will be shown in the reconciliation window." This limitation means you must ensure all relevant items are properly categorized before the final balance check occurs.

Zoho Books also defines the condition for a successful match. According to Zoho, "To reconcile your accounts, you need to make sure that the Closing Balance and Cleared Amount are the same and the difference is zero." This specific calculation serves as the final verification step within that platform's interface. You should confirm that the Cleared Amount reflects all transactions you have categorized and matched against the statement line items. The difference must resolve to zero before the reconciliation is considered complete in this system.

Patriot Software uses a different terminology for the book-side total. According to Patriot Software, "Your “Patriot Balance” is the total of all transactions in Patriot that fall on or before the Statement Date you entered above." Patriot Balance includes all transactions in Patriot dated on or before the Statement Date you entered. When comparing this balance to the bank statement, ensure the Statement Date matches the period end date on the bank document. Any transaction dated after this cutoff is excluded from the Patriot Balance calculation by design.

Missing entries often cause the closing balance to differ from the bank statement. According to Patriot Software, "If your account statement contains transactions that are not yet entered into Patriot, you will need to enter these missing deposits and withdrawals." This instruction highlights that the reconciliation process is not just about matching existing data but also about capturing new information from the statement. Review the statement line by line to identify any deposits or withdrawals absent from the software. Enter these missing items with their correct dates and amounts to bring the book balance into alignment with the bank record.

When the bank statement balance and the book balance do not match, the remaining difference requires investigation rather than immediate adjustment. In the context of Reconciling Your Accounts with Patriot Software | Patriot Software Help Center, the difference must be $0 before you can continue from this page and finish your reconciliation. Once the Difference total becomes $0, the “Continue” button will be clickable, and you may finish your reconciliation. This specific completion condition applies to that software’s interface; it does not mean you should force the numbers to align by adding unsupported journal entries. If the difference persists, it indicates that entries are missing, misdated, or misclassified.

Common causes for these discrepancies include outstanding checks, deposits in transit, bank fees, and timing differences, according to Sage. Timing differences occur when a transaction is recorded in one system in one period but appears on the bank statement in another. For example, a check written at the end of the month may not clear the bank until the following month. These items are normal and should be tracked as reconciling items, not erased. Bank fees are another frequent source of variance; the bank may deduct service charges that have not yet been entered into the accounting records.

If you have double-checked your records and believe a discrepancy is due to an error on the bank’s statement, contact your bank before making adjustments to your books, according to Sage. This step is critical because editing the closing balance or adding an adjustment merely to force agreement masks the underlying error. If the bank made a mistake, correcting it in your books without bank confirmation creates a false record. Similarly, if a client’s transaction was recorded incorrectly in the accounting software, the correction should reflect the actual transaction details, not a plug figure to make the difference zero.

The table below lists vendor-specific reconciliation rules and limits from the supplied documentation. Each row corresponds to a single publisher and cites only the facts attributed to that source.

Review each cell against the specific client’s software version before applying the rule. The FreshBooks 90-day limit is a vendor-specific maximum qualified by the bank connection partner; it is not the amount of history every bank will supply. The FreshBooks $0 balance is a documentation example for a paid-off card, not a recommended universal opening balance. Patriot distinguishes reconciliation against the actual bank statement from managing imported transactions. Sage advises that adjusted balances should match upon completion. Never edit a closing balance or add an adjustment merely to force agreement.

The four checks serve as an editorial review structure, not a shared vendor standard. Each product defines its reconciliation controls differently, so you must preserve the specific evidence provided by each platform rather than applying a uniform rule. For example, FreshBooks documentation notes that if you are setting up a credit card account, the opening balance is your Previous Statement Balance, and if you have paid off the credit card balance, this would be $0. This specific illustration is a documentation example for that product’s setup process, not a universal recommendation for every bank account or a benchmark for client data. Similarly, FreshBooks states that bank connections can pull up to a maximum of 90 days of activity, and advises checking for more details with your bank connection partner. This 90-day figure is a vendor-specific maximum for that connection feature, not the amount of history every bank will supply or a universal import window.

When reviewing the file, distinguish between the actual bank statement and imported data. Patriot Software clarifies that when talking about reconciling accounts, they are referring to matching the bank statement, not matching the bank import, which is called “managing imported transactions” in their system. This distinction matters because the reconciliation process targets the statement itself. If you treat the import as the final truth, you may miss discrepancies that only appear when comparing against the actual statement.

When the file in front of you is not the prior version, follow Workpaper recovery: 4 checks for a prior version.

Select one existing client bank statement and compare its period, opening balance, and closing balance with the reconciliation file; list any remaining difference for investigation. This practice ensures that the reconciliation is grounded in actual data rather than forced agreement.

Is matching a bank import the same as reconciling the bank statement?

No. Patriot Software distinguishes between the two processes in its documentation. When talking about reconciling accounts, the firm refers to matching the bank statement, not matching the bank import, which is called “managing imported transactions” in Patriot, according to Patriot Software.

What should we check before entering an opening balance?

Verify the statement period before setting the initial figure. In FreshBooks, the opening balance is set before starting to reconcile transactions, according to FreshBooks. Once the opening balance is set, you can then start reconciling transactions.

Why might a statement and the book balance differ?

Sage notes that the most common causes of discrepancies are outstanding checks, deposits in transit, bank fees, and timing differences, according to Sage. These items create temporary mismatches between the bank’s records and the firm’s books.

Can every vendor’s opening balance be edited after reconciliation?

No. Zoho Books states that the opening balance cannot be edited once the transactions have been reconciled, according to Zoho. This restriction prevents changes to the starting figure once the transactions have been reconciled.

Does a zero difference prove that every entry is correct?

No. Once reconciliation is complete, the adjusted balances should match, according to Sage. A zero difference indicates the adjusted balances match, but it does not prove every individual transaction is correct.