Bookkeeping for Handmade and Etsy Sellers: Using the Aspire Budgeting Spreadsheet

Track sales, fees, refunds, shipping, materials, labor, supplies, and taxes, while keeping business and personal accounts separate. Set up Aspire with Income, Expenses, COGS, Inventory, and Cash Flow tabs, map Etsy CSV fields to those columns, and use consistent naming so imports and month-end reconciliations are fast and auditable.

TL;DR: Track sales, fees, refunds, shipping, materials, labor, supplies, and taxes, while keeping business and personal accounts separate. Set up Aspire with Income, Expenses, COGS, Inventory, and Cash Flow tabs, map Etsy CSV fields to those columns, and use consistent naming so imports and month-end reconciliations are fast and auditable.

Handmade and Etsy seller bookkeeping

Bookkeeping basics for handmade and Etsy sellers

One-line description: Define what to track (sales, fees, refunds, shipping, materials, labor, supplies, taxes), how to separate business vs personal transactions, and the bookkeeping terms and accounts a small handmade business needs.

If you sell handmade goods on Etsy, bookkeeping is about keeping your shop solvent and your taxes tidy, not about making spreadsheets for accountants. Track these core items: gross sales, Etsy and payment processor fees, refunds and discounts, shipping collected and shipping costs, cost of materials, direct labor, supplies, overhead, and taxes collected. Those items let you calculate profit and prepare for tax time.

Keep business and personal transactions separate. Open a dedicated business account or, at minimum, use a dedicated card. When you move money from business to personal, record it as an owner draw or equity withdrawal, not an expense. That keeps profit calculations accurate and avoids mixing personal spending with business costs.

Basic bookkeeping accounts and terms for a small handmade business:

Income or Sales, separated by channel (Etsy, craft fair, wholesale).
Cost of Goods Sold (COGS), capturing materials and direct labor tied to sold items.
Inventory asset account, to track items on hand and their costs.
Expenses, organized by category such as shipping, supplies, marketing, platform fees, payment processing, rent/utilities.
Accounts Receivable if you offer wholesale invoices.
Bank and Cash accounts for reconciliations.
Equity accounts for owner contributions and draws.

Treat refunds and discounts as contra-revenue, not expenses, so gross sales and net sales remain clear. Use memos on transactions to record why a refund happened; that helps when reconciling with Etsy reports.

Setting up the Aspire Budgeting Spreadsheet for your Etsy shop

One-line description: Step-by-step setup guidance for Aspire. Recommended tabs: Income, Expenses, COGS, Inventory, Cash Flow. How to map Etsy report fields to the spreadsheet, naming conventions, and tips for turning raw CSVs into clean bookkeeping rows.

Aspire works best with clear tabs and a consistent import process. Start with these tabs: Income, Expenses, COGS, Inventory, Cash Flow. Add a Mappings or Settings tab to control categories and source tags.

Step-by-step setup:

Create tabs named exactly: Income, Expenses, COGS, Inventory, Cash Flow, Mappings. Consistent names make imports predictable.
In Mappings, list the Etsy CSV fields you commonly get: Order ID, Date, Item Title, Quantity, Item Sales, Shipping Collected, Shipping Cost, Sales Tax Collected, Etsy Fees, Payment Processing Fees, Refund Amount, Promotional Credits. Map each incoming field to your Aspire column names.
On the Income tab, include Date, Channel, Order ID, SKU or Item, Quantity, Gross Sales, Shipping Collected, Sales Tax, Discounts/Refunds (negative), Net Sales, and Category tag.
On the COGS tab, record material cost per item, labor minutes or rate, packaging, and per-item shipping allocation if you include that in COGS. Use SKU, Batch ID, Material Cost, Labor Cost, Total COGS.
Expenses tab: Date, Payee, Category (platform fees, supplies, advertising, rent, software), Amount, Payment Method, Reimbursable flag, Memo.
Inventory tab: SKU, Description, Units on Hand, Unit Cost, Total Value, Reorder Point.
Cash Flow tab can be driven by Income and Expenses, with Opening Balance, Cash Inflow, Cash Outflow, Net Change, Closing Balance.

Naming conventions, keep them simple and consistent:

income_etsy, income_craftfair, income_wholesale
expense_materials, expense_shipping, expense_fees, expense_marketing
cogs_{sku} or cogs_batch_2026_09
inv_{sku}

Mapping Etsy report fields to your Aspire columns: Etsy often separates item sales from shipping and taxes. Map Item Sales to Gross Sales, Shipping Paid by Buyer to Shipping Collected, Etsy Fees to Expense - platform fees, Payment Processor Fees to Expense - processing fees, and Refund Amount to the Discounts/Refunds negative line on Income.

Tips for converting raw CSVs into clean rows:

Import or paste the raw CSV into a staging sheet. Clean up date formats and remove empty header rows.
Split combined columns. When multiple items appear in one order, expand them into separate rows or split quantities and item titles into separate lines with the same Order ID.
Normalize payee names so Etsy, PayPal, and Shopify show consistently as the same channel when you tag.
Use lookup tables to map Etsy fee lines that include text descriptions into your expense categories automatically.
Round consistently and keep cents. If you reconcile to bank deposits, remember that Etsy batches payments and deposits may combine many orders, so include deposit matching columns.

What the Aspire Budgeting Spreadsheet does well for makers and Etsy sellers

One-line description: Explain Aspire’s strengths for ongoing shop management: budget-driven cash visibility, category-level expense tracking, scenario planning, and runway views. Describe when that visibility helps routine bookkeeping and decision-making.

Aspire is strongest when you want a budget-first view of your creative business. It makes cash visible by category, so you can see how much of your sales are eaten by materials, platform fees, or shipping. That clarity reduces routine bookkeeping work because you can allocate recurring expenses once and then track month-to-month changes without reclassifying every transaction.

Use Aspire for scenario planning, such as modeling a price increase, higher marketing spend, or a seasonal sale. The cash runway view shows how long you can operate if sales dip or a large supplier bill arrives. For makers, per-item COGS and inventory tracking are the most useful parts because margins on handmade items are often thin and variable.

Aspire helps bookkeeping when you use the same categories as your tax preparer and import bank or Etsy reports into consistent tabs. It reduces time spent reconciling by giving you one place to view budgeted versus actuals.

When a one-time template or single-use workbook fits better (comparison table goes here)

One-line description: Describe scenarios where a one-time template is preferable (short-term projects, seasonal pop-ups, single-event budgets) and include a comparison table placed in this section: Aspire Budgeting Spreadsheet vs one-time template vs basic bookkeeping software (feature-by-feature trade-offs, setup time, flexibility, learning curve).

If you run a short seasonal pop-up, a craft fair project, or a single wholesale event, a one-time template can be faster. It is lighter weight, needs less setup, and suits a single budget that will not require ongoing imports.

Feature	Aspire Budgeting Spreadsheet	One-time Template	Basic Bookkeeping Software
Best use case	Ongoing shop with recurring imports and scenario planning	Short-term projects, seasonal pop-ups, single-event budgets	Regular bookkeeping, automated bank feeds, tax reports
Feature depth	High for budgeting, COGS, runway and category tracking	Low, focused on the event or project	Medium, focuses on ledger and accounts, less flexible budgeting
Setup time	Medium, initial mapping and tab setup required	Low, quick to copy and tweak	Low to medium, depends on setup of accounts and bank connections
Flexibility	High, customize columns and scenarios	High for single use, but not ideal for scaling	Low to medium, constrained by software workflows
Learning curve	Medium, a few spreadsheet skills needed	Low, minimal spreadsheet skills	Low for basic tasks, higher for advanced reporting
Ideal for makers who	Need ongoing visibility and forecasting	Want a quick plan for a single show or pop-up	Want automated transaction imports and tax-ready reports

Use the spreadsheet when you want control and modeling. Use a one-time template when speed and simplicity matter. Use bookkeeping software when you want automation of bank feeds and tax reports and are comfortable trading some flexibility for convenience.

Practical bookkeeping workflow, reconciliations, and integrations for Etsy sellers

One-line description: Day-to-month bookkeeping routine (recording sales and fees, reconciling payments, logging refunds and shipping costs), inventory cost-tracking approach, integration options (CSV imports, bank rules, connector tools), and how to keep records tax-ready without inventing new processes.

Daily to weekly routine:

Import or paste an Etsy order CSV into the Income staging sheet, map fields, and tag by channel.
Record Etsy fees and payment processing fees as expenses, or map them to contra lines if you prefer net sales reporting.
Log refunds immediately as negative income with a memo referencing the Order ID.
Record shipping costs and label expenses so you can separate shipping paid by buyers from shipping you paid.

Monthly routine:

Reconcile bank deposits to the Cash Flow tab, noting that Etsy batches multiple orders into single deposits.
Reconcile credit card and PayPal statements to expenses.
Run a month-end COGS calculation: move material and direct labor into COGS for items sold in the month, and adjust Inventory asset balances.
Review category spending against budgeted amounts and adjust prices or suppliers as needed.

Inventory cost-tracking approach:

Use per-SKU unit costs. When you purchase materials, record them as inventory or supplies depending on whether they become part of finished goods.
When you make items, record a build entry that moves material value into finished inventory at a calculated unit cost.
When items sell, record COGS based on the SKU unit cost. That keeps gross margin accurate.

Integration options:

CSV imports remain the most reliable cross-platform method. Create a staging import tab and transformation rules.
Bank rules in your spreadsheet or accounting software can auto-categorize recurring expenses.
Connector tools can automate data pulls from Etsy into cloud sheets, but test them and verify each import.

Keep records tax-ready by retaining order IDs, invoices, receipts for materials, shipping receipts, and bank statements. Use consistent memos and tags so you or your accountant can filter by category quickly without reclassifying transactions.

FAQ: quick answers to common follow-ups

One-line description: Short, practical Q/A pairs addressing points not fully covered above.

Q1: How often should I back up my Aspire spreadsheet and what’s the simplest backup routine? A1: Back up after any batch import or month-end close; keep a dated copy in cloud storage plus one local copy and use version history to recover earlier states.

Q2: Can I track in-person craft fair or wholesale sales in the same Aspire file as my Etsy sales? A2: Yes, use separate income source tags or a dedicated tab for each channel so you can filter, reconcile, and compare channel performance without mixing raw transactions.

Q3: What’s the easiest way to record owner draws and transfers between business and personal accounts? A3: Record owner draws as equity withdrawals with a clear memo and separate bank transfer entries; do not treat them as expenses so profit calculations remain accurate.

Q4: How should I record refunds, discounts, and Etsy promotional credits so reporting stays clear? A4: Post refunds and discounts as negative sales or separate contra-revenue lines, and record platform promotional credits in a clearly labeled income or reimbursement category so gross vs net reporting stays transparent.