[GNC] properly record short-selling
Hello people, For the first time since I started using gnucash 3+ years ago, I'm now shorting on a stock. Nice how I refrained from excessive speculation for 3+ years hah! So, I started with Assets:Banks:USD +$1,274.26 Assets:Investments:Stocks USD:TSLA 0 And what is clear from my bank statements is: * I sold 8 TSLA stocks for $326.71 each, tot 2,613.68, minus $3.94 fee, so I have a +$2,609.74 in A:Banks:USD * this is operating on a 45% margin, and shows a "margin amount" of $1,176.16 * to cover the rest, apparently I borrowed 2,459.01 EUR according to the statement, go figure what's that in USD * this being a bank, they are not just happily loaning me shares without any insurance, so I have a -$3,789.83 on my statement. But where is that number coming from? It looks suspiciously close to what 2,459.01 EUR + 1,176.16 USD would look like. * it *seems* those 8 shares I borrowed for the operation are valued $473.7295 each, total $3,565.57 — I'm seriously confused about where that figure is coming from, but it's listed in the stock transactions list with the note "lending". (note: I get what short selling is all about, I'm only confused about where that $473 figure comes from). At the end of it all, the bank gives me a balance of +$94.17 and -8 shares. How do you recommend I record all of the above in gnucash? For long positions it's a fairly straightforward Assets:Banks:USD +$1234 Liabilities:Loans:Margin Trading:USD -$1234 Assets:Banks:USD -$3456 Assets:Investments:Stocks USD:whatever +$3456 But clearly it's not _that_ straightforward for shorts. Would people normally create a Liabilities accounts for the asset loan (with the counter-account being the regular stock account under Assets)? Or would you just let the A:I:Stocks account go negative while the position is open? And how do you even start recording the cash that has been loaned just to cover the position? If anybody is able to make heads and tails of this situation, I would really appreciate it! -- regards, Mattia Rizzolo GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`. More about me: https://mapreri.org : :' : Launchpad user: https://launchpad.net/~mapreri `. `'` Debian QA page: https://qa.debian.org/developer.php?login=mattia `- signature.asc Description: PGP signature ___ 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.
Re: [GNC] Account Register not Populating
The link that I clicked on was the next to last one GNC_CONF. The only thing I found there was a lonely file called environment. Not sure what it contains. The GnuCash backup instructions state that the stuff is in the Registry. Right now I don't have time to do any research on that. On Fri, Nov 15, 2024 at 1:04 PM David H wrote: > You'll be relieved to know that it's still there in the latest version > (5.9) then :-) > > Cheers David H. > > On Sat, 16 Nov 2024 at 04:28, Stan Brown (using GC 4.14) < > stan...@fastmail.fm> wrote: > >> On 2024-11-15 08:44, David Carlson wrote: >> > Also, as R Losey noted earlier, the locations of most of those other >> 'user' >> > files is nicely shown in the 'About' window.. The only problem I have >> with >> > that is that it works nicely in Linux, but in Windows 10 I was unable to >> > find them there. I think one needs to check the page [ >> > https://wiki.gnucash.org/wiki/FAQ#Questions_about_Backups] for >> information >> > relating to Windows 10/11 installations. >> >> That's odd. I have Windows 10 and GC 4.14, and Help » About gives me >> "the location of those other user files", as shown in the attachment. >> They're even clickable links, and I've just verified that they open the >> right folder. >> >> Which GC version do you have that doesn't show them? Hopefully it's an >> earlier version not a later one -- it would be a pity if that useful >> information were removed. >> >> Stan Brown >> Tehachapi, CA, USA >> https://BrownMath.com/___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> - >> 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 - 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 Memo to print on check. How to access 1099 list
Thanks David, I recognise nearly every word of the messages, typically the saga of moving PCs. 10> attemps sounds familiar. Backup not easy, is also fmiliar. I don't wish to be critical, I have so much good help on here, but the content of the two pages I printed from this message says a lot for a non-accountant/non bookeeper but computer literate, user. Thanks again, Barry On 14/11/2024 19:07, halatch1008 via gnucash-user wrote: Does any one know how to get "memo" information to print on the check?AndHow do I choose certain Vendors so I can send them a 1099 ? These options are both available on Quickbooks.Thanks,Heidi610 636 9947Sent from my Verizon, Samsung Galaxy smartphone Original message From: David Cousens Date: 10/17/24 5:30 PM (GMT-05:00) To: Dan a1TNC , 'R Losey' , 'halatch1008' , 'Gnucash Users' Subject: Re: [GNC] How do I do a back up of Gnucash? Dan,Your main data file (set of books is stored at a location you will havedecided on when you first ran GnuCash and did a File->Save to somespecific location on a hard drive. GunCash by default creates backupfiles of that file and log files which are useful in the event a crashcauses corruption of the main data file.The main data file will be named .gnucash where isthe name you have given the file.The backup files will be named .gnucash..gnucashand the log files will be named.gnucash..log. is 1 14 characcter numerical string giving the date(yearmonth and day and time (hours, min, sec) of creation of the file in theformat MMDDHHMMSS. If you move the file(s) to another locationGnuCash will not find them when you start it again and you can useFile_Open to navigate to the new location and open the.gnucash file. You would only access the backup and logfiles after having a system crash where the .gnucash becomescorrupted.It is generally recommended that you create a folder/directory (it canbe named ) and place all of the above files with .*in that directory. This simplifies backup of the files to anotherdevice as you simply backup the whole directory. In addition there is user preference data (including saved reports etc)and configuartion data as described on the wiki page. About half waydown that page under the heading Diagrams of Configuration LocationsYou will find links to diagrams showing the locations of that data inthe file heirarchy. You may wish to backup the data in c:\Documentsand Settings\\\AppData\Roaming\GnuCash to preserve the userpreference dataThere is no problem locating the main data file in any locationaccessible from your file system including cloud locations, Dropboxes,Network file storage etc. MOve it and then use the File->Open dialogueto find and open itDavid CousensOn Thu, 2024-10-17 at 15:32 -0400, Dan a1TNC wrote:> I'm wanting to use GNC in a Windows land where there are different> OSs. Some are 10 and some 11 etc. I ,like Heidi, did not find the> backup info in the manual to be very helpful cuz I'm not a coder, and> it seems to be written by someone who understands all OSs and is a> one size fits all for all OSs. > > I have come up with test system to figure out a dependable backup> system and I want to share that here to see if anyone can tell me if> there is a flaw in my idea.> > I have installed GNU on two different computers on/in my land and> have started entering my accounts and info in my primary computer. I> did not find a way to install it on a location outside of my primary> computer into a local cloud or another computer. (Suggestions> ???) On my second computer, I have copied the last two data files> and one text file into my GNU folder on my 2nd computer and after 10> or so attempts (after adding more data) it seems like both computers> are showing the same entries at every level. At every attempt I> delete all the old files from the last attempt, and I open GNU from> the short GNU data file which does not have that date added to the> file name. > > If this works I'm planning on doing a video to share so that others> will find this help. > Also, I've been using Quick books for over 10 years and they have> gone up to over 400% in price and we will start to see others many> many many other come to GNU> Thx> Dan> > > -Original Message-> From: gnucash-user [mailto:gnucash-user-> bounces+dan=a1tnc@gnucash.org] On Behalf Of R Losey> Sent: Thursday, October 17, 2024 11:48 AM> To: halatch1008; Gnucash Users> Subject: Re: [GNC] How do I do a back up of Gnucash?> > Well, that's a start... what kind of backup program do you have?> > Oh, and please ensure that you do a reply-all so that the> conversation goes> out to the community; it may help others, and I make some errors that> the> community would catch and correct.> > I thought that someone had pointed to a section of the manual or> somewhere> that listed the files that should be backed up.> > Richard> > > On Wed, Oct 16, 2024 at 10:09 PM halatch1008> > wrote:> > > I have Windows. The" Get help" section
Re: [GNC] Account Register not Populating
On 11/14/2024 9:34 PM, R Losey wrote: I'm glad your accounts are there with your data. As other people noted, the Saved Reports are not stored with the saved data; they are part of the user configuration. I think we should keep in mind that there are two (rather different) meanings for which the term "saved reports" can be applied. a) Our regular repeated reports. We might have a tab left open for these (for rerunning them) but have a series going back into the past of the same report but previous running of it. For example, Balance Sheet (as of date X, as of date Y, as of date Z, etc.) b) Reports which I will call special. We have made modifications to exclude accounts, etc. Of course these too might have a series of previous running of them (as in "a") For case "a", after running (for date W) I would be saving BUT not within gnucash. In other words, after running I would export it. I would have a directory (folder) with a name like "saved reports" and within that folders (directories) like "Balance Sheets", "Revenue Statements", etc, So that I could tell them apart, would make date part of the file name (so might be BalanceSheet20241115 if run today). So yes you would be moving a directory like that when moving to a new computer, but not as part of moving gnucash but as part of moving ALL data directories. For case "b", besides saving specific runs of a report like above I would want a saved version within gnucash if not used so often as to deserve an open tab. That is to save all those modifications, what accounts included, etc. In other words, I would save WITHIN gnucash ONE version of each report I use and save outside of gnucash previous runs of each of these reports. Michael D Novack ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Account Register not Populating
You'll be relieved to know that it's still there in the latest version (5.9) then :-) Cheers David H. On Sat, 16 Nov 2024 at 04:28, Stan Brown (using GC 4.14) < stan...@fastmail.fm> wrote: > On 2024-11-15 08:44, David Carlson wrote: > > Also, as R Losey noted earlier, the locations of most of those other > 'user' > > files is nicely shown in the 'About' window.. The only problem I have > with > > that is that it works nicely in Linux, but in Windows 10 I was unable to > > find them there. I think one needs to check the page [ > > https://wiki.gnucash.org/wiki/FAQ#Questions_about_Backups] for > information > > relating to Windows 10/11 installations. > > That's odd. I have Windows 10 and GC 4.14, and Help » About gives me > "the location of those other user files", as shown in the attachment. > They're even clickable links, and I've just verified that they open the > right folder. > > Which GC version do you have that doesn't show them? Hopefully it's an > earlier version not a later one -- it would be a pity if that useful > information were removed. > > Stan Brown > Tehachapi, CA, USA > https://BrownMath.com/___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Account Register not Populating
On 2024-11-15 08:44, David Carlson wrote: > Also, as R Losey noted earlier, the locations of most of those other 'user' > files is nicely shown in the 'About' window.. The only problem I have with > that is that it works nicely in Linux, but in Windows 10 I was unable to > find them there. I think one needs to check the page [ > https://wiki.gnucash.org/wiki/FAQ#Questions_about_Backups] for information > relating to Windows 10/11 installations. That's odd. I have Windows 10 and GC 4.14, and Help » About gives me "the location of those other user files", as shown in the attachment. They're even clickable links, and I've just verified that they open the right folder. Which GC version do you have that doesn't show them? Hopefully it's an earlier version not a later one -- it would be a pity if that useful information were removed. Stan Brown Tehachapi, CA, USA https://BrownMath.com/___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Account Register not Populating
Michael D Novac, You make a very good point with your illustration point 'a'. However, for your point 'b', GnuCash has a quirk that any custom report configurations that the user saved under the menu Reports > Saved Report Configurations are not actually stored in the main data file, but in a separate location where other 'User' stuff is saved, such as which register windows and report windows were open as of the last time that particular GnuCash data file was actually closed using File > Quit or by clicking on the "X' icon in the upper right corner of the GnuCash window and the widths of most of the columns [except Description] are in those register windows and the specific options selected in those open report windows. User preferences saved under Edit > Preferences also are not in the data file. Note that Search windows disappear and are not saved when GnuCash is shut down. Also, as R Losey noted earlier, the locations of most of those other 'user' files is nicely shown in the 'About' window.. The only problem I have with that is that it works nicely in Linux, but in Windows 10 I was unable to find them there. I think one needs to check the page [ https://wiki.gnucash.org/wiki/FAQ#Questions_about_Backups] for information relating to Windows 10/11 installations. Lastly, I must offer the disclaimer that I only know about using the [compressed or uncompressed]XML data file format, but not either of the two database file formats that may also be used. On Fri, Nov 15, 2024 at 9:31 AM Michael or Penny Novack via gnucash-user < gnucash-user@gnucash.org> wrote: > On 11/14/2024 9:34 PM, R Losey wrote: > > I'm glad your accounts are there with your data. > > > > As other people noted, the Saved Reports are not stored with the saved > > data; they are part of the user configuration. > > I think we should keep in mind that there are two (rather different) > meanings for which the term "saved reports" can be applied. > > a) Our regular repeated reports. We might have a tab left open for these > (for rerunning them) but have a series going back into the past of the > same report but previous running of it. For example, Balance Sheet (as > of date X, as of date Y, as of date Z, etc.) > > b) Reports which I will call special. We have made modifications to > exclude accounts, etc. Of course these too might have a series of > previous running of them (as in "a") > > For case "a", after running (for date W) I would be saving BUT not > within gnucash. In other words, after running I would export it. I would > have a directory (folder) with a name like "saved reports" and within > that folders (directories) like "Balance Sheets", "Revenue Statements", > etc, So that I could tell them apart, would make date part of the file > name (so might be BalanceSheet20241115 if run today). So yes you would > be moving a directory like that when moving to a new computer, but not > as part of moving gnucash but as part of moving ALL data directories. > > For case "b", besides saving specific runs of a report like above I > would want a saved version within gnucash if not used so often as to > deserve an open tab. That is to save all those modifications, what > accounts included, etc. > > In other words, I would save WITHIN gnucash ONE version of each report I > use and save outside of gnucash previous runs of each of these reports. > > Michael D Novack > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Account Register not Populating
It's the first two links that are probably of more interest to a user, the other links relate to where gnucash and it's components are installed. You'll be comforted to know that I also only have a single lonely environment file in that same folder :-) Cheers David H. On Sat, 16 Nov 2024 at 05:12, David Carlson wrote: > The link that I clicked on was the next to last one GNC_CONF. The only > thing I found there was a lonely file called environment. Not sure what it > contains. The GnuCash backup instructions state that the stuff is in the > Registry. Right now I don't have time to do any research on that. > > On Fri, Nov 15, 2024 at 1:04 PM David H wrote: > >> You'll be relieved to know that it's still there in the latest version >> (5.9) then :-) >> >> Cheers David H. >> >> On Sat, 16 Nov 2024 at 04:28, Stan Brown (using GC 4.14) < >> stan...@fastmail.fm> wrote: >> >>> On 2024-11-15 08:44, David Carlson wrote: >>> > Also, as R Losey noted earlier, the locations of most of those other >>> 'user' >>> > files is nicely shown in the 'About' window.. The only problem I have >>> with >>> > that is that it works nicely in Linux, but in Windows 10 I was unable >>> to >>> > find them there. I think one needs to check the page [ >>> > https://wiki.gnucash.org/wiki/FAQ#Questions_about_Backups] for >>> information >>> > relating to Windows 10/11 installations. >>> >>> That's odd. I have Windows 10 and GC 4.14, and Help » About gives me >>> "the location of those other user files", as shown in the attachment. >>> They're even clickable links, and I've just verified that they open the >>> right folder. >>> >>> Which GC version do you have that doesn't show them? Hopefully it's an >>> earlier version not a later one -- it would be a pity if that useful >>> information were removed. >>> >>> Stan Brown >>> Tehachapi, CA, USA >>> https://BrownMath.com/___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> To update your subscription preferences or to unsubscribe: >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>> - >>> 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Closing out QB Pro?!
Hey y'all, Thank you for building GNUCash. >From Quickbooks to GNUCash, what is the file transfer setup from one to the other? Is GNUCash stable in 2024+? I don't intend to step on any foots, I've been with Linux since late 1994. Is it better on hardware or a VM, does anyone build it on a docker container with its own database? Thank you everyone, Best, John <>___ 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.
Re: [GNC] Closing out QB Pro?!
Do you need to transfer data to Quickbooks? I just switched over, with the idea that I could run QuickBooks if I needed old data. (The one thing that I added to GnuCash were some investment bits to properly track gains). I think GnuCash is very stable; it has a new release at the end of every quarter. Sometimes, there are bugs introduced, but GnuCash is actively supported. I don't see any reason to run a VM, since there are versions for macOS and Windows and Linux. You can build your own version on Linux systems (and there are some packages to install). On my Linux system (Ubuntu), I run GnuCash under flatpak so that I can keep it in synch with the other versions. Some people here do their own builds; I haven't done it yet. On Fri, Nov 15, 2024 at 10:05 PM wrote: > Thank you for building GNUCash. > > From Quickbooks to GNUCash, what is the file transfer setup from one to the > other? > Is GNUCash stable in 2024+? I don't intend to step on any foots, I've been > with Linux since late 1994. > > Is it better on hardware or a VM, does anyone build it on a docker > container > with its own database? > > Thank you everyone, > > Best, > John > ___ > 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. > -- _ Richard Losey rlo...@gmail.com Micah 6:8 ___ 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.
Re: [GNC] Closing out QB Pro?!
By the way, John, email to your address here is apparently blocked; my reply-to-all bounced from your address. On Fri, Nov 15, 2024 at 10:05 PM wrote: > Hey y'all, > > Thank you for building GNUCash. > > From Quickbooks to GNUCash, what is the file transfer setup from one to the > other? > Is GNUCash stable in 2024+? I don't intend to step on any foots, I've been > with Linux since late 1994. > > Is it better on hardware or a VM, does anyone build it on a docker > container > with its own database? > > Thank you everyone, > > Best, > John > ___ > 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. > -- _ Richard Losey rlo...@gmail.com Micah 6:8 ___ 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.
