Under the Columns tab, you can set the report columns to match the imported file for your transactions.
CSV Properties
If you have a header in your file, you will need to check the Skip First Row (header) so that the data can be appropriately read from your report. ExpensePoint™ will not be able to recognize the headers since we are setting those headers/columns through the setup screen.
You will also need to check the box for Numeric values are negative if your transactions are showing up negative on the report.
Lastly, it would help if you defined how the data will be read. For this, enter the Delimeter type so the ExpensePoint™ system can adequately read the data. Your options are Comma, Tab, or Semi-Colon.
By clicking on the Add button from the bottom of the CSV Properties section, you can start selecting the fields for your imported file.
From the Data Type field, choose any of the following options:
- Currency
- Date Incurred
- Description
- Exchange Rate
- Notes
- Posted Date
- Project Number
- Receipt Total
- Standard Industry Code
- Tax Amount
- Total
- Transaction Identifier
Date Format Editor
When adding the fields to your imported file, for some fields, e.g., Date Fields, you may need to set the format further through the Date Format Editor to ensure accurate reading from the file.
Note: If you look at the date in Excel format, it might differ from what is displayed. Please change your CSV file to open with Notes to see the date field in the correct format.
Locked Values
If you would like to disable the editing options for some fields, you could check the box next to the fields from the Locked Values section.
- Date Incurred
- Vendor
- Payment Types
- Lock All Amounts
- Cost Per Units
- Units
- Taxes
- Exchange Rate
- Receipt Total
- Total
Watch the video below about the Columns tab when Adding a New Template.