Import Xero-format CSV files into MYOB
Lots of apps with no MYOB integration can still export invoices as a CSV file in Xero’s import format. TransPost imports that file into MYOB once you have replaced the tax names in Excel.
Works in TransPost, TransPost Express, TransPost Plus and TransPost Premier.
*ContactNameCustomer*InvoiceNumberInvoice number*InvoiceDateDate*DescriptionLine description*UnitAmountAmount or price*TaxTypeWhat is a Xero-format CSV file?
It is a spreadsheet laid out the way Xero asks for invoices to be imported: one row per
invoice line, with columns such as *ContactName, *InvoiceNumber,
*InvoiceDate and *TaxType. The asterisks mark the columns Xero
requires. Rows with the same invoice number make up one invoice.
Apps that connect to Xero often offer this file as an export, so you can use it even if your books are in MYOB. Most of it imports as it is. The tax column needs changing, because the file names each tax (GST on Income) where MYOB uses a code (GST).
Will my file work?
Check these before your first import. If you are not sure, send us the file’s heading row and we will tell you.
- It has all of Xero’s invoice columns, even empty ones, with the headings left as they are
- The headings start with an asterisk, such as
*ContactName. A file exported from Xero itself has none and needs a different mapping - Invoice numbers are 13 characters or fewer
- Each customer name matches a customer card in MYOB, or you import the contacts file first
- Every line has a quantity of 1, or your item codes match MYOB item numbers
- Discounts come through on the Item Sales mapping; for Service Sales the column must be blank
- The amounts are in your MYOB company file’s currency
- Windows date format set to Australian or NZ
- Keep each invoice’s lines together; don’t re-sort
Three steps
-
Export from your app
Choose the export for Xero, often called Xero CSV or Xero import format. Note whether the amounts include GST.
-
Replace the tax names in Excel
Open the file, use Find and Replace for each row of the table below, then save it as a CSV file. If you use the Service Sales mapping, replace the account codes too.
-
Import with TransPost
Import the mapping on the TransPost Mapping tab, choose your file and run it. Then check your first import in MYOB before you import more.
Find and replace: Xero tax names to MYOB tax codes
In Excel, press Ctrl+H, tick Match entire cell contents, and replace each name on the left with the code on the right. Check the codes against the tax codes in your MYOB company file, and type them in capitals as shown.
| Find (Xero tax name) | Replace with (MYOB tax code) |
|---|---|
| GST on Income | GST |
| GST on Expenses | GST |
| GST Free Income | FRE |
| GST Free Expenses | FRE |
| GST Free Exports | EXP |
| BAS Excluded | N-T |
| Input Taxed | ITS |
These are Xero’s Australian tax names. For a New Zealand file, ask us first.
GST Free Exports and Input Taxed are in Xero’s advanced tax rates only. MYOB’s
code for input-taxed sales is ITS. MYOB refuses INP on a sale. If
your company file has no ITS code, ask
us before you import input-taxed sales.
If a tax name isn’t replaced, the line takes your MYOB file’s default tax code and imports without an error, so a GST-free line can be charged GST. Check your first import.
Account codes
The *AccountCode column holds Xero account codes, such as 200, which do not
exist in MYOB. Either replace each one with your MYOB income account number (a detail
account, not a header), or use the one income account mapping, which ignores the column.
Excel drops a leading zero when it opens a CSV file, so account code 091 shows as 91 and invoice number 00123 becomes 123. If yours start with 0, make the replacements in Notepad instead.
The mappings
Pick the sales mapping that suits your invoices. To add one to TransPost, click Import Mappings on the Mapping tab and choose the file. See Importing Mappings if you haven’t done this before.
Customers
From a Xero contacts CSVRun this first if your customers are not in MYOB yet. Each contact becomes a customer card, named from ContactName, with its email, phone numbers, billing and delivery addresses and ABN. Cards already in MYOB are left as they are.
Service Sales
From a Xero invoices CSVFor services, where every line has a quantity of 1. Each line goes to the MYOB account in the AccountCode column, so replace Xero's account codes first.
Service Sales, one income account
From a Xero invoices CSVEvery line goes to one income account, so there are no account codes to replace. Change the AccountNumber default to your own income account before you run it.
Item Sales
From a Xero invoices CSVFor products. InventoryItemCode must match the item number in MYOB. Quantity, unit price and discount all come through.
Each sales mapping treats amounts as including GST. If your app
exported them without GST, open the mapping, type N in the Default column
for Inclusive and click Save Settings.
Works with MYOB AccountRight and MYOB Business
Tested on MYOB Business Lite and Pro and on MYOB AccountRight Plus and Premier. Only the due date behaves differently. AccountRight sets the invoice’s payment terms from it; MYOB Business doesn’t import it yet, so the invoice takes the customer’s usual terms.
| Service Sales, Item Sales and customer cards | Every MYOB edition |
|---|---|
| Due date | MYOB AccountRight only, for now |
| Item Sales on MYOB Business Lite and Pro | Up to 10 inventoried items, unless you have MYOB’s Premium Inventory add-on |
| TransPost Express | MYOB Business company files only |
What doesn’t come across
- Tax names. They need replacing with MYOB tax codes first. If a tax name isn’t replaced, the line takes your MYOB file’s default tax code without an error, so check your first import.
- Account codes. Replace them with MYOB account numbers, or use the one income account mapping.
- Discounts. They come through on the Item Sales mapping; for Service Sales the column must be blank.
- Quantities on Service Sales. A Service Sales line takes one amount and does not multiply quantity by price, so every line needs a quantity of 1. For more than 1, use Item Sales.
- New customers. An invoice for a name that isn’t in MYOB fails, and one where two MYOB cards share the name can fail. Import new customers first and keep names unique.
- Other columns. Tracking, currency, and the address and email on the invoice file are not imported onto the sale. The reference comes across as the customer PO number. The due date sets the payment terms on MYOB AccountRight; MYOB Business doesn’t import it yet.
- Bills. This page covers sales invoices only.
Credit notes do come across. With the Service Sales mappings, an invoice that adds up to less than zero posts to MYOB as a credit note. With Item Sales, a credit line needs a negative quantity and a positive unit price, because an item price cannot be negative.
Xero-format CSV and MYOB: what to know
Can I import a Xero CSV file into MYOB?
Yes. TransPost imports it as MYOB sales once the Xero tax names in the file are replaced with MYOB tax codes.
Why do the tax names need replacing?
Xero files name the tax (GST on Income) and MYOB uses a code (GST). If a tax name is not replaced, the line takes your MYOB file's default tax code and imports without an error, so a GST-free line can be charged GST. Check your first import.
Do my customers need to be in MYOB already?
Yes, each invoice is matched to a MYOB customer card by name. If they are not there yet, export your contacts in Xero's format and import them first with the Customers mapping.
Do credit notes come across?
Yes. With the Service Sales mappings, an invoice that adds up to less than zero posts to MYOB as a credit note. With Item Sales, a credit line needs a negative quantity and a positive unit price, because an item price cannot be negative.
Which MYOB editions does this work with?
Every edition of MYOB AccountRight and MYOB Business. On MYOB Business, the due date in the file is not imported yet; the invoice takes the customer's usual terms.
Send us your file’s heading row and we’ll tell you if it works
Tell us which app the file came from and paste its first row, the column names only. We don’t need any invoices.
Xero and MYOB are trademarks of their owners. TransPost is not affiliated with either.