Our accountant has asked for aged receivables and payables as of Jan 31, 2007 (our year end). When we printed thiese reports (sometime in March) they show traansactions dated February even though we asked for aging as of Jan. 31. The aging is done (number of days) as of Jan 31, but the totals include items in the new year. Is there a way to get these reports to show only the transactions up to and including Jan 31??

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).