Sir I am a little learner & a big fan of yours. I have more than 6 years of bookkeeping experience & also a quickbooks proadvisor certified. Now I want to work with you as an intern.
Hector, you are the best Quickbooks tutor on RUclips, you don't skip anything that is important and nothing you do is confusing, a shout out here from South Africa !
Thank you Hector; you provided some great detail. I've been reconciling bank statements in Desktop QB for over 30 years and just migrated to on-line. I learned a lot from your video that is going to save me time.
Hector your videos are great! Very thorough and descriptive. Thank you so much for putting these out here for us newbies!! Yours are the best I've seen. Your 3.75 hr introductory video was a great starting place to learning the ins and outs. Thank you!!
Hi Hector. 1. I have a supplier credit note that I have recorded already. There is a Money Coming in the bank account against that Supplier Credit. How can I match my Money In bank transaction with the supplier credit. Would you please do a short video on this. Thank you so much for all your videos. 2. We can change categories in Batch can we change VAT/Sales Tax rate of a Batch of transactions. Would you Please guide!!
This does look like it's very useful, if not the most useful feature. It will also take some practice. I want to hear more about sub-categories I hope that is taken up soon.
Best QBO tutor! What would explain a transaction that is a "deposit" also showing up as a "payment" when I try and reconcile? Do you have a video that shows steps from invoicing a customer, to receiving payment (placing in undeposited funds), then making a deposit to the correct bank account, and then reconciling when using the bank link? Thank you.
Kinda hard to judge without looking at it. But maybe when you go into that Payment, change the “deposit to” account from the bank account and into “Undeposited Funds”
hello Hector, i am from Pakistan and learning quickbooks to do freelancing so that i can pay my college and hostel fees and if i something left after these expenses i will buy my favourite blue colour t shirts.I hope i will get clients on fiver or upwork.I dont have anything to give you except my prayers.
Because I come from a poor family, I cannot afford to buy QB Source. The love and respect of Pakistan goes out to you for these wonderful lectures, sir.🟢⚪
You are such a life saver, I did many things and now i can't fix my reconciliation for one month, I'm losing my head. I'm off on the difference and I don't know what else to do.
Hector you are an awesome tutor. Thank you so much for such a great explanation of bank reconciliation. Really appreciate your time and effort sharing it.
Thank you for this explanation, Ive been given a new position from home and they use quickbooks, ive used xero but not quickbooks & ur video is everything, ive learnt alot, much appreciated 😗 stay blessed 💚
@@HectorGarciaCPA almost finished watching your " introduction to quickbooks desktop" tutorial, this has given me a bigger view of the software, I cant thank you enough 😗 again much appreciated!! 💙
uick question: when reconciling my business checking account, QB tells me that one tansaction ws deleted, which is a credit card payment from the checking account. But that transaction is there and reconciled in the checking and credit card ledger! Any explanation?
@@HectorGarciaCPA Thank you for the response; let me keep going and see if it gets any better... Even though I'm an accounting student, this is sometimes very confusing...
Hector please do a video on how to filled a w2c instrucciones when only the ss# is entered incorrect. And w3c when the total amounts filled on w2 were correct. Thanks
Your channel is very helpful and full of great information and a very good quality of your videos, to any one wants to start with the bookkeeping i really recommend this channel. I have a question is it possible to become a certified payroll with QuickBooks? Thank you for your efforts.
Thank you for this video. As always it is very helpful and useful. I have a question: what would you do if you had 1799 transactions in bank reconciliation and just a 0.02$ difference? Would you make an adjustment or re-check each transaction? Or any other solutions?
@@HectorGarciaCPA Thank you, Hector, I am asking because I faced the problem doing reconciliation that even the small discrepancy can cause issues that affect further periods. In my case, it involved transactions with thousands of dollars afterward...
If you are in cash basics you shouldn't have to worry about those two last checks on February, if they haven't clear your account you should move the date to March.
I have two problems with a checking account . 1. the person that was doing the books did not use the "banking " section correctly. they would just add without matching a transaction. so there is double of numerous transactions through the entire year of 2021. Spoke to qb and i was told to go to banking and under the category column find each transaction and undo it. I did this and the duplicate transaction was removed. but it through my beginning Feb 2021 balance off by the amount of the items i "undone". what is the solution? 2. they reconciled the rest of the year manually (old fashion way) and put a 'r" on each reconciled transaction for the entire year. again spoke with qb and they sd since it was not reconciled through qb that I could just remove the "r" and it would have no effect on the books. I cannot tell if it does or does't because I can't get past Feb. 2021. about to pull my hair out. help!
I am a beginner with QB online. I would like to know how to reconcile bank statements from a previous year? When I select "reconcile", there is a beginning balance shown. Where does this amount come from. I have never reconciled anything in QB. I just moved from an obsolete accounting system. I'm so lost!!
i need some help, so i am trying to reconcile. step #1 Deposit to match them them i did, Then step #2 was do EXPENSE which i was matching them but some of where not in the list but they are in the "register" the dates are in line with the month but they are not showing up in the reconcile
Hector, great video on reconciliations. Do you have a video that explains how to enter bank and credit card statement data manually when reconciling. My QB online version does not have the bank/credit card connection so my data is not downloaded into Quick Books. Thank You!
I enter the expenses as you would any expense. However, when paying I pay by the CC account. That way that transaction shows up as a CC transaction and will match the statement. I hope this helps.
i just did the "click all and the click all again to clear transaction checks to start fresh" and i still have deposits and payments in the math at the top. what do i do here?
Hi Hector, I love this video. I'm wondering if you can help me with an issue I'm having. When I'm in reconcile my transaction for a transfer will show as a transfer and as a deposit. How do i make them one? for example: I transferred $5 from account A to account B. Now in reconcile it says there was a deposit for $5 into account B and a transfer for $5 into account B. I can't give the blue check to both transactions because it makes the difference balance $5. What do i do?
So in Bank reconciliation in QBO, you are making the book balance agree with the bank balance? so you only apply the book reconciling items..what about if it's the bank that made the miss recording? like 2 debits instead of one, or 2 credits instead of just one?
How do I add my banking info so that when I hit the "View Statement" button the current statement automatically pops up so that I don't have to add it manually?
Hi Hector, how did you know that transaction has to be recorded under the management fee? suppose you have it under unclear transactions what can you dO?
Great video Hector. By mistake, I deleted a vendor payment which had cleared months before the current bank rec. Now there is difference on the beginning balance while reconciling. How do I enter the vendor payment I deleted and reconcile it? Thanks.
What if if is not the right number? Its my first time reconciling the account so my QBO says 0 and the bank statement says a number from the beginning of that month.
HELP! I am doing the bookkeeping for my son and am learning QB as I go by watching your videos!! Thank you!! During the reconciliation process, one issue I'm regularly seeing is duplicate deposits. It appears one deposit comes in from the bank feed and the other deposit is "system-generated" in QB during the payment received process. How do we stop the system-generated deposit from being created in QB?
Hector, more specifically, the system-generated deposit is for a payment made direct through QB. It creates a system generated deposit in the reconciliation. A duplicate deposit it created when the payment comes comes through the bank feed to QB. Which one is correct and which one should be deleted?
Hello. I have a question. How would I categorize my sales tax payments when they hit my bank? I think I did not set up my chart of accounts right because when it comes to choosing the payee I am ok but when I have to choose the category it is where I am wrong. Can you help?
Thank you. Treasurer for a 45 year old Social Club 501c7. Model Trains 250 members. Have annual Convention and each rev and exp item has been setup in QB Desktop as a separate Chart of Accounts Entry. Should I have done that?
Thank you very much. I didn't know about classes on Desktop until I got QB online.. Should I begin to use classes and replace 2022 account entries. e.g. 2023 Convention Expenses which I have treated as a new account with sub-accounts below that and then replace with classes? Other people must have similar situations with repetitive projects. Since a project will have income and expense, how should I set it up? Since 2023 is a new year, I could start now but leave 2022 Convention Transactions alone. Please send me a bill if needed.🤫@@HectorGarciaCPA
I made a mistake when I tried to change the date from July to August, but I only realized it after reconciling till December. After looking into it, I was told that it's not possible to change or redo any month without undoing everything from August to December.
Just finished binge watching 4 hours of your previous videos.
You’re invaluable to us qbo newbies. Thanks so much Hector, you’ve got a big fan here.
I can't agree with you enough.
Absolutely agree! Been watching these videos for a few days now and i can see EVERYTHING i was doing wrong LOL
Sir I am a little learner & a big fan of yours.
I have more than 6 years of bookkeeping experience & also a quickbooks proadvisor certified.
Now I want to work with you as an intern.
Hector, you are the best Quickbooks tutor on RUclips, you don't skip anything that is important and nothing you do is confusing, a shout out here from South Africa !
:)
You are a gentleman and a saint for offering so much knowledge so freely and completely, Hector. May God richly Bless you.
:)
Thanks! Reconciling simplified without unnecessary confusing details.
Thanks, this video was very helpful! I used to reconcile on excel and didn’t know how to do it in qb!
Thank you Hector; you provided some great detail. I've been reconciling bank statements in Desktop QB for over 30 years and just migrated to on-line. I learned a lot from your video that is going to save me time.
Awesome
Your lectures are very informative. Can show you show me how to prepare a check and print it
:)
Hector your videos are great! Very thorough and descriptive. Thank you so much for putting these out here for us newbies!! Yours are the best I've seen. Your 3.75 hr introductory video was a great starting place to learning the ins and outs. Thank you!!
Glad you like it
The instructor is awesome. This tutorial is very helpful.
I agree!
Hi Hector. 1. I have a supplier credit note that I have recorded already. There is a Money Coming in the bank account against that Supplier Credit. How can I match my Money In bank transaction with the supplier credit. Would you please do a short video on this. Thank you so much for all your videos. 2. We can change categories in Batch can we change VAT/Sales Tax rate of a Batch of transactions. Would you Please guide!!
Thanks Hector, I really learned a lot from your videos, actually your videos help me also to pass the quickbooks proadvisor examination.
This does look like it's very useful, if not the most useful feature. It will also take some practice. I want to hear more about sub-categories I hope that is taken up soon.
Thank you so much for taking the time the put this video on reconciliation together .
You are welcome
Best QBO tutor! What would explain a transaction that is a "deposit" also showing up as a "payment" when I try and reconcile? Do you have a video that shows steps from invoicing a customer, to receiving payment (placing in undeposited funds), then making a deposit to the correct bank account, and then reconciling when using the bank link? Thank you.
Kinda hard to judge without looking at it.
But maybe when you go into that Payment, change the “deposit to” account from the bank account and into “Undeposited Funds”
Thank you so much Hector, because of you I learned to reconcile the account successfully. Loads of blessings to you, Thanks a lot
:)
hello Hector, i am from Pakistan and learning quickbooks to do freelancing so that i can pay my college and hostel fees and if i something left after these expenses i will buy my favourite blue colour t shirts.I hope i will get clients on fiver or upwork.I dont have anything to give you except my prayers.
Best of luck
Thank you for the step by step instructions.
Because I come from a poor family, I cannot afford to buy QB Source. The love and respect of Pakistan goes out to you for these wonderful lectures, sir.🟢⚪
Thank you, happy to help
Thank you! You also speak in ways I fully understand!
You are such a life saver, I did many things and now i can't fix my reconciliation for one month, I'm losing my head. I'm off on the difference and I don't know what else to do.
You might need some one on one support
@@HectorGarciaCPA is that something that you can offer?
@@espressoequipment5474 my team can, starting at $395. Call 954-414-1524 to set it up
I got the right Teacher. Thanks a lot hector.
One of best video for all.
Good :)
Wow! this tutorial is awesome. I'm a smal business and I'm learning on how to use QB. Thank for the clear explanations.
:)
Hey Mr. Hector, how would you reconcile your bank statement if some of the added square transactions are missing? Thank you for great videos.
Been a fan since 2018 thanks mentor Hector !
:)
Such an easy fix after hours of trying to figure it out! Thank you so very much for sharing your extensive knowledge.
:)
Thank you, the last 10 minutes of this solved my concern about Balance sheet and Bank Statement mismatch.
Yes is a common question
Need help figuring out an unexplainable difference amount during reconciliation. I've followed the steps here but I still have a large difference.
Always a nice watch. Thank you Hector!
Thanks, keep watching and liking!
Hector you are an awesome tutor. Thank you so much for such a great explanation of bank reconciliation. Really appreciate your time and effort sharing it.
You welcome
Best video so far! Thank you so much.
:)
Thank you for this explanation, Ive been given a new position from home and they use quickbooks, ive used xero but not quickbooks & ur video is everything, ive learnt alot, much appreciated 😗 stay blessed 💚
:)
@@HectorGarciaCPA almost finished watching your " introduction to quickbooks desktop" tutorial, this has given me a bigger view of the software, I cant thank you enough 😗 again much appreciated!! 💙
OMG. Thank you so much. I followed your step-by-step process and I did it. Wow.
Fantastic!
why do the balance sheet shows negative bank balance when recociliation is correctly done? please reply
uick question: when reconciling my business checking account, QB tells me that one tansaction ws deleted, which is a credit card payment from the checking account. But that transaction is there and reconciled in the checking and credit card ledger! Any explanation?
What if the difference between the two accounts (the QBO and the bank account) increases as you continue to reconcile the accounts?
Once you reconcile and delete all duplicates/errors, bank and QBO will match
@@HectorGarciaCPA Thank you for the response; let me keep going and see if it gets any better...
Even though I'm an accounting student, this is sometimes very confusing...
Fantastic resource thank you!
:)
i love watching all your videos. you are amazing hector
Thanks
Hector please do a video on how to filled a w2c instrucciones when only the ss# is entered incorrect. And w3c when the total amounts filled on w2 were correct. Thanks
I wont do a video like that..
@@HectorGarciaCPA thanks
Hello, do you have a video on how to reconcile PayPal account?
yes please!!!
Thank you so much Hector,you really a great teacher..
Thank you Hector. I'll try that.
:)
Thank you so much.
:)
Truly amazing and your teaching style is also polite thank you so much.
Glad you like it
Very nice video. Thanks
You welcome
Excellent content and presentation! Thanks Hector.
Thanks
For example the beginning balance is zero , How can I use it ?
You need to reconcile that correct beginning balance
Thanks for sharing this can you guide me please how I can get dummy bank statements for practice in QBO
Search them in google
Amazing, absolutely thorough video. Thank you so much!
Glad it was helpful!
Your channel is very helpful and full of great information and a very good quality of your videos, to any one wants to start with the bookkeeping i really recommend this channel. I have a question is it possible to become a certified payroll with QuickBooks? Thank you for your efforts.
Proadvisor.intuit.com
Thank you for this video. As always it is very helpful and useful. I have a question: what would you do if you had 1799 transactions in bank reconciliation and just a 0.02$ difference? Would you make an adjustment or re-check each transaction? Or any other solutions?
Adjustment… $.02 is insignificant
@@HectorGarciaCPA Thank you, Hector, I am asking because I faced the problem doing reconciliation that even the small discrepancy can cause issues that affect further periods. In my case, it involved transactions with thousands of dollars afterward...
@@HectorGarciaCPA I have the cleared date on my screen,but I do not have the transaction date ?
@@HectorGarciaCPA you’re so amazing ! Sharing your high educated knowledge is so amazing
If you are in cash basics you shouldn't have to worry about those two last checks on February, if they haven't clear your account you should move the date to March.
The check # no longer displays on my reconciliation. Very difficult to reconcile when I have several transactions of the same amount.
You should be able to enable that
Such a professional personality
:)
Excellent videos, the best so far. Thank you for such a thorough demonstration in the subject.
Thank you so much sir, i fully understand now on qbo bank reconcilliation. God bless.
what if my beginning balance does not match my statement? And quickbooks isnt allowing me to change the opening balance
You need to UNDO the reconciliations, there is another video explaining that
I have two problems with a checking account . 1. the person that was doing the books did not use the "banking " section correctly. they would just add without matching a transaction. so there is double of numerous transactions through the entire year of 2021. Spoke to qb and i was told to go to banking and under the category column find each transaction and undo it. I did this and the duplicate transaction was removed. but it through my beginning Feb 2021 balance off by the amount of the items i "undone". what is the solution? 2. they reconciled the rest of the year manually (old fashion way) and put a 'r" on each reconciled transaction for the entire year. again spoke with qb and they sd since it was not reconciled through qb that I could just remove the "r" and it would have no effect on the books. I cannot tell if it does or does't because I can't get past Feb. 2021. about to pull my hair out. help!
You need mayor cleanup.. you need external help for that
I am a beginner with QB online. I would like to know how to reconcile bank statements from a previous year? When I select "reconcile", there is a beginning balance shown. Where does this amount come from. I have never reconciled anything in QB. I just moved from an obsolete accounting system. I'm so lost!!
There is an entry that was downloaded from
The bank that represents that beginning balance, you can delete the entry
Thank you very much! I learned a lot from this Reconciliation video.
i need some help, so i am trying to reconcile. step #1 Deposit to match them them i did, Then step #2 was do EXPENSE which i was matching them but some of where not in the list but they are in the "register" the dates are in line with the month but they are not showing up in the reconcile
Wondering if you tutor people on "Wave" Accounting Software?
No, Wave is garbage
Thank you for your youtube 🙏🙏👍👍👍
Sir how about if the beginning balance different? Thank you
King of quickbook sir
:)
Would u also do monthly reconciliation for a 6 month clean/catch up?
Hector, great video on reconciliations. Do you have a video that explains how to enter bank and credit card statement data manually when reconciling. My QB online version does not have the bank/credit card connection so my data is not downloaded into Quick Books. Thank You!
I enter the expenses as you would any expense. However, when paying I pay by the CC account. That way that transaction shows up as a CC transaction and will match the statement. I hope this helps.
Thank you so much, Mr. Garcia. God bless!
Awesome tutorial!
Thank you for this. I learned a lot.
Could you please let me know how to create custom report to extract vendor bills with items, rates and quantities from quickbooks.
QB online? I don’t think you can have such Report
How do I correct the ending date when i have already started to reconcile? I accidently put the wrong year? thank you
You have to UNDO the reconciliation, there is another video on that
Thank you so much, this video definitely helped me a lot.
Why my transaction not showing
I need to do bank reconciliation Desk Top
Ok
Best ever!! Thank you!!!👏
Sure, my pleasure
is this the normal way to do the bank recon on quickbooks? what if you have a thousand deposit transactions in a month?
This is the normal way regardless how many you have
i just did the "click all and the click all again to clear transaction checks to start fresh" and i still have deposits and payments in the math at the top.
what do i do here?
Get out and get back in.
What if beginning balance is incorrect or not sure?
You might need to undo de reconciliations
Hi Hector, I love this video. I'm wondering if you can help me with an issue I'm having. When I'm in reconcile my transaction for a transfer will show as a transfer and as a deposit. How do i make them one? for example: I transferred $5 from account A to account B. Now in reconcile it says there was a deposit for $5 into account B and a transfer for $5 into account B. I can't give the blue check to both transactions because it makes the difference balance $5. What do i do?
I would need to see it sorry
So in Bank reconciliation in QBO, you are making the book balance agree with the bank balance? so you only apply the book reconciling items..what about if it's the bank that made the miss recording? like 2 debits instead of one, or 2 credits instead of just one?
As long as total amounts coincide.
How do I add my banking info so that when I hit the "View Statement" button the current statement automatically pops up so that I don't have to add it manually?
Your bank would need to be setup with QB to do that, not all the banks are ready
Hi Hector, how did you know that transaction has to be recorded under the management fee? suppose you have it under unclear transactions what can you dO?
I didn’t “know” i would have gathered info from the person that made the expense and picked the best option from the chart of accounts
Nice! Thank you for helping, you solved my mystery!
:)
Great video Hector. By mistake, I deleted a vendor payment which had cleared months before the current bank rec. Now there is difference on the beginning balance while reconciling. How do I enter the vendor payment I deleted and reconcile it?
Thanks.
Yes.. enter the payment an re reconcile last month
Thanks!
It's not a recommendable version. QBO has lots of issues. The desktop version is a much better and stronger version.
I have a discrepancy on my reconciliation and I found it, but I do not know how to fix it. what can I do?
and its desktop
Very helpful. The video is great
Glad it was helpful!
wonderful tutorial
Thanks
Great video,I have cleared date ,but I do not have the transation dade What I have to do Hector Gracia?
Weird
What if if is not the right number? Its my first time reconciling the account so my QBO says 0 and the bank statement says a number from the beginning of that month.
You might need to undo the last reconciliations, and start from scratch.
Perfect .
Thank you
Hello, How can I sign up for the advanced bank reconciliation course?
Hectorgarcia.teachable.com
HELP! I am doing the bookkeeping for my son and am learning QB as I go by watching your videos!! Thank you!! During the reconciliation process, one issue I'm regularly seeing is duplicate deposits. It appears one deposit comes in from the bank feed and the other deposit is "system-generated" in QB during the payment received process. How do we stop the system-generated deposit from being created in QB?
Delete it
@@HectorGarciaCPA Do i delete the "system-generated" deposit that shows up in "undeposited funds" or the bank generated deposit when reconciling?
Hector, more specifically, the system-generated deposit is for a payment made direct through QB. It creates a system generated deposit in the reconciliation. A duplicate deposit it created when the payment comes comes through the bank feed to QB. Which one is correct and which one should be deleted?
@@deborahblevins2779 the one linked to the invoice stays
good way to make sure that there is no fraud , is to have the bank statements, quickbooks and transactions for cross reference each month.
Binge watching your content! New subscriber!
LOL Great, thanks
Hello. I have a question. How would I categorize my sales tax payments when they hit my bank? I think I did not set up my chart of accounts right because when it comes to choosing the payee I am ok but when I have to choose the category it is where I am wrong. Can you help?
Should go to Sales Tax Payable
Oh!!!! Ok. I will try that. Thank you so much for your reply. Thank you, Thank you!!!
Thank you. Treasurer for a 45 year old Social Club 501c7. Model Trains 250 members. Have annual Convention and each rev and exp item has been setup in QB Desktop as a separate Chart of Accounts Entry. Should I have done that?
I would have used classes
Thank you very much. I didn't know about classes on Desktop until I got QB online.. Should I begin to use classes and replace 2022 account entries. e.g. 2023 Convention Expenses which I have treated as a new account with sub-accounts below that and then replace with classes? Other people must have similar situations with repetitive projects. Since a project will have income and expense, how should I set it up? Since 2023 is a new year, I could start now but leave 2022 Convention Transactions alone. Please send me a bill if needed.🤫@@HectorGarciaCPA
My online statement doesn't have "check mark" circles.
You mean, your reconciliations page? It should have it.. try zooming in and out mayeb
In QB desktop can I undo a reconciliation for a specific month, without undoing other months?
I made a mistake when I tried to change the date from July to August, but I only realized it after reconciling till December. After looking into it, I was told that it's not possible to change or redo any month without undoing everything from August to December.