Re: [GNC] Need help reconciling

[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.


Here it's called "boy look" 
as in
"You only had a boy look"

:D

Liz
___
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] Changing account tree on large database

[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. Then my
motherboard failed, and the new hardware is of course far better than
the last, so I can't compare new and old now.
Currently my 1.8Mb database loads in 11sec. I'm not on 3.5 yet.

Liz
___
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] QIF File import

[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  wrote:
> 
> 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 screens previous).
>> 
>> I think this is a user interface issue. Have tried on my laptop as well as
>> desktop but with no success.
>> 
> 
> What version of GnuCash?
> What operating system?
> 
> Have you checked the FAQ?
> https://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_import_my_data_from_...
> 
> Have you seen the FAQ link to the Quicken Migration page?
> https://wiki.gnucash.org/wiki/Quicken_Migration
> 
> I have not done a QIF import in many years, but if you're importing several
> years of data you might go back into Quicken and export just a single year
> or a single account category to get started. You can do several "test"
> imports and see ways to make the final import go a lot smoother. Since
> you're stumbling on "tradeable commodities," maybe at minimum it would help
> to export your trading accounts separately.
> 
> If you continue to have trouble at a specific point, you may need to look
> carefully at the QIF file in a text editor to see if you can see an obvious
> error in the data.
> 
> (Please don't forget to reply to the list, as suggested below.)
> 
> 
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>> 
> ___
> 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.

___
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] Changing account tree on large database

[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 reports do load slowly 
(the Asset Barchart comes to mind), most of my experience has been positive on 
this regard. I do not see delays on entry—certainly not on order of seconds.

Similarly, what size is your data file? Mine goes back 13 years, and a quick 
survey of the file in SQL format shows 900 entries in accounts, a little over 
27,000 transactions with 63,000 splits overall. As compressed XML, it’s just 
over 4MB. My data file is larger than Cricket’s proposed import, and I am not 
seeing problems on my setup. Of course, that all could change when I migrate to 
different machine and OS later this year...

My point is that your experience, while real and a valid data point, is 
nonetheless your experience, and not necessarily the norm. My own (similarly 
singular) experience is starkly different from yours. I think the overall user 
experience is somewhere along the line between these two. 

FWIW, my import process from Quicken (way back when) took a while to work out, 
but I eventually was able to import the entire QIF file (account structure and 
all) directly into GnuCash. My method was to export the QIF, import into 
GnuCash, see the gaps and failures, go back to Quicken (where my familiarity 
allowed me to fix things quickly), change the Quicken data to address the gaps, 
and repeat until such point as the incoming data was clean enough to move 
forward.

David T.

> On Apr 27, 2019, at 3:20 AM, David Carlson  
> wrote:
> 
> 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 register windows open, or if you
> have a Hi-Res monitor, and having a powerful computer is not enough to
> prevent that.
> 
> In my case it takes over a minute to open my file and about 10 seconds
> every time I press the Enter key.  the periodic saves take so long that I
> can squeeze in about 1/2 a game of Solitaire.
> 
> David Carlson
> 
> On Fri, Apr 26, 2019 at 4:31 PM Cricket Onebit 
> wrote:
> 
>> 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 threads over the years, this will be a doozy.
>>> 
>> 
>> Yes, it's a daunting task, but I do't want to lose 10+ years of data. I'm
>> using an old version of Quicken, and don't trust the new version to be able
>> to read it. The old version might not work on newer Windows. I need to move
>> it.
>> 
>> I’d try finding some of those threads or asking about a general ‘best
>>> practices’ or ‘workflow’ to accomplish this with the least amount of
>>> headache.
>>> 
>> 
>> There doesn't seem to be an easy way to find those threads. I might not be
>> searching right. "site:lists.gnucash.org quicken" has posts from many
>> years
>> ago on the first page, but not any from 2019. I know there are some from
>> 2019.
>> 
>> Two gnucash.org pages need to be updated. They have broken links.
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> https://lists.gnucash.org/search/?idxinfo=gnucash-user
>> 
>> Yes, you can do this at will, over and over till you have your tree the way
>>> you like it. (and then re-factor it again months later when you change
>> your
>>> mind)
>>> 
>> 
>> Yay! for easy moving / promoting / demoting / etc child / parent / sibling
>> / cousin accounts. Both your suggested methods make sense.
>> 
>> One less reason to put off the migration.
>> 
>> Also, for this particular example, I’d opt for tags for each kid instead of
>>> accounts, see below about Cars.
>>> 
>> 
>> I didn't think GNUCash supported tags. I plan to use #tagone in a text
>> field. That's one of the things I need to do in Quicken. Search for each
>> transaction using a label, and put it in a text field. Problem: The text
>> fields are short. Maybe I'll create accounts/categories for each tag, and
>> add a $0.01 line. That will at least preserve the info. Then in GC edit
>> again to put the tags in a text field and undo the $0.01 split. (Not $0
>> because I think Quicken ignores $0 lines.)
>> 
>> I’ve not found one yet, though that may be in the documentation. Look into
>>> Double-Line mode to give you an extra note field. Once discovered, I now
>>> use it extensively.
>>> 
>> 
>> I like that GNUCash makes it easy to switch between journal, register, and
>> split views.
>> 
>> The #1 

Re: [GNC] Changing account tree on large database

[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 import
> over from scratch.
>

That's my first choice. I already checked for uncategorized transactions,
and will remove the few stock purchases. Any other risky types?

It seems like I started with the default GnuCash accounts, and worked from
> a printout of my Quicken accounts and categories, and created them in
> GnuCash beforehand. That made the transfer happen much faster because I
> wasn't creating new accounts as I went along.
>

I remember letting GnuCash get the accounts from the QIF worked 2 years
ago. It was other things that didn't work. That method might affect its
ability to catch transfers. (Another reason I prefer double-entry
accounting. One transaction with many accounts, rather than two
transactions.)


> You might also try exporting just however many years of data from a single
> bank account at a time until you have them all. Unless I'm mis-remembering,
> I think the only places you'll have duplicate transactions will be those
> places where you transferred money BETWEEN the bank accounts.
>

There are a lot of transfers, about 10 a month, with credit cards, mortgage
and car loan, and cash withdrawals.

I think I'm ready for the next set of tests, hopefully in a few days.

Good luck!
>

Thanks! If the program is as good as the community, I'll be very happy.

+++

Not as a ladder from earth to Heaven, not as a witness to any creed,
But simple service simply given to his own kind in their common need.
-- Rudyard Kipling
___
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] Changing account tree on large database

[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.
>>
>
> The "standard" XML files are quick enough for me, though as time goes on
> it does take longer to load. I have never tried the database formats; the
> only upside (at the moment) is they give you some additional nerdy
> reporting options.
>

Don't tempt me. I've spent enough hours learning "just enough" of
half-a-dozen languages for various projects that never quite did what I
wanted.


> QIF files are just text files, right, and human-readable? So I can use a
>> text editor and search.
>>
>
> Yes, "human-readable," though not exactly comfortably readable. Export a
> small file and have a look. You MAY find that not every text editor can
> open the largest (multi-megabyte) files, though nowadays I suspect that's
> less a problem than it was back in the 20th century. ;-)
>

After Pascal variable typing, a few XML files, and FORTRAN formatting
statements (both input and output), how hard can QIF be? (Rhetorical
question.) Still, my first choice is do everything with a single program,
even if I start a new data file every few years.


> How easy is it to delete old transactions? (Or export recent ones to a new
>> file?) That way I could migrate 10 years worth, so they're all in GC format
>> rather than QIF, then use a smaller file going forward.
>>
>
> Unless it's been added in the last couple of releases, GnuCash itself
> doesn't have that facility. At best you can easily "prune" entire accounts,
> OR start from scratch. At this moment in your GnuCash history your best bet
> is to export date ranges from Quicken.
>
>>
That surprises me. It can't be uncommon for a file to get unwieldy. Pruning
an entire account would make a lot of ripples. Is there a feature request I
can vote on?

-- 
+++

Not as a ladder from earth to Heaven, not as a witness to any creed,
But simple service simply given to his own kind in their common need.
-- Rudyard Kipling
___
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] Changing account tree on large database

[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 to be the only way to accurately get "both sides" of
every transaction. The ability to get every part of a transaction in a CSV
is a new feature with the 3.x series. I haven't tried it.

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 import over
from scratch.


> I might make one huge QIF, import it and save as GC, then make another QIF
> just of recent transactions for actual use.


That's my recommendation.


> That's a lot of work, though. I
> asked a few days about chunking it by date. They suggested doing each
> account separately. If I understand correctly, transfers between accounts
> might show up as two transactions otherwise. I guess Quicken exports the
> transaction twice, once in each direction. GC's matcher only checks against
> transactions it's already saved.
>

I might be wrong, but I believe the advantage of the QIF import is that
Quicken and GnuCash are pretty good about conveying the matching parts of
the transaction. I don't remember it being a problem at all, once you got
over the process of creating all the accounts (on the GnuCash side).

It seems like I started with the default GnuCash accounts, and worked from
a printout of my Quicken accounts and categories, and created them in
GnuCash beforehand. That made the transfer happen much faster because I
wasn't creating new accounts as I went along.

You might also try exporting just however many years of data from a single
bank account at a time until you have them all. Unless I'm mis-remembering,
I think the only places you'll have duplicate transactions will be those
places where you transferred money BETWEEN the bank accounts.

Good luck!


> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
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] Changing account tree on large database

[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 time goes on it
does take longer to load. I have never tried the database formats; the only
upside (at the moment) is they give you some additional nerdy reporting
options.


> QIF files are just text files, right, and human-readable? So I can use a
> text editor and search.
>

Yes, "human-readable," though not exactly comfortably readable. Export a
small file and have a look. You MAY find that not every text editor can
open the largest (multi-megabyte) files, though nowadays I suspect that's
less a problem than it was back in the 20th century. ;-)


> How easy is it to delete old transactions? (Or export recent ones to a new
> file?) That way I could migrate 10 years worth, so they're all in GC format
> rather than QIF, then use a smaller file going forward.
>

Unless it's been added in the last couple of releases, GnuCash itself
doesn't have that facility. At best you can easily "prune" entire accounts,
OR start from scratch. At this moment in your GnuCash history your best bet
is to export date ranges from Quicken.


>
___
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] Changing account tree on large database

[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 recent transactions for actual use. That's a lot of work, though. I
asked a few days about chunking it by date. They suggested doing each
account separately. If I understand correctly, transfers between accounts
might show up as two transactions otherwise. I guess Quicken exports the
transaction twice, once in each direction. GC's matcher only checks against
transactions it's already saved.

It might be easier to just let "archive" migration file be huge, even if it
takes a few attempts to fix all the problems, then do another, smaller,
"active" migration.

Cricket / Sandy

On Fri, 26 Apr 2019 at 20:39, nvsoar  wrote:

> On 04/26/19 16:18, Tommy Trussell wrote:
> > On Fri, Apr 26, 2019 at 4:53 PM David Carlson <
> david.carlson@gmail.com>
> > 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 closed bank accounts etc.
> >
> > Since I had been using Quicken since the 1990s I had a number of
> > "historical" transactions I MIGHT conceivably want to look up, so I
> > exported those and kept the (enormous) QIF files. Any time I want to
> find a
> > transaction I can just do a few searches through the QIF file and find
> the
> > transaction date and the amount. If I really really want to, I COULD
> create
> > a "historical" GnuCash book with the imported data and just ignore the
> odd
> > balances etc.
> >
> > (I'm looking through my data and found that I kept a complete QIF I
> > exported in 2000, and then another one I exported in 2007. I believe 2007
> > is when I gave up on Quicken for good, so my original GnuCash-only data
> was
> > based upon 2006 and 2007 transactions only.)
> >
> snip
>
> FWIW - if Quicken will export to a .csv file then I think I would
> download the entire Quicken file, and then import to GnuCash only those
> files that I need to refer to, and leave the rest as an archive in the
> .csv file.
> nvsoar
>
> ___
> 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.
>


-- 
+++

Not as a ladder from earth to Heaven, not as a witness to any creed,
But simple service simply given to his own kind in their common need.
-- Rudyard Kipling
___
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] Changing account tree on large database

[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 say otherwise. Out of date
manual, or optimistic / lucky users?)

QIF files are just text files, right, and human-readable? So I can use a
text editor and search.

How easy is it to delete old transactions? (Or export recent ones to a new
file?) That way I could migrate 10 years worth, so they're all in GC format
rather than QIF, then use a smaller file going forward. [Searching "site:
gnucash.org file size" gives many hits, but none answering my question. .
https://www.gnucash.org/docs/v3/C/gnucash-help/tool-close-book.html  says
closing doesn't delete old transactions. "site:gnucash.org delete old
transactions " doesn't have anything useful, at least not on the first few
pages.

You're right, I planned to make everything look right, which isn't
necessary, and would take a lot of time (and explains putting it off for 2
years).

   - Anything older than 5 years is useless for budgeting. The kids are now
   teenagers. No more playschool. Much more food and clubs and trips. Soon to
   be tuition and rent.
   - The lifetime cost of all but the current cars is already inaccurate.
   Two years ago I tried to delete all transactions older than 10 years. Some
   are gone, but not all. The final balances stayed the same (or was easy to
   fix), so I kept going. Also, why does it matter? I have the backup QDF from
   that time, maybe even a QIF from an attempt to migrate.
   - We keep original paper receipts anything that affects future tax, and
   for big items with long warranties.
   - I stopped tracking stocks and such in Quicken in that

I do need to calculate how much the kids owe us for things they said they'd
pay us back for. The cheques we wrote are in Quicken, but I didn't split
the transactions into "we pay / kid owes" at the time. That mess goes back
to 2010. I handled each big expense differently. I'll use a spreadsheet for
the final report rather than trying to get one from Quicken.

2015 reduces it to 7400 transactions and avoids all but a few stock
purchases. I'll think about it and see what if my husband has a preference.

Thanks! You may have saved me from myself!

Cricket / Sandy


On Fri, 26 Apr 2019 at 19: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 seemed
> pointless for things like long-ago closed bank accounts etc.
>
> Since I had been using Quicken since the 1990s I had a number of
> "historical" transactions I MIGHT conceivably want to look up, so I
> exported those and kept the (enormous) QIF files. Any time I want to find a
> transaction I can just do a few searches through the QIF file and find the
> transaction date and the amount. If I really really want to, I COULD create
> a "historical" GnuCash book with the imported data and just ignore the odd
> balances etc.
>
> (I'm looking through my data and found that I kept a complete QIF I
> exported in 2000, and then another one I exported in 2007. I believe 2007
> is when I gave up on Quicken for good, so my original GnuCash-only data was
> based upon 2006 and 2007 transactions only.)
>
>
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>

-- 
+++

Not as a ladder from earth to Heaven, not as a witness to any creed,
But simple service simply given to his own kind in their common need.
-- Rudyard Kipling
___
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] Need help reconciling

[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 rest of your sentence got cut off.. Anyway, I dod not
> follow.  :'(
>
>
My apologies ... I got called away from the office for a few hours and I
hit SEND thinking I had finished the thought. If the manual doesn't give
you what you need please ask more.


> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
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] Need help reconciling

[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!

___
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] Need help reconciling

[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 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-f1415819.html
> ___
> 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.
>


-- 
+++

Not as a ladder from earth to Heaven, not as a witness to any creed,
But simple service simply given to his own kind in their common need.
-- Rudyard Kipling
___
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] Changing account tree on large database

[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 seemed
pointless for things like long-ago closed bank accounts etc.

Since I had been using Quicken since the 1990s I had a number of
"historical" transactions I MIGHT conceivably want to look up, so I
exported those and kept the (enormous) QIF files. Any time I want to find a
transaction I can just do a few searches through the QIF file and find the
transaction date and the amount. If I really really want to, I COULD create
a "historical" GnuCash book with the imported data and just ignore the odd
balances etc.

(I'm looking through my data and found that I kept a complete QIF I
exported in 2000, and then another one I exported in 2007. I believe 2007
is when I gave up on Quicken for good, so my original GnuCash-only data was
based upon 2006 and 2007 transactions only.)


snip

FWIW - if Quicken will export to a .csv file then I think I would 
download the entire Quicken file, and then import to GnuCash only those 
files that I need to refer to, and leave the rest as an archive in the 
.csv file.

nvsoar

___
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] Need help reconciling

[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-f1415819.html
___
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] Need help reconciling

[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 as well as
the tutorial and concepts guide entries on that topic for example and often
the wiki pages which may have up to date info not yet in the documentation
for example.

David Cousens.


Tommy sent me to

https://www.gnucash.org/docs/v3/C/gnucash-guide/cc-together1.html

Why I could not find it on my own, I can only speculate ...

___
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] Need help reconciling

[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 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] Need help reconciling

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

> >
> > 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 with the n or c flags
> > in the ledger -- let GnuCash do that for you, through the
>
> I think the rest of your sentence got cut off.. Anyway, I dod not
> follow.  :'(
>
>
> ___
> 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.
>


-- 
David Carlson
___
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] Need help reconciling

[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 entries on that topic for example and often
the wiki pages which may have up to date info not yet in the documentation
for example.

David Cousens.



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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] QIF File import

[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 help you with that if you follow Tommy Trussell's
suggestions.


Good luck,

David Carlson

On Fri, Apr 26, 2019 at 5:50 PM Tommy Trussell 
wrote:

> 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 screens previous).
> >
> > I think this is a user interface issue. Have tried on my laptop as well
> as
> > desktop but with no success.
> >
>
> What version of GnuCash?
> What operating system?
>
> Have you checked the FAQ?
> https://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_import_my_data_from_...
>
> Have you seen the FAQ link to the Quicken Migration page?
> https://wiki.gnucash.org/wiki/Quicken_Migration
>
> I have not done a QIF import in many years, but if you're importing several
> years of data you might go back into Quicken and export just a single year
> or a single account category to get started. You can do several "test"
> imports and see ways to make the final import go a lot smoother. Since
> you're stumbling on "tradeable commodities," maybe at minimum it would help
> to export your trading accounts separately.
>
> If you continue to have trouble at a specific point, you may need to look
> carefully at the QIF file in a text editor to see if you can see an obvious
> error in the data.
>
> (Please don't forget to reply to the list, as suggested below.)
>
>
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
> ___
> 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.
>


-- 
David Carlson
___
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] Need help reconciling

[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 has checked it?
>

When you reconcile, you want to use the Reconcile window. Here's the
specific part of the manual that deals with Credit Card accounts -- have a
glance through here

https://www.gnucash.org/docs/v3/C/gnucash-guide/cc-together1.html


> 2) I have put "C" in all the charges on my bank statement.
>

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


> 3) I press the Reconcile button and I put in the closing data.
>
> It puts a weird entry into the the ledger that I don't understand
> and puts it on one of those weird  "you goofed" accounts.  And
> I get no "y"'s.
>
>
It sounds like you may have had GnuCash create a correcting entry INSTEAD
of finding the discrepancy in the data you've entered. When you have
everything verified against your statement, you shouldn't need to enter a
correcting entry, unless the problem preceded the month you are looking at.

Alternatively, are you looking at the same account? You would open the
Credit Card account (NOT the "General Ledger" because that gets confusing)
When you have the focus on the Credit Card account tab, choose Actions -->
Reconcile...


> I look at the doc and I have no clue what is going on.
>  https://gnucash.org/viewdoc.phtml?rev=3=C=help
>  https://gnucash.org/viewdoc.phtml?rev=3=C=guide
>
>
Even though you have spent some time on this, I recommend starting at least
at the beginning of the Credit Card chapter, and if it's still not
absolutely clear, go back to the beginning of the manual and make sure you
understand the examples. Maybe even create a couple of "Fake" accounts in
your data and enter the examples from the manual exactly as they are there.
If they're clearly labeled as fake you can easily delete them (and the
transactions in them) when you are through with them.

Good luck, and remember to respond to the list (as described below)


> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
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] Changing account tree on large database

[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 closed bank accounts etc.

Since I had been using Quicken since the 1990s I had a number of
"historical" transactions I MIGHT conceivably want to look up, so I
exported those and kept the (enormous) QIF files. Any time I want to find a
transaction I can just do a few searches through the QIF file and find the
transaction date and the amount. If I really really want to, I COULD create
a "historical" GnuCash book with the imported data and just ignore the odd
balances etc.

(I'm looking through my data and found that I kept a complete QIF I
exported in 2000, and then another one I exported in 2007. I believe 2007
is when I gave up on Quicken for good, so my original GnuCash-only data was
based upon 2006 and 2007 transactions only.)


> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
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] QIF File import

[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 screens previous).
>
> I think this is a user interface issue. Have tried on my laptop as well as
> desktop but with no success.
>

What version of GnuCash?
What operating system?

Have you checked the FAQ?
https://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_import_my_data_from_...

Have you seen the FAQ link to the Quicken Migration page?
https://wiki.gnucash.org/wiki/Quicken_Migration

I have not done a QIF import in many years, but if you're importing several
years of data you might go back into Quicken and export just a single year
or a single account category to get started. You can do several "test"
imports and see ways to make the final import go a lot smoother. Since
you're stumbling on "tradeable commodities," maybe at minimum it would help
to export your trading accounts separately.

If you continue to have trouble at a specific point, you may need to look
carefully at the QIF file in a text editor to see if you can see an obvious
error in the data.

(Please don't forget to reply to the list, as suggested below.)


> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
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] Need help reconciling

[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 the closing data.

It puts a weird entry into the the ledger that I don't understand
and puts it on one of those weird  "you goofed" accounts.  And
I get no "y"'s.

I look at the doc and I have no clue what is going on.
https://gnucash.org/viewdoc.phtml?rev=3=C=help
https://gnucash.org/viewdoc.phtml?rev=3=C=guide

:'(

-T

___
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] Changing account tree on large database

[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 register windows open, or if you
have a Hi-Res monitor, and having a powerful computer is not enough to
prevent that.

In my case it takes over a minute to open my file and about 10 seconds
every time I press the Enter key.  the periodic saves take so long that I
can squeeze in about 1/2 a game of Solitaire.

David Carlson

On Fri, Apr 26, 2019 at 4:31 PM Cricket Onebit 
wrote:

> 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 threads over the years, this will be a doozy.
> >
>
> Yes, it's a daunting task, but I do't want to lose 10+ years of data. I'm
> using an old version of Quicken, and don't trust the new version to be able
> to read it. The old version might not work on newer Windows. I need to move
> it.
>
> I’d try finding some of those threads or asking about a general ‘best
> > practices’ or ‘workflow’ to accomplish this with the least amount of
> > headache.
> >
>
> There doesn't seem to be an easy way to find those threads. I might not be
> searching right. "site:lists.gnucash.org quicken" has posts from many
> years
> ago on the first page, but not any from 2019. I know there are some from
> 2019.
>
> Two gnucash.org pages need to be updated. They have broken links.
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> https://lists.gnucash.org/search/?idxinfo=gnucash-user
>
> Yes, you can do this at will, over and over till you have your tree the way
> > you like it. (and then re-factor it again months later when you change
> your
> > mind)
> >
>
> Yay! for easy moving / promoting / demoting / etc child / parent / sibling
> / cousin accounts. Both your suggested methods make sense.
>
> One less reason to put off the migration.
>
> Also, for this particular example, I’d opt for tags for each kid instead of
> > accounts, see below about Cars.
> >
>
> I didn't think GNUCash supported tags. I plan to use #tagone in a text
> field. That's one of the things I need to do in Quicken. Search for each
> transaction using a label, and put it in a text field. Problem: The text
> fields are short. Maybe I'll create accounts/categories for each tag, and
> add a $0.01 line. That will at least preserve the info. Then in GC edit
> again to put the tags in a text field and undo the $0.01 split. (Not $0
> because I think Quicken ignores $0 lines.)
>
> I’ve not found one yet, though that may be in the documentation. Look into
> > Double-Line mode to give you an extra note field. Once discovered, I now
> > use it extensively.
> >
>
> I like that GNUCash makes it easy to switch between journal, register, and
> split views.
>
> The #1 piece of advice I could give to anyone who even thinks they might
> > want detail or multiple levels of categorization is to record as much
> info
> > as possible in each transaction. Record each split line from a receipt
> and
> > never combine items. Be descriptive for each split. That way, in the
> > future, should you decide to break something out into its own account,
> the
> > process will be much easier. But if you don’t have that info in the first
> > place...
> >
>
> I've annoyed many people with data. It runs in the family.
>
> "Nothing ruins an argument like a fact." -- RM Thomas, P.Eng. (aka Dad)
>
>
> > On the reporting end, if you really need to have parents with their own
> > transactions (instead of just as placeholders), set your options like
> this
> > on the P (Income Statement):
> >
> > Options > Display > Parent account balances > Account Balance
> > Options > Display > Parent account subtotals > Show Subtotals
>
> ...
>
> Parts` has one break-out sub-account with the remaining transactions in
> > itself. So that one shows its own balance, and the `Total Parts` line
> > combines it with its sub-account.
> >
>
> Yay! I wasn't looking forward to creating "misc" (grand) child accounts for
> every parent and moving the transactions. The GC report is similar to the
> Quicken report.
>
> Does it also do that for a Transaction, Group by (sub-)account report? I
> use that one a lot. There's probably something close enough.
>
> +++
>
> Enough stalling. Today's goal is to replace all the investment accounts
> with basic accounts. Apparently migrating investments isn't reliable. I
> won't lose any data because I haven't tracked investment details in Quicken
> in years. Also create appropriate income/loss accounts for the investment
> accounts so the year-end balances work. And, of course, lots of pre/post
> change reports 

Re: [GNC] Changing account tree on large database

[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 threads over the years, this will be a doozy.
>

Yes, it's a daunting task, but I do't want to lose 10+ years of data. I'm
using an old version of Quicken, and don't trust the new version to be able
to read it. The old version might not work on newer Windows. I need to move
it.

I’d try finding some of those threads or asking about a general ‘best
> practices’ or ‘workflow’ to accomplish this with the least amount of
> headache.
>

There doesn't seem to be an easy way to find those threads. I might not be
searching right. "site:lists.gnucash.org quicken" has posts from many years
ago on the first page, but not any from 2019. I know there are some from
2019.

Two gnucash.org pages need to be updated. They have broken links.
https://lists.gnucash.org/mailman/listinfo/gnucash-user
https://lists.gnucash.org/search/?idxinfo=gnucash-user

Yes, you can do this at will, over and over till you have your tree the way
> you like it. (and then re-factor it again months later when you change your
> mind)
>

Yay! for easy moving / promoting / demoting / etc child / parent / sibling
/ cousin accounts. Both your suggested methods make sense.

One less reason to put off the migration.

Also, for this particular example, I’d opt for tags for each kid instead of
> accounts, see below about Cars.
>

I didn't think GNUCash supported tags. I plan to use #tagone in a text
field. That's one of the things I need to do in Quicken. Search for each
transaction using a label, and put it in a text field. Problem: The text
fields are short. Maybe I'll create accounts/categories for each tag, and
add a $0.01 line. That will at least preserve the info. Then in GC edit
again to put the tags in a text field and undo the $0.01 split. (Not $0
because I think Quicken ignores $0 lines.)

I’ve not found one yet, though that may be in the documentation. Look into
> Double-Line mode to give you an extra note field. Once discovered, I now
> use it extensively.
>

I like that GNUCash makes it easy to switch between journal, register, and
split views.

The #1 piece of advice I could give to anyone who even thinks they might
> want detail or multiple levels of categorization is to record as much info
> as possible in each transaction. Record each split line from a receipt and
> never combine items. Be descriptive for each split. That way, in the
> future, should you decide to break something out into its own account, the
> process will be much easier. But if you don’t have that info in the first
> place...
>

I've annoyed many people with data. It runs in the family.

"Nothing ruins an argument like a fact." -- RM Thomas, P.Eng. (aka Dad)


> On the reporting end, if you really need to have parents with their own
> transactions (instead of just as placeholders), set your options like this
> on the P (Income Statement):
>
> Options > Display > Parent account balances > Account Balance
> Options > Display > Parent account subtotals > Show Subtotals

...

Parts` has one break-out sub-account with the remaining transactions in
> itself. So that one shows its own balance, and the `Total Parts` line
> combines it with its sub-account.
>

Yay! I wasn't looking forward to creating "misc" (grand) child accounts for
every parent and moving the transactions. The GC report is similar to the
Quicken report.

Does it also do that for a Transaction, Group by (sub-)account report? I
use that one a lot. There's probably something close enough.

+++

Enough stalling. Today's goal is to replace all the investment accounts
with basic accounts. Apparently migrating investments isn't reliable. I
won't lose any data because I haven't tracked investment details in Quicken
in years. Also create appropriate income/loss accounts for the investment
accounts so the year-end balances work. And, of course, lots of pre/post
change reports to catch problems.

Wish me luck!
___
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] Changing account tree on large database

[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
reports accordingly. That's safer than assuming all will go well. (Lots and
lots of before/after reports, sigh.)







On Thu, 25 Apr 2019 at 19:39, David Cousens 
wrote:

> The following bit of the Wiki may be some help:
> https://wiki.gnucash.org/wiki/Quicken_Migration
>
> The documentation on the importer is in need of some improvement and that
> is
> underway but not useful yet. There are some additions in the just released
> 3.5 documentation, mainly to do with the CSV importer but there were some
> mods to the matcher info as well.
>
> David Cousens
>
>
>
> -
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> 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.
>


-- 
+++

Not as a ladder from earth to Heaven, not as a witness to any creed,
But simple service simply given to his own kind in their common need.
-- Rudyard Kipling
___
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] Curl expertise -- off list

[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...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
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] Finance::Quotes stopped working for me

[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 continue to
improve it, which they have been successfully doing for several years with
very limited resources.

I have not worked 'under the hood' very much with GnuCash due to my limited
expertise.  I don't know about curl or how it might be useful.

Coercing for me consisted mainly in getting Perl installed and working to
use F::Q with GnuCash in Windows 7 and in Ubuntu 16.04 and later Ubuntu
18.04.  For some reason I have not gotten it to work in both direct and
remote environments, but I quit trying when I had one method working as
other projects demanded my attention.  I only download prices once every
month.

Good luck with solving your networking problems.

David Carlson

On Fri, Apr 26, 2019 at 11:36 AM Bruno Acklin  wrote:

> 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 Uverse as my ISP and i know they do have some strange
> settings in their router, but the basic firewall and TCP port settings out
> of the box are fine for most users without tinkering with pinholes or other
> firewall settings.  In my neighborhood they now set IPV6 as preferred
> addressing protocol.  I have several Windows and Linux real or virtual
> computers including a few with GnuCash 2.6.17 or 19, but I have only
> managed to coerce one of them to download price quotes, and then only when
> running in a local desktop but not in a remote terminal.
>
> I do not know enough about networking to be able to say whether you have a
> problem with your router or firewall.
>
> David Carlson
>
>
> On Mon, Apr 22, 2019, 3:16 PM Bruno Acklin  wrote:
>
>> Wow, thanks all for your thoughts, although unfortunately this remains an
>> unsolved mystery to me!
>>
>> Tools/"Price Editor"/"Get Quotes" still works smoothly when I disconnect
>> the ethernet cable to my router (standard ATT Uverse DSL router and
>> configuration with DNS 68.94.156.1 and ..157.1) and use wifi to my
>> neighbors router (cable based), and vice versa not if I reconnect my
>> ethernet.
>>
>> [@David] So definitely different ISP, DNS, etc for the two paths.
>>
>> [@AC] I did not see any proxy information on my routers broadband status.
>> <"LWP apparently will also self report a 500 status if the connection
>> fails for any reason"> I also “interpreted" the 500 error as a sort of
>> timeout error, because the response comes only after a second or two while
>> it is instantaneous with curl or browser.
>>
>> [@Ronal, ..] I checked for open TCP ports using loopback address
>> 127.0.0.1 (Is this the right way?). Received identical responses for both
>> paths, including Port 88 (but not 80!).
>>
>> In looking at my firewall settings I noticed that “the computer that will
>> host applications through the firewall” is still set to my old Time Machine
>> router (which I assume still runs its own firewall which used to work fine
>> for gnc-fc before). Should that be set to my desktop?
>>
>> I am assuming that a server response to an http: call is governed by
>> “outgoing protocol control” rules, and does not need any inbound protocol
>> control enabled, correct?
>>
>> Thanks and best,
>> Bruno
>>
>> > On Apr 13, 2019, at 12:41 PM, Adrien Monteleone <
>> adrien.montele...@lusfiber.net> wrote:
>> >
>> > It doesn’t make any sense to me either. But curl works, perl doesn’t.
>> What does that perl script actually do when it tries to pull that URL?
>> >
>> > Regards,
>> > Adrien
>> >
>> >> On Apr 13, 2019, at 9:17 AM, John Ralls  wrote:
>> >>
>> >> The URL is given several times in the thread, it's http, port 80. That
>> aside, get real: A firewall that blocks a port when perl's LWP is the agent
>> but not when curl or a web browser is?
>> >>
>> >> Besides, the request isn't blocked, it's munged so that Yahoo! returns
>> a 500--server error response. So we have to imagine that the router can
>> somehow tell that the packets are coming from curl and not messing with
>> them or perl LWP and messing with them? That's a pretty amazing firewall.
>> >>
>> >> Regards,
>> >> John Ralls
>> >>
>> >>> On Apr 13, 2019, at 2:32 AM, Adrien Monteleone <
>> adrien.montele...@lusfiber.net> wrote:
>> >>>
>> >>> More likely a blocked port though since the OP said curl works to
>> retrieve the same URL, but not perl. A look at the perl script will
>> probably expose the issue.
>> >>>
>> >>> Regards,
>> >>> Adrien
>> >>>
>>  On Apr 13, 2019, at 4:29 AM, David Carlson <
>> david.carlson@gmail.com> wrote:
>> 
>>  A different router could also mean a different ISP, a different DNS,
>> and
>>  that is 

Re: [GNC] OFX Import add Memo to transaction

[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 'your orders' section. Which doesn't 
have a total of all items and shipping.


eBay doesn't have a purchase export, and their 'MyEbay->Purchase 
history' has an order total, but it doesn't reflect shipping charges! It 
makes it difficult to simply ^F search on a bank transaction amount to 
find the matching seller transaction.


PayPal has a transaction export. In fact you can export .QIF from 
PayPal. Dare I try an import from my primary PayPal bank and Paypal. 
This report does have Transaction total including the shipping.


I'll have to experiment with that in the GNUCash 'Generic import 
transaction matcher' after I accrue some new transactions.


With these reports quit a bit of frustration and time sink will be 
removed from my GNUCash import work flow!



Some icing on this workflow would be a simple filter input box at the 
top of the COA account selector in the 'Generic import transaction 
matcher' such that I can filter all those accounts to those that contain 
a string say gas, fuel, netflix, dining, clothing etc... It sure would 
make the matching account selection a lot easier, faster and error prone.


On the GNUCash user voice this sounds a bit similar to my 'icing' 
https://gnucash.uservoice.com/forums/101223-feature-request/suggestions/1589607-type-ahead-search-when-entering-the-accounts-to-a 
but rather than a type ahead match a straight filter on search of any 
COA account that matches any part of the account name on that filter 
string.


If others think this 'icing' suggestion worthy I'll add it to the user 
voice. I did spend some time searching to see if this request was 
already there. Looks like there are 351 feature requests.


 - Jeff


On 4/26/2019 8:07 AM, David Carlson wrote:

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 
between those downloads and watching for fraudulent transactions.


Perhaps the developers could refine the import process to allow 
performing the first and second parts simultaneously.


That is my suggestion.

David Carlson


On Fri, Apr 26, 2019 at 9:22 AM Jeff Albrecht > wrote:


On 4/26/2019 3:22 AM, Liz wrote:
> On Wed, 24 Apr 2019 13:24:29 -0700
> Jeff Albrecht mailto:je...@rodaw.com>> 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 accounts open in browser tabs to lookup
>> transactions to be sure I categorize them to my liking. There is
>> information important to me that I want to add as a memo in each of
>> the transactions. Sometimes I try to modify the transaction after I
>> enter / classify it into the correct 'category' entering a memo
>> however I generally get message something to the effect of
>> 'transaction is open in another window, please close or finish that
>> edit' I'm assuming the message is referring to the 'Generic import
>> transaction matcher' window, other times I get a message about the
>> transaction being out of balance after I've added a memo - usually
>> the former about the record being open in another window.
>>
>> Is there a way to add a memo during the import process?
>>
>> If not It's a feature I'd very much like to see. I imagine that
once
>> I select the account for the match it could open up in a
'transaction
>> journal' view allowing me to enter a memo and clicking a O.K.
accept
>> button. The 'transaction journal' view could be displayed in the
>> 'Generic import transaction matcher' for items that have been
>> matched. A check box could enable (or disable) this behavior in the
>> 'Generic import transaction matcher' screen. And / or as a
>> preferences selection.
>>
>>    - Jeff
>>
>>
> To help us understand, we need some more information about your work
> flow.
> Do you enter transactions into Gnucash one by one, and then run the
> import looking for ones you have missed (or could be fraudulent)
OR do
> you use the OFX file to populate your Gnucash ledger?
>
> If you do enter one by one you can of course put the memo in at that
> 

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

[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 Uverse as my ISP and i know they do have some strange 
> settings in their router, but the basic firewall and TCP port settings out of 
> the box are fine for most users without tinkering with pinholes or other 
> firewall settings.  In my neighborhood they now set IPV6 as preferred 
> addressing protocol.  I have several Windows and Linux real or virtual 
> computers including a few with GnuCash 2.6.17 or 19, but I have only managed 
> to coerce one of them to download price quotes, and then only when running in 
> a local desktop but not in a remote terminal.
> 
> I do not know enough about networking to be able to say whether you have a 
> problem with your router or firewall.
> 
> David Carlson 
> 
> 
> On Mon, Apr 22, 2019, 3:16 PM Bruno Acklin  > wrote:
> Wow, thanks all for your thoughts, although unfortunately this remains an 
> unsolved mystery to me!
> 
> Tools/"Price Editor"/"Get Quotes" still works smoothly when I disconnect the 
> ethernet cable to my router (standard ATT Uverse DSL router and configuration 
> with DNS 68.94.156.1 and ..157.1) and use wifi to my neighbors router (cable 
> based), and vice versa not if I reconnect my ethernet.
> 
> [@David] So definitely different ISP, DNS, etc for the two paths.
> 
> [@AC] I did not see any proxy information on my routers broadband status.
> <"LWP apparently will also self report a 500 status if the connection fails 
> for any reason"> I also “interpreted" the 500 error as a sort of timeout 
> error, because the response comes only after a second or two while it is 
> instantaneous with curl or browser.
> 
> [@Ronal, ..] I checked for open TCP ports using loopback address 127.0.0.1 
> (Is this the right way?). Received identical responses for both paths, 
> including Port 88 (but not 80!).
> 
> In looking at my firewall settings I noticed that “the computer that will 
> host applications through the firewall” is still set to my old Time Machine 
> router (which I assume still runs its own firewall which used to work fine 
> for gnc-fc before). Should that be set to my desktop?
> 
> I am assuming that a server response to an http: call is governed by 
> “outgoing protocol control” rules, and does not need any inbound protocol 
> control enabled, correct? 
> 
> Thanks and best,
> Bruno
> 
> > On Apr 13, 2019, at 12:41 PM, Adrien Monteleone 
> > mailto:adrien.montele...@lusfiber.net>> 
> > wrote:
> > 
> > It doesn’t make any sense to me either. But curl works, perl doesn’t. What 
> > does that perl script actually do when it tries to pull that URL?
> > 
> > Regards,
> > Adrien
> > 
> >> On Apr 13, 2019, at 9:17 AM, John Ralls  >> > wrote:
> >> 
> >> The URL is given several times in the thread, it's http, port 80. That 
> >> aside, get real: A firewall that blocks a port when perl's LWP is the 
> >> agent but not when curl or a web browser is?
> >> 
> >> Besides, the request isn't blocked, it's munged so that Yahoo! returns a 
> >> 500--server error response. So we have to imagine that the router can 
> >> somehow tell that the packets are coming from curl and not messing with 
> >> them or perl LWP and messing with them? That's a pretty amazing firewall.
> >> 
> >> Regards,
> >> John Ralls
> >> 
> >>> On Apr 13, 2019, at 2:32 AM, Adrien Monteleone 
> >>> mailto:adrien.montele...@lusfiber.net>> 
> >>> wrote:
> >>> 
> >>> More likely a blocked port though since the OP said curl works to 
> >>> retrieve the same URL, but not perl. A look at the perl script will 
> >>> probably expose the issue.
> >>> 
> >>> Regards,
> >>> Adrien
> >>> 
>  On Apr 13, 2019, at 4:29 AM, David Carlson   > wrote:
>  
>  A different router could also mean a different ISP, a different DNS, and
>  that is just the starting point...
>  
>  David Carlson
>  
> > 
> > ___
> > 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.
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org 
> To update your subscription preferences or to unsubscribe:
> 

Re: [GNC] OFX Import add Memo to transaction

[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 between
those downloads and watching for fraudulent transactions.

Perhaps the developers could refine the import process to allow performing
the first and second parts simultaneously.

That is my suggestion.

David Carlson


On Fri, Apr 26, 2019 at 9:22 AM Jeff Albrecht  wrote:

> 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 my Ebay and PayPal accounts open in browser tabs to lookup
> >> transactions to be sure I categorize them to my liking. There is
> >> information important to me that I want to add as a memo in each of
> >> the transactions. Sometimes I try to modify the transaction after I
> >> enter / classify it into the correct 'category' entering a memo
> >> however I generally get message something to the effect of
> >> 'transaction is open in another window, please close or finish that
> >> edit' I'm assuming the message is referring to the 'Generic import
> >> transaction matcher' window, other times I get a message about the
> >> transaction being out of balance after I've added a memo - usually
> >> the former about the record being open in another window.
> >>
> >> Is there a way to add a memo during the import process?
> >>
> >> If not It's a feature I'd very much like to see. I imagine that once
> >> I select the account for the match it could open up in a 'transaction
> >> journal' view allowing me to enter a memo and clicking a O.K. accept
> >> button. The 'transaction journal' view could be displayed in the
> >> 'Generic import transaction matcher' for items that have been
> >> matched. A check box could enable (or disable) this behavior in the
> >> 'Generic import transaction matcher' screen. And / or as a
> >> preferences selection.
> >>
> >>- Jeff
> >>
> >>
> > To help us understand, we need some more information about your work
> > flow.
> > Do you enter transactions into Gnucash one by one, and then run the
> > import looking for ones you have missed (or could be fraudulent) OR do
> > you use the OFX file to populate your Gnucash ledger?
> >
> > If you do enter one by one you can of course put the memo in at that
> > stage. The importer will find the transaction as a possible match, and
> > you will tell it NOT to amend the matched transaction.
> >
> > Liz
>
> I use the OFX file to populate the Gnucash ledger. As I import and
> categorize I check transactions against vendor (seller) online records.
> Other than recurring transactions I generally want to add a memo to most
> other transactions.
>
> I generally am working through a number of transactions. As I lookup
> each item in the sellers site to verify the transaction and decide
> classification there is no opportunity for me to add the memo. I have to
> go through seller site transactions again after moving each item from
> the 'Generic import transaction matcher' to add the memo. Time consuming.
>
> What I've started to do is move the un-categorized transactions that I
> want a memo for into a register "UnAccounted For" There I can categorize
> and add memos at the same time working my way through verifying against
> online seller transactions until there are no more remaining. mostly
> Ebay, PayPal and Amazon.
>
> I read about "6.15.5.2. Assign a Destination Account to Multiple
> Transaction" and once David gets that functionality restored to 3.5.x,
> see thread; "6.15.5.2. Assign a Destination Account to Multiple
> Transaction" that will be handy in the 'Generic import transaction
> matcher' window to deal with some of the transactions that have a common
> destination and don't need a memo. Then I can use the multiple
> transaction selector to move all reaming un-categorized transactions to
> my "UnAccounted For" account to classify and add memos. It's a bit
> tedious right now as I have to move one transaction at a time however it
> saves me the time sink of looking up each item twice. I can enter the
> memo and the destination category / account at the same time while
> verifying that transaction on seller sites. If I don't recall the
> transaction and can't find it on a seller's site then It's suspicious of
> being bogus.
>
>   - Jeff
>
>
> ___
> 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
> 

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

[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 select the archive file for
the appropriate year.

This would free up lots of memory and make it less cumbersome to find
the beginning of the current year and not have to scroll down through
prior years data to find the beginning of the current year.

I hope this makes sense to you. If I understood the programming
language, I'd do it myself and submit the update to the appropriate
location so everyone could take advantage of the update.

Thank you for your understanding of the problem.

This is not a "programming" issue. It is a "work flow" issue.

a) This is what used to happen back in the old days of pen and ink on 
paper bookkeeping in bound volumes ruled for accounting. At the end of 
each accounting period the books were closed (a process) and a new set 
of physical books begun using the closing Balance Sheet.


b) Nothing prevents you from mirroring this process using existing 
gnucash. You do a close the books. You run the post closing Balance 
Sheet. You export the CoA and import into a new file (empty set of 
books). You use the Balance Sheet to create the opening entries << one 
giant split both sides transaction or easier/safer, two transactions 
each split on just one side >>


Michael D Novack
___
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 Import add Memo to transaction

[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 my Ebay and PayPal accounts open in browser tabs to lookup
transactions to be sure I categorize them to my liking. There is
information important to me that I want to add as a memo in each of
the transactions. Sometimes I try to modify the transaction after I
enter / classify it into the correct 'category' entering a memo
however I generally get message something to the effect of
'transaction is open in another window, please close or finish that
edit' I'm assuming the message is referring to the 'Generic import
transaction matcher' window, other times I get a message about the
transaction being out of balance after I've added a memo - usually
the former about the record being open in another window.

Is there a way to add a memo during the import process?

If not It's a feature I'd very much like to see. I imagine that once
I select the account for the match it could open up in a 'transaction
journal' view allowing me to enter a memo and clicking a O.K. accept
button. The 'transaction journal' view could be displayed in the
'Generic import transaction matcher' for items that have been
matched. A check box could enable (or disable) this behavior in the
'Generic import transaction matcher' screen. And / or as a
preferences selection.

   - Jeff



To help us understand, we need some more information about your work
flow.
Do you enter transactions into Gnucash one by one, and then run the
import looking for ones you have missed (or could be fraudulent) OR do
you use the OFX file to populate your Gnucash ledger?

If you do enter one by one you can of course put the memo in at that
stage. The importer will find the transaction as a possible match, and
you will tell it NOT to amend the matched transaction.

Liz


I use the OFX file to populate the Gnucash ledger. As I import and 
categorize I check transactions against vendor (seller) online records. 
Other than recurring transactions I generally want to add a memo to most 
other transactions.


I generally am working through a number of transactions. As I lookup 
each item in the sellers site to verify the transaction and decide 
classification there is no opportunity for me to add the memo. I have to 
go through seller site transactions again after moving each item from 
the 'Generic import transaction matcher' to add the memo. Time consuming.


What I've started to do is move the un-categorized transactions that I 
want a memo for into a register "UnAccounted For" There I can categorize 
and add memos at the same time working my way through verifying against 
online seller transactions until there are no more remaining. mostly 
Ebay, PayPal and Amazon.


I read about "6.15.5.2. Assign a Destination Account to Multiple 
Transaction" and once David gets that functionality restored to 3.5.x, 
see thread; "6.15.5.2. Assign a Destination Account to Multiple 
Transaction" that will be handy in the 'Generic import transaction 
matcher' window to deal with some of the transactions that have a common 
destination and don't need a memo. Then I can use the multiple 
transaction selector to move all reaming un-categorized transactions to 
my "UnAccounted For" account to classify and add memos. It's a bit 
tedious right now as I have to move one transaction at a time however it 
saves me the time sink of looking up each item twice. I can enter the 
memo and the destination category / account at the same time while 
verifying that transaction on seller sites. If I don't recall the 
transaction and can't find it on a seller's site then It's suspicious of 
being bogus.


 - Jeff


___
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] VAT Reporting

[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 glue to some GC reports.  I need to look at more depth at the actual 
numbers produced by the GST report first, because I don't think it is quite 
covering all the bases yet but I need to complete the next return first!

Maf,.


On Friday, 26 April 2019 11:35:07 BST Laurel Brunner wrote:
> 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 2019, at 18:02, Maf. King  wrote:
> > 
> > Hi Laurel,
> > 
> > not got time at the moment to answer you properly, but I do VAT reports
> > with few runs of the transaction report.
> > 
> > Christopher Lam has supplied a GST report that I'm looking at for the
> > impending Make Tax Difficult transition.   I am confident there will be a
> > solution that will be working by the time July rolls around - even if it
> > is a bit of a fudge needing polish!
> > 
> > will be able to answer questions in more detail either after 10 tonight or
> > in the morning.
> > 
> > Maf.
> > 
> > On Thursday, 25 April 2019 16:41:33 BST Laurel Brunner wrote:
> >> Dear Helpful people,
> >> 
> >> How do I produce quarterly VAT reports from Gnucash?
> >> 
> >> I did it once before for the previous quarter and crosschecked it with a
> >> manual accounting of the VAT. And it worked, but I cannot remember how I
> >> did this, and cannot find any help online.
> >> 
> >> Also, have you done anything to support the UK government’s mandate that
> >> VAT returns are filed automatically: Making Tax Digital?
> >> 
> >> Many thanks.
> >> 
> >> -Laurel.
> 
> -Laurel.
> 
> Laurel Brunner
> Digital Dots Limited
> The Clock Tower
> Southover
> Spring Lane
> Burwash
> East Sussex
> TN19 7JB
> UK
> 
> +44 (0)1435 883565
> +44 (0)7721 424449
> 
> Please check out our subscriber supported journal at
> http://www.spindrift.click and our environmental blogs at
> http://www.verdigrisproject.com


-- 
Maf. King
PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7  2B7C E591 E8E1 0DE7 C542





___
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] VAT Reporting

[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 2019, at 18:02, Maf. King  wrote:
> 
> Hi Laurel,
> 
> not got time at the moment to answer you properly, but I do VAT reports with 
> few runs of the transaction report.
> 
> Christopher Lam has supplied a GST report that I'm looking at for the 
> impending Make Tax Difficult transition.   I am confident there will be a 
> solution that will be working by the time July rolls around - even if it is a 
> bit of a fudge needing polish!
> 
> will be able to answer questions in more detail either after 10 tonight or in 
> the morning.
> 
> Maf.
> 
> 
> On Thursday, 25 April 2019 16:41:33 BST Laurel Brunner wrote:
>> Dear Helpful people,
>> 
>> How do I produce quarterly VAT reports from Gnucash?
>> 
>> I did it once before for the previous quarter and crosschecked it with a
>> manual accounting of the VAT. And it worked, but I cannot remember how I
>> did this, and cannot find any help online.
>> 
>> Also, have you done anything to support the UK government’s mandate that VAT
>> returns are filed automatically: Making Tax Digital?
>> 
>> Many thanks.
>> 
>> -Laurel.
>> 
> 
> 
> 
> 
> 
> 

-Laurel.

Laurel Brunner
Digital Dots Limited
The Clock Tower
Southover
Spring Lane
Burwash
East Sussex
TN19 7JB
UK

+44 (0)1435 883565
+44 (0)7721 424449

Please check out our subscriber supported journal at http://www.spindrift.click 
and our environmental blogs at http://www.verdigrisproject.com


___
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] VAT Reporting

[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 are 
> set up as liability/asset accounts. Use the "Income & GST Statement" report 
> present in version 3.0 and above, select income & expense accounts and your 
> VAT accounts.
> 
> You'll probably wish to select 'start of last quarter' to 'end of last 
> quarter' in the date filter. Each transaction found is analysed; the 
> sales, and the VAT parts are pulled out, and reported and summed - 
> either into each account, or per amount type 
> (sales/purchase/vat-sales/vat-purchases). To that matter, if you have EC 
> sales you'll need separate EC VAT liability accounts which can be reported 
> separately.
> 
> MTD is another issue altogether and there is no inbuilt solution. Unless 
> someone creates a built-in MTD bridge, your best bet for now is to find a 
> suitable HMRC VAT bridging software, and plug the amounts obtained above.
> 
> Good luck, ask any questions!
> 
> On Thu, 25 Apr 2019 at 15:44, Laurel Brunner  > wrote:
> Dear Helpful people,
> 
> How do I produce quarterly VAT reports from Gnucash?
> 
> I did it once before for the previous quarter and crosschecked it with a 
> manual accounting of the VAT. And it worked, but I cannot remember how I did 
> this, and cannot find any help online.
> 
> Also, have you done anything to support the UK government’s mandate that VAT 
> returns are filed automatically: Making Tax Digital?
> 
> Many thanks.
> 
> -Laurel.
> 
> Laurel Brunner
> Digital Dots Limited
> The Clock Tower
> Southover
> Spring Lane
> Burwash
> East Sussex
> TN19 7JB
> UK
> 
> +44 (0)1435 883565
> +44 (0)7721 424449
> 
> Please check out our subscriber supported journal at 
> http://www.spindrift.click  
> > and our 
> environmental blogs at http://www.verdigrisproject.com 
>   >
> 
> 
> ___
> 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.

-Laurel.

Laurel Brunner
Digital Dots Limited
The Clock Tower
Southover
Spring Lane
Burwash
East Sussex
TN19 7JB
UK

+44 (0)1435 883565
+44 (0)7721 424449

Please check out our subscriber supported journal at http://www.spindrift.click 
and our environmental blogs at http://www.verdigrisproject.com


___
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] GNU Cash End of Year Closing of Accounts

[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'd like to be able to select the
> archive file for the appropriate year.
> 
> This would free up lots of memory and make it less cumbersome to find
> the beginning of the current year and not have to scroll down through
> prior years data to find the beginning of the current year.
> 
> I hope this makes sense to you. If I understood the programming
> language, I'd do it myself and submit the update to the appropriate
> location so everyone could take advantage of the update.
> 
> Thank you for your understanding of the problem.
> 
> 
> Stephen Brandt
> 
> A frustrated user of GNU Cash.  I love the program, with the above
> exception.

have you considered the "close books" feature?
http://www.gnucash.org/viewdoc.phtml?doc=help
Section 8.9

Liz
___
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 Import add Memo to transaction

[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 accounts open in browser tabs to lookup
> transactions to be sure I categorize them to my liking. There is
> information important to me that I want to add as a memo in each of
> the transactions. Sometimes I try to modify the transaction after I
> enter / classify it into the correct 'category' entering a memo
> however I generally get message something to the effect of
> 'transaction is open in another window, please close or finish that
> edit' I'm assuming the message is referring to the 'Generic import
> transaction matcher' window, other times I get a message about the
> transaction being out of balance after I've added a memo - usually
> the former about the record being open in another window.
> 
> Is there a way to add a memo during the import process?
> 
> If not It's a feature I'd very much like to see. I imagine that once
> I select the account for the match it could open up in a 'transaction 
> journal' view allowing me to enter a memo and clicking a O.K. accept 
> button. The 'transaction journal' view could be displayed in the 
> 'Generic import transaction matcher' for items that have been
> matched. A check box could enable (or disable) this behavior in the
> 'Generic import transaction matcher' screen. And / or as a
> preferences selection.
> 
>   - Jeff
> 
> 

To help us understand, we need some more information about your work
flow.
Do you enter transactions into Gnucash one by one, and then run the
import looking for ones you have missed (or could be fraudulent) OR do
you use the OFX file to populate your Gnucash ledger?

If you do enter one by one you can of course put the memo in at that
stage. The importer will find the transaction as a possible match, and
you will tell it NOT to amend the matched transaction.

Liz
___
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] How to see major category totals by month?

[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 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 month? When I do a profit & loss report for a
> specific month, for example, the major category totals are all $0.00
> because the individual transactions are given in the subcategories.
>
> Thanks for any help you can provide.
> Eric
>
___
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] How to see major category totals by month?

[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 month? When I do a profit & loss report for a
specific month, for example, the major category totals are all $0.00
because the individual transactions are given in the subcategories.

Thanks for any help you can provide.
Eric
___
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] GNU Cash End of Year Closing of Accounts

[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 year.

This would free up lots of memory and make it less cumbersome to find
the beginning of the current year and not have to scroll down through
prior years data to find the beginning of the current year.

I hope this makes sense to you. If I understood the programming
language, I'd do it myself and submit the update to the appropriate
location so everyone could take advantage of the update.

Thank you for your understanding of the problem.


Stephen Brandt

A frustrated user of GNU Cash.  I love the program, with the above
exception.

___
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] Downloading stock prices in the UK

[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 downloads worked
perfectly for all stocks without a hitch.

Prior to your suggestion, I had been put off the use of AlphaVantage by its
US suffix and had tried all of the GB suffixed sources before concluding
that it must be the Symbol or Namespace Type that was causing the problem.
Reassurance from you and Fred helped to clarify that aspect so I was then
able to focus on AlphaVantage again, initially without success until I
discovered the need for a key!

Thanks again; I'm very grateful for all the help given.

Best wishes

Alan



Eric Coates wrote
> Alan
> 
> Before commenting about the failure of Get Online Quotes to get anything 
> useful a small amplification of Fred Bone's comment that *Type* can be 
> anything you want (Fred has given his choice, I use a different set - 
> LSE for London quoted shares, EUREX for shares quoted on continental 
> European bourses, Fund for unit trusts - use whatever works for you ) so 
> can the *F**ull Name* - for example you could use SSE or Scottish and 
> Southern Electricity or even its full formal name SSE Plc Ord 50p.
> 
> As for why you're not getting even one quote ...
> 
> You've obviously got an internet connection and you're?? ticking the *Get 
> Online Quotes* box and (I assume) you've updated the AphaVantage.pm file 
> so I'm close to the edge of my knowledge.
> 
> On the basis of those assumptions, I'd try something a little "left 
> field". Safeguard your data and try changing the source of quotes to 
> *Single - Yahoo as JSON*. As I said earlier Yahoo is seen as reliable (I 
> use it for my European shares) but I'd expect you to get a price that 
> will be 100 times too big (just try one share then if you're 
> brave/foolhardy enough to risk your live data it's easy to delete the 
> wrong value). The result of this experiment may (just may) give us 
> something to get our teeth into. And when I say "us"/"our" I mean the 
> community at large - as I said I'm staring into the dark.
> 
> Best wishes
> 
> Eric
> 
> PS: But there's a small niggle that I've just noticed: I've just 
> upgraded my operating system and got an upgraded gnuCash as a bonus (I'm 
> now running gnuCash 3.4 with Finance::Quote 1.47 on Ubuntu 19.04 all of 
> which, I believe, are the most up-to-date versions). In the Edit 
> Security window what used to appear as *AlphaVantage* in the *Unknown* 
> category now appears as *Alphavantage, US* under *Single*. Even though 
> the name has changed Alphavantage, US gives me legitimate values for UK 
> shares. Did the US put you off? It seems unlikely.
> 
> 
> ==





--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.