Preparing a Bank Reconciliation
Note: For A/R transactions, after a
payment by check is received for an invoice, you must manually enter the payment in the
Bank Reconciliations form. You must enter and
post customer checks individually. When each payment is reconciled with the bank
statement, the system credits the VAT A/R Received account. For A/P transactions, after
a processed check is reconciled with the bank, the system debits the VAT A/P Paid
account.
Use the buttons on the form as described here:
- Click Bank Addresses form with the bank address information displayed for the currently selected bank code. to open the
- Click to mark the selected records as reconciled, setting the reconcile date to the "As Of" date value. This button is only enabled when the starting and ending balances match. New entries can be created in the grid for adjustment transactions to get the starting and ending balances in line.
- Click to mark the selected records as reconciled.
- Click to mark all records in the grid as selected.
- Click to remove the selected check on each record in the grid.
For each row of the grid, if the Service Management amount is different than the amount shown by the Bank statement, the Adjustment Account can be populated. Upon reconciliation and adjustment, an entry is created and posted to the journal for the difference between the two amounts. But, adjustment accounts are no longer required for records out of balance; they can be selected to enable the button to reconcile valid records. The invalid records are ignored during posting and remain as unreconciled after the routine finishes.