Re: [GNC] Schedule transaction for 2 Wednesday?

[Adrien Monteleone]

Yes, I see the arrow, but the list on the screen runs only through 
"30th" and unless you need "31st" you wouldn't scroll to see the other 
options. As the initial visible part of the list only contains the days 
of the month, there's no reason to expect that the down arrow will show 
anything other than "31st". (oddly, there are multiple blank lines at 
the beginning of the list, if they were removed, then other options 
would be visible right away)


Regards,
Adrien

On 3/11/23 10:45 AM, R Losey wrote:

At least on my iMac, there is a down arrow at the bottom of the list that
makes it pretty clear that there are options below.

On Fri, Mar 10, 2023 at 7:27 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:


I wouldn't pull the RFE though, but instead re-word it to improve the UX
for better discoverability. If at first you see a partial list of nth
days of a month, it isn't intuitive to keep scrolling to see the other
options. One would only discover them by accident. (or I suppose,
reading a current version of the manual, again, by chance for long time
users)


___
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.

Re: [GNC] GnuCash flatpak "invisible" update?

[Tommy Trussell]

On Sun, Mar 12, 2023 at 10:08 AM john  wrote:

>
> On Mar 11, 2023, at 1:15 PM, Tommy Trussell 
> wrote:
>
> On Sat, Mar 11, 2023 at 2:21 PM John Ralls  wrote:
>
>>
>> > On Mar 11, 2023, at 11:14 AM, Tommy Trussell 
>> wrote:
>> ...
>
> > I was surprised the flatpak "stable" repository was showing an update to
>> > GnuCash 4.13. I was even more surprised it was showing the update would
>> be
>> > to a commit from December. ...
>>
>> [SNIP]
>>
>> >  Commit:
>> > eb1be08966b94073a6f219dcf8f61f42c88228d1d1f2aba15da990591bccf3c7
>> >  Parent:
>> > 7e2d8364088a32d0f6849893a43b41a5623886c2d5c7da3505c023ba0c86fa5f
>> > Subject: Fix GnuCash tarball sha256 (bd9f8e1e)
>
> >Date: 2022-12-18 22:30:44 +
>>
>> The commits are weird. The one in parentheses is the current HEAD on
>> https://github.com/flathub/org.gnucash.GnuCash/commits/master and as
>> will be apparent if you visit that page the commit was needed because the
>> first build failed.
>>
>> Does the subject for the parent commit say "Package GnuCash 4.13
>> (c825100b)"? That's the build that failed so it's seems odd to me that it
>> would have made an installable flatpak.
>>
>
> I don't know how to look for the information you requested. All I know how
> to discern is through the flatpak info command, and it shows exactly what
> you've quoted.
>
> I searched github for the last eight characters of the strings and have
> not found anything relevant EXCEPT the parent commit you mentioned.
>
> HOWEVER I just noticed in
>
> https://github.com/Gnucash/gnucash-on-flatpak
>
> there's an update to modules/aqbanking.json from last week. It could
> easily be that I have not checked flatpak updates since you made that
> change. Could that one file explain it?  I don't use AQBanking so I don't
> even know where I'd look in my installation unless I dug into the
> installed flatpak.
>
> I just chose Help --> About
>
> Version: 4.13
> Build ID: Flathub 4.13
> Finance::Quote: 1.5301
>
>
>
>
> No, it's not the AQBanking change. Changes on gnucash-on-flatpak don't get
> reflected in org.gnucash.GnuCash until I copy them over as part of doing a
> release, so that change is in the beta branch for the 4.90x releases but
> not yet in master for 4.x.
>
> bd9f8e1e is the 18 December commit for the 4.13 flathub release in
> org.gnucash.GnuCash. That part isn't mysterious, what's mysterious is what
> did you have before and why did flatpak not update you to that release
> until almost 3 months later?
>

Today I'm back on another machine and it has the same situation. Flatpak is
showing an update available. The machine is running the org.flathub.Stable
commit ending in 0c86fa5f just as the other machine was.

I just opened Gnucash, and opened Help-->About

Version: 4.13
Build ID: Flathub 4.13
Finance::Quote: 1.5301

SO The answer is yes I have been running version 4.13 since soon after it
came out in late 2022, but there's some sort of update to it as of
recently. Flatpak shows BOTH versions dated back in December, with a
different commit.

I'm assuming the new package will be the same commit I installed on the
other computer a few days ago with the commit ending in 1bccf3c7, but I
haven't installed it yet.
___
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.

Re: [GNC] gnu-fq-check missing

[John Ralls]

Urk, looks like a problem with converting a string to wchar_t for Windows, we 
didn't set up codecvt in gnc-quotes.cpp. I can reproduce it here, trying a 
quick fix.

Regards,
John Ralls

> On Mar 13, 2023, at 2:12 PM, rolf.hoef...@gmail.com wrote:
> 
> wow.. never expected such a quick and personalized answer.. Thx!
>   I'm using now the unstable release 4.902. 
> I followed your instructions, but after trying gnucash-cli -Q info, I get the 
> following error:
> "Failed to initialize Finance::Quote: boost::process codecvt to wchar_t: 
> error"
> Within Gnucash app, still not able to use it..
> Thanks again, John!
> BR,
>  Rolf
> 
> On Mon, Mar 13, 2023 at 12:15 PM john  wrote:
> 
> 
> > On Mar 12, 2023, at 5:37 PM, rolf.hoef...@gmail.com wrote:
> > 
> > Hi, I've been trying hard to be able to run "Install Online Price
> > Retrieval", and I almost made it.. but I got this.. and it's right..
> > there's no gnu-fq-check program in bin.. how can I get it? I think I'm
> > almost there..
> 
> That depends on the version of GnuCash. If it's a 4.90x beta gnc-fq-check, 
> gnc-fq-helper, and gnc-fq-dump have been replaced with finance-quote-wrapper 
> and their function is now in gnucash-cli. We neglected to modify the Install 
> Online Price Retrieval tool to reflect that. The two calls to gnc-fq-check 
> and gnc-fq-helper in install-fq-mods.cmd are final checks to make sure 
> everything succeeded, so you probably are done. You can run c:\Program Files 
> (x86)\gnucash\bin\gnucash-cli -Q info and …\gnucash-cli -Q dump alphavantage 
> AMZN to test it.
> 
> OTOH if you're using a production release of GnuCash then gnc-fq-check should 
> be in C:\Program Files (x86)\gnucash\bin and since install-fq-mods.cmd is in 
> that directory too it should have found it.
> 
> Regards,
> John Ralls
> 
> 

___
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.

Re: [GNC] Can a bank account have sub-accounts?

[Vincent Dawans]

This sort of fund accounting is typically taken care of by using the
analytical dimension feature offered by some accounting softwares.
Unfortunately gnuCash doesn't have that feature (yet).
Here is an article somewhat explaining how it works (for a different
accounting package):
https://www.bakertilly.com/insights/tame-your-wild-not-for-profit-chart-of-accounts-with-dimensions

There is a workaround in gnuCash I have used before in some cases but it
only works as long as all entries in a split come or go to the same
dimension.

Here I am just pasting from an old comment I wrote in the gnucash
enhancement request for this feature
https://bugs.gnucash.org/show_bug.cgi?id=113772

The current work-around I am using is to create my dimensions as a
bunch of accounts under a new high-level structure (Dimensions for
instance). Then I create a sub-account for each type of dimension
Departments, Projects, Events, etc). Finally under each sub-account I
create sub-accounts for each actual dimension. These accounts will
never have any money in them so they will not interfere with the real
GL accounts.  Instead, I simply use them to add additional splits
pointing to the dimension accounts (with no amount) to any GL
transaction I want to tag.

For instance: I want to tag a $1000 rent expense to the 'Marketing'
department dimension and 'ABC Street Fair' event dimension; I create
the following split.

Account  Debit   Credit
Assets:Current Assets:Checking Account   $1000
Expenses:Rent$1000
Dimension:Events:ABC Street Fair
Dimension:Department:Marketing

Then I can actually use the "Transaction Report" to see all
transaction related to Dimension:Events:ABC Street Fair for instance.

- Go in Reports-Transaction Report, then in the Report Options, go to
the accounts tab.
- Select all Report Accounts EXCEPT the dimension accounts and sub-accounts.
- In the Filter accounts, select the dimension you want to report on
(e.g. Dimension:Events:ABC Street Fair).
- In the filter type, select "Include Transactions to/from Filter accounts").
- Change Display, General and sorting options as needed.
- Now you have a transaction report for all transactions attached to
the ABC Street Fair dimension.


On Mon, Mar 13, 2023 at 1:09 PM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

> On 3/13/2023 10:35 AM, Mort Q wrote:
> > Hi Robert
> > I do have lots of expense accounts for repairs, catering, office
> expenses,
> > utilities, etc, and income accounts for fund raising, donations,
> > memberships, etc. so we can track income and expenses easily.  The
> GnuCash
> > reports really help people see where money is coming from and going to.
> > That's one of the reasons I was thinking of having the sub accounts - the
> > bank reports will be like an overall report but with the underlying break
> > down of fund allocation.  Does that make sense?
> >
> As noted, this will cost you the ability to use the "reconcile" feature.
>
> But folks, I've been there and done that as treasurer of orgs. This is a
> trade off that might make sense. Keep in mind that such orgs might have
> a rather low monthly volume of transactions against the checking
> account. Reconciling the old fashioned way no big deal. When there were
> FORMALLY restricted funds would do that the right way, but for
> informally restricted funds, just partitioning the checking account
> makes for less work.
>
> Another alternative (will let you  partially use the reconcile feature)
> is partition but only write checks against main (before writing the
> check for an expense qualified to use restricted, transfer the amount
> from that partition). The total balance amount according to the bank
> won't match the balance of the check writing partition but no bog deal
> to just add the remaining balances of the reserved partitions.
>
> Note that an organization that DOES keep restricted funds in a separate
> bank account, unless these are LARGE restricted funds, will likely have
> only one "other" bank account for all the restricted funds and that
> would be partitioned.
>
> Michael D Novack
>
>
> ___
> 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.

Re: [GNC] Can a bank account have sub-accounts?

[Michael or Penny Novack]

On 3/13/2023 10:35 AM, Mort Q wrote:

Hi Robert
I do have lots of expense accounts for repairs, catering, office expenses,
utilities, etc, and income accounts for fund raising, donations,
memberships, etc. so we can track income and expenses easily.  The GnuCash
reports really help people see where money is coming from and going to.
That's one of the reasons I was thinking of having the sub accounts - the
bank reports will be like an overall report but with the underlying break
down of fund allocation.  Does that make sense?


As noted, this will cost you the ability to use the "reconcile" feature.

But folks, I've been there and done that as treasurer of orgs. This is a 
trade off that might make sense. Keep in mind that such orgs might have 
a rather low monthly volume of transactions against the checking 
account. Reconciling the old fashioned way no big deal. When there were 
FORMALLY restricted funds would do that the right way, but for 
informally restricted funds, just partitioning the checking account 
makes for less work.


Another alternative (will let you  partially use the reconcile feature) 
is partition but only write checks against main (before writing the 
check for an expense qualified to use restricted, transfer the amount 
from that partition). The total balance amount according to the bank 
won't match the balance of the check writing partition but no bog deal 
to just add the remaining balances of the reserved partitions.


Note that an organization that DOES keep restricted funds in a separate 
bank account, unless these are LARGE restricted funds, will likely have 
only one "other" bank account for all the restricted funds and that 
would be partitioned.


Michael D Novack


___
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.

Re: [GNC] Change column widths

[David T. via gnucash-user]

Of course, reading 2.9.2.3. Setting Column Widths in the Guide might also help 
you out. 

David T. 



On Mar 13, 2023, 10:45 PM, at 10:45 PM, David H  wrote:
>Ops that should read...
>
>Personally I always start by double clicking the very rightwardcolumn
>and
>working towards the Description column leaving that until last.
>
>Cheers David H.
>
>On Tue, 14 Mar 2023 at 05:41, David H  wrote:
>
>> James/Bjorn
>>
>> ALWAYS adjust columns leaving the Description column to last as this
>> particular column is a special case and expands to fill the remaining
>> width.  So adjust the Transfer column first - double click on its
>header or
>> click on the right hand header delimiter and drag to the right.  When
>it's
>> where you want it to be then go back to the description column and
>either
>> double click the Description header OR click the right hand column
>> delimiter, drag it to the left and release.
>>
>> Personally I always start by double clicking the very leftward column
>and
>> working towards the Description column leaving that until last.
>>
>> Cheers David H.
>>
>> On Tue, 14 Mar 2023 at 05:29, Björn Sunde
>
>> wrote:
>>
>>> I would like to shorten the width of the Description column and
>increase
>>> the width of the Transfer column as some of the Transfer entries are
>>> very long.  Is there some way to do this?
>>>
>>> Thanks in advance.
>>>
>>> James Wilde
>>> ___
>>> 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.
___
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.

Re: [GNC] Change column widths

[David Carlson]

There is a description of how to do this in the help.  Basically, grab the
right edge of the account column header and move it either way to the
desired width, then grab the right edge of the description column header
and move it left far enough to eliminate the horizontal scroll bar.

You can start by double clicking the category header, and if that makes the
account column too wide, grab the right edge an move it left as desired.

In the next software release there will be a fix so all the column widths
will be remembered when the register is closed.  Currently sometimes they
are not.

On Mon, Mar 13, 2023, 2:29 PM Björn Sunde 
wrote:

> I would like to shorten the width of the Description column and increase
> the width of the Transfer column as some of the Transfer entries are
> very long.  Is there some way to do this?
>
> Thanks in advance.
>
> James Wilde
> ___
> 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.

Re: [GNC] Change column widths

[David H]

Ops that should read...

Personally I always start by double clicking the very rightwardcolumn and
working towards the Description column leaving that until last.

Cheers David H.

On Tue, 14 Mar 2023 at 05:41, David H  wrote:

> James/Bjorn
>
> ALWAYS adjust columns leaving the Description column to last as this
> particular column is a special case and expands to fill the remaining
> width.  So adjust the Transfer column first - double click on its header or
> click on the right hand header delimiter and drag to the right.  When it's
> where you want it to be then go back to the description column and either
> double click the Description header OR click the right hand column
> delimiter, drag it to the left and release.
>
> Personally I always start by double clicking the very leftward column and
> working towards the Description column leaving that until last.
>
> Cheers David H.
>
> On Tue, 14 Mar 2023 at 05:29, Björn Sunde 
> wrote:
>
>> I would like to shorten the width of the Description column and increase
>> the width of the Transfer column as some of the Transfer entries are
>> very long.  Is there some way to do this?
>>
>> Thanks in advance.
>>
>> James Wilde
>> ___
>> 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.

Re: [GNC] Change column widths

[David H]

James/Bjorn

ALWAYS adjust columns leaving the Description column to last as this
particular column is a special case and expands to fill the remaining
width.  So adjust the Transfer column first - double click on its header or
click on the right hand header delimiter and drag to the right.  When it's
where you want it to be then go back to the description column and either
double click the Description header OR click the right hand column
delimiter, drag it to the left and release.

Personally I always start by double clicking the very leftward column and
working towards the Description column leaving that until last.

Cheers David H.

On Tue, 14 Mar 2023 at 05:29, Björn Sunde 
wrote:

> I would like to shorten the width of the Description column and increase
> the width of the Transfer column as some of the Transfer entries are
> very long.  Is there some way to do this?
>
> Thanks in advance.
>
> James Wilde
> ___
> 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.

Re: [GNC] Change column widths

[Vincent Dawans]

This question comes back from time to time. It's a bit counter intuitive.
First you must resize the transfer column by pointing to the right edge of
the heading, on the line, and click and drag to the right. Yes when you do
that it will push the columns to the right out of the screen but that's Ok.
Then you do the same with the description column except now you drag the
right edge of the description heading to the left (or just double click on
it) to reduce the size of that column and bring back the other columns into
the screen.

On Mon, Mar 13, 2023 at 12:29 PM Björn Sunde 
wrote:

> I would like to shorten the width of the Description column and increase
> the width of the Transfer column as some of the Transfer entries are
> very long.  Is there some way to do this?
>
> Thanks in advance.
>
> James Wilde
> ___
> 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.

Re: [GNC] GnuCash flatpak "invisible" update?

[Geert Janssens]

Op zondag 12 maart 2023 16:07:55 CET schreef john:
> A related and perhaps more interesting question for folks with a firmer
> grasp of flathub than I have: I'll be releasing both 4.14 and 5.0 in two
> weeks. IIUC flathub supports only one version at a time so there's no point
> in making a flathub build for 4.14. Both would be available from
> https://code.gnucash.org/builds/flatpak. Is my understanding correct?

FWIW I think it's worth pushing both releases to flathub, first the 4.14 one 
and right 
afterwards 5.0. There are ways to install an earlier version of a package from 
a flatpak repo 
(like flathub). So if you push both, we can document how to install 4.14 if 
there are 
(important) issues with 5.0.

As for installing from https://code.gnucash.org/builds/flatpak, that works, but 
was never 
really set up to be a source of release packages. So it's a bit awkward for 
people that are 
used to the convenience of flatpak.

Regards,

Geert
___
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.

[GNC] Change column widths

[Björn Sunde]

I would like to shorten the width of the Description column and increase 
the width of the Transfer column as some of the Transfer entries are 
very long.  Is there some way to do this?


Thanks in advance.

James Wilde
___
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.

Re: [GNC] User defined currencies in "Expense Accounts"

[R Losey]

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  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   email
>
> 
> From: gnucash-user  on
> behalf of Charles Crossan 
> Sent: Sunday, March 12, 2023 10:51 AM
> To: 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
> ).
>
> 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.

Re: [GNC] Schedule transaction for 2 Wednesday?

[R Losey]

Yes, I was thinking of "conditional" in the sense of "If...then"... and
that AND and OR are merely complex operations; however, in a broader sense,
they are all conditional.

On Sat, Mar 11, 2023 at 12:30 PM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

>
>
> > The earliest the second Thursday can be is the 8th and the latest is
> > the 14th, so if you want the Friday after the second Thursday, you
> > just want
> > "day is Friday AND the day number is between 9 and 15".
> >
> > But I've not found a schedule that can handle that.
>
> That is another example of a conditional, x AND y.
>
> LOL, in my working days I often did things exactly like that. Say had a
> job that ran nightly but on some special days, submitted another job to
> run (that was the purpose of the first, to control on what day the
> second ran).
>
>
> Michael D Novack
>
>
>
>

-- 
_
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.

Re: [GNC] Can a bank account have sub-accounts?

[R Losey]

Yes, you can!

I do something like what you say, as long as these are funds deposited into
the bank that are earmarked for those expenses... As an example, I set
aside some money for a vacation, but those funds are in the bank account,
so I have sub-accounts for how much they have.

I only "transfer" money from this account to the main bank account, since
it is from there that I use debit cards or write checks to pay for things.
Expenses are sent to the vacation expense account.

It's a few extra steps, but it can certainly be done.  Quicken called these
things "savings goals".

In addition to the vacation sub-account, we also have a "credit" sub
account that holds money for paying off the credit card(s) each month. I
happen to enter data weekly, and I transfer money from the bank account to
the credit sub-account to cover all of the charges made that week. That
way, I always have enough funds to pay off the credit card(s). When a
payment is due, we transfer money from the credit account to the bank
account, and then pay the card from the bank account.

You might be able to do something by having those expenses, such as
Equipment Enhancement get both the credits and debits, but I'm not sure how
you would keep the bank balance right (there is probably an accounting way
to do this)... as a personal example, if I get $50 a month for clothing
expenditures, I could give the clothing account $50 each month, and then
take the money away as I spend it on clothes... the account would therefore
always tell me the exact balance in the clothing account. But I don't know
what the other side of the $50 added would be. Future spending?  Budgeted?


On Mon, Mar 13, 2023 at 8:55 AM Mort Q  wrote:

> Hi all
> I act as Treasurer for a community organisation, and want to look for a way
> that GnuCash can subdivide the money in the bank account into planned
> expenses e.g. a few members do ongoing fund raising for equipment, so could
> I make a sub-account of the bank account called "Equipment enhancement"?
> When making a deposit, allocate that money to "Assets:Current Assets:Bank
> Account:Equipment Enhancement" instead of the currently-used
> "Assets:Current Assets:Bank Account".
>
> Currently, we just have the one account called "Bank Account" in the Assets
> tree, and I keep a separate spreadsheet with the allocation break up.  I
> have to remember to do the extra work to keep the spreadsheet up to date.
> In my previous life, I learnt that it was better to have a single point of
> truth for data.
>
> I am thinking I will end up with an account tree like
> Assets:
>-Current Assets:
> -Accounts Receivable
> -Bank Account:  (will still need this to be reported on for audits,
> etc, as a single account)
>   -General Funds
>   -Equipment Enhancement
>   -Saved for something else
>   -etc
> Does this make sense?  Or am I missing something?
> Or creating a nightmare that will come back and bite me when I try to do
> reports, etc later?
>
> Clearly, I am not an accountant, and a self-taught GnuCash user.
>
> Thanks
> Mort
> ___
> 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.

Re: [GNC] Can a bank account have sub-accounts?

[Peter West via gnucash-user]

If you use a variant of envelope budgeting, your actual bank account can be a 
placeholder account, and every transaction against that account is actually 
recorded in one of the subaccounts. The total balance of all the subaccounts 
will show against the placeholder account. By using the OpenSubaccounts item in 
the menu for the placeholder, you will see a list of all of the transactions in 
the subaccounts. You cannot edit this list, but you can check the items against 
your bank statement. If you then uncheck ‘Placeholder account’ you will lose 
the grand total, but you will be able to edit, hence reconcile, the items in 
the ‘Open Subaccounts’ transaction display. After reconciliation you can 
recheck the ‘Placeholder Account’.

I haven’t actually tried this process during reconciliation, but perhaps 
someone else has, and can give you the pros and cons or suggest an alternative.

—
Peter West
p...@pbw.id.au
“Blessed are you when others revile you and persecute you and utter all kinds 
of evil against you falsely on my account.”




> On 14 Mar 2023, at 12:46 am, Murugan Muruganandam 
>  wrote:
> 
> hi Mort
> 
> The  expenses account can be granular and can be tracked separately.  for 
> Asset account unless you have separate bank accounts, you cannot separate it 
> in your accounting system.
> You can use sub accounts, but it would be a huge overhead for you to 
> reconcile your bank statement with individual buckets you have created.
> 
> 
> 
> 
> 
> Saludos Cordiales
> 
> 
> Murugan
> 
> 
> From: gnucash-user 
>  on behalf of 
> Mort Q 
> Sent: Monday, March 13, 2023 11:35 AM
> To: Robert Heller 
> Cc: gnucash-user@gnucash.org 
> Subject: Re: [GNC] Can a bank account have sub-accounts?
> 
> Hi Robert
> I do have lots of expense accounts for repairs, catering, office expenses,
> utilities, etc, and income accounts for fund raising, donations,
> memberships, etc. so we can track income and expenses easily.  The GnuCash
> reports really help people see where money is coming from and going to.
> That's one of the reasons I was thinking of having the sub accounts - the
> bank reports will be like an overall report but with the underlying break
> down of fund allocation.  Does that make sense?
> 
> Every transaction is double entry, I think (one account credited and the
> other debited) e.g. a bill payment will credit Liabilities:Accounts Payable
> and debit Assets:Current Assets:Bank Account.  Is that what you mean?
> 
> Thanks
> Mort
> 
> On Tue, 14 Mar 2023 at 00:05, Robert Heller  wrote:
> 
>> At Mon, 13 Mar 2023 23:55:05 +1000 Mort Q  wrote:
>> 
>>> 
>>> Hi all
>>> I act as Treasurer for a community organisation, and want to look for a
>> way
>>> that GnuCash can subdivide the money in the bank account into planned
>>> expenses e.g. a few members do ongoing fund raising for equipment, so
>> could
>>> I make a sub-account of the bank account called "Equipment enhancement"?
>>> When making a deposit, allocate that money to "Assets:Current Assets:Bank
>>> Account:Equipment Enhancement" instead of the currently-used
>>> "Assets:Current Assets:Bank Account".
>>> 
>>> Currently, we just have the one account called "Bank Account" in the
>> Assets
>>> tree, and I keep a separate spreadsheet with the allocation break up.  I
>>> have to remember to do the extra work to keep the spreadsheet up to date.
>>> In my previous life, I learnt that it was better to have a single point
>> of
>>> truth for data.
>>> 
>>> I am thinking I will end up with an account tree like
>>> Assets:
>>>   -Current Assets:
>>>-Accounts Receivable
>>>-Bank Account:  (will still need this to be reported on for
>> audits,
>>> etc, as a single account)
>>>  -General Funds
>>>  -Equipment Enhancement
>>>  -Saved for something else
>>>  -etc
>>> Does this make sense?  Or am I missing something?
>>> Or creating a nightmare that will come back and bite me when I try to do
>>> reports, etc later?
>>> 
>>> Clearly, I am not an accountant, and a self-taught GnuCash user.
>> 
>> Clearly :-).
>> 
>> You are not fully understanding double-entry bookkeeping and how GnuCash
>> works
>> and is generally meant to be used.
>> 
>> Yes, you can have sub-accounts under Bank Account, but probably should be
>> looking at creating a budget.
>> 
>> You should *also* create additional accounts for the various expenses and
>> so
>> on as well.
>> 
>>> 
>>> Thanks
>>> Mort
>>> ___
>>> 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.
>>> 
>>> 
>> 
>>> 
>> 
>> --
>> Robert Heller -- Cell: 413-658-7953 GV: 978-633-5364
>> Deepwoods Software-- Custom Software Ser

Re: [GNC] Can a bank account have sub-accounts?

[Alton Brantley]

to answer your question— yes, a bank account can have subaccounts. 

I use a subaccount named “ACH” for  Automated Clearing House bank and 
investment accounts so that double entry accounts match up to statements on 
both credit cards and check ledgers to account for the delay going through the 
ACH. It just requires a second transaction to record the second half of the ACH 
activity. So e.g. an automatic payment on a Cc account is two entries:
1. Debit CC , Credit Bank:ACH
 Now the CC statement dates match
2. Debit Bank:ACH, Credit Bank
 Now the ACH balance is 0 and each statement matches up. 

The process is easy because I enter both transactions at the same time with the 
same date, and then correct dates on part 2 above at reconciliation. 


In order to see the bank account and subaccounts during bank statement 
reconciliation, just use the “include subaccounts” feature and the bank 
register will open with its name followed by a “+” so my “Bank of America” 
account opens as “Bank of America+”

--Alton Brantley

___
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.

Re: [GNC] gnu-fq-check missing

[john]

> On Mar 12, 2023, at 5:37 PM, rolf.hoef...@gmail.com wrote:
> 
> Hi, I've been trying hard to be able to run "Install Online Price
> Retrieval", and I almost made it.. but I got this.. and it's right..
> there's no gnu-fq-check program in bin.. how can I get it? I think I'm
> almost there..

That depends on the version of GnuCash. If it's a 4.90x beta gnc-fq-check, 
gnc-fq-helper, and gnc-fq-dump have been replaced with finance-quote-wrapper 
and their function is now in gnucash-cli. We neglected to modify the Install 
Online Price Retrieval tool to reflect that. The two calls to gnc-fq-check and 
gnc-fq-helper in install-fq-mods.cmd are final checks to make sure everything 
succeeded, so you probably are done. You can run c:\Program Files 
(x86)\gnucash\bin\gnucash-cli -Q info and …\gnucash-cli -Q dump alphavantage 
AMZN to test it.

OTOH if you're using a production release of GnuCash then gnc-fq-check should 
be in C:\Program Files (x86)\gnucash\bin and since install-fq-mods.cmd is in 
that directory too it should have found it.

Regards,
John Ralls


___
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.

Re: [GNC] Can a bank account have sub-accounts?

[Dan Black]

With subaccounts, when you reconcile be sure to check the box to include 
subaccounts and it's fairly easy to reconcile it.


Dan


On March 13, 2023 10:47:31 AM Murugan Muruganandam 
 wrote:



hi Mort

The  expenses account can be granular and can be tracked seperately.  for 
Asset account unless you have separate bank accounts, you cannot separate 
it in your accounting system.
You can use sub accounts, but it would be a huge overhead for you to 
reconcile your bank statement with individual buckets you have created.






Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of 
Mort Q 

Sent: Monday, March 13, 2023 11:35 AM
To: Robert Heller 
Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] Can a bank account have sub-accounts?

Hi Robert
I do have lots of expense accounts for repairs, catering, office expenses,
utilities, etc, and income accounts for fund raising, donations,
memberships, etc. so we can track income and expenses easily.  The GnuCash
reports really help people see where money is coming from and going to.
That's one of the reasons I was thinking of having the sub accounts - the
bank reports will be like an overall report but with the underlying break
down of fund allocation.  Does that make sense?

Every transaction is double entry, I think (one account credited and the
other debited) e.g. a bill payment will credit Liabilities:Accounts Payable
and debit Assets:Current Assets:Bank Account.  Is that what you mean?

Thanks
Mort

On Tue, 14 Mar 2023 at 00:05, Robert Heller  wrote:


At Mon, 13 Mar 2023 23:55:05 +1000 Mort Q  wrote:

>
> Hi all
> I act as Treasurer for a community organisation, and want to look for a
way
> that GnuCash can subdivide the money in the bank account into planned
> expenses e.g. a few members do ongoing fund raising for equipment, so
could
> I make a sub-account of the bank account called "Equipment enhancement"?
> When making a deposit, allocate that money to "Assets:Current Assets:Bank
> Account:Equipment Enhancement" instead of the currently-used
> "Assets:Current Assets:Bank Account".
>
> Currently, we just have the one account called "Bank Account" in the
Assets
> tree, and I keep a separate spreadsheet with the allocation break up.  I
> have to remember to do the extra work to keep the spreadsheet up to date.
> In my previous life, I learnt that it was better to have a single point
of
> truth for data.
>
> I am thinking I will end up with an account tree like
> Assets:
>-Current Assets:
> -Accounts Receivable
> -Bank Account:  (will still need this to be reported on for
audits,
> etc, as a single account)
>   -General Funds
>   -Equipment Enhancement
>   -Saved for something else
>   -etc
> Does this make sense?  Or am I missing something?
> Or creating a nightmare that will come back and bite me when I try to do
> reports, etc later?
>
> Clearly, I am not an accountant, and a self-taught GnuCash user.

Clearly :-).

You are not fully understanding double-entry bookkeeping and how GnuCash
works
and is generally meant to be used.

Yes, you can have sub-accounts under Bank Account, but probably should be
looking at creating a budget.

You should *also* create additional accounts for the various expenses and
so
on as well.

>
> Thanks
> Mort
> ___
> 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.
>
>

>

--
Robert Heller -- Cell: 413-658-7953 GV: 978-633-5364
Deepwoods Software-- Custom Software Services
http://www.deepsoft.com/  -- Linux Administration Services
hel...@deepsoft.com   -- Webhosting Services



___
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.


___
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.

Re: [GNC] Can a bank account have sub-accounts?

[Murugan Muruganandam]

hi Mort

The  expenses account can be granular and can be tracked seperately.  for Asset 
account unless you have separate bank accounts, you cannot separate it in your 
accounting system.
You can use sub accounts, but it would be a huge overhead for you to reconcile 
your bank statement with individual buckets you have created.





Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of Mort 
Q 
Sent: Monday, March 13, 2023 11:35 AM
To: Robert Heller 
Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] Can a bank account have sub-accounts?

Hi Robert
I do have lots of expense accounts for repairs, catering, office expenses,
utilities, etc, and income accounts for fund raising, donations,
memberships, etc. so we can track income and expenses easily.  The GnuCash
reports really help people see where money is coming from and going to.
That's one of the reasons I was thinking of having the sub accounts - the
bank reports will be like an overall report but with the underlying break
down of fund allocation.  Does that make sense?

Every transaction is double entry, I think (one account credited and the
other debited) e.g. a bill payment will credit Liabilities:Accounts Payable
and debit Assets:Current Assets:Bank Account.  Is that what you mean?

Thanks
Mort

On Tue, 14 Mar 2023 at 00:05, Robert Heller  wrote:

> At Mon, 13 Mar 2023 23:55:05 +1000 Mort Q  wrote:
>
> >
> > Hi all
> > I act as Treasurer for a community organisation, and want to look for a
> way
> > that GnuCash can subdivide the money in the bank account into planned
> > expenses e.g. a few members do ongoing fund raising for equipment, so
> could
> > I make a sub-account of the bank account called "Equipment enhancement"?
> > When making a deposit, allocate that money to "Assets:Current Assets:Bank
> > Account:Equipment Enhancement" instead of the currently-used
> > "Assets:Current Assets:Bank Account".
> >
> > Currently, we just have the one account called "Bank Account" in the
> Assets
> > tree, and I keep a separate spreadsheet with the allocation break up.  I
> > have to remember to do the extra work to keep the spreadsheet up to date.
> > In my previous life, I learnt that it was better to have a single point
> of
> > truth for data.
> >
> > I am thinking I will end up with an account tree like
> > Assets:
> >-Current Assets:
> > -Accounts Receivable
> > -Bank Account:  (will still need this to be reported on for
> audits,
> > etc, as a single account)
> >   -General Funds
> >   -Equipment Enhancement
> >   -Saved for something else
> >   -etc
> > Does this make sense?  Or am I missing something?
> > Or creating a nightmare that will come back and bite me when I try to do
> > reports, etc later?
> >
> > Clearly, I am not an accountant, and a self-taught GnuCash user.
>
> Clearly :-).
>
> You are not fully understanding double-entry bookkeeping and how GnuCash
> works
> and is generally meant to be used.
>
> Yes, you can have sub-accounts under Bank Account, but probably should be
> looking at creating a budget.
>
> You should *also* create additional accounts for the various expenses and
> so
> on as well.
>
> >
> > Thanks
> > Mort
> > ___
> > 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.
> >
> >
>
> >
>
> --
> Robert Heller -- Cell: 413-658-7953 GV: 978-633-5364
> Deepwoods Software-- Custom Software Services
> http://www.deepsoft.com/  -- Linux Administration Services
> hel...@deepsoft.com   -- Webhosting Services
>
>
___
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.

Re: [GNC] Can a bank account have sub-accounts?

[Mort Q]

Hi Robert
I do have lots of expense accounts for repairs, catering, office expenses,
utilities, etc, and income accounts for fund raising, donations,
memberships, etc. so we can track income and expenses easily.  The GnuCash
reports really help people see where money is coming from and going to.
That's one of the reasons I was thinking of having the sub accounts - the
bank reports will be like an overall report but with the underlying break
down of fund allocation.  Does that make sense?

Every transaction is double entry, I think (one account credited and the
other debited) e.g. a bill payment will credit Liabilities:Accounts Payable
and debit Assets:Current Assets:Bank Account.  Is that what you mean?

Thanks
Mort

On Tue, 14 Mar 2023 at 00:05, Robert Heller  wrote:

> At Mon, 13 Mar 2023 23:55:05 +1000 Mort Q  wrote:
>
> >
> > Hi all
> > I act as Treasurer for a community organisation, and want to look for a
> way
> > that GnuCash can subdivide the money in the bank account into planned
> > expenses e.g. a few members do ongoing fund raising for equipment, so
> could
> > I make a sub-account of the bank account called "Equipment enhancement"?
> > When making a deposit, allocate that money to "Assets:Current Assets:Bank
> > Account:Equipment Enhancement" instead of the currently-used
> > "Assets:Current Assets:Bank Account".
> >
> > Currently, we just have the one account called "Bank Account" in the
> Assets
> > tree, and I keep a separate spreadsheet with the allocation break up.  I
> > have to remember to do the extra work to keep the spreadsheet up to date.
> > In my previous life, I learnt that it was better to have a single point
> of
> > truth for data.
> >
> > I am thinking I will end up with an account tree like
> > Assets:
> >-Current Assets:
> > -Accounts Receivable
> > -Bank Account:  (will still need this to be reported on for
> audits,
> > etc, as a single account)
> >   -General Funds
> >   -Equipment Enhancement
> >   -Saved for something else
> >   -etc
> > Does this make sense?  Or am I missing something?
> > Or creating a nightmare that will come back and bite me when I try to do
> > reports, etc later?
> >
> > Clearly, I am not an accountant, and a self-taught GnuCash user.
>
> Clearly :-).
>
> You are not fully understanding double-entry bookkeeping and how GnuCash
> works
> and is generally meant to be used.
>
> Yes, you can have sub-accounts under Bank Account, but probably should be
> looking at creating a budget.
>
> You should *also* create additional accounts for the various expenses and
> so
> on as well.
>
> >
> > Thanks
> > Mort
> > ___
> > 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.
> >
> >
>
> >
>
> --
> Robert Heller -- Cell: 413-658-7953 GV: 978-633-5364
> Deepwoods Software-- Custom Software Services
> http://www.deepsoft.com/  -- Linux Administration Services
> hel...@deepsoft.com   -- Webhosting Services
>
>
___
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.

Re: [GNC] Can a bank account have sub-accounts?

[Mort Q]

Thanks Rich.
I thought of something like that, but I can't see how it works when I pay a
bill, for example.
e.g. The money for the new widget comes out of the widget asset account,
and the bank account isn't debited, so GnuCash doesn't have a record that
matches the bank statement any more.  That was the thinking that led me to
wonder about the extra asset accounts being under the main bank account.

Does that make sense?
Cheers
Mort

On Tue, 14 Mar 2023 at 00:03, Rich Shepard  wrote:

> On Mon, 13 Mar 2023, Mort Q wrote:
>
> > I act as Treasurer for a community organisation, and want to look for a
> > way that GnuCash can subdivide the money in the bank account into planned
> > expenses e.g. a few members do ongoing fund raising for equipment, so
> > could I make a sub-account of the bank account called "Equipment
> > enhancement"? When making a deposit, allocate that money to
> > "Assets:Current Assets:Bank Account:Equipment Enhancement" instead of the
> > currently-used "Assets:Current Assets:Bank Account".
>
> Mort,
>
> Why not have multiple asset accounts? For example, "Checking," "Equipment,"
> "Petty Cash?" When you make a deposit you can split it among all pertinent
> accounts.
>
> They're not sub-accounts of a checking account, for example, but idividual
> accounts. It's similar to a set of expense accounts; e.g, Rent, Utilities
> (which would have sub-accounts for Electric, Gas, Water, Garbage or
> whatever
> utility expenses you have), Repair & Maintenance, etc.
>
> HTH,
>
> Rich
> ___
> 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.

Re: [GNC] Can a bank account have sub-accounts?

[Robert Heller]

At Mon, 13 Mar 2023 23:55:05 +1000 Mort Q  wrote:

> 
> Hi all
> I act as Treasurer for a community organisation, and want to look for a way
> that GnuCash can subdivide the money in the bank account into planned
> expenses e.g. a few members do ongoing fund raising for equipment, so could
> I make a sub-account of the bank account called "Equipment enhancement"?
> When making a deposit, allocate that money to "Assets:Current Assets:Bank
> Account:Equipment Enhancement" instead of the currently-used
> "Assets:Current Assets:Bank Account".
> 
> Currently, we just have the one account called "Bank Account" in the Assets
> tree, and I keep a separate spreadsheet with the allocation break up.  I
> have to remember to do the extra work to keep the spreadsheet up to date.
> In my previous life, I learnt that it was better to have a single point of
> truth for data.
> 
> I am thinking I will end up with an account tree like
> Assets:
>-Current Assets:
> -Accounts Receivable
> -Bank Account:  (will still need this to be reported on for audits,
> etc, as a single account)
>   -General Funds
>   -Equipment Enhancement
>   -Saved for something else
>   -etc
> Does this make sense?  Or am I missing something?
> Or creating a nightmare that will come back and bite me when I try to do
> reports, etc later?
> 
> Clearly, I am not an accountant, and a self-taught GnuCash user.

Clearly :-).

You are not fully understanding double-entry bookkeeping and how GnuCash works 
and is generally meant to be used.

Yes, you can have sub-accounts under Bank Account, but probably should be 
looking at creating a budget.

You should *also* create additional accounts for the various expenses and so 
on as well.

> 
> Thanks
> Mort
> ___
> 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.
> 
>   
>   
> 

-- 
Robert Heller -- Cell: 413-658-7953 GV: 978-633-5364
Deepwoods Software-- Custom Software Services
http://www.deepsoft.com/  -- Linux Administration Services
hel...@deepsoft.com   -- Webhosting Services

___
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.

Re: [GNC] Can a bank account have sub-accounts?

[Rich Shepard]

On Mon, 13 Mar 2023, Mort Q wrote:


I act as Treasurer for a community organisation, and want to look for a
way that GnuCash can subdivide the money in the bank account into planned
expenses e.g. a few members do ongoing fund raising for equipment, so
could I make a sub-account of the bank account called "Equipment
enhancement"? When making a deposit, allocate that money to
"Assets:Current Assets:Bank Account:Equipment Enhancement" instead of the
currently-used "Assets:Current Assets:Bank Account".


Mort,

Why not have multiple asset accounts? For example, "Checking," "Equipment,"
"Petty Cash?" When you make a deposit you can split it among all pertinent
accounts.

They're not sub-accounts of a checking account, for example, but idividual
accounts. It's similar to a set of expense accounts; e.g, Rent, Utilities
(which would have sub-accounts for Electric, Gas, Water, Garbage or whatever
utility expenses you have), Repair & Maintenance, etc.

HTH,

Rich
___
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.

[GNC] Can a bank account have sub-accounts?

[Mort Q]

Hi all
I act as Treasurer for a community organisation, and want to look for a way
that GnuCash can subdivide the money in the bank account into planned
expenses e.g. a few members do ongoing fund raising for equipment, so could
I make a sub-account of the bank account called "Equipment enhancement"?
When making a deposit, allocate that money to "Assets:Current Assets:Bank
Account:Equipment Enhancement" instead of the currently-used
"Assets:Current Assets:Bank Account".

Currently, we just have the one account called "Bank Account" in the Assets
tree, and I keep a separate spreadsheet with the allocation break up.  I
have to remember to do the extra work to keep the spreadsheet up to date.
In my previous life, I learnt that it was better to have a single point of
truth for data.

I am thinking I will end up with an account tree like
Assets:
   -Current Assets:
-Accounts Receivable
-Bank Account:  (will still need this to be reported on for audits,
etc, as a single account)
  -General Funds
  -Equipment Enhancement
  -Saved for something else
  -etc
Does this make sense?  Or am I missing something?
Or creating a nightmare that will come back and bite me when I try to do
reports, etc later?

Clearly, I am not an accountant, and a self-taught GnuCash user.

Thanks
Mort
___
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.

Re: [GNC] User defined currencies in "Expense Accounts"

[John Layman]

"I realize I'm probably a tad crazy for wanting this level of detail."

Perhaps not.  But recognize that GnuCash is built upon an abstract data
model where the elements and their relationship to one another have meaning.
If you overload those semantics you are degrading the consistency and
coherence of the software.  You'd be better tracking such non-financial
information in a purpose-built spreadsheet.


-Original Message-
From: gnucash-user 
On Behalf Of Charles Crossan
Sent: Sunday, March 12, 2023 10:52 AM
To: 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
).

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.