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

[@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 ;)

[@utleyadmin9679]

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

[@HectorGarciaCPA]

Amen, thanks!

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

[@carolinepartridge4088]

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

[@annthans2728]

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

[@MyGarden61]

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

[@lasermedia3256]

best quickbooks video on youtube, thanks a bunch Hector!

[@HectorGarciaCPA]

Laser Media thanks

[@rosanneturkington8622]

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

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

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

[@kyerefrederick627]

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

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

[@davidwalk7828]

Hector, you're a legend.

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

[@jewelgoss8005]

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

[@michellecoon1126]

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

[@StraightOffTheCouch]

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

[@HectorGarciaCPA]

Thanks

[@shaileshpatel3607]

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

[@jafarsharif3366]

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

[@HectorGarciaCPA]

Jafar Sharif awesome

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

[@frankbuescher7615]

Good job - clear explanation

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

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

[@domingoandresgomezfirpo5076]

Excellent Video, Hector . Thank you.

[@HectorGarciaCPA]

Thanks

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

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

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

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

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

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

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

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

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

[@traceyinglimo428]

Loved that tutorial! Learned a few things! Thanks!

[@HectorGarciaCPA]

Awesome

[@joalexstatham4124]

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

[@RealMattCalvin]

Lol it's Hector ;)

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

[@joanndelatorre336]

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

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

[@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”

[@thomasenzmann6225]

Thank You very much! You helped me a lot.

[@RandiJamesInc]

Great content! Thank you!

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

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

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

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

[@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 👍🏼👍🏼

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

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

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

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

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

[@cristinamagpantay617]

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

[@pakhtoonculture9783]

HOW CAN CATEGORIES INCOME IN QBO ACCOUNTANT ON 2018 VERSION

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

[@donnalefneski5054]

How do you deal with the taxes from these invoices?

[@HectorGarciaCPA]

You can turn on the Sales Tax feature

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

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

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

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

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

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

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

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

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

[@Phyl651]

Thanks for the videos! All have been very helpful!

[@HectorGarciaCPA]

You welcoem

[@cristinapresquito1644]

God bless for information we learned

[@paulohsmlima]

Great tips! Thank you!

[@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. :(

[@tfwal69]

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

[@HectorGarciaCPA]

Thomas Walsh yes.. is in my channel

[@AndieCv]

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

[@HectorGarciaCPA]

Ha ha... spend too much money there

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

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

[@darrenjoseph2551]

Thanks alot Hector!

[@HectorGarciaCPA]

You welcome

[@dailypaywithWendyK]

You are an excellent teacher. Thank you!

[@HectorGarciaCPA]

Thanks

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

[@beatrizborquez6116]

wish I had seen your video years ago!!!

[@naokisonoda1367]

Another great video. Thank you!

[@KimMar1982]

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

[@HectorGarciaCPA]

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

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

[@leidyslemus]

THANKS A LOT VERY USEFULL

[@HectorGarciaCPA]

:)

[@mikelahey172]

Can you change a category on a deposit?

[@HectorGarciaCPA]

Yes..

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

[@aselawimalaratne6454]

Thanks, that was really useful!

[@HectorGarciaCPA]

Awesome, you welcome

[@MrCheeks850]

Where can I find someone like you local? in Destin FL?

[@HectorGarciaCPA]

Chinh Cao search for “find a ProAdvisor”

[@boriskofman7852]

Thank you. Great tips.

[@HectorGarciaCPA]

You welcome

[@2010thezara]

Thank you very well explain

[@noirxplorer3185]

Thanks for your help Hector.

[@HectorGarciaCPA]

NoirXplorer you welcome

[@jenicepye2997]

Can you use this with a PayPal?

[@HectorGarciaCPA]

Yes

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

[@ALEXA7951]

MR. GARCIA, i AM INTESTED IN YOUR TRAINING, but my english its no good, somebody speak spanish in your Team?

[@HectorGarciaCPA]

Si claro, estamos en miami.. llama al 954-414-1524

[@RealMattCalvin]

They are Spanish speakers

[@ozzieva]

Awesome! Thanks Hector

[@HectorGarciaCPA]

ozzieva you welcome

[@cindymoolekamp6312]

Great job Hector

[@HectorGarciaCPA]

Thanks

[@mpielage]

Thanks! Awesome video!

[@v.a.carter5406]

Thank you Hector.

[@HectorGarciaCPA]

You welcome

[@rodneystanfield685]

Thank you Hector!

[@HectorGarciaCPA]

You welcome