how can I sort my A/R Aging Detail report in order of descending invoice number?

Thank you for reaching out with your question about sorting the A/R Aging Detail report in descending order based on invoice numbers when saving it as an Excel spreadsheet. I'd be happy to assist you with this.

To sort the invoice numbers in the desired order, you can utilize the sorting feature within the A/R Aging Detail report. By default, the report is categorized or batched by the due date difference. However, you can still sort the invoice numbers within each category.

Here's how you can achieve this:

1. Open the A/R Aging Detail report in QuickBooks Online.
2. Locate the Invoice Number column in the report.
3. To sort the invoice numbers in ascending order, click once on the arrow icon next to the "Invoice Number" column header.
4. Click again on the same arrow icon.

By toggling the arrow icon, you can switch between ascending and descending orders for the invoice numbers. Please note that this sorting action will maintain the categorization or batching by the due date difference within the report.

If you require a report that is categorized or batched solely based on the invoice numbers without any regard to the due date difference, you can explore custom report options or consider exporting the data to Excel and applying further sorting and filtering within the spreadsheet program.

I encourage you to use the built-in feedback feature in QuickBooks Online. This allows you to share your thoughts directly with our development team, who continuously work to enhance the software based on customer feedback. To send feedback, follow these steps: 
 

1. Click the Gear icon and choose Feedback.
2. Enter your feedback suggestion.
3. Press Next.

Your feedback is valuable to us, as it helps us understand your needs and improve our software. We appreciate your input and strive to deliver the best user experience possible. 
 

To learn more about customizing reports in QBO, you can check these articles. Each of them provides information on how you can modify and save what you have currently modified:

• Learn how to get the most out of your financial reports.
• Memorize reports in QuickBooks Online.

I'm always here ready to lend a hand if you have other concerns tracking the aging transactions of your customers. Please keep me posted. Have a good one.