Re: [GNC] Finance::Quote not Working on Macbook
Hi BP Background: To retrieve price data, GnuCash depends on a Perl module called Finance-Quote. Finance-Quote depends on other Perl modules, including one called Date-Manip. Date-Manip in turn also depends on other Perl modules. These modules may depend on further Perl modules. Etc etc. Most of these dependencies are *not* included in the base Perl installation. Your problem: Based on the scant information you have provided, it appears that the Date-Manip module can't be installed because of one or more missing dependencies. Your task: Carefully track down all the missing dependencies and install them. I have no experience with MacOS, but Google is your friend: https://bioinformaticsonline.com/blog/view/29479/how-to-install-perl-modules-on-mac-os-x-in-easy-steps Good luck, and report back with more details if you get stuck. Geoff = On 16/02/2021 3:55 pm, bdp3 wrote: Thanks, John, for the suggestion. It ran--produced a lot of activity in the Terminal window. The problems started immediately. This message was first... Unsatisfied dependencies detected during SBECK/Date-Manip-6.83.tar.gz Then there was a whole lot of this message throughout... Make had some problems, won't install Delayed until after prerequisites Also had loads and loads of ... Warning: prerequisite < blah blah blah > with 'make => NO'. Continuing, but chances to succeed are limited. And if finally ended with these messages... Running make test Can't test without successful make Running make install Make had returned bad status, install seems impossible Is there something else I can try, or another reference I can read? I don't understand any of it and I'm thinking I did it wrong. Thanks for all! (Even if I don't know what that is.) BP On 2/15/21, 8:01 PM, "John Ralls" wrote: > On Feb 15, 2021, at 5:47 PM, bdp3 wrote: > > Is anyone else having trouble making F:Q work on a Mac? If not, maybe you can help me—I’m new here and I just don’t ‘get it’! > > I’m using GnuCash_4.4 on Mac OS 10.14 (Mojave). > > I downloaded version 1.49 from SourceForge. There’s an ‘Applications’ folder at the hard-drive level, and an ‘Applications’ folder at the User folder level; I’ve tried unzipping FQ into both directories and still have no success. I read the GnuCash wiki on Online Quotes; I have perl installed; I used CPAN; I’m getting lost in the weeds. The ‘Security Edit’ page (for any given security which I have set up) shows the Online Checkbox greyed-out with the same message familiar to us: “Warning: Finance::Quote not installed properly”. I also tried running “gnc-fq-check“ and “gnc-fq-update” – No Joy! > > What am I missing? > > > > Thanks much for anything you can tell me!! (Pictures help – preferably in crayons or watercolors.) The only thing you tried that's right is gnc-fq-update. It needs sudo as shown in https://wiki.gnucash.org/wiki/Online_Quotes#Installing_Finance::Quote_on_macOS_from_a_Terminal_prompt Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ 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] Scheduled Transactions
lj, I'm Pretty sure you're correct on that. I have tried previously to update Scheduled Txns so I could delete incorrect ones and recreate them from a certain date but without success. I've never found anything to reset the last occurred date recorded in Gnucash and invariably ended up manually creating a new Scheduled Txn. I have just tried right clicking on a past transaction that was created by a Scheduled Txn template and clicking Schedule on the context menu that pops up. This created a duplicate Scheduled Txn with a last occurred date of never which I was able to edit and get triggered by using the "Since Last Run..." menu item so you can probably replace a bad Scheduled Txn this way. Cheers David H. On Tue, 16 Feb 2021 at 11:23, lj wrote: > I am pretty sure that does NOT work. You can change the start date for a > scheduled transaction forward, or backwards, or change the transaction to > non-repeating and then back to repeating... and the "last triggered" date > will > not change. Someone correct me if I'm wrong but I think editing the file > is > the only way to set the last triggered date to an earlier date (or to > remove it). > > > David Carlson wrote: > > I think it may be possible to set the start date for an existing > scheduled > > transaction to an arbitrary date in the past to effectively reset the > clock > > on that scheduled transaction. However, I do not have a test file handy > or > > the time to pursue that theory myself. > > > > Alternatively, one could duplicate a previously created transaction, then > > memorize that transaction. If the original scheduled transaction > contained > > formulas, the newly created scheduled transaction would have to be edited > > to insert those formulas. While formulas can be inserted into existing > > transactions, they get evaluated instantly when the edit is committed, so > > they must be saved as scheduled transactions to remain as formulas. > > > > One would have to remember to give the new scheduled transaction a > > distinctive name to be easily found in the list of scheduled > transactions, > > since it will likely be named similarly to other existing transactions. > > > > > > > > On Sun, Feb 14, 2021 at 8:46 PM lj wrote: > > > >> bdp3 wrote: > >>> But I still don't understand HOW to rerun the SX using a date in the > >> past... My SX has many lines and deleting/re-writing it would be a > hassle. > >>> > Questions: > >>> > How can the Scheduled be re-run for prior periods? > >> > >> The only way to do that is by editing your Gnucash data file with a text > >> editor. Not recommended unless you are confident, keep backups, etc. > >> Basically > >> you close Gnucash, uncompress (gunzip) the data file, and open it in > your > >> text > >> editor. Look for your scheduled transaction by name (...), and > >> change > >> the date in the sx:last tag. Save the file, recompress it with gzip, and > >> reopen it in Gnucash. > >> > >> I've always thought it would be a neat feature to add: Have gnucash > reset > >> the > >> last triggered date for a scheduled transaction if you change the start > >> date > >> (or something like that). No UI changes needed. It would provide a way > to > >> fix > >> problems like this without affecting much else. > >> > > ___ > 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] Finance::Quote not Working on Macbook
Thanks, John, for the suggestion. It ran--produced a lot of activity in the Terminal window. The problems started immediately. This message was first... Unsatisfied dependencies detected during SBECK/Date-Manip-6.83.tar.gz Then there was a whole lot of this message throughout... Make had some problems, won't install Delayed until after prerequisites Also had loads and loads of ... Warning: prerequisite < blah blah blah > with 'make => NO'. Continuing, but chances to succeed are limited. And if finally ended with these messages... Running make test Can't test without successful make Running make install Make had returned bad status, install seems impossible Is there something else I can try, or another reference I can read? I don't understand any of it and I'm thinking I did it wrong. Thanks for all! (Even if I don't know what that is.) BP On 2/15/21, 8:01 PM, "John Ralls" wrote: > On Feb 15, 2021, at 5:47 PM, bdp3 wrote: > > Is anyone else having trouble making F:Q work on a Mac? If not, maybe you can help me—I’m new here and I just don’t ‘get it’! > > I’m using GnuCash_4.4 on Mac OS 10.14 (Mojave). > > I downloaded version 1.49 from SourceForge. There’s an ‘Applications’ folder at the hard-drive level, and an ‘Applications’ folder at the User folder level; I’ve tried unzipping FQ into both directories and still have no success. I read the GnuCash wiki on Online Quotes; I have perl installed; I used CPAN; I’m getting lost in the weeds. The ‘Security Edit’ page (for any given security which I have set up) shows the Online Checkbox greyed-out with the same message familiar to us: “Warning: Finance::Quote not installed properly”. I also tried running “gnc-fq-check“ and “gnc-fq-update” – No Joy! > > What am I missing? > > > > Thanks much for anything you can tell me!! (Pictures help – preferably in crayons or watercolors.) The only thing you tried that's right is gnc-fq-update. It needs sudo as shown in https://wiki.gnucash.org/wiki/Online_Quotes#Installing_Finance::Quote_on_macOS_from_a_Terminal_prompt Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Hidden accounts appear in popups
That's always been true, and it's not a bug. As noted in the comments of the bug I cited, "Placeholder" might better be considered and named "Read Only." Original Message From: Adrien Monteleone Sent: Mon Feb 15 17:05:18 EST 2021 To: gnucash-u...@lists.gnucash.org Subject: Re: [GNC] Hidden accounts appear in popups You can mark an account that contains transactions as a placeholder? I didn't think that was possible. Sounds like another bug. Regards, Adrien On 2/14/21 10:22 PM, D. via gnucash-user wrote: > Yep. That's how it is. To hide accounts in the popup, you also have to set it > as a placeholder. Cf. https://bugs.gnucash.org/show_bug.cgi?id=397135 ___ 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] Finance::Quote not Working on Macbook
> On Feb 15, 2021, at 5:47 PM, bdp3 wrote: > > Is anyone else having trouble making F:Q work on a Mac? If not, maybe you > can help me—I’m new here and I just don’t ‘get it’! > > I’m using GnuCash_4.4 on Mac OS 10.14 (Mojave). > > I downloaded version 1.49 from SourceForge. There’s an ‘Applications’ folder > at the hard-drive level, and an ‘Applications’ folder at the User folder > level; I’ve tried unzipping FQ into both directories and still have no > success. I read the GnuCash wiki on Online Quotes; I have perl installed; I > used CPAN; I’m getting lost in the weeds. The ‘Security Edit’ page (for any > given security which I have set up) shows the Online Checkbox greyed-out with > the same message familiar to us: “Warning: Finance::Quote not installed > properly”. I also tried running “gnc-fq-check“ and “gnc-fq-update” – No > Joy! > > What am I missing? > > > > Thanks much for anything you can tell me!! (Pictures help – preferably in > crayons or watercolors.) The only thing you tried that's right is gnc-fq-update. It needs sudo as shown in https://wiki.gnucash.org/wiki/Online_Quotes#Installing_Finance::Quote_on_macOS_from_a_Terminal_prompt Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] getting other account types on expense report
I recently switched from paying rent to a mortgage. I have a Liabilities account with my mortgage principal, which I pay down every month with part of my mortgage payment, which comes directly from an Income account. I like the Expense Barchart report, but is there some way I can add the principal part of my mortgage payment to it? Whenever I try to add a non-Expenses account to that report, it gets deselected and ignored. Is there some other report I should use to get the same result plus other account types, or some other account structure? I understand that the principal I pay back is not really an expense, but I would still like to see it in a report as if it were an expense, because I need to pay it every month, like rent. I'm using GnuCash 2.6.21 on CentOS 7. Cheers, 11011011 ___ 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] Finance::Quote not Working on Macbook
Is anyone else having trouble making F:Q work on a Mac? If not, maybe you can help me—I’m new here and I just don’t ‘get it’! I’m using GnuCash_4.4 on Mac OS 10.14 (Mojave). I downloaded version 1.49 from SourceForge. There’s an ‘Applications’ folder at the hard-drive level, and an ‘Applications’ folder at the User folder level; I’ve tried unzipping FQ into both directories and still have no success. I read the GnuCash wiki on Online Quotes; I have perl installed; I used CPAN; I’m getting lost in the weeds. The ‘Security Edit’ page (for any given security which I have set up) shows the Online Checkbox greyed-out with the same message familiar to us: “Warning: Finance::Quote not installed properly”. I also tried running “gnc-fq-check“ and “gnc-fq-update” – No Joy! What am I missing? Thanks much for anything you can tell me!! (Pictures help – preferably in crayons or watercolors.) BP ___ 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] Asset vs Equity accounts?
Strangely nearly all quick-serve businesses stopped offering receipts about 18-24 months ago. (at least in my neck-o-the-woods) Their printers were spitting them out mind you, but they would quickly just crumple and toss them. I'm sure I annoyed a few cashiers by asking for it. I even told one when they complained that perhaps *they* should ask. Their response was, "I used to but *everyone* declined, so I just started throwing them." I'm sure their boss would have been happier to know that tidbit so they could turn off auto-receipt printing, or maybe that would have been an opportune time to instruct their employees to just hand it out and let the customer toss it if they don't want it. (I honestly thought offering a receipt was required by law, I guess not.) To be sure, I don't think any 'conspiracy against receipts memo' was sent out nationwide, but it might be one of those '100th monkey' scenarios. I got a kick out of asking for receipts at the local taproom for each round. (paying cash as I go) One of the bar guests thought I had devised a way to write-off beer! (certainly no, but it was the surest way to keep track of my beer budget.) Regards, Adrien On 2/15/21 7:11 PM, Larry Long wrote: Thanks for the illuminating responses from Stan, Adrien and Michael! It reminds me of years ago when my wife had to start reporting her business expenses and she had a hard time remembering to always get a receipt.One day I finally said "You have two hands. Hold both of them out with your palms up. Just remember when your money leaves one hand, you should be getting a receipt back in the other hand."It served as a good visual reminder for me with expenses, also.:-) ___ 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] Scheduled Transactions
I am pretty sure that does NOT work. You can change the start date for a scheduled transaction forward, or backwards, or change the transaction to non-repeating and then back to repeating... and the "last triggered" date will not change. Someone correct me if I'm wrong but I think editing the file is the only way to set the last triggered date to an earlier date (or to remove it). David Carlson wrote: I think it may be possible to set the start date for an existing scheduled transaction to an arbitrary date in the past to effectively reset the clock on that scheduled transaction. However, I do not have a test file handy or the time to pursue that theory myself. Alternatively, one could duplicate a previously created transaction, then memorize that transaction. If the original scheduled transaction contained formulas, the newly created scheduled transaction would have to be edited to insert those formulas. While formulas can be inserted into existing transactions, they get evaluated instantly when the edit is committed, so they must be saved as scheduled transactions to remain as formulas. One would have to remember to give the new scheduled transaction a distinctive name to be easily found in the list of scheduled transactions, since it will likely be named similarly to other existing transactions. On Sun, Feb 14, 2021 at 8:46 PM lj wrote: bdp3 wrote: But I still don't understand HOW to rerun the SX using a date in the past... My SX has many lines and deleting/re-writing it would be a hassle. > Questions: > How can the Scheduled be re-run for prior periods? The only way to do that is by editing your Gnucash data file with a text editor. Not recommended unless you are confident, keep backups, etc. Basically you close Gnucash, uncompress (gunzip) the data file, and open it in your text editor. Look for your scheduled transaction by name (...), and change the date in the sx:last tag. Save the file, recompress it with gzip, and reopen it in Gnucash. I've always thought it would be a neat feature to add: Have gnucash reset the last triggered date for a scheduled transaction if you change the start date (or something like that). No UI changes needed. It would provide a way to fix problems like this without affecting much else. ___ 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] Asset vs Equity accounts?
Thanks for the illuminating responses from Stan, Adrien and Michael! It reminds me of years ago when my wife had to start reporting her business expenses and she had a hard time remembering to always get a receipt.One day I finally said "You have two hands. Hold both of them out with your palms up. Just remember when your money leaves one hand, you should be getting a receipt back in the other hand."It served as a good visual reminder for me with expenses, also.:-) Larry ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] USAA online setup
That might be a older AQBanking6 issue. Try creating a dummy account on the AQBanking Setup Dialog's Accounts tab then go back to Users and retrieve your USAA accounts again. Regards, John Ralls > On Feb 15, 2021, at 12:28 PM, Richard via gnucash-user > wrote: > > I followed the instructions at > https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings > > It did not work for me. I don't know if I missed some little input or what. I > did not understand a lot of the labels for input. > > I did not receive an error message. It appear to go through the process of > downloading the account list. It said finished. If it downloaded anything, I > don't know where it is. > > Anyone have an additional suggestion? > > Richard > > ___ > 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] Lists
The auto-fill is a feature of GTK then and GnuCash just gets to take advantage of it? Regards, Adrien On 2/15/21 5:42 PM, David Carlson wrote: You won't find that first list in the help manual because it does not exist in GnuCash. Right now the GnuCash.org server is down, else You may find it mentioned in their wish list section for new features. ___ 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] Asset vs Equity accounts? (Stan Brown)
On 2021-02-15 14:12, Larry Long wrote: > Stan, > You gave an excellent intro into the fundamentals of accounting (and GnuCash)! > I would like to follow up with a basic question of my own. > Let's say that I have added my new car's value to Assets and my auto loan to > Liabilities.After a year, I log the car's depreciation as a reduction to it's > account in Assets.Where is the account for the offsetting depreciation > amount?Is that an expense? Yes, the two splits for a record of depreciation are a minus to Asset:Car and an equal and opposite plus to Expense:Car Depreciation -- or perhaps Expense:Transportation. Of course you can set whatever account titles you wish, and you can also decide how finely you want to subdivide things. Don't know if you've set up your GC to use standard accounting terminology, but if you have then it would be a credit to the asset (which decreases it) and a debit to the expense (which increases that). -- Stan Brown Tehachapi, CA, USA https://BrownMath.com https://OakRoadSystems.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] Lists
You won't find that first list in the help manual because it does not exist in GnuCash. Right now the GnuCash.org server is down, else You may find it mentioned in their wish list section for new features. On Mon, Feb 15, 2021 at 4:35 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > I'm not certain about the first one. How you get to it might depend on > which data format you are saving. > > For the second, GnuCash doesn't have 'categories'. What would be similar > to categories from something like Quicken, are called Accounts. And > those are editable on the main tab in GnuCash with that same label. > > Regards, > Adrien > > On 2/14/21 5:14 PM, Richard via gnucash-user wrote: > > Could someone please tell me where the memorized payee list is stored > > and how to add or delete one? > > > > Also, where is the category list stored and how do I edit 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 > 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] Asset vs Equity accounts? (Stan Brown)
Thank you very much to all that replied. There are, obviously, a lot of people out there with a much deeper understanding of this than I currently have (or probably ever will) and I thank you for sharing your knowledge and experience. I am slowly getting a handle on the overall concepts and believe the point here is to 'account' for all movement of funds. In a perfect world, every transaction would have a source and a destination (my terminology) and every account would start at zero but if we start with something we need to record where it came from so we can use 'opening balance' in Equity. I'm not completely sure if this is all correct (or close to correct) but it's kind of the way I understand it so far... I believe for my purposes, now, I will record only 'opening balances' in the Equity account. That should get me by until I realize it's completely wrong. ;) Thanks again. On Mon, Feb 15, 2021 at 2:22 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Generally yes, but that usually is not done for a personal vehicle > unless you are allowed to do so for some type of credit or deduction on > taxes. Businesses routinely depreciate their fleets however. The rules > are varied and myriad as to what you are allowed to do. > > Regards, > Adrien > > On 2/15/21 4:12 PM, Larry Long wrote: > > Stan, > > You gave an excellent intro into the fundamentals of accounting (and > GnuCash)!I would like to follow up with a basic question of my own. > > Let's say that I have added my new car's value to Assets and my auto > loan to Liabilities.After a year, I log the car's depreciation as a > reduction to it's account in Assets.Where is the account for the offsetting > depreciation amount?Is that an expense? > > ___ > 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] Asset vs Equity accounts?
On 2/15/21 4:37 PM, Michael or Penny Novack wrote: On 2/15/2021 5:17 PM, Adrien Monteleone wrote: (technically, Income & Expenses are 'temporary' Equity accounts, but GnuCash gives them their own 'top-level' with Assets, Equity & Liabilities. In the pen days, you closed these out at the end of the year to Retained Earnings, also an Equity account.) Even more pedantic (from somebody who was first keeping books in those days when it was pen and ink in paper) you FIRST closed the income and expense accounts to a special (equity) account called "profit and loss" and you closed THAT account with the net profit (or loss) to retained earnings. The closed "profit and loss" account became your "Profit and Loss" report. How did I forget? Yes, I learned it that way as well. Thus the expanded equation is: Assets = Liabilities + Income - Expenses Well --- Assets = Liabilities + Equity + Income - Expenses < there really isn't any subtraction; expenses are debits and this is the credit side of the equation> Yeah, I once tried to explain to my Mom & Dad how accounting isn't really about math equations, but how you 'account' for what you did. They never got it. Regards, Adrien ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Asset vs Equity accounts?
On 2/15/2021 5:17 PM, Adrien Monteleone wrote: (technically, Income & Expenses are 'temporary' Equity accounts, but GnuCash gives them their own 'top-level' with Assets, Equity & Liabilities. In the pen days, you closed these out at the end of the year to Retained Earnings, also an Equity account.) Even more pedantic (from somebody who was first keeping books in those days when it was pen and ink in paper) you FIRST closed the income and expense accounts to a special (equity) account called "profit and loss" and you closed THAT account with the net profit (or loss) to retained earnings. The closed "profit and loss" account became your "Profit and Loss" report. Thus the expanded equation is: Assets = Liabilities + Income - Expenses Well --- Assets = Liabilities + Equity + Income - Expenses < there really isn't any subtraction; expenses are debits and this is the credit side of the equation> Michael D Novack ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Lists
I'm not certain about the first one. How you get to it might depend on which data format you are saving. For the second, GnuCash doesn't have 'categories'. What would be similar to categories from something like Quicken, are called Accounts. And those are editable on the main tab in GnuCash with that same label. Regards, Adrien On 2/14/21 5:14 PM, Richard via gnucash-user wrote: Could someone please tell me where the memorized payee list is stored and how to add or delete one? Also, where is the category list stored and how do I edit 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 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] Minor issue with invoice layout
Play with the Layout tab in Options for the Invoice Report. There is also a custom CSS box available if you want to dig that far. Regards, Adrien On 2/14/21 11:47 AM, Howard M. Fried wrote: Hello, I upgraded Gnucash from ver 3.2 to 4.4 (Mac OS 10.15). My custom invoice layout changed. Particularly, the Client information, which was flush with the left margin, is now moved much toward the center. Business information is OK. It is a trivial issue, but can the Client information be moved back to the left margin? Edit--Style Sheets does not appear to be the answer. I created a new custom invoice (based on Easy), but it had the same issue. I haven't followed this forum for quite a while; thus, I apologize if invoice layout has been discussed (please point me to the information). ___ 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] TD Ameritrade OFX Direct
Thanks. I'll take a look at ofx.py. I was puzzled since the wizard setup in GNC goes to a place that brings back no data. But Quicken gets both the portfolio and transactions. Anyway, I'm more of a buy and hold kind of guy, so not that much data entry. If I were a day trader it would be a bigger deal. Keith On Mon, Feb 15, 2021 at 11:44 AM David Reiser wrote: > As of late last year, Martin was going to see if he could make the > stocks/mutual funds ofx transaction work well in aqbanking. I don’t know > how far he got, since he doesn’t have any of his own accounts to test that > functionality with. > > You might not be doing anything wrong. And fixing it might not do you any > good. > > I use ofx.py to download TDAmeritrade transactions. Then File>Import in > Gnucash works, since the import function goes through libofx to parse the > transactions. Libofx has handled stock/mutual fund transactions pretty well > for me. > -- > Dave Reiser > dbrei...@icloud.com > > > > > > > On Feb 15, 2021, at 11:20 AM, Keith Bellairs wrote: > > > > Quicken is able to download brokerage account transactions from > Ameritrade. > > > > I can configure Online Banking in GNC with my user info, retrieve > accounts, > > and link the accounts to my GNC accounts. But when I try to Get > > Transactions the ameritrade server accepts my connection and returns a > HTTP > > status 400. No transactions. But Quicken sees and downloads them. > > > > Does anyone use online banking with Ameritrade? If so, what am I doing > > wrong? > > > > Keith > > > > Here's the GNC Online Banking connection Window: > > > > AqBanking v6.2.5.0stable > > Sending jobs to the bank(s) > > Sorting commands by account > > Sorting commands by account > > Sorting commands by provider > > Send commands to providers > > Send commands to provider "aqofxconnect" > > Locking customer "13" > > Sending request... > > Connecting to server... > > Resolving hostname "ofxs.ameritrade.com" ... > > IP address is "198.200.171.142" > > Connecting to "ofxs.ameritrade.com" > > Connected to "ofxs.ameritrade.com" > > Using GnuTLS default ciphers. > > TLS: SSL-Ciphers negotiated: TLS1.2:RSA-AES-256-GCM:AEAD > > Connected. > > Sending message... > > Message sent. > > Waiting for response... > > Receiving response... > > HTTP-Status: 400 (400) > > Unlocking customer "13" > > ___ > > 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] Lists
Hit F1 while GnuCash is running. Then read the help manual. On Mon, Feb 15, 2021 at 4:21 PM Richard via gnucash-user < gnucash-user@gnucash.org> wrote: > Could someone please tell me where the memorized payee list is stored > and how to add or delete one? > > Also, where is the category list stored and how do I edit 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 > 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] UI question about 2.6...
I thought that change was made in the move to 3.x, but perhaps the UI was affected for the final releases of 2.6 as well. One of the early 3.x versions switched back to showing both text and buttons. Perhaps consider trying the Flatpak version. That way you can move up to the current 4.4. Regards, Adrien On 2/14/21 1:26 PM, Robert Heller wrote: I recently upgraded my OS from CentOS 6.10 to Ubuntu 18.04 and thus from GNUCash 2.4 to GNUCash 2.6. With GNUCash 2.6, the toolbar only has images for most of the tools. GNUCash 2.4 had a preference setting to display both text and images, but that preference seems to be missing in GNUCash 2.6. I am somebody who is fiercely literate and generally have trouble with pictorial tool buttons. Is there any way to get text for these buttons? It is actually easier/quicker for me if there is text. I am managing, mostly because I have been using GNUCash long enough to generally remember the order of the buttons. I realize the the 2.6 branch is not being worked on anymore and don't expect any sort of fix, just that I am wondering about this UI change... ___ 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] [GNC-dev] USAA FSB requires newer QWIN support
I ended up with two during my experimentation - I ended up requesting access twice, I got the same access is and password both times but different client uuids. Both client uuids I got as well as the published one worked for me. Quick check, did you capitalize the letters in the uuid? Someone mentioned it earlier and I just confirmed with my own, lower case uuids will return an error. -Randy On Sun, Feb 14, 2021, 2:12 PM John Ralls wrote: > Well, there's a UUID in that URL, but I just tried using it for the > ClientUUID and got "The user cannot signon because he or she entered an > invalid user ID or password." Using the one scraped from Quicken for MacOS > and reported in > https://lists.gnucash.org/pipermail/gnucash-devel/2021-February/045690.html > works. > > That leads me to believe that USAA is using the ClientUUID as an API key. > Quicken may have registered one or many. I think the only way to find that > out is for more users to set up MITMs with different versions of Quicken > and retrieve the ClientUUIDs for comparison. > > This makes me a bit leery of publishing it on the wiki, because if Quicken > or USAA catch on that it's been compromised they might change it and lock > us out again. > > Regards, > John Ralls > > > > On Feb 13, 2021, at 9:06 PM, Randy Johnson wrote: > > > > The CLIENTUID is also part of the URL that you get sent to after > completing > > https://df3cx-services.1fsapi.com/casm/usaa/enroll (or usaa.com/accessid > , > > not sure which is preferred), hopefully avoiding the need to install > > Quicken. > > > > -Randy > > > > On Fri, Feb 12, 2021, 5:29 PM Bob White via gnucash-devel < > > gnucash-de...@gnucash.org> wrote: > > > >> I got new USAA OFX download working with GNC 4.4.1. > >> > >> It's mainly a configuration task. > >> > >> -- User config -- > >> int uniqueId="" > >> char backendName="aqofxconnect" > >> char userName="" > >> char userId="" > >> char customerId="" > >> char country="us" > >> char bankCode="314074269" > >> int lastSessionId="0" > >> > >> data { > >> backend { > >>char bankName="USAA Federal Savings Bank" > >>char org="USAA Federal Savings Bank" > >>char fid="67811" > >>char serverAddr="https%3A%2F%2Fdf3cx-services.1fsapi.com > >> %2Fcasm%2Fusaa%2Faccess.ofx" > >>char appId="QMOFX" > >>char appVer="2300" > >>char headerVer="103" > >>char clientUid="" > >>int httpVMajor="0" > >>int httpVMinor="0" > >>char httpUserAgent="InetClntApp%2F3.0" > >> } #backend > >> } #data > >> - > >> > >> Notes: > >> -- 'httpUserAgent' is currently not configurable through GNC v4.4.1, > but > >> it works when included in the file. It has been added in newer > AqBanking, > >> look for support in next GNC release. > >> -- 'CLIENTUID' can be found in OFXLog.txt generated by Quicken. Signup > >> for trial and cancel within 30 days no charge. > >> -- 'your new USAA access id' can be found at > >> https://www.usaa.com/accessid > >> > >> You will need to disconnect accounts from within the AqBanking Wizard, > >> download accounts with new user configuration, then reconnect > accounts. In > >> my case, the new credit card account numbers in the accounts list are > not a > >> 100% match to the number found on your credit card. There were enough > >> common digits to know which was which, just be aware. I was able to > >> successfully download and update 2 checking accounts, a savings account, > >> and a credit card account. > >> > >> I hope this helps. > >> > >> Regards, > >> > >> Bob > >> > >> PS. I did clone the AqBanking repo and build and install the latest > >> libraries on the same machine I am running GNC. I am not sure if the > >> GNC used the libraries distributed with it or the ones I built so YMMV. > >> ___ > >> gnucash-devel mailing list > >> gnucash-de...@gnucash.org > >> https://lists.gnucash.org/mailman/listinfo/gnucash-devel > >> > > ___ > > gnucash-devel mailing list > > gnucash-de...@gnucash.org > > https://lists.gnucash.org/mailman/listinfo/gnucash-devel > > ___ 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] [GNC-dev] USAA FSB requires newer QWIN support
The CLIENTUID is also part of the URL that you get sent to after completing https://df3cx-services.1fsapi.com/casm/usaa/enroll (or usaa.com/accessid , not sure which is preferred), hopefully avoiding the need to install Quicken. -Randy On Fri, Feb 12, 2021, 5:29 PM Bob White via gnucash-devel < gnucash-de...@gnucash.org> wrote: > I got new USAA OFX download working with GNC 4.4.1. > > It's mainly a configuration task. > > -- User config -- > int uniqueId="" > char backendName="aqofxconnect" > char userName="" > char userId="" > char customerId="" > char country="us" > char bankCode="314074269" > int lastSessionId="0" > > data { > backend { > char bankName="USAA Federal Savings Bank" > char org="USAA Federal Savings Bank" > char fid="67811" > char serverAddr="https%3A%2F%2Fdf3cx-services.1fsapi.com > %2Fcasm%2Fusaa%2Faccess.ofx" > char appId="QMOFX" > char appVer="2300" > char headerVer="103" > char clientUid="" > int httpVMajor="0" > int httpVMinor="0" > char httpUserAgent="InetClntApp%2F3.0" > } #backend > } #data > - > > Notes: > -- 'httpUserAgent' is currently not configurable through GNC v4.4.1, but > it works when included in the file. It has been added in newer AqBanking, > look for support in next GNC release. > -- 'CLIENTUID' can be found in OFXLog.txt generated by Quicken. Signup > for trial and cancel within 30 days no charge. > -- 'your new USAA access id' can be found at > https://www.usaa.com/accessid > > You will need to disconnect accounts from within the AqBanking Wizard, > download accounts with new user configuration, then reconnect accounts. In > my case, the new credit card account numbers in the accounts list are not a > 100% match to the number found on your credit card. There were enough > common digits to know which was which, just be aware. I was able to > successfully download and update 2 checking accounts, a savings account, > and a credit card account. > > I hope this helps. > > Regards, > > Bob > > PS. I did clone the AqBanking repo and build and install the latest > libraries on the same machine I am running GNC. I am not sure if the > GNC used the libraries distributed with it or the ones I built so YMMV. > ___ > gnucash-devel mailing list > gnucash-de...@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-devel > ___ 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] Asset vs Equity accounts? (Stan Brown)
Generally yes, but that usually is not done for a personal vehicle unless you are allowed to do so for some type of credit or deduction on taxes. Businesses routinely depreciate their fleets however. The rules are varied and myriad as to what you are allowed to do. Regards, Adrien On 2/15/21 4:12 PM, Larry Long wrote: Stan, You gave an excellent intro into the fundamentals of accounting (and GnuCash)!I would like to follow up with a basic question of my own. Let's say that I have added my new car's value to Assets and my auto loan to Liabilities.After a year, I log the car's depreciation as a reduction to it's account in Assets.Where is the account for the offsetting depreciation amount?Is that an expense? ___ 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] Lists
Could someone please tell me where the memorized payee list is stored and how to add or delete one? Also, where is the category list stored and how do I edit 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 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] Reverse all transactions
Dear all, thanks for all your comments. It helped me to migrate the database into a proper state. >If you have a file holding the original transactions, then you should be > able to import them twice. Once to reverse the transactions original > entry. The second time to get them entered correctly. *@Stephen, *I was playing with the export-import function (to a CSV) but did not succeed. Gnucash crashed during import of transaction-CSV file with SIGABRT and error "Too many root sets. Aborted". There is a backtrace. Not sure whether it is useful: = #0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50 #1 0x7686f537 in __GI_abort () at abort.c:79 #2 0x76144158 in () at /usr/lib/x86_64-linux-gnu/libgc.so.1 #3 0x76144191 in GC_add_roots () at /usr/lib/x86_64-linux-gnu/libgc.so.1 #4 0x77db73f3 in () at /usr/lib/x86_64-linux-gnu/libguile-3.0.so.1 #5 0x77d8b639 in () at /usr/lib/x86_64-linux-gnu/libguile-3.0.so.1 #6 0x77e05bfd in scm_c_catch () at /usr/lib/x86_64-linux-gnu/libguile-3.0.so.1 #7 0x77db6065 in () at /usr/lib/x86_64-linux-gnu/libguile-3.0.so.1 #8 0x77db6234 in scm_primitive_load_path () at /usr/lib/x86_64-linux-gnu/libguile-3.0.so.1 #9 0x76fc99ac in gnc_exp_parser_real_init (addPredefined=addPredefined@entry=0) at ./libgnucash/app-utils/gnc-exp-parser.c:85 #10 0x76fc9d7e in gnc_exp_parser_parse_separate_varsPython Exception There is no member named keys.: (expression=expression@entry=0x7fffbcd0 "1.", value_p=value_p@entry=0x7fffbbb0, error_loc_p=error_loc_p@entry=0x7fffbb98, varHash=varHash@entry=0x5676b360) at ./libgnucash/app-utils/gnc-exp-parser.c:516 = gnucash version is 4.4 and it looks like the crash comes from the parser [1]. scm_primitive_load_path(scm_from_utf8_string("gnucash/app-utils/fin")); I did not investigate it further. I can file a bug report if it does not exist yet. [1] https://sources.debian.org/src/gnucash/1:4.4-1/libgnucash/app-utils/gnc-exp-parser.c/#L85 > one option you have is to go through each transaction in the > register, by hand, and reverse each split of each transaction by putting > a "-" character in front of the amount. *@Jim*, thanks for a very useful tip! It really helped to fix the database relatively quickly! I employed this trick in a semi-automatic way. What was necessary is the following combination of keypresses: *-key Downkey Left* It needed to be repeated many times, for each transaction. I have written a small bash script (I am using Linux), which generated this combination of keypresses. With its help I could fire about 5000 combinations just in one second. = #!/bin/bash sleep 1 for i in $(seq "$1") do xte 'str -' && xte 'key Down' && xte 'key Left' done = So the database is fixed. Thanks all for the help! Best regards Anton ___ 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] Asset vs Equity accounts?
While this may seem pedantic (and maybe it is), most texts present the Accounting Equation as: Assets = Liabilities + Equity Balance Sheets are based off this arrangement of the equation. That is why you will generally see an Asset section first, with a total, and then a second section or column with a "Liabilities + Equity" total that exactly matches the Asset total. Equity can be further broken down to: Income - Expenses (technically, Income & Expenses are 'temporary' Equity accounts, but GnuCash gives them their own 'top-level' with Assets, Equity & Liabilities. In the pen days, you closed these out at the end of the year to Retained Earnings, also an Equity account.) Thus the expanded equation is: Assets = Liabilities + Income - Expenses Regards, Adrien On 2/14/21 3:29 PM, gnu Gord wrote: First off I'll say I have no formal accounting training so I don't really understand accounting terminology or how it is represented in GnuCash. I understand the basic idea that Equity = Assets - Liabilities, but I'm unsure how this should be entered in GnuCash. Specifically, my question is; how do I know if something I have should be recorded in an Asset account or an Equity account? For example, our house. The documentation says an asset is something I own. That would mean our house should go in the Asset account, correct? But the documentation also says equity is my overall net worth. If I don't owe anything on my house, should it be recorded in an equity account instead of an asset account? What about a car, should it be recorded as an asset or equity if I own some of it but have a loan on it as well? Sorry for asking so many dumb questions but my head is about to explode!! ;) ___ 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] Asset vs Equity accounts? (Stan Brown)
Stan, You gave an excellent intro into the fundamentals of accounting (and GnuCash)!I would like to follow up with a basic question of my own. Let's say that I have added my new car's value to Assets and my auto loan to Liabilities.After a year, I log the car's depreciation as a reduction to it's account in Assets.Where is the account for the offsetting depreciation amount?Is that an expense? Thank you. Larry Long On Monday, February 15, 2021, 12:30:19 AM EST, gnucash-user-requ...@gnucash.org wrote: ... Date: Sun, 14 Feb 2021 17:08:02 -0800 From: Stan Brown To: gnucash-user@gnucash.org Subject: Re: [GNC] Asset vs Equity accounts? Message-ID: <167aeb21-5037-b157-34fe-85173c33a...@fastmail.fm> Content-Type: text/plain; charset=utf-8 ... Hi, Gord. Welcome to GnuCash! I think you may have missed a fundamental concept, and that's giving you all of the questions you mentioned above. The fundamental concept is: Every transaction, without exception, comprises two or more sub-entries, called "splits" in Gnucash. The splits in any give transaction must balance; if they don't, GC automatically creates an "imbalance" split to tell you the amount they're out of balance. What do I mean by "the splits must balance"? To answer that, let's first rearrange and expand that accounting equation you mentioned. You stated correctly: Equity = Assets - Liabilities That's correct as far as it goes, but it leaves out two other categories of accounts: Income and Expense. You can think of Income and Expense as adjustments to Equity from your day-to-day operations, but for a beginner it's probably easier to just think of them as independent types of accounts. That expands the basic equation in this way: Equity + Income - Expenses = Assets - Liabilities "Equity" is accountant-speak for your net worth. Income increases your net worth, and expenses reduce it. But from the equation, since everything must balance, you can see other possibilities too. Here's an example. Suppose you go to the grocery store and charge $120 worth of groceries to your Visa card. Then your transaction has two splits: Expense:Groceries +120 Liability:Visa +120 Expenses (left side of the equation) and liabilities (right side) both increase by $120, so your transaction is in balance. Now let's take your car question. Your car is an asset. Let's suppose you just bought it for $20,000. You paid $2500 down and financed $17,500. The transaction would be recorded in three splits: Assets:Car +20,000 Liability:Car loan +17,500 Assets:Bank Acct - 2,500 How does that work in terms of the accounting equation? Assets are increasing by 20,000 for the car but decreasing by 2,500 from bank account, for a net increase of 17,500; liabilities are increasing by 17,400. So each side of the equation is increasing by 17,500, and once again your transaction balances. Most types of transactions will increase both sides of the equation or decrease both sides, but some are a plus and a minus on one side that net out to not changing the equation. For instance, you get your Visa bill for $1822 and pay it. Here's your transaction: Liability:Visa -1822 Asset:Bank Acct -1822 The right side of the equation is Assets - Liabilities. If an asset moves up or down, and a liability moves up or down by the same amount, there is no net change on that side of the equation. The details have changed, but not the totals, because of that minus sign in "Assets - Liabilities". Once again, your transaction is in balance. Now let's take your house. Suppose it's worth $300,000, or at least that's what you paid for it, and your current mortgage balance is $170,000. There are three splits in the transaction that records this. Two of them are easy to see: Asset:House 300,000 Liability:Mortgage 170,000 But this is out of balance. How should the 130,000 difference be recorded to keep things in balance? As you suspected, that's part of your net worth, so the third split in this transaction is Equity:Net Worth 130,000 (If you own your house free and clear, you record the full value in Asset:House and also in Equity:Net Worth. Again, the equation balances because each side is increased by $300,000.) Hopefully from this you get the idea. It's not a question of which one account you should record something in, but which two (or more) accounts, to keep every transaction in balance. -- Stan Brown Tehachapi, CA, USA https://BrownMath.com https://OakRoadSystems.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
Re: [GNC] Hidden accounts appear in popups
Neat. I learn something new. Thanks! Regards, Adrien On 2/14/21 11:20 PM, D. via gnucash-user wrote: I'll mention that you can add both the hidden and the placeholder columns onto your Chart of Accounts window. They appear as check boxes, and you can change their values directly by clicking them in the window. Thus, you can quickly set both these flags from that screen. Note that if your CoA is using the defaults, once you click the hidden check box, your account will disappear. You can address this by setting the filter to show hidden accounts. Perhaps this will be less painful... ___ 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] Hidden accounts appear in popups
You can mark an account that contains transactions as a placeholder? I didn't think that was possible. Sounds like another bug. Regards, Adrien On 2/14/21 10:22 PM, D. via gnucash-user wrote: Yep. That's how it is. To hide accounts in the popup, you also have to set it as a placeholder. Cf. https://bugs.gnucash.org/show_bug.cgi?id=397135 ___ 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] USAA online setup
I followed the instructions at https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings It did not work for me. I don't know if I missed some little input or what. I did not understand a lot of the labels for input. I did not receive an error message. It appear to go through the process of downloading the account list. It said finished. If it downloaded anything, I don't know where it is. Anyone have an additional suggestion? Richard ___ 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] Dependency Page
Sorry. Time. Bit Bucket. Overflow bin. Besides, it will be outdated in 6 months anyway. On 2/14/21 4:22 PM, Frank H. Ellenberger wrote: Hi Stephen, Am 14.02.21 um 23:53 schrieb Stephen M. Butler: to whoever is maintaining the https://wiki.gnucash.org/wiki/Installing_Dependencies page. : the GnuCash community is the maintainer of the wiki. As I am busy, it is your job. ;-) Get a wiki account and fix it. Regards Frank ___ 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] Dependency Page
1. Need a round tuit. 2. Lack of knowledge (someday -- probably not soon). 3. When the bit bucket gets full just dump into the overflow bin. On 2/14/21 4:44 PM, David Cousens wrote: Stephen I have been meaning to an update of the dependencies page on the wiki for V4 for some time but have been largely occupied elsewhere for the moment. I usually consult the Version Release notes for any changes recorded there and do a skim through the Dev and User archives for any missing items anyone has picked up. Different distros also have different sets of preinstalled libraries so I generally include anything anyone noted as missing in the lists of apt ( and equivalent commands) but on the page which has the table of formal dependency requirements for each release I only use the information from the release notes. Please feel free to update the pages as you find problems. As Frank mentioned the idea behind the wiki is primarily user maintainance, David - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Tab Rendering Flaw
On Mon, Feb 15, 2021 at 11:03 AM John Ralls wrote: > > > On Feb 15, 2021, at 8:51 AM, Tommy Trussell > wrote: > > > > I noticed this morning John Ralls pushed an update to the Flatpak so I > > installed the update. I am now running the latest flatpak version > (Version: > > 4.4 Build ID: Flathub 4.4-4). It's still behaving similarly > > It's still the 4.4 release, the change is that it has some dependency > updates, the motivating one being the latest AQBanking for USAA members. > > You know that we have flatpak nightlies at > https://code.gnucash.org/builds/flatpak/maint, right? > I haven't had any special reason to try the nightly builds so I haven't looked into how to switch to them, but if needed I can try that. ___ 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] Tab Rendering Flaw
> On Feb 15, 2021, at 8:51 AM, Tommy Trussell wrote: > > I noticed this morning John Ralls pushed an update to the Flatpak so I > installed the update. I am now running the latest flatpak version (Version: > 4.4 Build ID: Flathub 4.4-4). It's still behaving similarly It's still the 4.4 release, the change is that it has some dependency updates, the motivating one being the latest AQBanking for USAA members. You know that we have flatpak nightlies at https://code.gnucash.org/builds/flatpak/maint, right? Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Tab Rendering Flaw
Thanks for the workaround. I just confirmed that some combination of right-clicks (bringing up the menu) and left clicks restores the tab label to its proper position. I noticed this morning John Ralls pushed an update to the Flatpak so I installed the update. I am now running the latest flatpak version (Version: 4.4 Build ID: Flathub 4.4-4). It's still behaving similarly I just opened Bug 798129 https://bugs.gnucash.org/show_bug.cgi?id=798129 HOW TO TRIGGER THE BUG 1) Open GnuCash and open enough accounts and/or reports to have more tabs than will fit across the top of the screen. 2) Scroll back and forth through the tabs using the arrow buttons to the right and left of the tabs. Clicking and HOLDING an arrow seems to most reliably trigger the bug. 3) Eventually one or more of the tabs will be rendered in the wrong location as shown in the attached screenshot. (The tab area will be blank, and while it may be hard to see, it's rendered BELOW the tab area.) Workaround to restore a tab label: 1) Right-click in the empty tab area to bring up the tabs menu. Occasionally this is all you need to do to make the text reappear. 2) (If the tab is still blank) Left-click in the blank area to close the tabs menu. The tab label sometimes reappears in the correct position by this point. 3) (If the tab is still blank) Left-click again in the blank area. The label usually reappears in the correct position by this point. On Sun, Feb 14, 2021 at 1:07 PM A Harvey wrote: > I played around with it for a few minutes. I seem to be able to reproduce > it. If I scroll back forth (using the arrows at the end of the row of > tabs) repeatedly enough times, the label is removed from the tab and stays > on the screen in the area a few lines below the tab area. If I right-click > the offending (now blank) tab opening the drop down menu, then left click > on the tab (which closes the drop down) the tab title returns to its place. > -Arthur > > On Sat, Feb 13, 2021 at 9:31 PM A Harvey wrote: > >> I have just started seeing the problem on Windows 10, GnuCash 4.4. >> I found that when I have many (as in too many to fit on the screen) tabs >> open at the top and scroll the tabs across very quickly, the text on one of >> the tabs will fall down exactly as Tommy has shown in his screenshot. If I >> scroll the tabs slowly, this doesn't happen. Since I just noticed this >> recently, I have not explored further. >> -Arthur >> >> On Sat, Feb 13, 2021 at 8:33 PM David Carlson < >> david.carlson@gmail.com> wrote: >> >>> I have also seen this oddity. I have seen it in release 3.8 in Ubuntu >>> 20.04. It has appeared on the tab for a report, usually after reloading >>> the report. I think that it persists until I close the file and re-open >>> it. >>> >>> On Sat, Feb 13, 2021 at 6:57 PM Tommy Trussell >> > >>> wrote: >>> >>> > For a few releases of GnuCash I have been seeing the account tabs >>> rendered >>> > strangely (the tab text and icons "floating" below the "tab area" of >>> the >>> > window). >>> > >>> > I'm attaching a screenshot. (I added a red box around the text to >>> highlight >>> > it.) >>> > >>> > I'm running GnuCash Version 4.4 (Build ID: Flathub 4.4-2) on Ubuntu >>> 20.10, >>> > and Ubuntu 18.04. HOWEVER I believe I have been seeing this since 3.8 >>> or so >>> > in self-built GnuCash installations. I haven't mentioned it before >>> because >>> > at first I assumed it was because of something I did in creating my >>> > self-compiled package, but this has persisted after I switched to >>> Flathub. >>> > >>> > Is anyone else experiencing this? I find that the tabs spontaneously >>> and >>> > randomly get affected throughout the session, at first affecting a >>> single >>> > tab and then affecting more tabs. >>> > >>> > In composing this message I wondered how the problem changes if I move >>> the >>> > tabs to the side [Preferences --> Window --> Tab], but on the side they >>> > look even worse, and when moving the tabs to the bottom of the window >>> the >>> > text of the tab is completely gone (presumably off the bottom edge of >>> the >>> > window and not visible). >>> > >>> > I just used Control-W to close a tab and then reopened the account and >>> the >>> > tab rendered correctly on the new attempt. SO for now I have a >>> > workaround... well except for when it affects an ad-hoc report tab... >>> > >>> > I would think that if this was common, folks would be complaining >>> because >>> > it makes it hard to deal with a lot of tabs when you can't read them >>> > easily. >>> > ___ >>> > 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.
Re: [GNC] TD Ameritrade OFX Direct
As of late last year, Martin was going to see if he could make the stocks/mutual funds ofx transaction work well in aqbanking. I don’t know how far he got, since he doesn’t have any of his own accounts to test that functionality with. You might not be doing anything wrong. And fixing it might not do you any good. I use ofx.py to download TDAmeritrade transactions. Then File>Import in Gnucash works, since the import function goes through libofx to parse the transactions. Libofx has handled stock/mutual fund transactions pretty well for me. -- Dave Reiser dbrei...@icloud.com > On Feb 15, 2021, at 11:20 AM, Keith Bellairs wrote: > > Quicken is able to download brokerage account transactions from Ameritrade. > > I can configure Online Banking in GNC with my user info, retrieve accounts, > and link the accounts to my GNC accounts. But when I try to Get > Transactions the ameritrade server accepts my connection and returns a HTTP > status 400. No transactions. But Quicken sees and downloads them. > > Does anyone use online banking with Ameritrade? If so, what am I doing > wrong? > > Keith > > Here's the GNC Online Banking connection Window: > > AqBanking v6.2.5.0stable > Sending jobs to the bank(s) > Sorting commands by account > Sorting commands by account > Sorting commands by provider > Send commands to providers > Send commands to provider "aqofxconnect" > Locking customer "13" > Sending request... > Connecting to server... > Resolving hostname "ofxs.ameritrade.com" ... > IP address is "198.200.171.142" > Connecting to "ofxs.ameritrade.com" > Connected to "ofxs.ameritrade.com" > Using GnuTLS default ciphers. > TLS: SSL-Ciphers negotiated: TLS1.2:RSA-AES-256-GCM:AEAD > Connected. > Sending message... > Message sent. > Waiting for response... > Receiving response... > HTTP-Status: 400 (400) > Unlocking customer "13" > ___ > 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.
[GNC] TD Ameritrade OFX Direct
Quicken is able to download brokerage account transactions from Ameritrade. I can configure Online Banking in GNC with my user info, retrieve accounts, and link the accounts to my GNC accounts. But when I try to Get Transactions the ameritrade server accepts my connection and returns a HTTP status 400. No transactions. But Quicken sees and downloads them. Does anyone use online banking with Ameritrade? If so, what am I doing wrong? Keith Here's the GNC Online Banking connection Window: AqBanking v6.2.5.0stable Sending jobs to the bank(s) Sorting commands by account Sorting commands by account Sorting commands by provider Send commands to providers Send commands to provider "aqofxconnect" Locking customer "13" Sending request... Connecting to server... Resolving hostname "ofxs.ameritrade.com" ... IP address is "198.200.171.142" Connecting to "ofxs.ameritrade.com" Connected to "ofxs.ameritrade.com" Using GnuTLS default ciphers. TLS: SSL-Ciphers negotiated: TLS1.2:RSA-AES-256-GCM:AEAD Connected. Sending message... Message sent. Waiting for response... Receiving response... HTTP-Status: 400 (400) Unlocking customer "13" ___ 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.