Sample data — fictional firm and clients

Lantern & Loom Home Goods

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

Revenue
$89,183
vs prior year +9.7%
Gross profit
$40,694
Gross margin 45.6%
Net income
$5,491
Net margin 6.2%
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 '26MonthSep 2026Prior yearSep 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$89,183$81,292
$89,611$120,036$131,345$68,549$68,600$73,988$77,447$79,372$77,656$77,640$82,717$82,854$82,854$75,380
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$6,330$5,913
$53,205$69,115$77,642$40,792$40,521$43,647$45,266$46,738$45,969$44,940$48,849$48,490$48,490$44,805
$53,205$69,115$77,642$40,792$40,521$43,647$45,266$46,738$45,969$44,940$48,849$48,490$48,490$44,805
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$40,694$36,487
$37,267$43,803$46,769$32,045$32,006$33,380$34,126$34,680$34,278$34,183$35,469$35,251$35,251$33,867
$13,894$17,537$19,311$10,931$10,853$11,677$11,956$12,494$12,156$12,327$12,873$12,862$12,862$12,093
$5,323$6,986$7,604$4,093$4,041$4,349$4,523$4,686$4,549$4,475$4,904$4,770$4,770$4,445
$5,496$6,099$6,416$5,019$5,107$5,169$5,375$5,302$5,378$5,200$5,471$5,305$5,305$5,186
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$2,138$2,085
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$2,575$2,526
Utilities$421$465$459$411$403$422$422$417$414$415$427$433$433$416
$2,003$2,023$2,048$1,923$1,962$1,970$1,966$1,966$1,951$1,975$1,962$1,969$1,969$1,945
$848$859$865$851$874$861$850$849$864$847$857$844$844$854
Insurance$789$754$781$777$758$765$776$765$785$761$761$768$768$762
Photography & Content$848$954$996$788$790$799$821$828$842$836$838$827$827$817
Customer Service$702$821$848$619$599$622$642$641$626$630$660$675$675$649
Travel & Trade Shows$438$424$425$416$431$427$419$434$435$421$434$420$420$433
Bank Service Charges$175$171$174$168$173$172$170$169$173$171$174$172$172$171
Office Supplies$344$374$386$323$327$334$326$325$323$331$330$341$341$333
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$1,152$1,152
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$5,443$2,620
$47$46$53$54$56$54$45$46$46$48$48$49$49$46
Interest Income$47$46$53$54$56$54$45$46$46$48$48$49$49$46
Net Other Income$47$46$53$54$56$54$45$46$46$48$48$49$49$46
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$5,491$2,666

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