Manufacturing, Job Work and Advanced Inventory

Introduction and Context

Manufacturing accounting connects commercial transactions with the physical transformation of materials into finished goods. In Tally.ERP 9, this connection is created through stock items, units of measure, godowns, batches, bills of materials (BOMs), manufacturing journals, stock journals, purchase and sales documents, and job-work transactions. The objective is not merely to record quantities. It is to establish an auditable relationship between input consumption, output production, inventory valuation, production losses, outsourced processing, and managerial decisions.

Advanced inventory management is particularly important where materials have expiry dates, multiple storage locations, variable procurement lead times, subcontracting arrangements, or significant freight and handling costs. A technically correct configuration improves cost visibility and reduces the risk of stock-outs, overstocking, unrecorded wastage, and misstatement of inventory.

Tally.ERP 9 is a transaction-processing and accounting system rather than a complete production-planning suite. Consequently, users must distinguish between what the software records automatically and what must be designed through procedures, master data, controls, and external planning analysis.

Learning Objectives

After completing this chapter, the learner should be able to:

1. Explain the role of BOMs in manufacturing accounting.
2. Configure and use manufacturing journals and stock journals.
3. Record stock transfers and distinguish them from accounting purchases and sales.
4. Analyse additional costs and their effect on inventory valuation.
5. Account for materials sent to and received from job workers.
6. Apply batch, expiry, godown, and stock-category controls.
7. Calculate reorder levels, safety stock, and economic order quantity where appropriate.
8. Evaluate the control, costing, and governance implications of advanced inventory processes.

1. Manufacturing Information Architecture in Tally.ERP 9

A manufacturing implementation generally contains five linked layers:

A stock item should be created only when quantity tracking is required. Non-stock expenses such as electricity or factory supervision may be recorded through ledgers and allocated analytically, but they are not automatically transformed into stock consumption merely because they relate to production.

Important master-data decisions

The following decisions should be made before transactions are entered:

• whether inventory is maintained in integrated mode;
• whether separate godowns are required;
• whether batches and expiry dates must be tracked;
• whether the item requires a BOM;
• whether the item has a compound or alternate unit;
• whether negative stock should be permitted;
• whether different valuation methods are required for different categories;
• whether job-work locations must be treated as separate godowns or tracked through dedicated documents.

Poor master data creates systematic errors. For example, recording kilograms as pieces prevents meaningful consumption analysis, while combining saleable and rejected material in one stock item conceals quality losses.

2. Bills of Materials

A bill of materials is a structured specification of the components required to manufacture one defined quantity of a finished or semi-finished item. It is both a production reference and a cost-analysis tool. A BOM may include raw materials, packaging, subassemblies, consumables, co-products, and expected scrap assumptions.

A simple BOM can be represented as:

where:

• Q_i = required quantity of component i;
• q_i = component quantity specified in the BOM;
• Q_f = planned finished quantity;
• B = BOM base quantity.

The relationship applies when consumption is proportional to output and no fixed setup quantity is involved. If a component has a fixed setup requirement, the more general expression is:

where F_i is fixed consumption and v_i is variable consumption per unit of finished output. Tally.ERP 9 BOM structures commonly express standard component quantities; fixed setup consumption may therefore require a separate production procedure or adjustment.

BOM example

A company manufactures 100 bottles of a chemical product. The BOM requires 25 kg of chemical A, 10 kg of chemical B, and 100 bottles. For a production order of 250 bottles:

• chemical A = 25 × 250 ÷ 100 = 62.5 kg;
• chemical B = 10 × 250 ÷ 100 = 25 kg;
• bottles = 100 × 250 ÷ 100 = 250.

These are standard requirements. Actual consumption may differ because of evaporation, process loss, rework, or substitution. Such differences should be separately authorised and analysed rather than silently incorporated into the standard BOM.

BOM configuration principles

In Tally.ERP 9, a BOM is generally associated with a stock item and can be selected in manufacturing-related transactions where the relevant feature is enabled. A practical configuration sequence is:

1. Create units of measure.
2. Create component and finished-good stock items.
3. Enable inventory features relevant to manufacturing.
4. Define the BOM for the finished item.
5. Specify component quantities and units.
6. Define godowns and batches where necessary.
7. Test a small manufacturing transaction before live use.

BOMs should be version-controlled. A change in formulation, packaging, or process yield should have an effective date and authorisation. Overwriting an old BOM without retaining its historical version weakens cost variance analysis.

3. Manufacturing Journals and Production Recording

A manufacturing journal records the conversion of components into finished goods. Its conceptual structure is:

Inputs: raw materials and components consumed.

Outputs: finished goods, co-products, by-products, and, where configured, scrap or wastage.

The accounting meaning is not that cash has been paid. Rather, the transaction transfers value within inventory and records the production event. The monetary effect depends on the valuation basis assigned to the items and on the treatment of production expenses.

Standard production flow

1. Verify that sufficient components are available.
2. Confirm the production quantity and relevant BOM.
3. Select the production or manufacturing journal.
4. Enter the finished item and output quantity.
5. Allow the BOM to populate standard components, where available.
6. Review actual quantities against the standard.
7. Record additional components, co-products, and authorised wastage.
8. Select godowns and batches correctly.
9. Save and review the resulting stock impact.

The user should not assume that every manufacturing journal automatically includes labour, power, depreciation, or factory overhead. These costs may require separate accounting entries, cost-centre allocations, or a costing system outside the basic stock transaction.

Production yield and loss

Yield is the relationship between acceptable output and input. A simple yield percentage is:

This formula applies when input and output are measured in comparable units or when a conversion basis is explicitly defined. If several inputs and outputs exist, physical yield should not be interpreted as a complete cost-efficiency measure. Monetary yield and conversion-cost variance may provide better managerial information.

Expected process loss should be documented. Unauthorised excess consumption may indicate incorrect BOMs, poor process control, theft, measurement error, or quality problems. A separate scrap item or rejection godown can improve visibility.

4. Stock Journals and Internal Transfers

A stock journal records movement of inventory without necessarily representing an external purchase or sale. Common uses include:

• transfer between godowns;
• movement from stores to production;
• movement from production to finished-goods storage;
• reclassification of stock;
• physical stock adjustments;
• recording of shortages, excesses, or wastage;
• recording additional cost details where the configuration and transaction type support them.

A transfer between two godowns changes location but does not, by itself, create revenue, purchases, or profit. The quantity and value remain within the business, although the transaction may affect location-based reporting.

Stock-transfer control

Every transfer should identify:

• sending location;
• receiving location;
• item and quantity;
• batch, if applicable;
• date and responsible employee;
• transport or movement reference;
• confirmation of receipt.

A transfer should not be used to conceal a sale, write off a shortage, or alter valuation without an approved adjustment reason. Separate voucher numbering or narration can help distinguish routine transfers from correction entries.

5. Additional Costs and Inventory Valuation

Additional costs include freight, insurance, customs duty, loading, unloading, handling, and other costs directly attributable to bringing inventory to its present location and condition. Their treatment must be consistent with the applicable accounting framework and the entity’s documented policy.

A basic landed-cost model is:

The formula assumes that all included costs relate to the same receipt and that the allocation basis is appropriate. Where different items have different weights, values, or volumes, equal allocation may be misleading.

For an allocation based on invoice value:

For an allocation based on weight:

The selected basis should reflect the cause of the cost. Freight may be allocated by weight or volume; insurance may be allocated by value; customs duty may follow the legally assessed basis.

Worked example: landed cost

A consignment contains 1,000 units of item P invoiced at ₹80,000 and 500 units of item Q invoiced at ₹60,000. Freight of ₹14,000 is allocated by invoice value.

Total invoice value = ₹140,000.

Allocation to P = ₹14,000 × 80,000 ÷ 140,000 = ₹8,000.

Allocation to Q = ₹14,000 × 60,000 ÷ 140,000 = ₹6,000.

Landed cost per unit:

• P = (₹80,000 + ₹8,000) ÷ 1,000 = ₹88;
• Q = (₹60,000 + ₹6,000) ÷ 500 = ₹132.

The accounting team should verify whether tax components are recoverable. Recoverable input tax is normally not treated as inventory cost, whereas non-recoverable taxes may form part of cost, subject to the applicable framework.

In Tally.ERP 9, additional cost details may be entered through supported purchase or inventory transactions after enabling the relevant feature. The exact availability depends on the release, voucher configuration, and company settings. Users should verify the resulting stock valuation report rather than relying only on the voucher screen.

6. Job Work and Subcontracting

Job work is processing performed by one party on behalf of another. The principal may provide materials, while the job worker contributes labour, capacity, expertise, or additional materials. Ownership of the principal’s materials may remain with the principal throughout the process.

Job work must be distinguished from an ordinary purchase. In an ordinary purchase, ownership of goods generally transfers to the buyer. In job work, the principal may send materials for processing without selling them to the job worker.

Job-work lifecycle

1. Receive or create the job-work order.
2. Dispatch materials to the job worker.
3. Track goods held outside the principal’s premises.
4. Receive processed goods.
5. Record consumption, wastage, shortages, and returns.
6. Record the job-work service charge.
7. Reconcile quantities and value.
8. Close the order only after all materials and charges are accounted for.

A separate godown such as “Material with Job Worker” can provide strong physical visibility. However, the godown should not be interpreted automatically as a transfer of ownership. Documentation and legal treatment remain essential.

Quantity reconciliation

A job-work reconciliation may be expressed as:

For a properly controlled job order, unexplained variance should be zero or investigated. The identity is a quantity-control relationship, not a valuation rule. Units must be comparable, and conversion factors must be documented.

Job-work example

A principal sends 1,000 kg of material to a processor. The contract permits 20 kg of process loss. The processor returns 960 kg of finished product and 18 kg of recoverable scrap. The quantity accounted for is:

960 + 18 + 20 = 998 kg.

There is an unexplained variance of 1,000 − 998 = 2 kg. The 2 kg should not be automatically treated as approved wastage. It requires investigation, adjustment authority, and appropriate accounting treatment.

The processor’s service charge should be recorded separately from the material movement unless the entity’s costing policy deliberately incorporates it into the finished-goods cost. A purchase invoice for job-work service may therefore be matched with the relevant job-work order and output receipt.

7. Batch and Expiry Tracking

Batch tracking is necessary where stock identity depends on production lot, supplier lot, quality status, or expiry date. Typical industries include pharmaceuticals, food, chemicals, cosmetics, and medical supplies.

A batch record may contain:

• batch number;
• manufacturing date;
• expiry date;
• supplier or production reference;
• quantity received or produced;
• quality status;
• godown location;
• related documents.

The system should be configured so that batch-enabled items require batch selection during relevant receipts, issues, transfers, and sales. If batch selection is optional when it should be mandatory, traceability becomes unreliable.

Expiry and FEFO

First-expiry-first-out (FEFO) issues stock with the earliest expiry date first. It is different from FIFO, which issues the earliest receipt first. FEFO is a physical-dispatch policy; valuation may still follow the accounting method permitted by the entity’s accounting framework.

An expiry-control report should identify:

• expired stock;
• stock expiring within a defined horizon;
• quantity by batch and location;
• blocked or quarantined stock;
• responsible action owner.

Expiry dates are not substitutes for quality release controls. A batch may be within date but still be quarantined because of failed testing or damaged packaging.

8. Reorder Levels and Inventory Planning

Reorder decisions balance service availability against holding cost. The simplest reorder point is:

where:

• ROP = reorder point in units;
• d̄ = average demand per period;
• L = replenishment lead time in the same period;
• SS = safety stock in units.

This formula assumes reasonably stable demand and lead time. If both are variable and independent, a commonly used approximation for safety stock is:

where z is the service-factor value, σ_d is the standard deviation of demand per period, and σ_L is the standard deviation of lead time in periods. The formula assumes that demand and lead-time variation are adequately represented by the measured statistics and that their covariance is negligible. If demand and lead time are correlated, the covariance term should be considered.

For fixed lead time, the expression simplifies to:

These formulas support planning; they are not native substitutes for managerial judgement in Tally.ERP 9. Reorder levels can be maintained in stock-item masters or supporting reports, while the actual purchase decision must consider supplier minimum order quantities, budget, shelf life, seasonality, and production schedules.

Economic order quantity

Where annual demand, ordering cost, and holding cost are reasonably stable, the classical EOQ is:

where D is annual demand in units, S is ordering cost per order, and H is annual holding cost per unit. The units are consistent because the numerator has units of units × currency/order × orders/year and the denominator has currency/unit/year, producing units² under the square root.

The model assumes constant demand, constant lead time, instantaneous replenishment, no quantity discounts, and no stock-outs. These assumptions often fail in manufacturing environments; EOQ should therefore be used as a benchmark rather than an unquestionable answer.

9. Integrated Applied Case: Apex Nutraceuticals

The following is an illustrative case.

Background

Apex Nutraceuticals manufactures a powdered supplement in 500-gram containers. It purchases active ingredient, excipients, and packaging material. A specialist processor performs blending and returns bulk powder. The company has experienced stock-outs of active ingredient, unexplained job-work shortages, and expired packaging.

Problem

The existing system records purchases and sales but does not adequately distinguish raw materials, material with the processor, released batches, and expired stock. Freight is posted entirely to a general expense account, and reorder decisions are based on informal judgement.

Analysis

The implementation team identifies four control failures:

1. The BOM is not maintained, so standard consumption cannot be compared with actual consumption.
2. Materials sent to the processor are not tracked in a separate godown.
3. Batch and expiry data are entered inconsistently.
4. No formal reorder point is calculated for the active ingredient.

Approach and solution

The team creates separate stock items for active ingredient, excipient, bottles, labels, bulk blend, and finished product. A BOM is prepared for 1,000 finished containers. A “Material with Processor” godown is created. Job-work dispatches are recorded as movements to that godown, and returns are recorded against the same job order.

Each active-ingredient receipt requires a supplier batch and expiry date. Finished production receives an internal batch number linked to the production date and input batches. The warehouse adopts FEFO for dispatch, while quality control maintains a separate released/quarantine status procedure.

Monthly demand for active ingredient averages 2,000 kg. Lead time is 3 months, with a measured demand standard deviation of 250 kg per month. Management selects a service factor of z = 1.65. With lead time treated as fixed:

SS = 1.65 × 250 × √3 ≈ 714 kg.

The reorder point is:

ROP = 2,000 × 3 + 714 = 6,714 kg.

The figure is rounded according to the company’s purchasing unit and policy. It is not a command to purchase 6,714 kg; it is the inventory position at which replenishment review should begin.

Outcome

After implementation, the company can report material at each location, compare actual consumption with the BOM, identify processor variances, and isolate near-expiry stock. Freight is allocated using a documented basis, improving product-cost analysis. The purchase department uses reorder alerts together with supplier minimum quantities and shelf-life checks.

Learning points

The case demonstrates that software configuration alone does not create control. Reliable results require item coding, documented ownership, batch discipline, physical verification, approval rules, and periodic reconciliation.

10. Controls, Governance and Professional Responsibilities

Advanced inventory affects financial reporting, tax documentation, production efficiency, and customer safety. Important controls include:

• segregation of master-data creation, purchasing, receipt, production, and approval;
• restricted rights for altering BOMs and valuation settings;
• sequential and reviewable voucher numbering;
• periodic physical counts and batch reconciliation;
• investigation of negative stock and unexplained variances;
• approval of stock adjustments and write-offs;
• retention of job-work delivery and receipt evidence;
• documented treatment of recoverable and non-recoverable taxes;
• backup, access control, and audit-trail review.

Inventory should not be manipulated to improve reported profit. Delaying a write-off, overstating production, suppressing a shortage, or assigning costs to an inappropriate item undermines financial integrity. In regulated industries, inaccurate batch records may also create direct risks to consumers.

Tally.ERP 9 access rights should follow least privilege. Users should receive only the permissions necessary for their roles. Periodic review is required when employees change departments or leave the organisation.

11. Limitations and Contemporary Practice

Tally.ERP 9 can support substantial inventory control, but limitations may arise in advanced finite-capacity planning, shop-floor data capture, barcode integration, statistical forecasting, maintenance of complex multi-level routings, and real-time supplier collaboration. Organisations with high-volume or highly regulated operations may integrate ERP data with manufacturing execution systems, warehouse-management systems, barcode scanners, or specialised planning tools.

AI and analytics can assist with demand forecasting, anomaly detection, expiry-risk prioritisation, and supplier lead-time prediction. However, forecasts must be explainable and reviewed. A model trained on inaccurate stock balances may generate confident but harmful recommendations. Human approval remains necessary for unusual purchases, batch release, stock write-offs, and changes to production standards.

Best-Practice Implementation Sequence

1. Map the physical and legal flow of materials.
2. Cleanse item, unit, batch, and godown masters.
3. Define BOM versions and approval responsibility.
4. Configure manufacturing and stock journals.
5. Establish job-work dispatch and reconciliation procedures.
6. Define landed-cost allocation policies.
7. Configure batch and expiry controls.
8. Calculate provisional reorder levels using reliable data.
9. Test normal, exceptional, and correction transactions.
10. Reconcile reports to physical stock and accounting records.
11. Train users by role.
12. Review controls and planning parameters periodically.

Chapter Summary

Manufacturing and advanced inventory accounting requires a coordinated relationship among BOMs, stock items, units, godowns, batches, manufacturing journals, stock journals, job-work records, and cost policies. A BOM establishes standard component requirements; a manufacturing journal records conversion into finished goods; and a stock journal records internal movement or adjustment. Additional costs should be allocated using a rational and documented basis. Job work requires separate tracking of materials owned by the principal, quantities consumed, returns, wastage, and service charges. Batch and expiry controls support traceability and FEFO dispatch. Reorder points, safety stock, and EOQ provide analytical support for inventory planning, but their assumptions must be tested against actual demand, lead time, shelf life, and supplier constraints. Effective implementation depends equally on software configuration, physical discipline, authorisation, reconciliation, and ethical governance.

Key Terms

BOM: A structured specification of components required to produce a defined quantity of an item.

Batch: A distinct quantity of stock identified by a production or supplier lot number.

Bill of materials version: An authorised formulation or component specification applicable during a defined period.

Co-product: An additional output produced together with the principal finished product.

Economic order quantity: The theoretical order size that balances ordering and holding costs under stated assumptions.

Expiry date: The date after which a batch may no longer be suitable for use or sale under the relevant policy.

FEFO: First-expiry-first-out, a dispatch method that prioritises the earliest-expiring stock.

Godown: A warehouse, store, production location, or other inventory location maintained in the system.

Job work: Processing performed by an external party on behalf of the principal.

Landed cost: Acquisition cost plus allocable costs required to bring inventory to its present location and condition.

Manufacturing journal: A transaction recording consumption of components and production of finished goods.

Reorder point: The inventory position at which replenishment review or ordering is initiated.

Safety stock: Inventory held to protect against uncertainty in demand or replenishment time.

Scrap: Residual or rejected material arising from production or processing.

Stock journal: A transaction used for internal stock movement, reclassification, or adjustment.

Stock transfer: Movement of inventory between locations without an external sale or purchase.

Traceability: The ability to follow an item or batch through receipt, processing, storage, and dispatch.

Yield: The proportion of input converted into acceptable output under a defined measurement basis.

Review Questions

Short Answer Questions

1. What is the purpose of a bill of materials?
2. Distinguish a manufacturing journal from a stock journal.
3. Why should materials with a job worker be tracked separately?
4. What is the difference between FIFO and FEFO?
5. Name two costs that may form part of landed cost.

Long Answer Questions

1. Explain the complete manufacturing transaction cycle in Tally.ERP 9, including master data, BOM selection, input consumption, output recording, and review controls.
2. Discuss the accounting and operational treatment of job work, including dispatch, processing, receipt, wastage, service charges, and reconciliation.
3. Explain batch and expiry management and evaluate its importance in regulated or perishable-product industries.
4. Derive and interpret the reorder-point and safety-stock formulas, stating their assumptions and limitations.
5. Analyse the governance risks associated with stock adjustments, BOM changes, negative stock, and unauthorised valuation changes.

Analytical / Application Questions

1. A factory plans to produce 2,400 units. A BOM based on 600 units requires 90 kg of material X and 300 bottles. Calculate the standard requirements and explain two reasons why actual consumption may differ.
2. A company sends 4,000 kg to a job worker. The worker returns 3,850 kg of finished output and 100 kg of recoverable scrap. Determine the unexplained variance and recommend control actions.
3. Monthly demand is 1,500 units, lead time is 2 months, and safety stock is 400 units. Calculate the reorder point and evaluate whether the result should be adopted without considering shelf life and supplier minimum-order restrictions.

Multiple Choice Questions with Answers

Question 1

Which transaction most appropriately records the conversion of raw materials into finished goods?

A. Manufacturing journal

B. Sales invoice

C. Receipt note only

D. Payment voucher

Correct Answer: A. Manufacturing journal

Question 2

A BOM based on 100 units requires 25 kg of material. How much is required for 250 units under proportional consumption?

A. 50 kg

B. 62.5 kg

C. 75 kg

D. 125 kg

Correct Answer: B. 62.5 kg

Question 3

What is the primary effect of transferring stock between two internal godowns?

A. It creates sales revenue

B. It creates a purchase liability

C. It changes the recorded inventory location

D. It automatically writes off the stock

Correct Answer: C. It changes the recorded inventory location

Question 4

A consignment has invoice value ₹200,000 and allocable freight ₹20,000. If one item represents 25% of invoice value, what freight is allocated to it using value-based allocation?

A. ₹2,500

B. ₹4,000

C. ₹5,000

D. ₹8,000

Correct Answer: C. ₹5,000

Question 5

Which principle best describes FEFO?

A. Issue the highest-cost batch first

B. Issue the earliest-expiring batch first

C. Issue the latest-received batch first

D. Issue batches in alphabetical order

Correct Answer: B. Issue the earliest-expiring batch first

Question 6

In a job-work reconciliation, 1,000 kg is sent, 940 kg is returned as output, and 40 kg is returned as scrap. What is the unexplained variance before investigation?

A. 10 kg

B. 20 kg

C. 40 kg

D. 60 kg

Correct Answer: B. 20 kg

Question 7

If average demand is 800 units per month, lead time is 3 months, and safety stock is 500 units, what is the reorder point?

A. 1,900 units

B. 2,400 units

C. 2,900 units

D. 3,300 units

Correct Answer: C. 2,900 units

Question 8

Which condition is an assumption of the classical EOQ model?

A. Demand is perfectly unpredictable

B. Ordering cost changes randomly each month

C. Replenishment is treated as instantaneous

D. Expiry risk is always included

Correct Answer: C. Replenishment is treated as instantaneous

Question 9

Which control most directly improves batch traceability?

A. Allowing all items to share one item code

B. Recording batch identifiers at relevant receipts and issues

C. Removing godown names from vouchers

D. Posting all freight to sales revenue

Correct Answer: B. Recording batch identifiers at relevant receipts and issues

Question 10

Which statement about job work is correct?

A. Materials sent for processing are automatically sold to the processor

B. Job work never requires quantity reconciliation

C. The principal may retain ownership of materials sent for processing

D. Job-work service charges must always be included in raw-material quantity

Correct Answer: C. The principal may retain ownership of materials sent for processing