Finance: Average Collection Period

Efficiency Measure: The approximate amount of time it takes for a business to receive payments owed, in terms of receivables, from its customers and clients. Formula: Accounts Receivable/ (Annual Credit Sales/ 365) or 365/ Receivables Turnover

 

'Calculate Average Collection Period
'Formula: Accounts Receivable/ (Annual Credit Sales/ 365) or
365/ Receivables Turnover

Return api.Data.GetDataCell("Divide(365, A#[YourReceivablesTurnoverAccount])")

Source:   Snippet Editor:  Finance - Common Accounts - Efficiency Measures