QuickBooks Online for Construction 2024

[@4everCEO]

I am halfway through this video and it is SUPER informative! I literally signed up for QBO yesterday and needed this guided walkthrough to get started, more specifically with construction projects. The progress invoicing section and item vs category (sales) sections were especially helpful. Thanks so much, Hector. New sub 🙂

[@HectorGarciaCPA]

Great!

[@emilio-vernaza]

Hector, your content is gold! Thanks for your generosity

[@HectorGarciaCPA]

Glad you find it useful

[@emilio-vernaza]

How can I learn more about this industry? Saw you had an older knowify course from 2021, is it still relevant?

[@HectorGarciaCPA]

@@emilio-vernaza yeah. I am redoing a Knowify video for KZbin, next month

[@emilio-vernaza]

@@HectorGarciaCPA cool let me know when it out pls

[@sshmalonez9986]

Thank you Hector! That was very informative! My company is looking to move to QBO Advanced and I think this is ticking most of the boxes that we need. Cheers!

[@frankmartin-adirondackcampcab]

Hector you are amazing Ty. I have been using QBD since it came out and have mastered a daily routine system. I just migrated to QBO and much the same just finding it and how to. Your video is exactly how I operate and so helpful for me to navigate QBO. I wish you had a PDF flow chart...lol. Thank you again, I'll keep watching!

[@HectorGarciaCPA]

You are welcome.. no PDF flowchart, wouldn’t even know how to make one

[@AceCPAsBookkeeping]

TLDR: QuickBooks Online for construction provides comprehensive tools for setting up accounts, tracking project costs, and assessing profitability for construction projects. 00:00 🏗 QuickBooks Online for construction provides a comprehensive overview of setting up chart of accounts, creating income accounts and subcategories, and customizing cost of goods sold and income accounts, with suggestions for third-party apps for additional functionality. 07:04 🏗 Set up labor, equipment, and materials items with correct accounts, organize product and services list, create customers and projects for tracking billing and project statuses in QuickBooks Online for construction. 16:23 🏗 Use QuickBooks Online for Construction to enter project line items, set up estimates, create bundles for internal breakdowns, and convert estimates into invoices with potential confusion for customers. 26:14 🏗 Clearly communicate project costs, use items for advanced analysis, pay subcontractors and track expenses in QuickBooks Online for construction projects. 35:30 🏗 Enter employee time in QuickBooks Online for construction projects, calculate cost of employees, and track project profitability and costs, but be aware that only actual payroll will affect profit and loss. 43:35 🏗 QuickBooks Online for Construction allows for hourly payroll calculations, progress invoice reports, customizable and filterable income and expense reports, and detailed cost analysis through product-based reports and advanced features. 51:40 🏗 Use QuickBooks Online to create project estimates, track costs and profit margins, and easily convert estimates to invoices for construction jobs. 58:04 🏗 Track income, costs, and profit margins for construction projects in QuickBooks Online, emphasizing the importance of using the projects report and new reporting module for accurate profitability assessment.

[@HectorGarciaCPA]

:)

[@Fix2Sell]

This might be one of the most informative videos and specific to my need I have seen! Thank you Hector!

[@HectorGarciaCPA]

Great!

[@carmencuret8492]

@@HectorGarciaCPA@HectorGarciaCPA is available in a step-by-step written format?

[@IMBCBUSINESSADVISORY]

Hector you are the best. You have a gift for explain think in a easy way. Great help

[@HectorGarciaCPA]

@@IMBCBUSINESSADVISORY :)

[@ahmadalawnh3366]

How we could deal with the hourly time that we added to project that it’s not posted to profit and loss since we run the payroll with different company!?

[@murataktar8367]

Really excellent, comprehensive video. Question: I'm currently running a 3rd Party Construction Management package with an integration to QBO. It's ok but like so many applications, it has dozens of features I don't use and does not have the features I want/need. Would love to run everything from QBO and from your video it looks possible. The one really important feature I don't see how to do (and don't want to do manually) is change orders. Any thoughts?

[@HectorGarciaCPA]

QBO cant do change orders

[@ahmadalawnh3366]

Could you please tell us how to deal with the profit and loss for time are not posting if we run payroll outside QuickBooks !?? I spend many hours to figure out but no outcomes!?

[@ahmadalawnh3366]

Hector Thanks for the video, we have QBO Plus how we need to deal with non posting time to profit and loss we run the payroll with different company ? Do you think we need to expense the time to non payee for Cost of labor to COGS as manual and stop using the time entry or creat deferent service Internal labor cost ? Please help 😊

[@HectorGarciaCPA]

@@ahmadalawnh3366 must do a journal entry

[@jessamaepag-iwayan1250]

Hi! In Projects, I don't see the income vs. cost and profit margin. It's only project, customer then goes straight to time, start date.. etc..

[@HectorGarciaCPA]

Outside USA?

[@joannacastellanos5756]

Help! What if the Invoicing is paid out by lot progress /completion?

[@HectorGarciaCPA]

You can just use Progress Invoicing

[@joannacastellanos5756]

Hello Hector, What's if the GC is paying the supplier Invoices as a part of the contract, How will I record that ?

[@jessicabest_family]

This has been such a valuable video and can't thank you enough for sharing this! We have upgraded to the advanced plan and this is coming together after using the techniques you have shared here. How would you handle change orders? Would you add a separate project estimate or would you edit the existing one?

[@HectorGarciaCPA]

Change order would be an additional estimate

[@andymacmovie]

Great info - except, how would you show the expenses about to hit - in particular any purchase orders issued to suppliers that have not billed/supplied to us yet. Without knowing this, how is the reported margin correct? Any ideas? Without showing the value of Open PO.s - the numbers report more favorably.

[@HectorGarciaCPA]

@@andymacmovie there is no reports that include POs . Only Bills and checks/expenses

[@kamran2265]

Hi, sir can we show an estimated and Actual Quantity complete report. My Boss wants to see a report Quantity wise .... Estimated quantity was 100 but completely Quantity is 80.

[@paisaborracho]

Hector, would you happen to have a sample chart of accounts for Glazing Contractor or something similar?

[@HectorGarciaCPA]

I dont

[@michellebackus6424]

Thank you for this video! We've been using QBOA for several years already. I utilize the Projects feature, but not the reports for costs, etc. but would like to! Is it a problem to edit the chart of accounts and products/services item lists after using QB for over 5 years? I assume I'd have to re-categorize some accounts, etc.

[@HectorGarciaCPA]

@@michellebackus6424 not an problem but will change all your retroactive statements

[@PattySchild]

Hello! I'm wondering what happens to the Unbilled Expenses that were added to the projects. Can you maybe direct me to one of your videos that explains Billable Time and Expenses? My mind isn't connecting how that works when you have a specific amount you quoted in the Estimate; but you're always putting the actual expenses as Billable. Am I making sense about what I'm confused about?

[@HectorGarciaCPA]

@@PattySchild i might need to make a video on that.. too of head, not clear on all the details

[@PattySchild]

@@HectorGarciaCPA .... Are you saying that you aren't clear on what I'm confused about? Let me try again. A contractor gives an Estimate for $12,000 for a project and the Customer accepts price of $12,000 .... so the Invoice (or the sum of the progress Invoices) will be $12,000. When entering expenses (subcontractors, materials, etc.), those expenses were being marked as Billable Expenses. Doesn't being marked as Billable Expenses mean that those expenses should eventually get billed to the Customer on an Invoice? If not pulled over into an Invoice, wouldn't those expenses stay in some sort of Unbilled Expenses category? Did I explain my confusion better?

[@irajeshpal08]

Hey Hector thank you so much, this video is really useful for me and i am want to learn more and more.

[@HectorGarciaCPA]

Happy to hear that!

[@johnnyrivas342]

Awesome insight Hector!

[@md6922]

Do you recommend a small general contractor use the cash or accrual accounting in quickbooks online. I was veering towards the cash accounting instead of accrual as it's easier to use. What do you think?

[@HectorGarciaCPA]

Accrual always

[@DevinSullivan-k3m]

Hi Hector! Thank you so much for this video. It is so helpful! In the video you mention quickbooks advanced has the option to add in your own rate which is separate from the line item costs. I am curious how you would recommend adding in that rate if you don't have advanced? Should I add my percentage to each line item? Or would I create a separate line item for my cost with a account & everything? Any help is much appreciated!!

[@HectorGarciaCPA]

Not possible without advanced.

[@SamTurner-pw6rq]

We are new to QBO and use progress invoicing. We do cost plus projects and i am needing to link billable expenses to estimates. When progess invoicing a customer lets say for multiple "framing material" bills, I select manual entry for my invoice but when I add the billable expenses it is adding an additional line rather than taking it out of the line item in the estimate. Can you provide any clarity on this?

[@HectorGarciaCPA]

Not possible…. Invoicing from estimate vs. Invoicing from a billable expense are completely independent, there is no way you “link” them

[@SamTurner-pw6rq]

@@HectorGarciaCPA Thank you for your response!

[@stevechild5348]

Hector, thank you for the awesome training. What report do you recommend to determine if all entries have been assigned to a project?

[@HectorGarciaCPA]

Unfortunately. Such report doesn’t exisit by default. You have to do some tricky custom reporting

[@stevechild5348]

Ok. Thank you.

[@malachismoneytalks8026]

How do your track income for projects in the past? I can't unlink the estimates/invoices without it messing up the books. Please advise.

[@HectorGarciaCPA]

You would need to recreate those transactions.

[@malachismoneytalks8026]

@@HectorGarciaCPA Thank you. How would I go about this? Unlink the estimates/invoices and then reaccount for it?

[@toqirzafar]

very informative videos. Thanks for sharing, so whats you suggest for Construction industry which one is good QBOA or QBO Plus

[@elezardador3441]

It is recommended to use QBO Advanced because of the project cost estimate feature and work in progress report that are very important in the construction industry and which are not available in QBO Plus.

[@pupcountry]

Hola, Hector, Please, Puedes hacer un modelo para groomers salon. Gracias y bendiciones

[@HectorGarciaCPA]

@@pupcountry hola.. no va a pasar. No es mi area de expertise

[@jeffreyromero9169]

What version of quickbooks online is this? I am not seeing the make project command

[@HectorGarciaCPA]

Plus or Advanced. You must have Simple or Essentials

[@jeffreyromero9169]

@@HectorGarciaCPA Plus and Advance is a bit out of range for my volume of work. Is there a way to setup Simple to work in a similar manner?

[@HectorGarciaCPA]

@@jeffreyromero9169 no. Projects is only on Plus or Advanced

[@FancyBuilders]

Thanks for such a great and detailed video. I am getting this error when I click "Products & Services", "We're sorry! You don't have access rights to view this data, please refresh the page to see the new experience or please do logout and login again." I know I shouldn't post this here, however, I thought someone has the same issue and might have a solution.

[@HectorGarciaCPA]

No clue.. gotta call support

[@FancyBuilders]

@@HectorGarciaCPA Thanks for the quick reply, I already called them and they said they are working to fix this issue.

[@HectorGarciaCPA]

@@FancyBuilders cool

[@vinnie21000]

Hector I need your help please. In Quickbooks Desktop when creating estimates there was a feature similar to what you explain in the "project cost estimates" section of your tutorial where you could populate "your rate" (which is hidden) and the customer rate on the estimate. In Desktop you could then create a PO based off of this estimate. Is this possisable within QBO Adavanced, can you create a PO based off of the "project cost estimate". Thank you in advance for any help.

[@HectorGarciaCPA]

Not yet…. They have not done this part yet :(

[@vinnie21000]

@@HectorGarciaCPA Thank you sir.

[@JohnVan13]

Love your videos Hector. My QB online doesn’t have the PROJECT option. How do I get that?

[@HectorGarciaCPA]

Upgrade to Plus or Advanced.

[@HectorGarciaCPA]

Turn on the Setting

[@loriflath5917]

Thank you so much for such great videos. I do a lot of construction and do AIA billing I would love to see a video on tracking retainage for invoices and we hold retaininge for some of our subcontractors.

[@HectorGarciaCPA]

That video has been posted. I recommend looking an an app called Knowify

[@loriflath5917]

Would it be possible to link the video in here? Or give me the name of the video to look up. I will also look into knowify

[@JordanCummings-m5f]

Hector I cannot get my sub-customers or projects to appear on invoices. I see the project name on the invoice in this video. How is this possible? Intuit says the feature doesn’t exist and I have to use custom fields and manually type in a project name.

[@HectorGarciaCPA]

You have to include it in the Address section if you want it to print

[@JordanCummings-m5f]

@@HectorGarciaCPA your video shows Backyard Remodel in the Project field and not in the address field. And it appears as Backyard Remodel on the PDF view. Do Projects print on the invoice?

[@HectorGarciaCPA]

@@JordanCummings-m5f they only print if they are in the Address section.

[@JordanCummings-m5f]

@@HectorGarciaCPA You're quick man! Thanks so much for the reply. Seems like a major oversight to not allow the sub-customer or project on an invoice. Using custom fields is a hack of a work-around. I put in a feature request. But in the meantime my client is regretting the move from QBD to QBO. Thanks again for your help.

[@HectorGarciaCPA]

@@JordanCummings-m5f been asking for that forever :(

[@BillCipher1995]

Whooooaa! I was just talking about how the road construction companies in my county are super active!

[@HectorGarciaCPA]

Great niche to serve

[@MomentoMori769]

very good video, do you do government accounting? Its kinda like this construction example but more complicated

[@HectorGarciaCPA]

I dont :(

[@christianeldringhoff4241]

Hector - At 1:06 you show the Project Est vs. Actuals report; however, you didn't demonstrate how to drill into the total cost detail of the cost code (service item). Even though QBO makes it look like you can click on the total of the cost code to drill into the transaction detail, you cannot. This should be highlighted in BOLD for all accountant considering moving their QBD construction clients to QBO. I was excited to have the Project Bud vs. Act report only to find out I couldn't get back to the original budget or the actual transaction cost code detail from any of these project reports. The Intuit rep kept telling me to go back to the P&L to drill through the G/L detail. Clearly, she's not understanding the need for accountants to drill into the cost by cost code and not by G/L. What good is a report that shows over or under budget when I cannot access the details to find out why? Can you shed any light on this glaring issue? Thanks for your content as always!!!

[@HectorGarciaCPA]

Its a glaring issue for sure! This is something that Intuit/QB has not addressed

[@christianeldringhoff4241]

@@HectorGarciaCPA Thank you so much...I thought I was crazy.

[@TraciBradley-i8k]

THANK YOU!!!!!!❤

[@SamerHani]

Thank you!

[@HectorGarciaCPA]

:)

[@monafaizan9215]

Hi Hector, Thank you for sharing the Video, I am looking forward for E commerce Bookkeeping Video from you. It is a request to upload that one too. Please acknowledge.

[@HectorGarciaCPA]

Ecommerce video will not be coming anytime soon time soon

[@cintiadixon4897]

You are so great. I wish you could make a video for interior designers, too 😂

[@HectorGarciaCPA]

Not my specialty