Skip to main content
November 11, 2021
Solved

US Receipt Matching

  • November 11, 2021
  • 1 reply
  • 0 views

Hi there. I have multiple receipts in US currency, so when I upload the receipt I use the US amount. When the bank transactions get uploaded, they are in CAD, so they never match. Just wondering what the best way to go about this. Thanks!

Best answer by Trish_T

Hi Tara,

 

In in addition to the information previously posted, I'd be happy to review additional options to help you reach your goal.  In QuickBooks Online, the receipts will only scan to Canadian currency.  For transactions in other currencies, you can enter them manually and attach the receipt to the expense, or there'll be times when you just need to revalue the exchange rate to ensure you're able to match your transactions.  I'll provide the steps for both options.

 

I see you've already setup the supplier in US currency, now let's create an expense that we can attach the receipt to.  You'll need to ensure your receipts are saved to a folder on your system.  When you're ready, follow these steps:

 

1. Select +New in the top left of your dashboard

2. Choose Expense

3. Enter the Payee from the drop-down

4. Choose the Payment Date

5. Complete all required fields

6. At the bottom, click the Attachments icon to browse for the receipt and then hit Open

7. When finished hit Save and Close

You've recorded the USD transaction and this should now match with your bank feed.

 

Here's how to revalue currency:

 

1. From the Gear in the top right, select Currencies

2. Click on Edit currency exchange in the Action column

3. Enter the date for the Market rate, or click Your rate to enter a specific amount

4. Hit Save when done

 

Here's a couple of articles for your reference:

Attachments in QuickBooks Online

Enter home currency adjustments for your foreign balances

 

I hope you find this to be helpful.  Enjoy the rest of your day!

 

 

 

 

 

 

 

 

 

1 reply

November 12, 2021

Hi Tara40,

Welcome to the Community. Matching your transactions is a good way to keep your transactions organized. QuickBooks Online allows you to match your banking transactions to ensure that they are well recorded to keep your books balanced. I'd be glad point you in the right direction to match banking transactions.

If your QuickBooks account has the Canadian home currency and the expenses of the receipts needed to be in Canadian amount, I'd encourage you to delete the expenses and recreate them with the Canadian currency. If your bank is Canadian and the expenses of your receipts need to be in US, you can try to match the transactions from the bank feed by clicking on Banking on the left navigation menu > and then select the Banking tab > choose your bank > click on your transaction >  select Find match and then Foreign currency. This will allow you to match your transactions.

Let me know if you have any questions, I'll be happy to help.

Tara40Author
November 12, 2021

Thank you so much! When I search for the receipts in foreign currency, they do not show up. The receipts are still listed as CAD, even though they are US. Is there a way to upload the receipts in USD?