Sample data — fictional firm and clients

Coastal Comfort Heating & Air

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

Revenue
$1,367,379
vs prior year +5.2%
Gross profit
$636,095
Gross margin 46.5%
Net income
$147,148
Net margin 10.8%
Cash
$227,505
As of Sep 2026 month-end
Accounts receivable
$428,742
As of Sep 2026 month-end
Accounts payable
$94,522
As of Sep 2026 month-end

Needs attention (1 flag)

Why each flag fired, and where to look.

  • PerformanceAR high

    A/R $428,742 is 2.4x average monthly revenue of $179,249

    Accounts receivable is above 2 x the trailing 3-month average monthly revenue (about 60 days).

    Show the line

Last 24 months.

Revenue by month
Revenue by monthRevenue: $107,217 in Oct 2024 to $148,339 in Sep 2026; low $107,217 in Oct 2024, high $200,897 in Jul 2026.$0$50k$100k$150k$200k$250kMar '25Sep '25Mar '26Sep '26Revenue, Oct 2024: $107,217Revenue, Nov 2024: $113,880Revenue, Dec 2024: $131,395Revenue, Jan 2025: $142,011Revenue, Feb 2025: $122,347Revenue, Mar 2025: $108,723Revenue, Apr 2025: $111,192Revenue, May 2025: $136,472Revenue, Jun 2025: $167,317Revenue, Jul 2025: $190,211Revenue, Aug 2025: $184,406Revenue, Sep 2025: $137,305Revenue, Oct 2025: $112,875Revenue, Nov 2025: $120,626Revenue, Dec 2025: $139,582Revenue, Jan 2026: $148,334Revenue, Feb 2026: $127,566Revenue, Mar 2026: $117,378Revenue, Apr 2026: $114,100Revenue, May 2026: $144,344Revenue, Jun 2026: $177,909Revenue, Jul 2026: $200,897Revenue, Aug 2026: $188,513Revenue, Sep 2026: $148,339
Net income by month
Net income by monthNet income: $2,144 in Oct 2024 to $14,349 in Sep 2026; low $2,144 in Oct 2024, high $36,229 in Jul 2026.$0$10k$20k$30k$40kMar '25Sep '25Mar '26Sep '26Net income, Oct 2024: $2,144Net income, Nov 2024: $2,278Net income, Dec 2024: $7,756Net income, Jan 2025: $11,912Net income, Feb 2025: $4,525Net income, Mar 2025: $2,174Net income, Apr 2025: $2,224Net income, May 2025: $10,525Net income, Jun 2025: $22,479Net income, Jul 2025: $31,246Net income, Aug 2025: $27,216Net income, Sep 2025: $10,558Net income, Oct 2025: $2,258Net income, Nov 2025: $4,686Net income, Dec 2025: $12,182Net income, Jan 2026: $14,482Net income, Feb 2026: $6,662Net income, Mar 2026: $3,083Net income, Apr 2026: $2,282Net income, May 2026: $12,850Net income, Jun 2026: $25,131Net income, Jul 2026: $36,229Net income, Aug 2026: $32,080Net income, Sep 2026: $14,349
Cash at month-end
Cash at month-endCash: $249,340 in Oct 2024 to $227,505 in Sep 2026; low $187,923 in Jul 2025, high $260,574 in Oct 2025.$0$50k$100k$150k$200k$250k$300kMar '25Sep '25Mar '26Sep '26Cash, Oct 2024: $249,340Cash, Nov 2024: $228,880Cash, Dec 2024: $226,506Cash, Jan 2025: $208,856Cash, Feb 2025: $213,601Cash, Mar 2025: $202,367Cash, Apr 2025: $221,444Cash, May 2025: $222,142Cash, Jun 2025: $203,871Cash, Jul 2025: $187,923Cash, Aug 2025: $192,023Cash, Sep 2025: $209,696Cash, Oct 2025: $260,574Cash, Nov 2025: $238,493Cash, Dec 2025: $236,109Cash, Jan 2026: $218,774Cash, Feb 2026: $234,904Cash, Mar 2026: $235,137Cash, Apr 2026: $232,388Cash, May 2026: $237,750Cash, Jun 2026: $222,126Cash, Jul 2026: $205,241Cash, Aug 2026: $203,361Cash, Sep 2026: $227,505

Profit and loss

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

Coastal Comfort Heating & Air profit and loss by month
AccountOct '25Nov '25Dec '25Jan '26Feb '26Mar '26Apr '26May '26Jun '26Jul '26Aug '26Sep '26YTDJan–Sep 2026Prior yearJan–Sep 2025
$112,875$120,626$139,582$148,334$127,566$117,378$114,100$144,344$177,909$200,897$188,513$148,339$1,367,379$1,299,984
$53,700$58,582$67,184$72,455$61,939$57,253$56,829$71,944$87,886$97,787$91,690$73,538$671,319$638,858
$49,930$52,704$60,915$64,027$55,520$51,037$48,169$60,943$76,073$87,184$81,499$63,123$587,575$557,323
Parts & Equipment Sales$5,826$5,821$7,242$7,465$6,328$5,716$5,615$7,100$8,671$9,783$9,554$7,271$67,503$64,706
Service Call Fees$3,419$3,519$4,240$4,387$3,780$3,372$3,488$4,358$5,278$6,143$5,771$4,407$40,983$39,097
$61,882$64,660$74,588$79,619$69,133$63,518$61,563$78,137$95,504$105,297$98,522$79,992$731,285$696,916
Equipment & Materials$26,443$27,435$32,299$34,023$29,963$27,416$25,978$33,442$41,831$45,313$42,431$34,193$314,589$299,588
Technician Labor$23,309$24,515$27,672$30,059$25,530$23,591$23,523$29,452$34,901$39,073$36,670$30,198$272,997$260,828
Subcontractors$6,995$7,315$8,455$8,780$7,894$7,266$6,965$8,810$10,709$11,941$10,894$8,953$82,211$77,928
Permits & Inspection Fees$1,690$1,793$2,045$2,263$1,914$1,734$1,705$2,138$2,687$3,023$2,815$2,185$20,464$19,582
Refrigerant & Supplies$3,444$3,601$4,117$4,494$3,832$3,511$3,392$4,293$5,377$5,948$5,712$4,464$41,023$38,989
Gross Profit$50,993$55,966$64,993$68,715$58,433$53,860$52,537$66,207$82,404$95,600$89,991$68,347$636,095$603,068
$48,332$50,916$52,666$54,149$51,704$50,738$50,237$53,422$57,353$59,444$57,980$54,065$489,093$475,493
$17,016$17,195$17,687$18,401$17,485$17,130$17,225$18,066$19,394$20,067$19,525$18,396$165,689$162,148
$5,274$5,921$6,338$6,496$6,041$5,732$5,586$6,481$7,393$7,969$7,605$6,654$59,957$57,405
$5,307$5,438$5,660$5,835$5,583$5,393$5,360$5,646$6,141$6,345$6,185$5,832$52,321$51,241
Advertising & Marketing$3,133$4,157$4,335$4,464$4,244$4,212$4,140$4,530$4,840$4,960$4,909$4,444$40,744$37,131
Shop & Warehouse Rent$3,685$3,628$3,650$3,708$3,644$3,709$3,574$3,576$3,683$3,735$3,576$3,641$32,846$32,760
Utilities$1,069$1,085$1,115$1,149$1,087$1,074$1,092$1,129$1,177$1,222$1,189$1,099$10,217$10,103
Telephone & Internet$1,280$1,264$1,249$1,292$1,263$1,265$1,238$1,252$1,287$1,255$1,255$1,285$11,391$11,417
Dispatch & Field Service Software$1,534$1,538$1,576$1,572$1,506$1,537$1,525$1,553$1,523$1,510$1,577$1,505$13,807$13,980
Licenses & Permits$835$849$824$825$829$851$850$862$861$835$851$825$7,589$7,617
$1,568$1,555$1,555$1,549$1,560$1,530$1,535$1,532$1,536$1,572$1,510$1,536$13,860$13,845
Merchant Account Fees$1,356$1,464$1,710$1,805$1,593$1,470$1,388$1,805$2,201$2,448$2,370$1,807$16,887$15,945
Office Supplies$890$919$949$959$940$943$903$983$1,059$1,101$1,078$972$8,938$8,856
Tools & Small Equipment$1,009$1,352$1,497$1,548$1,402$1,361$1,305$1,488$1,711$1,901$1,798$1,532$14,045$12,761
Training & Certification$544$718$688$709$691$694$686$684$718$689$714$710$6,293$5,810
Bank Service Charges$280$280$283$286$284$285$279$283$279$282$286$277$2,540$2,506
Depreciation Expense$3,552$3,552$3,552$3,552$3,552$3,552$3,552$3,552$3,552$3,552$3,552$3,552$31,968$31,968
Net Operating Income$2,661$5,050$12,327$14,566$6,729$3,122$2,299$12,785$25,052$36,155$32,011$14,282$147,002$127,576
$70$87$80$79$73$78$78$77$79$74$68$68$675$626
Interest Income$70$87$80$79$73$78$78$77$79$74$68$68$675$626
$473$451$225$163$140$118$96$12$0$0$0$0$529$5,342
Interest Expense$473$451$225$163$140$118$96$12$0$0$0$0$529$5,342
Net Other Income-$403-$364-$146-$84-$67-$40-$17$65$79$74$68$68$146-$4,716
Net Income$2,258$4,686$12,182$14,482$6,662$3,083$2,282$12,850$25,131$36,229$32,080$14,349$147,148$122,859

Balance sheet

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

Coastal Comfort Heating & Air balance sheet
AccountSep 30, 2026As ofSep 30, 2025A year earlier
$926,741$892,918
$227,505$209,696
Accounts Receivable (A/R)$428,742$411,570
Parts Inventory$44,682$42,182
Prepaid Expenses$44,400$44,400
$166,612$170,270
Security Deposits$14,800$14,800
$167,171$248,982
Accounts Payable (A/P)$94,522$86,228
Business Credit Card$64,799$67,702
Payroll Liabilities$7,850$7,702
$0$87,349
$759,570$643,936
Owner's Investment$88,800$88,800
Retained Earnings$533,747$435,685
Owner's Draw-$10,126-$3,408
Net Income$147,148$122,859
Total Liabilities and Equity$926,741$892,918