cancel
Showing results for 
Search instead for 
Did you mean: 
Senior Explorer *

Opening balance equity

How can I establish my opening balance after the bank information has been imported? 

As an example, My actual opening balance was $100.  But The info imported from the bank states as a MEMO that a transaction of $384.53 is my "Opening Balance from Bank".  How can I remove this association and choose the correct transaction as the opening balance?

 

Thnx

Solved
Best answer 10-14-2018

Accepted Solutions
ProAdvisor

Re: Opening balance equity

Hello @oscortega:

 

This is one of my pet "peeves" when you hook up a bank feed initially.  It goes back 90 days and then it enters whatever the balance is at that time AND it reconciles that transaction (causing a whole other issue).  Here is a post I wrote on logging in and connecting the bank for the first time.  And the steps you need to follow to remove that unwanted reconciled opening balance transaction.

 

I hope that helps you.   If you need more help, feel free to reach out.  Happy Sunday!

 

Lynda

View solution in original post

Highlighted
Senior Explorer *

Re: Opening balance equity

Hi Lynda,

 

Thank you so much for sending me the link to your video.  I did watch and it was very clear.  I simply deleted the opening balance that QBO created.  I now have as you did in the video a balance of zero when I go to reconcile.

 

My question now is maybe a silly one.  I opened the bank account with $100.  I was assuming (before watching your video) that this was my opening balance.  But yoyr video made it claer to me that an opening balance is obviously a zero balance.  The first transaction of course is just that...a first transaction.  AM I correct?  That minimum $100. dollar deposit used to establish a bank account is not an opening balance.   It is simply the first transaction recorded?

View solution in original post

ProAdvisor

Re: Opening balance equity

@oscortega:  Not a silly question at all. Yes, the $100 would be your first transaction.  The opening balance should be zero the first time you reconcile.  Code the $100 from wherever those funds came from.  IE, another bank account in your business, you personally (code to your equity account), etc.  Typically it is one of those two places mentioned.  

 

Lynda

View solution in original post

13 Comments
ProAdvisor

Re: Opening balance equity

Hello @oscortega:

 

This is one of my pet "peeves" when you hook up a bank feed initially.  It goes back 90 days and then it enters whatever the balance is at that time AND it reconciles that transaction (causing a whole other issue).  Here is a post I wrote on logging in and connecting the bank for the first time.  And the steps you need to follow to remove that unwanted reconciled opening balance transaction.

 

I hope that helps you.   If you need more help, feel free to reach out.  Happy Sunday!

 

Lynda

View solution in original post

Highlighted
Senior Explorer *

Re: Opening balance equity

Hi Lynda,

 

Thank you so much for sending me the link to your video.  I did watch and it was very clear.  I simply deleted the opening balance that QBO created.  I now have as you did in the video a balance of zero when I go to reconcile.

 

My question now is maybe a silly one.  I opened the bank account with $100.  I was assuming (before watching your video) that this was my opening balance.  But yoyr video made it claer to me that an opening balance is obviously a zero balance.  The first transaction of course is just that...a first transaction.  AM I correct?  That minimum $100. dollar deposit used to establish a bank account is not an opening balance.   It is simply the first transaction recorded?

View solution in original post

ProAdvisor

Re: Opening balance equity

@oscortega:  Not a silly question at all. Yes, the $100 would be your first transaction.  The opening balance should be zero the first time you reconcile.  Code the $100 from wherever those funds came from.  IE, another bank account in your business, you personally (code to your equity account), etc.  Typically it is one of those two places mentioned.  

 

Lynda

View solution in original post

Senior Explorer *

Re: Opening balance equity

Hi Lynda,

Thank you.

Can you explain what is an Equity Account?  Would this simply be your current balance?  meaning the end amount of funds regardless of liabilities across multple accounts (if more than one account)?

Or your equity account is the balance after liabilities have been deducted? Becasue liabilites must be factored in and deducted before equity can be said to be equity?

 

I cannot find a simple, clear definition online. Thnx

ProAdvisor

Re: Opening balance equity

Hello @oscortega:

 

@lynda and Matthew @ParkwayInc here to give you a live discussion on what an equity account is and it's meaning to the business owner as well as its relationship to the other balance sheet accounts.

 

 

We hope that helps clarify this mysterious category on the balance sheet.  Basically, like Matthew stated, think of it as your "business scorecard".  Equity accounts are the financial representation of the ownership of a business.  We get into more detail in the video.  

 

Have a wonderful, prosperous week!  If you have any more questions, feel free to reach out to us.  And if you liked our answer, we would love a cheer or kudo!

 

Matthew and Lynda

Super Contributor *

Re: Opening balance equity

I have a question for opening balance on accounts- is it possible to just have the starting balance on an account without having to affiliate it with another account? And  are opening balances really equity? Doesn't equity mean the worth of your business? So if you started quick books with negative worth then your business will always have negative worth? I just don't think the starting balance (at the time you started quickbooks) is a good representation of your companies worth. Is there another account you can use for starting balance instead of Open Balance Equity? Because I know Open Balance Equity shows up on the Balance Sheet and I can't figure out how to zero out that negative amount from OBE. Even if I transfer it to another account then another account will be negative. How can I make it so that the OPENING BALANCES of my accounts don't show up on the Balance Sheet Report?

Super Contributor *

Re: Opening balance equity

I wrote my previous question before I watched your video that you posted. Very great informative video!

 

But I have a new question why does a positive (+) (starting balance in bank account) show up as a negative (-)  number when categorized as "other current assets". And negative (-) (starting balance loan on equipment) become a positive (+)  number when categorized as "fixed asset" on the balance sheet?

 

 

Content Leader

Re: Opening balance equity

Greetings, @Vitan.

 

I'll be happy to provide some clarification on this Opening Balance Equity issue. Rather than the worth of your business, Equity is more aptly defined as an individual's worth in the business. This is also often referred to as Capital. For example, if an individual invests $20,000 in the company but also brings in a $10,000 liability, their initial Capital is $10,000 (investment minus liability).

 

Is it possible to create an opening balance without affiliating it with another account?

QuickBooks Online uses double-entry accounting, so this initial capital is necessary for recording the Opening Balance of new accounts. Generally this only occurs when a new set of books is opened, as any accounts created thereafter can have both ends originate from within the business. For instance, a new bank account can have its beginning balance fed by transferring from an existing account or a loan will contribute its asset and liability simultaneously.

 

How does this represent my business's worth?

Remember that the Balance Sheet doesn't necessarily represent the wellness of your business, rather it proves that every balance has an origin and is equally and oppositely represented elsewhere in the records. Statements like the Profit and Loss that report income are more adequate for determining your company's success for a given period. Once your decided accounting period has ended and the books are closed, your Net Profit/Loss will flow into Retained Earnings and help balance your Owner's Equity. This way, even if you begin a period with negative equity, it will be increased if the business is doing well.

 

Much of this information is explained in detail in these resources and I strongly encourage you to check them out:

 

I also recommend getting in touch with an accounting professional for a personalized opinion. Every business is unique and they can make suggestions for handling those Opening Balances that are a perfect fit for your company. Look into the Intuit Find-A-ProAdvisor site to find certified professionals in your local area that are sure to have the answers you're looking for.

 

With this information, you'll be an Equity master before you know it. Please know I'm always available here for all of your questions and concerns. Thanks for reaching out, wishing you continued success.

Senior Explorer *

Re: Opening balance equity

Hi Lynda,

 

Thank you for the additional video.  A lot more information than I expected. LOL. 

If I understand correctly, I can delete the opening balance equtiy that the QBO forced in from my inital bank download as per the first video.  Then Categorize the $100. deposit (Chk transfer) which came from my personal account to my business account upon opening the business account as "Owners Investment"?

QuickBooks Team

Re: Opening balance equity

Greetings, oscortega.

 

Thanks for being part of the QuickBooks family. Helping out with updating your opening balance is my priority.

 

In cases like this, you’ll need to delete the opening balance equity that QuickBooks forced in from your initial download. Before performing the process, I recommend consulting with your accountant to ensure your records are in ship-shape.

 

To change the account opening balance:

  1. Go to the Gear icon at the top.
  2. Under Your Company, choose Chart of Accounts.
  3. Find the account name, choose Run Report on the Action column.
  4. In the Report period drop-down, choose All Dates.
  5. Then select Run report.
  6. Find the deposit posted at the earliest date noted as Opening Balance in MEMO/DESCRIPTION.
  7. Select the entry.
  8. In the Bank Deposit page, enter the correct dollar amount and date.
  9. Click on Save.

For future reference, check out this article on how to Change an account opening balance on a bank account.

 

Thanks for giving me the opportunity to help. I value the success of your business. Have a great day ahead.

Not applicable

Re: Opening balance equity

Lynda,

 

I followed your video and deleted the beginning balance that QB generated, but what if I need the beginning balance to be something other than zero?

Not applicable

Re: Opening balance equity

Your video was very helpful! My issue is an opening balance equity that suddenly appeared, throwing off my reconcile. It is on a Homeowners Association account,so deleting stuff is looked at very suspiciously! Do you have any suggestions for me?

QuickBooks Team

Re: Opening balance equity

 

Thanks for joining this thread, @omp-hoa.

 

The opening balance equity may show on the register for the following reasons:

 

  • Manually entered.
  • The amount was added in the Balance field upon the account setup.

Let's run the Audit Log Report to check who created the account. This is a built-in tool that can help see the history of changes made to transactions and who added them.

 

I have a few easy steps to open it:

 

  1. Go to the Gear icon at the top of your company to choose the Audit Log.
  2. Click on the drop-down for Filter to sort the data.
  3. In the Events section, make sure to select the Show All Events option.
  4. Click on Apply.
  5. Hit the View link to check who modified the entries.
    op.png op1.png op3.png

If you want to remove the opening balance equity, you can delete it in your account. Here's how:

 

  1. On the left panel of your company, tap the Accounting menu to choose Chart of Accounts.
    coa.png
  2. From the list, select the correct bank and click the View register to see the opening balance equity.
    bank1.png
  3. Click on the amount of the account in question to select the Edit button.
    bank2.png
  4. Hit the Yes option to proceed.

As always, I recommend consulting with an accountant. This is to ensure your records are tiptop shape.

 

For additional resources, the following contains detailed steps on how to add or edit transactions in the register: Modify transactions in QBO.


Keep in touch if you have any further questions or concerns. I’ll be more than happy to assist further. Wishing you the best.

 

Need to get in touch?

Contact us