Editorial draft available to read. Factual and language review is pending. Examples are illustrative.
Decision and method
Store market, campaign and original currency separately. For consolidation, add the reporting currency and conversion rule. Preserve original amounts: adding dollars and euros under one label prevents the result from being reconstructed reliably. Also define which date determines the reporting period of each amount.
Illustrative example
Illustrative example: one campaign records EUR 800 and another USD 900. The report shows two columns. A comparison may use an agreed and visible sample rate, but must not describe it as a current exchange rate. Refunds retain their original currency and connection to the initial transaction.
Acceptance check
Filter by market and export a row. Its original amount, transformation and result should remain visible. Accept the report when subtotals, dates and refunds can be explained without hidden rules. If a rate is missing, mark the value pending rather than mixing original and converted amounts.
Key takeaways
- Consolidation requires traceability of the currency, reporting date and transformation rule for every amount.