- 182
- 529 485
The Bookkeeping Xperts
United States
เข้าร่วมเมื่อ 17 ก.ย. 2020
Unlock the power of QuickBooks Online with The Bookkeeping Xperts! With over two decades of hands-on experience as seasoned bookkeepers and accountants, we're dedicated to demystifying QuickBooks Online for you. Dive into our tutorials where we share invaluable tips to tackle the biggest pain points users encounter. Let's transform bookkeeping from a challenge to an enjoyable experience. Join us on a journey to simplify and master QuickBooks Online - because bookkeeping should be as rewarding as your business success!
Cleaning Up Workflow for Accountants | QuickBooks Online Tutorial
In this video, I’ll walk you through step-by-step how to clean up messy transactions, organize client records, and streamline your processes to save time and reduce stress by following the QuickBooks workflow tool. Whether you’re dealing with uncategorized transactions, reconciling accounts, or just trying to make sense of the chaos, you’ll find actionable tips and strategies to get the job done.
Here’s what we’ll cover:
How to clean up and organize QuickBooks Online efficiently
Common bookkeeping mistakes and how to fix them
Tips to improve your workflow and collaborate better with clients
Features in QuickBooks Online that make cleanup easier
By the end of this tutorial, you’ll feel confident handling cleanup projects and delivering great results for your clients. This video is perfect for accountants, bookkeepers, and financial professionals who want to work smarter, not harder.
Don’t forget to subscribe for more QuickBooks tips and tricks, and feel free to share your thoughts or questions in the comments!
Here’s what we’ll cover:
How to clean up and organize QuickBooks Online efficiently
Common bookkeeping mistakes and how to fix them
Tips to improve your workflow and collaborate better with clients
Features in QuickBooks Online that make cleanup easier
By the end of this tutorial, you’ll feel confident handling cleanup projects and delivering great results for your clients. This video is perfect for accountants, bookkeepers, and financial professionals who want to work smarter, not harder.
Don’t forget to subscribe for more QuickBooks tips and tricks, and feel free to share your thoughts or questions in the comments!
มุมมอง: 153
วีดีโอ
Knowing if Your Books are Ready | QuickBooks Online Tutorial
มุมมอง 135วันที่ผ่านมา
With year-end just around the corner, it’s time to make sure your QuickBooks Online is ready to wrap up the year smoothly. In this video, I’ll walk you through the essential steps to ensure your books are accurate, complete, and ready for tax season. We’ll cover everything from reconciling your accounts to reviewing transactions and running key reports. Whether you’re a seasoned user or just ge...
My Favorite Report in QuickBooks Online
มุมมอง 9014 วันที่ผ่านมา
In this QuickBooks Online tutorial, I'll walk you through how to easily generate and understand my favorite financial statement in QuickBooks. The Profit and Loss by percentage of income is a great way to understand where is your money coming from and going to. If you need more assistance and want to hire us for ongoing bookkeeping, catch up and clean up work, or a one on one tutorial contact u...
How to Use Filters QuickBooks Online
มุมมอง 7621 วันที่ผ่านมา
In this video tutorial you will learn: How to use the search bar effectively. Using filters to narrow down results by date, customer, or account. Accessing the "Find" feature for detailed transaction searches. Troubleshooting common transaction issues. Perfect for small business owners, bookkeepers, and anyone managing their finances with QuickBooks Online. If you need further assistance and wa...
Tags Going Away in QuickBooks Online
มุมมอง 39228 วันที่ผ่านมา
QuickBooks is planning to remove the Tags feature in QuickBooks. What does it mean to you and what are the alternatives. For now Tags is planned to be removed by March 8, 2015. If you use tags you want to watch this video to check the alternatives and how it is going to migrate to the new system. For the tutorial on how to use classes in QuickBooks click on link below: th-cam.com/video/l93OMpTU...
3 Most Common Errors When Recording Sales in QuickBooks Online
มุมมอง 133หลายเดือนก่อน
Learn how to prevent common sales recording mistakes in QuickBooks Online and ensure accurate financial reporting. This tutorial covers essential tips and tricks, including: Accurately entering sales transactions and tracking payments. Reconciling bank accounts to identify and correct any discrepancies. Using QuickBooks reports to monitor sales activity and identify potential errors. This video...
3 Ways to Find Overstated Sales in QuickBooks Online
มุมมอง 102หลายเดือนก่อน
In this video, we'll walk through three ways of locating overstated sales income in QuickBooks Online. We'll cover overstated sales, and troubleshooting. Here's a breakdown of what we'll discuss: Understanding the Causes of Overstated Sales Income: We'll explore common reasons why sales income might be inflated, such as duplicate entries, incorrect pricing, or unapplied payments. Using QuickBoo...
Preparing a Budget in QuickBooks Online Tutorial
มุมมอง 105หลายเดือนก่อน
Learn how to prepare a Budget on QuickBooks Online and prepare to take your business to the next level. For new QuickBooks Online accounts click below for our affiliate link: quickbooks.partnerlinks.io/3ic0et8d5jwe If you need one on one tutorials, clean up, catch up, or ongoing bookkeeping you may contact us at: Phone: 407 504 9828 Email: qboxperts@gmail.com Website: www.thebookkeepingxperts.c...
Preparing Your Books for End of Year Closing | QuickBooks Tutorial
มุมมอง 358หลายเดือนก่อน
This comprehensive video tutorial will guide you through the step-by-step process, ensuring your financial records are accurate and up to date when closing your books or your client’s books. Key Takeaways: • Learn the essential steps involved in the process. • Discover tips and tricks to streamline the process. • Gain a thorough understanding of QuickBooks Online closing process. • Enhance your...
How to Create Client Statements in QuickBooks Online
มุมมอง 982 หลายเดือนก่อน
Learn how to create professional client statements in QuickBooks Online! In this tutorial, we'll show you how to easily generate Learn how to create professional client statements in QuickBooks Online! Key topics covered in this video: Navigating to the Statements section in QuickBooks Online Customizing statement templates Adding client information and invoice details Generating PDF statements...
Shopify & PayPal Integration | QuickBooks Tutorial
มุมมอง 1702 หลายเดือนก่อน
Learn how to streamline your business operations by integrating Shopify and PayPal with QuickBooks Online. In this tutorial, you'll discover: How to connect your Shopify store to QuickBooks Online How to sync sales and inventory data between platforms How to avoid errors and duplication when integrating Tips for optimizing your workflow and saving time Benefits of Integrating Shopify, PayPal, a...
Inventory Solution for E-Business, Retail, and Wholesale Integrates with QuickBooks Online
มุมมอง 752 หลายเดือนก่อน
Struggling with inventory management? Discover how Settle's integration with QuickBooks Online can streamline your business! From purchase orders to cost of goods sold, their cutting-edge software ensures you always know where your inventory stands. Track orders effortlessly, optimize your processes, and take control of your business today. In addition, Settle offers, Accounts Payable, Inventor...
Intuit Enterprise Suite at Intuit Connect
มุมมอง 892 หลายเดือนก่อน
Introducing QuickBooks' game-changing solution for medium-sized businesses! 🎉 This new product bridges the gap between QuickBooks Online and traditional ERP systems, offering advanced features designed to save you time and money. ✅ Streamline operations with multi-entity support in a single account ✅ Reduce conversion time and costs significantly ✅ Enjoy powerful tools tailored to meet the need...
Chart of Accounts | QuickBooks Online Tutorial
มุมมอง 1872 หลายเดือนก่อน
"Is your QuickBooks Online chart of accounts a mess? This video will help you organize it. We’ll walk you through the step-by-step process of cleaning up your chart of accounts to keep your books organized and accurate. Learn how to remove unused accounts Simplify your bookkeeping with a streamlined chart Avoid accounting errors and gain better financial insights Whether you're a small business...
Managing Cash Transactions | QuickBooks Tutorial
มุมมอง 1242 หลายเดือนก่อน
Managing Cash Transactions | QuickBooks Tutorial
Unapplied Cash Payment | QuickBooks Tutorial
มุมมอง 1503 หลายเดือนก่อน
Unapplied Cash Payment | QuickBooks Tutorial
Recategorize Multiple Transactions | QuickBooks Tutorial
มุมมอง 853 หลายเดือนก่อน
Recategorize Multiple Transactions | QuickBooks Tutorial
Uncategorized Assets in QuickBooks Tutorial
มุมมอง 1383 หลายเดือนก่อน
Uncategorized Assets in QuickBooks Tutorial
Uncategorized Income and Expense in QuickBooks Tutorial
มุมมอง 2683 หลายเดือนก่อน
Uncategorized Income and Expense in QuickBooks Tutorial
Understanding your Statement of Cash Flow | QuickBooks Tutorial
มุมมอง 1113 หลายเดือนก่อน
Understanding your Statement of Cash Flow | QuickBooks Tutorial
How to Create Credit Memo | QuickBooks Tutorial
มุมมอง 793 หลายเดือนก่อน
How to Create Credit Memo | QuickBooks Tutorial
How to Understand Your Balance Sheet | QuickBooks Tutorial
มุมมอง 1423 หลายเดือนก่อน
How to Understand Your Balance Sheet | QuickBooks Tutorial
How to Understand Your Profit and Loss | QuickBooks Tutorial
มุมมอง 914 หลายเดือนก่อน
How to Understand Your Profit and Loss | QuickBooks Tutorial
Undeposited Funds Mastery in QuickBooks Online | Bookkeeping Tutorial
มุมมอง 4034 หลายเดือนก่อน
Undeposited Funds Mastery in QuickBooks Online | Bookkeeping Tutorial
How to Send Receipts to QuickBooks Online | Bookkeeping Tutorial
มุมมอง 1824 หลายเดือนก่อน
How to Send Receipts to QuickBooks Online | Bookkeeping Tutorial
Cash Transactions in QuickBooks Online Tutorial
มุมมอง 2164 หลายเดือนก่อน
Cash Transactions in QuickBooks Online Tutorial
QuickBooks Online for Accountants | Clean Up and Monthly Workflow
มุมมอง 1854 หลายเดือนก่อน
QuickBooks Online for Accountants | Clean Up and Monthly Workflow
Reconcile Bank Acc and Clean Up Duplication in QuickBooks Online
มุมมอง 5894 หลายเดือนก่อน
Reconcile Bank Acc and Clean Up Duplication in QuickBooks Online
Square Cash payment Workflow | QuickBooks Online Tutorial
มุมมอง 1965 หลายเดือนก่อน
Square Cash payment Workflow | QuickBooks Online Tutorial
QuickBooks and Square - Accepting Transactions and Matching Tutorial
มุมมอง 4375 หลายเดือนก่อน
QuickBooks and Square - Accepting Transactions and Matching Tutorial
i am in accountant view but do not have undo option for my latest reconciliation, how do i undo it?
Only if you have a pro-advisor account access. The account view just impact the interface not the access.
Thank you for showing us how to enter that journal entry. I've been looking for that piece of information for too long 😅
You are so welcome! Glad that the video on “How to Approach a QuickBooks Online Clean up” helped you find the answer!!
Do you recommend requesting updated W-9 every year?
Yes, if you are an employer the contractor’s address could have changed., so you will need to ask for the updated information. If you are an accountant you will need to verify if there are new contracts to be added.
Ive been trying to categorize my snapped qb app receipts on my business's qb-online. how to i categorize the expense when i purchased inventory (cogs) with single owners personal store gift card (owners own money or a owner's personal credit card) using the 'owners investment' category, not business funds? Thanks so much.!! pls, :) so appreciated
I am just starting QB for my shopify and came across your video. I'm trying to do my qb for the 2024 year- I am not a high volume seller. Like you said, Shopify now processes the payments for Paypal. But if we download the orders for shopify for the entire year, will the first half of the year paypal transactions not show? Do we need to do those manually or only import the months where Shopify didn't process those payments? THANKS!
Yes, from January through June 2024 PayPal transactions will need to be entered manually. Keep in mind that this is if you do not have PayPal integration. If you do have PayPal integration it will come through PayPal and you will need to remove the integration and remove transactions from PayPal as off July 2025 and forward to avoid duplicating transactions
@@ClaudiaXperts I only integrated shopify now. I am slowly integrations processors. I haven't done paypal yet. I am thinking of doing it manually. Thank you for the reply!
Hello Claudia, First thanks for all you do. Was wondering how do you reconcile your clearance account ?
If it is Shopify by using payout transactions. If it is Square using Square transaction list.
This is great, but what happens to the fees that were in each transaction? Shouldn't those be recorded and categorized as expenses? Just matching the deposits doesn't do that, does it? I am trying to figure out how to breakdown the expenses that were taken out. Do you have a video about that? Or what do you do with those expenses?
The fees are added to the deposit when you accept it. It also contains tips and sales tax for the transaction. If you click on the deposit you will see the fees being deducted
@@ClaudiaXperts Thank you! I didn't realize that matching that would actually ADD the expenses into the correct categories.
@ Yes, the beauty of integration!
Thank you so much for this! Just one in mine falls under "Transfer", the rest are either on Journal Entry or Expense, how do I tackle this please?
You just need to categorize the transaction in the a Journal Entry to what the transaction was supposed to be categorized.
@ClaudiaXperts Thank you!
@ You are welcome!!
@@ChiamakaMuokwe For the transfer there is no way to recategorize you need to undo the transaction or do a Journal entry.
You should have cleaned up QB prior to hitting record
Thanks for the feedback
thank you very much
You are very welcome! Thanks for watching “preparing Your Books for End of Year Closing/QuickBooks Tutorial!!
Thank you so much! Perfect advice and education at the just right time for me! I’ve got undeposited funds from one client since 2016. I’m hoping I can clear most of it this way.
You got this! You are welcome! Glad this was helpful. Remember if Undeposited Funds is for an accounting season you already filed the taxes send the balance to Retained earnings instead.
Hi, How do we contact you for a session? The links in your bio aren’t working for me.
My phone number is 407 504 9828 and email is qboxperts@gmail.com
Please make more tutorials 🙏 Learning a lot from you maam
I will, I have another one coming up for Accountants and bookkeepers on QuickBooks clean up. Stay tuned.
Thank you for sharing, ma'am. I'm learning more from you as a remote QuickBooks bookkeeper.🎉
You are so welcome!
Nice
Thank you!
Finally! I have been trying to figure out how to fix this because my deposits were reconciled.
I am so happy to hear that the tutorial on how to fix Undeposited Funds After you Reconciled helped you! Thanks for watching!!
So if I manually recorded my payments, and my bank is synced it will duplicate he payment once direct deposit hits ?
If you do not match yes, but if you properly match no. When you match you are combining the transaction you entered to the transaction coming from the automatic bank feed.
Any insights on how best to track Partners separate income and expenses within the same Quickbooks account? Was previously using tags, and it sounds like the Custom Fields will not be helpful since it doesn't apply to expenses.
Running into a similar problem here. The only thing I've come up with so far is to label the vendor with the tag and then run a vendor report. So McDonald's - Gary, McDonald's - Greg. Income is a little easier because you can have subcustomers. Each Partner could be a Customer and each person they sell to would be their subcustomer. Subcustomers work great for filtering sales by zip code and tracking rental homes.
I would recommend classes, in your case. Classes is available in Plus and advance subscription.
That’s a great idea. The other as I mentioned is classes. It works like tags with a limit of 40 classes. Classes are available in Plus advance subscription.
@@ClaudiaXperts The problem is that clients are tired of paying Intuit so much money. They take, take, take.
@@Christina729 This exactly. My plan would increase 200% from $35 to $100. I don't think it justifies that much of an increase for simple services.
After changing my password in square my old transaction is not showing ?
You may need to reconnect Square.
@@ClaudiaXperts if we change or update new password our money will remain safe in my square pos terminal ?
Thank you for sharing. Hugs
Thanks for watching “How to send receipts to QuickBooks online” tutorial❤️❤️
Very helpful! Do you by any chance have a video that covers future cash flow? E.g. I pay vendors on NET30 terms but I get paid on NET60-90 so there is always a delay and need to constantly forecast future cash flows while waiting to get paid
No we don’t. I use budget, keep in mind if you run your financials as accrual it will show the income for all invoices and expenses including the bills that you entered either they were paid or not.
I currently have tags showing up in my bank feeds so I can categorize multiple debit cards used in my checking ac. The custom fields aren't able to show up in my bank feed. Do you know how to get rid of fields like products/services or customers that show up as drop down menus in that bank feed so I can add in a custom field instead?
You can not substitute your Products and Services or any other account for Custom Fields. You will get 1 custom field if you have Simple Start subscription , 4 if you have Essential or Plus, and 12 if you have Advance subscription. No custom field is available for Simple Start right now it should be available in February.
I'm new to Toast and new to qbo. We pay out our tips daily out of the cash on hand, and the cash on hand stays in the restaurant. Is there a way to set up the template to reflect the credit card sales, tips received/tips payed, and cash on hand
The template will be the same. All the cash tips will need to be enter manually. You can do a Journal entry for that credit cash on hand debit tips payable.
How to create a customized sales receipts for my entire sales customers for all products and services as year to date
You may customize an invoice but not for individual customers. If you want to customize the discount you can. You can use price rules.
Thank you Claudia for another useful tutorial. I love your expressions❤
You are so welcome!
I'm confused about the cash debit. I know where you are getting the number which is from the report. However, that means cash will be increasing month over month on the balance sheet. The business owner then deposits cash to their bank. So in the banking we will see deposits in the 'received' column. If you categorize it to the Toast Clearing, when will the cash balance ever go down?
Whenever you categorize your bank feed deposit as cash bank what you are doing is removing cash from cash bank and adding to your checking bank account. This will lower your cash bank balance and increase your checking bank account.
Is that a typo? Do you mean categorize bank 'feed'? Or bank fees? If I categorize cash deposits in the banking center to cash bank that still increases the cash bank account. Im sorry could you try to explain that again? I would really really appreciate it!!!
@@crystalramirez5631 Yes it is bank feed. Crystal when you categorize cash deposit in the bank feed as a cash bank what you are saying is that you took money from the cash bank account and deposited into the checking account. So money was taken from the cash bank therefore it lowered the balance and was deposited into the checking account which raises the balance in the checking account.
Dear Claudia...You are awesome at explaining QuickBooks dynamics..I love your style and personality
Thank you so much for the kind words! Happy I can help you with QuickBooks Online!!
@@ClaudiaXperts My pleasure..Yes You are helping me a lot learning QuickBooks Online dear Claudia as I wait for your videos..Stay blessed
You too!! Have a blessed day
@@ClaudiaXperts thank you so much Claudia
@ You are welcome!
Do we need to pay for a Melio subscription?
Melio has both free and paid subscription.
Thank you. This was very helpful. When customers pay via the QB online bill payment system, the funds were being automatically added to 'Undeposited funds". I didn't realize this was happening and the register for Undeposited funds was showing a balance. I was able to solve the problem following your instructions!
Awesome!! Glad it helped!! If the issue persists take a look at you account settings under sales and make sure that the right payment account is set up.
Your seating view in the camera is low.
Thanks for the feedback. I will correct that on the next video!!
How do your clear A/R account to $0 as my client has a negative balance in A/R of -$771,450.63 I’ve gone in and looked and many had a credit note raised against them to clear them out of unpaid. I think that was the wrong way to do it and maybe they should have been marked paid by owners Investment Equity or through the petty Cash account.
Thanks for your interesting explanation, for your great job 🎉 😊
My pleasure 😊
Can I pay bills with a NACHA file?
Melio does have batch payments. Melio is no longer the Payment company in QuickBooks you can still link your Melio to QuickBooks Online and do batch payments on the Melio app.
Hi Claudia! So i have done what you have showed in this video but i accidentally selected too many transactions and now i can't match them to my bank deposits. How do i undo this so i can correctly match the transactions?
Click on the plus new left hand side menu, then click on deposit, click on the conter clock icon on the top left hand side. You should see the most recent deposit. You can click on it and make the corrections. If you do not see the deposit right there click on view more and look for the deposit, click on it and make the correction.
Why should map third party to undeposited funds over Accounts receiable? We use xtrachef to sync sales data from toast pos to QBO. My former bookkeeper had doordash, uber, grubhub sales sent to "undeposited funds" but when matching payments you can't see the payee on the JE. xtrachef told me to map to accounts receivable, then i was able to create a customer for doordash etc. and then i can easily match payments with doordash JEs. Having it mapped to AR instead of Undeposited funds has been tremendously helpful. I just want to make sure i'm not causing more problems in the long run.
I created a bill, then paid the vendor via ACH deposit. Why do I see an Unapplied Cash Payment in my P&L report?
Either the date of payment is for after the brill was created or the amount of the payment was for more than the bill.
Please remember that you need to record the payment for the bill that needs to have a prior date from the payment date and the amount must match what was paid.
Would have been helpful to show us where you get the info from on the reports.
I will, you can find the Square reports by logging into Square and select reports on the left hand side menu.
Your template said Square Fees twice...
There should be only one. Thanks for pointing that out!
Yes, it is amazing and Useful. I didn't see this feature. Thank you for the update, my sister.🙏😊
You are very welcome!
All good, Ma'am. Wish you take yourself on the top and away the main content
Will do
How would I record a transaction in which the lawyer pays himself directly from the Trust account and does not transfer money into the main checking account from the Trust account. Because he does this, I'm not sure where I would put the money going out of the trust account. TIA
You will categorize the transaction as the trust so remove the liability, then you will need to do a Journal entry to record the income by crediting the income account and debiting owner’s distribution.
Thank you for being concise and to the point. I've always done J/E for all the transactions, so seeing it with Invoices and sales receipts is wonderful. Thank you!
So glad you liked the video on accounting for attorneys.
Thank you for doing this video
Glad you found it helpful!
Hi there, I'm trying to clean up the undeposited funds account. However the previous bookeeper did a journal entry which is causing the UDF balance to not match the remaining balance. Also the journal entry did not clear the transactions out. What should be my next step?
That why you never use Journal Entries to clear Undeposited Funds. You will need to get rid of the Journal Entries and fix Undeposited Funds as I teach in the video.
@@ClaudiaXperts Thank you for the response. However, the JE that she did is for a closed period.
@ I understand, however you may substitute the amount from the JE for the amount deposited into retained earnings. The JE will keep the Undeposited Funds off.
Great site to learn
Thank you!!
Can you do this when using quick books self employment? I don't get chart of accounts as an option. Thank you!
No unfortunately self-employment version does not offer this option.
Excellent video! I’m going to watch this over again a couple more times!
Awesome! Thank you!
Question: how to record mileage reimbursement as income? My husband has an S Corp and he uses his personal car to travel to work. His employer pays him for the miles accumulated in the month to go to work. This amount is also included on his paycheck. I believe the mileage reimbursement is an accountable plan because it meets all the requirements. Please and thank you in advance. Laritza Ruiz
Hi Laritza if he is being paid by hi employer you will not add the expense nor the income to your books since he is being reimbursed for it.
Thank you for your videos!! They are great :)
You’re very welcome!!
Prior to reconciling, how do I fix payments recorded to clients bank account instead of undeposited funds?
You sent it to owner’s distributions