AR: What is the calculation formula of Average Age in Debtor Collection report: Difference between revisions
AR: What is the calculation formula of Average Age in Debtor Collection report (view source)
Revision as of 01:33, 31 October 2022
, 1 year agono edit summary
(Created page with "'''Question:''' What is the calculation formula of Average Age in Debtor Collection report? '''Version:''' 1.8 / 1.9 / 2.0 900px <u><b>Answer:</b></u> The formula of Average Age is:<br/> Average Age = Total Age / Number of knockoff transaction<br/> <u><b>Example:</b></u> <u>For knockoff no.1:</u> Payment Days = Payment Date (OR Date) – DocDate (Invoice Date)<br/> = 07/10/2022 – 23/05/2022<br/> = 137 days<br/> Age = Payment D...") |
No edit summary |
||
Line 33:
Average Age = Total Age / Number of knockoff transaction<br/>
= (107 + 105 + 54 + 43 + 41 + 33 + (-23) + 72) / 8<br/>
= 54<br/>
| |||
