Skip to main content
All CollectionsMortarReports
Where should I look for Canadian tax reporting?
Where should I look for Canadian tax reporting?

Orders uploaded to Lightspeed R-Series with a combined sales tax rate. To report separately on GST/ PST, you must use Shopify's Tax report.

Updated over a month ago

Overview

If you are collecting GST and PST and need to report on these separately, it is not possible at this time to split these out on orders uploaded to your Lightspeed Retail R-Series account. The best resource for accurately viewing and reporting on your taxes will be in the tax reports available in Shopify.

Shopify

How do I find the Shopify taxes report?

In your Shopify admin account navigate to Analytics > Reports > then scroll till you find the report title Taxes

Example Shopify Tax Report

In this example you can see the different sales tax rates and amount collected for each province.

Lightspeed

Reports in Lightspeed

Because tax rates are combined into one tax rate for online orders uploaded to Lightspeed, to prevent overstating your GST tax collected from in store transactions, you should to subtract online sales for tax reporting. This applies even if your Lightspeed R-Series account is configured to report GST and PST separately for in store transactions.

Lightspeed Sales Report - All Transactions

GST and PST are separated for in store transactions.

Lightspeed Sales Report - Shopify Transactions

GST and PST are combined in the GST tax total for online transactions.

How do I remove Shopify transactions from reports in Lightspeed?

This will vary depending on the complexity of your setup and the report you are viewing in Lightspeed.

  1. Choose the report you want to review.

  2. Filter the report using either:

    1. The Employee designated in your Mortar settings for online orders.

    2. or Reference# using the word "Shopify"

  3. Make note of the total GST or sales Totals

  4. Subtract this value from the same report without filtering for online orders.

If you have any questions about filtering reports, we are happy to help. Please contact our Mortar support team via chat or [email protected].


Additional Links

Did this answer your question?