Free Online Tally.ERP9 Help & Tutorial : www.tallyerp9help.com
 

Manual Bank Reconciliation in Tally.ERP9

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

  • Reconcile Bank accounts.

  • Create vouchers from the Bank Reconciliation screen itself.

  • The user can also provide opening BRS for unreconciled transactions.

  • Alter the voucher by selecting the required transaction from the Bank Reconciliation screen.

  • Filter the report to display transactions based on Amount, Bank Date, Instrument No, Instrument Date, Party ledger, etc.

  1. Accessing Bank Reconciliation

  2. Printing Bank Reconciliation Statement

  3. Configuring Bank Reconciliation Statement

  4. Configuring Bank Reconciliation Statement

1. Accessing Bank Reconciliation

To access Bank Reconciliation screen,

  • Go to Gateway of Tally > Banking > Bank Reconciliation

  • The Select Bank screen displaying the List of Bank appears as shown:

Accessing Bank Reconciliation in Tally.ERP9

  • Select the required Bank account from the List of Bank and press Enter.

The Bank Reconciliation screen of the selected Bank appears. By default the details in the Bank Reconciliation screen are sorted based on Bank Date (if bank date is already specified for the transaction). Or else, such sorting will be based on the Instrument Date.

Accessing Bank Reconciliation in Tally.ERP9

Note:
1. 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.
2. 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.
3. The Bank Date has be to be provided based on the Instrument Date and not on Voucher Date.

Button Options in Bank Reconciliation Screen

F2: Period

PressF2key or clickF2: Periodto specify a period for which the Bank Reconciliation screen is to be displayed.

S: Set Bank Dates

To set a bank date for all the transactions for reconciliation, clickS: Set Bank Datesbutton or pressAlt+Skey.

On pressingAlt+S, aSetBank Datesub-screen appears as shown:

Accessing Bank Reconciliation in Tally.ERP9

  • Instrument Date: On selecting Instrument Date as the Bank Date Type, the Bank Date field for all the transactions in the Bank Reconciliation screen is filled with the instrument date entered for that transaction in the Bank Allocations screen.

  • New Date: On selecting New Date as the Bank Date Type, a new field Date appears in the Set Bank Date sub-screen.

Accessing Bank Reconciliation in Tally.ERP9

Specify the required bank date that is to be filled for all the transactions in the Bank Reconciliation screen.

  • Voucher Date: On selectingVoucher Dateas theBank Date Type, theBank Datefield for all the transactions in the Bank Reconciliation screen is filled with theDate of Voucher.

C: Create Voucher:

PressAlt+Ckey or clickC: Create Voucherto create a voucher from the Bank Reconciliation screen itself.

U: Opening BRS

In Tally.ERP 9 Series A Release 3.0 onwards the user may provided opening BRS to the unreconciled transactions using this function.

The opening BRS will be used in the following scenarios:

  • The BRS feature was used in the middle of the financial year by settingEffective Date of Reconciliationin Bank ledger master in Tally.ERP 9, or

  • Accountingwas started in Tally.ERP 9 in the middle of the financial year.

  • Openingbalanceof Bank havingunreconciled transactionsbrought forward to Bank ledgercreated inTally.ERP 9, or for other reasons.

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

To provide Opening BRS

  1. ClickU: Opening BRS.

The Opening Bank Allocation screen for the selected Bank is displayed as shown:

Accessing Bank Reconciliation in Tally.ERP9

2. Provide the unreconciled transaction details based on the nature of transactions (Deposit/Withdrawal) as shown:

Accessing Bank Reconciliation in Tally.ERP9

3. Save the screen.

When the company data is split, the unreconciled transactions will automatically get updated in the Opening BRS details.

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

Accessing Bank Reconciliation in Tally.ERP9

4. Provide the date of the realised transactions (the amount reflecting in the bank passbook) in the Bank Date field provided.

5. Save the Bank Reconciliation screen.

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

6. Press Ctrl+Enter on the required transaction row to open the voucher in alteration mode.

F12 : Range

Allows to filter the Bank Reconciliation screen. The user may filter the transactions based on the Amount, Ba nk Date , Date , Favouring Name , etc as shown:

Accessing Bank Reconciliation in Tally.ERP9

2. Configuring Bank Reconciliation

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

PressF12: Configure.TheConfigurationscreen appears as follows:

Configuring Bank Reconciliation in Tally.ERP9

  • Select vouchers to show:
    By default,allthe vouchers are displayed. Select the requiredLedgerEntriestype from the list.

  • Show Narrations also:
    Set this option toYesto display the narration in the Bank Reconciliation screen.

  • Show Remarks also:
    Set this option toYesto display the remarks in the Bank Reconciliation screen as shown:

Configuring Bank Reconciliation in Tally.ERP9

  • Show Forex details also:

    Set this option toYesto display the forex details also in the report.

  • Show Forex Transactions only:

    By default, this option is set toYes. The cheque printing screen displays only the Forex transaction.

Note:The optionsShow Forex details alsoandShow Forex Transactions onlyappear only in caseMultiCurrencyfeature is enabled for the company.

  • Show Reconciled Transactions also:

  • Set this option toYesto display the reconciled transactions also in the Bank Reconciliation screen.
  • Allow Back dated Reconciliation:

    Set this option toYesto allow reconciling back dated transactions also.

  • Show Payment Favouring/Received From:

    Set this option toYesto display thePaymentFavouring/ReceivedFromdetails in the Bank Reconciliation screen.

The Bank Reconciliation screen withNarration,RemarksandPaymentFavouring/ReceivedFromdetails is displayed, as shown:

Configuring Bank Reconciliation in Tally.ERP9

Note:
♦TheFavouringNamecolumn displays only those names which are different from theParty/Ledgeraccount names.
♦Bank Reconciliation capability has been enhanced, from this screen users can
* View the voucher display by pressingAlt + EnterfromBank Datefield
* Alter the Voucher by pressingCtrl +EnterfromBank Datefield

  • Show all Unreconciled Transactions Till Date: Set this option toYesto display all theUnreconciledTransactionstill the given date, irrespective of theFromdate set in the Bank Reconciliation Statement.

Note:
♦This option is also available inGateway of Tally > F12:Configure > General.
♦The option set will be applicable toallthebanksfor the selected company.

  • Appearance of Name: Select the requiredDisplay Name Stylefrom the list to display in cheque printing screen.

The completed Bank Reconciliation screen is displayed as shown

Configuring Bank Reconciliation in Tally.ERP9

3. Printing Bank Reconciliation Statement

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

To Print Bank Reconciliation Statement

  1. Go to Gateway of Tally > Banking > Bank Reconciliation .

  2. Select the required Bank account from List of Bank .

  3. The Bank Reconciliation screen is displayed.

  4. Click Print or Press Alt+P .

The Print Report screen appears.

Printing Bank Reconciliation Statement in Tally.ERP9

5.ClickNoor PressNorEscto set the following options:

  • Select Vouchers to Show: By default this is selected asAllVouchers, select the required option from the Ledger Entries list.

  • Show Narrations also: Set this option toYesto display the narration in the report.

  • Show Remarks also: Set this option toYesto display the remarks in the report.

  • Show Forex details also: Set this option toYesto display the forex details in the report.

  • Show Forex Transactions only: Set this option toYesto display the forex transactions only in the report.

    Note:The optionsShow Forex details alsoandShow Forex Transactions onlyappear only in caseMultiCurrencyfeature is enabled for the company.

  • Show Reconciled Transactions also: Set this option toYesto display the reconciled transactions also in the report.

  • Show Payment Favouring/Received From: Set this option toYesto display the Payment Favouring/Received From details in the report.

6. Acceptto Print.

The Bank Reconciliation Statement appears as shown:

Printing Bank Reconciliation Statement in Tally.ERP9

4. 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 fromDay Book, Bank Conciliationor fromvoucher reports.

Here ABC company is altering the voucher dated3-7-2010(already reconciled) where the company has issued the cheque forRs. 1000toSupreme Computers

Note:To alter a voucher fromBank Reconciliationreport, fromBank Datefield press Ctrl + Enter

The amount of1000has been split into600&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.

Alteration of Reconciled Voucher in Tally.ERP9

Get...Tally.ERP9 Book + GST Assignment (2 Set) @ Rs.550
 
 
Disclaimer :

Tally, Tally 9, Tally9, Tally.ERP, Tally.ERP 9, Tally.Server 9, Tally.NET & Power of Simplicity are either registered trademarks or trademarks of Tally Solutions Pvt. Ltd. in India and/or other countries. All other trademarks are properties of their respective owners.

The visitors may click here to visit the web site of Tally Solutions Pvt. Ltd. for resolving their doubts or for clarifications

Trademarks :
Tally,Tally GST,TallyERP9 GST, Tally9, Tally.ERP, Tally.ERP –9, Tally.Server 9, Tally.NET & Power of Simplicity are either registered trademarks or trademarks of Tally Solutions Pvt. Ltd. in India and/or other countries. All other trademarks are properties of their respective owners. This Website is not associated with any product or vendor mentioned in this Website
© 2018 : www.tallyerp9help.com