Expense Payment Import


The Expense Payments Import process read files from the ./Incoming/ExpensePayments/ folder in the SFTP. These files will be moved to the archive folder located at ./Incoming/Archive/ExpensePayments/ before being processed in Alphanumeric order. Flat Files are then transformed to Coupa's XML format.

Payment records for expenses must have an Expense Report Id value.

Note: While Expense payments can be created using CSV integration, all updates must be done through the Expense Report UI.

Column Name Description Req'd Unique Type Allowable Values
Expense Report Id* This is the Coupa generated Expense Number Yes integer
Paid-in-Full Date* This is the date the payment was completed in the payment system. Yes datetime YYYY-MM-DDTHH:MM:SS+HH:MM
Paid-in-Full Note This is an optional free form note regarding the payment that was made (paid by who, transaction number, etc) No string(255)