AR Aging Customizing by Product/Service

Currently, creating an A/R Aging Detail report broken down by product/service is unavailable in QuickBooks Online. The standard aging report only tracks overall invoice totals in Accounts Receivable. Mapping your retention to a separate Current Asset account removes those funds from A/R, so they can't show up in the aging report.

However, as you're open to Excel, you can combine two reports to get a complete picture of both your Aged A/R and Aged Retention. Here's how:

1. Navigate to the Reports menu, search for Accounts Receivable Aging Detail, and open the report.
2. Filter the report period and click the Export icon. Then, choose Export to Excel.
3. Next, search and open the Transaction Detail by Account report.
4. Click Customize, filter it by Account type, and pick the Other Current Asset account in Value section.
5. Select Customize, select Account Type and Choose Other Current Asset used for retention.
6. Set A/R Paid in the Filter by section and Unpaid for the value.
7. Customize your columns and include the Line created date and Line due date.
8. Customize your columns to include the Create Date and Due Date.
9. Download a copy of this report to Excel as well.
10. Once done, drop the retention data onto a second tab in your first workbook to view them side-by-side or analyze them using a Pivot Table.

If you're using QuickBooks Online Advanced, you can use Spreadsheet Sync to pull live data for open invoices and your retention account into Excel, then build a Pivot Table to calculate days past due for both.

Let us know if you have any other concerns.