Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I have a Bank Chequing CAD account (CAD Acct) and a Wise USD account (USD Acct) connected to QuickBooks. I am trying to properly record transfers and fees related to Wise but cannot figure it out.
Essentially money is transferred from the CAD Acct to the USD Acct and is translated to USD as well as having a Wise fee included in the amount. For example if I was looking to transfer $20 USD to the USD Acct from the CAD Acct it would show as the following:
Total Sent: $29.67
Our Fee: $3
+
Converted: $26.67 (FX Rate: 0.750 = USD $20)
As a result, on the QuickBooks transaction feed for the CAD Acct I have a money out of $29.67 and have QuickBooks transaction feed for the USD showing money in of $20 USD.
I am looking to use QuickBooks record a transfer function to “match” this transfer between the two accounts as well as recording the Wise fee as an expense. I also believe that FX rates used by Wise and QuickBooks would differ.
Wondering if anyone has encountered this/has any solutions. My initial thoughts is the “match” function wont be able to be used and I will need to post journal entries and delete the transactions instead but hoping not the case.
Hi there TurtleHermit,
It's important that all your transactions be entered correctly for your books to be well balanced. QuickBooks Online is a great tool able to connect to your bank so that you can match them to the transactions in your books. I can provide some information about matching.
QuickBooks Online can match one transaction in the banking tab to more than one in your books, so what can be done is you create the transfer from the chequing account to the USD account by going to the +Newbutton, then Transfer. Enter the amount in CAD for the chequing account, then manually adjust the exchange rate in the text box so that the value in foreign currency is total to the amount that was deposited in the second account.
The second step would be to create the expense for the fees, by going to +New, then expense. Enter the information for this expense, then for the payment account, you'd need to select the bank account from which the money was transferred, which in this case would be the CAD account. Once done, hit Save.
You can then go match these two transactions by going to the Banking tab, then click on the transaction's description. Select find match, then put a checkmark beside both the transfer and the expense to match them to the bank transaction.
If you have any other questions, feel free to reach out here.
Just wanted to start by saying thank you for a prompt response. I have a few further questions below:
"QuickBooks Online can match one transaction in the banking tab to more than one in your books, so what can be done is you create the transfer from the chequing account to the USD account by going to the +Newbutton, then Transfer. Enter the amount in CAD for the chequing account, then manually adjust the exchange rate in the text box so that the value in foreign currency is total to the amount that was deposited in the second account."
The transfer to chequing account already exists as this account is also linked to QBO. Sorry if this was not clear. Using the above solution with this knowledge I would essentially need to manually recreate the existing transfer and turn it into two separate transactions per say. one for the transfer of funds, another for the expense, Is this correct to say?
Thank you again.
What you've described sounds right in terms of making sure you achieve the goal you've reached out about. I encourage you to take that route and let me know if you have additional questions as you go through the process. I'll be one message away.
Yes and no. My main goal would be so that I take the transfer and I am able to use the match feature to match this to my Wise USD account.
I'm trying to figure out if QBO has that capability currently, to split lump sum amount into an expense and a transfer, record the expense as such, and match the transfer to the Wise USD account
Hi TurtleHermit,
QuickBooks Online enables you to split transactions, when you need to list multiple accounts. Here's how;
1. Open your Settings ⚙ and select Chart of Accounts
2. Locate the account for the transaction
3. Under the Action column, select Account history
4. Select the transaction, then Edit.
5. Enter the other accounts to add with the amount
6. Hit Save
The transaction now displays Split in account column.
You can also split transactions from the For review tab in the Banking feature. Here's a helpful guide for your reference.
Please feel free to contact us if you require additional assistance. We'd enjoy the opportunity to work with you directly and ensure you're able to accomplish your QuickBooks goals as soon as possible!
Schedule a Callback or start a Chat: click (?) Help in the upper right in QuickBooks Online > enter "Contact support" > hit Contact Us > provide a brief summary of your situation > hit Let's Talk > choose Get a callback or Start a Chat.
Social Media: Facebook, Twitter, and Instagram.
Support hours are from Monday to Friday between 9 a.m. and 8 p.m. ET.
If you have other questions, feel free to reach back out. We're here for you!
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