WorkflowSoftware

We are a small accounting firm. Want to develop a small software to track workflow with following structure: 1. Should run on our in-house servers on WAMP or any other light weight software 2. Ideally, the database should be working on google spreadsheet The following tentative information needs to be input by various team members in the workflow software: 1) name of accounting job received (job number, name of the job, name of the client, date received, type of word such as accounting, audit, tax, bookkeeping, value of the job, GST on the job, etc) 2) the jobs created at step 1 should be able to add additional info such as, name of the team member assigned to work, the reviewer of the job, date of queries sent to the client, date of response received from the client, date of job completion, date of issue of audit report (for audit jobs), etc. 3) Ability to calculate incentives for the team members and the reviewers based on number of jobs they have finished x fixed rate. The software should give flexibility of changing the rate of incentives in future. 4) In case of jobs received for audit work, list of documents pending from the client even after completion of the job, example- signed documents, permanent file documents. And ability to enter the date when these pending documents were received. 5) Reporting system should have ability to fetch reports, such as: a) list of all jobs received during a selected period b) value of all jobs received during a period in total, and category wise (audit, accounting, tax work, etc.) c) list of pending jobs in total, or for a particular team member or for a particular client d) list of pending documents for the completed audit jobs e) list of pending jobs due to awaiting of response to queries/requests for additional information. Some more requirements may come while developing the project. Also, some requirements may arise in future as the business progresses.