How to get a detailed Sales Tax report for your Shopify store

Step-by-step description of how to get a Tax report in the Shopify

Install App User Guide
search

What is a tax report

Tax Report implies a document made by lawful subjects that characterizes their income taxes recorded in accordance with regulations. This report can be presented in electronic or a hard copy.

Report on taxes is generally identified with your business tasks, clients, and the resources your business administers.

As an owner of online business endeavor, you may be legally required to charge additional sum on every deal in your shop to cover tax expenses.

Depending on the legal requirements in specific region, you may have an obligation to prepare on timely basis a report on those taxes and dispatch those expenses to your authoritative administration.

Typically the tax report on sales incorporates all financial exchanges in the store during the predefined time frame. It's a nonexclusive report so it may contain data that isn't required for the tax return.

The report utilizes the time frame that is set for tax dispatching in your local area. Usually any tax reporting tool allows to see not only the current data on taxes, but you can also change the dates to see taxes on deals for different periods. Run the tax report generation to assemble data for documenting your business taxes and providing this data to the authorities.

The report on sales tax may typically include two main sections. One it the summary on sales tax, and the other is the Sales Tax Audit report.

The Sales Tax Summary shows a rundown of taxed deals in your store. They can be coordinated by tax rate, or type.

The Sales Tax Audit shows a rundown on your business tax exchanges for the time frame designated to claim tax return. The report utilizes the tax settings and tax rates of your business that were applied to taxes for the specified period.

Since taxes in the tax report are related to purchases and product returns, taxes can be depicted as a negative number. Tax value will be a positive number for any deal on the specified date that a customer made his order. It will be presented as a negative number when the purchased product was returned and the deal was refunded by the store.

Shopify does not file taxes for you

Shopify provides tax reports, however this ecommerce platform does not document or dispatch your tax report to the corresponding authorities. You may have to enlist your business with your government or tax authority to deal with your business taxes.

The tax estimations and reports that Shopify gives to a store in the admin panel should assist with keeping things on taxes simpler when it's time to put your tax assessments on official record.

Sales tax report on Shopify

Despite the fact that tax laws and tax guidelines are complicated and can change frequently, you can configure your Shopify sales tax report generating tool to naturally deal with many basic estimations on taxes. You can likewise set up custom reports on taxes to address extraordinary tax assessment laws and circumstances.

To get a Shopify Tax Report, you need to go to Analytics > Reports in the admin panel of your Shopify store and select Taxes in the Finance section.

demo

Tax report from Shopify depicts the statistics on deals and corresponding taxes that were applied to those deals in the chosen time period. Each column of the Sales Tax report Shopify provides shows a type of the tax. For example, it can be a local tax. The Shopify report for tax also shows its rate, and the aggregated sum of expense that was charged during this time period.

Report for sales tax Shopify provides can be viewed as a total for the store and by individual sales channels, like an online store, Facebook sales channel, Shopify point of sale, etc. Additionally you are free to choose the date range for tax report generation.

You can select one of the predefined date range values, for example last 90 days, month to date, year to date, quarter. Alternatively, you can choose individual time range.

Since taxes are region dependent, the tax report shopify provides selects the nation and locale dependent on the final location of the purchases. So it may show objective data in any event, even for cases of sales to locations that charge sales tax based on origin.

The final destination for every purchase is chosen based on its specified shipping address. In case it is not set up, the billing address in used for the purpose of determining the region. When both shipping and billing addresses are not available Shopify uses point of sale address to determine tax rate.

Basic tax configuration in Shopify

Online store owners should start configuring taxes in their stores by setting up the list of countries they ship products to. This is done by using the shipping zones functionality.

In your Shopify admin panel locate the Settings section and open the Shipping and delivery page. On this page create a new shipping zone, which is a country that you need to configure taxes for.

Return to the Settings page and locate Taxes section.

demo

In the Tax Regions section locate the country you need to configure tax rates. Click Manage button to open the tax configuration page. On this page specify the base tax rate and the tax override. The latter is customized tax rate that can be used for specific product collections to override base tax rate.

demo Taxation peculiarities in countries

Such countries as US, Canada, European Union, United Kingdom, Norway, Switzerland, Australia, New Zealand use taxes based on the registration. At that point, enter into Shopify the duty enrollments to gather taxes in your store.

For countries that use taxes based on location, you may use the default Shopify values or set the rates of specific country, or its region.

Keep in mind that some regions, like European Union, require taxation of digital products. Such items are taxed regardless of the seller location.

Other regions, like United Kingdom, require that prices displayed on its frontend included taxes. To configure your Shopify in that way in the admin panel of your store got to Settings > Taxes and in the section Tax calculations activate the option All prices include tax.

demo

To use the local tax rate of the country your customer is located at, you can use the option Include or exclude tax based on your customer's country.

Additionally your store may be required to charge taxes on shipping. For stores that operate in Canada, US, EU, UK, Australia, New Zealand the tax on shipping is calculated automatically. Stores that operate outside those countries in this case should activate the Charge tax on shipping rates option.

Learn more on taxes peculiarities in specific countries on the Shopify help page on taxes.

Tax report in Advanced Reports app

Shopify presents very concise and general tax information. Therefore, if you need more accurate reports, then you can get them using our Advanced Reports app. You can also get faster access to tax reports with our app. Simply pin it to the reporting dashboard.

In addition to the general tax report, similar to that of the Shopify, we offer more detailed reports, such as:

  • State / Provincial Tax, in which the report is based on the State / Province of the recipient
  • demo
  • Tax Per Country - similar to the previous report, but instead of the State / Province of the recipient, the Country receives the report.
  • demo
  • Tax details. in this report, each sold variant is presented in a separate row. This way you can see absolutely all sales that are taxable. Use filters by the variant value or any other value in the data grid to reduce the number of displayed data entries.
  • demo

Tax Collected (Monthly) report is similar to the default Shopify tax report. It provides data on the orders and their taxes. However, in comparison to the default Shopify reporting functionality, our app provides more flexibility with filters and ability to edit data columns.

Advanced Reports app also provides extended functionality on report export. You can export data as Microsoft Excel (.xlsx), PDF document (.pdf), web page (.html), comma-separated values (.csv). Export to Google Sheets is also supported.

Data visualization is also enhanced in Advanced Reports app when creating Shopify tax report. You can build graphics in the form of line chart, bar, area, column, pie, scalar. Add several data columns as Y-axis to make the graphic visualization more informative.

demo

In addition to the preinstalled reports, you can also easily create custom reports tailored custom requirements. For example, show detailed taxes but with a filter for a specific state. Or exclude unnecessary countries from the report.

Read more on how to create custom reports, manage filters, add data columns in Advanced Reports on the help page of this app.