Zero your bank reconciliation to start new or reconcile the first time
Description
Cause
Resolution

Clear transactions reconciled previously

  1. Select Cash Management, Transactions, Reconcile Checking Account.
  2. Use a Statement End Date and a Reconciliation Date before the actual bank reconciliation.
    For example, if reconciling July, enter June 30 as the Statement End Date and Reconciliation Date. 
  3. Enter 0.00 for the beginning and ending balance.
  4. Select Reconcile.
  5. Clear all transactions that aren't outstanding as of the last bank statement reconciled manually.

Note the Reconciliation Summary difference

  1. Select the Reconciliation Summary tab.
  2. The General Ledger shows on the right side of the Reconciliation Summary screen under OUTSTANDING.
     NOTE: The G/L Balance must be correct. If not, correct before proceeding. 
  3. Write down the Difference in Adjusted bank balance and G/L balance.
  4. Select OK to close the Reconciliation Summary.
  5. Close out of the bank reconciliation.

Enter the Statement ending balance on the first screen of the reconciliation

  1. Go to CM, Transactions, Reconcile Checking Account.
  2. Enter the Statement ending balance.
    • Enter a positive amount if the G/L difference is negative
    • Enter a negative amount if the G/L difference is positive 
  3. Select Reconcile. You’ll see an Out of balance amount.  Write down this amount.
  4. Select the Reconciliation Summary button.
  5. The Difference on the right side of the reconciliation will be zero.

Enter a bank transaction for the Out of balance amount

  1. Select CM Transactions, Enter Bank Transactions.
  2. Enter a bank transaction for the Out of balance difference.
    • Use a credit transaction if the Out of balance amount is negative
    • Use a Charge transaction if the Out of balance amount is positive
  3. Use a posting date that coincides with your bank statement you’re zeroing out.
    For example, if July is the first month you're reconciling, use a posting date in June. 
  4.  CAUTION: Uncheck Post to G/L box before posting the transaction. 

Clear the bank transaction in the bank reconciliation

  1. Go to CM, Transactions, Reconcile Checking Account.
  2. Don't change the Statement ending date, Reconciliation date, or your Statement beginning and ending balance.
  3. Select Reconcile.
  4. Locate the transaction you posted for the Out of Balance amount above and mark as cleared.
  5. Select the Reconciliation Summary button and both sides will now show 0.00 as the Difference. 
  6. Your bank reconciliation will now be in balance.

You’re now ready to reconcile your first month

  1. Go to CM, Transactions, Reconcile Checking Account.
  2. Change your Statement ending date and Reconciliation date to your first reconciliation date. 
    For example, July is the first month you're reconciling, enter July 31 for Statement ending and Reconciliation dates.
  3. Move the ending balance in to the statement beginning balance field.
  4. Enter your Bank's bank statement ending balance in the Statement ending balance field.
  5. Select Reconcile to proceed with the bank reconciliation.
[BCB:163:Chat BusinessWorks US:ECB]
Steps to duplicate
Related Solutions