Sample data — fictional firm and clients

Trailhead Outfitters Online

Jan–Sep 2026 · Balances as of Sep 30, 2026 · Accrual basis

Revenue
$279,016
vs prior year -49.5%
Gross profit
$126,128
Gross margin 45.2%
Net income
-$43,880
Net margin -15.7%
Cash
$45,857
As of Sep 2026 month-end
Accounts receivable
$4,331
As of Sep 2026 month-end
Accounts payable
$23,914
As of Sep 2026 month-end

Needs attention (2 flags)

Why each flag fired, and where to look.

  • PerformanceNet loss

    Net loss of $43,880 for Jan–Sep 2026

    Net income is below 0 in the selected period.

    Show the line
  • PerformanceRevenue down

    Revenue down 49.5% ($273,159) vs Jan–Sep 2025

    Revenue is down more than 25% and by at least $5,000 vs the same period last year.

    Show the line

Last 24 months.

Revenue by month
Revenue by monthRevenue: $75,541 in Oct 2024 to $33,018 in Sep 2026; low $26,962 in Feb 2026, high $108,805 in Dec 2024.$0$20k$40k$60k$80k$100k$120kMar '25Sep '25Mar '26Sep '26Revenue, Oct 2024: $75,541Revenue, Nov 2024: $105,370Revenue, Dec 2024: $108,805Revenue, Jan 2025: $57,992Revenue, Feb 2025: $54,363Revenue, Mar 2025: $59,799Revenue, Apr 2025: $62,801Revenue, May 2025: $62,962Revenue, Jun 2025: $62,230Revenue, Jul 2025: $60,791Revenue, Aug 2025: $65,115Revenue, Sep 2025: $66,121Revenue, Oct 2025: $69,146Revenue, Nov 2025: $81,788Revenue, Dec 2025: $71,123Revenue, Jan 2026: $31,444Revenue, Feb 2026: $26,962Revenue, Mar 2026: $30,649Revenue, Apr 2026: $30,327Revenue, May 2026: $32,433Revenue, Jun 2026: $31,037Revenue, Jul 2026: $30,068Revenue, Aug 2026: $33,077Revenue, Sep 2026: $33,018
Net income by month
Net income by monthNet income: $5,962 in Oct 2024 to -$4,063 in Sep 2026; low -$6,100 in Feb 2026, high $13,401 in Nov 2024.-$10k-$5k$0$5k$10k$15kMar '25Sep '25Mar '26Sep '26Net income, Oct 2024: $5,962Net income, Nov 2024: $13,401Net income, Dec 2024: $13,209Net income, Jan 2025: $934Net income, Feb 2025: -$138Net income, Mar 2025: $2,629Net income, Apr 2025: $2,886Net income, May 2025: $2,205Net income, Jun 2025: $2,007Net income, Jul 2025: $1,791Net income, Aug 2025: $2,548Net income, Sep 2025: $2,655Net income, Oct 2025: $4,412Net income, Nov 2025: $6,980Net income, Dec 2025: $3,980Net income, Jan 2026: -$5,239Net income, Feb 2026: -$6,100Net income, Mar 2026: -$4,609Net income, Apr 2026: -$4,933Net income, May 2026: -$4,399Net income, Jun 2026: -$4,745Net income, Jul 2026: -$5,322Net income, Aug 2026: -$4,469Net income, Sep 2026: -$4,063
Cash at month-end
Cash at month-endCash: $115,093 in Oct 2024 to $45,857 in Sep 2026; low $45,321 in Aug 2026, high $141,609 in Dec 2024.$0$25k$50k$75k$100k$125k$150kMar '25Sep '25Mar '26Sep '26Cash, Oct 2024: $115,093Cash, Nov 2024: $126,118Cash, Dec 2024: $141,609Cash, Jan 2025: $139,232Cash, Feb 2025: $126,176Cash, Mar 2025: $104,249Cash, Apr 2025: $103,400Cash, May 2025: $106,773Cash, Jun 2025: $108,607Cash, Jul 2025: $108,881Cash, Aug 2025: $104,861Cash, Sep 2025: $108,119Cash, Oct 2025: $114,874Cash, Nov 2025: $118,376Cash, Dec 2025: $122,859Cash, Jan 2026: $108,499Cash, Feb 2026: $84,228Cash, Mar 2026: $65,166Cash, Apr 2026: $59,784Cash, May 2026: $55,271Cash, Jun 2026: $50,716Cash, Jul 2026: $45,474Cash, Aug 2026: $45,321Cash, Sep 2026: $45,857

Profit and loss

Oct 2025 to Sep 2026 · Accrual basis · Expand parent accounts to see their sub-accounts.

Trailhead Outfitters Online profit and loss by month
AccountOct '25Nov '25Dec '25Jan '26Feb '26Mar '26Apr '26May '26Jun '26Jul '26Aug '26Sep '26YTDJan–Sep 2026Prior yearJan–Sep 2025
$69,146$81,788$71,123$31,444$26,962$30,649$30,327$32,433$31,037$30,068$33,077$33,018$279,016$552,175
$64,550$76,136$66,331$29,233$25,060$28,548$28,213$30,114$28,800$27,997$30,724$30,682$259,372$513,062
Shipping Income$4,596$5,652$4,792$2,211$1,902$2,100$2,114$2,319$2,236$2,071$2,354$2,337$19,644$39,112
$37,483$44,499$39,343$17,603$15,111$16,608$16,529$17,665$16,863$16,604$18,018$17,886$152,888$303,536
$37,483$44,499$39,343$17,603$15,111$16,608$16,529$17,665$16,863$16,604$18,018$17,886$152,888$303,536
Gross Profit$31,663$37,289$31,780$13,841$11,851$14,041$13,798$14,768$14,174$13,464$15,059$15,132$126,128$248,638
$27,287$30,347$27,840$19,122$17,987$18,678$18,753$19,187$18,938$18,803$19,544$19,201$170,211$231,468
$10,032$11,778$10,409$5,461$4,796$5,234$5,289$5,520$5,380$5,285$5,674$5,535$48,174$82,859
$3,899$4,642$3,979$1,770$1,503$1,721$1,726$1,826$1,724$1,709$1,819$1,838$15,635$30,927
$4,100$4,401$4,093$3,396$3,332$3,311$3,322$3,376$3,427$3,393$3,502$3,355$30,414$35,685
Contract Labor$1,632$1,777$1,720$1,216$1,165$1,199$1,182$1,241$1,200$1,207$1,255$1,219$10,885$13,971
Warehouse Rent$1,899$1,898$1,901$1,942$1,932$1,910$1,911$1,897$1,881$1,934$1,959$1,913$17,280$17,264
Utilities$327$325$325$283$284$279$282$282$293$280$294$292$2,570$2,846
$1,479$1,505$1,484$1,388$1,385$1,398$1,406$1,408$1,381$1,403$1,401$1,394$12,564$13,117
$643$657$634$644$649$641$654$646$647$630$641$635$5,788$5,845
Insurance$577$574$568$589$573$574$569$569$578$578$585$587$5,202$5,181
Photography & Content$643$664$653$548$516$537$534$542$548$525$535$549$4,833$5,587
Customer Service$501$563$524$378$351$368$369$367$378$365$373$370$3,319$4,349
Travel & Trade Shows$325$322$323$321$320$328$324$325$320$315$320$328$2,901$2,881
Bank Service Charges$131$132$128$128$132$127$130$127$131$128$132$128$1,163$1,164
Office Supplies$258$269$260$218$210$210$215$219$209$211$213$218$1,923$2,234
Depreciation Expense$840$840$840$840$840$840$840$840$840$840$840$840$7,560$7,560
Net Operating Income$4,376$6,942$3,940-$5,280-$6,136-$4,637-$4,955-$4,419-$4,764-$5,339-$4,484-$4,069-$44,083$17,170
$36$38$39$41$36$28$22$20$18$17$15$15$212$348
Interest Income$36$38$39$41$36$28$22$20$18$17$15$15$212$348
$0$0$0$0$0$0$0$0$0$0$0$9$9$0
Interest Expense$0$0$0$0$0$0$0$0$0$0$0$9$9$0
Net Other Income$36$38$39$41$36$28$22$20$18$17$15$6$203$348
Net Income$4,412$6,980$3,980-$5,239-$6,100-$4,609-$4,933-$4,399-$4,745-$5,322-$4,469-$4,063-$43,880$17,518

Balance sheet

As of Sep 2026 month-end. Highlighted rows feed the Cash, AR and AP figures.

Trailhead Outfitters Online balance sheet
AccountSep 30, 2026As ofSep 30, 2025A year earlier
$126,754$234,687
$45,857$108,119
Accounts Receivable (A/R)$4,331$8,697
Inventory Asset$32,373$66,514
Prepaid Expenses$14,000$14,000
$23,194$30,357
Security Deposits$7,000$7,000
$54,948$82,863
Accounts Payable (A/P)$23,914$41,997
Business Credit Card$22,270$37,728
Sales Tax Payable$664$1,330
Payroll Liabilities$1,119$1,808
$6,981$0
$71,806$151,824
Owner's Investment$56,000$56,000
Retained Earnings$108,041$131,802
Owner's Draw-$48,355-$53,497
Net Income-$43,880$17,518
Total Liabilities and Equity$126,754$234,687