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

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 →

Get the next free tool

One email when a new free calculator or trade guide ships. No spam, unsubscribe anytime.

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