Core Accounting and Financials
Sage 100 Bank Reconciliation
Home » ERP Resources » Sage 100 Resources » Sage 100 Bank Reconciliation
Each month, like clockwork, bank statements and canceled checks arrive, setting off a tedious reconciliation process. You sort checks, account for deposits, and compare your account balances to those of the bank. If only it ended there. Discrepancies can initiate an irritating and time-consuming search for the differences before your statements can be reconciled and filed— then it all begins again.
The Bank Reconciliation module for Sage 100 ERP (formerly Sage ERP MAS 90 and 200) automates and simplifies the monthly reconciliation process, detects unrecorded transactions between books and banks, locates the errors and differences, records the corrections, and reconciles your books to the bank statements, all in a solution that is easy to use and implement.
Even more important, Bank Reconciliation gives you insights behind the numbers to better manage and direct cashflow, helping you to view and forecast cashflow activities with registers, reports, and analyses. You can project an estimated cashflow when you link it to your Accounts Receivable, Accounts Payable, Payroll, and Purchase Order modules.
The many features of the Bank Reconciliation module enable the use of multiple bank accounts, automatic and manual posting of checks, adjustments and deposits, quick and easy account reconciliation, complete transaction listings and details, and more.
Powerful yet simple to use, Bank Reconciliation gives you the ability to efficiently manage reconciliation activities today and helps you make better business decisions for the future with cashflow analysis and forecasting.
“We process nearly 1,000 checks every month. By automating the reconciliation task, we’ve freed up countless hours on each statement for our accountant.”
Elizabeth Johnson-Stevens, special projects coordinator Salutary SportsClubs, Inc.
BENEFITS
- Deter check fraud using Positive Pay
- Reconcile multiple bank accounts
- Analyze estimated cashflow
- Automatically reconcile check information
- Control who can access and adjust balance entries
- Retain or purge detail after reconciliation
- Make one-step bank transfers from the General Ledger
- Use up to 2,048 characters for comments on adjustment entries
REPORTS
The Bank Reconciliation module features streamlined bank statement reconciliation and insightful reports, including:
- Bank Reconciliation Register
- Bank Transaction Recap Report
- Estimated Cashflow Analysis
Features
MULTIPLE BANK ACCOUNTS
RECONCILE BANK ACCOUNTS
BANK RECONCILIATION REGISTER
All transactions, cleared and outstanding, are listed on this detailed report for each bank account. The Reconciliation Summary shows the adjusted bank balance, computer-calculated book balance, and any out-of-balance amount.
CASHFLOW ANALYSIS
The Estimated Cashflow Analysis Report combines information from the Accounts Receivable, Accounts Payable, and Purchase Order modules to provide an overall cash flow projection for four consecutive periods.
CHECK AND DEPOSIT ENTRY
Transactions not posted automatically through the other integrated modules can be entered manually. Checks, deposits, and adjustments for nonintegrated bank accounts can also be entered manually.
BANK ACTIVITY DETAIL
Bank transaction detail can be retained indefinitely or cleared each month after each account is reconciled.
Want More Core Accounting and Financials Information?
Experience the depth, functionality, and ease of use that Sage ERP offers. Provide an accounting foundation for your business that optimizes your productivity.