- What is it?
- How do I access the report?
- What's in the report?
- How to reconcile Shopify's and Returnly's Reports
What is it?
Returnly allows your customers to exchange or repurchase new items when they decide to return something they originally bought. At the time of exchange or repurchase, a completely new order is created on your Store's eCommerce platform at full value prior to receiving the original item and processing its return.
The Gross-to-Net Sales report is a Returnly generated report that helps you financially reconcile your existing Sales reports in Shopify, and thus, arrive at accurate sales numbers.
The video below explains the contents of the report, as well as how to use it.
How Do I Access the Reports?
When logged into your Returnly instance, click on Reports from the lefthand menu. Under Reconciliation, you can click on the Gross-to-Net Sales link.
You'll then see a pop-up that allows you to select your timing parameters.
You can use any of the pre-sets from the first drop-down menu, or select the specific time window yourself, along with your timezone.
You'll get a confirmation message that the report is being generated and sent to your email address. Remember, the report comes in a .csv (comma separated values).
What's in the report?
Each record in this report is a sales adjusting entry. These entries are used in combination with Shopify's Sales report to net out your Shopify sales, accomplishing accurate sales numbers.
Each adjusting entry in the report contains the following fields:
|Sale ID||Empty. Used for compatibility with Shopify’s Sales report to facilitate manual reconciliation.|
|Settlement Date||Date on which the settlement of the return corresponding to a repurchase or an exchange occurs.|
|Order ID||Platform order ID from the original order where the repurchase or exchange comes from.|
|Order||Platform order number from the original order where the repurchase or exchange comes from.|
|Product||“N/A” as the entry corresponds to an adjustment to net out sales and not to a particular product.|
|Gross sales||Always 0, as the entry corresponds to an adjustment to net out sales.|
|Discounts||Always 0, as the entry corresponds to an adjustment to net out sales.|
|Returns||Credit Spent amount by the customer on the Repurchase / Exchange tied to the original order.|
|Net Sales||Credit Spent amount on the Repurchase / Exchange tied to the original order|
|Taxes||Always 0, as the entry corresponds to an adjustment to net out sales.|
|Shipping||Always 0, as the entry corresponds to an adjustment to net out sales.|
|Total Sales||Credit Spent amount on the Repurchase / Exchange tied to the original order.|
How to Reconcile Shopify's and Returnly's Reports
Returnly’s Gross-to-Net Sales report is built with a similar column structure as Shopify's Total Sales report in order to append both reports easily and quickly. The reconciliation process between Shopify's and Returnly's reports consists of three main portions:
- Download Returnly's Gross-to-Net Sales report (shown above)
- Download Shopify’s Total Sales report.
- On your Shopify dashboard, on the left-hand-side menu, select Analytics.
- Under Analytics, select Reports.
- Navigate to Finances, and select Total Sales.
- On your Total Sales report, select the desired date range.
- Click Apply.
- You will then be presented with the following options: Current page and Full report; select the former, Current page. This is representative of the format of the report and not the data included on the page. The report will download all the data belonging to the selected date range.
- Click Export.
- Note: The Total Sales report will be exported as a CSV file.
- For more on the data included in this Sales reporting, see Shopify's glossary of terms.
- Append Returnly's Gross-to-Net Sales report to Shopify’s Total Sales report, and sum the columns from Gross sales to Total sales.
The Total Sales field will add up to your Total Sales, thus effectively reconciling for exchanges and repurchases, while also adjusting for Discounts, Returns, Net Sales, Taxes and Shipping.
For more information on reconciliation and best practices, see Returnly's Return Reconciliation Guide.