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?
Like this one?
RefNumber | TxnDate | PrivateNote | IsAdjustment | Currency | ExchangeRate | Account | LineAmount | LineDesc | Entity | Class | Location |
101 | 01/10/2020 | Wire Transfer | FALSE | Savings | -50,00 | Credit Savings | |||||
101 | 01/10/2020 | Wire Transfer | FALSE | Checking | 50,00 | Debit Checking | |||||
102 | 01/10/2020 | Wire Transfer | FALSE | Savings | 200,00 | Debit Savings | |||||
102 | 01/10/2020 | Wire Transfer | FALSE | Checking | -200,00 | Credit Checking |
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here