Entering Data In The PL-DETAIL Column (Column E)
Under the column titled PL-DETAIL (for Profit & Loss Detail), enter the actual account names which the accounts (under column ACCOUNTS) will appear in the Profit & Loss statement. This is relevant for accounts which usually come into the Profit & Loss statement. If the accounts come into a Balance Sheet category, write NR (for Not Relevant) or use a blank instead.
Sometimes, the account name you use in the Chart of Accounts is slightly different from what you want to appear in the Profit & Loss statement. For example, in the Chart of Accounts, you use P & S, but in the Profit & Loss statement you want it to appear as Printing & Stationery.
In another example, in the Chart of accounts under the column ACCOUNTS, you have many items related to salary, e.g. Salary-Basic, Salary-Allowance, Salary-EPF etc., but under column PL-DETAIL, you want to group it all under one name ie. Salary since this is the name that will appear in the Profit & Loss statement.
Do not miss a single account.
Copying Formula Into Cells In The RM-DEBIT Column (Column F)
Located immediately under the column titled RM-DEBIT is the cell F5 which contains a formula. This formula will get the total of Debit amounts (in column H in sheet DATA) for every account name in column G (in sheet DATA) which matches the account name that appears in cell A5 (in sheet TB). The formula is:
=SUMIF(INDIRECT("DATA!G5: G30000"), A5, INDIRECT("DATA! HS: H30000"))
Be careful not to delete the formula in this cell.
Copy this formula down to every row where the corresponding cell in column A has an account name. The formula will get the net total of RM-Debit amounts for each account. Remember, you can use Ctrl+D keyboard keys to copy down.
Do not miss copying the formula for a single account.
23
Copying Formula Into Cells In The RM-CREDIT Column (Column G)
Located immediately under the column & titled BM CREDIT is the cell G5 which contains a formula. This formula will total the Credit amounts (in columin I in sheet DATA) for every account name in column I in sheet DATA) which matches the account name that appear in cell A5 (in sheet TB). The formula is :
=SUMIF (INDIRECT("DATAIIS 130000"), AS, INDIRECT("DATA! JS 330000"))
Be careful not to delete the formula in this cell.
Copy this formula down to every row where the corresponding cell in column A has an account name. The formula will get the net total of RM-Credit amounts for each account. Remember, you can use Ctrl+D keyboard keys to copy down.
Do not miss copying the formula for a single account.
Copying Formula Into Cells In The RM-NET Column (Column H)
Located immediately under the column H titled RM-NET is the cell H5 which contains a formula. The formula is:
=F5+G5
This formula will gets the net total of RM-Debit amounts and RM-Credit amounts for account in cell A5.
Copy down this formula for every row which its corresponding cell in column A has an account name.
Do not miss copying the formula for a single account.
24
No comments:
Post a Comment