What Subcontractor Work Records are
A Subcontractor Work Record logs work a subcontractor has done for you. It holds a list of lines. Each line has its own project, cost code and date, so one work record can cover several projects.
A work record is not linked to a Subcontractor Order. It starts as Open. You add the lines, apply it to the projects, then click Post when it is finished.
| Status | Meaning |
|---|---|
Open | A new work record. You can add, change and remove lines. |
Posted | Finished. The lines are locked. To change it, revise it. |
Revised | Replaced by a newer copy. Shown crossed out in the list. |
Where to find it
Click Subcontractors in the main sidebar, then click Work Records under Subcontractor. Work records are company-wide — there is no Work Records link inside a project.
Work Records has its own Subcontractor Work Records module on the RBAC screen. View shows Work Records in the sidebar. Create shows the New Work Record button.
Viewing work records
The Subcontractor Work Records table lists every work record, newest first.
| Column | What it shows |
|---|---|
| # | The work record number — it starts with SWR unless you have changed the prefix. Click it to open the work record. |
| Reference | The reference you gave it |
| Status | Open, Posted or Revised |
| Subcontractor | Who did the work |
| CIS Scheme | Yes if the work is under the Construction Industry Scheme (CIS) |
| Labour, Total Before Tax, Total Tax, Total After Tax | Figures saved from the work record's Apply to form. The totals at the bottom leave out Revised work records. |
| Created By | Who created the work record |
| Applied to | Ticks under Applications, Budget and Buying List show the work record has been applied. See Applying a work record to the projects below. |
Filter by Subcontractor, Status, CIS Registered or Created By to narrow the list.
Click Generate Report above the table to print a summary of the work records the table is showing. Choose PDF or DOCX.
Creating a work record
- 1
Click New Work Record in the top-right corner.
- 2
Select the Subcontractor. Their Type fills in, and Work undertaken is part of CIS scheme is ticked if they are CIS registered.
- 3
Check the Type. Choosing a Type first narrows the Subcontractor list to that type.
- 4
Enter a Reference — for example, the subcontractor's own sheet number.
- 5
Set the Date. It starts as today.
- 6
Check the Work undertaken is part of CIS scheme tick.
- 7
Optionally add Internal Notes. These are not printed on reports.
- 8
Click Create. The new work record opens.
If you have no subcontractors yet, the form shows No Subcontractors found. Click Add a Subcontractor first to go to Subcontractors.
Compliance warnings
When you click Create, Project Commander checks the subcontractor's certificates, cards and insurance policies. If the work is ticked as CIS, it also checks their CIS registration. You see a warning if any of these have expired or expire within 30 days.
To carry on, click View, read the Warning Details, then click Accept. Click Cancel to go back and change the form.
Adding lines
- 1
On the work record, click New Subcontractor Work Record.
- 2
Select the Project.
- 3
Enter a Reference — a short description of the work. It shows in the Description column.
- 4
Enter the Quantity and Rate. The Total works itself out.
- 5
Set the Date.
- 6
Check the Cost Code. The list shows the project's labour codes (
L0001toL0005), andL0004is picked for you. Tick Show all cost codes to see the rest. - 7
Click Create.
For a fixed amount instead, turn on Flat Cost and enter the Total (£).
To add several lines in a row, tick Continue adding items? before you click Create. The form clears and stays open for the next line.
The lines table shows each line's Project, Description, Quantity, Rate, Value, Cost Code and Work Date. While the work record is Open, click a Description or Quantity to change it. To remove lines, tick them and click Delete.
Applying a work record to the projects
- 1
On the work record, click Apply to.
- 2
Choose Project.
- 3
Enter the Labour figure.
- 4
Check the CIS Tax %. It fills in from the subcontractor's Tax Treatment when the work is under CIS. Otherwise it is locked.
- 5
Check the Nominal Account, VAT Rate and Payment Terms.
- 6
Click Apply.
The other figures on the form — Work Record Value, Amount Taxable, VAT Amount, Tax Payable and Total Value — are worked out for you.
Nominal Account, VAT Rate and Payment Terms fill in from your company's Default Accounts on the Connections page, where they are set. On a CIS work record, Nominal Account and Payment Terms are locked.
When you click Apply:
- The work record's lines are added to each project's budget, against their cost codes.
- Ticks appear under Applications, Budget and Buying List on the list, and next to Project in the Apply to menu.
- The figures are saved to the Labour, Total Before Tax, Total Tax and Total After Tax columns on the list.
A work record's lines do not count towards the project budgets until you use Apply to > Project. You can do this before or after you post the work record.
Posting a work record
- 1
Open the work record.
- 2
Check that all the lines are there and correct.
- 3
Click Post in the top-right corner.
The status changes to Posted. The lines are locked, and New Subcontractor Work Record is no longer shown.
If your company has connected Xero or Sage on the Connections page, posting sends the work record to your accounting system. To send it again, click Sync to Xero or Sync to Sage in the header. After the first sync, the button reads Re-sync to Xero or Re-sync to Sage, and a coloured dot shows whether it worked.
Revising a work record
To change a Posted work record, click Revise in the header. Project Commander makes a new Open copy with all the lines, numbered with /R1 on the end. The original is marked Revised, and the new copy opens.
The new copy starts with no Applied to ticks.
Deleting work records
- 1
On the Subcontractor Work Records list, tick the work records you want to remove.
- 2
Click Delete above the table.
- 3
If you ticked more than one, click Delete again to confirm.
You cannot delete a Posted work record. You see Cannot delete Posted work records instead.
Next steps
- Subcontractors — set each subcontractor's Type, CIS registration and Tax Treatment.
- Budgets — see applied work record lines against each project's cost codes.
- Subcontractor Compliance — check every subcontractor's CIS, certificates and insurance in one table.
- System Prefixes — change the
SWRprefix and starting number for work record numbers. - Connections — connect Xero or Sage so posted work records are sent to your accounts.