What connections do
The Connections page lets you link Project Commander to external systems. Once connected, data such as accounting accounts, contacts, and VAT rates can sync between systems, reducing double-entry and keeping your records aligned.
This page is available to Super Admins only. If you need a connection set up, ask your Super Admin to configure it.
Available integrations
Accounting platforms
| Card | What it does |
|---|---|
| Xero | A live connection. Brings in your contacts, VAT rates and chart of accounts, and sends your documents to Xero. |
| Sage Accounting | The same as Xero, for Sage's online accounting software. |
| Sage 50 | No live connection. Switches on the Daybook, where you export your transactions to load into Sage 50 yourself. |
You can connect to Xero or Sage Accounting, not both. If you connect one, Project Commander disconnects the other automatically.
When Xero or Sage Accounting is connected, these documents are sent across:
- Invoices and Sales Credit Notes
- Supplier Credit Notes
- Purchase invoices from Invoice Checking
- Direct Invoices and Direct Credit Notes
- Subcontractor Payment Notices, Subcontractor Invoices and Subcontractor Work Records
- Contacts — your Clients and Suppliers
While Xero or Sage Accounting is connected, or Sage 50 is switched on, the Cash Received page is hidden in every project.
Vehicle tracking
| Platform | What it provides |
|---|---|
| RAM Tracking | GPS vehicle and asset tracking data |
The RAM connection card works the same way — authenticate with RAM to enable location tracking features within Project Commander.
Connecting to Xero or Sage Accounting
- 1
Navigate to Settings > System > Connections.
- 2
On the Xero or Sage Accounting card, click Connect.
- 3
You will be redirected to the provider's login page. Sign in with your accounting credentials and authorise Project Commander to access your data.
- 4
After authorisation, you are returned to the Connections page. A message reads Congratulations! You have successfully connected to Xero (or Sage), and the card shows Connected to followed by your organisation's name.
Connecting or disconnecting an accounting platform affects the entire company. All users will see the synced data. Make sure you are connecting to the correct organisation within your accounting software before authorising.
Bringing your data across
Connecting does not copy your records across on its own. Run a sync to bring in your contacts, VAT rates and chart of accounts.
- 1
On the connected card, click Sync with Xero (or Sync with Sage).
- 2
Keep the page open while it runs. It imports your contacts first, then your tax rates, then your chart of accounts.
- 3
Wait until the card says Xero Sync Complete (or Sage Sync Complete).
If the card says Xero Sync Failed or Sage Sync Failed, click Try Again.
Once the sync is complete:
- Accounts from the provider appear on the Accounts settings page.
- VAT rates from the provider appear on the VAT Rates settings page.
- Your customers and suppliers appear as Clients and Suppliers.
After the first sync, Project Commander checks Xero or Sage for new and changed records every 15 minutes. You can also run the sync again at any time.
Checking the connection
The Xero and Sage Accounting cards show where the connection stands.
| The card shows | What it means | What to do |
|---|---|---|
| Not connected to Xero (or Sage) | There is no connection. | Click Connect. |
| Connected to your organisation's name | The connection is working. | Nothing. |
| Connected to your organisation's name (expires soon) | The connection is still working, but its sign-in will run out soon. | Keep working. If the card changes to Token expired, reconnect. |
| Your organisation's name - Token expired | The connection has stopped working. | Click Reconnect to Xero (or Reconnect to Sage) and sign in again. |
Switching on Sage 50 export
Sage 50 is the desktop version of Sage. It has no live connection, so there is nothing to sign in to. Instead, you switch on the Daybook, which exports your transactions in a file you load into Sage 50.
- 1
On the Sage 50 card ("Allow Sage 50 CSV export"), click Enable.
- 2
Check that the card now shows Enabled.
A Daybook item then appears in the sidebar under Company. See Daybook for how to export. To switch it off, click Disable on the same card.
Sage 50 accounts do not come across automatically. To use your Sage 50 nominal codes, import them on the Accounts page.
Setting default accounts
The Default Accounts button at the top right of the Connections page sets the account, VAT code and payment terms that are filled in for you on new documents. You can still change them on each document.
- 1
Click Default Accounts at the top right of the page.
- 2
Pick the defaults you want in each section — see the table below.
- 3
Click Save.
| Section | Used on | Fields |
|---|---|---|
| Sales | Invoices and Sales Credit Notes | Default Sales Nominal / Account, Default Sales VAT code, Default Payment terms |
| Purchases | Invoice Checking, supplier Credit Notes, Direct Invoices and Direct Credit Notes | Default Purchase Nominal / Account, Default Purchase VAT code, Default Payment terms |
| Subcontractors | Subcontractor Invoices and Subcontractor Work Records | First row: Default Purchase Nominal / Account, Default Purchase VAT code, Default Payment terms. Second row, for subcontractors under CIS (the Construction Industry Scheme): Default CIS Tax Nominal / Account, Default Subcon VAT code, Default Payment terms |
Disconnecting
- 1
On the Xero or Sage Accounting card, click Disconnect.
- 2
In the Disconnect from Xero? (or Disconnect from Sage?) window, click Disconnect to confirm.
Existing synced data remains in Project Commander but will no longer update. To sync again, you need to connect again.
Next steps
- Accounts — view the accounts synced from Xero or Sage, or import your own.
- VAT Rates — manage VAT rates, including those synced from your accounting platform.
- Payment Terms — set up the payment terms you can pick as defaults.
- Daybook — export your transactions to Sage 50.