Re: [GNC] Setting Currency Format when importing from CSV?

2022-05-11 Thread Geert Janssens
gnucash.org; gnucash-user@gnucash.org > Cc: viking...@san.rr.com > Subject: Re: [GNC] Setting Currency Format when importing from CSV? > > > > I believe gnucash only cares about the decimal point separator and ignores > the thousands separator. So for your example selecting "

Re: [GNC] Setting Currency Format when importing from CSV?

2022-05-12 Thread Michael or Penny Novack
On 5/12/2022 2:18 AM, Geert Janssens wrote: Unfortunately that's currently not possible. If the currency symbol had been "$" instead of "USD" it would probably have worked as the code is hardwired to ignore that value. The only alternative I can suggest is to preprocess your CSV file to add a

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

2022-07-11 Thread Geoff
Hi Jon This isn't exactly what you are asking for, but it may give you some clues. Importing Dividends from CSV:- https://lists.gnucash.org/pipermail/gnucash-user/2020-August/092768.html Good luck! Geoff = On 12/07/2022 12:35 pm, Jon Schewe wrote: Does anyone have an examp

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

2022-07-12 Thread Jon Schewe
That looks similar to what I'm doing, except all of my data is on a single line in the CSV file. The biggest problem seems to be how to convince GnuCash to use 2 different commodities for the transaction when importing from CSV. On Tue, 2022-07-12 at 13:04 +1000, Geoff wrote: > Hi Jon &

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

2022-08-19 Thread Jon Schewe
doing, except all of my data is on a > single line in the CSV file. The biggest problem seems to be how to > convince GnuCash to use 2 different commodities for the transaction > when importing from CSV. > > > On Tue, 2022-07-12 at 13:04 +1000, Geoff wrote: > > Hi Jon >

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

2022-08-20 Thread Michael or Penny Novack
hich means two important things. The fields (individual data elements) cannot contain commas but even more important, ORDER MATTERS. In other words, the record A,B,C,D is not the same a B,A,C,D << A, B, C, and D being elements of data, names, amounts, etc. >> The CSV data you are i

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

2022-08-21 Thread Jon Schewe
Jack, I have tried using this configuration multiple times to get the import to work. I have a list of column assignments, none of which have worked correctly. Thus the python script that does in fact work. In your screenshot I see column options that don't exist for me. Are you impo

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

2022-08-21 Thread Jon Schewe
t the same a B,A,C,D << A, B, > C, > and D being elements of data, names, amounts, etc. >> > > The CSV data you are importing must not only be in CSV format but the > data must be in the right order AND any data that is null (not > present > still has its space i

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

2022-08-21 Thread Jack Frillman via gnucash-user
I’m importing prices —— I smell carrots a-cooking and where there’s carrots, there’s a rabbit. — Yosemite Sam > On Aug 21, 2022, at 9:34 AM, Jon Schewe wrote: > >  > Jack, > > I have tried using this configuration multiple times to get the import to > work. I

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

2022-08-21 Thread David Carlson
security at some exchange rate, aka price. For this discussion I will ignore commissions and fees. Thus you want to have two CSV lines per transaction. Also, when importing the CSV file, you will need to check the Multi-split box to tell GnuCash that is the type of file that you are importing

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

2022-08-21 Thread Jon Schewe
f cash from a brokerage account, the other an > exchange of the cash for a security at some exchange rate, aka > price.  For this discussion I will ignore commissions and fees. > > Thus you want to have two CSV lines per transaction.  Also, when > importing the CSV file, you will

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

2022-08-21 Thread john
commas but even more important, ORDER >> MATTERS. >> >> In other words, the record A,B,C,D is not the same a B,A,C,D << A, B, >> C, >> and D being elements of data, names, amounts, etc. >> >> >> The CSV data you are importing must not only be

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

2022-08-21 Thread David T. via gnucash-user
cash from a brokerage account, the other an >> exchange of the cash for a security at some exchange rate, aka >> price.  For this discussion I will ignore commissions and fees. >> >> Thus you want to have two CSV lines per transaction.  Also, when >> importing the CSV fi

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

2022-08-21 Thread David Carlson
Jon, I just tried exporting one transaction from a security account and re-importing it with the CSV importer. It worked like a charm! I don't have time right now to detail what I did here, but I did not need to select the Multi split box after all. Have fun On Sun, Aug 21, 2022 at 12:

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

2022-08-21 Thread David Carlson
nicely, but I did not try extending the test to multiple transactions. On Sun, Aug 21, 2022 at 3:19 PM David Carlson wrote: > Jon, > > I just tried exporting one transaction from a security account and > re-importing it with the CSV importer. It worked like a charm! I don't &g

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

2022-08-24 Thread Jon Schewe
fields delineated > > > by  > > > commas. Which means two important things. The fields (individual > > > data > > > elements) cannot contain commas but even more important, ORDER > > > MATTERS. > > > > > > In other words, the record A,B,C,D is

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

2022-08-24 Thread Adrien Monteleone
Unless I've confused something, purchasing or selling a stock/fund/etc. should be between 2 asset accounts. Considering a split for a commission or such, (like the first line of your CSV) it would be a *specific* expense account, not the parent and placeholder "Expenses" account. Regards, Adr

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

2022-08-24 Thread David Carlson
Jon, My example that I gave earlier deliberately ignored commissions. I assumed the simpler method, as described somewhere in the help manual, that net prices were used instead. This will better match your broker's statements when you review the cost basis. If your first line is supposed to ind

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

2022-08-24 Thread flywire
> Does the CSV importer handle floating point values for amount and price or do I need to use integers? Floating point works fine for me in all amounts except price: https://lists.gnucash.org/pipermail/gnucash-user/2022-August/102535.html > e.g you'd write $497.65 for 57 shares as 49765/5700 ___

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

2022-08-24 Thread flywire
The three lines below work using a Multi-split import - based on https://bugs.gnucash.org/show_bug.cgi?id=797450 Save *PP-Demo_Transactions_Minimal_Priced2.csv*: Date,Description,Action,Account,Deposit,Rate/Price 01/02/2021,RIO,,Assets:Broker:Funds,-9912.53 ,,Buy,Assets:Broker:Shares:RIO,89,8900/

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

2022-08-24 Thread Jon Schewe
I used the parent Expense account because I don't really need to track it separately. The fee is paid directly out of the stock account. I don't see how adding an additional account is going to fit the commodity problem. The second line is a purchase from a specific Asset account and that transacti

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

2022-08-24 Thread Adrien Monteleone
As for using the Expenses account, unless you intentionally made it *not* a placeholder account, you can't put transactions in it. I'll hazard a guess that is why the importer is not assigning it. Create a sub-account of Expenses for tracking the commissions/fees and try to assign that one in

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

2022-08-24 Thread David Carlson
The GnuCash account structure is dictated by the program and it will not necessarily exactly match what your brokerage statement shows. As one of the previous comments noted, there are some bug reports indicating that the csv importer is not able to import some transactions . You may need to fudge

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

2022-08-24 Thread Jon Schewe
My accounts were created before GnuCash defaulted to setting the top level accounts as placeholders. So yes, my Expenses account will allow transactions to use it. When I get to the "Match Transactions" step, none of the transactions have transfer accounts. When click the Add column and then try a

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

2022-08-25 Thread flywire
Did you carefully work through the known working process described in the bug report Comment 3 using the file below? The broker csv file almost certainly needs manipulating. The best approach is to enter the data into GnuCash, and then export the account to csv. You can use the exported csv to see

Re: [GNC] Importing investment info from Financial Planner's website

2019-05-27 Thread David T. via gnucash-user
Jo, Importing such information is typically a one- time process, and the time it would take to programmatically process all possible situations makes it expensive, from a programming perspective. The development team has focused on other areas. I doubt any developer would take up your request

Re: [GNC] Importing investment info from Financial Planner's website

2019-05-27 Thread Joseph Hymel via gnucash-user
might exist in GNUCASH also. There is so much similarity between the two applications that has amazed me and thus caused me to seek this functionality out if it existed. I appreciate your prompt response nonetheless. Jo On Monday, May 27, 2019, 06:55:53 AM CDT, David T. wrote: Jo, Impo

Re: [GNC] Importing investment info from Financial Planner's website

2019-05-27 Thread David Carlson
, David T. < > sunfis...@yahoo.com> wrote: > > Jo, > > Importing such information is typically a one- time process, and the time > it would take to programmatically process all possible situations makes it > expensive, from a programming perspective. The development team ha

Re: [GNC] Importing investment info from Financial Planner's website

2019-05-28 Thread csingley
Just to summarize what people are telling you: GnuCash doesn't have any sort of functionality to automatically create accounts for an investment the first time it's seen, if that's what you're after. You will need to manually set up your accounts with beginning balances. It's not that bad, unles

Re: [GNC] Column Detection when Importing Transactions from CSV

2019-06-26 Thread Geert Janssens
Op woensdag 26 juni 2019 21:31:54 CEST schreef Patrick: > When importing transactions from a CSV file, is there a way to have GnuCash > automatically detect the meaning of the columns based on the CSV headers? > The headers in my CSV file are "Date", "Description"

Re: [GNC] Column Detection when Importing Transactions from CSV

2019-06-26 Thread Patrick
hreef Patrick: > > When importing transactions from a CSV file, is there a way to have > GnuCash > > automatically detect the meaning of the columns based on the CSV headers? > > The headers in my CSV file are "Date", "Description", "Account", etc., >

Re: [GNC] Column Detection when Importing Transactions from CSV

2019-06-26 Thread Stephen M. Butler
On 6/26/19 12:31 PM, Patrick wrote: > When importing transactions from a CSV file, is there a way to have GnuCash > automatically detect the meaning of the columns based on the CSV headers? > The headers in my CSV file are "Date", "Description", "Account", et

Re: [GNC] Reconcile Flag when Importing Transactions from CSV

2019-07-02 Thread Patrick
On Mon, Jul 1, 2019 at 7:33 AM Patrick wrote: > When I am importing transactions from a CSV, I have a "Reconcile" column > that I select as the "Transfer Reconciled" column in the import wizard. I > have all of the entries marked as "n" in this column, but af

Re: [GNC] Reconcile Flag when Importing Transactions from CSV

2019-07-05 Thread Patrick
https://bugs.gnucash.org/show_bug.cgi?id=796890 > > On Mon, Jul 1, 2019 at 7:33 AM Patrick wrote: > >> When I am importing transactions from a CSV, I have a "Reconcile" column >> that I select as the "Transfer Reconciled" column in the import wizard. I >>

[GNC] GC Importing GC Export Format - too many credits

2019-10-08 Thread ornd25
When I import using GnuCash Export Format it brings in more splits than I requested. This is a simple dividend reinvestment, with one Dr Asset:Mutual fund, and one Cr Income:Dividends. I ended up with the wrong number of splits and a wrong allocation follows: Line 1 - Asset: Mutual Fund 3.026 s

[GNC] GC Importing GC Export Format - too many credits

2019-10-08 Thread ornd25
reimported it. On reimporting it created a miscellaneous transaction tothe imbalance account for 3.45.   The price on export was 14+17238/34483 butwhen reimported the price is recorded as 13+17238/34483 accounting for thisdifference. This appears to be some problem with importing prices expressed

[GNC] Importing a CSV with transactions in another currency

2019-10-11 Thread Frederico Zica
Hello! I have been using gnucash with more than one currency, but recently I got puzzled about how to proceed with a CSV import. In that CSV there are USD transactions while my main Gnucash currency is not USD, and the majority of my accounts don't have USD as their currency. I'm

[GNC] Importing bank transactions B4 posting bills & Invoices - question

2020-02-03 Thread Fran_3 via gnucash-user
Can I 1 - import banking transactions Then2 - Post Bills from vendors & Invoices to clients Then 3 - Apply the previously imported bank transaction to the appropriate bill or invoice? Thanks for any help. ___ gnucash-user mailing list gnucash-user@gnuc

Re: [GNC] Importing Checking Transactions: Expense Acct Assignment Question.

2020-02-04 Thread Adrien Monteleone
of transactions for errors or improper account assignments, and then you miss the benefit of training the importer) You might want to start with just importing basic expenses and get some of those payees trained and make sure the importer matches subsequent imports correctly. Then move on to the

Re: [GNC] Importing Checking Transactions: Expense Acct Assignment Question.

2020-02-04 Thread David Cousens
Just a note re the training of the importer to match transactions to transfer accounts. The ability to do this depends upon there being sufficient consistent distinguishing information in the description fields of the imported transaction. One vendor I have supplies a different unique transact

Re: [GNC] Importing Checking Transactions: Expense Acct Assignment Question.

2020-02-05 Thread Derek Atkins
Hi, Fran_3 via gnucash-user writes: > Will assigning the Expense Account during import conflict with later > creating a bill and then assigning a checking transaction as payment > for that bill? (Since the Expense Account is normally assigned during > creation of the bill... so this will be kind

Re: [GNC] Importing Checking Transactions: Expense Acct Assignment Question.

2020-02-05 Thread Fran_3 via gnucash-user
benefit of training the importer) You might want to start with just importing basic expenses and get some of those payees trained and make sure the importer matches subsequent imports correctly. Then move on to the business payments that need to be assigned. All of them should go to AP and each

Re: [GNC] Importing Checking Transactions: Expense Acct Assignment Question.

2020-02-05 Thread Fran_3 via gnucash-user
Derek, your answer confirmed Adrian's post and both gave me the confident to experiment today. I'll pull the trigger on the big import tomorrow and report back. On Wednesday, February 5, 2020, 09:18:35 AM EST, Derek Atkins wrote: Hi, Fran_3 via gnucash-user writes: > Will assigning

[GNC] Does date order matter for Importing Checking Transactions?

2020-02-07 Thread Fran_3 via gnucash-user
Does date order matter when importing checking transactions? I'm guessing they are ordered by date in the Check Register view and not by the order in which they were entered or imported in the system... right? I'm asking because this next account I'll be working on has almost 2,00

[GNC] Problems importing American Express QFX files into GNUCash

2020-03-03 Thread Jonathan Bentz
I'm running GNUCash 3.8 and was manually importing my credit card statements yesterday via QFX and when I tried to import a QFX file from AMEX, it was blank. I have successfully imported QFX files from AMEX for a few years now and as recently as December of 2019 I have never encountered thi

[GNC] Missing Bank Interest Transactions When Importing with QFX

2020-04-27 Thread Keith Fetterman
When I import the transactions from my bank using QFX, the small interest transactions are not appearing in the import screen? The amounts are usually less than a $1 dollar. Does anyone know why this is? Is there a threshold somewhere that might be filtering them out? I discovered it with Gn

[GNC] Convincing my credit union to support online importing

2018-04-19 Thread Jeff Albrecht
Here in Arizona, USA Tuesday I attend the annual meeting of my credit union. I met with the Senior VP / Chief Information officer. We spoke about Quicken and it's rapid price hikes and move to subscription model. I told him a bit about GnuCash and that I had just converted to GnuCash and had im

[GNC] Need User friendly guide to importing qfx file

2018-05-16 Thread eNews
Hello! I am new to GnuCash and attempted my first import of a qfx file from my bank. When I import the file, the "Generic import transaction matcher" is blank/empty. Although I've researched the answers to similar questions, I do not understand the technical answers to them. The closest I ca

[GNC] Need User friendly guide to importing qfx file

2018-05-17 Thread BC
I'm using v3.1 and OFX import works on Windows10. ___ 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 Nabble or Gmane,

Re: [GNC] Transaction matcher window blank when importing QFX

2018-07-10 Thread Bo Laurent
Whoops; never mind. I now see that the import was successful, but I didn't notice that. I was apparently trying to re-import, and gnucash successfully noticed that all the transactions had already been imported. Bo ___ gnucash-user mailing list gnucash-u

[GNC] Gnucash unresponsive when importing large Bills & Invoices file

2018-07-23 Thread Nelson Handcock
Hello All, This is not reported as a bug (yet) but will do so if initial responses suggest it's warranted. I'm running Gnucash Version 3.1 I prepared a csv file to import a number of invoices - about 900 or so. The spreadsheet file contained about 1300 rows. Some invoices are multi-item - I've

[GNC] New GnuCash file and importing Chart of Accounts

2023-04-11 Thread Jay Bouxsein
At the outset, I must confess that I am a senior who increasingly has difficulties using complicated software products, especially accounting products because I do not have detailed accounting knowledge but I do know the basics. I have worked with my accountant to use GnuCash to assist him in prepa

[GNC] Issues Recognizing Account Names When Importing CSV into GnuCash

2023-10-06 Thread Gio Bacareza
I'm experiencing difficulties when importing a CSV file into GnuCash, particularly when the file contains both "Account" and "Target Account" columns. Despite meticulously encoding the account names in the CSV to match the exact account names as they appear in GnuCash

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

2024-05-10 Thread sunfish62--- via gnucash-user
Of course there is. The csv importer can handle any price data, including historical data, as long as you supply the proper dates along with the other data elements. The challenge is gathering that price data in the first place. It used to be possible to retrieve unlimited price quotes from a

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

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

[GNC] tool to translate csv files for gnucash invoice importing

2022-09-18 Thread Blake Hannaford
https://github.com/blake5634/csv2gnucash-importer -- Blake Hannaford -- ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Pleas

[GNC] Crash when importing OFX file from Bank of America

2022-10-01 Thread William Starrs
Hello all, I have been downloading and importing OFX (QFX) files from BofA nightly for many years. Starting a few days ago, it crashes when attempting. This is for a checking account. I do the same for Chase and Amex Credit Cards without issue. Here is what I see in the terminal

[GNC] Importing Multiple Accounts in a single OFX/QFX file

2021-08-09 Thread Chris Good
Hi, Re https://bugs.gnucash.org/show_bug.cgi?id=105334#c13 import multiple account OFX files with transfers between the accounts, duplicate transactions are generated The problem is that when you import OFX transactions for 2 bank accounts from the same file, if there is a t

Re: [GNC] GC Importing GC Export Format - too many credits

2019-10-08 Thread David Cousens
orted it. On reimporting it created a miscellaneous transaction to the imbalance account for 3.45. The price on export was 14+17238/34483 but when reimported the price is recorded as 13+17238/34483 accounting for this difference. This appears to be some problem with importing prices expressed as a

Re: [GNC] GC Importing GC Export Format - too many credits

2019-10-08 Thread David Cousens
That's good . I will add the description of the issues I observed to one or the other of your bug reports and cross reference them. I suspect the issues are all related. AFAIK the CSV importer was rewritten for the late v2.7 and early 3.x versions and possible only received testing for the straight

Re: [GNC] Importing a CSV with transactions in another currency

2019-10-11 Thread David Cousens
There is really no way GnuCash can do that at least at the moment. The easiest way to achieve it would be to use the multiline multisplit import mode and prior to import into GnuCash import the data into a spreadsheet and add the additional information in a Rate/Price column for each split. If y

Re: [GNC] Importing a CSV with transactions in another currency

2019-10-19 Thread boldstripe
Thanks to Yoman and David. This seems to be a difficult problem to fix. Just to clarify the need for this: if you trade and/or live in two different countries, you need to be able to report worldwide income/expenses in both currencies. Ideally, to do this, the user could: - import CSV in either

Re: [GNC] Importing a CSV with transactions in another currency

2019-12-19 Thread boldstripe
In the end I could not import either CSV or OFX/QFX from one currency to another in Gnucash. I have since given up the goal of a single 'worldwide' Gnucash file, choosing instead to run two (in my case) national files, one based in each currency. That way, OFX imports work well, and scheduling, bud

Re: [GNC] Importing bank transactions B4 posting bills & Invoices - question

2020-02-03 Thread Adrien Monteleone
invoices/bills reflects the real world transaction and not the date you happen to enter them in GnuCash or else down the road you’ll have a hard time tracing an error or when otherwise investigating something. You can certainly do the data entry out of order though. (such as importing payments

Re: [GNC] Importing bank transactions B4 posting bills & Invoices - question

2020-02-03 Thread Fran_3 via gnucash-user
clicking the $99 transaction in the Unassigned Expense account but no option to Apply As Payment. Maybe I didn't do the test correctly. Maybe importing a CSV file puts the items elsewhere in the system. Thanks if you can give me some additional guidance. On Monday, February 3, 2020, 11:41:

Re: [GNC] Importing bank transactions B4 posting bills & Invoices - question

2020-02-03 Thread Fran_3 via gnucash-user
ion to Apply As Payment. Maybe I didn't do the test correctly. Maybe importing a CSV file puts the items elsewhere in the system. Thanks if you can give me some additional guidance.     On Monday, February 3, 2020, 11:41:40 AM EST, Adrien Monteleone wrote:  If those previously impor

Re: [GNC] Does date order matter for Importing Checking Transactions?

2020-02-07 Thread David Carlson
ser@gnucash.org> wrote: > Does date order matter when importing checking transactions? > I'm guessing they are ordered by date in the Check Register view and not > by the order in which they were entered or imported in the system... right? > I'm asking because this next account I

Re: [GNC] Does date order matter for Importing Checking Transactions?

2020-02-07 Thread David Cousens
Fran, The date shouldn't matter but having them date ordered can help when sorting out any problems (easier to locate in the data file). David Carlson's reason for suggesting importing in small batches initially are twofold. 1. The importer has a Bayesian matcher which will automatic

Re: [GNC] Does date order matter for Importing Checking Transactions?

2020-02-07 Thread Fran_3 via gnucash-user
Thank you David. Good info. FYI, I'm importing checking transactions which I downloaded a csv file from the bank, imported into Google Sheets I re-formatted the columns to have the following... Date, Num, Description, Deposit, Withdrawal I then exported this from Google Sheets to a csv fil

Re: [GNC] Does date order matter for Importing Checking Transactions?

2020-02-07 Thread David Cousens
Fran "That brings up another question... is there anyway in GC to assign multiple checking transactions at once to a single expense account?" Yes there is. In the import matcher window you can multiply select the transactions you want to assign to a given transfer account (click on them while hol

Re: [GNC] Does date order matter for Importing Checking Transactions?

2020-02-07 Thread Fran_3 via gnucash-user
Thank you David! Now I know how to assign multiple checking transactions at once. Great tip. And "Roger That" on debit/credit description fields. Very long & often very confusing. Thanks again. On Friday, February 7, 2020, 04:49:37 PM EST, David Cousens wrote: Fran "That brings up an

Re: [GNC] Problems importing American Express QFX files into GNUCash

2020-03-03 Thread David Reiser via gnucash-user
> On Mar 3, 2020, at 4:14 PM, Jonathan Bentz wrote: > > I'm running GNUCash 3.8 and was manually importing my credit card > statements yesterday via QFX and when I tried to import a QFX file from > AMEX, it was blank. I have successfully imported QFX files from AMEX for a

Re: [GNC] Problems importing American Express QFX files into GNUCash

2020-03-03 Thread Jonathan Bentz
Does this also apply to offline importing? I'm just downloading the transactions locally then importing them, not connected directly via the online banking tools.Thanks. On Tue, Mar 3, 2020 at 4:47 PM David Reiser wrote: > > > On Mar 3, 2020, at 4:14 PM, Jonathan Bentz wrot

Re: [GNC] Problems importing American Express QFX files into GNUCash

2020-03-03 Thread Greg Feneis
3, 2020, 15:10 Jonathan Bentz wrote: > Does this also apply to offline importing? > > I'm just downloading the transactions locally then importing them, not > connected directly via the online banking tools.Thanks. > > On Tue, Mar 3, 2020 at 4:47 PM David Reiser wrote:

Re: [GNC] Missing Bank Interest Transactions When Importing with QFX

2020-04-27 Thread Chris Good
Message: 2 Date: Mon, 27 Apr 2020 18:51:41 -0700 From: Keith Fetterman To: GnuCash users group Subject: [GNC] Missing Bank Interest Transactions When Importing with QFX Message-ID: <5fc46e9e-f08a-4ba1-b13e-0dad30c1f...@gmail.com> Content-Type: text/plain; charset=us-ascii

Re: [GNC] Missing Bank Interest Transactions When Importing with QFX

2020-04-28 Thread Keith Fetterman
PM, Chris Good wrote: > > Message: 2 > Date: Mon, 27 Apr 2020 18:51:41 -0700 > From: Keith Fetterman > To: GnuCash users group > Subject: [GNC] Missing Bank Interest Transactions When Importing with > QFX > Message-ID: <5fc46e9e-f08a-4ba1-b13e-0dad30c1f...@gmail.c

Re: [GNC] Need User friendly guide to importing qfx file

2018-05-17 Thread Dennis Powless
Is qfx the only output/export you get from your bank? If you can try ofx or try to do the export again, change the parameters on the export ie dates. Make sure you’re in the account you’re importing to, ie that register is open. Dennis Sent from my iPhone > On May 16, 2018, at 4

Re: [GNC] Need User friendly guide to importing qfx file

2018-05-17 Thread David Carlson
can try > ofx or try to do the export again, change the parameters on the export > ie dates. Make sure you’re in the account you’re importing to, ie that > register is open. > > Dennis > > Sent from my iPhone > > > On May 16, 2018, at 4:18 PM, eNews wrote: > &

Re: [GNC] Need User friendly guide to importing qfx file

2018-05-17 Thread D via gnucash-user
o the export again, change the parameters on the export ie dates. Make sure you’re in the account you’re importing to, ie that register is open. Dennis Sent from my iPhone > On May 16, 2018, at 4:18 PM, eNews wrote: > > Hello! > > > > I am new to GnuCash and attempte

[GNC] Problems importing credit card transactions via CSV formatted file.

2018-06-13 Thread John Clark via gnucash-user
One of the problems I’ve found with gnucash is in the area of importing CSV formatted transactions. I figured out how to do it reasonably well for my bank statements, and now I’m turning my attention to my credit card accounts. I’m trying to enter in data that spans several years, and I have a

[GNC] Importing QIF from Quicken to set up new file

2018-10-14 Thread Tom Goodhart
When I am in the middle of the Import QIF process, the window that lists each security and asks for info for each is so long that I can't see the buttons for Next, etc at the bottom of the window and I cannot scroll down. What is the default response or how can I see the bottom of the window? Are

Re: [GNC] New GnuCash file and importing Chart of Accounts

2023-04-11 Thread Stan Brown (using GC 2.6.19)
On 2023-04-11 15:50, Jay Bouxsein wrote: > I am running version 2.6.7. Wow! That's older even than my version, 2.6.19. > I have worked with my accountant to use GnuCash to assist him in > preparing end of year tax returns and he has suggested that I open > new books at the beginning of each ne

Re: [GNC] New GnuCash file and importing Chart of Accounts

2023-04-11 Thread Michael or Penny Novack
5. Enter a transaction to make all the starting balances in the new file match the ending balances from the old file, referring to the report you saved in step 1. Yes, you could use a single, massive transaction split on both the debit and credit side. Or you could use two massive transacti

Re: [GNC] Issues Recognizing Account Names When Importing CSV into GnuCash

2023-10-07 Thread Adrien Monteleone
On 10/7/23 12:01 AM, Gio Bacareza wrote: I'm experiencing difficulties when importing a CSV file into GnuCash, particularly when the file contains both "Account" and "Target Account" columns. Despite meticulously encoding the account names in the CSV to match the exact acco

Re: [GNC] Issues Recognizing Account Names When Importing CSV into GnuCash

2023-10-09 Thread Gio Bacareza
rt chunks. You don't want to have to > manually assign those in a large quantity in a single pass. > > Regards, > Adrien > > On 10/7/23 12:01 AM, Gio Bacareza wrote: > > I'm experiencing difficulties when importing a CSV file into GnuCash, > > particular

Re: [GNC] Crash when importing OFX file from Bank of America

2022-10-01 Thread john
> On Oct 1, 2022, at 8:26 AM, William Starrs wrote: > > Hello all, > > I have been downloading and importing OFX (QFX) files from BofA nightly for > many years. Starting a few days ago, it crashes when attempting. This is > for a checking account. > > I do

Re: [GNC] Crash when importing OFX file from Bank of America

2022-10-01 Thread William Starrs
, at 8:26 AM, William Starrs wrote: > > Hello all, > > I have been downloading and importing OFX (QFX) files from BofA nightly for > many years. Starting a few days ago, it crashes when attempting. This is > for a checking account. > > I do the same for Chase and Amex Credit

Re: [GNC] Importing Multiple Accounts in a single OFX/QFX file

2021-08-10 Thread David Carlson
While the files that I import from my bank have content that I want to retain in both sides of the duplicated transactions other use cases probably differ. I expect that this solution would work for some users and I would prefer to keep the multiple source accounts separated during the import proc

[GNC] My experience importing 19 years of Quicken data into GnuCash

2019-04-02 Thread no_more_quicken
I've been diligently tracking my personal finances since early 2000. I started with MS Money, then reluctantly switched to Quicken when Money was discontinued. I LOVED MS Money, but I've never really been happy with Quicken. It's hard to pinpoint exaclty why, but some combination of the clunky UI,

[GNC] GnuCash 3.1-3 freezes when importing OFX file on Mac

2018-06-10 Thread Brendan Simon
I just tried GnuCash 3.1-3 on Mac, and it freezes when trying to import a small OFX file (downloaded from my bank).  The cursor just turns into a spinning beach ball and the app otherwise doesn't respond. The OFX file imports just fine with GnuCash-2.6.21-2. The OFX file comes from an Australian

Re: [GNC] Problems importing credit card transactions via CSV formatted file.

2018-06-13 Thread David Carlson
ols> which includes a CSV to QIF converter which you might find useful. David C On Wed, Jun 13, 2018 at 2:14 PM, John Clark via gnucash-user < gnucash-user@gnucash.org> wrote: > One of the problems I’ve found with gnucash is in the area of importing > CSV formatted transactions. I fig

Re: [GNC] Importing QIF from Quicken to set up new file

2018-10-15 Thread Liz
On Fri, 12 Oct 2018 12:52:37 -0500 Tom Goodhart wrote: > When I am in the middle of the Import QIF process, the window that > lists each security and asks for info for each is so long that I > can't see the buttons for Next, etc at the bottom of the window and I > cannot scroll down. What is the

Re: [GNC] Importing QIF from Quicken to set up new file

2018-10-15 Thread Adrien Monteleone
Macs used to be limited (at least as of Snow Leopard) to only re-sizing windows via the bottom right corner’s drag handle. I don’t recall when that changed, but certainly on High Sierra (I’m using it as well) you can hover over any window side at any point, the pointer will change to an arrow o

[GNC] Exporting and Importing CSV Transactions from One Book to Another

2018-10-15 Thread Scales Office
ght maybe it was just a lot to load so I waited a long time but it didn't work and I tried multiple times. Would you be able to give me a step by step how to for exporting and importing transactions from one book to another? Thank you in advance for your help, Melissa

Re: [GNC] My experience importing 19 years of Quicken data into GnuCash

2019-04-02 Thread Adrien Monteleone
> On Apr 2, 2019, at 11:59 AM, no_more_quicken wrote: > > > 5. I still haven't quite figured out the reporting framework; my goal is to > generate an "expenses over the last X months grouped by month" report (i.e., > just like the "Expense Over Time" built-in chart, but in a table format with >

Re: [GNC] My experience importing 19 years of Quicken data into GnuCash

2019-04-02 Thread Cricket Onebit
Thanks for this. I have a similar project in the near future, and was wondering the best order for some things. It looks like the major re-categorization should be done before leaving Quicken. Good to know there's a workaround for the HiDPI bug. Is there a bug report / feature request for bulk a

Re: [GNC] My experience importing 19 years of Quicken data into GnuCash

2019-04-02 Thread no_more_quicken
Cricket Onebit wrote > Can you explain more about not being able to undo things with the SQL > backend vs XML (or point to more details)? I'm undecided about which > backend. Fully-functional and easy to install and maintain is more > important to me than a few seconds while using, unless those sec

Re: [GNC] My experience importing 19 years of Quicken data into GnuCash

2019-04-02 Thread no_more_quicken
Adrien Monteleone-2 wrote >> On Apr 2, 2019, at 11:59 AM, no_more_quicken < > nospam@ > > wrote: >> >> >> 5. I still haven't quite figured out the reporting framework; my goal is >> to >> generate an "expenses over the last X months grouped by month" report >> (i.e., >> just like the "Expense O

<    1   2   3   4   5   6   7   >