Tabs
Investment Revaluations
The Investment Revaluations tab is where you can adjust the values of your investments to reflect their current market value, which is essential for maintaining accurate financial records.
Investment Revaluation Worksheet
Even though Investment Revaluations tab allows manual entries, typically you would use Investment Revaluation Worksheet under Reports tab to calculate the figures for you.
First, navigate to Investment Revaluation Worksheet, then click New Report button.
Enter Date as of which you require to calculate the figures.
Then click Create button to create the worksheet.
The worksheet will have 3 columns.
- Calculated Realized Gain - this is recalculated realized gain
- Accounted Realized Gain - this is total of previously recorded realized gains
- and Unaccounted Realized Gain - this is a difference between Calculated Realized Gain and Accounted Realized Gain that should be posted as new transaction so your Calculated Realized Gain and Accounted Realized Gain match.
For example, if we run Investment Revaluation Worksheet where Calculated Realized Gain and Accounted Realized Gain does not match:
Demo Company | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Investment Revaluation Worksheet | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
12/01/2023 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Calculated Realized Gain | Accounted Realized Gain | Unaccounted Realized Gain | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Investment #1 | 800 | 600 | 200 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Investment #2 | 900 | 750 | 150 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1700 | 1350 | 350 |
You will see New Investment Revaluation button at the bottom of the worksheet.
When you click New Investment Revaluation, the figures from the worksheet will be copied to new investment revaluation transaction. After creating the transaction, you will be taken back to the worksheet. Now Accounted Realized Gain will be adjusted so it matches Calculated Realized Gain and the Unaccounted Realized Gain will be zero.
Demo Company | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Investment Revaluation Worksheet | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
12/01/2023 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Calculated Realized Gain | Accounted Realized Gain | Unaccounted Realized Gain | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Investment #1 | 800 | 800 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Investment #2 | 900 | 900 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1700 | 1700 | 0 |
And instead of New Investment Revaluation button, you will see Balanced notice.
Dynamic Rolling Recalculations
The Dynamic Rolling Recalculations is obsolete feature and should not be used for new businesses. Existing businesses can switch it off and move to Investment Revaluation Worksheet method.
Dynamic Rolling Recalculations poses several potential challenges and concerns when applied in a practical accounting context. Here's a detailed explanation of why this method can be problematic:
- One of the primary tenets of accounting is the consistency and reliability of historical financial data. Continuously recalculating and updating prior periods disrupts this consistency.
- Tax calculations, payments, and filings are based on financial data. If the underlying data keeps changing due to recalculations, it could lead to discrepancies in tax filings.
- If data across periods and figures keep changing, it can lead to confusion. This may erode confidence in the company's reporting practices.
- Continuously recalculating historical financial data every time a new transaction is entered can put significant strain on the system, leading to performance issues.
- If there's an error in a new transaction, and the software recalculates historical data based on that, the error can get propagated across multiple periods. Spotting and rectifying such errors can become a monumental task.
Given these concerns, while the ability to recalculate dynamically might be useful in specific scenarios or for specific analyses, it's advisable for businesses to stick to traditional accounting methods where historical data remains consistent once a period is closed. The option to turn off the Dynamic Rolling Recalculations feature in the newer versions of Manager.io allows users to choose stability and consistency in their financial reporting.
To turn off Dynamic Rolling Recalculations for Investments, go to Settings then Obsolete Features
Then click on Dynamic Rolling Recalculations where you will see Investments checked. You need to uncheck the option.
Then click Update button
This will disable Dynamic Rolling Recalculations for Investments. You should now run Investment Revaluation Worksheet for all the prior periods starting from the oldest to recent.
You can manually adjust Investment Revaluations entries to match your historical figures.