Re: [GNC] Old book not opening

On Sun, Nov 12, 2023 at 09:18 Phil Reynolds wrote: ... What OS are you running? I have not seen any complete or partial path name to the files you mention you are looking for. If you are running Linux or MacOS, 'updatedb', 'locate', and 'git' are good friends to have. I you are running

Re: [GNC] GnuCash_user: rounding errors and significant digits

On Tue, Sep 26, 2023 at 11:50 john wrote … Thanks, John—nice work! -Tom ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user -

Re: [GNC] GnuCash_user: rounding errors and significant digits

On Mon, Sep 25, 2023 at 20:07 Bruce McCoy via gnucash-user < gnucash-user@gnucash.org> wrote: ...discussion of GnuCash's handling of numbers... Does GnuCash use the Gnu Multiple Precision Arithmetic (GMP) library? -Tom ___ gnucash-user mailing list

Re: [GNC] Using Plaid

On Sat, Mar 4, 2023 at 12:06 Steve Brown wrote: > If you are referring to the file I store, it is the response from the > OFX server and doesn't contain credentials. > > If you are referring to the request, I'm using the keyring approach > referred to by Sherlock. Thanks, Steve. After seeing

Re: [GNC] Using Plaid

On Fri, Mar 3, 2023 at 04:20 Steve Brown wrote: > I've been using ofxget to download statements from Fidelity, Wells > Fargo and Truist for the last several months. I made a few changes so > it writes to a file that I import to Gnucash. How do you use (wrap) the file to protect your

Re: [GNC] Using Plaid

On Wed, Feb 22, 2023 at 16:02 Ben Pracht wrote: > I'd like to use Plaid with GnuCash. There is a plaid2qif project that How are you able to use Plaid at all? What service do you have access to that provides access to your personal finances? Or are you using it for a business? YNAB is the

Re: [GNC] Is this a wacky idea?

On Sun, Jan 29, 2023 at 05:23 flywire wrote: > Anyone can run https://portableapps.com/apps/office/gnucash_portable in > Windows without installing it. It is probably better than installing It sounds great, but color me skeptical. I have looked at portableapps twice now and declined. The fine

Re: [GNC] gnucash-user Digest, Vol 234, Issue 6

On Sat, Sep 3, 2022 at 07:25 James Baxter via gnucash-user < gnucash-user@gnucash.org> wrote: > I am James Baxter and I am playing with this and made a mistake with my > with my checking account, as I found out what my problem was. Not entering > income the right way. > So I am looking to start

Re: [GNC] How to bulk import about 130 Securities entries?

On Sun, Aug 14, 2022 at 00:40 Geoff wrote: > Hi Jim > > I don't have any experience manipulating GnuCash XML files, but in > principle what you want to do should work, although it does void your > GnuCash warranty. > > However, if you are going to all this effort you may find it more >

Re: [GNC] Banks with OFX or CSV account data downloads

On Wed, Aug 10, 2022 at 00:00 Tracy wrote: > As with so many things, your mileage may vary, but... Thanks so much, Tracy—that’s very helpful. Some of those banks are in my area. -Tom ___ gnucash-user mailing list gnucash-user@gnucash.org To update

Re: [GNC] Banks with OFX or CSV account data downloads

On Tue, Aug 9, 2022 at 20:54 wrote: > Tom, > There is another issue with putting up a list of banks known not to supply ... Okay, I'll stop fooling with that idea--you're all right. > The best place to find out what a bank website can or can't do is usually > from > their IT department, as

Re: [GNC] Banks with OFX or CSV account data downloads

On Tue, Aug 9, 2022 at 16:11 David Carlson wrote: > Tom, > > As Gyle mentioned, the vast majority of banks, credit card companies and > even online > David, that the "vast majority" allegedly provide such capability doesn't help someone looking for a local bank providing such. Why do GnuCash

Re: [GNC] Banks with OFX or CSV account data downloads

On Tue, Aug 9, 2022 at 15:12 John Ralls wrote: On Aug 9, 2022, at 10:10 AM, Tom Browder wrote: ... > > To continue in a more direct way to fix my problem, I would appreciate > > users who can recommend specific US banks they know that provide OFX or > CSV > > downloads for

Re: [GNC] Banks with OFX or CSV account data downloads

On Tue, Aug 9, 2022 at 15:00 Gyle McCollam wrote: > I use 6 different banks and many more credit cards and they all offer > downloads in CSV or QFX. > Gyle, can you please list them and what they provide? I understand that one may have to search around, but it would help to have a starting

[GNC] Banks with OFX or CSV account data downloads

On another thread I asked for any third-party resources for converting pdf bank statements to another format. One in particular works good enough for my current bank, Hancock-Whitney. The resource was suggested by Christopher Lam. To continue in a more direct way to fix my problem, I would

Re: [GNC] Third party OFX/CVS providers

On Sun, Aug 7, 2022 at 09:32 Tom Browder wrote: > On Sun, Aug 7, 2022 at 09:09 Christopher Lam > wrote: > >> You may try this service which is free for personal use. (Not mine) >> >> https://bankstatementconverter.com/ >> > That does a good job, at least on

Re: [GNC] Convert PDF to OFX/CVS

On Sun, Aug 7, 2022 at 13:10 rick1 via gnucash-user < gnucash-user@gnucash.org wrote: … > What Mr. Browder really needs is a different bank. For a bank to not > provide a usable digital download ought to be disqualifying. I agree, Rick, and I am looking. But it’s not trivial changing banks with

Re: [GNC] Third party OFX/CVS providers

On Sun, Aug 7, 2022 at 09:09 Christopher Lam wrote: > You may try this service which is free for personal use. (Not mine) > > https://bankstatementconverter.com/ > Thanks, Christopher, I’ll give it a shot. -Tom ___ gnucash-user mailing list

Re: [GNC] Third party OFX/CVS providers

On Sat, Aug 6, 2022 at 21:25 Chris Good wrote: > From: Tom Browder > Sent: Sunday, 7 August 2022 12:37 AM > To: Chris Good > Cc: gnucash-user@gnucash.org > Subject: Re: [GNC] Third party OFX/CVS providers > > > > On Sat, Aug 6, 2022 at 08:51 Chris Good wrote: > &

Re: [GNC] Third party OFX/CVS providers

On Sat, Aug 6, 2022 at 18:40 Peter West wrote: > The other great tool for processing pdfs is PDFBox. It’s a java jar file, > so you need to have a reasonably recent JVM installed. > ... Thanks, Peter. And God bless you and yours! -Tom ___

Re: [GNC] Third party OFX/CVS providers

On Sat, Aug 6, 2022 at 11:43 AM Glenn Fowler wrote: > > My scripts are in PowerShell. For GhostScript I'm just using CLI: Thanks, Glenn, that's close to what I've found for Linux: $ gs -sDEVICE=txtwrite -o output.txt input.pdf It just needs some tweaking and post-conversion parsing (very

Re: [GNC] Third party OFX/CVS providers

On Sat, Aug 6, 2022 at 10:43 AM Glenn Fowler wrote: > > Look into GhostScript and iText7. I have used both to pull text out of PDF's > easily in scripts. What program language? Can you show me an example of your code to do that? Thanks. -Tom ___

Re: [GNC] Third party OFX/CVS providers

On Sat, Aug 6, 2022 at 08:51 Chris Good wrote: .., > Can you copy the text out of the pdf statement? Getting "organized" text programmatically out of PDF is a giant pain. My current approach is almost completely programmatic. BTW, Raku is the "sister" language of Perl, and it is a "scripting"

Re: [GNC] Third party OFX/CVS providers

On Wed, Aug 3, 2022 at 17:39 Tom Browder wrote: > My current bank (US, Hancock Whitney) unfortunately does not provide > account data in a digital format other than monthly PDF statements for > personal accounts. I know third-party programs, such as YNAB (ynab.com), > can get ac

[GNC] Third party OFX/CVS providers

My current bank (US, Hancock Whitney) unfortunately does not provide account data in a digital format other than monthly PDF statements for personal accounts. I know third-party programs, such as YNAB (ynab.com), can get access my bank while I can't, but I don't want the baggage that comes with

Re: [GNC] What is the intended effect of hiding an account ?

On Thu, Jul 21, 2022 at 15:53 David Carlson wrote: > Perhaps another user misunderstood your question. John R is a major > developer and he has a very good idea of what is going on inside the > program. > David, I probably misunderstood (the conversation got a little unstructured), but it's

Re: [GNC] What is the intended effect of hiding an account ?

On Thu, Jul 21, 2022 at 14:45 Michael or Penny Novack < stepbystepf...@comcast.net> wrote: > On 7/21/2022 2:13 PM, Tom Browder wrote: > > >From my attempt at hiding several Asset subaccounts, the effect is to > > remove it from view. It does *not* seem to remove it

Re: [GNC] What is the intended effect of hiding an account ?

On Thu, Jul 21, 2022 at 13:53 David Carlson wrote: > Tom, > > If you really want to remove the value of an account from your data you > can enter a transaction to zero out the account the same way you close a > bank or credit card account by moving the funds to another location. > Okay, I get

[GNC] What is the intended effect of hiding an account ?

>From my attempt at hiding several Asset subaccounts, the effect is to remove it from view. It does *not* seem to remove its value from the Asset total. But I wish it did! -Tom ___ gnucash-user mailing list gnucash-user@gnucash.org To update your

Re: [GNC] Revising an old Gnucash file

On Tue, Jul 19, 2022 at 3:27 PM Tom Browder wrote: > I have my original Gnucash file which has been continually used (for about 15 > years) mainly as a simple check book app to replace Quicken. I appreciate all the help and suggestions I've received. I think I know how to proceed f

Re: [GNC] Transaction imports

On Tue, Jul 5, 2022 at 07:53 Christian Lynbech wrote: > Where is the information related to transaction imports saved? I am on a > Mac. > > I have my books stored under revision control FWIW, I also keep mine under version control with git. I make sure the data file is in **unzipped xml

Re: [GNC] Revising an old Gnucash file

On Tue, Jul 19, 2022 at 16:57 wrote: > Tom, > > You can make accounts hidden. Edit the account in the Account tab and > select the > hidden button in the dialogue. You can always then use the right click in > the > Accounts tab, select Find Account and unhide them in future. If you delete > an >

Re: [GNC] Revising an old Gnucash file

On Tue, Jul 19, 2022 at 15:52 Phyllis Bruce wrote: > > Tom, best wishes! I had to abandon Microsoft Money after 30 years. I > suggest you do as I did, even though you've been using GC. Thanks, Po. I'm too lazy to start over again, but I'm sure your method is probably the best (and maybe less

Re: [GNC] Revising an old Gnucash file

On Tue, Jul 19, 2022 at 15:51 David Carlson wrote: > I would develop a plan that would probably include some limited steps of > improvement with backups between steps. Now that there is a way to export > and import transactions via CSV between files if there is enough > commonality to make it

[GNC] Revising an old Gnucash file

I have my original Gnucase file which has been continually used (for about 15 years) mainly as a simple check book app to replace Quicken. I am motivated now to (1) improve the account structure and (2) start moving toward a properly used double-entry system so I can use the full power of

Re: [GNC] Example of accounts for a personal residence with entries for US tax basis

On Tue, Jul 12, 2022 at 09:38 Michael or Penny Novack < stepbystepf...@comcast.net> wrote: > On 7/12/2022 9:01 AM, Derek Atkins wrote: > > The way I do it personally (note: IANAA) is that I have an Assets:Fixed > > Assets: account with subaccounts for, e.g. Purchase, > > Renovations, etc. > > > >

Re: [GNC] Example of accounts for a personal residence with entries for US tax basis

On Tue, Jul 12, 2022 at 08:01 Derek Atkins wrote: > The way I do it personally (note: IANAA) is that I have an Assets:Fixed > Assets: account with subaccounts for, e.g. Purchase, > Renovations, etc. > > That way I account for improvements that change the basis, and the summed > balance of A:FA:

[GNC] Example of accounts for a personal residence with entries for US tax basis

I have looked at several accounting books and websites for an example of accounting for an owner's personal residence and US fedral tax treatment for improvements contributing to basis, but I haven't yet found a recipe suitable for my lame level of bookkeeping knowledge. Can anyone point to such

Re: [GNC] New to GnuCash SQLite on Windows: I have questions

On Tue, Apr 19, 2022 at 20:20 Derek Atkins wrote: > Hi, > ... Thanks much, Derek. -Tom ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

[GNC] New to GnuCash SQLite on Windows: I have questions

I just updated my MS Windows GnuCash version to 4.10 and see the new option to save my GnuCash xml file in SQLite format. In general, I like it! However, I had a few moments of panic when Windows wanted to save the file without a name change. I also forgot the changes in the SQLite file are done

Re: [GNC] Stock transaction research

On Sat, Nov 27, 2021 at 18:17 Geoff wrote: > Hi Tom > > I suggest you read Chapter 9 Investments: > https://www.gnucash.org/docs/v4/C/gnucash-guide/invest_concepts1.html ... Thanks, Geoff, will do. Blessings, -Tom ___ gnucash-user mailing list

Re: [GNC] Stock transaction research

On Sat, Nov 27, 2021 at 12:10 Michael or Penny Novack < stepbystepf...@comcast.net> wrote: … > Whether worthwhile or not, you'd have to judge, but since you would be > hand entering the data in either case, not more work using gnucash and > as you note, easier t produce the reports you would

[GNC] Stock transaction research

I have been browsing various Gnucash documentation areas and think Gnucash might be able to help me with a tedious task: properly account for all transactions on stocks bought many years ago which have undergone spinoffs, splits, reverse splits, renames, etc. The stocks were recently sold to buy

Re: [GNC] Can I reverse the "deposit" and "withdrawal" columns for checkbook entry?

On Sat, Oct 16, 2021 at 13:54 John Morris wrote: > All these arguments hold very little water in the real world. Thanks, John. (And also thanks to John Ralls and Stan). I definitely am not complaining about Gnucash, I am grateful for it and the wonderful developers. I am also aware of the

[GNC] Can I reverse the "deposit" and "withdrawal" columns for checkbook entry?

My bank's checkbook register has the "withdrawal" and "deposit" columns in the reverse order of that shown in Gnucash. Is there any way to reverse them in Gnucash for ease of use? Thanks. -Tom ___ gnucash-user mailing list gnucash-user@gnucash.org To

Re: [GNC] A Linux utility/program to print ABA and account numbers on stock/blank checks

On Thu, May 20, 2021 at 16:15 local10 via gnucash-user < gnucash-user@gnucash.org> wrote: > May 20, 2021, 10:57 by tom.brow...@gmail.com: > > > Keep an eye out for my Raku module CheckWriter at <> > https://github.com/tbrowder/CheckWriter> > (a WIP). I bought a pack of > single-check letter-size

Re: [GNC] A Linux utility/program to print ABA and account numbers on stock/blank checks

On Wed, May 19, 2021 at 23:49 local10 via gnucash-user < gnucash-user@gnucash.org> wrote: > May 20, 2021, 03:39 by jra...@ceridwen.us: > > Yes, if one doesn't print many checks per month (less than ten, I'd say) > the bank will process it even without the magnetic ink. > > I have a small Windows

Re: [GNC] OFX connections

On Fri, Feb 19, 2021 at 11:05 John Ralls wrote: > Tom, ... > GnuCash already has a CSV import facility: Use File>Import>Import > Transactions from CSV. There you can associate columns in the CSV with > GnuCash fields and adjust CSV parameters. Once you have it set up you can > save the

Re: [GNC] OFX connections

On Thu, Feb 18, 2021 at 23:27 John Ralls wrote: > I'm pretty sure David was being facetious. There's approximately zero > chance that any bank is going to undertake developing a new transfer > protocol. How many banks and financial houses still allow CVS download? All of ours do: TD Ameritrade

Re: [GNC] USAA

On Wed, Feb 17, 2021 at 12:21 Richard wrote: > Tom, > > Thanks for the message. > > They do have CSV downloads. > > That works but between my wife and I, we have like 6 accounts plus credit > card accounts with other banks. That makes downloading a CSV for each one > very time consuming. I am

Re: [GNC] USAA

On Wed, Feb 17, 2021 at 11:08 Richard via gnucash-user < gnucash-user@gnucash.org> wrote: > I spoke with USAA tech support this morning. They told me GNU software > is not supported due to the software security issues. Richard, I stopped using USAA a couple of years ago, but I vaguely remember

Re: [GNC] TXF file format

On Sat, Oct 31, 2020 at 12:53 John Ralls wrote: ... > It looks like Intuit has pulled their page but there's a copy here: ... > > https://github.com/simonmichael/hledger/blob/master/examples/TXF-spec-v042.org > and here: > http://support.moosetechsoftware.com/solutions/txfspecs42.txt Thank

[GNC] TXF file format

I've searched the gnucash repository for infomation on the TXF format but haven't yet found a live reference to the specification. There is a also reference on the net but the reference, too, is a dead link. Does anyone have a copy of the old Intuit TXF reference available or know of any other

Re: [GNC] TXF file format

On Fri, Oct 30, 2020 at 06:43 Tom Browder wrote: > > I've searched the gnucash repository for information on the TXF format but > haven't yet found a live reference to the specification. There is a also > reference on the net but the reference, too, is a dead link. I've been

Re: [GNC] Check printing via the command line?

On Fri, Jul 17, 2020 at 18:16 John Ralls wrote: > > On Jul 17, 2020, at 8:27 AM, Tom Browder wrote: > > Is there any way to access the check printing capability of GnuCash via a > > CLI? ... > No, sorry, only reports can be printed from the command line, nor is ..

[GNC] Check printing via the command line?

Is there any way to access the check printing capability of GnuCash via a CLI? I haven't tried it via the GUI yet. I just became interested this morning when I had to write a check manually and, being of advanced age with not-so-good hand-writing, thought about the GnuCash software I've been

Re: [GNC] Gnucash logs

On Mon, Apr 27, 2020 at 10:46 AM Frank H. Ellenberger wrote: > Hi Tom, ... > doesn't adjusting Edit->Preferences->General:Retain log/backup files > bring some relief? I completely forgot about that--I haven't looked at it in many years. However, I see that it's always been set on 30 days and I

Re: [GNC] Gnucash logs

On Sat, Apr 25, 2020 at 11:01 PM D. wrote: > Unfortunately, no. This is a long standing feature request. See: ... Thanks for the reply. I don't speak Lisp or its dialects much, but at adding a log directory "sounds" fixable fairly easily enough for a fairly experienced programmer. Is my opinion

[GNC] Gnucash logs

Is there any way to get Gnucash to write its logs in another directory to keep its working directory less cluttered? Thanks, -Tom P.S.I love Gnucash! ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to

Re: [GNC] Lost my GnuCash data

On Mon, Oct 8, 2018 at 9:53 AM John Ralls wrote: > > On Oct 7, 2018, at 5:35 PM, Arnie Yahoo via gnucash-user > > wrote: > > > > I have been posting deposits and checks to GnuCash from 1/1/18 to end of > > Sept. > > When I opened the file only data up to Feb 2 appeared, other than a monthly >

Re: GnuCash 3.0 Released

On Mon, Apr 2, 2018 at 3:49 PM, C M Reinehr wrote: > John, > > Thanks for all your hard work. GnuCash is an invaluable piece of software. Amen, Brother! -Tom ___ gnucash-user mailing list gnucash-user@gnucash.org To update your

Version 3: Improved SQLite response?

First let me say I have been a user of GNU Cash (on Windows) for many years, and I greatly appreciate the efforts of all the developers. Thank you all so much! My question: I tried SQLite early after it was considered usable by ordinary users, but was disappointed to see that the response time