Skip ahead to the main page
Partner Huddle
Pages

Bank reconciliation: 8 checks before client sign-off

Partner Huddle Editorial Team · Published · 10 min read

Reconciling accounts means comparing what is recorded in the accounting software with the transaction on your bank statement, according to Patriot Software.

Key takeaways for reconciling client bank accounts

  • Verify that book balances match account balances by matching bank transactions to entries, as FreshBooks defines the core reconciliation task.
  • Treat the reconciliation as complete only after transactions are matched and both adjusted balances match, a state Sage identifies as the final verification point.
  • Enter any missing deposits or withdrawals found on the statement so the difference becomes $0, a requirement specified by Patriot Software.
  • Apply these procedures to asset, liability, and equity accounts, which Patriot Software lists as reconcilable account types for accounting customers.

Bank reconciliation ensures client books match bank statements before tax work begins

The core task is verifying that internal records match external bank data. Patriot Software states that ideally, your balances in the software should agree with your external account balances and reports, so that you are fully tracking all of your transactions, according to Patriot Software. Matching balances supports reconciliation, but it does not prove that every transaction is recorded, so transaction-level checks are still needed.

When discrepancies appear, the goal is to eliminate the gap. Recording the missing items ensures the accounting records reflect the actual bank activity.

For small firms, Reconciliation can be a recommended step in the monthly close. It provides a clear check that the client's financial position is accurate before tax work begins. The reconciliation acts as a control to catch errors early.

To start, open the client's bank statement and the corresponding account in your software. Compare the totals to identify any differences. Enter any missing transactions to bring the difference to zero. Do not treat the account as reconciled until transactions are matched and timing differences are accounted for. For a related check on balances, see Client bank reconciliation with 4 balance checks.

Reference table: bank reconciliation steps by software publisher

The table below lists eight reconciliation checks drawn from the vendor documentation of four software publishers. Each row names the publisher and quotes the specific step or definition from its documentation. Use this as a quick reference before you sign off on a client’s books.

PublisherKey Reconciliation Step or Definition Source Quote
Patriot SoftwareReconcile asset, liability, and equity accounts "As an accounting customer, you can reconcile your asset, liability, and equity accounts with Patriot Software."
Patriot Software Navigate to the reconciliation tool"In Patriot Software, go to Accounting > Financial Tasks > Reconcile Accounts."
FreshBooks Set the reconciliation start date"Choose any date within the statement period and put this into FreshBooks’ Bank Rec as your Reconciliation Start Date"
FreshBooks Identify the starting amount"On the statement, find the Previous Balance and use this as your starting amount to calculate from"
Zoho Define the reconciliation goal "In Zoho Books, you can reconcile an account to ensure that the transactions in your bank account match with the transactions you’ve created in Zoho Books."
Zoho Choose the reconciliation period"You can also choose the period for which you would like to reconcile an account."
ZohoEnter the closing balance "Enter the Closing Balance of your bank account."
SageConfirm reconciliation completion "Both adjusted balances now match at $13,800, confirming that the reconciliation is complete."

These steps come directly from the vendors’ own documentation. According to Patriot Software, the platform supports reconciliation for asset, liability, and equity accounts. According to FreshBooks, the setup process involves selecting a start date and identifying the previous balance. According to Zoho, the process ensures bank transactions match those created in the software. According to Sage, completion is confirmed when adjusted balances match.

Review each row against your client’s specific software platform. If your firm uses a different tool, locate the equivalent steps in that vendor’s help center. The goal is to verify that every balance is accounted for before you move to the next client. Keep this table handy during your monthly close to ensure consistency across all accounts you manage.

How to bring bank transactions into the software

To begin reconciling a client’s bank account, you need its transactions in the accounting software. FreshBooks offers two methods for getting them there. According to FreshBooks, bank reconciliation can be done by connecting directly to a bank through a bank connection. Alternatively, the same source notes that you can create a bank account and upload CSV files to it manually. This manual upload option serves as a fallback when a direct bank connection is unavailable or unsupported for a specific client’s financial institution.

Zoho Books also provides a mechanism for handling bank transactions. According to Zoho, you can reconcile your bank account in Zoho Books. The platform supports the reconciliation workflow once transactions are present in the system. For firms using multiple software platforms, it is essential to verify the specific connection capabilities of each tool before initiating the monthly close process.

When choosing between a direct bank connection and a manual CSV upload, consider the client’s banking environment. Check whether a direct connection is available for the client’s bank. If it is not, the manual CSV upload method described by FreshBooks is one supported alternative. Ensure that the CSV file format matches the requirements of the specific software version you are using to avoid import errors.

Remember that getting transactions into the software comes first. Without bank transactions in the software, there is nothing to match, so prepare them using one of the two FreshBooks methods above. Verify that the bank account is correctly set up in the software before attempting to import transactions. This setup phase is critical for maintaining the integrity of the client’s financial records. For the bank feed side, see Bank feed checks: 8 items for client reconciliation.

Open your client's bank statement and the corresponding account in your accounting software to begin comparing balances.

How to set opening and closing balances for reconciliation

Selecting the correct start date is the first procedural step in the reconciliation process. In FreshBooks, you choose any date within the statement period and put this into the Bank Rec as your Reconciliation Start Date, such as July 28, according to FreshBooks. Once the start date is selected, you must identify the previous balance to use as your baseline. On the statement, find the Balance or Amount one day before the date you chose; for example, if you chose July 4, look for the balance next to July 3, or the next row above it if the next available transaction is older than July 3, according to FreshBooks. This previous balance serves as the starting amount for your calculations.

For platforms that require explicit period selection, the setup process involves defining the timeframe before entering balances. In Zoho Books, you can also choose the period for which you would like to reconcile an account, according to Zoho. After establishing the period, you must input the final figure from the bank statement. In Zoho Books, enter the Closing Balance of your bank account, according to Zoho. This closing balance represents the end state of the account for the selected reconciliation period.

How to match transactions and resolve differences

The core of reconciliation is comparing the transactions recorded in the client’s internal books against the transactions listed on the bank statement. When these two records do not align, the difference must be identified and explained before the account can be considered accurate. In the example provided by Sage, the bank statement shows a closing balance of $14,200, but the company’s internal books show $12,850, according to Sage. This discrepancy highlights the need to review each line item to determine why the figures differ.

To resolve such differences, you must identify items that have not yet been recorded in the internal books or transactions that the bank has not yet processed. In the Sage example, 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, according to Sage. This indicates that the variance is not necessarily an error but often a result of timing gaps between when a transaction occurs and when it is recorded in each system.

Once these timing differences and unrecorded transactions are identified and accounted for, the balances should be adjusted to reflect the true financial position. In the Sage scenario, both adjusted balances now match at $13,800, confirming that the reconciliation is complete, according to Sage. This matching of adjusted balances serves as the validation that the reconciliation process has successfully resolved all discrepancies.

For your own client accounts, apply this same logic of identifying timing differences and unrecorded items. Compare the bank statement line by line with the internal books, noting any transactions present in one but not the other. Adjust the internal books for any transactions that should have been recorded but were missed, and note any bank-side items that are pending. Continue this process until the adjusted bank balance and the adjusted book balance are identical. If the balances do not match after accounting for all known timing differences, re-examine the transaction list for omitted or duplicated entries. The goal is to reach a state where the adjusted balances match, confirming that the reconciliation is complete.

Illustrative example: a 10 difference

Suppose a client’s bank statement shows a closing balance of 100, while the software shows 90. The difference is 10. If the statement includes a 10 deposit that is missing from the software, entering that deposit makes the difference 0, so both balances read 100. Before you sign off, still compare the individual transactions for timing differences, because matching totals alone does not prove every transaction is recorded.

As a next step, pick one client account today and compare its bank statement with the matching account in your software.

Related guides: Review 8 CP2000 details before sending client replies.

FAQ: Common questions about client bank reconciliation in small firms

What is the first step in reconciling a client's bank account in Patriot Software?

In Patriot Software, the process begins by navigating to Accounting > Financial Tasks > Reconcile Accounts, according to Patriot Software. This specific menu path directs users to the reconciliation interface within the platform.

How do I set the reconciliation start date in FreshBooks when doing manual bank reconciliation?

Choose any date within the statement period and enter it as the Reconciliation Start Date in FreshBooks’ Bank Rec, according to FreshBooks. The documentation provides July 28 as an example of a valid date selection for this field.

What does reconciliation check in Zoho Books?

Reconciliation in Zoho Books checks that the transactions in your bank account match the transactions you have created there, according to Zoho. This verification step confirms alignment between external bank records and internal software entries.

What does a completed bank reconciliation look like in Sage when adjusted balances match?

A completed reconciliation is confirmed when both adjusted balances match, as illustrated by a figure of $13,800 in the example, according to Sage. The equality of these adjusted figures indicates the reconciliation process is finished.

How can I import bank transactions manually in FreshBooks?

You can create a bank account in FreshBooks and upload CSV files to it manually, according to FreshBooks. This manual upload method serves as an alternative to direct bank connections.

Sources