- Open AR
- Open invoice balance on QuickBooks' own A/R aging report, invoice by invoice, gross. Credits are not netted into invoices. Branded only, per invoice: Private Label and Bulk accounts are not on this page, and an invoice that carries only private-label, white-label or bulk product is left out even on a branded account. Ruling of 2026-11-07.
- Last payment
- The latest payment date and the sum of that day's payments. Payments deleted in QuickBooks are left out: Snowflake keeps them, so a payment the latest QuickBooks load did not return (dated in its 540-day window) counts as deleted.
- Days past due
- Report date minus the invoice due date. This is how QuickBooks ages. An invoice due today or later is Current.
- Buckets
- Current (not yet due), 1-30, 31-60, 61-90, 91-120 and 120+ days past due (Wassef 6/15).
- Customer type
- Branded = branded retail accounts, with collections accounts. House = accounting and house accounts that are not retail customers (Suspense, Tweed, Vireo NY); hidden by default. Private Label and Bulk are never on this page.
- Not yet dated
- Open invoices already created in QuickBooks but dated after the report date. QuickBooks' aging leaves them out, and so does Total open: a future invoice date is still backlog. Their count and dollars are in the Total open i.
- Credits not yet applied
- Credit memos, unapplied payments and journal entries still open on the customer in QuickBooks. Shown apart. Total open plus credits = net: QuickBooks A/R for these accounts less their open invoices that carry only private-label, white-label or bulk product (count and dollars in the Net after credits i).
- Rep
- The person on the account in the dated rep map on the report date; for a key account with no person there, the SEED_ACCOUNT_REP KEY row, then the current SEED_REP_BOOK row (same rule as Account Health). Key accounts show their person and a Key account pill.
- DSO
- Finance BI owns it: AR times 28, divided by revenue of the trailing 4 weeks. This page shows the definition only.
Voided and deleted QuickBooks invoices never count. None were on the report at this load.