Track Your Assignments, Invoices and Earnings with This Spreadsheet

When people think about illustrators, they imagine us drawing and doing creative things all day. But the reality is very different.

Like any other business people, we spend lots of hours dealing with very boring but important tasks like emails, accounting, contracts, invoices, quotes, etc.

The accounting is especially important, since there is money involved, and we need to keep our business’ paperwork in order. But sometimes we feel overwhelmed with all those things.

When I became self-employed, I created a very basic spreadsheet where I tracked all the assignments. This spreadsheet has evolved and improved over the years, and now I have a powerful tool to track all the work I do.

Today I’m sharing the spreadsheet with you. You will be able to easily track all your assignments, invoices and earnings.

Track Your Assignments, Invoices and Earnings with This Spreadsheet

What it is useful for:

What it includes:

• Client
• Assignment date
• Art director/contact person
• Budget
• Agent Fee (optional)
• % of tax
• Net earnings
• Invoice number
• Invoice date
• Payment date
• Total net earnings per month

Use the spreadsheet:

You can create a copy of my Google spreadsheet and use if for yourself.

Just follow the link and go to File > Create a copy.

Create a copy of the Spreadsheet

How it works:

I adapted my version of the spreadsheet to make it extremely easy to use.

The spreadsheet is automated, which means that you don’t need to write any formulas by yourself. I added three fictional assignments to show you what the spreadsheet looks like.

  1. Add a new assignment
    To add a new assignment, type the name of the client, what you were commissioned for, the date of the first contact and the name of the art director.
  2. Add the budget, % agent fee (optional) and % tax
    Add the budget, the % of your agent fee (if you have one) and the % of taxes. Your net earnings will be calculated automatically.
  3. Add the invoice date, number
    Add the invoice number and the invoice date.
  4. Track when the client pays
    When a client pays, add the date and change the whole row’s background color to green. This is very useful to see quickly who hasn’t paid.
  5. Canceled and on hold projects
    Change the background colors of the canceled and on hold projects to track them as well.
  6. Extra: track how much money you are earning per month
    This is the only step that requires modifying a formula to make it work. When a new month comes, just copy and paste the month row under your last assignment. Then you need to double click on the amount cell in the N column and modify the formula to adjust to the number of assignments. Change the cell numbers in the formula to get the first and the last assignments of the month.
Spreadsheet to track Assingments, Invoice and Earning - Keep track of your earnings


The spreadsheet is very simple and easy to use.

I’ve removed some advanced functionalities to avoid complexity and the need of writing formulas. But if you learn a bit about how Google Spreadsheets works you can extend the functionalities.

You can get some useful extras like converting the money to your currency, track your annual earnings, do some graphs to visualize how your business is doing, etc.

The possibilities are endless.