Collections pending without auto pay. Accounts with a balance whose recurring mapping is not Active —
the book somebody has to actually go and collect. Day buckets are on TAT (days outstanding): ≤30 / 31-60 / >60,
which is how the Looker report splits them. Amounts in INR.
Pending by Account Manager
click to filter
Pending by AE / SPOC
click to filter
Never received any payment from this customer. Accounts with a balance and Payment Received Status = No
— every one of these also has a blank last-collection date, so nothing has ever landed. These are onboarding
failures, not late payers, and they need a different conversation.
Pending by Account Manager
Payment recurring status — all numbers in USD. Subscription-based accounts only. "Activated" means the
recurring mapping is Active, i.e. the money collects itself. Everything in the without recurring column is
ARR that somebody has to chase by hand every cycle — that is the cost this page exists to remove.
ARR by Account Manager
active vs without recurring
Collected amount — cash that actually landed. Built from the Collection tab: one row per receipt,
converted to INR. Period metrics are anchored to the snapshot date.
By currency
INR equivalent
Full book, aged by the sheet's own buckets. Every account with a balance — auto-pay included, so this total
is larger than the Collections Pending page. Buckets here are the sheet's 0-30 / 30-60 / 60-90 / >90
columns, not the TAT split.
Aging profile
0-30
30-60
60-90
>90
By SPOC
click a row to filter · click headers to sort
Top 12 SPOCs by exposure
stacked by bucket
Worst 12 accounts >90 days
escalation list