QuickBooks Online Tutorial: Categorizing dowloaded transactions (2019)

[@RealMattCalvin]

Hector you deserve every bit of ad revenue that you generate on KZbin. You do a great job and are very thorough. Keep the content coming! $$

[@HectorGarciaCPA]

Thanks

[@utleyadmin9679]

God Bless You, Brother... Maybe the best presenter on KZbin.

[@HectorGarciaCPA]

Amen, thanks!

[@deegathers9821]

I've been looking for this explanation for YEARS!!!! Thank You.

[@aqualuxx]

Wow Waaaaaaay more helpful than official quickbooks vids! thank you and thank god youre here.

[@HectorGarciaCPA]

Thanks ;)

[@carolinepartridge4088]

Thank you Hector, you explained this really clearly and it has definitely helped me understand how to work in QuickBooks.

[@alejandrochaves2302]

You have no idea how helpful this was. AMAZING stuff

[@HectorGarciaCPA]

thanks

[@josangloria2111]

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.

[@HectorGarciaCPA]

Josan Gloria thank you.

[@francesolivares6607]

Thank you Hector. This tutorial was very informative and I definitely learned a lot. Looking forward to viewing your other links that you notated.

[@JusttJasmine]

Thank you! You explained this beautifully

[@rosanneturkington8622]

Can you go over how to add a wire transfer - bank to bank

[@conniebrancato5415]

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.

[@ew4096]

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.

[@HectorGarciaCPA]

Well that is all arguable... Publix sells napkins;, cups, plates, paper towels, printable paper, pens.... so it’s all circumstance

[@annthans2728]

This is gold. Thank you so much! You make our lives so much easier.

[@lasermedia3256]

best quickbooks video on youtube, thanks a bunch Hector!

[@HectorGarciaCPA]

Laser Media thanks

[@ew4096]

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.

[@HectorGarciaCPA]

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.

[@joanndelatorre336]

My version doesn’t have add selected on the bottom why not

[@jafarsharif3366]

Thanks for your help. Now I really understood how bank feeds work in QBO.

[@HectorGarciaCPA]

Jafar Sharif awesome

[@MyGarden61]

Your videos are AWESOME!!!! I have been learning so much from them. Great job!!!

[@shaileshpatel3607]

Hi Hector, I am importing monthly tax entry from Checking account, but I could not figure out how to categorize tax entry?

[@michellecoon1126]

How do I categorize to chart of accounts subitems when I transfer between two checking accounts for the same organization?

[@frankbuescher7615]

Good job - clear explanation

[@domingoandresgomezfirpo5076]

Excellent Video, Hector . Thank you.

[@HectorGarciaCPA]

Thanks

[@jewelgoss8005]

I'm learning to be a virtual bookkeeper and this is such a helpful video! Thank you for the wonderful tutorial Hector =)

[@traceyinglimo428]

Loved that tutorial! Learned a few things! Thanks!

[@HectorGarciaCPA]

Awesome

[@kathyscholl7306]

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?

[@user-zc3kd4oc1s]

Hector hello! Could you advise please is it possible to start the new year in Quik Book with new bank account balances, adjust them? I faced with the fact that for the previous year the balance does not match with the bank statement. The difference has been dragging on since 2018. I would like to somehow quickly adjust the incoming balances at the beginning of 2022

[@dianaandino6526]

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

[@HectorGarciaCPA]

I recommend to sit down with a accountant and do a few with him/her. There is no single black/white answer

[@cristinapresquito1644]

God bless for information we learned

[@kyerefrederick627]

Excellent work. I have actually enjoyed your lectures and you have actually increased my understanding of categorizing downloaded transactions.

[@skyerlog5487]

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!

[@jonathanlarios5218]

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.

[@juliegonzalez7540]

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?

[@RandiJamesInc]

Great content! Thank you!

[@davidwalk7828]

Hector, you're a legend.

[@StraightOffTheCouch]

As another CPA you know your stuff and explain very well! Gave you a thumbs up!

[@HectorGarciaCPA]

Thanks

[@thomasenzmann6225]

Thank You very much! You helped me a lot.

[@thomito3]

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????

[@HectorGarciaCPA]

I hate when that happens… seem to be random

[@pakhtoonculture9783]

HOW CAN CATEGORIES INCOME IN QBO ACCOUNTANT ON 2018 VERSION

[@abuzarqazi8989]

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

[@carmanhaag9072]

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!

[@gregdalton3565]

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.

[@shatuts]

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?

[@alishajeziorski4167]

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?

[@HectorGarciaCPA]

Create a credit card account.. then you have o enter every charge from the credit card.

[@Phyl651]

Thanks for the videos! All have been very helpful!

[@HectorGarciaCPA]

You welcoem

[@ceciliasalamanca9102]

How you create those bubbles (as you said)? Or is there a video about that? I like your videos, I'm learning a lot.

[@HectorGarciaCPA]

Those are old.. don’t exist anymore

[@lukemckenzie7200]

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.

[@mshollywod]

Did you ever get an answer?

[@joalexstatham4124]

Super helpful Victor! I work in my iPad. How well does QB’s online work on the iPad?

[@RealMattCalvin]

Lol it's Hector ;)

[@donnalefneski5054]

How do you deal with the taxes from these invoices?

[@HectorGarciaCPA]

You can turn on the Sales Tax feature

[@AndieCv]

Great video, also now I'm craving La Granja lol

[@HectorGarciaCPA]

Ha ha... spend too much money there

[@erin5539]

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?

[@HectorGarciaCPA]

I don’t know which video covers that, but the concept is called “Matching”

[@timbaker6108]

I did not see where the Bank Feed did matching with what was already in the Register in your tutorial.

[@HectorGarciaCPA]

Tim Baker check the other bank feed videos

[@mindfulmoments17]

Hi hector ur a great help. Do u know why its showing me negative expense report on my balance sheet?

[@HectorGarciaCPA]

Balance sheet doesn’t have expenses, so not sure

[@wendyleekremer4648]

You are an excellent teacher. Thank you!

[@HectorGarciaCPA]

Thanks

[@leidyslemus]

THANKS A LOT VERY USEFULL

[@HectorGarciaCPA]

:)

[@michaelseabaugh601]

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(

[@HectorGarciaCPA]

QB Mac is way different, I have not created any content on Mac.

[@cristinamagpantay617]

Hi Hector, we're a church organizations, will Quickbooks be a good software to use?

[@woodbridllc2339]

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!!!

[@HectorGarciaCPA]

Woodbrid LLC a veces se bajan duplicadas.. si es el caso las tienes que borrar después.

[@mysolutiondesk]

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.

[@HectorGarciaCPA]

Not possible

[@robertthegeek]

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

[@HectorGarciaCPA]

No clue

[@jonhardin545]

How do I get the various bubble to "All Transactions""Sales Income""Expenses""Taxes and Licenses Expense"

[@HectorGarciaCPA]

They removed the bubbles, but everything else is the same.

[@chrisdickin2928]

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?

[@HectorGarciaCPA]

Chris Derby you can’t change the type

[@crist2082]

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 🤷🏽‍♀️

[@HectorGarciaCPA]

crist2082 you have to click on FIND match and select them both

[@noirxplorer3185]

Thanks for your help Hector.

[@HectorGarciaCPA]

NoirXplorer you welcome

[@paulohsmlima]

Great tips! Thank you!

[@HectorGarciaCPA]

You welcome

[@beatrizborquez6116]

wish I had seen your video years ago!!!

[@naokisonoda1367]

Another great video. Thank you!

[@agarraloquivenga1924]

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.

[@HectorGarciaCPA]

I don’t use CA version.

[@mostafaeldeeb4134]

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

[@HectorGarciaCPA]

Vendor Prepayment asset

[@shelleydaza1295]

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?

[@HectorGarciaCPA]

shelley daza no, the bubbles were removed

[@trixiestterror]

Hi Hector! What would your thoughts be on how to categorize earnest money that was refunded due to a cancelled real estate sale?

[@HectorGarciaCPA]

Other Income

[@Arnoldego]

What happen when the transactions from the bank don’t appear on the list ?

[@HectorGarciaCPA]

Enter it manually.

[@Arnoldego]

Hector Garcia CPA Do you have a video how to enter a manual transaction?

[@HectorGarciaCPA]

Arnold Gutiérrez no..

[@HectorGarciaCPA]

Arnold Gutiérrez no..

[@aselawimalaratne6454]

Thanks, that was really useful!

[@HectorGarciaCPA]

Awesome, you welcome

[@scottabrahamson3283]

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.

[@HectorGarciaCPA]

They do change... but note sure what you are talking about, I would need to see a screenshot

[@bodywise007]

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.

[@HectorGarciaCPA]

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.

[@bodywise007]

@@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 KZbin that specifically shows these screens. You are doing a great job.

[@HectorGarciaCPA]

Philip Miller i am not a big fan of the QB Desktop bank feeds. I am unlikely to spend any more time in them.

[@bodywise007]

@@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.

[@2001benjamin]

Could explain bank roll for money receipt which we have calculate vat for it

[@2010thezara]

Thank you very well explain

[@wendimcintosh9634]

Can you explain the split key option? Or do your u have a video on it?

[@HectorGarciaCPA]

its just to log two categories into one transaction

[@susyg7061]

Thanks for this tutorial, it was very helpful! Do you have tutorials on how to prepare sales tax reporting packets for small businesses?

[@HectorGarciaCPA]

Susy G no, don’t have that.

[@musicandeye]

Powerful stuff. in comparison to quickbooks desktop which most these options dont exist. Thanks for the lesson.

[@HectorGarciaCPA]

youtube watcher yeap

[@ew4096]

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.

[@brendailgen]

Very good videos, my qbo does not have the bubbles as in your video at 1:31? Any suggestions? Thank you

[@HectorGarciaCPA]

Brenda some have it some don’t..

[@phenixwars1]

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 🙌🏼

[@HectorGarciaCPA]

I am going to do an updated PayPal video in Feb 2020

[@phenixwars1]

@@HectorGarciaCPA Awesome! Thanks so much 👍🏼👍🏼

[@j0hnnyo3]

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..

[@HectorGarciaCPA]

Chart of Accounts

[@darrenjoseph2551]

Thanks alot Hector!

[@HectorGarciaCPA]

You welcome

[@boriskofman7852]

Thank you. Great tips.

[@HectorGarciaCPA]

You welcome

[@jccharly2000]

Hi Hector, I'm already in the 30 day trial, can still use you code for the discounted rate? Great vids btw!! Thx.

[@HectorGarciaCPA]

If you didn’t use the link on the beginning, no.

[@TheSavvyHeart]

Thank you, Hector!

[@HectorGarciaCPA]

you welcome

[@tfwal69]

Great videos. Do have anything for using QB online with PayPal?

[@HectorGarciaCPA]

Thomas Walsh yes.. is in my channel

[@KimMar1982]

How does one turn on the "bubbles" across the top?

[@HectorGarciaCPA]

Kim Ranger they don’t exist anymore.. :(

[@LeagueOfOurOwnServices]

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-

[@HectorGarciaCPA]

That’s for credit memos

[@HectorGarciaCPA]

Send them to the bank account the money went to or came from

[@LeagueOfOurOwnServices]

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.

[@gtonyrodriguez9984]

Hey Hector how are you? where can I get one of those hats?

[@HectorGarciaCPA]

I bought this at the QuickBooks Connect conference

[@gtonyrodriguez9984]

@@HectorGarciaCPA Thank you do you know if there is a website where I can buy it?

[@garryskwarek3105]

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

[@HectorGarciaCPA]

Garry Skwarek if the bank give you access to a QBO file, then you dont need a converter

[@garryskwarek3105]

@@HectorGarciaCPA my bank only let's me download 90 days, that's the problem

[@mpielage]

Thanks! Awesome video!

[@mikelahey172]

Can you change a category on a deposit?

[@HectorGarciaCPA]

Yes..

[@v.a.carter5406]

Thank you Hector.

[@HectorGarciaCPA]

You welcome

[@liezltorres4213]

where can you categorize bank transfer? thanks

[@HectorGarciaCPA]

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

[@liezltorres4213]

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

[@ozzieva]

Awesome! Thanks Hector

[@HectorGarciaCPA]

ozzieva you welcome

[@rodneystanfield685]

Thank you Hector!

[@HectorGarciaCPA]

You welcome

[@rachellebennett4020]

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

[@HectorGarciaCPA]

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

[@rachellebennett4020]

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?

[@HectorGarciaCPA]

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.

[@rachellebennett4020]

I thought you could download it as an excel file and then upload it somehow, that is what I thought you mentioned somewhere. :(

[@princesstolentino4015]

Hi Hector! I just wanna ask what to do when intuit charge us twice in a month?

[@HectorGarciaCPA]

Call them

[@princesstolentino4015]

@@HectorGarciaCPA thank you hector! You really a big help

[@Villaranfamily]

hello again hector :) just passing by... hehehe have a great day

[@jenicepye2997]

Can you use this with a PayPal?

[@HectorGarciaCPA]

Yes