How QualpRo Eliminated Spreadsheet Dependency and Gained Full Financial Control with D365 Finance

LocationCanada

SolutionD365 Finance & Operations

Zero

Spreadsheet dependency from day-one go-live

44%

Faster audit preparation cycle

$180K

Revenue restatement risk fully resolved

At-a-Glance

QualpRo - a Canadian quality assurance and testing services firm that grew from 20 to 60 staff over 3 years on a QuickBooks and 14-spreadsheet financial infrastructure.

Case Study

CHALLENGE:

A critical formula error in their FY2022 Excel revenue model caused a $180K misstatement discovered during audit. The CFO classified the entire spreadsheet architecture as the firm's single greatest operational risk.

SOLUTION:

Intelegain deployed D365 Finance with audit-trail configuration, ASPE-compliant revenue recognition, CRA T2 tax reporting, full QuickBooks data migration, and locking of all 14 Excel workbooks.

RESULTS:

Zero spreadsheet dependency from go-live, 44% faster audit preparation, 100% elimination of manual formula-based financial models, $180K restatement risk resolved.

The Challenge: When the Spreadsheet Becomes a Liability

QualpRo's financial infrastructure looked reasonable when the company had 20 people. QuickBooks handled accounts payable, receivable, and payroll. A small set of Excel workbooks handled revenue tracking and management reporting. It was manageable because the volume was low and the people running it knew every formula by hand.

Then the company grew - fast. Over three years, QualpRo's headcount tripled from 20 to 60 staff, their client roster expanded, and the complexity of their service contracts increased. But the financial infrastructure didn't scale with them. Instead, new workbooks got added to patch gaps. By the time the CFO initiated the ERP evaluation, there were 14 interconnected Excel workbooks underpinning QualpRo's financial operations, with dependencies between files that only two people in the company fully understood.

The breaking point came during the FY2022 audit. The external auditors identified a formula error in the primary revenue recognition workbook - a cell reference that had broken when a new service line was added mid-year. The error had propagated silently through the interconnected workbooks for eight months before being caught. The resulting $180,000 revenue misstatement required a restatement, additional audit hours, and a formal management letter that the CFO described as professionally the worst experience of his career.

$180K revenue misstatement

caused by a broken Excel formula that went undetected for 8 months - a direct consequence of the spreadsheet architecture

14 interconnected workbooks

with cross-file dependencies that only two people fully understood - an institutional single point of failure

QuickBooks growth ceiling

- QuickBooks could not handle QualpRo's project-based billing complexity, multi-contract revenue structures, or the reporting requirements of their bank's covenant monitoring

No audit trail

- spreadsheet edits left no system record. The auditors could not determine when the formula error was introduced or who had last modified the affected cell

CRA T2 tax reporting

was being prepared manually from Excel outputs, creating an additional reconciliation step with no automated validation against general ledger balances

Why QualpRo Chose Intelegain

QualpRo's CFO was clear about what he was buying: audit readiness, not just accounting software. The ERP evaluation was driven by three non-negotiable criteria, all shaped directly by the FY2022 audit experience.

SME-to-mid-market D365 implementation experience:

QualpRo wasn't a large enterprise buying an enterprise ERP. They needed a partner who had taken companies of their size - 50-100 staff, project-based billing, growing complexity - through a D365 Finance migration without over-engineering the solution. Intelegain's track record in this specific segment was the differentiator that separated them from larger partners whose minimum engagement sizes would have been impractical.

Audit-readiness as a first-class requirement:

Most ERP partners treat audit trail configuration as a standard feature. Intelegain treated it as a primary design constraint - configuring D365 Finance's audit trail, change logging, and period-lock controls specifically around the failure modes that had produced QualpRo's FY2022 restatement. The CFO reviewed Intelegain's audit configuration documentation before signing the contract.

Accelerated delivery commitment:

QualpRo's next audit cycle was imminent. A 6-month implementation timeline would have meant entering another audit on the same spreadsheet infrastructure. Intelegain committed to a Accelerated delivery timeline with specific milestone gates, and delivered against it.

Implementation: The Intelegain Approach

The 16-week timeline was tight but achievable because QualpRo's scope was well-defined. Intelegain ran the implementation in four structured four-week phases, with the QuickBooks migration and D365 configuration happening in parallel rather than sequentially - the approach that made the timeline possible.

Phase 1: Configuration Design & Audit Architecture

Designed QualpRo's D365 Finance configuration with audit readiness as the primary constraint. Established period locking rules, change log activation, and user security roles that prevent post-close period adjustments without controller approval. Mapped QualpRo's project billing structures to D365 project contract types. Defined the ASPE-compliant revenue recognition methodology for QualpRo's fixed-price and time-and-material service contracts. All configuration design was documented and reviewed with QualpRo's CFO and external auditors before build commenced.

Phase 2: QuickBooks Migration & CRA Tax Configuration

Migrated full transaction history from QuickBooks into D365 Finance - covering 3 years of AP, AR, payroll journals, and bank reconciliation history. Validated migrated balances against QuickBooks trial balances at the account level, with sign-off from QualpRo's CFO at each validation checkpoint. Configured CRA T2 corporate tax reporting templates with automated population from D365 general ledger accounts. Built the ASPE-compliant automated revenue recognition schedule, replacing the broken Excel workbook that had caused the FY2022 misstatement. During this phase, all 14 Excel workbooks were formally archived, access-locked, and documented as deprecated - a deliberate symbolic and practical step.

Phase 3: UAT, Finance Team Training & Controlled Go-Live

Ran a 2-week UAT cycle with QualpRo's 4-person finance team processing a full month of transactions in D365 Finance - AP, AR, expense claims, revenue recognition entries, and month-end close. Delivered role-specific training over 3 weeks, tailored to the CFO's analytical workflows and the finance team's day-to-day transaction processing. Go-live was executed as a clean cutover on the first day of a new financial month, with Intelegain on-site for the first full week post-go-live.

D365 Finance & OperationsFull Audit Trail & Change LoggingASPE Revenue RecognitionQuickBooks Data MigrationCRA T2 Tax ReportingPeriod Lock Controls

Measurable Results

Zero

Spreadsheet dependency from day one of go-live

44%

Faster annual audit preparation cycle

100%

Elimination of manual formula-based financial models