Define the rules of how Supplier Expenses will be transferred to Xero using Connect. Supplier expenses will be sent to Xero using Connect when they are disbursed against a Synergy Project or against the <Office> Project .
Setup required before use | Who Can Use It? | Where Is It? |
---|---|---|
Administrator System Administrator |
Connect > Xero Connect > Run Connect > Supplier Expense Settings |
Tips:
Xero Connect will transfer any Supplier Expenses from Synergy to Xero. Use the Xero Connect Supplier Expense Settings to select which Xero Account Code, Inventory Item, and Item Description will be shown in Xero for each disbursement row of the supplier expense transferred from Synergy. Separate settings are available for expenses disbursement against a Synergy Project or the <Office> project. Extra setting available to send the disbursement notes to appear as a $0 line item within the Xero Purchase record. Supplier (Bills) can only be exported to Xero if the Synergy record is fully disbursed and 'locked'.
Use the filter options to control if all available supplier expenses will be sent in the sync, or if only expenses for a certain project manager or office location will be included in this Xero Connect sync run.
Enable the import of Supplier Expense Payments from Xero to Synergy, and an additional tab is shown in the Xero Connect Preview window. The payment date, and note details are imported from Xero. Supplier (Bill) payments can only be imported from Xero if the bill record is locked in Synergy.
Control how Supplier Expenses entered in Synergy will be transferred to Xero, and if payments will be imported to Synergy.
Synergy supplier expense details can be exported to Xero. Use the Supplier Expense Settings screen to control how data for Project and <Office> Project disbursed expenses is sent to Xero:
Export Supplier Expenses - Enable this setting for the sync to Xero.
A Bill must have the following three conditions met for the bill disbursement rows to be shown in Connect Preview:
Click the image above to see the data required in a bill for it to be exported via Connect.
Complete the following steps to configure the settings to send Supplier Expenses to Xero:
Check the 'Export Supplier Expenses' box to have the Synergy Supplier Expenses transferred to Xero using Connect. Supplier Expenses will be added to the Purchases > Bills List within Xero. A supplier expense will be shown as available for exported if the full amount has been disbursed against a Synergy project or the internal <Office> project.
When Export Supplier Expenses is enabled the settings for Project and Office Line Items must both be defined.
Tip: Learn more about entering Supplier Expenses using Expenses (Invoices / Bills).
Each Supplier Expense in Synergy that is disbursed against a Project will used these settings. Configure each of the options below before running the Xero Connect interface.
This setting controls what is used as the Xero Inventory Item when Supplier Expenses are sent to Xero. The Inventory Items in Xero control what is shown as the 'item code' on each row added to the Bills in Xero. Inventory Items are optional for entry within Xero, and due to this we allow an option for no Inventory Item to be sent in the sync.
When the sync is run if the Inventory Item in Xero does not exist, this will be created. Xero Inventory Items can be found in Xero > Settings > Inventory Items.
The Supplier Expense Inventory Item options are:
Tip: The inventory item description does not get displayed on the expense. The description is overwritten by the selection in "Option 3 - Choose what will be shown as the line description" below.
The Account Code is used to define which expense account the supplier expenses data will be transferred to in Xero. The default Xero setup has one Expense Account with the Account Code #300. However you may have setup multiple revenue accounts in Xero, to track different expense types for different office locations or types of business. Use the account code setup to ensure that the different types of supplier expenses are sent to the correct account in Xero.
Tips:
Option | Supplier Expense Line Item Option | Account Code Option | What is it used for? | Steps to use this setting |
---|---|---|---|---|
1 |
Discipline |
From Item |
Extract the account code from the Discipline attached to the Synergy Project / Sub Project. The Discipline 'Account Code' field must contain the Xero expense account code. |
|
2 | Cost Centre | From Item |
Extract the account code from the Cost Centre attached to the Synergy Project / Sub Project. The Cost Centre 'Account Code' field must contain the Xero expense account code. |
|
3 | Expense Type | From Item |
Extract the account code from the Expense Type chosen on the supplier expense disbursement line. The Expense Type 'Account Code' field must contain the Xero expense account code. The Expense Type Account Code is entered in the Xero Connect Preview window only. |
|
4 | Xero Item | From Item | The account code is used that is already attached to the Xero Inventory Item selected. |
|
5 |
Project |
Always Generate |
The account code must be defined using the custom account segment options. Learn more about how to define the custom account segments. |
|
6 |
Discipline |
Generate |
The account code must be defined using the custom account segment options. Learn more about how to define the custom account segments. |
|
7 | Cost Centre | Generate |
The account code must be defined using the custom account segment options. Learn more about how to define the custom account segments table. |
|
8 | Expense Type | Generate |
The account code must be defined using the custom account segment options. Learn more about how to define the custom account segments. |
|
9 | Xero Item | Generate |
The account code must be defined using the custom account segment options. Learn more about how to define the custom account segments. |
|
10 |
None |
Not Required |
If the 'None' option is chosen then no inventory item will be created in Xero. A custom account code must be defined using account segments. Learn more about how to define the custom account segments below this table. |
|
Choose what description will be shown on each Xero row added to a supplier expense row.
The available options are:
Tip: Send the 'disbursement line notes' to appear as a $0 line in the Xero Purchase record. Check the 'Display the disbursement notes as a zero value line item' option to enable this feature. Then other Synergy Supplier expense (Bills) detail from the disbursement like Sub Project can be configured to show on the expense line.
Each Supplier Expense in Synergy that is disbursed against the <Office> project will used these settings. Configure each of the options below before running the Xero Connect interface.
This setting controls what is used as the Xero Inventory Item when Supplier Expenses are sent to Xero. The Inventory Items in Xero control what is shown as the 'item code' on each row added to the Bills in Xero. Inventory Items are optional within Xero, and if the option of 'None is selected then this details is not sent.
If the Inventory Item in Xero does not exist, this will be created when the Xero Connect interface is run. Xero Inventory Items can be found in Xero > Settings > Inventory Items.
The Supplier Expense Inventory Item options are:
Tip: The inventory item description does not get displayed on the expense. The description is overwritten by the selection in "Option 3 - Choose what will be shown as the line description" below.
The Account Code is used to define which expense account the supplier expenses data will be transferred to in Xero. The default Xero setup has one Expense Account with the Account Code #300. However you may have setup multiple revenue accounts in Xero, to track different expense types for different office locations or types of business. Use the account code setup to ensure that the different types of supplier expenses are sent to the correct account in Xero.
Tips:
Option | Supplier Expense Line Item Option | Account Code Option | What is it used for? | Steps to use this setting |
---|---|---|---|---|
1 | Xero Item | From Item | The account code is used that is already attached to the Xero Inventory Item selected. |
|
2 |
Expense Type |
From Item |
Extract the account code from the Expense Type chosen on the supplier expense disbursement line. The Expense Type 'Account Code' field must contain the Xero expense account code. The Expense Type Account Code is entered in the Xero Connect Preview window only. |
|
3 |
<Office> |
Generate |
The account code must be defined using the custom account segment options. Learn more about how to define the custom account segments. |
|
4 | Xero Item | Generate |
The account code must be defined using the custom account segment options. Learn more about how to define the custom account segments. |
|
5 |
Expense Type |
Generate |
The account code must be defined using the custom account segment options. Learn more about how to define the custom account segments. |
|
6 |
None |
Not Required |
If the 'None' option is chosen then no inventory item will be created in Xero. A custom account code must be defined using account segments. Learn more about how to define the custom account segments below this table. |
|
Choose what description will be shown on each Xero row added to a supplier expense row.
The available options are:
Tip: Send the 'disbursement line notes' to appear as a $0 line in the Xero Purchase record. Check the 'Display the disbursement notes as a zero value line item' option to enable this feature. Then other Synergy Supplier expense (Bills) detail from the disbursement like Sub Project can be configured to show on the expense line.
Filters can be used to stop a selected group of supplier expenses from being sent to Xero.
For example: Stop all supplier expense from appearing in the Connect Preview Window for the 'Sydney' Office Location. This will stop the transfer of Sydney office supplier expenses to Xero, and allow all other office locations data to be sent.
Tip: Remove the filter in the edit screen using the eraser button on the filter row.
Setup the account segments to always send the expense data to the same Xero Expense Account. This can be done using the 'Fixed Value' account segment option. The steps below would be required if you also wanted to display the 'Expense Type' as each Xero inventory item.
Step the fixed account code using a single segment by:
A company has two directors, and requires to track the cost of expenses for each director separately in Xero. Each of the directors works across the companies three business disciplines: Architecture, Landscape Design, and Interior Design. The expense cost for each of the disciplines also needs to be tracked separately in Xero for each director. In Xero this is managed by creating a separate account code for each required Xero Inventory Item, and a separate Xero Direct Costs Account (Bank Account) for each director / discipline.
The 'Inventory Item' of Discipline will be used, and the account segments are create to extra the account code for Xero from an alternate location. A sample of these codes are shown below:
Director - Discipline | Cost Centre | Discipline Code | Account Code |
---|---|---|---|
Director A | |||
Architecture | A | Arch | A-Arch |
Landscape Design | A | LS | A-LS |
Interior Design | A | ID | A-ID |
Director B | |||
Architecture | B | Arch | B-Arch |
Landscape Design | B | LS | B-LS |
Interior Design | B | ID | B-ID |
Click the image above to view multiple account code segments.
Tips:
Check the 'Import Paid Status from Xero' check box in the supplier expense window and the supplier expense payments that will be imported to Synergy from Xero. Import the payment flag for the supplier expenses in Synergy to easily keep track of which items have been paid in full in Synergy, without having look the item up in Xero. If this option in unchecked then the 'Supplier expense payments' tab is not shown in the Xero Connect Preview window.
Payments are only imported when the Xero Bill is marked as paid in full. Partial Xero Bill payments are ignored and not shown in the preview. The Xero payment date and note are imported to the Synergy supplier expense (as shown in the image below).
Click the image above to view an imported supplier expense payment.
Tip: Supplier (Bill) payments are only imported to Synergy when the Bill record in Synergy is locked.
Change Description | Changed Within | Result |
---|---|---|
The supplier expense has been entered in Synergy, but is not shown in the interface to Xero. |
Synergy |
All supplier expenses must be disbursed against a Project before they can be seen in the Xero Connect Preview screen. If the expense is not related to a Project, then disburse the expense against the <Office> project. |
An expense has been marked as paid in Synergy. Will this be interfaced to Xero? |
Synergy and Xero |
No, if you mark an expense as paid in Synergy this information will not be sent to Xero. If you mark an expense as paid in Xero that can be imported back to Synergy. |
The expense description was entered in Synergy. Can this be seen in Xero. |
Synergy and Xero |
No, the Synergy 'Description' field from the supplier expense is not interfaced to Xero. There is no matching field available in Xero to interface this data to. |
A different billing option and markup rate has been applied to the disbursement line of the supplier expense. Will this effect the interface to Xero? |
Synergy and Xero |
No, the interface to Xero will not be affected by these changes. The disbursement lines will still be interfaced to Xero with the correct value of the Supplier Expense received shown. |
A negative expense has been entered in Synergy. |
Synergy |
The negative expense will still be sent across to Xero in the next sync, if the 'From Date' in the Connect Wizard allows it. |
A supplier expense has been entered, and also marked as 'inactive' in Synergy. Can this be excluded from the Sync? |
Synergy |
All Supplier Expenses are shown in the Connect Preview Screen by default. To remove 'inactive' supplier expenses to be sent to Xero add the filter 'Expense Is Active' to the settings screen. This will make sure that any expense marked as inactive is not sent to Xero. |
A supplier expense has been entered, but it is not showing in the preview for the sync. |
Synergy |
Supplier expenses are only valid to be exported using Connect if they have been fully disbursed and 'locked'. Make sure the full value of the expense has been disbursed against a project, and then use the 'lock' option on the bill. This will allow the bill to be exported from Synergy to Xero. |
The expense in Synergy has been assigned to the 'Unallocated Costs' sub project. |
Synergy |
An error will be displayed in the Preview the Sync window. The expense will need to be adjusted to be assigned to a valid sub project before it can be interfaced with Xero. |
The tax rate entered against the Bill disbursement lines is different to the sub project. Which will be sent to Xero with the Supplier / Bill? |
Synergy |
The 'tax code' entered on the disbursement line of the Supplier / Bill will be sent to Xero. (Synergy 4.9.4 or higher release). This change was implemented in the 4.9.4 release and the sub project tax code is no longer used by Connect when exporting Bills. In prior Synergy releases, each Supplier Expense disbursement line can have a 'tax rule' selected when it is assigned to the <office> project. For <Office> items that tax code is sent for the bill. For project disbursement items the tax code exported is from the Sub Project. |
The supplier expense contains multiple rows that are all disbursed against the same Project / Sub Project / Rate / Expense Type combination. |
Synergy |
Xero will display a separate line for each disbursement row entered on the Supplier Expense. The disbursement rows will not be grouped together within Xero, even if the data matches. |
The expense has been renumbered in Xero. |
Xero |
The expense will be shown again within the Synergy Connect preview window to be re-sent to Xero, as the expense bill number does not exist. |
The expense has already been sent to Xero, and the value of the expense has been amended in Synergy. |
Synergy |
The expense will not be re-sent to Xero. Manually adjust the record in Xero, to match the updated record in Synergy. |
Exclude two contacts from having their supplier expenses being sent to Xero. | Synergy |
In the Xero Connect > Supplier Expenses wizard screen setup a filter to exclude the contacts.
The filter with the AND join will stop both the contacts supplier expenses from being sent to Xero. TIP: Keep the join as AND, do not change it to OR. |
Supplier Expense 'XYZ' for $ (ex tax) failed to export: Invoice not of valid status for modification. | Xero | The supplier expense sent in the Sync has already been created manually in Xero. To remove this warning from the Xero sync results, either skip the supplier expense row in the Synergy Xero Connect Preview screen, or delete the supplier expense from Xero to allow the sync from Synergy to add the record. |
Tip: View the Supplier Expenses transferred from Synergy in Xero within Purchases > Bills.
Looking for more help? Try reviewing the following topics: View Topics
© 2019 Total Synergy Pty Ltd