Etsy & Shopify Seller Bookkeeping Spreadsheet 2027 | Mrs Tenisha Collins

Etsy & Shopify Seller Bookkeeping Spreadsheet 2027 | Mrs Tenisha Collins

Sale price  $16.79 USD Regular price  $27.99 USD
Skip to product information
Etsy & Shopify Seller Bookkeeping Spreadsheet 2027 | Mrs Tenisha Collins

Etsy & Shopify Seller Bookkeeping Spreadsheet 2027 | Mrs Tenisha Collins

Sale price  $16.79 USD Regular price  $27.99 USD

Know your REAL profit after Etsy fees, ads, shipping and materials. Designed by accountant Mrs Tenisha Collins.

Sales are coming in, but how much are you actually keeping? This spreadsheet is built for online sellers. Log your payouts and purchases, and it shows your true profit by month and by sales channel, plus how much to save for taxes.

MADE FOR SELLERS
✔ Sales channels: Etsy, Shopify, Amazon, eBay, craft fairs, wholesale
✔ Seller expense categories ready to go: Etsy transaction, listing and ad fees, Shopify plan and apps, payment processing, shipping labels, packaging, materials (COGS), print-on-demand costs, photography, booth fees
✔ See your holiday rush and slow months side by side in the monthly P&L

WHAT'S INCLUDED (8 tabs)
✔ Start Here: setup in 10 minutes, plus seller tips (fees, sales tax)
✔ Setup: shop name, year, starting balance, tax set-aside %
✔ Income Log (500 rows) with a Sales Channel drop-down
✔ Expense Log (1,000 rows) with drop-down categories and a receipt check
✔ Mileage Log: supply runs, post office trips, craft fairs
✔ Monthly Profit & Loss: fills in automatically
✔ Quarterly Tax Set-Aside: follows the real IRS estimated-tax periods
✔ Dashboard: income, expenses, profit margin, tax savings and bank balance, with charts

WORKS WITH
Microsoft Excel 2010+ (Windows/Mac) and Google Sheets (free; instructions included).

YOU'LL RECEIVE (one instant-download ZIP)
• Etsy_Shopify_Seller_Bookkeeping_2027.xlsx
• How-To-Use guide (PDF)

PLEASE NOTE
• Digital download. Nothing will be shipped. Software not included.
• Not affiliated with or endorsed by Etsy, Shopify, Amazon or eBay.
• An organizing tool, not tax or legal advice. Consult a licensed tax professional.
• All sales are final due to the digital nature, but message us anytime for help.
• For personal or single-shop use. Please don't resell or share.

Created by Mrs Tenisha Collins, Accountant · Author · Coach.

You may also like