Importing a .CSV file

Using the default MYOB template

To successfully import third-party transactions, the file containing the exported transactions needs to follow the default import format. Below are the default template specifications for the contents of the import file. The file needs to match these specifications to be able to import the transactions. These are normally in CSV file format, which you can create using Microsoft Excel.

The column names in your CSV file must be in the first line of your CSV file.

Some ledger fields are mandatory and some are optional, as shown in the following table.

1. Go to the Client Accounting > Trial Balance (Workpapers) tab.
2. On the TASKS bar, click Import client file or Manage client file imports depending on your version.
   
   An import wizard appears.
3. Select the .CSV radio button.
4. Click the Select file to import field's ellipsis [...] button, and browse to and open the CSV.

5. In the Select template dropdown, select the type of mapping template that matches the client’s source file.

   The default options are Default Template and Quickbooks 2014 Template. If other options are listed, they have been customised for your site. If you’re not sure which one to use, contact IT or MYOB Support.

6. Click Next.

1. If you want to map the client’s chart of accounts to the ledger chart of accounts, select The chart of accounts in the file being imported is different to the chart in the ledger – I want to specify how to map the accounts to the ledger checkbox.

   Do not select this checkbox if the client’s chart of accounts is the same as your chart of accounts.
2. If you want consolidated transactions so that you have one transaction per account on a monthly/annual basis, select the Consolidate imported transactions into single monthly or annual transactions for each account checkbox and select the Monthly or Annually radio button.
3. Click Next. The Map Accounts window appears. Some accounts are mapped by the system, but you need to map any unmapped accounts indicated by a question mark [?] icon

1. If any accounts with a question mark [?] icon, click the blank Map to cell and select the account to map to.

2. Click Next. The Preview window appears.

1. Click Finish. A message asks if you want to post all the file data to the ledger.
2. Click Yes. The accounts are posted to the ledger and an import summary message appears.
3. Click OK.

You can import .QIF files into MYOB Ledger.

Do it in ledger.

Importing .QIF files into MYOB Ledger

• Comments less than 955 characters
  • transactions split over 2 lines ^ (in export file)
• special characters in account codes
• all accounts have account codes

• all accounts have Numeric account codes. (check if you can have alphanumeric)

• The sum of all transactions is equal to 0 (i.e. Debit and Credit columns balance.)

• each transaction in balance (yeah QBOL)

Check these bad boys:

Check out these other bad boys:

ask reckon

ask xero

ask quickbooks

Creating a custom CSV import template to import into Client Accounting