Data Import/Xero Ledger Code Mapping
Contents
Import Ledger Code Mapping for Xero
This feature provides an easy and fast way to import xero ledger code mappings via a bulk upload tool.
The system utilises the Bulk upload processing notification event to send a notification with the results of the import attempt. See below for further information.
If the import is successful, the email notification will advise you when the import process is complete.
If the import is not successful, the email notification will send details of the records that failed validation and why.
Preparing your Data
To prepare your data for import, you will need to create a CSV import file or you can download the import file below. You will need to extract the csv file and save it.
media: xero-ledger-code-mapping-import-template.csv
Export the full list of Emersion ledger codes by running the Ledger Codes (and Mapping) report located on the Reference tab under the Reports section of Cumulus.
Enter the data into the import sheet. You must ensure the data meets all validation requirements that are contained in the data definition table below. When you submit the data file for import, the system will parse the file looking for errors. If the system finds no errors, the system will import the ledger code mappings into the system. The file needs to be error-free in order to import the data. In the event errors are found, no data will be imported into Emersion. Review the bulk upload processing notification email, correct the file and try again.
Importing your Data
To access the Xero Ledger Mapping import tool:
- Log into Cumulus.
- Nav: Admin > Bulk Import > Xero Ledger Account Mappings.
- Click the Browse button and select the csv file containing the data you want to import.
- If you want the bulk upload processing notification email to be sent to a different email address than the address defined in the event template, tick the Override? checkbox and enter an alternative email address. This will only apply for this upload. To change the email address for all future imports, you will need to change the recipient defined in the event template.
- Press Submit
Xero Ledger Account Mappings Data Definitions
| Data field | Description |
| LEDGER_CODE_ID | The ID of Emersion ledger code. This is optional however if this is not provided, Emersion will attempt to import based on the LEDGER_CODE_NAME. You must provide either a LEDGER_CODE_ID or a LEDGER_CODE_NAME. |
| LEDGER_CODE_NAME | The name of the Emersion Ledger Code. This is optional however if this is not provided, Emersion will attempt to import based on the LEDGER_CODE_ID. You must provide a LEDGER_CODE_ID or a LEDGER_CODE_NAME. |
| XERO_LEDGER_ACCOUNT_NAME | The ledger account name in Xero. These can be found in Xero, or in Cumulus when mapping an Emersion ledger code to a Xero ledger account manually. This is optional however if this is not provided Emersion will attempt to import based on the XERO_LEDGER_ACCOUNT_CODE. You must provide a XERO_LEDGER_ACCOUNT_NAME, a XERO_LEDGER_ACCOUNT_CODE, or a XERO_LEDGER_ACCOUNT_GUID. |
| XERO_LEDGER_ACCOUNT_CODE | The account code in Xero. These can be found in Xero, or in Cumulus when mapping an Emersion ledger code to a Xero ledger account manually. This is optional however if this is not provided Emersion will attempt to import based on the XERO_LEDGER_ACCOUNT_CODE. You must provide a XERO_LEDGER_ACCOUNT_NAME, a XERO_LEDGER_ACCOUNT_CODE, or a XERO_LEDGER_ACCOUNT_GUID. |
| XERO_LEDGER_ACCOUNT_GUID | The ledger account ID. This can be found in Xero. |
| DESCRIPTION | Provide an optional description. |
Xero Ledger Account data in Cumulus
To find the XERO_LEDGER_ACCOUNT_NAME or XERO_LEDGER_ACCOUNT_CODE in Cumulus follow the steps below.
Nav: Admin > Xero > Xero Ledger Map
- Click on any Emersion Ledger Code name. A pop up will open.
- Drop down the list of Mapped Ledger Codes to view the names and codes to use in the import sheet
