Setting up general ledger/tax reporting for a Real Estate Rental LLC in GnuCash
No, GnuCash doesn't specifically provide a partner cash basis report/function. However, GnuCash reports are fairly easy to write. If the data was readily available in your accounts it shouldn't be too hard to create a cash basis report. The account setup is so flexible, you might actually be able to create accounts for each partner, and, using standard dual-entry accounting, always debit and credit these accounts so the actual cash basis of each partner is shown and updated with every transaction. I used GnuCash for many years to manage my personal finances and those of my business (sole proprietorship). It really shines for data integrity (I never lost data), customer management (decent UI for managing multiple clients and business partners) and customer invoice generation (they look pretty). I found the user interface ugly and cumbersome. GnuCash doesn't integrate cleanly with banks in the US. It's possible to import data, but the process is very clunky and error-prone. Apparently you can make bank transactions right from GnuCash if you live in Europe. Another very important limitation of GnuCash to be aware of: only one user at a time. Period. If this is important to you, don't use GnuCash. To really use GnuCash effectively, you probably have to be an actual accountant. I studied dual-entry accounting a bit while using GnuCash. Dual-entry accounting in GnuCash is a pain in the butt. Accurately recording certain types of transactions (like stock buys/sells) requires fiddling with complicated split transactions. I agree with Mariette: hire a pro. "You will need to set up accounts in your chart of accounts for each of the partners. These are equity accounts where you can track your contributions, share of the profits and losses, and distributions. You're going to have to go back into the beginning years to get this right. I'm not sure what you mean by a ""Built-in function"". All the accounting software I'm familiar with requires data entry of some kind. You need to post your contributions and distributions to the correct accounts, and close properly at year end. You were indeed legally considered a partnership as soon as you started a for-profit business venture together. It's a bug in the legal system that a written partnership agreement is not necessarily required - you can form a partnership unknowingly. (BTW, a partnership actually is pretty far off from a sole proprietorship, legally and taxwise - the change from one person to two is major. It's the change from two to three or four or more that's incremental ;) I know you said you didn't want to consult a professional, but I have to say that I think it's worth the money to get your books set up by someone who has experience and can show you how to do it. And get a separate bank account for the partnership, if you haven't done so already. And check with your state to see if there are any requirements regarding partnerships. Hope this helps, Mariette IRS Circular 230 Notice: Please note that any tax advice contained in this communication is not intended to be used, and cannot be used, by anyone to avoid penalties that may be imposed under federal tax law."
Because a paying down a liability and thus gaining asset equity is not technically an expense, GnuCash will not include it in any expense reports. However, you can abuse the system a bit to do what you want.  The mortgage payment should be divided into principle, interest, and escrow / tax / insurance accounts. For example: A mortgage payment will then be a split transaction that puts money into these accounts from your bank account: For completeness, the escrow account will periodically be used to pay actual expenses, which just moves the expense from escrow into insurance or tax. This is nice so that expenses for a month aren't inflated due to a tax payment being made: Now, this is all fairly typical and results in all but the principle part of the mortgage payment being included in expense reports. The trick then is to duplicate the principle portion in a way that it makes its way into your expenses. One way to do this is to create a principle expense account and also a fictional equity account that provides the funds to pay it: Every time you record a mortgage payment, add a transfer from this equity account into the Principle Payments expense account. This will mess things up at some level, since you're inventing an expense that does not truly exist, but if you're using GnuCash more to monitor monthly cash flow, it causes the Income/Expense report to finally make sense. Example transaction split: "I compared investing in real estate a few years ago to investing in stocks that paid double digit dividends (hard to find, however, managing and maintaining real estate is just as hard).  After discussing with many in the real estate world, I counted the average and learned that most averaged about 6 - 8% on real estate after taxes.  This does not include anything else like Dilip mentions (maintenance, insurance, etc).  For those who want to avoid that route, you can buy some companies that invest in real estate or REIT funds like Dilip mentions.  However, they are also susceptible to the problems mentioned above this. In terms of other investment opportunities like stocks or funds, think about businesses that will always be around and will always be needed.  We won't outgrow our need for real estate, but we won't outgrow our need for food or tangible goods either.  You can diversify into these companies along with real estate or buy a general mutual fund. Finally, one of your best investments is your career field - software.  Do some extra work on the side and see if you can get an adviser position at a start-up (it's actually not that hard and it will help you build your skill set) or create a site which generates passive revenue (again, not that hard).  One software engineer told me a few years ago that the stock market is a relic of the past and the new passive income would be generated by businesses that had tools which did all the work through automation (think of a smart phone application that you build once, yet continues to generate revenue).  This was right before the crash, and after it, everyone talked about another ""lost decade.""  While it does require extra work initially, like all things software related, you'll be discovering tools in programming that you can use again and again in other applications - meaning your first one may be the most difficult. All it takes in this case is one really good idea ..." Your post seems to read as if you want to invest only in real estate rental properties as a start because they will be a reliable investment guaranteed to generate profits that you will be plowing back into buying even more rental properties, but you are willing to consider (possibly in later years) other forms of investment (in real estate) that will not require active  participation in the management of the rental properties. While many participants here do own rental real estate and even manage it entirely, for most people, that is only a small part of their investment portfolio, and I suspect that hardly any will recommend real estate as the only investment the way you seem to want to do. Also, you might want to look more closely at the realities of rental real estate  operations before jumping in. Things are not necessarily as rosy as they appear to you now.  Not all your units will be rented all the time, and the rental income might not always be enough to cover the mortgage payments and the property taxes and the insurance payments and the repairs and maintenance and ... Depreciation of the property is another matter that you might not have thought about. That being said, you can invest in real estate through real estate investment trusts (REITs) or through limited partnerships where you have only a passive role.  There are even mutual funds that invest in REITs or in REIT indexes. You apparently assume that pouring money into a landlord's pocket is a bad thing. Not necessarily. Whether it makes sense to purchase your own home or to live in a rental property varies based on the market prices and rents of properties. In the long term, real estate prices closely follow inflation. However, in some areas it may be possible that real estate prices have increased by more than inflation in the past, say, 10 years. This may mean that some (stupid) people assume that real estate prices continue to appreciate at this rate in the future. The price of real estates when compared to rents may become unrealistically high so that the rental yield becomes low, and the only reasonable way of obtaining money from real estate investments is price appreciation continuing. No, it will not continue forever. Furthermore, an individual real estate is a very poorly diversified investment. And a very risky investment, too: a mold problem can destroy the entire value of your investment, if you invest in only one property. Real estates are commonly said to be less risky than stocks, but this applies only to large real estate portfolios when compared with large stock portfolios. It is easier to build a large stock portfolio with a small amount of money to invest when compared to building a large real estate portfolio. Thus, I would consider this: how much return are you going to get (by not needing to pay rent, but needing to pay some minor maintenance costs) when purchasing your own home? How much does the home cost? What is the annual return on the investment? Is it larger than smaller when compared to investing the same amount of money in the stock market? As I said, an individual house is a more risky investment than a well-diversified stock portfolio. Thus, if a well-diversified stock portfolio yields 8% annually, I would demand 10% return from an individual house before considering to move my money from stocks to a house. You could classify the mortgage as a different assets class and then create automated additions and deductions to the account as deems fit. other than that quickbooks online is a bit fishy so it seems. "Gnucash is first and foremost just a general ledger system. It tracks money in accounts, and lets you make transactions to transfer money between the accounts, but it has no inherent concept of things like taxes. This gives you a large amount of flexibility to organize your account hierarchy the way you want, but also means that it sometimes can take a while to figure out what account hierarchy you want. The idea is that you keep track of where you get money from (the Income accounts), what you have as a result (the Asset accounts), and then track what you spent the money on (the Expense accounts). It sounds like you primarily think of expenses as each being for a particular property, so I think you want to use that as the basis of your hierarchy. You probably want something like this (obviously I'm making up the specifics): Now, when running transaction reports or income/expense reports, you can filter to the accounts (and subaccounts) of each property to get a report specific to that property. You mention that you also sometimes want to run a report on ""all gas expenses, regardless of property"", and that's a bit more annoying to do. You can run the report, and when selecting accounts you have to select all the Gas accounts individually. It sounds like you're really looking for a way to have each transaction classified in some kind of two-axis system, but the way a general ledger works is that it's just a tree, so you need to pick just one ""primary"" axis to organize your accounts by." If you were a business, all your assets would have a dollar value, so when you sold them you'd decrease the amount of assets by that amount and increase in cash, and if there was a profit on the sale it would go in as income, if there was loss it would count as a cost (or a loss)... so if there was a profit it would increase Equity, a loss then it would decrease Equity.  Since it's not really worthwhile doing a estimated cost for everything that you have, I'd just report it as income like you are doing and let the amount of equity increase proportionately. So, implicitly you always had roughly that amount of equity, but some of it was in the form of assets, and now you're liquidating those assets so the amount shows up in GnuCash. When you buy new things you might sell later, you could consider adding them as assets to keep track of this explicitly (but even then you have problems-- the price of things changes with time and you might not want to keep up with those price changes, it's a lot of extra work for a family budget) -- for stuff you already have it's better to treat things as you are doing and just treat the money as income-- it's easier and doesn't really change anything-- you always had that in equity, some of it was just off the books and now you are bringing it into the books. "I found an answer by Peter Selinger, in two articles, Tutorial on multiple currency accounting (June 2005, Jan 2011) and the accompanying Multiple currency accounting in GnuCash (June 2005, Feb 2007). Selinger embraces the currency neutrality I'm after. His method uses ""[a]n account that is denominated as a difference of multiple currencies... known as a currency trading account."" Currency trading accounts show the gain or loss based on exchange rates at any moment.  Apparently GnuCash 2.3.9 added support for multi-currency accounting. I haven't tried this myself. This feature is not enabled by default, and must be turned on explicity. To do so, check ""Use Trading Accounts"" under File -> Properties -> Accounts. This must be done on a per-file basis. Thanks to Mike Alexander, who implemented this feature in 2007, and worked for over 3 years to convince the GnuCash developers to include it. Older versions of GnuCash, such as 1.8.11, apparently had a feature called ""Currency Trading Accounts"", but they behaved differently than Selinger's method."