Entering data in sheet Data column ACCOUNT CREDIT (Column I)

Entering Data In The ACCOUNT-CREDIT Column (Column I)

In the ACCOUNT CREDIT column, enter the account names that you want to be credited. The account name must already exist in the Chart of accounts (in TB sheet). If an account name does not yet exist, update the Chart of accounts (in TB sheet).

As explained at the top of the page, excel is very particular about spelling. A single dot or a single space can mean a different item.

33
Entering Data In The RM-CREDIT Column (Column J)

In the RM-CREDIT column, enter the amounts of the account names that you credited. For example, -1000. Precede the credit amount with minus sign. The minus sign indicates a credit amount. If you have formatted the column appropriately, it will appear as "(1,000.00)" or "(RM 1,000.00)" etc.

Entering Data In The CHECK ACCOUNT-DEBIT Column (Column K)

In the CHECK ACCOUNT DEBIT column, cell K5 should already contain the following formula:

=IF(ISERROR(VLOOKUP(G5, INDIRECT("TB!A5: A2000"), 1, FALSE)), "NOT OK", "OK")

If there are more entries in the cells below it, just copy down the formula. The formula will return NOT OK if the account name in the column ACCOUNT DEBIT is not listed in sheet TB. The formula will return OK if the account name in column ACCOUNT-DEBIT is listed in column A in sheet TB.

Review this column to check for non-existent account names.

Entering Data In The CHECK ACCOUNT-CREDIT Column (Column L)

In the CHECK ACCOUNT CREDIT column, cell 15 should already contain the following formula:

=IF(ISERROR(VLOOKUP(IS, INDIRECT("TB!A5: A2000"), 1, FALSE)), "NOT OK", "ОК")

If there are more entries in the cells below it, just copy down the formula. The formula will return NOT OK if the account name in the column ACCOUNT CREDIT is not listed in sheet TB. The formula will return OK if the account name in column ACCOUNT CREDIT is listed in sheet TB

Review this column to check for non-existent account names.

34