Chapter 8
Production, Payroll, Fixed Assets and Project Systems
Bachelors Program in Accounting and Finance
Accounting Information Systems & ERP
•
Bachelor
Production, Payroll, Fixed Assets and Project Systems
Introduction
Production, payroll, fixed-asset and project systems convert operational events into financial records and managerial information. Although each system has a distinct purpose, they are strongly interconnected. Production consumes materials, labour and machine capacity; payroll values employee services; fixed-asset systems account for productive resources; and project systems accumulate costs, bill customers and assess performance.
In an enterprise resource planning (ERP) environment, a single operational event may update several modules. Recording production completion can reduce work in process, increase finished goods, absorb machine depreciation and assign direct labour. This integration improves timeliness but also creates risks: an incorrect master record, interface or allocation rule can affect multiple ledgers simultaneously.
Learning Objectives
After studying this chapter, students should be able to:
Explain production planning, execution and cost-accounting processes.
Describe payroll processing and correctly distinguish cash earnings from non-cash taxable benefits.
Apply a properly designed labour-clearing account.
Account for fixed assets throughout their life cycle.
Explain project planning, costing, billing and revenue-recognition interfaces.
Evaluate system interfaces, internal controls and managerial reports.
Analyse integrated ERP information using operational and financial measures.
1. Integrated ERP Architecture
An ERP system ordinarily combines transaction processing, master data, workflow, authorization and reporting. The general ledger receives summarized or detailed postings from subledgers, while reconciliation procedures confirm that the modules remain consistent.
Integration of production, payroll, fixed assets and project systems with the general ledger
Figure: Integration of production, payroll, fixed assets and project systems with the general ledger
Figure: ERP integration among operational subledgers and the general ledger.
Important shared master data include employees, materials, bills of materials, work centres, assets, projects, accounts and cost centres. Master-data governance is therefore essential. For example, an incorrect employee cost centre can misstate project cost, factory overhead and departmental performance without changing total payroll expense.
2. Production Planning and Execution
2.1 From demand to production order
Production planning translates expected demand into material and capacity requirements. A typical sequence is:
Sales forecasts and confirmed orders establish demand.
The master production schedule states what finished goods will be produced and when.
Material requirements planning (MRP) determines component requirements.
Capacity planning compares required machine and labour hours with available capacity.
Authorized production orders initiate manufacturing.
Material issues, labour time and machine activity are recorded against orders.
Completed output is transferred to finished goods.
For a component, planned net requirements may be expressed as:
NRt = max(0, GRt + SS - OHt - SRt)
where NRt is the net requirement in period t, GRt is gross requirement, SS is required safety stock, OHt is usable inventory on hand and SRt is scheduled receipts. All quantities must use compatible physical units. The expression is a simplified single-period calculation; full MRP also offsets planned orders by lead time and applies lot-sizing rules.
2.2 Bills of materials and routings
A bill of materials (BOM) identifies the components and quantities required for a product. A routing specifies the operations, work centres, setup time and processing time. Together, these records support planning and standard costing.
If each finished unit requires 3 components and planned production is 800 units, gross component demand is 3 × 800 = 2,400 components, before considering expected loss, inventory or scheduled receipts.
Controls should prevent unauthorized BOM or routing changes. Effective-dating and version control are necessary because engineering changes may apply only to production orders released after a specified date.
2.3 Production cost accumulation
Production systems commonly accumulate:
direct materials issued to an order;
direct labour recorded through time systems;
machine or activity costs;
production overhead allocated using predetermined rules;
scrap, rework and by-product amounts.
A predetermined overhead rate is:
POHR = BO ÷ BD
where POHR is the predetermined overhead rate, BO is budgeted overhead in currency units and BD is budgeted activity in the selected driver, such as machine-hours. The driver must have a defensible relationship with resource consumption.
If budgeted factory overhead is $720,000 and expected machine activity is 60,000 hours, the rate is $720,000 ÷ 60,000 = $12 per machine-hour. An order using 350 machine-hours receives 350 × $12 = $4,200 of applied overhead.
2.4 Production journal flows
Typical entries include:
Event
Debit
Credit
Direct materials issued
Work in process (WIP)
Raw-material inventory
Indirect materials issued
Factory overhead
Raw-material inventory
Direct labour assigned
WIP
Labour clearing
Indirect factory labour assigned
Factory overhead
Labour clearing
Overhead applied
WIP
Applied-overhead account
Goods completed
Finished goods
WIP
Goods sold
Cost of goods sold
Finished goods
The applied-overhead account is compared with actual overhead. Underapplied or overapplied overhead is disposed of according to organizational policy and the applicable reporting framework, often through cost of goods sold or allocation among inventory and cost-of-sales accounts when material.
2.5 Standard-cost variances
For direct materials:
MPV = AQ × (AP - SP)
MUV = SP × (AQ - SQ)
Here, MPV is material price variance, MUV is material usage variance, AQ is actual quantity purchased or used as defined by the system, AP is actual price per unit, SP is standard price per unit and SQ is standard quantity allowed for actual output. Positive results under these conventions are unfavourable.
For labour:
LRV = AH × (AR - SR)
LEV = SR × (AH - SH)
where AH is actual labour-hours, AR is actual hourly rate, SR is standard hourly rate and SH is standard hours allowed for actual output. Variance reports are diagnostic signals, not proof of responsibility. A usage variance may result from poor material quality rather than production inefficiency.
3. Human-Capital and Payroll Systems
3.1 Human-capital information
Human-capital management systems maintain employee identity, position, compensation, qualifications, leave, performance and training information. Payroll uses selected data from this system, but access should be restricted because the records contain sensitive personal and financial information.
The payroll cycle normally includes:
maintaining authorized employee and compensation records;
collecting attendance, time and production data;
calculating cash earnings;
determining taxable pay under applicable law;
calculating taxes, benefit contributions and other deductions;
reviewing exception reports;
authorizing payment;
remitting liabilities and posting accounting entries.
3.2 Cash earnings, taxable benefits and net pay
A non-cash taxable benefit can increase taxable income without increasing cash payable to the employee. Consequently, it must not be added to cash net pay.
Consider the following illustrative payroll calculation. An employee has cash gross earnings of $4,000 and a non-cash taxable benefit of $100. Under the assumed tax table, withholding on taxable pay of $4,100 is $796. Other authorized deductions are $420.
Thus, $4,000 - $796 - $420 = $2,784. The $100 taxable benefit affects taxable pay and withholding, but it is not cash earnings.
Payroll deductions and rates are jurisdiction-specific. Systems must be updated for current legislation, thresholds and employee elections rather than relying on a universal formula.
3.3 Correct use of labour clearing
A labour-clearing account temporarily holds gross cash payroll until labour is assigned to cost objects. At payroll recognition, the clearing account is debited and payroll liabilities are credited. When labour is distributed, WIP, overhead and administrative expense are debited and labour clearing is credited.
Using the preceding employee data, the payroll recognition entry is:
Account
Debit
Credit
Labour clearing
$4,000
—
Tax withholding payable
—
$796
Other deductions payable
—
420
Net pay payable
—
2,784
Total
$4,000
$4,000
If the employee's cash labour is classified as $3,000 direct production labour, $600 indirect factory labour and $400 administrative labour, the distribution is:
Account
Debit
Credit
WIP
$3,000
—
Factory overhead
600
—
Administrative wage expense
400
—
Labour clearing
—
$4,000
The labour-clearing balance is then zero. Crediting labour clearing in both entries would incorrectly double its credit balance rather than clear it.
The non-cash benefit is accounted for separately according to its economic nature. If the employer incurs a $100 benefit cost not previously recorded, an illustrative entry is debit employee-benefit expense and credit the relevant benefit payable or supplier liability for $100. This separate entry does not increase net pay.
Employer payroll taxes and employer-funded pension or benefit costs are also separate from employee deductions. They are recognized as employer expenses and liabilities, then allocated to production, projects or departments using an appropriate rule.
3.4 Payroll controls
Key controls include:
separation of employee hiring, time approval, payroll processing and payment release;
validation of bank-account and compensation changes;
supervisor approval of time and overtime;
duplicate identity and bank-account reports;
reconciliation of payroll registers, bank files and general-ledger postings;
review of inactive, terminated or unusually paid employees;
encryption, retention controls and role-based access;
independent review of payroll interface totals.
Biometric attendance may reduce time fraud but introduces privacy, consent and data-security concerns. Organizations should collect only necessary data and comply with applicable employment and privacy laws.
4. Fixed-Asset Life-Cycle Accounting
4.1 Asset acquisition and capitalization
The asset life cycle includes planning, approval, acquisition, capitalization, use, maintenance, impairment review, transfer and disposal. A fixed-asset register ordinarily stores asset class, location, custodian, cost, useful life, residual value, depreciation method and accumulated depreciation.
Capitalized cost generally includes the purchase price and directly attributable costs necessary to bring the asset to the location and condition required for intended operation. Routine repairs and training are normally expensed because they do not create or prepare the asset itself for use. Detailed treatment depends on the applicable accounting standard.
Suppose a machine costs $180,000, delivery is $6,000, installation is $9,000 and testing is $3,000. Assuming all amounts are directly attributable and no recognition exception applies, asset cost is:
$180,000 + $6,000 + $9,000 + $3,000 = $198,000.
4.2 Depreciation
Under straight-line depreciation:
DSL = (C - R) ÷ N
where DSL is annual depreciation in currency per year, C is depreciable asset cost, R is estimated residual value and N is useful life in years. The method assumes consumption is reasonably even over time.
For the $198,000 machine, with an $18,000 residual value and a six-year life:
For an asset whose consumption follows activity, units-of-production depreciation may be more faithful:
Dt = (C - R) × (Ut ÷ UT)
where Dt is depreciation for period t, Ut is actual output or usage during the period and UT is estimated total lifetime output or usage. Units must be consistent, such as machine-hours divided by total estimated machine-hours.
Useful lives, residual values and methods require periodic review under the applicable reporting framework. Changes in estimates are generally applied prospectively rather than treated as corrections of prior-period errors.
4.3 Component accounting, impairment and disposal
Where significant components have different useful lives, separate component records can improve depreciation accuracy. For example, an aircraft body and engine may require distinct schedules.
Impairment rules differ by framework. Under IFRS, the recoverable amount is the higher of value in use and fair value less costs of disposal. US GAAP applies different models and recoverability tests for long-lived assets. ERP configuration must therefore reflect the entity's reporting framework rather than applying one universal rule.
On disposal, the system removes asset cost and accumulated depreciation. The gain or loss is:
Gain\ or\ loss = Disposal\ proceeds - Carrying\ amount
where carrying amount equals asset cost less accumulated depreciation and recognized impairment. If proceeds exceed carrying amount, the difference is a gain; otherwise, it is a loss.
Physical verification, asset tags, transfer approvals and disposal authorization help protect assets. Fully depreciated assets still in use should remain in the register until disposal, with zero or residual carrying amount as appropriate.
5. Project Accounting Systems
5.1 Project structures and cost collection
Project systems support internal investments, customer contracts, research activities and implementation work. A work breakdown structure (WBS) divides the project into controllable deliverables or work packages. Costs can be collected from purchasing, inventory, payroll, fixed assets and expense claims.
Project records commonly include:
approved budget and funding source;
responsible manager;
start and completion dates;
WBS elements and activities;
cost and revenue categories;
billing terms and milestones;
capitalization or expense rules;
project status and completion forecasts.
Internal projects may create assets, but costs are capitalized only when recognition criteria under the applicable standard are met. Merely charging expenditure to a capital project does not make it an asset.
5.2 Project revenue and billing
Billing and revenue recognition are related but distinct. A customer invoice creates a receivable, whereas revenue is recognized when performance obligations are satisfied under IFRS 15 or ASC 606. Consequently, the difference may be reported as a contract asset or contract liability, subject to the relevant standard and facts.
For an obligation satisfied over time, a cost-to-cost input measure may be appropriate if costs faithfully depict performance:
Suppose a contract price is $500,000, estimated eligible total cost is $400,000 and eligible cost incurred to date is $160,000. If the over-time criteria are met and the input method faithfully represents performance:
If only $180,000 has been billed and no other adjustments apply, the $20,000 difference is generally a contract asset. Costs that do not depict performance, such as certain inefficiencies or significant uninstalled materials, may require adjustment rather than automatic inclusion.
5.3 Earned value analysis
Earned value management integrates project scope, schedule and cost:
CV = EV - AC
SV = EV - PV
CPI = EV ÷ AC
SPI = EV ÷ PV
Here, EV is budgeted cost of work performed, AC is actual cost, and PV is budgeted cost of work scheduled, all measured at the same reporting date and in the same currency. CV is cost variance, SV is schedule variance, CPI is cost performance index and SPI is schedule performance index. A CPI or SPI below 1 indicates unfavourable performance under these definitions.
Earned value measures are managerial tools; they do not by themselves determine financial-statement revenue.
6. Integrated Controls and Managerial Information
6.1 Interface and reconciliation controls
System integration can be real-time or batch-based. Essential controls include record counts, control totals, duplicate detection, valid-account checks, interface logs and error queues. Failed transactions should be corrected through controlled workflows rather than direct database edits.
Useful reconciliations include:
Reconciliation
Control objective
Production orders to WIP ledger
Completeness and accuracy of manufacturing cost
Payroll register to payment file
Only approved net pay is disbursed
Labour distribution to payroll gross earnings
Labour clearing returns to zero
Asset register to general ledger
Asset cost and accumulated depreciation agree
Project subledger to general ledger
Project costs, revenue and billing are complete
Subledger control totals before and after interface
No records are lost or duplicated
6.2 Managerial reports
Managers need both financial and non-financial information. Relevant reports include production yield, scrap rate, capacity utilization, overtime, labour turnover, asset downtime, maintenance cost, project margin and forecast-at-completion.
Reports should preserve causal distinctions. For example, a project may exceed budget because of scope changes, wage-rate increases, inefficient hours or incorrect charging. A single total variance cannot identify which explanation is valid.
Northstar Engineering is a fictional manufacturer of automated packaging equipment. It uses production orders for standard modules and project accounting for customer-specific installation. Management has recently integrated payroll, fixed assets and production with its ERP general ledger.
Problem
For one production order, actual output was 960 acceptable units. The material standard was 2.5 kg per unit at $8 per kg. Actual material usage was 2,460 kg at $8.40 per kg. The labour standard was 1.2 hours per unit at $24 per hour; actual direct labour was 1,180 hours at $25 per hour.
The weekly gross cash payroll was $40,000. It was distributed as $29,500 direct labour, $6,500 indirect factory labour and $4,000 administrative labour. Payroll liabilities, including net pay and deductions, totalled $40,000. The ERP implementation had incorrectly proposed crediting labour clearing during both payroll recognition and labour distribution.
Northstar also acquired a production machine for the $198,000 capitalized cost calculated earlier. Finally, a customer project had a $500,000 transaction price, $400,000 estimated total eligible cost, $160,000 cost incurred and $180,000 billed.
Analysis and solution
The standard material quantity allowed is 960 × 2.5 = 2,400 kg.
Material price variance:
2,460 × ($8.40 - $8.00) = $984 unfavourable.
Material usage variance:
$8 × (2,460 - 2,400) = $480 unfavourable.
Standard labour-hours allowed are 960 × 1.2 = 1,152 hours.
Labour rate variance:
1,180 × ($25 - $24) = $1,180 unfavourable.
Labour efficiency variance:
$24 × (1,180 - 1,152) = $672 unfavourable.
For the full payroll, recognition must debit labour clearing for $40,000 and credit the relevant payroll liabilities for $40,000. Distribution then debits WIP $29,500, factory overhead $6,500 and administrative wages $4,000, while crediting labour clearing $40,000. The account clears to zero.
The machine is depreciated at $30,000 annually under the stated straight-line assumptions. If used in production, the depreciation may enter factory overhead and ultimately inventory through the overhead-allocation process.
Project progress is 40%, cumulative revenue is $200,000 and cumulative gross profit is $40,000, assuming the stated revenue-recognition conditions are satisfied. Since billing is $180,000, the project has a $20,000 contract asset before other adjustments.
Outcome
Northstar corrected the labour-clearing configuration, introduced automated zero-balance exception reporting and restricted payroll posting-rule changes. Managers received separate price, usage, rate and efficiency reports rather than a single unexplained production variance.
Learning points
Integrated systems require consistent accounting direction, reliable master data and reconciled interfaces. Operational classifications affect inventory, departmental expense and project profitability even when total payroll remains unchanged. Automated postings do not remove the need for professional judgement over capitalization, allocation and revenue recognition.
8. Governance, Ethics and Contemporary Developments
Payroll and employee analytics may expose protected personal information. Ethical use requires a legitimate purpose, proportionate collection, transparent policies and safeguards against discriminatory algorithms. Project managers must not manipulate completion estimates to accelerate revenue, while asset custodians must not conceal missing equipment by retaining fictitious register entries.
Contemporary ERP systems increasingly use:
mobile time and production capture;
Internet of Things sensors for machine usage and predictive maintenance;
robotic process automation for reconciliations;
machine learning for payroll anomalies and project-cost forecasts;
digital twins for capacity and maintenance simulation;
cloud ERP with continuous software and tax updates.
AI-generated exceptions are not conclusive evidence of fraud or error. Models may reproduce historical bias, generate false positives or become unreliable when operations change. Human review, explainability, access controls and model-performance monitoring remain necessary.
9. Implementation Challenges and Best Practices
Common challenges include inaccurate legacy data, poorly designed account mappings, inconsistent definitions of direct labour, excessive customization and weak user training. Real-time integration can spread errors rapidly, while batch processing can delay detection.
Best practices are to:
assign accountable owners to shared master data;
document posting logic and allocation rules;
test normal, exceptional and reversal transactions;
reconcile source totals to subledgers and the general ledger;
use role-based access and workflow approvals;
monitor clearing accounts and interface errors;
retain audit trails for estimates and overrides;
review reports jointly with operational managers and accountants.
Chapter Summary
Production systems convert demand into production orders and collect material, labour and overhead costs. Payroll systems calculate cash earnings, taxable pay, deductions and liabilities; non-cash taxable benefits affect tax calculations but do not increase cash net pay. A labour-clearing account is debited when payroll is recognized and credited when labour is distributed to WIP, overhead and expenses.
Fixed-asset systems manage acquisition, capitalization, depreciation, impairment and disposal. Project systems collect costs, control budgets, support billing and provide information for revenue recognition and earned value analysis. Across all modules, reliable master data, segregation of duties, controlled interfaces, reconciliations and professional judgement are essential. Emerging automation and AI can improve exception detection, but they also require privacy, governance and human oversight.
Key Terms
Bill of materials: A structured record of components and quantities required to manufacture a product.
Routing: The sequence of operations, work centres and standard times required for production.
Material requirements planning: A method for determining the timing and quantity of component requirements.
Work in process: The inventory cost of incomplete production.
Predetermined overhead rate: A budgeted rate used to assign overhead to cost objects.
Standard cost: A predetermined benchmark cost for a material, labour or overhead input.
Labour clearing: A temporary account debited for gross payroll and credited when labour is distributed.
Taxable benefit: A benefit included in taxable income even though it may not be paid in cash.
Net pay: Cash earnings remaining after employee withholding and other cash deductions.
Human-capital management system: A system that manages employee, position, compensation and workforce information.
Fixed-asset register: A detailed subsidiary record of an entity's property and equipment.
Depreciation: Systematic allocation of an asset's depreciable amount over its useful life.
Residual value: The estimated amount recoverable from an asset at the end of its useful life.
Impairment: A reduction in an asset's carrying amount under applicable recognition rules.
Work breakdown structure: A hierarchical decomposition of a project into manageable elements.
Contract asset: A conditional right to consideration for goods or services already transferred to a customer.
Earned value: The budgeted cost of project work actually performed.
Interface control: A control designed to ensure complete, accurate and authorized transfer between systems.
Review Questions
Short Answer Questions
What information is contained in a bill of materials?
Why does a non-cash taxable benefit not increase cash net pay?
How should a labour-clearing account be used?
What costs are generally included in the initial cost of a fixed asset?
Distinguish project billing from project revenue recognition.
Long Answer Questions
Explain the complete production cycle from demand planning to transfer of completed goods.
Describe payroll risks and the controls that address unauthorized or inaccurate payments.
Discuss the fixed-asset life cycle and its principal accounting interfaces.
Explain how project systems integrate purchasing, payroll, assets, billing and the general ledger.
Evaluate the advantages and risks of real-time ERP integration.
Analytical / Application Questions
A production order completed 500 units. Each unit should use 4 kg at $6 per kg. Actual usage was 2,100 kg at $6.20 per kg. Calculate and interpret the material price and usage variances.
An employee has cash earnings of $5,000, a $200 non-cash taxable benefit, withholding of $1,050 and other deductions of $350. Calculate taxable pay and cash net pay, explaining the treatment of the benefit.
A project has an $800,000 transaction price, estimated eligible cost of $640,000, cost incurred of $256,000 and billings of $280,000. Assuming over-time recognition and a faithful cost-to-cost measure, calculate progress, cumulative revenue, gross profit and the resulting contract asset or liability position.
Multiple Choice Questions with Answers
Question 1
Which production master record identifies the components and quantities required for a finished product?
A. Routing
B. Bill of materials
C. Asset register
D. Payroll register
Correct Answer: B. Bill of materials
Question 2
An employee has cash gross earnings of $4,000, a $100 non-cash taxable benefit, withholding of $796 and other deductions of $420. What is cash net pay?
A. $2,684
B. $2,784
C. $2,884
D. $3,204
Correct Answer: B. $2,784
Question 3
Which pair of entries correctly operates a labour-clearing account?
A. Payroll recognition credits labour clearing; labour distribution also credits labour clearing
B. Payroll recognition debits labour clearing; labour distribution credits labour clearing
C. Payroll recognition credits labour clearing; labour distribution debits labour clearing
D. Payroll recognition debits WIP directly; labour distribution debits labour clearing
Correct Answer: B. Payroll recognition debits labour clearing; labour distribution credits labour clearing
Question 4
Budgeted factory overhead is $600,000 and expected machine activity is 50,000 hours. What is the predetermined overhead rate?
A. $10 per machine-hour
B. $12 per machine-hour
C. $50 per machine-hour
D. $120 per machine-hour
Correct Answer: B. $12 per machine-hour
Question 5
A machine costs $198,000, has an estimated residual value of $18,000 and a six-year useful life. What is annual straight-line depreciation?
A. $27,000
B. $30,000
C. $33,000
D. $36,000
Correct Answer: B. $30,000
Question 6
Which statement correctly distinguishes project billing from revenue recognition?
A. Billing and revenue must always be equal in each period
B. Billing records project costs, while revenue records cash receipts
C. Billing creates a receivable, while revenue depends on satisfaction of performance obligations
D. Revenue may be recognized only after the final invoice
Correct Answer: C. Billing creates a receivable, while revenue depends on satisfaction of performance obligations
Question 7
A project has earned value of $150,000 and actual cost of $125,000. What is its cost performance index?
A. 0.83
B. 1.00
C. 1.20
D. 1.25
Correct Answer: C. 1.20
Question 8
A product has a standard material requirement of 2 kg per unit. Actual output is 600 units and actual material usage is 1,260 kg. What is the standard quantity allowed for actual output?
A. 1,160 kg
B. 1,200 kg
C. 1,260 kg
D. 1,320 kg
Correct Answer: B. 1,200 kg
Question 9
Which control most directly detects incomplete or duplicated transfers between an operational subledger and the general ledger?
A. Comparing interface record counts and control totals
B. Increasing employee overtime approval limits
C. Changing the asset depreciation method annually
D. Allowing direct database corrections
Correct Answer: A. Comparing interface record counts and control totals
Question 10
A project has a transaction price of $500,000, estimated eligible total cost of $400,000 and eligible cost incurred of $160,000. Assuming over-time recognition and a faithful cost-to-cost measure, what is cumulative revenue?
A. $160,000
B. $180,000
C. $200,000
D. $320,000
Correct Answer: C. $200,000
Accounting Information Systems & ERP
Chapter 8
of 15