Skip to content
Tutorials Center
My learning

Topics

Lesson 37 of 38 ยท Projects and Practice

Project: Manufacturing Accounts and Month-End Close in Tally Prime

A manufacturing project in Tally Prime: bill of materials, production, costing, selling with GST, TDS on contract work, and a month-end close checklist with stand-ins.

A trading company only buys and sells. A manufacturer adds a middle step: it turns raw materials into finished goods, which means bills of material, production vouchers, costing and often TDS on contractors. In this project you run Sunrise Foods, a fictional maker of gift hampers, for a month and close the books.

Tally Prime cannot run on this site. Do the steps in a practice company in your own installation and use the Python stand-ins to check the numbers. Names, rates and amounts are invented.

Setup

  1. Enable inventory, GST, BOM (component list) and TDS in F11 (batches and BOM, TDS).
  2. Stock items: raw materials Gift Box, Jam Jar, Tea Sachet; finished item Gift Hamper (unit Nos) with BOM: 1 box, 2 jars, 3 sachets.
  3. Ledgers: sales, purchases, GST duty ledgers, Labour Charges (with TDS for contractor), Power, TDS Payable - Contractor, bank, and parties.
  4. Valuation: average cost for all items (valuation methods).

The month

Day Event
1 Buy 200 boxes at 25, 400 jars at 60, 600 sachets at 8 (+ 18% GST)
5 Produce 100 hampers with a stock journal, adding labour 1,000 and power 300 as additional costs
12 Produce 60 more hampers (same BOM, same additional cost per unit)
15 Sell 120 hampers at 300 to a retailer in the same state (+ 18% GST)
18 Pay the labour contractor 20,000 with TDS deducted at 2% (illustration)
30 Count stock and close the month

Costing production

Cost per hamper = material (169) + additional costs. For the first run: material 100 x 169 = 16,900; additional costs 1,300; so 18,200 for 100 hampers, 182 each. For the second run, if labour and power are 10 + 3 per hamper, cost is 169 + 13 = 182 again.

Python Stand-in: production cost for both runs

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

The output shows 18200 (182.0 per unit) and 10920 (182.0 per unit), with 40 boxes, 80 jars and 120 sachets left.

Selling and GST

Selling 120 hampers at 300 gives 36,000 taxable value, 18% GST of 6,480 (CGST 3,240 + SGST 3,240) and an invoice total of 42,480. With 160 hampers produced and 120 sold, 40 remain in stock at 182 each: 7,280.

Python Stand-in: margin on the sale

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

TDS on the contractor

The 20,000 labour bill with 2% TDS (illustration; take the real section and rate from the current law) leaves a TDS of 400, so you pay the contractor 19,600 and owe 400 to the government. Book it with the TDS journal and deposit it with a payment voucher (TDS lesson). Note that if you booked the labour as an additional production cost, it is not also an expense in the P&L: pick one treatment.

Month-end close checklist

Close the month

Stock Count and fix negatives
Production All vouchers in
GST Returns tie to books
Bank Reconciled

Then statements and backup.

1 / 2
  1. All purchases, productions, sales, payments and receipts entered with correct dates.
  2. Physical count agrees with the stock summary; adjust differences with a stock journal and explain them.
  3. GST: uncertain transactions cleared; GSTR-1 and GSTR-3B data match registers.
  4. TDS: deductions deposited by the due date.
  5. Bank reconciliation done.
  6. Trial balance, P&L, balance sheet reviewed; ratio analysis looked at.
  7. Backup taken; audit trail reviewed.

Common mistakes

  1. Producing more than raw material in stock, so negative component stock distorts cost.
  2. Counting labour twice (as production cost and expense).
  3. Selling finished goods before recording production, so costs are wrong until it is entered.
  4. Forgetting that closing stock must include finished goods and work in progress.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. Raw material per hamper costs 169 and additional costs are 13. What is the unit cost?

    169 + 13 = 182.
  2. 2. Sale of 120 hampers at 300 with 18% GST. What is the invoice total?

    36,000 + 6,480 GST = 42,480.
  3. 3. A 20,000 contractor bill with 2% TDS. How much do you pay the contractor?

    Deduct 400 and pay 19,600; the 400 goes to the government.
  4. 4. Which is a valid month-end step?

    A count verifies stock quantity and value before profit is trusted.

Summary

  • Manufacturing adds BOM, production vouchers and costing to trading accounts.
  • Unit cost = material + additional costs; use consistent allocation.
  • GST applies to the sale; TDS applies to contractor payments, where relevant.
  • Close each month with stock, GST, TDS, bank and statement checks, then back up.

Next: Practice set with solutions