Ageing factor in Mews Analytics
Financial analytics - open invoices. I see that you have the ageing periods in there. The only thing that is really still missing here is 1 amount: the ageing factor. Is there any chance that you would develop this. For those who are not familiar with this terminology; the ageing factor= SUM(outstanding amount*nr of days outstanding per invoice) divided by total amount outstanding.
This factor (1 number) gives an immediate glance of your accounts receivable status. Back in the days hotels were always aiming to be around the number of 34.
Hotel owners, General Managers and the accountants would use this.
Hello from the product team! We are revamping the aging balance and will incorporate this into the new version. Many thanks for contributing to our forum.