cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
r4v3n
Level 1

Multiple Currencies in A/R Ageing Summary

Hello,
My query is with regards to the A/R Ageing Summary Report only, and not the A/R Ageing Detail Report.
 
I have clients that I invoice/bill in our local currency and others that I invoice/bill in a foreign currency (USD for example).
 
When I run the A/R Ageing Summary report, a general one with all my clients in the one report (for easier reconciliation), all the amounts are converted into our local currency.
I've cycled through all the options/filters (that I can see) in the Customise report section, but cannot find a way in which the amounts shown for each client  are in the original currency they were invoiced/billed in.
 
Can anyone kindly advise how I can achieve this?
 
Thanks..
Solved
Best answer June 02, 2020

Best Answers
Jen_D
Moderator

Multiple Currencies in A/R Ageing Summary

I'd be more than happy to share with you how the A/R Ageing Summary Report works in QuickBooks Online, @r4v3n,

 

Normally, the system uses your home currency on Summary Reports to show the actual receivables of the company. The total projected income from unpaid balances is multiplied with the current foreign exchange rate to help businesses review their cash inflows during the Fiscal Year.

 

If you'd like to see the raw data based on the currency billed for a foreign client, you can use the A/R Ageing Detail or a Transaction List by Customer Report. Here are the steps to do that:

 

  1. Go to the Reports menu and type Transaction List by Customer on the search field. You can also find this under Sales and customers.
  2. From there, click the Customise button.
  3. Tap the blue Change columns link to expand the options.
  4. Update the Report period.
  5. Mark the boxes for Foreign Amount, Foreign Net Amount, Currency, Exchange Rate, Due Date and A/R Paid.
  6. Press Run report when you're done.

 

 

To learn more about customising reports and basic tasks in QuickBooks Online, check out the following links:

 

Customise reports in QuickBooks Online

Help Articles for Quickbooks Online

 

For other questions about this or other topics concerning our program, feel free to mention me anytime. I'll be right here to help. Have a wondrous day!

View solution in original post

2 Comments 2
Jen_D
Moderator

Multiple Currencies in A/R Ageing Summary

I'd be more than happy to share with you how the A/R Ageing Summary Report works in QuickBooks Online, @r4v3n,

 

Normally, the system uses your home currency on Summary Reports to show the actual receivables of the company. The total projected income from unpaid balances is multiplied with the current foreign exchange rate to help businesses review their cash inflows during the Fiscal Year.

 

If you'd like to see the raw data based on the currency billed for a foreign client, you can use the A/R Ageing Detail or a Transaction List by Customer Report. Here are the steps to do that:

 

  1. Go to the Reports menu and type Transaction List by Customer on the search field. You can also find this under Sales and customers.
  2. From there, click the Customise button.
  3. Tap the blue Change columns link to expand the options.
  4. Update the Report period.
  5. Mark the boxes for Foreign Amount, Foreign Net Amount, Currency, Exchange Rate, Due Date and A/R Paid.
  6. Press Run report when you're done.

 

 

To learn more about customising reports and basic tasks in QuickBooks Online, check out the following links:

 

Customise reports in QuickBooks Online

Help Articles for Quickbooks Online

 

For other questions about this or other topics concerning our program, feel free to mention me anytime. I'll be right here to help. Have a wondrous day!

r4v3n
Level 1

Multiple Currencies in A/R Ageing Summary

An interesting work-around that should work.

Thanks @Jen_D ..