Entering data in sheet Data column SRC

Filling cells under column title ‘SRC’

Under the column title 'SRC' (for Source), enter a name for your source of transaction. The source refers to a group of documents having similar function that you have, such as invoices, vouchers, journals etc.

Below are some of the common sources :

1. Opening Balances
If this is the first time you use this system, or in a new accounting year, opening balances is one source of transaction. You may write 'OB' or other term of your choice to identify Opening Balance source.

2. Audit Adjustment
It is good to identify Auditor's adjustment as a separate source, rather than group them under journals. You may write 'AUDIT ADJ' or other term to identify Audit Adjustment.

3. Provisions for expenses

It is good to identify provisions for expenses as a separate source. Usually, we use journals to be our source for provisions. In this case, we identify journal for provision separate from other journals. You may write 'PROV' or other term to identify Provisions.

4. Purchase (Supplier) Invoices

This refers to invoices from local suppliers. You may write 'INV' or other term to identify Purchase Invoices.

5. Import Invoices

This refers to invoices from oversea suppliers. You may write 'IMPORT' or other term to identify Import Invoices.

6. Salary-Production

This refers to salary summary for production workers. Accounts staff may get the summary from payroll system.

It is good to obtain separate salary summary for production staff from administrative staff. You may write 'SALARY-P' or other term to identify Salary summary for production staff.

7. Salary-Admin

This refers to salary summary for administrative staff. Accounts staff may get the summary from payroll system. It is good to obtain separate salary summary for administrative staff from production staff. You may write 'SALARY-A' or other term to identify Salary summary for administrative staff.

8. Bonus-Production

This refers to bonus summary for production staff. Accounts staff may get the summary from payroll system. It is good to obtain separate bonus summary for production staff from administrative staff. You may write 'BONUS-P' or other term to identify bonus summary for production staff.

9. Bonus-Admin

This refers to bonus summary for administrative staff. Accounts staff may get the summary from payroll system. It is good to obtain separate bonus summary for production staff from administrative staff. You may write 'BONUS-A' or other term to identify bonus summary for administrative staff.

10. Sales Invoices

This refers to our sales invoices. You may write 'SALES' or other term to identify sales invoices.

11. Sale-Subsidiary XX

This refers to sales invoices to one of our subsidiary with name XX. It is good to identify sales to each subsidiary as separate source. You may write 'SALE-X' or other term to identify sales to company X (a subsidiary).

12. Sale-Associate co. XX This refers to sales invoices to one of our accociate company. It is good to identify sales to each associate company as separate source. You may write 'SALE-X' or other term to identify sales to company X (an associated company).

13. Sale-Holding company

This refers to sales invoices to our holding company. It is good to identify sales to holding company as separate source. You may write 'SALE-H-X' or other term to identify sales to company X (holding company).

14. Petty Cash

This refers to one of petty cash transactions (receipts and payments). It is good to identify each petty cash float as separate source. You may write 'PC-X' or other term to identify Petty Cash float managed by staff X.

15. Banks

This refers to one of banks transactions (receipts and payments). It is good to identify each one bank as separate source. You may write 'BANK X' or other term to identify Bank X transactions.

16. Interest on HP

This refers to interest on hire purchase of one item. It is good to identify each item under hire purchase as a separate source. Usually, we use journals to be our source for interest on Hire Purchase. It is good to identify interest on hire purchase as separate source from general journals. You may write 'INT-HP-X' or other term to identify Hire Purchase Interest for item X.

17. Depreciation

This refers to depreciation of one type or category of fixed assets. It is good to identify depreciation of each one type of assets as separate source rather than lump them all together. You may write 'DEPR-X' or other term to identify Depreciation for item X.

18. Journal

This refers to general journals, ie journal which could not be conveniently identified as separate source. As we see, normally depreciation and interest on hire purchase will lump under journals. But since we can conveniently identify them as separate source, we do separate it. You may write 'JOURNAL' or other term to identify journals.

19. Closing Stock-Raw material

This refers to closing stock of raw material. Accounts staff may get the summary from store system. You may write 'CS-RM' or other term to identify Closing Stock of Raw Material.

20. Closing Stock-Finished Product

This refers to closing stock of finished product. Accounts staff may get the summary from store system staff. You may write 'CS-FP' or other term to identify Closing Stock of Finished Product.

21. Closing Stock-Semi-Finished Product

This refers to closing stock of semi-finished product Accounts staff may get the summary from store system. You may write 'CS-SF' or other term to identify Closing Stock of Semi-Finished Product. Variances in source identified You may identify sources differently eventhough the above samples are most common. Below are some of the difference :

Some company file their suppliers invoices in a file for each supplier, rather than ALL supplier invoice in ONE file. If this is the case, it is more appropriate if the source is written such as "INV-SUPPLIER XXX", "INV-SUPPLIER YYY", and so on. The sample in this book assume that ALL supplier invoices are kept in ONE file.

Some company file their sales invoices in the separate file for each customer, rather than ALL sales invoice in ONE file. If this is the case, it is more appropriate if the source is written such as "INV-CUST-XXX", "INV-CUST-YYY", and so on. The sample in this book assume that ALL sales invoices are kept in ONE file.

However, some companies generate more than one internal copies for sales invoice. They keep one copy in a master file and another copy in the respective customer file. If this is the case, you can use either way as source.

Why we want to identify sources ?

Apparently, source can be said best as a group of document that get filed together. Proper identification of source will help you easily refer back and search to your physical (paper) document.