Field Name

Description

Period

The period name.

Period ID

The internal identifier used for a period.

Currency Code

The Bank Account Currency Code.

Opening

Opening balance for the period.

Deposits

Deposits made during the period.

Withdrawals

Withdrawals made during the period.

Balance

Balance at the end of the period.

Opening Balance Bs

Opening Balance in the base currency.

Opening Unrealised Bs

Opening unrealised amount in the base currency. This is calculated as:

Variation Unrealised Bs + previous period Opening Unrealised Bs.

See CB Realised and Unrealised Balances Example.

Deposits Bs

Deposits made during the period in the base currency.

Withdrawals Bs

Withdrawals made during the period in the base currency.

Realised Bs

The variation realised in the base currency. See CB Realised and Unrealised Balances Example.

The Current Realised Bs is calculated as:

(Current Activity / Current Rate) - Current Activity Bs

The Variation Realised Bs is calculated as:

Opening Realised Bs + Current Realised Bs

Unrealised Bs

The variation unrealised in the base currency. See CB Realised and Unrealised Balances Example.

The Variation Unrealised Bs is calculated as:

(Period Closing Balance / Exchange Rate) - (Period Closing Balance Bs Before Revaluation + Variation Realised Bs)

Closing Balance Bs

Closing balance in the base currency.

Deposit Activity Last Year

Deposit made during the period in the previous year.

Period Activity

Amount of activity in the period, calculated as Deposits - Withdrawals.

Period Activity Bs

Amount of activity in the period, in the base currency.

Period Activity Bs Last Year

Amount of activity in the period, in the base currency, in the previous year.

Period Activity Last Year

The activity for the period in the previous year.

Period Closing Balance Bs Last Year

Closing balance for the period in the base currency, in the previous year.

Period Closing Balance Last Year

The closing balance for the period in the previous year.

Period Opening Balance Bs Last Year

The opening balance for the period in the base currency, in the previous year.

Period Opening Balance Last Year

Opening balance for the period in the previous year.

Period Opening Unrealised Bs Last Year

Opening unrealised amount in the base currency, for the previous year. This is calculated as:

Variation Unrealised Bs + previous period Opening Unrealised Bs.

See CB Realised and Unrealised Balances Example.

Variation Activity Bs

The variation activity in the base currency, calculated as Variation Realised Bs - Variation Unrealised Bs.

Variation Activity Bs Last Year

The variation activity in the base currency, calculated as Variation Realised Bs - Variation Unrealised Bs in the previous year.

Variation Realised BS Last Year

The variation realised in the base currency, in the previous year. See CB Realised and Unrealised Balances Example.

The Current Realised Bs is calculated as:

(Current Activity / Current Rate) - Current Activity Bs

The Variation Realised Bs is calculated as:

Opening Realised Bs + Current Realised Bs

Variation Unrealised Bs Last Year

The variation unrealised in the base currency, in the previous year. See CB Realised and Unrealised Balances Example.

The Variation Unrealised Bs is calculated as:

(Period Closing Balance / Exchange Rate) - (Period Closing Balance Bs Before Revaluation + Variation Realised Bs)

Withdrawal Activity Last Year

Withdrawals made during the period in the previous year.