Technology and AI
Choosing Project and Accounting Software for an Engineering Firm
Choosing project and accounting software for an engineering firm starts from the reports the partners need each week, not from feature lists. The choice that matters most is how the numbers move between systems, so that each one is entered once.
On this page
Terms Used
- ERP: enterprise resource planning, one system that holds time, projects, billing and accounting together.
- Percent complete: how much of a phase’s work is done, used to bill fixed fees and to compare hours against fee.
- Integration: a link that moves data from one system to another without retyping, built in, through a connector or by a regular export.
- Migration: moving projects, rates and balances from the old system into the new one.
Start from the Reports
Software choices usually start with feature lists. A better start is the handful of reports the partners need every week and month (see engineering firm KPIs). Work back from those to the data each one needs and where it is entered. The software is whatever produces those reports with each number entered once.
| Report | Data it needs | Entered where, and by whom |
|---|---|---|
| Utilization by person | Hours by person, billable or not | Timesheets, by everyone, weekly |
| Hours against fee on every live project | Hours by phase, fee by phase, percent complete | Timesheets; the fee at set-up; percent complete by the project manager |
| Unbilled work | Hours and costs not yet invoiced | Timesheets and expenses, against invoices |
| Receivables | Invoices sent and payments received | Billing and accounting |
| Backlog and pipeline | Signed fees not yet earned; pursuits and their chances | Contracts at set-up; the pursuit list |
Read down the last column. Where the same number appears in two places, such as hours typed into a timesheet tool and again into billing, the systems need a link or need to be one system.
One System, or Several Linked
There are two common shapes:
| Shape | One system for time, projects and billing | Several systems, linked |
|---|---|---|
| Examples | Systems built for architecture and engineering firms, such as Deltek Vantagepoint, Deltek Ajera or BQE Core | A time and project tool, an accounting package, a CRM |
| Strength | One set of project numbers, reports designed for A/E firms | Each tool can be the best fit for its job; easier to change one part |
| Weakness | A larger change to make at once; the firm adapts to the system | Only as good as the links; without them, hours are retyped |
Either can work for a small firm. What fails is the third shape, and it is common: several systems that do not talk to each other, joined by spreadsheets and retyping.
Questions to Ask Every Vendor
- Can it hold our project structure: projects, phases, tasks, and both fixed-fee and hourly work?
- Does it show hours against fee and percent complete by phase, weekly?
- Can it produce our invoices from timesheets, by percent complete and by milestone, with GST/HST?
- Does it connect to our accounting and payroll, and how: built-in, through a connector, or by export?
- Can our people enter time on a phone, quickly?
- How are rates by role, overhead and multipliers handled?
- Who can see what: can a project manager see their projects’ numbers without seeing salaries?
- Where is our data stored, and can we keep a complete copy in Canada?
- Can we get all our data out, in a usable form, if we leave?
- What does setup include, and who moves our open projects?
Test It on Your Own Month
Before signing, run a real month through it: your own projects, last month’s timesheets and the invoices you actually sent. A demonstration with sample data shows the software at its best. Your own month shows whether it fits your firm. A useful test has three parts:
- Set up three live projects as they really are: one fixed fee, one hourly, one with phases.
- Enter last month’s hours for the people on them, the way your people would.
- Produce last month’s invoices and the weekly hours-against-fee report, and compare them with what you actually sent and knew.
Where the numbers differ, find out why before you sign.
What a Switch Really Costs
The subscription is the visible cost. The larger one is usually people’s time: deciding the structure, moving open projects, training, and checking the first month’s reports. Count it in hours before comparing prices.
| Example, round numbers: a firm of 12 | Hours |
|---|---|
| Deciding project numbering, phases, task codes and rates | 40 |
| Setting up and checking open projects | 60 |
| Training, 12 people × 4 hours | 48 |
| Checking the first month’s reports against the old ones | 20 |
| Total | 168 |
In this example, at a salary cost of $60 an hour, the switch costs $10,080 of people’s time (168 × 60) before the first licence is paid, and more if those hours would otherwise have been billed. Your own estimate replaces these figures; the point is to count the hours at all.
Plan the Switch
- Decide the structure first. Project numbering, phases, task codes and rates, written down before setup.
- Move open projects only. Closed projects can stay in the old system for reference.
- Start at a clean point. The start of a month or a financial year.
- Run both for one cycle. Produce one month’s invoices from both systems and compare them before the old one is retired.
- Train for the same habits. Everyone enters time the same way, or the reports mean nothing.
Plan for months, not weeks, and expect the first month’s reports to need checking.
Keep the Old Records Readable
Retiring the old system does not retire its records. The Canada Revenue Agency says: “Generally, you must keep all required records and supporting documents for a period of six years from the end of the last tax year they relate to” (Canada Revenue Agency, keeping records). The same page sets out when that is longer: a late-filed return, or a CRA official asking for more time. It also says records are kept “at your place of business or your residence in Canada” unless the CRA gives written permission otherwise, and that records kept outside Canada and accessed electronically from Canada are not considered kept in Canada.
So before the old subscription ends, read that guidance with your accountant, then export the timesheets, invoices and project records into a form the firm can still open, kept where the guidance allows, or keep read-only access that meets it. Ask the same question of the new system: where its data is stored. Project files may need keeping longer still under the firm’s contracts and quality system.
Keep What You Have, if It Works
Sometimes the right answer is to keep the systems and link them. If the firm already has a good time tool and accounting package, a reliable connection between them, plus one report built from both, may give the partners what they need for far less disruption. The test is the same as for a new system: run a month through the link and check the reports.
A Checklist Before You Sign
- List the weekly and monthly reports the partners need.
- Mark where each number is entered today, and where it is entered twice.
- Choose the shape: one system, or several linked.
- Ask every vendor the questions above, in writing.
- Run a real month through the finalist.
- Count the switch in hours, not only the subscription.
- Plan how the old records stay readable.
How We Approach This
We link time, projects, accounting and client records, so nothing is keyed twice, and build a dashboard of the numbers that matter, as part of our software work. We resell no one’s software.
Questions
What Is the Best Project Management Software for Engineering Firms?
The one that gives your partners their weekly numbers without anyone retyping hours. Systems built for architecture and engineering firms include Deltek Vantagepoint, Deltek Ajera and BQE Core; other firms link general project and time tools to their accounting.
Do Engineering Firms Need an ERP?
An ERP joins time, projects, billing and accounting in one system. A small firm can get the same view by linking a few systems well. The test is whether hours are entered once.
How Long Does Switching Take?
Plan for months, not weeks: deciding the structure, setting up and checking open projects, training people to enter time the same way, and checking the first month’s reports.
Who at the Firm Should Own the Choice?
A partner who reads the weekly reports, with the person who runs billing. Project managers should test it on their own projects before anyone signs, because their habits decide whether the numbers are right.
Can We Keep Our Accounting Package and Add a Project System?
Yes, if the two are linked so hours and invoices move between them without retyping. Run a real month through the link before relying on it.
Sources
Updates
- : Rewritten at full length: a table of reports and where their data is entered, more vendor questions, a three-part test on your own month, what a switch costs in hours (worked example), running both systems for one cycle, keeping old records readable and where the CRA allows (CRA read), and a checklist.