How to Track Rental Property Income and Expenses | Complete Bookkeeping Tutorial | InsightSheets
A complete step by step walkthrough of the CPA-designed Rental Property Bookkeeping System. In this video I cover every tab from setup to your first transaction including capital improvement tracking, security deposit management, expense allocation across multiple properties, and automated dashboards for up to 10 rental properties.
Timestamps:
00:00 Introduction
01:36 Inputs Tab Setup
03:01 Account Setup
03:41 Chart of Accounts Setup
07:08 Chart of Accounts Tab
07:27 Property and Tenant Tracker
09:48 Budget Tab
10:29 Transaction Log
15:03 Allocation Feature
16:05 Profit and Loss
18:01 Monthly Dashboard
19:22 Annual Dashboard
19:44 Five Year Dashboard
20:37 Property Dashboard
21:42 Account Reconciliation
23:40 Accounts Custom Tab
24:25 Balance Sheet Roll Forward
26:37 Balance Sheet
27:34 Sales Tax Reporting
28:06 Transaction History
28:56 Closing Tips
Template features:
Up to 10 rental properties, tenant management, capital improvement tracker excluded from P&L, expense allocation across multiple properties, automated monthly and annual dashboards, 5-year dashboard, property comparison dashboard, account reconciliation, security deposit subledger, and balance sheet roll forward schedules.
Purchase this template on Etsy:
https://insightsheets.etsy.com/ca/lis...
Questions?
Message me directly on Etsy or email [email protected]. I am always happy to help and happy to jump directly into your file if needed.
If this tutorial helped you a quick review on Etsy means the world to a small shop like mine.
Designed by a CPA with 15 years of financial reporting experience