WIP realization reporting tells you whether the hours your firm puts into a file actually become billed revenue. Most Canadian accounting firms have a version of this problem: a client file consumed 40 hours of senior staff time, the bill went out for 20, and the write-off got buried in the year-end work papers.

That gap is not a minor leak. Across a 10-person firm, it can easily cost six figures in lost billing per year. It hides in uncategorized bank feeds, manual timesheet entries, and stale unbilled WIP that nobody opens until the file closes.

The fix starts with understanding the numbers and then building a review routine around them. If you have not yet standardized client intake, start with our guide to CPA firm onboarding software, because billing expectations begin at intake. Many firms also centralize client files in Awditify for accounting firms so the WIP data stays current between partner meetings.

Table of Contents

What WIP and Realization Reporting Actually Measure {#what-wip-and-realization-reporting-actually-measure}

WIP (work in progress) is the time and cost accumulated on a client engagement before a bill is issued. Realization is the percentage of that WIP that turns into billed revenue, and then into cash collected. Together, these two concepts form the core of firm profitability.

The common confusion is between billing realization and collection realization. Billing realization compares the hours you wrote off to the hours you worked. Collection realization compares the cash you received to the amount you billed. A firm can show a healthy billing realization and still lose money if the client never pays. You need both numbers on the same report.

The table below shows the four metrics that matter most, what they measure, and the warning sign to watch for.

| Metric | What it measures | Formula | Warning sign | | WIP balance | Unbilled time and expenses on open engagements | Sum of time entries plus out-of-pocket costs not yet billed | WIP aging over 60 days for recurring clients | | Billing realization | How much of the standard value of worked hours was billed | Billed fees divided by (worked hours times standard rate) | Realization below 80 percent on fixed-fee files | | Collection realization | How much of the billed value was collected | Cash collected divided by billed fees | Steady decline while WIP stays flat | | Effective rate | Blended rate actually earned per hour | Billed fees divided by worked hours | Rate drops when block billing replaces careful time capture |

Each metric answers a different question. The WIP balance tells you how much unbilled value is sitting in the firm. Billing realization tells you whether your pricing decisions are holding up. Collection realization tells you whether your follow-up process works. The effective rate tells you whether your staff are working on the right clients at the right rates.

In Canadian accounting practice, WIP appears on the balance sheet as an unbilled receivable or a work in progress asset. Under ASPE, you can value it at cost, but if you cannot reliably estimate the eventual revenue, you may need to write it down. That write-down is effectively a realization loss that hits the income statement before you have even sent the bill. Accurate time capture is therefore not just an operational preference; it is a balance sheet issue.

For Canadian firms, these numbers matter at tax season, when CRA deadlines force staff to work evenings and weekends. If the hours go into a fixed-fee file that was quoted before the scope grew, the realization rate will fall. The same file, billed under a time-and-materials arrangement with a clear engagement letter, would have held its margin. The difference is almost always visible in the WIP report before it is visible in the income statement.

Where Canadian Firms Lose Revenue in the WIP-to-Cash Cycle {#where-canadian-firms-lose-revenue-in-the-wip-to-cash-cycle}

Revenue disappears at specific points in the engagement lifecycle. Most of the loss is avoidable, but you need to see it first. The most common leakage points show up repeatedly in firms that have not automated their time and billing workflow.

Common leakage points include:

  • Manual timesheet entry that misses non-billable work actually attributable to a client, such as calls with the CRA on a client's file.
  • Unbilled expenses like travel, courier, and disbursements that fall through the cracks because they were recorded as overhead.
  • Progress billings that are sent late on long engagements, pushing revenue past year-end and delaying the GST/HST remittance.
  • Write-offs made quietly at the billing stage instead of being flagged for partner review.
  • Fixed-fee files where scope creep is never renegotiated, so the extra hours are simply absorbed.

The Canadian detail makes progress billings especially delicate. If you bill a client on a milestone basis, each invoice may create a GST/HST obligation at a different time, and the input tax credits have to match the expenses you actually incurred. A firm with clients in British Columbia also needs to handle PST on certain fees, and a firm with Quebec clients has to reconcile QST separately. When the billing process is manual, these obligations are easy to miss, and the mistake shows up in both the WIP report and the GST/HST return.

Payroll also plays a role in WIP accuracy. When a firm runs payroll through a generic provider, the salary cost for a staff member is not attached to the client files they worked on. That makes it impossible to calculate the gross margin on a fixed-fee engagement. Canadian payroll calculations with CPP, EI, and income tax need to connect to the same cost data that feeds the WIP balance. If the payroll system and the practice management system are separate, the margin analysis will always be incomplete.

Consider a 12-person contractor firm in Ontario that does year-end compilations and notice to reader engagements. The partners rely on fixed fees. After a busy season, the WIP report shows $180,000 in unbilled time. An aging report reveals that $70,000 of that time belongs to files closed in the previous quarter. The partner remembers that the draft bills were sent, but approval sat in an inbox, and no one followed up. At year-end, that $70,000 becomes a write-off, and the firm has already paid salaries on it.

The cause is almost never a single bad decision. It is the absence of a routine. When WIP is reviewed only at year-end, small gaps turn into large write-offs. The firm that reviews WIP monthly can bill while the work is still fresh, can push back on scope creep before it becomes a problem, and can identify a client that should be repriced at renewal.

Municipal finance teams face a related version of this issue. Under PSAB, tangible capital assets and deferred revenue need to be tracked separately from operating funds. If a municipality's property tax billing and utility billing sit in separate systems, the WIP equivalent is the unbilled levy or the unapplied payment. The reporting burden lands on the finance department, and the realization problem becomes a cash flow problem for public services. The same discipline of reviewing aging, matching payments, and billing on schedule applies to a levy cycle as much as to a client engagement.

How to Read WIP Realization Reports Like a Partner {#how-to-read-wip-realization-reports-like-a-partner}

A WIP realization report is not a single number. It is a set of signals that point to the next conversation you need to have. Start with the firm-wide realization rate, then drill into service line, partner, and client.

The report should show both billing realization and collection realization at each level. If you only look at billed fees, you miss the clients who will not pay. If you only look at cash, you miss the write-offs that happened before the bill was issued. The most useful reports pair WIP aging with realization rates by client.

Here is what a partner should look for when the report lands:

  • Clients with WIP older than 90 days and no recent activity.
  • Engagements where hours exceed the original estimate by more than 15 percent.
  • Staff whose write-off rate is consistently higher than their peers.
  • Fixed-fee files where realization dropped after the second year.
  • Expenses that were recorded but never billed back.

The biggest error is to look only at the firm-wide number. A firm-wide realization rate of 85 percent can hide one partner at 65 percent and another at 95 percent. The partner at 65 percent is absorbing scope creep because the engagement letter did not define the boundaries clearly enough. Averaging gives you a warm feeling and no action plan.

Timing matters too. Compare monthly and quarterly trends, not just the year-end number. A seasonal firm in Canada wraps up a large volume of work after January 31 for sole proprietors, then again after April 30 for trusts, and after June 15 for certain international filings. If you review realization only in December, you miss the pattern that repeats every tax season.

A good report also ties WIP to billing schedules. For fixed-fee engagements, the billable hours should be compared to the percentage of the work completed. For hourly engagements, the WIP balance should move in step with the remaining budget. When those two lines diverge, something is wrong in the estimate, the time capture, or the billing rules.

Collection realization deserves the same attention as billing realization. A client that pays at 120 days is effectively paying less than the invoice amount because of the delay. When interest rates are high and borrowing costs are real, the time value of money turns a 30-day payer into a better client than a 120-day payer with the same rates. Many Canadian firms now include days sales outstanding (DSO) alongside WIP and realization in the partner pack.

The partner meeting should spend five minutes on exceptions, not twenty minutes reading every line. Pull the ten clients with the highest WIP, the three partners with the biggest write-offs, and the five fixed-fee files where realization has declined for two consecutive quarters. That is enough to decide whether a client needs a new pricing structure or a staff member needs better guidance on time coding.

Building a Realization Improvement Workflow {#building-a-realization-improvement-workflow}

The goal is to make WIP review a habit, not a fire drill. The workflow has three stages: capture time accurately, review WIP weekly, and bill on a schedule.

The manual version of this workflow is familiar. A bookkeeper exports timesheets, an admin person keys them into a spreadsheet, and a manager reconciles the spreadsheet against the accounting system on the last Friday of the month. If a partner forgets to submit a timesheet, the WIP report is wrong a month later. If an expense is entered without a client code, it stays in overhead and becomes a realization loss.

The automated version works differently. With Awditify, bank feeds pull in transactions, AI transaction categorization suggests the client and expense account, and the time entry sits next to the WIP balance in real time. When the work is done, the draft bill is ready with the GST/HST calculated automatically. The report is available on Monday morning, not Thursday after the reconciliation. You catch the missing expense, the written-off hour, and the overdue progress billing while they are still small.

Here is a practical sequence for a firm that wants to improve realization:

  1. Set a realization threshold for each service line, such as 85 percent for compilations and 90 percent for consulting.
  2. Require that WIP over the threshold be reviewed at the weekly team meeting.
  3. Make write-offs require a second approval, so a partner cannot quietly absorb a scope change.
  4. Send progress bills on fixed-fee files at set milestones, not when the partner remembers.
  5. Track realization by partner and by client in the monthly management report, with the same level of attention as revenue.

The Canadian detail is the billing itself. If you bill a trust in Quebec, you need to know whether QST applies. If you bill a municipality, the invoice may have to match a purchase order and the remittance cycle. The workflow has to accommodate those constraints without letting them delay the bill. A platform that tracks Canadian taxes and supports municipal billing reduces the friction that causes late invoices.

Once the workflow is in place, the reporting tool makes the review faster. The Awditify Help Center shows how to use reports, including how to filter WIP by client and engagement. You can also set up deferred revenue tracking for engagements that span multiple periods, which matters when a retainer comes in before the work is done. The revenue recognition walkthrough explains how to automate the journal entries instead of reversing them manually.

Why a Purpose-Built Canadian Platform Beats Spreadsheets and Legacy Tools {#why-a-purpose-built-canadian-platform-beats-spreadsheets-and-legacy-tools}

A spreadsheet can track WIP, but it cannot fix the cause. The cause is usually time captured in the wrong place, expenses sitting in uncategorized bank feeds, and draft bills waiting in someone's outbox. A legacy desktop system built for a US market often lacks Canadian payroll integration, GST/HST tracking, and PSAB-aware reporting for municipal teams. When you export a CSV to a spreadsheet and rekey it every week, you create a new source of error.

The distinction between tools matters at busy season. A generic time and billing add-on records hours, but it does not automatically match an expense from a bank feed to a client file. It does not know that a payment from a client should reduce the WIP balance and the accounts receivable at the same time. It certainly does not know that a write-off has to be approved by a partner to keep the audit trail clean.

Awditify combines practice management, bookkeeping, and Canadian payroll in one platform. Time entries flow into WIP. Expenses from bank feeds get categorized automatically. Invoices carry the correct GST/HST. The audit trail shows exactly who changed a write-off and when. For CPA firms, this means the WIP report is not an afterthought; it is the same data used to close the books.

Data integrity also matters for the audit trail. When a write-off is entered directly in a spreadsheet, there is no record of the approval. In a platform built for accounting firms, the write-off can require a partner's electronic sign-off, and the system logs the change with a timestamp. That level of control is what makes realization reporting defensible, whether the reviewer is a partner, a lender, or a practice inspector.

Many Canadian CPA firms centralize client work in Awditify for accounting firms and then use the same reports for WIP, realization, and client profitability. When you also need one view of every client, our guide to accounting client management software covers the broader decision. And if you are evaluating tools heading into tax season, the 2026 comparison of tax workflow software for Canadian accountants is a useful next step.

Municipal finance teams get the same benefit from a different direction. The platform handles property tax billing and utility billing, which are often the two largest sources of unbilled revenue in a city's books. You can see the WIP-like balance between bills issued and cash received in the same dashboard that tracks PSAB reporting. That direct link between operational billing and financial reporting is hard to achieve with a spreadsheet and a stand-alone billing system.

Frequently Asked Questions {#frequently-asked-questions}

What is wip realization reporting?

WIP realization reporting tracks the difference between the hours and expenses you accumulate on a client engagement and the revenue you actually bill and collect. It combines work in progress (WIP) balances with realization rates, which measure how much of that work turned into revenue. For Canadian accounting firms, this reporting identifies which files are profitable and which ones are quietly losing money. Without it, partners rely on memory and year-end surprises.

How do you calculate realization rate?

Billing realization is calculated by dividing the fees you billed by the standard value of the hours you worked. For example, if you worked 10 hours at a $200 standard rate and billed $1,600, your billing realization is 80 percent. Collection realization divides cash collected by the amount billed. You should track both, because a high billing realization with slow collections still hurts your cash flow.

What is a good realization rate for an accounting firm?

A common benchmark for Canadian accounting firms is 85 to 90 percent for billing realization, but the right target depends on your service line and pricing model. Fixed-fee compilation work often lands below 90 percent, while ad-hoc consulting and tax planning should be higher. The more useful number is the trend by partner and client, not a single firm-wide target. If a client is consistently below your threshold, the engagement letter likely needs to be rewritten.

How do I improve WIP realization?

Start by reviewing WIP aging every week and billing on a fixed schedule. Set a realization threshold and require management approval for any write-off above it. Train staff to code time and expenses accurately at the point of entry, and use bank feeds to catch uncategorized charges before they disappear. Most firms improve realization by 5 to 10 points in the first year simply by making WIP review a recurring agenda item.

What software does wip and realization reporting well?

Awditify handles WIP realization reporting natively for Canadian accounting firms. Time entries, expenses, bank feeds, and invoices live in one system, so the WIP balance updates in real time and the realization report reflects actual data instead of a spreadsheet that went stale. The platform also tracks GST/HST and Canadian payroll, which keeps the numbers Canada-accurate. You can see the report per client, per partner, or per service line without exporting data.

What to Do Next {#what-to-do-next}

WIP realization reporting only works if the data underneath it is accurate. Review the WIP aging weekly, set thresholds for write-offs, and compare realization by partner and client every month. The firms that close the revenue gap are the ones that treat WIP as a live operational metric, not a year-end curiosity.

Awditify brings the time, expenses, bank feeds, and invoices into one Canadian platform, so the report you look at in the morning is the same data your bookkeeper reconciled yesterday. If you are ready to stop leaving revenue on the table, see how Awditify for accounting firms works. You can also book a demo and walk through your WIP file with someone who knows Canadian accounting.