Timesheet and Billing Tracker spreadsheet (Google Sheets) for freelancers, sole traders, agencies, project managers and teams

Simple process to set-up accurate, consistent and comprehensive log to record time spent and calculate the value of your work. Makes invoicing calculations simple and fast.

No frills design. Simple, clean layout. My emphasis is always on sound structure, ease of use and labour saving functions.

Add your rates, log your time and costs, allocate to projects and clients. I developed this tool for my own use as a freelancer. I think it can be a labour saver for anyone in design, studio management, web, digital or many other freelance or project managements roles

-Easy to create structure - break your work down into time, expenses, products or whatever matches your business

-Set up rates for hours, days, however you charge for your work and that of any collaborators. Examples of categories and rates shown in the visuals can be replaced with your own

-Create a database of regular tasks and other cost items.

-Add a list of current clients and projects.

-Log work in the Spreadsheet by quickly adding items you created in the database. Unit costs and other values will pull through automatically.

-Fast and consistent data entry. Timesheet entries are mostly from pull-down menus created automatically from the earlier stages.

-See the total value of the work add up with every new entry, and be presented according to the relevant project, client and category of work.

-User Notes are provided within the spreadsheet, to help you get up and running quickly

No skills with formulae are required. Calculations are built into the spreadsheet and are made automatically.

If you have purchased this I hope you will feel able to leave a positive review, and help me reach more people. If you have constructive feedback please feel free to share so I can roll user ideas into future updates and new releases.

Made in the UK in 2023, using Google Sheets. This is the Google Sheets version of my Excel spreadsheet of the same name. The functionality is almost identical. Small adaptations have been required as some Excel functions do not have an equivalent in Sheets. You will need a Google account to use this spreadsheet.

---

Boring stuff

Terms of use

I am here for your questions but I cannot provide in-depth tuition as after-sales support. Google Sheets contains an in-depth Help facility. I am not able not provide refunds if you are unable to use Sheets to the required standard. I assume basic Google Sheets and Google Drive / Workplace spreadsheet skills on the part of the purchaser / user. You should be able to input figures and text into empty cells, edit content of cells and choose items from pull-down lists as required. You will need to navigate within and between separate pages and to be able to manage your own versions of the worksheets as you progress with their use.

The template is supplied with some protection in place to lock formulae and other functions within the spreadsheet. This protects against malfunction and piracy. You will not require a password in order to carry out intended use of the product. If a formula or other feature appears not to work correctly you should revert to the downloaded template in the first instance. If the issue is present in the original version please contact me if you still feel anything is not functioning correctly. I am happy to address any bugs you may identify and re-supply an updated version.

These templates are strictly for personal use only. They are not to be modified, reproduced or re-sold in their original or modified form.

---

Technical spec / Compatibility

The spreadsheet is supplied as a Google Sheets template. Digital product. No physical material will be supplied.

I cannot guarantee full functionality in Excel, Apple Numbers or any other spreadsheet package. I cannot offer advice or refunds based on problems using the sheet in packages other than Sheets.

I cannot guarantee full functionality when using the template saved for use with older versions. Using an older version of the software inevitably carries some risk to the user.