Skip to main content
February 24, 2020
Question

How can I enter multicurrency opening g/l account balances when A/R and A/P details have been imported already ?

  • February 24, 2020
  • 1 reply
  • 0 views
Posting from a journal entry requires a customer or supplier.

1 reply

February 24, 2020

Hello sdavenport1,

 

It's nice to hear from you again and I can appreciate wanting to get through this so you can get to managing your books in QuickBooks Online. I'm here to help and can shed some light on why the program is requiring you to choose customers and suppliers for these kinds of transactions.

 

In QuickBooks, the Accounts Receivable and Accounts Payable accounts are linked to customer and supplier transactions. Entering an opening balance on these sorts of accounts is going to want a customer or supplier so it knows whose balance to affect with the amount given. This means either divvying up the amounts to be allocated to the appropriate customers and suppliers on the journal entries if you're hoping to enter them all at once. Learn more here: What to do if you didn't enter an opening balance in QuickBooks Online

 

Another option for entering a customer or vendor opening balance is to do so directly from the customer or vendor information windows. I'll outline how to do it below.

  1. Hover over Sales in the left menu and choose Customers.
  2. Select New customer or the name of an existing customer.
  3. For an existing customer, click Edit on the next page.
  4. Navigate to the Payment and billing tab of the Customer Information window.
  5. Enter an Opening balance and choose the appropriate as of date (Note: You will not be able to enter an opening balance if the customer has open transactions).
  6. Click Save when done.
  7. Repeat this as needed with other customers.

For suppliers, it's a similar process.

  1. Hover over Expenses in the left menu and choose Suppliers.
  2. Click New supplier or the name of an existing supplier.
  3. For an existing supplier, click Edit on the next page.
  4. Enter the Opening balance and choose the appropriate as of date (Note: You will not be able to enter an opening balance if the supplier has open transactions).
  5. Click Save.

With either of these processes, you'll have balances entered for your customers, suppliers, and their related accounts, which should get you on your way. Give them a try an let me know if you have further questions. I'm here to help!