Type in the blue cells. The deadlines, the three rules and the boot math all follow from them.
THE TWO DEADLINES
45-day identification deadline—
180-day closing deadline—
DAYS LEFT TO IDENTIFY—
Days left to close—
Days elapsed since closing—
WHAT YOU HAVE IDENTIFIED
Properties identified (withdrawn excluded)—
Total identified value—
Value actually closed so far—
Rows delivered after day 45—
THE THREE IDENTIFICATION RULES
200% cap - twice what you sold—
Room left under the 200% cap—
Three-property rule—
200% rule—
Share of identified value actually received—
95% rule—
THE RULE YOU ARE RELYING ON—
Does the identification comply right now?—
BOOT AND GAIN
Net selling price after costs—
Realized gain on the sale—
Cash boot—
Mortgage boot - debt shed and not replaced—
Total boot—
Gain taxable now—
Gain deferred—
Basis in the replacement property—
Traded down by—
REVERSE EXCHANGE PARKING
Parking must end by—
Days left in the parking period—
Identification Log
One row per candidate replacement property. The three-rule panel on THE CLOCK reads this tab.
Property / address
Legal description or distinguishable name used in the written ID
Date delivered in writing
Identified fair market value
Status
Signed & delivered to the QI?
Day number after closing
Inside the 45 days?
% of what you sold
Notes
1
—
—
—
2
—
—
—
3
—
—
—
4
—
—
—
5
—
—
—
6
—
—
—
7
—
—
—
8
—
—
—
9
—
—
—
10
—
—
—
11
—
—
—
12
—
—
—
13
—
—
—
Where that leaves you
—
Want it as a spreadsheet you own?
The full workbook adds the tabs this page cannot: a monthly log, a dashboard with charts,
and your own copy that works offline in Google Sheets or Excel. One purchase, no subscription.
1031 Exchange Timeline & Identification Tracker: the full workbook
Same formulas as this calculator, plus the tabs, the charts and a 12-month history that this page cannot hold. Google Sheets and Excel. One purchase, no subscription.
We'll send this result plus the matching worksheet. No spam, unsubscribe anytime.
Done — you are on the list.
Something went wrong. Please try again.
Last updated: October 2026
Educational estimates only. These calculators and workbooks do the arithmetic on the figures you enter; they are general-purpose tools, not financial, investment, tax, legal, lending, insurance or construction advice, and no result is a quote, an offer, or a guarantee of any outcome. Results depend entirely on your inputs and assumptions. Verify anything you intend to rely on with a licensed professional — a CPA, attorney, lender, licensed contractor, or your own agent. WorkbookBarn and Marcos Gil accept no liability for decisions made using these tools. Marcos Gil is a licensed Kentucky real estate agent (License No. 296259) and is not a lender, CPA or attorney.