Find Jobs
Hire Freelancers

Create contractor calendar and payments database -- 2

£20-250 GBP

Tamamlandı
İlan edilme: yaklaşık 9 yıl önce

£20-250 GBP

Teslimde ödenir
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.
Proje No: 7576789

Proje hakkında

6 teklif
Uzaktan proje
Son aktiviteden bu yana geçen zaman 9 yıl önce

Biraz para mı kazanmak istiyorsunuz?

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin
Çalışmanız için ödeme alın
Teklifinizin ana hatlarını belirleyin
Kaydolmak ve işlere teklif vermek ücretsizdir
Seçilen:
Kullanıcı Avatarı
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 3 gün içinde
4,9 (150 değerlendirme)
6,8
6,8
6 freelancer bu proje için ortalama £229 GBP teklif veriyor
Kullanıcı Avatarı
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 23 gün içinde
4,7 (57 değerlendirme)
5,7
5,7
Kullanıcı Avatarı
Hi, I am perfect and will enjoy doing your project. Please reply if you consider. Thank you, Sam .
£150 GBP 5 gün içinde
5,0 (7 değerlendirme)
4,6
4,6
Kullanıcı Avatarı
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 3 gün içinde
0,0 (0 değerlendirme)
0,0
0,0

Müşteri hakkında

   UNITED KINGDOM bayrağı
Hitchin, United Kingdom
5,0
2
Ödeme yöntemi onaylandı
Mar 3, 2015 tarihinden bu yana üye

Müşteri Doğrulaması

Teşekkürler! Ücretsiz kredinizi talep etmeniz için size bir bağlantı gönderdik.
E-postanız gönderilirken bir şeyler yanlış gitti. Lütfen tekrar deneyin.
Kayıtlı Kullanıcı İlan Edlien Toplam İş
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ön izleme yükleniyor
Coğrafik konum için izin verildi.
Giriş oturumunuzun süresi doldu ve çıkış yaptınız. Lütfen tekrar giriş yapın.