Mapping Expense Category Enhancements Follow

Mapping Expense Categories is now easier than ever. New components have been introduced to the expense category functionality, all designed to improve the account and item mapping workflow during expense category creation.

This article will introduce you to the new and improved expense category functionality.

Map Account and/or Item via Expense Category Upload

When you upload a list of expense categories, you can map accounts and/or items simultaneously. Fill out the account and/or item columns with the exact account or item names, along with expense category names and other fields.

Tallie will perform the mapping based on any exact name match with existing accounts or items in the enterprise. The following scenarios could occur:

• If no exact name match is found, the category is uploaded without mapping.
• If both an account and an item are provided in the upload file, Tallie will evaluate whether both can be applied based on the same integration-based logic used when saving expense categories.
  • If both can be applied, Tallie will apply both; otherwise, Tallie will apply item mapping only.

Generate an Expense Category from an Account

On the Edit page of an Account, you’ll find a Create a Mapped Expense Category button.

Clicking this button will take you to an expense category creation view where the expense category name and account mapping are pre-populated. You can fill in any other details as necessary and click Create to set up a new category.

Certain accounts that aren’t eligible for expense category mapping (such as Credit Card type accounts) will not get this button. The eligibility is determined by which account types allow for expense tracking.

Generate an Expense Category from an Item

On the Edit page of an Item, you’ll find a Create a Mapped Expense Category button.

Clicking this button will take you to an expense category creation view where the Expense Category Name and Account mapping are pre-populated based on your item settings.

From here, you can finish your Expense Category Configuration and click Create to save. 

Mass Create Expense Categories from the Item List

Selecting one or more items from the Items list will activate a Create Mapped Expense Categories button.

Clicking the button will create expense categories for each of the selected Items that mirror the Display name and Mapping set on the Items selected. 

If an expense category already exists with the same name and it’s already mapped to an Item or Account then a new expense category will be created, with the number 2 (or 3, 4… depending on the number of pre-existing expense categories with the same name) appended to the expense category name. 

If an un-mapped expense category with the same name exists, Tallie will update the existing Category to apply Item mapping based on the Item selected.

When Mass-Creating Categories from the Items or Accounts Page, you can click on the Expense Categories link in the pop-up message for a shortcut to the Expense Categories Page.

Mass Create Expense Categories from the Account List

Selecting one or more items from the Account list will activate a Create Mapped Expense Categories button.

Clicking the button will create expense categories for each of the selected Items that mirror the Display name and Mapping set on the compatible Accounts selected. 

Certain accounts that aren’t eligible for expense category mapping (such as Credit Card type accounts) will not be created and an error message will display. The eligibility is determined by which account types allow for expense tracking.

If an expense category already exists with the same name and it’s already mapped to an Item or Account then a new expense category will be created, with the number 2 (or 3, 4… depending on the number of pre-existing expense categories with the same name) appended to the expense category name. 

If an un-mapped expense category with the same name exists, Tallie will update the existing Category to apply Item mapping based on the Item selected.

When Mass-Creating Categories from the Items or Accounts Page, you can click on the Expense Categories link in the pop-up message for a shortcut to the Expense Categories Page.