I have just begun to use Quickbooks online. I would like to set up bank accounts in several different currencies. Similarly, I need to set up Accounts Payable in a couple of foreign currency.
Of course, in each case, I need to define the opening currency balances (as at 31 March 2020) in account. That's straightforward. But I also need to apply the foreign exchange rates which prevailed on 31 March. More accurately, I want to apply the foreign exchange rates which I used (in accounts created in accounting software now supeceded by QBO) on 31 March when valuing those balances in my home currency. Once that's acheived, I can bring the accounts up to date and, using a home currency adjustment, value the up-to-date balances using QBO exchange rates.
So, in short, this is a question about imposing the home currency valuations of foreign curreny balances
I have already activated the multi currency feature; that much, I am comfortable with. Now, I have to create bank accounts in QB Online. Let's say I have a bank account in EUR (my home currency is GBP) with EUR 5,000.
I want to move my accounts over to QB Online, with a start date of 1 April 2020. I want my opening balances to match those I last reported, as at 31 March 2020. It is easy enough to establish the initial balance in QB Online as EUR 5,000.00. What I must also do is apply (to that 31 March EUR balance) the EUR/GBP exchange rate which I applied on 31 March. This way, QB Online will capture exchange gains and losses when I next revalue my the balance.
Thank you for getting back to this thread, @27975011
Yes, you can manually add a bank account in QuickBooks Online. Let me guide you how:
From the left menu, click the Accounting menu.
Choose Chart ofAccount.
Click New, then enter an Account Type, Detail Type, and Beginning Balance.
Click Save and close once finished.
With regards to applying an exchange rate to enter the opening balance, it isn't possible in QuickBooks Online. You can manually calculate the conversion, however, it will not capture the gain and loss.
I recommend checking with an accountant for suggestions as this process can affect the financial reports especially the balance sheet.
I've added these articles to know more about managing accounts in QuickBooks Online: