Add New File

Steps to Add a New File to Your Automations List

1. Open the Automation Manager Module
   Navigate to the Automation Manager module from the top navigation bar.
   
   Note: If you do not see it in the top menu, check under the More menu located in the upper right corner of your screen.
   
2. Access the Add New File Option
   From the Output Files navigation menu on the left side of the screen, select Add New File.
   
3. Open the Output File Editor
   This will open the Output File Editor window.
   
4. Output File Editor Tabs
   The editor includes two main tabs:
   1. General
   2. Scheduling

General Tab

In the General tab, you can:

1. Enter the Template Title
2. Select the File Type
3. Optionally, check the box “Show status in expense manager” to display the file processing status on your expense reports.
   

Available File Types
The following file types are currently supported in ExpensePoint:

1. CSV
2. Amex card remittance (CAD)
3. Amex card remittance (USA)
4. ACH transfer
5. HSBC remittance
6. TransactionPro
7. NACHA file
8. Quickbooks Online
9. Sage 50 (Canadian Version)
10. Xero
11. NetSuite
12. Viewpoint Spectrum
13. EFT 80 byte file

Scheduling Tab

Scheduling Tab Overview
In the Scheduling tab, you can set when the automated file output should be sent to your accounting system via SFTP or other methods.

Steps to Setting the Automation Schedule

1. Setting the Schedule
   Define the frequency and timing for the automated export under the scheduling options.
   
2. Submission Method
   In the Submission section, select the method for sending the file from the Send Via dropdown:
   1. Do not send: The file will not be sent anywhere.
   2. SFTP: Send the file through a Secure File Transfer Protocol (recommended).
   3. FTP: Send the file through a regular File Transfer Protocol (unsecured, not recommended).
   4. Email: Enter an Email address to receive the file by email.
   5. HTTP Post: Enter the HTTP URL to post this file to an external link.
3. Submission Details for SFTP or FTP
   If you select SFTP or FTP, provide the following details:
   1. SFTP Server: Server name.
   2. Port: Port name.
   3. Username: Username for the server above.
   4. Password: Password for the server above.
   5. Folder: Destination folder from your server where the file will be placed.
   6. Binary File Transfer (not ASCII): Enable this checkbox to send the file in binary format.
      Note: Please consult your IT Department for these technical details.
      
4. Save Your Settings
   Once you have configured the schedule and submission details, click OK to save your automation setup.

Watch the video below for a visual guide to Adding a New File.

Watch the video below for a visual guide to Scheduling and Submission of an Output File.