Invoice Variance Report

14/05/2025
Knowledge

How To

Location: LEAP Menu > Reports > Management > Invoice Variance Report

Purpose: The report captures variances between initially recorded professional fees (Time or Fees) and their invoiced amounts, including any adjustments made during the invoicing process.

By highlighting these variances at the invoicing and adjustment stages, it can help your firm to:

Monitor the accuracy of Staff fee recording and billing;
Project how much of the work in progress (WIP) is likely to be converted into billable revenue;
Make informed choices about pricing adjustments, ensuring that the rates reflect the services provided while staying competitive in the market.

Report Trigger: Displays discrepancies between recorded professional fees and their billed amounts within a specified invoicing period.

Filters:

Date Range	Displays staff members recorded professional fees and their billed amounts within the choosen date range.
Billing Category	Filter results to display all or only the categories selected.
Staff	Consists of two filters: 1. Include Inactive Staff: Yes: Include inactive Staff members in the 'Staff' list for selection. No: Exclude inactive Staff members in the 'Staff' list for selection. 2. Staff list for selection. NOTE: When you change the selection for Include Inactive Staff (from Yes to No or vice versa), the Staff drop-down list will be updated accordingly.
Invoice Status	Allows users to control which invoices are included in the contribution evaluation by selecting from different invoice statuses. Draft Unapproved Draft Approved Printed Sent (Final)
Include Tax	Displays amounts inclusive or exclusive of tax.
Expand Row Groups	Select Yes to display the breakdown of individual invoices and its associated Professional Fees (Time & Fees) for the selected Staff members.

Report Fields:

Staff Name/Invoice No.	Displays the following information: The staff member who contributed to invoices The invoice number of the relevant invoice
Original Fees	The actual value of WIP (Time or Fee) entered to the ledger.
Invoice Amount	The value as invoiced prior to any adjustments.
Variance	Invoiced Amount less original WIP Amount. NOTE: This variance arises from fee altering before finalising an invoice. Please refer to this article for instructions on altering fees (located under 'Additional Options').
Adjustments	Invoiced Amount less original WIP Amount. NOTE: This variance arises from fee altering before finalising an invoice. Please refer to this article for instructions on altering fees (located under 'Additional Options').
Total Variance	The cumulative total of all variances to the invoice, which is the sum of both 'Variance' and 'Adjustments'.

Last Modified Date

14/05/2025 12:13 pm

Title

Invoice Variance Report

URL Name

Invoice-Variance-Report-NZ

Resolution