This article applies to Aiwyn Practice.
This page lists each calculated amount in WIP, what it represents and how Aiwyn works it out, in the order the amounts appear. Use it when you reconcile a WIP figure or need to check why an amount looks the way it does.
For what every column and control on the page shows, see WIP grid reference.
WIP grid amounts
| Amount | What it represents |
How it's calculated | Notes and limits |
|---|---|---|---|
|
Unbilled Time |
The value of approved time on the project that hasn't been billed yet. | The total unbilled value of the project's approved, billable time entries dated on or before Unbilled as of. An entry's value is its hours multiplied by the billing rate that applied to it. | An entry's value doesn't change after it's recorded. Non-billable and unapproved time is never included. |
| Unbilled Expenses | The value of expenses on the project that haven't been billed yet. | The total unbilled value of the project's expenses dated on or before Unbilled as of. An expense's value is its quantity multiplied by its cost per unit. | Only posted and approved entries land in unbilled WIP. Unbilled balance only clears once the invoice is sent. |
| Unapplied Progress | Progress billed on the project that hasn't yet been applied against its time and expenses. | The total of the project's sent progress invoices, less any progress already applied on a later invoice. | It grows when a progress invoice is sent, whether or not the client has paid it, so it isn't the same as an unallocated payment. Progress has no WIP value of its own. It goes down when a draft that applies progress is sent. |
| Unbilled Overall | The project's net unbilled balance. | Unbilled Time plus Unbilled Expenses, minus Unapplied Progress. | Negative when the project has more unapplied progress than unbilled time and expenses. A project can total $0.00 and still have work and progress to apply. |
| Price | The fee in the project's pricing structure. It's entered on the project, not calculated. | Fixed Fee: the project's total price. Hourly: the minimum and maximum price, shown as a range. | Shows - - when the project has no pricing structure. |
|
Billed to Date |
What has already been invoiced on the project. | The total billed amount of time, expenses and progress on invoices sent for the project, after write-ups and write-downs, plus any prepayment on the project's engagement. | Draft invoices aren't included. Sales tax and custom fees aren't included. Shows $0.00 when nothing has been billed. |
| Amount Remaining | How much of the project's price is left to bill. |
Fixed Fee: Price − Billed to Date − the amount on the project's current draft invoice. Hourly: the same calculation from the minimum and the maximum price, shown as a range. |
Unapplied Progress doesn't affect it. Negative when what's billed and on the current draft is more than the price. Blank when the project has no pricing structure. See What a negative Amount Remaining means. |
The billing performance report defines Unbilled WIP (Net) and Unapplied Progress in its own way, so report totals won't necessarily match the WIP grid. See Billing performance report reference.
Project billing summary amounts
A project's billing details include a billing summary. Total Price, Billed to Date, Unapplied Progress and Amount Remaining there are the same amounts as Price, Billed to Date, Unapplied Progress and Amount Remaining in the grid. These amounts appear only in the project's billing details:
| Amount | What it represents |
How it's calculated | Notes and limits |
|---|---|---|---|
| Current Draft Invoice | The amount on the project's open draft invoice. | The total of time, expenses and progress on the project's currently open draft invoice, after write-ups and write-downs. | Sales tax and custom fees aren't included. This is the amount Amount Remaining subtracts. |
| Realization | How much of the project's recorded work value has been billed so far. | Billed to Date ÷ the project's WIP value to date, as a percentage. | Covers the whole project, so it can differ from a draft invoice's realization. It's most meaningful once the project is fully billed. See How realization is calculated. |
Adjustment amounts
Write-ups, write-downs and write-offs don't have a WIP grid column. They show on the draft invoice, and they're recorded against each WIP entry when the invoice is sent.
| Amount | What it represents |
How it's calculated | Notes and limits |
|---|---|---|---|
| Write Up/Down | The difference between what a draft invoice bills and what its work was worth. | Invoice Amount − WIP Value. | Negative is a write-down. Positive is a write-up. See Draft invoice screen reference. |
| Draft invoice Realization | How much of the work's value a draft invoice bills. | Invoice Amount ÷ WIP Value, as a percentage. | Above 100% after a write-up, below 100% after a write-down. See How realization is calculated. |
| Write-down or write-up on a sent invoice | What happens to an entry's value when the invoice it's on is sent. | The entry leaves WIP in full. Its billed amount counts toward Billed to Date. The difference between its value and its billed amount is recorded as the entry's write-down, or its write-up if you billed more. | The difference doesn't stay in Unbilled Time or Unbilled Expenses. |
| WIP write-off | Unbilled work removed without being billed. | The entry's whole unbilled value is recorded as written off. Nothing is added to Billed to Date. | See Write down or write off unbilled work. |
Related
- WIP grid reference
- How realization is calculated
- What a negative Amount Remaining means
- How work enters and leaves WIP
- How WIP becomes a draft invoice line item
- Draft invoice screen reference
- Write down or write off unbilled work
- Billing performance report reference
- Rate card fields reference