Have any questions?
Drop me a message at templatesbygabi@gmail.com and I’ll be happy to help you with any questions that you have about the time tracker 💓
Services
The Services database stores information about the different services that you offer, including their hourly rates. This database is linked to the Projects database to automatically calculate potential earnings based on time tracked.
- Hourly rate - The cost per hour for the service provided. This property is used to calculate potential earnings based on the hours logged in the timesheet.
Projects
The Projects database tracks all the projects you're working on.
- Name: Name of the project
- Service: A relation to the Services database that identifies which service is associated with the project. This helps in applying the correct hourly rate.
- Status: A status property that tracks the current status of the project. Options include:
- Not started
- In progress
- Done
- Time Estimate: A number property indicating the estimated number of hours expected to complete the project. This helps in planning and setting expectations.
- Total Earnings: A formula that calculates the potential earnings from this project based on logged entries in the Timesheet database
- Hours Consumed: A progress bar that tracks the total number of hours worked on the project. It is used to visualize progress against the time estimate.
- Divider: A divider property used for visual separation within the Gallery view
- Cover: A file property that allows you to add a cover image to the project
Timesheet
The Timesheet database logs all time entries for tasks performed under various projects. It tracks the start and end times for each task and links back to the associated project to calculate total hours and potential earnings.
- Name: The name of the specific task being worked on
- Project: A relation property that links the task to a specific project in the Projects database. This ensures the task is tracked under the correct project and allows for rollups and calculations based on project data
- Start: A button that sets the current time as the Start time when clicked. It automates logging the beginning of a task
- End: A button that sets the current time as the End time when clicked. It automates logging the completion of a task
- Start Time: A date property indicating when the task started. This is set by the Start button
- End Time: A date property indicating when the task ended. This is set by the End butto
- Hours: A formula property that calculates the duration of the task in hours
- Hourly Rate: A formula property that pulls the hourly rate from the associated Service in the Projects database. This ensures the correct rate is applied for earnings calculations
- Earnings: A formula property that calculates the potential earnings for the task based on the hours worked and the hourly rate
Reports
- Weekly timesheet: This board view shows the time logged on tasks each week, helping you track weekly productivity and identify work patterns at a glance.
- Earnings by project: This board view groups tasks by project, displaying total earnings to help you assess project profitability and prioritise your work.
- Project time utilisation: This table view compares estimated and actual hours for each project, highlighting time utilisation to improve planning and resource allocation.