Mortgage Payment Table
Scenario: one mortgage paid with two checks from two accounts - one account
tracked by Money (mine) and one not (gf's). I would like to track my
mortgage payments and include my gf's contribution (easily done on a credit
account). How can I set up this scenario so each of the two payments are
automatically divided into P & I and entered as one or two monthly bills? I
hope this explanation is clear.
I used to track half of the mortgage (and home value), but need to track the
total due to differences in our contributions.
I think the easiest way is to just brute force the situation in Money and
track the shares of P and I (hence equity splits) in Excel. I.e., track the
whole loan and make the loan payments with some income split entry to make
the GFs contribution so that the total of the transaction in your cash
account is your portion in Money. Create a simple amortization table in
Excel with pairs of columns for the shares of the payment and the
application of those shares to P+I.
Now for the relationship counseling: most every GF I ever had viewed this
kind of accountancy as somehow an anti-romantic slam aimed solely at
protecting you against the day you decide to dump her.