Skip to main content
December 30, 2019
Question

I made a Bill Pmt for a USD payee using my CAD bank account, and it recorded in the CAD bank GL. Why is it not showing up as a possible match during reconciliation?

  • December 30, 2019
  • 1 reply
  • 0 views
Context: I'm trying to match transactions and reconcile my CAD account, and while this bill payment is certainly part of the CAD transaction, it's not showing up as a possible match.

1 reply

December 30, 2019

Hey shawnlangley,

 

Matching your bank transactions as you go is a great way to keep your books balanced, and sets you up for a much easier reconciliation down the road. This is especially true for foreign currencies, as it will automatically calculate and keeping track of the various exchange rates your business is exposed to. 


Foreign currency bank transactions are handled similarly to home currency transactions, with a few minor differences. You seem to already know your way around matching home currency transactions, so I'm confident you'll be an expert in no time. You can match payments such as this one in just a few simple steps:

  1. Head to your Banking tab then select your CAD bank account, then click on the transaction you'd like to match.
  2. Select Find match in the upper left.
  3. Select Foreign currency in the upper left (if you don't see the bill payment, make sure it is within From and To fields). 
  4. Select the payment you wish to match. You may receive a message advising you the exchange rate will be updated.
  5. Click Save.

 

The best practice is to ensure the transaction is unreconciled in QuickBooks and has the same date, bank/credit account, and amount as the downloaded bank transaction. This helps the system automatically detect the match, so you don't have to.

 

Feel free to reach out if you'd like any further assistance.