Kopanow — Collections

Lipa = all rows ≤ cut-off. Scheduled installment amounts include paid + open rows for loans with cashier-completed cash only (not applications). Live cut-off uses server time each refresh.

Admin key As of (when pinned) Live cut-off (server time each refresh — recommended) Rolling window From (optional) To (optional)

—

Money received

—

Rolling Lipa

—

Scheduled (through today)

—

Claimed share

—

— —

Installment due customers

Cash-sent loans only · due through today in local TZ

Due reached

—

Paid

—

All due-window installments paid

Overdue unpaid

—

Same scope as Unpaid invoices

Open due

—

Due but not yet overdue unpaid

No FCM token

—

All cash-sent customers

With FCM token

—

All cash-sent customers

Admin removed

—

No FCM token · device admin removed

Overdue · no FCM

—

Same scope as Unpaid invoices

No FCM breakdown

Cash-sent customers unreachable by push · grouped by device state

Category	Borrower	Loan IDs	Device status	Loan device status	Device updated

All Lipa received trend

History of grand SUM(amount) (all rows ≤ as_of) · refreshes every 10 minutes

No trend yet

Chart fills after a second refresh or the next 10-minute poll.

Lipa flow (claimed vs unclaimed)

Recent Lipa

Ingested ≤ as_of · latest rows · amount column

Amount	Status	Ref	Ingested	Till	Business

Debug

x-admin-key matches server ADMIN_KEY. Money received uses all lipa_transactions.amount with ingested_at ≤ as_of; rolling uses the same full table inside the time window. Scheduled sums pending, overdue, and paid invoices with due_date through end of that calendar day (default TZ Africa/Dar_es_Salaam; set KOPANOW_SCHEDULED_INVOICE_TZ on the server to change), for loans in cash_disbursement_queue with status = completed only (cash sent — applications excluded). Installment due customers counts unique borrowers in that same due window; overdue unpaid matches the Unpaid invoices dashboard (open pending/overdue installments past due on customer loans). Add ?debug_lipa=1 for sample Lipa rows.