SmartHelping / Real Estate / Excel
Adjusted Cost Basis Template
Record the cost of a property and work through the adjustments behind its cost basis. This Excel template gives you a structured way to organize the calculation for real estate recordkeeping and advisor review.
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
See the template in action
Review the cost basis calculation before you buy.
Watch the walkthrough and open the screenshots to see the spreadsheet's layout and adjustment process.
A focused real estate tool
Bring the basis calculation into one working file.
The template is designed to make recording and calculating a property's adjusted cost basis easier, with a guided approach to the adjustments.
Record the property's starting point
Use your acquisition records to establish the initial amounts for the calculation, with supporting documents available for review.
Work through the changes
Follow the template's adjustment process and identify the items that apply to the property rather than rebuilding the calculation from scratch.
Calculate the resulting figure
Bring the starting amount and relevant adjustments together in an Excel-based cost basis calculation.
Prepare a clearer review file
Use the spreadsheet alongside closing records, invoices, and prior schedules when discussing the calculation with your accountant or advisor.
The basis review framework
Start with cost. Review what changed.
These are common U.S. basis considerations to review, not a substitute for determining the treatment of each item.
Starting basis
For purchased property, basis generally begins with cost plus qualifying acquisition expenses. Not every closing cost qualifies.
Increases to basis
Capital improvements and certain other capitalized costs can increase basis. Deductible current expenses should not be added again.
Decreases to basis
Depreciation allowed or allowable and certain casualty losses, reimbursements, or credits may require reductions.
Special situations
Partial dispositions, gifts, inheritances, and exchanges can require different calculations or allocations.
For U.S. tax guidance, see IRS Publication 551: Basis of Assets. Have a qualified tax professional confirm the treatment of your property's costs and adjustments. This template is a calculation and recordkeeping aid, not tax advice or tax-return preparation software.
How to use it
Move from property records to a reviewable calculation.
Gather the supporting records
Collect the closing statement, relevant invoices, prior depreciation schedules, and documentation of later changes to the property.
Establish the starting amounts
Confirm the property's initial basis with your records and advisor, then enter the applicable information in the template.
Work through the adjustments
Review each applicable item, confirm its treatment, and enter the relevant amounts. Keep the supporting evidence with your property records.
Check and retain the result
Review the resulting adjusted cost basis, reconcile the inputs to your records, and save the completed file for future reference.
Who gets value from it
For owners and advisors organizing property records.
Real estate investors
Organize the cost basis calculation alongside your investment and ownership records.
Rental property owners
Bring the relevant acquisition history and later adjustments into a focused worksheet for review.
Accountants and bookkeepers
Use a structured working file when helping clients assemble and reconcile property information.
Owners preparing for a sale
Gather the basis information needed for a discussion with your tax advisor before completing a transaction.
Also available in these bundles
Need more real estate modeling tools?
The Adjusted Cost Basis template is included in the Real Estate and Super Smart collections.
Real Estate Templates
Explore the collection of real estate investment, development, and property analysis spreadsheets.
View the Real Estate bundleSuper Smart Bundle
Explore the broader SmartHelping collection of financial models, accounting tools, and spreadsheet templates.
View the Super Smart BundleRelated real estate tools
Connect the basis calculation to your broader analysis.
Explore complementary templates for acquisition analysis, development, rental property planning, and depreciation-related work.
Hotel Deal Analysis
Explore a financial model for evaluating a hotel investment.
Explore the hotel modelFix and Flip Scaling Model
Plan a fix-and-flip business across a 10-year financial forecast.
Explore the fix-and-flip modelMulti-Family Acquisition Model
Evaluate the financial assumptions behind a multi-family property acquisition.
Explore the acquisition modelSale-Leaseback Analysis
Review the economics of a sale-leaseback transaction.
Explore the sale-leaseback modelCost Segregation Study Template
Explore a complementary tool for cost segregation analysis.
Explore the cost segregation templateDepreciation Recapture Analysis
Explore a separate model focused on depreciation recapture.
Explore the recapture modelGeneral Real Estate Underwriting
Analyze a real estate investment with a broader underwriting model.
Explore the underwriting modelSingle-Tenant Industrial Real Estate
Evaluate a single-tenant industrial real estate investment.
Explore the single-tenant modelRetail Building Construction
Build a financial plan for a retail construction project.
Explore the construction modelLot Development Cash Flow
Explore the cash flow of a real estate lot development project.
Explore the lot development modelRental Property Scaling Model
Plan the growth of a rental property portfolio.
Explore the rental property modelQuestions before you buy
A few useful details.
What is this template designed to do?
It provides a structured Excel tool for recording and calculating a property's adjusted cost basis, with a process for working through relevant adjustments.
What information should I have ready?
Have your acquisition records and documentation of later changes available. Depending on the property, this may include invoices, prior schedules, and records of dispositions or reimbursements.
Does the spreadsheet replace professional tax advice?
No. Use it to organize the calculation, then confirm the applicable rules and treatment with a qualified tax professional. It should not be treated as a complete tax-return or capital-gains-tax solution.
Can I preview it before purchasing?
Yes. The walkthrough video and expandable screenshots above let you review the template before deciding whether it fits your needs.
Is this a subscription?
No. The standalone template is a one-time $45 purchase with an Excel download.
Is the template included in a bundle?
Yes. It is included in the Real Estate and Super Smart bundles linked above.
Organize the property calculation
Make adjusted cost basis easier to review.
Get the Excel template for recording property costs, working through adjustments, and preparing a clearer basis calculation. One-time purchase for $45.
