Entering data in sheet Data column ‘NOTE’ (Column F G H)

Filling cells under column title ‘NOTE’ (Column F)

Under the column title 'NOTE', enter any note you want regarding the transaction. If there is no note to write, you can leave blank.

Filling cells under column title ‘ACCOUNT-DEBIT’ (Column G)

Under the column title 'ACCOUNT-DEBIT', enter the account name that you want it to be debited. The account name must already exist in the Chart of account (in TB sheet). If the account name not yet exist, update the Chart of account (in TB sheet).

Excel is very sensitive about spelling. A single dot or a single space can mean a different item. For example, 'My World" with "My World" is considered different, because of more spaces in the latter. "MyWorld" with "My.World" is also different, because of a dot in the latter. Another example, 'My World" with "My World " is considered different because of the additional space after the end of the latter word . This is difficult to trace since we cannot see the space character.

To check whether there is an additional space at the end of the account name, activate the cell and press F2. Look at the position of the caret. You will notice whether there is any space before the caret.

Or, the formula in cell under column title 'CHECK ACCOUNT-DEBIT' will flag you if the account does not yet exist (may be due to slight different in spelling). However, small letter or capital letter is not treated as different.

Filling cells under column title ‘RM-DEBIT’ (Column H)

Under the column title 'RM-DEBIT', enter the amount of the account name that you debited. For example, 1000. If you format appropriately, it will appear as "1,000.00" or "RM 1,000.00" etc.