Prepare Bank Records and Statement Details
Before starting, obtain the bank statement for the period and confirm the statement ending date and balance. In Sage 100, identify the corresponding cash account and review the transactions recorded for that account. Confirm that deposits, checks, electronic payments, bank fees, interest, and transfers have been entered in the appropriate period. Also check that transactions from connected systems have been imported or posted as expected.
Keep the bank statement and supporting records available while reconciling. If the company uses multiple bank accounts, verify the account number and currency before beginning each reconciliation. The general ledger's chart of accounts should map each bank account to the correct cash account, with separate accounts where needed for fees, interest, and other bank activity. Tax-related transactions should also use the appropriate accounts so that tax validation and tax compliance reviews remain consistent with the company's accounting policies.
Match Transactions in Sage 100
Open the bank reconciliation function available in your Sage 100 version and select the correct cash account. Enter the statement date and ending balance as shown on the bank statement. Review the listed transactions and mark items that appear on both the statement and Sage 100 records. Match amounts, transaction dates, check numbers, payment references, and deposit details rather than relying on amount alone.
Deposits recorded in Sage 100 may appear on a later bank statement if they were made near the statement cutoff. Likewise, issued checks and electronic payments may remain outstanding until the bank processes them. These timing differences should be reviewed and tracked, not treated automatically as accounting errors. A completed Bank Reconciliation provides evidence that the book balance has been compared with the bank's records and that outstanding items have been identified.
Investigate Differences and Record Adjustments
When the reconciliation does not balance, examine unmatched transactions and compare them with bank documents, receipts, payment confirmations, and general ledger details. Common causes include bank service charges not yet recorded, interest credits, duplicate entries, incorrect amounts, missing transactions, and posting to the wrong cash account. Correct the underlying transaction or enter an approved adjustment using the company's normal accounting controls.
For example, assume Sage 100 shows a cash balance of $24,850 while the bank statement shows $26,100. The statement includes a $1,500 deposit in transit and an outstanding check of $400. The adjusted bank balance is $26,100 + $1,500 - $400 = $27,200. Since this does not equal the book balance of $24,850, the accountant should investigate additional differences, such as unrecorded bank activity or missing entries, rather than forcing the reconciliation to balance. This calculation illustrates how reconciling items explain the gap between bank and book balances.
Review, Complete, and Retain the Reconciliation
Before completing the process, review the reconciliation summary and confirm that the statement date, ending balance, cleared transactions, and remaining difference are correct. Follow the instructions for your Sage 100 release to finish or update the reconciliation, and retain the reconciliation report and supporting statement according to company policy. If a correction is needed after completion, follow the documented procedure for your version instead of changing historical transactions without review.
Organizations that connect Sage 100 with other finance applications should verify that transfers and posted transactions reach the intended accounts. Sage Intacct Integration is an example of an ERP integration concept in which financial data moves between systems; it is not a Sage 100 menu or a required step in this reconciliation process. For other ERP environments, Keep Your GL Codes Aligned in Any ERP System discusses the importance of consistent account mapping across connected finance workflows.
Use Automation While Preserving Review
Finance teams can standardize recurring reconciliation activities with documented procedures, consistent transaction references, and defined approval responsibilities. The Hyperbots Platform supports finance workflows through ERP integration and company-specific configuration. Process Specific Capabilities can align AI assistance to finance tasks, while Ready to Deploy Capabilities provide pre-trained agents and ERP connectors for suitable workflows.
Self Learning Capabilities allow AI systems to adapt based on human feedback, and Human in the Loop processes retain human review for exceptions and approvals. These capabilities can complement established controls by helping organize supporting information and route items for review. They do not replace verification of bank statements or the need to follow Sage 100's version-specific instructions. Detail Accounts Finance is also relevant when understanding how detailed ledger accounts support accurate transaction classification and financial reporting.
Summary
To reconcile bank accounts in Sage 100, select the correct cash account, enter the bank statement details, match cleared transactions, investigate differences, record approved adjustments, and review the reconciliation summary. Retain the supporting statement and report for audit purposes. Consistent reconciliation helps maintain reliable cash balances, identify unrecorded bank activity, and strengthen the accuracy of financial reporting.