I started to write this post before Bill wrote his and have to laugh because he is an accountant and talks like an accountant, he even made my eyes go glassy. (My own CPA makes my eyes go glassy...which is a a form of flattery to all Accountants because they sure know their stuff) But to the normal Joe ya have to talk like a Landlord and not as an accountant. So here is what I wrote before Bill posted.
First of all, personally, I would setup my business with each LLC having their own company file and each LLC having their own bank account. That's just me. Most of the people I talk to about QuickBooks who have various LLC's fight me tooth and nail regarding them setting up their company files as I recommend them to do. Somehow they just hate to click on File and previous company file to go back and forth to each company.
With that said and done, they ask me if they can merge their LLC's into one company and I say yes you can, but make each LLC a Class and each property that belongs to that LLC as a subclass.
Then do the same thing with the bank account.
You have your Major Bank, list Each LLC as a sub bank.
When you get your bank statement back, it will list the bank total and your deposit and expenses.
Since your Bank Account is the Header and the LLC's are a sub account of the bank, all their deposits and expenses are going to appear as one bank, because it is one bank. You just are listing different deposits and expenses that make up that bank statement, but assigning them to various sub accounts, various LLC's.
When you reconcile your bank account, do it as normal reconciliation in QuickBooks and choose the deposits and withdrawals that match each other. Bank Statement with QuickBooks Statement
It's the same concept as having Security Deposits from various tenants put into a Security Trust Fund Account. One Bank Account, various security deposits.
When you get your statement from the bank for the Security Deposits it will list all your deposits, and you just match those deposits with the deposits that appear in your Security Deposit list.
SECURITY DEPOSIT TRUST FUND ACCOUNT..................................Total $3,000.00
Barbara Rose: $750.00
Candy Cane: $1050...
Benjamin Franklin: $1200.00
LLC MANAGEMENT COMPANY..........................................................Total $10,500.00
Town and Country Rentals LLC............................$3,000.00
Reliable Properties LLC.........................................$5,000.00
Sunrise Apartments LLC............................................$2500.00
When you make a deposit, the deposits reflect the entries that you assign to each LLC
As you can see the main bank has the all the deposits you made per LLC as one total. When you make the deposits the deposit slip will list each deposit made with the total of all deposits.
It's like working for a utility company and everyone makes a payment by check. You take their checks and enter them on the deposit slip, go to the bank with one big deposit, that lists all the checks that make up the deposit. (Haven't you been to a bank and were so lucky to stand behind a company depositing all their checks into their account? Long time standing !!
This is no different than a company taking all their checks to the bank and making a deposit. You list the LLC Deposits as a list and use the total as the deposit total.
The same thing with your expenses. You write a check for the expense choosing the sub bank account that belongs to that LLC the expense is from and it will deduct the total of that LLC's bank balance as well as the main bank total.
Hope this helps.
Nancy Neville