The first step we have to do,after the file (workbook) created, is creating sheet containing chart of accounts named “ca”. The existance of this sheet will enable us to enter account in General Journal by just entering its number. Entering accounts this way will save time a bit and avoid errors. From the figure we can see that this sheet consist of four column:
Number
Account Title
NB
Explanation
Column Number contained account number. Column Account Title is for account title. Column NB for the normal balance position of each account. Other information about accounts can be filled in column Explanation.
All column starting from columns' header to the lowest row (marked by different colour) is named “rca”. This range name will make it esier for us to refer to when we use this data in the sheet in other sheet. When we need data in the range, in our formula for example, we just refer to the name of the range.
No comments:
Post a Comment