Find Jobs
Hire Freelancers

Create contractor calendar and payments database -- 2

£20-250 GBP

完了済み
投稿日: 約9年前

£20-250 GBP

完了時にお支払い
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: 7576789

プロジェクトについて

6個の提案
リモートプロジェクト
アクティブ 9年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
アワード者:
ユーザーアバター
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日以内
4.9 (150 レビュー)
6.8
6.8
この仕事に6人のフリーランサーが、平均£229 GBPで入札しています
ユーザーアバター
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日以内
4.7 (57 レビュー)
5.7
5.7
ユーザーアバター
Hi, I am perfect and will enjoy doing your project. Please reply if you consider. Thank you, Sam .
£150 GBP 5日以内
5.0 (7 レビュー)
4.6
4.6
ユーザーアバター
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日以内
0.0 (0 レビュー)
0.0
0.0

クライアントについて

UNITED KINGDOMのフラグ
Hitchin, United Kingdom
5.0
2
お支払い方法確認済み
メンバー登録日:3月 3, 2015

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。