Bank Reconciliation Process

How to: Complete a bank reconciliation.

Environment: Comsense Enterprise

In this article: 

  1. Before the Bank Reconciliation
  2. Accessing Bank Reconciliation
  3. Creating a New Bank Reconciliation
  4. Completing the Bank Reconciliation

Before the Bank Reconciliation

Before any bank reconciliations in Comsense, you must:

  • Enter any manual journal entries
    • E.g. interest charges, service fees, loans, or automatic withdrawals
  • Close all cash drawers
  • Complete any deposits
    • Especially automatic deposits
  • Have your bank statement

Accessing Bank Reconciliation

Enterprise > General Ledger > Bank Reconciliation

Click image to enlarge
Enterprise Navigation menu; shows the location of General Ledger and Bank Reconciliation.

Creating a New Bank Reconciliation

In the Bank Reconciliation window:

  1. Click New

In the Bank Account window:

  1. Select the applicable bank account
Click image to enlarge
Bank Account window; shows a selected bank accouunt and the location of the Open button.
  1. Click Open

In the Statement Date field:

  1. Enter the statement end date
Click image to enlarge
Bank Reconciliation window; shows the Statement Date field.

In the Statement field:

  1. Enter the statement end balance
Click image to enlarge
Bank Reconciliation window; shows the Statement field.

On the bank statement line items:

  1. Check the cleared checkbox for all cleared line items on the bank statement
Click image to enlarge
Bank Reconciliation window; shows all line items cleared.

Completing the Bank Reconciliation

You can only complete a bank reconciliation when all line items are cleared and the Difference field balance is 0.00. Always review the bank reconciliation before completing it because you cannot update a completed bank reconciliation.

Click image to enlarge
Bank Reconciliation window; shows all cleared line items and the Difference field at 0.00.

All incomplete bank reconciliations must remain open until all line items are cleared. Open status bank reconciliations are editable.

Click image to enlarge
Bank Reconciliation window; shows uncleared line items and a balance in the Difference field.

In the Bank Reconciliation window:

  1. Review the bank reconciliation line items

In the Status field:

  1. Select:
    1. Completed if all line items are cleared
Click image to enlarge
Bank Reconciliation window; shows the Status field drop-down list and the location of Completed.
    1. Open if there are uncleared line items
Click image to enlarge
Bank Reconciliation window; shows the Status field drop-down list and the location of Open.
  1. Click Save & Close
Have more questions? Submit a request

Comments