Huge Savings
Get our price list!
Buy with Confidence
from a Premier Intuit Reseller
Free Shipping
Direct from Intuit
No Sales Tax
(in some states)
Try it free for 30 days

Huge Savings!

Add-ons


CRM: Online marketing: Field service mgmt.: POS email marketing: Inventory: E-commerce: Reporting: Time tracking: Billing/invoicing: Travel/expense mgmt: Donor management:

Business Tools


Social media mgmt: Cloud applications: Email marketing: Webstores: Online chat:

How to Invoice Real Estate with Owner Financing in QuickBooks

I work for a real estate developer and brokerage, who, along with buying residential lots, also does owner financing. Then, we turn around to sell the properties.  My question is: How do I get the notes receivable to report as a receivable and not as an asset?  I have entered the purchase of the properties under Inventory. Once we sold, and the Investor selected to do owner financing, I then entered a notes receivable for each lot. Then, to invoice, I entered a Sale-Lot# item, which I then linked it to the proper Note. I use QuickBooks to do our billing, and before I get one doing this, I want to make sure I am doing it correctly. The problem is that the notes receivable are not reporting correctly because of how the notes receivable was set-up.  What is the right way to do these transactions? The one thing I ask stays the same it is being able to do Bulk Sales postings in the Journal Entry and in the invoicing.  Thank you.
Only in rare cases would you want to map a sales item to an account that is increased with debits (assets and expenses) because items on sales transactions generate credits and credits decrease the balance of assets or expenses instead of increasing it. 

Instead of using items, I recommend that you create an additional accounts receivable account for your notes receivable.  In many case, you can easily change the account type by going to Lists > Chart of Accounts, clicking on the Accounts button, selecting Edit and just changing the account type..  However, unfortunately QuickBooks doesn’t allow you to change account types to accounts receivable or payable.  So you’ll need to setup new accounts using the accounts receivable type.  Once you do, a new Account drop-down box will be displayed at the top of your invoices so you can choose whichever receivable account you want to use. 

You can also change your previous invoices to use the correct account.  However, once you’re done make sure to check your Open Invoices report (Reports > Customers & Receivables) to make sure you didn’t unlink any of payments/credits from invoices.  If you did, open the invoice and click the Apply Credits button to link them up again.

If you want to map an item so it can be used on purchase transactions, ordinarily to an expense account or an asset account such as work in progress, you should make the item two-sided by checking the box next to “This item is used in assemblies…”  This expands the item information so you can enter both purchase and sales accounts.  The purchase account is normally one that is increased with debits (cost of goods sold, expense or asset) because when you use an item on a purchase transaction it generates a debit.  The sales account is normally one that is increased with credits (revenue, liability or equity) because when you use an item on a sales transaction is generates a credit.


Visit our webstore for huge savings on QuickBooks!

This article is provided for informational purposes and is not intended to be construed as legal, accounting, or other professional advice. For further information, please consult appropriate professional advice from your attorney and certified public accountant.

Ruth Perryman - QuickBooks Specialist Written by +Ruth Perryman, CMA, CFE, CFM, MBA

Ruth is the president of The QB Specialists, an Intuit Premier Reseller that offers huge savings and expert advice on QuickBooks POS and QuickBooks Enterprise. She is an Advanced Certified QuickBooks ProAdvisor and a member of Intuit’s Trainer/Writer Network. She is also certified in QuickBooks POS and QuickBooks Enterprise and has provided expert QuickBooks help to thousands of businesses all over the world since 1996.

Web Store | Price List | Free Trials | Newsletter

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>