Re: Preferred Date Format When Importing CSV Files

[David Carlson]

It does seem odd that the importer does not default to the same choice that
the user has chosen for the data file, even though it is important to allow
the user to change it if (s)he has a CSV file with a different choice.

David C

On Sat, Jul 29, 2017 at 7:36 AM, Jean-David Beyer 
wrote:

> On 07/28/2017 09:32 PM, Paul W. wrote:
> > I set the date format to m-d-y in Edit>Preferences>Date/time
> >
> > When I import CSV files, the date format on the Preview Settings page
> shows y-m-d.  I manually change the format to m-d-y.
> > What do I need to do to have GC automatically show the format I selected.
> >
> Different strokes...
>
> Years ago I had to figure out how to make dates all y-m-d because
> sorting by date is easier for me that way.
>
>
> --
>   .~.  Jean-David Beyer  Registered Linux User 85642.
>   /V\  PGP-Key:166D840A 0C610C8B Registered Machine  1935521.
>  /( )\ Shrewsbury, New Jerseyhttp://linuxcounter.net
>  ^^-^^ 08:35:01 up 3 days, 9:30, 2 users, load average: 5.05, 4.83, 4.54
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

GnuCash with bad network connection

[David Carlson]

My home Wi-Fi has suddenly developed a bad case of dropouts in spite of a
very strong signal.  Several times a day various devices need to reconnect.

With that background, if GnuCash is in the process of saving the data file
(over Wi-Fi) when the dropout happens, GnuCash appears to hang and my
Windows 7 OS reports that the file save failed and after the destination
returns it asks me if I want to try again, but it needs a file name.

Through trial and error I was able to revive Gnucash and let it do the save
using it's internal procedure without crashing and losing data.

My question is whether there is a place in the documentation that
summarizes troubleshooting various file save problems such as this or
possibly other issues with saving or backing up to places other than the
local hard drive.

I heard through the grapevine that the Q product has recently been having
serious data loss issues with this type of network problem.

David C
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: gnucash update on debian errors, then stops

[David Carlson]

Is that the new package  of release 2.6.17 from getdeb that I just tried to
download into Ubuntu and have not had time to test yet?

David C

On Aug 1, 2017 8:25 PM, "John Griessen"  wrote:

> I have not been able to upgrade gnucash for a while now.
>
> Will there be a usable gnucash in the next debian release?
> If not, why not?
>
>
> I still use this version on debian stretch/testing/frozen, soon to be the
> new released debian stable:
>
> sudo apt-get purge gnucash-docs gnucash-common gnucash
> sudo dpkg -i gnucash_1%3a2.6.14-1_amd64.deb gnucash-common_1%3a2.6.14-1_al
> l.deb
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Scheduled Transaction Help :(

[David Carlson]

Another thing to try that once helped me to fix some old and broken SEx's
(android did tat and I can't fix it.) is to enter zero's into every empty
acccouunt value box so there are two values in each line.

Sounds crazy but it actually worked

David C

On Aug 3, 2017 2:48 AM, "Steve"  wrote:

> Sure...
>
> 
>
>
>
> --
> View this message in context: http://gnucash.1415818.n4.
> nabble.com/Scheduled-Transaction-Help-tp4693019p4693030.html
> Sent from the GnuCash - User mailing list archive at Nabble.com.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: advice on software

[David Carlson]

Chris,

There is a steep hill to climb to export history from a 'Q' program and
import it into GnuCash.

Many of GnuCash's current users felt that it was worth the effort to switch.

Even if you do not import any history, there is a learning curve to get
your account tree set up correctly, etc.  You should plan on spending a
minimum of several weeks to get your GnuCash file polished to the point
that you can show your reports to your officers and auditors.

That is only one comment from a satisfied GnuCash user.

David C

On Fri, Aug 11, 2017 at 6:31 PM, Chris Tsuji  wrote:

>Hi
>Hopefully, I did this correct.
>I am a treasurer of a not profit orgnization and need to decide on
>using quickbooks or gnucash.
>The currently use quickbooks but has be be redone.
>What is your advice?
>thanks in advance.
>Chris tsuji
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Reporting Repository ?

[David Carlson]

Did you look at gti90...@gmail.com answers in the clean CSI export thread?

David C

On Jul 3, 2017 9:42 AM, "John Ralls"  wrote:

>
>
> > On Jul 3, 2017, at 6:38 AM, aegross  wrote:
> >
> > On Mon, Jul 3, 2017 at 12:50 AM, John Ralls-2 [via GnuCash] <
> > ml+s1415818n4692486...@n4.nabble.com> wrote:
> >
> >> some non-committer can make a PR to incorporate them.
> >
> >
> > What is a "PR" ?
> >
>
> A Github pull request. It’s the preferred way for contributors who don’t
> have write access to our code base to propose changes.
>
> Regards,
> John Ralls
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Repeating transactions crash Gnucash 2.6.16 and 2.2.17

[David Carlson]

When you say you use the transaction again, do you mean that it is
scheduled and comes up when running the Since Last Run Assistant?  Exactly
at what point does it crash?

David C

On Thu, Jul 6, 2017 at 1:14 AM, Frank  wrote:

> I'm relatively to gnucash and am looking to replace Quicken.  I'm on
> Windows
> 10 and have tried both 2.6.16 and 2.6.17 and have the same problem.
>
>
>
> I have a repeating transaction (salary).  I input the transaction OK.  I
> then went to use the transaction again with no problem.  On the third
> entry,
> gnucash crashes.  Close, reopen, and I still cannot use the same
> transaction.  This is frustrating.
>
>
>
> Any help would be appreciated.
>
>
>
> Thanks
>
> Frank
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: "Point of sale debit or credit (Note: Depends on signage of amount)" appended to transactions in 2.6.17

[David Carlson]

Sorry, I am confused about field names.  Is that new message in the
description field instead of the current data or is it actually in the
Notes field where the previous message was prepended to the FI note?

David C

On Thu, Jul 6, 2017 at 1:26 PM, David Carlson <david.carlson@gmail.com>
wrote:

> John,
>
> Does that mean that when users download files from their financial
> institutions and import them offline they will always get that message in
> the description field?
>
> I would prefer "OFX ext. info: |Trans type:Generic debit|Memo:" as before,
> unless an option is added to even suppress that text.
>
> David C
>
> On Thu, Jul 6, 2017 at 12:42 PM, John Ralls <jra...@ceridwen.us> wrote:
>
>>
>> > On Jul 5, 2017, at 2:47 PM, John Vermeer <joh...@juno.com> wrote:
>> >
>> > Hi,
>> >
>> > Since upgrading to Gnucash 2.6.17 I am seeing the string "Point of sale
>> debit or credit (Note: Depends on signage of amount)" appended to the
>> description field of all my OFX transactions. I have aqbanking bringing
>> most transactions directly from my credit union.
>> >
>> > This exact string is found in https://github.com/Gnucash/gnu
>> cash/blob/master/src/import-export/ofx/gnc-ofx-import.c [line 107]. But
>> I am not certain that that is where it is coming from. I suppose that my
>> credit union could also be appending the string.
>> >
>> > This is happening in a home compiled Linux version as well as under
>> Gnucash installed in Windows 10.
>> >
>> > Is this a new feature? Or, possibly, a bug?
>>
>> It's a new feature [1] that was supposed to apply only to HBCI, so
>> there's an option to enable it on the HBCI import dialog but not the OFX
>> one where it's enabled by default.
>>
>> Regards,
>> John Ralls
>>
>> [1] https://github.com/Gnucash/gnucash/pull/139
>>
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Is there a way to set an account's beginning balance AFTER having created it in GnuCash?

[David Carlson]

Bob,

The Opening Balance shortcut that you see when creating an account is not
functional after the account is created, as you have seen.

That shortcut just creates a transaction to offset the opening balance with
an entry in Equity:Opening Balances.  You can open that account and
duplicate any previous  entry changing the transfer account to a different
account to create an opening balance in another account.

David C

On Thu, Jul 27, 2017 at 3:33 PM,  wrote:

> I’ve searched the help and can’t find anything that addresses this
> question.
>
> Thanks!
>
> Bob
>
> Sent from Mail for Windows 10
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: population

[David Carlson]

Christine,

It seems that you are the first to report your problem.  That is why the
developers are asking so many questions about details.  Please check the
about gnucash screen and tell them the exact release number and build date.

David C

On Wed, Aug 2, 2017 at 7:24 AM, Christine Maloney via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Yes the date and time are correct on the PC, I have windows 7 home
> premium. And I got the latest I think Gnucash 2017. I wonder if there is a
> fix for this.
>
>
>
> From: Dave H [mailto:hell...@gmail.com]
> Sent: Wednesday, August 02, 2017 12:00 PM
> To: AC ; Christine Maloney ;
> John Ralls 
> Cc: gnucash-user@gnucash.org
> Subject: Re: population
>
>
>
>
>
> On Wed, 2 Aug 2017 at 8:25 pm, Christine Maloney via gnucash-user <
> gnucash-user@gnucash.org  > wrote:
>
> 13/01/1899 is the exact date. I have downloaded a later version, 2017 and
> it
> is still doing the same. The date range is amended correctly but the report
> still does not show it.
>
>
>
> Is the date and time correct on your pc and in other programs/apps
> (clock/calendar) running on your pc ?
>
>
>
> Cheers Dave H
>
>
>
>
>
> ---
> This email has been checked for viruses by AVG.
> http://www.avg.com
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Help on US Tax Form 8825

[David Carlson]

It is curious that this form is not in the list.  For tax related accounts
that cannot be assigned to the proper form you could just mark the account
as tax related without the form assignment, and it will be in the report
where you will at least be reminded to include it in your filing.

David C

On Wed, Aug 9, 2017 at 10:59 AM, Edoardo Tirtarahardja <
etirta.2...@gmail.com> wrote:

> Why GNU Cash can't classify an expenses to be reported in US Federal Tax
> From 8825 Line 14 (Depreciation)? TurboTax shows that the annual
> depreciation shall be reported in this line, but I can't set the Tax
> Report Option as that line is not available.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Virtual accounts or line items

[David Carlson]

What I do is keep two register views open on the 'parent' account, one
'with sub-accounts' which shows the totals as seen by the bank and one
normal register view which shows the amount not dedicated to the 'virtual'
sub-account(s).

As suggested in the thread that you cited, I do not tell the bank anything
about the 'virtual' sub-account(s) transactions, so they will never appear
in an imported transaction list and thus they are never 'cleared' via the
import.  While it is not required to have a register view open during an
import, I always do, because I have a lot of cases where the import process
makes matching mistakes or incorrect transfer account assignments if I do
not monitor it.

In any case, my reconciliation is intended to verify transactions with the
bank, and it still works correctly in the 'with sub-accounts' register
view.  The 'Include Sub-Accounts option is not required.  I then look in
the 'virtual' sub-account(s) register(s) and I can reconcile them
separately.  For those accounts the reconciliation only tells me that I am
satisfied with those transactions.

As for budgeting, I do not use that feature, so I cannot comment.

David C

On Sun, Aug 6, 2017 at 2:19 PM, Jon Schewe  wrote:

> I've got a question about using virtual accounts along with QFX imports.
>
> I found this thread about using virtual accounts to do budgeting:
> http://gnucash.1415818.n4.nabble.com/Virtual-accounts-td1421283.html
>
> I rather like how it works from the perspective that I know how much money
> is available in my checking account for things that I haven't budgeted.
> This also works well when reconciling against my statement as I can check
> the box to include sub-accounts and everything balances.
>
> However when I import a QFX file, the importer will only look at the top
> level account for transactions. This means that I need to manually clear
> the transactions in the sub-accounts.
>
> My wife uses Quickbooks at work and says there is a view that works for her
> for this. She can create these virtual sub-accounts and see their
> individual transactions, however when she looks at the top-level account
> she sees all transactions for the top account and the sub-accounts.
>
> Is there a way to do this in GnuCash?
>
> Thanks,
>
> - Jon
>
> --
> http://mtu.net/~jpschewe
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Suggestion

[David Carlson]

For me the time to move, decrypt, and decompress the data file and generate
the register views and report views is so much longer than loading the
program that I do not even try to measure that part.

David C

On Sun, Aug 6, 2017 at 5:50 PM, Greg Feneis  wrote:

> Also FWIW, I just started GnuCash V...16 (not quite the latest) on my 6
> year old Win 7 laptop and it only took 25 Seconds to get to where it begins
> loading the data file.  While a lot of my programs take between 2 and 5
> seconds to load, I do have a few that take quite a bit longer to load than
> GnuCash does (programing, simulation, cad environments, etc.).
> ​
> Are other folks having a significantly longer wait than 25 Seconds for
> GnuCash to go from start to begin loading of data file?
>
> Kind regards,
>
> Greg Feneis
>
>
>
> On Sun, Aug 6, 2017 at 2:50 PM, aegross  wrote:
>
> > >>
> > On zondag 6 augustus 2017 16:46:24 CEST Sam McCoy wrote:
> > >Gentlemen:
> > >
> > >I have noticed the time it takes to load all the modules when
> starting
> > >up Gnu Cash.
> >
> > FWIW, I have anecdotally noticed that by far the longest module required
> to
> > load is Finance::Quote, which strictly speaking, is not GnuCash code.
> >
> > Regards,
> > AEG
> >
> >
> >
> >
> >
> > --
> > View this message in context: http://gnucash.1415818.n4.
> > nabble.com/Suggestion-tp4693076p4693081.html
> > Sent from the GnuCash - User mailing list archive at Nabble.com.
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Virtual accounts or line items

[David Carlson]

My bank does permit the customer to assign a 'category' to a transaction,
somewhat like some credit cards do.  I have no idea if that info would be
included in a OFX export.

David C



On Sun, Aug 6, 2017 at 7:43 PM, Jon Schewe <jpsch...@mtu.net> wrote:

> Ideally what I would like would be for some "real" transactions to
> reference the parent account and some to reference the virtual account.
> Then when importing the QFX the import process would look in the parent
> account and the sub-accounts.
>
>
> On Sun, Aug 6, 2017 at 6:15 PM, David Carlson <david.carlson@gmail.com
> > wrote:
>
>> What I do is keep two register views open on the 'parent' account, one
>> 'with sub-accounts' which shows the totals as seen by the bank and one
>> normal register view which shows the amount not dedicated to the 'virtual'
>> sub-account(s).
>>
>> As suggested in the thread that you cited, I do not tell the bank
>> anything about the 'virtual' sub-account(s) transactions, so they will
>> never appear in an imported transaction list and thus they are never
>> 'cleared' via the import.  While it is not required to have a register view
>> open during an import, I always do, because I have a lot of cases where the
>> import process makes matching mistakes or incorrect transfer account
>> assignments if I do not monitor it.
>>
>> In any case, my reconciliation is intended to verify transactions with
>> the bank, and it still works correctly in the 'with sub-accounts' register
>> view.  The 'Include Sub-Accounts option is not required.  I then look in
>> the 'virtual' sub-account(s) register(s) and I can reconcile them
>> separately.  For those accounts the reconciliation only tells me that I am
>> satisfied with those transactions.
>>
>> As for budgeting, I do not use that feature, so I cannot comment.
>>
>> David C
>>
>> On Sun, Aug 6, 2017 at 2:19 PM, Jon Schewe <jpsch...@mtu.net> wrote:
>>
>>> I've got a question about using virtual accounts along with QFX imports.
>>>
>>> I found this thread about using virtual accounts to do budgeting:
>>> http://gnucash.1415818.n4.nabble.com/Virtual-accounts-td1421283.html
>>>
>>> I rather like how it works from the perspective that I know how much
>>> money
>>> is available in my checking account for things that I haven't budgeted.
>>> This also works well when reconciling against my statement as I can check
>>> the box to include sub-accounts and everything balances.
>>>
>>> However when I import a QFX file, the importer will only look at the top
>>> level account for transactions. This means that I need to manually clear
>>> the transactions in the sub-accounts.
>>>
>>> My wife uses Quickbooks at work and says there is a view that works for
>>> her
>>> for this. She can create these virtual sub-accounts and see their
>>> individual transactions, however when she looks at the top-level account
>>> she sees all transactions for the top account and the sub-accounts.
>>>
>>> Is there a way to do this in GnuCash?
>>>
>>> Thanks,
>>>
>>> - Jon
>>>
>>> --
>>> http://mtu.net/~jpschewe
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>>
>>
>>
>
>
> --
> http://mtu.net/~jpschewe
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Is there a GC function to separate a multi-split transaction into sepa rate, 2-split transactions?

[David Carlson]

Paul,

I would not recommend doing that, as it would fill your bank account
register with many entries that would be a nightmare to reconcile against
your bank statement, but one brute force way to do it would be to duplicate
the transaction as many times as necessary, then edit each one to delete
every line except one, and change the bank account amount to match.

That would be easiest to do in transaction journal view with 2 line mode
selected.

David C

On Fri, Aug 18, 2017 at 10:24 AM, Paul W.  wrote:

> I have multiple bank deposit items showing in a single, multi-split
> transaction.
> Is there a GC function to separate the multi-split transaction into
> separate, 2-split transactions?
> If not, I would appreciate guidance on how to manually separate the
> splits, other than re-entering each deposit item as a separate transaction.
>
> GC novice, double-entry novice.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Trial Balance does not include amount of Return of Capital Investment splits

[David Carlson]

Chris,

It has been several years since I had a similar situation, but I see that
GnuCash still has a stock split assistant (Chapter 11, I think of the
tutorial) which helps to mash all of the parts of a split into a single
transaction.  Did you try that?

David C

On Thu, May 18, 2017 at 3:18 AM, Chris Good 
wrote:

> From: John Ralls [mailto:jra...@ceridwen.fremont.ca.us]
> Sent: Tuesday, 16 May 2017 2:05 PM
> To: Chris Good 
> Cc: GnuCash User Mailing List 
> Subject: Re: Trial Balance does not include amount of Return of Capital
> Investment splits
>
>
>
>
>
> On May 15, 2017, at 8:42 PM, John Ralls   > wrote:
>
>
>
>
> On May 15, 2017, at 7:41 PM, Chris Good   > wrote:
>
> Hi,
>
>
>
> I'm airing this before I raise a bug.
>
>
>
> I've noticed that if you do a Return of Capital transaction [1]
>
> I.e. Stock split with Shares=0, Price=0, Sell=Return of Capital value,
>
> the Trial Balance no longer balances by the value of the Return of Capital.
>
>
>
> The stock line value in the report does not include the Sell value of the
> RoT split.
>
>
>
> Can anyone throw any light on this?
>
>
>
> The Balance sheet also shows the incorrect asset value of the stock, but it
> still balances
>
> because it (incorrectly?) also shows Unrealised Gains in Equity with the
> value of the RoT.
>
>
>
> [1] https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-retofcap.html
>
>
>
> Regards, Chris Good
>
>
> A return of capital when booked that way creates an unrealized capital
> gain:
> You have the same number of shares but a lower basis. You can either
> recognize the capital gain or find a different way to record the RoC.
>
>
>
> It occurred to me that I should explain that a bit more fully.
>
>
>
> The original buy transaction sets the basis, and any transaction that
> changes the balance of money<->shares will affect the trial balance, so you
> need another pair of splits that adjusts Equity to compensate, just as you
> do when you sell a security.
>
>
>
> Under US tax law (the only flavor I know anything about) RoC reduces the
> basis so that taxes on it are deferred until one sells the asset
>
> and furthermore are at the (much lower) capital gains rate. There may be
> other benefits as well depending on the industry the company is in; those
> companies generally issue special tax documents (called "K-1s" in the US)
> that are a serious PITA to deal with. Most of the tax advantages other than
> the deferment are useful only to people in high tax brackets, so that sort
> of investment generally makes sense only to that sort of investor and makes
> no sense at all (except maybe diversification) in tax-deferred accounts
> like
> retirement accounts. The rules are likely different in other jurisdictions,
> so investors should study up and seriously consider consulting an
> accountant
> before investing.
>
>
>
> Anyway, if your jurisdiction allows you to reduce the basis of the
> investment instead of immediately recognizing the income then you'll want
> to
> set up a non-taxable income hierarchy with a "returned capital" account in
> which to recognize the income and to get your trial balance to balance.
> You'd otherwise treat it like any other capital gain/loss.
>
> If your jurisdiction doesn't allow you to defer recognizing the income by
> reducing the basis then an RoC is just a dividend with a funny name and you
> should book it accordingly.
>
>
>
> Regards,
>
> John Ralls
>
>
>
> Hi John,
>
>
>
> (Sorry about wrong abbreviation RoT I used previously when I meant RoC)
>
>
>
> Thanks very much for your input. Interesting to hear about US tax law.
> Australian tax law seems similar, at least as far as recording in GnuCash
> is
> concerned, but not as complicated thankfully.
>
> My RoC transactions are actually to do with a stock split where the value
> of
> one stock is reduced, but not the no of shares, and a no of a different
> stock are created for the same value. In my very limited, inexpert
> investment experience, the Aust Tax Office has made a ruling shortly after
> the split, detailing what the cost of the shares involved should be.
>
>
>
> Using the RoC transaction to reduce the original shares works fine with the
> Advanced Portfolio Rpt, but not with the Trial Balance, which makes using
> the TB to validate the correct capital gain/loss value of other sales more
> complicated than it should be.
>
>
>
> I tried everything I could think of to add another pair of splits that
> adjusts Equity as you suggested, but could not find anything that ends up
> with the right figures in all accounts and a balancing Trial Balance. Could
> you please give more detail?
>
>
>
> As the RoC transaction seems to be a problem, I thought that instead of
> doing a ROC, I would sell all the stock at cost (so there is 

When does GnuCash create .log files?

[David Carlson]

I used to think that GnuCash created .log files periodically when
theauto-save interval has passed since the last edit.

Now, it seems that GnuCash does a complete file save according to that
interval.  If that is the case, why have a .log file?

David C
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: List of Equity, Expenses and Liabilities has disappeared

[David Carlson]

Are you using View>New Accounts Page to see the list of accounts?

David C

On Mon, Jun 12, 2017 at 4:37 AM, Jonathan Silvey 
wrote:

> I
> ​ ​
> have two problems that may or may not be related.
>
> First, when I want to go to my main list of assets and liabilities, the
> name of the page is one of my Expense categories. For example, it is called
> 'Medical expenses '.
>
> Second, when I see the list of Accounts, it only gives my Assets. It does
> not show Equity, Expenses or Liabilities.  I do not know whether these
> faults are related or unconnected.
>
> Jonathan
>
> *Think before you print.*
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: When does GnuCash create .log files?

[David Carlson]

Google blocked this email so I amtrying again.

I cannot find any better description in the help files than what you
mentioned Buddha.

However, in Windows  GuCash makes a full save on that schedule instead of
making a .log file.  The result is that there is usually pnly one log file
and sometimes none if I do an early save.

David C


Sent via the Samsung Galaxy S® 5 ACTIVE™, an AT 4G LTE smartphone





 Original message 
From: Buddha Buck <blaisepas...@gmail.com>
Date: 5/16/17 2:41 PM (GMT-06:00)
To: David Carlson <david.carlson@gmail.com>, gnucash-user@gnucash.org
Subject: Re: When does GnuCash create .log files?


I believe, perhaps incorrectly, that the .log files are updated when a
change is made, and are dated based on the last (auto)save. So the most
recent log file will have an entry for each transaction since the last save.

On Tue, May 16, 2017 at 3:32 PM David Carlson <david.carlson@gmail.com>
wrote:

I didn't say that correctly.  I meant that I thought that GnuCash created
.log files periodically when the auto-save interval has passed since the
next edit after the last save or auto-save.  Then they would be useful if
it had been a while since the last full save.

With the current behavior (release 2.6.15 in Windows 7) the frequent full
saves seem superfluous to me.


David C​
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


On May 16, 2017 2:42 PM, "Buddha Buck" <blaisepas...@gmail.com> wrote:

> I believe, perhaps incorrectly, that the .log files are updated when a
> change is made, and are dated based on the last (auto)save. So the most
> recent log file will have an entry for each transaction since the last save.
>
> On Tue, May 16, 2017 at 3:32 PM David Carlson <david.carlson@gmail.com>
> wrote:
>
>> I didn't say that correctly.  I meant that I thought that GnuCash created
>> .log files periodically when the auto-save interval has passed since the
>> next edit after the last save or auto-save.  Then they would be useful if
>> it had been a while since the last full save.
>>
>> With the current behavior (release 2.6.15 in Windows 7) the frequent full
>> saves seem superfluous to me.
>>
>>
>> David C​
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Reconciling an account

[David Carlson]

I really hate to rain on your parade...
Check your Edit>Preferences>Accounts>Reverse Balanced Accounts.

I believe the default is labelled Credit, but that means Credit Card,
Payable, Liability
 Equity and Income, and that is probably what is checked in your file.

If that is so, then the balance should be positive, charges would be on the
right and your payments would be on the left as shown, and the
reconciliation is still backwards.

However, if your liability account was a sub-account of an asset account
you might see that behavior???

If that is true, you would need to move it under the Liability umbrella to
make it correct.  What bothers me, though is that you say previous months
were ok.  There was a change in release 2.6.16 that made it impossible to
make that kind of error (if it is, indeed an error), but I do not know how
it handles existing errors of that type.  It may be necessary to revert to
2.6.15 to correct this (see
https://bugzilla.gnome.org/show_bug.cgi?id=603379#c24).

David C


On Tue, Jun 6, 2017 at 6:36 PM, EngineInstitute 
wrote:

> Thanks for that hint David, I did check the running totals in the register
> and I did not find anything but what I did was realize what the source of
> the problem is.
> This is a liability account. In the reconciliation window the funds in
> should create a decrease on the balance and the funds out an increase That
> is it should be subtracting the income and adding the debts Here is the
> correct computation
> 5363.26
> -640.73
> +543.16
> =5265.69 Correct to the statement
>
> GnuCash is doing the opposite:
> 5363.26
> +640.73
> -543.16
> =5460.83
> Difference: ($195.14)
> This is why I am out of balance!
>
> Any ideas on how to correct this calculation error?
>
> BTW thank you a ton to everyone for helping with this horribly sticky
> problem.
>
>
>
>
>
> -
> China Blue
> --
> View this message in context: http://gnucash.1415818.n4.
> nabble.com/Reconciling-an-account-tp4691993p4692063.html
> Sent from the GnuCash - User mailing list archive at Nabble.com.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Website down?

[David Carlson]

Must have been intermittent.  I was there a couple of days ago too.

David C

On Jun 8, 2017 10:00 AM, "Maf. King"  wrote:

> ISTR that I was on it yesterday (or the day before.  Looking at the FAQ to
> point Edwin in the right direction).  of course, I may have found a cache
> but
> I don't think so.
>
> Maf.
>
>
> On Thursday, 8 June 2017 15:12:44 BST Derek Atkins wrote:
> > This thread is the first I've heard of this. I've contacted. Linas.
> > -derek
> >
> > >Has been down since early last week.
> > >
> > >
> > >Sent from my T-Mobile 4G LTE Device
> > > Original message From: aegross 
> > >Date: 6/8/17  7:21 AM  (GMT-06:00) To: gnucash-user@gnucash.org
> > >Subject: Re: Website down?
> > >Has been down for a number of days...
> > >
> > >Perhaps the wiki site would be of help?
> > >http://wiki.gnucash.org/wiki/GnuCash
> > >
> > >
> > >
> > >--
> > >View this message in context:
> > >http://gnucash.1415818.n4.nabble.com/Website-down-
> tp4692091p4692095.html
> > >Sent from the GnuCash - User mailing list archive at Nabble.com.
> > >___
> > >gnucash-user mailing list
> > >gnucash-user@gnucash.org
> > >https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > >-
> > >Please remember to CC this list on all your replies.
> > >You can do this by using Reply-To-List or Reply-All.
> > >___
> > >gnucash-user mailing list
> > >gnucash-user@gnucash.org
> > >https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > >-
> > >Please remember to CC this list on all your replies.
> > >You can do this by using Reply-To-List or Reply-All.
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
>
> --
> Maf. King
> PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7  2B7C E591 E8E1 0DE7 C542
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Reconciling an account

[David Carlson]

I often have duplicate entries appear in transfer accounts when I import
transactions resulting from imperfect matching during the import process.

While these are usually easy to find and fix, sometimes I make an error and
"fix" the wrong transaction or split.

If a previously reconciled transaction is deleted, that is one of several
ways the "starting" balance can change from the previous month end balance.


It is usually ok to just ignore the starting balance and see what falls out
when every transaction on the statement is matched to a Gnucash transaction.

David C

On Jun 5, 2017 12:26 PM, "EngineInstitute"  wrote:

> John,
>
> What baffles me is that I am balancing a credit card statement with little
> activity. It was reconciled correctly the prior month, so the starting
> balance for the following month is correct.
>
> In this case the initial reconcile box reflects a different balance, so I
> put in the new balance to reflect the statement. Usually if everything is
> in
> order that number agrees with the statement. In this case it does not (I
> thought this strange) so I corrected the number.
>
> I then took the normal steps and checked off the expenses (not many) and
> payments as well as the interest against the statement. Yet, there is no
> agreement.
>
> I double checked my work against the statement's payment amounts, purchase
> amounts and interest charged to make sure that these sums add up to what
> was
> in GnuCash. All agree yet the balance in GnuCash is off by hundreds of
> dollars. Since all of the prior months sums are balanced, my data is
> correct
> and there is no outstanding activity that might somehow affect the balance
> I
> cannot figure out what to look for and how to resolve this weird problem.
>
> Note I have been doing bookkeeping for many years so knowing how to
> reconcile a statement is not the problem. I am wondering if there is
> something that I don't understand with how GnuCash manages the data.
>
>
>
> -
> China Blue
> --
> View this message in context: http://gnucash.1415818.n4.
> nabble.com/Reconciling-an-account-tp4691993p4692041.html
> Sent from the GnuCash - User mailing list archive at Nabble.com.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Reconciling an account

[David Carlson]

Ok, the next thing to do is to go into your register view and look at the
running total next to each of the transactions that you show in your
images, to see if the value was correctly added or subtracted by GnuCash.
Also set the register view to Transaction Journal to see if there are any
suspicious splits.

There are some sneaky ways that GnuCash can keep some hidden values in
transactions.  In my case, they were all resulting from corrupted scheduled
transactions, and they usually resulted in an entry in the Imbalance
account.

David C

On Tue, Jun 6, 2017 at 5:16 PM, Mark Phillips 
wrote:

> Is your opening balance for this account correct?
>
> Mark
>
> On Tue, Jun 6, 2017 at 2:20 PM, EngineInstitute 
> wrote:
>
> > Yes I tried the manual way using the transaction report to check against
> > both
> > the Gnu reconciliation as well as the statement.  Nothing is obvious.
> > I also checked by applying the filter without the reconciled items and
> what
> > came up are the items in the to be reconciled in the reconcile register.
> > Finally I also did a global search for $195.14 and $97.57 no entries of
> > those amounts.
> > I thought I would upload images so it is easier to discuss.
> > As you can see the dialog shows what it expects as the final amount:
> > $5265.69 (my statement balance)
> > The next is the reconcile page that shows the reconciled balance with a
> > difference of $97.57 (there are no outstanding items past 3/11).
> > After reconciling the totals at the bottom of each white box (funds in
> and
> > funds out) agree with the statement.
> > So why the ($195.14) difference? I note that is double the difference of
> > $97.57 in the pre-reconciled sum.
> > I am sure it is something obvious but I can't for the life of me see it.
> > Dialog1.jpg  > Dialog1.jpg>
> > PreReconciled.jpg
> > 
> > Reconciled.jpg
> > 
> >
> >
> >
> >
> >
> >
> >
> > -
> > China Blue
> > --
> > View this message in context: http://gnucash.1415818.n4.
> > nabble.com/Reconciling-an-account-tp4691993p4692059.html
> > Sent from the GnuCash - User mailing list archive at Nabble.com.
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Notes column in SingleLine display

[David Carlson]

Well, if you read the manual you will find the answer to all your prayers,
or at ieast to all the "faults" that you have found so far with GnuCash.
Well, there is no way to replace the description with the notes other than
to put the text that you want to see in the Description field.  Isn't that
good enough?


David C

On Jun 18, 2017 10:32 AM, "azalea4va"  wrote:

I am new to GnuCash.  What was MOST noticable within minutes of my first use
was the glaring inefficient use of screen space.  Perhaps 1/3 of a register
listing is just empty in an overly wide "Description" column.  I personally
prefer to have the Notes field visible in the SingleLine display instead of
having to use a DoubleLine display (halving the number of transactions that
can be listed).  While I would love to see that as an official program
change (those that like things as they are could reduce a SingleLine "note"
column to minimal size), I doubt that will happen.  I have downloaded the
soure code and am wondering if anyone can provide some guidance in two
areas.

1. Hopefully adding the Notes column is a fairly straight-forward change,
ideally just requring a change to a single function (and maybe calls to that
function).  Any idea how complex such a change would be?

2. There is alot of code,  where would I focus my search efforts in finding
the code that must be chnaged?

Thank you.



--
View this message in context: http://gnucash.1415818.n4.
nabble.com/Notes-column-in-SingleLine-display-tp4692253.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Unrealized losses (or gains)

[David Carlson]

Alain

Follow this link.
http://gnucash.1415818.n4.nabble.com/Unrealized-losses-tc4691319.html#a4691532

David C

On Jun 18, 2017 1:41 PM, "Kalin KOZHUHAROV"  wrote:

Hello,

On Sun, Jun 18, 2017 at 6:45 PM, Alain Dormoy  wrote:
> My problem is I had in the past "Unrealized losses" (and gains) which turn
> up on given dates and vanish on other.
>
> You advised me to identify the dates and see what can have gone wrong
then.
>
> I found the dates. I ran a "Transaction report" for those two particumar
> dates.
>
> Does nothing for me: The unrealized gain is huge (roughly my total icome
for
> the year) but in the list of transactions on those two dates all that
comes
> up is a few petty amounts, maximum 100 EUR (I have selected "all accounts"
> including hidden).
>
> Ideas?
>
Just a wild guess, but try to "increase the border", see one day
before the actual problem and one after.

Kalin.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Transfer query.

[David Carlson]

To elaborate on Derek's explanation, all the 'Charges' in your credit card
(Liability) account should appear on the right side in the credit card
account, and on the left side in the various expense accounts if you 'jump'
to the expense accounts.

On Tue, Jun 13, 2017 at 11:44 AM, Derek Atkins  wrote:

> Hi
>
> On Tue, June 13, 2017 12:20 pm, Ken Tibbles wrote:
> > Hi,
> >
> >
> > I am trying to move from "MoneyMaker Ex" and use Gnucash for my home
> > accounts instead.
> >
> >
> > However, when trying to enter the payment of my credit card balance I
> > create a payment in my current accout (which shows as a withdrawl) with
> > the transfer to the credit account (an account under Liabilities) which
> > then shows as a  payment not a receipt.
>
> This is the correct behavior.  A payment to your CC should show up as a
> payment!
>
> >Therefore my credit card balance
> > has doubled not reduced to zero.
> >
> >
> > What am I doing wrong?
>
> It sounds like you're entering all your credit card transactions wrong, as
> payments as opposed to charges.
>
> > Regards
> >
> > Ken.
>
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Gnucash file is getting long!

[David Carlson]

I think that John Ogden has a valid question which should be covered better
somewhere in the manual.

The short answer, unfortunately, is that there is no way to split out old
data to shrink the data file.  Also, it is a fact that eventually your file
may grow to the point where it taxes your computers' resources in one way
or another, possibly hogging RAM  or loading and saving slowly.

It is not easy to design a routine to split a file because there are many
cases of reports that would fail to give accurate results for some users if
old data was removed.  The most obvious would be capital gains for sales of
stocks, but there are probably other things that could break.

Various other users have found ways to work around this shortcoming for
their individual use.  It would be nice to hear from some of them and to
include them in the help literature as well.

My solution so far has been to buy a more powerful computer and use
Ethernet instead of WiFi to attach to the data file.  Yes, a file save
through WiFi takes well over a minute for my data file which is now over
6MB compressed.


David C

On Wed, Jun 14, 2017 at 5:05 AM, Colin Law  wrote:

> What do you mean by 'quite large'? I have 15 years of (personal) data
> in mine and would not split it unless force to. It is great to be able
> to so easily look back to see when and where I bought the dishwasher
> (or whatever) and how much it cost. Mine is1.9 MBytes (compressed
> xml).
>
> Colin
>
> On 14 June 2017 at 10:45, JOHN OGDEN  wrote:
> > I have been using GnuCash for over four years, and the file is becoming
> quite large.I have searched the documentation but have failed to find any
> instructions for separating the GnuCash accounts file (for all accounts) so
> that I end up with two files, one for 'old' transactions and one for 'new'
> transactions. I assume this to be a standard 'end-of-accounting-period'
> action: where do I find it documented? John
> > Revd Dr John Ogden 0118 969 6319 07746 621447
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Reconciling an account

[David Carlson]

Wow, now we are getting some well detailed suggestions!

I will add a couple:  To quickly see if all previous transactions were
really reconciled, select View > Filter by .> Status > uncheck Reconciled.

If you don't have too many transactions with dates earlier than the bank
cleared them, your running balance should agree with the bank's running
balance, at least when there is a 'dry' spell.  If the difference
consistently goes back to the same value, that is a clue of the amount, ant
the first time you see that value would be the approximate date.

On Mon, Jun 5, 2017 at 3:56 PM, Colin Law  wrote:

> Have you possibly entered a transaction the wrong way round (debit
> instead of credit or vise versa)? Then not noticed this when you tick
> it off?
>
> A suggestion earlier may be a good one if you still cannot find where
> you are going wrong. Draw lines on your statement after every, say, 4
> entries. Then reconcile from the start to the first line by entering
> the balance from the statement at that time. If the first one
> reconciles ok then do the next, and so on till you find the error.
>
> Note that others suggesting that this may be due to changed earlier
> transactions and so on are wrong. If the starting balance on the
> statement agrees with the starting balance in the reconcile window
> then the error is to do with the transactions on the statement,
> nothing else.
>
> Colin
>
> On 5 June 2017 at 18:10, EngineInstitute  wrote:
> > John,
> >
> > What baffles me is that I am balancing a credit card statement with
> little
> > activity. It was reconciled correctly the prior month, so the starting
> > balance for the following month is correct.
> >
> > In this case the initial reconcile box reflects a different balance, so I
> > put in the new balance to reflect the statement. Usually if everything
> is in
> > order that number agrees with the statement. In this case it does not (I
> > thought this strange) so I corrected the number.
> >
> > I then took the normal steps and checked off the expenses (not many) and
> > payments as well as the interest against the statement. Yet, there is no
> > agreement.
> >
> > I double checked my work against the statement's payment amounts,
> purchase
> > amounts and interest charged to make sure that these sums add up to what
> was
> > in GnuCash. All agree yet the balance in GnuCash is off by hundreds of
> > dollars. Since all of the prior months sums are balanced, my data is
> correct
> > and there is no outstanding activity that might somehow affect the
> balance I
> > cannot figure out what to look for and how to resolve this weird problem.
> >
> > Note I have been doing bookkeeping for many years so knowing how to
> > reconcile a statement is not the problem. I am wondering if there is
> > something that I don't understand with how GnuCash manages the data.
> >
> >
> >
> > -
> > China Blue
> > --
> > View this message in context: http://gnucash.1415818.n4.
> nabble.com/Reconciling-an-account-tp4691993p4692041.html
> > Sent from the GnuCash - User mailing list archive at Nabble.com.
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: nomenclatural clarification - parts of a transaction

[David Carlson]

Good call David R,

Another point of possible confusion for even long-time users like me is
that the column titles will change as the curser moves around in the
transaction display, so the user must carefully note the current position
of the curser to correctly interpret the column title.

David C

On Thu, Sep 14, 2017 at 6:16 PM, David Reiser  wrote:

>
> > On Sep 14, 2017, at 12:00 PM, George Riner 
> wrote:
> >
> > I may not be clearly following the information about the names of the
> parts of a transaction.
> >
> > attached screen capture for reference.
> >
> > Are these the correct terms for the called-out parts of the split
> transaction?
> >
> > part "A" is the "Description"
> > part "B" is the "Memo"
> > parts "C" are each a "Note"
> >
> > followup question:
> >
> > If it is not a split transaction, is there no "Note" field at all?
> >
> > :George
> > Gnucash 2.6.17
> > Windows 10
> >
> >
> >
> > __
> _
>
> Not quite.
> B is the note (notes are associated with the whole transaction)
> C’s are memos (a memo is associated with a single split within a
> transaction)
>
> --
> Dave Reiser
> dbrei...@icloud.com
>
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [MAINT] Network Work on Code Sunday, Oct 1, 1-4pm EDT

[David Carlson]

Derek,

Did you try replacing the cable? Low hanging fruit...

David C

On Fri, Oct 6, 2017 at 8:39 AM, Derek Atkins <warl...@mit.edu> wrote:

> David Carlson <david.carlson@gmail.com> writes:
>
> > Derek,
> >
> > Is it possible to read event logs and determine that some pieces of
> equipment
> > are definitely not causing the problem?
>
> Well, if I unplug or otherwise disable the VM server then the problem
> goes away.  Similarly, if I shutdown two of the VMs (the two that
> generate the most traffic, by the way), the problem goes away.  I tried
> rebuilding one of the VMs and swapped over to that one (to test if,
> perhaps, the VM had been hacked)..  The problem did not go away.
>
> SO..  I have ordered a new network card for the server which should
> arrive tomorrow.  HOPEFULLY that will solve the problem.  We'll know soon.
>
> > David C
>
> -derek
>
> --
>Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>Member, MIT Student Information Processing Board  (SIPB)
>URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
>warl...@mit.eduPGP key available
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [MAINT] Network Work on Code Sunday, Oct 1, 1-4pm EDT

[David Carlson]

I didn't really need to ask, but Idid anyway.

David C

On Oct 6, 2017 9:47 AM, "Derek Atkins" <de...@ihtfp.com> wrote:

> Yes.  Replaced the cables.  Changed the ports on the switch..
> Only thing I haven't tried yet is replacing the network card.
>
> -derek
>
> On Fri, October 6, 2017 10:27 am, David Carlson wrote:
> > Derek,
> >
> > Did you try replacing the cable? Low hanging fruit...
> >
> > David C
> >
> > On Fri, Oct 6, 2017 at 8:39 AM, Derek Atkins <warl...@mit.edu> wrote:
> >
> >> David Carlson <david.carlson@gmail.com> writes:
> >>
> >> > Derek,
> >> >
> >> > Is it possible to read event logs and determine that some pieces of
> >> equipment
> >> > are definitely not causing the problem?
> >>
> >> Well, if I unplug or otherwise disable the VM server then the problem
> >> goes away.  Similarly, if I shutdown two of the VMs (the two that
> >> generate the most traffic, by the way), the problem goes away.  I tried
> >> rebuilding one of the VMs and swapped over to that one (to test if,
> >> perhaps, the VM had been hacked)..  The problem did not go away.
> >>
> >> SO..  I have ordered a new network card for the server which should
> >> arrive tomorrow.  HOPEFULLY that will solve the problem.  We'll know
> >> soon.
> >>
> >> > David C
> >>
> >> -derek
> >>
> >> --
> >>Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
> >>Member, MIT Student Information Processing Board  (SIPB)
> >>URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
> >>warl...@mit.eduPGP key available
> >>
> >
>
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: only deposits show

[David Carlson]

Frank,

Please reply to all so it goes to the list where others can see it and help.

It has been several years since I did my major import via QIF and now I
almost never use that format so I have lost track of the details of how
matching is accomplished in that importer.

It may be necessary to import accounts one at a time to allow the importer
to find the matching transactions from other accounts during the import
process.

Perhaps another user has more recent experience with QIF

David C

On Fri, Oct 6, 2017 at 3:28 PM, frank raney <frankraney...@gmail.com> wrote:

> I just realized all balances were twice what they should be except for the
> last account I imported..  I deleted the gc file and started
> over.EVERYTHING was twice the correct balance.
>
> I have come to realise, that when importing the quicken file, every think
> gets imported twice.  The catagories are imported as accounts and all my
> cash accounts get imported and imports the same categories.  It would take
> days to identify the duplicates and delete the correct ones.
>
> There has to be a way to import the quicken file without the duplicates or
> me going through EVERY account in GC?
>
>
> *Frankie Raney*
> *12454 Auberry Rd.
> <https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_=gmail=g>*
> *Clovis, Ca
> <https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_=gmail=g>.*
> *559.297.8577 <(559)%20297-8577> H*
> *559.304.1751 <(559)%20304-1751> C*
>
> On 10/4/2017 9:13:46 AM, frank raney <frankraney...@gmail.com> wrote:
>
> First, your assumptions are correct. that is what i did.
>
> just deleted the account from gnu, exported it again from quicken by
> itself, and re-imported it.  its fine now..my original file was huge. I
> didnt think that would matter...now I really have to compare an see if
> I need to redo any others.what is the largest file that can be imported
> accurately.
>
> *Frankie Raney*
> *12454 Auberry Rd.
> <https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_=gmail=g>*
> *Clovis, Ca
> <https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_=gmail=g>.*
> *559.297.8577 <(559)%20297-8577> H*
> *559.304.1751 <(559)%20304-1751> C*
>
> On 10/2/2017 10:11:19 PM, David Carlson <david.carlson@gmail.com>
> wrote:
> You do not mention important details that are needed to give a definitive
> answer, but assuming that you followed the a likely path, you exported
> transactions from your Quicken file in QIF format then imported them into
> GnuCash in the same format.
>
> The QIF format creates a data section for each account which includes
> transfers to or from whatever other accounts are used.  To get complete
> information you need a section for every asset and liability account in
> your file.  I would guess that you are missing some sections for some of
> your accounts.
>
> It happens that Quicken uses the term Category for account types Income
> and Expense, and there is no need to have QIF sections for Categories, but
> all Asset and Liability accounts need to be imported individually or in a
> combined file.
>
> If your Quicken file is large we usually recommend breaking down your QIF
> file into separate files for each account, and possibly for limited time
> intervals, such as Bank1_2016, Bank1_2015, etc.This helps to get better
> results with matching the two sides of transfers during the import and
> avoiding Imbalance entries.
>
> Good Luck.
>
> David C
>
>
>
> On Mon, Oct 2, 2017 at 5:22 PM, frank raney <frankraney...@gmail.com>
> wrote:
>
>> Just installed  and imported a quicken file.  after import, one of my
>> checking accounts on;y shows deposits made from another checking account.
>> It does not show checks od debits.
>>
>> Any idea why
>>
>>
>> Frankie Raney
>> 12454 Auberry Rd.
>> <https://maps.google.com/?q=12454+Auberry+Rd.+%0D+Clovis,+Ca=gmail=g>
>> Clovis, Ca.
>> 559.297.8577 H
>> 559.304.1751 C
>>
>> ---
>> This email has been checked for viruses by Avast antivirus software.
>> https://www.avast.com/antivirus
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>
>
>
>
> <https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient_term=icon>
>  Virus-free.
> www.avast.com
> <https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient_term=link>
> <#m_3489956349136510886_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: importing

[David Carlson]

Frank and David T,

I believe that the QIF importer may not work exactly the same way that it
did back in the 2.2 series or the 2.4 series  or even the 2.6 series before
release 2.6.18.

If that is the c as e  then we really do need someone who is familiar with
the way it works now to jump in and help.

David C

On Oct 7, 2017 3:18 PM, "frank raney"  wrote:

I did import all at once..don't know yet how to export individual
accounts from Quicken..


Frankie Raney

On 10/7/2017 7:46:05 AM, David T.  wrote:
Frank,

The *other* David suggested importing each account separately; I was
suggesting importing all at once. In my (admittedly ancient) experience, I
worked to get the Quicken data just so, and when I imported everything, I
had little to no duplicates.

David (T.)

On Oct 7, 2017, at 7:17 PM, Frankie Raney  wrote:

You are right as to what is being done When I import, it sees the
duplicates, but there are hundredsit would take forever to Mark
themI do not know how to export just one account at a timeI could
try to figure it out and try that way I guess.

On Oct 6, 2017 8:34 PM, "D" 
wrote:

Frank,
Like the other David, on the other thread, it has been a while since I
imported from Quicken. When I did, I was able to bring in everything in one
huge pass. Gnucash properly created the many accounts and captured most of
the transfers as well.
Are you exporting each account from Quicken separately? It sounds as if you
are getting both sides of your transactions, i.e., the transfer payment
from checking to your credit card is being processed once for the checking
and once for the credit card. If this is what is happening for you, then
there are two solutions: either match the second version to the first
during the import process, or don't import the second transaction.
I seem to recall that I didn't have to do much manual massage to my large
quicken file when I imported way back when, so I believe that exporting the
whole file (accounts, categories and transactions for it all) will catch
those duplications. But I've been known to be wrong before.
David T.
On October 7, 2017, at 6:24 AM, frank raney  wrote:
>I thought I had the importing figured out, but no...
>I exported my quicken data to qif format.  When I import it into GC I get
a lot of double entries.  Quicken uses catagories, GC uses accounts... How
do I import my cash accounts without getting all the duplicates.
>My checking account imports as do all my categories to the same accounts
in GC.  I am given a list of possible duplicates, but it will take days to
go through this.  Isn't there a way import without sorting through the
list?  If I do not go through the list (just import everything as is, I end
up with every account with double entries, double money.
>I am trying to get away from quicken because of all the troubles they are
having, but now I wonder if it is worth it.  I am always for programs like
GC, but sometimes they are very cumbersome, like this appears to be.  What
am I missing?
>Frankie Raney
>12454 Auberry Rd. [https://maps.google.com/?q=12454+Auberry+Rd.+%3EClovis,+
Caentry=gmailsource=g]
[https://maps.google.com/?q=12454+Auberry+Rd.+%3EClovis,+
Caentry=gmailsource=g]>Clovis, Ca [https://maps.google.com/?q=
12454+Auberry+Rd.+%3EClovis,+Caentry=gmailsource=g].
>559.297.8577 [tel:(559)%20297-8577] H
>559.304.1751 [tel:(559)%20304-1751] C
>---
>This email has been checked for viruses by Avast antivirus software.
>https://www.avast.com/antivirus [https://www.avast.com/antivirus]
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org [mailto:gnucash-user@gnucash.org]
>https://lists.gnucash.org/mailman/listinfo/gnucash-user [
https://lists.gnucash.org/mailman/listinfo/gnucash-user]
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: importing

[David Carlson]

Frank,

I did not mean to imply that it worked better then, but it may have worked
differently in older releases.  In any case, if you went that far back,
there are some file compatibility issues to be concerned with.  I do recall
being irritated with the fact that the QIF importer failed to import memos
in split transactions, and I think that has been fixed.

The main thing is that neither David T nor I recall having a significant
problem avoiding the potential duplicate transactions that could arise if
the user does not know the best procedure (as you have seen).

David C

On Sat, Oct 7, 2017 at 6:55 PM, frank raney <frankraney...@gmail.com> wrote:

>
>
> *Frankie Raney*
> *If it worked good in 2.2, then maybe I can get that version, try it and
> if it works good, then upgrade.*
>
> On 10/7/2017 4:45:51 PM, David Carlson <david.carlson@gmail.com>
> wrote:
> Frank and David T,
>
> I believe that the QIF importer may not work exactly the same way that it
> did back in the 2.2 series or the 2.4 series  or even the 2.6 series before
> release 2.6.18.
>
> If that is the c as e  then we really do need someone who is familiar
> with the way it works now to jump in and help.
>
> David C
>
> On Oct 7, 2017 3:18 PM, "frank raney" <frankraney...@gmail.com> wrote:
>
> I did import all at once..don't know yet how to export individual
> accounts from Quicken..
>
>
> Frankie Raney
>
> On 10/7/2017 7:46:05 AM, David T. <sunfis...@yahoo.com> wrote:
> Frank,
>
> The *other* David suggested importing each account separately; I was
> suggesting importing all at once. In my (admittedly ancient) experience, I
> worked to get the Quicken data just so, and when I imported everything, I
> had little to no duplicates.
>
> David (T.)
>
> On Oct 7, 2017, at 7:17 PM, Frankie Raney <frankraney...@gmail.com
> [mailto:frankraney...@gmail.com]> wrote:
>
> You are right as to what is being done When I import, it sees the
> duplicates, but there are hundredsit would take forever to Mark
> themI do not know how to export just one account at a timeI could
> try to figure it out and try that way I guess.
>
> On Oct 6, 2017 8:34 PM, "D" <sunfis...@yahoo.com [mailto:
> sunfis...@yahoo.com]> wrote:
>
> Frank,
> Like the other David, on the other thread, it has been a while since I
> imported from Quicken. When I did, I was able to bring in everything in one
> huge pass. Gnucash properly created the many accounts and captured most of
> the transfers as well.
> Are you exporting each account from Quicken separately? It sounds as if
> you are getting both sides of your transactions, i.e., the transfer payment
> from checking to your credit card is being processed once for the checking
> and once for the credit card. If this is what is happening for you, then
> there are two solutions: either match the second version to the first
> during the import process, or don't import the second transaction.
> I seem to recall that I didn't have to do much manual massage to my large
> quicken file when I imported way back when, so I believe that exporting the
> whole file (accounts, categories and transactions for it all) will catch
> those duplications. But I've been known to be wrong before.
> David T.
> On October 7, 2017, at 6:24 AM, frank raney <frankraney...@gmail.com
> [mailto:frankraney...@gmail.com]> wrote:
> >I thought I had the importing figured out, but no...
> >I exported my quicken data to qif format.  When I import it into GC I get
> a lot of double entries.  Quicken uses catagories, GC uses accounts... How
> do I import my cash accounts without getting all the duplicates.
> >My checking account imports as do all my categories to the same accounts
> in GC.  I am given a list of possible duplicates, but it will take days to
> go through this.  Isn't there a way import without sorting through the
> list?  If I do not go through the list (just import everything as is, I end
> up with every account with double entries, double money.
> >I am trying to get away from quicken because of all the troubles they are
> having, but now I wonder if it is worth it.  I am always for programs like
> GC, but sometimes they are very cumbersome, like this appears to be.  What
> am I missing?
> >Frankie Raney
> >12454 Auberry Rd
> <https://maps.google.com/?q=12454+Auberry+Rd=gmail=g>. [
> https://maps.google.com/?q=12454+Auberry+Rd.+%3EClovis,+Ca;
> amp;entry=gmailsource=g]
> [https://maps.google.com/?q=12454+Auberry+Rd.+%3EClovis,+Ca;
> amp;entry=gmailsource=g]>Clovis, Ca [https://maps.google.com/?q=12
> 454+Auberry+Rd.+%3EClovis,+Caentry=gmailsource=g].
> >559.297.8577 [tel:(55

Re: only deposits show

[David Carlson]

You do not mention important details that are needed to give a definitive
answer, but assuming that you followed the a likely path, you exported
transactions from your Quicken file in QIF format then imported them into
GnuCash in the same format.

The QIF format creates a data section for each account which includes
transfers to or from whatever other accounts are used.  To get complete
information you need a section for every asset and liability account in
your file.  I would guess that you are missing some sections for some of
your accounts.

It happens that Quicken uses the term Category for account types Income and
Expense, and there is no need to have QIF sections for Categories, but all
Asset and Liability accounts need to be imported individually or in a
combined file.

If your Quicken file is large we usually recommend breaking down your QIF
file into separate files for each account, and possibly for limited time
intervals, such as Bank1_2016, Bank1_2015, etc.This helps to get better
results with matching the two sides of transfers during the import and
avoiding Imbalance entries.

Good Luck.

David C



On Mon, Oct 2, 2017 at 5:22 PM, frank raney  wrote:

> Just installed  and imported a quicken file.  after import, one of my
> checking accounts on;y shows deposits made from another checking account.
> It does not show checks od debits.
>
> Any idea why
>
>
> Frankie Raney
> 12454 Auberry Rd.
> Clovis, Ca.
> 559.297.8577 H
> 559.304.1751 C
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: simple find transactions report

[David Carlson]

Geert,

I should be sorry for exposing you and others to my rant about Google, but
it was the third time in a week that their software did something
unexpected that was not making me happy.


David C

On Oct 10, 2017 10:26 AM, "Geert Janssens" <geert.gnuc...@kobaltwit.be>
wrote:

> Heh, sorry. I'm not near a computer to verify my directions and won't be
> until next week...
>
> Glad you managed to decode my terse answer.
>
> Geert
>
> Elmar <etsc...@gmail.com> schreef op 9 oktober 2017 21:37:57 GMT+01:00:
> >Perfect!  Thanks, although I had to translate this to the menu entry
> >"edit/find" (not "search")
> >
> >- elmar
> >
> >On 10/09/2017 04:16 PM, David Carlson wrote:
> >> Geert,
> >>
> >> Gmail used those ing triple dots to hide your reply in my mail
> >> folder.  Lucky for me I suspected as much when there appeared to be
> >no
> >> reply .
> >>
> >> David C
> >>
> >>
> >> On Mon, Oct 9, 2017 at 2:48 PM, Geert Janssens
> >> <geert.gnuc...@kobaltwit.be <mailto:geert.gnuc...@kobaltwit.be>>
> >wrote:
> >>
> >> Start with a search from the account hierarchy page and then open
> >> an account report on the search results tab.
> >>
> >> Regards,
> >> Geert
> >>
> >> Elmar <etsc...@gmail.com <mailto:etsc...@gmail.com>> schreef op 9
> >> oktober 2017 20:35:06 GMT+01:00:
> >> >Good afternoon to the list
> >> >
> >> >I seem to be having a brain fart.  I am trying to retrieve all
> >the
> >> >transactions (all dates) with a certain payee in the description
> >> field,
> >> >
> >> >and only those transactions.  Somehow I cannot make the
> >transaction
> >> >report do this - what am I missing?  It should be easy, which
> >> tells me
> >> >I'm at fault.
> >> >
> >> >- Elmar
> >> >
> >> >
> >> >___
> >> >gnucash-user mailing list
> >> >gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
> >> >https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
> >> >-
> >> >Please remember to CC this list on all your replies.
> >> >You can do this by using Reply-To-List or Reply-All.
> >>
> >> Sent from my smartphone. Please excuse my brevity.
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
> >> -
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> >>
> >>
> >
> >___
> >gnucash-user mailing list
> >gnucash-user@gnucash.org
> >https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >-
> >Please remember to CC this list on all your replies.
> >You can do this by using Reply-To-List or Reply-All.
>
> --
> Verzonden van mijn Android telefoon met K-9 Mail.
> Sent from my smartphone. Please excuse my brevity.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: command line QIF import

[David Carlson]

Not sure about more efficient ways to import via QIF, which, by the way, is
reasonably efficient when done in small chunks,  but another caveat that
has not been raised recently is that as the data file grows it takes longer
to do the frequent file saves.

In Windows each save for my data file takes the file out of service for
over a minute with a very fast computer.  In Linux it is still 15 or 20
seconds.  I have about 10 years' data in my main file.

David C

On Sun, Oct 15, 2017 at 12:14 PM, Nelson  wrote:

> Hi everyone,
>
> I am trying to import about 20 years of Quicken transactions into GnuCash
> going trough a Quicken QIF export. As many people reported, this is a very
> painful process and requires endless manual corrections.
>
> I was wondering if it would be possible to maybe to do the import from
> command line, and maybe to have more control of the process. Doing it from
> gui, there are no options to modify / adjust the process and all warnings /
> progress messages just disappear from the screen. Also, any entity
> remapping
> is not kept from one test to another and it seems that no useful logs are
> being created.
>
> I am running this on windows and I've noticed 83 .exe files in GnuCash's
> bin
> directory. Is any of these binaries capable to do an QIF import, maybe with
> more options than the gui does and proper logging?
>
> TIA.
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: command line QIF import

[David Carlson]

I am not a developer, but I can point out that the QIF importer works in
several discrete steps where (roughly) it

1. identifies the 'source' account type and name and tries to associate it
to an existing account in the data file.  If there is more than one
'source' account in the QIF file it repeats for each.

2.  It presents it's results to the user for verification and (if
necessary) correction.

3.  Identifies all of the 'destination' accounts or categories and tries to
match them to existing accounts.

4.  It presents it's results to the user for verification and (if
necessary) correction.

5.  It parses each transaction and compares it to existing transactions
between the particular accounts previously identified.

6. It prepares lists of incoming transactions with suggested matches to
existing transactions where found.  These lists allow user editing to
accept or correct suggested matches.  This is where it is more efficient to
import only one account at a time so the 'duplicates' can be found here.

There are many checks during the import to test the text at each step and
prevent possible crashes and gross errors during matching and acceptance.

As an experienced user I would actually prefer that the developers stay out
of this discussion as they are very busy working 'under the hood' right now
toward getting the release 2.8 series into shape.  That release should get
rid of the deprecated software that is now threatening the continued
inclusion of GnuCash in (and compatibility with) upcoming Linux packages.

David C

On Sun, Oct 15, 2017 at 6:05 PM, Adam Jensen  wrote:

> On 10/15/2017 04:49 PM, Nelson wrote:
> > Thank you for your answer David.
> >
> > I am aware that QIF is a text file and I can open it in text editor.
> >
> > I have a 235000 lines QIF file created by quicken. Most of the
> transactions
> > are being imported properly but there are thousands failing as well. I
> have
> > no way to identify those failed transactions other than going line by
> line
> > in each account. What shall I "edit in quicken first" to insure a
> successful
> > import?
>
> Hi. I am very new to the list [1] and *very* new to GnuCash [2].
>
> Strangely, Nelson, I might get what you are asking far more than the
> other respondents seem to. I hope you can endure this problem, at least
> while it is being explored and discussed; rational, pragmatic people are
> vital to technical projects. ...Sometimes volunteer-based communities
> get a little cult-like in their public interface...
>
> So, I am a mature engineer [3] with some experience in
> instrumentation-sourced data wrangling (as part of large data
> organization and analysis systems); maybe I can try to steer the topic
> of file conversion/import towards the "hackers" on the list - and those
> otherwise interested in engaging such a conversation. To that end, could
> some of the software developers and maintainers chime into a technical
> discussion of the data structure issues involved in building a
> translation utility? It might be fruitful if not at least interesting :)
>
> Anyway, a belated Greetings and Salutations to you all :)
>
>
> [1]: Subscribed for about two days.
> [2]: I've only just started the semi-serious exploration, assessment and
> evaulation of the GnuCash software (and its representation of the
> historical bookkeeping/accounting processes and their
> traditional/societal basis) about three days ago - installation and one
> launch of the application on Ubuntu, one chapter of the Guide read and
> the introductory chapter of a financial Accounting book mused at.
> [3]: LinkedIn, Google::hanzer
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: command line QIF import

[David Carlson]

Nelson,

It sounds to me like you are unwilling make the effort to "shepherd" your
data through the import process.  Many of us, including David T are trying
to tell you that we have succeeded in completing massive imports from
Quicken into GnuCash, but we needed to take several steps to plan our
procedure, prepare the data, preprocess data and postprocess data to do
it.

Each case will vary because each of us took different shortcuts and entered
data from different financial institutions, etc. when using Quicken.  We
also have different ideas about what details are most important to preserve
vs what is "noise"

David C

On Mon, Oct 16, 2017 at 7:55 AM, Nelson  wrote:

> There are multiple classes of failures and most of them seems to be
> transfers
> related. There are the ones a which show up more often:
>
> - missing transactions
> - duplicate transactions
> - voided transactions (transaction exist but flagged as "void" and has zero
> amount)
> - transactions in wrong account (transfer from account.A to account.B
> recorded as debit account.A and credit account.C)
>
> I totally understand QIF format limitations. When I do a transfer from
> account.A to account.B, and I download the transactions from the bank in
> Quicken, account.B trx. will show up in one day while account.B will show
> up
> couple days later, maybe 2 to 5 days. While Quicken will match these
> properly, GnuCash will create duplicates most-likely, because in the
> exported QIF file  there are two different transactions,  one for account.A
> and one for account.B.
>
> That's why I am saying that having some flags to tuneup the import process
> and detailed logging would help a lot.
>
>
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Account report error for transactions the last 30 days

[David Carlson]

I think that what you both are seeing is, in fact, as you have correctly
asserted, Garbage In Garbage Out.

Normally there are no running totals in search register views because they
are an accumulation of transactions over an indeterminate sub set of the
entire data set.  Then a report derived from that set would also be
indeterminate.  I am surprised that GnuCash even allows the account report
to be run in the search results window.

David C

On Fri, Oct 13, 2017 at 12:39 PM, Tom B  wrote:

> Hi Maf,
> Well unfortunately the problem seems to have resolved itself.  As of this
> morning the same search results account report appears to be correct.  I
> have no clue as to why it is now different than first reported.  It was
> consistently wrong for a couple of weeks.
>
> I did initially attempt to correct the issue by selecting "menu > action >
> check & repair > check & repair all" which did not affect the results.  I
> even did a complete remove and reinstall of the pkg with no change.
>
> At this point it is behaving as expected.  Sorry for the distraction.
>
> Regards,
> Tom
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Migrate from Moneydance to Gnucash

[David Carlson]

I think it is about the same as from Quicken,  but perhaps easier because
Moneydance is closer to being double entry.

If they still have QIF exports ...


David C

On Oct 16, 2017 8:51 AM, "Roger Miskowicz"  wrote:

> Is there a recommended procedure for migrating Moneydance to GnuCash?
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Scheduled transactions

[David Carlson]

Please reply to all.

Read the section of the help manual about scheduled transactions.
Then click on Actions>Scheduled Transactions>Scheduled Transaction Editor.

David C

On Mon, Sep 25, 2017 at 3:48 PM, Roger Oliver <rmom...@gmail.com> wrote:

> I'm sorry, I don't see the template tab. Thanks
>
> On Sep 25, 2017 2:04 PM, "David Carlson" <david.carlson@gmail.com>
> wrote:
>
>> On the Template tab it is in the upper left as in the register view.
>>
>> David C
>>
>> On Mon, Sep 25, 2017 at 12:23 PM, <rmom...@gmail.com> wrote:
>>
>>> Think I’ll just have to adapt to what the program can do. Where is the
>>> Num Field you are referring to? I don’t see it in Schedule Transactions.
>>> Thanks
>>>
>>>
>>>
>>> *From:* David Carlson [mailto:david.carlson@gmail.com]
>>> *Sent:* Monday, September 25, 2017 11:39 AM
>>> *To:* Matthew Pounsett <m...@conundrum.com>
>>> *Cc:* rmom...@gmail.com; Gnucash Users <gnucash-user@gnucash.org>
>>> *Subject:* Re: Scheduled transactions
>>>
>>>
>>>
>>> I use Remind in Advance for that purpose, but it is somewhat clumsy
>>> too.  I put the word Sched in the Num field to remind me that the
>>> transaction has not really happened yet.
>>>
>>> David C
>>>
>>>
>>>
>>> On Mon, Sep 25, 2017 at 10:12 AM, Matthew Pounsett <m...@conundrum.com>
>>> wrote:
>>>
>>> On 25 September 2017 at 10:57, <rmom...@gmail.com> wrote:
>>>
>>> > Is there a way to tell GnuCash to process a scheduled transaction early
>>> > other than to chance the date of each transaction? Some months I would
>>> like
>>> > to do my monthly accounting earlier than the first of the month. Only
>>> way I
>>> > have found to do that is to change the dates of the scheduled
>>> transactions
>>> > or the number of days to create in advance. That is a one-by-one
>>> operation.
>>> > I'm looking for a way to tell GnuCash to go ahead and process all of
>>> the
>>> > scheduled transactions early.
>>> >
>>> > I don't think there's a way to do precisely what you're asking.  My
>>> suggestion would be to tell GnuCash to Create in Advance by a week or so.
>>> Then, for CC payments for example, if you make them a few days early just
>>> change the date of the transaction that GC creates.  I do this myself for
>>> regularly occurring transactions that don't have predictable dates.  For
>>> example, my Internet Service Provider for some reason doesn't bill on
>>> exactly the same date every month, and it can be +/-5 days from the
>>> average.
>>>
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>>
>>>
>>>
>>
>>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Merging imported transactions

[David Carlson]

The OFX import assistant includes a step to match newly imported
transactions to existing transactions, as you probably noticed.

The problem is that it is error prone and has to be monitored carefully
during the import process.  I prefer to import a small number of
transactions at a time so that I am less likely to be overwhelmed.

The program is supposed to learn from previous imports and improve it's
accuracy eventually, but in my experience it still seems to make a lot of
mis-matches.  I still end up with duplicates when it fails to find the
correct match or I just get tired of searching and just let the duplicates
through.  I am less likely to miss a transaction if I use the import
assistant, so I continue to use it.

David C

On Mon, Sep 25, 2017 at 11:00 AM, Warner Losh  wrote:

> Greetings,
>
> I download all my transactions from my back in quickbooks OFX format. I
> import them into gnu cash. This works well; however, I’ve hit a snag.
>
> I have a credit card, a paypal account and a bank account. These all have
> different formats for downloading the data from, which I can convert to
> something gnu cash can import. When I do this, though, I have a small
> problem. The bank account comes in via OFX, so has lots of Imbalance-USD
> entries. I’ve used this account for the import of some items from the
> credit card and paypal accounts as well. So I wind up with a transaction in
> the bank ledger that is a payment to the credit card, but doesn’t credit
> that account. There’s also a separate transaction in the credit card that’s
> a payment from the bank, but doesn’t debit the bank account. In a sense,
> there’s two double entries I’d like to combine to eliminate the
> Imbalance-USD account entirely since I don’t think that’s a real account
> and find it sloppy book keeping. Is there anything I can use to merge
> entries when I’m replying on downloading the bulk of the data rather than
> entering it myself?
>
> Thanks for any help you can give me here.
>
> Warner
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: What's the best way to model an electronic funds transfer pull with hold

[David Carlson]

Nelson,

Just one comment from another user;
My banks do not show holds online, or if they do, it is a simple summary of
book balance vs available balance.  They warn that ACH transfers these-days
often clear on the same day.
To me, it is too much effort to try to track that, and as others have
mentioned, GnuCash does not track those details unless you manually set up
mechanisms in your chart of accounts and scheduled transactions, etc.

David C

On Sun, Oct 1, 2017 at 12:00 PM, John Ralls  wrote:

>
>
> > On Oct 1, 2017, at 9:49 AM, Nelson  wrote:
> >
> > Hi John,
> >
> > What I am doing today is exactly you are saying. I have a "pending"
> account
> > and I would record two transfers:
> >
> > - $1 bank-a -> pending
> > - $1 pending -> bank-b postdated by 5 business days.
> >
> > What bothers me with this approach is that when I go online on bank-a I
> see
> > a different balance than I have in GC.
> >
>
> You could record the transfer to the suspense account 2 business days in
> the future so that you’re aware of the obligation but today’s balance still
> matches.
>
> IMO it’s better to just accept that trying to match your books to the
> bank’s day-to-day is a fools errand and to recognize transactions in your
> books when you initiate them… and maybe reflect on why you’re maintaining
> 10 bank accounts and tying up money for days at a time by shifting it among
> the accounts.
>
> Regards,
> John Ralls
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [MAINT] Network Work on Code Sunday, Oct 1, 1-4pm EDT

[David Carlson]

That might be difficult, as it may be a loose connector or even corrosion
inside a cable or connector or component in a power supply or ???

Good luck.

David C

On Oct 2, 2017 10:42 AM, "Derek Atkins"  wrote:

> Hi,
>
> Just a quick follow-up.
>
> AT did come, and with their help we debugged the network only to
> discover that it's something inside my network that is causing their
> modem to go all futzy.
>
> I'm now in the process of trying to debug further, but it's going to
> take time.  Expect further interuptions until I can isolate the issue.
>
> -derek
>
> Derek Atkins  writes:
>
> > Hi,
> >
> > tl;dr:  AT is coming to fix some network issues tomorrow, Sunday,
> > between 1-4pm EDT; service can last up to 2 hours and may involve
> > several network outages.
> >
> > LONG VERSION:
> >
> > As some of you may have noticed, there have been some network issues to
> > code which started just over a week ago.  One of the downsides was
> > significant packet loss and gncbot disappearing from IRC.  Alas, I had
> > been out of the country while this was happening and couldn't start to
> > really look into it; I restarted gncbot several times while I was away
> > but due to the persistent network issues it regularly would lost
> > contact.
> >
> > I'm seeing anywhere from 20-40% packet loss and ping times to my
> > immediate router anywhere from 200-1000ms (whereas it's usually 3-4ms).
> > I called AT, my ISP, and they are sending a tech tomorrow, Sunday,
> > October 1, between 1-4pm EDT.  The maintenance could potentially take 2
> > hours once they arrive, but of course it all depends on what the issue
> > is.
> >
> > This will affect code, lists, and wiki services including email, gncbot,
> > etc.
> >
> > I'll attempt to keep people informed over IRC, assuming of course that I
> > can get online prior to the work being done.
> >
> > Please let me know if you have any questions.
> >
> > -derek
>
> --
>Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>Member, MIT Student Information Processing Board  (SIPB)
>URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
>warl...@mit.eduPGP key available
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: What's the best way to model "in-flight" transactions?

[David Carlson]

I think the answer is "What works best for you."

When most of our bank account transactions were checks (cheques in many
countries) we entered each check by date and number in the checkbook
register.  When the bank statement came we compared it to our register,
checking off each one that appeared on the statement.  Then we made a list
of the checks (and deposits) that did not match the bank statement, added
them up and compared sum of those and the statement balance to our
checkbook register balance.  Since we did it all by hand, there were months
when we would tear our hair out trying to find out why they did not agree.

I personally use a pair of special accounts that I call Checking A-R and
Checking A-P to hold items that are in float, but I only use them when I
want to account for float, say, over the transition from month to month, or
when there is an unusual issue with a missing check or whatever as each
transaction gets entered twice.

I only consider doing this for bank accounts, credit card accounts, and
sometimes for medical bills if I am trying to track what I owe there.

David C

On Thu, Sep 28, 2017 at 7:39 AM, replicon  wrote:

> Hey all,
>
> I've been using/loving GNUCash for almost a year now, and one thing I'm
> sure
> I'm doing wrong is how I'm showing credit card payments.
>
> For paying credit card bills, I just use my bank's bill pay. The bank is
> different from the credit card provider, so there's some "in-flight" time
> for that money. The day the withdrawal shows up on my checking account is
> not the same as the day the payment shows up when I login to my credit card
> provider and check transactions there.
>
> Right now, in GNUCash, I just do a transaction from checking account to
> credit card, and by convention, always adjust the time to reflect checking
> account, but I wonder if there's a more correct way to do it.
>
> The best I can think of is to have a separate account for "in-flight"
> transactions between establishments, and turn the credit card payment into
> two transactions that go through this account. Is that the best way to do
> it? If so, what account type would that be? Would it be an asset, because
> in
> a way, it's like I'm loaning money to some imaginary entity for a while,
> which it will repay to my other account a day or two later? :)
>
> Thanks!
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [MAINT] Network Work on Code Sunday, Oct 1, 1-4pm EDT

[David Carlson]

Derek,

Is it possible to read event logs and determine that some pieces of
equipment are definitely not causing the problem?

David C

On Oct 3, 2017 10:04 AM, "Derek Atkins"  wrote:

> GWB  writes:
>
> > So AT's network equipment works when nothing is connected to it?
> > Clearly this is a success story.  If the tech had been allowed to try
> > the new modem, that would have greatly sped up the troubleshooting
> > process.  If it had worked as before, then problem solved.  If not,
> > then you could debug your network topography on your side.
>
> Well, it works when I'm just connected with a laptop.  That proves (to
> them) that it's not their equipment.  It could be my equipment.  It
> could be a bad interaction between..  It's very hard to say.
>
> > That's actually more frustrating than I thought.  Maybe another phone
> > call to ask them to just please try a different modem before you spend
> > all that time chasing a problem that might not exist.
>
> The problem is my static IPs.  I can't just replace the modem.  And I
> can't just "take a random IP address" because it requires coordination
> to also migrate my tunnels, which is how code.gnucash.org gets its IP
> address.
>
> > I have managed to keep the static (fixed) IP I have, but not without a
> > struggle.  The solution is sometimes just having a "dumb" modem
> > connected to the LAN with the switching equipment at the telecomm set
> > to assign a fixed IP.  Sometimes I have to lease a fixed IP from a
> > different provider who then contracts with a local telecomm.  In any
> > event, it's worth it, and necessary.
>
> I have a /29 from them.
>
> > Check around.  Anywhere from Cambridge to Dedham should be any number
> > of telecomm trunk leasing outfits.
>
> Alas, Cambridge is about 1000 miles from here.  While I DID live in
> Somerville for ~14 years, I'm now much further south ;)
>
> > Gordon
>
> -derek
>
> PS: There is still a SMALL chance that it's not my VM system..  I'm
> considering taking it offline again this afternoon to test it again.
> --
>Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>Member, MIT Student Information Processing Board  (SIPB)
>URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
>warl...@mit.eduPGP key available
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Budget Slowing Down Windows 10

[David Carlson]

In W7 or W10 right click in the task bar and select Task Manager.  Then
select Resource Monitor to look at details.

David C

On Fri, Aug 25, 2017 at 1:39 AM, Colin Law <clan...@gmail.com> wrote:

> The point about memory is a good one @proberts042 I assume that
> Windows has a system monitor tool of some sort that you can run to see
> how much memory is being used. Try running that and then the report
> and see if you are running out of RAM
>
> Colin
>
> On 24 August 2017 at 22:59, David Carlson <david.carlson@gmail.com>
> wrote:
> > It is well known that GnuCash tends to run slowly when running some
> > reports, and particularly when working on larger data files containing
> > years of data.  However, it is very unusual to run so slowly that the OS
> > complains that it is not responding.  Some users (myself included) notice
> > that it could take more than a minute to start the program or to run some
> > reports with large files.
> >
> > If you have issues with Firefox or other memory intensive programs also
> > causing problems, you probably need to add RAM or get a more powerful
> > computer.
> >
> > Those are two common scenarios, but there are other cases where GnuCash
> may
> > sometimes run slowly without actually having triggered a bug.
> >
> > David C
> >
> > On Thu, Aug 24, 2017 at 4:03 PM, Proberts042 <probert...@gmail.com>
> wrote:
> >
> >> Version 2.6.17
> >>
> >>
> >>
> >> --
> >> View this message in context: http://gnucash.1415818.n4.
> >> nabble.com/Budget-Slowing-Down-Windows-10-tp4693398p4693414.html
> >> Sent from the GnuCash - User mailing list archive at Nabble.com.
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> -
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> >>
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Tax Tables - an illustrated primer?

[David Carlson]

In the United States "Sales Tax" is a generic term for taxes that are
collected at the point-of-sale and usually turned over to a state, city,
county or other government agency by retailers.

It is even difficult to make a concise and grammatically correct statement
to describe the process.

I live near Cook County Illinois in the Chicago area where the county
decided recently to tax all sweetened beverages by the ounce, as you
probably read in the Internet.  For that tax, it is calculated in a silly
way  and it is only supposed to be collected by retailers selling at
certain business addresses, but perhaps not across the street.

On the other hand, automobile sales taxes are determined by the buyer's
residence address and must be collected by automobile retailers when
completing a sale along with a lot of other paperwork, that cannot be
completed on Sunday when all car dealers cannot sell cars.  However, if a
car is purchased in a private sale, a different, but equally daunting set
of rules apply.

That is why business lawyers and accountants are very busy around here, and
any business that is too big to do all the calculations manually uses some
sort of point-of-sale software to handle the collection process.  It would
be overwhelming for even a very small retail business to try to use GnuCash
for that.

That is my two cents.

David C

On Sun, Sep 3, 2017 at 3:40 AM, Geert Janssens 
wrote:

> On zondag 3 september 2017 06:29:48 CEST Christopher Lam wrote:
> > Hi Users & Devs,
> >
> > I'd like to gather data on how Business > Tax Tables are currently being
> > used by users. Tutorial is rather blank on this; says "set up your tax
> > tables", "choose name, entries and percentage or amount", and in doubt,
> > seek an accountant who usually doesn't use gnc.
> >
> > From my understanding, Tax Tables are mainly used to *automatically*
> > calculate various county and state taxes as applied to business invoices
> > and bills... but it's rather confusing that:
> > - menu is labelled 'Sales Tax Tables' but the tables are designed for
> both
> > sales & purchase taxes
>
> True. I have wondered about this also. I assume "Sales Tax" is a standard
> term
> in American English ? It helps to consider that the difference between an
> invoice or a bill is only from which side of the transaction you look at
> it.
> The bill you receive from your vendor is an invoice from their point of
> view.
> Strictly speaking they are all invoices, but the name bill was adopted in
> gnucash to make the differentiation easier (I was told it's a common name
> for
> invoices you have to pay).
>
> > - multiple tax table entries are possible
> > - each tax table entry allows *multiple* account selection, each with its
> > own percentage/amount and tax account
> I don't think this is exactly correct.
> One can define multiple tax tables. Each tax table can have multiple tax
> table
> entries. And each entry has *exactly one* tax account.
>
> >
> > So instead of delving deep into theory of taxes and how they apply, could
> > users please let me know illustrated examples of how they have set up
> their
> > tables in their jurisdiction, and example invoices/bills that apply? I'm
> > especially keen on an example of an invoice/bill which has multiple
> > entries, each with its own tax table, and the tax table entry
> incorporates
> > multiple tax accounts. (If this makes any sense... because the software
> > supports it!)
> >
> Practical examples in Belgium:
> Depending on the type of good or service being sold we have different tax
> (VAT/GST) regimes.
> On 'luxury goods' (very broad term) we are required to charge 21% VAT
> On food only 6% VAT is charged
>
> That requires me to define two tax tables:
> One for 21% VAT
> One for 6% VAT
>
> So whenever I buy a 'luxury good', I select the 21% VAT tax table for that
> good on the bill. When I buy groceries, I select that 6% VAT tax table. I
> can
> also shop in a big shopping mall and buy both something considered luxury
> and
> some groceries. In that case some lines on the bill will be assigned the
> 21%
> VAT tax table and some the 6% one.
>
> Note these are very simple tax tables. They both have only one entry
> setting
> the percentage and an account to collect the VAT. It makes it easier for my
> VAT declaration to track the diffent VAT percentages in separate accounts
> so I
> have accounts for 6% VAT and 21% VAT.
>
> On to a more complicated example: Europe has some special legislation
> regarding sales across country borders. When I sell something to a German
> client (being in Belgium myself), I don't have to charge VAT on the
> invoice,
> but I do have to declare this VAT to the VAT office in two separate lines:
> - I have to count the VAT as 21% sales tax (adding it to all the VAT
> collected
> on invoices for Belgian customers)
> - I have to add it to a special entry that counts all the VAT I did not
> collect because it was an intra-European sale.
>
> 

Re: Re : Could not obtain the lock

[David Carlson]

It sounds like you are starting GnuCash more times than you are shutting it
down.  GnuCash can open more than one instance at a time, which would cause
the same message.

Take care to return to the open instance rather than starting a new
instance when you return, because it is possible to lose data from the
first instance when the second instance is shut down.

David C

On Sat, Sep 2, 2017 at 1:40 AM, Alain Dormoy  wrote:

>
>
> --
> De : "Colin Law" 
> Date : vendredi 1 septembre 2017 13:12
> À : "Alain Dormoy" 
> Cc : 
> Objet : Re: Could not obtain the lock
>
> On 1 September 2017 at 11:51, Alain Dormoy  wrote:
>>
>>> Hi!
>>>
>>> More often than not, when I launch GnuCash, I get the message:
>>>
>>> Gnucash could not obtain the lock for file:\...\filename.gnucash
>>>
>>> I click "Open anyway" and it works normally. So I can't say I really care
>>> but it's a bit puzzling.
>>>
>>> Anyone has an explanation and can I do something to change that?
>>>
>>
>> That normally happens when GC has not been closed down correctly. How
>> are you closing it?
>> Also which operating system are you using and which version GC?
>>
>> Colin
>>
>
>
>
> I'm using Windows 7.
> I normally close GC before turning my computer off. But I hardly turn it
> off more than once a week and the "incident" I'm refering to happens most
> every day.
>
> Alain
>
> ---
> L'absence de virus dans ce courrier électronique a été vérifiée par le
> logiciel antivirus Avast.
> https://www.avast.com/antivirus
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Re : Re : Could not obtain the lock

[David Carlson]

Alain, sometimes Windows does some weird things if its settings get messed
up.

Next time you want to see if it is already running try Alt-Tab several
times to see all the programs that are running.   There are other ways to
check as well.

David C

On Sep 2, 2017 3:26 AM, "Alain Dormoy" <cag...@free.fr> wrote:


*Thank you David.*
*I don't think I'm starting GC more times than I'm shutting it down. If
it's running I access it through the icon at the base of my desk, it's only
if the icon is missing that I "start" GC. *
*If I don't intend to use it for a long while I save whatever still needs
to be saved and I click on the cross in the upper right corner of my screen
(am I missing something?) *
*Alain*


*De :* David Carlson <david.carlson@gmail.com>
*Date :* samedi 2 septembre 2017 12:37
*À :* Alain Dormoy <cag...@free.fr>
*Cc :* Colin Law <clan...@gmail.com> ; Robert Heller <hel...@deepsoft.com>
; gnucash-user@gnucash.org
*Objet :* Re: Re : Could not obtain the lock

It sounds like you are starting GnuCash more times than you are shutting it
down.  GnuCash can open more than one instance at a time, which would cause
the same message.

Take care to return to the open instance rather than starting a new
instance when you return, because it is possible to lose data from the
first instance when the second instance is shut down.

David C

On Sat, Sep 2, 2017 at 1:40 AM, Alain Dormoy <cag...@free.fr> wrote:

>
>
> --
> De : "Colin Law" <clan...@gmail.com>
> Date : vendredi 1 septembre 2017 13:12
> À : "Alain Dormoy" <cag...@free.fr>
> Cc : <gnucash-user@gnucash.org>
> Objet : Re: Could not obtain the lock
>
> On 1 September 2017 at 11:51, Alain Dormoy <cag...@free.fr> wrote:
>>
>>> Hi!
>>>
>>> More often than not, when I launch GnuCash, I get the message:
>>>
>>> Gnucash could not obtain the lock for file:\...\filename.gnucash
>>>
>>> I click "Open anyway" and it works normally. So I can't say I really care
>>> but it's a bit puzzling.
>>>
>>> Anyone has an explanation and can I do something to change that?
>>>
>>
>> That normally happens when GC has not been closed down correctly. How
>> are you closing it?
>> Also which operating system are you using and which version GC?
>>
>> Colin
>>
>
>
>
> I'm using Windows 7.
> I normally close GC before turning my computer off. But I hardly turn it
> off more than once a week and the "incident" I'm refering to happens most
> every day.
>
> Alain
>
> ---
> L'absence de virus dans ce courrier électronique a été vérifiée par le
> logiciel antivirus Avast.
> https://www.avast.com/antivirus
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient>
Garanti
sans virus. www.avast.com
<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient>
<#m_5602255948920206301_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: simple find transactions report

[David Carlson]

Geert,

Gmail used those ing triple dots to hide your reply in my mail folder.
Lucky for me I suspected as much when there appeared to be no reply .

David C


On Mon, Oct 9, 2017 at 2:48 PM, Geert Janssens 
wrote:

> Start with a search from the account hierarchy page and then open an
> account report on the search results tab.
>
> Regards,
> Geert
>
> Elmar  schreef op 9 oktober 2017 20:35:06 GMT+01:00:
> >Good afternoon to the list
> >
> >I seem to be having a brain fart.  I am trying to retrieve all the
> >transactions (all dates) with a certain payee in the description field,
> >
> >and only those transactions.  Somehow I cannot make the transaction
> >report do this - what am I missing?  It should be easy, which tells me
> >I'm at fault.
> >
> >- Elmar
> >
> >
> >___
> >gnucash-user mailing list
> >gnucash-user@gnucash.org
> >https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >-
> >Please remember to CC this list on all your replies.
> >You can do this by using Reply-To-List or Reply-All.
>
> Sent from my smartphone. Please excuse my brevity.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: importing

[David Carlson]

Frank,

I just tried the QIF importer on a tiny file that I had laying around.  For
this test I was using release 2.6.15 in Windows.

I found that the QIF importer is somewhat tedious to use initially until it
has some history in it's memory from previous imports.  After several steps
of finding the correct account names to import into, it does have a step to
find possible matches of existing transactions to new incoming
transactions.  A good reason to take baby steps here is that you may need
to remember what the transactions looked like in Quicken to be good at
making the correct matches.  Once you have some history imported correctly,
it should get easier to import more history without accidentally letting
too many duplicates through.  When you see the data you may find that
certain transactions in your Quicken file would import better if they were
changed in Quicken before being exported.  I recall that around 2005 or a
little later it was possible to export single accounts and limited time
intervals from Quicken, which helped me then.  I know that Quicken has
changed a lot since then and that may not be possible any more.


David C


On Sun, Oct 8, 2017 at 10:24 PM, David Carlson <david.carlson@gmail.com>
wrote:

> Frank,
>
> Sorry to hear about that misfortune.
>
> Theoretically you you can use file > replay log and that may get you close
> to where it was before it crashed, but in your case that may not be your
> best choice.
>
> I suggest writing up your experiences so far to learning about some of the
> mistakes that Gnucash is not very good at protecting users from making.
>
> That said, you can establish procedures to avoid those mistakes, and I
> think that if you do that and continue with Gnucash it can probably meet
> your needs.
>
> You have now learned that you should save your d ata file often, perhaps
> every five minutes.
>
> When learning how the import process works, it is wise to start with baby
> steps, perhaps starting over several times when you are not getting the
> desired results.
>
> As David T suggested, you may find it helpful to make changes to your
> Quicken data before exporting to QIF.
>
> Good luck.
>
> David C
>
> On Oct 8, 2017 8:27 PM, "frank raney" <frankraney...@gmail.com> wrote:
>
> Just finished 6 hours correcting all the data i imported and before I
> could save it, the program crashed. All I have is the unchanged imported
> data fileWhen it crashed, the file was lost but there is a log
> file..what it is I don't know.  Guess I have to start all over?
>
> *Frankie Raney*
> *12454 Auberry Rd.
> <https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_=gmail=g>*
> *Clovis, Ca
> <https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_=gmail=g>.*
> *559.297.8577 <(559)%20297-8577> H*
> *559.304.1751 <(559)%20304-1751> C*
>
> On 10/7/2017 7:15:37 PM, David Carlson <david.carlson@gmail.com>
> wrote:
> Frank,
>
> I did not mean to imply that it worked better then, but it may have worked
> differently in older releases.  In any case, if you went that far back,
> there are some file compatibility issues to be concerned with.  I do recall
> being irritated with the fact that the QIF importer failed to import memos
> in split transactions, and I think that has been fixed.
>
> The main thing is that neither David T nor I recall having a significant
> problem avoiding the potential duplicate transactions that could arise if
> the user does not know the best procedure (as you have seen).
>
> David C
>
> On Sat, Oct 7, 2017 at 6:55 PM, frank raney <frankraney...@gmail.com>
> wrote:
>
>>
>>
>> *Frankie Raney*
>> *If it worked good in 2.2, then maybe I can get that version, try it and
>> if it works good, then upgrade.*
>>
>> On 10/7/2017 4:45:51 PM, David Carlson <david.carlson@gmail.com>
>> wrote:
>> Frank and David T,
>>
>> I believe that the QIF importer may not work exactly the same way that it
>> did back in the 2.2 series or the 2.4 series  or even the 2.6 series before
>> release 2.6.18.
>>
>> If that is the c as e  then we really do need someone who is familiar
>> with the way it works now to jump in and help.
>>
>> David C
>>
>> On Oct 7, 2017 3:18 PM, "frank raney" <frankraney...@gmail.com> wrote:
>>
>> I did import all at once..don't know yet how to export individual
>> accounts from Quicken..
>>
>>
>> Frankie Raney
>>
>> On 10/7/2017 7:46:05 AM, David T. <sunfis...@yahoo.com> wrote:
>> Frank,
>>
>> The *other* David suggested importing each account separately; I was
>> su

Re: importing

[David Carlson]

Frank,

There is still a problem with Gnucash on your computer because it should
not be crashing.

It may be somehow related to the account named Trading that GnuCash
created.  Normally, GnuCash will only create that account for users that
know that they want to use a special feature that is there for investors to
use to help with capital gains calculations, and it normally isn't used by
most people.

Actually, I am not sure how to safely delete that account (and prevent it
from coming back) if you do not want it, because it contains transfers to
and from your security accounts.  Perhaps a developer or another user can
advise us about that.   That is still not the cause of the crash, the
developers may need more details about that.

Good luck.

David C


On Wed, Oct 11, 2017 at 3:06 PM, Aaron Laws  wrote:

> On Wed, Oct 11, 2017 at 3:31 PM, frank raney 
> wrote:
>
> > I just answered my own question..The lck file is a temporary file
> > when the main file is opened.  I opened my file read only, resaved it.
> > closed it and the lck file went away.  I opened the file in a smaller
> > window so I coiuld see my directory and the lck file appeared
> again..it
> > went away when I closed the file..so.what was happening was,
> > when the program crashed, it did not close the lck file, and when I tried
> > to reopen it, it thought it was in usewala..Im back in
> > business...
> >
> >
> > Frankie Raney
> > 12454 Auberry Rd.
> > Clovis, Ca.
> > 559.297.8577 H
> > 559.304.1751 C
>
>
> That lck file is the mechanism by which gnucash ensures that each file is
> only opened once at a time. If that file is there, that means gnucash is
> using the corresponding ".gnucash" file. Of course, if gnucash crashes and
> is unable to delete that .lck file, it will superexist the gnucash process.
> In this case, the correct choice is "open anyway", and copying everything
> first is an excellent idea, too.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: importing

[David Carlson]

I forgot to mention that there is a setting somewhere called "Use Trading
Accounts" that turns that feature on or off.  I think it is mentioned
somewhere in the documentation.

David C

On Wed, Oct 11, 2017 at 4:07 PM, David Carlson <david.carlson@gmail.com>
wrote:

> Frank,
>
> There is still a problem with Gnucash on your computer because it should
> not be crashing.
>
> It may be somehow related to the account named Trading that GnuCash
> created.  Normally, GnuCash will only create that account for users that
> know that they want to use a special feature that is there for investors to
> use to help with capital gains calculations, and it normally isn't used by
> most people.
>
> Actually, I am not sure how to safely delete that account (and prevent it
> from coming back) if you do not want it, because it contains transfers to
> and from your security accounts.  Perhaps a developer or another user can
> advise us about that.   That is still not the cause of the crash, the
> developers may need more details about that.
>
> Good luck.
>
> David C
>
>
> On Wed, Oct 11, 2017 at 3:06 PM, Aaron Laws <dartm...@gmail.com> wrote:
>
>> On Wed, Oct 11, 2017 at 3:31 PM, frank raney <frankraney...@gmail.com>
>> wrote:
>>
>> > I just answered my own question..The lck file is a temporary
>> file
>> > when the main file is opened.  I opened my file read only, resaved it.
>> > closed it and the lck file went away.  I opened the file in a smaller
>> > window so I coiuld see my directory and the lck file appeared
>> again..it
>> > went away when I closed the file..so.what was happening was,
>> > when the program crashed, it did not close the lck file, and when I
>> tried
>> > to reopen it, it thought it was in usewala..Im back in
>> > business...
>> >
>> >
>> > Frankie Raney
>> > 12454 Auberry Rd.
>> > Clovis, Ca.
>> > 559.297.8577 H
>> > 559.304.1751 C
>>
>>
>> That lck file is the mechanism by which gnucash ensures that each file is
>> only opened once at a time. If that file is there, that means gnucash is
>> using the corresponding ".gnucash" file. Of course, if gnucash crashes and
>> is unable to delete that .lck file, it will superexist the gnucash
>> process.
>> In this case, the correct choice is "open anyway", and copying everything
>> first is an excellent idea, too.
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: importing

[David Carlson]

What O S are you installing into and what version are you installing?
The help files come along automatically in Windows and most Linux packages.

David C


On Oct 11, 2017 11:18 PM, "frank raney" <frankraney...@gmail.com> wrote:

> I can't find the documentation to tell me where to put the help files.  I
> put them in the same dir as the program but when I click on help, I am told
> it can not be found.
>
> *Frankie Raney*
> *12454 Auberry Rd.
> <https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_=gmail=g>*
> *Clovis, Ca
> <https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_=gmail=g>.*
> *559.297.8577 <(559)%20297-8577> H*
> *559.304.1751 <(559)%20304-1751> C*
>
> On 10/11/2017 2:14:08 PM, David Carlson <david.carlson@gmail.com>
> wrote:
> I forgot to mention that there is a setting somewhere called "Use Trading
> Accounts" that turns that feature on or off.  I think it is mentioned
> somewhere in the documentation.
>
> David C
>
> On Wed, Oct 11, 2017 at 4:07 PM, David Carlson <
> david.carlson@gmail.com> wrote:
>
>> Frank,
>>
>> There is still a problem with Gnucash on your computer because it should
>> not be crashing.
>>
>> It may be somehow related to the account named Trading that GnuCash
>> created.  Normally, GnuCash will only create that account for users that
>> know that they want to use a special feature that is there for investors to
>> use to help with capital gains calculations, and it normally isn't used by
>> most people.
>>
>> Actually, I am not sure how to safely delete that account (and prevent it
>> from coming back) if you do not want it, because it contains transfers to
>> and from your security accounts.  Perhaps a developer or another user can
>> advise us about that.   That is still not the cause of the crash, the
>> developers may need more details about that.
>>
>> Good luck.
>>
>> David C
>>
>>
>> On Wed, Oct 11, 2017 at 3:06 PM, Aaron Laws <dartm...@gmail.com> wrote:
>>
>>> On Wed, Oct 11, 2017 at 3:31 PM, frank raney <frankraney...@gmail.com>
>>> wrote:
>>>
>>> > I just answered my own question..The lck file is a temporary
>>> file
>>> > when the main file is opened.  I opened my file read only, resaved it.
>>> > closed it and the lck file went away.  I opened the file in a smaller
>>> > window so I coiuld see my directory and the lck file appeared
>>> again..it
>>> > went away when I closed the file..so.what was happening
>>> was,
>>> > when the program crashed, it did not close the lck file, and when I
>>> tried
>>> > to reopen it, it thought it was in usewala..Im back in
>>> > business...
>>> >
>>> >
>>> > Frankie Raney
>>> > 12454 Auberry Rd.
>>> <https://maps.google.com/?q=12454+Auberry+Rd.+%0D+%3E+Clovis,+Ca=gmail=g>
>>> > Clovis, Ca
>>> <https://maps.google.com/?q=12454+Auberry+Rd.+%0D+%3E+Clovis,+Ca=gmail=g>
>>> .
>>> > 559.297.8577 H
>>> > 559.304.1751 C
>>>
>>>
>>> That lck file is the mechanism by which gnucash ensures that each file is
>>> only opened once at a time. If that file is there, that means gnucash is
>>> using the corresponding ".gnucash" file. Of course, if gnucash crashes
>>> and
>>> is unable to delete that .lck file, it will superexist the gnucash
>>> process.
>>> In this case, the correct choice is "open anyway", and copying everything
>>> first is an excellent idea, too.
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>>
>>
>>
>
>
> <https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient_term=icon>
>  Virus-free.
> www.avast.com
> <https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient_term=link>
> <#m_-361508229154219599_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Customized saved-reports file per gnucash file (i.e. per company)

[David Carlson]

There is a section in the GnuCash FAQ about what files are where for the
various OS's.  IIRC there is a .gnucash directory under ~user or some such
which can be copied and pasted into another machine, even under a different
OS but that would overwrite whatever is there.  Do not try that without
backing up whatever is already there.  For Windows it might get more
complicated, as some stuff is now in the Registry.

David C


On Tue, Oct 10, 2017 at 4:26 PM, Matthew Pounsett 
wrote:

> On 10 October 2017 at 15:15, Carsten Rinke  wrote:
>
> > Hi Ben,
> >
> > what do you mean by machine specific?
> >
> > If you transfer your gnucash data file between machines, I thought it
> > should also possible to transfer the saved-reports-2.x file between the
> > machines.
> >
>
> It probably is, but it's not trivial.  The data file is saved to an
> arbitrary location, which can easily be some sort of shared media.  The
> saved reports get saved... somewhere... by the application, and that
> somewhere is very likely platform-specific, and doesn't seem to be
> configurable.  Add to that the documentation about where GnuCash saves
> certain state files seems to be out of date (at least for the Mac) and it's
> enough to make the saved reports files less portable just because they're
> that much more difficult to find.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: importing

[David Carlson]

Frank,

You certainly had way too many issues with installing and starting to use
GnuCash.  Hopefully, you have seen them all and will enjoy the benefits now.

If GnuCash ever crashes again please report that here.

David C

On Thu, Oct 12, 2017 at 10:09 AM, frank raney <frankraney...@gmail.com>
wrote:

> I re-downloaded and re-installedworks now..
>
> *Frankie Raney*
> *12454 Auberry Rd.
> <https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_=gmail=g>*
> *Clovis, Ca
> <https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_=gmail=g>.*
> *559.297.8577 <(559)%20297-8577> H*
> *559.304.1751 <(559)%20304-1751> C*
>
> On 10/12/2017 7:52:06 AM, frank raney <frankraney...@gmail.com> wrote:
> I am using win 10 and installed GC 2.6.18.
>
> I have even tried putting the help pdf file manually, no luck..looks
> like the install file is only the program, no help file...got it from the
> GC web site  https://www.gnucash.org/download.phtml
>
> *Frankie Raney*
> *12454 Auberry Rd.
> <https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_=gmail=g>*
> *Clovis, Ca
> <https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_=gmail=g>.*
> *559.297.8577 <(559)%20297-8577> H*
> *559.304.1751 <(559)%20304-1751> C*
>
> On 10/11/2017 10:00:32 PM, David Carlson <david.carlson@gmail.com>
> wrote:
> What O S are you installing into and what version are you installing?
> The help files come along automatically in Windows and most Linux packages.
>
> David C
>
>
> On Oct 11, 2017 11:18 PM, "frank raney" <frankraney...@gmail.com> wrote:
>
>> I can't find the documentation to tell me where to put the help files.  I
>> put them in the same dir as the program but when I click on help, I am told
>> it can not be found.
>>
>> *Frankie Raney*
>> *12454 Auberry Rd.
>> <https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_=gmail=g>*
>> *Clovis, Ca
>> <https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_=gmail=g>.*
>> *559.297.8577 <(559)%20297-8577> H*
>> *559.304.1751 <(559)%20304-1751> C*
>>
>> On 10/11/2017 2:14:08 PM, David Carlson <david.carlson@gmail.com>
>> wrote:
>> I forgot to mention that there is a setting somewhere called "Use Trading
>> Accounts" that turns that feature on or off.  I think it is mentioned
>> somewhere in the documentation.
>>
>> David C
>>
>> On Wed, Oct 11, 2017 at 4:07 PM, David Carlson <
>> david.carlson@gmail.com> wrote:
>>
>>> Frank,
>>>
>>> There is still a problem with Gnucash on your computer because it should
>>> not be crashing.
>>>
>>> It may be somehow related to the account named Trading that GnuCash
>>> created.  Normally, GnuCash will only create that account for users that
>>> know that they want to use a special feature that is there for investors to
>>> use to help with capital gains calculations, and it normally isn't used by
>>> most people.
>>>
>>> Actually, I am not sure how to safely delete that account (and prevent
>>> it from coming back) if you do not want it, because it contains transfers
>>> to and from your security accounts.  Perhaps a developer or another user
>>> can advise us about that.   That is still not the cause of the crash, the
>>> developers may need more details about that.
>>>
>>> Good luck.
>>>
>>> David C
>>>
>>>
>>> On Wed, Oct 11, 2017 at 3:06 PM, Aaron Laws <dartm...@gmail.com> wrote:
>>>
>>>> On Wed, Oct 11, 2017 at 3:31 PM, frank raney <frankraney...@gmail.com>
>>>> wrote:
>>>>
>>>> > I just answered my own question..The lck file is a temporary
>>>> file
>>>> > when the main file is opened.  I opened my file read only, resaved it.
>>>> > closed it and the lck file went away.  I opened the file in a smaller
>>>> > window so I coiuld see my directory and the lck file appeared
>>>> again..it
>>>> > went away when I closed the file..so.what was happening
>>>> was,
>>>> > when the program crashed, it did not close the lck file, and when I
>>>> tried
>>>> > to reopen it, it thought it was in usewala..Im back in
>>>> > business...
>>>> >
>>>> >
>>>> > Frankie Raney
>>>> > 12454 Auberry Rd.
>>>> <ht

Re: command line QIF import

[David Carlson]

John R. Sowden,

Could you please elaborate on your assertions that

1. "errors, often based on changing amounts (2 debits, etc.,) are hidden
from the user."

2. "A 'preference' switch to allow users who are familiar and comfortable
with the 'Intuit Way' to continue, vs. those with accounting knowledge who
want a transaction to look like a transaction, could have it that way, is a
possibility."

3. is "In House Accountant" available on the internet?

David C

On Tue, Oct 17, 2017 at 10:36 AM, John R. Sowden  wrote:

> To: Liz, the moderator, and the list:
>
> Actually Gnucash seems to strike a strong resemblance to Quicken.  The
> data entry in the journal mode with no payee in the check or source account
> entry (from cash, checking, or credit cards), and where the amounts of the
> entry change in during the data entry process, and where errors, often
> based on changing amounts (2 debits, etc.,) are hidden from the user.
>
> It makes sense that users of the Intuit family of products want to leave,
> due to some of their business practices; and some desire to use an
> operating system that is not founded on enhancing the profits of the
> publishers at the user's expense.
>
> I watch Gnucash for fixes to these problems, but all I see are
> justifications of why they exist.  A 'preference' switch to allow users who
> are familiar and comfortable with the 'Intuit Way' to continue, vs. those
> with accounting knowledge who want a transaction to look like a
> transaction, could have it that way, is a possibility.  The end result
> would be a transaction posted to the appropriate accounts.
>
> I use a DOS program run under Dosemu in Ubuntu, written by 2 programmers
> who sold their program to Intuit.  Intuit buried their program, "In House
> Accountant", and use some of its code in Quickbooks.  I declined their
> offer to 'switch'.
>
> John Sowden
> American Sentry Systems, Inc.
>
>
>
> On 10/16/2017 07:06 PM, Liz wrote:
>
>> On Mon, 16 Oct 2017 06:52:17 -0700 (MST)
>> Nelson  wrote:
>>
>> You're getting very defensive here David and your posts are not
>>> contributing to this discussion at all.
>>>
>>>
>>> Gnucash is Gnucash.
>> It isn't a Quicken-to-Gnucash project.
>>
>> Yes, we do get many queries about this, but the process once completed
>> is soon forgotten, and while there is much knowledge about this in the
>> mailing lists, Quicken-to-Gnucash is not the main focus of this project.
>>
>>
>> Nelson, you are free to try and do what you like, except start personal
>> attacks on other contributors.
>>
>> Liz, the moderator.
>> (Profanity is also something I heavily discourage)
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: exporting

[David Carlson]

Are you having a problem using the Export function or is your problem with
reading the output with a spreadsheet program?

David C

On Mon, Oct 23, 2017 at 3:58 PM, Jonathan Silvey 
wrote:

> Hi,
>
> I'd like to export a single account to Excel but I can't find Export on the
> help pages. I have found Export under File but I can't follow the resulting
> output.
>
> Jonathan
>
> *Think before you print.*
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: CSV Imports

[David Carlson]

Nick,

The CSV import assistant in release 2.6 series is not able to import files
created by GnuCash.

This is a known problem which will be corrected when the 2.8 release  comes
out.

That release will change the data file structure in a way that will not be
readable by older releases of GnuCash.

David C

On Oct 24, 2017 12:48 AM, "Nick Judd"  wrote:

> Hello everyone,
>
> I have been using Gnucash for personal accounting for the last couple of
> years. I have questions about CSV imports relevant to this thread:
>
> https://lists.gnucash.org/pipermail/gnucash-user/2017-March/069914.html
>
> 1. Using Gnucash 2.6.18, my experience is that it is not straightforward
> to import transactions from CSV using a CSV /I have generated using
> GNUCash/, into exactly the same account structure.
>
> Am I missing something here?
>
> 2. Looking over previous threads, I understand that Gnucash's CSV import
> cannot really handle multi-split transactions. I need multi-split
> transactions and I can code well in Python but am useless in Gnucash's
> native C/C++. The solutions that immediately come to mind are trying to
> shoehorn the data in using Gnucash's Python API (bad) or to use Python to
> reshape the CSV into a more Gnucash-friendly object (easier -> better).
> However, the threads I have seen focus more on the general notion that CSV
> import really isn't going to be ready for prime time until 2.8 than on the
> kinds of things CSV import can currently do well. I am interested in the
> latter.
>
>
> Apologies for retreading ground that I am sure comes up a lot. Thanks for
> your help.
>
>
> Best
>
>
> Nick Judd
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

How to install an updated Finance-Quote module in Linux

[David Carlson]

I thought I saw instructions somewhere on how to update the Finance-Quote
module, but now I cannot find it.  The instructions in the GnuCash FAQ are
not sufficiently complete for dummies like me.  I get an error
gnc-fq-update command not found then I do not know what to do next.

David C
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: GNU Cash Transactions - Wiped Out

[David Carlson]

Roy,

What is the name of your data file and where do you have it stored?  If all
the accounts are devoid of transactions, are they all present?

Did you look for the backups that are mentioned in the online FAQs?

David C

On Thu, Nov 9, 2017 at 2:39 PM, Roy Molepo  wrote:

> Greetings
>
> I have been using GNU Cash and processed transactions for 12 months.
>
> Today when I opened the Program all my processed transactions have been
> wiped out / disappeared. All balances are now ZEROS.
>
> How can I recover my processed transactions?
>
> Help will be highly APPRECIATED.
>
> Yours Sincerely
>
> Roy Molepo
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Slow startup on Windows 10, v2.6.18

[David Carlson]

Steve,

As far as I know, what you are describing has been the way GnuCash works on
Windows for the entire life of the 2.6 series as well as the 2.4 series
releases.

I am currently using various releases from 2.6.12 on to release 2.6 16 in
Windows and Linux and I see the same with files saved in compressed
.gnucash format.  I understand that behavior is a little different for
other formats and OS's but that there will not be a substantial improvement
in the 2.6 series or even in the upcoming 2.8 series, but I could be wrong
about that.

As you have noticed, closing all reports before closing the data file helps
minimize this.

David C

On Tue, Nov 28, 2017 at 8:53 AM, Steve Goings 
wrote:

> I've been using 2.6.18 on Windows 10 for some weeks with no problems until
> recently.
>
> Now, startup gets very slow as Gnucash renders the first report that was
> displayed in the last session. It takes about 30 seconds to render that
> first report. Then the other reports render quickly, as expected.
>
> When I close all the reports and then close Gnucash, restart happens
> quickly as expected. Then when I try to run any report, there is again
> about a 30 second delay to render that first report, no matter what it is.
> After that, other reports are rendered quickly.
>
> I have created a new Gnucash file, with the basic accounts, and no data,
> and get the same delay when rendering any of the standard reports the first
> time.
>
> I have removed and reinstalled Gnucash 2.6.18, to no avail. When I look at
> the Windows task manager, nothing seems to be eating CPU cycles or doing
> anything to slow down the system.
>
> I also have the latest Mac version of Gnucash running on a MacBook Pro, and
> it does not have this problem on the same data file and reports.
>
> Seeing this long delay after seeing none earlier has made me worry about
> some problem in the installation on Windows. I have tried clearing out all
> the Gnucash support files, such as I can find and reinstalling. None of
> this helps.
>
> Is this long delay on Windows for the first report rendering expected
> behavior now? If anyone has some ideas I would be grateful.
>
> In the meantime, I have gone back to 2.4.15 on Windows, and it works
> without any of the delays, but I would prefer to use the newer release if
> possible.
>
> I tried the development release, and it would not even run on my system.
>
> Thanks in advance for any advice or suggestions. I did report a bug on
> this,
>
> SG
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: QIF or QXF file for Quicken to GnuCash migration?

[David Carlson]

Is there a way to export data from Quicken in QXF format?

On Sat, Nov 25, 2017 at 9:50 AM, Ken Schneider 
wrote:

> On 11/24/2017 05:15 PM, Kenneth Schneider wrote:
>
>> I did this a few months ago and found it best to do each quicken account
>> separately. If the accounts are large you may want to do them in stages
>> covering only a couple of years at a time.
>>
>> Ken Schneider
>>
>> On Nov 24, 2017, at 2:05 PM, spflanze  wrote:
>>>
>>> Is a Quicken to GnuCash migration best done using a QIF or QXF file?
>>>
>>>
> Duh forgot to actualy answer your question, QIF works best.
>
> Ken
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Could not obtain the lock

[David Carlson]

Moira,

Do you have similar problems with other files on that computer?  Do you
check it for malware regularly?  It seems a little odd that you were able
to place the file there without write permission unless you do have
multiple users on that computer.  You may need to find an expert that is
familiar with permissions issues.

Another thing you could try is to put the GnuCash data file on a USB key
and see if it can be opened , closed and saved.

David C

On Wed, Nov 22, 2017 at 2:26 AM, Maf. King  wrote:

> On Wednesday, 22 November 2017 04:19:21 GMT moi...@web.net wrote:
>
> >
> > It has to be on my desktop?? OK, i'll try that ... tomorrow ... and
> report
> > back.
> >
> > Moira
>
> No it doesn't have to be on your desktop, but for testing purposes it is a
> handy place that we know exists!
>
> Maf.
>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Could not obtain the lock

[David Carlson]

Moira,

You have the attention of several different experienced GnuCash users from
various different backgrounds, and we all share your frustration.

Your experience does not match that of a typical user.  In my opinion there
is something unusual about your computer or how you managed to get the file
onto it with apparently different privileges than you have now.  However, I
am not an expert in privileges, so I cannot help you with that part of your
problem.

Another experiment that I can suggest is to try creating a new GnuCash data
file either on a USB key or in a sub-folder on your desktop, and see if you
can create a couple of accounts and transactions.  Try playing with that
for a while, and create and save a text file or a Word document.

Good luck and let us know about your progress.


David C

On Wed, Nov 22, 2017 at 8:53 PM,  wrote:

> > On Wednesday, 22 November 2017 04:19:21 GMT moi...@web.net wrote:
> >
> >>
> >> It has to be on my desktop?? OK, i'll try that ... tomorrow ... and
> >> report
> >> back.
> >>
> >> Moira
> >
> > No it doesn't have to be on your desktop, but for testing purposes it is
> a
> > handy place that we know exists!
>
> Oh, well I already tried saving it in a new folder, and that didn't work.
>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: bank entries

[David Carlson]

Christine,

If you receive income you might deposit it into the bank.  If you spend
money for groceries, you use cash.  If you withdraw money from the bank you
transfer from bank to cash.

That is what double entry is about.

David C,

On Sun, Nov 26, 2017 at 6:33 PM, Christine via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Hi Dave
> My accounts are Cash, Bank, Income, various expenses, and 2 people who I
> pay
> money too and who pay to the bank.
> IF I balance one of the accounts another goes wrong. All I want to do is
> add
> my bank and my cash and let gnucash do the rest (ie an income and
> expenditure report) but it is not working. Reading the literature I just
> get
> confused as I am used to DR and CR.
> Thanks anyway maybe I should look for an easier program if anyone knows of
> one
>
> Christine
>
>
> -Original Message-
> From: gnucash-user
> [mailto:gnucash-user-bounces+cmaloney4=talktalk@gnucash.org] On Behalf
> Of DaveC49
> Sent: 27 November 2017 02:20
> To: gnucash-user@gnucash.org
> Subject: Re: bank entries
>
> Christine,
>
> Gnucash is a double entry accounting system.  What this means is that any
> transaction affects at least two accounts. For example when you purchase
> something your bank account is credited by the amount of the purchase any
> purchase is also an expense so an expense account has to be debited by the
> amount of the purchase in the second component of the transaction. These
> two
> components of the one transactions are referred to in Gnucash as "splits".
> The same methodology is applied to any other sort of transaction, it will
> always consist of at least two components ( and sometimes more) affecting
> at
> least two accounts. In any single transaction the sum of the debit and the
> sum of the credit components of the splits of that transaction must be
> equal
>
> The Gnucash Tutorial and Concepts guide
> (https://www.gnucash.org/docs/v2.6/C/gnucash-guide/) along with the
> Wikipedia articles on double entry bookkeeping
> (https://en.wikipedia.org/wiki/Double-entry_bookkeeping_system will give
> you
> some background information. Gnucash follows what is called the Accounting
> Equation or American approach in this article. The article on the
> Accounting
> equation (https://en.wikipedia.org/wiki/Accounting_equation) also provides
> some useful background.
>
> That said, it is possible when you are entering a transaction and create
> the
> deposit split to your bank account (this will be a debit to that account if
> you use the accounting terms) what you are seeing is the other
> component/split of the transaction being automatically created. If you have
> not yet created  appropriate income accounts, it may be assigning your bank
> account as the default account for this second split which will be  a
> credit. If you click in the account field in the second split, you should
> be
> able to select a different account from your chart of accounts.
>
> For a deposit to your bank account, the account for the second split would
> normally be an income account for money coming from an external source or
> another asset account if you are transferring money between accounts ofr
> example.
>
>
> David
>
>
>
> -
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Enhancement Request for GNUcash

[David Carlson]

Are you asking for GnuCash to perform magic or just pretend?

David C

On Dec 5, 2017 12:25 AM, "Jesse Cochran"  wrote:

> To whom it may concern,
>
> Given how limited and un-free our monetary system is nowadays, I think
> GNUcash would make a great tool for the following freedoms below:
>
> 0 > The Freedom to modify your starting and ending balance. This means you
> can take a @200 balance (yes, I'm using the @ symbol for example use), and
> turn it into @20 without the need to transfer anything.
>
> 1 > The Freedom to add and subtract from your ending balance like a
> calculator.
>
> 2 > The Freedom to send and receive money in any amount you choose.
>
> 3 > The Freedom to exchange this currency for other currency of any amount
> or size.
>
> So I am generically requesting a feature that allows this  to be
> implemented into GNUcash, just to exercise this right.
>
> Thanks for understanding,
>
> Jesse.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: A BASH script to help get tax-related data from gnucash

[David Carlson]

Could this script be referenced somewhere in the GnuCash WIKI?

David C

On Sat, Dec 16, 2017 at 3:44 AM, David T. via gnucash-user <
gnucash-user@gnucash.org> wrote:

> I’m sorry. Your original characterization was vague, and I didn’t
> understand what your issue with that report was. I see what you are noting,
> although it’s not something that bothers me. FWIW, I would probably dump
> the report into a spreadsheet and munge the data there if the redundancies
> were an issue.
>
> Nevertheless, thanks for sharing your script; perhaps it will help others
> out!
>
> Cheers,
> David
>
> > On Dec 15, 2017, at 8:22 PM, azalea4va 
> wrote:
> >
> > GnuCash - User mailing list wrote
> >> If you have set the accounts as tax-related, why wouldn't you use the
> Tax
> >> Schedule Report?
> >
> > I thought I addressed that in my post when I said "I find the provided
> "Tax
> > Schedule Report" as being les than ideal in its presentation of the
> > information I seek."
> >
> > Look at the attached screenshot where I have side-by-side the portions of
> > the two reports information about "Tax Prep" expenses,  tax-prep.png
> >   .
> The Tax
> > Schedule report has 4 lines vs 1 in the Income Statement and the Tax
> > Schedule is almost twice as wide.  They convey the same USEFUL
> information
> > but the Tax Schedule takes almost 8 times the space.  Additionally,
> there is
> > the "noise" of other info on the Tax Schedule that intereferes with
> easily
> > accessing the info I want.  Please understand that this example is just
> > showing one data item, so the "noise" is not a major issue.  But when one
> > looks at the entire report with hundreds of lines of output (most of it
> > noise), then the noise really gets in the way. Yes the tax Schedule also
> > gives the line number on the tax form.  But that is useless info for
> me.  I
> > use tax prep software so I am not dealing with line numbers in forms.
> But
> > also, it is not a number I can rely on as depending on the version of
> > gnucash and the tax year, that number will not always be accurate.
> >
> > In addition, because of the lack of noise in the Income Statement, it is
> > easy to copy/paste the tax-related data into a spreadsheet (or whatever).
> > Yes, getting info out of gnucash for use in other things is something of
> > value to me. For example, in a spreadsheet where I have an added column
> that
> > tracks if a data item will have a tax form being sent to me and if that
> form
> > has been received or not. The spreadsheet makes it easy to keep track of
> > cross checking received form data with data in gnucash and data entered
> into
> > the tax return itself.
> >
> > So for those reasons, I find the Income Statement format more useful.  I
> am
> > not saying the Income Statement is "better" for everyone, just that I
> find
> > it a useful alternative. Your mileage may vary.  I offer the tool for
> anyone
> > who finds it of value.
> >
> >
> >
> > --
> > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-
> f1415819.html
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Error in Tip of the Day

[David Carlson]

The two bug reports contain different descriptions of the reasoning behind
calling it a bug, so I think that it would be appropriate to just leave
them cross referenced until the situation is resolved, rather than marking
one as a duplicate.

David C

On Fri, Dec 15, 2017 at 9:25 PM, Daniel Narvaes 
wrote:

> On Fri, 2017-12-15 at 09:36 +0100, Geert Janssens wrote:
> > Op zondag 10 december 2017 22:26:40 CET schreef Daniel Narvaes:
> > >
> > > I've been using gnucash for a long time, and I usually read the tip
> > > of the
> > > day, and try it if I have not seen it before.  Today it said "To
> > > switch
> > > between multiple tabs in the main window, press Control+Page
> > > Up/Down."  I
> > > tried it and it didn't work.  After browsing the users mailing
> > > list, I
> > > found out the correct key combination is "Ctrl+Alt+Page Up/Down."
> > >
> > > I'm using gnucash 2.6.12 on Ubuntu 14.04 LTS.  Can someone check
> > > and see if
> > > the description is still wrong on the latest version?  If so, I'll
> > > file a
> > > bug report, unless you want to do that for me too.  I would still
> > > have to
> > > create an account on Bugzilla to make a bug report.
> > > ___
> > > gnucash-user mailing list
> > > gnucash-user@gnucash.org
> > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > > -
> > > Please remember to CC this list on all your replies.
> > > You can do this by using Reply-To-List or Reply-All.
> > You are correct it should be "Ctrl-Alt-Page Up/Down". That's how it
> > works on
> > the current stable version (2.6.18) as well.
> >
> > On the current development version this appears to be broken. It will
> > only
> > work if a notebook tab is clicked on first (which is defeating the
> > initial
> > idea). And it breaks down on report pages.
> >
> > Please do file a bug report and feel free to quote my findings as
> > well.
> >
> > Thanks,
> >
> > Geert
> >
> So, I created an account on Bugzilla, and when I started typing a
> description of the bug, it referred me to similar bug reports.  It
> turns out there are already a couple of bug reports on this issue,
> one of which is over ten years old!
>
> Can you take a look and see if you think there is anything else that
> needs to be added to the existing bug reports?
> https://bugzilla.gnome.org/show_bug.cgi?id=647744
> https://bugzilla.gnome.org/show_bug.cgi?id=450717
>
> -Daniel
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: How to find out which securities need to be switched from Yahoo to Alphavantage

[David Carlson]

Ouch!!
David T, I vaguely recall that either you or someone you were discussing
price retrieval with about a year or two ago developed a way to find and
purge old prices from a file in a more selective way than the current purge
function works.
Is that documented somewhere?

Parenthetically, I also found a note in this haystack from Erik Colson
indicating that as of this time vanguard, nasdaq and nyse prices are not
retrieved by the alphavantage module, and a lot of my currently owned
securities are traded on nasdaq, so that is another gotcha to watch out for.

David C

On Mon, Nov 13, 2017 at 11:20 AM, D <sunfis...@yahoo.com> wrote:

> See below.
>
> On November 13, 2017, at 9:02 PM, David Carlson <
> david.carlson@gmail.com> wrote:
>
> >I have been using GnuCash for many years and there are many securities in
> >my file that I no longer own, but I may or may not have discontinued
> >downloading their prices.  In trying to get my Alphavantage source
> working,
> >it appears that it does not work if there is a mix of some securities
> >changed and many not changed.
> >1. Do I have to find all of them and change all before it will work?
>
> Unfortunately, yes.
>
> >2. If so, is there an easy way to find them all?
>
> Not really. I tried using the sql back end to change things  (through
> direct manipulation in the tables, which is NOT recommended), but the
> result was not successful. The sources were changed, but retrieval failed.
> I didn't feel like exploring further, so I went back to my original file
> and changed them manually.
>
> >3. If not,what troubleshooting steps will help figure out why it is not
> >working yet?
>
> I went through all my securities and changed them all. Then I ran get
> quotes, and checked the errors, which were inevitably omissions on my part.
> Rinse and repeat until you don't get errors.
>
> Perhaps it would be advisable to take this opportunity to clean out the
> older securities and turn off retrieval for them. Those lookups take time,
> the prices take space, and it doesn't really serve your accounting any real
> purpose to keep retrieving them.
>
> David T.
>
> >David C
> >___
> >gnucash-user mailing list
> >gnucash-user@gnucash.org
> >https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >-
> >Please remember to CC this list on all your replies.
> >You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

How to find out which securities need to be switched from Yahoo to Alphavantage

[David Carlson]

I have been using GnuCash for many years and there are many securities in
my file that I no longer own, but I may or may not have discontinued
downloading their prices.  In trying to get my Alphavantage source working,
it appears that it does not work if there is a mix of some securities
changed and many not changed.

1. Do I have to find all of them and change all before it will work?

2. If so, is there an easy way to find them all?

3. If not,what troubleshooting steps will help figure out why it is not
working yet?

David C
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Reconciling Manually Downloaded Transactions

[David Carlson]

AAK,

Yes, that is the way Gnucash behaves when you select the Update + Reconcile
option while matching transactions.  I rarely use that option for that very
reason.  I mostly use the Reconcile option.

I will get on my soapbox here, since I think that the word Reconcile is not
used correctly in this context.  In this context the word Match fits better
in my opinion.

David C

On Mon, Nov 20, 2017 at 8:03 AM, AAK  wrote:

> I download transaction activity from my bank in a QFX format. When I match
> them with pre-existing transaction and finalize the import process I see
> that GC overrides the payee names i have in the register with the cryptic
> names downloaded from the bank. Is there a way to prevent that?
> Also, when there are new transactions to be added is there a way to edit
> the
> payee name and category from the transaction matcher window? Thanks in
> advance.
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Reconciling Manually Downloaded Transactions

[David Carlson]

I forgot to answer your second question.

There is a problem with mucking about in the underlying register view while
the import assistant is running, because if you accidentally touch one of
the new incoming transactions you trigger warning messages that you really
do not want to see.  If you can move the import window far enough out of
the way to see what you are doing and never touch any of the incoming
transactions, you can edit existing transactions, but never touch new
transactions even just to go by to the next transaction.  If you really do
want to experiment, be extra sure to save the file before starting the
import. I recommend saving first in every case.

David C

On Mon, Nov 20, 2017 at 6:57 PM, David Carlson <david.carlson@gmail.com>
wrote:

> AAK,
>
> Yes, that is the way Gnucash behaves when you select the Update +
> Reconcile option while matching transactions.  I rarely use that option for
> that very reason.  I mostly use the Reconcile option.
>
> I will get on my soapbox here, since I think that the word Reconcile is
> not used correctly in this context.  In this context the word Match fits
> better in my opinion.
>
> David C
>
> On Mon, Nov 20, 2017 at 8:03 AM, AAK <a.a.khali...@gmail.com> wrote:
>
>> I download transaction activity from my bank in a QFX format. When I match
>> them with pre-existing transaction and finalize the import process I see
>> that GC overrides the payee names i have in the register with the cryptic
>> names downloaded from the bank. Is there a way to prevent that?
>> Also, when there are new transactions to be added is there a way to edit
>> the
>> payee name and category from the transaction matcher window? Thanks in
>> advance.
>>
>>
>>
>> --
>> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.
>> html
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Could not obtain the lock

[David Carlson]

Moira,

The lock file is always in the same folder as the data file and it always
has the same name as the data file with the suffix .LCK  Unless you are
doing something very unusual, the files will be visible in your file
explorer as long as you put them somewhere in your user folder on your
local machine ('C' Drive) or on a removable device.  If you are using cloud
storage, you may have a problem with the configuration.

In Windows the user name matters when there are more than one user on the
same machine, but on single user machines it does not matter if the files
were created in another machine under a different user name.

What do you mean by "it asks me to save the file as a new file"?  Have you
been clicking on "File > Save" and immediately getting a message to "Save
As.." or does the "Save" button go grey and the asterisk that was in front
of the file name in the top banner disappear?.

If you do get the "Save As..." prompt, just save it to a different folder
under your desktop temporarily until you can find the problem.

Exactly how do you exit the program?  Are the transactions you entered
recently reappearing when you re-open the file?  Do you start the program
by clicking on the program icon or on the data file icon or a shortcut to
the data file?

David C

On Tue, Nov 21, 2017 at 1:35 AM, Maf. King  wrote:

> Hi Moira,
>
> What about the folder that the GC data file is in - is that read-only?
> can you
> create a file in that folder using some other program, say notepad or word?
>
> Don't know how windows manages username permissions - I know that some
> files
> can only be touched by an administrator.  You didn't specify windows in
> your
> OP, it would certainly be possible on linux that the new user ID would not
> have permissions to the files of an old ID...
>
> Maf.
>
>
> On Tuesday, 21 November 2017 02:49:30 GMT you wrote:
> > No, the files are not "Read-Only".
> >
> > My username for Windows??? Yes, it is different on the new computer. Does
> > that matter?
> >
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Could not obtain the lock

[David Carlson]

I believe that others will concur that you do not have write permission in
the folder containing that data file.  Is your user name User?

That is also why GnuCash failed to create a .LCK file.  You need to make a
new folder on your desktop, call it Moira_GnuCash_Data or similar and use
file manager to save a copy of the data file there.  Alternatively, when
you have the file open in GnuCash just do a Save As... into a new folder on
your desktop.  You will not be able to save any data until you do that.

David C


On Tue, Nov 21, 2017 at 8:32 PM,  wrote:

> David...
>
> > The lock file is always in the same folder as the data file and it always
> > has the same name as the data file with the suffix .LCK  Unless you are
> > doing something very unusual, the files will be visible in your file
> > explorer as long as you put them somewhere in your user folder on your
> > local machine ('C' Drive) or on a removable device.  If you are using
> > cloud storage, you may have a problem with the configuration.
>
> I looked in the same folder as the data file, there is no .LCK file there.
>
> > In Windows the user name matters when there are more than one user on
> the same machine, but on single user machines it does not matter if the
> files were created in another machine under a different user name.
>
> Then that is not the problem; these files were created in another file
> under a different user name; both machines were single user.
>
> > What do you mean by "it asks me to save the file as a new file"?  Have
> you been clicking on "File > Save" and immediately getting a message to
> "Save As.." or does the "Save" button go grey and the asterisk that was
> in front of the file name in the top banner disappear?. If you do get
> the "Save As..." prompt, just save it to a different folder under your
> desktop temporarily until you can find the problem.
>
> The actual error message I get when I click Save is "Could not make a
> backup of the file C:\Users\User\Documents\blahblahblah.gnucash"
>
> I then click "Close" (the only option in the error window), and it open
> the Save window.  Regardless of how or where I save it, I get an error
> message "GnuCash could not write to C:\Users\User\Documents\Temporary
> Gnucash\blahblahblah.gnucash. That database may be on a read-only file
> system, or you may not have write permission for the directory." If I try
> to overwrite the existing file, I get the warning message that it alredy
> exists, and after that "Could not make a backup of the file
> C:\Users\User\Documents\blahblahblah.gnucash" The changes don't save.
>
> > Exactly how do you exit the program?  Are the transactions you entered
> > recently reappearing when you re-open the file?  Do you start the
> program by clicking on the program icon or on the data file icon or a
> shortcut to the data file?
>
> I exit by clicking on Save, and then when that is done, either clicking on
> the X in the upper left corner or with File - Quit. Same results either
> way.  I start the program from the descktop shortcut, but get the same
> results when I open it from the Start menu.
>
> Help!
>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Restarting a Scheduled Transaction - possible ?

[David Carlson]

AEG,

I have succeeded in re-using scheduled transactions but there are some
limitations.  In your case, I think that using the for some number of
occurrences may be what is preventing further use of that SX.  I have never
used that box.  Last Occurred is only settable by the program so once it
has set that, I think there is no way to change the SX to add another
occurrence before that date.

As you have surmised, it is likely easier to duplicate a recent occurrence
in the register and create a new SX from that.

David C

On Tue, Nov 21, 2017 at 9:23 PM, aegross  wrote:

> Greetings, I had a scheduled transaction that ran for x months and has now
> ended.  I would like to restart the transaction with some changes.  I used
> the SX editor to change the start date but the transaction would not
> restart
> -- I tried restarting gnucash to start the next series of transactions, but
> nothing happens.  Also tried running the "since last run" command but that
> didn't help.
>
> Running GC v2.6.17 on Mac OS Sierra (10.12.6)
>
> Parameters around the transaction:
>
> OVERVIEW tab
> - "enable" checkbox is checked
> - the new date (that I set trying to restart the transaction) persists
> after
> restarting GnuCash and is currently one day (11/22) in the future.
> - "create automatically" is checked
> - "create in advance" is set to 15 days.
> - last occurred (which I can't change), is actually 2 days in the future
> (11/23) and was an error when the original transaction was created; before
> trying to restart the transaction series I had deleted this incorrect entry
> in the account.
> - Under "For", it's set to 12 occurrences.
>
> FREQUENCY TAB
> - "Start" date is set to 11/22/17 (had been 11/23/16 originally)
> - Every "1" months
> - On the "22nd", except "no change"
>
> Am thinking either scheduled transactions can't be restarted (or recycled)
> OR having the SX editor think the last transaction occurred after the next
> scheduled transaction (the first transaction in the new series) is a
> problem.
>
> After writing all this I am thinking the answer is probably just to delete
> and redo the SX; any other ideas?
>
>
> Thanks,
> AEG
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Gnucash 2.7 on Windows

[David Carlson]

I assume that you know that 2.7 is is a pre-release version, I would call
it an alpha or beta version, not for production use.

That said, I thought that the developers had updated it so that it did not
crash instantly in Windows.  Be sure that you have the most recent build.
It may be a bit hard to find.  I personally am not testing it myself.

David C

On Fri, Nov 17, 2017 at 5:55 PM, Sébastien de Menten 
wrote:

> Had anyone got some success in running the gnucash 2.7 binaries on Windows?
> My version just crashes at startup time without any meaningful logs.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: GnuCash skips lines with identical dollar amounts during bank statement import

[David Carlson]

Todd,

The OFX/QFX import requires a lot of TLC during the import to get
everything right.  During the verification step it is critical to examine
each transaction carefully to be sure that if it is new it gets added, if
it matches an existing transaction in your data it is matched to the
correct existing transaction, etc.

The details vary depending on some of your settings, but as John points out
in his reply, you probably see some highlighted in red that should be
changed to be accepted during the import.

Note that once GnuCash has seen a transaction in an import file, it will
recognize it if it appears again.  This is true even if you rejected it in
the previous import session. There is also a small chance that your source
file is incomplete, so if you cannot complete a reconciliation without
re-importing some missing transactions, that requires some jumping through
hoops.  In that case it may be easier to create the missing transactions
manually.

David C

On Sun, Nov 5, 2017 at 3:59 PM, Todd Dailey  wrote:

> During a QFX bank statement import, GnuCash skips lines with identical
> dollar amounts.
>
> Example: my mortgage payment is bi-weekly and is withdrawn as the same
> amount 2X or 3X per statement. GnuCash will only import the first
> occurrence.
>
> GnuCash 2.6.16
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: General Journal - history limit and search

[David Carlson]

Roger,

I do not normally start a search from the General Ledger view or I would
have known that it worked exactly as you described, at least in my
installation of release 2.6.11 in Linux.

The instructions for searching in the entire database state that one should
start from the chart of accounts, and that is the method that I usually use.

If one starts from a standard account register view a search opens a new
results window and leaves the account register view alone.

I have not found a way to 'back out' of a search result either, and , in
fact, I am often frustrated by the fact that there is no way to see what
was searched in or for what to generate that last search result window.
The search tool has an option to start a new search or to refine the last
search, but I have no idea if that actually does anything.

Occasionally I have seen a request to be able to save a search criteria
set, but as the program is now, with no way to identify the criteria, a
saved search would be useless.

If you can succinctly describe a better way to implement a search procedure
within the current GnuCash UI, suggest that as a potential improvement.

David C

On Tue, Oct 31, 2017 at 10:17 PM, Roger Oliver <rmom...@gmail.com> wrote:

> I thought so too but it doesn't seem to work that way. I keep the general
> journal open on the desktop. It isn't that difficult to open it again, just
> a curiosity that it didn't show the search results in a new window like the
> account journals.
>
> Once it shows the search results, I haven't figured out a way to get the
> general journal back to showing all the transactions after doing a search
> other than by opening another general journal. Might be able to do it by
> changing the filter settings in view. I'll try that tomorrow. Thanks
>
> On Oct 31, 2017 7:20 PM, "David Carlson" <david.carlson@gmail.com>
> wrote:
>
>> Roger, for your second question, I think that a search in the General
>> ledger view should produce it's results in a new results view rather than
>> the first General Ledger view.
>>
>> However, if I am wrong about that, it should be simple to open a new
>> General Ledger view from the menu.  You should not need to close the
>> previous results views unless you do not expect to go back to them and you
>> would rather have less clutter on your desktop.
>>
>> David C
>>
>> On Tue, Oct 31, 2017 at 12:23 PM, Roger Oliver <rmom...@gmail.com> wrote:
>>
>>> Perfect. Thanks
>>>
>>> On Oct 31, 2017 11:08 AM, "Aaron Laws" <dartm...@gmail.com> wrote:
>>>
>>> > On Tue, Oct 31, 2017 at 12:39 PM, Roger Oliver <rmom...@gmail.com>
>>> wrote:
>>> >
>>> >> I notice my general journal only goes back to the beginning of
>>> Octuber.
>>> >> Transactions from September don't show. A search by date doesn't find
>>> any
>>> >> transactions earlier than October either. Is there a setting I'm
>>> >> overlooking to include everything in the general journal?
>>> >>
>>> >> Also, when I search the general journal the results are shows in the
>>> same
>>> >> journal, not in another register. Don't know how to get the general
>>> >> journal
>>> >> back to showing all the transactions. I just close it and open the
>>> general
>>> >> journal again from the tools menu. Is there a better way? Something
>>> I'm
>>> >> not
>>> >> doing correctly in the search criteria window?
>>> >>
>>> >> Thanks,
>>> >> Roger
>>> >
>>> >
>>> > With the General Ledger open, click "View" then "Filter By..." and
>>> adjust
>>> > the filter to your liking. It doesn't remember this setting, so you'll
>>> have
>>> > to do it any time you close then reopen gnucash.
>>> >
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>>
>>
>>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: finance-quote error

[David Carlson]

I wonder exactly what "Term of Service" we violated?

David C

On Thu, Nov 2, 2017 at 6:10 PM, MGC  wrote:

> The error message I'm getting now says:
>
> It has come to our attention that this service is being used in violation
> of
> the Yahoo Terms of Service.  As such, the service is being discontinued.
> For all future markets and equities data research, please refer to
> finance.yahoo.com.
>
> I think we're hosed.
>
>
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: finance-quote error

[David Carlson]

OK, I think I found the problem, they discovered that there is no practical
way to take possession of our first-born children and they cannot tell if
we are stealing the information that they provide for free on their finance
website and selling it to the Russians.

David C

On Thu, Nov 2, 2017 at 7:03 PM, David Carlson <david.carlson@gmail.com>
wrote:

> I wonder exactly what "Term of Service" we violated?
>
> David C
>
> On Thu, Nov 2, 2017 at 6:10 PM, MGC <pis...@gmail.com> wrote:
>
>> The error message I'm getting now says:
>>
>> It has come to our attention that this service is being used in violation
>> of
>> the Yahoo Terms of Service.  As such, the service is being discontinued.
>> For all future markets and equities data research, please refer to
>> finance.yahoo.com.
>>
>> I think we're hosed.
>>
>>
>>
>>
>>
>> --
>> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.
>> html
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: finance-quote error

[David Carlson]

I found another program that may still be able to get prices, including
historical prices.  It just worked a moment ago to get the price of a NYSE
stock.  It would not be trivial to export tables from that program to
import into GnuCash, but maybe someone wants to try...

Google "TakeStock2"

On Thu, Nov 2, 2017 at 8:02 PM, MGC  wrote:

> Nobody knows what terms of service were violated. The yahoo finance help
> community is exploding over this. Check that out for a fun read.
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Removal of unnecessary listed Account names

[David Carlson]

Where are you seeing the multiple account names?  If you actually changed
the names in your chart of accounts, there should not be accounts with the
old names.  Similarly, in the OFX, QIF and CSV imports, you should not see
the old account names when matching transactions to existing.  You will
need to re-train the bayesian matching.

David C

On Thu, Nov 9, 2017 at 1:56 PM, Cliff Williams 
wrote:

> Gents
>
> After a couple of weeks using GnuCash I made a mistake and renamed some
> of my accounts. In fact in most cases just changed the name from
> low-case to upper-case so that I could easily identify the headings.
> What's happened now is that when I import new data and begin to match
> the incoming sub accounts with mine in GnuCash I now have two sets of
> headings to sort through, one in upper-case the other in lower.  The
> issue also appears when manually inputting or changing a transaction; In
> my case the dropdown list in account shows, one name in upper-case the
> other in lower.
>
> Is there a way of deleting all the lower case account headings to make
> the importing of data easier.  I do recognise that this is a short term
> issue as over time the accounts will automatically match the headings
> correctly but it is a bit of a pain at the moment.
>
> I've not been able to find any related information in your support
> documentation.
>
> Any assistance would be much appreciated.
>
> Thanks
>
> Cliff Williams
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: How to create an asset with a reduced value compared to my regular currency (dollars)

[David Carlson]

Adrian,

While I am not an accountant, historically I have used a method similar to
that suggested by Adrien.  However, I am intrigued by the answer provided
by Michael Novack, as it avoids the problem of overstating potentially
taxable income without needing to have a group of accounts to segregate
before running your tax reports at the end of the year.

Thus I am considering switching to a method modeled on his suggestion.

David C

On Thu, Dec 7, 2017 at 4:19 PM, Adrien Monteleone <
adrien.montele...@gmail.com> wrote:

> I have to concur on the $70 gift idea.
>
> You paid $430 for a stored value card that has $500 on it.
>
> This is no different than if you handed a bank teller $430 in small bills
> and they returned to you 5 one hundred dollar bills. (assuming the bank is
> just fine with that)
>
> When you spend $100 from this card you aren’t really spending $86. You’re
> spending $100.
>
> After you’ve spent $430, the next $70 on the card is a gift to you from
> whomever sold you the card.
>
> But you can’t truly determine which $70 is gift and which isn’t.
>
> The easiest and likely most correct transaction is this:
>
> Dr. Assets:Cash $430
> Dr. Income:Gift Received $70
> Cr. Assets:Prepaid Card $500
>
> When you use the card, all transactions are just normal as if you’d paid
> $500 for it.
>
> There is no discount. There is no rebate. You received a ‘gift’ of $70 in
> the form of extra stored value on the card.
>
> Had you paid nothing and received a card with a $70 value, the transaction
> would be:
>
> Dr. Income:Gift Received $70
> Cr. Assets:Prepaid Card $70
>
> Note, the difference is NOT the $70. The difference is what you paid for
> the extra value, in this case $430.
>
> Had you paid $430 for one card and the merchant gave you a separate card
> with $70 value on it (that’s two cards totaling $500) then your entries
> would be this:
>
> Dr. Assets:Cash $430
> Cr. Assets:Prepaid Card $430
>
> Dr. Income:Gift Received $70
> Cr. Assets:Prepaid Card $70
>
> There’s no fundamental difference in these two separate transactions than
> the combined transaction above. They record the same net amounts in the
> same places. The fact that all of this takes place on one card instead of
> two, or that the gift is from a merchant instead of a family member or
> friend does not change the nature of the transaction.
>
> You can record anything you want the way you want if this is just for you
> to keep track of, but the goal should always be to use transactions to show
> an accurate picture of what happened. What happened is NOT that you saved
> money on future purchases. What happened is you received a gift of $70 in
> the form of a stored value card.
>
> But by all means, ask a CPA if it’s that important to you.
>
> Regards,
> Adrien
>
> > On Dec 7, 2017, at 3:46 PM, nvsoar  wrote:
> >
> > On 12/06/17 12:44, adrian wrote:
> >> Tommy Trussell wrote
>  Adrian:
>  In the case at hand I spent $430 on the gift card and when I buy
>  something
>  that costs $100, I'm really only spending $86.  That's what makes
> sense
>  to
>  me for how this ought to be counted.   Since I don't know the
> category of
>  the expense in advance, I can't just put in a $70 offset unless I put
> it
>  as
>  "misc", in which case I lose track of some information about how I
>  allocated
>  my money.
> 
> >>> I went back to your original question (remember that this is NOT a
> forum
> >>> --
> >>> it's an email list that you're viewing through Nabble)
> >> Yeah, despite that I have been unable to actually subscribe to the list.
> >> But your point was you wanted more context, I suppose.
> >>
> >>
>  I bought a $500 gift card for $430 this week.  I would like to add
> this to
>  gnucash as some kind of asset so that as I spend it, the correctly
> scaled
>  amount gets transferred to the expense account I use.  In other
> words, if
>  I
>  spend $100 from this account it's really only $86.
> 
>  I tried to do this by creating a security fund and then using the
> price
>  editor to set the price to 0.86.  But when I insert a transaction from
>  the
>  new account to an expense account, it doesn't apply the 0.86 factor.
>  What
>  is the right way to do what I want to do?
> >>>
> >>> I think you have demonstrated the difficulty with what you're trying to
> >>> do-- you're trying to make a rebate card a different KIND of currency,
> >>> which in one sense, it is. HOWEVER every time you make a purchase from
> >>> that
> >>> card it will require a currency exchange, which adds a level of
> complexity
> >>> and may not produce the result you want.
> >>>
> >>> I'm sure you could make it work, but in the end, it's a lot easier to
> just
> >>> offset the $70 against the expenses. TECHNICALLY you don't get benefit
> of
> >>> the full amount you spent on the card until you have completely
> depleted
> >>> the value of the card, 

Re: GnuCash: Import CSV File Format

[David Carlson]

I don't think that there is a specification beyond the generic CSV format,
which is grouping chunks of text separated by commas into groups separated
by a carriage return.  Check with your favorite spreadsheet program for
help.

When you want to import a file into GnuCash you then assign 'columns' to
data during the import process.  You can assign a 'column' to each of the
commonly used used fields in a transaction record. The process does not
consider which account is the 'home' account, you just start in that
account when you import, if I recall

FYI it is very important to be consistent with the date format when
assigning a column to dates, as GnuCash is very fussy about M-D-Y vs
D-M-Y.

David C

On Thu, Dec 7, 2017 at 3:58 PM, Charles Sliger  wrote:

> Where can I find the file specification for creating a csv file to
> import transactions?
> --
> -chaz
> Charles Sliger
> "No matter where you go... There you are... Buckaroo Banzai"
>
>
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: What does "Update and Reconcile" update?

[David Carlson]

I always save the file just before importing so I can just close without
saving after an import if I don't like the result.

My experience has been that the U+R function in GnuCash adds something
either to the Description or to the Notes line besides changing the date
and possibly even the amount by a few cents in some cases, especially if it
is matching to the wrong transaction.  It may vary depending on what your
bank likes to put in to their data.

Because I am paranoid about matching to the wrong transaction I always
check that, correct the transfer account if it is incorrect and then either
use the Add or the Reconcile option.

David C

On Sun, Dec 10, 2017 at 10:57 AM, Donald Pellegrino <
donald.a.pellegr...@gmail.com> wrote:

> When importing transactions, the "Generic import transaction matcher"
> dialog provides "A," "U+R," and "R" columns. These columns each contain
> check-marks but are mutually exclusive in their selection. It is not clear
> to me which fields of the transaction will be changed, and in which ways,
> when "U+R" (Update and Reconcile) is selected instead of just "R"
> (Reconcile).
>
> For reference, I found an old post discussing the topic at
> https://lists.gnucash.org/pipermail/gnucash-user/2011-November/042039.html
> .
> However, I was unable to find a definitive documentation of the full
> process. As with the author of that old post, I am nervous to lose the
> Description content that I have entered.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Interesting Discovery in my accounts -- more info...

[David Carlson]

Jay,

My first thought is that sometime after you closed the books you probably
inadvertently entered additional transaction(s) dated before the closing
date.  Did you make an archive backup then that you can compare to your
balances as of that date in your current data?

If there were a very limited number of transactions you might be able to
determine whether they were erroneous and could (and should) be corrected.

David C

On Sat, Dec 2, 2017 at 4:32 PM, Jay Ridgley  wrote:

> On 12/02/2017 04:01 PM, Jay Ridgley wrote:
>
>> Good Afternoon,
>> I just discovered that in 2014 a number of my expense accounts were not
>> correctly closed (they had a balance other that ZERO)!
>>
>
> I have always closed my books at the end of an accounting period.
>
> However, upon further investigation, it appears that the 2013 close book
> transaction was not correctly performed.
>
> How that happened I have no idea. Most likely I did the close book for
> that year incorrectly and missed it. Is it recoverable? For instance can a
> close books be run with a date of 12/31/2013?
>
> I do not want to start over with a new set of books but I may have to do
> so.
>
>>
>> Questions that I have:
>>
>> 1. How did it happen?
>>
>
> See above
>
> 2. Has this happened to anyone else?
>> 3. How do I correct the problem?
>>
>> I can not go back and recreate 3 YEARS of data.
>>
>> Ideas...
>>
>> Regards,
>> Jay
>>
>
>
> --
> Jay Ridgley
> jridgley2 at austin.rr.com
> Registered Linux User ID - 9115
> https://linuxcounter.net/cert/9115.png
> Registered Ubuntu User ID - 23320
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Reconciliation Report

[David Carlson]

Adrien,

First, the reconciliation window does not have an option to show the
results of the reconciliation in a nice format 'Suitable for Framing".

Second, it does not have a feature to display results of previous
reconciliations, let alone have a way to correct errors in previous
reconciliations.

Third, there is no ability to add missing reconciliations in the past, as
well as no tracking of specific transactions being deleted or edited out of
the account by other actions on the data.

I think that your idea does have some merit, if it were possible to be
implemented.  I would like to see an ability to see which reconciliation a
particular transaction was a part of, for example, but I am not a
developer.  i think some changes have already been requested for
implementation.

David C


On Sun, Dec 3, 2017 at 9:32 AM, Adrien Monteleone <
adrien.montele...@gmail.com> wrote:

> Out of curiosity, how is this different from the reconciliation window
> itself? All of what has been listed in this thread is in that window. You
> can even jump to any transaction if you need more info to investigate
> something. You don’t have to close the window until you’re done. No adding
> machine tape is needed either. The window shows all relevant amounts and
> updates them as you mark items cleared or you unclear them.
>
> It seems to me the idea of a reconciliation report is trying to make
> GnuCash fit the old paper-books methods rather than utilizing the
> advantages of an electronic system.
>
> Regards,
> Adrien
>
> > On Dec 2, 2017, at 12:51 PM, C M Reinehr  wrote:
> >
> > The accounting software that I use to manage my business includes the
> following "Bank Reconciliation Report":
> >
> > 1)The bank balance as of the reconciliation date;
> >
> > 2)A list of currently unreconciled deposits & charges;
> >
> > 3)A subtotal of the above (2);
> >
> > 4)Followed by an "Adjusted Statement Balance" calculated by adding
> the above subtotal to the bank balance. This balance should be your
> register balance as of the reconciliation date or there is an error.
> >
> > This is essentially the procedure that is followed when reconciling your
> bank or credit card statement to your GNUCash register, just in the form of
> a printed report instead of an adding machine tape.
> >
> > I'm no expert at GNUCash but I haven't yet found any way to replicate
> this report in GNUCash but I think it would be a useful addition.
> >
> > HTH.
> >
> > CMR
> >
> >
> > On 11/30/2017 03:06 PM, Mike or Penny Novack wrote:
> >> On 11/29/2017 11:07 PM, Adrien Monteleone wrote:
> >>> Rick,
> >>>
> >>> Try the Transaction or Transaction by Payee report (the latter posted
> here on the list).
> >>>
> >>> You can show the Reconciled Date using the display tab in options,
> and/or sort by the reconciled date in the sorting tab.
> >>>
> >>> Unfortunately, I don’t think you can filter by
> reconciled/non-reconciled as the report currently stands.
> >>>
> >> Perhaps a more serious issue? Depending on what is meant by
> "reconciliation report".
> >>
> >> Rick, can you describe what your report is supposed to show? Let me
> explain. In the "old days" each month, when we got our bank statement, we
> "reconciled" the checking account. The bank statement showed the balance as
> of the close of the period and also all the deposits that the bank has
> during the period and all checks cleared during the period. Your books
> would have a bank account showing all deposits you made during the period
> and all checks written during the period and what you think the ending
> balance should be. Those two would normally NOT agree because:
> >> 1) A deposit made on the last day of the period might not be credited.
> >> 2) Some number of checks written during the period (or even from
> previous periods) not cleared yet.
> >>
> >> "1" rare but "2" the normal situation.
> >>
> >> So you took your balance and added to it all the checks that had not
> cleared (those NOT reconciled in the gnucash sense of "reconciled") and
> took the bank balance and added to it any deposit you made not shown on the
> bank statement and checked that those those two sums were equal.
> >>
> >> THAT what you mean?
> >>
> >> << I don't do any on-line banking (not over a dial-up connection OR a
> public access (unsecured) wifi) and the organizations for which I keep
> books have  a low enough volume of checks written each month that doing the
> old fashioned reconciliation no big chore to do that "report" by hand since
> not likely to be more than 2-3 uncleared checks >>
> >>
> >> If THAT is the report you require, unless you have a large number of
> checks still outstanding each period, automating the process perhaps a
> waste of time. So try to better describe what you have been asked to
> produce.
> >>
> >> Michael D Novack
> >>
> >>
> >>
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >> 

Re: Crashes importing CSV

[David Carlson]

Hi Phillip

I think that earlier versions would crash if the date format was not
correctly selected.

I am not sure if that has been fixed in the current release.

David C

On Oct 29, 2017 12:42 PM, "Phillip Gotobed"  wrote:

> Hello everyone,
>
> I've been using gnucash for a bit now and had no issues once I started to
> understand things but recently I tried importing CSV files, not for the
> first time, and gnucash crashed. Going through some previous suggestions
> I've tried re-saving the file, adding "," to the end of each line, removing
> extraneous information, etc and nothing seems to work. No matter what it
> crashes after I select which account to import transactions into. I also
> went back to the old file that I had succeeded in importing before to test
> it and that one also crashed the program now. I'm not sure what changed but
> if anyone has suggestions that'd be great; I'm at my end here.
>
> Thanks,
> Phillip
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: General Journal - history limit and search

[David Carlson]

Roger, for your second question, I think that a search in the General
ledger view should produce it's results in a new results view rather than
the first General Ledger view.

However, if I am wrong about that, it should be simple to open a new
General Ledger view from the menu.  You should not need to close the
previous results views unless you do not expect to go back to them and you
would rather have less clutter on your desktop.

David C

On Tue, Oct 31, 2017 at 12:23 PM, Roger Oliver  wrote:

> Perfect. Thanks
>
> On Oct 31, 2017 11:08 AM, "Aaron Laws"  wrote:
>
> > On Tue, Oct 31, 2017 at 12:39 PM, Roger Oliver 
> wrote:
> >
> >> I notice my general journal only goes back to the beginning of Octuber.
> >> Transactions from September don't show. A search by date doesn't find
> any
> >> transactions earlier than October either. Is there a setting I'm
> >> overlooking to include everything in the general journal?
> >>
> >> Also, when I search the general journal the results are shows in the
> same
> >> journal, not in another register. Don't know how to get the general
> >> journal
> >> back to showing all the transactions. I just close it and open the
> general
> >> journal again from the tools menu. Is there a better way? Something I'm
> >> not
> >> doing correctly in the search criteria window?
> >>
> >> Thanks,
> >> Roger
> >
> >
> > With the General Ledger open, click "View" then "Filter By..." and adjust
> > the filter to your liking. It doesn't remember this setting, so you'll
> have
> > to do it any time you close then reopen gnucash.
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: New User to GnuCash

[David Carlson]

Jack

Look under Edit>Preferences>Register>Register Defaults>Register Opens in a
New Window..  I tink that box should be unchecked by default, but it may
have changed.  I think that setting goes with the data file, so it may be
different in different files.

David C

On Wed, Dec 20, 2017 at 11:25 AM, Jack Slater 
wrote:

> Derek - Thx for this detailed suggestion. The light bulb is going on now
> and cleaning up the "view" helps a lot!
>
> I have another question.
>
> When I have opened 3 sub-account windows - they are all "pinned" in the
> same window pane as the main Accounts window pane - a tabbed approach. But
> from that point, any other sub accounts that I double click to open - will
> open in an individual/separate/apart window instead of adding to the tabbed
> view with the others. Hope this makes sense!  Would there be a limit on
> tabbed accounts you can open?
>
> On Fri, Dec 15, 2017 at 9:46 AM, Derek Atkins  wrote:
>
> > Hi Jack,
> >
> > Jack Slater  writes:
> >
> > > I think I'm getting that understanding a little bit. Thanks!
> > >
> > > Debit Checking Account - Credit Rent - paying a bill and knowing why
> > (even
> > > though in my Quicken mind the Rent account is just a category)
> > >
> > > I found a Transfer transaction on the tool bar that accommodates the
> type
> > > of transfer I am used to, i.e.:
> > >
> > > Debit Checking Account - Credit Visa Account - paying a bill
> > >
> > > In a perfect world, I'd sure like to use GC the same way.  Maybe with
> all
> > > the help and usage I'll get there.
> >
> > You can easily restructure your account hierarchy by editing your
> > accounts and reassigning them to new parent accounts.  For example, if
> > you look at the default account structure that you could create via File
> > -> New File and creating a set of empty accounts, it will look something
> > like:
> >
> > Assets/
> >Current Assets/
> >   Bank/
> >  Checking
> >  Savings
> >   Cash
> >Fixed Assets/
> >   Car
> >   House
> > Liabilities/
> >Credit Card
> >Mortgage
> > Equity/
> >Opening Balances
> > Income/
> >Salary
> > Expenses/
> >Groceries
> >Rent
> >Utilities/
> >   Electricity
> >   Gas
> >   Internet
> >   Phone
> >
> > Most likely all your Income/Expense accounts got flattened because
> > Quicken generally doesn't create a hierarchy like this.  But GnuCash
> > can.
> >
> > All you need to do is select an account in the CoA, click on Edit, and
> > then you can reassign to a new parent.  Note that the parent must
> > already exist.  So if you create a top-level Expenses account, then you
> > can assign Groceries and Rent to that.  Similarly, if you create
> > Expenses:Utilities then you can put the other accounts under that.
> >
> > This will help clean up your accounts.
> >
> > There is another option: You can start over.  Run the File -> New File,
> > create an empty set of accounts, and then, during the QIF Import from
> > Quicken, assign each of the QIF Accounts and Categories to the correct
> > GnuCash Account.  This will properly populate the hierarchy as you
> > desire.
> >
> > Hope this helps!
> >
> > -derek
> >
> > > On Thu, Dec 14, 2017 at 2:38 PM, Mike or Penny Novack <
> > > stepbystepf...@dialup4less.com> wrote:
> > >
> > >> On 12/14/2017 2:10 PM, Jack Slater wrote:
> > >>
> > >>> I think I get what your saying and at this point (a) I have no clue
> > how to
> > >>> manage/edit/adjust what I have to that type of structure nor (b) do I
> > know
> > >>> enough yet to feel confident in making any changes! LOL..
> > >>>
> > >>> I'm reconciling my November statement as we "speak" and had to add a
> > few
> > >>> account transfer entries - that in Quicken would credit 1 account and
> > >>> automatically debit the transfer account. I have non idea how/if I
> can
> > do
> > >>> that in GC!?
> > >>>
> > >>> Any pointers/help is gladly and thankfully accepted!
> > >>>
> > >>> On Thu, Dec 14, 2017 at 12:53 PM, Fross, Michael 
> > >>> wrote:
> > >>>
> > >>
> > >> When you are entering transactions (of any sort) in gnucash or any
> other
> > >> double entry package you are always debiting one account (or accounts)
> > and
> > >> crediting one account (or accounts). Whether the second account is
> being
> > >> debited or credited will depend on what you are doing in the first
> > account
> > >> (the one you are entering the transactions from). THAT is automatic
> > using
> > >> gnucash.
> > >>
> > >> << the plurals above refer to split transactions which you will learn
> > >> about later >>
> > >>
> > >> Michael
> > >> ___
> > >> gnucash-user mailing list
> > >> gnucash-user@gnucash.org
> > >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > >> -
> > >> Please remember to CC this list on all your replies.
> > >> You can do this by using Reply-To-List 

Re: [GNC] VISA Debit Card was gnucash-user Digest, Vol 182, Issue 8

[David Carlson]

On Mon, May 7, 2018 at 1:32 AM, Karen Stingel 
wrote:

>How does gnc handle the Case of a VISA Debit card?
>Technically, this is a BANK account with a VISA enabled card and a
>$0.00 Credit Limit
>Should it just be created as a normal BANK account type?
>Are there any plans to include this as a new Asset Account type in
>future editions of gnc?
>Are Python Bindings enabled in the Windows binaries, and could this
>Account type be added via writing a Python script?
> ___
> 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.
>

Karen,

I do not give my debit card an account because I just use it as a plastic
checkbook on my checking account.  Thus I just enter a transaction from the
checking account, using a keyword 'Debit' in the check number box.

David C
___
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] Tax Report Options not working

[David Carlson]

 Tom ,  Since you are using Windows 10 the issue must be a Windows thing.
Are you using the official release or one of the nightly builds?

I don't know if the developers would suggest trying one of them for this
issue, but I see that there is a May 6 build in the nightly directory. <
https://code.gnucash.org/builds/win32/maint/> I guess I would stay with
2.6.21 for a while.

David C

On Tue, May 8, 2018 at 3:43 PM, Geert Janssens 
wrote:

> Tom,
>
> I'm glad you got it working.
>
> I have just tried this on my Fedora linux system and there the tax entries
> do
> stick. I tried with both an xml based file and a sqlite3 based one.
>
> So I don't know why it's not on your system.
>
> Geert
>
> Op dinsdag 8 mei 2018 22:29:56 CEST schreef Tom Charles:
> > Thanks David!  I downgraded to version 2.6.21 and IT WORKS!!!, i.e. the
> > entity type now "sticks" and I can run the report just fine!
> >
> > Must be a bug in the v3.x version for Windows 10.
>
>
>
>
___
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] Data format compatibility between recent versions

[David Carlson]

We need clarification on this because I recall seeing that files touched by
testing releases in the 2.7 group and 3.0 and 3.1 were changed so they were
no longer readable by releases prior to 2.6.21.

David C

On Mon, May 14, 2018 at 2:45 PM, John Pastore  wrote:

> I reviewed FAQ section 3.3, but it does not cover more recent versions of
> Gnucash.
>
> I use Gnucash 3.1 on Windows (7) and Gnucash 2.6.12 on Linux (Ubuntu 16.04
> LTS), soon to transition to 2.6.19 on Ubuntu 18.04 LTS.
>
> Data file portability appears to be fine in both directions, but I just
> want to make sure there are no specific cases that might result in data
> file corruption.
>
> Any advice much appreciated!
>
> John
> ___
> 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] how do I get different dates for balancing transactions when transferring amounts between two accounts

[David Carlson]

We all have our own definition of the the best way to handle these 'float'
issues.  While most of us simply choose to let the date be technically
incorrect in some accounts, others create what I believe are called
'suspense' accounts to serve as containers for the 'float'.

Those accounts could be asset type or liability type and they usually are
given a name that strongly suggests their purpose as a temporary holding
account.

David C

On Mon, May 14, 2018 at 5:19 PM, RL  wrote:

> I have two bank accounts on which I regularly write checks to transfer
> amounts between them. Downloading the ofx files from each bank, I have,
> for those checks, transactions with different (correct) dates in each GC
> account which represent the left and right side of the same accounting
> transaction. For purposes of reconciling against the bank statements,
> these dates must remain different in their separate GC accounts, even
> though they are opposite ends of the same accounting transaction.
>
> GC wants to make the balancing transactions in each GC account one
> single identical transaction (except for the proper credit/debit column,
> depending on which account I'm looking at). I don't see how to work this
> and maintain both accounts true to their source, the bank transactions.
> The date is also important because at times it matters when a check was
> cashed and when it was payed by the originating bank; there needs to be
> an accurate record of this. An additional, maybe lesser, problem is that
> GC's methodology makes the transaction number the same in each GC
> account. Since the trans number is one of the most easily noted text
> fields, I have been using it to quickly/easily identify "deposits" - but
> this won't work if I want to retain the check number in that field (very
> important). Also, a check number on a deposit line doesn't seem
> particularly proper.
>
> How is this handled in GC?
>
>
> Thanks
> Rufus
> ___
> 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] Data format compatibility between recent versions

[David Carlson]

John,

I was not clear.  I really wanted clarification from the developers.  I
suspect that you may not be using features that are not compatible between
the versions as I know that there are some features that are not backward
compatible.

David C

On Mon, May 14, 2018, 7:59 PM John Pastore <jrpast...@gmail.com> wrote:

> Not sure if you meant you need clarification from ME or ...?
>
> Anyway, here's my history:
>
> 1) Created original data file using GNC 2.6.12 on Ubuntu 16.04 LTS
>
> 2) Months later installed GNC 2.6.19 on Win 7 and copied datafile from #1
> with no issues.
> - this datafile included (1) monthly scheduled transaction and about (20)
> securities each with about (5) manual price history updates
>
> 3) Weeks later installed GNC 3.1 on Win 7 and used same datafile from #2
> with no issues.
>
> 4) Weeks later got Finance::Quote automatic price updates working via
> AlphaVantage on #3.
>
> 5) Days later copied datafile from #4 back to GNC 2.6.12 on Ubuntu.
> Everything looked fine including:
> - scheduled transaction notice for monthly transaction whose date had
> since passed by
> - price history for all securities including more recent entries from
> Finance::Quote
> - security details including (to my surprise) updated source for online
> updates to "Unknown:AlphaVantage" from "Single:Vanguard" (which had never
> worked) for all (20) securities.
>
> 6) Days later (just now) copied most recent datafile from #4 back to GNC
> 2.6.12 on Ubuntu just to see if prior success had been a fluke.  Everything
> still looks fine.
>
> Hope this history is helpful.
>
> John
>
> On Mon, May 14, 2018 at 6:22 PM, David Carlson <
> david.carlson@gmail.com> wrote:
>
>> We need clarification on this because I recall seeing that files touched
>> by testing releases in the 2.7 group and 3.0 and 3.1 were changed so they
>> were no longer readable by releases prior to 2.6.21.
>>
>> David C
>>
>> On Mon, May 14, 2018 at 2:45 PM, John Pastore <jrpast...@gmail.com>
>> wrote:
>>
>>> I reviewed FAQ section 3.3, but it does not cover more recent versions of
>>> Gnucash.
>>>
>>> I use Gnucash 3.1 on Windows (7) and Gnucash 2.6.12 on Linux (Ubuntu
>>> 16.04
>>> LTS), soon to transition to 2.6.19 on Ubuntu 18.04 LTS.
>>>
>>> Data file portability appears to be fine in both directions, but I just
>>> want to make sure there are no specific cases that might result in data
>>> file corruption.
>>>
>>> Any advice much appreciated!
>>>
>>> John
>>> ___
>>> 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] Tax Report Options not working

[David Carlson]

I cannot say whether version 3.x is different as I have not tried that, but
in the 2.6.x versions it is necessary  to use the tax report options
configuration to assign a tax form, line number and copy number to each tax
worthy account individually before it will appear in the Tax report.  Since
it is impossible to do this to more than one account at a time, it is very
tedious to set up initially, but it is nice once it is working.  In my case
I am in the US and using the US forms. I started with accounts that are
assigned to the basic income lines on the 1040 form.  If your tax situation
involves as many forms and lines as mine, it will probably take several
trials to find all the accounts that are tax worthy and get them correctly
assigned.

Once you feel that you are close you can check the Tax Info Column in the
Chart of Accounts to verify whether any given account is configured for the
tax report.

Since you state that you did those things but the information is not
'sticking', that is probably a bug in the 3.x release.  I know that others
have reported bugs with various reports in v3.x

Lets hear from others who have migrated with a previously configured tax
report.

David C

On Mon, May 7, 2018 at 10:52 PM, Tom Charles  wrote:

> Hello,
>
> I am using v3.1 of GNUCash and I  am try to set up the Tax Schedule Report
> and cannot figure out why I cannot get the report to run and give me the
> expected data.   The message I get is the following:
>
> Period from 2018-Jan-01 to 2018-Dec-31
> Tax Year 2018
> Tax Entity Type: *None specified*
>  All amounts in USD unless otherwise noted
> The Income Tax Report is only available for valid Income Tax Entity
> Types. Go to the Edit->Tax Report Options dialog to change your Income Tax
> Entity Type selection and set up tax-related accounts.
>
> I did use the Edit->Tax Report Options to set the tax related information
> for my accounts.
>
> In the dialog box I select Edit. Then I set the "Type" to "Individual,
> Joint, etc. - Files US Form 1040 Tax Return", then clicked apply.
> I then went through and for each account that I wanted in the report I
> selected the "Tax Related" box, then selected the TXF category for each. I
> then clicked OK.
>
> I noticed when I looked at the accounts in the "Accounts" page it stated
> (under the "Tax Info" heading) for each account that the "Tax Entity Type
> was not specified" for every account I set up.  This seems to relate to the
> notice I get when I run the report.
>
>
> What am I missing? Any help would be much appreciated!
>
> Thanks in advance!
> Tom
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
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] 3.1 + Win10, TIME it takes to SAVE

[David Carlson]

That's still better than 2.6.xx releases in Windozezzz

David C

On Sun, May 13, 2018, 2:36 PM randix  wrote:

> Saw the SAVE AS issue in 3.1+Win10, but in a quick search, didn't see this
> (apologize if I missed it)...
>
> Using 3.1 + Windows 10, why does it now take 2-3 minutes (literally) just
> to
> do a simple save?  It's not the end of my world, but...
>
>
>
> --
> 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.
>
___
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.