New accounting year item 22 23 pg 176 177

22. Zerorise Investments category accounts amounts from the previous year

Naturally, after we set one figure to represent the net total of amounts of Investments, we need to zerorise the details amounts. We can find the amounts under columns RM-DEBIT and RM-CREDIT, where the corresponding accounts are in column ACCOUNT-DEBIT and ACCOUNT-CREDIT respectively.

Here are the steps to identify the amounts and to zerorise them:

1. Make sure the data in sheet DATA is in AutoFilter mode.

2. Click the arrow-head on the right of the column title ACCOUNT-DEBIT.

3. A list will appear. Select the investment category account name that you want.

4. Now, you should see only transactions rows where the item in column ACCOUNT-DEBIT is the investment category name you selected.

176

5. Replace each previous year figure under the column RM-DEBIT with 0 (zero), one by one. You probably will not have many to replace. If otherwise, to zerorise faster, copy a zero figure, then select the target range and paste into the selected range.

6. Save the file.

7. Remove the filtering mode.

8. Next we want to see only transactions rows where the item in column ACCOUNT-CREDIT is the same investment category account name. So, switch to the AutoFilter mode again.

9. Click the arrow-head on the right of the column title ACCOUNT CREDIT.

10. A list will appear. Select the same investment category account name.

11. Now you should see only transactions rows where the item in column ACCOUNT CREDIT is the investment category account name you selected.

12. Replace each previous year figure under column RM-CREDIT with 0 (zero). You probably will not have many to replace. However, if otherwise, to zerorise faster, copy a zero figure, then select the target range and paste into the selected range.

13. Save the file.

14. Remove the filtering mode.

15. Check that the absolute total of RM-DEBIT (in cell H1) and RM-CREDIT (in cell J1) is still the same. Otherwise, you may not have identified the amounts correctly. A review of the assets accounts may help you identify the reason.

16. Repeat the operation for each investments category account.

23. Handling other accounts

For any other group of accounts not identified in this book, you can use one of the methods mentioned above.

177