Sage 50 Canada

Welcome to the Sage 50 Canada Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Report - Average days to pay

Posted By Margaret Kasza over 1 year ago

Is there a report I can check average payment time for our clients? or do I have to go through every single transaction and count?

Thanks!

Parents

0 GwG over 1 year ago

There is on report but if you have some Excel skills. Export the customer aged detail report to Excel and subtract INVOICE from PAYMENT will calculate the number of days and then use the AVG days formula at the end of the customer listing. Use an IFF formula to only calculate PAYMENT lines. I know this sound complicated but will save some time.

=if(d7="Payment",c9-c8,0)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 GwG over 1 year ago

There is on report but if you have some Excel skills. Export the customer aged detail report to Excel and subtract INVOICE from PAYMENT will calculate the number of days and then use the AVG days formula at the end of the customer listing. Use an IFF formula to only calculate PAYMENT lines. I know this sound complicated but will save some time.

=if(d7="Payment",c9-c8,0)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data

Sage 50 Canada

Report - Average days to pay

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING