Bank Recap Report - Lists checks, deposits, and adjustments in the order they happened.
- You can print it anytime before deleting the Bank Reconciliation file.
- This report shows all transactions for a chosen date range.
- You can print:
- One or more transaction types.
- Only cleared, only outstanding, or all transactions.
- For each bank code, it prints:
- Transaction date, type, source, check number, and check type
- Reference, comment/payee name, cleared status, amount, and bank balance
- The report prints the number of transactions and total amount for each selected transaction type.
Bank Reconciliation Report (Register) - Lists all transactions for a chosen date range.
- The report provides a summary of reconciliation.
- The register acts as an audit record of bank activity.
- It Includes transactions from:
- General Ledger, Accounts Payable, Accounts Receivable
- Payroll, Purchase Order updates, and manual entries using Check, Deposit & Adjustment Entry
- You normally print the Bank Reconciliation report after using the Reconcile Bank.
- The reconciliation summary:
- Total all outstanding checks, deposits, and adjustments
- Shows calculated book balance up to the ending transaction date
Bank Reconciliation Process Tips Match these amounts with the bank statement summary: - Beginning balance on statement = beginning balance on Bank Recap Report
- Ending balance on statement = ending balance entered in Reconcile Bank
- Cleared items on statement = cleared items on Bank Recap Report
You can create a template such as the example below. Enter the bank information and use it to Check amounts in Sage 100. 
▼ Tip #1: Reconcile beginning balance on Bank Recap Report 
- Open Bank Reconciliation, go to Reports, then select Bank Recap Report.
- Enter the bank code only. Leave other fields blank.
- Preview the report and compare its beginning balance to the Bank Statement's beginning balance.
- If the balances don’t match, follow these steps to fix it:
- Find the difference between:
- Ending balance on last purged Bank Statement.
- Beginning balance on Bank Recap Report. (For example: If you purged May, June's Bank Statement beginning balance need to match the Bank Recap Report.)
- Tip: Always purge cleared transactions monthly after printing a balanced Bank Reconciliation Report.
- Go to Bank Reconciliation, then Main, and open Bank Code Maintenance.
- Choose the correct bank code from the lookup list.
- Write down the Current Balance before making changes.
- Adjust the Current Balance using the difference from step 5:
- If the Bank Recap Report is too low: Increase the Current Balance.
- If the Bank Recap Report is too high: Decrease the Current Balance.
- Enter the new amount and click Accept.
- Run the Bank Recap Report again and confirm the beginning balance matches the Bank Statement.
▼ Tip #4: Finalizing the Bank Reconciliation - When the out of balance amount is zero, start reconciling against the General Ledger.
- This process uses the Bank Recap Report and General Ledger Detail report for comparison.
- Print the Bank Recap Report through the last day of the month you're reconciling.
- Print the Bank Reconciliation Report through the same date.
- Answer Yes when asked, “Do you want to purge cleared documents?”
 CAUTION: Retain these copies as you can't regenerate these reports.
[BCB:155:Chat 100 US:ECB]
|
