Re: [GNC] Tax report options
https://lists.gnucash.org/pipermail/gnucash-user/2023-May/107018.html flywire wrote: > It is a spreadsheet process to add share/franking credits to etf/franking > credits (Distribution:13Q) and similar for capital gains > (Distribution:18H:18A) since the components are the same tax item. Any > thoughts of how I could sum them in reports from different account trees? > lol In the heat of the moment preparing tax I'd never thought of just transferring the total to the main account for that item. https://lists.gnucash.org/pipermail/gnucash-user/2023-May/107020.html flywire wrote: > ...there are 13 annual returns > To be clear, the items on the return map to different tax codes, eg franking credits is 13Q on a personal return and 8D on a trust return. I'd expect a table would need to be maintained for each return type. Australian codes hardly change over time which likely means there would be no active maintenance. Is it as simple as just using a unique tax code as account code and then reporting by account code? (Assume one return type.) ___ 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 report options (flywire)
On Wed, May 17, 2023 at 9:00 AM wrote: > > -- Forwarded message -- > From: flywire > To: Gnucash Users > Cc: > Bcc: > Date: Wed, 17 May 2023 17:17:45 +1000 > Subject: Re: [GNC] Tax report options > https://lists.gnucash.org/pipermail/gnucash-user/2023-May/107018.html > flywire wrote: > > > It is a spreadsheet process to add share/franking credits to etf/franking > > credits (Distribution:13Q) and similar for capital gains > > (Distribution:18H:18A) since the components are the same tax item. Any > > thoughts of how I could sum them in reports from different account trees? > > > > lol In the heat of the moment preparing tax I'd never thought of just > transferring the total to the main account for that item. > > https://lists.gnucash.org/pipermail/gnucash-user/2023-May/107020.html > flywire wrote: > > > ...there are 13 annual returns > > > > To be clear, the items on the return map to different tax codes, eg > franking credits is 13Q on a personal return and 8D on a trust return. I'd > expect a table would need to be maintained for each return type. Australian > codes hardly change over time which likely means there would be no active > maintenance. > > Is it as simple as just using a unique tax code as account code and then > reporting by account code? (Assume one return type.) > > ___ > > Some questions have been asked about Tax Report Options in the past couple of weeks. I have been away and not able to respond or make comments. Let me make these points, which may not necessarily apply to this thread, but to others (sorry): - The Tax Report Options and associated US Income Tax Report are only intended to be used for US Income Taxes. - Some time ago, someone in Germany used the US version and made adjustments for use in Germany; I'm not familiar with that and don't know if it works and is being maintained. - Initially it was intended primarily to generate a file that could be uploaded to Income Tax Preparation software (and a report was sort of secondary) and so a key element of the design was the use of TXF codes that the Tax software could understand; the specification for those codes was abandoned some time ago so the ability to expand the system is not there unless we invented our own new TXF code (ugh!). - That is why there is nothing for Form 1116. - If someone wanted to do what was done for Germany for another jurisdiction, they would have to deal with this TXF issue; I certainly don't recommend trying it. - The US version could/should be re-written to not depend on TXF codes but this would not be trivial. - One can use the 'No Tax code' tag to include accounts on the US Income Tax Report, just not sorted by Form/Schedule; you could use the account name and/or description for that purpose for those accounts to give you totals (example: for Form 1116). - The system assumes that each 'book' (i.e., gnucash file) is for one reporting entity (individual, partnership, corporation, etc.) and that one file is not used to track the accounts of more than one tax reporting entity. - You can certainly use your account structure design and other available reports to get your tax information without using this system; in fact, if you use this system, you have to carefully design your account structure and do careful data entry to get the report to be useful. Alex ___ 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] Finance::Quote on Mac M1 OSX Ventura
While testing an install of Finance::Quote on a somewhat fresh out of the box MacBook Pro running Ventura 13.3.1, some issues with the bundled Perl were discovered. At first I thought it may have been prerequisites not properly defined for DateTime::Locale, but a deeper analysis showed that the bundled Perl has modules such as Test2::Plugin::Warnings with dependencies on modules that are *not* part of the OS packaged Perl bundle. See https://github.com/houseabsolute/DateTime-Locale/issues/36 for the thread between myself and the module's maintainer. Bruce S. ___ 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] Transaction Report - Split Transactions
Hello, I have a Gnucash file, which I use to track expenses for a jointly owned property. Under Assets, I have two accounts. One for myself and one for the other owner. Under Expenses, I have the Property, and under that I have sub-accounts for the various types of expenses (eg. Taxes, Service Charges, Maintenance, Bills etc). A number of the expenses transactions have split entries. Either because something was paid by both owners, or because I keep more detailed records. I am trying to come up with a Transaction Report that will summarise: (a) Total Expenses (b) Breakdown of Expenses per sub-Account (i.e. type of expense) (c) How much was paid by each owner, of each type of expense The problem I am facing and have not managed to solve no matter what I have tried, is that for the Split Transactions, when Sorting with “Other Account”, I just get a groups for “Split Transaction”, and thus lose the transparency of the Sub-Account or if I structure the Transaction report differently, I lose the transparency/sum for the account from which the payment was made. Any help would be welcome. Thank you! ___ 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] Transaction Report - Split Transactions
Unfortunately that is a limitation on how the splits work and I have run into this myself. When you look at it from the expense accounts, every transaction has a 3 way split because of the 2 owner accounts, so unfortunately there is no way to group by owner account as the secondary sort When you look at it the other way, selecting Owner A and B as the accounts to report on, every transaction is still split because of the other owner account, so there is no way to group by owner as primary then expense as secondary. You can still get the correct total for each owner, but not the subtotal by expense account. It could be an interesting thing to try to change. When showing a split on the credit side, and the multiple splits are ONLY on the credit side, then we should be able to show the single debit side account name as the other account instead of showing "split transaction"; same for the other way around, When showing a split on the debit side, and the multiple splits are ONLY on the debit side, then we should be able to show the single credit side account name as other account instead of showing "split transaction"; I might look at changing this as it would help as well because I have several reports where I have ran into this problem The alternative is to only use simple transactions, which essentially means splitting your transactions into 2. So instead of Electricity 100 Owner A 60 Owner B 40 you end up with 2 transactions Electricity 60 Owner A 60 Electricity 40 Owner B 40 But it's not really very nice I have also an experimental report using tags but that would require changing your setup as well. It would still require splitting the expenses however, but both splits could be kept in the same transactions. Only advantage is you could get rid of the owner accounts UNLESS they are actual escrow accounts (instead of report placeholders while the actual payment is done from a single asset account). Checking account 100 Electricity60 #OwnerA in the split memo Electricity40 #OwnerB in the split memo Here it is if you want to give that a try: https://github.com/dawansv/gnucash-transaction-tags But ultimately allowing the single matching debit/credit side to show instead of "split transactions" would be a more useful solution. I'll look at whether I can get that done but it might take a little while. On Wed, May 17, 2023 at 3:22 PM John Dimitriadis wrote: > Hello, > > I have a Gnucash file, which I use to track expenses for a jointly owned > property. > > Under Assets, I have two accounts. One for myself and one for the other > owner. > > Under Expenses, I have the Property, and under that I have sub-accounts > for the various types of expenses (eg. Taxes, Service Charges, Maintenance, > Bills etc). > > A number of the expenses transactions have split entries. Either because > something was paid by both owners, or because I keep more detailed records. > > I am trying to come up with a Transaction Report that will summarise: > (a) Total Expenses > (b) Breakdown of Expenses per sub-Account (i.e. type of expense) > (c) How much was paid by each owner, of each type of expense > > The problem I am facing and have not managed to solve no matter what I > have tried, is that for the Split Transactions, when Sorting with “Other > Account”, I just get a groups for “Split Transaction”, and thus lose the > transparency of the Sub-Account or if I structure the Transaction report > differently, I lose the transparency/sum for the account from which the > payment was made. > > Any help would be welcome. > > Thank you! > ___ > 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] Transaction Report - Split Transactions
The last one should show this for proper credit/debi sides Checking account 100 Electricity 60 #OwnerA in the split memo Electricity 40 #OwnerB in the split memo On Wed, May 17, 2023 at 4:26 PM Vincent Dawans wrote: > Unfortunately that is a limitation on how the splits work and I have run > into this myself. > > When you look at it from the expense accounts, every transaction has a 3 > way split because of the 2 owner accounts, so unfortunately there is no way > to group by owner account as the secondary sort > When you look at it the other way, selecting Owner A and B as the accounts > to report on, every transaction is still split because of the other owner > account, so there is no way to group by owner as primary then expense as > secondary. You can still get the correct total for each owner, but not the > subtotal by expense account. > > It could be an interesting thing to try to change. When showing a split on > the credit side, and the multiple splits are ONLY on the credit side, then > we should be able to show the single debit side account name as the other > account instead of showing "split transaction"; same for the other way > around, When showing a split on the debit side, and the multiple splits are > ONLY on the debit side, then we should be able to show the single credit > side account name as other account instead of showing "split transaction"; > > I might look at changing this as it would help as well because I have > several reports where I have ran into this problem > > The alternative is to only use simple transactions, which essentially > means splitting your transactions into 2. So instead of > > Electricity 100 > Owner A 60 > Owner B 40 > > you end up with 2 transactions > > Electricity 60 > Owner A 60 > > Electricity 40 > Owner B 40 > > But it's not really very nice > > I have also an experimental report using tags but that would require > changing your setup as well. It would still require splitting the expenses > however, but both splits could be kept in the same transactions. Only > advantage is you could get rid of the owner accounts UNLESS they are actual > escrow accounts (instead of report placeholders while the actual payment is > done from a single asset account). > Checking account 100 > Electricity60 #OwnerA in the split memo > Electricity40 #OwnerB in the split memo > > Here it is if you want to give that a try: > https://github.com/dawansv/gnucash-transaction-tags > > But ultimately allowing the single matching debit/credit side to show > instead of "split transactions" would be a more useful solution. I'll look > at whether I can get that done but it might take a little while. > > On Wed, May 17, 2023 at 3:22 PM John Dimitriadis > wrote: > >> Hello, >> >> I have a Gnucash file, which I use to track expenses for a jointly owned >> property. >> >> Under Assets, I have two accounts. One for myself and one for the other >> owner. >> >> Under Expenses, I have the Property, and under that I have sub-accounts >> for the various types of expenses (eg. Taxes, Service Charges, Maintenance, >> Bills etc). >> >> A number of the expenses transactions have split entries. Either because >> something was paid by both owners, or because I keep more detailed records. >> >> I am trying to come up with a Transaction Report that will summarise: >> (a) Total Expenses >> (b) Breakdown of Expenses per sub-Account (i.e. type of expense) >> (c) How much was paid by each owner, of each type of expense >> >> The problem I am facing and have not managed to solve no matter what I >> have tried, is that for the Split Transactions, when Sorting with “Other >> Account”, I just get a groups for “Split Transaction”, and thus lose the >> transparency of the Sub-Account or if I structure the Transaction report >> differently, I lose the transparency/sum for the account from which the >> payment was made. >> >> Any help would be welcome. >> >> Thank you! >> ___ >> 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] Transaction Report - Split Transactions
Look, we can tell you how to use gnucash to do double-entry bookkeeping. But it is beyond our remit to tell you how to set up books for this or that type of entity. For example, I lack the "qualifications" to advise you the way a CPA could. But I do know something about it, so I will give you some hints as to what you need to learn in order to DIY. You are describing an entity that is a "partnership". So you should want to set up the books for this property that way. Notice that I am talking about the entity, not your personal books, because it will be much easier that way. Obtain a text (paper or on-line) along the lines of "accounting for partnerships 101". If you have a set of books for this entity, you should NOT have to split each and every transaction! Depending on the frequency you want to do this, every month, or every quarter, or annually you can allocate each partner's share (of income, of expenses, etc.). If you have a separate set of books for the entity, on your books your share of the property would be an asset (like other forms of investments) The reason I am unwilling to give advice in more detail (the way the accountant would) is that exactly how done depends on lots of things. For example, is this a rental property? Do either or both of you live in it? Etc. Michael D Novack On 5/16/2023 4:24 AM, John Dimitriadis wrote: Hello, I have a Gnucash file, which I use to track expenses for a jointly owned property. Under Assets, I have two accounts. One for myself and one for the other owner. Under Expenses, I have the Property, and under that I have sub-accounts for the various types of expenses (eg. Taxes, Service Charges, Maintenance, Bills etc). A number of the expenses transactions have split entries. Either because something was paid by both owners, or because I keep more detailed records. I am trying to come up with a Transaction Report that will summarise: (a) Total Expenses (b) Breakdown of Expenses per sub-Account (i.e. type of expense) (c) How much was paid by each owner, of each type of expense The problem I am facing and have not managed to solve no matter what I have tried, is that for the Split Transactions, when Sorting with “Other Account”, I just get a groups for “Split Transaction”, and thus lose the transparency of the Sub-Account or if I structure the Transaction report differently, I lose the transparency/sum for the account from which the payment was made. Any help would be welcome. Thank you! ___ 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.
[GNC] add additional accounts after initial setup
trying to add a few more accounts after using the wizard, and starting to enter transactions, I realized I missed a few..tried the help file, I must be missing how do I add an new account? ___ 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] add additional accounts after initial setup
hi Jamie the following link will give you the guide. it is quite simple and straight forward https://www.gnucash.org/docs/v4/C/gnucash-help/acct-create.html Saludos Cordiales Murugan From: gnucash-user on behalf of Jamie Tolbert Sent: Wednesday, May 17, 2023 7:54 PM To: gnucash-user@gnucash.org Subject: [GNC] add additional accounts after initial setup trying to add a few more accounts after using the wizard, and starting to enter transactions, I realized I missed a few..tried the help file, I must be missing how do I add an new account? ___ 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] add additional accounts after initial setup
Jamie In the Accounts tab if you right click there will be a new account item in the popup menu (also edit an existing account) which starts the account edit dialog with default properties. The parent account property determines where it appears in your account tree. The account type should generally match the type of the parent account with a few exceptions for specialized sub-type accounts mainly associated with the business features. David Cousens On Wed, 2023-05-17 at 23:54 +, Jamie Tolbert wrote: > trying to add a few more accounts after using the wizard, and starting > to enter transactions, I realized I missed a few..tried the help > file, I must be missing how do I add an new account? > ___ > 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] add additional accounts after initial setup
thanks everyone -- Original Message -- From "Murugan Muruganandam" To "gnucash-user@gnucash.org" ; "Jamie Tolbert" Date 5/17/2023 8:12:56 PM Subject Re: [GNC] add additional accounts after initial setup hi Jamie the following link will give you the guide. it is quite simple and straight forward https://www.gnucash.org/docs/v4/C/gnucash-help/acct-create.html Saludos Cordiales Murugan From: gnucash-user on behalf of Jamie Tolbert Sent: Wednesday, May 17, 2023 7:54 PM To:gnucash-user@gnucash.org Subject: [GNC] add additional accounts after initial setup trying to add a few more accounts after using the wizard, and starting to enter transactions, I realized I missed a few..tried the help file, I must be missing how do I add an new account? ___ 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] [GNC-dev] Finance::Quote on Mac M1 OSX Ventura
> On May 17, 2023, at 15:31, Bruce Schuck wrote: > > While testing an install of Finance::Quote on a somewhat fresh out of the box > MacBook Pro running Ventura 13.3.1, some issues with the bundled Perl were > discovered. > > At first I thought it may have been prerequisites not properly defined for > DateTime::Locale, but a deeper analysis showed that the bundled Perl has > modules such as Test2::Plugin::Warnings with dependencies on modules that are > *not* part of the OS packaged Perl bundle. > > See https://github.com/houseabsolute/DateTime-Locale/issues/36 for the thread > between myself and the module's maintainer. Bruce, That's interesting, but running your test from the end of that GitHub issue I get: ``` $ Hector:/Users/john> perl -MTest2::Plugin::NoWarnings -e 'print "$Test2::Plugin::NoWarnings::VERSION\n"' 0.09 $ Hector:/Users/john> perl -MTest2 -e 'print "$Test2::VERSION\n"' 1.302193 ``` DateTime::Locale also installs without error including passing all of its tests. Mind, I've had F::Q installed on it for a while. I'm running the current 13.4 developer beta. 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] [GNC-dev] Finance::Quote on Mac M1 OSX Ventura
On 5/17/23 7:02 PM, John Ralls wrote: That's interesting, but running your test from the end of that GitHub issue I get: ``` $ Hector:/Users/john> perl -MTest2::Plugin::NoWarnings -e 'print "$Test2::Plugin::NoWarnings::VERSION\n"' 0.09 $ Hector:/Users/john> perl -MTest2 -e 'print "$Test2::VERSION\n"' 1.302193 ``` DateTime::Locale also installs without error including passing all of its tests. Mind, I've had F::Q installed on it for a while. I'm running the current 13.4 developer beta. On the virgin OS out of the box, Test2 module is in the included Perl but its version is 1.302162 (at least on 13.3.1). But if you look at the file /System/Library/Perl/Extras/5.30/Test2/Plugin/NoWarnings.pm, line 9 is use Test2 1.302167; One would think that if the OS supplied bundle has a Perl module that requires at minimum version of another module, the required module would be that version or later. Not the case. The key here is until doing this testing ** no other additional perl modules were installed **. Either 13.4 has more recent modules in the OS supplied Perl, or you updated Test2 at some point in the past. I probably should have add the output of perl -MTest2 -e 'print "$Test2::VERSION\n"' in my comment, but before I installed *any* additional modules, it was 1.302162 as noted above. I didn't want remove the OS supplied Test2::Plugin::NoWarnings, but I would bet reinstalling it would trigger the correct dependency of Test2 also getting installed. The 0.09 version already installed/included is the most current release. Bruce S. ___ 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.
