Six Colors
Six Colors

by Jason Snell & Dan Moren

This Week's Sponsor

Clay - A beautiful relationship manager for macOS and iOS, built automatically from email, Contacts, calendar, iMessage, LinkedIn, and more. Try it free for 60 days.

By Dan Moren

Template for Numbers freelance accounting sheet

Warning: This story has not been updated in several years and may contain out-of-date information.

Update: Check out the updated version of this sheet for 2017, including expense tracking.

Who knew you folks were so interested in spreadsheets? After my post last week detailing my freelance accounting sheet, I was inundated with requests for the template. Far be it from me to deny you fine people, so here it is, in all its glory. (Click the image to download.)

Freelance Spreadsheet

I have, of course, removed all of my pertinent information from the file, but to give you a better idea of how things work, I’ve filled it in with a variety of placeholder information. All of which can, of course, be removed and filled with your own details.

You’re free to use this, tweak it to your tastes, and redistribute it, although it’d be great if you acknowledge the source. If you happen to make any changes and would like to share them, feel free to shoot me an email (or hit me up on Twitter) and let me know.


[Dan Moren is the East Coast Bureau Chief of Six Colors. You can find him on Twitter at @dmoren or reach him by email at The latest novel in his Galactic Cold War series of sci-fi space adventures, The Nova Incident, is available now.]

If you appreciate articles like this one, support us by becoming a Six Colors subscriber. Subscribers get access to an exclusive podcast, members-only stories, and a special community.

Search Six Colors