Re: [GNC] operation still running....

2024-06-06 Thread R Losey
Could it be a transaction that was filled out, but wasn't completed? (that
is, RETURN or ENTER wasn't pressed on the line?)


On Thu, Jun 6, 2024 at 7:32 PM Stephen M. Butler  wrote:

> I would minimize windows and see if there is one that is waiting for
> input.   Or, start up a terminal session and see what us running with Top.
>
> Stephen M Butler
> stephen.m.butle...@gmail.com
> kg...@arrl.net
> 253-350-0166
> ---
> GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
>
> On 6/6/24 17:18, Richard Dawson wrote:
> > I completed reconciliation and then tried to save and close.  I
> > received a message, "An operation is still running, wait for it to
> > complete before quitting."
> >
> > I've been waiting for quite a while, and nothing seems to be hitting.
> > If I attempt to save, I get the same message.  Only the list of
> > accounts window is open. How should I proceed?
> >
> > I am running Version: 4.8, Build ID: 4.8a+(2021-09-28), from, as I
> > recall, Ubuntu repository.  Using Neon Linux, and ubuntu derivative.
> >
> > Thank you for any suggestions.
> >
> > ___
> > 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] operation still running....

2024-06-06 Thread Stephen M. Butler
I would minimize windows and see if there is one that is waiting for 
input.   Or, start up a terminal session and see what us running with Top.


Stephen M Butler
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

On 6/6/24 17:18, Richard Dawson wrote:
I completed reconciliation and then tried to save and close.  I 
received a message, "An operation is still running, wait for it to 
complete before quitting."


I've been waiting for quite a while, and nothing seems to be hitting.  
If I attempt to save, I get the same message.  Only the list of 
accounts window is open. How should I proceed?


I am running Version: 4.8, Build ID: 4.8a+(2021-09-28), from, as I 
recall, Ubuntu repository.  Using Neon Linux, and ubuntu derivative.


Thank you for any suggestions.

___
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 I set an option to stop auto-fill ?

2024-06-04 Thread NoobAlice

On 2024-06-03 03:44 PM, fromvendor wrote:

Anyway, what I'd like is if the "prior" transaction has splits, then simply 
leave the whole thing un-populated.  If it doesn't have splits, go ahead and put in the 
account.  Leave the cursor in the account field and don't fill in anything else (notes, 
amount, etc).  That would be ideal for me.  Simply turning off the auto-complete is, I 
expect, a simpler option and probably already there I just don't know where to turn it 
off.


I realize this isn't quite what you're asking, but there is a mouse 
right-click option on a transaction to "remove other splits."


When you are typing, using the mouse is not convenient, so you can set 
up a shortcut for it.


Reference: 
https://wiki.gnucash.org/wiki/Keyboard_Shortcuts#Modifying_Keyboard_Shortcuts


I found the full list of shortcut-able actions in my root folder
/usr/share/gnucash/ui/

So in my local file ~/.local/share/gnucash/accelerator-map (on Linux, 
your path will be different if you are on Windows or Apple), I have 
added these 2 lines:


; Remove other splits from transaction
(gtk_accel_path 
"/GncPluginPageRegisterActions/RemoveTransactionSplitsAction" 
"m")


Now I can hit Ctrl+M to make my other splits disappear.

Note that the example in the wiki is a different splits shortcut, I 
think to turn on multiple split entry.


___
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] Delete acct + move txns - can't specify acct

2024-06-03 Thread Chris Skudder
Thank you Fred, you nailed it - the "old" checking acct (the one I want 
to delete) is Type=Bank.
The "new" checking acct into which I want to roll the txn's from the old 
acct was Type=Asset.


And thanks for all the other responses as well.

Next ... to learn how to help revise/expand this page-
https://gnucash.org/docs/v5/C/gnucash-manual/acct-delete.html
... to capture what I've learned here.

Thanks again Fred + all.
And again big thank you to dev's + all who have contributed to and 
maintain this great program + community.


Chris


On 6/3/24 17:48, gnucash-user-requ...@gnucash.org wrote:
Message: 1 Date: Mon, 03 Jun 2024 17:22:31 +0100 From: "Fred Bone" 
 To: gnucash-u...@lists.gnucash.org Subject: Re: 
[GNC] Delete acct + move txns - can't specify acct Message-ID: 
<665dedc7.32669.e533...@fred.mandfb.me.uk>
Some experimenting (2.6.21, but it doesn't strike me as the sort of 
thing that would have changed) it appears to restrict to the same 
Account Type. If I try to delete a "Bank" account under Assets, it 
offers all the other Bank accounts (including the Orphan and Imbalance 
ones). For a Cash account it offers all the Cash accounts. Obviously 
not exhaustive testing but might help.

___
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] Delete acct + move txns - can't specify acct

2024-06-03 Thread Michael or Penny Novack

On 6/3/2024 12:28 PM, Kalpesh Patel wrote:

Is there any reason why not just simply rename account and then re-parent the 
account to where you actually want the transaction to show in the account list 
rather than delete the account and move the transactions during delete?


Well -- the person is having a general problem so I thought not to 
comment on that. But yes, I can't see a good reason to DELETE an 
obsolete bank account (balance now zero). I would think, if examining 
old transaction that were against this account, you'd want to be able to 
do that. Just "hide" it if you don't want it to take up visible space in 
your CoA.


HOWEVER -- what somebody just said might explain why I have never 
encountered the problem. Type "bank", type "cash", etc. LOL, being from 
the old days I wouldn't be using things like that. For example, under 
Assets I would have children "current assets", "investments", "fixed 
assets", etc. Under "current assets" I would have "cash" and all current 
"bank accounts << I'm here, savings accounts are "current assets" >>  
The point is that ALL of these accounts, placeholding parents and 
children would be of fundamental type asset.


So if THIS is what is causing the problem, subtypes offered by gnucash 
that have no meaning in old fashioned bookkeeping, I would not have 
experienced the problem.


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] Can I set an option to stop auto-fill ?

2024-06-03 Thread David Carlson
I think that the autocompletiin feature was refined somewhere in the 5.x
series of releases such that in rrelease 5.6 for some cases there is now a
pop-up offering a couple of options to choose from.  I dont remember the
details and i am sending this from my phone where it is too difficuly to
fix typos.

On Mon, Jun 3, 2024, 3:36 PM Glenn Fowler  wrote:

> One way to "disable" is to simply add a space after the description and it
> will turn off. Another way is to choose "Don't autocomplete" in the
> autocomplete list.
>
> On Mon, Jun 3, 2024 at 4:13 PM sunfish62--- via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
> > It doesn't exist.
> >
> > ⁣David T. ​
> >
> > On Jun 3, 2024, 11:00 PM, at 11:00 PM, Mark at Lorimark <
> > m...@lorimarksolutions.com> wrote:
> > >I don't see an option to turn off the auto-complete.
> > >
> > >~mark petryk
> > >~w:http://www.lorimarksolutions.com
> > >
> > >On 6/3/24 14:44, fromvendor wrote:
> > >> Hi y'all!
> > >>
> > >> I am finding the auto-complete function to be more troublesome than
> > >not and I'd like a way to turn it off.  I don't mind it overmuch
> > >filling in the account so much as the amount and the splits.  I'd
> > >rather have none of it that have the confustion (that's confusion and
> > >frustration in a word) caused by the auto-fill.
> > >>
> > >> I, BTW, am loving the software.  I'm sure the setting is in there
> > >somewhere, I'm just not finding it.
> > >>
> > >___
> > >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.
>
___
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 I set an option to stop auto-fill ?

2024-06-03 Thread Glenn Fowler
One way to "disable" is to simply add a space after the description and it
will turn off. Another way is to choose "Don't autocomplete" in the
autocomplete list.

On Mon, Jun 3, 2024 at 4:13 PM sunfish62--- via gnucash-user <
gnucash-user@gnucash.org> wrote:

> It doesn't exist.
>
> ⁣David T. ​
>
> On Jun 3, 2024, 11:00 PM, at 11:00 PM, Mark at Lorimark <
> m...@lorimarksolutions.com> wrote:
> >I don't see an option to turn off the auto-complete.
> >
> >~mark petryk
> >~w:http://www.lorimarksolutions.com
> >
> >On 6/3/24 14:44, fromvendor wrote:
> >> Hi y'all!
> >>
> >> I am finding the auto-complete function to be more troublesome than
> >not and I'd like a way to turn it off.  I don't mind it overmuch
> >filling in the account so much as the amount and the splits.  I'd
> >rather have none of it that have the confustion (that's confusion and
> >frustration in a word) caused by the auto-fill.
> >>
> >> I, BTW, am loving the software.  I'm sure the setting is in there
> >somewhere, I'm just not finding it.
> >>
> >___
> >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 I set an option to stop auto-fill ?

2024-06-03 Thread sunfish62--- via gnucash-user
It doesn't exist. 

⁣David T. ​

On Jun 3, 2024, 11:00 PM, at 11:00 PM, Mark at Lorimark 
 wrote:
>I don't see an option to turn off the auto-complete.
>
>~mark petryk
>~w:http://www.lorimarksolutions.com
>
>On 6/3/24 14:44, fromvendor wrote:
>> Hi y'all!
>> 
>> I am finding the auto-complete function to be more troublesome than
>not and I'd like a way to turn it off.  I don't mind it overmuch
>filling in the account so much as the amount and the splits.  I'd
>rather have none of it that have the confustion (that's confusion and
>frustration in a word) caused by the auto-fill.
>> 
>> I, BTW, am loving the software.  I'm sure the setting is in there
>somewhere, I'm just not finding it.
>> 
>___
>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 I set an option to stop auto-fill ?

2024-06-03 Thread Mark at Lorimark

I don't see an option to turn off the auto-complete.

~mark petryk
~w:http://www.lorimarksolutions.com

On 6/3/24 14:44, fromvendor wrote:

Hi y'all!

I am finding the auto-complete function to be more troublesome than not and I'd 
like a way to turn it off.  I don't mind it overmuch filling in the account so 
much as the amount and the splits.  I'd rather have none of it that have the 
confustion (that's confusion and frustration in a word) caused by the auto-fill.

I, BTW, am loving the software.  I'm sure the setting is in there somewhere, 
I'm just not finding it.


___
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] Need help with eBay - tagging multiple sales into one payout hitting checking two business days later

2024-06-03 Thread David G. Pickett via gnucash-user
 For transfers, I put both dates in the description, and start it at the from 
date for ease of reconciling that account, then move it to the to date for ease 
in reconciling that account.  I have not tried that for checks, but might start 
them when cleared and then move them to when written.  Even ACH often shows up 
a business day later.

So much of the business world still runs like it did on daily tape master file 
updates, where they fed one or more tapes of input transactions and inquiries 
into a tape master file update and got one or more output transaction tapes.  
They could do it in real time on disk.  The only downside for instant real time 
is that a delay with notification allows the account owner a chance at catching 
fraud.  Similarly, some CC make me wait days for a statement, as if printing 
paper, when they could generate the pdf from their RDBMS for me interactively 
one second after midnight after the cycle!
On Monday, June 3, 2024 at 11:37:12 AM EDT, R Losey  
wrote:   

 

On Sat, Jun 1, 2024 at 3:40 PM David G. Pickett via gnucash-user 
 wrote:

I like to record my checks written on the day they were written, not cashed, 
but am frustrated that then I cannot check when they cleared!  Float is nice, 
especially if you get interest, but not something I bank on!  :D  Similarly, 
one bank puts a 3 day hold on transfers, so the money goes out one day and 
shows up in the other account 3-5 days later!  Maybe another field would be 
nice?  I don't want to create a limbo account and two transactions to hold the 
value when it is floating!


I have run into this same thing when transferring funds from one institution to 
another.  I have settled on the practice of using the date when it shows up at 
the "TO" institution rather than the "FROM" of the previous one; and I usually 
enter it when the "FROM" initiates the transfer... so there is a future 
transaction when I enter it to know that it is "in transit"
-- 
_
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] Delete acct + move txns - can't specify acct

2024-06-03 Thread Kalpesh Patel
Is there any reason why not just simply rename account and then re-parent the 
account to where you actually want the transaction to show in the account list 
rather than delete the account and move the transactions during delete? 

-Original Message-
From: Mark at Lorimark  
Sent: Monday, June 03, 2024 8:19 AM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Delete acct + move txns - can't specify acct

Yes, pretty basic simple small business file, checking, savings, CD's...

~mark petryk
~w:http://www.lorimarksolutions.com

On 6/3/24 07:17, Derek Atkins wrote:
> I presume the accounts have the same currency?
> I honestly do not recall what algorithm is used to choose options there.
> 
> -derek
> 


___
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] Delete acct + move txns - can't specify acct

2024-06-03 Thread Fred Bone
On 03 June 2024 at 8:17, Derek Atkins said:

> I presume the accounts have the same currency?
> I honestly do not recall what algorithm is used to choose options there.

Some experimenting (2.6.21, but it doesn't strike me as the sort of thing 
that would have changed) it appears to restrict to the same Account Type. 
If I try to delete a "Bank" account under Assets, it offers all the other 
Bank accounts (including the Orphan and Imbalance ones). For a Cash 
account it offers all the Cash accounts.

Obviously not exhaustive testing but might help.
___
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] Need help with eBay - tagging multiple sales into one payout hitting checking two business days later

2024-06-03 Thread R Losey
On Sat, Jun 1, 2024 at 3:40 PM David G. Pickett via gnucash-user <
gnucash-user@gnucash.org> wrote:

> I like to record my checks written on the day they were written, not
> cashed, but am frustrated that then I cannot check when they cleared!
> Float is nice, especially if you get interest, but not something I bank
> on!  :D  Similarly, one bank puts a 3 day hold on transfers, so the money
> goes out one day and shows up in the other account 3-5 days later!  Maybe
> another field would be nice?  I don't want to create a limbo account and
> two transactions to hold the value when it is floating!
>

I have run into this same thing when transferring funds from one
institution to another.  I have settled on the practice of using the date
when it shows up at the "TO" institution rather than the "FROM" of the
previous one; and I usually enter it when the "FROM" initiates the
transfer... so there is a future transaction when I enter it to know that
it is "in transit"

-- 
_
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] Delete acct + move txns - can't specify acct

2024-06-03 Thread Mark at Lorimark

Yes, pretty basic simple small business file, checking, savings, CD's...

~mark petryk
~w:http://www.lorimarksolutions.com

On 6/3/24 07:17, Derek Atkins wrote:

I presume the accounts have the same currency?
I honestly do not recall what algorithm is used to choose options there.

-derek


___
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] Delete acct + move txns - can't specify acct

2024-06-03 Thread Derek Atkins
I presume the accounts have the same currency?
I honestly do not recall what algorithm is used to choose options there.

-derek

On Mon, June 3, 2024 8:00 am, Mark at Lorimark wrote:
> Yea, I tried that, thinking the same.  It didn't work.  One of the
> assets it presented was in a different tree.  I added a 'test' account
> there and it didn't show, then moved that test account to the same
> branch as the account I was trying to delete, still no joy.
>
> ~mark petryk
> ~w:http://www.lorimarksolutions.com
>
> On 6/3/24 06:57, Derek Atkins wrote:
>> Hi,
>>
>> I admit I have not used the function, but my recollection is that it
>> only
>> lets you roll it up into a parent account -- so if you want to choose a
>> specific account you need to re-parent the account-to-be-deleted under
>> the
>> account you want to move the transactions into, and then when you delete
>> it you should be able to choose the new parent.
>>
>> I'll note that I have not tried to verify this belief, so YMMV.
>>
>> -derek
> ___
> 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.
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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] Delete acct + move txns - can't specify acct

2024-06-03 Thread Mark at Lorimark
Yea, I tried that, thinking the same.  It didn't work.  One of the 
assets it presented was in a different tree.  I added a 'test' account 
there and it didn't show, then moved that test account to the same 
branch as the account I was trying to delete, still no joy.


~mark petryk
~w:http://www.lorimarksolutions.com

On 6/3/24 06:57, Derek Atkins wrote:

Hi,

I admit I have not used the function, but my recollection is that it only
lets you roll it up into a parent account -- so if you want to choose a
specific account you need to re-parent the account-to-be-deleted under the
account you want to move the transactions into, and then when you delete
it you should be able to choose the new parent.

I'll note that I have not tried to verify this belief, so YMMV.

-derek

___
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] Delete acct + move txns - can't specify acct

2024-06-03 Thread Derek Atkins
Hi,

I admit I have not used the function, but my recollection is that it only
lets you roll it up into a parent account -- so if you want to choose a
specific account you need to re-parent the account-to-be-deleted under the
account you want to move the transactions into, and then when you delete
it you should be able to choose the new parent.

I'll note that I have not tried to verify this belief, so YMMV.

-derek

On Mon, June 3, 2024 7:43 am, Mark at Lorimark wrote:
> I'm curious what your account tree looks like.
>
> I just tried to delete an account, and it only shows a couple of my
> other asset accounts.  I created a 'test' account, and even that didn't
> show up... interesting.
>
> Never used that before, not sure what's expected of it.
>
> ~mark petryk
> ~w:http://www.lorimarksolutions.com
>
> On 6/2/24 17:21, Chris Skudder wrote:
>> I'm on Flathub 5.4.1, on Xubuntu 22.04 (xml db).
>>
>> I tried to delete a closed checking acct, and move the transactions to
>> another checking acct.
>>
>> When in the "Delete Acct" dialog box, I get the button to move
>> transactions to another acct, and GnuCash offers another asset acct -
>> but not the one I want.
>>
>> I cannot change this "move to" acct - I can't type the name of the acct
>> that I want into the box. I can type characters, but whatever I type, it
>> only offers the one single acct which it first offers. The dropdown also
>> offers Imbalance + Orphan.
>>
>> I looked here -
>> https://gnucash.org/docs/v5/C/gnucash-manual/acct-delete.html
>> ... didn't find any mention of how to specify the "move-to" acct.
>>
>> Any ideas? Thanks in advance.
>>
> ___
> 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.
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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] Delete acct + move txns - can't specify acct

2024-06-03 Thread Mark at Lorimark

I'm curious what your account tree looks like.

I just tried to delete an account, and it only shows a couple of my 
other asset accounts.  I created a 'test' account, and even that didn't 
show up... interesting.


Never used that before, not sure what's expected of it.

~mark petryk
~w:http://www.lorimarksolutions.com

On 6/2/24 17:21, Chris Skudder wrote:

I'm on Flathub 5.4.1, on Xubuntu 22.04 (xml db).

I tried to delete a closed checking acct, and move the transactions to 
another checking acct.


When in the "Delete Acct" dialog box, I get the button to move 
transactions to another acct, and GnuCash offers another asset acct - 
but not the one I want.


I cannot change this "move to" acct - I can't type the name of the acct 
that I want into the box. I can type characters, but whatever I type, it 
only offers the one single acct which it first offers. The dropdown also 
offers Imbalance + Orphan.


I looked here -
https://gnucash.org/docs/v5/C/gnucash-manual/acct-delete.html
... didn't find any mention of how to specify the "move-to" acct.

Any ideas? Thanks in advance.


___
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] Delete acct + move txns - can't specify acct

2024-06-02 Thread Chris Skudder

<< Is the missing account set to Placeholder? >>
 ... no, it is not ... still, thanks for coming back on it.
- Chris


*From:* sunfis...@yahoo.com
*To:* Chris Skudder
*Cc:* Gnucash Users
*Date:* Sunday, June 2, 2024 at 11:35 PM
*Subject:* [GNC] Delete acct + move txns - can't specify acct


Is the missing account set to Placeholder?

David T.
On Jun 3, 2024, at 1:22 AM, Chris Skudder  wrote:

I'm on Flathub 5.4.1, on Xubuntu 22.04 (xml db).

I tried to delete a closed checking acct, and move the transactions to
another checking acct.

When in the "Delete Acct" dialog box, I get the button to move
transactions to another acct, and GnuCash offers another asset acct -
but not the one I want.

I cannot change this "move to" acct - I can't type the name of the acct
that I want into the box. I can type characters, but whatever I type, it
only offers the one single acct which it first offers. The dropdown also
offers Imbalance + Orphan.

I looked here -
https://gnucash.org/docs/v5/C/gnucash-manual/acct-delete.html
... didn't find any mention of how to specify the "move-to" acct.

Any ideas? Thanks in advance.

This is a great program. Big thank you for all the thought, time +
effort from dev's and everyone working on it.

Chris


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] Delete acct + move txns - can't specify acct

2024-06-02 Thread sunfish62--- via gnucash-user
Is the missing account set to Placeholder?

⁣David T. ​

On Jun 3, 2024, 1:22 AM, at 1:22 AM, Chris Skudder  
wrote:
>I'm on Flathub 5.4.1, on Xubuntu 22.04 (xml db).
>
>I tried to delete a closed checking acct, and move the transactions to 
>another checking acct.
>
>When in the "Delete Acct" dialog box, I get the button to move 
>transactions to another acct, and GnuCash offers another asset acct - 
>but not the one I want.
>
>I cannot change this "move to" acct - I can't type the name of the acct
>
>that I want into the box. I can type characters, but whatever I type,
>it 
>only offers the one single acct which it first offers. The dropdown
>also 
>offers Imbalance + Orphan.
>
>I looked here -
>https://gnucash.org/docs/v5/C/gnucash-manual/acct-delete.html
>... didn't find any mention of how to specify the "move-to" acct.
>
>Any ideas? Thanks in advance.
>
>This is a great program. Big thank you for all the thought, time + 
>effort from dev's and everyone working on it.
>
>Chris
>___
>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] Need help with eBay - tagging multiple sales into one payout hitting checking two business days later

2024-06-01 Thread Michael or Penny Novack

On 6/1/2024 4:39 PM, David G. Pickett via gnucash-user wrote:

I like to record my checks written on the day they were written, not cashed, 
but am frustrated that then I cannot check when they cleared!


Well technically should be recorded when delivered, with delivered 
meaning "constructively delivered" << when you mail them >> You should 
NOT be tracking "float". Legally that money isn't yours any more even 
though sitting in your bank account until the check clears. The reason 
that just WRITING the check (that date) has no meaning is until you send 
it, could just change your mind and rip it up. But as many do, I use the 
date written even though might not be be immediately picked up by the PO 
<< say I put in the mailbox after collection on Saturday and Monday is a 
Federal holiday -- won't get postmarked till Tuesday at the earliest -- 
the postmark date has legal significance >>


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] Need help with eBay - tagging multiple sales into one payout hitting checking two business days later

2024-06-01 Thread David Cousens
David,

AFAIK the reconcile "R" column has three settings ,"n","c","y". If you
manually record a transaction it should be set at "n". The "c" setting
indicates that a transaction has been cleared and can be set to this
when for example the money either appears in your account or when it
has been taken out of your account. It is set to "y" when you do a
reconciliation against a statement.

David Cousens
 

On Sat, 2024-06-01 at 20:39 +, David G. Pickett via gnucash-user
wrote:
> I like to record my checks written on the day they were written, not
> cashed, but am frustrated that then I cannot check when they
> cleared!  Float is nice, especially if you get interest, but not
> something I bank on!  :D  Similarly, one bank puts a 3 day hold on
> transfers, so the money goes out one day and shows up in the other
> account 3-5 days later!  Maybe another field would be nice?  I don't
> want to create a limbo account and two transactions to hold the value
> when it is floating!
> ___
> 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] Need help with eBay - tagging multiple sales into one payout hitting checking two business days later

2024-06-01 Thread David G. Pickett via gnucash-user
I like to record my checks written on the day they were written, not cashed, 
but am frustrated that then I cannot check when they cleared!  Float is nice, 
especially if you get interest, but not something I bank on!  :D  Similarly, 
one bank puts a 3 day hold on transfers, so the money goes out one day and 
shows up in the other account 3-5 days later!  Maybe another field would be 
nice?  I don't want to create a limbo account and two transactions to hold the 
value when it is floating!
___
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] Adding ASSETS & LIABILITIES to sub accounts

2024-06-01 Thread David G. Pickett via gnucash-user
I was recently feeling a similar vibe as I had income taxes in expenses and 
refunds in income, but they are really algebraically the same thing of opposite 
sign until you get into US tax code of itemized deductions making them 
different.  The tax report does somewhat marry them back together.  As I am a 
standard deduction guy for the last few years, I forget the exact place it 
binds you up, maybe state/city tax refunds and itemization.
___
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] Adding ASSETS & LIABILITIES to sub accounts

2024-06-01 Thread David G. Pickett via gnucash-user
In the realm of enhancement suggestions, if there was a special top level 
folder of named sets of books, and each named set of books could have its own 
income, expense, equity, assets, liabilities.  Then you could work a hierarchy 
of books in one gnucash instance.
The entries in those books could even be shadowed by being linked into the 
master folders of income, expense, equity, assets, liabilities (rather like 
hard links in files -- changing either changes both), with reports knowing they 
should run in one tree or the other to avoid doubling items.  The xml world 
would record them in the folder of books but the xml to C++ loader would know 
to also link the transactions to the master set of folders.

Reports might even run on the entire folder of books, preceding the report on 
each set of books with a header in the report.

Alternatively, gnucash could have a way to include multiple gnucash instances 
by reference into a parent instance, with the reporting behaviors described 
above.  When loading the parent instance, the trans in every child would be 
linked also into the parent income, expense, equity, asset, liability folders.  
Gnucash in the children would not change, but all the new behaviors are tied to 
working in a parent folder.  It begs the idea of a grandparent folder, i. e., 
unlimited levels of hierarchy, with a hierarchy of headers and subtotals in 
reports.  And it imposes/suggests the idea that all transactions have to be in 
'leaf' books, either a feature or a problem.
No idea how these might be kept separate in an RDBMS supported instance, but 
let's assume a separate schema for each 'leaf' set of books.
___
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] Problem with New Account Creation

2024-06-01 Thread Bruno Barros
Seems like an uninstall (used revo to remove any registry entries related
to GnuCash and remnant files) and re-install has solved the problem. Guess
I could have tried that to begin with. Thanks for everyone's help! Problem
solved.

On Sat, Jun 1, 2024 at 12:53 PM Ken Pyzik  wrote:

> One more thing to try.  It is possible that your version of GNUcash got
> stepped-on by something else.  If all other troubleshooting to this point
> has failed, de-install the version you have – and them re-install the
> latest version from SorgeForce or wherever you get your latest versions.
> Upon re-installation – see if the same behavior exists
>
>
>
> Ken
>
>
>
> *From:* Bruno Barros 
> *Sent:* Saturday, June 1, 2024 9:47 AM
> *To:* Ken Pyzik 
> *Cc:* sunfis...@yahoo.com; Gnucash Users 
> *Subject:* Re: [GNC] Problem with New Account Creation
>
>
>
> The context menu was a great idea. Hadn't thought of that. I had changed
> the registry to revert to the old windows context menu so thought maybe it
> was related to that. However, when I reverted back to the new context menu,
> it did not resolve the issue.
>
> Currently updating finance:quote but I doubt it's that. I've had
> finance:quote installed for a while now and it never messed with GnuCash
> before.
>
>
>
> Wondering if there may be some other context menu hide registry entry.
>
>
>
> On Sat, Jun 1, 2024 at 12:02 PM Ken Pyzik  wrote:
>
> I am currently running Win 11 Build 5.6 and have no issue with the new
> account option:
>
>
>
>
>
> When I click on “NEW”; the new account menu opens and a new accounts can
> be added with no issue.   One difference - I do NOT have finance quote
> installed.
>
>
>
> I suspect that the window is being hidden on you for some reason.  Try
> rebooting your machine and starting from scratch and see if you see the
> same behavior.  If you still have the same behavior, then your registry may
> have a setting that is telling windows to hide the context menu – or the
> finance quote may have overwritten something (just a couple of thoughts).
>
>
>
> Also, see if any other apps demonstrate the same behavior.  If they do –
> google search Context Menu hidden and see if that helps.  These are only my
> personal suggestions.  Hope they help.
>
>
>
> Ken
>
>
>
>
>
>
>
> -Original Message-
> From: gnucash-user 
> On Behalf Of Bruno Barros
> Sent: Saturday, June 1, 2024 8:44 AM
> To: sunfis...@yahoo.com
> Cc: Peter Cuthbert via gnucash-user 
> Subject: Re: [GNC] Problem with New Account Creation
>
>
>
> I do have multiple screens and I thought that at first. But not showing up
> on that screen either. Plus on the taskbar only the main GnuCash window is
> showing.
>
>
>
> On Sat, Jun 1, 2024 at 11:40 AM sunfis...@yahoo.com 
>
> wrote:
>
>
>
> > Multiple screens?
>
> >
>
> > ⁣David T.​
>
> >
>
> > On Jun 1, 2024, 6:30 PM, at 6:30 PM, Bruno Barros 
>
> > wrote:
>
> > >Recently starting having trouble creating new accounts. When I right
>
> > >click and select the New Account option, GnuCash "flashes" (as if the
>
> > >GnuCash window is getting selected and then deselected) but no pop up
>
> > >appears to create the account.
>
> > >I'm on the latest 5.6 version
>
> > >
>
> > >Win 11
>
> > >Build ID: 5.6+ (2024-03-30)
>
> > >Also have finance quote 1.59 installed
>
> > >
>
> > >Thanks in advance for any help or ideas of what might be the cause.
>
> > >___
>
> > >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] Problem with New Account Creation

2024-06-01 Thread Ken Pyzik
One more thing to try.  It is possible that your version of GNUcash got 
stepped-on by something else.  If all other troubleshooting to this point has 
failed, de-install the version you have – and them re-install the latest 
version from SorgeForce or wherever you get your latest versions.  Upon 
re-installation – see if the same behavior exists

Ken

From: Bruno Barros 
Sent: Saturday, June 1, 2024 9:47 AM
To: Ken Pyzik 
Cc: sunfis...@yahoo.com; Gnucash Users 
Subject: Re: [GNC] Problem with New Account Creation

The context menu was a great idea. Hadn't thought of that. I had changed the 
registry to revert to the old windows context menu so thought maybe it was 
related to that. However, when I reverted back to the new context menu, it did 
not resolve the issue.
Currently updating finance:quote but I doubt it's that. I've had finance:quote 
installed for a while now and it never messed with GnuCash before.

Wondering if there may be some other context menu hide registry entry.

On Sat, Jun 1, 2024 at 12:02 PM Ken Pyzik 
mailto:py...@outlook.com>> wrote:

I am currently running Win 11 Build 5.6 and have no issue with the new account 
option:



[cid:image001.png@01DAB409.9989C820]



When I click on “NEW”; the new account menu opens and a new accounts can be 
added with no issue.   One difference - I do NOT have finance quote installed.



I suspect that the window is being hidden on you for some reason.  Try 
rebooting your machine and starting from scratch and see if you see the same 
behavior.  If you still have the same behavior, then your registry may have a 
setting that is telling windows to hide the context menu – or the finance quote 
may have overwritten something (just a couple of thoughts).



Also, see if any other apps demonstrate the same behavior.  If they do – google 
search Context Menu hidden and see if that helps.  These are only my personal 
suggestions.  Hope they help.



Ken







-Original Message-
From: gnucash-user 
mailto:outlook@gnucash.org>>
 On Behalf Of Bruno Barros
Sent: Saturday, June 1, 2024 8:44 AM
To: sunfis...@yahoo.com<mailto:sunfis...@yahoo.com>
Cc: Peter Cuthbert via gnucash-user 
mailto:gnucash-user@gnucash.org>>
Subject: Re: [GNC] Problem with New Account Creation



I do have multiple screens and I thought that at first. But not showing up on 
that screen either. Plus on the taskbar only the main GnuCash window is showing.



On Sat, Jun 1, 2024 at 11:40 AM sunfis...@yahoo.com<mailto:sunfis...@yahoo.com> 
mailto:sunfis...@yahoo.com>>

wrote:



> Multiple screens?

>

> ⁣David T.​

>

> On Jun 1, 2024, 6:30 PM, at 6:30 PM, Bruno Barros 
> mailto:cho...@gmail.com>>

> wrote:

> >Recently starting having trouble creating new accounts. When I right

> >click and select the New Account option, GnuCash "flashes" (as if the

> >GnuCash window is getting selected and then deselected) but no pop up

> >appears to create the account.

> >I'm on the latest 5.6 version

> >

> >Win 11

> >Build ID: 5.6+ (2024-03-30)

> >Also have finance quote 1.59 installed

> >

> >Thanks in advance for any help or ideas of what might be the cause.

> >___

> >gnucash-user mailing list

> >gnucash-user@gnucash.org<mailto: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<mailto: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] Problem with New Account Creation

2024-06-01 Thread Bruno Barros
The context menu was a great idea. Hadn't thought of that. I had changed
the registry to revert to the old windows context menu so thought maybe it
was related to that. However, when I reverted back to the new context menu,
it did not resolve the issue.
Currently updating finance:quote but I doubt it's that. I've had
finance:quote installed for a while now and it never messed with GnuCash
before.

Wondering if there may be some other context menu hide registry entry.

On Sat, Jun 1, 2024 at 12:02 PM Ken Pyzik  wrote:

> I am currently running Win 11 Build 5.6 and have no issue with the new
> account option:
>
>
>
>
>
> When I click on “NEW”; the new account menu opens and a new accounts can
> be added with no issue.   One difference - I do NOT have finance quote
> installed.
>
>
>
> I suspect that the window is being hidden on you for some reason.  Try
> rebooting your machine and starting from scratch and see if you see the
> same behavior.  If you still have the same behavior, then your registry may
> have a setting that is telling windows to hide the context menu – or the
> finance quote may have overwritten something (just a couple of thoughts).
>
>
>
> Also, see if any other apps demonstrate the same behavior.  If they do –
> google search Context Menu hidden and see if that helps.  These are only my
> personal suggestions.  Hope they help.
>
>
>
> Ken
>
>
>
>
>
>
>
> -Original Message-
> From: gnucash-user 
> On Behalf Of Bruno Barros
> Sent: Saturday, June 1, 2024 8:44 AM
> To: sunfis...@yahoo.com
> Cc: Peter Cuthbert via gnucash-user 
> Subject: Re: [GNC] Problem with New Account Creation
>
>
>
> I do have multiple screens and I thought that at first. But not showing up
> on that screen either. Plus on the taskbar only the main GnuCash window is
> showing.
>
>
>
> On Sat, Jun 1, 2024 at 11:40 AM sunfis...@yahoo.com 
>
> wrote:
>
>
>
> > Multiple screens?
>
> >
>
> > ⁣David T.​
>
> >
>
> > On Jun 1, 2024, 6:30 PM, at 6:30 PM, Bruno Barros 
>
> > wrote:
>
> > >Recently starting having trouble creating new accounts. When I right
>
> > >click and select the New Account option, GnuCash "flashes" (as if the
>
> > >GnuCash window is getting selected and then deselected) but no pop up
>
> > >appears to create the account.
>
> > >I'm on the latest 5.6 version
>
> > >
>
> > >Win 11
>
> > >Build ID: 5.6+ (2024-03-30)
>
> > >Also have finance quote 1.59 installed
>
> > >
>
> > >Thanks in advance for any help or ideas of what might be the cause.
>
> > >___
>
> > >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] Problem with New Account Creation

2024-06-01 Thread Ken Pyzik
I am currently running Win 11 Build 5.6 and have no issue with the new account 
option:



[cid:image001.png@01DAB402.2DC30220]



When I click on “NEW”; the new account menu opens and a new accounts can be 
added with no issue.   One difference - I do NOT have finance quote installed.



I suspect that the window is being hidden on you for some reason.  Try 
rebooting your machine and starting from scratch and see if you see the same 
behavior.  If you still have the same behavior, then your registry may have a 
setting that is telling windows to hide the context menu – or the finance quote 
may have overwritten something (just a couple of thoughts).



Also, see if any other apps demonstrate the same behavior.  If they do – google 
search Context Menu hidden and see if that helps.  These are only my personal 
suggestions.  Hope they help.



Ken







-Original Message-
From: gnucash-user  On 
Behalf Of Bruno Barros
Sent: Saturday, June 1, 2024 8:44 AM
To: sunfis...@yahoo.com
Cc: Peter Cuthbert via gnucash-user 
Subject: Re: [GNC] Problem with New Account Creation



I do have multiple screens and I thought that at first. But not showing up on 
that screen either. Plus on the taskbar only the main GnuCash window is showing.



On Sat, Jun 1, 2024 at 11:40 AM sunfis...@yahoo.com<mailto:sunfis...@yahoo.com> 
mailto:sunfis...@yahoo.com>>

wrote:



> Multiple screens?

>

> ⁣David T.​

>

> On Jun 1, 2024, 6:30 PM, at 6:30 PM, Bruno Barros 
> mailto:cho...@gmail.com>>

> wrote:

> >Recently starting having trouble creating new accounts. When I right

> >click and select the New Account option, GnuCash "flashes" (as if the

> >GnuCash window is getting selected and then deselected) but no pop up

> >appears to create the account.

> >I'm on the latest 5.6 version

> >

> >Win 11

> >Build ID: 5.6+ (2024-03-30)

> >Also have finance quote 1.59 installed

> >

> >Thanks in advance for any help or ideas of what might be the cause.

> >___

> >gnucash-user mailing list

> >gnucash-user@gnucash.org<mailto: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<mailto: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] Problem with New Account Creation

2024-06-01 Thread Bruno Barros
I do have multiple screens and I thought that at first. But not showing up
on that screen either. Plus on the taskbar only the main GnuCash window is
showing.

On Sat, Jun 1, 2024 at 11:40 AM sunfis...@yahoo.com 
wrote:

> Multiple screens?
>
> ⁣David T.​
>
> On Jun 1, 2024, 6:30 PM, at 6:30 PM, Bruno Barros 
> wrote:
> >Recently starting having trouble creating new accounts. When I right
> >click
> >and select the New Account option, GnuCash "flashes" (as if the GnuCash
> >window is getting selected and then deselected) but no pop up appears
> >to
> >create the account.
> >I'm on the latest 5.6 version
> >
> >Win 11
> >Build ID: 5.6+ (2024-03-30)
> >Also have finance quote 1.59 installed
> >
> >Thanks in advance for any help or ideas of what might be the cause.
> >___
> >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] Problem with New Account Creation

2024-06-01 Thread sunfish62--- via gnucash-user
Multiple screens?

⁣David T.​

On Jun 1, 2024, 6:30 PM, at 6:30 PM, Bruno Barros  wrote:
>Recently starting having trouble creating new accounts. When I right
>click
>and select the New Account option, GnuCash "flashes" (as if the GnuCash
>window is getting selected and then deselected) but no pop up appears
>to
>create the account.
>I'm on the latest 5.6 version
>
>Win 11
>Build ID: 5.6+ (2024-03-30)
>Also have finance quote 1.59 installed
>
>Thanks in advance for any help or ideas of what might be the cause.
>___
>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] Adding ASSETS & LIABILITIES to sub accounts

2024-06-01 Thread Michael or Penny Novack

I doubt it. If they are all reported as part of the one tax return they are
enterprises rather than entities. Entity finances are normally kept
separate with separate tax returns, bank accounts and cashbook files
(despite what can be done).


How reported on taxes not a factor on whether multiple sets of books kept.

Remember, I go back to the days of pen and ink on paper. Subsidiary sets 
of books not unusual. There might be "petty cash" (which might even have 
ts own bank account), a "cash book"  (and perhaps a physical cash box) , 
etc. The TOTALS from these subsidiary books  ended up in the main 
ledger, and THAT from where taxes figured, etc. (the subsidiary books 
not involved with tax filings, etc.)


However -- today, those who wanted multiple sets of books so as to make 
easy separating enterprises << by treating as entities >> probably would 
want to skip that step as unfamiliar with the work flow process of 
formally "closing" into the main ledger. Easier to just total outside of 
gnucash. Since I usually advocate for "formal" this might surprise you, 
but I'd think doing it "right" would definitely require finding a text 
that provided examples << say how a petty cash set of books connected to 
the main ledger; usually done each time the petty cash fund was 
refreshed* >> Seeing it done for one sort of subsidiary books would 
guide for other sorts.


LOL -- you can even use gnucash to track a VIRTUAL entity. For example, 
I wanted to track our solar system << how long did it take to pay itself 
off >> figured correctly, time value of money, affect on our property 
insurance premium, taxes it made us liable for, etc. The easiest way was 
to treat the solar system as if it were an entity operating on borrowed 
capital (borrowed from us), paying off this loan by getting tax credits 
for us, selling SRECs for us, paying our electric bill, etc.  << at the 
present time, paid off, so accumulating a virtual "repair and 
replacement fund".


Michael D Novack

* If done THEN (when being "refreshed") the total of debits and credits 
going to main books and to the petty cash fund will be the same -- the 
amount needed to refresh the petty cash fund to its original amount is 
the total of expenses since the last time. In other words, the same 
transaction in both main books and petty cash books except debits and 
credits reversed.



___
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] Adding ASSETS & LIABILITIES to sub accounts

2024-06-01 Thread Paras Desai
Hello David,

Oh yes, my mistake 﫢
thanks for correcting !

Best regards

Paras


01-Jun-2024 11:53:59 am sunfis...@yahoo.com<mailto:sunfis...@yahoo.com>:

Thanks for the insights. For the record, the app you're intending to reference 
is "skrooge" not "skoorage".

David T.
On Jun 1, 2024, at 8:20 AM, Paras Desai 
mailto:desaipa...@outlook.com>> wrote:

On 31-05-2024 20:46, 
gnucash-user-requ...@gnucash.org<mailto:gnucash-user-requ...@gnucash.org> wrote:
 Re: [GNC] Adding ASSETS & LIABILITIES to sub accounts


My two cent on the topic 

Before I zeroed in to GNU Cash for my personal finance accounting, I
evaluated many open source softwares like Money manager Ex, Skoorage,
Kmymoney and likes and eventually I decided to settle in GNC for
multiple reasons.

However, I remember one feature (either in skoorage or Kmymoney), which
has a feature of grouping Chart of Accounts (COA) Institution wise.

While posting the transaction, one can select the Institution and
transaction flows in that institution. While generating report, one can
generate report for all Institutions or for an individual institution.

Now, this “Institution” can be an either a family member, or a company
or a company business division.

This feature is very relevant, if one wishes to monitor family finance
along with individual finance, or separate business line finance.

So configuration can be like Family (All Institutions)-->
Institution1(family Member 1) + Institution2(Family member2) and so on.

GNC manages accounts as an individual file. So, to achieve above, if a
report can be developed to combine multiple files (Accounts) to generate
a report !

Of course, this is a suggestion of a layman, without giving cognizance
to the technicality involved and basic software structure of the GNC and
limitations.

I just thought of sharing this idea, when I came across the discussion
on the topic.

With my best regards


Paras





gnucash-user mailing list
gnucash-user@gnucash.org<mailto: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] Adding ASSETS & LIABILITIES to sub accounts

2024-06-01 Thread sunfish62--- via gnucash-user
Thanks for the insights. For the record, the app you're intending to reference 
is "skrooge" not "skoorage".

⁣David T. ​

On Jun 1, 2024, 8:20 AM, at 8:20 AM, Paras Desai  wrote:
>
>On 31-05-2024 20:46, gnucash-user-requ...@gnucash.org wrote:
>> Re: [GNC] Adding ASSETS & LIABILITIES to sub accounts
>
>
>My two cent on the topic 
>
>Before I zeroed in to GNU Cash for my personal finance accounting, I 
>evaluated many open source softwares like Money manager Ex, Skoorage, 
>Kmymoney and likes and eventually I decided to settle in GNC for 
>multiple reasons.
>
>However, I remember one feature (either in skoorage or Kmymoney), which
>
>has a feature of grouping Chart of Accounts (COA) Institution wise.
>
>While posting the transaction, one can select the Institution and 
>transaction flows in that institution. While generating report, one can
>
>generate report for all Institutions or for an individual institution.
>
>Now, this “Institution” can be an either a family member, or a company 
>or a company business division.
>
>This feature is very relevant, if one wishes to monitor family finance 
>along with individual finance, or separate business line finance.
>
>So configuration can be like Family (All Institutions)--> 
>Institution1(family Member 1) + Institution2(Family member2) and so on.
>
>GNC manages accounts as an individual file. So, to achieve above, if a 
>report can be developed to combine multiple files (Accounts) to
>generate 
>a report !
>
>Of course, this is a suggestion of a layman, without giving cognizance 
>to the technicality involved and basic software structure of the GNC
>and 
>limitations.
>
>I just thought of sharing this idea, when I came across the discussion 
>on the topic.
>
>With my best regards
>
>
>Paras
>
>
>
>___
>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] Adding ASSETS & LIABILITIES to sub accounts

2024-05-31 Thread Paras Desai


On 31-05-2024 20:46, gnucash-user-requ...@gnucash.org wrote:

Re: [GNC] Adding ASSETS & LIABILITIES to sub accounts



My two cent on the topic 

Before I zeroed in to GNU Cash for my personal finance accounting, I 
evaluated many open source softwares like Money manager Ex, Skoorage, 
Kmymoney and likes and eventually I decided to settle in GNC for 
multiple reasons.


However, I remember one feature (either in skoorage or Kmymoney), which 
has a feature of grouping Chart of Accounts (COA) Institution wise.


While posting the transaction, one can select the Institution and 
transaction flows in that institution. While generating report, one can 
generate report for all Institutions or for an individual institution.


Now, this “Institution” can be an either a family member, or a company 
or a company business division.


This feature is very relevant, if one wishes to monitor family finance 
along with individual finance, or separate business line finance.


So configuration can be like Family (All Institutions)--> 
Institution1(family Member 1) + Institution2(Family member2) and so on.


GNC manages accounts as an individual file. So, to achieve above, if a 
report can be developed to combine multiple files (Accounts) to generate 
a report !


Of course, this is a suggestion of a layman, without giving cognizance 
to the technicality involved and basic software structure of the GNC and 
limitations.


I just thought of sharing this idea, when I came across the discussion 
on the topic.


With my best regards


Paras



___
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] Need help with eBay - tagging multiple sales into one payout hitting checking two business days later

2024-05-31 Thread David Cousens
Bruce.
There should be no problem just adding additional lines for each sale
and shipping label purchase and fee transaction to the single
transaction with the debit entry to your check account being the payout
figure. 

Alternatively if you have the gross amount of each sale available you
can calculate what you receive from each sale and could post each
individual sale as a transaction and instead of debiting your cheque
account, debit an accounts receivable account. When you record the
transaction for Ebay's payment to you at the end of the day, you credit
the accounts receivable and then debit your cheque account. The amounts
should match.

What is more appropraite will depend on your reporting requirements and
taxation legislation. This is where you need your local accountant.

David Cousens

On Fri, 2024-05-31 at 10:25 -0400, Bruce Griffis wrote:
> I’m looking for help in figuring out GnuCash for a small eBay
> reseller, 
> basically selling items from home, but occasionally purchasing an
> item 
> for resale. I’m looking at this from the perspective of viewing sales
> from the My eBay / Selling / Payments / Total Sales page.
> 
> 
> Under Assets, I have Checking account, Savings account, Cash account
> and 
> eBay Inventory account (I get that GnuCash does not support inventory
> – 
> I just build this using a CSV export from Libre Office Calc). Under 
> liabilities I have a secured credit card.
> 
> 
> Under Income I have eBay Transactions (and I want this to reflect the
> eBay All Transactions page). Under expenses I have eBay Final Value 
> Fees, eBay Shipping Labels and eBay Refunds. I also have standard
> small 
> business chart of accounts to support basics of purchasing boxes,
> bubble 
> wrap, bubble mailers, tape, poly bags, …
> 
> 
> When I look at making just one sale in a day, this approach works
> pretty 
> well:
> 
> On eBay All Transactions I have one entry that gives Date,
> Description 
> (the item that was sold),
> 
> Amount (this is gross amount), Fees (this is eBay Final Value fees),
> Net 
> (the net amount I receive – if I pay shipping (offer free shipping),
> net 
> gets reduced by my shipping label costs), Total Funds.
> 
> 
> I then see a second transaction under All Transactions for the
> purchase 
> of the shipping label. This includes Date, Description, Amount and
> Net. 
> Since Total Amount is the amount in this account before payout, my
> total 
> amount in this account gets modified (it gets reduced by shipping
> label 
> amount).
> 
> 
> I then see a third transaction. The third is my payout. This includes
> Date, Description, Amount and Total Amount. Amount is the dollar
> amount 
> that hits my checking account in two business days. Total Amount is
> the 
> Total in this account (eBay Funds? I need to figure out what to 
> descriptively call it). If I only had one sale in a day and did not
> make 
> any new sales then Total is zero.
> 
> 
> To reflect this, I enter a split transaction.
> 
> I enter the Date, Description and Gross amount for the sale.
> 
> I enter another transaction in the split. This is Date, Description, 
> eBay Final Fees (an expense). This goes into Expense account eBay
> Final 
> Fees.
> 
> I enter another transaction in the split. This is Date, Description, 
> Shipping label cost and goes to eBay Shipping Labels expense account.
> 
> I enter a third transaction. This is my payout. It usually simply 
> matches Imbalance-USD. This goes to my Income account Checking.
> 
> 
> When I look at my checking account, I can match it by the dollar
> amount, 
> but since payouts post in two business days, the date does not match
> up. 
> But it is simple enough to figure out.
> 
> 
> Things get way out of hand when I make multiple sales in one day. I 
> would enter a split transaction for every sale, so if I had four 
> transaction – I would show four split transactions made up of the
> sale, 
> the final value fees, and the shipping label. However – I would only 
> have one payout. So if I take the income from the sale and post it 
> directly to checking, I end up adding 1 of 4, 2 of 4, 3 of 4, … to
> the 
> front of the description field. Then when looking at my checking
> account 
> – I would need to add together each individual transaction to equal
> my 
> payout. Now I am not matching on date (posted two business days
> later) 
> and amount (I need to add individual sales together to correlate with
> the days payout.
> 
> 
> Additionally, Refunds get pulled out of the running eBay Funds
> account 
> (that I need to create in GnuCash). If the funds in that account
> aren’t 
> enough t cover it, the refund comes out of checking as a direct
> debit.
> 
> Any recommendations on how I would show multiple sales in a day
> making 
> up one entry into my checking account? Do I need another account –
> send 
> my payouts there. Then group multiples in another split (if I can do 
> that?) to show the days transactions? Or do I need to think about
> doing 
> an 

Re: [GNC] Need help with eBay - tagging multiple sales into one payout hitting checking two business days later

2024-05-31 Thread Jim DeLaHunt

Bruce:

Welcome to GnuCash, congratulations on the eBay business, and I hope it 
goes well for you.


It sounds like your question is not about GnuCash, it is about 
accounting. Once you know how the information should get tracked as an 
accounting matter, it will be straightforward to explain how to record 
that information using GnuCash as the recording tool.


Do you have an accountant advising you?  If so, ask them for their 
advice about how to record this information.  Have you read an 
introductory accounting textbook?  If not, maybe this is a good time for 
that learning.


You say,

…Under Income I have eBay Transactions (and I want this to reflect the 
eBay All Transactions page).…


From what you describe, this sounds to me like it should be an Asset, 
not Income. It is something like Accounts Receivable from eBay. The eBay 
All Transactions page as you describe it lists a sale, where eBay starts 
to owe you money, then a deduction for cost of sales, where eBay reduces 
the amount they owe you, then a payout, where eBay reduces what they owe 
you to zero by sending you money. So: it sounds to me like the type of 
this account should be Asset, not Income.


…Things get way out of hand when I make multiple sales in one day. I 
would enter a split transaction for every sale, so if I had four 
transaction – I would show four split transactions made up of the 
sale, the final value fees, and the shipping label. However – I would 
only have one payout. So if I take the income from the sale and post 
it directly to checking, I end up adding 1 of 4, 2 of 4, 3 of 4, … to 
the front of the description field. Then when looking at my checking 
account – I would need to add together each individual transaction to 
equal my payout.…
It sounds like you should be entering only one transaction from the eBay 
Accounts Receivable account to the chequing account, to correspond to 
the one payout per day. There is no need to make a transaction between 
these two accounts for each eBay sale. The amount of the one daily 
transaction equals the amount of the eBay payout, and the amount which 
arrives in your chequing account.


Note that the balance in your eBay Accounts Receivable account starts at 
zero each day, increases as eBay makes sales, decreases as eBay charges 
you fees, then drop to zero when eBay makes the daily payout.


…When I look at my checking account, I can match it by the dollar 
amount, but since payouts post in two business days, the date does not 
match up. But it is simple enough to figure out.… 
In my finances, it is completely normal for a transaction to take 
multiple days to play out, so the statements from various parties to the 
transaction will have different dates.  For instance, I pay a store by 
credit card on May 1st. When I get my credit card statement, it has two 
dates for the transaction: transaction date, and posting date.  The 
transaction date is May 3rd, because the store did not report the sale 
to the credit card company for a little while.  The posting date is May 
4th, because the credit card company also took a little time to process 
the transaction.


GnuCash only has one date field per transaction, so I choose one of 
those three transaction dates as the representative date to record in 
GnuCash.


It is possible to enter multiple GnuCash transactions to record the 
separate steps and the time delay in transactions, but I almost never 
find it worth the bother.


Does this answer your question?
  —Jim DeLaHunt


On 2024-05-31 10:25, Bruce Griffis wrote:
I’m looking for help in figuring out GnuCash for a small eBay 
reseller, basically selling items from home, but occasionally 
purchasing an item for resale. I’m looking at this from the 
perspective of viewing sales from the My eBay / Selling / Payments / 
Total Sales page.



Under Assets, I have Checking account, Savings account, Cash account 
and eBay Inventory account (I get that GnuCash does not support 
inventory – I just build this using a CSV export from Libre Office 
Calc). Under liabilities I have a secured credit card.



Under Income I have eBay Transactions (and I want this to reflect the 
eBay All Transactions page). Under expenses I have eBay Final Value 
Fees, eBay Shipping Labels and eBay Refunds. I also have standard 
small business chart of accounts to support basics of purchasing 
boxes, bubble wrap, bubble mailers, tape, poly bags, …



When I look at making just one sale in a day, this approach works 
pretty well:


On eBay All Transactions I have one entry that gives Date, Description 
(the item that was sold),


Amount (this is gross amount), Fees (this is eBay Final Value fees), 
Net (the net amount I receive – if I pay shipping (offer free 
shipping), net gets reduced by my shipping label costs), Total Funds.



I then see a second transaction under All Transactions for the 
purchase of the shipping label. This includes Date, Description, 
Amount and Net. Since Total Amount is the amount 

Re: [GNC] Adding ASSETS & LIABILITIES to sub accounts

2024-05-31 Thread Michael or Penny Novack
You aren't going to be happy with the answer. Well, part it. See, 
without realizing it, you are asking for TWO things:
1) Can I have these multiple "entities" in one set of books, be able to 
have, for example, assets for entity one, assets for entity two, etc.
 The answer to THAT question is yes, and you can run reports 
selecting just the accounts related to each entity in the report for 
that entity.
2) Can I show these grouped by entity instead of all the asset accounts 
together (under assets), all the liability accounts (under liabilities), 
etc.
 The answer to THAT question is no. If all in one CoA then have to 
follow the rules for how a CoA is organized. That's not specifically a 
gnucash thing.


This is a tradeoff situation related to work flow, which you decide is 
easier. Keep in one set of books but have a lot more work setting up the 
reports with account inclusion/exclusion for each entity. Or Keep in 
separate books and now the reports are simple default (since that CoA 
has only accounts of that entity) and have the work of adding up the 
totals from the Balance Sheets (etc.) of all entities.


Michael D Novack

PS --- If you are new to double entry bookkeeping I strongly suggest the 
"separate books" option since each will be simpler to set up, more 
closely follow examples, and the task of adding up the corresponding 
pieces (of each entity) is straightforward. Also a factor to consider, 
if you are keeping all in one set of books there is an error you could 
make that gnucash would not catch for you << no double entry software 
would, since the fundamental rules of double entry not violated by this 
mistake >> You COULD accidentally enter a transaction belonging to 
entity one in accounts of entity two, even partly in one and partly in 
another. And it's really not if you will do this but when you will make 
a mistake of that sort. Finding/correcting an error of that sort not 
going to be easy.


PPS --- Those of us whose experience goes back to the days of pen and 
ink on paper will probably know how to have "subsidiary books" and how 
the totals of such subsidiary books enter the main set of books. In 
other words, you COULD have separate sets of books and then a "main" set 
of books, the reports from which would give you the totals. I suggest 
not trying this unless with the guidance of a text that deals with 
things like "petty cash", "sales", etc. which might have subsidiary sets 
of books connected to a main set of books.




On 5/30/2024 1:31 AM, Luis Sini wrote:

TL;DR
+
I would like to add "ASSETS" and "LIABILITIES" account types as
sub-accounts but GnuCash only allows it if they are "Top Level Accounts"
+
Hello to everyone,
I make money personally, I own a couple of properties, and I also design
and manufacture audio devices. These are basically different entities, and
I know that I can create a separate GnuCash file for each one of those
ventures. But, I wanted to create 1 GnuCash file that will allow me to have
a comprehensive view of all my financial activities while being able to
track each venture separately.

I've gone ahead and created the following structure:

1. PERSONAL WORK
   1. INCOME
   2. EXPENSES
2. PROPERTIES
   1. PROPERTY A
  1. INCOME
  2. EXPENSES
   2. PROPERTY B
  1. INCOME
  2. EXPENSES
   3. AUDIO DEVICES
   1. INCOME
   2. EXPENSES

What I would like to do is add "ASSETS" and "LIABILITIES" sub-accounts to
"PERSONAL WORK" and each of the "PROPERTIES". Unfortunately, GnuCash only
allows me to assign sub-accounts types as either "Income" or "Expense"
unless the parent account is not set up as either Assets or Liability? I
can make an account an "Asset" or "Liability" if the account is a "Top
Level Account". Is there any way to get around this limitation?

Thanks in advance.

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



--
There is no possibility of social justice on a dead planet except the equality 
of the grave.

___
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] Adding ASSETS & LIABILITIES to sub accounts

2024-05-31 Thread Maf. King
Hi Luis,

Welcome to GnuCash!

On Friday, 31 May 2024 06:09:12 BST Luis Sini wrote:
> Dear Jim,

> Since GnuCash is open source, i was wondering how members are able to
> contribute to it? Who adds features and make changes to the software. Im
> not a programmer, but perhaps i could find someonw that could work on
> making changes for me.

There is a core team of develpoers who wrtie the code and fix the bugs.  their 
time is very limited.  Some others help out by writing/updating docs, or add 
to the wiki and FAQ.  others just answer on here if they have knowledge that 
fits.  Anyone can report bugs, of course.  There's a link somewhere on the GC 
website for $ donatinos, too, I think.

> 
> Although, your solution is something that i have thought of, im wondering
> how difficult would it be to add 1 more account type to the software that
> made that account be ble to have any type under it. Similar to the top
> level accounts.

Jim's solution makes sense to me.  Use the reports to report on what you need.  
GC is quite strict about being a "formal accounting" program, and I think 
you'll struggle to get developer support to make that change to account types.

> 
> I was surprised to find that there is no user group for GnuCash. I'd figure
> that may be a way for people to ask questions in a forum which may allow
> > people to search previous topics and such.

This email list is the "user group".  GC has been around for a very long time, 
pretty much predating "social media", and this email group is still the formal 
way to ask user-level questions.  All the archives exist and can be read, it 
may just be a slightly different way that you expected, and hard to search for 
a variety of reasons!  I think the specific site: search trick has been killed 
by google, for example (but still works on duckduckgo).



good luck!
Maf.




___
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] Adding ASSETS & LIABILITIES to sub accounts

2024-05-31 Thread Luis Sini
Dear Jim,

Thank you so very much for taking the time to answer my questions.

Since GnuCash is open source, i was wondering how members are able to
contribute to it? Who adds features and make changes to the software. Im
not a programmer, but perhaps i could find someonw that could work on
making changes for me.

Although, your solution is something that i have thought of, im wondering
how difficult would it be to add 1 more account type to the software that
made that account be ble to have any type under it. Similar to the top
level accounts.

I was surprised to find that there is no user group for GnuCash. I'd figure
that may be a way for people to ask questions in a forum which may allow
people to search previous topics and such.

And please forgive me if any of this has been discussed already. I
certainly do not want to be a troublemaker. Just wondering how i can
contribute and perhaps help people.

Thank you again,

Luis Sinibaldi

On Thu, May 30, 2024, 9:50 PM Jim DeLaHunt  wrote:

> Luis:
>
> Welcome to GnuCash! You ask a good question.
>
> On 2024-05-30 01:31, Luis Sini wrote:
> > TL;DR
> > +
> > I would like to add "ASSETS" and "LIABILITIES" account types as
> > sub-accounts but GnuCash only allows it if they are "Top Level Accounts"
> > +
> > Hello to everyone,
> > I make money personally, I own a couple of properties, and I also design
> > and manufacture audio devices. These are basically different entities,
> and
> > I know that I can create a separate GnuCash file for each one of those
> > ventures. But, I wanted to create 1 GnuCash file that will allow me to
> have
> > a comprehensive view of all my financial activities while being able to
> > track each venture separately.
> >
> > I've gone ahead and created the following structure:
> >
> > 1. PERSONAL WORK
> >1. INCOME
> >2. EXPENSES
> > 2. PROPERTIES
> >1. PROPERTY A
> >   1. INCOME
> >   2. EXPENSES
> >2. PROPERTY B
> >   1. INCOME
> >   2. EXPENSES
> >3. AUDIO DEVICES
> >1. INCOME
> >2. EXPENSES
> >
> > What I would like to do is add "ASSETS" and "LIABILITIES" sub-accounts to
> > "PERSONAL WORK" and each of the "PROPERTIES". Unfortunately, GnuCash only
> > allows me to assign sub-accounts types as either "Income" or "Expense"
> > unless the parent account is not set up as either Assets or Liability? I
> > can make an account an "Asset" or "Liability" if the account is a "Top
> > Level Account". Is there any way to get around this limitation?
>
> I do not know a way around the limitation that GnuCash places on the
> types of accounts which can be children of various types of accounts,
> e.g. that an Asset account may not be a child of an Income or Expense
> account.
>
> I face a similar situation with my own bookkeeping. I track assets,
> liabilities, income, and expenses, for my marriage's joint holdings, and
> my personal income, and my spouse's personal income, for my small
> business, and some real estate.  I let GnuCash insist that Assets,
> Liabilities, Equity, Income, and Expenses be top-level accounts. I
> divide into my various joint and personal and business divisions at the
> next level down.
>
> Applying that to your example, your chart of accounts might be:
>
> 1. Assets
> 1.A. Personal Assets
> 1.B. Property Assets
>   1.B.a. Property A Assets
>   1.B.b. Property B Assets
> 1.C. Audio Devices Assets
> 2. Equity
> 2.A. Personal Equity
> 2.B. Property Equity
>   2.B.a. Property A Equity
>   2.B.b. Property B Equity
> 2.C. Audio Devices Equity
> 3. Expenses
> 3.A. Personal Expenses
> 3.B. Property Expenses
>   3.B.a. Property A Expenses
>   3.B.b. Property B Expenses
> 3.C. Audio Devices Expenses
> 4. Income
> 4.A. Personal Income
> 4.B. Property Income
>   4.B.a. Property A Income
>   4.B.b. Property B Income
> 4.C. Audio Devices Income
> 5. Liabilities
> 5.A. Personal Income
> 5.B. Property Income
>   5.B.a. Property A Income
>   5.B.b. Property B Income
> 5.C. Audio Devices Income
>
> I can imagine three objections you might have to this structure.
>
> 1. It is verbose. My structure has 30 lines, while yours has only 13
> lines (or 21 after you add Assets and Liabilities as you propose). I do
> not find that to be a problem. The only time I see all the accounts is
> in the Accounts tab, and most of the time most of the hierarchy is
> collapsed and hidden from view. When I want to enter an account name
> into a transaction, I type portions of the path of account names, and
> GnuCash gives me a menu of the few accounts which match those portions.
>
> 2. It doesn't let you report on a single subtree of the account and
> capture all the income, expenses, assets, and liabilities. I also do not
> find that to be a 

Re: [GNC] Adding ASSETS & LIABILITIES to sub accounts

2024-05-30 Thread Jim DeLaHunt

Luis:

Welcome to GnuCash! You ask a good question.

On 2024-05-30 01:31, Luis Sini wrote:

TL;DR
+
I would like to add "ASSETS" and "LIABILITIES" account types as
sub-accounts but GnuCash only allows it if they are "Top Level Accounts"
+
Hello to everyone,
I make money personally, I own a couple of properties, and I also design
and manufacture audio devices. These are basically different entities, and
I know that I can create a separate GnuCash file for each one of those
ventures. But, I wanted to create 1 GnuCash file that will allow me to have
a comprehensive view of all my financial activities while being able to
track each venture separately.

I've gone ahead and created the following structure:

1. PERSONAL WORK
   1. INCOME
   2. EXPENSES
2. PROPERTIES
   1. PROPERTY A
  1. INCOME
  2. EXPENSES
   2. PROPERTY B
  1. INCOME
  2. EXPENSES
   3. AUDIO DEVICES
   1. INCOME
   2. EXPENSES

What I would like to do is add "ASSETS" and "LIABILITIES" sub-accounts to
"PERSONAL WORK" and each of the "PROPERTIES". Unfortunately, GnuCash only
allows me to assign sub-accounts types as either "Income" or "Expense"
unless the parent account is not set up as either Assets or Liability? I
can make an account an "Asset" or "Liability" if the account is a "Top
Level Account". Is there any way to get around this limitation?


I do not know a way around the limitation that GnuCash places on the 
types of accounts which can be children of various types of accounts, 
e.g. that an Asset account may not be a child of an Income or Expense 
account.


I face a similar situation with my own bookkeeping. I track assets, 
liabilities, income, and expenses, for my marriage's joint holdings, and 
my personal income, and my spouse's personal income, for my small 
business, and some real estate.  I let GnuCash insist that Assets, 
Liabilities, Equity, Income, and Expenses be top-level accounts. I 
divide into my various joint and personal and business divisions at the 
next level down.


Applying that to your example, your chart of accounts might be:

1. Assets
   1.A. Personal Assets
   1.B. Property Assets
     1.B.a. Property A Assets
     1.B.b. Property B Assets
   1.C. Audio Devices Assets
2. Equity
   2.A. Personal Equity
   2.B. Property Equity
 2.B.a. Property A Equity
 2.B.b. Property B Equity
   2.C. Audio Devices Equity
3. Expenses
   3.A. Personal Expenses
   3.B. Property Expenses
 3.B.a. Property A Expenses
 3.B.b. Property B Expenses
   3.C. Audio Devices Expenses
4. Income
   4.A. Personal Income
   4.B. Property Income
 4.B.a. Property A Income
 4.B.b. Property B Income
   4.C. Audio Devices Income
5. Liabilities
   5.A. Personal Income
   5.B. Property Income
 5.B.a. Property A Income
 5.B.b. Property B Income
   5.C. Audio Devices Income

I can imagine three objections you might have to this structure.

1. It is verbose. My structure has 30 lines, while yours has only 13 
lines (or 21 after you add Assets and Liabilities as you propose). I do 
not find that to be a problem. The only time I see all the accounts is 
in the Accounts tab, and most of the time most of the hierarchy is 
collapsed and hidden from view. When I want to enter an account name 
into a transaction, I type portions of the path of account names, and 
GnuCash gives me a menu of the few accounts which match those portions.


2. It doesn't let you report on a single subtree of the account and 
capture all the income, expenses, assets, and liabilities. I also do not 
find that to be a problem. GnuCash custom reports allow you to select 
which accounts to include in the reports. If you want a report for 
Property A, you can define a GnuCash custom report which includes 1.B.a. 
Property A Assets, 2.B.a. Property A Equity, 3.B.a. Property A Expenses, 
4.B.a. Property A Income, 5.B.a. Property A Income and all subaccounts 
of those five accounts.


3. You might not be sure which structure will work for you long-term. 
The good news is that GnuCash lets you move accounts from one parent to 
another within the Accounts tree (subject to its rules about which 
account types can be children of which account types), and all the 
transactions associated with that account follow the account to its new 
home.  You can do even pretty major restructuring of accounts as you go, 
and your records stay intact.


I hope this helps. Good luck with your bookkeeping!
   —Jim DeLaHunt


___
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] Reconciliation Roll Back

2024-05-30 Thread R Losey
I'll add a "me, too" - I had no idea that this was available until I saw it
here.

Very nice!

On Wed, May 29, 2024 at 8:15 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> And I learn something new everyday. Thanks David!
>
> Regards,
> Adrien
>
> On 5/28/24 9:17 AM, David Carlson wrote:
> > A tidbit of information that you may find helpful:  If you hover the
> mouse
> > over the "y" character in the reconcile box in an account split line, the
> > date of the reconciliation for that account split in that transaction
> > appears in a flyover.  It may take a couple of seconds to appear.
>
> ___
> 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] Reconciliation Roll Back (Peter Cuthbert)

2024-05-30 Thread Liz
On Thu, 30 May 2024 12:14:08 +0300
sunfish62--- via gnucash-user  wrote:

> With all due respect, most of the issues raised by Peter are covered
> in some way in section 2.9.4 of the Guide, especially in the notes
> and warnings embedded there. 
> 
> A deeper exploration of the different methods a user can implement to
> recover from some of these more challenging situations might
> appropriately fit on the wiki. 
> 
> ⁣David T.​

I was thinking about recovery from the challenging situations, which
might start with a quote from Douglas Adams "Don't Panic"

Liz
___
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] Reconciliation Roll Back (Peter Cuthbert)

2024-05-30 Thread sunfish62--- via gnucash-user
With all due respect, most of the issues raised by Peter are covered in some 
way in section 2.9.4 of the Guide, especially in the notes and warnings 
embedded there. 

A deeper exploration of the different methods a user can implement to recover 
from some of these more challenging situations might appropriately fit on the 
wiki. 

⁣David T.​

On May 30, 2024, 8:00 AM, at 8:00 AM, Liz  wrote:
>On Wed, 29 May 2024 22:54:26 -0400
>NoobAlice  wrote:
>
>> On 2024-05-29 04:39 PM, Peter Cuthbert via gnucash-user wrote:
>> 
>> > The dates associated with the reconciled/not reconciled flag struck
>> > me as an easy way to do a roll back without using the backups.
>> > Something along the lines of if date = [specified
>> > reconciliation date] then flag = n (I have no idea what
>> > language is used by the developers. ...
>> > So where am I with my data?  I have corrected the £10k which was 
>> > 'swopped' and then gone after the error schrapnel.  Some of that I
>> > have found and corrected but eventually I had to succumb to a
>> > balancing 'fudge it' figure.  With that in place the rest of the
>> > reconciliation was correct to the penny.  
>> 
>> To you and anyone else facing this issue, you can run a transaction 
>> report that shows you a history of of the account with reconciled
>> dates for every transaction.
>> 
>
>Thanks NoobAlice
>that is a really useful tip
>
>Thanks to Peter Cuthbert we've got together some really good tips on
>what happens when a reconciliation goes awry, and I hope that someone
>puts a summary on the wiki.
>
>Liz
>___
>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] Reconciliation Roll Back (Peter Cuthbert)

2024-05-30 Thread G R Hewitt
There is nothing worse than facing a pile of paperwork to input, at the end
of the month - or whatever period of time chosen.
As a sufferer of such I resolved to spend a few minutes entering whatever
had accrued during the day at the end of it - or first thing the next.
The good thing about this is that you can pick up any errors made whilst
they are still fresh in your mind, and it is surprising how quickly this
becomes part
of your daily routine. I heartily recommend it.

On Wed, 29 May 2024 at 21:40, Peter Cuthbert via gnucash-user <
gnucash-user@gnucash.org> wrote:

>
> Hi David, Adam, Derek and everybody who has contributed.
>
> David, your solution is excellent and I suppose it never crossed my mind
> as I had not wholly worked out what all the files GNUCash spews out
> actually do.  I am afraid that using the accounting software is a twice
> monthly chore in which I log all the transaction slip and credit card
> statement and then reconcile against the bank account.  It is almost
> always late in the evening after the day's chores are cleared up and I
> am not really at my brightest.  So I have not been a keen student and
> learned how to make the software fly.
>
> The dates associated with the reconciled/not reconciled flag struck me
> as an easy way to do a roll back without using the backups.  Something
> along the lines of if date = [specified reconciliation date] then
> flag = n (I have no idea what language is used by the developers.
>  I suppose my gripe about the 'Opening Balance' auto figure is probably
> based on many years of using Quicken.  According to my memory one could
> enter both an opening and closing balance, but more recent users can
> tell me if that memoryis incorrect,  Perhaps, for those of us who are
> more in the 'dozy user'category the term Opening balance could perhaps
> have Closing balance at last reconciliation added to it.
>  Have suffered all this messing about to find errors I will probably
> remember that but it might help folk loke me who have yet to fall into
> the trap of not checking that the opening balance was the last
> reconciliation closing balance.  After all, if the program will not let
> you change it why worry about the figure?  However it is really the key
> figure on which the reconciliation is built so ought to be checked at
> the start.
>
> So where am I with my data?  I have corrected the £10k which was
> 'swopped' and then gone after the error schrapnel.  Some of that I have
> found and corrected but eventually I had to succumb to a balancing
> 'fudge it' figure.  With that in place the rest of the reconciliation
> was correct to the penny.
>
> Thanks for all the help.
>
> Best wishes
>
> Pete
>
> -- Original Message --
> From: hell...@gmail.com
> To: p.f.cuthb...@btinternet.com Cc: gnucash-user@gnucash.org;
> blake.hannaf...@gmail.com
> Sent: Wednesday, May 29th 2024, 21:01
> Subject: Re: [GNC] Reconciliation Roll Back (Peter Cuthbert)
> Peter, The roll back facility is already there and has been for years -
> it's called going back to a backup of your accounts file :-) I'm
> assuming you're just using the bog standard xml data file here and are
> running on Windows. There is a preference under Preferences >> General
> that allows you to specify how many days to retain log/backup files
> which is defaulted to 30 days from memory, but you can set it to retain
> backups permanently and delete on an adhoc basis if you wish. So if you
> are using the xml backend Gnucash does this for you and on Windows at
> least keeps them in the same folder as your actual data file. Gnucash
> names them the same as your actual data file but includes a date and
> timestamp embedded in the name and they also have the usual .gnucash
> file suffix - e.g. if the actual data file was named
> Gnucash_Data_From_2011_01_01.gnucash the backups are named
> Gnucash_Data_From_2011_01_01.gnucash.20240429182558.gnucash.
> You can open any of these backup files as a Gnucash data file. My
> suggestion would be to take a copy of your actual data file and put it
> somewhere safe before you do anything further and make a note of the
> date and time you did the reconciliation that you think was bad. Then
> open the backup file just prior to this date and time - hopefully
> whatever happened, occurred within your backup files window if you do
> have GnuCash setup to retain backups. If this backup file looks good to
> you, you can then choose to save this backup file as your actual data
> file name and start over - you need to do this last step of saving the
> backup file without the date and timestamp in the name, otherwise going
> forward you'll end up with some horrendous backup/log file names e.g.
> Gnucash_Data_From_2011_01_01.gnucash.

Re: [GNC] Reconciliation Roll Back (Peter Cuthbert)

2024-05-29 Thread Liz
On Wed, 29 May 2024 22:54:26 -0400
NoobAlice  wrote:

> On 2024-05-29 04:39 PM, Peter Cuthbert via gnucash-user wrote:
> 
> > The dates associated with the reconciled/not reconciled flag struck
> > me as an easy way to do a roll back without using the backups.
> > Something along the lines of if date = [specified
> > reconciliation date] then flag = n (I have no idea what
> > language is used by the developers. ...
> > So where am I with my data?  I have corrected the £10k which was 
> > 'swopped' and then gone after the error schrapnel.  Some of that I
> > have found and corrected but eventually I had to succumb to a
> > balancing 'fudge it' figure.  With that in place the rest of the
> > reconciliation was correct to the penny.  
> 
> To you and anyone else facing this issue, you can run a transaction 
> report that shows you a history of of the account with reconciled
> dates for every transaction.
> 

Thanks NoobAlice
that is a really useful tip

Thanks to Peter Cuthbert we've got together some really good tips on
what happens when a reconciliation goes awry, and I hope that someone
puts a summary on the wiki.

Liz
___
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-user Digest, Vol 254, Issue 46

2024-05-29 Thread John Ralls



> On May 29, 2024, at 20:15, Bruce Schuck  wrote:
> 
> On 5/29/24 18:01:33 -0700, John Ralls wrote:
> 
>> OBTW, I had to force-install 1.62 because
>> Test Summary Report
>> ---
>> t/02-pod-coverage.t  (Wstat: 512 Tests: 0 Failed: 0)
>>   Non-zero exit status: 2
>>   Parse errors: No plan found in TAP output
>> Files=67, Tests=83,  5 wallclock secs ( 0.05 usr  0.06 sys +  3.61 cusr  
>> 0.60 csys =  4.32 CPU)
>> Result: FAIL
>> Failed 1/67 test programs. 0/83 subtests failed.
>> make: *** [test_dynamic] Error 255
>>   BPSCHUCK/Finance-Quote-1.62.tar.gz
>>   /usr/bin/make test -- NOT OK
> 
> John,
> 
> Can you do me a favor and update the Perl module Moose? And try a reinstall 
> of Finance::Quote.

Bruce,

OK. F::Q test results were the same.

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] gnucash-user Digest, Vol 254, Issue 46

2024-05-29 Thread Bruce Schuck

On 5/29/24 18:01:33 -0700, John Ralls wrote:


OBTW, I had to force-install 1.62 because
Test Summary Report
---
t/02-pod-coverage.t  (Wstat: 512 Tests: 0 Failed: 0)
   Non-zero exit status: 2
   Parse errors: No plan found in TAP output
Files=67, Tests=83,  5 wallclock secs ( 0.05 usr  0.06 sys +  3.61 cusr  0.60 
csys =  4.32 CPU)
Result: FAIL
Failed 1/67 test programs. 0/83 subtests failed.
make: *** [test_dynamic] Error 255
   BPSCHUCK/Finance-Quote-1.62.tar.gz
   /usr/bin/make test -- NOT OK


John,

Can you do me a favor and update the Perl module Moose? And try a 
reinstall of Finance::Quote.


Thanks.

Bruce
___
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] Reconciliation Roll Back (Peter Cuthbert)

2024-05-29 Thread NoobAlice

On 2024-05-29 04:39 PM, Peter Cuthbert via gnucash-user wrote:

The dates associated with the reconciled/not reconciled flag struck me 
as an easy way to do a roll back without using the backups.  Something 
along the lines of if date = [specified reconciliation date] then 
flag = n (I have no idea what language is used by the developers. 
...
So where am I with my data?  I have corrected the £10k which was 
'swopped' and then gone after the error schrapnel.  Some of that I have 
found and corrected but eventually I had to succumb to a balancing 
'fudge it' figure.  With that in place the rest of the reconciliation 
was correct to the penny.


To you and anyone else facing this issue, you can run a transaction 
report that shows you a history of of the account with reconciled dates 
for every transaction.


Reports > Transaction Report
Options
Accounts: Choose your checking account
Display:
Check Reconciled Date
Check Date Entered (may be useful, so why not)
Amount: Single column
General:
Start: BEFORE YOUR FIRST TRANSACTION EVER - I pick Jan 1 2000
End: Today
Sorting:
Primary key: Reconciled Status, Ascending
Uncheck Primary subtotal
Secondary key: Reconciled Date, Ascending (sort doesn't work)
Secondary subtotal for date: NONE

Now run the report.  It doesn't get the sort by reconciled date quite 
right, but it might be close.


At this point you need to put the report in a spreadsheet program.  I 
copy and paste, but there are many methods people have shared on the list.


See attached  for an example of what I describe below.  It is very 
important that the start date of your report is before the first 
transaction you have in the account.


In the spreadsheet program, paste and unmerge cells, then:
1) Freeze panes so the column labels at the top don't move
2) Set up a filter across all columns.
3) Use the filter dropdowns to sort by reconciled date.  Make sure the 
transactions with no date are at the bottom and that the reconciled 
transactions are with reconciled dates oldest to newest.
4) Make a formula in a column to the right of your data to make your 
spreadsheet program recognize the numbers.
5) Make a formula in a column to the right of your data to do a running 
subtotal.  (Something like =SUM(I$1:I2) and drag it down, with "$" 
making a part of the formula sticky.)


Now you can quickly look at the reconciled balance as of the end of each 
reconciliation and see if it matches your bank statement.  Once you find 
the first one that doesn't work (or the last one that works), you can 
look at your bank statements and see what transactions are missing from 
the reconciled list in GnuCash.  Look for those missing transactions in 
the unreconciled ones at the end of the list.


I would suggest fixing transactions on the spreadsheet report to get 
things working and highlight all my changes in bright yellow.  Once 
everything is making sense in the spreadsheet, you can make the changes 
in GnuCash.


I have this report saved as Transaction Report -> Rec Report Details

GnuCash Sample Reconciliation.xlsx
Description: MS-Excel 2007 spreadsheet
___
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] Reconciliation Roll Back (Peter Cuthbert)

2024-05-29 Thread Adrien Monteleone

You don't need to roll back a reconciliation that is now out of whack.

If need be, un-reconcile that transaction split, then re-reconcile.

Regards,
Adrien

On 5/29/24 8:33 AM, Peter Cuthbert via gnucash-user wrote:
So final thought for the GNUCash programmers.  Please consider a 'roll 
back' facility so that one can correct mistakes.  Indeed an 'opening 
balance' entry request for Reconciliations would be useful with a 
warning message that the value one has entered is not what the system 
holds.  If that happened one would not go ahead with the reconciliation, 
but go back and look for obvious mistakes.


___
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] Reconciliation Roll Back (Peter Cuthbert)

2024-05-29 Thread Adrien Monteleone
GnuCash is supposed to warn you when editing a reconciled transaction 
that would change the flag.


If not, perhaps you turned that message off.

Check Actions > Reset Warnings and look for something like "change 
contents of reconciled split". If it is there, select it and Apply to 
reset the warning to show up next time. (and next time, don't click the 
box to never warn you again)


If it is not there, and you can intentionally repeat an edit without 
getting the warning and see the transaction un-reconcile, then you found 
a bug. Please report it.


Regards,
Adrien

On 5/28/24 12:49 PM, Blake Hannaford wrote:

I find this has been a longstanding problem.   Every once in a while, old
transactions get unreconciled.  I always open GC the same way so I'm sure
I'm not opening backups.


___
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] Reconciliation Roll Back

2024-05-29 Thread Adrien Monteleone

And I learn something new everyday. Thanks David!

Regards,
Adrien

On 5/28/24 9:17 AM, David Carlson wrote:

A tidbit of information that you may find helpful:  If you hover the mouse
over the "y" character in the reconcile box in an account split line, the
date of the reconciliation for that account split in that transaction
appears in a flyover.  It may take a couple of seconds to appear.


___
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] Running balance/total from search results is always $0.00

2024-05-29 Thread Adrien Monteleone
If the Memo field is your only criteria, then just use the Transaction 
Report and use the Filter tab for your Memo text.


Note, you'll need to decide which account you are summing on the report 
though. (likely the same issue with the Account Report) In the case of 
multiple expense accounts for one or more transactions, you'd want to 
sum and sort off the source account for the funds, usually an asset, but 
could be a credit card or other liability. Be warned though, that will 
be the sum of the entirety of those transactions, not just the 
individual splits you want to highlight. So if there are other 
non-interesting splits in those transactions that balance the source 
funds, they'll get included as well.


Regards,
Adrien

On 5/29/24 12:42 AM, Chandler via gnucash-user wrote:

     I'd like the sum of the values from entries with certain criteria in
the "Memo" field in an expense account.  I can get the list of
transactions containing these entries by searching the Memo field.
Then, everything I found says I can open a Report > Account Report to
get the running balance/total, however that column always remains $0.00
for me.

     I wonder if this has to due with the double-entry bookkeeping I'm
using?  The display is also complicated by the fact that these
transactions can include 3 or 4 different expenses which means instead
of just 2 lines for funds in/funds out, there could be 8 lines for funds
in/out of 4 different accounts, all of which are shown in the Account
Report, yet I'm only interested in the values from the one account I
performed the initial search from.

Using Gnucash 5.6


___
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] YahooJSON Failing Again?

2024-05-29 Thread Bruce Schuck

On 5/29/24 6:01 PM, John Ralls wrote:

Somebody filed https://bugs.gnucash.org/show_bug.cgi?id=799322 
 earlier today so it’s 
not just you. OTOH it might have been a temporary problem:


Thanks John. It just worked for me as well on my work macbook. But I 
hate to say that last time it failed there was some "now it works, now 
it doesn't" before now it doesn't became permanent. 


Odd on the 02-pod test fail. Nothing there has been touched in a few years.

Bruce S.
___
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] YahooJSON Failing Again?

2024-05-29 Thread John Ralls


> On May 29, 2024, at 16:09, Bruce Schuck  wrote:
> 
> Just started failing for me again this afternoon. The never ending game of 
> whack-a-mole continues.
> 
> For those having the same issue I suggest:
> 
> alphavantage (needs an API key)
> twelvedata (needs an API key)
> 
> Web page scrapers
> googleweb
> marketwatch
> fool
> yahooweb
> 
> On the roadmap, you may want to get an api key from https://financeapi.net 
> (100 API calls per day limit).
> 
> Not sure of the availability of quotes for securities traded on non-US 
> exchanges, sorry.

Bruce,

Somebody filed https://bugs.gnucash.org/show_bug.cgi?id=799322 earlier today so 
it’s not just you. OTOH it might have been a temporary problem:
/Applications/Gnucash.app/Contents/MacOS/gnucash-cli -Q dump yahoo_json AAPL
Application Path /Applications/Gnucash.app/Contents/MacOS/gnucash-cli
Finance::Quote fields GnuCash uses:
symbol: AAPL<=== required
  date: 05/29/2024  <=== recommended
  currency: USD <=== required
  last: 190.29  <=\
   nav: <=== one of these
 price: <=/

At 5:57 PM today.

Regards,
John Ralls

OBTW, I had to force-install 1.62 because
Test Summary Report
---
t/02-pod-coverage.t  (Wstat: 512 Tests: 0 Failed: 0)
  Non-zero exit status: 2
  Parse errors: No plan found in TAP output
Files=67, Tests=83,  5 wallclock secs ( 0.05 usr  0.06 sys +  3.61 cusr  0.60 
csys =  4.32 CPU)
Result: FAIL
Failed 1/67 test programs. 0/83 subtests failed.
make: *** [test_dynamic] Error 255
  BPSCHUCK/Finance-Quote-1.62.tar.gz
  /usr/bin/make test -- NOT OK


___
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] how to import notes to desktop from android

2024-05-29 Thread David Carlson
GnuCash doesn't magically read your email.  You are leaving out a critical
part of the workflow in your description.

Are you trying to use the Android app that was abandoned years ago by it's
developer?  GnuCash doesn't support that either, AFAIK, but you might still
get some help here on how to revise your workflow to achieve your goal if
you describe it better.

On Wed, May 29, 2024 at 5:05 PM Kernel Hazelnut <
everythingediblelandscap...@gmail.com> wrote:

> When I export account transactions from GNU cash on my Android phone to
> email and then import to my desktop GNU cash, none of the notes show
> up.  I looked in double line mode also and still no notes.  I can see if
> I open the .qif file in a text editor that they have been exported.
> What can I do?
>
> ___
> 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.
>


-- 
David Carlson
___
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] Reconciliation Roll Back (Peter Cuthbert)

2024-05-29 Thread Peter Cuthbert via gnucash-user


Hi David, Adam, Derek and everybody who has contributed.
 
David, your solution is excellent and I suppose it never crossed my mind 
as I had not wholly worked out what all the files GNUCash spews out 
actually do.  I am afraid that using the accounting software is a twice 
monthly chore in which I log all the transaction slip and credit card 
statement and then reconcile against the bank account.  It is almost 
always late in the evening after the day's chores are cleared up and I 
am not really at my brightest.  So I have not been a keen student and 
learned how to make the software fly.

 
The dates associated with the reconciled/not reconciled flag struck me 
as an easy way to do a roll back without using the backups.  Something 
along the lines of if date = [specified reconciliation date] then 
flag = n (I have no idea what language is used by the developers. 
 I suppose my gripe about the 'Opening Balance' auto figure is probably 
based on many years of using Quicken.  According to my memory one could 
enter both an opening and closing balance, but more recent users can 
tell me if that memoryis incorrect,  Perhaps, for those of us who are 
more in the 'dozy user'category the term Opening balance could perhaps 
have Closing balance at last reconciliation added to it. 
 Have suffered all this messing about to find errors I will probably 
remember that but it might help folk loke me who have yet to fall into 
the trap of not checking that the opening balance was the last 
reconciliation closing balance.  After all, if the program will not let 
you change it why worry about the figure?  However it is really the key 
figure on which the reconciliation is built so ought to be checked at 
the start.

 
So where am I with my data?  I have corrected the £10k which was 
'swopped' and then gone after the error schrapnel.  Some of that I have 
found and corrected but eventually I had to succumb to a balancing 
'fudge it' figure.  With that in place the rest of the reconciliation 
was correct to the penny.

 
Thanks for all the help.
 
Best wishes
 
Pete
 
-- Original Message --
From: hell...@gmail.com
To: p.f.cuthb...@btinternet.com Cc: gnucash-user@gnucash.org; 
blake.hannaf...@gmail.com

Sent: Wednesday, May 29th 2024, 21:01
Subject: Re: [GNC] Reconciliation Roll Back (Peter Cuthbert)
Peter, The roll back facility is already there and has been for years - 
it's called going back to a backup of your accounts file :-) I'm 
assuming you're just using the bog standard xml data file here and are 
running on Windows. There is a preference under Preferences >> General 
that allows you to specify how many days to retain log/backup files 
which is defaulted to 30 days from memory, but you can set it to retain 
backups permanently and delete on an adhoc basis if you wish. So if you 
are using the xml backend Gnucash does this for you and on Windows at 
least keeps them in the same folder as your actual data file. Gnucash 
names them the same as your actual data file but includes a date and 
timestamp embedded in the name and they also have the usual .gnucash 
file suffix - e.g. if the actual data file was named 
Gnucash_Data_From_2011_01_01.gnucash the backups are named 
Gnucash_Data_From_2011_01_01.gnucash.20240429182558.gnucash. 
You can open any of these backup files as a Gnucash data file. My 
suggestion would be to take a copy of your actual data file and put it 
somewhere safe before you do anything further and make a note of the 
date and time you did the reconciliation that you think was bad. Then 
open the backup file just prior to this date and time - hopefully 
whatever happened, occurred within your backup files window if you do 
have GnuCash setup to retain backups. If this backup file looks good to 
you, you can then choose to save this backup file as your actual data 
file name and start over - you need to do this last step of saving the 
backup file without the date and timestamp in the name, otherwise going 
forward you'll end up with some horrendous backup/log file names e.g. 
Gnucash_Data_From_2011_01_01.gnucash.20240429182558.20240430054858.gnucash. 
This may mean re-entering/importing transactions from the date and time 
of the backup file - you could always export transactions from your 
actual data file to cover this period if that's an issue for you ? Hope 
this helps and you have a suitable backup file to go back to. Cheers 
David H. On Wed, 29 May 2024 at 23:34, Peter Cuthbert via gnucash-user 
wrote: > > > Dear Everybody > > Many thanks for your responses to my 
Reconciliation problem. > > I have been examining my accounts and have 
managed to find part of the > problem. A £10K transfer out of the bank 
account to a new saving > account became 'flipped' from a payment to a 
receipt. Looking at the > details I set up for the savings a/c I made 
the wrong choices so that it > was shown as an outgoing not an incoming. 
That clearly accounts

Re: [GNC] Reconciliation Roll Back (Peter Cuthbert)

2024-05-29 Thread Michael or Penny Novack

Useful hint (when making backups, any, not just gnucash)

My suggestion would be to take a copy of your actual data file and put
it somewhere safe before you do anything further


Remove any uncertainty about what back-up is which. Include the Julian date in the name of 
the file. Thus if I were making a back-up of my personal books today, I might name that 
file ..backup20240529.personalbooks.gnucash <>

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] Reconciliation Roll Back (Peter Cuthbert)

2024-05-29 Thread David H
Peter,

The roll back facility is already there and has been for years - it's
called going back to a backup of your accounts file :-)

I'm assuming you're just using the bog standard xml data file here and
are running on Windows.  There is a preference under Preferences >>
General that allows you to specify how many days to retain log/backup
files which is defaulted to 30 days from memory, but you can set it to
retain backups permanently and delete on an adhoc basis if you wish.

So if you are using the xml backend Gnucash does this for you and on
Windows at least keeps them in the same folder as your actual data
file. Gnucash names them the same as your actual data file but
includes a date and timestamp embedded in the name and they also have
the usual .gnucash file suffix - e.g. if the actual data file was
named "Gnucash_Data_From_2011_01_01.gnucash" the backups are named
"Gnucash_Data_From_2011_01_01.gnucash.20240429182558.gnucash".  You
can open any of these backup files as a Gnucash data file.

My suggestion would be to take a copy of your actual data file and put
it somewhere safe before you do anything further and make a note of
the date and time you did the reconciliation that you think was bad.
Then open the backup file just prior to this date and time - hopefully
whatever happened, occurred within your backup files window if you do
have GnuCash setup to retain backups.  If this backup file looks good
to you, you can then choose to save this backup file as your actual
data file name and start over - you need to do this last step of
saving the backup file without the date and timestamp in the name,
otherwise going forward you'll end up with some horrendous backup/log
file names e.g.
"Gnucash_Data_From_2011_01_01.gnucash.20240429182558.20240430054858.gnucash".

This may mean re-entering/importing transactions from the date and
time of the backup file - you could always export transactions from
your actual data file to cover this period if that's an issue for you
?

Hope this helps and you have a suitable backup file to go back to.

Cheers David H.

On Wed, 29 May 2024 at 23:34, Peter Cuthbert via gnucash-user
 wrote:
>
>
> Dear Everybody
>
> Many thanks for your responses to my Reconciliation problem.
>
> I have been examining my accounts and have managed to find part of the
> problem.  A £10K transfer out of the bank account to a new saving
> account became 'flipped' from a payment to a receipt.  Looking at the
> details I set up for the savings a/c I made the wrong choices so that it
> was shown as an outgoing not an incoming.  That clearly accounts for the
> £20k of difference but where the other odds and ends that dribbled it
> down to 19K came from I have no idea.
>
> In exasperation I have looked at some of the other account programs that
> are out there on the Internet but it looks as if they are keen to simply
> import one's bank statement.  I cannot see how they would cope with
> credit card payements other than as a single lump DD.  That is no use to
> me as I use the credit card as a payments card and need to analyse the
> statements.  Thus it looks as if I will have to wind the reconciliation
> back transaction by transaction and get GNUCash corrected.
>
> So final thought for the GNUCash programmers.  Please consider a 'roll
> back' facility so that one can correct mistakes.  Indeed an 'opening
> balance' entry request for Reconciliations would be useful with a
> warning message that the value one has entered is not what the system
> holds.  If that happened one would not go ahead with the reconciliation,
> but go back and look for obvious mistakes.
>
> Best wishes
>
> Pete
>
> -- Original Message --
> From: gnucash-user@gnucash.org
> To: blake.hannaf...@gmail.com Cc: gnucash-user@gnucash.org
> Sent: Tuesday, May 28th 2024, 21:40
> Subject: Re: [GNC] Reconciliation Roll Back (Peter Cuthbert)
> Generally, I find that transactions ONLY get dereconciled due to an
> action I have taken-- like changing some element of said transaction.
> They don't just get unreconciled-- at least, not for me.
> There was a short period of time where the app was very strict about
> when a transaction was dereconciled, but that change was modified after
> user feedback. I believe that recent versions only dereconcile a
> transaction when you modify a material detail, like the amount or the
> date. If you are having this as a longstanding problem, it would be
> useful to everyone to figure out what is going on, so that the problem
> can be addressed-- regardless of where the problem lies. Dereconciling
> transactions is not a minor matter when it comes to accounting software.
> ⁣David T. On May 28, 2024, 8:51 PM, at 8:51 PM, Blake Hannaford wrote:
> >I fi

Re: [GNC] Reconciliation Roll Back

2024-05-29 Thread Adam Funk
On 2024-05-28, David Carlson wrote:

> A tidbit of information that you may find helpful:  If you hover the mouse
> over the "y" character in the reconcile box in an account split line, the
> date of the reconciliation for that account split in that transaction
> appears in a flyover.  It may take a couple of seconds to appear.

Interesting, thanks! I did not know that.

___
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] Reconciliation Roll Back (Peter Cuthbert)

2024-05-29 Thread Derek Atkins
Pete,

I don't understand your request.
During reconciliation, you need to enter the ending balance from your
statement.  If, at the end of the process of checking your transaction the
computed balance does not match the entered balance, then the
reconciliation will not complete.

Now, Gnucash gives you a /guess/ of what that balance is and automatically
fills in that field.  If you just use that directly then yes, reversed
transactions can catch you off guard.  So really the only suggestion I can
see here is to empty out that text field so gnucash won't suggest an
ending balance.

But in reality, you just need to manually enter the correct ending balance
from your statement and then you wont be able to reconcile if transactions
are entered incorrectly.

-derek

On Wed, May 29, 2024 9:33 am, Peter Cuthbert via gnucash-user wrote:
>
> Dear Everybody
>  
> Many thanks for your responses to my Reconciliation problem.
>  
> I have been examining my accounts and have managed to find part of the
> problem.  A £10K transfer out of the bank account to a new saving
> account became 'flipped' from a payment to a receipt.  Looking at the
> details I set up for the savings a/c I made the wrong choices so that it
> was shown as an outgoing not an incoming.  That clearly accounts for the
> £20k of difference but where the other odds and ends that dribbled it
> down to 19K came from I have no idea.
>  
> In exasperation I have looked at some of the other account programs that
> are out there on the Internet but it looks as if they are keen to simply
> import one's bank statement.  I cannot see how they would cope with
> credit card payements other than as a single lump DD.  That is no use to
> me as I use the credit card as a payments card and need to analyse the
> statements.  Thus it looks as if I will have to wind the reconciliation
> back transaction by transaction and get GNUCash corrected.
>  
> So final thought for the GNUCash programmers.  Please consider a 'roll
> back' facility so that one can correct mistakes.  Indeed an 'opening
> balance' entry request for Reconciliations would be useful with a
> warning message that the value one has entered is not what the system
> holds.  If that happened one would not go ahead with the reconciliation,
> but go back and look for obvious mistakes.
>  
> Best wishes
>  
> Pete
>  
> -- Original Message --
> From: gnucash-user@gnucash.org
> To: blake.hannaf...@gmail.com Cc: gnucash-user@gnucash.org
> Sent: Tuesday, May 28th 2024, 21:40
> Subject: Re: [GNC] Reconciliation Roll Back (Peter Cuthbert)
> Generally, I find that transactions ONLY get dereconciled due to an
> action I have taken-- like changing some element of said transaction.
> They don't just get unreconciled-- at least, not for me.
> There was a short period of time where the app was very strict about
> when a transaction was dereconciled, but that change was modified after
> user feedback. I believe that recent versions only dereconcile a
> transaction when you modify a material detail, like the amount or the
> date. If you are having this as a longstanding problem, it would be
> useful to everyone to figure out what is going on, so that the problem
> can be addressed-- regardless of where the problem lies. Dereconciling
> transactions is not a minor matter when it comes to accounting software.
> ⁣David T. ​ On May 28, 2024, 8:51 PM, at 8:51 PM, Blake Hannaford wrote:
>>I find this has been a longstanding problem. Every once in a while,
>>old >transactions get unreconciled. I always open GC the same way so
> I'm >sure >I'm not opening backups. > >Blake Hannaford > >--
>>___ >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.
>  
>
>  
> Dr Peter Cuthbert
> Creuddyn
> Coedlan Y Plas
> Llangawsai
> Aberystwyth
> Sir Ceredigion
> SY23 1HJ
> 01970 623 447
>  
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/lis

Re: [GNC] Reconciliation Roll Back (Peter Cuthbert)

2024-05-29 Thread Peter Cuthbert via gnucash-user


Dear Everybody
 
Many thanks for your responses to my Reconciliation problem.
 
I have been examining my accounts and have managed to find part of the 
problem.  A £10K transfer out of the bank account to a new saving 
account became 'flipped' from a payment to a receipt.  Looking at the 
details I set up for the savings a/c I made the wrong choices so that it 
was shown as an outgoing not an incoming.  That clearly accounts for the 
£20k of difference but where the other odds and ends that dribbled it 
down to 19K came from I have no idea.

 
In exasperation I have looked at some of the other account programs that 
are out there on the Internet but it looks as if they are keen to simply 
import one's bank statement.  I cannot see how they would cope with 
credit card payements other than as a single lump DD.  That is no use to 
me as I use the credit card as a payments card and need to analyse the 
statements.  Thus it looks as if I will have to wind the reconciliation 
back transaction by transaction and get GNUCash corrected.

 
So final thought for the GNUCash programmers.  Please consider a 'roll 
back' facility so that one can correct mistakes.  Indeed an 'opening 
balance' entry request for Reconciliations would be useful with a 
warning message that the value one has entered is not what the system 
holds.  If that happened one would not go ahead with the reconciliation, 
but go back and look for obvious mistakes.

 
Best wishes
 
Pete
 
-- Original Message --
From: gnucash-user@gnucash.org
To: blake.hannaf...@gmail.com Cc: gnucash-user@gnucash.org
Sent: Tuesday, May 28th 2024, 21:40
Subject: Re: [GNC] Reconciliation Roll Back (Peter Cuthbert)
Generally, I find that transactions ONLY get dereconciled due to an 
action I have taken-- like changing some element of said transaction. 
They don't just get unreconciled-- at least, not for me. 
There was a short period of time where the app was very strict about 
when a transaction was dereconciled, but that change was modified after 
user feedback. I believe that recent versions only dereconcile a 
transaction when you modify a material detail, like the amount or the 
date. If you are having this as a longstanding problem, it would be 
useful to everyone to figure out what is going on, so that the problem 
can be addressed-- regardless of where the problem lies. Dereconciling 
transactions is not a minor matter when it comes to accounting software. 
⁣David T. ​ On May 28, 2024, 8:51 PM, at 8:51 PM, Blake Hannaford wrote: 
I find this has been a longstanding problem. Every once in a while, 
old >transactions get unreconciled. I always open GC the same way so 
I'm >sure >I'm not opening backups. > >Blake Hannaford > >-- 
___ >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.

 

 
Dr Peter Cuthbert
Creuddyn
Coedlan Y Plas
Llangawsai
Aberystwyth
Sir Ceredigion
SY23 1HJ
01970 623 447
 
___
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] Reconciliation Roll Back (Peter Cuthbert)

2024-05-28 Thread sunfish62--- via gnucash-user
Generally, I find that transactions ONLY get dereconciled due to an action I 
have taken-- like changing some element of said transaction. They don't just 
"get unreconciled"-- at least, not for me.

There was a short period of time where the app was very strict about when a 
transaction was dereconciled, but that change was modified after user feedback.

I believe that recent versions only dereconcile a transaction when you modify a 
material detail, like the amount or the date.

If you are having this as a longstanding problem, it would be useful to 
everyone to figure out what is going on, so that the problem can be addressed-- 
regardless of where the problem lies. Dereconciling transactions is not a minor 
matter when it comes to accounting software. 

⁣David T. ​

On May 28, 2024, 8:51 PM, at 8:51 PM, Blake Hannaford 
 wrote:
>I find this has been a longstanding problem.   Every once in a while,
>old
>transactions get unreconciled.  I always open GC the same way so I'm
>sure
>I'm not opening backups.
>
>Blake Hannaford
>
>--
>___
>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] Reconciliation Roll Back (Peter Cuthbert)

2024-05-28 Thread Blake Hannaford
I find this has been a longstanding problem.   Every once in a while, old
transactions get unreconciled.  I always open GC the same way so I'm sure
I'm not opening backups.

Blake Hannaford

--
___
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] PST and GST Tax Tables

2024-05-28 Thread Derek Atkins
Hi,

On Tue, May 28, 2024 10:57 am, Peter Klassen wrote:
> Hi Derek
>
> Once again your response was excellent. I have a combined tax table but
> how
> do I split the tax to show separately at the end of the invoice for all
> the
> items.
> pardon my ignorance.

Make sure in the tax table that PST and GST get assigned into DIFFERENT
accounts.
Then when you print the invoice, go into the invoice options and select
the option to show individual taxes.  The exact option you use will depend
on which Invoice report you use.

>
> Peter Klassen
> peita...@gmail.com
>

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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] thanks for the quick answer. I have created separate accounts for PST and GST as liability subaccounts but when I go to assign the tax table I have to use the item value each time. This look

2024-05-28 Thread Derek Atkins
Hi Peter,

First, please be sure to CC gnucash-user on all replies.
Second, It helps to put your question into the email, not in the subject.

It SOUNDS like you created two TaxTables (one for PST and one for GST) and
then made two Invoice line-items, one with each tax table. Instead, you
need to create a single tax-table with BOTH PST and GST, and then apply
that to a single line-item in the invoice.

Please try again.

Thanks,

-derek.

On Tue, May 28, 2024 10:01 am, Peter Klassen wrote:
> Peter Klassen
> peita...@gmail.com
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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] Reconciliation Roll Back

2024-05-28 Thread David Carlson
A tidbit of information that you may find helpful:  If you hover the mouse
over the "y" character in the reconcile box in an account split line, the
date of the reconciliation for that account split in that transaction
appears in a flyover.  It may take a couple of seconds to appear.

Another tidbit:  Transactions with multiple accounts or splits reconcile
separately for each account, but sometimes editing, unreconciling or
deleting in one account can change a reconciliation for another account in
that transaction.  That isn't supposed to happen but sometimes it does with
unusual editing methods, especially if the account name is changed for a
reconciled account line.

On Tue, May 28, 2024 at 5:21 AM Maf. King  wrote:

> On Tuesday, 28 May 2024 09:49:05 BST Peter Cuthbert via gnucash-user wrote:
>
> >   The reason I suspect
> > is that the opening balance that it picked up seemed way too high but I
> > know of no way to make sure that the opening balance is the correct one.
>
> Only by visual inspection - if you completed the reconcile of last month's
> statement, then the reconciled balance in GC should match the end balance
> of
> that statement  which should match the opening balance of the current
> statement which should match what GC suggests as the starting balance.
>
> If the opening balances don't match but the previous reconciled balances
> did
> then something slightly odd has happened.  Maybe you inadvertently
> modified
> some reconciled txns and they lost their "reconcied" status.   maybe you
> accidently started using a backup file at some point (look for lots of
> numbers
> in the filename)
>
>
> >  Additionally I noticed that a good handful of transactions that were
> > reconciled in last months task now showed up as unreconciled.
>
> That would certainly throw off the starting balance.
>
> >
> > I am at a loss as to how to rescure this problem.  What would be nice
> > would be to be able to 'roll back' the erroneous reconciliation and
> > probably the previous one and then begin again.  Unless, of course you
> > > know a better way to get out of this hole.
>
> Try a reconcile to the new statement ending balance - ignore the "start".
> Also look at the unreconciled transactions from previous months - if they
> all
> check off OK and you hit the  new statement end balance  then you are good
> to
> go.
>
> If you really want to roll back the previous reconciles, then you can only
> do
> that manually by clicking on each of the "Y" in the reconciled
> transactions
> status.
>
> As always, take a back-up copey of the file before you start digging and
> maybe
> get in a worse mess!
>
> HTH,
> Maf.
> >
>
>
>
>
> ___
> 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.
>


-- 
David Carlson
___
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] do not know how to show 2 x taxes on an item in invoice

2024-05-28 Thread Derek Atkins
Send them into different Accounts for tax collection.
Then when you print, you can tell it to separate out the taxes.
-derek

On Tue, May 28, 2024 9:42 am, Peter Klassen wrote:
> Trying to print both PST and GST separately on an invoice
>
> Thanks
>
> Peter Klassen
> peita...@gmail.com
> ___
> 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.
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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] Reconciliation Roll Back

2024-05-28 Thread Maf. King
On Tuesday, 28 May 2024 09:49:05 BST Peter Cuthbert via gnucash-user wrote:

>   The reason I suspect
> is that the opening balance that it picked up seemed way too high but I
> know of no way to make sure that the opening balance is the correct one.

Only by visual inspection - if you completed the reconcile of last month's 
statement, then the reconciled balance in GC should match the end balance of 
that statement  which should match the opening balance of the current 
statement which should match what GC suggests as the starting balance.

If the opening balances don't match but the previous reconciled balances did 
then something slightly odd has happened.  Maybe you inadvertently modified 
some reconciled txns and they lost their "reconcied" status.   maybe you 
accidently started using a backup file at some point (look for lots of numbers 
in the filename)


>  Additionally I noticed that a good handful of transactions that were
> reconciled in last months task now showed up as unreconciled.

That would certainly throw off the starting balance.

>  
> I am at a loss as to how to rescure this problem.  What would be nice
> would be to be able to 'roll back' the erroneous reconciliation and
> probably the previous one and then begin again.  Unless, of course you
> > know a better way to get out of this hole.

Try a reconcile to the new statement ending balance - ignore the "start".  
Also look at the unreconciled transactions from previous months - if they all 
check off OK and you hit the  new statement end balance  then you are good to 
go.

If you really want to roll back the previous reconciles, then you can only do 
that manually by clicking on each of the "Y" in the reconciled transactions 
status.

As always, take a back-up copey of the file before you start digging and maybe 
get in a worse mess!

HTH,
Maf.
>  




___
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] Reconciliation Roll Back

2024-05-28 Thread Liz
On Tue, 28 May 2024 09:49:05 +0100 (BST)
Peter Cuthbert via gnucash-user  wrote:

> Dear GNU Cash Users
>  
> A year ago I re-started an account from 6th April in GNU Cash as my 
> previous imports from Quicken were not working as I would have
> wished. It was a lot of work to re enter 3 months of transactions but
> the clean start has been excellent and every month the bank
> reconciiation has been perfect.  This month it is out by more than
> £20K.  The reason I suspect is that the opening balance that it
> picked up seemed way too high but I know of no way to make sure that
> the opening balance is the correct one. Additionally I noticed that a
> good handful of transactions that were reconciled in last months task
> now showed up as unreconciled. 
> I am at a loss as to how to rescure this problem.  What would be nice 
> would be to be able to 'roll back' the erroneous reconciliation and 
> probably the previous one and then begin again.  Unless, of course
> you know a better way to get out of this hole.
>  
> Regards
>  
> Pete C

1. make a copy of your data file.
2. Play with the copy.
3. Ensure you are not working with a backup file.

4. Try reconciling the account as it is. Mark as reconciled all the
things you know were reconciled in the past and see if that improves
the situation.

5. Wait for more advice

Liz
___
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] Using GnuCash with charity restricted and unrestricted funds, advice wanted

2024-05-27 Thread Adrien Monteleone

Both Michael & user 'flywire' have offered the 'how to do that' answer.

Michael's answer involves out-of-the box reports that are further 
manipulated outside of GnuCash to achieve the desired end result, using 
the standard method of entering transactions. (this is quite normal for 
anything but the most basic of reporting needs)


Flywire's answer involves a custom report that someone else was kind 
enough to craft, that you have to add to GnuCash yourself first and then 
use 'tags' in your transactions for your extra reporting dimension.


But in both cases, none of us know what the legal requirements of your 
jurisdiction are. We can make suggestions and offer general guesses 
based on the reasoning of what the term 'restricted funds' means with 
respect to where they belong in the account tree, but if your accountant 
or legal counsel tell you otherwise, you have to follow what *they* tell 
you, not take the suggestions here. If you are not sure how to follow 
*their* advice using GnuCash, we can probably help, or at least suggest 
that you may have to do some finishing work on your reports with other 
software.


Regards,
Adrien

On 5/27/24 8:12 AM, Edward Bainton wrote:

You have to know that first, then ask, "How do I accomplish this using

GnuCash?"

Think of funds accounting as different colours of money. Every account and
every category can include any colour of money.

I need the gross figure for each account and category, the figure for each
account and category broken out into the colours of money that it’s
comprised of, and I need to report on the overall financial position and
movements in any given period of each colour of money, detailing which
accounts and categories it’s comprised of.

How do I accomplish this using GnuCash?


___
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] Using GnuCash with charity restricted and unrestricted funds, advice wanted

2024-05-27 Thread Michael or Penny Novack

On 5/27/2024 9:12 AM, Edward Bainton wrote:

How about this:


You have to know that first, then ask, "How do I accomplish this using

GnuCash?"

Think of funds accounting as different colours of money. Every account and
every category can include any colour of money.

I need the gross figure for each account and category, the figure for each
account and category broken out into the colours of money that it’s
comprised of, and I need to report on the overall financial position and
movements in any given period of each colour of money, detailing which
accounts and categories it’s comprised of.

How do I accomplish this using GnuCash?


By not thinking about colors of money?

It is fair to ask us "How can I use gnucash to store the financial 
transactions so that the data can be extracted to produce the reports 
that I will need?"


OK to ask us "Can I produce these reports directly out of gnucash?" as 
long as you accept the possibility of "No, but you will be able to 
produce reports that when exported, will allow you you to 
combine/extract to produce the final reports"


NOT FAIR to ask "can I do it it THIS WAY using concepts outside of 
standard double entry bookkeeping.


For example, if I understand what you are asking for:

  There is an expense (call it X) for which restricted funds may be 
used OR non-restricted funds may be used (let's say the restricted funds 
for X have run out). You want to have a SINGLE account "expense X"  in 
which the transactions using restricted funds are "colored A" and those 
paid by non-restricted funds "colored B". And then on a report being 
able to show the total "colored A". Yes? << I'm a retired senior 
business analyst; that's how we work, asking the client questions >>


 Well gnucash doesn't do "colors", just debits and credits.

 You could have an expense account "expense X paid both ways" and 
under that child accounts "expense X paid by restricted funds" and 
"expense X paid by non-restricted funds" << those names just to make 
clear what we are talking about >>  And gnucash will certainly allow you 
to use account selection/exclusion so that in a report of where you only 
wanted that part of expense X that was paid using restricted funds you 
could do that.


  Again, wearing my old analyst hat, what are the reports you will 
need to be able to produce?  What has to be on them?


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] Document Link Action Freezes Flatpak GnuCash

2024-05-27 Thread George Lobay

MX-Linux MX-23.3; Debian 12.5; Desktp xfce v: 4.18.1

The version that works fine is natively installed and is Version: 4.13, 
Build ID: 4.13+(2022-12-17), Finance::Quote: 1.54


The version that freezes when attempting to link a file is a Flatpak 
installation and is  Version: 5.6, Build ID: Flathub 5.6-2, 
Finance::Quote: 1.61


On 5/26/24 23:47, David Carlson wrote:

George,

Just for the record, which Linux distribution is on the machine where 
you see this problem?  And which GnuCash distribution does not have 
the problem?


On Sun, May 26, 2024 at 1:13 PM George Lobay  wrote:

I'm using the latest Flatpak GnuCash, ver 5.6, on Linux. Everything
works fine except:

Document linking does not work. I thought it might be a permission
problem, but GNC does have permission to access the folder that holds
the documents to be linked, confirmed by Flatseal.

Problem in detail: Right-click on register item, click item "Manage
Document Link", dialog box opens. Path head is set to the default
Documents folder, the file selection button says 'none'. All is
well so
far, then click 'none' and then GNC completely freezes (including the
dialog box), I have to use xkill and restart GNC. Happens every time.

I really thought it was a Flatpak permissions issue but apparently
not.
When I use the non-Flatpak older GNC that comes with my Linux
distribution, there's no problem.

Thanks in advance

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



--
David Carlson

___
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] Using GnuCash with charity restricted and unrestricted funds, advice wanted

2024-05-27 Thread Edward Bainton
How about this:

> You have to know that first, then ask, "How do I accomplish this using
GnuCash?"

Think of funds accounting as different colours of money. Every account and
every category can include any colour of money.

I need the gross figure for each account and category, the figure for each
account and category broken out into the colours of money that it’s
comprised of, and I need to report on the overall financial position and
movements in any given period of each colour of money, detailing which
accounts and categories it’s comprised of.

How do I accomplish this using GnuCash?



On Mon, 27 May 2024 at 05:22, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> This is a perfect example of why this list is not the place for
> accounting advice.
>
> We can't answer, "What should I do?"
>
> You have to know that first, then ask, "How do I accomplish this using
> GnuCash?"
>
> In many cases, the answer is, "The same way you'd do so with Pen &
> Paper." (sans the actual pen and paper of course)
>
> At best, folks here can offer generalizations. Exact implementation
> absolutely *must* be done in consultation with local professionals
> versed in the laws of your jurisdiction if your issue is anything but
> mere personal musings, and in any case where you have any official duty
> or legal obligation.
>
> Regards,
> Adrien
>
> On 5/26/24 12:37 PM, Michael Hendry wrote:
> > I was keen to keep track of restricted funds within GC in a way which
> would make unspent restricted income persist as restricted funds beyond the
> year end, and you suggested the use of a Liability account for this purpose,
> >
> > Unfortunately, the accountant who examines our accounts before
> submission to OSCR (the Scottish Charities Regulator) advised that this
> isn’t an acceptable way to handle restricted funds in the UK.
> >
> > The problem with using the income accounts (as below) for the various
> types of Income, is that the money not spent (in our case on bursaries for
> musicians who wouldn’t otherwise be able to attend our courses) doesn’t
> persist in the that account after the year end the way a liability would. A
> collection at the final-day concert which is advertised as being destined
> for use as bursaries won’t be spent until the next year’s course.
> >
> > On the other hand, if income received for restricted donations is
> accounted for in this way, and funds paid out as bursaries are also
> accounted for in a separate expense account it should be easy enough to
> keep a year-on-year tally of the remaining restricted funds. In practice,
> we probably spend more than we receive on bursaries each year, but a church
> roof might be a longer-term job.
>
> ___
> 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 on Debian

2024-05-27 Thread Mike Evans
On Sun, 26 May 2024 19:36:37 -0700
John Ralls  wrote:

> > On May 26, 2024, at 12:58, Mike Evans  wrote:
> > 
> > Hi all.
> > 
> > Just moved to debian from Fedora and after installing with apt I get:
> > 
> > /usr/bin/gnucash: symbol lookup error: 
> > /usr/lib/x86_64-linux-gnu/gnucash/gnucash/libgnc-gnome-utils.so: undefined 
> > symbol: gnc_filter_text_for_currency_commodity  
> 
> Mike,
> 
> Sounds like a library version mismatch. The function should be in 
> libgnc-app-utils.so . Make sure that you have 
> only one in your ld.so.conf search path and that it’s the one that belongs to 
> the version of GnuCash you have installed.
> The function was added in 4.6; bookworm has 4.13 (5.6 is available in 
> bookworm-backports should you want the latest release).
> 
> Regards,
> John Ralls
> 

Thanks John 
I do indeed have built-from-source GnuCash installed and that's likely the 
issue.

As an aside.
I was having issues with reports not displaying recently, hence installing with 
apt. 
Whilst troubleshooting I found your mail
https://lists.gnucash.org/pipermail/gnucash-user/2023-October/109024.html
I added a comment to bug 799095 about it not just being NVIDIA drivers.

Thanks again.

Maybe I should do some bug fixing again, since I'm now retired. :)

Mike

-- 
GPG Key fingerprint = 0D8A 33A8 F7F8 733C 7519  2A56 DB8F 7CF1 C67B BC0F
Keyserver: https://keys.openpgp.org
@saxicola@toot.community
___
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] Using GnuCash with charity restricted and unrestricted funds, advice wanted

2024-05-26 Thread Adrien Monteleone
This is a perfect example of why this list is not the place for 
accounting advice.


We can't answer, "What should I do?"

You have to know that first, then ask, "How do I accomplish this using 
GnuCash?"


In many cases, the answer is, "The same way you'd do so with Pen & 
Paper." (sans the actual pen and paper of course)


At best, folks here can offer generalizations. Exact implementation 
absolutely *must* be done in consultation with local professionals 
versed in the laws of your jurisdiction if your issue is anything but 
mere personal musings, and in any case where you have any official duty 
or legal obligation.


Regards,
Adrien

On 5/26/24 12:37 PM, Michael Hendry wrote:

I was keen to keep track of restricted funds within GC in a way which would 
make unspent restricted income persist as restricted funds beyond the year end, 
and you suggested the use of a Liability account for this purpose,

Unfortunately, the accountant who examines our accounts before submission to 
OSCR (the Scottish Charities Regulator) advised that this isn’t an acceptable 
way to handle restricted funds in the UK.

The problem with using the income accounts (as below) for the various types of 
Income, is that the money not spent (in our case on bursaries for musicians who 
wouldn’t otherwise be able to attend our courses) doesn’t persist in the that 
account after the year end the way a liability would. A collection at the 
final-day concert which is advertised as being destined for use as bursaries 
won’t be spent until the next year’s course.

On the other hand, if income received for restricted donations is accounted for 
in this way, and funds paid out as bursaries are also accounted for in a 
separate expense account it should be easy enough to keep a year-on-year tally 
of the remaining restricted funds. In practice, we probably spend more than we 
receive on bursaries each year, but a church roof might be a longer-term job.


___
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] Document Link Action Freezes Flatpak GnuCash

2024-05-26 Thread David Carlson
George,

Just for the record, which Linux distribution is on the machine where you
see this problem?  And which GnuCash distribution does not have the problem?

On Sun, May 26, 2024 at 1:13 PM George Lobay  wrote:

> I'm using the latest Flatpak GnuCash, ver 5.6, on Linux. Everything
> works fine except:
>
> Document linking does not work. I thought it might be a permission
> problem, but GNC does have permission to access the folder that holds
> the documents to be linked, confirmed by Flatseal.
>
> Problem in detail: Right-click on register item, click item "Manage
> Document Link", dialog box opens. Path head is set to the default
> Documents folder, the file selection button says 'none'. All is well so
> far, then click 'none' and then GNC completely freezes (including the
> dialog box), I have to use xkill and restart GNC. Happens every time.
>
> I really thought it was a Flatpak permissions issue but apparently not.
> When I use the non-Flatpak older GNC that comes with my Linux
> distribution, there's no problem.
>
> Thanks in advance
>
> ___
> 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.
>


-- 
David Carlson
___
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 on Debian

2024-05-26 Thread John Ralls


> On May 26, 2024, at 12:58, Mike Evans  wrote:
> 
> Hi all.
> 
> Just moved to debian from Fedora and after installing with apt I get:
> 
> /usr/bin/gnucash: symbol lookup error: 
> /usr/lib/x86_64-linux-gnu/gnucash/gnucash/libgnc-gnome-utils.so: undefined 
> symbol: gnc_filter_text_for_currency_commodity

Mike,

Sounds like a library version mismatch. The function should be in 
libgnc-app-utils.so . Make sure that you have only 
one in your ld.so.conf search path and that it’s the one that belongs to the 
version of GnuCash you have installed.
The function was added in 4.6; bookworm has 4.13 (5.6 is available in 
bookworm-backports should you want the latest release).

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] Using GnuCash with charity restricted and unrestricted funds, advice wanted

2024-05-26 Thread Edward Bainton
The issue UK charity funds accounting presents is that the funds represent
a “third dimension” beyond Dr/Cr: every account, and every category, must
be subdivided into as many restricted funds as the organisation has
(strictly n + 1, since there is almost invariably an unrestricted fund,
too).

If there really are only two funds, per OP’s parish council query, then
mirroring the chart of accounts so every account exists in two versions may
be feasible. But restricted funds have a habit of multiplying like rabbits,
and can appear when least expected, so this is not a future-proof solution.

To me the currency tag workaround seems an efficient solution (if a
somewhat inelegant one). Anyone have lived experience of it?


Sent from my mobile device with apologies for brevity.


On Sun, 26 May 2024 at 19:48, Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

> On 5/26/2024 1:37 PM, Michael Hendry wrote:
> > Hi, Michael,
> >
> > We’ve corresponded about this in the past.
> >
> > I was keen to keep track of restricted funds within GC in a way which
> > would make unspent restricted income persist as restricted funds
> > beyond the year end, and you suggested the use of a Liability account
> > for this purpose,
> >
> > Unfortunately, the accountant who examines our accounts before
> > submission to OSCR (the Scottish Charities Regulator) advised that
> > this isn’t an acceptable way to handle restricted funds in the UK.
> >
> > The problem with using the income accounts (as below) for the various
> > types of Income, is that the money not spent (in our case on bursaries
> > for musicians who wouldn’t otherwise be able to attend our courses)
> > doesn’t persist in the that account after the year end the way a
> > liability would. A collection at the final-day concert which is
> > advertised as being destined for use as bursaries won’t be spent until
> > the next year’s course.
>
> STOP!   The way you keep confusing "income accounts" with the funds that
> came in as that income indicates to me that you are still struggling
> with the fundamental concepts of double entry bookkeeping.
>
> The money itself (the funds) would be in an account(s) of type asset. If
> a transaction in which money coming in is being recorded the debit side
> would be that asset account and the credit side likely an account of
> type income << was that the contents of a donations jar, cookie sales,
> whatever >> If the transaction is where money is going out, the debit
> side likely some expense and the credit side where the money came from
> (the account against which the check written, etc.
>
> You are asking about tracking restricted funds, making sure they are
> only used for the designated purpose. Note that if you had separate bank
> accounts, it would be perfectly clear. What is being discussed is how
> when you DON'T have actually separate accounts you can mimic that. If
> your accountant says not done with liabilities, follow his/her advice as
> to what accounts to use. I just described for somebody else partitioning
> a single (actual) bank account so that it would have a number of
> separate accounts in the books << the liabilities method was NOT
> partitioning the actual bank account -- equivalent in terms of total
> debits and credits >>
>
> Look, I am here. I am NOT going to be able to find a text book covering
> "accounting for non-profits in Scotland". If you are not being told by
> your accountant, you need to look that up for yourself, what accounts
> you'd need, what the workflow of transactions would look like, etc. THEN
> we can tell you how to do that using gnucash as opposed to say pen and
> ink on paper.
>
> 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] Using GnuCash with charity restricted and unrestricted funds, advice wanted

2024-05-26 Thread Michael or Penny Novack

On 5/26/2024 1:37 PM, Michael Hendry wrote:

Hi, Michael,

We’ve corresponded about this in the past.

I was keen to keep track of restricted funds within GC in a way which 
would make unspent restricted income persist as restricted funds 
beyond the year end, and you suggested the use of a Liability account 
for this purpose,


Unfortunately, the accountant who examines our accounts before 
submission to OSCR (the Scottish Charities Regulator) advised that 
this isn’t an acceptable way to handle restricted funds in the UK.


The problem with using the income accounts (as below) for the various 
types of Income, is that the money not spent (in our case on bursaries 
for musicians who wouldn’t otherwise be able to attend our courses) 
doesn’t persist in the that account after the year end the way a 
liability would. A collection at the final-day concert which is 
advertised as being destined for use as bursaries won’t be spent until 
the next year’s course.


STOP!   The way you keep confusing "income accounts" with the funds that 
came in as that income indicates to me that you are still struggling 
with the fundamental concepts of double entry bookkeeping.


The money itself (the funds) would be in an account(s) of type asset. If 
a transaction in which money coming in is being recorded the debit side 
would be that asset account and the credit side likely an account of 
type income << was that the contents of a donations jar, cookie sales, 
whatever >> If the transaction is where money is going out, the debit 
side likely some expense and the credit side where the money came from 
(the account against which the check written, etc.


You are asking about tracking restricted funds, making sure they are 
only used for the designated purpose. Note that if you had separate bank 
accounts, it would be perfectly clear. What is being discussed is how 
when you DON'T have actually separate accounts you can mimic that. If 
your accountant says not done with liabilities, follow his/her advice as 
to what accounts to use. I just described for somebody else partitioning 
a single (actual) bank account so that it would have a number of 
separate accounts in the books << the liabilities method was NOT 
partitioning the actual bank account -- equivalent in terms of total 
debits and credits >>


Look, I am here. I am NOT going to be able to find a text book covering 
"accounting for non-profits in Scotland". If you are not being told by 
your accountant, you need to look that up for yourself, what accounts 
you'd need, what the workflow of transactions would look like, etc. THEN 
we can tell you how to do that using gnucash as opposed to say pen and 
ink on paper.


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] Using GnuCash with charity restricted and unrestricted funds, advice wanted

2024-05-26 Thread Michael Hendry
Hi, Michael,

We’ve corresponded about this in the past.

I was keen to keep track of restricted funds within GC in a way which would 
make unspent restricted income persist as restricted funds beyond the year end, 
and you suggested the use of a Liability account for this purpose,

Unfortunately, the accountant who examines our accounts before submission to 
OSCR (the Scottish Charities Regulator) advised that this isn’t an acceptable 
way to handle restricted funds in the UK.

The problem with using the income accounts (as below) for the various types of 
Income, is that the money not spent (in our case on bursaries for musicians who 
wouldn’t otherwise be able to attend our courses) doesn’t persist in the that 
account after the year end the way a liability would. A collection at the 
final-day concert which is advertised as being destined for use as bursaries 
won’t be spent until the next year’s course.

On the other hand, if income received for restricted donations is accounted for 
in this way, and funds paid out as bursaries are also accounted for in a 
separate expense account it should be easy enough to keep a year-on-year tally 
of the remaining restricted funds. In practice, we probably spend more than we 
receive on bursaries each year, but a church roof might be a longer-term job.

Michael

> On 25 May 2024, at 23:08, Michael or Penny Novack 
>  wrote:
> 
> You did NOT have to have separate books!
> 
> In ONE set of books you can have as many "bank accounts" in the ledger ans 
> you have bank accounts. Just give them different names so that you can tell 
> them apart. We may have some difficulties with cross pond differences in 
> language. Thus your "current account" means what I would call a "checking 
> account" and you must not confuse "current account" with the asset category 
> "current assets" << all accounts containing immediately available funds >>
> 
> Thus:
> Assets
>  Current assets
>Current account
>Savings account << where you are keeping restricted funds >>
> 
> OK, now your donations are all being deposited into the checking account even 
> though some of those donations are restricted. You are asking how to deal 
> with that? Under income you could have:
> Income
>   unrestricted donations
>   untransferred restricted donations
>   restricted donations
> 
> When you make a deposit into the checking account of a bunch of donations (of 
> both sorts) you use the top two. Hint: easiest to have an asset under current 
> assets "undeposited cash" and as donations come in they go there credited to 
> either unrestricted donations or untransferred. Now your actual bank deposit 
> is an easy transaction, just undeposited to checking. Later, when you 
> transfer from the "checking account" to the "savings account"  you 
> would ALSO be transferring between "untransferred restricted donations" to 
> "restricted donations". NOTE -- your reference to "building society" manes a 
> different bank? Still that way your side of the pond?
> 
> As for your question about statements, almost all gnucash reports allow you 
> to SELECT which accounts are to be included. You'd be able to produce 
> statements for just the unrestricted funds, just the restricted, both 
> together, etc.
> 
> Do note that while you can't use restricted funds for other than their 
> intended purpose THE REVERSE IS NOT TRUE < organizational bylaws but would be most unusual >> That's why you would want 
> to use restricted funds for their intended purpose first (before using any 
> non-restricted funds for that purpose). You want to clear the restriction.
> 
> Michael D Novack
> 
> PS --- The usual caveat, I'm not "licensed" to give accounting help. For what 
> it's worth, I've been Treasurer for a number of non-profits.
> 
> PPS -- if you are following this, but your organization does not have that 
> second bank account, you could track the restriction using a liability.
> 
> 
> 
> 
> 
> 
> On 5/25/2024 4:13 PM, Chris Green wrote:
>> I am the treasurer of a very small parish church council in the UK.
>> 
>> We have to present separate accounts for restricted and unrestricted
>> accounts, this is a legal requirement and also required by our diocese.
>> 
>> At the moment restricted funds are, basically, building funds and are
>> kept in an interest paying savings account.  The unrestricted funds
>> are kept in a bank current account.
>> 
>> My problem is that many donations to the restricted account (e.g.
>> donations that the donor has specifically said must be for repairs of
>> the church roof) go into the bank current account and have to be
>> transferred from there to the building society account.
>> 
>> For the last couple of years I have separate GnuCash data for the
>> current account and the building society account, this has worked
>> reasonably well.  However we are now moving into a period of getting
>> the roof repaired and much more money will have to move via the
>> 

Re: [GNC] Using GnuCash with charity restricted and unrestricted funds, advice wanted

2024-05-26 Thread Michael or Penny Novack

On 5/26/2024 10:24 AM, (Alan) David Smith wrote:

Dear  Sir/Madam,

I am an FCCA in England and an ex PCC treasurer. The main point to bear in mind 
about funds is that they must be accounted for Separately. They do not have to 
be represented by separate bank accounts, but it may advisable in Certain 
cases. So one bank can share various funds. But the bookkeeping must be clear.


The other thing to keep clear is that (as Treasurer) you need to be able 
to produce the report which is NOT the same thing as saying the finished 
report (pretty print and all) has to come DIRECTLY from your financial 
software. All your financial software needs to be able to do is produce 
raw reports which contain the data you would need to put together the 
finished product.


Thus I would guess the "final product" for a restricted fund report in 
the UK would need starting balance, income to this fund for the period, 
expenses paid for by this fund, and ending balance. Yes? Notice that for 
this you might have to partition the authorized expense! << because 
while the restricted funds can only be used t=for this purpose nothing 
prevents the organization from also using general funds for the purpose. 
In other words, possibly not all of that expense were paid for by 
restricted funds >>


The first organization where I took over being Treasurer after retiring 
another board member who was a lawyer/accountant told me "Mike, don't 
bother writing custom reports. Just export raw reports and we use a full 
function editor to produce the finished products" << I could have; spent 
decades in the cypher mines and was a senior systems analyst/senior 
business analyst -- never had been paid to write in LISP but I would not 
have taken long to become fluent in Scheme >>. The point here is that IN 
GENERAL going to have to do some editing anyway to get a pro[per 
finished product.


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] Using GnuCash with charity restricted and unrestricted funds, advice wanted

2024-05-26 Thread Edward Bainton
When I asked this question a couple of years ago there were quite a few
suggestions. (Someone better versed in listserv could probably find this,
but I can't.)

The solution that seemed most straightforward and workable to me was:

   - Assign each discrete fund a currency code
  - assuming these are free text, this could be a TLA that matches the
  name of the fund well, but it's possible the real-world
currencies are the
  only options, so you'd have to approximate and keep an index.
   - Set the exchange rate at 1:1
   - Your funds report is the balance of each "currency" at any given moment

I'm sorry I'm still not a real-life GnuCash user, so can't comment on this
solution from experience, but it looked like a good solution to me - as
secretary/treasurer of an unincorporated charity in the UK using Excel
currently. (Which on <20 transactions per month I find perfectly usable -
DM me for more on that if you like, or find your way to
smallcharitysupport.uk)

On Sat, 25 May 2024 at 21:14, Chris Green  wrote:

> I am the treasurer of a very small parish church council in the UK.
>
> We have to present separate accounts for restricted and unrestricted
> accounts, this is a legal requirement and also required by our diocese.
>
> At the moment restricted funds are, basically, building funds and are
> kept in an interest paying savings account.  The unrestricted funds
> are kept in a bank current account.
>
> My problem is that many donations to the restricted account (e.g.
> donations that the donor has specifically said must be for repairs of
> the church roof) go into the bank current account and have to be
> transferred from there to the building society account.
>
> For the last couple of years I have separate GnuCash data for the
> current account and the building society account, this has worked
> reasonably well.  However we are now moving into a period of getting
> the roof repaired and much more money will have to move via the
> current account.
>
> So, how should I deal with this using GnuCash?  I can see that I could
> separate accounts into two hierarchies (in a single database) -
> restricted and unrestricted with expenses and income for each, etc.
> However is it then possible to present separate end of year statements
> for them?  This would simplify incoming donations which are all to a
> single bank account.
>
> Or are there other strategies which work better for this sort of
> situation?
>
> I emphasise that this is a small church, annual income is only of the
> order of £5000 and we have no full-time or paid employees.  So the
> solution has to be simple and manageable by part-time,
> non-professional people.
>
> --
> Chris Green
> ___
> 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] Using GnuCash with charity restricted and unrestricted funds, advice wanted

2024-05-26 Thread (Alan) David Smith
Dear  Sir/Madam,

I am an FCCA in England and an ex PCC treasurer. The main point to bear in mind 
about funds is that they must be accounted for Separately. They do not have to 
be represented by separate bank accounts, but it may advisable in Certain 
cases. So one bank can share various funds. But the bookkeeping must be clear. 

Our church has used Financial co-ordinator software in recent years which is 
good for small and larger churches. It also clearly deals with Fund accounting 
and is easy to learn.

There is a charge - which I do not think is excessive and may be someone would 
be willing to donate the cost.

However I also use GNU Cash for my own books  and find it a good free program.

Regards,

David.

Ex PCC Treasurer  and current member of Finance committee.

On 25/05/2024, 21:13, "gnucash-user on behalf of Chris Green" 
 wrote:

I am the treasurer of a very small parish church council in the UK.

We have to present separate accounts for restricted and unrestricted
accounts, this is a legal requirement and also required by our diocese.

At the moment restricted funds are, basically, building funds and are
kept in an interest paying savings account.  The unrestricted funds
are kept in a bank current account.

My problem is that many donations to the restricted account (e.g.
donations that the donor has specifically said must be for repairs of
the church roof) go into the bank current account and have to be
transferred from there to the building society account.

For the last couple of years I have separate GnuCash data for the
current account and the building society account, this has worked
reasonably well.  However we are now moving into a period of getting
the roof repaired and much more money will have to move via the
current account.

So, how should I deal with this using GnuCash?  I can see that I could
separate accounts into two hierarchies (in a single database) -
restricted and unrestricted with expenses and income for each, etc. 
However is it then possible to present separate end of year statements
for them?  This would simplify incoming donations which are all to a
single bank account.

Or are there other strategies which work better for this sort of
situation?

I emphasise that this is a small church, annual income is only of the
order of £5000 and we have no full-time or paid employees.  So the
solution has to be simple and manageable by part-time,
non-professional people.

-- 
Chris Green
___
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't download stock prices

2024-05-25 Thread Ernie Wakamatsu
And like magic it works.  Thanks for the help.

Ernie



> On 22 May 2024, at 2:14 PM, John Ralls  wrote:
> 
> Ernie,
> 
> You probably built it for the wrong architecture. GnuCash is x86_64 so all of 
> the perl modules that aren’t pure perl need to be multi-architecture. See 
> https://wiki.gnucash.org/wiki/Online_Quotes#Installing_Finance::Quote_on_macOS_from_a_Terminal_prompt
>  for an explanation.
> 
> Regards,
> John Ralls
> 
>> On May 21, 2024, at 19:16, Ernie Wakamatsu  wrote:
>> 
>> HI John and Gnucash Supporters,
>> 
>> I was afraid you were going to say that.  As far as I can tell, I have 
>> JSON::Parse installed, but gnucash-cli is not finding it.
>> 
>> Ernie-Mac-mini% cpan JSON::Parse
>> Loading internal logger. Log::Log4perl recommended for better logging
>> Reading '/Users/Ernie_1/.cpan/Metadata'
>>   Database was generated on Tue, 21 May 2024 02:17:02 GMT
>> JSON::Parse is up to date (0.62).
>> Ernie-Mac-mini% /Applications/Gnucash.app/Contents/MacOS/gnucash-cli -Q info
>> Application Path /Applications/Gnucash.app/Contents/MacOS/gnucash-cli
>> Failed to initialize Finance::Quote: missing_modules JSON::Parse
>> 
>> Sorry to keep troubling you.
>> 
>> Reards,
>> Ernie
>> Just an old FORTRAN programmer
>> 
>> 
>>> On 22 May 2024, at 1:48 AM, John Ralls  wrote:
>>> 
>>> Depends on the bug. Just like every other development team they have more 
>>> bugs than engineers so they have to prioritize. Some things get fixed 
>>> quickly, others take a while, and some never get attention. I don’t know 
>>> who maintains the libc that Apple uses. If it’s FreeBSD then they won’t 
>>> consider it a bug because their file systems are case sensitive.
>>> 
>>> As for what to do, that should be obvious: Spell the path correctly, where 
>>> spell includes case.
>>> You also need to run gnc-update-fq again to get JSON::Parse installed.
>>> 
>>> Regards,
>>> John Ralls
>>> 
 On May 20, 2024, at 22:00, Ernie Wakamatsu  wrote:
 
 One could hope Apple will fix bugs in a timely manner :-p.  
 
 So what should I do to workaround this bug or am I hosed?
 
 Ernie
 
 
> On 21 May 2024, at 1:21 PM, John Ralls  wrote:
> 
> Hah! I didn’t even notice that. It’s pretty funny.
> 
> The *file system* is by default case-preserving, meaning that you can 
> create either macOS or MacOS but not both; preserving means that it will 
> keep whichever one you create first. The shell is too, though Bash 
> completion is case-sensitive. Apparently dlopen is case-sensitive too: 
> when we call 
> `dlopen(/Applications/Gnucash.app/Contents/macOS/lib/gnucash/libgncmod-backend-dbi.dylib,
>  0x0009)` it fails to find the file. You can see this yourself by running 
>   /Applications/Gnucash.app/Contents/macOS/gnucash-cli --debug 
> —logto=stdout -Q info
> It’s in the first line of output.
> 
> I’m going to file a bug with Apple on that if it’s still true when the 
> first macOS 15 developer beta comes out in 3 weeks. Maybe they’ll fix it.
> 
> Regards,
> John Ralls
> 
> 
>> On May 20, 2024, at 18:07, Ernie Wakamatsu  wrote:
>> 
>> Very strange.  I get two results.
>> 
>> First, following your instructions, by coping and pasting
>> Ernie@Ernie-Mac-mini contents % zsh -df
>> Ernie-Mac-mini% /Applications/Gnucash.app/Contents/MacOS/gnucash-cli -Q 
>> info
>> Application Path /Applications/Gnucash.app/Contents/MacOS/gnucash-cli
>> Failed to initialize Finance::Quote: missing_modules JSON::Parse
>> 
>> But when I type in the command line:
>> 
>> Ernie-Mac-mini% /Applications/Gnucash.app/Contents/macOS/gnucash-cli -Q 
>> info
>> Application Path /Applications/Gnucash.app/Contents/macOS/gnucash-cli
>> * 11:01:28  WARN  failed to load gncmod-backend-dbi from 
>> relative path 
>> * 11:01:28 ERROR  required library gncmod-backend-dbi not 
>> found.
>> * 11:01:28  WARN  failed to load gncmod-backend-xml from 
>> relative path 
>> * 11:01:28 ERROR  required library gncmod-backend-xml not 
>> found.
>> * 11:01:28 ERROR  g_settings_schema_source_lookup: assertion 
>> 'source != NULL' failed
>> * 11:01:28 ERROR  g_settings_new_full: assertion 'schema != 
>> NULL' failed
>> * 11:01:28  WARN  
>> [gnc_gsettings_get_settings_obj()] Ignoring attempt to access unknown 
>> gsettings schema org.gnucash.GnuCash.general
>> zsh: segmentation fault  
>> /Applications/Gnucash.app/Contents/macOS/gnucash-cli -Q info
>> 
>> The two command lines are seemingly the same, but the difference is 
>> macOS and MacOS.  I thought the shell was not case sensitive.  h  
>> The behavior is the same when I exit from the default shell.
>> 
>> I did check the directory and it is MacOS.
>> 
>> Ernie-Mac-mini% cd /Applications/Gnucash.app/Contents
>> Ernie-Mac-mini% ls
>> Info.plist   

Re: [GNC] Budget-like Balance Sheet Report

2024-05-25 Thread Who The Hell Knows
Thanks Geoff.

A couple tweaks to the defaults and I got exactly what I needed.

Regards,

Julian


On Fri., May 24, 2024, 8:46 a.m. Geoff,  wrote:

> Hi Julian
>
> Try the Balance Sheet Multicolumn report.  It has options for Monthly or
> Yearly balances.
>
> Regards
>
> Geoff
> =
>
> On 23/05/2024 1:47 am, Who The Hell Knows wrote:
> > I'm looking for a balance sheet report similar in format to the budget
> > report but instead of the net debit/credit per account per month it shows
> > the account balances at the end of each month in multiple columns, one
> > month per column.
> >
> > Does such a report exist?
> >
> > Thanks,
> >
> > Julian
> > ___
> > 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] Using GnuCash with charity restricted and unrestricted funds, advice wanted

2024-05-25 Thread Michael or Penny Novack

You did NOT have to have separate books!

In ONE set of books you can have as many "bank accounts" in the ledger 
ans you have bank accounts. Just give them different names so that you 
can tell them apart. We may have some difficulties with cross pond 
differences in language. Thus your "current account" means what I would 
call a "checking account" and you must not confuse "current account" 
with the asset category "current assets" << all accounts containing 
immediately available funds >>


Thus:
Assets
 Current assets
   Current account
   Savings account << where you are keeping restricted funds >>

OK, now your donations are all being deposited into the checking account 
even though some of those donations are restricted. You are asking how 
to deal with that? Under income you could have:

Income
  unrestricted donations
  untransferred restricted donations
  restricted donations

When you make a deposit into the checking account of a bunch of 
donations (of both sorts) you use the top two. Hint: easiest to have an 
asset under current assets "undeposited cash" and as donations come in 
they go there credited to either unrestricted donations or 
untransferred. Now your actual bank deposit is an easy transaction, just 
undeposited to checking. Later, when you transfer from the "checking 
account" to the "savings account"  you would ALSO be transferring 
between "untransferred restricted donations" to "restricted donations". 
NOTE -- your reference to "building society" manes a different bank? 
Still that way your side of the pond?


As for your question about statements, almost all gnucash reports allow 
you to SELECT which accounts are to be included. You'd be able to 
produce statements for just the unrestricted funds, just the restricted, 
both together, etc.


Do note that while you can't use restricted funds for other than their 
intended purpose THE REVERSE IS NOT TRUE > That's why you 
would want to use restricted funds for their intended purpose first 
(before using any non-restricted funds for that purpose). You want to 
clear the restriction.


Michael D Novack

PS --- The usual caveat, I'm not "licensed" to give accounting help. For 
what it's worth, I've been Treasurer for a number of non-profits.


PPS -- if you are following this, but your organization does not have 
that second bank account, you could track the restriction using a 
liability.







On 5/25/2024 4:13 PM, Chris Green wrote:

I am the treasurer of a very small parish church council in the UK.

We have to present separate accounts for restricted and unrestricted
accounts, this is a legal requirement and also required by our diocese.

At the moment restricted funds are, basically, building funds and are
kept in an interest paying savings account.  The unrestricted funds
are kept in a bank current account.

My problem is that many donations to the restricted account (e.g.
donations that the donor has specifically said must be for repairs of
the church roof) go into the bank current account and have to be
transferred from there to the building society account.

For the last couple of years I have separate GnuCash data for the
current account and the building society account, this has worked
reasonably well.  However we are now moving into a period of getting
the roof repaired and much more money will have to move via the
current account.

So, how should I deal with this using GnuCash?  I can see that I could
separate accounts into two hierarchies (in a single database) -
restricted and unrestricted with expenses and income for each, etc.
However is it then possible to present separate end of year statements
for them?  This would simplify incoming donations which are all to a
single bank account.

Or are there other strategies which work better for this sort of
situation?

I emphasise that this is a small church, annual income is only of the
order of £5000 and we have no full-time or paid employees.  So the
solution has to be simple and manageable by part-time,
non-professional people.



--
There is no possibility of social justice on a dead planet except the equality 
of the grave.

___
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] How should I enter values on a budget in gnucash ?

2024-05-24 Thread Adrien Monteleone

Daniel,

The Budget module needs lots of testing.

Some changes were made (not sure at what release) to sort out issues 
with negative signs and the book preference for 'reverse balanced accounts.'


I used to use this module quite a bit, but about that time, I fell 
behind and haven't gotten back to it.


When that happens, I'll report back in this thread if I find similar 
issues as you, and/or if I find answers/solutions.


Regards,
Adrien

On 5/15/24 6:37 PM, Daniel Sheffield wrote:

Hi all,

I am using Gnucash 4.8. I'm facing the issues discussed here.

I see a bunch of issues here:
https://bugs.gnucash.org/buglist.cgi?component=Budgets=GnuCash=---

Specifically I am hitting these:

* https://bugs.gnucash.org/show_bug.cgi?id=797870
* https://bugs.gnucash.org/show_bug.cgi?id=689754

I've seen a bunch of comments in this e-mail thread about user error or
user preferences. Fact is the budget feature is just plain wrong as there
is currently no form of user entry that gives consistent results in the
following areas:
* Budget Chart - plots actual vs budget bar chart
* Budget Editor Income/Expense/Transfers/Total - this seems to be where the
math error is
* Budget Balance sheet - I don't use this one, but can confirm that it
behaves as described in the issues above.

What I desire:
* Budget Editor Income/Expense/Transfers/Total is correct so that I can
tell at a glance if I've made a mistake in my budget.
* Budget Chart - I need the credits and debits to be plotted in the same
direction. I don't care whether the Reverse value for Credit Accounts is
set or not or which direction debits/credits are plotted so long as they
are consistent.

What I have been doing as a work around:
* In the Budget Editor I put debiting a liability [thus decreasing my
liability] as a +ve value and crediting a liability [thus increasing my
liability] as a -ve value. If I make corresponding transactions in my
accounts, then the Budget Chart of actuals vs budget agree.
* In the Budget Editor I put crediting my Income as a +ve value and
debiting an Expense as a +ve value. If I make corresponding transactions in
my accounts, then the Budget Chart of actuals vs budget agree for Expenses
but are opposite (diverging graph) for Income. But that's OK because I
don't include income in my Budget Chart.
* In the Budget Editor, the totals are calculated like: Remaining to Budget
= Net Income Credits - Net Expense Debits + Net Transfer Debits (where
debits are positive values on the budget sheet and credits are negative
values on the budget sheet). Note that again, the "Reverse value for Credit
Accounts" setting has no effect on the charts or the budget editor as far
as I can tell.
* Thus, the +ve values on my liabilities increase the total remaining to
budget!
* I can rectify the total remaining to budget by using -ve values for
debiting a liability, but if I do that my Budget Chart is off (I include
Expense and Liabilities in my chart).
* So instead, I do a crazy hack: For every +ve value in a Liability, I put
a corresponding -ve value in Equity and a +ve value in Assets.

The result is:
   * The total remaining to budget is correct
   * The Budget Chart shows actuals that go in the same direction as budget
values for Expense and Liabilities.
   * The Budget Report is incorrect for liabilities - but I don't use this
feature - I use the Budget Chart instead.
   * I have to remember to put the hack values in my Assets and Equities on
the Budget Editor (making room for error).

This whole thing makes me afraid to use the budget feature.
As my wife is used to an Envelopes (Single Entry) system rather than Double
Entry accounting, it's critical that I can have a reliable budgeting
feature (essentially what single entry is looking at).

At this point, I'm seriously considering changing my method to the
following:
* Put all values in budget editor as +ve for a debit and -ve for a credit.
* The estimate feature will be applying sign reversal inconsistently with
this approach - but this is less error prone to reverse (multiply each
value by minus -1 as necessary).
* The total remaining to budget will be completely wrong, but I can
calculate this myself by looking at the rolled up top level accounts
(assuming I haven't hard-coded values in any of these accounts). That is,
summing the totals on the top-level accounts should add to zero.
* Assuming corresponding transactions entered in the accounts, ie, sticking
to budget, then all the accounts on the Budget Chart will show actuals
agreeing with budget, including Income accounts (and Equity accounts too?).
* Differences on Budget Chart will be shown correctly (in terms of
magnitude), though wrapping my head around the sign reversal will be a pain
- but this is the "normal" confusion I face with meaning of credit and
debit in terms of accounting vs colloquial usage.
* Budget Report is still wrong (sign reversal applied to Liabilities in
Actual but not in Budget values). But I don't use this feature.
* 

Re: [GNC] Budget-like Balance Sheet Report

2024-05-24 Thread Geoff

Hi Julian

Try the Balance Sheet Multicolumn report.  It has options for Monthly or 
Yearly balances.


Regards

Geoff
=

On 23/05/2024 1:47 am, Who The Hell Knows wrote:

I'm looking for a balance sheet report similar in format to the budget
report but instead of the net debit/credit per account per month it shows
the account balances at the end of each month in multiple columns, one
month per column.

Does such a report exist?

Thanks,

Julian
___
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] Problem building Gnucash from source using wiki page "macOS/Quartz"

2024-05-24 Thread Paul Ingram
As suggested, I patched project.py in 
~/.new_local/lib/python3.11/site-packages/pipenv/ as per 
"gitHub.com/pypa/pipenv/issues/6106”.
Reran gtk-osx-setup.sh and got the following question:

- pyenv: /Users/gtkosx/.new_local/share/pyenv/versions/3.11.7 already exists
- continue with installation? (y/N)

Answered “y”, and it seemed to run to completion, but with some warnings about 
tkinter and lzma not being installed.

Continued with instructions in wiki.gnucash.org/wiki/MacOS/Quartz:
- Set path to include ~/.new_local/bin
- Moved copy of bash to .new_local/bin
- Downloaded jhbuildrc_custom
- Put jhbuild_custom in .config
- Added 'branches["gnucash-git”]=(None,”master”)’
- Changed “=_modules_stable” to “=_modules_git”

Finally, ran “jhbuild bootstrap-gtk-osx” and got:

- Loading .env environment variables...
- I: Modulesets were edited locally but JHBuild is configured to get them from 
the network, perhaps you need to add use_local_modulesets = True to your 
/Users/gtkosx/.config/jhbuildrc.
- jhbuild bootstrap-gtk-osx: no such command (did you mean "jhbuild run 
bootstrap-gtk-osx"?)

Tried running “jhbuild -f .config/jhbuildrc-custom bootstrap-gtk-osx” and got:

- Loading .env environment variables...
- Traceback (most recent call last):
-   File "/Users/gtkosx/Source/jhbuild/jhbuild/config.py", line 194, in load
- execfile(filename, config)
-   File "/Users/gtkosx/Source/jhbuild/jhbuild/utils/compat.py", line 67, in 
execfile
- exec(code, globals, locals)
-   File ".config/jhbuildrc-custom", line 3, in 
- setup_sdk()
- ^
- NameError: name 'setup_sdk' is not defined
- jhbuild: could not load config file

Looks like jhbuild is trying to execute "setup_sdk()” from line 3 of 
jhbuildrc_custom but can’t find this function.
There was no reference to it in the output of gtk-osx-setup.sh.
Thanks for any advice on how to proceed.



> On May 10, 2024, at 10:43 AM, John Ralls  wrote:
> 
> 
> 
>> On May 9, 2024, at 10:08, Paul Ingram  wrote:
>> 
>> 
>> Trying to build gnucash-5.6 from source on a mac mini running macOS 14.4.1 
>> in accordance with the instructions on 
>> https://wiki.gnucash.org/wiki/MacOS/Quartz.
>> 
>> Created administrator account “gtkosx”
>> Switched to the new account: "su gtkosx"
>> Ran “sh gtk-osx-setup.sh” in a bash shell
>> Got the following messages:
>> 
>> Installed openssl-3.2.0 …
>> Installed readline-8.2 …
>> Installed python-3.11.7 (with warnings “missing the Tk toolkit?” and 
>> “missing the lzma lib?”
>> Installed pip-24.0 …
>> Installing collected packages: distlib, setup tools, …
>> Installed certifi-2024.2.2, distlib-0.3.8, …
>> Created virtualenv …
>> Locking dependencies ...
>> Building requirements …
>> Resolving dependencies …
>> 
>> Error:
>> File 
>> "/Users/gtkosx/.new_local/lib/python3.11/site-packages/pipenv/project.py", 
>> line *239*, in get_requests_session_for_source
>> 
>>  if *self.sessions.get**(*source*[*"name"*])*:
>> 
>>   ~~
>> 
>> KeyError: 'name'
>> 
>> ✘ Locking Failed!
>> 
>> 
>> 
>> Patch for project.py appears here: https://github.com/pypa/pipenv/issues/6106
>> 
>> 
>> 
>> Do I patch project.py manually and rerun gtk-osx-setup.sh?
>> 
> 
> Yes. Pipenv has merged my PR but hasn’t done a new release.
> 
> Regards,
> John Ralls



signature.asc
Description: Message signed with OpenPGP
___
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] Newbie Questions

2024-05-23 Thread David Cousens
Joe,

The IIF format is a TSV (tab separated format 
see 
https://quickbooks.intuit.com/learn-support/en-us/help-article/list-management/iif-overview-import-kit-sample-files-headers/L5CZIpJne_US_en_US
). You should be able to import them with the gnucash CSV importer
which has provision for changing the separator used from a "," to a tab
or any other character.

The CSV importer has a number of headers which define the data in
GnuCash. Setting up the importer will require identifying the
appropriate columns in the IIF file to which you assign the headers
and/or rearranging the IIF file into a format more suitable for CSV
import in GnuCash.   The easiest way to understand the format GnuCash
imports is to manually setup transactions of the type you wish to
import in gnuCash then export them in CSV format and examine the
exported file  ina text editor
See https://code.gnucash.org/docs/C/gnucash-manual/trans-import.html
for details on the importer.

You may also find additional information in this thread in the mailing
list archives
https://lists.gnucash.org/pipermail/gnucash-user/2008-March/024282.html

It may pay to work with a dummy set of books in Gnucash and practise
with the sample files in the IIF import kit in the reference above
before importing data into your current books.

You may also find this article helpful https://lwn.net/Articles/833616/
as it has some Python scripts. This seems to require a version of
GnuCash compiled with the Python bindings. 

David Cousens

On Thu, 2024-05-23 at 15:03 -0400, Joe Padavic wrote:
> I hadn't imported any Quickbook file to GNUCASH, but the "Welcome to
> GNUCASH" (splash page) wasn't showing up so I didn't know when to go
> to
> import the files. I eventually uninstalled the app and deleted the
> registry
> entry and the Welcome page is being displayed.
> [image: image.png]
> 
> My intentions are to convert personal checking/credit card accounts
> from
> Quicken and business data from Quickbooks. Having all transactions
> make
> Year End Tax Reporting for the business easier. Any comparisons from
> previous to current year would be helpful. This would hold true for
> budgeting purposes for personal accounts, also.
> 
> So the question remains - can I import the IIF files from Quickbooks
> and
> what files can be imported from Quicken?
> The first time I import my bank transactions, both business and
> personal,
> what date would these transactions start with?
> 
> 
> On Thu, May 23, 2024 at 1:52 PM R Losey  wrote:
> 
> > 
> > 
> > On Thu, May 23, 2024 at 11:45 AM Joe Padavic 
> > wrote:
> > 
> > > I have a few questions:
> > > 
> > > Is there a way to reset the splash page?
> > > I have Quickbook 2021 Pro.
> > > There aren't any QIF files, but I can create IIF files. Can these
> > > be used
> > > for importing into GNUCASH?
> > > If so, should I create individual IIF files for each type of file
> > > to
> > > import
> > > or can I select all files and create 1 IIF file?
> > > How do I import existing bank transactions (checking, Credit
> > > Card) from QB
> > > 2021?
> > > When I'm ready to import transactions from my back, where will
> > > the
> > > activity start?
> > > 
> > 
> > Welcome! (also, don't forget to do reply-all, not just reply)
> > 
> > I'm not sure what you mean by "reset the splash page"?  Do you want
> > to
> > show up again? Do you want to turn it off? Do you want to edit it?
> > I've
> > just left the splash page. If it can be turned off, there is
> > probably a
> > button to disable or enable it; you can have fun with the settings.
> > 
> > Regarding importing, consider if you need to do any importing. I
> > changed
> > from Quicken to Gnucash by ceasing to use Quicken and starting to
> > use
> > Gnucash. I figured that I could always run Quicken if I really
> > needed to
> > look something up, and I didn't (that's been some years ago).
> > However, if
> > you have stocks or mutual funds and you need to track gains/losses,
> > you may
> > need to import at least that data. I only had a few such items, so
> > I merely
> > hand-entered the transactions.
> > 
> > 
> > _
> > 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.

___
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] Newbie Questions

2024-05-23 Thread Mark at Lorimark

Hi Joe,

I'm likely stepping way out of my reach here, but,

Gnucash will not import from IIF, but you might have success if you can 
convert your IIF file to a CSV file.  Then you can import from that to 
GnuCash like you would if you had fetched a CSV file from your bank.


The 'transaction importer' is somewhat smart too that it can remember 
your associations...


That's me shooting from the hip, though.  I left quickbooks a few years 
ago, and while the GnuCash transition was a bit of a brain bender at 
times, what a reward!  Never looking back!  Trying to web-enable gnucash 
even, love the software!


When I left quickbooks I did not pull anything across, so I'm no help 
there.  As far as my transactions, I was able to import a bunch from my 
bank accounts, and the rest I just hand keyed, given it's just my tiny 
business, and plus that exercise helped me to become super familiar with 
the GnuCash interface, and how I wanted to set up accounts and all that.


I loaded my historical data back only a few years, to 2020, just so I 
could compare the most recent years... but, you can start from any date 
that makes sense to you.


~mark petryk
~w:http://www.lorimarksolutions.com

On 5/23/24 14:03, Joe Padavic wrote:

I hadn't imported any Quickbook file to GNUCASH, but the "Welcome to
GNUCASH" (splash page) wasn't showing up so I didn't know when to go to
import the files. I eventually uninstalled the app and deleted the registry
entry and the Welcome page is being displayed.
[image: image.png]

My intentions are to convert personal checking/credit card accounts from
Quicken and business data from Quickbooks. Having all transactions make
Year End Tax Reporting for the business easier. Any comparisons from
previous to current year would be helpful. This would hold true for
budgeting purposes for personal accounts, also.

So the question remains - can I import the IIF files from Quickbooks and
what files can be imported from Quicken?
The first time I import my bank transactions, both business and personal,
what date would these transactions start with?



___
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 works on clean install of Ubuntu 24.04

2024-05-23 Thread Mark at Lorimark

That's my understanding.

~mark petryk
~w:http://www.lorimarksolutions.com

On 5/23/24 13:24, John Ralls wrote:

Good that it works, I guess. Is the cause of the problem the broken Nvidia 
drivers?

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] GnuCash works on clean install of Ubuntu 24.04

2024-05-23 Thread John Ralls
Good that it works, I guess. Is the cause of the problem the broken Nvidia 
drivers?

Regards,
John Ralls


> On May 23, 2024, at 10:00, Mark at Lorimark  
> wrote:
> 
> Hey, run gnucash with this to get it to show reports;
> 
>> WEBKIT_DISABLE_COMPOSITING_MODE=1 gnucash
> 
> ~mark petryk
> ~w:http://www.lorimarksolutions.com
> 
> On 5/23/24 11:25, Bruce Griffis wrote:
>> I saw the message on GnuCash not working on an upgrade to Ubuntu 24.04.
>> Just wanted to say that it works on a fresh install. I wanted to go 24.04,
>> so did a fresh install than restored /home from backups. While that works,
>> if you have a lot of customized packages installed instead of just things
>> from the Ubuntu Software store or snaps - it can get hard to maintain. For
>> me, Rocksmith 2014 under Steam just doesn't work on 24.04 - so there are
>> broken things. But GnuCash was pretty cool (other than reports not
>> displaying).
> ___
> 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] Newbie Questions

2024-05-23 Thread R Losey
On Thu, May 23, 2024 at 11:45 AM Joe Padavic  wrote:

> I have a few questions:
>
> Is there a way to reset the splash page?
> I have Quickbook 2021 Pro.
> There aren't any QIF files, but I can create IIF files. Can these be used
> for importing into GNUCASH?
> If so, should I create individual IIF files for each type of file to import
> or can I select all files and create 1 IIF file?
> How do I import existing bank transactions (checking, Credit Card) from QB
> 2021?
> When I'm ready to import transactions from my back, where will the
> activity start?
>

Welcome! (also, don't forget to do reply-all, not just reply)

I'm not sure what you mean by "reset the splash page"?  Do you want to show
up again? Do you want to turn it off? Do you want to edit it? I've just
left the splash page. If it can be turned off, there is probably a button
to disable or enable it; you can have fun with the settings.

Regarding importing, consider if you need to do any importing. I changed
from Quicken to Gnucash by ceasing to use Quicken and starting to use
Gnucash. I figured that I could always run Quicken if I really needed to
look something up, and I didn't (that's been some years ago). However, if
you have stocks or mutual funds and you need to track gains/losses, you may
need to import at least that data. I only had a few such items, so I merely
hand-entered the transactions.


_
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] GnuCash works on clean install of Ubuntu 24.04

2024-05-23 Thread Mark at Lorimark

Hey, run gnucash with this to get it to show reports;


WEBKIT_DISABLE_COMPOSITING_MODE=1 gnucash


~mark petryk
~w:http://www.lorimarksolutions.com

On 5/23/24 11:25, Bruce Griffis wrote:

I saw the message on GnuCash not working on an upgrade to Ubuntu 24.04.
Just wanted to say that it works on a fresh install. I wanted to go 24.04,
so did a fresh install than restored /home from backups. While that works,
if you have a lot of customized packages installed instead of just things
from the Ubuntu Software store or snaps - it can get hard to maintain. For
me, Rocksmith 2014 under Steam just doesn't work on 24.04 - so there are
broken things. But GnuCash was pretty cool (other than reports not
displaying).


___
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] Cash in/cash out - debit/credit

2024-05-22 Thread Jim DeLaHunt

On 2024-05-22 18:07, Tinker Books wrote:


  -How can I change the column headers to read DEBIT CREDIT intsead of CASH
IN/CASHOUT


This is covered in the /GnuCash Manual/, section 10.2.2. *Accounts:*



It is an application preference. The relevant checkbox is labelled "Use 
formal accounting labels".


Best regards,
    —Jim DeLaHunt
___
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] Ubuntu 24.04 update -- problems

2024-05-22 Thread Stephen M. Butler
1.  Somehow, after the update, I had two PPA entries for mozilla team.  
Kenetic and mantic.  Kept the mantic:
    -rw-r--r-- 1 root root 10127 May 22 14:07 
mozillateam-ubuntu-ppa-kinetic.sources
    -rw-r--r-- 1 root root 9908 May 22 14:07 
mozillateam-ubuntu-ppa-mantic.sources


    That fixed the problem with software updater and also allowed sudo 
apt update work.


2.  Had to install the following packages after the upgrade (before I 
could rebuild GnC):

    libwebkit2gtk-4.0-37
    libwebkit2gtk-4.1
    libsecret-1-0
    libsecret-1-dev
    libboost-all-dev

    Took several attempts to get all the missing packages loaded back 
(and a lot of research to get the right names).


3.  I did a git pull before doing the rebuild so moved from 5.6-87 to 
5.6-150.


Stephen M Butler
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

On 5/22/24 14:32, Stephen M. Butler wrote:

Anybody on Ubuntu may want to wait a bit before upgrading o 24.04 LTS.

I just did the upgrade and GnuCash now fails to start with err:

gnucash: error while loading shared libraries:
libboost_locale.so.1.74.0: cannot open shared object file: No such
file or directory


Did a find command:

sudo find / -name libboost_locale.so.*
/usr/lib/x86_64-linux-gnu/libboost_locale.so.1.83.0


Attempted to rebuild gnucash and having make problems for webkit. The 
software updater is also broken (won't start).  So BEWARE, don't do 
the upgrade yet.


--Steve
--
Stephen M Butler
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
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] [gnc] Forecasting savings

2024-05-22 Thread Michael or Penny Novack

On 5/22/2024 1:48 AM, Adrien Laveau wrote:

Hello community, I would like to know what is the best way (if there is) to
project savings evolution in gnc based or scheduled transaction (income,
tax, average spending, loan etc...).

The goal is ti properly budget and know if at some time a more important
transaction is reasonable or not (install A/C, buy a car etc...)

Thank you


There are a number of ways. But before discussions about those that are 
only "on paper" we should discuss those that are "actual".


"actual" --- You have, or could have, more than one bank account 
(savings as well as checking) OR one of the special checking+savings 
accounts (I don't know exactly how that works, but a credit union I 
belong to offers it). In THAT case you would be tracking ACTUAL 
transactions putting money into the savings account (or later 
transferring back for one of those major purchases. Automation of 
transfers in depends on if the banks supports that. Even of you don't 
have a savings as well as checking account NOW, the question is "could 
you". Note that this approach enforces not spending from the savings 
reserve without explicit action on your part (transfer)


"paper" --- If you only have the one bank account and can't get another, 
you can "partition" that account in your books. In other words, a parent 
account for the full bank account under which children for current use 
and savings. This requires discipline as nothing would prevent you from 
writing a check that required dipping into savings. If you wanted 
separate savings accounts for future big purchases, you could partition 
the :savings" part the same way.


The budget module can be used for planning. That's what you would use 
for predicting things like "when will the A/C savings account reach $X". 
But note that the budget doesn't make it so (it doesn't enforce sticking 
to the budget)


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] Delete a trading account => crash

2024-05-22 Thread Kalpesh Patel
Ah, go to the contra cash account for the transaction and do it over there...
thanks for that tip! 

-- Original Message --
Received: Sun, 19 May 2024 05:38:58 PM EDT
From: Fred Tydeman 
To: Kalpesh Patel Cc: Gnucash Users

Subject: Re: [GNC] Delete a trading account => crash

> By mistake, I had two Asset accounts for the same stock, but with different
> spellings.
> That is what produced the two similar Trading accounts.
> 
> So, I ended up doing in the Cash account that did the buys and sells:
> In split view mode: change the stock asset account from one to the other,
> press Enter, that got me a popup to adjust the number of shares.
> Press Enter and all was fixed.
> 
> Doing that was a lot easier than deleting and re-entering the transactions.
> 
> When I was done, one stock asset account and one trading account were
> both empty, so could be deleted.  I also deleted the wrong spelling in the
> Security editor.
> 
> On Sun, May 19, 2024 at 9:28 AM Kalpesh Patel 
wrote:
> 
> > That is the behavior, sadly, where it goes back to what the original
> > transaction was. It is undesired but it is there and not likely to be
> > fixed.. (I run into it when I want to duplicate the transaction and then
> > just update the quantity)
> >
> > To get around, you technically have to enter the entire transaction from
> > beginning to end. Work around is to "modify" transaction is to open up
the
> > transaction, select first row from split view, go to first column
highlight
> > what is in it, copy it to clipboard, delete it, paste it from clipboard
> > (correct as you need to during this paste phase). Rinse-&-repeat for all
> > columns across for all rows in the transaction... you can minimize this
by
> > doing cut-&-paste to only the Shares, Buy and Sell columns and let it
> > calculate the Price column. It does get crazy when you have
multi-currency
> > enabled and/or are dividend reinvestment transactions ...
> >
> >
> > -Original Message-
> > From: Fred Tydeman 
> > Sent: Sunday, May 19, 2024 1:04 AM
> > To: Gnucash Users 
> > Subject: [GNC] Delete a trading account => crash
> >
> > Running GnuCash 4.14 on Fedora Linux.
> >
> > Due to a mistake on my part, I have two Trading accounts:
> >   IVR-PC
> >   IVRPRC
> > for the same security.
> >
> > First, I tried changing Trading:IVRPRC to Trading:IVR-PC in a Sell or Buy
> > transaction from the cash account. However, when I pressed Enter, Gnucash
> > undid my change.
> >
> > Then, I tried deleting Trading:IVRPRC account and moving its transactions
> > to Trading: IVR-PC.
> > That crashed Gnucash.
> >
> > I am now running a Check & Repair all (takes many minutes).
> >
> >
> >
> 


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


  1   2   3   4   5   6   7   8   9   10   >