Re: [GNC] Changing account tree on large database

[David Carlson]

David T and Cricket,

I am still using release 2.6.19 in either Windows 7 or Ubuntu 18.04 but I
like to keep several reports and 30 0r so accounts open when I close the
program a few times a week.  When I heard that 3.x was much slower and even
now still has other bugs that would frustrate me I decided to wait longer
to take the plunge.  i mostly run it in a direct session on a Ubuntu
virtual machine which is faster than Windows but  I do see a few seconds
lags with the enter key and I play a lot of solitaire during those pesky
automagical file backups every half hour.  I think that GnuCash has to do a
huge number of background computations, mostly single threaded, which are
likely caused by the compiler and not really needed every time the enter
key is pressed, even in Linux.  Oh, my data file is stored on a separate
NAS elsewhere on my LAN and I don't do anything special to try using a
local copy with manual backups to the NAS.  My Ethernet is mostly Gigahertz
but I recently found that  it has some 10 MHz bottlenecks which I have not
yet pinpointed and fixed.  Some parts are now well over 15 years old and
there may still be some short Cat 5 segments in the system. So there is
some room for improvement there.

My data file starts in September 2007 with bank accounts and gradually gets
more complete until it has almost everything after 2010. My data file is
7.2 Meg in compressed XML.  It ties up 1.7 GiB out of 5.5 GiB RAM in the
Ubuntu Virtual Box guest.  I forgot where to look for the number of
transactions.  All this in a Dell Precision 7510 Laptop with an Intel Core
I7-6820HQ processor @ 2.7 GHz CPU with 24 GiB RAM running Windows 7.

That is where I am at right now.

David Carlson

On Fri, Apr 26, 2019 at 11:45 PM David T.  wrote:

> 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 <
> cricketbeauti...@gmail.com>
> > 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.
> >

Re: [GNC] Need help reconciling

[Colin Law]

I am sure we have been over this before.  You should not generally
need to touch the reconcile column in the register yourself.  It is
all done through the Reconcile feature.  Open the credit card (or
bank) account and select Options > Reconcile.  Check the opening
balance matches the opening balance on the statement from the bank,
enter the closing balance from the statement and then tick off the
transactions.

Colin

On Fri, 26 Apr 2019 at 23:22, ToddAndMargo via gnucash-user
 wrote:
>
> 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&lang=C&doc=help
>  https://gnucash.org/viewdoc.phtml?rev=3&lang=C&doc=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.
___
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/27/19 12:11 AM, Colin Law wrote:

I am sure we have been over this before.  You should not generally
need to touch the reconcile column in the register yourself.  It is
all done through the Reconcile feature.  Open the credit card (or
bank) account and select Options > Reconcile.  Check the opening
balance matches the opening balance on the statement from the bank,
enter the closing balance from the statement and then tick off the
transactions.

Colin


Something is wrong.  I don't have an opening Balance.  It
says it is zero

___
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

[Colin Law]

On Sat, 27 Apr 2019 at 08:34, ToddAndMargo via gnucash-user
 wrote:
>
> On 4/27/19 12:11 AM, Colin Law wrote:
> > I am sure we have been over this before.  You should not generally
> > need to touch the reconcile column in the register yourself.  It is
> > all done through the Reconcile feature.  Open the credit card (or
> > bank) account and select Options > Reconcile.  Check the opening
> > balance matches the opening balance on the statement from the bank,
> > enter the closing balance from the statement and then tick off the
> > transactions.
> >
> > Colin
>
> Something is wrong.  I don't have an opening Balance.  It
> says it is zero

If it is the first time you have reconciled this account then it will
be zero, and you should see your opening balance that you entered in
the reconcile window.  Obviously that is not in the bank statement.
This is a one-off situation due to the fact that you have started
using gnucash with the account already up and running.

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

[Colin Law]

On Sat, 27 Apr 2019 at 08:48, Colin Law  wrote:
>
> On Sat, 27 Apr 2019 at 08:34, ToddAndMargo via gnucash-user
>  wrote:
> >
> > On 4/27/19 12:11 AM, Colin Law wrote:
> > > I am sure we have been over this before.  You should not generally
> > > need to touch the reconcile column in the register yourself.  It is
> > > all done through the Reconcile feature.  Open the credit card (or
> > > bank) account and select Options > Reconcile.  Check the opening
> > > balance matches the opening balance on the statement from the bank,
> > > enter the closing balance from the statement and then tick off the
> > > transactions.
> > >
> > > Colin
> >
> > Something is wrong.  I don't have an opening Balance.  It
> > says it is zero
>
> If it is the first time you have reconciled this account then it will
> be zero, and you should see your opening balance that you entered in
> the reconcile window.  Obviously that is not in the bank statement.
> This is a one-off situation due to the fact that you have started
> using gnucash with the account already up and running.

I meant that you should see your opening balance in the list of
transactions waiting to be ticked off.

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

[David T. via gnucash-user]

All of this is covered in the Guide at 
https://www.gnucash.org/docs/v3/C/gnucash-guide/chapter_txns.html#txns-reconcile1
 
,
 especially 2.9.4.1, which includes a section regarding the starting balance, 
as well as a note specifically about the starting balance:

Note
The first time you reconcile your account, the starting balance will be 0.00, 
thus probably not the opening balance of your account. When you reconcile the 
account, the opening balance for the account will be included in the 
reconciliation, and the result should balance.


ToddAndMango, you might try reading the documentation.

David T.

> On Apr 27, 2019, at 1:18 PM, Colin Law  > wrote:
> 
> On Sat, 27 Apr 2019 at 08:34, ToddAndMargo via gnucash-user
> mailto:gnucash-user@gnucash.org>> wrote:
>> 
>> On 4/27/19 12:11 AM, Colin Law wrote:
>>> I am sure we have been over this before.  You should not generally
>>> need to touch the reconcile column in the register yourself.  It is
>>> all done through the Reconcile feature.  Open the credit card (or
>>> bank) account and select Options > Reconcile.  Check the opening
>>> balance matches the opening balance on the statement from the bank,
>>> enter the closing balance from the statement and then tick off the
>>> transactions.
>>> 
>>> Colin
>> 
>> Something is wrong.  I don't have an opening Balance.  It
>> says it is zero
> 
> If it is the first time you have reconciled this account then it will
> be zero, and you should see your opening balance that you entered in
> the reconcile window.  Obviously that is not in the bank statement.
> This is a one-off situation due to the fact that you have started
> using gnucash with the account already up and running.
> 
>> 
>> ___
>> 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.

___
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

[Liz]

On Sat, 27 Apr 2019 14:16:25 +0530
"David T. via gnucash-user"  wrote:

> ToddAndMango, you might try reading the documentation.

I'm going to put my education hat on here

We all learn in different combinations of three main ways
Hearing, Doing and Seeing
It doesn't matter how.
Most importantly
Some people just don't learn from lectures 
some just don't learn from reading a book

some only learn by doing and asking questions.
Sometimes they have the skills to research the answers to questions
Sometimes they don't have the skills to know what question to ask.

For the human identified as ToddAndMargo

I think we'd understand more if you could send some screenshots and a
bit more detail as you ask questions.

Liz
The Moderator
___
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

[Michael Hendry]

> On 27 Apr 2019, at 10:29, Liz  wrote:
> 
> On Sat, 27 Apr 2019 14:16:25 +0530
> "David T. via gnucash-user"  wrote:
> 
>> ToddAndMango, you might try reading the documentation.
> 
> I'm going to put my education hat on here
> 
> We all learn in different combinations of three main ways
> Hearing, Doing and Seeing
> It doesn't matter how.
> Most importantly
> Some people just don't learn from lectures 
> some just don't learn from reading a book
> 
> some only learn by doing and asking questions.
> Sometimes they have the skills to research the answers to questions
> Sometimes they don't have the skills to know what question to ask.
> 
> For the human identified as ToddAndMargo
> 
> I think we'd understand more if you could send some screenshots and a
> bit more detail as you ask questions.
> 
> Liz
> The Moderator

Couldn’t agree more, Liz, and especially the bit about knowing what question to 
ask.

In my past life as a GP facing a set of symptoms and signs that I couldn’t 
assemble into a diagnosis, I would suggest a referral to a consultant.

Away from the pressures of the consulting room, I would construct a referral 
letter containing a coherent history and clinical findings and in the process 
find that the diagnosis fell into my lap - not unlike the awkward crossword 
clue that mysteriously solves itself overnight.

Michael


___
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] Quicken import and duplicate records

[Priit Lilleleht]

Greetings, dear GnuCash gurus! :)

I wonder if there is an answer to my problem with Quicken data import? I
have used Quicken 2000 Home & Business since year 2000 but recently I
discovered GnuCash as a cute and at the same time much more serious
alternative to this old Quicken ("serious" meaning more close to the
professional bookkeeping). So I tried to import all my Quicken history to
Gnucash and it was generally a success except for the duplicate entries
which are created when there is a transfer from one account to another in
Quicken. Instead on one transaction there are 2 created in GnuCash and they
both are changing the balance. Here is one example:

https://drive.google.com/file/d/1ID-DxZTcPN8sy9QADt9sSG4PCRquBd5T/view

I suspect that when Quicken recorded this transfer then one record has flag
(Num) TXFR and the other has not, and GnuCash import treats them as
different transactions and creates a matching record for both of them. Also
Quicken has a possibility that when a transfer record is created then
afterwards you can add memo to the record of one account and this is
probably also treated as 2 different transactions in GnuCash when the memo
fields do not match. I have also many of those kind of records and they all
are imported as duplicates.

Maybe this is only the problem with old Quicken versions and the newer ones
do keep the transfer records matching. GnuCash is version 3.4.

Has anyone seen this kind of trouble before and are there any solutions?

Thank You in Advance,
Priit Lilleleht






Manuste ala
___
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] Quicken import and duplicate records

[Greg Feneis]

Hi,

I get duplicate transactions sometimes too.  I tend to download data from
financial institutions and import it to GnuCash on a quarterly basis and
catch things up.  The matcher does a pretty good job of assigning accounts
and so forth, but it's not perfect.  I find I still have to survey its work
and make minor corrections.  Still amazing free software and the matcher
does 90% of the work.

Sometimes, I'll import a credit card's account data, which will include
payments I make from my checking account to pay the credit card, so payment
transactions also appear in my checking account as a result of importing my
credit card data.  Then, if I import my checking account data, and if the
matcher and I don't see that the credit card payment transaction is already
in my checking account register, the matcher will import this payment
transaction and assign it to the credit card account, essentially causing a
duplicate transaction to appear.




Kind regards,

Greg Feneis




On Sat, Apr 27, 2019 at 6:47 AM Priit Lilleleht 
wrote:

> Greetings, dear GnuCash gurus! :)
>
> I wonder if there is an answer to my problem with Quicken data import? I
> have used Quicken 2000 Home & Business since year 2000 but recently I
> discovered GnuCash as a cute and at the same time much more serious
> alternative to this old Quicken ("serious" meaning more close to the
> professional bookkeeping). So I tried to import all my Quicken history to
> Gnucash and it was generally a success except for the duplicate entries
> which are created when there is a transfer from one account to another in
> Quicken. Instead on one transaction there are 2 created in GnuCash and they
> both are changing the balance. Here is one example:
>
> https://drive.google.com/file/d/1ID-DxZTcPN8sy9QADt9sSG4PCRquBd5T/view
>
> I suspect that when Quicken recorded this transfer then one record has flag
> (Num) TXFR and the other has not, and GnuCash import treats them as
> different transactions and creates a matching record for both of them. Also
> Quicken has a possibility that when a transfer record is created then
> afterwards you can add memo to the record of one account and this is
> probably also treated as 2 different transactions in GnuCash when the memo
> fields do not match. I have also many of those kind of records and they all
> are imported as duplicates.
>
> Maybe this is only the problem with old Quicken versions and the newer ones
> do keep the transfer records matching. GnuCash is version 3.4.
>
> Has anyone seen this kind of trouble before and are there any solutions?
>
> Thank You in Advance,
> Priit Lilleleht
>
>
>
>
>
>
> Manuste ala
> ___
> 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

[Greg Feneis]

Alternatively, Cricket, instead of exporting from Quicken, then arranging
things as you like, then importing to GnuCash, or some variation of that,
you could make a copy of your Quicken working file and from within Quicken,
arrange things as you like with a mind toward exporting to GnuCash, then
export from Quicken and import to GnuCash.  At one point, I recall trying
to decipher OFX or QIF files.  I found that exporting the same data as CSV
and opening in Excel gave me good hints about what I was looking at in the
OFX or QIF




Kind regards,

Greg Feneis




On Fri, Apr 26, 2019 at 8:06 PM Cricket Onebit 
wrote:

> >
> > 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.
>
___
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] Tips for reporting

[V. Vatsal via gnucash-user]

Hello,

I am trying to get a more granular look at one of my expense categories, and 
hoping that one of the gurus can tell me how best to do it.

Basically, I want to be able to set a date range, and see all the transactions 
in that range grouped according to the merchant, using the information in the 
description field.

Can this be done within GnuCash? I have played around with some subset of the 
built-in reports, but can’t find one that does it right away.

The only way I can think of is to export to CSV and then use a spreadsheet, but 
I hope to avoid that because there’s no way to set the date range in the export 
as far as I can tell.

I am on Mac OS, for the record.

Thanks,

Nike


___
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] OFX Import requests (Mac OS)

[V. Vatsal via gnucash-user]

Hi,

I have a couple of questions/requests about OFX importing on a Mac.

Would it be possible to get the active field in the import window highlighted, 
so one can see which line is being edited? As it stands, clicking on an entry 
to adjust the account brings up another window for account selection, but 
there’s no indication of which transaction is being adjusted, so if you take 
your eye of the screen to answer a call or get distracted by something else, 
you have no idea which line you were working on when you go back. It’s a small 
point, but it can be annoying, especially when trying to reconcile an account 
with a statement or fix a bungled import, when there are lots of lines to be 
changed and lots of things to look at. 

Second, is there a way to edit the memo field prior to import? I cannot find 
out how to do this. Clicking in that field just brings up the account selection 
window.

Thanks in advance,

Nike
___
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] Tips for reporting

[Maf. King]

On Saturday, 27 April 2019 15:53:38 BST V. Vatsal via gnucash-user wrote:
> Hello,
> 
> I am trying to get a more granular look at one of my expense categories, and
> hoping that one of the gurus can tell me how best to do it.
> 
> Basically, I want to be able to set a date range, and see all the
> transactions in that range grouped according to the merchant, using the
> information in the description field.
> 
> Can this be done within GnuCash? I have played around with some subset of
> the built-in reports, but can’t find one that does it right away.
> 

Hi Nike,

I think the Transaction report can sort (and subtotal) by description.  That 
may get you close.

HTH,
Maf.




___
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

[Adrien Monteleone]

> On Apr 26, 2019, at 4:28 PM, Cricket Onebit  
> wrote:
> 
> 
> 
> 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.)
> 

There’s no official ’tag’ support, but some reports let you filter based on 
text in certain fields and you can use regular expressions if you like.

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

The Transaction Report does this by default. I currently have a report open 
that is tracking my expenses at a Festival this weekend. I reload the report 
each day and it show my transactions with sub-account totals for amounts spent 
on Food, Beer, tips, etc. Each transaction has the festival name in the Notes 
field and I’m using that as a ’tag’ filter.


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

Work on a copy of the export and if something blows up, you won’t lose anything.

Regards,
Adrien


___
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] Paying business vendor invoice: enter vendor's name twice

[Rich Shepard]

Just curious about this behavior that I finally noticed while paying vendor
invoices this morning.

Selecting Business -> New bill produces a dialog box with a text entry
widget for the vendor's name. When I enter the name and click the 'Select'
button, a new dialog pops up asking me to enter the vendor's name (again),
find it, then re-select it.

Why isn't the first selection of the vendor's name accepted and the
following action is to open an A/P transaction tab?

Regards,

Rich
___
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

[Adrien Monteleone]

> On Apr 26, 2019, at 8:49 PM, Cricket Onebit  
> wrote:
> 
> 
> 
> (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?)

There was some display issue with business info when I first moved from 2.6.19 
to 3.0, but that was fixed quickly and no data was lost. That is the only issue 
I’ve encountered personally, but you can check out Bugzilla and read over the 
SQL bugs to see if they scare you away from it, or you find you can live with 
them. (I’m using Sqlite3 backend for a few years now)

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

I created a tree of accounts under `Assets:Current Assets` like so:

Reimbursements:Family
Reimbursements:Friends

and then an account for each person under those. I have 5 siblings and we often 
consolidate large gift buys for our parents among other expenses, so I use 
these to track who owes me or who I owe. I have an account for each of my 
parents as well. Sometimes they give me money to buy something for them. I’ll 
first debit it to cash and credit their reimbursement account, and then debit 
their account and credit cash when I make the purchase. I don’t involve my 
expense accounts in this case because it was just a pass-through. Those aren’t 
*my* expenses. I suppose it could get a little messier involving cards or bank 
transfers/deposits but the idea is the same. For shared expenses like a large 
gift, I’ll only expense my portion and the rest goes through the reimbursement 
accounts.

I suppose you could place these under Liabilities instead, but since the case 
is usually that my family owes me, I put them under assets. The sign of the 
balance will tell me which it really is.

Regards,
Adrien
___
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

[Adrien Monteleone]

> On Apr 26, 2019, at 9:49 PM, Cricket Onebit  
> wrote:
> 
> 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.

Using the Sqlite backend I get one file that I can either use an sqlite 
viewer/query editor on, or using piecash, query directly for any custom report 
I want that isn’t offered by GnuCash. And I don’t have to mess with a MySQL db 
server. (which is fine, but if you don’t really *need* to...)

I also get instant saves as I enter each transaction so no waiting around while 
it writes that massive file back to disk every 10 minutes or so.

Let that temptation sink in.

Regards,
Adrien
___
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] Quicken import and duplicate records

[D via gnucash-user]

Priit,

I suspect you imported the transactions for Swedbank, and then imported ones 
from LHV, correct? 

When you do this, you must ensure that you take the time in the second import 
to ensure that the transaction from Swedbank to LHV is matched to the 
transaction from the first import. They are two sides of the same transaction, 
and Gnucash is not necessarily going to know that. So, you teach the matcher by 
demonstration.

That will eliminate the duplicate entries. Of course, you can delete one of 
them after the fact, but it is better to get the matching right.

(Note: if I have the sequence wrong, the concept nevertheless holds)

David

On April 27, 2019, at 7:43 PM, Greg Feneis  wrote:

Hi,

I get duplicate transactions sometimes too.  I tend to download data from
financial institutions and import it to GnuCash on a quarterly basis and
catch things up.  The matcher does a pretty good job of assigning accounts
and so forth, but it's not perfect.  I find I still have to survey its work
and make minor corrections.  Still amazing free software and the matcher
does 90% of the work.

Sometimes, I'll import a credit card's account data, which will include
payments I make from my checking account to pay the credit card, so payment
transactions also appear in my checking account as a result of importing my
credit card data.  Then, if I import my checking account data, and if the
matcher and I don't see that the credit card payment transaction is already
in my checking account register, the matcher will import this payment
transaction and assign it to the credit card account, essentially causing a
duplicate transaction to appear.




Kind regards,

Greg Feneis




On Sat, Apr 27, 2019 at 6:47 AM Priit Lilleleht 
wrote:

> Greetings, dear GnuCash gurus! :)
>
> I wonder if there is an answer to my problem with Quicken data import? I
> have used Quicken 2000 Home & Business since year 2000 but recently I
> discovered GnuCash as a cute and at the same time much more serious
> alternative to this old Quicken ("serious" meaning more close to the
> professional bookkeeping). So I tried to import all my Quicken history to
> Gnucash and it was generally a success except for the duplicate entries
> which are created when there is a transfer from one account to another in
> Quicken. Instead on one transaction there are 2 created in GnuCash and they
> both are changing the balance. Here is one example:
>
> https://drive.google.com/file/d/1ID-DxZTcPN8sy9QADt9sSG4PCRquBd5T/view
>
> I suspect that when Quicken recorded this transfer then one record has flag
> (Num) TXFR and the other has not, and GnuCash import treats them as
> different transactions and creates a matching record for both of them. Also
> Quicken has a possibility that when a transfer record is created then
> afterwards you can add memo to the record of one account and this is
> probably also treated as 2 different transactions in GnuCash when the memo
> fields do not match. I have also many of those kind of records and they all
> are imported as duplicates.
>
> Maybe this is only the problem with old Quicken versions and the newer ones
> do keep the transfer records matching. GnuCash is version 3.4.
>
> Has anyone seen this kind of trouble before and are there any solutions?
>
> Thank You in Advance,
> Priit Lilleleht
>
>
>
>
>
>
> Manuste ala
> ___
> 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.
___
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

[D via gnucash-user]

Good points, Greg. I believe that echoes what the wiki says on the subject.

David

On April 27, 2019, at 8:01 PM, Greg Feneis  wrote:

Alternatively, Cricket, instead of exporting from Quicken, then arranging
things as you like, then importing to GnuCash, or some variation of that,
you could make a copy of your Quicken working file and from within Quicken,
arrange things as you like with a mind toward exporting to GnuCash, then
export from Quicken and import to GnuCash.  At one point, I recall trying
to decipher OFX or QIF files.  I found that exporting the same data as CSV
and opening in Excel gave me good hints about what I was looking at in the
OFX or QIF




Kind regards,

Greg Feneis




On Fri, Apr 26, 2019 at 8:06 PM Cricket Onebit 
wrote:

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

[GNC] sqlite error from gnucash 2.6.19

[Jeff Abrahamson]

I opened a gnucash file (sqlite, gnucash v2.6.19, built from version
c1b5e6c8d+) and saw a stream of errors in /tmp/gnucash.trace

* 18:36:09  CRIT  xaccAccountGetName: assertion
'GNC_IS_ACCOUNT(acc)' failed

I presume this means some bit of corruption in the sqlite file, but
googling isn't helping me know what to do about it.  Something gnucash
specific?  Use sqlite tools directly?  Other?

-- 

Jeff Abrahamson
+33 6 24 40 01 57
+44 7920 594 255
https://www.p27.eu/jeff/
https://www.transport-nantes.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] Paying business vendor invoice: enter vendor's name twice

[Adrien Monteleone]

From the Help manual

7.10.1. New Bills

"Billing Info - Vendor - the issuing vendor. If you remember the company name 
you entered in the New Vendor window for this vendor, start to type it in this 
field and GnuCash will try auto complete it for you. Else, press the Select... 
button to access the Find Vendor window described in Section 7.9.2, “Find and 
Edit”. Highlight the vendor you are looking for with a click in the search 
results, then press the Select button.”

Notice the ‘else’ at the beginning of the second sentence. Only use that select 
button to open a find dialog if GnuCash doesn’t manage to give you the desired 
vendor in an auto-complete list.

And the last sentence saying to "press the Select button" is for the find 
dialog search results, not the New invoice dialog.

Regards,
Adrien

> On Apr 27, 2019, at 11:10 AM, Rich Shepard  wrote:
> 
> Just curious about this behavior that I finally noticed while paying vendor
> invoices this morning.
> 
> Selecting Business -> New bill produces a dialog box with a text entry
> widget for the vendor's name. When I enter the name and click the 'Select'
> button, a new dialog pops up asking me to enter the vendor's name (again),
> find it, then re-select it.
> 
> Why isn't the first selection of the vendor's name accepted and the
> following action is to open an A/P transaction tab?
> 
> Regards,
> 
> Rich

___
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] Tips for reporting

[D via gnucash-user]

Maf,

The transaction report capabilities have changed dramatically between 2.x and 
3.x, so the OP would need to be using 3.5 to get those features. But otherwise 
you are correct.

David

On April 27, 2019, at 9:29 PM, "Maf. King"  wrote:

On Saturday, 27 April 2019 15:53:38 BST V. Vatsal via gnucash-user wrote:
> Hello,
> 
> I am trying to get a more granular look at one of my expense categories, and
> hoping that one of the gurus can tell me how best to do it.
> 
> Basically, I want to be able to set a date range, and see all the
> transactions in that range grouped according to the merchant, using the
> information in the description field.
> 
> Can this be done within GnuCash? I have played around with some subset of
> the built-in reports, but can’t find one that does it right away.
> 

Hi Nike,

I think the Transaction report can sort (and subtotal) by description.  That 
may get you close.

HTH,
Maf.




___
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] Tips for reporting

[Maf. King]

David,

thanks for the reminder!  Might save Nike some head scratching if he's still 
on a 2.x version.

It is easy to forget exactly when certain options came into being!

Maf.

On Saturday, 27 April 2019 18:06:25 BST D wrote:

> Maf,
> 
> The transaction report capabilities have changed dramatically between 2.x
> and 3.x, so the OP would need to be using 3.5 to get those features. But
> otherwise you are correct.
> 
> David
> 
> On April 27, 2019, at 9:29 PM, "Maf. King"  wrote:
> 
> On Saturday, 27 April 2019 15:53:38 BST V. Vatsal via gnucash-user wrote:
> > Hello,
> > 
> > I am trying to get a more granular look at one of my expense categories,
> > and hoping that one of the gurus can tell me how best to do it.
> > 
> > Basically, I want to be able to set a date range, and see all the
> > transactions in that range grouped according to the merchant, using the
> > information in the description field.
> > 
> > Can this be done within GnuCash? I have played around with some subset of
> > the built-in reports, but can’t find one that does it right away.
> 
> Hi Nike,
> 
> I think the Transaction report can sort (and subtotal) by description.  That
> may get you close.
> 
> HTH,
> Maf.
> 
> 
> 
> 
> ___
> 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.


-- 
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] Tips for reporting

[V. Vatsal via gnucash-user]

Thank you both.

Indeed, the Transaction Report in 3.5 works for what I want (Although I would 
have never guessed it from the name.)



> On Apr 27, 2019, at 7:06 PM, D  wrote:
> 
> Maf,
> 
> The transaction report capabilities have changed dramatically between 2.x and 
> 3.x, so the OP would need to be using 3.5 to get those features. But 
> otherwise you are correct.
> 
> David
> 
> On April 27, 2019, at 9:29 PM, "Maf. King"  wrote:
> 
> On Saturday, 27 April 2019 15:53:38 BST V. Vatsal via gnucash-user wrote:
>> Hello,
>> 
>> I am trying to get a more granular look at one of my expense categories, and
>> hoping that one of the gurus can tell me how best to do it.
>> 
>> Basically, I want to be able to set a date range, and see all the
>> transactions in that range grouped according to the merchant, using the
>> information in the description field.
>> 
>> Can this be done within GnuCash? I have played around with some subset of
>> the built-in reports, but can’t find one that does it right away.
>> 
> 
> Hi Nike,
> 
> I think the Transaction report can sort (and subtotal) by description.  That 
> may get you close.
> 
> HTH,
> Maf.
> 
> 
> 
> 
> ___
> 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] Paying business vendor invoice: enter vendor's name twice

[Rich Shepard]

On Sat, 27 Apr 2019, Adrien Monteleone wrote:


Notice the ‘else’ at the beginning of the second sentence. Only use that
select button to open a find dialog if GnuCash doesn’t manage to give you
the desired vendor in an auto-complete list.


Ah so. Having the 'Select' button immediately adjacent to the vendor name
text entry widget _implies_ the user wants to select that vendor. It has not
be obvious (or 'intuitive' as applications like to call it) that after
entering the vendor's name I just click the OK button. The position of the
dialog box suggested to me that gnucash should select the entered name.

And, I did not look in the manual for how to generate a new vendor invoice
because the menus seemed sufficiently easy to understand.

Thanks for clarifying,

Rich
___
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] Paying business vendor invoice: enter vendor's name twice

[Rich Shepard]

On Sat, 27 Apr 2019, Adrien Monteleone wrote:


"Billing Info - Vendor - the issuing vendor. If you remember the company
name you entered in the New Vendor window for this vendor, start to type
it in this field and GnuCash will try auto complete it for you.


What's missing in this sentence are these four words, "then click the OK
button."

Rich

___
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] Quicken import and duplicate records

[David Cousens]

Priit,

Are you following the suggestions on the following Wiki page
https://wiki.gnucash.org/wiki/Quicken_Migration. 

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] sqlite error from gnucash 2.6.19

[John Ralls]

> On Apr 27, 2019, at 10:00 AM, Jeff Abrahamson  wrote:
> 
> I opened a gnucash file (sqlite, gnucash v2.6.19, built from version
> c1b5e6c8d+) and saw a stream of errors in /tmp/gnucash.trace
> 
>* 18:36:09  CRIT  xaccAccountGetName: assertion
>'GNC_IS_ACCOUNT(acc)' failed
> 
> I presume this means some bit of corruption in the sqlite file, but
> googling isn't helping me know what to do about it.  Something gnucash
> specific?  Use sqlite tools directly?  Other?
> 

Don't leap to conclusions. First run GnuCash with the --debug option. That will 
provide a great deal more information that should help resolve where the error 
is coming from.

If it does prove to be a database problem next run gnucash with --log 
gnc.backend.dbi=debug which will print out all of the SQL queries. If it's 
really corrupt data then the errors will be interleaved with the queries. That 
should provide you enough information to query the database with the sqlite3 
command-line tool and figure out exactly what's wrong.

Regards,
John Ralls
___
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] 8.1 Find (^F) set default search preferences?

[Jeff Albrecht]

I looked through '8.1 Find' 
https://www.gnucash.org/docs/v3/C/gnucash-help/tool-find.html hoping to 
find a way to save a default search criteria setup. I didn't see that in 
this section, is there a way?


I've been searching repeatedly today as I enter some transactions for a 
bank that apparently only exports to .CSV without much retention. Before 
I manually enter a transaction I search on the transactions amount to 
see if possibly I've already entered it.


When I enter ^F for search it always comes up with
 Type of search radio buttons - Refine current search. (I don't have 
any other open searches.)

 Search Criteria - description -> contains

I'd like it to come up at least for this afternoon's workflow where I'm 
using ^F many times...

 Type of search radio buttons - New search
 Search Criteria - Value (once I select Value has credits or debits and 
equal to list items are selected.)


 - 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] 8.1 Find (^F) set default search preferences?

[Adrien Monteleone]

I don’t know of a way to save search criteria, however, when you do a Find, you 
get a results tab.

If you do a subsequent find, you’ll effectively be narrowing the search 
results. (because you’re running the find from the results tab, the new find 
window is using that as the data set)

So if you need to repeatedly start from a particular criteria, run that `find` 
operation once to get the intial data set, then from that tab, run find again 
as you like to narrow down the search.

Just don’t close the initial search result, and always run your next `find` 
from that tab if that is the data set you want to narrow down. (or just keep 
running `find` from the next results tab to keep narrowing down further.)

Regards,
Adrien

> On Apr 27, 2019, at 8:09 PM, Jeff Albrecht  wrote:
> 
> I looked through '8.1 Find' 
> https://www.gnucash.org/docs/v3/C/gnucash-help/tool-find.html hoping to find 
> a way to save a default search criteria setup. I didn't see that in this 
> section, is there a way?
> 
> I've been searching repeatedly today as I enter some transactions for a bank 
> that apparently only exports to .CSV without much retention. Before I 
> manually enter a transaction I search on the transactions amount to see if 
> possibly I've already entered it.
> 
> When I enter ^F for search it always comes up with
>  Type of search radio buttons - Refine current search. (I don't have any 
> other open searches.)
>  Search Criteria - description -> contains
> 
> I'd like it to come up at least for this afternoon's workflow where I'm using 
> ^F many times...
>  Type of search radio buttons - New search
>  Search Criteria - Value (once I select Value has credits or debits and equal 
> to list items are selected.)
> 
>  - 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] 6.15.5.2. Assign a Destination Account to Multiple Transaction

[David Cousens]

The files to patch  V3.5 to allow multiple selection and assignment of a
transfer account to the selection are attached. Unfortunately only if you
build from sources. Hopefully they will be in 3.6 when it is released.

Rename import-main-matcher.c to import-main-matcher.c.old  in
~/gnucash/import-export/ where ~ is your directory containing the GnuCash
sources. Better to append ".old" to the original file rather than replacing
it in case you want to revert to the original. The copy this file
import-main-matcher.c
  
to the same location.

Similarly rename ~/gnucash/gtkbuilder/dialog-import.glade to
dialog.glade.old and copy the following file
dialog-import.glade
  
 to the same location.

Then rebuild GnuCash as you would normally.

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.