Re: [GNC] Return of Capital
John, I thought the same thing on price, but if you look closely, the “1” is cut off because the column is too small. The line total reflects that indeed, that split was at $10. Regards, Adrien > On Apr 19, 2019, at 9:55 PM, John Ralls wrote: > > > > Alen, > > Sorry, I missed the imgur links when I went back to your previous post and > saw only the text part. > > Part of the problem is that you were entering the sale at a price of 0 but > with an amount of 100 shares and a value of A$1000. In basic view GnuCash > will put up a dialog asking whether you want it to change the amount, value, > or price to make sense of it. Split view won't do that. That was probably > also what was suppressing generating the trading account splits. > > That's an interesting way of handling an RoC. The only downside for those of > us with different tax rates depending on how long we hold an investment is > that it resets the purchase date, and if we're not paying attention might > make one think at tax time that the $500 RoC was really a capital gain. > > Regards, > John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Return of Capital
> On Apr 19, 2019, at 2:34 PM, cicko wrote: > > John Ralls-2 wrote >> IIUC the transaction that you're creating is between IPE and AUD. That >> will cause trading account splits as they operate between any differing >> commodity pair, not just between currencies. > > Right, that's what I would expect. > > > John Ralls-2 wrote >> The example doesn't show shares or price columns. ... If it's still >> confusing post the whole transaction showing all 4 columns (i.e. shares, >> price, debit, and credit) and all splits including the trading account >> ones. > > Hm, not sure which example you saw but on these screenshots there are 4 > columns. The additional two, with totals, are blank as the transaction is > not yet posted. > I'm using Auto-Split view. > > My entry, before trying to save: https://imgur.com/i0CbKUq > The price is a bit skewed but it is $10 for Sell and $5 for Buy split. The > transaction seems to balance. > > Trying to save by pressing enter, the Trading split gets inserted (only 1!): > https://imgur.com/NzAFZLC > And from there, the dialog keeps popping up: https://imgur.com/bk8a9zb > > The records for the IPE trading accounts are missing, correct. This is a > good hint. I'd prefer to avoid them, as the balance stays the same but - > adding the two Trading:ASX:IPE records balances and the transaction is > saved. > Thanks! > > Here is the end-result: https://imgur.com/aOIxLxM > > Your example is difficult to follow in text mode but the screenshot above > should balance, as far as I can say. Alen, Sorry, I missed the imgur links when I went back to your previous post and saw only the text part. Part of the problem is that you were entering the sale at a price of 0 but with an amount of 100 shares and a value of A$1000. In basic view GnuCash will put up a dialog asking whether you want it to change the amount, value, or price to make sense of it. Split view won't do that. That was probably also what was suppressing generating the trading account splits. That's an interesting way of handling an RoC. The only downside for those of us with different tax rates depending on how long we hold an investment is that it resets the purchase date, and if we're not paying attention might make one think at tax time that the $500 RoC was really a capital gain. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Logging into the forum
Justin, Possibly not kosher for security reasons but I use the same credentials on both Nabble and the mailing list (just have to remember to update both if I change a pasword) , registered separately for each, and it works fine. I can use either for replying to posts but obviously not both. I find email easier to use on my phone and Nabble easier from my laptop and desktop as it is easier to follow the threads although that can also be done from the mailing list. While Nabble is not official it works well if you like that interface. 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] Assets don't display in CasgFlow report
Ron, Welcome to GnuCash! Edit your report options to include the accounts you want. There is an ‘Accounts’ tab where you make the selection. Be mindful of the account depth setting as well. Note, of course, the accounts in question have to have transactions during the same period as the report in order to show up. Regards, Adrien > On Apr 19, 2019, at 4:52 PM, Ron Eggler wrote: > > Hi, > GnuCash newbie here, sorry if the answer to my question is obvious. > When I create a Cash Flow report, Money In & Money Out seems to display > properly but the Assets don't. In accounts, I have some "Bank"-Type > accounts under "Asset". > My assets kind of look like (the account Type is in []): > Assets [Asset] > Deposits in Can banks/instit - Can currency [Asset[ >account1 [Bank] >account2 [Bank] >Deposit in Can banks/instit - Foreign currency >account1 (USD) [Bank] >account2 (USD) [Bank] > > why would this not work as expected and show up in the report accordingly? > And more importantly, how can I make my assets show up? > > Thanks a lot! > Ron ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] GnuCash V3.5 Not Used By My GnuCash Database
The first error was because you were not in the same directory as the .deb files. You could still run the command in that case, but then you’d have to specify the exact location of each .deb. It is much easier to just be in the same directory. I’m not sure why those files had architecture specifications on them (amd64) as I don’t think GC supports 32 bit any longer. (I could be mistaken) Anyhow, those three notes were simply telling you it was going to install the packages under different names. (more generic ones) This *might* have something to do with the way they were packaged. Regardless, the result of your last two commands tell you the following: which gnucash means the executable is in the standard location `/usr/bin`. That is, you don’t need to specify to the OS where to find it. It just launches it. sudo dpkg -l | grep gnucash reports that you have successfully installed 3.5 and there are no other versions lying around. (though I do see gnucash-docs is at version 3.4, you can remove that and manually download the 3.5 versions if you like, but I don’t think the docs are packaged as gnucash-docs accordingly, you’ll just have 2 pdf files for reference) Regards, Adrien > On Apr 19, 2019, at 2:01 PM, Lawrence Joy wrote: > > A synopsis of what I did to get V3.5 loaded and working on my Ubuntu 18.04.1 > LTS OS. The files: > MyNamed.gnucash > MyNamed.gnucash.20190304113239.log > MyNamed.gnucash.20190304124553.log > MyNamed.gnuchas.20190304124553.gnucash > are in /home/larry and gnucash-3.5 is in /home/larry/Downloads. > > I downloaded the three files by Stephen Butler off of Google Drive.--Thanks > for that information as I had not seen it any other place before. Those three > files were put in /home/larry/Downloads. Per instructions I did 'sudo apt > install ./*_3.5_*.deb' in my /home/larry directory as that was where my > gnucash files were. It came back with: > "Reading package lists... Done" > "E: Unsupported file ./*_3.5_*.deb given on commandline" > > I then went to /home/larry/Downloads directory and entered the same thing. It > came back with > "Reading package lists... Done" > "Building dependency tree" > "Reading state information... Done" > "Note, selecting 'gnucash' instead of './gnucash_3.5_amd64.deb" > "Note, selecting 'gnucash-common' instead of './gnucash-common_3.5_all.deb" > "Note, selecting 'python3-gnucash' instead of > './python3-gnucash_3.5_amd64.deb" > "Do you want to continue? [Y/n]" The three notes bothered me but I went ahead > and answered Y. > It took about an hour and a half to do the download/programming. > > Now when I push the Super Key and then push G the gnucash icon shows up, > which I click on, and when I check Help>About it says its GnuCash V3.5. > Hurray! > > On the terminal I run 'which gnucash' and get back "usr/bin/gnucash". > On the terminal I also run 'sudo dpkg -l | grep gnucash' and get back > ii gnucash1:3.5 >amd64personal and small-business > financial-accounting software > ii gnucash-common 1:3.5 >all common files for the financial-accounting > software Gnucash > ii gnucash-docs 3.4-0+bionic~ppa1 >all Documentation for gnucash, a personal finance > tracking program > ii python3-gnucash1:3.5 >amd64Gnucash interface for Python > > Everything seems to be okay now. Thanks for all your help. > --Larry ___ 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: Assets don't display in CasgFlow report
Hi, GnuCash newbie here, sorry if the answer to my question is obvious. I'm using version 2.6.12 When I create a Cash Flow report, Money In & Money Out seems to display properly but the Assets don't or better, the report doesn't show an amount behind the account name. In the report options, I selected Account Display Depth 3 (instead of 2) and if I click onto the account names (the links) it takes me correctly to the corresponding account with all transactions but still, no balance for the accounting period shows up why is this? In accounts, I have some "Bank"-Type accounts under "Asset". My assets kind of look like (the account Type is in []): Assets [Asset] Deposits in Can banks/instit - Can currency [Asset] account1 [Bank] account2 [Bank] Deposit in Can banks/instit - Foreign currency account1 (USD) [Bank] account2 (USD) [Bank] why would this not work as expected and show up in the report accordingly? And more importantly, how can I make my assets' balances show up? Thanks a lot! Ron ___ 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] Assets don't display in CasgFlow report
Hi, GnuCash newbie here, sorry if the answer to my question is obvious. When I create a Cash Flow report, Money In & Money Out seems to display properly but the Assets don't. In accounts, I have some "Bank"-Type accounts under "Asset". My assets kind of look like (the account Type is in []): Assets [Asset] Deposits in Can banks/instit - Can currency [Asset[ account1 [Bank] account2 [Bank] Deposit in Can banks/instit - Foreign currency account1 (USD) [Bank] account2 (USD) [Bank] why would this not work as expected and show up in the report accordingly? And more importantly, how can I make my assets show up? Thanks a lot! Ron ___ 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] Return of Capital
John Ralls-2 wrote > IIUC the transaction that you're creating is between IPE and AUD. That > will cause trading account splits as they operate between any differing > commodity pair, not just between currencies. Right, that's what I would expect. John Ralls-2 wrote > The example doesn't show shares or price columns. ... If it's still > confusing post the whole transaction showing all 4 columns (i.e. shares, > price, debit, and credit) and all splits including the trading account > ones. Hm, not sure which example you saw but on these screenshots there are 4 columns. The additional two, with totals, are blank as the transaction is not yet posted. I'm using Auto-Split view. My entry, before trying to save: https://imgur.com/i0CbKUq The price is a bit skewed but it is $10 for Sell and $5 for Buy split. The transaction seems to balance. Trying to save by pressing enter, the Trading split gets inserted (only 1!): https://imgur.com/NzAFZLC And from there, the dialog keeps popping up: https://imgur.com/bk8a9zb The records for the IPE trading accounts are missing, correct. This is a good hint. I'd prefer to avoid them, as the balance stays the same but - adding the two Trading:ASX:IPE records balances and the transaction is saved. Thanks! Here is the end-result: https://imgur.com/aOIxLxM Your example is difficult to follow in text mode but the screenshot above should balance, as far as I can say. -- 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] CSV import lags and burns CPU; can't report bug
GnuCash 3 is using a different way to store import matcher heuristics internally. The first time the csv importer is run, any heuristics in the old format are converted to the newer format. Depending on how large this heuristics database is, this can take a considerable amount of time. And unfortunately there is no visual indication this process is running - an unfortunate omission. The dev that implemented the conversion probably didn't expect this to be an issue (and I wouldn't have either tbh). So maybe this internal conversion is what you experienced. As it should only run once (if you let it complete) subsequent imports should be faster. Regards, Geert Op donderdag 11 april 2019 01:12:53 CEST schreef Mark Hedges via gnucash-user: > It was super super slow... until it wasn't. I tried the import over again > with the descriptions modified with an "x" so they don't stomp on > autocomplete for previously filed transactions. It imported 160 > transactions in about 2 seconds today. So I don't know what was up. Evil > gnomes? > > Mark > > On Mon, Apr 8, 2019 at 3:55 PM John Ralls wrote: > > Huh. Another corner of the Windows Installer I hadn't noticed before. > > > > Fixed, will be in the next nightly build. > > > > Regards, > > John Ralls > > > > > On Apr 8, 2019, at 12:57 PM, Adrien Monteleone < > > > > adrien.montele...@lusfiber.net> wrote: > > > GnuCash’s Bugzilla database moved to bugs.gnucash.com several moons ago. > > > > > > I can’t find any similar shortcut for bug filing on MacOS, so this is > > > > probably for the Windows version only. (I don’t ever recall seeing it with > > Linux versions either) > > > > > You should file a bug on that as well, since it needs to point to the > > > > correct location. > > > > > Regards, > > > Adrien > > > > > >> On Apr 8, 2019, at 1:51 PM, Mark Hedges via gnucash-user < > > > > gnucash-user@gnucash.org> wrote: > > >> Hi. I'm trying to import transactions from a very simple CSV file, > > > > using a > > > > >> default account and a single transfer account in a CSV field. I get to > > > > the > > > > >> stage to go from "Transaction Information" where it says "On the > > > > following > > > > >> page you will be able to associate each transaction to a category." > > > > Even a > > > > >> 1-line CSV test file takes about 10 or 15 seconds to get to the next > > > > page. > > > > >> With 160 transactions, the program stops responding, though it is > > > > burning > > > > >>> 30% CPU. I assume it will finish eventually, but this process seems > > > > to be > > > > >> very inefficient. > > >> > > >> I can't seem to report a bug anymore. I just installed GnuCash 3.5. > > > > When > > > > >> I go to Start > GnuCash > Report a GnuCash Bug (Online), this takes me > > > > to > > > > >> bugzilla.gnome.org. It says that most projects have migrated to > > > > GitLab, > > > > >> but for GnuCash I should NOT go to GitLab. When I try to log into > > >> bugzilla, it says "Sorry, entering a bug into the product GnuCash has > > > > been > > > > >> disabled." However, the GitLab site linked from the BugZilla page does > > > > not > > > > >> seem to have a GnuCash project. Where should we report bugs these > > >> days? > > >> > > >> Thanks. > > >> > > >> Mark Hedges > > > > > > ___ > > > gnucash-user mailing list > > > gnucash-user@gnucash.org > > > To update your subscription preferences or to unsubscribe: > > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > > If you are using Nabble or Gmane, please see > > > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > > > > - > > > Please remember to CC this list on all your replies. > > > You can do this by using Reply-To-List or Reply-All. > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > If you are using Nabble or Gmane, please see > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > - > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Na
Re: [GNC] GnuCash V3.5 Not Used By My GnuCash Database
A synopsis of what I did to get V3.5 loaded and working on my Ubuntu 18.04.1 LTS OS. The files:MyNamed.gnucashMyNamed.gnucash.20190304113239.logMyNamed.gnucash.20190304124553.logMyNamed.gnuchas.20190304124553.gnucashare in /home/larry and gnucash-3.5 is in /home/larry/Downloads. I downloaded the three files by Stephen Butler off of Google Drive.--Thanks for that information as I had not seen it any other place before. Those three files were put in /home/larry/Downloads. Per instructions I did 'sudo apt install ./*_3.5_*.deb' in my /home/larry directory as that was where my gnucash files were. It came back with:"Reading package lists... Done""E: Unsupported file ./*_3.5_*.deb given on commandline" I then went to /home/larry/Downloads directory and entered the same thing. It came back with"Reading package lists... Done""Building dependency tree""Reading state information... Done""Note, selecting 'gnucash' instead of './gnucash_3.5_amd64.deb""Note, selecting 'gnucash-common' instead of './gnucash-common_3.5_all.deb""Note, selecting 'python3-gnucash' instead of './python3-gnucash_3.5_amd64.deb""Do you want to continue? [Y/n]" The three notes bothered me but I went ahead and answered Y.It took about an hour and a half to do the download/programming. Now when I push the Super Key and then push G the gnucash icon shows up, which I click on, and when I check Help>About it says its GnuCash V3.5. Hurray! On the terminal I run 'which gnucash' and get back "usr/bin/gnucash".On the terminal I also run 'sudo dpkg -l | grep gnucash' and get backii gnucash 1:3.5 amd64 personal and small-business financial-accounting software ii gnucash-common 1:3.5 all common files for the financial-accounting software Gnucash ii gnucash-docs 3.4-0+bionic~ppa1 all Documentation for gnucash, a personal finance tracking program ii python3-gnucash 1:3.5 amd64 Gnucash interface for Python Everything seems to be okay now. Thanks for all your help.--Larry >I don?t know if you even had 3.4 installed unless you knew for a fact you >were once running it. (If that is the case, you might have earlier removed >2.6.19) **Yes, the Help>About said it was V3.4. >It looks like you downloaded the 3.5 source. (you mentioned it contained >directories and files) >You can build from that source download using the wiki instructions, or use >the pre-built deb packages as Colin suggests. If you choose not to build from >source, you can safely delete that gnucash-3.5 directory. **I'm not a programmer so I stick to official released stuff. >Do not delete the files ending in .gnucash. The first one `MyNamed.gnucash` is >your main data file. The last one `MyNamed.gnucash.20190304124553.gnucash` is >a backup file. The other two are log files as their file extension suggests. >Keeping the logs and the backup is optional. Just don?t delete the main data >file. >I would still run the dpkg -l command to make sure there are no other versions >on your system before installing 3.5: >sudo dpkg -l | grep gnucash >(no response and a return to the command prompt means nothing else concerning >gnucash is installed) >You can also perform a: >which gnucash >to see if the system thinks an executable with that name is located anywhere, >but I don?t expect it will find anything. >Regards, >Adrien ___ 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] Recording dividend payoffs
I’d suspect, more likely than not, if I were running a business that needed such accounting, I too would close the books each year. It would be nice if GC handled Equity accounts without having to do so, but as-is, the software is certainly usable for a more formal business case. Regards, Adrien > On Apr 19, 2019, at 6:35 AM, David Cousens wrote: > > Hi Justin > > I certainly prefer the approach of declaring dividends as a contra acunt to > Retained Earnings and/or debiting it directly to Retained Earnings but it > will require closure of the books to provide retained earnings to handle it > properly. > > That said there is nothing technically wrong in accounting terms with having > a dividend expense account which is closed to Retained Earnings. The act of > closing it to the Retained Earnings subtracts the dividend from Equity in > this case. The only difficulty is that the procedure is not as clear in > making it obvious that dividends are paid out of profits. > > The problem with how the reports deal with Retained Earnings is another > issue. Retained Earnings is a permanent account of a business. The net > income or profit/loss is only a periodic increment or decrement in that > account value not the value of Retained Earnings itself. GnuCash for the > reporting must calculate Retained Earnings as Income - Expenses calculated > from when the since books are opened. If the dividends are accounted for > with an expense account, then they have been deducted from Retained Earnings > and hence from Equity. However they will not appear as a line item unless > listed in the expenses. Depending on tax rules they may or may not be a > deductible business expense, generally not in most jurisdictions as in most > cases where dividends are paid out of after tax profits. Specific > jurisdictional rules could however prevent using expense accounts to record > dividends. > > If I was running a business and using GnuCash, I would be closing the > Income and Expense accounts to Retained Earnings using the closing procedure > to zero out the temporary accounts. That way the closing transactions are > explicit and as long as the Balance Sheet is calculated at a date after the > transactions for the dividends have been applied they should be reported in > the balance sheet. Using the contra account should allow you to list them > explicitly in a Balance Sheet report if you need to. > > David Cousens ___ 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 treat benefit payments from government?
Good to know, thanks! Regards, Adrien > On Apr 19, 2019, at 6:17 AM, R. Victor Klassen wrote: > > Both the Trillium benefit and the HST/GST credit are essentially refundable > tax credits, except that are paid out either over a period of a year > beginning some time after the filing deadline, or in a lump sum (but later). > Unlike in the US where state tax refunds are income for federal purposes, > provincial and federal taxes do not interact. So these are purely tax-free. > >> On Apr 18, 2019, at 9:36 AM, Adrien Monteleone >> wrote: >> >> Michael, >> >> Yep, I’m well aware. I just looked over my Mom’s filing before she mailed it >> off. Certainly, having to massage the raw number two or three times with >> various figures from multiple lines on several different schedules just to >> figure out if her SS payments were taxable I can attest you are correct, >> that my question isn’t always a simple one. >> >> But even an answer of ‘depends’ is an answer that you can take some action >> on. >> >> Though I don’t live in Canada, I’m still curious to see how that one should >> be handled. >> >> Regards, >> Adrien >> >>> On Apr 18, 2019, at 8:23 AM, Michael or Penny Novack >>> wrote: >>> >>> On 4/17/2019 6:16 PM, Adrien Monteleone wrote: Someone on the list from Canada (even better, a local CPA) should offer better advice, but the first question you probably want answered is, “Is this taxable next year?” That will likely influence how you record it now. Regards, Adrien >>> Adrian, it could be worse than that (in the general case). How about SS >>> pension payments here in the US? The question "is this taxable" cannot be >>> answered based upon the pension payment alone because it will depend on >>> OTHER income received. Thus while you could possibly "know" (barring >>> unexpected events) that none of it will be taxable (your estimate of other >>> income is below X) or that 85% of it will be taxable (your estimate of >>> other income is above Y) what you enter COULD be wrong << in the former >>> case you ended up receiving some windfall and in the latter, suffered some >>> economic disaster >> But SOME of us, alas, normally have an "other" income >>> between X and Y and always have a messy calculation to perform come tax >>> time to figure out how much of our SS was taxable. >>> >>> 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 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] Return of Capital
Alen, Yes, I saw that. IIUC the transaction that you're creating is between IPE and AUD. That will cause trading account splits as they operate between any differing commodity pair, not just between currencies. I presume that you're working on the transaction in split view. In that view GnuCash's automatic price conversion is turned off so it's to the user to enter values (in the split's commodity) and amounts (in the transaction currency) that balance in the transaction currency. The example doesn't show shares or price columns. If you're trying to create or edit the transaction in a currency account where those aren't shown it can make getting the balance right difficult so try switching to the IPE account to view the transaction. If it's still confusing post the whole transaction showing all 4 columns (i.e. shares, price, debit, and credit) and all splits including the trading account ones. Aside from that you've overstated your return of capital. Consider the whole cycle (AUD balance reflects the cash account so decreases with debit in the stock account): Description Shares Price Debit Credit Share Bal. AUD Buy ISE 100 100 10 1000 100 -1000 ISE Return of Capital 500 - 500 Sell ISE 100 @ 10 -10010 10000 500 Buy ISE 100 @ 5 100 5 500 100 0 The return of capital changes the basis on its own, though I think the Advanced Portfolio Report doesn't understand returns of capital and won't reflect the change in basis. When you get around to really selling the ISE then when you compute the capital gain you'll subtract the return of capital from the original basis. Regards, John Ralls > On Apr 18, 2019, at 10:26 PM, cicko wrote: > > John, I've included the answer to your question(s) in the thread continuing > on Adrien's answer. There may be something wrong with the insertion of the > adjusting splits. > In both cases, you might want to follow up there. Thanks! > > > > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Recording dividend payoffs
Hi Justin I certainly prefer the approach of declaring dividends as a contra acunt to Retained Earnings and/or debiting it directly to Retained Earnings but it will require closure of the books to provide retained earnings to handle it properly. That said there is nothing technically wrong in accounting terms with having a dividend expense account which is closed to Retained Earnings. The act of closing it to the Retained Earnings subtracts the dividend from Equity in this case. The only difficulty is that the procedure is not as clear in making it obvious that dividends are paid out of profits. The problem with how the reports deal with Retained Earnings is another issue. Retained Earnings is a permanent account of a business. The net income or profit/loss is only a periodic increment or decrement in that account value not the value of Retained Earnings itself. GnuCash for the reporting must calculate Retained Earnings as Income - Expenses calculated from when the since books are opened. If the dividends are accounted for with an expense account, then they have been deducted from Retained Earnings and hence from Equity. However they will not appear as a line item unless listed in the expenses. Depending on tax rules they may or may not be a deductible business expense, generally not in most jurisdictions as in most cases where dividends are paid out of after tax profits. Specific jurisdictional rules could however prevent using expense accounts to record dividends. If I was running a business and using GnuCash, I would be closing the Income and Expense accounts to Retained Earnings using the closing procedure to zero out the temporary accounts. That way the closing transactions are explicit and as long as the Balance Sheet is calculated at a date after the transactions for the dividends have been applied they should be reported in the balance sheet. Using the contra account should allow you to list them explicitly in a Balance Sheet report if you need to. 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] How to treat benefit payments from government?
Both the Trillium benefit and the HST/GST credit are essentially refundable tax credits, except that are paid out either over a period of a year beginning some time after the filing deadline, or in a lump sum (but later). Unlike in the US where state tax refunds are income for federal purposes, provincial and federal taxes do not interact. So these are purely tax-free. > On Apr 18, 2019, at 9:36 AM, Adrien Monteleone > wrote: > > Michael, > > Yep, I’m well aware. I just looked over my Mom’s filing before she mailed it > off. Certainly, having to massage the raw number two or three times with > various figures from multiple lines on several different schedules just to > figure out if her SS payments were taxable I can attest you are correct, that > my question isn’t always a simple one. > > But even an answer of ‘depends’ is an answer that you can take some action on. > > Though I don’t live in Canada, I’m still curious to see how that one should > be handled. > > Regards, > Adrien > >> On Apr 18, 2019, at 8:23 AM, Michael or Penny Novack >> wrote: >> >> On 4/17/2019 6:16 PM, Adrien Monteleone wrote: >>> Someone on the list from Canada (even better, a local CPA) should offer >>> better advice, but the first question you probably want answered is, “Is >>> this taxable next year?” >>> >>> That will likely influence how you record it now. >>> >>> Regards, >>> Adrien >> Adrian, it could be worse than that (in the general case). How about SS >> pension payments here in the US? The question "is this taxable" cannot be >> answered based upon the pension payment alone because it will depend on >> OTHER income received. Thus while you could possibly "know" (barring >> unexpected events) that none of it will be taxable (your estimate of other >> income is below X) or that 85% of it will be taxable (your estimate of other >> income is above Y) what you enter COULD be wrong << in the former case you >> ended up receiving some windfall and in the latter, suffered some economic >> disaster >> But SOME of us, alas, normally have an "other" income between X >> and Y and always have a messy calculation to perform come tax time to figure >> out how much of our SS was taxable. >> >> 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 > 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] Return of Capital
> On Apr 19, 2019, at 12:24 AM, cicko wrote:
>
> Adrien Monteleone-2 wrote
>> Interesting that GC is throwing that Trading split in at all. The
>> transaction balances without it. I’ll presume this brokerage account for
>> the fund and the cash are both in AUD also?
>
> Correct. My case is in AUD even though the example which suggests how to
> post such transaction, in the first post, is in USD.
>
>
> Adrien Monteleone-2 wrote
>> Does manually adding:
>>
>> Dr.(buy) Trading:CURRENCY:AUD$500
>>
>> Satisfy GC and avoid the pop-up?
>> The two Trading splits would be superfluous but they should then balance.
>
> That's an interesting suggestion! And it should work, theoretically.
> :(
> https://imgur.com/VbDrPKU
>
> Unfortunately, GC inserts *another* trading record for $10. And also $10
> Imbalance-AUD, to balance that, I guess.
> And, when trying to post the transaction, it tells me that the transaction
> does not balance and offers the same dialog with "balance manually" and "let
> GC add the adjusting split”.
But this looks like an entirely different transaction.
What happens if you try to manually balance the one you outline below? (the 100
shares ea. @ $5/$10, $500 transaction)
What does GC insert if you let it do it automatically?
Two more things to try,
#1 - choose manual editing in that pop-up and this time, instead of adding a
balancing split, delete the Trading:Currency split, since the transaction
should balance without it. Does GC accept this or does it add it back?
#2 - (working on a backup file) turn off trading accounts and see what happens
when you try to enter this transaction fresh.
It looks like a loop here where it never balances. If this really does get
stuck in such a loop, then certainly there is a bug. You should either be able
to balance manually, or GC should be able to do it, not just get stuck in an
infinite (or at least several repetitions of a) reduction loop.
While actual transaction pricing should be inserted into the price DB, out of
curiosity, is there a price on this date? Is GC inserting either the $5 or $10
price on this date as well? Is there some sort of multiple price insertion loop
happening there?
> Adrien Monteleone-2 wrote
>> If you let GC balance it, what does it insert?
>
> If I do the initial entry of (names adjusted for simplicity):
>
> 2019-04-01 * Return of capital
> Assets:Investments:Broker:Cash 500.00 AUD
> Assets:Investments:Broker:Shares:IPE100 IPE { 5.00 USD} [2000-01-01]
> @ 5.00 AUD
> Assets:Investments:Broker:Shares:IPE -100 IPE {10.00 USD} [2000-01-01]
> @ 5.00 AUD
>
> https://imgur.com/i0CbKUq
>
> then it will add the Trading:CURRENCY:AUD record: https://imgur.com/NzAFZLC
> and, when trying to post, show the dialog dialog: https://imgur.com/bk8a9zb.
>
> No matter which option is selected, nothing will change, and I can't
> proceed.
> If I add another balancing split for trading account, as suggested earlier,
> the same dialog appears and the transaction can't get saved.
>
>
> Adrien Monteleone-2 wrote
>> Is that ANZ Cash account something special or just a cash type asset in
>> AUD? (effectively no different than Assets:Cash?)
>
> The names can get mixed as the sample had generic names and USD currency
> whereas my screenshots and examples may use real names (ANZ broker). ANZ
> Cash is just the actual cash account with the broker, nothing special. Cash
> & ANZ Cash are just used intermittently. There are only two accounts in the
> scenario - commodity (share/fund) and cash.
Understood, I just wanted to clear up if it was a special account type or just
a standard asset.
Regards,
Adrien
___
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.
