I co-own a house with two unrelated friends. We have a single mortgage that we're each responsible for our fraction of. We've been keeping track of our payments in a spreadsheet but for a variety of reasons we'd like to switch to real accounting software. I'm trying to use QuickBooks Online and model the house as the company, of which we are all owning partners, each with our own equity accounts.
My question is how I should record mortgage payments. I want to record the payments so that they credit (decrease) the balance of our shared bank account, and debit (decrease) each of our equity accounts in a fixed proportion. I can do this with a journal entry with multiple debit lines, but that appears to require me to figure out the exact dollar amounts for every debit line for each account -- so I have to multiply the payment by each of our fractions every time. I'd like the debit lines to be automatically calculated based on the fraction of the house that each of us owns and therefore pays in mortgage. Or somehow get that effect. Could I fake this with a "product"? Or can I get this effect by reconciling accounts later or something?
Is there a better way to be doing this? Maybe with a package other than QBO? Any pointers appreciated.