Forum Discussion
Costumer payments velocity in one day in percntage
If I had a clear description of the calculation required, illustrated with step-by-step hand calculations, I could probably reproduce the results using MS 365. As things stand, I do not understand the meaning of the term 'payment velocity'; I am not sure why the customer started out by paying so much more than was invoiced; I don't know whether the fact that at the end transactions do not appear in date order.
The sort of things I can do are to calculate the balance and identify points at which it falls to zero; calculate the average balance for each reconciliation period, similarly average the selling amount. For all that, I do not know what you want returned by way of calculations.
I'm not sure if I understood it correctly, but I'm sending you a test file with what I understood 
.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and Like it!
This will help all forum participants.
- Dear Nikolino
thank you for your trying but unfortunately your response is false
tnxIf I had a clear description of the calculation required, illustrated with step-by-step hand calculations, I could probably reproduce the results using MS 365. As things stand, I do not understand the meaning of the term 'payment velocity'; I am not sure why the customer started out by paying so much more than was invoiced; I don't know whether the fact that at the end transactions do not appear in date order.
The sort of things I can do are to calculate the balance and identify points at which it falls to zero; calculate the average balance for each reconciliation period, similarly average the selling amount. For all that, I do not know what you want returned by way of calculations.
- No problem for the payment in first time more than its purchase,
i want to find an index for my costumer to know which costumers doing their payments in shortest time to classify the costumers
