Skip to content

10 · Project — Quarter-End Close for a Manufacturer

Combine Level 3 in a quarter-end close for Deccan Furniture Works (Hyderabad, Telangana) — manufacturing, payroll, TDS/TCS, inventory, banking, exports and adjustments — and produce management-ready reports.

1. Setup

  1. Company with GST, TDS, TCS, payroll, multi-currency, godowns (Raw Materials Store, Factory Floor, Finished Goods, Showroom), batches for laminates, cost centres (Production, Sales, Admin).
  2. Raw materials, finished items with BOMs (study table, wardrobe, bookshelf), opening stock.
  3. Employees (6) with PF, ESI and PT; TDS natures of payment; TCS for scrap sales.

2. Transactions for the quarter

  1. Purchases of raw materials (including an inter-state supplier and an import in USD with customs duty and import IGST).
  2. Production runs for all three products with labour and power as additional costs.
  3. Job work: tables sent for polishing and received back with the job worker's invoice.
  4. Sales: domestic B2B and B2C, one export under LUT in USD, scrap sale with TCS.
  5. Payroll for three months with attendance, PF/ESI payments by the 15th.
  6. TDS on contractor, professional fees and rent; deposits by the 7th; quarterly statement data.
  7. Banking: cheques, e-payments, two post-dated receipts, one dishonoured cheque.
  8. Forex receipt for the export at a different rate.

3. Close and report

  1. Quarter-end adjustments: depreciation, outstanding expenses, prepaid items, provision for doubtful debts.
  2. Physical stock verification and adjustments; batch expiry review.
  3. Bank reconciliation for all accounts.
  4. GST: monthly GSTR-1/3B for the quarter, GSTR-2B reconciliation, ITC-04 data for job work.
  5. Reports: Trial Balance, P&L (with gross margin), Balance Sheet, Stock Summary by godown, Cost Centre break-up, payroll summary, TDS/TCS summary, forex gain/loss.

Deliverable checklist

Item Done?
Manufacturing with BOM and additional costs
Job work cycle
Payroll 3 months + statutory payments
TDS/TCS entries, deposits, return data
Export, import, forex
Adjustments + stock verification
GST returns + reconciliations
Management report pack

How It Actually Works

A quarter-end close tests whether all modules agree with each other: production consumption with stock counts, payroll costs with statutory dues, sales with GST returns and receivables, bank entries with statements. Accountants close in a fixed order — record, reconcile, adjust, review, report — because each step depends on the accuracy of the one before. Delivering this pack is close to what a finance team does every quarter in a real manufacturing company.

Exercise

Complete the close and write a two-page management report: revenue by channel (domestic, export), gross margin by product, payroll cost as a percentage of revenue, cash position and upcoming post-dated receipts, statutory payments made and due, and three operational recommendations.