I’m working on a milestone-based billing setup where each milestone has a retention amount held by the customer. I would like to clarify the correct way to handle this scenario in NetSuite.
Business Case:
- Milestone Billing With Retention Deduction
- Example: Certified milestone value = RM1,000,000
- Retention 10% = RM100,000
- Tax should be applied only on the net amount (RM900,000), not on the retention.
- Each milestone invoice must show the gross milestone value, retention deducted, and tax calculated on the net.
- Retention Release at Final Milestone
- When the project is completed, the retention amount (RM100,000) will be released.
- At that point, tax must be applied on the retained amount, and a retention release invoice is required.
Invoice | Amount | Retention | Net Amount | Tax | Invoice Total |
|---|
M1 (10%) | 100,000.00 | 10,000.00 | 90,000.00 | 5,400.00 | 95,400.00 |
M2 (40%) | 400,000.00 | 40,000.00 | 360,000.00 | 21,600.00 | 381,600.00 |
M3 (40%) | 400,000.00 | 40,000.00 | 360,000.00 | 21,600.00 | 381,600.00 |
M4 (10%) | 100,000.00 | 10,000.00 | 90,000.00 | 5,400.00 | 95,400.00 |
Subtotal | | | 900,000.00 | | 954,000.00 |
Retention Claim | | | | | |
Claim | | | 100,000.00 | 6,000.00 | 106,000.00 |
Questions:
- What is the recommended NetSuite approach to manage milestone billing with retention deduction and tax only on the net amount?
- Should retention be handled using custom fields + revenue recognition, or is there a native feature/workaround that supports retention for Accounts Receivable?
- How do others normally configure the retention release invoice to trigger tax correctly at the time of release?
- Is there any best practice for reporting retained amounts and outstanding retention balance across projects?
Would appreciate any guidance, setups, workflows, or SuiteScript options that have worked well for similar construction/engineering project billing models. Thanks!