Hackathon Problem Statement Tally With GST
Hackathon Problem Statement Tally With GST
Create a company:
Create a company:
Create a company:
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
Create AXL & Sons Company with book Beginning 2023 and
Maintain current Financial Year accounts 2024 - 2025
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.
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
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
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
Sales
PROBLEM STATEMENT 11
Create ABC Company on Financial year 2023-24 and make all type of transaction
on 31 March 2023.
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
Generate Report:
Stock Summary Report
Purchase Register
Sales Register
Debit Note Register
Credit Note Register
Payable & Receivable report
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.
Rent, Rates and Taxes 12,500 Loan from Dena bank @ 12% 5,50000
Discount 1,400
Commission 1,500
Buildings 1,80,000
Machinery 1,20,000
Furniture 75,000
8,51,250 8,51,250
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
5 Stars
Kitkat Chocolate
Munch
Dairy
milk
Moov
D’Clod
Lee T-Shirts
Nike
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
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
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: