About this system and its suitability

34. This System And Its Suitability

Suitability Of This System

In reviewing the suitability of this system, here are the factors to consider:

Size Of Business

This file is suitable for small and medium-sized 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 for in a trading company, manufacturing, services etc.

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

How many rows will you probably use in a year? Here is a 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's transactions.

Who Will Be Able To Use This File?

Someone with basic book-keeping knowledge and good familiarity with Microsoft Excel.

253

What Is Lacking?

This system is not:

an integrated invoicing system with ledger.
an integrated fixed assets system with ledger.
an integrated investment system with ledger.
an integrated stock system with ledger.
an integrated payroll system with ledger.

The above can be handled through use of Excel-VBA programming.

What Is Good?

Portable (because of its small in size)
Network-enabled (Via Excel's built-in capability)
No need to buy a separate program.
Save cost in the long run.
Easy trouble-shooting.
Web-enabled (via Excel's built-in capability)
Potential for working from home.

Does This System Work In Other Spreadsheet Programs?

Other than Microsoft Excel, there are other spreadsheet programs such as Lotus123, OpenOffice, StarOffice, Microsoft Works, etc. The formulas and functions in this book have not been tested in those spreadsheets. There may be small variations on how the functions and formulas should be constructed, or difference in syntax. Most spreadsheets have functions similar to AutoFilter and PivotTable. You can check by opening Excel files using those spreadsheets and see whether the formulas are still intact and get the expected results.

254

Sample Disk

A sample disk is provided with this book. The disk contains data for you to try out the operations mentioned in this book and familiarise yourself with the system.

Contacting The Author

You can contact the author at ibh1@live.com