Sample data — fictional firm and clients

Rosemary Kitchen — Old TownRosemary Hospitality Group

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

Revenue
$98,987
vs prior year +8.4%
Gross profit
$69,206
Gross margin 69.9%
Net income
-$12,021
Net margin -12.1%
Cash
$140,715
As of Sep 2026 month-end
Accounts receivable
$10,258
As of Sep 2026 month-end
Accounts payable
$34,739
As of Sep 2026 month-end

Needs attention (1 flag)

Why each flag fired, and where to look.

  • PerformanceNet loss

    Net loss of $12,021 for Sep 2026

    Net income is below 0 in the selected period.

    Show the line

Last 24 months.

Revenue by month
Revenue by monthRevenue: $89,294 in Oct 2024 to $98,987 in Sep 2026; low $79,970 in Jan 2025, high $111,666 in Dec 2025.$0$20k$40k$60k$80k$100k$120kMar '25Sep '25Mar '26Sep '26Revenue, Oct 2024: $89,294Revenue, Nov 2024: $91,830Revenue, Dec 2024: $102,020Revenue, Jan 2025: $79,970Revenue, Feb 2025: $80,719Revenue, Mar 2025: $90,260Revenue, Apr 2025: $91,456Revenue, May 2025: $97,752Revenue, Jun 2025: $94,851Revenue, Jul 2025: $91,220Revenue, Aug 2025: $91,483Revenue, Sep 2025: $91,321Revenue, Oct 2025: $97,483Revenue, Nov 2025: $98,993Revenue, Dec 2025: $111,666Revenue, Jan 2026: $85,791Revenue, Feb 2026: $87,735Revenue, Mar 2026: $98,860Revenue, Apr 2026: $99,363Revenue, May 2026: $105,652Revenue, Jun 2026: $103,701Revenue, Jul 2026: $100,403Revenue, Aug 2026: $102,008Revenue, Sep 2026: $98,987
Net income by month
Net income by monthNet income: -$15,790 in Oct 2024 to -$12,021 in Sep 2026; low -$19,395 in Jan 2025, high -$8,101 in Dec 2025.-$20k-$15k-$10k-$5k$0Mar '25Sep '25Mar '26Sep '26Net income, Oct 2024: -$15,790Net income, Nov 2024: -$15,445Net income, Dec 2024: -$11,761Net income, Jan 2025: -$19,395Net income, Feb 2025: -$18,956Net income, Mar 2025: -$15,389Net income, Apr 2025: -$14,615Net income, May 2025: -$13,370Net income, Jun 2025: -$14,439Net income, Jul 2025: -$15,686Net income, Aug 2025: -$14,874Net income, Sep 2025: -$14,505Net income, Oct 2025: -$13,599Net income, Nov 2025: -$11,782Net income, Dec 2025: -$8,101Net income, Jan 2026: -$17,568Net income, Feb 2026: -$17,190Net income, Mar 2026: -$12,292Net income, Apr 2026: -$12,008Net income, May 2026: -$9,833Net income, Jun 2026: -$9,988Net income, Jul 2026: -$11,767Net income, Aug 2026: -$12,389Net income, Sep 2026: -$12,021
Cash at month-end
Cash at month-endCash: $127,735 in Oct 2024 to $140,715 in Sep 2026; low $127,010 in Mar 2025, high $142,399 in Dec 2025.$0$25k$50k$75k$100k$125k$150kMar '25Sep '25Mar '26Sep '26Cash, Oct 2024: $127,735Cash, Nov 2024: $129,855Cash, Dec 2024: $135,944Cash, Jan 2025: $133,563Cash, Feb 2025: $130,398Cash, Mar 2025: $127,010Cash, Apr 2025: $129,802Cash, May 2025: $134,572Cash, Jun 2025: $136,089Cash, Jul 2025: $136,439Cash, Aug 2025: $134,454Cash, Sep 2025: $133,010Cash, Oct 2025: $134,749Cash, Nov 2025: $136,590Cash, Dec 2025: $142,399Cash, Jan 2026: $139,183Cash, Feb 2026: $136,745Cash, Mar 2026: $133,156Cash, Apr 2026: $136,493Cash, May 2026: $140,893Cash, Jun 2026: $141,950Cash, Jul 2026: $142,285Cash, Aug 2026: $141,832Cash, Sep 2026: $140,715

Profit and loss

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

Rosemary Kitchen — Old Town profit and loss by month
AccountOct '25Nov '25Dec '25Jan '26Feb '26Mar '26Apr '26May '26Jun '26Jul '26Aug '26Sep '26MonthSep 2026Prior yearSep 2025
$97,483$98,993$111,666$85,791$87,735$98,860$99,363$105,652$103,701$100,403$102,008$98,987$98,987$91,321
$94,410$95,986$108,401$83,250$85,137$95,856$96,464$102,548$100,466$97,347$98,859$96,020$96,020$88,506
Service Charges & Gratuities$3,073$3,007$3,265$2,541$2,597$3,005$2,899$3,104$3,235$3,056$3,149$2,967$2,967$2,814
$29,596$29,801$33,936$26,075$26,696$29,268$29,646$32,017$30,982$30,219$31,262$29,781$29,781$26,859
$29,596$29,801$33,936$26,075$26,696$29,268$29,646$32,017$30,982$30,219$31,262$29,781$29,781$26,859
Gross Profit$67,887$69,193$77,730$59,716$61,039$69,592$69,716$73,635$72,718$70,183$70,746$69,206$69,206$64,461
$81,530$81,019$85,876$77,331$78,275$81,930$81,768$83,513$82,753$81,998$83,183$81,274$81,274$79,011
$41,497$40,746$44,261$38,763$39,533$41,846$41,702$42,705$41,863$41,687$42,150$41,163$41,163$39,945
$10,635$10,444$10,288$10,417$10,530$10,290$10,341$10,284$10,461$10,396$10,596$10,461$10,461$10,386
$4,673$4,797$4,911$4,620$4,653$4,702$4,822$4,823$4,848$4,833$4,826$4,768$4,768$4,690
Merchant Card Fees$3,407$3,511$3,930$3,040$3,006$3,495$3,433$3,670$3,658$3,538$3,634$3,383$3,383$3,236
Third-Party Delivery Fees$2,423$2,380$2,768$2,138$2,129$2,434$2,408$2,578$2,500$2,451$2,556$2,383$2,383$2,234
Advertising & Marketing$3,446$3,528$3,564$3,345$3,272$3,525$3,417$3,522$3,503$3,519$3,557$3,510$3,510$3,287
Repairs & Maintenance$2,616$2,584$2,724$2,485$2,556$2,643$2,671$2,733$2,685$2,596$2,711$2,588$2,588$2,547
Restaurant Supplies & Smallwares$2,754$2,896$3,073$2,594$2,632$2,840$2,853$2,976$3,006$2,832$2,908$2,840$2,840$2,660
Linen & Uniforms$1,262$1,274$1,428$1,156$1,189$1,283$1,302$1,369$1,335$1,335$1,345$1,327$1,327$1,212
$2,770$2,812$2,897$2,699$2,752$2,820$2,779$2,785$2,876$2,740$2,831$2,798$2,798$2,775
Licenses & Permits$677$671$668$679$659$674$658$657$673$673$663$671$671$674
$1,076$1,082$1,055$1,081$1,073$1,094$1,065$1,090$1,079$1,073$1,078$1,067$1,067$1,084
Music & Entertainment$530$544$543$534$550$535$548$532$524$547$546$533$533$538
Software & POS Subscriptions$1,207$1,198$1,211$1,224$1,191$1,190$1,218$1,233$1,181$1,226$1,221$1,221$1,221$1,186
Bank Service Charges$269$265$269$267$264$271$264$269$274$263$273$273$273$269
Depreciation Expense$2,288$2,288$2,288$2,288$2,288$2,288$2,288$2,288$2,288$2,288$2,288$2,288$2,288$2,288
Net Operating Income-$13,643-$11,827-$8,146-$17,615-$17,236-$12,338-$12,052-$9,878-$10,035-$11,815-$12,436-$12,069-$12,069-$14,549
$44$45$46$47$46$46$44$46$47$47$47$47$47$45
Interest Income$44$45$46$47$46$46$44$46$47$47$47$47$47$45
Net Other Income$44$45$46$47$46$46$44$46$47$47$47$47$47$45
Net Income-$13,599-$11,782-$8,101-$17,568-$17,190-$12,292-$12,008-$9,833-$9,988-$11,767-$12,389-$12,021-$12,021-$14,505

Balance sheet

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

Rosemary Kitchen — Old Town balance sheet
AccountSep 30, 2026As ofSep 30, 2025A year earlier
$515,945$453,769
$140,715$133,010
Accounts Receivable (A/R)$10,258$8,953
Inventory - Food & Beverage$8,070$7,159
Prepaid Expenses$26,000$26,000
$299,703$247,447
Security Deposits$31,200$31,200
$881,753$671,039
Accounts Payable (A/P)$34,739$31,135
Business Credit Card$44,970$40,740
Sales Tax Payable$8,864$8,259
Payroll Liabilities$5,458$5,075
$787,721$585,830
-$365,807-$217,270
Members' Capital$83,200$83,200
Retained Earnings-$333,951-$159,240
Net Income-$115,056-$141,230
Total Liabilities and Equity$515,945$453,769