Google Sheets template, $39 one time

Etsy and Shopify bookkeeping spreadsheet

Import your Etsy monthly statement and Shopify Payments CSV. TieOut Sheets builds one P&L, splits every fee and ties each payout to your bank.

Open the demo See the price

Etsy + Shopify Payouts Reconciler Sample data

B5fx=SUMIFS(ENet,ECat,"Sales",EIn,1)

ABCD

1 Profit and loss from platform activity

2 Period: 2026-10-01 to 2026-10-31

4 LineEtsyShopifyTotal

5 Gross sales (with shipping)$2,456.70$3,706.53$6,163.23

6 Less: sales tax inside Shopify sales$0.00$0.00$0.00

7 Refunds-$36.00-$45.12-$81.12

8 Disputes and chargebacks$0.00-$73.61-$73.61

9 Net sales$2,420.70$3,587.80$6,008.50

11 Etsy transaction fees-$158.60$0.00-$158.60

12 Etsy processing fees-$92.37$0.00-$92.37

13 Etsy listing fees-$10.40$0.00-$10.40

14 Etsy Offsite Ads fees$0.00$0.00$0.00

15 Etsy subscription$0.00$0.00$0.00

16 Etsy VAT on fees$0.00$0.00$0.00

17 Other Etsy fees-$0.38$0.00-$0.38

18 Shopify payment fees$0.00-$138.01-$138.01

19 Total platform fees-$261.75-$138.01-$399.76

21 Etsy Ads-$39.20$0.00-$39.20

22 Shipping labels bought on Etsy-$126.10$0.00-$126.10

23 Adjustments and reserves$0.00$15.00$15.00

24 Net from platforms$1,993.65$3,464.79$5,458.44

26 Memo: sales tax Etsy collected and paid for you$190.04

27 Memo: fees as a share of gross sales10.7%3.7%6.5%

28 Memo: money sent to your bank$1,945.02$3,035.02$4,980.04

Two exports in, one set of books

Etsy and Shopify pay out on their own schedules and take fees in different places. Import each file into its tab and the formulas sort every row.

EtsyShop Manager > Finances > Monthly statements
ShopifyFinance > Payouts, then export the transactions
BankDate, description and amount, if you want the match

Read the import steps

An Etsy payout is not revenue

An Etsy deposit lands after fees, labels, ads and refunds come out. The sheet keeps sales, fees and payouts apart, and shows the sales tax Etsy collects as a memo line.

Read why deposits differ from sales

11 tabs in one Google Sheet

Exceptions runs every check on one page: the Etsy balance to the cent, rows of an unknown type, payouts missing from the bank file. Read it first, then the P&L. See the limits

Workbook / Tabs Sample data

SHStart HerePeriod, Etsy opening and closing balanceFilledOct
PLP&LEtsy, Shopify and total, side by sideOKOct
FEFeesEach fee per order and as a shareOKOct
PBPayout BridgeEtsy balance and 17 Shopify payoutsOKOct
EXExceptionsOne page of checks, 1 to look atCheckOct
ECEtsy CSVThe monthly statement, 350 rowsImportedOct
SCShopify CSVPayments transactions, 55 rowsImportedOct
BCBank CSVDate, description and amountImportedOct
CAEtsy CalcFormulas, one row per Etsy lineFormulasOct
CSShopify CalcFormulas, one row per Shopify lineFormulasOct
CBBank CalcFormulas, one row per depositFormulasOct

Etsy + Shopify Payouts Reconciler Sample data

C8fx=IF(EtsyClose="","",ABS('Payout Bridge'!B9))

ABCD

1 Exceptions

2 Every line should show OK. To find the rows, filter the Exception column on the Etsy Calc or Shopify Calc tab.

4 CheckCountStatusWhat to do

5 Etsy file is loaded350infoImport the Etsy statement CSV into 'Etsy CSV'.

6 Shopify file is loaded55infoImport the Shopify transactions CSV into 'Shopify CSV'.

7 Shopify columns found9OKIf this is under 9, the file is not the Payments transactions export.

8 Etsy statement ties to the closing balance$0.00OKCheck the opening balance. Check that the file covers the full month.

9 Etsy rows with an unknown type0OKSend us the Type value. Until then, the row shows in no P&L line.

10 Etsy rows not in USD0OKThis version supports USD only.

11 Etsy dates not read0OKImport the file again with 'Replace current sheet'. Do not edit the cells.

12 Etsy refunds for orders from an earlier month1infoNormal. The sale was in an earlier statement.

13 Shopify rows with an unknown type0OKSend us the Type value.

14 Shopify rows not in USD0OKThis version supports USD only.

15 Shopify dates not read0OKImport the file again with 'Replace current sheet'.

16 Shopify rows where Net is not Amount minus Fee0OKCheck for edited cells.

17 Shopify possible duplicate rows0OKYou may have pasted the same rows twice.

18 Shopify rows not yet paid out4infoNormal at month end. They pay out next month.

19 Etsy deposits not found in the bank file0OKCheck the bank file dates. Etsy can take 1 to 3 business days.

20 Shopify payouts not found in the bank file1CHECKCheck the bank file. A payout can be split or held.

21 Bank deposits that are not Etsy or Shopify payouts1infoNormal for other income. Check that none is a missing payout.

Start HereP&LFeesPayout BridgeExceptions

Close a month in 3 steps

About 10 minutes a month, once the Start Here tab is filled in.

Download both exports

The Etsy monthly statement and the Shopify Payments transactions, for the same month.

Import each file into its tab

File > Import > Replace current sheet. Column order in the Shopify file does not matter.

Read the spreadsheet’s checks first

Every line on the Exceptions tab should show OK. Then read the P&L.

Google Sheets formulas only

No add-on, no script, no permissions screen and no account connection. Your copy lives in your own Google Drive.

Read where your data stays

Etsy + Shopify Payouts Reconciler Sample data

C4fx=IF('P&L'!B5=0,"",B4/'P&L'!B5)

ABCD

1 Fees

2 Orders in period:104

3 FeeAmountShare of gross salesPer order

4 Etsy transaction fees$158.606.5%$1.53

5 Etsy processing fees$92.373.8%$0.89

6 Etsy listing fees$10.400.4%$0.10

7 Etsy Offsite Ads fees$0.000.0%$0.00

8 Etsy subscription$0.000.0%$0.00

9 Etsy VAT on fees$0.000.0%$0.00

10 Other Etsy fees$0.380.0%$0.00

11 Etsy Ads$39.201.6%$0.38

12 Shopify payment fees$138.013.7%$1.33

13 All fees and ads$438.967.1%$4.22

Pricing. One sheet, one payment.

TieOut SheetsEvery tab, both shops, yours to keep$39 one time
Demo sheetSample October, view only, no loginFree
RefundIf the sheet cannot handle your files$39 back

Checkout opens this week. Email lalit@tieoutsheets.com and we send the link the day it opens.

USD only. One Etsy shop and one Shopify Payments store. Up to 3,000 rows for each platform each month.

Questions

Plain answers on imports, deposits, sales tax and limits.

Read all the answers

Does it connect to my Etsy or Shopify account?

No. You download two CSV files and import them. There is no add-on, no script and no account connection.

Why is my Etsy deposit less than my sales?

Etsy takes fees, labels, ads and refunds out of your balance before each deposit. The Payout Bridge tab walks from the opening balance to the closing balance.

Does the sheet count Etsy sales tax as income?

No. Etsy collects and pays US sales tax for you, so the sheet shows it as a memo line. For Shopify, you enter the tax you collected on the Start Here tab.

What are the spreadsheet’s limits?

USD only. One Etsy shop and one Shopify Payments store. Up to 3,000 rows for each platform each month. It runs in Google Sheets; Excel is not tested.

How long does a month take in the sheet?

About 10 minutes once the Start Here tab is filled in: download two files, import each into its tab, then read the Exceptions tab and the P&L.

Is the spreadsheet tax advice?

No. It is a bookkeeping aid, and we are not accountants. Ask your tax professional about your filing.