New Schedule E Excel Worksheet For 2025

by | Dec 23, 2025 | Accounting, Tax

If you report rental income on a form Schedule E, you already know the IRS wants your numbers broken out by category and by property. The Schedule E form is the main IRS form used to report rental real estate income and expenses on your personal return, and clean detail makes preparation easier and cuts down on follow-ups.

To make this more simple for you (and cleaner for us), we have created a simple Excel worksheet you can download, fill out, and upload through your Senter CPA portal as part of your organizer.

How the worksheet helps:

  • Gives you one place to report all Schedule E rental income and expense information
  • Matches the main categories on Schedule E so we can easily reconcile the information when preparing your return
  • Cuts down on back-and-forth emails regarding missing items

What you will enter:

  • Rents received by property address/location
  • Common expense categories (for example: advertising, cleaning and maintenance, commissions, insurance, legal and professional fees, management fees, mortgage interest, repairs, supplies, taxes, utilities, depreciation, and others)
  • Notes for big items like new appliances, remodels, or improvements (often handled differently than repairs)

How to use it:

  1. Download the Schedule E Rental Excel worksheet from this post.
  2. Fill it out as completely as you can based on your records.
  3. Log in to your Senter CPA portal.
  4. Upload the finished file under your 1040 organizer in the document upload area for rental income.

Please do not email it. Uploading through the portal keeps everything together with the rest of your tax documents.

What if I already use property management software or my own spreadsheet?

If you already track rentals in:

  • Property management software, QuickBooks, Xero, Wave, or another system, or
  • Your own spreadsheet that clearly shows income and expenses by category and by property address/location

You can upload those reports instead of using our worksheet. For example, a year-to-date Profit & Loss, access to your QuickBooks file plus any supporting detail is fine.

Senter, CPA Accounting Client?

If Senter, CPA already handles your rental bookkeeping or monthly reporting, you do NOT need to complete this Excel sheet. We will use the records we maintain for you.

Want to see the actual Schedule E form?

If you are curious how these ties to the tax form, you can look at:

  • The DRAFT 2025 Schedule E (Form 1040) the IRS has posted HERE –  This is for reference only and may change before filing season.
  • The IRS page for Schedule E (Form 1040) can be found HERE – This page will always include links to the current form and instructions.

Download Below:

Always remember, Senter, CPA is here for you if you need any assistance.

Don't hesitate to give us a call at 248-934-0550, or contact us below.

Are Unused Subscriptions Costing You Money?

As household expenses continue to rise, identifying unnecessary recurring charges is a practical way to improve cash flow without making significant lifestyle changes. Many consumers unknowingly pay for subscriptions they no longer use, forgot to cancel after a free trial, or no longer find valuable. While individual charges may seem insignificant, the combined annual cost can amount to hundreds of dollars.

Your Year-End Tax Bill Shouldn’t Be a Surprise

December has a way of making tax planning feel urgent—but by December, you’re already behind the strategy and some of the best planning opportunities could have already passed you.

Fall Accounting

It’s like spring cleaning, but now we’re working on it in between Back to School and Football and Pumpkins and Mostly Great Weather!

Trump Accounts: What Parents—Especially Michigan Families—Need to Know

Trump Accounts are a new type of savings vehicle designed to help families build long-term financial resources for children. Structured as a special type of traditional IRA, these accounts have specific rules governing eligibility, contributions, investments, and withdrawals.

Senter Forward: The Kind of Client Relationship We Want to Build

I will start with something that may sound strange coming from a CPA firm: we are not trying to take every piece of work that walks through the door.
We have reached a point where the question is less “Can we prepare this return?” and more “Can we build a relationship here where our team can actually help?” That difference matters.

Federal Updates on Tip And Overtime Tax Deductions

Recent federal tax legislation introduced new deductions related to qualified tip income and overtime pay. These changes may benefit eligible employees while also creating additional reporting responsibilities for employers. At Senter CPA, we are helping both businesses and individual taxpayers understand how these rules apply and how to stay compliant.

1099 Filing Requirements Update! Yes, this is good news!

The reporting amount threshold has increased. Yes, you read that right! The old $600 filing requirement for 1099-MISC & 1099-NECs has been increased to $2,000, with some minor exceptions.

To jog your memory, if you need it, you are required to file 1099s to those who you pay for rent, contract labor (not through your payroll), interest, etc. The 1099-MISC is most commonly used to report rent, while the 1099-NEC is mostly used to report non-employee compensation to most everyone.

Mid-Year Financial Checkup Checklist: Are You on Track for 2026?

Summer is a good time to check in on your finances. The year is already halfway over, which makes it easier to see what’s working and what might need attention. Maybe your income has changed. Maybe you’ve spent more than expected or fallen behind on a savings goal.

Understanding Quarterly Estimated Tax Payments

If you’re self-employed, a freelancer, or a small business owner, quarterly estimated tax payments are an important part of staying current with your federal tax obligations. Because taxes typically aren’t withheld from self-employment income, the IRS requires many taxpayers to pay taxes throughout the year instead of waiting until they file their annual return. Making timely estimated payments can help avoid a large tax bill and potential underpayment penalties.

Why I Visit Our Accounting Clients

Every couple of years, I spend part of my summer leaving the office.

That probably sounds strange coming from a CPA.