PART IV. GENERAL JOURNAL

Create Sheet General Journal, named “gj”, to record transactions. The sheet consist of eight column as follows:

1. Date, to record date of transactions

2. Doc Nr, to record number of source documents

3. Acc Nr, to record accounts number

4. SL , to record customer/suplier card number

5. Account Title, to record account title

6. Explanations, to record brief explanation of the transaction

7. DR, to record amount debited

8. CR, to record amount credited

Format different colour at the last row. Transactions should not recorded beyond this marked row. If we need more rows, inserting rows must be done somewhere above the marked row. To check whether total amount debited and total amount credited are balance, put sum formula at the end and at the top of column DR and CR to sum all amount debited/credited.

Some columns should be range named. This will make us esier to refer to when we need the data at other sheet. Cells included in each columns starting form column's header and ended in lowest cell (cell marked by different colour). The range name and their respected columns are as follows:

1. gjn for column Acc Nr

2. sl for column SL

3. gjd for column DR

4. gjc for column CR

Only limited automation can be done here. All transactions data should be entered manually but accounts title. The cells in Accounts Title column contain Vlookup formula to refer account title to rca range on sheet ca. The formula are:

=Vlookup(C6;rca;2;false)

This formula will get the account title of account number typed in column “C”. This will avoid error. We just need to type this formula once, that is in the first row of column “E”. Then we just simply copy this cell to the cells in the following rows. Of course, this will save much time.