Compare Quote, Jobsheet and Invoice Items

Learn how to compare your invoice items to those on your quote and jobsheet

Updated on June 3rd, 2024

The Invoice Worksheet allows you to compare the items that were quoted, booked on the job and allocated to the invoice side by side with the Compare Quote, Jobsheet and Invoice Items tab.

Why use this feature?
This is a great way to make sure that what you're invoicing for matches what you originally quoted, or booked onto your jobsheet. Here is an example scenario:

Quote

Jobsheet

Invoice

You quote for $1000. You book $200 worth of extra purchases on the jobsheet. You check the Compare Quote, Jobsheet and Invoice Items tab. Instead of missing out on invoicing the extra $200 in purchases, you catch it and add it to your invoice worksheet in addition to the original quoted amount.
 

What to check if the tab doesn't work as expected

If the tab doesn't work as expected, try checking the following things:

  • Invoice Layout must be set to Lab & Line ItemsDetailed or Itemised.
  • Use the Quoted Items list when booking materials on to the task. Field Technicians use the Quoted Items list when booking parts to the task.
  • Task Quotes only. The Compare tab only looks at the quote attached to the task and not from any project it may be linked to.
 
 

Click the Compare Quote, Jobsheet and Invoice Items tab.

Select either the quote or jobsheet item you want to add to the invoice by clicking the arrow icon next to Qty when it appears. This will add the item to the invoice with the quantity from either the task or the quote; whichever column you clicked from.

Alternatively, you can add all of the items from a task or quote to the invoice by selecting Invoice All at the bottom of the Quote or Jobsheet columns.

In the example shown, the quoted labor was six hours. The labor recorded on the jobsheet was only five hours. The quoted value will be invoiced by clicking Invoice All under the Quote column.

 

Click Save to display the selected items.

Quick Comparison

The compare tool uses colors and icons to indicate variances between the item quantities on the invoice and the item quantities on the quote or jobsheet:
Quantity invoiced is greater than the quote or jobsheet
Quantity invoiced is less than the quote or jobsheet
Quantity invoiced is equal to the quote or jobsheet
Quantity invoiced is greater than the quote or jobsheet
Quantity invoiced is less than the quote or jobsheet
Quantity invoiced is equal to the quote or jobsheet