Re: [GNC] Issues with Payables

[Adrien Monteleone]

Yeah, can't do that.

Right click the transaction and use 'Edit Payment' to change the date. 
That way the 'Business Features' will be cognizant of the change.


To fix the existing transactions' "no owner" problem, you'll also likely 
need to re-select the proper document they apply to.


Regards,
Adrien

On 5/3/22 1:36 AM, cyberfores...@gmail.com wrote:

I knew there was something I was omitting from my question...

What I have done is create the invoice and then subsequently process
the payment or receipt against the invoice.   I have then noticed that
I have entered the receipt or payment date incorrectly and then changed
the date in the Bank Account Register.

On Mon, 2022-05-02 at 21:24 -0500, Adrien Monteleone wrote:

How are you entering these payments? That should be done with the
'Process Payments' feature where you select the document
(bill/invoice)
to be paid, enter a payment amount, and select the source/destination
account.

For existing transactions you can right-click them and choose Edit
Payment to assign it properly.

If you are importing the payment transactions you'll have to 'Edit
Payment' for each one after import.

Regards,
Adrien

On 5/2/22 3:18 AM, Grant Alexander wrote:

I am having problems figuring out how to solve the following
How to I correct the error messages "Payment has no owner and
Invalid
Txn Type?

Likewise with the Receivable Aging


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Change layout and font sizes in Transaction Report - how?

[Adrien Monteleone]

Export the report. The format is HTML, then you can examine it with a 
text editor and/or open it in a browser and use its inspector.


Alternatively, just open it in a spreadsheet app and manipulate it from 
there.


Regards,
Adrien

On 5/4/22 5:40 AM, Chris Green wrote:

The Transaction Report probably provides the information that my
auditor wants by listing each account's transactions in order and
giving the total amount below each account.

However the formatting and font sizes seem a little odd and I'd like
to change them if I can.

I have two fairly simple requirements:-

 Increase the space below "Total for " before the
 name of the next account appears.

 Increase the font size for the account name that appears at the
 top of each account's transactions.  As it is at present it's just
 in the default small size used for all the 'body' text and so the
 name doesn't stand out to indicate the start of the next account.


I can 'do' CSS but there don't seem to be any obvious selectors for
the items I want to change.  Is there any detailed description of what
selectors are available in the CSS stylesheet?



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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 one save report option defaults?

[Adrien Monteleone]

No there is not unfortunately.

I've seen it discussed and there is probably an RFE filed on it.

Regards,
Adrien

On 5/4/22 9:31 AM, Chris Green wrote:

I find I nearly always change the same five or six report options
every time I want a new report.  For example I nearly always want to
select all accounts (at least initially) and I want the secondary sort
key to be Date.

Is there any way I can set up GnuCash so the report options always
start with the values I want?



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] QFX file for Bank of American business account not invoking Import Matcher

[Jean L]

You launch GC with the --debug flag. If you're on MacOS, you have to go 
to a console, find the path to your Gnucash, then do 
GnucashApp/contents/MacOs/Gnucash/Gnucash --debug (from memory, so I'm 
sure some of this is wrong)


Same idea on windows and linux, launch from the command line with the 
--debug flag.


J


On 5/4/2022 8:23 PM, Peter Wu wrote:


@Jean Laroche , can you send some 
instructions on how to run the debug mode?


I have another QFX file from BofA too.  It failed even after I remove 
CARDNUM, CARDNAME and MCC elements.


I suspect there are more invalid tags in this file.

Btw, the sample file I give you worked after removing above three tags.

Best,

Peter

*From: *gnucash-user 
 on behalf 
of Jean Laroche 

*Date: *Wednesday, May 4, 2022 at 09:52
*To: *gnucash-user@gnucash.org 
*Subject: *Re: [GNC] QFX file for Bank of American business account 
not invoking Import Matcher


Running gnucash with --debug shows what the issue is.

Removing the lines that contain the CARDNUM, CARDNAME and MCC elements
makes the file import correctly.
I'm not sure why ofxlib does not just ignore the unrecognized elements,
but that's the way it is.
Perhaps file a bug with libofx?

Jean

LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:39:13:E: 


element "CARDNUM" undefined

(Above message occurred on Line 39, Column 14)
  X ERROR: startElement: incoming_data should be empty! You are
probably using OpenSP <= 1.3.4.  The following data was lost: -50.00
(Above message occurred on Line 39, Column 6)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:40:14:E: 


element "CARDNAME" undefined

(Above message occurred on Line 40, Column 15)
  X ERROR: startElement: incoming_data should be empty! You are
probably using OpenSP <= 1.3.4.  The following data was lost: 9767
(Above message occurred on Line 40, Column 6)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:41:9:E:
element "MCC" undefined



On 5/4/22 8:38 AM, Peter Wu wrote:
> Hi David C,
>
> It is all new transactions.  If it is previously imported 
transaction, it would give a error dialog saying no new transaction.

>
> But for the given QFX, it just does nothing after you click okay to 
import the file.

>
> By the way, I am using the latest Mac OS on latest Gnucash version.
>
> Should I reply all with email or just reply to the mailing list?
>
> Best,
> Peter
>
> From: David Carlson 
> Date: Wednesday, May 4, 2022 at 08:30
> To: Peter Wu 
> Cc: stepbystepf...@comcast.net , Gnucash 
Users 
> Subject: Re: [GNC] QFX file for Bank of American business account 
not invoking Import Matcher
> If your file already contains a transaction that was previously 
imported with the same reference number, Gnucash does not import it again.

>
> On Wed, May 4, 2022, 9:11 AM David Carlson 
mailto:david.carlson@gmail.com>> wrote:
> Probably, but you do not explain what happens or doesn't happen when 
you click on "Import OFX/QFX"?  Are you able to see the filename and 
select it?  Is there an error message?

>
> On Wed, May 4, 2022 at 9:03 AM Peter Wu 
mailto:peter_cd...@hotmail.com>> wrote:

> Quote:
> What is your reasoning to expect THAT (data intended for some sort 
of bookkeeping that is NOT double entry bookkeeping) to be correct 
data for gnucash

>
> For personal account checking or credit card. It is the same user 
flow, use the web connect for quicken 2018 or above download a qfx 
file and everything works fine.

>
> I would expect this biz credit to work too. They are from the same 
institution and UI flow is the same.

>
> Somehow the downloaded qfx won’t work. I attached the file in the 
first email.

>
> I used a diff checker to check personal qfx and biz credit card qfx. 
Inside the file, keys are different.

>
> Is it because how gnucash is parsing the file?
>
> Thanks,
> Peter
>
> Sent from my iPhone
>
>> On May 4, 2022, at 6:47 AM, Michael or Penny Novack 
mailto:stepbystepf...@comcast.net>> wrote:

>>
>> What is your reasoning to expect THAT (data intended for some sort 
of bookkeeping that is NOT double entry bookkeeping) to be correct 
data for 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
> If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists 
 for more information.

> -
> 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
> gnucas

Re: [GNC] QFX file for Bank of American business account not invoking Import Matcher

[Peter Wu]

@Jean Laroche, can you send some instructions on how 
to run the debug mode?

I have another QFX file from BofA too.  It failed even after I remove CARDNUM, 
CARDNAME and MCC elements.

I suspect there are more invalid tags in this file.

Btw, the sample file I give you worked after removing above three tags.

Best,
Peter

From: gnucash-user  
on behalf of Jean Laroche 
Date: Wednesday, May 4, 2022 at 09:52
To: gnucash-user@gnucash.org 
Subject: Re: [GNC] QFX file for Bank of American business account not invoking 
Import Matcher
Running gnucash with --debug shows what the issue is.

Removing the lines that contain the CARDNUM, CARDNAME and MCC elements
makes the file import correctly.
I'm not sure why ofxlib does not just ignore the unrecognized elements,
but that's the way it is.
Perhaps file a bug with libofx?

Jean

LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:39:13:E:
element "CARDNUM" undefined

(Above message occurred on Line 39, Column 14)
  X ERROR: startElement: incoming_data should be empty! You are
probably using OpenSP <= 1.3.4.  The following data was lost: -50.00
(Above message occurred on Line 39, Column 6)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:40:14:E:
element "CARDNAME" undefined

(Above message occurred on Line 40, Column 15)
  X ERROR: startElement: incoming_data should be empty! You are
probably using OpenSP <= 1.3.4.  The following data was lost: 9767
(Above message occurred on Line 40, Column 6)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:41:9:E:
element "MCC" undefined



On 5/4/22 8:38 AM, Peter Wu wrote:
> Hi David C,
>
> It is all new transactions.  If it is previously imported transaction, it 
> would give a error dialog saying no new transaction.
>
> But for the given QFX, it just does nothing after you click okay to import 
> the file.
>
> By the way, I am using the latest Mac OS on latest Gnucash version.
>
> Should I reply all with email or just reply to the mailing list?
>
> Best,
> Peter
>
> From: David Carlson 
> Date: Wednesday, May 4, 2022 at 08:30
> To: Peter Wu 
> Cc: stepbystepf...@comcast.net , Gnucash Users 
> 
> Subject: Re: [GNC] QFX file for Bank of American business account not 
> invoking Import Matcher
> If your file already contains a transaction that was previously imported with 
> the same reference number,  Gnucash does not import it again.
>
> On Wed, May 4, 2022, 9:11 AM David Carlson 
> mailto:david.carlson@gmail.com>> wrote:
> Probably, but you do not explain what happens or doesn't happen when you 
> click on "Import OFX/QFX"?  Are you able to see the filename and select it?  
> Is there an error message?
>
> On Wed, May 4, 2022 at 9:03 AM Peter Wu 
> mailto:peter_cd...@hotmail.com>> wrote:
> Quote:
> What is your reasoning to expect THAT (data intended for some sort of 
> bookkeeping that is NOT double entry bookkeeping) to be correct data for 
> gnucash
>
> For personal account checking or credit card. It is the same user flow, use 
> the web connect for quicken 2018 or above download a qfx file and everything 
> works fine.
>
> I would expect this biz credit to work too. They are from the same 
> institution and UI flow is the same.
>
> Somehow the downloaded qfx won’t work. I attached the file in the first email.
>
> I used a diff checker to check personal qfx and biz credit card qfx. Inside 
> the file, keys are different.
>
> Is it because how gnucash is parsing the file?
>
> Thanks,
> Peter
>
> Sent from my iPhone
>
>> On May 4, 2022, at 6:47 AM, Michael or Penny Novack 
>> mailto:stepbystepf...@comcast.net>> wrote:
>>
>> What is your reasoning to expect THAT (data intended for some sort of 
>> bookkeeping that is NOT double entry bookkeeping) to be correct data for 
>> 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
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

Re: [GNC] QFX file for Bank of American business account not

[Peter Wu]

Or I think like Jen was saying, ignore custom tags and don’t import the value.  
Only import stander values, and do not raise exception.

It is raising exception and cause the consumer(gnucash) to fail.

Best,
peter

From: gnucash-user  
on behalf of David Carlson 
Date: Wednesday, May 4, 2022 at 19:48
To: David Reiser 
Cc: Gnucash Users 
Subject: Re: [GNC] QFX file for Bank of American business account not
I agree, Libofx doesn't need to go down that rabbit hole, but it could
throw an error message if it finds that rabbit hole.

On Wed, May 4, 2022 at 9:12 PM David Reiser via gnucash-user <
gnucash-user@gnucash.org> wrote:

> The three tags in question are not valid OFX tags, which means they are
> custom to either QFX  or BofA. I’d seriously doubt libofx would be willing
> to get into trying to maintain custom tags.
> --
> Dave Reiser
> dbrei...@icloud.com
>
>
>
>
>
> > On May 4, 2022, at 9:49 PM, davidcousen...@gmail.com wrote:
> >
> >
> >
> > The other possibility if libofx supports the credit card tags  would be
> to give
> > users the option of having the different card numbers recognized as
> subaccounts
> > of the main credit card account .  If libofx doesn't support it it is
> unlikely
> > much can be done other than raising it as an issue with the libofx
> developer(s).
> > Once it is in libofx then GnuCash can be modified to recognize the
> situation.
> >
> > David Cousens
> >
> > On Wed, 2022-05-04 at 20:01 -0500, David Carlson wrote:
> >> Perhaps there should be a GnuCash error message if libofx fails.
> >>
> >> On Wed, May 4, 2022, 4:41 PM Jean Laroche  wrote:
> >>
> >>> Don't know if my last messages went through. Here they are again:
> >>>
> >>> Running gnucash with --debug shows what the issue is.
> >>>
> >>> Removing the lines that contain the CARDNUM, CARDNAME and MCC elements
> >>> makes the file import correctly.
> >>> I'm not sure why ofxlib does not just ignore the unrecognized elements,
> >>> but that's the way it is.
> >>> Perhaps file a bug with libofx?
> >>>
> >>> In the meantime, if you're on a linux box or a mac and you're familiar
> >>> with linux commands, you can use the command line to strip the ofx file
> >>> from the offending lines using sed, for example on the mac:
> >>>
> >>> cat stmt.qfx | sed -E "/ stmt_fixed.qfx
> >>>
> >>> I'm not a sed guru, so maybe there's a better/more robust way to do it.
> >>> But this should give you a temporary solution?
> >>>
> >>> Jean
> >>>
> >>> LibOFX ERROR: OpenSP parser: otherError (misc parse error):
> >>>
> /var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:39:13:E:
> >>> element "CARDNUM" undefined
> >>>
> >>> (Above message occurred on Line 39, Column 14)
> >>>  X ERROR: startElement: incoming_data should be empty! You are
> >>> probably using OpenSP <= 1.3.4.  The following data was lost: -50.00
> >>> (Above message occurred on Line 39, Column 6)
> >>> LibOFX ERROR: OpenSP parser: otherError (misc parse error):
> >>>
> /var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:40:14:E:
> >>> element "CARDNAME" undefined
> >>>
> >>> (Above message occurred on Line 40, Column 15)
> >>>  X ERROR: startElement: incoming_data should be empty! You are
> >>> probably using OpenSP <= 1.3.4.  The following data was lost: 9767
> >>> (Above message occurred on Line 40, Column 6)
> >>> LibOFX ERROR: OpenSP parser: otherError (misc parse error):
> >>>
> /var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:41:9:E:
> >>> element "MCC" undefined
> >>>
> >>>
> >>>
> >>>
> >>> On 5/4/22 2:24 PM, Kalpesh Patel wrote:
>  I did experimented with the file he has attached and I can concur that
> >>> OFX
>  matcher is bailing out, or more likely silently exiting as if it was
> NOP.
>  This is most likely an OFX import bug.
> 
> 
> 
>  If you start a fresh new file with just the 'Common Accounts' and then
>  import the ofx file that was originally attached to the e-mail, GNC
> 4.10
> >>> on
>  Windows 10 prompts to create a new account which it does with 'Unknown
> >>> OFX
>  credit card account "Credit card 4003901016729673"' account name and
> then
>  there is no subsequent dialogue box to import the single transaction
> >>> that is
>  in that file. It exit with the effect that you cancelled the import
> after
>  creating the account. If I reimport the file again then there is
> nothing
>  displayed, -- nothing;  nada --,  such as error messages or the
> >>> notification
>  windows that one transaction was found and that it was a duplicate. It
> >>> once
>  again simply silently exits and goes back if like no "import" was
> >>> performed
>  at all or cancelled. I don't see the transaction getting added to the
>  register either.
> 
> 
> 
> 
> 
> 
> 
>  --
> 
> 
> 
>  Message: 12
> 
>  Date: Wed, 4 May 2022 03:25:25 +
> 
>  From: Peter Wu  peter

Re: [GNC] QFX file for Bank of American business account not

[David Carlson]

I agree, Libofx doesn't need to go down that rabbit hole, but it could
throw an error message if it finds that rabbit hole.

On Wed, May 4, 2022 at 9:12 PM David Reiser via gnucash-user <
gnucash-user@gnucash.org> wrote:

> The three tags in question are not valid OFX tags, which means they are
> custom to either QFX  or BofA. I’d seriously doubt libofx would be willing
> to get into trying to maintain custom tags.
> --
> Dave Reiser
> dbrei...@icloud.com
>
>
>
>
>
> > On May 4, 2022, at 9:49 PM, davidcousen...@gmail.com wrote:
> >
> >
> >
> > The other possibility if libofx supports the credit card tags  would be
> to give
> > users the option of having the different card numbers recognized as
> subaccounts
> > of the main credit card account .  If libofx doesn't support it it is
> unlikely
> > much can be done other than raising it as an issue with the libofx
> developer(s).
> > Once it is in libofx then GnuCash can be modified to recognize the
> situation.
> >
> > David Cousens
> >
> > On Wed, 2022-05-04 at 20:01 -0500, David Carlson wrote:
> >> Perhaps there should be a GnuCash error message if libofx fails.
> >>
> >> On Wed, May 4, 2022, 4:41 PM Jean Laroche  wrote:
> >>
> >>> Don't know if my last messages went through. Here they are again:
> >>>
> >>> Running gnucash with --debug shows what the issue is.
> >>>
> >>> Removing the lines that contain the CARDNUM, CARDNAME and MCC elements
> >>> makes the file import correctly.
> >>> I'm not sure why ofxlib does not just ignore the unrecognized elements,
> >>> but that's the way it is.
> >>> Perhaps file a bug with libofx?
> >>>
> >>> In the meantime, if you're on a linux box or a mac and you're familiar
> >>> with linux commands, you can use the command line to strip the ofx file
> >>> from the offending lines using sed, for example on the mac:
> >>>
> >>> cat stmt.qfx | sed -E "/ stmt_fixed.qfx
> >>>
> >>> I'm not a sed guru, so maybe there's a better/more robust way to do it.
> >>> But this should give you a temporary solution?
> >>>
> >>> Jean
> >>>
> >>> LibOFX ERROR: OpenSP parser: otherError (misc parse error):
> >>>
> /var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:39:13:E:
> >>> element "CARDNUM" undefined
> >>>
> >>> (Above message occurred on Line 39, Column 14)
> >>>  X ERROR: startElement: incoming_data should be empty! You are
> >>> probably using OpenSP <= 1.3.4.  The following data was lost: -50.00
> >>> (Above message occurred on Line 39, Column 6)
> >>> LibOFX ERROR: OpenSP parser: otherError (misc parse error):
> >>>
> /var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:40:14:E:
> >>> element "CARDNAME" undefined
> >>>
> >>> (Above message occurred on Line 40, Column 15)
> >>>  X ERROR: startElement: incoming_data should be empty! You are
> >>> probably using OpenSP <= 1.3.4.  The following data was lost: 9767
> >>> (Above message occurred on Line 40, Column 6)
> >>> LibOFX ERROR: OpenSP parser: otherError (misc parse error):
> >>>
> /var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:41:9:E:
> >>> element "MCC" undefined
> >>>
> >>>
> >>>
> >>>
> >>> On 5/4/22 2:24 PM, Kalpesh Patel wrote:
>  I did experimented with the file he has attached and I can concur that
> >>> OFX
>  matcher is bailing out, or more likely silently exiting as if it was
> NOP.
>  This is most likely an OFX import bug.
> 
> 
> 
>  If you start a fresh new file with just the 'Common Accounts' and then
>  import the ofx file that was originally attached to the e-mail, GNC
> 4.10
> >>> on
>  Windows 10 prompts to create a new account which it does with 'Unknown
> >>> OFX
>  credit card account "Credit card 4003901016729673"' account name and
> then
>  there is no subsequent dialogue box to import the single transaction
> >>> that is
>  in that file. It exit with the effect that you cancelled the import
> after
>  creating the account. If I reimport the file again then there is
> nothing
>  displayed, -- nothing;  nada --,  such as error messages or the
> >>> notification
>  windows that one transaction was found and that it was a duplicate. It
> >>> once
>  again simply silently exits and goes back if like no "import" was
> >>> performed
>  at all or cancelled. I don't see the transaction getting added to the
>  register either.
> 
> 
> 
> 
> 
> 
> 
>  --
> 
> 
> 
>  Message: 12
> 
>  Date: Wed, 4 May 2022 03:25:25 +
> 
>  From: Peter Wu  peter_cd...@hotmail.com>
> 
> 
>  To: "gnucash-user@gnucash.org  "
>  mailto:gnucash-user@gnucash.org> >
> 
>  Subject: [GNC] QFX file for Bank of American business account not
> 
>  invoking Import Matcher
> 
>  Message-ID:
> 
> 
> 
> >>>
>   OM
>   >>> dm8p221mb05727f95859d29b4d429f0a4c2...@dm8p221mb0572

Re: [GNC] QFX file for Bank of American business account not

[David Reiser via gnucash-user]

The three tags in question are not valid OFX tags, which means they are custom 
to either QFX  or BofA. I’d seriously doubt libofx would be willing to get into 
trying to maintain custom tags.
--
Dave Reiser
dbrei...@icloud.com





> On May 4, 2022, at 9:49 PM, davidcousen...@gmail.com wrote:
> 
> 
> 
> The other possibility if libofx supports the credit card tags  would be to 
> give
> users the option of having the different card numbers recognized as 
> subaccounts
> of the main credit card account .  If libofx doesn't support it it is unlikely
> much can be done other than raising it as an issue with the libofx 
> developer(s).
> Once it is in libofx then GnuCash can be modified to recognize the situation.
> 
> David Cousens
> 
> On Wed, 2022-05-04 at 20:01 -0500, David Carlson wrote:
>> Perhaps there should be a GnuCash error message if libofx fails.
>> 
>> On Wed, May 4, 2022, 4:41 PM Jean Laroche  wrote:
>> 
>>> Don't know if my last messages went through. Here they are again:
>>> 
>>> Running gnucash with --debug shows what the issue is.
>>> 
>>> Removing the lines that contain the CARDNUM, CARDNAME and MCC elements
>>> makes the file import correctly.
>>> I'm not sure why ofxlib does not just ignore the unrecognized elements,
>>> but that's the way it is.
>>> Perhaps file a bug with libofx?
>>> 
>>> In the meantime, if you're on a linux box or a mac and you're familiar
>>> with linux commands, you can use the command line to strip the ofx file
>>> from the offending lines using sed, for example on the mac:
>>> 
>>> cat stmt.qfx | sed -E "/ stmt_fixed.qfx
>>> 
>>> I'm not a sed guru, so maybe there's a better/more robust way to do it.
>>> But this should give you a temporary solution?
>>> 
>>> Jean
>>> 
>>> LibOFX ERROR: OpenSP parser: otherError (misc parse error):
>>> /var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:39:13:E:
>>> element "CARDNUM" undefined
>>> 
>>> (Above message occurred on Line 39, Column 14)
>>>  X ERROR: startElement: incoming_data should be empty! You are
>>> probably using OpenSP <= 1.3.4.  The following data was lost: -50.00
>>> (Above message occurred on Line 39, Column 6)
>>> LibOFX ERROR: OpenSP parser: otherError (misc parse error):
>>> /var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:40:14:E:
>>> element "CARDNAME" undefined
>>> 
>>> (Above message occurred on Line 40, Column 15)
>>>  X ERROR: startElement: incoming_data should be empty! You are
>>> probably using OpenSP <= 1.3.4.  The following data was lost: 9767
>>> (Above message occurred on Line 40, Column 6)
>>> LibOFX ERROR: OpenSP parser: otherError (misc parse error):
>>> /var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:41:9:E:
>>> element "MCC" undefined
>>> 
>>> 
>>> 
>>> 
>>> On 5/4/22 2:24 PM, Kalpesh Patel wrote:
 I did experimented with the file he has attached and I can concur that
>>> OFX
 matcher is bailing out, or more likely silently exiting as if it was NOP.
 This is most likely an OFX import bug.
 
 
 
 If you start a fresh new file with just the 'Common Accounts' and then
 import the ofx file that was originally attached to the e-mail, GNC 4.10
>>> on
 Windows 10 prompts to create a new account which it does with 'Unknown
>>> OFX
 credit card account "Credit card 4003901016729673"' account name and then
 there is no subsequent dialogue box to import the single transaction
>>> that is
 in that file. It exit with the effect that you cancelled the import after
 creating the account. If I reimport the file again then there is nothing
 displayed, -- nothing;  nada --,  such as error messages or the
>>> notification
 windows that one transaction was found and that it was a duplicate. It
>>> once
 again simply silently exits and goes back if like no "import" was
>>> performed
 at all or cancelled. I don't see the transaction getting added to the
 register either.
 
 
 
 
 
 
 
 --
 
 
 
 Message: 12
 
 Date: Wed, 4 May 2022 03:25:25 +
 
 From: Peter Wu mailto:peter_cd...@hotmail.com>
 
 
 To: "gnucash-user@gnucash.org  "
 mailto:gnucash-user@gnucash.org> >
 
 Subject: [GNC] QFX file for Bank of American business account not
 
 invoking Import Matcher
 
 Message-ID:
 
 
 
>>> >>> OM
 >> dm8p221mb05727f95859d29b4d429f0a4c2...@dm8p221mb0572.namp221.prod.ou
 TLOOK.COM> >
 
 
 
 Content-Type: text/plain; charset="windows-1252"
 
 
 
 Hello,
 
 Gnucash community.  Hope everyone is doing well and having a good time.
>>> Two
 questions:
 
 
 
 
 
   1.  Beside the mailing-list.  Does anyone know a forum where we can
>>> ask
 and discuss issues?  I feel it may be easier to search/discuss/answer
 questions 

Re: [GNC] QFX file for Bank of American business account not

[davidcousens49]

The other possibility if libofx supports the credit card tags  would be to give
users the option of having the different card numbers recognized as subaccounts
of the main credit card account .  If libofx doesn't support it it is unlikely
much can be done other than raising it as an issue with the libofx developer(s).
Once it is in libofx then GnuCash can be modified to recognize the situation.

David Cousens

On Wed, 2022-05-04 at 20:01 -0500, David Carlson wrote:
> Perhaps there should be a GnuCash error message if libofx fails.
> 
> On Wed, May 4, 2022, 4:41 PM Jean Laroche  wrote:
> 
> > Don't know if my last messages went through. Here they are again:
> > 
> > Running gnucash with --debug shows what the issue is.
> > 
> > Removing the lines that contain the CARDNUM, CARDNAME and MCC elements
> > makes the file import correctly.
> > I'm not sure why ofxlib does not just ignore the unrecognized elements,
> > but that's the way it is.
> > Perhaps file a bug with libofx?
> > 
> > In the meantime, if you're on a linux box or a mac and you're familiar
> > with linux commands, you can use the command line to strip the ofx file
> > from the offending lines using sed, for example on the mac:
> > 
> > cat stmt.qfx | sed -E "/ stmt_fixed.qfx
> > 
> > I'm not a sed guru, so maybe there's a better/more robust way to do it.
> > But this should give you a temporary solution?
> > 
> > Jean
> > 
> > LibOFX ERROR: OpenSP parser: otherError (misc parse error):
> > /var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:39:13:E:
> > element "CARDNUM" undefined
> > 
> > (Above message occurred on Line 39, Column 14)
> >   X ERROR: startElement: incoming_data should be empty! You are
> > probably using OpenSP <= 1.3.4.  The following data was lost: -50.00
> > (Above message occurred on Line 39, Column 6)
> > LibOFX ERROR: OpenSP parser: otherError (misc parse error):
> > /var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:40:14:E:
> > element "CARDNAME" undefined
> > 
> > (Above message occurred on Line 40, Column 15)
> >   X ERROR: startElement: incoming_data should be empty! You are
> > probably using OpenSP <= 1.3.4.  The following data was lost: 9767
> > (Above message occurred on Line 40, Column 6)
> > LibOFX ERROR: OpenSP parser: otherError (misc parse error):
> > /var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:41:9:E:
> > element "MCC" undefined
> > 
> > 
> > 
> > 
> > On 5/4/22 2:24 PM, Kalpesh Patel wrote:
> > > I did experimented with the file he has attached and I can concur that
> > OFX
> > > matcher is bailing out, or more likely silently exiting as if it was NOP.
> > > This is most likely an OFX import bug.
> > > 
> > > 
> > > 
> > > If you start a fresh new file with just the 'Common Accounts' and then
> > > import the ofx file that was originally attached to the e-mail, GNC 4.10
> > on
> > > Windows 10 prompts to create a new account which it does with 'Unknown
> > OFX
> > > credit card account "Credit card 4003901016729673"' account name and then
> > > there is no subsequent dialogue box to import the single transaction
> > that is
> > > in that file. It exit with the effect that you cancelled the import after
> > > creating the account. If I reimport the file again then there is nothing
> > > displayed, -- nothing;  nada --,  such as error messages or the
> > notification
> > > windows that one transaction was found and that it was a duplicate. It
> > once
> > > again simply silently exits and goes back if like no "import" was
> > performed
> > > at all or cancelled. I don't see the transaction getting added to the
> > > register either.
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > --
> > > 
> > > 
> > > 
> > > Message: 12
> > > 
> > > Date: Wed, 4 May 2022 03:25:25 +
> > > 
> > > From: Peter Wu mailto:peter_cd...@hotmail.com>
> > > 
> > > 
> > > To: "gnucash-user@gnucash.org  "
> > > mailto:gnucash-user@gnucash.org> >
> > > 
> > > Subject: [GNC] QFX file for Bank of American business account not
> > > 
> > >  invoking Import Matcher
> > > 
> > > Message-ID:
> > > 
> > > 
> > > 
> >  > > OM
> > >  > dm8p221mb05727f95859d29b4d429f0a4c2...@dm8p221mb0572.namp221.prod.ou
> > > TLOOK.COM> >
> > > 
> > > 
> > > 
> > > Content-Type: text/plain; charset="windows-1252"
> > > 
> > > 
> > > 
> > > Hello,
> > > 
> > > Gnucash community.  Hope everyone is doing well and having a good time.
> > Two
> > > questions:
> > > 
> > > 
> > > 
> > > 
> > > 
> > >1.  Beside the mailing-list.  Does anyone know a forum where we can
> > ask
> > > and discuss issues?  I feel it may be easier to search/discuss/answer
> > > questions than a mailing list.
> > > 
> > >2.  As the email subject says.  Attached qfx file does not work.  I
> > have
> > > personal Bank of American checking and credit card.  They all work.  I
> > > downloaded the file by using the ?Web Connect for Quicken 2018

Re: [GNC] QFX file for Bank of American business account not

[David Carlson]

Perhaps there should be a GnuCash error message if libofx fails.

On Wed, May 4, 2022, 4:41 PM Jean Laroche  wrote:

> Don't know if my last messages went through. Here they are again:
>
> Running gnucash with --debug shows what the issue is.
>
> Removing the lines that contain the CARDNUM, CARDNAME and MCC elements
> makes the file import correctly.
> I'm not sure why ofxlib does not just ignore the unrecognized elements,
> but that's the way it is.
> Perhaps file a bug with libofx?
>
> In the meantime, if you're on a linux box or a mac and you're familiar
> with linux commands, you can use the command line to strip the ofx file
> from the offending lines using sed, for example on the mac:
>
> cat stmt.qfx | sed -E "/ stmt_fixed.qfx
>
> I'm not a sed guru, so maybe there's a better/more robust way to do it.
> But this should give you a temporary solution?
>
> Jean
>
> LibOFX ERROR: OpenSP parser: otherError (misc parse error):
> /var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:39:13:E:
> element "CARDNUM" undefined
>
> (Above message occurred on Line 39, Column 14)
>   X ERROR: startElement: incoming_data should be empty! You are
> probably using OpenSP <= 1.3.4.  The following data was lost: -50.00
> (Above message occurred on Line 39, Column 6)
> LibOFX ERROR: OpenSP parser: otherError (misc parse error):
> /var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:40:14:E:
> element "CARDNAME" undefined
>
> (Above message occurred on Line 40, Column 15)
>   X ERROR: startElement: incoming_data should be empty! You are
> probably using OpenSP <= 1.3.4.  The following data was lost: 9767
> (Above message occurred on Line 40, Column 6)
> LibOFX ERROR: OpenSP parser: otherError (misc parse error):
> /var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:41:9:E:
> element "MCC" undefined
>
>
>
>
> On 5/4/22 2:24 PM, Kalpesh Patel wrote:
> > I did experimented with the file he has attached and I can concur that
> OFX
> > matcher is bailing out, or more likely silently exiting as if it was NOP.
> > This is most likely an OFX import bug.
> >
> >
> >
> > If you start a fresh new file with just the 'Common Accounts' and then
> > import the ofx file that was originally attached to the e-mail, GNC 4.10
> on
> > Windows 10 prompts to create a new account which it does with 'Unknown
> OFX
> > credit card account "Credit card 4003901016729673"' account name and then
> > there is no subsequent dialogue box to import the single transaction
> that is
> > in that file. It exit with the effect that you cancelled the import after
> > creating the account. If I reimport the file again then there is nothing
> > displayed, -- nothing;  nada --,  such as error messages or the
> notification
> > windows that one transaction was found and that it was a duplicate. It
> once
> > again simply silently exits and goes back if like no "import" was
> performed
> > at all or cancelled. I don't see the transaction getting added to the
> > register either.
> >
> >
> >
> >
> >
> >
> >
> > --
> >
> >
> >
> > Message: 12
> >
> > Date: Wed, 4 May 2022 03:25:25 +
> >
> > From: Peter Wu mailto:peter_cd...@hotmail.com>
> >
> >
> > To: "gnucash-user@gnucash.org  "
> > mailto:gnucash-user@gnucash.org> >
> >
> > Subject: [GNC] QFX file for Bank of American business account not
> >
> >  invoking Import Matcher
> >
> > Message-ID:
> >
> >
> >
>  > OM
> >  dm8p221mb05727f95859d29b4d429f0a4c2...@dm8p221mb0572.namp221.prod.ou
> > TLOOK.COM> >
> >
> >
> >
> > Content-Type: text/plain; charset="windows-1252"
> >
> >
> >
> > Hello,
> >
> > Gnucash community.  Hope everyone is doing well and having a good time.
> Two
> > questions:
> >
> >
> >
> >
> >
> >1.  Beside the mailing-list.  Does anyone know a forum where we can
> ask
> > and discuss issues?  I feel it may be easier to search/discuss/answer
> > questions than a mailing list.
> >
> >2.  As the email subject says.  Attached qfx file does not work.  I
> have
> > personal Bank of American checking and credit card.  They all work.  I
> > downloaded the file by using the ?Web Connect for Quicken 2018 and
> above?.
> >
> >
> >
> > I have a suspicion why it is not working.  Maybe it is because a combined
> > qfx file.  BofA organized their business account in a group fashion.
> They
> > made a parent account and each credit card holder as a child account.
> Their
> > personal account doesn?t follow this parent-child account structure.
> >
> >
> >
> > Does anyone has a solution for this kind of qfx file?
> >
> >
> >
> > Best,
> >
> > Peter
> >
> >
> >
> >
> >
> >
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/M

Re: [GNC] Is there a way to handle same-named GnuCash files sensibly?

[Michael or Penny Novack]

Yes, I noticed too that there a files with a number added to the base
name, e.g.:-

 building.gnucash.gcm
 building.gnucash_2.gcm

... but I'm not sure that it's a perfect system.

I have reverted to having the year as part of the file name and a
wrapper script that finds the data file corresponding to the year
directory I'm in.

UH ... just because you as a human consider abcd and abcd_3 to be the 
same name misses the point that they ARE different file names as far as 
the computer is concerned, as different as you consider Fred and Freda 
different names


However, including the year in the name when in fact these are :the same 
file except for a different year is an EXCELLENT way to go


Michael D Novack


--
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] QFX file for Bank of American business account not

[Jean Laroche]

Don't know if my last messages went through. Here they are again:

Running gnucash with --debug shows what the issue is.

Removing the lines that contain the CARDNUM, CARDNAME and MCC elements 
makes the file import correctly.
I'm not sure why ofxlib does not just ignore the unrecognized elements, 
but that's the way it is.

Perhaps file a bug with libofx?

In the meantime, if you're on a linux box or a mac and you're familiar 
with linux commands, you can use the command line to strip the ofx file 
from the offending lines using sed, for example on the mac:


cat stmt.qfx | sed -E "/ stmt_fixed.qfx

I'm not a sed guru, so maybe there's a better/more robust way to do it. 
But this should give you a temporary solution?


Jean

LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:39:13:E: 
element "CARDNUM" undefined


(Above message occurred on Line 39, Column 14)
 X ERROR: startElement: incoming_data should be empty! You are 
probably using OpenSP <= 1.3.4.  The following data was lost: -50.00

(Above message occurred on Line 39, Column 6)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:40:14:E: 
element "CARDNAME" undefined


(Above message occurred on Line 40, Column 15)
 X ERROR: startElement: incoming_data should be empty! You are 
probably using OpenSP <= 1.3.4.  The following data was lost: 9767

(Above message occurred on Line 40, Column 6)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:41:9:E: 
element "MCC" undefined





On 5/4/22 2:24 PM, Kalpesh Patel wrote:

I did experimented with the file he has attached and I can concur that OFX
matcher is bailing out, or more likely silently exiting as if it was NOP.
This is most likely an OFX import bug.

  


If you start a fresh new file with just the 'Common Accounts' and then
import the ofx file that was originally attached to the e-mail, GNC 4.10 on
Windows 10 prompts to create a new account which it does with 'Unknown OFX
credit card account "Credit card 4003901016729673"' account name and then
there is no subsequent dialogue box to import the single transaction that is
in that file. It exit with the effect that you cancelled the import after
creating the account. If I reimport the file again then there is nothing
displayed, -- nothing;  nada --,  such as error messages or the notification
windows that one transaction was found and that it was a duplicate. It once
again simply silently exits and goes back if like no "import" was performed
at all or cancelled. I don't see the transaction getting added to the
register either.

  

  

  


--

  


Message: 12

Date: Wed, 4 May 2022 03:25:25 +

From: Peter Wu mailto:peter_cd...@hotmail.com> >

To: "gnucash-user@gnucash.org  "
mailto:gnucash-user@gnucash.org> >

Subject: [GNC] QFX file for Bank of American business account not

 invoking Import Matcher

Message-ID:

  

OM
 >

 


Content-Type: text/plain; charset="windows-1252"

  


Hello,

Gnucash community.  Hope everyone is doing well and having a good time.  Two
questions:

  

  


   1.  Beside the mailing-list.  Does anyone know a forum where we can ask
and discuss issues?  I feel it may be easier to search/discuss/answer
questions than a mailing list.

   2.  As the email subject says.  Attached qfx file does not work.  I have
personal Bank of American checking and credit card.  They all work.  I
downloaded the file by using the ?Web Connect for Quicken 2018 and above?.

  


I have a suspicion why it is not working.  Maybe it is because a combined
qfx file.  BofA organized their business account in a group fashion.  They
made a parent account and each credit card holder as a child account.  Their
personal account doesn?t follow this parent-child account structure.

  


Does anyone has a solution for this kind of qfx file?

  


Best,

Peter

  

  

  


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember

Re: [GNC] QFX file for Bank of American business account not

[Kalpesh Patel]

I did experimented with the file he has attached and I can concur that OFX
matcher is bailing out, or more likely silently exiting as if it was NOP.
This is most likely an OFX import bug.

 

If you start a fresh new file with just the 'Common Accounts' and then
import the ofx file that was originally attached to the e-mail, GNC 4.10 on
Windows 10 prompts to create a new account which it does with 'Unknown OFX
credit card account "Credit card 4003901016729673"' account name and then
there is no subsequent dialogue box to import the single transaction that is
in that file. It exit with the effect that you cancelled the import after
creating the account. If I reimport the file again then there is nothing
displayed, -- nothing;  nada --,  such as error messages or the notification
windows that one transaction was found and that it was a duplicate. It once
again simply silently exits and goes back if like no "import" was performed
at all or cancelled. I don't see the transaction getting added to the
register either. 

 

 

 

--

 

Message: 12

Date: Wed, 4 May 2022 03:25:25 +

From: Peter Wu mailto:peter_cd...@hotmail.com> >

To: "gnucash-user@gnucash.org  "
mailto:gnucash-user@gnucash.org> >

Subject: [GNC] QFX file for Bank of American business account not

invoking Import Matcher

Message-ID:

 
mailto:dm8p221mb05727f95859d29b4d429f0a4c2...@dm8p221mb0572.namp221.prod.ou
TLOOK.COM> >



Content-Type: text/plain; charset="windows-1252"

 

Hello,

Gnucash community.  Hope everyone is doing well and having a good time.  Two
questions:

 

 

  1.  Beside the mailing-list.  Does anyone know a forum where we can ask
and discuss issues?  I feel it may be easier to search/discuss/answer
questions than a mailing list.

  2.  As the email subject says.  Attached qfx file does not work.  I have
personal Bank of American checking and credit card.  They all work.  I
downloaded the file by using the ?Web Connect for Quicken 2018 and above?.

 

I have a suspicion why it is not working.  Maybe it is because a combined
qfx file.  BofA organized their business account in a group fashion.  They
made a parent account and each credit card holder as a child account.  Their
personal account doesn?t follow this parent-child account structure.

 

Does anyone has a solution for this kind of qfx file?

 

Best,

Peter

 

 

 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Is there a way to handle same-named GnuCash files sensibly?

[Derek Atkins]

Back in antiquity, GnuCash would encode the full path of the data file
into the metadata file, but that meant that if you moved the data file in
any way, GnuCash would lose track of the metadata belonging to it...

-derek

On Wed, May 4, 2022 4:02 pm, Chris Green wrote:
> On Wed, May 04, 2022 at 09:26:51PM +0200, Geert Janssens wrote:
>> Op dinsdag 3 mei 2022 18:37:20 CEST schreef Chris Green:
>> > GnuCash names files in ~/.local/share/gnucash/books according to the
>> > filename of the GnuCash data file.  This is a bit of a problem for me
>> > because I expect to be able to have multiple GnuCash data files with
>> > the same name in different places.
>> >
>> In theory gnucash should be able to handle this. If the file name
>> already exists in the books
>> directory, gnucash will create the new file in there with a number
>> appended to the name. To
>> find the proper file in book matching the building.gnucash file you just
>> opened, it uses a
>> unique book guid that's stored inside each of the files in the books
>> directory. I don't know
>> however how these unique id's are generated or how their uniqueness is
>> guaranteed. So
>> depending on how you make new gnucash files for each year, this may or
>> may not work.
>>
> Yes, I noticed too that there a files with a number added to the base
> name, e.g.:-
>
> building.gnucash.gcm
> building.gnucash_2.gcm
>
> ... but I'm not sure that it's a perfect system.
>
> I have reverted to having the year as part of the file name and a
> wrapper script that finds the data file corresponding to the year
> directory I'm in.
>
> I.e. if I'm in directory /home/chris/pcc/2021 and I run the wrapper
> script 'gnc' it will run gnucash with data file general2021.gnucash.
> It seems pretty much OK so far and saves a lot of typing of long names.
>
>
> --
> 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
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Is there a way to handle same-named GnuCash files sensibly?

[Chris Green]

On Wed, May 04, 2022 at 09:26:51PM +0200, Geert Janssens wrote:
> Op dinsdag 3 mei 2022 18:37:20 CEST schreef Chris Green:
> > GnuCash names files in ~/.local/share/gnucash/books according to the
> > filename of the GnuCash data file.  This is a bit of a problem for me
> > because I expect to be able to have multiple GnuCash data files with
> > the same name in different places.
> > 
> In theory gnucash should be able to handle this. If the file name already 
> exists in the books 
> directory, gnucash will create the new file in there with a number appended 
> to the name. To 
> find the proper file in book matching the building.gnucash file you just 
> opened, it uses a 
> unique book guid that's stored inside each of the files in the books 
> directory. I don't know 
> however how these unique id's are generated or how their uniqueness is 
> guaranteed. So 
> depending on how you make new gnucash files for each year, this may or may 
> not work.
> 
Yes, I noticed too that there a files with a number added to the base
name, e.g.:-

building.gnucash.gcm
building.gnucash_2.gcm

... but I'm not sure that it's a perfect system.

I have reverted to having the year as part of the file name and a
wrapper script that finds the data file corresponding to the year
directory I'm in.

I.e. if I'm in directory /home/chris/pcc/2021 and I run the wrapper
script 'gnc' it will run gnucash with data file general2021.gnucash.
It seems pretty much OK so far and saves a lot of typing of long names.


-- 
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Is there a way to handle same-named GnuCash files sensibly?

[Geert Janssens]

Op dinsdag 3 mei 2022 18:37:20 CEST schreef Chris Green:
> GnuCash names files in ~/.local/share/gnucash/books according to the
> filename of the GnuCash data file.  This is a bit of a problem for me
> because I expect to be able to have multiple GnuCash data files with
> the same name in different places.
> 
In theory gnucash should be able to handle this. If the file name already 
exists in the books 
directory, gnucash will create the new file in there with a number appended to 
the name. To 
find the proper file in book matching the building.gnucash file you just 
opened, it uses a 
unique book guid that's stored inside each of the files in the books directory. 
I don't know 
however how these unique id's are generated or how their uniqueness is 
guaranteed. So 
depending on how you make new gnucash files for each year, this may or may not 
work.

Regards,

Geert
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Scheduled transaction: double-prompting for a variable

[Stan Brown]

Please disregard. I must have been doing something wrong when I tried
this before. Just now, in a copy of my database, I tried again, and it
worked just fine: I got only one prompt.

-- 
Stan Brown
Tehachapi, CA, USA
https://BrownMath.com

On 2022-05-04 09:30, Stan Brown wrote:
> My mortgage payment is a scheduled transaction of three splits:
> Credit: Cash and Banks (always the same amount)
> Debit:  Expenses:Mortgage Interest (variable)
> Debit:  Liabilities:Home Mortgage (variable)
> 
> I set the transaction up with Interest set to a variable and Home
> Mortgage set to the unvarying payment amount minus the variable
> mentioned in Interest. But when the transaction fires, I get prompted
> separately for each occurrence of the same variable. Have I missed
> something, or is this just how it works?
> 
> I'm running GC 2.6.19, so maybe the behavior was changed in later versions?

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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 Value in Scheduled transaction

[Fred Tydeman]

I assume you mean Edit Scheduled Transaction: Template Transaction.
The transaction has two splits:
  Income:Dividends:...:$MKT   Credit formula is 5.
  Assets:Investments:...:$MKT  Debit formula is 5.

On Wed, May 4, 2022 at 9:21 AM Fred Bone  wrote:

> On 04 May 2022 at 8:48, Fred J. Tydeman said:
>
> > When I start Gnucash and there are scheduled transactions to be run,
> > the window that pops up takes me to a dividend reinvest transaction
> > and says it needs a value.  That is confusing in that it is unknown what
> > value is it asking for:  Shares, Price, Buy. It appears to be Price, but
> I
> > was expecting it to be Shares.
>
> Can you not inspect the relevant SX in the SX Editor?
>
> For all my SXs that require input at create time I can look at the
> template and see which entries require input.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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 Value in Scheduled transaction

[Fred Tydeman]

I believe this is what I did to create the scheduled transaction:
In a money market investment account,
with an existing month end reinvest of dividends transaction,
Right click  => popup menu
Left click on Schedule
Left click on OK


On Wed, May 4, 2022 at 9:02 AM Derek Atkins  wrote:

> It is where-ever you put the variable into the SX.  Without knowing how
> you entered it, it's impossible to know what it's actually asking for.
> But I would expect it to only ask for #shares or total value -- the price
> is not stored in GnuCash and is always computed.
>
> -derek
>
> On Wed, May 4, 2022 10:48 am, Fred J. Tydeman wrote:
> > When I start Gnucash and there are scheduled transactions to be run,
> > the window that pops up takes me to a dividend reinvest transaction
> > and says it needs a value.  That is confusing in that it is unknown what
> > value is it asking for:  Shares, Price, Buy.
> > It appears to be Price, but I was expecting it to be Shares.
> >
> >
> > ---
> > Fred J. TydemanTydeman Consulting
> > tyde...@tybor.com  Testing, numerics, programming
> > +1 (702) 608-6093  Vice-chair of PL22.11 (ANSI "C")
> > Sample C99+FPCE tests: http://www.tybor.com
> > Savers sleep well, investors eat well, spenders work forever.
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] QFX file for Bank of American business account not invoking Import Matcher

[Jean Laroche]

In the meantime, if you're on a linux box or a mac and you're familiar 
with linux commands, you can use the command line to strip the ofx file 
from the offending lines using sed, for example on the mac:


cat stmt.qfx | sed -E "/ stmt_fixed.qfx

I'm not a sed guru, so maybe there's a better/more robust way to do it. 
But this should give you a temporary solution?


Jean

On 5/4/22 9:51 AM, Jean Laroche wrote:

Running gnucash with --debug shows what the issue is.

Removing the lines that contain the CARDNUM, CARDNAME and MCC elements 
makes the file import correctly.
I'm not sure why ofxlib does not just ignore the unrecognized 
elements, but that's the way it is.

Perhaps file a bug with libofx?

Jean

LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:39:13:E: 
element "CARDNUM" undefined


(Above message occurred on Line 39, Column 14)
 X ERROR: startElement: incoming_data should be empty! You are 
probably using OpenSP <= 1.3.4.  The following data was lost: -50.00

(Above message occurred on Line 39, Column 6)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:40:14:E: 
element "CARDNAME" undefined


(Above message occurred on Line 40, Column 15)
 X ERROR: startElement: incoming_data should be empty! You are 
probably using OpenSP <= 1.3.4.  The following data was lost: 9767

(Above message occurred on Line 40, Column 6)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:41:9:E: 
element "MCC" undefined




On 5/4/22 8:38 AM, Peter Wu wrote:

Hi David C,

It is all new transactions.  If it is previously imported 
transaction, it would give a error dialog saying no new transaction.


But for the given QFX, it just does nothing after you click okay to 
import the file.


By the way, I am using the latest Mac OS on latest Gnucash version.

Should I reply all with email or just reply to the mailing list?

Best,
Peter

From: David Carlson 
Date: Wednesday, May 4, 2022 at 08:30
To: Peter Wu 
Cc: stepbystepf...@comcast.net , Gnucash 
Users 
Subject: Re: [GNC] QFX file for Bank of American business account not 
invoking Import Matcher
If your file already contains a transaction that was previously 
imported with the same reference number,  Gnucash does not import it 
again.


On Wed, May 4, 2022, 9:11 AM David Carlson 
mailto:david.carlson@gmail.com>> wrote:
Probably, but you do not explain what happens or doesn't happen when 
you click on "Import OFX/QFX"?  Are you able to see the filename and 
select it?  Is there an error message?


On Wed, May 4, 2022 at 9:03 AM Peter Wu 
mailto:peter_cd...@hotmail.com>> wrote:

Quote:
What is your reasoning to expect THAT (data intended for some sort of 
bookkeeping that is NOT double entry bookkeeping) to be correct data 
for gnucash


For personal account checking or credit card. It is the same user 
flow, use the web connect for quicken 2018 or above download a qfx 
file and everything works fine.


I would expect this biz credit to work too. They are from the same 
institution and UI flow is the same.


Somehow the downloaded qfx won’t work. I attached the file in the 
first email.


I used a diff checker to check personal qfx and biz credit card qfx. 
Inside the file, keys are different.


Is it because how gnucash is parsing the file?

Thanks,
Peter

Sent from my iPhone

On May 4, 2022, at 6:47 AM, Michael or Penny Novack 
mailto:stepbystepf...@comcast.net>> wrote:


What is your reasoning to expect THAT (data intended for some sort 
of bookkeeping that is NOT double entry bookkeeping) to be correct 
data for 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists f

Re: [GNC] QFX file for Bank of American business account not invoking Import Matcher

[Jean Laroche]

Running gnucash with --debug shows what the issue is.

Removing the lines that contain the CARDNUM, CARDNAME and MCC elements 
makes the file import correctly.
I'm not sure why ofxlib does not just ignore the unrecognized elements, 
but that's the way it is.

Perhaps file a bug with libofx?

Jean

LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:39:13:E: 
element "CARDNUM" undefined


(Above message occurred on Line 39, Column 14)
 X ERROR: startElement: incoming_data should be empty! You are 
probably using OpenSP <= 1.3.4.  The following data was lost: -50.00

(Above message occurred on Line 39, Column 6)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:40:14:E: 
element "CARDNAME" undefined


(Above message occurred on Line 40, Column 15)
 X ERROR: startElement: incoming_data should be empty! You are 
probably using OpenSP <= 1.3.4.  The following data was lost: 9767

(Above message occurred on Line 40, Column 6)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:41:9:E: 
element "MCC" undefined




On 5/4/22 8:38 AM, Peter Wu wrote:

Hi David C,

It is all new transactions.  If it is previously imported transaction, it would 
give a error dialog saying no new transaction.

But for the given QFX, it just does nothing after you click okay to import the 
file.

By the way, I am using the latest Mac OS on latest Gnucash version.

Should I reply all with email or just reply to the mailing list?

Best,
Peter

From: David Carlson 
Date: Wednesday, May 4, 2022 at 08:30
To: Peter Wu 
Cc: stepbystepf...@comcast.net , Gnucash Users 

Subject: Re: [GNC] QFX file for Bank of American business account not invoking 
Import Matcher
If your file already contains a transaction that was previously imported with 
the same reference number,  Gnucash does not import it again.

On Wed, May 4, 2022, 9:11 AM David Carlson 
mailto:david.carlson@gmail.com>> wrote:
Probably, but you do not explain what happens or doesn't happen when you click on 
"Import OFX/QFX"?  Are you able to see the filename and select it?  Is there an 
error message?

On Wed, May 4, 2022 at 9:03 AM Peter Wu 
mailto:peter_cd...@hotmail.com>> wrote:
Quote:
What is your reasoning to expect THAT (data intended for some sort of 
bookkeeping that is NOT double entry bookkeeping) to be correct data for gnucash

For personal account checking or credit card. It is the same user flow, use the 
web connect for quicken 2018 or above download a qfx file and everything works 
fine.

I would expect this biz credit to work too. They are from the same institution 
and UI flow is the same.

Somehow the downloaded qfx won’t work. I attached the file in the first email.

I used a diff checker to check personal qfx and biz credit card qfx. Inside the 
file, keys are different.

Is it because how gnucash is parsing the file?

Thanks,
Peter

Sent from my iPhone


On May 4, 2022, at 6:47 AM, Michael or Penny Novack 
mailto:stepbystepf...@comcast.net>> wrote:

What is your reasoning to expect THAT (data intended for some sort of 
bookkeeping that is NOT double entry bookkeeping) to be correct data for 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Scheduled transaction: double-prompting for a variable

[Stan Brown]

My mortgage payment is a scheduled transaction of three splits:
Credit: Cash and Banks (always the same amount)
Debit:  Expenses:Mortgage Interest (variable)
Debit:  Liabilities:Home Mortgage (variable)

I set the transaction up with Interest set to a variable and Home
Mortgage set to the unvarying payment amount minus the variable
mentioned in Interest. But when the transaction fires, I get prompted
separately for each occurrence of the same variable. Have I missed
something, or is this just how it works?

I'm running GC 2.6.19, so maybe the behavior was changed in later versions?

-- 
Stan Brown
Tehachapi, CA, USA
https://BrownMath.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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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 Value in Scheduled transaction

[Fred Bone]

On 04 May 2022 at 8:48, Fred J. Tydeman said:

> When I start Gnucash and there are scheduled transactions to be run,
> the window that pops up takes me to a dividend reinvest transaction
> and says it needs a value.  That is confusing in that it is unknown what
> value is it asking for:  Shares, Price, Buy. It appears to be Price, but I
> was expecting it to be Shares.

Can you not inspect the relevant SX in the SX Editor?

For all my SXs that require input at create time I can look at the 
template and see which entries require input.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] QFX file for Bank of American business account not invoking Import Matcher

[David Carlson]

Perhaps that is a problem with GnuCash's linking the OFX file to a selected
account in your data file.  That is over my paygrade...

On Wed, May 4, 2022 at 11:00 AM Jean Laroche  wrote:

> I tried your OFX file, and the same happens for me, no matching dialog
> opens.
> I'll take a look and see if I can find out what's going on.
>
> Jean
>
> On 5/4/22 8:38 AM, Peter Wu wrote:
> > Hi David C,
> >
> > It is all new transactions.  If it is previously imported transaction,
> it would give a error dialog saying no new transaction.
> >
> > But for the given QFX, it just does nothing after you click okay to
> import the file.
> >
> > By the way, I am using the latest Mac OS on latest Gnucash version.
> >
> > Should I reply all with email or just reply to the mailing list?
> >
> > Best,
> > Peter
> >
> > From: David Carlson 
> > Date: Wednesday, May 4, 2022 at 08:30
> > To: Peter Wu 
> > Cc: stepbystepf...@comcast.net , Gnucash
> Users 
> > Subject: Re: [GNC] QFX file for Bank of American business account not
> invoking Import Matcher
> > If your file already contains a transaction that was previously imported
> with the same reference number,  Gnucash does not import it again.
> >
> > On Wed, May 4, 2022, 9:11 AM David Carlson  > wrote:
> > Probably, but you do not explain what happens or doesn't happen when you
> click on "Import OFX/QFX"?  Are you able to see the filename and select
> it?  Is there an error message?
> >
> > On Wed, May 4, 2022 at 9:03 AM Peter Wu  peter_cd...@hotmail.com>> wrote:
> > Quote:
> > What is your reasoning to expect THAT (data intended for some sort of
> bookkeeping that is NOT double entry bookkeeping) to be correct data for
> gnucash
> >
> > For personal account checking or credit card. It is the same user flow,
> use the web connect for quicken 2018 or above download a qfx file and
> everything works fine.
> >
> > I would expect this biz credit to work too. They are from the same
> institution and UI flow is the same.
> >
> > Somehow the downloaded qfx won’t work. I attached the file in the first
> email.
> >
> > I used a diff checker to check personal qfx and biz credit card qfx.
> Inside the file, keys are different.
> >
> > Is it because how gnucash is parsing the file?
> >
> > Thanks,
> > Peter
> >
> > Sent from my iPhone
> >
> >> On May 4, 2022, at 6:47 AM, Michael or Penny Novack <
> stepbystepf...@comcast.net> wrote:
> >>
> >> What is your reasoning to expect THAT (data intended for some sort of
> bookkeeping that is NOT double entry bookkeeping) to be correct data for
> 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
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > 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
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > 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
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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 Value in Scheduled transaction

[Derek Atkins]

It is where-ever you put the variable into the SX.  Without knowing how
you entered it, it's impossible to know what it's actually asking for. 
But I would expect it to only ask for #shares or total value -- the price
is not stored in GnuCash and is always computed.

-derek

On Wed, May 4, 2022 10:48 am, Fred J. Tydeman wrote:
> When I start Gnucash and there are scheduled transactions to be run,
> the window that pops up takes me to a dividend reinvest transaction
> and says it needs a value.  That is confusing in that it is unknown what
> value is it asking for:  Shares, Price, Buy.
> It appears to be Price, but I was expecting it to be Shares.
>
>
> ---
> Fred J. TydemanTydeman Consulting
> tyde...@tybor.com  Testing, numerics, programming
> +1 (702) 608-6093  Vice-chair of PL22.11 (ANSI "C")
> Sample C99+FPCE tests: http://www.tybor.com
> Savers sleep well, investors eat well, spenders work forever.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] QFX file for Bank of American business account not invoking Import Matcher

[Jean Laroche]

I tried your OFX file, and the same happens for me, no matching dialog 
opens.

I'll take a look and see if I can find out what's going on.

Jean

On 5/4/22 8:38 AM, Peter Wu wrote:

Hi David C,

It is all new transactions.  If it is previously imported transaction, it would 
give a error dialog saying no new transaction.

But for the given QFX, it just does nothing after you click okay to import the 
file.

By the way, I am using the latest Mac OS on latest Gnucash version.

Should I reply all with email or just reply to the mailing list?

Best,
Peter

From: David Carlson 
Date: Wednesday, May 4, 2022 at 08:30
To: Peter Wu 
Cc: stepbystepf...@comcast.net , Gnucash Users 

Subject: Re: [GNC] QFX file for Bank of American business account not invoking 
Import Matcher
If your file already contains a transaction that was previously imported with 
the same reference number,  Gnucash does not import it again.

On Wed, May 4, 2022, 9:11 AM David Carlson 
mailto:david.carlson@gmail.com>> wrote:
Probably, but you do not explain what happens or doesn't happen when you click on 
"Import OFX/QFX"?  Are you able to see the filename and select it?  Is there an 
error message?

On Wed, May 4, 2022 at 9:03 AM Peter Wu 
mailto:peter_cd...@hotmail.com>> wrote:
Quote:
What is your reasoning to expect THAT (data intended for some sort of 
bookkeeping that is NOT double entry bookkeeping) to be correct data for gnucash

For personal account checking or credit card. It is the same user flow, use the 
web connect for quicken 2018 or above download a qfx file and everything works 
fine.

I would expect this biz credit to work too. They are from the same institution 
and UI flow is the same.

Somehow the downloaded qfx won’t work. I attached the file in the first email.

I used a diff checker to check personal qfx and biz credit card qfx. Inside the 
file, keys are different.

Is it because how gnucash is parsing the file?

Thanks,
Peter

Sent from my iPhone


On May 4, 2022, at 6:47 AM, Michael or Penny Novack 
mailto:stepbystepf...@comcast.net>> wrote:

What is your reasoning to expect THAT (data intended for some sort of 
bookkeeping that is NOT double entry bookkeeping) to be correct data for 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Need Value in Scheduled transaction

[Fred J. Tydeman]

When I start Gnucash and there are scheduled transactions to be run,
the window that pops up takes me to a dividend reinvest transaction
and says it needs a value.  That is confusing in that it is unknown what
value is it asking for:  Shares, Price, Buy.
It appears to be Price, but I was expecting it to be Shares.


---
Fred J. TydemanTydeman Consulting
tyde...@tybor.com  Testing, numerics, programming
+1 (702) 608-6093  Vice-chair of PL22.11 (ANSI "C")
Sample C99+FPCE tests: http://www.tybor.com
Savers sleep well, investors eat well, spenders work forever.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] QFX file for Bank of American business account not invoking Import Matcher

[Peter Wu]

Hi David C,

It is all new transactions.  If it is previously imported transaction, it would 
give a error dialog saying no new transaction.

But for the given QFX, it just does nothing after you click okay to import the 
file.

By the way, I am using the latest Mac OS on latest Gnucash version.

Should I reply all with email or just reply to the mailing list?

Best,
Peter

From: David Carlson 
Date: Wednesday, May 4, 2022 at 08:30
To: Peter Wu 
Cc: stepbystepf...@comcast.net , Gnucash Users 

Subject: Re: [GNC] QFX file for Bank of American business account not invoking 
Import Matcher
If your file already contains a transaction that was previously imported with 
the same reference number,  Gnucash does not import it again.

On Wed, May 4, 2022, 9:11 AM David Carlson 
mailto:david.carlson@gmail.com>> wrote:
Probably, but you do not explain what happens or doesn't happen when you click 
on "Import OFX/QFX"?  Are you able to see the filename and select it?  Is there 
an error message?

On Wed, May 4, 2022 at 9:03 AM Peter Wu 
mailto:peter_cd...@hotmail.com>> wrote:
Quote:
What is your reasoning to expect THAT (data intended for some sort of 
bookkeeping that is NOT double entry bookkeeping) to be correct data for gnucash

For personal account checking or credit card. It is the same user flow, use the 
web connect for quicken 2018 or above download a qfx file and everything works 
fine.

I would expect this biz credit to work too. They are from the same institution 
and UI flow is the same.

Somehow the downloaded qfx won’t work. I attached the file in the first email.

I used a diff checker to check personal qfx and biz credit card qfx. Inside the 
file, keys are different.

Is it because how gnucash is parsing the file?

Thanks,
Peter

Sent from my iPhone

> On May 4, 2022, at 6:47 AM, Michael or Penny Novack 
> mailto:stepbystepf...@comcast.net>> wrote:
>
> What is your reasoning to expect THAT (data intended for some sort of 
> bookkeeping that is NOT double entry bookkeeping) to be correct data for 
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] QFX file for Bank of American business account not invoking Import Matcher

[Peter Wu]

Hey David, sorry I wasn’t being specific.  I mentioned in the email subject 
line.  It does not open Import Matcher window.

This is a new account.  I open it, it prompt me to select an account an 
account.  (I already made a new empty account before import). Select the 
account, no import matcher pops up.

I have another qfx file with more transactions from this BofA business account. 
 It doesn’t open import matcher as well.

My personal checking or credit card qfx are from BofA and works fine.

Best,
Peter

From: David Carlson 
Date: Wednesday, May 4, 2022 at 08:30
To: Peter Wu 
Cc: stepbystepf...@comcast.net , Gnucash Users 

Subject: Re: [GNC] QFX file for Bank of American business account not invoking 
Import Matcher
If your file already contains a transaction that was previously imported with 
the same reference number,  Gnucash does not import it again.

On Wed, May 4, 2022, 9:11 AM David Carlson 
mailto:david.carlson@gmail.com>> wrote:
Probably, but you do not explain what happens or doesn't happen when you click 
on "Import OFX/QFX"?  Are you able to see the filename and select it?  Is there 
an error message?

On Wed, May 4, 2022 at 9:03 AM Peter Wu 
mailto:peter_cd...@hotmail.com>> wrote:
Quote:
What is your reasoning to expect THAT (data intended for some sort of 
bookkeeping that is NOT double entry bookkeeping) to be correct data for gnucash

For personal account checking or credit card. It is the same user flow, use the 
web connect for quicken 2018 or above download a qfx file and everything works 
fine.

I would expect this biz credit to work too. They are from the same institution 
and UI flow is the same.

Somehow the downloaded qfx won’t work. I attached the file in the first email.

I used a diff checker to check personal qfx and biz credit card qfx. Inside the 
file, keys are different.

Is it because how gnucash is parsing the file?

Thanks,
Peter

Sent from my iPhone

> On May 4, 2022, at 6:47 AM, Michael or Penny Novack 
> mailto:stepbystepf...@comcast.net>> wrote:
>
> What is your reasoning to expect THAT (data intended for some sort of 
> bookkeeping that is NOT double entry bookkeeping) to be correct data for 
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] QFX file for Bank of American business account not invoking Import Matcher

[David Carlson]

If your file already contains a transaction that was previously imported
with the same reference number,  Gnucash does not import it again.

On Wed, May 4, 2022, 9:11 AM David Carlson 
wrote:

> Probably, but you do not explain what happens or doesn't happen when you
> click on "Import OFX/QFX"?  Are you able to see the filename and select
> it?  Is there an error message?
>
> On Wed, May 4, 2022 at 9:03 AM Peter Wu  wrote:
>
>> Quote:
>> What is your reasoning to expect THAT (data intended for some sort of
>> bookkeeping that is NOT double entry bookkeeping) to be correct data for
>> gnucash
>>
>> For personal account checking or credit card. It is the same user flow,
>> use the web connect for quicken 2018 or above download a qfx file and
>> everything works fine.
>>
>> I would expect this biz credit to work too. They are from the same
>> institution and UI flow is the same.
>>
>> Somehow the downloaded qfx won’t work. I attached the file in the first
>> email.
>>
>> I used a diff checker to check personal qfx and biz credit card qfx.
>> Inside the file, keys are different.
>>
>> Is it because how gnucash is parsing the file?
>>
>> Thanks,
>> Peter
>>
>> Sent from my iPhone
>>
>> > On May 4, 2022, at 6:47 AM, Michael or Penny Novack <
>> stepbystepf...@comcast.net> wrote:
>> >
>> > What is your reasoning to expect THAT (data intended for some sort of
>> bookkeeping that is NOT double entry bookkeeping) to be correct data for
>> 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
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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 one save report option defaults?

[Chris Green]

On Wed, May 04, 2022 at 09:36:19AM -0500, David Carlson wrote:
> On Wed, May 4, 2022 at 9:32 AM Chris Green  wrote:
> 
> > I find I nearly always change the same five or six report options
> > every time I want a new report.  For example I nearly always want to
> > select all accounts (at least initially) and I want the secondary sort
> > key to be Date.
> >
> > Is there any way I can set up GnuCash so the report options always
> > start with the values I want?
> >
> At the top of the report there is a button labelled "Save Config/"
> 
Yes, I know that.  However it only saves the settings for one report
and when you retrieve it you get exactly the report you saved.  What I
want is to be able to save the more general report settings so that
whenever I open a new report I get those settings.

There's already a few things that can be configured 'system wide' in
Edit->Preferences->Reports, for example you can set the default
currency for *every* report there.  I'd like to be able to set more
things like this so that they apply to every report. Then I won't have
to set/unset the same half-dozen or so things I have to change every
time I create a new report.  The problem is that I sometimes forget
some of them! :-)

-- 
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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 one save report option defaults?

[David Carlson]

At the top of the report there is a button labelled "Save Config/"

On Wed, May 4, 2022 at 9:32 AM Chris Green  wrote:

> I find I nearly always change the same five or six report options
> every time I want a new report.  For example I nearly always want to
> select all accounts (at least initially) and I want the secondary sort
> key to be Date.
>
> Is there any way I can set up GnuCash so the report options always
> start with the values I want?
>
> --
> 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
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Can one save report option defaults?

[Chris Green]

I find I nearly always change the same five or six report options
every time I want a new report.  For example I nearly always want to
select all accounts (at least initially) and I want the secondary sort
key to be Date.

Is there any way I can set up GnuCash so the report options always
start with the values I want?

-- 
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] QFX file for Bank of American business account not invoking Import Matcher

[David Carlson]

Probably, but you do not explain what happens or doesn't happen when you
click on "Import OFX/QFX"?  Are you able to see the filename and select
it?  Is there an error message?

On Wed, May 4, 2022 at 9:03 AM Peter Wu  wrote:

> Quote:
> What is your reasoning to expect THAT (data intended for some sort of
> bookkeeping that is NOT double entry bookkeeping) to be correct data for
> gnucash
>
> For personal account checking or credit card. It is the same user flow,
> use the web connect for quicken 2018 or above download a qfx file and
> everything works fine.
>
> I would expect this biz credit to work too. They are from the same
> institution and UI flow is the same.
>
> Somehow the downloaded qfx won’t work. I attached the file in the first
> email.
>
> I used a diff checker to check personal qfx and biz credit card qfx.
> Inside the file, keys are different.
>
> Is it because how gnucash is parsing the file?
>
> Thanks,
> Peter
>
> Sent from my iPhone
>
> > On May 4, 2022, at 6:47 AM, Michael or Penny Novack <
> stepbystepf...@comcast.net> wrote:
> >
> > What is your reasoning to expect THAT (data intended for some sort of
> bookkeeping that is NOT double entry bookkeeping) to be correct data for
> 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
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Is there a report with transactions by date and accounts in columns?

[Chris Green]

On Wed, May 04, 2022 at 01:27:59PM +, Christopher Lam wrote:
> Use the "Income & GST Statement" report.
> 
> [image: image.png]
> 
> [image: image.png]
> 

Yes, thank you, I've finally got there.  That provides the information
(plus a few unwanted columns).  :-)


-- 
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] QFX file for Bank of American business account not invoking Import Matcher

[Peter Wu]

Quote:
What is your reasoning to expect THAT (data intended for some sort of 
bookkeeping that is NOT double entry bookkeeping) to be correct data for gnucash

For personal account checking or credit card. It is the same user flow, use the 
web connect for quicken 2018 or above download a qfx file and everything works 
fine. 

I would expect this biz credit to work too. They are from the same institution 
and UI flow is the same. 

Somehow the downloaded qfx won’t work. I attached the file in the first email. 

I used a diff checker to check personal qfx and biz credit card qfx. Inside the 
file, keys are different. 

Is it because how gnucash is parsing the file?

Thanks,
Peter

Sent from my iPhone

> On May 4, 2022, at 6:47 AM, Michael or Penny Novack 
>  wrote:
> 
> What is your reasoning to expect THAT (data intended for some sort of 
> bookkeeping that is NOT double entry bookkeeping) to be correct data for 
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] QFX file for Bank of American business account not invoking Import Matcher

[David Carlson]

Peter,

What do you mean by "does not work"?

Looking at it with a text editor, it appears to follow the OFX format but
it only contains one transaction which may or may not import correctly to
your data file.

On Wed, May 4, 2022 at 8:47 AM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

> On 5/3/2022 11:25 PM, Peter Wu wrote:
>
> >2.  As the email subject says.  Attached qfx file does not work.  I
> have personal Bank of American checking and credit card.  They all work.  I
> downloaded the file by using the “Web Connect for Quicken 2018 and above”.
>
> You are perhaps confusing file type with data withing that file. You say
> that you downloaded the file asking it be delivered for "Quicken 2018
> and above" What is your reasoning to expect THAT (data intended for some
> sort of bookkeeping that is NOT double entry bookkeeping) to be correct
> data for gnucash (data intended for standard double entry bookkeeping)
>
> >
> > I have a suspicion why it is not working.  Maybe it is because a
> combined qfx file.  BofA organized their business account in a group
> fashion.  They made a parent account and each credit card holder as a child
> account.  Their personal account doesn’t follow this parent-child account
> structure.
> >
> Well a credit card "account" of that sort is standard for business
> credit cards (a master card number, perhaps not used to charge anything,
> and some number of individual child cards which are. That way whoever is
> doing the record keeping can see what is being charged on each card but
> pays to the master number. That is NOT just for business. Thus in my own
> case, I have a card (and it's the master number) and my wife has a card
> with a different number but actually the same account. When I get a
> statement, the charges for both card numbers are listed separately but
> the total, and payments. etc. just on the master account number.
>
> Since I have not yet switched that to online, I have no idea what the
> file would look like if I asked MasterCard to provide a file instead of
> paper statement.
>
> 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
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] QFX file for Bank of American business account not invoking Import Matcher

[Michael or Penny Novack]

On 5/3/2022 11:25 PM, Peter Wu wrote:


   2.  As the email subject says.  Attached qfx file does not work.  I have 
personal Bank of American checking and credit card.  They all work.  I 
downloaded the file by using the “Web Connect for Quicken 2018 and above”.


You are perhaps confusing file type with data withing that file. You say 
that you downloaded the file asking it be delivered for "Quicken 2018 
and above" What is your reasoning to expect THAT (data intended for some 
sort of bookkeeping that is NOT double entry bookkeeping) to be correct 
data for gnucash (data intended for standard double entry bookkeeping)




I have a suspicion why it is not working.  Maybe it is because a combined qfx 
file.  BofA organized their business account in a group fashion.  They made a 
parent account and each credit card holder as a child account.  Their personal 
account doesn’t follow this parent-child account structure.

Well a credit card "account" of that sort is standard for business 
credit cards (a master card number, perhaps not used to charge anything, 
and some number of individual child cards which are. That way whoever is 
doing the record keeping can see what is being charged on each card but 
pays to the master number. That is NOT just for business. Thus in my own 
case, I have a card (and it's the master number) and my wife has a card 
with a different number but actually the same account. When I get a 
statement, the charges for both card numbers are listed separately but 
the total, and payments. etc. just on the master account number.


Since I have not yet switched that to online, I have no idea what the 
file would look like if I asked MasterCard to provide a file instead of 
paper statement.


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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Change account in Transfer column - how?

[davidcousens49]

Chris,
You have created a chart of accounts which has more than a single account in it?
One other point. Do you have the View->Autosplit ledger option checked. IF you
do then the first line is the transaction summary line and it remains balnk
until you create the transaction splits. You have to move to the second line to
enter the first account for the split and then tab to the third line to enter
the account for the second split second split for the transaction.

David

On Wed, 2022-05-04 at 09:04 +0100, Chris Green wrote:
> On Wed, May 04, 2022 at 06:55:05AM +1000, davidcousen...@gmail.com wrote:
> > Chris,
> > 
> > The behaviour of the account selection in the transfer column in GC 4.10 on
> > Linux Mint is as follows:
> > 
> > When you first click on the split of the transaction a down arrow appears at
> > thr
> > right of the column.
> > 
> > If you click on the down arrow, the list of transaction is displayed and its
> > window overlays the transfer debit,credit and balance columns and the column
> > borders are no longer present and there is a scroll bar to the right which
> > you
> > can use to scroll through the accounts. 
> > 
> I get the down arrow but no list of accounts, no scroll bar, nothing.
> Occasionally it works but, just at the moment, not very often.
> 
> 
> > The arrow to the right will now appear as an up arrow and clicking on it
> > will
> > close the account selection window without making a selection.
> > 
> I get the change to the up arrow, but (as I said) there's no list to
> be closed.
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Change layout and font sizes in Transaction Report - how?

[Chris Green]

The Transaction Report probably provides the information that my
auditor wants by listing each account's transactions in order and
giving the total amount below each account.

However the formatting and font sizes seem a little odd and I'd like
to change them if I can.

I have two fairly simple requirements:-

Increase the space below "Total for " before the
name of the next account appears.

Increase the font size for the account name that appears at the
top of each account's transactions.  As it is at present it's just
in the default small size used for all the 'body' text and so the
name doesn't stand out to indicate the start of the next account.


I can 'do' CSS but there don't seem to be any obvious selectors for
the items I want to change.  Is there any detailed description of what
selectors are available in the CSS stylesheet?

-- 
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Double entry directly to Equity

[Bogdan]

Hi,

I am trying to figure out how to set up a  revaluation reserve account
directly in Equity so that I could do e.g. Dr Asset a/c Cr Equity.

About a year ago I was able to create an account in Trading and debit /
credit it directly from Asset and Liability accounts. However, now when I
enter a similar transaction the Trading account (second leg of the entry)
simply disappears and is replaced by Imbalance.

What is the appropriate way to make accounting entries directly to Equity
accounts (not retained earnings through PL)? Any idea why the above
approach no longer works?

Thanks!
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Is there a report with transactions by date and accounts in columns?

[Chris Green]

On Wed, May 04, 2022 at 12:07:53AM +0800, Christopher Lam wrote:
> On Tue, 3 May 2022, 11:53 pm Chris Green,  wrote:
> 
> > My auditor wants a transaction report showing transactions in date
> > order one per line with the transaction amounts in columns according
> > to account name.
> >
> > Is there anything in GnuCash that can do this?
> >
> I guess the report intends to show the inputs and outputs into the company,
> you could use the income and GST statement report. Inputs and sales, and
> outputs are purchases. You can ignore the tax accounts. Then select
> detailed sales and purchase accounts in the display options.
> 
Still no separate columns for accounts, what's wanted is something
like (needs fixed width font) :-

   DonationsInterestMiscExpenses
01/03/21£40.00
03/03/21£25.00
07/04/21   (£23.00)
22/04/21£0.50
02/05/21£10.00


etc. etc.

It doesn't have to have income and expense on the same sheet, in fact
one sheet for each might well make sense, avoiding the need for a way
to show -ve values (or some other debit/credit differentiation).

-- 
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] QFX file for Bank of American business account not invoking Import Matcher

[Liz]

On Wed, 4 May 2022 03:25:25 +
Peter Wu  wrote:

>  1.  Beside the mailing-list.  Does anyone know a forum where we can
> ask and discuss issues?  I feel it maybe easier to
> search/discuss/answer questions than a mailing list.

This mailing list leads to the expertise, or the brains trust of
Gnucash. You can also use IRC if you prefer.

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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Change account in Transfer column - how?

[Chris Green]

On Wed, May 04, 2022 at 06:55:05AM +1000, davidcousen...@gmail.com wrote:
> Chris,
> 
> The behaviour of the account selection in the transfer column in GC 4.10 on
> Linux Mint is as follows:
> 
> When you first click on the split of the transaction a down arrow appears at 
> thr
> right of the column.
> 
> If you click on the down arrow, the list of transaction is displayed and its
> window overlays the transfer debit,credit and balance columns and the column
> borders are no longer present and there is a scroll bar to the right which you
> can use to scroll through the accounts. 
> 
I get the down arrow but no list of accounts, no scroll bar, nothing.
Occasionally it works but, just at the moment, not very often.


> The arrow to the right will now appear as an up arrow and clicking on it will
> close the account selection window without making a selection.
> 
I get the change to the up arrow, but (as I said) there's no list to
be closed.

-- 
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.