Collected Amount
This metric shows how much money has been received from customers whose accounts entered a dunning workflow during a given period.
Kolleno is looking at customers who, from the chosen date onward, ever had a dunning workflow started (whether by customer, invoice, or customer group). Then we add up every payment they actually made on or after that same date. If nobody paid, the total is zero.
Workflows Open Balance (Goal)
This represents the total outstanding balance as of the workflow start date across all active dunning workflows.
How it’s calculated:
Retrieve all active workflows (customer workflows, invoice workflows, and customer-group workflows) that ended on or after the selected date.
For each workflow record, compute the starting balance:
Invoice workflows use the invoice-specific starting balance.
Customer/customer-group workflows sum the whole balance at start
If a customer appears in both an individual workflow and a group workflow, only the larger of the two balances counts.
Convert each workflow’s starting balance into the company’s base currency using up-to-date exchange rates.
Sum all converted balances.
Both metrics are recalculated on demand and cached per user/company for correct dashboard display.
⚠️ Why Can the Collected Amount Be Higher Than the Workflows Open Balance?
You might notice that the Collected Amount on your dashboard is higher than the Workflows Open Balance. This is expected in some cases, and here's why:
Finished Workflows Still Count:
Payments made after a workflow ends are still included in Collected Amount, but the corresponding balances are no longer part of the Workflows Open Balance.Payments Beyond the Balance:
Sometimes customers pay more than the workflow balance, or pay other unrelated invoices – these are still included.Currency Effects:
Exchange rate differences at the time of payment vs workflow start may cause slight differences when converted to your base currency.