How do I do double-entry bookkeeping for separately-managed investment accounts?
"For any accounts where you have a wish to keep track of dividends, gains and losses, etc., you will have to set up a an account to hold the separately listed securities.  It looks like you already know how to do this.  Here the trading accounts will help you, especially if you have Finance:Quote set up (to pull security prices from the internet). For the actively-managed accounts, you can just create each managed account and NOT fill it with the separate securities.  You can record the changes in that account in summary each month/year as you prefer. So, you might set up your chart of accounts to include these assets: And this income: The actively-managed accounts will each get set up as Type ""Stock.""  You will create one fake security for each account, which will get your unrealized gains/losses on active accounts showing up in your trading accounts.  The fake securities will NOT be pulling prices from the internet.  Go to     Tools -> Securities Editor -> Add and type in a name such as ""Merrill Lynch Brokerage,"" a symbol such as ""ML1,"" and in the ""Type"" field input something like ""Actively Managed."" In your self-managed accounts, you will record dividends and sales as they occur, and your securities will be set to get quotes online.  You can follow the general GnuCash guides for this.   In your too-many-transactions actively traded accounts, maybe once a month you will gather up your statements and enter the activity in summary to tie the changes in cost basis.  I would suggest making each fake ""share"" equal $1, so if you have a $505 dividend, you buy 505 ""shares"" with it.  So, you might have these transactions for your brokerage account with Merrill Lynch (for example): When you have finished making your period-end summary entries for all the actively-managed accounts, double-check that the share balances of your actively-managed accounts match the cost basis amounts on your statements.  Remember that each fake ""share"" is worth $1 when you enter it.  Once the cost basis is tied, you can go into the price editor (Tools -> Price Editor) and enter a new ""price"" as of the period-end date for each actively-managed account.  The price will be ""Value of Active Acct at Period-End/Cost of Active Acct at Period-End.""  So, if your account was worth $1908 but had a cost basis of $505 on Jan. 31, you would type ""1908/505"" in the price field and Jan. 31, 2017 in the date field. When you run your reports, you will want to choose the price source as ""Nearest in Time"" so that GnuCash grabs the correct quotes. This should make your actively-managed accounts have the correct activity in summary in your GnuCash income accounts and let them work well with the Trading Accounts feature."
Thanks for the answer/comments! The time-based method was something we mooted and something I almost went with. But just to wrap this up, the method we settled on was this: Every time there is an entry or exit into the fund, we divvy out any unrealised market profits/losses according to each person's profit share (based on % of the asset purchased at buy-in) JUST BEFORE the entry/exit. These realised profits are then locked in for those particpants, and then the unrealised profits/loss counter starts at zero, we do a fresh recalculation of shareholding after the entry/exit, and then we start again. Hope this helps anyone with the same issue! "You need one ""company file"" for each company that you want to track through QuickBooks.  Looks like, in your case, that is at least the PM and the PH (as you labeled them in your question).  The companies that just hold property and pay utilities might be simple enough that you don't need the full power of QB, in which case you might just track their finances on a spread sheet.  Subsidiary companies will probably appear as ""assets"" of some sort on the books of the parent company. This set-up probably does limit liability at some level, but it's going to create a lot of overhead for your that incurs some expense either in your time or in actual fees paid.  You should really consider whether the limitations on liability balance against those costs. (Think ahead to what you're going to do when you have to file taxes on this network of companies, whether you need separate insurance policies for each instead of getting one policy covering multiple properties, etc.)" how many transactions per year do you intend? Mixing the funds is an issue for the reasons stated.  But. I have a similar situation managing money for others, and the solution was a power of attorney. When I sign into my brokerage account, I see these other accounts and can trade them, but the owners get their own tax reporting. How do I account for this in the bookkeeping? Here is an example below:  This is how you would accurately depict contributions made by an owner for a business. If you would want to remove money from your company, or pay yourself back, this would be called withdrawals. It would be the inverse of the first journal entry with cash on the credit side and withdrawals on the debited side (as it is an expense).  You and your business are not the same thing. You are two different entities. This is why you are taxed as two different entities. When you (the owner) make contributions, it is considered to be the cash of the business. From here you will make these expenses against the business and not yourself.  Good luck, I skimmed the answer from mirage007, and it looked correct if you're going to set this up from scratch.  Since you said you already have a system for tracking stocks, however, maybe you'd prefer to use that.  It should handle almost everything you need: Note that only the last of these actually ties the option and the underlying together in your accounting system.  Other than that case, the option behaves in your accounting system as if it were a stock. (It does not behave that way in the market, but you need to manage that risk profile outside of the double-entry accounting system.) "Journal entry into Books of company: 100 dr. expense a/c 1 200 dr. expense a/c 2 300 dr. expanse a/c 3   //   cr. your name 600 Each expense actually could be a total if you don´t want to itemise, to save time if you totaled them on a paper.  The paper is essentually an invoice. And the recipts are the primary documents. Entry into Your journal: dr. Company name   // cr. cash or bank You want the company to settle at any time the balce is totaled for your name in the company books and the company name in your books.  They should be equal and the payment reverses it.  Or, just partially pay. Company journal: dr. your name  //  cr. cash or bank your journal: dr. cash or bank  // cr. company name Look up ""personal accounts"" for the reasoning. Here is some thing on personal accounts. https://books.google.com/books?id=LhPMCgAAQBAJ&pg=PT4&dq=%22personal+account%22+double+entry&hl=es-419&sa=X&redir_esc=y#v=onepage&q=%22personal%20account%22%20double%20entry&f=false" "The bank ""credit's"" your account for money coming into it. In double entry accounting, you always have a debit and a credit to balance the accounts. As an Example: for $500 that the bank credited to your checking account, you would post a debit to Cash and a Credit to Income Earned. The accounting equation is: Assets = Liabilities + Owner's Equity                             $500   =                    $500 Cash is the ""Asset"" side of the equation, Income is part of Owner's Equity, and so is the Credit side... to make the equation balanced." "My answer is Microsoft Excel.  Google ""VBA for dummies"" (seriously) and find out if your brokerage offers an 'API'.  With a brief understanding of coding you can get a spreadsheet that is live connected to your brokers data stream.  Say you have a spreadsheet with the 1990 value of each in the first two columns (cells a1 and b1).  Maybe this formula could be the third column, it'll tell you how much to buy or sell to rebalance them.   then to iterate the rebalance, set both a2 and b2 to =C1 and drag the formula through row 25, one row for each year.  It'll probably be a little more work than that, but you get the idea." The GnuCash manual has a page with examples of opening new accounts. The tl;dr is: use the Equity:Opening Balance to offset your original amounts. The further explanation from the GnuCash page is: As shown earlier with the Assets:Checking account, the starting   balances in an account are typically assigned to a special account   called Equity:Opening Balance. To start filling in this chart of   account, begin by setting the starting balances for the accounts.   Assume that there is $1000 in the savings account and $500 charged on   the credit card. Open the Assets:Savings account register. Select View from the menu and check to make sure you are in Basic Ledger style. You will   view your transactions in the other modes later, but for now let’s   enter a basic transaction using the basic default style. From the Assets:Savings account register window, enter a basic 2 account transaction to set your starting balance to $1000, transferred   from Equity:Opening Balance. Remember, basic transactions transfer   money from a source account to a destination account. Record the   transaction (press the Enter key, or click on the Enter icon). From the Assets:Checking account register window, enter a basic 2 account transaction to set your starting balance to $1000, transferred   from Equity:Opening Balance. From the Liabilities:Visa account register window, enter a basic 2 account transaction to set your starting balance to $500, transferred   from Equity:Opening Balance. This is done by entering the $500 as a   charge in the Visa account (or decrease in the Opening Balance   account), since it is money you borrowed. Record the transaction   (press the Enter key, or click on the Enter icon). You should now have 3 accounts with opening balances set. Assets:Checking, Assets:Savings, and Liabilities:Visa. If you go through the web pages of some online brokers, you will find out that some of them allow you to manage friends/relatives accounts from your account as a trusteer. That should really solve your underlying problem, you will need only one login, etc. (Example: https://www.interactivebrokers.com/ff/en/main.php) If I understand it right it will even allow you to make one trade splitting the cost and returns among the other accounts, but you would have to verify that. Anyways, that will save you a lot of trouble and your broker can probably help you with the legal necessities. "If you are using software like QuickBooks (or even just using spreadsheets or tracking this without software) use two Equity accounts, something like ""Capital Contributions"" and ""Capital Distributions"" When you write a personal check to the company, the money goes into the company's checking account and also increases the Capital Contribution account in accordance with double-entry accounting practices. When the company has enough retained earnings to pay you back, you use the Capital Distributions equity account and just write yourself a check. You can also make general journal entries every year to zero out or balance your two capital accounts with Retained Earnings, which (I think) is an automatically generated Equity account in QuickBooks. If this sounds too complex, you could also just use a single ""Capital Contributions and Distributions"" equity account for your contributions and distributions." As stated above, the IRA accounts themselves are individual.  But if you want to simulate a joint account, the following actions would help: Make sure to setup each account with the other spouse as the beneficiary so that each account goes to any surviving spouse should the unexpected happen. Some brokers (I know TDA does this) allow you to grant access to your account to another login, so that effectively one spouse could make the invest decisions for all your accounts.  This is better than simply sharing your username and password, which is against many T&Cs.  If you do this in both directions, each spouse has access to all accounts. "I have a similar situation -- five different accounts between me and my wife. Just as you and @Alex B describe, I maintain my asset allocation across the combination of all accounts. I also maintain a spreadsheet to track the targets, deviations from the targets, amounts required to get back in balance, and overall performance. I (mostly) don't use mutual funds. I have selected, for each category, 1 or 2 ETFs. Choosing index ETFs with low expense ratios and a brokerage with cheap or free trades keeps expenses low. (My broker offers free ETF trades if you buy off their list as long as you aren't short-term trading; this is great for rebalancing for free 2 or 3 times a year.) Using ETFs also solves the minimum balance problem -- but watch out for commissions. If you pay $10 to buy $500 worth of an ETF, that's an immediate 2% loss; trade a couple of times a year and that ETF has to gain 5% just to break even. One issue that comes up is managing cash and avoiding transaction fees. Say your IRA has all the growth stock funds and your Roth has the bonds. Stocks do well and bonds do poorly, so you sell off some stocks, which creates a bunch of cash in your IRA. Now you want to buy some bonds but you don't have enough cash in your Roth, so you buy the bonds in your IRA. Not a problem at first but if you don't manage it you can end up with small amounts of various funds spread across all of your accounts. If you're not careful you can end up paying two commissions (in two different accounts) to sell off / purchase enough of a category to get back to your targets. Another problem I had is that only one account (401k) is receiving deposits on a regular basis, and that's all going into an S&P 500 index fund. This makes it so that my allocation is off by a fair amount every quarter or so -- too much in large cap equities, not enough of everything else. My solution to this going forward is to ""over-rebalance"" a couple of times a year: sell enough SPY from my other accounts so that I'm under-allocated in large caps by the amount I expect to add to my 401k over the next 3 months. (So that in six months at my next rebalancing I'm only 3 months over-allocated to large caps -- plus or minus whatever gains/losses there are.)" I'm not familiar with Gnucash, but I can discuss double-entry bookkeeping in general. I think the typical solution to something like this is to create an Asset account for what this other person owes you. This represents the money that he owes you. It's an Accounts Receivable. Method 1: Do you have/need separate accounts for each company that you are paying for this person? Do you need to record where the money is going? If not, then all you need is: When you pay a bill, you credit (subtract from) Checking and debit (add to) Friend Account. When he pays you, you credit (subtract from) Friend Account and debit (add to) Checking. That is, when you pay a bill for your friend you are turning one asset, cash, into a different kind of asset, receivable. When he pays you, you are doing the reverse. There's no need to create a new account each time you pay a bill. Just keep a rolling balance on this My Friend account. It's like a credit card: you don't get a new card each time you make a purchase, you just add to the balance. When you make a payment, you subtract from the balance. Method 2: If you need to record where the money is going, then you'd have to create accounts for each of the companies that you pay bills to. These would be Expense accounts.  Then you'd need to create two accounts for your friend: An Asset account for the money he owes you, and an Income account for the stream of money coming in. So when you pay a bill, you'd credit Checking, debit My Friend Owes Me, credit the company expense account, and debit the Money from My Friend income account.  When he repays you, you'd credit My Friend Owes Me and debit Checking. You don't change the income or expense accounts. Method 3: You could enter bills when they're received as a liability and then eliminate the liability when you pay them. This is probably more work than you want to go to. Proposed solutions 1 and 3 sound like extra work. Is a dual-file system something that you and your wife will be willing to maintain? Having separate files may better reflect your financial structure, but be sure that the expense of added time and overhead is worth it to you in the long run. You could track your own accounts, your wife's accounts, and your joint accounts in the same Money file (solution 2). Getting married can be a simple matter of adding the wife's accounts and recording transfers as money flows into joint accounts. This would make transfers between accounts easy to record and would afford easy reporting of overall income and spending. To maintain a degree of continuity for your own accounts, customize some reports to exclude your wife's accounts and joint accounts. A note about Microsoft Money I think Microsoft Money is fantastic and I have no plans to stop using it despite the fact that Microsoft killed the product line. All Money users should be made aware of the free Sunset version that requires no online activation. Also check out PocketSense, a collection of free Python scripts that can download transactions from some banks directly into Money. I use and highly recommend both.