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.
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)
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.