Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 18 Next »


 

 

Close

How satisfied are you with our online help?*

Just these help pages, not phone support or the product itself

0
1
2
3
4
5
Very dissatisfied
Very satisfied

Why did you give this rating?

Anything else you want to tell us about the help?

 

 

You may need to import ledger data if you want to use data from a ledger that you can't directly connect to, or if you're migrating to another ledger, such as MYOB Ledger.

You can add your current-year data by importing transactions from the following file formats:

To import a client file, make sure the ledger is configured as an MYOB Ledger.

For more info on two of the options you may come across: 

If you're looking to create a custom template in Client Accounting so that you can import CSV files in a different format to the MYOB default, see KB 38782: Creating a custom CSV import template to import into Client Accounting.

To import an MYE or TXT client file

An MYE or TXT file contains details about the client’s ledger being imported, chart of accounts and journal transactions.
When you import these files, Client Accounting identifies accounts that need to be added to the chart of accounts, and adds all the journal transactions as journals to the ledger.

To import an MYE file that exceeds 16,000 journal entries, decrease the number of transactions and consolidate prior-period data.


  1. Go to the Client Accounting > Trial Balance (Workpapers) tab.
  2. On the TASKS bar, click Import clientfile or Manage client file imports depending on your version.

    An import wizard appears.
  3. In Choose file type, click either .MYE or .TXT.
  4. In the Select file to import field, browse for the .MYE or .TXT file to import.
  5. Click Next.
  6. If the client's details are correct, click Yes.
  7. 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.
  8. If you want to include 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.
  9. Click Next. The Map Accounts window appears.
  10. Select the accounts on the Practice ledger chart that correspond to each account on the accountant's chart.
  11. If required, adjust the ledger accounts to align the balances with the equivalent accountant's accounts.
  12. If you want to import all transactions in the file:
    1. Do not tick the Consolidate imported transactions into single monthly or annual transactions for each account checkbox.
    2. Click Next.
  13. Click Next.

  14. Click Finish. The accounts are posted to the ledger.

Importing a CSV file

A CSV file contains either a chart of accounts, or chart of accounts and transactions.

When importing a CSV file, an XML configuration file in the Deploy folder controls the mapping between the CSV file columns and ledger fields.

For more information on CSV templates, including a sample template that you can download, see KB 37963: Complying with the specifications for importing transactions exported from a third-party product.

For specific details about importing Quickbooks Online CSV files, check out KB 38166: Complying with the specifications for importing transactions exported from a third-party product.

The CSV file you're going to import needs to have no more than 38,000 journal entries. If you've got more, either:

  • separate the CSV file into multiple files and import each file separately, or
  • consolidate prior period data to decrease the total entries.

You can watch us stepping through this procedure in the Import prior year balances chapter of the Adding data to MYOB Ledger video.

To import a CSV client file
  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.

  7. 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.
  8. 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.
  9. 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.
  10. If any accounts with a question mark [?] icon, click the blank Map to cell and select the account to map to.
  11. Click Next. The Preview window appears.

  12. Click Finish. A message asks if you want to post all the file data to the ledger.
  13. Click Yes. The accounts are posted to the ledger and an import summary message appears.
  14. Click OK.
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.

 

Column name    Maps toMandatory/optional
account codeAccountCodeMandatory
account nameAccountNameOptional
account typeAccountType

Optional

Note: The following values are valid:
Income, Other Income, Liability, Equity, Expense, Other Expense, Assets, Cost of Sales, Uncategorised

account type groupAccountTypeGroupOptional
tax codeTaxCode

Optional
The valid code values (and their definitions) are:
  • NA (No tax implied)
  • (Australia) CAP (Capital acquisitions)
  • (Australia) EXP (Export sales)
  • (Australia) FRE (GST free)
  • GST (Goods & Services Tax)
  • (New Zealand) E (Exempt)
  • (Australia) GNR (Not registered)
  • (Australia) INP (Input taxed purchases)
  • (Australia) ITS (Input taxed sales)
  • NTR (Not reportable).
  • (New Zealand) Z (Zero rate)
  • (New Zealand) I (GST on imported supplies).
If no value is entered, the default value of NA is used.
transaction referenceTransactionReferenceId

Optional
transaction descriptionTransactionDescription

Optional
transaction dateTransactionDate

Optional (mandatory if TransactionAmount is mapped)

The following formats are both valid:
  • dd/mm/yyyy
  • dd-mm-yyyy
transaction amountTransactionAmountOptional

Note: The file should be balanced:
Sum of Amount = $0
Sum of Amount for each unique Date = $0

No special characters are allowed ($ or ',')
Signage is allowed (+, -)

  Frequently Asked Questions (FAQs)