Sample data — fictional firm and clients

Pinecrest Mechanical

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

Revenue
$548,817
vs prior year -7.5%
Gross profit
$256,111
Gross margin 46.7%
Net income
$57,619
Net margin 10.5%
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 '26YTDJan–Sep 2026Prior yearJan–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$548,817$593,510
$24,839$26,975$31,594$33,336$27,809$25,631$25,601$31,758$39,849$44,706$42,547$0$271,236$291,031
$21,679$23,725$26,377$29,311$24,217$22,183$21,707$27,583$33,516$37,716$37,140$0$233,374$254,485
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$27,654$30,058
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$16,553$17,936
$27,348$29,364$33,652$36,822$30,579$28,147$28,179$34,000$41,911$47,436$45,634$0$292,707$317,111
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$125,439$136,568
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$109,759$118,390
Subcontractors$3,093$3,353$3,833$4,078$3,388$3,213$3,248$3,852$4,605$5,252$5,007$0$32,642$35,530
Permits & Inspection Fees$748$812$951$1,025$848$786$790$969$1,223$1,350$1,301$0$8,292$8,929
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$16,574$17,695
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$256,111$276,398
$22,092$23,487$24,353$24,804$23,680$22,858$22,368$24,621$26,313$27,119$27,024$0$198,787$219,979
$7,882$7,952$8,207$8,450$7,970$7,931$7,831$8,368$8,944$9,185$9,129$0$67,807$75,226
$2,417$2,753$2,958$3,065$2,761$2,588$2,469$2,970$3,429$3,629$3,585$0$24,496$26,747
$2,437$2,494$2,584$2,617$2,533$2,458$2,481$2,631$2,815$2,908$2,919$0$21,362$23,808
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$16,113$17,246
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$13,382$15,105
Utilities$497$502$521$521$511$493$499$517$549$545$541$0$4,175$4,637
Telephone & Internet$569$583$581$573$584$569$567$589$571$583$586$0$4,624$5,251
Dispatch & Field Service Software$720$694$724$725$719$717$701$708$705$716$715$0$5,706$6,392
Licenses & Permits$391$393$389$385$382$386$378$390$393$381$383$0$3,078$3,460
$706$708$706$703$709$718$715$694$705$718$711$0$5,674$6,402
Merchant Account Fees$648$681$807$841$724$650$661$811$997$1,161$1,103$0$6,948$7,483
Office Supplies$413$418$443$457$422$429$416$449$486$502$502$0$3,662$4,031
Tools & Small Equipment$429$650$683$711$641$549$470$717$802$858$857$0$5,605$6,059
Training & Certification$232$315$323$317$320$284$253$316$315$321$324$0$2,449$2,720
Bank Service Charges$126$131$131$128$127$129$126$130$129$131$130$0$1,032$1,157
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$12,672$14,256
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$57,324$56,419
$43$40$36$36$37$37$37$35$36$39$43$0$299$319
Interest Income$43$40$36$36$37$37$37$35$36$39$43$0$299$319
$131$92$31$3$0$0$0$0$0$0$0$0$3$1,671
Interest Expense$131$92$31$3$0$0$0$0$0$0$0$0$3$1,671
Net Other Income-$88-$52$5$33$37$37$37$35$36$39$43$0$296-$1,353
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$57,619$55,066

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