Sample data — fictional firm and clients

Northstar Creative Studio

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

Revenue
$250,383
vs prior year +7.9%
Gross profit
$174,873
Gross margin 69.8%
Net income
$38,262
Net margin 15.3%
Cash
$156,917
As of Sep 2026 month-end
Accounts receivable
$114,018
As of Sep 2026 month-end
Accounts payable
$36,563
As of Sep 2026 month-end

No flags

Nothing is flagged for this client in this period.

Last 24 months.

Revenue by month
Revenue by monthRevenue: $77,440 in Oct 2024 to $88,303 in Sep 2026; low $72,384 in Dec 2024, high $88,303 in Sep 2026.$0$20k$40k$60k$80k$100kMar '25Sep '25Mar '26Sep '26Revenue, Oct 2024: $77,440Revenue, Nov 2024: $75,286Revenue, Dec 2024: $72,384Revenue, Jan 2025: $74,470Revenue, Feb 2025: $76,357Revenue, Mar 2025: $77,081Revenue, Apr 2025: $76,674Revenue, May 2025: $74,886Revenue, Jun 2025: $79,634Revenue, Jul 2025: $75,373Revenue, Aug 2025: $77,786Revenue, Sep 2025: $78,983Revenue, Oct 2025: $79,614Revenue, Nov 2025: $80,012Revenue, Dec 2025: $77,624Revenue, Jan 2026: $80,994Revenue, Feb 2026: $82,734Revenue, Mar 2026: $83,465Revenue, Apr 2026: $81,002Revenue, May 2026: $81,796Revenue, Jun 2026: $83,150Revenue, Jul 2026: $81,524Revenue, Aug 2026: $80,556Revenue, Sep 2026: $88,303
Net income by month
Net income by monthNet income: $9,656 in Oct 2024 to $15,825 in Sep 2026; low $5,864 in Dec 2024, high $15,825 in Sep 2026.$0$5k$10k$15k$20kMar '25Sep '25Mar '26Sep '26Net income, Oct 2024: $9,656Net income, Nov 2024: $8,600Net income, Dec 2024: $5,864Net income, Jan 2025: $8,060Net income, Feb 2025: $8,544Net income, Mar 2025: $9,616Net income, Apr 2025: $8,745Net income, May 2025: $8,607Net income, Jun 2025: $10,731Net income, Jul 2025: $7,641Net income, Aug 2025: $9,541Net income, Sep 2025: $10,529Net income, Oct 2025: $10,842Net income, Nov 2025: $10,718Net income, Dec 2025: $10,234Net income, Jan 2026: $11,413Net income, Feb 2026: $12,005Net income, Mar 2026: $13,438Net income, Apr 2026: $12,078Net income, May 2026: $12,006Net income, Jun 2026: $12,158Net income, Jul 2026: $11,383Net income, Aug 2026: $11,054Net income, Sep 2026: $15,825
Cash at month-end
Cash at month-endCash: $148,412 in Oct 2024 to $156,917 in Sep 2026; low $147,320 in Jan 2025, high $156,917 in Sep 2026.$0$50k$100k$150k$200kMar '25Sep '25Mar '26Sep '26Cash, Oct 2024: $148,412Cash, Nov 2024: $148,973Cash, Dec 2024: $148,694Cash, Jan 2025: $147,320Cash, Feb 2025: $148,334Cash, Mar 2025: $148,640Cash, Apr 2025: $150,091Cash, May 2025: $149,142Cash, Jun 2025: $149,755Cash, Jul 2025: $150,393Cash, Aug 2025: $151,340Cash, Sep 2025: $150,837Cash, Oct 2025: $152,431Cash, Nov 2025: $152,611Cash, Dec 2025: $151,897Cash, Jan 2026: $151,935Cash, Feb 2026: $153,488Cash, Mar 2026: $155,792Cash, Apr 2026: $154,925Cash, May 2026: $154,800Cash, Jun 2026: $155,699Cash, Jul 2026: $155,647Cash, Aug 2026: $156,218Cash, Sep 2026: $156,917

Profit and loss

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

Northstar Creative Studio profit and loss by month
AccountOct '25Nov '25Dec '25Jan '26Feb '26Mar '26Apr '26May '26Jun '26Jul '26Aug '26Sep '26Last full quarterJul–Sep 2026Prior yearJul–Sep 2025
$79,614$80,012$77,624$80,994$82,734$83,465$81,002$81,796$83,150$81,524$80,556$88,303$250,383$232,143
$76,260$76,948$74,600$77,718$79,412$80,072$77,687$78,555$79,803$78,350$77,266$84,844$240,460$222,909
Reimbursable Expenses Billed$3,354$3,064$3,024$3,276$3,322$3,392$3,316$3,241$3,347$3,174$3,290$3,459$9,923$9,234
$24,227$24,011$23,075$24,046$25,089$25,023$24,614$24,713$25,343$24,859$24,565$26,086$75,510$70,378
Freelance Creative$11,379$11,293$10,709$11,195$11,731$11,524$11,538$11,381$11,907$11,627$11,550$12,206$35,383$32,875
Freelance Development$6,433$6,303$6,143$6,369$6,639$6,830$6,556$6,705$6,767$6,698$6,613$6,880$20,191$18,790
Stock Media & Licensing$1,174$1,227$1,177$1,194$1,256$1,268$1,218$1,220$1,239$1,193$1,197$1,297$3,687$3,490
Third-Party Software for Clients$2,030$1,974$1,949$1,999$2,074$2,091$2,025$2,071$2,127$2,002$1,981$2,179$6,162$5,874
Reimbursable Costs$3,211$3,214$3,097$3,288$3,389$3,310$3,277$3,335$3,304$3,339$3,224$3,524$10,087$9,349
Gross Profit$55,387$56,001$54,549$56,948$57,644$58,442$56,388$57,083$57,807$56,665$55,991$62,217$174,873$161,764
$44,595$45,334$44,366$45,585$45,690$45,055$44,363$45,128$45,701$45,334$44,989$46,445$136,767$134,204
$29,153$29,785$29,082$29,998$30,228$29,406$28,846$29,512$30,083$29,855$29,448$30,699$90,002$87,938
Office Rent$3,980$4,051$3,910$4,053$3,906$4,078$3,951$4,085$4,043$3,945$4,020$3,951$11,916$11,951
$2,553$2,627$2,573$2,626$2,601$2,621$2,637$2,593$2,628$2,558$2,591$2,658$7,807$7,743
Advertising & Marketing$1,739$1,711$1,654$1,722$1,738$1,704$1,696$1,700$1,728$1,738$1,716$1,801$5,255$5,076
$1,426$1,434$1,407$1,438$1,462$1,481$1,466$1,460$1,456$1,431$1,478$1,517$4,426$4,276
$1,114$1,130$1,129$1,142$1,107$1,138$1,112$1,126$1,148$1,143$1,112$1,131$3,385$3,381
$1,144$1,120$1,141$1,117$1,132$1,119$1,140$1,137$1,128$1,144$1,132$1,135$3,411$3,433
Utilities & Internet$525$533$524$511$529$527$529$526$510$530$519$522$1,571$1,567
Office Supplies$421$417$431$426$439$432$433$433$435$435$419$438$1,292$1,291
Training$531$513$509$514$516$519$518$524$509$518$530$521$1,570$1,562
Merchant Account Fees$642$648$638$667$677$674$681$678$671$684$668$715$2,066$1,906
Bank Service Charges$173$174$172$176$171$173$171$170$173$170$173$177$521$529
Dues & Subscriptions$354$351$355$356$345$343$342$345$350$343$344$339$1,026$1,031
Depreciation Expense$840$840$840$840$840$840$840$840$840$840$840$840$2,520$2,520
Net Operating Income$10,792$10,668$10,183$11,363$11,955$13,387$12,026$11,955$12,106$11,331$11,002$15,773$38,106$27,561
$50$51$51$51$51$51$52$52$52$52$52$52$156$151
Interest Income$50$51$51$51$51$51$52$52$52$52$52$52$156$151
Net Other Income$50$51$51$51$51$51$52$52$52$52$52$52$156$151
Net Income$10,842$10,718$10,234$11,413$12,005$13,438$12,078$12,006$12,158$11,383$11,054$15,825$38,262$27,711

Balance sheet

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

Northstar Creative Studio balance sheet
AccountSep 30, 2026As ofSep 30, 2025A year earlier
$330,300$313,722
$156,917$150,837
Accounts Receivable (A/R)$114,018$106,167
Prepaid Expenses$25,200$25,200
$17,365$14,718
Security Deposits$16,800$16,800
$94,274$85,224
Accounts Payable (A/P)$36,563$32,897
Business Credit Card$37,050$33,153
Payroll Liabilities$3,499$3,469
Deferred Revenue$17,162$15,704
$236,026$228,498
Common Stock$42,000$42,000
Retained Earnings$184,006$181,364
Shareholder Distributions-$101,339-$76,880
Net Income$111,359$82,015
Total Liabilities and Equity$330,300$313,722