Technology and AI

Choosing Project and Accounting Software for an Engineering Firm

Sam&Sain Co. · Published · Updated · 7 minute read

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.

ReportData it needsEntered where, and by whom
Utilization by personHours by person, billable or notTimesheets, by everyone, weekly
Hours against fee on every live projectHours by phase, fee by phase, percent completeTimesheets; the fee at set-up; percent complete by the project manager
Unbilled workHours and costs not yet invoicedTimesheets and expenses, against invoices
ReceivablesInvoices sent and payments receivedBilling and accounting
Backlog and pipelineSigned fees not yet earned; pursuits and their chancesContracts 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:

ShapeOne system for time, projects and billingSeveral systems, linked
ExamplesSystems built for architecture and engineering firms, such as Deltek Vantagepoint, Deltek Ajera or BQE CoreA time and project tool, an accounting package, a CRM
StrengthOne set of project numbers, reports designed for A/E firmsEach tool can be the best fit for its job; easier to change one part
WeaknessA larger change to make at once; the firm adapts to the systemOnly 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

  1. Can it hold our project structure: projects, phases, tasks, and both fixed-fee and hourly work?
  2. Does it show hours against fee and percent complete by phase, weekly?
  3. Can it produce our invoices from timesheets, by percent complete and by milestone, with GST/HST?
  4. Does it connect to our accounting and payroll, and how: built-in, through a connector, or by export?
  5. Can our people enter time on a phone, quickly?
  6. How are rates by role, overhead and multipliers handled?
  7. Who can see what: can a project manager see their projects’ numbers without seeing salaries?
  8. Where is our data stored, and can we keep a complete copy in Canada?
  9. Can we get all our data out, in a usable form, if we leave?
  10. 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:

  1. Set up three live projects as they really are: one fixed fee, one hourly, one with phases.
  2. Enter last month’s hours for the people on them, the way your people would.
  3. 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 12Hours
Deciding project numbering, phases, task codes and rates40
Setting up and checking open projects60
Training, 12 people × 4 hours48
Checking the first month’s reports against the old ones20
Total168

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

  1. List the weekly and monthly reports the partners need.
  2. Mark where each number is entered today, and where it is entered twice.
  3. Choose the shape: one system, or several linked.
  4. Ask every vendor the questions above, in writing.
  5. Run a real month through the finalist.
  6. Count the switch in hours, not only the subscription.
  7. 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.

Discuss Your Project

Topic

We read every application. If we can help, the first 30-minute video call is free. Or contact us.