HECTOR! You are such a good teacher. Exactly what I needed to see today. I appreciate your going in depth and using solid examples for the construction industry. So many QB teachers water EVERY single thing down so much that it hardly relates to real work-life examples.
This video just helped me solve a major problem I have had :) I am in the staffing business, and we have to invoice against POs issued by our larger clients, AND the clients want us to track their spend against the POs and notify them when the balance remaining hits certain points. I can create estimates to represent the POs from the client, use the PO number as the name of the job, and then do progress invoicing and run reports showing percentage depletion and dollars remaining.
Excellent video! Would you recommend using this method for construction loans? How do you incorporate the long term liability loan? Do you bill for each draw?
So when I click on Create Invoice and select create invoice for selected items or for different percentages and hit okay nothing from the invoice is pulling over. Why is this?
How to create invoices in quickbooks for patients and insurance companies? Can we check separately patients accounts and insurance companies accounts receivable?
Hi Hector! I wanted to ask if Quickbooks Desktop has a way to create an estimate/sales order/invoice or any, for this matter, that can make the rows auto-adjust to print only the parts where there is input and stop printing after the subtotal/total? I want to use continuous paper and printing an entire page with just a few items seems wasteful, and reprinting the info from the 1st page to the next also seems redundant. Can you help me with this?
Help with project estimates and applying payments from the customer. I want to drive the payment to a specific line item on the estimate, thus showing the numbers reduce over time. I am using QB Online. I know I may need to convert the estimate to an invoice but want the payments to be applied to the sub contractor I need to pay. Is there a video for this or a training I can take?
Thank you Hector. I enjoyed your video about progess invoicing and it makes sense. However, you mention to not use changes to estimates as Change Orders. Do you have other videos about change orders? I understand you are saying to create a separate estimate under the same job, but I have an example where the "change order" results in a negative amount. QB won't save a negative invoice. How should we handle this? Secondly, do you have videos on Sales Orders. I don't use them and am curious if they would help. I am responsible for bookeeping of a Landscape company and they use progress invoices, estimates, and we also prepare pay apps A1A forms for our customers. Do you have recommendations or do you offer individual trainging?
How can progress invoicing be done on a "not to exceed contract"? Customer gives us PO for not to exceed amount but it is a general PO where the line item services are not specified until the work is done. Help please! Thank you!
Hector, I’ve created already a progress invoice for the remaining 50% of the job and the builder only paid a portion of it which left a balance owing. How do I now invoice for that remainder after 100% of each item has been billed already?
Can you set due dates for progress invoicing? We clean commercial properties several times per month and invoice monthly, but we want to start estimating for the annual cost since our contracts are annual.
How do you change the % for progressive invoice. I'm trying to charge 50% which it did on the first invoice but won't let me change it for second invoice. Stays on 100%
Having a lot of trouble with my QBD, lost invoice, two estimates and double credit on customers!! I need help. Why is my QBD acting up so baddd! Help anyone? Plz
Hi, is there any way to change the rounding in the total when creating an invoice? It always rounds it a penny extra. I’ve been trying to find it but i can’t. thank you!
Hi, I have a problem with creating an invoice. When I create an invoice automatically the amount is round up and the actual amount can not appear in the invoice. Plz advised me how to get an actual amount on the invoice. And there is no sense that can be appeared in the total of the invoice. It is just like QR.250. So I hope to answer in this 02 problems from you. Thanks.
Love this video, thank you for sharing! Could you please do a vide on invoicing clients on a legal advance payment. What happens is I hAve to bill clients for a legal advance before we actually receive the bill from the lawyer, then when I get the bill I again have the option to invoice the client, but I like that we can send an estimate. I just want to be able to track how much legal we have sitting with us for the client and then use that money to apply to each legal invoice that comes in for that job and then see what is left for the client. If that makes sense, please explain if you have any ideas I would appreciate it that! Thank youu 🤗
Thank you Hector. Accounting for contractors can be a challenge. If I may suggest possible future subjects: Retention Billing & Percentage Completion Accounting.
Can you update to include changes to the estimate? You touch on it at the end of this video but I'm looking for more information. Specifically, when the estimate goes down after invoices have already been issued. When I make this change, it adjusts the invoices and shows prior billing in the first invoice that didn't occur and throws off the prior billing amounts so I always look overbilled. Help!
@@HectorGarciaCPA right but when I change the estimate it adjusts the prior billing inversely on the first invoice. So if I adjust the estimate down after invoice 3, the 4th invoice shows I've billed at 103% so I adjust current billing to -3%, it takes that 3% amount and adjusts the first invoice to have a prior billing of that same amount credited on the 4th invoice.
Hector, WONDERFUL instruction!!! I work for a construction company. Can I create a -1, -2, -3 for Change Orders? Oftentimes, we have a change to the regular schedule. How can I create, from the original invoice #7820, a 7820-1, 7820-2, 7820-3? Thank you!
This video is amazing. Thank you!!! I do have a question about profit and loss accurate reporting after removing the markup on the actual inventory item. Is there a way to still accurately reflect reporting later on?
Is there a way to progress invoice without showing each item such as labor, etc? i just want to show a lump sum for the service. The estimate is for $100,000.00 in that estimate $20,000 is for labor. In order to job cost this project I needed to enter a line item for labor-$20,000 and Concrete - $80,000. However I don't want the customer to see that.
What if you don't want to add the sales tax until the final invoice of your progress invoicing? Is there any way to do that? I tried so many different ways to think around quickbooks procedure.
Hi Hector. Loved this video...very detailed information for a person like me who is learning as I go along. I have an issue with progress invoicing though. I sometimes need to do 2-3 progress invoices before I do the final one. Somehow my 2nd or subsequent invoices do not reflect the payments applied from the prior invoices. I always use the estimate to create all my invoices and not once does it populate. Is that something you can help me with? So the problem is when I send invoice #2, it should actually tell my customer that there was a payment of $ to invoice #1 and this is a second progress invoice.
hey hector question: the between window from estimate to partial invoice is there any way i can have there the item description column as well? sometimes i have to wrote a customized item which is not on my list or some items are just numbers and i cant tell what they are just from the item and i dont know which item to bill for how much
hi How can i add on line items on to and invoice so all i have to do is add the progress. it seems i have to add it onto the estimate then create another invoice it seems it locks out the percentage unless i start it from beginning
Hi, we use open sales order report for production scheduling for products, does the progressive invoicing then affect the sales order item report if we took a deposit? how do we handle that? thanks!
Hector Garcia CPA what is the process flow then? (we are manufacturer)if we receive a custom PO or want to get a deposit for a new project? each has to have an estimate, then we create sales order and partial invoice off of estimate?
@@HectorGarciaCPA is it possible to speak to you directly? I know QB from previous industries but now do custom homes. Moving books over January 2021 from custom job costing system. Do I make a customer for each home and then a job too? or do I make the Customer the name of the community I am building in and then make a job for each home? We build in 4 communties.
in the beginning you said it is important that we know the cost of items, but what about the engineering services our company engineers provide during project dont have any cost, what to do about that?
Hector Garcia CPA i usually do it by charging their saleries expense to that specific job for the month they work on the project. Beside i link their hotel expenses also to the project. Please correct me if I am wrong. You are the best tutor.
Thank you Hector for your helpful videos! I just started using progress invoicing for a recent remodeling project which has worked fine until I went in and made some changes to the item list. (Adding a couple of new items and editing a current item) Now the % are off on those items and I'm not sure how to fix it other than going back in and deleting each of the invoices since those changes. This is a $250k job so it's a little involved. Can you offer any advice?
I have the same problem. If there is an error made on the invoice the percentages are completely off and the only solution I’ve found is to delete all invoices and start over. 😫 there’s no way to easily fix the percent of prior billed.
HECTOR! You are such a good teacher. Exactly what I needed to see today. I appreciate your going in depth and using solid examples for the construction industry. So many QB teachers water EVERY single thing down so much that it hardly relates to real work-life examples.
:)
This video just helped me solve a major problem I have had :) I am in the staffing business, and we have to invoice against POs issued by our larger clients, AND the clients want us to track their spend against the POs and notify them when the balance remaining hits certain points. I can create estimates to represent the POs from the client, use the PO number as the name of the job, and then do progress invoicing and run reports showing percentage depletion and dollars remaining.
Great!
Great video; Good to see reports and different invoice formats that fit for job costing.
I've been working with QuickBooks for years but still, I just learned some things, thank you :)
Happy to help! thanks
This really helped. Thank you for the details
Where have you been all my life?! Seriously, great help!
You welcome.
Excellent thanks!
Thanks
Excellent job! Just what I needed. Thanks.
Scott Schlesinger great! Thanks
Excellent video! Would you recommend using this method for construction loans? How do you incorporate the long term liability loan? Do you bill for each draw?
No. A loan is managed under a different context
So when I click on Create Invoice and select create invoice for selected items or for different percentages and hit okay nothing from the invoice is pulling over. Why is this?
How to create invoices in quickbooks for patients and insurance companies?
Can we check separately patients accounts and insurance companies accounts receivable?
Hi Hector! I wanted to ask if Quickbooks Desktop has a way to create an estimate/sales order/invoice or any, for this matter, that can make the rows auto-adjust to print only the parts where there is input and stop printing after the subtotal/total? I want to use continuous paper and printing an entire page with just a few items seems wasteful, and reprinting the info from the 1st page to the next also seems redundant. Can you help me with this?
thank you. I had never interim billed before but now I can!
Super helpful. Appreciate the tutorial.
+Ali Jarvis :)
This was very helpful Thank you
Great :)
Help with project estimates and applying payments from the customer. I want to drive the payment to a specific line item on the estimate, thus showing the numbers reduce over time. I am using QB Online. I know I may need to convert the estimate to an invoice but want the payments to be applied to the sub contractor I need to pay. Is there a video for this or a training I can take?
You cant just pay an item
It is still helpful in 2021! Thanks!
Thank you Hector. I enjoyed your video about progess invoicing and it makes sense. However, you mention to not use changes to estimates as Change Orders. Do you have other videos about change orders? I understand you are saying to create a separate estimate under the same job, but I have an example where the "change order" results in a negative amount. QB won't save a negative invoice. How should we handle this? Secondly, do you have videos on Sales Orders. I don't use them and am curious if they would help. I am responsible for bookeeping of a Landscape company and they use progress invoices, estimates, and we also prepare pay apps A1A forms for our customers. Do you have recommendations or do you offer individual trainging?
Very good instructions for progress invoicing with QuickBooks
Thanks..
How can progress invoicing be done on a "not to exceed contract"? Customer gives us PO for not to exceed amount but it is a general PO where the line item services are not specified until the work is done. Help please! Thank you!
There is no way to create those limits in QB
THANK YOU! okay so what do I do if I want to add a change order to the contract. Do I just add that as a line item to the estimate?
Hector, I’ve created already a progress invoice for the remaining 50% of the job and the builder only paid a portion of it which left a balance owing. How do I now invoice for that remainder after 100% of each item has been billed already?
Hey Victor .. Gracias
Can you set due dates for progress invoicing?
We clean commercial properties several times per month and invoice monthly, but we want to start estimating for the annual cost since our contracts are annual.
Every invoice you create can have its own due date. But you cannot setup the due dates at the estimate level
How do you change the % for progressive invoice. I'm trying to charge 50% which it did on the first invoice but won't let me change it for second invoice. Stays on 100%
Having a lot of trouble with my QBD, lost invoice, two estimates and double credit on customers!! I need help. Why is my QBD acting up so baddd! Help anyone? Plz
Hi, is there any way to change the rounding in the total when creating an invoice? It always rounds it a penny extra. I’ve been trying to find it but i can’t. thank you!
Hi, I have a problem with creating an invoice. When I create an invoice automatically the amount is round up and the actual amount can not appear in the invoice. Plz advised me how to get an actual amount on the invoice. And there is no sense that can be appeared in the total of the invoice. It is just like QR.250.
So I hope to answer in this 02 problems from you. Thanks.
Can’t avoid the rounding.
Love this video, thank you for sharing! Could you please do a vide on invoicing clients on a legal advance payment. What happens is I hAve to bill clients for a legal advance before we actually receive the bill from the lawyer, then when I get the bill I again have the option to invoice the client, but I like that we can send an estimate. I just want to be able to track how much legal we have sitting with us for the client and then use that money to apply to each legal invoice that comes in for that job and then see what is left for the client. If that makes sense, please explain if you have any ideas I would appreciate it that! Thank youu 🤗
This was very helpful.
+Martha Studebaker :)
love this vedio. cleared every thing in detail. Thanks
thanks
Thank you Hector. Accounting for contractors can be a challenge. If I may suggest possible future subjects: Retention Billing & Percentage Completion Accounting.
Good topics.. thanks
Can you update to include changes to the estimate? You touch on it at the end of this video but I'm looking for more information. Specifically, when the estimate goes down after invoices have already been issued. When I make this change, it adjusts the invoices and shows prior billing in the first invoice that didn't occur and throws off the prior billing amounts so I always look overbilled. Help!
you would need to manually update the estimate if you need to do that
@@HectorGarciaCPA right but when I change the estimate it adjusts the prior billing inversely on the first invoice. So if I adjust the estimate down after invoice 3, the 4th invoice shows I've billed at 103% so I adjust current billing to -3%, it takes that 3% amount and adjusts the first invoice to have a prior billing of that same amount credited on the 4th invoice.
Has este video en espanol please
Awesome video well explained. Thank you very much Hector.
Wolf E Wolf thanks.. and you welcome
Thank you!
Hector, WONDERFUL instruction!!! I work for a construction company. Can I create a -1, -2, -3 for Change Orders? Oftentimes, we have a change to the regular schedule. How can I create, from the original invoice #7820, a 7820-1, 7820-2, 7820-3? Thank you!
Olivia Banales you can manually just change the form number
Great Video! When using Progress Invoicing, can you use the 'Add Time/Costs' function to add Items when using progress invoicing?
Yes.. click on Button on the top ribbon
This video is amazing. Thank you!!! I do have a question about profit and loss accurate reporting after removing the markup on the actual inventory item. Is there a way to still accurately reflect reporting later on?
The profit will show based on what was actually posted as expenses for the job vs the income
How do I print a progress report so I can see the different percents on the invoice or a report?
Accounts Payable there is no report per invoice
Is there a way to progress invoice without showing each item such as labor, etc? i just want to show a lump sum for the service. The estimate is for $100,000.00 in that estimate $20,000 is for labor. In order to job cost this project I needed to enter a line item for labor-$20,000 and Concrete - $80,000. However I don't want the customer to see that.
Yes.. with item groups..
What if you don't want to add the sales tax until the final invoice of your progress invoicing? Is there any way to do that? I tried so many different ways to think around quickbooks procedure.
Mel Saltis just keep everything non taxable.. just make the last invoice with the total taxable
Hi Hector. Loved this video...very detailed information for a person like me who is learning as I go along.
I have an issue with progress invoicing though. I sometimes need to do 2-3 progress invoices before I do the final one. Somehow my 2nd or subsequent invoices do not reflect the payments applied from the prior invoices. I always use the estimate to create all my invoices and not once does it populate. Is that something you can help me with? So the problem is when I send invoice #2, it should actually tell my customer that there was a payment of $ to invoice #1 and this is a second progress invoice.
Hey was this figured out? I would also like to know
hey hector
question: the between window from estimate to partial invoice is there any way i can have there the item description column as well?
sometimes i have to wrote a customized item which is not on my list or some items are just numbers and i cant tell what they are just from the item and i dont know which item to bill for how much
Can’t be customized....
Thank you. It was very helpful.
Awesome! Thanks
hi How can i add on line items on to and invoice so all i have to do is add the progress. it seems i have to add it onto the estimate then create another invoice it seems it locks out the percentage unless i start it from beginning
Correct.. estimate first.
Can I just add my product manually without putting it into inventory list. I tried and I cant tab over to quantity or cost....!?
You need to add it to the list!
Is there anyway to convert an invoice into a progress invoice?
No
Really good...Thanks so very much!!!
Laureen Slater thank you!
Very helpful, thanks!
You welcome
Thank you for these!
+John Gerlach you are welcome
Am really happy for your instructions. How can i grate Targets vs Actual s for each account. will really appreciate
That would be a budget
@@HectorGarciaCPA okay, but will budget break it to monthly? Because I set targets on each item and each account daily
fredrick langat you can run the report for a specific month... but not a report with monthly figures containing multiple months
@@HectorGarciaCPA Thanks
Hi, we use open sales order report for production scheduling for products, does the progressive invoicing then affect the sales order item report if we took a deposit? how do we handle that? thanks!
mnminnmn no it doesn’t
Hector Garcia CPA what is the process flow then? (we are manufacturer)if we receive a custom PO or want to get a deposit for a new project? each has to have an estimate, then we create sales order and partial invoice off of estimate?
mnminnmn with progress Invoicing; there is no workflow with Sales Order.. Just estimate/Invoice
how can i watch the 3 day virtual? the link says no longer valid?
Lori Burton sorry, link changed: hectorgarcia.teachable.com/p/quickbooks-desktop-basics
@@HectorGarciaCPA is it possible to speak to you directly? I know QB from previous industries but now do custom homes. Moving books over January 2021 from custom job costing system. Do I make a customer for each home and then a job too? or do I make the Customer the name of the community I am building in and then make a job for each home? We build in 4 communties.
in the beginning you said it is important that we know the cost of items, but what about the engineering services our company engineers provide during project dont have any cost, what to do about that?
MUHAMMAD BILAL you can put your labor cost there as well.. there is no restriction
Can i put the labor or engineering cost zero as they are not outsourced but rather permanent employees?
MUHAMMAD BILAL you can.. but i would put the internal cost either way
Hector Garcia CPA i usually do it by charging their saleries expense to that specific job for the month they work on the project. Beside i link their hotel expenses also to the project. Please correct me if I am wrong. You are the best tutor.
MUHAMMAD BILAL you are Not wrong
Thank you Hector for your helpful videos! I just started using progress invoicing for a recent remodeling project which has worked fine until I went in and made some changes to the item list. (Adding a couple of new items and editing a current item) Now the % are off on those items and I'm not sure how to fix it other than going back in and deleting each of the invoices since those changes. This is a $250k job so it's a little involved. Can you offer any advice?
I don’t know if I can without looking at it... so many moving parts.
I have the same problem. If there is an error made on the invoice the percentages are completely off and the only solution I’ve found is to delete all invoices and start over. 😫 there’s no way to easily fix the percent of prior billed.
Koaloctopus Smith correct delete and recreate
nice, you guru.
+Somen Mondal :)
Thank you
+banadir computer :)
Great video Hector! How would you add a retention column in the progress invoice? Many times we have 5-10% held on our payment.
Im trying to do an invoice but it wont let me apply the taxes what can i do...
Apply the taxes? I don’t know what you are talking about? Are you outside of US?
Buddy you need to pump up the volume
Thanks For the feedback.
your voice is low sir plz improve on that otherwise thank u
Thanks for feedback