Accrued Expense Aging Report

1.  Navigate to Transactions>Management>Saved Searches>New
2.  Click on Transactions link
3.  Click on Criteria tab>Standard subtab

Select the accrued expenses account
Amount (Credit) is greater than or equal to 0.00
Reversal Number is empty

4.  Click on Results tab>Columns subtab

Type --- Summary Type is Group
Number --- Summary Type is Group
Formula (Currency) --- Summary Type is Sum
--- Formula - case when trunc({today})-{trandate} between 1 and 30 then {creditamount} end
--- Custom Label - 1-30 Days
Formula (Currency) --- Summary Type is Sum
--- Formula - case when trunc({today})-{trandate} between 31 and 60 then {creditamount} end
--- Custom Label - 31-60 Days
Formula (Currency) --- Summary Type is Sum
--- Formula - case when trunc({today})-{trandate} between 61 and 90 then {creditamount} end
--- Custom Label - 61-90 Days
Formula (Currency) --- Summary Type is Sum
--- Formula - case when trunc({today})-{trandate} >90 then {creditamount} end
--- Custom Label - > 90 Days
Formula (Currency) --- Summary Type is Sum
--- Formula - NVL(case when trunc({today})-{trandate} between 1 and 30 then {creditamount} end,0) + NVL(case when trunc({today})-{trandate} between 31 and 60 then {creditamount} end,0) + NVL( case when trunc({today})-{trandate} between 61 and 90 then {creditamount} end ,0)+ NVL(case when trunc({today})-{trandate} > 90 then {creditamount} end,0)
--- Custom Label - Total Outstanding Balance

5.  Enter the name of the Search
6.  Click Save and Run