Re: [GNC] Hidden accounts appear in popups
I did? Still a great idea :-). David Carlson wrote: > Well, it has only been 10 years since you(Bill) suggested renaming the > placeholder column to Read-Only. > > On Sun, Feb 14, 2021 at 11:11 PM Bill Wohler wrote: > > Thanks for the confirmation, David. This does seems like a bug to be > fixed someday... > > D. 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 > > > > David > > > > > > Original Message > > From: Bill Wohler > > Sent: Sun Feb 14 19:03:09 EST 2021 > > To: gnucash-u...@lists.gnucash.org > > Subject: [GNC] Hidden accounts appear in popups > > > > The documentation says that, "The check box Hidden marks this account > > (and any sub-accounts) to be hidden in the account tree and not appear > > in the pop-up account list in the register." > > > > However, hidden accounts are still appearing in the account pop-up for > > me (version 4.4). > > > > Is this a known bug? I read about marking all of the hidden accounts > > with placeholder, but this is a pain. It also appears you still have to > > mark all subaccounts as hidden and placeholder as well, which is a pain. > > > > One click on the Hidden box in the parent account should be all it takes > > to make the account go away until summoned by the Filter By > Other > > > Show hidden accounts option. > > > > -- > > Bill Wohler aka > > http://www.newt.com/wohler/, GnuPG ID:610BD9AD > > ___ > > 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. > > -- > Bill Wohler aka > http://www.newt.com/wohler/, GnuPG ID:610BD9AD > ___ > 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 > > > > Alternatives: > > -- Bill Wohler aka http://www.newt.com/wohler/, GnuPG ID:610BD9AD ___ 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
Well, it has only been 10 years since you(Bill) suggested renaming the placeholder column to Read-Only. On Sun, Feb 14, 2021 at 11:11 PM Bill Wohler wrote: > Thanks for the confirmation, David. This does seems like a bug to be > fixed someday... > > D. 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 > > > > David > > > > > > Original Message > > From: Bill Wohler > > Sent: Sun Feb 14 19:03:09 EST 2021 > > To: gnucash-u...@lists.gnucash.org > > Subject: [GNC] Hidden accounts appear in popups > > > > The documentation says that, "The check box Hidden marks this account > > (and any sub-accounts) to be hidden in the account tree and not appear > > in the pop-up account list in the register." > > > > However, hidden accounts are still appearing in the account pop-up for > > me (version 4.4). > > > > Is this a known bug? I read about marking all of the hidden accounts > > with placeholder, but this is a pain. It also appears you still have to > > mark all subaccounts as hidden and placeholder as well, which is a pain. > > > > One click on the Hidden box in the parent account should be all it takes > > to make the account go away until summoned by the Filter By > Other > > > Show hidden accounts option. > > > > -- > > Bill Wohler aka > > http://www.newt.com/wohler/, GnuPG ID:610BD9AD > > ___ > > 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. > > -- > Bill Wohler aka > http://www.newt.com/wohler/, GnuPG ID:610BD9AD > ___ > 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] Hidden accounts appear in popups
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... Cheers, David T. Original Message From: Bill Wohler Sent: Mon Feb 15 00:10:03 EST 2021 To: "D." Cc: GnuCash-User Subject: Re: [GNC] Hidden accounts appear in popups Thanks for the confirmation, David. This does seems like a bug to be fixed someday... D. 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 > > David > > > Original Message > From: Bill Wohler > Sent: Sun Feb 14 19:03:09 EST 2021 > To: gnucash-u...@lists.gnucash.org > Subject: [GNC] Hidden accounts appear in popups > > The documentation says that, "The check box Hidden marks this account > (and any sub-accounts) to be hidden in the account tree and not appear > in the pop-up account list in the register." > > However, hidden accounts are still appearing in the account pop-up for > me (version 4.4). > > Is this a known bug? I read about marking all of the hidden accounts > with placeholder, but this is a pain. It also appears you still have to > mark all subaccounts as hidden and placeholder as well, which is a pain. > > One click on the Hidden box in the parent account should be all it takes > to make the account go away until summoned by the Filter By > Other > > Show hidden accounts option. > > -- > Bill Wohler aka > http://www.newt.com/wohler/, GnuPG ID:610BD9AD > ___ > 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. -- Bill Wohler aka http://www.newt.com/wohler/, GnuPG ID:610BD9AD ___ 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
Thanks for the confirmation, David. This does seems like a bug to be fixed someday... D. 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 > > David > > > Original Message > From: Bill Wohler > Sent: Sun Feb 14 19:03:09 EST 2021 > To: gnucash-u...@lists.gnucash.org > Subject: [GNC] Hidden accounts appear in popups > > The documentation says that, "The check box Hidden marks this account > (and any sub-accounts) to be hidden in the account tree and not appear > in the pop-up account list in the register." > > However, hidden accounts are still appearing in the account pop-up for > me (version 4.4). > > Is this a known bug? I read about marking all of the hidden accounts > with placeholder, but this is a pain. It also appears you still have to > mark all subaccounts as hidden and placeholder as well, which is a pain. > > One click on the Hidden box in the parent account should be all it takes > to make the account go away until summoned by the Filter By > Other > > Show hidden accounts option. > > -- > Bill Wohler aka > http://www.newt.com/wohler/, GnuPG ID:610BD9AD > ___ > 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. -- Bill Wohler aka http://www.newt.com/wohler/, GnuPG ID:610BD9AD ___ 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
What flavor of Quicken did you use? Regards, John Ralls > On Feb 14, 2021, at 6:19 PM, Keith Bellairs wrote: > > My USAA checking and credit card seem to be working. My users/0.conf is > using this client UID: I got it from quicken's OFXlog.txt file. > > char clientUid="39E0E763-4E1E-4918-9528-D6EBAC94EF5D" > > Notably when the online action in GNC challenges for the account password the > required response is now the "Access PIN". No longer the web site account > password. Yet another password to track. > > I cannot believe its working again. Thanks everyone. > > Keith > > _ > > Date: Sun, 14 Feb 2021 11:12:26 -0800 > From: John Ralls > To: Randy Johnson > Cc: gnucash-de...@gnucash.org, gnucash-user@gnucash.org > Subject: Re: [GNC] [GNC-dev] USAA FSB requires newer QWIN support > Message-ID: > Content-Type: text/plain; charset=us-ascii > > 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 > ___ 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 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. > -- 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] Hidden accounts appear in popups
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 David Original Message From: Bill Wohler Sent: Sun Feb 14 19:03:09 EST 2021 To: gnucash-u...@lists.gnucash.org Subject: [GNC] Hidden accounts appear in popups The documentation says that, "The check box Hidden marks this account (and any sub-accounts) to be hidden in the account tree and not appear in the pop-up account list in the register." However, hidden accounts are still appearing in the account pop-up for me (version 4.4). Is this a known bug? I read about marking all of the hidden accounts with placeholder, but this is a pain. It also appears you still have to mark all subaccounts as hidden and placeholder as well, which is a pain. One click on the Hidden box in the parent account should be all it takes to make the account go away until summoned by the Filter By > Other > Show hidden accounts option. -- Bill Wohler aka http://www.newt.com/wohler/, GnuPG ID:610BD9AD ___ 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
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] [GNC-dev] USAA FSB requires newer QWIN support
My USAA checking and credit card seem to be working. My users/0.conf is using this client UID: I got it from quicken's OFXlog.txt file. char clientUid="39E0E763-4E1E-4918-9528-D6EBAC94EF5D" Notably when the online action in GNC challenges for the account password the required response is now the "Access PIN". No longer the web site account password. Yet another password to track. I cannot believe its working again. Thanks everyone. Keith _ Date: Sun, 14 Feb 2021 11:12:26 -0800 From: John Ralls To: Randy Johnson Cc: gnucash-de...@gnucash.org, gnucash-user@gnucash.org Subject: Re: [GNC] [GNC-dev] USAA FSB requires newer QWIN support Message-ID: Content-Type: text/plain; charset=us-ascii 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 ___ 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 2021-02-14 13:29, 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!! > ;) 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:House300,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,
Re: [GNC] [GNC-dev] USAA FSB requires newer QWIN support
I tried again with a second visit to accessid so I'd get a fresh UUID. It worked to get the accounts but failed when I tried to retrieve transactions. I've summarized the setup process in https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings#USAA, though for my experience the Client UID instructions, which reflect getting them from the URL, are not correct. Regards, John Ralls > On Feb 14, 2021, at 3:59 PM, John Ralls wrote: > > I tried it both ways, capitalized and not. > > Regards, > John Ralls > > >> On Feb 14, 2021, at 11:31 AM, Randy Johnson wrote: >> >> 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: >
Re: [GNC] Dependency Page
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.
Re: [GNC] Dependency Page
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] Migrating to Linux Mint
Your GnuCash data file can be placed anywhere suitable in your home directory in Linux.i.e. in /home/ where is your user name on the Linux system. It is a good practice to create a separate subdirectory in which to place GnuCash data file you have (e.g personal finances, business finances etc). GnuCash creates backup and log files for each datafile each time the file is opened in the application in the same directory as the data file so this keeps the files for different sets of books separate and easier to manage. The date-timestamped backup and log files allow reconstruction of the file up to the corrupting transaction in the event of a corruption of the data file. You will need to save to that location when you create the data file (or move the file to that location if it already is created somewhere else, e.g in the Flatpak directory structure). I keep my data files in a Dropbox subdirectory of /home/ with a sub directory "GnuCash_Data_Files" with sub directories of that for each of my data files as I have a need to be able to access my accounts at times from multiple computers and sometimes multiple physical locations over the internet. This directory is synced to a Dropbox server. When I do backups of all my data, I backup all the contents of the "GnuCash _Data_Files" directory to my offsite backup device/location which makes backups simple. - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] [GNC-dev] USAA FSB requires newer QWIN support
I tried it both ways, capitalized and not. Regards, John Ralls > On Feb 14, 2021, at 11:31 AM, Randy Johnson wrote: > > 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] Asset vs Equity accounts?
gnuGord, If you have ownership, possession and/or control of your house and car or any other resource then they are assets. Bank accounts are also assets for example. Your furniture, a boat, camper etc are all assets. If you have taken a loan out to buy them, the present value of that loan is a liability, usually against that specific asset (e.g. mortgage) or your assets in general, i.e. you are obligated to pay it back with loss of the asset or a considerable fraction of its value a likely penalty if you don't. Any obligation you have to pay someone else some amount of money is a liability. Your equity in the house and car is the difference between their present value as assets and the outstanding liabilities against those assets. In most cases the cost of an asset is used to record its value as until you have sold it you do not have a definite value to ascribe to it. It is possible to track market values (unrealized gains and losses) on assets but it will be better to leave looking at this until you have the basic accounting under control. Each jurisdiction has rules re reporting of unrealized gains and losses and these can be quite variable). The only entries you normally make to equity as Stephen said are when you enter the opening balances of your assets and liabilities and if you close the temporary equity (Income and Expenses) accounts to equity ( this is not necessary in GnuCash but may be for external accounting procedural purposes). The transactions to add the value of an existing asset is normally: 1. a debit to the asset account for the present value of the asset and 2. a credit entry to the equity opening balances account (or an appropriate subaccount of the opening balances for that specific asset if you require that level of detail) and to add a liability 1. a credit to the liability account recording the liability and 2.a debit to the opening balances sub account of equity (or again a sub account of that depending on the detail you require, i.e. if you need to know the equity you have in specific assets. These are the individual lines (or splits) of a single transaction. If you select View->Auto Split Ledger from the menu then each transaction in a register of an account will open up to display the individual lines/splits composing it. See https://code.gnucash.org/docs/C/gnucash-guide/chapter_basics.html for a very basic introduction to accounting. The Wikipedia articles on Double Entry, debits and Credits and basic accounting are pretty good as well. Otherwise a reasonably recent second hand textbook on financial accounting is a good investment for the basics. David Cousens - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Hidden accounts appear in popups
The documentation says that, "The check box Hidden marks this account (and any sub-accounts) to be hidden in the account tree and not appear in the pop-up account list in the register." However, hidden accounts are still appearing in the account pop-up for me (version 4.4). Is this a known bug? I read about marking all of the hidden accounts with placeholder, but this is a pain. It also appears you still have to mark all subaccounts as hidden and placeholder as well, which is a pain. One click on the Hidden box in the parent account should be all it takes to make the account go away until summoned by the Filter By > Other > Show hidden accounts option. -- Bill Wohler aka http://www.newt.com/wohler/, GnuPG ID:610BD9AD ___ 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
Richard, For your first lesson, GnuCash developers don't accept personal emails. All communications goes through the lists. Second lesson: Everything you're asking is already explained in the 3 or 4 threads about USAA, one on gnucash-user and the other on gnucash-devel. I'll summarize them on https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings soon. Regards, John Ralls > On Feb 14, 2021, at 3:44 PM, Richard wrote: > > John, > > I read your message on the GNUCash digest email. I am brand new to gnu so I > have a lot to learn. > > Having said that, when I am trying to establish a connection to download my > transactions, I do not know which selections to make when creating a new user. > > Can you clue me in on the steps. > > I am also a Quicken user and I am trying to migrate away from it. I have > spent days trying to get Quicken and USAA to fix account download issues. > > Both tech supports are weak at best. > > Turns out USAA without telling customers ahead of time just change the user > ID and issued their own password. Don't know if that is going to be an issue > with the GNUcash app or not. Guess I will be finding out > > > > Thanks for any help you may offer, > > 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.
[GNC] Migrating to Linux Mint
Hi Frank As I mentioned previously I am using GnuCash, the portable version, in windows and with your help I was able to very quickly migrate to V4.4 while keeping my older version intact. The nice thing about portable apps is one folder for each version. so copy one file and easy peasy I am up and running in V4.4. As I also mentioned I am migrating to Linux. I am still not far on the learning curve but am able to l use linux for 90% of my computing needs. On linux GnuCash is installed as a flapack, unfortunately that choice is least like portable apps compared to Snap or AppImage. Which means I can not figure out where to put my GnuCash file. Anny help with this would be much appreciated. Thanks PS how do I let everybody else see this ‐‐‐ Original Message ‐‐‐ On Monday, January 18, 2021 5:06 PM, Frank H. Ellenberger wrote: > I assume others are intersted in the answer, too. > > Weitergeleitete Nachricht > Betreff: Re: [GNC] Upgrade from portable 2.6 to 4.4 > Datum: Mon, 18 Jan 2021 23:52:56 + > Von: W. Michael Schoel sch...@protonmail.com > Antwort an: W. Michael Schoel sch...@protonmail.com > An: Frank H. Ellenberger frank.h.ellenber...@gmail.com > > Hi Frank > I responding to a message regarding windows that recommended against > using the portable version. I proceeded with the portable version > without problem and was suggesting that portable and the linux > equivelants were my preference because of simpler maintenance. I > mentioned Appimage to avoid the Snap Flatpack tension. I use all three > and because I use linux mint I first go to Flatpack. > Gnucash Flatpack was installed while writing this > > Best > Michael > > ‐‐‐ Original Message ‐‐‐ > On Monday, January 18, 2021 4:28 PM, Frank H. Ellenberger > frank.h.ellenber...@gmail.com wrote: > > > Hello Michael, > > Am 18.01.21 um 20:41 schrieb John Ralls: > > > > > On Jan 18, 2021, at 9:58 AM, W. Michael Schoel sch...@protonmail.com > > > wrote: > > > > : > > > > > > I have no appreciation of the effort required but it would be nice if > > > > GnuCash fully adopted the Portable and AppImage approach. > > > > what is wrong with Flatpak, seehttps://wiki.gnucash.org/wiki/Flatpak ? > > 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. > ___ 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
Likewise: sudo apt install libgwengui-gtk3 libgwengui-gtk3-dev Reading package lists... Done Building dependency tree Reading state information... Done E: Unable to locate package libgwengui-gtk3 On 2/14/21 2:53 PM, Stephen M. Butler wrote: to whoever is maintaining the https://wiki.gnucash.org/wiki/Installing_Dependencies page. On Ubuntu 20.10, I got this message while installing the packages for AQ Banking. Wiki may need a note regarding building on 20.10 sudo apt install gwenhywfar-tools libgwenhywfar60 libgwenhywfar60-dev Reading package lists... Done Building dependency tree Reading state information... Done Package libgwenhywfar60-dev is not available, but is referred to by another package. This may mean that the package is missing, has been obsoleted, or is only available from another source However the following packages replace it: libgwenhywfar-core-dev libgwengui-qt5-dev libgwengui-fox16-dev E: Package 'libgwenhywfar60-dev' has no installation candidate -- 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.
[GNC] Dependency Page
to whoever is maintaining the https://wiki.gnucash.org/wiki/Installing_Dependencies page. On Ubuntu 20.10, I got this message while installing the packages for AQ Banking. Wiki may need a note regarding building on 20.10 sudo apt install gwenhywfar-tools libgwenhywfar60 libgwenhywfar60-dev Reading package lists... Done Building dependency tree Reading state information... Done Package libgwenhywfar60-dev is not available, but is referred to by another package. This may mean that the package is missing, has been obsoleted, or is only available from another source However the following packages replace it: libgwenhywfar-core-dev libgwengui-qt5-dev libgwengui-fox16-dev E: Package 'libgwenhywfar60-dev' has no installation candidate -- 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] Asset vs Equity accounts?
On 2/14/21 1: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!! ;) I know the feeling. Though I have had no "formal" training, my wife has been trained as an accountant. So, let me try to simplify things: 1. Equity -- it happens. Usually you don't do anything to this except in rare instances (such as year end closing of books -- if you need to do that). You will want an "Equity:OpeningBalance" account for the initial transaction that sets up all the opening balances. It will be whatever is left over after setting the opening balance for all the Asset and Liability accounts. You may not want or need an "Equity:RetainedEarnings" account. I have one since I like to close the books at the end of the year. It isn't needed and a lot of folks don't. GnC will handle reports properly either way. 2. Assets -- if you own even a tiny piece of it, it goes here. If you owe a portion then we'll make a second account for it over in Liabilities. Group your assets into logical groups -- like all your accounts at bank X would go into ASSETS:BANKX: (where is Checking, Saving, CD, Money Market -- the various accounts that contain your money. Remember to track CASH as an asset also. House -- it's the purchase price plus any additions you have made over the years -- your account will give you better advice. Vehicles -- what you paid to buy them. If other people owe you money, that would be tracked in an asset account (Loan to Cousin Joe) 3. Liabilities -- what you owe. Car loans. House Mortgage. Credit Card (even when paid off each month), etc. 4. Income -- any money that comes to you whether you will be taxed on it or not. "But", you say, "My paycheck went into the checking account." Yup, you are right. But GnC is a "Double Entry" book keeping system. So, the other side of that transaction for the paycheck is Income (and most likely some expenses). The net goes into "Assets:BankX:Checking" while the gross is in "Income:MyWorkPlace" and any deductions go into "Expense:z" where are for the various deductions your employer takes out. 5. Expenses -- money that went out to buy things (if it went out to reduce a liability then it isn't an expense). Now, I've probably given you too much to think about right now. Feel free to ask further and others may jump in to help clarify things. Don't try to eat the entire elephant at one sitting. -- 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.
[GNC] Asset vs Equity accounts?
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.
[GNC] Fwd: Setup for downloading transactions for a financial institution
Please reply to all. As I implied in my previous email, I cannot help with online access. -- Forwarded message - From: Richard Date: Sun, Feb 14, 2021, 2:29 PM Subject: Re: [GNC] Setup for downloading transactions for a financial institution To: David Carlson Thanks for the quick reply David. I am looking to see if setup for USAA, US Bank, Chase, etc. You wrote below that I can ask specific questions here about specific institutions. How does that work? On 2/14/2021 3:23 PM, David Carlson wrote: Richard, Welcome to the GnuCash User email. Regarding the column labels, there are some options in various places. One is under Edit > Preferences > Accounts, but there are also some others scattered around that change depending on whether you are using single line or two line view and Basic Ledger, Auto-Split Ledger or Transaction Journal view, for example. One notable point for converts from Quicken is that GnuCash calls incomes and expenses accounts instead of categories, and all transactions have transfers to and from other accounts in double entry bookkeeping. As for the online setup, that may or may not work with your financial institutions, I didn't get it to work with any of mine so I do a manual export from the online presence and manually import the data into GnuCash. I can use the QFX/OFX format with most of my banks. You can ask specific questions here about setup with specific institutions. On Sun, Feb 14, 2021 at 1:36 PM Richard via gnucash-user < gnucash-user@gnucash.org> wrote: > I am a new user. I have a few questions. > > Is there any way to change the column label on the account transaction > display? Currently one of my columns is labeled Transfer. The items in > that column are actually transaction categories. > > Next, when I attempted to link an account with a financial institution > via the online setup wizard, the setup asked to select ECIBS or one of 4 > other options. I am not familiar with any of these options. Could > someone please help me understand what these are or suggest which on to > used > > Thanks, > > 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. > -- 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] Setup for downloading transactions for a financial institution
Richard, Welcome to the GnuCash User email. Regarding the column labels, there are some options in various places. One is under Edit > Preferences > Accounts, but there are also some others scattered around that change depending on whether you are using single line or two line view and Basic Ledger, Auto-Split Ledger or Transaction Journal view, for example. One notable point for converts from Quicken is that GnuCash calls incomes and expenses accounts instead of categories, and all transactions have transfers to and from other accounts in double entry bookkeeping. As for the online setup, that may or may not work with your financial institutions, I didn't get it to work with any of mine so I do a manual export from the online presence and manually import the data into GnuCash. I can use the QFX/OFX format with most of my banks. You can ask specific questions here about setup with specific institutions. On Sun, Feb 14, 2021 at 1:36 PM Richard via gnucash-user < gnucash-user@gnucash.org> wrote: > I am a new user. I have a few questions. > > Is there any way to change the column label on the account transaction > display? Currently one of my columns is labeled Transfer. The items in > that column are actually transaction categories. > > Next, when I attempted to link an account with a financial institution > via the online setup wizard, the setup asked to select ECIBS or one of 4 > other options. I am not familiar with any of these options. Could > someone please help me understand what these are or suggest which on to > used > > Thanks, > > 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. > -- 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...
Robert, I just fired up a copy of release 2.6.18 in Ubuntu 18.04. I did notice that there are mouse fly-over descriptions for toolbar icons. I did not find that option to show text with the icons, which I thought was still there. One other possibility would be to check out Gnome Tweaks, but I do not know how to use them. On Sun, Feb 14, 2021 at 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... > > -- > Robert Heller -- 978-544-6933 > Deepwoods Software-- Custom Software Services > http://www.deepsoft.com/ -- Linux Administration Services > hel...@deepsoft.com -- Webhosting Services > > ___ > 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.
[GNC] Setup for downloading transactions for a financial institution
I am a new user. I have a few questions. Is there any way to change the column label on the account transaction display? Currently one of my columns is labeled Transfer. The items in that column are actually transaction categories. Next, when I attempted to link an account with a financial institution via the online setup wizard, the setup asked to select ECIBS or one of 4 other options. I am not familiar with any of these options. Could someone please help me understand what these are or suggest which on to used Thanks, 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.
[GNC] UI question about 2.6...
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... -- Robert Heller -- 978-544-6933 Deepwoods Software-- Custom Software Services http://www.deepsoft.com/ -- Linux Administration Services hel...@deepsoft.com -- Webhosting Services ___ 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
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] Tab Rendering Flaw
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 > 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. >> > 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. >> > ___ 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] Minor issue with invoice layout
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). Thank you. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user 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
Additionally, I might suggest duplicating transactions for the dates in question. I do that all the time to catch up in accounts I rarely check. It's quite easy then to modify as needed. David T. Original Message From: David H Sent: Sun Feb 14 01:26:28 EST 2021 To: bdp3 Cc: gnucash-u...@lists.gnucash.org, adrien.montele...@lusfiber.net Subject: Re: [GNC] Scheduled Transactions A couple of things that might assist... 1. Right click on any txn and click Schedule down near the bottom of the context menu to create a scheduled txn from an existing txn. 2. Use the Actions >> Scheduled Transactions >> Since Last Run... menu item to do a manual catchup run if you've setup a scheduled txn that has txn's to be created that are prior to today + the create in advance period. I've always found it easier to delete the wrong scheduled txn and create a new one using item 1 above as it seems to remember the last run date/next occurrence due and doesn't seem to fire if I try updating the old scheduled txn. Cheers David H. On Sun, 14 Feb 2021 at 15:04, bdp3 wrote: > Thank you Adrien! > > 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? > > Thanks for your help! > BDP > > > On 2/13/21, 7:25 AM, "gnucash-user on behalf of Adrien Monteleone" > adrien.montele...@lusfiber.net> wrote: > > On 2/12/21 9:50 PM, bdp3 wrote: > > > Questions: > > How can the Scheduled be re-run for prior periods? Can this be > done? How? Is it necessary to delete the Schedule and start all over with > a new one? > > > Maybe, but if you have to re-create the SX (Scheduled Transaction) and > delete the current one, that isn't too painful. (unless you have lots > of > SX in play for this case) > > > The Schedule in question is basically a distribution of salary costs > and benefits, may of which are direct percentage relations to salary. Is > it possible to enter formulas into the Schedule in such a way that all/most > split-accounts are updated simply by changing the salary amount? > > Yes, I've done that when trying to work out an 'envelope method' for > savings. > > Use a variable in each split and name it something useful, like > "net_pay", then use a multiplier for the distribution: > > net_pay*.0125, e.g. to set that split equal to 1.25% of net_pay > > You'll want to carefully make sure your distributions add up to 100% > of > net_pay or you'll end up with an Imbalance split. (which you can > always > manually fix upon creation) > > When the SX fires, you'll see a prompt to enter a value for 'net_pay', > then the SX will dutifully calculate and fill in the splits for you. > > I highly recommend to always tick the box to "Review created > transactions", to make sure you don't have a rounding error creating > an > Imbalance split. > > 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. > > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.