Normalize campaign costs across currencies

Combine creator costs by choosing one reporting currency, preserving each original amount, and recording the exchange-rate source and date for every conversion. Keep payment fees separate, state your rounding rule, and distinguish reference-rate estimates from cash that left your account. Those choices make influencer campaign currency reporting reproducible.

A total such as USD 900 + EUR 1,000 + GBP 801 has no single monetary value until you convert it. Even after conversion, a reader needs to know whether the result describes your budget, approved costs, or settled payments.

Decide what the total should answer

Choose the view before choosing the rate. These are recommended reporting conventions, not payment-platform requirements or financial-accounting rules.

Keep these views in separate columns. Never replace an earlier estimate with a settled number without changing its label. A partial payment also needs a status: the remaining approved amount belongs in outstanding costs, not settled cash.

For a campaign management report, agree the date policy with whoever owns its budget. Formal accounting, tax and foreign-exchange gain or loss treatment should follow your finance team's applicable requirements. This ledger does not prescribe those treatments.

Modash's creator-payment guide starts manual tracking with spend per creator and campaign, followed by invoice checks. Use the approved amount as your input here. Calculating affiliate commissions and release dates is a separate task; use the affiliate payout statement guide to work through that calculation before importing the amount.

Store a rate with its direction and date

Write the rate as a sentence: "1 EUR buys 1.10 USD." A column named "exchange rate" without currency units invites multiplication in the wrong direction.

The European Central Bank's reference-rate page quotes currencies against the euro. It normally updates around 16:00 CET on working days, except TARGET closing days. The ECB publishes these rates for information and discourages their use for transactions. A reference-rate estimate therefore needs a different label from a bank-confirmed payment.

If your policy uses a daily reference source, define what happens on a day without a published rate. For example, you could use the latest preceding published date and retain both the requested date and the effective rate date. That is a reporting choice to approve internally.

Save the actual rate values with the report. A link to a page showing today's rates will not reproduce last month's calculation.

Your ledger needs these fields:

• Campaign, creator and invoice IDs, plus payment or refund ID where available.
• Original amount and currency code, such as USD, EUR or GBP.
• Cost type, including creator fee, usage rights or transfer fee.
• Reporting currency, rate direction, value, source and effective date.
• Invoice date, settlement date and paid or outstanding status.
• Converted amount and the rounding rule applied.

Use a separate fee row if its currency or rate date differs from the invoice. A symbol such as "$" alone is insufficient to identify the currency.

A reproducible three-currency ledger

Every amount, fee and rate below is hypothetical. These are arithmetic examples, not current exchange rates or provider prices.

Assume a USD management report using a frozen reference-rate set dated 2026-09-01:

• 1 EUR = 1.10 USD.
• 1 EUR = 0.88 GBP.
• Therefore, 1 GBP = 1.10 / 0.88 = 1.25 USD.
• USD amounts use a rate of 1.

For this example, each transfer fee uses the invoice currency and the same reference rate. The report covers creator fees and transfer fees only. It excludes taxes, products, shipping and other campaign costs.

The rule is to keep the stored rate precision, multiply each cost component, round each converted component to USD cents, then sum. For this example, halfway values round away from zero. Keep that same rule for negative adjustments.

Record C can be checked without any external data:

Creator fee: GBP 801.00 × 1.25 = USD 1,001.25
Transfer fee: GBP 8.01 × 1.25 = USD 10.0125
Rounded transfer fee: USD 10.01
Record total: USD 1,001.25 + USD 10.01 = USD 1,011.26
Campaign total: USD 909.00 + USD 1,111.00 + USD 1,011.26
              = USD 3,031.26

Rounding only the final campaign sum can produce a different result from rounding each component. Pick one method, document it, and avoid rounding the exchange rate early to make the table shorter.

Reconcile fees and actual debits

Wise's fee documentation explains that transfer cost depends on the amount, payment method and exchange rate. Use the fee on your own payment record. A generic percentage copied into every row will not reproduce every transfer.

Keep three amounts distinct: the creator's agreed amount, any fee deducted from what the creator receives, and the amount your business pays. If a fee is already included in the settled debit, do not add it again. If you reimburse a deducted fee, record that extra payment once.

Continue the hypothetical example. Suppose record C later settles with USD 1,010.00 used for the creator payment and a USD 10.25 fee. Its settled cash cost is USD 1,020.25. The difference from the reference estimate is USD 8.99:

Principal difference: 1,010.00 − 1,001.25 = USD 8.75
Fee difference:         10.25 −    10.01 = USD 0.24
Total difference:                          USD 8.99

Retain both columns. That USD 8.99 explains a difference between two reporting bases; this example does not classify it as an accounting exchange loss.

For a refund, add a linked negative adjustment with its own date and basis. Keep the original invoice visible. For a batch payment, record the allocation rule for shared fees and check that allocated fees sum to the statement total.

Close the report with a reproducibility check

Before sharing the total, ask a teammate to rebuild one foreign-currency row using only your saved records. They should reach the same cents and identify whether the row is estimated, approved or settled.

Then confirm that:

• Every amount has a currency code and every rate has a direction.
• Missing rates remain flagged rather than silently becoming zero or one.
• Paid, outstanding and refunded amounts appear separately.
• Transfer fees appear once, including fees already inside a debit.
• The report states which cost categories it excludes.

If the number will feed a return calculation, use the complete campaign cost ledger to identify costs beyond creator payments. For gifted products, the seeding-batch cost guide covers the separate cost inventory.

Start by choosing the report's currency and cost basis. Write those choices above the ledger before converting the first invoice.