Treasury Cash Flow Import

Overview

The Treasury Cash Flow File Import process read files from ./Incoming/CashFlows/ in the SFTP. These files will be moved to the archive folder located at ./Incoming/Archive/CashFlows/ before being processed in alphanumeric order.

Column Name

Description

Req'd

Unique

Type

Allowable Values

Account

Account Name

Yes

(string)50

any

Amount

Amount

Yes

decimal

cannot be zero

Value Date

Value Date

Yes

date

mdy, dmy, ymd

Booking Date

Booking Date

date

mdy, dmy, ymd

Payment Reference

Free text containing additional information about the transaction

(string)400

any

Project

Internal reference as defined in Coupa Treasury

(string)50

any

Portfolio

Internal reference as defined in Coupa Treasury

(string)50

any

Counterparty

Internal reference as defined in Coupa Treasury

(string)50

any

Cash Flow GL number

String of numbers or letters referencing the general ledger

(string)50

any

CategoryID

ID planning category as defined in Coupa Treasury

(string)50

any

Cash Flow category

ID cash flow category as defined in Coupa Treasury

(string)50

any

Comment

Comment

(string)500

any