Reports — 2025
▶ Monthly Profit & Loss
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | YTD | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | |||||||||||||
| Orders | $2,742 | $3,719 | $4,129 | $5,525 | $6,086 | $6,196 | $5,039 | $6,081 | $6,488 | $7,362 | $10,188 | $12,415 | $75,970 |
| Retail | $246 | $376 | $348 | $385 | $207 | $383 | $421 | $288 | $231 | $241 | $166 | $283 | $3,575 |
| Cathedral | $0 | ||||||||||||
| Total Revenue | $2,988 | $4,094 | $4,477 | $5,910 | $6,294 | $6,579 | $5,461 | $6,369 | $6,719 | $7,603 | $10,354 | $12,697 | $79,545 |
| COGS | $231 | $330 | $693 | $776 | $724 | $847 | $798 | $837 | $591 | $905 | $938 | $1,080 | $8,749 |
| Gross Margin | $2,757 | $3,764 | $3,784 | $5,133 | $5,569 | $5,732 | $4,663 | $5,533 | $6,129 | $6,698 | $9,416 | $11,617 | $70,796 |
| Operating Expenses | |||||||||||||
| Advertising | $121 | $172 | $134 | $238 | $170 | $242 | $201 | $189 | $143 | $221 | $311 | $392 | $2,533 |
| Car and truck expenses | $120 | $90 | $78 | $82 | $76 | $76 | $140 | $120 | $39 | $91 | $45 | $73 | $1,028 |
| Commissions and fees | $192 | $283 | $294 | $426 | $448 | $483 | $384 | $372 | $456 | $540 | $743 | $804 | $5,426 |
| Insurance | $175 | $175 | $175 | $175 | $175 | $175 | $175 | $175 | $175 | $175 | $175 | $175 | $2,100 |
| Office expenses | $155 | $155 | $155 | $155 | $155 | $155 | $155 | $155 | $155 | $155 | $155 | $155 | $1,862 |
| Rent or lease | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $4,200 |
| Supplies | $574 | $658 | $627 | $660 | $660 | $737 | $872 | $690 | $708 | $484 | $751 | $885 | $8,306 |
| Total Expenses | $1,687 | $1,883 | $1,814 | $2,087 | $2,033 | $2,217 | $2,277 | $2,051 | $2,027 | $2,017 | $2,529 | $2,834 | $25,456 |
| Net Profit | $1,070 | $1,882 | $1,970 | $3,047 | $3,536 | $3,514 | $2,386 | $3,481 | $4,102 | $4,682 | $6,887 | $8,783 | $45,340 |
▶ Channel Profitability
| Channel | Orders | Gross | Est. Fees | Net | Margin | Avg Order |
|---|---|---|---|---|---|---|
| Etsy | 523 | $52,590.14 | $5,231.41 | $47,358.73 | 90.1% | $100.55 |
| Shopify | 125 | $11,911.29 | $382.93 | $11,528.36 | 96.8% | $95.29 |
| Square | 92 | $7,793.86 | $211.84 | $7,582.02 | 97.3% | $84.72 |
| Cash | 27 | $2,414.73 | $0.00 | $2,414.73 | 100.0% | $89.43 |
| PayPal | 14 | $1,259.90 | $0.00 | $1,259.90 | 100.0% | $89.99 |
| Painted Tree | 68 | $3,574.90 | $0.00 | $3,574.90 | 100.0% | $52.57 |
| Total | 849 | $79,544.82 | $5,826.18 | $73,718.64 | 92.7% | $93.69 |
▶ Subscription Tracker
$680/mo · $8,162/yr
$680
Monthly
$8,162
Annual
8
Active Subscriptions
| Subscription | Amount | Frequency | Annual Cost | Category | Months | Status |
|---|---|---|---|---|---|---|
| Painted Tree booth rent | $350.00 | monthly | $4,200.00 | Rent or lease | 12 | Active |
| State Farm business insurance | $175.00 | monthly | $2,100.00 | Insurance | 12 | Active |
| Cell phone (business portion) | $45.00 | monthly | $540.00 | Office expenses | 12 | Active |
| Shopify subscription | $39.99 | monthly | $479.88 | Office expenses | 12 | Active |
| Internet (business portion) | $30.00 | monthly | $360.00 | Office expenses | 12 | Active |
| Adobe Creative Cloud | $22.99 | monthly | $275.88 | Office expenses | 12 | Active |
| Etsy Plus | $10.00 | monthly | $120.00 | Office expenses | 12 | Active |
| Google Workspace | $7.20 | monthly | $86.40 | Office expenses | 12 | Active |
| Total | $680.18/mo | $8,162.16/yr |
Auto-detected from recurring expenses (same item, same amount, 2+ months). Excludes repeat purchases from Amazon, Pirate Ship, hardware stores, etc.
▶ Quarterly Tax Estimates (Self-Employment)
Q1 Jan / Feb / Mar
Revenue
$11,560
Expenses
$6,638
Net Profit
$4,922
SE Tax (15.3%)
$695
Deductible half
$348
Due: April 15, 2025
Q2 Apr / May / Jun
Revenue
$18,782
Expenses
$8,685
Net Profit
$10,097
SE Tax (15.3%)
$1,427
Deductible half
$713
Due: June 15, 2025
Q3 Jul / Aug / Sep
Revenue
$18,549
Expenses
$8,580
Net Profit
$9,969
SE Tax (15.3%)
$1,409
Deductible half
$704
Due: September 15, 2025
Q4 Oct / Nov / Dec
Revenue
$30,653
Expenses
$10,302
Net Profit
$20,351
SE Tax (15.3%)
$2,876
Deductible half
$1,438
Due: January 15, 2026
Annual Net Profit
$45,340
SE Taxable (92.35%)
$41,872
Total SE Tax
$6,406
Deductible Half
$3,203
Effective Rate
14.1%
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-over-Year Comparison
| 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.
▶ Schedule C Summary
| Line 1 — Gross receipts | $79,544.82 |
| Line 4 — Cost of goods sold | $8,748.87 |
| Line 5 — Gross profit | $70,795.95 |
| Line 7 — Gross income | $70,795.95 |
| Line 10 — Commissions and fees | $5,425.65 |
| Line 15 — Insurance (other than health) | $2,100.00 |
| Line 18 — Office expense | $1,862.16 |
| Line 20b — Rent — other business property | $4,200.00 |
| Line 22 — Supplies | $8,306.48 |
| Line 8 — Advertising | $2,533.18 |
| Line 9 — Car and truck expenses | $1,028.30 |
| Line 28 — Total expenses | $25,455.77 |
| Line 29 — Tentative profit | $45,340.18 |
| Line 31 — Net profit | $45,340.18 |
▶ Oklahoma Sales Tax (9.0%)
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,742 | $1,694 | $246 | $803 | $72.27 | $0.00 | $-72.27 |
| February | $3,719 | $2,629 | $376 | $715 | $64.31 | $0.00 | $-64.31 |
| March | $4,129 | $2,910 | $348 | $871 | $78.42 | $0.00 | $-78.42 |
| April | $5,525 | $4,174 | $385 | $965 | $86.89 | $0.00 | $-86.89 |
| May | $6,086 | $4,244 | $207 | $1,635 | $147.16 | $0.00 | $-147.16 |
| June | $6,196 | $4,745 | $383 | $1,068 | $96.12 | $0.00 | $-96.12 |
| July | $5,039 | $3,729 | $421 | $890 | $80.06 | $0.00 | $-80.06 |
| August | $6,081 | $3,572 | $288 | $2,220 | $199.84 | $0.00 | $-199.84 |
| September | $6,488 | $4,363 | $231 | $1,893 | $170.41 | $0.00 | $-170.41 |
| October | $7,362 | $5,324 | $241 | $1,797 | $161.72 | $0.00 | $-161.72 |
| November | $10,188 | $7,404 | $166 | $2,618 | $235.64 | $0.00 | $-235.64 |
| December | $12,415 | $7,803 | $283 | $4,329 | $389.61 | $0.00 | $-389.61 |
| Annual | $75,970 | $52,590 | $3,575 | $19,805 | $1,782.45 | $0.00 | $-1,782.45 |
▶ Mileage Deduction (0 miles x $0.7/mi = $0.00)
| Month | Miles | Deduction |
|---|---|---|
| Total | 0 | $0.00 |
Missing mileage data: January, February, March, April, May, June, July, August, September, October, November, December
IRS standard mileage rate for 2025: $0.7/mile. Using standard rate means you cannot separately deduct vehicle expenses (insurance, interest, gas, repairs).
Product Tag Analysis
▶ Tag Performance (2025)
33
Unique Tags
13.2
Avg Length /20
12
Short Tags (<12)
0
Zero-Revenue Tags
Top Performing Tags
| Tag | Length | Products | Orders | Revenue | Avg Order | Score |
|---|---|---|---|---|---|---|
| housewarming gift | 17 | 30 | 5610 | $523,706 | $93 |
97
|
| gift for her | 12 | 30 | 5610 | $523,706 | $93 |
92
|
| wedding gift | 12 | 30 | 5610 | $523,706 | $93 |
92
|
| woodworking | 11 | 30 | 5610 | $523,706 | $93 |
91
|
| handcrafted | 11 | 30 | 5610 | $523,706 | $93 |
91
|
| food safe | 9 | 30 | 5610 | $523,706 | $93 |
89
|
| cutting board | 13 | 21 | 5052 | $480,327 | $95 |
88
|
| handmade | 8 | 30 | 5610 | $523,706 | $93 |
88
|
| kitchen SHORT | 7 | 30 | 5610 | $523,706 | $93 |
87
|
| custom SHORT | 6 | 30 | 5610 | $523,706 | $93 |
86
|
| personalized | 12 | 21 | 4664 | $450,308 | $97 |
84
|
| cherry charcuterie | 18 | 4 | 1043 | $97,233 | $93 |
49
|
| walnut charcuterie | 18 | 4 | 1047 | $96,673 | $92 |
49
|
| maple charcuterie | 17 | 4 | 1075 | $98,680 | $92 |
48
|
| walnut cutting board | 20 | 3 | 642 | $63,651 | $99 |
47
|
| cherry cutting board | 20 | 3 | 608 | $60,959 | $100 |
47
|
| maple cutting board | 19 | 3 | 637 | $63,131 | $99 |
46
|
| walnut SHORT | 6 | 10 | 1875 | $174,755 | $93 |
46
|
| cherry SHORT | 6 | 10 | 1833 | $172,333 | $94 |
46
|
| maple SHORT | 5 | 10 | 1902 | $176,618 | $93 |
45
|
| walnut serving tray | 19 | 1 | 111 | $10,892 | $98 |
40
|
| cherry serving tray | 19 | 1 | 107 | $10,602 | $99 |
40
|
| maple serving tray | 18 | 1 | 115 | $11,269 | $98 |
39
|
| walnut wine caddy | 17 | 1 | 45 | $2,493 | $55 |
37
|
| cherry wine caddy | 17 | 1 | 45 | $2,493 | $55 |
37
|
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.