Sample output from the P&L Flux Analysis with Automated Variance Explanations prompt in the Sonar AI Prompt Library, run against a NetSuite test account. Every name and number here is test data. Back to the post · The library
Financial Intelligence · Automated Variance Analysis · v2

P&L Flux Analysis

June 2026 vs. May 2026 — full-population GL review with trailing-12-month trend context, price/volume/mix decomposition, dimensional segmentation, and document-level evidence links.
11,352GL lines in flux census (100%)
12 monthstrend context (Jul 25–Jun 26)
49P&L accounts
Jul 28, 2026Report date
Sonar AIPrepared by

CFO Summary — the month in 20 seconds

June 2026: Net income $694.0K, +13.0% MoM — real growth of ~+10% after stripping two one-time items.

  1. Two documents distort the month. A $130.3K rent-coded vendor bill (ACME INV-2024-1848) inflated OpEx +64%; a $100.4K undocumented inventory adjustment (IA49) credited COGS and inflated gross margin to 68.8%. Normalized GM is ~59.6% and normalized operating income ~$674K (+9.8%).
  2. All revenue growth came from new products. Price/volume/mix decomposition: new SKUs +$81.6K (HUM100CTP/CTG), existing-product volume −$12.1K, price −$3.2K. Core volume contracted ~2% — growth quality depends on the new-product pipeline.
  3. Four customers churned an identical ~$38.0K each (~$152K/month, ~$1.8M annualized at risk) — the identical magnitude points to one lapsed recurring order type; a targeted win-back is high-leverage.
  4. The G&A “savings” are an allocation artifact, not cuts. All ~25 discretionary accounts declined exactly −19.4% because they are booked by topside allocation journals (no vendor bills, no departments) using a single ratio. Real cash OpEx discipline is unproven.
  5. The business step-changed in May 2026. Revenue ran $500–640K/month for ten months, then jumped to $1.35M in May (+118%) with GM up ~17 pts. June extends that new plateau (+4.6%); this flux compares two post-shift months.
P1 — before close: Validate ACME bill INV-2024-1848 ($130,294) coding to 6610 Rent. The “INV-2024” numbering on a June 2026 bill is itself anomalous. Open bill →
P1 — before close: Document inventory adjustment IA49 ($100,449 credit to 5070). It moves gross margin ~7 pts alone; June GM is provisional until resolved. Open adjustment →

1Executive Summary — Reported vs. Normalized

The comparative P&L is shown twice: as reported, and normalized to remove the incremental effect of the two flagged one-time items (ACME rent bill beyond its May comparable; 5070 inventory-adjustment credits beyond May’s level).

Revenue
$1.411M
▲ +$61.7K (+4.6%)
Gross Margin (rep.)
68.8%
normalized: 59.6%
OpEx (rep.)
$277.2K
normalized: $166.9K
Net Income (rep.)
$694.0K
▲ +13.0%
Net Income (norm.)
$675.8K
▲ +10.0% like-for-like
Jun 2026 ReportedJun 2026 NormalizedMay 2026Δ ReportedΔ NormalizedJun 2025 (YoY)
Revenue (net)1,410,5391,410,5391,348,861+61,678 (+4.6%)+61,678 (+4.6%)632,539
Cost of Goods Sold440,603569,182566,173−125,570+3,009 (+0.5%)317,805
Gross Profit969,936841,357782,688+187,248+58,669 (+7.5%)314,734
Gross Margin %68.8%59.6%58.0%+10.7 pts+1.6 pts49.8%
Operating Expenses277,209166,915168,642+108,568−1,727 (−1.0%)129,048
Operating Income692,727674,442614,046+78,681 (+12.8%)+60,396 (+9.8%)185,686
Other Income / (Exp.), net1,3121,312382+930+930(1,287)
Net Income694,038675,754614,428+79,610 (+13.0%)+61,326 (+10.0%)184,399
Normalization removes the incremental effect vs. May of: ACME rent bill ($130,294 − $20,000 May comparable = $110,294 OpEx) and 5070 inventory-adjustment credits ($174,445 − $45,866 = $128,579 COGS credit). May is presented as reported; its own $45.9K of 5070 credits and $20K ACME bill are treated as run-rate. Tax effects not modeled.

2Trailing-12-Month Trend — the May 2026 step-change

The trend view reveals what a two-month flux cannot: the business operated at a stable $500–640K/month for ten consecutive months, then step-changed in May 2026 to a ~$1.4M plateau with structurally higher gross margin. June is the second month of the new regime.

$1.5M$1.0M$500K0 70%57%43%30% Jul 2025: $500.2K rev, 42.8% GM Aug 2025: $619.0K rev, 39.4% GM Sep 2025: $624.9K rev, 35.2% GM Oct 2025: $638.0K rev, 34.7% GM Nov 2025: $638.3K rev, 34.0% GM Dec 2025: $590.3K rev, 37.6% GM Jan 2026: $590.2K rev, 36.9% GM Feb 2026: $540.3K rev, 37.5% GM Mar 2026: $579.4K rev, 34.5% GM Apr 2026: $619.6K rev, 40.8% GM May 2026: $1,348.9K rev, 58.0% GM — step-change Jun 2026: $1,410.5K rev, 68.8% GM (reported) ← stable $500–640K × 10 months step-change → JulAugSepOct NovDecJan ’26Feb MarAprMayJun Bars = revenue (left axis) · line = gross margin % (right axis) · hover bars for values · Jun GM shown as reported (68.8%); normalized ~59.6%
Finding (new in v2): The May 2026 step-change (+118% revenue MoM, +17 GM pts) coincides with the appearance of a stable ~$150K/month journal-posted revenue block and a set of large, identically-quantified (12 units/month) big-ticket catalog items present in both May and June. This pattern is consistent with a new business line, channel, or entity coming online in May — management should confirm the source so the new plateau can be forecast with confidence. Other income also flipped from a stable −$5.9K/month to positive in May.

3Net Income Bridge — May → June 2026

The waterfall decomposes the +$79.6K net-income change. Amber denotes the inventory-adjustment swing flagged for documentation review.

$850K$800K$750K $700K$650K$600K$550K Net income May 2026: $614.4K Revenue growth: +$69.9K (4110 + 4120) Sales discounts: −$8.2K 5070 inventory adjustment credit: +$128.6K — flagged Other COGS: −$3.0K Rent 6610: −$111.0K — flagged Other OpEx: +$2.4K Other income: +$0.9K Net income Jun 2026: $694.0K 614.4 +69.9 −8.2 +128.6 −3.0 −111.0 +2.4 +0.9 694.0 Net IncomeMay 2026 Revenuegrowth Salesdiscounts Inventory adj.credit (5070) ⚑ OtherCOGS Rent(6610) ⚑ OtherOpEx Otherincome Net IncomeJun 2026 All values $ thousands · ⚑ = flagged one-time / anomalous item · hover bars for detail

4Revenue Quality — Price / Volume / Mix Bridge

Line-level decomposition of the +$69.0K gross revenue change (account 4110, 111 item groups). The result reframes the growth story: new products contributed +$81.6K while the existing portfolio contracted.

$1.45M$1.40M$1.35M$1.30M May 2026 gross revenue: $1,349.3K New SKUs: +$81.6K (HUM100CTP +$41.2K, HUM100CTG +$41.2K, rebate −$0.7K) Journal / non-item revenue: +$2.8K Volume effect, existing items: −$12.1K Price/rate effect, existing items: −$3.3K Jun 2026 gross revenue: $1,418.3K 1,349.3 +81.6 +2.8 −12.1 −3.3 1,418.3 May 2026 New SKUs(HUM100 launch) Journal /non-item Volume(existing) Price(existing) Jun 2026 Account 4110 gross revenue, $ thousands · y-axis truncated at $1.30M for readability · volume = Δqty × May rate; price = Δrate × Jun qty
Interpretation: Headline +5.1% revenue growth is entirely attributable to the HUM100-series launch. The existing catalog declined −1.1% ($15.4K) on softer volume (−0.9%) and slightly lower realized rates (−0.2%). No items were fully discontinued (lost-item effect $0). Combined with June’s first-ever sales discounts ($8.2K) and 10× wider purchase-price variance on the new assemblies, the quality of growth warrants attention: sustaining the plateau requires either core-volume stabilization or continued new-SKU velocity.

Revenue movement by customer (top 15 by absolute change)

Oozz Incorporated+68.0 Nightingale Senior Center+65.9 Meetz inc.+50.1 Keller PR−38.0 Oyope Industries−38.0 Tincidunt Ltd Industries−38.0 Phasellus Vitae Mauris Inc.−37.9 Smith Pacific Northwest Store+37.7 Photolist Foundation ★+32.0 Snaptags Consulting ★+24.4 Realpoint Co. ★+24.4 Yahl Markets Incorporated−19.0 Wapp Hardware Sales−19.0 Viva Cafe+16.2 Vestibulum Lorem Sit LLP ★+16.0 $ thousands, account 4110 · ★ = new revenue in June (zero in May) · lighter green = new logo

5Key Variance Drivers — Transaction-Level Evidence

Click any driver header to expand/collapse. Source-document links open the record in NetSuite.

Driver 1 · Rent Expense (6610) — one-time vendor bill [−]

Unfavorable −$110,961

Rent expense jumped from $31.3K to $142.3K (+354%). Segmentation by transaction type isolates it precisely: journal-posted rent was stable ($7.3K → $8.0K) while vendor-bill rent went from $24.0K to $134.3K — all of it one document: ACME Industries bill INV-2024-1848, 6/10/2026, $130,294, 6.5× the comparable May bill. Possible explanations: annual CAM/escalation true-up, prepaid-rent misclassification, or coding error. The “INV-2024-” numbering on a 2026 bill is independently anomalous.

PeriodTypeDocumentEntityAmount
JunVendor BillINV-2024-1848 (6/10)ACME Industries130,294.00
JunJournal47 (6/1)6,000.00
JunVendor Bill1758655909 (6/1)Landlord Ltd.4,000.00
JunJournalJE87 (6/1)2,000.00
MayVendor Bill(no doc #) (5/10)ACME Industries20,000.00
MayJournal + bills46, JE86, 1758655917Various11,333.33

Driver 2 · COGS – Finished Goods (5070) — inventory adjustment credits [−]

Favorable — quality flag +$128,579

Account 5070 carried a net credit of $174.4K in June vs. $45.9K in May — entirely from inventory adjustments, not trading. June posted three large same-day (6/1) adjustments: IA49 ($100,449), IA02 ($40,000), IA10 ($25,746); IA49 alone exceeds all of May’s activity. These credits reduce reported COGS and account for the entire GM jump to 68.8%. Core trading COGS (5010 Purchases, 5,671 lines) was flat at +0.3% — underlying unit margins did not improve. Until IA49 is documented, June margin should not be treated as a new baseline.

PeriodDocumentDateCredit to COGS
JunIA496/1100,449.00
JunIA026/140,000.00
JunIA106/125,745.60
JunIA40, IA45, IA416/15–6/208,250.00
MayIA015/140,000.00
MayIA50, IA525/10–5/245,866.00

Driver 3 · Revenue (4110) — new-SKU-driven growth over a contracting core [−]

Favorable +$69,024

Gross revenue grew +5.1% across 5,027 invoice lines. The PVM bridge (Section 4) shows the composition: new SKUs +$81.6K (HUM100CTP/CTG, 200 units each at $205.80), journal/non-item revenue +$2.8K, existing-item volume −$12.1K, price −$3.3K. By customer: Oozz Incorporated (+$68.0K), Nightingale Senior Center (+$65.9K), Meetz inc. (+$50.1K) led; $80.7K of entirely new revenue from Photolist Foundation, Snaptags Consulting, Realpoint Co. Offsetting: four accounts each dropped an identical ~$37,990 (Keller PR, Oyope, Tincidunt, Phasellus Vitae Mauris) — one lapsed recurring order type, specific and recoverable.

Driver 4 · G&A “discipline” — RESOLVED: topside allocation artifact [−]

Explained +$6.6K

v1 flagged the uniform −19.4% decline across ~25 discretionary G&A accounts as a hypothesis. Dimensional segmentation now confirms it: every affected account is booked exclusively via journal entries with no department, vendor, or bill attached — a monthly topside allocation set, with one ratio (×0.8056) applied uniformly in June. No vendor-bill activity exists in these accounts in either month. Implications: (1) the “savings” reflect an allocation-model input change, not cash cost reduction; (2) forecasting these lines requires knowing the allocation driver; (3) only depreciation (68xx) carries department coding (Marketing, Operations, Administration, Products, Engineering) — expense departmentalization is otherwise absent from the ledger.

Driver 5 · Sales Discounts (4130) [−]

Unfavorable −$8,232

Discounting appeared for the first time in June — 20 GL lines vs. zero in May, concurrent with the new-logo wins. Individually immaterial; monitor as a leading indicator of pricing pressure on the new revenue plateau.

Driver 6 · Bad Debt (6691/6692) [−]

Unfavorable −$4,000 net

June recorded a $5,000 write-off via customer credit to 6691 vs. $1,000 in May to 6692. Write-offs in consecutive months merit a collections-process check, especially as the customer base scales post-step-change.

Driver 7 · Purchase Price Variance (5071) [−]

Unfavorable −$3,388

PPV widened 10× ($337 → $3,726 across 72 lines), consistent with input-cost pressure on the HUM100-series builds that drove all of June’s revenue growth. Refresh standard costs after the first full production cycle — the growth engine’s true margin is currently understated by stale standards.

Driver 8 · Operating leverage (YoY) [−]

Favorable Structural

Vs. June 2025, revenue is 2.2× ($632.5K → $1,410.5K) while salaries are flat and normalized OpEx grew only ~29% ($129.0K → $166.9K). Normalized operating margin expanded from ~29% to ~48% YoY — substantial operating leverage, assuming the May step-change revenue is durable.

6Recommended Actions

P1 · Close

Validate ACME Industries bill INV-2024-1848 ($130,294) before period close

Confirm the GL coding to 6610 Rent. If an annual true-up, consider reclassing to prepaid and amortizing; if miscoded, correct in-period. Largest single-document risk in the month (moves OpEx 64% alone). Reconcile the anomalous “INV-2024” numbering on a June 2026 bill. Open bill →

Owner: AP / Controller · Impact: $110.3K OpEx · Evidence: Driver 1
P1 · Close

Obtain supporting documentation for inventory adjustment IA49 ($100,449)

IA49 credits COGS and moves gross margin ~7 pts by itself. Determine whether it is a cycle-count true-up, standard-cost revaluation, or error correction — and whether the three same-day 6/1 adjustments (IA49, IA02, IA10, $166K combined) are related. Do not communicate 68.8% GM externally until resolved; use normalized 59.6%. Open adjustment →

Owner: Cost Accounting / Inventory Control · Impact: $128.6K COGS, 10.7 GM pts · Evidence: Driver 2
P2 · 2 wks

Confirm the source and durability of the May 2026 revenue step-change

Revenue jumped +118% in May after ten stable months, carried by a ~$150K/month journal-posted revenue block and a set of large fixed-quantity catalog items. Identify the underlying business event (new channel, entity, contract, or integration go-live) and validate that the journal-posted revenue has proper support — the entire FY26 forecast hinges on this plateau being real and recurring.

Owner: CFO / FP&A · Impact: ~$780K/month revenue base · Evidence: Section 2
P2 · 2 wks

Sales win-back on four lapsed ~$38.0K accounts

Keller PR, Oyope Industries, Tincidunt Ltd, and Phasellus Vitae Mauris each dropped an identical ~$37,990 — almost certainly the same lapsed recurring order type. Combined annualized revenue at risk: ~$1.8M. Especially important given core volume is already contracting (Section 4).

Owner: Sales leadership · Impact: $152K/month at risk · Evidence: Drivers 3, Section 4
P2 · 2 wks

Set discounting policy before the practice hardens

June introduced $8.2K of sales discounts (from zero), concurrent with new-logo wins. Establish approval thresholds now and track discount % of gross revenue as a standing KPI.

Owner: Sales Ops / CFO · Evidence: Driver 5
P3 · Month

Refresh HUM100-series standard costs; document the G&A allocation model

PPV widened 10× alongside the HUM100 launch — refresh standards after the first full production cycle so the new products’ true margin is visible. Separately, document the topside G&A allocation model (driver, ratio source, owner) now confirmed as the sole mechanism behind the −19.4% pattern, and consider department-coding operating expenses to enable dimensional reporting (only depreciation is departmentalized today).

Owner: Cost Accounting / FP&A · Evidence: Drivers 4, 7

7Appendix A — Complete Account-Level Flux (49 accounts)

Expenses shown as positive costs; parentheses denote net credit balances. Variance colors reflect direction of effect on net income. n/m = not meaningful (zero base).

Click a column header to sort.
Acct Account Jun 2026 May 2026 Variance % GL Lines
Income
4110Sales : Revenue1,418,3021,349,278+69,024+5.1%5,027
4120Sales Returns & Allowances469(417)+886n/m5
4130Sales Discounts(8,232)0−8,232n/m20
Cost of Goods Sold
5000Cost of Goods Sold (parent)(2,236)(1,518)−718+47.3%28
5010Purchases610,287608,558+1,729+0.3%5,671
5020Direct Labor & Overtime4,7644,677+87+1.9%4
5030Inventory Variance(508)0−508n/m24
5040Purchases Returns & Allowances15(15)+31n/m2
5070COGS – Finished Goods ⚑(174,445)(45,866)−128,579+280.3%11
5071Purchase Price Variance3,726337+3,388+1004%72
5077Manufacturing WIP(1,000)0−1,000n/m1
Operating Expenses
6060Advertising4,3385,385−1,047−19.4%4
6070Commission Expense24,44424,000+444+1.9%4
6210Salaries & Wages57,74357,74300.0%4
6230Payroll Expenses3,5503,496+53+1.5%6
6240Supplies Expense694862−168−19.4%4
6250Automobile Expense781969−188−19.4%4
6260Training Expense2,1692,692−524−19.4%4
6311Insurance – Liability1,7352,154−419−19.4%4
6312Insurance – Workers’ Comp723897−175−19.4%4
6320Dues & Subscriptions607754−147−19.4%4
6330Bank Service Charges434538−105−19.4%4
6340Postage & Delivery9541,185−230−19.4%4
6360Miscellaneous Expense(15)0−15n/m1
6370Legal Fees390485−94−19.4%4
6410Business Meals & Entertainment463574−112−19.4%4
6420T&E – Accommodations1,4461,795−349−19.4%4
6430T&E – Airfare2,3142,872−558−19.4%4
6440T&E – Meals, Employees1,1571,436−279−19.4%4
6450T&E – Parking & Tolls5872−14−19.4%4
6460T&E – Taxi & Car Rental347431−84−19.4%4
6470Professional Fees2,1692,692−524−19.4%4
6480Outside Services477592−115−19.4%4
6610Rent Expense ⚑142,29431,333+110,961+354.1%9
6620Equipment Rental289359−70−19.4%4
6630Repairs & Maintenance434538−105−19.4%4
6640Utilities723897−175−19.4%4
6655Computer – Office Expense1,7352,154−419−19.4%4
6671Telephone – Regular Service1,4461,795−349−19.4%4
6672Telephone – Internet8681,077−209−19.4%4
6673Telephone – Cellular578718−140−19.4%4
6674Telephone – Online Fees1,1571,436−279−19.4%4
6691Bad Debt – Advertising Charge5,0000+5,000n/m2
6692Bad Debt – Damaged01,000−1,000−100%1
6820Depr – Furniture & Fixtures3,7503,75000.0%4
6830Depr – Automotive1,6671,66700.0%4
6870Depr – Leasehold Improvements10,29210,29200.0%8
Other Income / (Expense)
7000Other Income8,8627,882+980+12.4%335
7500Gain (Loss) on Sale of Assets(7,550)(7,500)−50+0.7%5

⚑ = flagged item discussed in Section 5. A machine-readable CSV of this table accompanies the report (pl-flux-jun-vs-may-2026.csv).

8Appendix B — Flagged-Document Evidence Register

Every document cited in this report, with a direct link into the NetSuite record for one-click review. Links require an active NetSuite session with permission to view the record.

DocumentTypeDateEntityAccountAmountRelevance
INV-2024-1848Vendor Bill6/10/26ACME Industries6610 Rent130,294.00P1 One-time rent spike; anomalous doc numbering
IA49Inventory Adj.6/1/265070 COGS-FG100,449.00 crP1 Undocumented; drives GM +7 pts
IA02Inventory Adj.6/1/265070 COGS-FG40,000.00 crSame-day cluster with IA49/IA10
IA10Inventory Adj.6/1/265070 COGS-FG25,745.60 crSame-day cluster with IA49/IA02
IA01Inventory Adj.5/1/265070 COGS-FG40,000.00 crMay comparable; monthly $40K pattern with IA02
IA40 / IA41 / IA45Inventory Adj.6/15–205070 COGS-FG8,250.00 crMinor June adjustments
IA50 / IA52Inventory Adj.5/10–245070 COGS-FG5,866.00 crMinor May adjustments
1758655909Vendor Bill6/1/26Landlord Ltd.6610 Rent4,000.00Recurring monthly rent (normal)
1758655917Vendor Bill5/1/26Landlord Ltd.6610 Rent4,000.00Recurring monthly rent (normal)
47 / JE87Journals6/1/266610 Rent8,000.00Journal-posted rent (stable)
46 / JE86Journals5/1/266610 Rent7,333.33Journal-posted rent (stable)

9Methodology & Limitations

Scope & data source

Analytical definitions

Known limitations

Reproducibility

All figures derive from deterministic SuiteQL aggregations over transactionaccountingline. Re-running the same queries against the same ledger state reproduces every number. Account-level extract: pl-flux-jun-vs-may-2026.csv. The PVM decomposition reconciles to the GL variance to the cent.