Please unsub me from the list, thankyou.
On Monday, March 18th, 2024 at 8:47 AM, [email protected] <[email protected]> wrote: > > > Send gnucash-user mailing list submissions to > [email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.gnucash.org/mailman/listinfo/gnucash-user > or, via email, send a message with subject or body 'help' to > [email protected] > > You can reach the person managing the list at > [email protected] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of gnucash-user digest..." > > > Today's Topics: > > 1. gnucash suggestions (J. A. Harris) > 2. Re: UNSUBCRIBE and Lemmy.World (Kalpesh Patel) > 3. Re: gnucash suggestions (Michael or Penny Novack) > 4. Re: UNSUBCRIBE and Lemmy.World (Michael or Penny Novack) > 5. Re: gnucash suggestions (J. A. Harris) > 6. Re: gnucash suggestions (Stan Brown (using GC 4.14)) > 7. Re: Separating tax years for payments in next year (NoobAlice) > 8. Re: gnucash-user Digest, Vol 252, Issue 33 (Anon20x) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Sun, 17 Mar 2024 12:15:28 -0400 > From: "J. A. Harris" [email protected] > > To: [email protected] > Subject: [GNC] gnucash suggestions > Message-ID: [email protected] > > Content-Type: text/plain; charset=UTF-8; format=flowed > > I have been using gnucash for almost 10 years now.? I have downloaded > the source code and even made some changes to it that I consider > improvement.? There are other changes that I think would be a good > idea.? If this is not the place to share such comments, I apologize. > > 1. I use gnucash on a computer with a large screen,? I have a source > code modification that adds including the Assoc and Notes fields to > the single-line Basic Ledger view.? For me, those fields are too > important to require going double-line (which cuts in half the > entries in the window) and there is plenty of room on a desktop > monitor to accommodate the extra width needed. I think this would be > a nice option for many users. > 2. Add a new Generic and INC+EXP account.? No doubt this violates basic > accounting rules but for an amateur like me, it is useful to have a > single book in which I can separate sections like reserves, > retirement, and operating items.? Accounts of type Generic could > have sub-accounts of any type.? Accounts of type INC+EXP would act > as an Income account and as Expense account. For example, if there > were a mixture of Income and Expense accounts under a INC+EXP > account, a search in the tax system for Income accounts would find > them and a search for Expense accounts would find them.? As it > stands now, that top level account must be either Income or Expense > and Income accounts are not found if the top-level account is > Expense and vice-versa. (With an INC+EXP type, it would also permit > restricting subaccounts under Income to be just Income and under > Expense just Expense.) > 3. Sorting occurs in many different places: in register displays, in > reports, in the listing of accounts in the transfer field, etc.? If > the natural sort organization for my accounts is by account code, I > find it confusing inconvenient when that is not the default sorting > used in reports, budgets, transfer menu, etc. > 4. Give the users the ability to create new "currencies".? There are a > number of occasions where I have assets which have a dollar value > but the accounting of that asset uses a different measure.? Some > examples include airline loyalty points, miles driven that have a > tax deduction value, etc. ? Doing this through FUND or NYSE does not > work because those things cannot be used in account types where > Currencies can be used. > > > -- > ---- > Dr. J. A. Harris > > > ------------------------------ > > Message: 2 > Date: Sun, 17 Mar 2024 12:39:32 -0400 > From: "Kalpesh Patel" [email protected] > > To: [email protected] > > Subject: Re: [GNC] UNSUBCRIBE and Lemmy.World > Message-ID: [email protected] > > Content-Type: text/plain; charset="utf-8" > > If the e-mail client is configured via IMAP access to email server, then > whatever email is deleted on your client is also removed from your server so > you don't need to clean up multiple times... IMAP keeps "one" view for all of > the email clients that access those emails. > > My outlook client is configured to move messages to 'Deleted Item' and then > it is further configured to delete them permanently after 30 days. One rule > has multiple email addresses of all the sources which should go to 'Deleted > Items' automatically. > > Go to explore the capabilities of the tools to employ for various tasks... > > > -----Original Message----- > From: Michael or Penny Novack [email protected] > > Sent: Saturday, March 16, 2024 7:41 PM > To: [email protected] > Subject: Re: [GNC] UNSUBCRIBE and Lemmy.World > > On 3/16/2024 5:40 PM, Ken Farley wrote: > > > Unsubscribing isn't done by the list, it's just posts of questions > > like yours. > > > > To unsubscribe, you need to go to: > > > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > > > To be honest, I don't allow the deluge of emails to come to me, > > either. Too many to have to sift through every day. > > > << not about gnucash -- but about this specific issue >> > > > If you are an EMAIL user (not WEBMAIL) then your email client (Outlook, > Thunderbird, etc.) almost certainly provides a facility for you to create > "message filter rules". You can then add a rule so that emails coming from a > particular source (say this email list) get moved to a dedicated folder > instead of appearing in your inbox). The only emails that show up in the > inbox here are ones for which I haven't written a rule. > > Then you either sift through them in this other folder or not depending on > whether you have time. Nor do they have to take up space in that folder > forever as you can specify retention policy for that folder. > > Webmail users --- I have no idea if whatever provider you are using offers > similar facilities. > > Michael D Novack > > > > > > > ------------------------------ > > Message: 3 > Date: Sun, 17 Mar 2024 15:54:44 -0400 > From: Michael or Penny Novack [email protected] > > To: [email protected] > Subject: Re: [GNC] gnucash suggestions > Message-ID: [email protected] > > Content-Type: text/plain; charset=UTF-8; format=flowed > > On 3/17/2024 12:15 PM, J. A. Harris wrote: > > > I have been using gnucash for almost 10 years now.? I have downloaded > > the source code and even made some changes to it that I consider > > improvement.? There are other changes that I think would be a good > > idea.? If this is not the place to share such comments, I apologize. > > > 2. Add a new Generic and INC+EXP account.? No doubt this violates basic > > ?? accounting rules but for an amateur like me, it is useful to have a > > ?? single book in which I can separate sections like reserves, > > ?? retirement, and operating items.? Accounts of type Generic could > > ?? have sub-accounts of any type. > > > Your lack of accounting and understanding of the history of double entry > is confusing you. You might think of BOTH types "income" and "expense" > as having a single generic type "temp equity" (not yet recorded against > equity) with the ones with type "expense" just those "temp equity" > accounts whose balance is normally debit and the ones with type "income" > those whose balance is normally credit. Because it is usual to want > reports that group all income accounts together and all expense accounts > together our books tend to reflect that. But sometimes we want to group > a subset of income and a subset of expenses together instead. Some of > the organizations I kept books for did "events" and so might want to > group all associated with an event together. Not hard, there is no magic > in the names "income" and "expense". If the balance is debit, it's and > expense, if credit, an income. > > Thus for an event were EXPECTED to make a profit for the organization, > I'd make them all of type "income". Understand? Yes, what we pay to rent > the venue is an expense of the event, but we can still have an account > name "venue costs" of type INCOME a child of the account that totals all > income and expenses for that event. What makes the charges (the > transactions for) hall rent, chair rent, cleaning, etc. expense is that > they are debits to that account. > > > 4. Give the users the ability to create new "currencies".? There are a > > ?? number of occasions where I have assets which have a dollar value > > ?? but the accounting of that asset uses a different measure. > > > Those are "commodities" ----- "currency" means something is the legal > tender of some sovereign power. BUT --- there might be need to account > for some "local currency" which might not be exchangeable for legal > tender, and commodities are expected to have some money value. Note that > I am not talking about things of no value, just not a money value > (conversion might not be allowed/encouraged). Thus if I were dealing > with something like "Ithaca Dollars I might use gnucash to track my > balance, what I received or used them for, etc. in a separate set of books. > > More awkward, perhaps, assets which have value, possibly significant > value, but unclear/uncertain exactly how much. > > Michael D Novack > > > > ------------------------------ > > Message: 4 > Date: Sun, 17 Mar 2024 16:00:24 -0400 > From: Michael or Penny Novack [email protected] > > To: [email protected] > Subject: Re: [GNC] UNSUBCRIBE and Lemmy.World > Message-ID: [email protected] > > Content-Type: text/plain; charset=UTF-8; format=flowed > > On 3/17/2024 12:39 PM, Kalpesh Patel wrote: > > > If the e-mail client is configured via IMAP access to email server, then > > whatever email is deleted on your client is also removed from your server > > so you don't need to clean up multiple times... IMAP keeps "one" view for > > all of the email clients that access those emails. > > > Or with POP, when POPed. But I was being fussy because MY provider's > server isn't a trained seal. It will disregard that "delete" UNLESS I > configure my my account with them to not use THEIR default of "disobey" > that delete. In other words, besides configuring my email client to > "delete when POPed" I had to also have gone into my account with the > provider and made a change there also. > > Michael D Novack > > > > > ------------------------------ > > Message: 5 > Date: Sun, 17 Mar 2024 17:36:29 -0400 > From: "J. A. Harris" [email protected] > > To: [email protected] > Subject: Re: [GNC] gnucash suggestions > Message-ID: [email protected] > > Content-Type: text/plain; charset=UTF-8; format=flowed > > On 3/17/24 15:54, Michael or Penny Novack wrote: > > > Your lack of accounting and understanding of the history of double > > entry is confusing you. ... > > .. > > > Thus for an event were EXPECTED to make a profit for the organization, > > I'd make them all of type "income". Understand? > > > Yes, I do understand.? The purpose of the INC+EXP would not be to put > entries in.? It would be a placeholder account, under which there would > be Revenue and Expense accounts.? I can think of many situations where > that would be desirable.? Here is one. HOAs frequently use "fund" > accounting where there is an "Operating Fund" and a "Reserve Fund".? > Each of those funds have Income and Expenses (along with other things).? > So you might see a structure like this. > > Top > ??? Operating > ??? ??? Assets ? > ??? ??? Equity ? > ??? ??? Income > ??? ??? ??? Expenses > ??? ??? ??? Revenue > ??? ??? Liabilities ? > ??? Reserve > ??? ??? Assets ? > ??? ??? Equity ? > ??? ??? Income > ??? ??? ??? Expenses > ??? ??? ??? Revenue > ??? ??? Liabilities ? > > In that type of situation, a General account type is useful for the > Operating and Reserve placeholder account and an Inc&Exp type is useful > for the accounts called Income. (Even if you do not want want both > Expenses and Revenues under the placeholder account named Income, you > still cannot put them under Reserve.) > > Are you saying you have never found an occasion where it would be useful > to have an upper-level account above a group of accounts, some of which > were Income and some were Expense? > > On 3/17/24 15:54, Michael or Penny Novack wrote: > > > Those are "commodities" > > > I am aware of that.? Currencies, Funds, and NYSEs are all particular > types of Commodities. There is no current support in gnucash for > defining Commodities other than those three types. Since for things like > airline points, it seemed to me their operational characteristics as > they are used in gnucash are the same as Currencies, I thought it would > be easiest to implement them by adding support for them under the > existing Currency category.? If you prefer, the name could be changed to > Currencies & Other Things.? Or a fourth category could created, although > that would probably increase code complexity? But all that is detail, > which I did not feel needed to be addressed at this point. > > -- > ---- > Dr. J. A. Harris > > > ------------------------------ > > Message: 6 > Date: Sun, 17 Mar 2024 15:08:42 -0700 > From: "Stan Brown (using GC 4.14)" [email protected] > > To: [email protected] > Subject: Re: [GNC] gnucash suggestions > Message-ID: [email protected] > > Content-Type: text/plain; charset=UTF-8 > > It would seem more straightforward just to have separate books for the > two funds. > > That's pretty standard in UK government accounts, for instance: Capital > Account and Revenue Account. (That's if we can believe /Yes, Minister/, > but Margaret Thatcher called it "the best documentary the BBC ever made".) > > Stan Brown > Tehachapi, CA, USA > https://BrownMath.com/ > > On 2024-03-17 14:36, J. A. Harris wrote: > > > On 3/17/24 15:54, Michael or Penny Novack wrote: > > > > > Your lack of accounting and understanding of the history of double > > > entry is confusing you. ... > > > .. > > > Thus for an event were EXPECTED to make a profit for the organization, > > > I'd make them all of type "income". Understand? > > > > Yes, I do understand.? The purpose of the INC+EXP would not be to put > > entries in.? It would be a placeholder account, under which there would > > be Revenue and Expense accounts.? I can think of many situations where > > that would be desirable.? Here is one. HOAs frequently use "fund" > > accounting where there is an "Operating Fund" and a "Reserve Fund".? > > Each of those funds have Income and Expenses (along with other things).? > > So you might see a structure like this. > > > > ?? Top > > ?? ??? Operating > > ?? ??? ??? Assets ? > > ?? ??? ??? Equity ? > > ?? ??? ??? Income > > ?? ??? ??? ??? Expenses > > ?? ??? ??? ??? Revenue > > ?? ??? ??? Liabilities ? > > ?? ??? Reserve > > ??? ??? ??? Assets ? > > ??? ??? ??? Equity ? > > ??? ??? ??? Income > > ??? ??? ??? ??? Expenses > > ??? ??? ??? ??? Revenue > > ??? ??? ??? Liabilities ? > > > > In that type of situation, a General account type is useful for the > > Operating and Reserve placeholder account and an Inc&Exp type is useful > > for the accounts called Income. (Even if you do not want want both > > Expenses and Revenues under the placeholder account named Income, you > > still cannot put them under Reserve.) > > > > Are you saying you have never found an occasion where it would be useful > > to have an upper-level account above a group of accounts, some of which > > were Income and some were Expense? > > > > On 3/17/24 15:54, Michael or Penny Novack wrote: > > > > > Those are "commodities" > > > > I am aware of that.? Currencies, Funds, and NYSEs are all particular > > types of Commodities. There is no current support in gnucash for > > defining Commodities other than those three types. Since for things like > > airline points, it seemed to me their operational characteristics as > > they are used in gnucash are the same as Currencies, I thought it would > > be easiest to implement them by adding support for them under the > > existing Currency category.? If you prefer, the name could be changed to > > Currencies & Other Things.? Or a fourth category could created, although > > that would probably increase code complexity? But all that is detail, > > which I did not feel needed to be addressed at this point. > > > > -- > > ---- > > Dr. J. A. Harris > > _______________________________________________ > > gnucash-user mailing list > > [email protected] > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > ----- > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > > > ------------------------------ > > Message: 7 > Date: Sun, 17 Mar 2024 18:45:41 -0400 > From: NoobAlice [email protected] > > To: [email protected] > Subject: Re: [GNC] Separating tax years for payments in next year > Message-ID: [email protected] > > Content-Type: text/plain; charset=UTF-8; format=flowed > > I just start my description "2023 Q1 fed estimate" or similar in my tax > payable account. If you do that, you can use a filter for reports. > > Also, since I use a liability account, I can reconcile it after filing. > Then you can filter the account itself for unreconciled transactions, > which will then just show 2024 estimates. > > On 2024-03-08 04:54 PM, David G. Pickett via gnucash-user wrote: > > > I recently created ExpenseAccounts/Taxes/FederalEven and > > ExpenseAccounts/Taxes/FederalOdd to allow me to get a meaningful report on > > estimated tax and various tax withholding.? The payments in Jan 2024 for > > 2023 estimated and later for 2-23 tax due do not clutter the reports on > > 2024 tax year, and the 2022 items do not get into the 2023 report.? Is > > there a better way to deal with this? > > > > > ------------------------------ > > Message: 8 > Date: Sun, 17 Mar 2024 22:47:15 +0000 > From: Anon20x [email protected] > > To: [email protected] > Subject: Re: [GNC] gnucash-user Digest, Vol 252, Issue 33 > Message-ID: > tDX5hVcsu9_MtBeSDTNiX0671podLTSTsLDq5ZdJCCoNv24gXxH_uXA5c0U1QeTs6r-uL6RCJnZRe_5qVi8UD1PkrQmYuLJdxPuAonF9N5I=@proton.me > > > Content-Type: text/plain; charset=utf-8 > > Hi, > > Will you please unsub me from the mailing list, thankyou! > > > > > On Monday, March 18th, 2024 at 2:00 AM, [email protected] > [email protected] wrote: > > > Send gnucash-user mailing list submissions to > > [email protected] > > > > To subscribe or unsubscribe via the World Wide Web, visit > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > or, via email, send a message with subject or body 'help' to > > [email protected] > > > > You can reach the person managing the list at > > [email protected] > > > > When replying, please edit your Subject line so it is more specific > > than "Re: Contents of gnucash-user digest..." > > > > Today's Topics: > > > > 1. Re: How to import MT940 and/or online banking missing in 5.5 > > (Frank H. Ellenberger) > > 2. UNSUBCRIBE and Lemmy.World > > ([email protected]) > > 3. Re: UNSUBCRIBE and Lemmy.World (Ken Farley) > > 4. Re: UNSUBCRIBE and Lemmy.World (Michael or Penny Novack) > > 5. Re: 5.5-1 crashing on macOS 14.3 (Mike Alexander) > > 6. Re: UNSUBCRIBE and Lemmy.World (Ken Farley) > > > > ---------------------------------------------------------------------- > > > > Message: 1 > > Date: Sat, 16 Mar 2024 17:00:11 +0100 > > From: "Frank H. Ellenberger" [email protected] > > > > To: john [email protected], An Ku [email protected] > > > > Cc: [email protected] > > Subject: Re: [GNC] How to import MT940 and/or online banking missing > > in 5.5 > > Message-ID: [email protected] > > > > Content-Type: text/plain; charset=UTF-8; format=flowed > > > > I suspect, Andr? is aWindows user and needs to upgrade to 5.5-1: > > https://sourceforge.net/projects/gnucash/files/gnucash > > (stable)/5.5/gnucash-5.5-1.setup.exe > > > > Regards > > Frank > > > > Am 16.03.24 um 08:07 schrieb john: > > > > > MT940 and CAMT.053 imports are done with File>Import>Import Using > > > AQBanking. Note that CAMT.053 is under XML, not CAMT in the import > > > selector. > > > > > > Regards, > > > John Ralls > > > > > > > On Mar 14, 2024, at 13:44, An Ku [email protected] wrote: > > > > > > > > Dear all > > > > > > > > Unfortunately, my bank's CSV export is useless as it does not state > > > > recipients or any useful information of transactions apart from the > > > > amount > > > > and date/time of execution. They do however provide the option to > > > > download > > > > MT940 as well as camt.053 (apart form PDFs). I understand there used to > > > > be > > > > an option to import MT940 transactions through an online banking module, > > > > but I cannot find it anywhere in the UI (I'm using windows and am on > > > > v5.5). > > > > I found references to an external online banking package but no how to > > > > make > > > > it run on a windows machine. > > > > > > > > I'd appreciate any help on: > > > > > > > > - Importing an MT940 file directly > > > > - Importing an camt.053 file directly > > > > - Converting either MT940 or camt.053 files to CSV > > > > > > > > Thank you and kind regards, > > > > Andr? > > > > _______________________________________________ > > > > gnucash-user mailing list > > > > [email protected] > > > > To update your subscription preferences or to unsubscribe: > > > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > > > ----- > > > > Please remember to CC this list on all your replies. > > > > You can do this by using Reply-To-List or Reply-All. > > > > > > _______________________________________________ > > > gnucash-user mailing list > > > [email protected] > > > To update your subscription preferences or to unsubscribe: > > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > > ----- > > > Please remember to CC this list on all your replies. > > > You can do this by using Reply-To-List or Reply-All. > > > > ------------------------------ > > > > Message: 2 > > Date: Sat, 16 Mar 2024 19:35:37 +0000 > > From: [email protected] > > To: [email protected] > > Subject: [GNC] UNSUBCRIBE and Lemmy.World > > Message-ID: > > [email protected] > > > > Content-Type: text/plain; charset=utf-8 > > > > Will you please unsub me from the emails, it's too much! Also I've tried > > multiple times using the unsub button in the email and it apparently > > doesn't work. > > > > I thoroughly appreciate your time and commitment to GNU Cash and the > > community and I recommend a lemmy.world community (an independent kind of > > reddit) too much gets lost for those who can't simply search the post > > history. > > > > On Sunday, March 17th, 2024 at 2:00 AM, [email protected] > > [email protected] wrote: > > > > > Send gnucash-user mailing list submissions to > > > [email protected] > > > > > > To subscribe or unsubscribe via the World Wide Web, visit > > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > > or, via email, send a message with subject or body 'help' to > > > [email protected] > > > > > > You can reach the person managing the list at > > > [email protected] > > > > > > When replying, please edit your Subject line so it is more specific > > > than "Re: Contents of gnucash-user digest..." > > > > > > Today's Topics: > > > > > > 1. How to import MT940 and/or online banking missing in 5.5 (An Ku) > > > 2. Re: Bill total does not match real total (Alan Johnson) > > > 3. Re: How to import MT940 and/or online banking missing in 5.5 > > > (john) > > > 4. Re: How to import MT940 and/or online banking missing in 5.5 > > > (Gyle McCollam) > > > > > > ---------------------------------------------------------------------- > > > > > > Message: 1 > > > Date: Thu, 14 Mar 2024 13:44:04 +0100 > > > From: An Ku [email protected] > > > > > > To: [email protected] > > > Subject: [GNC] How to import MT940 and/or online banking missing in > > > 5.5 > > > Message-ID: > > > CAFHnGB9XGxZv-6mN5Toak9keiNwUHY=gofocrlk8ioy3v-d...@mail.gmail.com > > > > > > Content-Type: text/plain; charset="UTF-8" > > > > > > Dear all > > > > > > Unfortunately, my bank's CSV export is useless as it does not state > > > recipients or any useful information of transactions apart from the amount > > > and date/time of execution. They do however provide the option to download > > > MT940 as well as camt.053 (apart form PDFs). I understand there used to be > > > an option to import MT940 transactions through an online banking module, > > > but I cannot find it anywhere in the UI (I'm using windows and am on > > > v5.5). > > > I found references to an external online banking package but no how to > > > make > > > it run on a windows machine. > > > > > > I'd appreciate any help on: > > > > > > - Importing an MT940 file directly > > > - Importing an camt.053 file directly > > > - Converting either MT940 or camt.053 files to CSV > > > > > > Thank you and kind regards, > > > Andr? > > > > > > ------------------------------ > > > > > > Message: 2 > > > Date: Fri, 15 Mar 2024 22:33:29 -0400 > > > From: Alan Johnson [email protected] > > > > > > To: [email protected], [email protected] > > > Subject: Re: [GNC] Bill total does not match real total > > > Message-ID: > > > [email protected] > > > > > > Content-Type: text/plain; charset="utf-8" > > > > > > I looked at the trial. The core they offer has a number of modules you > > > can use for free/self hosted/open source. ?The accounting packages > > > require a subscription/paid service. ? > > > > > > On Mon, 2024-03-11 at 11:56 -0500, Adrien Monteleone wrote: > > > > > > > I'm not sure if it is still entirely open source, but it started that > > > > way. I think they've added on features that are closed. (some may > > > > simply > > > > be built with Odoo itself) The base package is still available as far > > > > as > > > > I'm aware, and it is pretty powerful, but likely overkill for most > > > > small > > > > businesses. They also don't make it easy to build it and get up and > > > > running, preferring to 'guide' you to their paid support offerings. > > > > > > > > Odoo is more of a tool to build an app, rather than a business app > > > > itself. > > > > > > > > Regards, > > > > Adrien > > > > > > > > On 3/11/24 10:33 AM, Michael or Penny Novack wrote: > > > > > > > > > Well ... if it is really "open software" they would have to make > > > > > the > > > > > source code available for free (technically can charge reasonable > > > > > cost > > > > > for a copy on medium -- the 'rule" was made before we got things by > > > > > download). The "open software" rules do NOT forbid charging for > > > > > providing executables, support, etc. The originally concept was > > > > > that > > > > > nobody could charge excessively for that or somebody else would > > > > > step in > > > > > and provide at a more reasonable price. Yes, I am old enough to > > > > > have > > > > > followed the original "open software" discussions real time. > > > > > > > > _______________________________________________ > > > > gnucash-user mailing list > > > > [email protected] > > > > To update your subscription preferences or to unsubscribe: > > > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > > > ----- > > > > Please remember to CC this list on all your replies. > > > > You can do this by using Reply-To-List or Reply-All. > > > > > > -------------- next part -------------- > > > A non-text attachment was scrubbed... > > > Name: smime.p7s > > > Type: application/pkcs7-signature > > > Size: 5197 bytes > > > Desc: not available > > > URL: > > > http://lists.gnucash.org/pipermail/gnucash-user/attachments/20240315/270097c8/attachment-0001.p7s > > > > > > ------------------------------ > > > > > > Message: 3 > > > Date: Sat, 16 Mar 2024 08:07:00 +0100 > > > From: john [email protected] > > > > > > To: An Ku [email protected] > > > > > > Cc: [email protected] > > > Subject: Re: [GNC] How to import MT940 and/or online banking missing > > > in 5.5 > > > Message-ID: [email protected] > > > > > > Content-Type: text/plain; charset=utf-8 > > > > > > MT940 and CAMT.053 imports are done with File>Import>Import Using > > > AQBanking. Note that CAMT.053 is under XML, not CAMT in the import > > > selector. > > > > > > Regards, > > > John Ralls > > > > > > > On Mar 14, 2024, at 13:44, An Ku [email protected] wrote: > > > > > > > > Dear all > > > > > > > > Unfortunately, my bank's CSV export is useless as it does not state > > > > recipients or any useful information of transactions apart from the > > > > amount > > > > and date/time of execution. They do however provide the option to > > > > download > > > > MT940 as well as camt.053 (apart form PDFs). I understand there used to > > > > be > > > > an option to import MT940 transactions through an online banking module, > > > > but I cannot find it anywhere in the UI (I'm using windows and am on > > > > v5.5). > > > > I found references to an external online banking package but no how to > > > > make > > > > it run on a windows machine. > > > > > > > > I'd appreciate any help on: > > > > > > > > - Importing an MT940 file directly > > > > - Importing an camt.053 file directly > > > > - Converting either MT940 or camt.053 files to CSV > > > > > > > > Thank you and kind regards, > > > > Andr? > > > > _______________________________________________ > > > > gnucash-user mailing list > > > > [email protected] > > > > To update your subscription preferences or to unsubscribe: > > > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > > > ----- > > > > Please remember to CC this list on all your replies. > > > > You can do this by using Reply-To-List or Reply-All. > > > > > > ------------------------------ > > > > > > Message: 4 > > > Date: Sat, 16 Mar 2024 13:26:05 +0000 > > > From: Gyle McCollam [email protected] > > > > > > To: john [email protected], An Ku [email protected] > > > > > > Cc: "[email protected]" [email protected] > > > > > > Subject: Re: [GNC] How to import MT940 and/or online banking missing > > > in 5.5 > > > Message-ID: > > > cy4pr1001mb21998b83f9848ac2fedbab74ca...@cy4pr1001mb2199.namprd10.prod.outlook.com > > > > > > Content-Type: text/plain; charset="iso-8859-1" > > > > > > Just a reminder that "File>Import>Import Using AQBanking" is not an > > > option on the menu for Windows Build ID: 5.5+(2023-12-16) > > > > > > Thank You, > > > > > > Gyle McCollam > > > > > > Gyle McCollam > > > > > > [email protected]mailto:[email protected] email > > > > > > ________________________________ > > > From: gnucash-user [email protected] on > > > behalf of john [email protected] > > > > > > Sent: Saturday, March 16, 2024 3:07 AM > > > To: An Ku [email protected] > > > > > > Cc: [email protected] [email protected] > > > > > > Subject: Re: [GNC] How to import MT940 and/or online banking missing in > > > 5.5 > > > > > > MT940 and CAMT.053 imports are done with File>Import>Import Using > > > AQBanking. Note that CAMT.053 is under XML, not CAMT in the import > > > selector. > > > > > > Regards, > > > John Ralls > > > > > > > On Mar 14, 2024, at 13:44, An Ku [email protected] wrote: > > > > > > > > Dear all > > > > > > > > Unfortunately, my bank's CSV export is useless as it does not state > > > > recipients or any useful information of transactions apart from the > > > > amount > > > > and date/time of execution. They do however provide the option to > > > > download > > > > MT940 as well as camt.053 (apart form PDFs). I understand there used to > > > > be > > > > an option to import MT940 transactions through an online banking module, > > > > but I cannot find it anywhere in the UI (I'm using windows and am on > > > > v5.5). > > > > I found references to an external online banking package but no how to > > > > make > > > > it run on a windows machine. > > > > > > > > I'd appreciate any help on: > > > > > > > > - Importing an MT940 file directly > > > > - Importing an camt.053 file directly > > > > - Converting either MT940 or camt.053 files to CSV > > > > > > > > Thank you and kind regards, > > > > Andr? > > > > _______________________________________________ > > > > gnucash-user mailing list > > > > [email protected] > > > > To update your subscription preferences or to unsubscribe: > > > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > > > ----- > > > > Please remember to CC this list on all your replies. > > > > You can do this by using Reply-To-List or Reply-All. > > > > > > _______________________________________________ > > > gnucash-user mailing list > > > [email protected] > > > To update your subscription preferences or to unsubscribe: > > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > > ----- > > > Please remember to CC this list on all your replies. > > > You can do this by using Reply-To-List or Reply-All. > > > > > > ------------------------------ > > > > > > Subject: Digest Footer > > > > > > _______________________________________________ > > > > > > gnucash-user mailing list > > > [email protected] > > > To update your subscription preferences or to unsubscribe: > > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > > ----- > > > Please remember to CC this list on all your replies. > > > You can do this by using Reply-To-List or Reply-All. > > > > > > ------------------------------ > > > > > > End of gnucash-user Digest, Vol 252, Issue 32 > > > ********************************************* > > > > ------------------------------ > > > > Message: 3 > > Date: Sat, 16 Mar 2024 17:40:04 -0400 > > From: Ken Farley [email protected] > > > > To: [email protected] > > Subject: Re: [GNC] UNSUBCRIBE and Lemmy.World > > Message-ID: [email protected] > > > > Content-Type: text/plain; charset=UTF-8; format=flowed > > > > Unsubscribing isn't done by the list, it's just posts of questions like > > yours. > > > > To unsubscribe, you need to go to: > > > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > > > To be honest, I don't allow the deluge of emails to come to me, either. > > Too many to have to sift through every day. > > > > ------------------------------ > > > > Message: 4 > > Date: Sat, 16 Mar 2024 19:40:50 -0400 > > From: Michael or Penny Novack [email protected] > > > > To: [email protected] > > Subject: Re: [GNC] UNSUBCRIBE and Lemmy.World > > Message-ID: [email protected] > > > > Content-Type: text/plain; charset=UTF-8; format=flowed > > > > On 3/16/2024 5:40 PM, Ken Farley wrote: > > > > > Unsubscribing isn't done by the list, it's just posts of questions > > > like yours. > > > > > > To unsubscribe, you need to go to: > > > > > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > > > > > To be honest, I don't allow the deluge of emails to come to me, > > > either. Too many to have to sift through every day. > > > > << not about gnucash -- but about this specific issue >> > > > > If you are an EMAIL user (not WEBMAIL) then your email client (Outlook, > > Thunderbird, etc.) almost certainly provides a facility for you to > > create "message filter rules". You can then add a rule so that emails > > coming from a particular source (say this email list) get moved to a > > dedicated folder instead of appearing in your inbox). The only emails > > that show up in the inbox here are ones for which I haven't written a rule. > > > > Then you either sift through them in this other folder or not depending > > on whether you have time. Nor do they have to take up space in that > > folder forever as you can specify retention policy for that folder. > > > > Webmail users --- I have no idea if whatever provider you are using > > offers similar facilities. > > > > Michael D Novack > > > > ------------------------------ > > > > Message: 5 > > Date: Sat, 16 Mar 2024 20:17:57 -0400 > > From: Mike Alexander [email protected] > > > > To: [email protected] > > Subject: Re: [GNC] 5.5-1 crashing on macOS 14.3 > > Message-ID: [email protected] > > > > Content-Type: text/plain; charset=UTF-8; format=flowed; > > markup=markdown > > > > Sorry for the late reply, I didn't see this because of the subject > > change. > > > > The bug in F9nance::Quote has been fixed. I don't know if the fix is in > > a version that has been released, but if not it will be in the next one. > > > > Mike > > > > On 9 Mar 2024, at 10:06, john wrote: > > > > > Good that you've gotten it working. Maybe open an issue at > > > https://github.com/finance-quote/finance-quote/issues about > > > YahooWeb.pm not setting the right error code when it fails to get a > > > quote. > > > > > > And please, in the future, start a new thread or at least change the > > > subject when you digress like that. This one was supposed to be about > > > a hard crash of GnuCash itself. > > > > > > Regards, > > > John Ralls > > > > > > > On Mar 8, 2024, at 23:30, Tom Teixeira [email protected] > > > > wrote: > > > > > > > > I did end up making time to investigate today, and the problem ended > > > > up being just one fund that no longer works with YahooWeb. This > > > > particular fund is a "stable value" fund so checking the value is > > > > somewhat superfluous. As it turns out, it does with with > > > > AlphaVantage. > > > > > > > > Again, thanks to David Reiser for the information to explicitly > > > > specify x86_64 architecture when running on Apple silicon. > > > > > > > > On 3/8/24 3:25 PM, Tom Teixeira wrote: > > > > > > > > > Thanks for the suggestion. I won't have time today to investigate, > > > > > but will do some targeted debugging, either by removing stocks from > > > > > my list to update, or by creating a new Gnucash file with only one > > > > > stock. > > > > > > > > > > On 3/8/24 2:51 PM, David Reiser wrote: > > > > > > > > > > > We are now into my mental weeds as far as real knowledge goes, but > > > > > > I have had some success at thrashing around to fix self-induced > > > > > > perl challenges. > > > > > > > > > > > > Since the error happens on both architectures, that suggests > > > > > > something is missing. I think YahooWeb is relatively recent in the > > > > > > F::Q realm. And F::Q hasn?t managed dependency declarations as > > > > > > well as I?d like. > > > > > > > > > > > > The error complains about a ?row method?. YahooWeb uses > > > > > > HTML::TableExtract which might be the source of the row > > > > > > information. Try installing the appropriate arch version of > > > > > > HTML::TableExtract on each machine and see if that works. > > > > > > -- > > > > > > Dave Reiser > > > > > > [email protected] > > > > > > > > > > > > > On Mar 8, 2024, at 1:03?PM, Tom Teixeira > > > > > > > [email protected] wrote: > > > > > > > > > > > > > > I spoke too soon: while getting an individual quote with > > > > > > > gnucash-cli works: > > > > > > > > > > > > > > /Applications/Gnucash-5.5.app/Contents/MacOS/gnucash-cli --quotes > > > > > > > dump yahooweb MSFT > > > > > > > > > > > > > > Application Path > > > > > > > /Applications/Gnucash-5.5.app/Contents/MacOS/gnucash-cli > > > > > > > Finance::Quote fields GnuCash uses: > > > > > > > symbol: MSFT <=== required > > > > > > > date: 03/08/2024 <=== recommended > > > > > > > currency: USD <=== required > > > > > > > last: 407.16 <=\ > > > > > > > nav: <=== one of these > > > > > > > price: <=/ > > > > > > > > > > > > > > trying to "Get Quotes" in my "Price Database" does not. I get a > > > > > > > dialog box with > > > > > > > > > > > > > > Price retrieval failed: Unrecognized Finance::Quote Error: Can't > > > > > > > call method "rows" on an undefined value at > > > > > > > /Library/Perl/5.34/Finance/Quote/YahooWeb.pm line 101. > > > > > > > > > > > > > > I have another, Intel-based Mac. After upgrading this to Sonoma > > > > > > > 14.4 release version, and re-installing Finance::Quote, it gets > > > > > > > the same error. > > > > > > > > > > _______________________________________________ > > > > > gnucash-user mailing list > > > > > [email protected] > > > > > To update your subscription preferences or to unsubscribe: > > > > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > > > > ----- > > > > > Please remember to CC this list on all your replies. > > > > > You can do this by using Reply-To-List or Reply-All. > > > > > > > > _______________________________________________ > > > > gnucash-user mailing list > > > > [email protected] > > > > To update your subscription preferences or to unsubscribe: > > > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > > > ----- > > > > Please remember to CC this list on all your replies. > > > > You can do this by using Reply-To-List or Reply-All. > > > > > > _______________________________________________ > > > gnucash-user mailing list > > > [email protected] > > > To update your subscription preferences or to unsubscribe: > > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > > ----- > > > Please remember to CC this list on all your replies. > > > You can do this by using Reply-To-List or Reply-All. > > > > ------------------------------ > > > > Message: 6 > > Date: Sat, 16 Mar 2024 22:48:27 -0400 > > From: Ken Farley [email protected] > > > > To: [email protected] > > Subject: Re: [GNC] UNSUBCRIBE and Lemmy.World > > Message-ID: [email protected] > > > > Content-Type: text/plain; charset=UTF-8; format=flowed > > > > Nah. Filters that store all that stuff are for things I need to look at. > > I find it much more efficient to go to: > > > > https://lists.gnucash.org/pipermail/gnucash-user > > > > and browse through the messages to see the very small percentage of them > > I'm interested in. That way I don't have to delete a pile of unwanted > > stuff, on my computer and also on my e-mail provider's site. > > > > ------------------------------ > > > > Subject: Digest Footer > > > > _______________________________________________ > > > > gnucash-user mailing list > > [email protected] > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > ----- > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > > > ------------------------------ > > > > End of gnucash-user Digest, Vol 252, Issue 33 > > ********************************************* > > > > ------------------------------ > > Subject: Digest Footer > > _______________________________________________ > > gnucash-user mailing list > [email protected] > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > ----- > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > > > ------------------------------ > > End of gnucash-user Digest, Vol 252, Issue 34 > ********************************************* _______________________________________________ gnucash-user mailing list [email protected] To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
