Find Jobs
Hire Freelancers

Create contractor calendar and payments database -- 2

£20-250 GBP

Selesai
Dibuat sekitar 9 tahun yang lalu

£20-250 GBP

Dibayar ketika dikirim
I need a database that houses a contractor database and payments. I need to be able to access this from muliple locations so cant be stand alone - but we do have a company cloud server in the form of Dropbox. Basci interface should involve a calendar, where I can flick through weeks that run Monday to Sunday. Down the left I need to be able to add staff that have worked that week. And then for each day of the week type in how much of the day they have worked. So 1 for full day, 0.5 for a half day and so on. I need to be able to add bonus's and penalties for each day and each person. So on Tuesday, I might give worker 1 a bonus of £15 on Thursday worker 3 might have a penalty of £15. Also need one field for each worker that week called 'Materials' which is a £ value I add. Fields required: Contractor information: First Name Lat Name Address (Address 1 2, Town, County, Postcode) Contact Number Email Address Bank Sort Code Bank Account Number NI Number UTR VAT Registered? (Yes/No) - default No Day Rate - how much they get paid for each completed day. £100 a day = so if calendar shows they worked half a day on Wednesday (0.5) they would get £50 before tax on that day. With the day rate in mind, there is a chance they might get a pay rise so we need this to be involved, but if change day rate from £100 to £150 we don't want it to change information for previous weeks! So if looking back at a record, it will show during week 1 rate was £100 a day, but on week 10 it was £150. Tax Rate: a % of the gross pay which we do not pay the contractor but pay ourselves to the tax office. Usuaully this is 20% but wheh someone new starts for first week or two it might be 30% so we need same as above to take that into consideration. And same for VAT. Weekly information required: (this is based off the calendar - how many days they have worked and any penalties/bonus given) -Total Days Worked (Monday: 1 Tuesday 1 Wednesday 1 Thursday 0.5 Friday 0 Saturday 0 Sunday 0 = 3.5) -Payment ammendments - will summarise total value of any bonus or penalties -Labour Total: This is total days worked +- payment ammendments -Materials Total: (See above) -Gross (is materials + Labour) -VAT - Only If VAT registered is Yes - It is Gross divided by 120 x 100 x 0.2. - Tax Deducted - Gross - VAT - Materials x by Tax Rate - Net Payment (i.e money owed to contractor for the week) = Gross - Tax Rate Payments: Sometimes the weeks payment may be made up of two payments. So if they were due £100 I might make 2 payments of £50 to them. I need to log what dates they are - but for the tax return, only the date the payment is completed counts. (see reports). I need to see if I make a payment how much is still owed. Reports: I need to generate from what days they have worked, based on their day rate - how much money they are due for that week. What they work week 1 Monday to Sunday they get paid Friday of week two - I need to be able to preferable have an option to link in with outlook as I email them a summary of what is paid to them, each Friday. I need to submit tax returns each month. So the tax month for payments operates on the basis of the start date is the 6th of each month, the last day the 5th of the next. I need the individual totals for each worker during that period for 3 things: Gross, Materials, Tax Deducted. A printable report would be nice. Key points are quality of layout and ease of use - this is aimed at being a time saving projeect for myself. I currently operate off of a spreadsheet which is an annoyance. I can send what I currently use a spreadsheet, to show the calculations if it doesn't make sense here.
ID Proyek: 7576789

Tentang proyek

6 proposal
Proyek remot
Aktif 9 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
Diberikan kepada:
Avatar Pengguna
Hi sir, My name is Leonardo Medina, and I'm from Brazil. I have lots of experience in PHP. I'm an experienced Web Developer working since 1996 in this field, with: * 7+ years experience in PHP, ASP, HTML, CSS and Javascript (JQuery & Ajax) * 2 years in Java and JSP * 8 years in Delphi * 3 years of experience in programming stored procedures, triggers, creating tables and relationships for SQL Server, and 10 years in MySQL; * 2 year in Solr/Lucene (for full-text searches), Sphinx, Redis and CouchDB. * 1 Year of experience in CakePHP, CodeIgniter and Wordpress. These are some samples of my works: [login to view URL] User: admin Password: 12345 Voting System Frontend: [login to view URL] Admin Backend: [login to view URL] Usr: admin Pwd: 123456 Bitcoin Exchange Website [login to view URL] User: admin Password: 12345 Admin Franchisor Panel: [login to view URL] username: admin pwd: 12345 Franchisee Orders Panel: [login to view URL] username: medina pwd: 12345 Please drop me a line, so we can discuss this project in details and I can make a proper bid. Best Regards
£350 GBP dalam 3 hari
4,9 (150 ulasan)
6,8
6,8
6 freelancer menawar dengan rata-rata £229 GBP untuk pekerjaan ini
Avatar Pengguna
Hello, I have very good experience with VB, VBA and .Net programming and very proficient at MS Office application Automation, I have also completed several similar projects here on this site. For your task I can create a .NET web solution that would automate, the processes, the database I would recommend is SQL Server hosted online, this way you can access the database and application any time from anywhere. The Application would feature Calendar and Scheduler using clean UI that is simple and clear for quick data entry. Looking forward to working with you on this project Ola
£261 GBP dalam 23 hari
4,7 (57 ulasan)
5,7
5,7
Avatar Pengguna
Hi, I am perfect and will enjoy doing your project. Please reply if you consider. Thank you, Sam .
£150 GBP dalam 5 hari
5,0 (7 ulasan)
4,6
4,6
Avatar Pengguna
Sir/Mam, I am excellent in database. I can do it well. I will submit it just in time. I hope you will give the taks and verify me.
£150 GBP dalam 3 hari
0,0 (0 ulasan)
0,0
0,0

Tentang klien

Bendera UNITED KINGDOM
Hitchin, United Kingdom
5,0
2
Memverifikasi Metode pembayaran
Anggota sejak Mar 3, 2015

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.