.png){kind=logo}
CSV - Expenses
- 20 Nov 2023
- 1 Minute to read
- Print
- DarkLight
- PDF
CSV - Expenses
- Updated on 20 Nov 2023
- 1 Minute to read
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
CSV - Expenses File Adapter imports information about transactions related to SaaS from a CSV file.
The adapter parameters are the same as the CSV Legacy Remote File Configuration. Since the CSV - Expenses adapter provides data about transactions only, unlike the generic CSV adapter, there is no option to configure the adapter to contain information about Users, Devices, or any other type of asset.
The functionality of this adapter is the same as the CSV adapter.
Note that the Accepted CSV field names are case insensitive.
Which fields are imported with an Expenses file?
The following data is imported as part of the Expenses file.
| Field | Accepted CSV Field Name(s) | Notes | Required? |
|---|---|---|---|
| Transaction ID | Transaction ID, Report ID, ID, Identifier, Invoice number | Internal transaction ID of the CSV’s source | No |
| Transaction date | Transaction date, Date, Invoice date, Invoice voucher date | Transaction date | Yes |
| Amount | Amount, Total amount, Expense line amount, Spend, Spend_USD | Transaction amount | Yes |
| Original currency | Original currency, Currency | Transaction original currency | No (USD is the currently supported currency |
| Application | vendor name, Vendor, Supplier, Supplier name, application | The SaaS product purchased | Yes |
| Transaction description | Transaction description, Description, Comments, Invoice description, Invoice line description | Transaction’s description | No |
| Department | Department, BU, BU name, Business unit | Transaction on behalf of which department | No |
| Reported by email | Reported by email, Employee, Emp Email, submitted by, Submitter, mail, email, usermail, mailaddress, email address, emailprimarywork | Owner (email appearing in the transaction) | No |
Was this article helpful?