How to cleanup Opening balance equity in QuickBooks Online

Подписаться 44 тыс.

Просмотров 40 тыс.

50% 1

You're doing a massive cleanup of QuickBooks Online and you come across an account called Opening Balance Equity on the Balance Sheet. What is Opening Balance Equity and how do you clean it up? Let's take a look.
--------------------------------------------
Remember to subscribe so you get all my latest videos as soon as they come out! Check the links below for more info and helpful resources.
Review your client's books in just 15 minutes - sign up for my QBO Smart Review Checklist: bit.ly/3kmRjhd
Save time and trouble cleaning up the messiest QBO files with the QBO Colossal Cleanup Checklist: bit.ly/2Te0pAT
Get notified about all my latest content, webinars, courses, and more: veronicawasek.ck.page/content
Join my Facebook community of virtual bookkeepers to find support and get your questions answered: bit.ly/2Am1lLQ
Check out my online academy for virtual bookkeepers to find amazing, free training resources as well as full courses on everything from pricing your services to virtual bookkeeping workflows. See what we've got for you right now at: 5MBacademy.com
Follow me on Instagram @5minutebookkeeping for bookkeeping tips, inspiration, and some behind-the-scenes looks at what we're up to: / 5minutebookkeeping
**Manage client communications and bookkeeping workflows with ease using the Keeper app. Get 20% off the first 3 months by signing up with this link: keeper.app/?via=veronicawasek
Recommended playlists:
Successful Virtual Bookkeeping Business: bit.ly/37rCAur
QuickBooks Online cleanup & diagnosis: bit.ly/2ZFOQVL
**Affiliate link
Copyright 2022 5MB LLC

Хобби

Опубликовано:

3 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 80

@chucktrotter9699 3 года назад

5.22.21 Thanks for making this video on Opening Balance Equity. Gives insight of what QB is doing. Thanks

@5MinuteBookkeeping 3 года назад

You're welcome, Chuck.

@rickeyhughes7380 3 года назад

Thank you for sharing this video about "Cleaning Up QBO Opening Balance Equity." I believe it would be helpful to me if I was using Quickbooks. Again, I thank you, so much, for sharing this video.

@5MinuteBookkeeping 3 года назад

Glad it was helpful Rickey.

@lucyrodriguez7982 Год назад

Thank you so much, your videos have helped me tremendously ❤

@5MinuteBookkeeping Год назад

You are so welcome, Lucy.

@leeannemullins8908 3 года назад

Very helpful, thank you!

@5MinuteBookkeeping 3 года назад

Glad it was helpful!

@robertgibson9722 2 года назад

Amazing. Thank You so much

@5MinuteBookkeeping 2 года назад

You're very welcome!

@AyatTadjalli Год назад

Hello and thank you for this video. When connecting credit cards to QBO, it generates an entry and put the CC balance to opening balance equity. Where you should classify the opening balance coming from credit cards?

@5MinuteBookkeeping Год назад

In many cases, QBO adds an amount to opening balance equity automatically. This amount is normally deleted. You should reconcile the credit card after deleting the opening balance in opening balance equity.

@lucerorivas8455 2 года назад

@5 Minute Bookkeeping Hello, thank you for this video. I need some help though. My Opening Balance Equity shows up as a negative balance from a check. It should actually be a positive beginning bank account balance. I can't figure out how to correct this. Would you be able to help me with this?

@5MinuteBookkeeping 2 года назад

I believe you are referring to the bank account opening balance. If the balance is incorrect, then you need to adjust the amount of the opening balance in the bank account. Since I don't have enough details, I can't tell you exactly how to do that.

@cindycooley1419 2 года назад

I am in the process of setting up QB Online (simple start) for my LLC partnership. I have an opening balance equity entered but think I should have that split between the two equal partners. Can I go back and fix this?

@5MinuteBookkeeping 2 года назад

Yes, look for the transaction in the account register and click on Edit to edit the account categories. Then save the transaction.

@brendapeterson8450 Год назад

Hello Veronica, thank you for a great video. I have 2 clients that just started using QBO, when I set up their beginning balances for their checking accounts I put their beginning balances under Opening Balance Equity, were should I have put those beginning balances for their business checking accounts?

@5MinuteBookkeeping Год назад

Hi Brenda, assuming they are sole proprietors, you would reclassify the amounts in opening balance equity to Retained Earnings.

@brendapeterson8450 Год назад

@@5MinuteBookkeeping Thank you!

@Jenny-rb6it 2 года назад

Can I delete an opening balance journal entry created to bring a checking account into balance? (Through the bank reconciliation process) I have found I have a lot more to clean up. I brought the account to correct ending balance in July, but the previous months are all off. They were reconciled, but not correctly and not to the bank statements. It’s QBO and this is a major clean up for a client.

@5MinuteBookkeeping 2 года назад

Yes, you should delete the opening balance journal entry created by QBO.

@daylynterante8122 3 года назад

Hi, I accidentally deleted one transaction but when I re-enter it again..the reconcile reports are still off. this transaction is connected to a bank and loan. what should I do?

@5MinuteBookkeeping 3 года назад

You have to true up the bank reconciliation by marking that transaction as reconciled as of the last reconciliation date.

@omshalom9486 10 месяцев назад

Hi Veronica, Thank you for the great teaching. Can you help me with this question: Do I need to move/transfer balance from Opening Balance Equity account to another account before deleting/closing out the account? If yes, how and move to where? Thank you so much.

@5MinuteBookkeeping 10 месяцев назад

You would need to figure out why the amount is in Opening Balance Equity based on what I discussed in the video. If the balance in the OBE account is for setting up opening balances in bank/credit card accounts, you would normally close out the balance to Retained Earnings.

@natoum.780 10 месяцев назад

@@5MinuteBookkeeping that is my issue- but there aren’t any balance in retain earnings

@thejismeisfamily9654 3 года назад

great

@5MinuteBookkeeping 3 года назад

Thanks.

@user-bn3iy7my8q 9 месяцев назад

I had JE added an opening balance for checking accounts as the company has been around for years but only put the last couple into QBO - How do I remove this from Opening Balance Equity account but still have the year started off with correct balance?

@5MinuteBookkeeping 9 месяцев назад

You would need to recategorize your JE from opening balance equity to another account. You would need to determine with the assistance of the tax preparer which period to adjust and which account category to use.

@pumpedminds6973 3 года назад

what to do with the other accounts which were entered with use of opening balance initially?. Can you make video on the issue about what to do when QBO didn't download some transactions?( mIainly for reconciliation purpose)

@5MinuteBookkeeping 3 года назад

If transactions were added to Opening Balance Equity in prior years, I normally reclassify the balance in Opening Balance Equity to the Retained Earnings account. If transactions were added to Opening Balance Equity in the current year, then you should look at each entry and figure out why a balance was entered to Opening Balance Equity. I mentioned one or two examples in the video, but it is dependent on the type of transaction entered. If QBO didn't download transactions from the bank feed, you have to enter them manually in QBO or import them from your bank/credit card account.

@kaldreasewingco.5189 3 года назад

@@5MinuteBookkeeping is this covered in more detail in your course?

@moisescorrea5777 Год назад

Hello, quick question. Is it possible to remove credit cards added to QuickBooks that relate to your personal use and not the business?

@5MinuteBookkeeping Год назад

Hi Moises. Yes, but you must first delete the transactions before you can delete the account from the chart of accounts.

@usnaccountant 2 года назад

Where is the link to the colossal clean up guide for purchase?

@5MinuteBookkeeping 2 года назад

Hi. Here's the link bit.ly/cleanup_checklist

@Jojo-rz9vz 2 года назад

Great video thank you. I have opening balance in credit card what does it mean? I just check that on my bank register and it says there it is a opening balance equity on my credit card. Can i delete this? Pls. Advise thank you

@5MinuteBookkeeping 2 года назад

Whenever you connect QBO to a bank or credit card account, QBO will set up an opening balance for the account and categorize it as "Opening Balance Equity". If you have already done the reconciliation for this account, you would not want to delete the balance since it will mess up your credit card reconciliation. If you haven't reconciled the credit card, then you can delete the amount in the opening balance.

@Jojo-rz9vz 2 года назад

@@5MinuteBookkeeping thank you for reply. Appreciate it. Just follow question please. So if you connected a newly credit card the opening balance should always zero when you start the reconcillation? If quickbook gives you opening balance i shoulb have to delete it?thanks

@ashleydaniels7745 5 месяцев назад

Great video but it now puts me back at the original problem. So now how do I clear and delete the account correctly?

@5MinuteBookkeeping 5 месяцев назад

Hi. I'm not sure what you're trying to do. Can you provide more details?

@muhamadkhaled8199 2 года назад

I can't make it in my quickbooks enterprise 2021,,, i can't find view register, not like online quickbooks

@5MinuteBookkeeping 2 года назад

Hi. My tutorials are specific to QBO. For QBD tutorials, check out Hector Garcia CPA's RU-vid channel.

@nancymalski2398 2 года назад

Thank you for video! I didnt see where you move the money when a new bank account was added in previous years- still showing on current Balance sheet? I see how they are created but I still not see where you put the opening bank account?

@5MinuteBookkeeping 2 года назад

If a bank account was added in previous years and it still shows a balance on the Balance Sheet, you would not adjust Opening Balance Equity. You would need to adjust the bank balance. You would need to reconcile the bank account, if statements are still available. Otherwise, you would need to consider writing off the balance in the the bank account. I can't tell you what account to use to make the write-off since I don't know the amount or why the balance is still on the books. Typically, it's best to get the client's tax preparer involved in deciding how to write off old balances.

@amandajames3253 5 месяцев назад

This was helpful, but after the deleting the JE that QB recorded for making an account inactive, what's next? I still need to clean up the accounts and need to make them inactive as they are very old and for a different business that morphed into my current business QBO. Will I need to manually delete each transaction?! That will take days! I need a clean slate -0-.

@5MinuteBookkeeping 5 месяцев назад

You can make a journal entry to 0 out the balance in the account you're trying to clean up. You'll need to determine the best account category to use to 0 out (or write-off) the balance.

@atifnaseer4695 2 года назад

I want to start with zero balances but with my existing chart of accounts which I have been added, how is this possible?

@5MinuteBookkeeping 2 года назад

Hi Atif. I'm sorry but I don't understand your question. Can you try to rephrase your question?

@atifnaseer4695 2 года назад

@@5MinuteBookkeeping I want all figures in zero in my accounts. As I have been recorded wrong entries and openings by mistake. and how to delete multiple entries in one go/click?

@jeanjohnson5414 Год назад

Your video was helpful but I have a different dilemma related to Opening Balance Equity. I purchased a business that was already in existence. What I purchased was quite a bit of "blue sky" because the seller then taught me how to do many things. The part of the blue sky was $27000 which I paid from my personal savings. When I start QuickBooks, how do I show that amount as owners equity? When I create the Owner's Equity account, if I put in the 27000 as a beginning balance, it does exactly what you showed - puts an entry in opening balance equity, but how do I clear that or avoid that so the 27000 shows as my owner equity? The rest of my owner equity for the inventory is correct. Thanks in advance

@5MinuteBookkeeping Год назад

If you put in $27K of your own personal savings into the company, it is an Owner Contribution.

@jeanjohnson5414 Год назад

@@5MinuteBookkeeping Wow. thanks for your quick reply. when you record an owner contribution, it's usually money going into checking or into inventory, but I don't have any account to accept that money. The previous owner took it as purchase for the business. if we forget about the other actual assets that I purchased, here's what happens. When I start in QuickBooks, if I enter the 27000 as any kind of income/asset/equity then QB creates the offset entry and my Balance Sheet shows that offset and, therefore my equity is still 0. I'm lost.

@JoshuaCConsulting 11 месяцев назад

@@jeanjohnson5414 I'm not sure if you're still searching for an answer on this, but if you are, I have one. The thing is, when you traded $27,000 of your savings for ownership of the company, you weren't making a contribution to the company. The company's finances actually weren't affected at all by the transaction (unless of course the previous owner withdrew funds from the company before selling it, in which case that should be recorded as a draw by the previous owner). The only way this transaction would show up on a balance sheet would be if the company had been acquired by another company (a Parent Company). In that case, the Parent Company would record a new asset on it's balance sheet for this company (a Child Company) and would need to offset it by either reducing another asset or by recording a liability. Hope this helps!

@pubg0075 3 года назад

Mam where i can find clients for QuickBooks?

@5MinuteBookkeeping 3 года назад

I find all my clients via my RU-vid channel. Perhaps you could start a RU-vid channel or blog. You can also use social media.

@chytealthedeal 3 месяца назад

New Client has moved from Xero to QBO, previous year taxes done and books cleaned already. I connected bank and now I have Opening Balance Equity. Do I delete OBE? Do I Journal Entry to Retained Earnings? All I am supposed to be doing is Entering Opening Balances from Balance Sheet and start reconciling each month but I cannot figure what to do with this OBE😢.

@5MinuteBookkeeping 3 месяца назад

QBO has a bad habit of putting balances to OBE when you connect the bank feed. You should delete the entry to OBE.

@chytealthedeal 3 месяца назад

@@5MinuteBookkeeping Thank you

@JillSchroeter 2 месяца назад

if we deposited our own $ into our account when opening the business , what is this called?

@5MinuteBookkeeping 2 месяца назад

It is an owner contribution.

@JB-dv7ew 2 месяца назад

am I supposed to zero out my owners draws or something? Mine are still showing up in Xero following into the new year. For tax purposes wouldn't I want to get this off the balance sheet. I don't want to pay taxes on an owners draw twice.

@5MinuteBookkeeping 2 месяца назад

I don't use Xero so I can't say for sure what you should do in Xero. However, for US tax purposes, owner draws are not taxed. You are taxed on the taxable income of the business.

@JB-dv7ew 2 месяца назад

@@5MinuteBookkeeping Okay that makes perfect sense. I guess its just more of a balance sheet bookkeeping thing. I zeroed it out. I just wanted to make sure I'm doing taxes right.

@israrahmed784 3 года назад

Maám, I'm not able to join your Facebook group, can anyone help me?

@5MinuteBookkeeping 3 года назад

Make sure that you answer both questions to be allowed in the group. We approve requests once a day.

@daylynterante8122 3 года назад

Do you offer one on one coaching for 1 hour?

@5MinuteBookkeeping 3 года назад

Daylyn, I currently focus my coaching with bookkeepers or business owners on Shopify bookkeeping using QBO and A2X.

@dmekas 2 года назад

It look just the loan balance was just put back on books at was originally prior the owner deleted the acccount. Why didn't you show JE how to zero out the balance?

@5MinuteBookkeeping 2 года назад

Hi DJ. After reactivating the account and deleting the adjustment made by QBO to opening balance equity, you could certainly enter a JE to clean up the loan balance. I just didn't show that part for the sake of time.

@dmekas 2 года назад

@@5MinuteBookkeeping OK thanks.

@dmekas 2 года назад

@@5MinuteBookkeeping Bdw, you run awesome channel keep up good work! :)

@5MinuteBookkeeping 2 года назад

@@dmekas Thank you!

@carlasuyannesouza2933 Год назад

Now..How can I undo that 50k chart account that you created? Im starting on quickbooks and I was thinking you were teaching how to clean...Now I have 50000k in my balance..

@5MinuteBookkeeping Год назад

Hi Carla. Can you provide more details regarding what you were attempting to clean up?

@carlasuyannesouza2933 Год назад

@@5MinuteBookkeeping I think I could finally take the 50k out of my balance.. but the Fixed assets building I can’t remove..😅