I do something similar; I have one spreadsheet for Electricity, and another one far water.
Welcome to the crazy club! (heh) On Sun, Mar 12, 2023 at 10:21 AM Gyle McCollam <gmccol...@live.com> wrote: > As to #3, I track my utilities with a spreadsheet in Libre Office. What > are you trying to track, kwh usage or cost per kwh? In my spreadsheet I > track both, plus differences with last year. In Gnucash you could put this > info in the "notes" field, but reporting on tis info I'm not sure about. > Another way that won't screw up your financial reporting is to set up > subaccounts under electric. One account for say kwh and a contra account > for the -kwh. You could record the kwh used in the first and the opposite > value in the contra so they net to zero and don't affect financial > reporting. That way you could get a report on just the positive account > for usage. I myself would use the spreadsheet approach. > > > Thank You, > > Gyle McCollam > > Gyle McCollam > > gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email > > ________________________________ > From: gnucash-user <gnucash-user-bounces+gylemc=gmail....@gnucash.org> on > behalf of Charles Crossan <crossan...@gmail.com> > Sent: Sunday, March 12, 2023 10:51 AM > To: gnucash-user@gnucash.org <gnucash-user@gnucash.org> > Subject: [GNC] User defined currencies in "Expense Accounts" > > While doing my monthly ritual of breaking down my utility bill into > GNUcash, I had the idea of using a user defined currency for electricity > (Kilowatt Hours - kWh) and Water (gallons). I'd like to be able to chart > my "real usage" as well as rate fluctuations. > > I've been using GNUCash for over 10 years, and have created a bunch of > custom currencies for stocks / etc; however, this is the first time I > thought about using it for tracking utility units. > > I got as far as creating the kWh currency when I realized that there's no > way to choose a "non ISO 4217" currency for expense accounts. > > The GNUCash documentation seems to indicate that Income and Expense > accounts are only able to use "National Currencies" (12.2.1.1. User-Defined > Currencies - > https://www.gnucash.org/docs/v4/C/gnucash-guide/currency_manual.html > <https://www.gnucash.org/docs/v4/C/gnucash-guide/currency_manual.html>). > > I'm wondering: > > 1. Is there a functional reason for this requirement; or is it an > arbitrary UI restriction? > 2. Would the application behave erratically if I were to manually edit > the expense account in SQL to use my own currency? > 3. How is everyone else handling utility tracking? I realize I'm > probably a tad crazy for wanting this level of detail. > > -- > Thanks, > _______________________________________________ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > ----- > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > _______________________________________________ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > ----- > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- _________________________________ Richard Losey rlo...@gmail.com Micah 6:8 _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
