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 Windows, good luck finding anything, but 'git' is still a good friend to have. -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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
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 gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] 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 the docs, all is much clearer now. Our two financial firms show success in the OFX database. Unfortunately, my bank is now Hancock-Whitney and they show OFX failure since 2018. They do have CVS manual downloads, but I haven't tried to automate that process. (Ideas welcome.) -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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
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 credentials? -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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
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 closest thing I've found for personal use that allows programmatic access to most any bank or other financial institution. Thanks. -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 - 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 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 print says you'll be given a "free" two-day membership to what sounds like a dating site. After that you'll be hit with a bill for almost $40 monthly. At my age it's easy to forget given such a short time to try it out "free." I didn't see a way to decline. Frankly, I would be fine with a more modest amount per month, with no long-term contract. -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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
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 buying stock and also Bonds.When I place the cost > (say Tesla) of $285.50 (A fake number) the tell it the number of stock I > want. it goes back to one. If you insist on replying to the digest, or copying it, PLEASE chop out the unused cruft. I can’t tell what you want. -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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
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 > worthwhile to invest your time in learning how to use a general purpose > automation tool. This approach has two advantages over data manipulation: > (1) Automation drives the GnuCash GUI and thus protects you from > accidental data corruption. > (2) You will be able to use your new automation skills to automate any > subsequent GnuCash tasks, for example loading historical transactions to > your 130 securities. > > For Windows, check out: > AutoHotKey https://www.autohotkey.com/ Geoff, that looks very interesting, thanks for the link. I do most of my work on Linux, but I do have to do some things on Windows (TL;DR), so this is very useful. One of the things I'm not sure about is how powerful the script is. For instance, can it determine the date for 16 months before the current date? That's one of the requirements for one of my banks earliest date of data retrieval. And one has to start over again for each different account. If it can't, then I will use the power of Raku to regenerate the autohotkey script for the current date. Best regards, -Tom P.S. Is there a spot on the Wiki to list things like Geoff's suggestion and flycatcher's program? If not, I will be glad to start one--suggestions welcomed. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] 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 your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] 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 they will be aware of such facilities even where > teller > staff aren't. Good idea, but so far I haven't had much luck. I'll keep plugging away. -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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
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 users not want to at least name banks they use and state whether or not they provide downloadable tranactions and in what format? Is it a private issue? -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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
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 all personal accounts including checking, savings, and > credit > > cards. There is a page on the GnuCash Wiki for OFX info: > > > >https://wiki.gnucash.org/wiki/OFX > > > > If your bank is NOT listed, please add it. If your bank IS listed, please > > make sure the informtion is correct. It would also help to add banks > known > > NOT to have either capability. > > Please don't. That page is *not* about downloading files outside of > GnuCash and then importing them with File>Import>Import OFX/QFX. It's about > the banks that support downloading directly into GnuCash using > OFX-DirectConnect, sadly a dwindling population. Point taken, John, so how about a new page, with an appropriate title, for financial institutions whose transactions download capability, or lack thereof, can be stated by real GnuCash users. (I confess that trying to name such a page on your Wiki will be daunting.) Regards, -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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
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 point. I am actively searching the ones I have accounts with, but it would be very helpful for us searchers if users such as yourself listed your successes. (And I will be glad to add them to the Wiki if need be.) And, again, the one bank I have that meets all my other requirements, does NOT have transaction downloads for personal accounts. But I am still working on asking HHQ (higher headquarters) about the issue. Thanks. -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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[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 appreciate users who can recommend specific US banks they know that provide OFX or CSV downloads for all personal accounts including checking, savings, and credit cards. There is a page on the GnuCash Wiki for OFX info: https://wiki.gnucash.org/wiki/OFX If your bank is NOT listed, please add it. If your bank IS listed, please make sure the informtion is correct. It would also help to add banks known NOT to have either capability. I'm thinking of adding a new Wiki page entitled "Financial firms and OFX-CSV capability" or something like that. Suggestions welcome. Best regards, -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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
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 my test pdf statements from Hancock-Whitney. It's a good resource to have in my toolbox! Thanks so much. -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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
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 all the set ups with auto payments, etc. Anyway, I love the excuse to program for the existing situation. On that note, I’m looking for the ofx and csv import test in the source to get some hints. Cheers! -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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
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 gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] 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: > > .., > > 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" language. > > > > Raku can also use Perl modules so I can use Finance::Quote with it if need > be. But, until I can get the bank data working, I won't be needing it. > > > > Thanks, Chris. > > > > -Tom > > > > Hi Tom, > > > > I was actually suggesting you just highlight the transactions in the pdf > statement and copy/paste them into a > > spreadsheet or text file before using a scripting language to reformat them > but if you can programmatically > extract the text that would be better long term. But I did see Peter West's warning about checking results carefully--it's not always the expected result. Although I hope the products from the same source are consistent enough to make it reasonably fool proof. (See my comments below.) > I notice with my PDF statement that (free) Adobe Acrobat DC no longer allows > me to select text (as they want me to pay for a fancy tool - BOO) but if you > send the pdf to Edge or Chrome you can select just the transaction text. Yes, I now see my "PDF COmplete" on Windows can do that--I never thought of doing that until now. > Thanks for the info re Raku. You're welcome! I'm always happy for programmers to learn about Raku > Finance::Quote is just for getting stock prices from websites (usually) so > not useful for this task. Right, but good to know for later. > Are you sure you cannot export transactions from your bank? All mine do > although sometimes it is hard to find. Yes, and I agree it's sometimes hard to find. Yesterday I did find one bank (the bank I'm leaving) does have two choices of download for the credit card: CSV and OFX. That is very helpful for working on a transformation algorithm. I did look at the PDF to text transformation on one of the new bank's statements (definitely nothing but PDFs) and it looks surprisingly usable, so that's exciting. I was too hasty in my outright condemnation of PDF to text because I had worked on a project with a PDF expert to generate PDF as a native file and saw how easy it is to get things out of place. I usually create beautiful, and accurate, PDFs by writing the PostScript code and relying on Ghostscript's ps2pdf converter. Thus going backwards in the workflow is a little different for my longtime mindset. Best regards, -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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
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 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] 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 bank specific). I'll see how my current PDF statements look after text conversion. But I'll also keep looking at YNAB for a more general solution. Cheers! -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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
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 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] 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" language. Raku can also use Perl modules so I can use Finance::Quote with it if need be. But, until I can get the bank data working, I won't be needing it. Thanks, Chris. -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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
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 access my bank while I can't, but I don't want the baggage that > comes with it. > I changed my mind. I now have an YNAB account and found that is has a well-documented API. Not only that, I was able to link it successfully to my two banks and access my checking, savings, and credit card transactions! It might be possible to use the API to periodically download bank and credit card transactions into YNAB's standard JSON format, then convert that into the OFX format, and then upload the OFX into GnuCash. I'm proceeding on the project with the hope of success. If anyone is interested in following it, the Raku (formerly Perl 6, see https://raku.org) module skeleton is on my Github repo now at https://github.com/tbrowder/API-YNAB.git. (Note I may soon change the title to something like YNAB2OFX or YNAB-OFX--suggestions are very welcome.) The downside, assuming I have success, is that YNAB has a subscription fee of about $15 per month plus tax (cancel any time) or $100 plus tax a year, sums well worth it if I can get a periodic good OFX-to-GnuCash import. Best regards, -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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[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 it. Does anyone know of a third-party entity I could use just to get access to the raw data for my personal accounts? Thanks. -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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
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 not clearly stated in anything I could find. Clarifying the documentation is always appreciated. > That brings to mind another question: which is the preferred set for a user to work on? I started on a fork of the xml source, but I just found again the docs on github for the rst version which are a *lot* easier to edit. -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 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] 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 its value from the > Asset > > total. > > > > But I wish it did! > > You might want to explain what you are trying to accomplish? My main point is it is not clear in the docs what hiding an account means. In another thread I explained what I wanted to do and I was told hiding one would remove it from the accounting equations. -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 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] 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 it. But the docs need to say that. I'm working on a doc PR and will try to find a place to say so. Thanks. -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 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] 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 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] 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 for now. To answer several helpers: the reason I wanted to hide or delete some accounts is because, years ago, I tried importing security data from several financial accounts but didn't keep them current. Most of those securities have since been either transferred to another institution, sold, or converted into IRA accounts. In general, I want to keep that original data but only for possible historical use for any audits. I want my book to just reflect active bank accounts, home improvements and basis, expenses, liabilities, and income. I will add existing non-bank financial assets in the aggregate (by institution, probably updated monthly, possibly via OFX or QIF). So, unless someone has any more suggestions, consider this thread closed. Thanks again for tons of friendly advice--I'm sure I'll be asking for help again. Blessings, -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 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] 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 format** to help the diffing be at least somewhat easier for a human eye to interpret if need be. -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 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] 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 > account you can choose another account for any splits to the deleted > account to > be redirected to. That sounds like the way to go! I saw in the docs one can hide an account, but I could not find in the docs what the effect of a “hidden” file is. Thanks, David! -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 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] 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 work in the long run!). One problem is that I don't think my banks support either QIF or OFX for personal accounts, but I'll check it out. I may also change my mind a bit and do a combo: (1) save a copy of the existing file, (2) delete obsolete accounts, and (3) reorg/update the leftover accounts. -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 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] 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 worthwhile for a few dozen transactions or so, at > least, that might fit in your plan. > > I would not ignore accounts, especially asset and liability accounts, but > try to redefine the income and expense accounts to make more sense. > Thanks, David. Is there any way to "turn off" an account while doing my clean-up? I do have many financial accounts that I would like to keep (at least for now) but have them not participating the book in the meantime. -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 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] 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 Gnucash. Is there any way to ignore accounts while incrementally working on tidying up my mess? Or should I just give up and start afresh (ugh)? Thanks. Cheers! -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 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] 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. > > > > That way I account for improvements that change the basis, and the summed > > balance of A:FA: is my current basis. > > > > -derek > > This is very much not a gnucash question per se. Or rather the gnucash > part of it rather simple, just make "basis" a parent with two children, > one for the original acquisition basis and one for later "improvements". > > BUT --- you need to know WHAT is allowed for each of these according to > IRS rules. The first part, "acquisition basis" is relatively simple and > probably already done long go. It's the second that is not so simple. > Not beyond the examples the IRS will use. In other words, what counts as > "improvements" which you can add to the basis and what is considered > "general maintenance" and you cannot add to the basis. Thus . Thanks, Michael. Yes, I understand the need for carefully determining, according to IRS rules, what is allowed for basis. But I'm not sure of what you're doing with the things not allowed for basis, e.g., maintenance expenses. (Unless you're talking about an invoice which might need to be split such as a reroof job plus chimney or dry rot repair.) -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 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] 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: is my current basis. Thanks, Derek. I think that’s all I need. Best regards, -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 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] 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 an example? The Gnucash docs do a good job for business applications, and I will try to adapt that to my case, but a better example for one's personal residence would be much appreciated. Best regards, -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 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] 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: 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] 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 without notice. (When I first started withGnuCash on Windows, I was able to unzip the xml file and save it unzipped as "myGnuCash.gnucash" successfully so I get version control over a text file for readable diffs.) 1. Is there any way to get GnuCash to save its file, by default, with an appropriate suffix other than "gnucash?" 2. Is there any hope of some kind of "commit" button to use with the SQLite version? 3. I assume the binary SQLite file is usable with a binary copy from Windows, is that true? 4. Is there any Perl program on Windows to convert the xml file to SQLite? Is there one on Linux? My immediate goal is to continue using my xml fille on Windows as the master data source until I'm comfortable with the SQLite version. During that time, I will periodically produce an SQLite version as a read-only one to experiment with on Linux. I would love to do that automatically. I have briefly looked at the (ugh) Python support and may go down that route, but not until I've looked at compiling from github on Linux and looked at what's available. Thanks for any help or suggestions. -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 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] 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 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] 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 want. Thanks, Michael, for the good tips Merry Christmas, -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 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] 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 real estate and we need accurate capital gain/loss calculations for the IRS. Given the age of the holdings, the accounts of those stocks in TD Ameritrade don't have accurate cost basis information, so I am belatedly trying to calculate that for tax filing purposes. I have all the records, but not all are in or available in digital form, so I have been laboriously entering them in a spreadsheet. Would it be worthwhile to set up a new data file just for those stocks and import/hand enter them in Gnucash instead? (I suspect any IRS auditor would be more impressed with my Gnucash data store than my Excel data store.) Thanks. -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 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 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 debit/credit convention. I just looked in detail about the nice changes in the version 4 series and wondered if that choice might be available now. The reason I still use the paper register is multifold: 1. My wife does not use a computer on a routine basis and we share the checking account, 2. I keep my Gnucash on Windows but do most of my computing on Linux, and 3. Much of our activity is auto-debit and auto-deposit and not always on a known date. So, my daily routine is to log in to our checking every morning on my Linux box and update the paper register from there. When I get around to it I update the Gnucash data (which is under git version control) on the Windows box. And, when I get my monthly bank statement, I reconcile both the register and Gnucash. All this stems from my experience with my first checking account at 17 when I found the bank actually made an error (in 1961, way before PCs)—the man at the bank was quite surprised! No more rambling, I am happy with Gnucash, and I may try scripting some of my work flow now that it seems user friendly. Best regards, -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 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 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 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] 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 paper from Office Depot to use it with. > > > > I took a look at the CheckWriter module but I'm a bit confused how you use > it with GnuCash. What are the steps that are necessary to print a check > from GnuCash using the CheckWriter module? Sorry, I did not grok the completevcontext. I thought you just needed a Linux check writer. The GnuCash interface was the second part of your need. -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 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] 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 utility that does it but I was hoping to find > something similar for Linux as I rarely use my Windows PC these days. 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 paper from Office Depot to use it with. -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 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] 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 configuration for reuse. The configs are saved in the book state > file and aren't amenable to sharing. Thanks, John, I didn't realize that (or forgot about it), and it's good to know! I will pass that on to my children for sure. (AFAIK they haven't started using it yet, but they can't say they haven't heard about it!) Best regards, -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 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] 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 (recently bought by Schwab), Fidelity, Fidelity Credit Card, Synovus Bank, Synovus Card Services, USAA (recently integrated software-wise with Schwab), and American Express Credit Card. How much effort to add a hook to GNU Cash to initiate the download? How much effort to add a CVS to GNU Cash converter? All of those CSV converters would probably require help from users having accounts, and maybe a first step would be a Perl (or Raku) CSV => OFX (or some other useful format) converter which I could help with. I already have some converters from CSV to other formats for Fidelity and TD Ameritrade products (in Raku), but I haven't looked at OFX in a long time (I do not enjoy working with XML in the least, but converting to XML is not so bad). I would also be willing to donate to the effort if it were deemed feasible and of interest. -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 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] 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 trying to find a replacement software for > Quicken. They don't have much competition. I refuse to use a service that > only provides web service so all your accounts are ready to be hacked all > in one place. > > I like having trouble finding a software that can reside on my laptop that > can download all my accounts from multiple banks in one easy step. > > I really like GNUCash. It looks great but I don't think in the long run it > is going to supply me with the features I need. > I understand, but good luck finding anything else. When I dumped Quicken many years ago I found another program I used for a while, but can't remember the name for it. I finally wrote my own check book program which I used until I found GNU Cash. If you are using GNU Cash to integrate all those accounts, have you thought of combining all or most of them under one house like Schwab or Fidelity or the like? Those now have much better analytical aids than I had with USAA and my wife and I have been happy with just TD Ameritrade and Fidelity. And both houses integrate well with H&R tax software (I took a clean break with Quicken a long time ago). Best regards, -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 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] 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 the problem (and it's more complicated since they just went with Schwab). I'm coming to this late but do they provide a CSV download? Best regards, -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 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] 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 you so much, John! Blessings, -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 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] 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 open source of documentation of the format? Thanks. Cheers! -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 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] 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 using a Perl module to search the wayback program on archive.org but so far I've had no luck (see on CPAN.org the module "WWW::WebArchive"). -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 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] 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 .. Thanks, John. -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 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] 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 using since I dumped Quicken many years ago. Note I only use it on Windows at the moment (mainly for access for my Windows-only wife), but can use it on my Debian at any time. I'm not interested so much interfacing with my account data as in getting the printing and check templating access at the moment. I see only one GnuCash module on CPAN, but that doesn't do what I need, although it does provide some help with developing Perl interfaces. I mainly program in Raku now (see https://raku.org) and its NativeCall access will help create the necessary interface if the API is reasonably documented or if some kind soul can point me in the right direction. I will of course publish anything I write that may be useful to others (see my repos at https://github.com/tbrowder). Best regards, -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 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] 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 think it hasn't been deleting older files. I just cleaned out old stuff yesterday so I can't say for sure. I will reset to a couple of days and see what happens. Thanks, Frank! -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 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] 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 too naive? Blessings, -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 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] 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 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] 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 > > repeat entry. That's why my data file has been version controlled since I started using GnuCash many years ago. I use git on the uncompressed version of the xml data file. -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 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: 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 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.
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 (loading saved views on start) on my large DB was not significantly different from the flat file. (To be fair, I didn't spend much time experimenting because I didn't want to get out of sync with the flat file DB.) Is there any specific SQLite improvement planned for Version 3? Thanks. Best regards, -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 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.
