Can anyone give guidance on where I can find handy instructions on how to do investment fund accounting?
Thanks!
Can anyone give guidance on where I can find handy instructions on how to do investment fund accounting?
Jeff-Ohio wrote:Can anyone give guidance on where I can find handy instructions on how to do investment fund accounting?
I’m not sure what you mean by that, but when it comes to an investment account, I think about the following:
1. When a dividend is collected, I’d debit Cash and credit Dividend Income. After year-end, and when the 1099 arrives, I’d reclass that Income into more specific buckets (like Qualifying Dividends, for example).
2. When interest is collected, I’d debit Cash and credit Interest Income. If it’s muni income, I’d credit T/E Muni Income. And you’d probably have 2 accounts here, one for in state and one for out of state.
3. If OID is involved, I’d debit Basis and credit OID Income.
4. If a check is written for something like investment fees, I’d debit that and credit Cash.
5. If an investment is purchased, I’d debit Basis and credit cash.
6. If something is sold, I’d debit Cash, credit Basis and then debit or credit Loss or Gain. Then when the 1099 arrives, I’d tie it all back to the 1099B’s.
7. If mutual fund dividends get automatically reinvested, I’d debit Basis and credit Dividend Income.
8. If we have something like muni premium we need to amortize down, I’d debit Premium and credit Basis.
At this point, a lot of ideas have been presented. Your job is to assemble the above into a single monthly journal entry, which is what we do here at our firm (in Excel). I’m guessing you’ll be stating Investments at cost (i.e. tax basis). You’d tie-back your overall month-end basis number, as per your Balance Sheet, to the monthly statements, which should list each investment at cost and then a sum total. And you might have different buckets here (i.e. stocks, mutual funds, bonds, cash, etc.). Adding debt into the mix, like a margin account, shouldn’t be too difficult. Ditto for the receipt of K1’s.
sjrcpa wrote:An Accounting 101, 102 or higher textbook? All I seem to remember from college is that there is such a thing as Fund Accounting. And it is Fund Balance instead of Retained Earnings or Capital.
cp_acwt wrote:https://www.accountingtools.com/accounting-for-investment
Take a look at the link above. It may be a good place to start. You could also look at the course descriptions at colleges that teach accounting, find the course that includes what you are looking for, and what book is used in the course.
Users browsing this forum: No registered users and 28 guests