Re: [GNC] Can't import .qif files from quicken since latest update

[Joseph Keithley]

QIF importer in Gnucash 5.6 gives me the same error for my credit card
import even though the same file works in Quicken and in Gnucash 5.5.  I
reinstalled Gnucash 5.5.

If I understand your comment corrrectly, the format of the qif file, with
and with the first lines of the sample qif file below, both import into
Gnucash 5.5.  The only difference is you don't have to tell Gnucash which
account to use, it is automatically specified in the first four lines.

!Account
NCredit Card Name
TCCard
^
!Type:CCard
Cc
D03/31/2024
MRestaurants
PStarbucks
T-9.53
^


On Sat, Apr 6, 2024 at 7:21 PM Fross, Michael via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Bryan, I believe "something" is purchased when you move money into an IRA.
> For me, it's a money market fund with the share price a constant $1.
>
> Michael
>
> On Sat, Apr 6, 2024 at 5:28 PM Bryan B.  wrote:
>
> > I've tried several different methods to export a .qif file from quicken
> and
> > import it into GnuCash.
> >
> > The process of importing the file goes fine until I reach the part where
> > the actual import occurs. Then I get this type of message:
> >
> > "Missing QIF investment action for transaction dated 08/31/2023."
> >
> > Upon investigation, it would seem that these transactions are from
> > automated transfers from my bank account to an IRA fund. I believe these
> > are money transfers, where the money is simply transferred without
> > explicitly purchasing a security, and then the security is purchased
> later.
> >
> > When I opened and examined the .qif file, and did some conversation with
> > ChatGPT-4, it would seem that I would have to put a line such as
> > "N***XIn***" for each of the offending transactions. I did try that, and
> > GnuCash still didn't accept those transactions (that I could see).
> >
> > Is anyone familiar with this problem already, or have any ideas on how to
> > solve 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.
>


-- 
iii
___
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] IRA conversion

[Fred Tydeman]

I assume that that Distributions account should be of type Income (not
Asset).

It appears that Income accounts cannot have a stock account type (so cannot
move stock via this method).
Would have to fake it by selling the stock (in 'from' account) to get cash,
move the cash, then buy the stock
(in the 'to' account).

Also, since X dollars come into Distributions and X dollars leave, the net
is zero.  So, any report would
show zero income.

I think a better solution is to use four splits:
  Cash or stock coming out of Regular IRA Asset account
  Cash or stock going into Roth IRA Asset account
  Cash going into a Distributions Income account
  Cash going into a dummy Expense account

Then, make sure to exclude the dummy Expense account in any reports.


On Sat, Apr 6, 2024 at 12:43 AM sunfis...@yahoo.com 
wrote:

> I am not really knowledgeable in this area (or many other areas, to be
> honest), but I found the following discussion (in a Quicken forum) that
> might lead you towards an answer:
> https://community.quicken.com/discussion/7931315/tax-summary-report-does-not-include-income-for-conversions-to-roth-ira
>
> My reading of that post suggests that you might first sell your regular
> IRA into a (taxable)  Distributions account. That would allow creation of
> any gains entries necessary. Then use the Distributions account to buy into
> the Roth.
>
> I'm sure others will inform me and you of the errors in my advice.
>
> David T.
> On Apr 6, 2024, at 8:02 AM, Fred Tydeman  wrote:
>>
>> Suggestions on how to record moving cash and stock from
>> a regular IRA to a Roth IRA so that a taxable event is recorded?
>> --
>>
>> 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] Multi-column reports- sort by acct code?

[Geoff]

I don't think so - there is nothing about sorting in the report options.

Geoff
=

On 7/04/2024 4:30 am, Chris Skudder wrote:

I usually do multi-column Statements of Activity and Position.
I have been using Custom Multicolumn because that sorts in order of 
Account Code.


Is there a way to sort the Income Statement-Multicolumn by acct code? 
That would save some time setting up the several reports.


Thanks very much,
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] Can't import .qif files from quicken since latest update

[Geoff]

I suspect this bug fix in the 5.6 release notes is the cause:

Bug 799225 - QIF Importer Crashes Silently after "Start Import" Button: 
Don't allow a QIF investment transaction without an action (buy/sell/etc)


I *think* it was intended to block *investment* transactions but it 
appears to have blocked *banking* transactions too?


Geoff
=

On 7/04/2024 11:44 am, Ian Cuthbertson wrote:

Bryan
This problem seems to be caused by the latest update (5.6) .I import
direct from a bank and got the same error message but when I used an
earlier version (5.4) transactions imported OK. Problem has been reported
in another thread.
Ian
___
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] Forgotten Splits

[David Carlson]

I think that the point Liz tried to make was a memorized transaction can be
designed to be a prototype that can be customized each time by edits that
are easy to make,
possibly more by deletions of unused splits than by adding splits.
Further, the memorized transactions can also be edited when they have
attributes that you don't expect to need again.

I also use the auto-competion feature frequently to fill in lines similar
to lines in previous transactions.

I don't have a problem with GnuCash failing to remember changes when I save
the file right away, or for certain user associated changes I need to close
the program to make those changes stick.

On Sat, Apr 6, 2024 at 9:39 PM David Carlson 
wrote:

> I don't understand.  Are you saying that splits are disappearing from your
> paycheck or from the record in GnuCash?
>
> On Sat, Apr 6, 2024 at 7:27 PM Phyllis Bruce  wrote:
>
>> Your electric bill splits will change every month.  Mine change once a
>> year so no, though that’s a good idea.   My main concern is that the splits
>> disappear. Hence gnu is not remembering them.  I would expect to need to
>> change them once and be done for another year.
>>
>> > On Apr 6, 2024, at 7:11 PM, Liz  wrote:
>> >
>> > On Sat, 6 Apr 2024 17:34:26 -0500
>> > Phyllis Bruce  wrote:
>> >
>> >> Just wanting to vent for a moment.  I have my income with multiple
>> >> splits in gnucash.  Works fine for a while but when they change,
>> >> gnucash forgets the new splits and the old ones.  I don't typically
>> >> open the imported transactions but noticed some missing from another
>> >> account and I have three months of splits to recreate.  bummer!
>> >
>> > For my electricity bill I have a scheduled transaction with four
>> > splits. Each of the amounts is blank, and I fill them in once the bill
>> > arrives.
>> > Would that be a useful way for you to account for your income splits?
>> >
>> > 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.
>>
>
>
> --
> David Carlson
>


-- 
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] Forgotten Splits

[David Carlson]

I don't understand.  Are you saying that splits are disappearing from your
paycheck or from the record in GnuCash?

On Sat, Apr 6, 2024 at 7:27 PM Phyllis Bruce  wrote:

> Your electric bill splits will change every month.  Mine change once a
> year so no, though that’s a good idea.   My main concern is that the splits
> disappear. Hence gnu is not remembering them.  I would expect to need to
> change them once and be done for another year.
>
> > On Apr 6, 2024, at 7:11 PM, Liz  wrote:
> >
> > On Sat, 6 Apr 2024 17:34:26 -0500
> > Phyllis Bruce  wrote:
> >
> >> Just wanting to vent for a moment.  I have my income with multiple
> >> splits in gnucash.  Works fine for a while but when they change,
> >> gnucash forgets the new splits and the old ones.  I don't typically
> >> open the imported transactions but noticed some missing from another
> >> account and I have three months of splits to recreate.  bummer!
> >
> > For my electricity bill I have a scheduled transaction with four
> > splits. Each of the amounts is blank, and I fill them in once the bill
> > arrives.
> > Would that be a useful way for you to account for your income splits?
> >
> > 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.
>


-- 
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] Can't import .qif files from quicken since latest update

[Ian Cuthbertson]

Bryan
This problem seems to be caused by the latest update (5.6) .I import
direct from a bank and got the same error message but when I used an
earlier version (5.4) transactions imported OK. Problem has been reported
in another thread.
Ian
___
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] QIF import broken on v5.6

[Ian Cuthbertson]

I am having the same problem with importing QIF files. Getting message "Missing
QIF investment action for transaction"
Went back to a previous version of GNUcash and imported 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] Forgotten Splits

[Phyllis Bruce]

Your electric bill splits will change every month.  Mine change once a year so 
no, though that’s a good idea.   My main concern is that the splits disappear. 
Hence gnu is not remembering them.  I would expect to need to change them once 
and be done for another year.

> On Apr 6, 2024, at 7:11 PM, Liz  wrote:
> 
> On Sat, 6 Apr 2024 17:34:26 -0500
> Phyllis Bruce  wrote:
> 
>> Just wanting to vent for a moment.  I have my income with multiple
>> splits in gnucash.  Works fine for a while but when they change,
>> gnucash forgets the new splits and the old ones.  I don't typically
>> open the imported transactions but noticed some missing from another
>> account and I have three months of splits to recreate.  bummer!
> 
> For my electricity bill I have a scheduled transaction with four
> splits. Each of the amounts is blank, and I fill them in once the bill
> arrives.
> Would that be a useful way for you to account for your income splits?
> 
> 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] Forgotten Splits

[Liz]

On Sat, 6 Apr 2024 17:34:26 -0500
Phyllis Bruce  wrote:

> Just wanting to vent for a moment.  I have my income with multiple
> splits in gnucash.  Works fine for a while but when they change,
> gnucash forgets the new splits and the old ones.  I don't typically
> open the imported transactions but noticed some missing from another
> account and I have three months of splits to recreate.  bummer!

For my electricity bill I have a scheduled transaction with four
splits. Each of the amounts is blank, and I fill them in once the bill
arrives. 
Would that be a useful way for you to account for your income splits?

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] Forgotten Splits

[David Carlson]

Phyllis,

I periodically assess, as you are doing now, whether there is a better
workflow to meet my personal needs.  My experience has been that the best
solution depends on specifics of the situation, which will change when the
bank changes their software, etc., hence it is very dynamic.  My solution
will be different than yours.



On Sat, Apr 6, 2024 at 5:35 PM Phyllis Bruce  wrote:

> Just wanting to vent for a moment.  I have my income with multiple splits
> in gnucash.  Works fine for a while but when they change, gnucash forgets
> the new splits and the old ones.  I don't typically open the imported
> transactions but noticed some missing from another account and I have three
> months of splits to recreate.  bummer!
>
> Something I've noticed in the import and reconciliation is that I spend
> time verifying some items before hitting finish. (what did I purchase on
> Amazon for X$?) However, then I have to look them up again to enter the
> info into my register.
> Has anyone found a better way to do this?  Should I import the transactions
> and just be sure I have zero variance?  Then deal with my notations?
>
> Thanks for you thoughts
> Phyllis B
> ___
> 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] Can't import .qif files from quicken since latest update

[Fross, Michael via gnucash-user]

Bryan, I believe "something" is purchased when you move money into an IRA.
For me, it's a money market fund with the share price a constant $1.

Michael

On Sat, Apr 6, 2024 at 5:28 PM Bryan B.  wrote:

> I've tried several different methods to export a .qif file from quicken and
> import it into GnuCash.
>
> The process of importing the file goes fine until I reach the part where
> the actual import occurs. Then I get this type of message:
>
> "Missing QIF investment action for transaction dated 08/31/2023."
>
> Upon investigation, it would seem that these transactions are from
> automated transfers from my bank account to an IRA fund. I believe these
> are money transfers, where the money is simply transferred without
> explicitly purchasing a security, and then the security is purchased later.
>
> When I opened and examined the .qif file, and did some conversation with
> ChatGPT-4, it would seem that I would have to put a line such as
> "N***XIn***" for each of the offending transactions. I did try that, and
> GnuCash still didn't accept those transactions (that I could see).
>
> Is anyone familiar with this problem already, or have any ideas on how to
> solve 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] check printing

[John Layman via gnucash-user]

Just to pick a nit: it was referred to as the MICR line (Magnetic Ink Character 
Recognition).  Kinda sounded like MITRE.

-Original Message-
From: gnucash-user  On 
Behalf Of David Carlson
Sent: Friday, April 5, 2024 11:15 AM
To: Andrea Bryant 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] check printing

Years ago (before electronic payments and deposits) I recall that it was 
possible to program GnuCash to print the MITRE line, as it used to be called, 
but you needed to use special magnetic ink so that check readers could read 
them reliably.  I imagine that it is still possible, but hardly necessary in 
the United States, anyway.  I think that you used to get the supplies from a 
company called Checksoft.  Back then banks weren't very cooperative because 
mistakes could wreak havoc in the clearing houses, and today they would be even 
less cooperative due to increased fraud concerns.
If you are really an alum of Southwest Bell, you are probably a U. S.
citizen and probably already using electronic deposits and payments, so I 
suspect that your interest may be mostly academic to show your grandchildren.



On Fri, Apr 5, 2024 at 5:08 AM Andrea Bryant 
wrote:

> I was wondering if you need to use a pre-printed check or can you use 
> blank check stock and have the routing and account numbers printed out 
> by GnuCash.
> --
> */Andrea Bryant/*
> ___
> 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.

___
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 Past email archives

[J R via gnucash-user]

 Got it, thanksI guess its like a google site search, omitting all the other 
results except the mailing list
On Saturday, April 6, 2024 at 06:15:22 PM EDT, Ken Farley 
 wrote:  
 
 I believe there is something on the mailing list site (the one 
referenced at the bottom of every message) that gives you a link for a 
"helper" Google search that is tailored to search the archives. I find 
it helpful to find "that answer I remember seeing that I can't for the 
life of me remember when" inquiries.

I, too, used to Nabble, but it's a dead one, now. A pity.
___
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.

[GNC] Forgotten Splits

[Phyllis Bruce]

Just wanting to vent for a moment.  I have my income with multiple splits
in gnucash.  Works fine for a while but when they change, gnucash forgets
the new splits and the old ones.  I don't typically open the imported
transactions but noticed some missing from another account and I have three
months of splits to recreate.  bummer!

Something I've noticed in the import and reconciliation is that I spend
time verifying some items before hitting finish. (what did I purchase on
Amazon for X$?) However, then I have to look them up again to enter the
info into my register.
Has anyone found a better way to do this?  Should I import the transactions
and just be sure I have zero variance?  Then deal with my notations?

Thanks for you thoughts
Phyllis B
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Can't import .qif files from quicken since latest update

[Bryan B.]

I've tried several different methods to export a .qif file from quicken and
import it into GnuCash.

The process of importing the file goes fine until I reach the part where
the actual import occurs. Then I get this type of message:

"Missing QIF investment action for transaction dated 08/31/2023."

Upon investigation, it would seem that these transactions are from
automated transfers from my bank account to an IRA fund. I believe these
are money transfers, where the money is simply transferred without
explicitly purchasing a security, and then the security is purchased later.

When I opened and examined the .qif file, and did some conversation with
ChatGPT-4, it would seem that I would have to put a line such as
"N***XIn***" for each of the offending transactions. I did try that, and
GnuCash still didn't accept those transactions (that I could see).

Is anyone familiar with this problem already, or have any ideas on how to
solve 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] GNC Past email archives

[Ken Farley]

I believe there is something on the mailing list site (the one 
referenced at the bottom of every message) that gives you a link for a 
"helper" Google search that is tailored to search the archives. I find 
it helpful to find "that answer I remember seeing that I can't for the 
life of me remember when" inquiries.


I, too, used to Nabble, but it's a dead one, now. A pity.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] GNC Past email archives

[J R via gnucash-user]

I found the archives and want to do some research on topics but they are 
monthly. There used to be Nabble a while back.Is there anything similar to 
search an entire year?
ThanksJimmy
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Multi-column reports- sort by acct code?

[Chris Skudder]

I usually do multi-column Statements of Activity and Position.
I have been using Custom Multicolumn because that sorts in order of 
Account Code.


Is there a way to sort the Income Statement-Multicolumn by acct code? 
That would save some time setting up the several reports.


Thanks very much,
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.

Re: [GNC] Finance Quotes Yahoo off the rails again?

[David G. Pickett via gnucash-user]

 That's a lot of crontab weirdness for a cosmetic bug of bad code or bad 
install, on top of the flatpak weirdness.  Maybe either there should be some 
command line option to direct Finance::Quotes to the right or unusual 
mechanisms, or Finance::Quotes should just check and move on silently, saving 
the status for part of a message if all run configurations are discovered not 
viable at the end?

The snap installed apps seem more normal, but then I do not run them from cron 
or the command line.  It'd be nicest if the latest GnuCash updates could be 
distributed through normal Ubuntu/Linux Software channels.  I guess they are 
not "Long Term Stable"?  Life on the bleeding edge!  At least once a week, I am 
running "flatpak update -y", "snap refresh", "Software Updater" (obsolescent 
but seems to install stuff that "Software" "Updates" tab wants to install with 
a reboot), and finally "Software" "Updates" tab.

The time of the quote fetch might be a busy time, but I want it after I go to 
bed and before I start clamscan, which is very cpu and file intense.  Of 
course, it has to be after the markets close at 4 Eastern, but the Mutual Fund 
admins sometimes take a while to post their NAVs.  I have to wait a day to get 
Fidelity captive security quotes from their website for some of my 401Ks.  I am 
not sure my quote updates get the NAV or the last or what, but it is just an 
approximation for Net Worth reports of unrealized gain.



On Friday, April 5, 2024 at 01:09:35 PM EDT, Bruce Schuck 
 wrote:  
 
 On 4/5/24 8:50 AM, David G. Pickett wrote:

> The quotes were fetched despite these usual errors, so it is only a 
> cosmetic error.

>  > 2024-04-03 23:45:06 Removed any lck, adding price quotes
>  > flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes get --
>  > /home/dgp/GnuCash/ubuntu-DGPickett.gnucash
>  > F: X11 socket /tmp/.X11-unix/X0 does not exist in filesystem, 
trying to
>  > use abstract socket instead.
>
>  > ** (process:102885): WARNING **: 23:45:07.118: Failed to connect 
to bus:
>  > Could not connect: Connection refused
>  > Found Finance::Quote version 1.59.
>
> This error is from Flatpak. Could be related to this thread:
>
> https://github.com/flatpak/flatpak/issues/938
> 

Possibly. I noticed this in the GnuCash technical reference 
(https://gnucash.org/docs/v5/C/gnucash-manual.pdf):

=
On Linux if there is no graphic session that has already started the 
dbus, running on your
computer at the time of the quote request, you must do the entry as 
follows instead:

0 16 * * 5 env `dbus-launch` sh -c 'trap "kill $DBUS_SESSION_BUS_PID" EXIT;
gnucash-cli --quotes get ${HOME}/gnucash-filename > /dev/null 2>&1=

For *its and giggles, change the time of your cron job to an hour or so 
before or after 23:45.

Still, I have not been able to duplicate the issue on an Ubuntu 22.04 
virtual machine (VirtualBox) and the current stable Flatpak GnuCash 5.6 
(Build ID: Flathub 5.6-1). I'm running the update every hour.

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] check printing

[fliegersonic.net]

There will always be non-digital methods of payment.  I use preprinted checks 
with GnuCash and my only issue is 
that I haven't figured out how to associate an address with a payee - I'm sure 
it's there, but

I will hate it if we can no longer use checks because transacting in cash is 
possible but inconvenient.

Jim

On 6 Apr 2024 at 19:12, Liz wrote:

> On Fri, 5 Apr 2024 22:02:39 -0500
> Andrea  wrote:
> 
> >Actually, it's not academic. There are still many workers in
> >the US that want a check payment once the work is done. Right now
> >I have a printer with MICR ink that does print routing and
> >account numbers.
> > I print from different bank accounts, so it is so easy to print
> > checks on blank stock and have the different bank information
> > printed in MICR. I would like to find a software that can do that or
> > integrate with a check printing software.
> > 
> >Andrea
> > 
> 
> It will be just academic.
> NZ (New Zealand, Aotearoa) ceased using them in 2021.
> Australia promises to be cheque free by 2030.
> My bank in Au will stop accepting cheques from this May.
> 
> Sometimes the USA is world leading, and sometimes not.
> 
> 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] Security not showing up in Price Database

[Murugan Muruganandam]

can you send the security editor screen shot and account screen shot for both 
to review




Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of 
David Warren 
Sent: Friday, April 5, 2024 6:00 PM
To: gnucash-user@gnucash.org 
Subject: [GNC] Security not showing up in Price Database

Hi.  I am a reasonably new (last 6 months) user of gnucash.  I am using
version 5.3 on Windows 10.  I am not getting online quotes but I own
various *private *securities, for which I manually enter prices, either in
the register as I make capital calls or receive distributions, or in the
Price Database itself, when the Fund manager tells me the valuation has
changed.  I own two funds from the same manager and I created Securities
for them on the same dates when I first set up gnucash.  I created both
(let's call them XYZ Fund 1 and XYZ Fund 2) in the same Namespace that I
called Private Funds.  I named the two securities XYZ Fund 1 and XYZ Fund
2.  I created (fake) symbols and display symbols for them, which, again,
are XYZ Fund 1 and XYZ Fund 2.  I have been entering transaction for each
for the last few months and both appear priced/valued correctly (with the
correct # of shares and the correct valuation) in the Accounts tab.

The issue is that while both securities appear in the Tools/Securities
Editor, only XYZ Fund 1 appears in the Tools/Price Database.  I've looked
carefully and didn't mis-name one into the wrong Namespace or anything else
I can see.  Any ideas why this might happen and how to fix?

Much appreciated...
___
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] check printing

[Liz]

On Fri, 5 Apr 2024 22:02:39 -0500
Andrea  wrote:

>Actually, it’s not academic. There are still many workers in the US
>that want a check payment once the work is done. Right now I have a
>printer with MICR ink that does print routing and account numbers.
> I print from different bank accounts, so it is so easy to print
> checks on blank stock and have the different bank information printed
> in MICR. I would like to find a software that can do that or
> integrate with a check printing software.
> 
>Andrea
> 

It will be just academic.
NZ (New Zealand, Aotearoa) ceased using them in 2021.
Australia promises to be cheque free by 2030.
My bank in Au will stop accepting cheques from this May.

Sometimes the USA is world leading, and sometimes not.

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] check printing

[Andrea]

   Thanks for responding. I print checks from more than I bank. I have
   MICR ink and a software that prints checks. That’s why I would like to
   find a software or software integration that will print routing and
   account numbers on checks. My banks are ok with it and I’ve never had a
   problem. Many workers want to a check after they have finished their
   work.

   Andrea

 On Apr 5, 2024, at 10:19 AM, R Losey  wrote:

   
   While things may have changed, many years ago when I worked in the
   bank, the info at the bottom of the check was printed with a special
   ink (I think they called it a magnetic ink) so that the routing and
   account numbers could be scanned by a computer.  The rest of the check
   is regular printing.
   Moreover, I suspect that the banks don't like people being able to
   print an entire check, as a small tweat of an account number might pull
   the money from the wrong account.
   On Fri, Apr 5, 2024 at 5:08 AM Andrea Bryant
   <[1]andreabry...@swbell.net> wrote:

 I was wondering if you need to use a pre-printed check or can you
 use
 blank check stock and have the routing and account numbers printed
 out
 by GnuCash.
 --
 */Andrea Bryant/*
 ___
 gnucash-user mailing list
 [2]gnucash-user@gnucash.org
 To update your subscription preferences or to unsubscribe:
 [3]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
   [4]rlo...@gmail.com
   Micah 6:8

References

   1. mailto:andreabry...@swbell.net
   2. mailto:gnucash-user@gnucash.org
   3. https://lists.gnucash.org/mailman/listinfo/gnucash-user
   4. mailto:rlo...@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.

Re: [GNC] check printing

[Andrea]

   Actually, it’s not academic. There are still many workers in the US
   that want a check payment once the work is done. Right now I have a
   printer with MICR ink that does print routing and account numbers. I
   print from different bank accounts, so it is so easy to print checks on
   blank stock and have the different bank information printed in MICR. I
   would like to find a software that can do that or integrate with a
   check printing software.

   Andrea

 On Apr 5, 2024, at 10:15 AM, David Carlson
  wrote:

   
   Years ago (before electronic payments and deposits) I recall that it
   was possible to program GnuCash to print the MITRE line, as it used to
   be called, but you needed to use special magnetic ink so that check
   readers could read them reliably.  I imagine that it is still possible,
   but hardly necessary in the United States, anyway.  I think that you
   used to get the supplies from a company called Checksoft.  Back then
   banks weren't very cooperative because mistakes could wreak havoc in
   the clearing houses, and today they would be even less cooperative due
   to increased fraud concerns.  If you are really an alum of Southwest
   Bell, you are probably a U. S. citizen and probably already using
   electronic deposits and payments, so I suspect that your interest may
   be mostly academic to show your grandchildren.
   On Fri, Apr 5, 2024 at 5:08 AM Andrea Bryant
   <[1]andreabry...@swbell.net> wrote:

 I was wondering if you need to use a pre-printed check or can you
 use
 blank check stock and have the routing and account numbers printed
 out
 by GnuCash.
 --
 */Andrea Bryant/*
 ___
 gnucash-user mailing list
 [2]gnucash-user@gnucash.org
 To update your subscription preferences or to unsubscribe:
 [3]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

References

   1. mailto:andreabry...@swbell.net
   2. mailto:gnucash-user@gnucash.org
   3. https://lists.gnucash.org/mailman/listinfo/gnucash-user
___
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] IRA conversion

[sunfish62--- via gnucash-user]

I am not really knowledgeable in this area (or many other areas, to be honest), 
but I found the following discussion (in a Quicken forum) that might lead you 
towards an answer: 
https://community.quicken.com/discussion/7931315/tax-summary-report-does-not-include-income-for-conversions-to-roth-ira

My reading of that post suggests that you might first sell your regular IRA 
into a (taxable)  Distributions account. That would allow creation of any gains 
entries necessary. Then use the Distributions account to buy into the Roth. 

I'm sure others will inform me and you of the errors in my advice. 

⁣David T. ​

On Apr 6, 2024, 8:02 AM, at 8:02 AM, Fred Tydeman  
wrote:
>Suggestions on how to record moving cash and stock from
>a regular IRA to a Roth IRA so that a taxable event is recorded?
>___
>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] check printing

[greg]

Hmmm, I don't do "electronic" payments or deposits.  But thenn, I've 
never been hacked ;)  MICR is still a thing because The Fed requires 
it.  Lots of MICR toner cartridges for sale online.  I have 2 MICR toner 
cartridges that came with a printer I bought via a local Craigslist.


-greg schmitz

On 4/5/24 07:14, David Carlson wrote:

Years ago (before electronic payments and deposits) I recall that it was
possible to program GnuCash to print the MITRE line, as it used to be
called, but you needed to use special magnetic ink so that check readers
could read them reliably.  I imagine that it is still possible, but hardly
necessary in the United States, anyway.  I think that you used to get the
supplies from a company called Checksoft.  Back then banks weren't very
cooperative because mistakes could wreak havoc in the clearing houses, and
today they would be even less cooperative due to increased fraud concerns.
If you are really an alum of Southwest Bell, you are probably a U. S.
citizen and probably already using electronic deposits and payments, so I
suspect that your interest may be mostly academic to show your
grandchildren.



On Fri, Apr 5, 2024 at 5:08 AM Andrea Bryant 
wrote:


I was wondering if you need to use a pre-printed check or can you use
blank check stock and have the routing and account numbers printed out
by GnuCash.
--
*/Andrea Bryant/*
___
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] QIF import "Unspecified" transaction

[Joseph Keithley]

Your response was a little too deep for my question.  I simply want to type
in "Expense:Entertainment:Restaurant:Tip" instead of scrolling to the
Expense item then clicking on a triangle then scrolling to the
Enterntainment item then clicking on that triangle then scrolling to the
Restaurant item then clicking on that triangle then scrolling to the Tip
item and then highlighting it and then closing the window.  Which is
exactly what Quicken does and it is much faster than surfing all my
accounts, items and categories with a mouse.  If the account doesn't exist
I want to be asked, just like Gnucash and Quicken both do now, to add an
account/item. This feature already exists in Gnucash in individual account
register when entering a transaction.  Why can't this feature also exist in
the QIF importer?

On Fri, Apr 5, 2024 at 9:17 AM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

> On 4/5/2024 6:43 AM, Joseph Keithley wrote:
> > When importing a QIF in the "Match payees/memos to GnuCash accounts"
> > window, an "Unspecified" transaction will be listed under "GnuCash
> account
> > name".  When you double click on the item, a window pops up that lets you
> > scroll
> > through the different "accounts" and assign the item to a specific one.
> >
> > Is there some way to just type in the account name directly instead of
> > surfing around with the mouse?
>
> Perhaps not. As a retired senior systems analyst/senior business analyst
> I can see a very good reason requiring you to select from the list of
> existing accounts.
>
> Answer this question --- if free entry of an account name were allowed,
> what would you want the system to do if the string of characters you
> typed in were NOT the name of an existing account? Do you want it to
> give you an error message at that point? Do you want it to not let you
> enter an invalid character*? Is introducing this error process (and how
> user recovers) worth the complication of the user's work flow?
>
> Michael D Novack
>
> * That's possible because the set of existing accounts can be expressed
> as a tree structure with the nth level of the tree being the possible
> nth characters. So this is like the nth character entered causing the
> "not (yet) in dictionary" of the Lempel-Ziv algorithm. Notice that even
> this "not letting you" would, have issues. because as a user, how do you
> know "well what character am I allowed to enter?"
>
>
> --
> 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.
>


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