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

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

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

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

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

[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

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

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

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

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

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

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

[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

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

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

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

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

[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

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

[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

[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

Re: [GNC] Club membership fees and charitable contributions - Business Features or Assets?

2019-08-04 Thread Michael Hendry
> On 3 Aug 2019, at 01:28, David Cousens wrote: > > Michael > > 4 sets of books is possibly overkill and likely confusing. At worst you > would need two, one for the club operations and one for charity. I agree, and have set up the two sets you describe. I have created an "Income:Intended