# SAP SD Milestone Billing Plan Calculator

> Source: https://netray.co/tools/sap-sd-milestone-billing-plan-calculator
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Split a contract value across milestones, clear an advance proportionally and see the net invoice and retention for each step.

## Category

sap

## Erp

SAP S/4HANA

## Audience

- SAP SD consultant
- Project finance
- Billing specialist

## Tool

**Kind:** calculator

**Currency:** $

**Inputs:**

#### Contract value

**Key:** value

**Type:** number

**Default:** 1200000

**Min:** 0

**Step:** 10000

#### Down payment

**Key:** dp_pct

**Type:** slider

**Default:** 20

**Min:** 0

**Max:** 50

**Step:** 1

**Unit:** % of contract

#### Milestone 1 share of contract

**Key:** m1_pct

**Type:** number

**Default:** 30

**Min:** 0

**Max:** 100

**Step:** 1

**Unit:** %

#### Milestone 2 share of contract

**Key:** m2_pct

**Type:** number

**Default:** 40

**Min:** 0

**Max:** 100

**Step:** 1

**Unit:** %

#### Retention held on milestone billing

**Key:** ret_pct

**Type:** number

**Default:** 5

**Min:** 0

**Max:** 20

**Step:** 0.5

**Unit:** %

**Outputs:**

#### Down payment request

**Key:** dp_amt

**Expr:** value * dp_pct / 100

**Format:** currency

**Primary:** true

#### Milestone 1 net invoice

**Key:** m1_net

**Expr:** value * m1_pct / 100 * (1 - dp_pct / 100)

**Format:** currency

#### Milestone 2 net invoice

**Key:** m2_net

**Expr:** value * m2_pct / 100 * (1 - dp_pct / 100)

**Format:** currency

#### Milestone 3 share of contract

**Key:** m3_pct

**Expr:** max(0, 100 - m1_pct - m2_pct)

**Format:** percent

#### Milestone 3 net invoice

**Key:** m3_net

**Expr:** value * m3_pct / 100 * (1 - dp_pct / 100)

**Format:** currency

#### Total retention held

**Key:** ret_total

**Expr:** value * ret_pct / 100

**Format:** currency

**Primary:** true

#### Total billed (should equal contract)

**Key:** check

**Expr:** dp_amt + m1_net + m2_net + m3_net

**Format:** currency

**Chart:**

#### Net milestone invoices vs down payment share

**Type:** bar

**X:** dp_pct

**From:** 0

**To:** 50

**Steps:** 11

**Series:**

- m1_net
- m2_net
- m3_net

**Disclaimer:** Simplified. Taxes on the down payment, retention release timing and rounding of the clearing amount are not modelled.

## Content

**Intro:** Milestone billing plans in SAP SD link invoices to project or contract milestones, often with a down payment requested up front. Billing teams struggle to explain why a milestone invoice is smaller than the milestone percentage. This calculator shows the maths.

**Sections:**

#### How to use it

**Body:** Enter the contract value, the down payment percentage and the shares of the contract for the first two milestones. The third milestone takes the remainder. Then enter the retention percentage if the customer holds back part of each invoice. The outputs list the down payment request, the net invoice for each milestone and the retention total. The check line should always equal the contract value.

#### Proportional clearing

**Body:** When the down payment is cleared proportionally, each milestone invoice settles a share of the advance equal to its share of the contract. With a 20 percent down payment, every milestone invoice is reduced by 20 percent. A milestone worth 360,000 gross results in a net invoice of 288,000, and the remaining 72,000 is cleared against the advance already paid.

**Bullets:**

- Down payment request is a billing document type of its own
- Clearing happens in the final or milestone invoice
- Tax on down payments depends on local rules

#### Reading the chart

**Body:** The bar chart sweeps the down payment share from zero to 50 percent. As the advance grows, every milestone invoice shrinks, and the cash arrives earlier. Use this to explain to a project manager why the cash profile changes when the down payment is negotiated up or down, even if the contract value stays the same.

#### Common mistakes

**Body:** Do not forget that milestone shares must add up to 100 percent of the contract excluding the down payment. Retention is not the same as the advance: it is a withheld amount that you invoice later. Finally, billing plan dates and milestone status drive when the billing block is released, so test the workflow, not only the numbers.

**Cta:** If you want a read-only view of billing plans that are due, blocked or overdue across your contracts, we can build it over your SD data.

**Faq:**

#### What is the difference between milestone and periodic billing?

**Answer:** Periodic billing creates invoice dates on a fixed schedule. Milestone billing ties each billing date to a project milestone and releases it when the milestone is reached.

#### Can the down payment be cleared in the final invoice only?

**Answer:** Yes, depending on configuration. This tool shows proportional clearing, which is common. For clearing in the last invoice, the earlier invoices would be gross and the last one smaller.

#### Does retention reduce the invoice?

**Answer:** It depends on the contract. Here it is shown as a total held amount, not as a deduction from the net invoice. Adjust to match your contract.

#### Why must shares add up to 100?

**Answer:** Because the milestone invoices together must cover the contract value. The third milestone is calculated as the remainder to avoid an under or over billing.

## Search terms

sap milestone billing, sap billing plan down payment, sap milestone billing plan calculation, sap down payment clearing, sap retention billing, milestone invoice calculator, sap fpla billing plan

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