Reporting in Rand: Handling Multi-Currency Sales Data
Reporting in rand when you sell in several currencies: choose exchange rates, convert sales data consistently, and separate real growth from currency movement.
· 4 min read · Summarix team
If you sell in dollars, euros or pounds but run your business in rand, your reports need every amount converted to rand using a consistent, documented exchange rate. The key decisions are which rate to use (transaction date, monthly average or month-end), where to store it, and how to show how much of your growth came from sales versus from the rand moving. Get those right and multi-currency reporting becomes routine.
Why multi-currency data causes reporting headaches
- Exports from Stripe, Shopify, PayPal or marketplaces often mix currencies in one ‘amount’ column.
- Some systems store amounts in minor units (cents), others in whole units.
- The rand amount that lands in your bank differs from the sale value because of conversion spreads and fees.
- A weaker rand makes foreign sales look like growth even when volumes are flat.
Step 1: Standardise the raw data
- Make sure every row has an explicit currency code (ZAR, USD, EUR, GBP).
- Convert minor units to major units if needed (divide cents by 100).
- Keep the original amount and currency in their own columns; add converted columns alongside rather than overwriting.
- Record whether amounts are gross (before fees) or net.
Step 2: Choose an exchange-rate policy
| Rate policy | How it works | Best for |
|---|---|---|
| Transaction-date rate | Each sale converted at that day’s rate | Accuracy per sale; closest to accounting treatment of individual transactions |
| Monthly average rate | All sales in a month converted at the month’s average | Management reports; simple and stable |
| Month-end rate | Balances converted at the closing rate | Outstanding debtors and cash balances |
| Actual settlement | The rand amount actually received in the bank | Cash reporting and reconciliations |
For management reporting, a monthly average is usually good enough and easy to explain. Whatever you choose, write it down and use the same source every month, for example the rate from your bank or a published reference rate. Your accountant will advise on the treatment required in your financial statements, which may differ from management reports.
Step 3: Keep a rate table
Maintain a small table with one row per currency per period: month, currency, rate to ZAR, and source. Then join it to your sales data on month and currency and calculate: amount in ZAR = original amount × rate. A lookup (XLOOKUP or VLOOKUP) in Excel does the job, or a join in SQL if your data is in a database.
Worked example: separating volume from currency
Say your online store sold USD 10,000 in June and USD 10,000 in July. Using illustrative monthly average rates of R18.00 in June and R18.90 in July, rand revenue rose from R180,000 to R189,000, a 5% increase. But dollar sales did not grow at all; the whole R9,000 increase came from the rand weakening.
A useful habit is to report growth two ways:
- Reported growth: in rand, at each month’s actual rate.
- Constant-currency growth: this month’s sales converted at last month’s (or last year’s) rate, which strips out currency movement.
In the example, constant-currency growth is 0%. That is the number that tells you whether your marketing and product work is paying off.
Step 4: Show fees and conversion costs
Payment processors and banks take fees and a spread on conversion. Compare converted sales value with the rand amount received for each payout. The gap is your effective cost of selling in foreign currency, and it belongs in your margin analysis alongside other financial KPIs.
Handling costs and refunds in other currencies
The same rules apply to the other side of the ledger. If you pay for software, advertising or stock in dollars, convert those costs with the same rate policy you use for sales, or your margins will be distorted. Refunds need care too: convert a refund at the same rate as the original sale if you want product-level figures to net to zero, and note the policy in your report. If a sale was made in June and refunded in August, decide whether the refund reduces June or August revenue and apply that rule consistently.
Step 5: Present it clearly
- Headline figures in rand, with the rate policy stated in a footnote.
- A breakdown of sales by currency, in both original and rand terms.
- Constant-currency growth next to reported growth.
- A short note on the rate used and its source.
If you already pull data from Stripe or Shopify, Summarix can connect to those sources or take a CSV with an added ZAR column, then compute totals, currency breakdowns and trends with its own code and write the summary around them. Data-quality notes flag problems such as missing currency codes before they distort the headline.
Turn a multi-currency export into a clear rand report.
Free plan: 5 AI reports a month, no card needed.
Summary
Label every amount with its currency, keep originals, pick one documented rate policy, and report constant-currency growth alongside rand growth. That way you and your stakeholders can tell the difference between selling more and simply benefiting from a weaker rand. For store-specific metrics, see our guide to South African e-commerce reporting.
Frequently asked questions
Which exchange rate should I use to convert sales to rand?
For management reports, a documented monthly average rate from a consistent source is common and simple. Your accountant will confirm the rates required for financial statements and tax.
What is constant-currency growth?
It is growth calculated with the same exchange rate for both periods, so it shows changes in underlying sales without the effect of currency movement.
Why does my payout differ from my converted sales?
Processors and banks deduct fees and apply their own conversion rate, and payouts are often timed differently from sales. Reconcile payouts separately from sales.