Sample data — fictional firm and clients

Lantern & Loom Home Goods

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

Revenue
$1,107,376
vs prior year +7.5%
Gross profit
$502,202
Gross margin 45.4%
Net income
$69,537
Net margin 6.3%
Cash
$149,033
As of Sep 2026 month-end
Accounts receivable
$11,391
As of Sep 2026 month-end
Accounts payable
$55,067
As of Sep 2026 month-end

Needs attention (1 flag)

Why each flag fired, and where to look.

  • BookkeepingOpening Balance Equity

    Opening Balance Equity is $4,300 at Sep 2026 month-end (should be 0)

    Opening Balance Equity is not 0 at the as-of month-end.

    Show the line

Last 24 months.

Revenue by month
Revenue by monthRevenue: $89,324 in Oct 2024 to $89,183 in Sep 2026; low $68,291 in Feb 2025, high $141,394 in Dec 2025.$0$25k$50k$75k$100k$125k$150kMar '25Sep '25Mar '26Sep '26Revenue, Oct 2024: $89,324Revenue, Nov 2024: $120,907Revenue, Dec 2024: $134,034Revenue, Jan 2025: $72,052Revenue, Feb 2025: $68,291Revenue, Mar 2025: $73,264Revenue, Apr 2025: $76,484Revenue, May 2025: $80,910Revenue, Jun 2025: $74,594Revenue, Jul 2025: $76,897Revenue, Aug 2025: $82,410Revenue, Sep 2025: $81,292Revenue, Oct 2025: $96,088Revenue, Nov 2025: $129,005Revenue, Dec 2025: $141,394Revenue, Jan 2026: $73,891Revenue, Feb 2026: $73,575Revenue, Mar 2026: $79,695Revenue, Apr 2026: $82,993Revenue, May 2026: $85,593Revenue, Jun 2026: $83,543Revenue, Jul 2026: $83,472Revenue, Aug 2026: $88,945Revenue, Sep 2026: $89,183
Net income by month
Net income by monthNet income: $4,460 in Oct 2024 to $5,491 in Sep 2026; low $1,024 in Feb 2025, high $17,036 in Dec 2025.$0$5k$10k$15k$20kMar '25Sep '25Mar '26Sep '26Net income, Oct 2024: $4,460Net income, Nov 2024: $14,180Net income, Dec 2024: $15,107Net income, Jan 2025: $1,081Net income, Feb 2025: $1,024Net income, Mar 2025: $1,315Net income, Apr 2025: $1,408Net income, May 2025: $3,146Net income, Jun 2025: $1,288Net income, Jul 2025: $1,675Net income, Aug 2025: $3,584Net income, Sep 2025: $2,666Net income, Oct 2025: $5,662Net income, Nov 2025: $16,133Net income, Dec 2025: $17,036Net income, Jan 2026: $1,108Net income, Feb 2026: $1,104Net income, Mar 2026: $2,722Net income, Apr 2026: $3,646Net income, May 2026: $4,220Net income, Jun 2026: $3,342Net income, Jul 2026: $4,397Net income, Aug 2026: $4,676Net income, Sep 2026: $5,491
Cash at month-end
Cash at month-endCash: $132,415 in Oct 2024 to $149,033 in Sep 2026; low $128,161 in May 2025, high $168,072 in Jan 2026.$0$50k$100k$150k$200kMar '25Sep '25Mar '26Sep '26Cash, Oct 2024: $132,415Cash, Nov 2024: $147,845Cash, Dec 2024: $167,926Cash, Jan 2025: $164,551Cash, Feb 2025: $155,593Cash, Mar 2025: $129,854Cash, Apr 2025: $129,351Cash, May 2025: $128,161Cash, Jun 2025: $135,072Cash, Jul 2025: $135,878Cash, Aug 2025: $136,701Cash, Sep 2025: $140,078Cash, Oct 2025: $136,846Cash, Nov 2025: $158,785Cash, Dec 2025: $161,641Cash, Jan 2026: $168,072Cash, Feb 2026: $163,130Cash, Mar 2026: $136,337Cash, Apr 2026: $136,585Cash, May 2026: $139,003Cash, Jun 2026: $145,108Cash, Jul 2026: $145,208Cash, Aug 2026: $145,806Cash, Sep 2026: $149,033

Profit and loss

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

Lantern & Loom Home Goods 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
$96,088$129,005$141,394$73,891$73,575$79,695$82,993$85,593$83,543$83,472$88,945$89,183$1,107,376$1,030,460
$89,611$120,036$131,345$68,549$68,600$73,988$77,447$79,372$77,656$77,640$82,717$82,854$1,029,815$958,391
Shipping Income$6,476$8,969$10,049$5,343$4,975$5,707$5,545$6,220$5,887$5,832$6,228$6,330$77,561$72,069
$53,205$69,115$77,642$40,792$40,521$43,647$45,266$46,738$45,969$44,940$48,849$48,490$605,175$563,504
$53,205$69,115$77,642$40,792$40,521$43,647$45,266$46,738$45,969$44,940$48,849$48,490$605,175$563,504
Gross Profit$42,882$59,890$63,752$33,100$33,054$36,048$37,726$38,854$37,574$38,532$40,096$40,694$502,202$466,956
$37,267$43,803$46,769$32,045$32,006$33,380$34,126$34,680$34,278$34,183$35,469$35,251$433,256$416,587
$13,894$17,537$19,311$10,931$10,853$11,677$11,956$12,494$12,156$12,327$12,873$12,862$158,869$149,315
$5,323$6,986$7,604$4,093$4,041$4,349$4,523$4,686$4,549$4,475$4,904$4,770$60,304$56,366
$5,496$6,099$6,416$5,019$5,107$5,169$5,375$5,302$5,378$5,200$5,471$5,305$65,337$63,761
Contract Labor$2,220$2,626$2,790$2,018$1,944$2,040$2,090$2,103$2,053$2,068$2,106$2,138$26,194$25,201
Warehouse Rent$2,615$2,558$2,514$2,556$2,592$2,621$2,639$2,549$2,577$2,575$2,519$2,575$30,887$31,148
Utilities$421$465$459$411$403$422$422$417$414$415$427$433$5,109$5,064
$2,003$2,023$2,048$1,923$1,962$1,970$1,966$1,966$1,951$1,975$1,962$1,969$23,719$23,386
$848$859$865$851$874$861$850$849$864$847$857$844$10,269$10,256
Insurance$789$754$781$777$758$765$776$765$785$761$761$768$9,241$9,353
Photography & Content$848$954$996$788$790$799$821$828$842$836$838$827$10,167$9,883
Customer Service$702$821$848$619$599$622$642$641$626$630$660$675$8,084$7,832
Travel & Trade Shows$438$424$425$416$431$427$419$434$435$421$434$420$5,125$5,139
Bank Service Charges$175$171$174$168$173$172$170$169$173$171$174$172$2,063$2,060
Office Supplies$344$374$386$323$327$334$326$325$323$331$330$341$4,063$4,000
Depreciation Expense$1,152$1,152$1,152$1,152$1,152$1,152$1,152$1,152$1,152$1,152$1,152$1,152$13,824$13,824
Net Operating Income$5,615$16,088$16,983$1,054$1,048$2,668$3,600$4,174$3,296$4,349$4,628$5,443$68,945$50,369
$47$46$53$54$56$54$45$46$46$48$48$49$592$564
Interest Income$47$46$53$54$56$54$45$46$46$48$48$49$592$564
Net Other Income$47$46$53$54$56$54$45$46$46$48$48$49$592$564
Net Income$5,662$16,133$17,036$1,108$1,104$2,722$3,646$4,220$3,342$4,397$4,676$5,491$69,537$50,933

Balance sheet

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

Lantern & Loom Home Goods balance sheet
AccountSep 30, 2026As ofSep 30, 2025A year earlier
$312,022$290,697
$149,033$140,078
Accounts Receivable (A/R)$11,391$10,525
Inventory Asset$88,460$82,715
Prepaid Expenses$19,200$19,200
$34,338$28,580
Security Deposits$9,600$9,600
$111,614$104,928
Accounts Payable (A/P)$55,067$53,566
Business Credit Card$52,251$47,419
Sales Tax Payable$1,798$1,640
Payroll Liabilities$2,497$2,303
$200,408$185,769
Owner's Investment$76,800$76,800
Opening Balance Equity$4,300$4,300
Retained Earnings$143,500$142,841
Owner's Draw-$54,898-$55,359
Net Income$30,706$17,187
Total Liabilities and Equity$312,022$290,697