The Bank Recap Report lists checks, deposits, and adjustments in chronological order. This report can be printed at any time before the Bank Reconciliation file is purged.

• This report provides an overall picture of transactions for a specified range of dates. Information can be printed for either one or a combination of transaction types and include only cleared transactions, outstanding transactions, or all transactions. The transaction date, type, source, check number, check type, reference, comment/payee name, whether the transaction has been cleared, the transaction amount, and the bank balance are printed for each bank code. In addition, the number of transactions and a total amount are printed for each transaction type selected.

The Bank Reconciliation Report (Register) lists all transactions entered for a specified date range and provides a reconciliation summary.

• This register serves as an audit record of bank account activity and includes checks, deposits, and adjustments recorded automatically through the General Ledger, Accounts Payable, Accounts Receivable, Payroll and Purchase Order updates, and all information entered manually using Check, Deposit & Adjustment Entry. The Bank Reconciliation Report is normally printed following the use of Reconcile Bank.
• The reconciliation summary at the end of the register totals all outstanding checks, deposits, and adjustments. The calculated book balance reflects the cumulative system balance through the ending transaction date specified.

During the bank reconciliation process, it is important to reconcile to the amounts in the summary section of the bank statement.
• Beginning balance on bank statement agrees with beginning balance on Bank Recap Report.
• Ending balance on bank statement agrees with ending balance entered in Reconcile Bank.
• Cleared items on bank statement agree with cleared items on Bank Recap Report.

If you have access to Excel, it is helpful to create a template such as this. Enter the bank information and go back to this as you verify the amounts in Sage 100.

Tip #1 Reconcile beginning balance on Bank Recap Report.

1. Open Bank Reconciliation, Reports, Bank Recap Report.
2. Enter the Bank code. Do not enter any other information.
3. Preview the report and compare beginning balance on the report to the beginning balance on Bank Statement.
4. If the balances do not agree, use the following steps to correct the Beginning Balance:
5. Calculate the difference between the Bank Statement Ending Balance (for the last month that was purged in Bank Reconciliation)* and the Beginning Balance on the Bank Recap Report. (i.e. If you are working on June's Bank Rec and the last month you purged in Bank Rec was May, then the Beginning Balance on June's Bank STATEMENT should match the Beginning Balance on Bank Recap report). *Note: This step can be difficult if cleared transactions are not purged after generating a Bank Reconciliation Report that is in balance. It is strongly recommended that the transactions are purged each month.
6. Expand Bank Reconciliation, Main, Bank Code Maintenance,
7. Select applicable Bank Code from look up
8. Write down the amount in the Current Balance field before changing
9. Add or subtract the amount from step 5 (depending if the Bank Recap Report is higher or lower than the Bank Statement) to the amount in the Current Balance field, enter the adjusted amount, and click Accept.
a. If the Recap Beginning Balance is too Low: INCREASE the Current Bank Balance
b. If the Recap Beginning Balance is too High: DECREASE the Current Bank Balance
11. Run the Bank Recap Report again and verify the Beginning Balance equals the Bank Statement Beginning Balance.

Tip #2 Confirm the correct ending balance is entered in Reconcile Bank.

1. Verify that the ending balance on the bank statement matches the Ending Balance entered in Reconcile Bank.

Tip #3 Reconcile the cleared items

1. Open Bank Reconciliation, Reports, Bank Recap Report.
2. Select "Cleared Documents Only" in the Print Cleared Documents drop down.
3. Enter the bank code
4. On the Document Date line enter the end of month date for the month you are reconciling in the right hand column. Do not enter a date in the left hand column.
5. Preview the report and go to the last page of the report to the Document Type Summary for Bank Code { }.
6. Enter the total amount of Deposits cleared in the excel worksheet, or compare to the Deposits amount in the summary section of the bank statement. If a deposit is on the Bank Statement, then it must be on the cleared items only Bank Recap Report. If it is not on the bank statement, then it should not be on the cleared items report.
Note: This report can be run for deposits only, or checks and withdrawals only, to make the reconciliation process easier.
7. Compare the total amount of Checks and/or Withdrawals cleared to the Checks/Withdrawals amount in the summary section of the bank statement.
Note: Unless and until the cleared items on the bank recap report match the cleared items on the bank statement, the account will be out of balance.

Tip #4 Finalizing the Bank Reconciliation
1. When the out of balance amount is zero, the next step is reconciling to the General Ledger. This process uses the Bank Recap Report to compare to the General Ledger Detail Report.
2. See Knowledgebase Article 18015 in the Related Resources Section for help with this task.
3. Print the Bank Recap Report through the last day of the month being reconciled.
4. Print the Bank Reconciliation Report through the last day of the month being reconciled.
5. Answer yes to "Do you want to purge cleared documents?"

*****IMPORTANT: Retain these copies as these reports CANNOT be regenerated*****

DocLink: General Ledger does not balance to the Bank Reconciliation module
DocLink: Reconcile Bank is in balance but the Bank Reconciliation Report is out of balance or vice versa

[BCB:155:Chat 100 US:ECB]