OVERVIEW

This article describes the basics behind the reconciliation process that merchants must follow to make their Shopify reporting accurate. Merchants will learn:

• What reconciliation means for Shopify accounting.

• Why merchants need to reconcile their accounts.

• Which factors play into reconciliation.

• How to complete the reconciliation process.

Important:

• Loop highly suggests reviewing the basic and then the advanced exchange accounting articles before continuing; these articles give context for why reconciliation is necessary.

• This article is specific to Shopify merchants and merchants using Shopify as a source of truth for accounting.

For Loop merchants, reconciliation refers to identifying and resolving discrepancies in the Discounts, Returns, and Net Sales columns within Shopify's sales reports. This process includes the use of the Loop Sales Adjustment report to offset those discrepancies.

Shopify's lack of native support for exchanges leads to accounting discrepancies that occur when:

• Shopify makes order adjustments for returns without refunds (exchanges and store credit returns).

• The Loop Discount is applied to exchange orders.

Therefore, financial reconciliation is necessary to arrive at accurate sales and accounting figures.

Note: Merchants that rely on a third-party finance tool for accounting (rather than Shopify) may not reconcile their accounts exactly like Loop recommends. However, Loop still encourages merchants to learn how Shopify and Loop interact regarding exchanges and store credit returns; this understanding can help merchants ensure that their third-party finance tools are accurate.

To reconcile their accounts, merchants can use Loop's Sales Adjustment report, which contains three values: discounts, returns, and net sales. By adding these adjustments to the corresponding values in Shopify's sales reports, merchants can resolve discrepancies and get accurate sales information.

The instructions below detail how to complete reconciliation for Shopify sales reports.

Important: Reporting information cannot be changed within Shopify. Therefore, reconciliation must happen outside of Shopify (in Excel or a similar platform).

To export the Shopify sales report:

1. In Shopify, go to Analytics > Reports.

   

2. Select the report being reconciled. Loop recommends the "Sales by channel" report, but merchants can use any report with (or add to a report) the following fields:

   • Adjustment

   • Discounts

   • Gross sales

   • Net sales

   • Returns

   • Sale kind

   • Tax

   • Total sales

Important:

• Adjustments must be in the report to yield accurate numbers. If the chosen report does not include adjustments, add them by clicking the Columns button.

• For order-specific reports, add "Order name" by clicking the Columns button.

3. Select the dates to the range needed for account reconciliation, then click Apply.

   

4. If using the "Sales by channel" report, please include all active sales channels aside from Draft Orders.

   

5. After setting all columns, dates, and other parameters, click Export in the top right corner. Loop recommends exporting the full report.

   

To export the Loop Sales Adjustment report:

1. In the Loop admin, go to Analytics > Reports > Sales Adjustment report.

   

2. Set the Data Type field to Returns Processed and the Timeframe field to whatever range is needed for account reconciliation. The dates should match the date range set for the Shopify sales report.

   

3. In the top right corner of the report table, download the report as a CSV file.

   

   Tip: If experiencing issues with exporting, please follow the instructions in the Loop Reports article.

Note: Merchants can review the impacts of individual orders (returned orders or Loop-generated exchange orders) with this report, but the most important part of the report for account reconciliation is the top line.

To reconcile the Loop and Shopify reports:

1. Open a new sheet in Excel or a similar platform. This example uses Google Sheets.

2. Import the Shopify sales report downloaded in the previous steps.

   

   

3. Open the Loop Sales Adjustment report outside of the spreadsheet and copy the totaled figures.

4. In the spreadsheet, paste the totaled figures from Loop's Sales Adjustment report under the corresponding columns from the Shopify report.

   

   Note: The formatting on Loop's example was done for clarity. Merchants can format their reconciliation spreadsheets as needed.

5. Total the Discounts, Returns, and Net Sales columns using both Loop's and Shopify's values. 

   1. The Discounts column will become more positive (this is when the Loop Discount is turned on).

   2. The Returns column will become more negative.

   3. Net Sales will become more positive by the amount on the adjustment report but will net out to become more negative due to the changes in the Discounts and Returns columns.

Good job! Having reconciled the discrepancies caused by Loop's exchange process, the Shopify sales report should now be accurate.

This section provides a more in-depth analysis of what each value represents in the reconciliation report. Totals for the Discounts, Returns, and Net Sales columns are bolded and shaded for clarity.

Reconciling on an aggregate level is the most helpful way to use the Loop Sales Adjustment report. It helps merchants understand their total discounts, returns, and net sales figures for a given date range.

The image below shows a finished reconciliation of Loop's and Shopify's discounts, returns, and net sales numbers. The Loop Discount is configured to be on.

The report example above represents the following values by row:

• Row two shows the aggregate data for the date range set on Shopify's sales report.

• Row three shows the aggregate gross sales, discounts, returns, and net sales data from Loop's Sales Adjustment report for the same date range. The latter three are the most important.

• Row four shows the reconciled discounts, returns, and net sales numbers from adding Shopify's totals to Loop's totals.

The reconciled numbers in row four show the following:

This sub-section explains and instructs how to reconcile on a more granular level, helping merchants understand how the Loop Sales Adjustment report impacts specific transactions and orders.

The image below shows a finished reconciliation of Loop's and Shopify's discounts, returns, and net sales numbers:

The report example above represents the following values by row:

• Row two shows the values for the original order.

• Row three shows shipping costs associated with the order.

  Note: This parameter was not mentioned in earlier instructions but is important for some merchants' reporting and was therefore included to visualize here.

• Row four is the return row, representing the return itself.

• Row five is Shopify's positive return order adjustment, created when the item was marked returned.

• Row six contains values for the new exchange order. Its order name prefix shows it as an exchange.

  In this example, the merchant has the Loop Discount turned on. This is indicated by the exchange order's $148 discount (shown as -148), which brought the sale amount down to $0 for the exchange.

• Row seven shows the totals for Discounts, Returns, and Net Sales from the first five rows.

• Rows eight and nine are where the example merchant added Loop's Sales Adjustment report totals:

  • Row eight shows adjustments for the original order.

  • Row nine shows adjustments for the new exchange order.

• Row ten shows the reconciled numbers from adding Shopify's totals (row seven) to Loop's figures (rows eight and nine).

The reconciled numbers in row ten show the following:

Can I change the numbers directly in Shopify? At this time, merchants cannot change figures directly in Shopify. They must export the reports and reconcile them externally in Excel or a similar platform. Loop cannot edit the Shopify reports directly.

Which time zone does Loop reporting reflect? Loop reporting reflects GMT timezone.

Please contact support@loopreturns.com with additional questions.