UNIT - III ADVANCE ACCOUNTING IN TALLY.ppt

slogeshk98 11 views 67 slides Nov 02, 2025
Slide 1
Slide 1 of 67
Slide 1
1
Slide 2
2
Slide 3
3
Slide 4
4
Slide 5
5
Slide 6
6
Slide 7
7
Slide 8
8
Slide 9
9
Slide 10
10
Slide 11
11
Slide 12
12
Slide 13
13
Slide 14
14
Slide 15
15
Slide 16
16
Slide 17
17
Slide 18
18
Slide 19
19
Slide 20
20
Slide 21
21
Slide 22
22
Slide 23
23
Slide 24
24
Slide 25
25
Slide 26
26
Slide 27
27
Slide 28
28
Slide 29
29
Slide 30
30
Slide 31
31
Slide 32
32
Slide 33
33
Slide 34
34
Slide 35
35
Slide 36
36
Slide 37
37
Slide 38
38
Slide 39
39
Slide 40
40
Slide 41
41
Slide 42
42
Slide 43
43
Slide 44
44
Slide 45
45
Slide 46
46
Slide 47
47
Slide 48
48
Slide 49
49
Slide 50
50
Slide 51
51
Slide 52
52
Slide 53
53
Slide 54
54
Slide 55
55
Slide 56
56
Slide 57
57
Slide 58
58
Slide 59
59
Slide 60
60
Slide 61
61
Slide 62
62
Slide 63
63
Slide 64
64
Slide 65
65
Slide 66
66
Slide 67
67

About This Presentation

Hnllmmmmkl


Slide Content

Topic : ADVANCE ACCOUNTING IN TALLY.
Subject Code: MBBA22L03
Subject Name: Tally - Financial Statement Analysis
Delivered by : DeviBharathi M

Invoice vs Bill
Invoice vs. bill - a summary
 
The terms 'bills' and 'invoices' are often used synonymously, and this can lead to confusion. To
summarise, it’s important to remember:
 
•Bills provide limited details such as prices and VAT, invoices provide detailed information and are
therefore legally binding.
•Bills are commonly used to pay for goods and services received instantaneously, invoices can be used for
immediate transactions, but are also used to request payment before a pre-approved date.
Whilst businesses will naturally talk about invoices, a customer may still refer to these documents as
‘bills’. Therefore, the next time a customer calls you about a problem with their ‘bill’, just remember that
they’re viewing the transaction from a different perspective, and they may well be referring to the invoice
you have just issued.
 

ADVANCE ACCOUNTING IN TALLY.
Bill-wise details,
Cost centers
Cost Categories
Multiple currencies
Interest calculations
Budget and controls Scenario management
Bank Reconciliation.

Bill-wise details
What is Bill wise Accounting?
If we make an entry to a ledger that needs bill wise
details, we have to give the details of the bill at the
voucher entry itself. Where we can see the details of bills,
specific credit periods and get the correct outstanding
result [balance] of each ledger.
But when there are a lot of entries it becomes difficult
to match a payment to an invoice. It is so that the details
of creditors and debtors are maintained at the invoice
level and called as Bill-Wise Accounting system.
Types of Bill wise details in Tally.ERP 9
There are four types of bill wise detail.
New Reference
Against Reference
Advance
On Account

New Reference This is used at the time of passing sales and purchase entries which will later serve for Against reference entries to be
passed under Sundry debtors and creditors ledger.
Against
Reference
This reference is used when we pass receipt entries or payment entries against the references created at the time of
passing of original entries such as sales and purchase.
Advance This reference is used when any amount is received in advance for any services rendered or for any outward supplies
of goods is made or when any amount is paid in advance for purchases to be made at the future date.
In other words, this type of bill wise detail is maintained where the nature of service or nature of product or terms of
business demands advance receipts/ advance payments to be made and to track these when the business gets
materialized at the time of raising of bill or invoice, these entries would serve as reference.
 
On Account An interest receipt entry, interest payment entries uses these types of references. But apart from these, this type of
reference is also used when we are unsure of as of against which bill the sum has been settled by the debtor.
So, all those types of entries are kept under this reference till the time it gets cleared as to which Invoice the sum
relates to.
 

Benefits of maintaining Bill wise details in Tally.ERP 9
•To easily maintain/generate outstanding reports of Receivables and Payables
•To maintain & track
 
Accounts Receivable 
and 
Accounts Payable 
based on every bill
•The primary benefit of this capability is the speed and ease which is enabled by Tally.ERP 9
•Helps in generating Age wise analysis report for receivables and payables

How to activate Bill wise Accounting in Tally.ERP 9
Step 1:To set Maintain Bill wise Details to Yes in F11: Accounting Features
window
Step 2:To create a Party (Ledger A/c) under Sundry Debtors /
 Sundry
Creditors
 group
Step 3:To set maintain balances bill by bill to Yes for the parties during ledger
creation
Step 4:From Gateway of Tally > Accounting Vouchers > Sales (F8) or Purchase
(F9) accordingly and enter the transaction by specifying a Bill reference
No. along with due dates for the amount to be received or paid in the Bill
Allocations for the screen (we can also break up the amount into multiple
reference numbers with different due dates)

To generate various types of Bill wise summary report in Tally.ERP 9
Generally, to view Receivables / Payables Reports, we have to proceed to
 Gateway of Tally > Display > Statement of Accounts > Outstandings > Receivables (to view due to the
company).
This report displays a bill by bill outstanding for all the parties with the pending amount along with the due
date.
Report Type
Individual party wise – Bill wise outstanding
Group Outstanding report – Bill wise outstanding
Ageing analysis report – Bill wise outstanding

Report Type Description
Individual party wise – Bill wise
outstanding
Select
 
Ledger in the Outstandings menu
We will now get a report displaying bill-by-bill details of all outstandings for the
concerned party along with the total outstanding amount.
Group Outstanding report – Bill wise
outstanding
To View Group Outstanding Report, select Group in the Outstandings menu and
then select the specific group or sub group
Ageing analysis report – Bill wise
outstanding
We can also view Ageing Analysis of Outstandings, by defining various ranges
of periods and view outstanding across the specified time slabs
Such as 0 to 30 days, 30 to 45 days and 45 to 75 days and so on
To View Ageing Analysis Report , go to Gateway of Tally
 > Display  >
Outstandings
 > Receivables or Payables
Select F6 (Age wise)
Specify Ageing Methods and the Periods
 

Bill wise detail is used to know about party outstanding detail.
There are four types of bill wise detail:-
 
  
1)
    
New reference: - at the time of sales/purchases.
 
  
2)
    
Against reference: - at the time of cash received.
 
  
3)
   
 
Advance
: - cash received as advance.
 
  
4)
    
On account: - at the time of interest charged.
For example:
 
  
a)
    Goods sold to Ravi Rs. 15000/-                    (1-Apr-2014)
 
  
b)
    Cash received from Ravi Rs. 10000/-          (1-Apr-2014)
 
  
c)
     Goods sold to Ravi Rs. 10000/-                   (1-May-2014)
 
  
d)
    Cash received from Ravi Rs. 20000/-          (1-May-2014)
 
  
e)
    Goods sold to Ravi Rs. 25000/                    (1-Jun-2014)
 
  
f)
      Interest charged to Ravi Rs. 500/-                (1-Jun-2014)
First of all create a company.

And then activate bill wise detail as follows:
Path for activate bill wise detail:-G.O.T. (gateway of tally)-->
 press F11 --> press F1 (Accounting feature)

Now create ledger and voucher entries:
Path for ledger creation:- G.O.T. (gateway of tally)-->
 account info-->ledger--> create (single).

Path for voucher creation:- G.O.T. (gateway of tally)-->
 accounting voucher--> press F8 (sales
voucher)
Press F6 (receipt voucher)

Press F8 (sales voucher)
Press F6 (receipt voucher)

Press F8 (sales voucher)
Press F7 (journal voucher)

To view the reports follow these steps:
Path for view report:- G.O.T. (gateway of tally) -->display
  --> statement of account -->
outstanding --> ledger --> Ravi.
Press “Alt + F1” for more information.

Cost Centre and Cost Category in Tally.ERP 9

Creating Cost Categories
To group the salesmen under one
Cost Category (onesimilar
project):
 Go to
 Gateway of Tally
>
 Accounts Info.
>
 CostCategories >
Select ‘Create’ under ‘Single
Cost centre’
 Enter ‘Sales Project 1’ in
‘Name’
 > Accept the screen

Creating Cost Centres
Each salesman is considered as a cost
centre, so tocreate these:
 Go to
 Gateway of Tally> Accounts
Info.>
 Cost Centres> Select ‘Create’
under Single Cost Centres
Select ‘Sales Project 1’ in ‘Category’
 
Enter ‘Salesman 1’ in Name and accept
the screen
 Similarly, you can create cost centres
for other 3 salesmen

Pre-Allocation of Costs
For faster entry you can pre-allocate cost centres by defining percentage in the Cost Centre Class.For example, if
a salary of Rs.50, 000 is to be paid and distributed as 30% to Salesman 1, 25% toSalesman 2, 25% to Salesman 3
and 20% to Salesman 4. To do this:
 Go
 to Gateway of Tally > F11: Accounting Features.
 Set
 'Use Pre-defined Cost Centre Allocations during Entry' to 'Yes' > Press ‘Enter’
 
 
On the ‘Auto-Cost Allocation’ screen,
Enter the ‘Class
 Name’ and press ‘Enter’
 Select
 the appropriate ‘Cost Category’  and enter the required percentage.

Pre- Allocation of Costs
Cost Centre Reports
For faster identification and detailed analysis of how costs are
allocated to your business units,Tally.ERP 9 provides reports to show
complete details of all the cost centres and their related transactionsin
different ways. These reports are:
1.
 Category Summary
2.
 Cost Centre Break-up
3.
 Ledger Break-up
4.
 Group Break-up
For example, the ‘Cost Category Summary’ report is shown
 Go
 to Gateway of Tally > Display > Statements of Accounts > Cost
CentresHence, no matter how many business units you have to handle
and optimize your profit, the cost centreand cost category in Tally.ERP 9
can help you make faster decision for your business.
below:To view these cost centre reports:

Multi Currency in Tally.ERP 9
With globalization opening up the gates for trade and businesses across seas, we find many
organizations have transactions in more than one currency. Such overseas transactions have to be
recorded either in the base (home) currency or in the foreign currency.
If we record the transactions in home currency, then the rate at which the foreign currency is exchanged
should be recorded as well. Owing to the nature of the transaction, at times we need to record the
transaction in the foreign currency itself to maintain the balance of the concerned account in foreign
currency.
Forex Calculation
On 01-11-2018 XYZ Ltd is selling Commodity to a Foreign Company ABC Inc $10000.00 on 30
days credit considering the current date Exchange Rate of INR 74 for 1 USD. On 30-11-2018 ABC Ltd
receives $ 10000 in their Dollar bank account. and the exchange rate on that day was INR 69 for 1 USD.

 
In the same manner when theRs. 6,90,000
Exchange rate increases, the seller may experience Forex Gain.
(A) Exchange rate of USD on trading date : 1 USD = 7410000$ * 74 Rs. 7,40,000
(B) Exchange rate of USD on receipt date : 1 USD = 6910000$*69 Rs. 6,90,000
Forex Loss
 
Rs. 50,000

How to activate multi-currency in Tally.ERP 9
DirectionGo to Gateway of Tally > Accounts Info > Currencies > Create
Details to
enter
Symbol: Enter the symbol of currencies
·
       Number of decimal places: Generally we keep this to two decimal places
·
       Amounts to show in Millions: If you set to yes 10,00000.00 will be shown as 1 Million.
·
       Is Symbol suffixed to amounts:  Yes, then amount will we displayed as $, £,¥ etc., (Viz., US
dollar/Pounds, Yen etc.,)
·
       Add space between Amount and symbol: If set yes, Tally will put a space in between amount
and symbol like $
  10000
·
       Word used to print a decimal portion of the amount: For example, the decimal portion of USD
is cents.

Step 2: Defining rate of exchange
By altering Currency we can define rates of currency exchange on various dates. To do this :
 
Direction Go to Gateway of Tally > Accounts Info. >
Currencies > Alter
Details to enter In this screen, we can define a different exchange rate
for different dates. Before doing that we must know
some terms of currencies used in Tally.ERP 9 for
better understanding of the rate of exchange.
Understanding terms of
currencies
 
   
Standard Rate: Standard rate is the current rate of
currency prevailing in the market.
·
       Rate on the date of sale: Selling rate is the rate of
the currency in which you are selling currency to your
banker.
·
       Rate on the date of purchase: Buying rate is the
rate at which you are buying currency from the bank.
 

Step 3: Creating party ledger with foreign currency
Gateway of Tally > Accounts Info > Ledger > Create
To maintain Multi-currency in Tally ERP 9, we have to create a party ledger with
foreign currency by selecting the required currency in the currency ledger field.
Step 4: Create Sales Ledger and Bank Account Ledger
1.To create sales ledger - Follow: Gateway of Tally > Accounts Info > Ledger > Create
2.To create bank ledger - Follow: Gateway of Tally > Accounts Info > Ledger > Create

Note: Select the currency of bank account, one can choose INR or USD in which they are dealing
with the bank.
Final Step pass the transactions.

To view Foreign exchange gain or loss in Tally.ERP 9
To view Forex gain or loss one has to view the balance sheet of the company by following through
the gateway of Tally to
 
Balance sheet. It will be reflected under the heading unadjusted foreign gain/
loss. Following which we have to pass
 
journal entry 
to give effect to foreign exchange loss or gain
incurred in such transaction.

Interest calculations

Note:
 
If the interest style selected is
 365-day Year , then the interest will be calculated for 365 days irrespective of the number of days
in the calendar year. If
 Calendar Year is selected as the interest style, then the rate of interest will be calculated on 365 days or 366
days, depending on the number of days as per the calendar.
Calculate interest transaction-by-transaction
Interest calculation can be done bill-by-bill for accounts grouped
under
 
Sundry
 Debtors 
and
 
Sundry
 Creditors 
.
1.
 In the party ledger alteration screen, set 
Activate interest calculation?
 
to
 
Yes
 
. The
 
Interest
Parameters
 
screen appears.
2.
 Set 
Calculate Interest Transaction-by-transaction?
 
to
 
Yes
 
.
3.
 Set 
Override Parameters for each Transaction?
 
to
 
Yes
 
to change the parameters during voucher or
invoice entry.
4.
 Enter the rate of interest in the field 
Rate
 
.
5.
 Select the 
Interest Style
 
, as required. The rate of interest will be calculated on the basis of the
interest style applied.

Calculate interest in advanced mode
The
 advanced parameters are used when interest rates change periodically. Number of days,
balance type, and applicable from date to be considered for interest calculation can be
configured using advanced parameters.
Enable advanced parameters
1.
 Go to 
Gateway of Tally
 
>
 
F11: Features
 
>
 
Accounting Features
2.
 Set 
Activate interest calculation?
 
to
 
Yes
 
.
3.
 Set 
Use advanced parameters?
 
to
 
Yes
 
.
4.
 Press 
Ctrl+A
 
to accept the changes.

Set advanced configuration for a
party
1.
 In the party ledger master set 
Calculate Interest Transaction-by-Transaction?
 
to
 
Yes
 
to calculate
interest for each transaction.
2.
 Set 
Override Parameters for each Transaction?
 
to
 
Yes
 
t
 o display the 
Interest
 Parameters 
screen
while recording the transaction. The defined parameters can be modified during voucher entry.
3.
 Set 
Override advanced parameters?
 
to
 
Yes.
4.
 Enter the 
Rate
 
of interest.
5.
 Select the 
Interest Style
 
, as required. The rate of interest will be calculated on the basis of the interest
style applied.
6.
 Select the balance on which the interest has to be calculated. Interest can be calculated on credit balance,
debit balance or both credit and debit balances.
7.
 Select the 
Applicability
 
of the interest as required. If
 
Past
 Due Date 
is selected, then the number of days
after which interest has to be applied can be specified.
8.
 Select the date from which interest is applicable in the 
Calculate From
 
field.
9.
 Select the rounding method applicable in the 
Rounding
 
field. Select
 
Not Applicable
 
for saving values as
is without rounding off.
10.
 Define multiple slabs with different rates and applicability.

The
 Interest Parameters screen with multiple slabs appears as shown below:
11.
 Press 
Ctrl+A
 
to accept the configuration.
12.
 Press 
Ctrl+A
 
to save the ledger.
In case of the above configuration, interest will be calculated at 5% starting from 10th day after due
date and at 10% starting from 60th day after due date. Similarly, multiple slabs can be configured with
different interest style, applicability, calculate from and rounding.

Calculate interest on Group
The
 
Group Interest Calculation
 
statement is a list of all accounts and sub-groups belonging to the
selected group that displays the current balance in each account or sub-group and the total interest.
1.
 Go to 
Gateway of Tally> Display > Statements of Accounts > Interest Calculations > Group
2.
 Select a 
Group
 
, E.g.
 
Loans (Liability)
3.
 Press 
Enter
 
to
 drill down to the Ledger level Interest report.
Note:
 
The
 
Cr
 
in the interest amount indicates that it is a liability.

Calculate interest on Ledger Balances
You can get a report on the
 
Ledger balances
 
for the interest calculated.
1.
 Go to 
Gateway of Tally > Display > Statements of Accounts > Interest Calculations > Ledger
2.
 Select an Account, for example, 
Bank Loan Account
 
. The
 
Ledger Interest
 
report appears as shown below:

View interest amount on invoices
You can calculate interest on each
 invoice for the period it is outstanding, wholly or partly. Transaction by
transaction or bill-by-bill interest calculation is permitted for party accounts like accounts under the groups
sundry debtors and sundry creditors. For interest calculation on each bill, Bill-wise details should be
enabled for the company and the party.
The
 
Ledger Interest
 
report displays the interest calculated for the ledger selected. If a part of the amount is
settled, then interest is calculated only on the amount pending to be repaid.
1.
 Go to 
Gateway of Tally
 
>
 
Display
 
>
 
Statements of Accounts
 
>
 
Interest Calculations
 
>
 
Ledger
 
.
2.
 Select the required ledger. The 
Ledger Interest
 
report appears as shown below:

2.
 Select the required ledger. The 
Ledger Interest
 
report
appears as shown below:
3.
 Click 
F1
 
: Detailed
 to view the calculation and period.

Note:
 
In case if part of the amount is settled, the interest is calculated on the
remaining balance.

Budget And Controls
Budgets
A budget is a plan prepared for the flow of funds in an organisation. It contains financial guidelines for
the future plan of action for a selected period of time. A budget helps to refine goals and use funds
efficiently. It provides accurate information for evaluation of financial activities, aids in decision making
and provides a reference for future planning. You can modify a budget using the alter option. You can also
delete a budget.
Multiple budgets can be created for specific purposes in Tally.ERP 9. Budgets for Banks, Head offices,
Departmental budgets like Marketing Budgets, Finance Budgets, and so on, can also be created. The
Budgeted figures in Tally.ERP 9 can be compared with Actual figures and variance report can be
generated.
On this page
Create a budget
Alter a budget
Delete a budget

Create a budget
In Tally.ERP 9, you can create a budget for groups, ledger accounts, and cost centres.
1.
 Go to 
Gateway of Tally
 
>
 
Accounts Info.
 
>
 
Budgets
 
>
 
Create
 
.
2.
 Enter a 
Name
 
for your budget in the
 
Budget Creation
 
screen.
3.
 Select from the List of Budgets for Under field. You can have a hierarchical setup for budgets. In the List of
Budgets, Primary is at the top of the hierarchy and you can create more primary budgets. Sub-budgets can be
created under Primary budgets.
4.
 Enter the period of the budget in the 
From
 
and
 
To
 
fields. The period entered can be a month, a year or any other
period.
5.
 In 
Set/Alter Budgets of
 
, select
 Groups
 
- To create a budget for a Group of ledger accounts.
 Ledgers
 
- To create a budget for Ledgers.
 Cost
 Centres 
- To create a budget for Cost Centres.
6.
 Press 
Ctrl+A
 
to accept
 .

Alter a Budget

Create Budgets for cost centres
The purpose of a budget is to control expenditure. You can create multiple budgets in Tally.ERP 9, each for a
specific purposes. If cost centres are enabled for the company, then budgets can be created for cost centres.
1.
 Go to 
Gateway of Tally
 
>
 
Accounts Info
 
. >
 
Budgets
 
>
 
Create
 
.
2.
 I n the 
Budget Creation
 
screen, enter a
 
Name
 
for your budget.
3.
 Enable budgets for 
groups
 
, and
 
ledgers
 
if required.

4.
 Set the option 
Cost Centres
 
to
 
Yes
 
to view the
 
Cost Centre Budget
 
screen.
5.
 Enter a budget figure in 
Expenses
 
for the cost centre.
6.
 Enter a budget figure in 
Income
 
for the cost centre.
7.
 Enter 
Closing Balance
 
.
The
 
Cost Centre Budget
 
screen appears as shown below:
8.
 Press 
Enter
 
.
9.
 Press 
Enter
 
to save the budgets created.

View Budget Variance

3.
 Select the required budget to view the 
Corporate
 Budget 
, the
 
Actuals
 
, and
the
 
Corporate
 Budget Variance 
, as shown below.

Scenario Management
What is scenario?
A scenario could be defined as a description of a possible set of events that might reasonably take place. The
primary purpose of developing scenarios is to stimulate thinking about possible occurrences, assumptions
relating these occurrences, possible opportunities and risks, and courses of action.

Scenario management in accounting
It is a management tool that enables different displays of accounts and inventory related information, by
selectively including certain
 
types of vouchers 
without affecting the source data. Managing scenarios is
useful in generating provisional reports, where entries are not actually made in the main books. It is also a
useful forecasting tool i.e. we can forecast the expenses using provisional Vouchers and include them in
your reports.
The following vouchers used in Scenario Management are:
•Optional Vouchers
•Memorandum Vouchers
•Reversing Journals

To create a scenario in Tally.ERP 9
Step 1Set Use Reversing Journals & Optional Vouchers in F11 : F1: Accounting Features to Yes.
Step 2Go to Gateway of Tally > Accounts Info. > Scenario > Create
Step 3Give a suitable name to the scenario.
Step 4Set Include Actuals to Yes
Step 5·
 Set Exclude Forex Gains/Losses Calculations to Yes if you do not want the Unadjusted Forex Gain/Loss element
to appear in the scenario.
·
 Set Exclude tracking of inventory calculations to Yes if you do not want the Sales/Purchase Bills Pending
element to appear in the scenario.
Step 6Include:
From the list of available vouchers, include the type of vouchers required. Here we have to take care to pick up the
Voucher Types created for the company for which scenario is being prepared. Regular and Provisional Vouchers
that are marked Optional are permitted for selection.
Exclude:
From the list of available vouchers, exclude vouchers that are already included in the type of vouchers that you do
not
  want to affect this scenario. This is used in Alter mode and hence is discussed under Alter/Display Scenario
Information.
Step 7Accept to create this scenario.

To alter a scenario in Tally.ERP 9
Step 1Go to Gateway of Tally > Accounts Info > Scenario > Alter
Step 2Select the scenario to alter from the List of Scenarios. The information given while creating the scenario
displays and you can alter it. (or)
Exclude:
Use the mode “ Alter”,
 when you do not want a selected included voucher to affect the scenario,
anymore. This way it is easier to put the selected voucher in the Exclude List, rather than to remove it
from the Include List.

Using scenarios in sales forecast report

In Tally.ERP 9 we can use scenarios to tap sales forecast report. To use scenarios in
sales forecast report follow these steps:
Step 1Create a new Scenario and name it. Since we are going to use the
scenario for sales forecast let us name it as Sales Forecasts.
Step 2Include Sales Vouchers Optional Only.
Step 3Create 12 Sales Vouchers, one in each month. Remember to mark them
Optional.
Step 4View the Sales Accounts by drilling down the Profit & Loss A/c.
Step 5Bring up New Columns and limit each column date range to the
following month. The Sales forecast figures must display.

Bank Reconciliation
What is Bank reconciliation statement?
Bank Reconciliation Statement is an explanation of the difference between bank balance as per cash book and
bank balance as per Passbook (Bank statement). Sometimes, the bank balance as per cash book and pass book do
not tally with each other, then we can know the difference between them by preparing the bank reconciliation
statement.
The process of checking the differences between a bank column of the cash book and the bank statement or
passbook is called Bank reconciliation process in accounting terms. The person preparing BRS Statement has to
check all the transaction recorded in the cash book with transactions recorded in passbook by the bank.

Why we prepare bank reconciliation statement?
If a trader or business organization uses the bank for the transaction, then we use this option. Nowadays all
merchants do all their business transactions through the bank and to keep the details of these transactions, cash
book and bank book are maintained. When the merchant deposits money in the bank, then it is entered into the
cash book and bank book simultaneously.
Therefore, both the books remain balanced or reconciled most of the times, but sometimes the these two books
shows differences, and the statement which is prepared to match the differences between these books is called
Bank Reconciliation Statement.

How to activate auto bank reconciliation in Tally.ERP 9?
Starting Point : Gateway of Tally
Destination
    : Banking Configuration


Path:
 Gateway of Tally -> F11 Features ->
Accounting Features
Step 1Open the bank ledger (in case the Bank ledger is not
opened) by creating a bank ledger or use
  the option
“alter the ledger” (if bank ledger is already created in
Tally)
Step 2Under banking configuration, set ‘Yes’ to use this feature
of Auto bank reconciliation in Tally. ERP 9
Step 3Select the relevant bank from the ‘List of Banks’
Step 4After selecting the bank from the list of banks, In the
next dialogue box, Set ‘ Yes’ to ‘Activate Auto
Reconciliation’
Step 5Accept the change by selecting
  “Yes” in the next screen
Set/alter transaction features: 
Yes, once enable
this option, and then you will
find
 Banking option in Gateway of Tally screen.
 

Using auto bank reconciliation in Tally.ERP 9
After enabling the Auto Bank Reconciliation option, now one can go ahead and reconcile the bank
statement with the company’s books following these directions :
Step 1Go to ‘Gateway of Tally > Banking > Bank Reconciliation’
Step 2Select the required bank which has to be reconciled from the ‘List of Bank’
Step 3On the ‘Bank Reconciliation’ screen, press ‘B: Bank Statement’ or ‘Alt + B’
Step 4Specify the ‘Directory’, where you have saved the downloaded bank statement
Step 5In case you need to change the ‘File Type’, you can press ‘Backspace’ to select the appropriate ‘File
Type’ for the bank statement to be imported
Step 6Once you’ve selected the required ‘File Type’, select the required bank statement file from the ‘List
of Files’, and reconciliation will happen automatically. Once the reconciliation happens, a
‘Success!!’ notification will be displayed with details like ‘Total Entries in Bank Statement’, number
of entries reconciled and ‘Additional Bank Entries’
Step 7Now press any key and the Bank Reconciliation Statement with Imported bank statement details will
appear. Now the screen will show the reconciled list of entries from the bank statement under
‘Amounts not reflected in Company Books’
Step 8Begin the reconciliation process for entries under Amounts not reflected in company books by
verifying with the Bank Statements obtained from the bank or the Bank book maintained by you.

Shortcut key for bank reconciliation in Tally.ERP 9
Starting Point: Gateway of Tally
Destination: Cash/Bank book
Steps
•Go to gateway of Tally>
 
Display>
 
Account books>
 
Cash/Bank book
•Select the required
 
bank account
 
and press
 
enter
 
on the required month (or press F2 function
button on the keyboard and Specify the required period from which date you want to reconcile
your bank account)
•Now press “F5”–
 
the short cut key for bank reconciliation in Tally. ERP 9 
function key from the
keyboard and Bank reconciliation statement screen will open
•Enter
 
the
 
date of clearing
 
from the bank statements into
 
Bank Date
 
column next to voucher type
column to reconcile the statements and finally press Yes to accept/ save the reconciliation
statement prepared.

How to undo bank reconciliation in Tally.ERP 9?
To undo bank reconciliation in tally follow these simple steps :
Step 1: Go to gateway of Tally>
 
Display>
 
Account books>
 
Cash/Bank book
Step 2: Select the required
 
bank account
 
and press
 
enter
 
on the required month for which reconciliation
has already been done and for which you have to undo the reconciliation which is already been done.
Step 3: Press 
“F5” - 
short cut for bank reconciliation in Tally. ERP 9
Step 4: Now press “F12” – Configuration and a dialogue box will appear.
Step 5: Select “Yes “ against the dialogue –
 
Show also reconciled transactions
Step 6: The reconciled transactions for the period with bank dates will reopen and now one can alter or
undo bank reconciliation in Tally by feeding the correct inputs.

Printing of
 BRS in tally
The user may print the bank reconciliation statement. This is usually done to meet the record-keeping
needs.
 
 Start with
 the gateway of the tally. 
Then select banking.
 
After that, opt for Bank Reconciliation.
 
The list of banks will appear on the screen.
Choose the required bank for reconciliation.
The bank reconciliation statement for that particular bank will appear on the screen.
 
Then click on the print button.
 
Alternatively, you can press the Alt and P buttons to
 gether.
The Printing screen will appear. 
Tags