Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
pkelly22
Level 2

Costs on Est vs Act Report without a Bill

We are a construction company and one of our charges on every estimate is a "reuse fee" for the plans they chose us to build. How do I get this cost to show on the Estimate vs Actual report without an actual bill? We need it to appear on this report as we share this report with our clients.

5 Comments 5
LouiseG
QuickBooks Team

Costs on Est vs Act Report without a Bill

To display the cost on the  Estimate vs. Actual report without an actual bill, you can enter the fee as a non-inventory item on the estimate. 

Please note that the estimate cost will not appear in the Actual Cost column because estimates are considered as non-posting transactions. Actual cost, on the other hand, are based on real transactions such as vendor bills that directly impact your financial records. 

Here’s how:
 

  1. Go to Lists, then Item List.
  2. Click the drop-down arrow beside the Item and then New.
  3. Select Non-inventory Part as the type.
  4. Enter Reuse Fee in the Item Name/Number field.
  5. Fill out the necessary details.
  6. Hit OK.


Once done, when you create an estimate. Add the Reuse fee item that you’ve created, then generate the Item Estimate vs Actual Report. Please see the attached screenshot below:

 

Don't hesitate to revisit this thread if you have additional questions.

pkelly22
Level 2

Costs on Est vs Act Report without a Bill

Thank you! I have been able to get it to show as part of the Estimate on the report (under hte Est. Cost column), but I can't get it to show under the "Act. Cost" column. We share this report with our clients, so I need them to see that they have been charged the Plan Reuse Fee as well. Any idea how to show it under the Actual Cost without a bill?

Rusimyhr
QuickBooks Team

Costs on Est vs Act Report without a Bill

I appreciate the follow-up, @pkelly22.
 
While it’s not possible to display costs under the Act. Cost column without creating a posting transaction, there is a way to ensure accurate reporting and alignment in your Estimate vs. Actual Report.

The Estimate transactions are non-posting and will only appear under the Est. Cost column. To reflect costs under the Act. Cost column, QuickBooks requires a posting transaction, such as an invoice, bill, check, or journal entry, as these directly impact your financial records. Also, using Inventory Items instead of Non-inventory Items allows for better tracking of both estimated and actual costs, making it ideal for job costing purposes. By converting your estimate to an invoice and utilizing Inventory Items, you can ensure that your costs are accurately reflected in the report, providing both transparency and consistency for your financial records.
 
Let us know if you have additional questions or need assistance with QuickBooks.
pkelly22
Level 2

Costs on Est vs Act Report without a Bill

Thank you. I do understand this and have no problem getting it to show as part of the Estimate. I really just need to find a way for it to show under the Actual Costs column. You mentioned Journal Entry. Is there a way to create a Journal Entry that will show the cost under the Actual Costs column on the Est vs Act report? As mentioned with the previous support received, this specific report is shared with our customer, so they need to see what that actual cost is to track their costs associated with the job (we bill our customers the actual costs of the job plus a management fee, so it is open-book). Thank you!

JeveeAdvin__la
QuickBooks Team

Costs on Est vs Act Report without a Bill

Hi, Kelly. To display information in the Actual Cost column of the Estimate vs. Actual Cost report in QuickBooks Desktop (QBDT), you can create a zero-dollar check. This allows the data to appear in the report without inflating expenses.

 

While we can technically create a Journal Entry (JE) to record costs, it will not effectively reflect in the Actual Costs column on the Estimate vs. Actual report because we can only choose accounts in JEs; therefore, they can't be tied to the Reuse fee item created.

 

Here's how you can write a zero-dollar check:

 

  1. Go to the Banking menu and select Write checks.
  2. Leave blank the Pay to the Order field.
  3. Start with the Items tab, and select the Reuse fee item created.
    1. From Customer: job dropdown, choose the customer or job.
    2. Ensure that the Billable checkbox is unticked.
  4. Go next to the Expenses tab and choose the expense account you've used for the Reuse fee item.
    1. Enter the same amount as the item you've selected, but this time as a negative value.
  5. Save the check.

 

Once done, run the Estimate vs. Actual cost report to verify that the amount is displayed under the Actual Cost column.

 

  1. Navigate to the Reports menu.
  2. Go to Jobs, Time & Mileage.
  3. Select Estimates vs. Actuals Detail.

 

In the report, you'll see a comparison between the estimates you entered earlier and the actual costs incurred based on the checks, bills, or other vendor transactions tied to the job.

 

Please don't hesitate to reach out if you have any additional questions or concerns. We're here to provide ongoing support and assistance.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us