Etsy Bookkeeping Template
A simple Etsy bookkeeping template helps you separate shop revenue, Etsy fees, and business expenses so tax time is less stressful. This workbook mirrors how successful sellers track monthly sales, fees, and operating costs.
Available as a free Excel download or make a Google Sheets copy. Paste in bank and Etsy payout data, categorize transactions, and view a monthly profit and loss with spend insights.
Want automated Etsy bookkeeping? BudgetBadger Business connects your Etsy shop and bank accounts for a tax-ready P&L without spreadsheet maintenance.
Etsy Bookkeeping Template Preview:
Download the Etsy Bookkeeping Excel spreadsheet:
Make a copy of the Etsy Bookkeeping Google Sheet:
Completion instructions:
- Download your bank and credit card transaction data in CSV format for the most recent completed month
- Follow the instructions on the Data Input tab to consolidate transactions and import your Etsy Shop Manager monthly statement CSV
- On the Profit & Loss tab, select a month to view revenue, expenses, net income, and spend insights
Related free tool: Etsy Fee Calculator — Calculate Etsy fees and true profit per sale with Offsite Ads toggles.