cancel
Showing results for 
Search instead for 
Did you mean: 
Jimbozeubuen
Level 1

In QB Online, is there a way to run AR and AP aging reports by transaction (invoice) dates, instead of due dates? This was easy to do in QB Desktop.

 
Solved
Best answer August 24, 2020

Best Answers
Charies_M
Moderator

In QB Online, is there a way to run AR and AP aging reports by transaction (invoice) dates, instead of due dates? This was easy to do in QB Desktop.

Glad to have you here, Jimbozeubuen.

 

The Accounts receivable aging detail and Accounts payable aging detail reports are set to show transactions grouped by days of past due. Instead, you can run the Transaction Detail by Account report and customize the filters to group AR/AP transactions by invoice dates.

 

Here's how:

 

  1. Go to Reports.
  2. Enter Transaction Detail by Account in the search field.
  3. Click the Customize button.
  4. From the Filter drop-down, mark the following boxes:
    Transaction Type and choose Invoice.
    Account and choose All Accounts receivable.
    Service Date and choose the your preferred period date.
  5. Click Run report.

Here's a sample screenshot on how the report would look like after applying the customization above.
2.PNG

 

I'm also adding the following resources to learn more about customizing reports in QBO: Customize reports in QuickBooks Online.

 

Having the option to group the aging reports by invoice dates instead of due dates is a good idea. While we continue to work in making sure we meet our customers needs, please check out our QuickBooks Blog to be updated with our product's latest feature release.

 

Drop me a reply if you have additional queries. It would be my pleasure to help. Have a good one.

View solution in original post

Jovychris_A
Moderator

In QB Online, is there a way to run AR and AP aging reports by transaction (invoice) dates, instead of due dates? This was easy to do in QB Desktop.

Thanks for your prompt response and for sharing more details, @Jimbozeubuen.

 

Currently, running AR and AP aging reports by invoices services dates is unavailable in QuickBooks Online.

 

I know how beneficial it is when we could run this kind of report in QBO. Please know that I'm taking note of this one. In the meantime, I encourage you to visit our QuickBooks blog site for updates such as feature release and product enhancements.

 

Also, you can try new features in our QuickBooks Labs like QuickBooks Themes and Community Reports shared by others. Just go to the Gear icon and then select QuickBooks labs under  Your Company section.

 

Feel free to place a comment or tag me (@Jovychris_A) if there's anything else. I'm always around to help. Take care!

View solution in original post

6 Comments 6
Charies_M
Moderator

In QB Online, is there a way to run AR and AP aging reports by transaction (invoice) dates, instead of due dates? This was easy to do in QB Desktop.

Glad to have you here, Jimbozeubuen.

 

The Accounts receivable aging detail and Accounts payable aging detail reports are set to show transactions grouped by days of past due. Instead, you can run the Transaction Detail by Account report and customize the filters to group AR/AP transactions by invoice dates.

 

Here's how:

 

  1. Go to Reports.
  2. Enter Transaction Detail by Account in the search field.
  3. Click the Customize button.
  4. From the Filter drop-down, mark the following boxes:
    Transaction Type and choose Invoice.
    Account and choose All Accounts receivable.
    Service Date and choose the your preferred period date.
  5. Click Run report.

Here's a sample screenshot on how the report would look like after applying the customization above.
2.PNG

 

I'm also adding the following resources to learn more about customizing reports in QBO: Customize reports in QuickBooks Online.

 

Having the option to group the aging reports by invoice dates instead of due dates is a good idea. While we continue to work in making sure we meet our customers needs, please check out our QuickBooks Blog to be updated with our product's latest feature release.

 

Drop me a reply if you have additional queries. It would be my pleasure to help. Have a good one.

Jimbozeubuen
Level 1

In QB Online, is there a way to run AR and AP aging reports by transaction (invoice) dates, instead of due dates? This was easy to do in QB Desktop.

Thanks for the detailed response. This is a nice workaround, but it doesn't display the aging buckets (such as current, 1-30, 31-60, etc.) by transaction (invoice) date like QB Desktop does. It would definitely be great if QB Online can implement this feature in the future.

Jovychris_A
Moderator

In QB Online, is there a way to run AR and AP aging reports by transaction (invoice) dates, instead of due dates? This was easy to do in QB Desktop.

Thanks for your prompt response and for sharing more details, @Jimbozeubuen.

 

Currently, running AR and AP aging reports by invoices services dates is unavailable in QuickBooks Online.

 

I know how beneficial it is when we could run this kind of report in QBO. Please know that I'm taking note of this one. In the meantime, I encourage you to visit our QuickBooks blog site for updates such as feature release and product enhancements.

 

Also, you can try new features in our QuickBooks Labs like QuickBooks Themes and Community Reports shared by others. Just go to the Gear icon and then select QuickBooks labs under  Your Company section.

 

Feel free to place a comment or tag me (@Jovychris_A) if there's anything else. I'm always around to help. Take care!

indu_nilukshi
Level 1

In QB Online, is there a way to run AR and AP aging reports by transaction (invoice) dates, instead of due dates? This was easy to do in QB Desktop.

Hi There 

 

I am unable to see an option call service date 

exempt5
Level 2

In QB Online, is there a way to run AR and AP aging reports by transaction (invoice) dates, instead of due dates? This was easy to do in QB Desktop.

Come on Quickbooks.  Don't we think after 4 years we can get this critical report updated.  Especially how the summary reports groups both positive and negative amounts together.  Please add a choice in the Row/Column section for details.  Without the details by VENDOR/CUSTOMER below the total we have to resort to multiple reports and spend countless hours reconciling and reviewing.  

 
 

 

RogelioL
QuickBooks Team

In QB Online, is there a way to run AR and AP aging reports by transaction (invoice) dates, instead of due dates? This was easy to do in QB Desktop.

I appreciate and hear your feedback about the reports in QuickBooks Online.

 

Firstly, please know that we still don't have a specific report for Accounts Payable (A/P) and Accounts Receivable (A/R). However, our reports in QuickBooks Online have a new feature that you can utilize to customize the Transactions Detail By Account.

 

Here's how:

  1. Navigate to the Reports tab.
  2. On the search panel, enter Transaction Detail by Account.
  3. Click the Columns, located at the top right corner.
  4. Choose Either A/P paid, A/R paidVendor, or Customer.

 

Once done, let's add a Filter that matches your preference:

  1. After the process above, click the Filter located near the Columns.
  2. In the Filter By, choose any of the Columns you've added above.
  3. Click Equals in the Options tab.
  4. If you've clicked A/R or A/P, you can select Paid and Unpaid in the Value tab.
  5. If you've clicked Customer or Vendor, you can choose a specific vendor or customer in the Value tab.

 

For further details about customizing a report using the modern view, please refer to this article: Modern view customization reports in QuickBooks Online.

 

If you wish to add a specific report to QuickBooks, I suggest submitting feedback to our product engineers. Also, you can track the status of your request in our customer Feedback for QuickBooks Online.

 

Additionally, you can memorize the report you've previously run to save its current customization. Memorizing a report can help you save time, as you can utilize the previous report you've made without customizing again.

 

Let me know if you have further concerns about running and customizing a report. Keep safe.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us