Skip to content
Bitta Apps

Chapter 8 of 8Page 1 of 4

Report and manage

Reports and KPIs

Follow overdue, DSO, cash collected and promise kept rate on the Collections and Credit role center, and find the reports for collectors, managers and auditors.

updated: applies-to: 1.2.0.0

See how collections are going without leaving Business Central. The Collections and Credit role center shows the key figures live from the customer ledger, and its Reports menu groups 41 reports by task. Every report reads the native customer ledger entries, so the figures agree with your aging.

Applies to: Bitta Collections 1.2 on Business Central online, version 28 or later.

Before you start

  • Every report and KPI needs only the BAA COLL READ permission set (the Read set), plus read access to customers and ledger entries. Users with D365 READ get it automatically.
  • Reports need no license seat, so controllers and auditors can read them without one.
  • To make the role center your home page, choose the Collections and Credit role in My Settings.

The role center KPIs

The role center has two parts with figures. My Collections shows the customers of your own collector code. Collections Team shows the whole team. The Collections Team part is also added to the native Accounts Receivable Administrator and Business Manager role centers.

KPI Part What it shows
Overdue Both Open invoices and other debit entries due before the work date, in local currency. Choose it to see the entries
DSO (Days) Collections Team Days sales outstanding: the receivables balance divided by the sales of the KPI period, times its days
Best DSO Collections Team The DSO if every overdue amount were paid: the part not yet due, divided by the sales of the period, times its days
Cash Collected Collections Team Customer payments posted in the KPI period up to the work date. Choose it to see the payments
Kept Rate % Both Kept promises out of the promises that closed in the KPI period. Canceled promises don't count

The KPI period is DSO Period Days on the Insight FastTab of Bitta Collections Setup (default 90).

The cues count the work to do: Promises Due Today, Broken Promises, Open Disputes, Disputes Past Due, Customers on Hold, Unapplied Payments and Suggestions to Review. The Collections Team part also counts Mail to Approve, Remittances to Review and Placements to Review for the mail, remittance and agency features. The My Collections part also has Replies to Review, the customer replies waiting for a person.

NOTE

Overdue counts invoices in full until a payment is applied to them. An unapplied payment doesn't lower Overdue, so the KPI can be higher than a customer's net balance. The worklist shows the native Balance Due instead, which open credits do reduce.

Collections and Credit role center with the KPI cues for the collector and the team
The role center KPIs; choose a figure to see the entries behind it.

Find the reports

On the Collections and Credit role center, choose Reports and then a group. You can also search for any report by name.

Group Most useful reports
Collector's Day Collector Call List: each collector's ranked work items for the day, with contact details. Customer Collection Review: one page per customer before a call
Receivables and Aging Aging by Collector: aging buckets per customer. DSO and Collection Effectiveness: monthly DSO, best possible DSO and CEI. Collections Executive Summary: a one-page monthly pack against the prior month. Allowance for Doubtful Accounts: a reserve per aging bucket and write-off candidates. Cash Forecast: expected cash per week or month
Promises and Disputes Promise Performance: kept, partly kept and broken promises and the kept rate. Open Disputes: open disputes by reason, age and owner
Dunning and Communication Dunning History: every step that ran and its outcome. Dunning Proposal: what the next run would do, without writing anything
Credit Control Customers on Credit Hold and Credit Hold Audit: current holds and the holds of a period
Cash Application Unapplied Cash: payments and credit memos not fully applied, aged. Cash Application Register: suggestions accepted or rejected, and by whom
Team Performance Collector Performance: per collector, balance, overdue, DSO, cash, kept rate and activity. Collection Results (Before and After): the same figures for two periods side by side
Setup and Control Collections Setup Check: every setup gap that stops dunning, emails or holds
Customer Documents The statement, the collection letter and the confirmations. See Statements and letters

Most request pages have a Collector option. It covers the customers assigned to that collector and, for the default collector, the customers without one. Leave it blank for all collectors. The full list of reports, options and layouts is on the Report list.

How the figures are calculated

The KPIs and the figures below are in local currency, read live from the customer ledger. Most reports total in local currency too, but not all:

  • Short Payments and Deductions and Cash Application Register print the amounts in the currency of the payment.
  • Remittance Inbox Log prints each remittance's total in the currency of the remittance.
  • Mail Register prints the estimated cost in US dollars.
  • The customer documents (statement, collection letter, confirmations and the payment plan agreement) print in the currency of the invoices. The statement and the letter total each currency apart.

The Report list gives the currency of each report.

Figure Formula
DSO Ending receivables / credit sales of the period x days of the period
Best possible DSO Ending current (not yet due) receivables / credit sales of the period x days of the period
Average days delinquent DSO minus best possible DSO
CEI (%) (Beginning AR + credit sales - ending AR) / (beginning AR + credit sales - ending current AR) x 100
% overdue Overdue / (overdue + current AR) x 100
Promise kept rate (%) Kept / (kept + partly kept + broken), for the promises closed in the period

Credit sales are the invoices minus the credit memos posted in the period, tax included. The request pages of the reports explain these formulas in their About text.

Predicted pay dates and the cash forecast

Bitta Collections predicts when each open invoice will be paid from the customer's own payment history, open promises and payment plans, without AI, and says in words how each prediction was made. The Payment Forecast FactBox and the Predicted Pay Date column show the predictions, and the Cash Forecast report adds them up per week or month, by collector and customer, with early and late cases. See Cash forecast.

The Collection Results (Before and After) report measures DSO, CEI, overdue share, days late, promise kept rate and matching for a period before and a period after, for example the quarter before you started with Bitta Collections and a quarter after. Use periods of the same length, because DSO and CEI depend on the number of days.

Excel and analysis

Most reports have an Excel layout next to the default RDLC layout. Choose it on the request page, or set it on the Report Layouts page. For your own analysis, the Open Receivables Analysis and Cash Received Analysis queries in the Reports menu open in Excel or in analysis mode.

NOTE

Collector reports and KPIs count a customer under its current collector. A blank collector counts as the default collector. The Excel layout of Collector Performance also shows partly kept promises.

What's next

See when each customer is likely to pay and what cash to expect: Cash forecast.

Next step

Ready to try Bitta Collections?