cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Beyourownbank21
New Member

Importing Journal Entries with Custom Exchange Rates in QuickBooks

How can we import a journal entry (with csv file) involving a foreign currency account and use our own exchange rate instead of QuickBooks' system-generated rate?

2 Comments 2
Chrea
Level 6

Importing Journal Entries with Custom Exchange Rates in QuickBooks

Like this one?

 

RefNumberTxnDatePrivateNoteIsAdjustmentCurrencyExchangeRateAccountLineAmountLineDescEntityClassLocation
10101/10/2020Wire TransferFALSE  Savings-50,00Credit Savings   
10101/10/2020Wire TransferFALSE  Checking50,00Debit Checking   
10201/10/2020Wire TransferFALSE  Savings200,00Debit Savings   
10201/10/2020Wire TransferFALSE  Checking-200,00Credit Checking   
Alex M
QuickBooks Team

Importing Journal Entries with Custom Exchange Rates in QuickBooks

Hi there Beyourownbank21,

 

Thanks for reaching out about your journal entries. QuickBooks Online is a great tool able to assist you in keeping track of sales and expenses so you can see the profitability of your business. I can provide some information about this. 

 

When importing journal entries in QuickBooks Online using a CSV file, there is the option to specify a currency in a file and map it, but there isn't the option to specify an exchange rate. It would be imported with the default exchange rate for that time, and it would need to be adjusted manually after the import. I can see that this would be a feature that you'd like to see in the software. I recommend you leave feedback by clicking on the Gear Icon, then Feedback. The comments made in that section are considered by our developers for future features in the software.

 

If you have any other questions, feel free to reach out here.

Need to get in touch?

Contact us