How to Identify and Fix Duplicate Income in QuickBooks Online - Sales Receipt & Deposit

Struggling with duplicate income entries in QuickBooks Online? You're not alone. In this video, I delve into a common issue that many bookkeepers and small business owners face: identifying and rectifying duplicate income. Using the example of a deposit and a sales receipt that are recording the same income twice, I guide you through the process of discovering, evaluating, and correcting this duplication.
What You'll Learn:
- How to navigate to the Profit and Loss report to uncover potential duplicates in your income.
- The importance of regularly reviewing your total income for any discrepancies or logical mistakes.
- A practical walkthrough on deciding which entry to keep - in our case, choosing a sales receipt over a deposit for historical accuracy and customer tracking.
- Step-by-step instructions on adjusting the chosen entry to correct the duplication without affecting your financial records adversely.
Please like, subscribe, and comment!
Contact Rachel for one-on-one assistance:
www.gentlefrog.com/meeting/
Are you a small business owner struggling to make sense of your QuickBooks data? Sign up for my FREE Review Your QuickBooks Mini-course and learn how to keep your QuickBooks accurate, up-to-date, and free from costly errors: courses.gentlefrog.com/review...
☕ If you found this video helpful you can say "thanks" by buying me a coffee...
www.buymeacoffee.com/gentlefrog
Connect with Rachel on Facebook:
/ gentlefrogllc
Try QuickBooks Online for free for 30 days: bit.ly/3gXpv3b
Already know you want QuickBooks Online? Buy now and save 30% on your first 12 months: intuit.me/3gZ0q85
Check our reviews: www.gentlefrog.com/reviews/
Timestamps
00:00 - Intro
00:45 - Find duplicate income in the P&L
01:58 - Why keep the Sales Receipt
02:41 - Remove duplicate deposit
04:33 - Verify you did this correctly
04:58 - Outro
#quickbooksonline #bookkeepingtips #DuplicateIncome #financialmanagement
This content is for information purposes only and should not be considered legal, accounting, or tax advice, or a substitute for obtaining such advice specific to your business. Additional information and exceptions may apply. Applicable laws may vary by state or locality. No assurance is given that the information is comprehensive in its coverage or that it is suitable in dealing with a customer’s particular situation. Gentle Frog, LLC does not have any responsibility for updating or revising any information presented herein. Accordingly, the information provided should not be relied upon as a substitute for independent research. Gentle Frog, LLC does not warrant that the material contained herein will continue to be accurate, nor that it is completely free of errors when published. Readers and viewers should verify statements before relying on them.

[@j.k6580]

love it, thank you

[@GentleFrog]

You're welcome! I'm so glad you like it.

[@weskowalchuk4983]

I love this and it does help however I have Clients I invoice then receive payments from thru square. I cannot figure out how to reconcile the payment with the actual deposit as the deposit is short the merchant fees. DO I show the invoice as paid in full and then split the deposit to merchant fees?

[@GentleFrog]

I have a video on recording payment process fees. It uses payments through Stripe as an example but the process is the same: kzbin.info/www/bejne/rZewi5mKZ5h7p6M If this video doesn't answer your question please let me know.

[@chytealthedeal]

So do you mean that once a Sales receipt is created you shouldn't put the amount in your bank account and make a deposit because it will create a duplicate? In other words, you avoid making this type of duplicate by putting it into Undeposited Funds correct?

[@GentleFrog]

Yes, when creating the sales receipt don't select the bank account for "deposit to" select "Undeposited Funds". Then when you do create a deposit later that sales receipt will be in the undeposited funds, you'll select it from the list to add it to the deposit and you won't end up with duplicate transactions.

[@chytealthedeal]

​@@GentleFrog thanks for awesome content