Premium Report - Realized Gains and Losses

Realized Gains and Losses 

In currency conversion terms, a Realized Gain/Loss occurs when the exchange rate has changed between the time of sale and when the payment is collected.

If the exchange rate becomes more favorable between the two, you have a realized gain. 

In contrast, if the exchange rate becomes less favorable between the two, you have a realized loss.

For many merchants, the timing between the sale and payment is usually near-instantaneous.

But for merchants who sell internationally and defer payments in any way (especially with pre-orders/downpayments), Realized Gains and Losses can have a noticeable impact on one's monthly totals. 

As a Premium Report, this is available on all Paid Plans of Report Toaster. If you aren't signed up, follow these steps to upgrade your account. 

This report lets you see any Realized Gains and losses for orders involving payments using a different currency than the one for your store.

These are vital if you're looking to reconcile the amounts received in payments each month vs. the amounts on the original sales: 

Here are a few terms to be familiar with to understand the Realized Gains and Losses report, numbered in the screenshots (above):

1.) Realized Gains/Losses not equal to 0. This metrics filter ensures that only orders with a Realized Gain/Loss (below) appear in the report. 

2.) Currency: The currency for your store.

3.) Checkout currency: The currency the customer paid with at the checkout. 

For example, if my store was set to USD but the customer paid in GBP, then USD would appear in Currency and GBP in Checkout Currency

4.) Total Sales plus Duties: The Total Sales for that order, including discounts, returns, taxes, shipping and duties. 

Note - Any 'additional fees' your store applies to an order will not be included in this figure.

For example, if order HC1962730 added up to a total of $6.72, then that's the value that would appear in the column. 

5.) Paid Amount: The amount the customer paid for that order. 

For example, on order HC1962730, the customer paid $6.43.

6.) Realized Gains/Losses: The difference between the Total Sales plus Duties and the Paid Amount. Note that this value only populates if:

1. The Currency and Checkout currency are different. 
   
2. The order has actually been paid (Paid at, is set)
   
3. The difference is not equal to 0.00 (in conjunction with the metrics filter, this ensures you don't get orders with no actual difference showing up in the report)

For example, on order HC1962730, there is a difference of $0.29 between the order total and what the customer actually paid later that evening.  

Like all Report Toaster reports, these reports are fully customizable - so you can adjust the date range, add/remove columns, introduce a filter, or change the sort to suit your individual needs. See our basic guides here for more info.

For other premium reports you can add to your account, check out our other article guides here. 

• Related Articles

• Whats New? - July 2025

  Continuing our way into July, it's time to take a look at a few new reports we've added to Report Toaster. Let's take a look! Month-end Inventory Snapshot While we've had Inventory History reports for a while now in Report Toaster, a few merchants ...

• Premium Report - Return Rate Reports

  Order/Product/Product Variant/Vendor Return Rate Return Rate Reports are used to compare how much of something has been sold vs how much has been returned. These reports all follow a very similar format - tracking your Return Rate on a per-order, ...

• Premium Report - Sell Through Reports

  Sell Through Rate (By Product, By Variant, By Vendor) Sell Through Reports are used to compare how much of something has been sold vs how much you have in stock. These reports all follow a very similar format - tracking your Sell Through Rate on a ...

• Premium Report - Stock Intake & Sales Velocity

  Stock Intake & Sales Velocity This report is for merchants who are looking to measure their stock vs. sales in any given month. Using this report, you can see exactly how much you sold of each item, how much you stocked, key metrics like Resale Ratio ...

• Premium Report - ABC Inventory

  ABC Inventory Much like the Shopify ABC Inventory Analysis report, this report asigns a letter grade (A, B, or C) to each inventory item based on its sales performance. For those of you who aren't familiar with Shopify's ABC grade for Inventory, the ...