Detailed guide to options available when configuring your account code breakdown when syncing expenses to MYOB or QuickBooks (Reckon Accounts Premier).
Tip: Not seeing the Connect module? Contact Total Synergy Support to request this to be added to your Synergy licence.
You can elect whether or not you want Staff expenses to be sync'd to MYOB or QuickBooks (Reckon Accounts Premier). Here's information about the settings available.
This selection will not transfer any expenses from Synergy to MYOB or QuickBooks (Reckon Accounts Premier). Expenses will need to be manually entered into MYOB or QuickBooks (Reckon Accounts Premier). Use this option also if you want to sync Invoices and Expenses in separate batches.
All expenses that have been entered since the last sync session will be exported.
If you are using Expense Approvals, you would be processing new expenses through the approval wizard. This option will only sync those staff expenses that have been approved.
All Expenses will be allocated to the one Expense Account in MYOB or QuickBooks (Reckon Accounts Premier).
Using the Attribute, firstly we assign an attribute to the Staff record. Within Default Data we store the Expense code. The whole Expense is allocated to one Expense code.
Using the Attribute, firstly we assign an attribute to the project. Within Default Data we store the Expense code. The whole Expense is allocated to one Expense code, though you do see the sub project detail in MYOB or QuickBooks (Reckon Accounts Premier).
If Expense account codes have been allocated to the disciplines select the option discipline from the drop down list. When the Expense is allocated to a sub project, the expense will sync to whichever account code has been assigned to the discipline within the sub project. If an expense is allocated to multiple sub projects, potentially the one expense may be split across multiple account codes (disciplines) as well.
If Expense account codes have been allocated to the cost centres select the option cost centre from the drop down list. Each Expense will be split over the relevant Expense account codes according to the code attached to the cost centre. view example
An account code can be stored against the Expense types so that when expenses are sync'd the expenses are allocated to the correct expense accounts in MYOB or QuickBooks (Reckon Accounts Premier) such as Cost of Sales or Expense accounts.
Locate Expense Types to learn more.
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 sync-able fields (Attributes, Cost Centre).
Choose whether or not the staff record should be sync'd to MYOB or QuickBooks (Reckon Accounts Premier).
If you select this option, the Expenses will continue to sync. Providing the name in Synergy and MYOB or QuickBooks (Reckon Accounts Premier) are identical then the expense will sync successfully.
Sync the Staff record to MYOB or QuickBooks (Reckon Accounts Premier) as a Supplier type. If you already have them setup in MYOB as suppliers for the purposes of reimbursing cash expenses, then select No Staff Export and ensure the names in both systems are identical.
This is an important field as Synergy will allow 100 characters in the Contact name field, however MYOB will only allow 50 and QuickBooks only 42 characters. So to truncate will be important otherwise the contact will be rejected in the accounting system and the expense won't sync across.
The way Expenses are reimbursed to your staff in MYOB, you will have your staff setup as an Employee for payroll processing as well as a Supplier for expense processing. Because you cannot have duplicate card names in MYOB - even though the card types are different (one supplier, one employee) when the sync occurs the MYOB ODBC driver does not know which Contact to allocate the expense to.
What you need to do is assign a Card ID to your staff in Synergy and MYOB. By adding a prefix of S- or SUP-, this will create a unique record in MYOB so expenses and invoices will sync successfully placing the suffix at the end of the Card ID.
Locate MYOB Expenses sync checklist to learn more.
Because you cannot have duplicate card names in QuickBooks (Reckon Accounts Premier) - whether one be set as Customer and one as Supplier, when the sync occurs the QuickBooks (Reckon Accounts Premier) driver does not know which Contact to allocate the expense to. By adding a suffix of S- or SUP, this will create a unique record in QuickBooks (Reckon Accounts Premier) so expenses and invoices will sync successfully placing the suffix at the end of the name.
Some of the options above only allow you to sync transactions to a single account code - meaning each Invoice or Expense may not be broken down across multiple account codes.
Invoice 95 has work for Engineering services and Architectural services. The project has been setup with 2 sub projects with the disciplines Eng and Arch attached. In MYOB there is also 2 different account codes for the 2 services, so I want the Invoice amounts to be allocated to the appropriate codes.
Single account code |
Can split invoice/expense to multiple account code |
|
---|---|---|
Project attribute |
|
|
Contact attribute |
|
|
Staff attribute |
|
|
Contact |
|
|
Discipline |
|
|
Cost Centre |
|
|
Expense Type |
|
|
Fixed Value |
|
|
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.
Locate Split data to account codes in MYOB to learn more.
Looking for more help? Try reviewing the following topics: View Topics
© 2019 Total Synergy Pty Ltd