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

Filter or Group Accounts Receivable or Accounts Payable aging reports by currency

I am unable to filter the A/R Aging report by the different currencies. It seems that the only option is to manually click through all the customers that are in the same currency.  Is there a way to add a filter so that I can see ONLY my USD A/R or A/P aging instead of all open items displaying mixed together?

1 Comment 1
Kurt_M
QuickBooks Team

Filter or Group Accounts Receivable or Accounts Payable aging reports by currency

Thank you for reaching out here in the Community, @David_Dupaix. I’ll share some information about your query.

 

You can manually click through all the customers with the same currency. Another workaround is to run the Transaction Detail by Account report. I'll show you how:

 

  1. On the left navigational bar, and then select the Reports tab.
  2. In the search bar, type Transaction Detail by Account.
  3. Click the Customize button and then go to Row/Column section.
  4. Below click the Change columns and then mark the box for currency.

 

For visual reference, you can refer on the screenshot below.

 

 

 

  5. You’ll then want to go to the Filter section and then filter the Distribution Account to AR & AP.

  6. Once done, click export to Excel and then from there. You can add filter to select only the customers that uses USD currency.

 

In case you want to print the report, you can click the Printer icon beside the Envelope icon.

 

image (47).png

 

Additionally, I'll be leaving this article for more information about how to memorize reports in QuickBooks Online. 

Let me know if you need further assistance with this by hitting the REPLY button below. I'll keep an eye for your response. Keep safe and have a good one!

 


 

Need to get in touch?

Contact us