Now onto the fun part!

Let’s get you set up with your very own Budget Spreadsheet. 

Head over to your Private Folder > Budget > Your Budget Spreadsheet.

Then, watch this video to understand how to set it up and get it working for you.

[VIDEO]

READ THE TRANSCRIPT AND ADDITIONAL NOTES BELOW

The tabs below show the various pages of the spreadsheet. You have your Projected Budget, your Receipts, your Actual Budget, and the Projected vs. Actual Budget. 

Projected Budget: This is your budget before  you start construction, so it is based on what your contractor will put together for you.
Receipts: Plug in the receipts of every item you purchase.
Actual Budget: This is your actual cost of the project.
Projected vs. Actual Budget: This is the difference between the projected and the actual budget.

Let's look at the Projected Budget. It is divided into phases, items within each phase and their descriptions and cost. Below is your hard cost total and your Contractor and Architect management fees. The hard costs are calculated and the managements fees are a percentage based on the total or you can delete the calculation (SUM) and add a flat rate. 

Remember: your soft costs are the documents and paperwork and the hard costs are the physical materials and labor. Typically the management fees, when based on a percentage, is based on the hard costs, not the soft (unless they are completely involved in that aspect of the project).

Then you have a total of the total.

The receipts page is a way to organize your receipts based on phase, professional, etc. You can add additional information and sort based on what ever you're looking for. Choose a column (A, B, etc.) and go to DATE >> SORT >> AZ or ZA.

Once you've kept track of your receipts, you can start plugging in your numbers into the Actual Budget spreadsheet. This will give you the actual cost of your project.

From there you can copy column D from your Projected Budget and column D from your Actual Budget over to your Projected vs. Actual Budget. This will give you the difference between the two budgets and see where your numbers were in the black or in the red.

The information provided in this spreadsheet is intended for informational and internal use only. It may contain confidential or proprietary data. Unauthorized distribution or disclosure to external parties is prohibited. Any actions taken based on the information herein are at the user's discretion. We do not guarantee the accuracy or completeness of the data, and users are encouraged to verify and validate information as necessary. By using this spreadsheet, you agree to abide by these terms. Please note that Homeowner HQ may analyze the data for the purpose of assisting others but will never share the information with external parties, ensuring data privacy.