Skip to content
×
PRO
Pro Members Get Full Access!
Get off the sidelines and take action in real estate investing with BiggerPockets Pro. Our comprehensive suite of tools and resources minimize mistakes, support informed decisions, and propel you to success.
Advanced networking features
Market and Deal Finder tools
Property analysis calculators
Landlord Command Center
$0
TODAY
$69.00/month when billed monthly.
$32.50/month when billed annually.
7 day free trial. Cancel anytime
Already a Pro Member? Sign in here
Pick markets, find deals, analyze and manage properties. Try BiggerPockets PRO.
x
All Forum Categories
All Forum Categories
Followed Discussions
Followed Categories
Followed People
Followed Locations
Market News & Data
General Info
Real Estate Strategies
Landlording & Rental Properties
Real Estate Professionals
Financial, Tax, & Legal
Real Estate Classifieds
Reviews & Feedback

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

Harman N.Posted
  • 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?

Harman N.Posted
  • 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

Harman N.Posted
  • 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

Harman N.Posted
  • 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

Harman N.Posted
  • 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?

Harman N.Posted
  • 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?

Harman N.Posted
  • 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

Harman N.Posted
  • 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?

Harman N.Posted
  • 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

Harman N.Posted
  • 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-  :-)