• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
  • Home
  • Blog Monetization
  • Social Media
  • WordPress
  • Resources
  • Freebies
  • Nav Widget Area

    • Bloglovin
    • Facebook
    • Instagram
    • Pinterest
    • Twitter

Lovely Blog Academy

Lovely tips for growing and monetizing your blog

AFFILIATE MARKETING FREEBIES

Download my beginner's guide to affiliate marketing & my income tracking spreadsheet by signing up to my weekly email newsletter:

Thank you! Now check your email inbox

FREE: Blog income tracking spreadsheet

Free affiliate income tracker

I have to admit, I’m not the most organised person in the world.  I started monetizing blogs nearly six years ago and up until last year, I never kept a proper record of my affiliate income.

Don’t get me wrong – I did the maths and filed my tax returns in April every year.  But otherwise, I was useless.  For example, if you had asked me how much I’d earned in November 2015 compared to November 2014?  I’d have no clue.  That had to change!

So, I created this income tracking spreadsheet:

Free affiliate income tracking spreadsheet

I’ve used it every single day since January 2016.  I can quite honestly say it has transformed my entire business and my earnings have consistently improved since using it.

Would you like a copy of the spreadsheet?
I’m giving it away for free!  Details below! 

Here’s how the spreadsheet can help you:

  • Compare your monthly earnings year-on-year to see growth
  • Fill in last year’s earnings to spot seasonal trends
  • This allows you to plan ahead (I’ve found this SO helpful)
  • Spot your best performing networks
  • Track other blog income too, like sponsored posts and Adsense revenue
  • Set a target you’d like to reach (I suggest aiming high)
  • The spreadsheet will work out how much you need to earn per day to meet the target
  • The spreadsheet will tell you how much you’re CURRENTLY earning per day
  • In all, the spreadsheet will help keep you motivated on a daily basis. (I fill out the spreadsheet at 9am every morning with a cup of tea.)

DOWNLOAD FOR FREE

The download is stored in my free content library. Unlock access (and sign up to my weekly newsletter) by entering your email address below:

Thank you! Now check your email inbox

How to use the blog income tracker:

I’m going to walk you through each tab and explain how to make full use of the spreadsheet.

TAB 1: AFFIL 2017

This is where you’ll record your income for 2017.  I check my affiliate networks and other income streams every morning and record them in this section.

NOTE: The currency is currently set to USD (United States Dollars) but it’s easy to switch into your local currency. Simply select all of the cells in the table and click FORMAT > CELLS > CURRENCY 

NETWORKS: Rename the teal/green boxes on the left to suit your own needs. You can list as many or as few networks as you like.  Record income from affiliate networks, advertising networks, sponsored posts, freelance gigs, etc.

TARGET EARNINGS: Amend this to suit your own goals.  This is to keep you motivated throughout the month.  It will encourage you to think of new ways to meet the target.

CURRENTLY EARNING PER DAY: This is how much you’re currently making per day for the given month.  You’ll need to update the formula manually on the first of every month.  But it’s just one small change:  Change the cell number to correspond with the month.  It’s set to February by default (E14) so in March, you will need to change this to F14 and so on.

NEED PER DAY: This is how much you NEED to be making per day in order to hit your target.

The total bars will automatically change colour throughout the year. Your highest earning months will be highlighted green and your lowest earning months will be coloured red.

TAB 2: AFFIL 2016

This is where you’ll record your income for 2016. This will give you an accurate benchmark for setting targets. Plus, you can compare this year’s income with last year’s. It also allowed me to spot patterns in my earnings. I realised that I had some low earning months and some more lucrative months due to seasonal factors. This enabled me to plan ahead and come up with different strategies. It will take some time to fill in this section, but I promise it’ll be worth it!

Share this with other bloggers

If you find our affiliate income tracking spreadsheet useful, consider sharing it with other bloggers on Pinterest:

affiliate income tracker

1st February 2017 7:48 pm Carly Filed Under: Monetizing your blog

Any questions?

Leave a comment below, or head over to the LBA Community Facebook group.

Visit us on Facebook

Advertisement

Feminine WordPress Themes

Primary Sidebar

HI, I’M CARLY

If you're a blogger looking for helpful tips with a focus on monetization and affiliate marketing... you've come to the right place! ABOUT ME & THIS SITE

TRIED, TESTED & RECOMMENDED

Want to get started with affiliate marketing? I use and recommend SkimLinks. Install it and it'll monetize your content automagically. Works with ANY site:

SkimLinks

RECENT POSTS

  • Can I use Shopstyle Collective with WordPress.com?
  • Can I boost my Amazon Affiliate Links on Facebook?
  • How to add a ShopStyle Collective widget to your sidebar in WordPress
  • Can I post Amazon affiliate links to Pinterest?
  • FREE: Blog income tracking spreadsheet
  • A guide to using affiliate links on Facebook
  • How to monetize your WordPress.com blog
  • A beginner’s guide to WordPress security
  • 17 successful affiliate linking strategies you need to know
  • How to add links to image captions in WordPress

MORE FROM THE BLOG

Guide to affiliate marketing and promoting affiliate links on Facebook

A guide to using affiliate links on Facebook

How to manage mupliple Pinterest accounts using Google Chrome

How to easily manage multiple Pinterest accounts (for FREE)

Tips for affiliates/bloggers

17 successful affiliate linking strategies you need to know

AFFILIATE MARKETING FREEBIES

Join my community to get:

My beginner’s guide to affiliate marketing (5-page eBook)

My affiliate income tracking spreadsheet

Access to my private Facebook group (ask questions, share your blog etc)

My email newsletter once per week

Thank you! Now check your email inbox

Browse by category

  • Blogging Tips (1)
  • Design (2)
  • Monetizing your blog (15)
  • News (1)
  • Social Media (8)
  • WordPress (6)

COME SAY HI

  • Facebook Page
  • Facebook Group
  • Instagram
  • Twitter
  • Pinterest
  • Google+

FREE DESIGN GOODIES:

Powered by Creative Market

Useful pages

  • About
  • Contact
  • Content Archives
  • Resources / Credits
  • Advertise here?
  • Disclosure
  • Cookie Policy
  • Privacy policy

RESOURCES

ShopStyle Collective, Formally ShopSense

Here's a list of every tool, app, resource and piece of equipment that I personally use on this site (or on one of my other blogs) and recommend. The list is a mixture of free and paid resources. Disclosure:  I have used affiliate links to some of the ... Read this post

Footer

DISCLOSURE

This website is supported by adverts and affiliate marketing links. This means if you click a link and/or buy a product, I might earn a commission at no extra cost to you. These partnerships help pay for this site. Regardless of this, all opinions are my own. Read my FULL earnings disclosure here for more information.

As per the Amazon Operating Agreement I have to state that I (Carly Wood) am a participant in the Amazon Services LLC Associates Program and the Amazon EU Associates Programme. These are affiliate advertising programs designed to provide a means for sites to earn advertising fees by advertising and linking to amazon.co.uk and amazon.com.

Learn more about paid advertising & affiliate marketing:
Visit: PaidForAdvertising.com

This site also uses cookies.
You can also read about cookies and how they affect you by clicking here. My privacy policy is located here.

  • About
  • Contact
  • Content Archives
  • Resources / Credits
  • Advertise here?
  • Disclosure
  • Cookie Policy
  • Privacy policy

© Copyright 2017 · CARLY WOOD · Lovely Blog Academy