Skip to main content
July 3, 2022
Question

Emailed invoices don't match those downloaded in bank statements (different exchange rates). As result, we have many duplicated expenses. How do you go about that?

  • July 3, 2022
  • 1 reply
  • 0 views
* invoices for all expenses. 
Isn't it simpler to just download bank statements and then add photos of receipts/expenses once auditing bank statements?

1 reply

July 3, 2022

Hello there, @kamila. I'm here to help you sort out this issue with your bank transactions that we're unable to match due to exchange rates.

To match them, you'll need to modify the exchange rate on the transaction specifically. You might consider looking for a currency conversion calculator when doing this.

On the other hand, duplicate transactions can be undone or deleted. I'll share with you the steps to remove duplicates directly from your account.

 

Here's how:
 

  1. Go to the Banking or Transactions menu.
  2. Click the Banking tab.
  3. Click the For review tab
  4. Put a checkmark on the transaction you'll want to exclude.
  5. Select Exclude deleting the transactions. 

Additionally, after you remove the duplicates and modify the exchange rates of your invoices, you can consider categorising and matching your transactions again.


On the other hand, yes, you can just download the bank statements and upload your receipts and bills to QuickBooks Online. This will save time to track and record your transactions. After you've downloaded them, you'll just need to match them from the downloaded bank statements. 

For more additional insights and detailed steps, please visit this article: Upload your receipts and bills to QuickBooks Online.

I'll also share this article for your future reference: Reconcile an account in QuickBooks Online.

 

Let me know if you have any clarifications or any additional QuickBooks-related concerns. I'll be happy to help you. Have a great day!