Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesMarketing & GrowthGrowth & Agency OperationsAffiliate Program Tracker

SpreadsheetGrowth & Agency OperationsFree

Affiliate Program Tracker

Track affiliates’ clicks, orders and revenue, calculate tiered commission net of refunds and manage monthly payouts.

Shown with sample data

Colour

Affiliate Program Tracker

Track affiliates’ clicks, orders and revenue, calculate tiered commission net of refunds and manage monthly payouts.

Net affiliate sales
$65,620
Commission due now
$2,895
Effective cost of sale
11%
Commission ÷ net sales
Earnings per click
$0.23
Active affiliates
5
Affiliates to review
1
Commission earned by affiliate
  • Lena Bakes (creator)$3,766
  • Kitchen Confidential Blog$1,752
  • DealHub Coupons$1,287.20
  • Home Cook Weekly$173.60
  • Tom’s Gear Reviews$43.20

How to use it

  1. 1Set commission rates per tier and the minimum payout on the Settings sheet.
  2. 2Add a row per affiliate per month with clicks, orders, gross sales and refunds from your tracking tool.
  3. 3Add any agreed bonus (for example for a launch) in the Bonus column.
  4. 4Pay rows marked Due after the refund period and change Payout status to Paid.
  5. 5Review earnings per click and cost of sale quarterly and move strong affiliates up a tier.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Run an affiliate programme without paying for software until you outgrow it. Log each affiliate’s monthly clicks, orders, gross sales and refunds; the tracker applies the commission rate for the affiliate’s tier from the Settings sheet to net sales, adds any bonus, holds payouts below the minimum threshold and shows what is owed, paid and due. Conversion rate, earnings per click and effective cost of sale tell you which partners are worth investing in.

Who it’s for

  • Brands running affiliate or creator programmes
  • Monthly commission calculation and payouts
  • Comparing affiliate quality, not just volume
  • Programmes with tiered commission rates

What’s included

  • Monthly results sheet: One row per affiliate per month.
  • Affiliates sheet: Each affiliate’s tier and totals.
  • Settings sheet: Commission rates and payout rules.

How to use it

  1. 1Set commission rates per tier and the minimum payout on the Settings sheet.
  2. 2Add a row per affiliate per month with clicks, orders, gross sales and refunds from your tracking tool.
  3. 3Add any agreed bonus (for example for a launch) in the Bonus column.
  4. 4Pay rows marked Due after the refund period and change Payout status to Paid.
  5. 5Review earnings per click and cost of sale quarterly and move strong affiliates up a tier.

Tips

  • Pay commission on net sales after refunds and after your returns window closes, and say so in your affiliate terms.
  • Earnings per click (EPC) is the number affiliates care about; a higher EPC attracts better partners.
  • Watch for coupon-site affiliates claiming sales you would have made anyway; check new versus returning customers.
  • Affiliates must disclose the relationship (for example under FTC rules in the US or ASA/CAP rules in the UK); include this in your terms.

Questions

How is affiliate commission calculated?

Usually as a percentage of net sales (gross sales minus refunds and sometimes tax and shipping) at the affiliate’s rate, plus any flat bonuses. This sheet uses the tier rate from Settings × (gross sales − refunds) + bonus.

What is a typical affiliate commission rate?

Physical products often pay 5–15%, digital products and software 20–50% of the first payment or a recurring share. Set rates from your gross margin and what a customer is worth to you.

What is a minimum payout threshold?

The smallest balance you will pay out, which avoids many tiny transfers. Balances below it roll over to the next month.

Related searchesaffiliate program trackeraffiliate commission calculatoraffiliate marketing spreadsheetaffiliate payout trackerinfluencer affiliate trackingpartner commission tracker

Details

Format
Spreadsheet
Category
Growth & Agency Operations
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetGrowth & Agency OperationsFree

Affiliate Program Tracker

Track affiliates’ clicks, orders and revenue, calculate tiered commission net of refunds and manage monthly payouts.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Growth & Agency Operations
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More growth & agency operations templates

View all

Marketing Request Form

Let teams request design, content or campaign support with everything marketing needs.

Name *

Email *

Team *

SalesProductCustomer success
Submit request
FormGrowth & Agency Operations

Marketing Request Form

Let teams request design, content or campaign support with everything marketing needs.

10 min setupPreview

Marketing Report: Client name

Period: Month, year Prepared by: Name, agency Date: Date

1. Summary

Three or four sentences: the headline result, the main reason for it, and the focus for next month.

2. Results against goals

GoalTargetThis month
Qualified leads8091
Cost per lead$60$54

3. What worked

  • 1.Activity: What happened and the result, with a number.
  • 2.Activity: What happened and the result.
  • 3.Activity: What happened and the result.
DocumentGrowth & Agency Operations

Monthly Marketing Report for Clients

A report clients read: results against goals, what worked, what did not and next month’s plan.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ