Handmade Business Bookkeeping Checklist: Track Sales, Fees, Expenses, and Tax Records

Overview

Handmade business bookkeeping is the process of recording money received, costs paid, inventory purchased, and amounts set aside for obligations. It does not need to begin with complicated software. A spreadsheet, accounting system, or carefully maintained ledger can work if it captures the same basic information consistently.

Keep business and personal transactions separate whenever possible. Use a dedicated bank or payment account if that is practical for your situation, and label every transaction when it occurs rather than relying on memory months later. Your records should allow you to answer four questions:

• What did I sell, and when was the payment received?
• Which marketplace, payment, advertising, or transaction fees were deducted?
• What did I spend to make, package, market, and deliver the products?
• Which documents support each recorded amount?

Record gross sales separately from refunds, discounts, sales tax collected, and marketplace fees. The exact treatment of these amounts can depend on your location and business structure, so use this workflow as an organization guide and confirm tax rules with the relevant authority or a qualified tax professional.

If you are still setting up your shop, pair this system with the handmade product launch checklist. Pricing decisions also become more useful when they are based on real material, labor, packaging, and fee records; see the handmade product pricing worksheet for a complementary framework.

How to estimate

Start with one transaction or one month of orders and build a simple income-and-expense log. Each sales row should include:

• Order date and payment date
• Order or listing reference
• Product or custom commission description
• Quantity and listed price
• Discounts, refunds, and shipping charged to the customer
• Marketplace, payment-processing, advertising, or transaction fees
• Net deposit received
• Payment account and reconciliation status

A useful check is:

Gross order amount − discounts − refunds − selling fees − payment fees = amount expected in the payout or deposit.

Do not assume the marketplace deposit equals the order total. Platforms may group several orders into one payout, deduct fees before payment, or issue refunds separately. Download order reports and payout statements when available, then match their totals to your bank or payment account.

For expenses, record the date, supplier, category, business purpose, payment method, amount, and receipt location. Common categories include:

• Raw materials such as clay, yarn, wood, fabric, findings, paint, or beads
• Packaging, labels, tissue, boxes, and protective materials
• Postage, courier charges, and shipping supplies
• Craft-fair fees, booth equipment, signage, and display materials
• Marketplace subscriptions, listing fees, payment fees, and permitted promotion costs
• Tools, equipment, repairs, studio supplies, and software
• Photography, printing, website, and business administration costs

Keep personal purchases out of business categories. If an item has both business and personal use, record only the portion that your local rules allow and retain a note explaining your method.

Inputs and assumptions

Your bookkeeping system becomes easier to review when its assumptions are written down. Create a short reference page containing:

• Your bookkeeping period and preferred payment date convention
• The marketplaces, payment processors, craft fairs, and direct-sales channels you use
• Your expense categories and inventory method
• How you handle discounts, deposits, cancellations, returns, and damaged goods
• Where digital receipts, invoices, payout reports, and paper documents are stored
• The local filing, reporting, and record-retention guidance you are following

For inventory, separate materials bought from materials used. An inventory-cost worksheet can include:

Opening materials inventory + materials purchased − materials used or otherwise removed = closing materials inventory.

For finished goods, list the item, quantity completed, material cost per unit, direct labor assumption, and current status: available, sold, damaged, gifted, or used as a sample. Avoid counting the same material as both an expense and remaining inventory in the same calculation. The appropriate treatment can vary by jurisdiction and business type, so document your method and obtain professional advice when needed.

Receipts should be readable and connected to the ledger entry. A practical file name might include the date, supplier, category, and amount. Photograph paper receipts promptly, back up digital files, and retain records for the period required by your local tax and business rules rather than relying on a universal timetable.

Worked examples

Suppose a customer order shows a product amount of 48, customer-paid shipping of 8, a discount of 4, and marketplace and payment fees totaling 6. The expected payout before any separate adjustment is:

48 + 8 − 4 − 6 = 46.

Record the product sale, shipping amount, discount, and fees in separate fields. When the payout arrives, compare it with the order and note any difference rather than changing the original figures to force a match.

Now consider a monthly materials purchase. You buy 120 worth of supplies, use materials costing 35 to make sold pieces, and still have 85 worth of identifiable materials on hand. Your worksheet should show the purchase and the amount used according to your chosen inventory method. If several products share a roll of fabric or a bulk package of beads, use a consistent allocation method and keep the calculation with your records.

At month-end, reconcile in this order:

1. Export sales, refund, fee, and payout reports from each marketplace.
2. Match order totals to deposits or payout batches.
3. Compare bank and payment-account activity with your ledger.
4. Investigate unmatched amounts, duplicate entries, missing fees, and delayed refunds.
5. Enter expenses from receipts and flag transactions that need clarification.
6. Update inventory quantities and save a dated copy of the completed report.

If you sell at in-person events, count opening and closing cash, record card payments separately, and preserve the event application, booth invoice, and sales summary. The craft fair booth budget and break-even planner can help connect event costs with sales targets.

When to recalculate

Use a monthly routine for ordinary sales and expense entry, a quarterly review for broader decisions, and a year-end close for document preparation. Recalculate sooner when a marketplace changes its fee structure, a payment processor changes reports, shipping costs rise, material prices move, or you add a new sales channel. Review pricing after these changes; the marketplace fees and seller policies guide can help you identify which platform inputs deserve attention.

Monthly checklist: enter all orders and expenses, reconcile payouts, save reports, update inventory, and investigate missing receipts.

Quarterly checklist: compare revenue and costs by product or sales channel, review unpaid customer balances or deposits, check whether pricing still covers current inputs, and set aside records needed for any applicable filings.

Year-end checklist: save final marketplace and payment reports, review refunds and returns, count inventory using your documented method, confirm equipment and supply records, organize bank statements and receipts, and prepare a list of questions for your tax professional. Also check official guidance for the relevant tax year because deadlines, reporting thresholds, forms, and marketplace policies can change.

Bookkeeping works best as a small recurring task rather than a once-a-year reconstruction. Schedule a fixed monthly review, use the same categories each time, and keep a note beside every unresolved item. That habit gives you cleaner handmade marketplace accounting, more defensible business records, and better information for deciding what to make, price, and sell next.