Example Bank Reconciliation Statement Tally Prime in Tamil


Excise Sum : 1

The Following Would Be Recording In Journal Using Double Entry System. Do The Posting Process From Journal Entries And Prepare The Trial Balance, Trading A/C, Profit & Loss A/C, Balance Sheet and bank reconciliation statement also In The Books Of M/S.PENGUIN PVT LTD For The Following Year 2009 To 2010.


PARTICULARDR CR
Capital350000
Cash 100000
Indian bank300000
Loan liability150000
Bank o/d48000
Furniture30000
Good will15000
Bills payable200000
Land & building 50000
Bills receivable130000
Bank deposit100000
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.No,AG076
2. Mr. LINE MARK Ltd Rs.20000

TRANSACTION DURING THE PERIOD OF APRIL:


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

Apr 2 Amount Paid To Mr. Win India Was Rs.5000 Against Bill. No. AC075. Ch.No. 25132

Apr 3 Commission Received By Cheque Rs.10000 Ch.No.75461

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

Apr 5 Amount Received M/r.Five Star Rs.15000 By Cheque Discount allowed Rs.750.Ch.No.42678

Apr 6 Dividend Received Rs.29000 By Cheque .Ch.No.13555

Apr 10 Paid Rent By ChequeRs.4500 .Ch.No.25134

Apr 11 Amount Paid To Mr. Cool Dream Rs.7000 By Cheque Discount Received Rs.700 Ch.No.25135

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

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

Apr 17 Amount Received Mr. Lion Mark Was Rs.19000 Discount Allowed Rs.1000 By Cheque Ch.No.89576

Apr 19 Received Branch Income Rs. 25000 By Cheque .Ch.No. 89156

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

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

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

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

Apr 30 Deposit To Bank Rs.9000


BANK STATEMENT FOR THE MONTH OF APRIL:

INDIAN BANK ,
25, GANDHI ROAD ,CHERRY ROAD,
SALEM – 636007

DateParticularReferenceDrCrBalance
1 Apr 2022Balance B/d300000
3 Apr 2022Win India251325000295000
3 Apr 2022Vodafone251312000293000
5 Apr 2022Commission 7546110000303000
6 Apr 2022Five star4267814250317250
7 Apr 2022Salary2513310000307250
9 Apr 2022ATM 15:15:492000305250
10 Apr 2022Dividend 3000308250
12 Apr 2022Cash 10000 318250
15 Apr 2022Cool dream251356300311950
16 Apr 2022Interest415962000313950
17 Apr 2022EB charges251361500312450
19 Apr 2022ATM 15:45:0630000282450
22 Apr 2022Dividend 1355529000311450
25 Apr 2022General exp251386000305450
25 Apr 2022Guna3548615000320450
27 Apr 2022Nathan2514050000270450
29 Apr 2022Salary65456100000370450
30 Apr 2022Cash90000460450
30 Apr 2022Cash251397000453450
30 Apr 2022Interest1000454450
30 Apr 2022Travelling 2514120000434450
Closing434450

View Answer


Excise Sum : 2

The following would be Recording in Journal Using Double Entry System. Do the Posting Process From Journal Entries And Prepare The Trial Balance, Trading A/C, Profit & Loss A/C, Balance Sheet and bank reconciliation statement also in The Books of M/S. RAMAN PVT LTD for the following year 2011 to 2012


PARTICULARDR CR
Capital380000
Cash100000
Federal Bank350000
Bank O/D50000
Furniture82000
Land & Building 50000
Bills receivable150000
Bills payable150000
Good will50000
Bank Loan152000
Bonus payable50000
SUNDRY CREDITORS:
MS. Nathan & CO Rs.10000 Bill no: AC071 due days:28
Mr. Pillai & CO Rs.5000 Bill no: AG085 due days:30
SUNDRY DEBTORS:
Mr. Senthil Ltd Rs.8000 Bill No:AG035 due days:21
Mr. Selvi Ltd Rs.7000 Bill no:AC083 due days:10

TRANSACTION DURING THE PERIOD OF APRIL:


Apr 1Paid Salary by cheque RS10000 Chno:73105

Apr 2 Paid Commission by cheque Rs750 Chno:83103

Apr 3 Commission received Rs10000 by cheque Chno:81883

Apr 4 EB charges Rs1500 by cheque chno:73113

Apr 5 Amount paid to Ms Nathan & co by cheque Rs9500 Discount received Rs500 chno:71383 against bill no :AC071

Apr 6 Amount received from Ms Senthil Ltd by cheque & discount allowed Rs700 chno:81735 against bill no:AG035

Apr 7 Amount received from Ms Selvi Ltd by cheque chno:31780 against bill no:AC083

Apr 8 Interest received Rs20000 by cheque chno:51333

Apr 9 House rent paid Rs10000 by cheque chno:72450

Apr 10 Bank O/D settled Rs30000 by cheque chno:63085

Apr 11 Bank loan settled Rs40000 by cheque chno:711103

Apr 12 Cash withdraw from bank Rs7000 by cheque chno:37015

Apr 13 Cash deposit to bank Rs70000 chno:63511

Apr 14 Telephone charges Rs1500 by cheque chno:13543

Apr 15 Dividend received Rs20000 by cheque chno:13515

Apr 16 Paid travelling expenses by cheque Rs5000 chno:74332

Apr 17 General expenses paid by cheque Rs3000 chno:53533

Apr 18 Received interest from by cheque Rs1000 chno:77777

Apr 19 Paid trade expenses Rs2000 by cheque chno:25138

Apr 20 Insurance paid Rs5000 by cheque chno:53112

Apr 21 Bank O/D settled Rs10000 chno:73513

Apr 22 Bank loan settled Rs20000 chno:51031

Apr 23 Rent received by cheque Rs10000 chno:73519

BANK STATEMENT FOR THE MONTH OF APRIL:

Federal Bank ,
26, Fairland’s Road, Mittapudur,
Salem-636016.

DateParticularReferenceDrCrBalance
1-4-2022 balance B/D 350000
2-4-2022 salary 73105 10000 340000
2-4-2022 commission83103750 339250
3-4-2022 commission81883 10000349250
4-4-2022 EB charges731131500347750
5-4-2022 cash 63511 70000417750
6-4-2022 dividend5000422750
8-4-2022 Nathan CO71383 9500413250
8-4-2022 Interest5133320000433250
9-4-2022 Senthil Ltd817357300440550
14-4-2022 Selvi Ltd 317807000447550
18-4-2022 House Rent7245010000437550
19-4-2022 Bank O/D settled 6308530000407550
21-4-2022 cash 70000337550
22-4-2022 Telephone charges 135431500336050
25-4-2022 dividend1351520000356050
26-4-2022 Branch income 4321010000366050
28-4-2022 ATM (02-10-35)10000356050
29-4-2022 cash9000365050
29-4-2022 Rent received7351910000375050
29-4-2022 Interest received777771000376050
30-4-2022 Cash370517000369050
30-4-2022 Bank O/D settled7351310000359050
30-4-2022 Salary93158100000459050
Closing459050

View Answer


Excise Sum : 3

The following would be Recording in Journal Using Double Entry System. Do the Posting Process From Journal Entries And Prepare The Trial Balance, Trading A/C, Profit & Loss A/C, Balance Sheet and bank reconciliation statement also in The Books of M/S. Navin Pvt Ltd for the following year 2021 to 2022


PARTICULARDR CR
Capital 100000
Indian Bank 122.54
Bank loan 50000
Cash 100000
Reserves 30000
Machinery 35000
Bill Payable 7000.54
Typewriter 31000
Unpaid Expenses 10000
Furniture 25000
Bill Receivable 5878

TRANSACTION DURING THE PERIOD OF APRIL:


Oct 01 Amount Received MR. Saranya Pvt Ltd Rs.1000.Ch.No.10011

Oct 02 Amount paid By Transfer Money Transfer Rs.230.Ch.No.10012

Oct 03 Paid Telephone Charge Rs.120.Ch.No.10013

Oct 06 Amount paid By Transfer Money Transfer Rs.100.Ch.No.10014

Oct 07 Amount Paid Withdrawal Transfer Cash Rs.100. Ch.No.10017

Oct 08 Salary Received Rs. 3000.Ch.No.10018

Oct 09 Paid Rent Rs.1000.Ch.No.10019

Oct 11 Amount Paid Withdrawal Transfer Cash Rs.239.Ch.No.10021

Oct 12 Paid Electric Charge Rs.2000.Ch.No.10022

Oct 13 Amount Received MR. Saranya Pvt Ltd Rs.4500.Ch.No.10023

Oct 15 Amount Paid Mr. Murugesan pvt ltd Rs.4400.Ch.No.10025

Oct 17 Amount paid By Transfer Money Transfer Rs.234.Ch.No.10027

Oct 18 Amount Paid Withdrawal Transfer Cash Rs.704.Ch.No.10028

Oct 19 Amount Received from MR. Tutor Joes Pvt Ltd Rs.13000.Ch.No.10029

Oct 20 Amount Paid Withdrawal Transfer Cash Rs.4500.Ch.No.10030

Oct 21 Amount paid from Mr. Sri Sai Kamatchi Pvt Ltd Rs.6000. Ch.No.10031

Oct 23 Paid Rent Rs.1000.Ch.No.10033

Oct 24 Amount Received from Mr. Ramya Pvt Ltd Rs.7500.Ch.No.10034

Oct 26 Amount Received from MR. Tutor Joes Pvt Ltd Rs.4733.Ch.No.10036

Oct 27 Amount paid from Mr. Sri Sai Kamatchi Pvt Ltd Rs.4700.Ch.No.10037

Oct 30 Amount Received from Mr. Dhivya Pvt Ltd Rs.5000.Ch.No.10040

Nov 01 Amount paid from Mr. Kalyan Silks Pvt Ltd Rs.6851.

BANK STATEMENT FOR THE MONTH OF OCTOBER:

INDIAN BANK,
28,Shopping Complex Omalur Road,
Salem-636016.

DateParticularReferenceDrCrBalance
balance B/D 122.54
01-11-2022 SARANYA PVT LTD 10011 1000.001122.54
02-11-2022 BY TRANSFER MONEY TRANSFER10012 230.00 1352.54
02-11-2022 TELEPHONE CHARGE 10013 120.00 1232.54
03-11-2022 WITHDRAWAL TRANSFER CASH 10014 100.00 1132.54
04-11-2022 BY TRANSFER MONEY TRANSFER 10015 100.00 1232.54
05-11-2022 BY TRANSFER MONEY TRANSFER 10016 100.00 1332.54
06-11-2022 WITHDRAWAL TRANSFER CASH 10017 100.00 1232.54
06-11-2022 SALARY RECEIVED 10018 3000.00 4232.54
07-11-2022 RENT PAID 10019 1000.00 3232.54
08-11-2022 DISCOUNT PAID 10020 209.00 3023.54
09-11-2022 WITHDRAWAL TRANSFER CASH 10021 239.00 2784.54
10-11-2022 ELECTRIC CHARGE 10022 2000.00 784.54
11-11-2022 SARANYA PVT LTD 10023 4500.00 5284.54
12-11-2022 COMMISSION PAID 10024 100.00 5184.54
13-11-2022 MURUGESAN PVT LTD 10025 4400.00 784.54
14-11-2022 WITHDRAWAL TRANSFER CASH 10026 299.00 485.54
15-11-2022 BY TRANSFER MONEY TRANSFER 10027 234.00 719.54
16-11-2022 WITHDRAWAL TRANSFER CASH 10028 704.00 15.54
17-11-2022 TUTOR JOES PVT LTD 10029 13000.00 13015.54
18-11-2022 WITHDRAWAL TRANSFER CASH 10030 4500.00 8530.54
19-11-2022 SRI SAI KAMATCHI 10031 6000.00 2530.54
20-11-2022 SRI SAI KAMATCHI 10032 1500.00 1030.54
21-11-2022 RENT PAID 10033 1000.00 30.54
22-11-2022 RAMYA PVT LTD 10034 7500.00 7530.54
23-11-2022 DISCOUNT PAID 10035 199.00 7331.54
24-11-2022 TUTOR JOES PVT LTD 10036 4733.00 12064.54
25-11-2022 SRI SAI KAMATCHI 10037 4700.00 7364.54
26-11-2022 BY TRANSFER MONEY TRANSFER 10038 240.00 7604.54
27-11-2022 TELEPHONE CHARGE 10039 240.00 7364.54
28-11-2022 DHIVYA PVT LTD 10040 5000.00 12364.54
29-11-2022 KALYAN SILKS 6851.00 5513.54
30-11-2022 KALYAN SILKS 10041 1340.00 4173.54
Total 38,581.00 39,653.00

View Answer


Tally Prime