How do I export my MYOB Invoice data in a CSV format?

Purpose 

This feature has been developed to alleviate some specific issues with MYOB syncs that some organisations may have.

This MYOB custom csv export, exports finalised NDIS Self & Plan managed invoices into a CSV format, following the specific requirements below:

Header Name	Formatting	Example
Co./Last Name	Global Billing Contact Name if Plan Managed, or Client Surname if Self Managed.	Acme Council (NDIS) Tigersword
First Name	Client First name if invoicing to individual	Blank - if Plan Managed Sully - if invoiced to individual eg Self Managed
Client
Addr 1 - Line 1	Client name and NDIS number	Sully Tigersword 000000000
Invoice #	Left Blank
Date	Only include date not time in formats	18/09/2024
Customer PO	The last 4 digits of the NDIS number - Need to confirm the Invoice Number from NG	8764
Description	Date Time Units UnitPrice Ratio Support Funding Item Note: no tabs or commas	14/09/2024 06:00-07:00: 1.00x $73.09 1:1 01_400_0104_1_1 Assistance With Self-Care Activities - High Intensity - Weekday Daytime - WA
AttendanceDate	Dates only not times	14/09/2024
AttendanceDateDate	Dates only not times	14/09/2024
SupportFundingRef	Support Funding Reference Number	01_400_0104_1_1
SupportFundingItem	Support Funding Item	Assistance With Self-Care Activities - High Intensity - Weekday Daytime - WA
ClaimType
CancellationType
ClaimableUnits	Formatted to 2 decimals	0.5
UnitPrice	Formatted to 2 decimals	73.09
UnitPriceString	Formatted to 2 decimals	73.09
Amount	Formatted to 2 decimals	36.55
GST Amount	Formatted to 2 Decimals	0
Inc-Tax Amount		36.55
SupportFunding	Support Funding	[01_400_0104_1_1] Assistance With Self-Care Activities - High Intensity - Weekday Daytime - WA Claimable units: 0.50
AttendanceStartTime	Time	5:00
AttendanceEndTime	Time	5:30
Ratio	Ratio	1:01
Account #	Using lookup table based on Job Code to add this in.	4-1100
Job	Job Code	18YNDIS
Comment	NG Claims Run DDMMYY	NG Claims Run 180924
Journal Memo	Equal to Co./Last Name field	Acme Council (NDIS) - If Plan Managed. Tigersword - If invoiced to individual eg Self Managed.
Tax Code	Use GST if funding line if included GST otherwise will use “FRE”	FRE or GST
Currency Code		AUD

Audience 

This article is intended for advanced users and admins.

Configuration

How to enable the MYOB Custom CSV Export

Please contact Nightingale Support if you would like this custom csv export enabled.

Enable Staff Member Access

This setting enables visibility of the report per staff position.

You must have the feature enabled, and the access setting below granted to use the feature.

1. Edit Position → Reports & Forms (tab) → Enable MYOB Client Service Invoice CSV Export

2. Save

Sync MYOB Jobs and Accounts

This feature uses some new data, that is pulled from MYOB.

General Ledger Jobs and General Ledger Accounts must be updated in Nightingale, to save the Job Number and Account Codes respectively.

1. Organisation Settings → Finance (tab) → MYOB Integration

   1. Sync General Ledger Jobs

   2. Sync General Ledger Accounts

Usage

Pre-Usage

note

You must run a Claim/Invoice Report to finalise invoices prior to using the export tool.

• Finalised both, Plan and Self Managed invoice reports.

You must run a Claim/Invoice Report to finalise invoices prior to using the export tool.

• Finalised both, Plan and Self Managed invoice reports.

Generate MYOB CSV Export

Navigate to Organisation Settings → Finance (tab) → MYOB - Export NDIS Plan/Self Managed Sale (CSV).

Criteria

Groups:

• Selecting a group from this select box, fills the clients select box with all required clients in the group.

  • Removing a Group will not remove the clients.

Client/s:

• Select required Clients sorted alphabetically by last name.

General Ledger Account:

• Select a default General Ledger Account to use if the account is unavailable from the funding.

All Clients:

• Checking this will run the export for All Active Clients

• It will disable the Group and Client selections.

Include Inactive Clients:

• This will include inactive clients in the all clients export.

• Option is enabled when All Clients is selected.

  • Deselecting All Clients will uncheck and disable this option.

Invoice Period:

• The Invoice Period start and end date, will set the range to pull the finalised Client Invoices from.

Issue Date:

• Meta-data applied to each row in the export for the export run time.

Generate CSV Button:

• Runs the process and when finished will download a CSV export of the results.

  • CSV should be downloaded directly, and is named “NG Claims Run ddMMyy.csv”

• Button will not run the export if the required criteria are not completed.

note

Note the process will complete, even if there are no finalised balances. In this case you will get an empty CSV file.

Note the process will complete, even if there are no finalised balances. In this case you will get an empty CSV file.