KPI spotlight
Average Days to Deposit (ADD)
The lag between payment arrival and the deposit that lands in the bank.
Adjust the inputs to see how RuleKit operators would tweak rule definitions or bulk actions to move this KPI, then explain the change with clear values.
Use this sandbox to see how rule changes move Average Days to Deposit (ADD)
These defaults sit in the concerning range so you can experiment: tweak invoice amounts, credit sales, or deposit timing as if you were defining a RuleKit workflow, then track how the result shifts toward the good zone. Credit sales should still match the total recognized revenue for this 30-day window, including any net-term invoices.
Formula result
ADD = 17.8 days
ADD = Σ(amount × deposit lag) ÷ Σ(amount)
Weight each payment by how long it waits before hitting the balance so you can spot outliers that slow deposits.
Minimum practical range: An ADD below 1 day would require instant payouts, which most banks do not offer.
Formula segments
Deposited amount
Cash entries we assume land in Stripe
$13,700
Amount-weighted days
Sum(payment amount × lag days)
243,200 day·$
Avg days to deposit
How long funds sit before hitting your balance
17.8 days
| Count | Pay date | Dep date | Dep $ | Lag days |
|---|---|---|---|---|
Definition
What it measures
ADD measures the delay between when payments post and when they are actually deposited. Shorter ADD keeps your cash flow predictable and tells you when payout routing, refunds, or manual holds need new rules.
Receivables are unpaid invoices and credit sales represent the revenue attached to those invoices, even on net terms. RuleKit links these inputs so operators can explain how rule changes move cash versus recognition.
How this maps to Stripe data
Use Stripe invoice `created` and `paid` timestamps to populate each row. RuleKit derives the NET 30 due date from the invoice date so long-term accounts still count toward DSO until they clear, keeping the aging buckets honest even before the payment lands.
Outstanding amount pulls from `amount_remaining` and credit sales should match the revenue for your 30-day window. RuleKit uses those values to highlight which invoices drive aging bucket spikes so you can reduce them with new rules.
Glossary
- Deposit amount
- The amount that actually hits the bank (pull from Stripe payouts).
- Days until deposit
- The lag between payment receipt and bank payout; short lags keep ADD low.
- Invoice count
- How many similar invoices share this payment/deposit pattern.
Real World Strategies to Improve Average Days to Deposit (ADD)
These practical moves reflect what competitive AR teams do to move Average Days to Deposit (ADD).
- Batch smaller deposits to minimize bank clearing overhead and keep ADD steady.
- Monitor payout schedules and add rules that bump suspect methods before they delay the bank deposit.
- Automate routing rules so refunds and disputes don’t pause the full deposit run.
- Reconcile unclear payout timing with finance weekly so exception rules stay visible.