• CCA Student Sign In

Filthy Rich Writer

The #1 All-in-One Online Copywriting Program

The #1 All-in-One Online Copywriting Training Program

  • What Is Copywriting?
    • What Is Copywriting?
    • Why Copywriting is the BEST Career for Writers
  • Blog
    • Most Popular
    • Mindset & Professional Development
    • Portfolio
    • Business Development
    • Book Recommendations
    • Pitching
    • Copywriting Tips
    • Terms to Know
  • Podcast
    • Build Your Copywriting Business Podcast
    • Latest Episodes
    • Student Stories
  • Copywriting Training
    • Learn About the Comprehensive Copywriting Academy
    • CCA Next Level
  • CCA Reviews
    • CCA Reviews
    • Videos: CCA Student Stories
    • Videos: CCA Student Reviews
    • CCA Student Wins
  • About Us
    • About Us
    • About Nicki Krawczyk
    • Press
  • Copywriting Tools

The Easiest Way to Track Freelance Income [With Template]

By Nicki Krawczyk 11 Comments

Face rests on a stack of mail with one eyeball covered by a hand holding one five, one ten, and one twenty dollar US bills.


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?

If you’re seeing ads for invoice tracking software for freelancers, you may feel like this type of software is essential. 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.

Freelance Income Tracker Template

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 or Google Sheet.

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)

How to Use Your Freelance Invoice Tracker

Using it is just a simple as creating it. 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.

Make Tracking Income Part of Your Process

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 or Google Sheet invoice tracker.

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

Last Updated on July 4, 2023

Filed Under: Business Development Tagged With: finances, invoicing, money management

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 20 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
  3. A.A says

    March 21, 2021 at 3:24 am

    Hi Nicki!

    Is Excel hard to use for a beginner?

    I’ve never used Excel before and was never really good at statistics in college.

    I’ve always felt a little intimidated by spreadsheets for this reason, but I’m beginning to think it’s the best and most simple option for tracking my income (in conjunction with PayPal.)

    I’ve looked into QuickBooks, FreshBooks, Wave, etc but they come with a lot of unnecessary features that I don’t need.

    Thanks in advance for your help 🙂

    Reply
    • Filthy Rich Writer says

      March 22, 2021 at 10:22 am

      Hi A! Excel is a very user-friendly program and there are a lot of free resources on learning how to use it. For tracking income, you won’t need to have a very in-depth mastery of Excel, it’s really very basic. Hope this helps! Good luck!

      Reply
      • A.A says

        March 22, 2021 at 3:04 pm

        Okay thank you! I’ll keep that in mind.

        Reply
  4. Jackie says

    November 28, 2021 at 8:26 pm

    So helpful! If we have memberships and every month 30 ppls membership gland in stripe, do we have to log that? It’s not an invoice? Is there an automation you suggest to track non-invoice income for your cpa?

    Reply
    • The Filthy Rich Writer Team says

      November 30, 2021 at 11:25 am

      It sounds like these are memberships for a business (most copywriters don’t have memberships!). In that case, you wouldn’t track them with your invoices – you track your invoices because you have to wait for them to be paid, while membership payments are automatically paid. Still, of course, you will need to track that income. You might want a master excel doc to track all of your income streams. Hope that helps!

      Reply
  5. Janelle says

    January 5, 2023 at 8:11 pm

    Do you know of any resources for figuring out how much money you need to set aside for taxes for each project?

    Reply
    • The Filthy Rich Writer Team says

      January 6, 2023 at 1:04 am

      Your best bet is to talk to a tax professional as every situation is different. We have done a few posts about taxes as a freelance copywriter, here’s the link to our Q&A to offer some guidance – https://filthyrichwriter.com/copywriting-qa-planning-for-taxes/

      Reply

Leave a Reply Cancel reply

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

Click here to subscribe

Break Into Copywriting

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



Click here to subscribe

Comprehensive Copywriting Academy

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

Learn more
Comprehensive Copywriting Academy from Filthy Rich Writer

Portfolio Tips

  • Nicki Krawczyk, founder of Filthy Rich Writer and the Build Your Copywriting Business podcast
    Ep. 43: 4 Biggest Copywriter Portfolio Mistakes
  • Home office with desktop computer, tablet, and a mobile
    3 Copywriter Portfolio Examples That Wow Clients
  • Nicki Krawczyk, founder of Filthy Rich Writer and the Build Your Copywriting Business podcast
    Ep. 22: Why Every Copywriter MUST Have an Online Portfolio

Top Resources

  • What is Copywriting?
  • How Much Do Copywriters Actually Make?
  • Is Copywriting Hard to Get Into?
  • Why Copywriting Certificates Are B-S
  • How Soon Can You Make Money as a Copywriter?
  • What Does a Copywriter Actually Do?
  • Copywriting vs. Copyediting: What's the Difference?
  • Avoid the Copywriting Niche Trap
  • Upwork is NOT the Path to Copywriting Success
  • Getting Started in the Comprehensive Copywriting Academy

Recent Articles

  • Nicki and Kate sit at a table with podcast recording microphones, notebooks, and Filthy Rich Writer mugs, with the words "Build Your Copywriting Business" above them.
    Episode 227: How Do I Write an About Page? [Copywriting Tips]
  • Nicki and Kate sit at a table with podcast recording microphones, notebooks, and Filthy Rich Writer mugs, with the words "Build Your Copywriting Business" above them.
    Episode 225: What Jobs Can I Do As a Copywriter?
  • Nicki and Kate sit at a table with podcast recording microphones, notebooks, and Filthy Rich Writer mugs, with the words "Build Your Copywriting Business" above them.
    Episode 223: If Not Now, When? A Deep Dive Into Decision Making
  • Nicki and Kate sit at a table with podcast recording microphones, notebooks, and Filthy Rich Writer mugs, with the words "Build Your Copywriting Business" above them.
    Episode 221: “I Don’t Want To!” Tactics for Completing Un-Fun Tasks
  • Nicki and Kate sit at a table with podcast recording microphones, notebooks, and Filthy Rich Writer mugs, with the words "Build Your Copywriting Business" above them.
    Episode 220: How to Have Uncomfortable Client and Work Conversations
  • Instagram
  • Facebook
  • YouTube
  • LinkedIn

Copyright © 2025 Filthy Rich Writer | Contact Us | FAQs |About Us | Terms of Service | Privacy Policy| Business Affiliates

Manage Consent
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Manage options Manage services Manage {vendor_count} vendors Read more about these purposes
View preferences
{title} {title} {title}