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
| Input | Value |
|---|---|
| Opening units | 100 |
| Closing unit price | 12 |
| Reported closing balance | 1,450 |
Cash transactions in order
| Net contribution (withdrawals negative) | Unit transaction price |
|---|---|
| 200 | 10 |
| Result | Value |
|---|---|
| Calculated closing balance | 1,440 |
| Statement less calculated balance | 10 |
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Opening units | 100 | 110 | Calculated closing balance | 1,440 | 1,560 |
| Closing unit price | 12 | 13 | Calculated closing balance | 1,440 | 1,560 |
| Reported closing balance | 1,450 | 1,595 | Statement less calculated balance | 10 | 155 |
| Net contribution (withdrawals negative) (row 1) | 200 | 220 | Calculated closing balance | 1,440 | 1,464 |
| Unit transaction price (row 1) | 10 | 11 | Calculated closing balance | 1,440 | 1,418.181818 |
