Thank you for reaching out to us! I'll make sure you can view your aging report for foreign AP accounts.
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 Customize 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/P Paid.
6. Press Run report when you're done.
I've also added this article that'll help you customize reports and basic info in Quickbooks Online.
Please do get back on this thread if you need further assistance in customizing reports. I'm always here to help you.
Thank you but this is not what I am looking for. My Aging report does not tie to the the General Ledger Account for Accounts Payable. My issues is with Vendors and not Customers. In my General Ledger Account, Bills are shown in the euros amount. Payments are shown in USD amount. For example, I owe a vendor/bill EUR 1,500 (translated approx to $1,705)... I pay them $1,700. My AP account shows that I was billed $1,500 and paid $1,700...so it says that I overpaid them by $200. The $5.00 f(x) is correctly hitting foreign exchange. My GL account has a credit of $(200.00) ...my aging report = zero. Why? What are we doing wrong that no other company has this issue? This is an automatic import from a third party system. I make several overseas payment. Manually changing it every time cannot be the solution. Hopefully this clarifies my issue. Any help is appreciated. I was on the phone with support for 4 hours already today.
Thank you for providing additional info on your concern, @hmeskell.
In QuickBooks, to receive and make payment with a foreign bill, you can use a Dummy Bank account. Then, transfer the money from a foreign bank account to the dummy bank. To do so, you'll need to ensure that the Multicurrency feature is enabled. To start, create a new dummy bank account in the home currency to facilitate the movement between 2 different foreign currencies:
Once done, go to the +New and then, Receive Payment. Set the Deposit To field to Dummy Bank. Before saving ensure that the home currency amount is shown at the bottom right.
Then, refer to this article to transfer the amount from the dummy bank to the foreign bank: Receiving and making payment for a foreign invoice/ bill with a foreign currency.
You might also want to visit our help page to browse articles that can guide you with your QBO tasks. To get started head to our QBO help articles at this link.
If you need further assistance about this, feel free to post a reply below. I'm always here to help. Have a good one.
Sorry but this does not answer my question. I was on hold for 4 hours on Monday to resolve this. Someone was to call me back..but no one did. Can someone please call me because no one is answering my question on this thread.
Allow me to join this thread and share some details about your foreign AP account.
Once you enabled the Multicurrency feature, QuickBooks Online creates a separate AP account for every currency you used. This way, all your transactions will be segregated based on the currency so that your data is accurate.
Additionally, upon checking, there's an investigation where some Bill.com foreign transactions were recorded in US currency. I understand that you need this to be resolved. As much as I want to call you and fix this, we only have limited tools. It's best to reach out to our Support Team again for further assistance.
For your reference, here's how to receive and make payment for a foreign invoice/ bill with a foreign currency.
Need more help? Keep your posts coming and we'll respond as soon as we can.