H-TS's avatar
H-TS
Trusted User
2 months ago
Status:
Open

Sales Invoice Report with both due date and paid/closed date

Hi, 

 

There are a lot of sales reports but neither I nor the live chat support team, were able to find one that allowed me to modify it so both due date and closed date could be shown on the same report. Some reports allowed the due date, others allowed the paid/closed date but none of them allow both.

 

My boss wants me to report on the average number of days overdue our overdue invoices go. I can get the daily snapshot from the to do list but again, if I 'print' the list to export it, the number of days overdue column disappears anyway, so I have to manually type the numbers into excel/calculator. But if I forget one day, then the data is gone. The report isn't back-date-able.

 

I know I can also add a 'days to pay' column on some reports but I couldn't find any where I could get the due date as well to even do a calculation of overdue days. Since different customers have different payment terms, the number of days to pay is a useless stat for this purpose.

 

Very happy to be proven wrong if this feature already exists. I don't even need the value of the invoices, just the difference between due date and paid date.

I looked at both the desktop and browser versions of AccountRight.

1 Comment

  • Status changed:
    New
    to
    Open

    Hey H-TS

    Thanks for your idea. We'll be sharing this one with our product teams and have updated the status to open for other members of our community to vote and add weight to your idea.