1.1 BACKGROUND OF STUDY
Prompt payment of staff salaries by management of an organization boosts the morale of staffs and enhances productivity. Manual preparation of staff’s salaries is often associated with lots of problems, which often time disrupt the morale of workers. The problems ranges from arithmetic error in computation, delay in payment, underpayment or overpayment and so on. In this project work, automated system shall be developed which shall eliminate all the problems associated with the manual process. The most common method of keeping the financial records of a company was manually. A bookkeeper kept the journals, the accounts receivable, the accounts payable, payroll and the ledgers in his best possible penmanship. In later years, an accounting machine, which was capable of performing normal bookkeeping functions, such as tabulating in vertical columns, performing arithmetic functions, and typing horizontal rows was used. The billing machine, which was designed to typewrite names, addresses, and descriptions, to multiply, to compute discounts, and to add net total, posting the requisite data to the proper accounts, and so to prepare a customer’s bill automatically once the operator has entered the necessary information, was used. Early accounting machines were marvels of mechanical complexity, often combining a typewriter and various kinds of calculator elements. The refinements in speed and capacity made possible by advances in electronics and operating complexity of these machines. Many of the newer “generations” of accounting machines are operated by a computer to which they are permanently connected. Because of the minute by minute change in finances, accurate record keeping is critical. Computerizing a business’s general ledger, payroll, and other accounting tasks increases office efficiency. With the advent of computerization in accounting, Electronic spreadsheets were used to compute payroll and perform other accounting routines in organizations. Electronic spreadsheets allow you to do anything that you would normally do with a calculator, pencil and columnar scratch pad. Spreadsheets were primarily designed for managers who in the process of planning must do “what if” calculations and due to their flexibility; electronic spreadsheets have found their way into businesses. It takes its name from the accountant’s spreadsheet—a sheet of paper with rules for rows and columns—on which such work was usually done. Spreadsheet programs are much faster, more accurate, and easier to use than traditional accounting techniques. An example of electronic spreadsheet is Microsoft Excel. Early programs such as VisiCalc provided 254 rows and 63 columns for entering data and formulas for calculations. VisiCalc was introduced by Robert Frankston, a young computer programmer, and Dan Bricklin, a Harvard Business School student who was looking for a way to use the power of a computer to simplify complex time-consuming financial analyses. VisiCalc proved so useful in such applications that it provided an entry for personal computers into the business world. In 1980, the Sorcim Corporation introduced SuperCalc, a similar spreadsheet program for personal computers using the CPM operating system. Some modern programs for computers with large memories provide thousands of rows and hundreds of columns. A new generation of computer software for business began with integrated spreadsheet programs, which can be used to prepare spreadsheets, create graphs, and manage data. In such programs, for example, it is easy to display spreadsheet data in the form of a graph or to transfer data from a data base to a spreadsheet. One of the first such programs was Lotus 1-2-3, an immediate success following its introduction in 1983. 1.2 STATEMENT OF RESEARCH PROBLEM
Preparation of payroll manually as earlier said is a cumbersome and boring task encountered by the account...