Concluído

Custom online database for expenses and time tracking.

Custom online database for expenses and time tracking for a very small company.

We want to have a database where time and expenses are entered by employees and the administrator can create reports and extract data.

The source code must be delivered, as we want to ensure no connection to a third-party server is attempted in order to keep the privacy of the data.

The user interface must be a webpage and the database to be hosted on our server.

The employee logs in using a username and password.

In the time logging page, the employee enters tasks that contains : date ; short text description ; internal project number (string) ; client project number (string) ; type of work (field / office) ; amount of time worked (in hours if office, in days if field) ; amount of food allowance claimed ($) ; state/province in which the worked was performed. This page is a listing of all time logged so far and can be filtered for a specific date range, per project (internal or client), and/or per type of work or a combination of all.

In the expense page, the employees enters expenses that contains : date ; category (from a drop-down list) ; item (string) ; amount ; tip amount ; taxes (2 types) ; total paid ; project number. Then the employee uploads a picture of the expense limited to 1MB. The sum of amount + tip + taxes must be equal to total paid. This page is a listing of all expenses logged so far and can be filtered for a specific date range, per project, and/or per category or a combination of all.

The administrator logs in using a username and password.

The administrator can create a daily, weekly or monthly report of time spent on a project in the previous month, total time logged filtered by employee, project, etc. and save this to a .CSV format or Excel format, and in a PDF.

The administrator can create a CSV/EXCEL/PDF report listing all expenses, by filtering by employee name, date range, project number. For example, the administrator can create a PDF report of expenses of employee #1, assigned to project #2 during the "Current Month" or "Previous Month" or "From 2017xxxx to 2017yyyy" and in this PDF, on each page, one expense will be shown with all of its information and the uploaded picture.

The employees only have access to their own entries but are allowed to get a sum of amount, tip amount, taxes and total paid filtered by date period and project. The employees can edit their entries. In a similar way the employees can get a report of time logged and food allowance paid filtered by date period and project.

The administrator can get a sum of amount, tip amount, taxes and total paid filtered by employee, date period and project.

The administrator has access to an employee list and can add/remove users.

During the development of the project, the freelancer is to provide us a draft of the work in progress online so we can provide comments as it goes.

Habilidades: Programação de Banco de Dados, MySQL, PHP, Arquitetura de software, SQL

Veja mais: convert excel access database time tracking reporting, task time tracking access database, access time tracking database, employee timesheet software, best timesheet software, free online timesheets for employees, project time tracking software, timesheet software for small business, employee time tracking software free, free timesheet software, timesheet software open source, php, mysql, c# programming, bootstrap, software architecture, javascript, asp.net, d3.js, access database time tracking

Acerca do Empregador:
( 2 comentários ) Cantley, Canada

ID do Projeto: #15898651

Concedido a:

JinNg

I can build the time and expense tracking system that your described above. All your requirements are clearly defined. I will use MySQL, PHP for the backend and Javascript & Bootstrap for the frontend Relevant Skills Mais

$680 CAD em 12 dias
(34 Comentários)
6.6

33 freelancers estão ofertando em média $686 para esse trabalho

TenStar718

Hello, and thanks for the opportunity to bid on your project. https://www.freelancer.com/u/TenStar718.html Relevant Skills and Experience Web(PHP, MySql, HTML5, Java) and Mobile (Native and Hybrid). I am also an expe Mais

$526 CAD in 10 dias
(247 Comentários)
8.7
WebInfoSolutions

I think you will need 2 types of users. Admin and Employees. So, Will admin create the employees account or there will be an open registration? Relevant Skills and Experience Website Dev Proposed Milestones $1578 CAD Mais

$1578 CAD in 25 dias
(232 Comentários)
8.0
$555 CAD in 10 dias
(110 Comentários)
7.5
$555 CAD in 10 dias
(40 Comentários)
7.4
tranngocanh1702

I am able to create online database for expenses and time tracking. I can prepare the hosting to upload the current work so that you can provide feedback during development time. I am ready now. Relevant Skills and Ex Mais

$700 CAD in 12 dias
(150 Comentários)
7.6
malviyamanish

Hello sir, we are Professional & dedicated Team Having total 10 year experience in software development have read and understood your complete requirement i will provide you fully functional system Relevant Skills and Mais

$2500 CAD in 35 dias
(221 Comentários)
7.7
fullymagento

We are team of PHP and Mobile apps and developed numerous websites and applications as well as products like CRM,ERP,PMS,POS etc,kindly have a look below: Relevant Skills and Experience Ecommerce = http://livesoftwa Mais

$555 CAD in 10 dias
(84 Comentários)
7.5
nddungha

Hello. I am familiar with PHP and MySQL. I can build a secure site. Thanks Relevant Skills and Experience PHP, MySQL Proposed Milestones $1111 CAD - complete

$1111 CAD in 10 dias
(189 Comentários)
7.2
mike199

Hello, I do UX/UI design & development I’m based in Oxford. Your project seems interesting and I do have the required skills Relevant Skills and Experience Database Programming, MySQL, PHP, Software Architecture, SQL Mais

$555 CAD in 10 dias
(48 Comentários)
6.9
Ajcm623

Hi. I read you job description carefully and am making a proposal to this job with confidence that I cah do this job perfectly. I have full skill sets for this proect Stay tuned, I'm still working on this proposal.

$555 CAD in 10 dias
(74 Comentários)
6.6
Walkingdreams

Hello I have checked your complete project details, we can develop this time tracker for your company. Relevant Skills and Experience php Proposed Milestones $777 CAD - milestone

$777 CAD in 10 dias
(88 Comentários)
7.0
arityinfoway

I have more than 6+ years of experience in Laravel, Magento, Wordpress, joomla, Codeigniter, PHP, Angular js, node js, vuejs, jquery, mysql. I have developed more than 50 websites. Relevant Skills and Experience I hav Mais

$736 CAD in 10 dias
(133 Comentários)
6.9
anmoltech

Greetings, I've analysed your project very well, as per analysis you are looking for an expert developer to create custom application to track your expenses and time. Relevant Skills and Experience I'm expert in PHP, Mais

$755 CAD in 10 dias
(161 Comentários)
6.3
wsafreelancer

HI! Sir i m interested to Custom online database once contact me i will start work immediately and complete it as your requirement thank you i m waiting for your reply thanks Relevant Skills and Experience I have 7+ye Mais

$750 CAD in 10 dias
(130 Comentários)
6.2
schoudhary1553

Greeting, I have understood your Custom online database for expenses and time tracking. task and can do it with your 100% satisfaction. Please ping me for more discussion. Relevant Skills and Experience I have more Mais

$500 CAD in 7 dias
(72 Comentários)
6.6
periyannas

Sure. I am master in creating custom applications similar to the one you have asked. Willing to do this application for you. Looking forward to working with you. Thank you, Regards Relevant Skills and Experience web d Mais

$555 CAD in 15 dias
(56 Comentários)
5.6
$555 CAD in 10 dias
(44 Comentários)
5.7
quickapp100

we are a software development company from india in past 8 years me & my Team developed approx 950 projects for global market Relevant Skills and Experience we did lots of similar kind applications we would like to di Mais

$250 CAD in 6 dias
(16 Comentários)
5.1
zdesign77

Hello, how are you? I’m Mike, I’m a web developer & designer based in Boston. My previous experience match your requirements perfectly. Relevant Skills and Experience Database Programming, MySQL, PHP, Software Archite Mais

$555 CAD in 10 dias
(7 Comentários)
4.9
julienmoutier

Create a custom website to track times, expenses and other data. Relevant Skills and Experience Full stack developer, 7 years experience in PHP / mySQL development. I'm available right now and can get it done quickly Mais

$333 CAD in 2 dias
(16 Comentários)
4.5