Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
How do i receive payment in USD to my USD fx bank account and transfer it to my AUD bank account for receiving as a payment for an AUD invoice in QBO, so it reconciles correctly?
Currently I am invoicing my Canadian customer in AUD who pays me in USD into my FX Cash and cash equivalents account, which I then exchange for AUD in that account and transfer it to the Cash and cash equivalents AUD home currency account and Categorised as Accounts Receivable (A/R) AUD to then be applied to specific Invoice as payment.
Currently when I receive USD into my FX Cash and cash equivalents account I categorise as Accounts Receivable (A/R) - USD which can't be reconciled to the associated AUD invoice.
Therefore I have an unreconcilable amount in my Balance Sheet in Accounts Receivable (A/R) - USD.
Can I create a Clearing Account as Unapplied Cash Payment Income USD or Uncategorised Income USD instead of Accounts Receivable (A/R) - USD and when FX exchanged from USD to AUD in FX Account it could then be transferred to Cash and cash equivalents AUD home currency account?
I have read the QuickBooksHelp, Receiving and making payment for a foreign invoice/ bill with a foreign currency, about setting up a Dummy Account but is this the same as a clearing account.
Any help appreciated so I can reconcile and balance my accounts.
Yes, WebPro25. Dummy Account and Clearing Account serve similar purpose for multi-currency transactions, typically a temporary holding account used specifically for recording transactions involving foreign currencies, helping to manage exchange rate differences during invoice/bill payments. Allow me to guide you about managing cross-currency payments in QuickBooks Online.
To begin with, we'll have to create a new dummy bank account in the home currency to facilitate the movement between two (2) different foreign currencies.
Here's how:
Next, we need to record payment of the foreign invoice. In the Receive Payment , set the Deposit To field to Dummy Bank. Before saving the transaction, take note of the home currency (AUD) amount displayed at the bottom right.
Lastly, we’ll have to transfer the created account with the right amount from Dummy Bank to the EUR bank account.
Moreover, I'm adding this article for future reference on how to reconcile your accounts, so that they always match your bank and credit card statements: Reconcile an account in QuickBooks Online.
Keep me updated by leaving a post if you still require assistance with managing cross-currency payments in QBO. Don't hesitate to hit Reply below, we'll get back to you.
Hi Jovelyn,
Appreciate the response.
To help ensure we are of the same understanding I wanted to share my exact process steps & how with you below so I can rectify my current 6 months of reconciled accounts for future correct processing in QBO.
My current process steps are as below:
My problem seems to be that when Categorising the USD payment as Accounts Receivable (A/R) - USD in the un-linked USD FX Bank Account-Account Type Cash and cash equivalents-Detail Type Cash and cash equivalents-Currency USD it creates an un-balanced amount because it is not applied to an invoice.
Many thanks for your assistance to get this right,
Phillip
Further thoughts.
Isn’t the USD FX Bank Account-Account Type Cash and cash equivalents-Detail Type Cash and cash equivalents-Currency USD effectively the real receiving and clearing account for USD payments of AUD invoices?
Perhaps the following is relevant to my situation:
as the replacement for the Dummy/Clearing FX Account
with the exception that it is Currency USD instead of AUD
Therefore, instead of creating a Dummy/Clearing Account, would changing the existing FX Cash and cash equivalent account, which is a real bank account, Detail Type from Cash and cash equivalents to Cash on hand work?
Which raises the question.
Does the Currency matter if I am transferring into the Business Bank Account-Account Type Cash and cash equivalents-Detail Type Cash and cash equivalents-Home Currency AUD, the accurate AUD exchange amount from USD that was used when the exchange was done?
You're correct, WebPro25. The USD Foreign Exchange (FX) Bank Account is the primary account for receiving and processing USD payments related to AUD invoices. Let me explain how this works in detail.
This functionality is due to its integration with multicurrency features, its capability to handle exchange rates, and its support for smoother cash flow management.
However, changing the Detail Type of the FX Cash account from "Cash and cash equivalents" to "Cash on hand" is not advisable, as it may negatively impact accounting and reporting in QuickBooks Online (QBO). The current type suits a real bank account that processes transactions, especially in a multicurrency context.
If you need a dummy or clearing account, it’s better to create a separate one while keeping the existing FX account active. I also suggest consulting your accountant for expert guidance on how to structure and use clearing accounts, ensuring compliance with accounting standards and best practices.
Regarding your question about transferring funds into a Business Bank Account classified as "Cash and cash equivalents" with a home currency of AUD: Yes, the currency matters. It's essential to use the accurate exchange amount from USD to AUD at the time of the transaction to ensure correct financial records.
QuickBooks Online (QBO) automatically updates foreign currency values every 4 hours from Wall Street on Demand and uses exchange rates from IHS Markit. You can check out this article for detailed information: Learn to use Multicurrency in QuickBooks Online.
If you encounter issues during your reconciliation process, refer to this article for detailed guidance: Fix issues with your beginning balance for accounts you've reconciled before.
You can ask us whenever you have further concerns about managing multicurrency transactions. We'll always be available to help you out. Stay safe!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here