Finances
When a new maintenance project comes in, set up a Google Sheet to track timesheets for weekly breakdowns. Note that design hours are billed at half the tracked hours, indicated by the DESIGN tag.
Step by step
- Create Google Sheet: Set up a new Google Sheet specifically for the new maintenance project.
- Export Timesheets: Export the relevant timesheets into the Google Sheet for weekly tracking.
- Tag Design Tasks: Mark tasks involving design with the DESIGN tag.
- Adjust Design Hours: Calculate design hours at half the tracked time for billing purposes.
Things to Keep in Mind
- Use a consistent naming convention for the Google Sheet to keep track of different projects.
- Verify that all design tasks are appropriately tagged with DESIGN.
- Ensure the weekly breakdowns are accurate and clearly indicate the adjusted design hours.