Database for office expenditure, attendance record, and salary record
$30-250 USD
Закрито
Опублікований over 11 years ago
$30-250 USD
Оплачується при отриманні
We need a database
For each employee there is user ID with the code in the database to login
Database should be accessible through internet explorer intranet
Process
1- When someone request money, he should send a request to the payer in the database
2- The payer pays him physically; the requester goes to the database and approves the receipt of payment (user will have one secret code. When he receives the money he will confirm it by entering the code in the database. In case he loose it or it’s leaked, the liability goes to the user)
3- A balance sheet within the database opens for this payment, where the receiver adds all his expenditures for the money at the end of each day until zero amount remains with him
4- During the clearance, the payer/the finance person will check all the expenses one by one and approves each. After the approval, the receiver will be free of liability for the amount he has received.
5- Once the balance is cleared, no one has access to edit/delete the balance sheet.. only read access
6- If the receiver has to pay some amount of money to another user, within the balance sheet he will have the access to transfer amount. The second receiver will approve the amount and in the remarks section the confirmation will be added
The user in the database can access:
Summary of payment received/sent each month/year
Detailed Record of the each balance sheets of each month/year
Amount he/she owes
Salary section
Attendance sheet/ details of attending
The operator and the payer will have access to:
Change the pin code of the users
View summary of expenses for all employees (Read only)
Salary section
Attendance sheet/ details of attending
Stock/inventory record system
Each items is recorded in the database
User will make a request for using the item
The payment and expense tracking part is clear but I see no relation with attendance and salary - there are no details pertaining to it. Also the proposed budget is not feasible for the entire scope. So I suggest you divide the project into smaller phases and let us concentrate on only the payment and expense tracking part. If you agree, then lets discuss further.
Hi,
I am database expert with more than 5 years of experience in this field.
I have read your requirements. I can guarantee of quality. I know the mentioned process too.
Rgds,
Shafiq
Dear Employer,
I am India based software developer working on browser based customized application development.
I have gone through the requirements and feel comfortable with this project.
Looking forward to hear from your side.
Regards,