cancel
Showing results for 
Search instead for 
Did you mean: 
nicholas-onetree
Level 1

My company bank account is in USD but I deposited a CAD check. This has appeared as 2 separate items in my linked bank account. How do I process this?

The 2 line items are due to the one reflecting the receipt of the check amount (unadjusted for forex) and a payment for the forex change.
6 Comments 6
Kristine Mae
Moderator

My company bank account is in USD but I deposited a CAD check. This has appeared as 2 separate items in my linked bank account. How do I process this?

Let me help you sort this out, Nicholas-onetree.

 

In QuickBooks Online, the Online Banking feature will automatically identify and use your home currency. This is why foreign transactions are not showing when matching. Having said that, if you're trying to match the transactions with a different one other than your home currency, you're unable to do it.

 

You'll want to exclude the transactions instead. Then, manually add them to the program. 

 

If you have more questions, feel free to leave a reply below. We'll respond as soon as we can. Take care!

nicholas-onetree
Level 1

My company bank account is in USD but I deposited a CAD check. This has appeared as 2 separate items in my linked bank account. How do I process this?

Thanks, but now that I have excluded the incoming and outgoing transactions how do I add another transaction with the net figure to allocate to the check that has been received against the debtor?

AileneA
QuickBooks Team

My company bank account is in USD but I deposited a CAD check. This has appeared as 2 separate items in my linked bank account. How do I process this?

Hello, nicholas-onetree. 

 

Thank you for posting here in the Community. You can create a Journal Entry to allocate check that has been received against the debtor.  

 

  1. Click the (+ New), then choose Journal Entry.
  2. In the Account Field, choose Creditors from the drop-down list.
  3. Enter the amount in the Debit field.
  4. The amount in the Credit field should be equal to the amount in the Debit field.
  5. Press Save & Close. 

 

To know more about this process, you can check this article for your reference: Create a journal entry in QuickBooks Online

 

As always, we recommend consulting with your accountant on the best way to handle this. 

 

Feel free to reach out to us. While we can't provide an accounting advice, we want to make sure any technical questions you have about the system are answered. Stay safe!

nicholas-onetree
Level 1

My company bank account is in USD but I deposited a CAD check. This has appeared as 2 separate items in my linked bank account. How do I process this?

This is not a Creditor payment, it is a Debtor receipt. 

If I process a journal entry will this not affect the bank recon?

Are you suggesting that I process the following journal:

Dr Bank $xx

Cr Debtor $xx

nicholas-onetree
Level 1

My company bank account is in USD but I deposited a CAD check. This has appeared as 2 separate items in my linked bank account. How do I process this?

Hi, can you please reply.

RCV
QuickBooks Team
QuickBooks Team

My company bank account is in USD but I deposited a CAD check. This has appeared as 2 separate items in my linked bank account. How do I process this?

Thanks for coming back, nicholas-onetree.

 

For the Dr Bank $xx or Debit field, just enter the exact amount.  However, for the Cr Debtor $xx side, we'll need to consult your accountant about this one since the amount in the Credit field should be equal to the amount in the Debit field. Once you have the information, you can now create the journal entry: 

  1. Click the + New button, then select Journal entry.
  2. On the page, choose the appropriate accounts from the drop-down.
  3. Fill out the necessary information.
  4. Click Save and close.

To learn more about this one, see the Create a journal entry in QuickBooks Online article. To keep updated with any upcoming QuickBooks updates and enhancements, feel free to visit these blogs:

 

Visit our Banking page for more insights about managing your bank transactions.

 

Feel free to update us on the result of this troubleshooting in the comment below. I'd like to ensure this is resolved for you. You have a good one.

Need to get in touch?

Contact us