Mapping

What are mappings?

In the table mapping you will link the transactions on your general ledger to your Profit & loss statement and Balance sheet. Mappings can be made either on a general ledger account, or if applicable on the combination of a general ledger account and a selected analytical axis.

How can you use analytical axis in mappings?

E.g. if you use the cost centers in Exact Online to register costs per department, you can map the combination of the general ledger account '620500 - Wages' and cost center 'Sales' to the reporting line 'Personnel Costs - Sales' in your Profit & loss statement.

Before you can use analytical axis in your mappings you need to select what axis to use in the settings of your entity. Select the analytical axis you would like to use and click .

You can select to following options (if used in your accounting):

• None
• Cost Center (Exact Online)
• Cost Unit (Exact Online)
• Project (Yuki, Exact Online)

Setup your mapping

You can setup your mapping either by uploading a CSV file or via our user-interface.

The mappings table contains the following fields:

• Account: General ledger account used for the mapping
• Account description: Description of the selected Account
• Code: Code of the analytical axis used for the mapping, if analytical axis is selected in the settings of your entity.
• Analytical axis description: Description of the selected analytical Code.
• Report line: The report line (Profit and loss and Balance sheet) that to wich the mapping is allocated. You can only map to report lines that are not a parent of other report lines.
• Report: the report of the selected Report line.
• Top Level: The name of the Report line of the first parent that is indicated as Top level in the definition of the Profit & loss statement or Balance sheet.
• Comment: Optional comments.
• Transactions: click '' to quickly get an overview of the transactions booked on a mapping.

Every time your general ledger is refreshed Monitr will check for General ledger accounts (or a combination of General ledger accounts and analytical axis if selected) that have not been defined in the mapping table. If unmapped transaction occur these will be presented at the top of the mapping table, highlighted in blue. Make sure to map these transaction to the correct 'report line' to ensure your reporting is complete. You can filter the mappings to only show the unmapped transactions by clicking '' next to Account Mapping.

If you have unmapped transactions in your general ledger this will be indicated as an error in validations.

Via User Interface

Definition

Complete the folowing fields in the template

• Account [string]: the code of the general ledger account
• Analytical Account [string]: the code of the analytical account (optional)
• ReportingID [string]: the ID of the
• Comment [string]: A comment (optional)

Validation

Make sure these validations rules are respected:

The combination of Account and Analytical Account needs to be unique
The Account needs to exist in your accounting
The Analytical Account needs exist in your accounting
A mapping to a reporting line needs to be made in Reporting ID
The Mapping needs to be made to a reporting line without children

Upload your template

1. Make sure the status of all validation rules in the tabsheet 'Mapping' of the template is 'TRUE'.
2. Copy the definition (columns with a dark blue header) in to a csv file and save it on your computer.
3. Go to tab 'Mapping'.
4. Click
5. Browse to the CSV file on your computer and select and click 'Open'.
6. Click
7. If any errors occur they will be highlighted in red. Your report will not be saved.
8. Fix the errors and click untill the report is succelfully saved

If you upload a CSV file with mapping, this will overwrite (not append) your current mappaings.

Via CSV

Setup your mapping

To create your mapping via the Monitr user interface:

1. Go to tab 'Mapping'.
2. You can complete pre-filled rows highlighted in blue or add rows by clicking ' insert row'
3. Select the report line to which you want to allocate the mapping in the column 'Report line'.
4. Click
5. If any errors occur they will be highlighted in red. Your report will not be saved.
6. Fix the errors and click untill the report is succelfully saved

Validation

The following validation checks are performed:

Mappings (combination of general ledger accounts and analytical axis if applicable) should be unique
One general ledger account can only be linked to one report (Profit & Loss or Balancesheet) if multiple mappings occur (analytical axis)