Skip to content
×
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
ANNUAL Save 54%
$32.50 /mo
$390 billed annualy
MONTHLY
$69 /mo
billed monthly
7 day free trial. Cancel anytime
×
Take Your Forum Experience
to the Next Level
Create a free account and join over 3 million investors sharing
their journeys and helping each other succeed.
Use your real name
By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions.
Already a member?  Login here
Goals, Business Plans & Entities
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

Updated almost 8 years ago on . Most recent reply

User Stats

102
Posts
17
Votes
Brandon G.
  • Middle Tennessee, TN
17
Votes |
102
Posts

Excel Spreadsheet advice

Brandon G.
  • Middle Tennessee, TN
Posted

I'm looking for a spreadsheet that would allow me to keep track of all my income and expenses.  I'd like to find one that will allow me to individually keep track of each expense per unit/building, but all the one's I've seen so far on the site (in the spreadsheeet area and doing a search on the forums) just would have me tally up all my expenses and enter them per month rather than breaking them apart in a separate column.  Does anyone know of a good spreadsheet that would allow all expenses to be entered individually?

I have one duplex and manage two single families and plan on purchasing 1 - 2 more duplexes in the next year.

Thank you,

Brandon

Most Popular Reply

User Stats

259
Posts
144
Votes
Matt Faix
  • Investor
  • Carnegie, PA
144
Votes |
259
Posts
Matt Faix
  • Investor
  • Carnegie, PA
Replied

@Brandon G. This doesn't sound like it would be too hard to build. Sounds like you want an excel notebook with a tab for each property that shows income and expenses. Within each property tab, Column 'A' could be your descriptions of all income/expense line items, and all other columns would be the months, then you could calculate down to arrive at your NOI. Feel free to PM me, I'm happy to help you build something like that if you want.

Loading replies...