This article applies to Aiwyn Practice.
This article explains how Aiwyn works out the Realization percentage on a draft invoice, what changes it, and why it can differ from realization figures elsewhere in Aiwyn.
Realization compares what you bill with what the work was worth
Realization is Invoice Amount divided by WIP Value, shown as a percentage.
- WIP Value is what the work on the draft was worth when it was recorded. For time, it is the hours logged multiplied by the billing rate resolved for the entry. The work code selects the rate type, the assigned rate card supplies the role rate, and a staff-specific rate overrides that role rate when one exists. For expenses, WIP value is quantity multiplied by cost per unit; expense mark-up is not added to WIP value.
- Invoice Amount is what the client will be asked to pay for the included time or expenses, excluding tax and custom fees.
- Write Up/Down is the difference between the two. A negative figure is a write-down and a positive figure is a write-up.
For example, a draft with a WIP Value of $2,000 that bills $1,800 shows a Write Up/Down of −$200 and realizes 90%. Tax is not part of the calculation. When there is no WIP and WIP Value is zero, Realization does not display because there is no WIP value to use as the denominator.
Realization measures the billing decision, not the timesheet
Logged hours tell you how much work was done. Realization tells you how much of that work's recorded value the firm turned into fees. Every amount change moves it, and the percentage recalculates when the change is saved. The original time entries remain unchanged.
New WIP starts at 100%
When WIP is put on a draft, each included entry starts with an Invoice Amount equal to its WIP Value. A new draft with WIP therefore starts at 100% realization unless someone changes an amount. If the draft has only non-WIP amounts and no WIP value, Realization does not display. This applies whether the draft was created manually or by Auto Generate.
A write-down changes what's billed, never what the work was worth
WIP Value does not change after the entry is recorded. Editing an amount on the draft changes only Invoice Amount.
- A lower amount records a write-down and pushes realization below 100%.
- A higher amount records a write-up and pushes realization above 100%.
Write-ups use the same Edit Invoice permission as other amount edits; there is no separate write-up setting on the draft.
Where you adjust decides whose realization changes
You can change the amount for a whole project, one staff member's work or a single entry.
- A project-level change is spread proportionally across every included entry on the project, so every staff member's realization moves by the same share.
- A staff-level change affects only that person's entries.
- An entry-level change affects only that entry.
You can also enter a target Realization percentage on the same project, staff-group or entry row, and Aiwyn calculates the matching Invoice Amount. See Write down or write off unbilled work.
Removing a line does not create a write-down
Clearing an entry from a draft returns it to WIP. It no longer counts in the draft's WIP Value or Invoice Amount, so removing it does not lower the realization of the work that remains on the draft. Nothing is written off.
To stop work from ever being billed, keep it on a draft, set its Invoice Amount to 0 and post the invoice. See How work enters and leaves WIP.
Applied progress currently understates realization
Progress billed ahead of the work has no WIP value of its own. The intended measure for a draft that applies progress is:
(Invoice Amount + progress applied) ÷ WIP Value
The current draft invoice calculation uses Invoice Amount alone. That known defect understates realization whenever progress is applied. For example, a draft with $4,000 of WIP, $3,000 of progress applied and a $600 Invoice Amount currently shows 15%, even though the progress-aware result is 90%.
Use the draft's amount and applied-progress values together when reviewing realization on a progress invoice until that defect is released.
Fixed fees often show as a write-up or write-down
For a fixed-fee project, enter the agreed fee as the project's Invoice Amount. Realization still compares that amount with the WIP value of the included work. If the fee is lower than the recorded WIP value, the difference is a write-down; if it is higher, it is a write-up. The invoice type does not use a different realization formula.
If the fixed fee was billed as progress, the known progress limitation above applies.
Time and expenses are realized separately
The Time tab shows Time Realization and the Expenses tab shows Expense Realization, each next to its own Write Up/Down. The open draft does not show a combined time-and-expense realization tile.
On the Draft Invoices list, the Realization value combines time and expenses. It is calculated as the amount being billed for time and expenses divided by the value of the time and expenses on the invoice. Applied progress is not included.
A draft's realization covers one invoice, so other figures can differ
Realization appears in several places in Aiwyn, and each one answers a different question.
- On a draft invoice, realization covers the included work on that draft and changes with every amount edit until the invoice is sent.
- On a project, realization is Billed to Date divided by the project's WIP value to date. It covers the whole project's billing history.
- On the billing performance report, Realization Rate uses the WIP time records attached to the invoice. If a WIP record is not attached to an invoice, it is not included in the realization rate. Progress WIP is excluded.
Because the scopes and date rules differ, the figures do not necessarily match.
Related
- How work enters and leaves WIP
- How WIP becomes a draft invoice line item
- Edit a draft invoice
- Write down or write off unbilled work
- Troubleshoot a draft invoice
- Draft invoice screen reference
- Billing performance report reference
- Rate card fields reference