This resolution includes reconciliation information and procedures that are not supported by Sage Support. For assistance with reconciliation, contact your certified consultant.

The term "reconcile" has two definitions in Cash Management as follows:

• The verification and correction of bank account balances that are incorrect.
• The monthly comparison of your paper bank statement to the bank transactions recorded in Cash Management.

The solution below is in regards to the first definition.

Due to the complexity of reconciliation issues, contact your certified Sage Sage 300 Construction and Real Estate Office consultant for assistance. Use the appropriate report below, based on your installed CD version, to verify and correct your Cash Management bank account totals. Create a backup of your entire data folder before you proceed.

Note: The solution below makes two assumptions:

• That your Last reconciled balance is correct and that it matches your bank statement ending balance for the last bank statement that you reconciled.
• That you have verified that the items on your Reconciliation Worksheet (Reports > Worksheet > Reconciliation Worksheet) are correct for your bank account.

1. Have all other users exit all Sage Sage 300 Construction and Real Estate Office applications.
2. Download the Bank Account Balance Verification report attached below. See the link below for more information on how to download and print a report.
3. Click [Print Preview] or click [Start] to print the report to a file or printer.
   Note: For the 8.x version of the report, click [Ranges] and select the bank account that you want to reconcile before printing or previewing the report.
4. Review the report to verify your bank account balances are correct as follows:
   • Verify the Derived Bank Balance equals the Bank Account Bank Balance.
   • Verify the Derived Posted CM Balance equals the Posted (CM) Balance.
   • Verify the Derived Register Balance equals the Register Balance.
   • Verify the Open Derived amounts equal the Open from Bank Account amounts.
   • Verify the Unreconciled Derived amounts equal the Unreconciled from Bank Account amounts.
5. If all the amounts equal then your bank account balances match your transactions. You do not need to proceed further.
6. If any totals do not match, then turn on Audit setup activity and correct the totals on your bank account using the derived balances from the Bank Account Balance Verification report as follows:
   Note: See the link below for more information on how to use Audit setup activity.
   1. In Cash Management, from the Setup menu, select Bank Account.
   2. Click [Start] to print the audit report to a file or printer.
   3. In the Bank account list, select your bank account.
   4. On the General tab, replace the Register balance with the Derived Register Balance.
   5. On the General tab, replace the Bank balance with the Derived Bank Balance.
   6. On the Totals by GL Cash Acct tab, replace the Posted (CM) Balance and Amount with the Derived Posted CM Balance.
   7. If you use multiple cash accounts with your bank account, you may have multiple cash accounts and amounts on the Totals by GL Cash Acct tab. Determine the correct amount for each cash account and adjust the amounts for each account accordingly. Delete any lines with blank cash accounts. When you finish, the amounts for each cash account should sum to the Posted (CM) Balance.
   8. On the Totals tab, replace each of the various open amounts with the appropriate Open Derived amounts.
   9. On the Totals tab, replace each of the various unreconciled amounts with the appropriate Unreconciled Derived amounts.
   10. Press ENTER to update the Open total and Unreconciled total after you correct the appropriate open and unreconciled amounts.
   11. Click [Close] and then turn off Audit setup activity.