In some cases, users may notice that the Market Movement figure in the Operating Statement does not match the Market Movement figure shown in the Market Movement Report. This discrepancy is often caused by manual revaluations posted directly to asset accounts without a corresponding entry to Account 24700 (Unrealised Gain/Loss).
What Causes the Difference?
The key cause of the mismatch is when manual revaluations are entered directly into asset accounts via journal entries. These revaluations can affect how the Market Movement is calculated and displayed in different reports.
- The Market Movement Report uses revaluations posted to the investment account to calculate unrealised gains and losses.
- The Operating Statement reflects all posted revaluations to the 24700 account.
As a result, if you've manually revalued an asset by posting journals, those entries will be included in the Market Movement Report but not reflected in the Operating Statement’s Market Movement figure unless there is a corresponding entry that has been made to Account 24700.
How to Reconcile the Difference
To identify and fix these discrepancies:
| From the Main Toolbar, go to Accounting | |
| Select Transactions |
Tick all transaction types to ensure a complete view.
Use the filter to display only transactions related to the relevant investment account.
Review the transactions to identify any entries to investment accounts (appearing in the Notes to the Financial Statements) that:
- Have blank units
- Do not have the other side of the journal posted to Account 24700
What to Do Next
Depending on the nature of the transaction, take one of the following actions:
If the transaction was intended as a cost base adjustment, refer to these help articles:
After making changes, you may need to reverse and re-create the entries before reviewing the reports again.
If the transaction is meant to be a revaluation, it is recommended to enter a Security Price under Investment | Investment Security List for the relevant asset. This allows the system to automatically handle revaluations via the Create Entries process.