Re: [GNC] Import is finding no matching transactions

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 to

Re: [GNC] Import is finding no matching transactions

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 w

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

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 problem

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

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 someth

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

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 possi

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

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 ret

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

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 hap

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

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

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, th

Re: [GNC] Import is finding no matching transactions

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 th

Re: [GNC] Import is finding no matching transactions

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

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 a

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

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 ac

[GNC] Import Map Editor - accidentally deleted account

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 restor

Re: [GNC] Import overwrites transaction description

Dan, Sorry to be late with a response. It is going to be awhile before I can test this. My bank just went through a big upgrade and all the account numbers changed. I "uncleared" a check transaction, downloaded an OFX file, and when I tried you suggestion the important couldn't find a matchin

Re: [GNC] Import overwrites transaction description

Thanks! Will give it a try. On Sat, Apr 9, 2022, at 3:48 AM, Dan Black wrote: > On the matching screen, select C (clear) instead of U+C (update and clear). > > > > On April 9, 2022 5:03:59 AM "Ed Reeder" wrote: > >> Example: >> I have previously entered a check into gnucash: >> Num=205, Desc

Re: [GNC] Import overwrites transaction description

t;CHECK # 205" is correct Description for it in GC. Whether that Description is useful or not is definitely debatable with opinions on both sides with equal passion. -- Message: 3 Date: Sat, 9 Apr 2022 10:26:20 -0400 From: Michael or Penny Novack To: gnucash

Re: [GNC] Import overwrites transaction description

Thanks for taking the time to reply. It is appreciated. On Sat, Apr 9, 2022, at 7:26 AM, Michael or Penny Novack wrote: > On 4/6/2022 3:53 PM, Ed Reeder wrote: >> Example: >> I have previously entered a check into gnucash: >> Num=205, Description=Smith Plumbing, Withdrawal=100.00 >> >> My bank's

Re: [GNC] Import overwrites transaction description

On 4/6/2022 3:53 PM, Ed Reeder wrote: Example: I have previously entered a check into gnucash: Num=205, Description=Smith Plumbing, Withdrawal=100.00 My bank's OFX transaction has: CHECK -100.00 205 CHECK # 205 When I import the OFX file and and match its transaction with the

Re: [GNC] Import overwrites transaction description

On the matching screen, select C (clear) instead of U+C (update and clear). On April 9, 2022 5:03:59 AM "Ed Reeder" wrote: Example: I have previously entered a check into gnucash: Num=205, Description=Smith Plumbing, Withdrawal=100.00 My bank's OFX transaction has: CHECK -100.00 205

[GNC] Import overwrites transaction description

Example: I have previously entered a check into gnucash: Num=205, Description=Smith Plumbing, Withdrawal=100.00 My bank's OFX transaction has: CHECK -100.00 205 CHECK # 205 When I import the OFX file and and match its transaction with the previously entered check transaction the "

[GNC] Import Transaction Manager (version 3.8) customization

Greetings, I am using GnuCash 3.8 (I haven't updated to a later version because I'm running Ubuntu 20.04 and don't want to take the time to set up to compile the source, nor do I want to be bothered with having to set up and work around the limitations of the flatpack installs. Once 22.04 com

Re: [GNC] Import csv, ofx

0.2326 Mobile > > > > gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email > > > > > > From: gnucash-user > on behalf of davidcousen...@gmail.com > > Sent: Tuesday, January 4, 2022 8:53 PM > > To: gnucash-user@gnucash.org

Re: [GNC] Import csv, ofx

...@gyleshomes.com> email From: gnucash-user on behalf of davidcousen...@gmail.com Sent: Tuesday, January 4, 2022 8:53 PM To: gnucash-user@gnucash.org Subject: Re: [GNC] Import csv, ofx Gyle, Export it as Excel, load it up in Excel and export it from there as CS

Re: [GNC] Import csv, ofx

david whiting Sent: Wednesday, January 5, 2022 3:09 AM To: Gyle McCollam Subject: Re: [GNC] Import csv, ofx Hi Gyle, If I have understood correctly, you just need to select the appropriate date format in the Miscellaneous settings during the import. So, after selecting your csv file to import (there

Re: [GNC] Import csv, ofx

le gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email From: gnucash-user on behalf of davidcousen...@gmail.com Sent: Tuesday, January 4, 2022 8:53 PM To: gnucash-user@gnucash.org Subject: Re: [GNC] Import csv, ofx Gyle, Export it as Excel, loa

Re: [GNC] Import csv, ofx

Gyle, Export it as Excel, load it up in Excel and export it from there as CSV. GnuCash has always read Excel's CSV exports AFAIK (I use Libre Ofiice these days and it certainly works with LO). You should also be able to set the date format in the CSV import dialog. It will likely default to the fo

[GNC] Import csv, ofx

I have been having a great experience importing ofx files for my bank accounts and credit cards. However, when I tried to export from Discover Card, the only options were Excel or csv. I didn't see that Gnucash imported Excel so I used csv. I had absolutely no luck importing the csv file into

Re: [GNC] import csv transactions

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

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

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

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

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

[GNC] Import securities into security editor and show local value of shares not default currency value of shares

Hi 1. Is it possible to import securities into the securities editor or does every stock have to be manually set up? 2. I have GBP set as the main currency. I have a USD shares in a USD denominated account. Is it possible to show the USD value of the shares? Currently it only shows i)

Re: [GNC] Import CSV account names matching problems

Excellent. Didn’t know about piecash. Looks really useful. Thanks for the pointer! Best, Stephan > On 10. Oct 2021, at 11:48, flywire wrote: > > Stephan, you're right, you can't. Try python - > https://lists.gnucash.org/pipermail/gnucash-user/2021-July/097124.html >

[GNC] Import CSV account names matching problems

Stephan, you're right, you can't. Try python - https://lists.gnucash.org/pipermail/gnucash-user/2021-July/097124.html Email me directly if you want support. Splits are a bit different. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your

[GNC] Import CSV account names matching problems

Dear all, I have a CSV with thousands of transactions from my checking account that I’ve generated from another software. I have prepared and curated it such that in principle it contains all information needed for Gnucash to import the transactions with the correct expense and income accounts.

Re: [GNC] import csv transactions with split

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

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

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

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

Re: [GNC] Import Format

The developers' link looks interesting. It seems to be mainly about making authorized payments for e-commerce functions on a quick look at it and nothing about downloading transaction data, but it is a move in the right direction. The Python version of the API may provide a way of creating a paym

Re: [GNC] Import Format

Sample pdf bank statement attached. Format will vary by bank but note "Opening balance" before first transaction, "BALANCE CARRIED FORWARD" at end of non-last page, "BALANCE BROUGHT FORWARD" at start of non-first page and "CLOSING BALANCE" on last page would allow transaction filtering. Some progr

Re: [GNC] Import Format

Another two of the four Australian banks: * https://help.anz.co.nz/app/answers/detail/a_id/334/~/transaction-history-export-formats * https://www.westpac.com.au/business-banking/online-banking/support-faqs/export-detailed-transaction-history/ Don't assume these formats are available with all acco

Re: [GNC] Import Format

Thanks Dave, that's one of the four main banks: https://commbank.simplify.com/commerce/docs/misc/dataexport Interestingly there's a developer's link on that page too. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gn

Re: [GNC] Import Format

On a related note, I wish Gnucash supported export formats besides CSV. -p On Thu, May 27, 2021 at 9:39 PM DaveC49 wrote: > The CBA in Australia offers CSV, OFX and QIF (2 variants) downloads from > the > bank website. They only offer direct connect OFX downloads via MYOB or > Quicken where th

Re: [GNC] Import Format

The CBA in Australia offers CSV, OFX and QIF (2 variants) downloads from the bank website. They only offer direct connect OFX downloads via MYOB or Quicken where these companies have a software deal/agreement with the bank about security. i have approached them about direct connect access but recei

[GNC] Import Format

The documentation could offer users more guidance in choosing the import format. Most banks allow account transactions to be downloaded (usually as files) and most financial software (including GNUCash) allows the transactions to be imported. GnuCash offers six options but in reality the user migh

[GNC] Import accounts from CSV / new security

Hi everyone, When doing an "Import accounts from CSV" if the account is "stock" type, it will require a "security" (or commodity) as parameter. Is there any way to create the security through import, when it is a new one and it does not exist? TIA. -- Sent from: http://gnucash.1415818.n4.nabb

Re: [GNC] Import invoices ~ tax table

Glad you got it sorted! On Sat., 6 Mar. 2021, 00:50 R. Victor Klassen, wrote: > Bingo. > > This has been hanging around for a long time since 99% of our sales are > zero-rated. Automatically catching the other 1% will reduce the opportunity > for errors and speed up the process. > > Sent from my

Re: [GNC] Import invoices ~ tax table

Bingo. This has been hanging around for a long time since 99% of our sales are zero-rated. Automatically catching the other 1% will reduce the opportunity for errors and speed up the process. Sent from my iPhone > On Mar 5, 2021, at 7:13 AM, R. Victor Klassen wrote: > > I’m wondering whe

Re: [GNC] Import invoices ~ tax table

I’m wondering whether I left out the “Tax Included” column, and whether there are no important columns after that so it just (almost) works. I’ll have another chance to try it out this morning, as we have an importable invoice twice a week. Something to try. > On Mar 4, 2021, at 8:10 PM, Nelso

Re: [GNC] Import invoices ~ tax table

In your original email you say your GST Tax table is in column P - mine is in column Q. So perhaps that's the problem? Thanks & Regards, Nelson Handcock 0409 149919 http://www.linkedin.com/in/nelsonhandcockaustralia On Fri, Mar 5, 2021 at 11:09 AM Nelson Handcock wrote: > Hello, > > Ahh yes

Re: [GNC] Import invoices ~ tax table

Hello, Ahh yes - I mis-read your original email! Here's a snapshot of my recent loadfile: [image: image.png] And here's a snapshot of my tax tables: [image: image.png] The loaded invoice looks fine in GN - the GST amount is correct and is showing in the liabilities account as defined. Thanks

Re: [GNC] Import invoices ~ tax table

When I said the x in the “Taxable?” column is correctly showing which items are taxable, I was referring to the column in the invoice after import. I do have a Y in the appropriate column of the csv file being imported - else I wouldn’t get the x in the “Taxable?” column. > On Mar 2, 2021, at

Re: [GNC] Import invoices ~ tax table

Hello, Try using "Y" in the Taxable column instead of "X" Regards, etc On Wed., 3 Mar. 2021, 02:40 R. Victor Klassen, wrote: > The documentation I’ve read has me specify the tax table in column 15 > (counting from 0) aka column P when the csv file is opened as a > spreadsheet. > > When I put t

[GNC] Import invoices ~ tax table

The documentation I’ve read has me specify the tax table in column 15 (counting from 0) aka column P when the csv file is opened as a spreadsheet. When I put the three letters “HST” or the phrase “Harmonized Sales Tax”, both of which name sales tax tables, in that column, it is ignored. The

Re: [GNC] Import CSV: save settings doesn't save

Thanks for those details. I do have libgtk-3 installed, version 3.18.9. I believe I've had it installed since I built GnuCash; Linux Mint 18.3 appears to have come with gtklib 3.18. Also, I assume most of GnuCash wouldn't work if libgtk runtime wasn't installed from the get-go. I built it (GnuC

Re: [GNC] Import CSV: save settings doesn't save

Marcus, Those errors in the tracefile tends to suggest a problem with the GTK library at runtime. Have you recently upgraded from a 2.x version of GnuCash to the 3.6 version? The GTK dependencies changed at that transition. (https://wiki.gnucash.org/wiki/Dependencies - i need to upgrade this for

Re: [GNC] Import CSV: save settings doesn't save

Thanks for the reply. I don't get any sort of pop-up when I type in a name and click on the Save button. I finally found something that might help. This might be a question for the gnucash-dev list (rather than the user list). When I try to save the import profile, I get the following lines in

Re: [GNC] Import CSV: save settings doesn't save

Marcus This works fine in GnuCash 4.4 on LinuxMInt 20.3. Apologize for not responding earlier but II rarely use the importer with CSV these days and had left it for someone who was using it regularly. Tosave the file with changed settings( change at least one first of course) you first have to

Re: [GNC] Import CSV: save settings doesn't save

Hello everyone, If there are any suggestions on how to figure out the trouble, I'd appreciate it. -m On Fri, Jan 22, 2021 at 9:26 AM Marcus Winston wrote: > >>> the next time you run the csv import assistant the name you typed in > should be present... > > That's the problem: the name I typed i

Re: [GNC] Import CSV: save settings doesn't save

>>> the next time you run the csv import assistant the name you typed in should be present... That's the problem: the name I typed in doesn't show up. That's what I mean by "nothing happens". -marcus On Fri, Jan 22, 2021 at 8:19 AM John Ralls wrote: > > > > On Jan 22, 2021, at 7:26 AM, Marcus

[GNC] Import CSV: save settings doesn't save

Hello, I'm using GnuCash 3.6 on Linux. Trying to get CSV import working a bit "faster". I see the "Save Settings" (https://www.gnucash.org/docs/v4/C/gnucash-guide/importing-from-files.html#importing-csv-save). Unfortunately for me, saving settings doesn't work. I type in a name, click the "Sa

Re: [GNC] Import PayPal transactions into GC (Windows)

That is about to the ofx backend. I see no relation to the paypal backend. Frank Am 25.11.20 um 23:55 schrieb Jeff Albrecht: > On 11/25/2020 3:27 PM, Frank H. Ellenberger wrote: > >> >> Gnucash 4.2 on Windows shipped aqbanking-6.2.2, gwenhywfar-5.4.0 >> The recent nighlies >> [https://code.gnuca

Re: [GNC] Import PayPal transactions into GC

t; > it's not > > > too easy to set up and probably have to spend the rest of my > > life > > > figuring out all of the intricacies to use itI quit. > > > Thank you, all, for the help. > > > Peter > >

Re: [GNC] Import PayPal transactions into GC (Windows)

On 11/25/2020 3:27 PM, Frank H. Ellenberger wrote: Gnucash 4.2 on Windows shipped aqbanking-6.2.2, gwenhywfar-5.4.0 The recent nighlies [https://code.gnucash.org/builds/win32/maint/?C=M;O=D] are build with aqbanking-6.2.5 and gwenhywfar-5.4.1 I do not remember major changes related to the paypa

Re: [GNC] Import PayPal transactions into GC

hank you, all, for the help. >     Peter >  __ > >     From: Frank H. Ellenberger [[1]mailto:frank.h.ellenber...@gmail.com <mailto:frank.h.ellenber...@gmail.com>] >     Subject: [GNC] Import PayPal transactions into GC >     Da

Re: [GNC] Import PayPal transactions into GC (Windows)

Hi Jeff Am 25.11.20 um 22:58 schrieb Jeff Albrecht: > For me... > > CSV is death by a thousand cuts. > Aqbanking worked consistently once I got it configured. (Only about 175 > cuts) Unfortunately the development of Aqbanking got out of sync with > GNUCash a while back. I think it's been correcte

Re: [GNC] Import PayPal transactions into GC

et up and probably have to spend the rest of my life > > figuring out all of the intricacies to use itI quit. > > Thank you, all, for the help. > > Peter > > __ > > > >

Re: [GNC] Import PayPal transactions into GC

ve to spend the rest of my life figuring out all of the intricacies to use itI quit. Thank you, all, for the help. Peter __ From: Frank H. Ellenberger [[1]mailto:frank.h.ellenber...@gmail.com] Subject: [GNC

Re: [GNC] Import PayPal transactions into GC

Peter __ From: Frank H. Ellenberger [[1]mailto:frank.h.ellenber...@gmail.com] Subject: [GNC] Import PayPal transactions into GC Date: Wednesday, November 25, 2020, 3:26 PM To: Peter Dutton Cc: Gnucash Users Am 25.11.20 um 19:38 schrieb Peter Dutton:

Re: [GNC] Import PayPal transactions into GC

- > > *From:* Frank H. Ellenberger [mailto:frank.h.ellenber...@gmail.com] > > *Subject:* [GNC] Import PayPal transactions into GC > > *Date:* Wednesday, November 25, 2020, 12:44 PM > > *To:* Peter Dutton > > *Cc:* Gnucash Users > > > >> You didn't tell us y

Re: [GNC] Import PayPal transactions into GC

mail.com] > *Subject:* [GNC] Import PayPal transactions into GC > *Date:* Wednesday, November 25, 2020, 12:44 PM > *To:* Peter Dutton > *Cc:* Gnucash Users > >> You didn't tell us your OS/distribution. If you are on Linux >> https://wiki.gnucash.org/wiki/Flatpak wou

Re: [GNC] Import PayPal transactions into GC

Yes, I read them but they were of no assistance- too basic. Peter __ From: Frank H. Ellenberger [[1]mailto:frank.h.ellenber...@gmail.com] Subject: [GNC] Import PayPal transactions into GC Date: Wednesday, November

Re: [GNC] Import PayPal transactions into GC

I'm running Ubuntu18.04 Mate Peter... __ From: Frank H. Ellenberger [[1]mailto:frank.h.ellenber...@gmail.com] Subject: [GNC] Import PayPal transactions into GC Date: Wednesday, November 25, 2020, 12:44 PM

Re: [GNC] Import PayPal transactions into GC

You didn't tell us your OS/distribution. If you are on Linux https://wiki.gnucash.org/wiki/Flatpak would be one possibility to get a recent Gnucash and Aqbanking. Am 25.11.20 um 18:14 schrieb Peter Dutton: > The online banking tool wizard in my version of GC v 3.11 doesn't do anything > when I cl

Re: [GNC] Import PayPal transactions into GC

From: Frank H. Ellenberger [[1]mailto:frank.h.ellenber...@gmail.com] Subject: [GNC] Import PayPal transactions into GC Date: Wednesday, November 25, 2020, 11:45 AM To: Peter Dutton Cc: Gnucash Users Hi Peter, you can also use our onlinebanking tool aAqBanking [2]https://wiki.gnucash.org/wik

Re: [GNC] Import PayPal transactions into GC

Hi Peter, you can also use our onlinebanking tool aAqBanking https://wiki.gnucash.org/wiki/AqBanking to direct download your paypal account into gnucash. The full instructions need to become translated to English: https://wiki.gnucash.org/wiki/De/Paypal_einrichten and https://wiki.gnucash.org/wik

Re: [GNC] Import PayPal transactions into GC

Peter, If you are using release 3.something or 4.something The CSV importer works pretty well once you get it set up correctly and save the configuration for repeated use. If it is making 'a mess' you need to make some adjustment. All of the import methods allow a lot of flexibility in the 'match

[GNC] Import PayPal transactions into GC

How can I easily import PayPal transactions into GC? I've tried importing a CSV but it just makes everything a mess. A qif import works a little better but not much. Any ideas for a guy who isn't clever? Thank you, Peter (my nametoday)

Re: [GNC] Import transactions

G'day Michael If you haven't already, I suggest you start with the following sections of the Gnucash Documentation: https://www.gnucash.org/viewdoc.phtml?rev=4&lang=C&doc=help 6.16. Importing Transactions from Files 6.16.5. Import CSV Then have a look at the second last post on this thread whe

[GNC] Import transactions

I need to import bank data csv into Gnucash accounts. So far with some limited success. I am unsure from the user manual of the required column headings in the import wizard screen. If the data to be imported is say: into account ASSET: BankXYZ date description de

Re: [GNC] Import transactions with expenses in a different currency

Hmm I see. Thanks for the suggestion. However I don't think this solves the issue. I would still need to go manually through all the accounts, and also this would introduce a layer of complexity in importing my monthly statements that I don't really want... -- Sent from: http://gnucash.1415818.n

Re: [GNC] Import transactions with expenses in a different currency

I had similar problems and I solved it by turning on "trading accounts" . This way there are no exchange rates involved in individual transactions, but instead each transaction is balanced to a currency trading account. To correct any existing transactions I then had to click on it and accept gnuca

[GNC] Import transactions with expenses in a different currency

In the latest version of gnucash (4.1-2 from flathub) I noticed that, when importing transactions in .ofx/.csv into a GBP-denominated bank account, and matching them to expense accounts in EUR, I get the following error message: The account 'Electronics' has a different commodity from the one re

Re: [GNC] Import quicken

: gnucash-user@gnucash.org Subject: [GNC] Import quicken What steps to go thru for a Quicken QIF file import to Gnucash ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https

[GNC] Import quicken

What steps to go thru for a Quicken QIF file import to Gnucash ___ 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 Nab

Re: [GNC] Import Transaction Matcher issue in v4

Hello everyone, Just confirming the issue with Citibank QFX files. They are changing the FITID for the same transactions in the QFX downloads. I'll reach out to them, but I'm not optimistic The download on Friday yielded the following for a specific transaction: CREDIT 2020072112 54.00

Re: [GNC] Import Transaction Matcher issue in v4

Michael, Exactly. The QFX file only contains the information that the bank would put on your monthly account statement along with the necessary infrastructure to identify which bank created the file and which account and the time frame which the file describes and sometimes some additional inform

Re: [GNC] Import Transaction Matcher issue in v4

Hello David, In looking at the QFX file, I only see one side of the transaction. This file has 3 distinct transactions ( records) that are not related and only one account ID is listed. Michael On Mon, Jul 27, 2020 at 5:56 PM David Carlson wrote: > There is another use case which GnuCash also

Re: [GNC] Import Transaction Matcher issue in v4

There is another use case which GnuCash also needs to handle. Some OFX files may contain both sides of an inter-account transfer between two accounts within the same bank because the OFX file can include multiple accounts. In fact, I do that on a regular basis at one of my banks. I do not test G

Re: [GNC] Import Transaction Matcher issue in v4

Fross, Michael, Are you trying to match bank payments to credit card accounts from QFX/OFX downloads from both sides? If so, the FITID's might accidentally match but the FID and/or BANKID and/or ACCTID of the bank/credit card transaction split line in the import file should be different from the

Re: [GNC] Import Transaction Matcher issue in v4

Got it. Thanks. Now I understand why it used to work. And I certainly wouldn't expect GnuCash to correct a bank's horrible behavior. I'll keep an eye on the FITID and see if that's what they are doing. Thanks everyone for your help. Much appreciated. Michael On Mon, Jul 27, 2020 at 5:13 PM J

Re: [GNC] Import Transaction Matcher issue in v4

Ah, OK I get it now! Yes, you should check that from one day to the next, the FTID returned by citibank remains the same (for the same transaction). If not, then that's going to be a problem. What has changed recently with GC is that it not will not match a new imported transaction with one fro

Re: [GNC] Import Transaction Matcher issue in v4

No. Section 3.2.3 of the OFX 1.6 spec: "An FI (or its Service Provider) assigns an to uniquely identify a financial transaction that can appear in an account statement. Its primary purpose is to allow a client to detect duplicate responses. Open Financial Exchange intends for use in statement

Re: [GNC] Import Transaction Matcher issue in v4

Hi Christopher. Alas I do not keep the QFX files. I'll hang on to them for now and see if the FIDID does change. On Mon, Jul 27, 2020 at 4:20 PM Christopher Lam wrote: > As I understand the ofx spec*, the fitid should be an invariant for the > bank and account. By any chance do you have older

Re: [GNC] Import Transaction Matcher issue in v4

Hi Jean. Let me try to better explain my issue. On most days, I download QFX files from my Checking and Credit Card accounts and import them. In this way I clear transactions and I can see what's going on. The next day I'll do so again, and the importer skips those that have already been matche

Re: [GNC] Import Transaction Matcher issue in v4

As I understand the ofx spec*, the fitid should be an invariant for the bank and account. By any chance do you have older qfx files to compare? * https://www.ofx.net/downloads.html On Tue, 28 Jul 2020, 4:34 am Fross, Michael, wrote: > Thanks Jean / John for your thoughts. There is a register e

Re: [GNC] Import Transaction Matcher issue in v4

There's a misunderstanding here. This is what GC does: - It looks at the OFX transaction, which always has an FITID. - IF GC sees this FITID in one of the register transactions, it skips the OFX transaction, because it's already been imported (when a transaction gets imported from the ofx, the o

<    1   2   3   4   >