Defined contribution unitized account reconciliation · Calculation guide

Use the actual unit price for each subscription or withdrawal and one closing price.

Calculation guide

Positive differences mean the statement exceeds the computed account.

units(t) = units(t−1) + cash(t)/price(t). V = units(n) × closing price.

Inputs

Opening units

Example entry 100.

Closing unit price

Example entry 12 (in the selected currency). Minimum 1e-06.

Reported closing balance

Example entry 1450 (in the selected currency).

Net contribution (withdrawals negative)

Example entry 200 (in the selected currency).

Unit transaction price

Example entry 10 (in the selected currency). Minimum 1e-06.

Worked example

InputValue
Opening units100
Closing unit price12
Reported closing balance1,450

Cash transactions in order

Net contribution (withdrawals negative)Unit transaction price
20010
ResultValue
Calculated closing balance1,440
Statement less calculated balance10

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Opening units100110Calculated closing balance1,4401,560
Closing unit price1213Calculated closing balance1,4401,560
Reported closing balance1,4501,595Statement less calculated balance10155
Net contribution (withdrawals negative) (row 1)200220Calculated closing balance1,4401,464
Unit transaction price (row 1)1011Calculated closing balance1,4401,418.181818
Defined contribution unitized account reconciliation →

Sources