[GNC] Help

[Anon20x]

Please unsub me from the list, thankyou.




On Monday, March 18th, 2024 at 8:47 AM, gnucash-user-request at gnucash.org <gnucash-user-request at gnucash.org> wrote:

> 
> 
> Send gnucash-user mailing list submissions to
> gnucash-user at gnucash.org
> 
> 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
> gnucash-user-request at gnucash.org
> 
> You can reach the person managing the list at
> gnucash-user-owner at gnucash.org
> 
> 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" product at harrisja.us
> 
> To: gnucash-user at gnucash.org
> Subject: [GNC] gnucash suggestions
> Message-ID: a1a89c31-e2f6-4c09-8433-55658ab15fb6 at harrisja.us
> 
> 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" kalpesh.patel at usa.net
> 
> To: gnucash-user at gnucash.org
> 
> Subject: Re: [GNC] UNSUBCRIBE and Lemmy.World
> Message-ID: 000e01da7889$b0f5c380$12e14a80$@usa.net
> 
> 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 stepbystepfarm at comcast.net
> 
> Sent: Saturday, March 16, 2024 7:41 PM
> To: gnucash-user at gnucash.org
> 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 stepbystepfarm at comcast.net
> 
> To: gnucash-user at gnucash.org
> Subject: Re: [GNC] gnucash suggestions
> Message-ID: 5b5e6ef9-aeac-4b3e-a4a4-97fb8beac0fd at comcast.net
> 
> 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 stepbystepfarm at comcast.net
> 
> To: gnucash-user at gnucash.org
> Subject: Re: [GNC] UNSUBCRIBE and Lemmy.World
> Message-ID: cd100369-17fd-49b0-a1c4-8d15bcb81694 at comcast.net
> 
> 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" product at harrisja.us
> 
> To: gnucash-user at gnucash.org
> Subject: Re: [GNC] gnucash suggestions
> Message-ID: 2707c5d4-8335-441d-9147-18e3dc38ef9b at harrisja.us
> 
> 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)" stan+gc at fastmail.fm
> 
> To: gnucash-user at gnucash.org
> Subject: Re: [GNC] gnucash suggestions
> Message-ID: dbc45c7b-abea-42c0-a314-8ce3d9ac701c at fastmail.fm
> 
> 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
> > gnucash-user at gnucash.org
> > 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 NoobAlice at airmail.cc
> 
> To: gnucash-user at gnucash.org
> Subject: Re: [GNC] Separating tax years for payments in next year
> Message-ID: bf10abaf-327a-41c8-8ca2-d5eb643f08c0 at airmail.cc
> 
> 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 Anon20x at proton.me
> 
> To: gnucash-user at gnucash.org
> 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, gnucash-user-request at gnucash.org gnucash-user-request at gnucash.org wrote:
> 
> > Send gnucash-user mailing list submissions to
> > gnucash-user at gnucash.org
> > 
> > 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
> > gnucash-user-request at gnucash.org
> > 
> > You can reach the person managing the list at
> > gnucash-user-owner at gnucash.org
> > 
> > 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
> > (lists.gnucash.org.quantum270 at passmail.net)
> > 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" frank.h.ellenberger at gmail.com
> > 
> > To: john jralls at ceridwen.us, An Ku prooffes at gmail.com
> > 
> > Cc: gnucash-user at gnucash.org
> > Subject: Re: [GNC] How to import MT940 and/or online banking missing
> > in 5.5
> > Message-ID: 2453b79d-5d8f-44f2-b66b-7491ac58ad50 at gmail.com
> > 
> > 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 prooffes at gmail.com 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
> > > > gnucash-user at gnucash.org
> > > > 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
> > > gnucash-user at gnucash.org
> > > 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: lists.gnucash.org.quantum270 at passmail.net
> > To: gnucash-user at gnucash.org
> > Subject: [GNC] UNSUBCRIBE and Lemmy.World
> > Message-ID:
> > 171061775343.8.2420981101855662130.287866314 at passmail.net
> > 
> > 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, gnucash-user-request at gnucash.org gnucash-user-request at gnucash.org wrote:
> > 
> > > Send gnucash-user mailing list submissions to
> > > gnucash-user at gnucash.org
> > > 
> > > 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
> > > gnucash-user-request at gnucash.org
> > > 
> > > You can reach the person managing the list at
> > > gnucash-user-owner at gnucash.org
> > > 
> > > 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 prooffes at gmail.com
> > > 
> > > To: gnucash-user at gnucash.org
> > > Subject: [GNC] How to import MT940 and/or online banking missing in
> > > 5.5
> > > Message-ID:
> > > CAFHnGB9XGxZv-6mN5Toak9keiNwUHY=GofocrLk8ioY3V-dhWA at 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 alan at argentwolf.org
> > > 
> > > To: adrien.monteleone at lusfiber.net, gnucash-user at lists.gnucash.org
> > > Subject: Re: [GNC] Bill total does not match real total
> > > Message-ID:
> > > 51bd6de630d64f56859e78705a1de99191b9c3a5.camel at argentwolf.org
> > > 
> > > 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
> > > > gnucash-user at gnucash.org
> > > > 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 jralls at ceridwen.us
> > > 
> > > To: An Ku prooffes at gmail.com
> > > 
> > > Cc: gnucash-user at gnucash.org
> > > Subject: Re: [GNC] How to import MT940 and/or online banking missing
> > > in 5.5
> > > Message-ID: 2459A8EE-391E-4B09-998A-47BD9213F411 at ceridwen.us
> > > 
> > > 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 prooffes at gmail.com 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
> > > > gnucash-user at gnucash.org
> > > > 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 gmccollam at live.com
> > > 
> > > To: john jralls at ceridwen.us, An Ku prooffes at gmail.com
> > > 
> > > Cc: "gnucash-user at gnucash.org" gnucash-user at gnucash.org
> > > 
> > > Subject: Re: [GNC] How to import MT940 and/or online banking missing
> > > in 5.5
> > > Message-ID:
> > > CY4PR1001MB21998B83F9848AC2FEDBAB74CA2F2 at 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
> > > 
> > > gmccollam at live.commailto:gmccollam at gyleshomes.com email
> > > 
> > > ________________________________
> > > From: gnucash-user gnucash-user-bounces+gylemc=gmail.com at gnucash.org on behalf of john jralls at ceridwen.us
> > > 
> > > Sent: Saturday, March 16, 2024 3:07 AM
> > > To: An Ku prooffes at gmail.com
> > > 
> > > Cc: gnucash-user at gnucash.org gnucash-user at gnucash.org
> > > 
> > > 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 prooffes at gmail.com 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
> > > > gnucash-user at gnucash.org
> > > > 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
> > > gnucash-user at gnucash.org
> > > 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
> > > gnucash-user at gnucash.org
> > > 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 farleykj at gmail.com
> > 
> > To: gnucash-user at gnucash.org
> > Subject: Re: [GNC] UNSUBCRIBE and Lemmy.World
> > Message-ID: 8347e821-c582-42a8-9f43-c23a588569a9 at gmail.com
> > 
> > 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 stepbystepfarm at comcast.net
> > 
> > To: gnucash-user at gnucash.org
> > Subject: Re: [GNC] UNSUBCRIBE and Lemmy.World
> > Message-ID: dd3c457d-11b0-4014-bed2-b1c71cd68c83 at comcast.net
> > 
> > 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 mta at umich.edu
> > 
> > To: gnucash-user at gnucash.org
> > Subject: Re: [GNC] 5.5-1 crashing on macOS 14.3
> > Message-ID: CCD31BED-BA4A-4BA8-9C58-0C6F8899052C at umich.edu
> > 
> > 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 tjteixeira at earthlink.net
> > > > 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
> > > > > > dbreiser at icloud.com
> > > > > > 
> > > > > > > On Mar 8, 2024, at 1:03?PM, Tom Teixeira
> > > > > > > tjteixeira at earthlink.net 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
> > > > > gnucash-user at gnucash.org
> > > > > 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
> > > > gnucash-user at gnucash.org
> > > > 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
> > > gnucash-user at gnucash.org
> > > 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 farleykj at gmail.com
> > 
> > To: gnucash-user at gnucash.org
> > Subject: Re: [GNC] UNSUBCRIBE and Lemmy.World
> > Message-ID: f5a56aba-ebca-458b-b357-d2a89b69d2bf at gmail.com
> > 
> > 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
> > gnucash-user at gnucash.org
> > 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
> gnucash-user at gnucash.org
> 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
> *********************************************