Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Can someone please speak to the data mapping of Estimate data? When I create an estimate, my expectation is that the amount in the TOTAL column (in the estimate) should populate to the EST. COST column on the "Job Estimates vs. Actual Detail" report and it does not. A value only populates to the report when I put a 1 in the rate column on the estimate. Why is that???? The data mapping should be pulled from the TOTAL column on the estimate directly to the EST COST and it doesn't. I called CS and he was useless. Couldn't tell me a thing...tried to tell me that there needed to be a value in an Item...eye roll...when I explained to him that many items don't have values because they change for every job...that went over his head. I'm hoping someone can explain it here.
I can see the confusion you have about the mapping of estimates in QuickBooks Desktop (QBDT), @pandregg. I appreciate you bringing this to our attention, and I'm here to help clarify the situation.
Please know that when setting up an item in QuickBooks, you have the option to assign a specific rate to an item. If you include this item in an estimate, the assigned rate will determine how it appears when you run the Job Estimates vs. Actuals Detail report in QBDT.
On the other hand, if an item does not have a rate in the setup, QuickBooks will be unable to calculate its contribution to the total estimated cost automatically. That said, you'll want to manually input a rate on your estimate for it to be considered in the reporting.
Furthermore, once your estimate proposal is approved, you can easily convert it into an invoice, ensuring a smooth transition from estimating costs to billing your customer.
You can ask them to select Pay Now in the email to pay online. Alternatively, you can also process the payment for them and match it to their invoice.
If there's anything else I can help you about estimates in QBDT, you can always click the Reply button for a follow-up. I'll make sure to respond. Take care.
Thanks for the reply but there's a deeper issue going on with my data. I had an estimate that had no value in the QTY column for some items. For items that had no value in the QTY column those columns didn't appear on the EST vs. ACT report. I added a 1 to the QTY column on the estimate and the TOTAL value appeared in the EST column on the report. BUT....I have another estimate where I've used the SAME items and did NOT have a 1 in the QTY column on the estimate BUT the TOTAL value appeared in the EST column on the report. Why would the report data appear correctly for some estimates but not for others when the same items are used? Additionally, for the estimate where the values appeared on EST column in the report, there were some items that didn't appear...they came up as zeros. I deleted the item from the estimate, readded it and now it appears on the report. There's definitely something funky going on....
Based on the information provided, it appears that the issue may be associated with your data files, Pandregg.
Let's use the verify and rebuild tools in QuickBooks Desktop (QBDT) to address why some items with or without quantity in your estimates appear in your Job Estimates vs Actual Detail Reports.
The verify tool locates the problems in a company file, and then the rebuild tool fixes them. To start the process, check your company file data using the verify tools. Kindly follow the steps provided below:
Furthermore, if you have to rebuild the data in your company file, here's a step-by-step guidelines on how to execute it:
Additionally, you can refer to this article for more details on fixing your company data files: Verify and Rebuild Data in QuickBooks Desktop.
Moreover, I have gathered these articles for you to use in generating reports according to your business needs and preferences:
If any technical issue arises, know that the Community is available to assist you 24/7, Pandregg. Keep safe!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here