How to Import and Map Categories in Spenmo

Role: ✔ Accountant, ✔Admin, ✖ Team Manager, ✖ Employee, ✖ Bookkeeper

This article serves as a guide on how to import categories from Xero and map your categories in the Spenmo Dashboard to your Xero Charts of Accounts (CoA). To do this, ensure that you have integrated your Spenmo account to Xero. Follow our guide here.

Automatic Mapping

Spenmo allows you to automatically import expense categories from your Xero CoA.

1. During Xero integration, you will see the option to "Import Categories from Xero". Click on it.

2. Spenmo will proceed to pull out all the Expense account categories from Xero to your Spenmo dashboard. The rest of the account categories (Assets, Liabilities, Revenue) will not be synced into the categories in Spenmo.

Manual Mapping

Spenmo allows you customise expense categories in the Spenmo Dashboard. You can then map these unique categories to the correct Xero CoA. To learn how to set up your own categories in Spenmo, refer to our guide here.

After you do the Automatic Mapping above, you can also make changes to the CoA mapping using this manual method.

1. To map your categories to your Xero CoA, click on settings, then "Categories".

2. Choose the category you want to map to your Xero CoA.
3. Click on the dropdown menu under "Account Code". Your Xero CoA will appear for selection. Proceed to select the Xero CoA you want to map the category to.

4. Click "Save" once done. Transactions tagged to this category will be synced to the chosen Xero CoA moving forward.

Note:

We recommend that you do not map the "Default and "Refund" categories. This is to prevent uncategorised transactions from being synced to Xero. Thus, make sure that you categorise the transactions in your "Transactions" tab into the correct categories before syncing them into Xero.

How to Import The Categories from Xero After Integration

If your Spenmo account has already connected to Xero, you can import the categories again in Xero to Spenmo by following the steps below.

1. Select the ⚙️ ‘Settings’ icon on the bottom left of your screen and click ‘Categories’.

2. Click the ‘Add Category’ button and select the ‘Import from Xero’ button.

3. On Add Category pop-up screen, click ‘Import Category’.

4. Afterward, the screen will show the categories that will be imported, and click “Finish Importing & Mapping”.

5. The new categories will be imported automatically to the Spenmo dashboard. 

Please fill in this form for any additional assistance required.