[GNC] Tracking UnPaid Bills
griffin
griffin at bernevyl.com
Tue Mar 18 13:12:38 EDT 2025
Sorry, but I'm still having an issue with this process.
Setting the bill value as a transfer from the expense account to the
liability account is working fine, as is paying off the liability from
the chequing account.
However, dealing with a refund is still causing a problem.
1.) If I make a deposit into the chequing account from the liability
account, Gnucash makes the balance of the liability account go up, not
down towards zero. Making the value a negative number, only results in
the value moving to the other column (see the second point).
2.) If I make the transfer from the liability account in the decrease
column, setting the balance to zero, the transaction appears in the
chequing account as a withdrawal.
This is all controlled by GnuCash. Am I doing something, or is GnuCash
doing something of which I'm not aware.
On 2025-03-17 12:01 p.m., griffin wrote:
> I have been trying this, and I've hit a small issue.
>
> I made an over payment to my phone bill, and then moved to another
> carrier, so I was over paid in the liability account.
>
> When I tried to "refund" this overpayment to my chequing account
> GnuCash either doubles the liability, or withdraws the refund from the
> chequing account.
>
> (...and yes, I feed my dog Dog Foof!!!😳)
>
> I don't seem to be able to reduce the liability to zero, and increase
> the chequing account balance.
>
> What have I done wrong?
>
>
>
>
>
> On 2025-03-17 10:56 a.m., R Losey wrote:
>> On Sun, Mar 16, 2025 at 11:56 AM Michael or Penny Novack via
>> gnucash-user <
>> gnucash-user at gnucash.org> wrote:
>>
>>> On 3/16/2025 12:13 AM, R Losey wrote:
>>>> Hi. I'd just set such accounts up as sub-accounts under Liabilities.
>>> Using
>>>> your example (electricity)
>>>>
>>>> 1) Create an "Electricity" account under "Liabilites"
>>>> (alternatively, you
>>>> could use the provider as the name of the account
>>>> 2) Using your $120 bill as an example, when you pay $60 and owe
>>>> them $60,
>>>> you'd create a three-way split
>>>> Checking: decrease (credit) $60
>>>> Expenses->Utilities->Electricity: increase (debit) $120
>>>> Liabilities->Electricity: increase (credit) $60
>>> You COULD do it that way. Splits when paying the bill.
>>>
>>> But I suggested entering the expense/liability when the bill arrives
>>> with an effective date the due date of the bill. Then when you pay all
>>> or part of the bill, the transaction just liability/bank account. No
>>> split transactions involved. (well MAYBE no splits -- besides being
>>> billed for electricity might also have late fees and/or interest
>>> charges. You MIGHT just bundle those into electricity expense but also
>>> might instead might want to see how much you are being hit with late
>>> fees and interest on all your bills).
>>>
>>> Michael D Novack
>>>
>>> Your suggestion is even better and simpler (no splits); I was trying to
>> think of how to do it the way you suggest, but somehow confused
>> myself and
>> couldn't figure out what the two transactions would look like. (I don't
>> know what I was thinking; it's perfectly obvious today).
>>
>>
--
If you need end-to-end encryption, I have a PGP Key
--
This email has been checked for viruses by Avast antivirus software.
www.avast.com
More information about the gnucash-user
mailing list