This article applies to Aiwyn Practice.
This article explains what a negative Amount Remaining tells you about a project, what makes it go below zero, and whether you need to do anything about it.
Amount Remaining is the price left after what's billed and what's on the current draft
Amount Remaining shows how much of a project's price is still left to bill. You see it in three places:
- The Amount Remaining column in the WIP grid.
- The billing summary on the project's Billing tab, which opens when you select a project in WIP.
- The Project Amount Remaining column on the Project Billing tab in Draft Invoices.
For a Fixed Fee project, Aiwyn works it out as Price − Billed to Date − the amount on the project's current draft invoice. In the billing summary, these amounts are labelled Total Price, Billed to Date and Current Draft Invoice.
For an Hourly project with a minimum and maximum price, Aiwyn runs the same calculation from each price and shows the result as a range. A project with no pricing structure shows no Amount Remaining.
The billed amounts in the calculation are counted after write-ups and write-downs. Sales tax and custom fees aren't included, and Unapplied Progress doesn't affect the figure. For each amount in the calculation, see WIP amount calculations reference.
Below zero means billing has gone past the price
When Amount Remaining reaches zero, the whole price has been billed. When it goes below zero, what's been billed plus what's on the current draft is more than the price. In the WIP grid, a negative amount shows in parentheses.
For example, a Fixed Fee project has a Price of $10,000. Its sent invoices total $9,000, and its open draft bills $1,500. Its Amount Remaining is ($500).
On an Hourly project, each end of the range goes negative separately. Say a project has a minimum price of $8,000, a maximum price of $12,000, and $10,000 billed. Each end is formatted separately, so the range runs from ($2,000) to $2,000. Billing has passed the minimum price but not the maximum. Billing has gone past the maximum price only when both ends are negative. Aiwyn sometimes calls an hourly project with a maximum price “capped”; it isn't a separate pricing structure.
Work billed beyond the agreed scope is the usual cause
Most often, a negative Amount Remaining means the firm did extra work outside the original scope and billed it on top of the fixed fee. That can be exactly what the partner agreed with the client. It can also be work that should have been written down, or billed to a different project.
Write-ups, expenses, project fees and progress bills all count against the price
Everything that counts in Billed to Date or on the current draft reduces Amount Remaining. That means ordinary billing actions can take it below zero:
- Write-ups. A write-up on a draft or sent invoice lowers Amount Remaining by the amount written up. A write-down raises it. A write-up also takes the draft's Realization above 100%. See How realization is calculated.
- Expenses. Billed expenses count toward Billed to Date, even on a fixed-fee project. A project billed in full for its fee goes negative by the amount of any expenses billed with it.
- Project fee charges. Project fee charges on sent invoices count toward Billed to Date. They also reduce Amount Remaining.
- Progress bills. A sent progress invoice counts toward Billed to Date straight away. When that progress is later applied against time and expenses, it isn't counted a second time.
An open draft can make the figure negative before anything is sent
The current draft invoice is part of the calculation, so Amount Remaining can go negative while a draft is still in review. That warns you that sending the draft as it stands will bill more than the price.
A draft doesn't bill anything until it's sent, so you can still change it. Amount Remaining updates as the draft changes. Writing down the draft, taking work off it or deleting it changes the amount the calculation subtracts. See Edit a draft invoice.
A prepayment reduces the figure after it is invoiced
A required prepayment doesn't count toward Billed to Date before the engagement is executed. After execution, Aiwyn creates a progress invoice for the prepayment. Once that invoice is posted, the prepayment counts once in Billed to Date and appears as Unapplied Progress until it is applied against time and expenses. Applying it later doesn't add the same amount to Billed to Date again. See Require a prepayment on a project.
Unbilled WIP doesn't count until it's on a draft
Amount Remaining looks only at billed amounts and the current draft. Approved work in Unbilled Time, Unbilled Expenses and Unbilled Overall doesn't reduce it until you put that work on a draft invoice. See How work enters and leaves WIP.
A positive Amount Remaining doesn't mean there's room for all of a project's WIP. Compare it with Unbilled Overall before you bill. If the unbilled work is worth more than what's left of the price, billing it as recorded takes Amount Remaining below zero.
When Amount Remaining is already zero, any work still in WIP has no fee left to bill against. You decide whether to bill it anyway, write it down or write it off. See Write down or write off unbilled work.
Aiwyn flags billing past the price but doesn't stop it
Aiwyn doesn't stop you from creating or sending a draft invoice just because it bills more than a project's price. When a draft bills more than the fixed fee, the project detail view on the draft shows an overcharge warning. The warning is a heads-up, not a hard stop.
Some related actions do enforce the price. You can't close a fixed-fee project while Billed to Date is more than Total Price. You also can't save a custom billing schedule for more than the amount left to bill, or reduce a fixed fee's Total Price below Billed to Date. Resolve the excess billing or raise the price before you complete those actions.
A negative Amount Remaining isn't an error on its own. It tells you the project's billing no longer matches its agreed price. The next step is to find out whether the extra billing was authorized, or whether something else explains it: a write-up, billed expenses, a prepayment, an open draft or a price that was entered wrongly. For how to check each of these, see Troubleshoot unexpected WIP.
Related
- WIP amount calculations reference
- WIP grid reference
- Troubleshoot unexpected WIP
- How work enters and leaves WIP
- How realization is calculated
- Edit a draft invoice
- Write down or write off unbilled work
- Require a prepayment on a project
- Price a project on an engagement letter