Costing & FinanceFree worksheetPDF, Excel, Word exportIndustrial Machinery

Project Milestone Billing Worksheet for Machine Builders

Machine projects run for months and cost is incurred far ahead of the final payment. This worksheet lays out the billing milestones next to the cost you expect to have incurred, so you can see cash exposure and margin by milestone before you sign.

Download:
MilestoneTriggerPlanned dateInvoice amountRetention % (%)Retention heldTax % (%)TaxCash dueCost incurred by milestoneMargin earned
$0
$0
$200,000
$185,000
$0
$0
$150,000
$30,000
$0
$0
$350,000
$10,000
$0
$0
$150,000
$90,000
$0
$0
$100,000
$60,000
$0
$0
$50,000
$45,000
Contract value
$1,000,000
Retention held
$0
Tax
$0
Cash due
$1,000,000
Total cost
$580,000
Total margin
$420,000
Gross margin on contract
42%
Average milestone size as percent of contract
16.7%

Enter milestone amounts that sum to the contract value. Use the retention column only if the contract holds back a percentage on a milestone; a separate retention release row (as in the example) is an alternative. Compare cost incurred against billed amounts to spot milestones that leave you cash-negative.

Automate milestone invoicing

Optional review of how milestone billing plans in your ERP can be triggered from FAT and SAT evidence.

Optional. The tool and every export work without this. No spam.

How to use the worksheet

List each billing milestone from the contract in order, with its trigger, planned date and invoice amount. Set retention and tax percentages where they apply, and enter the cost you expect to have incurred by that point. The sheet computes retention held, tax, cash due and margin earned for each row, plus totals and the overall gross margin. Edit the dates when the project schedule changes and export to Excel for finance and the project manager.

  • Match trigger names to the contract wording exactly.
  • Use cumulative cost to date if that is easier; keep it consistent.
  • Enter tax only if it is billed on the invoice in your jurisdiction.
  • Add rows for variation orders as they are approved.

Designing the payment schedule

A common pattern for custom machinery is a down payment at order, a design approval milestone, a larger payment after FAT or before shipment, and a final payment after site acceptance, sometimes with a retention released after warranty. The goal is to keep cumulative billing at or above cumulative cost so the customer finances the project and not you. Compare the billed total against the cost incurred at each milestone: a negative gap means you are funding the project, which has a cost of money.

Triggers and evidence

Define each trigger with evidence: a signed design approval, a FAT report, a shipping document, a SAT certificate. Disputes about whether a milestone was reached are the most common reason payments are late. For milestones that rely on the customer, such as site readiness, include a long-stop date after which the invoice may be issued anyway. In an ERP, milestone billing plans in sales or project modules automate invoice creation when the milestone is confirmed.

Common mistakes

The usual errors are back-loading payments so that most cash arrives after SAT, accepting an open-ended acceptance clause, and forgetting that the retention is revenue you may not collect for a year or more. International contracts add letters of credit, bank guarantees and currency risk, all of which have cost. Ignoring sales tax or withholding tax timing can also create unpleasant surprises. Review the schedule with finance before it goes into the proposal.

Frequently Asked Questions

What is a typical milestone split for a custom machine?

There is no standard, but a common structure is 20 to 30 percent at order, 30 to 40 percent on design approval or material milestones, 30 to 40 percent at FAT or shipment, and the rest at acceptance. Retention of 5 to 10 percent is often held until after warranty. Always negotiate by cash exposure.

How is retention different from a deposit?

A deposit is paid in advance to fund the project. Retention is part of the contract value held back by the customer until a condition is met, usually acceptance or the end of warranty. Retention is a receivable at risk, so track it separately and consider a bank guarantee in exchange.

What if the customer delays the milestone?

Include contract terms that allow invoicing after a long-stop date when the delay is caused by the customer, and record the delay. Without such terms, project cost keeps accruing while billing waits. Keep evidence of requests and notices in case of a claim.

Can ERP automate milestone billing?

Most ERPs offer billing plans or project milestones that create invoices when a milestone is released. The work is in defining triggers and approvals so release is controlled. Start by mapping your contract milestones to the ERP's billing plan or project task structure.

If milestone invoices are created manually from spreadsheets, Netray can help connect project status in your ERP to billing plans so invoices follow evidence.

Talk to an ExpertExplore More Free Tools

Related Tools

Industry Templates

Engineer to Order Machine Quote Worksheet

Line-by-line cost build-up for a one-off machine quote with a risk allowance per line and the resulting price at 20 to 35 percent gross margin.

Industry Templates

Equipment Factory Acceptance Test (FAT) Checklist

A factory acceptance test checklist for custom machinery covering documents, mechanical, electrical, safety, controls and run-off tests before shipment.

Industry Templates

Site Acceptance Test (SAT) Report Template

A fill-in site acceptance test report for installed machinery with utilities check, test results table, punch list and customer sign-off.

Field Service & Quality

Machine Service Contract Pricing Calculator

Builds an annual service contract price from preventive visits, expected corrective calls, parts, overhead and target margin.

More Costing & Finance tools

See all
Back to All Tools