Re: [GNC] Profit & Retained Earning don't match
Derek, Thanks for raising those legitimate points. I think a flag or trigger to reselect accounts would be helpful. I would note that, to my way of thinking, when I call up a saved report, I *am* running it from scratch, although I understand your perspective. From my corner, when I call up a custom report, I'm doing the exact same steps as when I run a system report "from scratch." I open the reports menu, and I ask to run my report. In one case, it's a new report from scratch; the other is not. That's confusing to me. David Original Message From: Derek Atkins Sent: Fri Feb 25 21:07:49 EST 2022 To: Stan Brown Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Profit & Retained Earning don't match HI, On Fri, February 25, 2022 7:07 pm, Stan Brown wrote: > On 2022-02-25 15:09, D. wrote: >> >> My recollection was that standard reports based on a class of accounts >> (assets, liabilities) will recompile the account list each time. >> >> It would seem useful to extend this functionality to saved reports as >> well... > > That's what I was trying to suggest, but you stated it much more clearly! ANY report you re-run from scratch will start with the current set of accounts. Changing the list of accounts on a Saved Report, however, could have negative consequences, especially if the user explicitly set the set of accounts. Imagine if you explicitly wanted a Cash Flow report with all but one Asset account, saved it, and then when you re-ran the report that account got added in! That would change the report results. Arguably there *could* be a flag for "using the default" which would cause the saved report to use the current default (which may be different than the default at the time the report was saved). I'm not sure how we would encode that, and it certainly would not be a backwards-compatible change. > 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 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] Profit & Retained Earning don't match
HI, On Fri, February 25, 2022 7:07 pm, Stan Brown wrote: > On 2022-02-25 15:09, D. wrote: >> >> My recollection was that standard reports based on a class of accounts >> (assets, liabilities) will recompile the account list each time. >> >> It would seem useful to extend this functionality to saved reports as >> well... > > That's what I was trying to suggest, but you stated it much more clearly! ANY report you re-run from scratch will start with the current set of accounts. Changing the list of accounts on a Saved Report, however, could have negative consequences, especially if the user explicitly set the set of accounts. Imagine if you explicitly wanted a Cash Flow report with all but one Asset account, saved it, and then when you re-ran the report that account got added in! That would change the report results. Arguably there *could* be a flag for "using the default" which would cause the saved report to use the current default (which may be different than the default at the time the report was saved). I'm not sure how we would encode that, and it certainly would not be a backwards-compatible change. > 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 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] Report question
On Fri, Feb 25, 2022 at 9:27 AM Paul Kinzelman wrote: > Do you mean Account Report? But when I go to File | Export, it asks > me which accounts again, it doesn't export the actual report. > > When I export the transactions I want, it exports both sides of the > transaction, so the column sum is always zero whereas I want the > sum of the transactions. > > In other words, each transaction takes two lines, the line I want > (the expense of what I bought), and the next line which is the > account that paid it (like a charge card). > > How do I get rid of the double-lines on the export? > We're apparently not seeing the same thing you are. Here's a way to get an Account Report for your credit card transactions. (This is using GnuCash 4.9.) 1) Open the account Accounts tab --> open Liabilities : Credit Cards : BigBankTwo VISA (yours will differ) 2) Use Filter By to select the transactions you want [while the register is active] View --> Filter By (choose parameters such as date, number of days, reconciled, etc.) 3) Open Account Report [while the filtered register is active] Reports --> Account Report 4) Adjust the options on the report Edit --> Report Options (here you can adjust specific columns, single or double amount columns, totals or running total, style, report name, etc.) 5) Export the report You can copy what's on your screen and paste it into a word processor or spreadsheet OR File --> Export --> Export Report (give it a name -- it will save an .html file you can open with a web browser or a spreadsheet program) > - > 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.
[GNC] Fwd: Setting up Government Bond
forwarding to the list since this apparently just went to me. -- Forwarded message - From: Suseno Dermawan Date: Fri, Feb 25, 2022 at 7:53 AM Subject: Re: [GNC] Setting up Government Bond To: Tommy Trussell ok it definitely happens again, in either XML or sqlite. not sure what is wrong, perhaps my sequences of input. not sure what's going on but i'll keep the fixed file and worked on from there. :D On Fri, Feb 25, 2022 at 8:18 AM Suseno Dermawan wrote: > Umm, no. > This is my first time trying sqlite, cause previously i found the loading > time of xml is quite long. > And this is a new records, that's why I re create all the accounts n > opening balance. > > I can try to play around with it again to see if it happens again > > On Fri, 25 Feb 2022, 08:09 Tommy Trussell, > wrote: > >> On Thu, Feb 24, 2022 at 5:32 AM Suseno Dermawan >> wrote: >> >>> Just a quick Update. >>> after i saved to XML, now i am able to change the price to 30.000.000 and >>> shares of 1. or changes the shares to 30.000.000 share and price to 1. >>> >>> weird tho. >>> >> >> It sounds like you may have encountered a bug of some sort. Were you >> using SQLite format before? >> >> >> >>> - >>> 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] Profit & Retained Earning don't match
On 2022-02-25 15:09, D. wrote: > > My recollection was that standard reports based on a class of accounts > (assets, liabilities) will recompile the account list each time. > > It would seem useful to extend this functionality to saved reports as > well... That's what I was trying to suggest, but you stated it much more clearly! -- Stan Brown Tehachapi, CA, USA https://BrownMath.com ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user 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 closes when I edit a value
Yes you used the correct channel, but please remember to reply to the list in your replies. On February 25, 2022 6:08:28 PM Peter wrote: Hi, Dan, Thanks for a prompt response. I was using 4.2. I have since noticed that 4.9 is now available so have installed 4.9. I just now tried a couple of my usual " duplicate then amend value" routines and the system did not shut down. So perhaps I'm OK. Shall we call this one resolved? I'll raise it again if it happens again. BTW, did I use the correct channel to ask my question? Peter Peter and Judy Ridgewell 27 Tobruk Street, Lutwyche 4030 Australia +61 4 1338 8598, +61 4 6985 3831 On 26/02/2022 7:15 am, Dan Black wrote: What operating system and version of Gnucash are you using? On February 25, 2022 4:12:06 PM Peter wrote: Hi, Don't know that I'm in the right place for this one but couldn't find where else to go. Lately, when I edit a value field, GNUCash closes. Often, when entering a new transaction similar to a previous one, I just duplicate the earlier one and edit the value (eg another payment on my credit card at the same shop). (The auto-fill feature based on a previous transaction doesn't quite work for me as well as a duplication for some transactions.) When I go to edit the value, GNUCash closes. This happens regularly. I'm pretty switched on to it now so that I usually save before duplicating. Of interest is that my GNU file is 1.5 mb. Should that be a problem? Peter ___ 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] Profit & Retained Earning don't match
Derek, Some of the standard reports automatically update the account selection when they are invoked. See, for example, the Advanced Portfolio report, which automatically selects new commodity accounts each time it is run. My recollection was that standard reports based on a class of accounts (assets, liabilities) will recompile the account list each time. It would seem useful to extend this functionality to saved reports as well... David T. Original Message From: Derek Atkins Sent: Fri Feb 25 16:56:36 EST 2022 To: Stan Brown Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Profit & Retained Earning don't match HI, On Fri, February 25, 2022 4:49 pm, Stan Brown wrote: > > On 2022-02-25 13:14, Derek Atkins wrote: >> For example, if you ran the report, then added an account, that new >> account would not be included by default in the report if you refresh >> it. >> You need to manually add the new account into the report. >> >> This also applies to saved reports. > > Wow -- I did not know this, but it explains why my balance sheet and > income statement sometimes miss accounts. (With the income statement in > particular, I run it only at the end of the year, so any accounts could > have been added almost a whole year ago, and I wouldn't remember when I > added them.) > > I select accounts for my saved reports in what seems like a sensible > way: all Income And Expense accounts for the income statement, and all > Assets, Liabilities, and Equities for the balance sheet. > > I don't know how hard this would be to do, but it would be nice if GC > would keep track in a saved report of how accounts were selected. If the > selection was by a hierarchy rather than individual accounts, GC could > then automatically include all accounts within that hierarchy when > running the saved report. Yeah, sorry -- that's not how it works. It honestly doesn't know anything about "accounts" per se, let along hierachies. It just knows "Object GUIDs". The good news is that it's only a few clicks to get "all accounts" added. But yeah, if you save a report, or have a report "open", it wont learn about new accounts. This has been the case since, oh... 2003? 2005? Something like that. > 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 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] Profit & Retained Earning don't match
I can't check right now but I think there is an enhancement request to show in a printable form all the settings for a given report. On Fri, Feb 25, 2022, 3:57 PM Derek Atkins wrote: > HI, > > On Fri, February 25, 2022 4:49 pm, Stan Brown wrote: > > > > On 2022-02-25 13:14, Derek Atkins wrote: > >> For example, if you ran the report, then added an account, that new > >> account would not be included by default in the report if you refresh > >> it. > >> You need to manually add the new account into the report. > >> > >> This also applies to saved reports. > > > > Wow -- I did not know this, but it explains why my balance sheet and > > income statement sometimes miss accounts. (With the income statement in > > particular, I run it only at the end of the year, so any accounts could > > have been added almost a whole year ago, and I wouldn't remember when I > > added them.) > > > > I select accounts for my saved reports in what seems like a sensible > > way: all Income And Expense accounts for the income statement, and all > > Assets, Liabilities, and Equities for the balance sheet. > > > > I don't know how hard this would be to do, but it would be nice if GC > > would keep track in a saved report of how accounts were selected. If the > > selection was by a hierarchy rather than individual accounts, GC could > > then automatically include all accounts within that hierarchy when > > running the saved report. > > Yeah, sorry -- that's not how it works. It honestly doesn't know anything > about "accounts" per se, let along hierachies. It just knows "Object > GUIDs". > > The good news is that it's only a few clicks to get "all accounts" added. > > But yeah, if you save a report, or have a report "open", it wont learn > about new accounts. > > This has been the case since, oh... 2003? 2005? Something like that. > > > 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 > 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] Profit & Retained Earning don't match
HI, On Fri, February 25, 2022 4:49 pm, Stan Brown wrote: > > On 2022-02-25 13:14, Derek Atkins wrote: >> For example, if you ran the report, then added an account, that new >> account would not be included by default in the report if you refresh >> it. >> You need to manually add the new account into the report. >> >> This also applies to saved reports. > > Wow -- I did not know this, but it explains why my balance sheet and > income statement sometimes miss accounts. (With the income statement in > particular, I run it only at the end of the year, so any accounts could > have been added almost a whole year ago, and I wouldn't remember when I > added them.) > > I select accounts for my saved reports in what seems like a sensible > way: all Income And Expense accounts for the income statement, and all > Assets, Liabilities, and Equities for the balance sheet. > > I don't know how hard this would be to do, but it would be nice if GC > would keep track in a saved report of how accounts were selected. If the > selection was by a hierarchy rather than individual accounts, GC could > then automatically include all accounts within that hierarchy when > running the saved report. Yeah, sorry -- that's not how it works. It honestly doesn't know anything about "accounts" per se, let along hierachies. It just knows "Object GUIDs". The good news is that it's only a few clicks to get "all accounts" added. But yeah, if you save a report, or have a report "open", it wont learn about new accounts. This has been the case since, oh... 2003? 2005? Something like that. > 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 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] Profit & Retained Earning don't match
On 2022-02-25 13:14, Derek Atkins wrote: > For example, if you ran the report, then added an account, that new > account would not be included by default in the report if you refresh it. > You need to manually add the new account into the report. > > This also applies to saved reports. Wow -- I did not know this, but it explains why my balance sheet and income statement sometimes miss accounts. (With the income statement in particular, I run it only at the end of the year, so any accounts could have been added almost a whole year ago, and I wouldn't remember when I added them.) I select accounts for my saved reports in what seems like a sensible way: all Income And Expense accounts for the income statement, and all Assets, Liabilities, and Equities for the balance sheet. I don't know how hard this would be to do, but it would be nice if GC would keep track in a saved report of how accounts were selected. If the selection was by a hierarchy rather than individual accounts, GC could then automatically include all accounts within that hierarchy when running the saved report. -- Stan Brown Tehachapi, CA, USA https://BrownMath.com ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user 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 closes when I edit a value
What operating system and version of Gnucash are you using? On February 25, 2022 4:12:06 PM Peter wrote: Hi, Don't know that I'm in the right place for this one but couldn't find where else to go. Lately, when I edit a value field, GNUCash closes. Often, when entering a new transaction similar to a previous one, I just duplicate the earlier one and edit the value (eg another payment on my credit card at the same shop). (The auto-fill feature based on a previous transaction doesn't quite work for me as well as a duplication for some transactions.) When I go to edit the value, GNUCash closes. This happens regularly. I'm pretty switched on to it now so that I usually save before duplicating. Of interest is that my GNU file is 1.5 mb. Should that be a problem? Peter ___ 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] Profit & Retained Earning don't match
Is it possible that you are missing an account in one of the reports? For example, if you ran the report, then added an account, that new account would not be included by default in the report if you refresh it. You need to manually add the new account into the report. This also applies to saved reports. -derek On Tue, February 22, 2022 5:16 pm, John Wilson wrote: > When I did our church's books for January 2022 the profit from the > Profit & Loss account and retained earnings on the balance sheet do not > match by $539.95 > > The Net income in the P a/c is $193,748.66 and on the BS it has shrunk > to $193,208.71. > > I cannot see an error in the figures and $539.95 does not occur in any > transactions. > > I wonder if I have set up the new set of books wrongly. > > The attached screenshots are of my tree of accounts starting at 11-37-37 > > A fresh set of eyes would be appreciated > > John > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > 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. > -- 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 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] GNUCash closes when I edit a value
Hi, Don't know that I'm in the right place for this one but couldn't find where else to go. Lately, when I edit a value field, GNUCash closes. Often, when entering a new transaction similar to a previous one, I just duplicate the earlier one and edit the value (eg another payment on my credit card at the same shop). (The auto-fill feature based on a previous transaction doesn't quite work for me as well as a duplication for some transactions.) When I go to edit the value, GNUCash closes. This happens regularly. I'm pretty switched on to it now so that I usually save before duplicating. Of interest is that my GNU file is 1.5 mb. Should that be a problem? Peter ___ 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] Automatic sales tax
A further complication in calculating sales tax is that there is no uniform law regarding nexus. Whereas most states consider the location of the seller to be the nexus, there are others where the nexus is that of the buyer! In Florida, a seller in Okeechobee shipping an alligator skin wallet to a buyer in Pensacola is supposed to charge sales tax at the rate of the buyer's location 600 miles away. And, if the purchase was made from an online store whose owner was in Baton Rouge, same thing. Sales tax is one reason there is a difference between point-of-sale systems and accounting packages. -Original Message- From: gnucash-user On Behalf Of Adrien Monteleone Sent: Monday, February 21, 2022 12:45 PM To: gnucash-u...@lists.gnucash.org Subject: Re: [GNC] Automatic sales tax Yeah, without a receipt in hand (or electronic) showing the breakout, no software can assume or guess reliably. That is just insane. In my state, you can have one location in one jurisdiction depending on what side of the street it is on, and the two properties to the left and right can each be in other separate districts. And then, you have to take into account purchasing location vs. delivery, and then the type of item or service. That is impossible for any software, paid for or not, to 'guess' based merely on a description containing a business name. Even if you pre-specified what each business you buy from charges, you might end up getting it wrong. (my grocery receipt for example charges one rate for food 'for home consumption' and another for everything else, and those subtotals of course vary from purchase to purchase) And that doesn't even scratch 'tax holidays'! (or that local rates can change 4 times a year!) Regards, Adrien On 2/21/22 9:00 AM, Michael or Penny Novack wrote: > On 2/20/2022 7:58 PM, David Carlson wrote: >> Here in Illinois it varies by county, city, merchandise category, >> service category, seller category and sometimes by such arcane >> variables as library district (well, that last one may be a slight >> exaggeration). > > And not only is it that complex, but the DATA (what IS the > jurisdiction that applies) is typically not available. Almost always > the information by the vendor, just the postal address. > > For example, while my town (township) does indeed have a PO with zip > code 01338 that post office delivers no mail (just for PO boxes inside > that post office). On the other hand, four different post office with > zip codes 01330, 01339, 01340, and 01370 do deliver mail to addresses > located in my town. So EVERY street address in my town has some other > town in the address << well one of those isn't a "town" but a village > on the boundary of two towns (townships) >> > > There was a period during which when writing a letter to my > Congressman I had to make it very clear, "Yes, I AM a constituent > living in your district in spite of appearances" (the "town" on my > address was outside his district) > > And I can think of a merchandise category/seller category tax > difference in my state. Buy a pair of gloves (clothing, not taxed) in > a clothing store/department store vs buy the SAME pair of gloves > (protective gear, > taxed) in a hardware store. > > BTW --- usually responsibility for figuring sales tax is in the POS > system, not the accounting package being fed by POS (POS would also > interact with the Inventory system). The accounting package is just > one part of an "integrated business system". ___ 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] reconcile problem?
Well, I have multiple multiple cards with the same bank, & it's no trouble to detect the payments during import & deal with them in an appropriate manner. I n my case, I delete them from the import. That makes the reconciliation balance to the amount that was due. Then, when I import payments from by checking account, I allocate the payments to the correct card account. GNUcash is reasonable accounting software. It just doesn't do thinking for each individual's particular situation. On 2022-02-25 08:20, David Carlson wrote: That came up in another thread a couple of weeks ago. As far as I know, the only solution is to be very careful in the matching step of the import. You can help yourself when making the payments to be sure they have different dates or amounts, or even paying out of different checking accounts. On Fri, Feb 25, 2022 at 8:11 AM scum buster wrote: Sidebar question --- do any of you have more than one credit card with the same bank? That is where I am running into issues when I import and "clear" (I have always called this "reconciling" but I guess there is a difference?) The bank just has a line item "bankname payment" , same for each card account. That is where I run into issues trying to manually "clear" and that throws my account balances in GC off -Original Message- From: Adrien Monteleone [mailto:adrien.montele...@lusfiber.net] Sent: Wednesday, February 23, 2022 2:15 PM To:gnucash-u...@lists.gnucash.org Subject: Re: [GNC] reconcile problem? Transactions won't reconcile themselves, but you can clear them either manually or via an import. If you opened a backup by mistake, that would result in something showing 'unreconciled' if the backup was before the reconciliation. The only way to get the 'y' to appear in the register is through a reconciliation. Which means you in fact checked it off a previous time. You can re-do a reconciliation by changing all of the affected transactions back to 'n' or 'c', and then trying again. Be sure to remove any adjusting transactions you made during the last reconciliation. You probably don't need them. (but can always re-create if you do) Then proceed with this months reconciliation. In the future, if you ever notice transactions appearing 'c' or 'n' when you know they should be 'y' means you've edited them in a manner that will change the flag. (either in that register or one connected to the transaction) If you don't get warnings about this, go to Actions > Reset Warnings... and adjust as needed. When you edit a transaction and the flag changes (or you discover it later) simply re-reconcile and clear the affected transaction(s). (and if you are editing amounts, double check you didn't make an adjusting entry, because again, you might no longer need it!) Regards, Adrien On 2/23/22 9:33 AM, Paul Kinzelman wrote: That's a good question and I think that could be an explanation for the resurrection of the reconciled transactions which happened quite awhile ago when I was new to GC. But that doesn't explain how a transaction could become reconciled on its own like the one that happened this month, which tipped me over the edge to post about it. -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ 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] reconcile problem?
That came up in another thread a couple of weeks ago. As far as I know, the only solution is to be very careful in the matching step of the import. You can help yourself when making the payments to be sure they have different dates or amounts, or even paying out of different checking accounts. On Fri, Feb 25, 2022 at 8:11 AM scum buster wrote: > Sidebar question --- do any of you have more than one credit card with the > same bank? That is where I am running into issues when I import and > "clear" (I have always called this "reconciling" but I guess there is a > difference?) > > The bank just has a line item "bankname payment" , same for each card > account. > > That is where I run into issues trying to manually "clear" and that throws > my account balances in GC off > > -Original Message- > From: Adrien Monteleone [mailto:adrien.montele...@lusfiber.net] > Sent: Wednesday, February 23, 2022 2:15 PM > To: gnucash-u...@lists.gnucash.org > Subject: Re: [GNC] reconcile problem? > > Transactions won't reconcile themselves, but you can clear them either > manually or via an import. > > If you opened a backup by mistake, that would result in something > showing 'unreconciled' if the backup was before the reconciliation. > > The only way to get the 'y' to appear in the register is through a > reconciliation. Which means you in fact checked it off a previous time. > > You can re-do a reconciliation by changing all of the affected > transactions back to 'n' or 'c', and then trying again. Be sure to > remove any adjusting transactions you made during the last > reconciliation. You probably don't need them. (but can always re-create > if you do) > > Then proceed with this months reconciliation. > > In the future, if you ever notice transactions appearing 'c' or 'n' when > you know they should be 'y' means you've edited them in a manner that > will change the flag. (either in that register or one connected to the > transaction) > > If you don't get warnings about this, go to Actions > Reset Warnings... > and adjust as needed. > > When you edit a transaction and the flag changes (or you discover it > later) simply re-reconcile and clear the affected transaction(s). (and > if you are editing amounts, double check you didn't make an adjusting > entry, because again, you might no longer need it!) > > Regards, > Adrien > > On 2/23/22 9:33 AM, Paul Kinzelman wrote: > > That's a good question and I think that could be an explanation > > for the resurrection of the reconciled transactions which happened > > quite awhile ago when I was new to GC. > > > > But that doesn't explain how a transaction could become > > reconciled on its own like the one that happened this month, which > > tipped me over the edge to post about it. > > > > > -- > This email has been checked for viruses by Avast antivirus software. > https://www.avast.com/antivirus > > ___ > 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. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user 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] Report question
Do you mean Account Report? But when I go to File | Export, it asks me which accounts again, it doesn't export the actual report. When I export the transactions I want, it exports both sides of the transaction, so the column sum is always zero whereas I want the sum of the transactions. In other words, each transaction takes two lines, the line I want (the expense of what I bought), and the next line which is the account that paid it (like a charge card). How do I get rid of the double-lines on the export? Here's one line example: 02/23/2022 ff8275d221f24ecfa82aaf8f6e4c9852 Home Depot weed block CURRENCY::USD Expenses:House:Garden Garden $102.11 102.11 n 1 Liabilities:Credit Card:DCUvisa DCUvisa joint $(102.11) (102.11)n 1 On 2/24/2022 1:09 PM, David Carlson wrote: That procedure generates a mess, in my opinion. Wouldn't it be simpler to just run a register report? On Thu, Feb 24, 2022 at 12:57 PM Paul Kinzelman wrote: If I do a Search for the transactions I want, and then Export Active Register, I can look at the CSV in a spreadsheet, but both accounts of the transaction appear in the same column so the sum of the amount column is always zero. How do I export just one account's amount of each transaction without the other side of the transaction being there so that the sum of the column actually represents the sum of the expenses of that Search? TIA! ___ 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. -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user 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] reconcile problem?
Sidebar question --- do any of you have more than one credit card with the same bank? That is where I am running into issues when I import and "clear" (I have always called this "reconciling" but I guess there is a difference?) The bank just has a line item "bankname payment" , same for each card account. That is where I run into issues trying to manually "clear" and that throws my account balances in GC off -Original Message- From: Adrien Monteleone [mailto:adrien.montele...@lusfiber.net] Sent: Wednesday, February 23, 2022 2:15 PM To: gnucash-u...@lists.gnucash.org Subject: Re: [GNC] reconcile problem? Transactions won't reconcile themselves, but you can clear them either manually or via an import. If you opened a backup by mistake, that would result in something showing 'unreconciled' if the backup was before the reconciliation. The only way to get the 'y' to appear in the register is through a reconciliation. Which means you in fact checked it off a previous time. You can re-do a reconciliation by changing all of the affected transactions back to 'n' or 'c', and then trying again. Be sure to remove any adjusting transactions you made during the last reconciliation. You probably don't need them. (but can always re-create if you do) Then proceed with this months reconciliation. In the future, if you ever notice transactions appearing 'c' or 'n' when you know they should be 'y' means you've edited them in a manner that will change the flag. (either in that register or one connected to the transaction) If you don't get warnings about this, go to Actions > Reset Warnings... and adjust as needed. When you edit a transaction and the flag changes (or you discover it later) simply re-reconcile and clear the affected transaction(s). (and if you are editing amounts, double check you didn't make an adjusting entry, because again, you might no longer need it!) Regards, Adrien On 2/23/22 9:33 AM, Paul Kinzelman wrote: > That's a good question and I think that could be an explanation > for the resurrection of the reconciled transactions which happened > quite awhile ago when I was new to GC. > > But that doesn't explain how a transaction could become > reconciled on its own like the one that happened this month, which > tipped me over the edge to post about it. -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ 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] GNU Cash on Apple iPhone
Hi, On Fri, February 25, 2022 6:42 am, Sudesh Chandar via gnucash-user wrote: > Hello Group, > I use my cell phone as an input device for GNU cash application on my > Windows 10 laptop. > I recently switched from an Android device to an Apple iPhone and noticed > a lot of differences using the app on the iPhone. > 1. I don't have the ability to export transactions as a QIF ( Quicken file > format )2.The only option to export tractions is thru comma separated > values.3. There is no setting menu on the iPhone to store the exported > file to cloud storage as in the Android version. I have to manually move > the csv file to the cloud storage for importing it on my PC.4. GNU Cash > mobile doesn't come with any user manual. > I would love these features to be added to the iPhone version or do you > suggest I just get used to it? There is no GnuCash of iOS... And if there is, not only is it not related to us, it was NEVER related to us. Even GnuCash for Android was only tangentially related (the author was a GSoC summer intern, but it was never truly a GnuCash product). So you should reach out to the app author. We have nothing to do with it. Sorry, > Thanks, > Sudesh Chandar, > 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 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] GNU Cash on Apple iPhone
Hello Group, I use my cell phone as an input device for GNU cash application on my Windows 10 laptop. I recently switched from an Android device to an Apple iPhone and noticed a lot of differences using the app on the iPhone. 1. I don't have the ability to export transactions as a QIF ( Quicken file format )2.The only option to export tractions is thru comma separated values.3. There is no setting menu on the iPhone to store the exported file to cloud storage as in the Android version. I have to manually move the csv file to the cloud storage for importing it on my PC.4. GNU Cash mobile doesn't come with any user manual. I would love these features to be added to the iPhone version or do you suggest I just get used to it? Thanks, Sudesh Chandar, ___ 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.