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¶
- 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).
- Raw materials, finished items with BOMs (study table, wardrobe, bookshelf), opening stock.
- Employees (6) with PF, ESI and PT; TDS natures of payment; TCS for scrap sales.
2. Transactions for the quarter¶
- Purchases of raw materials (including an inter-state supplier and an import in USD with customs duty and import IGST).
- Production runs for all three products with labour and power as additional costs.
- Job work: tables sent for polishing and received back with the job worker's invoice.
- Sales: domestic B2B and B2C, one export under LUT in USD, scrap sale with TCS.
- Payroll for three months with attendance, PF/ESI payments by the 15th.
- TDS on contractor, professional fees and rent; deposits by the 7th; quarterly statement data.
- Banking: cheques, e-payments, two post-dated receipts, one dishonoured cheque.
- Forex receipt for the export at a different rate.
3. Close and report¶
- Quarter-end adjustments: depreciation, outstanding expenses, prepaid items, provision for doubtful debts.
- Physical stock verification and adjustments; batch expiry review.
- Bank reconciliation for all accounts.
- GST: monthly GSTR-1/3B for the quarter, GSTR-2B reconciliation, ITC-04 data for job work.
- 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.