Skip to content
×
Try PRO Free Today!
BiggerPockets Pro offers you a comprehensive suite of tools and resources
Market and Deal Finder Tools
Deal Analysis Calculators
Property Management Software
Exclusive discounts to Home Depot, RentRedi, and more
$0
7 days free
$828/yr or $69/mo when billed monthly.
$390/yr or $32.5/mo when billed annually.
7 days free. Cancel anytime.
Already a Pro Member? Sign in here

Join Over 3 Million Real Estate Investors

Create a free BiggerPockets account to comment, participate, and connect with over 3 million real estate investors.
Use your real name
By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions.
The community here is like my own little personal real estate army that I can depend upon to help me through ANY problems I come across.
General Real Estate Investing
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 about 5 years ago on . Most recent reply

User Stats

65
Posts
31
Votes
Garen T.
  • Vendor
  • Vancouver, WA
31
Votes |
65
Posts

Expense tracking google sheets with CPA output?

Garen T.
  • Vendor
  • Vancouver, WA
Posted

I own 3 rentals (1 SFR and 1 duplex) with another duplex coming on this year. I've been tracking income and expenses on a very simple Google sheet which separates things into the different properties. This week I sent that over to my CPA and he asked me to fill out a paper form which separated all my expenses out into categories that needs needs for taxes.

Property 1
Income
    5. Rent Received
    6. Other Income

Property Expense
    7. Advertising
    8. Cleaning and Maint
    9. Commissions. 
    10. Insurance
    11. Legal
    12. etc, etc, etc, 

Does anyone have a nice google or excel doc that auto outputs to this level of detail? I'm not looking for anything super complex (unless I'm at the point where I need to do that) and I'm fairly good at excel formulas and forms, so I may end up doing this on my own. 

Thoughts?

Loading replies...