Change date of a downloaded foreign currency transactions

noraknotes · ‎December 01, 2021

On the banking tab, I have a transaction downloaded from a bank in a foreign currency. QBO automatically pulls the exchange rate given the date that the transactions shows; however, the transaction date in QBO does NOT match the bank statement and I need to adjust the transaction date, which will in turn affect the currency exchange rate. These transactions are tens of thousands of dollars so a change to the exchange rate may have a material effect.

How do I change the date of the transaction? Will QBO pull a new exchange rate if I am able to change the date?

JessT · ‎December 01, 2021

Hi noraknotes,

Thank you for reaching out to the QuickBooks Community.

You'll want to categorize or accept the transactions and change their dates within the bank register. The exchange rate is based on the date you enter. You can try this on a few transactions to see the effect.

Let me know if you have other questions in mind. Take care and have a good one!

View solution in original post

JessT · ‎December 01, 2021

Hi noraknotes,

Thank you for reaching out to the QuickBooks Community.

You'll want to categorize or accept the transactions and change their dates within the bank register. The exchange rate is based on the date you enter. You can try this on a few transactions to see the effect.

Let me know if you have other questions in mind. Take care and have a good one!

MCB · ‎March 29, 2022

When I added a company to my account in QB, I entered the wrong date of when I wanted my bank to link. Is there a way I can change that date?

Jovychris_A · ‎March 29, 2022

Thank you for joining this topic, @MCB.

I see this is different from what my colleague answered. Currently, we're unable to change the date of when you wanted your bank to link. However, if you'll have to change the date of some transactions from your bank, please follow my peer's recommendation.

It's easy, let me show you how:

Click the Gear icon on the top right.
Select Chart of accounts.
Find the bank in question and then select View register.
Click the transaction and then change the date.
Hit Save.

Otherwise, you can upload transactions into QuickBooks Online if you need to add the later entries in the bank register. Feel free to check this link for more insights: Manually upload transactions into QuickBooks Online.

If you need a hand in getting the latest bank entries, here's how to download the most recent bank and credit transactions in QuickBooks Online.

Let me know if you have other banking questions. I'm always ready to help you out more. Have a great day!

Topics

Training

Community

Resources

Change date of a downloaded foreign currency transactions