WB WorkbookBarn All workbooks

Free calculator · nothing to download

1031 Exchange Timeline & Identification Tracker

Type in the blue cells. The deadlines, the three rules and the boot math all follow from them.

THE SALE THAT STARTS THE CLOCK
THE PROPERTY YOU SOLD
THE PROPERTY YOU ARE BUYING
REVERSE EXCHANGE ONLY

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 / addressLegal description or distinguishable name used in the written IDDate delivered in writingIdentified fair market valueStatusSigned & delivered to the QI?Day number after closingInside the 45 days?% of what you soldNotes
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.

Get the workbook · $24.99

See what is inside the workbook

Keep it

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.

Buy on Etsy · $24.99What is inside →

Email me these results

We'll send this result plus the matching worksheet. No spam, unsubscribe anytime.

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.

WorkbookBarn · All free calculators · Workbooks