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

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

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

@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

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

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

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 >

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

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

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

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

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

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,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Re: [GNC] Need Value in Scheduled transaction

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

Re: [GNC] Need Value in Scheduled transaction

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

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

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

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

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

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

Re: [GNC] Need Value in Scheduled transaction

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,

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

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

Re: [GNC] Need Value in Scheduled transaction

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

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

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

[GNC] Need Value in Scheduled transaction

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

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

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.

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

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

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"?

Re: [GNC] Can one save report option defaults?

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

Re: [GNC] Can one save report option defaults?

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

[GNC] Can one save report option defaults?

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

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

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

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

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

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

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

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

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>

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

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

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

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

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

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

[GNC] Double entry directly to Equity

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

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

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

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

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

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

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