Tracking your jobs
This lesson is aimed to small design departments and freelance graphic designers. If you work for an advertising agency you should already have some sort of tracking. You don’t? What are you waiting for.
In this lesson, where I explain the benefits of tracking, is a free to download spreadsheet included to get you started in minutes.
Why you should track your jobs
The first thing that will come to mind are the invoices – you need to know how much to charge your clients and you need a record for taxes and all the accounting. But if you do your tracking with just the money in your mind you may miss some important points. Setting the tracking up the right way will help you (just to name a few):
Don’t do too much
If you are not used to track you jobs you may think that it will consume to much time. But you don’t need to start with a full blown project management suite. In fact it is one of the biggest errors you can do, to start with a too complex system. As a graphic designer you didn’t start with a corporate design for an international firm, you started with small projects. You need to begin with only a few key values. To update this values does not impact your performance as they will take no more than 5 minutes a day.
An easy Spreadsheet to start
To give you a Headstart I’ve made a small spreadsheet. It contains the most basic information you need in my opinion. One covers some general information about your costs (I will get into details about this part next week) and one simple table. Here the contents of the columns:
[cta_button link="http://www.frankie.bz/v3/wp-content/uploads/work_tracking.zip"]Download the free project tracking example spreadsheet[/cta_button]
You will see that even with this basic spreadsheet you will be able to speed up your work and get some interesting data. In the next lesson I will show you what type of insights over your work you can get by reading the data you collected.