Re: [GNC] QIF Import Problem

2019-08-04 Thread David T. via gnucash-user
... And I have none of these problems with 13 years of history. No lags, 
loading, while slow, has neither decreased nor increased over the years 
with a growing file size. YMMV, but I've used both Mac versions, and now 
the Windows version (currently 3.5).


I've said it before, but it bears repeating. When I imported many years 
ago, I exported everything from Quicken into GnuCash in one grand pass. 
GnuCash set up the accounts based on the transactions and picked up the 
matching sides of transfers such as the OP mentioned.


David T.

On 8/5/2019 2:38 AM, David Carlson wrote:

I would suggest that it would probably create a very ponderous data file to
cover 15 years' data.  I have 10 years' history in my current file and I
regret putting so much into one file, as it generates lags of several
seconds for some very common operations, and minutes to open or close..

I would suggest at most one or two years of history for your GnuCash file.
Then the one-account-at-a-time procedure is not so overwhelming.

I think, but I am not sure, that Quicken will continue to work off-line if
you want to review older history in the future.

David Carlson

On Sun, Aug 4, 2019 at 2:53 PM Colin McLellan 
wrote:


Hi,

I'm trying to switch to GnuCash from Quicken 2016 and I'm running into a
problem where all transfers between accounts are duplicated after the QUF
import.  I am aware that this is not a new problem and I have read meany
threads on here going back at least ten years about this.

I tried exporting just one month of my chequing and savings accounts to
separate QIF files and then importing them into GnuCash simultaneously and
separately.  In each case, 100% of the time all transfers between the
accounts are duplicated in each account.  Whatever is supposed to be
flagging these duplicates is not working.  If I do them separately, I do
get the option to select the duplicates, but ultimately I want to import
the past 15 years of transaction level detail, and I am not willing to go
the manual route.

My question is: Is there any new information about a solution to this
problem?

Thanks,

Colin
___
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] QIF Import Problem

2019-08-04 Thread Christopher Lam
Hi I'm currently looking at the QIF importer and would be grateful for a
sample datafile that contains data between matching accounts. Would you
mind sending me a small QIF? eg. a couple days' worth of data.

On Sun, 4 Aug 2019 at 19:52, Colin McLellan 
wrote:

> Hi,
>
> I'm trying to switch to GnuCash from Quicken 2016 and I'm running into a
> problem where all transfers between accounts are duplicated after the QUF
> import.  I am aware that this is not a new problem and I have read meany
> threads on here going back at least ten years about this.
>
> I tried exporting just one month of my chequing and savings accounts to
> separate QIF files and then importing them into GnuCash simultaneously and
> separately.  In each case, 100% of the time all transfers between the
> accounts are duplicated in each account.  Whatever is supposed to be
> flagging these duplicates is not working.  If I do them separately, I do
> get the option to select the duplicates, but ultimately I want to import
> the past 15 years of transaction level detail, and I am not willing to go
> the manual route.
>
> My question is: Is there any new information about a solution to this
> problem?
>
> Thanks,
>
> Colin
> ___
> 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] QIF Import Problem

2019-08-04 Thread David Carlson
I would suggest that it would probably create a very ponderous data file to
cover 15 years' data.  I have 10 years' history in my current file and I
regret putting so much into one file, as it generates lags of several
seconds for some very common operations, and minutes to open or close..

I would suggest at most one or two years of history for your GnuCash file.
Then the one-account-at-a-time procedure is not so overwhelming.

I think, but I am not sure, that Quicken will continue to work off-line if
you want to review older history in the future.

David Carlson

On Sun, Aug 4, 2019 at 2:53 PM Colin McLellan 
wrote:

> Hi,
>
> I'm trying to switch to GnuCash from Quicken 2016 and I'm running into a
> problem where all transfers between accounts are duplicated after the QUF
> import.  I am aware that this is not a new problem and I have read meany
> threads on here going back at least ten years about this.
>
> I tried exporting just one month of my chequing and savings accounts to
> separate QIF files and then importing them into GnuCash simultaneously and
> separately.  In each case, 100% of the time all transfers between the
> accounts are duplicated in each account.  Whatever is supposed to be
> flagging these duplicates is not working.  If I do them separately, I do
> get the option to select the duplicates, but ultimately I want to import
> the past 15 years of transaction level detail, and I am not willing to go
> the manual route.
>
> My question is: Is there any new information about a solution to this
> problem?
>
> Thanks,
>
> Colin
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Last month's transactions included in Reconciliation Report

2019-08-04 Thread Adrien Monteleone
It seems to me like Dale mentioned, what you want is in fact presented as the 
Reconcile window in GnuCash, rather than a printed report. The Report is for 
after the reconcile is done, though I suppose you could use the unreconciled 
portion for a future statement comparison when reconciling.

To explain the report more:

If you reconciled transactions from June in your July reconciliation, then yes, 
they should appear in the July Reconciliation Report because they are part of 
the formula that got you from the balance on 6/30/19 to the balance on 7/31/19. 
And they should also show up as cleared in July on your statement from the bank.

If you reconciled transactions in June in the June reconciliation, they should 
not show up in a report for a July Reconciliation, as they aren’t part of that 
calculation.

If they *are* showing up in that case, you might have a bug, but I can’t seem 
to reproduce it in my test. (or my usual workflow)

The report can give you both the a), b) & c) sections you want.

On the Filter tab, set `Reconcile Status` to “All”

Be sure on the Display tab to check both `Date` and `Reconcile Date` and 
`Totals`

On the Sorting tab, set your `Primary Key` to “Reconciled Status”, check 
`Primary Subtotal`, set `Secondary Key` to “Date” and make sure `Secondary 
Subtotal for Date Key` is set to “None”.

Now you should get a report for the time period specified in the General tab, 
that first shows all transactions reconciled during that time period, 
regardless of their actual transaction dates. This will be followed by a 
subtotal of those transactions.

The next section will be a chronological listing of all outstanding 
transactions that have not been reconciled with another subtotal.

The Grand Total at the bottom will be the sum of the two subtotals, that is, 
the sum of debits/credits for the report date range.

The reason for selecting both “Date” and “Reconciled Date” is this will both 
make clear what the report is doing, and maybe expose an error.

If you really want a printed report rather than a window to work from, (you 
still have to use the window to perform the task) then set `Reconciled Status` 
to “Unreconciled” and you’ll get just those transactions that still need to be 
matched up. I don’t think you can restrict these by date. You’ll get all of 
them. (helpful if you see one from the past that should have been reconciled, 
but messy if you’re behind several months on reconciliation) At the least, you 
can specify “Monthly” as the `Secondary Subtotal for Date Key` to divide them 
up. You could also make “Date” the primary key since you’re only dealing with 
unreconciled transactions in this case.

Finally with regards to ‘Reconcile Date’ perhaps being a source of the problem, 
my understanding is this date is the one you choose for the closing date, not 
the actual calendar date you happen to perform the reconciliation. (at least it 
should be) If instead, it is tagging transactions that you reconciled with a 
closing date of June 30th as being reconciled on July 3rd, then yes, that is a 
bug. But all of my reconciliation reports display the closing date as the 
reconciliation date for me. So I can’t reproduce that one either. (and I might 
perform the actual reconciliation on any old day of the month)

Regards,
Adrien

> On Aug 4, 2019, at 1:42 PM, Art Chimes  wrote:
> 
> Thanks for the responses.
> 
> Adrien asks, "why are you wanting this report?" Partly it's about
> having another piece of a paper trail, but mainly because it's what
> I've been doing in Quicken for a couple of decades.
> 
> To be clear, this is just about my personal finances: checking
> account, credit cards, and so on. Nothing that will be audited, nor
> likely requested by an accountant. What I am used to
> seeing in a reconciliation report is (a) a list of cleared
> transactions for the period covered by the current statement, the one
> I have just reconciled; and (b) a list of transactions that remain
> uncleared after the reconciliation process; and (c) various totals and
> summaries.
> 
> Item (b) would ideally consist of transactions since the statement
> closed, an uncashed check I wrote two months ago, etc.
> 
> When I specify a date range, Gnucash wants to look at both the
> transaction date AND the reconciliation date. So I am getting two
> months' transactions in the report, one of which is just clutter and
> will duplicate the prior month's reconciliation report.
> 
> If my latest statement includes 15 transactions between July 1 and
> July 31, when it closes, that time period will include the day (e.g.
> July 3) that I reconcile the June statement. But the June transactions
> are history; they have no business in the July reconciliation report.
> I'm not an accountant for sure, but if there is a reason for including
> in the report the June transactions *reconciled* in July along with
> the actual July transactions, I don't see it.
> 
> The suggestion that I filter for a date rang

Re: [GNC] Struggling with Export/Import of Accounts

2019-08-04 Thread Adrien Monteleone


> On Aug 4, 2019, at 12:23 PM, Michael Hendry  wrote:
> 
>> On 4 Aug 2019, at 16:32, Adrien Monteleone  
>> wrote:
>> 
>> I’ve had no issue exporting and importing an account tree myself.
>> 
>> I see you’re using a comma as part of an account name. While changing the 
>> separator and using quotes should work, I try to avoid commas in CSV data as 
>> a rule.
>> 
>> Try using something else like `-` (hyphen), `–` (en dash), `—` (em dash), 
>> `~` (tilde), or `_` (underscore) and see if that works without quotes and 
>> with the standard comma separator or CamelCase the names if that isn’t an 
>> eye sore for you.
> 
> That worked!
> 
> I restricted myself to changing one name, replacing the comma with an 
> underscore, and edited the exported file with MacVim so as so import only 
> that account name and all went well!
> 
> I plan now to investigate the mass-production of multiple identical 
> transactions such as annual subscriptions by editing the CSV file in MacVim. 
> This way I can keep the monitoring of such payments within GC, with the 
> simple recording of the receipt of a cheque updating that individual’s 
> account.

I would suspect a macro of vim script could handle that easily as could macros 
in a spreadsheet.
> 
> Many thanks,
> 
> Michael
> 
> PS My first attempt at importing the whole membership list failed, even 
> though I’d replaced the “, “ with “_” in the account names. I had a suspicion 
> this might relate to an e-acute (“é”) in a member’s name, and replacing this 
> with a plain “e” worked the trick.
> 
>> 
>> Note, I’d suspect a bug, but maybe there is a good reason why it failed. 
>> Hopefully someone more familiar with the importer’s quirks will chime in.
> 
> The failure to handle UTF-8 characters looks like a bug to me.

Yep. I’d file that one. If it isn’t designed to handle them on purpose, then at 
least as an RFE.

Regards,
Adrien

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] followup about 'how to remember an interest account'

2019-08-04 Thread Adrien Monteleone
Ah, sorry I wasn’t reading carefully enough.

So both accounts are defaulting to the Savings account?

I just did my own test with a bank account and reconciling. While it did 
remember I had entered interest in the previous reconcile and brought up the 
window automatically, it defaulted to the same account for the ‘From’ panel 
when it should have defaulted to the one used last. And for the record, on the 
first reconcile, I chose an income account. So it isn’t like it wasn’t 
remembering it because of an errant expense account selection.

I’d file a bug report for the inconsistent behavior.

Regards,
Adrien

> On Aug 4, 2019, at 12:17 PM, Paul Kinzelman  wrote:
> 
> Thanks for the tip about not changing the subject.
> 
> As I said below, both the windows, "Payment From"
> (which should highlight the interest account I used last month)
> and the "Reconcile Account" (the account I'm reconciling - the savings 
> account)
> highlight the same account that I'm trying to reconcile.
> I always have to manually highlight the Income Interest account.
> 
> That highlight is correct for the "Reconcile Account", but it's not
> the correct account for the "Payment From" window. That one
> should be the interest account, which should be the same one
> that I used the last month.
> 
> On 8/4/2019 10:00 AM, gnucash-user-requ...@gnucash.org wrote:
>> Here is info from the Help Manual Chapter 5:
>> 
>> "The Payment From pane contains a list of accounts where you can select the 
>> source account.
>> 
>>  Note
>> If the payment is for a credit or loan account then usually the payment 
>> would be from an Expense account. If the payment is for a checking or 
>> savings account then usually this would be from an Income account.?
>> 
>> What is the incorrect account that the window is preselecting? Is it an 
>> income account?
>> 
>> Savings accounts usually earn interest, while credit accounts usually cost 
>> you interest.
>> 
>> -
>> 
>> Also, please when sending a ?follow up? like you did here, do not change the 
>> subject line, just reply to the same thread. Otherwise, you end up with two 
>> threads neither of which have all the info in them. Someone might not see 
>> one or the other when replying.
>> 
>> Regards,
>> Adrien
>> 
>>> On Aug 4, 2019, at 9:40 AM, Paul Kinzelman  wrote:
>>> 
>>> Sorry, I should have included this more specific info...
>>> 
>>> In the 'Payment Information" window,
>>> the "Payment From" and "Reconcile Account" are always
>>> initially the same account which is not very useful.
>>> 
>>> The previous month I reconciled the same account and
>>> under "Payment From"  I selected the interest account, but
>>> the following month it goes back to initially selecting the
>>> same account as is in the "Reconcile Account" window
>>> and I have to select the desired account again every month.
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] QIF Import Problem

2019-08-04 Thread Colin McLellan
Hi,

I'm trying to switch to GnuCash from Quicken 2016 and I'm running into a
problem where all transfers between accounts are duplicated after the QUF
import.  I am aware that this is not a new problem and I have read meany
threads on here going back at least ten years about this.

I tried exporting just one month of my chequing and savings accounts to
separate QIF files and then importing them into GnuCash simultaneously and
separately.  In each case, 100% of the time all transfers between the
accounts are duplicated in each account.  Whatever is supposed to be
flagging these duplicates is not working.  If I do them separately, I do
get the option to select the duplicates, but ultimately I want to import
the past 15 years of transaction level detail, and I am not willing to go
the manual route.

My question is: Is there any new information about a solution to this
problem?

Thanks,

Colin
___
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] FX fetching strangeness

2019-08-04 Thread John Ralls
Do you have an Alphavantage key set in $ALPHAVANTAGE_API_KEY (for command line 
tools like gnc-fq-dump) and in Preferences>Online Quotes (for GnuCash's 
internal use)?

Regards,
John Ralls


> On Aug 4, 2019, at 11:45 AM, Jeff Abrahamson  wrote:
> 
> I'm using gnucash 3.4 and Finance::Quote 1.47 on linux (ubuntu 19.04). 
> I'm trying to get FQ to work for me.
> 
> When I enter a dual-currency transaction, the quote editor pops up.  If
> I touch the "fetch rate" button, I see a dialog that says "unable to
> retrieve quotes for these items: CURRENCY:CHF" and three other currencies.
> 
> I have precisely those four currencies in use, though I'm a bit confused
> why FQ would have tried to fetch all four at once when I only needed
> one.  I'm also confused why it found none.
> 
> Based on a conversation on this list in 2018, I tried this:
> 
>jeff@birdsong:~ $ gnc-fq-dump currency USD EUR
>1 USD =  EUR
>jeff@birdsong:~ $ gnc-fq-dump alphavantage USD EUR
>Finance::Quote fields Gnucash uses:
>symbol: USD (deduced)<=== required
>  date: ** missing **<=== recommended
>  currency: ** missing **<=== required
>  last:  <=\  
>   nav:  <=== one of these
> price:  <=/   
>  timezone:  <=== optional
> 
>** This stock quote cannot be used by GnuCash!
> 
>=
> 
>Finance::Quote fields Gnucash uses:
>symbol: EUR (deduced)<=== required
>  date: ** missing **<=== recommended
>  currency: ** missing **<=== required
>  last:  <=\  
>   nav:  <=== one of these
> price:  <=/   
>  timezone:  <=== optional
> 
>** This stock quote cannot be used by GnuCash!
> 
>jeff@birdsong:~ $
> 
> Any suggestions on what to do or what to test?
> 
> -- 
> 
> Jeff Abrahamson
> +33 6 24 40 01 57
> +44 7920 594 255
> 
> http://p27.eu/jeff/
> http://transport-nantes.com/
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
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] Last month's transactions included in Reconciliation Report

2019-08-04 Thread Dale Alspach
What you seem to be asking for is what happens when you click on
Reconcile except that it is a window that opens not a report. This also
has the advantage that you can go back to the account and add missed
transactions. These will immediately appear in the reconciliation window.

Dale

On 8/4/19 1:42 PM, Art Chimes wrote:
> Thanks for the responses.
> 
> Adrien asks, "why are you wanting this report?" Partly it's about
> having another piece of a paper trail, but mainly because it's what
> I've been doing in Quicken for a couple of decades.
> 
> To be clear, this is just about my personal finances: checking
> account, credit cards, and so on. Nothing that will be audited, nor
> likely requested by an accountant. What I am used to
> seeing in a reconciliation report is (a) a list of cleared
> transactions for the period covered by the current statement, the one
> I have just reconciled; and (b) a list of transactions that remain
> uncleared after the reconciliation process; and (c) various totals and
> summaries.
> 
> Item (b) would ideally consist of transactions since the statement
> closed, an uncashed check I wrote two months ago, etc.
> 
> When I specify a date range, Gnucash wants to look at both the
> transaction date AND the reconciliation date. So I am getting two
> months' transactions in the report, one of which is just clutter and
> will duplicate the prior month's reconciliation report.
> 
> If my latest statement includes 15 transactions between July 1 and
> July 31, when it closes, that time period will include the day (e.g.
> July 3) that I reconcile the June statement. But the June transactions
> are history; they have no business in the July reconciliation report.
> I'm not an accountant for sure, but if there is a reason for including
> in the report the June transactions *reconciled* in July along with
> the actual July transactions, I don't see it.
> 
> The suggestion that I filter for a date range (e.g. July 1-31) and for
> reconciled transactions, then generate an Account Report would give me
> a list of current reconciled transactions, but not the unreconciled
> ones. (Yes, I could generate a separate report with a filter, but that
> is an inelegant workaround, in my opinion.)
> 
> Regarding Christopher's reference to "standard accounting practice," I
> want to emphasize that I don't know what is standard, just what seems
> logical, familiar, and useful to me. Nevertheless, I am going to
> follow his suggestion and file a bug report suggesting an Enhancement
> to the reconciliation report dialog.
> 
> Thanks,
> Art
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] FX fetching strangeness

2019-08-04 Thread Jeff Abrahamson
I'm using gnucash 3.4 and Finance::Quote 1.47 on linux (ubuntu 19.04). 
I'm trying to get FQ to work for me.

When I enter a dual-currency transaction, the quote editor pops up.  If
I touch the "fetch rate" button, I see a dialog that says "unable to
retrieve quotes for these items: CURRENCY:CHF" and three other currencies.

I have precisely those four currencies in use, though I'm a bit confused
why FQ would have tried to fetch all four at once when I only needed
one.  I'm also confused why it found none.

Based on a conversation on this list in 2018, I tried this:

jeff@birdsong:~ $ gnc-fq-dump currency USD EUR
1 USD =  EUR
jeff@birdsong:~ $ gnc-fq-dump alphavantage USD EUR
Finance::Quote fields Gnucash uses:
    symbol: USD (deduced)    <=== required
  date: ** missing **    <=== recommended
  currency: ** missing **    <=== required
  last:  <=\  
   nav:  <=== one of these
 price:  <=/   
  timezone:  <=== optional

** This stock quote cannot be used by GnuCash!

=

Finance::Quote fields Gnucash uses:
    symbol: EUR (deduced)    <=== required
  date: ** missing **    <=== recommended
  currency: ** missing **    <=== required
  last:  <=\  
   nav:  <=== one of these
 price:  <=/   
  timezone:  <=== optional

** This stock quote cannot be used by GnuCash!

jeff@birdsong:~ $

Any suggestions on what to do or what to test?

-- 

Jeff Abrahamson
+33 6 24 40 01 57
+44 7920 594 255

http://p27.eu/jeff/
http://transport-nantes.com/

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Last month's transactions included in Reconciliation Report

2019-08-04 Thread Art Chimes
Thanks for the responses.

Adrien asks, "why are you wanting this report?" Partly it's about
having another piece of a paper trail, but mainly because it's what
I've been doing in Quicken for a couple of decades.

To be clear, this is just about my personal finances: checking
account, credit cards, and so on. Nothing that will be audited, nor
likely requested by an accountant. What I am used to
seeing in a reconciliation report is (a) a list of cleared
transactions for the period covered by the current statement, the one
I have just reconciled; and (b) a list of transactions that remain
uncleared after the reconciliation process; and (c) various totals and
summaries.

Item (b) would ideally consist of transactions since the statement
closed, an uncashed check I wrote two months ago, etc.

When I specify a date range, Gnucash wants to look at both the
transaction date AND the reconciliation date. So I am getting two
months' transactions in the report, one of which is just clutter and
will duplicate the prior month's reconciliation report.

If my latest statement includes 15 transactions between July 1 and
July 31, when it closes, that time period will include the day (e.g.
July 3) that I reconcile the June statement. But the June transactions
are history; they have no business in the July reconciliation report.
I'm not an accountant for sure, but if there is a reason for including
in the report the June transactions *reconciled* in July along with
the actual July transactions, I don't see it.

The suggestion that I filter for a date range (e.g. July 1-31) and for
reconciled transactions, then generate an Account Report would give me
a list of current reconciled transactions, but not the unreconciled
ones. (Yes, I could generate a separate report with a filter, but that
is an inelegant workaround, in my opinion.)

Regarding Christopher's reference to "standard accounting practice," I
want to emphasize that I don't know what is standard, just what seems
logical, familiar, and useful to me. Nevertheless, I am going to
follow his suggestion and file a bug report suggesting an Enhancement
to the reconciliation report dialog.

Thanks,
Art
___
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] Migration

2019-08-04 Thread Clint Chaplin
The more basic limitation of MYM is the complete inability to include
transfers to different "accounts" (bank, investment, credit card), in a
split transaction.  Splits can only go to budget categories.

This causes lots of silly/stupid workarounds like the one below.

On Thu, Aug 1, 2019 at 11:12 AM Clint Chaplin  wrote:

> Thanks!
>
> MYM, unfortunately, does not rigidly enforce the double entry aspects of
> financial recording.  As a for instance, 401(k) contributions from my
> paycheck would not automatically transfer to the account; I've had to
> manually adjust the cash balance of the investment to record the
> contribution.
>
> On Thu, Aug 1, 2019 at 1:20 AM David Carlson 
> wrote:
>
>> Hi,
>>
>> Welcome to GnuCash!
>>
>> I found the user group called "MYM users" on Facebook and the forum on
>> https://www.starkeysoftware.com/MYM/.  I recall that MYM was very nice
>> when
>> I used it, and I think it was rather rigidly double-entry, so it should
>> import into GnuCash rather easily if it can make good QIF exports.  Since
>> it basically is limited to one or two years' data in a data file, you
>> would
>> probably want to convert one file at a time and keep them separate rather
>> than concatenating them into a "huge" single data file.  While GnuCash
>> doesn't have the DOS limits, from personal experience I can tell you that
>> it still gets slow with a decade long data file.
>>
>> I have some old MYM data files on some old hard drive if I ever have time
>> to fire it up, or really old floppies but I can't find them right now.
>>
>> GnuCash is rigidly double-entry but it can keep basic investment records
>> as
>> well as checkbook records.  It is limited as a budgeting tool, tho.
>>
>> It does have a bit of a learning curve, but I like it better than the
>> others that I have tried.
>>
>> David Carlson
>>
>> On Thu, Aug 1, 2019 at 12:21 AM Dennis Powless 
>> wrote:
>>
>> > I can say the migration process wasn't easy, but wasn't too hard.  I was
>> > able to do it and got it up and running with all my old quicken data.  I
>> > can't remember the number of years of quicken data, maybe 5-10 years or
>> > more.  I've probably been with gnucash for about 10 years maybe.
>> >
>> > After all is said and done, I'd NEVER go back to quicken.  Gnucash has
>> done
>> > everything I need (I don't have complicated stocks or investments).  I
>> only
>> > use it for my personal finances, not a business, so can't comment on
>> that.
>> >
>> >
>> > I'm not familiar with MYM12, so don't know about that migration.
>> >
>> > Gnucash is a great program and open source, the devs work very hard on
>> > keeping it up to date and are making improvements all the time.
>> >
>> > d
>> >
>> > On Wed, Jul 31, 2019 at 11:04 PM David T. via gnucash-user <
>> > gnucash-user@gnucash.org> wrote:
>> >
>> > > I won't comment on whether the migration process has become simpler
>> over
>> > > the years, as I haven't done it in about as long.
>> > >
>> > > There has been a huge amount of discussion over the years on the
>> question
>> > > of migration from Quicken (usually tied either to the beginning of a
>> new
>> > > calendar year, or the imposition of a new fee structure by Intuit).
>> > >
>> > > A search of the mailing list archives will turn these up.
>> > >
>> > > Additionally, the wiki includes a summary of many of the points that
>> have
>> > > been raised on the topic.
>> > > wiki.gnucash.org/wiki/FAQ#Importing.2FExporting_Data
>> > >
>> > > I can't comment on the ease of migration from the other application,
>> but
>> > I
>> > > can say that the strict enforcement of double entry accounting in
>> gnucash
>> > > causes most Quicken refugees some discomfort. People with complicated
>> > stock
>> > > holdings also encounter special challenges typically.
>> > >
>> > > David
>> > >
>> > >
>> > >   On Thu, Aug 1, 2019 at 6:54, Jean-David Beyer via gnucash-user<
>> > > gnucash-user@gnucash.org> wrote:   On 7/31/19 5:01 PM, Clint Chaplin
>> > > wrote:
>> > > > Hi all,
>> > > >
>> > > > I am looking for, well, some assurance here.
>> > > >
>> > > > How many of you migrated to GnuCash from another financial
>> product?  If
>> > > you
>> > > > did, what did you migrate from?  How much data did you have to
>> migrate?
>> > > > And would you do it again knowing what you know now?
>> > > >
>> > >
>> > > I ran Quicken for a few years, but I could not stand Windows 95
>> (current
>> > > at the time), so I switched to Red Hat Linux 5 in about mid 1998. A
>> > > little later, I started using GnuCash. It could presumably convert
>> from
>> > > Quicken, but it made such a mess of mine that I just dropped all the
>> old
>> > > data and started afresh.
>> > >
>> > > I suppose in the decade or more since than, Gnucash has improved the
>> > > behavior of the conversions.
>> > >
>> > >
>> > > --
>> > >   .~.  Jean-David Beyer
>> > >   /V\  PGP-Key:166D840A 0C610C8B
>> > >  /( )\ Shrewsbury, New Jersey
>> > >  ^^-^^ 21:15:01 up 6 days, 6:07, 2 users, loa

Re: [GNC] Struggling with Export/Import of Accounts

2019-08-04 Thread Michael Hendry
> On 4 Aug 2019, at 16:32, Adrien Monteleone  
> wrote:
> 
> I’ve had no issue exporting and importing an account tree myself.
> 
> I see you’re using a comma as part of an account name. While changing the 
> separator and using quotes should work, I try to avoid commas in CSV data as 
> a rule.
> 
> Try using something else like `-` (hyphen), `–` (en dash), `—` (em dash), `~` 
> (tilde), or `_` (underscore) and see if that works without quotes and with 
> the standard comma separator or CamelCase the names if that isn’t an eye sore 
> for you.

That worked!

I restricted myself to changing one name, replacing the comma with an 
underscore, and edited the exported file with MacVim so as so import only that 
account name and all went well!

I plan now to investigate the mass-production of multiple identical 
transactions such as annual subscriptions by editing the CSV file in MacVim. 
This way I can keep the monitoring of such payments within GC, with the simple 
recording of the receipt of a cheque updating that individual’s account.

Many thanks,

Michael

PS My first attempt at importing the whole membership list failed, even though 
I’d replaced the “, “ with “_” in the account names. I had a suspicion this 
might relate to an e-acute (“é”) in a member’s name, and replacing this with a 
plain “e” worked the trick.

> 
> Note, I’d suspect a bug, but maybe there is a good reason why it failed. 
> Hopefully someone more familiar with the importer’s quirks will chime in.

The failure to handle UTF-8 characters looks like a bug to me.

> 
> Regards,
> Adrien

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] followup about 'how to remember an interest account'

2019-08-04 Thread Paul Kinzelman

Thanks for the tip about not changing the subject.

As I said below, both the windows, "Payment From"
(which should highlight the interest account I used last month)
and the "Reconcile Account" (the account I'm reconciling - the savings 
account)

highlight the same account that I'm trying to reconcile.
I always have to manually highlight the Income Interest account.

That highlight is correct for the "Reconcile Account", but it's not
the correct account for the "Payment From" window. That one
should be the interest account, which should be the same one
that I used the last month.

On 8/4/2019 10:00 AM, gnucash-user-requ...@gnucash.org wrote:

Here is info from the Help Manual Chapter 5:

"The Payment From pane contains a list of accounts where you can select the 
source account.

Note
If the payment is for a credit or loan account then usually the payment would 
be from an Expense account. If the payment is for a checking or savings account 
then usually this would be from an Income account.?

What is the incorrect account that the window is preselecting? Is it an income 
account?

Savings accounts usually earn interest, while credit accounts usually cost you 
interest.

-

Also, please when sending a ?follow up? like you did here, do not change the 
subject line, just reply to the same thread. Otherwise, you end up with two 
threads neither of which have all the info in them. Someone might not see one 
or the other when replying.

Regards,
Adrien


On Aug 4, 2019, at 9:40 AM, Paul Kinzelman  wrote:

Sorry, I should have included this more specific info...

In the 'Payment Information" window,
the "Payment From" and "Reconcile Account" are always
initially the same account which is not very useful.

The previous month I reconciled the same account and
under "Payment From"  I selected the interest account, but
the following month it goes back to initially selecting the
same account as is in the "Reconcile Account" window
and I have to select the desired account again every month.


___
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] Income statement incorrect

2019-08-04 Thread Adrien Monteleone
Sounds like a lot of work. Would simply not posting the bills/invoices until 
actually paid not accomplish the proper timing of when the transactions hit the 
books? (yes, you do lose the ‘reminders’ feature in that case, but unless that 
is critical, it is a small price for not having to maintain 2 books)

Regards,
Adrien

> On Aug 4, 2019, at 10:37 AM, Mike or Penny Novack 
>  wrote:
> 
> On 8/3/2019 6:16 AM, Liz wrote:
>> On Wed, 31 Jul 2019 09:10:02 -0700 (PDT)
>> Rich Shepard  wrote:
>> 
>>> Would be nice to have a cash accounting option in addition to the
>>> default accrual accounting option.
>> Whether a business uses cash or accrual accounting in Australia is set
>> by the tax authorities, so I am obliged to use cash accounting.
> This is a common situation in many jurisdictions with certain sorts of 
> businesses required to use either cash of accrual. The difficulty is that 
> gnucash does not support PRODUCING invoices for cash based << in other words, 
> simply producing an invoice but NOT entering transaction to A/R and income >>
> 
> That's why I am mentioning "multiple books". If I had to produce invoices, it 
> is what I would do. Set up a virtual entity associated with the actual 
> entity. This virtual entity would be "accrual" and so have A/R and income and 
> it would produce the invoices to be sent out (and track which paid, which 
> outstanding) but the A/R and income would otherwise be ignored << when 
> invoice paid, a transaction in the main (cash books affecting cash and income 
> >>
> 
> Michael D Novack

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] followup about 'how to remember an interest account'

2019-08-04 Thread Adrien Monteleone
Paul,

Here is info from the Help Manual Chapter 5:

"The Payment From pane contains a list of accounts where you can select the 
source account.

Note
If the payment is for a credit or loan account then usually the payment would 
be from an Expense account. If the payment is for a checking or savings account 
then usually this would be from an Income account.”

What is the incorrect account that the window is preselecting? Is it an income 
account?

Savings accounts usually earn interest, while credit accounts usually cost you 
interest.

-

Also, please when sending a ‘follow up’ like you did here, do not change the 
subject line, just reply to the same thread. Otherwise, you end up with two 
threads neither of which have all the info in them. Someone might not see one 
or the other when replying.

Regards,
Adrien

> On Aug 4, 2019, at 9:40 AM, Paul Kinzelman  wrote:
> 
> Sorry, I should have included this more specific info...
> 
> In the 'Payment Information" window,
> the "Payment From" and "Reconcile Account" are always
> initially the same account which is not very useful.
> 
> The previous month I reconciled the same account and
> under "Payment From"  I selected the interest account, but
> the following month it goes back to initially selecting the
> same account as is in the "Reconcile Account" window
> and I have to select the desired account again every month.

___
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] Income statement incorrect

2019-08-04 Thread Mike or Penny Novack

On 8/3/2019 6:16 AM, Liz wrote:

On Wed, 31 Jul 2019 09:10:02 -0700 (PDT)
Rich Shepard  wrote:


Would be nice to have a cash accounting option in addition to the
default accrual accounting option.

Whether a business uses cash or accrual accounting in Australia is set
by the tax authorities, so I am obliged to use cash accounting.
This is a common situation in many jurisdictions with certain sorts of 
businesses required to use either cash of accrual. The difficulty is 
that gnucash does not support PRODUCING invoices for cash based << in 
other words, simply producing an invoice but NOT entering transaction to 
A/R and income >>


That's why I am mentioning "multiple books". If I had to produce 
invoices, it is what I would do. Set up a virtual entity associated with 
the actual entity. This virtual entity would be "accrual" and so have 
A/R and income and it would produce the invoices to be sent out (and 
track which paid, which outstanding) but the A/R and income would 
otherwise be ignored << when invoice paid, a transaction in the main 
(cash books affecting cash and income >>


Michael D Novack
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Struggling with Export/Import of Accounts

2019-08-04 Thread Adrien Monteleone
I’ve had no issue exporting and importing an account tree myself.

I see you’re using a comma as part of an account name. While changing the 
separator and using quotes should work, I try to avoid commas in CSV data as a 
rule.

Try using something else like `-` (hyphen), `–` (en dash), `—` (em dash), `~` 
(tilde), or `_` (underscore) and see if that works without quotes and with the 
standard comma separator or CamelCase the names if that isn’t an eye sore for 
you.

Note, I’d suspect a bug, but maybe there is a good reason why it failed. 
Hopefully someone more familiar with the importer’s quirks will chime in.

Regards,
Adrien

> On Aug 4, 2019, at 5:03 AM, Michael Hendry  wrote:
> 
> I’m using GC version 3.5 on iMac with OS X High Sierra, set up to use UTF-8 
> by default.
> 
> I’ve created a GC file with accounts for each member of my Rotary club in the 
> form:
> 
> Assets:Current Assets:Member:Surname, Forename
> 
> and thought I should be able to copy these Accounts to another GC file using 
> "Export Account Tree to CSV” and “Import Accounts from CSV” on the respective 
> files.
> 
> After my initial experiments failed, I ran a Google search, and found advice 
> from 2017 that it’s necessary to use a semicolon as a separator, and to use 
> quotes on export.
> 
> These adjustments didn’t resolve the problem, which is that an attempt to 
> import fails to get beyond the “Import Account Preview…” phase. The header 
> labels appear in the window, but none of the other content of the file.
> 
> I had hoped that I could edit the CSV file to include only the member’s 
> individual accounts, and in due course to create CSV transaction files to 
> speed the chore of adding a set of identical transactions for each member.
> 
> Presumably someone out there is using CSV export/import successfully?
> 
> Regards,
> 
> Michael

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] followup about 'how to remember an interest account'

2019-08-04 Thread Paul Kinzelman

Sorry, I should have included this more specific info...

In the 'Payment Information" window,
the "Payment From" and "Reconcile Account" are always
initially the same account which is not very useful.

The previous month I reconciled the same account and
under "Payment From"  I selected the interest account, but
the following month it goes back to initially selecting the
same account as is in the "Reconcile Account" window
and I have to select the desired account again every month.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] how to remember an interest account?

2019-08-04 Thread Robert Heller
At Sun, 4 Aug 2019 08:00:05 -0600 p...@kinzelman.com wrote:

> 
> When I reconcile a charge card, GC remembers the account I pay
> the card out of, and in the payment window (after reconciliation),
> it selects this account which is quite convenient.
> 
> However, when I reconcile, say a savings account, the window that
> pops up to account for the interest does not pre-select the account that
> I always use to post the interest. Both sides of the window (to select
> the debit account and the credit account) show the same account.
> 
> Is there any way for GC to remember the account from the last time
> I reconciled and posted interest, and select that same account for
> interest again?
> 
> Given that the remembering for charge cards works, I would almost
> think the lack of remembering is a bug. Should I post a bug someplace?

Assuming you use the same text for the *description*, once you tab to there in 
the form and start to enter the description, it will remember/fill things in. 
At least that is what happens with the older version I am using (2.4.15) under 
CentOS 6.

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

-- 
Robert Heller -- 978-544-6933
Deepwoods Software-- Custom Software Services
http://www.deepsoft.com/  -- Linux Administration Services
hel...@deepsoft.com   -- Webhosting Services
 
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] how to remember an interest account?

2019-08-04 Thread Paul Kinzelman

When I reconcile a charge card, GC remembers the account I pay
the card out of, and in the payment window (after reconciliation),
it selects this account which is quite convenient.

However, when I reconcile, say a savings account, the window that
pops up to account for the interest does not pre-select the account that
I always use to post the interest. Both sides of the window (to select
the debit account and the credit account) show the same account.

Is there any way for GC to remember the account from the last time
I reconciled and posted interest, and select that same account for
interest again?

Given that the remembering for charge cards works, I would almost
think the lack of remembering is a bug. Should I post a bug someplace?

Thanks!

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Struggling with Export/Import of Accounts

2019-08-04 Thread Michael Hendry
I’m using GC version 3.5 on iMac with OS X High Sierra, set up to use UTF-8 by 
default.

I’ve created a GC file with accounts for each member of my Rotary club in the 
form:

Assets:Current Assets:Member:Surname, Forename

and thought I should be able to copy these Accounts to another GC file using 
"Export Account Tree to CSV” and “Import Accounts from CSV” on the respective 
files.

After my initial experiments failed, I ran a Google search, and found advice 
from 2017 that it’s necessary to use a semicolon as a separator, and to use 
quotes on export.

These adjustments didn’t resolve the problem, which is that an attempt to 
import fails to get beyond the “Import Account Preview…” phase. The header 
labels appear in the window, but none of the other content of the file.

I had hoped that I could edit the CSV file to include only the member’s 
individual accounts, and in due course to create CSV transaction files to speed 
the chore of adding a set of identical transactions for each member.

Presumably someone out there is using CSV export/import successfully?

Regards,

Michael


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.