Why Small A/E Firms Can't Quit Spreadsheets

You already know the setup isn't great.

The project tracker lives in one Excel workbook. Timesheets are in another—or maybe a free app someone downloaded two years ago. The budget? That's a tab you update when you remember to. Invoices go through QuickBooks, but the hours feeding them come from a completely separate place, and half the time you're manually keying them in because nothing connects.

It works. Mostly. Until it doesn't—until you're spending your Friday night reconciling numbers so you can invoice on Monday, or until you realize a project has been running over budget for three weeks and nobody caught it because the data was spread across four different files.

You've probably looked at the tools that are supposed to fix this. You've seen BQE Core and Deltek on the trade show floor. Maybe you've sat through a demo or two. But the pricing is built for 50-person firms, the implementation takes months, and you're running a team of eight. You can't justify $30K a year and a six-month onboarding process just to stop using spreadsheets.

So you stay where you are. Excel and QuickBooks. It's not ideal, but it's yours and you know how it works.

We've spent the last year talking to small A/E firm owners in exactly this position. What we found is that the problem isn't that you haven't tried hard enough, and it isn't that you need a bigger budget for software. It's that nearly every tool on the market was designed for a different kind of firm, running a different kind of project.

The Mismatch Nobody Talks About

Most project management software was built for one of two industries: software development or general consulting.

Software teams work in sprints. Tasks are discrete, sequential, and estimable. A feature is either done or it isn't. Time is tracked against tasks, not phases. Agile methodology made this world legible to software—and that software became the template for everything that followed.

General consulting firms work in retainers and deliverables. Billing is mostly time-and-materials. Scope is loosely defined. Resources are fungible. The tools built for them reflect that flexibility.

Neither of those is how a civil or structural engineering project actually runs.

A/E projects are phase-based. Design, entitlement, CDs, CA—each phase has its own budget, its own deliverables, and its own billing milestone. You're tracking lump sum contracts against percentage-complete estimates. You're managing subconsultants with their own invoices that need to be reconciled before you can bill your client. You're dealing with submittal comment cycles that can blow your budget in a single round—and you found out about it at 95%, not at kickoff.

Time tracking in this world isn't about tasks. It's about figuring out which hours are billable, which phase they belong to, and whether you've already invoiced for them.

Invoicing isn't a downstream function. It's a judgment call—how much can we bill right now without blowing our client relationship, given where we actually are versus where the contract says we should be?

No Gantt chart tool was designed for that. No generic PM platform handles it well. And the enterprise tools that were purpose-built for A/E firms—the Delteks and BQEs of the world—require a six-month implementation, a dedicated admin, and a price tag that makes sense for a 200-person firm. Not a team of eight running everything through Excel and QuickBooks.

What "Spreadsheet Chaos" Actually Looks Like From the Inside

Here's what we hear from small firm owners, almost word for word:

The project tracker is in Excel. Timesheets are in a separate spreadsheet—or maybe a free time tracking app that doesn't connect to anything. The budget is in another tab. Invoices and payments are in QuickBooks, but the hours feeding those invoices come from somewhere else entirely, and someone has to manually bridge that gap every billing cycle. The project folder is in SharePoint, but only two people remember how it's organized. The contract amendments are in email.

Every Friday—or every time a billing deadline shows up—someone has to manually pull all of this together. They're chasing down hours that never got logged. They're rebuilding invoices from scratch because the last one was in a QuickBooks template that's since been modified. They're calculating percent complete based on vibes and a gut check, because nobody has a real-time view of budget burn.

This isn't disorganization. This is the natural result of using tools that weren't designed to work together, for a kind of work they weren't designed to support.

Beyond the dollars, there's the time. Principals who should be doing business development or design review are spending Friday afternoons reconciling spreadsheets. Project managers are becoming part-time billing administrators. Admins are drowning in data entry that no one has found a way to automate.

And underneath all of it is a quiet anxiety: how much time has gone unbilled? Are we actually profitable on this project? Do we even know?

Why "Just Get Better Software" Isn't the Answer (Yet)

Here's what makes this frustrating: the advice you hear is always "get a real PM tool." But the options available to a 5-to-20-person firm just don't fit.

You've seen the demos for BQE Core, Deltek Vantagepoint, Ajera. They're built for this industry—no question. But they're priced and scoped for firms five to ten times your size. You're looking at $15K–$30K a year, a months-long implementation, and a tool so deep that you need someone on staff just to manage it. That math doesn't work when you're a team of eight and the principal is also the PM, the BD lead, and the one fixing the printer.

So you look at the lighter tools—the Mondays, Asanas, ClickUps. They're affordable. They look great. But within a week you realize they don't understand phases, they can't handle lump sum billing, and time tracking is bolted on as an afterthought. They become, as one firm owner told us, "glorified spreadsheets."

That's not a failure of commitment. That's what happens when the tools don't match the work.

The Three Things That Actually Need to Work Together

After talking to dozens of small A/E firm owners, we've found that the firms who do get out of spreadsheet chaos share a common pattern. They're not necessarily using the best software. They're using software where three specific things work together seamlessly:

1. Time tracking that people actually use. This sounds obvious, but it's the root of everything. If time tracking is clunky—no mobile, too many clicks, hard to find the right project or phase—people stop doing it. And once time tracking breaks down, everything downstream breaks with it: billing accuracy, project profitability, workload planning. The single most important feature in any A/E firm tool isn't the dashboard or the reporting. It's whether your team will actually log their hours every day without being chased.
2. Billing that reflects how A/E contracts actually work—and talks to QuickBooks. Not time-and-materials-only. Not flat-rate invoicing. Billing that understands lump sum with percent-complete milestones, billing that can hold time against a phase budget and tell you when you're approaching the limit, billing that makes it easy to include subconsultant costs without rebuilding the invoice from scratch every time. And critically, it has to sync cleanly with QuickBooks—because that's where your accounting lives, and it's not going anywhere. The moment billing and accounting are out of sync, you're back to manual reconciliation. Firms that get this right typically cut their invoicing time by more than half.
3. Project visibility without manual assembly. The question principals ask most often isn't "what are my tasks this week." It's "where are we on this project, what have we billed, what's left in the budget, and are we going to be profitable when we close it out?" That question should have an answer that doesn't require opening four different tabs and doing math in your head. When you have it, you stop being reactive and start being able to manage scope conversations before they become scope crises.

When those three things work together—and only when they work together—do firms actually escape the spreadsheets.

What This Means for Your Firm

None of this means you need to overhaul everything immediately. The firms that make the cleanest transitions usually start small: pick one project and track it end-to-end in a new system before you migrate anything else. Get time tracking working first, before you touch billing. Prove the data is trustworthy before you let go of the backup spreadsheet. Keep QuickBooks exactly where it is—just make sure whatever you add actually connects to it.

The goal isn't to find perfect software. The goal is to find something where the workflow matches yours closely enough that people actually use it—and that plays nicely with QuickBooks instead of trying to replace it.

That standard turns out to disqualify most of the options on the market for small A/E firms. But it does exist.