Key Functions and Components
The reconciliation workflow brings together statement information, recorded cash transactions, outstanding items, and adjustment entries. Understanding these components helps users identify the correct action when a transaction does not match.
- Statement entry: Enter or verify the statement date and ending balance against the bank's official statement.
- Transaction matching: Compare cleared deposits, checks, electronic payments, and transfers with entries in Sage 100.
- Outstanding items: Track checks that have not cleared and deposits that have not yet appeared on the statement.
- Adjustments: Record supported bank charges, interest income, returned payments, and other missing transactions through the appropriate accounting workflow.
- Reconciliation reporting: Review the remaining difference, retain supporting documentation, and provide evidence for supervisory review.
The purpose is not simply to produce matching totals. Each difference should have a valid explanation, and every adjustment should be supported by transaction evidence.
How to Use Sage 100 for Bank Reconciliation
Step 1: Prepare the statement. Obtain the statement for the period being reconciled. Verify the bank account, statement date, opening balance, ending balance, deposits, and withdrawals.
Step 2: Open the reconciliation function. Navigate to the relevant bank reconciliation area in your Sage 100 configuration and select the appropriate cash account.
Step 3: Match cleared transactions. Compare each statement transaction with the accounting records. Mark the corresponding items as cleared using the options available in your version.
Step 4: Investigate unmatched items. Check for omitted entries, duplicate transactions, amount differences, incorrect account assignments, and legitimate timing differences. Record missing bank activity using the correct general ledger accounts and posting procedures.
Step 5: Review and retain the results. Confirm that the adjusted balances agree or that any remaining difference is documented according to company policy. Save or print the reconciliation report and retain the bank statement and supporting evidence.
Understand Reconciliation Differences
A reconciliation difference is the amount by which the adjusted book balance differs from the adjusted bank balance. A useful calculation is:
Reconciliation Difference = Adjusted Book Balance − Adjusted Bank Balance.
For example, assume the adjusted book balance is $42,750 and the adjusted bank balance is $42,500. The difference is $42,750 − $42,500 = $250. If investigation identifies an unrecorded $250 bank service charge, recording the expense reduces the book balance to $42,500, assuming no other differences remain.
Outstanding checks and deposits in transit should generally be treated as timing differences rather than new transactions. If the difference remains after legitimate timing items and supported adjustments are considered, review the statement details, transaction dates, posting status, and selected cash account before making further entries.
Controls for Accurate Month-End Close
A documented Bank Reconciliation Policy establishes who prepares and reviews reconciliations, how frequently they are completed, which records must be retained, and how unresolved differences are escalated. A consistent Bank Reconciliation Framework defines the sequence for matching transactions, investigating exceptions, approving adjustments, and completing the review.
Reconciliation also depends on sound general ledger practices. For example, invoice reconciliation validates invoice details against supporting purchase and receipt records before approval or posting. Separately, month-end accrual procedures ensure expenses are recognized in the appropriate period, including cases where goods have been received but the supplier invoice has not arrived. COA Accrual Structuring Tips & AI-Powered Reconciliation provides related guidance on aligning accruals with financial reporting accounts.
Automation and Connected Finance Workflows
Technology can support reconciliation by organizing transaction data, identifying exceptions, and routing items for review. The term agentic ai describes AI systems that use agents and connected tools to carry out defined tasks within established business rules.
The Hyperbots Platform supports company-specific configurations for ERP integrations, finance workflows, roles, and general ledger structures. Its Process Specific Capabilities focus on finance processes, while Ready to Deploy Capabilities include pre-trained agents and ERP connectors. Self Learning Capabilities use human feedback to refine processing, and Human in the Loop workflows allow finance professionals to review exceptions and approve actions.
Organizations researching AI-assisted finance operations may also examine AI Copilots for Sage 300 to understand how AI tools can support finance workflows in that separate Sage product. Sage 300 and Sage 100 have distinct functionality, so teams should verify compatibility and available features for their own system before applying a particular workflow.
Summary
The Sage 100 Bank Reconciliation Module helps finance teams match bank statement activity with recorded cash transactions, investigate differences, document adjustments, and verify balances. Accurate statement details, consistent transaction matching, supported accounting entries, and timely reviews improve cash visibility and financial reporting. A repeatable reconciliation process also strengthens internal controls and helps organizations complete the month-end close with greater confidence.