$45.00 USD
I am excited to see how many hours I am actually working a week for contracts/jobs that are outside of my standard Upwork environment.
This version allows the user to input all their details about every time they do work directly on the database and from that there are all kinds of time-based and bucket based summaries to show you how much you have 'in progress', 'billed', 'paid', etc...for each client that you are doing work for.
Personally, I will be using it to track things that are in progress and billed as well as see what kind of hours I am actually putting in per week. Also, this will make sending invoices a bit easier, especially on the math of counting amount of hours from start to finish and then auto calculate amount due based on a rate. You can create blocks of detailed work log history and screen shot it or create a PDF of it to send along with your invoice.
There is a detail summary that automatically knows what day/week it is via native Excel functions and goes back two weeks prior. You can then choose a specific client/job status or all for both and hit a macro button to see those specific job details on a summary dashboard for the current week and past two weeks.
The data entry on this is simple. You are just entering the date you are doing the work, status, client, job type/detail, and the start/end time. I did the start / end time with a 'now' formula so when you actually go to enter a time, it will have auto populated the current time when you entered today's date and then you just paste values only into that cell to get the times. This was the simplest way I could think of it record start/end times of work within Excel.
I have since added some pie and bar charts on the detail summary and client summary tabs.
This version allows the user to input all their details about every time they do work directly on the database and from that there are all kinds of time-based and bucket based summaries to show you how much you have 'in progress', 'billed', 'paid', etc...for each client that you are doing work for.
Personally, I will be using it to track things that are in progress and billed as well as see what kind of hours I am actually putting in per week. Also, this will make sending invoices a bit easier, especially on the math of counting amount of hours from start to finish and then auto calculate amount due based on a rate. You can create blocks of detailed work log history and screen shot it or create a PDF of it to send along with your invoice.
There is a detail summary that automatically knows what day/week it is via native Excel functions and goes back two weeks prior. You can then choose a specific client/job status or all for both and hit a macro button to see those specific job details on a summary dashboard for the current week and past two weeks.
The data entry on this is simple. You are just entering the date you are doing the work, status, client, job type/detail, and the start/end time. I did the start / end time with a 'now' formula so when you actually go to enter a time, it will have auto populated the current time when you entered today's date and then you just paste values only into that cell to get the times. This was the simplest way I could think of it record start/end times of work within Excel.
I have since added some pie and bar charts on the detail summary and client summary tabs.
More HR Management Spreadsheets:
- Payroll KPI
- HR Tool - Hiring/Firing
- Employee Data Tracker for HR
- Employee Training Tracker
- Employee Time Sheets
- Sales Team Hiring Plan + R&D / Customer Service
- Gantt Scheduling
- Employee Scheduling
- Project Management
- Layoff Financial Impact Analysis
- General Contractor KPI Dashboard
- KPI Dashboard with A Scoring System
- Payroll Calculator and Tracker - Budget vs. Actual
- Sales Person Commissions: Incentivization Structures
- To-Do List Tracker
- Consultant Tracker and Rankings
