Mapping your bookkeeping data improves accuracy, saves time, and makes reporting better.
Use mapping to standardise your chart of accounts so you can simplify your workflow, keep your data consistent, and provide useful insights across all your client files.
Mapping chart of accounts using AI
Key points
-
You don’t need to complete mapping when you first set up the client. Create the client first, then come back to mapping when you can set aside some focused time.
-
Important: Once you start mapping, you must finish within 30 minutes. If your session times out, any mapping you’ve done will be lost, and you'll need to start over again.
-
AI mapping appears when new accounts are added, uploaded or synced. AI suggestions are there to help, but you still need to review and confirm them.
-
AI suggestions only appear once, so it’s important to complete the mapping in one session. After you save, AI-mapped accounts no longer look different from manually mapped accounts.
How does AI mapping work
Client Accounting uses AI to help with your account mapping by providing account mapping proposals.
When you go to the Account mapping window after importing your client data, the AI will start looking for the accounts that match.
AI account matches
The Account mapping window will display the mapping proposals on the left.
The system will show single account or multiple accounts proposals. You can review these and accept them.
The proposals have a confidence level:
High confidence has no indicator - You can accept these if you want.
Low confidence has a red exclamation mark - Review these suggestions.
Multiple accounts are ordered first based on the highest probability.
Accepting or updating the account mapping
In a single proposal, if you’re happy with it you don’t need to do anything.
In multiple proposals, the first one is ticked by default. You can either accept that or select another account you want.
Use the Account type column when reviewing the suggestions to check the type of account.
If the proposals are incorrect, you can remap the accounts by selecting Remap and selecting from the account codes list.
When you remap, you’ll see a pencil icon indicating that the AI suggestion has been manually edited.
Once you’ve reviewed mapping, select Save.
You’ll need to map these accounts once and remap any new accounts added after the mapping is complete.
Watch the video to learn about AI mapping
Re-mapping chart of accounts
If you don’t accept the AI suggestion, you can manually remap the account to a different code.
-
The Client accounting chart is more streamlined than other charts, so one-to-one mapping isn’t expected and several accounts may map to one category.
-
Original ledger detail is not lost even if mapping is consolidated. You can still review original ledger accounts in workpapers, break down balances where needed (e.g. for banks or internal review)
-
Chart headings vs account codes: Some headings represent ranges or structure, not real account codes. These can't be mapped to directly and are used only to explain the chart’s hierarchy
-
We've provided downloadable spreadsheets that can be used as planning tool and a guide before starting to map the accounts.
How to map chart of accounts manually
After you’ve synced a file, you need to map a file so you can use our workpaper and reporting workflows.
Click Remap to start mapping the accounts and select Save once you’ve finished the mapping.
You can search for an account based on the code or description.
Account mapping reference
Here’s a summary of the chart of account codes in Client Accounting.
1 - Assets
1.1 - Current assets
1.2 - Non-current assets
2 - Liabilities
2.1 - Current liabilities
2.2 - Non-current liabilities
3 - Equity
4 - Revenue
5 - Cost of sales
6 - Expenses
8 - Other income
9 - Appropriation
Account mapping chart in Client Accounting
To see account code mappings, right- click and select Save Link As to download this spreadsheet: Account Mapping in Client Accounting
Example of MAS chart of accounts
We’ve created an example showing how account mapping works between a MAS chart of accounts and a client accounting chart of accounts. Use it as a guide when mapping other charts of accounts. 8
Right- click and select Save Link As to download: MAS chart of accounts example