Treasury CSV Exports

View available exports and download example files.

Design considerations

When setting up Treasury CSV exports, use these guidelines:

  • Columns are not configurable. All treasury exports contain the full set of available fields.
  • Always build your integrations using file headers instead of column positions, as positions are subject to change.
  • Exported data cannot exceed the supported limit of 150,000 rows.
  • For more information on the elements for the CSV exports, refer to the API documentation in the Treasury application. See View Treasury API Documentation.

For more information, see Using the Flat File Format.

Available exports

File names contain the object name, date, timestamp, and an integer to prevent overwriting existing files. For example: AccountBalance_20250402_104107+0.

sFTP folders are located under /Outgoing followed by a dedicated folder per object. For example: /Outgoing/AccountBalances. The folders are automatically created once the export triggers.

Note:

Any changes to the standard integrations require a statement of work. If you need to make changes, reach out to your Coupa representative.

Export name Description Example file download

Account Balance

Exports the value date balances of all valid accounts for d-2, d-1,d,d+1,d+2, whereas d is today

Example export files ZIP download

Account Interest Details

Exports all records that are valid at the time of the export

Account Statement

Exports all not yet exported account statements created within the last 7 days

Bulk Direct Debit 

Exports all records created or updated within the last 7 days

Bulk Direct Debit Details

Exports all records created or updated within the last 7 days

Bulk Payment

Exports all records created or updated within the last 7 days

Bulk Payment Details

Exports all records created or updated within the last 7 days

Cash Flow

Exports all cash flows created since prior day (yesterday)

Commodity Classic Deal

Exports all outstanding deals

Commodity Classic Payment Plan

Exports all commodity payments that are due today or in the future

Credit Line

Exports all outstanding deals

Credit Line Utilization

Exports today's utilization for all outstanding credit lines

Foreign Exchange Deal

Exports all outstanding deals

Foreign Exchange Option Deal

Exports all outstanding deals

GL Entry

Exports GL entries that have not been exported

Guarantee

Exports all outstanding guarantees (return date today or in the future)

Intercompany Payment

Exports all not yet exported records created or updated within the last 7 days

Interest Rate Options

Exports all outstanding deals

Interest Rate Swap

Exports all outstanding deals

Interest Rate Swap Lifecycle Event (Options)

Exports all lifecycle events on outstanding deals

Interest Rate Swap Payment Plan

Exports all payment plans where at least one payment of that plan is in the future or today

Letter of Credits

Exports all outstanding letters of credit (settlement date of today or in the future)

Liquidity Planning Data

Exports all records created or updated since the last business day (ultimo) of 2 months ago

Long Term Loan

Exports all outstanding deals

Long Term Loan Lifecyle Event

Exports all lifecycle events on outstanding deals

Long Term Loan Payment Plan

Exports all payment plans where at least one payment of that plan is in the future or today

Money Market

Exports all outstanding deals

Netting Items

Exports all records created or updated within the last 31 days

Netting Statements

Exports all statements created within the last 31 days

(Planning) Category

Exports all categories

Portfolio

Exports all active portfolios

Project

Exports all active projects

Reconciliation Results

Exports all records created within the last 7 days

Recon Invoice Archive

Exports all records created or updated within the last 31 days

Recon Invoice

Exports all records created or updated within the last 31 days

Securities

Exports all outstanding deals

Security Transactions

Exports all transactions of all outstanding deals

Settlement

Exports all records created or updated within the last 7 days

Settlement Flow

Exports all records created within the last 7 days.

(Payment) Signing Authority

Exports all valid records

Single Direct Debit

Exports all records created or updated within the last 7 days

(Single) Payment

Exports all records created or updated within the last 7 days