There are three ways to track affiliate earnings across networks: a spreadsheet you update from each network's exports, an automated pull from the networks' reporting APIs into a sheet or database, or a paid affiliate earnings aggregator that connects to the networks for you and shows everything in one dashboard. Whichever you choose, use consistent sub-IDs so earnings can be traced back to pages, and keep a separate record of actual payments received for your accountant.
Most publishers start with a spreadsheet, move to an aggregator once they work with more than a handful of networks, and only build their own API pipeline if they have developer time and unusual needs.
Why combining affiliate network reports is harder than it looks
Each network reports in its own way. Before you combine anything, expect these differences:
- Dates: some report by click date, others by conversion or approval date.
- Statuses: pending, approved, locked, paid, reversed, declined, each defined differently.
- Currencies: commissions in euros, dollars and pounds, sometimes converted at the network's rate.
- Time zones: a sale at 23:30 in London may fall on the next day in a US-based network's report.
- Sub-ID fields: different names, character limits and numbers of fields.
- Recurring income: RevShare commissions arrive months after the original click.
Decide your own definitions once (for example, "earned" means approved, by conversion date, in euros at a monthly average rate) and translate every network into them.
Three ways to track affiliate earnings across networks
| Spreadsheet | Network APIs | Aggregator tool | |
|---|---|---|---|
| Cost | Free | Developer time, hosting | Monthly subscription |
| Setup time | An afternoon | Days to weeks | An hour or two |
| Ongoing effort | Manual exports each week or month | Maintenance when APIs change | Low; reconnect when credentials change |
| Network coverage | Any network with an export | Only networks with an API | The tool's supported list |
| Best for | Up to about five networks | Large publishers with developers | Portfolios across many networks |
Option 1: The spreadsheet
Create one raw tab per network, pasted from its export in the original format, plus a lookup tab mapping sub-IDs to pages and programs. A summary tab totals approved and pending commission by month, network and page. This is the same structure as our affiliate reporting dashboard guide, and the two can share a file.
The weakness is discipline: miss a month and the gaps are hard to fill, because some networks only keep detailed data for a limited period.
Option 2: Network APIs
Most large networks and many in-house adult programs offer a reporting API or scheduled report emails. A script that pulls transactions daily into a database or Google Sheet gives you full control and history. You will need to handle authentication, rate limits, currency conversion and status changes (a sale approved last month may be reversed this month, so pull by date modified, not just date created).
Option 3: An affiliate earnings aggregator
An affiliate revenue tracking tool connects to your networks using your API keys or logins and normalises the data into one dashboard. Examples include Strackr, which lists connections to hundreds of networks, and wecantrack, which also attributes conversions to clicks and can send them to GA4 and ad platforms. Before you sign up, check:
- That it supports your networks, especially smaller adult programs, which many tools do not cover.
- How often it refreshes data and how far back it imports.
- Whether it keeps sub-ID detail or only totals.
- What happens to your data if you cancel, and whether you can export everything.
- How it stores network credentials, and whether it can use read-only API keys instead of passwords.
Matching revenue back to pages
To track commissions in one place and know which pages earn them, every affiliate link needs a sub-ID that identifies the page, and ideally the position on it. Use the same format in every network, such as page-slug_position, and respect the shortest character limit among your networks. Our guide to sub-IDs covers naming in detail.
Hypothetical example: you promote three cam programs from one comparison page. Program A pays £410 for the month, B £260 and C £95. Joined to your click data by sub-ID, A earns £0.55 per click, B £0.62 and C £0.19. B deserves the top slot, despite paying less in total, and C may need replacing.
Network totals will not match your own click counts or each other perfectly. Small gaps are normal; unexplained large gaps are worth investigating with our guide to tracking discrepancies.
Keeping records accountants can use
Performance reporting and accounting records are different things. Your dashboard shows what you earned by page; your accountant needs what you were actually paid, when and in what currency. Keep both.
- A payments ledger: date received, network, amount, currency, amount in your base currency, and the bank or wallet it arrived in.
- Statements and invoices: download each network's payment statement or self-billing invoice when it is issued, and file it by month. See our guide to self-billing invoices from affiliate programs.
- Reconciliation: each month, tick off ledger entries against bank deposits and network statements.
- Fees and exchange losses: record payout fees and conversion costs separately.
In the UK, HMRC says self-employed people must keep records for at least five years after the 31 January submission deadline for the relevant tax year. Making Tax Digital for Income Tax now applies to sole traders and landlords with qualifying income over £50,000, with the threshold falling to £30,000 from April 2027 and £20,000 from April 2028, according to GOV.UK. If you are in scope, your records need to work with compatible software. Read our guide to Making Tax Digital for affiliates. Other countries set their own retention periods.
This is general information, not tax advice. Rules depend on your country and business structure, so confirm your record-keeping with an accountant.
A monthly routine
- Weekly: refresh performance data and check for falls in approval rates.
- Monthly: record payments received, download statements, reconcile with the bank, update exchange rates.
- Quarterly: review which networks and programs earn most per click and whether to renegotiate or replace any.
Frequently asked questions
Should I count pending or approved commission?
Report both, separately. Pending commission is useful as an early signal of performance, but approved (or locked) commission is what you will actually be paid. Treating pending as earned overstates income, especially on lead offers with high reversal rates.
Which exchange rate should I use?
For performance reporting, a fixed monthly average rate keeps figures stable. For accounting, use the amount that actually arrived in your account, or the method your accountant recommends. See our guide on whether to be paid in euros, dollars or pounds.
Next steps
List every network you earn from and how each reports. If it is more than five, trial an aggregator alongside your spreadsheet for a month and compare totals. Compare tracking and reporting platforms in our affiliate tracking platforms directory.