All Forum Posts by: Harman N.
Harman N. has started 40 posts and replied 124 times.
Post: Getting an occupied property vacant for a flip

- Rental Property Investor
- San Francisco, CA
- Posts 126
- Votes 74
Hi all,
I'm wondering how to get an occupied property vacant before a flip, especially if you're out of state? For a BRRRR I can use my property manager since he'd be managing it post-rehab, but for a flip the PM wouldn't have any incentive.
- Harman
Post: What paper docs to keep? Title, insurance policy, loan paperwork?

- Rental Property Investor
- San Francisco, CA
- Posts 126
- Votes 74
Hi all,
Is there any need to keep any paper documents related to investment properties? I have a drawer over-stuffed with purchase and finance paperwork and insurance information, but I'm wondering if any of it actually necessary to keep on hand. I assume that for:
- Title/deed to the property which the title company mails after closing -- the county maintains the official record, and I assume this is a just a photocopy anyway
- Insurance policy -- you can always go online and get this
- Loan and purchase paperwork -- as long as you have a record of your closing disclosure, all the other forms you sign for buying/financing are mostly filler
Curious to hear what others do with all these dead trees. I'd love to be able to just shred it all.
- Harman
Post: New Construction in Columbus, Ohio

- Rental Property Investor
- San Francisco, CA
- Posts 126
- Votes 74
Originally posted by @Brandon Sturgill:
@Harman N. private builder rates have climbed steeply over the last 5-years...I've connected with a couple of builders and they seem to be closer to the $200/ft mark outside of the city...doing a lot scrape and build in a popular area could easily double that. Existing structures in the city are hovering around $200/ft right now...lots of variables, but buying existing would be a significant savings.
If you move to secondary markets you may find a local builder that does 2-3 builds a year around the $150-$175/ft. mark. for single family...cookie cutter stuff...no real customization or deluxe finishes...
Wow, $200/ft is quite expensive, especially if that doesn't include soft costs..
Post: New Construction in Columbus, Ohio

- Rental Property Investor
- San Francisco, CA
- Posts 126
- Votes 74
Relatedly, roughly what's the build cost per square foot in Columbus? Realize it depends on a lot of factors, but would be good to understand the high-level range
Post: Solid & Stable B Class in Columbus

- Rental Property Investor
- San Francisco, CA
- Posts 126
- Votes 74
Originally posted by @Brandon Sturgill:
@Harman N. Define B-class, lol...I know we all use the Marcus & Millichap asset class language, but it's more complex. We used algorithms and math to create rules to classify areas...this is a very scientific journey...and my B-class is probably significantly different than most...so, I think the fundamental question is what makes a B-class location B-class...
It's also important to note the structure...even using the simple class factor...a 200 year old property with a stone foundation in an "A-class" neighborhood may turn into a cashflow killing money pit...
Best of luck
Great point, the classification can apply to the asset as well as the location. I'd want a B-asset in a B-neighborhood: something build in the 1980s or later, ranch style, with a garage, etc
Post: How do you aggregate PM books with the stuff you pay for?

- Rental Property Investor
- San Francisco, CA
- Posts 126
- Votes 74
Originally posted by @Mike Dymski:
@Harman N. sure, PM me your email address. Keep in mind that the spreadsheet is for upload purposes only; so, it's basic.
I bought QB and planned to use it but it was not intuitive and could not facilitate the file uploads. So, I tried a 30 day trial with Xero instead, it worked, and I have been on it for a few years now.
Thanks Mike, PMed you my email address
Post: How do you aggregate PM books with the stuff you pay for?

- Rental Property Investor
- San Francisco, CA
- Posts 126
- Votes 74
Originally posted by @Mike Dymski:
Hey @Harman N. I tried converting AppFolio reports into a file format that could be uploaded into QB and that did not work. I manually key AppFolio Owner's Statement data into a standard Excel template that is prepopulated with recurring descriptions (unit numbers, rents, management fees, landscaping, dates, etc.) I tried uploading that file into QB and QB would not support it. So, I use Xero instead...and upload the Excel file (CSV). Incidentally, Xero is significantly more intuitive than QB.
Currently, I am doing this at a transaction level but may start using aggregated totals. I catch PM errors during this process; so, not sure how aggregated I can go anyway. For example, I recently noticed that the PM did not transfer a security deposit to my account for back rent after a non-paying resident moved out, did not bill back residents for utilities, forgot to reimburse a portion of carpet repair caused by a former resident's pet (PM did not withhold security deposit or have move in/move out inspection documents), etc.
It's not an elegant process but it is semi-automated.
Thanks for the input Mike! Did you move all your bookkeeping & accounting to Xero from QB? Or is Xero a complement to your QBO?
Would you mind sharing your Excel template (w/o the data) with me? I've been improving my spreadsheet a little bit each month, but right now I'm only at 4 properties / 10 units in service, and I don't think my spreadsheet would scale 5x..
Post: Appfolio cash flow report --> Quickbooks accounting

- Rental Property Investor
- San Francisco, CA
- Posts 126
- Votes 74
Hi all,
Every month I spend 2-3 hours translating the Appfolio cash flow report I get from my PM into double-ledger accounting for Quickbooks. First I do the Appfolio translation in a spreadsheet until I get everything to balance, then I manually enter into Quickbooks. Is there an Appfolio & Quickbooks integration that makes this process streamlined?
- Harman
Post: How do you aggregate PM books with the stuff you pay for?

- Rental Property Investor
- San Francisco, CA
- Posts 126
- Votes 74
Originally posted by @Mike Dymski:
@Nathan Miller I need more robust reporting for commercial lenders, financing packages and general analysis (separate and aggregated property P&Ls, T12s, rent rolls); so, unfortunately, I may need to handle the bookkeeping myself or continue to vet PMs who provide this service. I see this reporting from sellers when performing due diligence on properties; so, there are PMs and systems that are providing this data.
Hey Mike,
Did you ever figure this out? Every month I spend 2-3 hours translating the Appfolio cash flow report I get from my PM into double-ledger accounting for Quickbooks.
Post: Solid & Stable B Class in Columbus

- Rental Property Investor
- San Francisco, CA
- Posts 126
- Votes 74
Originally posted by @Remington Lyman:
Originally posted by @Harman N.:
Hey everyone,
My portfolio right now is all C-class / gentrifying parts of Columbus. I'm thinking of balancing it a bit with some solid, stable, B-class locations: not too rough, but not too expensive either. Areas that are family-friendly and attract tenants that tend to stay a while.
What are some such areas you've had success with? I'm curious especially about Grove City, Reynoldsburg, Clinton Estates (north of Linden), Gahanna.
Thanks!
- Harman
Buy in Old North Columbus or Franklin Park so we can be neighbors. I would consider those A locations though.
I would consider Grove City, Reynoldsburg, and Gahanna A as well. Clinton Estates is probably B.
Below is what I would consider > C areas. Please note this is an extremely rough sketch I did in a couple of minutes. It is not as accurate as it would be if I spent a couple of hours.

Great artwork, I'd give it a B- :-)