A PI total is the sum of the lines (quantity × unit price, to the cent), less any discount, plus freight and insurance; a deposit rate gives the deposit and the balance.
Example: 3 goods lines come to a subtotal of USD 31,722.04; less a 5% discount, plus USD 1,800.00 freight and USD 95.50 insurance, the total is USD 32,031.44; a 30% deposit is USD 9,609.43 (rounded half up to 2 decimal places).
Result
Subtotal
USD 31,722.04
This calculator needs JavaScript to run. The formula and the worked example below work without it.
- Discount
- USD 1,586.10
- Freight
- USD 1,800.00
- Insurance
- USD 95.50
- Total
- USD 32,031.44
- Deposit
- USD 9,609.43
- Balance
- USD 22,422.01
- Line 1Quantity × unit price, rounded to 0.014,500 × USD 7.04 = USD 31,680.00
- Line 2Quantity × unit price, rounded to 0.0112.5 × USD 3.333 = USD 41.66
- Line 3Quantity × unit price, rounded to 0.013 × USD 0.125 = USD 0.38
- SubtotalThe sum of the line amounts as printedSum of the line amounts: USD 31,722.04
- DiscountThe discount applies to the goods only, not to freight or insuranceSubtotal × 5% = discount USD 1,586.10, goods after discount USD 30,135.94
- Freight and insuranceAdded as you typed them, with no discount
- TotalGoods (subtotal − discount) + freight + insuranceUSD 32,031.44
- Deposit and balanceDeposit = total × deposit rate (rounded to 0.01); balance = total − depositTotal × 30% = deposit USD 9,609.43; balance USD 22,422.01
Formula
Line amount = quantity × unit pricerounded to 0.01 and used as printed
Subtotal = the sum of the line amounts
Discount = subtotal × discount rate, or an amount you enteron the goods only, not on freight or insurance
Total = subtotal − discount + freight + insurance
Deposit = total × deposit rate; balance = total − depositthe deposit is rounded to 0.01
Not covered
- No tax line: export sales are usually zero-rated or exempt, so a PI does not normally show tax, and the refund is the seller's own matter.
- Every currency is worked to two decimal places; currencies with no minor unit, such as JPY and KRW, are not handled separately yet.
- Up to 50 goods lines; one discount, taken on all the goods.
- What you type is not sent to this site and is not put in the address or a share link; it is kept only in your own browser, and you can clear it at any time.
Worked example
Example inputs: Currency USD; Goods lines Quantity 4,500, Unit price 7.04; Quantity 12.5, Unit price 3.333; Quantity 3, Unit price 0.125; Discount 5; Discount is A percentage (%); Freight 1800; Insurance 95.5; Deposit rate (%) 30
| Step | Working |
|---|---|
| Line 1 | 4,500 × USD 7.04 = USD 31,680.00 |
| Line 2 | 12.5 × USD 3.333 = USD 41.66 |
| Line 3 | 3 × USD 0.125 = USD 0.38 |
| Subtotal | Sum of the line amounts: USD 31,722.04 |
| Discount | Discount USD 1,586.10, goods after discount USD 30,135.94 |
| Freight and insurance | Added as you typed them, with no discount |
| Total | USD 32,031.44 |
| Deposit and balance | Total × 30% = deposit USD 9,609.43; balance USD 22,422.01 |
FAQ
What does PI generator give for an example?
Example: 3 goods lines come to a subtotal of USD 31,722.04; less a 5% discount, plus USD 1,800.00 freight and USD 95.50 insurance, the total is USD 32,031.44; a 30% deposit is USD 9,609.43 (rounded half up to 2 decimal places).
What is a proforma invoice (PI)?
A PI is a document the seller sends the buyer before the order is confirmed, stating the goods, unit prices, total, price term and payment terms. Buyers often use it to arrange payment or a letter of credit. It is not the commercial invoice used for customs.
How are the discount, freight and insurance worked out?
The discount applies to the goods (the subtotal) only. Freight and insurance are added exactly as you enter them, with no discount. Total = subtotal − discount + freight + insurance.
Why is there no tax line?
Export sales are usually zero-rated or exempt, so a PI to a buyer does not normally show tax; the refund is the seller's own matter and does not appear on the PI. This tool has no tax line.
Related tools
Results are for reference only. The figures confirmed by the tax authorities, banks and carriers prevail.Disclaimer