Develop HRM and Payroll Database

In Progress Posted Jan 14, 2016 Paid on delivery
In Progress Paid on delivery

Traditional Arts and Ethnology Centre (TAEC) employs up to 20 staff members (full and part-time) in Laos. We would like a Microsoft Access database for HR management to record leave (absences, sick, vacation, and other), salary advances and loans, insurance payments, and lunch payments, and to calculate monthly salary/wages and payments to staff. We currently use one excel spreadsheet (Staff working hours [login to view URL]) for recording time worked and leave taken. We use a different excel spreadsheet to calculate and record the payments made to each employee. Most staff are paid in the local currency (LAK), but a few staff are paid in USD.

We want to improve our system for recording and accessing HR information. The file (HR [login to view URL]) shows the fields we want to record by date. We envision an employee record form with basic information including name, start date, end date, regular working hours, starting salary or wage including currency, increase of salary or wage with date of increase, annual sick days, annual vacation days, and a lunch payment (yes/no) and insurance (yes/no).

On a daily basis, time worked is recorded in days for each employee. Additional time worked may include special hours (added to vacation time), overtime hours (paid with monthly salary), and nights worked at the boutique location(paid with monthly salary). The reason for special hours or overtime hours should be noted, as well as the dates worked at the boutique location.

When an employee takes leave (sick, vacation, absences, or other leave), this will be recorded with the type of absence, date, and reason. Sick and vacation days should be subtracted from the annual allotment.

Lunch payments are also made for certain employees for each day worked and are paid with monthly salary. Some employees have an insurance payment deducted from their monthly salary.

Employees may take a salary advance, which is then deducted from their next monthly salary. Employees may take out a larger loan, which must be repaid within 6 months. Advances and loans may be made in LAK or USD. Loans have terms (amount to be repaid each month and the period of time to repay) and include a reason for the loan. Repayment of the loan is made through a monthly salary deduction.

On a monthly basis we envision running a report that will calculate salary/wages with any additional payments and debits for all employees. Individual reports by employee should also be possible.

Database Development Database Programming Microsoft Access Payroll Project Management

Project ID: #9312264

About the project

32 proposals Remote project Active Jan 22, 2016

Awarded to:

y2klewis

Hi, my name is Daniel, i am an Access expert and vb programmer, my proposal: - Create this Application, where you will be able to create/edit/invalidate any worker (TABLE WORKER), also in this table you will be able t More

$270 USD in 5 days
(13 Reviews)
3.9

32 freelancers are bidding on average $312 for this job

fabest

Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am ser More

$547 USD in 7 days
(79 Reviews)
7.3
jawadaman

Hi I am interested in this project.I am an experienced MS Access applications developer. i can do this job for you. If interested in hiring me then please let me know so that we can finalize the scope, timelines an More

$555 USD in 3 days
(84 Reviews)
5.7
zu02

Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Acc More

$555 USD in 3 days
(45 Reviews)
6.1
SergeyKyiv

Greetings! I've studied the case you described, so I'm sure I can perform it. Currently I'm free for new job, so I could start immediately. Please don't hesitate to contact me, Regards, Sergey

$166 USD in 5 days
(8 Reviews)
4.6
crypthne

I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administ More

$111 USD in 2 days
(29 Reviews)
4.4
Friends4it

I already have a complete and mature HRM & Management System, which have all basic and special modules, to complete your requirements. I can show you demo as per your request.

$500 USD in 4 days
(4 Reviews)
4.1
SCKRamana

I am ready to work on your task and design as per the requrement and available 24/7 online for status update . More

$155 USD in 3 days
(5 Reviews)
3.4
kamrananjum1

Hi, I can help you with this one. I have more than 10 years of professional experience in Microsoft Packages. Please share some more details for quality work. Please also consider this bid as provisional one as i More

$526 USD in 10 days
(3 Reviews)
3.3
sunsoftpro

Hi Employer, I have read your description and been interested in your project. Please give me more details of your project. I'm ready to discuss and start to work on it now. ==================================== Pl More

$631 USD in 20 days
(2 Reviews)
2.8
SkyTechnovation

Hello There, This is Akash Fasara from Sky Technovation (IT Development & Cyber Security Company). From last 5 years we are working on Software & Website development. We have developed too many Software & websites in More

$368 USD in 13 days
(1 Review)
2.6
tandonshailendra

Understand you need Access 2010/ 2013 based offline solution. About Myself Good Day!. Let me introduce myself for building your confidence in me. Worked at Sr. position with experience of marketing, Service, P More

$250 USD in 10 days
(5 Reviews)
2.5
khannanav

We have a team of expert DB Architects and MS SQL developers with more than 10 years of rich industry experience & would be more than happy to work on the project. We have expertise in designing DB schema from scrat More

$144 USD in 3 days
(1 Review)
2.3
AVRocker1

Hello Client I have check your post regarding HRMS and Payroll, I have similar system if you want to see the demo let me know.. I have expertise on PHP, Yii, Zend, Codeigniter Cakephp, Laravel, Wordpress, Openca More

$30 USD in 3 days
(0 Reviews)
0.0
codeblockinfo

I have 8+ years experience in Java Development with on hand experience in Collections, Data structures, OOP, Generics,Multithreading,File Handing,Database handling using JDBC, Swing framework etc. Excellent debugging s More

$250 USD in 10 days
(0 Reviews)
1.9
NoheirAdel4

Hello, I can provide you with accurate data base for the attendance and overtime and the time of attending and leaving of employees. I am working as a payroll specialist and I can manage this task.

$133 USD in 4 days
(0 Reviews)
0.0
sudiptachoudhury

Hi, I have 10+ years of experience in Access, VB, VB.net, SQL server development. I am interested in your project.

$222 USD in 10 days
(0 Reviews)
0.0
kinboboye

A proposal has not yet been provided

$244 USD in 3 days
(0 Reviews)
0.0
vagmendoza

i have 3 years of experience in creating huge database for banks and airlines. I'm also a developer who can help you and give some ideas if needed.

$500 USD in 3 days
(0 Reviews)
0.0
tophamandrea

Hi There, I can use access to develop the HR tracking system as you described. However, I think there might be better solutions for your needs through free or open source HR management software. Please don't hesitate More

$222 USD in 5 days
(0 Reviews)
0.0
rku56978ac6779ba

A proposal has not yet been provided

$155 USD in 3 days
(0 Reviews)
0.0