Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
posted
Best answer November 15, 2025
Solved
Best Answers
Hi, @finance235.
Currently, the A/P Aging summary and A/P Aging detail reports don't have a way to filter by class. However, you can achieve your goal by running the Transaction Detail by Account report, as you can add the Class column to it and then filter by Transaction Type, A/P paid, and Distribution account. Here's how:
- Enter Transaction Detail by Account in the report search box.
- Add the Class column through the Columns feature. If you don't see it immediately in the available option, go to More Columns and search for it. Optionally, add the Open Balance column.
- Make sure to add the Transaction Type and A/P paid columns if you haven't already. Also, set Group by to Distribution account.
- Filter your data using the Filter feature:
- Transaction Type (Tip: get the transaction types you see in the A/P Aging report and use them to refine your filters.)
- A/P paid = Unpaid
- Distribution account = Accounts Payable
Once done, compare the Amount from the Transaction Detail by Account report with the Total or Amount from the A/P Aging report; they should match. Lastly, be sure to align the Report period on both reports for the best results.
If you have any other concerns, feel free to reply in the thread.
Hi, @finance235.
Currently, the A/P Aging summary and A/P Aging detail reports don't have a way to filter by class. However, you can achieve your goal by running the Transaction Detail by Account report, as you can add the Class column to it and then filter by Transaction Type, A/P paid, and Distribution account. Here's how:
- Enter Transaction Detail by Account in the report search box.
- Add the Class column through the Columns feature. If you don't see it immediately in the available option, go to More Columns and search for it. Optionally, add the Open Balance column.
- Make sure to add the Transaction Type and A/P paid columns if you haven't already. Also, set Group by to Distribution account.
- Filter your data using the Filter feature:
- Transaction Type (Tip: get the transaction types you see in the A/P Aging report and use them to refine your filters.)
- A/P paid = Unpaid
- Distribution account = Accounts Payable
Once done, compare the Amount from the Transaction Detail by Account report with the Total or Amount from the A/P Aging report; they should match. Lastly, be sure to align the Report period on both reports for the best results.
If you have any other concerns, feel free to reply in the thread.
