In Abtrac you can create a detailed progress claim invoice automatically from your project task and timesheet data.
Automatic Progress Claim invoices can be generated by amounts to look like the examples below.
There are quite a few key details to get your progress claim invoices set up and working they way you need them.
It’s a good idea to read through this article from start to finish, but we’ve also summarised the key components below for quick reference:
Where to enter fee estimates and claim details
How to use the automatically generate invoice options
Screenshots of automatically generate invoice options and the invoices they create
An explanation of how invoice lines for Progress Claim invoices are created, how to assign time to claim lines, and how to enter the line amounts you require for each claim item
The Progress Claim columns show the Task Fee Value, Percentage Complete (Task %), Fee to Date (Value Completed), Previously Invoiced and a Line Amount
Each of the columns in an invoice can be edited, styled and hidden from Administration > Settings > Invoice Line Control Settings, or by editing the invoice line.
Click on the links above, or read on for details
Creating Progress Claim Invoices – Setting up your Projects
To create a progress claim invoice you’ll first need a project with task budgets entered.
People will then need to enter their time and disbursements against each respective task (you’ll want to ensure that tasks are required for the project).
If you are not using tasks yet we’d recommend reading through this article to learn the best way to set up and use tasks in your office. (aka. stages, phases, or matters)
You may also wish to generate progress claim numbers automatically for each invoice. This can be enabled from Project Billing Details.
From the Invoice Lines, Narratives and Amounts section > choose the Auto Generate Invoice Lines button.
Then choose the Progress Claim option and decide which style of progress claim invoice you’d like to use
This article relates to Progress Claim by Amount invoices. The process is similar for Percentage Progress Claim invoices.
Progress Claim by Amount Invoice Gallery
Generating and Editing Invoice Lines.
Invoice lines for an automatically generated progress claim are created for each current project task – regardless of whether any time exists in the system for that task.
Unbilled time and cost for each current project task is automatically assigned to the corresponding task line.
You can determine what to bill by viewing the assigned time (at this point you can also un-assign items and hold some back for the next claim if required).
Alternately you can bill any other chosen amount, including an amount greater than the original fee estimate. However to clearly view and analyse any variations to the original scope you may prefer to track the variations as separate tasks.
You can also bill a percentage of the total fee estimate, by entering a percentage amount from edit invoice line details the line amount will calculate automatically.
The invoice line narrations for each line are copied from the task name as a default but these descriptions can be amended on the invoice line narrative.
Adding additional lines to automatically generated claim invoices.
Once lines have been created you can independently create text only lines containing a description of the work carried out. You can also create other types of invoice lines (text/value etc) – but these won’t be taken into account the next time a claim is automatically generated.
(You’ll need to use subtotals to ensure the claim details still displays as expected with extra invoice lines inserted.)
All the columns can be renamed, re-ordered and hidden from the invoice, this is explained in the next section – Styling Progress Claim Invoices
Task Fee Value is auto-filled from the Task Fee Estimate
% Completed (Task %) is automatically calculated from the total Fee to Date(including the current Line Amount) ÷ Task Fee Value. You can also enter a percentage from edit invoice lines (e.g. 0.50 (50%)) and the Line Amount will be worked out for you.
Fee to Date (Value Completed) is automatically calculated from all other invoices and invoice lines in the system which also contain the same project number and task – including the current invoice.
But if you are using Progress Assessments then the Value Completed will be taken instead from a calculation of the %ge Completed field (and will not necessarily be equal to the billed valued to date.)
Previously Invoiced is automatically calculated from other invoices and invoice lines in the system (excluding the current invoice) which also contact the same project number and task.
Line Amount can be calculated from entering the %ge complete value, either in the invoice line, or in the task screen (as a progress assessment). Or you can enter the line amount manually for all progress claim lines.
Each of the fee column options above are visible from Edit Invoice Lines – some fields are editable, some are not.
To style the default layout and the titles of the columns within the invoice you’ll need to specify your requirements from Administration > Settings > Invoice Line Control Settings.
Whether each column is included in the invoice, the sizing, display order, column names(labels), and other styling is determined from here.
Header and Footer Descriptions
You can also style the progress claim column headers, totals and descriptions. Each claim can display one or more groupings of totals, the display of totals, and what you call your total lines can be specified here also.
Section Headers using Task Groups and Itemised Disbursements
If you wish to automatically create titles for the task and disbursement claim sections within the invoice you can use task groups.
Tips for using Progress Claims
What if I’ve created an invoice for a project that wasn’t a progress claim – but I want to include the details of this invoice in the ‘previously invoiced column’ for future claims?
If you have previously created an invoice for the project that was not a progress claim, you can adjust this previously invoiced amount, and optionally update the task fee estimate at the same time.
In the example below an additional $2,000.00 was billed prior to the automatically generated progress claim invoices, but was omitted from the task estimate for the project. The previously invoiced amount, and the task value are both increased by $2,000.00
Abtrac KB# 2085