Report Pundit
내용
[subtitle-meta] lang=en auto=True
Hey everyone, today we're going to talk
about sales tax report. Sales tax report
is one of the report that takes way too
much time for Shopify stores. But don't
worry, I'll walk you through the exact
report in Shopify, modify a little bit
and export it for filing. Also, when to
consider an external application if
you're dealing with multiple states and
international complexities. Here's the
plan. First, we'll locate the Shopify's
built-in tax report. I'll help you tweak
that a little bit and then when to
consider a reporting application,
especially if you need a monthly summary
or tax by state, tax by country, or a
detailed line item level report, or if
you want to reconcile your taxes with
your payout. Shopify's built-in tax
report gives you total taxes collected
and taxable sales. You can set the date
range and filter by country, like just
the United States, and export it in a
CSV format. Let me walk you through it.
You go to Shopify admin page. Under
analytics, you have reports.
Click on reports. These are the built-in
Shopify reports that we have.
Look for taxes.
So, this is the report.
Here you can set the date range of your
choice.
Let's select last 7 days.
Apply. You can also set the date here
and export it in a CSV format. So this
gives you an overall tax report in
Shopify. If you're looking for the
report to reflect only for a specific
country, you can just go ahead and apply
the filter for tax country
and select United States here
and group by the country and save the
report. So this way you have the tax
report for United States. The tax data
that you see here is only for the
selected period but it can include lines
from different jurisdictions. So before
you finalize anything, double check your
exemptions and destination based rules
in your tax engine or run it by your
accountant's checklist. It's always
better to be safe than to be sorry when
it comes to taxes. All right, let's
check out what additional options we
have. When you extend with a reporting
application like report funded, you can
get a monthly summary in one click. Tax
details per product line item
jurisdiction breakdown. Super handy if
you're selling across borders. The best
part, you can reconcile your taxes with
your payouts. So no more manual number
crunching at the end of the month.
Honestly, if you want a clear automated
tax report and you're done doing it all
by hand, then this reporting application
is a game changer. Let me show you how
to get this report in report bund. You
go to library section.
Under library section, you have tax
category.
And here's your monthly tax summary
report.
This will give you taxable sales, non-t
taxable sales, total sales, all grouped
by month. You can also schedule this to
your email or Google sheet for your
finance pack. If you need a breakdown
report on state or country, you can make
use of one of these two reports. Let's
click one of these.
This report is grouped based on the
state.
You can also include order details and
product details
in case if your auditor asks for
verification. Next up, we've got the USA
tax collected report. This one pulls all
your line item level data showing the
jurisdiction, tax amount, and your net
sales, all broken down clearly. It's
perfect if you're selling across
different states and need itemized tax
support. And if you need Canadian tax
report, you can make use of this one.
This report breaks down by province. It
includes GST, HST, PST, QST. For EU and
IOSS report, we can customize it by
including invoice number, transaction
date, BAT rate, BAT value, and many
more. All right, guys, here's a pro
move. We're going to match your taxes
with your payouts. This report links
your order tax data directly with your
payout reports, so everything lines up
perfectly with what actually hits your
bank. With this, you can spot the timing
gaps, adjustments, and accounting
mismatches before they mess up your
book. To sum it up, begin with your
Shopify's built-in tax report if you
want to cover the essentials. If you're
looking for deeper insights like monthly
summaries, Canadian tax, jurisdiction
level detail, then extend your setup
with reporting application. Thank you
for watching this video. I hope this
will help you in making better business
decisions.
원문 자막 펼치기
WEBVTT Kind: captions Language: en 00:00:00.480 --> 00:00:02.230 align:start position:0% Hey<00:00:00.719><c> everyone,</c><00:00:01.280><c> today</c><00:00:01.520><c> we're</c><00:00:01.760><c> going</c><00:00:01.839><c> to</c><00:00:02.000><c> talk</c> 00:00:02.230 --> 00:00:02.240 align:start position:0% Hey everyone, today we're going to talk 00:00:02.240 --> 00:00:05.030 align:start position:0% Hey everyone, today we're going to talk about<00:00:02.560><c> sales</c><00:00:02.960><c> tax</c><00:00:03.360><c> report.</c><00:00:04.080><c> Sales</c><00:00:04.400><c> tax</c><00:00:04.720><c> report</c> 00:00:05.030 --> 00:00:05.040 align:start position:0% about sales tax report. Sales tax report 00:00:05.040 --> 00:00:07.349 align:start position:0% about sales tax report. Sales tax report is<00:00:05.279><c> one</c><00:00:05.440><c> of</c><00:00:05.600><c> the</c><00:00:05.759><c> report</c><00:00:06.160><c> that</c><00:00:06.400><c> takes</c><00:00:06.879><c> way</c><00:00:07.120><c> too</c> 00:00:07.349 --> 00:00:07.359 align:start position:0% is one of the report that takes way too 00:00:07.359 --> 00:00:09.669 align:start position:0% is one of the report that takes way too much<00:00:07.600><c> time</c><00:00:07.839><c> for</c><00:00:08.080><c> Shopify</c><00:00:08.639><c> stores.</c><00:00:09.360><c> But</c><00:00:09.519><c> don't</c> 00:00:09.669 --> 00:00:09.679 align:start position:0% much time for Shopify stores. But don't 00:00:09.679 --> 00:00:11.509 align:start position:0% much time for Shopify stores. But don't worry,<00:00:10.080><c> I'll</c><00:00:10.320><c> walk</c><00:00:10.559><c> you</c><00:00:10.719><c> through</c><00:00:10.880><c> the</c><00:00:11.120><c> exact</c> 00:00:11.509 --> 00:00:11.519 align:start position:0% worry, I'll walk you through the exact 00:00:11.519 --> 00:00:13.910 align:start position:0% worry, I'll walk you through the exact report<00:00:11.759><c> in</c><00:00:12.000><c> Shopify,</c><00:00:12.800><c> modify</c><00:00:13.360><c> a</c><00:00:13.519><c> little</c><00:00:13.679><c> bit</c> 00:00:13.910 --> 00:00:13.920 align:start position:0% report in Shopify, modify a little bit 00:00:13.920 --> 00:00:16.390 align:start position:0% report in Shopify, modify a little bit and<00:00:14.160><c> export</c><00:00:14.480><c> it</c><00:00:14.719><c> for</c><00:00:14.880><c> filing.</c><00:00:15.599><c> Also,</c><00:00:15.920><c> when</c><00:00:16.160><c> to</c> 00:00:16.390 --> 00:00:16.400 align:start position:0% and export it for filing. Also, when to 00:00:16.400 --> 00:00:18.390 align:start position:0% and export it for filing. Also, when to consider<00:00:16.720><c> an</c><00:00:16.960><c> external</c><00:00:17.440><c> application</c><00:00:18.160><c> if</c> 00:00:18.390 --> 00:00:18.400 align:start position:0% consider an external application if 00:00:18.400 --> 00:00:20.230 align:start position:0% consider an external application if you're<00:00:18.560><c> dealing</c><00:00:18.800><c> with</c><00:00:19.119><c> multiple</c><00:00:19.600><c> states</c><00:00:19.920><c> and</c> 00:00:20.230 --> 00:00:20.240 align:start position:0% you're dealing with multiple states and 00:00:20.240 --> 00:00:22.390 align:start position:0% you're dealing with multiple states and international<00:00:20.800><c> complexities.</c><00:00:22.000><c> Here's</c><00:00:22.240><c> the</c> 00:00:22.390 --> 00:00:22.400 align:start position:0% international complexities. Here's the 00:00:22.400 --> 00:00:24.390 align:start position:0% international complexities. Here's the plan.<00:00:22.800><c> First,</c><00:00:23.039><c> we'll</c><00:00:23.279><c> locate</c><00:00:23.519><c> the</c><00:00:23.680><c> Shopify's</c> 00:00:24.390 --> 00:00:24.400 align:start position:0% plan. First, we'll locate the Shopify's 00:00:24.400 --> 00:00:26.550 align:start position:0% plan. First, we'll locate the Shopify's built-in<00:00:24.800><c> tax</c><00:00:25.119><c> report.</c><00:00:25.600><c> I'll</c><00:00:25.920><c> help</c><00:00:26.080><c> you</c><00:00:26.240><c> tweak</c> 00:00:26.550 --> 00:00:26.560 align:start position:0% built-in tax report. I'll help you tweak 00:00:26.560 --> 00:00:28.390 align:start position:0% built-in tax report. I'll help you tweak that<00:00:26.800><c> a</c><00:00:26.960><c> little</c><00:00:27.119><c> bit</c><00:00:27.519><c> and</c><00:00:27.760><c> then</c><00:00:28.000><c> when</c><00:00:28.240><c> to</c> 00:00:28.390 --> 00:00:28.400 align:start position:0% that a little bit and then when to 00:00:28.400 --> 00:00:30.470 align:start position:0% that a little bit and then when to consider<00:00:28.800><c> a</c><00:00:29.119><c> reporting</c><00:00:29.599><c> application,</c> 00:00:30.470 --> 00:00:30.480 align:start position:0% consider a reporting application, 00:00:30.480 --> 00:00:32.709 align:start position:0% consider a reporting application, especially<00:00:30.880><c> if</c><00:00:31.119><c> you</c><00:00:31.279><c> need</c><00:00:31.359><c> a</c><00:00:31.599><c> monthly</c><00:00:31.920><c> summary</c> 00:00:32.709 --> 00:00:32.719 align:start position:0% especially if you need a monthly summary 00:00:32.719 --> 00:00:35.750 align:start position:0% especially if you need a monthly summary or<00:00:32.880><c> tax</c><00:00:33.200><c> by</c><00:00:33.440><c> state,</c><00:00:34.079><c> tax</c><00:00:34.399><c> by</c><00:00:34.640><c> country,</c><00:00:35.280><c> or</c><00:00:35.520><c> a</c> 00:00:35.750 --> 00:00:35.760 align:start position:0% or tax by state, tax by country, or a 00:00:35.760 --> 00:00:38.389 align:start position:0% or tax by state, tax by country, or a detailed<00:00:36.160><c> line</c><00:00:36.399><c> item</c><00:00:36.800><c> level</c><00:00:37.120><c> report,</c><00:00:37.760><c> or</c><00:00:38.160><c> if</c> 00:00:38.389 --> 00:00:38.399 align:start position:0% detailed line item level report, or if 00:00:38.399 --> 00:00:40.229 align:start position:0% detailed line item level report, or if you<00:00:38.559><c> want</c><00:00:38.640><c> to</c><00:00:38.800><c> reconcile</c><00:00:39.280><c> your</c><00:00:39.520><c> taxes</c><00:00:40.000><c> with</c> 00:00:40.229 --> 00:00:40.239 align:start position:0% you want to reconcile your taxes with 00:00:40.239 --> 00:00:42.310 align:start position:0% you want to reconcile your taxes with your<00:00:40.399><c> payout.</c><00:00:40.960><c> Shopify's</c><00:00:41.680><c> built-in</c><00:00:42.000><c> tax</c> 00:00:42.310 --> 00:00:42.320 align:start position:0% your payout. Shopify's built-in tax 00:00:42.320 --> 00:00:44.709 align:start position:0% your payout. Shopify's built-in tax report<00:00:42.719><c> gives</c><00:00:42.960><c> you</c><00:00:43.440><c> total</c><00:00:43.840><c> taxes</c><00:00:44.320><c> collected</c> 00:00:44.709 --> 00:00:44.719 align:start position:0% report gives you total taxes collected 00:00:44.719 --> 00:00:47.110 align:start position:0% report gives you total taxes collected and<00:00:45.040><c> taxable</c><00:00:45.600><c> sales.</c><00:00:46.239><c> You</c><00:00:46.399><c> can</c><00:00:46.559><c> set</c><00:00:46.719><c> the</c><00:00:46.879><c> date</c> 00:00:47.110 --> 00:00:47.120 align:start position:0% and taxable sales. You can set the date 00:00:47.120 --> 00:00:49.029 align:start position:0% and taxable sales. You can set the date range<00:00:47.440><c> and</c><00:00:47.680><c> filter</c><00:00:48.000><c> by</c><00:00:48.239><c> country,</c><00:00:48.640><c> like</c><00:00:48.879><c> just</c> 00:00:49.029 --> 00:00:49.039 align:start position:0% range and filter by country, like just 00:00:49.039 --> 00:00:51.270 align:start position:0% range and filter by country, like just the<00:00:49.280><c> United</c><00:00:49.680><c> States,</c><00:00:50.079><c> and</c><00:00:50.320><c> export</c><00:00:50.719><c> it</c><00:00:50.879><c> in</c><00:00:51.039><c> a</c> 00:00:51.270 --> 00:00:51.280 align:start position:0% the United States, and export it in a 00:00:51.280 --> 00:00:53.910 align:start position:0% the United States, and export it in a CSV<00:00:51.760><c> format.</c><00:00:52.719><c> Let</c><00:00:52.879><c> me</c><00:00:53.039><c> walk</c><00:00:53.199><c> you</c><00:00:53.360><c> through</c><00:00:53.600><c> it.</c> 00:00:53.910 --> 00:00:53.920 align:start position:0% CSV format. Let me walk you through it. 00:00:53.920 --> 00:00:56.790 align:start position:0% CSV format. Let me walk you through it. You<00:00:54.079><c> go</c><00:00:54.239><c> to</c><00:00:54.399><c> Shopify</c><00:00:55.039><c> admin</c><00:00:55.440><c> page.</c><00:00:56.399><c> Under</c> 00:00:56.790 --> 00:00:56.800 align:start position:0% You go to Shopify admin page. Under 00:00:56.800 --> 00:01:00.069 align:start position:0% You go to Shopify admin page. Under analytics,<00:00:57.840><c> you</c><00:00:58.160><c> have</c><00:00:58.399><c> reports.</c> 00:01:00.069 --> 00:01:00.079 align:start position:0% analytics, you have reports. 00:01:00.079 --> 00:01:02.869 align:start position:0% analytics, you have reports. Click<00:01:00.320><c> on</c><00:01:00.559><c> reports.</c><00:01:02.000><c> These</c><00:01:02.239><c> are</c><00:01:02.320><c> the</c><00:01:02.480><c> built-in</c> 00:01:02.869 --> 00:01:02.879 align:start position:0% Click on reports. These are the built-in 00:01:02.879 --> 00:01:05.750 align:start position:0% Click on reports. These are the built-in Shopify<00:01:03.359><c> reports</c><00:01:03.760><c> that</c><00:01:03.920><c> we</c><00:01:04.159><c> have.</c> 00:01:05.750 --> 00:01:05.760 align:start position:0% Shopify reports that we have. 00:01:05.760 --> 00:01:11.030 align:start position:0% Shopify reports that we have. Look<00:01:06.000><c> for</c><00:01:06.640><c> taxes.</c> 00:01:11.030 --> 00:01:11.040 align:start position:0% 00:01:11.040 --> 00:01:13.750 align:start position:0% So,<00:01:11.280><c> this</c><00:01:11.520><c> is</c><00:01:11.600><c> the</c><00:01:11.840><c> report.</c> 00:01:13.750 --> 00:01:13.760 align:start position:0% So, this is the report. 00:01:13.760 --> 00:01:15.910 align:start position:0% So, this is the report. Here<00:01:14.000><c> you</c><00:01:14.240><c> can</c><00:01:14.400><c> set</c><00:01:14.560><c> the</c><00:01:14.799><c> date</c><00:01:15.040><c> range</c><00:01:15.520><c> of</c><00:01:15.760><c> your</c> 00:01:15.910 --> 00:01:15.920 align:start position:0% Here you can set the date range of your 00:01:15.920 --> 00:01:17.830 align:start position:0% Here you can set the date range of your choice. 00:01:17.830 --> 00:01:17.840 align:start position:0% choice. 00:01:17.840 --> 00:01:21.350 align:start position:0% choice. Let's<00:01:18.240><c> select</c><00:01:18.880><c> last</c><00:01:19.280><c> 7</c><00:01:19.600><c> days.</c> 00:01:21.350 --> 00:01:21.360 align:start position:0% Let's select last 7 days. 00:01:21.360 --> 00:01:24.390 align:start position:0% Let's select last 7 days. Apply.<00:01:22.799><c> You</c><00:01:23.040><c> can</c><00:01:23.200><c> also</c><00:01:23.439><c> set</c><00:01:23.680><c> the</c><00:01:23.840><c> date</c><00:01:24.080><c> here</c> 00:01:24.390 --> 00:01:24.400 align:start position:0% Apply. You can also set the date here 00:01:24.400 --> 00:01:27.590 align:start position:0% Apply. You can also set the date here and<00:01:24.640><c> export</c><00:01:25.040><c> it</c><00:01:25.200><c> in</c><00:01:25.360><c> a</c><00:01:25.600><c> CSV</c><00:01:26.080><c> format.</c><00:01:27.119><c> So</c><00:01:27.360><c> this</c> 00:01:27.590 --> 00:01:27.600 align:start position:0% and export it in a CSV format. So this 00:01:27.600 --> 00:01:30.070 align:start position:0% and export it in a CSV format. So this gives<00:01:27.840><c> you</c><00:01:28.159><c> an</c><00:01:28.479><c> overall</c><00:01:28.960><c> tax</c><00:01:29.360><c> report</c><00:01:29.759><c> in</c> 00:01:30.070 --> 00:01:30.080 align:start position:0% gives you an overall tax report in 00:01:30.080 --> 00:01:31.670 align:start position:0% gives you an overall tax report in Shopify.<00:01:30.799><c> If</c><00:01:30.960><c> you're</c><00:01:31.119><c> looking</c><00:01:31.280><c> for</c><00:01:31.439><c> the</c> 00:01:31.670 --> 00:01:31.680 align:start position:0% Shopify. If you're looking for the 00:01:31.680 --> 00:01:33.830 align:start position:0% Shopify. If you're looking for the report<00:01:32.000><c> to</c><00:01:32.320><c> reflect</c><00:01:32.720><c> only</c><00:01:32.960><c> for</c><00:01:33.200><c> a</c><00:01:33.439><c> specific</c> 00:01:33.830 --> 00:01:33.840 align:start position:0% report to reflect only for a specific 00:01:33.840 --> 00:01:36.789 align:start position:0% report to reflect only for a specific country,<00:01:34.560><c> you</c><00:01:34.799><c> can</c><00:01:34.880><c> just</c><00:01:35.200><c> go</c><00:01:35.360><c> ahead</c><00:01:35.840><c> and</c><00:01:36.400><c> apply</c> 00:01:36.789 --> 00:01:36.799 align:start position:0% country, you can just go ahead and apply 00:01:36.799 --> 00:01:42.310 align:start position:0% country, you can just go ahead and apply the<00:01:36.960><c> filter</c><00:01:37.840><c> for</c><00:01:38.159><c> tax</c><00:01:38.560><c> country</c> 00:01:42.310 --> 00:01:42.320 align:start position:0% 00:01:42.320 --> 00:01:48.789 align:start position:0% and<00:01:43.040><c> select</c><00:01:43.759><c> United</c><00:01:44.159><c> States</c><00:01:44.560><c> here</c> 00:01:48.789 --> 00:01:48.799 align:start position:0% 00:01:48.799 --> 00:01:51.109 align:start position:0% and<00:01:49.200><c> group</c><00:01:49.520><c> by</c><00:01:49.759><c> the</c><00:01:49.920><c> country</c><00:01:50.320><c> and</c><00:01:50.640><c> save</c><00:01:50.880><c> the</c> 00:01:51.109 --> 00:01:51.119 align:start position:0% and group by the country and save the 00:01:51.119 --> 00:01:53.510 align:start position:0% and group by the country and save the report.<00:01:51.840><c> So</c><00:01:52.079><c> this</c><00:01:52.320><c> way</c><00:01:52.640><c> you</c><00:01:52.880><c> have</c><00:01:52.960><c> the</c><00:01:53.200><c> tax</c> 00:01:53.510 --> 00:01:53.520 align:start position:0% report. So this way you have the tax 00:01:53.520 --> 00:01:55.990 align:start position:0% report. So this way you have the tax report<00:01:53.840><c> for</c><00:01:54.079><c> United</c><00:01:54.479><c> States.</c><00:01:55.200><c> The</c><00:01:55.439><c> tax</c><00:01:55.680><c> data</c> 00:01:55.990 --> 00:01:56.000 align:start position:0% report for United States. The tax data 00:01:56.000 --> 00:01:57.749 align:start position:0% report for United States. The tax data that<00:01:56.240><c> you</c><00:01:56.479><c> see</c><00:01:56.640><c> here</c><00:01:56.880><c> is</c><00:01:57.200><c> only</c><00:01:57.360><c> for</c><00:01:57.600><c> the</c> 00:01:57.749 --> 00:01:57.759 align:start position:0% that you see here is only for the 00:01:57.759 --> 00:01:59.910 align:start position:0% that you see here is only for the selected<00:01:58.240><c> period</c><00:01:58.640><c> but</c><00:01:58.880><c> it</c><00:01:59.040><c> can</c><00:01:59.200><c> include</c><00:01:59.600><c> lines</c> 00:01:59.910 --> 00:01:59.920 align:start position:0% selected period but it can include lines 00:01:59.920 --> 00:02:01.990 align:start position:0% selected period but it can include lines from<00:02:00.159><c> different</c><00:02:00.560><c> jurisdictions.</c><00:02:01.520><c> So</c><00:02:01.759><c> before</c> 00:02:01.990 --> 00:02:02.000 align:start position:0% from different jurisdictions. So before 00:02:02.000 --> 00:02:04.149 align:start position:0% from different jurisdictions. So before you<00:02:02.159><c> finalize</c><00:02:02.719><c> anything,</c><00:02:03.360><c> double</c><00:02:03.680><c> check</c><00:02:03.920><c> your</c> 00:02:04.149 --> 00:02:04.159 align:start position:0% you finalize anything, double check your 00:02:04.159 --> 00:02:06.310 align:start position:0% you finalize anything, double check your exemptions<00:02:04.799><c> and</c><00:02:05.119><c> destination</c><00:02:05.759><c> based</c><00:02:06.000><c> rules</c> 00:02:06.310 --> 00:02:06.320 align:start position:0% exemptions and destination based rules 00:02:06.320 --> 00:02:08.550 align:start position:0% exemptions and destination based rules in<00:02:06.560><c> your</c><00:02:06.719><c> tax</c><00:02:07.040><c> engine</c><00:02:07.520><c> or</c><00:02:07.840><c> run</c><00:02:08.000><c> it</c><00:02:08.160><c> by</c><00:02:08.319><c> your</c> 00:02:08.550 --> 00:02:08.560 align:start position:0% in your tax engine or run it by your 00:02:08.560 --> 00:02:10.229 align:start position:0% in your tax engine or run it by your accountant's<00:02:09.039><c> checklist.</c><00:02:09.759><c> It's</c><00:02:10.000><c> always</c> 00:02:10.229 --> 00:02:10.239 align:start position:0% accountant's checklist. It's always 00:02:10.239 --> 00:02:12.070 align:start position:0% accountant's checklist. It's always better<00:02:10.479><c> to</c><00:02:10.640><c> be</c><00:02:10.800><c> safe</c><00:02:11.039><c> than</c><00:02:11.280><c> to</c><00:02:11.440><c> be</c><00:02:11.599><c> sorry</c><00:02:11.840><c> when</c> 00:02:12.070 --> 00:02:12.080 align:start position:0% better to be safe than to be sorry when 00:02:12.080 --> 00:02:14.309 align:start position:0% better to be safe than to be sorry when it<00:02:12.160><c> comes</c><00:02:12.319><c> to</c><00:02:12.480><c> taxes.</c><00:02:13.440><c> All</c><00:02:13.520><c> right,</c><00:02:14.080><c> let's</c> 00:02:14.309 --> 00:02:14.319 align:start position:0% it comes to taxes. All right, let's 00:02:14.319 --> 00:02:16.229 align:start position:0% it comes to taxes. All right, let's check<00:02:14.560><c> out</c><00:02:14.800><c> what</c><00:02:15.120><c> additional</c><00:02:15.599><c> options</c><00:02:16.000><c> we</c> 00:02:16.229 --> 00:02:16.239 align:start position:0% check out what additional options we 00:02:16.239 --> 00:02:18.150 align:start position:0% check out what additional options we have.<00:02:16.640><c> When</c><00:02:16.879><c> you</c><00:02:16.959><c> extend</c><00:02:17.360><c> with</c><00:02:17.520><c> a</c><00:02:17.680><c> reporting</c> 00:02:18.150 --> 00:02:18.160 align:start position:0% have. When you extend with a reporting 00:02:18.160 --> 00:02:20.390 align:start position:0% have. When you extend with a reporting application<00:02:18.800><c> like</c><00:02:19.120><c> report</c><00:02:19.440><c> funded,</c><00:02:20.080><c> you</c><00:02:20.319><c> can</c> 00:02:20.390 --> 00:02:20.400 align:start position:0% application like report funded, you can 00:02:20.400 --> 00:02:22.869 align:start position:0% application like report funded, you can get<00:02:20.560><c> a</c><00:02:20.800><c> monthly</c><00:02:21.120><c> summary</c><00:02:21.520><c> in</c><00:02:21.760><c> one</c><00:02:22.000><c> click.</c><00:02:22.480><c> Tax</c> 00:02:22.869 --> 00:02:22.879 align:start position:0% get a monthly summary in one click. Tax 00:02:22.879 --> 00:02:24.869 align:start position:0% get a monthly summary in one click. Tax details<00:02:23.360><c> per</c><00:02:23.680><c> product</c><00:02:24.239><c> line</c><00:02:24.560><c> item</c> 00:02:24.869 --> 00:02:24.879 align:start position:0% details per product line item 00:02:24.879 --> 00:02:27.190 align:start position:0% details per product line item jurisdiction<00:02:25.520><c> breakdown.</c><00:02:26.319><c> Super</c><00:02:26.640><c> handy</c><00:02:26.959><c> if</c> 00:02:27.190 --> 00:02:27.200 align:start position:0% jurisdiction breakdown. Super handy if 00:02:27.200 --> 00:02:29.190 align:start position:0% jurisdiction breakdown. Super handy if you're<00:02:27.360><c> selling</c><00:02:27.599><c> across</c><00:02:28.000><c> borders.</c><00:02:28.720><c> The</c><00:02:28.959><c> best</c> 00:02:29.190 --> 00:02:29.200 align:start position:0% you're selling across borders. The best 00:02:29.200 --> 00:02:31.430 align:start position:0% you're selling across borders. The best part,<00:02:29.680><c> you</c><00:02:29.840><c> can</c><00:02:30.000><c> reconcile</c><00:02:30.560><c> your</c><00:02:30.720><c> taxes</c><00:02:31.200><c> with</c> 00:02:31.430 --> 00:02:31.440 align:start position:0% part, you can reconcile your taxes with 00:02:31.440 --> 00:02:33.509 align:start position:0% part, you can reconcile your taxes with your<00:02:31.599><c> payouts.</c><00:02:32.239><c> So</c><00:02:32.480><c> no</c><00:02:32.640><c> more</c><00:02:32.879><c> manual</c><00:02:33.200><c> number</c> 00:02:33.509 --> 00:02:33.519 align:start position:0% your payouts. So no more manual number 00:02:33.519 --> 00:02:35.110 align:start position:0% your payouts. So no more manual number crunching<00:02:33.840><c> at</c><00:02:34.080><c> the</c><00:02:34.160><c> end</c><00:02:34.319><c> of</c><00:02:34.400><c> the</c><00:02:34.480><c> month.</c> 00:02:35.110 --> 00:02:35.120 align:start position:0% crunching at the end of the month. 00:02:35.120 --> 00:02:37.190 align:start position:0% crunching at the end of the month. Honestly,<00:02:35.599><c> if</c><00:02:35.840><c> you</c><00:02:35.920><c> want</c><00:02:36.080><c> a</c><00:02:36.319><c> clear</c><00:02:36.640><c> automated</c> 00:02:37.190 --> 00:02:37.200 align:start position:0% Honestly, if you want a clear automated 00:02:37.200 --> 00:02:39.270 align:start position:0% Honestly, if you want a clear automated tax<00:02:37.599><c> report</c><00:02:38.000><c> and</c><00:02:38.319><c> you're</c><00:02:38.560><c> done</c><00:02:38.720><c> doing</c><00:02:38.959><c> it</c><00:02:39.120><c> all</c> 00:02:39.270 --> 00:02:39.280 align:start position:0% tax report and you're done doing it all 00:02:39.280 --> 00:02:41.350 align:start position:0% tax report and you're done doing it all by<00:02:39.519><c> hand,</c><00:02:39.920><c> then</c><00:02:40.080><c> this</c><00:02:40.319><c> reporting</c><00:02:40.800><c> application</c> 00:02:41.350 --> 00:02:41.360 align:start position:0% by hand, then this reporting application 00:02:41.360 --> 00:02:44.150 align:start position:0% by hand, then this reporting application is<00:02:41.519><c> a</c><00:02:41.680><c> game</c><00:02:41.840><c> changer.</c><00:02:43.280><c> Let</c><00:02:43.519><c> me</c><00:02:43.680><c> show</c><00:02:43.840><c> you</c><00:02:44.000><c> how</c> 00:02:44.150 --> 00:02:44.160 align:start position:0% is a game changer. Let me show you how 00:02:44.160 --> 00:02:46.470 align:start position:0% is a game changer. Let me show you how to<00:02:44.319><c> get</c><00:02:44.480><c> this</c><00:02:44.720><c> report</c><00:02:44.959><c> in</c><00:02:45.200><c> report</c><00:02:45.440><c> bund.</c><00:02:46.319><c> You</c> 00:02:46.470 --> 00:02:46.480 align:start position:0% to get this report in report bund. You 00:02:46.480 --> 00:02:48.869 align:start position:0% to get this report in report bund. You go<00:02:46.640><c> to</c><00:02:46.800><c> library</c><00:02:47.280><c> section.</c> 00:02:48.869 --> 00:02:48.879 align:start position:0% go to library section. 00:02:48.879 --> 00:02:52.229 align:start position:0% go to library section. Under<00:02:49.200><c> library</c><00:02:49.599><c> section,</c><00:02:50.640><c> you</c><00:02:50.879><c> have</c><00:02:51.840><c> tax</c> 00:02:52.229 --> 00:02:52.239 align:start position:0% Under library section, you have tax 00:02:52.239 --> 00:02:53.910 align:start position:0% Under library section, you have tax category. 00:02:53.910 --> 00:02:53.920 align:start position:0% category. 00:02:53.920 --> 00:02:56.309 align:start position:0% category. And<00:02:54.160><c> here's</c><00:02:54.560><c> your</c><00:02:55.120><c> monthly</c><00:02:55.599><c> tax</c><00:02:55.920><c> summary</c> 00:02:56.309 --> 00:02:56.319 align:start position:0% And here's your monthly tax summary 00:02:56.319 --> 00:03:00.229 align:start position:0% And here's your monthly tax summary report. 00:03:00.229 --> 00:03:00.239 align:start position:0% 00:03:00.239 --> 00:03:02.790 align:start position:0% This<00:03:00.480><c> will</c><00:03:00.720><c> give</c><00:03:00.879><c> you</c><00:03:01.360><c> taxable</c><00:03:01.920><c> sales,</c><00:03:02.480><c> non-t</c> 00:03:02.790 --> 00:03:02.800 align:start position:0% This will give you taxable sales, non-t 00:03:02.800 --> 00:03:05.830 align:start position:0% This will give you taxable sales, non-t taxable<00:03:03.280><c> sales,</c><00:03:03.920><c> total</c><00:03:04.319><c> sales,</c><00:03:05.200><c> all</c><00:03:05.519><c> grouped</c> 00:03:05.830 --> 00:03:05.840 align:start position:0% taxable sales, total sales, all grouped 00:03:05.840 --> 00:03:08.229 align:start position:0% taxable sales, total sales, all grouped by<00:03:06.080><c> month.</c><00:03:06.879><c> You</c><00:03:07.120><c> can</c><00:03:07.200><c> also</c><00:03:07.519><c> schedule</c><00:03:07.840><c> this</c><00:03:08.080><c> to</c> 00:03:08.229 --> 00:03:08.239 align:start position:0% by month. You can also schedule this to 00:03:08.239 --> 00:03:10.309 align:start position:0% by month. You can also schedule this to your<00:03:08.400><c> email</c><00:03:08.879><c> or</c><00:03:09.280><c> Google</c><00:03:09.599><c> sheet</c><00:03:09.920><c> for</c><00:03:10.159><c> your</c> 00:03:10.309 --> 00:03:10.319 align:start position:0% your email or Google sheet for your 00:03:10.319 --> 00:03:13.030 align:start position:0% your email or Google sheet for your finance<00:03:10.640><c> pack.</c><00:03:11.920><c> If</c><00:03:12.080><c> you</c><00:03:12.239><c> need</c><00:03:12.400><c> a</c><00:03:12.560><c> breakdown</c> 00:03:13.030 --> 00:03:13.040 align:start position:0% finance pack. If you need a breakdown 00:03:13.040 --> 00:03:15.589 align:start position:0% finance pack. If you need a breakdown report<00:03:13.440><c> on</c><00:03:13.760><c> state</c><00:03:14.080><c> or</c><00:03:14.400><c> country,</c><00:03:15.040><c> you</c><00:03:15.280><c> can</c><00:03:15.360><c> make</c> 00:03:15.589 --> 00:03:15.599 align:start position:0% report on state or country, you can make 00:03:15.599 --> 00:03:18.070 align:start position:0% report on state or country, you can make use<00:03:15.840><c> of</c><00:03:16.159><c> one</c><00:03:16.400><c> of</c><00:03:16.480><c> these</c><00:03:16.800><c> two</c><00:03:16.959><c> reports.</c><00:03:17.760><c> Let's</c> 00:03:18.070 --> 00:03:18.080 align:start position:0% use of one of these two reports. Let's 00:03:18.080 --> 00:03:25.670 align:start position:0% use of one of these two reports. Let's click<00:03:18.400><c> one</c><00:03:18.560><c> of</c><00:03:18.720><c> these.</c> 00:03:25.670 --> 00:03:25.680 align:start position:0% 00:03:25.680 --> 00:03:27.750 align:start position:0% This<00:03:26.000><c> report</c><00:03:26.480><c> is</c><00:03:26.720><c> grouped</c><00:03:27.120><c> based</c><00:03:27.360><c> on</c><00:03:27.519><c> the</c> 00:03:27.750 --> 00:03:27.760 align:start position:0% This report is grouped based on the 00:03:27.760 --> 00:03:31.670 align:start position:0% This report is grouped based on the state. 00:03:31.670 --> 00:03:31.680 align:start position:0% 00:03:31.680 --> 00:03:35.270 align:start position:0% You<00:03:31.920><c> can</c><00:03:32.080><c> also</c><00:03:32.400><c> include</c><00:03:33.360><c> order</c><00:03:33.760><c> details</c><00:03:34.959><c> and</c> 00:03:35.270 --> 00:03:35.280 align:start position:0% You can also include order details and 00:03:35.280 --> 00:03:37.190 align:start position:0% You can also include order details and product<00:03:35.680><c> details</c> 00:03:37.190 --> 00:03:37.200 align:start position:0% product details 00:03:37.200 --> 00:03:38.949 align:start position:0% product details in<00:03:37.440><c> case</c><00:03:37.599><c> if</c><00:03:37.840><c> your</c><00:03:38.000><c> auditor</c><00:03:38.480><c> asks</c><00:03:38.720><c> for</c> 00:03:38.949 --> 00:03:38.959 align:start position:0% in case if your auditor asks for 00:03:38.959 --> 00:03:41.589 align:start position:0% in case if your auditor asks for verification.<00:03:40.000><c> Next</c><00:03:40.239><c> up,</c><00:03:40.560><c> we've</c><00:03:40.799><c> got</c><00:03:40.959><c> the</c><00:03:41.200><c> USA</c> 00:03:41.589 --> 00:03:41.599 align:start position:0% verification. Next up, we've got the USA 00:03:41.599 --> 00:03:44.070 align:start position:0% verification. Next up, we've got the USA tax<00:03:41.920><c> collected</c><00:03:42.400><c> report.</c><00:03:42.959><c> This</c><00:03:43.120><c> one</c><00:03:43.360><c> pulls</c><00:03:43.840><c> all</c> 00:03:44.070 --> 00:03:44.080 align:start position:0% tax collected report. This one pulls all 00:03:44.080 --> 00:03:46.309 align:start position:0% tax collected report. This one pulls all your<00:03:44.239><c> line</c><00:03:44.560><c> item</c><00:03:44.959><c> level</c><00:03:45.200><c> data</c><00:03:45.760><c> showing</c><00:03:46.080><c> the</c> 00:03:46.309 --> 00:03:46.319 align:start position:0% your line item level data showing the 00:03:46.319 --> 00:03:48.710 align:start position:0% your line item level data showing the jurisdiction,<00:03:47.280><c> tax</c><00:03:47.599><c> amount,</c><00:03:48.080><c> and</c><00:03:48.319><c> your</c><00:03:48.480><c> net</c> 00:03:48.710 --> 00:03:48.720 align:start position:0% jurisdiction, tax amount, and your net 00:03:48.720 --> 00:03:51.509 align:start position:0% jurisdiction, tax amount, and your net sales,<00:03:49.440><c> all</c><00:03:49.680><c> broken</c><00:03:50.080><c> down</c><00:03:50.319><c> clearly.</c><00:03:51.200><c> It's</c> 00:03:51.509 --> 00:03:51.519 align:start position:0% sales, all broken down clearly. It's 00:03:51.519 --> 00:03:52.949 align:start position:0% sales, all broken down clearly. It's perfect<00:03:51.760><c> if</c><00:03:52.080><c> you're</c><00:03:52.239><c> selling</c><00:03:52.560><c> across</c> 00:03:52.949 --> 00:03:52.959 align:start position:0% perfect if you're selling across 00:03:52.959 --> 00:03:55.589 align:start position:0% perfect if you're selling across different<00:03:53.360><c> states</c><00:03:53.920><c> and</c><00:03:54.239><c> need</c><00:03:54.560><c> itemized</c><00:03:55.200><c> tax</c> 00:03:55.589 --> 00:03:55.599 align:start position:0% different states and need itemized tax 00:03:55.599 --> 00:03:58.309 align:start position:0% different states and need itemized tax support.<00:03:56.560><c> And</c><00:03:56.799><c> if</c><00:03:57.040><c> you</c><00:03:57.200><c> need</c><00:03:57.519><c> Canadian</c><00:03:58.000><c> tax</c> 00:03:58.309 --> 00:03:58.319 align:start position:0% support. And if you need Canadian tax 00:03:58.319 --> 00:04:00.550 align:start position:0% support. And if you need Canadian tax report,<00:03:58.879><c> you</c><00:03:59.120><c> can</c><00:03:59.200><c> make</c><00:03:59.360><c> use</c><00:03:59.599><c> of</c><00:03:59.840><c> this</c><00:04:00.000><c> one.</c> 00:04:00.550 --> 00:04:00.560 align:start position:0% report, you can make use of this one. 00:04:00.560 --> 00:04:03.110 align:start position:0% report, you can make use of this one. This<00:04:00.799><c> report</c><00:04:01.280><c> breaks</c><00:04:01.680><c> down</c><00:04:01.920><c> by</c><00:04:02.159><c> province.</c><00:04:02.799><c> It</c> 00:04:03.110 --> 00:04:03.120 align:start position:0% This report breaks down by province. It 00:04:03.120 --> 00:04:08.309 align:start position:0% This report breaks down by province. It includes<00:04:03.599><c> GST,</c><00:04:04.400><c> HST,</c><00:04:05.439><c> PST,</c><00:04:06.319><c> QST.</c><00:04:07.360><c> For</c><00:04:07.599><c> EU</c><00:04:08.000><c> and</c> 00:04:08.309 --> 00:04:08.319 align:start position:0% includes GST, HST, PST, QST. For EU and 00:04:08.319 --> 00:04:10.869 align:start position:0% includes GST, HST, PST, QST. For EU and IOSS<00:04:09.040><c> report,</c><00:04:09.519><c> we</c><00:04:09.760><c> can</c><00:04:09.920><c> customize</c><00:04:10.480><c> it</c><00:04:10.640><c> by</c> 00:04:10.869 --> 00:04:10.879 align:start position:0% IOSS report, we can customize it by 00:04:10.879 --> 00:04:13.110 align:start position:0% IOSS report, we can customize it by including<00:04:11.439><c> invoice</c><00:04:11.920><c> number,</c><00:04:12.480><c> transaction</c> 00:04:13.110 --> 00:04:13.120 align:start position:0% including invoice number, transaction 00:04:13.120 --> 00:04:15.670 align:start position:0% including invoice number, transaction date,<00:04:13.680><c> BAT</c><00:04:14.000><c> rate,</c><00:04:14.400><c> BAT</c><00:04:14.799><c> value,</c><00:04:15.200><c> and</c><00:04:15.439><c> many</c> 00:04:15.670 --> 00:04:15.680 align:start position:0% date, BAT rate, BAT value, and many 00:04:15.680 --> 00:04:17.909 align:start position:0% date, BAT rate, BAT value, and many more.<00:04:16.400><c> All</c><00:04:16.479><c> right,</c><00:04:16.799><c> guys,</c><00:04:17.280><c> here's</c><00:04:17.519><c> a</c><00:04:17.680><c> pro</c> 00:04:17.909 --> 00:04:17.919 align:start position:0% more. All right, guys, here's a pro 00:04:17.919 --> 00:04:20.069 align:start position:0% more. All right, guys, here's a pro move.<00:04:18.400><c> We're</c><00:04:18.639><c> going</c><00:04:18.720><c> to</c><00:04:18.880><c> match</c><00:04:19.199><c> your</c><00:04:19.519><c> taxes</c> 00:04:20.069 --> 00:04:20.079 align:start position:0% move. We're going to match your taxes 00:04:20.079 --> 00:04:22.950 align:start position:0% move. We're going to match your taxes with<00:04:20.400><c> your</c><00:04:20.560><c> payouts.</c><00:04:21.680><c> This</c><00:04:21.919><c> report</c><00:04:22.639><c> links</c> 00:04:22.950 --> 00:04:22.960 align:start position:0% with your payouts. This report links 00:04:22.960 --> 00:04:25.510 align:start position:0% with your payouts. This report links your<00:04:23.199><c> order</c><00:04:23.520><c> tax</c><00:04:23.840><c> data</c><00:04:24.560><c> directly</c><00:04:25.040><c> with</c><00:04:25.280><c> your</c> 00:04:25.510 --> 00:04:25.520 align:start position:0% your order tax data directly with your 00:04:25.520 --> 00:04:27.830 align:start position:0% your order tax data directly with your payout<00:04:25.919><c> reports,</c><00:04:26.639><c> so</c><00:04:26.960><c> everything</c><00:04:27.280><c> lines</c><00:04:27.600><c> up</c> 00:04:27.830 --> 00:04:27.840 align:start position:0% payout reports, so everything lines up 00:04:27.840 --> 00:04:29.909 align:start position:0% payout reports, so everything lines up perfectly<00:04:28.400><c> with</c><00:04:28.639><c> what</c><00:04:29.040><c> actually</c><00:04:29.440><c> hits</c><00:04:29.680><c> your</c> 00:04:29.909 --> 00:04:29.919 align:start position:0% perfectly with what actually hits your 00:04:29.919 --> 00:04:32.469 align:start position:0% perfectly with what actually hits your bank.<00:04:30.560><c> With</c><00:04:30.800><c> this,</c><00:04:31.280><c> you</c><00:04:31.520><c> can</c><00:04:31.680><c> spot</c><00:04:31.919><c> the</c><00:04:32.160><c> timing</c> 00:04:32.469 --> 00:04:32.479 align:start position:0% bank. With this, you can spot the timing 00:04:32.479 --> 00:04:34.870 align:start position:0% bank. With this, you can spot the timing gaps,<00:04:33.120><c> adjustments,</c><00:04:34.080><c> and</c><00:04:34.320><c> accounting</c> 00:04:34.870 --> 00:04:34.880 align:start position:0% gaps, adjustments, and accounting 00:04:34.880 --> 00:04:36.870 align:start position:0% gaps, adjustments, and accounting mismatches<00:04:35.759><c> before</c><00:04:36.080><c> they</c><00:04:36.240><c> mess</c><00:04:36.479><c> up</c><00:04:36.639><c> your</c> 00:04:36.870 --> 00:04:36.880 align:start position:0% mismatches before they mess up your 00:04:36.880 --> 00:04:38.950 align:start position:0% mismatches before they mess up your book.<00:04:37.360><c> To</c><00:04:37.600><c> sum</c><00:04:37.759><c> it</c><00:04:37.840><c> up,</c><00:04:38.240><c> begin</c><00:04:38.560><c> with</c><00:04:38.720><c> your</c> 00:04:38.950 --> 00:04:38.960 align:start position:0% book. To sum it up, begin with your 00:04:38.960 --> 00:04:41.030 align:start position:0% book. To sum it up, begin with your Shopify's<00:04:39.600><c> built-in</c><00:04:40.000><c> tax</c><00:04:40.320><c> report</c><00:04:40.720><c> if</c><00:04:40.880><c> you</c> 00:04:41.030 --> 00:04:41.040 align:start position:0% Shopify's built-in tax report if you 00:04:41.040 --> 00:04:42.950 align:start position:0% Shopify's built-in tax report if you want<00:04:41.120><c> to</c><00:04:41.280><c> cover</c><00:04:41.520><c> the</c><00:04:41.840><c> essentials.</c><00:04:42.639><c> If</c><00:04:42.800><c> you're</c> 00:04:42.950 --> 00:04:42.960 align:start position:0% want to cover the essentials. If you're 00:04:42.960 --> 00:04:45.110 align:start position:0% want to cover the essentials. If you're looking<00:04:43.199><c> for</c><00:04:43.440><c> deeper</c><00:04:43.759><c> insights</c><00:04:44.400><c> like</c><00:04:44.639><c> monthly</c> 00:04:45.110 --> 00:04:45.120 align:start position:0% looking for deeper insights like monthly 00:04:45.120 --> 00:04:47.590 align:start position:0% looking for deeper insights like monthly summaries,<00:04:45.840><c> Canadian</c><00:04:46.320><c> tax,</c><00:04:46.960><c> jurisdiction</c> 00:04:47.590 --> 00:04:47.600 align:start position:0% summaries, Canadian tax, jurisdiction 00:04:47.600 --> 00:04:49.749 align:start position:0% summaries, Canadian tax, jurisdiction level<00:04:47.919><c> detail,</c><00:04:48.560><c> then</c><00:04:48.800><c> extend</c><00:04:49.120><c> your</c><00:04:49.360><c> setup</c> 00:04:49.749 --> 00:04:49.759 align:start position:0% level detail, then extend your setup 00:04:49.759 --> 00:04:52.150 align:start position:0% level detail, then extend your setup with<00:04:50.080><c> reporting</c><00:04:50.560><c> application.</c><00:04:51.840><c> Thank</c><00:04:52.000><c> you</c> 00:04:52.150 --> 00:04:52.160 align:start position:0% with reporting application. Thank you 00:04:52.160 --> 00:04:53.990 align:start position:0% with reporting application. Thank you for<00:04:52.320><c> watching</c><00:04:52.560><c> this</c><00:04:52.880><c> video.</c><00:04:53.360><c> I</c><00:04:53.600><c> hope</c><00:04:53.759><c> this</c> 00:04:53.990 --> 00:04:54.000 align:start position:0% for watching this video. I hope this 00:04:54.000 --> 00:04:55.830 align:start position:0% for watching this video. I hope this will<00:04:54.160><c> help</c><00:04:54.320><c> you</c><00:04:54.479><c> in</c><00:04:54.800><c> making</c><00:04:55.120><c> better</c><00:04:55.440><c> business</c> 00:04:55.830 --> 00:04:55.840 align:start position:0% will help you in making better business 00:04:55.840 --> 00:04:58.840 align:start position:0% will help you in making better business decisions.