Schedule Exports
Emburse Spend’s Scheduled Exports allow organizations that use ERPs not yet integrated with Emburse Spend to export data more efficiently and without user intervention, enabling easier accounting reconciliation.
Scheduled exports automatically deliver export files by email. You can send a single scheduled export to multiple email recipients, ensuring all relevant administrators or stakeholders receive the data at the same time.
SFTP-based scheduled exports are only available for Emburse Spend's paid tiers; they are excluded for the base-level subscription.
Create a Custom Export Template
Create a custom export template before you schedule an export. See How to Create a Custom Export Template with Export Builder for complete details.
Set the Schedule & Delivery Method
Once you have created a custom export template, you may schedule it for export.
You can schedule only one custom template at a time. The Schedule Export feature disables all other templates.
-
Select
Company Settings > Export.
-
Find the desired template in the Exports list, select the More Actions button, and select Schedule Export.
| Setting | Description |
|---|---|
| Frequency | Choose how often the system automatically runs this export (e.g., Weekly, Monthly). |
| Start Date | Select the date when the scheduled export should first run. |
| File Type | Choose the file format for the export: CSV, Pipe Delimited, or Semicolon Delimited. |
| Apply Batch ID | Select to assign automatically generated batch IDs to track which expenses were exported together for accounting reconciliation. Each batch ID is unique to the expense submitter; no batch includes expenses from multiple submitters. |
| Transaction Status Filters | Determine which transactions to include based on status. |
| └ Occurred | Contains Needs Review, Needs Manager Review, Pending Submission, Denied, and Completed transactions |
| └ Were Submitted for Approval | Contains Needs Review, Needs Manager Review, and Completed transactions |
| └ Were Fully Approved | Contains only Completed transactions |
| └ None | Select to exclude corporate card transactions entirely. |
| Transaction Date Range | Choose the date range for included transactions (Previous 7 Days; Previous Month; Most Recent Statement Cycle). |
| Default Category for Unsubmitted Transactions | Displays the automatically assigned category for eligible unsubmitted transactions. This field remains blank if the system did not auto-categorize the transaction. |
| Reimbursable Expense Status | Select which reimbursable expenses to include. |
| └ Were Submitted for Approval | Contains Needs Review, Needs Manager Review, and Completed expenses |
| └ Were Fully Approved | Contains only Completed expenses |
| └ Do Not Export Reimbursable Expenses | Select to exclude reimbursable expenses entirely. |
| Reimbursable Date Range | Choose the date range for reimbursable expenses (Previous 7 Days; Previous Month; Most Recent Statement Cycle). |
- In the Choose where exports will be sent section at the bottom of the screen, select the desired delivery method for exports—email, SFTP, or both.
You can enter multiple email addresses for a single scheduled export. Separate each email address with a comma. The system delivers the export to all listed recipients at the same time.
- Select SCHEDULE EXPORT.