Accounting and Record Keepingng
I receive a lot of questions about my company’s method for accounting and recording keeping for our rehab projects. For those who have been in this business for a while, you probably have your own system that you rely on and that works well for you; for others who are just starting out, hopefully this will give a framework for thinking about these types of things…
First, I use Quicken for all my accounting and financial record keeping. I know a lot of people prefer QuickBooks for business accounting, but I find it to be a bit too cumbersome for current needs. If necessary, I’ll port my Quicken data over to QuickBooks at some point in the future if I ever decide to switch, but in the meantime, both my employees and my accountant have adapted to our system.
As for how I break down my financial view of a house flip, it looks something like the following:
Purchase Costs
This group accounts for all costs incurred up until the day I own the property. This includes any earnest money deposits, inspections, appraisals, financing fees/charges, closing costs, bank credits, etc.
I like to keep this as a separate category because this group of expenses represents costs that I’ve incurred not just on the properties I flip, but also on some properties that I investigate but don’t end up purchasing. For example, if I put a property under contract, hire an inspector to do a property inspection, and then later back out of the deal, I still need to account for those inspection costs.
That said, I keep a close eye on this group of expenses (I have several reports that I run once a month in Quicken); because there are a lot of “sunk costs” (costs that are never recouped) in this area, I try to ensure that I do everything possible to keep expenses in this area as low as possible.
Rehab Costs
Rehab costs are all costs associated with both materials and labor during the rehab. Material costs consist of everything that gets purchased for the property and will stay with the property (materials used for staging that will be retrieved upon sale are not counted). Contractor costs include everything from the GC to the landscaper to the termite inspection to all the other sub-contractors I might hire.
In short, rehab costs are essentially anything I spend to renovate the property.
Holding Costs
Holding costs are those costs that accrue the longer I hold the property, generally monthly. This includes any mortgage or loan payments against the property, property taxes, insurance premiums, utility payments (water, electricity, gas, garbage, etc), lawn care (once the rehab is complete), etc.
Selling Costs
Selling costs are all the costs accrued in order to sell the property. This includes commissions, any closing costs I might pay on behalf of the buyer, selling closing costs, any mortgage or loan payoffs, etc.
This category also includes items required by the buyer as part of the purchase contract. For example, if the buyer requires a termite letter, that would be included as part of the selling costs. In the case where the buyer requires that a repair be performed that should have been performed during rehab, I may attribute the cost to Rehab Costs.
Lastly, any refunds or over-payments that are returned to me — such as escrowed funds or insurance over-payments — are also attributed to selling costs.
I’ve found that this system of managing and organizing expenses is very effective for the way I think about this business, and I extend it past just my financial management software. We keep four folders for each property (Purchase, Rehab, Holding, Selling), along with a “Receipts” folder; these coincide to the financial groupings that I use so it’s generally pretty easy to find and cross-reference items when I need any property information.



{ 8 comments… read them below or add one }
My bookkeeper wants me to create a chart of accounts for my fix-n-flip business. I don’t want to reinvent the wheel, but do you have a Chart of Accounts that you use for your fix ‘n flip business that you wouldn’t mind sharing? I found a good one from the National Association of Home Builders, but I wanted to see if maybe you had something better. Let me know. Thanks. -Gerard
Gerard -
Are you referring to a chart of accounts as would be used in Quickbooks? If so, I’m happy to share what I use…just shoot me an email from my contact link on the Home Page…
Please send to me as well!
I will send an email as well..
Thanks!
Thanks for the high level summary. Have never used quicken, but with Quickbooks we have to deal with capitalizing costs in WIP, converting it to COGS when sold, etc. Not overly difficult once we plow through the hundreds of tidbit information (yet to find a comprehensive walk-through – and would write one if I knew enough) available on the intuit site. That said, do you have simialr issues with decided what to expense, what to capitalize, debit and credits to move the money around from WIP to COGs, etc? Does your accountant do all this?
If you have this information to share, I would also like a sample or copy of your “Chart of Accounts” please. Thank you for all the helpful info.
Hi Cheryl,
My accountant is actually in the middle of overhauling my QuickBooks chart of accounts; once he’s done with it, I’m happy to send you the latest version.
Please send to me as well!
I will send an email as well..
Thanks!
I clicked on your link to free Flipper Software, but it’s not free.