QuickBooks Online Tutorial: Labor and Materials Job Costing for Projects

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

КОМЕНТАРІ • 132

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

    In the second example (about minute 10) this feature will NOT work if payroll is turned on or if it has even been turned on! I dont know of an active solution for this issue!

  • @nicholassergon
    @nicholassergon 4 роки тому

    Hector - Thank God for you and Thank God for UA-cam. Your videos are extremely, extremely helpful. Thanks for putting these together!

  • @KyleBaptiste
    @KyleBaptiste 5 років тому +2

    We have QB full service payroll and Projects. Even if you input the Hourly cost rate including WC and overhead related to that employee, the projects report defaults to the posted payroll from that week which only calculates the wages and taxes. Is there a work around that would account for the other "estimated" costs attached to said employee? ie. Workers Comp and overhead multiplier

    • @HectorGarciaCPA
      @HectorGarciaCPA  5 років тому

      Kyle Baptiste yes.. IF you have payroll, it only uses Actual Payroll into.. no burdened data.

    • @falonnebilly3796
      @falonnebilly3796 5 років тому

      Hi , where you able to find a work around that resolve this?

    • @falonnebilly3796
      @falonnebilly3796 5 років тому

      *were

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

    Hector, Do you have videos for QBO for construction industry. I need to do WIP for the construction project . Any help would be appreciated.

  • @mohamedsultan7705
    @mohamedsultan7705 4 роки тому

    If you have an construction accounting example staring from posting expense as WIP and selling the house and moving WIP to P&L

  • @Cluni-80s
    @Cluni-80s Рік тому

    Thank you Hector for the detailed video, what about if an employee has overtime?
    Lets say the normal working hours are 8h per day. Any additional hours (or working on holidays) are calculated @1.5 the regular hourly rate. (I am asking without payroll being activated).
    Thank you.

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

    Love your videos. I have a hourly employee and a salary employee. When I run payroll, only the hourly employee's time (and payroll costs) gets added to the "payroll expenses" for a particular project

  • @01adutton
    @01adutton 2 місяці тому

    @HectorGarciaCPA, we build projects and then create an invoice for the contractual amount of the total project. We then create bills and click billable to the project for the sub-contractors and then bill payments when we receive funds on the contract. The P&L and the Project income vs. expenses seem extremely convoluted and messy as well as inaccurate. What am I doing wrong? The contractual amount is the total income on the project. It will never be more. The expenses could be more but that will just be a loss to the overall contract price. (this would include fuel, admin costs, etc.) We bill the architect for portions of the invoice as work is completed and then apply the payment from the architect to the invoice. There are still the bills and bill payments to the sub-contractors that seem to confuse me when looking at the job report or the P&L. It is as if the "billable expense" makes it appear to be a duplicated entry?

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

      @@01adutton you should avoid billable expenses if you dont invoice like that

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

    As always Hector great video., I have a question though. If i get deposits from a client for a project , do i have to do that deposit from the project window or outside the project window?. Like i saw a video from you concerning retainers/deposits and i was wondering if it would work the same way .......
    Thanks in advance.

  • @olindaramirez1982
    @olindaramirez1982 4 роки тому +1

    Great webinar, I have a question. My client paid an invoice via CC that was not tied to their project, can I still edit the CC payment to apply it to the project after the fact?

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

      You can change the customer in the payment.

    • @olindaramirez1982
      @olindaramirez1982 4 роки тому

      @@HectorGarciaCPA when I do that it zeros out the payment and doesn't show it as a CC payment that was processed through the QB system.

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

      Olinda Ramirez oh... then you might need to do a journal entry.

  • @lalmohd2779
    @lalmohd2779 4 роки тому

    Really helpful information. my manager asked me to work on time allocation for each project but all the times come 0 under the project transaction , how to get rid of these 0 which is coming from the last couple weeks. need your help in this regards . Thank you

  • @carolinecarriere1154
    @carolinecarriere1154 4 роки тому

    Hector thanks for the video. How would you compare QB Online Vs QB Desktop for Job Costing, are there specific advantages or inconveniences one over the other?

  • @christeifke9921
    @christeifke9921 4 роки тому +1

    Thank you for this video! I have a Standard User with Full Access in QBO+ but she does not see the Overview Tab in Projects?

  • @lilianadeanda2038
    @lilianadeanda2038 4 роки тому

    2 questions: I do single time activity instead of weekly because not every job is big enough for us to do a project. So the weekly becomes a hassle when it wants a project name when there won't be one. And sometimes, those small jobs become projects so I go back and add times to those previous days in single time. Does that affect the numbers we use to calculate cost because there is no payroll expense this way? Also, we pay some contractors by check and track their time at each project, will splitting their checks according to how much time spent in each project AND tracking their time on single time double the expenses on them and thus miscalculating the actual cost for projects?

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

    Sir My Quickbooks is not same as yours. Your quickbooks clearly shows Income & Cost but my quickbooks didn't show. Can you really help me?

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

    Hi hector, can you tell me, on the projects profitability detail screen, why there is a separate "hourly costs" vs "payroll expenses" option? When selected they show different profit margins.

  • @ShadowLight2012
    @ShadowLight2012 5 років тому

    Thanks Hector..this was extremely helpful. I am starting a new accounting project and going to be implementing this concept into their books.

  • @KenStolting-y4u
    @KenStolting-y4u Рік тому

    Love the video, so after creating the project, is there a way to force all i have done related to that project to drop into this project? In other words retroactively?

  • @seansnider
    @seansnider 3 роки тому +2

    Great video! Thank you for making this.

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

    Help please!! I am creating invoices and everything through the Sales section. But then when I go to project profitability nothing shows for my customers. Do I have to add these transactions in BOTH places (sales/ expenses section AND project profitability section?

  • @sandydaywhitfield1257
    @sandydaywhitfield1257 5 років тому +1

    If a client outsources payroll, how do you suggest getting the payroll expenses into projects?

  • @caseytaylor1487
    @caseytaylor1487 4 роки тому +1

    This is a great video and very helpful, thank you! I have just implemented TSheets and I want employees to be able to assign time to overhead, do I have to create a project/customer for this so that it becomes available in TSheets?

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

      Yes.. I you need the premium version of Tsheets as well

  • @dustyh2371
    @dustyh2371 5 років тому

    Does QB allow you to put in the total price of the job based on your estimate, then show you your hours counting against that to show how close you are to your limit? I do architectural services so I'm always tracking my time. How is the T-Sheet timer in connection with QB? I would need it all to be easy and seamless since that's how Freshbooks is for me. I currently use Freshbooks but am curious if Quickbooks is worth switching to.

    • @HectorGarciaCPA
      @HectorGarciaCPA  5 років тому

      I would have to see freshbooks to compare... but there is no way to budget for hours spent

  • @NinetyOneAdventures
    @NinetyOneAdventures 11 місяців тому

    There's no project tab in QBO anymore. Do you have an updated video about this?

    • @HectorGarciaCPA
      @HectorGarciaCPA  11 місяців тому +1

      Not lately.. i should do.. this has changed a lot

  • @entremama
    @entremama 3 місяці тому

    Should the owner of a fencing company pay themselves a salary or a W2? There are 2 owners and they are the only ones working.

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

      If is a Scorp, yes for sure. If is a C Corp or Partnership, depends on the amounts of profits

    • @entremama
      @entremama 3 місяці тому

      @@HectorGarciaCPA For the first month of production would you suggest a salary until business is consistent and then transfer to W2 payroll? It is a Partnership LLC they would also get distributions each quarter

  • @masseyandcompanycpa4682
    @masseyandcompanycpa4682 4 роки тому

    Our contractors enter their time in TSheets and we export it to QBO. Is there a way to add an Hourly Cost Rate in QBO even if we are not paying out contractors through QBO Payroll? I would love to be able to see a Project Profitabiity Report that includes both Sales and the cost of labor.

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

      Yes, if you have never enabled Payroll in QBO, the Tsheets timesheets that transfer to QBO will be able to be job costed.

    • @masseyandcompanycpa4682
      @masseyandcompanycpa4682 4 роки тому

      @@HectorGarciaCPA Will this cause me any problems if my workers are actually contractors? They are listed as vendors in QBO and I give them a 1099.

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

      Massey and Company CPA complicated answer.. first of all, if your contractors are using YOUR time tracking system, that might just disqualify them from being a contractor in the first place.
      Second; I think that if you use contractors in QBO, the project costing module will not work.... I have not tested it, but my instincts tell me that. I would recommend you to test it by creating a timesheet for a vendor/contractor. So you might need to create them as employee for this to work.
      On another point. If they are contractors, you are probably creating manual bills or checks for them anyway, you can just project cost it in there, and no need to use timesheets.

  • @jaredmkioko
    @jaredmkioko 3 місяці тому

    @HectorGarciaCPA, Is it possible to rename the sales receipt to inventory usage (material /stores requisition) to issue to projects?

  • @커피빈-w5r
    @커피빈-w5r 4 роки тому

    What do you suggest if we pay commission per project not hourly and I want to show the commission cost in project's pL.?

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

    Hector does quickbooks online have the ability to job cost non-taxable portions of the workers wage such as health care and pensions. We got away from it because it did not have the capability but I heard a rumor they may have added it now. I can't find anything on it though

  • @christeifke9921
    @christeifke9921 4 роки тому

    See this video is almost a year old. Has QBO come up with any report to pull and display the job costs when not using QB payroll other than just being able to view the project costs (material and estimated labor) from the Project screen?

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

      nothing has changed inside this feature, this video is still 100% relevant

    • @christeifke366
      @christeifke366 4 роки тому

      @@HectorGarciaCPA Thanks, Hector. Just wanted to make sure there was nothing new related to this feature.

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

      @@christeifke366 i wish :) . when it does, you will surely see a video on it

  • @slaughtertexas9645
    @slaughtertexas9645 5 років тому

    Can Workers Comp and GL insurance be set up to accrue per project based upon the gross wages for that pay period? I see where it breaks down the wages and and associated payroll taxes for the project but didn’t notice anything related to GL & WC. We have this set up in Quickbooks Enterprise desktop right now and have been entertaining the idea of trying to move to QB online Advanced

    • @HectorGarciaCPA
      @HectorGarciaCPA  5 років тому

      Yes, but you can’t have payroll inside QB, you need to outsource it.

    • @slaughtertexas9645
      @slaughtertexas9645 5 років тому

      So the payroll that is processed within QB online won’t handle without outsourcing the payroll?

    • @HectorGarciaCPA
      @HectorGarciaCPA  5 років тому

      Slaughter Texas built in payroll only job costs labor and taxes... no WC; Benefits, or other burdened costs

    • @48537778
      @48537778 5 років тому

      I am also trying to enter overhead expenses to jobs through payroll as a % in Enterprise contractor - Have not found a way to do so. @@HectorGarciaCPA

  • @kaltuzarra
    @kaltuzarra 5 років тому

    Hi Hector - I missed your webinar about labor costing projects, can you please tell me how to get a copy of this webinar? Thank you

    • @HectorGarciaCPA
      @HectorGarciaCPA  5 років тому

      It’s a subscription... go to hectorgarcia.com/advanced for info.

    • @kaltuzarra
      @kaltuzarra 5 років тому

      @@HectorGarciaCPA Thank you!!

  • @htohb
    @htohb 4 роки тому

    Hi Hector, I am all for doing this process however I would like the direct labor costs to show under COGS on the P&L. It sounds like your process does not increase expenses for the user. Can you share if there is a way to have the direct labor costs filter through to the P&L to reduce profit?

  • @PaulChoate-s4v
    @PaulChoate-s4v 10 місяців тому

    It is so convoluted how Intuit/QBO breaks this down. Project expenses, COGS and employee labor are ALL EXPENSES when it comes to project costs! I've been trying to get my employee costs (horly labor rate) to show in my custom reports but it will not. I'll watch the rest of the video to see what I'm doing wrong lol.

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

      If it comes from timesheets, wont pass through reports, unless Payroll is processed inside QuickBooks

    • @PaulChoate-s4v
      @PaulChoate-s4v 10 місяців тому

      @@HectorGarciaCPA Thank you Hector. My payroll is processed in QBO through Intuit. I enter the timesheet data in QBO and you'd think the timesheet data/hours would transfer to the payroll hours when I "run payroll" but they do not does not. I need to manually enter the amount of hours for my employees again even though it's already on their time sheet. And how do I account for my employees hours in the "Products & Services" (AKA "Items" in QBDT)? When setting up a new service exclusively for my employee (Carpentry: Labor) I don't have the option to link it to a COGS account (or any account) unless I check off that "This service is provided by a sub contractor/vendor". And even when I do that it still doesn't show in the job costing report. It's as if I need to have two reports to get an accurate picture of my projects: One for vendors & subcontractors and one for employees and then add them together. I need help!

    • @PaulChoate-s4v
      @PaulChoate-s4v 10 місяців тому

      @@HectorGarciaCPA I do process my payroll in QBO/Intuit.

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

      @@PaulChoate-s4v then the actual payroll cost plus taxes should show as the official expense for the Project.. which part is the convoluted part?

    • @teakkabean
      @teakkabean 6 місяців тому

      Can projects be assigned after the estimate & invoice is generated?
      If vendor bills are uploaded into the bill mod, can they be assigned to the project? Or do they have to be entered into the projects window?

  • @Phoebetu2
    @Phoebetu2 4 роки тому

    Hi Hector, quick question for job costing on QBO. I am curious as to why NOT ALL INCOME is recognized. I have cross-checked that the project and client are selected correctly, but for some reason, not all income showing instead only a portion of the income is showing. Have you ran into this issue and/or know what could be the issue?

  • @noahgreer7970
    @noahgreer7970 5 років тому

    Great video, thank you. Is there any way to edit the Cost Rate for employees after the fact? We didn't assign one employee an Hourly Cost Rate earlier, but I'd love to update the Project now.

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

    Would this work for pieceworkers? They are not paid by the hour.

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

      You would need to use the hour as a proxy. Because there is no mechanism for something other than a timesheet

  • @denamartin765
    @denamartin765 4 роки тому

    Hector, this is great info, thank you. I have a client that sells Blinds. They have QBO Payroll and I've touted Projects for them. But the payroll is commission based, not hourly. Is it possible to get his payroll info into the Project?

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

      In QB you can only do the job costing in payroll it based on timesheets.

  • @jamescrozier8156
    @jamescrozier8156 5 років тому

    Great video Hector. Just want to know how you would do progress invoicing if you have already created a invoice for the total amount? Would you have to create progress payments manually in quickbooks? Also I use tsheets for time tracking would that flow into this new project feature? Thanks

    • @HectorGarciaCPA
      @HectorGarciaCPA  5 років тому

      If you invoice in full, you can’t progress invoice any more

    • @HectorGarciaCPA
      @HectorGarciaCPA  5 років тому

      Yes Tsheets will flow through

    • @jamescrozier8156
      @jamescrozier8156 5 років тому

      @@HectorGarciaCPA So should I just invoice as phases of job done. I have a construction company and want to do job costing but do progress invoicing upon completion. What would be the best approach for this? Thank you

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

    Do I need to have an upgraded QuickBooks account to access job costing?

  • @Carylle18
    @Carylle18 4 роки тому

    Hi Hector! Your videos are very useful and informative! Thank you! I’m using quickbooks online pro. We dont have payroll taxes here (Cayman Islands). Is there any way I can still use qbo payroll?

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

      Carylle Angelie Cabading probably not

    • @Carylle18
      @Carylle18 4 роки тому

      Thank you for the reply. I hope tax exempt feature will be available soon.

  • @Andreina2104
    @Andreina2104 4 роки тому

    Hola Héctor, muy bueno tú video, sin embargo tengo una duda, tengo algunos vendors a los cuales necesito hacerles tracking time, y tomando en cuenta que debo hacerles un pago por sus servicios basado en ese tiempo, quería saber si existe alguna posibilidad de que ese tiempo llegue al Vendor y a partir de allí hacer el bill, o que apareciera la opción de hacer el link a ese tiempo. Porque sucede lo siguiente, si posterior a registrar al tiempo elaboró un cheque o un bill, voy a seleccionar una cuenta de gasto y en el overview del proyecto se estaría duplicando el gasto, por lo que el Resultado no sería el real. Espero tu experiencia pueda ayudarme. Gracias.

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

      Andreina Soto es un error de QuickBooks, esta mal diseñado

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

    Sir I also use quickbooks online but my interface is different kindly can u tell me how i can manage the interface same as you.

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

      Should be identical.. unless you are outside US

  • @whit6119
    @whit6119 5 років тому

    How come I don't see any of the graphs or the overview tab with the summary in my projects?

    • @HectorGarciaCPA
      @HectorGarciaCPA  5 років тому

      Maybe you have the international version?

    • @whit6119
      @whit6119 5 років тому

      I am not sure, mine looks like it does in this video. ua-cam.com/video/kwPLxUsvMoU/v-deo.html and so do a lot of other videos and websites I have seen@@HectorGarciaCPA

  • @melissarigney7710
    @melissarigney7710 4 роки тому

    How do you track time for an owner with Tsheets?

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

      Melissa Rigney you could.. but if he/she is not getting a paycheck; what’s the point?

  • @mariacastaneda4543
    @mariacastaneda4543 4 роки тому

    This video was so helpful, thank you! I wanted to sign up for your webinars but I realized that none are for construction companies, do you think I could benefit from attending anyway?
    Also, you mentioned that if we already created invoices/estimates on a project we have to change them, how do I do that?
    “Hector Garcia CPA
    You have to change the estimate and invoice to be for the Project
    4 months ago”

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

      Maria Castaneda there is a button that lets you do that.. on top of the estimate once you have it open

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

    The problem about project costing is that Quickbooks doesnt' do a simple comparison of actual to the estimate for each cost code. Does anyone know any good workaround?

  • @pauldeuzeman307
    @pauldeuzeman307 5 років тому

    Is this available for QBO Canada or only QBO US?

    • @HectorGarciaCPA
      @HectorGarciaCPA  5 років тому

      Paul Deuzeman I would guess US for now

    • @pauldeuzeman307
      @pauldeuzeman307 5 років тому

      I called QBO Canada. They said Canadian accounts should see it in coming weeks. I don’t know how confident the agent was in their response but I hope they were correct.

    • @HectorGarciaCPA
      @HectorGarciaCPA  5 років тому

      @@pauldeuzeman307 I called, they told me the same thing.. I have 2-3 Canadians call me today with the same Question, LOL

  • @EvandroFilgueiras88
    @EvandroFilgueiras88 4 роки тому

    Can I use exclusively quickbooks online as a contractor? If now, what do you advise?

    • @bitcoinsarah2780
      @bitcoinsarah2780 4 роки тому

      Hector, I would like to know this also! Also, as an LLC can i pay an employee? i have been debating this with business owners I know and my current accountant who I am thinking about letting go.

    • @EvandroFilgueiras88
      @EvandroFilgueiras88 4 роки тому

      @@bitcoinsarah2780 Sarah, I'm an LLC and I have W-2 and 1099 employees... I haven't had any problems with it. My biggest problem is not exactly knowing what problems quickbooks online don't address since now they do have a good job costing tool. My idea is to wait a bit more before I move into a more robust software like Procore or BuilderTrend.

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

    What version of Quickbooks is this?

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

    Where do you pull your expenses from

  • @ThaoNguyen-qq8zg
    @ThaoNguyen-qq8zg 5 років тому

    what if i already made an estimate and invoice the customer and then i wanted to create a project and add receipts later to see actually profit can i do that?

    • @HectorGarciaCPA
      @HectorGarciaCPA  5 років тому

      You have to change the estimate and invoice to be for the Project

  • @cristalgarcia797
    @cristalgarcia797 5 років тому

    I don't see the Projects tab on the left

    • @HectorGarciaCPA
      @HectorGarciaCPA  5 років тому

      1) are you in US? 2) are you using QuickBooks Plus?

    • @clearandfocused8882
      @clearandfocused8882 4 роки тому

      @@HectorGarciaCPA What if I answer No to both 1 & 2? Does that mean I cannot do job costing as a contractor using quickbooks?

    • @clearandfocused8882
      @clearandfocused8882 4 роки тому

      @@HectorGarciaCPA Is it possible at all as a contractor to get by with QBEssentials only? What is it about Plus that would make a contractor opt for that instead, and is it something that can also be done with Essentials, but perhaps just more cumbersomely?

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

      Clear and focused no.. you need Plus to be able to track Projects and job costing.

  • @AudreaRobbins
    @AudreaRobbins 5 років тому

    Thanks for the video. Very helpful. I am new to using QBO to running a non-profit. I'd like to use projects for fundraising projects but I cannot figure out how to add multiple donors (customers in regular version) that give to a specific fundraiser. It forces me to always choose a specific donor. I have multiple donors that attach to a specific fundraiser. Any thoughts? I'm using the $60 version. I was told it would work.

    • @HectorGarciaCPA
      @HectorGarciaCPA  5 років тому

      Audrea Robbins each donor should have its own invoice or sales receipt

    • @AudreaRobbins
      @AudreaRobbins 5 років тому

      Hector Garcia CPA thanks for replying. Let me explain what I’m trying to do. I’m running a school booster club and we have fundraisers like selling field signs, selling program ads, selling bundles where corporate sponsors get advertising, touchdown ads, etc etc. We ask our parents/players to raise $500 yearly by selling these for us or making donations. We would like to keep up with which player sells what in order to keep up with corporate relationships, as well as seeing who is helping out and who is not. It’s voluntary but it’s still beneficial to us. By using a donation invoice, we could send invoices out to players and remind them of their promised goal of selling or donating. So I am trying to keep up with it via projects. I thought I could but I just cannot seem to figure out the combination of how to keep up with which player sold. As I mentioned, I tried by entering each player in as a project, then entering in an invoice for each player of $500 so that each transaction of a fundraiser’s sold to a corporate sponsor could be attached to that player’s project and reduce their $500 goal. But I just cannot figure it out. Any ideas? I’m trying to prevent having to keep excel spreadsheets for this if I can use QB to do it while steady entering in. Thanks for any help.

  • @dfinalcutaz
    @dfinalcutaz 5 років тому

    Thanks, Hector.

  • @AnonymousPerspective33
    @AnonymousPerspective33 4 роки тому

    thanks this was very helpful