Re: : importing

Welcome to GnuCash! Since you have already found the qfx importer you are almost there. Each QIF file contains only transactions from one financial institution and probably only for one or two accounts. You simply follow the steps that appear after starting the importer. It will first ask you

Re: : importing

Does File > Import > Import OFX/QFX not work for you? For instructions, visit gnucash.org. Click the documentation link on the left. Read over the Help Manual and the Tutorial & Concepts Guide. Regards, Adrien > On Mar 10, 2018, at 8:59 AM, Beri Hull wrote: > > Hi, I am

Re: Importing Quicken

7) >> How can I import these? > >I found it easier to just start again with GnuCash instead of importing >data >that I did not require. You then have a nice new clean set of accounts. > > >Keith > > > > >- >GnuCash 2.6.19 - Windows 10 >-- >Sent

: importing

Hi, I am new to gnucash and want to import data from my various bank and investment accounts that I have imported to finder as qfx files. I am able to import data as qfx files that appear listed in a box titled generic import transaction matcher.I need the transactions imported into

Re: Importing Quicken

Edward Ingram-2 wrote > My Quicken files are stored in .QDF format, not .QIF. (Quicken 2017) > How can I import these? I found it easier to just start again with GnuCash instead of importing data that I did not require. You then have a nice new clean set of accounts. Keith - G

Re: Importing Quicken

r 10, 2018 at 10:21 AM, Edward Ingram <edwardingram...@gmail.com > > wrote: > >> Thanks for the quick response! >> I discovered that I could export my Quicken in .QIF and amazingly, >> gnucash had no problems whatsoever importing them. I'm a little >> intimidated as

Re: Importing Quicken

gly, gnucash > had no problems whatsoever importing them. I'm a little intimidated as I > begin to learn gnucash as I have hundreds of accounts that don't actually > exist. I will need months of work to reduce them to the three registers > that I actually need. > > On Sat, M

Re: Importing Quicken

On 03/10/2018 11:16 AM, David Carlson wrote: The QDF format is one of the data formats that Quicken has used over the years. It is proprietary and sufficiently encrypted to be impossible to read with other programs. Before you abandon Quicken you need to use it to open your file and export

Re: Importing Quicken

ge- > From: gnucash-user <gnucash-user-bounces+pyz01=cox@gnucash.org> On > Behalf Of Edward Ingram > Sent: Saturday, March 10, 2018 8:03 AM > To: gnucash-user@gnucash.org > Subject: Importing Quicken > > My Quicken files are stored in .QDF format, not .QIF.

Re: Importing Quicken

The QDF format is one of the data formats that Quicken has used over the years. It is proprietary and sufficiently encrypted to be impossible to read with other programs. Before you abandon Quicken you need to use it to open your file and export your data to QIF format which GnuCash can import.

RE: Importing Quicken

al Message- From: gnucash-user <gnucash-user-bounces+pyz01=cox@gnucash.org> On Behalf Of Edward Ingram Sent: Saturday, March 10, 2018 8:03 AM To: gnucash-user@gnucash.org Subject: Importing Quicken My Quicken files are stored in .QDF format, not .QIF. (Quicken 2017) How can I i

Re: importing splits

are preparing for release, hopefully next month). I've been importing multi split transactions for years using the qif importer. Am I missing something here? Cheers Lawrence ___ gnucash-user mailing list gn

Re: importing splits

;> >> Assuming this is one transaction, you are essentially asking to import >> multi- >> split transactions. >> >> This is not possible in gnucash 2.6, but it will be in 3.0 (which we are >> preparing for release, hopefully next month). >> > I've been im

Re: importing splits

, but it will be in 3.0 (which we are preparing for release, hopefully next month). I've been importing multi split transactions for years using the qif importer. Am I missing something here? Cheers Lawrence ___ gnucash-user mailing list gnucash-user@gnucash.org

Re: importing splits

ot;, Latin for "for example", used to provide an example. > > Jeff > > > On Tue, Feb 20, 2018 at 09:01:54PM +, Matt Graham wrote: > > The easiest way would be saving the spreadsheet to .csv format and > importing > > that to Gnucash. > > >

Re: importing splits

Bob membership rx 50.00 Jeff On Tue, Feb 20, 2018 at 09:01:54PM +, Matt Graham wrote: > The easiest way would be saving the spreadsheet to .csv format and importing > that to Gnucash. > > Id recommend: > - first removing any other text and stuff you have so that

Re: importing splits

The easiest way would be saving the spreadsheet to .csv format and importing that to Gnucash. Id recommend: - first removing any other text and stuff you have so that the spreadsheet is just the headings you want and the data you want in columns - doing the import on a new test gnucash file

Re: Headers for importing accounts from CSV

Sorry, I don’t use that feature at all, so I’ll have to defer. Try a google search on the list with “site:lists.gnucash.org” (without the quotes) followed by your search terms. You’ll get hits only from the list archives. There are many threads on OFX and AqWizard and I doubt you’re the first

Re: Headers for importing accounts from CSV

Sweet! What a simple solution... Can't believe I didn't think of trying to make an account then export it. Setting up all the accounts I need one by one is painful. Thanks for the info! Regards, Holly Ochidi On Thu, Feb 15, 2018 at 4:49 PM, Adrien Monteleone < adrien.montele...@gmail.com>

Re: Headers for importing accounts from CSV

Sorry, I forgot to mention that in the hidden and place_holder columns, the export shows ‘F’ and ‘T’ so those should work, but if not, using or 0 or 1 should suffice. The tax column also appears to be binary. I think the setting is just a check box for each account that asks “Tax Related?” so

Re: Where does Gnucash keep the list of accounts to match transactions to when importing OFX/QFX

Hi Clint, the associations are kept within the datafile itself. There's no current mechanism for modifying these associations, however, the upcoming version 3.0 will feature an editor. On 23 Jan 2018 11:16 AM, "Clint Redwood" <cl...@screwtape.co.uk> wrote: > Hi, > &g

Where does Gnucash keep the list of accounts to match transactions to when importing OFX/QFX

Hi, I'm importing a number of transactions, and most repeating transactions import fine, but some have incorrect accounts linked and some don't choose. I seem to remember that there is a file or page somewhere where these links are stored, but I can neither find that within Gnucash

Control order of splits importing from QIF?

Hello, I created a QIF file to test importing a payroll transaction. The import works well but the splits are ordered differently in the gnucash transaction than the QIF file. I enter the splits in an order matching the report from the payroll software to make it easier to review

Re: Crashes importing CSV

; I've been using gnucash for a bit now and had no issues once I started to > understand things but recently I tried importing CSV files, not for the > first time, and gnucash crashed. Going through some previous suggestions > I've tried re-saving the file, adding "," to the end of each

Crashes importing CSV

Hello everyone, I've been using gnucash for a bit now and had no issues once I started to understand things but recently I tried importing CSV files, not for the first time, and gnucash crashed. Going through some previous suggestions I've tried re-saving the file, adding "," to the e

Importing Data

I have just purchased a new laptop with Windows 10 and am trying to import the data from my old laptop onto it. Which files do I look for and how can I put them on my new machine? Rick ___ gnucash-user mailing list gnucash-user@gnucash.org

Re: importing

There should be no need to delete the Trading Accounts. It only exists if you have set File>Properties>Use Trading Accounts to true, and you have transactions that involve a currency/stock conversion. The transactions in the Trading Accounts are harmless, and are even useful when performing some

Re: importing

I tried to delete the trading account and my program crashed.  I tried again and sometimes it crashes and sometimes nothing happensHow do we delete that trading accountI do not need it, but it has transactions, I cannot delete the transactions either.  There is also am imbalance

Re: importing

Frank, You certainly had way too many issues with installing and starting to use GnuCash. Hopefully, you have seen them all and will enjoy the benefits now. If GnuCash ever crashes again please report that here. David C On Thu, Oct 12, 2017 at 10:09 AM, frank raney

Re: importing

I re-downloaded and re-installedworks now.. Frankie Raney 12454 Auberry Rd. Clovis, Ca. 559.297.8577 H 559.304.1751 C On 10/12/2017 7:52:06 AM, frank raney wrote: I am using win 10 and installed GC 2.6.18. I have even tried putting the help pdf file manually,

Re: importing

I am using win 10 and installed GC 2.6.18. I have even tried putting the help pdf file manually, no luck..looks like the install file is only the program, no help file...got it from the GC web site  https://www.gnucash.org/download.phtml Frankie Raney 12454 Auberry Rd. Clovis, Ca.

Re: importing

What O S are you installing into and what version are you installing? The help files come along automatically in Windows and most Linux packages. David C On Oct 11, 2017 11:18 PM, "frank raney" wrote: > I can't find the documentation to tell me where to put the help

Re: importing

I forgot to mention that there is a setting somewhere called "Use Trading Accounts" that turns that feature on or off. I think it is mentioned somewhere in the documentation. David C On Wed, Oct 11, 2017 at 4:07 PM, David Carlson wrote: > Frank, > > There is still

Re: importing

Frank, There is still a problem with Gnucash on your computer because it should not be crashing. It may be somehow related to the account named Trading that GnuCash created. Normally, GnuCash will only create that account for users that know that they want to use a special feature that is there

Re: importing

On Wed, Oct 11, 2017 at 3:31 PM, frank raney wrote: > I just answered my own question..The lck file is a temporary file > when the main file is opened. I opened my file read only, resaved it. > closed it and the lck file went away. I opened the file in a

Re: importing

m]> >> wrote: >> >> > Yes, yes, and yes. It was, is the only filewhen it crashed it went >> > awayI saved it after importing, and looked at it with file >> > browserit was therethen I went back, run GC and started >> > editing..when

Re: importing

2017 2:50 AM, "Liz" <ed...@billiau.net [mailto:ed...@billiau.net]> > wrote: > >> On Mon, 9 Oct 2017 20:39:34 -0700 >> Frankie Raney <frankraney...@gmail.com [mailto:frankraney...@gmail.com]> >> wrote: >> >> > Yes, yes, and yes. It was,

Re: importing

> >> > Yes, yes, and yes. It was, is the only filewhen it crashed it went >> > awayI saved it after importing, and looked at it with file >> > browserit was therethen I went back, run GC and started >> > editing..when GC crashed, the fil

Re: importing

On Tuesday, 10 October 2017 14:30:41 BST Frankie Raney wrote: > Did a search, that's how I know it went to lala land. Can't remember ever > having this happen before. > Hi Frankie, Don't know much about importing, 'cos I've never done it, but trashing the data file is a worry! AFAI

Re: importing

es, and yes. It was, is the only filewhen it crashed it went > > awayI saved it after importing, and looked at it with file > > browserit was therethen I went back, run GC and started > > editing..when GC crashed, the file went to lala land. Only the > >

Re: importing

On Mon, 9 Oct 2017 20:39:34 -0700 Frankie Raney <frankraney...@gmail.com> wrote: > Yes, yes, and yes. It was, is the only filewhen it crashed it went > awayI saved it after importing, and looked at it with file > browserit was therethen I went back, run GC and st

Re: importing

Yes, yes, and yes. It was, is the only filewhen it crashed it went awayI saved it after importing, and looked at it with file browserit was therethen I went back, run GC and started editing..when GC crashed, the file went to lala land. Only the log file was left. On Oct 9

Re: importing

It's entirely possible that Frank has a "mybooks.gnucash" file that doesn't have everything, and a bunch of "mybooks.gnucash..gnucash" files which have (incrementally) more of everything, as well as the "*.log" files which go along with them, but beign a new user doesn't realize what those

Re: importing

I thought it did something like that..I usually do save periodically when working for long periods,  But I got so involved, I forgot.How do I get/install an sql backend. Frankie Raney 12454 Auberry Rd. Clovis, Ca. 559.297.8577 H 559.304.1751 C On 10/9/2017 6:43:14 AM, Aaron Laws

Re: importing

QIF importer may not work exactly the same way that it >> did back in the 2.2 series or the 2.4 series or even the 2.6 series before >> release 2.6.18. >> >> If that is the c as e then we really do need someone who is familiar >> with the way it works now to jump in an

Re: importing

other* David suggested importing each account separately; I was suggesting importing all at once. In my (admittedly ancient) experience, I worked to get the Quicken data just so, and when I imported everything, I had little to no duplicates. David (T.) On Oct 7, 2017, at 7:17 PM, Frankie Raney &l

Re: importing

[mailto:frankraney...@gmail.com]> wrote: I did import all at once..don't know yet how to export individual accounts from Quicken.. Frankie Raney On 10/7/2017 7:46:05 AM, David T. <sunfis...@yahoo.com [mailto:sunfis...@yahoo.com]> wrote: Frank, The *other* David suggested impor

Re: importing

ie Raney > > On 10/7/2017 7:46:05 AM, David T. <sunfis...@yahoo.com> wrote: > Frank, > > The *other* David suggested importing each account separately; I was > suggesting importing all at once. In my (admittedly ancient) experience, I > worked to get the Quicken data j

Re: importing

I did import all at once..don't know yet how to export individual accounts from Quicken.. Frankie Raney On 10/7/2017 7:46:05 AM, David T. <sunfis...@yahoo.com> wrote: Frank, The *other* David suggested importing each account separately; I was suggesting importing all at once.

Re: importing

Frank, The *other* David suggested importing each account separately; I was suggesting importing all at once. In my (admittedly ancient) experience, I worked to get the Quicken data just so, and when I imported everything, I had little to no duplicates. David (T.) > On Oct 7, 2017, at 7

Re: importing

rted way back when, so I believe that exporting the > whole file (accounts, categories and transactions for it all) will catch > those duplications. But I've been known to be wrong before. > > David T. > > On October 7, 2017, at 6:24 AM, frank raney <frankraney...@gmail.com

Re: importing

for it all) will catch those duplications. But I've been known to be wrong before. David T. On October 7, 2017, at 6:24 AM, frank raney <frankraney...@gmail.com> wrote: >I thought I had the importing figured out, but no... >I exported my quicken data to qif format.  W

importing

I thought I had the importing figured out, but no... I exported my quicken data to qif format.  When I import it into GC I get a lot of double entries.  Quicken uses catagories, GC uses accounts... How do I import my cash accounts without getting all the duplicates. My checking

importing qif file

I import a 10 day bank transaction from my only  bank into my only gnucash  checking account.  My checking is in current assets.  When I imported prior to this week, my transaction went to the checking account with a "unspecified" note in my transfer column.  This worked great for me.  When I

Re: Importing bookings with accounts fully assigned

Good evening, ;-) That sounds indeed like exactly the thing that I would need! However, I already tried a bit with the QIF format, reading the manual, then trying to manually fabricate some QIF file exactly with that intention - with no success so far. So if you have any knowledge of that

Importing bookings with accounts fully assigned

Good morning, Does anybody know a way or a specific data format that allows to import bookings into Gnucash that have already their "counter booking" (probably not the correct bookkeeper's language...)? Example: I have a list of bookings somehow like the following: Date Amount

Importing Memo data via QIF

I have been unable to import data in the M field using QIF import. Everything else imports OK, but the Memo data does not import. How do I import the Memo field data using QIF import? ___ gnucash-user mailing list gnucash-user@gnucash.org

Re: Preferred Date Format When Importing CSV Files

It does seem odd that the importer does not default to the same choice that the user has chosen for the data file, even though it is important to allow the user to change it if (s)he has a CSV file with a different choice. David C On Sat, Jul 29, 2017 at 7:36 AM, Jean-David Beyer

Re: Preferred Date Format When Importing CSV Files

On 07/28/2017 09:32 PM, Paul W. wrote: > I set the date format to m-d-y in Edit>Preferences>Date/time > > When I import CSV files, the date format on the Preview Settings page shows > y-m-d. I manually change the format to m-d-y. > What do I need to do to have GC automatically show the

Preferred Date Format When Importing CSV Files

I set the date format to m-d-y in Edit>Preferences>Date/time When I import CSV files, the date format on the Preview Settings page shows y-m-d. I manually change the format to m-d-y. What do I need to do to have GC automatically show the format I selected.

Re: When importing transactions, what happens to non-identical data in the description and notes fields?

com Cc: gnucash-user@gnucash.org Subject: Re: When importing transactions, what happens to non-identical data in the description and notes fields? Date: Sun, 9 Jul 2017 10:33:21 -0500 Paul In my experience it depends on which method you use. I usually use the OFX import and if I choose update t

Re: When importing transactions, what happens to non-identical data in the description and notes fields?

The importer includes three options: A, R and R+U. These mean: A = add the transaction as new R+U = reconcile the transaction with a matching transaction and update the existing GC transaction with the incoming data (description field etc.) R = Reconcile the incoming transaction with

When importing transactions, what happens to non-identical data in the description and notes fields?

I import transactions in QIF, GFX and CSV formats to GC 2.6.16. When I import transactions, GC proposes to match some of the imported transactions with transactions in my file. GC highlights these transactions in green. These transactions do not have identical data in the date, description,

RE: Issues with Importing Invoices

going to try that out. :) -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+danielsonb=logroom@gnucash.org] On Behalf Of DaveC49 Sent: Sunday, May 28, 2017 6:55 PM To: gnucash-user@gnucash.org Subject: Re: Issues with Importing Invoices Hi Buster, Customer jobs

Re: Issues with Importing Invoices

C/gnucash-help/busnss-ar-customers1.html#busnss-ar-custfind2 in the Help Manual. David Cousens. -- View this message in context: http://gnucash.1415818.n4.nabble.com/Issues-with-Importing-Invoices-tp4691904p4691921.html Sent from the GnuCash - User

Issues with Importing Invoices

Greetings - I am a fairly new user, and have a couple of business questions. I was looking to see if I can make, print & send to vendors Purchase Orders in GnuCash, and assign this to job(s) if necessary. I see Orders in the Properties / Counters tab but there is little to no explanation as to

RE: Issues with Importing Invoices

importing and posting, all one step. Thanks Nelson, all is good. I appreciate your help & suggestions. Bruce From: Nelson Handcock [mailto:nelson.handc...@gmail.com] Sent: Thursday, May 25, 2017 8:03 PM To: Bruce Danielson Cc: gnucash-user@gnucash.org Subject: Re: Issues with Impor

RE: Issues with Importing Invoices

Nelson – OK, I just copied your exact header row and tried importing but with no ID’s (Invoice Number blank) – I got errors that No ID Set (or something like that). So, I plugged in Invoice Numbers – and it worked. 2 invoices to 2 users, perfect, just as you would expect. I then posted both

RE: Issues with Importing Invoices

; when I get some success. Thx Again Nelson, Bruce From: Nelson Handcock [mailto:nelson.handc...@gmail.com] Sent: Thursday, May 25, 2017 5:57 PM To: Bruce Danielson Cc: gnucash-user@gnucash.org Subject: Re: Issues with Importing Invoices Hi Bruce, In no particular order

Re: Issues with Importing Invoices

> > > Thanks Nelson – I appreciate your help. Please check out my import file > and see if you spot anything amiss. > > Bruce > > > > *From:* Nelson Handcock [mailto:nelson.handc...@gmail.com] > *Sent:* Wednesday, May 24, 2017 12:54 PM > *To:* Bruce Danielson &

Re: Issues with Importing Invoices

Bruce, I've attached a sample of an invoice import file that I recently prepared and successfully loaded up. If you change the "memberidn" to match your customer ID's and also change the account names then it should work for you. The key thing for me is sorting my source data by Member ID and

<    1   2   3   4   5   6