Bill Line Type Mappings

When you have a Bill CAPture subscription, you can set rules to automatically assign bill line types based on bill line captions.

You configure the mappings with a spreadsheet you download from the Bills module menu.

From this screen you can see the mappings already in place.

Use the link Download and update mappings to download the spreadsheet and after you have updated the sheet, use this same location to upload your changes.

This spreadsheet lets you add, delete, or update mappings.

When you remove a row from the spreadsheet the mapping is also deleted in the application.

Do not rename, remove, or rearrange columns.

  • Any mappings provided on the Account tab are used first for the selected accounts.
  • If no mappings exist for a specific account, the Vendor tab is used to apply mappings for the selected vendors.
  • If no account or vendor mappings exist, the mappings on the Default tab are applied.

Steps to add a mapping

After you download the spreadsheet

  1. Review any existing mappings, update or remove mappings as needed.
  2. Select the tab where you want to enter your mappings.
  3. Enter the bill line caption from your bill import file that you want to map.
  4. Select the operator for how you want to match the bill line caption. The highest priority operator is applied if more than one selection is entered. The priority order is:
    1. Equals
    2. Begins with
    3. Ends with
    4. Contains
  5. Use the drop-down to select the bill line type you want to map to.

Example bill before 

This is the bill with the caption "Portland Harbor Superfund" and it is assigned to the bill line type Charge.

Example bill after

After uploading the Bill Line Type Mapping spreadsheet the caption "Portland Harbor Superfund" is now assigned to the bill line type Fee.

Errors

When you upload the spreadsheet the application validates the cells. If any errors exist you must download the error (kickout) file, fix the errors, and upload the error file.

None of the rows in the Bill Line Mapping spreadsheet are processed if there is an error in the file.

Example error

In this example Column E was accidentally left empty.

After uploading the file you get an error message.

The file you download is named kickout.xlsx. If you already have a kickout file in you download directory you will see something like kickout (2).xlsx.

Fix the error in the file and import.