Treasury Account Statement Import

Overview

You can upload account statement CSV files manually from the Bank Files Overview or Account Statements menu items or by using SFTP import.

Coupa can import statement files of any size as long as each .zip file is less than 100MB.

Note:

If you need to load multiple account statements, Coupa recommends combining them into a single file. As every instance has a limited number of resources, loading multiple files can cause performance degradation.

Example: You need to load statements for Account A, Account B, and Account C. Instead of loading each statement as an individual file, combine into a single file in order to ensure optimal speed and results while processing.

Validations

The flexible CSV account statement format captures all relevant account information from your uploaded files. This allows you to provide CSV account statements containing any of the following options:

• Balances and transactions

• Only balances

• Only transactions

Files with any of these will be treated as complete statements and any missing information will be generated by Treasury’s system logic. 

For account statements which are provided without transactions, the logic calculates and creates a transaction in the system. For statements with missing balance information, the logic calculates balances based on the information in the transactions.

Calculation

The Statement line is required for each statement. 

Statement line

Statement Number

Statement Number is calculated based on the calendar day numbering of the Closing Date.

Example: Closing Date of June 20, 2024 = Statement Number 172, since 06/20/24 is the 172nd calendar day of 2024.

Closing Date

Calculate the maximum Booked date of all transactions on this statement.

Closing Balance

A balance is created with the following values:

The sum of Opening Balance and sum of all transaction amounts (Opening Balance + sum of transactions)

Opening Date

• Closing Booked Date of the previous account statement of the same account is taken.

• If there is no previous account statement, the minimum Booked Date of all transactions on this statement is taken.

• If there is no previous account statement and no transactions, the Closing Date (-1d) is taken.

Opening Balance

• If there is a previous account statement, the Closing Booked Balance of the previous End of Day Statement of the same account is taken.

• If the Starting Date of the Account is before the Opening Date, the Booking Date Starting Balance of the account is taken.

• If the Starting Date of the account is after the Opening Date, the Booking Date Starting Balance minus (-) sum of transactions is calculated.

Transaction line

The transaction line is optional. If no transaction line is provided for a Statement line, the Closing Date and Closing Balance become required (*) and one (1) transaction will be created.

Amount

Calculated based on the difference between Closing Booked Balance and Opening Booked Balance (Closing Booked Balance minus (-) Opening Booked Balance = Transaction Amount).

If the amount = 0, no transaction will be created.

Value Date

The date of the Closing Booked Balance is taken.

Payment Reference

For balance-only statement.

Booking Date

• The date of the Closing Booked Balance is taken.

• If Closing Date is not present, the Value Date of the transaction is taken.

 Status Code

The default Status Code is Booked.

You can access a template with all available fields from the Account Statements menu item.

Statement line

Transaction line