Sample data — fictional firm and clients

Pinecrest Mechanical

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

Revenue
$717,309
vs prior year -5.4%
Gross profit
$334,239
Gross margin 46.6%
Net income
$65,681
Net margin 9.2%
Cash
$139,303
As of Sep 2026 month-end
Accounts receivable
$75,301
As of Sep 2026 month-end
Accounts payable
$44,500
As of Sep 2026 month-end

Needs attention (1 flag)

Why each flag fired, and where to look.

  • BookkeepingBooks behind

    No income or expense activity in Sep 2026

    The as-of month has zero income activity and zero expense activity. Not raised when the sync simply has not reached the as-of month yet (that is Stale).

Last 24 months.

Revenue by month
Revenue by monthRevenue: $49,889 in Oct 2024 to $0 in Sep 2026; low $0 in Sep 2026, high $89,472 in Jul 2026.$0$20k$40k$60k$80k$100kMar '25Sep '25Mar '26Sep '26Revenue, Oct 2024: $49,889Revenue, Nov 2024: $53,321Revenue, Dec 2024: $61,542Revenue, Jan 2025: $63,243Revenue, Feb 2025: $55,169Revenue, Mar 2025: $50,090Revenue, Apr 2025: $50,383Revenue, May 2025: $61,802Revenue, Jun 2025: $79,516Revenue, Jul 2025: $87,045Revenue, Aug 2025: $84,287Revenue, Sep 2025: $61,974Revenue, Oct 2025: $50,538Revenue, Nov 2025: $55,086Revenue, Dec 2025: $62,867Revenue, Jan 2026: $67,971Revenue, Feb 2026: $56,635Revenue, Mar 2026: $52,009Revenue, Apr 2026: $51,540Revenue, May 2026: $64,634Revenue, Jun 2026: $79,852Revenue, Jul 2026: $89,472Revenue, Aug 2026: $86,704Revenue, Sep 2026: $0
Net income by month
Net income by monthNet income: $998 in Oct 2024 to $0 in Sep 2026; low $0 in Sep 2026, high $14,956 in Jul 2026.$0$2.5k$5k$7.5k$10k$12.5k$15kMar '25Sep '25Mar '26Sep '26Net income, Oct 2024: $998Net income, Nov 2024: $1,066Net income, Dec 2024: $4,086Net income, Jan 2025: $4,792Net income, Feb 2025: $1,457Net income, Mar 2025: $1,002Net income, Apr 2025: $1,008Net income, May 2025: $3,518Net income, Jun 2025: $11,623Net income, Jul 2025: $14,846Net income, Aug 2025: $12,638Net income, Sep 2025: $4,183Net income, Oct 2025: $1,011Net income, Nov 2025: $2,184Net income, Dec 2025: $4,867Net income, Jan 2026: $6,378Net income, Feb 2026: $2,413Net income, Mar 2026: $1,040Net income, Apr 2026: $1,031Net income, May 2026: $6,048Net income, Jun 2026: $11,664Net income, Jul 2026: $14,956Net income, Aug 2026: $14,089Net income, Sep 2026: $0
Cash at month-end
Cash at month-endCash: $117,396 in Oct 2024 to $139,303 in Sep 2026; low $98,935 in Jan 2025, high $139,303 in Aug 2026.$0$25k$50k$75k$100k$125k$150kMar '25Sep '25Mar '26Sep '26Cash, Oct 2024: $117,396Cash, Nov 2024: $106,340Cash, Dec 2024: $105,442Cash, Jan 2025: $98,935Cash, Feb 2025: $100,847Cash, Mar 2025: $102,106Cash, Apr 2025: $101,306Cash, May 2025: $99,491Cash, Jun 2025: $108,125Cash, Jul 2025: $120,465Cash, Aug 2025: $118,994Cash, Sep 2025: $129,145Cash, Oct 2025: $119,653Cash, Nov 2025: $107,587Cash, Dec 2025: $107,197Cash, Jan 2026: $109,502Cash, Feb 2026: $110,079Cash, Mar 2026: $111,756Cash, Apr 2026: $105,110Cash, May 2026: $106,966Cash, Jun 2026: $116,227Cash, Jul 2026: $129,734Cash, Aug 2026: $139,303Cash, Sep 2026: $139,303

Profit and loss

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

Pinecrest Mechanical 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
$50,538$55,086$62,867$67,971$56,635$52,009$51,540$64,634$79,852$89,472$86,704$0$717,309$758,261
$24,839$26,975$31,594$33,336$27,809$25,631$25,601$31,758$39,849$44,706$42,547$0$354,645$371,863
$21,679$23,725$26,377$29,311$24,217$22,183$21,707$27,583$33,516$37,716$37,140$0$305,155$325,281
Parts & Equipment Sales$2,478$2,795$3,064$3,381$2,825$2,688$2,686$3,342$4,050$4,327$4,354$0$35,992$38,250
Service Call Fees$1,541$1,591$1,832$1,944$1,784$1,507$1,546$1,951$2,437$2,722$2,662$0$21,517$22,868
$27,348$29,364$33,652$36,822$30,579$28,147$28,179$34,000$41,911$47,436$45,634$0$383,070$405,670
Equipment & Materials$11,746$12,547$14,408$15,839$12,943$12,059$11,718$14,586$17,937$20,285$20,072$0$164,140$174,183
Technician Labor$10,248$11,026$12,605$13,840$11,703$10,526$10,844$12,684$15,720$17,807$16,634$0$143,639$151,889
Subcontractors$3,093$3,353$3,833$4,078$3,388$3,213$3,248$3,852$4,605$5,252$5,007$0$42,921$45,587
Permits & Inspection Fees$748$812$951$1,025$848$786$790$969$1,223$1,350$1,301$0$10,803$11,403
Refrigerant & Supplies$1,513$1,625$1,855$2,039$1,696$1,564$1,579$1,909$2,426$2,742$2,619$0$21,567$22,608
Gross Profit$23,191$25,722$29,215$31,150$26,056$23,862$23,361$30,634$37,941$42,036$41,070$0$334,239$352,591
$22,092$23,487$24,353$24,804$23,680$22,858$22,368$24,621$26,313$27,119$27,024$0$268,719$289,242
$7,882$7,952$8,207$8,450$7,970$7,931$7,831$8,368$8,944$9,185$9,129$0$91,849$99,071
$2,417$2,753$2,958$3,065$2,761$2,588$2,469$2,970$3,429$3,629$3,585$0$32,623$34,620
$2,437$2,494$2,584$2,617$2,533$2,458$2,481$2,631$2,815$2,908$2,919$0$28,876$31,375
Advertising & Marketing$1,371$1,981$2,038$2,056$2,018$1,729$1,502$2,090$2,201$2,235$2,283$0$21,504$22,409
Shop & Warehouse Rent$1,670$1,648$1,674$1,673$1,674$1,642$1,713$1,658$1,689$1,662$1,671$0$18,374$20,127
Utilities$497$502$521$521$511$493$499$517$549$545$541$0$5,695$6,155
Telephone & Internet$569$583$581$573$584$569$567$589$571$583$586$0$6,357$7,006
Dispatch & Field Service Software$720$694$724$725$719$717$701$708$705$716$715$0$7,844$8,531
Licenses & Permits$391$393$389$385$382$386$378$390$393$381$383$0$4,251$4,618
$706$708$706$703$709$718$715$694$705$718$711$0$7,795$8,552
Merchant Account Fees$648$681$807$841$724$650$661$811$997$1,161$1,103$0$9,085$9,572
Office Supplies$413$418$443$457$422$429$416$449$486$502$502$0$4,937$5,308
Tools & Small Equipment$429$650$683$711$641$549$470$717$802$858$857$0$7,367$7,769
Training & Certification$232$315$323$317$320$284$253$316$315$321$324$0$3,319$3,571
Bank Service Charges$126$131$131$128$127$129$126$130$129$131$130$0$1,420$1,551
Depreciation Expense$1,584$1,584$1,584$1,584$1,584$1,584$1,584$1,584$1,584$1,584$1,584$0$17,424$19,008
Net Operating Income$1,099$2,236$4,862$6,346$2,377$1,003$994$6,013$11,629$14,917$14,046$0$65,520$63,350
$43$40$36$36$37$37$37$35$36$39$43$0$418$432
Interest Income$43$40$36$36$37$37$37$35$36$39$43$0$418$432
$131$92$31$3$0$0$0$0$0$0$0$0$257$2,565
Interest Expense$131$92$31$3$0$0$0$0$0$0$0$0$257$2,565
Net Other Income-$88-$52$5$33$37$37$37$35$36$39$43$0$161-$2,133
Net Income$1,011$2,184$4,867$6,378$2,413$1,040$1,031$6,048$11,664$14,956$14,089$0$65,681$61,217

Balance sheet

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

Pinecrest Mechanical balance sheet
AccountSep 30, 2026As ofSep 30, 2025A year earlier
$329,393$319,554
$139,303$129,145
Accounts Receivable (A/R)$75,301$65,652
Parts Inventory$21,491$19,562
Prepaid Expenses$19,800$19,800
$66,898$78,795
Security Deposits$6,600$6,600
$78,921$101,241
Accounts Payable (A/P)$44,500$41,566
Business Credit Card$30,665$31,996
Payroll Liabilities$3,756$3,510
$0$24,169
$250,473$218,313
Owner's Investment$39,600$39,600
Retained Earnings$170,508$125,569
Owner's Draw-$17,255-$1,923
Net Income$57,619$55,066
Total Liabilities and Equity$329,393$319,554