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

1. From AE/AO, open the client and go to the Client Accounting > Trial Balance (Workpapers) tab.
2. On the TASKS bar, click Manage client file imports. The Manage Client File Imports window appears.
   
3. Select either .MYE or .TXT according to your exported file type.
4. At the Select file to import field, click the ellipses () button and browse to the location of the export file.
5. Highlight the file and click Open. The file path appears in the Select file to import field.
6. Click Next.
   

1. Choose whether you want to map your client's account codes to your ledger's accounts, or to import your client's accounts:

   Option	Description
   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	If your client's chart is the same as your chart of accounts, you can choose whether to select this option. When this option is not selected, all transactions import with the client’s account code. Any accounts that don't exist in your chart are automatically added. If your chart of accounts is different from your client's chart, select this option. This will let you map your client's accounts to your ledger accounts.
   Consolidate imported transactions into single monthly or annual transactions for each account	Consolidates transactions into a single monthly or annual transaction for each account. To import all transactions, leave this checkbox unticked. UI Text Box type warning Only imported transactions can be viewed. If you choose to import consolidated transactions, you'll only be able to view one imported transaction per month or year (as selected). You can import up to 16,000 transactions. If you have more than this, select this checkbox to consolidate your transactions. If you've selected this checkbox, select to import either: Monthly – imports one transaction per month for each account Annually – imports one transaction per year for each account.

2. Click Next.
   If you've selected the first option, continue to Map Accounts. Otherwise, continue to Stage 4.
   

1. In the Map Accounts window, click in the Map to column for each account and choose an account to import your client's transactions to.

   

   The Account name, Account type and Balance are updated automatically. Repeat this step for each account code.

   UI Text Box
   type tip
   Can't find the account you're looking for? You may need to create a new one. Click Add account and fill in the details.

2. Once all accounts have been mapped, click Next.

1. Preview the accounts and make sure all accounts are mapped correctly.

   UI Text Box
   size medium type tipinfo
   To export the data, click Export to Excel.

2. When you're ready to submit the transactions, click Finish. The client data is posted to your ledger.