Table of Contents

Overview

When bank statements are received, the bank accounts can be reconciled to find any discrepancies between the bank and the bank account transaction record in TRX Enterprise. Interest and bank charges are entered as part of the reconciliation process.

Only one bank account can be reconciled at a time and it must be completed or saved before reconciling another account. The reconciliation process can be saved and restarted so that it does not have to be done all at once.

Transaction will need to be processed in the Undeposited Funds screen. See guide Here

Create Bank Reconciliation

1. Open Bank Reconciliation screen (BNK > Bank Accounts > Bank Reconciliation)

   1. Open

      

      BNK > Bank Accounts > Bank Reconciliation

2. Click on a Blank Line or hit Add button to Start a new Bank Rec

3. Enter details

   1. Bank Account

   2. Reconciliation Date (Recon Date)

   3. Bank Statement Balance

   4. Service Charge - Bank charges that appear on the statement

   5. Interest Earned - Interest earned on the statement

** If there isn’t a blank line (or you are on an older version), click on the last bank and hit the down arrow on your keyboard to add a new one. If you are on latest, then hit the Add button

Note: The reconciliation date must be within an open General Ledger period. If it is not you will need to go to the GL >Special Functions > Period Maintenance screen and open the period by checking the open box by the period date. 

Reconciling Bank Account

After filling out the details, Click on the Edit button next to your Bank reconciliation. If you do not wish to reconcile the account press the Exit button.

Open

BNK > Bank Accounts > Bank Reconciliation

Outstanding disbursements will appear on the left side and outstanding deposits appear on the right side of the reconciliation screen both are sorted in date order.

• Click on the checkbox next to items that appear on the statement to clear them or use the Clear Thru buttons and boxes to speed checking items. The Cleared Balance and Difference between the account and the statement are automatically calculated as items are marked as cleared.

• Once the difference is zero, the account is in balance with the bank statement. Press the finish icon. The Reconciliation report is printed and the interest and bank charges are ready to be posted to the General Ledger via the Post Banking to General Ledger screen.

• Use the Print Report button to print the Account Reconciliation report.

• To exit the reconciliation process without completing it, click on the Exit button on the toolbar. Another account cannot be reconciled until the current account is finished.