QuickBooks Desktop Tutorial: Reports Basics & Financial Statement Analysis

QuickBooks 30-day free trial + 30% off for 12 months:
quickbooks.intuit.com/partner...
Take my 3-day virtual course on QuickBooks Desktop and Job Costing: hectorgarcia.teachable.com/p/... - Use Coupon code HECTOR95 to pay $95 instead of $149!
00:00:00 Intro
00:05:00 Profit & Loss
00:10:00 Balance Sheet
00:15:00 Comparatives
00:30:00 Other Reports (i.e. A/R Aging)
00:45:00 Outro
If you are in Miami, you can take our live course as well, more info: qbkaccounting.com/
Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary from $395 to $1,000) for first consultation depending on length and consultant required. E-mail Hector your questions [e-mail]

[@HectorGarciaCPA]

Domain name changed! qbkaccounting.com

[@abdihananjama8614]

Thank you so much Prof. Hector. Definitely, that was an Informative Video.

[@janinerepic5858]

I am so excited that I was able to watch such an educational video. I have been an accountant for several years, however to to health issues I have been out of the workforce for a while. I have an interview with a large CPA firm today and I was feeling really rusty until I watched this video and was able to refresh my memory. GREAT JOB HECTOR!!!!!

[@HectorGarciaCPA]

Janine Repic awesome.

[@timothypotapenko5046]

Thank-you for these videos. Starting from 0, these are helping me learn fast!

[@Mrspaige81]

Seriously, you are such a blessing to my life! This is wonderful content and you made it so easy to understand. 👏🏽👏🏽👏🏽

[@HectorGarciaCPA]

Thanks.

[@garyjclancy]

That was an amazing video! Very well done. Thank you!

[@HectorGarciaCPA]

Gary Clancy you welcome

[@aprilsmith4113]

What a great video. You are very good at explaining and giving an understanding of how this all works! Thank you!

[@HectorGarciaCPA]

Thanks.. glad you liked it

[@jorgefraga5045]

Hector this is a great video as always you are the best!. learning so much with your videos

[@anaramirez9448]

Fantastic video, really appreciate the time you put into making these. BTW, does any one know which video explains step by step on how to add late fees or monthly interest charge to past due invoices,and how it would show on Statements? Thank you for sharing such valuable information. 🙏

[@emilywu7517]

Well explained! Thank you!

[@glennscanlan3397]

Very well explained. Really learned a lot. Thank you, keep putting out great videos!

[@HectorGarciaCPA]

Awesome, you saw the whole thing?

[@WalkingAfterMidnightRadio]

I did. We didn't have a class for Quick Books in my Accounting diploma program. Most employers look for knowledge of this though.

[@Phoenixspin]

This guy is awesome. When I grow up, I want to be like him.

[@mariafernandasanchez6459]

Excellent video. Thank you

[@leealanbaker7654]

Thank you the videos are very informative

[@louietoltolvlog9699]

Thank you. I took QB with other school online and sadly it was a little learning. Terrible but your is so useful. Thank you so much 😊

[@HectorGarciaCPA]

Glad they are useful

[@tee1ibrahim112]

Hello Garcia, question. If I needed to to figured out my revenue dropped comparing 2019 and 2020 quarter by quarter in other to see which quarter has the lowest drop. How is the way to go about this? Thank you in advance,

[@kathyho3985]

Hoila! Can you kindly post a video on how to fix the common problems found using QB? Muchas gracias!

[@timeisgold7793]

Glad I found this

[@HectorGarciaCPA]

Great!

[@enzodelfino4338]

I have a question..at 41:42 you show about double clicking and showing the account list..but my system isn't showing it. How do i fix that?

[@joanelizabeth1766]

Very helpful, thank you!

[@HectorGarciaCPA]

You welcome

[@AQOON544]

Hi teachers thanks for your help. I have one question and i need your help. I closed my year end i got retained earnings 16500. Also i have net ordinary income -3750. I don't know where this mines from and how to solve it. Thanks

[@zzzlife]

Fast, comprehensive, VERY EDUCATIONAL. Hector is doing an excellent job in this presentation . If you have basic knowledge of accounting this video will make it very easy for you to learn Quickbooks. I very much appreciate your presentation Hector, thank you so much 🙏🙏🙏

[@HectorGarciaCPA]

Thanks! Glad you find it helpful

[@EdenLipao]

newbie here on Quickbook...really wanted to learn

[@nadiaaljaddo2582]

thank you for this video

[@debbie083]

Love the content

[@michellewithrow1149]

Great content and easy to follow along

[@HectorGarciaCPA]

:)

[@hassaneidsaied]

Hector, you are the best in the west!!!

[@HectorGarciaCPA]

He he, thanks.

[@mohammadwalid7751]

Thank you.

[@davgar4241]

you made it very easy to understand

[@HectorGarciaCPA]

:)

[@gracedemi9247]

Thanks for this very helpful video. new subs here

[@canadassweetsour7671]

Loved it

[@HectorGarciaCPA]

:)

[@deborahrao4339]

How much is a quickbooks desktop intermediate course?

[@officesycoc4036]

I have learned so much from watching your videos and plan on taking the virtual course. I do have a question about reports though. When I created the new budget for this year and ran the reports, the reports don't have the changes on them. Am I missing a step?

[@HectorGarciaCPA]

I would need to see it.. is hard to diagnose from here.

[@louietoltolvlog9699]

It’s so wonderful lessons ever. May I ask a question? 1. If owner asks about financial reports, do I just need to give him a P & L report and Balance sheet? Is it only two reports? 2. What about trial balance, general ledger? Is it just for me to review or should I think of financial report? 3. When do I need to make a journal entry and why do we need to do? 4. If owner just purchased a new car for his work, should I put it’s his asset and should it be recorded depreciated expense? 5. If company bought a new computer $1000 for me with a credit card, should I just enter a credit card for purchase only or should I record a new computer purchase for an asset and depreciate ?

[@HectorGarciaCPA]

Thats 5 questions….

[@lenaarmel5763]

Hello Hector, I enjoy your tutorials. I have Quickbooks desktop for Windows. I am looking for a Detailed Cash Flow report for a calendar year: Account, sub-account, date, amount. We want to load this data into an Excel spreadsheet to do our analysis. Transaction report just does not do it for us, most of transactions are reported twice and it shows sub-accounts only, not an account:sub-account. Cash Flow report does not give details unless I drill in, so it does not work for Excel export. Grateful for your help.

[@HectorGarciaCPA]

The term “cash flow report” doesn’t mean anything… which means that it could be anything really. So your question here really might be about how to create a custom report with certain parameters…. If you send me a sample spreadsheet via email, i can tell you which app you might need to add to get the data you want. Its possible that QB cannot do it natively.

[@jhonatanorabadillo5958]

Great video! We're working on a reporting project with Power BI and generate some dashboards, for example, Profit & Loss and Balance from QuickBooks Desktop Data. So, Could you give us advice to achieve it? thanks!

[@HectorGarciaCPA]

I am not a PowerBi expert

[@parvanehtahmasbi1019]

Hello and thanks a lot, one question Not regarding the QuickBooks, can you please tell me what software did you use to make this video? this shows you and the training window at the same time which is amazing, I'd appreciate if you would answer me. Thanks.

[@HectorGarciaCPA]

I use Screenflow on Mac

[@parvanehtahmasbi1019]

@@HectorGarciaCPA Thank you :)

[@peterz3729]

is there a way to graph in QB or do you have to export to Excel?

[@HectorGarciaCPA]

You have to export.

[@frankayala3950]

Hi Hector, I'm wondering if you know how to change the current operating date, month/date/year ? and have it reflect from that period going forward? My sample date reads 12/32/2031.

[@HectorGarciaCPA]

Cant follow

[@megavitai]

Hola Hector. Me gustaria saber si aun tiene disponible el curso online de QB Desktop por 3 dias??? Estoy interesada. Gracias

[@HectorGarciaCPA]

El curso que tengo ahora es en Miami 2 dias

[@sulemanahmed3866]

I have created customer jobs in quickbooks. Now I want to see how much cost I have spent on the specific customer job. Where I can create it please need help...

[@HectorGarciaCPA]

Profit and loss by customer:job

[@sulemanahmed3866]

thank u very much.. please one more query if we create job related expense account than will we also debit inventory items in this job related expense account???

[@debbiewells7603]

Hi Hector, Can I undo a void in a CC reconcile?

[@HectorGarciaCPA]

Cant undo, but you can edit a voided transaction

[@Darioq57]

How do you zoom when the Z is showing over transactions?

[@HectorGarciaCPA]

Right click on the report to change the font size.

[@gaurivichare665]

I have trial balance in excel how to import it in Quickbooks desktop

[@HectorGarciaCPA]

You would need a 3rd party tool like Transaction Pro Importer

[@naveen9189]

How to take receipts and payments report?

[@HectorGarciaCPA]

Transaction detail report, transaction type: Payments and Deposits

[@louietoltolvlog9699]

Do you have any plan to teach QB online in discord?

[@HectorGarciaCPA]

No

[@doykme]

Hi Hector Do you still have classes?

[@HectorGarciaCPA]

In Miami, we have in-person

[@doykme]

@@HectorGarciaCPAI’m in Texas ☺️

[@auntiebagadonuts5950]

How are you in December of 2022? We aren't even there yet.

[@HectorGarciaCPA]

I came from the future

[@andreaziz5499]

Mfg ,achines are w/off on useful life

[@HectorGarciaCPA]

Is there a question here?

[@merlinq.9287]

i've looked at most of your videos by just listening. and i just realized, your voice doesn't match your face: but thank you for all the education 😊

[@AQOON544]

Hi teachers thanks for your help. I have one question and i need your help. I closed my year end i got retained earnings 16500. Also i have net ordinary income -3750. I don't know where this mines from and how to solve it. Thanks