How to Track Affiliate Earnings and Avoid Common Mistakes in 2026

How to Track Affiliate Earnings and Avoid Common Mistakes in 2026

Learning how to track affiliate earnings is the difference between guessing and knowing what works. Many beginners earn from three or four places at once, and none of them shows the full picture. One dashboard shows clicks, another shows sales, and a third shows a payment that arrived two months later. Without one home for your numbers, you cannot tell which post earned, which link failed, or whether you made a profit after costs. This guide gives you a simple system you can run in a spreadsheet, with labelled links and a short weekly routine.

Disclosure: this guide contains affiliate links. If you buy through them, EarnQuill may earn a commission at no extra cost to you. Read our affiliate disclosure.

This guide explains how affiliate tracking actually works, how to build a sheet with three tabs, how to label every link so you know what earned, how to log commissions by status, how to count costs and work out net income, and which metrics matter. It also covers tracking across programmes and channels, a weekly and monthly review routine, what to do when your numbers do not match the dashboard, and how to keep records for tax time. It is written for beginners with one to five programmes and no paid tracking tool.

In this guide

• How affiliate tracking actually works
• Step 1: Pick one home for your numbers
• Step 2: Build the sheet
• Step 3: Label every link
• Step 4: Log each commission and its status
• Step 5: Count your costs too
• Step 6: Read the metrics that matter
• Step 7: Track across programmes and channels
• Step 8: Set a weekly and monthly review routine
• Common mistakes
• When your numbers do not match the dashboard
• Frequently asked questions

How affiliate tracking actually works

Affiliate tracking follows a simple chain. A reader clicks your link, the programme records that click, and a cookie window starts. A cookie window is the period after the click during which a sale still counts as yours. If the reader buys inside that window, the sale is linked to your click. The commission then moves through stages: pending, approved, paid, or reversed. Pending means the sale is recorded but not yet confirmed. Approved means the programme has confirmed it. Paid means the money has been sent to you. Reversed means the sale was cancelled, returned, or ruled out, so the commission is removed.

Each programme has its own dashboard, its own cookie window, and its own payment timing. That is why one dashboard never tells the full story. Your own sheet is the place where those separate stories meet. The dashboard is your baseline, because it is the programme's own record. Your sheet is your check, because it shows what you expected, what you received, and what is still missing.

A sale can also be tracked by a tracking ID, which is a short label you add to a link so the programme can tell you which post, email, or channel the click came from. Without that label, you may know that you earned, but not where the sale came from. That gap is the most common tracking failure for beginners.

Step 1: Pick one home for your numbers

Pick one spreadsheet as the home for your numbers, and keep it there. A free spreadsheet app, such as Google Sheets, is enough for most beginners. Do not start with paid tracking software. Paid tools add features you do not need yet, and they still need the same habits: labelled links, logged sales, and a regular review. Start simple, and upgrade only when the sheet cannot answer a question you actually have.

Your sheet needs three tabs. The log tab records each commission. The monthly summary tab adds up income, costs, and net profit by month. The link map tab lists every affiliate link you use, where it lives, and what it points to. Three tabs are enough. More tabs create work, and work you skip is worse than a simple sheet you actually use.

Set the sheet up before your next post goes live. Tracking is much harder to fix after the fact, because you cannot label a click that already happened. If you already have links live without labels, label them now, and note the date you changed them, so you know that earlier clicks have no label.

Step 2: Build the sheet

Build the log tab first. Use these columns: date, programme, product, link label, clicks, sales, commission amount, currency, status, payment date, and notes. One row per sale, not per click. Clicks belong in the link map or in a separate weekly count, because a log row per click would fill fast and tell you little.

Build the monthly summary tab next. Use one row per month, with columns for total commission earned, total commission paid, total costs, net income, and notes. Net income is total commission paid, minus total costs, for that month. Keep the formula simple, and check it by hand once, so you trust it later. A summary tab that you trust is the page you will open each month to decide what to do next.

Build the link map tab last. Use these columns: link label, full link, short link if you use one, where the link lives, programme, product, date created, and last checked. The link map is your safety net. When a link breaks, or a programme changes its link structure, the map tells you where to fix it. Without a map, a broken link can sit unnoticed for months.

Example only: these numbers are not typical results. Imagine a log row for 12 November 2026, for a programme called Example Tools, for a writing app. The link label is blog-review-writing-app. The row shows 40 clicks, 1 sale, a commission of 9 dollars, and a status of pending. The notes say the sale came from a review post, and the payment is due about 60 days after the month earned, if the programme's terms say so. That one row tells you the post, the product, the amount, and the status, which is all you need to follow it up.

Step 3: Label every link

Label every affiliate link, every time, in the same way. A good label answers three questions: where did the click come from, what product is it, and which version of the link is it. A simple naming pattern is channel, then content, then product. For example, blog-review-writing-app means a blog review post about a writing app. Email-welcome-writing-app means a welcome email about the same app. Youtube-tutorial-writing-app means a YouTube tutorial about the same app. Use lower case, hyphens between words, and no spaces, so the label is easy to read and sort.

Use the programme's own label where it offers one. Many programmes call it a SubID, a tracking ID, or a campaign label. It is a short code you add to the link, so the dashboard can report sales by label. If the programme does not offer one, use a link shortener or link management tool that records clicks by link, and note the label in your link map.

Add UTM parameters where they help, and where the programme allows them. UTM parameters are short tags added to a link, such as utm_source, utm_medium, and utm_campaign, that tell your analytics tool where a click came from. Use the free Campaign URL Builder from Google to build them correctly, so you do not mistype a tag. Do not put personal data in UTM values, such as a name or an email address. Google's own guidance says personal data must not be sent in UTM parameters, and a reader's privacy matters more than a tidy report.

Check the programme rules before you cloak a link. Link cloaking means showing a short, tidy link that redirects to the affiliate link. Some programmes allow it, and some do not. Amazon Associates, for example, does not allow cloaking that hides the destination, as its Associates Program Policies explain. Read the rules for each programme you join, and follow the strictest rule when you are unsure.

Step 4: Log each commission and its status

Log each commission on the day you see it, or at least once a week. A sale you do not log is a sale you will forget, and a forgotten sale is a sale you cannot follow up. Copy the date, the programme, the product, the link label, the amount, the currency, and the status from the dashboard into your log tab. Do not copy only the paid total. Paid totals hide pending sales, reversed sales, and sales that are stuck.

Update the status when it changes. A pending sale that becomes approved is progress. A pending sale that becomes reversed needs a note, so you can see whether returns are common for that product. A sale that stays pending for months needs a check, because the programme may have a long approval period, or the sale may have a problem.

Keep the currency as the programme reports it. If you earn in dollars, pounds, and euros, log each sale in its own currency, and add a separate column for the amount in your home currency on the day you convert it, if you convert it. Do not mix currencies in one column, because the totals will be wrong. Note any fee the programme or the payment provider takes, so your net income is honest.

Step 5: Count your costs too

Income without costs is not profit. Many beginners track sales and forget the money they spent to get them. List every cost in your monthly summary: hosting, domain, email tool, link tool, design tool, paid adverts, and any product you bought to test. Add the date and the amount, and keep the receipt or the invoice where you can find it.

Work out your break even point, which is the income you need to cover your costs. If your costs are 20 dollars a month, and your average commission is 10 dollars a sale, you need two sales a month to break even. That simple sum tells you whether a channel is worth your time. A post that brings many clicks but no sales, after months of work, may cost more in time than it earns in commission.

Example only: these numbers are not typical results. Imagine a month where you earn 45 dollars in approved commission, pay 15 dollars for hosting and an email tool, and spend nothing on adverts. Your net income is 45 minus 15, which is 30 dollars. If only 25 dollars of that commission is paid that month, and 20 dollars is still pending, your paid income is 25 dollars, and your paid net is 10 dollars. That split between earned, approved, and paid matters, because only paid money is in your account.

Step 6: Read the metrics that matter

Three metrics matter most for beginners: clicks, conversion rate, and earnings per click. Clicks tell you how many people followed a link. Conversion rate tells you how many of those clicks became sales, as a percentage. Earnings per click, often shortened to EPC, tells you how much you earn on average per click, in money terms.

Work them out from your own numbers, not from a figure you read online. Conversion rate is sales divided by clicks, multiplied by 100. If a link gets 200 clicks and 2 sales, the conversion rate is 2 divided by 200, which is 1 percent. EPC is total commission divided by total clicks. If those 200 clicks earn 20 dollars, the EPC is 20 divided by 200, which is 10 cents per click. Recalculate both numbers twice, because a small error here can mislead a big decision.

Do not treat a conversion rate you read in a blog post as typical for your site. Conversion rates vary by offer, audience, traffic source, and price, and a figure quoted without a source is not a fact. Compare your own numbers over time instead. If a post had 50 clicks last month and 80 this month, with the same conversion rate, it is improving. If clicks rise but sales fall, check the link, the price, and the product page, because something changed.

Metric	How to work it out	What it tells you
Clicks	Count of link clicks in the period	How many people followed the link
Conversion rate	Sales divided by clicks, times 100	How many clicks became sales
Earnings per click	Commission divided by clicks	How much each click earned on average

Step 7: Track across programmes and channels

Most affiliates use more than one programme, and more than one channel. That creates three problems: different dashboards, different currencies, and different payment timings. Your sheet solves all three, if you keep it in one place. Log every sale in the same log tab, with the programme name and the currency in their own columns. Add a column for the payment date you expect, based on that programme's own terms, and update it when the money arrives.

Check each programme's payout threshold, which is the minimum amount you must earn before the programme pays you. Thresholds differ by programme, and by payment method. Some pay at 10 dollars by direct deposit, and some pay only at 50 or 100 dollars. Check the terms in your own account, because a threshold you read in a blog post may be old or may apply to another country. Note the threshold in your link map or in a short programme notes tab, so you do not have to search for it each month.

Track non-website channels in the same way. A YouTube description link, a Pinterest pin, and an email link all need their own label, so you can tell which channel earned. Use one link per channel for the same product, where the programme allows it, and note the channel in the label. That way, a sale from a video does not get mixed up with a sale from a blog post. For the YouTube method in detail, read how to use YouTube for affiliate marketing, and for promotion in general, read how to promote affiliate products.

Step 8: Set a weekly and monthly review routine

Tracking only works if you look at the numbers. Set a short weekly routine of 15 minutes. Open each dashboard, log any new sales, update any status changes, and check that your top five links still work. Then look at the week's clicks and sales, and ask one question: what earned, and what did not. Write the answer in one line in your sheet, so you can see the pattern over time.

Set a longer monthly routine of about one hour. Add up the month's income by programme and by channel, add up the month's costs, and work out net income. Compare the month with the last month, using your own numbers. Then make one decision. That decision might be to update a post that gets clicks but no sales, to fix a link that gets no clicks, to stop promoting a product that never sells, or to write a follow-up post on a topic that does sell. One decision a month, acted on, beats ten decisions you never make.

Common mistakes

• Waiting until income arrives before you start tracking, so your first sales have no label and no source.
• Keeping numbers in too many places, such as three dashboards, two sheets, and a notes app, so no one place shows the truth.
• Logging only paid income, and ignoring pending, approved, and reversed sales, so you cannot see what is stuck.
• Forgetting costs, so a month that looks profitable is actually a loss after hosting and tools.
• Using no link labels, so you know you earned, but not which post or email earned.
• Building a sheet so fancy that you stop using it, instead of a simple sheet you open every week.
• Ignoring the numbers, so a broken link or a falling product sits unnoticed for months.
• Comparing your conversion rate with an unsourced figure online, instead of comparing your own numbers over time.

When your numbers do not match the dashboard

A mismatch between your sheet and a dashboard is common, and it usually has a simple cause. Check timing first. A sale may appear in the dashboard days after the click, and a payment may arrive about 60 days after the month earned, depending on the programme. Check refunds and returns next, because a reversed sale will lower the dashboard total. Check currency and fees, because a payment in another currency, minus a fee, will not match your log if you copied the wrong figure. Check the cookie window, because a sale outside the window does not count as yours.

If the gap is small, note it and watch it next month. If the gap is large, or a sale you expected never appears, contact the programme support team with the date, the link label, and the product, and ask them to check it. Keep the reply in your notes. Do not accuse the programme of an error until you have checked timing, refunds, currency, and fees yourself. Most mismatches are timing or returns, not missing sales.

Frequently asked questions

How do I track my affiliate earnings?

Start with one spreadsheet, with a log tab, a monthly summary tab, and a link map tab. Label every link with a tracking ID or SubID, log each sale with its status, and review the sheet weekly. The dashboard is your baseline, and your sheet is the place where all programmes meet in one view.

What is EPC in affiliate marketing?

EPC means earnings per click. It is total commission divided by total clicks, and it tells you how much each click earned on average. If 200 clicks earn 20 dollars, the EPC is 10 cents per click. Use your own numbers to work it out, and compare it over time, because EPC varies by offer, audience, and traffic source.

How do I know which post earned a sale?

Label each link with a tracking ID that names the channel and the content, such as blog-review-writing-app. When a sale appears in the dashboard, the label tells you which post or email it came from. Without a label, you may know that you earned, but not where the sale came from.

Do I need paid software to track affiliate sales?

No, not at the start. A free spreadsheet, labelled links, and a weekly review cover the full system in this guide. Paid software can save time later, when you have many links and many sales, but it does not replace the habits of labelling links, logging sales, and reviewing the numbers.

What is the difference between clicks and conversions?

A click is a person following your link. A conversion is a click that becomes a sale, or another action the programme pays for, such as a sign-up. Many clicks and few conversions may mean the link works, but the product page, the price, or the audience fit needs a closer look.

Why do my clicks differ from the network clicks?

Click counts differ because each tool counts in its own way. Your link tool may count every click, while the programme may count only clicks that reach its page, or only clicks inside the cookie window. Ad blockers, bots, and repeat clicks can also change the count. Compare trends over time, not single days, and use the programme dashboard as the baseline for sales.

Conclusion: one sheet, labelled links, and a weekly look

Tracking affiliate earnings is a habit, not a tool. Pick one spreadsheet, build three tabs, label every link, log each sale with its status, count your costs, and read clicks, conversion rate, and earnings per click from your own numbers. Then review the sheet for 15 minutes each week, and make one decision each month. That routine will show you which posts earn, which links fail, and whether you made a profit after costs.

Your next step is to build the sheet today, before your next post goes live, and label every link in it. Then read how to make your first affiliate sale to see where tracking fits in the wider system, and browse all our guides in the affiliate marketing category. For video traffic, see how to grow a YouTube channel, and for search basics, see how to learn SEO for beginners.