Cash Flows

This report enables you to track all payment transactions from your loan and investment agreements, highlighting the realised foreign exchange (FX) differences for agreements in a currency different from the entity's base currency. The direction of the payment (incoming or outgoing) is indicated by the sign of the payment amount.

Report Customization

• Access various filters, including entity, portfolio, counterparty, or specific loan IDs.
• Currency conversion is mandatory for this report, using the end date market rate available under Settings > Market data > Foreign exchange rates.
• There are several columns in the report. If you prefer to have less columns, you can hide columns under 'Column visibility'. This way you can present only the preferred information in report and can run more detailed report separately if needed.

Columns explained

Interest %

The current interest rate used for the interest calculation.

Payment date

The actual payment day of the transaction.

Outstanding amount

The open loan/investment balance at the payment date in the agreement currency.

Outstanding amount (base)

The open loan/investment balance at the payment date in entity's base currency.

Amortization amount

The capital payment in the agreement currency.

Amortization amount in base ccy

The capital payment in entity's base currency, if there is a currency conversion then the system uses a  payment date fx rate.

Realised FX difference

When the loan is in different currency than the entity's base currency. If positive, this is a gain posted normally to the debit BS / credit P&L realised FX difference (gain). If negative, this is a loss posted normally to the debit P&L realised FX difference (loss) / credit BS.

Interest

The interest payment in the agreement currency.

Interest amount in base ccy

The interest payment in the entity case currency.