[GNC] Entering Dividend Confusion
Hi all, I'm trying to enter dividends, I'm following this video https://www.youtube.com/watch?v=WRNoabz1WSo but his page shows columns with shares/price/debt/credit, but mine has just buy/sell any ideas? How do I get those columns? I'm in Australia, so I wanted to enter dividend payments as 3 types: Taxed (franked), Untaxed (unfranked) and the Tax credit (input credit), and I reinvest the dividends typically. Thanks: All advice welcomed. ___ 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] Fwd: Bonus share entry
I managed to sort the capital reconstruction out: Stock split with a negative value. As for the naming and code issue: I think I'll just rename the stock to it's final name, and enter notes on the earlier transactions before the name change? Or is there a proper way to handle this? I was also thinking the stock merger feature could be used? On Sat, Mar 23, 2019 at 6:13 PM Gnucash Xboxboy Mageia < xboxboy.mageia+gnuc...@gmail.com> wrote: > Thanks everyone: I think David's tab trick worked. It appears to have > worked anyways. > > Now my next trick, is a double trick: > During the ownership of a company, it has changed it's name/code. How does > one best handle this? > > and > > I have 163 shares in a company that had a capital reconstruction, and > after wards it has 98 shares: So the reverse of a stock split: Can the > stock split process handle this? > > I appreciate everyone's input. > Xboxboy > > On Sat, Mar 9, 2019 at 5:32 PM Chris Good wrote: > >> -Original Message- >> From: D >> Sent: Thursday, 7 March 2019 12:26 PM >> To: Chris Good ; Gnucash Users < >> gnucash-user@gnucash.org> >> Subject: Re: [GNC] Fwd: Bonus share entry >> >> Chris, >> >> That's a bad idea. It messes up the lots as you note, it screws up the >> acquisition dates (important for tax purposes in the US), and ultimately >> it's not what happened. Since it is possible to add zero cost shares using >> tab (instead of enter), there is no reason to use this approach. You >> certainly don't *have* to use it. >> >> David >> >> On March 7, 2019, at 2:29 AM, Chris Good wrote: >> >> Message: 6 >> > Date: Wed, 6 Mar 2019 22:00:16 +1030 >> > From: Gnucash Xboxboy Mageia >> > To: Derek Atkins >> > Cc: gnucash-user@gnucash.org >> > Subject: Re: [GNC] Fwd: Bonus share entry >> > Message-ID: >> > >> > >> > Content-Type: text/plain; charset="utf-8" >> > >> >> On Wed, Mar 6, 2019 at 9:38 PM Derek Atkins wrote: >> >> >> >> The cost may be zero, but the value is not. >> >> Maybe just enter them as 0.01? >> >> >> >> -derek >> >> Sent using my mobile device. Please excuse any typos. >> >> On March 6, 2019 6:07:28 AM Gnucash Xboxboy Mageia >> >> wrote: >> >> >> >>> Hi all, >> >>> I have some bonus shares that were issued with no cost to me: >> >>> >> >>> I am having trouble entering them without a cost. When I put 0 as >> >>> the >> >> cost, >> >>> on the next line 1 appears, and I am unable to get rid of it. >> >>> >> >>> Perhaps I'm doing this the wrong way, and need to be entering them >> >>> as a share split? >> >>> >> >>> In this case, I had 100 shares, and got issued 16 for no cost: so I >> >>> have >> >>> 116 in total. >> >>> >> >>> Any ideas? >> >>> >> >>> Thanks, >> >>> Xboxboy >> >>> ___ >> >>> 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. >> > Hi Derek, >> > >> > I've attached a picture, I don't think I'm explaining very well. >> > >> > Please see attached. >> > >> > What can I do about that imbalance line? >> > Many thanks, >> > Xboxboy >> > -- next part -- A non-text attachment was >> > scrubbed... >> > Name: Screenshot_20190306_215426.png >> > Type: image/png >> > Size: 34424 bytes >> > Desc: not available >> > URL: >> > <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20190306/ >> > 8a2c7c73/attachment.png> >> > >> >> Hi XBoxBoy, >> >> If the tax authorities have agreed that you are getting these bonus >> shares for zero cost, then to keep the cost correct in GnuCash
[GNC] Fwd: Fwd: Bonus share entry
Thanks everyone: I think David's tab trick worked. It appears to have worked anyways. Now my next trick, is a double trick: During the ownership of a company, it has changed it's name/code. How does one best handle this? and I have 163 shares in a company that had a capital reconstruction, and after wards it has 98 shares: So the reverse of a stock split: Can the stock split process handle this? I appreciate everyone's input. Xboxboy On Sat, Mar 9, 2019 at 5:32 PM Chris Good wrote: > -Original Message- > From: D > Sent: Thursday, 7 March 2019 12:26 PM > To: Chris Good ; Gnucash Users < > gnucash-user@gnucash.org> > Subject: Re: [GNC] Fwd: Bonus share entry > > Chris, > > That's a bad idea. It messes up the lots as you note, it screws up the > acquisition dates (important for tax purposes in the US), and ultimately > it's not what happened. Since it is possible to add zero cost shares using > tab (instead of enter), there is no reason to use this approach. You > certainly don't *have* to use it. > > David > > On March 7, 2019, at 2:29 AM, Chris Good wrote: > > Message: 6 > > Date: Wed, 6 Mar 2019 22:00:16 +1030 > > From: Gnucash Xboxboy Mageia > > To: Derek Atkins > > Cc: gnucash-user@gnucash.org > > Subject: Re: [GNC] Fwd: Bonus share entry > > Message-ID: > > > > > > Content-Type: text/plain; charset="utf-8" > > > >> On Wed, Mar 6, 2019 at 9:38 PM Derek Atkins wrote: > >> > >> The cost may be zero, but the value is not. > >> Maybe just enter them as 0.01? > >> > >> -derek > >> Sent using my mobile device. Please excuse any typos. > >> On March 6, 2019 6:07:28 AM Gnucash Xboxboy Mageia > >> wrote: > >> > >>> Hi all, > >>> I have some bonus shares that were issued with no cost to me: > >>> > >>> I am having trouble entering them without a cost. When I put 0 as > >>> the > >> cost, > >>> on the next line 1 appears, and I am unable to get rid of it. > >>> > >>> Perhaps I'm doing this the wrong way, and need to be entering them > >>> as a share split? > >>> > >>> In this case, I had 100 shares, and got issued 16 for no cost: so I > >>> have > >>> 116 in total. > >>> > >>> Any ideas? > >>> > >>> Thanks, > >>> Xboxboy > >>> ___ > >>> 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. > > Hi Derek, > > > > I've attached a picture, I don't think I'm explaining very well. > > > > Please see attached. > > > > What can I do about that imbalance line? > > Many thanks, > > Xboxboy > > -- next part -- A non-text attachment was > > scrubbed... > > Name: Screenshot_20190306_215426.png > > Type: image/png > > Size: 34424 bytes > > Desc: not available > > URL: > > <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20190306/ > > 8a2c7c73/attachment.png> > > > > Hi XBoxBoy, > > If the tax authorities have agreed that you are getting these bonus shares > for zero cost, then to keep the cost correct in GnuCash you will have to do > a dummy sell of all your existing shares at cost, and then in another > transaction, buy them, including the bonus qty, at the same cost. Assuming > this is for your personal accounting, it probably doesn't matter which > account you use for the other side in each transaction - you could probably > use either a bank account (and if you reconcile that bank account, flag the > transactions as reconciled even though they never appear on a bank > statement) or an Equity:Opening Balances account - you should check with > your accountant. > > Doing this will mean manually keeping track of lots bought and sold when > determining costs of future sales. > > Regards, Chris Good > > Hi David, > > You're right, I was confusing this with the problem where the Advanced > Portfolio Report doesn't handle Return Of Capital transactions, but it > seems to handle zero cost and price transactions OK. Sorry for the bad > advice XBoxBoy. > > Regards, > Chris Good > > ___ 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] Bonus share entry
Hi all, I have some bonus shares that were issued with no cost to me: I am having trouble entering them without a cost. When I put 0 as the cost, on the next line 1 appears, and I am unable to get rid of it. Perhaps I'm doing this the wrong way, and need to be entering them as a share split? In this case, I had 100 shares, and got issued 16 for no cost: so I have 116 in total. Any ideas? Thanks, Xboxboy ___ 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] Fwd: Bonus share entry
On Wed, Mar 6, 2019 at 10:22 PM Fred Bone wrote: > On Wednesday, March 6, 2019 at 22:00, Gnucash Xboxboy Mageia said: > > [...] > > Hi Derek, > > > > I've attached a picture, I don't think I'm explaining very well. > > > > Please see attached. > > > > What can I do about that imbalance line? > > Delete it, and delete the price and value on the "buy" split. > > Fred, I think I've done as you say, but it continues to place 1 in the line below? I've attached an updated pic ___ 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] Fwd: Bonus share entry
On Wed, Mar 6, 2019 at 9:38 PM Derek Atkins wrote: > The cost may be zero, but the value is not. > Maybe just enter them as 0.01? > > -derek > Sent using my mobile device. Please excuse any typos. > On March 6, 2019 6:07:28 AM Gnucash Xboxboy Mageia > wrote: > > > Hi all, > > I have some bonus shares that were issued with no cost to me: > > > > I am having trouble entering them without a cost. When I put 0 as the > cost, > > on the next line 1 appears, and I am unable to get rid of it. > > > > Perhaps I'm doing this the wrong way, and need to be entering them as a > > share split? > > > > In this case, I had 100 shares, and got issued 16 for no cost: so I have > > 116 in total. > > > > Any ideas? > > > > Thanks, > > Xboxboy > > ___ > > 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. > > > Hi Derek, I've attached a picture, I don't think I'm explaining very well. Please see attached. What can I do about that imbalance line? Many thanks, Xboxboy ___ 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] Fwd: Bonus share entry
Hi all, I have some bonus shares that were issued with no cost to me: I am having trouble entering them without a cost. When I put 0 as the cost, on the next line 1 appears, and I am unable to get rid of it. Perhaps I'm doing this the wrong way, and need to be entering them as a share split? In this case, I had 100 shares, and got issued 16 for no cost: so I have 116 in total. Any ideas? Thanks, Xboxboy ___ 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 email to Mailing List: I've been having Issues Sending to list
Hi guys, just a test email to see if I send to the mailing list: I seem to have been getting bounced: so I've updated my 'from' address. Can one or two kind souls please reply if this comes through on your end? Many thanks, Xboxboy ___ 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] Stocks/Equities queries (Australian Based)
HI guys, I got several stocks all entered in now: Really happy with how that's gone. Now I'm tripped up on a bonus issue of shares. For some reason I'm lost one how to enter these bonus shares that cost zero. I enter in 16 new shares to the correct asset/stocks/sharecode account, but even when I put zero as the cost, automatically a value of 1 appears on the next line of the split: I am unable to remove this 1. These shares were a bonus, with zero cost to the holders. Any ideas? Thank you. Xboxboy On Sun, Jan 20, 2019 at 6:46 PM Xboxboy Mageia wrote: > > > On Mon, Jan 7, 2019 at 6:46 AM David Cousens > wrote: > >> Hi, >> >> The brokerage charges usually come on top of the share price as a service >> fee charged to your brokerage account. I would >> use the gross pricing method as the expenses will be deductible as >> brokerage fees and you would use the share price and >> number to calculate the capital gains nott the nett price. GnuCash's >> The transaction to record this is: >> >> Asset:BankCr 2935.35 >> Asset:Shares 500@$5.01 Db $2880.75 >> Expenses:Shares:Brokerage Db 54.60 >> >> >> Unless you are registered or required to be registered for GST then you >> can ignore the GST. If you are close to the >> turnover threshold for GST registration with your share trading (or >> combined turnover if you operate other enterprises >> as the same entity), it would probably pay to start to track GST so you >> know when you go over the threshold. >> >> https://www.ato.gov.au/general/capital-gains-tax/shares,-units-and-similar-investments/shareholding-as-investor-or-share-trading-as-business-/ >> , >> >> https://www.ato.gov.au/Business/GST/In-detail/GST-issues-registers/Financial-services---questions-and-answers/?anchor=a4_6 >> . You can also register under the threshold and claim GST credits, but it >> is optional then. >> >> The brokerage fees etc will of course be deductible against any income >> which is the main reason for recording them. You >> also have the correct value for CGT calculations in Australia which is >> not the nett price. >> >> Please CC gnucash-user@gnucash.org in all replies to ensure the full >> conversation appears on the list >> >> >> David >> >> >> >> >> On Sun, 2019-01-06 at 17:41 +1030, Xboxboy Mageia wrote: >> > >> > >> > On Sun., 6 Jan. 2019, 3:15 pm Xboxboy Mageia > wrote: >> > > >> > > On Sat, Jan 5, 2019 at 11:35 PM David Cousens < >> davidcous...@bigpond.com> wrote: >> > > > XboxBoy >> > > > >> > > > I've done this recently with a superannuation pension fund. I had >> initially >> > > > entered an Opening Balance from mid last year and the transactions >> forward >> > > > from that. I already had data for the pension payments entered as >> income >> > > > (not taxable in my case for this fund which is taxed in the hands >> of the >> > > > fund administrator), but not the fund itself as an asset and the >> investment >> > > > returns and fees charged, payments to me out of it etc. I took it >> back six >> > > > months at a time using the six monthly statements/transaction >> records I had >> > > > on file. Just changed the date on the opening balance transaction >> to the new >> > > > starting date and the balance at that date, then entered the >> investment >> > > > returns, fees pension payments etc between the new opening balance >> date and >> > > > the previous one. Checked that the opening and closing balances for >> that >> > > > period still agreed with my statements. >> > > > >> > > > I had to do a bit of trickery as I receive the pension payments >> paid >> > > > directly into my bank account from the fund administrator. To be >> able to >> > > > reconcile that with the bank statements, I could not record my >> pension >> > > > payments simply as decreases (credits) to the fund and increases in >> my bank >> > > > account. I set up a separate Income and Expenses account to record >> the >> > > > Investment return to the fund and expenses associated with that. An >> > > > additional Expenses account recorded the pension payments as >> decreases >> > > > (credits) to the asset account for th
Re: [GNC] [MAINT] server upgrade planned Feb 3, 2019 1200-2300 US/EST
On Wed., 16 Jan. 2019, 7:06 pm Liz On Tue, 15 Jan 2019 10:35:58 -0500 > Derek Atkins wrote: > > > Hi, > > > > PLANNED MAINTENANCE > > WHAT: Upgrading Operating System on Code > > WHEN: Feb 3, 2019 1200-2300 US/EST (1700-0400 UTC) > > > > > > tl;dr: I am planning to upgrade the OS on code.gnucash.org on February > > 3, 2019 from 1200-2300 US/EDT (1700-0400 UTC). During this > > time, git master, wiki, email/mailman, and gncbot/irc logs > > will all be unavailable. I'll be on #gnucash IRC for real-time > > updates and notices. > > > > > > Long version: > > > > The GnuCash "everything" server is getting a little long on the tooth, > > and to enable some upgraded build tools I plan to upgrade the server > > from Fedora 25 to Fedora 29. I plan to do this upgrade on Sunday, > > February 3, 2019, starting somewhere around 12:00 noon US/EST > > (although my personal schedule might push that back, hense the long > > maintenance window). I've upgraded a few systems from F25 -> F29 > > already, some of them upgraded in an hour, one system took over 4 > > hours. > > > > Code has lots of services so I expect it will take a long time to > > upgrade and verify that everything is working. > > > > During the upgrade window code will be unavailable, and the services > > running on code will be unavailable. I will stay on IRC during the > > upgrade to make real-time announcements. > > > > Please let me know if this time frame does not work for you. > > > > Thanks, > > > > -derek > > > > Well that's so many hours less spam I get to check > I'm quite happy with the proposal > > :) > > 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. > I've got two fedora servers that have done multiple os updates over the years. Mine have all gone smoothly. Best of luck, hope it goes as well as mine have. > ___ 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] Stocks/Equities queries (Australian Based)
Hi all. Just getting all my stocks entered into GNC. Reading the concepts/tutorial last night, I see 2 methods of setting up: Purchasing or setting up with an opening balance. I have records stretching back to the early 80's. Being Australian stocks, most spit out yearly/6 monthly or even quarterly dividends, and where possible, I use the DRIP (Dividend Re-Investment Plan) So if possible, I'd like to get that ALL entered. But for the time being, my question is: If I setup my accounts as they are now, using an opening balance, can I at a later date go back and adjust, and enter the earlier purchases/dividends of stocks/equities? Regards, Xboxboy ___ 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] Australian Initial Setup Q's
Hi all: Great to see how active the mailing list is. I'm in the process of getting all my finances into gnucash. Up until know I've been using a spreadsheet to track all my shares/stocks, fund and interest income. I've read and continue to read the guide and principles, and I run my business through MYOB, which is also a double entry system. But, I still have plenty of questions as I get settled in. The first is, I've got an old edition of Quicken Personal plus, which I've read the manual, and a really handy feature I seen was what they call "home inventory". This is used to keep track of items of value that aren't traditional stocks/bonds etc. This is particularly useful for insurance purposes, which I currently have a scrappy spreadsheet for also. Can anyone advise how to set this up, or if I'm missing something, and this function is already set to go? Many 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.