Reports — 2026
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | YTD | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | |||||||||||||
| Orders | $2,489 | $2,468 | $4,958 | ||||||||||
| Retail | $218 | $351 | $569 | ||||||||||
| Cathedral | $0 | ||||||||||||
| Total Revenue | $2,707 | $2,819 | $5,527 | ||||||||||
| COGS | $466 | $284 | $750 | ||||||||||
| Gross Margin | $2,241 | $2,536 | $4,777 | ||||||||||
| Operating Expenses | |||||||||||||
| Advertising | $162 | $86 | $248 | ||||||||||
| Car and truck expenses | $70 | $134 | $204 | ||||||||||
| Commissions and fees | $154 | $197 | $351 | ||||||||||
| Insurance | $175 | $175 | $350 | ||||||||||
| Office expenses | $155 | $155 | $310 | ||||||||||
| Rent or lease | $350 | $350 | $700 | ||||||||||
| Supplies | $554 | $653 | $1,206 | ||||||||||
| Total Expenses | $1,620 | $1,750 | $3,370 | ||||||||||
| Net Profit | $621 | $786 | $1,407 | ||||||||||
| Channel | Orders | Gross | Est. Fees | Net | Margin | Avg Order |
|---|---|---|---|---|---|---|
| Etsy | 32 | $3,366.44 | $334.21 | $3,032.23 | 90.1% | $105.20 |
| Shopify | 8 | $764.31 | $24.56 | $739.75 | 96.8% | $95.54 |
| Square | 7 | $566.96 | $15.44 | $551.52 | 97.3% | $80.99 |
| Cash | 2 | $260.17 | $0.00 | $260.17 | 100.0% | $130.08 |
| Painted Tree | 12 | $569.00 | $0.00 | $569.00 | 100.0% | $47.42 |
| Total | 61 | $5,526.88 | $374.21 | $5,152.67 | 93.2% | $90.60 |
| Subscription | Amount | Frequency | Annual Cost | Category | Months | Status |
|---|---|---|---|---|---|---|
| Painted Tree booth rent | $350.00 | monthly | $4,200.00 | Rent or lease | 2 | Ended |
| State Farm business insurance | $175.00 | monthly | $2,100.00 | Insurance | 2 | Ended |
| Shopify subscription | $39.99 | monthly | $479.88 | Office expenses | 2 | Ended |
| Adobe Creative Cloud | $22.99 | monthly | $275.88 | Office expenses | 2 | Ended |
| Etsy Plus | $10.00 | monthly | $120.00 | Office expenses | 2 | Ended |
| Google Workspace | $7.20 | monthly | $86.40 | Office expenses | 2 | Ended |
| Total | $605.18/mo | $7,262.16/yr |
Auto-detected from recurring expenses (same item, same amount, 2+ months). Excludes repeat purchases from Amazon, Pirate Ship, hardware stores, etc.
Q1 Jan / Feb / Mar
Q2 Apr / May / Jun
Q3 Jul / Aug / Sep
Q4 Oct / Nov / Dec
SE tax = 92.35% of net profit x 15.3% (12.4% Social Security + 2.9% Medicare). Half of SE tax is deductible on Form 1040. Estimates do not include income tax.
| Year | Gross Sales | Expenses | Net Profit | YoY Growth |
|---|---|---|---|---|
| 2023 | $69,696 | $26,276 | $43,420 | — |
| 2024 | $62,184 | $34,304 | $27,880 | -10.8% |
| 2025 | $79,545 | $34,205 | $45,340 | +27.9% |
| 2026 * | $5,527 | $4,120 | $1,407 | -93.1% |
* Current selected year. Historical data from workbook summaries; current year from live data.
Tax Reports
Same data as Close Year — available here anytime.
| Line 1 — Gross receipts | $5,526.88 |
| Line 4 — Cost of goods sold | $750.05 |
| Line 5 — Gross profit | $4,776.83 |
| Line 7 — Gross income | $4,776.83 |
| Line 10 — Commissions and fees | $351.03 |
| Line 15 — Insurance (other than health) | $350.00 |
| Line 18 — Office expense | $310.36 |
| Line 20b — Rent — other business property | $700.00 |
| Line 22 — Supplies | $1,206.37 |
| Line 8 — Advertising | $248.13 |
| Line 9 — Car and truck expenses | $204.40 |
| Line 28 — Total expenses | $3,370.29 |
| Line 29 — Tentative profit | $1,406.54 |
| Line 31 — Net profit | $1,406.54 |
Etsy and Painted Tree collect & remit as marketplace facilitators. Cathedral is B2B (not retail). Only direct sales (Shopify, Square, PayPal, Cash, etc.) require you to collect and remit.
| Month | Total Gross | Etsy (exempt) | PT (exempt) | Taxable | Tax Owed | Tax Paid | Diff |
|---|---|---|---|---|---|---|---|
| January | $2,489 | $1,474 | $218 | $797 | $71.73 | $0.00 | $-71.73 |
| February | $2,468 | $1,892 | $351 | $225 | $20.29 | $0.00 | $-20.29 |
| Annual | $4,958 | $3,366 | $569 | $1,022 | $92.02 | $0.00 | $-92.02 |
| Month | Miles | Deduction |
|---|---|---|
| Total | 0 | $0.00 |
Missing mileage data: January, February
IRS standard mileage rate for 2026: $0.7/mile. Using standard rate means you cannot separately deduct vehicle expenses (insurance, interest, gas, repairs).
Product Tag Analysis
Top Performing Tags
| Tag | Length | Products | Orders | Revenue | Avg Order | Score |
|---|---|---|---|---|---|---|
| housewarming gift | 17 | 30 | 377 | $36,041 | $96 |
97
|
| gift for her | 12 | 30 | 377 | $36,041 | $96 |
92
|
| wedding gift | 12 | 30 | 377 | $36,041 | $96 |
92
|
| cutting board | 13 | 21 | 359 | $34,888 | $97 |
91
|
| woodworking | 11 | 30 | 377 | $36,041 | $96 |
91
|
| handcrafted | 11 | 30 | 377 | $36,041 | $96 |
91
|
| food safe | 9 | 30 | 377 | $36,041 | $96 |
89
|
| handmade | 8 | 30 | 377 | $36,041 | $96 |
88
|
| kitchen SHORT | 7 | 30 | 377 | $36,041 | $96 |
87
|
| custom SHORT | 6 | 30 | 377 | $36,041 | $96 |
86
|
| personalized | 12 | 21 | 315 | $30,923 | $98 |
83
|
| cherry charcuterie | 18 | 4 | 78 | $7,501 | $96 |
50
|
| walnut charcuterie | 18 | 4 | 73 | $6,915 | $95 |
50
|
| walnut cutting board | 20 | 3 | 51 | $5,395 | $106 |
49
|
| maple charcuterie | 17 | 4 | 71 | $6,543 | $92 |
48
|
| walnut SHORT | 6 | 10 | 130 | $12,694 | $98 |
47
|
| cherry cutting board | 20 | 3 | 41 | $4,153 | $101 |
47
|
| maple cutting board | 19 | 3 | 45 | $4,381 | $97 |
46
|
| cherry SHORT | 6 | 10 | 125 | $12,038 | $96 |
46
|
| maple SHORT | 5 | 10 | 122 | $11,308 | $93 |
44
|
| artisan SHORT | 7 | 9 | 62 | $5,118 | $83 |
36
|
| walnut serving tray | 19 | 1 | 3 | $274 | $91 |
22
|
| cherry serving tray | 19 | 1 | 3 | $274 | $91 |
22
|
| serving tray | 12 | 3 | 9 | $823 | $91 |
22
|
| maple serving tray | 18 | 1 | 3 | $274 | $91 |
21
|
Score = revenue contribution (60%) + tag length efficiency (20%) + order volume (20%). Tags are matched to orders via product title word overlap. Revenue may be shared across products with the same tag.