Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
HTML Wrap
classsection group
HTML Wrap
classcol span_3_of_5

HTML
<span data-swiftype-index="true">

Transactions can be imported into Client Accounting using the Manage client file imports wizard. You can find this function on the Tasks bar of your client's Client Accounting > Trial Balance (or Workpapers) tab.

You can only import transactions via Client Accounting if your configured ledger is an MYOB Ledger. If you're using something different, you can still use the import functions in your configured ledger's software.

The Manage client file imports wizard accepts the following file types:

About the Manage Client File Imports wizard

The Manage client file imports wizard is where you'll import journal transactions from your client's file into an MYOB ledger. In this window, you'll map your the client's accounts to its equivalent account in your ledger.

There are two additional functions in this window:

  • The View/edit mapping template link lets you view and modify the mapping template for the most recently imported client accounts.
  • The Delete previous import link will delete all transactions and journal entries posted by the import wizard for the previously imported client file (i.e. undo the import).
HTML
<h2><i class="fa fa-comments"></i>&nbsp;&nbsp;Transaction Import FAQs</h2>
File type

You may need to customise the exported file to match the format MYOB Ledger requires.

UI Expand
titleHow do I import data from another accounting software?

If your client's accounting software has the option to export transactions in an MYE format, choose this option. This is an MYOB file type and requires no additional formatting.

If you don't have this option, choose a .CSV or Excel file type. These files may require some additional customisation to import into MYOB ledger.

For example:

Product
If you're using...Choose file type...
Xero.MYE
QuickBooks.CSV
Reckon.CSV

If you're not sure how to export data from a 3rd party accounting software, check the product help for that software.

UI Expand
titleHow do I export transactions from a AccountRight, AccountEdge or Essentials?

For information on how to export transactions from your client's file, click on the link in the Refer to column for the relevant product.

ProductRefer to..
AccountRightProvide information to your accountant
AccountRight Classic (v19 or earler)Exporting information for use with AE/AO
AccountEdgeProvide information to your accountant
Essentials Accounting (including Connected Ledger)Export for accountants
UI Expand
titleHow do I import transactions if I'm not using an MYOB ledger?

If your configured ledger is not an MYOB Ledger, you can still import transactions from within your configured ledger's software.

For example, if you've configured a MAS ledger, import your data using the import function within the MAS ledger.

The table below lists articles containing information on how to import transactions into your product.

UI Text Box

Journal transactions can't be imported into MYOB Essentials. For information on what you can import into Essentials, see Importing and exporting in MYOB Essentials.

UI Expand
titleWhat data can I import into MYOB Ledger?

You can import:

ItemMYECSVTXTQIFMore information
Chart of Accounts

 

  Importing a chart of accounts into MYOB Ledger


Journal transactions




 

Importing an .MYE or .TXT file

Importing a .CSV file

Bank Statements 

 

 

Importing a Bank Statement into MYOB Ledger
HTML
</span>
HTML Wrap
width15%
classcol span_1_of_5
 
HTML Wrap
floatleft
classcol span_1_of_5
Panelbox
namegreen
titleRelated topics
HTML Wrap
classsidebarlinks

Mapping imported accounts

Importing an .MYE or .TXT file

Importing a .CSV file

Importing a Chart of Accounts

Importing a Bank Statement into MYOB Ledger

Using the QuickBooks 2014 template

Using the QuickBooks Online Template