Reconciling bank accounts

Use this procedure to reconcile deposits and disbursements with a bank statement. You can reconcile transactions with a bank statement before or after you close the period.

  1. Select Bank Statements .
  2. Click Create.
  3. Select a School and a Bank Account.
  4. Specify this information:
    Bank Statement
    Specify the bank statement number.
    Statement Date
    Select the bank statement date.
    Statement Ending Balance
    Specify the amount for the statement ending balance.
  5. Click Save.

    The beginning balance is based on the last period ending balance.

    Transactions that are available to be reconciled are displayed on the Unreconciled Transactions tab.

  6. View unreconciled transactions and select the Reconcile button to move it into the reconciled transactions list.

    You can either reconcile on the Bank Statement form or close the form and use the Bank Reconciliation tab on the Cash Processing page. The Bank Reconciliation tab shows both reconciled and unreconciled transaction on the same page. You can view summary information on the Bank Reconciliation tab.

  7. Optionally, add bank transactions, such as fees or credits.
    1. Select Add Bank Transaction button.
    2. Specify this information:
      Transaction Number
      Specify the transaction number.
      Transaction Date
      The current date defaults, you can override the date.
      Amount
      Specify the amount of the transaction.
      Amount Type
      Select either bank debit or bank credit transaction.
      Description
      Provide the description for the bank transaction.
    3. Click Submit.
  8. Optionally, you can add or adjust the beginning balance.
    1. Select Actions > Update Beginning Balance.
    2. Specify the beginning balance amount and click Submit.
  9. Click Release if the bank statement reconciliation is completed.

    You cannot release a bank statement until the statement is fully reconciled. That is, the value in the Difference field must be zero.