How to split a transaction that is variable each month.

Question

So I have a utility bill. It is a different amount each month. Like an electric bill. I want to split the bill into 2 categories/tags, etc. One part would be fixed. The other variable. So for example, I get a water bill. I want to allocate $50 each month to the house category. And the other amount which will vary from $10-$80 a month, to another category called renter. Each month, the bill comes in from the biller. It is on the biller list. I have it connected to the biller account. I also have it linked to a reminder transaction. The reminder transaction seems to be fixed and I have to adjust it each month when the actual transaction downloads from the bank. If this is not doable, any suggestions on how to accomplish something equivalent? Basically, I have a utility bill to be split between 2 people; me and my renter. My renter pays a fixed portion, while I pay the rest, high or low.

Rich_M · Accepted Answer

If you're willing to unlink this biller, you will have other options to setup an estimated amount instead of fixed.

However, having to adjust the split every month to keep your records accurate is unavoidable.

Another thought I have is to enter the fixed portions paid by your renter in the income reminder for his payment in the split.  These amounts will then show up as offsets to your utility bill categories and might save you some effort.