Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
K
klous-1
New Member
March 9, 2026
Question

Foreign Amount in AP Aging Report error

  • March 9, 2026
  • 1 reply
  • 3 views

In the AP Aging Report the Foreign Open Balance of each transaction shows only €0, despite the actual open balance being e.g. £20,000.00 and the foreign amount being eg €22,000.00.

See screenshot.

[Email attachment containing a filename with PII (email) removed.]

1 reply

M
MichaelaSQuickBooks Team
QuickBooks Team
March 10, 2026

Thank you for providing the details and the screenshot, klous-1. The possible reason your Foreign Open Balance is currently showing as €0 is that the report requires a triggered calculation to bridge the gap between your home currency (GBP) and the foreign currency (EUR). When exchange rates fluctuate, the system’s "link" to those values can become stale, causing the report to default to zero if a current rate isn't recognized for that period.
 

Revaluing your currency allows the system to recalculate the value of your open transactions based on current market rates. You can do this by going to the Gear icon, selecting Currencies under the Lists column, clicking the Edit currency exchange dropdown, and hitting Revalue currency. From there, choose all your open balances and hit the Revalue and Save button.
 

Please return to your A/P Aging Detail report and see if the value is now displaying. If it is still not appearing, I recommend contacting our QuickBooks Online Live support team. They have the tools and capabilities to conduct a deeper review of your report setup and history to resolve the issue immediately.
 

Please don't hesitate to leave us a response if you have other questions or concerns.

K
klous-1Author
New Member
March 10, 2026

Thanks for the reply, however, I did that and it did not work, still show as zero.

Clark_B
Clark_BQuickBooks Team
QuickBooks Team
March 10, 2026

I appreciate you getting back to the thread and updating us on the result, @klous-1. Since the value is still not appearing in your A/P Aging Detail report, the best next step is to contact our Live Support team directly so they can further investigate your account and determine why it’s showing as zero. You can simply go to the Help section, select the Search tab, and then choose Contact Us to type in your concern. Once you hit Continue, you can click the Chat or Callback option to get started.

 

For more information about our contact feature and support hours, please refer to this article: Get help with QuickBooks products and services.

 

We’re always here to help you if you have any other concerns.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement