expansion MRR reported verbally. Excluded from signed contracts and the revenue forecast.
Original sales update · Sales correction
Contract MRR is the average over the contract term, not the amount of a first invoice. Already-invoiced accounts are removed from the unbilled balance by billing account and workspace, including invoices under another name. Unverified verbal sales and expansions are excluded from every financial total. The remaining balance is recalculated from the same billing records as the revenue forecast.
| # | Customer / shop | Whitelist source | Payment | CAD | Outstanding | Status |
|---|
whitelist_source is a paying value (quickbooks / shopify / stripe), synced from HubSpot every 5 min. Money (QBO invoices dated in the month, excl. sales tax, net of credit memos + Shopify subscription charges) is joined to each company through its declared workspaces — it is the financial detail and the audit of the flag, not the roster itself. "no money this month" = declared paying but nothing billed/charged in the selected month (fine for annual/irregular billing; see the gap card for the 60-day view). The red section at the bottom lists money with no declared paying owner — either the customer is absent from HubSpot or its stores carry a non-paying flag; each row names the fix. QBO USD invoices use QBO’s per-invoice rate; Shopify USD converted at a fixed 1.3756 CAD/USD — the stated rate the finance workbook uses, not live FX. Shopify money is collected by definition; outstanding exists only on the QBO rail.| Customer | Type | Billed (CAD) | Outstanding | Status |
|---|
TxnDate), not the due date — excluding sales tax and net of credit memos (revenue view; platform + managed together; one-time invoices included → MRR proxy, not pure MRR). Due date drives only the receivable side: "Outstanding" = the actual balance owed, tax included, and the paid/overdue status. USD invoices use QBO’s per-invoice exchange rate. Status: paid all at zero balance · partial · overdue unpaid past due · billed unpaid, not due. never sent = QBO EmailStatus ≠ EmailSent — invoice exists but was never emailed. Workspace chips use reviewed billing IDs, then unique company-name matches with accents and legal suffixes normalized. Ambiguous identities require reconciliation. ⚠ warning = invoiced customer with no Glowtify store linked. Customer type from CS sheet (2026-05) until the HubSpot customer_type backfill. Walter Interactive is the internal billing entity — flagged on its row and named in the reconciliation, but included in every KPI on this page. Zero-amount invoices count as billing events and contribute zero revenue.
| Shop | Domain | Gross (CAD) | Net (CAD) | Charged |
|---|
APP_SUBSCRIPTION_SALE). Shopify collects at charge time — payment status is implicit (collected); failed payments never appear. Net = gross minus Shopify's revenue share. All Shopify-rail customers are self-served by definition. This rail is excluded from the QBO tab's totals — the two tabs are additive, in different currencies.