Average time to pay & Time taken to pay sales invoices report

I am doing some analysis work on debtors and have run the 'Time taken to pay sales invoices' report which then shows the average days to pay for each customer.

On my 'Customers' screen I have the 'Average time to pay' column showing (I'm running version 22 of Sage 50) and I've noticed that some of the average days information is different.

Does anyone know why this would be?

Thanks

  • Hi Lisa,

    The report you are running will take the date of the payment and subtract the Invoice date, then average this value to give you a true average of days to pay. The report also gives you a date range for the transactions you wish to include.

    The fields in the customer record can be over typed and can also include outstanding transactions that have not yet been paid in the total figure.

    If you have any issues or questions with this, please let me know and I'll be happy to help further.

    Regards,

    Adam
  • Thanks, Adam! That's useful to know - I will use the report for my analysis.
  • in reply to Adam Wood

    Hi Adam, this is an old thread but just wondering, is there a way I can batch change my customer records or change something in settings so the average time to pay is refreshed based on what sage calculates so as to overwrite any old, manually entered figures in customer records?