|UI Text Box|
This feature is not enabled for all users. If this option isn’t available in the Tasks bar, please contact your client manager to enable this feature for your practice.
In order to import a client file, make sure that the configured ledger is Practice Ledger.
If you need to use ledger data that was prepared using a ledger that cannot be directly connected to, you can load the ledger data by importing an MYE, TXT or CSV file.
An MYE or TXT file contains details about the client’s ledger being imported, and chart of accounts and journal transactions. A CSV file contains either chart of accounts, or chart of accounts and transactions.
|title||How to import an MYE client file|
Open the client’s Client Accounting > Trial Balance tab (called the Workpapers tab if you are licensed for Workpapers).Click Ledger > Import client file on the Tasks bar.In the Import Wizard window, Select the .MYE option under Choose file type.In the Select file to import field, browse for the .MYE file to import.Click Next. A message displays with details of the client’s name, start date and end date.If the details are correct, click Yes. The system validates the file format.Continue to Selecting account mapping options.
|UI Text Box|
- When you import an MYE file, the system identifies any accounts that need to be added to the chart of accounts, and adds all the journal transactions as journals to the ledger.
- If your MYE file exceeds the system limit for journal entries (16,000), an error message will display. To address this issue, decrease the number of transactions and consolidate prior period data.
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).
<h2><i class="fa fa-comments"></i> Transaction Import FAQs</h2>
|title||How to import a TXT client file|
|UI Text Box|
When you import a TXT file, the system identifies any accounts that need to be added to the chart of accounts, and adds all the journal transactions as journals to the ledger.
- Open the client’s Client Accounting > Trial Balance tab (called the Workpapers tab if you are licensed for Workpapers).
- Click Ledger > Import client file on the Tasks bar.
- In the Import Wizard window, Select the .TXT option under Choose file type.
- In the Select file to import field, browse for the .TXT file to import.
- Click Next. A message displays with details of the client’s name, start date and end date.
If the details are correct, click Yes. The system validates the file format.
Continue to Selecting account mapping options.
|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. You may need to customise the exported file to match the format MYOB Ledger requires.
|If you're using...||Choose file type...|
If you're not sure how to export data from a 3rd party accounting software, check the product help for that software.
To successfully import 3rd party transactions, the file containing the exported transactions need 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.