Re: [GNC] Import matching

2024-04-23 Thread Phyllis Bruce
> Thaks again for your time. > > > Thank You, > > Gyle McCollam > > Gyle McCollam > > gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email > > > From: David Carlson > Sent: Tuesday, April 23, 2024 11:59 AM >

Re: [GNC] Import matching

2024-04-23 Thread Gyle McCollam
sh.org Subject: Re: [GNC] Import matching Amazon doesn't split it into multiple invoices, but multiple payments per invoice. When you go into Amazon and go to Your Orders, click the *show invoice* link. At the bottom it will show you the payment break down (taxes, gift card, each CC payment made etc

Re: [GNC] Import matching

2024-04-23 Thread Alan Johnson via gnucash-user
Amazon doesn't split it into multiple invoices, but multiple payments per invoice. When you go into Amazon and go to Your Orders, click the *show invoice* link. At the bottom it will show you the payment break down (taxes, gift card, each CC payment made etc) GNC will process this just fine.

Re: [GNC] Import matching

2024-04-23 Thread Gyle McCollam
...@live.com<mailto:gmccol...@gyleshomes.com> email From: David Carlson Sent: Tuesday, April 23, 2024 11:59 AM To: Gyle McCollam Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Import matching Gyle, Please provide more information. Not only have the

Re: [GNC] Import matching

2024-04-23 Thread Alan Johnson via gnucash-user
gt; >> >> Thank You, >> >> Gyle McCollam >> >> Gyle McCollam >> >> gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email >> >> ________ >> From: gnucash-user on >> behalf of Gyl

Re: [GNC] Import matching

2024-04-23 Thread David Carlson
lt;mailto:gmccol...@gyleshomes.com> email > > > From: gnucash-user on > behalf of Gyle McCollam > Sent: Monday, March 11, 2024 3:49 PM > To: gnucash-user@gnucash.org > Subject: [GNC] Import matching > > I tried importing credit card transactions.

Re: [GNC] Import of CSV

2024-04-13 Thread Gyle McCollam
.@live.com<mailto:gmccol...@gyleshomes.com> email From: gnucash-user on behalf of David Cousens Sent: Thursday, April 11, 2024 8:38 PM To: gnucash-user@gnucash.org Subject: Re: [GNC] Import of CSV Gyle The CSV data is likely not marked as cleared as

Re: [GNC] Import of CSV

2024-04-11 Thread David Cousens
Gyle The CSV data is likely not marked as cleared as the CSV importer can be used fro importing data from any source, including self generated while the OFX data is more likely to originate form a bank download. Cleared is not the same as reconciled. It was more relevant in the days when cheques

Re: [GNC] Import of CSV

2024-04-11 Thread David Cousens
Gyle, The import matcher works with a number of settable parameters (Edit- >Preferences->Import. The default values of these may not be suitable for your specific cases. A problem I have encountered with one supplier is that my bank include sa unique identifier number from the vendor in the

Re: [GNC] Import of CSV

2024-04-11 Thread Gyle McCollam
Sent: Thursday, April 11, 2024 7:57 PM To: gnucash-user@gnucash.org Subject: Re: [GNC] Import of CSV I can't help you with the CSV import as I typically use ofx and am not familiar with the CSV workflow. The option to reconcile is there with the OFX import because it was added by the people who ma

Re: [GNC] Import of CSV

2024-04-11 Thread Jean Laroche
I can't help you with the CSV import as I typically use ofx and am not familiar with the CSV workflow. The option to reconcile is there with the OFX import because it was added by the people who maintain and update gnucash (I worked on the ofx import myself). I'm guessing it's not on the CSV

[GNC] Import of CSV

2024-04-11 Thread Gyle McCollam
Back on 3/11 I sent 2 emails about issues with imports. Neither received any responses. This month when I imported the CSV file I had the following issues: 1. There were many receipts from the same vendor. It matched the 1st to an entry that was already reconciled, which to me doesn't

Re: [GNC] Import QIF files

2024-04-08 Thread Geoff
Hi Beryl This particular error is a problem with GnuCash version 5.6, and was resolved by one of the developers on Sunday: https://lists.gnucash.org/pipermail/gnucash-user/2024-April/111404.html You have three choices: (1) Downgrade to GnuCash version 5.5

Re: [GNC] Import QIF files

2024-04-08 Thread fromvendor
+fromvendor=outtacyte@gnucash.org] On Behalf Of Jim Passmore Sent: Monday, April 08, 2024 6:01 PM To: gnucash-user@gnucash.org Subject: Re: [GNC] Import QIF files Beryl, I can't help on the specifics as I only occasionally do imports. I will give the request to supply your operating system

Re: [GNC] Import QIF files

2024-04-08 Thread Jim Passmore
Beryl, I can't help on the specifics as I only occasionally do imports. I will give the request to supply your operating system and GnuCash version when reporting a problem. Also, and the main reason I replied, is to point out two emails in the same day with that same error message while doing

[GNC] Import QIF files

2024-04-08 Thread Beryl Lymer
I have been importing QIF files into GNUcash successfully for several years. However, for recent files, I am getting an error of ‘MISSING QIF INVESTMENT ACTION FOR TRANSACTION DATED xx/xx/.  The erroneous transaction seems to be the last of those imported.  The import will not complete.  I

Re: [GNC] Import matching

2024-03-11 Thread Gyle McCollam
behalf of Gyle McCollam Sent: Monday, March 11, 2024 3:49 PM To: gnucash-user@gnucash.org Subject: [GNC] Import matching I tried importing credit card transactions. There were 2 with no match information. Turns out Amazon split the order to 2 different transactions. I changed the trans

[GNC] Import matching

2024-03-11 Thread Gyle McCollam
I tried importing credit card transactions. There were 2 with no match information. Turns out Amazon split the order to 2 different transactions. I changed the transaction in the account to 1 of the amounts and added a transaction for the other amount. They were both dated 02/09/2024. The

Re: [GNC] Import CSV settings location

2024-02-07 Thread Adrien Monteleone
They aren't in the data file itself, I don't think. Check the Wiki for 'File Locations' which describes the various directories used by GnuCash to store various settings, reports, and other bits. Copy those over from Computer A to B as needed. Regards, Adrien On 2/7/24 8:57 AM, Aryeh

Re: [GNC] Import CSV settings location

2024-02-07 Thread Stan Brown (using GC 4.14)
On 2024-02-07 07:01, Mark at Lorimark wrote: > Can you click on Help->About and does it show the various paths in use? That's a nice feature, and I never knew it was there. Thanks for posting! Stan Brown Tehachapi, CA, USA https://BrownMath.com ___

Re: [GNC] Import CSV settings location

2024-02-07 Thread Mark at Lorimark
Hi Aryeh Can you click on Help->About and does it show the various paths in use? ~mark petryk ~w:http://www.lorimarksolutions.com On 2/7/24 08:57, Aryeh Gielchinsky wrote: Hello, I'm a new user. I saved some CSV import settings on computer A, synced my account/transaction file to computer

[GNC] Import CSV settings location

2024-02-07 Thread Aryeh Gielchinsky
Hello, I'm a new user. I saved some CSV import settings on computer A, synced my account/transaction file to computer B, but I'm unable to use the saved import CSV settings on Computer B. Are these import CSV settings saved somewhere on each computer separately? I've checked

Re: [GNC] Import Matcher Comments and Questions

2023-12-30 Thread Dale Alspach
Version: 5.5 Build ID: Flathub 5.5 Finance::Quote: 1.58 linux mint 21.1 TIAA is the source. format is Intuit/Quicken .qfx The relevant account structure was implicit in what I wrote. It approximates the structure of the TIAA accounts. More explicitly: Asset Account 1-> employer contract A ->

Re: [GNC] Import Matcher Comments and Questions

2023-12-30 Thread David Cousens
Dale, The assignment of an internal GnuCash account to an external account during import has a couple of levels. If a transfer account is specified in the import record, then the first time that account description is encountered the external name has to be assigned to a specific internal

Re: [GNC] Import Matcher Comments and Questions

2023-12-30 Thread David Carlson
It would be helpful to know what release pf GnuCash you are on, which import format you are using, and possibly which financial institution is providing the import files. If there is other informstion, possibly if you are using a certain report or have a specific accounting structure, that may

[GNC] Import Matcher Comments and Questions

2023-12-30 Thread Dale Alspach
Recently there was some restructuring of some of my retirement accounts (still under control of my former employer). This caused problems with importing because the parent accounts of the securities were altered. This led to a lot of questions from the importer. This entailed a tedious process of

Re: [GNC] Import issue

2023-12-19 Thread john
david.carlson@gmail.com>>; Gnucash Users > mailto:gnucash-user@gnucash.org>> > Subject: Re: [GNC] Import issue > > Somebody commented out all of the DEBUG logging statements in > import-backend.cpp so you'd need to uncomment them then build GnuCash > yourself, after

Re: [GNC] Import issue

2023-12-19 Thread Kalpesh Patel
Message- From: john Sent: Monday, December 18, 2023 8:55 PM To: Kalpesh Patel Cc: David Carlson ; Gnucash Users Subject: Re: [GNC] Import issue Somebody commented out all of the DEBUG logging statements in import-backend.cpp so you'd need to uncomment them then build GnuCash yourself

Re: [GNC] Import issue

2023-12-18 Thread john
till on 4.14 version of GNC but I wouldn’t mind > a pointer to a documentation showing debugging various major functions. > > > > From: David Carlson <mailto:david.carlson@gmail.com>> > Sent: Monday, December 18, 2023 5:51 PM > To: Kalpesh Patel mailto:kalpesh

Re: [GNC] Import issue

2023-12-18 Thread Kalpesh Patel
: [GNC] Import issue You forgot to cc to users. I did it for you this time. My point was that, like the OP, sometimes GnuCash does not present the correct, or any existing transaction to match an incoming transaction to during the import, so the only option left is to import as new

Re: [GNC] Import issue

2023-12-18 Thread David Carlson
sage- > From: David Carlson > Sent: Sunday, December 17, 2023 11:01 PM > To: Gyle McCollam > Cc: gnucash-user@gnucash.org > Subject: Re: [GNC] Import issue > > Gyle, > > I have sometimes had GnuCash fail to match transactions with equal amounts > and dates. I do not k

Re: [GNC] Import issue

2023-12-18 Thread Gyle McCollam
email From: Kalpesh Patel Sent: Monday, December 18, 2023 11:13 AM To: 'Gyle McCollam' Cc: gnucash-user@gnucash.org Subject: RE: [GNC] Import issue After spending some time looking at downloaded data, I've noticed that, sadly, a lot of banks and credit card companies are now appending dates in t

Re: [GNC] Import issue

2023-12-18 Thread Kalpesh Patel
d Carlson Sent: Sunday, December 17, 2023 11:01 PM To: Gyle McCollam Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Import issue Gyle, I have sometimes had GnuCash fail to match transactions with equal amounts and dates. I do not know why but I suspect either there is insufficien

Re: [GNC] Import issue

2023-12-17 Thread David Carlson
Gyle, I have sometimes had GnuCash fail to match transactions with equal amounts and dates. I do not know why but I suspect either there is insufficient matching text in the description or there is a different reason blocking the match. In those cases I just import the transaction unmatched,

[GNC] Import issue

2023-12-12 Thread Gyle McCollam
I'm importing a credit card statement and matching to transactions already entered. I have a transaction recorded on 11/08/2023 that was processed by the credit card company on 11/12/2023, 4 days later. It is not matching with the entered transaction even though the amount is identical. I've

Re: [GNC] Import Bills & Invoices

2023-11-21 Thread Adrien Monteleone
Malformed CSV. See the Tutorial & Concepts Guide §18.1 Importing Bills and Invoices. The columns need to be in that exact order and format. Regards, Adrien On 11/21/23 9:02 AM, Mark at Lorimark wrote: I am trying to run File | Import | Import Bills & Invoices. The file-type to pick is *.csv

Re: [GNC] Import Multi-split transactions from CSV

2023-11-17 Thread Sherman Yoder
> On Nov 17, 2023, at 10:38 PM, john wrote: > >  > >> On Nov 17, 2023, at 16:48, Sherman Yoder wrote: >> >> What am I >> doing wrong? > > Total speculation, but perhaps using "notes" instead of "memo" for the CSV's > Memo field. Notes is a per-transaction field while Memo is per-split.

Re: [GNC] Import Multi-split transactions from CSV

2023-11-17 Thread john
> On Nov 17, 2023, at 16:48, Sherman Yoder wrote: > > What am I > doing wrong? Total speculation, but perhaps using "notes" instead of "memo" for the CSV's Memo field. Notes is a per-transaction field while Memo is per-split. Regards, John Ralls

Re: [GNC] Import saved-reports from 4.x

2023-09-29 Thread Roland Giesler via gnucash-user
Apologies for the double post!  I received repeated responses from the mailing list that said my address is not validated...  so after a few days I posted again. And promptly now both messages are on the list! On 2023/09/28 21:41, Adrien Monteleone wrote: Roland, You already have a thread

Re: [GNC] Import saved-reports from 4.x

2023-09-28 Thread Murugan Muruganandam
:28 PM To: gnucash-user@gnucash.org Subject: [GNC] Import saved-reports from 4.x I eventually got around to installing a new Ubuntu 22.04 VM with flatpak, GNUCash 5.3 and postgres 14. All is well, except that I can't figure out where to put my customised invoices file: saved_reports-2.8 Accord

Re: [GNC] Import saved-reports from 4.x

2023-09-28 Thread Adrien Monteleone
Roland, You already have a thread posted on this, no need to repost to get an answer. I saw your previous post, but didn't reply yet since I don't use the flatpak and was going to leave this for others who do. However, I guess I can at least ask for clarification concerning: "I don't see

[GNC] Import saved-reports from 4.x

2023-09-28 Thread Roland Giesler via gnucash-user
I eventually got around to installing a new Ubuntu 22.04 VM with flatpak, GNUCash 5.3 and postgres 14. All is well, except that I can't figure out where to put my customised invoices file: saved_reports-2.8 According to /https://wiki.gnucash.org/wiki/Configuration_Locations/ it should be in

Re: [GNC] Import question

2023-09-07 Thread R Losey
Thank you for the clarification/education. On Sat, Sep 2, 2023 at 1:35 PM Fred Bone wrote: > On 02 September 2023 at 11:07, R Losey said: > > [...] > > Hi. The issue may be with the CSV (which stands for COMMA separated > > values)... if the currency contains commas, it will confuse anything

Re: [GNC] Import Transactions: Withdrawals vs Deposits, and Account

2023-09-03 Thread Geert Janssens
Op zondag 3 september 2023 17:25:48 CEST schreef Geert Janssens: > ... The other would have been (although non-obvious) to set > both accounts as "Deposit"... I meant "amounts" rather than accounts here. Sorry for the confusion. Geert ___ gnucash-user

Re: [GNC] Import Transactions: Withdrawals vs Deposits, and Account

2023-09-03 Thread Geert Janssens
That's one solution. The other would have been (although non-obvious) to set both accounts as "Deposit". That's allowed in the csv importer. Deposit and Withdrawal come from the early days of the importer and don't cover all use cases very well. "Deposit" here really means, use the number

Re: [GNC] Import Transactions: Withdrawals vs Deposits, and Account

2023-09-03 Thread Tom Balazs
Problem solved: the withdrawal columns were all negative numbers. I changed them to positive and it worked correctly. On Sun, Sep 3, 2023 at 9:20 AM Tom Balazs wrote: > I'm importing transactions into a checking account. Why do all transaction > amounts go into the deposits column? > > I'm

[GNC] Import Transactions: Withdrawals vs Deposits, and Account

2023-09-03 Thread Tom Balazs
I'm importing transactions into a checking account. Why do all transaction amounts go into the deposits column? I'm trying to import transactions one month at a time for a checking account. I have a CSV file with one month of transactions. I went through the Transaction Import Assistant / Import

Re: [GNC] Import question

2023-09-03 Thread Nicolas de La Chaise via gnucash-user
Good evening all, Apologies for wasting everyone's time and thanks again for those who responded. After looking at the csv import dialog with a fresh head, I realise I had both comma AND semicolon ticked as separators. The software was doing exactly as instructed to do. Another instance of

Re: [GNC] Import question

2023-09-02 Thread Fred Bone
On 02 September 2023 at 11:07, R Losey said: [...] > Hi. The issue may be with the CSV (which stands for COMMA separated > values)... if the currency contains commas, it will confuse anything that > thinks it is separated by commas. No. A field in a .CSV file that contains a comma will be

Re: [GNC] Import question

2023-09-02 Thread R Losey
On Thu, Aug 31, 2023 at 10:15 PM Nicolas de La Chaise via gnucash-user < gnucash-user@gnucash.org> wrote: > Hello all, > > First of all, I want to take this opportunity to thank all the posters > and developers who dedicate so much of their time to help the ungrateful > mass I belong to. You guys

Re: [GNC] Import question

2023-09-01 Thread Murugan Muruganandam
To: gnucash-user@gnucash.org Subject: [GNC] Import question Hello all, First of all, I want to take this opportunity to thank all the posters and developers who dedicate so much of their time to help the ungrateful mass I belong to. You guys rock. Now, my silly problem... My bank only offers 2

Re: [GNC] Import question

2023-09-01 Thread Carsten Hütter
Hello Nicolas, I'm on GnuCash 5.3 already. Here you can freely choose the currency format in the import dialogue, i.e. the decimal separator can be changed from comma to point or vice versa. So updating your GnuCash could be very easy solution to your issue. Greetings Carsten Am 31.08.2023 um

Re: [GNC] Import question

2023-08-31 Thread Adrien Monteleone
Nicolas, Your screenshot didn't come through, likely because you pasted it 'inline' in the message, rather than explicitly attaching it. (inline gets stripped from the message by the mailman software) While I don't do imports regularly myself from other exported data, from what I gather

Re: [GNC] Import question

2023-08-31 Thread David Carlson
Nicolas, You do not tell us what is your default currency. Gnucash is reasonably good with any of the major currencies and releaae 4.4 has a feature where it can save the csv import configuration for each variation that you may see. Others here can help you get the details correct. On Thu,

[GNC] Import question

2023-08-31 Thread Nicolas de La Chaise via gnucash-user
Hello all, First of all, I want to take this opportunity to thank all the posters and developers who dedicate so much of their time to help the ungrateful mass I belong to. You guys rock. Now, my silly problem... My bank only offers 2 formats when exporting transactions: either QIF or CSV.

Re: [GNC] import

2023-04-05 Thread Geert Janssens
Meanwhile this has been reported as https://bugs.gnucash.org/show_bug.cgi?id=798813[1] and it will be fixed in gnucash 5.1. Regards, Geert Op zaterdag 1 april 2023 08:16:48 CEST schreef Gyle McCollam: > Using Gnucash 5.0 and Windows 11. > What happened to the import QFX/OFX option? It is

Re: [GNC] import

2023-04-01 Thread Gyle McCollam
Gyle McCollam gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email From: p...@kroitor.ca Sent: Saturday, April 1, 2023 4:03 PM To: gnucash-user@gnucash.org Cc: 'Gyle McCollam' ; 'john' Subject: RE: [GNC] import I noticed that too, b

Re: [GNC] import

2023-04-01 Thread paul
-Original Message- From: gnucash-user On Behalf Of john Sent: Saturday, April 1, 2023 1:55 PM To: Gyle McCollam Cc: gnucash-user@gnucash.org Subject: Re: [GNC] import > On Mar 31, 2023, at 11:16 PM, Gyle McCollam wrote: > > Using Gnucash 5.0 and Windows 11. > What happened to th

Re: [GNC] import

2023-04-01 Thread Gyle McCollam
.@live.com<mailto:gmccol...@gyleshomes.com> email From: john Sent: Saturday, April 1, 2023 1:54 PM To: Gyle McCollam Cc: gnucash-user@gnucash.org Subject: Re: [GNC] import > On Mar 31, 2023, at 11:16 PM, Gyle McCollam wrote: > > Using G

Re: [GNC] import

2023-04-01 Thread john
> On Mar 31, 2023, at 11:16 PM, Gyle McCollam wrote: > > Using Gnucash 5.0 and Windows 11. > What happened to the import QFX/OFX option? It is missing from the chioces. Only on Windows, and I've been trying to figure that out. Regards, John Ralls

[GNC] import

2023-04-01 Thread Gyle McCollam
Using Gnucash 5.0 and Windows 11. What happened to the import QFX/OFX option? It is missing from the chioces. Thank You, Gyle McCollam Gyle McCollam gmccol...@live.com email ___ gnucash-user mailing list

Re: [GNC] import settings file

2023-01-04 Thread Kevin T via gnucash-user
thanks for that !  I am able to move setting successfully Kevin On Wednesday, January 4, 2023 at 02:58:13 AM CST, flywire wrote: https://lists.gnucash.org/pipermail/gnucash-user/2022-October/103049.html ___ gnucash-user mailing list

[GNC] import settings file

2023-01-04 Thread flywire
https://lists.gnucash.org/pipermail/gnucash-user/2022-October/103049.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user -

[GNC] import settings file

2023-01-03 Thread Kevin T via gnucash-user
All, I have moved the base gnucash data files to a different location on the file system (windows). All of the 'saved' import settings have been lost. Where are these import settings saved?  Is it a single file or embedded in some other ? The import settings aren't covered in the 

Re: [GNC] Import CSV transactions into GC

2022-10-07 Thread Phyllis Bruce
ess I ask."QFXQFX.what's that?" > > Carl Smith > > *From:* R Losey [mailto:rlo...@gmail.com] > *Subject:* [GNC] Import CSV transactions into GC > *Date:* Thursday, October 6, 2022 at 12:43 PM

Re: [GNC] Import CSV transactions into GC

2022-10-07 Thread R Losey
gt; > if the balances agree, then there'll be no problems. > > ---- > > *From:* R Losey [mailto:rlo...@gmail.com] > > *Subject:* [GNC] Import CSV transactions into GC > > *Date:* Friday, October 7, 2022 at 1:58 PM > > *To:* Carl S. > > *Cc:* David Carlson; gnuc

Re: [GNC] Import CSV transactions into GC

2022-10-07 Thread Stephen M. Butler
clear that when you perform an account reconciliation, and if the balances agree, then there'll be no problems. *From:* R Losey [mailto:rlo...@gmail.com] *Subject:* [GNC] Import CSV transactions into GC *Date:* Friday

Re: [GNC] Import CSV transactions into GC

2022-10-07 Thread Carl S.
. *From:* R Losey [mailto:rlo...@gmail.com] *Subject:* [GNC] Import CSV transactions into GC *Date:* Friday, October 7, 2022 at 1:58 PM *To:* Carl S. *Cc:* David Carlson; gnucash-user@gnucash.org Well, yes, but if I have the same balance that the statement shows, I can assume

Re: [GNC] Import CSV transactions into GC

2022-10-07 Thread R Losey
nverted to CSV format once certain data or columns (in Libreoffice Calc) > were modified or deleted. > > So with an element of happiness I ask."QFXQFX.what's that?" > > Carl Smith > -- > *From:* R Losey [mailto:rlo...@gmail.com

Re: [GNC] Import CSV transactions into GC

2022-10-07 Thread Carl S.
mailto:rlo...@gmail.com] *Subject:* [GNC] Import CSV transactions into GC *Date:* Thursday, October 6, 2022 at 12:43 PM *To:* David Carlson *Cc:* Carl S.; gnucash-user@gnucash.org While the convenience of importing transactions is nice, I've been doing manual reconciliation and entry -- it's fast enough,

Re: [GNC] Import Map Editor

2022-10-06 Thread Liz Dodd
On Thu, 6 Oct 2022 14:28:21 -0700 Jim DeLaHunt wrote: > On 2022-10-06 05:58, Carl S. wrote: > > > I'm curious about the Import Map Editor and what it's for. > > Have you read the documentation about it, at >

Re: [GNC] Import Map Editor

2022-10-06 Thread Jim DeLaHunt
On 2022-10-06 05:58, Carl S. wrote: I'm curious about the Import Map Editor and what it's for. Have you read the documentation about it, at , yet? It does say I've got something like 300 invalid mapping

Re: [GNC] Import CSV transactions into GC

2022-10-06 Thread Carl S.
you, all Carl Smith *From:* David Carlson [mailto:david.carlson@gmail.com] *Subject:* [GNC] Import CSV transactions into GC *Date:* Thursday, October 6, 2022 at 9:10 AM *To:* Carl S. *Cc:* gnucash-user@gnucash.org

Re: [GNC] Import CSV transactions into GC

2022-10-06 Thread R Losey
[mailto:david.carlson....@gmail.com > > ] > > *Subject:* [GNC] Import CSV transactions into GC > > *Date:* Thursday, October 6, 2022 at 12:17 AM > > *To:* Carl S. > > *Cc:* gnucash-user@gnucash.org > > > > What is QDF format? That would not be the same

Re: [GNC] Import CSV transactions into GC

2022-10-06 Thread David Carlson
gt; *From:* David Carlson [mailto:david.carlson@gmail.com > ] > *Subject:* [GNC] Import CSV transactions into GC > *Date:* Thursday, October 6, 2022 at 12:17 AM > *To:* Carl S. > *Cc:* gnucash-user@gnucash.org > > What is QDF format? That would not be the same as QFX. >

[GNC] Import Map Editor

2022-10-06 Thread Carl S.
I'm curious about the Import Map Editor and what it's for.  It does say I've got something like 300 invalid mapping and asks if I want to delete them. No idea what to do with itand certainly don't want to create a disaster. Thanks, Carl OpenPGP_0x19B6B68457884FFB.asc Description:

Re: [GNC] Import CSV transactions into GC

2022-10-06 Thread Carl S.
Whooops.you're right  QFX and not QDF *From:* David Carlson [mailto:david.carlson@gmail.com] *Subject:* [GNC] Import CSV transactions into GC *Date:* Thursday, October 6, 2022 at 12:17 AM *To:* Carl S. *Cc:* gnucash

Re: [GNC] Import CSV transactions into GC

2022-10-06 Thread David Cousens
Carl, The A checkbox (Add) indicates that the transaction is to be imported as it hasn't matched any existing transaction. If it was checked and that transaction was previously imported, then for some reason the Import Matcher did not automatically match the existing transaction. One possible

Re: [GNC] Import CSV transactions into GC

2022-10-05 Thread David Carlson
What is QDF format? That would not be the same as QFX. On Wed, Oct 5, 2022 at 10:57 PM Carl S. wrote: > David, > > Thanks for the recommendations. I've been working on this way too long > but think that I figured out some of the difficulties. 'Just reconciled > a credit card statement and

Re: [GNC] Import CSV transactions into GC

2022-10-05 Thread Carl S.
David, Thanks for the recommendations.  I've been working on this way too long but think that I figured out some of the difficulties.  'Just reconciled a credit card statement and got all of the old mess behind so that I can begin anew by downloading csv transactions every few days or so. I

Re: [GNC] Import CSV transactions into GC

2022-10-05 Thread David Carlson
CSV imports are less likely to catch all duplicates, especially if there is little or no history of training. Hopefully, though, amount and payee will match closely enough to usually offer matches in the comparison step of the import. In 2021 Discover card offered QFX exports which include a

Re: [GNC] Import CSV transactions into GC

2022-10-05 Thread David Cousens
Carl If you had previously imported the September transactions, then the Import Matcher should recognize all of them as duplicates and not import them. In this case the A checkbox and U+C checkbox should both be unchecked and the 'C' checkbox set to indicate that the transactions match existing

[GNC] Import CSV transactions into GC

2022-10-05 Thread Carl S.
Discover Card (a credit card) as of last week stopped providing the download of Discover card transactions in QDFmuch to my displeasure. They do provide a download of transactions in CSV format. I'm trying to figure out how to do a reliable importation of my credit card transactions into

[GNC] Import importing duplicate trans

2022-06-16 Thread Stephen M. Butler
Today I tracked down a problem I've had with OFX import from Citi CC (Costco). I did a partial month import a couple weeks ago.  Today I imported the entire statement period (so had several transactions already present).  The import "lost" a new entry and "duplicated" an entry already

Re: [GNC] Import is finding no matching transactions

2022-05-31 Thread Liz Dodd
On Wed, 1 Jun 2022 00:00:19 + Gyle McCollam wrote: > Aaron, > 1st David is correct, you don't set up the expense account as > subaccounts of your checking account. They are Expenses and you > debit the expense account and credit the bank account. By looking at > the expense account you get

Re: [GNC] Import is finding no matching transactions

2022-05-31 Thread Gyle McCollam
ce. Thank You, Gyle McCollam Gyle McCollam 609.680.2326 Mobile gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email From: gnucash-user on behalf of davidcousen...@gmail.com Sent: Tuesday, May 31, 2022 6:27 PM To: gnucash

Re: [GNC] Import is finding no matching transactions

2022-05-31 Thread davidcousens49
Aaron, >From your description it sounds as though you have created sub-accounts of your checking account to implement a budget process. If this is the case, it is the opposite of normal accounting proceduress. To account for expenditure in a specific category the generally accepted procedure is

Re: [GNC] Import is finding no matching transactions

2022-05-31 Thread Thepwnd via gnucash-user
Hi all, I wanted to circle back on this issue that I opened a couple weeks ago. I came down with the flu, as did the rest of my family, so I haven't had a chance to look at this again until this weekend. Also, I'm not sure if I'm creating the response to the mailing list in the most optimal

Re: [GNC] Import Map Editor - accidentally deleted account

2022-05-20 Thread davidcousens49
Bogdan, I have no problem deleting individual match strings in the import map editor in GC4.10 on Linux mint 20.3. I used to do it occasionally in several of the 3.x versons as well but I have never deleted all the strings for a given account. It may be that action which is causing the

Re: [GNC] Import Map Editor - accidentally deleted account

2022-05-20 Thread Bogdan
Hi David, Thanks, that's of course how I tried to delete an individual token - by highlighting the item and yet it would delete the entire account. That bug happened on several accounts but I can't reproduce it on some other accounts where I could delete tokens just fine. So I guess this is

Re: [GNC] Import Map Editor - accidentally deleted account

2022-05-19 Thread Bogdan
Hello, The course of the problem is that I tried to delete a specific mapping for a specific account in the Import Map Editor and instead it would delete the entire account with all mappings (that is, in the Map Editor, not the account itself). That looks like a bug. Anyway, it doesn't seem

Re: [GNC] Import Map Editor - accidentally deleted account

2022-05-18 Thread davidcousens49
Bogdan AFAIK the import mapping data is stored in the main data file as is the price database data. I don't know if the log files record changes to the import map editor or only transaction changes. I suspect if you have deleted something in the import map editor your only recourse will be to

Re: [GNC] Import Map Editor - accidentally deleted account

2022-05-18 Thread Bogdan
Hello, I don't have a "qif-accounts-map" file on my system. I've been importing OFX rather than QIF format. Where else would the mapping for these imports be stored? On Wed, May 18, 2022 at 1:28 AM Tommy Trussell wrote: > I don't regularly import data, so I am not sure... > > HOWEVER what

Re: [GNC] Import Map Editor - accidentally deleted account

2022-05-17 Thread Tommy Trussell
I don't regularly import data, so I am not sure... HOWEVER what happens if you quit GnuCash, move the qif-accounts-map file to another place, then open GnuCash and try the import again? https://wiki.gnucash.org/wiki/Configuration_Locations If this is "dangerous" I hope someone jumps in. Since I

Re: [GNC] Import is finding no matching transactions

2022-05-14 Thread Jean L
Yes, if the transactions have been imported before, they will not even show in the matching dialog, in the latest version of GC. J On 5/14/2022 4:26 PM, Greg Feneis wrote: Another possibility is if you happen to be trying to import transactions that GnuCash thinks have already been imported,

Re: [GNC] Import is finding no matching transactions

2022-05-14 Thread Greg Feneis
Another possibility is if you happen to be trying to import transactions that GnuCash thinks have already been imported, the matcher dialogue may appear like there are no transactions being proposed to be imported, essentially there will be nothing displayed in the matcher dialogue. Just in case

Re: [GNC] Import is finding no matching transactions

2022-05-14 Thread Jean L
Can you give us more details? Are you saying that GC does not show matching transactions, but does it at least show the imported transactions (and fails to find matches)? Note that the transaction dates have to match (the imported transactions and the ones you have in your ledger) for them to

[GNC] Import is finding no matching transactions

2022-05-14 Thread Thepwnd via gnucash-user
Hi all, So I am still fairly new to Gnucash (and personal finances for that matter), but I've been using it the last 2 months and change to track my family's spending. I primarily use my debit card for daily purchases, but I have begun keeping receipts for more immediate entry into the ledger

Re: [GNC] Import Map Editor - accidentally deleted account

2022-05-14 Thread Bogdan
Hello, does anybody have a suggestion how to fix the import map editor? On Wed, May 11, 2022, 12:26 Bogdan wrote: > Hi, > > I've accidentally deleted several accounts in the Import Map Editor - > Bayesian (actually, I was trying to delete a match string but it would > delete the entire source

[GNC] Import Map Editor - accidentally deleted account

2022-05-11 Thread Bogdan
Hi, I've accidentally deleted several accounts in the Import Map Editor - Bayesian (actually, I was trying to delete a match string but it would delete the entire source account with all match strings). Now, obviously, matching on import no longer works for these accounts. Is there a way to

  1   2   3   4   >