AuditTrove user guide · Chapter 18

18. Scheduling, time, WIP and billing

Steps in this chapter (12)

12 steps, each with a screenshot · Chapter 18 of 21

Book people on engagements, record and approve time and expenses, set charge-out rates and budgets, raise fee notes with VAT and WHT, record receipts and read the practice reports.

Scheduling, WIP & billing runs the practice side: who is booked where, weekly timesheets with approval, expenses, charge-out rates with history, budgets, work in progress, fee notes with VAT and Nigerian withholding tax, receipts, write-offs, debtors and the reports that the firm and the regulators need (utilisation, realisation, fee dependency and the non-audit services ratio).

Use cases

  • Use case — A staff member's leave clashes with a booking. The planner warns about capacity when the booking is made (step 18.3).
  • Use case — A fixed fee with time over budget. Raise the fee note at the agreed fee and record the reason for the adjustment (step 18.9).
  • Use case — A client deducts 5% WHT. Record the receipt net and the WHT credit note or certificate (step 18.10).
  • Use case — Fee dependency on a PIE client. Practice reports show fees from each client as a share of the firm's total (IESBA Code 410).

18.1 Record time

AuditTrove screenshot: Scheduling, WIP & billing → Timesheet. Numbered orange markers point to the items described in the steps.
Figure 18.1 — Scheduling, WIP & billing → Timesheet

Why

Time is recorded weekly against engagements, phases and other activities (training, leave) and approved by the manager or partner. Approved time feeds the engagement's hours against budget and the firm's work in progress.

Who

Everyone.

What to do

  1. Open Timesheet, add a row for the engagement and phase and enter the hours by day.
  2. Choose Submit week.

Back to top ↑

18.2 Approve timesheets

AuditTrove screenshot: Approvals: time and expenses waiting. Numbered orange markers point to the items described in the steps.
Figure 18.2 — Approvals: time and expenses waiting

Why

Managers and partners approve or reject submitted time and expenses; a rejection goes back with the reason. Nobody approves their own time.

Who

Manager or partner.

What to do

  1. Tick the entries and choose Approve, or Reject with a reason.

Back to top ↑

18.3 The planner

AuditTrove screenshot: Planner: bookings by person and week, with capacity. Numbered orange markers point to the items described in the steps.
Figure 18.3 — Planner: bookings by person and week, with capacity

Why

Bookings put people on engagements (or leave and training) for dates and hours per day. The planner shows each person's load against capacity and warns about over-booking and about a person who has not declared independence for the engagement.

Who

Manager or partner.

What to do

  1. Choose a cell to book a person, or open a booking to change it.

Back to top ↑

18.4 My schedule

AuditTrove screenshot: My schedule: where I am booked. Numbered orange markers point to the items described in the steps.
Figure 18.4 — My schedule: where I am booked

Why

Each person sees their own bookings for the coming weeks and books their own leave or training.

Who

Everyone.

What to do

  1. Choose Book leave or training to record your absence.

Back to top ↑

18.5 Charge-out and cost rates

AuditTrove screenshot: Rates by grade and by person, with effective dates. Numbered orange markers point to the items described in the steps.
Figure 18.5 — Rates by grade and by person, with effective dates

Why

Charge-out rates are set by grade and, where different, by person, with an effective date, so history is kept and old time is valued at the rate in force. Cost rates give realisation.

Who

Owner or partner.

What to do

  1. Add a rate with its effective date; a new rate never changes approved time already billed.

Back to top ↑

18.6 Expenses

AuditTrove screenshot: Expenses on engagements, billable or not. Numbered orange markers point to the items described in the steps.
Figure 18.6 — Expenses on engagements, billable or not

Why

Expenses (travel, courier, other) are recorded against engagements, approved and, if billable, added to the next fee note.

Who

Everyone.

What to do

  1. Choose Add an expense, pick the engagement and category and tick Billable if it can be charged.

Back to top ↑

18.7 Engagements: budget and WIP

AuditTrove screenshot: Each engagement's fee basis, budget, time and WIP. Numbered orange markers point to the items described in the steps.
Figure 18.7 — Each engagement's fee basis, budget, time and WIP

Why

Each engagement shows its fee basis (fixed or time), the budget by person and phase, the time recorded and the unbilled work in progress.

Who

Manager or partner.

What to do

  1. Open an engagement to set its budget and the rates that apply to it.

Back to top ↑

18.8 A draft fee note

AuditTrove screenshot: Billing: the fee note drafted from the WIP. Numbered orange markers point to the items described in the steps.
Figure 18.8 — Billing: the fee note drafted from the WIP

Why

A fee note is drafted from unbilled time and billable expenses, summarised by person or phase, with VAT by the engagement's jurisdiction and the WHT the client may deduct. Fee note lines are classed as audit, audit-related or non-audit for the NAS ratio.

Who

Partner raises; owner or partner issues.

What to do

  1. On the engagement choose Raise a fee note, check the lines and the text.

Back to top ↑

18.9 The issued fee note

AuditTrove screenshot: The fee note as the client receives it. Numbered orange markers point to the items described in the steps.
Figure 18.9 — The fee note as the client receives it

Why

Issuing a fee note gives it the next number (it can only move forward), records any difference from the time value with the reason, and produces the PDF with the firm's bank details and terms. An issued fee note can be corrected only with a credit note.

Who

Partner.

What to do

  1. Choose Issue, give the reason for any adjustment, and download the PDF.

Back to top ↑

18.10 Receipts and the fee notes

AuditTrove screenshot: Billing: issued fee notes, receipts and what is outstanding. Numbered orange markers point to the items described in the steps.
Figure 18.10 — Billing: issued fee notes, receipts and what is outstanding

Why

Receipts are recorded against fee notes; a receipt net of withholding tax leaves the WHT to be matched to the client's credit note or certificate.

Who

Owner, partner or administrator.

What to do

  1. Choose Record a receipt, allocate it to the fee notes and record the WHT.

Back to top ↑

18.11 WIP and debtors

AuditTrove screenshot: WIP & debtors: unbilled time and ageing. Numbered orange markers point to the items described in the steps.
Figure 18.11 — WIP & debtors: unbilled time and ageing

Why

Work in progress and debtors are aged, so partners see what to bill and what to chase; write-offs are recorded with reasons.

Who

Partners.

What to do

  1. Open a client to see its statement; record a write-off with the reason.

Back to top ↑

18.12 Practice reports

AuditTrove screenshot: Reports: utilisation, realisation, fee dependency and the NAS ratio. Numbered orange markers point to the items described in the steps.
Figure 18.12 — Reports: utilisation, realisation, fee dependency and the NAS ratio

Why

Reports cover utilisation, realisation, WIP, debtors, fee dependency (fees from one client as a share of the firm's total — IESBA Code 410) and the non-audit services ratio for PIE clients (80% cap for Nigerian firms, with a warning at 70%).

Who

Owner, partners, quality lead.

What to do

  1. Choose a report and a period; download it as CSV.

Back to top ↑