MYOB Finance Integration

This article is designed to assist providers setting up finance integration for MYOB AccountRight v19 and v2018 finance packages. At the time of writing, MYOB Essentials (the Cloud based version of MYOB, does not support importing invoice data)

Prerequisites


Debtor ID

Client, Client Contact and Contact records contain 'Debtor ID' fields for finance integration. The corresponding MYOB 'Card ID' must be added to the 'Debtor ID' field in SupportAbility for any parties invoices are being issued to. 

Client Debtor ID options

When the client is set as their own  billing contact, and invoices are being generated for them, the Client Debtor ID entered is the default identifier that populates in the card ID field on the MYOB invoice export. 

If an organisation uses the client's NDIS number as their card ID, there is a system setting that when set, SupportAbility will populate the client's NDIS number in the card ID on the export instead.   

To update this to the NDIS number instead of the Client Debtor ID, go to the Settings tab of System Preferences. Navigate to the Invoicing section on the bottom right-hand side and change the 'Client Debtor ID' field:

The setting of client NDIS number being used in lieu of the Debtor ID is only applicable if: 

  • the client is being billed directly i.e. self-managed clients, additional activity costs, or non-NDIS billing, AND
  • their MYOB Card ID has been set up as their NDIS number


Internal [Direct] Invoice Export Mapping for MYOB AccountRight v19

SupportAbility can export accounts receivable invoices as MYOB AccountRight v19 'Sales - Service' records.  The full specification details can be found using the link below:

http://help.myob.com.au/prem19/win/impexptables.htm

The following table maps the MYOB AccountRight v19 Invoice batch export headers with the corresponding SupportAbility data for reference purposes. 


MYOB AccountRight Invoice Batch export SupportAbility field
Co./Last Name Client Debtor: Client's last name
Client Contact Debtor: Client contact's last name
Contact Debtor: Company name if available or primary contact last name
First Name Client Debtor: Client's first name
Client Contact Debtor: Client contact's first name
Contact Debtor: empty if company name if available or primary contact first name
Addr 1 - Line 1 Prints 'Client: [CLIENT_NAME]' if the client is not marked as the debtor (eg. the client has a client contact or contact marked to receive invoices on their behalf).
If the client is marked as the debtor for the invoice, this field will be left empty
- Line 2 Client Debtor: Client's postal address
Client Contact Debtor: Client contact's postal address
Contact Debtor: Contact's postal address
- Line 3 Client Debtor: Client's postal suburb        
Client Contact Debtor: Client contact's postal suburb
Contact Debtor: Contact's postal suburb
- Line 4 Client Debtor: Client's postal state and postcode
Client Contact Debtor: Client contact's postal state and postcode
Contact Debtor: Contact's postal state and postcode
Invoice # The invoice number generated by SupportAbility.  
Please ensure that your invoice number formatting configuration uses no more than 8 characters which is MYOBs maximum invoice number length
Date The invoice date (same as the date the invoice batch was generated)
Description This element may include:
  • activity date and time
  • quantity
  • NDIS support item details
  • Non-NDIS supports used based on the rate card
Account # The auto-allocated  General Ledger Code for this invoice item based on the site, service and payment method
Amount The value of the invoice item exclusive of GST
Inc-Tax Amount The value of the invoice item inclusive of GST
Job The auto-allocated  Job Code for this invoice item.  This field will be empty unless Job Codes have been configured
Comment For non-clinical invoices, this element will include details of the SupportAbility Invoice Batch number that this invoice is related to.   
For clinical invoices, this element will include the Claim Number, Injury Date and Clinical Notes from the Client Funding record.
GST Code GST: if invoice item contains GST
FRE: if invoice item does not contain GST
Sale Status EMPTY
Currency Code AUD
Card ID Client Debtor: Client Debtor ID or NDIS Number depending on the  invoicing configuration setup within SupportAbility
Client Contact Debtor: Client Contact's Debtor ID
Contact Debtor: Contact's Debtor ID


Internal [Direct] Invoice Export Mapping for MYOB AccountRight v2018

SupportAbility can export accounts receivable invoices as MYOB AccountRight v2018 'Sales - Service' records.  The full specification details can be found using the link below:

http://help.myob.com/wiki/display/ar/Import+and+export+fields#expand-Servicesales

The following table maps the MYOB AccountRight v2018 Invoice batch export headers with the corresponding SupportAbility data for reference purposes. 


MYOB AccountRight Invoice Batch export SupportAbility field
Co./Last Name Client Debtor: Client's last name 
Client Contact Debtor: Client contact's last name 
Contact Debtor: Company name if available or primary contact last name
First Name Client Debtor: Client's first name 
Client Contact Debtor: Client contact's first name 
Contact Debtor: empty if company name if available or primary contact first name 
Addr 1 - Line 1 Prints 'Client: [CLIENT_NAME]' if the client is not marked as the debtor (eg. the client has a client contact or contact marked to receive invoices on their behalf). 
If the client is marked as the debtor for the invoice, this field will be left empty
- Line 2 Client Debtor: Client's postal address 
Client Contact Debtor: Client contact's postal address 
Contact Debtor: Contact's postal address 
- Line 3 Client Debtor: Client's postal suburb         
Client Contact Debtor: Client contact's postal suburb 
Contact Debtor: Contact's postal suburb 
- Line 4 Client Debtor: Client's postal state and postcode 
Client Contact Debtor: Client contact's postal state and postcode 
Contact Debtor: Contact's postal state and postcode 
Invoice # The invoice number generated by SupportAbility.  
Please ensure that your invoice number formatting configuration uses no more than 8 characters which is MYOBs maximum invoice number length
Date The invoice date (same as the date the invoice batch was generated)
Description This element may include: 
  • activity date and time
  • quantity
  • NDIS support item details
  • Non-NDIS supports used based on the rate card
Account # The auto-allocated   General Ledger Code for this invoice item based on the site, service and payment method
Amount The value of the invoice item exclusive of GST
Inc-Tax Amount The value of the invoice item inclusive of GST
Job The auto-allocated   Job Code for this invoice item.  This field will be empty unless Job Codes have been configured
Comment For non-clinical invoices, this element will include details of the SupportAbility Invoice Batch number that this invoice is related to.    
For clinical invoices, this element will include the Claim Number, Injury Date and Clinical Notes from the Client Funding record. 
GST Code GST: if invoice item contains GST 
FRE: if invoice item does not contain GST
Sale Status EMPTY
Currency Code AUD
Card ID Client Debtor: Client Debtor ID or NDIS Number depending on the   invoicing configuration setup within SupportAbility
Client Contact Debtor: Client Contact's Debtor ID 
Contact Debtor: Contact's Debtor ID 


External [Plan Managed] Accounts Payable Invoice Export Mapping for MYOB AccountRight v19

SupportAbility can export accounts payable invoices as MYOB AccountRight v19 'Purchases - Service' records.  The full specification details can be found using the link below:

http://help.myob.com.au/prem19/win/impexptables.htm

The following table maps the MYOB AccountRight v19 Invoice batch export headers with the corresponding SupportAbility data for reference purposes. 


MYOB AccountRight Invoice Batch export SupportAbility field
Co./Last Name Contact Creditor: Company name if available or primary contact last name
First Name Contact Creditor: empty if company name if available or primary contact first name 
Addr 1 - Line 1 Prints 'Client: [CLIENT_NAME]'
- Line 2 Contact Creditor: Contact's postal address 
- Line 3 Contact Creditor: Contact's postal suburb 
- Line 4 Contact Creditor: Contact's postal state and postcode 
Inclusive EMPTY
Purchase # EMPTY
Date The external invoice date
Supplier Invoice #
The Service Providers invoice number as entered on the external invoice
Ship Via EMPTY
Delivery Status EMPTY
Description This element may include: 
  • service date
  • quantity
  • NDIS support item details
Account # The standardised  General Ledger Code for all external invoice items as configured in System Preferences
Amount The value of the invoice item exclusive of GST
Inc-Tax Amount The value of the invoice item inclusive of GST
Job The standardised  Job Code configured to be used for all external invoice items.  This field will be empty unless Job Codes have been configured
Comment The Client's NDIS Number
Journal Memo The ID of the NDIA Bulk Payment Request Record in SupportAbility
The Reference Number of the NDIS Support Item Used
Shipping Date EMPTY
GST Code  'FRE'
Non-GST Amount The value of the invoice item exclusive of GST
Import Duty 0
Freight Amount EMPTY
Inc-Tax Freight Amount EMPTY
Freight GST Code EMPTY
Freight Non-GST Code EMPTY
Freight GST Amount EMPTY
Freight Import Duty Amount EMPTY
Purchase Status 'O'
Currency Code AUD
Exchange Rate EMPTY
Terms - Payment Is Due EMPTY
Discount Days EMPTY
Balance Due Days EMPTY
% Discount EMPTY
Amount Paid EMPTY
Category EMPTY
Card ID Contact Debtor: Service Provider Contact's Creditor ID 
Record ID EMPTY


External [Plan Managed] Accounts Payable Export Mapping for MYOB AccountRight v2018

SupportAbility can export accounts payable invoices as MYOB AccountRight v2018 'Purchases - Service' records.  The full specification details can be found using the link below:

http://help.myob.com/wiki/display/ar/Import+and+export+fields#expand-Servicepurchases

The following table maps the MYOB AccountRight v2018 Invoice batch export headers with the corresponding SupportAbility data for reference purposes. 


MYOB AccountRight Invoice Batch export SupportAbility field
Co./Last Name Contact Creditor: Company name if available or primary contact last name
First Name Contact Creditor: empty if company name if available or primary contact first name 
Addr 1 - Line 1 Prints 'Client: [CLIENT_NAME]'
- Line 2 Contact Creditor: Contact's postal address 
- Line 3 Contact Creditor: Contact's postal suburb 
- Line 4 Contact Creditor: Contact's postal state and postcode 
Inclusive EMPTY
Purchase No. EMPTY
Date The external invoice date
Supplier Invoice No. The Service Providers invoice number as entered on the external invoice
Ship Via EMPTY
Delivery Status EMPTY
Description This element may include:  
  • service date
  • quantity
  • NDIS support item details
Account No. The standardised   General Ledger Code for all external invoice items as configured in System Preferences
Amount The value of the invoice item exclusive of GST
Inc-Tax Amount The value of the invoice item inclusive of GST
Job The standardised   Job Code configured to be used for all external invoice items.  This field will be empty unless Job Codes have been configured
Comment The Client's NDIS Number
Journal Memo The ID of the NDIA Bulk Payment Request Record in SupportAbility 
The Reference Number of the NDIS Support Item Used
Shipping Date EMPTY 
Tax Code  'FRE'
Freight Amount EMPTY
Freight Tax Code EMPTY
Freight Tax Amount EMPTY
Purchase Status 'O'
Currency Code AUD
Exchange Rate EMPTY
Terms - Payment Is Due EMPTY
Discount Days EMPTY
Balance Due Days EMPTY
% Discount EMPTY
Amount Paid EMPTY
Category EMPTY
Card ID Contact Debtor: Service Provider Contact's Creditor ID 
Record ID EMPTY

Still need help? Contact Us Contact Us