CSV - Expenses

Updated on 20 Nov 2023
1 Minute to read

Print
Share
Dark
Light
PDF

Article Summary

Share feedback

Thanks for sharing 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?

What's Next

CSV - Licenses

Table of contents

Which fields are imported with an Expenses file?