A cost sheet is the CSV file of dollar values that Due Diligence uses to calculate estimated repair and replacement costs for items inspected during your Unit Walks. Update it when your pricing changes, then send it to the Due Diligence Support team, who upload it and regenerate your cost-related reports.

🎬 Watch it in action: Watch: Update Property Emergency and Technician Notes

🎬 Watch it in action: Watch: The Hidden Cost in Your Service Contracts

  Only the Due Diligence Support team can apply cost sheet updates

At this time, only the HappyCo Due Diligence Support team can apply updates to cost sheets and regenerate cost-related reports. Submit your completed cost sheet through a Due Diligence Service Request, and the team handles the upload from there.

Before you update a property cost sheet

  • Reports must already be generated for your Order.
  • The property cost sheet only becomes available after reports are created.
  • To generate and view reports, see Due Diligence: Running Reports.

Update a property cost sheet

1.  Download the property cost sheet

Open the Google Drive where your reports are stored and download the file named [PropertyName]_Cost_Sheet.csv.

2.  Enter costs in Column F

Update the Cost column (Column F) with numbers only. Leave out dollar signs ($), text and special formatting. For instance, enter 150, not $150.

3.  Clear a cost with 0

To clear a value, replace it with 0.

  Tip

$0 costs do not appear in reporting.

4.  Save the file as CSV

Save the file as a CSV, not Excel.

  Tip

Sorting and filtering during your edits is fine. Save in CSV format when you are done.

5.  Attach it to a Service Request

Attach the updated cost sheet to a Service Request on your Order.

  Tip

See Due Diligence: How to Create a Service Request for where to place the request.

  Do not modify Columns A through E

Column A (ID) is the unique identifier the system uses to apply each cost to the correct section, item and rating. If Columns A to E are altered, the upload will not work correctly. Only edit Column F.

  Set a cost on every item row

Column F takes a cost on every inspection item row. You must set the cost on each row, not once per section.

Request a business-wide cost sheet

The Due Diligence Support team must pull the business-wide cost sheet for you. To request one, submit a Service Request or email dd@happy.co.

Update a business-wide cost sheet

1.  Open the business-wide cost sheet

Open the cost sheet provided by the Due Diligence Support team.

2.  Enter costs in Column F

Update the Cost column (Column F) with numbers only. Leave out dollar signs ($), text and special formatting.

3.  Clear a cost with 0

To clear a value, replace it with 0.

  Tip

$0 costs do not appear in reporting.

4.  Save the file as CSV

Save the file as a CSV.

  Tip

Sorting and filtering is fine.

5.  Email the file to the Due Diligence team

Send the updated file to dd@happy.co.

  Tip

The team handles the upload and confirms once it is complete.

  Update business-wide costs once or twice a year

Business-wide updates apply automatically to all properties using those templates, so property-level edits should be minimal once they are set. Updating more often than once or twice per year can become cumbersome and may need extra coordination across reports.

  Apply new costs to past projects

If you want updated business-wide costs applied to previous Due Diligence projects, say so when you submit your sheet. The team can apply the changes to past reporting as well.

What happens after you submit your cost sheet

  • The Due Diligence Support team uploads it on your behalf.
  • The team regenerates any cost-related reports tied to the update.
  • You receive a confirmation that everything is updated and reports are ready to view.

Troubleshooting: costs not showing in reports

  • Check you are looking at the latest reports. Support regenerates them after the upload.
  • Check Columns A to E are unchanged. A row with a changed ID in Column A is skipped and keeps its old cost.
  • Check Column F holds numbers only. Anything that isn't a number becomes $0, and $0 items don't appear in reports.
  • Check the file was saved as CSV.
  • If all of that looks right, reply on your original Service Request and say which items or reports are wrong.

  A changed ID gives no error message

There is no error today when a row's ID in Column A was changed. The row is silently skipped and keeps its old cost; it doesn't show $0 or blank.

Frequently asked questions

I haven't received a confirmation. Should I submit a new Service Request?

No. Reply to your original Service Request for anything about a cost sheet you already sent: no confirmation, wrong costs or missing items. Submit a new Service Request only when you are sending a new or revised cost sheet.

What should I include if I follow up outside the Service Request?

Reply on the original Service Request if you can, since it already has your order, property and cost sheet attached. If you write in separately, include:

  • Property name (and section, if the property is split into sections)
  • Customer or business name
  • Your request number, or the date you submitted the sheet
  • The name of the cost sheet file you sent
  • Which report or item isn't showing the cost you expected

What is a cost sheet?

A cost sheet is a CSV file that contains the dollar values applied to specific inspection items, based on the condition (rating) assigned during the Unit Walk. When cost-related reports are generated, the platform pulls from the cost sheet to populate the values.

The two types of cost sheet
Type Covers Best for
Property cost sheet A single property: only the inspection items from the template assigned to that property One-off updates or property-specific pricing
Business-wide cost sheet All inspection templates available to your business; updates apply to all properties using those templates Setting standard costs across properties

When are costs applied?

In most cases, assign costs only to items with a Repair or Replace condition rating.

One common exception: if your team always removes carpet during turnover, it is fine to assign costs to Type items with Carpet, regardless of condition.

What's coming next

Improvements are in progress to make the cost sheet workflow customer-facing in a future Due Diligence update. There is no release date to share yet.

Contact the Due Diligence team

  Related articles

Was this article helpful?
0 out of 0 found this helpful