Skip to main content

[Extension] Bookkeeping - Deferrals

Overview of deferrals

Deferral processes generate deferral transactions for bookkeeping purposes. The "Deferrals" package contains separate processes for handling deferral of accrued interests, deferral of bond purchase price (with linear approach and contact yield method) and deferrals of other securities' purchase values based on the market value. Find more detailed descriptions of the processes below.

These deferral processes create transactions for bookkeeping purposes. You can map these transactions to appropriate bookkeeping accounts through posting rules - when these transaction are generated, appropriate postings are generated for accounting purposes. See also required transaction types for deferrals below.

Bookkeeping - Deferral of accounts

This process calculates profits and losses for your currency accounts. It creates Cashflow in (Internal) and Cashflow out (Internal) transactions whose value equals the entire account balance, and which use the latest FX rate. The Cash out transaction realizes all profits on the cash account, and the Cash in adds back the account balance with the latest FX rate. The created transactions can then be used in accounting to handle account profits and losses.

Bookkeeping - Deferral of accrued interest

This process calculates accruals for your bonds' accrued interests for bookkeeping purposes. The generated transactions can be used in bookkeeping to handle accrued interest properly, allowing you to book accrued interests of bonds for the period you have earned them, prior to the actual interest payment.

The deferral transactions created by this process contains the sum of accrued interests between the selected dates. You can select to either create one transaction per each bond, or a single combined transaction per portfolio (i.e. sum of all deferrals in the portfolio). In addition, you can configure the process to "reverse" the deferrals (or create counter-transactions to reverse the effect of the deferral) either with the same or a different transaction type - this allows you to book deferrals of accrued interest flexibly.

Bookkeeping - Deferral of bond purchase price

This process calculates deferrals for your bonds' purchase price for bookkeeping purposes. The generated transactions can be used in bookkeeping, allowing you to book purchase prices of your bonds periodically between purchase and maturity.

This process supports two methods for calculating the deferral transactions: linear method calculates deferral based on the bond purchase price versus its price at maturity, and constant yield method (also know as "amortized costs") calculates the deferral based on the bond's yield at the time of purchase versus its yield on the day of the deferral.

Linear method

The linear method generates deferral transaction based on the bond purchase price vs its price at maturity.

Calculation logic:

Maturity price = nominal value in portfolio currency corrected with the maturity price if its different from 100%

Over/underprice = maturity price - purchase price

Total days = days between purchase date and maturity date

Deferral days = difference between start date (or purchase date if its after the start date) and end date (or maturity date if its before the end date)

Deferral = Over/underprice * deferralDays / totalDays

Constant yield method

The constant yield method generates deferral transaction based on the bond's yield at the time of purchase vs its yield on the day of the deferral. This means that the process calculates the initial yield to maturity for each purchase lot, and uses that to calculate the bond position's expected price for the given date. The resulting deferral transaction captures the difference between this calculated price and the position's purchase price.

Note

You should use a portfolio valuation type that keeps separate items, eg. FIFO or "Average price with separate items" in order for the purchase dates of all purchase lots to be considered.

Calculation logic:

YTM = Yield at purchase

Calculated unit price = Based on YTM on the day of the deferral:

Deferral = Calculated unit price - Purchase unit price

Bookkeeping - Deferrals of other securities

This process calculates deferrals for any kinds of securities for closing the portfolio at the end of the accounting year for bookkeeping purposes. The generated transactions can be used in bookkeeping, allowing you to re-valuate the booked purchase value of other types of securities based on the market value at year-end.

The deferral transactions created by this process re-valuate your open positions' booked purchase value based on the market value of the position at year-end. This allows you "close the books" on your portfolios at year-end. You can also calculate separate adjustments for changes in currency and security prices, and configure how the re-valuation affects your portfolio's booked purchase value.

This process supports creating a single adjustment, or creating separate adjustments due to currency and security changes. In the single adjustment mode, the logic compares the current booked purchase value against the market value and updates the booked purchase value:

  • To be the market value, if market value was less than the booked value

  • To be the market value, if the market value was greater than the booked value but less than the original purchase value

  • To be the original purchase value, if the market value was greater than the original purchase value

If the process is configured to create separate adjustments due to currency and security changes, the logic is more complicated:

  • Security adjustment: if market value (sec) is larger than the original purchase value (sec), then original purchase value (sec) - purchase value (sec). Otherwise market value (sec) - purchase value (sec). Used fx rate is the purchase fx rate, if market value (sec) is larger then the original purchase value (sec), otherwise market fx rate.

  • Fx adjustment: (purchase value (sec) + Security adjustment (sec))/market fx - (purchase value + Security adjustment). The fx adjustment is always done with the market fx rate.

Required transaction types for deferrals

These processes create transactions, that can be mapped to appropriate bookkeeping accounts using posting rules. Follow the configurations below to set up the transaction types used by the processes:

Name (Code)

Description and effects

Deferral of accrued interest

(DAI)

Transaction type for "Deferral of accrued interest", allowing you to book accrued interests of bonds for the period you have earned them, prior to the actual interest payment.

Effects // FIFO: Add

Deferral of bond purchase price

(DEFPR)

Transaction type for "Deferral of bond purchase price", allowing you to book purchase prices of your bonds periodically between purchase and maturity.

Effects // Purchase price: Reduce, record orig values

Value adjustment

(VAAD)

Transaction type for "Deferral of other securities", allowing you to re-valuate the booked purchase value of securities based on the market value at year-end for "closing the books". This transaction type should be used for single adjustments.

Effects // Purchase price: Reduce, record orig values

Value adjustment (sec)

(VAADSEC)

Transaction type for "Deferral of other securities", allowing you to re-valuate the booked purchase value of securities based on the market value at year-end for "closing the books". This transaction type should be used if separate adjustments are created due to currency and security changes.

Effects // Purchase price: Reduce in security currency, record orig values

Value adjustment (fx)

(VAADSEC)

Transaction type for "Deferral of other securities", allowing you to re-valuate the booked purchase value of securities based on the market value at year-end for "closing the books". This transaction type should be used if separate adjustments are created due to currency and security changes.

Effects // Purchase price: Reduce and set fx, record orig values