Limited time. 50% OFF QuickBooks for 3 months.

Buy now & save
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
pdurocher
Level 1

Can I run an accounts receivable aging report by currency?

I have customers in multiple currencies and i want to run an accounts receivable report by currency. i.e. Euro, GBP, etc. Is this possible?

Solved
Best answer October 15, 2018

Best Answers
IntuitLeleth
Level 2

Can I run an accounts receivable aging report by currency?

Hi there pdurocher

Yes. You can customize the A/R Aging Detail report to show multiple currencies.

Here’s how:

  1. Click Reports on the left navigation panel.
  2. In the search field, type in A/R Aging Detail.
  3. Click Customize and select Rows/Columns.
  4. Select Change columns and put a checkmark in the Currency box.
  5. Click Run report.

That’ll do it! Feel free to reach out to me if you have further questions about customizing the report.

View solution in original post

6 Comments 6
IntuitLeleth
Level 2

Can I run an accounts receivable aging report by currency?

Hi there pdurocher

Yes. You can customize the A/R Aging Detail report to show multiple currencies.

Here’s how:

  1. Click Reports on the left navigation panel.
  2. In the search field, type in A/R Aging Detail.
  3. Click Customize and select Rows/Columns.
  4. Select Change columns and put a checkmark in the Currency box.
  5. Click Run report.

That’ll do it! Feel free to reach out to me if you have further questions about customizing the report.

valentine1
Level 1

Can I run an accounts receivable aging report by currency?

When i get to step no. 3, there is no where  to''Select Change columns and put a checkmark in the Currency box"
adam-kagan
Level 1

Can I run an accounts receivable aging report by currency?

Me too, has this been resolved?
keaobaka
Level 1

Can I run an accounts receivable aging report by currency?

same problem here
Upulineth
Level 1

Can I run an accounts receivable aging report by currency?

In Row/Column setting, it says "Show non-zero or active only"

 

How do I enable the currency option here ?

RusiO
QuickBooks Team

Can I run an accounts receivable aging report by currency?

Hi, @Upulineth. It seems you're trying to run the Accounts Receivable Aging Summary Report instead of the Accounts Receivable Aging Detail Report, which is likely causing the confusion. Allow me to provide you some information about the difference between the two.

 

The Accounts Receivable Aging Summary Report provides a clear overview of outstanding balances categorized by overdue periods, such as current and 1-30 days overdue. While rows and columns can't be added or removed, this report effectively highlights amounts from active accounts and non-zero balances.

 

In contrast, the Accounts Receivable Aging Detail Report breaks down these balances by individual customers and highlights specific overdue transactions for a more detailed view of accounts receivable. This report offers a more detailed view of accounts receivable, allowing you to customize the information to better suit your needs.

 

Additionally, QuickBooks Online allows you to Export your QuickBooks Online data if you wish to use them outside of QuickBooks. This is particularly beneficial for businesses that need to share financial information with stakeholders or team members who may not have direct access to QuickBooks.

 

Reports are essential for informed decision-making and keeping accurate records, Upulineth. If you need additional help managing your reports, please leave a comment below. The Community space is dedicated to providing you with the information and support you need.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us