[GNC] Importing transactions via CSV - transactions always "c" (cleared)?!

2025-07-09 Thread Boniforti Flavio
Hi there. I'm just starting to use and understand transaction import via CSV. I've found that when importing a transaction this way, the "R" (reconcile status) field is automatically set to "c" (cleared). Is there a way to avoid this when importing and leave the

Re: [GNC] Importing single transactions to separate deposits and withdrawals

2025-04-30 Thread Paul-A via gnucash-user
Thanks everyone for the help and suggestions, it seems I underestimated how smart gnucash really is, so very little for me to do! ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lis

Re: [GNC] Importing single transactions to separate deposits and withdrawals

2025-04-29 Thread Liz
On Tue, 29 Apr 2025 15:43:40 + Paul-A via gnucash-user wrote: > 4.13 on debian, and I'd rather point to a repo for future upgrades > than do a one-time install. > There are specific instructions here https://unix.stackexchange.com/questions/107689/how-do-i-install-a-single-package-from-debi

Re: [GNC] Importing single transactions to separate deposits and withdrawals

2025-04-29 Thread David H
Paul, I use the Flatpak version on Linux - always updated by the Gnucash devs when a new version is released - details at https://wiki.gnucash.org/wiki/Flatpak Cheers David H. On Wed, 30 Apr 2025 at 01:39, Paul-A via gnucash-user < gnucash-user@gnucash.org> wrote: > Thanks for pointing this ou

Re: [GNC] Importing single transactions to separate deposits and withdrawals

2025-04-29 Thread David Carlson
025 at 07:30:07AM -0700, Brad Morrison wrote: > > Hi Paul/GNUCash users, > > > > https://wiki.gnucash.org/wiki/FAQ#Importing.2FExporting_Data - this is > > the GNC Wiki entry on importing (and exporting) data from GNUCash, > > hopefully it is current... > > I did

Re: [GNC] Importing single transactions to separate deposits and withdrawals

2025-04-29 Thread Paul-A via gnucash-user
On Mon, Apr 28, 2025 at 07:30:07AM -0700, Brad Morrison wrote: > Hi Paul/GNUCash users, > > https://wiki.gnucash.org/wiki/FAQ#Importing.2FExporting_Data - this is > the GNC Wiki entry on importing (and exporting) data from GNUCash, > hopefully it is current... I didn'

Re: [GNC] Importing single transactions to separate deposits and withdrawals

2025-04-29 Thread Paul-A via gnucash-user
Thanks for pointing this out... I'm on 4.13 that comes with debian bookworm. Is there a repo where I can easily get a newer one? On Mon, Apr 28, 2025 at 08:40:29AM -0500, David Carlson wrote: > For CSV imports, if GnuCash is a recent release, 5.10 or so, the answer is > simple. Either choose Am

Re: [GNC] Importing single transactions to separate deposits and withdrawals

2025-04-28 Thread Brad Morrison
Hi Paul/GNUCash users, https://wiki.gnucash.org/wiki/FAQ#Importing.2FExporting_Data - this is the GNC Wiki entry on importing (and exporting) data from GNUCash, hopefully it is current... Speaking of which - what version of GNUCash are you using? 5.11 is the current version - https

Re: [GNC] Importing single transactions to separate deposits and withdrawals

2025-04-28 Thread Murugan Mariappan
ucash-user Sent: 28 April 2025 09:17 To: David Carlson Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Importing single transactions to separate deposits and withdrawals The format is CSV... not sure if I follow your later suggestion, but will give it a try to see what I get. On Mon, Apr 28,

Re: [GNC] Importing single transactions to separate deposits and withdrawals

2025-04-28 Thread David Carlson
The reason I asked about OFX/QFX is because there is at least one credit card out there that my wife likes to use which has the values reversed so they all need to be manually changed either before or after the import. On Mon, Apr 28, 2025 at 8:40 AM David Carlson wrote: > For CSV imports, if

Re: [GNC] Importing single transactions to separate deposits and withdrawals

2025-04-28 Thread David Carlson
For CSV imports, if GnuCash is a recent release, 5.10 or so, the answer is simple. Either choose Amount or Amount (Negated) for the value column. If the transactions come in wrong, choose the other. Then be sure to save the settings with a unique name. The help description in the tutorial seems

Re: [GNC] Importing single transactions to separate deposits and withdrawals

2025-04-28 Thread Paul-A via gnucash-user
The format is CSV... not sure if I follow your later suggestion, but will give it a try to see what I get. On Mon, Apr 28, 2025 at 01:14:21AM -0500, David Carlson wrote: > Paul-A, > > The possible solution would be different for each type of import. Please > tell us if you can import in OFX or Q

Re: [GNC] Importing single transactions to separate deposits and withdrawals

2025-04-27 Thread David Cousens
David I assumed the file was CSV because in OFX/QFX/QIF formats it is specified explicitly whether it is a credit or debit. David Cousens On Mon, 2025-04-28 at 01:14 -0500, David Carlson wrote: > Paul-A, > > The possible solution would be different for each type of import.  > Please > tell u

Re: [GNC] Importing single transactions to separate deposits and withdrawals

2025-04-27 Thread David Carlson
Paul-A, The possible solution would be different for each type of import. Please tell us if you can import in OFX or QFX format, QIF format or CSV format. On Mon, Apr 28, 2025 at 12:35 AM Paul-A via gnucash-user < gnucash-user@gnucash.org> wrote: > I had a bank account, thankfully only for a

Re: [GNC] Importing single transactions to separate deposits and withdrawals

2025-04-27 Thread David Cousens
GnuCash will handle this. You just need to use the deposit or withdrawal header applied to the column. For me deposit always worked with my banks output but it may depend on whether your bank formats debits or credits as positive numbers. Experiment with a shortened file with only 1-2 transactions

[GNC] Importing single transactions to separate deposits and withdrawals

2025-04-27 Thread Paul-A via gnucash-user
I had a bank account, thankfully only for a few months, that exported debits and credits as negative and positive values in the same column. I suppose it'll be easy enough to massage this through awk or perl for import into gnucash, but might there already be some canned solution to handle this si

Re: [GNC] Importing QIF, from Quicken 2016

2025-02-16 Thread Wendy Verbeek
Subject: Re: [GNC] Importing QIF, from Quicken 2016 I had the same issue as there's a bug with imports on 5.10. I had to i the import into GnuCash on my wife's Linux laptop, then copy the main file over onto my W10 PC. GnuCash was happy loading it. On 15 February 2025 13:56:01 GMT, Wen

Re: [GNC] Importing QIF, from Quicken 2016

2025-02-15 Thread Roger Shilcock
I had the same issue as there's a bug with imports on 5.10. I had to i the import into GnuCash on my wife's Linux laptop, then copy the main file over onto my W10 PC. GnuCash was happy loading it. On 15 February 2025 13:56:01 GMT, Wendy Verbeek wrote: >I have tried the QIF export file from Quic

[GNC] Importing QIF, from Quicken 2016

2025-02-15 Thread Wendy Verbeek
I have tried the QIF export file from Quicken 2016 to import to GNUcash V5.10 on WIndows 10. It imports the accounts, but not the transactions. Thanks for any help * 17:35:01 WARN Could not locate file AUTHORS * 17:35:01 WARN Could not locate file DOCUMENTERS * 17:35:01 WARN Could not l

[GNC] Issues Importing CSVs

2025-02-04 Thread flywire
le 1. No need, during import select Amount or Amount(negated) as required 2. Account names can be updated in a spreadsheet with a lookup table Intuitively exporting and importing transactions seems right but synchronizing two sets of reversed transactions would be a nightmare. I have an entity

Re: [GNC] Issues Importing CSVs

2025-02-04 Thread David Cousens
in the imported records to the internal accounts in the set of books you are importing into during initial imports of records but these assignments should take place automatically once initially assigned. This would avoid the skipping lines option and should import the transactions with more than

Re: [GNC] Issues Importing CSVs

2025-02-04 Thread Paul Kroitor
using? What version of GNUCash are you using? https://www.gnucash.org/download.phtml - the current version is 5.10 https://wiki.gnucash.org/wiki/FAQ#Importing.2FExporting_Data - covers some of the importing & exporting basics, have you looked through it already? --- Thanks, Bra

Re: [GNC] Issues Importing CSVs

2025-02-04 Thread Paul Kroitor
to the other: 1. how to avoid the even/odd cadence issue introduced when importing splits 2. how to get data into the memo field in the "other" side of each transaction created by the import. Paul On 2025-02-04 10:58 a.m., Michael or Penny Novack via gnucash-user wrote: On 2/4/2

Re: [GNC] Issues Importing CSVs

2025-02-04 Thread Michael or Penny Novack via gnucash-user
On 2/4/2025 10:11 AM, Paul Kroitor wrote: I regularly have to transfer large batches of transactions from one set of existing books into another. Basically party A pays dozens of expenses for party B, then rebills B quarterly a lump sum total. I am temporarily ignoring your standard process to

Re: [GNC] Issues Importing CSVs

2025-02-04 Thread Brad Morrison
Hi Paul/GNUCash users, First off, some basics: What operating system are you using? What version of GNUCash are you using? https://www.gnucash.org/download.phtml - the current version is 5.10 https://wiki.gnucash.org/wiki/FAQ#Importing.2FExporting_Data - covers some of the importing

Re: [GNC] exporting/importing transactions..

2025-02-04 Thread Brad Morrison
Hi Arthur/Fred/GNUCash users, First off, some basics: What operating system are you using? What version of GNUCash are you using? https://www.gnucash.org/download.phtml - 5.10 is the current version https://wiki.gnucash.org/wiki/FAQ#Importing.2FExporting_Data - the GNUCash Wiki FAQs have

[GNC] Issues Importing CSVs

2025-02-04 Thread Paul Kroitor
I regularly have to transfer large batches of transactions from one set of existing books into another. Basically party A pays dozens of expenses for party B, then rebills B quarterly a lump sum total. I have established a standard process for this (by exporting then importing CSVs) but I

Re: [GNC] exporting/importing transactions..

2025-02-03 Thread Fred Tydeman
I believe an alternative method to try is: Make a copy of your existing book with the name of the business. Open that business book and delete the accounts you do not need. On Mon, Feb 3, 2025 at 4:13 AM arthur brogard via gnucash-user < gnucash-user@gnucash.org> wrote: > > I am a beginner. > I k

[GNC] exporting/importing transactions..

2025-02-02 Thread arthur brogard via gnucash-user
I am a beginner. I keep personal accounts in gnucash now starting a business and opened a new chart of account for it. exported all the transactions for the 'business account'  from the personal books. tried to import it to the business set of books. the formats don't seem to match. some fields i

Re: [GNC] Importing QIF files contain no transactions

2025-01-22 Thread John Ralls
Please remember to copy the list on all replies. No, there is no nightly build for macOS, but the change can be done by hand. With GnuCash not running, open a Finder window and right (or control) click on the Gnucash application and select Show Package Contents, then navigate to Contents/Resou

Re: [GNC] Importing QIF files contain no transactions

2025-01-22 Thread Roger Shilcock
Thanks for the quick reply John.  Good to know that I wasn't doing anything wrong.  At least I was able to do the import on my wife's Linux laptop and then move the resulting data file over to my PC. Regards. On 21/01/2025 17:14, John Ralls wrote: On Jan 21, 2025, at 08:31, Roger Shilcock

Re: [GNC] Importing QIF files contain no transactions

2025-01-21 Thread John Ralls
> On Jan 21, 2025, at 08:31, Roger Shilcock wrote: > > Hi All, > I'm new to GnuCash but am looking to migrate over to it from the 2002 version > of Quicken I currently run on my Windows 10 desktop. > Initially, I installed it Version 5.5+(2023-12-16) on my wife's laptop > running Linux Mint V

Re: [GNC] Importing QIF files contain no transactions

2025-01-21 Thread Sherlock
QIF import is known to be broken in 5.10. For example, see: https://bugs.gnucash.org/show_bug.cgi?id=799492 https://bugs.gnucash.org/show_bug.cgi?id=799494 Regards, Sherlock On 1/21/25 8:31 AM, Roger Shilcock wrote: Hi All, I'm new to GnuCash but am looking to migrate over to it from the 20

[GNC] Importing QIF files contain no transactions

2025-01-21 Thread Roger Shilcock
Hi All, I'm new to GnuCash but am looking to migrate over to it from the 2002 version of Quicken I currently run on my Windows 10 desktop. Initially, I installed it Version 5.5+(2023-12-16) on my wife's laptop running Linux Mint V22 to try it out, exported all the accounts as QIF's from Quicken

Re: [GNC] Importing CC Transactions, Positive or Negative, Debit or Credit?

2025-01-17 Thread Brad Morrison
Hi David/GNUCash users, For those that do not know and/or want to learn more about how OFX works within GNUCash - https://wiki.gnucash.org/wiki/Setting_up_OFXDirectConnect & https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings (although that information may not be current/still accurate

Re: [GNC] Importing CC Transactions, Positive or Negative, Debit or Credit?

2025-01-17 Thread Brad Morrison
2025 21:20:03 Midden-Europese standaardtijd schreef > Brad Morrison: > >> Hi Tom & GNUCash users, > >> > >> In case this issue turns out to be a bug: > >> > >> What operating system are you using? > >> > >

Re: [GNC] Importing CC Transactions, Positive or Negative, Debit or Credit?

2025-01-17 Thread Geert Janssens
re you using? > > What version of GnuCash are you using? The current version is 5.10 - > https://gnucash.org/download.phtml > > As far as importing data into GNC - > https://wiki.gnucash.org/wiki/FAQ#Importing.2FExporting_Data > > --- > Thanks, > > Brad - http

Re: [GNC] Importing CC Transactions, Positive or Negative, Debit or Credit?

2025-01-16 Thread David Carlson
FYI one of my credit cards produces OFX files that are reversed from the standard that the other cards all produce. I suppose the same might happen with the CSV format but if so you should be able to adjust the settings to match. On Thu, Jan 16, 2025, 1:56 PM Michael or Penny Novack via gnucash-u

Re: [GNC] Importing CC Transactions, Positive or Negative, Debit or Credit?

2025-01-16 Thread Brad Morrison
Hi Tom & GNUCash users, In case this issue turns out to be a bug: What operating system are you using? What version of GnuCash are you using? The current version is 5.10 - https://gnucash.org/download.phtml As far as importing data into GNC - https://wiki.gnucash.org/wiki/FAQ#Impor

Re: [GNC] Importing CC Transactions, Positive or Negative, Debit or Credit?

2025-01-16 Thread Jediator
Did the payment transactions imported as charges (negative)?  If that the case, yes, you need to choose Amount Negated for the Amount column.  If not, your CSV may have an additional column indicating if a transaction is a credit or debit, and the amount column contains all positive values.  In

Re: [GNC] Importing CC Transactions, Positive or Negative, Debit or Credit?

2025-01-16 Thread Michael or Penny Novack via gnucash-user
The statement from the credit card company is likely from THEIR point of view. Just like the statement of your bank account you get from your bank is from their point of view. What you owe them is a credit in your books but a debit in theirs. What money they owe you is a debit in your books an

[GNC] Importing CC Transactions, Positive or Negative, Debit or Credit?

2025-01-16 Thread Tom Balazs
I just imported a bunch of credit card transactions from a CSV file. I imported them into a liability credit card account, positive values, column title "amount". But they all the purchases / charge transactions went into the "payment" column, not the "charge" column. All the other info imported fi

Re: [GNC] When importing an account tree from a csv file,     account type information disappears

2025-01-10 Thread Brad Morrison
e: > Thanks, Brad, for the Wiki pointer. No, I had not read it. However, while it > says something about importing data from specific banking formats, the > treatment of csv file import seems to be concerned with transactions only and > not account structures. As for my account Type

Re: [GNC] When importing an account tree from a csv file,     account type information disappears

2025-01-10 Thread hakon
Thanks, Brad, for the Wiki pointer. No, I had not read it. However, while it says something about importing data from specific banking formats, the treatment of csv file import seems to be concerned with transactions only and not account structures. As for my account Type problem, I think I

Re: [GNC] When importing an account tree from a csv file,     account type information disappears

2025-01-09 Thread hakon
quot; ensemble (English original) and the "Nærings Kontoer" ensemble (Norwegian adaptation of a different set of accounts). So I tested four different cases of importing a (selection of) my MD account tree (sorry I also erroneously misspelt it MB earlier) into a new and empty GnuCa

Re: [GNC] When importing an account tree from a csv file, account type information disappears

2025-01-09 Thread Brad Morrison
Hi Hakon/GnuCash users, https://wiki.gnucash.org/wiki/FAQ#Importing.2FExporting_Data - have you read this section of the GnuCash Wiki on importing and exporting data? What version of GnuCash are you using? The current version is 5.10 - https://www.gnucash.org/download.phtml What operating

Re: [GNC] When importing an account tree from a csv file, account type information disappears

2025-01-08 Thread Michael or Penny Novack via gnucash-user
On 1/8/2025 5:52 PM, ha...@finne.net wrote: I am a new GnuCash user. I have several problems when trying to import an account tree from an accounting program (Mamut Datax) I have used before. One of these problems can be described as follows. I export the account structure from my MD system to

[GNC] When importing an account tree from a csv file, account type information disappears

2025-01-08 Thread hakon
I am a new GnuCash user. I have several problems when trying to import an account tree from an accounting program (Mamut Datax) I have used before. One of these problems can be described as follows. I export the account structure from my MD system to a csv file. I then use MS Excel to restruct

Re: [GNC] importing log files

2024-12-27 Thread R Losey
On Fri, Dec 27, 2024 at 10:33 AM Eric via gnucash-user < gnucash-user@gnucash.org> wrote: > Hi, > > I have the following situation. > > User "A" was making all the entries into GnuCash, but on a certain date > stopped using GNC. I will call teh data file *GNC-A*. > > User "B" took the GnuCash dat

Re: [GNC] importing log files

2024-12-27 Thread John Ralls
It’s logically valid. What errors is GnuCash raising when you try to replay the log files? Regards, John Ralls > On Dec 27, 2024, at 08:32, Eric via gnucash-user > wrote: > > Hi, > > I have the following situation. > > User "A" was making all the entries into GnuCash, but on a certain date

[GNC] importing log files

2024-12-27 Thread Eric via gnucash-user
Hi, I have the following situation. User "A" was making all the entries into GnuCash, but on a certain date stopped using GNC.  I will call teh data file *GNC-A*. User "B" took the GnuCash data file (GNC-A) from  user "A" and using a different computer making some changes to the data (correctio

Re: [GNC] Oddities importing from Quicken

2024-11-20 Thread David Carlson
The duplicate entries issue with QIF imports is very common if you have more than one account in a given QIF import file because there are no existing entries to compare against during the import. The easiest solution is to import one account at a time and carefully monitor the matching step to be

Re: [GNC] Oddities importing from Quicken

2024-11-20 Thread Simon Roberts
Many thanks Murugan, Fred; I've been using GNC for some years now for other accounting, so double entry is decently familiar (though I don't usually use the transaction journal). However, I hadn't recognized what was happening with the two entries, not least because each showed a split to the other

Re: [GNC] Oddities importing from Quicken

2024-11-20 Thread Kalpesh Patel
where trial-and-error starts. Start moving transaction from one account from Quicken at a time with the account that has highest amount of transaction to least amount. When you start importing transactions from second account, GNUCash should open a matcher window and this is where you can reassi

Re: [GNC] Oddities importing from Quicken

2024-11-20 Thread Liz
On Tue, 19 Nov 2024 20:55:19 -0600 David Carlson wrote: > You will probably decide to break the process down by accounts > and time intervals, especially if you need to edit the data during > the QIF import, which can literally take your full attention for > hours for a large import. > > Good l

Re: [GNC] Oddities importing from Quicken

2024-11-19 Thread Fred Bone
On 19 November 2024 at 16:39, Simon Roberts said: > Hi all, > > I'm hoping to get my personal accounts onto GNC (I'm using it for a small > business, so I'm tolerably familiar with it already). > > I exported a QIF from Quicken, and imported it. Lots of accounts were > created in GNC that map "w

Re: [GNC] Oddities importing from Quicken

2024-11-19 Thread David Carlson
biting the bullet, you will know if you need to massage the Quicken data before exporting it or to massage it after importing it into GnuCash or a combination, as well as whether you really want to import all or just a portion of your Quicken history. You will probably decide to break the proce

Re: [GNC] Oddities importing from Quicken

2024-11-19 Thread Doug via gnucash-user
needs to pick importing transactions, then select the account, then sort the disbursements: something that .ofx seems to handle much better in my opinion.) I have not used Quicken for about 25 years! Suggest trying different export. Then later, when importing from your bank, use .ofx or .csv

Re: [GNC] Oddities importing from Quicken

2024-11-19 Thread Murugan Mariappan
behalf of Simon Roberts Sent: 19 November 2024 20:39 To: Gnucash Users Subject: [GNC] Oddities importing from Quicken Hi all, I'm hoping to get my personal accounts onto GNC (I'm using it for a small business, so I'm tolerably familiar with it already). I exported a QIF from Quicke

Re: [GNC] Oddities importing from Quicken

2024-11-19 Thread Jim DeLaHunt
Simon: Welcome to GnuCash! Good luck with your migration. On 2024-11-19 15:39, Simon Roberts wrote: ...I exported a QIF from Quicken, and imported it. Lots of accounts were created in GNC that map "well-at-first-glance" to the actual accounts and categories in Quicken. However, many balances ar

[GNC] Oddities importing from Quicken

2024-11-19 Thread Simon Roberts
Hi all, I'm hoping to get my personal accounts onto GNC (I'm using it for a small business, so I'm tolerably familiar with it already). I exported a QIF from Quicken, and imported it. Lots of accounts were created in GNC that map "well-at-first-glance" to the actual accounts and categories in Qui

Re: [GNC] Importing CSV exchange rate prices

2024-11-03 Thread Andrew Beattie
properly! Kind regards Andrew > On 2 Nov 2024, at 22:22, Jim DeLaHunt wrote: > > Andrew: > > On 2024-11-02 05:27, Andrew Beattie wrote: >> Hi all >> >> I’m successfully importing stock prices in multiple currencies into gnucash, >> but can’t seem to fin

Re: [GNC] Importing CSV exchange rate prices

2024-11-02 Thread Jim DeLaHunt
Andrew: On 2024-11-02 05:27, Andrew Beattie wrote: Hi all I’m successfully importing stock prices in multiple currencies into gnucash, but can’t seem to find a way to import exchange rates. I’ve tried setting namespace to “Currencies” which is what’s used in the price editor, but the

[GNC] Importing CSV exchange rate prices

2024-11-02 Thread Andrew Beattie
Hi all I’m successfully importing stock prices in multiple currencies into gnucash, but can’t seem to find a way to import exchange rates. I’ve tried setting namespace to “Currencies” which is what’s used in the price editor, but the import routine highlights any line with namespace

[GNC] Importing Accounts

2024-09-22 Thread flywire
TLDR; Create a new file choosing one of the template accounts to use as a basis to export account tree as csv then modify as required. The GnuCash csv conventions don't apply to the coa csv file. Specifically: 1. It must have a header line 2. iirc all fields must be included even though most of t

Re: [GNC] Importing Accounts

2024-09-22 Thread Murugan Mariappan
To: gnucash-user Subject: [GNC] Importing Accounts Hi Folks, I am importing accounts. The third step of the import dialog shows a row with column headers. Does my import CSV file have to use that *order*, or simply use those *names*? If "order" is discretionary, can I create a colu

[GNC] Importing Accounts

2024-09-22 Thread Chris Miller via gnucash-user
Hi Folks, I am importing accounts. The third step of the import dialog shows a row with column headers. Does my import CSV file have to use that *order*, or simply use those *names*? If "order" is discretionary, can I create a column mapping with the first row? Will the "Im

Re: [GNC] Importing Data

2024-09-22 Thread Chris Miller via gnucash-user
Hi David, > The CSV importer can also work with tab separated data. There is a > setup screen in which you can set the separator so there is no need to > change it. Yes. There was an option to change the separator, but "tab" was not one of the choices. See the dialog below. > The confusion may

Re: [GNC] Importing Data

2024-09-22 Thread Chris Miller via gnucash-user
Hi Murugan, > Please refer the following link for the steps to import transactions > [ https://lists.gnucash.org/docs/C/gnucash-manual/trans-import.html | > https://lists.gnucash.org/docs/C/gnucash-manual/trans-import.html ] As I have said, I'm importing "Accounts", no

Re: [GNC] Importing Data

2024-09-21 Thread Murugan Mariappan
Subject: Re: Importing Data Hi Folks, There are couple of steps and queries 1. Create the account structure in GNC. you can import your existing structure if you have a file for the same I was very much hoping that "File ==> Import ==> Accounts from CSV" would do that. On the c

Re: [GNC] Importing Data

2024-09-21 Thread Chris Miller via gnucash-user
Hi Folks, > There are couple of steps and queries > 1. > Create the account structure in GNC. you can import your existing structure if > you have a file for the same I was very much hoping that "File ==> Import ==> Accounts from CSV" would do that. > On the column mapping it is straight

Re: [GNC] Importing Data

2024-09-21 Thread Murugan Mariappan
account, in your case of opening balance you can choose equity account Saludos Cordiales Murugan From: gnucash-user on behalf of Chris Miller via gnucash-user Sent: 21 September 2024 22:02 To: gnucash-user Subject: [GNC] Importing Data Hi Folks, QuickBooks

[GNC] Importing Data

2024-09-21 Thread Chris Miller via gnucash-user
Hi Folks, QuickBooks does not give up its data graciously, but it will export many things as an IIF -- "Intuit Interchange File", which is almost like a "CSV", except with "tab" instead of "comma". I can replace the "tab" with ";" and I'm good to go. Almost. The first line is a header to ident

[GNC] Importing QFX with no transaction, only position/price updates?

2024-09-15 Thread Ross Reedstrom
Hey y'all - I'm doing a round of quarterly (yes I'm late for Q2/early for Q3) updates, and the QFX I have downloaded from my retirement account manager (TIAA/CREF) contains no actual transactions, only position updates with prices. This is correct, I've recently retired, so contributions have stopp

Re: [GNC] Help with importing into GnuCash

2024-09-14 Thread Ken Farley
Some previous discussions of this: https://lists.gnucash.org/pipermail/gnucash-user/2015-April/060025.html https://lists.gnucash.org/pipermail/gnucash-user/2019-April/083773.html https://lists.gnucash.org/pipermail/gnucash-user/2011-August/040761.html These are just a sample of the ideas avail

Re: [GNC] Help with importing into GnuCash

2024-09-14 Thread Murugan Mariappan
2024 14:22 To: gnucash-user@gnucash.org Subject: [GNC] Help with importing into GnuCash I would like to run GnuCash in tandem with QuickBooks Enterprise for a couple months just to see if GnuCash will work for me. I can export the Chart of Accounts, Vendors, Customers and Transactions, but I am next

[GNC] Help with importing into GnuCash

2024-09-14 Thread Dr Lawrence M Fox
I would like to run GnuCash in tandem with QuickBooks Enterprise for a couple months just to see if GnuCash will work for me. I can export the Chart of Accounts, Vendors, Customers and Transactions, but I am next to clueless as to how to import (I've tried). Is there someone knowledgeable here

Re: [GNC] Importing Transactions

2024-08-13 Thread Mark at Lorimark
Hi Ron, Go to edit-> pref-> import and read what the 'default transaction status' is set to. ~mark petryk ~w:http://www.lorimarksolutions.com On 8/13/24 08:47, Ronald Solomon wrote: I am just starting with Gnucash. I was importing transactions one month at a time. January

[GNC] Importing Transactions

2024-08-13 Thread Ronald Solomon
I am just starting with Gnucash. I was importing transactions one month at a time. January and February of 2024 went okay. They were balanced and reconciled. When I did March the totals for February were changed and it took me hours to figure out that transactions in February were changed even

Re: [GNC] Importing causes 'y' in reconciliation?

2024-08-01 Thread Mark at Lorimark
do not know, sir, but I will find out :) ~mark petryk ~w:http://www.lorimarksolutions.com On 8/1/24 16:28, David Cousens wrote: Mark there is a preference setting on the Edit->_Preferences_->Import tab that sets the default status on imported transactions What was that setting at during the im

Re: [GNC] Importing causes 'y' in reconciliation?

2024-08-01 Thread David Cousens
xperience, regarding > importing and reconciliation.  He reports that after an import, the > reconciliation balances are off, and the account balances are off. > > I looked at his register, and he had reconciled 5 months or so, and > then > following those reconciled transac

Re: [GNC] Importing causes 'y' in reconciliation?

2024-08-01 Thread Stephen M. Butler
t with their new GnuCash experience, regarding importing and reconciliation. He reports that after an import, the reconciliation balances are off, and the account balances are off. I looked at his register, and he had reconciled 5 months or so, and then following those reconciled transaction,

Re: [GNC] Importing causes 'y' in reconciliation?

2024-08-01 Thread Mark at Lorimark
/1/24 11:01, Mark at Lorimark wrote: Helping someone out with their new GnuCash experience, regarding importing and reconciliation.  He reports that after an import, the reconciliation balances are off, and the account balances are off. I looked at his register, and he had reconciled 5 months or so, a

Re: [GNC] Importing causes 'y' in reconciliation?

2024-08-01 Thread Stephen M. Butler
On 8/1/24 11:01, Mark at Lorimark wrote: Helping someone out with their new GnuCash experience, regarding importing and reconciliation.  He reports that after an import, the reconciliation balances are off, and the account balances are off. I looked at his register, and he had reconciled 5

[GNC] Importing causes 'y' in reconciliation?

2024-08-01 Thread Mark at Lorimark
Helping someone out with their new GnuCash experience, regarding importing and reconciliation. He reports that after an import, the reconciliation balances are off, and the account balances are off. I looked at his register, and he had reconciled 5 months or so, and then following those

Re: [GNC] Example of importing Stock transactions from CSV

2024-07-20 Thread flywire
This post is from the https://lists.gnucash.org/pipermail/gnucash-user/2024-July/112463.html thread with discussion moving in a different direction. https://lists.gnucash.org/pipermail/gnucash-user/2024-July/112470.html Greg Julius wrote: > FWIW, I really struggled with this to figure out what w

Re: [GNC] Importing to Gnucash

2024-07-07 Thread Kalpesh Patel
t of the input field. Next time you can click the down arrow button in the same area to select and recall back previously saved setting. -Original Message- From: Ronald Solomon Sent: Friday, July 05, 2024 12:09 PM To: Users GnuCash Subject: [GNC] Importing to Gnucash I want to import fr

Re: [GNC] Importing to Gnucash

2024-07-05 Thread John Ralls
nother > column. > I have set up a test GNUCash file and am running test data. It sees the > transactions however, it negates the amount to 0 Assuming that both columns are unsigned and you’re importing into an asset account use Amount for the debit column and Amount (Negated) for

[GNC] Importing to Gnucash

2024-07-05 Thread Ronald Solomon
I want to import from a CSV file It has both debit and credit transactions. When I am labeling the CSV columns I don't see where I label Withdrawal and deposit. My deposits are in one column and withdrawals are in another column. I have set up a test GNUCash file and am running test data. It sees t

Re: [GNC] Importing a QIF file

2024-06-20 Thread David H
Kitty, Read the other thread *[GNC] Error Importing Quicken Files Mac OSX* at https://lists.gnucash.org/pipermail/gnucash-user/2024-June/112157.html - you'll see it's a known issue and will be fixed in the next release in a couple of weeks time. Bug report link thanks to Dae Re

Re: [GNC] Error Importing Quicken Files Mac OSX

2024-06-20 Thread David Reiser via gnucash-user
bug https://bugs.gnucash.org/show_bug.cgi?id=799262 fixed wait 2 weeks and the new version of gnucash will be out -- Dave Reiser dbrei...@icloud.com > On Jun 20, 2024, at 11:50, Jim Johnson wrote: > > Hi! > > I’m new to GnuCash (terrific experience so far!) and am trying to import my > old

Re: [GNC] Error Importing Quicken Files Mac OSX

2024-06-20 Thread Fred Bone
On 20 June 2024 at 11:50, Jim Johnson said: [...] > I have been looking for GnuCash 5.5 (5.6 is the current one on the > website) but was unable to find it on the website. > > Does anyone have any ideas? If you follow the link "More downloads" (4th bullet-point under "Download GnuCash 5.6") the

Re: [GNC] Importing a QIF file

2024-06-20 Thread David Carlson
Kitty, Which version of GnuCash are you using? I have not tried QIF imports in a few years but in earlier releases they did not choke on nonexistent investments. It may also be necessary to make sure that Quicken did not create a bad QIF export. Someone here can help but we do need more info to

[GNC] Error Importing Quicken Files Mac OSX

2024-06-20 Thread Jim Johnson
Hi! I’m new to GnuCash (terrific experience so far!) and am trying to import my old Quicken 2007 Mac OS X files. I used Quicken only as a check register, nothing else (no investments, pie-charts, financial overviews, whatever), so it’s just one single big checkbook register covering about 15 y

[GNC] Importing a QIF file

2024-06-19 Thread Kitty Werner
I'm on Win11, currently using Quicken Home & Business. I have no investments which seems to be the problem. When I import the QIF file, all works well until I get to the Import the Investments. Since there is nothing to import, it gives an error and stops with the only choice to Close. Nothing

Re: [GNC] Importing bank data, sending instructions.

2024-05-15 Thread David Reiser via gnucash-user
> On May 15, 2024, at 17:58, Chris Miller wrote: > > Hi Folks, > > GnuCash will import bank data in OFX format. OFX imports advise me of > activity that originates with the bank, so I can "sync" my books with the > bank. So far; so good. > > Wells Fargo produces an OFX import file with "We

[GNC] Importing bank data, sending instructions.

2024-05-15 Thread Chris Miller
Hi Folks, GnuCash will import bank data in OFX format. OFX imports advise me of activity that originates with the bank, so I can "sync" my books with the bank. So far; so good. Wells Fargo produces an OFX import file with "WebConnect", but I have been using Wells Fargo "Direct Connect" for t

Re: [GNC] Importing historical stock prices to GnuCash in Windows

2024-05-10 Thread Kalpesh Patel
You may want to look at https://github.com/ka-patel/dl_quotes/tree/main/yfinance which is Python based... -Original Message- From: sunfis...@yahoo.com Sent: Friday, May 10, 2024 2:59 AM To: Leung Wing Cheong Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Importing historical stock

Re: [GNC] Importing historical stock prices to GnuCash in Windows

2024-05-10 Thread sunfish62--- via gnucash-user
On May 10, 2024, 11:31 AM, at 11:31 AM, Leung Wing Cheong wrote: >Got it, many thanks! >Wing > >-Original Message- >From: sunfis...@yahoo.com >Sent: Friday, May 10, 2024 2:59 PM >To: Leung Wing Cheong >Cc: gnucash-user@gnucash.org >Subject: Re: [GNC] Importi

Re: [GNC] Importing historical stock prices to GnuCash in Windows

2024-05-10 Thread Leung Wing Cheong
Got it, many thanks! Wing -Original Message- From: sunfis...@yahoo.com Sent: Friday, May 10, 2024 2:59 PM To: Leung Wing Cheong Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Importing historical stock prices to GnuCash in Windows Of course there is. The csv importer can handle any

  1   2   3   4   5   6   7   >