0% found this document useful (0 votes)
18 views55 pages

Tally Prime Algorithm FINAL

The document outlines various financial tasks related to the creation and management of a company, including the preparation of profit and loss accounts, balance sheets, and inventory management. It includes detailed calculations for interest, ratio analysis, and stock summaries using different methods like FIFO and LIFO. Additionally, it discusses budgeting, tax deductions, and sales orders, providing a comprehensive overview of financial operations within a business context.

Uploaded by

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

Tally Prime Algorithm FINAL

The document outlines various financial tasks related to the creation and management of a company, including the preparation of profit and loss accounts, balance sheets, and inventory management. It includes detailed calculations for interest, ratio analysis, and stock summaries using different methods like FIFO and LIFO. Additionally, it discusses budgeting, tax deductions, and sales orders, providing a comprehensive overview of financial operations within a business context.

Uploaded by

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

1.

A CREATION OF COMPANY

1.B MULTI – LEDGER DISPLAY


1.C STOCK SUMMARY

1.D MEMO VOUCHER


PAYMENT VOUCHER
1.E PROFIT AND LOSS ACCOUNT

BALANCE SHEET
2 .A. Prepare a Profit &Loss Account of Balance sheet on Emerald & Co Company

Opening capital by Mr Ram₹25,00,000


Bank deposit ₹1,00,000
Stationery ₹2,000
Rent received
₹5,500
Salary₹5,000
Insurance premium ₹850
Commission received ₹1,000
Goods purchase ₹2,000
Goods purchase from Sakthi store ₹34,000
Wages ₹670
Cash withdraw for office purpose
₹12,000 Sales of goods ₹4,000
Sold goods orange agencies ₹38,000
Carriage inward ₹650

PROFIT & LOSS A/C


BALANCE SHEET

1. B. From the following particulars calculate the Interest for the period of 01-04 to 31-3

01-04-Cash deposited in Scotia bank Rs.

1,00,000 01-04- Sold goods to Ganesh Rs.

25,000

31-12-Cash deposited at Scotia bank Rs. 50,000

31-12-Sold goods to Ganesh Rs. 50,000

Interest parameters rate 14% per 365 days year.


INTEREST RECEIVABLE

PROFIT & LOSS A/C


BALANCE SHEET

2.C. From the following particulars calculate the Interest for the period of 01-04 -24 to 31-03-25

01-04 Cash deposited in SBI Rs. 100000

01-04 Purchased goods from suppliers Rs.

20000 01-12 Deposited in SBI Rs. 50000 ,

01-12 Purchased goods from suppliers Rs 40000

Interest parameters rate 16% per 365 days year.


INTEREST PAYABLE

PROFIT & LOSS A/C


BALANCE SHEET

RATIO ANALYSIS
1. D
[Link] & Co, sells goods on cash and credit terms and also purchased goods on cash and credit terms.
The following particulars are obtained from their books.
Rs

Total sales 5,00,000

Cash sales 40,000

Sales returns 20,000

Debtors at the end 80,000

Bills receivable at the end 20,000

Reserve for doubtful debts 1,000

Total purchase 3,00,000

Cash purchase 50,000

Purchase return 10,000

Creditors at the end 60,000

Bills payable at the end 20,000

Reserve for discount on creditors 2,000

Opening stock 50,000

Closing stock 40,000

Gross profit 1, 00,000

Fixed assets 10, 00,000

Calculate Ratio analysis.


3(A). INVENTORY MANAGEMENT

1. Capital -400000 6. Bills payable -20000


2. Royalty payable -70000 7. furniture -50000
3. Cash -120000 8. bills receivable -50000
4. Bank O/D-50000 9. Land& buildings -60000
5. ICICI BANK -80000 10. Loan from Ravi -10000

Stock in hand

1. Sony TV 15 nos Rs-5500


2. Sony I pad 15 nos Rs -500
3. Lenovo Laptop 7 nos Rs -12000
4. Micro max phone 8 nos Rs -2000

Purchase on credit Mr. Citizen

1. LC -10121 Calculator 20 nos Rs -1200


2. USB 17 nos Rs -2300
3. Laptop battery 22 nos Rs -2100

Purchase on credit Mr. micro max

1. Phone display 20 nos Rs -7500

Sold goods on Mr. Benn

1. Lenovo Laptop 4 nos Rs -15000

Return goods Mr. Citizen

1. LC -10121 Calculator 3 nos Rs -1200


2. Laptop battery 20 nos Rs -2100

Sold goods on Mr. Network

1. Laptop battery 15 nos Rs -3000

2. Phone display 12 nos Rs -750

Return by goods Mr. Benn

1. Sony TV 2nos Rs -7500

2. Lenovo Laptop 1nos Rs -15000

The stock LC 10121 Calculator 2 nos transferred to Chennai branch. After stock the manual
inventory the stock of Sony I pad 10 nos only.
DAY BOOK

STOCK SUMMARY
PROFIT & LOSS A/C

BALANCE SHEET
2. (B) Sakthi Ltd furnishes the following Stores Ledger , stores transaction for July 2024,

July 1 Opening balance 200 units at Rs. 10 per


unit July 4 Receipts from Mital Ltd GRN . NO.1 300 units at Rs. 12 per
unit
July 7 Issues Requisition No.48 400 units
July 10 Receipts from Madhav
400 units at Rs.14 per unit
Ltd [Link].2

July 19 Issues Requisition No. 49 300 units


July 22 Receipt from Raghav Ltd [Link].3 200 units at Rs. 16 per
unit
July 28 Issues Requisition No.50 200 units
July 30 Issues Requisition No.51 100 units

Prepare stores ledger under FIFO and LIFO Method.

STOCK SUMMARY
STOCK ITEM MONTHLY SUMMARY

STOCK ITEM MONTHLY SUMMARY FIFO


STOCK ITEM MONTHLY SUMMARY LIFO

PROFIT AND LOSS A/C


BALANCE SHEET

2. (c). Record the following transactions in a stores ledger card by adopting the simple average price method:

Date Purchase Issues

Qty. Rate

01.01.2010 500 2 00 -
10.01.2010 300 2 10 -
15.01.2010 - - - 600
20.01.2010 400 2 20 -
25.01.2010 - - - 300
27.01.2010 500 2 10 -
31.01.2010 - - - 200
STOCK SUMMAR
PROFIT AND LOSS ACCOUNT

BALANCE SHEET
3. (D). Prepare a stores ledger for the month of March 2010 under weighted average method:

Date Particulars Units Value

(Rs)
March 01 Balance 300 600
March 02 Purchased 200 440
March 04 Issued 150 -
March 06 Purchased 200 460
March 11 Issued 150 -
March 19 Issued 200 -
March 22 Purchased 400 960
March 27 Issued 150 -

STOCK SUMMARY
PROFIT AND LOSS ACCOUNT
BALANCE SHEET
3. (E). PRICE LEVEL PRICE LIST

ITEMS WHOLE SRLLER DEALER RESELLER

Chudither Rs Discount(%) Rs Discount(%) Rs

00-51 350 - 380 - 400

51-101 340 2% 365 - 400

101- above 325 5% 340 10% 400

Cotton sarees

00-51 300 - 340 - 370

51-101 285 5% 310 - 370

101-Above 270 8% 290 5% 370

Jeans

00-51 380 - 420 - 450

51-101 360 5% 400 - 450

101-above 345 10% 380 5% 450

Sarees

00-51 360 - 390 - 400

51-101 345 6% 370 - 400

101-above 320 8% 350 8% 400


TRANSACTIONS
Apr 2 goods sold to m/s jayappa readymade (whole seller) for the
following.

 sarees 150 nos.

 Sarees 550 nos.

 Cotton Jeans 400 nos sales tax 10% vide bill no :JR02(25

days) Jun 5 goods sold to mr. nalli readymade (dealer) for the

following

 50 nos, 100 nos, 150 nos.


 Cotton sarees 50 nos, 100 nos, 150 nos.

 Chudithar 50 nos, 100 nos, 150 nos.

 Sarees 50 nos, 100 nos, 150 nos.

DAY BOOK
PRICE LEVEL

PRICE LEVEL (STOCK GROUP)


3 (G). PURCHASE ORDER & SALES ORDER

RKM CREATORS

ADDRESS New no.6 New Jamu Nager ,Rs Puram


Coimbatore 641-002

MOBILE NUMBER 7689007655

WEBSITE Covairkmcreators

EMAIL Covaikmcreations @ [Link]

GSTN NO 33AAALC7527P1DH

PAN NO AAALC7527OP
1-07-23. Raised on order on brandmard pvt ltd purchasing keyboards and incurred additional
packaging and transport charges of 2% due on 6-7-2024purchase order no po-001

Stock Qty Rate

Keyboard 200Nos 620

29-07-23 order received from Lakshmi Computers for Keyboard (vide Order No SSD-001).
The due daten for delivering the goods is 4-08-23 and delivery charges of 1% apply.

Stock Qty Rate

Keyboard 150Nos 750

6-07-23 Record a receipt note on BrandMonk Pvt ltd. This receipt note will be linked to the
Purchase order no PO_001. That was recorded 0n 1-07-23. Receipt notes no: RN- 01.

Stock Qty Rate

Keyboard 200Nos 620

4-08-23 Goods were delivered to Lakshmi Computers against the order No: SSD_001.

Stock Qty Rate

Key board 2nos 750

10-07 2023 raise a purchase invoice on barandmank pvt ltd for following stock items the purchase invoice
will be linked to the receipt note RN-01 that was recorded on [Link] invoice no PUR01.

Stock0 Qty Rate

Keyboard 195 620


18-8-23 lakshumi computers rejected keyboards ,resons inferior qnality.

Stock Qty Rate

Keyboard 2 nos 750

15-07-23 RKM creators returned damaged keyboards to barandmank pvt ltd.

Stock Qty Rate

Keyboard 5 nos 620

PURCHASE ORDER
RECEIPT NOTE

REJECTIONS OUT
PURCHASE

SALES ORDER
DELIVERY NOTE

SALES
3 (H). COST CENTRE

Particulars Rs Rs

SBI Bank 800000

Cash in hand 100000

Furniture 200000

Building advance 150000

Computer 500000

Stock in hand 150000

Software deposit 100000

CCI capital 1000000

O/S building rent 20000

O/S salary 80000

Loan from bank 70000

Sundry creditors
m/s Hindustan computer ltd Rs
1500000 bill no. 2112 (25 days)
M/S Pavai books &note
printers Rs 50000 bill no. 2209 (25
days)

COST CATEGORIES AND COST CENTRE APPLICATIN FEES


Computer application Entrance
application
COURSE FEE
DCA;
Course fees (DCA) Course
material (DCA) DCA forenoon
DCA afternoon
DCA w/k
TALLY;
Course fees(tally) Course
material(tally) Tally
forenoon Tally afternoon
Tally
day time
DTP;
Course fees (DTP) Course
material(DTP) DTP
forenoon DTP afternoon
DTP day time.

DIT

Course fees (DIT) Course


material (DIT) DIT forenoon
DIT afternoon DIT
Day time

TRANSACTION

1. Course fee received for tally (f/n) Rs 22000and tally (a/n) Rs 14000
2. Course fee received for tally (a/n) Rs 30000 and computer application for Rs 5000 by
cheque.
3. Course fee received for tally (day time) Rs 120000 DCA (w/k)Rs 75000 DTP (day time)
Rs 90000 DIT (day time) Rs 110000and summar offer for discount 2% for each course,.
4. Course fee received for DIT (f/n) Rs 15000 and DIT (day time) Rs 13000.
5. Enterance application received Rs 10000
6. Course fee received for DTP,(a/n) Rs 36000 and DTP (f/n) Rs 14500
7. Course fee for tally (a/n) refund Rs 5000
8. Course material to tally DIT and DTP purchased 50 copies @Rs
5000,Rs 3000,Rs1000 each.
9. Amount paid to Ms. Hindustan ltd for Rs.75000 part settlement .
10. Course fee for DIT (f/n) refund Rs 15000 and DCA (a/n) Rs.5000
11. Depreciation of furniture and fittings @10%
12. Computer stolen@ Rs.10000
13. Interest received from bank balance Rs.5000
DAY BOOK

COST CENTRE
COST CATEGORY

COST CENTRE
COST CATEGOR

4.(A) BUDGET–Financial Budget

Stationary-10000
Rent- 50000
Salary-20000
Wages- 15000
Freightcharges-5000
Discount – 5000
Commission-10000
Depreciation-10000

Transaction:
 Paid telephone charges 2000

 Good purchase on credit R/s Raj &co100000

 Salary by cheque 10000

 Rent 20000 ; stationary 4000 ; wages6000

 Fright charges 3750 by cheque

 Paid to M/s Raj & co with discount received @ 5%

 Salary 10000; Rent30000

 Interest received25000

 Discount allowed30000

 Insurance premium30000
BUDGET REPORT

(B) TAXDEDUCTED AT SOURCE

X Y company limited land and building & furniture cost at 240000, pay rent of
building Rs 300000, taxable rent 7.5 %. Taxable amount to bank in the nature of
payment. Calculate tax deducted at sources.
TAX DEDUCTED AT SOURCE REPORT

DAY BOOK
BALANCE SHEET

3. (D) TAX COLLECTED AT SOURCES

Every sellers whose total sales, gross recipts or turnover from the business carried on by
him exceed Rs 10 corers during the fy 2019-20 & onwords, and if sales to buyer is
exceeding Rs 50 lakes during the FY 2020-21 & onwords then seller has a to collect TCS
tax for such buyers on the value exceeding the thershold limit.
NAME SALE OF ANY GOODS

Section code 206c


Payment code Yes to provided by the department
Note: As the payment code is not yet
notified the department this field will
be left blak and the same will not
be printed on ITNS chalan 281.
Rate of tax No PAN/Aadhaar 1%
with PAN/Aadhaar Note: as per finance bill 2020, the TCS
0.075% rate for this category with PAN is 0.1%
and No PAN wll be1% due to
COVID19
outbreak,
department has reduced to 0.075% and
No PAN remans
as 1%
Threshold limit Rs.50,00,000

Effective from 01-10-2020

TAX COLLECTED AT SOURCE REPORT


TCS OUTSTANDING
ACCOUNTING VOUCHER
4. (E) Journalise the following transaction 01.01.2024, prepare cash flowstatements
01.07.2024 Purchased Goods for Cash 10,000
02.07.2024 Purchased Stationary for Cash 500

03.07.2024 Purchased Furniture for Cash 3,000

04.07.2024 Sold Goods for Cash 8,000

05.07.2024 Sold Goods to John for Cash 3,000

06.07.2024 Sold Goods to James 2,000

07.07.2024 Paid Rent to Krishna the Landlord 800

08.07.2024Paid Salary of 8,000

09.07.2024 Paid Logesh the Manager his Salary of 3,000

10.07.2024 Paid Fright on Goods Purchased 300

11.07.2024 Paid Fright on Machine Purchased 400

12.07.2024 Paid Wages 500

13.07.2024 Paid Wages to Erect Machine 1,000

14.07.2024 Received Rs.800 from Kamal 15.07.2024 Received

Rs.600 from Kamal as Interest.

16.07.2024 Received Rs.7, 000 from Kamal as want 5% Interest.


CASH FLOW STATEMENT

PROFIT AND LOSS ACCOUNT


BALANCE SHEET

4.(F) From the following particulars calculate the Fund flow statement:

SOURCES OF FUNDS

Issue of share 1000000

Issue of debenture 200000

Sale of fixed asset 100000

Invest sold 80000

Funds from operation 150000

APPLICATION OF FUNDS

Repayment of long- term loans 175000

Redemption of preference shares 80000


Purchase of fixed asset 250000

Tax paid 70000

Dividend Paid 60000

Investment Purchase 65000

Outflow of funds on 25000


account operation

FUND FLOW STATEMENT


PROFIT AND LOSS ACCOUNT

BALANCE SHEET
5. (A) CALCULATE THE GST
REPORTS: CGST, SGST,

Items HSN Qty Rate Amount GST Total

Cabinet 84732900 100 650 65000 18% 76700

Mouse 84733010 100 175 17500 18% 20650

Keyboard 84733010 100 200 20000 18% 23600

RAM 84733030 100 750 75000 18% 88500

HDD 84733030 100 3500 350000 18% 413000

DVD 84733030 100 800 80000 18% 94400



ROM

Monitors 85283020 50 4000 200000 18% 236000

TOTA 807500 952850


L
3
5. (B) CALUCULATE THE IGST TAX RATE:

DESCRIPTION HSN CODE GSTRATE QTY RATE

SOLAR TUBE LIGHT 94055040 5% 100 350

SOLAR TORCH LIGHT 15043000 12% 100 200

USB CABLE 85716060 18% 100 150

WASHING MACHINE 84501100 28% 50 1500

TOTAL 820000
7
BALANCE SHEET

You might also like