Project-based firms lose track of receivables because AR data lives inside individual project files rather than in one consolidated view, so no one sees the full picture until cash gets tight. Each project manager can be doing a competent job tracking their own project's billing status and the firm can still have no reliable answer to a simple question: what does receivables look like across the whole portfolio right now?
Why Project-Level Tracking Hides the Full Picture
Architecture and engineering firms are organized around projects, and their financial tracking habits typically follow that same structure. Each project has its own budget, its own schedule, and often its own record of what has been billed and collected, sometimes in a project management tool, sometimes in a spreadsheet the project lead maintains independently. That structure works well for delivering the work. It works poorly for understanding receivables, because the firm's actual financial exposure is the sum of dozens of these individually maintained records, and nobody is looking at the sum.
Research on financial management for AEC firms from Total Synergy describes this pattern directly: revenue leakage happens quietly, hours get logged late or not at all, small amounts across multiple projects add up to significant losses over the course of a year, and when financial reporting only arrives as a monthly summary after the fact, there is no opportunity to course correct while the problem is still small. A firm with fifteen active projects, each individually a few days behind on billing, does not look like a crisis on any single project file. Rolled up across the portfolio, it is a meaningful cash flow problem hiding in plain sight.
Consolidating AR Across Concurrent Projects
The fix is not asking project managers to become better bookkeepers. It is separating two things that most firms conflate: tracking a project's delivery status, which belongs with the project manager, and tracking the firm's aggregate financial exposure, which needs its own consolidated view independent of any single project file.
This distinction matters because AR aging and work in progress aging are not the same report, and firms that only watch one are missing half the picture. AR aging shows invoices that have already been sent and are waiting on payment. Work in progress aging shows work that has already been completed but has not been invoiced at all yet. Revenue optimization research from project management platform Monograph found that many firms watch AR aging closely while effectively ignoring WIP aging, even though unbilled WIP represents exactly the same financial exposure, it simply has not been converted into an invoice yet. A consolidated view has to show both, side by side, for every active project, or a firm can look financially healthy on paper while sitting on weeks of quietly unbilled work.
How that unbilled work turns into an actual invoice on a reliable schedule, rather than depending on someone remembering to generate it, is covered in Milestone Billing for Architecture Firms: A Phase-by-Phase Guide.
What a Weekly Portfolio-Wide AR View Looks Like
A useful consolidated view does not need to be complicated. It needs to answer the same four questions for every active project, reviewed on the same day every week, rather than scattered across individual project files that only get opened when something goes wrong:
- What phase is each project in, and has that phase's invoice actually been generated? This catches the gap between delivery tracking and billing tracking before it ages.
- How much unbilled work in progress exists on each project, and how long has it been sitting? Guidance on WIP management for AEC firms notes that firms reviewing this weekly catch problems while the work is still recent and easy to bill, rather than after it has aged into an uncomfortable conversation.
- Which sent invoices are approaching or past their due date? This is standard AR aging, but it only has value when reviewed alongside the WIP figure above rather than in isolation.
- Which projects, in total, are trending toward being cash negative once billed and incurred amounts are compared? This is the portfolio level signal that something needs attention beyond a single missed invoice, covered in detail in How to Calculate Which Projects Are Actually Cash Positive.
None of this requires new project management software for most firms. It requires pulling the same four data points, from wherever they already live, into a single weekly view reviewed by someone whose responsibility explicitly includes reading it. That habit, more than any tool, is what separates firms that catch billing drift early from firms that discover it during a slow quarter, once it has already become a write-off.
Frequently Asked Questions
Why do project-based firms lose track of receivables?
Project-based firms lose track of receivables because AR data lives inside individual project files rather than in one consolidated view, so no one sees the full picture until cash gets tight.
What is the difference between AR aging and WIP aging?
AR aging tracks invoices that have already been sent and are waiting on payment, while WIP aging tracks work that has already been completed but not yet invoiced at all. Many firms watch AR aging closely while ignoring WIP aging, even though unbilled WIP represents the same financial exposure before it has been converted into an invoice.
How often should an AEC firm review AR across its full project portfolio?
A weekly review across every active project is generally the right cadence, since it catches a slipping invoice or an aging unbilled balance while it is still a routine fix, rather than after it has aged into a difficult collection or a write-off.
