Re: [GNC] QIF Import Problem
... 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
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
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
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
> 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'
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
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
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
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
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
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
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
> 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'
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
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'
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
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
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'
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?
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?
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
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.