• What is Copywriting?
    • Why Become a Copywriter?
  • Blog
    • Most Popular
    • Growth & Development
    • Portfolio
    • Business Development
    • Book Recommendations
    • Looking for Work
    • Copy Tactics
    • Definitions
  • Podcast
  • Copywriting Course
    • Comprehensive Copywriting Academy
    • CCA Login
    • Written Testimonials
    • Video Testimonials
  • Store
  • About Us
    • About Us
    • About Nicki
    • Contact Us
  • Copywriter Jobs

Filthy Rich Writer

Write copy, make money, be happy!

Tips, Tools and Training for New and Aspiring Copywriters

  • What does “Filthy Rich” mean? It means having a job you love, being good at what you do…and making great money doing it!

Copywriting Q&A: The Best (and Cheapest) Way to Track Freelance Income

By Nicki Krawczyk 4 Comments

best way to track freelance income
Once you get money coming in from several clients, things can get a little chaotic—to say the least. With multiple clients, multiple projects, and multiple invoices in various states of payment, how do you keep track your freelance income and keep it all straight? Read on…

Today’s question is from Trevor D., who asks, “I keep seeing ads for invoice tracking software for freelancers. They make it sound pretty essential. (Good copy, I guess!) Is this something I’ll need?”

Good copy, indeed! I’ve seen some of these ads, myself. They do a great job of making you feel like, if you were a real freelance professional, you’d use this software.

That’s not the case, though. You don’t need this software to keep your invoices straight.

However, you do need a system.

Here’s what your system needs to track:

  • What projects you’re currently working on
  • What projects you’ve concluded and have invoiced for (bonus tip: the same day you get client approval, send them your invoice. Make this a habit, and you’ll save yourself a lot of headaches)
  • How much the invoice is for
  • The invoice number
  • When you sent it
  • When you received it
  • Whether or not you’ve set aside money for taxes

Wow, kind of a lot, right? What kind of crazy, high-tech system is going to let you track all of this?

Open yourself up an Excel document.

Really: an excel document is all you need to track your invoices effectively. (Well, with one caveat—more on that in a sec.

Across the top of your doc, create these column titles:

  • Client
  • Project (write a two- or three-word description)
  • The date you sent the invoice
  • The invoice number
  • The amount it was for
  • The date you receive the invoice
  • Whether or not you’ve set aside tax funds (y/n)

Using it is just a simple. As soon as you get a client, enter the client name and short project description in the sheet.

If you’ve agreed on a project price, you can put that in there, too—it will help keep the info handy.

This shows you your current, unbilled projects.

When you finish a project and bill for it, put in your invoice number and the date you sent it. This gives you an easy way to see your unpaid invoices.

When you receive a payment (and automatically deposit any checks you receive via your phone—you need to), record the date you receive it. This gives you a handy reference for how much income you’ve made.

And, of course, when you transfer funds to your for-taxes-only account, record that you’ve done so. This will help you remember to do it, as well as help you remember which payments you’ve planned for in your taxes.

And that’s it! Really, that’s all you need.

But time for that caveat: You have to actually use it. No tracking system, not this one and not some five-figure swanky tracking software, will work unless you actually use it.

Make it a habit to record your projects, bill as soon as you get approval, deposit your payment as soon as you get it, and transfer your tax savings as soon as the payment is deposited. And, of course, make it a habit to record all of this in your Excel invoice tracking sheet.

Your turn! Do you have any additional tips for tracking invoices? Or questions about this system? Let us know in the questions below!

Tweet
Share
Pin23
Share
23 Shares

Filed Under: Business Development

Interested in Copywriting? Get our Free Video Training!

Plus, get on the list for updates, freebies, and more :) 



About Nicki Krawczyk

Nicki is a copywriter, copy coach and the founder of Filthy Rich Writer. She's been writing copy for more than 15 years.

Comments

  1. Kate says

    May 15, 2017 at 8:50 am

    This is *everything.* I’ve been using a Word doc. (habit?) for too long and everything gets so disorganized. The Excel doc is so simple, but it’s been a complete game changer (and such a “duh,” pam-to-head moment). Thank you!

    Reply
    • Nicki Krawczyk says

      June 25, 2017 at 3:26 pm

      Hi Kate!

      I’m glad you found it helpful – tracking doesn’t need to be nearly as hard as we often try to make it. 🙂

      Thanks for commenting!
      Nicki

      Reply
  2. Keshi says

    September 2, 2019 at 2:48 am

    Glad I found this. I currently use project panorama for WordPress, but that doesn’t organize everything, only the projects. Thanks

    Reply
    • Nicki Krawczyk says

      September 4, 2019 at 10:47 am

      Hi Keshi,

      I’m glad you found this helpful! Thanks for commenting. 🙂

      Nicki

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Please follow & like us :)

Facebook
Facebook
fb-share-icon
Twitter
Visit Us
Follow Me
Tweet
Pinterest
Pinterest
fb-share-icon
Instagram

Search Posts By Topic

“

Break Into Copywriting

Sign up to get our FREE video training, special resources, and more!



“skills

Portfolio Tips

Why listing out all of your possible copywriting services may not be a great idea

Do You Need to List Your Copywriting Services on Your Portfolio Site?

Should I List Prices on My Copywriting Website?

4 Things Most Copywriters Get Wrong on Their Portfolio Websites

4 Things Most Copywriters Get Wrong on Their Portfolio Websites

Comprehensive Copywriting Academy

Comprehensive Copywriting Academy from Filthy Rich Writer

Join the copywriting training program that's helping people just like you build successful copywriting careers!

Recent Articles

  • Choosing a Business Structure as a Copywriter
  • How to Set Up Your Schedule When Working from Home
  • How to Make 2021 The Best Year Yet
  • A Great Reason to Reach Out to Past Copywriting Clients
  • Do You Need to List Your Copywriting Services on Your Portfolio Site?

Copyright 2021 Filthy Rich Writer | About Us | Terms of Service | Privacy Policy