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 16%
$32.50 /mo
$390 billed annualy
MONTHLY
$39 /mo
billed monthly
7 day free trial. Cancel anytime
You must be logged in and allowed to do that
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 over 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...