How to Track Architecture Design Fees by Phase in a Spreadsheet

Architecture and design contracts rarely bill as one lump sum — fees split across schematic design, design development, construction documents, and construction administration. Cash flow problems start when you cannot see billed vs. remaining per phase on active projects. A free design fee tracker spreadsheet maps contract fee, phase allocation, billed to date, and remaining for every job.

Allocate the contract fee across phases first

Before billing, split total fee by phase percentages your contract uses — common patterns:

• Schematic design — 15–20%
• Design development — 20–25%
• Construction documents — 35–40%
• Construction administration — 15–20%

Each phase row shows allocated amount, amount billed, and balance. When a phase completes, the remaining column tells you exactly what is left to invoice.

Bill on milestones, not calendar guesses

Tie invoices to deliverables: SD package issued, DD sign-off, permit set submitted. Log each invoice row with date, phase, and amount. Add services and reimbursables get separate lines so base fee math stays clean.

Watch remaining fee before scope expands

Client requests outside the contract should appear as add-service rows with fee and billing status — not silent hours that erode margin. Pair fee tracking with project profitability when labor burn matters alongside contracted fee.

Interior studios tracking FF&E separately should use the interior design budget tracker for product pass-throughs; this sheet is for professional design fee on the architecture side.

When AIA billing software replaces the sheet

Integrated time, invoicing, and percent-complete billing at multi-office scale need dedicated tools. Small firms with three to ten active contracts often run fee phases in a sheet until AR volume and audit requirements demand ERP integration.

These templates are fee tracking tools, not licensed contract documents. Verify billing terms with your attorney and contract templates.