0% found this document useful (0 votes)
537 views26 pages

Hackathon Problem Statement Tally With GST

The document outlines the creation of multiple companies with specific details such as names, addresses, financial years, and transactions for each company. It includes journal entries, balance sheets, and various financial reports for the companies, covering different scenarios and transactions. Each problem statement provides a unique set of financial activities to be recorded and reported.

Uploaded by

dineshr2023aids
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
537 views26 pages

Hackathon Problem Statement Tally With GST

The document outlines the creation of multiple companies with specific details such as names, addresses, financial years, and transactions for each company. It includes journal entries, balance sheets, and various financial reports for the companies, covering different scenarios and transactions. Each problem statement provides a unique set of financial activities to be recorded and reported.

Uploaded by

dineshr2023aids
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

PROBLEM STATEMENT 1

Create a company:

Name : ABC Corporation .


Mailing Name: ABC Corporation .
Address: Shastri Nagar
Chennai, India
State: Tamil Nadu
Pin Code: 600 001
Telephone No. 011-23282697
E-Mail Address: abc@[Link]
Currency Symbol Rs.
Maintain: Accounts Only
Financial year from: 1-4-2024
Books beginning from: 1-4-2024
Tally Vault No
Security Control No
PROBLEM STATEMENT 1
PROBLEM
STATEMENT 2

Create a company:

Name : ABC & Co .


Mailing Name: ABC & Co.
Address: Anna Nagar, Chennai.
State: Tamilnadu.
Pin Code: 600001
Telephone No: 044-23282697
E-Mail Address: abc@[Link]
Currency Symbol Rs.
Maintain: Accounts Only
Financial year from: 1-4-2024
Books beginning from: 1-4-2024
Tally Vault No
Security Control No

Pass Journal Entries


Business started by Shyam with 5,00,000 cash, 2,00,000 Machinery,
1,00,000 Livestock.
1. Goods purchased from ABC 60,000/-.
2. Goods given in charity 50/-.
3. Salary paid to A Deptt. 5,000/-, B Deptt. 10,000/-, C Deptt. 10,000/
4. Furniture & Computer bought for office use Rs. 20,000 & 30,000
respectively.
5. T.V. bought 5,000/- and taken at home.
6. Pickle given as free sample 2000/
7. Goods sold 10000/ to ABC cash received 2000/,Cheque received 3000/
B R received 5000/
8. Broom purchased 10/-
9. Paid to car mechanic 500/10. Paid for Postage Stamps 100/-
11. Compensation received from supplier by court
order 5000/12. Loss by Fire 10000/- Insurance
company will pay only 5000/-
13. Partially burnt goods sold as salvage & recovered 3000/-

Journalise the following transactions.


1. Business started by AMC with Machinery 30,000/, Hari (Debtor) 20,000,
Girish 10,000(Creditor), Cash 30,000.
2. Wood purchased for furniture 7000/-.
3. Advance given to Carpenter 3,000/
4. Paid for white-wash of building 1000/
5. Account opened in Bank of Baroda 3000/6. Goods purchased 10,000/- &
B/P given.
7. Goods sold & Draft received from Garry 7,000/-
8. Interest given by Bank 100/- ,Cheque charge 70/
9. 10. BMC partner joined firm & paid 20,000/-.
10. Refund of EMD received 2000
PROBLEM STATEMENT 3

Create a company:

Name : Alfha Tech Ltd.


Mailing Name: Alfha Tech Ltd.
Address: Anna Nagar, Chennai.
Statutory compliance for India
State: Tamilnadu.
Pin Code: 600 001
Telephone No. 011-23282697
Email Address:
alfhatech@[Link]
Currency Symbol Rs.
Maintain: Accounts Only
Financial year from: 1-4-2023
Books beginning from: 1-4-2023
Tally Vault No
Security Control No

Balance Sheet of Alfha Tech Ltd. 2023-24

Liabilities AMT. Assets AMT.


Aptech’s Capital 10,000 Machinery 10,000
General Reserve 10,000 Shares 10,000
Overdraft 10,000 Cash 10,000
Girish 10,000 Stock 10,000
P&L 10,000 Staff Advances 10,000
Outstanding Rent 10,000 Harish 10,000
60,000 60,000

2024-2025
1 Apr Goods purchased from Girish 700
1 Apr Goods Sold to Harish 12000
1 May Goods returned by Harish 100
1 May Goods returned to Girish 200
1 Jun Aptech Withdraws 500
1 Jun Cash deposited in PNB 2000
1 Jul Interest received 3000
1 Jul Salary Paid 1000
1 Aug Outstanding Rent paid 5000
1 Aug Depreciate Machinery @ 10%
1 Sep Goods purchased 500
1 Sep Goods sold 1000

Report :: Trial Balance, Trading & Profit and Loss,Balance Sheet


Calcluator
PROBLEM STATEMENT 4

Create AXL & Sons Company with book Beginning 2023 and
Maintain current Financial Year accounts 2024 - 2025

Liabilities AMT. Assets AMT.


A’s Capital 30,000 L’s Capital 20,000
X’s Capital 20,000 Staff advance 5000
Gen Reserve 50,000 Shares 10,000
Loan from friends 30,000 NSC / NSS 10,000
CC A/c 20,000 Cash 25,000
B/P 30,000 Prepaid Insurance 20,000
Outstanding Salary 20,000 P&L 5,000
Def Res. & Dev. Exps. 1,000
Closing Stock 4,000
Zenith Ltd. 1,00,000
[Link]. 29 1-1-07/60 30,000
[Link]. 35 1-2-07/30 20,000
[Link]. 37 1-3-07/30 50,000
2,00,000 2,00,000

1st Apr. Rs. 10,000 cash received from Zenith against Bill No. 29.
1st May. Sweets box purchased for Employees 2000/-
1st June Free samples given 1500/-.
1st July Goods sold to Zenith Bill No. 138/1-8-07 Rs. 20,000.
1st Aug. Outstanding salary paid 3000/-.
1st Nov. Interest charged by bank 5000/-.
31st Dec. Shares sold for 12000/-.
31st Mar. Closing stock 10,000.

Report: Balance of Zenith in Statement Of Account


Balance of Zenith in Balance Sheet
Use Multiple Ledger
PROBLEM STATEMENT 5

Create Rajan & Sons – (2024 - 2025) Company for current financial year
Capital Fixed Assets
A’s Capital 50,000 Land & Building 20,000
B’s capital 60,000 Computers 10,000
Res. & Surplus Machinery 10,000
Gen. Res. 30,000 Motor Car 5,000
P & L A/c 40,000 Furniture 5,000
Reserve for Machinery 30,000 Goodwill 10,000
Loans Patent 10,000
Term Loan 30,000 Copyright 10,000
Loan from friends 30,000 Music Rights 20,000
Mortgage/ Hypothecation 40,000 C’s Capital 10,000
Current Liabilities Investments
Girish 10,000 FDR 50,000
Ganesh 10,000 Shares 30,000
B/P 10,000 Debentures 10,000
Cc A/c 10,000 Investment in Firm 10,000
Overdraft 10,000 Tender Deposit 10,000
Outstanding Salary 10,000 Loans & Advances
Unearned Interest 10,000 Loan to Staff 10,000
VAT Payable 10,000 Loan to Supplier 10,000
PF Payable 10,000 Advance Salary 20,000
ESI Payable 10,000 Current Assets
Cash 10,000
Bank of Baroda 10,000
Stock 10,000
B/R 10,000
Prepaid premium 10,000
Accrued Interest 30,000 Ram 20,000
Misc. Exps.
Prelim. Exp. 20,000
Deferred R &D 10,000
Deferred Advertisement 20,000
4,10,000 4,10,000

1 Apr Goods purchased 5,000 1 Oct Ram will not pay 1000
1 May Goods sold 7000 31 Mar Interest on FDR due but not received 500
1 Jun Salary paid 100 31 Mar Interest received in advance 100
1 Jul Interest received 10000 31 Mar Insurance premium paid in advance 500
1 Aug Cash deposited 10000 31 Mar Salary due but not paid for March 100
1 Sep Salary paid 50 31 Mar Closing Stock 5000
PROBLEM STATEMENT 6

Create AAA & Sons Company for 2024-25 and make transaction on Aril 1st and
generate cash flow and Fund flow & Ratio analysis.

(Adjustment Entries)
Liabilities Amount Assets Amount
Capital of X 1,000 Cash 32,000
Unearned Interest 3,000 Accrued Interest 1,000
Outstanding Rent 32,000 Prepaid Maintenance Charges 1,500
Prelim. Exps. 500
Shares & Deb. 1,000
Total Rs. 36,000 Total Rs. 36,000

1. Prepaid charges are related to current year.


2. Goods purchases from Hari 20000.
3. Goods sold to Shyam 25000.
4. Insurance charges paid in Advance for 2007-2008 Rs. 3000/-.
5. Interest is due 2006-07 on FDR Rs. 2000/- but not paid by the bank.
6. Salary due but not paid 3000/-.
7. Write off preliminary expenses using P & L A/c 300/-.
8. Cash deposited in Bank 100/-.
9. Interest received in cash 10000/-.
10. Goods returned to Hari 750/-.
11. Goods returned by Shyam 700/-.
12. Salary related to previous year paid in current year 1000/-.
13. Loan given to supplier Yash Enterprises 3000/-.
14. A consumer last year filed a compensation case for 1000/-.

Report :: Cash Flow,Fund Flow & Ratio Analysis


PROBLEM STATEMENT 7

Create Inventory Company

Mittal Corporation Ltd.


2024-2025
Liabilities AMT. Assets AMT.
Amit’s Capital 1,70,000 Stock: Computers
P & L A/c 20,000 Desktop 1 @ 15,000 ,Vaishali Ngr. 15,000
Overdraft 10,000 Laptop 1 @ 40,000 , Vaishali Ngr. 40,000
Machines:
Drill 3 @ 5000 , Shastri Ngr 15,000
Lathe 1 @ 10,000,Shastri Ngr. 10000
Cash in hand 1,20,000
2,00,000 2,00,000

1 Apr 3 Desktop purchased @ 20,000/- Bill No. 23.


1 May 1 Laptop purchased @ 50,000/- Bill No. 25 from Mehta & Co..
1 Jun Drill purchased 2 @ 5,500/- Bill No. 27 from Kumar Ltd.
1 Jul 4 Desktops sold @ 20,000/- Bill No. 10. to Jain & Sons.
1 Aug 2 Laptops sold @ 60,000/- Bill No. 35.
1 Sep Deposited in Bank 1,000/-.
1 Oct Amit withdrew 500/- for personal use.
1 Nov Lathe sold 1 @ 12,000/- Bill No. 55.
1 Dec Interest credited in Mehta & Co. account 500/-.
1 Dec 1 Desktop returned by Jain & Sons.

Reports: Valuation Option


Range & Value.
PROBLEM STATEMENT 8

Create Inventory Company

Mitesh & Sons.


2024-2025
Liabilities AMT. Assets AMT.
Ram’s Capital 40,000 Stock
Shyam’s Capital 10,000 Cotton : B12 100 Kg @ 10 1000
Imported 10 Kg @ 100 1000
Thread: Red 10 spindles @ 3000 30,000
Yellow 10 spindles @ 1500 15,000
Cloth: Raw 100 mtrs. @ 30 3000
Total Rs. 50,000 Total Rs. 50,000

1 Apr Cotton B-12 purchased from Sandy 500 kg @ 12/-.


1 May Thread sold 5 red spindles @ 4000/- to Garry.
1 Jun Cloth: Raw sold 50 meters. @ 15/-.
1 Jul Cotton: B-12 returned 100 kg. @ 12/- to Sandy.
1 Aug 2 Red spindles returned by Garry.
1 Sep Ram introduced additional Capital 5000/-.
1 Oct Shyam withdraws 3000 for personal use.
1 Nov B12 10kg given in charity @ 10.
31 Mar Wages paid 1000.

Reportd::
:: Split company wef 1st Aug 2007
:: Exception Report
:: Go for Backup & Restore
PROBLEM STATEMENT 9
Create Rajan & Co company on Current finical year and Make Debit Note & Credit Note
Transaction

1) F11 🡪Accounting /Inventory Features


Use Debit Credit Notes : Yes
Use Invoice Mode for Credit Notes: Yes
Use Invoice Mode for Debit Notes: Yes
2) G.O.T. 🡪 Voucher Entry 🡪 F8 for Credit Note – F9 for Debit Note
3) G.O.T. 🡪 Accounts Info 🡪 Ledger 🡪 Create:- Sales Return and
Purchase Return
4) Create Sales Party Name and Purchase Party Name

Party Name
Sr. No Group Name Purchase Sales
1 Pen Kirti Journal Store Nehal Journal Store
2 Groundnut Rajesh Prov. Store Naman Oil Depo
3 Soft Drink Nakhilekh Parlour Pepsi Industries
Unit: - Pcs-Pieces-0 Group: - Pen
Item Opening Purchase Purc. Sales Sales Cl
(Return) (Return) ose
Qty Rate Amt Qty Amt Qty Amt Qty Rate Am Qty Am
Reynold 40 14 ? 20 ? 10 ? 12 20 ? 6 ? 44
Cello 50 6 ? 25 ? 10 ? 15 7 ? 5 ? 55
Parker 50 48 ? 30 ? 15 ? 15 50 ? 5 ? 55
Add Gel 50 20 ? 40 ? 20 ? 22 20 ? 8 ? 56
Link 20 4 ? 12 ? 6 ? 6 5 ? 2 ? 22
Unit: - Kg-kilogram-3 Group: - Groundnut
Item Opening Purchase Purc. Sales Sales Clo
(Return) (Return) s
Qty Rate Amt Qty Am Qty Amt Qty Rate Am Qty Am
Dhara 35 12.5 ? 20 ? 10 ? 15 15.5 ? 5 ? 35
Gulab 33 15.5 ? 22 ? 8 ? 11 16.5 ? 4 ? 40
Gokul 18 13.5 ? 12 ? 5 ? 6 15.25 ? 2 ? 21
Maruti 66 14.7 ? 42 ? 20 ? 24 17.4 ? 10 ? 74
Dharti 28 45.5 ? 18 ? 7 ? 10 50.5 ? 6 ? 35
Unit: - Pcs-Pieces-0 Group: - Soft drink
Item Opening Purchase Purc. Sales Sales Clos
(Return) (Return)
Qty Rate Amt Qty Amt Qty Amt Qty Rate Amt Qty Amt
Pepsi 20 10 ? 10 ? 5 ? 5 10 ? 2 ? 22
Mirinda 25 12 ? 15 ? 6 ? 6 12 ? 1 ? 29
Milda 30 15 ? 15 ? 7 ? 7 15 ? 3 ? 34
Thrill 35 18 ? 10 ? 3 ? 3 18 ? 1 ? 40
Cock 40 20 ? 20 ? 10 ? 10 20 ? 2 ? 42
PROBLEM STATEMENT 10

Create John Garments on current finical year (2024-25) and make sales and
purchase order
F11: Inventory Features:
1) Allow Invoicing Yes
2) Allow Purchase Order Processing------------------Yes
3) Allow Sales Order Processing-----------------------Yes
4) Use Tracking Numbers-------------------------------Yes
5) Use Rejection Notes-----------------------------------Yes
F12: Invoice\Order Entry:
1) Accept Supplementary Details------------------------Yes
2) Use Common Ledger A/c for item Allocation------Yes

Group: Shoes Unit: Pair—Pairs—0


Purchase Order:
Item Open Rate Amount Purch. Purchase Receipt Purchase Pay
Name Qty Party Order Note
Action 1000 200 200000 Steve 120 80 80 8000
Adidas 400 300 120000 Mark 180 80 80 12000
Bata 400 300 120000 Ponting 100 60 60 9000
Carona 800 150 120000 Hayden 240 180 180 12000
Formal 1600 100 160000 Clark 400 300 300 15000
Nike 1000 200 200000 Martin 120 40 40 4000
Paragon 200 125 12500 Heddin 60 20 20 1250
Reebock 1200 250 300000 Symonds 200 100 100 12500
Lakhani 600 350 210000 Warn 280 200 200 35000

Sales
PROBLEM STATEMENT 11

Create ABC Company on Financial year 2023-24 and make all type of transaction
on 31 March 2023.

1) Purchase Stationary from J.P. Brothers worth Rs 1500.


2) Sold Goods worth Rs 10000 to Hetal & Payal Co.
3) Purchase goods worth Rs 2000 from Rehana trading.
4) Purchase a Cabinet worth Rs 4500 from Mehta Furniture.
5) Sold goods worth Rs 20000 to Jaiminee
6) Paid Rs 1200 to J.P. Brothers.
7) Paid Rs 500 for Carraige inward.
8) Receive 5000 from Hetal & Payal Co.
9) Paid Rs 1500 to Rehana by cheque
10) Receive cheque of Rs 14000 from Jaiminee.
11) Given Rs 15000 to K.C. Joshi on credit.
12) Receive 3500 from Hetal & Payal Co.
13) Receive 4000 from Jaiminee.
14) Bad Debts Rs 1500 to Hetal & Payal Co.
15) Paid Office Rent Rs 5000 by cash.
16) Paid Salary 1900 by cheque
17) Paid Conveyance Exp Rs 1500 by cash.
18) Bad Debts Rs 2000 to Jaiminee.
19) Paid Rs 2000 for Miscellaneous Exp.
20) Bad Debts Return Rs 1000 from Hetal & Payal Co.
21) Receive Rs 10000 from K.C. Joshi.
22) 10% Depreciation on Furniture.
23) Receive 3500 from K.C. Joshi
24) Bad Debts 1500 to K.C. Joshi.
25) Bad Debts Return Rs 1500 from Jaiminee.
26) 15% Depreciation on Machinery.
27) Bad Debts Return Rs 1000 from [Link].
28) Receive an invoice for Traveling Exp from Raj [Link].10,000.
29) 25% depreciation on computer.
30) Paid Full Amount to Raj Travels.
PROBLEM STATEMENT 12

Create XYZ Traders on current financial year 2024-2025 and Make following transaction
on 1 April 2024

Purchase Entries
1. Purchased from Raja & Co. 500 ITEM-1 @ Rs.20/- each on a credit of 30 days.
2. Purchased from Ramesh & Co. 250 ITEM-2 @ Rs.25/- each.
3. Purchased from Ramesh & Co. the following
ITEM-1 100 20
ITEM-2 250 40
ITEM-4 400 100

4. Purchased from Sanghavi Traders-M.P 1000 ITEM-1 @ Rs.12/-


5. Purchased from Ramesh & Co. ITEM-5 500 qty @ Rs.125/-
6. Raja & Co Returned ITEM-1 50 qty as they were damaged.
7. Good Returned to Ramesh & Co.
ITEM-1 25
ITEM-2 100
ITEM-4 200

8. Purchased from Raja Sons 1000 ITEM-3 from Jammu @ 89/-


Sales Entries
1. Sold Goods as per details give below to Rakesh Sharma & co.
ITEM-1 500 55
ITEM-2 200 90
ITEM-3 350 145
ITEM-4 50 180
ITEM-5 100 225

2. Sold goods to Chota Shakeel 750 ITEM-1 @ Rs. 75/-


3. Sold goods to Apple & Co. of Delhi as follows :-

ITEM-1 200 150


ITEM-2 100 125
ITEM-3 300 195
ITEM-4 50 300
ITEM-5 200 325
PROBLEM STATEMENT 12

4. Apple & Co. Returned the following Goods Back


ITEM-1 20 150
ITEM-2 20 125
ITEM-3 20 195
ITEM-4 20 300
ITEM-5 20 325

Generate Report:
Stock Summary Report
Purchase Register
Sales Register
Debit Note Register
Credit Note Register
Payable & Receivable report
PROBLEM STATEMENT 13

Accounts with Inventory


Create a company in the name of Asian Car Arcade for the year ending 2024.
Prepare the required ledgers, stock group, category, items, godown and pass the transactions
taking the following into consideration, entry to be done in invoice mode.
F11 Features to be activated:-

Under Maruti Maruti 800, Zen, Esteem, Baleno.


Under Hyundai Ascent, Hyundai Deluxe, Hyundai

Regular. Under Premiere Fiat, Uno, Siena.

Under Tata Indica, Sumo, Estate, Sierra.


Under Hindustan Ambassador, Contessa.
Transaction
 Purchased the following on 01.06.2023, discount 2%
Quantity Name Rate Godown
3 Zen 400000 Mumbai
2 Ascent 550000 Mumbai
2 Uno 375000 Pune
4 Siena 575000 Pune
2 Sumo 500000 Mumbai
5 Indica 400000 Mumbai

 On 02.06.2023 sold following cars to Patel Motors, discount 2%


Quantity Name Rate
1 Zen 475000
1 Siena 610000
1 Indica 450000

 On 01.07.2023 sold following cars to Dhruv Motors, discount 2%


Quantity Name Rate
1 Ascent 580000
1 Indica 430000

 On 02.07.2023 sold following cars to Gupta Car Arcade, discount 2%


Quantity Name Rate
1 Zen 460000
1 Siena 600000

 On 31.07.2023 sold following cars to Continental Motors, discount 2%


Quantity Name Rate
1 Sumo 550000
PROBLEM STATEMENT 13

1 Zen 450000
1 Siena 600000

 Received on 01.08.2023 Rs. 1125000/- from continental Motors after deducting discount
on total bill amount.
 Paid 50% bill amount from which 7.5% discount on bill amount has been paid for Hyundai
motors on 02.08.2023.
 On 31.08.2023 received 75% bill amount after deducting 11.25% on net bill from Dhruv
Motors.
 Paid full amount after deducting 15% discount to Premeiere 01.09.2023.
 Sold 1 Indica @ Rs. 450000 to Ramesh Motors (add 4% sales tax) on 02.09.2023.
 Sold 1 Siena @ Rs. 600000 and 1 Uno @ Rs. 400000 to Trilok Motors (add 4.8% sales tax)
on 31.09.2023.
PROBLEM STATEMENT 14

Given below is the trial balance of M/s. Sameer and Reena on 31 st Dec. 2023. They divide profits and
losses as 3:2 respectively. From the following trial balance you are required to prepare Trading and
Profit and loss account for the year ended 31 st December 2023 and the Balance Sheet as on that
date.

Trial balance as on 31st December 2023

Particulars Debit Particulars Credit


Rs. Rs.

Stock (1-1-88) 60,000 Sales 1,01,250

Purchases 1,20,000 Purchases Returns 1,000

Sales Returns 1,500 Capital account Sameer 80,000

Drawings Sameer 9,000 Capital account Reena 60,000

Drawings Reena 7,000 Current A/c. Reena 2,000

Current A/c. Sameer 3,000 Bank Overdraft 4% p.a. 17,000

Sundry Expenses 1,750 Discount Received 600

Wages 15,000 Dividend Received 2,400

Salaries 16,400 Sundry Creditors 10,000

Travelling Expenses 1,600 Bills Payable 25,000

Advertisement 6,000 Outstanding Wages 2,000

Rent, Rates and Taxes 12,500 Loan from Dena bank @ 12% 5,50000

Bad Debts 13,000

Discount 1,400

Commission 1,500

Buildings 1,80,000

Machinery 1,20,000

Furniture 75,000

Sundry Debtors 30,000

Cash in Hand 25,000


PROBLEM STATEMENT 14

Cash at Bank 2.5% interest p.m 1,22,000

Bills Receivable 27,000

Prepaid Insurance 2600

8,51,250 8,51,250

Additional Information at the end of the year.

 Closing Stock as on 31-12-2023 Rs. 57600/-

 Outstanding Rent Rs. 400/- Salaries Rs. 600/-


 Provide depreciation on Building 10% Machinery 20% and Furniture 15%.
 Provide 10% interest on partner’s capital. Sameer is entitled to get Rs. 1,500/- as salary
per month for his extra work for 3 Months.
 Partnership firm charges 5% interest on drawings.
 Share profit/loss in the ratio given

Reports: Display Balance sheet, Profit & Loss, Trial Balance.

Merge both the company and create a Group company, showing individual balance

sheet, profit / loss account, and also group wise details for the same.
PROBLEM STATEMENT 15

Create a Company Raman Shop, as on 2023-24


On 1-4-24 Raman commenced business with cash of Rs. 25,00,000. He further introduced Land and
Building costing Rs. 30,000, Plant and Machinery costing Rs. 25,000 and furniture and fixture
costing Rs. 36,000.
2. On 2-4-24 Purchased Vehicle and Patents Rs. 20,000 and Rs. 15,000.
3. On1-5-24 He deposited Rs. 1,00,000 into Canara Bank.
4. On 2-5-24 Purchased from Cadbury Company, discount 1%
500 5 Stars @ Rs. 5 1000 Munch @ Rs. 5
100 Kit kat @ Rs. 4 200 Dairy milk @ Rs. 7

5. On 31-5-24 Purchased from Paras, discount 2%


500 Moov @ Rs. 20
500 D’Clod @ Rs. 12
6. On 1-6-24 Purchased from Amber, discount 2%
450 Adhensive tape roll @ Rs. 14.50
200 Band Aid box @ Rs. 240
300 Boric Acid powder @ Rs. 13

7. On 1-6-24 Sold to Pankaj, discount 2%


200 Moov @ Rs. 20.50
100 D’Clod @ Rs. 12.25
200 Adhensive tape roll @ Rs. 15.25
100 Band Aid box @ Rs. 252
200 Boric Acid powder @ Rs.14

8. On 2-6-24 Sold to Akbar, discount 2%


500 Munch @ Rs. 6
200 5 Star @ Rs.5.25
50 Kit Kat @ Rs. 6
9. On 1-7-24 Paid to Cadbury company Rs. 7500/- in cash.
10. On 2-7-24 Received from Pankaj Rs. 30000/- by cheque
11. On 31-7-24 Paid to Paras Rs. 12000/- by cheque
12. On 2-8-24 Received from Akbar Rs. 3500/- in cash
13. On 2-8-24 Purchase from Well Cloth
T-Shirts Lee 25Pc @ Rs.200

Nike 30Pc @ Rs.300


Formal Shirts Pan America 35Pc @ Rs. 400

Peter England 30Pc @ Rs. 450


PROBLEM STATEMENT 15

Jeans Pants Tiger 20Pc @ Rs. 500


Ruff and Tuff 30Pc @ Rs. 350
Cotton Pants Arrow 40Pc @ Rs. 200
Ex-Calibar 20Pc @ Rs. 250
13. Paid Postage Rs. 500 by cheque
14. Received commission Rs. 15,000
15. Paid wages Rs. 2,500
Procedure for Inventory Problem
Gateway of Tally-Inventory Info-Unit of Measure-Create-
Symbol- Nos. Pcs
Formal Name- Number Pieces

Gateway of Tally-Inventory Info-Stock Group-Create


Chocolate, Medicines, Cotton Pants, Jeans Pants, Formal Shirts, T-Shirts

Gateway of Tally-Inventory Info-Stock Item-Create

5 Stars
Kitkat Chocolate
Munch

Dairy

milk

Moov

D’Clod

Adhensive tape rolls

Medicines Band Aid box

Boric Acid powder

Lee T-Shirts
Nike

Pan America Formal Shirts


Peter England
Tiger Jeans Pants
Ruff and Tuff

Arrow
Ex-Calibar Cotton Pants
PROBLEM STATEMENT 16
Kumaran & Sons
2023-2024
Capital Fixed Assets
A’s Capital 50,000 Land & Building 20,000
B’s capital 60,000 Computers 10,000
Res. & Surplus Machinery 10,000
Gen. Res. 30,000 Motor Car 5,000
P & L A/c 40,000 Furniture 5,000
Reserve for Machinery 30,000 Goodwill 10,000
Loans Patent 10,000
Term Loan 30,000 Copyright 10,000
Loan from friends 30,000 Music Rights 20,000
Mortgage/ Hypothecation 40,000 C’s Capital 10,000
Current Liabilities Investments
Girish 10,000 FDR 50,000
Ganesh 10,000 Shares 30,000
B/P 10,000 Debentures 10,000
Cc A/c 10,000 Investment in Firm 10,000
Overdraft 10,000 Tender Deposit 10,000
Outstanding Salary 10,000 Loans & Advances
Unearned Interest 10,000 Loan to Staff 10,000
VAT Payable 10,000 Loan to Supplier 10,000
PF Payable 10,000 Advance Salary 20,000
ESI Payable 10,000 Current Assets
Cash 10,000
Bank of Baroda 10,000
Stock 10,000
B/R 10,000
Prepaid premium 10,000
Accrued Interest 30,000
Ram 20,000
Misc. Exps.
Prelim. Exp. 20,000
Deferred R &D 10,000
Deferred Advertisement 20,000
4,10,000 4,10,000
1 Apr Goods purchased 5,000 1 Oct Ram will not pay 1000
1 May Goods sold 7000 31 Mar Interest on FDR due but not received 500
1 Jun Salary paid 100 31 Mar Interest received in advance 100
1 Jul Interest received 10000 31 Mar Insurance premium paid in advance 500
1 Aug Cash deposited 10000 31 Mar Salary due but not paid for March 100
1 Sep Salary paid 50 31 Mar Closing Stock 5000
PROBLEM STATEMENT 17

Ansari & Sons.


2023-2024
(Adjustment Entries)
Liabilities Amount Assets Amount
Capital of X 1,000 Cash 32,000
Unearned Interest 3,000 Accrued Interest 1,000
Outstanding Rent 32,000 Prepaid Maintenance Charges 1,500
Prelim. Exps. 500
Shares & Deb. 1,000
Total Rs. 36,000 Total Rs. 36,000

1. Prepaid charges are related to current year.


2. Goods purchases from Hari 20000.
3. Goods sold to Shyam 25000.
4. Insurance charges paid in Advance for 2007-2008 Rs. 3000/-.
5. Interest is due 2006-07 on FDR Rs. 2000/- but not paid by the bank.
6. Salary due but not paid 3000/-.
7. Write off preliminary expenses using P & L A/c 300/-.
8. Cash deposited in Bank 100/-.
9. Interest received in cash 10000/-.
10. Goods returned to Hari 750/-.
11. Goods returned by Shyam 700/-.
12. Salary related to previous year paid in current year 1000/-.
13. Loan given to supplier Yash Enterprises 3000/-.
14. A consumer last year filed a compensation case for 1000/-. Firm lost the
case.

Reports:- Cash Flow,Fund Flow & Ratio Analysis


PROBLEM STATEMENT 18

Create Inventory company for Mani Corporation Ltd on 2023- 2024.

Liabilities AMT. Assets AMT.


Amit’s Capital 1,70,000 Stock: Computers
P & L A/c 20,000 Desktop 1 @ 15,000 ,Vaishali Ngr. 15,000
Overdraft 10,000 Laptop 1 @ 40,000 , Vaishali Ngr. 40,000
Machines:
Drill 3 @ 5000 , Shastri Ngr. 15,000
Lathe 1 @ 10,000,Shastri Ngr. 10,000
Cash in hand 1,20,000
2,00,000 2,00,000

1 Apr 3 Desktop purchased @ 20,000/- Bill No. 23.


1 May 1 Laptop purchased @ 50,000/- Bill No. 25 from Mehta &
Co.. 1 Jun Drill purchased 2 @ 5,500/- Bill No. 27 from Kumar Ltd.
1 Jul 4 Desktops sold @ 20,000/- Bill No. 10. to Jain &
Sons. 1 Aug 2 Laptops sold @ 60,000/- Bill No. 35.
1 Sep Deposited in Bank 1,000/-.
1 Oct Amit withdrew 500/- for personal
use. 1 Nov Lathe sold 1 @ 12,000/- Bill No. 55.
1 Dec Interest credited in Mehta & Co. account
500/-. 1 Dec 1 Desktop returned by Jain & Sons.

Reports: Valuation
Option Range &
Value.
PROBLEM STATEMENT 19

Create accounts with inventory company on Amir & Sons below financial year
2023-2024
Liabilities AMT. Assets AMT.
Ram’s Capital 40,000 Stock
Shyam’s Capital 10,000 Cotton : B12 100 Kg @ 10 1000
Imported 10 Kg @ 100 1000
Thread: Red 10 spindles @ 3000 30,000
Yellow 10 spindles @ 1500 15,000
Cloth: Raw 100 mtrs. @ 30 3000
Total Rs. 50,000 Total Rs. 50,000

1 Apr Cotton B-12 purchased from Sandy 500 kg @


12/-. 1 May Thread sold 5 red spindles @ 4000/- to Garry.
1 Jun Cloth: Raw sold 50 meters. @ 15/-.
1 Jul Cotton: B-12 returned 100 kg. @ 12/- to
Sandy. 1 Aug 2 Red spindles returned by Garry.
1 Sep Ram introduced additional Capital
5000/-. 1 Oct Shyam withdraws 3000 for personal use.
1 Nov B12 10kg given in charity @ 10.
31 Mar Wages paid 1000.

Output :: Tally Audit


:: Split company wef 1st Mar 2024
:: Exception Report
:: Go for Backup & Restore
PROBLEM STATEMENT 20

Create Company of Aptech Ltd on financial year 2023-2024 and given last month balance
sheet below and follow 2024 -2025 transactions.

2024 -2025

Reports:

You might also like