Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

HTML Wrap
classsection group
HTML
<span data-swiftype-index="true">
HTML Wrap
classcol span_3_of_5

If you ticked the checkbox to map the client accounts, the Map Accounts window will open. The Map Accounts window enables you to select the account(s) on the Practice ledger chart that correspond to each account on the accountant's chart. You can make adjustments to the ledger accounts, where required, to align the balances with the equivalent accountant's accounts.

UI Text Box
typenote

Any GST columns in the imported file will be ignored. Make sure to add any GST data manually.

Map accounts window

 

Button / Field

Description

A

Client account code / name

These columns represent your client's chart of accounts. They're populated with the data in the Account code and Account name columns of the file you've selected to import in stage 1 of the import wizard.

B

Include Automatically mapped accounts

Select this checkbox to display all accounts automatically mapped by the system (indicated with in the status column). This option is selected by default.

If the system has mapped the account incorrectly, choose the correct account by clicking in the Map to column for the account, and choosing the correct account.

C

Status

Displays the mapping status for each account. A legend for these icons is available on the bottom-left of the window.
D

Search for account

Enter an account code or name to search the client chart of accounts.
EMap to

Click in the Map to column for each row and choose an account from your chart of accounts to allocate the balance of the client's account to. See To map an accounts below for a demonstration.

FAdd account

If you can't find the account you're looking to map to, create a new account by clicking the Add account button.

In the Add account window, specify the Account type, Account type group, Account number, Account name and Tax Code for the new account.

When finished, click OK to create the account.

GName, Account type, BalanceThese columns represent the chart of accounts in your MYOB ledger. These fields are populated automatically when you select an account in the Map to column for the row.
HClear all mappings

Click this button to clear all mappings, including automatic system mappings and any manual mappings you have made.

A confirmation window displays requesting confirmation to clear the mappings. Click Yes.

ISave as DraftSave your current mappings as a draft. When you reopen this window, your saved mappings will appear so you can continue where you left off.
JRestore default mappings

Click this button to clear any changes you've made when mapping your accounts. This will restore the account mappings to their original state and any changes you've made will be lost.

You confirmation window displays requesting confirmation to restore the default mappings.

KFinish

This button becomes active once all accounts have been mapped.

UI Expand
titleTo map an account
  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.

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

UI Expand
titleTo create a new account
UI Text Box
typetip

Can't find the account you're looking for?

Before adding an account, select the View all accounts and Include zero balances options, then try searching for the account.

You may notice the account you're looking for already exists!


  1. Click Add account.
  2. Specify the Account type, Account type group, Account number, Account name and Tax Code for the new account.
  3. Click OK.
UI Expand
titleTo view or edit the mapping template

The mapping template displays the most recently imported client accounts that are mapped to ledger accounts.

You can select to View/Edit mapping template from the Select File screen, which means you can view and modify account mappings without having to choose a client file to import.

The View/Edit mapping template window is identical to the Map Accounts window

  • To change a mapping, click the drop-down menu in the Map to field.
  • To add an account, click Add Account.

The Save button will be enabled once a change has been made. Click Save to save your changes.

UI Text Box
typenote

Existing mappings cannot be cleared or restored from default mappings.

Anchor
MaptempMaptemp
HTML
<br><h2><i class="fa fa-comments"></i>&nbsp;&nbsp;Mapping FAQs</h2>
UI Expand
titleHow does the system know which accounts to automatically map to?

The system maps some of the accounts automatically based on the account name and account balance:

  • where the account name on your chart of accounts is the same as an account name in your client's chart, and no other accounts exist with the exact same name.
  • where the balance of an account in your chart of accounts is exactly the same as the balance of an account in your client's chart, where no other accounts exist with the same balance.

These mappings are displayed on the Map Accounts window with a  icon in the status column. To re-allocate a system mapped account, select the account and click the drop-down arrow in the Map to column.

If the system can't find an exact match, you'll need to map the account manually. The system may suggest accounts that you may want to map to instead. Accounts with suggested mappings are displayed on the Map Accounts window with a  icon in the status column.

For example, where the account name on your chart of accounts is similar to an account name in your client's chart, or is exactly the same as more than one account in your chart of accounts, the system will suggest

If the account has not been mapped or no suggested mappings exist, a is displayed in the status column.

 

Icon

Mapping status

 

Automatically mapped by the system to the chart of accounts

Possible mappings exist to the chart of accounts

Has no mapping to the chart of accounts

Mapped by the user to the chart of accounts

Was previously mapped to the chart of accounts

UI Expand
titleCan I override a system mapped account?

Yes! Click in the Map To field for that row and choose another account.

UI Expand
titleWhy can't I see all accounts when choosing an account to map to?

The Mappings window has a number of display options:

OptionDescription
View suggested accounts

Displays a list of suggested mappings for the account. If the status column displays an icon, this display option is chosen by default.

View all accountsDisplays a full list of accounts.
Show unmapped accounts onlyHides accounts that have already been mapped to an account on your client's chart.
Include zero balancesDisplays accounts on your chart with a balance of $0.00.

If you can't find an account, select View all accounts and Include zero balances, then type any part of the account code or name in the Search for an account field.

If the account you're looking for doesn't exist, click Add account to create a new account and add it to the chart.

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

Importing data

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 templateUsing the

Importing transactions from QuickBooks Online Template