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