Hi Sammy,

The 'Aged as of' option does exactly what you described - ages transactions into Current/30/60/90 categories but does not remove transactions after the print date.

In the Aged Trial Balance report within Receivables, the 'Calculate as of' option will do what you want (aged by document date), as long as you haven't cleared transactions (to history) since then. If you have cleared transactions, there is no way to get a snap-shot of your aged receivables as of Jan 31, and you'll need to get an older backup of your data to print the report (prior to the clearing date).

In Payables, the Open Payables report has the 'Calculate as of' selection, but the Aged Overdue Payables does not. Similar to Receivables, if you have purged transactions to history, you likely need to get an older backup of the data to get the report you want. And to get aged payables with transactions cut off at Jan 31, you may need a custom report (if you don't have a data backup from Jan 31).