Where the Margin Lives

Five numbers and six findings

1. Revenue mix. Four channels, defined by posting source, earn gross margins of 37.2% (summary journals, product), 56.7% (invoiced), 19.8% (services) and 46.6% (cash sales). The largest channel is not the most profitable. Section 1.
2. Revenue quality. Four invoices memoed "TEST" (INV788–INV791) contribute $281,243 of revenue and $302,717.94 of open receivables with no shipment and no cost of sales. They explain every monthly revenue spike. Adjusted, net income is $882,589.67 (8.4%). Section 2.
3. Customer base. Eight corporate accounts that order in eleven or twelve months of the year supply $701,106.05 — 59.8% of invoiced product revenue. Section 2.
4. Cost structure. Forty-two of forty-six operating expense accounts, and interest expense, share one identical monthly index. $1,484,104.94 (50.5%) of operating expense is an allocation and cannot be managed as posted. Section 3.
5. Subsidiaries. Subsidiary 1 reports 13.6% net margin against 7.2% for Subsidiary 2; the difference is almost entirely direct-channel revenue, and all four TEST invoices sit in Subsidiary 1. Section 4.
6. Since the close. Jan–Aug 2026 revenue is up 18.7% and net income 85.6% on the prior-year period; receivables are up 61.4% and inventory 109.4% since Dec 2025. Section 5.

Thirteen recommendations follow, six on revenue and seven on cost, each sized in dollars or marked "unmeasured", with a named verification step. Assumptions are stated in Section 1 and Appendix C.

Revenue mix: the largest channel is not the most profitable

Split by posting source rather than by account, FY2025 revenue comprises four businesses with gross margins from 19.8% to 56.7%. The printed statement presents 4210 Revenue - Products as a single line of $10,063,960.01.

Revenue quality: four test invoices explain every spike

The summary journals form a stable base between $670,066.68 and $801,166.68 a month. The three months that stand apart — May, September and December — are attributable entirely to the invoiced channel and, within it, to four invoices.

The four invoices

INV791 Mercury Co. $73,976 (May), INV788 Haskell Associates $41,356 (September), INV790 Global Information $101,799 and INV789 Gotter inc. $64,112 (December) total $281,243, or 23.9% of invoiced revenue. Each carries the memo "TEST — customer name", has two item lines, no item fulfillment, no cost of sales, and remains open, with $302,717.94 outstanding including tax. All four were entered in Subsidiary 1 with header location 03: Los Angeles Distribution Center. Excluding them, the invoiced channel ranges between $60,204.98 and $84,992.78 a month: May falls from $158,968.78 to $84,992.78, September from $124,737.33 to $83,381.33 and December from $239,847.86 to $73,936.86.

The customer base behind the invoiced channel

Eight corporate accounts ordered in eleven or twelve months of the year: Jones Manufacturing $178,652.46 (15.2% of invoiced product revenue), Design Excellence Ltd. $111,256.56, Panaderia Co. $101,643.89, Davis Supplies $101,488.06, Realpoint inc. $75,850.29, Recreational Outfitters $51,123.19, Hugo Limited $41,440.26 and Karmabit $39,651.34. Together they placed 93 invoices worth $701,106.05 — 59.8% of invoiced product revenue — with no identifiable acquisition cost. Eight always-on individual customers add $9,565.83. The remaining 25 accounts ordered in two to nine months and total $176,321.03 (15.0%). Four further one-month buyers — Ghetti Ltd $2,577, Schmidt & Sons Consulting $1,616, Jasper and Associates $339 and Kasson Ltd $241 — add $4,773.

Quarterly view

The apparent margin expansion from Q1 to Q4 (34.4% to 40.8%) is largely the TEST invoices, which carry no cost: excluding them the year runs between 34.4% and 37.8%.

Order economics

367 invoices averaged $3,196.21 (median $249.99); 530 cash sales averaged $132.28 (median $69.99). Direct revenue by location: 03: Los Angeles Distribution Center $537,394.69; 05: Miami $305,735.33; 01: San Francisco Store $66,135.83 ($41,063.71 cash sales, $25,072.12 invoiced); 02: New York Store $53,767.74 ($31,156.97 and $22,610.77); $286,016 of one-month invoices carry no line location. Freight was charged at a flat $3.99 on every cash sale ($2,114.70) and $8.50 on 300 invoices, $10.00 on 50, $90.00 on 8 and $50.00 on 1 ($3,820.00 on 359 of 367 invoices) — $5,934.70 in total, unchanged across the year, against 358 item fulfillments and an account 6080 Freight-out that exists but has never been posted to.

Cost structure: half of operating expense moves on one factor

Indexed to January = 100, forty-two of the forty-six operating expense accounts — and 8100 Interest Expense — trace the same twelve-point curve: 100, 78.3, 75.5, 94.7, 98.0, 105.9, 106.9, 86.7, 80.5, 95.5, 104.6, 121.3.

$1,484,104.94 of operating expense — 50.5% — cannot be managed as posted. Travel, IT and telecom, marketing, insurance, professional and outside services, facilities other than rent, training, recruitment, sick leave, dues, bank charges, contributions and amortisation rise and fall together by the same percentage each month. The five accounts fed by vendor bills (Dell US, Brocade Communications Systems US, Staples US, XCOM US and CDW US, 24 bills each) follow the same curve, which indicates the bills were generated from the factor rather than the factor from the bills. Reducing any of these lines changes a formula, not a cost.

Three exact-ratio indicators. 8100 Interest Expense equals 6460 Taxi & Car Rental to the cent — $24,694.63 in FY2025 and $17,092.66 in Jan–Aug 2026 — while the Dec 2025 balance sheet carries no borrowing. The four telephone sub-accounts hold fixed proportions all year (Regular Service $81,028.44 : Internet $48,617.57 : Cellular $32,411.71 : Online Fees $64,823.43 = 2.5 : 1.5 : 1 : 2). 6060 Advertising, billed by one vendor, FrisCo US, in 24 bills, is exactly 2.6087% of that month's journal product revenue in every month ($230,109.00 in total).

Four accounts move independently. 6210 Salaries & Wages $971,755.70 steps in multiples of 5% of January; 6230 Payroll Expenses $102,539.95 tracks wages; 6610 Rent $150,040.00 was $12,100 a month through August and $13,310 from September (a 10% step, $14,520 annualised); and 6060 Advertising as described. Together they are $1,454,444.65, the other half of operating expense.

Ratios the ledger supports. IT and telecom is 33.4% of wages and telephone alone 23.3%. Travel and entertainment is 29.2% of wages; accommodation ($95,691.74) runs 1.55 times airfare ($61,736.62), consistent with long trips rather than frequent ones. Sick leave is 4.8% of wages. Advertising plus marketing is $446,187.13 — 4.1% of total revenue but 35.7% of the $1,249,049.59 of revenue that came through invoices and stores, the only revenue an advertising dollar could plausibly influence. Rent is 51.9% of facilities cost. No headcount or unit volumes exist in the ledger; nothing per employee or per unit is claimed.

Subsidiaries: one factor, two outcomes

The two subsidiaries run the same journal structure at the same margin. The difference in their results — $815,711.29 against $348,121.38 — is the direct channel, and the four TEST invoices sit entirely in Subsidiary 1.

Every allocated pool splits between the subsidiaries in the same proportion as the journals themselves — advertising 52.6 : 47.4, wages 52.6 : 47.4, travel 52.9 : 47.1, IT 52.9 : 47.1, interest 52.9 : 47.1 — and rent is $75,020.00 in each. Subsidiary 2 therefore carries operating expense at 28.7% of revenue not because it spends more but because it has less direct revenue over which to spread the same factor. Subsidiary 2's direct business is 05: Miami ($305,735.33, including $357.00 of freight) plus one invoice of $1,616; Subsidiary 1 holds Los Angeles, both stores and all four TEST invoices. Excluding the TEST invoices, the net income gap narrows from $467,589.91 to $186,346.91.

Since the close: growth is real, and so is the working-capital cost

Jan–Aug 2026 against the same eight months of 2025: revenue up 18.7%, gross margin up 2.9 points, operating expense up 8.7%; net income up 85.6%. Receivables rose 61.4% and inventory 109.4% since Dec 2025.

Sixteen summary journals supply $6,940,541.72 of 2026 revenue (84.2%), so the mix finding stands. Accounts absent from FY2025 have begun to post — 4320 Sales Returns & Allowances $149.95, 5370 Stock Adjustment ($9,140.00), 5205 Purchase Price Variance $765.00, 6690 Bad Debt Expense $149.95, 6370 Legal Fees $2,000.00, 6250 Automobile Expense $2,000.00 — the first transaction-driven costs the ledger has shown.

Operating cycle at Dec 2025. Receivables $1,305,952.68 represent 44.0 days of revenue; inventory $1,001,084.33, 54.5 days of total cost of sales; payables $806,802.51, 43.9 days — a 54.6-day cycle holding $1,500,234.50 of net working capital, with cash of $2,262,964.25 covering 9.2 months of operating expense and no debt. Each ten days of DSO represents $296,902.05 of cash. Sales tax is payable in eight states at Dec 2025 ($113,747.53) and twelve at Aug 2026 ($217,882.59). Capital stock increased by $390,000.00 to $2,658,382.83 in 2026; retained earnings of $217,235.72 plus FY2025 net income equal the $1,381,068.39 shown at Aug 2026.

Sub-ledger caveat. Inventory in Stock stood at $1,001,084.33 at Dec 2025 against $552,758.41 of item-driven cost of sales (5340) for the year — 661 days of supply; at Aug 2026 it is $2,095,945.97 against a 2026 run rate implying 1,133 days. The journal-posted cost of sales in 5310 never relieves inventory, so the general ledger cannot establish whether the stock supports the wholesale business or sits beside it. The item sub-ledger (Inventory Valuation report) is the appropriate source.

Ranked by dollars at stake

Ranked by dollars at stake

What this statement cannot establish

• Returns, allowances and discounts. 4320 and 4520 exist but carried nothing in FY2025 (the first return, $149.95, posts in 2026). Either no customer returned goods in a year of 897 orders, or returns were netted elsewhere. Populated, they would lower the 56.7% and 46.6% margins.
• Bad debt. 6690 has no FY2025 postings while $302,717.94 of invoices dated May to December remain open. A reserve would reduce net income directly.
• Freight-out. 6080 has never been posted to; 8300 Freight Expense shows ($0.50) in 2026. The shipping cost of 358 fulfillments is not visible, so the invoiced margin is overstated by an unknown amount.
• Shrinkage and obsolescence. 5370 Stock Adjustment first appears in 2026 at ($9,140.00). Nothing tests whether the $1,001,084.33 of Dec 2025 stock was saleable.
• The other 88.5% of revenue. The summary journals carry no customer, item or location, so concentration, cadence and pricing can be measured only on the $1,249,049.59 that came through invoices and stores. A customer-level extract from the source system would extend Section 2 to the whole business.
• Headcount and units. Neither exists in the ledger; nothing here is per employee, per order shipped or against an industry benchmark.
• FY2024. A prior-year income statement was not part of this review; the year-on-year comparison uses Jan–Aug 2026 against Jan–Aug 2025.

Sources and tie-out

NetSuite report runs

Report runs were issued sequentially; each response carried periodVerified = true and a rendered header matching the requested period. Consolidated context (-1) includes Subsidiary 1, Subsidiary 2 and xElim; xElim recorded no P&L activity.

Tie-out of derived figures to the printed reports

General ledger census, FY2025 P&L postings

Queries

All queries are SuiteQL executed against the production account on 2026-09-18 with Administrator permissions. Period ids: FY2025 monthly periods are 156–158, 160–162, 164–166, 168–170 (159, 163, 167 are quarter roll-ups and receive no postings). Amounts on transactionaccountingline follow the GL sign convention; revenue is credit-negative and is negated for presentation.

SELECT id, periodname, TO_CHAR(startdate,'YYYY-MM-DD') AS startdate, isquarter, isyear, closed
FROM accountingperiod
WHERE startdate >= TO_DATE('2025-01-01','YYYY-MM-DD') AND startdate < TO_DATE('2026-10-01','YYYY-MM-DD')
ORDER BY startdate, isyear DESC, isquarter DESC

SELECT t.type, COUNT(DISTINCT t.id) AS txns, COUNT(*) AS lines, ROUND(SUM(-tal.amount),2) AS amt
FROM transactionaccountingline tal
JOIN transaction t ON tal.transaction = t.id
JOIN account a ON tal.account = a.id
WHERE t.posting = 'T' AND tal.posting = 'T'
  AND t.postingperiod BETWEEN 156 AND 170
  AND a.accttype IN ('Income','COGS','Expense','OthExpense','OthIncome')
GROUP BY t.type ORDER BY t.type

SELECT a.acctnumber, a.fullname, a.accttype, t.type, COUNT(DISTINCT t.id) AS txns, ROUND(SUM(-tal.amount),2) AS amt
FROM transactionaccountingline tal
JOIN transaction t ON tal.transaction = t.id
JOIN account a ON tal.account = a.id
WHERE t.posting = 'T' AND tal.posting = 'T'
  AND t.postingperiod BETWEEN 156 AND 170
  AND a.accttype IN ('Income','COGS','OthIncome')
GROUP BY a.acctnumber, a.fullname, a.accttype, t.type
ORDER BY a.acctnumber, t.type

SELECT a.acctnumber AS acct, a.accttype AS atype, t.type AS ttype, t.postingperiod AS per,
       ROUND(SUM(-tal.amount),2) AS amt, COUNT(DISTINCT t.id) AS txns
FROM transactionaccountingline tal
JOIN transaction t ON tal.transaction = t.id
JOIN account a ON tal.account = a.id
WHERE t.posting = 'T' AND tal.posting = 'T'
  AND t.postingperiod BETWEEN 156 AND 170
  AND a.accttype IN ('Income','COGS','Expense','OthExpense','OthIncome')
GROUP BY a.acctnumber, a.accttype, t.type, t.postingperiod

SELECT a.acctnumber AS acct, a.accttype AS atype, t.postingperiod AS per, ROUND(SUM(-tal.amount),2) AS amt
FROM transactionaccountingline tal
JOIN transaction t ON tal.transaction = t.id
JOIN account a ON tal.account = a.id
WHERE t.posting = 'T' AND tal.posting = 'T'
  AND t.postingperiod BETWEEN 156 AND 170
  AND a.accttype IN ('Expense','OthExpense')
GROUP BY a.acctnumber, a.accttype, t.postingperiod

SELECT t.id AS tid, t.type AS ttype, t.entity AS ent, t.postingperiod AS per,
       tl.subsidiary AS sub, tl.location AS loc, a.acctnumber AS acct, ROUND(SUM(-tal.amount),2) AS amt
FROM transactionaccountingline tal
JOIN transaction t ON tal.transaction = t.id
JOIN transactionline tl ON tl.transaction = t.id AND tl.id = tal.transactionline
JOIN account a ON tal.account = a.id
WHERE t.posting = 'T' AND tal.posting = 'T'
  AND t.postingperiod BETWEEN 156 AND 170
  AND a.accttype = 'Income' AND t.type IN ('CustInvc','CashSale')
GROUP BY t.id, t.type, t.entity, t.postingperiod, tl.subsidiary, tl.location, a.acctnumber;

SELECT e.id AS ent, e.entityid AS name, BUILTIN.DF(e.type) AS etype
FROM entity e
WHERE e.id IN (SELECT DISTINCT t.entity FROM transaction t
               WHERE t.type IN ('CustInvc','CashSale') AND t.postingperiod BETWEEN 156 AND 170)

SELECT t.id, t.tranid, TO_CHAR(t.trandate,'YYYY-MM-DD') AS trandate, t.postingperiod AS per, t.memo,
       MIN(tl.subsidiary) AS sub, COUNT(*) AS lines,
       ROUND(SUM(CASE WHEN a.accttype='Income' THEN -tal.amount ELSE 0 END),2) AS income
FROM transaction t
JOIN transactionaccountingline tal ON tal.transaction = t.id
JOIN transactionline tl ON tl.transaction = t.id AND tl.id = tal.transactionline
JOIN account a ON tal.account = a.id
WHERE t.type = 'Journal' AND t.posting = 'T' AND t.postingperiod BETWEEN 156 AND 170
GROUP BY t.id, t.tranid, t.trandate, t.postingperiod, t.memo
ORDER BY t.postingperiod, t.tranid

SELECT a.acctnumber AS acct, e.entityid AS vendor, COUNT(DISTINCT t.id) AS bills,
       ROUND(SUM(tal.amount),2) AS amt, ROUND(MIN(tal.amount),2) AS min_line, ROUND(MAX(tal.amount),2) AS max_line
FROM transactionaccountingline tal
JOIN transaction t ON tal.transaction = t.id
JOIN account a ON tal.account = a.id
LEFT JOIN entity e ON e.id = t.entity
WHERE t.type = 'VendBill' AND t.posting = 'T' AND tal.posting = 'T'
  AND t.postingperiod BETWEEN 156 AND 170
  AND a.accttype IN ('Expense','OthExpense')
GROUP BY a.acctnumber, e.entityid
ORDER BY a.acctnumber, SUM(tal.amount) DESC

SELECT a.acctnumber, a.fullname, a.accttype, a.isinactive
FROM account a
WHERE a.acctnumber IN ('4320','4330','4400','5370','5205','6690','8300','6340','4310','5360')
   OR LOWER(a.fullname) LIKE '%discount%' OR LOWER(a.fullname) LIKE '%shrink%'
   OR LOWER(a.fullname) LIKE '%obsolesc%' OR LOWER(a.fullname) LIKE '%freight%'
   OR LOWER(a.fullname) LIKE '%bad debt%'
ORDER BY a.acctnumber

SELECT t.tranid, TO_CHAR(t.trandate,'YYYY-MM-DD') AS trandate, e.entityid AS customer, t.foreigntotal, t.status, t.memo,
  (SELECT COUNT(*) FROM transactionline tl WHERE tl.transaction = t.id AND tl.mainline='F' AND tl.taxline='F' AND tl.item IS NOT NULL) AS item_lines,
  (SELECT COUNT(*) FROM nexttransactionlinelink nl JOIN transaction s ON s.id = nl.nextdoc
     WHERE nl.previousdoc = t.id AND s.type='ItemShip') AS shipments,
  (SELECT MIN(tl.location) FROM transactionline tl WHERE tl.transaction = t.id) AS loc,
  (SELECT ROUND(SUM(-tal.amount),2) FROM transactionaccountingline tal JOIN account a ON a.id = tal.account
     WHERE tal.transaction = t.id AND a.accttype='COGS') AS cogs
FROM transaction t JOIN entity e ON e.id = t.entity
WHERE t.type='CustInvc' AND t.postingperiod BETWEEN 156 AND 170 AND t.foreigntotal >= 20000
ORDER BY t.foreigntotal DESC

SELECT t.type,
       CASE WHEN t.postingperiod BETWEEN 156 AND 170 THEN 'FY2025'
            WHEN t.postingperiod < 156 THEN 'pre-2025' ELSE 'FY2026' END AS era,
       COUNT(DISTINCT t.id) AS txns, ROUND(SUM(tal.amount),2) AS ar_movement
FROM transactionaccountingline tal
JOIN transaction t ON t.id = tal.transaction
JOIN account a ON a.id = tal.account
WHERE a.acctnumber = '1110' AND t.posting='T' AND tal.posting='T' AND t.postingperiod <= 182
GROUP BY t.type, CASE WHEN t.postingperiod BETWEEN 156 AND 170 THEN 'FY2025'
                      WHEN t.postingperiod < 156 THEN 'pre-2025' ELSE 'FY2026' END
ORDER BY 2, 1

-- IR657 and IR660 (vendor Bedline), $2,400 each to 5340
SELECT t.tranid, TO_CHAR(t.trandate,'YYYY-MM-DD') AS trandate, e.entityid AS entity, ROUND(SUM(-tal.amount),2) AS cogs
FROM transactionaccountingline tal JOIN transaction t ON t.id = tal.transaction
JOIN account a ON a.id = tal.account LEFT JOIN entity e ON e.id = t.entity
WHERE t.type='ItemRcpt' AND a.acctnumber='5340' AND t.postingperiod BETWEEN 156 AND 170
GROUP BY t.tranid, t.trandate, e.entityid;

-- Sixteen 2026 summary journals: $6,940,541.72 income
SELECT COUNT(DISTINCT t.id) AS journals,
       ROUND(SUM(CASE WHEN a.accttype='Income' THEN -tal.amount ELSE 0 END),2) AS income
FROM transactionaccountingline tal JOIN transaction t ON t.id = tal.transaction JOIN account a ON a.id = tal.account
WHERE t.type='Journal' AND t.posting='T' AND tal.posting='T'
  AND t.postingperiod BETWEEN 173 AND 182 AND t.memo LIKE 'Beg Balance%';

-- TEST invoices: all Subsidiary 1
SELECT t.tranid, MIN(tl.subsidiary) AS sub, s.name AS subname
FROM transaction t JOIN transactionline tl ON tl.transaction = t.id JOIN subsidiary s ON s.id = tl.subsidiary
WHERE t.tranid IN ('INV788','INV789','INV790','INV791')
GROUP BY t.tranid, s.name ORDER BY t.tranid

Method, assumptions and verification

Order of work

1. Ingest and tie out: the FY2025 Income Statement was run by month, in total and by subsidiary; every account total derived from the general ledger was reconciled to the printed subtotal before analysis proceeded.
2. Analyse: channel P&L by posting source; monthly trend; customer cadence; order economics; expense-pool indexing and cluster detection; ratio checks limited to what the ledger supports; missing-account audit; balance-sheet and subsequent-period review.
3. Confirm: the goal, three blocking questions with recommended defaults, and the assumptions below were presented and accepted before the document was built.
4. Build and verify: every dollar figure in the prose and tables was matched programmatically against a dictionary of values re-derived from the parsed rows and transcribed reports; arithmetic identities (channel, pool, cadence, A/R and balance-sheet sums) were checked independently. The same check runs in this document at load; see below.

Assumptions

1. The twenty-four "Beg Balance Entries" journals are a summary import from another system. Their revenue is treated as real; their internal cost relationships are not relied upon. Their exclusion would remove 88.5% of revenue, so they are retained and disclosed rather than excluded.
2. The four TEST invoices are retained in the tied-out figures and shown separately; adjusted figures are provided wherever they change a conclusion.
3. Cost of sales is paired with revenue by posting origin: 5310 with journal 4210; 5360 with 4310; 5340 (ItemShip) with invoiced revenue; 5340 (CashSale) with cash sales; the $4,800.00 posted by two item receipts is left unassigned.
4. Customer names in the entity table denote distinct entities.
5. 4450 Freight Revenue is the full freight recovery; 6080 Freight-out exists but has no postings.
6. 6060 Advertising, at a constant 2.6087% of journal product revenue, is a fee arrangement rather than performance media.
7. The 42-account block with an identical monthly index is driven by one allocation factor; 8100 Interest Expense, equal to 6460 in both periods with no borrowing recorded, is a mis-mapped member of that block.
8. Not undertaken: tax, valuation, financing, cash deployment, headcount-based or benchmark-based claims.

Classification rules

Channel = transaction type of the posting transaction (Journal, CustInvc, CashSale) and account (4310 for services). Customer cadence = number of distinct FY2025 monthly periods in which a customer's invoices posted 4210 revenue: always-on 10–12, episodic 2–9, bought once 1. Expense pools group accounts as listed under Figure 5. Allocation-factor membership = identical January-indexed monthly vector to one decimal place (two members differ by 0.1 in one month through rounding and are included).

Verification

Before publication, 205 dollar figures (142 distinct) in the prior draft were extracted and matched against the source dictionary: 138 matched exactly; the four exceptions were regular-expression artifacts (trailing punctuation and a truncated approximation, since removed). 43 further figures introduced in Section 4, the quarterly table and the location split matched 43 of 43. Twenty-five arithmetic identities passed. The same procedure runs in this document when it is opened: