What can we help you find? Products Total Spend Management Platform Integration Technical Documentation Treasury Integrations Treasury sFTP Integrations Treasury CSV Exports

Treasury CSV Exports

View available Standard export integrations and download example files, and configure custom CSV export integrations.

Use these guidelines when setting up Standard or custom Treasury CSV exports:

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 Standard 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.

For examples of exports, download the example export files ZIP.

Export name	Description
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
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

Custom Treasury CSV export integrations

Custom Treasury export integrations are based on automation views that you configure on the respective menu items in Treasury Management.

This is supported for all objects in the new Treasury Management interface. For example, Cash Flows is supported, while Netting Items Classic is not. The Automation View field is only visible if this feature is supported for the selected object.

For more information, see Automation Views in Treasury Management.

Create Integration window for custom Treasury integration for Account Statements

Tip: When you create a new integration, it's a good idea to use the name of the Treasury menu item for the integration. You can also add that it is a custom view, for example. This makes it easier to search for custom integrations after you create them. From the Integrations table, you can then set the View filter to All and search for the name of the custom integration you want to edit, for example Settlements, Cash Flows, or just Custom.

To use the self-service to create or edit outbound Treasury integrations, use the following steps:

Go to Setup > Integrations > Integrations to configure your Treasury process.
Select Create or use the pencil icon to open an existing custom integration.
For Integration, select Flat file or Original format (see Treasury Original File Export Types).
For Direction, select From Coupa.
For Business Object, select the name of the Treasury object. The Automation View field appears when the object supports an integration that you can customize using self-service.
Note: If the Automation View field does not appear for an object, then you must request a Statement of Work (SOW) from Coupa to customize the integration.
Select a defined view from the Automation View field. This defines the filter parameters for your custom integration.
You must also select your End System Type and End System.
Important: Don't enter Internal for End System, since this setting prevents you from editing an integration.
You can use the optional Subfolder field to specify a string that is valid to be a subfolder. If you don't enter a string for the subfolder, nothing is specified and the sFTP folder for the business object is used without a subfolder.
Note: If you do not enter a value for Subfolder when you save the integration, you cannot add it later. This means you have to create a new integration to specify a string for the subfolder. Also note that when you specify a subfolder name, the system automatically pluralizes the last segment of the folder name using a standard pluralization library. For example, if you enter a path like bankfile/PDF, the last segment is pluralized, resulting in bankfile/PDFS.
You can select Enable Encryption if you use a PGP key on the sFTP account level and need the export of this integration to be encrypted.
You can select the Mark as Exported field in some integrations (for example Account Statements).
Save the integration.

After you save an integration, you schedule integration runs from the Integrations data table. To schedule integration runs, use the following steps:

Use the pencil icon to open and edit the integration from the data table.
In the Edit dialog, activate Enable Scheduler.
For Schedule, configure an available setting, for example Every 30 minutes.
Save your configuration.

For more information, see Manage Treasury integrations.