Year-end value and reconciliation

Step by step

1. 1Update all transactions, income and payments through the financial year-end date. Compare quantities with your portfolio statement and check for missing opening positions.
2. 2Open Year-end value in the relevant module and select the financial year and position. The valuation date is the last day of that year, including financial years not ending on 31 December.
3. 3Enter the market quote per unit in the investment currency. For options and warrants, specify the quote basis and any required contract factor. For bonds, specify per unit or percentage of nominal value. Enter conversion for foreign currencies.
4. 4Ordinary valuation of purchased holdings uses cost or lower market value. A short liability uses the original net proceeds or higher settlement value. Example: €1,000 cost and €800 market value gives €800 carrying value; recovery to €1,200 restores that ordinary carrying value to at most €1,000.
5. 5Use the separate year-end value screen for participations. Futures are updated through daily settlements and receive no separate quote valuation. Complete any group valuations after ordinary year-end values.
6. 6Open Reconciliation from the Broker overview and select the reference date. Check messages about quantities, carrying values, cash settlements, interest and the opening balance. At year-end, missing or outdated closing valuations are also listed.
7. 7Resolve differences before closing the financial year through Settings, Fiscal years. If a correction makes a valuation outdated, update that valuation and any group valuation again.

What is on the screen?

• Financial year and actual end date
• Market quote and quote basis
• Conversion into the accounting currency
• Reconciliation differences and missing valuations

What happens next?

Recorded investments and payments have been compared with the ledger. Also compare against your broker statement yourself; reconciliation checks the information entered.

Continue reading