How do I set up vertical accounting services for booking progress billing in a real estate operator?

Setting up vertical accounting services for progress billing in a real estate operator usually means designing an accounting process that tracks costs and invoices by property, project, phase, or unit so you can bill customers or tenants based on completion milestones, percentages, or work-in-progress.

Here’s a practical setup approach.

1) Define the billing model

First identify which type of progress billing you need:

• Construction/development projects: bill by milestone or percent complete
• Tenant improvement / fit-out: bill based on completed work stages
• Management or consulting services: bill based on monthly progress or deliverables
• Sale of units off-plan: bill by deposit and construction milestones

For each, define:

• billing trigger
• billing frequency
• retention rules
• approval workflow
• documentation required

2) Set up vertical accounting dimensions

Use accounting dimensions to track transactions by business line and property hierarchy.

Typical dimensions:

• Legal entity
• Property / asset
• Project
• Phase / tower / building
• Unit
• Cost code / work package
• Vendor / contractor
• Customer / tenant

This lets you produce:

• project P&L
• property-level profitability
• WIP schedules
• progress billing aging
• budget vs actual reports

3) Create a chart of accounts that supports WIP and billing

Add accounts for:

Balance sheet

• Construction in progress (CIP)
• Work in progress asset
• Contract asset
• Billings in excess of costs
• Retainage receivable
• Retainage payable
• Customer deposits / advances

Revenue and expense

• Progress billing revenue
• Development income
• Management fee income
• Cost of sales / project costs
• Capitalized development costs
• Operating expenses

Make sure your accounting policy distinguishes:

• capitalizable costs
• period expenses
• billable costs
• non-billable costs

4) Build a project budget and cost code structure

Before billing starts, set up:

• master budget by project
• cost codes by trade or activity
• committed costs
• approved change orders
• contingency reserve

This supports percent-complete calculations and revenue recognition.

5) Define percent-complete logic

Choose how progress is measured:

• Cost-to-cost: actual costs incurred ÷ total estimated costs
• Milestone-based: based on approved completion stages
• Units completed: number of units finished ÷ total units
• Physical inspection: engineer/PM certification
• Hybrid: milestones plus cost-to-cost

Pick one primary method and document it in accounting policy.

6) Design the invoicing workflow

A standard workflow looks like this:

1. Project manager submits progress claim
2. Quantity surveyor / operations reviews completion
3. Finance checks contract terms and retainage
4. Invoice is generated
5. Revenue and receivable are posted
6. Collections and cash application follow

Include:

• supporting schedule
• approved certificate
• change-order adjustments
• retainage calculation
• taxes/VAT treatment

7) Record the accounting entries properly

A typical progress billing flow:

When costs are incurred

• Dr Construction in progress / project cost
• Cr AP / cash

When invoice is issued

• Dr Accounts receivable
• Cr Billings / progress billing revenue

For revenue recognition under percentage of completion

• Dr Contract asset or WIP
• Cr Revenue
• Dr Cost of sales
• Cr CIP or project cost clearing

The exact entry depends on your accounting standard and whether billing exceeds costs or vice versa.

8) Handle retainage and advances

Progress billing often includes:

• retainage: portion withheld until project completion
• advance payments: amounts received before work is performed

Set up separate tracking for:

• retainage receivable
• retainage payable
• customer deposits / advances
• release conditions

9) Use job costing and integration tools

For a real estate operator, the accounting system should integrate with:

• project management software
• procurement/PO system
• lease administration system
• fixed asset register
• AP/AR
• bank reconciliation
• document management

Recommended features:

• multi-entity support
• project/job costing
• budget controls
• approval workflows
• automated revenue recognition
• reporting by property and project

10) Create policies and controls

Document:

• who approves budgets and change orders
• who certifies completion
• invoice cutoff rules
• capitalization policy
• revenue recognition policy
• retention release procedure
• audit trail requirements

Controls to include:

• segregation of duties
• approval thresholds
• matching invoices to certified progress
• periodic reconciliation of WIP and billings
• monthly review of estimates-to-complete

11) Build reporting dashboards

Useful reports:

• progress billing by project
• WIP schedule
• cost-to-complete analysis
• budget vs actual
• gross margin by project/property
• AR aging and retainage aging
• unbilled revenue / contract asset report
• committed cost report

12) Consider system setup in your ERP

In your ERP, configure:

• project templates
• cost codes
• billing rules
• retainage terms
• revenue recognition schedules
• approval routing
• dimensional tagging
• standard journal templates

If you use software like NetSuite, Yardi, SAP, Sage, MRI, or Oracle, make sure the project accounting module supports:

• percentage completion
• progress invoicing
• WIP reconciliation
• retainage
• capitalization vs expensing

---

Example simplified setup

If you manage a mixed-use development, you could structure:

• Entity: Real Estate Operator LLC
• Property: Downtown Mixed Use
• Project: Tower A Construction
• Phase: Structural / MEP / Finishes
• Cost codes: labor, materials, subcontractors, permits
• Billing method: monthly cost-to-cost with 10% retainage

Then monthly:

• gather certified costs
• compute percent complete
• determine allowable revenue
• issue progress invoice
• update WIP and contract asset/liability

---

Recommended next step

If you want to implement this cleanly, start with these 5 deliverables:

1. Accounting policy memo
2. Chart of accounts and dimensions
3. Billing and revenue recognition workflow
4. WIP and retainage schedule template
5. ERP configuration checklist

If you want, I can also give you:

• a sample chart of accounts for progress billing in real estate,
• a month-end journal entry example,
• or a step-by-step setup in NetSuite/Yardi/Sage.