Bank Reconislation in Tally Prime

Bank Reconciliation
The Bank Reconciliation option in the Banking menu enables you to reconcile bank accounts. You
can access bank reconciliation to print or configure the reconciliation statements, according to
your requirements.
With Bank Reconciliation, you can :
• Create vouchers from the Bank Reconciliation screen itself.
• Provide opening BRS for unreconciled transactions.
Accessing Bank Reconciliation
1. Go to Gateway of Tally prime> Go to > Bank Reconciliation.

2. 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 .
Note:
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.
Button Options in Bank Reconciliation screen
• F2: Period : Press F2 key or click F2: Period to 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, click S:
Set Bank Dates button or press Alt+S key. The Set Bank Date sub-screen appears as
shown:
• 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.
• Specify the required bank date that is to be filled for all the transactions in the Bank
Reconciliation screen.
• Voucher Date : . F2 On selecting Voucher Date as the Bank Date Type , the Bank Date field
for all the transactions in the Bank Reconciliation screen is filled with the Date of
Voucher .
• C : Create Voucher : Press Alt+C key or click C : Create Voucher to create a voucher from
the Bank Reconciliation screen itself.
• U : Opening BRS : Click this button to provide opening BRS to the unreconciled
transactions. The Opening Bank Allocation screen for the selected Bank appears as
shown:
• Provide the unreconciled transaction details based on the nature of transactions
(Deposit/Withdrawal) as shown:
• Provide the date of the realised transactions (the amount reflecting in the bank passbook)
in the Bank Date field provided.
• Save the Bank Reconciliation screen.
PARTICULAR DR CR
Capital 350000
Cash 100000
Indian bank 300000
Loan liability 150000
Bank O/d 48000
Furniture 30000
Good will 15000
Bills payable 200000
Land & building 50000
Bills receivable 130000
Bank deposit 100000

SUNDRY CREDITORS:
Mr. WIN INDIA Was Rs.5000 Bill.No.Ac75
Mr. COOL DREAM Was Rs.7000 Bill.No.AG085
SUNDRY DEBTORS::
Mr. FIVE STAR Ltd Rs.15000 Bill.NoAG076
Mr. LION MARK Ltd Rs.20000
Date Transactions
01-Apr Paid Telephone Charge Rs.2000 By Cheque [Vodafone] Ch.No.25131
02-Apr Amount Paid To Mr. Win India Was Rs.5000 Against Bill. No. AC075. Ch.No. 25132
03-Apr Commission Received By Cheque Rs.10000 Ch.No.75461
04-Apr 4 Month Salary Rs.10000 By Cheque Paid Ch.No.25133
05-Apr Amount Received M/r.Five Star Rs.15000 By Cheque Discount allowed Rs.750.Ch.No.42678
06-Apr Dividend Received Rs.29000 By Cheque .Ch.No.13555
10-Apr Paid Rent By Cheque Rs.4500 .Ch.No.25134
11-Apr/td> Amount Paid To Mr. Cool Dream Rs.7000 by Cheque Discount Received Rs.700 Ch.No.25135
15-Apr Electric Charge Paid Cheque .Rs.1500 Ch.No.25136
16-Apr Interest Received By Cheque Rs.2000 Ch.No.41596
17-Apr Amount Received Mr. Lion Mark Was Rs.19000 Discount Allowed Rs.1000 By Cheque Ch.No.89576
19-Apr Received Branch Income Rs. 25000 by Cheque .Ch.No. 89156
20-Apr Paid Trade Expenses By Cheque Rs.2500 Ch.No.25137
25-Apr Paid To General Expenses Rs.6000 Ch.No.25138
26-Apr Received House Rent Rs.3000 Ch.No.695472
27-Apr With Draw From Bank Rs.7000 Ch.No.25139
30-Apr Deposit To Bank Rs.9000

Bank Reconislation in Tally Prime

Uploaded by

Copyright:

Available Formats

Bank Reconislation in Tally Prime

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Bank Reconislation in Tally Prime

Uploaded by

Copyright:

Available Formats

Bank Reconciliation

With Bank Reconciliation, you can :

• Create vouchers from the Bank Reconciliation screen itself.

• Provide opening BRS for unreconciled transactions.

Accessing Bank Reconciliation

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

Button Options in Bank Reconciliation screen

Reconciliation screen is to be displayed.

date entered for that transaction in the Bank Allocations screen.

the Bank Reconciliation screen itself.

in the Bank Date field provided.

• Save the Bank Reconciliation screen.

Indian bank 300000

Loan liability 150000

Bank O/d 48000

Good will 15000

Bills payable 200000

Land & building 50000

Bills receivable 130000

Bank deposit 100000

01-Apr Paid Telephone Charge Rs.2000 By Cheque [Vodafone] Ch.No.25131

03-Apr Commission Received By Cheque Rs.10000 Ch.No.75461

04-Apr 4 Month Salary Rs.10000 By Cheque Paid Ch.No.25133

06-Apr Dividend Received Rs.29000 By Cheque .Ch.No.13555

10-Apr Paid Rent By Cheque Rs.4500 .Ch.No.25134

15-Apr Electric Charge Paid Cheque .Rs.1500 Ch.No.25136

16-Apr Interest Received By Cheque Rs.2000 Ch.No.41596

20-Apr Paid Trade Expenses By Cheque Rs.2500 Ch.No.25137

25-Apr Paid To General Expenses Rs.6000 Ch.No.25138

26-Apr Received House Rent Rs.3000 Ch.No.695472

27-Apr With Draw From Bank Rs.7000 Ch.No.25139

30-Apr Deposit To Bank Rs.9000

You might also like