What client records are for
Client records store the companies you work for. When you create a project, you assign it a client — and the client's default MCD and retention percentages are carried across automatically. Keeping your client list accurate saves time on project setup and ensures your financial documents reference the correct details.
Viewing clients
Navigate to Settings > Data > Clients. The table shows all active clients in these columns:
| Column | What it shows |
|---|---|
| Source | A logo showing whether the client is linked to Xero or Sage, or held only in Project Commander |
| Name | The client's company name |
| VAT # | VAT registration number |
| UTR | HMRC unique tax reference |
| Registration # | Companies House registration number |
| Default MCD % | The main contractor's discount (MCD) copied onto new projects for this client |
| Default Retention % | The retention percentage copied onto new projects for this client |
| Account # | Your reference for this client in your accounts software |
| Projects | How many projects use this client |
The address and payment terms are not in the table. You see and change them with Modify — see Editing a client.
Use the Status filter to narrow the list, or type in the search box to find a specific client. To see archived clients, open View and tick Show Archived.
Creating a client
- 1
Click New Client in the top-right corner of the page.
- 2
Fill in the client details:
Field Required Description Name Yes The client's company name Account Number No Your reference for this client in your accounts software. The Daybook export uses it to match the client in Sage 50. VAT Number Yes VAT registration number Unique Tax Reference Yes HMRC unique tax reference Registration Number Yes Companies House registration number Default MCD Percentage Yes The main contractor's discount (MCD) copied onto new projects for this client Default Retention Percentage Yes The retention percentage copied onto new projects for this client Payment Terms (Days) No Default payment terms in days Address Line 1, Address Line 2, Town / City, County, Postcode No The client's address - 3
Click Create to save the new client.
The MCD and retention defaults fill in automatically when you pick this client on a new project. You can change them on the project itself.
Editing a client
Click into any editable cell in the table to update a client's details inline. Changes are saved automatically.
To change the address, the payment terms, or several fields at once, use Modify:
- 1
Tick the box at the start of the client's row.
- 2
Click Modify above the table.
- 3
Change the details, including the address.
- 4
Click Save.
Importing clients from CSV
If you have a large number of clients to add, you can import them from a spreadsheet.
- 1
Click Import/Export in the top-right corner.
- 2
Click Download CSV Template if you do not already have one.
- 3
Fill in the template with your client data.
- 4
Drop the file into the box, or click Select a File.
- 5
Click Import Clients.
Archiving and restoring clients
To archive a client, click the archive icon at the end of its row. To archive several clients at once, tick them, click Archive above the table, then click Archive again to confirm. Archived clients are hidden from the default table view and from dropdowns when creating projects.
To restore an archived client, open View and tick Show Archived. Then click the unarchive icon at the end of its row.
Archiving a client does not affect existing projects assigned to that client. It only removes the client from future selection lists.
Next steps
- Suppliers — manage your supplier and subcontractor records.
- Employees — manage your employee list and assign project manager or site manager roles.
- System Defaults — set default MCD and retention percentages at the system level.
- Daybook — export your documents to Sage 50, matched on each client's Account Number.