All
Members
Companies
Blog
Forums
Podcast
Webinars
    User Log in  /  Sign up
  • Forums
    Newest Posts Trending Discussions Followed Forums Real Estate News & Current Events General Landlording & Rental Properties Buying & Selling Real Estate Deal Analysis See All
  • Education

    Read

    BiggerPockets Blog BPInsights: Expert Analysis Guides Glossary Reviews Member Blogs

    Watch

    Webinars Video Library Financial Independence Blueprint Intro to Real Estate: Rentals

    Listen

    BiggerPockets Real Estate Podcast BiggerPockets Money Podcast BiggerPockets Business Podcast Real Estate Rookie Podcast Daily Podcast (Audio Blog)

    Topics

    Business Operations Finance Finding Deals Property Management Property Types Strategy
  • Network

    Recommended Vendors

    Real Estate Agents Mortgage Lenders Hard Money Lenders Insurance Contractors Investment Companies Build Your Team

    Search

    Members Events Jobs
  • Tools

    Calculators

    Rental Property Fix and Flip BRRRR Rehab Estimator
    Wholesaling Mortgage Payment 70% Rule Airbnb

    Services

    BPInsights: Property Insights Tenant Screening Property Management Lease Agreement Packages

    New Feature

    BPInsights (beta)

    Quickly analyze a property address or ZIP Code to compare your rent in your neighborhood.

    Analyze a property
  • Find Deals
    Real Estate Listings Find Foreclosures External Link Ads, Jobs, and Other
  • Bookstore

    Real Estate Books

    Profit Like The Pros Bidding to Buy See all books

    Featured Book

    BiggerPockets Wealth Magazine book cover
    BiggerPockets Wealth Magazine

    Written by financial journalists and data scientists, get 60+ pages of newsworthy content, expert-driven advice, and data-backed research written in a clear way to help you navigate your tough investment decisions in an ever-changing financial climate! Subscribe today and get the Oct/Nov issue delivered to your door!

    Get the Magazine
  • Pricing
Log In Sign up
User
Quick search links
Podcast Hard Money Lenders Books Washington
ForumsArrowStarting OutArrowHow do people manage their bank accounts, spreadsheets etc.
  • Newest Posts
    • Newest Posts
    • Unanswered Discussions
  • Trending
    • Top Discussions
    • Trending Discussions
  • Browse Forums
Search Nova
Create post

How do people manage their bank accounts, spreadsheets etc.

8 Replies

  • Share on Facebook
  • Share on Twitter
  • Share on LinkedIn
Rotate Log in or sign up to reply
user profile avatar
  • Posts 36
  • Votes 11

Caleb Clay
from Lexington, Ky

posted over 2 years ago

I currently have 2 properties and plan to refinance both of them soon. I am a "B type" person and struggle with organization skills. I have one main checking account for my LLC to help separate it from my personal banking. I plan on buying multiple properties in the coming months but being able to keep up with everything is already a challenge. Any suggestions on processes or systems that make everything much easier?? Also, I would like to note that I do not know how to use Excel.

Some questions I have:

-Should I have separate accounts for each property?

-How or where do people scan in physical receipts?

-What is the best way to calculate and keep track of all expenses and cash flow both monthly and yearly for each property?

-What is the best system to be best prepared come tax season as far as having everything organized for my CPA and having the documentation I need in case of an audit?

-Where are state specific lease agreements that I can access for land lording? 

Any advice will help. I am currently shopping for a PM to help me with this but would like to know what people do managing their own stuff. Thanks!

Rotate Log in or sign up to reply
user profile avatar
  • Posts 858
  • Votes 794

Peter M.
Rental Property Investor from DFW, TX

replied over 2 years ago

If you can't make your own spreadsheets or databases, quickbooks is usually a good option for bookkeeping. I used excel for a long time but I got a new CPA and she made me start using quickbooks. There is definitely a learning curve but it sounds like you will have that no matter what. 

QBs can split everything up by class. So each property would be its own class and you can run different reports to see every property separately. Your bank feeds can upload directly into QB and then you sort them to the respective Class. If you have multiple LLCs you will have multiple bank accounts and it can handle that as well. Your CPA will help you set it up but if you have a PM they will do it for you and send you a report which you will just forward to your CPA. 

You have to pay for new versions periodically but that expense is deductible as an expense. 

Rotate Log in or sign up to reply
user profile avatar
  • Posts 155
  • Votes 63

Bernie Huckestein
Rental Property Investor from Apopka, FL

replied over 2 years ago

I'd make a couple of comments:

I use Quicken for all my bills, personal and real estate...I have not written a paper check in years.  Business wise quickbooks or any number of others are probably better for the situation you describe quicken would work fine.  I do for sure have sperate personal and business accounts...this is a must; however, I do pay multiple property bills from a single business account...tracking it is just a matter of creating property categories eg 123mainst:Electric, 123Mainst:Taxes, 456AppleSt:Electric..).  

You didn't specifically ask the question but you may want to limit the number of properties in one single LLC for asset protection purposes...others here are more qualified to chime in on that, mine are not 1 for 1 but it is also not 1 for everything

b

Rotate Log in or sign up to reply
user profile avatar
  • Posts 13
  • Votes 8

Kevin Smith

replied over 2 years ago

QBO Plus will set you up for scale; if you get it through your CPA you can get a good discount.  With QBO Plus you'll be able to do class tracking as mentioned above.  Also, with any QBO tier you can use the mobile app to upload receipts to transactions.  

Rotate Log in or sign up to reply
user profile avatar
  • Posts 22
  • Votes 14

David Simon
Rental Property Investor from Camden County, NJ

replied over 2 years ago

I have two properties and use QuickBooks, with a separate book for each one. And I have my own small business unrelated to real estate and have another file for that in Quickbooks. As was mentioned before, there is certainly a learning curve. My accountant sat down with me early on and taught me the basics. And that was well worth the time. I've never found a book that helps all that much, but if anyone has a suggestion for that, I'd love to know it.

As far as saving receipts, I rarely do. I save invoices from service providers like contractors, plumbers, etc. Those I scan in and have a file on my computer. But for random trips to HomeDepot, I just enter the info into QuickBooks and toss the receipt. I figure my credit card statement retains the transaction amount, so I figure that will cover me. 

Rotate Log in or sign up to reply
user profile avatar
  • Posts 36
  • Votes 11

Caleb Clay
from Lexington, Ky

replied over 2 years ago

Awesome guys. Thanks for the input. I have an email out to my CPA now and I'm looking into QB!

Rotate Log in or sign up to reply
user profile avatar
Check Rosette Top Subjects:
Rentals, Analyze Deals, and Taxes & Accounting
  • Posts 817
  • Votes 777

Costin I.
Rental Property Investor from Round Rock, TX

replied over 2 years ago

@Caleb Clay How much time and/or money are you willing to allocate to these tasks? Your answers will change based on that.

My 2¢:

-Should I have separate accounts for each property? You don't need separate account per property, but you need to separate business dealings from personal dealings. And that means clear bookkeeping, if you keep all in your name, and separate business bank accounts and clear bookkeeping if you hold assets in an LLC.

-How or where do people scan in physical receipts? You can get mobile apps that act as scanners for receipts or buy documents scanners for all physical receipts, invoices and documents.

-What is the best way to calculate and keep track of all expenses and cash flow both monthly and yearly for each property? Nobody know the best way, but I can tell you how we are doing it: we use Quicken to track all our finances and also for properties bookkeeping. I highly suggest you do the same, as once setup and got everything tracked in it, it will give you clear sense of incoming and outgoing, net worth, assets and liabilities, etc. Additionally, we use a set of spreadsheets for categorization of rental expenses, plus another for property maintenance, task lists, etc... PM me if you want more info.

-What is the best system to be best prepared come tax season as far as having everything organized for my CPA and having the documentation I need in case of an audit? Use Quicken or Quickbooks. Track properly and organize the expenses in appropriate categories (rental income, maintenance, utilities, office expense, advertising, legal, and another 10 other categories). Track your mileage.

-Where are state specific lease agreements that I can access for land lording? You can find landlording forms here at BP if you are a PRO. You can find state specific information and lots of good books for landlords at NOLO. But beware, at least here in TX, you can't use a realtor lease agreement unless you are a licensed one - and there is a paragraph that invalidates the whole agreement otherwise - so we had to draft our own.

But then again, how much time and/or money are you willing to allocate to these tasks? A bookkeeper starts I think at $50/hr, a CPA at $150/hr and a property manager will take 10% + extra. You can put some money and time and get it setup and then just use your time to maintain it or you can pay others to do it for you. Ultimately, you'll still need to know how to do it (, otherwise how will you know if the resources you hire are doing it the right way?) since most are just tools that will give you results based on how good you wield them.

Let me know if you need more help on the DIY system.

Rotate Log in or sign up to reply
user profile avatar
Check Rosette Top Subject:
Team
  • Posts 254
  • Votes 152

Dan V.
Accountant from Norfolk, VA

replied over 2 years ago

-Should I have separate accounts for each property? 

No. One business bank account is enough and much more simple. As others suggested, do not mingle personal and business transactions. Some states require you to have a separate bank account for tenants security deposit, if not, one is fine.

-How or where do people scan in physical receipts? 

Some accounting software (like QBO) let you attach documents in the transaction.  There are also apps available but I prefer doing it directly in the accounting software or something that integrates with it. 

-What is the best way to calculate and keep track of all expenses and cash flow both monthly and yearly for each property?

A good accountant/bookkeeper and/or a good software. 

-What is the best system to be best prepared come tax season as far as having everything organized for my CPA and having the documentation I need in case of an audit?

I highly recommend using Quickbooks Online, especially if you are planning to use a remote bookkeeper or CPA.   As far as documentation, I recommend keeping electronic copies of at least all closing statements, loan docs/statements, and bank & credit card statements. Google Drive or Dropbox are some of the free cloud storage and can easily be shared with your accountant if needed whenever and whereever. If you will use an accounting firm, some have a client portal.

-Where are state specific lease agreements that I can access for land lording?

BP has those forms if you're a PRO member.


Goodluck!

Rotate Log in or sign up to reply
user profile avatar
  • Posts 215
  • Votes 186

Account Closed

replied over 2 years ago

@Caleb Clay Answers to your questions:

-Should I have separate accounts for each property?

I would recommend an account per LLC.

-How or where do people scan in physical receipts?

Some prefer attaching receipts to each transaction in QuickBooks. I prefer having folders (physical or DropBox, Google) set up by month so that you can just drop each receipt (preferably in order by date) in each month for the year.

-What is the best way to calculate and keep track of all expenses and cash flow both monthly and yearly for each property?

QuickBooks or other accounting software via bank feed (set up classes for QuickBooks Online) with receipts being your ultimate back up.

-What is the best system to be best prepared come tax season as far as having everything organized for my CPA and having the documentation I need in case of an audit?

See receipt documentation above. Keep for 3 years. 

-Where are state specific lease agreements that I can access for land lording? 

Check out BP's new section on leases or discuss with lawyer. 

Rotate Log in or sign up to reply
  • 1
Resources Read, see, and learn more!
Link Real Estate Investment Calculators
Link BiggerPockets Blog
Link Path to Purchase
Link Mortgage Loans
Link Find a Contractor
Link Real Estate Agents
Link Hard Money Lenders
Link Real Estate Listings

Top Contributors

Salvatore Lentini
Salvatore Lentini
Doylestown, PA
9.43
Score
Ciji Masser
Ciji Masser
Frederick MD
3.54
Score
Joe Villeneuve
Joe Villeneuve
Plymouth, MI
3.12
Score
Tre Irvin
Tre Irvin
Las Vegas, NV
2.58
Score
Jessica Piff
Jessica Piff
Churchville, MD
2.57
Score

Starting Out Trending Discussions

  • How do yall feel about buying a rental property all cash?
    106 Replies
  • I have $50k cash ready to invest and $50k in liquid assets.
    30 Replies
  • To sell or not to sell?
    16 Replies
  • So you want to become a real estate investor?
    197 Replies
  • Life just changed and now I am 100% remote - where to live??
    8 Replies
Log in Sign up

Log in

Forgot password?

If you signed up for BiggerPockets via Facebook, you can log in with just one click!

Log in with Facebook

Or
btn_google_dark_normal_ios Created with Sketch. Continue with Google

Let's get started

We just need a few details to get you set up and ready to go!

Use your real name

Use at least 8 characters. Using a phrase of random words (like: paper Dog team blue) is secure and easy to remember.

By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions.

Or
btn_google_dark_normal_ios Created with Sketch. Continue with Google

Why create an account?

Receive a free digital download of The Ultimate Beginner's Guide to Real Estate Investing.

Connect with 1,000,000+ real estate investors!

Find local real estate meetups and events in your area.

Start analyzing real estate properties, we do the math for you.

It's free!

Explore

  • Membership
  • Community
  • Education
  • Marketplace
  • Tools
  • FilePlace
  • REI Resources
  • Perks
  • Glossary
  • Reviews
  • iOS App
  • Android App

Company

  • About Us
  • Press
  • Advertising
  • Careers
  • Stats
  • Contact Us

Important

  • Editorial Guidelines
  • Terms of Use
  • Rules
  • Privacy
  • FAQ

Social

  • Facebook
  • Twitter
  • YouTube
  • Instagram
© 2004-2021 BiggerPockets, LLC. All Rights Reserved.