All articles

Enterprise Systems9 min read

ERP Project Accounting: Budgets, Costs and Revenue by Project

ERP project accounting attaches every cost, commitment and invoice to a project so you can see budget, actuals, forecast and margin in one place. This guide covers project structure, cost capture, revenue recognition basics and reports.

Written byUsama AsifPublished

ERP project accounting tags every relevant transaction (timesheets, purchases, stock issues, expenses, invoices) to a project and its tasks, so the business can compare budget, committed cost, actual cost and forecast for each project, and recognise revenue on a basis its accountants accept. It answers one question continuously: is this project making the money we expected?

Construction firms, engineering contractors, agencies, consultancies and installers all live or die by project margin. Spreadsheet job costing usually reports that margin weeks late, after the money is spent. This guide covers how to structure projects in an ERP, how to capture costs and commitments, the basics of revenue recognition, the reports that matter and a worked example.

What does ERP project accounting include?

Project accounting combines a project structure, budgets, cost capture from other modules, billing and revenue, and reporting. The structure is the foundation, because every other module posts against it.

ComponentWhat it holdsFed by
Project and tasksProject, phases or work breakdown structure, cost codesProject managers
BudgetOriginal budget, approved changes, revised budget by cost codeEstimating, project managers
CommitmentsApproved purchase orders and subcontracts not yet invoicedProcurement
Actual costsLabour from timesheets, materials, supplier invoices, expenses, equipmentPayroll, inventory, payables
BillingMilestones, time and materials, progress claims, retentionsFinance
RevenueRevenue recognised by period on the agreed basisFinance
ForecastEstimate to complete and estimate at completionProject managers

If your projects have specific contract structures, cost codes or billing rules, our custom ERP software page explains how a system is built around them, and project dashboards are often delivered as business dashboards on top of the ERP data.

How should projects be structured in an ERP?

Use a consistent hierarchy: project, then phases or work packages, then cost codes. Keep it shallow enough that people post to the right place without guessing.

  • Project: one per contract or engagement, linked to a customer, entity and project manager.
  • Phases or tasks: stages of work that matter for billing or tracking, such as design, procurement, installation and commissioning.
  • Cost codes: a company-wide list (labour, materials, subcontract, equipment, overheads) so projects can be compared.
  • Change orders: each approved variation has its own reference, budget and price, so you can see original scope against changes.

A standard cost code list across projects is what makes portfolio reporting possible. Allow projects to add tasks, but not to invent cost codes.

How do budgets and commitments work in project accounting?

A budget sets what each cost code is expected to cost. A commitment is money already promised (an approved purchase order or subcontract) but not yet invoiced. Tracking commitments is what turns project accounting from a history report into an early warning.

The key formula is:

Exposure = actual cost to date plus open commitments

If exposure on a cost code is approaching budget while work remains, the project manager knows before the invoices arrive. Purchase orders should be coded to a project and cost code at the request stage, because the procurement module is where commitments are created and approved.

Budget control options to decide:

  • Warn or block: warn the requester when a purchase would exceed the cost code budget, or block it until a budget transfer or change order is approved.
  • Budget transfers: moving budget between cost codes needs approval and a record.
  • Revised budget: original budget plus approved change orders, kept separate so you can see how scope moved.

How are project costs captured?

Costs reach the project from other modules, so project accounting is only as good as the coding at source. Each cost type needs a capture route.

Cost typeCapture routeCommon problem
LabourApproved timesheets valued at a cost rateLate or unapproved timesheets; wrong rate
MaterialsStock issued to project, or direct purchase delivered to siteMaterials bought for one job used on another
SubcontractSubcontract orders and progress claimsClaims not matched to commitment
ExpensesExpense claims coded to projectMissing project code
EquipmentInternal hire rates per day or hourNo agreed internal rate
OverheadsAllocation by rule at period endArbitrary or changing allocation rules

Labour cost rates usually come from payroll, so agree with HR and finance whether projects carry actual pay, a standard rate per grade, or a rate that includes employer costs and overheads.

How does revenue recognition work for projects?

Revenue is recognised under the accounting framework that applies to you: IFRS 15 Revenue from Contracts with Customers under IFRS, or ASC 606 under US GAAP. The two were issued as a converged standard in 2014 by the IASB and FASB, and IFRS 15 replaced IAS 11 Construction Contracts.

Both use a five-step model: identify the contract, identify the performance obligations, determine the transaction price, allocate it to the performance obligations, and recognise revenue when or as each obligation is satisfied. Revenue may be recognised over time or at a point in time, and for obligations satisfied over time the entity chooses a measure of progress.

What this means for the ERP, without turning it into accounting advice:

  • Billing and revenue are separate. An invoice is not revenue. The system must track amounts billed and revenue recognised independently.
  • Measure of progress is configurable. Common bases include cost incurred against total estimated cost (an input method) or milestones and surveys (output methods). Your accountants choose the basis; the ERP calculates it consistently.
  • Contract assets and liabilities. When revenue recognised exceeds billing, or the reverse, the difference is reported on the balance sheet. The ERP should produce that schedule per project.
  • Estimates drive revenue. If progress is cost-based, a wrong estimate to complete changes revenue, so forecast updates need review and approval.

Illustrative example (hypothetical figures, cost-based progress):

ItemAmount
Contract price500,000
Original cost budget400,000
Approved change order: price50,000
Approved change order: cost40,000
Revised price550,000
Revised budget440,000
Actual cost to date220,000
Estimate to complete240,000
Estimate at completion460,000
Progress (220,000 divided by 460,000)About 47.8 percent
Revenue to date at that progressAbout 263,000
Billed to date300,000
Forecast margin (550,000 minus 460,000)90,000

Two things stand out. The forecast margin has fallen from the 110,000 implied by the revised budget to 90,000, because the estimate at completion exceeds the revised budget by 20,000. And billing is ahead of revenue by about 37,000, which the ERP should report as a contract liability. Whether cost-based progress is appropriate for a contract is a judgement for your accountants.

What reports should ERP project accounting produce?

The reports should let a project manager act this week and let finance close the month. These are the core set:

  • Project cost report: budget, revised budget, committed, actual, estimate to complete and estimate at completion by cost code
  • Project profitability: revenue, cost and margin to date and at completion, against the original estimate
  • Work in progress schedule: revenue recognised against billing per project, showing contract assets and liabilities
  • Change order log: submitted, approved and rejected variations with value and status
  • Labour utilisation: hours by person, project and billable status
  • Portfolio view: all projects ranked by margin erosion or forecast overrun

Our guide to business dashboard KPI design covers how to present these without burying the warning signs.

When is ERP project accounting not the right approach?

Full project accounting is more than you need when projects are short, small or billed simply.

  • Short fixed-fee jobs: a job costing feature in accounting software may be enough.
  • Pure time and materials billing with no fixed budgets: a timesheet and billing tool integrated with the ledger may suffice.
  • No discipline in coding: if timesheets and purchases are not coded to projects at source, the reports will be wrong whatever the system.
  • Specialist industry tools already fit: some construction and professional services platforms handle project control well; integrating them with the ERP may beat replacing them.

Industry detail differs. Our sibling guides on ERP for construction companies and ERP for professional services firms cover sector-specific needs.

Project accounting requirements checklist

  • Project hierarchy and company-wide cost code list agreed
  • Budget, change order and budget transfer process with approvals
  • Purchase orders and subcontracts coded to project and cost code at request
  • Timesheets approved weekly, valued at agreed cost rates
  • Billing types supported: milestone, time and materials, progress claims, retentions
  • Revenue basis agreed with accountants, with billing and revenue tracked separately
  • Estimate to complete updated and approved each period
  • Work in progress schedule and project profitability reports defined
  • Multi-entity and multi-currency needs recorded

How to start

Pick three recent projects, one profitable, one that lost money and one typical, and write down how their costs, changes and billing flowed. That exercise exposes the requirements faster than any workshop. Use our software requirements brief template to record them, then discuss the project with us. Timeline Digital builds 2 to 3 key modules as a free pilot before the full project starts, so you can test project cost reporting on your own projects before committing.

Frequently asked questions

What is project accounting in an ERP?

Project accounting tags timesheets, purchases, stock issues, expenses and invoices to a project and its tasks, so the business can compare budget, commitments, actual cost and forecast for each project, and recognise revenue on an agreed basis. It is used by construction firms, contractors, agencies, consultancies and any business that sells work in projects and needs to know margin before the project ends.

What is the difference between committed cost and actual cost?

Actual cost has been incurred and recorded, for example approved timesheets, stock issued and supplier invoices posted. Committed cost is money already promised but not yet invoiced, such as approved purchase orders and subcontracts. Adding the two gives exposure, which shows how close a cost code is to its budget before the invoices arrive, so project managers can act earlier.

How does an ERP handle revenue recognition for projects?

Under IFRS 15 or ASC 606, revenue is recognised when or as performance obligations are satisfied, either over time or at a point in time. The ERP should track billing and revenue separately, calculate progress on the basis your accountants choose, such as cost incurred against estimated total cost or milestones, and report the difference as contract assets or liabilities. The choice of basis is an accounting judgement.

What reports does project accounting need?

The core set is a project cost report by cost code (budget, revised budget, committed, actual, estimate to complete and at completion), project profitability against the original estimate, a work in progress schedule comparing revenue and billing, a change order log, labour utilisation and a portfolio view that ranks projects by margin erosion. Project managers use them weekly and finance at month-end.

Can accounting software do project accounting?

Many accounting packages offer basic job or project tracking, which works for short fixed-fee jobs. They tend to fall short on commitments, change orders, estimates to complete, revenue recognised separately from billing, and portfolio reporting. When projects are long, contracts change during delivery, or margin needs to be forecast rather than reported afterwards, a dedicated project accounting module is usually needed.

Topics in this article

  • ERP
  • Project Accounting
  • Job Costing
  • Revenue Recognition
  • ERP Modules
  • Enterprise Systems

Start a conversation

Tell us how your business works.

Describe what is slowing your team down. We will help you work out what to build, and how a free pilot lets you judge our work before the full project.

Prefer WhatsApp? Start a chat

What happens next

  1. You send a short brief

    The problem, the people involved and any target date. A senior engineer replies within 4 business hours.

  2. We understand your workflow

    A first call about how your business works today. An NDA can be signed before you share details.

  3. You test a free pilot

    You choose 2 to 3 key modules and we build them first, so you judge real software before the full project.