Applies to Aiwyn Practice.
Find out why the WIP page shows something you didn't expect, and fix it, so every project's unbilled balance is right before you bill.
Before you start
- To open WIP, you need View Unbilled Jobs. To create a draft from WIP, you also need Create Invoice. See Permissions required to use WIP.
- Several checks happen in Timesheet. To change another staff member's entry you need Edit Entry For Others. To change a submitted entry you need Edit Submitted Entry. Nobody can edit a locked entry, whatever their permissions.
- For what each column and control means, see WIP grid reference. For how each amount is worked out, see WIP amount calculations reference.
Steps
Find the symptom that matches what you see, then work through its checks in order. The quickest checks come first.
Submitted time or an expense is missing from WIP
Time reaches WIP only when it's billable, submitted, approved where approval is required, and dated on or before the Unbilled as of date. Expenses must also be posted and approved where approval is required.
- Select WIP in the left sidebar.
- Check the Unbilled as of date at the top left of the page. The cutoff uses the date on the time or expense entry, not the date it was submitted or approved. If the cutoff is earlier than the entry date, select the date picker and select today's date.
- Select Search and type the client or project name. Search matches text only, so also clear any column filters you set.
- If the project has a row, check Current Draft Invoice. If a draft exists, open it and check whether it already holds the missing work. A project can be on only one open draft, and Auto Generate skips it. New work still posts to WIP, but you add it to the existing draft instead of starting a second one.
- If the project has no row, check whether it is active and open in Projects. By default, WIP shows active, open projects. A firm setting can also show non-open projects when they have non-zero unbilled time, expenses or unapplied progress. See "A closed project has unbilled work" below.
- Select Timesheet in the left sidebar.
- In the staff filter dropdown, select the staff member who logged the entry, then go to the date of the work.
- Check whether the entry is still a draft. Entries stay draft until the timesheet is submitted with Submit Timesheet, and draft entries never reach WIP. The summary row shows draft hours separately. See Submit and correct a timesheet.
- If your firm routes submitted entries for approval, confirm that the entry was approved. If your firm doesn't use an approval step, submission approves the entry automatically. The same rule applies to expenses: when approval is required, a submitted expense stays out of WIP until it is approved.
- Check whether a time entry is billable. Non-billable time never appears in WIP. The work code determines this. See How Aiwyn classifies billable, non-billable and operational time.
- Check the Client and Project on the entry. If the entry is on a different project, its value shows on that project's row. To move it, see "Work shows on the wrong project or client" below.
- If the entry passes every check and still isn't in WIP, contact Aiwyn Support. Include the staff member, entry date, client, project and the Unbilled as of date you checked.
The entry's value now shows in the project's Unbilled Time, or in Unbilled Expenses for an expense.
A project you already billed is back in WIP
A project returns to WIP when it has new work or when previously billed or drafted work becomes unbilled again.
- In WIP, find the project and scroll right to Last Invoice. This is the date of the most recent invoice sent for the project.
- Check Last Unbilled WIP Date. If it's later than Last Invoice, new time or expenses were dated after the invoice went out.
- Compare Unbilled Time, Unbilled Expenses and Unapplied Progress to see what the balance is made of.
- Check Current Draft Invoice. If a draft exists, open it and add the new work there. A project can be on only one open draft, and Auto Generate skips it.
- Check whether a draft for the project was deleted or had lines removed. Both actions return the work to WIP without writing it off. Deleting the draft also releases the project. See What happens when a draft invoice is returned or deleted.
- Check Accounts Receivable for the most recent invoice. If it is marked Reversed, its time and expenses returned to WIP and its original draft was restored in Draft Invoices. The reversed invoice is removed from the posted Invoices list, but remains visible as Reversed in Accounts Receivable. The original draft creator is notified to take action. Every project on the restored draft remains reserved until the draft is sent or deleted. See How to change a sent invoice and Invoice status reference.
- If your firm syncs billing with a practice management system and work reappeared after an invoice was sent, contact Aiwyn Support before resending the invoice or making a manual WIP adjustment. A failed billing writeback can make the same work return on a later sync.
- Bill the new or returned work, or write off work your firm won't bill. See Create or add to a draft invoice from WIP and Write down or write off unbilled work.
The project leaves WIP once its remaining work is billed or written off.
A closed project has unbilled work
Closing a project doesn't bill or write off its work. Whether the closed project appears in the grid depends on your firm's WIP setting.
- In Projects, check whether the project is active and whether its status is Open or a non-open status such as Closed.
- By default, WIP shows active, open projects. If your firm has enabled closed-project WIP, it also shows non-open projects when at least one of Unbilled Time, Unbilled Expenses or Unapplied Progress is non-zero. A project whose time and expenses are exactly offset by unapplied progress still appears because those components need to be reconciled.
- If a closed project has unbilled work but doesn't appear, ask your administrator whether closed-project WIP is enabled. Reopen the project only if that matches your firm's project-status policy.
- When the project appears, check Current Draft Invoice. Work left off or removed from a draft stays in the project's unbilled balance. Deleting a draft also returns its work to WIP.
- Bill the remaining work, or write off work your firm won't bill. See Write down or write off unbilled work.
Written-off work leaves WIP without being billed.
Work shows on the wrong project or client
Each WIP row adds up the entries logged against one project, so you correct misplaced work on the underlying entries in Timesheet, not in WIP.
- In WIP, note which project the work shows on and which project it belongs to.
- Check Current Draft Invoice. If the entry is already on a draft, remove it from that draft first so it returns to WIP and is no longer reserved. See Edit a draft invoice.
- Select Timesheet in the left sidebar.
- In the staff filter dropdown, select the staff member who logged the entry. You need Edit Entry For Others to change another staff member's entry.
- Go to the date of the work and open the entry.
- If the entry is submitted, you also need Edit Submitted Entry. A locked entry can't be changed by anyone.
- Change Client and Project to the correct values, then select Save. If the client or project isn't in the dropdown, see Restore a missing client or project in the entry dropdowns.
- Repeat for each misplaced entry. Aiwyn doesn't currently provide a bulk move between projects; entries are corrected one at a time.
- A submitted entry stays submitted after the edit; it doesn't return to draft for reapproval. If the entry is linked to a task and Client or Project can't be changed, contact Aiwyn Support. Task-linked submitted entries have a known editing limitation.
The work leaves the original project's row and shows on the correct project's row. See Log and manage time entries.
A project shows under the wrong partner or manager
Project Partner and Project Manager in WIP come from the project, not the client record, so they can differ from the client's partner and manager.
- In WIP, find the project and scroll right to Project Partner and Project Manager.
- Open the project in Projects and check its Partner and Manager.
- If they're wrong, correct them on the project. See Manage a project record.
- When you create a new project, select Projects → New Project…. After you choose the Client and enter the Project Name, assign the Partner and Manager in the creation form.
The project appears under the right owner when you group WIP by Project Partner or Project Manager.
Unbilled Overall is lower than the time logged, or negative
Unbilled Overall is Unbilled Time plus Unbilled Expenses, minus Unapplied Progress. Progress billed in advance reduces the net unbilled balance, so the result can be lower than the time logged, zero while work still exists, or negative. See WIP amount calculations reference.
- In WIP, find the project.
- Compare Unbilled Time, Unbilled Expenses and Unapplied Progress.
- If Unapplied Progress isn't zero, the project has progress billed ahead of the work, such as a retainer, that hasn't been applied against its time and expenses yet.
- Check the Unbilled as of date. Time and expenses dated after it are left out of the totals.
- Apply the progress when you review the project's next draft. Auto Generate doesn't apply it for you. See Edit a draft invoice.
When a draft that applies the progress is sent, Unapplied Progress goes down by the amount applied.
Amount Remaining is negative on a fixed-fee project
For a fixed-fee project, Amount Remaining = Price − Billed to Date − the amount on the project's current open draft invoice. A negative amount means the sent and open-draft amounts together exceed the project's price. See What a negative Amount Remaining means.
- In WIP, find the project and scroll right to Pricing Structure. Check that it's Fixed Fee.
- Compare Price with Billed to Date.
- Check Current Draft Invoice. The amount on the project's current open draft is also subtracted from Amount Remaining.
- Check Unbilled Overall to see the project's remaining net unbilled work.
- Scroll right to Project Partner and confirm whether billing above the price was agreed.
- If it was agreed, bill the work as usual. If the agreed fee changed, update Price on the project so the project records the new agreement.
- If the extra amount is only on an open draft and wasn't agreed, return the draft to In Progress, then reduce or remove the excess amount before it is sent. Don't raise the project price just to make the negative value disappear.
- If a sent invoice already caused the overage, don't edit WIP to offset it. Follow your firm's sent-invoice correction policy: adjust the balance when the invoice should stand, or reverse an eligible invoice when it needs a full redo. See How to change a sent invoice.
The project's price, sent invoices and current draft now match the decision the project partner approved.
Work is duplicated, missing from the grid or locked unexpectedly
If the checks above don't explain the result, the WIP record may be excluded by project status or date, or it may be held by a stale draft or invoice allocation.
- Clear Search and all column filters, then set Unbilled as of to the entry date or later.
- Check that the project is active and open, or that your firm has enabled closed-project WIP.
- Check Current Draft Invoice and the restored draft from any recent invoice reversal.
- Don't repeatedly delete drafts, reverse invoices or make manual WIP adjustments to release the work. Those actions can make a stale allocation harder to correct.
- Contact Aiwyn Support with the client, project, entry or WIP details, draft IDs, invoice number and screenshots. Support can check whether the same WIP is claimed twice, remains locked after a reversal, or exists in the data but is excluded from the grid.
An open draft reserves every project on it. Its unbilled work can't go onto another draft, and Auto Generate skips it. New time still posts to WIP, but you add it to the existing draft. Sending or deleting the draft releases the hold. Reversing an invoice restores its original draft, so its projects remain reserved until you send or delete that restored draft.
Deleting a draft or leaving work off it doesn't write anything off. The work returns to WIP and goes on the next draft for the project. To stop work from ever being billed, see Write down or write off unbilled work.
You can't write down time in WIP. Write-downs happen on the draft invoice. See Edit a draft invoice.
The Create Invoice modal has its own cutoff date. Changing Unbilled as of on the WIP page doesn't change which work goes on a draft. Check the Unbilled as of date in the Create Invoice modal.
Related
- WIP grid reference
- WIP amount calculations reference
- How work enters and leaves WIP
- What counts as WIP
- What a negative Amount Remaining means
- Work with the WIP grid
- Permissions required to use WIP
- Create or add to a draft invoice from WIP
- Edit a draft invoice
- Write down or write off unbilled work
- What happens when a draft invoice is returned or deleted
- Troubleshoot a draft invoice
- How to change a sent invoice
- Adjust a sent invoice balance
- Invoice status reference
- Submit and correct a timesheet
- Log and manage time entries
- Restore a missing client or project in the entry dropdowns
- How Aiwyn classifies billable, non-billable and operational time
- Project, task and request status reference
- Manage a project record