AI Sales Reports: Keep Currency and Conversion Rules Visible

An AI-generated sales summary announces that the shop took 200 yesterday. The underlying export contains a £100 purchase and a €100 purchase. Adding the two numeric fields was easy. Giving the result a meaningful currency requires another decision.

For an independent business selling across borders, a report needs to explain both the original amounts and any conversion applied to them. That becomes especially useful when a summary compares periods, describes growth or attempts to explain a bank deposit. Those are different reporting questions, even when they begin with the same transactions.

Keep the amount and currency together

Imagine a fictional illustration shop with two completed purchases: order P1 for GBP 100 and order P2 for EUR 100. In this simplified example, the amounts are the recorded gross charges. Fees, refunds and taxes are excluded from the calculation. No payment processor or live shop was tested.

A report preserving the original currencies can state GBP 100 and EUR 100 separately. It cannot label their unconverted numeric sum as GBP 200 or EUR 200. To produce a combined GBP comparison, the owner must specify a conversion rule.

Suppose the analytical exercise uses an invented rate of GBP 0.85 per EUR 1. The euro amount becomes GBP 85, and the combined amount becomes GBP 185. The arithmetic was checked for this article. This is a hypothetical converted comparison, not an actual settlement amount, a current exchange-rate quote or a prescribed accounting treatment.

Keep the rate’s direction visible. Multiplying EUR 100 by GBP 0.85 per euro gives GBP 85. A column labelled only rate leaves the reviewer to guess which currency is the starting unit. A useful report names the original currency, destination currency and rate convention.

Know which stage the currency describes

The distinction also appears in payment-provider terminology. Stripe’s supported-currencies documentation distinguishes the currency of the customer’s payment method, the charge or presentment currency, and the settlement currency accepted by the destination account. It describes conversion when charge and settlement currencies differ.

That documentation establishes why a charge and a settlement can involve different currencies. It does not supply the actual conversion or settlement record for the fictional shop. A summary prepared from original charges alone should not claim that it has reconciled the amount received in the bank.

For a real reconciliation, start with the relevant transaction and settlement records and explain the scope of the comparison. If information about deductions or adjustments is missing, name that gap. Do not make an invented balancing item merely to bring the reported total into line with a deposit.

A currency movement can change the headline

Now consider another hypothetical comparison. The shop records EUR 100 of gross charges in Period A and EUR 100 in Period B. The original-currency amounts are unchanged. For this illustration, apply GBP 0.80 per euro to A and GBP 0.90 per euro to B.

The converted figures are GBP 80 and GBP 90. Their percentage increase is 12.5%: the £10 difference divided by the £80 starting value. That calculation does not show that euro-denominated sales increased. In this constructed example, the entire difference comes from the conversion rates chosen.

A precise commentary could say that gross charges remained EUR 100 in each period, while the GBP translation rose from £80 to £90 under the stated rates. It should not turn that result into a claim about stronger customer demand. No additional purchases or higher euro charges have been supplied in the example.

For a separate analytical view, translating both periods at the same invented rate of GBP 0.80 gives £80 in each. This holds the conversion rate fixed for that comparison. It does not replace the original transaction records or determine the treatment required for financial statements. Name it as an analytical comparison and keep its assumptions attached.

A reference rate has a stated purpose

The European Central Bank’s euro reference-rate page says its rates are published for information and strongly discourages their use for transaction purposes. A public reference rate should therefore not be presented as evidence of the rate a particular payment actually received.

For the fictional report, distinguish a selected reference used for analysis from a rate recorded in a transaction or settlement. Record the source and relevant date alongside the chosen method. If an assistant supplies a rate without a traceable source, the reviewer still lacks that part of the calculation.

This article deliberately uses invented rates to demonstrate the arithmetic. It offers no forecast, conversion recommendation or assessment of a payment provider’s pricing. The business question is whether the summary describes the data and method it actually used.

Give the assistant a bounded reporting brief

An assistant could help draft a commentary after you define the reporting currency, the amount being measured and the conversion method. Ask it to preserve original amounts and currencies, identify missing information and distinguish calculated comparisons from observed settlement records. This is a proposed workflow, not a tested capability claim.

• State whether the task concerns original charges, an analytical comparison or settlement reconciliation.
• Keep original currency and amount fields beside any converted values.
• Name the conversion source, date or period, direction and method.
• Show a small worked calculation before accepting a combined total.
• Require commentary to distinguish original-currency changes from translation changes.

The same discipline applies to other sales fields. MaryChuks.com’s guide to reversals and physical returns explains why a monetary adjustment does not by itself establish a movement of goods. Here, a converted amount does not by itself establish the money received in a destination account.

Make the headline reproducible

For the fictional two-order shop, a reviewable summary retains P1 and P2, lists their original currencies, states the invented conversion rate and shows how the £185 comparison was calculated. Another reviewer can reproduce that number and understand its limits.

A polished narrative should come after those choices are visible. Keep the currency attached to every amount, explain which question the conversion answers and reserve claims about demand or settlement for evidence that supports them. The resulting report gives the owner a number they can interpret.

Sources

Primary documentation checked on 31 October 2026. These maintained pages do not supply an individual publication date asserted here. All shop records, periods and rates in the examples are hypothetical; arithmetic was checked locally.

• Stripe: Supported currencies — currency presentment and settlement.
• European Central Bank: Euro foreign exchange reference rates.