Account codes are used to map the location that data will be sent to in MYOB AccountRight Live for invoices, credit notes, supplier expense payments, and staff expenses. Review the advanced account code mapping options in this topic.
Setup required before use | Who Can Use It? | Where Is It? |
---|---|---|
Administrator System Administrator |
Connect > MYOB AccountRight Live Connect |
The following account code mapping options are available to use with MYOB AccountRight Live Connect. Account codes allow you to define which area or account in MYOB the invoice or expense data will be linked to, for each item that is created by Connect. It is required that an account code mapping be selected before Connect can be run.
The table below is a summary of the options available for invoices and expenses to be sent to MYOB AccountRight Live. Advanced options such as attributes, cost centres, disciplines, and expense types can be used to ensure Invoices and Expenses are allocated to the appropriate account codes in MYOB.
Account code option |
Invoices options |
Supplier Expenses options |
<Office> supplier expenses options |
Staff expenses options | <Office> staff expenses options |
---|---|---|---|---|---|
Fixed Value |
|
|
|
||
Contact |
|
|
|
||
Contact attribute |
|
|
|
||
Project attribute |
|
|
|
||
Staff attribute | |||||
Discipline |
|
|
|
||
Cost Centre |
|
|
|
||
Expense Type |
|
|
|
Add the account code mapping in connect on the invoices, supplier expenses, or staff expenses tabs by clicking the 'edit' button in the account code section of the page. Based on the option selected, further setup in Synergy will be required before you can run Connecct.
Account code option | Setup in Connect required | Further setup in Synergy required |
---|---|---|
Fixed Value |
Enter your income code as set in MYOB including the dash |
No further setup required. |
Contact |
- |
Extra setup is required. Ensure that account codes have been entered to all the items for the option selected. e.g. Enter an account code against all cost centres, disciplines, or expense types. |
Contact attribute |
Select the attribute group to be used from the drop down list. |
|
Project attribute |
Select the attribute group to be used from the drop down list. |
|
Discipline |
- | |
Cost Centre |
- | |
Expense Type |
- |
Alternate option: Add a fall back account number for MYOB. If the entered account number cannot be found, then the alternate value will be used in its place. Then if the contact, attribute, discipline, expense type or cost centre doesn't have an account code allocated to it, the connect sync for invoices / expense can still be run without error.
Review the steps below for an overview of how to setup the account codes in Synergy for the type that you want to map again:
Commonly used for sending invoice and credit data to MYOB. Disciplines and Cost Centres are attached to all sub projects in Synergy. This option is also available for sync-ing expenses, but is most commonly only used for mapping where invoices will be linked to in MYOB with the account code.
Commonly used as the mapping option for both Supplier and Staff expenses. This option is only available for mapping the sync of expenses (not invoices and credits).
Tip: If you use the mapping option of 'discipline' or 'cost centre' for invoices then they cannot be used for expenses. Due to this it is recommended that the 'expense type' option be used for mapping where supplier are staff expenses are sent to in MYOB.
In the account code select window you can double click the existing 'account code segment' to edit it and choose an alternate value. Or you can select the 'New Segment' button in the table and then choose one of the following account segment source options:
All items will be allocated to the one account in MYOB. If this option is selected in the 'invoice settings' tab then all invoices, credit notes, and invoice payments will be exported using this account code. If selected on the 'supplier expenses tab' then all supplier expenses (bills) will be exported to this account. If selected on the 'staff expense settings' tab then all staff cash and travel expense will be exported to this account. A different fixed value account can be selected for each type - invoices, suppliers, and staff.
Use this option if the account code has been entered in the 'Account Code' field on the Synergy Contact. This allows every contact record in Synergy to have a different account code setup, to be used to map either invoice or project supplier expense data to MYOB. This option is not available for <Office> supplier bills or staff expenses. Locate Contact account codes topic to learn more.
An account code can be stored on a Contact Attribute in Synergy. This attribute must then be assigned to each Contact in Synergy. It is recommended if this option is used that the contact attribute is setup as a 'mandatory attribute'. Within Default Data > Attributes you will store the account code. The entire item (invoice or expense) will be sync'd to the single account as attached to the Attribute. Used to map either invoice or project supplier expense data to MYOB. This option is not available for <Office> supplier bills or staff expenses.Locate Attach Attributes to learn more.
Tip: This option cannot be used if you disburse supplier expenses or enter staff expenses against the <office> project.
An account code can be linked to a Project attribute. This attribute must then be entered against every project that will be invoiced or have expenses. Therefore if this option is used we recommended that the attribute be set as a mandatory attribute. Within Default Data > Attributes you will store the account code. The invoice / expense data is then allocated to one account code. When disbursing an expense to multiple projects, the sync will use the disbursement line details to transfer that disbursed portion of the expense to the matching account code.
Used to map either invoices, or project allocated supplier or staff expense data to MYOB. This option is not available for <Office> supplier bills or <office> staff expenses. Locate Attach Attributes to learn more.
Tip: This option cannot be used if you disburse supplier expenses or enter staff expenses against the <office> project.
Enter account codes against each of the disciplines, which are setup in default data. Each sub project created in Synergy is allocated a discipline and this is commonly used for transferring invoice data to map the account code location in MYOB AccountRight Live. When the invoice line is created for a sub project, the invoice (or credit) will sync to the account code setup for that discipline. If the invoice is created for multiple sub project then each invoice line will appear lined to the different setup account code within the on MYOB invoice. Locate sub project discipline to learn more.
Tip: This option cannot be used if you disburse supplier expenses or enter staff expenses against the <office> project.
Cost centre mapping is commonly used for sending invoice data to MYOB. If account codes have been entered against all the cost centres, then select the option cost centre from the drop down list. Each invoice line will be sent to matching account in MYOB, based on the cost centre allocated to each sub project. When used by supplier expenses, the cost centre used is taken from the sub project on the disbursement line.
Tip: This option cannot be used if you disburse supplier expenses or enter staff expenses against the <office> project.
An account code can be stored against each of the expense types, so that when supplier or staff expenses are sync'd that the created purchase record is linked to a different expense accounts in MYOB, such as Cost of Sales or Expense accounts. When disbursing an expense to multiple projects, the sync will use the disbursement line details to transfer that disbursed portion of the expense to the matching account code. Locate Expense Types to learn more.
Tip: This option cannot be used if you disburse supplier expenses or enter staff expenses against the <office> project.
Tip: If you're utilising Disciplines for Invoices syncing, you won't be able to use Disciplines for Expenses - this is the case with all fields the can be used for mapping account codes (Attributes, Cost Centre, Expense Type).
The fixed value and attribute options allow you to sync transactions to a single account code. With these options each Invoice or Expense may not be broken down across multiple account codes.
If multiple sales income, or expense accounts exist in MYOB then the options that allow multiple account codes should be used for the connect mapping. These are discipline, cost centre, and expense type.
Once you have selected the invoice / expense source breakdown level, you will need to choose which account code the data should be allocated to. The account segments table allows you to create an account code that is made up of one source or several different sources. For example the account code is created using the segments of 'Cost Centre' and 'Expense Type'. Use the arrow icons to adjust the order of the segments within the supplier expense account table.
Invoice # SY000095 has work for Engineering services and Architectural services. The project has been setup with 2 sub projects, and the disciplines Engineering and Architecture are attached to sub project 1 and 2 respectively. MYOB has 2 different account codes for each of the 2 service types for project work. Using the mapping option of 'discipline' each type of business is sent to a different account number in MYOB.
Single account code |
Can split invoice / expense to multiple account codes |
|
---|---|---|
Fixed Value |
|
|
Project attribute |
|
|
Contact attribute |
|
|
Staff attribute |
|
|
Contact |
|
|
Discipline |
|
|
Cost Centre |
|
|
Expense Type |
|
|
Tip: If an account code is missing from one of the above fields, then a warning will occur at the time of the sync that the code will need to be added - data won't sync if the code is missing.
Looking for more help? Try reviewing the following topics: View Topics
© 2019 Total Synergy Pty Ltd