Manual Bank Reconciliation

green_left.gifgreen_right.gif

The Bank Reconciliation option in the Banking menu allows the user to perform the following operations:

Click the below links for detail.

Accessing Bank Reconciliation

Printing Bank Reconciliation Statement

Configuring Bank Reconciliation Statement

Accessing Bank Reconciliation

To access Bank Reconciliation screen,

Fig-1-Chq-Prtg-Select-Bank.gif

By default the BRS details will be sorted based on the Bank Date (if bank date is already specified for the transaction) else it will sort based on the Instrument Date.

Fig-2.2-BR-Select-Bank-BR.gif

Note:

 

The Bank Reconciliation screen can also be accessed from Gateway of Tally > Display > Accounts Books > Cash/Bank Books > Select Bank Ledger > Select a month > F5: Reconcile.

 

By default, the screen displays the period range from date specified in the Effective Date for Reconciliation in the Bank ledger master till the date of last entry.

 

The Bank Date has be to be provided based on the Instrument Date and not

on Voucher Date.

The opening BRS will be used in the following scenarios:

In these cases the user had to manually keep track of the unreconciled transaction until they are reconciled.   

To provide Opening BRS:

Fig-2.3-BR-Opening-BR.gif

Fig-2.4-BR-Unreconciled-Det.gif

The Bank Reconciliation screen is displayed with opening BRS provided as shown:

Fig-2.5-BR-with-Opening-BRS.gif

Note: When the user tries to access F12: Range for filters in the Bank Reconciliation screen, will prompt to Accept the current screen before proceeding.

Fig-2.6-BR-Filters.gif

Printing Bank Reconciliation Statement

The user may print the Bank Reconciliation statement for the required Bank.

To Print Bank Reconciliation Statement:

The Print Report screen appears.

Fig-2.7-BR-Printing.gif

Note: The options Show Forex details also and Show Forex Transactions only appear only in case Multi Currency feature is enabled for the company.

The Bank Reconciliation Statement appears as shown:

Fig-2.8-BRS-Print.gif

Configuring Bank Reconciliation

The user may configure the Bank Reconciliation screen based on his requirement.

To configure,

Fig-2.9-BR-F12-Configure.gif

Select vouchers to show:

By default, all the vouchers are displayed. Select the required Ledger Entries type from the list.

Show Narrations also:

Set this option to Yes to display the narration in the Bank Reconciliation screen.

Show Remarks also:

Set this option to Yes to display the remarks in the Bank Reconciliation screen as shown:

Fig-2.10-BR-F12-Remarks.gif

Show Forex details also:

Set this option to Yes to display the forex details also in the report.

Show Forex Transactions only:

By default, this option is set to Yes. The cheque printing screen displays only the forex transaction.

Note: The options Show Forex details also and Show Forex Transactions only appear only in case Multi Currency feature is enabled for the company.

Show Reconciled Transactions also:

Set this option to Yes to display the reconciled transactions also in the Bank Reconciliation screen.

Allow Back dated Reconciliation:

Set this option to Yes to allow reconciling back dated transactions also.

Show Payment Favouring / Received From:

Set this option to Yes to display the Payment Favouring / Received From details in the Bank Reconciliation screen.

The Bank Reconciliation screen with Narration, Remarks and Payment Favouring/Received From details is displayed, as shown:

Fig-2.11-BR-F12-Payment-Fav.gif

Note:

 

1.The Favouring Name column displays only those names which are different from the Party/Ledger account names.

 

2. Bank Reconciliation capability has been enhanced, from this screen users can

 * View the voucher display by pressing Alt + Enter from Bank Date field

 * Alter the Voucher by pressing Ctrl +Enter from Bank Date field

Show all Unreconciled Transactions Till Date:

Set this option to Yes to display all the Unreconciled Transactions till the given date, irrespective of the From date set in the Bank Reconciliation Statement.

Note:

1. This option is also available in Gateway of Tally > F12:Configure > General.

 

2.The option set will be applicable to all the banks for the selected company.

Appearance of Name:

Select the required Display Name Style from the list to display in cheque printing screen.

The completed Bank Reconciliation screen is displayed as shown

Fig-2.12-BR-F12-Payment-Fav.gif

Alteration of Reconciled Voucher

In some cases users may alter the reconciled vouchers by changing/splitting the amount, in such cases Tally.ERP 9 will display the message asking the confirmation to continue with the alteration. Users can later a reconciled voucher from Day Book, Bank Conciliation or from voucher reports.

Here ABC company is altering the voucher dated 3-7-2010 (already reconciled) where the company has issued the cheque for Rs. 1000 to Supreme Computers

Note: To alter a voucher from Bank Reconciliation report, from Bank Date field press Ctrl + Enter

The amount of 1000 has been split into 600 & 400. On saving this voucher Tally.ERP 9 displays the message indicating the reconciled voucher is altered and bank balance in BRS will not Match, hence Bank Date will be removed.

Fig-2.13-BR-F12-Payment-Fav.gif

green_left.gifgreen_right.gif