Rental Property Income & Expense Tracker Spreadsheet | Landlord Tracker | Real Estate Spreadsheet | Real Estate Bookkeeping

Landlord Rental Property Spreadsheet Features

• Track rental income and expenses
• Create your own income and expense categories
• Customizable income statement reports
• Track business bank accounts such as checking and credit card accounts
• Reconcile bank accounts
• Track tenant deposits

The landlord rental property template has a total of 14 registers. Use each Excel register to track your financial accounts, such as your checking and credit card accounts. You can track the running balances of those accounts and reconcile those accounts. As you enter transactions into the accounts, assign each transaction to the appropriate categories, such as income or expense categories. 

Create custom income and expense reports so you can see how your property is performing and whether it is profitable. You can create category reports, reports by vendor, reports by property location, reports by accounts, and reports by time periods.

Split transactions in the checkbook app for rental property to better reflect your rental income and rental expenses.

You can also chart and track the value of your asset and liability accounts over time so you have a visual picture the trending value of your cash and debt accounts.

The landlord property tracker is a great checkbook app with beautiful dashboards, reports and charts to help you analyze your rental properties business income and expenses.

The landlord income and expense tracker spreadsheet is designed for small businesses self-employed individuals who are managing one or small number of rental properties.

Whether you are a property owner looking to rent out your home for the first time or a seasoned landlord with several properties, this rental property spreadsheet can help simply your real estate bookkeeping, monitor rental expenses, analyze potential opportunities (such as whether to increase or decrease rents), and maximize your properties return on investment.

PC or Mac Computer with Microsoft Excel 2021 / Excel 2024 (one-time purchase, non-subscription) or Excel for Microsoft 365 (part of Microsoft 365 subscription). The rental property income and expense tracker spreadsheet is only supported in the United States (for use by US based small business only) as the amounts are formatted with the $ symbol and the dates are formatted as MM/DD/YYYY.

PC and Mac should have minimum 4 GHz processor, 16 GB RAM and SSD storage. The rental property spreadsheet spreadsheet is not compatible with Google Sheets (Google Spreadsheets). The property income vs expense tracker template is designed for small business that buy and sell using cash, check, wire transfers, credit cards, or debit cards and who meet the following criteria: Designed for small businesses that use the cash basis method of accounting as apposed to the accrual basis of accounting. The small business does not sell or buy on credit, such as the credit terms "payable in 30 days". The small business accounting software does not track accounts payable and accounts receivable. The small business accounting spreadsheet does not track employee payroll. The landlord rental property spreadsheet is not designed for small businesses that publish financial statements like public companies for audit purposes. Transactions are typically recorded using simple single-entry accounting rather than double-entry accounting.

All register transactions must originate from a transaction within one of your accounts (checking, savings, credit cards) and must be assigned to one of the income, expense, or other categories such as transfers, payments, spilt transactions, etc.) Each account register has a max of 4000 rows to record transactions, some of which might be splits which would require more than one row to record a single transaction such as a purchase split between two expense categories would require 3 rows to record the single transaction.

• How to download the Excel templates: All spreadsheet templates will be available for download after purchase. See Delivery Policy for more details.
• All checkbook software and budget spreadsheets have VBA macros which must be enabled prior to opening the Excel file. See simple video instructions for how to enable macros.
• See support page for help with how to use the spreadsheets or contact us at support@buyexceltemplates.com. By purchasing you agree with the Refund Policy and License Terms / Terms of Sale. Excel is a registered trademark of Microsoft Corporation.