Re: [GNC] Automatic payments and interest during reconciliation?
Re: The post, and Adrian's reply the next day, both show up here: https://lists.gnucash.org/pipermail/gnucash-user/2022-August/thread.html Oops, sorry, somehow I missed the reply to my previous post. Thanks for replying again. -PaulK ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
[GNC] Automatic payments and interest during reconciliation?
My apologies for posing this again, but when I posted it a couple of months ago, nobody responded. On some of my charge card accounts, when I reconcile the account with the statement, a pop-up happens that automatically allows me to record the payment. For those accounts, the pop-up happens every time I reconcile those accounts. On other charge card accounts, when I reconcile them, nothing happens after reconciliation, and I have to manually enter the payment transaction. And for these accounts, every time I reconcile them, I have to manually enter the transaction. The same kind of things happens also on reconciling savings/checking for entering the interest every month, on some accounts I always get a pop-up to enter interest and on some accounts I never get the popup. What determines whether a payment or interest window pops up during reconciliation or not? I looked under help | "Reconciling an Account to a Statement" where it says: "You can change this behaviour in the GnuCash Preferences from the menu Edit | Preferences in the Register tab by activating the checkbox Automatic credit card payment." but that's checked on all the accounts. Is that a per-account thing? Or a global setting for all accounts? The help implied that it's per-account but it looks like it's global because it was set when I selected an account that's not doing auto-popup, when to Edit | Preferences | Register and the "Automatic credit card payment" seems to be always set. Under Account tab | account | right-click | edit account there is a box "Auto interest transfer" that when I hover it sounds like what I want, but it's never checked even on accounts that do have the popup for the payment. I'm confused. TIA! ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
[GNC] reconciling an account and paying the balance
On some of my charge card accounts, when I reconcile the account with the statement, a pop-up happens that automatically allows me to record the payment. For those accounts, the pop-up happens every time I reconcile those accounts. On other charge card accounts, when I reconcile them, nothing happens and I have to manually enter the payment transaction. And for these accounts, every time I reconcile them, I have to manually enter the transaction. The same kind of things happens also on reconciling savings/checking for entering the interest every month, on some accounts I always get a pop-up to enter interest and on some accounts I never get the popup. What determines whether a payment or interest window pops up during reconciliation or not? I looked under help | "Reconciling an Account to a Statement" where it says: "You can change this behaviour in the GnuCash Preferences from the menuEdit → Preferences in the Register tab by activating the checkbox Automatic credit card payment." but that's checked. Is that a per-account thing? Or a global setting for all accounts? The help implied that it's per-account but it looks like it's global because it was set when I selected an account that's not doing auto-popup, when to Edit | Preferences | Register and the "Automatic credit card payment" seems to be always set. Under Account tab | account | right-click | edit account there is a box "Auto interest transfer" that when I hover it sounds like what I want, but it's never checked even on accounts that do have the popup for the payment. I'm confused. TIA! ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
[GNC] Transaction Paste problem?
This happened in 4.9 so I upgraded to 4.11 (latest) and it's still happening. Running on W10. If I Transaction|Copy, say a credit card charge, then paste it into the same or a different credit-card account, it doesn't display or paste correctly. So if I have a transaction in a credit card account like Date, SomeCompany, Expenses:someaccount, Payment blank, Charge $12.34, Balance $1123 Then I copy it and paste it into the same or different credit card account, I expect to see that same line with the date changed to today so that I can Enter and commit that transaction. However, in Basic Ledger View after the paste, what I see is: Date, SomeCompany, Liability:SameAccount, Payment $12.34, Charge blank, Balance $1123 The payment is in the wrong column, and the account in the transaction is the same account that I'm already viewing. And if I Enter, the transaction seems to vanish because it's a transfer from and to the same account. But if I do the same thing but before Enter, go to View Transaction Journal, then the pasted transaction looks correct, just like the one I copied. And then if I Enter, the transaction is committed correctly. And then if I go back to Basic Ledger View, the transaction still looks OK. So to make it work, I have to go to View Transaction Journal, do the paste and enter, then go back to Basic Ledger View -Paul Kinzelman ___ 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] Report question
Thanks for the suggestion, but I'm not trying anything huge. I just tried to get a quick spreadsheet out of it and stumbled. I thought there would be some easy way to get quick reports like there was in Quicken, but GC requires more user assembly. It's the Ikea of financial software. :-) The suggestions you made helped. Thanks very much! On 2/26/2022 1:30 PM, D. wrote: If you took the report data and pasted it directly into your favorite spreadsheet, you could save the result as CSV, no problem. At this point, it might be more useful if you explained more completely what it is you're trying to accomplish. Then people on the list could help you solve the problem, rather than half answer your half-stated question. David ---- *From:* Paul Kinzelman *Sent:* Sat Feb 26 11:56:27 EST 2022 *To:* Tommy Trussell *Cc:* Gnucash Elist *Subject:* Re: [GNC] Report question Thank you for the detailed instructions. I found that 'Transaction Report' will do what I want, but then I can't export to CSV. I can export to HTML by Export Report I can 'Export as PDF' but not CSV. That's what I'm missing. This would be really nice to add. I can Export Transactions, but that does not export the transactions of the transaction report which is what I wanted to do. On 2/25/2022 6:08 PM, Tommy Trussell wrote: On Fri, Feb 25, 2022 at 9:27 AM Paul Kinzelman wrote: Do you mean Account Report? But when I go to File | Export, it asks me which accounts again, it doesn't export the actual report. When I export the transactions I want, it exports both sides of the transaction, so the column sum is always zero whereas I want the sum of the transactions. In other words, each transaction takes two lines, the line I want (the expense of what I bought), and the next line which is the account that paid it (like a charge card). How do I get rid of the double-lines on the export? We're apparently not seeing the same thing you are. Here's a way to get an Account Report for your credit card transactions. (This is using GnuCash 4.9.) 1) Open the account Accounts tab --> open Liabilities : Credit Cards : BigBankTwo VISA (yours will differ) 2) Use Filter By to select the transactions you want [while the register is active] View --> Filter By (choose parameters such as date, number of days, reconciled, etc.) 3) Open Account Report [while the filtered register is active] Reports --> Account Report 4) Adjust the options on the report Edit --> Report Options (here you can adjust specific columns, single or double amount columns, totals or running total, style, report name, etc.) 5) Export the report You can copy what's on your screen and paste it into a word processor or spreadsheet OR File --> Export --> Export Report (give it a name -- it will save an .html file you can open with a web browser or a spreadsheet program) - 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 seehttps://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] Report question
Thank you for the detailed instructions. I found that 'Transaction Report' will do what I want, but then I can't export to CSV. I can export to HTML by Export Report I can 'Export as PDF' but not CSV. That's what I'm missing. This would be really nice to add. I can Export Transactions, but that does not export the transactions of the transaction report which is what I wanted to do. On 2/25/2022 6:08 PM, Tommy Trussell wrote: On Fri, Feb 25, 2022 at 9:27 AM Paul Kinzelman wrote: Do you mean Account Report? But when I go to File | Export, it asks me which accounts again, it doesn't export the actual report. When I export the transactions I want, it exports both sides of the transaction, so the column sum is always zero whereas I want the sum of the transactions. In other words, each transaction takes two lines, the line I want (the expense of what I bought), and the next line which is the account that paid it (like a charge card). How do I get rid of the double-lines on the export? We're apparently not seeing the same thing you are. Here's a way to get an Account Report for your credit card transactions. (This is using GnuCash 4.9.) 1) Open the account Accounts tab --> open Liabilities : Credit Cards : BigBankTwo VISA (yours will differ) 2) Use Filter By to select the transactions you want [while the register is active] View --> Filter By (choose parameters such as date, number of days, reconciled, etc.) 3) Open Account Report [while the filtered register is active] Reports --> Account Report 4) Adjust the options on the report Edit --> Report Options (here you can adjust specific columns, single or double amount columns, totals or running total, style, report name, etc.) 5) Export the report You can copy what's on your screen and paste it into a word processor or spreadsheet OR File --> Export --> Export Report (give it a name -- it will save an .html file you can open with a web browser or a spreadsheet program) - 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] Report question
Do you mean Account Report? But when I go to File | Export, it asks me which accounts again, it doesn't export the actual report. When I export the transactions I want, it exports both sides of the transaction, so the column sum is always zero whereas I want the sum of the transactions. In other words, each transaction takes two lines, the line I want (the expense of what I bought), and the next line which is the account that paid it (like a charge card). How do I get rid of the double-lines on the export? Here's one line example: 02/23/2022 ff8275d221f24ecfa82aaf8f6e4c9852 Home Depot weed block CURRENCY::USD Expenses:House:Garden Garden $102.11 102.11 n 1 Liabilities:Credit Card:DCUvisa DCUvisa joint $(102.11) (102.11)n 1 On 2/24/2022 1:09 PM, David Carlson wrote: That procedure generates a mess, in my opinion. Wouldn't it be simpler to just run a register report? On Thu, Feb 24, 2022 at 12:57 PM Paul Kinzelman wrote: If I do a Search for the transactions I want, and then Export Active Register, I can look at the CSV in a spreadsheet, but both accounts of the transaction appear in the same column so the sum of the amount column is always zero. How do I export just one account's amount of each transaction without the other side of the transaction being there so that the sum of the column actually represents the sum of the expenses of that Search? TIA! ___ 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.
[GNC] Report question
If I do a Search for the transactions I want, and then Export Active Register, I can look at the CSV in a spreadsheet, but both accounts of the transaction appear in the same column so the sum of the amount column is always zero. How do I export just one account's amount of each transaction without the other side of the transaction being there so that the sum of the column actually represents the sum of the expenses of that Search? TIA! ___ 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] reconcile problem?
Thanks, but I don't think any of those instances apply in my case. I don't remember ever reconciling one part of a split transaction, and didn't move the transaction to another account. On 2/23/2022 10:10 AM, David Carlson wrote: A couple of other issues that could make GnuCash appear to be flakey when it is just eccentric are as follows: One, while editing certain fields in a transaction that already contains one or more split lines that are already reconciled, GnuCash may unreconcile one or more of those reconciled splits. The specific details of that behavior was changed a couple of times over several releases in the 3.x and 4.x series'. Two, the first time GnuCash tries to do that it warns you and gives you an opportunity to change your mind, but it is very easy to click on the button to never remind me again about this. Then, if you forget to go to Actions > Reset Warnings to get the warnings back, it is even easier to shoot yourself in the foot. Last night I tested my skill at fixing a reconciliation error a few months earlier and I noted that GnuCash will give 'incorrect' values for the reconciliation if there are any 'future' [after the reconciliation date] non-zero value transactions that have already been reconciled. In a way, this is a test for that sort of error. There is a third possible issue that can create a 'future' reconciled transaction. If a transaction was reconciled while it resided in account 'A', and subsequently was edited to reside in account 'B', GnuCash may not give the proper warning and un-reconcile that split line. I think this only happens in older releases. On Wed, Feb 23, 2022 at 9:34 AM Paul Kinzelman wrote: That's a good question and I think that could be an explanation for the resurrection of the reconciled transactions which happened quite awhile ago when I was new to GC. But that doesn't explain how a transaction could become reconciled on its own like the one that happened this month, which tipped me over the edge to post about it. On 2/23/2022 8:29 AM, Derek Atkins wrote: > Are you possibly opening up a backup file when you start GnuCash? > > -derek > > On Wed, February 23, 2022 10:23 am, Paul Kinzelman wrote: >> The latter is certainly possible, but it's strange that this started with >> gnucash, didn't happen with Quicken. But if nobody else has noticed >> this, then maybe it is the latter. :-) >> >> And I have NEVER connected it to my account, as you suggested, >> I ALWAYS enter everything by hand. >> >> Oh, and I'm using the Windows latest version. >> >> A while ago, I remember seeing a number of transactions which were >> marked as reconciled become unreconciled as well, and it balanced after >> I checked them as reconciled again the next month. >> >> The real kicker was the one item I noticed that came up reconciled >> this month as tho I had done it last month. And I couldn't have done it >> last month or else it would have been unbalanced. And the charge >> was not on last month's statement. >> >> But if nobody else has seen anything like this, maybe it is something >> I'm doing. But it's strange that I never saw it with Quicken, thus my >> post. >> >> On 2/23/2022 7:51 AM, Derek Atkins wrote: >>> HI, >>> >>> On Wed, February 23, 2022 9:35 am, Paul Kinzelman wrote: >>>> I always balance my accounts every month. I used to use Quicken before >>>> they went to a rental model. Credit cards always balanced every month >>>> for me. >>>> >>>> I've been using GC for several years now, and notice that I sometimes >>>> can't >>>> get cards to balance, I have to add an imbalance amount. Then this >>>> month, I noticed that a charge that was on this month's statement >>>> and not last month's statement was already marked as reconciled in GC. >>>> >>>> Has anybody else noticed anything like this? >>>> >>>> I don't even know how to track this kind of thing down, whether it's >>>> a bug, or I'm just getting older and senile. :-) >>> without being rude, I would suggest the latter. >>> How are you entering your transactions? >>> I always enter them manually (I NEVER import), and when I have a problem >>> balancing I find it's *ALMOS
Re: [GNC] reconcile problem?
That's a good question and I think that could be an explanation for the resurrection of the reconciled transactions which happened quite awhile ago when I was new to GC. But that doesn't explain how a transaction could become reconciled on its own like the one that happened this month, which tipped me over the edge to post about it. On 2/23/2022 8:29 AM, Derek Atkins wrote: Are you possibly opening up a backup file when you start GnuCash? -derek On Wed, February 23, 2022 10:23 am, Paul Kinzelman wrote: The latter is certainly possible, but it's strange that this started with gnucash, didn't happen with Quicken. But if nobody else has noticed this, then maybe it is the latter. :-) And I have NEVER connected it to my account, as you suggested, I ALWAYS enter everything by hand. Oh, and I'm using the Windows latest version. A while ago, I remember seeing a number of transactions which were marked as reconciled become unreconciled as well, and it balanced after I checked them as reconciled again the next month. The real kicker was the one item I noticed that came up reconciled this month as tho I had done it last month. And I couldn't have done it last month or else it would have been unbalanced. And the charge was not on last month's statement. But if nobody else has seen anything like this, maybe it is something I'm doing. But it's strange that I never saw it with Quicken, thus my post. On 2/23/2022 7:51 AM, Derek Atkins wrote: HI, On Wed, February 23, 2022 9:35 am, Paul Kinzelman wrote: I always balance my accounts every month. I used to use Quicken before they went to a rental model. Credit cards always balanced every month for me. I've been using GC for several years now, and notice that I sometimes can't get cards to balance, I have to add an imbalance amount. Then this month, I noticed that a charge that was on this month's statement and not last month's statement was already marked as reconciled in GC. Has anybody else noticed anything like this? I don't even know how to track this kind of thing down, whether it's a bug, or I'm just getting older and senile. :-) without being rude, I would suggest the latter. How are you entering your transactions? I always enter them manually (I NEVER import), and when I have a problem balancing I find it's *ALMOST ALWAYS* an error on my part (especially with my wife's card, because I don't get receipts from any online shopping she does). When entering I find I sometimes swap digits, which causes the result to be off. Every once in a while I have to cancel the reconcile and start over and CAREFULLY watch the numbers to find where I entered something incorrectly. If you find you're off, then check again -- most likely something was entered wrong. Either that or you modified an existing, reconciled transaction (from the other side) which caused a break in that starting balance. Ideas? TIA! Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. -derek ___ 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] reconcile problem?
The latter is certainly possible, but it's strange that this started with gnucash, didn't happen with Quicken. But if nobody else has noticed this, then maybe it is the latter. :-) And I have NEVER connected it to my account, as you suggested, I ALWAYS enter everything by hand. Oh, and I'm using the Windows latest version. A while ago, I remember seeing a number of transactions which were marked as reconciled become unreconciled as well, and it balanced after I checked them as reconciled again the next month. The real kicker was the one item I noticed that came up reconciled this month as tho I had done it last month. And I couldn't have done it last month or else it would have been unbalanced. And the charge was not on last month's statement. But if nobody else has seen anything like this, maybe it is something I'm doing. But it's strange that I never saw it with Quicken, thus my post. On 2/23/2022 7:51 AM, Derek Atkins wrote: HI, On Wed, February 23, 2022 9:35 am, Paul Kinzelman wrote: I always balance my accounts every month. I used to use Quicken before they went to a rental model. Credit cards always balanced every month for me. I've been using GC for several years now, and notice that I sometimes can't get cards to balance, I have to add an imbalance amount. Then this month, I noticed that a charge that was on this month's statement and not last month's statement was already marked as reconciled in GC. Has anybody else noticed anything like this? I don't even know how to track this kind of thing down, whether it's a bug, or I'm just getting older and senile. :-) without being rude, I would suggest the latter. How are you entering your transactions? I always enter them manually (I NEVER import), and when I have a problem balancing I find it's *ALMOST ALWAYS* an error on my part (especially with my wife's card, because I don't get receipts from any online shopping she does). When entering I find I sometimes swap digits, which causes the result to be off. Every once in a while I have to cancel the reconcile and start over and CAREFULLY watch the numbers to find where I entered something incorrectly. If you find you're off, then check again -- most likely something was entered wrong. Either that or you modified an existing, reconciled transaction (from the other side) which caused a break in that starting balance. Ideas? TIA! Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. -derek ___ 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] reconcile problem?
I always balance my accounts every month. I used to use Quicken before they went to a rental model. Credit cards always balanced every month for me. I've been using GC for several years now, and notice that I sometimes can't get cards to balance, I have to add an imbalance amount. Then this month, I noticed that a charge that was on this month's statement and not last month's statement was already marked as reconciled in GC. Has anybody else noticed anything like this? I don't even know how to track this kind of thing down, whether it's a bug, or I'm just getting older and senile. :-) Ideas? TIA! ___ 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] exporting search?
Thank you. That's what I did, but there wasn't an obvious way to export that account. On 2/19/2022 6:35 PM, D. wrote: Personally, I'd have a separate account for medical expenses, and then a transaction report for that account would quickly give me totals for any given period. *From:* Geoff *Sent:* Sat Feb 19 18:32:43 EST 2022 *To:* p...@kinzelman.com, Gnucash Elist *Subject:* Re: [GNC] exporting search? Hi Paul Your original request said you required a list of expenses. If you only want the totals amount, there is no need to export at all. Just scroll to the bottom of the Account Report, which shows the the total Debits, Credits, and Balance. As to your other useful suggestions, please excuse the editorial. I see that the lead article on your web site is titled "The Importance of Building a Strong Community". The great thing about GnuCash is that it is built, maintained, and supported by a wonderful volunteer open source community. Please feel free to join us. I am sure that someone with your background and experience could make and make a valuable contribution: https://wiki.gnucash.org/wiki/Contributing_to_GnuCash Regards Geoff = On 20/02/2022 10:03 am, Paul Kinzelman wrote: Thank you! I see now how I can do that, but it's not all that convenient to do, seems like it would be something that lots of people would want to do. Copy/paste from HTML seems like not a good way to expect people to do it as well. All I want is a total of the columns of a search, seems like this ought to be a feature built in already. I also looked for this kind of search/export in the documentation and couldn't find it, it'd be nice to say something about that too. I tried things like "export search results" and nothing came up. Even "search results" didn't say much. A section on common things people like to do would be good. On 2/19/2022 3:40 PM, Geoff wrote: Hi Paul From the Search Results tab, choose Reports / Account Report. This opens a new tab with a variant of the Transaction Report showing just the transactions in your Search Results. The Report Options let you tweak which columns are displayed. From there, you can either File / Export / Report, or just select all and copy /paste. The export format is HTML, but it pastes into Microsoft Excel in a usable format. Regards Geoff = On 20/02/2022 6:49 am, Paul Kinzelman wrote: Is there some way to export search results? I was trying to get a list of medical expenses for the past year and I didn't see any easy way to do this, is there a good way to do it? I tried search but I couldn't export it or total the columns. It seems like I should be able to export this list - this is a general question. I tried income expense cash flow for the year, but it gave me just money-in and money-out. I was looking for detail to export to a spread sheet. I finally did File Export Transactions and got what I wanted but it seems like there should be an easier way. Suggestions? 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. 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 seehttps://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@g
Re: [GNC] exporting search?
Thank you! I see now how I can do that, but it's not all that convenient to do, seems like it would be something that lots of people would want to do. Copy/paste from HTML seems like not a good way to expect people to do it as well. All I want is a total of the columns of a search, seems like this ought to be a feature built in already. I also looked for this kind of search/export in the documentation and couldn't find it, it'd be nice to say something about that too. I tried things like "export search results" and nothing came up. Even "search results" didn't say much. A section on common things people like to do would be good. On 2/19/2022 3:40 PM, Geoff wrote: Hi Paul From the Search Results tab, choose Reports / Account Report. This opens a new tab with a variant of the Transaction Report showing just the transactions in your Search Results. The Report Options let you tweak which columns are displayed. From there, you can either File / Export / Report, or just select all and copy /paste. The export format is HTML, but it pastes into Microsoft Excel in a usable format. Regards Geoff = On 20/02/2022 6:49 am, Paul Kinzelman wrote: Is there some way to export search results? I was trying to get a list of medical expenses for the past year and I didn't see any easy way to do this, is there a good way to do it? I tried search but I couldn't export it or total the columns. It seems like I should be able to export this list - this is a general question. I tried income expense cash flow for the year, but it gave me just money-in and money-out. I was looking for detail to export to a spread sheet. I finally did File Export Transactions and got what I wanted but it seems like there should be an easier way. Suggestions? 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. ___ 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] exporting search?
Is there some way to export search results? I was trying to get a list of medical expenses for the past year and I didn't see any easy way to do this, is there a good way to do it? I tried search but I couldn't export it or total the columns. It seems like I should be able to export this list - this is a general question. I tried income expense cash flow for the year, but it gave me just money-in and money-out. I was looking for detail to export to a spread sheet. I finally did File Export Transactions and got what I wanted but it seems like there should be an easier way. Suggestions? 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.
Re: [GNC] Search results and Notes
Thank you. The ledger options are grayed out, I thought the double-line item was grayed out too. Glad to see I was wrong. On 11/12/2021 2:04 PM, john wrote: On Nov 12, 2021, at 12:22 PM, Paul Kinzelman wrote: When I do a search, the transaction 'Notes' line does not seem to appear under the search results tab. Is there a way to see and/or edit the Notes item in search? Select View>Double line from the menu. Regards, John Ralls ___ 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] Search results and Notes
When I do a search, the transaction 'Notes' line does not seem to appear under the search results tab. Is there a way to see and/or edit the Notes item in search? TIA! ___ 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] changing accounts?
You're a little bit fast for me on that one. :-) I did it by hand for what I needed right now, but I was asking for next time. In the 3rd paragraph, by "separate register" do you mean create a temp account, and by "putting them in a separate register" do you mean cut/paste each transaction? Then delete the temp and move the transactions to the new account? The replace is one of the features I really miss from Quicken. On 11/10/2021 3:37 PM, D. wrote: If you're changing every ABC to DEF, you can delete ABC and tell gnucash to move the transactions into DEF. That's documented in the wiki. If you're only deleting a bunch (but not all) there isn't one find and replace command. When push comes to shove, though, even fixing 100 transactions will only take a few minutes' time. If it were me in this second scenario (and it has been, believe me!), I'd search for the offending transactions, putting them all in a separate register, copy the new account designation, and paste it into each transaction at the appropriate point before pressing enter to commit them away. David ---- *From:* Paul Kinzelman *Sent:* Wed Nov 10 17:25:51 EST 2021 *To:* Gnucash Elist *Subject:* [GNC] changing accounts? Is there some way to change all the entries for a set of items in an account to be charged to one account to charge them all to another account? For instance, if I have a monthly charge from XYZ that I charge to account ABC, and I have a bunch of them in my Checking account, is there a way to change all of them to DEF without going in and poking each one? And that's where a simple account name change ABC->DEF won't work because there's other stuff in there. In other words, like a global replace? TIA! 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 seehttps://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] changing accounts?
Is there some way to change all the entries for a set of items in an account to be charged to one account to charge them all to another account? For instance, if I have a monthly charge from XYZ that I charge to account ABC, and I have a bunch of them in my Checking account, is there a way to change all of them to DEF without going in and poking each one? And that's where a simple account name change ABC->DEF won't work because there's other stuff in there. In other words, like a global replace? TIA! ___ 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] editing memorized transactions
Thanks! I know about the scheduled one, already use it. Steve I think hit the nail on the head. I tried a little experiment and I think he's right. Thanks for your time! On 10/29/2021 12:33 PM, David Carlson wrote: GnuCash has a Scheduled Transaction feature when you want a transaction to reappear on a regular basis. On Fri, Oct 29, 2021, 12:19 PM Paul Kinzelman wrote: Wow, I had no idea. I thought it kept track of them in a table someplace (like Quicken does), but a quick test seems to show what you said is how it works. Thanks a bunch! On 10/29/2021 10:51 AM, Steve Butler wrote: > I believe it simply looks backwards in that account's transactions to > find the most recent with the same description. > > Hence it is automatically updated with the most recent transaction > having that description. > > At least that has been my observation. > > On Fri, Oct 29, 2021, 09:41 Paul Kinzelman wrote: > > Sorry, I guess I wasn't clear, I'm not concerned about a single > transaction, > I'd like access to the table that holds the list of memorized > transactions so I can delete or edit transactions in the list. > > some items have typos in them and I'd like to delete them, > for instance. > > On 10/29/2021 10:34 AM, Steve Butler wrote: > > Yes. > > > > > > > > Just type over what you want. Or click on a split (line) and then > > click on the delete menu item. > > > > On Fri, Oct 29, 2021, 09:08 Paul Kinzelman > wrote: > > > > ...or whatever gnucash calls them. > > > > When you start typing in a transaction, it fills out one > that you've > > used in the past. > > > > Is there some way to edit or delete entries in this list? > > > > TIA! > > > > ___ > > 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. > ___ 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] editing memorized transactions
Wow, I had no idea. I thought it kept track of them in a table someplace
(like Quicken does), but a quick test seems to show what you said is how
it works.
Thanks a bunch!
On 10/29/2021 10:51 AM, Steve Butler wrote:
I believe it simply looks backwards in that account's transactions to
find the most recent with the same description.
Hence it is automatically updated with the most recent transaction
having that description.
At least that has been my observation.
On Fri, Oct 29, 2021, 09:41 Paul Kinzelman wrote:
Sorry, I guess I wasn't clear, I'm not concerned about a single
transaction,
I'd like access to the table that holds the list of memorized
transactions so I can delete or edit transactions in the list.
some items have typos in them and I'd like to delete them,
for instance.
On 10/29/2021 10:34 AM, Steve Butler wrote:
> Yes.
>
>
>
> Just type over what you want. Or click on a split (line) and then
> click on the delete menu item.
>
> On Fri, Oct 29, 2021, 09:08 Paul Kinzelman
wrote:
>
> ...or whatever gnucash calls them.
>
> When you start typing in a transaction, it fills out one
that you've
> used in the past.
>
> Is there some way to edit or delete entries in this list?
>
> TIA!
>
> ___
> 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.
___
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] editing memorized transactions
Sorry, I guess I wasn't clear, I'm not concerned about a single transaction, I'd like access to the table that holds the list of memorized transactions so I can delete or edit transactions in the list. some items have typos in them and I'd like to delete them, for instance. On 10/29/2021 10:34 AM, Steve Butler wrote: Yes. Just type over what you want. Or click on a split (line) and then click on the delete menu item. On Fri, Oct 29, 2021, 09:08 Paul Kinzelman wrote: ...or whatever gnucash calls them. When you start typing in a transaction, it fills out one that you've used in the past. Is there some way to edit or delete entries in this list? TIA! ___ 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] editing memorized transactions
...or whatever gnucash calls them. When you start typing in a transaction, it fills out one that you've used in the past. Is there some way to edit or delete entries in this list? TIA! ___ 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] Finding sales tax liability
On 7/10/2021 7:12 PM, Christopher Lam wrote: The Income GST report has undergone only one significant change: the "accounts" option replaced with "sales" and "purchases". I wasn't using Reports at all. There was a pulldown, I think it was under Business, maybe next to the current 'Sales Tax Table' item, that would list the transactions related to sales tax collected. But it's not there now. But I see now Reports | Income & Expense Reports | Income & GST statement, I think I can select items that will give me the equivalent. Thank you, I didn't know about that. So I'll use that. It would be useful if you would disclose your book account structure, and the options changed in the report. I don't know what you're looking for under 'account structure'? Both Sales and Interest have "tax related" checked. But that's for income tax forms, not gross receipts, right? If you tell me how to disclose that, I could do so. I have an account Income | Sales - that is subject to Gross Receipts tax and an account Income | Interest - that is not subject to GRT You're saying under the GST Report options I need to select 'Sales' and deselect 'Interest', right? Maybe you had included "interest income" in your sales and need to deselect it. I assume you mean under the Report you suggested? The Income and GST Statement? Yes, I deselected it and it seems to work. Thanks! On Sat, 10 Jul 2021, 10:36 am Paul Kinzelman, <mailto:p...@kinzelman.com>> wrote: Thank you, but that doesn't really work because it looks like it lumps sales (which requires Gross Receipts Tax) and interest on the bank account (which does not). Is there some way to differentiate this, like some way for interest and any other income to be separated from actual sales? It seemed to work just fine previously, was the capability removed for some reason? Thanks! -Paul Kinzelman On 7/9/2021 4:46 PM, Christopher Lam wrote: It's likely the Income and GST statement report can be used for your purposes. On Tue, 6 Jul 2021, 10:47 pm Paul Kinzelman, mailto:p...@kinzelman.com>> wrote: This is for a business that sells stuff and keeps track of sales tax. At the end of the reporting period, I need a report of the sales tax owed to the state. With previous versions it was easy, there was a pull-down item for getting a report of the sales tax but I can't remember where exactly it was, I think it was under Business | Vendor or maybe Actions? But in any event, I can't find it anywhere now, nor does the documentation seem to help. How do I find the sales tax accumulated during the reporting period? And is it in the docs anywhere? Thanks! ___ gnucash-user mailing list gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user <https://lists.gnucash.org/mailman/listinfo/gnucash-user> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists <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] Finding sales tax liability
Thank you, but that doesn't really work because it looks like it lumps sales (which requires Gross Receipts Tax) and interest on the bank account (which does not). Is there some way to differentiate this, like some way for interest and any other income to be separated from actual sales? It seemed to work just fine previously, was the capability removed for some reason? Thanks! -Paul Kinzelman On 7/9/2021 4:46 PM, Christopher Lam wrote: It's likely the Income and GST statement report can be used for your purposes. On Tue, 6 Jul 2021, 10:47 pm Paul Kinzelman, <mailto:p...@kinzelman.com>> wrote: This is for a business that sells stuff and keeps track of sales tax. At the end of the reporting period, I need a report of the sales tax owed to the state. With previous versions it was easy, there was a pull-down item for getting a report of the sales tax but I can't remember where exactly it was, I think it was under Business | Vendor or maybe Actions? But in any event, I can't find it anywhere now, nor does the documentation seem to help. How do I find the sales tax accumulated during the reporting period? And is it in the docs anywhere? Thanks! ___ gnucash-user mailing list gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user <https://lists.gnucash.org/mailman/listinfo/gnucash-user> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists <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] Finding sales tax liability
This is for a business that sells stuff and keeps track of sales tax. At the end of the reporting period, I need a report of the sales tax owed to the state. With previous versions it was easy, there was a pull-down item for getting a report of the sales tax but I can't remember where exactly it was, I think it was under Business | Vendor or maybe Actions? But in any event, I can't find it anywhere now, nor does the documentation seem to help. How do I find the sales tax accumulated during the reporting period? And is it in the docs anywhere? 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] How to Find... account
I've read thru the documentation about find and have a couple of questions to which I can't find the answers in the docs... Every time I go invoke Find, it comes up with the Refine current search option set, not New search, and I'm wondering why this is if I haven't done a previous search since I started gnucash? Why wouldn't a new Find start out with New Search by default? To do a Refine search, does the previous search have to be displayed in a tabbed window or does it remember the previous search somehow? And why even have that option when you can just do another Find while focused on the search results window of the previous search? More specifically, I don't understand the difference between 'Account' and 'All Accounts' as described in the documentation and I'm confused by the d and e footnotes. If I have an account open (like Visa) and I'm searching for a transaction with the Expenses:Computer account in Visa, if I do: Account | matches any account | Choose Accounts... Expenses:Computer nothing will be found. But if I do All Accounts | matches all accounts | Choose Accounts... Expenses:Computer the transactions I want *are* found. Why is that? In other words, footnote 'd' implies to me that the Account I specify there merely establishes the account in which I want to search, but then how do I specify the 'Transfer' account entry for which I'm searching within that account? ___ 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] Cut/paste between databases
In that case, it'd be good to clear the transaction paste buffer when reading in a new file so that people won't make the mistake of thinking they can cut/paste between databases. On 5/7/2021 10:00 AM, gnucash-user-requ...@gnucash.org wrote: Send gnucash-user mailing list submissions to gnucash-user@gnucash.org To subscribe or unsubscribe via the World Wide Web, visit https://lists.gnucash.org/mailman/listinfo/gnucash-user or, via email, send a message with subject or body 'help' to gnucash-user-requ...@gnucash.org You can reach the person managing the list at gnucash-user-ow...@gnucash.org When replying, please edit your Subject line so it is more specific than "Re: Contents of gnucash-user digest..." Today's Topics: 1. Re: Cut/paste between databases (John Ralls) 2. Re: Cut/paste between databases (John Ralls) -- Message: 1 Date: Thu, 6 May 2021 09:02:26 -0700 From: John Ralls To: GnuCash-User Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Cut/paste between databases Message-ID: <39da7616-d409-467a-bcef-d30507837...@ceridwen.us> Content-Type: text/plain; charset=us-ascii It can't work, the account GUIDs from the one book won't be valid in the other book. Regards, John Ralls On May 6, 2021, at 3:31 AM, Liz wrote: On Wed, 5 May 2021 13:40:13 -0600 Paul Kinzelman wrote: I'm running gnucash 4.5 I've got two gnucash databases (personal and business) and I accidentally entered a charge into one instead of the other. So I tried cut from one and paste into the other and it didn't work. When I pasted, I got only the Description got pasted, and I filled in the rest of the transaction manually, but I couldn't get it to enter. The 'Enter' key did nothing and the transaction still stayed open. I had to cancel the transaction and enter the whole thing by hand and it worked. It'd not a big deal to get it fixed, or maybe copy/paste isn't supposed to work between databases? I agree, it doesn't work, and I haven't tried to do it for a long time. Liz ___ 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. -- Message: 2 Date: Thu, 6 May 2021 09:02:26 -0700 From: John Ralls To: GnuCash-User Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Cut/paste between databases Message-ID: <39da7616-d409-467a-bcef-d30507837...@ceridwen.us> Content-Type: text/plain; charset=us-ascii It can't work, the account GUIDs from the one book won't be valid in the other book. Regards, John Ralls On May 6, 2021, at 3:31 AM, Liz wrote: On Wed, 5 May 2021 13:40:13 -0600 Paul Kinzelman wrote: I'm running gnucash 4.5 I've got two gnucash databases (personal and business) and I accidentally entered a charge into one instead of the other. So I tried cut from one and paste into the other and it didn't work. When I pasted, I got only the Description got pasted, and I filled in the rest of the transaction manually, but I couldn't get it to enter. The 'Enter' key did nothing and the transaction still stayed open. I had to cancel the transaction and enter the whole thing by hand and it worked. It'd not a big deal to get it fixed, or maybe copy/paste isn't supposed to work between databases? I agree, it doesn't work, and I haven't tried to do it for a long time. Liz ___ 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. -- Subject: Digest Footer ___ 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. -- End of gnucash-user Digest, Vol 218, Issue 10
[GNC] Cut/paste between databases
I'm running gnucash 4.5 I've got two gnucash databases (personal and business) and I accidentally entered a charge into one instead of the other. So I tried cut from one and paste into the other and it didn't work. When I pasted, I got only the Description got pasted, and I filled in the rest of the transaction manually, but I couldn't get it to enter. The 'Enter' key did nothing and the transaction still stayed open. I had to cancel the transaction and enter the whole thing by hand and it worked. It'd not a big deal to get it fixed, or maybe copy/paste isn't supposed to work between databases? ___ 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 get invoices to appear in the Reports|Tax schedule report?
Thanks for the quick reply! I looked and the invoice shows Income:Sales as you said it should. So then I did another Report|TaxSchedReport and now it's working, I can see that income. Science lurches onward. :-) I think what might have happened was that I was running 4.2, couldn't get it to work, so I upgraded to 4.4 before I posted the question and maybe it did work but I didn't notice, and by that time I was confused. Perhaps there was a bug in this area in 4.2? On 2/11/2021 11:36 AM, Derek Atkins wrote: Hi, On Thu, February 11, 2021 1:28 pm, Paul Kinzelman wrote: I'm running GC 4.4 I'm having trouble generating a tax report that includes paid invoices. I'm not an accounting heavy-weight so I'm likely doing something wrong, but I don't know what it is. I created an invoice for a customer and posted it. What I see is the money went into AccountsReceivable which is right. Then they pay the invoice and I mark the invoice as paid. The money goes from AccountsReceivable into Checking. So when I look at the Checking account, the money says it came from the AccountsReceivable account. However, this money never appears in an Income account. UMM.. So what account(s) are you specifying on the line-items in the Invoice? When you post it to A/R -- what are the *other* split-accounts on that posted transaction? Those should be your Income accounts. So when I do a Reports|TaxScheduleReport that amount doesn't appear anywhere in the report so that income is missed because AccountsReceivable is not set to be Tax Related but it seems like it should be. Sounds like you're not entering your invoices correctly. So if I go to Edit|TaxReport to try to make AccountsReceivable be tax related, it does not give me the option to bind it to Schedule C like all the other accounts allow. It allows only: Tax Report Only - No TXF Report F8606 IRA basis at beg of year F8606 IRA basis at end of year HomeWks Cost of new home Yeah, don't do that. A/R isn't a Tax account. Shouldn't I be able to specify the AccountsReceivable account to be binded to Schedule C Sales income? No. A/R is an Asset. To get around it I can change the entry in the checking account for the amount to come from Income:Sales and it works but I shouldn't have to do that. Indeed. It should be Income:Sales -> A/R and then A/R -> Checking. Shouldn't a paid invoice amount (from AccountsReceivable) somehow appear in Income:Sales? Or is that for cash-basis accounting and I do want it in Accounts:Receiveable for Accrual basis? And if so, shouldn't AccountsReceivable be able to be designated to appear in my Schedule C under Income? It should appear in Income:Sales when you post the invoice (not when you pay it). If it is not doing that, you're mis-assigning your invoice line-items. TIA! -Paul Kinzelman, Peralta NM Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. -derek ___ 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 get invoices to appear in the Reports|Tax schedule report?
I'm running GC 4.4 I'm having trouble generating a tax report that includes paid invoices. I'm not an accounting heavy-weight so I'm likely doing something wrong, but I don't know what it is. I created an invoice for a customer and posted it. What I see is the money went into AccountsReceivable which is right. Then they pay the invoice and I mark the invoice as paid. The money goes from AccountsReceivable into Checking. So when I look at the Checking account, the money says it came from the AccountsReceivable account. However, this money never appears in an Income account. So when I do a Reports|TaxScheduleReport that amount doesn't appear anywhere in the report so that income is missed because AccountsReceivable is not set to be Tax Related but it seems like it should be. So if I go to Edit|TaxReport to try to make AccountsReceivable be tax related, it does not give me the option to bind it to Schedule C like all the other accounts allow. It allows only: Tax Report Only - No TXF Report F8606 IRA basis at beg of year F8606 IRA basis at end of year HomeWks Cost of new home Shouldn't I be able to specify the AccountsReceivable account to be binded to Schedule C Sales income? To get around it I can change the entry in the checking account for the amount to come from Income:Sales and it works but I shouldn't have to do that. Shouldn't a paid invoice amount (from AccountsReceivable) somehow appear in Income:Sales? Or is that for cash-basis accounting and I do want it in Accounts:Receiveable for Accrual basis? And if so, shouldn't AccountsReceivable be able to be designated to appear in my Schedule C under Income? TIA! -Paul Kinzelman, Peralta NM ___ 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] When reconciling an account, the proper interest account should come up
I've asked this a couple of times over the last year but never got an answer to it, but I've stumbled over the answer, so for others who might be having problems with it, this is how it works. I think it's a bug that ought to be fixed sometime, but at least I can get it to work. The issue is when I'm reconciling a savings account, the interest screen pops up for me to enter the interest, but the account for entering the interest (the left window at the bottom) is the same as the account I'm reconciling which is obviously not correct. Every time I reconciled the account, I had to manually select the proper account for recording the interest. The proper account, probably the one that was used last month, should just pop up but it doesn't. However, if you enter a proper description (probably the one used the previous month) like "Interest", and then TAB to the next field, the proper account does pop up in the lower left select window. If you don't hit TAB, the proper account does not get automatically selected. ___ 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.
[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.
[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.
Re: [GNC] cut/paste problem in 3.4?
Thanks for your replies, also to David T, your way of moving a transaction had not occurred to me before. I'll try that next time. I figured the copy/paste would work more easily, hadn't occurred to me that it was for going between different files. I'm just curious where GC stashes the transaction, doesn't seem to be on the standard copy/paste clipboard because I don't see it when I paste into a text editor. But it has to go someplace globally to be able to move between 2 different GC files. BTW, the transaction was same currency, same file, vanilla transaction. And Adrien, your test case captured what I did. And I don't think it's the keyboard, these laptop keys are pretty tight and I haven't spilled coffee or beer on it. :-) The control and C keys always work at other times reliably. I think the best thing to do at this point is to declare victory and move on because it's not repeatable. Maybe play with it a bit if it happens again. On 7/2/2019 1:23 PM, gnucash-user-requ...@gnucash.org wrote: So, until or unless you could make it repeat the issue intentionally and repeatedly with the same steps, I?m afraid this one will have to be offered up to the digital gods to sort out. Finally, don?t discount a key not functioning. I?ve run myself ragged trying to figure out keyboard shortcuts not working properly (especially with cmd/ctrl/alt keys) only to discover that after removing the key caps, I saw some gunk underneath that was preventing the keypress from registering, though I was banging the heck out of it. A little cleaning with a q-tip and some rubbing alcohol, and... "magic!? You can bring up an onscreen keyboard viewer that will highlight a key as you press it. Using that, you might see if the CTRL key is sticking or missing. (and test the other CTRL key as well) ___ 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] cut/paste problem in 3.4?
Thanks for the suggestion, I'll try to remember that. I've been using gnucash for almost a year and I'd never seen it before tho I don't cut/paste whole transactions very often so I don't know when it'll come up again. I have done transaction copy/paste successfully in the past, so it is intermittent. I don't think it's a focus problem or it would not have deleted the transaction from the source. I didn't focus in any other app between the cut and the paste, and the destination did focus when I clicked on the tab just before doing the paste. So you're saying that if gnucash doesn't see a paste right after a cut, it puts the transaction back where it came from? That makes sense for it to do that. But I'm curious, where does gnucash stash the cut transaction? It doesn't seem to be in the standard clipboard. Now that you mention it, I have noticed that if I do a simple copy/paste of text between like Firefox and emacs (not in gnucash) sometimes it would not work (paste would get previous contents), so I've gotten into the habit of hitting ^C about 30 times (that many because I'm pissed that I have to do it more than once :-) whenever I want to copy. I've seen that behavior intermittently on W10 on a previous laptop and now on this one too. Maybe it's a W10 issue. On 7/1/2019 9:35 PM, gnucash-user-requ...@gnucash.org wrote: Date: Mon, 1 Jul 2019 16:23:26 -0500 From: Adrien Monteleone To: Users Gnucash Subject: Re: [GNC] cut/paste problem in 3.4? Message-ID:<72f7c2e7-232e-4308-9665-66e8538ec...@lusfiber.net> Content-Type: text/plain; charset=utf-8 Might indeed be a stray cosmic ray, or temporarily insane electrons, but this stood out for me: Earlier when I saw the problem, the cut did work, the transaction vanished from the source account, but when I pasted it into the destination account, it magically appeared again in the source account but not the destination account. My first suspicion would be a mouse/window focus problem. It did paste it, but not in the window you were expecting it to. Since you can paste into emacs, the problem is either intermittent, or somehow limited to GnuCash. I do know GnuCash on MacOS at least, has a focus problem where you must click the title bar sometimes to get it to accept input even though the window ?appears? to be in focus. If that?s your OS, do a search for some threads in the last 6-8 months and something might pop up. I think though this isn?t a GnuCash bug, but a GTK+ bug. (if I recall correctly.) Maybe do a trial with clicking the GnuCash title bar first, then pasting, and see which window it gets pasted into. ___ 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] gnucash-user Digest, Vol 196, Issue 5
Thanks for the suggestion, I'll try to remember that. I've been using gnucash for almost a year and I'd never seen it before tho I don't cut/paste whole transactions very often so I don't know when it'll come up again. I have done transaction copy/paste successfully in the past, so it is intermittent. I don't think it's a focus problem or it would not have deleted the transaction from the source. I didn't focus in any other app between the cut and the paste, and the destination did focus when I clicked on the tab just before doing the paste. So you're saying that if gnucash doesn't see a paste right after a cut, it puts the transaction back where it came from? That makes sense for it to do that. But I'm curious, where does gnucash stash the cut transaction? It doesn't seem to be in the standard clipboard. Now that you mention it, I have noticed that if I do a simple copy/paste of text between like Firefox and emacs (not in gnucash) sometimes it would not work (paste would get previous contents), so I've gotten into the habit of hitting ^C about 30 times (that many because I'm pissed that I have to do it more than once :-) whenever I want to copy. I've seen that behavior intermittently on W10 on a previous laptop and now on this one too. Maybe it's a W10 issue. On 7/1/2019 9:35 PM, gnucash-user-requ...@gnucash.org wrote: Date: Mon, 1 Jul 2019 16:23:26 -0500 From: Adrien Monteleone To: Users Gnucash Subject: Re: [GNC] cut/paste problem in 3.4? Message-ID:<72f7c2e7-232e-4308-9665-66e8538ec...@lusfiber.net> Content-Type: text/plain; charset=utf-8 Might indeed be a stray cosmic ray, or temporarily insane electrons, but this stood out for me: Earlier when I saw the problem, the cut did work, the transaction vanished from the source account, but when I pasted it into the destination account, it magically appeared again in the source account but not the destination account. My first suspicion would be a mouse/window focus problem. It did paste it, but not in the window you were expecting it to. Since you can paste into emacs, the problem is either intermittent, or somehow limited to GnuCash. I do know GnuCash on MacOS at least, has a focus problem where you must click the title bar sometimes to get it to accept input even though the window ?appears? to be in focus. If that?s your OS, do a search for some threads in the last 6-8 months and something might pop up. I think though this isn?t a GnuCash bug, but a GTK+ bug. (if I recall correctly.) Maybe do a trial with clicking the GnuCash title bar first, then pasting, and see which window it gets pasted into. ___ 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] cut/paste problem in 3.4?
Hadn't thought of that. I had already exited when I saw your suggestion and when I started up gnucash again, that same sequence to/from the same accounts as before now works. Perhaps copy/paste works only in the afternoons, not mornings. :-) Earlier when I saw the problem, the cut did work, the transaction vanished from the source account, but when I pasted it into the destination account, it magically appeared again in the source account but not the destination account. I also tried cutting a transaction, then pasting into a text editor (emacs) and the transaction does not paste so they must hide it someplace else other than the standard clipboard. I can cut/copy text from one of the gnucash fields and paste it in emacs so that part works with the standard clipboard. Anyway, thanks for the suggestion, I guess I'll chalk it up to a stray cosmic ray. On 7/1/2019 2:56 PM, gnucash-user-requ...@gnucash.org wrote: Date: Mon, 1 Jul 2019 15:48:53 -0500 From: Adrien Monteleone To: Users Gnucash Subject: Re: [GNC] cut/paste problem in 3.4? Message-ID: Content-Type: text/plain; charset=utf-8 Have you tried pasting into something like a plain text editor after cutting? Perhaps the clipboard is not picking up the ?cut? but GnuCash is still removing the data. Anytime I have a pasting problem I always test in a plain text editor to see if that is the issue. Regards, Adrien On Jul 1, 2019, at 3:30 PM, Paul Kinzelman wrote: I just tried cutting a transaction in one account, and I saw it vanish. I went to another account, pasted it, and it wasn't there, it had gone back to the account where it was before I cut it. So I carefully repeated the cut/paste and it did that again. So I deleted it from the one account, and typed it in manually into the other account and it worked. Has anybody else seen anything like this? ___ 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] cut/paste problem in 3.4?
I just tried cutting a transaction in one account, and I saw it vanish. I went to another account, pasted it, and it wasn't there, it had gone back to the account where it was before I cut it. So I carefully repeated the cut/paste and it did that again. So I deleted it from the one account, and typed it in manually into the other account and it worked. Has anybody else seen anything like this? ___ 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] reconcile - remembering the proper account for interest
I posted this a month or 2 ago, didn't see any response, my apologies if somebody responded. I'm now using 3.4 Build ID: 3.4+ (2018-12-30) When I reconcile an interest-bearing bank account, the interest window pops up, but it doesn't remember the account to which i posted the interest the previous month. The Payment From and the Reconcile Account accounts are both the same so every month I have to change to the income account for the interest. Is there a way to get GC to remember this info? I seem to recall that occasionally it does the right thing (remembers the account from last month) but usually doesn't. This happened with 3.3 as well. 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] report filtering
I'm using GC3.3 and trying to get a report out. I used somebody's advice and put in a text string in the 'Number' field for certain transactions of interest, say "xyz". How do I create a report that contains just those transactions that I labeled as xyz in the number field? I tried Reports | Transaction Report and edited the options and put in "xyz" for Filter | Transaction Filter but that doesn't work probably because according to the hover-help, the Transaction Filter looks only at the description, notes and memo fields? It doesn't look like there's a way to filter one specified field? So any filtering is limited to those three fields? ___ 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] remembering the interest account
I'm running V3.3 on Windows 10. Every time I balance a savings account with interest, the interest pop-up does not remember the account for the interest income from the previous month. Is there a way to have it remember this so I don't have to specify it every month? TIA! ___ 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] Trying to use gnucash need to convert .qdf to /qif
Perhaps your Quicken had no transfers between accounts? I posted in this list and was told that's how it is because the transfer appears in two places in the QIF file and figuring out that it's the same transaction was not worth implementing in the import code. I also tried editing the QIF code manually but finally gave up because that merely moved the manual intervention, didn't eliminate them. Best thing to do is be aware of the issue and just try it and see what happens, then post your results here. On 11/2/2018 9:17 AM, D wrote: On November 2, 2018, at 5:59 PM, Paul Kinzelman wrote: >Yes, there should be an Export... QIF function in Quicken. >I did that recently for a club account which was pretty straight-forward, >no stocks, etc. >The main problem I found was that when your Quicken database >has a transfer from one account to the other, when you import >the QIF file into Gnucash, all the transfers will be duplicated. >You have to manually go through and >delete one of the duplicated transactions for every transfer. Many years ago, I made the jump with a quicken file that had all sorts of accounts. I had no problems with duplicates, although capital gains were a challenge. David T. >On 11/2/2018 8:12 AM, David Carlson wrote: >> If I recall correctly QDF format is a proprietary and encrypted format >> owned by Intuit. The only way to extarct the data is to use the Guicken >> program to open the file and then export to QIF format. Hang on to Quicken >> until you have experimented with importing the QIF files into GnuCash to be >> sure that you are getting satisfactory results. >> >> David C >> >> On Fri, Nov 2, 2018 at 4:17 AM Mark Schwomeyer via gnucash-user < >> gnucash-user@gnucash.org> wrote: >> >>> GreetingsWe have for years used Quicken, (1998 at least) (latest is 2008) >>> they have went to a paid subscription service. (I think is overpriced)That >>> said I have used Open Office for a while and thought to look for a open >>> source financial program.The search for programs listed that GNUCASH would >>> be compatible with .qdf >>> GNUCASH was chosen and downloaded. I need to import the latest file >>> (backup).The only choice was to import a .qif file. Our version of Quicken >>> used .qdf as a working extension and as backup files.I have downloaded a >>> conversion program attached to Mozilla, but the convert button only wants >>> to convert pdf .doc >>> compress, .jpg, .ppt. Maybe a couple others, but no .qdf.The program I >>> downloaded, under further investigation, is a .pdf conversion program. [ >>> fileconverter.org] Although it listed .qdf on the page. >>> Does anyone know of a conversion for .qdf to .qif so I can use gnucash. >>> Thanks Mark >>> ___ >>> 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. >___ >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] Trying to use gnucash need to convert .qdf to /qif
Yes, there should be an Export... QIF function in Quicken. I did that recently for a club account which was pretty straight-forward, no stocks, etc. The main problem I found was that when your Quicken database has a transfer from one account to the other, when you import the QIF file into Gnucash, all the transfers will be duplicated. You have to manually go through and delete one of the duplicated transactions for every transfer. On 11/2/2018 8:12 AM, David Carlson wrote: If I recall correctly QDF format is a proprietary and encrypted format owned by Intuit. The only way to extarct the data is to use the Guicken program to open the file and then export to QIF format. Hang on to Quicken until you have experimented with importing the QIF files into GnuCash to be sure that you are getting satisfactory results. David C On Fri, Nov 2, 2018 at 4:17 AM Mark Schwomeyer via gnucash-user < gnucash-user@gnucash.org> wrote: GreetingsWe have for years used Quicken, (1998 at least) (latest is 2008) they have went to a paid subscription service. (I think is overpriced)That said I have used Open Office for a while and thought to look for a open source financial program.The search for programs listed that GNUCASH would be compatible with .qdf GNUCASH was chosen and downloaded. I need to import the latest file (backup).The only choice was to import a .qif file. Our version of Quicken used .qdf as a working extension and as backup files.I have downloaded a conversion program attached to Mozilla, but the convert button only wants to convert pdf .doc compress, .jpg, .ppt. Maybe a couple others, but no .qdf.The program I downloaded, under further investigation, is a .pdf conversion program. [ fileconverter.org] Although it listed .qdf on the page. Does anyone know of a conversion for .qdf to .qif so I can use gnucash. Thanks Mark ___ 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. ___ 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 run GNUcash in portable fashion?
Not ideal of course, but if you install GC on all the computers you want to run on, you could just put the data on the flash drive and plug it in to whatever computer you want and have already installed GC and then start GC. On 10/26/2018 2:27 PM, aeneas wrote: Very nice reply! It looks like knowing about GNC_DATA_HOME goes a long way toward solving my problem. From what I can see I'm not using AQBANKING. Also, I'd speculate that my scheme may not be be completely fool-proof. I did search the registry for "gnucash" and found some KEYS. This causes me to think that there could be some interference if different instances (i.e., different thumb drives with different peoples versions) of GNUcash were run on the same computer. While I might expect some behavioral irregularity I'd also be inclined to think that this should NOT risk contamination of the files used to store the actual accounting records. Just for the record I notice that the portableapps version of GNUcash (3.2) has a directory named GTKDataHome in addition to GNCDataHome. In my case the GTKDataHome directory is still empty. However, I am wondering if I could/should make some accommodation for whatever purpose that serves? Also, there is another directory named settings which contains files that appear to be exported from the registry. To the extent that portableapps handles registry keys properly it is a better solution than my home grown hack. However, another feature my technique provides is the installation of a new version without making any change to an existing version that is working just fine. There are many circumstances under which preserving the ability to revert to, or for that matter switch back and forth between, a prior version is quite helpful and this can extend across several versions. Anyway many thanks for the help. It looks like my flash drive installation is now somewhat portable and I also appreciate learning about some other aspects of GNUcash which may be helpful in the future. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Chromebooks
I wanted to suggest to those of you working on this to keep track of what you did and produce a 'howto' when you get done to help others who want to accomplish this. ___ 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] can Gnucash provide a list of unreconciled cheques?
Couldn't you just start a reconciliation on that account even if you don't have a statement? I'm kind of a novice with GC, but it seems to me you could get a list that way. On 9/30/2018 12:28 PM, John Ralls wrote: On Sep 30, 2018, at 10:42 AM, Barnabooth wrote: There are times (particularly near year's-end) when a simple list of the unreconciled (i.e. uncashed) cheques would be very convenient. I seem to see nothing in either the reports or the reconciliation window that would do. Is there a way? Edit>Find or f to open the find dialog. Search for Number matches regex .+ Reconcile is not cleared That assumes that you enter numbers when you write paper checks and only in that instance. If that's not the case you'll need to figure out some other way to separate checks from everything else. Note that if you use find from the Accounts page you'll be searching all accounts; if you do so from a register page you'll be searching only the corresponding account. Regards, John Ralls ___ 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] Another sort field like 'Class' in Quicken?
On 9/17/2018 8:16 AM, David T. wrote: Paul, This is a recent addition to the program. Since the documentation is also developed by volunteers (who are not necessarily the same as the people who write the program itself) documentation often lags behind the features. We rely on users like you to provide descriptions of features and how they get used. If you have a suggestion for this description, we’d welcome it. I understand the issues with volunteer efforts. I did provide my understanding of what you told me, perhaps that could be put into the docs. Is it a wiki? Can I just go in there and do it? But more importantly, is my summary correct? :-) As an aside, I will note that it is my understanding that this setting is supposedly a one-time option—i.e., that once you select it, you shouldn’t change it back. But your comment sounds as if you have tried it both ways in your file without negative consequence. If the setting can be changed at a later time without problem, that would be important to know. Can you give further information on this? No - I just saw the box and was trying to understand what it was for. I haven't tried turning it on, I'm still just trying to understand what it does. And that happened in my search for a Class/Tag field so I don't think I even need to try to turn it on. It does look like the Action field can be used for what I want. So if my summary of what it does is correct, I'd update the wiki if it will allow me to do that. What exact version are you using, and on which operating system? The latest download 3.2 on Windoz 10. What is your file storage, SQL or XML? If XML, when you tried the different settings, did you save your file after each setting change? default everything - XML. Didn't try it so I can't answer that question. If you did save the file after changing the setting, did you in fact save the file with data in the affected fields? David T. On Sep 17, 2018, at 10:00 AM, Paul Kinzelman wrote: Wow, I did not get that out of what I read at all. It'd be very useful for people I think if you updated the documentation to say that. So would a good summary be that if the box is unchecked, if you fill in the number field in a transaction, it automagically propagates to the other corresponding account register to keep them in sync. If the box is checked, you have to fill in the numbers in both places manually (if you don't, the other one will be blank), which allows them to be different. On 9/16/2018 10:59 PM, Adrien Monteleone wrote: Think of the option as more like either you have numbers for transactions, or you have numbers for splits. With the option unset, a payment transaction for example will have the same number both in the asset/liability register used to make/accept the payment and in the AP/AR register. With the option set, you could have different numbers depending on which register you are viewing. This might be useful in some cases to keep paperwork in sync. Your internal paperwork might use one number for a transaction but the external entity might use a different one. The option allows you to record both AND see each number in its proper perspective and context in your books. Regards, Adrien On Sep 16, 2018, at 10:07 PM, Paul Kinzelman wrote: I read the docs and don't really understand the "Use split Action field for Number" purpose. It sounds like the Action field is moved to the Num field, and the Num is hidden someplace else? And it's inaccessible? Too bad the empty space can't be used for tag, that sounds like a great solution. I'm surprised that it can't be. However, it sounds like I can use the "Action" field for the Tag, and I understand that I have to be careful to make sure the spelling is correct. As long as I don't collide with one of the already populated items, seems like I should be OK. Thanks! On 9/16/2018 10:24 AM, John Ralls wrote: But don’t confuse an empty space on the grid for a field. There’s no “tag” field, and adding one is complicated. There are already five free text fields in GnuCash, all searchable: Number, Description and Notes are part of transactions, Action and Memo are part of splits. Action is a little weird in that it’s a combo pre-populated with some values associated with certain GnuCash features so using it as a class/tag/subcategory might require extra effort and might interfere with a feature that uses it. There’s also the “Use split Action Field for Number” book option that displays the register account split’s action field in the Num column of the register, making the Number field inaccessible from the GUI. Since the fields are free text it requires user discipline to use any of them for categorization: One must be careful to always spell the values the same. Many users who want tags complain that that makes it too hard to use free text fields for cate
Re: [GNC] Another sort field like 'Class' in Quicken?
Wow, I did not get that out of what I read at all. It'd be very useful for people I think if you updated the documentation to say that. So would a good summary be that if the box is unchecked, if you fill in the number field in a transaction, it automagically propagates to the other corresponding account register to keep them in sync. If the box is checked, you have to fill in the numbers in both places manually (if you don't, the other one will be blank), which allows them to be different. On 9/16/2018 10:59 PM, Adrien Monteleone wrote: Think of the option as more like either you have numbers for transactions, or you have numbers for splits. With the option unset, a payment transaction for example will have the same number both in the asset/liability register used to make/accept the payment and in the AP/AR register. With the option set, you could have different numbers depending on which register you are viewing. This might be useful in some cases to keep paperwork in sync. Your internal paperwork might use one number for a transaction but the external entity might use a different one. The option allows you to record both AND see each number in its proper perspective and context in your books. Regards, Adrien On Sep 16, 2018, at 10:07 PM, Paul Kinzelman wrote: I read the docs and don't really understand the "Use split Action field for Number" purpose. It sounds like the Action field is moved to the Num field, and the Num is hidden someplace else? And it's inaccessible? Too bad the empty space can't be used for tag, that sounds like a great solution. I'm surprised that it can't be. However, it sounds like I can use the "Action" field for the Tag, and I understand that I have to be careful to make sure the spelling is correct. As long as I don't collide with one of the already populated items, seems like I should be OK. Thanks! On 9/16/2018 10:24 AM, John Ralls wrote: But don’t confuse an empty space on the grid for a field. There’s no “tag” field, and adding one is complicated. There are already five free text fields in GnuCash, all searchable: Number, Description and Notes are part of transactions, Action and Memo are part of splits. Action is a little weird in that it’s a combo pre-populated with some values associated with certain GnuCash features so using it as a class/tag/subcategory might require extra effort and might interfere with a feature that uses it. There’s also the “Use split Action Field for Number” book option that displays the register account split’s action field in the Num column of the register, making the Number field inaccessible from the GUI. Since the fields are free text it requires user discipline to use any of them for categorization: One must be careful to always spell the values the same. Many users who want tags complain that that makes it too hard to use free text fields for categorization, but a tweak to the Action combo so that all previous entries for an action in splits for a particular account are added to the list part or using a similar combo in the Memo would go a long way to resolving that objection. Regards, John Ralls On Sep 16, 2018, at 8:19 AM, Derek Atkins wrote: Search the list archives for "Tags". SIt's an oft requested feature. Patches welcome. -derek Sent using my mobile device. Please excuse any typos. On September 16, 2018 10:34:53 AM Paul Kinzelman wrote: Quicken normally specifies transactions into Categories for filtering for reports and such. But it also has a nice feature to allow a user to sort on a second field called 'Class' which can be specified for each transaction. Gnucash has what appears to be an unused field which could be used for the same purpose. If you view "Double Line", there's a space to the right of the "Notes" field which currently can't be used. Has anybody suggested or thought about using the unused field for this extra filtering purpose? ___ 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] Another sort field like 'Class' in Quicken?
I read the docs and don't really understand the "Use split Action field for Number" purpose. It sounds like the Action field is moved to the Num field, and the Num is hidden someplace else? And it's inaccessible? Too bad the empty space can't be used for tag, that sounds like a great solution. I'm surprised that it can't be. However, it sounds like I can use the "Action" field for the Tag, and I understand that I have to be careful to make sure the spelling is correct. As long as I don't collide with one of the already populated items, seems like I should be OK. Thanks! On 9/16/2018 10:24 AM, John Ralls wrote: But don’t confuse an empty space on the grid for a field. There’s no “tag” field, and adding one is complicated. There are already five free text fields in GnuCash, all searchable: Number, Description and Notes are part of transactions, Action and Memo are part of splits. Action is a little weird in that it’s a combo pre-populated with some values associated with certain GnuCash features so using it as a class/tag/subcategory might require extra effort and might interfere with a feature that uses it. There’s also the “Use split Action Field for Number” book option that displays the register account split’s action field in the Num column of the register, making the Number field inaccessible from the GUI. Since the fields are free text it requires user discipline to use any of them for categorization: One must be careful to always spell the values the same. Many users who want tags complain that that makes it too hard to use free text fields for categorization, but a tweak to the Action combo so that all previous entries for an action in splits for a particular account are added to the list part or using a similar combo in the Memo would go a long way to resolving that objection. Regards, John Ralls On Sep 16, 2018, at 8:19 AM, Derek Atkins wrote: Search the list archives for "Tags". SIt's an oft requested feature. Patches welcome. -derek Sent using my mobile device. Please excuse any typos. On September 16, 2018 10:34:53 AM Paul Kinzelman wrote: Quicken normally specifies transactions into Categories for filtering for reports and such. But it also has a nice feature to allow a user to sort on a second field called 'Class' which can be specified for each transaction. Gnucash has what appears to be an unused field which could be used for the same purpose. If you view "Double Line", there's a space to the right of the "Notes" field which currently can't be used. Has anybody suggested or thought about using the unused field for this extra filtering purpose? ___ 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. ___ 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] Another sort field like 'Class' in Quicken?
Quicken normally specifies transactions into Categories for filtering for reports and such. But it also has a nice feature to allow a user to sort on a second field called 'Class' which can be specified for each transaction. Gnucash has what appears to be an unused field which could be used for the same purpose. If you view "Double Line", there's a space to the right of the "Notes" field which currently can't be used. Has anybody suggested or thought about using the unused field for this extra filtering purpose? ___ 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] test msg
please ignore ___ 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.
