Forum Discussion
Solved
Costumer payments velocity in one day in percntage
I have an invoice for a customer to whom we sell on credit.
In one column, the amount paid by the customer is specified, and in another column, the sales amount is specified. In one column, there is the customer's Balance.
This customer has made purchases from us three times, and the balance is now zero. I want to calculate the customer's payment speed for each transaction (it means i want to calculate the velocity of payments for this costumer, in other how much is the average of payments of this costumer in Percentage), meaning I want to know on average, what percentage of their payments amount they have paid during these three purchases in one day how much in percentage?
"Point: for this aim we should extract the days which the costumer balance is not zero then ..."
Thank you.
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.
