Header Ads

Tally ERP9



Connect to Youtube Channel Tech Dhuliyan and Subscribe for join





SNo. DATE TRANSACTIONS
1 ) 1-4-2013 Anurag Rai started Smart Agencies by bringing in capital of Rs.15,00,000 by cheque and deposited the same in ICICI Bank by opening a new account.
2 ) 3-4-2013 Mr. Rai withdrew Rs.50,000 by cheque for shop expenditure from ICICI Bank.
(Cheque number: 123451.)
3 ) 5-4-2013 Mr. Rai purchased furniture and fixtures worth Rs.1,50,000 for the Shop by cheque
(Cheque number:123452.)
4 ) 8-4-2013 Mr. Rai rented a premise on 1-4-2013 for his business at Rs.3,500 per month. He paid a security deposit of Rs.25,000 by cheque.
(Cheque number: 123453.)
5) 10-4-2013 Mr. Rai issued a cheque to purchase the following assets. (Cheque number: 123454.)
Asset Cost Rate of Depreciation
Cell Phone Rs. 5,500 15%
Computer Rs.25,000 60%
Electrical Fittings Rs. 5,000 10%
Motor Vehicle ( 2 Wheeler) ` 40,000 15%

7) 20-4-2013 Mr. Rai purchased the following items from “A2Z Traders” on credit.
Items Qty
Rate per
Piece
(Rs.) Value In put
VAT Total
Value
High Capac-
ity Stabilisers 100 Pcs. 600 60,000 12.5% 67,500

8) 21-4-2013 Mr. Rai purchased the following items from “A2Z Traders” on credit.
Items Quantity
(In
Pieces) Rate per
Piece
(Rs.) Value In put
VAT Total
Value
Low Capac-
ity Stabilisers 100 400 40,000 12.5% 45,000
Open well Pumps 50 1,500 75,000 4% 78,000
Submersible Pumpls 100 2000 2,00,000 4% 2,08,000
Gross Total 3,31,000

9 ) 22-4-2013 Mr. Rai paid Carriage Inword Expenses of ` 500 in cash on purchases made on 20-04-2013 and 21-04-2013
10 ) 27-4-2013 Mr. Rai transferred ` 10,000 to Petty Cash from Cash to meet the day to day expenses.
11 ) 28-4-2013 Mr. Rai withdrew Rs.5,000 in cash for personal use.
12 ) 30-4-2013 VAT adjustment entry.
12-A ) 30-4-2013 Salary for the Month of April 2013 is Due as follows...
Name Designation Monthly Salary
Rahul Bhatt Sales Executive Rs. 4000
Jairam Sengupta Salesman Rs. 3500
Shishir Mathur Accountant Rs. 2500
Ajith V Nair Clerk Rs. 1500

13 ) 1-5-2013 Mr. Rai paid Salaries through cheque for April 2013 (Cheque number : 123455). The details are as follows …
Name Salary Paid Number of Days
Rahul Bhatt Rs.2,400 18
Jairam Sengupta Rs.2,100 18
Shishir Mathur Rs.1,500 18
Ajith V Nair Rs. 900 18

14 ) 2-5-2013 Mr. Rai paid Rs.2,500 in cash for stationery, printing invoices and vouchers to Cannon Traders.
15 ) 3-5-2013 Mr. Rai received the statement of expenditure from the petty cashier for April 2013. The statement is as follows.

Nature of Expense Amount
Stationery purchased Rs. 2500
Cell phone bill Rs. 600
Shop maintenance expenses Rs. 450
Conveyance expenses of marketingexecutives Rs. 250

16 ) 6-5-2013 Mr. Rai paid Rs.3,500 by cheque towards shop rent for April 2013 (Cheque number: 123456).
17 ) 10-5-2013 Mr. Rai sold the following items for cash, details are as follows.
Item Qty. in Pcs. Rate Value Output VAT Total Amount
High Capacity Stabilisers 50 850 42500 12.5% 47813
Open WellPumps 15 1700 2550 4% 26520
Gross Total 74,333

18 ) 15-5-2013 Mr. Ral issued a cheque to A2Z Traders for Rs.3,96,500 after deducting the discount of Rs.2,000. He received discount as he agreed to pay the entire bill amount. (Cheque number: 123457)
19 ) 28-5-2013 Mr. Rai withdrew Rs.4,000 in cash for personal use.
20 ) 30-5-2013 Mr. Rai received the statement of expenditure from the petty cashier  for May 2013. The statement is as follows.
Nature of Expense Amount
Cell phone bill Rs.1500
Conveyance expenses of marketing executives Rs. 800
Shop maintenance expenses Rs. 200

21 ) 31-5-2013 VAT Adjustment Entry
21-A ) 31-5-2013 Salary for the Month of May 2013 is Due as follows...
Name Designation Monthly Salary
Rahul Bhatt Sales Executive Rs. 4000
Jairam Sengupta Salesman Rs. 3500
Shishir Mathur Accountant Rs. 2500
Ajith V Nair Clerk Rs. 1500

22 ) 3-6-2013 Mr. Rai paid Rs.3,500 in cash towards shop rentfor May 2013.
23 ) 4-6-2013 Mr. Rai issued a cheque of Rs.11,000 to the petty cashier. (‘Cheque Number: 123458
24 ) 6-6-2013 Mr. Rai paid salaries for May 2013 by cheque. (Cheque number: 123459)
25 ) 8-6-2013 Mr. Rai purchased the following goods from Pacific Merchants on credit
Item Qty. in Pcs. Rate Value VAT Rate Total Amount
High CapacityStabilisers 200 650 1,30,000 12.5% 1,46,250
Open WellPumps 300 1600 4,80,000 4% 4,99,200
Gross Total 6,45,450

26 ) 10-6-2013 Mr. Rai paid carriage inwards of Rs.400 in cash.
27 ) 12-6-2013 Mr. Rai sold the following items to Java Trading Company on credit.
Item Qty. in Pcs. Rate Value VAT Rate Total Amount
High CapacityStabilisers 25 900 22,500 12.5% 25,313
Open WellPumps 30 2500 75,000 4% 78,000
Gross Total 1,03,313

28 ) 15-6-2013 Mr. Rai withdrew Rs.5,000 in cash for personal use.
29 ) 20-6-2013 Mr. Rai deposed cash of Rs.40,000 to ICICI Bank.
30) 27-6-2013 Mr. Rai paid Rs.2,000 in cash to Mr. Jairam Sengupta as salary advance.
Note: Salary’ advance is to be adjusted in four equal instalments.
31) 28-6-2013 Mr. Rai received the statement of expenditure from the petty cashier on end 30-6-2013. The statement is as follows.
Nature of Expense Amount
Insurance premium forthe period 1-7-2013 to 30-6-2014 Rs.2,400
Conveyance expenses of marketing executives Rs. 600
Shop maintenance expenses Rs. 550
Electricity expenses Rs. 500

32 ) 29-6-2013 Mr. Rai sold the following items to Data Tech Services on Credit
Item Qty. in Pcs. Rate Value VAT Rate Total Amount
Low Capacity Stabilisers 100 550 55,000 12.5% 61,875

33 ) 30-6-2013 VAT Adjustment Entry
33-A ) 30-6-2013 Salary for the Month of June 2013 is Due as follows...
Name Designation Monthly Salary
Rahul Bhatt Sales Executive Rs. 4000
Jairam Sengupta Salesman Rs. 3500
Shishir Mathur Accountant Rs. 2500
Ajith V Nair Clerk Rs. 1500

34 ) 3-7-2013 Mr. Rai paid the salaries through cheque for June 2013. i.e. Rs. 11,000 [ Rs.11500 - Rs.500]
Note: Adjust the salaty advance of Rs.500 (1st instalment) given to Mr. Jairam Sen gupta.
35 ) 6-7-2013 Mr. Rai paid Rent in Cash for June 2013.
36 ) 14-7-2013 Mr. Rai purchased the following items under a sales offer. He paid by cheque. The offer is as follows.
On purchase of 10 high capacity stabilisers, I HCS is given free of cost.
On purchase of 5 low capacity stabilisers, 1. LCS is given free of cost.
Item Pur. Qty. Free of Cost Total Qty. Rate Value Input VAT-% Total Amt.
High Capacity Stabilizers(HCS) 50 5 55 650 32500 12.5 36,536
Low Capacity Stabilizers(LCS) 20 4 24 400 8000 12.5 9,000
Gross Total 45,563

37 ) 19-7-2013 Mr. Rai paid by cheque to Pacific Merchants towards bill dated 8-6-2013.
38 ) 20-7-2013 Mr. Rai introduced a sales offer and sold the following items on credit to Java Trading Company and Data Tech Services.
Item Pur. Qty. Free of Cost Total Qty. Rate Value Input VAT-% Total Amt.
JAVA TRADING COMPNAY
High Capacity Stabilizers 20 2 22 750 15000 12.5 16,875
Low Capacity Stabilizers 5 1 6 450 2250 12.5 2,571
Gross Total 19,406

Item Pur. Qty. Free of Cost Total Qty. Rate Value Input VAT-% Total Amt.
DATA TECH SERVICES
High Capacity Stabilizers 30 3 33 750 22500 12.5 25,312
Low Capacity Stabilizers 15 3 18 450 6750 12.5 7,594
Gross Total 32,906

39 ) 22-7-2013 Mr. Rai received a cheque from Java Trading Company and Data Tech Services in settlement of bills dated 20-7-2013.
40 ) 28-7-2013 Mr. Rai received cheque from Data Tech Services towards the bill dated 29-6-2013 i.e. Rs.61875
41) 29-7-2013 Mr. Rai received the statement of expenditure from the petty cashier for the month end, July 2013. The statement is as follows.

Nature of Expense Amount
Advertising expenses incurred 1500
Conveyance expenses of marketing executives 600
Donation to charitable institutions 600
Shop mntenance expenses 550
Electricity expenses 500

41-A ) 31-7-2013 Salary for the Month of July 2013 is Due as follows...
Name Designation Monthly Salary
Rahul Bhatt Sales Executive Rs. 4000
Jairam Sengupta Salesman Rs. 3500
Shishir Mathur Accountant Rs. 2500
Ajith V Nair Clerk Rs. 1500

42 ) 31-7-2013 VAT Adjustment Entry
43 ) 5-8-2013 Mr. Rai paid salaries by cheque for July 2013.
i.e. Rs. 11,000 [ Rs.11500 - Rs.500]
Note: Adjust the salary advance of Rs.500 (2nd installment) given to Mr. Jairam Sen gupta.
44 ) 8-8-2013 Mr. Rai paid rent in cash for July 2013
45 ) 10-8-2013 Mr. Rai paid Rs.7,500 in cash to the petty cashier.
46 ) 12-8-2013 Mr. Rai sold the following items to Seacrest Trading Corporation and allowed a trade discount at the rate of 5%
Item Qty. in Pcs. Rate Value VAT Rate Total Amount
High CapacityStabilisers 90 900 76,950 12.5% 86,569

47 ) 27-8-2013 Mr. Rai received cheque from Seacrest Trading Corporation
towards the bill dated 12-8-2013
48 ) 28-8-2013 Mr. Rai received a cheque from Java Trading Company towards the bill dated 12-6-2013 i.e. Rs. 1,03,312.50
49) 29-8-2013 Mr. Rai received the statement of expenditure from petty cashier for the month end 31-8-2013. The statement is as follows.
Nature of Expense Amount
Cell phone bill paid 800
Conveyance expenses of marketing executives 600
Shop maintenance expenses 400
Electricity bills paid 350

49-A ) 31-8-2013 Salary for the Month of August 2013 is Due as follows...
Name Designation Monthly Salary
Rahul Bhatt Sales Executive Rs. 4000
Jairam Sengupta Salesman Rs. 3500
Shishir Mathur Accountant Rs. 2500
Ajith V Nair Clerk Rs. 1500

50 ) 31-8-2013 VAT Adjustment Entry
60 ) 1-10-2013 Java Trading Company returned the following items, out of sales on 17-9-2013, as they were in excess of its requirements.
Name of Item Quantity
High Capacity Stabilizer 15
Submersible Pumps 10

61 ) 3-10-2013 Mr. Rai issued a cheque of Rs.7,500 to petty cashier.
62 ) 4-10-2013 Mr. Ral paid salaries and rent of shop by cheque for September
2013.
Note: Adjust the salary advance of Rs.500 (4th instalment) given to Mr. Jairam Sengupta.
63 ) 10-10-2013 Mr. Rai deposited the bills receivable drawn on Data Tech Services which was duly honoured
64 ) 20-10-2013 Mr. Rai sold the following items to Seacrest Trading Corporation on credit
Item Qty. in Pcs. Rate Value Output VAT TotalAmount
Open Well Pumps 200 1900 380000 4% 395200

65 ) 21-10-2013 Mr. Rai issued a cheque to A2Z Traders towards the purchases made on 6-9-2013.
66 ) 28-10-2013 Mr. Rai received a cheque from Java Trading Company against sales made on 17-9-2013.
67) 29-10-2013 Mr. Rai received the statement of expenditure from petty cashier for the month-end,  October 2013. The statement is as follows
Nature of Expense Amount
Conveyance expenses of marketing executives 600
Shop maintenance expenses 450
Electricity bills paid 400
Cell phone Bill 1500

68 ) 29-10-2013 VAT Adjustment Entry
69 ) 4-11-2013 MR. Rai paid salaries and rent by cheque for October 2013.
70 ) 5-11-2013 Mr. Rai issued a cheque of Rs.8,000 to the pettycashier.
71 ) 10-11-2013 Mr. Rai received a cheque from Seacrest Trading Corporation in settlement of his bill dated 20-10-2013.
72 ) 12-11-2013 Mr. Rai started trading in a new product and purchased it from Icon Enterprises on credit.
Item Qty. inPcs. Rate Value Input VAT Total Amount
Electric Heater 30 400 12000 12.5% 13500

74 ) 14-11-2013 Mr. Rai paid Rs.4,500 by cheque for the cell phone he purchased for his sales executive.
75 ) 15-11-2013 Mr. Rai sold the following items to Seacrest Trading Corporation on credit.
Item Qty. in Pcs. Rate Value Output VAT Total Amount
Open WellPumps 50 1800 90000 4% 93600

76) 29-11-2013 Mr. Rai received the statement of expenditure from petty cashier for the month-end,  November 2013. The statement is as follows
Nature of Expense Amount
Conveyance expenses of marketing executives 600
Shop maintenance expenses 500
Electricity Charges 300
Cell phone Bill 1100

77 ) 30-11-2013 VAT Adjustment Entry
78 ) 4-12-2013 Rai paid salaries and rent by cheque for November 2013
79 ) 8-12-2013 Mr. Rai settled the bill dated 12-11-2013 of Icon Enterprises by cheque.
80 ) 10-12-2013 Mr. Rai withdrew Rs.10,000 from the bank for personal use.
81 ) 17-12-2013 Mr. Rai received a cheque from Seacrest Trading Co rporation in settlement of bill dated 15-11-2013.
82 ) 18-12-2013 Mr. Rai sold the following items for Cash in an Exhibition organized by V-Guard Company
Item Qty. in Pcs. Rate Value Output VAT TotalAmount
High Capacity Stabilizer 35 850 29750 12.5% 33468
Electric Heater 30 550 16500 12.5% 18562
Open WellPumps 25 1800 45000 4% 46800
Submersible Pumps 20 2400 48000 4% 49920
Gross Total 1,48,751

83 ) 19-12-2013 Mr. Rai paid Rs. 2500 in cash for the space provided in the exhibition.
84) 29-12-2013 Mr. Rai received the statement of expenditure from petty cashier for the month-end,  December 2013. The statement is as follows
Nature of Expense Amount
Conveyance expenses of marketing executives 600
Shop maintenance expenses 450
Electricity Charges 400
Cell phone Bill 1200

85 ) 31-12-2013 VAT Adjustment Entry
86 ) 31-12-2013 Provision entry to transfer balance from VAT adjustment account to VAT Payable account.
87 ) 1-1-2014 Mr. Rai paid salaries and rent by cheque for December 2013.
88 ) 2-1-2014 Mr. Rai deposited Rs.1,20,000 cash in ICICI Bank.
89) 5-1-2014 Mr. Rai paid VAT due for December 2013 by cheque.
90 ) 8-1-2014 Mr. Rai purchased the following items on credit from X-Tech Services, Orissa.
Item Qty. inPcs. Rate Value Input CST Total Amount
Submersible Pumps 50 1800 90000 4% 93600

91) 12-1-2014 Mr. Rai decides to have a Price List for his Customers. The Price Level where decided on the basis of Old and New Customers are also the volume of items purchased by them..
PRICE LIST FOR OLD CUSTOMERS
Items 0-20 Discount 20-50 Discount 50-Above Discount
High CapacityStabilizer 850 Nil 850 5% 850 7%
Open WellPumps 1600 2% 1600 5% 1600 6%

PRICE LIST FOR NEW CUSTOMERS
Items 0-20 Discount 20-50 Discount 50-Above Discount
Submersible Pumps 2500 Nil 2500 4% 2500 8%

92 14-1-2014 Mr. Rai sold the following items to Soft Touch Traders

Items Qty. Rate Discount Value Output VAT Total Value
Submersible Pumps 30 2500 4% 72000 4% 74880

93) 15-1-2014 Mr. Rai withdrew Rs.13000 from ICICI Bank for personal use.
94) 20-1-2014 Mr. Rai withdrew capital of Rs.5,00,000 from the firm by cheque.
95) 25-1-2014 Mr. Rai received a cheque from Soft Touch Traders for sales made on 14-01-2014
96) 30-1-2014 Mr. Rai received the statement of expenditure from petty cashier January 2014. The statement is as follows
Nature of Expense Amount
Conveyance expenses of marketing executives 500
Shop maintenance expenses 450
Electricity Charges 350
Cell phone Bill 800

SNo. DATE TRANSACTIONS
97) ) 31-1-2014 VAT Adjustment Entry
98 ) 31-1-2014 Provision entry to transfer balance from VAT Adjustment account to VAT Payable account.
99 ) 3-2-2014 Mr. Rai paid VAT due for the month of January 2014 by cheque.
100) 4-2-2014 Mr. Rai paid salaries and rent by cheque for January 2014.
101 ) 8-11-2014 Mr. Rai purchased the following items from Pacific Merchants.
Pacific Merchants
Item Qty. in Pcs. Rate Value Input VAT Total Amount
High CapacityStabilizer 50 500 25000 12.5% 28,125
Open wellPumps 30 1500 45000 4% 46,800
Gross Total 74,925

102 ) 12-2-2014 Mr. Rai Sold the following items To Java Trading Company on Credit
Item Qty. in Pcs. Rate Discount Value Output VAT Total Amount
High Capacity Stabilizer 30 850 5% 24225 12.5% 27,253
Open well Pumps 40 1600 5% 60800 4% 63,232
Gross Total 90,485

103 ) 14-2-2014 Mr. Rai purchased the following items from WinTech Information Systems, Hyderabad on Credit
Item Qty. in Pcs. Rate Value Input CST Total Amount
Low Capacity Stabilizer 50 450 22500 4% 23400

104) 15-2-2014 Mr. Rai withdrew Rs.5,000 from bank for personal use.
105 ) 18-2-2014 Mr. Rai purchased the following items from Icon Enterprises  on Credit
Item Qty. in Pcs. Rate Value Input CST Total Amount
SubmersiblePumps 30 2200 66000 4% 68640

106) 27-2-2014 Mr. Rai received the statement of expenditure from petty cashier February 2014. The statement is as follows
Nature of Expense Amount
Conveyance expenses of marketing executives 700
Shop maintenance expenses 400
Electricity Charges 450
Cell phone Bill 1300

107 ) 28-2-2014 VAT Adjustment Entry
108) 5-3-2014 Mr. Rai paid salaries and rent by cheque for February  2014.
109 ) 15-3-2014 Mr. Rai Sold the following items to Sun-Shine Traders, Kerala on Credit
Item Qty. in Pcs. Rate Output CST Total Amount
High CapacityStabilizer 30 850 4% 2550
Open well Pumps 50 1550 4% 77500
Gross Total 1,07,120

110 ) 18-3-2014 Mr. Rai Sold the following items to Seacrest Trading Corporation on Credit
Item Qty. in Pcs. Rate Value Output VAT Total Amount
High Capacity Stabilizer 5 950 4750 12.5% 5343
Low Capacity Stabilizer 15 750 11250 12.5% 12657
Gross Total 18,000

111) 20-3-2014 Mr. Rai withdraw ` 5,000 from Bank for Personal Use
112) 30-3-2014 Mr. Rai received the statement of expenditure from petty cashier March 2014. The statement is as follows
Nature of Expense Amount
Conveyance expenses of marketing executives 700
Shop maintenance expenses 350
Electricity Charges 500
Cell phone Bill 1800

113 ) 31-3-2014 VAT Adjustment Entry
114 ) 31-3-2014 Provision entry to transfer Balance from VAT Adjustment account to VAT Payable account.







PAYMENT VOUCHER (F5)
2-4-2015 Ms. Kapur issued a cheque and purchased the following fixed assets-
a) A cell phone for office use for Rs. 6000
b) Furniture for Rs. 20000
c) An Air Conditioner for Rs. 15000
3-4-2015 Paid Electricity bill Rs. 1700 in cash.
4-4-2015 Ms. Kapur paid printing & stationery Rs. 400 in cash.
5-4-2015 Ms. Kapur paid wages Rs. 1000 in cash.
12-4-2015 Ms. Kapur paid conveyance bill amounting 1600 in cash to Vijay Narayan.
18-4-2015 Ms. Kapur obtained a Mobile Phone subscription from planet telecommunications ltd. , by paying a deposit of Rs. 3000 in cash.
28-4-2015 Ms. Kapur paid outstanding salary Rs. 15000 by cheque. Chq. No- 221456
30-4-2015 Ms. Kapur paid outstanding office rent Rs. 25000 for march, 2014 by cheque. Chq. No – 221457
10-5-2015 Ms. Kapur clears the dues of Mr. Rajib Sukla of Rs. 45000 from SBI bank (chq. No- 221458) against the bill no. RS/201 and RS/202
15-5-2015 Ms. Kapur paid 32000 by cheque towards against the bill no. SI/206 and SI/208 of Smart India Pvt. Ltd. (chq. No- 221459)


Receipt Voucher (F6)
19-5-2015 Company signed a contract with Silver Services to provided consultancy services at an agreed price of Rs. 75000, He received an advance of Rs. 25000 by cheque (chq. No- 1255686)
20-5-2015 Ms. Kapur received Rs. 15000 as consulting revenue is cash from Omega Infotech.
23-5-2015 Ms. Kapur received Rs. 35000 from Global House against the pending bills by an UBI cheque and deposited into SBI bank on the same day (chq. No- 15208206)
25-5-2015 Ms. Kapur received Rs. 55000 from Cobra Universal against the pending bills by company account cheque Rs. 35000 and cash amount Rs. 20000 (chq. No- 15208286)
26-5-2015 Ms. Kapur received commission from Raj Agency in cash Rs. 2000
27-5-2015 Ms. Kapur received Interest from bank Rs. 2400 in cash
28-5-2015 KBP Plane matured and gets a cheque of 120000 (chq. No- 15208665) and deposited into company accounts.
29-5-2015 Ms. Kapur sales of scrap Rs. 400 in cash
30-5-2015 Company received Rs. 30000 in cash from Ingroove Designers.



Contra Vouchers (F4)
31-5-2015 Ms. Kapur deposited cash amounting to Rs. 75000 in SBI bank
2-6-2015 Ms. Kapur withdrew Rs. 30000 cash from SBI bank
3-6-2015 Cash transfer into Petty cash book Rs. 3000



Journal Vouchers (F7)
04-6-2015 Ms. Kapur received an Invoice for Rs. 6000 from Ink and Paper Publishers for Printing office stationery.
07-6-2015 Ms. Kapur raised an invoice for Rs. 65000 on Alfatech Solutions for service provided.
9-6-2015 Ms. Kapur received an invoice from Raj Travels for Rs. 12000. This includes Rs. 3900 towards Cab Hiring Charges and Rs. 8100 towards Out Station Tours.
11-6-2015 Ms. Kapur used furniture’s worth Rs. 5000 for Personal purpose.
12-6-2015 Purchased Machine for Rs. 5000 from Hindustan Machine Supply Co., Chadnichak on credit.
13-6-2015 Sold an Old Machinery on credit for Rs. 2500 having book of value Rs. 2200 to Gupta Machinery Corner, Howrah.
16-6-2015 Purchased a Building on credit for Rs. 45000 for shifting a part of the business from M/S Roy Building Constructions Co.
20-6-2015 Sold an old Furniture for Rs. 800 on Credit to M/s Saha Old Furniture Stores, Sealdah, having book of value Rs. 1000



Cost Centre and Cost Categories
19-7-2015 Ms. Kapur paid Salaries to his employees through cheque for April, (chq. No- 123455). The details are as follows-
Employees Name                             Salary paid
Rahul Bhatt                                      Rs. 8500
Joyram Sengupta                             Rs. 9300
Shishir Mathur                                Rs. 5200
Ajith V Nair                                     Rs. 3400
22-7-2015 Company allotted Rs. 50000 cash as advertisement cost to his branches Kolkata, Delhi, Mumbai, and Chennai. Distributed the amount as 25% for Kolkata, 15% for Delhi, 28% for Mumbai, and 32% for Chennai.
25-7-2015 Paid a consolidate Telephone bill of Rs. 2800 (Rs. 1700 for 03485-224859 and Rs. 1100 for 03485-224880) by cheque no 1213455 of SBI bank.



Purchase Order (Alt+F4)
18-5-2015 Raise a purchase order with Mr. Rajib Sukla with order no: PO/RS/001, due date 25-5-2015 for the following items –
Items name                  Quantity (nos.)
Table Fan                                     12
Ceiling Fan                                    15
19-5-2015 Company raise a purchase order with Smart India Pvt. Ltd. With order no: PO/SI/002, due date 25-5-2015 for the following items –
Items name                  Quantity (nos.)
Table Lamp                                   10
Iron Boxes                                    12
21-5-2015 Place an order for 9 nos. LG Refrigerator to Smart India Pvt. Ltd. Order no: PO/SI/003, due date 25-5-2015



Receipt Note (Alt+F9)
25-5-2015 Received from Mr. Rajib Sukla against order no: PO/RS/001, as per RN/01 at Dhuliyan godown.
Items name                  Quantity (nos.)
Table Fan                                     12
Ceiling Fan                                    15
25-5-2015 Received another challan from Smart India Pvt. Ltd. Against order no: PO/SI/002 and order no: PO/SI/003 as per RN/02 at Malda godown.
Items name                  Quantity (nos.)
Table Lamp                                   10
Iron Boxes                                    12
LG Refrigerator                             9
26-5-2015 Received a challan (RN/03) from Rolex Electronics Ltd. of 16 nos. CFL Bulbs at Dhuliyan godown.



Rejection Out (Alt+F6)
27-5-2015 Returned 5 nos. Iron Boxes to Smart India Pvt. Ltd., which were not as per specification, towards receipt note no: RN/02



Purchase (F9)
02-6-2015 Receipt a bill form Mr. Rajib Sukla against the previous challan no: RN/01 with the rate of 12nos. Table Fan @ Rs. 2800, and 15nos. Ceiling Fan @ Rs. 3200 (bills no: BL/RS/01)
03-6-2015 Smart India Pvt. Ltd. sent an invoice for the goods retained by the company towards challan no: RN/02 (BL/SI/01). The details are as follows-
Items name            Quantity (nos.)    Rate (nos.)
Table Lamp                              10                   1400
Iron Boxes                                7                     850
LG Refrigerator                        9                   12000
05-6-2015 Company purchased the followings items at Farakka godown from Shyama Traders and paid a cheque (chq. No: MFW12645022) (bills no: BL/ST/01)
Items name            Quantity (nos.)    Rate (nos.)
Table Fan                           8                         2600
Ceiling Fan                          5                         1650
Charger Light                      6                         850
12-6-2015 Company purchased 5 nos. Ceiling Fan @ Rs. 1050 at Malda godown from Bapi Electronics. Bills no: BL/BE/01



Sales Order (Alt+F5)
28-6-2015 Received an order from Cobra Universal order no- ORD/CU/001 for 8 nos. Table Fans from Dhuliyan godown and 5 nos. Table Lamp from Malda godown.
02-7-2015 Received an order from Global House for 6 nos. Iron Boxes and 10 nos. Ceiling Fan from Malda godown (order no: ORD/GH/02)
5-7-2015 Company received an order for 4 nos. Charger Light and 2 nos. Table Fan from Deb Electronics from Farakka godown.


Delivery Note (Alt+F8)
30-7-2015 Goods delivered to cobra Universal against the order (order no: ORD/CU/001) of 8 nos. Table Fan and 5 nos. Table Lamp, Challan no: CH/CU/001
30-7-2015 Goods delivered to Global House against the order (order no: ORD/GH/002) of 6 nos. Iron Boxes and 10 nos. Ceiling Fan. Challan no: CH/GH/002
31-7-2015 Goods delivered to Deb Electronics against the order (order no: ORD/DE/003) of 4 nos. Charger Light and 2 nos. Table Fan. Challan no: CH/DE/003



Rejection In (Ctrl+F6)
02-8-2015 Global House returned 3 nos. Ceiling Fan due to some problem against the challan – CH/GH/002


Sales (F8)
3-8-2015 Invoice send to Cobra Universal against the previous challan (challan no: CH/CU/001) with the rate of 8 nos. Table Fan @ Rs. 2950 and 5 nos. Table Lamp @ Rs. 1580 (Bills no: BL/CU/01)
3-8-2015 Invoice send to Global House against the previous challan (challan no: CH/GH/002) with the rate of 6 nos. Iron Boxes @ Rs. 950 and 7 nos. Ceiling Fan @ Rs. 1800 and with 5% trade discount. (Bills no: BL/GH/002)
4-8-2015 Invoice Send to Deb Electronics against the previous challan  (challan no: CH/DE/003) with the rate of 4 nos. Charger Light @ Rs. 980 and 2 nos. Table Fan @ Rs. 2750 with 4% trade discount. (Bills no: BL/DE/003)
4-8-2015 Sold 3 nos. Of LG Refrigerator @ Rs. 13500 in cash. Bills no: BL/Sal/001 from Malda godown with 3% trade discount.

GST
Change all purchase and sales bill and add @ 12% GST
12-10-2015 Purchase for Farakka godown from Spic-N-Span Traders on Credit of 10 days, (Bills no: BL/SST/01) the following items –
Items Quantity(nos.) Rate GST @ 12% Value
Mouse 10 200 12% 2000
Key Board 15 320 12% 4800
LED Monitor 8 10000 12% 80000

15-10-2015 Sales 5 nos. Ceiling Fan @ Rs. 1900 from Malda godown and 2 nos. Charger Light @ Rs. 980 from Farakka godown to Acron Clothing Ltd. with 12% GST (Bills no: BL/ACL/01)


Free Goods Treatment
20-10-2015 Ms. Kapur purchased the following items under a sales offer. He paid by cheque. The offer is follows –
On Purchase of 10 High Capacity Stabilisers, 1 HCS is given free of cost.
On purchase of 5 Low Capacity Stabilisers, 1 LCS is given free of cost.
Items Purchase quantity Free of Cost Total Quantity Rate Value GST(%) Total Amount
High Capacity Stabilisers 50 5 55 650 32500 12% 36563
Low Capacity Stabilisers 20 4 24 400 800 12% 9000

22-10-2015 Ms. Kapur introduced a sales offer and sold the following items on credit to Java Trading Company and Data Tech Services.
Java Trading Company
Items Purchase quantity Free of Cost Total Quantity Rate Value GST(%) Total Amount
High Capacity Stabilisers 20 5 25 725 14500 12% 16312.5
Low Capacity Stabilisers 10 2 12 450 4500 12% 5062.5

Data Tech Services
Items Purchase quantity Free of Cost Total Quantity Rate Value GST(%) Total Amount
High Capacity Stabilisers 20 5 25 725 14500 12% 16312.5
Low Capacity Stabilisers 10 2 12 450 4500 12% 5062.5




Debit Note (Ctrl+F9)
5-11-2015 Company returned 2 nos. Table Fan @ Rs. 2600 to Shyama Traders from Farakka godown with 4% VAT against the Bills no: BL/ST/01, Debit Note no: DB/ST/01





Credit Note (Ctrl+F8)
8-11-2015 Global House returned 2 nos. Iron Boxes @ Rs. 950 and 1 nos. Ceiling Fan @ Rs. 1800 Malda godown with 12% GST against the bill no: BL/GH/02. Credit Note no: CB/GH/01



Manufacturing Accounts
17-11-2015










The company purchased raw materials on 15 days credit from Ultra Tech Computers, stored them in the raw materials godown, and paid carriage in ward expenses of Rs. 400
Items Quantity Rate VAT Value
Processor(Athlon) 50 5700 4% 285000
Hard Disk 100 2800 4% 280000
Monitor 110 8500 4% 935000
Processor (P4) 50 6800 4% 340000

19-11-2015









The company purchased the following raw-materials from Isilon Systems, on 30 days credit, which was stored in the raw-materials godown. Carriage in Ward expenses of Rs. 350 was paid.
Items Quantity Rate VAT Value
Keyboard 110 280 4% 30800
Mouse 100 180 4% 18000
Motherboard 100 3200 4% 320000

28-11-2015 The following items were transferred from raw-material godown to assembling godown.

Items Quantity
Processor (Athlon) 25
Hard Disk 50
Processor (P4) 25
Monitor 50
Keyboard 50
Mouse 50
Motherboard 50

28-11-2015 To assemble one computer (P4), the following peripherals are required –
Name of the Peripheral Quantity
Processor (P4) 1 nos.
Monitor 1 nos.
Motherboard 1 nos.
Hard Disk 1 nos.
Mouse 1 nos.
Keyboard 1 nos.
The company assembled 20 computers with P4 configuration using the peripherals listed in the above table and stored the same in the finished goods godown. Wages of Rs. 30000 and overheads of Rs. 2000 were incurred.
The wages were paid by cheque.
29-11-2015 The company sold computer (P4) to Inter Fex Corporation on credit of 15days.
Items Quantity Rate VAT Value
Computer (P4) 10 nos. 28500 4% 285000


Budget
Period of Budget Ledger Amount
1-4-2015 to 31-3-2016 Tiffin Expenses 15000
1-4-2015 to 31-3-2016 Advertisement Expenses 2500
1-4-2015 to 31-3-2016 Wages 85000
 
01-01-2016 Paid Rs. 200 for Tiffin Expenses in cash
02-01-2016 Paid Rs. 8500 for wages in cash
05-01-2016 Paid Rs. 6000 for Advertisement in cash
01-02-2016 Paid Rs. 9500 for wages in cash
04-02-2016 Paid Rs. 1500 for Tiffin Expenses in cash
01-03-2016 Paid Rs. 3500 for Advertisement in cash




Job Costing
01-01-2016 Purchase 500 Bags of Cement @ Rs. 250, 1000 tons of Iron&Steel @ Rs. 16000 for Sealdah godown from Alco Creations. Bill no: AC/P/001 (Item Invoice)
02-01-2016 Payment made for transportation and General maintaince for the building project Rs. 5000 and 1000 through SBI cheque. (chq. No: 100011)
04-01-2016 Project Inspection charges paid for the Building Project Rs. 5000 through cash
12-01-2016 100 bags of Cement 500 tons of Iron&Steel consumed for Building Project from Sealdah godown.
18-01-2016 Sold the project to Vishal Enterprise for Rs. 100000 Bill no: VE/S/001




Service Tax
20-01-2016 A Bill of Rs. 25000 for course fees made on Kamal Sarma, Service Tax charge @ 12% Cess 2% and Sec Cess 1%   (Bill no: ST/KS/01)
20-01-2016 Received full amount outstanding from Kamal Sarma in cash
23-01-2016 Received a Telephone Bill of Rs. 18000 from BSNL with @ 12% Service Tax 2% Cess and 1% Sec Cess (Bill no: ST/BS/01)
25-01-2016 Paid the Telephone Bill with service tax to BSNL in cash
31-01-2016 Now adjust the service tax and clear the service tax payable amount from SBI cheque. (Chq. No: 100008)


TDS (Tax Deduction at Source)
15-8-2015 Received Invoice from Rajib Bharghav, chartered accountant, towards Internal Audit of Accounts Rs. 25000 (Bill no: RB/01)
16-8-2015 Paid to Rajib Bharghav towards his invoice after deducting TDS Rs. 1403 on amount payable to him by cheque. Chq. No: 12345601
22-8-2015 Give an advance of Rs. 15000 to K.N. Mukharjee in cash for Advertisement news in the press. Advance ref. ADV.KNM/01. But total Advertisement value is 25000. Paid remaining amount after deducting TDS. Bill no: KNM/01
25-8-2015 Now clear all the outstanding TDS to the government through company bank accounts. Cheque no: 45678902


No comments

Theme images by i-bob. Powered by Blogger.