QuickBooks Online Tutorial: Categorizing dowloaded transactions (2022)

Поділитися
Вставка
  • Опубліковано 28 лис 2024

КОМЕНТАРІ • 183

  • @dianestone9064
    @dianestone9064 3 роки тому +19

    Love your videos. Even though I took a college course many years ago in qb desktop. It helps watching your videos as qb is constantly changing and I am a self-employed bookkeeper. It is reassuring to know that I am doing things correctly. Thank you!

  • @AnythingWetPools
    @AnythingWetPools 3 роки тому +4

    Hector, you have some of the best videos on Quickbooks!

  • @tomfitz
    @tomfitz 3 роки тому +6

    Your videos are so helpful! Slowly trying to get my head around Quickbooks and your videos make it much easier.

  • @Knowledgeispower-c5w
    @Knowledgeispower-c5w Місяць тому

    I am new to QBO. This is a great video. Well explained. You are a great teacher. I will be watching the rest of the videos. Thank you for selflessly sharing your knowledge with us.

  • @DuayneHoward
    @DuayneHoward 3 роки тому +1

    Reconciling the bank accounts, I get. But the biggest caveat I left with was actually understanding the difference between the QBO bank balance and the bank statement balance! I finally get it! Thanks, Hector!

  • @shantryce375
    @shantryce375 3 роки тому +6

    Great video as always! I have learned so much from you in the last few months.You have been a blessing to my new small business!!!!

  • @My2bits-wp7ig
    @My2bits-wp7ig 9 днів тому

    Excellent presentation Mr Garcia, very much appreciated!

  • @jessicagarcia3331
    @jessicagarcia3331 2 роки тому +1

    Hector Garcia is my favorite youtuber!

  • @krystanokamoto5018
    @krystanokamoto5018 Рік тому +1

    so helpful!! 😁 I love those tips you have to make your categorizing faster and more efficient. Ive been categorizing one by one this entire time.

  • @angelacastillo8638
    @angelacastillo8638 2 роки тому +1

    I absolutely feel so confident after watching your videos! I will be taken your advance course very soon.

  • @lupitaortega74
    @lupitaortega74 2 роки тому

    What if my husband, who has a landscaping company, has regular expenses like at Home Depot for equipment but then an actual expense to a vendor for plants. Why would he name the payee as a vendor?

  • @SherriVardanega
    @SherriVardanega Рік тому +1

    Making me more confident

  • @robingwynne8111
    @robingwynne8111 3 роки тому +5

    Amazingly helpful, Hector! I'm trying to reenter the workforce and my QB knowledge goes back to desktop, so this is a much needed refresher. I already had one embarrassing interview/skills assessment before discovering your videos. (Just a Note--Probably not important since it's not your actual QBO account, but FYI: in the video you entered State Farm as a payee and QB categorized the Type as a Customer instead of a Vendor. You were entering quickly and talking so you didn't see it or change it.)

  • @patriciaherrera4680
    @patriciaherrera4680 Рік тому

    how do we apply payment transaction on paybills, example insurance payment ?

  • @Bravomaster1
    @Bravomaster1 2 роки тому

    Pls how can I categorize a return payment to business account, after categorized it as expenses months ago?

  • @sunshinecambel4176
    @sunshinecambel4176 Рік тому

    Your video is very helpful, but I still need some one to help with setup in QuickBooks, Can you referrer a CPC or some one to help?

  • @fabianmwilson2772
    @fabianmwilson2772 3 роки тому +3

    you were exceptional, the effort you put in is emensly appreciated! the clarity and explanations are very helpful. thanks very much

  • @md.alaminmridha6098
    @md.alaminmridha6098 8 місяців тому

    Can you provide the categorizing process link of the Intuit transactions (invoice matching)?

  • @sva-e7d
    @sva-e7d Рік тому +1

    one Credit card account is connected Suppose for 01/01/2023 can we change it to 12/22/2022?

  • @GoddessGirl-f5n
    @GoddessGirl-f5n 3 місяці тому

    So you have to manually categorize your transactions?

  • @patriciamarzari
    @patriciamarzari Рік тому

    Hi Hector Thank you for all your helpfull videos, I feel confident when I waTched the videos, but when I go to my Qb everything look different. Let me tell you I am amateur in this, trying to help. Here is my question, many time I see payments regrouping under only one transaction, and the number dosn't match with whatever custumer pay. and make feel lose. Can you please guide me how to look on this.Thanks in advance.

  • @dtsai
    @dtsai 3 роки тому

    Do you have any Quick Book tips for people that have multiple LLCs and S Corps? It would be nice to get a video for this.

  • @michellefLA
    @michellefLA Рік тому

    Will you make a lecture about financed car purchase? TIA!

  • @johnfoushee3861
    @johnfoushee3861 Рік тому

    I have my main checking account connected, but when I go to banking/transactions, it does not give me the option to add another. It only shows the checking account transactions. How do I add my cc account?

    • @HectorGarciaCPA
      @HectorGarciaCPA  Рік тому

      There is a section for “Manage Connections” where you can do that

  • @lisamurray4073
    @lisamurray4073 3 роки тому

    Your link above takes me to QBO not your site. Also, looking for the link to the 'matching' video you mentioned at 11:00 min you would post a link to. Thanks

  • @CoalitionCPR
    @CoalitionCPR 8 місяців тому

    Nice clear explanations. And you repeat enough to cement the methods into my head. Thanks Hector.

  • @patricianavarrovesga9278
    @patricianavarrovesga9278 3 роки тому +1

    hey hector hope you doing well ! how do you categorize checks ? ... I make checks payable to my gold vendors, each check has a specific #, since january 2021 to present, QB uploaded more than 100 checks, I am having a really hard time categorizing them, because I can't create a rule on them .... all checks are for different gold vendors .... is it better to pay with debit card in the future so the transaction shows with the vendor name on my checking and I can create rules ? ... thanks again for your amazing job. God bless you man.

  • @beverlybaumann9705
    @beverlybaumann9705 5 місяців тому

    So after this process why aren't they showing up in my reconcile screen?

    • @HectorGarciaCPA
      @HectorGarciaCPA  5 місяців тому

      They should be showing.. not sure what you are looking at..

  • @glendajoytan2484
    @glendajoytan2484 Місяць тому

    thank you . ilove the way you teach us.

  • @neldasolis419
    @neldasolis419 3 роки тому +1

    Thank you so much for your video. I learned a lot. I will start categorizing by vendor now.

  • @gulshanthakur4849
    @gulshanthakur4849 3 роки тому

    How we can check nature of business

  • @artparma2
    @artparma2 Рік тому

    i cant even find transactions on the left

  • @celestelewis2131
    @celestelewis2131 9 місяців тому

    Hi Hector. I am enjoying your videos; very informative. I have a question about categorizing. Your screen has "Confirm" and my screen has "Add". Are they the same? Thank you.

  • @crose4267
    @crose4267 2 місяці тому

    I signed for the membership for your courses. Is there a channel that I should sign into?

    • @HectorGarciaCPA
      @HectorGarciaCPA  2 місяці тому

      We release here in UA-cam early videos before they get released ro the public

  • @michellefLA
    @michellefLA Рік тому

    Thanks to your lectures, I am getting used to QBO interface from desktop 2018. Can you please show some reports bookkeepers run every quatre and what to do at the end of the year? TIA!

    • @HectorGarciaCPA
      @HectorGarciaCPA  Рік тому

      I have other videos focused on reports already in the channel, just search

  • @awalshfamily
    @awalshfamily 3 роки тому

    Once you hit confirm or "add" on my version, where does it go and can it be changed?

  • @rkrehal9329
    @rkrehal9329 Рік тому

    Hi Hector, I am a new QBO student. And would appreacite your help. When I categorize transactions, I get a tab for Tax. But I don't see that on your screen. Can you please explain why that is? What is the purpose of the Tax tab on the transaction screen?

    • @HectorGarciaCPA
      @HectorGarciaCPA  Рік тому

      That’s outside of the US.. that’s different. i dont know

  • @michellefLA
    @michellefLA Рік тому

    If I do a bookkeeping job for a partnership, where do I record partner's basis? TIA!

  • @debbiewells7603
    @debbiewells7603 2 роки тому

    What if your company doesn't charge sales tax? Is there anything in QBO that we have to do?

  • @frankmartin-adirondackcampcab
    @frankmartin-adirondackcampcab 5 місяців тому

    Hector
    Ty greatly.
    When writing checks in desktop I would put in full amount and then go to split below. I could put in first split amount and enter and it would go to the next split line and automatically show balance of my total check amount in entered...and so on. I don't see this in qbo?
    Can you help.
    Ty

  • @jannieli3598
    @jannieli3598 2 роки тому

    how can we get the discounted price please? great video, thank you!

    • @HectorGarciaCPA
      @HectorGarciaCPA  2 роки тому

      Use hectorgarcia.com/qb for 30% off a new account

  • @kathrynhughes3593
    @kathrynhughes3593 3 роки тому

    Hector, you are WONDERFUL!!

  • @funnyfornomoney9025
    @funnyfornomoney9025 2 роки тому

    I did all of these steps and I have an account without paying anything , so my question is , do I need to pay to to get the training and take the exam?

    • @HectorGarciaCPA
      @HectorGarciaCPA  2 роки тому

      My videos are no focused on any exam… they are practical advice for QB users.

  • @yachikajindal6939
    @yachikajindal6939 2 роки тому

    I have a question if we are not using the employee payroll in quickbooks online so how we can connect the employee salary with the project

    • @HectorGarciaCPA
      @HectorGarciaCPA  2 роки тому

      You would need to do it manully with a journal entry

  • @margaesclamado1371
    @margaesclamado1371 Місяць тому

    I love the videos, I am new to QB.. I found it interesting 😊

  • @JOETERRANY
    @JOETERRANY 2 роки тому

    Just started using quick books online and I don’t see a clear option for sales the program calls it “services” is this correct? I was originally using self employed and the terms were way easier

    • @HectorGarciaCPA
      @HectorGarciaCPA  2 роки тому

      You can create a “Sales” income account if you want

  • @wingatesouthport1118
    @wingatesouthport1118 3 роки тому

    Hello Mr Garcia, Thank you very much for all you do. I have some bookkeeping background but it was long time ago. Do you have any clip that shows how to start with opening balances such as Receivables, Payables, Partners Distribution etc. I just want to know how to enter those transactions when you start a new set of books. Thank you.

  • @johnfoushee3861
    @johnfoushee3861 Рік тому

    I did not see the option to assign a class which I need to do on all cost of good sold. Does this depend on the subscription service you are paying for? Thanks you so much for this video!!!

  • @MrAnjuubaba
    @MrAnjuubaba Місяць тому

    Hi, What about liabilities or accrued expenses.
    Can we use transfer, because journal entry will be same even if I create journal or record payment to liability through imported bank transaction.
    but is it good practice

    • @HectorGarciaCPA
      @HectorGarciaCPA  Місяць тому +1

      Transfer works for all balance sheet accounts

    • @MrAnjuubaba
      @MrAnjuubaba Місяць тому

      @@HectorGarciaCPA I used the same and this looked more professional instead of recording journals for each bank transaction. Thanks

  • @mrose4435
    @mrose4435 2 роки тому

    Great video. Which quick book version would apply to non profit? Advance seems close. Thanks so much!

  • @andreaaponte3529
    @andreaaponte3529 3 роки тому

    What happen if the transaction has tax, Can I manually input the tax code?

    • @HectorGarciaCPA
      @HectorGarciaCPA  3 роки тому

      We dont deal with categorizing tax on expenses in the US

  • @lorrainezea7988
    @lorrainezea7988 3 роки тому

    Does anyone know how to categorize the transactions from Roth IRA and Robinhood on Quickbooks?

  • @SmithyProductions
    @SmithyProductions 2 роки тому

    How do you categorize personal expenses paid with business, or business expenses paid with personal credit card?

    • @HectorGarciaCPA
      @HectorGarciaCPA  2 роки тому

      There is a video in my channel focused on that very thing, just search for it

    • @SmithyProductions
      @SmithyProductions 2 роки тому

      @@HectorGarciaCPA definitely will take a look. Thanks!

  • @carylarrinaga678
    @carylarrinaga678 3 роки тому

    What if when downloading the transactions it doesn't give you the option downloading per card holder? it downloads all transactions of all cardholders together.

    • @HectorGarciaCPA
      @HectorGarciaCPA  3 роки тому

      Some cards do, other do not…. You can’t control it

  • @ashleyvargas3488
    @ashleyvargas3488 2 роки тому

    Hello, do you or anyone know how to categorize deposits from customers and partnership distribution?

  • @rubina4411
    @rubina4411 Рік тому

    QB online is not showing the option of Journal entry, how can I active it?

    • @HectorGarciaCPA
      @HectorGarciaCPA  9 місяців тому

      Still having the same issue?

    • @rubina4411
      @rubina4411 9 місяців тому

      @@HectorGarciaCPA Yes

    • @rubina4411
      @rubina4411 9 місяців тому

      @@HectorGarciaCPA Sorry general entry I got it.
      Bank transactions are not sync with q

  • @Moose36127
    @Moose36127 3 роки тому

    Can you create subcategories under specific categories? IE. under a home for investment, can you make a sub category for landscaping, electronics, etc?

  • @careerpathacademyx
    @careerpathacademyx 2 роки тому

    I own 3 businesses, which version of quickbooks could I use to manage multiple businesses, am I better off with the desktop version or online? I have a real estate school and 2 brokerages and may be starting another business in the future that is totally unrelated type of business.

    • @HectorGarciaCPA
      @HectorGarciaCPA  2 роки тому

      Desktop will be less costly as there is no limit how many companies you can run. With QB Online it will be one subscription per company

  • @stephenmauro1770
    @stephenmauro1770 Рік тому

    is THE advanced lesson on credit cards an transfers available to me or do I need to pay?

  • @erikamorales3519
    @erikamorales3519 2 роки тому

    How would you categorize net payroll transactions that are being imported from bank?

    • @HectorGarciaCPA
      @HectorGarciaCPA  2 роки тому

      Thats a complex question, take a look at the video i have on “ADP” it should provide some guidance

    • @erikamorales7305
      @erikamorales7305 2 роки тому

      @@HectorGarciaCPA would that video still pertain if we’re using quickbooks payroll?

  • @josezavala6657
    @josezavala6657 3 роки тому +1

    Hi Hector! How do i categorize bank reverse fees? Its not income so do I use CREDIT on bank fees? How should I do this ? THANK YOU

  • @dustinwalker1099
    @dustinwalker1099 3 роки тому +1

    Hector, thank you so much for making these videos.

  • @ubstampin
    @ubstampin 3 роки тому

    Thank you for your video. I learned a lot. I'm starting to use QB with our new company and I had to review using QB. Thank you again.

  • @lorenacantua8004
    @lorenacantua8004 3 роки тому

    Great video! i just started using quickbooks online and your videos have helped me a lot! Do have a video for bank reconciliations on qb?

  • @fitzsixwellness
    @fitzsixwellness 3 роки тому

    that was great thanks.. how can someone chart a credit card payment paid with owner own cash to a credit card ?

    • @HectorGarciaCPA
      @HectorGarciaCPA  3 роки тому

      The payment book it to shareholder distributions

  • @temirtaragay8932
    @temirtaragay8932 3 роки тому

    Thank you for clear video quality and humble attitude!

  • @fatimaantonio8315
    @fatimaantonio8315 2 роки тому

    How to record an EDD California check in QBO?

  • @muhammadamjad8009
    @muhammadamjad8009 3 роки тому

    Greeting Hector,
    Thanks for the video. Please share the Credit Card banking categorization video link. The link you provide does no work. Thanks in advance.

    • @HectorGarciaCPA
      @HectorGarciaCPA  3 роки тому

      its in the description.. the link DOES work, I just tested it.

  • @katelynlenhart2801
    @katelynlenhart2801 3 роки тому

    If I had a customer give me money for supplies, then purchased supplies with my work account, how would I categorize the receipt for that so it doesn’t mess with profit loss ratio?

    • @HectorGarciaCPA
      @HectorGarciaCPA  3 роки тому

      Use the same category for the money coming in as the one coming out.. it should net to zero

  • @eiggy7126
    @eiggy7126 3 роки тому

    Hector, the link for the "online banking course" appears to be broken.

    • @HectorGarciaCPA
      @HectorGarciaCPA  3 роки тому

      I just tried it... it works, not sure what issue are you having

  • @rachelbentley8641
    @rachelbentley8641 3 роки тому

    @Hector Garcia CPA I see that you're adding merchants' names into the payee column for a cc. We sometimes issue a check to a cc merchant. In the case that we have to 1099 that payee, how do I easily separate out the payments that were made via cc (since the cc company is responsible for the reporting of those payments)?

    • @robingwynne8111
      @robingwynne8111 3 роки тому

      I could be wrong but I think you would create the credit card payee as a Vendor and the 1099 eligible payee created as a Contractor for those direct payments, two different payees even if it's the same entity, perhaps differentiated within the name to avoid confusion.

  • @610coffee
    @610coffee 2 роки тому

    Good afternoon Hector. How would you categorize an "Early Pay Discount" in credit card transactions? Thank you sir.

    • @HectorGarciaCPA
      @HectorGarciaCPA  2 роки тому

      you got the discount on a vendor bill? or your customer got the discount on your invoice?

    • @610coffee
      @610coffee 2 роки тому

      @@HectorGarciaCPA we get an early pay discount from a credit card vendor if we pay by a certain date. It shows up in that credit card transactions in qbo as a positive number. Thank you for your quick response!

    • @HectorGarciaCPA
      @HectorGarciaCPA  2 роки тому +1

      @@610coffee other income: Credit Card Rewards

    • @610coffee
      @610coffee 2 роки тому

      @@HectorGarciaCPA thank you sir. Really appreciate your content. Has been most helpful!

  • @angelhodgdon1127
    @angelhodgdon1127 3 роки тому

    Hello Hector,
    Another awesome video jampacked full of helpful information. Thanks so much for all your videos.
    I just had one question. At the 32:24 Transfers section, you mentioned changing the "Transfer Account" to the 8200 account because that's the account being transferred too... However, I noticed that in the Description column the actual account number there is 8208. Is that ok that they don't "Match" exactly? Am I being too particular? Sorry, I just wanted to make sure if I have to match the account exactly or if it's just an internal / company numbering system that doesn't matter as long as it's within the 8200's range?
    Thanks again for all your hard work. It's greatly appreciated.

    • @peterb.snyderman8191
      @peterb.snyderman8191 3 роки тому

      hi angel, my GUESS: i think the 8208 account was must mis-labelled as 8200 when the account was named. you can name the accounts anything you want ... the 8200 isn't a number in this case, it's essentially a "text description." the 8208 number was in the bank detail of the actual transaction, so that's probably the correct four digits. GREAT eye!! (p.s. i hope i'm right ... hector will chime in at some point :-)

  • @rosepa557
    @rosepa557 3 роки тому

    hi the 50% off for one year can i use that in canada as well? Im about to sign up, but want to make sure getting pricing in CDN dollars thanks

  • @publicprofile1
    @publicprofile1 3 роки тому

    Can QBO categorize expenses as items? I am a builder and most of my transactions are items (Expense / Item tab). THANKS!

    • @HectorGarciaCPA
      @HectorGarciaCPA  3 роки тому

      It can’t.

    • @publicprofile1
      @publicprofile1 3 роки тому

      @@HectorGarciaCPA Thanks! Its ridiculous they haven't added that. Items are so important for reports.

  • @jmoralesg14
    @jmoralesg14 3 роки тому

    Hi Hector, Do you offer Quickbooks Desktop course online?

  • @fritzmann210
    @fritzmann210 3 роки тому

    Hi sir, is your quickbooks applicable to the Philippines setting?

  • @SandyPhillips-p6i
    @SandyPhillips-p6i 8 місяців тому

    This video was so helpful. Thank you!

  • @angelarizzo8924
    @angelarizzo8924 2 роки тому

    Awesome video Hector. Thank you so much!! I subscribed and will continue to watch and follow you.

  • @etechbpo4285
    @etechbpo4285 3 роки тому

    Hector, thanks for your helpful video

  • @nightrider6289
    @nightrider6289 Рік тому +1

    Making Rules 28:53

  • @raquelgarcia7261
    @raquelgarcia7261 3 роки тому

    Hi Hector. Great video!! I have a question .How to categorize the transfer transaction that owner did . is business or personal? Also he wrote checks and cashed,then spent cash from those checks on personal items and material expenses for business.

    • @HectorGarciaCPA
      @HectorGarciaCPA  3 роки тому

      There is another video that covers that with great detail.

    • @raquelgarcia7261
      @raquelgarcia7261 3 роки тому

      What is the name of that video?
      Thanks

    • @HectorGarciaCPA
      @HectorGarciaCPA  3 роки тому

      @@raquelgarcia7261 ua-cam.com/video/kbwX5natX9c/v-deo.html

  • @kathy7095
    @kathy7095 Рік тому

    42:50 oh no Hector, you misspelled tax!

  • @helalahmed7428
    @helalahmed7428 Рік тому

    Love your Video!!

  • @hassanchalf3901
    @hassanchalf3901 3 роки тому

    Hi hector
    Thanks for the video
    Is there a way QuickBooks can help extract attachments from email to QuickBooks ? Thanks

    • @HectorGarciaCPA
      @HectorGarciaCPA  3 роки тому +1

      No

    • @hassanchalf3901
      @hassanchalf3901 3 роки тому

      @@HectorGarciaCPA thanks
      I know u r quite good with excel , do u know if I can assign vat automatically to my suppliers , so I don’t have to do it all the time ?? Thank you so much . U made me decide to use QuickBooks and I am using it now .

  • @maryerdman6562
    @maryerdman6562 2 роки тому

    GREAT TUTORIAL ! THANK YOU

  • @annal9443
    @annal9443 3 роки тому

    Hi Hector, thank you for this but I still have an issue with the uploading of my CC transactions. Can I e-mail you directly and get a consulting? How much it will cost? Thank you in advance!

    • @HectorGarciaCPA
      @HectorGarciaCPA  3 роки тому

      Emailed me first so I can check if is something o can answer via email

    • @annal9443
      @annal9443 3 роки тому

      @@HectorGarciaCPA Sure, what is your e-mail address?

  • @kulokoytricksph2928
    @kulokoytricksph2928 3 роки тому

    Thank you sooo much ❤️❤️❤️ very clear tutorial

  • @tariqmanzoor3067
    @tariqmanzoor3067 3 роки тому

    891th person to watch
    All the way from Himalayas ❤️

  • @hilaryjl1
    @hilaryjl1 3 роки тому

    Thank you for another great video! I am also trying to find your in-depth course and the link takes me to a page that says "Something is Wrong Here" error 404.

    • @HectorGarciaCPA
      @HectorGarciaCPA  3 роки тому

      I just tested it.. didn’t get an error.. not sure what happened with you. Are you clicking or copy/pasting?

    • @hilaryjl1
      @hilaryjl1 3 роки тому

      @@HectorGarciaCPA I was clicking. I tried copy/paste and it worked! Thanks for the reply.

  • @usaalltheway8127
    @usaalltheway8127 3 роки тому

    Great Video, helped a lot!

  • @lancejacob357
    @lancejacob357 10 місяців тому

    This is very helpful

  • @saifullahzafari7038
    @saifullahzafari7038 Рік тому

    Lovely video

  • @Malik-ix2kx
    @Malik-ix2kx 2 роки тому

    Good job👍🏻

  • @IlzamaraSales-jn2kp
    @IlzamaraSales-jn2kp 10 місяців тому

    Thanks!!

  • @joeanntorricer835
    @joeanntorricer835 3 роки тому

    Great Video. 💕 thank you so much for your effort. Great help. God bless 🙏

  • @pedrofaria9943
    @pedrofaria9943 2 роки тому +1

    Excelent

  • @caseohbigclips
    @caseohbigclips 2 роки тому

    Sa

  • @wrapdisshitup
    @wrapdisshitup 3 роки тому

    im getting very dizzy and distracted by the constant zoom-ins on the mouse pointer