Re: [GNC] CSV Importer - Debit vs Credit

2024-07-05 Thread Paul Kroitor
LOL -- Sorry for maligning TD! It turns out the bank that's causing the issue is ScotiaBank, not TD. Don't know why I kept saying TD, who are blameless in this. Yet another sign of approaching dementia. -Original Message- From: gnucash-user On Behalf Of Paul Kroitor Sent

Re: [GNC] CSV Importer - Debit vs Credit

2024-07-04 Thread Paul Kroitor
nded. NB: since " is used in the actual data, I'm using ' above as a delimiter and " as a character in the string. -Original Message- From: Kalpesh Patel Sent: Thursday, July 4, 2024 1:20 PM To: 'Paul Kroitor' ; gnucash-user@gnucash.org Subject: RE: [GNC] CSV Importe

Re: [GNC] CSV Importer - Debit vs Credit

2024-07-04 Thread Paul Kroitor
ch page I view. Is the Quicken option also gone? > >> On 2024-07-04 01:13 p.m., Paul Kroitor wrote: >> I'm afraid "Microsoft Money" format -- which I've been a satisfied user of >> for over a decade -- isn't an option anymore in their new website d

Re: [GNC] CSV Importer - Debit vs Credit

2024-07-04 Thread Paul Kroitor
I can easily write a little Python thingie and put it in my right-click menu, but it's just an added annoyance in this increasingly annoying world. -Original Message- From: Kalpesh Patel Sent: Thursday, July 4, 2024 12:59 PM To: 'Paul Kroitor' ; gnucash-user@gnucash.

Re: [GNC] CSV Importer - Debit vs Credit

2024-07-04 Thread Paul Kroitor
choose "Intuit Quicken", because that results in a QFX download, which GnuCash can import. On 2024-07-04 12:00 p.m., gnucash-user-requ...@gnucash.org wrote: > Date: Thu, 4 Jul 2024 11:30:29 -0400 > From: "Paul Kroitor" > To: > Subject: [GNC] CSV Importer - Debit vs Credi

Re: [GNC] CSV Importer - Debit vs Credit

2024-07-04 Thread Paul Kroitor
You can also preprocess the csv file to separate the debits and credits into 2 separate columns, wherein both amounts can remain positive. This is just from memory. I’m sure folks who use the importer will provide better responses. Cheers. -- From: "Pa

[GNC] CSV Importer - Debit vs Credit

2024-07-04 Thread Paul Kroitor
I'm sure this has been asked in a dozen different variations over the years but I'm now faced with the issue myself since I now need to use CSV for downloading (I hate TD Bank, who have removed the OFX download option). I can't immediately find any old messages describing this particular issue, so

Re: [GNC] Imbalance Records with zero amounts

2024-06-27 Thread Paul Kroitor
Thanks for that clarification, that matches with what I’m experiencing here. It also seems to fully explain what the OP was on about originally. Paul From: sunfis...@yahoo.com Sent: Thursday, June 27, 2024 8:12 AM To: Paul Kroitor Cc: David Carlson ; bbc104 via gnucash-user

Re: [GNC] Imbalance Records with zero amounts

2024-06-26 Thread Paul Kroitor
at in this second case, there is an imbalance amount line created but it created in bottom line of the group *without* "Imbalance" in the account field. Paul -Original Message- From: gnucash-user On Behalf Of Paul Kroitor Sent: Wednesday, June 26, 2024 11:08 PM To: 'David C

Re: [GNC] Imbalance Records with zero amounts

2024-06-26 Thread Paul Kroitor
was saved. I think it is a bug if they are now being saved. They are disappearing in my copy of release 5.6 in windows. On Wed, Jun 26, 2024, 9:14 PM Paul Kroitor mailto:p...@kroitor.ca> > wrote: I get one of these empty (zero amount) splits every time I have to change both sides

Re: [GNC] Imbalance Records with zero amounts

2024-06-26 Thread Paul Kroitor
I get one of these empty (zero amount) splits every time I have to change both sides of an already entered transaction in a register set to auto-split. Oddly, if the transaction shows the credit first, the imbalance gets created (temporarily non-zero) as the last split and, once the imbalance li

Re: [GNC] Moving from GnuCash 4.8 to GnuCash 5.5 - any issues likely to bite me?

2024-05-12 Thread Paul Kroitor
You're on a Linux platform so it won't directly matter, but be aware that the Windows 5.5 version has a major bug (many reports don't work). It's fixed in 5.5.1 and 5.6, so if you ever share your data files into the Windows universe, it's unlikely it would be to 5.5. That said, I'm not aware any d

Re: [GNC] Transaction Report Shortcomings

2024-05-04 Thread Paul Kroitor
nightly builds, right? Is that right? Sorry for double-checking, I just want to be sure I understand, Paul From: Christopher Lam Sent: Thursday, May 2, 2024 1:09 AM To: Paul Kroitor Cc: Gnucash Users Subject: Re: [GNC] Transaction Report Shortcomings Hi, See Sorting/Show Account

Re: [GNC] Transaction Report Shortcomings

2024-05-01 Thread Paul Kroitor
tly the perfect descriptions -- I just can't see a way to show them! Paul -Original Message- From: gnucash-user On Behalf Of Paul Kroitor Sent: Wednesday, May 1, 2024 10:07 AM To: 'Gnucash Users' Subject: [GNC] Transaction Report Shortcomings Is there a way to get the Tran

[GNC] Transaction Report Shortcomings

2024-05-01 Thread Paul Kroitor
Is there a way to get the Transaction Report to show Account Description rather than Account Name in the group header lines (not the detail lines)? I have a number of expense accounts that have identical subaccounts, for example House-1:Property Tax and House-2:Property Tax. In the CoA, the Nam

Re: [GNC] gnucash-5.5-1.setup.exe

2024-02-21 Thread Paul Kroitor
Yes, immense thanks for your persistence and hard work on this. I too find all my quotidian tasks run without issue, although I have not yet tried returning to aqBanking downloads after have been forced to revert to OFX when aqBanking disappeared from the menu. The only very minor thing I noti

Re: [GNC] Ver 5.5 for Windows import issue

2024-01-01 Thread Paul Kroitor
issue goes away. Will report result, Paul -Original Message- From: gnucash-user On Behalf Of Paul Kroitor Sent: Monday, January 1, 2024 2:05 PM To: adrien.montele...@lusfiber.net; gnucash-u...@lists.gnucash.org Subject: Re: [GNC] Ver 5.5 for Windows import issue I have been getting dup

Re: [GNC] Ver 5.5 for Windows import issue

2024-01-01 Thread Paul Kroitor
I have been getting duplicates of most, but not all, messages since 3AM Saturday EST. Since around 9pm Saturday EST all messages are duplicated. Paul -Original Message- From: gnucash-user On Behalf Of Adrien Monteleone Sent: Sunday, December 31, 2023 3:40 PM To: gnucash-u...@lists.gnucas

Re: [GNC] Gnu cash Version 5.5 error message

2023-12-25 Thread Paul Kroitor
Not sure how much of a show-stopper this actually is, but 5.5 pops up an "Entry Point Not Found" error upon startup here too. I note this error was reported in prior message (below) and a screenshot was requested (see attachment). The exact message is: The procedure entry point xmllOFTPClose could

Re: [GNC] Residual Processes After Closing GnuCash

2023-10-16 Thread Paul Kroitor
e- From: gnucash-user On Behalf Of Maf. King Sent: Monday, October 16, 2023 9:53 AM To: 'GnuCash User List' Subject: Re: [GNC] Residual Processes After Closing GnuCash On Monday, 16 October 2023 14:31:10 BST Paul Kroitor wrote: > > This started in 5.1 and I was told that it w

[GNC] Residual Processes After Closing GnuCash

2023-10-16 Thread Paul Kroitor
I initially reported this in the development list but am told it should be here instead (sorry!). On Win 11 every time I open then close GnuCash, another process called "GnuCash Program File (32-bit)" remains in the task manager's process list (i.e. five executions results in five zombie proces

Re: [GNC] balance of interests between users and developers

2023-05-21 Thread Paul Kroitor
Or just fire up your OS's favourite hypervisor (Hyper-V for Windows, KVM on Linux, etc) and run multiple instances. In fact, with a single Windows VM, you can keep a tree of alternate realities (i.e., checkpoints), and jump back and forth between different scenarios. For example, running 4.10, you

Re: [GNC] Memorized Payees (aka Import Map) vs Renaming Rules

2023-05-05 Thread Paul Kroitor
That would work. On the one hand, one would have to periodically run search and replace operations. But one would save having to maintain a second translation table along side the existing Import Map. From: G R Hewitt Sent: Friday, May 5, 2023 3:26 AM To: Paul Kroitor Cc: gnucash-user

[GNC] Trouble Changing Imported Descriptions

2023-05-04 Thread Paul Kroitor
This is part 2 of a two-part question about imported transactions. My bank invariably imports transactions in barely readable technical jargon. For example, a debit card purchase at Villeneuve & Sons comes into the Aqbanking importer as: "[PR]L. VILLENEUVE &" My problem is that it's nea

Re: [GNC] Memorized Payees (aka Import Map) vs Renaming Rules

2023-05-04 Thread Paul Kroitor
F 2023 2034-302" => Transfer to Fred). (Note the key fixed typo at the end of the previous line!) Sorry for the confusion. -Original Message- From: gnucash-user On Behalf Of Paul Kroitor Sent: Thursday, May 4, 2023 8:04 PM To: gnucash-user@gnucash.org Subject: [GNC] Memorized Payees (aka

[GNC] Memorized Payees (aka Import Map) vs Renaming Rules

2023-05-04 Thread Paul Kroitor
Hi, I have two (mildly) related questions, but I will post them separately, so the threads don't get confused. Quicken has two facilities upon transaction import that interact with each other: 1.Suggests a counter account (Quicken calls some of them categories) based upon what was

Re: [GNC] Locking the side bar items

2023-04-13 Thread Paul Kroitor
ed, or prefer working with separate windows, however, there should be a way to get everything to re-open on a subsequent launch. Regards, Adrien On 4/11/23 5:23 PM, Paul Kroitor wrote: > Perhaps the OP's issue is variation of a slightly different issue that > I've asked abo

Re: [GNC] Locking the side bar items

2023-04-11 Thread Paul Kroitor
Perhaps the OP's issue is variation of a slightly different issue that I've asked about in the past. I have Gnucash set so the tabs are across the top, and reports open as additional tabs in the main window. I can open and configure many reports during a session, and these reports survive a close

Re: [GNC] set up Gnucash on a new device

2023-04-10 Thread Paul Kroitor
source was reliable. Paul -Original Message- From: gnucash-user On Behalf Of Paul Kroitor Sent: Monday, April 10, 2023 9:59 AM To: 'Glenn Fowler' ; 'David H' Cc: 'GnuCash users group' Subject: Re: [GNC] set up Gnucash on a new device The file shows "App

Re: [GNC] set up Gnucash on a new device

2023-04-10 Thread Paul Kroitor
The file shows "Application" in the Type column, which is exactly what you would expect from an .exe file if Hide Extensions was on. Thus that aspect seems fine to me. It looks to me more like Windows 11 is further tightening the control of unsigned executables. Perhaps there's a Windows Settin

[GNC] One File, Two Users

2022-12-31 Thread Paul Kroitor
Hi, long time user of GnuCash with various sets of books. Some are currently run in a quasi-office environment such that users in other cities can VPN into our LAN and thus open GnuCash books as though they are on a local server. But this infrastructure is now going away. So I need to find a wa

Re: [GNC] What accounts should I reconcile?

2022-12-19 Thread Paul Kroitor
I use the reconcile feature in at least two other ways: 1. I keep current accounts with a lot of other parties -- four adult children, parents, in-laws, my sister's farm operation, our condo association, and at least a half-dozen more. Most of them don't do formal accounting and rely on me to k

Re: [GNC] Multiple currencies

2022-07-17 Thread Paul Kroitor
Each account in your CoA operates in a specific currency, which is specified when you create it. I expect you haven't seen this yet, as you haven't set up your accounts. I'm pretty sure you don't need to add anything new for the Riel (KHR), as all the standard currencies are already built in. In fa

Re: [GNC] Changing the UI Language

2022-07-15 Thread Paul Kroitor
Sorry, meant to reply to this earlier, but it slipped my mind. Here's the Windows batch file I use to open my GnuCash files in an alternate language: c: cd c:\users\public\documents\financial set LANG=fr_CA start /D "c:\program files (x86)\gnucash\bin" gnucash.exe Note that this changes the menu

Re: [GNC] Fiscal Year: Preferences vs Properties

2022-07-07 Thread Paul Kroitor
ecial requirements / procedural quirks anyway. I guess there's nothing to do but live with it. Regards, Paul -Original Message- From: john Sent: July 07, 2022 12:48 PM To: Paul Kroitor Cc: GnuCash User List Subject: Re: [GNC] Fiscal Year: Preferences vs Properties > On Jul

Re: [GNC] Fiscal Year: Preferences vs Properties

2022-07-07 Thread Paul Kroitor
I'm afraid I can't agree. Although what you say is true, it's needlessly bleak in laying out the possible approaches. Take Quicken, for example: every file (set of books) has the fiscal year as a property (defaulting to Jan 1 - Dec 31, but changeable). Every report has a date selection (like Gn

[GNC] Fiscal Year: Preferences vs Properties

2022-07-07 Thread Paul Kroitor
Hello again, Perhaps I missed earlier discussions about this, but is there a reason the Accounting Period is an attribute in the Preferences menu (and thus system-wide) rather than in the File Properties menu (as all the other company-specific items are)? Am I correct that every time I open

Re: [GNC] Terminology for Non-profits

2022-07-06 Thread Paul Kroitor
ple as possible. Thus I'm against it, personally. I just thought I'd throw it out there in case it led to further thoughts / suggestions. Paul -Original Message- From: gnucash-user On Behalf Of Paul Kroitor Sent: July 06, 2022 11:26 AM To: stepbystepf...@comcast.net; gnucash-use

Re: [GNC] Terminology for Non-profits

2022-07-06 Thread Paul Kroitor
ou don't have to know Scheme either. Just do a Find/Replace on the report code for whatever you want to change and then add the custom file properly as per the wiki instructions. Regards, Adrien On 7/6/22 10:15 AM, Paul Kroitor wrote: > Well actually, no, I hadn't, but not because

Re: [GNC] Terminology for Non-profits

2022-07-06 Thread Paul Kroitor
sh.org Subject: Re: [GNC] Terminology for Non-profits On 2022-07-04 16:33, Paul Kroitor wrote: > Most of the entities we use GnuCash for are non-profits, and here (at > least) non-profits don't have "Equity". They have "Net Assets", which > is the same thing b

Re: [GNC] Terminology for Non-profits

2022-07-06 Thread Paul Kroitor
tor to put the reports into final form you can do all sorts of things (annotate, pretty print, add organization logo and fixed text, etc.) Michael D Novack On 7/5/2022 10:40 AM, Stan Brown wrote: > On 2022-07-04 16:33, Paul Kroitor wrote: >> Most of the entities we use GnuCash for a

Re: [GNC] Terminology for Non-profits

2022-07-06 Thread Paul Kroitor
gnucash-u...@lists.gnucash.org Subject: Re: [GNC] Terminology for Non-profits Did you try changing the name of the Equity account to 'Net Assets'? Regards, Adrien On 7/4/22 6:33 PM, Paul Kroitor wrote: > Most of the entities we use GnuCash for are non-profits, and here (at >

[GNC] Terminology for Non-profits

2022-07-04 Thread Paul Kroitor
Most of the entities we use GnuCash for are non-profits, and here (at least) non-profits don't have "Equity". They have "Net Assets", which is the same thing but doesn't imply there are owners behind the internal value to the operation. The upshot is that every report we produce that shows Equi

Re: [GNC] Reports in Alternate Language

2021-08-21 Thread Paul Kroitor
Duplicate please ignore! Sent from my iPad > On Aug 21, 2021, at 5:49 AM, p...@kroitor.ca wrote: > > Hello all. This may have already been covered, but after the death of Nabble > I can't see how to do searches throughout the archive. > > > > I need to produce accounting reports in a differe

[GNC] Opening Balance on Reports

2020-01-02 Thread Paul Kroitor
Hello, and happy New Year to all of you using whatever the name is for the calendar that just started the year 2020! I am trying to produce an annual statement for a counter-party with whom we have a current account. It's set up in GnuCash as a liability account, as generally the balance is in

Re: [GNC] Sub-accounts disappeared during upgrade 3.5 > 3.7

2019-12-17 Thread Paul Kroitor
better. Anyway, the more I think about it, the more I think I did this myself and have totally forgotten about it. If I still drank, I could blame that, but I’m afraid it’s just the effects of impending senility. Paul From: David H Sent: December 16, 2019 3:29 PM To: Paul Kroitor Cc

Re: [GNC] Sub-accounts disappeared during upgrade 3.5 > 3.7

2019-12-16 Thread Paul Kroitor
I find these sources of errors occurring once in a while. Unless others are encountering similar issues I think we might ascribe this one to approaching senility. P From: Paul Kroitor Sent: December 16, 2019 11:12 AM To: 'davidcous...@bigpond.com' Cc: 'gnucash-user@gnucash.org&

Re: [GNC] Sub-accounts disappeared during upgrade 3.5 > 3.7

2019-12-16 Thread Paul Kroitor
Thanks David, I'm on Win 10, fully patched. I did try to look at the XML data files. Unfortunately I had turned on compression and thus they're not human readable unless someone knows a simple Windows decompression command line (ideally with 7zip, which is already on the box). There are severa

Re: [GNC] Sub-accounts disappeared during upgrade 3.5 > 3.7

2019-12-16 Thread Paul Kroitor
imilar weirdness. Paul -Original Message- From: Colin Law Sent: December 16, 2019 6:00 AM To: Paul Kroitor Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Sub-accounts disappeared during upgrade 3.5 > 3.7 Are you sure they are really gone? Find a transaction in an account which was

[GNC] Sub-accounts disappeared during upgrade 3.5 > 3.7

2019-12-15 Thread Paul Kroitor
Hello. Rather bizarrely, one group of sub-accounts has disappeared from the chart of accounts in one of our books. They we there when I last closed the file in GnuCash 3.5 a few days ago, and they're gone when I first opened them in 3.7. I am wracking my brain trying to understand what's specia

Re: [GNC] Split Transactions: "wrong" Num fields show in reports

2019-11-24 Thread Paul Kroitor
again, Paul Kroitor From: Alex Aycinena Sent: November 23, 2019 12:39 PM To: gnucash-user@gnucash.org; Paul Kroitor Subject: Re: Split Transactions: "wrong" Num fields show in reports -- Forwarded message ------ From: Paul Kroitor mailto:p...@kroitor.ca>> T

[GNC] Split Transactions: "wrong" Num fields show in reports

2019-11-23 Thread Paul Kroitor
nters, etc Paul Kroitor ___ 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.g