Export Configurator Overview

Export Configurator Overview

Export Configurator sets the columns in the invoice CSV for Emburse AP. Use this page to choose the source fields, name each column, and set the column order.

Access and Permissions

Export Configurator is available to users with the Manage AP Settings permission. If Export Configurator is not visible, confirm that permission with your company administrator.

Navigate to Export Configurator

  1. In the top-right corner, select the System Configuration gear icon.
  2. Under Accounts Payable, select Export Configurator.
  3. Emburse Professional System Configuration with Accounts Payable Export Configurator link highlighted

Export Configurator Page

Use this page to shape the invoice export CSV so it matches your accounting import or ERP template. You choose which source fields export as columns such as vendor, invoice number, dates, line amounts, and status. You can add user-defined invoice fields, approval data, and notes. You can set the left-to-right column order and the CSV header names your finance team or ERP expects.

Column Description
Source field The invoice value written to that CSV column. Each source field is a blue label with a pencil icon.
Export as The column name in the CSV. The box is labeled "Enter column name." It already contains the source field name. You can type a different name.

Export Configurator Source Fields

These source fields display on the template. Export as starts with the same text, and you can change that name.

Export Configurator default template listing source fields and matching Export as column names

The default template includes the following source fields:

  • Company Name
  • Invoice ID
  • Invoice Number
  • Vendor Name
  • Vendor External ID
  • Invoice Date
  • Due Date
  • Payment Terms
  • PO Number
  • Currency
  • Subtotal
  • Tax Amount
  • Invoice total
  • Line Number
  • Line Description
  • Quantity
  • Unit Price
  • Line Amount
  • GL Code
  • GL Name
  • Invoice Status
  • Payment Status
  • Payment Method
  • Payment/Settlement Date
  • ERP Sync Status
  • ERP Sync Date
  • Submitted By

Arrange the Export Configurator Columns

Arrange Export Configurator columns so the export CSV column order matches what you need.

The top-to-bottom order on the page is the left-to-right order that is exported in in the CSV and the last remaining row cannot be removed.

  1. Drag the handle on the left of a row to move that column.

  2. Export Configurator column list with drag handles, source field labels, Export as inputs, and delete icons on each row

  3. In Export as, type the column name for the CSV.

  4. (Optional) Select the trash icon to remove that row from the CSV.

  5. Select SAVE TEMPLATE.

  6. Export Configurator page footer with Unsaved changes and Save Template selected among preview and reset actions

Concatenate Export Configurator Columns

Concatenation writes more than one source field into a single CSV column.

For example, if you combine Vendor Name and Invoice Number with a slash (/) as the separator, and the vendor is Acme Corp with invoice number INV-1001, the CSV column shows Acme Corp/INV-1001.

  1. Select ADD A COLUMN.
  2. Export Configurator with Select columns or type a separator control and How to concatenate help below the column list

  3. In Select columns or type a separator, select the source fields to combine or type a separator such as / in between the field names.
  4. Add column control showing PO Number and Priority selected with Add enabled before concatenated fields are added

  5. Select Add.
  6. Select SAVE TEMPLATE.
The ADD A COLUMN option also offers Submitted Date, Approved Date, Approver, Notes, and each active Invoice Field. Those are not on the default template.

Save or Reset the Export Configurator Template

Use the buttons at the bottom of the page to review, save, or discard the column list.

Button Description
PREVIEW Displays the Export preview. It shows a sample row of the current column layout, including changes you have not saved. Select Close to leave it.
RESET TO DEFAULT Replace the current list with the default columns.
CANCEL Discard edits that are not saved.
SAVE TEMPLATE Save the column list. This button stays unavailable until you change the list. It also stays unavailable when a column name is empty or duplicated.

Save the Export Configurator Template

  1. Update the list.
  2. Unsaved changes displays beside SAVE TEMPLATE.

    Export Configurator with a shortened column list, Unsaved changes, and Save template available

  3. Select SAVE TEMPLATE to keep the column layout.

Save the template before you leave the page. The top-to-bottom order on the page is the left-to-right order that is exported in in the CSV

Was this article helpful?