Skip to content
×
PRO
Pro Members Get Full Access!
Get off the sidelines and take action in real estate investing with BiggerPockets Pro. Our comprehensive suite of tools and resources minimize mistakes, support informed decisions, and propel you to success.
Advanced networking features
Market and Deal Finder tools
Property analysis calculators
Landlord Command Center
$0
TODAY
$69.00/month when billed monthly.
$32.50/month when billed annually.
7 day free trial. Cancel anytime
Already a Pro Member? Sign in here
Pick markets, find deals, analyze and manage properties. Try BiggerPockets PRO.
x
All Forum Categories
All Forum Categories
Followed Discussions
Followed Categories
Followed People
Followed Locations
Market News & Data
General Info
Real Estate Strategies
Landlording & Rental Properties
Real Estate Professionals
Financial, Tax, & Legal
Real Estate Classifieds
Reviews & Feedback

All Forum Posts by: Adam Hays

Adam Hays has started 7 posts and replied 30 times.

Post: QuickBooks for Flippers - Inventory vs COGS

Adam HaysPosted
  • Investor
  • Blue Springs, MO
  • Posts 34
  • Votes 6
Quote from @J Scott:
Originally posted by @Eric M.:

J, came across this post from last year and for the first time I am running into a project that significantly overlaps tax years.

I use your CoA for Quickbooks and your general Cogs accounting technique.  Can you give a bit more detail about how you General Journal Cogs over to a WIP account at year end?

I don't have any experience with WIP. You are talking about moving the Cogs to the balance sheet? If so, to be specific, do you create separate WIP asset accounts for each COGS account, or can you just accumulate all your COGS for a property and put it in one WIP sub account under the Main property asset account?

Thanks

Hey Eric,

This is how my accountant (and therefore I) do it...

1.  Create a "Fixed Asset" account called "WIP" (Work in Progress) or "Flip Inventory" (this is the account used to move the COGS to in order to move it off the P&L

2.  Create a "Cost of Goods Sold" account called "WIP Reclass for Year End" (this the account account used to offset the COGS moved to the balance sheet)

3.  On December 31 of the tax year, do a General Journal entry that moves the total amount of COGS from flips in progress onto the balance sheet (specifically, credit the WIP Reclass account and debit the Flip Inventory account).  If you want, you can do a separate journal entry for each project in progress.  Here's an example of what the journal entry looked like on 12/31/2019 for the two projects I had in progress in one of my companies:

In this case, I was $84K into my 21st Street project (not yet completed) and $176K into my N Morgan project (not yet completed).

Now, when you run a P&L through 12/31, you see that these two amounts are credited back to the COGS, so these costs aren't recognized in that tax year.  And you'll see them show up as inventory on your balance sheet.

4.  On January 1 of the following year (the next day), you reverse the journal entry to move those projects back to COGS from inventory.  Like this:

Let me know if there's anything that doesn't make sense there!


 Could you accomplish the same thing and help to create a more accurate balance sheet, as @Gina Faust suggest, by periodically (weekly, monthly) doing the same thing as year end?

By using the WIP Reclass Account we maintain all of our Project and Class integrity for the QB Online Reporting and Project bells and whistles, and this seems easy to explain on a balance sheet as a sub account of COGS

Post: Manufactured, modular & mobile home loan financing

Adam HaysPosted
  • Investor
  • Blue Springs, MO
  • Posts 34
  • Votes 6

@Jo-Ann Lapin do you do prior to June 1976?

Post: Solid long term rental

Adam HaysPosted
  • Investor
  • Blue Springs, MO
  • Posts 34
  • Votes 6

This house been completely remodeled inside. This unit will be hassle free for quite awhile.

Contact me at [email protected] for info or to schedule a viewing

New plumbing

New electrical

New appliances

New fixtures

New flooring

New Water Heater

New Paint

Vinyl Windows

Pictures:

Bathroom

Kitchen

Kitchen 2

Kitchen 3

Living Room

Front Bedroom

Post: Turnkey rental property for sale, east side of Kansas City, MO

Adam HaysPosted
  • Investor
  • Blue Springs, MO
  • Posts 34
  • Votes 6

do you have photos? Please send me an email. 

[email protected]

Post: Accounting for an all Cash purchase

Adam HaysPosted
  • Investor
  • Blue Springs, MO
  • Posts 34
  • Votes 6

@Daniel Roca Thanks!

whats PP&E?
would I list the equity as an asset on the Balance sheet? It seems like most of the balance sheet examples I find are filled with things that don't pertain to use with a small portfolio. Do you have a good example of a Real Estate Balance Sheet, and a Cash Flow Statement?

Post: Kansas City Missouri Zip Codes

Adam HaysPosted
  • Investor
  • Blue Springs, MO
  • Posts 34
  • Votes 6

I would add that if you are local and can properly screen tenants, and meticulously manage the property you can find pretty good cash flow in 64053 and 64052 but it carries more risk for sure.  

Post: Accounting for an all Cash purchase

Adam HaysPosted
  • Investor
  • Blue Springs, MO
  • Posts 34
  • Votes 6

we paid cash for a multifamily property. When creating a monthly profit and loss statement do you include property acquisition as an expense? Or do you just include it in the balance sheet and don't really count it as an expense. 

Post: Should I buy for appreciation due to the second coming of Christ?

Adam HaysPosted
  • Investor
  • Blue Springs, MO
  • Posts 34
  • Votes 6

@Linda Weygant I mean, if I buy this place is JC gonna be beating on the door trying to collect his Milly?

Post: Should I buy for appreciation due to the second coming of Christ?

Adam HaysPosted
  • Investor
  • Blue Springs, MO
  • Posts 34
  • Votes 6

@William Hochstedler I did think of doing that. I'll keep you posted

Post: Should I buy for appreciation due to the second coming of Christ?

Adam HaysPosted
  • Investor
  • Blue Springs, MO
  • Posts 34
  • Votes 6

I'm digging through public records on a property going to auction soon and came across this. This has to be some loony tune, bat crap crazy stuff right? I didn't read it all btw, my skin was starting to burn and the lights in my house started to flicker.

Link to PDF in my dropbox