How to Utilize the Cash Flow Template

Cash Flow Template Guideline:

• You can add any cash flow transaction between 2 parties.

• For each transaction, you can additionally state the involved accounts from each party and the purpose of the transaction.

• The transaction purpose can be with an existing asset, liability, or legal entity in ORCA.

• The whole list of available cash flow verbs can be found by Clicking the Toggle ▶️

Cash Flow Template

• Column A - Type (Required)
• The type will always be ‘event’

• Column B - ID (Optional)
• Can leave blank

• Column C - Event Type (Required)
• The type will always be ‘cashflow’

• Column D - Date (Optional) - Date format = YYYY-MM-DD
• While inputting the Date is initially optional, we recommend adding dates later to utilize the Time Travel feature. If you have the dates, please input them here. You also have the option to return to the transaction in Orca and provide a date.

• Column E - Subject (Required)
• Use the Unique Identifier you have created from importing ‘Items / Entities’ to be the Point of Origination

• Column F - Subject Account (Required)
• Use the Unique Identifier you have created from importing ‘Items / Entities’
• Entity example = Bank Account

• Column G - Action (Required)
List of Cash Flow actions
• gifted
• was gifted
• inherited
• bequeathed
• paid dividends of
• received dividends of
• paid a commission of
• received a commission of
• paid an interest of
• was paid an interest of
• paid an invoice of
• received an invoice payment of
• transferred
• was transferred
• paid a contractual fulfillment of
• received a contractual fulfillment of
• donated
• received a donation of
• paid capital contribution of
• was paid a capital contribution of
• withdrew capital
• was withdrawn capital
• paid a settlement agreement
• received a settlement agreement

• Column H - Amount (Optional)
• Columns H and I are correlated

• Column I - Amount Unit (Optional)
List of Currencies:
AED	AFN	ALL	AMD
ANG	AOA	ARS	AUD
AWG	AZN	BAM	BBD
BDT	BGN	BHD	BIF
BMD	BND	BOB	BRL
BSD	BTC	BTN	BWP
BYN	BZD	CAD	CDF
CHF	CLP	CNY	COP
CRC	CUC	CUP	CVE
CZK	DJF	DKK	DOP
DZD	EGP	ERN	ETB
EUR	FJD	FKP	GBP
GEL	GHS	GIP	GMD
GNF	GTQ	GYD	HKD
HNL	HRK	HTG	HUF
IDR	ILS	INR	IQD
IRR	ISK	JMD	JOD
JPY	KES	KGS	KHR
KMF	KPW	KRW	KWD
KYD	KZT	LAK	LBP
LKR	LRD	LSL	LYD
MAD	MDL	MGA	MKD
MMK	MNT	MOP	MRU
MUR	MVR	MWK	MXN
MYR	MZN	NAD	NGN
NIO	NOK	NPR	NZD
OMR	PAB	PEN	PGK
PHP	PKR	PLN	PYG
QAR	RON	RSD	RUB
RWF	SAR	SBD	SCR
SDG	SEK	SGD	SHP
SLL	SOS	SRD	SSP
STN	SVC	SYP	SZL
THB	TJS	TMT	TND
TOP	TRY	TTD	TWD
TZS	UAH	UGX	USD
UYU	UZS	VES	VND
VUV	WST	XAF	XCD
XOF	XPF	YER	ZAR
ZMW	ZWL
 

• Column J - Counterparty (Required)
• Use the Unique Identifier you have created from importing ‘Items / Entities’ to be the other party or entity involved in a financial transaction or agreement.

• Column K - Counterparty Account (Optional)
• Use the Unique Identifier you have created from importing ‘Items / Entities’
• Example = Bank Account of the Counterparty

• Column L - Purpose (Optional)
• Use the External ID you have created from importing ‘Items / Entities’
• You have the option to provide External ID of a Legal entity or Asset

• Column K - Notes (Optional)
• Useful for explaining the details of this Cash Flow event