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] Shutdown using the "X" in windows 11

n their own premises. From: Gyle McCollam Sent: Monday, April 25, 2022 11:30 AM To: Kalpesh Patel Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Shutdown using the "X" in windows 11 The file is both on the hard drive and in the cloud as one drive saves it to both.

Re: [GNC] Shutdown using the "X" in windows 11

>> The filename suggests you are keeping the file "in the cloud", and if so >> this (failure to delete the lock file) seems to be expected behaviour, >> regardless of Windows or Gnucash version. This may not be correct assumption. The file is on the local hard drive for sure. Only way

Re: [GNC] Shutdown using the "X" in windows 11

I can confirm that on Windows 10 using GNC 4.10 exiting via 'X' regardless you are prompted to save the file or not does not clear the lock file on my kit. I do not have any unusual use of my kit so I am left to guess something with GNC is causing it . --

Re: [GNC] Import overwrites transaction description

So this is the same work flow that has annoyed me in the past, and I have found a work around that works well for me. As you recall that GC is a double entry system so every transaction has a Description that is common for both sides of the transaction, and then what most folks don't realize

Re: [GNC] Possible to display two account registers on

2022 3:18 PM To: 'gnucash-user' Cc: Kalpesh Patel Subject: Re: [GNC] Possible to display two account registers on On 2022-02-04 10:29, Kalpesh Patel wrote: > In Windows 10 (and probably all other host OSes?), if you double click > on any account in the Accounts Page window (windows  that

Re: [GNC] Possible to display two account registers on

In Windows 10 (and probably all other host OSes?), if you double click on any account in the Accounts Page window (windows that opens when GNC is launched) then it will open a new floating window for that specific account (it doesn't open another for an account for which one floating window is

Re: [GNC] Possible to display two account registers on screen?

I did this sort of migration (from Quicken) many moons ago and my recommendation is to perform reimport with slight modification in in the process. First delete the second account and all transactions that are in the second account. You can do so in bulk by deleting the account and while deleting

[GNC] credit card minimum payment due

Is there a way to schedule a transaction or to mimic a scheduling one if the account value is above a fixed value in that account? In my case it is minimum fixed amount due automatically for the credit card payment if total charges is over say $35.00 when statement period closes.

Re: [GNC] Exiting Gnucash Lock file

Is any tool, perhaps SQLite studio (https://sqlitestudio.pl/about/), supported as the alternate to an GNC API as the Editor that won’t void the warranty? From: Thomas Forrester Sent: Friday, January 21, 2022 5:03 PM To: John Ralls Cc: Kalpesh Patel ; gnucash-user Subject: Re: [GNC

Re: [GNC] Vanguard OFX Access

Sadly Vanguard does not offer OFX formatted download. They only provide QIF, in one account or individual mutual fund accounts, or CSV format - very limited formats. Even with QIF format it is a hit or miss in importing to GNC and CSV formatted requires good deal of post-processing If you

Re: [GNC] Exiting Gnucash Lock file

Few questions in regards to SQLite3 backend recommendation because currently XML format for my data is compressed size of 1.82MB so exploring moving to it. Not sure if this is considered small sized XML file or not but . 1 - SQLite was natively born on UNIX systems with UNIX systems in mind so

[GNC] Single mutual fund held in multiple accounts in

Dave - not sure if you are aware of importing your transactions using Quicken, OFX or CSV formatted file from your broker if they provide ability to download. OFX formatted file gives the best result with no pre-processing required while CSV one will need pre-processing before importing it. It

[GNC] Single mutual fund held in multiple accounts in gnucash

Dave - I have set it up to what Will has shown except that I have one additional level of hierarchy where I differentiate between brokerage account (wholesale marts) versus mutual funds (original mutual fund issuers) and then use the lowest level parent of it as the "cash" account. The "cash"

Re: [GNC] On line quote debugging help

Oh, sorry, my bad. Yes that is the question - why are some of the quote sources greyed out, and follow on question is: is there a way to edit that list to toggle the source? -Original Message- From: john Sent: Monday, December 27, 2021 11:28 PM To: Kalpesh Patel Cc: gnucash-user

Re: [GNC] On line quote debugging help

From: john Sent: Monday, December 27, 2021 11:42 AM To: Kalpesh Patel Cc: gnucash-user@gnucash.org Subject: Re: [GNC] On line quote debugging help > On Dec 27, 2021, at 7:41 AM, Kalpesh Patel wrote: > > Hi All - > > > > Few days back when I upgraded to GN

[GNC] On line quote debugging help

Hi All - Few days back when I upgraded to GNC 4.9 on Windows 10, I also ran the 'Install Online Price Retrieval for GnuCash' which updated some of the Perl modules. Now I am getting 'Unable to retrieve quotes for these items:' window with a random listing of securities intermittently, which

Re: [GNC] gnucash-user Digest, Vol 225, Issue 32

I believe double clicking on the right side divider line of a column to resize best fit for the largest content in that column is known practice in PC world since ages (I recall being able to do so since text based Lotus 123 times when mouse navigation was introduced in DOS mode) and behavior is

Re: [GNC] Bitcoin is legal currency in El Salvador - why not

Why not to set this up as a true currency in GNC, instead of Stock or Mutual Fund? -- Message: 8 Date: Tue, 7 Dec 2021 12:42:21 + From: Eric Coates mailto:twistedw...@talktalk.net> > To: gnucash-user@gnucash.org

Re: [GNC] CSV Import Reconciled field

But I assume that I am not going to succeed without some preprocessing to get aligned what csv importer is expecting. From: David Carlson Sent: Tuesday, November 16, 2021 1:00 PM To: Kalpesh Patel Cc: Ove Grunnér ; Gnucash Users Subject: Re: [GNC] CSV Import Reconciled field

Re: [GNC] clearing reconciled transactions

Might be slightly simpler way to do it - Do normal work flows other than reconcile, save the file, turn off auto save of the file and then you can do your reconciling and if you have cold feet then you can exit GNC without saving the file. Next time you open GNC it will put you back to place

Re: [GNC] clearing reconciled transactions

; charset=UTF-8; format=flowed Oh, does that work? It is a standard MS way of doing it but I never tried in Gnucash. Thanks On 02/12/2021 17:22, Kalpesh Patel wrote: > Just in case need details, this is what I do: > > > > Go to first row and then hold the [s

Re: [GNC] Adaptive learning reset of imports

Are you clicking the button at the top of 'Tools' >> 'Import Map Editor' window from 'Bayesian' to 'Online' in the 'What type of information to display?' bar? Then click on the 'Expand All' button at the bottom to see all the matching that has been done so far for every entry it has

Re: [GNC] clearing reconciled transactions

Just in case need details, this is what I do: Go to first row and then hold the [shift] key while clicking the last row to select a range that I want to reconcile. Selected row's display reverses in color for the range that is in focus. Now I press [space bar] to toggle the entire selection -

Re: [GNC] Data load from CSV files - duplicates

Work flow using two pass for the CSV importer (for that fact any importer) yields better result for me as well, generally speaking. This is probably best way to handle double-entry accounting. In the first pass I import new or update existing transactions into register for one side of the

Re: [GNC] CSV Import Reconciled field

Hi Ove - I was curious what types of Stock Transactions you are importing properly via CSV format into GNC. I was under the belief that purchase/sale of securities/commodities was not supported via CSV import process in GNC (or I was mistaken) so if it is possible then I wouldn't mind

Re: [GNC] Scheduled transactions details

away from it for good so that is one sure thing I miss from there … PS: No need to worry about late responses … it is always better to get it in then never … From: Tommy Trussell Sent: Monday, November 15, 2021 10:51 PM To: Kalpesh Patel Cc: David Carlson ; Gnucash Users Subject: Re

Re: [GNC] Account Name Matching

On Windows 10, I use the application icon in taskbar to close and then open the application window which returns back the focus and am able to do subsequent data entry as desired. I gotten into that situation in multiple instance where applications main window refuses to get attention or when a

Re: [GNC] import csv transactions

Chris - While David C has provided good template for how to approach your CSV import concerns, there is one more workflow you may want to keep it in back of your mind. You have an option to always start a new blank file, experiment with import into the blank file and then you can review

Re: [GNC] QFX import: transaction matching NOT learning to match

David – I think you are looking for the matcher window where you can see this and modify/delete them according to your need as I needed to undo erroneously accepted matching transactions in the past. I don’t have the older 3.8 version running but I find that in 4.8 under “Tools” à “Import Map

Re: [GNC] Scheduled transactions details

. Since I deal only with US Dollars currency, should that be just a value of 1? I reckon that I won’t have any transactions that creates imbalance. From: David Carlson Sent: Tuesday, November 02, 2021 12:43 PM To: Kalpesh Patel Cc: Gnucash Users Subject: Re: [GNC] Scheduled transactions

[GNC] Scheduled transactions details

Hi Everyone – Two questions – 1 - I noticed that the “Value” column next to “Status” in the “Since Last Run …” window that pops-up when GNC is launched or manually run from ‘Actions” à ‘Scheduled Transaction’ à ‘Since Last Run…’ is blank. I know I have some scheduled ones that have fixed

Re: [GNC] Error importing QIF file

Parag - are you able to send me the QIF file privately either as is or anonymized? I will flag down the offending entry. It won't be any easier than this. Just a FYI - my past experience in a massive import of over 10K+ transaction via QIF has been that the wild west of date format used by

Re: [GNC] Error importing QIF file

Parag - You will have to find the offending faulty transaction and correct it manually after understanding why it is failing. Learning the format of QIF file is not that difficult (plenty of sources to be had by Google'ing for it, including a Wikipedia) and the file can be viewed in any good old

Re: [GNC] How do you do this - differentiate scheduled transaction versus no scheduled one

it there permanently to help me understand where it came from if there is any confusion later on. Regards, Chris Good > > Message: 1 > Date: Fri, 15 Oct 2021 09:31:57 +0100 > From: "Maf. King" > To: 'Gnucash Users' > Cc: Kalpesh Patel > Subject: Re: [GNC] How do you do

[GNC] How do you do this - differentiate scheduled transaction versus no scheduled one

A workflow questions for GNC users: 1 - My habits when it comes to payments for example credit card, mortgage, other bills, etc. is to scheduled it out in advance from the appropriate institutions that hold my bank accounts, such as checking, savings, etc. at a future date but within due date.

Re: [GNC] Online price retrieval

In the search box (the icon that looks like magnifying glass in the task bar) just type in "Install Online Price Retrieval for GnuCash" and press the "Enter" key to kick off the installation routine. You can follow the same process to upgrade now and then as well. If all goes well, you should get

Re: [GNC] OFX - Citi Setup Trouble

Doesn't Citi requires validation steps in States? I believe they can be found under "Profile" --> "More Settings" --> "App with Account Access" in their web portal. I had it working at one time with following settings: -> "User Settings": User Name: User id: Client UUID: -> "Bank Settings":

Re: [GNC] OFX Import with Investment Transactions

, 2021 11:24 AM To: Kalpesh Patel ; 'john' Cc: 'Robin Chattopadhyay' ; 'Gnucash Users' Subject: Re: [GNC] OFX Import with Investment Transactions Thanks! That's good news! J. On 10/5/2021 7:25 AM, Kalpesh Patel wrote: I loaded up 4.8 version of GnuCash on another computer last night

Re: [GNC] OFX Import with Investment Transactions

03, 2021 11:50 PM To: john Cc: Robin Chattopadhyay ; Kalpesh Patel ; Gnucash Users Subject: Re: [GNC] OFX Import with Investment Transactions There was indeed a bug so I opened https://bugs.gnucash.org/show_bug.cgi?id=798327 and created a PR with a simple fix. I verified that on the file

Re: [GNC] OFX Import with Investment Transactions

, October 03, 2021 12:19 PM To: Kalpesh Patel Cc: Gnucash Users Subject: Re: [GNC] OFX Import with Investment Transactions Yes, I'm familiar with that issue as well as my spouse's 401K OFX has fee transactions where shares are sold to pay plan expenses, but those transactions appear only

Re: [GNC] OFX Import with Investment Transactions

The issues that you are seeing I believe has to do with changes that OFX introduced in libofx which has been included since 4.5 and above version of GnuCash. FWIW, I am running on Windows 10 Pro desktop but that likely doesn't matter when it comes to core functionality. I also had problems where

Re: [GNC] QIF imports for security pricing

to the author of libofx and waiting to hear back. I may go the route of cherry-pick the QIF import feature back to 4.4 or figure out how to import prices issuing CSV. -Original Message- From: Dong Lin Sent: Thursday, September 09, 2021 12:00 PM To: Kalpesh Patel Cc: gnucash-user

Re: [GNC] QIF imports for security pricing

) to import that as well. Kalpesh… From: D. Sent: Tuesday, September 07, 2021 3:57 PM To: Kalpesh Patel Cc: David Carlson ; David Reiser via gnucash-user Subject: RE: [GNC] QIF imports for security pricing I don't understand. Why would you need to KEEP importing prices? Once you've imported

Re: [GNC] QIF imports for security pricing

PM To: David Carlson Cc: Kalpesh Patel ; David Reiser via gnucash-user Subject: Re: [GNC] QIF imports for security pricing I've used csv imports for commodity prices many times. Because of problems with retrieving prices through Finance::Quote that started when Yahoo! deactivated its ser

Re: [GNC] QIF imports for security pricing

: Dong Lin Sent: Monday, September 06, 2021 3:56 PM To: Kalpesh Patel Cc: gnucash-user@gnucash.org Subject: Re: [GNC] QIF imports for security pricing Which GNC version are you using? Price database update from QIF imports is added in version 4.5. In order to propagate the price db through i

[GNC] QIF imports for security pricing

Hello GnuCash Dev and user community - Looking for answer to few questions related to GnuCash use, so I am hoping community can provide guidance. - Recently I tried to import a QIF file containing mutual fund transactions and pricing info into an investment account. The

Re: [GNC] Can I Prevent OFX/QFX Import Overwriting Notes?

I've established a bit of a different workflow. I "convert" what would have been the note into a very specific sub-account so that no matter what the note's information doesn't get lost. For example if I paid for a gift via check for xyz then I will create a sub account of xyz under gifts

[GNC] new namespaces for tokens and commodities

If token is pegged to a currency then is token not a foreign currency like euros or rupees or gold or silver? Exchange rate is either pegged or free floating but none the less isn't it a currency that is either sanctioned by group of people or a government (they are group of people too)?

Re: [GNC] Transactions for multiple accounts in 1 ofx file?

- From: David Reiser Sent: Monday, August 02, 2021 6:21 PM To: Kalpesh Patel Cc: David Carlson ; Chris Good ; Gnucash Users Subject: Re: [GNC] Transactions for multiple accounts in 1 ofx file? There was a change in libofx 10.something that changed the way it interpreted cash transactions. I think

Re: [GNC] Transactions for multiple accounts in 1 ofx file?

ugust 01, 2021 7:19 AM To: Chris Good Cc: Kalpesh Patel ; Gnucash Users Subject: Re: [GNC] Transactions for multiple accounts in 1 ofx file? You will also note that bug report is dated in 2003, the concern was raised then with the hint that it was inherent in the OFX specification and therefore

Re: [GNC] Transactions for multiple accounts in 1 ofx file?

I use it in this manner all the time and works great. I use an old program called pocketsense, which I modified a bit, which goes out to multiple institutions, downloads from each in ofx format and then combines them into single ofx file to import it into gnucash. Literally speaking they all

[GNC] Reconcile multiple child accounts

Hello GNUCash subscribers - I have a brokerage account which is set up as an ASSET account. The brokerage account holds MUTUAL FUNDS so for each MUTUAL FUND, a sub account underneath the brokerage account is created. All the MUTUAL FUND sub accounts matched the quantity with the statement as

Re: [GNC] Thinking about Moving to MacOS from Win 10

On Windows, I have been using CryptSync for ages and it has never failed me. Easy to setup and works on any cloud storage. I also use it to go back and forth on multiple desktops through cloud storage while maintaining encryption and with little patient/delay it always come through as it is an

Re: [GNC] gnucash-user Digest, Vol 214, Issue 23

Ah, that is now clear how it suppose to work. Thank you. -Original Message- From: David Reiser Sent: Monday, January 11, 2021 6:04 PM To: Kalpesh Patel Cc: gnucash-user@gnucash.org Subject: Re: [GNC] gnucash-user Digest, Vol 214, Issue 23 I believe that the Online ID section deals

Re: [GNC] gnucash-user Digest, Vol 214, Issue 23

is selected. -- Message: 1 Date: Sat, 9 Jan 2021 17:13:32 -0500 From: David Reiser To: Kalpesh Patel Cc: gnucash-user@gnucash.org Subject: Re: [GNC] OFX matched account and unmatching it manually Message-ID: <6f2e5d35-4b8c-49be-b

[GNC] OFX matched account and unmatching it manually

Hi all, I normally download OFX files and then import those downloaded transactions into GnuCash. When a new account is encountered in the import process, a dialog box shows up (see attached pic) that allows you to set the 'Account Name' in GnuCash that is mapped to and 'Account ID' that is

Re: [GNC] ofx.chase.com?

While I do not use GNUCash built in functionality of OFX to download statement (both bank and credit card) from Chase, their OFX servers are responding fine for download requests. For that fact, I just tested prior to sending this e-mail out, inspected the output and it has transaction that I

Re: [GNC] Split Transactions

Not to hit enter/return to move to next line is kind of counter-intuitive from everything else as I also get frustrated when entering some of the transactions. It would be nice to have an option, if it isn't there already, where a enter/return could be made to interpret as moving to next line and

Re: [GNC] Price retrieval

Looking at the picture of the menu shows that it has been customized. Next best step would be to download the official full Windows package and try to install it. That should create and populate that group properly. I don't believe reinstalling it will harm in anyway as I have reinstalled

Re: [GNC] Fidelity and TD Ameritrade setup

I am willing to provide you with sample OFX files for brokerage accounts if you need them to implement it in aqbanking and improve it. Ping me privately at this e-mail address and I can make them available securely to you. ___

Re: [GNC] Fidelity and TD Ameritrade setup

, Michael Cc: Kalpesh Patel ; Gnucash-User ; April Subject: Re: [GNC] Fidelity and TD Ameritrade setup I don’t download a file. I turn on logging in aqbanking, make the connection, then copy the transactions out of the aqbanking log file into a separate text file for manual import. -- Dave

Re: [GNC] Fidelity and TD Ameritrade setup

PocketSense to download trades into GnuCash. -Original Message- From: David Reiser Sent: Monday, November 02, 2020 10:11 AM To: Kalpesh Patel Cc: April ; gnucash-user@gnucash.org Subject: Re: [GNC] Fidelity and TD Ameritrade setup Good to know. My Fidelity ofx data is up to date (I got a 10

Re: [GNC] Fidelity and TD Ameritrade setup

You may want to explore freeware product called PocketSense (at https://sites.google.com/site/pocketsense/ and https://pocketsense.blogspot.com/) by fine gentleman named Robert which is to more or less degree has been kept up with modern times. Robert will accept donation to Coffee Fund in case

[GNC] Start up with security prices updated during launch

Hi GNUCash User group - Is there a way to launch GNUCash in Windows 10 such that it also updated security prices from online sources for securities that are configured before displaying the scheduled transactions? I am using version 4.2 on Windows at the moment. I don't believe it's:

Re: [GNC] Will the file myStuff.gnucash work on Linux & Windows machines?

I haven't had any problem using it on Linux (through WSL) and Windows version of GNUCash . I actually have lower version of GNUCash on my Ubuntu (v3.11) then Windows (v4.2) which allows me to work between two without any issues. Of course I use XML as the target format for saving the file data.

Re: [GNC] Account view question

. From: Christopher Lam Sent: Thursday, October 08, 2020 8:17 AM To: Kalpesh Patel Cc: GnuCash users group Subject: Re: [GNC] Account view question Easiest process would be to generate a daily-resolution table, then post-process in spreadsheet. e.g. from Asset/Liability/Income/Expense

[GNC] Account view question

yesterday' type of column. If there is a way then any help that would make that column available for display would be welcome. Thanks. Kalpesh Patel ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences

<    1   2   3