All banks I've reported to require an AGED Payables listing as part of the monthly security requirement. The only way to generate this is to hold payables open until all Last Month(LM) AP invoices are posted and to use Manual cheque processing to print cheques but not post.
The Open Payables report gives a balance which will match our payables liability, but it is not aged. It may be too complex, but if the Aged Overdue Payables report was calculated AS AT a date which you could specify then this the program would save the extra work and occasional being in default of the bank requirements.
I currently have dropped the Open payables into an Excel spreadsheet and have been able to age. I submit this as a suggestion to the Aged Overdue report in some future update, but understand if there isn't a great deal of demand for this.

Hi Glen

I have been in the ACCPAC/Adagio business for over 20 years, with hundreds of clients, and have never once heard a request for an "as of" Aged Payables report. In all cases, the Open Payables report has sufficed. Do your banks require the same thing from their Quickbooks (or other low level accounting software) users?

Steve

This is a new one for me too. Why not give the bank the Open Payables report and let them age it if it is important to them. Then you wouldn't have to hold the prior month open and print out all those manual cheques!

I've never seen this before either, Aged receivables and an inventory list is all I have ever been asked for.

I'm surprised as I've had both CIBC and RBC flaming because the security agreement states they are to received AGED payables. I've actually had them insist that we age the open payables as they would end up charge the company in their billing for the analysis. Remembering the locals submit to Toronto and have strict rules. And yes I have insisted on occasion or neglected and provided Open Payables and got away with it in some situations.
I've worked for a number of companies and they were following this procedure when I joined them.(the number is 14-16 companies to be exact).
Fortunately, this procedure isn't any extra work as the company has been using manual cheques for some time.

Thanks,

Glen_S

Hi Glen,

We'll take it under advisement for the next time we open Payables for improvements...