To set up the Xero interface, you first need to establish, then enable, the connection between and your Xero account.
Establish the connection
To establish the connection between and your Xero organisation:
- On the toolbar click the Settings
icon.
- Select the Integrations tab.
- On the Xero tile, click Setup Integration.
- If prompted, log in to your Xero organisation. Once you have set up the Xero integration between your Xero and organisations, you will not need to log in again. prompts you to select one or more organisations for connecting to your organisation.
- If you have multiple Xero organisations, select the Xero organisation that you wish to integrate with your organisation.
- Do one of the following:
- If the organisation you selected has not been connected before, click the Allow access button.
- If one or more organisations have been connected before, click the Continue with [n] organisation(s) button.
displays the Xero Setup overview screen, Select Organisation.
Configure and enable the connection
You must specify the Interface Information to enable the connection, but you can select other options, as required, to control how data is transmitted between your accounts.
To configure and enable the connection between and your Xero account:
- On the Xero Setup screen in , provide the following information, as required.
-
Select Organisation (required)
In the Select Xero Organisation drop-down list, select the Xero organisation to integrate with your organisation and click Next.
-
Initial Configuration (required)
In Xero you may have a number of different income and cost of sale accounts that different streams of work are coded against – Consulting Income versus Fee Income, for example.
You can set up job categories or job tasks and costs in that use unique income and cost of sale accounts instead of the accounts specified below (for details, see Xero GL account codes and tracking categories).
The connection to Xero cannot be enabled until you specify the Income Account and Cost of Sale Account and select the appropriate Tax on Sales and Tax on Purchase.
Field Description Interface Information
Income Account This should be your default 'catch all' income account. For example 200 - Sales. This will be used where the account codes are not otherwise specified in .
The only Xero accounts displayed in the drop-down list are accounts of the "revenue" type.
Cost of Sale Account This should be your default 'catch all' cost of sale account. For example 300 - Cost of Sales. This will be used where the account codes are not otherwise specified in .
The only Xero accounts displayed in this drop-down are accounts of the "expense" type.
Tax on Sales Select the name of the tax to apply to goods or services you are selling to your clients. The name is picked up from the Accounting > Advanced > Tax rates section in your Xero account.
When the tax name information is set up in Xero, it is recommended that the name used for the tax includes the value of the tax itself. For example:
Including the tax rate in the name helps to ensure that you can select the correct rate if you have several possible rates available.
Tax on Purchase Select the name of the tax to apply to goods or services you are buying to on-sell to your clients. The name is picked up from the Accounting > Advanced > Tax rates section in your Xero account.
When the tax name information is set up in Xero, it is recommended that the name used for the tax includes the value of the tax itself. For example:
Including the tax rate in the name helps to ensure that you can select the correct rate if you have several possible rates available.
Default Tracking Category 1, 2 You can also use the Tracking category fields to link your job categories to Xero tracking categories. You can have up to two tracking categories active.
For example, you might set up your Catering - Weddings and Catering - Functions job categories so that they use a Xero tracking category called Sales Region. This would allow you to report (in Xero) on your catering work, broken down by region. You can have up to two tracking categories active at a time.
For further details, see Xero GL account codes and tracking categories.
Default Tracking Option 1, 2 The Tracking options correspond to the selected Tracking category. If the Tracking category is Region, for example, the Tracking options might be Northern, Central and Southern.
Update client & supplier details in Xero Specify when you want to update client and supplier details in Xero.
This is a one-way process: to Xero. For further details, see the paragraph on Synchronising and Xero.
-
Never
When this option is selected:
- New client and supplier details added into are never pushed across into Xero.
- Changes to existing client and supplier details are never pushed across from to Xero.
- If you issue a sales invoice or PO receipt in , a new client or supplier will be created in Xero, if a client with exactly that name did not already exist. However any details (such as phone, fax, street address and postal address) associated with that name in will not be added in Xero.
-
Only when uploading invoices
When this option is selected, client and supplier details (such as phone, fax, street address and postal address) will be created or updated in Xero when a sales invoice or PO receipt is pushed across into Xero. As sales invoices and PO receipts (Bills Payable) are transferred immediately across into Xero upon approval, client and supplier details will also update immediately.
-
Every time client or supplier details are updated
When this option is selected, client and supplier details (such as phone, fax, street address and postal address) will be created or updated in Xero when client or supplier details are updated in .
Client and supplier details in Xero will not update instantaneously - they will be updated as the servers process queues in order of priority. You should generally expect these details to update within 15 to 30 minutes.
'Details' includes phone, fax, street address and postal address, but excludes email address and website.
Contact person
Update Contact Person and Email when uploading invoices Because Xero allows only one contact person for each customer/supplier, if this checkbox is: - Selected. Every time an invoice is pushed to Xero, the contact person in Xero will be updated to match the selected contact on that invoice. If no contact is selected on the invoice, then the contact person in Xero will remain unchanged.
Use the Business > Invoices > (select an invoice) > Details tab to select or change the contact person for that invoice. If you want the change to be pushed to Xero, it must be made before the invoice is approved.
- Deselected. The contact person for each invoice will not be transferred across into Xero.
-
Never
-
Invoices
These configuration settings allow you to control what type of information is sent from to Xero when either an Invoice or Purchase Order Receipt is saved.
Field Description Export as If you select:
-
Draft, exported invoices will be saved in Xero in a draft state, and you'll find the invoices in the Business > Invoices > Draft section of Xero.
We recommend that, to start with, you select the Draft option. Manually approving sales invoices in Xero provides an additional opportunity to check your invoices while you are still getting used to the - Xero integration.
- Approved, exported invoices will saved in Xero in an approved state, and you'll find them in the Business > Invoices > Awaiting Payment section of Xero.
If an exported invoice is subsequently cancelled in , then the way the invoice is handled in Xero will depend on its status. For further details, see Cancel or delete an invoice.
Invoice Number Sequence If you select:
-
Xero, new invoices (or credit notes) will use the Xero numbering sequence rather than the numbering sequence.
For example, with this option selected, a new invoice is numbered INV-0376 (the next Xero invoice number) rather than I000342 (the next invoice number). Invoice number INV-0376 is used in both and, after export, in Xero. You would use this option to ensure that you have only one set of invoice numbers - useful if you also invoice directly from your Xero account. For details of how to change the numbering of Xero invoices, see Change numbering on sales invoices, credit notes, quotes and purchase orders.
For consistency, we encourage you to use the Xero invoice number sequence, which ensures that Xero numbering is applied to invoices created in both systems.
-
WorkflowMax, new invoices (or credit notes) will use the numbering sequence.
For example, a new invoice is numbered I000342 (the next invoice number). Invoice number I000342 is used in both and, after export, in Xero. You would use this option if you want to be able to identify the source of each invoice - or Xero. We recommend that you use a different prefix in to avoid any risk of duplicate invoice numbers. For details of how to change the numbering of invoices, see Edit organisation number sequences.
Invoice Description Include Invoice description... Select this checkbox to include the invoice description with the exported invoice. Details These options control the level of detail and information included in the invoice.
If you select:
- (default) Individual tasks and costs, the cost of each task and cost is included as well as the total value.
The text and {placeholders} shown in the Job Summary field are included with the invoice. Each placeholder will be replaced by the corresponding item's value from the database.
You can change the default text and use any of the following placeholders to format the job information transferred to Xero:
- {ClientOrderNumber} - the client order number from the job
- {JobNumber} - the job number
- {JobName} - the name of the job
- {JobDescription} - the job description
- {ClientName} - the name of the client
- {ContactName} - the name of the job contact.
To insert a new placeholder into the job summary, type its name in curly brackets exactly as shown in the above list.
Select Task Options as required. You can include the contents of the task's Description field for each invoiced task. You may wish to include tasks with zero value so that your client can see work that you are doing for them but not charging for (these are enabled by default).
Select Cost Options as required. You can include the contents of the cost's Notes field for each invoiced cost. You may wish to include costs with zero value so that your client can see the items you are not charging them for (these are enabled by default).
-
Job or miscellaneous invoice total, the total value of the invoice is consolidated as a single line. For job invoices, any text and {placeholders} (see below) in the Job Invoice Description box are included with the invoice. For miscellaneous invoices, any text and {placeholders} in the Miscellaneous Invoice Description box are included with the invoice.
-
Consolidated invoices - limitations and defaults
Please note that there are some situations where the consolidated invoice export won’t work for you. For example:
- If you map your tasks and costs line by line to accounts in Xero, or use the Xero tracking options at the task and cost level. In this case, will no longer map accounts at the task and cost level when you use the consolidated invoice export option. It will instead use the mappings set at the job category level, or if you are not using job categories, it will use the default mappings.
- If you have included your time sheet notes on the task (by setting the Time Sheet Notes field to Task Description or Task Description - Time Detail in the
> Settings > General Settings > Organisation Settings > Invoice section) then we don’t recommend that you use the consolidated invoice export setting at the job level without first changing this setting to something else. Otherwise, the resulting invoice will include the time sheets in the single field.
The content of exported miscellaneous invoices depends on the way the Miscellaneous Invoice Description field is set up:
- If the Miscellaneous Invoice Description field includes the {InvoiceDescription} placeholder, the exported miscellaneous invoice will always consist of a single line showing the invoice description and the total invoice value (regardless of whether the Include Invoice Description checkbox is selected or not).
- If the Miscellaneous Invoice Description field does not include the {InvoiceDescription} placeholder, but the Include Invoice Description checkbox is selected, the exported miscellaneous invoice will contain two lines: one for the invoice description (if there is one) and a second line for the Miscellaneous Invoice Description and the total invoice value.
-
Consolidated invoices - limitations and defaults
-
Phases, the phase names and the subtotal for tasks and costs in each phase is included in the invoice.
Enter any text and placeholders you require into the Job Summary field, for passing through to Xero. Select Phase Options, as required:
Select Show phase description to include the description for each phase. It may be worth including the description if phase titles do not generally provide a clear enough indication of the purpose of the phases.
Select Show phases with zero value to include any phases with a zero subtotal value. It might be worth including phases with a zero value to show that they have not been forgotten and may be included in a future invoice (or have been invoiced in a previous invoice).
Invoice Payments If you select Automatically import from Xero, will check Xero for any payments that have been applied to invoices within the last 14 days, and automatically import these into .
We recommend that you use this option.
Payments made in Xero will normally take several hours to appear back in .
-
Draft, exported invoices will be saved in Xero in a draft state, and you'll find the invoices in the Business > Invoices > Draft section of Xero.
-
Purchase Receipts
Field Description Purchase Order Bills
Export as If you select:
- Draft, then you will find the receipts in the Business > Purchases overview > Draft section of Xero.
We recommend that, to start with, you do not select this checkbox. Manually approving bills payable in Xero provides an additional opportunity to check your payable invoices while you are still getting used to the - Xero integration.
- Approved, receipts will be imported into Xero in an approved state. You'll find them in the Business > Purchases overview > Awaiting Payment section of Xero.
Purchase Order Details
Include purchase order details... If this checkbox is selected, you will be able to display all the Purchase Order Information listed in the Purchase Order Information field immediately below this checkbox. You can add text and/or merge fields from the list displayed in the Job Information field above.
Purchase Order Information If Purchase Order Details is selected, the text and placeholders shown in the Purchase Order Information field will be pushed across to Xero. Each placeholder will be replaced by the corresponding item value from the database.
You can change the default text and use any of the following placeholders to format the purchase order information transferred to Xero:
- {JobNumber} - the job number
- {JobName} - the name of the job
- {PurchaseOrderNumber} - the purchase order number
- {PurchaseOrderDescription} - the purchase order description.
Copy the text of the placeholder exactly, including the curly brackets. For example, {JobName} not {Jobname}.
- Draft, then you will find the receipts in the Business > Purchases overview > Draft section of Xero.
-
Xero Invoice Import (Premium Only)
Additional options are available for users with Premium accounts. These options control the way that invoices are imported from Xero. For further details of these options, see Import invoices from Xero (Premium only).
-
Select Organisation (required)
- Click Complete the setup. displays the Xero Configuration screen.
- Review and, if necessary, change any of the settings.
- When you're ready, Save your changes. confirms that you have successfully connected to the Xero organisation you selected.