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
- In the top-right corner, select the Settings gear icon.
- Under Accounts Payable, select Export Configurator.
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.
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.
Drag the handle on the left of a row to move that column.
In Export as, type the column name for the CSV.
(Optional) Select the trash icon to remove that row from the CSV.
Select SAVE TEMPLATE.
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.
- Select ADD A COLUMN.
- In Select columns or type a separator, select the source fields to combine or type a separator such as / in between the field names.
- Select Add.
- Select SAVE 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
- Update the list.
- Select SAVE TEMPLATE to keep the column layout.
Unsaved changes displays beside SAVE TEMPLATE.
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