1031 exchange tracker spreadsheet
Our 1031 exchange tracker is a free Excel file for keeping your exchange on schedule. It has three tabs: your day-45 and closing deadlines, a trade-up check for cash and mortgage boot, and an identification worksheet that tests your list against the identification rules.
Free, no sign-up. Three tabs. File dated September 28, 2026.
Not tax or legal advice.
Alura Capital is not a qualified intermediary or tax advisor. This page and the file are for planning only. Confirm every date and rule with your qualified intermediary and your CPA or tax attorney.
Tab 1: Exchange timeline
What you enter
| Line in the file | The file's note |
|---|---|
| Relinquished property address | The property you sold. |
| Sale closing date (transfer date) | Day 0. The clock starts the day ownership transfers. |
| Qualified intermediary (company) | The QI holds your sale proceeds until you buy. |
| QI contact person, QI phone, QI email | (no note in the file) |
| Federal tax return due date for the year of the sale, including extensions | Extensions count. For a calendar-year individual this is usually April 15 of the year after the sale, or October 15 if you file an extension. Enter the date that applies to you. |
What it shows
- Day 45: identification deadline, with days remaining and a status.
- Day 180 after the sale.
- Your tax return due date, with extensions.
- Exchange deadline: close on the replacement property. This is the earlier of day 180 and your tax return due date, with days remaining and a status.
The status reads Sale not closed yet, Passed, Due today, Due soon (10 days or fewer), or On track. Days remaining are counted from today's date each time you open the file.
Example from the file
The example sale closes on August 20, 2026, and the tax return is due April 15, 2027. Day 45 is October 4, 2026, and day 180 is February 16, 2027. Day 180 comes first, so it sets the exchange deadline. If your return were due before day 180, the due date would set the deadline instead, and the file notes that filing an extension can restore the full 180 days.
The rules this tab spells out
- Both clocks start on the sale date. The 45-day and 180-day periods run at the same time, and day 45 does not restart the clock. IRS instructions count both from the date you transferred the property you gave up.
- The exchange period can end early. You must receive the replacement property by the earlier of the 180th day or your tax return due date, including extensions.
- Calendar days. The deadlines are not extended for weekends or holidays, so one can land on a Saturday or Sunday.
- The one exception the file names. After a federally declared disaster, such as a hurricane, the IRS can postpone these deadlines for affected exchanges. For example, after Hurricane Milton in 2024, the IRS release for Florida applied its like-kind exchange relief. Ask your QI whether relief applies to you.
- Identify in writing. Identification must be in writing, signed by you, and delivered to your qualified intermediary by midnight of day 45. Describe each property clearly, such as by street address or legal description. The IRS says the signed document goes either to the person who will transfer the replacement property to you, or to another person involved in the exchange who is not a disqualified person. A disqualified person is generally your agent or a person related to you.
For a quick online version of these dates, use our 1031 clock.
Tab 2: Trade up check
What you enter
- From the property you sold: sale price, selling costs (commissions, title, and other closing costs paid from the sale), and loan paid off at sale (every mortgage or lien paid off at closing).
- From the property you are buying: purchase price, and new loan amount (total new financing on the replacement).
What it shows
| Result in the file | What it means, in the file's words |
|---|---|
| Net proceeds held by the QI | Sale price minus selling costs minus the loan paid off. |
| Cash needed to close the replacement | Purchase price minus the new loan. Buyer closing costs are not included. |
| Cash reinvested from the exchange | Exchange proceeds that go into the replacement property. |
| Added cash from outside the exchange | Your own money added at closing. It can offset mortgage boot. |
| Estimated cash boot | Net proceeds not reinvested. Never below zero. |
| Estimated mortgage boot | Debt paid off minus new debt minus added cash. Never below zero. |
| Estimated total boot | Cash boot plus mortgage boot. |
| Replacement price equal to or greater than sale price? | Buying at an equal or greater price is part of deferring all of the gain. |
The file's usual test for deferring all of the gain: buy at an equal or greater price, reinvest all of the net proceeds, and replace the debt paid off with new debt or added cash. The IRS puts the tax side this way: if you receive other property or money in the exchange, you recognize gain to the extent of the other property and money received. The file adds that boot is generally taxable up to the amount of your gain, so talk to your CPA before you close.
The file tests the replacement price against your sale price. Our online 1031 clock tests it against your sale price minus selling costs, so the same deal can pass one and not the other. Confirm the right figure with your QI.
Example from the file
A $650,000 sale with $39,000 of selling costs and a $280,000 loan paid off leaves $331,000 with the QI. The $900,000 replacement with a $540,000 loan needs $360,000 of cash, so $29,000 comes from outside the exchange. No cash boot and no mortgage boot are estimated, and the price is higher, so the file reads "Full trade up on these numbers."
This is a simplified check. It leaves out buyer closing costs, prorations, deposits, and other items your qualified intermediary and CPA will account for.
Tab 3: Identification worksheet
The three identification rules (you only need to meet one)
- Three-property rule. Identify up to three properties of any value.
- 200 percent rule. Identify any number of properties, as long as their total value is no more than 200 percent of what you sold.
- 95 percent rule. If you go over both limits, you must acquire at least 95 percent of the total value of everything you identified.
IRS Publication 544 states the 200 percent limit in fair market value terms: the total fair market value of the properties you identify can be no more than double the fair market value of the property you give up. The tracker uses your sale price as the stand-in, so confirm the figure with your QI.
What you enter and what it checks
You list up to six properties with their address, price, and date identified. For each, the file checks "Within 45 days?" against the day-45 date on the timeline tab. The rule check then shows the number of properties identified, the total value, the 200 percent limit, the total as a percent of the sale price, and whether you meet the three-property rule or the 200 percent rule. If you meet neither, it shows the dollar amount you must close on under the 95 percent rule.
Example from the file
Three properties are identified on September 10, 18, and 24, 2026, all before day 45. Their total value is $2,725,000, more than 200 percent of the $650,000 sale. Because there are only three, the file reads "Meets the three-property rule. Value does not matter with three or fewer properties."
Changing your list
You can revoke and replace an identified property in writing before day 45 ends. After that, the list is final. IRS Publication 544 also says you can cancel an identification at any time before the identification period ends.
Preview: the identification table in the file
| # | Property address | Price | Date identified | Within 45 days? |
|---|---|---|---|---|
| 1 | 5501 Example Rd, Brandon, FL 33511 | $900,000 | 09/10/2026 | Yes |
| 2 | 310 Sample Ave, Clearwater, FL 33755 | $875,000 | 09/18/2026 | Yes |
| 3 | 88 Demo Blvd, Lakeland, FL 33801 | $950,000 | 09/24/2026 | Yes |
| 4 | ||||
| 5 | ||||
| 6 |
Scroll the table sideways to see every column.
Example rows from the file. Replace them with your own.
Where the replacement loan fits
The 180 days cover your replacement loan too. The file's advice: if you are financing the replacement property, call or text (813) 356-9448 early, so the loan can close before your exchange deadline. We plan the loan around your 45-day and 180-day clock, say early what could slow it down, and work alongside your qualified intermediary.
For the loan, a lender adds three documents to the usual list: your qualified intermediary agreement, the closing statement from the sale of the relinquished property, and the 45-day identification letter you sent to your QI. See the investor loan document checklist.
The application opens on NEXA Mortgage's site, the licensed mortgage company our loans run through.
Related
- 1031 exchange financing
- 1031 clock, online
- Deal analyzer workbook: run the replacement property's numbers.
- All templates
Frequently asked questions
Does the tracker count the days for me?
Yes. The timeline tab shows days remaining to day 45 and to your exchange deadline, counted from today's date each time you open the file. Each deadline gets a status: Sale not closed yet, Passed, Due today, Due soon at 10 days or fewer, or On track. Confirm the dates with your qualified intermediary.
Which date does the tracker use as my exchange deadline?
The earlier of day 180 and the tax return due date you enter, including extensions. In the file's example, a sale on August 20, 2026 with a return due April 15, 2027 makes day 180, February 16, 2027, the deadline. If your return comes due first, the file says so and notes that an extension can restore all 180 days.
Why does the tracker use the sale price for the 200 percent rule?
It uses your sale price as a stand-in for value. IRS Publication 544 states the limit in fair market value terms: the total fair market value of the properties you identify can be no more than double the fair market value of the property you give up. Confirm the right figure with your qualified intermediary.
What does the trade-up check leave out?
Buyer closing costs, prorations, deposits, and other items your qualified intermediary and CPA will account for. The file calls it a simplified check. It estimates cash boot and mortgage boot from your sale price, selling costs, loan paid off, purchase price, and new loan. The file notes that boot is generally taxable up to the amount of your gain.
How many replacement properties can I identify?
You meet the rules if you identify up to three properties of any value, or any number whose total value is no more than double the value of the property you gave up. Go over both limits and you must acquire at least 95 percent of the value you identified. The Identification tab tests your list.
Can I change the properties I identified?
Yes, before day 45 ends. The tracker's notes say you can revoke and replace an identified property in writing before the identification period ends, and that after that the list is final. IRS Publication 544 also says an identification can be canceled at any time before the identification period ends.
