Sample data — fictional firm and clients

Trailhead Outfitters Online

Oct 2025–Sep 2026 · Balances as of Sep 30, 2026 · Accrual basis

Revenue
$501,073
vs prior year -40.5%
Gross profit
$226,860
Gross margin 45.3%
Net income
-$28,508
Net margin -5.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 $28,508 for Oct 2025–Sep 2026

    Net income is below 0 in the selected period.

    Show the line
  • PerformanceRevenue down

    Revenue down 40.5% ($340,818) vs Oct 2024–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 '26TTMOct 2025–Sep 2026Prior yearOct 2024–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$501,073$841,891
$64,550$76,136$66,331$29,233$25,060$28,548$28,213$30,114$28,800$27,997$30,724$30,682$466,389$782,484
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$34,684$59,406
$37,483$44,499$39,343$17,603$15,111$16,608$16,529$17,665$16,863$16,604$18,018$17,886$274,213$459,724
$37,483$44,499$39,343$17,603$15,111$16,608$16,529$17,665$16,863$16,604$18,018$17,886$274,213$459,724
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$226,860$382,166
$27,287$30,347$27,840$19,122$17,987$18,678$18,753$19,187$18,938$18,803$19,544$19,201$255,684$332,541
$10,032$11,778$10,409$5,461$4,796$5,234$5,289$5,520$5,380$5,285$5,674$5,535$80,393$124,228
$3,899$4,642$3,979$1,770$1,503$1,721$1,726$1,826$1,724$1,709$1,819$1,838$28,155$47,052
$4,100$4,401$4,093$3,396$3,332$3,311$3,322$3,376$3,427$3,393$3,502$3,355$43,008$49,560
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$16,013$19,905
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$22,977$23,068
Utilities$327$325$325$283$284$279$282$282$293$280$294$292$3,548$3,875
$1,479$1,505$1,484$1,388$1,385$1,398$1,406$1,408$1,381$1,403$1,401$1,394$17,032$17,690
$643$657$634$644$649$641$654$646$647$630$641$635$7,722$7,780
Insurance$577$574$568$589$573$574$569$569$578$578$585$587$6,920$6,927
Photography & Content$643$664$653$548$516$537$534$542$548$525$535$549$6,793$7,743
Customer Service$501$563$524$378$351$368$369$367$378$365$373$370$4,908$6,158
Travel & Trade Shows$325$322$323$321$320$328$324$325$320$315$320$328$3,871$3,842
Bank Service Charges$131$132$128$128$132$127$130$127$131$128$132$128$1,554$1,546
Office Supplies$258$269$260$218$210$210$215$219$209$211$213$218$2,709$3,086
Depreciation Expense$840$840$840$840$840$840$840$840$840$840$840$840$10,080$10,080
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-$28,825$49,626
$36$38$39$41$36$28$22$20$18$17$15$15$326$464
Interest Income$36$38$39$41$36$28$22$20$18$17$15$15$326$464
$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$317$464
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-$28,508$50,090

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