- Net revenue
- Sales minus credits. Sales = QuickBooks invoice lines by invoice date, net of the discount lines on the same invoice. Credits = the account's credit memo lines, in the month the credit memo is dated (ruling of 2026-11-07).
- Credits
- QBO credit memo lines of the account (returns, promotions, price adjustments). Risks: a credit dated in a later month than its sale pulls that later month down. A credit with no product line counts in the account total only, under the Discounts product line. QBO does not tell a promotional credit from a return credit.
- New York (partner)
- The royalty partner's store sales (sell-through) from the New York sheet, V_PBI_NY_SALES_LINES. Not Claybourne invoices. Shown only when you pick New York, never added into California + Nevada, no bridge.
- Units
- Quantity on the invoice's product lines, less returned quantity on credit memos. Discount lines carry no units. Units on a $0.00 invoice are trade samples: not in Units, shown as Samples on hover.
- Product filter
- Invoice-level discount lines are spread over the invoice's product lines in proportion to their amount, so a brand or product-line filter still shows net revenue.
- Excluded
- Private label, white label, bulk, Vireo NY (Minnesota), Tweed (Ontario), Eaze Florida, and item 1029 'Distru Sales' lines on account 243 that match no product. They are never in an account row. Their dollars inside the branded P&L are in the bridge line.
- Bridge to P&L
- One line per month: QBO P&L branded net minus the sum of the account rows. Hover a cell for its parts. Closed months only. It applies to a whole market, so it shows only with no rep, account, banner or product filter.
- Market
- The customer's market: 'NV -' in the name means Nevada, else the QBO bill-to state, else California (ruling of 2026-11-07). The P&L splits by QBO class, so the bridge carries a market shift part.
- AVG monthly revenue
- Net revenue of the 6 months up to yesterday (Pacific) divided by 6 (Nick 7/13), the same window as Account Health. House accounts and central distro accounts are not in the total pace.
- YoY tiles
- Power BI's measure (ruling 2026-11-11, Power BI's number wins on the default view; overrides def7 there): this year January 1 to the last day in Power BI's sales table, against last year January to the month BEFORE the current month. With no filter: every account, royalty included, promotions and slotting bills and documents deleted in QBO included, and a month with a QBO P&L counted at the P&L. With a filter: the account rows of every account, royalty included, same months. 'Closed months only' stops both years at last month.
- YoY account table
- Per account: January to the picked month against the same months last year, the current partial month against the full month (def7). Royalty lines are left out so a Nevada account is compared on product. The Accounts up / down tile counts this table.
- Key account
- A pill, not a rep. The account belongs to a key-account chain or is typed KEY. The rep shown is the responsible person (ruling of 2026-11-07).
Credits sit in the month the credit memo is dated, not the month of the sale. A late credit pulls its month down.
The YoY account table compares the current month to date with the full month last year. The YoY tiles use Power BI's windows: last year stops at the month before the current one.
With a product filter, Net allocates each account's credits to the shown product lines by sales share. Credits YTD ignores the product filter.
Documents deleted in QBO but still in the warehouse (not re-touched by the latest full QBO load) are left out of the account rows; Power BI keeps them, so the default YoY tiles include them.
Nevada 2025 carries royalty invoices ($73,824.94 for the year). The YoY tiles include royalty ($68,338.33 of it in 'Last year', January to Oct); the YoY account table leaves royalty out.