# Percentage of Completion (Cost-to-Cost) Revenue Calculator

> Source: https://netray.co/tools/percentage-of-completion-cost-to-cost-revenue-calculator
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Compute percent complete, revenue and gross profit to date, billing position and any loss provision for an engineer-to-order contract.

## Category

cost-finance

## Industry

Industrial Machinery

## Audience

- Controller
- Project accountant
- Engineer-to-order finance

## Tool

**Kind:** calculator

**Currency:** $

**Inputs:**

#### Total contract price

**Key:** price

**Type:** number

**Default:** 1200000

**Min:** 0

**Step:** 10000

**Unit:** $

#### Estimated total cost at completion

**Key:** est_cost

**Type:** number

**Default:** 900000

**Min:** 0

**Step:** 10000

**Unit:** $

**Help:** Update this every month. It is the most important input.

#### Cost incurred to date

**Key:** cost_to_date

**Type:** number

**Default:** 450000

**Min:** 0

**Step:** 10000

**Unit:** $

**Help:** Include only costs that reflect progress. Exclude uninstalled materials that are not yet used.

#### Billed to date

**Key:** billed

**Type:** number

**Default:** 500000

**Min:** 0

**Step:** 10000

**Unit:** $

**Outputs:**

#### Percent complete

**Key:** pct

**Expr:** min(100, cost_to_date / est_cost * 100)

**Format:** percent

**Primary:** true

#### Revenue recognized to date

**Key:** rev

**Expr:** price * pct / 100

**Format:** currency

**Primary:** true

#### Gross profit to date

**Key:** gp

**Expr:** rev - cost_to_date

**Format:** currency

#### Estimated gross profit at completion

**Key:** est_gp

**Expr:** price - est_cost

**Format:** currency

#### Unbilled (+) or overbilled (-) position

**Key:** position

**Expr:** rev - billed

**Format:** currency

**Description:** Positive is a contract asset (underbilling). Negative is a contract liability (overbilling).

#### Total expected contract loss

**Key:** loss_total

**Expr:** max(0, est_cost - price)

**Format:** currency

#### Additional loss provision needed now

**Key:** loss_extra

**Expr:** loss_total - loss_total * pct / 100

**Format:** currency

**Description:** Under the usual rule the whole expected loss is recognized immediately; this is the part not yet absorbed by progress.

**Chart:**

#### Revenue and position vs cost to date

**Type:** line

**X:** cost_to_date

**From:** 0

**To:** 1000000

**Steps:** 21

**Series:**

- rev
- position

**Disclaimer:** Educational calculation of the cost-to-cost input method. Your accounting policy, contract terms and auditor determine actual recognition under ASC 606 or IFRS 15.

## Content

**Intro:** Machine builders with long engineer-to-order contracts often recognize revenue over time. The cost-to-cost method measures progress by the share of total estimated cost already spent, then applies it to the contract price.

**Sections:**

#### How to use it

**Body:** Enter the contract price, the current estimate of total cost at completion, the cost incurred to date and the amount billed so far. The calculator returns percent complete, the revenue recognized to date and gross profit to date. It then compares revenue with billings to show whether you have a contract asset (revenue recognized ahead of billing) or a contract liability (billing ahead of revenue). If the estimated cost now exceeds the price, it shows the full expected loss and how much additional provision is required. Run it per contract at each month end, using the cost estimate the project manager signs off.

#### The method

**Body:** Percent complete equals cost incurred divided by estimated total cost. Revenue to date is that percentage times price. Gross profit to date is revenue minus cost incurred. The billing position is revenue minus billed amounts. This is an input method permitted under ASC 606 and IFRS 15 when the performance obligation is satisfied over time. Costs that do not reflect progress, such as large purchased equipment delivered to site but not yet installed, are normally excluded from the measure or recognized at cost with no margin, depending on the policy you adopt.

**Bullets:**

- Revise the estimate at completion whenever scope or supplier prices change.
- Catch-up adjustments flow through current-period profit.
- Keep a loss provision as soon as the estimate exceeds price.

#### Reading the output

**Body:** In the default case, 450,000 of 900,000 spent means 50 percent complete, so 600,000 of revenue is recognized against 500,000 billed, leaving a 100,000 contract asset. A large positive position means invoicing is lagging the work and cash is being financed by you; check the milestone schedule. A large negative position means the customer funded the project ahead of progress, which is good for cash but must be shown as a liability. The chart sweeps cost to date and shows both lines moving together.

#### Common mistakes

**Body:** The biggest error is a stale estimate at completion: if engineers have found extra work but the number is unchanged, percent complete is understated and profit overstated until a painful catch-up. A second error is counting purchased material at full value as progress. A third is forgetting that warranty cost and commissions belong in the estimated cost. In an ERP, the project cost ledger and billing milestones should feed this calculation automatically at each period close.

**Cta:** If your project costs and billing milestones are in an ERP, we can build a read-only agent that drafts the month-end percent complete schedule for your controller to review.

**Faq:**

#### Is cost-to-cost the only way to measure progress?

**Answer:** No. Output methods such as milestones reached, units delivered or surveys of work performed are also allowed. Cost-to-cost is popular because costs are already tracked and verifiable, but the right method depends on how value transfers to the customer.

#### What happens when estimated cost exceeds the contract price?

**Answer:** The contract is onerous and the entire expected loss is recognized immediately, not spread across the remaining progress. This calculator shows the total loss and the part not yet absorbed by percent complete.

#### Does overbilling mean I recognized too little revenue?

**Answer:** No. It means you invoiced more than the revenue earned so far, so the excess sits as a contract liability on the balance sheet. It is a timing difference, not an error, provided the progress measure is sound.

#### How often should the estimate at completion be updated?

**Answer:** At least every month close, and immediately after any significant change order, supplier cost change or schedule slip. Many companies also require the project manager to document the forecast and have finance review it.

## Search terms

percentage of completion calculator, cost to cost method calculator, ASC 606 over time revenue recognition, IFRS 15 cost to cost, contract asset unbilled revenue calculator, overbilling underbilling calculator, WIP schedule construction contract, engineer to order revenue recognition

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json