Re: [GNC] Credit cards gone missing
Sent: Tuesday, December 04, 2018 at 10:48 PM >From: "John Ralls" >To: "Cliff McDiarmid" >Subject: Re: [GNC] Credit cards gone missing >On Dec 5, 2018, at 12:32 AM, Cliff McDiarmid <[1]cliffhan...@gardener.com> wrote: >Sent: Tuesday, December 04, 2018 at 12:48 PM >From: "John Ralls" <[2]jra...@ceridwen.fremont.ca.us> >To: [3]cliffhan...@gardener.com >Cc: [4]gnucash-user@gnucash.org >Subject: Re: [GNC] Credit cards gone missing > On Dec 4, 2018, at 5:51 PM, [5]cliffhan...@gardener.com wrote: > > Hi. Why would my credit cards disappear from the accounts list? I thought originally it was a filter issue but but that is not the case. Under the filter option credit cards is enabled. . Thanks Cliff >First guess is that you have 0-balance accounts filtered out and you’ve paid off the credit card balance so that it’s 0. >Thanks John but it's not that. I do have the 0-balance a/cs out, but I tried reinstating it made no difference. Anyway balances are not zero. Chance would be a fine thing! >Cliff >Please remember to copy the list on all replies. “Reply All” works well, as does “Reply List” if your mail client provides it. Will do >OK, take a look at the “Other” tab in the Filter By... dialog and make sure that all three boxes are checked. Found it. I'm off top get my head tested. Liabilities was unchecked! Thanks again regards Cliff References 1. mailto:cliffhan...@gardener.com 2. mailto:jra...@ceridwen.fremont.ca.us 3. mailto:cliffhan...@gardener.com 4. mailto:gnucash-user@gnucash.org 5. mailto:cliffhan...@gardener.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.
A predictive bar graph needed
[1]adrien.monteleone at gmail.com On Sun, Feb 11, 2018 at 6.33 PM, wrote >There is an expense and income graph that shows bars over months. You can >also get a data table for each. >Then, there is a future scheduled transaction report you can run. So set up >your recurring income/expenses to see that data. >There is currently no built-in way to get a bar chart with future scheduled >transactions, and the app will not 'guess' for you based on past entries. >You CAN export or copy and paste the Future Scheduled Transaction report to >a spreadsheet and generate a graph there if you like. On Sun, Feb 11, 2018 at 5:12 PM, Cliff McDiarmid <[2]cliffhanger at gardener.com > wrote: >Hi > >I've just moved over from Quicken. There was a rather neat feature in >it, whereby through a 12 month calender, one could input expenses and >income over the days of the months and see the predicted outcome in a >bar graph below. > >I need a similar thing in gnucash, but through the budget feature a >cannot get the outcome at the moment. I can only get a monthly view >which is not imformative enough. Any advice appreciated. Thanks Adrien I thought as much. That's a shame everything else is what I need. Cliff References 1. mailto:gnucash-user@gnucash.org?Subject=Re: Re: A predictive bar graph needed&In-Reply-To= 2. https://lists.gnucash.org/mailman/listinfo/gnucash-user ___ 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.
A predictive bar graph needed
Hi I've just moved over from Quicken. There was a rather neat feature in it, whereby through a 12 month calender, one could input expenses and income over the days of the months and see the predicted outcome in a bar graph below. I need a similar thing in gnucash, but through the budget feature a cannot get the outcome at the moment. I can only get a monthly view which is not imformative enough. Any advice appreciated. thanks Cliff ___ 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: Creating and Posting an Invoice
Sent: Monday, February 05, 2018 at 11:55 PM From: "Adrien Monteleone" To: "Gnucash Users" Subject: Re: Creating and Posting an Invoice >That’s the same account. >Accounts Receivable is a Current Asset account. That is what the invoice posts to. (other than the chosen Income account) >In order to increase the balance, you post a debit to it. >If you want to increase an Asset or an Expense, you debit the account. >If you want to increase Income, Liabilities or Equity, you credit the respective account > On Feb 5, 2018, at 4:18 PM, Cliff McDiarmid wrote: > > > > Sent: Sunday, February 04, 2018 at 11:53 PM > From: "Maf. King" > To: gnucash-user@gnucash.org > Cc: "Cliff McDiarmid" > Subject: Re: Creating and Posting an Invoice > On Sunday, 4 February 2018 23:30:32 GMT Cliff McDiarmid wrote: >> Hi >> >> I've nearly got gnucash running as i want it but i need some advice > on >> posting an invoice which is proving confusing. >> >> I create an invoice where one has to select an Income account; in my >> case a current account. But when it gets to posting the invoice one >> has to select a 'Post to Account' where one has to create a 'A/c >> receivable'. I assume this because of the double accounting, but why >> can't I just select an Income account such as 'Wages' at this stage? >> >> OK, so GC's invoice subsystem uses a concept called "accrual > accounting". You >> write the invoice and expect to be paid at some point in the future. > (end of >> month, 30 days, that sort of thing) >> With that in mind, the income is generated when you create the > invoice, even >> though you don't physically have the cash yet. >> As you write out the line items on the invoice in GC, you select the > relevant >> income account (eg Income:Sales or Income:consulting etc.) When the > invoice >> is "posted" into the GC books, this has the effect of increasing your > income >> totals. (your bank account isn't income, it is an asset account) >> But where to post it to balance the double entry? As far as gnucash > knows, >> you probably don't have the money yet, (assuming you are running > accruals >> "properly"), so clearly the bank account is the wrong place. This is > the >> purpose of the special A/R account. It stores the "earned but not yet >> received" money - and it is the other half of double-entry. >> At some point in the future, when the money actually arrives (maybe in > your >> case that is 1 second later, not 1 month or so!) you "process > payment", which >> decreases the A/R and increases the bank account (income is untouched > at this >> stage. you already earned it!) > One more thing on this subject. Why, when posting the invoice does it > place the amount in the A/R account as you explained, BUT also in the > receivable account(current)as a DEBIT! Thanks got it now. The mistake I was making was putting my current a/c as the income a/c. Cliff ___ 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: Creating and Posting an Invoice
Sent: Sunday, February 04, 2018 at 11:53 PM From: "Maf. King" To: gnucash-user@gnucash.org Cc: "Cliff McDiarmid" Subject: Re: Creating and Posting an Invoice On Sunday, 4 February 2018 23:30:32 GMT Cliff McDiarmid wrote: > Hi > > I've nearly got gnucash running as i want it but i need some advice on > posting an invoice which is proving confusing. > > I create an invoice where one has to select an Income account; in my > case a current account. But when it gets to posting the invoice one > has to select a 'Post to Account' where one has to create a 'A/c > receivable'. I assume this because of the double accounting, but why > can't I just select an Income account such as 'Wages' at this stage? > >OK, so GC's invoice subsystem uses a concept called "accrual accounting". You >write the invoice and expect to be paid at some point in the future. (end of >month, 30 days, that sort of thing) >With that in mind, the income is generated when you create the invoice, even >though you don't physically have the cash yet. >As you write out the line items on the invoice in GC, you select the relevant >income account (eg Income:Sales or Income:consulting etc.) When the invoice >is "posted" into the GC books, this has the effect of increasing your income >totals. (your bank account isn't income, it is an asset account) >But where to post it to balance the double entry? As far as gnucash knows, >you probably don't have the money yet, (assuming you are running accruals >"properly"), so clearly the bank account is the wrong place. This is the >purpose of the special A/R account. It stores the "earned but not yet >received" money - and it is the other half of double-entry. >At some point in the future, when the money actually arrives (maybe in your >case that is 1 second later, not 1 month or so!) you "process payment", which >decreases the A/R and increases the bank account (income is untouched at this >stage. you already earned it!) One more thing on this subject. Why, when posting the invoice does it place the amount in the A/R account as you explained, BUT also in the receivable account(current)as a DEBIT! thanks Cliff ___ 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.
Template for invoicing
Hi Is there a way of creating an invoice template that comes up every time I bill someone. At the moment I have to go to 'Style sheets' and select the 'Custom Invoice' I created, every time I create an invoice, in order to get it to display. Even then, try as I might, I cannot get a heading to work in the invoice. Created in Openofficedraw, even a size 12 font will not be accepted. Even a 'Default' invoice has the date out of place. Any tips? Many thanks Cliff ___ 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: Creating and Posting an Invoice
Sent: Sunday, February 04, 2018 at 11:53 PM From: "Maf. King" To: gnucash-user@gnucash.org Cc: "Cliff McDiarmid" Subject: Re: Creating and Posting an Invoice On Sunday, 4 February 2018 23:30:32 GMT Cliff McDiarmid wrote: > Hi > > I've nearly got gnucash running as i want it but i need some advice on > posting an invoice which is proving confusing. > > I create an invoice where one has to select an Income account; in my > case a current account. But when it gets to posting the invoice one > has to select a 'Post to Account' where one has to create a 'A/c > receivable'. I assume this because of the double accounting, but why > can't I just select an Income account such as 'Wages' at this stage? > >Hi Cliff, >OK, so GC's invoice subsystem uses a concept called "accrual accounting". You >.rite the invoice and expect to be paid at some point in the future. (end of >month, 30 days, that sort of thing) >With that in mind, the income is generated when you create the invoice, even >though you don't physically have the cash yet. >As you write out the line items on the invoice in GC, you select the relevant >income account (eg Income:Sales or Income:consulting etc.) When the invoice >is "posted" into the GC books, this has the effect of increasing your income >totals. (your bank account isn't income, it is an asset account) >But where to post it to balance the double entry? As far as gnucash knows, >you probably don't have the money yet, (assuming you are running accruals >"properly"), so clearly the bank account is the wrong place. This is the >purpose of the special A/R account. It stores the "earned but not yet >received" money - and it is the other half of double-entry. >At some point in the future, when the money actually arrives (maybe in your >case that is 1 second later, not 1 month or so!) you "process payment", which >decreases the A/R and increases the bank account (income is untouched at this >stage. you already earned it!) >Hope that clarifies a bit. >Maf. Many thanks for that Maf, it is clear now. It will take the other subject up in a separate email. Cliff ___ 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.
Creating and Posting an Invoice
Hi I've nearly got gnucash running as i want it but i need some advice on posting an invoice which is proving confusing. I create an invoice where one has to select an Income account; in my case a current account. But when it gets to posting the invoice one has to select a 'Post to Account' where one has to create a 'A/c receivable'. I assume this because of the double accounting, but why can't I just select an Income account such as 'Wages' at this stage? If i create a new 'A/c receivable', then when I post the invoice it only goes to that account, but not to my current a/c. Erh, why is this? Also. Is there a way of creating an invoice template that comes up every time I bill someone. At the moment I have to go to 'Style sheets and select my 'custom invoice' every time I create an invoice in order to get it to display properly. many thanks Cliff ___ 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: Read only transactions
Sent: Sunday, January 14, 2018 at 5:20 PM From: "Geert Janssens" To: gnucash-user@gnucash.org Cc: "Cliff McDiarmid" , "Colin Law" Subject: Re: Read only transactions Op zondag 14 januari 2018 16:14:18 CET schreef Cliff McDiarmid: > Sent: Sunday, January 14, 2018 at 12:27 PM > From: "Colin Law" > To: "Cliff McDiarmid" > Cc: gnucash-user@gnucash.org > Subject: Re: Read only transactions > > >Sorry, it is in File > Properties > Accounts. Best left at zero > >unless you want earlier transactions to be protected. > > Yes that's what mine is set to, i.e. zero. > > Where is this read only nonsense coming from then? > > Cliff >There are several reasons why transactions can be read-only. >The "Read-only" treshold is one. >If you have voided a transaction, that one will become read-only as well. >And if the transaction is the result of posting an invoice or bill using the >business features, it will equally be read-only. >There may be other reasons but I only know of these. >Solutions: >In the case of a voided transaction, unvoid it. In case of a transaction from >a bill or invoice (or employee voucher for that matter), use the business >features to unpost it again. Thanks Geert. I thought you had the answer, I had 5 voided transactions 'buried' amoungst my data. I reset them using the filter option and then saved the filter, but I still can't delete these a/cs I have. The voided transactions have disappeared from the accounts in question, but still reappear when searching all accounts. What's going on? Cliff ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Read only transactions
Sent: Sunday, January 14, 2018 at 12:27 PM From: "Colin Law" To: "Cliff McDiarmid" Cc: gnucash-user@gnucash.org Subject: Re: Read only transactions >Sorry, it is in File > Properties > Accounts. Best left at zero >unless you want earlier transactions to be protected. Yes that's what mine is set to, i.e. zero. Where is this read only nonsense coming from then? Cliff On 14 January 2018 at 12:15, Colin Law wrote: > What have you specified for Day Threshold for Read-Only Transactions > (red line): in Edit > Preferences > Accounts? > > Colin > > On 14 January 2018 at 12:04, Cliff McDiarmid wrote: >> Sent: Saturday, January 13, 2018 at 5:22 PM >> From: "Colin Law" >> To: "Cliff McDiarmid" >> Cc: gnucash-user@gnucash.org >> Subject: Re: Read only transactions >> On 13 January 2018 at 17:12, Cliff McDiarmid >> wrote: >>> >>> >Sent: Saturday, January 13, 2018 at 4:58 PM >>> >From: "Colin Law" >>> >To: "Cliff McDiarmid" >>> .Cc: gnucash-user@gnucash.org >>> >Subject: Re: Read only transactions >>> >On 10 January 2018 at 19:21, Cliff McDiarmid >>> > wrote: >>>> >>>> Hi >>>> >>>> I still haven't sorted my Quicken import, getting the correct balances >>>> without a 'balance adjustment' is difficult. >>> >>> >>> >Add (or adjust) an appropriate opening balance. >>> >>>> >>>> >>>> But the question is: How do i delete an account when it contains read >>>> only transactions? I know i can move the transactions elsewhere, but I >>>> need to delete the accounts. >>> >>> >>> >What do you mean by read only transactions? >>> >>> Well I assume, as in Linux, that one cannot write to or change these >>> files. >>> >>> >When you delete an account that contains transactions it should ask you >>> > which account you want to move them to. >>> >>> Yes, that's right it does. But it won't let me delete the account >>> altogether, because the account contains read only transactions. Other >>> accounts I've deleted have given one the option of moving the files as you >>> say or deleting them entirely. >> >>>All the accounts are in one file, so if you have read access to the >>>file then it is not a permissions issue. How are you trying to delete >>>the account and exactly what do you see when you try to delete it? >> >> I right click on the account and select delete account. I get a box that >> gives me two options. To move the transactions and to delete them, but the >> delete option is greyed out. The message in the same box says: 'This >> account contains read-only transactions which may not be deleted' >> >> Cliff >> ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Read only transactions
Sent: Saturday, January 13, 2018 at 5:22 PM From: "Colin Law" To: "Cliff McDiarmid" Cc: gnucash-user@gnucash.org Subject: Re: Read only transactions On 13 January 2018 at 17:12, Cliff McDiarmid wrote: > > >Sent: Saturday, January 13, 2018 at 4:58 PM > >From: "Colin Law" > >To: "Cliff McDiarmid" > .Cc: gnucash-user@gnucash.org > >Subject: Re: Read only transactions > >On 10 January 2018 at 19:21, Cliff McDiarmid wrote: >> >> Hi >> >> I still haven't sorted my Quicken import, getting the correct balances >> without a 'balance adjustment' is difficult. > > > >Add (or adjust) an appropriate opening balance. > >> >> >> But the question is: How do i delete an account when it contains read >> only transactions? I know i can move the transactions elsewhere, but I >> need to delete the accounts. > > > >What do you mean by read only transactions? > > Well I assume, as in Linux, that one cannot write to or change these files. > > >When you delete an account that contains transactions it should ask you which account you want to move them to. > > Yes, that's right it does. But it won't let me delete the account altogether, because the account contains read only transactions. Other accounts I've deleted have given one the option of moving the files as you say or deleting them entirely. >All the accounts are in one file, so if you have read access to the >file then it is not a permissions issue. How are you trying to delete >the account and exactly what do you see when you try to delete it? I right click on the account and select delete account. I get a box that gives me two options. To move the transactions and to delete them, but the delete option is greyed out. The message in the same box says: 'This account contains read-only transactions which may not be deleted' Cliff ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Read only transactions
>Sent: Saturday, January 13, 2018 at 4:58 PM >From: "Colin Law" >To: "Cliff McDiarmid" .Cc: gnucash-user@gnucash.org >Subject: Re: Read only transactions >On 10 January 2018 at 19:21, Cliff McDiarmid <[1]cliffhan...@gardener.com> wrote: Hi I still haven't sorted my Quicken import, getting the correct balances without a 'balance adjustment' is difficult. >Add (or adjust) an appropriate opening balance. But the question is: How do i delete an account when it contains read only transactions? I know i can move the transactions elsewhere, but I need to delete the accounts. >What do you mean by read only transactions? Well I assume, as in Linux, that one cannot write to or change these files. >When you delete an account that contains transactions it should ask you which account you want to move them to. Yes, that's right it does. But it won't let me delete the account altogether, because the account contains read only transactions. Other accounts I've deleted have given one the option of moving the files as you say or deleting them entirely. thanks Cliff References 1. mailto:cliffhan...@gardener.com ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Read only transactions
>Sent: Wednesday, January 10, 2018 at 7:21 PM >From: "Cliff McDiarmid" >To: gnucash-user@gnucash.org >Subject: Read only transactions >Hi >I still haven't sorted my Quicken import, getting the correct balances without >a 'balance adjustment' is difficult. >But the question is: How do i delete an account when it contains read only >transactions? I know i can move the transactions elsewhere, but I need to >delete the accounts. >I understand that the 'placeholder box' needs to be unchecked; it already is. >Need a solution, Google yields nothing. Okay so there's no answer or maybe it's a dumb question. So, is there anyway I can set the transactions within an account to read and write? thanks Cliff ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Read only transactions
Hi I still haven't sorted my Quicken import, getting the correct balances without a 'balance adjustment' is difficult. But the question is: How do i delete an account when it contains read only transactions? I know i can move the transactions elsewhere, but I need to delete the accounts. I understand that the 'placeholder box' needs to be unchecked; it already is. Need a solution, Google yields nothing. thanks Cliff ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Dealing with a large QIF file
Sent: Thursday, December 28, 2017 at 8:11 AM From: "jeffrey black" To: "l...@lincolnbaxter.com" , "cliffhan...@gardener.com" , "Colin Law" Cc: "gnucash-user@gnucash.org" Subject: Re: Dealing with a large QIF file On 12/24/2017 8:08 PM, Lincoln A Baxter wrote: > On Mon, 2017-12-25 at 00:46 +, cliffhan...@gardener.com wrote: >> Thanks. Yes one can import one at a time but this cheque ac from >> Quicken is huge and has references to other card accounts as >> categories >> within it. These accounts don't exist anymore and gnucash is >> trying to >> create them as part of the import. This is something I'd like to >> avoid. >> Hope this makes sense. Cliff >> >> Original Message >> Subject: Re: Dealing with a large QIF file >> From: Colin Law >> To: Cliff McDiarmid >> CC: gnucash-user@gnucash.org >> >> You should be able to export one account at a time from Quicken, >> I >> think. Then import them one at a time. >> Colin >> On 24 December 2017 at 19:02, Cliff McDiarmid wrote: >> > Hi >> > >> > I'm importing a large QIF file(a current a/c)about 6000 >> entries. >> > There are about a dozen other a/c's from Quicken, now closed, >> > associated with this large file. When importing, Gnucash seems >> to >> > want to create these defunct a/c's to 'balance the books'. I >> assume >> > there isn't any way of avoiding this. The whole thing looks >> like >> it >> > will be horrendous. I've imported some small credit card a/c's >> already >> > with success, but they were not any of these other closed >> accounts. >> > >> > Any advice please. >> > thanks >> > >> > Cliff > You might want to try editing the QIF file, and change all the > different categories referring legacy card accounts to one name. Call > it "Legacy Card" or something like that. > > In Quicken there was not enforcement of consistency of category > names... Quicken just said "ok" to what ever you put it. It is pretty > loosy goosy. But after you get things into GC, you can clean it up. I > was start, as a said, with the pre cleanup. It is likely to make your > conversion easier. > > Lincoln > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All >Don't worry about it, you are making a mountain out of a mole hill. I >transferred all of my Quicken data, more than 20 years to Gnucash in one >shot. I can not recall the link that told how to do it at the moment. >Export all your quicken data and let GnuCash import ALL of the data. >GnuCash will work it's "magic". >To make a long story short, do not worry about the closed accounts. Let >GnuCash create them. Make a top level account for each type of account, >IE. Closed credit cards. Once done and you get a chance to correct all >the erroneous entries (read that as using a hidden "corrected balance >account") that Quicken allowed then just edit the accounts and change >them to children of master accounts, "Closed credit cards", "Unused >checking", etc. Hide the master account of "unused" whatever. In my >case I needed to remember transactions from closed accounts for warranty >and shall we say domestic problems for the entire 20+ years. None of >which I wanted to see but; necessary for my financial "sayftey". >While GnuChash does no have all the "Fancy n Nancy, flashy ability" of >commercial programs it is a real accounting system. I greatly wish I >had the ability to donate one USD to each and every developer. Thanks Jeffery. I have reached the point now where I'm doing as you suggest. There are many alterations to make. regards Cliff ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Dealing with a large QIF file
Sent: Monday, December 25, 2017 at 7:28 PM From: "John Ralls" To: cliffhan...@gardener.com Cc: gnucash-user Subject: Re: Dealing with a large QIF file > On Dec 24, 2017, at 4:58 PM, cliffhan...@gardener.com wrote: > > Thanks . Yes one can import one at a time but this cheque ac from Quicken is huge and has references to other card accounts as categories within it. These accounts don't exist anymore and gnucash is trying to create them as part of the import. This is something I'd like to avoid. Hope this makes sense. Cliff > >The simplest way would be to pick some recent date, perhaps the beginning of last year, set the account’s opening balance to whatever it was on that date, and import only the transactions after >that date. >You could also use a plain-text editor on the QIF file and use search-and-replace to convert all of the closed CC accounts to a single account, perhaps named “Old Credit Cards”. Thanks again for all the thoughts. Me thinks this data transfer is going to take some time. regards Cliff ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Dealing with a large QIF file
Sent: Monday, December 25, 2017 at 3:23 AM From: D To: "cliffhan...@gardener.com" , "Colin Law" Cc: "Gnucash Users" Subject: Re: Dealing with a large QIF file >Gnucash creates the accounts because you and the transactions used those accounts. Personally, I prefer having all that "clutter," since it represents what happened. Accounting is supposed to >track what happened, after all. >Two points: first, you can hide accounts in the Chart of Accounts, which would allow these accounts to exist without disturbing your daily accounting work. Second, you can delete accounts, if >that really is your goal; when you delete an account with transactions in it, you get a chance to move them all to an account of your choosing. (I propose that this would be easier than editing >the QIF, as another suggests). >Personally, I'd keep the transactions and hide the accounts. >David >On December 25, 2017, at 5:47 AM, cliffhan...@gardener.com wrote: >Thanks. Yes one can import one at a time but this cheque ac from >Quicken is huge and has references to other card accounts as categories >within it. These accounts don't exist anymore and gnucash is trying to >create them as part of the import. This is something I'd like to avoid. >Hope this makes sense. Cliff Original Message ---- Subject: Re: Dealing with a large QIF file From: Colin Law To: Cliff McDiarmid CC: gnucash-user@gnucash.org You should be able to export one account at a time from Quicken, I think. Then import them one at a time. Colin On 24 December 2017 at 19:02, Cliff McDiarmid wrote: > Hi > > I'm importing a large QIF file(a current a/c)about 6000 entries. > There are about a dozen other a/c's from Quicken, now closed, > associated with this large file. When importing, Gnucash seems to > want to create these defunct a/c's to 'balance the books'. I assume > there isn't any way of avoiding this. The whole thing looks like it > will be horrendous. I've imported some small credit card a/c's already > with success, but they were not any of these other closed accounts. > > Any advice please. > thanks > > Cliff > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > [1]https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ Thanks to all for all the advice. I'm seeing clearer now. I will probably keep the accounts and hide them. One other thing, does anyone know, is it best to import all the accounts in one go? I have about 32 of them, but only two have over 6000 entries. Cliff References 1. https://lists.gnucash.org/mailman/listinfo/gnucash-user ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Dealing with a large QIF file
Hi I'm importing a large QIF file(a current a/c)about 6000 entries. There are about a dozen other a/c's from Quicken, now closed, associated with this large file. When importing, Gnucash seems to want to create these defunct a/c's to 'balance the books'. I assume there isn't any way of avoiding this. The whole thing looks like it will be horrendous. I've imported some small credit card a/c's already with success, but they were not any of these other closed accounts. Any advice please. thanks Cliff ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
gnucash coredump gnome
Sent: Wednesday, December 20, 2017 at 9:07 PM From: "Cliff McDiarmid" To: "Colin Law" Subject: Re: gnucash coredump gnome >On 19 December 2017 at 22:19, cliffhan...@gardener.com wrote: > Using Linux with gnome see message for ver. Gnucash was installed with dpkg. >Oh, you mean Ubuntu Gnome 16.04 LTS. You say you installed using >dpkg, do you mean apt-get install? If you used dpkg where did you get >?the deb file? >To give us more information what do see if you run in a terminal: >apt-cache policy gnucash >But first run >sudo apt-get update && sudo apt-get dist-upgrade >which will make sure everything is up to date (dist-upgrade does not >try to upgrade to the next version of Ubuntu, it just makes sure >everything is up to date for that version). Obviously report if that >shows any errors > > > Original Message > Subject: Re: gnucash coredump gnome > From: Colin Law > To: Cliff McDiarmid > CC: gnucash-user@gnucash.org > > > On 19 December 2017 at 19:20, Cliff McDiarmid wrote: >> >> Hi >> >> Just joined. i have been using Quicken for 24years running under Wine! >> It's now time to change, problems with older versions of it. >> >> I'm running Gnome 16.04LTS. But I have problems with my first foray into >> Gnucash. It is coredumping without starting, version 1:2.6.12-1. Other >> versions also dump. I've run it with Strace and the log is attached. AFAIK >> all dependencies are satisfied. > > Which OS are you using and how did you install gnucash? > > Colin Thanks Colin and all, but in the end I managed to compile from source and it started first time! I had wanted to do this originally but had problems with guille. All I've got to do now is learn the damn thing. Cliff ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Gnucash coredump
Just found this here 'https://lists.gnucash.org/wiki/Slackware' /usr/bin/glib-compile-schemas usr/share/glib-2.0/schemas >/dev/null 2>&1 Please execute the last command after installation or you will receive error like: Settings schema 'org.gnucash.general' is not installed Maybe this is not a fault. At a terminal all I get is : Trace/breakpoint trap (core dumped) Cliff ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.