Welcome To Axapta.

User Manual

14.3. Bank reconciliation

Bank reconciliation:

Reconciling is the process of comparing the cash activity in your accounting records to the transactions in bank statement.

Reconciliation is important to make sure that the cash account and the bank account balances match.

Path:

1.       Navigate to Bankà Common forms à Bank Accounts Details.

       2. Select the required bank account to reconcile.

2.    Click the Functions button and select Account reconciliation.

3.    Then Bank account statement form will open, Fill the required details as shown below.

4.       Enter bank statement date in Bank account statement date field.

5.       Enter the statement description in bank statement field.

6.       Select the required currency in currency field and give the ending balance amount as per the bank statement in ending balance field.

7.       Click on Transaction button.

8.       Account reconciliation form will open with the transactions.

9.       Cutoff date will be bank statement date which is entered.

10.   Show transactions filter allows to filter or show Reconciled, Unreconciled and All the transactions.

11.   Select unreconciled transactions it will show all the unreconciled transactions as per the bank.

12.   Opening Balance shows the previous month ending balance as opening for the current statement. 

13.   Balance as per books shows balance as per company books. 

14.   Balance per Bank shows the ending balance of the statement. 

15.   Once bank clearance date is entered as per bank statement in Bank date field, system will automatically mark the Cleared checkbox.

16.   Once all the transactions are cleared, unreconciled balance will become zero. 

17.   Once unreconciled balance becomes zero, Reconcile account button will be enabled.

18.   Click on Reconcile account button in order to reconcile the account.