All CSV Output Files will need a descriptive name. As a best practice use a naming convention for all the file names. Enter the file name into the Save As field and check the box for Add timestamp to filename if that is what you would like to add to the file name automatically, every time the file is generated.
From the Filter Data section, you have a few options to filter the data by:
- Currency
- Payment Type
- GL Code or
- Any other User Defined Fields you have set up, if any.
Lastly, check the box if you would like the file to be sent automatically. If checked, the file will be sent when a new batch is processed.
The CSV file type also allows you to map the Columns with your specific system.
Under the Columns tab of the Output File Editor enter the
- Content Type, can be either Line Item or User. The Line Item gets the line item details and User gets employee totals which are used in Payroll outputs.
Check the box if you would like to Include the Header.
- File Type, can be either CSV, Excel or JSON file format
From the Columns section, you can add the column name by clicking on the Add button to select the fields available in the ExpensePoint™ system for fields mapping.
You can also delete a Column, if necessary, by clicking on the Delete button.
If the fields/columns name do not exactly match with what you have in your system, click on Edit button to enter the exact name of the column from your system.
While editing the Column name you also have the ability to Group rows by this column if you check the box.
To adjust the order of the columns to match your system, you can use the Move Up or Move Down buttons to change the order.
Amex card remittance CAD
- Load Number
- Book Number
Amex card remittance CAD
- Load Number
- CID
- Book Number
ACH Transfer
- Merchant ID
- Secure Transaction Key
- Password
HSB remittance
- Transit Number
- Account Number
- Account Name
TransactionPro
- Track credits checkbox
- Entity
- Account
- Class
- Include Category Column
NACHA file
- Bank Name
- Bank Routing Number
- Company Name
- Company Identifier
- Add balancing entry
- Notify Users
Quickbooks Online
- Entry Type – could be Billing, Expense Reports and Journal Entries.
- Account Name
- Bill Vendor
- Transaction Date
- Description
- Memo
- Class Name
- Notify Users
Sage 500 (CA version)
- Entry Type
- Account Name
- Source Name
- Date
Xero
- Entry Type
Net Suite
- Entry Type
Viewpoint Spectrum
- Entry Type
EFT 80 byte file
- Originator Name (Company Name)
- Originator ID
- Institution ID
- Transit Number
- Account Number
- Manual Due Date (DDMMYY)