Etsy quarter-close template

Etsy quarterly tax spreadsheet template

Use this page as a copyable layout for Google Sheets or Excel when you want one simple place to track Etsy sales, fees, materials, shipping, and the cash you need to reserve for quarterly taxes. Once the sheet is clean, compare the numbers with the Etsy income tax calculator or the full side hustle tax calculator.

Advertisement Top of page ad placement

What this page gives you

This is not a downloadable file. It is the exact spreadsheet structure most Etsy sellers actually need: a transactions tab, a quarterly summary tab, a few starter formulas, and the current 2026 payment calendar so each quarter maps to a real deadline.

Etsy quarterly tax calculator → Quarterly tax dates → eBay income tax calculator → Side hustle deductions guide →

2026 quarter tabs and due dates

Create one summary block for each IRS payment period. Your spreadsheet can stay monthly or transaction-level underneath, but the summary view should still roll into these four quarter buckets.

Quarter	Income period	Due date	What to review
Q1	Income earned Jan 1 to Mar 31, 2026	April 15, 2026	Sales, refunds, fees, shipping, materials, and reserve gap
Q2	Income earned Apr 1 to May 31, 2026	June 15, 2026	Sales, refunds, fees, shipping, materials, and reserve gap
Q3	Income earned Jun 1 to Aug 31, 2026	September 15, 2026	Sales, refunds, fees, shipping, materials, and reserve gap
Q4	Income earned Sep 1 to Dec 31, 2026	January 15, 2027	Sales, refunds, fees, shipping, materials, and reserve gap

Copyable Etsy spreadsheet layout

Tab 1: Transactions

This is the raw sheet where you paste Etsy rows, fix categories, and keep a running profit number.

Column	Why it matters
A. Date	Use one consistent transaction date so quarter assignment stays clean.
B. Order or payout ID	Match Etsy exports to refunds, deposits, and bookkeeping notes.
C. Gross sales	Track item revenue before Etsy fees reduce your margin.
D. Shipping charged	Separate pass-through shipping cash from actual profit.
E. Refunds	Keep canceled or refunded orders from inflating the quarter.
F. Etsy fees	Capture listing, transaction, offsite ad, and other platform charges.
G. Payment processing	Useful if you want processor costs split from Etsy fees.
H. Shipping labels or postage	Deduct the actual cost of sending orders.
I. Materials or inventory	Track the direct cost to make or source what sold.
J. Packaging supplies	Mailers, tissue, inserts, labels, and protective materials.
K. Software or subscriptions	Design tools, bookkeeping apps, and Etsy-adjacent software.
L. Mileage or travel	Sourcing runs and post office trips often get missed.
M. Other deductions	Use this for ordinary business expenses that do not fit elsewhere.
N. Net profit	Your per-row profit after the main expense categories.
O. Tax reserve	Shows how much cash to move aside from each profitable row.
P. Quarter	Makes quarterly summary formulas simple in Sheets or Excel.

Tab 2: Quarterly summary

Keep this tab short. Its job is to answer one question: how much profit did Etsy produce this quarter, and how much of that needs to go toward tax?

Summary row	Purpose
Gross sales	Sum all sales rows for the quarter before expenses.
Total deductions	Combine fees, postage, materials, packaging, software, mileage, and other deductions.
Quarter net profit	The number you care about before estimating tax.
Quarter tax target	Your calculator-driven reserve target for that payment period.
Estimated payment sent	Track what you actually paid through IRS Direct Pay or EFTPS.
Gap before deadline	Shows whether the quarter is fully funded or still short.

If you also sell on eBay, add a platform field to the transactions tab and use a separate summary block for each marketplace before rolling them together.

Advertisement Etsy spreadsheet template ad placement

Starter formulas for Google Sheets or Excel

The formulas below assume the transactions tab follows the column order above and your reserve rate lives in cell R2.

Transactions!N2  Net profit
=C2 + D2 - E2 - F2 - G2 - H2 - I2 - J2 - K2 - L2 - M2

Transactions!O2  Tax reserve
=N2*$R$2

Transactions!P2  Quarter label
=IFS(MONTH(A2)<=3,"Q1",MONTH(A2)<=5,"Q2",MONTH(A2)<=8,"Q3",TRUE,"Q4")

Summary!B2  Q1 net profit
=SUMIF(Transactions!$P:$P,"Q1",Transactions!$N:$N)

Summary!C2  Q1 reserve
=SUMIF(Transactions!$P:$P,"Q1",Transactions!$O:$O)

Use the spreadsheet for organization, then run your quarter totals through the Etsy quarterly tax calculator before you send a payment.

How to use the template each quarter

Import or paste Etsy activity weekly

A spreadsheet only works if it stays current. Weekly updates keep refunds, shipping labels, and fee changes from piling up at quarter-end.

Close the quarter before the IRS due date

Reconcile the rows, confirm refunds, and review missing deductions before you decide how much to send for the payment period.

Run the calculator after the spreadsheet is clean

The spreadsheet gives you organized profit. The calculator converts that into a better quarterly estimate based on tax rules and filing status.

Separate Etsy from other 1099 income when needed

If Etsy is only part of your side hustle, compare the Etsy sheet with the full sitewide calculator so your reserve covers all income streams.

Related calculators and tax guides

Use the spreadsheet template to keep records clean, then use the tools below when you need an estimate or a platform-specific check.

Main side hustle tax calculator → Etsy income tax calculator → Etsy quarterly tax calculator 2026 → eBay income tax calculator →

FAQ: Etsy quarterly tax spreadsheet template

What should an Etsy quarterly tax spreadsheet template track?

A useful Etsy quarterly tax spreadsheet tracks gross sales, shipping charged, refunds, Etsy fees, payment processing, postage, materials, packaging, software, mileage, other deductions, and the net profit left for quarterly tax planning.

Should I organize the spreadsheet by month or by quarter?

Track each sale or payout row by date, then roll the data up into quarterly totals. That gives you month-level detail without losing the payment periods you need for estimated taxes.

Can I use the same spreadsheet for Etsy and eBay?

Yes. Add a platform column if you want one workbook for both marketplaces, then use separate summary views so Etsy and eBay fees do not blur together.

Does Etsy withhold my quarterly federal tax automatically?

No. Etsy may report payment totals, but estimated federal tax is usually your responsibility. If you expect to owe at least $1,000 for the year, quarterly payments are generally required.

Can a spreadsheet replace an Etsy tax calculator?

No. The spreadsheet is best for bookkeeping and quarter-close organization. Use it with an Etsy tax calculator so your reserve target reflects filing status, self-employment tax, and state tax.