Re: [GNC] gnucash-user Digest, Vol 233, Issue 34
Adrien, It does indeed Menu->Administration->Backup Tool. I don't usually make use of it as my NAS initiates and carries out my main backups for me and a couple of crons do the rest. It looks like it can access network locations too. I have a mixed Linux/Windows (can't convert the wife) setup which the NAS handles for me David On Thu, 2022-08-11 at 00:35 -0500, Adrien Monteleone wrote: > If I'm not mistaken, Mint has a backup utility. So you can just set it > up and make sure the GnuCash locations noted in the Wiki and Guide are > included in the paths to be backed up. > > Regards, > Adrien > > On 8/10/22 9:29 PM, davidcousen...@gmail.com wrote: > > James > > > > https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-backup1.html > > > > The info https://wiki.gnucash.org/wiki/Configuration_Locations is also > > useful > > for backing up user preferences and things like customized reports. > > > > To back up to a USB drive on Linux Mint, the drive should appear in the file > > manager (icon that looks like a filing cabinet folder in the LH panel of the > > Menu) once you have plugged it in and it is mounted. Navigate to andelect > > the > > folder containing the data file Ctr-c to copy it. Navigate to the USB hard > > drive > > and select a suitable directory to keep your backups in on the Hard drive > > and > > Ctrl-v to paste a copy there (or use the Edit items in the menu). > > > > How to do actually backups is an operating system issue and not really a > > GnuCash > > issue. Gnucash's internal backup, logfiles and restore capability are > > primarily > > about recovering from a datafile corrupted by a GnuCash program crash, > > rather > > than general computer failures like a hard disk failure. There are any > > number > > of articles on general computer backup strategies on the internet depending > > on > > the facilities you have available and how much you want to spend setting it > > up. > > A good practice is at least a backup to another local device in your > > home (USB > > disk, NAS, another computer) and a backup to an offsite facility to protect > > you > > if your house burns down for example (USB stick kept by a relative ot cloud > > facility) > > > > On Linux you can create "cron" jobs to schedule automatic backups if this is > > useful. For example I backup critical files to a cloud storage as well as > > local > > network storage on my LAN automatically daily and synchronize files between > > my > > laptop and desktop with Unison whenever they are connected so there are > > always > > multiple copies of my most recent datafile. My NAS is separately backedp up > > to > > cloud storage. > > ___ > 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.
[GNC] Found Another Potential Bug
This time in the Find function in the GUI. Here are the steps to reproduce: 1. Create a fresh GnuCash file of SQLite3 type. 2. Create a new company named "Acme" 3. Create a second new company called "The Empire" 4. Create a new job named "Build Deathstar" and set the owner information to "The Empire" 5. Create a new invoice with billing info set to customer "The Empire" and job set to "Build Deathstar". 6. Create an entry in the new invoice with description "Vaporize Alderaan", action "Project", account "Income:Sales", quantity 1, and unit price 1000. 7. Hit enter 8. Create a new job named "Catch Roadrunner" and set the customer to "Acme". 9. Create a new invoice with customer set to "Acme" and job set to "Catch Roadrunner". 10. Create an entry in the new invoice with description "Rocket powered rollerskates", action "Material", account "Income:Sales", quantity 1, and unit price 2000. 11. Business menu > Customer > Find Invoice... 12. Set the search criteria to "Invoice Owner" "is" "Customer" then click "Select" 13. Navigate to one of the customers and click "Select". 14. Back in the main find window, click "Find". Observe that the find failed and returned all invoices rather than the ones owned by the expected customer per search criteria. You can rinse and repeat this with setting the "Invoice Owner" "is" "Job" and pick any existing job and the same failure happens. Definitely a software defect here. Can someone reproduce this? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Unit Tests
Looking at the code repo I see a directory of unit tests, but it doesn't look like it has actual unit tests. Do you all do continuous integration somewhere and have unit tests? When a software defect is identified and fixed, do you create a unit test based on the fix? ___ 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] Possible Bug in Credit Note Display
> do you need me to file it? I don't have an account. Can you file it? ___ 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] Unit Tests
Hi, This question really belongs on gnucash-devel, not gnucash-user. So I am CC'ing that. Please direct your replies to the -devel list and drop -user from the CC list! On Thu, August 11, 2022 7:56 am, Robert Simmons wrote: > Looking at the code repo I see a directory of unit tests, but it doesn't > look like it has actual unit tests. Do you all do continuous integration > somewhere and have unit tests? When a software defect is identified and > fixed, do you create a unit test based on the fix? There are some Github Actions in place. It should be running the "make check" process. Depending on the bug, sometimes unit tests can't be written (e.g. if it's a UI issue). But in general, for the engine, yes, we try to add a test-case along with the bugfix. But there is no hard-and-fast rule. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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] Share Values recording
Hello, I am trying to rationalise my shares (or things that have a moving value) holdings. I understand the basics of GNU, in that I have been a user for some time and have been able to record transactions, create reports to satisfy the taxman, etc., but I keep getting bits and pieces of information from the various places where my shares are registered, mostly about values and dividends and the like. I have a somewhat random selection of 'accounts' with information about my (relatively small number) of holdings (a word that is a bit strong for my situation) What I am aiming to do is get a simple account or accounts where I can just register what I paid, what dividends and other income stuff I may have had and items such as current value. Is there a simple source in the 'help' for creating that and what is it called and what does it contain?? If not where should I start?? Sorry to be a neophyte, but I am a bit frustrated. Finbar (located in Europe, but only really dealing in €) ___ 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] Scheduled transactions do not appear in the register until is pressed
Replying to an old thread I found with a search. Using GnuCash version 4.11 on Windows 11. I've been using GnuCash for a few years and very happy with it. I haven't seen this problem until recently when I switched my scheduled transactions from no automatic entry with reminders, to automatic advanced entry with no reminders. Like Glenn, I have "run when the data file is opened" checked, and now I see this same problem that the created transactions don't show up in the register. I was restarting GnuCash to see the new entries in the register. Appreciate the tip that pressing helps. I haven't been able to find any other resolution in my search so I though I'd just mention what I'm seeing here. Tom On /Fri Oct 1 17:58:51 EDT 2021/, *Glenn Fowler* wrote: I have numerous scheduled transactions in multiple books and in settings have them "run when the data file is opened". The transactions do run as expected but do not appear in the register until you press . With them not appearing, I am not looking at an out of date register until I enter a transaction or press . Wouldn't it make sense for them to appear without user input so we are looking at up-to-date books instead of trying to create a habit for myself to click on every open? Thank you Glenn ___ 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] Scheduled transactions do not appear in the register until is pressed
I still consider this a bug and not a feature request since not seeing an up-to-date register could really throw things off. To the community and GnuCash team - should I open an issue in Bugzilla? On Thu, Aug 11, 2022 at 12:02 PM Tom Veik wrote: > Replying to an old thread I found with a search. > > Using GnuCash version 4.11 on Windows 11. I've been using GnuCash for a > few years and very happy with it. I haven't seen this problem until > recently when I switched my scheduled transactions from no automatic > entry with reminders, to automatic advanced entry with no reminders. > Like Glenn, I have "run when the data file is opened" checked, and now I > see this same problem that the created transactions don't show up in the > register. I was restarting GnuCash to see the new entries in the > register. Appreciate the tip that pressinghelps. > > I haven't been able to find any other resolution in my search so I > though I'd just mention what I'm seeing here. > > Tom > > On /Fri Oct 1 17:58:51 EDT 2021/, *Glenn Fowler* wrote: > > > I have numerous scheduled transactions in multiple books and in settings > > have them "run when the data file is opened". The transactions do run as > > expected but do not appear in the register until you press . > > With them not appearing, I am not looking at an out of date register > until > > I enter a transaction or press . Wouldn't it make sense for them > to > > appear without user input so we are looking at up-to-date books instead > of > > trying to create a habit for myself to click on every open? > > > > Thank you > > Glenn > ___ > 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] Share Values recording
Accounting question --- how does YOUR jurisdiction tax "gains or losses from sale of securities"? In other words, you might very much NOT want to do this in your main books, as would complicate matters at tax time. This does NOT mean that you can't use gnucash to ALSO provide you with more realistic "net worth" information. I'm here in the US, where capital gains are taxed differently than "income" so I would not want to do what you propose in my main books. But if a large component of my net worth was in "unrealized gains" I might choose to have a separate set of books just for this purpose. That would not be a lot of extra work as the only transactions here would be acquisition and sale of assets plus periodic adjustments to market. Like I said, this is a TAX issue. Thus you may be seeing people discussing adjusting to market in their regular books but they are talking about holdings in a 401k, IRA, Roth IRA, or other form of tax sheltered account. Michael D Novack On 8/11/2022 10:30 AM, Mahon Finbar wrote: Hello, I am trying to rationalise my shares (or things that have a moving value) holdings. I understand the basics of GNU, in that I have been a user for some time and have been able to record transactions, create reports to satisfy the taxman, etc., but I keep getting bits and pieces of information from the various places where my shares are registered, mostly about values and dividends and the like. I have a somewhat random selection of 'accounts' with information about my (relatively small number) of holdings (a word that is a bit strong for my situation) What I am aiming to do is get a simple account or accounts where I can just register what I paid, what dividends and other income stuff I may have had and items such as current value. Is there a simple source in the 'help' for creating that and what is it called and what does it contain?? If not where should I start?? Sorry to be a neophyte, but I am a bit frustrated. Finbar (located in Europe, but only really dealing in €) ___ 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. -- There is no possibility of social justice on a dead planet except the equality of the grave. ___ 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] Tax Accounting for Trust Income Received in Following Fiscal Year
> On Aug 11, 2022, at 6:06 AM, flywire wrote: > > It's tax time again and I'm wondering if I can improve on the process I > described in > https://lists.gnucash.org/pipermail/gnucash-user/2021-August/097424.html > > It works and keeps my accountant happy but it just doesn't seem to sit well > with double-entry accounting to just ignore a few accounts at tax time and > slip in a funny-money cheat sheet for ETF (Mutual Fund?) investments. I'd > welcome any suggestions for a better way of doing it. > > Attached is an ETF statement. The total of each of the 10 Tax codes in the > top section for all ETFs is reported in the attached guide on p4. > > The Cash distributions are on the bottom left and the Attribution is on the > bottom right don't match. I understand the issue is summarising different > tax treatments for Dividends, Franking credits, Realised capital gains, > Interest, and Foreign Income categories. I'd prefer to enter what is > relevant into GnuCash but I don't understand the accounting. I also > understand there are different ways of accounting for tax but any guidance > would be welcome. > > I don't want to get into the detail of setting up an investment portfolio > as explained in the guide and I can't see that it addresses this issue. I'd > be happy to revalue the few funds at the end of each tax year (with > guidance) for the balance sheet. > > This should feed into the financial statements for the trust which owns the > ETF units and distributes the proceeds each year. The Cash distribution has > been distributed with pro-rata funny-money reported. > > [image: VAS-annual-tax-statement-2018.png] > Nobody here is qualified to give you either accounting or tax advice. You need to hire one or more locally licensed professional advisors to guide you. With the disclaimer out of the way, I guess it's down to what you have to report on your taxes. In the US neither an ETF nor a mutual fund (a Registered Investment Company or RIC in the US tax code) would give you a breakdown like that. In both cases the only tax event that either generates are periodic dividends. Those come in 4 flavors and one can simply set up an income account for each flavor. These instruments all represent a corporation that is responsible for filing and paying its own taxes so the internals are opaque to the investor just like common and preferred stock holders. Then there are pass-through entities. These may be small corporations in which the investor is actively involved or some flavor of partnership. There are very large partnerships called Master Limited Partnerships that trade on the stock exchanges. A lot of these are structured so that the periodic payouts are called "returns of capital" until the nominal basis of one's holdings is exhausted; in US tax law these reduce one's basis in the investment increasing the capital gain when the investment is liquidated but accruing no tax in the meantime. All of these pass-through entities report to the investors annually their share of the company's/partnership's internal results: Revenues, expenses, special tax items, etc. and those amounts are applied to the investors tax return. I don't think that it's sane to try and track those amounts in one's personal accounts. Transfer the numbers into your tax software or include the forms in the bundle you send to your tax preparer and be done with i t. Much less common than any of those is the investment pool, sometimes marketed as a "Managed Portfolio", generally as a way for banks and brokerages to extract more fees from trusts and high net-worth clients who otherwise pay a fixed percentage of their portfolio as an annual fee in lieu of commissions on trading. They typically have exorbitant management fees, often more than 5% compared to the .5-1.5% for actively-managed mutual funds or .1% and less for ETFs and index funds. These vehicles can invest in all manner of things and generally pay no taxes themselves, handing off the investors share of every income category to add to their own tax returns. The statement that you posted looks like it might be from one of these. As in the MLP case I don't think it's practical to try and set up accounts in your own books matching the investment pool's holdings. It's too hard. Make an income account for the gross payouts and leave the tax reporting details in your tax software or tax prepar er. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Possible Bug in Credit Note Display
Robert, Done: https://bugs.gnucash.org/show_bug.cgi?id=798598 However, it seems you're on quite a streak finding bugs. Consider registering an account. Regards, Adrien On 8/11/22 7:03 AM, Robert Simmons wrote: do you need me to file it? I don't have an account. Can you file it? ___ 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] Scheduled transactions do not appear in the register until is pressed
I thought one was already opened. (but I admit I didn't search for it) If I recall correctly, it has to do with refreshing the register view. This seems to happen with registers that are left open at the last close and which re-open before the Since Last Run dialog fires. Though hitting [Enter] works to refresh, so does closing and opening the affected registers, as does View > Refresh. (CMD/CTRL+R) Other not so great options would be to close registers you have SX for each time you close GnuCash; (you'll end up opening them after the SX fires) or don't close GnuCash at all and just get in the habit of refreshing; (of course, then you also have to get in the habit of manually firing Since Last Run) or, go back to the previous SX settings which didn't cause this. As the function to refresh a register/report exists, I'm betting this falls more under 'enhancement' for an auto-refresh case. Regards, Adrien On 8/11/22 11:15 AM, Glenn Fowler wrote: I still consider this a bug and not a feature request since not seeing an up-to-date register could really throw things off. To the community and GnuCash team - should I open an issue in Bugzilla? On Thu, Aug 11, 2022 at 12:02 PM Tom Veik wrote: Replying to an old thread I found with a search. Using GnuCash version 4.11 on Windows 11. I've been using GnuCash for a few years and very happy with it. I haven't seen this problem until recently when I switched my scheduled transactions from no automatic entry with reminders, to automatic advanced entry with no reminders. Like Glenn, I have "run when the data file is opened" checked, and now I see this same problem that the created transactions don't show up in the register. I was restarting GnuCash to see the new entries in the register. Appreciate the tip that pressinghelps. I haven't been able to find any other resolution in my search so I though I'd just mention what I'm seeing here. ___ 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] Share Values recording
Do you simply want to track activity but are not concerned with individual share counts and prices? If that is the case, then a basic account of type Asset would do. You then make your entries as needed just like the Pen & Paper method. I'm sure there are plenty of resources online to demonstrate the basic Dr/Cr examples for the various events. (buying, selling, recording gain/loss, receipt of dividends, etc.) The Guide (and I think Help too) already covers simple investments. You only need to use accounts of type Stock if you really want *and need* (as Michael pointed out) to track cost-basis for tax purposes when determining gain/loss. If tax implications are not at play here, certainly a simple asset account would work. (you'll need income and possibly equity accounts here too depending on your needs, maybe even some expense accounts as well.) Regards, Adrien On 8/11/22 9:30 AM, Mahon Finbar wrote: Hello, I am trying to rationalise my shares (or things that have a moving value) holdings. I understand the basics of GNU, in that I have been a user for some time and have been able to record transactions, create reports to satisfy the taxman, etc., but I keep getting bits and pieces of information from the various places where my shares are registered, mostly about values and dividends and the like. I have a somewhat random selection of 'accounts' with information about my (relatively small number) of holdings (a word that is a bit strong for my situation) What I am aiming to do is get a simple account or accounts where I can just register what I paid, what dividends and other income stuff I may have had and items such as current value. Is there a simple source in the 'help' for creating that and what is it called and what does it contain?? If not where should I start?? Sorry to be a neophyte, but I am a bit frustrated. Finbar (located in Europe, but only really dealing in €) ___ 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] Share Values recording
Finbar, This is likely as specific as it gets or can get https://www.gnucash.org/docs/v4/C/gnucash-guide/chapter_invest.html. As others have mentioned the exact accounting treatment depends on the tax rules in your jurisdiction and likely business regulations if you are conducting investment as a business operation. From there you specify what information you need for: a) tax purposes; b) your management of your investments; c) reporting purposes if your investment can be classed as a business activity. This in turn defines what your account structure should be for investments. The examples in the guide will reflect fairly common practice in many jurisdictions but the devil is always in the local detail. For that you either need a local accountant/financial adviser you trust or you need to acquire the skills to research the legislation and regulation in your jurisdiction and turn that into accounting methodology. David Cousens On Thu, 2022-08-11 at 15:30 +0100, Mahon Finbar wrote: > Hello, > > I am trying to rationalise my shares (or things that have a moving > value) holdings. > > I understand the basics of GNU, in that I have been a user for some > time and have been able to record transactions, create reports to > satisfy the taxman, etc., but I keep getting bits and pieces of > information from the various places where my shares are registered, > mostly about values and dividends and the like. > > I have a somewhat random selection of 'accounts' with information about > my (relatively small number) of holdings (a word that is a bit strong > for my situation) > > What I am aiming to do is get a simple account or accounts where I can > just register what I paid, what dividends and other income stuff I may > have had and items such as current value. > > Is there a simple source in the 'help' for creating that and what is it > called and what does it contain?? If not where should I start?? > > Sorry to be a neophyte, but I am a bit frustrated. > > Finbar (located in Europe, but only really dealing in €) > > ___ > 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] Share Values recording
On 8/11/2022 4:27 PM, Adrien Monteleone wrote: Do you simply want to track activity but are not concerned with individual share counts and prices? If that is the case, then a basic account of type Asset would do. You then make your entries as needed just like the Pen & Paper method. . You only need to use accounts of type Stock if you really want *and need* (as Michael pointed out) to track cost-basis for tax purposes when determining gain/loss. Gnucash AUTOMATES the process. Even as recently as 4 decades ago, only the largest corporations had computers assisting their bookkeeping. All the rest of us were still using pen and ink on paper. Anything you can do with gnucash you could do in the old days of pen and ink on paper. As a matter of fact, if you turn on "journal mode" (what you are in when entering a split transaction) it is very much like the old pen and ink on paper days EXCEPT for being "autoposting" << the completed "journal" entry is posted to the "ledger" as opposed to the error prone manual process of the pen and ink on paper days >> That's why those of us who learned bookkeeping hack in those pen and ink on paper days have few problems using software like gnucash. 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.
[GNC] Share Values recording
This might be a TAX issue but financial reporting is very much a GnuCash issue and has nothing to do with tax advice. Different terms being used for the same thing in different jurisdictions complicate the discussion, and then the taxes actually vary. I've managed to move most of my spreadsheet tax fiddling back into Gnucash where a lot of it is useful. It tracks and reports Sales Tax (GST in Australia) and share Dividend income (Franked, Franking Credit, Unfranked), and a Contra account can easily report Distribution in the correct year. The capital gain issue is more about reporting taxable transactions than the actual tax payable. That doesn't seem that complicated. In Australia share (asset) capital gains are taxed at the same rate as income tax, unless they have been held for more than a year when only half of the capital gain (an account or split) is taxable. Capital losses are not an expense but they can be accumulated and used to offset gains. If capital gain is a liability I suppose losses are a negative liability but I'd take advice from someone with an accounting background on the COA structure. This isn't covered very well in the guide investment section. Sample report in https://www.sharesight.com/blog/capital-gains-tax-calculator-for-australian-investors/ (not software I use). Now tax payable calculations, that's way too complicated. Even the tax accountant's software is only an estimate. ___ 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] Scheduled transactions do not appear in the register until is pressed
I'd go with bug: It's supposed to refresh all of the registers, see https://github.com/Gnucash/gnucash/blob/41de4cefce621c214c0d6f6ff1c5ca05df8fd917/gnucash/gnome/dialog-sx-since-last-run.c#L1168 You may find in your trace file one or more error messages "suspend counter not zero" from gnc_gui_refresh_all on a session where the SLR ran. That would indicate that something else that's wrapping the SLR invocation has also blocked gui refreshes. If that message isn't there then there's something going wrong in gnc_gui_refresh_internal. Regards, John Ralls > On Aug 11, 2022, at 1:20 PM, Adrien Monteleone > wrote: > > I thought one was already opened. (but I admit I didn't search for it) > > If I recall correctly, it has to do with refreshing the register view. > > This seems to happen with registers that are left open at the last close and > which re-open before the Since Last Run dialog fires. > > Though hitting [Enter] works to refresh, so does closing and opening the > affected registers, as does View > Refresh. (CMD/CTRL+R) > > Other not so great options would be to close registers you have SX for each > time you close GnuCash; (you'll end up opening them after the SX fires) or > don't close GnuCash at all and just get in the habit of refreshing; (of > course, then you also have to get in the habit of manually firing Since Last > Run) or, go back to the previous SX settings which didn't cause this. > > As the function to refresh a register/report exists, I'm betting this falls > more under 'enhancement' for an auto-refresh case. > > Regards, > Adrien > > On 8/11/22 11:15 AM, Glenn Fowler wrote: >> I still consider this a bug and not a feature request since not seeing an >> up-to-date register could really throw things off. >> To the community and GnuCash team - should I open an issue in Bugzilla? >> On Thu, Aug 11, 2022 at 12:02 PM Tom Veik wrote: >>> Replying to an old thread I found with a search. >>> >>> Using GnuCash version 4.11 on Windows 11. I've been using GnuCash for a >>> few years and very happy with it. I haven't seen this problem until >>> recently when I switched my scheduled transactions from no automatic >>> entry with reminders, to automatic advanced entry with no reminders. >>> Like Glenn, I have "run when the data file is opened" checked, and now I >>> see this same problem that the created transactions don't show up in the >>> register. I was restarting GnuCash to see the new entries in the >>> register. Appreciate the tip that pressinghelps. >>> >>> I haven't been able to find any other resolution in my search so I >>> though I'd just mention what I'm seeing here. > > > ___ > 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] Tax Accounting for Trust Income Received in Following Fiscal Year
Hi flywire, A couple of comments before I get into the meat of my response: - What you're asking about here is somewhat specific to Australia, and the details may not be applicable to other jurisdictions. - I'm not an accountant, so I'm not sure how an accountant would respond to this. But it works for me! So with that said, here are accounts I use to track Australian trust distributions: [image: image.png] Here's an illustrative journal entry that represents the details from the AMIT statement for the VAS ETF attached to your email: [image: image.png] Here's a transaction on the date you become entitled to receive a distribution (for example - this is would be recorded on 30 June for the final VAS distribution for the year): [image: image.png] And here's a transaction representing the actual payment of the distribution (on the date the payment is made): [image: image.png] If anybody has a different way of modelling Australian trust distributions, I'd love to see other examples! Chris On Thu, 11 Aug 2022 at 23:10, flywire wrote: > It's tax time again and I'm wondering if I can improve on the process I > described in > https://lists.gnucash.org/pipermail/gnucash-user/2021-August/097424.html > > It works and keeps my accountant happy but it just doesn't seem to sit well > with double-entry accounting to just ignore a few accounts at tax time and > slip in a funny-money cheat sheet for ETF (Mutual Fund?) investments. I'd > welcome any suggestions for a better way of doing it. > > Attached is an ETF statement. The total of each of the 10 Tax codes in the > top section for all ETFs is reported in the attached guide on p4. > > The Cash distributions are on the bottom left and the Attribution is on the > bottom right don't match. I understand the issue is summarising different > tax treatments for Dividends, Franking credits, Realised capital gains, > Interest, and Foreign Income categories. I'd prefer to enter what is > relevant into GnuCash but I don't understand the accounting. I also > understand there are different ways of accounting for tax but any guidance > would be welcome. > > I don't want to get into the detail of setting up an investment portfolio > as explained in the guide and I can't see that it addresses this issue. I'd > be happy to revalue the few funds at the end of each tax year (with > guidance) for the balance sheet. > > This should feed into the financial statements for the trust which owns the > ETF units and distributes the proceeds each year. The Cash distribution has > been distributed with pro-rata funny-money reported. > > [image: VAS-annual-tax-statement-2018.png] > > > > ___ > 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] Scheduled transactions do not appear in the register until is pressed
Ok it looks like there are 2 open tickets already: https://bugs.gnucash.org/show_bug.cgi?id=794584 https://bugs.gnucash.org/show_bug.cgi?id=796948 It doesn't look like they are getting any traction... On Thu, Aug 11, 2022 at 9:05 PM John Ralls wrote: > I'd go with bug: It's supposed to refresh all of the registers, see > https://github.com/Gnucash/gnucash/blob/41de4cefce621c214c0d6f6ff1c5ca05df8fd917/gnucash/gnome/dialog-sx-since-last-run.c#L1168 > > You may find in your trace file one or more error messages "suspend > counter not zero" from gnc_gui_refresh_all on a session where the SLR ran. > That would indicate that something else that's wrapping the SLR invocation > has also blocked gui refreshes. If that message isn't there then there's > something going wrong in gnc_gui_refresh_internal. > > Regards, > John Ralls > > > > On Aug 11, 2022, at 1:20 PM, Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > > > > I thought one was already opened. (but I admit I didn't search for it) > > > > If I recall correctly, it has to do with refreshing the register view. > > > > This seems to happen with registers that are left open at the last close > and which re-open before the Since Last Run dialog fires. > > > > Though hitting [Enter] works to refresh, so does closing and opening the > affected registers, as does View > Refresh. (CMD/CTRL+R) > > > > Other not so great options would be to close registers you have SX for > each time you close GnuCash; (you'll end up opening them after the SX > fires) or don't close GnuCash at all and just get in the habit of > refreshing; (of course, then you also have to get in the habit of manually > firing Since Last Run) or, go back to the previous SX settings which didn't > cause this. > > > > As the function to refresh a register/report exists, I'm betting this > falls more under 'enhancement' for an auto-refresh case. > > > > Regards, > > Adrien > > > > On 8/11/22 11:15 AM, Glenn Fowler wrote: > >> I still consider this a bug and not a feature request since not seeing > an > >> up-to-date register could really throw things off. > >> To the community and GnuCash team - should I open an issue in Bugzilla? > >> On Thu, Aug 11, 2022 at 12:02 PM Tom Veik wrote: > >>> Replying to an old thread I found with a search. > >>> > >>> Using GnuCash version 4.11 on Windows 11. I've been using GnuCash for > a > >>> few years and very happy with it. I haven't seen this problem until > >>> recently when I switched my scheduled transactions from no automatic > >>> entry with reminders, to automatic advanced entry with no reminders. > >>> Like Glenn, I have "run when the data file is opened" checked, and now > I > >>> see this same problem that the created transactions don't show up in > the > >>> register. I was restarting GnuCash to see the new entries in the > >>> register. Appreciate the tip that pressinghelps. > >>> > >>> I haven't been able to find any other resolution in my search so I > >>> though I'd just mention what I'm seeing here. > > > > > > ___ > > 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. > ___ 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] Scheduled transactions do not appear in the register until is pressed
The last time this occurred would be the first run on the 10th. Here is the contents of the trace file with the earliest time on that date: * 07:53:46 WARN [gnc_spawn_process_async()] Could not spawn perl: Failed to execute child process (No such file or directory) * 07:53:46 ERROR <> gnc_process_get_fd: assertion 'proc' failed * 07:53:46 ERROR <> gnc_detach_process: assertion 'proc && proc->pid' failed Tom On 8/11/2022 8:05 PM, John Ralls wrote: I'd go with bug: It's supposed to refresh all of the registers, see https://github.com/Gnucash/gnucash/blob/41de4cefce621c214c0d6f6ff1c5ca05df8fd917/gnucash/gnome/dialog-sx-since-last-run.c#L1168 You may find in your trace file one or more error messages "suspend counter not zero" from gnc_gui_refresh_all on a session where the SLR ran. That would indicate that something else that's wrapping the SLR invocation has also blocked gui refreshes. If that message isn't there then there's something going wrong in gnc_gui_refresh_internal. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Tax Accounting for Trust Income Received in Following Fiscal Year
Thank you for the discussion. To clarify, these ETFs are index funds: https://www.vanguard.com.au/personal/invest-with-us/etf?portId=8205&tab=prices-and-distributions I don't see the point of entering the attribution values since they don't exist in the bank statement or tax return. A contra account seems to handle funny-money (ie unreal transactions) in reports. The link in my first post explains how I moved the last distribution into the correct tax year with a conta transaction. I'm more inclined to think the tax amounts are somehow contra transactions using the tax codes as descriptions. Investment bank account and tax details: Investment Acc Amount 02/08/2017 6836 73.00VAS.AX -499,028.00 02/08/2017Brokerage -10.00 Date CPU Ex-Date Payable 30/09/2017 100.88106602/10/201717/10/2017 6,896.23 31/12/2017 68.09890502/01/201817/01/2018 4,655.24 31/03/2018 66.52557903/04/201818/04/2018 4,547.69 30/06/2018 101.72935302/07/201817/07/2018 6,954.22 Tax Amount 13U 3,606.42 13Y 0.00 13C 22,870.71 13Q 7,069.35 13R 0.00 13A 0.00 13S 0.00 18A 1,568.43 18H 3,135.48 20E463.54 20F 0.00 20M463.54 20O 15.64 ___ 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] Tax Accounting for Trust Income Received in Following Fiscal Year
Re "the attribution values [...] don't exist in the [...] tax return": On the contrary, the attribution values from Part B are exactly what drives the values that end up at the various labels in the Australian tax return as detailed in Part A of the AMIT statement. I don't think you'll get away from entering these values in a balanced transaction somewhere if you want to use GnuCash to track the details required for your tax return; but if you aren't trying to do that then you're right that you won't need to enter them. I've added the tax return labels to the relevant accounts in the following chart of accounts: [image: image.png] The only tax label that doesn't appear directly here is 18A (Net capital gain), as that needs to be calculated after adding together capital gains of all sources, applying capital losses and any relevant discounts. Chris On Fri, 12 Aug 2022 at 16:26, flywire wrote: > Thank you for the discussion. To clarify, these ETFs are index funds: > https://www.vanguard.com.au/personal/invest-with-us/etf?portId=8205&tab=prices-and-distributions > I don't see the point of entering the attribution values since they don't > exist in the bank statement or tax return. > > A contra account seems to handle funny-money (ie unreal transactions) in > reports. The link in my first post explains how I moved the last > distribution into the correct tax year with a conta transaction. I'm more > inclined to think the tax amounts are somehow contra transactions using the > tax codes as descriptions. > > Investment bank account and tax details: > > Investment Acc Amount > 02/08/2017 6836 73.00VAS.AX -499,028.00 > 02/08/2017Brokerage -10.00 > > Date CPU Ex-Date Payable > 30/09/2017 100.88106602/10/201717/10/2017 6,896.23 > 31/12/2017 68.09890502/01/201817/01/2018 4,655.24 > 31/03/2018 66.52557903/04/201818/04/2018 4,547.69 > 30/06/2018 101.72935302/07/201817/07/2018 6,954.22 > > Tax Amount > 13U 3,606.42 > 13Y 0.00 > 13C 22,870.71 > 13Q 7,069.35 > 13R 0.00 > 13A 0.00 > 13S 0.00 > 18A 1,568.43 > 18H 3,135.48 > 20E463.54 > 20F 0.00 > 20M463.54 > 20O 15.64 > ___ 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.
