Automatically generate an invoice when manually processing timesheets
- or -
Post a project like this3353
$$
- Posted:
- Proposals: 14
- Remote
- #677448
- Awarded
Very experienced Excel user (including VBA), data analyst, and report writer. Currently working in a full time position but available on evenings and weekends.
Llanelli
Microsoft Access Developer, Access Developer, Access Development, Access Database Developer, MS Access VBA Developer
Paris
6529922341681974114612186609323452478360503693515791515826665266
Description
Experience Level: Intermediate
General information for the business: We are a domiciliary care provider
Kind of development: New program from scratch
Description of every module: would like an invoice to be created automatically for individual clients when processing timesheets
I believe this can be done from excel using LOOKUP data
At present we invoicve manually from excel but would like it to become automated when inputting timesheet data
Description of requirements/functionality: At present we manually process/input timesheet data.
A timesheet consists of:
1) Staff Name
2) Client/site visited
3) Date of visit
4) Start Time
5) Finish Time
6) Total Hours
This helps enable us to work out how much to pay the staff member. (ie total number of hours worked x hourly pay rate)
The area we need help with is that after processing this timesheet, we have to re-input all the data again into an invoice template (hence duplicating the work load)
Im after a system so when we initially process the timesheets for all staff, a program that can pull data from all the inputted timesheets automatically into an invoice.
The invoices on average consist of:
1) Staff Name who attended site (can be multiple staff)
2) Date of visit
3) Start Time
4) Finish time
5) Total Hours
6) Charge Rate
7) Sub Total
8) Total
CMS and Admin requirements: Ideally i know this can be done via Excel.....we currently use excel to process timesheets manually and also again to form invoives
Specific technologies required: Microsoft Excel
OS requirements: Windows
Extra notes: i have attached a basic invoice that we use. As you can see its quite simple but repetitive because we are having to manually input the Staff name, date, start time, finish time etc
If needed please do let me know and i can send you a sample of the basic timesheets that we input manually also
Kind of development: New program from scratch
Description of every module: would like an invoice to be created automatically for individual clients when processing timesheets
I believe this can be done from excel using LOOKUP data
At present we invoicve manually from excel but would like it to become automated when inputting timesheet data
Description of requirements/functionality: At present we manually process/input timesheet data.
A timesheet consists of:
1) Staff Name
2) Client/site visited
3) Date of visit
4) Start Time
5) Finish Time
6) Total Hours
This helps enable us to work out how much to pay the staff member. (ie total number of hours worked x hourly pay rate)
The area we need help with is that after processing this timesheet, we have to re-input all the data again into an invoice template (hence duplicating the work load)
Im after a system so when we initially process the timesheets for all staff, a program that can pull data from all the inputted timesheets automatically into an invoice.
The invoices on average consist of:
1) Staff Name who attended site (can be multiple staff)
2) Date of visit
3) Start Time
4) Finish time
5) Total Hours
6) Charge Rate
7) Sub Total
8) Total
CMS and Admin requirements: Ideally i know this can be done via Excel.....we currently use excel to process timesheets manually and also again to form invoives
Specific technologies required: Microsoft Excel
OS requirements: Windows
Extra notes: i have attached a basic invoice that we use. As you can see its quite simple but repetitive because we are having to manually input the Staff name, date, start time, finish time etc
If needed please do let me know and i can send you a sample of the basic timesheets that we input manually also
Bluewood H.
0% (0)Projects Completed
1
Freelancers worked with
1
Projects awarded
0%
Last project
23 Mar 2015
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies