Getting started with Xero
This article covers the steps that need to be followed to establish the connection between Projectworks and Xero. It also covers the mappings that need to be set up so the data can flow accurately between both systems. The set up only needs to be done once and that will allow users with the required permissions to export invoices to Xero and reconcile Projectworks with Xero.
This article covers:
How to set up Projectworks
Setting up Projectworks to integrate with Xero is an administrator task and is done on the Integration - Accounting page within the Admin section. Setting up the Xero connection is a one off task and Projectworks will remain connected to Xero as long as the credentials remain valid.
Before you start you will need:
- The credentials for Xero
- To understand what Projectworks GL Codes map to Xero Account Names
Connecting to a Xero organisation (authorising connection)
How to Connect to a Xero organisation
Connecting Projectworks to your Xero organisation is easy. The connection is initiated from the Integration - Accounting page in the admin section.
- Click "Connect to Xero"
- Enter the credentials for Xero
- Select the Xero organisation you wish to connect to
This will establish the connection between Projectworks and Xero for the selected Organisation. To complete the integration a number of mappings need to be set to enable the correct data in Projectworks and Xero to be aligned.
Using multiple Xero organisations
Projectworks can be configured to connect to multiple Xero organisations. This is useful if you are running separate General Ledgers for offices/locations within a single Projectworks instance. For example, within a single instance of Projectworks you have three offices set up; Wellington New Zealand, Auckland New Zealand and Seattle USA.
The Wellington and Auckland offices both use the same General Ledger while Seattle has their own General Ledger. Once multiple Xero organisations have been successfully connected to Projectworks, you can specify which Xero organisation a Projectworks office is associated to. This is done by editing the mappings for the Projectworks Offices.
Set Xero organisation mappings
Once Projectworks has been connected to Xero and authorised you need to set up various mappings. The mappings are needed to link the relevant pieces of information in Projectworks to the corresponding entries in Xero. The mappings only need to be set up once but can be edited at any time.
Mapping Reference Field
Projectworks invoices include a reference field. This is typically used to include the Purchase Order from the customer which relates to the work conducted. This is important to show on the invoice that goes to customers, but may not necessarily be the most relevant piece of data to export to Xero.
For each office in Projectworks you can choose to either map the Projectworks Reference or the Projectworks Project Name to the Xero Reference Field.
Specify which piece of Projectworks data will be used for the Xero Reference field.
Note: Each office can be configured to use a different reference field if required.
Mapping tax types
Tax Types are set up in Projectworks to allow the correct tax types and rates to be applied to invoices generated within Projectworks. Tax Types are also set up and managed within Xero and used for invoices generated from within Xero. The same set of tax types don't need to exist in each system, however linking the tax types in both systems allows for seamless integration as data moves between systems.
To map the Tax Types you need to choose the Xero Tax Type that corresponds to the Projectworks Tax Type:
Note: It isn't mandatory to map every Projectworks Tax Type to a Xero Tax Type. If required you can also have multiple Projectworks Tax Types mapped to the same Xero Tax Type.
Mapping GL Codes
GL Codes are set up in Projectworks to categorise revenue from invoices. The GL Codes should align with GL Codes within your accounting system (Xero). Each invoice line on a Projectworks invoice is tagged with the GL Code and when exported to Xero ensures that revenue is correctly categorised and to the appropriate Xero account name (GL Code). The same set of GL Codes don't need to exist in each system, however linking the GL Codes in both systems allows for seamless integration as data moves between systems.
To map the GL Codes, you need to choose the Xero Account Name that corresponds to the Projectworks GL Code:
Project Works can accommodate multiple currencies for budgets and invoices. This allows different offices or projects to have their financials tracked in the appropriate currency. There is no need to map the currencies from Projectworks to Xero as both systems have the same master set of currencies. To have multiple currencies set up for your Xero organisation you need to have bank accounts that can accept each currency.
Note: Only invoices for a currency which exists in Xero can be exported from Projectworks