Re: [GNC] Feature request: Stock currency setting
On 21/10/2018 15:28, John Ralls wrote: On Oct 21, 2018, at 2:51 AM, rsbrux via gnucash-user wrote: I have been repeatedly frustrated by my failure to remember this advice from https://wiki.gnucash.org/wiki/Stocks/add_stock#Stocks_noted_in_foreign_currency If you start your first (buy) transaction from your stock account, the currency of the parent account will be used. Assuming your default currency is USD and you wish to buy stocks in EUR, then you should first create a normal asset account of currency EUR and below this your stock accounts. Alternatively you could start your first transaction from you EUR cash or bank account, but with the first approach everything is much clearer - also later if you forgot the nominal currency. << I find it far more intuitive to start securities transactions from the account for the particular security, and I prefer to keep the parent accounts by account rather than by currency. It is easier to start the transactions from a security account, because the fields provided are described in keeping with with securities transactions. However, this often gets me in trouble with securities traded in a currency other than my base currency (CHF). I suspect that I am not the only one with this problem. Would it be possible to add a selection for trading currency in the Security Editor? It could default to the setting indicated above, but there would at least be a way to explicitly see and control what is now hidden and implicit. As a case in point, I have a bank relationship which includes securities as well as accounts in both CHF and USD. The bank erroneously booked the purchase of a USD-denominated security to my CHF account, and I duly recorded the transaction that way. After I complained to the bank, they rolled back the transaction and posted it to my USD account instead. Now I see no way of correcting the entries in GnuCash other than to delete the account for the particular security and to recreate it via a transaction starting from my USD account. Am I missing something here? You can just move the account, but the transaction currency is immutable so you will have to delete and re-create the transaction. As for adding a trading currency to the security editor, it’s possible but the code for creating transaction currency is kind of splattered around (register, transfer dialog, scheduled transactions, importers, maybe more) so getting it right would be a bit of work. I think it may be even more complicated than that as the OP's tx involves auto-magicking a 3 part exchange. -- Wm ___ 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] Feature request: Stock currency setting
On 27/10/2018 13:30, rsbrux via gnucash-user wrote: You can just move the account, but the transaction currency is immutable so you will have to delete and re-create the transaction. As for adding a trading currency to the security editor, it’s possible but the code for creating transaction currency is kind of splattered around (register, transfer dialog, scheduled transactions, importers, maybe more) so getting it right would be a bit of work. << Thanks for the response. To get the desired results, I found it necessary to delete the account I had created for transactions in that security and then > recreate each of the transactions using the "orphaned" transactions as a model. Don't use the orphans for long, *always* move the tx to an appropriate account unless you are the sort of person that throws all their financial documents in a drawer and sorts them out only when they have to. > If currency is a property of a transaction, would it be easier to provide a way to change a transaction's currency than that of a security? Not really. A transaction is between two accounts, gnc's model uses a commodity per account, nothing wrong or right about that, you just have to build your CoA appropriately. That would have at least made it possible for me to reuse the previously entered transactions, by changing their currency and assigning them to the new account. It isn't even clear to me that currency *is* a security property. In the price editor I found prices for the security in question in both CHF and USD. Transactions are cheap, accounts more expensive :) gnc rewards building a good CoA, it is all to do with double entry and good practice, if you come from a single entry finance world it can be more formal than you expect. Anyway, in the real world stock ABCD bought in two currencies is almost certainly actually two holdings of that stock not one *unless* there was a currency exchange before the purchase, in which case why not reflect that in your accounts? A parallel is people owning stock ABCD in a retirement account and an investment account, same stock, two separate holdings, gnc recognizes the separation even though you may not acknowledge it. In general, use a CASH or BANK type account of CURRENCY CCC to buy a commodity priced in that currency, I do something like this. ASSET mixed stuff below GBP <-- or whatever your book currency is \ USD account \ shares, etc in USD \ EUR account \ shares, etc in EUR It isn't really limiting, all you have to do is put a "plain" account on top of the more complex underlying asset, that way most transactions and reports will work as expected. And if you think about it, gnc is reflecting reality, when you buy a RUB asset using CHF there are two exchanges, CHF => RUB => commodity. -- Wm ___ 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] int
On 30/10/2018 14:00, tom9...@earthlink.net wrote: I have an interest bearing checking account that has paid interest every month until October (per their monthly statement). When I called them, they said it was calculated at $.008. I want to put a zero dollar transaction in GnuCash but whenever I try, I shows blanks instead of zeros. How do I get it to show zeros instead of blanks, so if look back at it in the future & see the absence of interest I won't have to call the back all over again to find out why. Just leave it as blank and add a comment in the description like "less than 1c int" You could change the account to allow umpteen decimal places but it probably isn't worth it for less than a penny as when you move money in or out (i.e. the money becomes real) you'll almost certainly have to use whole units anyway. -- Wm ___ 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?
On 26/10/2018 21:27, 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. You are likely to make a mistake rolling your own gnc portable. The portableapps.com model is good but not always up to date, e.g. the problem with Portableapps was that they didn't notice when gnc moved stuff around [1] If you really do need your gnc to be portable stick with PortableApps model and get them to follow changes, losing bits of closely integrated accounting data is generally not fun. [1] a bad move in portable and non-portable terms, think disjointed backups. -- Wm ___ 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?
On 26/10/2018 21:36, Paul Kinzelman wrote: 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. Wrong! the clever people at gnc towers decided to follow the MS idiocy model and put significant stuff in user / computer specific folders :( So what you suggest won't work. Gr! -- Wm ___ 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?
On 27/10/2018 09:34, Geert Janssens wrote: Agreed. And on several occasions I have been thinking about adjusting the gnucash code and its Windows installer to make this universally possible. It never really happened so far due to lack of time and other priorities. the .gnucash folder model was better than the current model, at least they were nearby in a folder structure. It can be near impossible to find all associated meta data on Windows now. There is a lot to be learned from the way PortableApps uses folder and registry as an impairment of Windows rather than a feature. -- Wm ___ 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?
On 27/10/2018 13:46, Kim Wood wrote: Here is another suggestion that works for me. I use the most recent PortableApps build, and simply delete the \PortableApps\GnuCashPortable\App\gnucash directory, and replace it with my more recent c:\Program Files (x86)\gnucash directory. Works fine for me, and has since the PortableApps version of GnuCash was first released some time ago. If I understand what you are doing, you're relying on PA to keep your book and its meta-data together rather than gnc itself. That makes sense as gnc fucked up when they went the MS way. However I think you should test your backup and restore procedures as things might not be where you (or JTH) expect them to be since gnc 3.x This should allow you to use the nightly build maint versions too if you want to stay on the bleeding edge. I understand that any significant change in GnuCash could break this hack - so I only use the latest PortableApps 3.2.0 version of GnuCash Portable. That only got fixed because I made a noise in these forums and elsewhere and is one behind. Note: This is a hack for you Windows users only. Further, I then run the PortableApps Installer generator tool to create a fresh new installer for a future installation should I need it. I also prefer a different GnuCash splash screen and PortableApp icons for my portable version. All very easily done and all works fine. This might be a better solution for you, as the PortableApps folks appear to have done a pretty good job with their portabilization. The PA people are very good at what they do and understand the weirdness of where MS want things to be much better than the gnc leaders [1], the problem is JTH needs to be kept on his toes about changes to apps and wasn't expecting the dir structory change. [1] they develop an app, I understand Win users are a nuisance -- Wm ___ 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't assign payment to multiple invoices
On 27/10/2018 19:24, wail wrote: Hello, I have a list of invoices and a list of payments and I'm trying to assign payments to invoices (I'm using Gnucash 3.3 on Ubuntu 18.10). The problem is that my client pays sums that are not related to invoices, e.g. invoices would be $4 $5 $3 $6 while payments would be $2 $6 $2 $3 $5. So I need to assign a payment to two or three invoices. I just want to assign each payment to the oldest unpaid invoice(s). I was able to add a few payments to multiple invoices then it stopped working, that is, if I select two payments in the "Process payment" window and click ok, then only the last selected invoice will receive the payment. If I edit the payment again, only one invoice is selected. That may be unrelated but sometimes the right click menu on a transaction shows "edit payment" and sometimes it shows "assign as payment" instead (typically after I edit the payment once and it gets split). Also, in the "Process payment" window, when there are multiple invoices for a given date, the list of invoices does not always appear in order of invoices number. The list is ordered by Date but it would be better if it could be ordered by invoice number in a given date. If the payments really are unrelated to the invoices use the old fashioned payment on account method, i.e. reduce the balance on the Liability and tidy it up occasionally. -- Wm ___ 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] Backup
On 31/10/2018 00:52, Bob Hammons wrote: I have been using Gnucash since the first of the year. The data files are in a directory named gnucash and it save a lot of backups. I am using Windows 10. I open filer and control c the days files, sometimes as high as 20, and paste them to a thumb drive for backup. Is this all I need to backup or is there other files ? Can I take the thumb drive to a different computer, to my accountant, with gnucash installed and have the info he needs? no, you misunderstand what you need to back up entirely. fact is things have changed a lot recently and it is all a mess, you can't even trust the website at the moment :( -- Wm ___ 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] Backup
On 31/10/2018 01:24, D via gnucash-user wrote: Check out https://wiki.gnucash.org/wiki/Backup You should not point people to incorrect and misleading links -- Wm ___ 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] Question about sub accounts
On 29/10/2018 14:55, Eric Gwin wrote: Hi, I'm pretty new to to application, and have basically 0 accounting background. I've setup my books and all is working pretty well, but I am running into an issue with subaccounts I hope I'm doing something wrong, but if not I'd also like to know so I can post a suggestion. Scenario: I have a checking account I am using as an accumulator for multiple other purposes (it is a "sinking" fund account I use to "save" for expected/budgeted non-monthly expenses) I have set it up like this: *assets:current assets:sinking checking* is then has sub accounts to track deposits to and deductions from various categories *assets:current assets:sinking checking:AutoMaint* *assets:current assets:sinking checking:Clothing* *assets:current assets:sinking checking:HairCare* *assets:current assets:sinking checking:HomeMaint* *assets:current assets:sinking checking:KidActivity* On a bi-monthly basis, I deposit a fixed amount to the "sinking checking" and a split transaction allocates it to the various sub-accounts. Then as payments need to be made I use that checking for the payment and track it using an entry against the sub-account. This works pretty well as it solves the major problem of maintaining each sub-accounts spending and balances. However, in order to reconcile the checking account I need to see all the transactions to each sub account listed in the register for the "sinking checking" along with the running balance for the account. I'm missing the point a bit, you have really specific accounts. I've been able to limp by so far by specifying every transaction as a split with no amount to *assets:current assets:sinking checking * and the actual transaction amount to the sub-account: *assets:current assets:sinking checking:AutoMaint* -135.45 *Expenses:Sinking:AutoMaint * 135.45 That at least creates an entry in the "singing checking" register and the "Accounts" tab does show the current balance for "sinking checking", but there is no running total, nor does the transaction amount show in that account's register. Setting "Sinking checking" as a placeholder seems to simply mean GNUCash won't allow you to view the register or enter a transaction against the account. We are aware of envelope accounting as a theory and don't really think of it as accounting, it is a budgeting method and hope you realise that. Your budget is your business, gnc can help you but it isn't going to do it for you. gnc is for grown ups not the average Trump voter. Is there a way to set up an account of this type where the account maintains the transactions (as it should for reconciliation) and each sub-account also "inherits" transactions for their type: or the sub accounts get the transaction entries as I'm doing, but the parent account register lists (but doesn't total) the sub account transactions? Yes, spend at the lowest level and report at the highest level and drill down until you see what you do (or don't) want to see. BTW, this sort of Budgeting won't work in gnc so don't even try. Micro management of personal finance is best done in another way, I'd go so far as to suggest not doing it on social media. -- Wm ___ 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] Question about sub accounts
On 29/10/2018 16:49, Adrien Monteleone wrote: We’ve discussed envelope budgeting quite a bit here on the list. Do a list restricted search to find the threads. I’ve tried it myself in the past, and currently have the account tree set up to use, but honestly, it is probably better to use an outside piece of software to manage the budgeting and just use GnuCash for the actual real accounting. (GnuCash has a budget module, but it is not envelope based) There are several methods and lots of pitfalls. The least of which is nearly double the work in entering transaction splits. I think it is a envelope budget hangover. Finally, there are plenty of good standard accounting textbooks online for free. Here’s one I’ve found pretty useful as a quick reference: https://www.principlesofaccounting.com/ (I have a college textbook I kept that is probably better, but that copy is on paper and this is at my fingertips) All of your questions though were not accounting questions, but GnuCash mechanics questions. We don’t give accounting advice here, but can offer some basic generic example help and can point you in the right direction, but if the question is “how do I do ‘x’ with GnuCash” like you’ve asked, that’s what we’re here for. You are sort of right and sort of wrong, the OP wants something that gnc can do with effort but if you have brains you don't bother with. Envelope budgeting is, oddly, something Trump voters pay for. Weird. -- Wm ___ 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] Backup
Wm, If you think that link contains incorrect and misleading information, why don't you contact the developers and help them correct it. David C On Thu, Nov 1, 2018 at 3:22 AM Wm via gnucash-user wrote: > On 31/10/2018 01:24, D via gnucash-user wrote: > > Check out https://wiki.gnucash.org/wiki/Backup > > You should not point people to incorrect and misleading links > -- > Wm > > ___ > 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?
Op woensdag 31 oktober 2018 14:20:02 CET schreef Wm via gnucash-user: > On 26/10/2018 21:36, Paul Kinzelman wrote: > > 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. > > Wrong! the clever people at gnc towers decided to follow the MS idiocy > model and put significant stuff in user / computer specific folders :( Wrong you too :) We didn't follow the MS model, but the free desktop one. Freedesktop defines a folder for application metadata and one for user configuration data. Microsoft specifies one folder for everything. So the default for GnuCash on Windows puts both metadata and configuration data in one directory, and in two separate ones on freedesktop adhering systems. As I said before, I missed adding an environment variable for overriding the configuration data folder, which bites on NON-freedesktop adhering systems such as Windows. Geert ___ 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?
Op woensdag 31 oktober 2018 14:27:37 CET schreef Wm via gnucash-user: > On 27/10/2018 09:34, Geert Janssens wrote: > > Agreed. And on several occasions I have been thinking about adjusting the > > gnucash code and its Windows installer to make this universally possible. > > It never really happened so far due to lack of time and other priorities. > the .gnucash folder model was better than the current model, at least > they were nearby in a folder structure. It can be near impossible to > find all associated meta data on Windows now. > Huh? Only the name of the directory changed on Windows. > There is a lot to be learned from the way PortableApps uses folder and > registry as an impairment of Windows rather than a feature. That's indeed one way of seeing it. Geert ___ 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] Backup
On Thu, 1 Nov 2018 at 08:23, Wm via gnucash-user wrote: > > On 31/10/2018 01:24, D via gnucash-user wrote: > > Check out https://wiki.gnucash.org/wiki/Backup > > You should not point people to incorrect and misleading links Please point out the errors so it can be corrected. Colin > -- > Wm > > ___ > 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] Can't assign payment to multiple invoices
Op woensdag 31 oktober 2018 16:43:12 CET schreef Wm via gnucash-user: > On 27/10/2018 19:24, wail wrote: > > Hello, > > I have a list of invoices and a list of payments and I'm trying to assign > > payments to invoices (I'm using Gnucash 3.3 on Ubuntu 18.10). > > The problem is that my client pays sums that are not related to invoices, > > e.g. invoices would be $4 $5 $3 $6 while payments would be $2 $6 $2 $3 $5. > > So I need to assign a payment to two or three invoices. > > I just want to assign each payment to the oldest unpaid invoice(s). > > > > I was able to add a few payments to multiple invoices then it stopped > > working, that is, if I select two payments in the "Process payment" window > > and click ok, then only the last selected invoice will receive the > > payment. > > If I edit the payment again, only one invoice is selected. > > > > That may be unrelated but sometimes the right click menu on a transaction > > shows "edit payment" and sometimes it shows "assign as payment" instead > > (typically after I edit the payment once and it gets split). > > Also, in the "Process payment" window, when there are multiple invoices > > for > > a given date, the list of invoices does not always appear in order of > > invoices number. The list is ordered by Date but it would be better if it > > could be ordered by invoice number in a given date. > > If the payments really are unrelated to the invoices use the old > fashioned payment on account method, i.e. reduce the balance on the > Liability and tidy it up occasionally. Good point indeed. That's what GnuCash does if you don't select invoices while adding payments for a customer. Geert ___ 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] Backup
Op woensdag 31 oktober 2018 17:09:27 CET schreef Wm via gnucash-user: > On 31/10/2018 01:24, D via gnucash-user wrote: > > Check out https://wiki.gnucash.org/wiki/Backup > > You should not point people to incorrect and misleading links What's misleading about that link ? I have just read it and as far as I can see it's correct. Geert ___ 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't assign payment to multiple invoices
I wanted to clean the unpaid invoice list. What do you mean by "tidy it up occasionally"? On 31/10/2018 16:43, Wm via gnucash-user wrote: On 27/10/2018 19:24, wail wrote: Hello, I have a list of invoices and a list of payments and I'm trying to assign payments to invoices (I'm using Gnucash 3.3 on Ubuntu 18.10). The problem is that my client pays sums that are not related to invoices, e.g. invoices would be $4 $5 $3 $6 while payments would be $2 $6 $2 $3 $5. So I need to assign a payment to two or three invoices. I just want to assign each payment to the oldest unpaid invoice(s). I was able to add a few payments to multiple invoices then it stopped working, that is, if I select two payments in the "Process payment" window and click ok, then only the last selected invoice will receive the payment. If I edit the payment again, only one invoice is selected. That may be unrelated but sometimes the right click menu on a transaction shows "edit payment" and sometimes it shows "assign as payment" instead (typically after I edit the payment once and it gets split). Also, in the "Process payment" window, when there are multiple invoices for a given date, the list of invoices does not always appear in order of invoices number. The list is ordered by Date but it would be better if it could be ordered by invoice number in a given date. If the payments really are unrelated to the invoices use the old fashioned payment on account method, i.e. reduce the balance on the Liability and tidy it up occasionally. ___ 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] Backup
Wm, I know I am putting myself out here to get royally flamed by you, but... I call BS. You’re trolling here. First off, IT’S A WIKI. YOU of all people should know what that means: volunteers write/edit that content, and OTHER volunteers (read: YOU) can edit those pages to make them accurate. Second off, I’ll note that I recently revamped that particular page, so I know pretty much what’s there. If it’s “incorrect and misleading,” I don’t know why. As far as I understand (and I admit that this is something that has pretty narrow boundaries), the page is mostly up to date; indeed one of the primary developers (Geert) has weighed in agreeing with that assessment. Now, if you have additional insight into the backup process, I suggest you put up, and write your corrections on the wiki, rather than intimate with mysterious tone that the information is “incorrect and misleading.” Stop spewing FUD, and make an effort to help, instead. David > On Nov 1, 2018, at 2:49 PM, Colin Law wrote: > > On Thu, 1 Nov 2018 at 08:23, Wm via gnucash-user > wrote: >> >> On 31/10/2018 01:24, D via gnucash-user wrote: >>> Check out https://wiki.gnucash.org/wiki/Backup >> >> You should not point people to incorrect and misleading links > > Please point out the errors so it can be corrected. > > Colin > >> -- >> Wm >> >> ___ >> 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] Backup
Wm, What is incorrect or misleading about the Wiki backup page? It points out the necessity to have an adequate backup strategy in place outside the inbuilt backups which only protect against file write problems. It is really outside the scope of GnuCash to specify what that strategy should be. It will be dependent upon the users particular system and usage as to what will constitute an appropriate strategy and it is really a system manangement issue, not an application issue. There are plenty of sites which provide appropriate backup strategies that a user could use, e.g. https://www.backblaze.com/backup-your-computer.html https://www.howtogeek.com/242428/whats-the-best-way-to-back-up-my-computer/ https://www.pcmag.com/article2/0,2817,2363057,00.asp https://www.thurrott.com/windows/1782/thinking-about-pc-backup-strategies https://www.itworld.com/article/2832755/consumerization/the-best-home-backup-plan-options---part-5--a-complete-backup-strategy.html https://support.apple.com/en-au/mac-backup https://www.backblaze.com/mac-backup.html David Cousens - David Cousens -- 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.
Re: [GNC] Question about sub accounts
Ken Schneider > On Oct 31, 2018, at 1:01 PM, Wm via gnucash-user > wrote: > >> On 29/10/2018 16:49, Adrien Monteleone wrote: >> >> We’ve discussed envelope budgeting quite a bit here on the list. Do a list >> restricted search to find the threads. I’ve tried it myself in the past, and >> currently have the account tree set up to use, but honestly, it is probably >> better to use an outside piece of software to manage the budgeting and just >> use GnuCash for the actual real accounting. (GnuCash has a budget module, >> but it is not envelope based) There are several methods and lots of >> pitfalls. The least of which is nearly double the work in entering >> transaction splits. > > I think it is a envelope budget hangover. > >> Finally, there are plenty of good standard accounting textbooks online for >> free. Here’s one I’ve found pretty useful as a quick reference: >> https://www.principlesofaccounting.com/ (I have a college textbook I kept >> that is probably better, but that copy is on paper and this is at my >> fingertips) >> All of your questions though were not accounting questions, but GnuCash >> mechanics questions. We don’t give accounting advice here, but can offer >> some basic generic example help and can point you in the right direction, >> but if the question is “how do I do ‘x’ with GnuCash” like you’ve asked, >> that’s what we’re here for. > > You are sort of right and sort of wrong, the OP wants something that gnc can > do with effort but if you have brains you don't bother with. > > Envelope budgeting is, oddly, something Trump voters pay for. Weird. PLEASE keep your snide childish remarks to yourself. They’re not appreciated on this list. ___ 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] Could not unpost a bill.
You can’t delete a bill. (or invoice, or vendor, or customer) But you can edit the bill after unposting and remove all line items, which will zero the bill. Then mark it as ‘inactive’, and possibly also change the bill number to something like “use next” so you’ll be able to find and re-use it later. It might also be a good idea to assign it to a dummy vendor so it doesn’t show up in any particular vendor list, but that is not entirely necessary, just a preference. It will then not show up in the AP account register. (only posted bills show up in the register and you can’t delete them from the register if they *are* posted) I see you’re saying ’nothing happens’ when you click the unpost button. What are you expecting to happen? Does the Edit Invoice button become effective after you click ‘unpost’? If not, there is certainly a problem. Also, I’m not sure what you mean by “unpost the bill and close the window without saving from the vendor report.” You don’t unpost from the vendor report, you unpost while viewing the invoice itself. What ‘window’ do you “close without saving”— the GnuCash window, or the tab for the vendor report, or the tab for the invoice? > On Oct 15, 2018, at 5:59 AM, William Lim wrote: > > Hello, I had some problem unposting a bill entry. > > I entered a bill and process the payment for this bill. > Subsequently, I entered the same bill again and also process the payment for > this bill. > > Usually to cancel this bill, I’ll unpost the bill and close the window > without saving from the vendor report. The bill will be cleared. And > subsequently I just need to delete the payment transaction and I’m good. > However, I have this 1 bill entry that I could not unpost. Nothing happen > after pressing the unpost button. > > The transaction did show up on the Liabilities Account page but somehow it > was like it was being process with a payment but actually the payment was > being deleted. > I tried deleting from Liabilities Account but I’m not able to delete the > transaction. > > Could someone help/advise what went wrong and what I can do to solve this > problem. > > Thank you, > William Lim > > > Sent from Mail for Windows 10 > > ___ > 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] Feature request: Stock currency setting
@Wm Thanks for your patient explanation! >> Don't use the orphans for long, *always* move the tx to an appropriate account unless you are the sort of person that throws all their financial documents in a drawer and sorts them out only when they have to. << I was unable to use (e.g. move) the transactions which I orphaned, because they were in the wrong currency. I used the orphaned transactions as models from which to manually transcribe the needed information into new transactions in the correct currency. Once this was done, I deleted the orphans. >> gnc rewards building a good CoA, it is all to do with double entry and good practice, if you come from a single entry finance world it can be more formal than you expect. << As a layperson, I have no doubt oversimplified. My securities accounts are directly under Assets:Inversments:Bank presumably I should have added a currency layer in between. >> Anyway, in the real world stock ABCD bought in two currencies is almost certainly actually two holdings of that stock not one *unless* there was a currency exchange before the purchase, in which case why not reflect that in your accounts? << In my case, it was simply an incorrect interpretation on the part of GnuCash, because the security was linked to the wrong currency. How it could have changed is beyond me. >> A parallel is people owning stock ABCD in a retirement account and an investment account, same stock, two separate holdings, gnc recognizes the separation even though you may not acknowledge it. << Provided the account hierarchy is properly set up ;-) >> In general, use a CASH or BANK type account of CURRENCY CCC to buy a commodity priced in that currency, I do something like this. ASSET mixed stuff below GBP <-- or whatever your book currency is \ USD account \ shares, etc in USD \ EUR account \ shares, etc in EUR It isn't really limiting, all you have to do is put a "plain" account on top of the more complex underlying asset, that way most transactions and reports will work as expected. << Indeed, this is what I learned from the wiki article which I cited in another post. >> And if you think about it, gnc is reflecting reality, when you buy a RUB asset using CHF there are two exchanges, CHF => RUB => commodity. << Indeed, this was the source of my problems, because the bank started out by buying the (USD-denominated) security in CHF, then corrected the transaction after I asked them to make future purchases out of my USD account. Instead they retroactively changed the first transaction, which I had already entered in CHF, instead of making the conversion explicit, as you suggest. Your approach would have saved me a lot of pain, as it took me over a year to figure out how to do it right ;-} ___ 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] Backup
I don't see any reason to change the Wiki. People who already have a backup plan in place know what they need to do. RBM On Thu, 2018-11-01 at 08:48 -0500, David Cousens wrote: > Wm, > > What is incorrect or misleading about the Wiki backup > page? It points out > the necessity to have an adequate backup strategy in place > outside the > inbuilt backups which only protect against file write > problems. It is really > outside the scope of GnuCash to specify what that strategy > should be. It > will be dependent upon the users particular system and > usage as to what > will constitute an appropriate strategy and it is really a > system > manangement issue, not an application issue. There are > plenty of sites which > provide appropriate backup strategies that a user could > use, e.g. > > https://www.backblaze.com/backup-your-computer.html > https://www.howtogeek.com/242428/whats-the-best-way-to-back-up-my-computer/ > https://www.pcmag.com/article2/0,2817,2363057,00.asp > https://www.thurrott.com/windows/1782/thinking-about-pc-backup-strategies > https://www.itworld.com/article/2832755/consumerization/the-best-home-backup-plan-options---part-5--a-complete-backup-strategy.html > https://support.apple.com/en-au/mac-backup > https://www.backblaze.com/mac-backup.html > > David Cousens > > > > - > David Cousens > -- > 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.
[GNC] how to process refunds
I have a client that has overpaid me due to invoices I sent for work that was later cancelled. I want to refund these fees but not sure how to do so to make my books square. Thanks, Eric ___ 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 process refunds
You can either unpost the invoice and then return the funds, or Issue a credit note for the amount of the invoice, un-pay the invoice, apply the credit note as an offset, and then return the funds. Regards, Adrien > On Nov 1, 2018, at 11:24 PM, Eric Rathhaus (general) via gnucash-user > wrote: > > I have a client that has overpaid me due to invoices I sent for work that was > later cancelled. I want to refund these fees but not sure how to do so to > make my books square. Thanks, Eric > > ___ > 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.
