Question

Due To/From Journal Entries

Forum|Forum|7 years ago
February 12, 2019
8 replies
66 views

I’m transitioning my bookkeeping to QuickBooks and want to make sure I am setting up my files to coincide with my current PL and BS for all of my LLC’s

I currently own roughly 100 rental properties. I generally create a HOLDING LLC to hold (own) 10 properties. I also have an MGMT LLC that I use to collect income and pay all expenses for all of those 100 properties (10 Holding LLC’s). This MGMT LLC does not own anything, but all income and expenses are received and paid through the MGMT LLC bank account (which makes my life a lot easier).

The balance sheet for my HOLDING LLC’s will always have a running “Due To/From MGMT LLC” as a current asset. This will show me how much the HOLDING LLC owes the MGMT LLC or vice versa.

I would like to continue using one company file in QuickBooks and just use classes and sub-classes for my Holding LLC’s and the properties they own. I can then customize reports to show a PL and BS for each HOLDING LLC.

I want to make sure I am creating my journal entries correctly in order to create what I described above.

Example: MGMT LLC pays $50 for a repair for 123 Main st. (owned by “HOLDING LLC #1”) from MGMT LLC’s bank account.

I’m assuming I need 3 journal entries

$50 repair expense for the sub-class 123 Main st. (owned by ”HOLDING LLC #1”)
-$50 Due To MGMT LLC from HOLDING LLC #1
$50 Due From HOLDING LLC #1

The result I am looking for is the following:

MGMT LLC books are reconciled in its Current Assets, since there was $50 reduced from MGMT LLC bank account and $50 added to the Due From Holding LLC#1.

HOLDING LLC #1 financials would show -$50 “Due To/From MGMT LLC” on its current assets and $50 as a repair expense on its PL.

If I have roughly 600-800 instances of income and expense transactions per month that go through MGMT LLC, will each transaction need this type of journal entries or is there an more efficient/easier way to accomplish the same thing?

QuickBooks Accountant Desktop

john-pero

Level 12

You do not need any journal entries other than year end balance of class allocation. (A single monthly insurance premium need not be split 100 ways when you pay it)

I assume you record rents into management as income or as liability to your sub units?

If income, you use 1099Rent to show the payments to the units.

Use invoices to bill the subs, use billable expenses to assign the costs by unit(customer) and class. Receive customer payments for monthly invoice, deposit to a clearing account, now deposit to the clearing account from each sub unit Due To liability in the management company.

You must, as I understand it, keep each LLC in a separate company file or there is no point in having more than one LLC unless you have additional investors/members.

The Ray Lucia mantra of each property in its own LLC is overblown in my mind. There may be a practical limit solely based on umbrella insurance limits but we only keep separate LLCs when there is a difference in ownership

Due to my perceived need you have of at least 11 company files I highly suggest for cost savings alone you stick with desktop not online. In addition any CRM program like PropertyWare syncs only to desktop.

A

AADPMGMT2016Author

I was hoping I could get a response on my original post. Any thoughts. Is the 3 journal entries the best way to accomplish what I am looking to accomplish in the post?

qbteachmt

Level 11

"I was hoping I could get a response on my original post."

Well, you asked this Twice and you have all sorts of peer user volunteers and the Intuit people trying to help in Both places, now. Here is your Original:

https://quickbooks.intuit.com/community/Other-questions/Due-To-From-for-property-management/m-p/222864#M7139

Nothing about what you asked is done using JE. Banking is done using Banking functions. The Tracking by Name is never JE; those are already customer or vendor names. You have Payees and you have people going to repay. The accounting is done for one entity in one file; it seems you own some of the properties your Management Entity manages, but that is Separate, not combined. And a Management Entity doesn't really incur much as Expense; these are Advanced Costs to be repaid either by the owners or by a holdback of the amount from Rent Gross Liability. That is covered in your answers in your original topic.

I recommend the Real Estate and Property Management Books for using QB by Gita Faust.

M

Malcolm Ziman

Level 4

@AADPMGMT2016 wrote:

-$50 Due To MGMT LLC from HOLDING LLC #1

$50 Due From HOLDING LLC #1

If you are the only owner of all these LLCs, then there is no point in tracking the Due To/From between them, I would think, as you can't owe yourself money. There is no balance sheet required on the tax return for a single member non-corporate LLC

A

AADPMGMT2016Author

Yes, I am the only owner all all but 2 LLC's which I have a partner. I would like to have a clean set of books for each of my holdings LLC's for several reasons.

1) I have a partner on a couple fo them

2) I would like to have a PL and BS to show the banks for a particular LLC. Ex. Main st bank financed the 10 properties with Holdings LLC 4. Would would like to present the PL and BS just for that LLC.

3) MGMT does not have the same member as the holding LLC's

So if I present a BS on behalf of Holdings 4 LLC to a particular bank, I would need to know how much money that LLC owes MGMT LLC (or vice versa) to get an accurate set of books.

qbteachmt

Level 11

@Malcolm Ziman

Is correct for those entities you own personally; there is no Lending between you and yourself and them. That would be Equity activity, not Liability and Asset activity.

You would have one data file per FEIN. You have different requirements depending on what is between which of your entities. Your own Management Entity never has expense or income for other entities' properties. You would have only a revenue stream as management fees. A Property Manager that incurs costs such as Plumbing repairs for property belonging to other entities, even if that also is your own entity, does not have Expense. That was an Advanced Cost as other current asset, to be part of the settlement between the Management firm that also collected Rent not as income but as Liability.

All of this is too complex for the text-based QB peer user internet forum.It's time to get personal one-on-one support and work with your own CPA for these intertwined relationships.

Banks know how to read financial statements. They don't need to see artificial Lending across your own entities.

Sign up

Login with SSO

Let's get you signed in

Login with SSO