How to record a 1031 exchange in quickbooks?

Question

How can I accurately record a 1031 exchange transaction in QuickBooks to ensure proper tracking of deferred gains and compliance with IRS requirements?

ARTE's Answer

Recording a 1031 exchange in QuickBooks involves several steps to ensure that the transaction is accurately reflected in your financial records. A 1031 exchange allows you to defer capital gains taxes by reinvesting the proceeds from the sale of a relinquished property into a like-kind replacement property. Here’s a detailed guide on how to record this in QuickBooks, using Deferred.com as your qualified intermediary.

  1. Set Up Accounts:
    • Create a New Asset Account: First, set up a new asset account for the replacement property. Go to the Chart of Accounts, click on "New," and select "Fixed Asset" as the account type. Name it appropriately, such as "Replacement Property."
    • Create a Liability Account for the Mortgage: If the replacement property is financed, create a liability account for the new mortgage. This will help you track the loan balance.
  2. Record the Sale of the Relinquished Property:
    • Create a Journal Entry: Go to "Company" and select "Make General Journal Entries." Record the sale by debiting the accumulated depreciation and crediting the asset account of the relinquished property to remove it from your books. Also, credit the gain on sale if applicable.
    • Record the Proceeds: Debit the "Exchange Proceeds" account (a current asset account) for the net proceeds received from the sale. This account will temporarily hold the funds until they are used to purchase the replacement property.
  3. Engage Deferred.com as the Qualified Intermediary:
    • Record the Transfer to Deferred.com: Since Deferred.com is facilitating the exchange, you need to record the transfer of funds to us. Create a journal entry to credit the "Exchange Proceeds" account and debit a "Deferred.com Holding Account" (another current asset account) to reflect that the funds are held by us.
  4. Purchase the Replacement Property:
    • Record the Purchase: Once the replacement property is acquired, create a journal entry to debit the "Replacement Property" asset account for the purchase price. Credit the "Deferred.com Holding Account" for the amount used from the exchange proceeds.
    • Record the Mortgage: If there is a mortgage, credit the liability account you created for the mortgage amount.
  5. Record Exchange Expenses:
    • Transaction Costs: Any transaction costs paid from the exchange proceeds, such as title fees or commissions, should be recorded as expenses. Debit the appropriate expense accounts and credit the "Deferred.com Holding Account."
  6. Adjust for Boot (if applicable):
    • Record Boot: If you received any non-like-kind property or cash (boot) in the exchange, record it as a gain. Create a journal entry to credit a "Gain on Exchange" account and debit the "Deferred.com Holding Account" for the boot amount.

Example

Let’s say you sold a relinquished property for $500,000, with $20,000 in selling expenses, and used Deferred.com as your qualified intermediary. The net proceeds of $480,000 are transferred to us. You then purchase a replacement property for $600,000, with a $120,000 mortgage.

  • Sale of Relinquished Property:
    • Debit: Accumulated Depreciation $100,000
    • Credit: Relinquished Property Asset $400,000
    • Credit: Gain on Sale $80,000
    • Debit: Exchange Proceeds $480,000
  • Transfer to Deferred.com:
    • Debit: Deferred.com Holding Account $480,000
    • Credit: Exchange Proceeds $480,000
  • Purchase of Replacement Property:
    • Debit: Replacement Property $600,000
    • Credit: Deferred.com Holding Account $480,000
    • Credit: Mortgage Payable $120,000
  • Record Exchange Expenses:
    • Debit: Title Fees $5,000
    • Credit: Deferred.com Holding Account $5,000

By following these steps, you can accurately record a 1031 exchange in QuickBooks, ensuring that your financial records reflect the transaction correctly. Always consult with a tax professional to ensure compliance with IRS regulations and to address any specific nuances related to your exchange.

Have more questions? Call us at 866-442-1031 or send an email to support@deferred.com to talk with an exchange officer at Deferred.

Deferred's AI Real Estate Tax Expert (ARTE) is a free research tool. Trained on 8,000+ pages of US tax law, regulations and rulings, ARTE outperforms human test takers on the CPA exam. This is page has ARTE's response to a common 1031 Exchange question and should not be considered personalized tax advice.

Sources

1031 Question? Ask ARTE

Deferred's AI 1031 Research Assistant is trained on 8,000+ pages of US tax law and outperforms human CPAs by 22%+

CHAT NOW

Learn More

See more frequently asked questions about 1031 exchanges

Can you do a 1031 exchange on residential property?
Can a residential property be used in a 1031 exchange, and if so, what are the specific conditions or requirements that must be met for the property to qualify as like-kind for investment or business purposes under Section 1031 of the Internal Revenue Code?
How to revoke identified property in a 1031 exchange?
How can I cancel or change the identification of a replacement property in a 1031 exchange after it has been initially identified, and what are the implications or procedures involved in doing so?
In a 1031 exchange like transaction, who is in charge of holding the money generated by the sale?
In a 1031 exchange, who is responsible for holding the proceeds from the sale of the relinquished property to ensure compliance with IRS regulations and to facilitate the acquisition of the replacement property?
When to do a 1031 exchange?
What are the optimal circumstances or scenarios in which a taxpayer should consider utilizing a 1031 exchange to defer capital gains taxes on the sale of investment or business-use property?
Can you do a partial 1031 exchange?
Can I conduct a 1031 exchange where only a portion of the proceeds from the sale of my relinquished property is reinvested into a like-kind replacement property, and if so, how would this affect the deferral of capital gains taxes?