Once the status of a task has been set to 'Completed', you will see a Create Final Invoice button at the bottom of the task screen. Click this to create a final invoice for the completed task.
The top section of the Invoice Worksheet displays all of the client details and task description for the job. The tabs below the description area provide quick access to costs recorded on the job sheet, task notes, task assets, task checklists, manual checklists, documents and photos, and any compliance forms raised against that job.
Used for recording client notes or messages which will appear on every sales invoice for the selected client. Notes entered into this field will automatically update the Client Message section on the client card.
Automatically populates based on the terms set in the client card.
Used for recording notes relating to the invoice that you may want to include on the layout.
The Invoice Details section is used to build the invoice.
Automatically populates with the next available invoice number. This number must be unique and should not be edited.
Please contact your Site Administrator if a higher invoice number sequence is required.
The next Invoice Number and Purchase Order Number to be generated can be changed in Site Administration > Resource > Integration.
Automatically populates with the date of creation. This can be edited if needed.
Automatically calculated based on your company's default transaction terms set in Site Admin. If terms have been set on the client card, this will override the company default terms. This can be edited if needed.
Automatically populates using the task identification and task description. This can be edited if needed.
Invoice Notes tab
Used for recording notes relating to the invoice (similar to task notes).
Documents & Photos tab
Used for uploading and storing documents or photos against the invoice (similar to task notes).
All Invoices tab
Lists all invoices raised for the task. This can be handy if you've created part invoices throughout a large task and you need to see a total invoiced value.
The Invoice Style controls how much information is shown on the Invoice Worksheet and is available to the custom print layout. It is also the format used when the invoice is imported into your accounting package.
Simple: Totals all of the Labour by Work Type.
Simple (Imp): Totals all of the items together into a single line item using the name of the task.
Lab & Mat (Simple): Two separate line items for grouped Labour and Parts used.
Lab & Line Items: Single line items for each Labour (showing the name, date and labour note) and Material used.
Detailed: Single line items for each Labour (showing the worktype only) and Material used.
Itemised: Labour items based on the cost rate and separate line items for each Material used.
Itemised (Mat): Total of all Labour and groups material items where the following are the same: Part Number, Item, Cost, Sell, GST, Margin On, Margin Amount, SOR Item.
Itemised (Qty): Total of all Labour and groups any item where the following are the same: Part Number, Item, Cost, Sell, GST, Margin On, Margin Amount, SOR Item.
We recommend starting off with a Detailed or Lab & Line Item invoice style so that you have the most information available to you on the Worksheet for pricing and/or displaying or restricting based on the invoice print layout.
Add line items
If the completed task is not linked to a quote or does not have any SOR items recorded on the Task Worksheet, the system will automatically copy the items from the Task Worksheet to the Invoice Worksheet.
Items can be added or removed from an invoice without affecting the original costs recorded on the Task Worksheet, maintaining the integrity of your Profit & Loss reporting.
Enter a percentage that you want to include as a line item
Select to either calculate on the total amount remaining on the task, the total amount remaining on the quote, or the overall value of the quote. The Invoiced to Date information above will help you out with your calculations.
The Item Description will default to the percentage of the option you selected. You can override this by clicking on the(pencil icon)
The calculated amount will be shown as the Line Item Total
Click Set Total when finished to add the line item.
You can also use the reverse process by typing an amount into the Line Item Total box and the percentage will update accordingly.
Adding an item from your inventory is useful if you used inventory items on a job that weren't added to the quote or task.
Click Multi-Search > Inventory.
Use the search boxes at the top of the Search Inventory window to filter the list by Category, Part Number, or Item name.
Enter the Quantity you want to invoice.
Click X to close the Search Inventory window.
Multi-Search items added to an invoice will not affect inventory stock levels.
If the task was quoted (or belongs to a quoted project) and you want to simply add all of the items from the linked quote to the invoice, clickAdd from quote Pick List. This greatly speeds up the process for invoicing clients for quoted works.
Alternatively, you can use the Quote Pick List button to view and select individual items from the quote.
You can enter the quantity of each quoted item you would like to invoice, or tick the All checkbox at the bottom to add all quoted items and Save.
Click Invoice to return to the Invoice Worksheet.
SOR or 'Schedule of Rates' items are used in flat-rate or price-book pricing situations. Often the sell price of the SOR item includes all labour and materials used for the entire job.
If there were any SOR items recorded on the Task Worksheet, you will see an additional option that allows you to add only those SOR items to the invoice.
Click Add SOR items booked out on jobsheetif you want to add only the SOR items (no additional labour or materials) from the Task Worksheet to the invoice.
Adding Jobsheet items would mostly be used for do-and-charge work, to invoice ongoing job costs.
ClickAdd items booked out on jobsheet toadd all labour, materials and expenses recorded in the Task Worksheet to the invoice.
Link Task items
Linking task items is an effective way to track the job costs associated with each invoice line item. Using this method, each invoice line item has a selection of task items grouped together.
You want to enter customised invoice line items, but want to show what job costs are related with each invoice line item.
You want to invoice for ongoing work to date and easily identify the materials, labour and expenses you have previously invoiced.
While you're able to apply these groupings within your invoices, currently these are only visible internally and are not available on invoice layouts. In future enhancements, however, you will have this functionality.
Using any of the methods above in Add line items, click the (link) button.
Click Link Task Items and select the type of item(s) you want to add from the task (Labour, Material, or Expenses).
From the pop-out window, double click your items to select them and close the window once finished.
Currently, the entire quantity of items will be linked to the invoice line item. In future enhancements, you will have the option to separate quantities.
To remove a linked item, click the(red trash can)
After saving the invoice, task items already linked to a line itemwill change colourto show that it has already been linked.
The link button will change colour to indicate items are linked. Click the button again if you want to collapsethe grouping.
Save the invoice to apply these groupings.
Compare quote, jobsheet and invoice items
You are also able 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 Itemstab.
There are some restrictions that must be adhered to if you want to take full advantage of the comparison tool:
Invoice Layout must be set to Lab & Line Items, Detailed 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 Allat the bottom of theQuoteorJobsheetcolumns.
Click Save to display the selected items.
The compare tool uses colours 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
Override quote value
When invoicing under or over the total value of a linked quote, AroFlo will automatically include a Quote Variation line item to adjust the total of the invoice so that it equals the total of the quote.
If you don't want to include this quote variation line item on the invoice, you can override it by selecting the Override Quotecheckbox and Save.
Invoice markups and discounts
Each line item on an invoice can receive both a markup and a separate discount. The discount will be applied to the total markup price. For example, an item costing $10 has a markup of 100% = $20 sell value. The discount of 20% is then applied to the total $20, reducing the sell value to $16.
The item markup is automatically applied based onClient,Business UnitorItem Specificmarkups. Discounts are applied manually by entering the discount percent into the discount field for the item as required.
Ad-hoc items added to an invoice will show the default material markup when the item type is set to 'MAT'. All other types (LAB, EXP, FRE) will automatically change the markup to 0.
Invoice markup, margin & profit.
Markup, margin and profit information is available to Admin users (with pricing visibility permissions).
Markup = ((Total Invoiced ex. GST - Total Task Cost ex. GST) / Total Task Cost ex. GST) * 100
Margin = ((Total Invoiced ex. GST - Total Task Cost ex. GST) / Total Invoiced ex. GST) * 100
Profit = Total Invoiced ex. GST - Total Task Costs ex. GST
[p/hr] = Total Profit / Task Total Hours
Remember to Save after making changes to line items to ensure these calculations are updated.
The above information can also be included in quote, task and invoice reports.
Not all users see the Cost and Markup column. Visibility depends on User Feature Access. Restricted users will only see Qty, Sell, Discount and Total columns (in Office and Field).
To remove items from an invoice, click the Del link to the right of each item.
If you want to remove more than one item quickly, click Multi-Delete, select the item/s you want to remove and Save.
Invoice totals panel
The invoice totals panel is found on the bottom right of the invoice worksheet. By default it will display all the information for the invoice you are working on(This Invoice).Click onInvoice Summaryto display a list of past invoices. The blue (if using AroFlo's default theme) vertical strip highlights the invoice currently being displayed.
See the tabs below for the available options for each view:
Presents adropdowngiving you further information on how the balance due on the displayed invoice is made up.
Click on the hyperlink to open up the corresponding invoice.
The Status drop-down at the bottom of the invoice offers three statuses:
The default status for all new invoices. You can add to or alter the invoice while it's in this status.
An optional status that allows for complex workflows. You can add to or alter the invoice while it's in this status.
The status to use when you've sent the invoice to the client. You can no longer add to or alter the invoice once it has this status. If you need to make changes, set the Status back to In Progress or Pending Approval, and click Save.
An invoice must be set to Approved before it can be pushed across to your accounting package.
The Save button at the bottom of the invoice offers three options:
Save & Mark as Pending Approval
The invoice will be moved into the Pending Approval section of the ServiceTrack > Invoicing menu.
'Pending Approval' is an optional status. It allows for complex workflows that may involve other departments, e.g. your Accounting department may need to approve before you send the invoice to your client.
Save & Mark as Approved
The invoice will be moved into the Approved Invoices section and can now be pushed to your accounting package.
You must save your invoice before printing or emailing the invoice to your client.