Quickbooks configuration for flipping multiple properties

Quickbooks configuration for flipping multiple properties

Flipper/Rehabber · Long Island, NY · Member since 2018 · 37 posts · 20 votes

I am looking for some insight into how others are tracking their finances for doing multiple flips. We are currently using a custom-built system to track receipts and expenses by property, but are considering switching to Quickbooks to have a more comprehensive view of the entire business - things that are not related to a specific property, such a payroll, rent, etc. and be able to keep track of money that frequently gets moved around between different accounts/entities.

I've been reading about how everyone uses Classes in Quickbooks to track P&L by property, storing property purchase and associated expenses as a "work in progress" (WIP) current asset and then changing those to COGS when the property is sold. This is great while the property is under construction and I can see how much money has been spent on construction, utilities, etc. right on the balance sheet. However, once I make the journal entry to convert those WIP assets to COGS, I can no longer see how much was spent in each of these categories for deals that have been sold - we like to look back and see how we did on certain deals. Do people create COGS accounts that correspond to the WIP current assets accounts so that all the categorization persists after moving from WIP to COGS, similar to below?

WIP-Inventory - Current Asset

-- WIP-Landscaping

-- WIP-Construction

-- WIP-Utilities

COGS

-- COGS-Landscaping

-- COGS-Construction

-- COGS-Utilities

I have also seen some people talk about using Items, but I am not sure of the Pros/Cons of this approach instead.

Lastly, is there a good way to manage estimated vs actuals for things like construction costs so we can see how we faired against our estimates?

0Reply
44 views

Most Popular Reply

J ScottPro Member
Moderator
Investor · Sarasota, FL · Member since 2008 · 17k+ posts · 17k+ votes
7y

I consider all costs COGS from the get-go, but broken down into sub-accounts like you have above.

Obviously, the costs aren't really COGS until I sell the property, but I let my accountant handle that at the end of the year.  For the properties that haven't yet sold, he does a Journal Entry to record the total costs to WIP; that entry is reversed once we sell.

See this reply in the discussion

4 Replies

Jump to latestLatest
  • J ScottPro Member
    Moderator
    Investor · Sarasota, FL · Member since 2008 · 17k+ posts · 17k+ votes
    7y

    I consider all costs COGS from the get-go, but broken down into sub-accounts like you have above.

    Obviously, the costs aren't really COGS until I sell the property, but I let my accountant handle that at the end of the year.  For the properties that haven't yet sold, he does a Journal Entry to record the total costs to WIP; that entry is reversed once we sell.

  • Real Estate Consultant · Norfolk, VA · Member since 2017 · 342 posts · 200 votes
    7y

    @Ben Wagner You are on the right track by tracking each property using Class, and tracking construction under WIP and then moving WIP to COGS once sold. And yes, you can create similar sub-account under COGS like you have them in WIP. Here's an example of P&L report with %.

    I have not tried using items but I think doing that will make the process more complicated, rather than just entering it at the register.  

    You can use the budget feature in Quickbooks but that is limited to P&L account not balance sheet. You can see your performance by running actual vs budget P&L for the items you already sold, for the ongoing projects, you can export the progress and put it in excel to compare it with your estimate. Or you can do what J Scott's doing, charge everything to COGS then move it to WIP comes reporting time. 

    Here's an example of custom report to see your progress on ongoing projects. 

    Good luck!

  • Will BarnardPro Member
    Moderator
    Developer · Santa Clarita, CA · Member since 2008 · 15k+ posts · 10k+ votes
    7y

    I use classes and items. The class portion is simply, each property is classed by property name. For item, I name the item (call it whatever you want, I use “investment properties”) and then I create sub items under that name - Framing, HVAC, Plumbing, electrical, landscape, etc. This way I get one lump item for total plus the sub items so I can go back and know what I spent on each category. Not sure if this is the best way or only way but it is my way.

  • Flipper/Rehabber · Long Island, NY · Member since 2018 · 37 posts · 20 votes
    7y

    @J Scott that's an interesting approach and would allow you to compare actuals vs budget since that's done on the P&L. I'll have to see what my accountant thinks about that.

    @Dan V. that makes sense having the same broken out accounts in WIP and COGS so that you don't lose that data.

    @Will Barnard I may end up experimenting with Items which would provide some additional granularity without having to add a ton of different accounts.

    Is anyone using projects? It seems like if I end up going down the route of using a construction management tool like CoConstruct or BuilderTrend, they are built around Projects and Items - which makes sense for their core market of home builders/remodelers, but I'm not sure whether it will work well for fix & flips.

Join the conversationCreate a free account to reply, vote on answers and follow this thread.