Skip to content
Rehabbing & House Flipping

User Stats

17
Posts
1
Votes
Erin Silva
  • Real Estate Agent
  • Atlanta, GA
1
Votes |
17
Posts

Spreadsheet for Tracking Rehab Expenses

Erin Silva
  • Real Estate Agent
  • Atlanta, GA
Posted Nov 11 2016, 08:15

Hi BP!

Does anyone have a good spreadsheet template for tracking all expenses associated with rehabbing?

Best,

User Stats

340
Posts
246
Votes
Chris C.
  • Wholesaler
  • Easley, SC
246
Votes |
340
Posts
Chris C.
  • Wholesaler
  • Easley, SC
Replied Nov 11 2016, 08:37

Here is the sheet I use to manage all my rehabs. 

https://drive.google.com/open?id=1y2wnoHVg-VRfI0QY...

User Stats

17,995
Posts
17,174
Votes
J Scott
Pro Member
  • Investor
  • Sarasota, FL
17,174
Votes |
17,995
Posts
J Scott
Pro Member
  • Investor
  • Sarasota, FL
ModeratorReplied Nov 11 2016, 09:10
Originally posted by @Chris C.:

Here is the sheet I use to manage all my rehabs. 

https://drive.google.com/open?id=1y2wnoHVg-VRfI0QY...

Looks like a couple of those sheets were pulled from stuff I posted a couple years ago.  For reference, the BP Flipping/Estimating books come with better spreadsheets that are closer to what I use...

Baselane logo
Baselane
|
Sponsored
A new type of banking built for RE investors BiggerPockets Prefers Baselane The #1 Real Estate Banking platform trusted by over 40k landlords.

User Stats

340
Posts
246
Votes
Chris C.
  • Wholesaler
  • Easley, SC
246
Votes |
340
Posts
Chris C.
  • Wholesaler
  • Easley, SC
Replied Nov 11 2016, 09:31

That is correct @J Scott as my entire business model is based off your books.  I did not think of that before sharing.  Please message me if I need to remove this for copyright or other reasons.

@Erin Silva I usually do recommend J Scotts book in these situations but was quickly responding.  You will do yourself a huge favor by getting his books and utilizing his information.

User Stats

17,995
Posts
17,174
Votes
J Scott
Pro Member
  • Investor
  • Sarasota, FL
17,174
Votes |
17,995
Posts
J Scott
Pro Member
  • Investor
  • Sarasota, FL
ModeratorReplied Nov 11 2016, 09:41
Originally posted by :

Please message me if I need to remove this for copyright or other reasons.

@Erin Silva

Absolutely not!  I love the fact that the stuff I've put together is helping other investors.  Just pointing it out for others that might be interested...  :-)

User Stats

186
Posts
164
Votes
Don Petrasek
  • Real Estate Agent
  • Westlake, OH
164
Votes |
186
Posts
Don Petrasek
  • Real Estate Agent
  • Westlake, OH
Replied Nov 11 2016, 10:17

@Erin Silva  I created a spreadsheet based product that may offer you another option (also a tablet version).  Similar to what's included in this post but comes preloaded with costs and requires only minimal measuring.  I found it really time consuming to measure for every single repair in a house so automated calcs as much as I could based on room sizes.  PM me if you're interested and I'll send you links. 

Still gotta get J Scott's books seeing a lot of positive feedback here on those so I'm sure I'll learn a lot from them.  

Homewyse.com is a good source to get costs for individual repair items based on zip code if you need them for your spreadsheet.  Pretty accurate but seem to me to skew a little toward the high side.  

User Stats

2,131
Posts
690
Votes
Kuba F.
Pro Member
  • Real Estate Investor
  • Los Angeles, CA
690
Votes |
2,131
Posts
Kuba F.
Pro Member
  • Real Estate Investor
  • Los Angeles, CA
Replied Nov 11 2016, 10:33

@Chris C. That's a pretty good one.  I like your cleanup checklist.

REIkit.com Logo

User Stats

340
Posts
246
Votes
Chris C.
  • Wholesaler
  • Easley, SC
246
Votes |
340
Posts
Chris C.
  • Wholesaler
  • Easley, SC
Replied Nov 11 2016, 10:55

@Kuba F. Yea I have a tremendous amount of time in it.  It auto populates the SOW's and pretty much builds the budget.  Only thing I need now is try and decrease the amount of time it takes me to walk through a property and populate the data.  Generally spend about 2 hours getting all the data in to the sheet.  Kind of clunky trying to enter the data directly into the sheet so trying to figure out a better interface.

User Stats

4,365
Posts
1,244
Votes
Manolo D.#3 Contractors Contributor
  • Contractor
  • Los Angeles, CA
1,244
Votes |
4,365
Posts
Manolo D.#3 Contractors Contributor
  • Contractor
  • Los Angeles, CA
Replied Nov 11 2016, 16:54

Chris C. Pretty nice SS. I did a similar for SoCal, never got the time to finish it. Good to get some.

User Stats

316
Posts
133
Votes
Valerie Hiscoe
  • Investor
  • Richmond, BC
133
Votes |
316
Posts
Valerie Hiscoe
  • Investor
  • Richmond, BC
Replied Nov 12 2016, 01:34

@J Scott

I know in the past you commented favorably on 'House Flipping Spreadsheet (.com)' which has a whole host of uses such as analyzing deals, managing projects, and tracking expenses.  There's even a business plan section available.  It doesn't seem to follow your format as closely as I was hoping (I know it was developed with a fair amount of input from Bigger Pocketers), but it looks quite helpful in many ways.  Would it be something that you'd recommend? It creates shopping lists and little bonuses like that so it has a few more things than the spreadsheet that comes with your Flipping/Estimating books.  Have you looked at it lately?  Do you think it would work in with your methodology and breakdown?

@Manolo D.  What do you think?

Has anyone used it?

User Stats

1,817
Posts
829
Votes
Patrick Liska
Pro Member
  • Investor
  • Verona, NJ
829
Votes |
1,817
Posts
Patrick Liska
Pro Member
  • Investor
  • Verona, NJ
Replied Nov 12 2016, 04:02

I believe the one good thing about that spreadsheet is that it can be adjusted by the State you live in. because costs are different in every State the estimate sheet i believe is based on a multiplier for the corresponding State, as most cost estimating books are based. that program does break down a lot of information for you and i think it is a good program, one thing you may want to check is if the program updates every year with current multipliers for the States ( program is probably based on a starting average value for each thing and then the multiplier changes as prices for materials change) and you want to make sure it does that.

User Stats

17,995
Posts
17,174
Votes
J Scott
Pro Member
  • Investor
  • Sarasota, FL
17,174
Votes |
17,995
Posts
J Scott
Pro Member
  • Investor
  • Sarasota, FL
ModeratorReplied Nov 12 2016, 07:04
Originally posted by @Valerie Hiscoe:

@J Scott

I know in the past you commented favorably on 'House Flipping Spreadsheet (.com)' which has a whole host of uses such as analyzing deals, managing projects, and tracking expenses.  There's even a business plan section available.  It doesn't seem to follow your format as closely as I was hoping (I know it was developed with a fair amount of input from Bigger Pocketers), but it looks quite helpful in many ways.  Would it be something that you'd recommend? It creates shopping lists and little bonuses like that so it has a few more things than the spreadsheet that comes with your Flipping/Estimating books.  Have you looked at it lately?  Do you think it would work in with your methodology and breakdown?

@Manolo D.  What do you think?

Has anyone used it?

Yes, I still highly recommend it. I was planning to bills my own software based on my books, when I first saw houseflippingspreadsheet I decided that it was close enough to what I was going to build that there was no reason to replicate it.

It's not exactly what I would have built (like you said the methodology and format is a little different) but it's definitely just as good, if not better than I would have come up with.

User Stats

4,365
Posts
1,244
Votes
Manolo D.#3 Contractors Contributor
  • Contractor
  • Los Angeles, CA
1,244
Votes |
4,365
Posts
Manolo D.#3 Contractors Contributor
  • Contractor
  • Los Angeles, CA
Replied Nov 12 2016, 21:45

@Valerie Hiscoe I believe they sent me a sample or beta version to get a little input, or I forgot if I asked for it, but something within those lines. Those were the first couple of versions, there was only a few tabs when i got the copy --if i remember correctly, only two or three--, I believe it is more complex now, constantly adding more stuff around, for sure there was no business plan then for example. It might be useful to other states, but since I'm a contractor, AND I am in CA, the rehab part is off. I believe the buy/sell part is an easier estimate (i just figure in 10% for a 6 month project). So as far as I am concerned, I can only speak to the rehab part, it is a little off or light, also it may be that I come from commercial/government construction sector, so that might affect my opinion.

Steadily logo
Steadily
|
Sponsored
America’s best-rated landlord insurance nationwide Quotes online in minutes. Single-family, fix n’ flips, short-term rentals, and more. Great prices.

User Stats

16
Posts
12
Votes
Nick Gaines
  • Rental Property Investor
  • Champaign, IL
12
Votes |
16
Posts
Nick Gaines
  • Rental Property Investor
  • Champaign, IL
Replied Mar 27 2018, 19:57

@J Scott - Does your book come with digital spreadsheets? Are they available somewhere else for download?

User Stats

17,995
Posts
17,174
Votes
J Scott
Pro Member
  • Investor
  • Sarasota, FL
17,174
Votes |
17,995
Posts
J Scott
Pro Member
  • Investor
  • Sarasota, FL
ModeratorReplied Mar 28 2018, 05:53
Originally posted by @Nick Gaines:

@J Scott - Does your book come with digital spreadsheets? Are they available somewhere else for download?

If you purchase the book package (either digital or physical) from BP, it comes with a bunch of digital files, including SOW templates, contract template, chart of accounts, etc.

User Stats

16
Posts
12
Votes
Nick Gaines
  • Rental Property Investor
  • Champaign, IL
12
Votes |
16
Posts
Nick Gaines
  • Rental Property Investor
  • Champaign, IL
Replied Mar 28 2018, 08:38

Awesome. Thanks for the response @J Scott.

User Stats

2
Posts
0
Votes
Replied Apr 30 2018, 20:04

Hello, J Scott is there is fee to use these spreadsheets?

Also, what is your opinion of houseflipplingspreadsheet.com?

Thank you,

Dave

User Stats

1
Posts
0
Votes
Replied Sep 14 2018, 21:19

Awesome. Thank you community!  Just what I've been searching for. 

User Stats

8
Posts
0
Votes
Chenping Ni
  • Naperville, IL
0
Votes |
8
Posts
Chenping Ni
  • Naperville, IL
Replied Nov 3 2018, 19:49

@J Scott I have bought both of your books on flipping and Estimating Rehab Costs. For the estimating rehab costs book, there is a table in section 4 from p.201-p.216. Is there any digital version of that table downloadable? 

Thank you very much,

Bob

User Stats

8
Posts
0
Votes
Chenping Ni
  • Naperville, IL
0
Votes |
8
Posts
Chenping Ni
  • Naperville, IL
Replied Nov 4 2018, 07:43

@J Scott @Chris C. I have downloaded both Chris's version and 123flip.com lite version, I do not see all 25 components (from the  book) on the spreadsheet. I may miss something.

User Stats

8
Posts
0
Votes
Chenping Ni
  • Naperville, IL
0
Votes |
8
Posts
Chenping Ni
  • Naperville, IL
Replied Nov 4 2018, 07:45

@Everyone, From your experience, what is the average ratio between labor expense and material expense for a successful flip project?   What factors effect the ratio?  

Thank you very much in advance for providing any insight on this.

Bob

User Stats

17,995
Posts
17,174
Votes
J Scott
Pro Member
  • Investor
  • Sarasota, FL
17,174
Votes |
17,995
Posts
J Scott
Pro Member
  • Investor
  • Sarasota, FL
ModeratorReplied Nov 4 2018, 08:33
Originally posted by @Chenping Ni:

@J Scott I have bought both of your books on flipping and Estimating Rehab Costs. For the estimating rehab costs book, there is a table in section 4 from p.201-p.216. Is there any digital version of that table downloadable? 

Thank you very much,

Bob

 I sent you a PM...

User Stats

17,995
Posts
17,174
Votes
J Scott
Pro Member
  • Investor
  • Sarasota, FL
17,174
Votes |
17,995
Posts
J Scott
Pro Member
  • Investor
  • Sarasota, FL
ModeratorReplied Nov 4 2018, 08:35
Originally posted by @David Alexander:

Hello, J Scott is there is fee to use these spreadsheets?

Also, what is your opinion of houseflipplingspreadsheet.com?

Thank you,

Dave

Sorry for the delay...just saw this...

The spreadsheets come as part of the Flipping/Estimating book package if you purchase on BP.  There is no fee to use the spreadsheets.

As for HouseFlippingSpreadsheet.com, I'm a big fan of the product.  I was going to build something similar, but Dave Robertson beat me to it, and there was no reason to build another product that would have been so similar.

BiggerPockets logo
BiggerPockets
|
Sponsored
Find an investor-friendly agent in your market TODAY Get matched with our network of trusted, local, investor friendly agents in under 2 minutes

User Stats

340
Posts
246
Votes
Chris C.
  • Wholesaler
  • Easley, SC
246
Votes |
340
Posts
Chris C.
  • Wholesaler
  • Easley, SC
Replied Nov 6 2018, 14:16

@Chenping Ni  

Just so there is no confusion, J Scott has no affiliation with the spreadsheet I built. My spreadsheet is custom built for my needs loosely based on J Scott's books and philosophy. I share it for free to those who request it for ideas if you want to build something similar. Unless you have strong coding and spreadsheet skills (and lot's of time) I recommend following J Scott's advice. 

User Stats

8
Posts
0
Votes
Chenping Ni
  • Naperville, IL
0
Votes |
8
Posts
Chenping Ni
  • Naperville, IL
Replied Nov 6 2018, 16:08

@Chris C. Thank you very much!

Bob

User Stats

8
Posts
0
Votes
Chenping Ni
  • Naperville, IL
0
Votes |
8
Posts
Chenping Ni
  • Naperville, IL
Replied Nov 6 2018, 16:09

@J Scott Thank you very much for your help!

Bob