Skip to main content
T
TurtleHermit
June 28, 2024
Question

US Bank Account, US AP, CAD Expense Account

  • June 28, 2024
  • 1 reply
  • 0 views

I am receiving USD invoices in April related to April that I am trying to record in AP and the appropriate expense. The expense account is CAD, the invoice is in USD through a USD bank account. When I try to post the AP journal entry in USD, QBO tells me that I can't use the CAD expense account due to the currencies not being the same. When I post the entry in CAD and try to match the actual USD payment it will not identify as a match. Therefore it does not let me appropriately clear AP when it is paid. I have multi currency enabled.

 

One invoice for example is paid now, I know the USD invoice amount, the translated CAD amount etc. but no matter what way I record the AP entry I cannot get them to match even using the same FX, CAD etc. 

 

The only solution I can think is I need to change this specific expense account to a USD account. This way currency conversion would be covered by QBO in running reports.and the AP entry would easily match the bank.

 

Any and all help appreciated. Thank you!

1 reply

T
Trish_T
June 28, 2024

Hi TurtleHermit,

 

Recording your transactions accurately in QuickBooks Online, is essential in keeping your books balanced.  I would be happy to provide some insight here!

 

Once multicurrency has been turned on, you can assign a foreign currency to your accounts.  Your chart of accounts will show account balances in their assigned currency and also have a column identifying the currency for each account.  Please note that income and expense accounts always use your home currency.  In addition, you can set a default currency to your customers and suppliers. 

 

Here's how to add a foreign currency account;

 

1. Open your Settings ⚙ and select Chart of Accounts

2. Hit New

3. Use the ▼ dropdown menu to select the appropriate Account type and Detail type

4. Enter a Name for the account 

5. Choose the currency for the account from the Currency ▼ dropdown menu

6. Hit Save and close.

 

Once you've created the transaction, you may need to recalculate the home currency value using current exchange rates.  The home currency value is based on the exchange rates used at the time of each transaction.  Here's how;

 

1. Open your Settings ⚙, then select Currencies

2. Under the Actions column, select the ▼ dropdown menu, for the currency you want to adjust, then Revalue currency

3. Enter a Date to run a currency revaluation

4. Decide whether you'd like it to be based on the Market rate or Your rate 

5. Select the Account you want to apply the revaluation to

6. Hit Save.

Note; Only one exchange rate can be saved per day per account.  You should be able to match your transactions and proceed to reconcile your account!

 

Feel free to touch base with us again, if you have other questions.  We will be close by!

 

T
TurtleHermitAuthor
June 28, 2024

Hi Trish,

 

Thank you for the response. I have some follow up questions based on it.

 

Multi currency has already been enabled. If income and expense accounts always use home currency does this mean I will not be able to create a USD expense account?

 

Also you said once I create the transaction to revaluate using the appropriate FX but I have already done that.

 

For example, my current situation is something like the following:

 

The expense has been paid for 9K USD, I see this in banking transactions in a USD bank account, when I select this transaction  in bank transactions within QBO it shows the CAD amount it would equate to. I then posted a journal entry that debits the expense and credits AP for this CAD amount. However once this occurs I am given no option to match the bank transaction to the AP JE I have posted, I assume because QBO is trying to match the USD to the CAD without converting.

 

Hope this is clearer, thank you.

T
Trish_T
June 28, 2024

Hi TurtleHermit,

 

QuickBooks Online enables you to add new accounts to your chart of accounts, with foreign currencies.  Here's a helpful guide to show you how.  When you add a supplier with a foreign currency, you'll be able to record transactions in the currency in which you pay the supplier, so your records remain aligned.

 

Should you require additional assistance, I feel you would benefit more, by contacting our Customer Care team at 1-855-253-1536 from Monday to Friday between the hours of 9 AM and 8 PM EST. With your consent, they'll connect with you virtually and ensure you're able to accomplish your QuickBooks goals as soon as possible!

 

Feel free to reach out with other questions. We are always glad to help!

Terms & ConditionsAccessibility statement