Skip to main content

Integrations: Scheduled expense export

Set up an automated expense export; choose email or SFTP delivery

Written by Anna Allen

To set up a scheduled Expense Export:

Company Settings > Integrations

If this is your first Integration, you will see a list of all our Integration options. If you've already setup an Integration, you will see it listed here. To add a new Integration, choose the blue "Add Integrations" button in the upper righthand corner.

From the list of Integrations find: "Scheduled Expense Export", and click "Add" located to the right.

Toggle the "Enabled" switch to "On".

In "Export Details" choose your preferred frequency. The options are:

  • Daily

  • Weekly

  • Biweekly

  • Semimonthly

  • Monthly

When choosing "Weekly" or "Biweekly" next choose the day on which you would like to receive your export. If you choose "Semimonthly" you can choose between the 1st and the 15th, or the 15th and the Last day of the month. Choosing "Monthly" will allow you to pick which day of the month, the 1st through the 30th.

There are two options for "Delivery Method":

  • Email Export

  • SFTP

Email Export will allow you to set one, or more emails to receive the export. There is an optional field if you'd like to receive any Error Notifications.

Scheduled Expense Export page within Company Settings, Integrations, showing how to add email recipients for report and the email recipient for an error file

Figure 1. Scheduled Expense Export page

After you have input the email addresses, choose "Save".

If you'd like to have your export delivered via SFTP, once this option is chosen, there will be a "Credentials" field. Choose the blue "Add" button to the right.

Modify Credentials dialog within the Scheduled Expense Export page showing how to modify SFTP credentials

Figure 2. Modify Credentials dialog within the Scheduled Expense Export page

In the dialog, the user name and password are input for your account. Input the following:

  • Host

  • Path

  • Port

Choose "Add" in the lower righthand corner.

Finally choose your file type. The self-solve setup supports CSV. If you would like a custom export, choose "Custom" from the "File Type" menu, in the section below click the blue "Contact" button to request a custom file type for your Scheduled Expense Export.

If you have a scheduled expense export, the expense export is done at 00:00 (midnight). Use this reference chart if you'd like to anticipate when you can expect to receive your file.

Note that during daylight savings, if your region shifts, you will see these times reflected as an hour later.

UTC

Universal Time Coordinated

00:00 (midnight)

PST

Pacific Standard Time

16:00 (4pm the previous day)

MST

Mountain Standard Time

17:00 (5pm the previous day)

CT

Central Time

18:00 (6pm the previous day)

ET

Eastern Time

19:00 (7pm the previous day)


Need help?

If you need help, contact the NextView support team:


Publish date: January 30, 2025

Last update: NA

Did this answer your question?