How to account for a shared mortgage in QuickBooks Online?
How you should record the mortgage payments depends on if you are trying to achieve correct accounting, according to the standards, or if you are just tracking everything for you and your friends. If you're just keeping track for personal reasons, I'd suggest that you set up your check (or journal entry, your preference) how you'd like it to be recorded.  Then, memorize that transaction.  This allows you to use it as many times as you need to, without having to set it up each time.  (Also note: there is no way to record a transaction that decreases cash and increases equity.) If you're trying to keep track of everything according to accounting standards, which it should be if you've set up an official business, then you have a lot more tracking to do with each payment.  Mortgage payments technically do not affect the equity accounts of the owners.  Each mortgage payment should decrease the bank balance, increase interest expense and decrease the mortgage balance, not to mention tracking any escrow account you may have.  The equity accounts would be affected if the owners are contributing funds to the bank account, but equity would increase at the time the funds are deposited, not when the mortgage payments are made. Hope this helps! 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. What is the corporate structure? Your partnership agreement or LLC operating agreement should dictate how you approach this.
"You are right on track with your idea of setting up a separate account for invoiced income. Create a new account with the type other asset and call it ""Receivables"" (or something similar). Every time you invoice a client, enter a credit to this account with the amount of the invoice. Once the client pays and you deposit a check, enter a transfer from the ""Receivables"" account to the bank account. EDIT I overlooked that you wish to account for not-yet-invoiced income. I think that's a bad idea. It will become confusing and will give you the false sense that your financial condition is better than it really is. There are plenty of stories about businesses that have stellar sales, but fail because of lack of cash flow (the business' bills become due before it gets paid by its own customers)." My wife and I set up a shared bank account. We knew the monthly costs of the mortgage and estimated the cost of utilities. Each month, we transferred enough to cover these, plus about 20% so we could make an extra mortgage payment each year and build up an emergency fund, and did so using automatic transactions. Other shared expenses such as groceries, we handled on an ad-hoc basis, settling up every month or three. We initially just split everything 50-50 because we both earned roughly the same income. When that changed, we ended up going with a 60-40 split. We maintained our separate bank accounts, though this may have changed in the future. A system like this may work for you, or may at least provide a starting point for a discussion. And I do strongly advise having a frank and open discussion on these points. Dealing with money can be tricky in the bounds of a marriage. "Should is a very ""strong"" word. You do what makes most sense to you. Should I be making a single account for Person and crediting / debiting that account? You can do that. Should I be creating a loan for Person? And if so, would I make a new   loan each month or would I keep all of the loans in one account? You can create a loan account (your asset), you don't need to create a new account every time - just change the balance of the existing one. That's essentially the implementation of the first way (""making a single account for a Person""). How do I show the money moving from my checking account to Company and   then to Person's loan? You make the payment to Company from your Checking, and you adjust the loan amount to Person from Equity for the same amount. When the Person pays - you clear the loan balance and adjust the Checking balance accordingly. This keeps your balance intact for the whole time (i.e.: your total balance sheet doesn't change, money moves from line to line internally but the totals remain the same). This is the proper trail you're looking for. How do I (or should I even) show the money being reimbursed from the   expense? You shouldn't. Company is your expense. Payment by the Person is your income. They net out to zero (unless you charge interest). Do I debit the expense at any point? Of course. Company is your expense account. Should I not concern myself with the source of a loan / repayment and   instead just increase the size of the loan? Yes. See above." "There are different approaches, but here is what we do and what I recommend.  Now that you are officially a married couple, open a joint bank account, and eliminate your individual accounts.  There are several reasons for this. Having a joint account promotes unity and teamwork.  When you only have a joint account, you do not have ""your income"" and ""her income,"" or ""your expenses"" and ""her expenses.""  You work together in everything.  You discuss your goals and set your household budget together.  If one of you makes more money than the other, that person is no longer ""worth more,"" because your incomes are pooled together.  If one person with a higher income has more in their account than the other person does, it can lead to envy, which you do not want in your marriage. Having a joint account is more efficient and makes more sense.  With separate accounts, who pays the rent/mortgage?  Who pays the utilities, or buys the food?  If you have separate accounts, it takes a lot of work to worry about what is ""fair"" when deciding how to divide up the expenses.  With a single household budget and a joint account, you decide together what the household expenses are, and they get paid from one account.  If one of you has debt, you both have debt.  You work together to get it paid off and strengthen your financial situation in the process. Having a joint account forces you to discuss your finances together.  Working toward common financial goals together is crucial in a strong marriage, but if you maintain your separate accounts, you might be tempted to put off these discussions until you are forced to by life circumstances.  It is better to work together from the start, and joining your finances facilitates that. You are intending your marriage to last.  Live your financial life like you believe that you are a team for life.  If you live in a community property state, separate accounts are a fiction anyway; everything is treated as if it was pooled together in the event of a divorce. I understand that if you are used to having your own money, it can be difficult to give up that sole control over your income, but in my opinion, it is worth it.  You will certainly hear of examples from couples who maintain separate accounts and make it work.  In my humble opinion, combining your finances completely is easier to do right." "I added ""Shared money in account"" (SMIA) as sub-account of my bank checking (CA) account and moved current difference to that account so total of CA was not changed but now private and shared money is separated. My cases would be handled the following The only downside I see is that now my balance in CA transaction log do not match exactly with bank so reconciliation will be slightly harder." "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." I did that.  What is allowed changes over time, though — leading up to the crisis, lenders would approve at the flimsiest evidence. In particular, my SO had only been in the country a couple years and was at a sweet spot where lack of history was no longer counting against her. Running the numbers, the mortgage was a fraction of a percent cheaper in her name than in mine.  Even though she used a “stated income” (self reported, not backed by job history) of the household, not just herself. The title was in her name, and would have cost money to have mine added later so we didn’t.  This was in Texas, which is a “community property” state so after marriage for sure everything is “ours”. Your account entries are generally correct, but do note that the last transaction is a mixture of the balance sheet and income statement.  If Quickbooks doesn't do this automatically then the expense must be manually removed from the balance sheet. The expense should be recognized on the balance sheet and income statement when it accrues, and it accrues when the prepaid rent is extinguished when consumed by the landlord, so that is when the second entry in your question should be booked. The cash flow statement will reflect all of these cash transactions immediately. I know of websites that do this, but I don't know of banks that do. Is there any reason you want to do this at a bank rather than use a service?  My main concern with using a bank for this would be the risk of overdraft fees I can't quite follow your question, so I'm proceeding under the following assumptions: - You paid £31,000 - Your partner paid £4,242 - You have at least one mortgage, which you both pay equally. If the relationship terminates, sell the property. You are reimbursed £31,000 and your partner is reimbursed £4,242. Any remaining proceeds from the sale are split 50-50. If the result is a net loss (i.e. you are underwater on your mortgage), you split the debt 50-50. If you are not both paying the same toward the mortgage, I'd split the profit or loss according to how much you each pay toward the mortgage. Of course, this is not the only possible way you can split things up. You can use pretty much any way you both think is fair. For example, maybe you should get more benefits from a profit because you contributed more up-front. The key thing, though, is that you must both agree in writing, in advance. This is reasonable; this is what I did, for example. Note that if the relationship ends, one or the other of you may wish to keep the property. I'd suggest including a clause in your written agreement simply disallowing this; specify criteria to force a sale. But I know lots of people are happy to allow this. They treat that situation as a forced sale from both people to one person. For example, if your partner chooses to stay in the house, he or she must buy the property from you at prevailing market rates. "We use mint for just that. We have a ""shared"" account. We each have the mobile app and share the same pin for the application (not our phones -- you can set a pin in the settings on the application). Thus we each share a login to the site, where we have setup all of our accounts. In the ""Your Profile"" link at the top of the page, you may select the Email & Alerts option. From here you may add a second e-mail account. This way if you go over a budget or have a bill upcoming each of you will get a notification. We have setup budgeting through the web site, and either of us can modify the budget via logging in." I use QuickBooks online... It's really the best out there for the price, just make sure to never upgrade to an edition you aren't 100% sure you need or you're forever stuck essentially. That's the mess I'm in right now. Paying $20 more than necessary a month, but it's still cheaper than switching to, say, xero. The starter edition of QuickBooks online is a lot more powerful than the equivalent plans anywhere else for the price. Is it normal in QuickBooks to have credit card expenses being shows as   liabilities? Is there a way I can correct this? If they are expenses they shouldn't be negative liabilities unless you overpaid your credit card by that amount. It sounds like perhaps when you linked the account the credit/debit mapping may have been mixed up. I've not used QB Online, but it looks like you might have to un-link the account, move all the existing transactions to 'excluded' and then link the account again and flip-flop the debit/credit mapping from what it is now. Hopefully there's an easier way. This QB community thread seems to address the same issue. That's right.  I wouldn't say that she directly caused Yahoo's downfall since that was put into motion long before she started.  However, she did nothing that succeeded in changing Yahoo's trajectory after she took over.  Yahoo could have done essentially nothing and it would have ended roughly the same.  People are just upset that she got compensated quite well without achieving anything of significance. Generally if there are enough details, they would match this up with your loan account and pass appropriate credit. The worst that can happen is;   In either case, watch your Loan account statement and it should show you the credit. If this does not then ask the company and they should be able to trace it and rectify. Under no scenario you would lose money.