How to get a detailed Sales Tax report from Shopify

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

What is a tax report

Tax Report implies a document made by lawful subjects that characterizes their income taxes recorded in accordance with regulations.

Revealing of the charge data is an ordinarily prerequisite for associations to provide information on all sorts of monetary exchanges made throughout their direct or related business. These exchanges can, for instance, be wage and non-wage installments.

This documentary space of tax announcing and obligation for it is persistently developing, conveying countless administrative necessities set up by the public authority of the country the store works in.

There are presently a few data reports on taxes needed by the public authority, and these documents ought to be given a cautious disposition by the store.

These documents have to have the option to pass the cross-checking measure the duty specialists of the state may organize to confirm the exactness of announced assessment forms recorded by the business.

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

As an owner of a business endeavor that works online, a legal requirement may be existing to charge an additional sums on every deal conducted in the shop to cover tax expenses.

Depending on the legal requirements in a specific region, a store may have an obligation to prepare on a timely basis a report on those taxes and dispatch those expenses to the corresponding 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 you to see not only the current data on taxes but 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 is the summary of 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 the tax rate or type.

The Sales Tax Audit shows a rundown on your business tax exchanges for the time frame designated to claim tax returns. 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, and a quarter. Alternatively, you can choose an 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 is used for the purpose of determining the region. When both shipping and billing addresses are not available Shopify uses point-of-sale addresses to determine the tax rates.

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

    OrdersCountryOrdersProvinceOrdersNumber of ordersOrder ItemsTotal QuantityOrdersNet amountOrder Item TaxesTitleOrder Item TaxesTotal Tax Amount
    United StatesAlabama23$260.00AL STATE TAX$0.00
    United StatesAlaska14$131.75AK STATE TAX$0.00
    United StatesArizona1574$3,964.98AZ CITY TAX$72.18
    United StatesArizona1574$3,964.98AZ COUNTY TAX$0.00
    United StatesArizona1574$3,964.98AZ STATE TAX$207.94
    United StatesArkansas415$711.23AR STATE TAX$0.00
    United StatesCalifornia1340$2,375.58ALAMEDA COUNTY DISTRICT TAX SP$73.12
    United StatesCalifornia82273$13,617.48CA CITY TAX$94.41
    United StatesCalifornia303954$48,911.68CA COUNTY TAX$116.10
    United StatesCalifornia1654$2,693.69CA SPECIAL TAX$25.72
    United StatesCalifornia303954$48,911.68CA STATE TAX$2,769.84
    United StatesCalifornia615$654.81CONTRA COSTA COUNTY DISTRICT TAX SP$9.49
    United StatesCalifornia26$430.68FRESNO COUNTY DISTRICT TAX SP$2.83
    United StatesCalifornia24$0.00HUMBOLDT COUNTY DISTRICT TAX SP$1.02
    United StatesCalifornia13$98.37INYO COUNTY DISTRICT TAX SP$0.53
    United StatesCalifornia287900$46,217.99LOS ANGELES CO LOCAL TAX SL$435.94
    United StatesCalifornia123368$19,515.76LOS ANGELES COUNTY DISTRICT TAX SP$407.62
    United StatesCalifornia935$2,088.22MARIN COUNTY DISTRICT TAX SP$14.18
    United StatesCalifornia320$1,259.83MONTEREY COUNTY DISTRICT TAX SP$5.76
    United StatesCalifornia22$137.92NAPA COUNTY DISTRICT TAX SP$1.06
    United StatesCalifornia13$106.88NEVADA COUNTY DISTRICT TAX SP$0.20
    United StatesCalifornia2155$2,581.68ORANGE COUNTY DISTRICT TAX SP$13.01
    United StatesCalifornia229$451.13RIVERSIDE COUNTY DISTRICT TAX SP$2.06
    United StatesCalifornia612$429.50SACRAMENTO COUNTY DISTRICT TAX SP$2.04
    United StatesCalifornia14$244.77SAN BERNARDINO COUNTY DISTRICT TAX SP$0.52
    United StatesCalifornia3091$5,030.32SAN DIEGO COUNTY DISTRICT TAX SP$23.04
    United StatesCalifornia30104$5,709.11SAN FRANCISCO COUNTY DISTRICT TAX SP$68.95
    United StatesCalifornia821$1,021.09SAN MATEO COUNTY DISTRICT TAX SP$20.54
    United StatesCalifornia518$700.14SANTA BARBARA COUNTY DISTRICT TAX SP$2.22
    United StatesCalifornia1343$2,335.36SANTA CLARA COUNTY DISTRICT TAX SP$46.04
    United StatesCalifornia38$330.76SANTA CRUZ COUNTY DISTRICT TAX SP$4.49
    .....................
    10083156$165,009.88$9,058.23
    report generated with mipler.com
  • Tax Per Country - similar to the previous report, but instead of the State / Province of the recipient, the Country receives the report.

    OrdersCountryOrdersNumber of ordersOrder ItemsTotal QuantityOrdersNet amountOrder Item TaxesTotal Tax Amount
    United Kingdom51213€4,577.58€0.00
    Belgium1982€1,086.70€89.04
    Netherlands1145€717.45€65.59
    Germany1165€982.28€76.58
    Austria436€568.65€51.31
    Sweden14€89.46€4.07
    United States17€159.05€0.00
    Denmark19€191.91€9.94
    France12€41.48€1.81
    Italy19€174.92€11.43
    Poland12€63.98€2.71
    102474€8,653.46€312.48
    report generated with mipler.com
  • 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.

    OrdersNameOrdersProcessed AtOrder ItemsSKUOrder ItemsProduct NameOrder ItemsVariant NameOrder ItemsTotal QuantityOrder ItemsTotal PriceOrder Item TaxesTitleOrder Item TaxesTotal Tax Amount
    #1602May 10, 2022 12:29 AMLMXSStretch ShortLIME / XS1$48.00CA COUNTY TAX$0.12
    #1602May 10, 2022 12:29 AMLMXSStretch ShortLIME / XS1$48.00CA STATE TAX$2.88
    #1602May 10, 2022 12:29 AMLMXSStretch ShortLIME / XS1$48.00LOS ANGELES CO LOCAL TAX SL$0.48
    #1602May 10, 2022 12:29 AMLMXSStretch ShortLIME / XS1$48.00LOS ANGELES COUNTY DISTRICT TAX SP$1.08
    #1602May 10, 2022 12:29 AMGRNXSStretch ShortGREEN / XS1$48.00CA COUNTY TAX$0.12
    #1602May 10, 2022 12:29 AMGRNXSStretch ShortGREEN / XS1$48.00CA STATE TAX$2.88
    #1602May 10, 2022 12:29 AMGRNXSStretch ShortGREEN / XS1$48.00LOS ANGELES CO LOCAL TAX SL$0.48
    #1602May 10, 2022 12:29 AMGRNXSStretch ShortGREEN / XS1$48.00LOS ANGELES COUNTY DISTRICT TAX SP$1.08
    #1120May 10, 2022 7:22 AMRSSStretch ShortROSE / S1$48.00AZ CITY TAX$0.86
    #1120May 10, 2022 7:22 AMRSSStretch ShortROSE / S1$48.00AZ COUNTY TAX$0.00
    #1120May 10, 2022 7:22 AMRSSStretch ShortROSE / S1$48.00AZ STATE TAX$2.69
    #1120May 10, 2022 7:22 AMBLSStretch ShortBLACK / S1$48.00AZ CITY TAX$0.86
    #1120May 10, 2022 7:22 AMBLSStretch ShortBLACK / S1$48.00AZ COUNTY TAX$0.00
    #1120May 10, 2022 7:22 AMBLSStretch ShortBLACK / S1$48.00AZ STATE TAX$2.69
    #1126May 10, 2022 8:33 AMBLKXSStretch ShortBLACK / XS1$48.00NY COUNTY TAX$2.04
    #1126May 10, 2022 8:33 AMBLKXSStretch ShortBLACK / XS1$48.00NY SPECIAL TAX$0.18
    #1126May 10, 2022 8:33 AMBLKXSStretch ShortBLACK / XS1$48.00NY STATE TAX$0.00
    #1631May 12, 2022 09:10 AMBLLStretch ShortBLUE / L1$48.00CA CITY TAX$0.43
    #1631May 12, 2022 09:10 AMBLLStretch ShortBLUE / L1$48.00CA COUNTY TAX$0.11
    #1631May 12, 2022 09:10 AMBLLStretch ShortBLUE / L1$48.00CA STATE TAX$2.59
    #1631May 12, 2022 09:10 AMBLLStretch ShortBLUE / L1$48.00LOS ANGELES CO LOCAL TAX SL$0.43
    #1631May 12, 2022 09:10 AMBLLStretch ShortBLUE / L1$48.00LOS ANGELES COUNTY DISTRICT TAX SP$0.97
    #12344May 10, 2022 11:37 AMLMSStretch ShortLIME / S1$48.00CA CITY TAX$0.48
    #12344May 10, 2022 11:37 AMLMSStretch ShortLIME / S1$48.00CA COUNTY TAX$0.12
    #12344May 10, 2022 11:37 AMLMSStretch ShortLIME / S1$48.00CA STATE TAX$2.88
    #12344May 10, 2022 11:37 AMLMSStretch ShortLIME / S1$48.00LOS ANGELES CO LOCAL TAX SL$0.48
    #12344May 10, 2022 11:37 AMLMSStretch ShortLIME / S1$48.00ORANGE COUNTY DISTRICT TAX SP$0.24
    #1634May 10, 2022 11:53 AMHYDMStretch ShortBLUE / M1$48.00OH COUNTY TAX$0.84
    #1634May 10, 2022 11:53 AMHYDMStretch ShortBLUE / M1$48.00OH STATE TAX$2.35
    #1639May 10, 2022 12:25 PMBLMStretch ShortBLACK / M1$48.00MI STATE TAX$2.30
    #1642May 10, 2022 12:38 PMBLMStretch ShortBLACK / M1$48.00MI STATE TAX$2.88
    ...........................
    30$1,440.00$81.82
    report generated with mipler.com

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.

Get rid of boring, tedious tasks.

Get full access to platform within a 14-day free trial.
No credit card required.

Start Free Trial Book 15 minute demo →