I downloaded a personal checking account because we have paid business expenses out of it. I manually entered the expenses using the offset account Owner's Contribution. Have I done this correctly? I dont understand why the personal account is showing up in my balance statement though... even if i deactivate it, it shows.... please advise. Thank you. I learn so much from your tutorials. Absolutely one of the best! I appreciate your help.
Thank you Hector you helped me so much! Do you have any videos that show what to do with the bank transactions that have "match" or "transfer" by them? The checks I write to myself from my business account to my checking account come up as "match" when I review them. Any help you can give me would be greatly appreciated. Thanks again for a great video!
Hi Hector, can you do a video on liabilites accounts in qbo. Examples employee 401k /fsa/commuter check deductions from their payroll. Thank you so much!
Really like your videos-- great service for us techie duds! Question:I have Quickbooks 2019 for Mac. I can't even get started as I can't find that Banking page you start off with. Help! (and thanks(
I have three different accounts on QB's. When I am writing a check out out of the main account to these other accounts how is that classified for each bank? I have my main account, profit account and owners pay account. When the bank feed comes over what category should I put each of these under?
Hello, I want to know what categories to use for a truck company, how to pay for drivers, loan expenses ,when you pay chassi at the port I would like to Know the Categorise tha should be Used
I recently found your videos and love them. I have QB online. My banking tab does not have the categories in bubbles on top like yours does. Therefore I cannot group and batch action multiple items. Do I need to upgrade my QB?
Publix is not office supply. Nobody goes to a supermarket to purchase office supply. Therefore a memo should be added to a vendor which normally does not handle supplies normally purchased from particular vendors, in this case Staples. You would not categorize Staples as meal expense as an example. The IRS auditors are not stupid.
Hector, I downloaded my chase account but have not downloaded my Amex card yet. Quickbooks has transfer and not add so how to I handle that ? Should I download my Amex card first?
I'm really interested in Online but am concerned that I keep hearing reviews indicating that you can't have multiple companies with the online version. Is that the case even if you are self-employed and working for two or three companies ie. Lyft Driver, Travel Agent & Real Estate Agent where you're not invoicing independently? Also, I think the Self-Employed version makes the most sense for me, do to the Mileage tracking but am concerned there isn't enough customizability with the categories, maybe I'm wrong. Would love your thoughts. Thank you.
Thank you for the tutorial. I have a question. I have been using QB online for a year and the problem I have on my deposits is that if I make a change on the deposit and save then at the end when I am doing the reconciliation I see the same deposit twice so QB only chooses the one I corrected but the other one stays in there. What am I doing wrong? How can I avoid the system leaving the deposit that I corrected? Thanks! Maria E Dalton.
What's the best way to categorize my credit card payments? Ex. When i'm on my credit card what should I categorize it as? When i'm on my checking, what should i categorize it as when it's paying towards my credit card?
It is not a choice to enter the name of the vendor. You have to enter the vendor's name. In an IRS, which I have participated, audit they will ask why the vendor's name was not included. And if they view too many transactions with no vendor, they will fine you on this. The exclude section I use when customer's have two business or more and use the same credit card for all business, therefore, the exclude and batch delete come in handy.
I hate when people don’t enter the vendor name, and I will always advise against it. But the software does give you the choice. Great tip on the “exclude” section. I just send it to shareholder distribution.
Hector, - a brilliant series, - thank you. One thing bugs me: By mistake, I enter a bank payment as an 'Expense' when it should have been a 'Bill Payment'. How can I reverse that? Can you comment?
Hello, If I used a cc linked to business 1 for an expense for business 2, how would I categorize that in the books for business 1 and business 2 (separate and accounts). I’ve asked like 10 people and nobody knows, and every time I call quickbooks they say they can’t answer it because they are not CPA’s.
I like the option " show bank details", but how can I make it stick???? It seems to go back to defaults (wherever they are set) when I leave that screen nd return????
Hector buenos dias, teno una pregunta, alguna vez has escuchado que haciendo ADD las transacciones, QBO las duplica o triplica? Dicen que es mejor hacerlas MATCH, es esto cierto? Gracias!!!
Hey hector, I'm a virtual bookkeeper, how do I know the category of expenses the client has spent his money on so that I may record it in QBO? Currently the client puts narration of purpose against each transaction in bank statement's excel or csv file and I record accordingly in QBO. Is ther any way out through this bank feeds functionality? Please reply
Hi, thanks for the nice video. Just wanted to ask if there is any option to change the programme date in QB. I wanted to set up a recurring entry prior to date today and it doesn't allow to do that. In other software, you can change or lock the date to enter any transactions prior to the date today. Any help on this will be highly appreciated! Thank you.
Good tutorial. I have Quickbooks Online version 3.5.2-200 and my check register and the options under the gear don't look like the one that you are teaching from. Do they intentionally change layouts so that tutorials become obsolete? Thanks for posting this but it's frustrating.
Thank you for your video. Do you have one explaining how to record transactions when PayPal is added as a bank in QB? I learned I'm supposed to record the transfer from the credit card to PayPal, first under the credit card bank, then when I go back to PayPal bank it should offer to match that transaction but I can't get it work. PayPal bank also isn't recognizing Shopify invoices to match them to payments received in PayPal. I need to balance my books but this just isn't working. Any help will be appreciated. Thank you 🙌🏼
This is great except there too many assumptions. What version of Quickbooks? You are not working or explaining QB desktop. Your screens are not the same as mine. I see acounts not categories. This module is the essence of balancing QB so it is so vital.
Philip Miller there is a different video for desktop... that is why I wouldn’t spend any time on that... and “categories” is a term being used interchangeably with accounts for the lamen.
@@HectorGarciaCPA Thank you so much for replying. Defining these terms is everything. I would like to see you drill down on dowloads from the bank in QB Desktop and how to categorize expenses and credit cards in the "Transactions List" screen. I have only seen on TH-cam that specifically shows these screens. You are doing a great job.
@@HectorGarciaCPA thank you for the kind reply. All you need to caution is the desktop version has significant limitations. Intuit QuickBooks support is essentially nonexistent. They do not care. The online and accountant versions are much more expensive. I know I am not the 1st to complain. I think it would behoove your audience to be upfront about these limitations and shortcomings.
Hi Hector. Here in Canada we have HST. When I categorize, how can I split the expense invoices into the expense portion and HST portion? Please advise.
Hi Hector, for the "received column" such things as refunds/credits or simply making a payment from bank account to credit card account, what do you do with them? Thanks! -Moses-
I had found a video after i sent you a message about transferring and matching so that helped. What if the credit cards show negative numbers in banking? what does that mean? Thanks.
Hi Hector. What are your thoughts on PDF2QBO I would like to upload all of my Bank statements from mid June 2015 to Today. Or is there another way to get the info into QB that is older than 90 days
Hey was wondering if its possible to edit the Received and Spent Category? Have some under review that should be under Spent but seem to be in Received..
Is there a bank Simulator that's works like a real Bank minus credits cards that will connect to QuickBooks Online Its like a fake bank but operates like real one
Hello 👋🏼 how do you match a transaction that was made once but shows up on banking as two separate transactions because of a convenience fee? Please help :( I’m so confused 🤷🏽♀️
is there a date range on what quickbooks will sync or download from your bank/credit card? I am not getting the entire 2017 year. It is only going back to Nov 2017 and up to May 2018 and we are now in August 2018. Thanks in advance for any help/suggestions
How can i record mony send to vendor but the goods not coming yet ! Bcz if i add in expense the product will be added in the store but its actually not shipping yet
If is to another acccount that the business owns, just choose that account. If is an account not related to the business, it’s either a loan, equity transaction, or expense to a 3rd party
Hector Garcia CPA thank you. can I account it to owner’s equity if received or owner’s drawings if transferred to a not related business account? thanks again
Still, I prefer QB desktop Premier or Accountant any day over the online version. I do have to admit the Online version is better than it used to be, yet I still gravitate to the QB desktop.
Hector you deserve every bit of ad revenue that you generate on TH-cam. You do a great job and are very thorough. Keep the content coming! $$
Thanks
I've been looking for this explanation for YEARS!!!! Thank You.
Wow Waaaaaaay more helpful than official quickbooks vids! thank you and thank god youre here.
Thanks ;)
You have no idea how helpful this was. AMAZING stuff
thanks
From the Philippines! Thanks Hector looking forward for more videos. I've learned a lot on QB by watching your tutorial. God bless and more power.
Josan Gloria thank you.
Thank you Hector, you explained this really clearly and it has definitely helped me understand how to work in QuickBooks.
God Bless You, Brother... Maybe the best presenter on TH-cam.
Amen, thanks!
Can you go over how to add a wire transfer - bank to bank
Thank you Hector. This tutorial was very informative and I definitely learned a lot. Looking forward to viewing your other links that you notated.
This is gold. Thank you so much! You make our lives so much easier.
best quickbooks video on youtube, thanks a bunch Hector!
Laser Media thanks
Excellent work. I have actually enjoyed your lectures and you have actually increased my understanding of categorizing downloaded transactions.
Thanks for your help. Now I really understood how bank feeds work in QBO.
Jafar Sharif awesome
Your videos are AWESOME!!!! I have been learning so much from them. Great job!!!
I downloaded a personal checking account because we have paid business expenses out of it. I manually entered the expenses using the offset account Owner's Contribution. Have I done this correctly? I dont understand why the personal account is showing up in my balance statement though... even if i deactivate it, it shows.... please advise. Thank you. I learn so much from your tutorials. Absolutely one of the best! I appreciate your help.
Super helpful Victor! I work in my iPad. How well does QB’s online work on the iPad?
Lol it's Hector ;)
Thank you Hector, this is very helpful. Question, once we add and categorize on the banking feed, do we still need to do and add on the expenses?
Thank you Hector you helped me so much! Do you have any videos that show what to do with the bank transactions that have "match" or "transfer" by them? The checks I write to myself from my business account to my checking account come up as "match" when I review them. Any help you can give me would be greatly appreciated. Thanks again for a great video!
Thank you! You explained this beautifully
Hi Hector, can you do a video on liabilites accounts in qbo. Examples employee 401k /fsa/commuter check deductions from their payroll. Thank you so much!
How you create those bubbles (as you said)? Or is there a video about that?
I like your videos, I'm learning a lot.
Those are old.. don’t exist anymore
Very good videos, my qbo does not have the bubbles as in your video at 1:31? Any suggestions? Thank you
Brenda some have it some don’t..
I'm learning to be a virtual bookkeeper and this is such a helpful video! Thank you for the wonderful tutorial Hector =)
Loved that tutorial! Learned a few things! Thanks!
Awesome
Hector, you're a legend.
Hi Hector, I am importing monthly tax entry from Checking account, but I could not figure out how to categorize tax entry?
How do I categorize to chart of accounts subitems when I transfer between two checking accounts for the same organization?
Really like your videos-- great service for us techie duds! Question:I have Quickbooks 2019 for Mac. I can't even get started as I can't find that Banking page you start off with. Help! (and thanks(
QB Mac is way different, I have not created any content on Mac.
I have three different accounts on QB's. When I am writing a check out out of the main account to these other accounts how is that classified for each bank? I have my main account, profit account and owners pay account. When the bank feed comes over what category should I put each of these under?
Hello, I want to know what categories to use for a truck company, how to pay for drivers, loan expenses ,when you pay chassi at the port I would like to Know the Categorise tha should be Used
I recommend to sit down with a accountant and do a few with him/her. There is no single black/white answer
I recently found your videos and love them. I have QB online. My banking tab does not have the categories in bubbles on top like yours does. Therefore I cannot group and batch action multiple items. Do I need to upgrade my QB?
shelley daza no, the bubbles were removed
As another CPA you know your stuff and explain very well! Gave you a thumbs up!
Thanks
Publix is not office supply. Nobody goes to a supermarket to purchase office supply. Therefore a memo should be added to a vendor which normally does not handle supplies normally purchased from particular vendors, in this case Staples. You would not categorize Staples as meal expense as an example. The IRS auditors are not stupid.
Well that is all arguable... Publix sells napkins;, cups, plates, paper towels, printable paper, pens.... so it’s all circumstance
Hector, I downloaded my chase account but have not downloaded my Amex card yet. Quickbooks has transfer and not add so how to I handle that ? Should I download my Amex card first?
Hi hector ur a great help. Do u know why its showing me negative expense report on my balance sheet?
Balance sheet doesn’t have expenses, so not sure
I'm really interested in Online but am concerned that I keep hearing reviews indicating that you can't have multiple companies with the online version. Is that the case even if you are self-employed and working for two or three companies ie. Lyft Driver, Travel Agent & Real Estate Agent where you're not invoicing independently? Also, I think the Self-Employed version makes the most sense for me, do to the Mileage tracking but am concerned there isn't enough customizability with the categories, maybe I'm wrong. Would love your thoughts. Thank you.
Did you ever get an answer?
Can you explain the split key option? Or do your u have a video on it?
its just to log two categories into one transaction
Thank you for the tutorial. I have a question. I have been using QB online for a year and the problem I have on my deposits is that if I make a change on the deposit and save then at the end when I am doing the reconciliation I see the same deposit twice so QB only chooses the one I corrected but the other one stays in there. What am I doing wrong? How can I avoid the system leaving the deposit that I corrected? Thanks!
Maria E Dalton.
Good job - clear explanation
What's the best way to categorize my credit card payments? Ex. When i'm on my credit card what should I categorize it as? When i'm on my checking, what should i categorize it as when it's paying towards my credit card?
Create a credit card account.. then you have o enter every charge from the credit card.
It is not a choice to enter the name of the vendor. You have to enter the vendor's name. In an IRS, which I have participated, audit they will ask why the vendor's name was not included. And if they view too many transactions with no vendor, they will fine you on this. The exclude section I use when customer's have two business or more and use the same credit card for all business, therefore, the exclude and batch delete come in handy.
I hate when people don’t enter the vendor name, and I will always advise against it. But the software does give you the choice.
Great tip on the “exclude” section. I just send it to shareholder distribution.
Hector, - a brilliant series, - thank you.
One thing bugs me: By mistake, I enter a bank payment as an 'Expense' when it should have been a 'Bill Payment'.
How can I reverse that? Can you comment?
Chris Derby you can’t change the type
Can you tell me or point me to video that shows how to manage payments that have been downloaded and apply them to an invoice?
I don’t know which video covers that, but the concept is called “Matching”
Hello,
If I used a cc linked to business 1 for an expense for business 2, how would I categorize that in the books for business 1 and business 2 (separate and accounts). I’ve asked like 10 people and nobody knows, and every time I call quickbooks they say they can’t answer it because they are not CPA’s.
Hi Hector! What would your thoughts be on how to categorize earnest money that was refunded due to a cancelled real estate sale?
Other Income
I like the option " show bank details", but how can I make it stick???? It seems to go back to defaults (wherever they are set) when I leave that screen nd return????
I hate when that happens… seem to be random
Hector buenos dias, teno una pregunta, alguna vez has escuchado que haciendo ADD las transacciones, QBO las duplica o triplica? Dicen que es mejor hacerlas MATCH, es esto cierto? Gracias!!!
Woodbrid LLC a veces se bajan duplicadas.. si es el caso las tienes que borrar después.
Hey hector, I'm a virtual bookkeeper, how do I know the category of expenses the client has spent his money on so that I may record it in QBO? Currently the client puts narration of purpose against each transaction in bank statement's excel or csv file and I record accordingly in QBO.
Is ther any way out through this bank feeds functionality?
Please reply
Hi, thanks for the nice video. Just wanted to ask if there is any option to change the programme date in QB. I wanted to set up a recurring entry prior to date today and it doesn't allow to do that. In other software, you can change or lock the date to enter any transactions prior to the date today. Any help on this will be highly appreciated! Thank you.
Not possible
Good tutorial. I have Quickbooks Online version 3.5.2-200 and my check register and the options under the gear don't look like the one that you are teaching from. Do they intentionally change layouts so that tutorials become obsolete? Thanks for posting this but it's frustrating.
They do change... but note sure what you are talking about, I would need to see a screenshot
Hi Hector, we're a church organizations, will Quickbooks be a good software to use?
Thanks for this tutorial, it was very helpful! Do you have tutorials on how to prepare sales tax reporting packets for small businesses?
Susy G no, don’t have that.
My version doesn’t have add selected on the bottom why not
Excellent Video, Hector . Thank you.
Thanks
Great videos. Do have anything for using QB online with PayPal?
Thomas Walsh yes.. is in my channel
Thank you for your video. Do you have one explaining how to record transactions when PayPal is added as a bank in QB? I learned I'm supposed to record the transfer from the credit card to PayPal, first under the credit card bank, then when I go back to PayPal bank it should offer to match that transaction but I can't get it work. PayPal bank also isn't recognizing Shopify invoices to match them to payments received in PayPal. I need to balance my books but this just isn't working. Any help will be appreciated. Thank you 🙌🏼
I am going to do an updated PayPal video in Feb 2020
@@HectorGarciaCPA Awesome! Thanks so much 👍🏼👍🏼
I did not see where the Bank Feed did matching with what was already in the Register in your tutorial.
Tim Baker check the other bank feed videos
Thanks for the videos! All have been very helpful!
You welcoem
This is great except there too many assumptions. What version of Quickbooks? You are not working or explaining QB desktop. Your screens are not the same as mine. I see acounts not categories. This module is the essence of balancing QB so it is so vital.
Philip Miller there is a different video for desktop... that is why I wouldn’t spend any time on that... and “categories” is a term being used interchangeably with accounts for the lamen.
@@HectorGarciaCPA Thank you so much for replying. Defining these terms is everything. I would like to see you drill down on dowloads from the bank in QB Desktop and how to categorize expenses and credit cards in the "Transactions List" screen. I have only seen on TH-cam that specifically shows these screens. You are doing a great job.
Philip Miller i am not a big fan of the QB Desktop bank feeds. I am unlikely to spend any more time in them.
@@HectorGarciaCPA thank you for the kind reply. All you need to caution is the desktop version has significant limitations. Intuit QuickBooks support is essentially nonexistent. They do not care. The online and accountant versions are much more expensive. I know I am not the 1st to complain. I think it would behoove your audience to be upfront about these limitations and shortcomings.
Could explain bank roll for money receipt which we have calculate vat for it
Hey Hector how are you? where can I get one of those hats?
I bought this at the QuickBooks Connect conference
@@HectorGarciaCPA Thank you do you know if there is a website where I can buy it?
HOW CAN CATEGORIES INCOME IN QBO ACCOUNTANT ON 2018 VERSION
Hi Hector, I'm already in the 30 day trial, can still use you code for the discounted rate? Great vids btw!! Thx.
If you didn’t use the link on the beginning, no.
Hi Hector. Here in Canada we have HST. When I categorize, how can I split the expense invoices into the expense portion and HST portion? Please advise.
I don’t use CA version.
Hi Hector, for the "received column" such things as refunds/credits or simply making a payment from bank account to credit card account, what do you do with them? Thanks! -Moses-
That’s for credit memos
Send them to the bank account the money went to or came from
I had found a video after i sent you a message about transferring and matching so that helped. What if the credit cards show negative numbers in banking? what does that mean? Thanks.
How do you deal with the taxes from these invoices?
You can turn on the Sales Tax feature
Hi Hector. What are your thoughts on PDF2QBO I would like to upload all of my Bank statements from mid June 2015 to Today. Or is there another way to get the info into QB that is older than 90 days
Garry Skwarek if the bank give you access to a QBO file, then you dont need a converter
@@HectorGarciaCPA my bank only let's me download 90 days, that's the problem
Thank You very much! You helped me a lot.
Hey was wondering if its possible to edit the Received and Spent Category? Have some under review that should be under Spent but seem to be in Received..
Chart of Accounts
How do I get the various bubble to "All Transactions""Sales Income""Expenses""Taxes and Licenses Expense"
They removed the bubbles, but everything else is the same.
Is there a bank Simulator that's works like a real Bank minus credits cards that will connect to QuickBooks Online
Its like a fake bank but operates like real one
No clue
Great content! Thank you!
Hello 👋🏼 how do you match a transaction that was made once but shows up on banking as two separate transactions because of a convenience fee? Please help :( I’m so confused 🤷🏽♀️
crist2082 you have to click on FIND match and select them both
What happen when the transactions from the bank don’t appear on the list ?
Enter it manually.
Hector Garcia CPA Do you have a video how to enter a manual transaction?
Arnold Gutiérrez no..
Arnold Gutiérrez no..
God bless for information we learned
Hi Hector! I just wanna ask what to do when intuit charge us twice in a month?
Call them
@@HectorGarciaCPA thank you hector! You really a big help
Great video, also now I'm craving La Granja lol
Ha ha... spend too much money there
is there a date range on what quickbooks will sync or download from your bank/credit card? I am not getting the entire 2017 year. It is only going back to Nov 2017 and up to May 2018 and we are now in August 2018. Thanks in advance for any help/suggestions
Rachelle Bennett most banks are limited to 90 days.. so if you got Nov 2017 that is amazing! You need to download the rest manually
Thank you so much! Which video do you show how to enter manually or excel? Thanks!
what about current? it is only showing through May this year?
Rachelle Bennett i May not have a video on manual data entry, LOL..
You need to go into the check register and enter it one by one.
I thought you could download it as an excel file and then upload it somehow, that is what I thought you mentioned somewhere. :(
wish I had seen your video years ago!!!
You are an excellent teacher. Thank you!
Thanks
How does one turn on the "bubbles" across the top?
Kim Ranger they don’t exist anymore.. :(
Can you change a category on a deposit?
Yes..
How can i record mony send to vendor but the goods not coming yet ! Bcz if i add in expense the product will be added in the store but its actually not shipping yet
Vendor Prepayment asset
Thanks, that was really useful!
Awesome, you welcome
Great tips! Thank you!
You welcome
Another great video. Thank you!
where can you categorize bank transfer? thanks
If is to another acccount that the business owns, just choose that account. If is an account not related to the business, it’s either a loan, equity transaction, or expense to a 3rd party
Hector Garcia CPA thank you. can I account it to owner’s equity if received or owner’s drawings if transferred to a not related business account? thanks again
Where can I find someone like you local? in Destin FL?
Chinh Cao search for “find a ProAdvisor”
Thanks for your help Hector.
NoirXplorer you welcome
Thanks alot Hector!
You welcome
Great job Hector
Thanks
Powerful stuff. in comparison to quickbooks desktop which most these options dont exist.
Thanks for the lesson.
youtube watcher yeap
Still, I prefer QB desktop Premier or Accountant any day over the online version. I do have to admit the Online version is better than it used to be, yet I still gravitate to the QB desktop.
THANKS A LOT VERY USEFULL
:)
Thank you. Great tips.
You welcome
Thank you very well explain
Can you use this with a PayPal?
Yes
Thanks! Awesome video!
Awesome! Thanks Hector
ozzieva you welcome
Thank you Hector.
You welcome
i need this subject in spanish.
No lo tengo :(
Thank you Hector!
You welcome