Re: [GNC] Import CSV transactions into GC

2022-10-07 Thread Phyllis Bruce
appiness 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, 2

Re: [GNC] Import CSV transactions into GC

2022-10-07 Thread R Losey
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, October 7, 2022 at 1:58 PM > > *To:* Carl S.

Re: [GNC] Import CSV transactions into GC

2022-10-07 Thread Stephen M. Butler
x27;s 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 *Dat

Re: [GNC] Import CSV transactions into GC

2022-10-07 Thread Carl S.
o 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; gnucash-user@gnucash.org Well, yes, but if I have the same balance that the statement shows, I can assum

Re: [GNC] Import CSV transactions into GC

2022-10-07 Thread R Losey
DF > converted 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:rl

Re: [GNC] Import CSV transactions into GC

2022-10-07 Thread Carl S.
rom:* R Losey [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

Re: [GNC] Import CSV transactions into GC

2022-10-06 Thread Carl S.
ll. Thank 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@g

Re: [GNC] Import CSV transactions into GC

2022-10-06 Thread R Losey
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? Th

Re: [GNC] Import CSV transactions into GC

2022-10-06 Thread David Carlson
> *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

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:* gn

Re: [GNC] Import CSV transactions into GC

2022-10-05 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 reas

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 got

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 uniq

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 t

[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 G

Re: [GNC] import csv transactions

2021-11-14 Thread Kalpesh Patel
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> Subject: Re: [GNC] import csv transactions Message-ID: mailto:cahrzaam_8e2rznh2hfg8csv767+l0rowblytkhohnltpmek...@mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" Thank you David. I will take your advi

Re: [GNC] import csv transactions

2021-11-13 Thread Chris Matchett
Thank you David. I will take your advice and work through a small number of transactions and follow your guidance. My file is csv. I caused confusion by transposing for readability in the email :-) Chris On Sat, 13 Nov 2021 at 22:38, wrote: > Chris, > > The account to import the records to wil

Re: [GNC] import csv transactions

2021-11-13 Thread davidcousens49
Chris, The account to import the records to will be the account in GnuCash which records the transactions for your business bank account. If you have the register for that account open when you initiate the import process it will be used as the default account to import to unless that is explicitl

Re: [GNC] import csv transactions

2021-11-13 Thread D via gnucash-user
If that's exactly your file format, it's not csv. Setting that aside, you'd need to import from within the bank account register, and then designate an account in gnucash to match up with TRANSPORT. On Nov 13, 2021, 14:06, at 14:06, Chris Matchett wrote: >Hi, > >I am experimenting with gnucash.

[GNC] import csv transactions

2021-11-13 Thread Chris Matchett
Hi, I am experimenting with gnucash. I am trying to import a csv file of my business bank statement. Starling bank in the UK. I assume the date and description fields are good below for the mandatory requirements? I am not sure how to match deposit and/or withdrawal and which account to use? *(D

Re: [GNC] import csv transactions with split

2021-09-20 Thread David H
Got it. Glad you got it sorted out. Cheers David H. On Tue, 21 Sept 2021 at 02:27, David Solet wrote: > David, thank you for your response. That is not the problem, since there > is a screen where one links the name of the account in the csv > file--whatever it is--with the actual account in gn

Re: [GNC] import csv transactions with split

2021-09-20 Thread David Solet
David, thank you for your response. That is not the problem, since there is a screen where one links the name of the account in the csv file--whatever it is--with the actual account in gnucash. However, I found the problem; it is with the content of the csv file. In my csv file, a value for custome

Re: [GNC] import csv transactions with split

2021-09-19 Thread David H
I don't use the csv importer but it seems to be complaining about not having a transfer account - "New, UNBALANCED (need acct to transfer $($$$.cc))! While you do have a text description in the account column when I do a csv import in gnucash format the account names are in the full format eg "Exp

[GNC] import csv transactions with split

2021-09-19 Thread David Solet
Hello, My version = 4.6 (Windows). I want to import a csv file with split transactions. The following text lines from the csv file represent one transaction (not real) that took place on 9/19/2021. This is a simplified example. An actual transaction would likely have more splits. Column heads are i