IRS Schedule E Report Generator for Rental Properties in Foundations
The Schedule E report organizes your transaction data and mileage into IRS Schedule E, Part I — Income or Loss From Rental Real Estate and Royalties. It is designed to give you, or your accountant, the figures needed to complete your Schedule E filing at tax time.
See Understanding Reports for instructions on selecting a property, date range, and exporting your report.
How Transactions Map to Schedule E
Section titled “How Transactions Map to Schedule E”Every transaction category in Foundations is mapped to a Schedule E line definition. When you generate a Schedule E report, each transaction recorded in the selected period is automatically placed on the appropriate line based on its category. As long as your transactions are categorized correctly, every transaction will appear somewhere in the report.
The report follows the IRS Schedule E instructions: line names and numbers match the form, income and expenses are reported on the cash method (income when you receive it, expenses when you pay them), and voided transactions are excluded.
Report Sections
Section titled “Report Sections”The IRS Schedule E form has 5 parts. Part I covers income or loss from rental real estate and royalties, and it is where your rental income (Line 3) and expenses (Lines 5 through 19) are reported. Foundations organizes your transactions when you create them to match the official lines in Part I. The remaining parts of Schedule E are not included in the report currently.
Part I: Income
Section titled “Part I: Income”All rental income is reported on Line 3: Rents received. The IRS instructions say any other rental income goes on line 3 too, with a statement attached to your return, so every income category in Foundations rolls up into Line 3: Rent Received, Late Fees, Pet Fees, Application Fees, Deposit Retained, Laundry/Vending, and Other income.
When your income has more than one source, the report lists each source directly under Line 3. That breakdown gives you the statement of other income the IRS asks for.
A Total Income (Line 3) figure is shown at the bottom of this section.
What counts as rental income
- Rent — including advance rent, which is income in the year you receive it regardless of the period it covers.
- Payments to cancel a lease and late, pet, and application fees.
- Expenses your tenant pays for you, such as a repair bill or utility bill the tenant deducts from the rent. Record the amount as rent received, and also record the expense if it is deductible.
- Property or services instead of rent, at their fair market value.
- Security deposits you keep. A refundable security deposit isn’t income when you receive it, so don’t record it. Record it as Deposit Retained in the year you keep all or part of it. A deposit that will be used as the tenant’s last month’s rent is advance rent, so record it as Rent Received when you receive it.
Part I: Expenses
Section titled “Part I: Expenses”Lists all expense lines from Schedule E with the corresponding total calculated from your transactions for the selected period. Expense lines covered include:
- Line 5: Advertising
- Line 6: Auto and travel — includes your standard mileage deduction. See Mileage on Line 6 below.
- Line 7: Cleaning and maintenance
- Line 8: Commissions
- Line 9: Insurance
- Line 10: Legal and other professional fees
- Line 11: Management fees
- Line 12: Mortgage interest paid to banks, etc.
- Line 13: Other interest
- Line 14: Repairs
- Line 15: Supplies
- Line 16: Taxes
- Line 17: Utilities
- Line 18: Depreciation expense or depletion — includes non-cash transactions. Depreciation does not represent actual cash movement but is included on the Schedule E as a non-cash deduction.
- Line 19: Other (list)
A Total Expenses (Line 20) figure, the sum of Lines 5 through 19, is shown at the bottom of this section.
Line 19: Other (list)
The Other category is for ordinary and necessary rental expenses that don’t fit lines 5 through 18. The form labels this line “Other (list)”, so the report includes a Line 19 Detail table directly after the expenses. It groups your Other expenses by the description you entered in the transaction’s Notes, with a count and total for each. Give Other transactions a short, clear description in Notes so the list is meaningful to you and your accountant.
Choosing the right category
- Repairs versus improvements. Line 14 is for repairs and maintenance that keep your property in ordinarily efficient operating condition, such as fixing a broken lock or painting a room. Improvements that better or restore the property or adapt it to a new use, such as replacing an entire HVAC system, must be capitalized and depreciated instead of deducted. The value of your own labor is not deductible either.
- Mortgage interest. Line 12 is for interest paid to banks or other financial institutions, usually shown on Form 1098. Use Other Interest (Line 13) for interest paid to anyone else. Prepaid interest is deductible only in the year it applies, and points are generally deducted over the life of the loan.
- Legal and professional fees. Line 10 includes fees for tax advice and preparing tax forms for your rentals. Legal fees to defend or protect title, recover property, or develop or improve property are capitalized instead.
- Mortgage principal is not deductible, which is why it is excluded from the report.
- Depreciation. Foundations reports the depreciation amount you enter. Depreciation is figured using Form 4562 and its instructions, and land is not depreciable.
Summary Section
Section titled “Summary Section”- Rents Received (Line 3) — total from the income section.
- Total Expenses (Line 20) — total from the expenses section.
- Income or (Loss) from Rental Real Estate (Line 21) — rents received minus total expenses.
If Line 21 is a loss, the report adds a note that the at-risk rules (Form 6198) and passive activity loss rules (Form 8582) may limit how much of it you can deduct on Line 22.
Mileage on Line 6
Section titled “Mileage on Line 6”If you logged trips with Mileage Tracking for the selected property and timeframe, your standard mileage deduction is included in the report automatically. The IRS reports it on Line 6: Auto and travel, together with your other auto and travel expenses, so Foundations folds it into that line.
When mileage is included, the report shows:
- Line 6 breakdown — directly under Line 6 in the expenses section, how much of the total is your standard mileage deduction and how much came from Travel transactions.
- Line 6 Detail: Standard Mileage Deduction — a table of your miles, the rate per mile, and the deduction. Each trip is priced at the IRS standard mileage rate in effect on the date of that trip. When the IRS changes the rate during the year, as it did in 2026, each rate is listed on its own row with the dates it was in effect.
- Mileage Log — an itemized list of every trip in the timeframe with its date, route, purpose, miles, and rate. In an XLSX export the Mileage Log is on its own sheet, and in a CSV export it follows the summary.
If you logged mileage but no transactions in the timeframe, the report is still generated with the mileage on Line 6.
Gas, repairs, and other vehicle costs
Section titled “Gas, repairs, and other vehicle costs”The standard mileage rate already covers gas, oil, repairs, tires, insurance, registration, and vehicle depreciation. If you take the standard mileage deduction, do not also deduct those costs. The IRS allows only parking fees and tolls on top of the standard mileage rate.
For that reason, the Travel transaction category should hold parking, tolls, and travel costs that aren’t part of driving your own vehicle, such as lodging for out-of-town trips. If you track your driving with Mileage Tracking, don’t log gas or vehicle repairs as Travel transactions, or the same cost would be deducted twice. Foundations shows a reminder once per app session when you choose Travel while logging a transaction, and the report repeats it in its notes whenever mileage is included.
Meals while traveling
Section titled “Meals while traveling”Line 6 includes only 50% of meal expenses incurred while traveling away from home. Foundations reports the amounts you enter and doesn’t apply the 50% limit for you, so enter only the deductible portion of a meal. The report repeats this reminder in its notes whenever Line 6 has Travel transactions.
Other IRS requirements to know about
Section titled “Other IRS requirements to know about”- Form 4562, Part V. The Schedule E instructions require Form 4562, Part V when you claim any auto expenses. It asks for the total business, commuting, and personal miles for your vehicle. Foundations records only the miles you drive for your rentals, so you will need to supply the rest.
- Choosing the standard mileage rate. You can use the standard mileage rate only if you chose it in the first year you placed the vehicle in service (or for the entire lease period, if the vehicle is leased).
Report Notes
Section titled “Report Notes”Every Schedule E report ends with a Notes section that explains how the numbers were calculated, so you and your accountant can see the IRS rules behind them. The notes only cover what appears on your report. Depending on your data, they can include:
- That the report uses the cash method, and how advance rent and security deposits are treated.
- For a Multi-Tenant property, whether the report covers the entire property or only property-level transactions, and how to change that or report a single unit instead.
- Where each part of your other rental income was reported, for the Line 3 statement.
- Reminders for the lines that have amounts, such as meals on Line 6, legal fees on Line 10, interest on Lines 12 and 13, repairs versus improvements on Line 14, depreciation on Line 18, and the Line 19 list.
- The mileage rules above, when mileage is included.
- A reminder about the at-risk and passive activity loss limits when Line 21 is a loss.
- A reminder when the timeframe is not a full calendar year, since Schedule E covers a full tax year.
- That Foundations doesn’t track the property type (Line 1b) or fair rental and personal-use days (Line 2), and that you should report only your share if you own part of the property.
- A reminder that the report is not a substitute for professional tax advice.
Important Notes
Section titled “Important Notes”Feel free to review our Terms and Privacy Policy for liability information regarding the use of these reports. You can also contact us with questions at support@thinkfoundations.com.
Was this page helpful?
Thanks for the feedback!