Skip to content
Bitta Apps

Chapter 8 of 8Page 2 of 4

Report and manage

Cash forecast

How Bitta Collections predicts when each invoice will be paid from the customer's payment history, and the Cash Forecast and Collection Results reports.

updated: applies-to: 1.2.0.0

Bitta Collections predicts when each open invoice will be paid, from the customer's own payment history in Business Central, and adds the predictions up into a cash forecast by week or month. Every prediction is calculated live from the customer ledger and says in words how it was made. No AI is involved and nothing is copied out of Business Central.

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

Before you start

  • The predictions use paid invoices in the customer ledger. A customer with a payment history gets its own prediction from day one; there is nothing to train or import.
  • Anyone with the Read set, BAA COLL READ, which D365 READ includes, can see the predictions and run both reports. Read-only users need no seat.
  • Promises, payment plans and disputes recorded in Bitta Collections are part of the forecast. See Promises to pay, Payment plans and Disputes.

How a pay date is predicted

For each open invoice, finance charge memo or reminder, the first rule that applies wins:

# When Predicted pay date Confidence
1 The invoice has an open dispute No prediction until the dispute is resolved. The amount is shown apart as disputed None
2 The invoice is in an active payment plan The due date of the installment that covers it Medium
3 The invoice has an open promise to pay The promise date Medium
4 Otherwise Learned from the payment history, with a range High, Medium or Low

A payment plan comes before a promise, so the same money is never counted twice.

How it learns from payment history

When no dispute, plan or promise applies, Bitta Collections looks at how the customer paid before:

  1. It reads the customer's invoices paid in the last Forecast History Months (default 24), at most the Forecast Max. Paid Invoices most recent ones (default 50). An invoice closed by a credit memo is left out, because a credit memo is not a payment.
  2. It weighs recent payments more. With Forecast Half-Life (Days) at its default of 180, a payment made six months ago counts half as much as one made today, and one made a year ago a quarter.
  3. It compares like with like. An invoice that is already 30 days past due is compared only with the invoices that were still open 30 days or more after their due date, so a late invoice is not predicted from the customer's on-time payments, and a prediction is never in the past.
  4. The predicted date is the due date plus the weighted median of the days late. The range runs from the 25th to the 75th percentile.
Confidence When
High The customer's own history, at least 12 paid invoices count, and the middle half of them spans 15 days or fewer
Medium The customer's own history, and the middle half spans 30 days or fewer
Low Any other case, including the company history, an invoice later than all of the history, and the due date fallback below

A customer with fewer than Forecast Min. Paid Invoices (default 5) is predicted from the company's payment history. When the company has too few paid invoices as well, the prediction is the due date, or the as-of date when the invoice is already past due. Each case says so in its basis. The median and the range say early or late in words, never with a minus sign:

History Basis
Pays late "Customer history: median 12 days late over 18 paid invoices; middle half 5 to 20 days after the due date."
Pays early "Customer history: median 5 days early over 9 paid invoices; middle half 10 to 3 days before the due date."
Pays around the due date "Customer history: median on the due date over 7 paid invoices; middle half 6 days before to 1 day after the due date."
Pays on the dot "Customer history: median on the due date over 6 paid invoices; middle half on the due date."

An invoice can also be later than anything in the history: already more days past due than every paid invoice took. Then there is nothing like it to learn from, so the prediction is about 30 days after the as-of date, with a range from the as-of date to 60 days after it, and the confidence is Low. The basis says so, for example "Customer history: already 95 days past due, later than all 18 paid invoices; expected in about 30 days, low confidence." An invoice that is not due yet can get there too, when every paid invoice was paid even earlier, for example "Customer history: due in 5 days, and all 6 paid invoices were paid more than 5 days before their due date; expected in about 30 days, low confidence." This applies to the company history the same way.

What the collector sees

Where What it shows
Payment Forecast FactBox on the customer card, Customer Ledger Entries, the Collections Worklist and the Collections Work Item Next Predicted Payment, Expected Within 30 Days, Expected Later, Disputed (Not Forecast), Typical Days Late, Paid Invoices in History, Confidence and the Basis in words
Predicted Pay Date column on Customer Ledger Entries, after Due Date, and in the open entries of the work item The prediction for each invoice. Add the hidden Prediction Basis column to see why

The amounts and dates in the FactBox drill down to the customer's open entries, where the column shows each prediction. A collector sees at a glance whether a customer usually pays 3 days late or 40, and plans the call accordingly.

Payment Forecast FactBox with the next predicted payment, typical days late, confidence and the basis in words
The Payment Forecast FactBox explains each prediction.

The Cash Forecast report

Open the Cash Forecast report from the Collections and Credit role center, under Reports > Receivables and Aging.

Request page option What it does
As of The date the forecast starts from. The default is the work date
Period Length Week (Monday to Sunday) or Month
Number of Periods How many periods to show. The default is 13. Everything later is added up in one "After" line
Collector Only the customers of one collector

You can also filter on customer numbers and customer posting groups. For each period, collector and customer, the report shows:

  • Expected: amounts predicted from the payment history, the company's history or the payment terms;
  • Promised: amounts on open promises, on their promise dates;
  • Plan: open installments of payment plans, on their due dates;
  • Total, plus an Early Case and a Late Case, which place the history-based amounts at the early and late ends of their ranges.

The disputed amount is printed below the total. Each invoice is counted once: a payment plan's installments replace its invoices, and a partly promised invoice is split between the promise and the history. The default layout prints by period with a heading per collector. The Cash Forecast (Excel) layout is a flat list for pivot tables.

Cash Forecast report by week with expected and promised amounts per collector and the period total
The Cash Forecast by week, per collector.

The Collection Results report

Collection Results (Before and After), under Reports > Team Performance, measures two periods the same way, for example the quarter before you started with Bitta Collections and a quarter after:

  • DSO and the collection effectiveness index (CEI);
  • the share of receivables overdue, the average days late and the share of invoices paid late;
  • the promise kept rate;
  • the share of matching suggestions accepted and of payments matched by a suggestion;
  • the number of collector actions.

Each figure prints with its method, the change and whether it got better or worse. Choose periods of the same length, because DSO and CEI depend on the number of days.

Collection Results report comparing a period before and after with DSO and promise figures
Collection Results compares two periods.

Settings

An administrator with BAA COLL SETUP sets the four forecast fields on the Insight FastTab of Bitta Collections Setup: Forecast History Months (24), Forecast Min. Paid Invoices (5), Forecast Max. Paid Invoices (50) and Forecast Half-Life (Days) (180). The defaults suit most companies. See Setup reference.

What's next

See the receivables of every company in one place: Several companies.

Next step

Ready to try Bitta Collections?