This article applies to Aiwyn Practice.
Set the WIP page's cutoff date, narrow it to the projects you need, and group or export it, so you can work through a billing cycle by age or by owner.
Before you start
- Ensure you can open WIP in the left sidebar. See Permissions required to use WIP.
- WIP shows approved, billable work that hasn't been billed yet. Time that isn't approved doesn't appear. See How work enters and leaves WIP.
- For what each column and control means, see WIP grid reference.
Steps
Set the Unbilled as of date
- Select WIP in the left sidebar.
- At the top left of the page, select the Unbilled as of date picker. It shows today's date until you change it.
- Select the date to calculate totals as of. For a month-end review, select the last day of the billing period.
Every total in the grid recalculates, and time entered after that date is left out.
Search for a project, client or staff member
- Select Search at the top right of the page.
- Type a client name, project name or staff name.
- To show every project again, clear the search box.
The grid shows only the rows that match. Search matches text only, so to find projects by amount or date, filter a column instead.
Filter by a column
- Open the filter on the header of the column you want to filter by hovering over the column and selecting the three horizontal lines.
- Set the condition, for example Unbilled Time greater than 5,000.
- To remove the filter, clear it.
The grid shows only the projects that meet the condition.
Group projects
- Select the grouping control at the top left of the grid.
- Select the field to group by, such as Client, Client Number, Project Partner or Project Manager.
- Select a group row to expand or collapse its projects.
- To show one row per project, clear the grouping.
Projects sit under a parent row for each value, and each parent row rolls up its projects.
Export the grid
- Set the Unbilled as of date, search, filters and grouping you want reflected in the file.
- Select Export at the top right of the page.
The file downloads with the current WIP view.
Review aging unbilled work
- Clear the grouping so each row is one project.
- Sort Last Unbilled WIP Date so the oldest dates come first.
- For each project, compare Last Invoice with Last Unbilled WIP Date. A later unbilled date means new work has built up since the last invoice.
- Check Current Draft Invoice. If a draft already exists, add the work to it. See Create or add to a draft invoice from WIP.
- Bill the work, or write off work your firm won't bill. See Write down or write off unbilled work.
Projects with the oldest unbilled work are at the top of the grid, ready to bill or clear.
Review WIP by partner or manager
- Set Unbilled as of to the last day of the billing period.
- Group the grid by Project Partner or Project Manager.
- Expand each owner's group to see their projects and Unbilled Overall totals.
- To send each owner their list, export the grid.
Each partner's or manager's projects sit together under their name, with the unbilled totals they're responsible for.
You can't write down time in WIP. Write-downs happen on the draft invoice after you create it. See Edit a draft invoice.
The Create Invoice modal has its own cutoff date. Confirm the Unbilled as of date in the Create Invoice modal, because that date decides which time goes on the draft.
Related
- WIP grid reference
- How work enters and leaves WIP
- What counts as WIP
- Create or add to a draft invoice from WIP
- Write down or write off unbilled work
- Troubleshoot unexpected WIP
- Export a grid table to Excel or CSV