A bank reconciliation statement is an important financial document which compares the amount on a company’s balance sheet with the number mentioned in its bank statement.
By performing bank reconciliation statement in Tally, it is ensured that the cash entries made by the company are correct. Bank reconciliation statements are a secure way of preventing cash fraud and misreporting of funds.
In this article we will be going over some of the ways to perform bank reconciliation in Tally ERP 9.
What is Tally ERP 9?
It is a resource planning software compatible with windows which is used for payroll management, banking, accounting and many more financial needs of your business.
Businesses can also carry out BRS in Tally ERP 9 to monitor that their account books are maintained correctly.
Tally ERP 9 helps businesses focus on their long term goal by working on cost centres, multi currency, order process etc. Auto bank reconciliation in Tally has also the added feature that by purchasing a multi-user license it supports unlimited users and transactions.
Bank reconciliation statement in Tally ERP 9 is an important activity that should be carried out by businesses to have better control as well as transparency regarding their money. Below we list the different steps involved in performing bank reconciliation in Tally ERP 9:
Go to the Gateway of Tally option. Here you will see a number of categories such as Master, Transactions, Utilities and Reports. Under Utilities section, select banking.
This will open a new display where you need to choose Bank reconciliation. Once complete, the complete list of bank accounts created in Tally would be visible to you.
After you have selected your bank account, enter the appropriate bank date under the column given. Bank date is required for bank reconciliation that is to correct any error that might have cropped while comparing your bank statement and book of account.
This is the sum which is levied by your bank for its services and is automatically debited from your account. In case of bank charges, it is impossible to add different dates in your account book than the ones mentioned in the bank statement.
Suggested Read: Difference Between Tally ERP 9 Vs Tally Prime
BRS in Tally ERP 9 is done in this step. The bank deposited the amount in Mega traders’ account on 17th April 2012, although the creditor’s details were Mega traders and they were supposed to be paid by cheque on 15th April 2012.
You might enter the date 15th April in your accounts but the date would be different in the bank statement. Hence you may need reconciliation. Enter the date 17th April in the bank date column to do this. Do this for as many creditors as applicable and then press enter.
Printing a bank reconciliation report in Tally is fairly easy. Go back to the bank reconciliation option, as shown above. The screen will show all your reconciled entries.
You can select the print option available on the top left corner. A number of options would then appear on your screen as shown below. The second last option, Show reconciled transactions, is also set to No.
This is the default option in Tally. Set it to yes to view all the entries entered by you during reconciliation. Click ok to print the BRS in Tally.
Suggested Read: Types of Voucher in Tally ERP 9 to Manage Transactions
Bank Reconciliation in Tally ERP 9 Shortcuts – 5 Simple Steps
Let’s find out some of the shortcuts for BRS in Tally, so that you can do it faster without much knowledge about Tally ERP 9.
BRS in Tally with Examples
In the above-mentioned image, there is a description and amount spent across different items in a month. However, the closing balance shows discrepancy between the closing balance and the person’s own financial records.
Suggested Read: How to Create Ledger in TallyPrime or Tally ERP 9
What’s the analysis here?
The account holder can perform bank reconciliation in Tally here to analyze that there were additional expenses in the form of bank charges for a new debit card ordered.
Therefore, the variation was showing between the customer’s account and that balance sheet shared by the bank through Tally reconciliation.
Frequently Asked Questions (FAQs)
Currently performing bank reconciliation in Tally ERP 9 in Hindi is not feasible. All operations are supported in English only. However, there are many online tutorials in Hindi to help you learn how to perform bank reconciliation in Tally ERP 9.
After performing the bank reconciliation in Tally, it is possible to delete that by following these steps:
a. Open second child company
b. Open Gateway of tally. Under that select the option Banking and then Banking reconciliation.
c. Select your desired bank from the list of banks.
d. Click the Opening BRS option. Under that select opening bank allocations. This contains the list of unreconciled transactions related to the particular bank ledger
e. In the date field, press spacebar to clear a transaction from unreconciled list
f. Click accept
g. Alternatively, for users with Tally.ERP 9 release 5.0 and above, the option of delete is present in the opening bank allocation. Select that to clear transactions from the unreconciled list.
a. Select gateway of Tally, under that banking and then bank reconciliation. You can select your bank from the list
b. Press F2 to specify period
c. Press F12 and select Yes to show reconciled transactions
d. Date of realisation will start showing in the column for bank date
There are two types of entries while studying bank statements and cash books:
a. Entries that are there in bank statement but not in Tally
b. Entries appearing in Tally but not in bank statements
You might come across such entries while doing bank reconciliation in Tally which include:
a. Interest income
b. Deposit by customer into bank account
c. Charges levied by bank
BRS in Tally ERP 9 might have such entries, which are:
a. Cheque which has not yet been presented to the customer,
b. Cheques not yet cleared by the bank.
Related Categories: Reconciliation Software | Accounting Software | Invoicing and Billing Software
Introducing Xoriant Corporation, leading player in the era of product development, engineering, and consulting… Read More
The dark web is a part of the internet that isn't indexed by standard search… Read More
A strong sales pipeline is indispensable for the expansion of every business organization. It's simply… Read More
In our earlier blogs, we have already discussed website cookies. Now, we will try to… Read More
Remote desktop software, which is also known as remote access software, allows users to interact… Read More
Human resource planning is the simplest way to describe strategy for ensuring that the… Read More
