Re: [GNC] Accounting FOr Beneficiary Income
On 1/31/20 10:48 AM, Dave Gilmore wrote: > Hello all, > > My mom recently passed away and I am the sole beneficiary on all of > her assets. I am wondering how to setup and record few scenarios. > > 1. She had a traditional IRA account that she was receiving > disbursements from. I worked with the broker and just rolled all of > the accounts into my name. So, now I have this money that was given to > me and I didn't pay into. I have to continue receiving disbursements > from this account every year. Because this is a traditional IRA, I > have to pay taxes on this income. Because of this, should I set the > IRA account as some sort of equity that I can get income from and pay > taxes on? I tried setting it up as an investment asset, but I couldn't > then make an income transaction. I think I need to reflect this as > income due to the taxes being taken out. Otherwise it would just be a > transfer between asset accounts. How should I set this up? > > 2. As I am closing out some of her accounts (utilities, insurance, > cable, etc) she is being issued a refund. Which is being paid to me. > Should I just list this as "other income". Technically it is a refund, > but I did not make the original expense to be refunded for > > Thanks! > > Dave Gilmore Only your local CPA can provide the correct answer for you. Once you know how s/he wants it recorded, we can then help you setup the accounts and enter the transactions. -- 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] Apple Card csv
On 2/3/20 8:44 AM, Keith Bellairs wrote: > I have been using GNC for a long, long time. So I have an account for each > of my credit cards. I can update the accounts with ofx/qfx downloads. I see > that Apple only allows csv downloads from that card. I have never used the > csv upload to GNC. Does anyone have experience with Apple's csv files? If > they don't upload cleanly that's a deal breaker for me. > > Keith Not Apple's but I do have experience with CSV and Citi. Under 3.7 I was able to define the layouts (what fields went where and the date format) and save that for future use. Also defined the "home" account (in my case, Liabilities:CreditCard:Citi). My only problem is that they also changed the sign of the payment AND put it in the other column. So the load routine dutifully turned it into a charge instead of a payment. I think options were added to 3.8 to allow you to override this. Perhaps load both fields to the same "column" in the account. I finally located where Citi hid their OFX download and switched back to that to cure having to fix the payment sign each download. --Steve -- 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] Loan with overpayments
On 2/21/20 8:56 AM, Claire via gnucash-user wrote: > Hello > I have a loan at a fixed interest rate and was planning to use "Loan and > Mortgage Repayment...". However I do have the option to make overpayments. > I checked this mailing list and there was a thread regarding mortgages in > 2013 which said that the SX uses the original amount to calculate interest > not the current balance. Is this still the case? > If that is the case is there any manual workaround I can do to get it to > calculate the interest correctly? > Claire I get a statement each month in advance that shows the interest portion applicable to the next payment (it also shows the amount going to principle and the escrow amount). So I manually update the scheduled transaction each month. If I forget, it is simple to go back to the posted transaction and edit it also. The statement also shows the amounts applied from the last payment along with the resulting balance. This allows me to cross check my version of the balance (loan and escrow) to verify all is correct on my side. So, this is the manual work around. Although it doesn't calculate the interest for you, it does allow you to use what the lender states is the interest they will charge for that payment. Now, if you don't get a monthly statement -- you will need to set up a loan amortization schedule in a spread sheet with a column for the extra payments. I've find that I'm usually right on and always within a penny of what the bank/lender calculates (unless they use the actual days to when the payment was applied). However, most lenders will use a standard month. --Steve -- 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] how to delete a new file
If in the Journal rather than a specific account register, the balance will always be zero since each transaction is always balanced. On 1/9/20 12:03 AM, Adrien Monteleone wrote: > I’m not sure what screen you are viewing but there should be a balance column > for every transaction in every account register. > > However, you do not enter the balance. > > GnuCash calculates it for you. > > There probably is no need to start all over, but if you must, simply delete > the data file after you’ve closed the program. The next time you start, > GnuCash will open with a blank book, which you’ll need to set up again. > > You can also use the File > New File option which will open a blank book, and > you retain the original should you decide to not delete it quite yet. > > >> On Jan 8, 2020 w2d8, at 3:51 PM, Harvey Moxness wrote: >> >> I hope someone can help I am new to gnu/cash and trying to set up a simple >> bookkeeping file, as a chequebook. When i get to the point of entering >> transactions, there is no space for "balance" at the end of the entry line. >> So I must have started the set-up procedure wrong, as the tutorial pictures >> show a balance at the end of each transaction. I would like to delete the >> whole project that I have started, and start again, but I don't see how to >> do that. I have used Quicken for years, but Microsoft is dumping its >> Windows 7, which is the only version I was able to use the Cash Manager 2015 >> on. Thank you. Harvey Moxness > ___ > 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] Mortgage & Loan Repayment schedule tool
On 1/11/20 12:26 PM, Michael or Penny Novack wrote: > Do not fault the tool if it does not agree with the bank. I have > written these things. There are simply too many assumption about how > to do the calculation, where to round off, etc. << I ended up with a > fancy version that allowed instructions where to adjust that could get > agreement to a penny BUT it was not strictly speaking a "function" (a > calculation) but a process using a repeated "trial and error" approach > not unlike Newton's Method --- lenders frequently charge for an > "amortization table" and I wanted to have that to be able to make > additional payments of principle*. > > As for escrow amount calculation, this is really tricky. The bank will > set an amount to fund an amount that will not only be sufficient to > pay the taxes and insurance bills over the year but will do so on a > "cash flow" basis. In other words, the fund will always have enough in > it to meet these bills when they are due. The bank will recalculate > ever year but based on the dates of the expected bills will tend to > fluctuate more wildly than you expect**. I never wrote one of these, > but again, a good candidate for repeated "trial and error*" > > Michael D Novack > > > * If the amount you send in is the exact amount of the principle > portion of the following payment then you can cross that payment off > -- in effect you are jumping closer to the end of the mortgage. > Especially when interest rates are high, as they were at the time, in > early years you can cheaply buy time off the end of the mortgage. > > **( In other words, given an initial balance (in escrow) and making a > series of payments at specified dates (the tax and insurance due dates > and amounts) what is the least monthly input (or biweekly if that's > what the mortgage payments are) that will prevent the escrow amount > from going minus.) In my experience, some banks use a standard 30 day month and 360 day year and are more easily matched by monthly calculations. Other banks use the actual number of days between payments (and whoa is you if the post office delays a day or two in delivery) and adjust the interest due accordingly. Those are impossible to predict in advance. So, I end up building a rough standard transaction and update it monthly based on statements from the bank. Sometimes I can update the scheduled transaction before it gets applied (those that assume a standard 30 day month or 1/12 of the annual interest rate). Others I have to update the posted transaction after the fact. Your bank might do something different. --Steve -- 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] Mortgage & Loan Repayment schedule tool
On 1/11/20 1:52 PM, Don Ireland wrote: > Thanks. I really understood that -- there are lots of variables that can > alter the interest versus principal portions of rhe payment (such as thr > payment was processed at the bank on the 15th but you entered it into the > system on the 20th. You now have 5 extra days of interest). > > But that's not what I was asking about. I'll say it again. The recurring > transactions created by the tool created transactions crediting the escrow > account for the insurance & taxes and debiting the escrow account to transfer > the money to the taxes and insurance accounts. So now the total amount it > takes from the account is equal to JUST THE P > > I ended up fixing it by entering it manually. Same here. My standard transaction just shows the money going to the bank (principle, interest, escrow). Then when the bank statement shows they paid the taxes/insurance, then I manually enter a transaction taking the money out of the escrow account (an asset BTW) and moving it to the correct expense account. -- 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] Owner Contributions & Distributions
I do both. I have a sole proprietorship that shares the same books with my personal activities. At least in this state (Washington, USA), it is just me doing business using a trade name. But, the trade name and I are the same legal entity. In that case I just opened another checking account at my credit union that is accessed via the same login as my other personal accounts. In GnC, I just set that up as another checking account under the same parent asset account as my other accounts (checking, savings, money market, etc). So, I can just move money between them and all is good as long as I make the same transfer in GnC. I also have an LLC that my wife co-owns with her business associate. That has it's own set up books. In my personal books I set that up as an Asset account to which I add money as needed. When the time comes I'll be able to draw money out of that asset. On the LLC set of books my accounts show up in their Equity as Ownership entries. When they pay me they have to decide if they are reimbursing me for some reimbursable expense, paying me for some work I did, or paying dividends. That affects how the LLC books enter the transactions. Likewise, in my books I have to make similar entries (reimbursable expenses are booked on my side as an Asset:Reimbursable (for one side of the split). When I get paid it offsets that value (returns it toward zero) transferring that asset to Checking (if I deposited it). Payment for work done simply becomes an income account with the other side going to my checking (just as for any other work I do). Dividends -- well, they haven't paid any yet! So I haven't had to figure that one out. But it should be like dividends from any other stock (or CD or interest bearing account) that you own. Hope this helps. --Steve On 1/17/20 2:40 PM, Don Ireland wrote: > I wasn't planning to as I think that would really really complicate > the books. > > On January 17, 2020 4:26:06 PM CST, "Stephen M. Butler" > wrote: > > Are you mixing your personal and business in the same GnuCash file? > > > > On 1/17/20 2:07 PM, Don Ireland wrote: > > What I was referring to is the checking account I use for my > business. When I make what the bank sees as a deposit, I need > to account for it in my books. My books includes an asset > account called Business Checking. Wouldn't that deposit be > considered a credit? Based on what you've described, it sounds > like you'd treat it as a debit. I need to account for moving > money from my personal checking account into the business > account. I entered it in to my personal check register. Now I > need to separately account for it in the business books. On > January 17, 2020 3:50:03 PM CST, Adrien Monteleone > wrote: > > Speak to a local CPA for details for your situation and > jurisdiction, but from what you can find in a basic > accounting text book, generally both contributions > (capital investments) and distributions (draws) are equity > accounts. The tree would look something like this: Equity > |_Opening Balances (already exists) |_Owner’s Equity > |_Investments |_Capital Investments |_Reimbursements > |_Earnings |_Dividendscurl > > 'https://tangerine-tulip-8sj7.squarespace.com/api/commerce/orders/export?orderStates=PENDING%2CFULFILLED%2CCANCELLED===false=2018-11-23T19%3A14%3A03.056Z=2020-01-18T07%3A59%3A59.999Z' > -H 'User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; > rv:72.0) Gecko/20100101 Firefox/72.0' -H 'Accept: > > text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8' > -H 'Accept-Language: en-US,en;q=0.5' --compressed -H 'DNT: > 1' -H 'Connection: keep-alive' -H 'Referer: > > https://tangerine-tulip-8sj7.squarespace.com/config/commerce/orders' > -H 'Cookie: SS_MID=8eaefbac-45bf-4f31-8e67-ecc1c580eee1; > IR_gbd=squarespace.com; > IR_9084=1579299517019%7Cc-13076%7C1579299109123%7C%7C; > IR_PI=5b9f1e10-3976-11ea-b100-061034f1b114%7C1579385509123; > SS_ANALYTICS_ID=3ea228cc-4cf5-459f-9904-1d3b25f624e4; > __zlcmid=wIiqRZHeptxSLP; > SS_SESSION_ID=60b42e4b-16ea-40bb-b7a1-ca6b35d6854b; > > SS_MATTR=eyJ2IjoyLCJhIjpbImRpcmVjdCIsIiIsIiIsIiIsIiJdLCJkIjoiMjAyMC0wMS0xNyAyMjoxNjo1Ni45MDMifQ==; > _gcl_au=1.1.630127523.1579299418; > crumb=saTUnBhE+Dsv6Ojy4pfcPfWTsV3cFqNAmWFw3A4aX5OJ; > > member-session=1|mGHszCC84SpEsx9ZVB6XLEQ53+ZaAU0FoudlR6i7A1tG|syPynu+Bf+W893cf1LdoKDTxzfTAz9XXOi0+MUG4Z6Y=; > > ss_lastid=
Re: [GNC] Owner Contributions & Distributions
cPfWTsV3cFqNAmWFw3A4aX5OJ; >> member-session=1|mGHszCC84SpEsx9ZVB6XLEQ53+ZaAU0FoudlR6i7A1tG|syPynu+Bf+W893cf1LdoKDTxzfTAz9XXOi0+MUG4Z6Y=; >> ss_lastid=eyJpZGVudGlmaWVyIjoidGFuZ2VyaW5lLXR1bGlwLThzajcifQ%3D%3D' -H >> 'Upgrade-Insecure-Requests: 1' -H 'TE: Trailers' >> >> If this is a distribution of profits, (and not just a draw) then you’d >> use the Dividends account: >> >> Dr. Equity:Owner’s Equity:Earnings:Dividends >> Cr. Cash/Checking, etc. >> >> >> This will keep all of these transactions in the Equity part of the >> tree. They will not affect Income or Expenses, but they will affect >> assets as money is put into the business or taken out. >> >> Note that Capital Investments don’t decrease as you take Draws or >> Dividends, and nothing ever decreases the Draws or Dividends, but all >> three affect the parent account "Owner’s Equity” balance appropriately. >> The Earnings & Draws parts of the tree will generally have ’positive’ >> sign balances if you aren’t reverse balancing accounts, or ’negative’ >> sign balances if you are. (for all credit accounts) This is because >> those two accounts are ‘contra’ accounts from normal Equity type >> accounts, meaning they will have the opposite balance expected for >> Equity, that is, a debit balance is normal, instead of a credit balance >> as normal. >> >> But certainly, how this is setup or done is entirely dependent on your >> exact form of your business and legal situation and requirements, which >> is why you should really, really, really get a local CPAs advice. >> >> Regards, >> Adrien >> >> p.s. - though it may not matter since you might not be using such a >> transaction, your below example of depositing money into a checking >> account wouldn’t be a credit to it. As you are increasing an asset, it >> would be a debit for that side of the transaction. >> >> >>> On Jan 17, 2020 w3d17, at 3:17 PM, Don Ireland >> wrote: >>> I'm having trouble figuring out the best way to handle owner >> contributions and distributions in gnucash. I understand them in >> concept but I'm just confused as to how the accounts get set up. >>> My 1st thought was to create an asset account called Owner >> Contributions and another called Distributions. But then when when I >> take Distributions, unless I take the funds from this contributions >> account, it'll just continue to grow. >>> Plus when I credit this account but deposit the money in the checking >> account, gnucash would see both as credits. So then I thought maybe >> it's a liability account but that still leaves the question as to >> separating the contributions and distributions. >>> Do I create one account called Contributions & Distributions and >> credit/debit this single account? Is it a liability account? >>> Don Ireland >> ___ >> 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.curl >> 'https://tangerine-tulip-8sj7.squarespace.com/api/commerce/orders/export?orderStates=PENDING%2CFULFILLED%2CCANCELLED===false=2018-11-23T19%3A14%3A03.056Z=2020-01-18T07%3A59%3A59.999Z' >> -H 'User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:72.0) >> Gecko/20100101 Firefox/72.0' -H 'Accept: >> text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8' >> -H 'Accept-Language: en-US,en;q=0.5' --compressed -H 'DNT: 1' -H >> 'Connection: keep-alive' -H 'Referer: >> https://tangerine-tulip-8sj7.squarespace.com/config/commerce/orders' -H >> 'Cookie: SS_MID=8eaefbac-45bf-4f31-8e67-ecc1c580eee1; >> IR_gbd=squarespace.com; >> IR_9084=1579299517019%7Cc-13076%7C1579299109123%7C%7C; >> IR_PI=5b9f1e10-3976-11ea-b100-061034f1b114%7C1579385509123; >> SS_ANALYTICS_ID=3ea228cc-4cf5-459f-9904-1d3b25f624e4; >> __zlcmid=wIiqRZHeptxSLP; SS_SESSION_ID=60b42e4b-16ea-40bb-b7a1-ca6b35d6854b; >> SS_MATTR=eyJ2IjoyLCJhIjpbImRpcmVjdCIsIiIsIiIsIiIsIiJdLCJkIjoiMjAyMC0wMS0xNyAyMjoxNjo1Ni45MDMifQ==; >> _gcl_au=1.1.630127523.1579299418; >> crumb=saTUnBhE+Dsv6Ojy4pfcPfWTsV3cFqNAmWFw3A4aX5OJ; >> member-session=1|mGHszCC84SpEsx9ZVB6XLEQ53+ZaAU0FoudlR6i7A1tG|syPynu+Bf+W893cf1LdoKDTxzfTAz9XXOi0+MUG4Z6Y=; >> ss_lastid=eyJpZGVudGlmaWVyIjoidGFuZ2VyaW5lLXR1bGlwLThzajcifQ%3D%3D' -H >> 'Upgrade-Insecure-Requests: 1' -H 'TE: Trailers' >> --
Re: [GNC] Sales Tax Report
On 1/19/20 10:22 AM, Keith Fetterman wrote: > Adrien, > > Thanks for the help. w > > In the state of Washington, we need to report the local city/county sales tax > for each physical location we do work in. The state assigns a tax code based > on address. The business is a very small landscaping business that only does > work in a few local locations, so fortunately there are not many tax codes to > keep track of. > > I have created a tax table for each tax code and assigned it to a customer. > This works because the physical work locations are the customers’ homes. If > work done in a different location, it’s almost always in the same area. > > I see what you mean about creating a sub account for each custom location. > In general, this could become very large. Your suggestion of using filters > is a good one. I hadn’t thought of it. But, it doesn’t appear that you add > notes to the memo lines of an invoice. I tested adding a note in the invoice > to see if it would appear in the memo line in AR. It doesn’t. The invoice > transaction in the AR is locked so you can not edit the memo lines. > > The ideal solution is a report of taxable sales by tax table. > > Thanks, > Keith > Keith, I also have a small business in Washington State that mails product to the buyers (very small amount of personal sales handed "over the counter"). I built a SQLite3 database to track the individual orders along with the State and Local jurisdiction collected taxes. It is just too complicated to keep track in GnC. For 2020Q1 there are 476 distinct local jurisdictions and 1,185,337 address locators in the states downloadable files. In two cases, the same block-face (same zip + zip-4) has different location codes based on the house number. However, the hosting site (Squarespace) will only apply taxes at the zip code level of which there are 716 different zip codes in the state. Thankfully I don't have "presence" in any other state (yet). Also, thankfully, I can download the orders direct from the web site in CSV format. I only have to manually add the very few OTC sales. --Steve -- 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] Sales Tax Report
On 1/19/20 12:13 PM, Michael or Penny Novack wrote: > On 1/19/2020 2:07 PM, Stephen M. Butler wrote: > >> Just this quarter (starting 1 Jan 2020) the State of Washington added >> some Idaho zip codes to its list of taxable zip codes. These are for >> houses in Washington State that get their mail via an Idaho post >> office. [ Note, Washington State is one of those that tax sales upon >> the delivered to address. ] >> > I think that legally, almost all do. But in the example you just gave, > are ALL houses in these "taxable Idaho zip codes" in Washington? In > that case you are lucky. In the more general case, those Idaho zip > codes would also include houses that are in Idaho. > > Note that this is early days of enforcement of sales tax for mail and > internet sales. Not yet time for cases to work their way through the > courts of people claiming wrongfully taxed or states suing states > because they argue the tax collected should be theirs. > > Michael D Novack Nobody in that zip code has ordered product yet. So I don't know what the "mailing address" will actually show. If they claim their "mailing address" is Idaho, I'll not collect. Now, I do a post process that looks at the address to figure out what I should have collected (so I can split local codes that share a common zip code). Will be interesting to see as the business grows. I do ship rather than visit. -- 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] Sales Tax Report
On 1/18/20 6:19 PM, Michael or Penny Novack wrote: > On 1/18/2020 5:25 PM, Keith Fetterman wrote: > >> I need to file an end of year sales tax report to the state showing >> the sales by tax code. I created a tax table for each customer’s >> city and assigned the entries to the customers. . > > > I'm going to ask you a scary question, Keith. How do you KNOW the > customer's city/state for legal purposes? Are you keeping that data? > The PHYSICAL location (city/state) as opposed to the city/state/zip of > the post office that delivers mail to that location. Postal routes do > NOT respect state boundaries. > > Of course you would be in good company with perhaps the majority of > businesses making mistakes with addresses close to state boundaries. > > Michael Just this quarter (starting 1 Jan 2020) the State of Washington added some Idaho zip codes to its list of taxable zip codes. These are for houses in Washington State that get their mail via an Idaho post office. [ Note, Washington State is one of those that tax sales upon the delivered to address. ] -- 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] Transfers to subaccounts, hide the transaction?
On 3/8/20 3:07 PM, Nate Bargmann wrote: > This is a bit complicated, of course! > > I have a main checking account with a number of subaccounts. So far so > good as it is a concept that is working well. After a couple of months > of this I can see some things becoming unwieldy, particularly when > reconciling as I have numerous "transfer" transactions that will never > be reconciled. In a nutshell, what I have is this. > > Deposit entry, all or part of which should be assigned to a designated > subaccount. This, of course shows as coming from an Income account and > then into the checking account. > > Transfer entry, whatever amount needs to be assigned to the subaccount > is deducted from the main checking account and applied to the > subaccount. > > The transfer entries would be nice to hide or eliminate. I tried > combining one into a deposit entry and that created a second deposit > entry that mirrored the original but with differing amounts. I > scratched that idea rather quickly! > > If there is no other clean way to do this, I wish I could at least avoid > having the Transfer transactions prior to the current reconciliation > time frame showing in the reconciliation dialog. I can see that by the > end of the year or a few years down the road that this is going to be a > huge mess! > > TIA > > - Nate Do you know at the time of entering the deposit which sub-accounts and amounts? If so, I would be tempted to deposit directly to the sub-accounts and then reconcile including all sub-accounts. While entering I would click on the reconciliation column and change it from an n to a c (just clicking will accomplish that). That way they are already check-marked when you do reconciliation. --Steve -- 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 signature.asc Description: OpenPGP digital signature ___ 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] Help Find Feature
On 3/8/20 11:14 AM, Adrien Monteleone wrote: > Per a previous post Gio noted the intent to delete *some* expense > transactions. AHA. Insight (to quote Martin Gardner). > > The example given was: > >> So example consider accountA. In it you would have transactions to/from: >> AccountB >> AccountC >> Expense:E >> Expense:F >> >> I want to be able to search so it will list Expense:E and F but NOT >> Accounts B and C. Then I can delete these expenses. > It still isn’t clear if the intent is to delete everything in Expense:E & > Expense:F or just those that also are split with AccountA. Well, there is that option to delete an entire account/sub-account. But that is drastic. Not as drastic as deleting everything! > > In the latter case, a proper Find operation I think is the fastest route, > deleting each one by one from that resulting list. (a search result that is, > not a report which does involve extra clicks as the OP noted.) > > Regards, > Adrien > > > >> On Mar 8, 2020 w11d68, at 12:48 PM, Stephen M. Butler wrote: >> >> Hmm. Did you say _every_ transaction involved in _all_ expense accounts? >> >> Open your file and save off a copy. >> >> Then on the Accounts tab, find the top-level Expenses account and >> highlight that. >> >> Click on Edit menu item and then on Delete Account. >> >> On the popup screen select the options to delete sub-accounts and to >> delete transactions. >> >> Click on the Delete button on the lower right corner. >> >> POOF -- all transactions involving an expense account are gone. So are >> all the Expense accounts! But you can add those back in as needed. > > ___ > 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] Help Find Feature
On 3/7/20 8:03 PM, Gio Bacareza wrote: > Thanks Tommy. This is a really interesting method and I can already think > of use cases. For my scenario though, as I mentioned earlier response, it > will add extra steps to what it is that I want to do. > > I want to be able to find transactions to/from expense accounts because I > need to delete them and I am looking for the fastest way to do that. Thanks > Hmm. Did you say _every_ transaction involved in _all_ expense accounts? Open your file and save off a copy. Then on the Accounts tab, find the top-level Expenses account and highlight that. Click on Edit menu item and then on Delete Account. On the popup screen select the options to delete sub-accounts and to delete transactions. Click on the Delete button on the lower right corner. POOF -- all transactions involving an expense account are gone. So are all the Expense accounts! But you can add those back in as needed. -- 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] hiding expense and income accounts with zero balances
On 3/7/20 8:13 AM, Ian D Henry wrote: > I am very new to Gnucash and I have not been able to find answers to > questions which I think possible ought to have easy answers. > > 1 Is there a way to suppress display of accounts with a zero balance in the > Balance Sheet and Income Statement? Yes. Click on Options in top menu, then click on the Display tab, and click on the option to suppress accounts with zero balance. > 2 How do I display either statement with a specific end date? For > example, today is 7March and I want to provide reports as at 29February. > The standard Income statement shows that it covers 1Jan20 to 30Jun20 and > the Balance Sheet is at 30Jun20. The accounting year is 1Jul19 to 30Jun20. Change the report options in the general tab to specify the date(s) you want. Balance sheet will only have ending date. Income statement will have both beginning and ending dates. > 3 Has anyone produced an multi column Income report that lists the income > and expense by month? Nope. Experiment and tell us what you find. > > Thank you in advance for your help. > > Ian > --Steve -- 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] Should i care about Unrealized Losses/Gain in Balance Sheet ?
While the non-profit I'm involved with does multi-currency transactions, ours is uni-directional and we don't treat it like an investment (stock). So I don't have experience handling this. My suspicion is that you will need to utilize trading accounts and treat your US bank as an investment which you buy and sell. But, I can't help you further than that. On 4/9/20 10:33 AM, Long wrote: > Hello, > > Picture here : replycomment-2.png > <http://gnucash.1415818.n4.nabble.com/file/t378901/replycomment-2.png> > > Regards. -- 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] Should i care about Unrealized Losses/Gain in Balance Sheet ?
Does your Profit/Loss report show zero profit/loss? On 4/9/20 10:13 AM, Long wrote: > Hello Stephen M. Butler, > > Here is my Picture : replycomment.png > <http://gnucash.1415818.n4.nabble.com/file/t378901/replycomment.png> > > Regards. > > > > -- > 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] Suggestion: add "balance" variable for scheduled transactions
I like it. Could you also add "days" as in the number of days from the last posting of this transaction until this posting (assume posting means "effective date of transaction". This would then allow the user to craft the interest based on number of days and the daily interest rate (fixed value known at time creating the scheduled transaction). Be sure the "interest" is rounded to the nearest penny and not left fraction of pennies. On 4/7/20 10:53 PM, jeanl wrote: > GC people! > The scheduled transaction editor has one special variable "i" which you can > use in your credit/debit formula, and counts how many times the transaction > has posted. > I'm suggesting to add a variable "balance" that would hold the value of the > account (see below for which) at the time the transaction posts. This > balance could then be used to compute interest, and other amounts that > depend on the current balance, within the scheduled transaction. > > The idea is to allow *simple* interest computations for basic fixed interest > mortgage loans that compound monthly (as is typically the case in the US, > but definitely not in the rest of the world). > Here's a typical example: You have a 4% interest rate on a mortgage with a > monthly payment of say $1000 (these have to be known in advance) > Each month the schedule transaction would transfer $1000 from your checking > account (for example) and split that into balance*0.04/12 toward an expense > account "mortgage interest" and 1000-balance*0.04/12 toward reducing the > mortgage account. "balance" would hold the current principal of the loan at > that date. > > This would easily handle mortgage extra payments: If you pay an extra $500 > in the middle of the month, that goes toward reducing the principal > (assuming that's how your bank handles it, but that's typical in the US) and > at the end of the month, the interests computed by the scheduled > transactions would be computed accurately according to the new loan balance. > > Again, all this works only if your interests are compounded monthly and not > daily. > The account the "balance" refers to would be automatically detected based on > the nature of the accounts present in the splits (i.e., it would ignore all > accounts except for the liability account, assuming there's only one). > > I understand this is far from perfect, and only applies to a subset of the > users, but for these I believe it could be quite useful. It happens to be > fairly easy to implement, which is why I'm suggesting it. > > I'm welcoming any feedback on this idea. > Jean > > > > -- > 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] Suggestion: add "balance" variable for scheduled transactions
On 4/8/20 11:19 AM, David Carlson wrote: > Have you reviewed > https://www.gnucash.org/viewdoc.phtml?rev=3=C=guide Not recently. I was a couple years into paying my mortgage when started using GnC. At that time I setup the scheduled transaction myself and noted that there was no way to get the current balance nor the number of days since last payment. Haven't reviewed the docs since. > > On Wed, Apr 8, 2020 at 1:13 PM Stephen M. Butler <mailto:kg...@arrl.net>> wrote: > > I like it. > > Could you also add "days" as in the number of days from the last > posting > of this transaction until this posting (assume posting means > "effective > date of transaction". This would then allow the user to craft the > interest based on number of days and the daily interest rate (fixed > value known at time creating the scheduled transaction). Be sure the > "interest" is rounded to the nearest penny and not left fraction > of pennies. > > On 4/7/20 10:53 PM, jeanl wrote: > > GC people! > > The scheduled transaction editor has one special variable "i" > which you can > > use in your credit/debit formula, and counts how many times the > transaction > > has posted. > > I'm suggesting to add a variable "balance" that would hold the > value of the > > account (see below for which) at the time the transaction posts. > This > > balance could then be used to compute interest, and other > amounts that > > depend on the current balance, within the scheduled transaction. > > > > The idea is to allow *simple* interest computations for basic > fixed interest > > mortgage loans that compound monthly (as is typically the case > in the US, > > but definitely not in the rest of the world). > > Here's a typical example: You have a 4% interest rate on a > mortgage with a > > monthly payment of say $1000 (these have to be known in advance) > > Each month the schedule transaction would transfer $1000 from > your checking > > account (for example) and split that into balance*0.04/12 toward > an expense > > account "mortgage interest" and 1000-balance*0.04/12 toward > reducing the > > mortgage account. "balance" would hold the current principal of > the loan at > > that date. > > > > This would easily handle mortgage extra payments: If you pay an > extra $500 > > in the middle of the month, that goes toward reducing the principal > > (assuming that's how your bank handles it, but that's typical in > the US) and > > at the end of the month, the interests computed by the scheduled > > transactions would be computed accurately according to the new > loan balance. > > > > Again, all this works only if your interests are compounded > monthly and not > > daily. > > The account the "balance" refers to would be automatically > detected based on > > the nature of the accounts present in the splits (i.e., it would > ignore all > > accounts except for the liability account, assuming there's only > one). > > > > I understand this is far from perfect, and only applies to a > subset of the > > users, but for these I believe it could be quite useful. It > happens to be > > fairly easy to implement, which is why I'm suggesting it. > > > > I'm welcoming any feedback on this idea. > > Jean > > > > > > > > -- > > Sent from: > http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org <mailto: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 <mailto:stephen.m.butle...@gmail.com> > kg...@arrl.net <mailto:kg...@arrl.net> > 253-350-0166 > --- > GnuPG Fingerprint: 8A25 9726 D439
Re: [GNC] Auto-delete imbalance with no value in split
On 4/9/20 1:55 PM, Håkon Fremstad wrote: > Hi > > Whenever I change the value of a split-transaction, I get an imbalance > with the difference. And after I fix the imbalance in the > split-transaction the imbalance stays there with no value. Is there a > way to make these empty imbalances disappear automatically to make > things neater? Do not hit the enter key after making the first change. Just tab or otherwise move the cursor to the other split that needs changed and make the appropriate change there. Doing it this way will open a split with no account name but with the value that would be "out of balance". You have the option then of giving that line an account name OR modifying another split line to absorb that difference. If you do modify the other split line, then the new line with the out of balance will go away (tab or otherwise move the cursor out of the amount field that you just modified). Only then (when all looks like it should) hit the enter key. Its the enter key that causes the modified transaction to be "committed." > > I've tried searching for my problem in the archives. The closest thing > I could find was > https://lists.gnucash.org/pipermail/gnucash-user/2017-January/068469.html > but I don't think it's exactly the thing I'm wondering about. > > > Thanks in advance, > > Håkon > > ___ > 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] Auto-delete imbalance with no value in split
On 4/9/20 11:13 PM, David Carlson wrote: > It would be nice if zero value imbalances would disappear automatically, > but they don't. The methods described in the reference that you found ae a > couple ways to get rid of them. I usually delete the Imbalance split line > from the asset or liability register where the transaction resides. Usually happens because you hit the enter key in the middle of making all the changes. I found (at least up through 3.7 on Ubuntu 19.10) that making all changes to all lines will remove that "extra" line that pops up after modifying the first split. Safe the enter key until it all looks good again. And yes, it would be nice that a "zero" split line would automatically be removed when the enter key is hit. This would be helpful when the enter key is hit in the middle of making changes. Keep on fixing the remaining lines and let that Imbalance line go back to zero and have it automatically disappear at the next enter key. Would be helpful also in those cases where a transaction sits for hours (days, weeks, months) with an unnoticed Imbalance split and you finally come back to fix it. Might be helpful just in general for any line that goes to a zero value (but I think some folks use those lines for other purposes so they might object). I would be fine if it only happened for the "Orphan" and "Imbalance" lines going to zero. > > On Fri, Apr 10, 2020 at 1:03 AM Håkon Fremstad wrote: > >> Hi >> >> Whenever I change the value of a split-transaction, I get an imbalance >> with the difference. And after I fix the imbalance in the >> split-transaction the imbalance stays there with no value. Is there a >> way to make these empty imbalances disappear automatically to make >> things neater? >> >> I've tried searching for my problem in the archives. The closest thing I >> could find was >> https://lists.gnucash.org/pipermail/gnucash-user/2017-January/068469.html >> but I don't think it's exactly the thing I'm wondering about. >> >> >> Thanks in advance, >> >> Håkon >> >> ___ >> 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] Should i care about Unrealized Losses/Gain in Balance Sheet ?
On 4/8/20 12:13 PM, Long wrote: > Hello, > > I have posted a topic about this, but that topic have been spammed. So i > created new one to resolve my question. > > First, i'm not an accounting, and trying to stay away accounting language, > trying to make anything to easier to understand for me, and who have the > same question like me. I urge you to learn at least the fundamentals about book keeping and accounting. > OK, my question is : > --- > I have 2 Bank accounts, one for my default currency, and other is USD in > GnuCash. In my real life, i usually buy USD by my VND, Then, I will sell USD > to get VND back. (included gold ... but i just want to talk about USD, it's > the same thing to do in GnuCash). > So, i setup the price database (GnuCash 3.9) for USD, i assume the rate is 1 > USD = 2 VND for first time i bought. So my accounts : > --- > Assets: 40 VND > -- VND Bank : 20 VND > -- USD Bank : 10 USD -- 20 VND > Equity : 40 VND > --- > Next month, The rate changed : 1USD = 3VND > Assets : 50 VND > -- VND Bank : 20 VND > -- USD Bank : 10 USD -- 30 VND > Equity : 40 VND > --- > Ok, the problem here, My Balance Sheet report now show in the equity tab > that had "Unrealized Gain" about 10 VND. > I knew that it's mean the rate of the USD are increasing so my assets are > increasing too. > But, It's also "Unrealized Gain" and not the "Realized Gain" in the report > when i transferred that USD to VND Bank. (Which mean, when USD rate high, i > sell it by transfer that money from USD Bank to VND Bank in GnuCash, of > course in my real life i do the same thing). > My accounts at that time: > Assets: 50 VND > -- VND Bank : 50 VND > -- USD Bank : 0 > Equity : 40VND > --- > 1 > - So,i really don't need to care about that "Words" in the Balance Sheet > Report ? > 2 > - If i need to care about it, What should i do to change it from > "Unrealized" to "Realized" (Please give me example for this). You yourself gave the best example -- when you sell it becomes "realized". Unless your local taxing authority requires otherwise (and check with your local accounting professional -- CPA), you can just ignore that it happens. > --- > P/s : I had read documents from GnuCash, and it's look like very hard to > understand for me. And i don't turned on the "Trading account", look like it > is the old way for solving this in the older version of GnuCash. i only > created account with USD currency and setup the price database. > > Thank you so much. Please help me. > Regards. It may help to setup an empty data file and follow the examples in the Concepts Guide. It can be tough to follow in a foreign language. --Steve -- 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] GNUCash beginner setup
Bottom line -- Enter them as you are paid. The CSV import should "see" the deposits and match them during the import. If it doesn't, it is a simple matter to remove that entry and keep the more detailed manually entered transaction. On 4/8/20 12:23 PM, jess wrote: > Thanks for the patience and help, I appreciate it. If I may ask another > account setup questions, how do you propose to handle income tax and other > contributions from your salary slips? > > I am a salaried individual with regular monthly income. The salary slips > reflect the gross income which contains deductions to health insurance, > social security contributions etc. The net income is finally credited to my > bank account. In the end of the year, I have a yearly consolidated form > which mentions my various contributions (social security, pension, health > insurance, tax etc.) from my salary slips for that FY (Financial Year). For > example, this tabular form would mention > > Income Tax Paid - 100€ > Health Insurance - 40€ > Pension - 30€ > Social Security - 20€ > > Some other details - > > (i) My goal is to track yearly contributions, I do not quite need monthly > details. > > (ii) I plan to import monthly bank transactions from my bank accounts in a > CSV format > > (iii) Tax and other contributions may wary throughout the year due to bonus > received Once you have entered one of them, the next time the application should bring that up as a template for entry. If nothing changed then just hit enter and you are done. If changes, then make those changes by tabbing to the fields that are different and enter the updated amounts. Hit enter when all updates are done. > > (iv) I have a separate account for "Income : Tax Refund" to see income OK. Some just offset the Expense account. Follow the desires of your CPA. > earned back from taxes > > (v) I want to track fine grained contributions viz. I have a separate > account for every contribution "Income Tax", "Social Security", "Pension" > etc. > > (vi) Contributions could be split between me and employer. For example, 10% > of income for total health insurance where I contribute 5% and employer > contributes 5%. But, the entire 10% is counted towards the gross income > statement. Income tax rates are based on gross incomes If that is shown on the pay slips, then enter it as part of the transaction. > > > I currently have two options which come to my mind. > > Option 1 - Monthly Salary Slip entries > > In this option, I will merely inflate the gross "Income" to "Net Income" (as > reflected on my bank account) + Contributions. The gross salary will flow > into the "Income" account and contributions will flow into the "Expense" > accounts - one for each > > Pros - I have monthly entries, up to date information at any given point of > time I prefer this route. > > Cons - Difficult to enter every month due to (iii), bank transaction CSV > import only reflects net income and additional account entries required The import should see the manually entered "deposits" and match to those. If it doesn't then you could deselect that row during import and it won't come in. Which is good because you already have entered that deposit. > > Option 2 - Yearly Entries Based on Wage Tax Form as mentioned above > > Here, I will just enter the contributions yearly into a separate individual > "Expense" accounts once a year. I am unsure on how to handle the "Income" > accounts year. My immediate idea is to create "Income" accounts for every > contribution. For example > > "Income : Social Security" , "Expense : Social Security" > > "Income : Health Insurance", "Expense : Health Insurance" and so on > > Pros - Easier to work with, transaction import CSV process does not > interfere > > Cons - Difficult to handle contributions as some contributions are employers > but part of the gross income (Refer (vi) > > > Given these options, what do you recommend? I am particularly concerned and > out of wits for point (vi). It seems complicated to handle. Once you have that figured out, the automatic "template" should bring those lines up and you just update the values, if different. That "template" is based on the most recent previous transaction of the same description. So, if you have two variants (if paid twice a month or bi-weekly and the amounts vary based on 1st pay of month versus 2nd, etc) use slightly different descriptions. > > > > > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___________
Re: [GNC] Should i care about Unrealized Losses/Gain in Balance Sheet ?
On 4/8/20 9:43 PM, Long wrote: > Hello Stephen M. Butler, > > You said that i'm doing the right way with my example ( i'm thinking like > that too ), when i transferred all my USD to VND Bank. Which mean, in > GnuCash, i don't have any USD, and all of it are now VND (in real life is > the same). But in the Balance Sheet report still show my value are > "Unrealized Gain" not "Realized Gain" . Maybe it's the default behavior of > GnuCash ? I'm confusing about that ! > > Thank you for helping me. Sounds like the report is based on US $. Look at the report options and see what currency the report is using as the default currency. -- 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] Reporting combinations of accounts
On 4/29/20 12:21 PM, Ruaraidh wrote: > I have the same question. I hope someone can answer. > > I'd put it more basically. I am a novice to GnuCash with no formal > accountancy training other than reading the (really good!) introduction in > the GnuCash documents, plus 10 years struggling with accounts in Excel. What > I wonder is, is there a "right" way to do this from an accountant's > perspective? > I find it kind of weird that the law allows couples to have joint assets, > liabilities, income and expenses, but doesn't allow them to report jointly > for tax purposes (unless, I guess, they go into proper business partnerships > and maintain formal business accounts). So I want to know the right way to > do it, and then ask if GnuCash can do that. It might help to know which country you are in. Here in the US we just file "Married filing jointly" and use the combined information. More importantly, you need a local tax/account professional to tell you the correct way to handle this for your jurisdiction. Then somebody here should know how to implement that in GnC. -- 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] Change account type by editing XML?
On 4/29/20 11:25 AM, david whiting wrote: > Hello, > > When I first set up my accounts (for a local club) I knew very little > about accounting and misinterpreted some information I was given by an > accountant and ended up creating some sub-accounts in Accounts Receivable. > I now know that was not the correct thing to do, and I should have created > these accounts as straight-forward asset accounts. > > Using gnucash I cannot change the account type for these accounts. When I > use ctrl+e on these accounts I only see account type A/Receivable so I > cannot change them through the GUI. When I've had problems changing the account type on an account, I found that changing the parent first opens up the additional account types to be used. Don't know if that will work for A/R (as I don't utilize them). > > I've compared the XML structure of one of these accounts with another > simple asset account and they are the same except for the , i.e.: > > RECEIVABLE > > versus > > ASSET > > I've tried editing this (on a copy) and simply changing RECEIVABLE to ASSET > seems to work when I re-open the file. Once this is done I used gnucash to > move the account to the correct place in the accounts hierarchy and all > seemed well. > > Before I do this to all instances in my working file are there any > potential adverse consequences that doing this could cause that I am > not aware of? > > Thanks. > > David -- 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] Change account type by editing XML?
On 4/29/20 1:14 PM, david whiting wrote: > On Wed, 29 Apr 2020 at 20:29, Maf. King wrote: >> Just a thought - if you change the account parent away from A/R can you then >> change the type? >> >> HTH, >> Maf. >> > No, unfortunately moving the parent account doesn't allow me to change it. > > David I think you misunderstood, or I'm not understanding what you did. It sounds like you attempted to edit the parent account and change it's type. What we are suggesting is that you edit the leaf account and change who it's parent is so that it shows up underneath a different (non-A/R) account. > > >> >> On Wednesday, 29 April 2020 19:25:25 BST david whiting wrote: >>> Hello, >>> >>> When I first set up my accounts (for a local club) I knew very little >>> about accounting and misinterpreted some information I was given by an >>> accountant and ended up creating some sub-accounts in Accounts Receivable. >>> I now know that was not the correct thing to do, and I should have created >>> these accounts as straight-forward asset accounts. >>> >>> Using gnucash I cannot change the account type for these accounts. When I >>> use ctrl+e on these accounts I only see account type A/Receivable so I >>> cannot change them through the GUI. >>> >>> I've compared the XML structure of one of these accounts with another >>> simple asset account and they are the same except for the , i.e.: >>> >>> RECEIVABLE >>> >>> versus >>> >>> ASSET >>> >>> I've tried editing this (on a copy) and simply changing RECEIVABLE to ASSET >>> seems to work when I re-open the file. Once this is done I used gnucash to >>> move the account to the correct place in the accounts hierarchy and all >>> seemed well. >>> >>> Before I do this to all instances in my working file are there any >>> potential adverse consequences that doing this could cause that I am >>> not aware of? >>> >>> Thanks. >>> >>> David >>> >>> >>>> >>>> >>>> -- >>>> 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. >>> >>>> >>>> >>>> -- >>>> 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. >> >> -- >> Maf. King >> PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7 2B7C E591 E8E1 0DE7 C542 >> >> >> >> >> > -- 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] Change account type by editing XML?
On 4/29/20 1:37 PM, david whiting wrote: > On Wed, 29 Apr 2020 at 21:31, Stephen M. Butler wrote: >> On 4/29/20 1:14 PM, david whiting wrote: >>> On Wed, 29 Apr 2020 at 20:29, Maf. King wrote: >>>> Just a thought - if you change the account parent away from A/R can you >>>> then >>>> change the type? >>>> >>>> HTH, >>>> Maf. >>>> >>> No, unfortunately moving the parent account doesn't allow me to change it. >>> >>> David >> >> I think you misunderstood, or I'm not understanding what you did. It >> sounds like you attempted to edit the parent account and change it's >> type. What we are suggesting is that you edit the leaf account and >> change who it's parent is so that it shows up underneath a different >> (non-A/R) account. >> > Yes, I misunderstood, however, I just tried that and still can't > change the type. See attached image showing that the account is now in > Assets:Members but other types are still not available. > > David That seems like a bug to me. -- 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] Change account type by editing XML?
On 4/29/20 1:21 PM, david whiting wrote: > On Wed, 29 Apr 2020 at 20:48, Adrien Monteleone > wrote: >> 1. Create new accounts as the proper type in the proper place in the tree. >> >> 2. Delete each of the current accounts, one at a time, you wish to change. >> >> 3. GnuCash will ask you, for each deletion, what you want to do with the >> transactions the account currently contains. >> >> 4. Choose the option to re-assign them to the corresponding new account. >> >> Since they are both assets (A/R is an asset) this should go smoothly. >> >> Do a test with one account on a copy of the data file just to be sure there >> are no unforseen issues. >> >> Regards, >> Adrien >> > Unfortunately the only accounts that show up in the "Move to" dialogue > are other A/R accounts, no other asset accounts are visible. I've > verified this by creating a new account outside of the A/R hierarchy > with type A/R. It was then visible in the list of accounts. I selected > it and deleted the transactions so they moved to this new A/R account > outside of the A/R hierarchy. But once that had been done, I could no > longer change the type of that account. Ouch! Sounds like a bug or that the A/R account type is locked down too tight. > > David > ___ > 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] Change account type by editing XML?
On 5/2/20 9:29 AM, Geert Janssens wrote: > > Op zaterdag 2 mei 2020 17:58:11 CEST schreef Stephen M. Butler: > > > On 5/2/20 2:44 AM, Geert Janssens wrote: > > > > Op zaterdag 2 mei 2020 08:23:19 CEST schreef Adrien Monteleone: > > > >> Indeed, I clicked Edit on an Asset account and I can only change > it to: > > > >> > > > >> Bank > > > >> Cash > > > >> Asset > > > >> Credit Card > > > >> Liability > > > >> > > > >> I get the first three if there is going to be a limitation, but > allowing > > > >> the last 2 and not allowing even another debit balanced account like > > > >> Expenses? > > > >> > > > >> Strange. > > > >> > > > >> I’m starting to wonder if this is a bug. If not, can someone shed > light > > > >> on > > > >> the reasoning for not being able to refactor accounts except > within their > > > >> current parent type? > > > > > > > > The idea here is that you can't put expense accounts under the an > Asset > > > > parent account. So if you want to change an asset account to become an > > > > expense account, you will first have to select a parent account > that is > > > > an expense account. That will then allow you to change the account > type. > > > > > > > > I agree the UI can use some more polish to make this a better > experience. > > > > The UI's original idea was to show the valid account types that are > > > > available for a given parent account. I think this would be more > easily > > > > understood if the parent account and the accountype widgets would > switch > > > > places. It is more intuitive if a lhs selection (for left to right > > > > interfaces) affect what can be selected in a rhs selector. Not the > other > > > > way around. > > > > > > > > Playing with this a bit more I wonder if other combinations make > sense or > > > > possibly conflict with gnucash' internal assumptions. For example, are > > > > there valid use cases to store an income account under an expense > account > > > > or the other way around ? > > > > > > For a small business I was carrying Cost-of-Goods-Sold (COGS) as an > > > expense item. When my CPA filed the taxes, I noticed that he placed it > > > as a deduction to revenue. So, after a chat with the in-house > > > accountant, I moved COGS to be under the Income parent. > > > > > > Thankfully, the internal representation for amounts still worked > > > correctly and the COGS account now showed as a reduction to Income > > > without me having to go change the sign on each transaction. > > > > > Do you mean that when you moved the COGS account under the Income > parent you also changed the account type to "Income" or did it remain > an expense ? > I changed it to be an Expense type. > > > > Note by the way that I have seen it mentioned several times on the > mailing lists that the Account Hierarchy view does not necessarily > follow the same ordering as your balance sheet. > > > > Regards, > > > > Geert > -- 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] Change account type by editing XML?
On 5/2/20 2:44 AM, Geert Janssens wrote: > Op zaterdag 2 mei 2020 08:23:19 CEST schreef Adrien Monteleone: >> Indeed, I clicked Edit on an Asset account and I can only change it to: >> >> Bank >> Cash >> Asset >> Credit Card >> Liability >> >> I get the first three if there is going to be a limitation, but allowing the >> last 2 and not allowing even another debit balanced account like Expenses? >> >> Strange. >> >> I’m starting to wonder if this is a bug. If not, can someone shed light on >> the reasoning for not being able to refactor accounts except within their >> current parent type? > The idea here is that you can't put expense accounts under the an Asset > parent account. So if > you want to change an asset account to become an expense account, you will > first have to > select a parent account that is an expense account. That will then allow you > to change the > account type. > > I agree the UI can use some more polish to make this a better experience. The > UI's original idea > was to show the valid account types that are available for a given parent > account. I think this > would be more easily understood if the parent account and the accountype > widgets would > switch places. It is more intuitive if a lhs selection (for left to right > interfaces) affect what can be > selected in a rhs selector. Not the other way around. > > Playing with this a bit more I wonder if other combinations make sense or > possibly conflict with > gnucash' internal assumptions. For example, are there valid use cases to > store an income > account under an expense account or the other way around ? For a small business I was carrying Cost-of-Goods-Sold (COGS) as an expense item. When my CPA filed the taxes, I noticed that he placed it as a deduction to revenue. So, after a chat with the in-house accountant, I moved COGS to be under the Income parent. Thankfully, the internal representation for amounts still worked correctly and the COGS account now showed as a reduction to Income without me having to go change the sign on each transaction. > > > And another minor glitch: when you start from for example an Asset account, > then change the > parent to a liability account and back to an asset account without closing > the window in > between, the asset account now suddenly has become a Liability account. > > Regards, > > Geert > ___ > 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] Change account type by editing XML?
On 5/2/20 11:10 AM, Stephen M. Butler wrote: > On 5/2/20 9:29 AM, Geert Janssens wrote: >> Do you mean that when you moved the COGS account under the Income >> parent you also changed the account type to "Income" or did it remain >> an expense ? >> > I changed it to be an Expense type. Oops. I meant to say that I changed it to be an Income account. It shows as a negative number in the COA. >> >> >> Note by the way that I have seen it mentioned several times on the >> mailing lists that the Account Hierarchy view does not necessarily >> follow the same ordering as your balance sheet. >> >> >> >> Regards, >> >> >> >> Geert >> -- 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] Scheduled transactions
On 5/3/20 6:29 AM, augras wrote: > Hello Jim, > thanks for your answer and your time. > You are right for points 1,2 and 3. > For the point 4 i can edit the transactions, but i can't make any change ! > I always get the message "An error occured in the treatment of 1000,00." and > the choice is only to Close. > I have a lot of scheduled transactions and get this problem for 2. > Philippe You might find it faster/easier to delete those two scheduled entries and load them up again. -- 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] Why do Imported Transactions NEED to be Matched?
On 4/26/20 6:18 PM, flywire wrote: >> Do you know other (including closed source) apps don’t use something > similar? > > I've used many other financial apps that just import Transfer Account > directly in as listed in the csv. > >> Why would a user normally need to know this implementation detail? > Because it's counter-intuitive to load a Transfer Account field that is > exactly the same as the CoA in the GnuCash file and then have to match the > Transfer Account. But that is the sweet idea -- use a short mnemonic and have it mapped once. I do this to encode a bunch of transactions for a non-profit I manage. Keeps from having to type in the entire account path. > Agree that import works in small chunks (as posted previously). Does that > response cover any way of getting GUIDs on the data? > ___ > 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] Backup to encrypted 7zip file
Encryption is very personal and also very hard to get right. 1. Personal. You might prefer a commercial product (PGP) while I prefer open source (GnuPG). 2. Hard. Simply XOR and many short-bit keys are now easily breakable. Even those who create methods (two-fish, RSA, etc) make mistakes that leave loop-holes open to be exploited. (See commentary by Bruce Schneier -- https://www.schneier.com/) So, 'tis better to use a tool built for encryption to do that work than to expect all other tools to implement (poorly) same. Pick the right tool for the job rather than expecting a screw-driver to drive a nail (or clamp two boards together). While at it, remember that if you are not on your own box, simply having your key available means that your data is compromised. Any key-stroke logger on the company machine could capture the key as you type it in (from memory). So, why are you putting your personal data on a company supplied machine? Your data is already compromised even with attempting to encrypt it. On 5/13/20 12:36 AM, flywire wrote: > Er ... no encryption. > > https://wiki.gnucash.org/wiki/FAQ#Q:_Can_you_please_add_a_password_feature.3F > ...[No] > > The actual problem is access to personal data on a work supplied computer. > An optional program based backup is more appropriate. GnuCash won't install > but thankfully there is a portable version > https://bugs.gnucash.org/show_bug.cgi?id=797740 > > ___ > 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] General Ledger
e...@lusfiber.net> wrote: >>> If you mean you want to see the individual transaction activity in your >> accounts related to a single customer, yes. >>> If you just want to see the balanced owed by all customers, you can use >> the Accounts Receivable report. (each customer can be listed separately, >> along with a total) >>> But both of these are entirely different things than your original >> question. Which is quite fine, but please do clarify what it is you are >> trying to accomplish so we can help you efficiently. >>> Regards, >>> Adrien >>> >>>> On Mar 16, 2020 w12d76, at 11:47 PM, Adrian Yong < >> adrianyong.88p...@gmail.com> wrote: >>>> Hi Christopher, >>>> >>>> That means I have to generate a report for each of the accounts ie >> Cash in >>>> Bank, Trade Debtors, each customer at a time ? >>>> >>>> Regards, >>>> Adrian >> ___ >> 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. -- 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] hiding expense and income accounts with zero balances
On 3/7/20 1:17 PM, David H wrote: > On Sun, 8 Mar 2020 at 04:22, Michael or Penny Novack < > stepbystepf...@comcast.net> wrote: > >> But there is some preliminary stuff you should know about the process. >> When you tell gnucash to produce the report, it will do so with default >> options. You then use Edit => Report Options to change the options that >> you want for this running of the report. In other words, the report has >> to exist before you choose options for it. A moment's thought should >> explain why you don't pick options and then open the report << how would >> gnucash know WHICH report you meant those options to apply to >> >> >> Michael D Novack >> >> >> > Michael, > > This has always seemed a bit arse about face to me. In my simple world the > report does exist as it's there in the menu items and I can select it and > run it. It's the report results that may or may not exist yet. It would > make a whole lot more sense for me personally to click on a report menu > item, have the options displayed at that point in time and for me to verify > the options and click OK to run the report at that point in time. It also > means that I wouldn't have to wait for the report to finish it's initial > run and then change the options to what I actually need :-) Newbies would > also benefit by actually seeing upfront what options are available. As you > can probably tell I don't run a lot of reports - I just use Gnucash for my > personal accounts and to track income/spending from a rental property. > > Cheers David H. Thinking back to when I was a new, it wasn't obvious that the Options menu entry was there on the report. The report ran and either was what I wanted or wasn't with little clue how to change it. If the options pop up first thing, then it would be obvious that there is a whole lot that could be configured on each report. Someday I may get around to entering that as an enhancement. --Steve -- 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] Dipping my toes into Scheme
Check out sicklylife on launchpad.net. He as 3.8 for eon and bionic. sudo add-apt-repository ppa:sicklylife/gnucash On 3/24/20 2:36 PM, Bruce Irving via gnucash-user wrote: > GnuCash Users > Subject: Re: [GNC] Dipping my toes into Scheme > Message-ID: <98fb916d-1962-40f5-96db-7a7154da3...@gmail.com> > Content-Type: text/plain; charset=utf-8sudo add-apt-repository > ppa:sicklylife/gnucash > >> I have an Ubuntu 18.04 VM on my Mac, but the most recent version of GnuCash >> available through the Ubuntu Software Manager is 2.6.19. >> >> Does anyone know if I have to compile from source to get 3.8? > http://www.flatpak.org I have been successful with a couple of applications > for my Peppermint 10 (Debian based). > > > Bruce Preach the Gospel wherever you go. If necessary, use words. > ___ > 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] XML vs SQL data integrity question
On 5/6/20 10:07 PM, Jeff wrote: > This has probably been discussed here before but; I'm going ask > anyway. Which do most people find more reliable with GNC, SQL or the > default XML? And are there any features I would lose other than the > rollback ability with SQL? > > I'm getting tired of having to track down account and report issues > every time Windoze 10 hiccups. I use the default XML, uncompressed. > One set of books has been corrupted several times, I'm assuming when > Windoze just simply kills the GNC program out of the blue. I have > another set of books for a business that so far, knock on wood, the > only problem is sometimes various buttons have to be selected multiple > times to work then all of the windows open in GNC blur while > processing then go back to normal display. > > My computers are all networked and dual boot Windoze and Ubuntu, so I > would need SQL on both sides if I switch over. I'm leaning towards > PostgreSQL (pro's, con's? Suggestions?). > I only use Ubuntu/XML (compressed). -- 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] Negative numbers
You may also enter an enhancement request in bugzilla. On 9/9/20 1:05 PM, Adrien Monteleone wrote: > Not that I'm aware of, but just tab or shift-tab to the other column. > A negative credit is a positive debit and vice versa. If you try > entering a negative, you'll see GnuCash moves it to the other column > as a positive anyway. > > Regards, > Adrien > > On 9/9/20 12:31 PM, ToddAndMargo via gnucash-user wrote: >> Fedora 32 >> gnucash-4.1-1.fc32.x86_64 >> >> I have a number of program that accept negative numbers >> with the minus sign at the end `123.45-` or inside >> parenthesis `(123.56)`. >> >> Is there a way to tell GnuCash to do this also? I >> keep entering it the other way and having to go back >> and put the minus sign in the front. > > ___ > 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] CSV file import question
Note that both columns could be tagged as "Deposit" as is the case with Citi CC. The column containing charges to the card are Positive but the payments column is negative. <>. I presume that someone has a case where both should be tagged as "Withdrawl". --Steve On 9/12/20 7:21 AM, Geert Janssens wrote: > Greg, > > The terms "Deposit" and "Withdrawal" in the csv importer can be a bit > confusing unfortunately. > The terms map well for bank statements using two columns to display amounts, > where both > columns list positive numbers. It maps less well for credit card statements > (interpretation would > be inversed) or two-column representations were the withdrawal column lists > negative numbers. > > As a sidenote, a more general labeling could have been "Amount (unchanged)" > and "Amount > (sign reversed)", because that's what the labeling actually makes gnucash do > internally. > However that also requires user interpretation of the data and understanding > of how gnucash > works internally. > > For your bank statements, if your amounts are all in one column the deposits > are presumably > positive numbers and withdrawals presumably negative numbers. In that case > label this single > column "Deposit". > > If you have separate columns for your deposits and withdrawals, the labels to > use depend on > the signs of the numbers in your csv. > > If the deposit column has positive numbers, label the column as "Deposit". If > the deposit column > has negative numbers, label the column as "Withdrawal". > > For the withdrawal column it's exactly the opposite. > > If the withdrawal column has positive numbers, label the column as > "Withdrawal". If the > withdrawal column has negative numbers, label the column as "Deposit". > > Regards, > > Geert > > Op dinsdag 8 september 2020 05:08:05 CEST schreef David Carlson: >> Greg, >> Usually, when your bank or credit card company creates a CSV file for you, >> either deposits are positive and withdrawals are negative, or vice versa. >> Whichever you see, you then call the amounts deposits or withdrawals when >> performing the import, and GnuCash assigns the value to the Debit or credit >> column as appropriate. >> The key is to correctly tag the value column as deposit or withdrawal when >> importing the file. >> >> >> >> On Mon, Sep 7, 2020 at 8:23 PM Greg Carroll >> >> wrote: >>> Hello, >>> >>> I'm new to Gnucash. I have it set up as a checkbook. I imported a csv >>> file, >>> but it put all of the amounts of the deposits and withdrawals only in the >>> deposit column. I can't figure out how get it to recognize deposit amounts >>> separately from withdrawal amounts. I even made separate csv files >>> containing only deposits and one for only withdrawals and upon importing >>> it, gnucash still puts all of the amounts in the deposits column. >>> >>> -- >>> Regards, >>> >>> Greg >>> ___ >>> 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. -- 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] clip board paste across catagories
On 9/29/20 1:20 PM, ToddAndMargo via gnucash-user wrote: > >>> On Sep 27, 2020, at 12:23 AM, ToddAndMargo via gnucash-user >>> wrote: > >>> Any special character I can throw at it to get it to paste across >>> fields? I can insert anything I want into the string >>> >> > > On 2020-09-29 08:55, John Ralls wrote: >> No. Aside from the special transaction copy-paste that Liz mentioned >> copy-paste is one field at a time. You'll note that you're able to >> select only one field at a time: GnuCash isn't a spreadsheet. >> >> What's the source of the clipboard item? >> >> Regards, >> John Ralls > > > I am the source of the data. I have written a program > that reads new purchase orders from my inventory > database and formats it into an eMail format that my > vendors have started requiring. > > My goal was to take my data and create a format that I > could paste into GnuCash. I frequently forget to enter > orders into GnuCash and THAT make for an INTERESTING > reconciliation with my bank statement. > > Since I am the programmer, I can insert anything in the > clipboard I want, including weird characters. Since you are the developer then you can write a CSV file and have that imported into GnC. -- 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] Checking account withdrawals for cash boxes
Yes, that would be a Cash Box asset account. If you wanted to track each box individually then make a sub-account for each under Cash Box. On 9/29/20 1:16 PM, Roderick A. Anderson wrote: > Good day to all. > > I have a question that may require me contacting an accountant but > this is my first pass. > > First I am the Treasurer for a small US 501c3. Never been an > accountant nor played one on TV. ;-) > > We have an annual fund raiser. I withdraw cash from the > checking/General account for the cash boxes. In the past (and what I > inherited) was to make it an expense entry. Just doesn't seem right > since we still have the money. > > Should I create another Asset account and record it there? > > > TIA, > Rod > ___ > 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] Loan to family member: How do i setup the account structure
I presume that you currently "expense" the loans. They really are not an "expense" but a change of asset (from your savings account to a receivable. 1. Add a new Asset account called "FaF Loans" (Friends and Family Loans). Mark it as a placeholder. 2. Under FaF add a new account for each person to home a loan is made. For your use case enter the following transactions: A. Transfer £2000 from Savings1 to Checking. B. Transfer £2000 from Checking to FaF:Family1 Note: If both happen at the same time, you could combine them into a multi-split transaction with Checking having two offsetting splits. C. £100 from Faf:Family1 to Checking D. £100 from Checking to Savings2 Note: Doubtful that the above two transactions happen at the same time so shouldn't combine. By looking at the transactions for each of the sub-accounts in FaF you would see the original loan amount plus all the payments. The account balance would be the outstanding balance. Now, if you should charge interest, the interest portion would be income. I presume that you already earn interest on other accounts so would already have that account setup in the Income area of CoA. The payment would then be split with FaF:FamilyX and Interest-Income on one side and Checking as the destination. On 9/23/20 4:27 AM, John Mansfield wrote: > I have lent monies to a family member and now wish to track the balances on > an ongoing basis. I have been looking at the guides etc but just cannot > understand the concept / account hierarchy given my circumstances. > > The software I am using is: > > * Version: Version: 4.1, Build ID: 4.1+(2020-07-25) > * Windows 10 > > My location/currency is: > > * GBP, UK Based > > My Gnu Cash account setup is: > > * I have a cheque account > * I have a savings account 1 > * I have a savings account 2 > * Plus others. > > My use case is: > > * It will be an interest free loan > * My family member has borrowed £2000 > * Loan taken from Savings account 1 into > * Cheque Account then electronically bank transfer > * To family member bank account. > * A repayment is made each month > * The family member transfers a set amount, say £100. This is > electronically deposited into my bank Cheque account > * To date, I have electronically bank transferred monies into Savings > Account 2 and updated gnu cash > * I have no immediate report of monies repaid / outstanding. > > My preferred outcome: > > > 1. To track the Principal amount of £2000 > * To track each payment into my Cheque Account from family member - > normally monthly (once bank transactions have been uploaded into gnu cash) > * To understand how much has been paid - to date > * To understand how much is outstanding > * To transfer each repayment into Gnu cash Savings account 2 and bank > account > * To be able to get reports on the above. > > > Given the above, I would be most grateful if you can advise what account > hierarchy / transaction splits etc I need in Gnu cash to support the above? > > I thank you for your time and support. > > Regards > > John Mansfield -- 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] Reconcile strangeness
Oops. I sent from one of my other email accounts! Sorry. --Steve On 9/22/20 8:10 PM, Steve wrote: > Today I noticed an anomaly while reconciling an asset account. > > I am still on 3.8b on Linux (Ubuntu 20.04). I suspect this is one I > compiled myself -- but it has been awhile. > > I haven't had time to compile and check the latest. > > Reconciling an asset account (that was a placeholder with 4 sub-accounts > -- Asset:Bank:MutualFund). I did click to include the sub-accounts > (General, Emergency, Sinking). > > One transaction was to move funds from one sub-account to another > sub-account of the placeholder (General --> Emergency). > > So, this transaction showed up on the Debit and Credit lists. I was > unable to get both sides to have a check-mark. Clicking on the credit > side would remove the check-mark from the debit side. And vice versus. > > Ended up postponing the reconcile, then editing the transaction to > remove the cleared flag from whichever side it had remained. Since this > transaction is balanced (!!) I was able to finish the reconcile to the > bank's value. > > Is this a known bug? Can somebody experiment with the latest release to > see if still present? > > --Steve > > -- 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] Split Transactions
On 9/30/20 6:53 PM, normanj wrote: > I've been using Gnucash for a few years, but I'm far from being an expert > user. > > One of my accounts is for a savings account which pays a monthly interest > and, subject to some conditions, a "bonus" interest payment. The bank used > to report these as a single monthly payment so entering these into Gnucash > was a straightforward transaction - a assets account for the balance and an > income account for the interest. > > The bank has started reporting the base and bonus interest payments > separately, and my first thought was to use a split transaction - two > payments for the interest and two corresponding entries into the asset > account. However, when I save the transaction it is shown as two split > transactions, each showing the same 4 numbers for both the regular and > "bonus" interest, though the asset account balance is correct. Any change I > make to one transaction, including deletion, is immediately reflected in the > other transaction. I routinely have transactions with multiple splits going to the same account. I only see the one transaction with multiple splits. Therefore, I think it must be an artifact of the type of register view you have. I am using the expanded view that shows all splits in the transaction. I suspect you are using a view that shows only the splits that apply to the account you are viewing. > > To my inexpert eye this seems quite odd. The only way I can see to fix this > is to delete the impacted transactions and re-enter the "ordinary" and > "bonus" payments separately, though as they are directly linked there is an > obvious benefit in having everything in one transaction. > > Can anyone kindly advise if this is normal behaviour and is there a better > way to do this? If it makes a difference I use a mac and upgraded to > Gnucash 3.6 earlier in year (as it happens, about the same time the bank > chnged its reporting format) > > Thank you. Despite this hiccup, I've found Gnucash to be an excellent tool. > -- 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] non-currency liabilities
On 8/2/20 8:35 AM, dann frazier wrote: > Thanks David - yeah, negative share balances are possible. But it's > seemingly not possible to track shares in a Liability account. You can always treat Liabilities as a negative Asset. > > On Sun, Aug 2, 2020 at 2:41 AM David Carlson > wrote: >> I meant no requirement to have a positive share balance. You should be able >> to have a negative share balance in a security account. >> >> On Sun, Aug 2, 2020 at 3:37 AM David Carlson >> wrote: >>> I believe there is no restriction to have a positive number of shares of a >>> security. After all, it is common to sell stock short (Against the box) or >>> not. >>> >>> David Carlson >>> >>> On Sun, Aug 2, 2020 at 2:48 AM dann frazier wrote: >>>> Hi, >>>> >>>> I'm trying to figure out the right way to represent a non-currency >>>> debt in gnucash. That is, I'd like to be able to record that I *owe* >>>> 20 shares of FooFund. I thought I'd just create a Mutual Fund >>>> Liability account, but apparently Mutual Funds and Liabilities are >>>> mutually exclusive. Is that restriction by design? >>>> >>>> One of the reasons I want to do this is for a college fund. I'd like >>>> to keep track of the fund value in an account, but also "keep it off >>>> the books" in a sense when it comes to Asset vs. Liability >>>> calculations, as I consider it both something I have and something I >>>> owe. I tried doing this by creating an Asset account and a Liability >>>> account that grow together, and cancel each other out, but I couldn't >>>> get that to work since it won't let me make the Liability a security. >>>> Is there a better way to do this? >>>> >>>> -dann >>>> ___ -- 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] Prevent register from auto-duplicating transactions?
Use a slightly different description. (store name + 4) for the 4 line split and (store name + 1) for the single line split. On 7/12/20 12:27 PM, Stan Brown wrote: > Example: In a trip to the supermarket I buy food, wine, flowers, and > cleaning supplies. To record that, I enter a transaction in GC, in the > register for my credit card: > Description = (store name) > Click the Split button. > In each of four splits, Memo = details of what I bought, Account = > (account for that type of expense), Debit = (amount) > In the fifth split, Memo = blank, Account = (credit card), credit = (total) > All of that is fine. (I don't divide that purchase into four > transactions, because I want the credit amount to match what will be > shown on my credit-card statement.) > > But here's the problem. On the next trip to that store, I buy only food. > What I want to do, in the account register for my credit card, is enter > Description = (store name), Transfer = "Groceries", Credit = (amount). > But as soon as I enter the store name in description, GC creates five > splits that duplicate that previous shopping trip. I have to click Split > and manually delete three splits, one at a time. > > Is there some way to tell GC "don't finish this one transaction for me"? > > Or, almost as good, when it does do the auto-complete, is there some way > to tell it "not this time, thank you", and have it delete all of what it > helpfully created for me?? > -- 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] Training the classifier of imported transactions in GnuCash
On 6/15/20 12:30 PM, Cliff Kushler wrote: > Hi Gio, > > Thanks for your quick response! > > Yes, I have been importing transactions for many years. However, it seems > that Gnucash is not getting any better - I have to correct transactions from > the same source over and over again, month after month. There is a window > that appears during the import process (before the transactions are posted in > the actual account registers) that shows all of the transactions to be > imported, with check boxes labelled “A” (accept? not sure…), “U+R” (update & > reconcile?) and “R” (reconcile). However, I do not know of any way to > correct the classification of a transaction while it is still in this window > (which seems like the opportunity to train the classifier). I end up > correcting the transactions after they have posted in the account registers, > and GnuCash does not seem to be learning from this. > > If you (or anyone) knows what I should be doing, please let me know - thanks! In that window, double click on a line that needs an update on the "classification". A window should pop-up that will allow you to select the account to which that line should be assigned. Doing this will "teach" the import how to make the assignments going forward. It might take a few iterations for it to "learn". --Steve > > Cliff > > On Jun 15, 2020, at 3:25 AM, Gio Bacareza wrote: > > Hi Cliff, > > I also want to first say thanks to all the developers. I am a user and a fan. > 2nd, awesome to meet you Cliff. I love your products too. > > I was also looking into an automated way of classifying transactions. I did a > quick automl using google and have achieved 90%+ accuracy. > > However, I wasn't able to use it because I think gnucash does its own and > requires you to classify them upon import. After a few imports it also > "learns." So subsequent imports will have these transfer accounts > autopopulated. > > I hope it helps. > > gio > > > > On Mon, Jun 15, 2020 at 5:11 PM Cliff Kushler <mailto:ckush...@gmail.com>> wrote: > Hello - > > I am a long-time user and fan of GnuCash, and start by offering my gratitude > to everyone who has contributed to it. For what it’s worth, I am also a > co-inventor of T9 and Swype, so perhaps I have contributed something to make > your life easier too. > > My question is whether there is a tool, technique or strategy to improve the > accuracy with which GnuCash assigns imported transactions to destination > accounts. I import large quantities of credit card transactions, and while > many of them are assigned to the correct accounts, a very large number of > repeat transactions (i.e. from the same vendor) are either repeatedly > assigned to the same wrong category or simply left as “Imbalance-USD”. I > have not been able to identify a way to correct them while they are still > displayed in the initial import window, although I suspect that would be the > time to correct them. I go through and manually correct them in the register > after importing them, but this does not seem to help future classification > accuracy. > > Any help would be much appreciated! I probably should have asked this years > ago… > > Joy & Blessings, > > Cliff Kushler > ___ > gnucash-user mailing list > gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > <https://lists.gnucash.org/mailman/listinfo/gnucash-user> > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists > <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] BotanyBayGardens nonprofit example, and why GnuCash does not suffice
On 7/26/20 2:40 PM, Michael or Penny Novack wrote: > >> Hmm. Better migrate to a credit union then. Mine will send checks to >> an address and they will even put the stamp on the envelope. There is >> an option to send to a phone number or email address. > > > Lovely. If you directed a check to my phone number it's inaccessible. > Do you KNOW that phone number is to a "smart-phone"or similar device, > not a "flip phone", or in my case a "land line" << you can't call HERE > to a cell phone, no cell service -- I do know several spots within a > mile where from some spot on a hilltop can get a connection to call > out >> In other words, more information for you to store. > > Email address -- yes that works if the recipient has an adequate > printer and their bank will accept such checks << yes they are legal, > but my bank has great difficulty scanning them in. Just had to go > through that nonsense. >> > > Having the bank mail a check? When I mail a check, there is always > going to be supporting documentation in the envelope along with it. > Are you receiving checks with no indication what for? What do you do > then? > > > Michael D Novack > Doesn't matter. All POP or Zelle needs is that at some point you responded and directed them to send the funds to your account. I don't know most of the routing numbers/accounts of folks to whom electronic funds are sent. But the recipient at some point tied their phone number (land line, cell phone, satellite) to their account. At that point they don't need to respond any further. Though they may get a notice that the transaction happened. Now, if I don't have that but I do know your address, well, as I said, my CU will slap a stamp on the envelope and mail that check out to them at no cost to me. -- 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] BotanyBayGardens nonprofit example, and why GnuCash does not suffice
On 7/26/20 9:25 AM, Michael or Penny Novack wrote: > On 7/26/2020 11:39 AM, John Ralls wrote: > >> Did nobody read the footnote? The book was published in 1985, long >> before electronic payments became widely available. No doubt the 2020 >> edition would say something like "independently documented transfer" >> with a mention somewhere that that used to mean a check but now >> covers a variety of payment methods. >> >> Incidentally, the textbook also says that checks should ideally >> require two signatures. I don't know how to impose that control over >> electronic transfers but the local newspaper reports two or three >> cases of embezzlement a year where it's obvious that a two-person >> control would have prevented the crime. >> > Even today, just because you CAN use "electronic checks" doesn't mean > you would want to. That's going to depend on the average number of > checks per payee since a bank transfer requires knowing/storing the > bank routing number and account of each. To use the organization where > I have FINALLY been relieved as treasurer, perhaps 50+ different > payees but rarely more than two checks to the same payee in a year. > SOME payees, like for governmental filing fees provide a site, might > even require electronic payment. But only a couple of those payments n > a year. Hmm. Better migrate to a credit union then. Mine will send checks to an address and they will even put the stamp on the envelope. There is an option to send to a phone number or email address. > So if an orchard manager sent in a envelope of receipts for > reimbursement, that would have a return address to mail a paper check > to. It's only the less well off that would be sending me receipts like > that, a few at a time. The ones well off might just save up a bunch > and hand them to me at the next board meeting and I write them a check > then and there. > > Best solutions depend on the work flow. The work required to obtain > the bank information for a direct transfer is more than the work of > writing/mailing a check. More than doing it twice. But if you are > going to be doing it ten times (to the same payee) getting the bank > info might be quicker. > > 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. > . -- 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] BotanyBayGardens nonprofit example, and why GnuCash does not suffice
On 7/27/20 2:07 AM, Liz Dodd wrote: > On Sun, 26 Jul 2020 17:40:19 -0400 > Michael or Penny Novack wrote: > >> Having the bank mail a check? When I mail a check, there is always >> going to be supporting documentation in the envelope along with it. >> Are you receiving checks with no indication what for? What do you do >> then? >> > There's about 250 characters for that data available on Osko, the > Aussie system. > You mention real problems, but they are already solved in some places. > > https://osko.com.au/faqs > > Liz I am able to send along an account ID or Invoice ID and then there is the entire memo field on the check. I also get an email from the CU (if I request) stating that it has been sent. I can forward that to the recipient with additional notes. Not convenient, but driving an hour to hand over coin is also very inconvenient. -- 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] Importing Transactions from Bank
On 7/20/20 2:43 PM, Jon Griffith wrote: > Is Gnucash smart enough to recognize transactions that have already been > imported, or do we have to keep tight tabs on the import date range? > OFX keeps track. CSV usually does but sometimes suppresses one that should be loaded. -- 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] Can you move a Liability Account to a "sub-account" in Liabilities?
On 7/30/20 6:41 AM, Fran_3 via gnucash-user wrote: > 3 items listed under Liabilities... > Liability ALiability BLiability Ceach to a different entity but related based > on certain criteria. > We want to setup another Liability account "Liabilities ABC" and then move > the 3 above under it as "sub-accounts" like ... > Liabilities- Liabilities ABC-- Liability A-- Liability B-- Liability C > That way we can see the total of the 3 or each individual total... > The Question: Is there any way to do this without having to delete A, B, C, > and re-creating them under Liabilities ABC ? > Thanks for any help. > Easy. 1. Create the new Liability ABC using Liabilities as its parent. 2. Edit the other three to change their parent from Liability to Liability ABC. -- 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] Thanks for interface improvement - import TXNs
On 1/6/21 12:41 PM, David Carlson wrote: Adrien, I do not currently have the time and motivation to go beyond using PPA's to keep current with my software. I am not ready to use flatpacks until that technology has matured better than what I have seen to date. For now I prefer to stay with solutions that are currently working for me. I would love to see a PPA dedicated to GnuCash that would have at least the stable releases pre-built for the various releases. For awhile I was able to build a .deb package on my box and share. However, I don't have the technical skill set to keep that up. It would be nice if someone with that skill set and time availability would join the development team and take on the maintenance of such a PPA. As a bonus, it would be nice to have the nightly builds also available. --Steve (Ubuntu 20.10) On Wed, Jan 6, 2021, 1:34 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: David, is something holding you back from Flatpak or building? Regards, Adrien On 1/6/21 9:31 AM, David Carlson wrote: Roberts, It is wonderful to hear your comment on the revised import interface. I have been procrastinating about updating to a newer release of GnuCash for a number reasons, but now I have updated to release 3.8, which I was able to find in a PPA for Ubuntu 20.04. I want to move to 4.4 but it appears that it is not yet available in a PPA form for Debian or Ubuntu Linux. For the record, exactly which release did you install in your Arch Linux machine? -- 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] Wrong starting balance
On 11/20/20 4:49 PM, Liz wrote: On Fri, 20 Nov 2020 16:41:22 -0800 Jim DeLaHunt wrote: Hello, Liz: Are any of the transactions in that account reconciled? Do you have a "starting balance" transaction in that account, perhaps created when you created the account? The reconciliation model for GnuCash assumes that you start by reconciling the earliest transactions, and move forward sequentially in time, reconciling bit by bit. When you start a reconciliation, GnuCash adds up all the reconciled transactions for that account, regardless of date, and that becomes your starting balance. Does this help? Best regards, —Jim DeLaHunt No Jim I know perfectly well how reconcile works. I have not reconciled this account ever. NO transactions are reconciled The starting balance is $1.87 I am mystified about $6,300, so I did a find for that value on the entire account tree and found nothing of that value. Liz _ Try to reconcile another account that has never been reconciled. If that comes up with a non-zero number then create a new account and attempt to reconcile with no entries. If that comes up with a non-zero amount then you have found a bug. What I'm wondering is if there are no entries to add up the module might not be handling the results correctly. -- 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] Fwd: Re: Possible Suggestion: Give transactions a default 'Jump to' target account
On 12/8/20 8:36 AM, Stan Brown wrote: Apologies -- I clicked "reply" instead of "reply List". Since you asked for opinions -- Speaking for myself only, I just click Split in the top row of icons, then click on the account I want in the expanded transaction and Jump. I don't think the pop-up would help me in my workflow. I always have the splits showing so this wouldn't help me at all either. -- 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] How to use Reminders?
the immortal words of "Doctor, it hurts when I do this"... "Don't Do That." Post your bill when you enter it. That's what the reminders are for, to pay the bill that you entered AND POSTED. Problem with missing your boss's birthday is you forgot what date it was. This is not a GnuCash problem; use your calendar for that. There are many options, like Orange and Evolution, which will do a MUCH better job. So, how do you create a general purpose Reminders for various things in GnuCash like..- Post Electric Bill Today (this reminds you to go find the bill online or in the mail or wherever & post it) - Boss's birthday is on April 1st- Valentines Day coming up on February 14th- Leave check under door mat for yard guy None of these reminders belong in GnuCash. I see the calendar view via clicking... Actions > Schedule > Edit Scheduled Transactions And the tabs & fields when I click "New" And most of the fields are obvious except under Template Transaction... I'm clueless about what I'm looking at...Is tat a template for...- a new bill to be posted- a reminder to pay a bill- or what? The Template Transaction is the transaction you have scheduled. The template will be executed and posted into your accounts when the SX fires. The template can be anything (well, any transaction -- you cannot schedule a Business feature object like Invoice or Bill). I, personally, use them to schedule Loan (and Mortgage) payments, because it can approximate interest calculations. And, what about a reminder that is not a financial transaction? Questions: 1 - Is there a way to create General Purpose Reminders in GnuCash? No. 2 - Where can I find instructions on how to navigate to General Purpose Reminders? Read up on Evolution (the program, not the Theory of). 3 - Is there a document that explains the use of the various fields in either... a. the General Purpose Reminder or in b. Scheduled Transactions Reminders? There should be documentation the SX Editor, yes. Check the Help file. Oh, one more thing -- keep in mind that you can post-date a transaction. For example, I tell my bank to go pay my credit card $1234 on the 17th. Even though today is the 9th, I can enter a transaction dated the 17th from Bank -> CC for $1234, so GnuCash records that I set the bank billpay up to do that for me. Hope this helps, You can even have GnC pre-post the scheduled transactions for you. I have most of mine set to 15 days. Sometimes I wish I'd set them to 30 days. Thanks for any help. Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. -derek Yes, I am a certified Project Management Professional. You need someone to help organize yourself. -- 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] Help with Column that Vanished
On 11/30/20 5:24 PM, David Carlson wrote: I suspect that the developers might have a hard time deciding how to select which other columns to use to fill the space that would be freed up if the description column did not fill the remaining space. However, another alternative would be to restore default column widths. This should make every column visible as they appear the first time that the account window is opened on a new computer. It may not be exactly what the user wants, but it would definitely give a good starting point. There are several alternatives that have served well with other software: 1. Don't fill the space. Let it be unused (whatever the default background color). 2. The right hand column expands/shrinks as needed (not ideal in my thinking). 3. ... I have also seen other software implement a minimum column size so you can't "lose" a column. With that they have a drop down list on the far right that allows you to activate/deactivate columns. Perhaps someone wants to enter an enhancement request. On Mon, Nov 30, 2020 at 3:51 PM Rob Britton | AirLearn < rob.brit...@airlearn.net> wrote: Geoff, Many thanks. The 200% display trick did it -- a couple of tries to get the Withdrawal column to appear, and there it was, hooray. I'll make a contribution, for sure. And sure would be great if, as other users have noted, the Description column could be reduced and not auto-adjust to fill the space. Thank you again for your responsiveness. -Original Message- From: Geoff Sent: Monday, November 30, 2020 05:19 To: gnucash-u...@lists.gnucash.org; Rob Britton | AirLearn < rob.brit...@airlearn.net> Cc: adrien.montele...@lusfiber.net Subject: Re: [GNC] Help with Column that Vanished Hi Rob You are not the only one to "lose" a column. If Adrian's instructions below don't work, have a look at this thread: http://gnucash.1415818.n4.nabble.com/GNC-Register-columns-The-balance-column-is-no-longer-visible-tc4721699.html Which includes screenshots for Windows 10. Good luck! Geoff = On 30/11/2020 8:20 pm, Adrien Monteleone wrote: First, the Description column is *not* fixed. (more to follow) Second, when sizing columns, you can only adjust using the right-side header divider. So hover near the right side of where the Withdrawal column should be, click and drag to the right.(you should see either two lines very close to each other, or a single thicker line, which would indicate the collapsed column) Finally, when all other columns are resized to your liking, click and drag the right-hand divider for the Description column far to the left. It will snap back and fill the remainder of the window width. (leaving your other columns sized how you want them) If you want to revert a column to its default size, double-click its header. Regards, Adrien On 11/29/20 4:01 PM, Rob Britton | AirLearn wrote: GnuCash is great, but resizing column widths is head-hurting. Okay, I'm 69 and not a youngster, so I make mistakes. And I understand that the description column width is fixed (that ought to be changed in the next update). So here's my problem: when trying to resize checking account columns just now I accidentally shrunk the withdrawal column and it "disappeared." How do I get it back? -- 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] Fwd: Smaller backup files: Time division, Since or Incremental?
s really old data is off screen in most accounts. > - The algorithm could even take into account keeping deeper time images of low churn accounts so the first page could be populated and the rest installed in the background. > > > -Original Message- > From: Geoff <mailto:cleanoutmys...@gmail.com>> > To: David G. Pickett <mailto:davidgpick...@comcast.net>>; gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > Sent: Mon, Dec 21, 2020 4:30 am > Subject: Re: [GNC] Fwd: Smaller backup files: Time division, Since or Incremental? > > Have you considered only backing up the log files then? They are your > incrementals... > > https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-backup1.html <https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-backup1.html> > > Geoff > = > > On 21/12/2020 1:28 pm, David G. Pickett wrote: >> >> >> >> Forwarded Message >> Subject: Smaller backup files: Time division, Since or Incremental? >> Date: Sat, 19 Dec 2020 14:40:54 -0500 >> From: David G. Pickett <mailto:davidgpick...@comcast.net>> >> To: gnucash-de...@gnucash.org <mailto:gnucash-de...@gnucash.org> >> >> >> >> One thing that complicates my gnucash life is the size and number of >> backup files. >> >> * It'd be nice, since most of the data is very historical, if it the >> data was divided by time into multiple files, more finely in rear >> time. Even if old files occasionally get updated by new work, they >> would mostly be static. >> * Another traditional way to keep backup sizes down is the Since-the >> last-full and the Incremental since the last incremental. >> * Since files are in xml, if they are line divided by transaction or >> entry, text tools like good old sccs can discern differences. >> >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user <https://lists.gnucash.org/mailman/listinfo/gnucash-user> >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists <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 <mailto:gnucash-user@gnucash.org> > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user <https://lists.gnucash.org/mailman/listinfo/gnucash-user> > If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists <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. -- 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] How to Manually Match transactions
On 11/19/20 10:29 AM, Griff wrote: Here is a very simple question but I can't figure out how to do this. I have searched the documentation and this mailing list. How do I manually match 2 transactions: I have 2 account that have had data imported via qfx. Account 1 (credit card) has a transaction on 2020-01-19 that is a payment for $amount which is the credit card payment from checking account Account 2 (bank account) has a transaction on 2020-01-21 that is a withdrawal for $amount which is the checking account payment to the credit card. The Transfer for the transactions in each account are currently set to Imbalance-USD. When I change the Account 1 transaction Transfer field to Account 2 - a new transaction is created in Account 2 instead of matching to the existing one. _ Manually -- you pick one of those dates and enter a single transaction. I usually have the bank payment entered in by hand and then do an OFX import of the CC file. The match happens automatically during the import. You can't do the match afterwards without manually removing one of them and adjusting the other. -- 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] How to Manually Match transactions
On 11/19/20 1:18 PM, Griff wrote: Thanks Adrien and Stephen. Both your solutions are good work arounds, sounds like the short answer is it can't be done the nice way preserving data. The result will be to manually delete one of the import transactions and the new duplicate created won't have the date that matches one of the 2 banks for correctness purposes. To your suggestion of importing it all at once, that is not possible as one QFX file is from the credit card company download and the other QFX is from the different bank company's download. They will be two files. This is unfortunate as the matcher is only run on QIF import and not OFX/QFX import. I use the OFX import all the time and get matching. Sometimes I have to force it to look for a match (check the R column). And sometimes, it matches too good and thinks it finds a duplicate (a charge that occurs every 2 weeks) so I have to force it to bring it in by checking the import column. Should I be getting the data from the banks in QIF instead, does that work better then OFX/QFX for GnuCash import? Should be just the same. <> -- 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] List Replies
On 11/18/20 1:38 AM, Geert Janssens wrote: Op dinsdag 17 november 2020 19:26:58 CET schreef Adrien Monteleone: Yeah, perhaps I'm not understanding something, but if the list server is configured with the list address in the reply-to header, but *does not* hide the individual's personal address (as described by Greg) how hard is it for someone to copy and paste that address in a new compose window in the 'to' field? And to make it even easier, most mail apps have a feature that if you select *any* e-mail address, you can get a context menu to send a new message to that address! So the default behavior would be reply-to-list, and if the *OFF* chance you *might* want to privately reply, you can still do so. (note, private replies to this list are discouraged, so why make it the default?!) You make a very good point here. I agree the list configuration should reflect our default behaviour. And given all mail clients I have seen make it easy to send a mail or reply to any visible header e-mail address (To, CC, From,...), the uncommon case of a private request is still readily available, but it does take explicit action. Making the desired behaviour default is actually good user experience. For the record these are the mail clients I have looked at: - Kmail: provides direct reply to or new message to any visible address. - Thunderbird: provides new message to any visible address - GMail: provides new message to any visible address, though it does take an extra click - K9-Mail (mobile): provides direct sending new mail to "from" address rather than reply-to address. Other visible addresses can't be targeted directly. I'm extrapolating from this that any decent mail client has effectively a way to directly send a message to the address that appears in the from field instead of using the hidden reply-to. So to me the original argument that it would be much harder to send a private reply doesn't hold. In fact as one on the other side of regularly receiving unwarranted private replies on my list posts, I actually prefer to make that process a bit harder (while still not difficult at all). Regards, Geert _ I use Thunderbird as a mail client. For messages from this list it offers me two buttons. Reply and ReplyList. Reply will send the message to the originator (From). ReplyList will send it to the ReplyTo entry. The ReplyList does have a drop down with three options (Reply, ReplyList, ReplyAll). Sometimes I've clicked on the Reply instead of ReplyList. Occasionally I catch that before hitting the Send button. --Steve PS. "If you idiot-proof the software, only idiots will be able to use it" -- 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] Wrong starting balance
On 11/20/20 6:23 PM, Liz wrote: On Fri, 20 Nov 2020 17:58:38 -0800 "Stephen M. Butler" wrote: Try to reconcile another account that has never been reconciled. If that comes up with a non-zero number then create a new account and attempt to reconcile with no entries. If that comes up with a non-zero amount then you have found a bug. What I'm wondering is if there are no entries to add up the module might not be handling the results correctly. I tested that possibility, and it was negative. Fortunately I found where the problem was, and it is related to the user. I did not expect when I moved transactions from the bank account to a holding account that the reconcile flag for the bank account would remain. It may be a bug. Liz At least the bug I was envisioning isn't there! Yes, I would call that behavior a bug. More urgent than an enhancement request. -- 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] Split Transactions
I find it easiest to adjust the preferences (Edit:Preferences:Register Defaults:Default Style) so that Register Style is my default. That means I see all the splits all the time. [Some may not like this.] --Steve On 11/15/20 12:46 PM, David Carlson wrote: Please include gnucash-user@gnucash.org in your reply by using reply all. GnuCash is a very high quality product and once you overcome this hurdle you will find it to work quite well. If you read the sections of manual described in other responses to your original email then follow Derek 's suggestions you should have excellent results. On Sun, Nov 15, 2020, 11:47 AM Nathan Rosenthal wrote: This did not seem to work. I can enter the split accounts and amounts OK but cannot save the entry (Save is greyed out). If I hit the key after entering the last account, the entire transaction disappears. I have worked around this bug by entering three separate transactions totaling the amount of the check. The balance is correct and the expenses are also correct. However when I run an Income and Expense report, the amounts I entered do not show or show in the wrong place. Very disappointed. I know this is a free program but now there are these problems. I don't believe the Windows updates caused them but it is possible. Nathan On 11/14/2020 8:37 PM, David Carlson wrote: Nathan, The first time it can be a little tricky. First select one of the transaction view options that will show the splits, then practice using the tab key to move the curser from box to box. For practice you can enter garbage text because it is easy to delete your practice mistakes. On Sat, Nov 14, 2020 at 7:20 PM Nathan Rosenthal wrote: I am almost sure someone has figured out how to enter what I call a split transaction - writing one check to cover multiple expense accounts. I cannot seem to get this to work properly. ___ 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. -- 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] GnuCash 4.4 Announcement/GnuCash 4.3 Announcement
I also just reconfigured my internal wireless network to use a mesh system. Suffice to say, your email reached me anyway. So, I guess the changes on both ends worked. On 12/30/20 1:39 PM, John Ralls wrote: Following up, Derek reconfigured his network so that code.gnucash.org supports IPv6. This is a first test to see if that changes the way my mail gets routed. If it goes through I'll try resending the 4.4 announcement with the copies. Regards, John Ralls On Dec 30, 2020, at 8:41 AM, John Ralls wrote: On Dec 30, 2020, at 6:24 AM, D. via gnucash-user wrote: Thanks, but the point is that the Gnucash project's standard practice-- that is, to post release announcements on the user and devel lists-- did not occur in this instance. @Frank: I didn't notice that your link was to a message in gnucash-announce. I don't know what the information flow typically is, but would assume that there is some script that repackages the announcement message and sends it along to the other lists as appropriate. Clearly, that didn't happen with these messages. I'd hazard a guess that most users only subscribe to the users list, and won't know about the new release otherwise. David, Nothing that fancy. I write the release notes for the website using the git log and a previous release notes, copy & paste it from a browser window into a blank email, address the email to gnucash-announce cc gnucash-devel and gnucash-user with reply to gnucash-user, and send it. That usually works fine, but this time it went into the bit-bucket somewhere between my ISP's smtp server (which my logs show acknowledging receiving it) and Derek's. No bounce or error messages, just poof. Same with 3 resends on the 4.3 announcement and one on the 4.4, so I sent the referral email to gnucash-user that begins this thread. On a whim I tried resending without the cc's and that went through, though only users who're subscribed to gnucash-announce will have gotten them. That's what Frank linked to. 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. -- 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] Set up
On 1/15/21 8:23 AM, Michael or Penny Novack wrote: Most people might prefer to put files they create in a "documents" directory. /In other words, you might under documents create a folder with a name like gnucash-data and use THAT as a place to store your gnucash data./ / / /If all the files you create are somewhere in the documents folder, then to back up your data you just need to every so often make a copy of THAT to external storage. Learning how to back up data is important because someday your device WILL fail./ / / /Michael D Novack / As part of a holistic backup strategy for ALL of your data. Not just GnuCash data. -- 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] UK specific: MTD - Making Tax Digital
On 1/17/21 1:28 AM, Liz wrote: On Sun, 17 Jan 2021 02:52:19 -0600 (CST) "chr...@floatdene.com" wrote: As there are only about 6 users interested, it is definitely not worth the effort! While you have only counted 6 who have put up their hand so far, I think that there would be far more interested in a usable system. It doesn't include me, I live elsewhere. Liz _ I used to help out with a non-profit radio station. For every response they figured there were an additional 6-7 folks who where thinking the same thing but didn't respond. Based on marketing studies. -- 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] Recent list in file menu
On 1/16/21 9:15 AM, Michael Hendry wrote: On 15 Jan 2021, at 03:30, David Carlson wrote: Maybe I searched for the wrong term. I would never have guessed to search for plist or mru, for example. I’ve found the relevant file here: ~/Library/Preferences/org.gnucash.Gnucash.plist but I can’t locate the Key that defines the maximum number of recently-used files for display (hereinafter called “MRU_MAX"), which defaults to 4 on my iMac Catalina running 4.4. I notice that the Keys org.gnucash.history.file0 to org.gnucash.history.file9 contain fully qualified filenames for the ten books I have opened most recently, which suggests that MRU_MAX up to 10 could be supported if the default of 4 were changed. There seems not to ba a way of adjusting MRU_MAX using GnuCash’s Preferences, so I’m stuck! Regards, Michael Check the recent archives as I remember a discussion that if the key entry doesn't exist, it defaults to 4. You have to create the entry name/value pair in order to change it. They gave the key name in that discussion. -- 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] UK specific: MTD - Making Tax Digital
On 1/18/21 11:22 AM, Michael or Penny Novack wrote: Good points. I have bridge software already working and approved by HMRC for use. My initial thought was to have a report in GnuCash that generated the VAT report for a period. There would then be a menu option to submit VAT. This menu option would generate a csv file containing the VAT values for submission. The bridge software is then invoked independently and submits the VAT return to HMRC. As there are only about 6 users interested, it is definitely not worth the effort! That is actually a good approach. Look at it from my point of view, living over here, 50 states potentially each requiring sales tax filed electronic (actually, not all states impose a sales tax -- but of those that do, neither the tax rates nor on what sorts of things imposed is uniform) That sort of detail is best kept out of the accounting program itself. Then users need only install whatever bridges and filing apps which would be needed for their jurisdiction(s)* Michael D Novack * plural, because a business would need to file to every state it had customers in I have customers in a number of states. But I have "presence" in only one (so far). I need file only in the states where I have "presence". And, yes, keep that out of GnuCash. 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] Linux build
On 12/31/20 12:05 PM, Jimmy R via gnucash-user wrote: Or is this all that is necessary to build mkdir build-gnucash-4. # create the build directory - Note: Named to identify the source since it is not necessarily within the source directory. cd build-gnucash-4.# change into the build directory cmake -DCMAKE_INSTALL_PREFIX=$HOME/opt ../gnucash-4. # As shown this will install in the opt directory in /home/. make # builds the program and associated libraries make install Jimmy Those are the steps I use in Ubuntu. I still need to move to 4.x myself so it has been awhile since I did that (last on 18.10). --Steve -- 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] Changing multiple transactions
On 1/31/21 12:26 PM, Jeff Rizzo wrote: On 1/31/21 12:05 PM, Stephen M. Butler wrote: PS If using a database back-end and you have experience as a database admin or programmer then use the database tools to effect the changes. Again, make that backup first and loop around as needed until GnC looks good. Yeah, since I'm using the sqlite back end I'd already thought about this but was hoping there's a better way - I'll see how this goes. Last year at the job I had at the time I had to scold the software designers every time I came across an admin function that required going to the database directly - because we all know how bad an idea it is. :) To err is human. It requires a computer to really foul things up -- especially if you ask the DBA (me in a former life) to fix a few million transactions with "this script"). PPS Backups are mandatory. Yeah, they will be, once I get enough useful data in there that I don't keep starting over from scratch. Since I sent out the original email, I've realized that it's any kind of bulk editing that will require this, and turns out, apparently I really like to change multiple things at once. I'll give it a try and see if it's worth it. Oh. Starting over from scratch? Just train the importer (you will have to do that anyway over time). Don't let them go to the imbalance account in the first place. If importing a CSV file, create an extra column that you call the transfer account (or something like that) and put your own strings in there for the different accounts. During the import GnC will ask you for the real account name for each of those strings. It will ask only once per string rather than each time it encounters that same string (as would be done if matching on something else). -- 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] Multi-column balance sheet report
On the main GnC menu, pick Reports. Then pick Experimental. Look for the ones that have "(Multicolumn)" in their name. On 1/31/21 1:04 PM, Marcus Winston wrote: Hi all, I just found this thread on the web: https://gnucash.uservoice.com/forums/101223-feature-request/suggestions/2149519-reporting-multiple-periods Given the date on the post from Geert Janssens, I'm guessing this report or capability isn't included in my GnuCash version 3.6 (from ~1.5 years back). Is there any way I can download this thing and get it working in my GnuCash (on Linux)? I didn't find any download links on the above page. Thanks. -marcus ___ 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] Changing multiple transactions
I have not had to do this at a large enough level to warrant the below: 1. Make a backup copy of your file (I presume you are using XML instead of a database back-end). 2. Export all the transactions from the Imbalance Account (getting the other splits also). 3. Delete the entire Imbalance Account and all associated transactions (why you needed to export the other splits). 4. Pull the export from #2 into a spreadsheet or other editing tool and make the assignments. 5. Import the multi-split edited file from #4 into GnC. 6. Do reports and other sanity checks to ensure everything is right. That's the safe and logical way. The other way is not safe and could really mess things up so you still need a backup: 1. Make that backup. 2. Un-Compress the XML file so you can humanly read the contents. 3. Figure out which fields you need to edit on which transactions (note -- I've not used an XML editor so don't know how easy this might be. I'd probably use vi or sed myself and groan inwardly.) 4. Make those edits. 5 Do the reports and other sanity checks to ensure everything is right. 6. Go back to the backup copy and try again since #5 wasn't right. Note: Loop through these steps as many times as needed until #5 looks good. --Steve PS If using a database back-end and you have experience as a database admin or programmer then use the database tools to effect the changes. Again, make that backup first and loop around as needed until GnC looks good. PPS Backups are mandatory. On 1/31/21 11:35 AM, Jeff Rizzo wrote: Hi- I'm currently trying to get my financial house back in order after some years, and have been pleasantly surprised with how much progress GNUCash has made since last I tried to use it (8 or 9 years ago). It seems to fit my need almost perfectly at this point, with one gaping hole - not being able to edit multiple transactions at the same time. :-( (I have read the "Register Tip" that says "There is no direct way to move a large number of transactions from one account to another in GnuCash.") As I'm trying to deal with several years' (two, at this point) worth of data, having to make three clicks to change each transaction is really a drag - and it's quickly sapping my enthusiasm for this project. Is there some workaround that some clever soul out there is using that would speed this up? To clarify, I'm trying to move large numbers of similar transactions from the "Imbalance" account to where they actually belong, so I don't see how I could easily do this by deleting an account. Thanks, +j ___ 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] mysql setup in linux (debian)
On 2/1/21 10:36 AM, gnu Gord wrote: Thanks to all that commented on this and thanks to the '/tmp/gnucash.trace' file, I think I have discovered the problem. It appears that mysql (or somewhere in the backend of gnuCash) does not like a back slash character as the last character in a field. The data I was trying to save had one entry with a 'notes' field that had a backslash as the last character. The text was "2 books one for A one for\". It appears when I save this as an XML file there is no problem but if I try to save this as a mysql I get an error message. A backslash other than at the end of the field does not appear to cause a problem. BTW if I remove the backslash and successfully save to a mysql file and then go back into the register GnuCash will not let me add a backslash to a field. However, if I save it as an XML file the backslash is allowed. Looks like you are on a Linux/Unix box. The backslash is the escape character. It probably ate the ending quote mark. I think you can get the backslash by escaping it! Yes, escape the escape character. \\ -- 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] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST CURIOUS
On 6/2/21 2:36 PM, David Carlson wrote: Stephen, There have been several posts explaining why it can be desirable to allow postponement of the completion of a balanced transaction because not all the details are known but the core of the transaction should not be postponed into oblivion. I was responding to the question "Why delete an account that's only going to get created again?". Not commenting on whether or not the account should be created as needed. Yes, most times being more careful will eliminate the sudden appearance of the account. Again, note the "most". On Wed, Jun 2, 2021 at 4:24 PM Stephen M. Butler mailto:stephen.m.butle...@gmail.com>> wrote: On 6/2/21 11:22 AM, D. via gnucash-user wrote: > Why delete an account that's only going to get created again? 1. So you know when something needs attention. 2. Make you more careful to not let the account be created in the first place. --Steve > > > Original Message > From: Michael Hendry mailto:hendry.mich...@gmail.com>> > Sent: Wed Jun 02 12:25:39 EDT 2021 > To: Peter West mailto:p...@pbw.id.au>> > Cc: GnuCash users group mailto:gnucash-user@gnucash.org>> > Subject: Re: [GNC] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST CURIOUS > >> On 2 Jun 2021, at 02:44, Peter West mailto:p...@pbw.id.au>> wrote: >> >> I’m a fairly naive user, but I find the Imbalance-XXX and Orphan-XXX accounts (at top level in my CoA) extremely useful, and I understand why they are there. If I ever see a balance, I know I have to fix something, which is a good reason to have them at the top. I can’t comment on any changes that might have occurred in the behaviour of these accounts recently. However, in respect of the tidiness of the CoA, one possible solution is to create a special case for these accounts, such that they only display in the CoA listing when they have a non-zero balance. >> >> Peter > > Why not simply delete the Imbalance and Orphan accounts when you’ve sorted out the problem and zeroed their contents - they’ll be created automatically if required. > > Michael > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user <https://lists.gnucash.org/mailman/listinfo/gnucash-user> > If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists <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 <mailto:gnucash-user@gnucash.org> > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user <https://lists.gnucash.org/mailman/listinfo/gnucash-user> > If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists <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 <mailto:stephen.m.butle...@gmail.com> kg...@arrl.net <mailto: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 <mailto:gnucash-user@gnucash.org> To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user <https://lists.gnucash.org/mailman/listinfo/gnucash-user> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists <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 -- 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 maili
Re: [GNC] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST CURIOUS
On 6/2/21 11:22 AM, D. via gnucash-user wrote: Why delete an account that's only going to get created again? 1. So you know when something needs attention. 2. Make you more careful to not let the account be created in the first place. --Steve Original Message From: Michael Hendry Sent: Wed Jun 02 12:25:39 EDT 2021 To: Peter West Cc: GnuCash users group Subject: Re: [GNC] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST CURIOUS On 2 Jun 2021, at 02:44, Peter West wrote: I’m a fairly naive user, but I find the Imbalance-XXX and Orphan-XXX accounts (at top level in my CoA) extremely useful, and I understand why they are there. If I ever see a balance, I know I have to fix something, which is a good reason to have them at the top. I can’t comment on any changes that might have occurred in the behaviour of these accounts recently. However, in respect of the tidiness of the CoA, one possible solution is to create a special case for these accounts, such that they only display in the CoA listing when they have a non-zero balance. Peter Why not simply delete the Imbalance and Orphan accounts when you’ve sorted out the problem and zeroed their contents - they’ll be created automatically if required. Michael ___ 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. -- 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] Accounting for GST in Australia
On 7/7/21 8:33 AM, Michael or Penny Novack wrote: On 7/7/2021 7:41 AM, flywire wrote: GST is only really supported if it's auto-calculated otherwise a user has to enter twice the splits with the associated logic and keying errors. I've only been using the Account Register for data entry. But GST in Australia appears to be a simple problem compared to "sales tax" here. Which not only varies by state (with respect to rate) but on what is or is not subject to the sales tax. Here in Washington of the USA, sales tax is based on your address. I've seen houses sitting next to each other that are in different tax districts with different rates. Most POS systems just go down to the zip code level so I have to pick the "most popular" tax rate for each zip code. <> This may be too much to expect from an ACCOUNTING system like gnucash if we expect automation. Usually this sort of thing is handled by what is called a POS system (point of sales) which builds the invoice of sales receipt << it will have the total sales tax attributed to this sale figured by adding up the sales tax on each item since whether taxable or at what rate depends on the item >> Such systems also need to make provision of "no tax" sales where the buyer has a certificate of exemption on file with the vendor. Typically a POS system is paired with an accounting system. The latter has only to be able to accept the transaction as created by the POS, not figure it out. Yes. Now if I would only take the time to figure out the multi-split import. But not enough sales to force me into making that effort!! So far I just dump a report for the daily deposit showing the half-dozen amounts (splits) that make up the transaction and manually enter them. Usually I can take the last sale and duplicate it for the next one (with minor changes for the local tax and net deposit). Michael D Novack --Steve ___ 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] Loan
On 2/7/21 1:36 AM, Petros Tenezakis wrote: How do set up initital balance for a loan. I owe for an example 1 USD to Example Bank I find it best to break actions like this into the different components. 1. First item is to realize this will result in you having a liability. This means you will need to setup an account in the liability section of your Chart of Accounts (COA). If you have other liabilities (loans) with this same bank, you should make each one a sub-account under a placeholder account for the bank. That way yo u know at a glance the total outstanding amount you owe this bank. 2. Next, the initial transaction will set the opening balance and also track where that money went. Perhaps it was deposited directly into you checking account (an asset) or it went to purchase a house (also an asset with some expenses for the closing costs) or was used to pay off credit-cards or other short/long-term loans (liabilities). The main item to remember is that the liability will be the credit side of the transactions with the other splits being the debit side. This means that an increase to an asset goes on the debit side of that account as also an increase to expense. 3. Finally, be sure you have the correct date on this transaction that all of the debits add up to the $10,000 credit . 4. Now you can setup a schedule payment plan to pay off this debit. You can even add a transaction to the scheduler so that the payment transaction will show up in the proper accounts each month. -- 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] Filtering reports on contents of Memo field
On 2/7/21 10:10 AM, Adrien Monteleone wrote: If you are treating members as 'customers' then you may have other options. Otherwise, you'd have to go through the equally tedious task of setting up sub-accounts for each member, or creating a saved report configuration for each member. The Transaction Report does offer filtering capabilities that you can use on a Memo field for that last option. Another alternative for a consolidated report might work: The Transaction Report also lets you sort by the Memo field, so if you choose only the Gift Aid account, and the Memo starts with/contains only the Member names, you might be able to get subtotals for each member. (if that is what you are looking for) In either case, no need to filter date range for the account view first, you'll do that in the report options. If you want individualized reports per member, then you can still use that last option, but you'll need to save each as a Report Configuration and just name it for each Member. Then run them one at a time as needed. What if the Memo field contains "Member: member last, first name" so that the filter was on the leading "Member: " portion but you still sorted by the Memo field. Wouldn't each break based on the remainder of that field trigger a total line? In that way this would be just one report without having to know if new members were added or removed. --Steve Hope that helps. Regards, Adrien On 2/6/21 5:56 AM, Michael Hendry wrote: Our Rotary Club hasn’t been able to meet in the flesh since the beginning of Covid, and we haven’t been able to run any fundraisers. One of our members suggested that each of us might consider donating the cost of the meal (and the associated glass or two of wine|) to the club’s charity account as a way of keeping some money coming in. As this is entirely voluntary and comparisons would be invidious if issued in reports, I’ve recorded the chosen a chosen destination in the description field of each transaction, and recorded the donor's name in the Memo. This way I can simply exclude Memo from reports. I’m now looking at making a Gift Aid claim for all these donations at the end of March, and I’ve found that the Spreadsheet I created to keep track of the Gift Aid side of the accounts has got out of step with the Gnucash record. I’ve managed to reconcile these by opening the account which receives these donations, filtering by date, using Find to pick up one member at a time in this account in the Memo and Reporting the findings (which provides a total in addition to the individual donations). This is a tedious and error-prone procedure which I would like to be able to automate. As far as I can see, there isn’t a way of setting up multiple such reports in advance and running it at the end of the tax year (or indeed as an ad-hoc report during the year) to get it all done in one go, and I’d have to export the account to CSV and sort by Memo to separate the donations by member, and then extract the total-contributions-by-member to generate the Gift Aid Claim. That’s unless one of you wise ones can suggest another route… Perhaps more in hope than expectation, -- 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] Filtering reports on contents of Memo field
On 2/10/21 12:38 AM, Michael Hendry wrote: On 8 Feb 2021, at 15:40, Michael Hendry wrote: On 7 Feb 2021, at 18:22, Stephen M. Butler wrote: On 2/7/21 10:10 AM, Adrien Monteleone wrote: If you are treating members as 'customers' then you may have other options. Otherwise, you'd have to go through the equally tedious task of setting up sub-accounts for each member, or creating a saved report configuration for each member. The Transaction Report does offer filtering capabilities that you can use on a Memo field for that last option. Another alternative for a consolidated report might work: The Transaction Report also lets you sort by the Memo field, so if you choose only the Gift Aid account, and the Memo starts with/contains only the Member names, you might be able to get subtotals for each member. (if that is what you are looking for) In either case, no need to filter date range for the account view first, you'll do that in the report options. Date Range isn’t available when adjusting report options, as far as I can see. Should be under the General Tab in Options. If you want individualized reports per member, then you can still use that last option, but you'll need to save each as a Report Configuration and just name it for each Member. Then run them one at a time as needed. What if the Memo field contains "Member: member last, first name" so that the filter was on the leading "Member: " portion but you still sorted by the Memo field. Wouldn't each break based on the remainder of that field trigger a total line? In that way this would be just one report without having to know if new members were added or removed. --Steve Thanks, Steve. I’ve tried just putting “M: “ in front of a few of the names in the memo filed, sorting by memo field and then using Cmd-F to search for “M: “ contained in the memo field, and that looks promising. The transaction report derived from this won’t produce sub-totals by member, but the Gift Aid claim has to be itemised by date so that’s not a huge problem. I’ll polish it and report back. Michael Confirming that this procedure allows me to produce a single report that covers my needs, with each member’s Gift-Aid-claimable donations listed in alphabetical order, and takes account of the fact that the Income:GA account is the parent of several accounts which specify the nominated destination for the donations, such as Income:GA:Foundation, Income:GA:PolioPlus. Michael. -- 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] Filtering reports on contents of Memo field
On 2/10/21 2:56 PM, Michael Hendry wrote: On 10 Feb 2021, at 18:47, Stephen M. Butler wrote: On 2/10/21 12:38 AM, Michael Hendry wrote: On 8 Feb 2021, at 15:40, Michael Hendry wrote: On 7 Feb 2021, at 18:22, Stephen M. Butler wrote: On 2/7/21 10:10 AM, Adrien Monteleone wrote: If you are treating members as 'customers' then you may have other options. Otherwise, you'd have to go through the equally tedious task of setting up sub-accounts for each member, or creating a saved report configuration for each member. The Transaction Report does offer filtering capabilities that you can use on a Memo field for that last option. Another alternative for a consolidated report might work: The Transaction Report also lets you sort by the Memo field, so if you choose only the Gift Aid account, and the Memo starts with/contains only the Member names, you might be able to get subtotals for each member. (if that is what you are looking for) In either case, no need to filter date range for the account view first, you'll do that in the report options. Date Range isn’t available when adjusting report options, as far as I can see. Should be under the General Tab in Options. Thanks, Steve, but this screenshot says “no”. https://www.dropbox.com/s/ul04nrhddesniy8/Screenshot%202021-02-10%20at%2022.52.20.png?dl=0 Aha. I did think you were in the Transaction Report. I do see that Account Summary doesn't have a date attached to it. I got there by opening the account in question and using Reports->Account Report to produce the report and then clicking the “Options” button. Am I missing an alternative route? Regards, Michael -- 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] Changing multiple transactions
On 2/1/21 4:45 AM, Michael or Penny Novack wrote: On 1/31/2021 5:30 PM, Stephen M. Butler wrote: To err is human. It requires a computer to really foul things up -- especially if you ask the DBA (me in a former life) to fix a few million transactions with "this script"). As somebody who did this sort of thing in my working days, I will second what Stephen just said. Leave it to the pros. It is very easy to get this sort of thing wrong << I'd be the person they'd ask "Mike, can you write something to convert the database instead of having a dozen workers sit at their terminal for a couple weeks re-entering the corrected data?" >> It wasn't the sort of thing even the average programmer in the shop could be trusted to get right. ^ Many times they tried and failed. Then it was, "hey, can you fix this?" Sometimes it could be done. Most times "Sorry, its FUBAR. Need to rollback." and "Why did you get a copy of production put into the test environment to do the final test?" Results --> dear in headlights look. Had one friend who worked for that big kite factory around Seattle. His complaint was their attitude of "Production if good". -- 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] How to code merchant refunds
On 3/24/21 6:47 AM, Mike via gnucash-user wrote: How should merchant refunds be coded? Are they income? Mike White From the purchaser point of view: Not income -- you will not pay taxes on this. It is just a reduction of what you paid. So a reduction of the expense. From the merchants point of view: Still not income. Actually a reduction in income as the merchant now "sells" the product for less than expected. So, are you the purchaser or the merchant? --Steve -- 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] How to code merchant refunds
On 3/24/21 7:48 AM, Mike via gnucash-user wrote: So you suggest I go to the original entry and reduce the amount spent by the amount refunded? Mike Nope. New entry with a new date but affecting the same expense account but in the opposite direction. --Steve On 3/24/21 9:27 AM, Michael or Penny Novack wrote: On 3/24/2021 9:47 AM, Mike via gnucash-user wrote: How should merchant refunds be coded? Are they income? Mike White ___ I would think better to consider a reduction of the expense. If you treated as income, equivalent to an overstatement of both income and expense. Michael D Novack -- 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] Confused Entering A Refund To Credit Card Account
uot;... and click on view to see your view options. TRY "journal view". Does what you see when you enter a "split" make any more sense Michael D Novack * PS -- that is with a ONE SIDED split and starting with the largest amount. If the transaction is split on both sides, more than one debt and more than one credit the amount for no account is going to be the "total" << although starting by "lying", starting with the total as the amount for the account you begin with and changing it later is one useful trick >> -- 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] Entering A Scheduled Transaction Early
Or adjust the Create X days in advance and run for this month (as noted by another response), modify the date on the created transaction, reset the Create X days in advance to desired value. All can be done without restarting GnC. On 4/4/21 6:24 AM, Glenn Fowler wrote: I can think of two ways. You can just leave it for the 15th and then after this month posts just manually edit to the desired date. You can also start the scheduled transactions next month and do a manual entry this month. On Sun, Apr 4, 2021, 8:29 AM Jack Frillman via gnucash-user < gnucash-user@gnucash.org> wrote: I have a scheduled transaction for the 15th of each month. This month and only this one time I want to make it before it's scheduled date of the 15th. How can easily I do that? The only way I could see how to do it was going into the scheduled transactions options, adjusting the day ahead value, exit GNUCash, restart and change the day ahead value back to zero. Thanks. -- Old Unix programmers never die, they just mv to /dev/null - Anonymous ___ 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. -- 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] Entering A Scheduled Transaction Early
You will have to do some manual work. This is how I would do it: 1. Edit the scheduled transaction to Create 15 days in advance. 2. Run the schedule transactions since last run to create the entry in the journal and update the scheduler so it knows that transaction was already created. 3. Modify the date on the just created transaction. 4. Edit the scheduled transaction to revert the Create Days in Advance to original value. That, to me, is the least painful method to get the entry to show up so you can edit it AND update the scheduler so it knows it was already generated for this month. On 4/4/21 2:44 PM, Jack Frillman via gnucash-user wrote: I have a transaction scheduled for the 15th of every month. Today something occurred where I want to make that transaction today, the 4th, and have it count as if the transaction occurred on the 15th and the next scheduled transaction date is the following month without having to go thought the process of adjusting the schedule dates manually. On 4/4/21 12:25 PM, Michael Hendry wrote: On 4 Apr 2021, at 15:30, Jack Frillman via gnucash-user wrote: That's not what I was trying to do. Is this scheduled transaction (Sx) the first of a series (A), or is it part of an existing series which is to be paid earlier than normal? (B) If (A): create the Sx with the early start date, and adjust the Sx after that date has past. If (B): duplicate last month’s (already created) transaction, and put in the desired date. Adjust the Sx so that its first payment will be next month. If neither (A) nor (B) please explain what you are trying to do. Regards, Michael -- 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] Transaction Reconcile behavior differences
On 2/23/21 4:13 AM, John Nickell wrote: I recently switched from GnuCash on Linux Mint to GnuCash on Windows. I brought the same GnuCash data file over between computers. My checking account is setup in GnuCash as a parent account with multiple sub accounts to the checking account. When reconciling (including sub accounts) on Linux if I selected a transaction that had multiple splits or was simply a transfer among sub accounts, all of the transaction splits that were part of that same transaction would also be marked as reconciled. (i.e. their box would be checked and the reconcile balance would reflect a $0 change.) When reconciling on Windows I'm having to reconcile each split individually and if the transaction is between two sub accounts within the checking account I must reconcile both the debit and the credit action separately. Is this expected and desired on the Windows version of GnuCash, or is there a setting I'm missing so that a reconciling "part" of a transaction reconciles all of the transaction within the account? I'm not looking for a reconciliation in my checking account to reconcile the transaction split in the savings account, but for transaction splits that are within the same parent checking account being reconciled I'd like to see similar behavior as I saw on the Linux version. Or at least understand this is 'expected'. I've made pretty heavy use of these split transaction types and this unexpected difference in transferring OS's has slowed down my reconciliation process. If an example helps: I us a single transaction to transfer a $1000 paycheck into three sub accounts. $300 for Automobile, $500 for Savings, $200 for Food. All are still within the same parent checking account. In Linux checking the box to reconcile the $200 food transaction would also check the Automobile, Savings and $1000 split. I would consider that a bug on the Linux side. I sometimes generate a multi-part transaction that has two parts on the checking side. Those two parts take different path and one general reconciles several days before the other. I, personally, would want to reconcile each split separately. In my experience with Windows all 4 transaction splits must be "checked" individually. Checking Food Automobile Savings Thanks ___ 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] 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] 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] Lock file problems -- won't open current file, claiming can't get lockfile
Which version of GnuCash? What O/S? What are the folder permission where you are saving the file? XML or database backend? Which database? You say it refuses to open -- but then you indicate it does open with "Open Anyways". So, before you run the app, do you have a lock file in the folder? On 2/4/21 11:18 AM, Cricket Onebit wrote: Even if I save immediately before closing the program, it refuses to open the file. I'm making do with Open Anyways, then Save As and changing the file name, but I don't think that's a good plan for the long run. Any ideas? -- 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] 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.
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.
Re: [GNC] Assets vs. expenses vs. income entry
On 2/21/21 5:45 PM, Stan Brown wrote: On 2021-02-21 15:22, gnu Gord wrote: I'm unsure of the best way to record the adding/modifying of an asset. Should the transaction go directly to an asset account or an expense account then create an asset? Let me explain. I started writing out a detailed reply, but David Cousens said it all well, and rather than just pile on I will say that I agree with what he said. I'll add one thing: if you find yourself asking "should I record a transaction to equity", the answer is almost certainly No. Changes in your net worth arise from income and expenses, so they should be recorded in the appropriate Income or Expense accounts. Buying an asset doesn't change your net worth, and therefore it is not income or expense; the same is true of paying a bill or paying principal on a loan. (The interest portion of a loan payment is an expense; the principal portion is just a debit to a liability account.) This page has become a reference page for me -- unless my wife is around and then it is easier to ask her. https://www.accountingtools.com/articles/2017/5/17/debits-and-credits The summary: Credits go next to the window -- just gotta remember which chair I need to set in when making that amazing discovery. <right when facing computer screen>> Debit Accounts -- increase in value on a debit entry: Assets, Expenses, Losses. Note that a credit to these accounts reduce value. Credit Accounts -- increase in value on a credit entry: Liabilities, Equity/Capital, Income/Revenue, Gains. A debit to these accounts reduces value. -- 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] Non-Scheduled Transaction ???
Did some additional testing as requested. 1. If the Create Automatically is not checked, and it is time to fire (or past time in my tests) then user is presented the option to review the transactions (including the ones that were auto-created=Y). If you click CANCEL then the one not auto-created is not added to the journal. If you click OK (without reviewing) then it is created. The ones that were auto-created stayed in the journal if you did click CANCEL. 2. If the Create Automatically is checked and the scheduled transaction fired, THEN if Notify is checked, you are presented the option to review the transactions. Whether you click CANCEL or OK, the transactions remain in the Journal. 3. If the Create Automatically is checked and the scheduled transactions fired, THEN if Notify is not checked you get the confusing message noted below. Notes: 1. if multiple scheduled transactions are fired that include Cases a mix of 1, 2, and/or 3, then Cases 1 and 2 will override case 3 and present you the list. 2. Notify can only be checked if Create Auto is also checked. Bug 798121 <https://bugs.gnucash.org/show_bug.cgi?id=798121> has been successfully created --Steve On 2/10/21 7:13 PM, Adrien Monteleone wrote: That indeed appears confusing. I'm going to hazard a guess that it means there are none for you to review prior to creation, absent auto-creation. (do a test SX, set to not auto-create, then run the dialog. It should show it to you as 'to create') Perhaps it should read, "There are no Scheduled Transactions to be manually entered at this time. (one transaction automatically created)" That would likely get fixed in the next release if you file a bug on it. It seems just a matter of wording. Regards, Adrien On 2/10/21 8:54 PM, Stephen M. Butler wrote: I'm still on Version: 3.10 Build ID: 3.10+(2020-04-11) on Ubuntu 20.10. Did not go looking for the thread in which this was mentioned. This evening when I popped GnC open, it reported: "There are no Scheduled Transactions to be entered at this time. (One transaction automatically created)." Screen Was only given the option to Close the information window. I did check the general journal and a scheduled transaction for 15 days out was created. I checked that scheduled transaction and it was set to be created 15 days out (which would have been today). -- 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] Reverse all transactions
Do you have a backup of the database from before these entries? If so, can you restore that database to that state and start over? Note: if there have been a lot of other transactions entered in the interim, then the above may not be an option. 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. Note that there is an option on a transaction-by-transaction basis to auto-generate a reversing entry. You would need to do that twice in order to get the effect you need. Again, that is a manual effort on one transaction at a time. On 2/11/21 12:33 PM, Derek Atkins wrote: Hi, On Thu, February 11, 2021 3:26 pm, Anton Gladky wrote: Hi Derek, Thanks for a quick reply! How did the entries get input into GnuCash? Manually, but in a reverse order. Why do you believe they are incorrect (reversed)? Well all entries in "Expenses" are in "Rebate" column, and all entries in "Income" are in "Charge" column. So I believe all of them need to be reversed. Now the root structure looks like this: Assets: -10 Expenses: -10 Income: 10 Two things: 1) Yes, this definitely looks wrong. Sorry. 2) From my experience it's much better (and easier) to enter transactions from Asset and Liability accounts instead of Income and Asset accounts. I'm afraid you're going to have to re-enter your data. You can TRY to export it to CSV, manipulate it there, and then import. -derek Thanks Anton Am Do., 11. Feb. 2021 um 21:17 Uhr schrieb Derek Atkins : Hi, On Thu, February 11, 2021 3:12 pm, Anton Gladky wrote: Dear all, I need to reverse all transactions in a relatively large database. Something like "Increase <-> Decrease" for all entries. Is there any effective way to do it? Maybe, is it possible to operate on sqlte-database directly? How did the entries get input into GnuCash? Why do you believe they are incorrect (reversed)? In short, no, there is no way to do it, and hand-modifying the database could corrupt it. But depending how the transactions were entered, there may be an easy way to "start over" and do it correctly --- assuming that they ARE incorrect. GnuCash has a preference to "reverse" the sign on some normally-negative accounts, so it's also possible that setting is incorrect, but your data is correct. This is why I'm asking the questions above. Hope this helps, Thanks Anton Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant -- 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] Account setupI
On 9/28/21 10:16 AM, Rogier F. van Vlissingen wrote: Thanks to everyone for helping out. What worked for me in the end was 1. to set up the COA first, without attempting any opening balances, and then 2. to create a single transaction to set up the opening balances on 1/1/2020. As it was, I had an ending trial balance on 12/31/2020, but there were a few mistakes floating around, so in my setup, I made those corrections, and settled it against retained earnings, by making that the final line item in my opening transaction. - One thing I was not able to figure out. If I do set up this way, and I made a mistake in my initial g/l transaction is there a way to edit that transaction, or am I doomed to simply start over and do it the right way? - And since I made a false starts, I now have a couple of sets of books that I want to get rid of, but I wasn't sure how to do it, other than just deleting the file in the file system. <> Rogier, (my apology for not spelling it correctly on my last reply) I have been able to edit that transaction even years later as I recently found some additional items that should have been entered -- but weren't. I know the purist will say that you should just create an additional transaction for that date with the adjustments. I am not a purist! This works for me. Yes, I am able to add new lines to the original transaction, change existing amounts, even delete a line that turned out to be a duplicate. You can always edit a transaction. This is a nice thing. This is a bad thing. This will help get you out of trouble. This will get you into trouble. Beware! Your books are only as good as you make them. --Steve -- 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] Account setup
Roger, I found it easier to leave all the opening balances at zero while setting up the chart of accounts (COA). Then I create one massive opening transaction dated (in your case) 12/31/2019. That way, if I find I forgot one account, I can add it later then go back and adjust the opening transaction to include an entry for that new account (I know the purist will have nightmares and would prefer you add a new transaction). --Steve On 9/22/21 12:43 PM, Rogier F. van Vlissingen wrote: I am struggling to move an existing business into gnucash. Have a closing trial balance @ year end 2019 In the setup screen I don't necessarily have all the accounts, so I imagine I can set them up later, but some accounts that area available do not let me put in an opening balance. E.g. "retained earnings" has a balance, but in the set up screen there is a greyed out "zero" and I cannot set up the opening balance. Can I edit that later? I tried this before, but was never able to figure it out. -- 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.