Tips for taking on a massive Undeposited funds cleanup in QBO

In this video, I'll talk about my best tips for taking on a massive Undeposited Funds cleanup in QuickBooks Online.
--------------------------------------------
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/3zzrl4k
Save time and trouble cleaning up the messiest QBO files with the QBO Colossal Cleanup Checklist: bit.ly/3PBZdCZ
Get notified about all my latest content, webinars, courses, and more: veronicawasek....
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/?vi...
Recommended playlists:
Successful Virtual Bookkeeping Business: bit.ly/37rCAur
QuickBooks Online cleanup & diagnosis: bit.ly/2ZFOQVL
**Affiliate link
Copyright 2022 5MB LLC

[@cathcobb3869]

Thank you!!! This was by far the most helpful QBO video I've ever seen. I spent years wondering and worrying about those darned unapplied payments. You made the resolution process so simple.

[@5MinuteBookkeeping]

You are so welcome!

[@staceycontreras4504]

Wow! You are a blessing! Thank you! My job's QBO account has nearly 2,000 transactions and some are from 2013. I think I need to buy your collosal guide!

[@5MinuteBookkeeping]

You're welcome!

[@itsmarieg5816]

Thanks for making these so simple to understand

[@5MinuteBookkeeping]

Glad it was helpful!

[@blueberrybridal]

I am a business owner. In 2021, I took over my books from an accounting firm. I noticed that there are a lot of transactions from 2019 that are in the Undeposited Funds account on my Balance Sheet. Do I just leave them there because 2019 has already been reconciled and the books closed or do I try to clear out the Undeposited Funds account as you show in this video? Thank you for your help.

[@5MinuteBookkeeping]

Normally, you would want to clean up Undeposited Funds. Since those transactions are from 2019, you could clean them up in the current year, however, the adjustment will be recorded to the current year - and you would not want to do that. There are ways to clean up Undeposited Funds in prior years but only if it doesn't affect prior year's retained earnings or a previously filed tax return. It's an involved decision and I can't get into all the details here.

[@PawsitivePetBehavior]

would this be the same if the income was recorded as sales receipts and not invoices? I use the sales receipts since the service and payment happen at the same time.

[@5MinuteBookkeeping]

Yes, the process is the same if you're using Sales Receipts deposited directly to Undeposited Funds.

[@acieramos2908]

How would you handle undeposited funds that were cash, and used the same day for personal use? Thank you so much! 🌺

[@5MinuteBookkeeping]

Acie, any amounts used by the business owner for personal purposes should be recorded to owner draws or distributions. But, ultimately, it's best to stop using cash in the business unless the owner absolutely has to.

[@acieramos2908]

@@5MinuteBookkeeping Thank you! Trying to cut that habit by creating new ones. Just curious on the best practice for these one offs. Appreciate all you do! 🌺

[@nicolearaujo5590]

@5 Minute Bookkeeping Hi, I have a deposit that I need to put back into undeposited funds account and all everything I read was to delete it. I don't want to make a mistake and send that money back to the customer.

[@5MinuteBookkeeping]

Hi Nicole. Deleting a deposit will only put the amount back into the Undeposited Funds account in QBO.

[@nicolearaujo5590]

@@5MinuteBookkeeping Hi Veronica. Thank you! I've been working with QBO for 8 months now but still not really sure on how to do things most of the time. I'm more familiar with Desktop version. So, in my Undeposited Funds account in QBO, I have 2 transactions for the same customer. One is a payment received and another is the deposit into the bank account so if I delete the deposit, the payment will still be in the Undeposited Funds, yes? Date REF No. Type Payee / Account Memo Decrease Increase Clear Balance 07/07/2022 Deposit Smith Paid via QuickBooks Payments $xx,xxx.xx R -$xx,xxx.xx 07/07/2022 Payment Smith Paid via QuickBooks Payments $xx,xxx.xx R $x.xx Thank you!

[@deborahmawson4745]

You mentioned the 2nd method to clean up the undeposited funds affects the tax return. Does the first method also change the tax return?

[@5MinuteBookkeeping]

It could if you are adjusting transactions that affect a previous year.

[@deborahmawson4745]

@@5MinuteBookkeeping thank you

[@conniegal201]

Veronica, I am a Shopify customer (since 2016) and because I'm not a bookkeeper or accountant, I have no idea what to do with the Undeposited Funds, which are directly deposited from Shopify to the QB Online account. The amount is massive. May I retain your services, please?

[@5MinuteBookkeeping]

Hi Connie. Absolutely. I believe you emailed me already about this and I have responded.

[@SeanFarrington]

Great video, Veronica. As I watched, I wondered how many of the symptoms and problems you see in all bookkeeping are due to incorrect workflows, as you mentioned?

[@5MinuteBookkeeping]

Hi Sean. Most of the mistakes made in QBO by untrained users are due to incorrect workflows. The challenge is that every business is different and their bookkeeping workflows should be customized to their specific business. Sadly, people DIYing their books don't realize this until their books get really messed up.

[@deborahmorales3012]

Hi Veronica, I have 6 months of Paypal Statements that I do not know how to reconcile - how soon can I hire you to help ? Deborah

[@5MinuteBookkeeping]

Hi Deborah. At my bookkeeping firm, Mavency, we specialize in working with Shopify sellers. If you're a Shopify seller using PayPal please contact me through my website at mavency.com

[@aircontrolserviceshotsprin1707]

How can I hire you to fix all my undeposited funds fast so I can do my taxes at the end of this year?

[@5MinuteBookkeeping]

Hi. Thank you for asking. I only work with Shopify clients.

[@mandytibbs3217]

Undeposited funds is such a simple concept but also can feel like such a nightmare lol

[@5MinuteBookkeeping]

Yes it is!