QuickBooks Online Tutorial: Categorizing dowloaded transactions (2022)

QuickBooks 30-day free trial + 30% off for 12 months:



To take an in-depth Online Banking & Bank Reconciliations course with me go to:

Updated April 2021, Use Coupon BANKING50 before 3/31/2021 for 30% off the course.

Timelines:
00:00 Intro
02:02 Connect your bank, choose dates
05:07 Navigating Banking Screen
08:02 Categorize your first expense
20:11 Reviewing Automatic Rules
21:54 Categorize more expenses...
27:19 Split Transactions
28:34 Rules based on amounts
31:02 More categorization...
32:24 Transfers
34:26 Matching current transfers
36:10 Transaction grouping
44:30 Categorizing sales/income
47:50 Reviewing reports after categorizing
49:45 Missing Payee issues
51:39 Outro

[dianestone]

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]

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

[Knowledgeispower-cw]

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.

[tomfitz]

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

[shantryce]

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

[frankmartin-adirondackcampcab]

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

[johnfoushee]

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?

[sva-ed]

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

[lisamurray]

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

[lupitaortega]

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?

[md.alaminmridha]

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

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

[DuayneHoward]

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!

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

[krystanokamoto]

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.

[beverlybaumann]

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

[Mybits-wpig]

Excellent presentation Mr Garcia, very much appreciated!

[patriciaherrera]

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

[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

[patricianavarrovesga]

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.