Collections Desk — Portfolio Demo | ExcelKeys

Collections Desk

Receivables & debtors ageing

Ageing basis
Where is the money stuck?

Debtors ageing

What needs your attention

Written from the filtered ledger. Refreshes with every filter and upload.

    Aaj kinko call karna hai

    Today's call list

      Priority score (0–100) blends overdue amount, how old the overdue is, payment-history grade, broken promises, credit-limit breach and days since last contact. Customers with a promise due soon rank lower so nobody is chased twice. The Excel download has the full list with blank columns for call outcome, promise date and remarks.

      Who owes the most?

      Top defaulters & customer quality

      Concentration of overdue

      Biggest overdue balances and how much of the total they carry.

      Payment behaviour mix

      Receivables split by how reliably each customer pays.

      Customer ageing

      Shaded cells show where each customer's money is stuck. Click a column heading to sort.

      Cash you can plan around

      Expected collections

      Next 5 weeks

      Each open invoice is placed on its likely pay date from that customer's habit, then weighted by the chance it gets paid.

      Falling due soon

      Not-yet-due invoices by due week. Remind customers a few days ahead.

      Who is responsible?

      Branch & salesperson view

      Every unpaid rupee

      Open invoice register

      Every unpaid or part-paid invoice in the current view.

      Built by ExcelKeys · excelkeys.in
      Portfolio Demo — Sample DataBuilt by Jitendra Rao · ExcelKeys · Full version on request
      Best viewed on a laptop or desktop.