- Видео 173
- Просмотров 490 420
The Bookkeeping Xperts
США
Добавлен 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!
Shopify & PayPal Integration | QuickBooks Tutorial
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, and QuickBooks Online:
Accurate Financial Reporting: Gain real-time insights into your business performance.
Efficient Inventory Management: Keep track of your stock levels across all channels.
Streamlined Payment Processing: Automate payments and reduce manual errors.
Simplified Tax Compliance: Easily manage...
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, and QuickBooks Online:
Accurate Financial Reporting: Gain real-time insights into your business performance.
Efficient Inventory Management: Keep track of your stock levels across all channels.
Streamlined Payment Processing: Automate payments and reduce manual errors.
Simplified Tax Compliance: Easily manage...
Просмотров: 45
Видео
Inventory Solution for E-Business, Retail, and Wholesale Integrates with QuickBooks Online
Просмотров 3814 часов назад
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...
Avalara Sales Tax Solution for E-Businesses, Multi-State Sales Tax Filling, and Nexus Compliance.
Просмотров 30День назад
"Sales tax compliance is one of the biggest challenges e-businesses face today. 🛒 As your business grows and sells across multiple states, managing multi-state sales tax filings becomes increasingly complex. Keeping up with varying tax rates, rules, and nexus requirements can quickly turn into a logistical nightmare. That’s where Avalara steps in! Avalara is designed to take the hassle out of s...
Intuit Enterprise Suite at Intuit Connect
Просмотров 5114 дней назад
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
Просмотров 11521 день назад
"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
Просмотров 6021 день назад
"Managing cash transactions in QuickBooks Online doesn’t have to be complicated! In this free tutorial, we’ll show you how to accurately track, record, and reconcile your cash transactions, so your books stay balanced and stress-free. * Learn the best practices for handling cash sales and expenses * Discover how to categorize transactions for accurate reporting * Avoid common mistakes that can ...
Unapplied Cash Payment | QuickBooks Tutorial
Просмотров 63Месяц назад
Unapplied cash payments can create confusion and throw off your financial records in QuickBooks Online, but fixing them is easier than you think! In this step-by-step tutorial, we’ll guide you through the process of identifying and resolving unapplied cash payments. You’ll learn why these errors happen, how to fix them, and tips to avoid them in the future. Whether you’re an accountant, bookkee...
Recategorize Multiple Transactions | QuickBooks Tutorial
Просмотров 63Месяц назад
In this step-by-step tutorial for the new QuickBooks Online tools, we'll dive into the world of QuickBooks Online and show you how to recategorize multiple transactions efficiently. What's Inside: Why recategorizing transactions is crucial for accurate accounting A detailed guide on selecting multiple transactions at once Tips and tricks to streamline your accounting process Common mistakes to ...
Uncategorized Assets in QuickBooks Tutorial
Просмотров 84Месяц назад
Are uncategorized assets driving you crazy in QuickBooks Online? You're not alone! In this down-to-earth tutorial, I'm going to show you how to fix those sneaky uncategorized assets once and for all. Whether you're a small business owner, accountant, or bookkeeper, this video is for you! 🎥 What We're Covering: Understanding uncategorized assets and why they pop up 🚀 Simple steps to find and rev...
Uncategorized Income and Expense in QuickBooks Tutorial
Просмотров 120Месяц назад
Is your QuickBooks Online filled with uncategorized income and expenses? Don't worry, I've got you covered! In this easy-to-follow tutorial, we'll dive into the steps to clean up your accounts and ensure your financial records are spot on. Whether you're a small business owner, an accountant, or just trying to stay organized, this video is perfect for you! In This Video, You'll Learn: What unca...
Understanding your Statement of Cash Flow | QuickBooks Tutorial
Просмотров 59Месяц назад
This is a step by step tutorial on how create a credit memo for a client in QuickBooks. Credit memos are created for many reasons including client overpayment, compensation, or other reasons. Credit memos are created for future use. If you need additional assistance and want to hire us for ongoing bookkeeping, a one on one tutorial, or catch up and clean up please contact us at: 407 504 9828 Qb...
How to Create Credit Memo | QuickBooks Tutorial
Просмотров 52Месяц назад
This is a step by step tutorial on how create a credit memo for a client in QuickBooks. Credit memos are created for many reasons including client overpayment, compensation, or other reasons. Credit memos are created for future use. If you need additional assistance and want to hire us for ongoing bookkeeping, a one on one tutorial, or catch up and clean up please contact us at: 407 504 9828 Qb...
How to Understand Your Balance Sheet | QuickBooks Tutorial
Просмотров 96Месяц назад
Feeling a bit lost with your balance sheet in QuickBooks Online? No worries-we're here to help you make sense of it all! In this friendly and straightforward tutorial, we’ll break down the balance sheet so you can understand your business's financial position with confidence. Whether you’re a small business owner, accountant, or just curious about QuickBooks, this video is just for you! For our...
How to Understand Your Profit and Loss | QuickBooks Tutorial
Просмотров 782 месяца назад
Are you puzzled by your Profit and Loss statement in QuickBooks Online? Don’t worry; I'm here to help you make sense of it all! In this user-friendly tutorial, we'll break down the Profit and Loss report so you can understand your business's financial health with confidence. Whether you're a small business owner, accountant, or just learning the ropes, this video is your go-to guide! In This Vi...
Undeposited Funds Mastery in QuickBooks Online | Bookkeeping Tutorial
Просмотров 2412 месяца назад
Undeposited Funds Mastery in QuickBooks Online | Bookkeeping Tutorial
How to Send Receipts to QuickBooks Online | Bookkeeping Tutorial
Просмотров 882 месяца назад
How to Send Receipts to QuickBooks Online | Bookkeeping Tutorial
Cash Transactions in QuickBooks Online Tutorial
Просмотров 1362 месяца назад
Cash Transactions in QuickBooks Online Tutorial
QuickBooks Online for Accountants | Clean Up and Monthly Workflow
Просмотров 1592 месяца назад
QuickBooks Online for Accountants | Clean Up and Monthly Workflow
Reconcile Bank Acc and Clean Up Duplication in QuickBooks Online
Просмотров 3692 месяца назад
Reconcile Bank Acc and Clean Up Duplication in QuickBooks Online
Square Cash payment Workflow | QuickBooks Online Tutorial
Просмотров 1503 месяца назад
Square Cash payment Workflow | QuickBooks Online Tutorial
QuickBooks and Square - Accepting Transactions and Matching Tutorial
Просмотров 2593 месяца назад
QuickBooks and Square - Accepting Transactions and Matching Tutorial
QuickBooks and Honeybook Integration Tutoriral
Просмотров 1293 месяца назад
QuickBooks and Honeybook Integration Tutoriral
Trust and Case Settlement Accounting for Attorneys | QuickBooks Tutorial
Просмотров 2223 месяца назад
Trust and Case Settlement Accounting for Attorneys | QuickBooks Tutorial
Delayed Charges Recurring and Batch Invoicing | QuickBooks Online Tutorial
Просмотров 1134 месяца назад
Delayed Charges Recurring and Batch Invoicing | QuickBooks Online Tutorial
Square and QuickBooks when you don't integrate
Просмотров 1884 месяца назад
Square and QuickBooks when you don't integrate
Shopify and QuickBooks Online Integration Workflow and Reconciliation
Просмотров 1,2 тыс.5 месяцев назад
Shopify and QuickBooks Online Integration Workflow and Reconciliation
QuickBooks Invoice Customization for New Template
Просмотров 535 месяцев назад
QuickBooks Invoice Customization for New Template
QuickBooks Online and Toast Integration Tutorial
Просмотров 1,7 тыс.6 месяцев назад
QuickBooks Online and Toast Integration Tutorial
Maintenance part II Reconciliation in QuickBooks Online and Fix Duplicated Transactions
Просмотров 4296 месяцев назад
Maintenance part II Reconciliation in QuickBooks Online and Fix Duplicated Transactions
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!!
So how can I hire u as a tutor is that possible?
You can email qboxperts@gmail.com or call 407 504 9828 to schedule a time.
Can you do this when using quick books self employment? I don't get chart of accounts as an option. Thank you!
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
Who tracks depreciation of fixed asset? Is it the tax accountants? Then when do I record depreciation? Do I record depreciation when accountants tell me to record?
Yes your tax accountant should have a depreciation schedule. He or she should give you a depreciation detail report for the year and you will need to enter in QuickBooks.
Hi! Thank you for this video! I have a question regarding 1099s. Since the rent payment is income to the property owner, and not to the property management company, how would I go about issuing a 1099-k for the full/gross rent amount paid? In your example a payment/expense is made to the property owner, but it was after other property expenses were taken out, the net amount. Thank you in advance!
For the property management you add the income as a liability then reverse the liability when you pay the owner and the property management. The 1099 for the property management should only reflect the amount paid as income for services provided as a property management company.
But if you do it this way (which I love cause it’s old school and THAT never fails), then, the sales taxes are not automatic and the sales tax tab I’ll have it without a purpose. Right?
If I let, say: commerce sync, do their little invoices AND charge me for the service, then the sales taxes are gonna show on the salex tax tab
The sales tax will go straight to the balance sheet as a short term liability named sales tax payable. When you pay it you categorize as sales tax payable to offset the liability. With commerce sync they may send sales receipts for each batch containing the sales tax. You will need to set up sales tax prior to integrating with QuickBooks.
@@ClaudiaXpertsso should I just ignore the sales tax TAB that qbo has for us there?
I use Quickbooks Online and I have 2023 where I entered all pymts as undeposited funds. I have customers bank acct linked with QBO so deposits automatically transfer. What is easiest to take care of the undeposited funds. I may have 20 or more invoices on one check per week.
Thank You! 😊
You are very welcome!!
Honestly hard to watch you type!
Does this new account have to be connected to quickbooks? in the video your example has a balance. Do I need to have that in order to categorize an outside payment? Or can I just use the new clearance account without connecting it and without any balance showing?
The clearance account is perfect! We do not connect any account to record those payment since they come from personal funds.
Hello, Thank you for your videos, they are very helpful. I have a question about reconciliation discrepancy - I have an account I can't move on with reconciling because of the discrepancy due to deleted duplicate transaction (it was intentional) which has been reconciled before deleted. Now my balance is off by the amount of that transaction. Is it ok to use forced Adjusting entry by QBO to help me move on? Would this entry affect the P&L and what should be my steps after the adjusting entry is posted?
You can do a Jornal Entry for that. I never use QBO adjustment because it does impact the Profit and Loss since usually it is an expense account. It should match if all transactions match the bank statement if not there is something wrong with the reconciliation.
My bank automatically shows the cash deposits once they are deposited, since the sale has already been recorded by square, could I just "add" the deposits into my "business checking" or do I need to try and match it with the sale from square
If you watch the video it will show that you do not match with a sales receipt from Square it rather record the sale to the Cash account then you categorize the deposit as a transfer from cash on order to avoid duplicate payments. The only matching is for card transactions.
I am very confused about how to enter the cash part on the sales once square app is intergrated. Do I need to make another invoice just for the cash sales part?
If you enter your cash transaction in Square it will be sent to QuickBooks. Once you add those cash transactions from the App Transactions it will go to Undeposited Funds, you will then recons the deposit to Petty Cash or Cash account.
Hello Claudia. I'm Demetrius and I'm having trouble finding a solution/s to my challenge. QBO categorized my uncats as income, which they are not. Two things, 1. This prior tax year has already been reconciled. I'm having to go back to correct these uncats, now that I realize that the profit and loss for that year is surely inaccurate. 2. These uncats are mostly returns or credits issued by merchants back into my business checking. There's not a category for that in QBO. How do I correctly categorize these types of transactions, in a reconciled prior tax year?
You will want to move with a Journal entry with January 1 2024 date into retained earnings. This is done because you already filled taxes and you do not want to change prior year numbers.
HI, I am new with the program. If I understand correctly, I can issue an invoice and once I receive the cash, I can add it as "Cash on hand" and once the deposit is ready to be done, I do a transfer from Cash on hand to deposit at the proper bank? Thank yoU!
That’s exactly right!
How do you record a refund of the deposit?
You can do a Journal entry debit the deposit liability and credit the bank account, you will need to match the transactions in the bank feed. Another way is to categorize the transaction from the bank feed as deposit and it will remove the liability the same way.
You are the best for this! Thank You!
So happy that the video ‘Why do my deposits are not matching”was helpful to you.
we couldn't see anything of what you were doing. You should remove your face from the video.
Thank you so much! You explain things so well!
You're very welcome!
So, if they fixed it ,how does it ends on transfer.? Or is something new? And is un categorized line means you didn’t categorize those items and that why it shows?
That was QuickBooks AI gone wrong, pre categorizing those transactions as a transfer. They fixed it but sometimes it still happens
Thanks for the video on COA setup. Couldn't remember the parent/sub account structure for these. Ty!
Glad to help!
Hi Claudia. I have seen videos where missing transactions are recorded or categorized during reconciliation process. Wouldn't it be more proactive to complete the categorization prior to starting the reconciliation
Yes Sandy! That's the ideal, but there are times when the customer does not answer and that's when this situation is better to add to uncategorized so you can move on with the monthly workflow.
9:55 notes payable why on the debit side. I get confused all the time. I known debt is a liability but accounting terms increasing debt is a credit. Please help me understand the accounting lingo. Thanks.
When we want to record payment to a liability we debit it so we eliminate the liability. Credit to increase the liability debit to record a payment and lower the liability.
Thank you!!
You are welcome!
how do I contact you? I need help setting up Toast GL accounts in Toast so I can generate the accounting report from Toast. I am not wanting to integrate with QBO just yet. Thank you. Also, let me know your fee for your time. Thank you.
Hello, my client made a cash deposit in Feb 2024 which includes cash collected from December 2023 up to Feb 13. During that time, those undeposited funds were not deposited to a cash account. fyi, I only just now unreconciled the account back to January 2024 and created a square cash account to properly account for the funds according to your tutorial (hopefully, I understood it correctly). How would I reconcile the 2023 undeposited funds for the Feb 2024 deposit as they are currently checked marked to the Feb 13 deposit? I am so frustrated with Square Cash transactions. Thank you for your tutorials and sharing your experiences and expertise!
You are very welcome! The income was recorded for 2023. You will just record the deposit to the cash account then the transfer to the checking account if he deposited into the cash account. You don’t reconcile the undeposited funds you will reconcile the bank account and the cash account.
Claudia, hello. Thank you for your previous reply. I am not getting the expected result according to the tutorial. I am obviously missing a detail. My checking account is off balance by the total I deposited to my cash account. These are the steps I followed: 1. I selected +new - deposit. I selected the cash transaction from undeposited funds and changed the account to Square Cash as well as the correct date. The cash deposit went up by that amount. 2. From the Square cash account, I selected +new transfer and transferred the amount from my cash account to the checking. account, my reconciliation in the checking is off by the amounts I transferred. What did I do wrong. By the way, my cash account type is BANK / Cash on hand. I also made it a sub account of the checking account. Is this correct?
@@darlamoore4090 Hello Darla, at times it is impossible to know exactly what is going on with ou looking into the account. It sounds to me that there are unreconciled transactions in the bank account creating duplicated transactions. Remember you just categorize the bank transactions as a cash transfer please do not record a transfer because if you need you will need to match in the bank fees. If you need further assistance you can hire me for a one on one you may email be at qboxperts@gmail.com for pricing and schedule.
Thank you, my Dear sis. But we create the invoice first, before the Cr Memo, am I right?
No the invoice will be for future services. So credit memo is created after an overpayment or compensation for a future service.
I use Honeybook as my CRM to send invoice and have them paid. I sync Quickbooks to HoneyBook. Why in Quickbooks I have undeposited Funds in both payment and deposit in the balance sheet? The payment says accounts receivable and the deposit says my company's name.
Help! I did what you said, ckecked the old ones I want to go away, and at bottom I entered the identical amoount as a negative, and for the account I used an equity account I had created. But when I go back to Undeposited Funds, the same old payments are still there????
Looks like it could be a Journal entry that could be causing the issue. Watch my latest video on Undeposited Funds it may help. It is difficulty without going into your books to research. ruclips.net/video/wyb6DE3DKKQ/видео.htmlsi=1f1SRi8q0W2yn81f
what about payments on the sales reports that "other" ?
It could be anything, you will need to ask the business owner what was categorized as other.
Hi Claudia, I have migrated the data for the Sage 50 to QuickBooks online but imported all the transactions from the previous company. How to make everything zero for the new company?
Go to the bank register and delete the transactions. You may do a JE to reverse as well but if you do that you will need to know exactly what to reverse.
Hello, my business just started using Square as the main transaction processor for my grocery store. My CPA is having a difficult time getting the data she needs onto Quickbooks. We are not seeing the gross amount from Square reflecting onto our Quickbooks but rather the net amount after the fees are taken out. We are wanting to input the gross amount from Square and split it into categories based on the types of transactions. How would we go about doing this? Any advice helps! Thank you.
If you integrate Square to QuickBooks you will get the complete transaction. Then you add the transaction from App transactions and match it to the bank fees transaction.
🙏Useful as usual 😊
Glad to hear that
Hi Claudia, I'm dealing with the same issue as in the video. There is $500 in undeposited cash/check that I can't find when I try to match the transaction. I've already confirmed that it was sent to the correct account. Could you please advise?
Take a look at the date and the amount. There is probably something g off
good lesson love u
Glad to hear that
hi, wanted to ask what if its the other way around? a payment has been received and its for multiple invoices, i check the bank feed and theres 3 transactions for that one payment and i cant do the find a match option, its not showing up. would really appreciate your help!
Make sure all payments go to undeposited funds then record the deposit for the amount that was deposited then you will be able to match to the bank feed
@@ClaudiaXperts thank you!
@@knorrrrrr You are welcome!
HOW DO YOU TRANSFER THE BALANCE AND PROFIT SHEETS / INFO TO YOU QB TO DO YOUR TAXES
Click on the top right hand corner gear menu, select export data. Select to get to info. Select the date for the tax accounting period. It will export to Excel you will then import to Turbo tax.
Hi I am from Pakistan We like to purchase Quick Book for Our Business Need some guidelines
Go to QuickBooks Online to purchase it May not be available in Pakistani
Could you show how to record the Toast Fees?
Sure!
Hi Claudia. Thank God I found you and your videos. The Payment to deposit account of my client is ballooning. I have both Deposit and Payment with the same amount. Basically referring to same transaction. The QBO Care told me to edit the Sales Receipt or Payment in the Register and change the account where it should be deposited. So I changed it from Payment to Deposit Accounts to the Bank Account of my client, did I do it right?
No, sounds like there are duplication going on. Check if both transactions have the same invoice. If not there are duplication for sure, in this case you will need to delete the duplicated transaction. Be careful when doing not to delete what you should not. If you have a third party app integration and also enter invoice in the system it will create duplication
Hi Claudia. Thank God I found this video of yours. The Payment to deposit account of my client is ballooning. I have both Deposit and Payment with the same amount. Basically referring to same transaction. The QBO Care told me to edit the Sales Receipt or Payment in the Register and change the account where it should be deposited. So I changed it from Payment to Deposit Accounts to the Bank Account of my client, did I do it right? I'm going insane with this.
No, sounds like there are duplication going on. Check if both transactions have the same invoice. If not there are duplication for sure, in this case you will need to delete the duplicated transaction. Be careful when doing not to delete what you should not. If you have a third party app integration and also enter invoice in the system it will create duplication