Re: [GNC] importing or pasting reports into spreadsheets

2024-04-14 Thread Chris Skudder
GnuCash 5.4 flatpak, LibreOffice 7.3.7.2) On 4/14/24 02:01, gnucash-user-requ...@gnucash.org wrote: Date: Sat, 13 Apr 2024 20:53:32 -0500 From: David Carlson To: "gnucash-user@gnucash.org" Subject: [GNC] importing

Re: [GNC] importing or pasting reports into spreadsheets

2024-04-14 Thread Maria Inmaculada de la Torre
Hello David, I do the same for my reports but paste it into Excel and whenever I had that issue I either use powerquery for the clean up or more quick and dirty approach of using functions to extract the correct figures, some MID/RIGHT function, within the CLEAN one wrapping the result and if you

Re: [GNC] importing or pasting reports into spreadsheets

2024-04-13 Thread Alan Hopkins
Hi David When you paste into Calc (I'll assume you are using Ctrl-v), you should get an Import options screen pop up in which you can tick a box "Detect special numbers (such as dates). I find this works for me (using different versions of Linux on differing hardware) I hope that helps! Cheers

[GNC] importing or pasting reports into spreadsheets

2024-04-13 Thread David Carlson
I have found that I can select the text of reports directly in GnuCash, then paste it into a Libre Office Calc spreadsheet. The problem then is that values are preceded with a dollar sign in the US and it seems that they are not currency numbers but some form of text, as numeric operators do not

Re: [GNC] View Transactions After Importing from CSV

2024-04-04 Thread Tom Balazs
very import. Note that if a transaction is matched >> incorrectly, you >> >> can check either 'U+C' or 'C" and then double clicking on it will >> bring up >> >> another dialogue box with a list of transactions it believe matches or >> are >> >> sim

Re: [GNC] View Transactions After Importing from CSV

2024-04-04 Thread Christopher Lam
s matched incorrectly, > you > >> can check either 'U+C' or 'C" and then double clicking on it will bring > up > >> another dialogue box with a list of transactions it believe matches or > are > >> similar from which you can select on that it should match with. > >> > >

Re: [GNC] View Transactions After Importing from CSV

2024-04-04 Thread Tom Balazs
er 'U+C' or 'C" and then double clicking on it will bring up >> another dialogue box with a list of transactions it believe matches or are >> similar from which you can select on that it should match with. >> >> -Original Message- >> From: Tom Balazs >>

Re: [GNC] View Transactions After Importing from CSV

2024-04-02 Thread Tom Balazs
hed incorrectly, >> you >> > can check either 'U+C' or 'C" and then double clicking on it will bring >> up >> > another dialogue box with a list of transactions it believe matches or >> are >> > similar from which you can select on that it should

Re: [GNC] View Transactions After Importing from CSV

2024-04-02 Thread David Carlson
t should match with. > > > > -Original Message- > > From: Tom Balazs > > Sent: Friday, December 22, 2023 7:02 AM > > To: Post to GnuCash User > > Subject: [GNC] View Transactions After Importing from CSV > > > > I'm using Financisto+ on

Re: [GNC] Segmentation fault while importing invoice data

2024-04-02 Thread Emir Herrera
Thanks a lot! I've been able to fix the issue by debugging it. Turns out missing fields like: date, notes, and date_posted make validations crash when they are null and that's the segmentation fault origin. I'll fill the bug report later, but I hope this helps others while validations are fixed

Re: [GNC] View Transactions After Importing from CSV

2024-04-02 Thread Tom Balazs
another dialogue box with a list of transactions it believe matches or are > similar from which you can select on that it should match with. > > -Original Message- > From: Tom Balazs > Sent: Friday, December 22, 2023 7:02 AM > To: Post to GnuCash User > Subject: [GNC] View Transacti

Re: [GNC] Segmentation fault while importing invoice data

2024-03-30 Thread Adrien Monteleone
See the wiki about crashes and bug reports. Take a look there as well about getting a Tracefile, then file a bug with the crash report and tracefile as attachments. (The Tracefile may or may not contain relevant info) You don't mention your OS by the way. Regards, Adrien On 3/30/24 10:56

[GNC] Segmentation fault while importing invoice data

2024-03-30 Thread Emir Herrera
Hello everyone. So, I'm trying to load some billing data from Google Cloud into GNUCash. I had made a script to get the data and parse it into a CSV. based on the documentation ( https://code.gnucash.org/docs/C/gnucash-guide/import-invoices.html) I have formatted it like this:

Re: [GNC] Importing Reports into LO Calc

2024-03-09 Thread Adrien Monteleone
You can certainly set that as a style in Calc. Regards, Adrien On 3/9/24 9:01 PM, Robert Heller wrote: I think the OP's issue is the fact that Calc does not preserve the red coloring of the negative numbers. The red coloring of the negative numbers is something *GnuCash* is doing as a "good

Re: [GNC] Importing Reports into LO Calc

2024-03-09 Thread David H
Hi Robert, If I copy and paste a Gnucash report directly into LibreOffice Calc (version 7.6.4.1 on Win10) everything is black as expected except for the negative numbers that are red which is what I also expected to happen ? Not sure what's happening with OP's calc. Cheers David H. On Sun, 10

Re: [GNC] Importing Reports into LO Calc

2024-03-09 Thread Robert Heller
I think the OP's issue is the fact that Calc does not preserve the red coloring of the negative numbers. The red coloring of the negative numbers is something *GnuCash* is doing as a "good accounting practice", but the Calc is not doing. At Sat, 9 Mar 2024 18:13:04 -0600

Re: [GNC] Importing Reports into LO Calc

2024-03-09 Thread Adrien Monteleone
1. Export Report 2. Open Calc 3. Open the report file in Calc. Result is the report imported into cells based on the html table. or 1. Export Report 2. Open Calc 3. Click 'Sheet' Menu, then 'Insert Sheet from file...' and select the exported report file. Answer the dialogs, result is same as

Re: [GNC] Importing Reports into LO Calc

2024-03-09 Thread Abe Sternberg
Thanks.  It may be best if I start this thread again.  I sincerely appreciate your taking the time to get me knowledgeable. Abe On 3/9/2024 15:35, David H wrote: Abe, You can't include/paste pictures inline on the Gnucash mailing list so they didn't show up :-(  You have to either save each

Re: [GNC] Importing Reports into LO Calc

2024-03-09 Thread David Cousens
Abe, The default colors which come up in Calc are going to depend upon its preference settings and any formatting already set in Calc before importing. GnuCash has no control over that. Cal's cell "currency" setting has the option of negative numbers appearing in red. If you format

Re: [GNC] Importing Reports into LO Calc

2024-03-09 Thread David H
Abe, You can't include/paste pictures inline on the Gnucash mailing list so they didn't show up :-( You have to either save each pic as a file and attach them to your email or I've found that you can get away with pasting 1 pic as the very last thing in your email and it makes it. Cheers David

Re: [GNC] Importing Reports into LO Calc

2024-03-09 Thread Robert Heller
At Sat, 9 Mar 2024 11:41:31 -0500 Abe Sternberg wrote: > > I guess I am a bit dense - old age will do that to you.  Let me try and > be a bit more specific on my actions and the errors I get. Below is a > screenshot of a budget performance report in GnuCash. > > > > Next, I export it to

Re: [GNC] Importing Reports into LO Calc

2024-03-09 Thread Abe Sternberg
I guess I am a bit dense - old age will do that to you.  Let me try and be a bit more specific on my actions and the errors I get. Below is a screenshot of a budget performance report in GnuCash. Next, I export it to the folder I want it in and open it in Calc. The file opens in a browser

Re: [GNC] Importing Reports into LO Calc

2024-03-08 Thread Adrien Monteleone
Abe, next time, please start a new thread by sending a new message to the list rather than replying to someone else's. As for how to get reports into Calc, I usually copy/paste, but you can also just 'open' the exported report, or you can 'insert sheet from file' into an existing workbook.

[GNC] Importing Reports into LO Calc

2024-03-08 Thread Abe Sternberg
After a long hiatus from GnuCash and preparing reports, I find that I am back in that business.  The good news is that I am good to go on getting my reports structured the way I want. The bad news is that now I can't figure out how to import the HTML report into Calc.  I have tried everything

Re: [GNC] Trouble importing bills via csv

2024-02-26 Thread Adrien Monteleone
Yes, if your field contains the separator character you should double-quote it, but *only* in that case. Id's, dates, et cetera will not, so no reason to quote them. The OP had quotes on most if not all fields and none of them were necessary. Regards, Adrien On 2/26/24 8:23 AM, Kalpesh Patel

Re: [GNC] Trouble importing bills via csv

2024-02-26 Thread Kalpesh Patel
. -Original Message- From: David H Sent: Saturday, February 24, 2024 7:02 PM To: Alan Johnson Cc: Adrien Monteleone ; gnucash-u...@lists.gnucash.org Subject: Re: [GNC] Trouble importing bills via csv Alan, Your file imports fine here after I add the vendor, create the Accounts Payable

Re: [GNC] Trouble importing bills via csv

2024-02-24 Thread David H
+1000, David H wrote: > > > Alan, > > > > > > Your file imports fine here after I add the vendor, create the > > > Accounts Payable liability, remove the header line and remove the > > > double quotes that you have plastered around every field for s

Re: [GNC] Trouble importing bills via csv

2024-02-24 Thread Alan Johnson via gnucash-user
; reason which probably causes the other errors. > > > > It might pay to read up on Gnucash Bills Importing > > at  > > https://gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html > >  and the examples therein :- > > > > You'll no

Re: [GNC] Trouble importing bills via csv

2024-02-24 Thread David H
ield for some reason which probably causes > the other errors. > > It might pay to read up on Gnucash Bills Importing at > https://gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html and > the examples therein :- > > You'll note a complete absence of double

Re: [GNC] Trouble importing bills via csv

2024-02-24 Thread Alan Johnson via gnucash-user
le liability, remove the header line and remove the > double quotes that you have plastered around every field for some > reason which probably causes the other errors. > > It might pay to read up on Gnucash Bills Importing > at  > https://gnucash.org/docs/v5/C/gnucash-guide/

Re: [GNC] Trouble importing bills via csv

2024-02-24 Thread Adrien Monteleone
Bills Importing at https://gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html and the examples therein :- You'll note a complete absence of double quotes in the following example and no header line. ___ gnucash-user mailing list gnucash-user

Re: [GNC] Trouble importing bills via csv

2024-02-24 Thread David H
Importing at https://gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html and the examples therein :- You'll note a complete absence of double quotes in the following example and no header line. Hope this helps, Cheers David H. Note on double quotes If you use the field separator

Re: [GNC] Trouble importing bills via csv

2024-02-24 Thread Alan Johnson via gnucash-user
> > On 2/24/24 10:15 AM, Alan Johnson via gnucash-user wrote: >> Hello, >> I'm having some issues importing a bill via CSV. I set up a trial run >> and I'm getting the below errors.  Vendor "05" does not exist, >> however that is the vendor ID for Amazon in my f

Re: [GNC] Trouble importing bills via csv

2024-02-24 Thread Adrien Monteleone
10:15 AM, Alan Johnson via gnucash-user wrote: Hello, I'm having some issues importing a bill via CSV. I set up a trial run and I'm getting the below errors.  Vendor "05" does not exist, however that is the vendor ID for Amazon in my file.  It says account "Liabilities:Account

[GNC] Issues importing transactions (not matching)

2024-02-04 Thread Alan Johnson via gnucash-user
Hello, I'm attempting to import transactions from a credit card QFX file / Quicken format.   I have the pre-entered transaction as 'LEGO' in the amount of 45.14.  The imported transaction is "LEGO Enfeild CT" in the amount of 45.14.  Gnucash thinks these are not the same - and there are a

Re: [GNC] Importing from one gnucash file to another

2024-01-16 Thread John Ralls
ien > > On 1/16/24 5:16 AM, David H wrote: >> James, >> I may be mis-remembering but I seem to recall when importing txns some time >> ago there was a checkbox or option to specify the file to be imported was >> in Gnucash format ? Do you see this? Have you selected i

Re: [GNC] Importing from one gnucash file to another

2024-01-16 Thread Adrien Monteleone
I've never used it myself, but I recall a discussion when the feature was added, I think for 4.x but it could have been earlier. Regards, Adrien On 1/16/24 5:16 AM, David H wrote: James, I may be mis-remembering but I seem to recall when importing txns some time ago there was a checkbox

Re: [GNC] Importing from one gnucash file to another

2024-01-16 Thread David H
James, I may be mis-remembering but I seem to recall when importing txns some time ago there was a checkbox or option to specify the file to be imported was in Gnucash format ? Do you see this? Have you selected it ? Regards David H. On Tue, 16 Jan 2024 at 06:33, James Wilde wrote: > I

Re: [GNC] Importing from one gnucash file to another

2024-01-15 Thread Jim DeLaHunt
James: On 2024-01-15 03:59, James Wilde wrote: I am rationalising my accounting in Gnucash and have previously had one instance of Gnucash for each year.  I now would like to load an [earlier year's data] into the current year.  I have exported the earlier year as a csv file (I have used

[GNC] Importing from one gnucash file to another

2024-01-15 Thread James Wilde
I am rationalising my accounting in Gnucash and have previously had one instance of Gnucash for each year.  I now would like to load an eyara into the current year.  I have exported the earlier year as a csv file (I have used semi-colons instead of commas) but when I go to the current year to

Re: [GNC] View Transactions After Importing from CSV

2023-12-22 Thread Kalpesh Patel
After Importing from CSV I'm using Financisto+ on my Android phone. So I am often exporting transactions from that, and importing them into GnuCash. Is there an option where I can view the transactions I just imported? So they appear on one page, as if I did a Find in GnuCash. I think I came a

[GNC] View Transactions After Importing from CSV

2023-12-22 Thread Tom Balazs
I'm using Financisto+ on my Android phone. So I am often exporting transactions from that, and importing them into GnuCash. Is there an option where I can view the transactions I just imported? So they appear on one page, as if I did a Find in GnuCash. I think I came across that once, but I can't

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

2023-10-09 Thread Gio Bacareza
unks. 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, > > particularly when the fil

Re: [GNC] Issues Importing a Large CSV with Multiple Accounts into GnuCash: Is Duplicated Transactions Normal?

2023-10-09 Thread Gio Bacareza
ther showing the cash account credit. > > > > I assumed that GnuCash’s import algorithm would recognize and eliminate > > these duplicate transactions during the import process as it typically > does > > with other duplicates. Unfortunately, my tests indicate that it

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

2023-10-07 Thread Adrien Monteleone
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 account names as th

Re: [GNC] Issues Importing a Large CSV with Multiple Accounts into GnuCash: Is Duplicated Transactions Normal?

2023-10-07 Thread Adrien Monteleone
GnuCash when importing a large CSV with multiple accounts? Any insights or solutions to prevent these duplicates would be greatly appreciated. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscrib

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

[GNC] Issues Importing a Large CSV with Multiple Accounts into GnuCash: Is Duplicated Transactions Normal?

2023-10-06 Thread Gio Bacareza
, or is this behavior expected from GnuCash when importing a large CSV with multiple accounts? Any insights or solutions to prevent these duplicates would be greatly appreciated. -- cheers, Gio ___ gnucash-user mailing list gnucash-user@gnucash.org To update

Re: [GNC] Importing stock prices from a CSV file

2023-10-02 Thread john
> On Oct 2, 2023, at 01:46, flywire wrote: > > While importing csv files is only really explained in the manual > (not the guide) in terms of transactions, there is a lot of supporting https://www.gnucash.org/docs/v5/C/gnucash-manual/trans-import.html#trans-import-csv > &

Re: [GNC] Importing stock prices from a CSV file

2023-10-02 Thread flywire
While importing csv files is only really explained in the manual https://www.gnucash.org/docs/v5/C/gnucash-manual/trans-import.html#trans-import-csv (not the guide) in terms of transactions, there is a lot of supporting information for the Price Import Assistant in https://www.gnucash.org/docs/v5

Re: [GNC] Importing stock prices from a CSV file

2023-10-01 Thread flywire
Can we focus this back on improving the clarity of the Price Import Assistant? The first page is essentially the full documentation of the process. https://github.com/Gnucash/gnucash/blob/5.4/gnucash/gtkbuilder/assistant-csv-price-import.glade#L55 uses the column labels: Date, Amount, From

Re: [GNC] Importing stock prices from a CSV file

2023-10-01 Thread Kalpesh Patel
' Cc: 'Gnucash Users' Subject: RE: [GNC] Importing stock prices from a CSV file Just to remove any confusion, the CSV format of the importing stock prices as of GNC v4.18 is as follows (which I don’t believe has changed in later and 5.x version)... "NAME_SPACE","TICKER_SYMB

Re: [GNC] Importing stock prices from a CSV file

2023-10-01 Thread Kalpesh Patel
Just to remove any confusion, the CSV format of the importing stock prices as of GNC v4.18 is as follows (which I don’t believe has changed in later and 5.x version)... "NAME_SPACE","TICKER_SYMBOL",date,"PRICE","QUOTE_CURRENCY" One line per record each f

Re: [GNC] Importing stock prices from a CSV file

2023-09-30 Thread flywire
Yes Ove, clearly there is more to it as demonstrated by your example. I can see the importer is using Commodity, Price Database uses Security, and Security Editor uses Namespace and Symbol. https://www.gnucash.org/docs/v5/C/gnucash-guide/gnc-gloss.html doesn't help much.

Re: [GNC] Importing stock prices from a CSV file

2023-09-30 Thread Ove Grunnér
Hi, if it helps, this is what an import file can look like when importing stock prices. the name space for stocks is the same name space you see in the security editor Menu -> Tools:Security Editor. So if you call the namespace for a stock e.g. NASDAQ when you create the st

Re: [GNC] Importing stock prices from a CSV file

2023-09-30 Thread flywire
The process works but the Price Import Assistant Summary description and poor user interface labels are confusing. I use csv import all the time but this is so bad I can't understand it. [the minimum columns] are Date, Amount, From Namespace, From Symbol and Currency To. If all entries are for

Re: [GNC] Importing stock prices from a CSV file

2023-09-29 Thread sunfish62--- via gnucash-user
I'll refer you to a process I sent in to the lists a while back. https://lists.gnucash.org/pipermail/gnucash-user/2018-August/079430.html ⁣David T. ​ On Sep 30, 2023, 1:38 AM, at 1:38 AM, flywire wrote: >I'll work with the Price Import Assistant druid. Is it actually >documented? >I found

Re: [GNC] Importing stock prices from a CSV file

2023-09-29 Thread Ken Farley
I'm not sure about the process. I'm led to believe it's built into GnuCash and relatively simple to use? Here's a past discussion prompted by someone having difficulties  and eventually figuring it out: https://lists.gnucash.org/pipermail/gnucash-user/2018-August/079372.html Hopefully this

Re: [GNC] Importing stock prices from a CSV file

2023-09-29 Thread brad
Here's a couple of examples: https://wiki.gnucash.org/wiki/Importing_fund_or_stock_prices_from_an_OFX_file https://wiki.gnucash.org/wiki/Stocks/get_prices On 9/29/23 16:33, flywire wrote: I'll work with the Price Import Assistant druid. Is it actually documented? I found

Re: [GNC] Importing stock prices from a CSV file

2023-09-29 Thread flywire
I'll work with the Price Import Assistant druid. Is it actually documented? I found https://wiki.gnucash.org/wiki/CSV_Import/Export#Importing_Prices > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to

[GNC] Importing stock prices from a CSV file

2023-09-29 Thread flywire
I have loaded my stock portfolio into GnuCash for tax reporting purposes. I'd like to update stock prices annually by importing the closing value for 30 June from a csv. Can someone give me a rundown on the required input and process? I'd be happy to add it to https://wiki.gnucash.org/wiki

Re: [GNC] Importing data from QuickBooks Online

2023-07-06 Thread Tom Olin via gnucash-user
gt;>>> c it works. So it seems to be related to either the inability to import >>>> reconciled flag or the flag is different, I am not sure. But that's where >>>> the problem is, something to do with the Y reconcile flag. >>>> >>>> Sincerel

Re: [GNC] Importing data from QuickBooks Online

2023-07-06 Thread Vincent Dawans
n >> that column while 2023 doesn't, and when I replace the 2022 Y entries with >> c it works. So it seems to be related to either the inability to import >> reconciled flag or the flag is different, I am not sure. But that's where >> the problem is, something to do with the Y

Re: [GNC] Importing data from QuickBooks Online

2023-07-05 Thread Tom Olin via gnucash-user
esn't, and when I replace the 2022 Y entries with c it >>> works. So it seems to be related to either the inability to import >>> reconciled flag or the flag is different, I am not sure. But that's where >>> the problem is, something to do with the Y reconcile flag. >>>

Re: [GNC] Importing data from QuickBooks Online

2023-07-04 Thread Vincent Dawans
led flag or the flag is different, I am not sure. But that's where > the problem is, something to do with the Y reconcile flag. > > Sincerely, > > Vincent Dawans > > On Mon, Jul 3, 2023 at 4:41 PM Tom Olin mailto:t...@tomolin.net >> wrote: > Vincent, > > Good sugg

Re: [GNC] Importing data from QuickBooks Online

2023-07-04 Thread Tom Olin via gnucash-user
; Vincent Dawans >> >> On Mon, Jul 3, 2023 at 4:41 PM Tom Olin > <mailto:t...@tomolin.net>> wrote: >> Vincent, >> >> Good suggestions. I’ve attached 2 files, 3 transactions each, for 2022 and >> 2023. Instructions for importing them are in the doc

Re: [GNC] Importing data from QuickBooks Online

2023-07-04 Thread Tom Olin via gnucash-user
ing to do with the Y reconcile flag. > > Sincerely, > > Vincent Dawans > > On Mon, Jul 3, 2023 at 4:41 PM Tom Olin <mailto:t...@tomolin.net>> wrote: > Vincent, > > Good suggestions. I’ve attached 2 files, 3 transactions each, for 2022 and > 2023. I

Re: [GNC] Importing data from QuickBooks Online

2023-07-03 Thread Vincent Dawans
o do with the Y reconcile flag. > > Sincerely, > > Vincent Dawans > > On Mon, Jul 3, 2023 at 4:41 PM Tom Olin wrote: > >> Vincent, >> >> Good suggestions. I’ve attached 2 files, 3 transactions each, for 2022 >> and 2023. Instructions for importing t

Re: [GNC] Importing data from QuickBooks Online

2023-07-03 Thread Vincent Dawans
for 2022 and > 2023. Instructions for importing them are in the documentation of the > script, latest version also attached. > > 2022 still fails, 2023 still works. Create the accounts as needed; there > are only a few. > > -- > Tom > > Money is created when banks loan

Re: [GNC] Importing data from QuickBooks Online

2023-07-03 Thread Tom Olin via gnucash-user
Vincent, Good suggestions. I’ve attached 2 files, 3 transactions each, for 2022 and 2023. Instructions for importing them are in the documentation of the script, latest version also attached. 2022 still fails, 2023 still works. Create the accounts as needed; there are only a few. -- Tom

Re: [GNC] Importing data from QuickBooks Online

2023-07-03 Thread Vincent Dawans
gnucash-user > On Behalf Of Tom Olin via gnucash-user > > Sent: Monday, July 3, 2023 1:55 PM > > To: Kalpesh Patel > > Cc: gnucash-user@gnucash.org > > Subject: Re: [GNC] Importing data from QuickBooks Online > > > > Good shot, but no, date formats are consis

Re: [GNC] Importing data from QuickBooks Online

2023-07-03 Thread Tom Olin via gnucash-user
On > Behalf Of Tom Olin via gnucash-user > Sent: Monday, July 3, 2023 1:55 PM > To: Kalpesh Patel > Cc: gnucash-user@gnucash.org > Subject: Re: [GNC] Importing data from QuickBooks Online > > Good shot, but no, date formats are consistent. > > -- > Tom > >

Re: [GNC] Importing data from QuickBooks Online

2023-07-03 Thread Tom Olin via gnucash-user
en > > -Original Message- > From: gnucash-user On > Behalf Of Tom Olin via gnucash-user > Sent: Monday, July 3, 2023 1:55 PM > To: Kalpesh Patel > Cc: gnucash-user@gnucash.org > Subject: Re: [GNC] Importing data from QuickBooks Online > > Good shot, but no, date f

Re: [GNC] Importing data from QuickBooks Online

2023-07-03 Thread Ken Pyzik
: gnucash-user On Behalf Of Tom Olin via gnucash-user Sent: Monday, July 3, 2023 1:55 PM To: Kalpesh Patel Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Importing data from QuickBooks Online Good shot, but no, date formats are consistent. -- Tom The federal government imposes a tax on you so YOU

Re: [GNC] Importing data from QuickBooks Online

2023-07-03 Thread Tom Olin via gnucash-user
To: Jean L > Cc: gnucash-user@gnucash.org > Subject: Re: [GNC] Importing data from QuickBooks Online > > Jean, > > Thanks for that. I did play with a few similar options but couldn’t get > anything to work easily. Some were aimed more at Quicken or QuickBooks > desk

Re: [GNC] Importing data from QuickBooks Online

2023-07-03 Thread Kalpesh Patel
, July 03, 2023 12:14 PM To: Jean L Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Importing data from QuickBooks Online Jean, Thanks for that. I did play with a few similar options but couldn’t get anything to work easily. Some were aimed more at Quicken or QuickBooks desktop instead

Re: [GNC] Importing data from QuickBooks Online

2023-07-03 Thread Tom Olin via gnucash-user
I tried changing one of the transactions in the 2022 >>>> import file to 2023. It still failed the same way. >>>> >>>> — >>>> Tom >>>> >>>>> On Jul 2, 2023, at 11:55 PM, Jim DeLaHunt wrote: >>>>>

Re: [GNC] Importing data from QuickBooks Online

2023-07-03 Thread David Reiser via gnucash-user
; >>>> On 2023-07-02 15:10, Tom Olin via gnucash-user wrote: >>>>> I’m attempting to import data from QuickBooks Online to GnuCash. I’ve >>>>> written an awk script which appears to work well except for one major >>>>> issue. >>>>

Re: [GNC] Importing data from QuickBooks Online

2023-07-03 Thread Tom Olin via gnucash-user
t; written an awk script which appears to work well except for one major >>>> issue. >>> >>> What format is the data which you export from Quickbooks Online? CSV (Comma >>> Separated Values text files with tabular data)? QFX (Quicken Financial >>&

Re: [GNC] Importing data from QuickBooks Online

2023-07-03 Thread Tom Olin via gnucash-user
pt for one major >>>> issue. >>> What format is the data which you export from Quickbooks Online? CSV (Comma >>> Separated Values text files with tabular data)? QFX (Quicken Financial >>> Exchange, similar to OFX)? >>> >>> What GnuCash ve

Re: [GNC] Importing data from QuickBooks Online

2023-07-03 Thread David Reiser via gnucash-user
d Values text files with tabular data)? QFX (Quicken Financial >> Exchange, similar to OFX)? >> >> What GnuCash version are you using? On what computer OS? >> >> What GnuCash sequence of actions do you use to import the data? >> >> >>> The data

Re: [GNC] Importing data from QuickBooks Online

2023-07-03 Thread Jean L
Online? CSV (Comma Separated Values text files with tabular data)? QFX (Quicken Financial Exchange, similar to OFX)? What GnuCash version are you using? On what computer OS? What GnuCash sequence of actions do you use to import the data? The data I’m importing spans the years 2022 and 2023

Re: [GNC] Importing data from QuickBooks Online

2023-07-02 Thread Jim DeLaHunt
Values text files with tabular data)? QFX (Quicken Financial Exchange, similar to OFX)? What GnuCash version are you using? On what computer OS? What GnuCash sequence of actions do you use to import the data? The data I’m importing spans the years 2022 and 2023. All 2023 transactions import

[GNC] Importing data from QuickBooks Online

2023-07-02 Thread Tom Olin via gnucash-user
I’m attempting to import data from QuickBooks Online to GnuCash. I’ve written an awk script which appears to work well except for one major issue. The data I’m importing spans the years 2022 and 2023. All 2023 transactions import cleanly, but all 2022 transactions import unbalanced, meaning I

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

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

[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

Re: [GNC] Importing QFX

2023-04-08 Thread R Losey
It's on holiday. :) It will be back. On Sat, Apr 8, 2023 at 10:31 AM Alan Schold via gnucash-user < gnucash-user@gnucash.org> wrote: > I just upgraded to 5.0 and now can no longer find the QFX choice under > Import. Where did it go? > > ___ >

Re: [GNC] Importing QFX

2023-04-08 Thread Gyle McCollam
nucash-user Sent: Saturday, April 8, 2023 11:30 AM To: GNU Cash User Subject: [GNC] Importing QFX I just upgraded to 5.0 and now can no longer find the QFX choice under Import. Where did it go? ___ gnucash-user mailing list gnucash-user@gnucash.org To

[GNC] Importing QFX

2023-04-08 Thread Alan Schold via gnucash-user
I just upgraded to 5.0 and now can no longer find the QFX choice under Import. Where did it go? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

Re: [GNC] Exporting from QuickBooks / Importing to GnuCash

2023-03-30 Thread john
According to https://quickbooks.intuit.com/learn-support/en-us/help-article/list-management/iif-overview-import-kit-sample-files-headers/L5CZIpJne_US_en_US IIF is a tab-separated-values format. You can import that with the CSV importer by setting the separator to Tab. Regards, John Ralls >

Re: [GNC] Exporting from QuickBooks / Importing to GnuCash

2023-03-30 Thread Chris Skudder
for money. IMHO. On 3/30/23 12:00, gnucash-user-requ...@gnucash.org wrote: Message: 4 Date: Thu, 30 Mar 2023 10:47:48 -0400 From: Richard Lindgren To: "gnucash-user@gnucash org" Subject: [GNC] Exporting from QuickBooks / Impor

[GNC] Exporting from QuickBooks / Importing to GnuCash

2023-03-30 Thread Richard Lindgren
I have been in contact with QuickBooks and they tell me that they only export IIF formatted files. As I look in GnuCash, I do not find where it will import the IIF files. Is there something that I am doing wrong or is there a work around to import my files from QuickBooks? I really need your help

Re: [GNC] importing

2023-02-18 Thread Adrien Monteleone
Gyle, You may be 'stuck' with having to just manually check those off during reconciliation this one time. They are already in your books, so the import failure is just a matter of auto-clearing them. It only takes a few seconds to either click them as cleared before reconciling or clicking

Re: [GNC] importing

2023-02-17 Thread Gyle McCollam
David T., Yes, it was a QFX file and the transactions had already been entered and I was importing the file to match and reconcile my credit card statement. The transactions on the statement were all dated 01/22/2023, while the transactions in my Gnu Cash file had transaction date from 09/2022

Re: [GNC] importing

2023-02-16 Thread David T. via gnucash-user
alf of ed...@billiau.net >Sent: Thursday, February 16, 2023 8:57 PM >To: gnucash-user@gnucash.org >Subject: Re: [GNC] importing > >On Thu, 16 Feb 2023 23:53:35 + >Gyle McCollam wrote: > >> I ran into a unique problem with a credit card import. I was buying >&

Re: [GNC] importing

2023-02-16 Thread Gyle McCollam
, Gyle McCollam Gyle McCollam gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email From: gnucash-user on behalf of ed...@billiau.net Sent: Thursday, February 16, 2023 8:57 PM To: gnucash-user@gnucash.org Subject: Re: [GNC] importing On T

Re: [GNC] importing

2023-02-16 Thread edodd
On Thu, 16 Feb 2023 23:53:35 + Gyle McCollam wrote: > I ran into a unique problem with a credit card import. I was buying > gas at a station using a mastercard. The transaction was on my > credit card as pending, but would disappear and not be on my bill. > This went on for 6 months, but

Re: [GNC] importing

2023-02-16 Thread David Carlson
Hopefully that is a problem caused by the import being based on posting dates rather than transaction dates. Then it should be possible to sort it out by looking at the monthly statement and manually changing the transaction dates if you want to go by transaction dates or as an alternate

[GNC] importing

2023-02-16 Thread Gyle McCollam
I ran into a unique problem with a credit card import. I was buying gas at a station using a mastercard. The transaction was on my credit card as pending, but would disappear and not be on my bill. This went on for 6 months, but they finally corrected the problem and billed me for the 6

  1   2   3   4   5   6   >