How I track affiliate income across currencies and payment gateways

Affiliate income becomes difficult to manage when a blog earns in several currencies and each network uses a different payment method. A commission may be reported in US dollars, paid in euros, converted by PayPal, and finally deposited into an Australian bank account in AUD. Treating all of those figures as interchangeable creates confusion very quickly.

I learned to separate the amount earned, the amount approved, the amount paid, and the amount that actually arrived in my account. Those are four different figures. The difference can include refunds, network adjustments, currency conversion margins, withdrawal charges, and payment processing fees.

My system is deliberately simple: one master spreadsheet, a separate record for each payment gateway, and a monthly reconciliation against bank statements and affiliate dashboards. It works for a small personal blog, and it gives me enough detail to understand which programmes are genuinely profitable.

I record the original currency first

The first rule is to preserve the commission in the currency in which the affiliate network reports it. If a US programme shows a commission of USD 86.40, I enter USD 86.40 in the original-currency column. I do not immediately replace it with an approximate Australian dollar amount.

My basic spreadsheet includes these columns:

This structure lets me compare programmes fairly. A commission from a British merchant might appear in GBP, while an Australian retailer reports in AUD and an American software company uses USD. Keeping the source amount intact means I can later check the number against the merchant dashboard without wondering which exchange rate I used.

I also distinguish between pending, approved, reversed, and paid. A pending commission is potential income, not cash flow. This matters with free trials, software subscriptions, and physical products, where returns or failed card payments can remove a commission weeks after it first appeared.

I use a consistent AUD conversion method

For everyday reporting, I convert each transaction to AUD using the exchange rate on the date the commission was paid or received. The choice depends on what I am measuring. For revenue performance, I may use the date the commission was approved. For bookkeeping and cash-flow tracking, the payment or deposit date is more useful.

I write the source of the exchange rate in a notes column. It might be the rate shown by Wise, the rate in my bank statement, or a historical rate from a reputable currency service. I avoid mixing a mid-market rate for one transaction with a payment provider’s retail rate for another, because that makes monthly comparisons unreliable.

For example, if a network pays USD 100 and my bank converts it at 0.65 AUD per US dollar, the gross converted value is AUD 153.85. If the gateway takes USD 3 and the bank adds a conversion margin, the amount deposited will be lower. I record the gross amount, the fee, and the final AUD deposit separately rather than hiding the difference inside one exchange-rate figure.

This approach reflects the reality of running a blog from Australia. The AUD can move noticeably against the US dollar, Japanese yen, or euro, and a strong month in US-dollar commissions may look weaker when converted during an unfavourable exchange period. Tracking both currencies shows whether the change came from traffic and sales or from foreign-exchange movement.

I reconcile each gateway separately

PayPal, Wise, direct bank transfers, and network-managed payment systems all produce different records. I give each gateway its own tab and match the payout ID, date, currency, and net amount to the corresponding affiliate-network entries. This prevents one large monthly deposit from being mistakenly treated as a single commission.

PayPal needs particular attention because its displayed exchange rate can include a conversion margin. I record the amount sent by the affiliate network, the PayPal fee if one appears, the exchange rate used by PayPal, and the amount transferred to my Australian account. If I leave a balance in USD, I do not count it as converted AUD income until I actually exchange or withdraw it.

Wise is useful when a network supports local receiving details or sends a foreign-currency payment. In that case, I record the currency arriving in the Wise balance first. When I convert it to AUD, I add a second line for the conversion, including the transparent fee. That keeps the commission transaction separate from the later currency exchange.

Direct bank deposits can be easier to reconcile, although international transfers may include intermediary-bank charges. I compare the payment advice from the network with the amount shown by my bank rather than assuming the difference is a missing commission. This has been especially helpful when checking payments against an Australian bank statement, where the deposit description may be abbreviated.

I connect commissions with content and traffic

Knowing the total payout is useful, but I also want to know which content generated it. My spreadsheet includes a campaign or article field, such as “WordPress migration guide”, “hosting comparison”, or “AFFINGER5 tutorial”. I use tracking IDs where an affiliate programme allows them, while keeping the naming format consistent across links.

This gives me a clearer view of earnings per article, conversion rate, and revenue by merchant. A post may generate fewer clicks than a broad review but produce higher commissions because the visitors have stronger buying intent. A seasonal travel article may perform well in Australian summer, while a WordPress tutorial may bring steady international traffic throughout the year.

When I move or rebuild a site, I also check whether tracking parameters, redirects, and affiliate links survived the process. My blog migration workflow includes checks that are useful for this: testing important URLs, reviewing redirects, and confirming that monetised pages still load correctly. A technically successful migration can still damage revenue if an affiliate link points to an old address or loses its tracking identifier.

I review the data by source country as well. Australian readers may use AUD pricing and local merchants, while visitors from the United States or Europe may convert through a different store or currency. That distinction helps me decide whether a page needs a local affiliate option, clearer shipping information, or separate links for international readers.

I separate reporting from Australian tax records

My monthly report has three totals: gross commissions earned, net cash received, and expenses or fees. These totals answer different questions. Gross commissions help measure the performance of the blog, net cash shows what reached me, and fees explain the gap between the two.

For Australian records, I keep payout statements, invoices or payment advice, bank statements, and screenshots of network reports in a dated folder. I record the AUD value using a consistent method and retain the original foreign-currency amount. An Australian sole trader may need to discuss income recognition, GST registration, and foreign-currency treatment with a registered tax professional, so I use my spreadsheet as an organised source of evidence rather than treating it as tax advice.

I also avoid assuming that an overseas affiliate programme follows Australian payment conventions. Some networks pay monthly after a long validation period, while others have minimum thresholds or hold balances until a payment method is verified. A commission earned in March may arrive in May, and a payout can cross financial years.

Sydney and Melbourne-based creators often have several domestic options for banking and accounting, while someone working remotely from Perth, Brisbane, or regional Queensland may prefer online payment services to reduce international transfer costs. The location does not change the need for reconciliation, but it can affect bank fees, transfer timing, and the most practical payment setup.

I review the numbers once a month

At the end of each month, I export reports from every affiliate dashboard and compare them with my spreadsheet. I search for duplicate transaction IDs, check commissions that changed status, and mark any payment that has not yet arrived. Then I compare the total net payouts with the relevant PayPal, Wise, or bank records.

I calculate a few simple measures: earnings by currency, average conversion cost, revenue by affiliate programme, and the percentage of approved commissions that were later reversed. I also compare the AUD result with the original-currency result. That prevents me from misreading a currency swing as a change in content performance.

If a gateway conversion cost is consistently high, I consider whether the programme offers another payment route. Some networks permit bank transfer, Payoneer, or PayPal; others provide no choice. I judge the alternative by the full cost, minimum payout, arrival time, and administrative effort rather than by the advertised fee alone.

The final step is a short monthly note explaining unusual movements. I might write that a large USD payout arrived late, that a merchant reversed several trial commissions, or that a stronger AUD reduced the local value of European earnings. These notes make future reviews much faster and preserve the reasoning behind the figures. With that habit, multi-currency affiliate income becomes a manageable bookkeeping task instead of a collection of unexplained deposits.