General guide to entering data in sheet Data

GENERAL GUIDE TO INPUTTING DATA IN SHEET 'DATA'

Once the structure of DATA sheet are ready, you can start inputting data in sheet ‘DATA’.

Data that you want to input is based on the financial transaction document we have on hand, such as invoice, vouchers, journals, etc. Enter the data available in each document in the appropriate cell under an appropriate column title in the same row.

A row containing data of a document in its appropriate column is called ‘Transaction row’. Sometimes, data in a row is called a ‘record’.

Data should start at row 5 and continue until row 30000. If your data exceed row 30000, change all references to “30000” in all formula in all sheets.