Entering data in sheet Data important things page 39 40 41

Group Together Data From The Same Source

Keep data from the same source close to each other. When you receive a new accounting document and want to enter data of the new document, try to enter the new data into a row immediately below the existing data from the ésame source. This is to make sure that data relating to the same source are kept close to each other. This will be helpful when you need to search for the data later on.

If the target row is already occupied by data of a different source, insert a new tow (menu Insert/Row) to accommodate the new data. When we insert a new row, all the existing data of the different source will be pushed down a row automatically.

You may think it is a good idea to just enter data in the blank row NOTE immediately below the last filled row irrespective of source group, and then sort the data according to source group. You can do it this way if as long as you don't mind having the Opening Balance data appear at the bottom of your list, i.e. in an illogical order.

Arrange Sources Of Data In Groups Of Logical Order

Grouping the data of the same source together is one thing, and arranging the sources according to a logical order is another matter. The suggested order of data groups (from top row to bottom row) is as follows (based on the column SRC):

Opening Balance
Audit Adjustments (previous yeat)
Provisions
Local Supplier Invoice
Import Invoice
Salary
Bonus
Sales
Petty Cash
Bank Book
Journals
Stock
Audit adjustments (current year)

Although this order is not compulsory, it is preferable. It is based on the logic that Opening Balance should appear at the top of a report, liabilities should appear before payments, debt should appear before payments, etc. This will be reflected in a report (eg. ledger) generated from the data.

You may have sources different from the above list. You are free to arrange them as you see fit.

41