Skip to main content

How do I use the Sales by Location report?

Become an expert on the Sales by Location report!

Helen Kang avatar
Written by Helen Kang
Updated over a week ago

The Sales by Location report surfaces a summary of all orders processed in Mariana Tek by location. The report is available in

  • Local Time

  • UTC

This report is useful for:

  • Pulling up calculations for sales by location without having to export the Orders report and filtering it by location in Excel

Pulling up the Report

  1. Navigate to Reports from the left panel > Sales > Sales by Location - Local Time > View.

    Image 2023-07-26 at 10.40.35 AM

  2. Specify the time frame from the date picker.

The populated data is dependent on the Transaction Date in UTC or Local Time for a specified time frame, not the Order Date.

Apply any additional filters.

Understanding the Report

The Sales by Location:

  1. Location

  2. Collected Subtotal: Only for completed transactions. This value will reflect the sum of the Line Subtotals (column 28) with a "completed" Line Status (column 24) in the Orders report for a specific location.

  3. Collected Tax: This value will reflect the sum of the Line Taxes (column 30) with a "completed" Line Status (column 24) in the Orders report for a specific location.

  4. Sold Quantity: This value will reflect the sum of the Line Quantity (column 27) in the Orders report for a specific location.

  5. Collected Total

  6. Refunded Subtotal: This value will reflect the sum of the subtotals with a "refunded" Line Status (column 24) in the Orders report.

  7. Refunded Tax: This value will reflect the sum of the refunded tax with a "refunded" Line Status (column 24) in the Orders report.

  8. Refunded Quantity: The number of refunded products.

  9. Refunded Total

  10. Location Subtotal: Collected Subtotal + Refunded Subtotal

  11. Location Tax: Collected tax + Refunded Tax

  12. Total Quantity: Sold Quantity + Refunded Quantity

  13. Currency

  14. Location Total: Refunded Total + Collected Total

Zero-dollar transactions are included in the report.

Did this answer your question?