QuickBooks Online Tutorial: Labor and Materials Job Costing for Projects

Поделиться
HTML-код
  • Опубликовано: 10 дек 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 RUclips. Your videos are extremely, extremely helpful. Thanks for putting these together!

  • @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

  • @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.

  • @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

  • @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

  • @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

  • @seansnider
    @seansnider 3 года назад +2

    Great video! Thank you for making this.

  • @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.

  • @Cluni-80s
    @Cluni-80s 11 месяцев назад

    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.

  • @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?

  • @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.

  • @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?

  • @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

  • @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?

  • @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?

  • @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.

  • @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.

  • @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

  • @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?

  • @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

  • @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

  • @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

  • @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?

  • @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?

  • @jaredmkioko
    @jaredmkioko 2 месяца назад

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

  • @NinetyOneAdventures
    @NinetyOneAdventures 10 месяцев назад

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

    • @HectorGarciaCPA
      @HectorGarciaCPA  10 месяцев назад +1

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

  • @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.

  • @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.

  • @sandydaywhitfield1257
    @sandydaywhitfield1257 5 лет назад +1

    If a client outsources payroll, how do you suggest getting the payroll expenses into 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.?

  • @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.

  • @noahgreer7970
    @noahgreer7970 4 года назад

    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.

  • @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?

  • @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

  • @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?

  • @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

  • @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

  • @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.

  • @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

  • @glendalewestpharmacy
    @glendalewestpharmacy 2 года назад

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

  • @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

  • @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

  • @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

  • @kristiehendricks9866
    @kristiehendricks9866 Год назад

    What version of Quickbooks is this?

  • @littlequeen22
    @littlequeen22 3 года назад

    Where do you pull your expenses from

  • @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. ruclips.net/video/kwPLxUsvMoU/видео.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?

  • @dfinalcutaz
    @dfinalcutaz 5 лет назад

    Thanks, Hector.

  • @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

  • @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?

  • @AnonymousPerspective33
    @AnonymousPerspective33 4 года назад

    thanks this was very helpful

  • @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.