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 Companies Hard Money Lenders Contractors Investment Companies

    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
ForumsArrowTax, Legal Issues, Contracts, Self-Directed IRAArrowSpreadsheet Accounting and Going Through Audits?
  • Newest Posts
    • Newest Posts
    • Unanswered Discussions
  • Trending
    • Top Discussions
    • Trending Discussions
  • Browse Forums
Search Nova
Create post

Spreadsheet Accounting and Going Through Audits?

10 Replies

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

Nicholas Anderson
from Tampa, Fl

posted about 1 month ago
Hello BP,

So I'm a few flips into a business endeavor here and have come to the point where it is really time to get organized.  One of the issues I'm having trouble with is the accounting aspect.  All of the accounting software seems like pretty serious overkill for a single-member LLC that flips houses and is taxed on a Schedule C form.  I was able to whip up a 6 tab spreadsheet (In addition to separate detailed job accounting spreadsheets for each property) that captures my cashflow nicely but obviously has no fancy account reconciliation or accrual-based accounting with Accounts Receivable or that sort of stuff.  Just the basics.  Income statement, expenses, transaction summaries(the flips), Other income, Owners Equity, and a Cash ledger.

Now, anyone with a business that is worth a lick is currently either shaking their heads or aghast reading this.  I get it.  Its not 'pro' but I don't really want to blow subscription fees or a big upfront cost for complex software that I then have to learn for maybe 5 flips a year.  Not unless I really have to anyways.

So, onto the question, has anyone ever been through an audit with this kind of haphazard spreadsheet accounting before?  If so, was it the absolute bane of your existence or did they just kinda shrug like it was par for the course with small businesses?  I have no problems actually running the LLC with this; its small, project based, and again only needs to use a Schedule C for taxes.  My fear is that when I get the distinction of living through my first IRS shakedown I'll be creating more problems for myself than I'm solving by keeping my accounting simple and minimal.  Any thoughts on the matter?
Rotate Log in or sign up to reply
user profile avatar
Check Rosette Top Subjects:
Tenants and Managing Tenants
  • Posts 865
  • Votes 597

Christopher Smith
Investor from brentwood, california

replied about 1 month ago

I've used a simple one page spreadsheet for 20+ years for multiple rental properties in multiple states, and I'm not even the least little bit concerned by an audit. Now I've never been audited (whether you see that as good or bad), but to me I don't think that is really the point. As long as your business accounts are kept separate from your personal accounts, and the processes that you use to record your activity are clear and consistent, I see absolutely no need for an elaborate set of financial statements. In fact my spreadsheet is much more tailored to tax reporting than financial reporting so its much easier to work from for tax compliance purposes than it would be to work from a set of financials.  

Just my opinion.

Rotate Log in or sign up to reply
user profile avatar
  • Posts 654
  • Votes 466

Dan Schwartz
Real Estate Investor from Tempe, AZ

replied about 1 month ago

@Nicholas Anderson the quality of your records count more than the format.  If you want an easy way to step up your thoroughness, save the spreadsheet in either a) a cloud service that offers unlimited versioning, or b) save a locked version of the spreadsheet at the end of every month to “version it yourself.”   Just an idea to show any potential auditor that you haven’t gone back and changed all of the records - and if you did you can explain when and why.  Hope you never need to go through an audit, but this came to mind. 

Rotate Log in or sign up to reply
user profile avatar
Check Rosette Top Subject:
Maintenance
  • Posts 2.4K
  • Votes 2.6K

Bill Brandt
Investor from Las Vegas, NV

replied about 1 month ago

You really can’t spend $50 for quicken? I use it for more than a dozen properties and it’s still overkill. But it’s $50 friggin dollars. And it auto inputs all your checks and credit card charges. In 10 seconds I can pull up income and expenses per property or over all the properties by type. It will save you hours and hours per year. 

Don’t do it because your afraid of an audit. Do it because it’s a smart use of your time and $1 per week. 

Rotate Log in or sign up to reply
user profile avatar
  • Posts 3.8K
  • Votes 3.0K

Pat L.
Rental Property Investor from Upstate, NY

replied about 1 month ago

I lived through two audits both triggered by large but valid operating expenses. 

The auditor was more interested in my bank ledgers, especially cancelled checks &/or CC accounting for specific expenses including the corresponding receipts, per expense per property. 

My wife has always maintained separate bank accounts for each property so that was easy. She also maintains Sched E type spreadsheets for each property detailing all expenses, capital improvements & especially mileage by property, & the auditor liked that.

I came in with copies of everything & she went through them in detail. The audit was two 1/2 days a week for 3 weeks (at the time my tax returns were 200+ pages). Then they decided to audit yet another year.

I was finally assessed $9k+ in taxes plus penalties for some obscure SE income so I wrote a check. 

2 years later they reversed that decision & paid back my $9k+ with interest. Have not changed my accounting since then.

Rotate Log in or sign up to reply
user profile avatar
Check Rosette Top Subjects:
Tenants and Managing Tenants
  • Posts 865
  • Votes 597

Christopher Smith
Investor from brentwood, california

replied about 1 month ago
Originally posted by @Pat L. :

I lived through two audits both triggered by large but valid operating expenses. 

I came in with copies of everything & she went through them in detail. The audit was two 1/2 days a week for 3 weeks (at the time my tax returns were 200+ pages). Then they decided to audit yet another year.

When you say large operating expenses were your properties all reporting large tax losses?



 

Rotate Log in or sign up to reply
user profile avatar
  • Posts 3.8K
  • Votes 3.0K

Pat L.
Rental Property Investor from Upstate, NY

replied about 1 month ago

@Christopher Smith yes major rehab for code compliance & a lot of mileage. 

Rotate Log in or sign up to reply
user profile avatar
Check Rosette Top Subject:
Taxes & Accounting
  • Posts 158
  • Votes 117

Greg O'Brien
Accountant from Boston, MA

replied about 1 month ago

@Christopher Smith I defended someone in 2019 who had spreadsheet accounting. That was fine but they had a comingled bank account which was not. The auditor tried to tie out the bank stmts to the Excel sheets though and we had to produce all the backup.

Rotate Log in or sign up to reply
user profile avatar
  • Posts 6
  • Votes 3

Nicholas Anderson
from Tampa, Fl

replied about 1 month ago

These are great insights, thank you all for your responses.  @Bill Brandt its moreso the time and commitment of learning the platform than the cost, although I hadn't even considered Quicken.  Cost is a factor too, though.  I was thinking Quickbooks which is $30/month for the features I need.

@Greg O'Brien , the co-mingled accounts is something I got away from as quickly as possible.  Not soon enough unfortunately - trying to tie bank statements to excel spreadsheets for one flip will be an absolute nightmare.  The case for not co-mingling really makes itself as soon as you try to put anything on books.  Thats the kind of things I'm very concerned about, though.  The IRS was actually going line by line in bank statements and attempting to match it to specific entries in his spreadsheet, like $307.50 at Lowes on the credit card matched to the line in Spreadsheet for $307.50 for a new stove on Project ABC?  Mind if I ask anything about details, how lenient they were, what their demands for evidence were, etc?

Rotate Log in or sign up to reply
user profile avatar
Check Rosette Top Subject:
Taxes & Accounting
  • Posts 158
  • Votes 117

Greg O'Brien
Accountant from Boston, MA

replied about 1 month ago

@Nicholas Anderson in this case, the person came to me (wasnt my client prior) so had to work with what he did and did not have records wise. The auditor was very in the weeds on two expense line items, but more about the jusitification vs tieing out. For example, she was questioning thevdeductibility of his travel vs the actual amounts. Second, we prepared a summary showing “total per line X vs total per bank statement”. They accepted this. We printed out hundreds of bank statements but they didnt even look. It turned into a negotiation as the client owed $50k plus and we probably settled under $20k.

IRS audits are highly individualized. We always suggest approaching him/her with grace, be open about any mistakes and it will go fine!

Rotate Log in or sign up to reply
  • 1
  • 2
Related Resources Tax, Legal Issues, Contracts, Self-Directed IRA
What’s the Most Powerful Business Entity for House Flippers?
8 Simple Steps to Close Real Estate Deals Like a Rockstar
How to Structure an LLC With S Corps Election
How to Get Stuff Done While Working at Home in Your Underwear
From Lazy to Laser-Focused: How to Find Your Real Estate Motivation
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

Michael Plaks
Michael Plaks
Houston, TX
9.51
Score
Dmitriy Fomichenko
Dmitriy Fomichenko
Anaheim Hills, CA
7.86
Score
Eamonn McElroy
Eamonn McElroy
Atlanta, GA
5.52
Score
Ashish Acharya
Ashish Acharya
Atlanta, GA
4.22
Score
Greg O'Brien
Greg O'Brien
Boston, MA
2.99
Score

Tax, Legal Issues, Contracts, Self-Directed IRA Trending Discussions

  • LLC or to not LLC for tax benefits
    5 Replies
  • Savannah Real Estate Lawyers?
    3 Replies
  • Capital Gains for DIY Flipper
    3 Replies
  • Create SLLC for FAFSA?
    4 Replies
  • Property taxes, conventional mortgage, Deed in LLC
    6 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.