Shopify Sales Tax Report | How to Find and Understand It

Подписаться 18 тыс.

Просмотров 20 тыс.

50% 1

The Shopify sales tax report can be daunting.
In this video, we explain:
👉 Common Shopify sales tax questions
👉 Understanding the sales tax report
Shopify sellers will understand how to use the report to identify nexus and how much sales tax they owe.
◾◾◾◾◾◾◾
🔥 If you're interested in our SALES TAX SERVICES, click here to contact us: **
ledgergurus.co...
◾◾◾◾◾◾
⬇️ MORE STUFF YOU SHOULD CHECK OUT ⬇️
**SALES TAX COMPLIANCE PLAYLIST: **
• Sales Tax Compliance
** If you'd like to read the blog associated with this video, complete with detailed instructions and screenshots, click here: **
ledgergurus.co...
** For a complete sales tax guide to be compliant for your Shopify taxes, DOWNLOAD our "10 Steps to Ensure Sales Tax Doesn’t Burn Down Your Ecommerce Business": **
ledgergurus.co...
** For a clear idea of where you are in the process of sales tax compliance, take our SALES TAX QUIZ: **
ledgergurus.co...
** For information on our SALES TAX COURSES geared specifically to online sellers and accountants serving online sellers, click here: **
ledgergurus.th...
** RELATED RESOURCES **
** BLOG: Complete Guide to Sales Tax Nexus for eCommerce Sellers **
ledgergurus.co...
** BLOG: Why Online Retailers Need to Worry About Sales Tax **
ledgergurus.co...
** BLOG: Online Sales Tax | Aggressive States to be Aware of and Why" **
ledgergurus.co...
** If you're interested in our ECOMMERCE ACCOUNTING SERVICES, click here to contact us: **
ledgergurus.co...
◾◾◾◾◾◾◾
🧑‍💻 EMPLOYMENT OPPORTUNITIES:
We are always looking for awesome CPAs, accountants, and bookkeepers to join our team. If you're interested in working for LedgerGurus, check out our careers page:
ledgergurus.br...
◾◾◾◾◾◾
👋 SAY HI ON SOCIAL:
Website: ledgergurus.co...
Facebook: / ledgergurus
LinkedIn: / ledgergurus
Instagram: / ledgergurus
• Shopify Sales Tax Repo...
#shopifyonlinesalestax #ecommerceaccounting #ledgergurus

Опубликовано:

21 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 101

@DreamFirms 3 года назад

This would help a lot of people who's in the e-commerce business!

@patchyalater_2347 2 года назад

Super helpful! I just did my state taxes and used this video to get through the process.

@LedgerGurus 2 года назад

So glad it was helpful!

@12345678910979 3 года назад

Great video. Why don’t these website builders just add an option on the sales report tax to filter tax report by state and date? just automatically filter the report by each state with the date, and have the option to click on each states tax report. Would make life so much easier for businesses. It doesn’t have to be this hard for us. :-)

@LedgerGurus 3 года назад

That would certainly make it easier. We're hoping the process becomes more streamlined soon, too. The pivot table does help in the meantime, though.

@corvettestingray271 2 года назад

@@LedgerGurus Thank you SSM! Great point.

@LedgerGurus 3 года назад

Need help with your Shopify sales tax compliance? View our services and contact us here: ledgergurus.com/services/sales-tax/. Also, check out our sales tax course here - ledgergurus.com/sales-tax-course-updates.

@melissashan6986 3 года назад

Can you PLEASE upload how to add the discount into this report?

@LedgerGurus 3 года назад

@@melissashan6986 There’s a column that shows discount amount and discount code used on the Shopify report. Do you mind giving me more details on your questions?

@Alkonafter 2 года назад

Oh wow. I'm usually not living comments, but this is simply cool. Thank you

@dextercruz1560 6 месяцев назад

Awesome step by step guide!

@LedgerGurus 6 месяцев назад

Glad it was helpful!

@IntentionalMarriages 3 года назад

Thankfully, that is what I use our tax preparation folks to assist us with. You're a great resource! (new sub)

@LedgerGurus 3 года назад

Thanks for the sub! We at LedgerGurus are in the process of creating a course for online sellers to teach them how to register, file, and remit sales tax. We want to make sure that we are providing exactly what online sellers need and are looking for. Would you be interested in giving us a few minutes of your time so we can ask you some questions? If so, please click this link to schedule a time - calendly.com/kelleybirrell. Thank you!

@MrAffolder 2 года назад

Very well done video! Thank you for walking through building the excel file.

@LedgerGurus 2 года назад

Of course! We are so glad you found it helpful!

@corvettestingray271 2 года назад

Very good video, I like your videos they are so informative and easy to understand!

@LedgerGurus 2 года назад

Thank you so much for being here and supporting our channel!

@speedbag1 3 года назад

wow. so complicated. I think I need a drink. (great video!)

@LedgerGurus 3 года назад

LOL! Hope that helps calm the nerves!

@speedbag1 3 года назад

@@LedgerGurus ....in a perfect world it would. I can appreciate this is easy for you. But the sheer volume of data to try to keep up with if you actually get a bunch of sales all over the county could be daunting to the uninitiated. Cudo's to you for sorting out all this mess!

@LedgerGurus 3 года назад

@@speedbag1 Thanks. It's taken some time. That's why we're trying to make it easier for small businesses with our videos and our upcoming sales tax course.

@speedbag1 3 года назад

@@LedgerGurus ...You do an excellent job at it also!

@LedgerGurus 3 года назад

@@speedbag1 Thank you!!!

@mintgreen292 2 года назад

This video is amazing and so helpful. Thank you!!

@LedgerGurus 2 года назад

So glad to hear!

@eddiec2669 3 года назад

Thank you! Super helpful!

@LedgerGurus 3 года назад

Thank you for the feedback. I'm glad you liked it.

@eugene-shestakov 3 года назад

Hey, you're awesome! thanks so much, straight to the point amazing. I'd love to see an example of the refunds, that's an important step to proper sales tax calculation. I'm sure a ton of people would love to see an example of that as well, if you're up for it please make a video for us. lol

@LedgerGurus 3 года назад

Great idea! We'll put that in the queue. Thanks for the suggestion.

@eugene-shestakov 3 года назад

@@LedgerGurus Awesome, thanks!

@PacificMoldDesign 3 года назад

that gong woke me up :)

@LedgerGurus 3 года назад

LOL! Good! ;-)

@hamatimmanuel2464 Год назад

Thank you for posting this video. It's very helpful. Do you help setting up sales tax with companies that use QuickBooks Enterprise Desktop?

@LedgerGurus Год назад

We only work with companies using QuickBooks Online.

@andreweikenberry129 2 года назад

thank you

@Bitcoin_Shango 3 года назад

Thank you, very much.

@LedgerGurus 3 года назад

You are very welcome.

@sjawad7299 2 года назад

You missed the 2.6% + fee per transaction that Shopify charges . You would need to calculate that as well

@LedgerGurus 2 года назад

Good to know! Thank you!

@SkolVikings22 Год назад

Great video! One question, when filling out the sales tax report online, how do we find the "City" codes? For example, County = Almeda County, City = Almeda 967 , Almeda 928, Almeda 648? (many options to choose from in the drop down menu)

@LedgerGurus Год назад

I would check CDTFA’s website for the exact rate and it’ll tell you which city and special district maps.cdtfa.ca.gov/

@SkolVikings22 Год назад

@@LedgerGurus ty!

@christopherjames1177 3 года назад

If anyone is looking for the reporting app, try Report Pundit, which is one of the top-rated reporting & analytics apps in Shopify and it has all kinds of reports like sales, customer journey, PayPal, Shopify payout, inventory reports, etc. 14 days of free trial available.

@lixiaxu9137 2 года назад

For example if I live in New York, am I only need to turn on new your NY sales tax, do I only need to file NY sales tax? Although my goods sell to different states and countries?

@LedgerGurus 2 года назад

You only need to charge sales tax for orders going to NY customers. If you don't have nexus (physical or economic) in other states, you don't need to charge tax on products shipped to other states.

@stephaniecrocker2494 Год назад

since the date of this video, the reports on shopify don't seem to match what you're showing (maybe they do, i'm in a confusion spiral). i have a stupid question...i run the shopify sales report and add the shipping region. on the top, i get gross sales, discounts, returns, net sales, shipping, and taxes. i'm confused when the sales tax agencies ask for "gross sales" when I think you mentioned in this case, I'd want to use "net sales" (before taxes of course) (to omit pending orders, returns, etc.).

@LedgerGurus Год назад

We can give you more individual help specific to your store on a consulting call. Please feel free to schedule with us at ledgergurus.com/ecommerce-accounting-services/sales-tax/

@quranlistencollectrewards2492 2 года назад

Thank u 🙏🏻 every 4 month do u offer pay taxes to your clients ? I mean help business owners pay and understand taxes ? Then register states after 200 transaction?

@LedgerGurus 2 года назад

If you're interested in our services, you can fill in the contact us form here - ledgergurus.com/services/sales-tax/. We have other options there, as well, including our sales tax course to teach you how to do this yourself.

@lambshe Год назад

What about Canadian Taxes, since we have two. Provincial PST and Federal GST

@LedgerGurus Год назад

Sorry, we only work with US taxes.

@ahmaddaboul2681 2 года назад

Thanks for the awesome explanation, when you clicked on the returns report from the finance summary, does this include only shopify payment returns? Do you think Paypal returns/refunds are also synced to Finance summary returns report as well? or this return report on Finance summary is an estimate only, because as you see no order number or payment method there, just date wise report. thanks again

@LedgerGurus 2 года назад

All the payment processors that go through Shopify should be on the orders report.

@mizzstarr510 2 года назад

I live in California and have a Shopify site.. When do I have to worry about signing up for Sales Tax? This is so much.

@LedgerGurus 2 года назад

The first place you have to think about sales tax is in your home state. Because you have a physical presence, you are already responsible for collecting and remitting sales tax there. Unless you have inventory stored in other states or have a lot of sales in other states, you may not have to worry about sales tax elsewhere yet. A good place to start to learn how to do all this is to download our free PDF "10 Steps to Ensure Sales Tax Doesn't Burn Down Your eCommerce Business." It will give you a solid plan to follow in how to do this. You can find that here - ledgergurus.com/resources/downloads-2/10-steps-to-ensure-sales-tax-doesnt-burn-down-your-ecommerce-business/. We have lots of other resources to help you, too, but this is a good place to start.

@derrickbaker1831 3 года назад

I thought Shopify does collect and remit the taxes to the proper states? Also, can you do a video on just Illinois sales tax? Apparently I live in the most complicated sales tax state

@LedgerGurus 3 года назад

No, Shopify will only collect sales tax if you tell it to and it does NOT remit. That's your job. We are launching a course very soon on how to do sales tax in all the states, and we will be including Illinois. If you'd like more info, please click here - ledgergurus.com/resources/sales-tax-course-updates/

@iridianhearon5627 2 года назад

I’m a new business owner so all of this is kind of new to me, do y’all offer services to help other businesses?

@LedgerGurus 2 года назад

Yes, we do offer some services for small, startup businesses. If you're interested, fill out this contact us form and we'll get back with you - ledgergurus.com/contact-us/

@lorenavanbeuren6192 2 года назад

I notice that you said to unselect "1 1900" because they are repeated orders. My CPA actually adds that into my report and I do not understand why. What exactly are the "1 1900" orders? I am a bit confused there. Thank you so much

@LedgerGurus 2 года назад

No problem, thank you for asking the question. Those are orders that did not have a date associated with them.

@TheMiig1513 9 месяцев назад

Is this also relevant if you live in EU, but sell worldwide including USA?

@LedgerGurus 9 месяцев назад

This is relevant for all US-based sales.

@DuncanFrancis Год назад

The problem I'm having is finding a report in Shopify that gives me all the information I need to complete CA Schedule A and Schedule B. The Shopify Tax Reports don't give you the amount of the sale, and the Orders report doesn't let you filter by Sales Channel to eliminate Facebook/Instagram orders for which tax has already been filed by the sales channel. Help?

@LedgerGurus Год назад

The orders’ report should have a payment column that allows you to filer out certain payment methods. Try that?

@johnny-gv9jf 2 года назад

Thank you so much!!!!! 😩😩😭😭

@LedgerGurus 2 года назад

You are so welcome. I know this can be overwhelming. If you need more help, we have a LOT of resources. Comment here with your questions, and I can answer them and point you to the resources that will be the most helpful for you.

@lthompson4 2 года назад

I'm getting errors when trying to pull the month and date from column H.... one says "Date requires 3 arguments but was given 1" and the other says "the function month contains a date, but it contains a string." My HGS has a date, time and then -0400 ... I'm wondering if that extra info is the problem??

@LedgerGurus 2 года назад

Will you email us at salestax@ledgergurus.com and share a screenshot? Thank you!

@mariacarizajoygragasin1612 3 года назад

Hi. Is this also the Shopify report you use in filling-out sales tax form? Thank you!

@LedgerGurus 3 года назад

Yes!

@cjtoscan 2 года назад

What about the orders at the bottom before you filter to just US that says "blank"

@LedgerGurus 2 года назад

Those are the ones that don’t have a ship to address associated with them. We usually advice to check what they are and determine if they should be included or not.

@quranlistencollectrewards2492 2 года назад

Thank u very much its mean that i musnt collectvand remit all states only where i have nexus ? Not all states ask remiting and collecting sales tax ?

@LedgerGurus 2 года назад

Yep, you're only responsible for collecting and remitting in states where you have nexus. For a really good education on nexus and what that looks like, download our 10 Steps for Sales Tax Compliance white paper - ledgergurus.com/resources/downloads-2/10-steps-to-ensure-sales-tax-doesnt-burn-down-your-ecommerce-business/

@theresareckner9319 3 года назад

I watched another view that you did and I thought you said that Shopifty used Avalaru to handle the sales tax for each state and than filed and remitted the payments to the appropriate states. I'm confused

@LedgerGurus 3 года назад

Do you remember which video that was in?

@veronicabaca-guevara7546 3 года назад

Thank you for this! How do you know if you are a quarter filer?

@LedgerGurus 3 года назад

States assign filing frequency based on sales tax liability. The frequency is usually on documents sent after registration, sometimes it’s on your license. If you have an online state portal, you can check what periods are available to file. You can also call the state.

@user-mg1jj9rr9u Год назад

Can you use Shopify's tax report for 1 state reporting?

@LedgerGurus Год назад

I'm not sure exactly what you're asking. Can you restate the question?

@fjohnso1985 3 года назад

So I’m most states you have to sell at least 100k in most states or 200 sales within a calendar year

@LedgerGurus 3 года назад

That's true. For an up-to-date list of economic thresholds by state, download our PDF, "10 Steps to Ensure Sales Tax Doesn't Burn Down Your eCommerce Business" - ledgergurus.com/resources/downloads-2/10-steps-to-ensure-sales-tax-doesnt-burn-down-your-ecommerce-business/.

@jackanderson7174 2 года назад

Hi super helpful video! Im stuck on the calculated order formula as everytime i punch in the formula and go to enter it comes up as #VALUE! Instead of 1 like in the video. When I go to drag down it just gives me an error for the formula code not allowing all the data to transfer to those columns. Not sure if its an update in excel but its for my quarterly returns for 2021.

@LedgerGurus 2 года назад

Try widening the column. Sometimes #VALUE shows up when there isn't enough room to display the data.

@joscelynreyes9993 Год назад

Same I think I had to delete the time

@quranlistencollectrewards2492 2 года назад

Hello, i have LLC and EIN and warehouses in new york , but i am in turkey , and want to set up my sales tax on shopify , then when shooify will collect sales taxes , i will get money and how can i return it every state , i watched video about it i must regitwr web site and pay there , but i dont have usa phone number there also international phone number , can i pay return taxes only with EIN number ?? And can u help to me ?

@LedgerGurus 2 года назад

If you have your EIN, there's usually a way to register with NY and collect and pay sales tax to NY. You might need to obtain an ITIN or contact the state and let them know that you don't have an SSN or ITIN and see if there's an alternative way to register for an account.

@Doopersam 2 года назад

how do you get tax % for each item from Shopify export. when you export it.

@LedgerGurus 2 года назад

Are you asking about tax rate for each item?

@Mecharenawaffle Год назад

It seems so much harder than selling on amazon

@LedgerGurus Год назад

There are benefits and downsides to both. It's definitely more complicated when it comes to sales tax.

@jjjjj2819 Год назад

Hi, I am Shuhag From Bangladesh Souht east asian National.I am a Regular Viewer of Your RU-vid channel which is encourage me a lot to do e-commerce Bookkeeping Though i am expert in using quickbooks online,wave,xero,zohobooks but i have not efficient enough to do a e-commerce bookkeeping that's why i want to take a E-commerce bookkeeping training so that i can able to do e-commerce bookkeeping. I want to take e-commerce bookkeeping training from your firm please help me to do so.I am waiting for your reply.

@LedgerGurus Год назад

We are so glad you are here! We will definitely let you know when we have a course on that topic. In the meantime you can take our sales tax course for ecommerce businesses and accountants!

@jjjjj2819 Год назад

@@LedgerGurus when your course will bes start(sales tax)?please let me know i am waiting for this.

@LedgerGurus Год назад

@@jjjjj2819 we already launched our sales tax course! ledgergurus.thinkific.com/

@scottnemiro 3 года назад

you do not file one amount with the state. you have to break it down by county. how do you break it down by county?!?! this is worthless

@LedgerGurus 3 года назад

You can do that by choosing state and county columns to go into your pivot table. You can design your pivot table to give you any information you want it to.