- Invoiced
- QuickBooks invoices and credit memos by invoice date for the house brands (Claybourne and Fleetwood), net of discounts, for every month, closed or open. Each closed month's California and Nevada total equals the QuickBooks P&L branded net. Later QuickBooks edits to a closed month show here.
- Closed month
- A month before the current one. Invoiced follows QuickBooks; who gets credit stays as of that month. Jan, Feb, Mar, Apr, May, Jun: each rep keeps their share of each line as saved at close (the rep map has no record for those months); a QuickBooks change to a line is spread over its reps by those shares. Later months: the dated rep map on the invoice date. Power BI still shows the saved dollars for January to August, so closed months can differ from Power BI by later QuickBooks edits.
- Quota
- The client's quota file, as Power BI shows it. Fleetwood is its own line where the quota file has one.
- Plan
- The Brand plan from Wassef's Sales-Finance-Ops sheet (row 7; lines rows 12, 16 + 24, 20), the same plan as Finance BI (Nick 10/23). Company plans are split to reps by each rep's share of the line's quota. Nevada and New York have no plan, so their quota is their plan. The Fleetwood plan (row 24) sits in Pre Roll.
- Backlog
- Every open Distru order (Processing or Delivering), any delivery date, house-brand lines, with no QBO invoice yet or a QBO invoice dated after today. It moves to Invoiced on the invoice date, never both (rulings of 2026-09-25 and 2026-11-07). Read live at each refresh. Current month only.
- Other and GL reconciliation
- A rep's QuickBooks total minus its product lines (open month and New York: Power BI's Total line minus its product lines). GL reconciliation is the gap to the QBO P&L; Other is product with no Power BI line. Power BI shows them only inside Total.
- Daily sales needed
- (Month target minus invoiced) divided by business days left. Business day = Monday to Friday. Today counts as elapsed, so days left start tomorrow (Finance BI rule, Nick 10/30).
- True revenue
- California plus Nevada. New York shows on its own and never adds into this total (Wassef 8/21).
- Account flash
- The Power BI account flash, every account and number: 12 full months before this month, this month to date, and open bookings = open Distru orders with no delivery date or a delivery date after today (California and Nevada). Accounts with open orders and no sales are rows too.
- Colors
- As in Power BI. Invoiced, % to quota and % with backlog: green at 100% or more, gold 90 to 99%, red under 90%. Discounts reverse it: green at or under 100% of the discount quota, gold to 110%, red above.
Plan split to reps is an allocation (rep share of the line quota). The sheet has company plans only.
Closed months follow QuickBooks, so January to August can differ from the Power BI Quota Tracker, which still shows the dollars saved at close.