Friday, July 24, 2009

This system and its suitability

THIS SYSTEM AND ITS SUITABILITY

Factors to consider : Size of business.

This file is suitable for small and medium size businesses. As long as the number of rows to be used does not exceed 65,536 in a year, you can use it. The type of industry is also not important – it can be used in trading company, manufacturing, services etc.

Will you reach 65,536 rows in a year : Very unlikely.

How many rows will you use in a year : Estimation using Simple calculation :

500 sales invoice per month X 12 months = 6,000 rows 500 suppliers invoice per month X 12 months = 6,000 rows 500 receipts + payments per month X 12 months = 6,000 rows 50 petty cash receipts + payments per month X 12 months = 600 rows Opening balances individual customer accounts = 200 rows Opening balances individual suppliers accounts = 200 rows Opening balances individual fixed assets categories = 10 rows Opening balances individual other accounts = 100 rows Salary journals : 20 items X 12 months = 240 rows Other journals items : 20 items X 12 months = 240 rows Contingency rows = 10,000 rows TOTAL = 29,590 rows.

Most likely, one file will be more than enough to accommodate one year transactions.



No comments:

Post a Comment