Re: [GNC] Need help reconciling

2019-04-26 Thread ToddAndMargo via gnucash-user
On 4/26/19 10:13 PM, Liz wrote: On Fri, 26 Apr 2019 19:59:32 -0500 (CDT) David Cousens wrote: Me: Where's the ? Wife: In the refrigerator. Me: No it isn't. Wife: Yes it is. Me: Definitely is not! Wife: Walks to refrigerator, opens the door grab.s . from the front of the middle shelf.

Re: [GNC] Need help reconciling

2019-04-26 Thread Liz
On Fri, 26 Apr 2019 19:59:32 -0500 (CDT) David Cousens wrote: > Me: Where's the ? > Wife: In the refrigerator. > Me: No it isn't. > Wife: Yes it is. > Me: Definitely is not! > Wife: Walks to refrigerator, opens the door grab.s . from the > front of the middle shelf. > Wife Dirty look.

Re: [GNC] Changing account tree on large database

2019-04-26 Thread Liz
On Fri, 26 Apr 2019 21:49:12 -0400 Cricket Onebit wrote: > The speed thing is disappointing. I thought 3.5 fixed that, but maybe > not enough. I planned to save as XML to get going, since the docs say > it's more stable, then try SQLite. I found that 3.4 has greatly improved load and save speeds

Re: [GNC] QIF File import

2019-04-26 Thread David T. via gnucash-user
Tommy, Thanks for pointing to the wiki! Note that your first link (to the FAQ) simply refers the reader to the page at the second link… I think the page at this second link covers most of the issues that users have raised over the years. David T. > On Apr 27, 2019, at 4:17 AM, Tommy Trussell

Re: [GNC] Changing account tree on large database

2019-04-26 Thread David T. via gnucash-user
David, I think a couple of additional points of reference from you would be helpful. What operating system are you experiencing this slow performance? I believe it’s WIndows, but I could be mistaken. The relative performance benchmarks seem to be OS-dependent. I am using MacOS, and while some

Re: [GNC] Changing account tree on large database

2019-04-26 Thread Cricket Onebit
> > You WILL almost certainly see some strangeness in the imported data > because Quicken doesn't strictly enforce balanced transactions as GnuCash > does. When you're just dealing with a few years, you may find it easy to go > back and fix the odd strange transactions in Quicken, and start the imp

Re: [GNC] Changing account tree on large database

2019-04-26 Thread Cricket Onebit
On Fri, 26 Apr 2019 at 22:14, Tommy Trussell wrote: > > On Fri, Apr 26, 2019 at 8:49 PM Cricket Onebit > wrote: > >> The speed thing is disappointing. I thought 3.5 fixed that, but maybe not >> enough. I planned to save as XML to get going, since the docs say it's more >> stable, then try SQLite

Re: [GNC] Changing account tree on large database

2019-04-26 Thread Tommy Trussell
On Fri, Apr 26, 2019 at 9:13 PM Cricket Onebit wrote: > Somewhere I saw that most people find QIF works better, and that QIF is > similar to CSV. If my version of Quicken won't export to QIF, I'll try CSV. > There are too many variations of CSV for me to trust it entirely. > The QIF import USED

Re: [GNC] Changing account tree on large database

2019-04-26 Thread Tommy Trussell
On Fri, Apr 26, 2019 at 8:49 PM Cricket Onebit wrote: > The speed thing is disappointing. I thought 3.5 fixed that, but maybe not > enough. I planned to save as XML to get going, since the docs say it's more > stable, then try SQLite. > The "standard" XML files are quick enough for me, though as

Re: [GNC] Changing account tree on large database

2019-04-26 Thread Cricket Onebit
Somewhere I saw that most people find QIF works better, and that QIF is similar to CSV. If my version of Quicken won't export to QIF, I'll try CSV. There are too many variations of CSV for me to trust it entirely. I might make one huge QIF, import it and save as GC, then make another QIF just of r

Re: [GNC] Changing account tree on large database

2019-04-26 Thread Cricket Onebit
The speed thing is disappointing. I thought 3.5 fixed that, but maybe not enough. I planned to save as XML to get going, since the docs say it's more stable, then try SQLite. (Aside: https://wiki.gnucash.org/wiki/FAQ#SQL_Database recommends not using the SQL just yet. Several posts on this list sa

Re: [GNC] Need help reconciling

2019-04-26 Thread Tommy Trussell
On Fri, Apr 26, 2019 at 6:44 PM ToddAndMargo via gnucash-user < gnucash-user@gnucash.org> wrote: > On 4/26/19 4:36 PM, Tommy Trussell wrote: > > Most of the time you probably don't want to bother with the n or c flags > > in the ledger -- let GnuCash do that for you, through the > > I think the re

Re: [GNC] Need help reconciling

2019-04-26 Thread ToddAndMargo via gnucash-user
On 4/26/19 5:59 PM, David Cousens wrote: Me: Where's the ? Wife: In the refrigerator. Me: No it isn't. Wife: Yes it is. Me: Definitely is not! Wife: Walks to refrigerator, opens the door grab.s . from the front of the middle shelf. Wife Dirty look. That could be my house! ___

Re: [GNC] Need help reconciling

2019-04-26 Thread David Cousens
Me: Where's the ? Wife: In the refrigerator. Me: No it isn't. Wife: Yes it is. Me: Definitely is not! Wife: Walks to refrigerator, opens the door grab.s . from the front of the middle shelf. Wife Dirty look. - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash

Re: [GNC] Need help reconciling

2019-04-26 Thread Cricket Onebit
Sounds like me at the grocery store. Just tell me what aisle, even better something big beside it, and like magic it appears, even though I'd already checked that area thoroughly. On Fri, 26 Apr 2019 at 20:35, David Cousens wrote: > Todd, > > >Why I could not find it on my own, I can only specul

Re: [GNC] Changing account tree on large database

2019-04-26 Thread nvsoar
On 04/26/19 16:18, Tommy Trussell wrote: On Fri, Apr 26, 2019 at 4:53 PM David Carlson wrote: Strongly consider only moving one or two years data to GnuCash. I agree. I found that I could import a lot more, but I found I was going crazy trying to make everything look right, which ultimately

Re: [GNC] Need help reconciling

2019-04-26 Thread David Cousens
Todd, >Why I could not find it on my own, I can only speculate ... We all went through not being able to find stuff at one point. Sometimes the greatest help is just knowing it exists somewhere. David - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f14158

Re: [GNC] Need help reconciling

2019-04-26 Thread ToddAndMargo via gnucash-user
On 4/26/19 4:55 PM, David Cousens wrote: Todd, Google "GnuCash" and a keyword or phrase and google will usually locate specific info within the documentation on a topic. Doesn't always work but usually gets you into the ballpark. Google "GnuCash reconcile" lists the relevant help manual entry

Re: [GNC] Need help reconciling

2019-04-26 Thread ToddAndMargo via gnucash-user
On 4/26/19 4:57 PM, David Carlson wrote: If you are using GMail Zoho mail ___ 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 yo

Re: [GNC] Need help reconciling

2019-04-26 Thread David Carlson
ToddAndMargo, If you are using GMail, it tries to hide what it considers less important, which often accidentally hides important information. Click on the three dots icon to see the rest. David Carlson On Fri, Apr 26, 2019 at 6:43 PM ToddAndMargo via gnucash-user < gnucash-user@gnucash.org> wr

Re: [GNC] Need help reconciling

2019-04-26 Thread David Cousens
Todd, Google "GnuCash" and a keyword or phrase and google will usually locate specific info within the documentation on a topic. Doesn't always work but usually gets you into the ballpark. Google "GnuCash reconcile" lists the relevant help manual entry as well as the tutorial and concepts guide

Re: [GNC] QIF File import

2019-04-26 Thread David Carlson
Hardeep Sodhi, I believe that I have seen some reference in this mail list to an issue with that tradable comodities screen. If you are careful to avoid importing transactions involving stocks or currencies other than your home currency then you should not see that screen. Others may be able to

Re: [GNC] Need help reconciling

2019-04-26 Thread ToddAndMargo via gnucash-user
https://www.gnucash.org/docs/v3/C/gnucash-guide/cc-together1.html Thank you! Now I have a place to start. For the life of me I could not find that chapter! I bet it was right under my nose too! On 4/26/19 4:36 PM, Tommy Trussell wrote: Most of the time you probably don't want to bother wit

Re: [GNC] Need help reconciling

2019-04-26 Thread Tommy Trussell
Hi! Welcome to GnuCash! On Fri, Apr 26, 2019 at 5:22 PM ToddAndMargo via gnucash-user < gnucash-user@gnucash.org> wrote: > I have been looking over the "Reconcile" on on eof m yu > credit card account. I just don understand what I am seeing. > > 1) do I put a "c" in the opening balance as I > I

Re: [GNC] Changing account tree on large database

2019-04-26 Thread Tommy Trussell
On Fri, Apr 26, 2019 at 4:53 PM David Carlson wrote: > Strongly consider only moving one or two years data to GnuCash. > I agree. I found that I could import a lot more, but I found I was going crazy trying to make everything look right, which ultimately seemed pointless for things like long-ago

Re: [GNC] QIF File import

2019-04-26 Thread Tommy Trussell
On Wed, Apr 24, 2019 at 9:58 PM Hardeep Sodhi wrote: > I am trying to import Quicken data into Gnucash. > > I have created a QIF File. The import starts well, but stops at the > 'Tradeable Commodities' screen since there is no 'Next' button I can see at > the bottom of the screen ( as there is in

[GNC] Need help reconciling

2019-04-26 Thread ToddAndMargo via gnucash-user
Hi All, I have been looking over the "Reconcile" on on eof m yu credit card account. I just don understand what I am seeing. 1) do I put a "c" in the opening balance as I I has checked it? 2) I have put "C" in all the charges on my bank statement. 3) I press the Reconcile button and I put in

Re: [GNC] Changing account tree on large database

2019-04-26 Thread David Carlson
Cricket, One more point... Strongly consider only moving one or two years data to GnuCash. When your file gets large you may prefer to have a new file for each year or whatever to keep GnuCash from bogging down and running too slow. It gets worse quickly if you leave a lot of reports and regist

Re: [GNC] Changing account tree on large database

2019-04-26 Thread Cricket Onebit
On Thu, 25 Apr 2019 at 17:29, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > > I'm preparing to convert 14,000 transactions from Quicken. It's a bit > > overwhelming, and I've put it off for years. > > Sounds like a daunting task. I don’t do such imports, but reading the > various th

Re: [GNC] Changing account tree on large database

2019-04-26 Thread Cricket Onebit
That page gave me nightmares when I first read it two years ago. I ran a few tests, then procrastinated. Nothing's difficult, but there's a lot to do. It looks like I should anticipate problems with the matcher for transfers between accounts, and for split transactions. I'll make before/after repo

[GNC] Curl expertise -- off list

2019-04-26 Thread Stephen M. Butler
Sorry for the off topic post.  Any users knowledgeable with curl and willing to go off-list to help this neophyte?  For personal project unrelated to GnC. --Steve Feel free to directly mail me to either of the below addresses. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arr

Re: [GNC] Finance::Quotes stopped working for me

2019-04-26 Thread David Carlson
Bruno, I am a retired Electrical Engineer with no formal training in modern programming languages but I am passionate about safe use of the Internet and environmental stewardship. I also use GnuCash for personal financial record keeping. With that background I depend on the GnuCash developers to

Re: [GNC] OFX Import add Memo to transaction

2019-04-26 Thread Jeff Albrecht
Groovy, boss and kean -or- OMG, snap and Shredding. Plus red face and a little embarrassment. But I didn't realize and it never occurred to me that my vendors / sellers had report exports! Amazon has CSV export as well as a much more useful on screen report than looking through the online 'you

Re: [GNC] Finance::Quotes stopped working for me

2019-04-26 Thread Bruno Acklin
Thanks David, Does the corresponding curl command work from your other computers as well? Any suggestions what “coercing” involved in your case? Best, Bruno > On Apr 22, 2019, at 6:48 PM, David Carlson > wrote: > > I too use ATT&T Uverse as my ISP and i know they do have some strange > setti

Re: [GNC] OFX Import add Memo to transaction

2019-04-26 Thread David Carlson
I can see a new workflow developing for some users. First, download lists of recent purchase transactions from Amazon, EBay, Paypal or Walmart. Second, download lists of recent charges to one or more bank or credit card accounts. Third, reconcile both sets of lists, including linking transactions

Re: [GNC] GNU Cash End of Year Closing of Accounts

2019-04-26 Thread Michael or Penny Novack
On 4/25/2019 5:54 PM, Stephen Brandt wrote: I am looking for a way to archive out all transactions for the Year ending . I would like to remove all transactions from all accounts and start the new year with the ending balance from the previous year. To view prior years I'd like to be able to

Re: [GNC] OFX Import add Memo to transaction

2019-04-26 Thread Jeff Albrecht
On 4/26/2019 3:22 AM, Liz wrote: On Wed, 24 Apr 2019 13:24:29 -0700 Jeff Albrecht wrote: I'm using GNUCash on Windows 10 using version 3.5.1 upgraded from 2.6.19. As I import a .OFX file from my bank or credit card and match/enter/edit with the 'Generic import transaction matcher' I sit with

Re: [GNC] VAT Reporting

2019-04-26 Thread Maf. King
Hi Laurel, Did yo manage to get the VAT figures you need out of GC? Was going to do mine this week... ahh well, not gonna happen! the MTD solution I'm getting round to is a spreadsheet supplied by a 3rd party (costs money to submit the figures to HMRC), that seems like it should more or less g

Re: [GNC] VAT Reporting

2019-04-26 Thread Laurel Brunner
Dear Maf., Thanks for this. I am confident that HMRC has other things on their mind at the moment and that they will struggle to deal with an overwhelming number of small businesses such as mine who have no idea how to make tax more digital than it already is. All best, -Laurel. > On 25 Apr

Re: [GNC] VAT Reporting

2019-04-26 Thread Laurel Brunner
Dear Christopher, Thanks so much for the prompt and comprehensive answer. I am struggling but getting there. Much appreciated. Happy Friday! -Laurel. > On 25 Apr 2019, at 17:03, Christopher Lam wrote: > > Hi Laurel > > Quarterly VAT reports are a breeze if your VAT collected/paid accounts

Re: [GNC] GNU Cash End of Year Closing of Accounts

2019-04-26 Thread Liz
On Thu, 25 Apr 2019 16:54:34 -0500 Stephen Brandt wrote: > I am looking for a way to archive out all transactions for the Year > ending .  I would like to remove all transactions from all > accounts and start the new year with the ending balance from the > previous year. To view prior years I

Re: [GNC] OFX Import add Memo to transaction

2019-04-26 Thread Liz
On Wed, 24 Apr 2019 13:24:29 -0700 Jeff Albrecht wrote: > I'm using GNUCash on Windows 10 using version 3.5.1 upgraded from > 2.6.19. > > As I import a .OFX file from my bank or credit card and > match/enter/edit with the 'Generic import transaction matcher' I sit > with my Ebay and PayPal accou

Re: [GNC] How to see major category totals by month?

2019-04-26 Thread Eric Sokolowsky
After a bit more searching, I think I found what I wanted. In the Options for the Profit & Loss report, under the Display tab, there is a line that says Parent Account Subtotals which should be changed to "Show Subtotals." Eric On Fri, Apr 26, 2019 at 5:41 AM Eric Sokolowsky wrote: > In the Acc

[GNC] How to see major category totals by month?

2019-04-26 Thread Eric Sokolowsky
In the Accounts view, I can see all of the major categories (Expenses, Income, etc) with the aggregate totals of all transactions in their respective subcategories, along with individual subtotals of all subcategories. Is there a way of showing these major category aggregate totals for a specific m

[GNC] GNU Cash End of Year Closing of Accounts

2019-04-26 Thread Stephen Brandt
I am looking for a way to archive out all transactions for the Year ending .  I would like to remove all transactions from all accounts and start the new year with the ending balance from the previous year.  To view prior years I'd like to be able to select the archive file for the appropriate

Re: [GNC] Downloading stock prices in the UK

2019-04-26 Thread AEG via gnucash-user
Eric Success!! Thank you very much for your detailed help with this problem. Quite by chance, I looked at "Preferences" and in "Online Quotes" discovered the need for an Alpha Vantage API key, which I hadn't seen any mention of in the tutorial. Once I had obtained and applied that key, the downlo