QuickBooks Desktop/Enterprise for Construction & Contractors

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

КОМЕНТАРІ • 113

  • @Max-nh3gp
    @Max-nh3gp 5 років тому +2

    Just watching this for fun to learn more about accounting for construction contractors. Great job explaining everything, very helpful and I learned a lot!

  • @bayarea13
    @bayarea13 3 роки тому +1

    Excellent detail in your description, so thank you for taking the time to school us up on how to maximize the use of QB.
    I'm just wrap my mind around the % of completion method.
    Do I have this right...
    The items that are funneled to the income and expense items through POs and payroll are strictly for internal job costing. No one outside the company sees any of that.
    The client side billing under "Project Billing" in only applied to the asset account which hits the balance sheet.
    When a client pays that invoice the "revenue" should be applied to that asset account to zero it out and clearly not to construction income as that would double it up?
    If I do have that right, would it be ok to create a second estimate with all of the milestones and bill against that instead of the single line item in the same estimate? That would allow for a bit more detail to the client and a cleaner tracking of the actual contracted milestones/payments. I would make MS25%, MS50%, etc. items that point to the asset account and use those in lieu of the single Project Billing one.
    FYI that I also left a VM regarding hiring you for some consulting help.

  • @mirnareyes1157
    @mirnareyes1157 3 роки тому +1

    Hector do you provide individual service ? like if i need you to check if my account are set up correctly on my quick book desktop

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

    Hi Hector. Thank you! For Percentage of Completion, how do you remove the unearned project billing balance off of the balance sheet? When job is done and all revenue needs to be realized, there shouldn't be any money leftover on balance sheet from that customer:job, right?

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

      Hard to answer without looking at it.. but probably a Journal Entry against income

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

      @@HectorGarciaCPA at 1:08:15 you still show unearned income of $98,373. Even though, at that point, you only had $67,750 of customer money (orA/R). So then shouldn't that liability account be -$30,623 instead of $67,750?

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

    thank you Mr Hector. how to manage construction overhead in estimation stage and when i finishing jobs?

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

    Hector, regarding payroll, if you use another payroll service do I just make a journal entry for each payroll to job costing?

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

    The Progress Billing (Unearned) equivalent to 25% multiplied by the estimated revenue of $271,000 should not anymore be recorded in the system since it is only your estimate/assumption. It must only be 36.30% which is the actual or correct percentage of completion. If these two scenarios will be both applied and recorded, therefore, there will be two schools of thought, that progress billing is based on the % of assumption and the percentage of completion to date. Only one must be adopted if strictly applied.
    Further, the Progress Billing (Unearned) discussed at the beginning which was classified as part of the income and by the end, treated as Current Asset. Additionally, I could say this is also the account referred to as Construction-In- Progress (CIP) account in the Percentage of Completion Method in Construction Accounting. As far as my knowledge is concern, this is a Current asset Balance Sheet account and represents the cumulative costs plus income recognized to date during the entire project.
    I think your application into the QuickBooks Desktop System is contrary to the Double Entry Bookkeeping Method in Construction Accounting. Just to eliminate the Progress Billing (Unearned) in the Profit & Loss is through editing the item as Current Asset but having with an abnormal negative balance; and double charging of receivables and crediting Current Asset and Construction Income (Earned).
    In view of this, may I politely request to update this video and make all accounts be properly configured in the system for more reliable dissemination of information for us who are not as good as you, Mr. Hector Garcia. Thank you very much and hoping for you would come up with a better presentation/video.
    Kindly ignore this message, if you have an updated one for my sharing of info.

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

      REX ESPIRITU there are two methods..WIP and Completed Method. You and I are discussing two different methods.

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

      @@HectorGarciaCPA Hi, my dear friend, Hector, we are both discussing the same. Yes, there are 2 methods and I agree on the presentation you made for the WIP/Completed Contract Method. What confused me only the time you are discussing the Contract PCM - 1. Creating Invoice - (1:03:45) Dr. Receivable Cr. Progress Billing (Unearned) and later edited as Current Asset just to be eliminated in the P&L; 2.Creating another Invoice (1:07:22) Dr. Receivable Cr. Construction Income (Earned). This is what only I want an explanation from you. As to the total presentation, an excellent job! Therefore, I would follow the second option you have discussed for Progress Billing purpose. Thank you very much for your kind reply. Wishing you all the best and great success!

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

      @@rexespiritu6153 exactely sir this was my concern unearned 25% should not be anywhere in billing the reason is already we have recognized the revenue that should maximum goes to p&l A/c NOW Again this project unearned if we are going to transfer to balance sheet this makes no sense as per IFRS OR GAAP laws.there is no any need of project unearned revenue account here in %age of completion method .100% agree with mr Rex

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

      thanks for your hard work but update this video

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

      @@rexespiritu6153 I agree. That confused me. Shouldn't the 25% invoice ($67,750) be eliminated, leaving the earned income on the income sheet? I cannot see a JE that would correct the current asset account being that @HectorGarciaCPA made the second invoice for the full 36.30% completion rate. I would like an explanation of this as I have recently taken a job as a construction company accountant and will be dealing this alone.

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

    Great video. What if you have hundreds of vendors? Creating as many sub accounts under materials makes COA messy or lengthy.

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

      Yes. I prefer to use smaller chart of accounts

  • @muhammadasif-mc2xy
    @muhammadasif-mc2xy 6 років тому +1

    I am not creating any estimates just all tha cost to WIP in balance sheet nd issue customer invoices without any estimated just as per contract 30% or 40 % simply..?when i will issue tha invoice that time transfer tha cost to As exp in pnl.,,?

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

    Hector, I have followed each and every step you have done here. The issue lies within the Estimate vs Actual Detail report. I have items setup as Service, Inventory Part, and Other Charge types. I have recorded 2 Purchase Orders and converted those to Bills with items that are inventory items. ALL of my items are setup as COGS Account > WIP Account (Construction in Progress - Other Current Asset) and Income Account (Construction in Progress - Other Current Asset) with the Asset Account being Inventory Asset (Quickbooks standard account). When I run the report my Estimate shows and anything with any Other Charge type shows on the report. My Inventory Part items are not showing on the report. Why and will I have to change all of my Inventory Part items to another Item Type?

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

      Inventory only shows when you sell it, when its in an invoice / sales receipt

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

    Can you batch enter bills in QB Premier Contractor Edition 2020?

  •  7 років тому +1

    hahahaha.....just wanted to be sure you were paying attention.........hhahaha great video Señor Hector; muy amable!!

  • @stevecollins8468
    @stevecollins8468 7 років тому +1

    Great video Hector. You cover a lot of ground in it. But I have one question. When setting up a new company, how do you enter beginning balances for jobs so that the Job Estimates vs Actuals Detail report will be correct for jobs that were in progress at the time you started using QBE?

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

      Steve Collins You can enter a Journal Entry on 12/31/2016 against Retained Earnings, male sure you select the Customer Job

    • @stevecollins8468
      @stevecollins8468 7 років тому

      But a Journal Entry can't use items (can it?) so it they won't match up with the estimates on the Job Estimates vs Actuals Detail report. Is there any way around that or is that something they'll just have to live with on the jobs that were active when they started using QB? Obviously it won't affect jobs started later.

    • @hexgarcia
      @hexgarcia 7 років тому

      then do a a BILL and net it to zero with a negative ammount to retained earnings

    • @stevecollins8468
      @stevecollins8468 7 років тому

      Thanks, I'll give that a try.

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

    If i am doing this accrual method and I sync my bank account, where do I send a deposit from a customer, for example? Should I send it to accounts receivable to reduce it? But what happens to WIP when I do that? Because isn’t what my customer paid me supposed to go into WIP?

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

      A/R to create a negative receivable that eventually gets applied to a invoice. Or into a “Customer Deposits” Other Current Liability account.

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

    Thank you . Would you use CCM if the Project is only sold at the completion ? In other words you do not haver a client. You would put the building for sale at the completion of construction.

  • @hildarbarron5775
    @hildarbarron5775 7 років тому

    Hector need to know the process of how to handle retainage as some of our GCs require retainage on our invoices to them?

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

      +Hilda R Barron item with negative amount hitting the asset account

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

    TLDR: QuickBooks Enterprise offers a comprehensive solution for construction and contractor businesses to track finances, manage expenses, allocate costs accurately, and monitor project expenditures.
    00:00 🏗 The webinar covers construction accounting in QuickBooks Enterprise, with a focus on technology solutions for medium-sized businesses and a webinar on new features of QuickBooks 2017 hosted by Hector Garcia.
    04:25 🏗 Use QuickBooks Enterprise to track finances for construction and contractor businesses, including determining accounting methods, managing payments separately from invoices, and organizing chart of accounts and item lists.
    15:07 🏗 Use QuickBooks to track labor, equipment, materials, and subcontractors, create estimates, understand profit percentage, manage expenses, and allocate costs accurately for construction projects.
    30:02 🏗 Create sub-accounts and custom fields, manage cash flow, track expenses and vendors, and monitor project expenditures in QuickBooks for construction and contractors.
    40:41 🏗 Transfer income from work in progress to profit and loss in QuickBooks for construction and contractors, track job profitability, reconcile accounts, and focus on active jobs.
    50:09 🏗 Use QuickBooks Desktop/Enterprise for construction and contracting to track costs, income, and billing for projects, including creating payment triggers and purchase orders.
    57:49 🏗 Plan payments, set up bills for rental equipment, tie service items to estimates, track labor through time sheets, create paychecks, split expenses per job, and use project billing and progress invoicing in QuickBooks Desktop/Enterprise for construction and contractor businesses.
    01:04:53 🏗 Use QuickBooks Desktop/Enterprise for Construction & Contractors to track job completion, project billings, costs, retainage, and expenses, and join webinars for more tips and features.

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

    Can QBO help construction company/contractor, too? Moreover, how many "customer's tagged projects" can we create on QBO?

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

      Kinda.. I like QB Desktop better for this industry

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

    Thanks hector...! Hats off for the Video and all the hard work..!
    Please I do have a quick question about setting up payment terms and conditions for the customer Estimates ..!

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

    Are the Items reports only for Enterprise? My client has Premier for Contractors 2019 right now. This is my only client in desktop. I'm QBO Advanced ProAdvisor but haven't used desktop until now...construction is my niche so I'm trying to most effectively become an expert in the contractor versions for desktop :-)

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

      Premiere does the same as enterprise in item level reports...

  • @GregoryBarronVideos
    @GregoryBarronVideos 7 років тому +1

    Hello Hector,
    Great video. I like your process of creating separate invoices from an estimate (one for billing, one for revenue recognition) -- I've been keeping separate sub schedules by job and using JEs to recognize revenue. Does the Invoice for Revenue and the Invoice for Billing result in two transactions appearing in AR?

    • @HectorGarciaCPA
      @HectorGarciaCPA  7 років тому +1

      :)

    • @GregoryBarronVideos
      @GregoryBarronVideos 7 років тому

      I also sent you an email. Don't want to take up your time, but thought I'd ask about the possible double entries in AR (and a way to avoid) before experimenting.

    • @alexgonzalez8879
      @alexgonzalez8879 7 років тому

      Gregory, Did you figure this out as I have the same question.

  • @abdiqaniismail2810
    @abdiqaniismail2810 6 років тому

    hi ! this great video for creating separate invoices from an estimate but how can i record when the client pay the project . there's no invoice. can i create credit memo. looking forward to your reply. thanks

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

      No.. no credit memo.. just do customer Payment as normal

    • @abdiqaniismail2810
      @abdiqaniismail2810 6 років тому

      do you mean customer deposit?

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

      @@abdiqaniismail2810 No credit memo to be prepared. If there's no invoice, you must do the invoicing. And if there's a deposit, make a journal entry by debiting Cash in Bank or appropriate account and crediting Customer's Deposit account (treated in the Balance Sheet as Current Liability. Every time there's a progress billing, customer's deposit has to be reversed based on the percentage of completion.

  • @muhammadasif-mc2xy
    @muhammadasif-mc2xy 6 років тому

    Dear how we will record inventory..& report as contract accounts?

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

      muhammad asif create an invoice with the inventory.. at zero sales price

  • @littlibet
    @littlibet 7 років тому

    Hi Hector,
    Thank you for all the great information.
    I took QuickBooks and recently started working for a building company. I'm confused because the lady who is training me becouse I'm she is leaving, is doing 4 reports. One from QB, and two from Excel and one from Buildertrend. She ne er has time to update the Excel ones and on QB the set up is no done right.
    The customers are not set up with the projects/jobs/contracts and it's detailes. The details are entered in Excel and Buildertrend.
    Can you please help me to have a better set up on QB? I'm taking over her position and I'm new at the construction field. Thank you.

    • @HectorGarciaCPA
      @HectorGarciaCPA  7 років тому +1

      Jessica Araya i don’t know how you want me to help? Wanna Setup a consultation? If so call 954-414-1524

  • @muhammadasif-mc2xy
    @muhammadasif-mc2xy 6 років тому

    Dear Just want to ask you..ONCE we finilze the estimate & later we have more subcontractor to add actual how we will do ...also show how this cost will transfer to PNL from wIP

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

    Hector,
    We are a firm that provides staffing for Projects- do you think Contractors is the best way to use QB?

  • @muhammadasif-mc2xy
    @muhammadasif-mc2xy 6 років тому

    Dear could u suggest any other best accounts Software specifically for Contractr..?

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

    How does QuickBooks Desktop Premier for Contractors 2019 compare to Enterprise for Contractors?

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

    My IT department asked me if Enterprise was set up for Contractors. How do I do that?

  • @abdiqaniismail2810
    @abdiqaniismail2810 6 років тому

    hey hector why don't you use billing excees in complete contract method

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

      abdiqani ismail I don’t use that method often; but is an option

  • @alexis_blooming6219
    @alexis_blooming6219 6 років тому +1

    Thank you. Excellent expertise and explanation

  • @muhammadasif-mc2xy
    @muhammadasif-mc2xy 6 років тому

    Dear i have one more question..if I transfer all tha project cost to balance sheet as work in process WIP nd when i will issue tha invoice to customer than transfer all that cost to pNL is it fine..? Or not

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

      That is fine.. you can setup an item that uses that account from
      The BS

  • @muhammadasif-mc2xy
    @muhammadasif-mc2xy 6 років тому

    My questoin is..." if i have some Overheads direct relate to projects whic should be direct cost how i will account for ..? it will be same as material,labor,subcontractorrs...

  • @игрикиксик
    @игрикиксик 3 роки тому

    We are the company which provides labor for another construction companies. Example: We have 5 different jobs from Brewer Co,which will pay us 1000$ per job and we have сontractors who are working on us and we will pay them 500$ per the same job. How i can control the payment from Brewer Co and control payment for our contractors? Our contracotrs will be Vendors in QB and companies for whom we provide labor will be Customers?

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

      There is no “control” per se... but you can track it. By assigning the expenses to the job.

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

    Thank you Teacher but do you Create new company construction This lesson is very hard

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

      Abdinazir Khalif this is an advanced video

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

      @@HectorGarciaCPA
      Okey teacher I know Really Vedio Advance
      But now I have firm That Demand system Of QuickBooks And construction company
      But Idont see System contractors
      I want help me please,
      This week I promise

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

    YOU ARE SO AWESOME!!!!!!

  • @MarthaRamirez-mw3sv
    @MarthaRamirez-mw3sv 6 років тому

    Great video!
    I'm just wondering if you have other video explaining how assess the purchase for a land.
    And If I wanted the item by job name for example "trim Labor" and not by subcontractor name. Can I?
    I'll appreciate your comment.
    Thank you and keep going, you're doing a great job!!!

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

      I am not sure about the land comment..
      But you can create any items you want using any criteria; there is no limits really.

    • @MarthaRamirez-mw3sv
      @MarthaRamirez-mw3sv 6 років тому

      Sorry, the question is: "The construction company is getting a land to build a house and sell it" . How I can put it into quick book, which account I have to debit and credit?'. Thank you so much

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

      @@MarthaRamirez-mw3sv Land (proportionate) will be part of the cost of Units Available For Sale. The land will be part of the Total Project Cost.

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

      Find some video about real estate business and how it is being configured in QuickBooks.

  • @harrygaul4475
    @harrygaul4475 7 років тому

    I can do the same thing with old Peachtree Software that cost $25. Why would I spent $500 for this?

  • @jascoent3245
    @jascoent3245 7 років тому

    Wow Hector, thank you so much. Awesome & very helpful

  • @khardu
    @khardu 7 років тому +1

    I guess we can also use Architects/Engineers as classes to view their performance, or can't we.

  • @SAFACLEANINGSERVICES
    @SAFACLEANINGSERVICES 6 років тому

    IAM VERY FAMILIAR QUICKBOOK ALL TYPES AND I SET MANY COMPANISE BU I WOULD LIKE TO GIVE TIPS CONSTRUCTION QUICKBOOK

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

      There are several videos in Construction.. Check them out

  • @muhammadasif-mc2xy
    @muhammadasif-mc2xy 6 років тому

    Hi Dear Thanks i leran a alot from this video thanks dear

  • @muhammadasif-mc2xy
    @muhammadasif-mc2xy 6 років тому

    if u have 4/5 projects same time.....

  • @arabicaccountant
    @arabicaccountant 7 років тому

    thx

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

    Trust me. Use "Sage accounting" for construction software. Check out "Sage 100 contractor". Stay away from quickbooks.