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

[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 "WebConnect", but I have been 
> using Wells Fargo "Direct Connect" for thirty years. "Direct Connect" allows 
> me to write checks and transfer funds from QuickBooks, but "OFX Import" does 
> not, which makes sense, because it is an import, not a dialog. 
> 
> I see that there is a way to send instruction to the bank and it is 
> AQBanking, which is an open source library that comes with GnuCash. I suspect 
> that AQBanking will be tricky to configure, so I'm looking for advice, 
> specifically advice on configuring AQBanking to run with Wells Fargo. 
> Reference to a specific AQBanking monograph for Wells Fargo would be 
> outstanding. 
> 
> Thanks for the help, 
> -- 
> Chris. 
I’m sorry to say that sending instructions via AQbanking will never happen. 
Even before Quicken (and even Intuit before them) started actively trying to 
deep six DirectConnect, it was highly impractical for anyone on the outside to 
handle sending instructions. The costs of gaining access to a DirectConnect 
test server made it unthinkable for an open source programmer to attempt to 
include sending instructions via DirectConnect. Add to that the fact that 
sending instructions essentially means moving money out of someone’s account, 
the risks to an independent developer become enormous.

All but 2 of my financial institutions have ceased supporting DirectConnect 
even for downloading transaction data. And one of them has crippled the content 
of the description field so badly that I’ve bailed to CSV. That leaves 1 out of 
what used to be 8 institutions that I could use with AQbanking. The end is near 
(though a few banks may hold out for a few more years).

--
Dave Reiser
dbrei...@icloud.com





___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Importing bank data, sending instructions.

[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 thirty years. "Direct Connect" allows me 
to write checks and transfer funds from QuickBooks, but "OFX Import" does not, 
which makes sense, because it is an import, not a dialog. 

I see that there is a way to send instruction to the bank and it is AQBanking, 
which is an open source library that comes with GnuCash. I suspect that 
AQBanking will be tricky to configure, so I'm looking for advice, specifically 
advice on configuring AQBanking to run with Wells Fargo. Reference to a 
specific AQBanking monograph for Wells Fargo would be outstanding. 

Thanks for the help, 
-- 
Chris. 

V:916.799.9461 
F:916.974.0428 
A: Because we read from top to bottom, left to right.
Q: > Why should I start my reply below the quoted text? 
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 prices to GnuCash in Windows

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 number of online sources, 
but those days are gone, sadly. 

At one point in the past, I used a perl module to retrieve monthly prices for 
all my commodities and put them into the GnuCash price history, but the module 
depended on Yahoo!, which no longer allows that level of data gathering. 

⁣David T.​

On May 10, 2024, 6:17 AM, at 6:17 AM, Leung Wing Cheong 
 wrote:
>Hi,
>Is there any way to import historical stock prices to GnuCash in 
>Windows?
>Thanks,
>Wing
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[sunfish62--- via gnucash-user]

Further to the point, I've used Google Sheets financial functions to retrieve 
stock prices pretty quickly. Those functions can pull prices for any given 
date, so you could set some dates and import them that way. It's not ideal, but 
it could get things done in a pinch. 

⁣David T. ​

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] Importing historical stock prices to GnuCash in
>Windows
>
>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 number of
>online sources, but those days are gone, sadly. 
>
>At one point in the past, I used a perl module to retrieve monthly
>prices for all my commodities and put them into the GnuCash price
>history, but the module depended on Yahoo!, which no longer allows that
>level of data gathering. 
>
>⁣David T.​
>
>On May 10, 2024, 6:17 AM, at 6:17 AM, Leung Wing Cheong
> wrote:
>>Hi,
>>Is there any way to import historical stock prices to GnuCash in 
>>Windows?
>>Thanks,
>>Wing
>>___
>>gnucash-user mailing list
>>gnucash-user@gnucash.org
>>To update your subscription preferences or to unsubscribe:
>>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>-
>>Please remember to CC this list on all your replies.
>>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 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 number of online sources, 
but those days are gone, sadly. 

At one point in the past, I used a perl module to retrieve monthly prices for 
all my commodities and put them into the GnuCash price history, but the module 
depended on Yahoo!, which no longer allows that level of data gathering. 

⁣David T.​

On May 10, 2024, 6:17 AM, at 6:17 AM, Leung Wing Cheong 
 wrote:
>Hi,
>Is there any way to import historical stock prices to GnuCash in 
>Windows?
>Thanks,
>Wing
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 number of online sources, 
but those days are gone, sadly. 

At one point in the past, I used a perl module to retrieve monthly prices for 
all my commodities and put them into the GnuCash price history, but the module 
depended on Yahoo!, which no longer allows that level of data gathering. 

⁣David T.​

On May 10, 2024, 6:17 AM, at 6:17 AM, Leung Wing Cheong 
 wrote:
>Hi,
>Is there any way to import historical stock prices to GnuCash in
>Windows?
>Thanks,
>Wing
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Importing historical stock prices to GnuCash in Windows

[Leung Wing Cheong]

Hi,
Is there any way to import historical stock prices to GnuCash in Windows?
Thanks,
Wing
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] importing or pasting reports into spreadsheets

[Chris Skudder]

I do this using the "Export" choice in GnuCash, saving the report as an 
html file on the desktop, then right-click + open with LibreOffice Calc.


In addition to what Hop said below about ticking the box for:
    "Detect special numbers (such as dates)" in the import ...

I also need to do this step:
- Select the entire column of numbers that aren't numerical values,
    by clicking on the letter at the column header)
- In the "Data" menu dropdown, select "Text to Columns", then click OK.

Hope that helps too.
Chris
(Xubuntu 22.04, Xfce desktop, 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 or pasting reports 
into spreadsheets 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 recognize them. It 
also looks like dates are in some form of text as they have a format 
code "@" whatever that means. I am not very proficient with these 
format issues. Does someone know of an elementary reference that is 
easier to understand than the spreadsheet help file? Just in case it 
makes a difference I am using GnuCash release 4.8 in Lubuntu 22.04 
with a LXQT desktop.
-- David Carlson -- Date: Sun, 14 Apr 2024 
12:20:35 +1000 From: Alan Hopkins  To: David 
Carlson  Cc: GnuCash users group 
 Subject: Re: [GNC] importing or pasting 
reports into spreadsheets 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 Hop

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] importing or pasting reports into spreadsheets

[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 still have
issues maybe using the VALUE formula to convert the final output (I would
try this one first as it might work out with the previous ones)

In any case I think not all the reports cause the issue of being pasted as
text, so maybe if you try to play with formatting options to number first
and set those setting by default in the file it might help you.


Thanking you.

Regards,


Inma

On Sun, 14 Apr 2024 at 02:54, David Carlson 
wrote:

> 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 recognize them.  It also looks like dates are in some form of text
> as they have a format code "@" whatever that means.
>
> I am not very proficient with these format issues.  Does someone know of an
> elementary reference that is easier to understand than the spreadsheet help
> file?
>
> Just in case it makes a difference I am using GnuCash release 4.8 in
> Lubuntu 22.04 with a LXQT desktop.
>
> --
> David Carlson
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] importing or pasting reports into spreadsheets

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

On Sun, 14 Apr 2024, 11:54 am David Carlson, 
wrote:

> 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 recognize them.  It also looks like dates are in some form of text
> as they have a format code "@" whatever that means.
>
> I am not very proficient with these format issues.  Does someone know of an
> elementary reference that is easier to understand than the spreadsheet help
> file?
>
> Just in case it makes a difference I am using GnuCash release 4.8 in
> Lubuntu 22.04 with a LXQT desktop.
>
> --
> David Carlson
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] importing or pasting reports into spreadsheets

[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 recognize them.  It also looks like dates are in some form of text
as they have a format code "@" whatever that means.

I am not very proficient with these format issues.  Does someone know of an
elementary reference that is easier to understand than the spreadsheet help
file?

Just in case it makes a difference I am using GnuCash release 4.8 in
Lubuntu 22.04 with a LXQT desktop.

-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing Reports into LO Calc

[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 accounting practice", but the Calc is
not doing.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing Reports into LO Calc

[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 Mar 2024 at 13:02, 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 accounting practice", but the Calc
> is
> not doing.
>
> At Sat, 9 Mar 2024 18:13:04 -0600 adrien.montele...@lusfiber.net wrote:
>
> >
> > 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 above.
> >
> > or
> >
> > 1. Run Report in GnuCash
> > 2. Select All
> > 3. Copy
> > 4. Open Calc
> > 5. Paste, result is same as above
> >
> > In none of these cases is a web browser involved. (save for the Webkit
> > rendering within GnuCash, if you want to be pedantic about browser
> engines)
> >
> > I just tried all three, and in each case, there is no change in font or
> > alignments.
> >
> > Perhaps your issues involve whatever intermediary (browser) you are
> > involving that is unnecessary.
> >
> > Regards,
> > Adrien
> >
> > On 3/9/24 10:41 AM, 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 the folder I want it in and open it in Calc. The
> > > file opens in a browser tab, and I cut and paste the data into Calc.
> > > Notice the different colors used.
> > >
> > >
> > >
> > > I wonder why the colors are there in the first place instead of the
> > > expected black.  The negative numbers being in red is good
> accounting
> > > practice.  Look at what happens when I copy them into Calc.ÂÂ
> Once again
> > > I get a shift in colors and the negative numbers are not in red and
> > > cannot be changed using cell format.  Is the problem in GnuCash or
> in Calc?
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
> >
>
> --
> Robert Heller -- Cell: 413-658-7953 GV: 978-633-5364
> Deepwoods Software-- Custom Software Services
> http://www.deepsoft.com/  -- Linux Administration Services
> hel...@deepsoft.com   -- Webhosting Services
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing Reports into LO Calc

[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 adrien.montele...@lusfiber.net wrote:

>
> 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 above.
>
> or
>
> 1. Run Report in GnuCash
> 2. Select All
> 3. Copy
> 4. Open Calc
> 5. Paste, result is same as above
>
> In none of these cases is a web browser involved. (save for the Webkit
> rendering within GnuCash, if you want to be pedantic about browser engines)
>
> I just tried all three, and in each case, there is no change in font or
> alignments.
>
> Perhaps your issues involve whatever intermediary (browser) you are
> involving that is unnecessary.
>
> Regards,
> Adrien
>
> On 3/9/24 10:41 AM, 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 the folder I want it in and open it in Calc. The
> > file opens in a browser tab, and I cut and paste the data into Calc.
> > Notice the different colors used.
> >
> >
> >
> > I wonder why the colors are there in the first place instead of the
> > expected black.  The negative numbers being in red is good accounting
> > practice.  Look at what happens when I copy them into Calc.  Once 
> > again
> > I get a shift in colors and the negative numbers are not in red and
> > cannot be changed using cell format.  Is the problem in GnuCash or in 
> > Calc?
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
>

--
Robert Heller -- Cell: 413-658-7953 GV: 978-633-5364
Deepwoods Software-- Custom Software Services
http://www.deepsoft.com/  -- Linux Administration Services
hel...@deepsoft.com   -- Webhosting Services

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing Reports into LO Calc

[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 above.


or

1. Run Report in GnuCash
2. Select All
3. Copy
4. Open Calc
5. Paste, result is same as above

In none of these cases is a web browser involved. (save for the Webkit 
rendering within GnuCash, if you want to be pedantic about browser engines)


I just tried all three, and in each case, there is no change in font or 
alignments.


Perhaps your issues involve whatever intermediary (browser) you are 
involving that is unnecessary.


Regards,
Adrien

On 3/9/24 10:41 AM, 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 the folder I want it in and open it in Calc. The 
file opens in a browser tab, and I cut and paste the data into Calc. 
Notice the different colors used.




I wonder why the colors are there in the first place instead of the 
expected black.  The negative numbers being in red is good accounting 
practice.  Look at what happens when I copy them into Calc.  Once again 
I get a shift in colors and the negative numbers are not in red and 
cannot be changed using cell format.  Is the problem in GnuCash or in Calc?


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing Reports into LO Calc

[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 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 H.


On Sun, 10 Mar 2024 at 02:42, 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 the folder I want it in and open it in Calc. The
file opens in a browser tab, and I cut and paste the data into Calc.
Notice the different colors used.



I wonder why the colors are there in the first place instead of the
expected black.  The negative numbers being in red is good accounting
practice.  Look at what happens when I copy them into Calc. Once
again
I get a shift in colors and the negative numbers are not in red and
cannot be changed using cell format.  Is the problem in GnuCash or
in Calc?



Thanks for your help.

Abe



On 3/8/2024 21:47, Adrien Monteleone wrote:
> 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. (again, choosing the exported
report)
> When exporting, it probably wouldn't hurt to use an .html filename
> extension.
>
> I have in a few reports seen some alignment issues, but that was
due
> to special padding used by that particular report rather than a
> cleaner HTML. I think I filed a bug on it.
>
> Otherwise, I've had no issues bringing them into Calc.
>
> Regards,
> Adrien
>
> On 3/8/24 1:45 PM, Abe Sternberg wrote:
>> 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 I can think of, including cutting and
pasting.
>>
>> The error is that some fields are imported in a different colored
>> font, this seems to be limited to numeric fields.  I have another
>> situation where totals in a table do not cross-foot - they are not
>> equal when adding row totals across and column totals going down.
>>
>> I had this correct, but have forgotten what to do.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing Reports into LO Calc

[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 all cells containing numerical currency
data to "Currency" this will work. ALl that is imported into Calc is
the data , not any formatting

The benefit of importing to Calc is that youthen have complete control
over how it is formatted within the constraints of Calc's formatting
capabilities but that comes at the cost of having to manually set that
formatting.

AFAIK it should be possible to create a formatted template in Calc so
that you can import the data into the template and have it appear as
you desire.

On Sat, 2024-03-09 at 11:41 -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 the folder I want it in and open it in Calc. The
> file opens in a browser tab, and I cut and paste the data into Calc. 
> Notice the different colors used.
> 
> 
> 
> I wonder why the colors are there in the first place instead of the 
> expected black.  The negative numbers being in red is good accounting
> practice.  Look at what happens when I copy them into Calc.  Once
> again 
> I get a shift in colors and the negative numbers are not in red and 
> cannot be changed using cell format.  Is the problem in GnuCash or in
> Calc?
> 
> 
> 
> Thanks for your help.
> 
> Abe
> 
> 
> 
> On 3/8/2024 21:47, Adrien Monteleone wrote:
> > 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. (again, choosing the exported
> > report) 
> > When exporting, it probably wouldn't hurt to use an .html filename 
> > extension.
> > 
> > I have in a few reports seen some alignment issues, but that was
> > due 
> > to special padding used by that particular report rather than a 
> > cleaner HTML. I think I filed a bug on it.
> > 
> > Otherwise, I've had no issues bringing them into Calc.
> > 
> > Regards,
> > Adrien
> > 
> > On 3/8/24 1:45 PM, Abe Sternberg wrote:
> > > 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 I can think of, including cutting and
> > > pasting.
> > > 
> > > The error is that some fields are imported in a different colored
> > > font, this seems to be limited to numeric fields.  I have another
> > > situation where totals in a table do not cross-foot - they are
> > > not 
> > > equal when adding row totals across and column totals going down.
> > > 
> > > I had this correct, but have forgotten what to do.
> > 
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing Reports into LO Calc

[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 H.


On Sun, 10 Mar 2024 at 02:42, 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 the folder I want it in and open it in Calc. The
> file opens in a browser tab, and I cut and paste the data into Calc.
> Notice the different colors used.
>
>
>
> I wonder why the colors are there in the first place instead of the
> expected black.  The negative numbers being in red is good accounting
> practice.  Look at what happens when I copy them into Calc.  Once again
> I get a shift in colors and the negative numbers are not in red and
> cannot be changed using cell format.  Is the problem in GnuCash or in Calc?
>
>
>
> Thanks for your help.
>
> Abe
>
>
>
> On 3/8/2024 21:47, Adrien Monteleone wrote:
> > 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. (again, choosing the exported report)
> > When exporting, it probably wouldn't hurt to use an .html filename
> > extension.
> >
> > I have in a few reports seen some alignment issues, but that was due
> > to special padding used by that particular report rather than a
> > cleaner HTML. I think I filed a bug on it.
> >
> > Otherwise, I've had no issues bringing them into Calc.
> >
> > Regards,
> > Adrien
> >
> > On 3/8/24 1:45 PM, Abe Sternberg wrote:
> >> 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 I can think of, including cutting and pasting.
> >>
> >> The error is that some fields are imported in a different colored
> >> font, this seems to be limited to numeric fields.  I have another
> >> situation where totals in a table do not cross-foot - they are not
> >> equal when adding row totals across and column totals going down.
> >>
> >> I had this correct, but have forgotten what to do.
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing Reports into LO Calc

[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 the folder I want it in and open it in Calc. The
> file opens in a browser tab, and I cut and paste the data into Calc. 
> Notice the different colors used.
>
>
>
> I wonder why the colors are there in the first place instead of the
> expected black. The negative numbers being in red is good accounting
> practice. Look at what happens when I copy them into Calc. Once again
> I get a shift in colors and the negative numbers are not in red and
> cannot be changed using cell format. Is the problem in GnuCash or in Calc?

It is the spreadsheet program (calc).  Spreadsheet programs are not accounting
programs and don't know anything about "good accounting practice".  GnuCash is
an accounting program and does know all about "good accounting practice".

*I* don't know how to fix this.  What are you trying to do with the
spreadsheet program?

>
>
>
> Thanks for your help.
>
> Abe
>
>
>
> On 3/8/2024 21:47, Adrien Monteleone wrote:
> > 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. (again, choosing the exported report)
> > When exporting, it probably wouldn't hurt to use an .html filename
> > extension.
> >
> > I have in a few reports seen some alignment issues, but that was due
> > to special padding used by that particular report rather than a
> > cleaner HTML. I think I filed a bug on it.
> >
> > Otherwise, I've had no issues bringing them into Calc.
> >
> > Regards,
> > Adrien
> >
> > On 3/8/24 1:45 PM, Abe Sternberg wrote:
> >> 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 I can think of, including cutting and pasting.
> >>
> >> The error is that some fields are imported in a different colored
> >> font, this seems to be limited to numeric fields.  I have another
> >> situation where totals in a table do not cross-foot - they are not
> >> equal when adding row totals across and column totals going down.
> >>
> >> I had this correct, but have forgotten what to do.
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
>

--
Robert Heller -- Cell: 413-658-7953 GV: 978-633-5364
Deepwoods Software-- Custom Software Services
http://www.deepsoft.com/  -- Linux Administration Services
hel...@deepsoft.com   -- Webhosting Services

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing Reports into LO Calc

[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 tab, and I cut and paste the data into Calc.  
Notice the different colors used.




I wonder why the colors are there in the first place instead of the 
expected black.  The negative numbers being in red is good accounting 
practice.  Look at what happens when I copy them into Calc.  Once again 
I get a shift in colors and the negative numbers are not in red and 
cannot be changed using cell format.  Is the problem in GnuCash or in Calc?




Thanks for your help.

Abe



On 3/8/2024 21:47, Adrien Monteleone wrote:
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. (again, choosing the exported report) 
When exporting, it probably wouldn't hurt to use an .html filename 
extension.


I have in a few reports seen some alignment issues, but that was due 
to special padding used by that particular report rather than a 
cleaner HTML. I think I filed a bug on it.


Otherwise, I've had no issues bringing them into Calc.

Regards,
Adrien

On 3/8/24 1:45 PM, Abe Sternberg wrote:
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 I can think of, including cutting and pasting.


The error is that some fields are imported in a different colored 
font, this seems to be limited to numeric fields.  I have another 
situation where totals in a table do not cross-foot - they are not 
equal when adding row totals across and column totals going down.


I had this correct, but have forgotten what to do.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing Reports into LO Calc

[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. (again, choosing the exported report) 
When exporting, it probably wouldn't hurt to use an .html filename 
extension.


I have in a few reports seen some alignment issues, but that was due to 
special padding used by that particular report rather than a cleaner 
HTML. I think I filed a bug on it.


Otherwise, I've had no issues bringing them into Calc.

Regards,
Adrien

On 3/8/24 1:45 PM, Abe Sternberg wrote:
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 I can think of, including cutting and pasting.


The error is that some fields are imported in a different colored font, 
this seems to be limited to numeric fields.  I have another situation 
where totals in a table do not cross-foot - they are not equal when 
adding row totals across and column totals going down.


I had this correct, but have forgotten what to do.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Importing Reports into LO Calc

[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 I can think of, including cutting and pasting.


The error is that some fields are imported in a different colored font, 
this seems to be limited to numeric fields.  I have another situation 
where totals in a table do not cross-foot - they are not equal when 
adding row totals across and column totals going down.


I had this correct, but have forgotten what to do.

Thanks for your help.

Abe
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[John Ralls]

It's part of CSV import. It has been there for a long time but didn't work very 
well until Geert rewrote the CSV importer for GnuCash 4.

Use File>Export>Transactions to CSV to create a CSV file then 
File>Import>Import Transactions from CSV and click the Multi-Split box under 
File Format on the Import Preview page.

Regards,
John Ralls

> On Jan 16, 2024, at 10:38 AM, Adrien Monteleone 
>  wrote:
> 
> 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 or option to specify the file to be imported was
>> in Gnucash format ?  Do you see this? Have you selected it ?
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 or option to specify the file to be imported was
in Gnucash format ?  Do you see this? Have you selected it ?


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 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 import it does not seem to be a possibility. It appears as
> though I must in some way edit the exported file in order to import it.
>
> Both the earlier year and the current year have the same account list.
> I am using Build ID: 4.12+(2022-09-24).
>
> I'd appreciate a hint on what I might be missing.
>
> Regards
>
> James Wilde
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 semi-colons instead of commas) 
but when I go to the current year to import it does not seem to be a 
possibility. It appears as though I must in some way edit the exported 
file in order to import it


Interesting.

I imagine that some more specifics about what you are observing might 
help others on the list get you through the next step.


You say, "when I go to the current year to import it does not seem to be 
a possibility."


You have run GnuCash and opened the book file for the current year, the 
file which will receive the earlier file's data, correct?


You are selecting the menu item, File -- Import -- Import Transactions 
from CSV, correct?


Does the Transaction Import Assistant appear?

Are you able to get past the first page of the Assistant? Does the 
"Select File for Import" page appear?


In the "Select File for Import" page, are you able to locate the CSV 
file which has the earlier data?


Is the name of that CSV file displayed as regular (black) text, or is it 
greyed-out text?


If you click on the name of the CSV, and click the "Next" button? Does 
the "Import Preview" page appear?


Do you encounter any problems on the "Import Preview" page? Are you able 
to click "Next"? Does the "Match Import and GnuCash accounts" page appear?


(and so on…)

I am using GnuCash in English. If you are using GnuCash in Swedish, and 
my English-language names do not translate easily to yours, I apologise 
for the confusion.


Both the earlier year and the current year have the same account list. 
I am using Build ID: 4.12+(2022-09-24).


Thank you for supplying those important facts. What computer OS are you 
using? Windows 11?


Best regards,
 —Jim DeLaHunt


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Importing from one gnucash file to another

[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 import it does not seem to be a possibility. It appears as 
though I must in some way edit the exported file in order to import it.


Both the earlier year and the current year have the same account list.  
I am using Build ID: 4.12+(2022-09-24).


I'd appreciate a hint on what I might be missing.

Regards

James Wilde
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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
> 
> 
> information for the Price Import Assistant in
> https://www.gnucash.org/docs/v5/C/gnucash-manual/tool-price.html and
> https://www.gnucash.org/docs/v5/C/gnucash-manual/tool-security-edit.html
> 
> The term security seems to be used interchangeably (ie it's not a subset)
> with commodity and a symbol is a property of a commodity.
> 
>   -
> 
>   *Commodity: *A commodity is something of value that is easily tradeable
>   or sellable; for example, currencies, stocks, bonds, grain, copper, and oil
>   are all commodities.
> 
> https://www.gnucash.org/docs/v5/C/gnucash-manual/tool-security-edit.html
> clearly describes Securities types are currency, fund, listing stock
> exchange, or a user defined type. It seems some user defined types, for
> example grain, would turn this into a commodity. It conflicts with the
> second sentence below:
> 
>   -
> 
> 
> *Security: The Security/commodity being priced. The display is sorted by
>   the Namespace that the individual securities are listed on. *
>   -
> 
>   *Symbol:* Indicates the symbol or abbreviation for the commodity. This
>   is usually the ticker symbol (for stocks) or other unique abbreviation for
>   the commodity. If the commodity is traded on any public exchange, it is
>   important to use the same identifier used on that exchange. For national
>   currencies the symbol is the ISO-4217 currency code.
>   -
> 
>   *Namespace:* What is a reasonable description of this group [of
>   commodities ??] ?  The only reference to Namespace in the documentation is
>   quoted above but referring to a group of stock by listing exchange is too
>   restrictive.

Namespace is the better name for security type. The Security Editor manual page 
is out of date, we've removed the hard-coded namespaces FUND, AMEX, ASX, EUREX, 
NASDAQ, and NYSE from the program; they seemed to be more confusing than 
helpful because they obscured that users could create their own.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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/C/gnucash-manual/tool-price.html and
https://www.gnucash.org/docs/v5/C/gnucash-manual/tool-security-edit.html

The term security seems to be used interchangeably (ie it's not a subset)
with commodity and a symbol is a property of a commodity.

   -

   *Commodity: *A commodity is something of value that is easily tradeable
   or sellable; for example, currencies, stocks, bonds, grain, copper, and oil
   are all commodities.

https://www.gnucash.org/docs/v5/C/gnucash-manual/tool-security-edit.html
clearly describes Securities types are currency, fund, listing stock
exchange, or a user defined type. It seems some user defined types, for
example grain, would turn this into a commodity. It conflicts with the
second sentence below:

   -


*Security: The Security/commodity being priced. The display is sorted by
   the Namespace that the individual securities are listed on. *
   -

   *Symbol:* Indicates the symbol or abbreviation for the commodity. This
   is usually the ticker symbol (for stocks) or other unique abbreviation for
   the commodity. If the commodity is traded on any public exchange, it is
   important to use the same identifier used on that exchange. For national
   currencies the symbol is the ISO-4217 currency code.
   -

   *Namespace:* What is a reasonable description of this group [of
   commodities ??] ?  The only reference to Namespace in the documentation is
   quoted above but referring to a group of stock by listing exchange is too
   restrictive.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 Namespace, From Symbol and
Currency To, irrespective of the labels used elsewhere for this data.

A csv file can use any column order, a header is optional, and the Import
Assistant doesn't use the header names. Various options exist for
specifying the delimiter as well as a fixed width option. Double quotes are
not required as shown in other examples.

I am confused by seemingly different labels being used within GnuCash for
the same data and I highlighted Commodity, Security, Namespace and Symbol.
How exactly is "CURRENCY" used in that example? Does it refer to the
default for the security or user/file?

It also seems From Symbol for
https://www.vanguard.com.au/personal/invest-with-us/etf?portId=8205 could
be VAS, VAS.ASX, or VAS.AX (ie custom Yahoo exchange code). I understand
>From Namespace is any convenient label the user chooses for the group of
Securities [??], not necessarily the Stock Exchange which could form part
of the From Symbol.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[Kalpesh Patel]

Attached is a file of what it would look like with same security prices for 
different day and with multiple of these examples repeated for other securities 
and/or indexes ...

-Original Message-
From: Kalpesh Patel  
Sent: Sunday, October 01, 2023 7:49 PM
To: 'flywire' ; 'Ove Grunnér' 
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_SYMBOL",date,"PRICE","QUOTE_CURRENCY"

One line per record each formatted as denoted above.
Double quotes around NAME_SPACE, TICKER_SYMBOL, PRICE and QUOTE_CURRENCY are 
required.
Date format I've utilized and has worked flawlessly has been mm/dd/.
NAME_SPACE corresponds to the top level name given in the 'Security' column in 
the 'Price Database' window and corresponds to 'From Namespace' heading in the 
'Import Preview' window. I normally set this to what Yahoo Finance reports as 
the exchange where the security trades. This also is same thing as 'Namespace" 
in the 'Securities' window.

See code at 
https://github.com/ka-patel/dl_quotes/blob/main/yahoo_finance/get_historic_quotes.py
 for details if you are knowledged in Python.

https://github.com/ka-patel/dl_quotes/blob/main/yahoo_finance/README.md has 
additional details...

-Original Message-
From: flywire  
Sent: Saturday, September 30, 2023 6:46 PM
To: Ove Grunnér 
Cc: Gnucash Users 
Subject: Re: [GNC] Importing stock prices from a CSV file

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.



gnucash_quotes.csv
Description: MS-Excel spreadsheet
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 formatted as denoted above.
Double quotes around NAME_SPACE, TICKER_SYMBOL, PRICE and QUOTE_CURRENCY are 
required.
Date format I've utilized and has worked flawlessly has been mm/dd/.
NAME_SPACE corresponds to the top level name given in the 'Security' column in 
the 'Price Database' window and corresponds to 'From Namespace' heading in the 
'Import Preview' window. I normally set this to what Yahoo Finance reports as 
the exchange where the security trades. This also is same thing as 'Namespace" 
in the 'Securities' window.

See code at 
https://github.com/ka-patel/dl_quotes/blob/main/yahoo_finance/get_historic_quotes.py
 for details if you are knowledged in Python.

https://github.com/ka-patel/dl_quotes/blob/main/yahoo_finance/README.md has 
additional details...

-Original Message-
From: flywire  
Sent: Saturday, September 30, 2023 6:46 PM
To: Ove Grunnér 
Cc: Gnucash Users 
Subject: Re: [GNC] Importing stock prices from a CSV file

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.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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
stock, then that will be the name space you need when importing stock
prices.

file example
Account_Name,Rate,Balance Currency,Date,Name Space
ALV.DE,207.95,EUR,2023-06-10,Euronext
AMZN,123.43,USD,2023-06-10,NASDAQ
ASML.AS,666.6,EUR,2023-06-10,Euronext
AZN.ST,1598,SEK,2023-06-10,StockholmsBorsen
BAS.DE,46.02,EUR,2023-06-10,Euronext
CA.PA,26.52,EUR,2023-06-10,Euronext




Kind Regards,

Ove.






On Sat, 30 Sept 2023 at 22:31, flywire  wrote:

> 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 the same Commodity / Currency then you
> can select them and then the columns will be Date and Amount...
>
> Examples are "FTSE","RR.L","21/11/2016",5.345,"GBP” and
> CURRENCY:USD;2016-11-21;1.56;GBP
>
> Isn't FTSE an index and what is the .L ? So currency can be prefixed with
> CURRENCY: ?
>
> I don't understand the data (except date and amount) which means I can't
> understand the column format example. It would be a lot clearer if the
> columns were in the same order as the description, and even better with a
> header line, so the data didn't have to be understood to understand
> the columns.
>
> I still have no idea what the file would look like when all entries are
> the same commodity...
>
> Surely this process should support the default currency like elsewhere in
> GnuCash and the column names are absurd.
>
> Thanks Ken. That link had a nice clear example but it will not work now
> without the From Namespace (coder jargon for Stock Exchange).
>
> I just tested with the following CSV:
> AAPL,23/8/2018,USD,255.37
> ABF.L,23/8/2018,GBP,25
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 the same Commodity / Currency then you
can select them and then the columns will be Date and Amount...

Examples are "FTSE","RR.L","21/11/2016",5.345,"GBP” and
CURRENCY:USD;2016-11-21;1.56;GBP

Isn't FTSE an index and what is the .L ? So currency can be prefixed with
CURRENCY: ?

I don't understand the data (except date and amount) which means I can't
understand the column format example. It would be a lot clearer if the
columns were in the same order as the description, and even better with a
header line, so the data didn't have to be understood to understand
the columns.

I still have no idea what the file would look like when all entries are
the same commodity...

Surely this process should support the default currency like elsewhere in
GnuCash and the column names are absurd.

Thanks Ken. That link had a nice clear example but it will not work now
without the From Namespace (coder jargon for Stock Exchange).

I just tested with the following CSV:
AAPL,23/8/2018,USD,255.37
ABF.L,23/8/2018,GBP,25
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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
>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 unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 will be helpful, at least it gives some examples of 
correct format, etc.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 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 unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Importing stock prices from a CSV file

[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/Using_GnuCash#Stocks_and_Commodities
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing data from QuickBooks Online

[Tom Olin via gnucash-user]

ad but have this advice for 
>>>>> you to further diagnose. When I face a puzzle like this, I like to try 
>>>>> creating the simplest possible scenario in which I am still able to 
>>>>> reproduce the problem. In this case this would start by figuring out how 
>>>>> far you can pare down your 2022 csv file while still having the problem. 
>>>>> Can you pair it down to just a few transactions, like 5 or 10 max?  Can 
>>>>> you then change some of that data in that pared down file and still have 
>>>>> the problem? By simplifying you can often more easily find the source of 
>>>>> the problem and also might be able to share your csv file when it reaches 
>>>>> the point where the data in it is no longer personal.
>>>>> 
>>>>> Sincerely,
>>>>> 
>>>>> Vincent Dawans
>>>>> 
>>>>> On Mon, Jul 3, 2023 at 3:35 PM Tom Olin via gnucash-user 
>>>>> mailto:gnucash-user@gnucash.org> 
>>>>> <mailto:gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>>> 
>>>>> wrote:
>>>>> I would add that I’m more inclined to attribute the problem to GnuCash 
>>>>> logic. However, the code will require a lot of study on my part before I 
>>>>> can make meaningful sense of it. I just wish I could think of some 
>>>>> possible logic that might explain it.
>>>>> 
>>>>> --
>>>>> Tom
>>>>> 
>>>>> Money is created out of thin air when banks loan and when the federal 
>>>>> government spends. Money is destroyed into thin air when bank loans are 
>>>>> repaid and when federal taxes are paid.
>>>>> 
>>>>>> On Jul 3, 2023, at 5:41 PM, Ken Pyzik >>>>> <mailto:py...@outlook.com> <mailto:py...@outlook.com 
>>>>>> <mailto:py...@outlook.com>>> wrote:
>>>>>> 
>>>>>> Tom -- I believe at the beginning of 2022, QuickBooks went from being a 
>>>>>> desktop and online software package  - to being strictly/only online.  
>>>>>> With that transition, I believe they also gave a one-year period where 
>>>>>> you could export data.  While this may be a stretch, I believe that they 
>>>>>> may have somehow added a change flag or some other thing to the data to 
>>>>>> prevent you from exporting it as easy as it used to be.  This could be 
>>>>>> the discrepancy you are experiencing.  In other words, to prevent people 
>>>>>> from doing what you are exactly trying to do -- they may have placed a 
>>>>>> simple data offset or some other thing into the data to prevent easy 
>>>>>> export.  Again, this could be a stretch -- but it would explain why one 
>>>>>> year comes over correctly and the next does not.  Just my two cents -- 
>>>>>> for what it is worth ( which could be nothing at all!)
>>>>>> 
>>>>>> Ken   
>>>>>> 
>>>>>> -Original Message-
>>>>>> From: gnucash-user >>>>> <mailto:gnucash-user-bounces+pyz01=outlook@gnucash.org> 
>>>>>> <mailto:outlook@gnucash.org <mailto:outlook@gnucash.org>>> On 
>>>>>> Behalf Of Tom Olin via gnucash-user
>>>>>> Sent: Monday, July 3, 2023 1:55 PM
>>>>>> To: Kalpesh Patel mailto:kalpesh.pa...@usa.net> 
>>>>>> <mailto:kalpesh.pa...@usa.net <mailto:kalpesh.pa...@usa.net>>>
>>>>>> Cc: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> 
>>>>>> <mailto:gnucash-user@gnucash.org <mailto: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 need THEIR money, not 
>>>>>> because they need yours.
>>>>>> 
>>>>>>> On Jul 3, 2023, at 4:52 PM, Kalpesh Patel >>>>>> <mailto:kalpesh.pa...@usa.net> <mailto:kalpesh.pa...@usa.net 
>>>>>>> <mailto:kalpesh.pa...@usa.net>>> wrote:
>>>>>>> 
>>>>&g

Re: [GNC] Importing data from QuickBooks Online

[Vincent Dawans]

; Tom
>>
>> Money is created out of thin air when banks loan and when the federal
>> government spends. Money is destroyed into thin air when bank loans are
>> repaid and when federal taxes are paid.
>>
>> On Jul 3, 2023, at 5:41 PM, Ken Pyzik > mailto:py...@outlook.com >> wrote:
>>
>> Tom -- I believe at the beginning of 2022, QuickBooks went from being a
>> desktop and online software package  - to being strictly/only online.  With
>> that transition, I believe they also gave a one-year period where you could
>> export data.  While this may be a stretch, I believe that they may have
>> somehow added a change flag or some other thing to the data to prevent you
>> from exporting it as easy as it used to be.  This could be the discrepancy
>> you are experiencing.  In other words, to prevent people from doing what
>> you are exactly trying to do -- they may have placed a simple data offset
>> or some other thing into the data to prevent easy export.  Again, this
>> could be a stretch -- but it would explain why one year comes over
>> correctly and the next does not.  Just my two cents -- for what it is worth
>> ( which could be nothing at all!)
>>
>> Ken
>>
>> -Original Message-
>> From: gnucash-user > mailto:outlook@gnucash.org >> On Behalf Of
>> Tom Olin via gnucash-user
>> Sent: Monday, July 3, 2023 1:55 PM
>> To: Kalpesh Patel mailto:kalpesh.pa...@usa.net
>> >>
>> Cc: gnucash-user@gnucash.org <mailto: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 need THEIR money, not
>> because they need yours.
>>
>> On Jul 3, 2023, at 4:52 PM, Kalpesh Patel > mailto:kalpesh.pa...@usa.net >> wrote:
>>
>> I am likely grasping straws here like David but did you verify the format
>> of the date that it is consistent throughout? Like it isn’t switching from
>> two digits to four digits, or replace certain digits with place holders,
>> etc. QuickBooks is (was?) published by the maker of Quicken and I remember
>> their exports when it came to Quicken was all over the map for the format
>> of the date and ended up normalizing it with an external script when I did
>> a full migration from Quicken to GNC. By far this, the date format, was
>> biggest PITA.
>>
>> -Original Message-
>> From: Tom Olin mailto:t...@tomolin.net 
>> >>
>>
>> Sent: Monday, July 03, 2023 12:14 PM
>> To: Jean L mailto:rip...@gmail.com 
>> >>
>> Cc: gnucash-user@gnucash.org <mailto: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 of QuickBooks Online.
>>
>> As it turns out, my minimal script seems to work very well with this one
>> weird anomaly. The nature of it suggests something that should be easily
>> worked around - if I can just figure out what it is.
>>
>> --
>> Tom
>>
>> Federal tax dollars don’t exist. Federal spending creates dollars out of
>> thin air. With federal tax payments, the opposite occurs.
>>
>> On Jul 3, 2023, at 12:04 PM, Jean L > mailto:rip...@gmail.com >> wrote:
>>
>> This may be slightly off topic, or too late to help, but...
>>
>> In github, there is a repository
>> https://github.com/tim-rohrer/move2gnucash <
>> https://github.com/tim-rohrer/move2gnucash>
>> That seems pretty well setup to migrate your data from a quicken csv
>> export to GC. I haven't used it, but I looked at it for a friend and it
>> looked interesting.
>>
>> Jean
>>
>> On 7/3/2023 8:59 AM, Tom Olin via gnucash-user wrote:
>>
>> [Resending to the list. Original reply went only to Jim.]
>>
>> Jim,
>>
>> Fair questions. Answers below, and I’ve attached the script itself which
>> includes documentation which addresses some of the questions. I’ve reviewed
>> all documentation that I can find.
>>
>> From QBO, I export a journal report to XLS (only usable option in QBO).
>>
>> GnuCash 5.3 on macOS 11.7.8
>>
>> See the script for the specific steps.
>>
>> The import matcher step of the import process is fully satisfied. That is
>> the step labeled “Ma

Re: [GNC] Importing data from QuickBooks Online

[Tom Olin via gnucash-user]

gnucash-user 
>>>> mailto:gnucash-user@gnucash.org> 
>>>> <mailto:gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>>> wrote:
>>>> I would add that I’m more inclined to attribute the problem to GnuCash 
>>>> logic. However, the code will require a lot of study on my part before I 
>>>> can make meaningful sense of it. I just wish I could think of some 
>>>> possible logic that might explain it.
>>>> 
>>>> --
>>>> Tom
>>>> 
>>>> Money is created out of thin air when banks loan and when the federal 
>>>> government spends. Money is destroyed into thin air when bank loans are 
>>>> repaid and when federal taxes are paid.
>>>> 
>>>>> On Jul 3, 2023, at 5:41 PM, Ken Pyzik >>>> <mailto:py...@outlook.com> <mailto:py...@outlook.com 
>>>>> <mailto:py...@outlook.com>>> wrote:
>>>>> 
>>>>> Tom -- I believe at the beginning of 2022, QuickBooks went from being a 
>>>>> desktop and online software package  - to being strictly/only online.  
>>>>> With that transition, I believe they also gave a one-year period where 
>>>>> you could export data.  While this may be a stretch, I believe that they 
>>>>> may have somehow added a change flag or some other thing to the data to 
>>>>> prevent you from exporting it as easy as it used to be.  This could be 
>>>>> the discrepancy you are experiencing.  In other words, to prevent people 
>>>>> from doing what you are exactly trying to do -- they may have placed a 
>>>>> simple data offset or some other thing into the data to prevent easy 
>>>>> export.  Again, this could be a stretch -- but it would explain why one 
>>>>> year comes over correctly and the next does not.  Just my two cents -- 
>>>>> for what it is worth ( which could be nothing at all!)
>>>>> 
>>>>> Ken   
>>>>> 
>>>>> -Original Message-
>>>>> From: gnucash-user >>>> <mailto:gnucash-user-bounces+pyz01=outlook@gnucash.org> 
>>>>> <mailto:outlook@gnucash.org <mailto:outlook@gnucash.org>>> On 
>>>>> Behalf Of Tom Olin via gnucash-user
>>>>> Sent: Monday, July 3, 2023 1:55 PM
>>>>> To: Kalpesh Patel mailto:kalpesh.pa...@usa.net> 
>>>>> <mailto:kalpesh.pa...@usa.net <mailto:kalpesh.pa...@usa.net>>>
>>>>> Cc: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> 
>>>>> <mailto:gnucash-user@gnucash.org <mailto: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 need THEIR money, not 
>>>>> because they need yours.
>>>>> 
>>>>>> On Jul 3, 2023, at 4:52 PM, Kalpesh Patel >>>>> <mailto:kalpesh.pa...@usa.net> <mailto:kalpesh.pa...@usa.net 
>>>>>> <mailto:kalpesh.pa...@usa.net>>> wrote:
>>>>>> 
>>>>>> I am likely grasping straws here like David but did you verify the 
>>>>>> format of the date that it is consistent throughout? Like it isn’t 
>>>>>> switching from two digits to four digits, or replace certain digits with 
>>>>>> place holders, etc. QuickBooks is (was?) published by the maker of 
>>>>>> Quicken and I remember their exports when it came to Quicken was all 
>>>>>> over the map for the format of the date and ended up normalizing it with 
>>>>>> an external script when I did a full migration from Quicken to GNC. By 
>>>>>> far this, the date format, was biggest PITA.
>>>>>> 
>>>>>> -Original Message-
>>>>>> From: Tom Olin mailto:t...@tomolin.net> 
>>>>>> <mailto:t...@tomolin.net <mailto:t...@tomolin.net>>> 
>>>>>> Sent: Monday, July 03, 2023 12:14 PM
>>>>>> To: Jean L mailto:rip...@gmail.com> 
>>>>>> <mailto:rip...@gmail.com <mailto:rip...@gmail.com>>>
>>>>>> Cc: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> 
>>>>>> <ma

Re: [GNC] Importing data from QuickBooks Online

[Vincent Dawans]

port.  Again, this
> could be a stretch -- but it would explain why one year comes over
> correctly and the next does not.  Just my two cents -- for what it is worth
> ( which could be nothing at all!)
>
> Ken
>
> -Original Message-
> From: gnucash-user  mailto:outlook@gnucash.org >> On Behalf Of
> Tom Olin via gnucash-user
> Sent: Monday, July 3, 2023 1:55 PM
> To: Kalpesh Patel mailto:kalpesh.pa...@usa.net
> >>
> Cc: gnucash-user@gnucash.org <mailto: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 need THEIR money, not
> because they need yours.
>
> On Jul 3, 2023, at 4:52 PM, Kalpesh Patel  mailto:kalpesh.pa...@usa.net >> wrote:
>
> I am likely grasping straws here like David but did you verify the format
> of the date that it is consistent throughout? Like it isn’t switching from
> two digits to four digits, or replace certain digits with place holders,
> etc. QuickBooks is (was?) published by the maker of Quicken and I remember
> their exports when it came to Quicken was all over the map for the format
> of the date and ended up normalizing it with an external script when I did
> a full migration from Quicken to GNC. By far this, the date format, was
> biggest PITA.
>
> -Original Message-
> From: Tom Olin mailto:t...@tomolin.net >>
>
> Sent: Monday, July 03, 2023 12:14 PM
> To: Jean L mailto:rip...@gmail.com >>
> Cc: gnucash-user@gnucash.org <mailto: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 of QuickBooks Online.
>
> As it turns out, my minimal script seems to work very well with this one
> weird anomaly. The nature of it suggests something that should be easily
> worked around - if I can just figure out what it is.
>
> --
> Tom
>
> Federal tax dollars don’t exist. Federal spending creates dollars out of
> thin air. With federal tax payments, the opposite occurs.
>
> On Jul 3, 2023, at 12:04 PM, Jean L  mailto:rip...@gmail.com >> wrote:
>
> This may be slightly off topic, or too late to help, but...
>
> In github, there is a repository
> https://github.com/tim-rohrer/move2gnucash <
> https://github.com/tim-rohrer/move2gnucash>
> That seems pretty well setup to migrate your data from a quicken csv
> export to GC. I haven't used it, but I looked at it for a friend and it
> looked interesting.
>
> Jean
>
> On 7/3/2023 8:59 AM, Tom Olin via gnucash-user wrote:
>
> [Resending to the list. Original reply went only to Jim.]
>
> Jim,
>
> Fair questions. Answers below, and I’ve attached the script itself which
> includes documentation which addresses some of the questions. I’ve reviewed
> all documentation that I can find.
>
> From QBO, I export a journal report to XLS (only usable option in QBO).
>
> GnuCash 5.3 on macOS 11.7.8
>
> See the script for the specific steps.
>
> The import matcher step of the import process is fully satisfied. That is
> the step labeled “Match Import and GnuCash accounts”.
>
> The  problem manifests at the “Match Transactions” screen where all
> transactions need to be matched. I’ve attached a screenshot if it is
> supported here.
>
> One more data point: 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 mailto:list%2bgnuc...@jdlh.com >>  wrote:
>
> Tom:
>
> 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.
>
> 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 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 cleanly, but all 2022 transactions import unbalanced,
> meaning I have to manually match up each of them - doable but tedious.
>
> Let's assume you are exporting data in CSV format, and using the current
> version of GnuCash (5.3), and importing using the File… Import… Import
> Transactions 

Re: [GNC] Importing data from QuickBooks Online

[Tom Olin via gnucash-user]

Here’s the final version (for now) of my script. I hope someone else finds it 
useful.

Thanks to all who responded to my query with suggestions.

--
Tom

Federal taxes can be paid with dollars, but the dollars have to be created 
(spent) by the government before anyone has dollars with which to pay their 
taxes.

> On Jul 4, 2023, at 8:00 AM, Tom Olin via gnucash-user 
>  wrote:
> 
> Vincent,
> 
> Thanks so much for figuring this out! If you don’t mind, I’d like to give you 
> credit in my file.
> 
> I’m going to rerun the entire dataset as a final test. I will repost the 
> final version of the script here for anyone else looking to do this.
> 
> Thanks, again!
> 
> --
> Tom
> 
> Federal spending funds taxes. It is impossible to pay taxes until the 
> government has spent money into the economy.
> 
>> On Jul 3, 2023, at 10:37 PM, Vincent Dawans  wrote:
>> 
>> Tom:
>> 
>> I tested both files and it seems that it fails on the reconcile column for 
>> 2022. When I skip the reconcile column it works. 2022 has Y entries in 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 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. 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 and when the federal government spends. The 
>> latter increases someone’s net worth. The former does not, but the interest 
>> and fees transfer net worth from the borrower to the lender.
>> 
>>> On Jul 3, 2023, at 6:44 PM, Vincent Dawans >> <mailto:dawa...@gmail.com>> wrote:
>>> 
>>> Tom:
>>> 
>>> I haven't read every single email in this thread but have this advice for 
>>> you to further diagnose. When I face a puzzle like this, I like to try 
>>> creating the simplest possible scenario in which I am still able to 
>>> reproduce the problem. In this case this would start by figuring out how 
>>> far you can pare down your 2022 csv file while still having the problem. 
>>> Can you pair it down to just a few transactions, like 5 or 10 max?  Can you 
>>> then change some of that data in that pared down file and still have the 
>>> problem? By simplifying you can often more easily find the source of the 
>>> problem and also might be able to share your csv file when it reaches the 
>>> point where the data in it is no longer personal.
>>> 
>>> Sincerely,
>>> 
>>> Vincent Dawans
>>> 
>>> On Mon, Jul 3, 2023 at 3:35 PM Tom Olin via gnucash-user 
>>> mailto:gnucash-user@gnucash.org>> wrote:
>>> I would add that I’m more inclined to attribute the problem to GnuCash 
>>> logic. However, the code will require a lot of study on my part before I 
>>> can make meaningful sense of it. I just wish I could think of some possible 
>>> logic that might explain it.
>>> 
>>> --
>>> Tom
>>> 
>>> Money is created out of thin air when banks loan and when the federal 
>>> government spends. Money is destroyed into thin air when bank loans are 
>>> repaid and when federal taxes are paid.
>>> 
>>>> On Jul 3, 2023, at 5:41 PM, Ken Pyzik >>> <mailto:py...@outlook.com>> wrote:
>>>> 
>>>> Tom -- I believe at the beginning of 2022, QuickBooks went from being a 
>>>> desktop and online software package  - to being strictly/only online.  
>>>> With that transition, I believe they also gave a one-year period where you 
>>>> could export data.  While this may be a stretch, I believe that they may 
>>>> have somehow added a change flag or some other thing to the data to 
>>>> prevent you from exporting it as easy as it used to be.  This could be the 
>>>> discrepancy you are experiencing.  In other words, to prevent people from 
>>>> doing what you are exactly trying to do -- they may have placed a simple 
>>>> data offset

Re: [GNC] Importing data from QuickBooks Online

[Tom Olin via gnucash-user]

Vincent,

Thanks so much for figuring this out! If you don’t mind, I’d like to give you 
credit in my file.

I’m going to rerun the entire dataset as a final test. I will repost the final 
version of the script here for anyone else looking to do this.

Thanks, again!

--
Tom

Federal spending funds taxes. It is impossible to pay taxes until the 
government has spent money into the economy.

> On Jul 3, 2023, at 10:37 PM, Vincent Dawans  wrote:
> 
> Tom:
> 
> I tested both files and it seems that it fails on the reconcile column for 
> 2022. When I skip the reconcile column it works. 2022 has Y entries in 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 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. 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 and when the federal government spends. The 
> latter increases someone’s net worth. The former does not, but the interest 
> and fees transfer net worth from the borrower to the lender.
> 
>> On Jul 3, 2023, at 6:44 PM, Vincent Dawans > <mailto:dawa...@gmail.com>> wrote:
>> 
>> Tom:
>> 
>> I haven't read every single email in this thread but have this advice for 
>> you to further diagnose. When I face a puzzle like this, I like to try 
>> creating the simplest possible scenario in which I am still able to 
>> reproduce the problem. In this case this would start by figuring out how far 
>> you can pare down your 2022 csv file while still having the problem. Can you 
>> pair it down to just a few transactions, like 5 or 10 max?  Can you then 
>> change some of that data in that pared down file and still have the problem? 
>> By simplifying you can often more easily find the source of the problem and 
>> also might be able to share your csv file when it reaches the point where 
>> the data in it is no longer personal.
>> 
>> Sincerely,
>> 
>> Vincent Dawans
>> 
>> On Mon, Jul 3, 2023 at 3:35 PM Tom Olin via gnucash-user 
>> mailto:gnucash-user@gnucash.org>> wrote:
>> I would add that I’m more inclined to attribute the problem to GnuCash 
>> logic. However, the code will require a lot of study on my part before I can 
>> make meaningful sense of it. I just wish I could think of some possible 
>> logic that might explain it.
>> 
>> --
>> Tom
>> 
>> Money is created out of thin air when banks loan and when the federal 
>> government spends. Money is destroyed into thin air when bank loans are 
>> repaid and when federal taxes are paid.
>> 
>> > On Jul 3, 2023, at 5:41 PM, Ken Pyzik > > <mailto:py...@outlook.com>> wrote:
>> > 
>> > Tom -- I believe at the beginning of 2022, QuickBooks went from being a 
>> > desktop and online software package  - to being strictly/only online.  
>> > With that transition, I believe they also gave a one-year period where you 
>> > could export data.  While this may be a stretch, I believe that they may 
>> > have somehow added a change flag or some other thing to the data to 
>> > prevent you from exporting it as easy as it used to be.  This could be the 
>> > discrepancy you are experiencing.  In other words, to prevent people from 
>> > doing what you are exactly trying to do -- they may have placed a simple 
>> > data offset or some other thing into the data to prevent easy export.  
>> > Again, this could be a stretch -- but it would explain why one year comes 
>> > over correctly and the next does not.  Just my two cents -- for what it is 
>> > worth ( which could be nothing at all!)
>> > 
>> > Ken   
>> > 
>> > -Original Message-
>> > From: gnucash-user > > <mailto:outlook@gnucash.org>> On Behalf Of Tom Olin via gnucash-user
>> > Sent: Monday, July 3, 2023 1:55 PM
>> > To: Kalpesh Patel mailto:kalpesh.pa...@usa.net>>
>> > Cc: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
>> > Subject: Re: [GNC] Importing data from QuickBooks Onl

Re: [GNC] Importing data from QuickBooks Online

[Vincent Dawans]

Just to add that the reconcile flag is sort of a moot point right now
because it seems like there is a bug with the multi-split import where the
flag is ignored and set to cleared for the first account on each
transaction. See  796890 – CSV import of multi-split transactions marks
reconciliation status of first line as cleared (gnucash.org)
<https://bugs.gnucash.org/show_bug.cgi?id=796890>

On Mon, Jul 3, 2023 at 7:37 PM Vincent Dawans  wrote:

> Tom:
>
> I tested both files and it seems that it fails on the reconcile column for
> 2022. When I skip the reconcile column it works. 2022 has Y entries in 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 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 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 and when the federal government spends.
>> The latter increases someone’s net worth. The former does not, but the
>> interest and fees transfer net worth from the borrower to the lender.
>>
>> On Jul 3, 2023, at 6:44 PM, Vincent Dawans  wrote:
>>
>> Tom:
>>
>> I haven't read every single email in this thread but have this advice for
>> you to further diagnose. When I face a puzzle like this, I like to try
>> creating the simplest possible scenario in which I am still able to
>> reproduce the problem. In this case this would start by figuring out how
>> far you can pare down your 2022 csv file while still having the problem.
>> Can you pair it down to just a few transactions, like 5 or 10 max?  Can you
>> then change some of that data in that pared down file and still have the
>> problem? By simplifying you can often more easily find the source of the
>> problem and also might be able to share your csv file when it reaches the
>> point where the data in it is no longer personal.
>>
>> Sincerely,
>>
>> Vincent Dawans
>>
>> On Mon, Jul 3, 2023 at 3:35 PM Tom Olin via gnucash-user <
>> gnucash-user@gnucash.org> wrote:
>>
>>> I would add that I’m more inclined to attribute the problem to GnuCash
>>> logic. However, the code will require a lot of study on my part before I
>>> can make meaningful sense of it. I just wish I could think of some possible
>>> logic that might explain it.
>>>
>>> --
>>> Tom
>>>
>>> Money is created out of thin air when banks loan and when the federal
>>> government spends. Money is destroyed into thin air when bank loans are
>>> repaid and when federal taxes are paid.
>>>
>>> > On Jul 3, 2023, at 5:41 PM, Ken Pyzik  wrote:
>>> >
>>> > Tom -- I believe at the beginning of 2022, QuickBooks went from being
>>> a desktop and online software package  - to being strictly/only online.
>>> With that transition, I believe they also gave a one-year period where you
>>> could export data.  While this may be a stretch, I believe that they may
>>> have somehow added a change flag or some other thing to the data to prevent
>>> you from exporting it as easy as it used to be.  This could be the
>>> discrepancy you are experiencing.  In other words, to prevent people from
>>> doing what you are exactly trying to do -- they may have placed a simple
>>> data offset or some other thing into the data to prevent easy export.
>>> Again, this could be a stretch -- but it would explain why one year comes
>>> over correctly and the next does not.  Just my two cents -- for what it is
>>> worth ( which could be nothing at all!)
>>> >
>>> > Ken
>>> >
>>> > -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 formats are consistent.
>>> >
>>> > --
>>> > Tom
>

Re: [GNC] Importing data from QuickBooks Online

[Vincent Dawans]

Tom:

I tested both files and it seems that it fails on the reconcile column for
2022. When I skip the reconcile column it works. 2022 has Y entries in 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 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 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 and when the federal government spends.
> The latter increases someone’s net worth. The former does not, but the
> interest and fees transfer net worth from the borrower to the lender.
>
> On Jul 3, 2023, at 6:44 PM, Vincent Dawans  wrote:
>
> Tom:
>
> I haven't read every single email in this thread but have this advice for
> you to further diagnose. When I face a puzzle like this, I like to try
> creating the simplest possible scenario in which I am still able to
> reproduce the problem. In this case this would start by figuring out how
> far you can pare down your 2022 csv file while still having the problem.
> Can you pair it down to just a few transactions, like 5 or 10 max?  Can you
> then change some of that data in that pared down file and still have the
> problem? By simplifying you can often more easily find the source of the
> problem and also might be able to share your csv file when it reaches the
> point where the data in it is no longer personal.
>
> Sincerely,
>
> Vincent Dawans
>
> On Mon, Jul 3, 2023 at 3:35 PM Tom Olin via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
>> I would add that I’m more inclined to attribute the problem to GnuCash
>> logic. However, the code will require a lot of study on my part before I
>> can make meaningful sense of it. I just wish I could think of some possible
>> logic that might explain it.
>>
>> --
>> Tom
>>
>> Money is created out of thin air when banks loan and when the federal
>> government spends. Money is destroyed into thin air when bank loans are
>> repaid and when federal taxes are paid.
>>
>> > On Jul 3, 2023, at 5:41 PM, Ken Pyzik  wrote:
>> >
>> > Tom -- I believe at the beginning of 2022, QuickBooks went from being a
>> desktop and online software package  - to being strictly/only online.  With
>> that transition, I believe they also gave a one-year period where you could
>> export data.  While this may be a stretch, I believe that they may have
>> somehow added a change flag or some other thing to the data to prevent you
>> from exporting it as easy as it used to be.  This could be the discrepancy
>> you are experiencing.  In other words, to prevent people from doing what
>> you are exactly trying to do -- they may have placed a simple data offset
>> or some other thing into the data to prevent easy export.  Again, this
>> could be a stretch -- but it would explain why one year comes over
>> correctly and the next does not.  Just my two cents -- for what it is worth
>> ( which could be nothing at all!)
>> >
>> > Ken
>> >
>> > -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 formats are consistent.
>> >
>> > --
>> > Tom
>> >
>> > The federal government imposes a tax on you so YOU need THEIR money,
>> not because they need yours.
>> >
>> >> On Jul 3, 2023, at 4:52 PM, Kalpesh Patel 
>> wrote:
>> >>
>> >> I am likely grasping straws here like David but did you verify the
>> format of the date that it is consistent throughout? Like it isn’t
>> switching from two digits to four digits, or replace certain digits with
>> place holders, etc. QuickBooks is (was?) published by the maker of Quicken
>> and I remember their exports when it came to Quicken was all over the map
>> for the format of the date and ended up normalizing it with an external
>> script when I did a full migration from Quicken to GNC. By far this, the
>> date format, was bigg

Re: [GNC] Importing data from QuickBooks Online

[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

Money is created when banks loan and when the federal government spends. The 
latter increases someone’s net worth. The former does not, but the interest and 
fees transfer net worth from the borrower to the lender.

> On Jul 3, 2023, at 6:44 PM, Vincent Dawans  wrote:
> 
> Tom:
> 
> I haven't read every single email in this thread but have this advice for you 
> to further diagnose. When I face a puzzle like this, I like to try creating 
> the simplest possible scenario in which I am still able to reproduce the 
> problem. In this case this would start by figuring out how far you can pare 
> down your 2022 csv file while still having the problem. Can you pair it down 
> to just a few transactions, like 5 or 10 max?  Can you then change some of 
> that data in that pared down file and still have the problem? By simplifying 
> you can often more easily find the source of the problem and also might be 
> able to share your csv file when it reaches the point where the data in it is 
> no longer personal.
> 
> Sincerely,
> 
> Vincent Dawans
> 
> On Mon, Jul 3, 2023 at 3:35 PM Tom Olin via gnucash-user 
> mailto:gnucash-user@gnucash.org>> wrote:
> I would add that I’m more inclined to attribute the problem to GnuCash logic. 
> However, the code will require a lot of study on my part before I can make 
> meaningful sense of it. I just wish I could think of some possible logic that 
> might explain it.
> 
> --
> Tom
> 
> Money is created out of thin air when banks loan and when the federal 
> government spends. Money is destroyed into thin air when bank loans are 
> repaid and when federal taxes are paid.
> 
> > On Jul 3, 2023, at 5:41 PM, Ken Pyzik  > <mailto:py...@outlook.com>> wrote:
> > 
> > Tom -- I believe at the beginning of 2022, QuickBooks went from being a 
> > desktop and online software package  - to being strictly/only online.  With 
> > that transition, I believe they also gave a one-year period where you could 
> > export data.  While this may be a stretch, I believe that they may have 
> > somehow added a change flag or some other thing to the data to prevent you 
> > from exporting it as easy as it used to be.  This could be the discrepancy 
> > you are experiencing.  In other words, to prevent people from doing what 
> > you are exactly trying to do -- they may have placed a simple data offset 
> > or some other thing into the data to prevent easy export.  Again, this 
> > could be a stretch -- but it would explain why one year comes over 
> > correctly and the next does not.  Just my two cents -- for what it is worth 
> > ( which could be nothing at all!)
> > 
> > Ken   
> > 
> > -Original Message-
> > From: gnucash-user  > <mailto:outlook....@gnucash.org>> On Behalf Of Tom Olin via gnucash-user
> > Sent: Monday, July 3, 2023 1:55 PM
> > To: Kalpesh Patel mailto:kalpesh.pa...@usa.net>>
> > Cc: gnucash-user@gnucash.org <mailto: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 need THEIR money, not 
> > because they need yours.
> > 
> >> On Jul 3, 2023, at 4:52 PM, Kalpesh Patel  >> <mailto:kalpesh.pa...@usa.net>> wrote:
> >> 
> >> I am likely grasping straws here like David but did you verify the format 
> >> of the date that it is consistent throughout? Like it isn’t switching from 
> >> two digits to four digits, or replace certain digits with place holders, 
> >> etc. QuickBooks is (was?) published by the maker of Quicken and I remember 
> >> their exports when it came to Quicken was all over the map for the format 
> >> of the date and ended up normalizing it with an external script when I did 
> >> a full migration from Quicken to GNC. By far this, the date format, was 
> >> biggest PITA.
> >> 
> >> -Original Message-
> >> From: Tom Olin mailto:t...@tomolin.net>> 
> >> Sent: Monday, July 03, 2023 12:14 PM
> >> To: Jean L mailto:rip...@gmail.com>>
> >> Cc: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
> >> Subject: Re: [GNC] Importing data from QuickBooks Online
> >> 
> >>

Re: [GNC] Importing data from QuickBooks Online

[Vincent Dawans]

Tom:

I haven't read every single email in this thread but have this advice for
you to further diagnose. When I face a puzzle like this, I like to try
creating the simplest possible scenario in which I am still able to
reproduce the problem. In this case this would start by figuring out how
far you can pare down your 2022 csv file while still having the problem.
Can you pair it down to just a few transactions, like 5 or 10 max?  Can you
then change some of that data in that pared down file and still have the
problem? By simplifying you can often more easily find the source of the
problem and also might be able to share your csv file when it reaches the
point where the data in it is no longer personal.

Sincerely,

Vincent Dawans

On Mon, Jul 3, 2023 at 3:35 PM Tom Olin via gnucash-user <
gnucash-user@gnucash.org> wrote:

> I would add that I’m more inclined to attribute the problem to GnuCash
> logic. However, the code will require a lot of study on my part before I
> can make meaningful sense of it. I just wish I could think of some possible
> logic that might explain it.
>
> --
> Tom
>
> Money is created out of thin air when banks loan and when the federal
> government spends. Money is destroyed into thin air when bank loans are
> repaid and when federal taxes are paid.
>
> > On Jul 3, 2023, at 5:41 PM, Ken Pyzik  wrote:
> >
> > Tom -- I believe at the beginning of 2022, QuickBooks went from being a
> desktop and online software package  - to being strictly/only online.  With
> that transition, I believe they also gave a one-year period where you could
> export data.  While this may be a stretch, I believe that they may have
> somehow added a change flag or some other thing to the data to prevent you
> from exporting it as easy as it used to be.  This could be the discrepancy
> you are experiencing.  In other words, to prevent people from doing what
> you are exactly trying to do -- they may have placed a simple data offset
> or some other thing into the data to prevent easy export.  Again, this
> could be a stretch -- but it would explain why one year comes over
> correctly and the next does not.  Just my two cents -- for what it is worth
> ( which could be nothing at all!)
> >
> > Ken
> >
> > -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 formats are consistent.
> >
> > --
> > Tom
> >
> > The federal government imposes a tax on you so YOU need THEIR money, not
> because they need yours.
> >
> >> On Jul 3, 2023, at 4:52 PM, Kalpesh Patel 
> wrote:
> >>
> >> I am likely grasping straws here like David but did you verify the
> format of the date that it is consistent throughout? Like it isn’t
> switching from two digits to four digits, or replace certain digits with
> place holders, etc. QuickBooks is (was?) published by the maker of Quicken
> and I remember their exports when it came to Quicken was all over the map
> for the format of the date and ended up normalizing it with an external
> script when I did a full migration from Quicken to GNC. By far this, the
> date format, was biggest PITA.
> >>
> >> -Original Message-
> >> From: Tom Olin 
> >> Sent: Monday, 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 of QuickBooks Online.
> >>
> >> As it turns out, my minimal script seems to work very well with this
> one weird anomaly. The nature of it suggests something that should be
> easily worked around - if I can just figure out what it is.
> >>
> >> --
> >> Tom
> >>
> >> Federal tax dollars don’t exist. Federal spending creates dollars out
> of thin air. With federal tax payments, the opposite occurs.
> >>
> >>> On Jul 3, 2023, at 12:04 PM, Jean L  wrote:
> >>>
> >>> This may be slightly off topic, or too late to help, but...
> >>>
> >>> In github, there is a repository
> >>> https://github.com/tim-rohrer/move2gnucash
> >>> That seems pretty well setup to migrate your data from a quicken csv
> export to GC. I haven't used it, but I looked at it for a friend and it
> looked i

Re: [GNC] Importing data from QuickBooks Online

[Tom Olin via gnucash-user]

I would add that I’m more inclined to attribute the problem to GnuCash logic. 
However, the code will require a lot of study on my part before I can make 
meaningful sense of it. I just wish I could think of some possible logic that 
might explain it.

--
Tom

Money is created out of thin air when banks loan and when the federal 
government spends. Money is destroyed into thin air when bank loans are repaid 
and when federal taxes are paid.

> On Jul 3, 2023, at 5:41 PM, Ken Pyzik  wrote:
> 
> Tom -- I believe at the beginning of 2022, QuickBooks went from being a 
> desktop and online software package  - to being strictly/only online.  With 
> that transition, I believe they also gave a one-year period where you could 
> export data.  While this may be a stretch, I believe that they may have 
> somehow added a change flag or some other thing to the data to prevent you 
> from exporting it as easy as it used to be.  This could be the discrepancy 
> you are experiencing.  In other words, to prevent people from doing what you 
> are exactly trying to do -- they may have placed a simple data offset or some 
> other thing into the data to prevent easy export.  Again, this could be a 
> stretch -- but it would explain why one year comes over correctly and the 
> next does not.  Just my two cents -- for what it is worth ( which could be 
> nothing at all!)
> 
> Ken   
> 
> -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 formats are consistent.
> 
> --
> Tom
> 
> The federal government imposes a tax on you so YOU need THEIR money, not 
> because they need yours.
> 
>> On Jul 3, 2023, at 4:52 PM, Kalpesh Patel  wrote:
>> 
>> I am likely grasping straws here like David but did you verify the format of 
>> the date that it is consistent throughout? Like it isn’t switching from two 
>> digits to four digits, or replace certain digits with place holders, etc. 
>> QuickBooks is (was?) published by the maker of Quicken and I remember their 
>> exports when it came to Quicken was all over the map for the format of the 
>> date and ended up normalizing it with an external script when I did a full 
>> migration from Quicken to GNC. By far this, the date format, was biggest 
>> PITA.
>> 
>> -Original Message-
>> From: Tom Olin  
>> Sent: Monday, 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 of QuickBooks Online.
>> 
>> As it turns out, my minimal script seems to work very well with this one 
>> weird anomaly. The nature of it suggests something that should be easily 
>> worked around - if I can just figure out what it is.
>> 
>> --
>> Tom
>> 
>> Federal tax dollars don’t exist. Federal spending creates dollars out of 
>> thin air. With federal tax payments, the opposite occurs.
>> 
>>> On Jul 3, 2023, at 12:04 PM, Jean L  wrote:
>>> 
>>> This may be slightly off topic, or too late to help, but...
>>> 
>>> In github, there is a repository
>>> https://github.com/tim-rohrer/move2gnucash
>>> That seems pretty well setup to migrate your data from a quicken csv export 
>>> to GC. I haven't used it, but I looked at it for a friend and it looked 
>>> interesting.
>>> 
>>> Jean
>>> 
>>> On 7/3/2023 8:59 AM, Tom Olin via gnucash-user wrote:
>>>> [Resending to the list. Original reply went only to Jim.]
>>>> 
>>>> Jim,
>>>> 
>>>> Fair questions. Answers below, and I’ve attached the script itself which 
>>>> includes documentation which addresses some of the questions. I’ve 
>>>> reviewed all documentation that I can find.
>>>> 
>>>> From QBO, I export a journal report to XLS (only usable option in QBO).
>>>> 
>>>> GnuCash 5.3 on macOS 11.7.8
>>>> 
>>>> See the script for the specific steps.
>>>> 
>>>> The import matcher step of the import process is fully satisfied. That is 
>>>> the step labeled “Match Import and GnuCash accounts”.
>>>> 
>>>> The  problem manifests at the “Match Transactions” screen where all 
>

Re: [GNC] Importing data from QuickBooks Online

[Tom Olin via gnucash-user]

Ken,

That’s a better theory than anything I’ve come up with so far. However, that 
would seem to get it backwards. Presumably, they might allow export of 2022 but 
not 2023. In my case, it was 2022 that failed.

If they managed to do something like that, how might they do it? The only idea 
I come up with would be some invisible characters in the text. But analysis 
shows no such characters.

Thanks for the suggestion.

--
Tom

A forest has no "value" to capitalism until it is cut down.

> On Jul 3, 2023, at 5:41 PM, Ken Pyzik  wrote:
> 
> Tom -- I believe at the beginning of 2022, QuickBooks went from being a 
> desktop and online software package  - to being strictly/only online.  With 
> that transition, I believe they also gave a one-year period where you could 
> export data.  While this may be a stretch, I believe that they may have 
> somehow added a change flag or some other thing to the data to prevent you 
> from exporting it as easy as it used to be.  This could be the discrepancy 
> you are experiencing.  In other words, to prevent people from doing what you 
> are exactly trying to do -- they may have placed a simple data offset or some 
> other thing into the data to prevent easy export.  Again, this could be a 
> stretch -- but it would explain why one year comes over correctly and the 
> next does not.  Just my two cents -- for what it is worth ( which could be 
> nothing at all!)
> 
> Ken   
> 
> -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 formats are consistent.
> 
> --
> Tom
> 
> The federal government imposes a tax on you so YOU need THEIR money, not 
> because they need yours.
> 
>> On Jul 3, 2023, at 4:52 PM, Kalpesh Patel  wrote:
>> 
>> I am likely grasping straws here like David but did you verify the format of 
>> the date that it is consistent throughout? Like it isn’t switching from two 
>> digits to four digits, or replace certain digits with place holders, etc. 
>> QuickBooks is (was?) published by the maker of Quicken and I remember their 
>> exports when it came to Quicken was all over the map for the format of the 
>> date and ended up normalizing it with an external script when I did a full 
>> migration from Quicken to GNC. By far this, the date format, was biggest 
>> PITA.
>> 
>> -Original Message-
>> From: Tom Olin  
>> Sent: Monday, 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 of QuickBooks Online.
>> 
>> As it turns out, my minimal script seems to work very well with this one 
>> weird anomaly. The nature of it suggests something that should be easily 
>> worked around - if I can just figure out what it is.
>> 
>> --
>> Tom
>> 
>> Federal tax dollars don’t exist. Federal spending creates dollars out of 
>> thin air. With federal tax payments, the opposite occurs.
>> 
>>> On Jul 3, 2023, at 12:04 PM, Jean L  wrote:
>>> 
>>> This may be slightly off topic, or too late to help, but...
>>> 
>>> In github, there is a repository
>>> https://github.com/tim-rohrer/move2gnucash
>>> That seems pretty well setup to migrate your data from a quicken csv export 
>>> to GC. I haven't used it, but I looked at it for a friend and it looked 
>>> interesting.
>>> 
>>> Jean
>>> 
>>> On 7/3/2023 8:59 AM, Tom Olin via gnucash-user wrote:
>>>> [Resending to the list. Original reply went only to Jim.]
>>>> 
>>>> Jim,
>>>> 
>>>> Fair questions. Answers below, and I’ve attached the script itself which 
>>>> includes documentation which addresses some of the questions. I’ve 
>>>> reviewed all documentation that I can find.
>>>> 
>>>> From QBO, I export a journal report to XLS (only usable option in QBO).
>>>> 
>>>> GnuCash 5.3 on macOS 11.7.8
>>>> 
>>>> See the script for the specific steps.
>>>> 
>>>> The import matcher step of the import process is fully satisfied. That is 
>>>> the step labeled “Match Import and GnuCash accounts”.
>>>> 
>>>> The  problem mani

Re: [GNC] Importing data from QuickBooks Online

[Ken Pyzik]

Tom -- I believe at the beginning of 2022, QuickBooks went from being a desktop 
and online software package  - to being strictly/only online.  With that 
transition, I believe they also gave a one-year period where you could export 
data.  While this may be a stretch, I believe that they may have somehow added 
a change flag or some other thing to the data to prevent you from exporting it 
as easy as it used to be.  This could be the discrepancy you are experiencing.  
In other words, to prevent people from doing what you are exactly trying to do 
-- they may have placed a simple data offset or some other thing into the data 
to prevent easy export.  Again, this could be a stretch -- but it would explain 
why one year comes over correctly and the next does not.  Just my two cents -- 
for what it is worth ( which could be nothing at all!)

Ken   

-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 formats are consistent.

--
Tom

The federal government imposes a tax on you so YOU need THEIR money, not 
because they need yours.

> On Jul 3, 2023, at 4:52 PM, Kalpesh Patel  wrote:
> 
> I am likely grasping straws here like David but did you verify the format of 
> the date that it is consistent throughout? Like it isn’t switching from two 
> digits to four digits, or replace certain digits with place holders, etc. 
> QuickBooks is (was?) published by the maker of Quicken and I remember their 
> exports when it came to Quicken was all over the map for the format of the 
> date and ended up normalizing it with an external script when I did a full 
> migration from Quicken to GNC. By far this, the date format, was biggest PITA.
> 
> -Original Message-
> From: Tom Olin  
> Sent: Monday, 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 of QuickBooks Online.
> 
> As it turns out, my minimal script seems to work very well with this one 
> weird anomaly. The nature of it suggests something that should be easily 
> worked around - if I can just figure out what it is.
> 
> --
> Tom
> 
> Federal tax dollars don’t exist. Federal spending creates dollars out of thin 
> air. With federal tax payments, the opposite occurs.
> 
>> On Jul 3, 2023, at 12:04 PM, Jean L  wrote:
>> 
>> This may be slightly off topic, or too late to help, but...
>> 
>> In github, there is a repository
>> https://github.com/tim-rohrer/move2gnucash
>> That seems pretty well setup to migrate your data from a quicken csv export 
>> to GC. I haven't used it, but I looked at it for a friend and it looked 
>> interesting.
>> 
>> Jean
>> 
>> On 7/3/2023 8:59 AM, Tom Olin via gnucash-user wrote:
>>> [Resending to the list. Original reply went only to Jim.]
>>> 
>>> Jim,
>>> 
>>> Fair questions. Answers below, and I’ve attached the script itself which 
>>> includes documentation which addresses some of the questions. I’ve reviewed 
>>> all documentation that I can find.
>>> 
>>> From QBO, I export a journal report to XLS (only usable option in QBO).
>>> 
>>> GnuCash 5.3 on macOS 11.7.8
>>> 
>>> See the script for the specific steps.
>>> 
>>> The import matcher step of the import process is fully satisfied. That is 
>>> the step labeled “Match Import and GnuCash accounts”.
>>> 
>>> The  problem manifests at the “Match Transactions” screen where all 
>>> transactions need to be matched. I’ve attached a screenshot if it is 
>>> supported here.
>>> 
>>> One more data point: 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:
>>>> 
>>>> Tom:
>>>> 
>>>> 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.
>>>> What format is the data which you export from Quickbooks Online? CSV 
>>>> (Comma Separated Values text files with tabular data)? QFX (Quicken 
>>>&g

Re: [GNC] Importing data from QuickBooks Online

[Tom Olin via gnucash-user]

Good shot, but no, date formats are consistent.

--
Tom

The federal government imposes a tax on you so YOU need THEIR money, not 
because they need yours.

> On Jul 3, 2023, at 4:52 PM, Kalpesh Patel  wrote:
> 
> I am likely grasping straws here like David but did you verify the format of 
> the date that it is consistent throughout? Like it isn’t switching from two 
> digits to four digits, or replace certain digits with place holders, etc. 
> QuickBooks is (was?) published by the maker of Quicken and I remember their 
> exports when it came to Quicken was all over the map for the format of the 
> date and ended up normalizing it with an external script when I did a full 
> migration from Quicken to GNC. By far this, the date format, was biggest PITA.
> 
> -Original Message-
> From: Tom Olin  
> Sent: Monday, 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 of QuickBooks Online.
> 
> As it turns out, my minimal script seems to work very well with this one 
> weird anomaly. The nature of it suggests something that should be easily 
> worked around - if I can just figure out what it is.
> 
> --
> Tom
> 
> Federal tax dollars don’t exist. Federal spending creates dollars out of thin 
> air. With federal tax payments, the opposite occurs.
> 
>> On Jul 3, 2023, at 12:04 PM, Jean L  wrote:
>> 
>> This may be slightly off topic, or too late to help, but...
>> 
>> In github, there is a repository
>> https://github.com/tim-rohrer/move2gnucash
>> That seems pretty well setup to migrate your data from a quicken csv export 
>> to GC. I haven't used it, but I looked at it for a friend and it looked 
>> interesting.
>> 
>> Jean
>> 
>> On 7/3/2023 8:59 AM, Tom Olin via gnucash-user wrote:
>>> [Resending to the list. Original reply went only to Jim.]
>>> 
>>> Jim,
>>> 
>>> Fair questions. Answers below, and I’ve attached the script itself which 
>>> includes documentation which addresses some of the questions. I’ve reviewed 
>>> all documentation that I can find.
>>> 
>>> From QBO, I export a journal report to XLS (only usable option in QBO).
>>> 
>>> GnuCash 5.3 on macOS 11.7.8
>>> 
>>> See the script for the specific steps.
>>> 
>>> The import matcher step of the import process is fully satisfied. That is 
>>> the step labeled “Match Import and GnuCash accounts”.
>>> 
>>> The  problem manifests at the “Match Transactions” screen where all 
>>> transactions need to be matched. I’ve attached a screenshot if it is 
>>> supported here.
>>> 
>>> One more data point: 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:
>>>> 
>>>> Tom:
>>>> 
>>>> 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.
>>>> 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 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 cleanly, but all 2022 transactions import unbalanced, 
>>>>> meaning I have to manually match up each of them - doable but tedious.
>>>> Let's assume you are exporting data in CSV format, and using the current 
>>>> version of GnuCash (5.3), and importing using the File… Import… Import 
>>>> Transactions from CSV menu item. You should be directed through an import 
>>>> matcher. This is the place where GnuCash should assign accounts to balance 
>>>> each transaction. Is each transaction assigned to an account in the import 
>>>> matcher?
>>>> 
>>>> Have you read the section 

Re: [GNC] Importing data from QuickBooks Online

[Kalpesh Patel]

I am likely grasping straws here like David but did you verify the format of 
the date that it is consistent throughout? Like it isn’t switching from two 
digits to four digits, or replace certain digits with place holders, etc. 
QuickBooks is (was?) published by the maker of Quicken and I remember their 
exports when it came to Quicken was all over the map for the format of the date 
and ended up normalizing it with an external script when I did a full migration 
from Quicken to GNC. By far this, the date format, was biggest PITA.

-Original Message-
From: Tom Olin  
Sent: Monday, 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 of QuickBooks Online.

As it turns out, my minimal script seems to work very well with this one weird 
anomaly. The nature of it suggests something that should be easily worked 
around - if I can just figure out what it is.

--
Tom

Federal tax dollars don’t exist. Federal spending creates dollars out of thin 
air. With federal tax payments, the opposite occurs.

> On Jul 3, 2023, at 12:04 PM, Jean L  wrote:
> 
> This may be slightly off topic, or too late to help, but...
> 
> In github, there is a repository
> https://github.com/tim-rohrer/move2gnucash
> That seems pretty well setup to migrate your data from a quicken csv export 
> to GC. I haven't used it, but I looked at it for a friend and it looked 
> interesting.
> 
> Jean
> 
> On 7/3/2023 8:59 AM, Tom Olin via gnucash-user wrote:
>> [Resending to the list. Original reply went only to Jim.]
>> 
>> Jim,
>> 
>> Fair questions. Answers below, and I’ve attached the script itself which 
>> includes documentation which addresses some of the questions. I’ve reviewed 
>> all documentation that I can find.
>> 
>> From QBO, I export a journal report to XLS (only usable option in QBO).
>> 
>> GnuCash 5.3 on macOS 11.7.8
>> 
>> See the script for the specific steps.
>> 
>> The import matcher step of the import process is fully satisfied. That is 
>> the step labeled “Match Import and GnuCash accounts”.
>> 
>> The  problem manifests at the “Match Transactions” screen where all 
>> transactions need to be matched. I’ve attached a screenshot if it is 
>> supported here.
>> 
>> One more data point: 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:
>>> 
>>> Tom:
>>> 
>>> 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.
>>> 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 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 cleanly, but all 2022 transactions import unbalanced, 
>>>> meaning I have to manually match up each of them - doable but tedious.
>>> Let's assume you are exporting data in CSV format, and using the current 
>>> version of GnuCash (5.3), and importing using the File… Import… Import 
>>> Transactions from CSV menu item. You should be directed through an import 
>>> matcher. This is the place where GnuCash should assign accounts to balance 
>>> each transaction. Is each transaction assigned to an account in the import 
>>> matcher?
>>> 
>>> Have you read the section of the documentation explaining how to import 
>>> data?
>>> 
>>>> Can anyone think of anything that would cause this behavior? I’ve ruled 
>>>> out Accounting Period. I’ve imported each year separately. I’ve exported 
>>>> each year separately from QBO. The behavior persists.
>>>> 
>>>> I’m stumped. Any ideas?
>>> I hope these questions help get enough information on the table to give 
>>> someone ideas.
>>> 
>>> Best regards,
>>>—Jim DeLaHunt
>>> 
>>> 
>>> _

Re: [GNC] Importing data from QuickBooks Online

[Tom Olin via gnucash-user]

All records came from the same account tree at the same time.

We need more straws!!! :-)

--
Tom

How many dollars would you own if the federal government had balanced its 
budget every year since the founding of our country? (Hint: It’s an exact 
number.)

> On Jul 3, 2023, at 2:32 PM, David Reiser  wrote:
> 
> Really grasping at straws now, but invisible characters/extra spaces in the 
> 2022 account names?
> --
> Dave Reiser
> dbrei...@icloud.com
> 
> 
> 
> 
> 
>> On Jul 3, 2023, at 12:29 PM, Tom Olin  wrote:
>> 
>> David,
>> 
>> Both import files were generated from the same 2-year QBO export, so they 
>> have identical structure. The process was:
>> 
>>  QBO export -> convert to CVS -> my script -> unified import file (CVS)
>> 
>> The problem occurred identically whether I imported the unified file or just 
>> the 2022 data portion.
>> 
>> I tried changing a 2023 transaction to 2022 and it imported correctly.
>> 
>> --
>> Tom
>> 
>> For the government, which came first? (a) first $ taxed; (b) first $ 
>> borrowed; (c) first $ spent. (Hint: state or federal?)
>> 
>>> On Jul 3, 2023, at 12:11 PM, David Reiser  wrote:
>>> 
>>> So, the year isn’t the sticking point. If you look at the .xls files — one 
>>> transaction from 2022 and one from 2023 — do you see a difference? If you 
>>> move a 2023 transaction to 2022, does it import correctly, or fail? I’m 
>>> guessing there’s a column missing in the 2022 xls file.
>>> 
>>> --
>>> Dave Reiser
>>> dbrei...@icloud.com
>>> 
>>> 
>>> 
>>> 
 On Jul 3, 2023, at 11:59 AM, Tom Olin via gnucash-user 
  wrote:
 
 [Resending to the list. Original reply went only to Jim.]
 
 Jim,
 
 Fair questions. Answers below, and I’ve attached the script itself which 
 includes documentation which addresses some of the questions. I’ve 
 reviewed all documentation that I can find.
 
 From QBO, I export a journal report to XLS (only usable option in QBO).
 
 GnuCash 5.3 on macOS 11.7.8
 
 See the script for the specific steps.
 
 The import matcher step of the import process is fully satisfied. That is 
 the step labeled “Match Import and GnuCash accounts”.
 
 The  problem manifests at the “Match Transactions” screen where all 
 transactions need to be matched. I’ve attached a screenshot if it is 
 supported here.
 
 One more data point: 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:
> 
> Tom:
> 
> 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.
> 
> 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 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 cleanly, but all 2022 transactions import 
>> unbalanced, meaning I have to manually match up each of them - doable 
>> but tedious.
> 
> Let's assume you are exporting data in CSV format, and using the current 
> version of GnuCash (5.3), and importing using the File… Import… Import 
> Transactions from CSV menu item. You should be directed through an import 
> matcher. This is the place where GnuCash should assign accounts to 
> balance each transaction. Is each transaction assigned to an account in 
> the import matcher?
> 
> Have you read the section of the documentation explaining how to import 
> data?
> 
>> Can anyone think of anything that would cause this behavior? I’ve ruled 
>> out Accounting Period. I’ve imported each year separately. I’ve exported 
>> each year separately from QBO. The behavior persists.
>> 
>> I’m stumped. Any ideas?
> 
> I hope these questions help get enough information on the table to give 
> someone ideas.
> 
> Best regards,
> —Jim DeLaHunt
> 
>>> 
>> 
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing data from QuickBooks Online

[David Reiser via gnucash-user]

Really grasping at straws now, but invisible characters/extra spaces in the 
2022 account names?
--
Dave Reiser
dbrei...@icloud.com





> On Jul 3, 2023, at 12:29 PM, Tom Olin  wrote:
> 
> David,
> 
> Both import files were generated from the same 2-year QBO export, so they 
> have identical structure. The process was:
> 
>   QBO export -> convert to CVS -> my script -> unified import file (CVS)
> 
> The problem occurred identically whether I imported the unified file or just 
> the 2022 data portion.
> 
> I tried changing a 2023 transaction to 2022 and it imported correctly.
> 
> --
> Tom
> 
> For the government, which came first? (a) first $ taxed; (b) first $ 
> borrowed; (c) first $ spent. (Hint: state or federal?)
> 
>> On Jul 3, 2023, at 12:11 PM, David Reiser  wrote:
>> 
>> So, the year isn’t the sticking point. If you look at the .xls files — one 
>> transaction from 2022 and one from 2023 — do you see a difference? If you 
>> move a 2023 transaction to 2022, does it import correctly, or fail? I’m 
>> guessing there’s a column missing in the 2022 xls file.
>> 
>> --
>> Dave Reiser
>> dbrei...@icloud.com
>> 
>> 
>> 
>> 
>>> On Jul 3, 2023, at 11:59 AM, Tom Olin via gnucash-user 
>>>  wrote:
>>> 
>>> [Resending to the list. Original reply went only to Jim.]
>>> 
>>> Jim,
>>> 
>>> Fair questions. Answers below, and I’ve attached the script itself which 
>>> includes documentation which addresses some of the questions. I’ve reviewed 
>>> all documentation that I can find.
>>> 
>>> From QBO, I export a journal report to XLS (only usable option in QBO).
>>> 
>>> GnuCash 5.3 on macOS 11.7.8
>>> 
>>> See the script for the specific steps.
>>> 
>>> The import matcher step of the import process is fully satisfied. That is 
>>> the step labeled “Match Import and GnuCash accounts”.
>>> 
>>> The  problem manifests at the “Match Transactions” screen where all 
>>> transactions need to be matched. I’ve attached a screenshot if it is 
>>> supported here.
>>> 
>>> One more data point: 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:
 
 Tom:
 
 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.
 
 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 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 cleanly, but all 2022 transactions import unbalanced, 
> meaning I have to manually match up each of them - doable but tedious.
 
 Let's assume you are exporting data in CSV format, and using the current 
 version of GnuCash (5.3), and importing using the File… Import… Import 
 Transactions from CSV menu item. You should be directed through an import 
 matcher. This is the place where GnuCash should assign accounts to balance 
 each transaction. Is each transaction assigned to an account in the import 
 matcher?
 
 Have you read the section of the documentation explaining how to import 
 data?
 
> Can anyone think of anything that would cause this behavior? I’ve ruled 
> out Accounting Period. I’ve imported each year separately. I’ve exported 
> each year separately from QBO. The behavior persists.
> 
> I’m stumped. Any ideas?
 
 I hope these questions help get enough information on the table to give 
 someone ideas.
 
 Best regards,
  —Jim DeLaHunt
 
>> 
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing data from QuickBooks Online

[Tom Olin via gnucash-user]

David,

Both import files were generated from the same 2-year QBO export, so they have 
identical structure. The process was:

QBO export -> convert to CVS -> my script -> unified import file (CVS)

The problem occurred identically whether I imported the unified file or just 
the 2022 data portion.

I tried changing a 2023 transaction to 2022 and it imported correctly.

--
Tom

For the government, which came first? (a) first $ taxed; (b) first $ borrowed; 
(c) first $ spent. (Hint: state or federal?)

> On Jul 3, 2023, at 12:11 PM, David Reiser  wrote:
> 
> So, the year isn’t the sticking point. If you look at the .xls files — one 
> transaction from 2022 and one from 2023 — do you see a difference? If you 
> move a 2023 transaction to 2022, does it import correctly, or fail? I’m 
> guessing there’s a column missing in the 2022 xls file.
> 
> --
> Dave Reiser
> dbrei...@icloud.com
> 
> 
> 
> 
>> On Jul 3, 2023, at 11:59 AM, Tom Olin via gnucash-user 
>>  wrote:
>> 
>> [Resending to the list. Original reply went only to Jim.]
>> 
>> Jim,
>> 
>> Fair questions. Answers below, and I’ve attached the script itself which 
>> includes documentation which addresses some of the questions. I’ve reviewed 
>> all documentation that I can find.
>> 
>> From QBO, I export a journal report to XLS (only usable option in QBO).
>> 
>> GnuCash 5.3 on macOS 11.7.8
>> 
>> See the script for the specific steps.
>> 
>> The import matcher step of the import process is fully satisfied. That is 
>> the step labeled “Match Import and GnuCash accounts”.
>> 
>> The  problem manifests at the “Match Transactions” screen where all 
>> transactions need to be matched. I’ve attached a screenshot if it is 
>> supported here.
>> 
>> One more data point: 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:
>>> 
>>> Tom:
>>> 
>>> 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.
>>> 
>>> 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 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 cleanly, but all 2022 transactions import unbalanced, 
 meaning I have to manually match up each of them - doable but tedious.
>>> 
>>> Let's assume you are exporting data in CSV format, and using the current 
>>> version of GnuCash (5.3), and importing using the File… Import… Import 
>>> Transactions from CSV menu item. You should be directed through an import 
>>> matcher. This is the place where GnuCash should assign accounts to balance 
>>> each transaction. Is each transaction assigned to an account in the import 
>>> matcher?
>>> 
>>> Have you read the section of the documentation explaining how to import 
>>> data?
>>> 
 Can anyone think of anything that would cause this behavior? I’ve ruled 
 out Accounting Period. I’ve imported each year separately. I’ve exported 
 each year separately from QBO. The behavior persists.
 
 I’m stumped. Any ideas?
>>> 
>>> I hope these questions help get enough information on the table to give 
>>> someone ideas.
>>> 
>>> Best regards,
>>>   —Jim DeLaHunt
>>> 
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing data from QuickBooks Online

[Tom Olin via gnucash-user]

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 of QuickBooks Online.

As it turns out, my minimal script seems to work very well with this one weird 
anomaly. The nature of it suggests something that should be easily worked 
around - if I can just figure out what it is.

--
Tom

Federal tax dollars don’t exist. Federal spending creates dollars out of thin 
air. With federal tax payments, the opposite occurs.

> On Jul 3, 2023, at 12:04 PM, Jean L  wrote:
> 
> This may be slightly off topic, or too late to help, but...
> 
> In github, there is a repository
> https://github.com/tim-rohrer/move2gnucash
> That seems pretty well setup to migrate your data from a quicken csv export 
> to GC. I haven't used it, but I looked at it for a friend and it looked 
> interesting.
> 
> Jean
> 
> On 7/3/2023 8:59 AM, Tom Olin via gnucash-user wrote:
>> [Resending to the list. Original reply went only to Jim.]
>> 
>> Jim,
>> 
>> Fair questions. Answers below, and I’ve attached the script itself which 
>> includes documentation which addresses some of the questions. I’ve reviewed 
>> all documentation that I can find.
>> 
>> From QBO, I export a journal report to XLS (only usable option in QBO).
>> 
>> GnuCash 5.3 on macOS 11.7.8
>> 
>> See the script for the specific steps.
>> 
>> The import matcher step of the import process is fully satisfied. That is 
>> the step labeled “Match Import and GnuCash accounts”.
>> 
>> The  problem manifests at the “Match Transactions” screen where all 
>> transactions need to be matched. I’ve attached a screenshot if it is 
>> supported here.
>> 
>> One more data point: 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:
>>> 
>>> Tom:
>>> 
>>> 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.
>>> 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 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 cleanly, but all 2022 transactions import unbalanced, 
 meaning I have to manually match up each of them - doable but tedious.
>>> Let's assume you are exporting data in CSV format, and using the current 
>>> version of GnuCash (5.3), and importing using the File… Import… Import 
>>> Transactions from CSV menu item. You should be directed through an import 
>>> matcher. This is the place where GnuCash should assign accounts to balance 
>>> each transaction. Is each transaction assigned to an account in the import 
>>> matcher?
>>> 
>>> Have you read the section of the documentation explaining how to import 
>>> data?
>>> 
 Can anyone think of anything that would cause this behavior? I’ve ruled 
 out Accounting Period. I’ve imported each year separately. I’ve exported 
 each year separately from QBO. The behavior persists.
 
 I’m stumped. Any ideas?
>>> I hope these questions help get enough information on the table to give 
>>> someone ideas.
>>> 
>>> Best regards,
>>>—Jim DeLaHunt
>>> 
>>> 
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>> 
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or 

Re: [GNC] Importing data from QuickBooks Online

[David Reiser via gnucash-user]

So, the year isn’t the sticking point. If you look at the .xls files — one 
transaction from 2022 and one from 2023 — do you see a difference? If you move 
a 2023 transaction to 2022, does it import correctly, or fail? I’m guessing 
there’s a column missing in the 2022 xls file.

--
Dave Reiser
dbrei...@icloud.com




> On Jul 3, 2023, at 11:59 AM, Tom Olin via gnucash-user 
>  wrote:
> 
> [Resending to the list. Original reply went only to Jim.]
> 
> Jim,
> 
> Fair questions. Answers below, and I’ve attached the script itself which 
> includes documentation which addresses some of the questions. I’ve reviewed 
> all documentation that I can find.
> 
> From QBO, I export a journal report to XLS (only usable option in QBO).
> 
> GnuCash 5.3 on macOS 11.7.8
> 
> See the script for the specific steps.
> 
> The import matcher step of the import process is fully satisfied. That is the 
> step labeled “Match Import and GnuCash accounts”.
> 
> The  problem manifests at the “Match Transactions” screen where all 
> transactions need to be matched. I’ve attached a screenshot if it is 
> supported here.
> 
> One more data point: 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:
>> 
>> Tom:
>> 
>> 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.
>> 
>> 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 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 cleanly, but all 2022 transactions import unbalanced, meaning I have 
>>> to manually match up each of them - doable but tedious.
>> 
>> Let's assume you are exporting data in CSV format, and using the current 
>> version of GnuCash (5.3), and importing using the File… Import… Import 
>> Transactions from CSV menu item. You should be directed through an import 
>> matcher. This is the place where GnuCash should assign accounts to balance 
>> each transaction. Is each transaction assigned to an account in the import 
>> matcher?
>> 
>> Have you read the section of the documentation explaining how to import data?
>> 
>>> Can anyone think of anything that would cause this behavior? I’ve ruled out 
>>> Accounting Period. I’ve imported each year separately. I’ve exported each 
>>> year separately from QBO. The behavior persists.
>>> 
>>> I’m stumped. Any ideas?
>> 
>> I hope these questions help get enough information on the table to give 
>> someone ideas.
>> 
>> Best regards,
>>   —Jim DeLaHunt
>> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing data from QuickBooks Online

[Jean L]

This may be slightly off topic, or too late to help, but...

In github, there is a repository
https://github.com/tim-rohrer/move2gnucash
That seems pretty well setup to migrate your data from a quicken csv 
export to GC. I haven't used it, but I looked at it for a friend and it 
looked interesting.


Jean

On 7/3/2023 8:59 AM, Tom Olin via gnucash-user wrote:

[Resending to the list. Original reply went only to Jim.]

Jim,

Fair questions. Answers below, and I’ve attached the script itself which 
includes documentation which addresses some of the questions. I’ve reviewed all 
documentation that I can find.

 From QBO, I export a journal report to XLS (only usable option in QBO).

GnuCash 5.3 on macOS 11.7.8

See the script for the specific steps.

The import matcher step of the import process is fully satisfied. That is the 
step labeled “Match Import and GnuCash accounts”.

The  problem manifests at the “Match Transactions” screen where all 
transactions need to be matched. I’ve attached a screenshot if it is supported 
here.

One more data point: 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:

Tom:

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.

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 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 cleanly, but all 2022 transactions import unbalanced, meaning I have to 
manually match up each of them - doable but tedious.

Let's assume you are exporting data in CSV format, and using the current 
version of GnuCash (5.3), and importing using the File… Import… Import 
Transactions from CSV menu item. You should be directed through an import 
matcher. This is the place where GnuCash should assign accounts to balance each 
transaction. Is each transaction assigned to an account in the import matcher?

Have you read the section of the documentation explaining how to import data?


Can anyone think of anything that would cause this behavior? I’ve ruled out 
Accounting Period. I’ve imported each year separately. I’ve exported each year 
separately from QBO. The behavior persists.

I’m stumped. Any ideas?

I hope these questions help get enough information on the table to give someone 
ideas.

Best regards,
—Jim DeLaHunt


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing data from QuickBooks Online

[Jim DeLaHunt]

Tom:

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.


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 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 cleanly, but all 2022 transactions import unbalanced, meaning I have to 
manually match up each of them - doable but tedious.


Let's assume you are exporting data in CSV format, and using the current 
version of GnuCash (5.3), and importing using the File… Import… Import 
Transactions from CSV menu item. You should be directed through an 
import matcher. This is the place where GnuCash should assign accounts 
to balance each transaction. Is each transaction assigned to an account 
in the import matcher?


Have you read the section of the documentation explaining how to import 
data?



Can anyone think of anything that would cause this behavior? I’ve ruled out 
Accounting Period. I’ve imported each year separately. I’ve exported each year 
separately from QBO. The behavior persists.

I’m stumped. Any ideas?


I hope these questions help get enough information on the table to give 
someone ideas.


Best regards,
    —Jim DeLaHunt


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Importing data from QuickBooks Online

[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 have to 
manually match up each of them - doable but tedious.

Can anyone think of anything that would cause this behavior? I’ve ruled out 
Accounting Period. I’ve imported each year separately. I’ve exported each year 
separately from QBO. The behavior persists.

I’m stumped. Any ideas?

--
Tom

Federal spending funds taxes. It is impossible to pay taxes until the 
government has spent money into the economy.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing QFX

[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?
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing QFX

[Gyle McCollam]

There is a bug filed, but the fix is promised for 5.1.  I reverted back to 4.13 
until then.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email


From: gnucash-user  on 
behalf of Alan Schold via gnucash-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 update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Importing QFX

[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:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] importing

[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 them as cleared during a reconciliation process which will in 
either case, set them to 'y' when done.


Regards,
Adrien

On 2/16/23 5:53 PM, 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 they 
finally corrected the problem and billed me for the 6 months of gas this month. 
 However, when I imported the file it said there were no matching transactions. 
 I used preferences to change the import parameters, but I could not change the 
dates to allow for transactions that old.  I could set the proper expense 
account, but that would double up on the transaction.  Is there a way to click 
or double click on the import matcher and manually select the matching 
transaction?


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] importing

[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 thru 01/2023.  I imported 
the file and made the corrections in the reconciliation window.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email


From: David T. 
Sent: Friday, February 17, 2023 12:57 AM
To: Gyle McCollam 
Cc: David Reiser via gnucash-user ; ed...@billiau.net 

Subject: Re: [GNC] importing

With regard to the import process, were the source files OFX/QFX, by chance?

That file format includes unique transaction IDs to prevent reimport of 
previously imported transactions. Under the circumstances, I'd opt to manually 
enter the transactions in question and reconcile after.

David T.
On Feb 17, 2023, at 5:55 AM, Gyle McCollam 
mailto:gmccol...@live.com>> wrote:

Liz,
Yes, I record all my transactions and then match with bank, credit card, etc.  
In this case, I think it was the gas stations fault as it happened with 
multiple Mastercard's.  It was nice not having to pay for gas for 6 months, but 
this month the charges showed up on both cards.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email



From: gnucash-user 
http://gmail.com>@gnucash.org> on behalf 
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
 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 months of gas this month.  However, when I
 imported the file it said there were no matching transactions.  I
 used preferences to change the import parameters, but I could not
 change the dates to allow for transactions that old.  I could set the
 proper expense account, but that would double up on the transaction.
 Is there a way to click or double click on the import matcher and
 manually select the matching transaction?


 Thank You,

 Gyle McCollam

This is an interesting case. Are you recording the credit card
transactions in your books regardless of the errors of the credit card
company?
It is an example of the advantages of maintaining your record from your
receipts and entering the transactions, because then you would know
that money was owing, and how much.

If something takes more than about 18 months to show up I remove it
from active lists but preserve the data in case it turns up eventually.
I won't specify a method, because it has failings.

Liz


gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] importing

[David T. via gnucash-user]

With regard to the import process, were the source files OFX/QFX, by chance? 

That file format includes unique transaction IDs to prevent reimport of 
previously imported transactions. Under the circumstances, I'd opt to manually 
enter the transactions in question and reconcile after.  

David T. 



On Feb 17, 2023, 5:55 AM, at 5:55 AM, Gyle McCollam  wrote:
>Liz,
>Yes, I record all my transactions and then match with bank, credit
>card, etc.  In this case, I think it was the gas stations fault as it
>happened with multiple Mastercard's.  It was nice not having to pay for
>gas for 6 months, but this month the charges showed up on both cards.
>
>
>Thank You,
>
>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 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 they finally corrected the problem and
>> billed me for the 6 months of gas this month.  However, when I
>> imported the file it said there were no matching transactions.  I
>> used preferences to change the import parameters, but I could not
>> change the dates to allow for transactions that old.  I could set the
>> proper expense account, but that would double up on the transaction.
>> Is there a way to click or double click on the import matcher and
>> manually select the matching transaction?
>>
>>
>> Thank You,
>>
>> Gyle McCollam
>
>This is an interesting case. Are you recording the credit card
>transactions in your books regardless of the errors of the credit card
>company?
>It is an example of the advantages of maintaining your record from your
>receipts and entering the transactions, because then you would know
>that money was owing, and how much.
>
>If something takes more than about 18 months to show up I remove it
>from active lists but preserve the data in case it turns up eventually.
>I won't specify a method, because it has failings.
>
>Liz
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] importing

[Gyle McCollam]

Liz,
Yes, I record all my transactions and then match with bank, credit card, etc.  
In this case, I think it was the gas stations fault as it happened with 
multiple Mastercard's.  It was nice not having to pay for gas for 6 months, but 
this month the charges showed up on both cards.


Thank You,

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 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 they finally corrected the problem and
> billed me for the 6 months of gas this month.  However, when I
> imported the file it said there were no matching transactions.  I
> used preferences to change the import parameters, but I could not
> change the dates to allow for transactions that old.  I could set the
> proper expense account, but that would double up on the transaction.
> Is there a way to click or double click on the import matcher and
> manually select the matching transaction?
>
>
> Thank You,
>
> Gyle McCollam

This is an interesting case. Are you recording the credit card
transactions in your books regardless of the errors of the credit card
company?
It is an example of the advantages of maintaining your record from your
receipts and entering the transactions, because then you would know
that money was owing, and how much.

If something takes more than about 18 months to show up I remove it
from active lists but preserve the data in case it turns up eventually.
I won't specify a method, because it has failings.

Liz
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] importing

[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 they finally corrected the problem and
> billed me for the 6 months of gas this month.  However, when I
> imported the file it said there were no matching transactions.  I
> used preferences to change the import parameters, but I could not
> change the dates to allow for transactions that old.  I could set the
> proper expense account, but that would double up on the transaction.
> Is there a way to click or double click on the import matcher and
> manually select the matching transaction?
> 
> 
> Thank You,
> 
> Gyle McCollam

This is an interesting case. Are you recording the credit card
transactions in your books regardless of the errors of the credit card
company?
It is an example of the advantages of maintaining your record from your
receipts and entering the transactions, because then you would know
that money was owing, and how much.

If something takes more than about 18 months to show up I remove it
from active lists but preserve the data in case it turns up eventually.
I won't specify a method, because it has failings.

Liz
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] importing

[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 manually putting the date in the transaction notes.

If they messed it up so badly that it is impossible to import the data,  I
would be inclined to move my business to a different provider.



On Thu, Feb 16, 2023, 5:54 PM 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 they finally corrected the problem and billed me for the 6
> months of gas this month.  However, when I imported the file it said there
> were no matching transactions.  I used preferences to change the import
> parameters, but I could not change the dates to allow for transactions that
> old.  I could set the proper expense account, but that would double up on
> the transaction.  Is there a way to click or double click on the import
> matcher and manually select the matching transaction?
>
>
> Thank You,
>
> Gyle McCollam
>
> Gyle McCollam
>
> gmccol...@live.com   email
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] importing

[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 months of gas this month. 
 However, when I imported the file it said there were no matching transactions. 
 I used preferences to change the import parameters, but I could not change the 
dates to allow for transactions that old.  I could set the proper expense 
account, but that would double up on the transaction.  Is there a way to click 
or double click on the import matcher and manually select the matching 
transaction?


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing csv files

[Mark Bole]

I *did* provide a "well-detailed example", as shown in my post copied 
below (one line with header info, one line of data).  But apparently no 
one looked at it to the point of finding my somewhat obvious error (not 
complaining, I realize this is a volunteer resource).


So, the other thing I did was put it aside for a few days and take 
another look with fresh eyes.  And the problem was simply that I omitted 
the column for "Account Code", even though it was present in my first 
successful import file.  Not sure why I missed it in the second file, 
perhaps because (so far) I'm not using account codes for bottom-level 
accounts. In the process of massaging the QB export data for input, I 
must have just accidentally deleted or over-wrote the Code column.



On 2023-01-19 22:42, David Carlson wrote:

Mark,

The Help manual chapter 6 gives a good starting point to configuring a 
successful CSV transaction import.  However, it does not describe 
importing accounts.


GnuCash is supposed to be able to import anything that it can export, 
so if you try to find an existing account tree example in a test file, 
possibly created by the Gnucash account setup wizard, you can try 
exporting it to see what might work in the import direction.  If you 
have tried that and it still fails, you should at least have a well 
detailed example to use when you return to ask this group for 
additional help.


Is there documentation somewhere as to allowed characters, field
lengths, etc for CSV import of accounts?

Here is an example of an import file that fails for me.  The top
level
and sub-accounts exist.  Why won't it import successfully?

Type,Full Account Name,Account Name,Description,Account
Color,Notes,Symbol,Namespace,Hidden,Tax Info,Placeholder
ASSET,Current Assets:Other Current Assets:Ibond,Ibond,Treasury
Direct,,,USD,CURRENCY,F,F,F



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing csv files

[David Carlson]

Mark,

The Help manual chapter 6 gives a good starting point to configuring a
successful CSV transaction import.  However, it does not describe importing
accounts.

GnuCash is supposed to be able to import anything that it can export, so if
you try to find an existing account tree example in a test file, possibly
created by the Gnucash account setup wizard, you can try exporting it to
see what might work in the import direction.  If you have tried that and it
still fails, you should at least have a well detailed example to use when
you return to ask this group for additional help.



On Thu, Jan 19, 2023 at 8:43 PM Mark Bole  wrote:

> By coincidence, I too am trying to import my QuickBooks well-tuned COA
> into GnuCash via CSV files.  I already knew to try the things
> recommended in this thread but still have indeterminate results. I
> realize by now that with the time already invested (especially after I
> finish writing this), I could have manually altered the sub-account
> status and been done with it, but I want to understand what is going on
> at a lower level.
>
> I broke my QB accounts into smaller chunks for better testing and
> recovery if needed. _/My first batch import of type BANK accounts worked
> fine!/_  But now, with the same CSV format, I find I cannot successfully
> import further small groups of account rows from CSV files.  The
> Preview, even more frustrating, can show that the first four or five
> input rows don't parse correctly, but then suddenly  row six is fine for
> import in the preview.
>
> Is there documentation somewhere as to allowed characters, field
> lengths, etc for CSV import of accounts?
>
> Here is an example of an import file that fails for me.  The top level
> and sub-accounts exist.  Why won't it import successfully?
>
> Type,Full Account Name,Account Name,Description,Account
> Color,Notes,Symbol,Namespace,Hidden,Tax Info,Placeholder
> ASSET,Current Assets:Other Current Assets:Ibond,Ibond,Treasury
> Direct,,,USD,CURRENCY,F,F,F
>
> -Mark B.
>
> On 2023-01-19 11:58, R Losey wrote:
> > Also, do you really need to import data from Quickbooks? I used Quicken,
> > not Quickbooks, but (by and large), I just started up GnuCash afresh and
> > went back to Quicken only when I needed to look things up.  Now that I'm
> > years into GnuCash, I have had no need to go back to Quicken.
> >
> >
> >
> > On Wed, Jan 18, 2023 at 7:30 PM rudy beuc  wrote:
> >
> >> Hello,
> >>
> >> I'm trying to migrate from Quickbooks to GnuCash.
> >>
> >> I'd like to keep as much information as I can for record keeping. To
> >> that end I've first been trying to import my accounts structure in via a
> >> csv file and failing badly.
> >>
> >> Pre Christmas holidays I was getting an error message I could not
> >> interpret. Now I've installed the latest stable version 4.13 and it just
> >> dies mid process.
> >>
> >> I'm running on Windows 11 and using open office to manipulate the csv
> >> files before trying to import.
> >>
> >> Where can I find a good discussion or indepth material on importing csv
> >> files, the expected format for them, ect...?
> >>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing csv files

[flywire]

There is no panacea for replacing QuickBooks with GnuCash but I'm starting
to warm to the workarounds:
* https://lists.gnucash.org/pipermail/gnucash-user/2022-February/099811.html
- use tags instead of classes, the transaction report is the only one that
supports filtering so other reports would need to be modified, also no
grouping by tag (ie every transaction shown) in any report
*
https://lists.gnucash.org/pipermail/gnucash-user/2021-September/097666.html
- Cash Accounting with Automated GST which requires data to be prepared
offline and imported instead of using the Gnucash gui

I'll test these workarounds soon because I'm keen to give Quickbooks the
flick.

Mark Bole wrote:

> Here is an example of an import file...

Open the file in a spreadsheet and simplify it. There is a linked an
example in my previous post. Also,
https://bugs.gnucash.org/show_bug.cgi?id=797711

rudy beuc wrote:

> The best way I found to give up QB classes is to simply add an additional
> subaccount. Then when needed do transaction report looking for that
> "class". Works great for rental properties.

... said the one-legged person walking down the track. "Works great"
implies the workaround is as good as Quickbooks classes, which it isn't for
either data entry or reporting.

Steve Brown wrote

> I've had very good results with this
> https://github.com/erikmack/qb-escape.git

This would be great if the python bindings ( https://lwn.net/Articles/729087
) were part of the GnuCash executables. GnuCash can be recompiled but
forget it for Windows.

R Losey wrote:

> Also, do you really need to import data from Quickbooks?

It is normally useful to convert any data you can. There are plenty in this
community with decades of data, especially for investments. You need
history for tax records, time series analysis, eg rental payments,
insurance bills, water usage, etc., and preparing budgets.

Michael or Penny Novack wrote:

> Sure you weren't meaning Quicken

Your commentary is normally fairly enlightening but I meant what I wrote
there.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing csv files

[Mark Bole]

By coincidence, I too am trying to import my QuickBooks well-tuned COA 
into GnuCash via CSV files.  I already knew to try the things 
recommended in this thread but still have indeterminate results. I 
realize by now that with the time already invested (especially after I 
finish writing this), I could have manually altered the sub-account 
status and been done with it, but I want to understand what is going on 
at a lower level.


I broke my QB accounts into smaller chunks for better testing and 
recovery if needed. _/My first batch import of type BANK accounts worked 
fine!/_  But now, with the same CSV format, I find I cannot successfully 
import further small groups of account rows from CSV files.  The 
Preview, even more frustrating, can show that the first four or five 
input rows don't parse correctly, but then suddenly  row six is fine for 
import in the preview.


Is there documentation somewhere as to allowed characters, field 
lengths, etc for CSV import of accounts?


Here is an example of an import file that fails for me.  The top level 
and sub-accounts exist.  Why won't it import successfully?


Type,Full Account Name,Account Name,Description,Account 
Color,Notes,Symbol,Namespace,Hidden,Tax Info,Placeholder
ASSET,Current Assets:Other Current Assets:Ibond,Ibond,Treasury 
Direct,,,USD,CURRENCY,F,F,F


-Mark B.

On 2023-01-19 11:58, R Losey wrote:

Also, do you really need to import data from Quickbooks? I used Quicken,
not Quickbooks, but (by and large), I just started up GnuCash afresh and
went back to Quicken only when I needed to look things up.  Now that I'm
years into GnuCash, I have had no need to go back to Quicken.



On Wed, Jan 18, 2023 at 7:30 PM rudy beuc  wrote:


Hello,

I'm trying to migrate from Quickbooks to GnuCash.

I'd like to keep as much information as I can for record keeping. To
that end I've first been trying to import my accounts structure in via a
csv file and failing badly.

Pre Christmas holidays I was getting an error message I could not
interpret. Now I've installed the latest stable version 4.13 and it just
dies mid process.

I'm running on Windows 11 and using open office to manipulate the csv
files before trying to import.

Where can I find a good discussion or indepth material on importing csv
files, the expected format for them, ect...?


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing csv files

[R Losey]

Also, do you really need to import data from Quickbooks? I used Quicken,
not Quickbooks, but (by and large), I just started up GnuCash afresh and
went back to Quicken only when I needed to look things up.  Now that I'm
years into GnuCash, I have had no need to go back to Quicken.



On Wed, Jan 18, 2023 at 7:30 PM rudy beuc  wrote:

> Hello,
>
> I'm trying to migrate from Quickbooks to GnuCash.
>
> I'd like to keep as much information as I can for record keeping. To
> that end I've first been trying to import my accounts structure in via a
> csv file and failing badly.
>
> Pre Christmas holidays I was getting an error message I could not
> interpret. Now I've installed the latest stable version 4.13 and it just
> dies mid process.
>
> I'm running on Windows 11 and using open office to manipulate the csv
> files before trying to import.
>
> Where can I find a good discussion or indepth material on importing csv
> files, the expected format for them, ect...?
>
>
> Thanks,
>
> Rudy Beuc
>
>
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing CSV files

[rick1 via gnucash-user]

The best way I found to give up QB classes is to simply add an additional 
subaccount. Then when needed do transaction report looking for that "class". 
Works great for rental properties.

-Original Message-
From: gnucash-user  On 
Behalf Of gnucash-user-requ...@gnucash.org
Sent: Thursday, January 19, 2023 11:00 AM
To: gnucash-user@gnucash.org
Subject: gnucash-user Digest, Vol 238, Issue 70

Send gnucash-user mailing list submissions to
gnucash-user@gnucash.org

To subscribe or unsubscribe via the World Wide Web, visit
https://lists.gnucash.org/mailman/listinfo/gnucash-user
or, via email, send a message with subject or body 'help' to
gnucash-user-requ...@gnucash.org

You can reach the person managing the list at
gnucash-user-ow...@gnucash.org

When replying, please edit your Subject line so it is more specific than "Re: 
Contents of gnucash-user digest..."


Today's Topics:

   1.  Importing csv files (flywire)
   2. Re:  Importing csv files (Steve Brown)
   3. Re:  Importing csv files (Michael or Penny Novack)
   4. Re:  4.13 Version not in downloads (jhoe...@googlemail.com)
   5. Re:  4.13 Version not in downloads (Glenn Fowler)
   6. Re:  How to move a transaction with splits from one top-level
  account to another - take 2 (David T.)
   7. Re:  How to move a transaction with splits from one top-level
  account to another - take 2 (Xe Roy)
   8. Re:  How to move a transaction with splits from one top-level
  account to another - take 2 (David T.)


--

Message: 1
Date: Thu, 19 Jan 2023 22:27:20 +1100
From: flywire 
To: rudy beuc 
Cc: Gnucash Users 
Subject: [GNC] Importing csv files
Message-ID:

Content-Type: text/plain; charset="UTF-8"

Make sure you understand what Gnucash offers as it could be a massive downgrade 
from Quickbooks. I use Quickbooks and GnuCash, each for different books because 
neither has all the features I need. Specifically, GnuCash does not support 
classes or automated GST (tax) for cash accounting (so I've never exported data 
from Quickbooks to GnuCash) but GnuCash does a fair job at importing csv files, 
which I do regularly.

Have a read through this before doing it. See:
* Prior thread:
https://lists.gnucash.org/pipermail/gnucash-user/2022-July/101901.html
* GnuCash Manual Import csv:
https://www.gnucash.org/viewdoc.phtml?rev=4=C=help
 * Tutorial data for testing:
https://lists.gnucash.org/pipermail/gnucash-user/attachments/20210718/2f60caee/attachment.obj

Importing accounts into GnuCash with csv is really nice csv but transaction 
data is really primitive. Still, despite how frustrating it is for new users in 
particular, it will work. File, Import, Import transaction from csv, Next, 
Select file...

Import Preview, normally you would select Account, say bank account, but that 
is not the case for a Quickbooks import. The File Format is likely Separators, 
Comma, but again, you likely need to *SELECT Multi-split* for the import which 
I'll explain soon.

Miscellaneous is really frustrating because of poor defaults. GnuCash has been 
around for 25 years but it doesn't recognise Locale date or support alphabetic 
month codes, so if you are not in the US, fix Date and check the month format. 
How many csv files have you seen without headers? Likely none. Set Leading 
Lines to skip, 1?? Currency format is likely correct.

In the link to the manual, navigate down to Example 6.1. Sample Multi-split.csv 
to see the layout of the csv file. See the tip? It is likely easier to prepare 
that file without the blank fields.

Back to the Import Preview form. Despite your csv file having the *exact* field 
names it needs there is no way for it to know that. You'll have to click each 
of the field dropdowns and match the field name to the data. The first line 
will be crossed out after you set it t skip 1 line but you can still read the 
field name.

All your records are red with a '-' in a circle on the right side? Chances are 
you need to reformat the date month data. Be careful, your spreadsheet might be 
outputting it in a different format to what is shown on the screen.

GnuCash does not recognise all the account codes in your data. You will have to 
create them, and even after you've done that you'll have to match them to the 
*same account*. Seriously! Now, stop banging your head. See above, " Importing 
accounts into GnuCash with csv is really nice", so do it to save yourself a 
little grief.

You haven't finished yet but I'll leave you with the manual. Check out Tools, 
Import Map Editor, Non-Bayesian.


--

Message: 2
Date: Thu, 19 Jan 2023 07:16:36 -0500
From: Steve Brown 
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Importing csv files
Message-ID:
<10ccd4f6605e121f47ff38a5502d563d8cabbccc.ca...@opensat.com>
Content-Type: text/plain; charset="UTF-8"

Re: [GNC] Importing csv files

[Michael or Penny Novack]

On 1/19/2023 6:27 AM, flywire wrote:

Make sure you understand what Gnucash offers as it could be a
massive downgrade from Quickbooks. I use Quickbooks and GnuCash, each for
different books because neither has all the features I need. Specifically,
GnuCash does not support classes ...


I used to use Quickbooks. That was a while ago, before the 2006 house 
fire. Standard double entry bookkeeping. It didn't have "classes" then, 
although possible it now supports "alternate view of the CoA" (what 
"classes" would be in double entry) somehow I doubt it, as not 
traditional in double entry ledger to have more than one view of the 
ledger hierarchy.


Sure you weren't meaning Quicken (which is not double entry ad which 
does have "classes")


Michael



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing csv files

[Steve Brown]

I've had very good results with this
https://github.com/erikmack/qb-escape.git

I had to back out the account code stuff in the most recent commit as
it didn't work for my use case.

The article referenced in the README was similarly helpful.

Steve

On Wed, 2023-01-18 at 19:29 -0600, rudy beuc wrote:
> Hello,
> 
> I'm trying to migrate from Quickbooks to GnuCash.
> 
> I'd like to keep as much information as I can for record keeping. To 
> that end I've first been trying to import my accounts structure in
> via a 
> csv file and failing badly.
> 
> Pre Christmas holidays I was getting an error message I could not 
> interpret. Now I've installed the latest stable version 4.13 and it
> just 
> dies mid process.
> 
> I'm running on Windows 11 and using open office to manipulate the csv
> files before trying to import.
> 
> Where can I find a good discussion or indepth material on importing
> csv 
> files, the expected format for them, ect...?
> 
> 
> Thanks,
> 
> Rudy Beuc
> 
> 
> 
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Importing csv files

[flywire]

Make sure you understand what Gnucash offers as it could be a
massive downgrade from Quickbooks. I use Quickbooks and GnuCash, each for
different books because neither has all the features I need. Specifically,
GnuCash does not support classes or automated GST (tax) for cash accounting
(so I've never exported data from Quickbooks to GnuCash) but GnuCash does a
fair job at importing csv files, which I do regularly.

Have a read through this before doing it. See:
* Prior thread:
https://lists.gnucash.org/pipermail/gnucash-user/2022-July/101901.html
* GnuCash Manual Import csv:
https://www.gnucash.org/viewdoc.phtml?rev=4=C=help
 * Tutorial data for testing:
https://lists.gnucash.org/pipermail/gnucash-user/attachments/20210718/2f60caee/attachment.obj

Importing accounts into GnuCash with csv is really nice csv but transaction
data is really primitive. Still, despite how frustrating it is for new
users in particular, it will work. File, Import, Import transaction from
csv, Next, Select file...

Import Preview, normally you would select Account, say bank account, but
that is not the case for a Quickbooks import. The File Format is likely
Separators, Comma, but again, you likely need to *SELECT Multi-split* for
the import which I'll explain soon.

Miscellaneous is really frustrating because of poor defaults. GnuCash has
been around for 25 years but it doesn't recognise Locale date or support
alphabetic month codes, so if you are not in the US, fix Date and check the
month format. How many csv files have you seen without headers? Likely
none. Set Leading Lines to skip, 1?? Currency format is likely correct.

In the link to the manual, navigate down to Example 6.1. Sample
Multi-split.csv to see the layout of the csv file. See the tip? It is
likely easier to prepare that file without the blank fields.

Back to the Import Preview form. Despite your csv file having the *exact*
field names it needs there is no way for it to know that. You'll have to
click each of the field dropdowns and match the field name to the data. The
first line will be crossed out after you set it t skip 1 line but you can
still read the field name.

All your records are red with a '-' in a circle on the right side? Chances
are you need to reformat the date month data. Be careful, your spreadsheet
might be outputting it in a different format to what is shown on the screen.

GnuCash does not recognise all the account codes in your data. You will
have to create them, and even after you've done that you'll have to match
them to the *same account*. Seriously! Now, stop banging your head. See
above, " Importing accounts into GnuCash with csv is really nice", so do it
to save yourself a little grief.

You haven't finished yet but I'll leave you with the manual. Check out
Tools, Import Map Editor, Non-Bayesian.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing csv files

[Geoff]

Hi Rudy

The easiest way to learn is to set up a dummy GnuCash book with a few 
accounts and transactions (doubtless you have done this already as part 
of your evaluation), do an EXPORT from GnuCash, and study the structure 
of the CSV files produced by GnuCash.


Hope this helps.

Regards

Geoff
=

On 19/01/2023 12:29 pm, rudy beuc wrote:

Hello,

I'm trying to migrate from Quickbooks to GnuCash.

I'd like to keep as much information as I can for record keeping. To 
that end I've first been trying to import my accounts structure in via a 
csv file and failing badly.


Pre Christmas holidays I was getting an error message I could not 
interpret. Now I've installed the latest stable version 4.13 and it just 
dies mid process.


I'm running on Windows 11 and using open office to manipulate the csv 
files before trying to import.


Where can I find a good discussion or indepth material on importing csv 
files, the expected format for them, ect...?



Thanks,

Rudy Beuc





___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing csv files

[Adrien Monteleone]

Welcome to GnuCash!

I'm not sure there is any single discussion on this outside of what 
you'll find in the documentation.


There are plenty of list threads on the topic in general, but most of 
them deal with a specific aspect, issue, error, etc.


'Best Practice' is to export small chunks and import the data in 
batches, for example, monthly or yearly. (at most)


The import matcher learns as you go, so if you do small batches, the 
effort to make corrections shrinks as it learns on subsequent imports. 
(*important note - while you can make corrections after the import, 
catching mistakes in the import process is better, because that is how 
you manually 'teach' it when it gets something wrong.)


This also makes it easier for you to review the imported transactions 
and affected accounts (possibly reconcile too) and then when you're 
satisfied all is well, move on to the next import.


If any transactions are 'malformed' and GnuCash doesn't like the data 
for some reason, working with a smaller set of data makes it easier to 
find the offender and correct it before trying to re-import.


Depending on how much data you have, be prepared to spend a considerable 
amount of time on this. But if you are methodical and meticulous, you're 
only going to have to do this once.


If you get stuck on any part of the process, or a particular import 
doesn't go smoothly, ask here with the details and someone should be 
able to assist.


Regards,
Adrien

On 1/18/23 7:29 PM, rudy beuc wrote:

Hello,

I'm trying to migrate from Quickbooks to GnuCash.

I'd like to keep as much information as I can for record keeping. To 
that end I've first been trying to import my accounts structure in via a 
csv file and failing badly.


Pre Christmas holidays I was getting an error message I could not 
interpret. Now I've installed the latest stable version 4.13 and it just 
dies mid process.


I'm running on Windows 11 and using open office to manipulate the csv 
files before trying to import.


Where can I find a good discussion or indepth material on importing csv 
files, the expected format for them, ect...?


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Importing csv files

[rudy beuc]

Hello,

I'm trying to migrate from Quickbooks to GnuCash.

I'd like to keep as much information as I can for record keeping. To 
that end I've first been trying to import my accounts structure in via a 
csv file and failing badly.


Pre Christmas holidays I was getting an error message I could not 
interpret. Now I've installed the latest stable version 4.13 and it just 
dies mid process.


I'm running on Windows 11 and using open office to manipulate the csv 
files before trying to import.


Where can I find a good discussion or indepth material on importing csv 
files, the expected format for them, ect...?



Thanks,

Rudy Beuc





___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing GIF: Unable to complete

[David Carlson]

Amar,
Just sayin'  If you imported your data into GnuCash 4.12 a month ago, then
you only need to open that data file and import a months' data into GnuCash
4.13, not the whole thing.


On Thu, Dec 22, 2022 at 9:50 PM Amar Khalifeh 
wrote:

> I think the QIF file is fine.
> I was able to import it into Moneyspire and Acemoney just now
> I was able to import a similar file (exported from Moneydance) into GnuCash
> less than a month ago.
>
> On Thu, Dec 22, 2022 at 4:01 PM David H  wrote:
>
> > Amar,
> >
> > Please use "Reply All" to keep the conversation on the mailing list
> > so other users can chip in and help.  I rarely use any importers and are
> > just offering suggestions that may or may not help :-)  See John Ralls's
> > reply which is probably more germane than mine.  To me it looks like your
> > file is rubbish - are you sure it's a QIF file ?  Or as John suggested
> have
> > you actually selected a file ?
> >
> > Cheers David H.
> >
> >
> > On Fri, 23 Dec 2022 at 07:46, Amar Khalifeh 
> > wrote:
> >
> >> The file is 1536 KB.
> >> I'm running Windows 11.
> >> 
> >>
> >> As a follow up, I tried again, and this time I examined the import
> status
> >> window.
> >> This is what I got. Does this provide any clues?
> >> [image: image.png]
> >>
> >> On Thu, Dec 22, 2022 at 2:56 PM David H  wrote:
> >>
> >>> What OS ? How large is your QIF history file - perhaps it's still
> >>> working on it and you need to give it more time ?  Have you clicked on
> >>> another Window and taken the focus away from you dialog ?
> >>>
> >>> Cheers David H.
> >>>
> >>> On Fri, 23 Dec 2022 at 06:50, Amar Khalifeh 
> >>> wrote:
> >>>
>  I just downloaded version 4.13 and am trying to import my QIF history.
>  I go
>  through the import process and it seems to be working fine, but when I
>  get
>  to the step where it asks if I want to load another file or continue
>  (with
>  "Next"), I find "Next" grayed out and none of the clickable buttons
>  work.
>  Any ideas why this is happening?
>  I was able to load QIF files in the past from the same source in
> earlier
>  attempts to use Gnu Cash.
>  Thank you for your help.
> 
>  [image: image.png]
>  ___
>  gnucash-user mailing list
>  gnucash-user@gnucash.org
>  To update your subscription preferences or to unsubscribe:
>  https://lists.gnucash.org/mailman/listinfo/gnucash-user
>  -
>  Please remember to CC this list on all your replies.
>  You can do this by using Reply-To-List or Reply-All.
> 
> >>>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing GIF: Unable to complete

[Amar Khalifeh]

I think the QIF file is fine.
I was able to import it into Moneyspire and Acemoney just now
I was able to import a similar file (exported from Moneydance) into GnuCash
less than a month ago.

On Thu, Dec 22, 2022 at 4:01 PM David H  wrote:

> Amar,
>
> Please use "Reply All" to keep the conversation on the mailing list
> so other users can chip in and help.  I rarely use any importers and are
> just offering suggestions that may or may not help :-)  See John Ralls's
> reply which is probably more germane than mine.  To me it looks like your
> file is rubbish - are you sure it's a QIF file ?  Or as John suggested have
> you actually selected a file ?
>
> Cheers David H.
>
>
> On Fri, 23 Dec 2022 at 07:46, Amar Khalifeh 
> wrote:
>
>> The file is 1536 KB.
>> I'm running Windows 11.
>> 
>>
>> As a follow up, I tried again, and this time I examined the import status
>> window.
>> This is what I got. Does this provide any clues?
>> [image: image.png]
>>
>> On Thu, Dec 22, 2022 at 2:56 PM David H  wrote:
>>
>>> What OS ? How large is your QIF history file - perhaps it's still
>>> working on it and you need to give it more time ?  Have you clicked on
>>> another Window and taken the focus away from you dialog ?
>>>
>>> Cheers David H.
>>>
>>> On Fri, 23 Dec 2022 at 06:50, Amar Khalifeh 
>>> wrote:
>>>
 I just downloaded version 4.13 and am trying to import my QIF history.
 I go
 through the import process and it seems to be working fine, but when I
 get
 to the step where it asks if I want to load another file or continue
 (with
 "Next"), I find "Next" grayed out and none of the clickable buttons
 work.
 Any ideas why this is happening?
 I was able to load QIF files in the past from the same source in earlier
 attempts to use Gnu Cash.
 Thank you for your help.

 [image: image.png]
 ___
 gnucash-user mailing list
 gnucash-user@gnucash.org
 To update your subscription preferences or to unsubscribe:
 https://lists.gnucash.org/mailman/listinfo/gnucash-user
 -
 Please remember to CC this list on all your replies.
 You can do this by using Reply-To-List or Reply-All.

>>>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing GIF: Unable to complete

[Amar Khalifeh]

Yes, but it's over a month old. I was able to import a QIF file from the
same source, Moneydance.
Now, I'm trying the same process again with a more recent version.

On Thu, Dec 22, 2022, 4:57 PM David Carlson 
wrote:

> Amar,
>
> do you have a data file from a previous version of GnuCash?
>
> On Thu, Dec 22, 2022 at 4:05 PM John Ralls  wrote:
>
>> Please remember to copy the list on all replies.
>>
>> Looks like you had a ton of errors so it didn't load the file.
>>
>> Regards,
>> John Ralls
>>
>>
>> > On Dec 22, 2022, at 1:48 PM, Amar Khalifeh 
>> wrote:
>> >
>> > The file selection was done in the previous step, and I got the
>> impression that it was actually loaded
>> > 
>> >
>> > On Thu, Dec 22, 2022 at 3:06 PM John Ralls  wrote:
>> >
>> >
>> > > On Dec 22, 2022, at 8:41 AM, Amar Khalifeh 
>> wrote:
>> > >
>> > > I just downloaded version 4.13 and am trying to import my QIF
>> history. I go
>> > > through the import process and it seems to be working fine, but when
>> I get
>> > > to the step where it asks if I want to load another file or continue
>> (with
>> > > "Next"), I find "Next" grayed out and none of the clickable buttons
>> work.
>> > > Any ideas why this is happening?
>> > > I was able to load QIF files in the past from the same source in
>> earlier
>> > > attempts to use Gnu Cash.
>> > > Thank you for your help.
>> > >
>> > > [image: image.png]
>> >
>> > The screenshot shows that you haven't selected any files to import. Use
>> the "load another file" button to select one. You can keep using that
>> button to build up a list of QIF files to import into the same GnuCash
>> account that you selected in the previous step.
>> >
>> > The Next button will enable once you've selected at least one file.
>> >
>> > Regards,
>> > John Ralls
>> >
>> >
>>
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
>
> --
> David Carlson
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing GIF: Unable to complete

[Liz Dodd]

On Fri, 23 Dec 2022 08:01:44 +1000
David H  wrote:

> Amar,
> 
> Please use "Reply All" to keep the conversation on the mailing list
> so other users can chip in and help. 

Amar is not subscribed to the list. Any replies will wait for me to let
them through. None waiting up to one minute ago.

Liz
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing GIF: Unable to complete

[David Carlson]

Amar,

do you have a data file from a previous version of GnuCash?

On Thu, Dec 22, 2022 at 4:05 PM John Ralls  wrote:

> Please remember to copy the list on all replies.
>
> Looks like you had a ton of errors so it didn't load the file.
>
> Regards,
> John Ralls
>
>
> > On Dec 22, 2022, at 1:48 PM, Amar Khalifeh 
> wrote:
> >
> > The file selection was done in the previous step, and I got the
> impression that it was actually loaded
> > 
> >
> > On Thu, Dec 22, 2022 at 3:06 PM John Ralls  wrote:
> >
> >
> > > On Dec 22, 2022, at 8:41 AM, Amar Khalifeh 
> wrote:
> > >
> > > I just downloaded version 4.13 and am trying to import my QIF history.
> I go
> > > through the import process and it seems to be working fine, but when I
> get
> > > to the step where it asks if I want to load another file or continue
> (with
> > > "Next"), I find "Next" grayed out and none of the clickable buttons
> work.
> > > Any ideas why this is happening?
> > > I was able to load QIF files in the past from the same source in
> earlier
> > > attempts to use Gnu Cash.
> > > Thank you for your help.
> > >
> > > [image: image.png]
> >
> > The screenshot shows that you haven't selected any files to import. Use
> the "load another file" button to select one. You can keep using that
> button to build up a list of QIF files to import into the same GnuCash
> account that you selected in the previous step.
> >
> > The Next button will enable once you've selected at least one file.
> >
> > Regards,
> > John Ralls
> >
> >
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing GIF: Unable to complete

[John Ralls]

Please remember to copy the list on all replies.

Looks like you had a ton of errors so it didn't load the file.

Regards,
John Ralls


> On Dec 22, 2022, at 1:48 PM, Amar Khalifeh  wrote:
> 
> The file selection was done in the previous step, and I got the impression 
> that it was actually loaded
> 
> 
> On Thu, Dec 22, 2022 at 3:06 PM John Ralls  wrote:
> 
> 
> > On Dec 22, 2022, at 8:41 AM, Amar Khalifeh  wrote:
> > 
> > I just downloaded version 4.13 and am trying to import my QIF history. I go
> > through the import process and it seems to be working fine, but when I get
> > to the step where it asks if I want to load another file or continue (with
> > "Next"), I find "Next" grayed out and none of the clickable buttons work.
> > Any ideas why this is happening?
> > I was able to load QIF files in the past from the same source in earlier
> > attempts to use Gnu Cash.
> > Thank you for your help.
> > 
> > [image: image.png]
> 
> The screenshot shows that you haven't selected any files to import. Use the 
> "load another file" button to select one. You can keep using that button to 
> build up a list of QIF files to import into the same GnuCash account that you 
> selected in the previous step.
> 
> The Next button will enable once you've selected at least one file.
> 
> Regards,
> John Ralls
> 
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing GIF: Unable to complete

[David H]

Amar,

Please use "Reply All" to keep the conversation on the mailing list
so other users can chip in and help.  I rarely use any importers and are
just offering suggestions that may or may not help :-)  See John Ralls's
reply which is probably more germane than mine.  To me it looks like your
file is rubbish - are you sure it's a QIF file ?  Or as John suggested have
you actually selected a file ?

Cheers David H.


On Fri, 23 Dec 2022 at 07:46, Amar Khalifeh  wrote:

> The file is 1536 KB.
> I'm running Windows 11.
> 
>
> As a follow up, I tried again, and this time I examined the import status
> window.
> This is what I got. Does this provide any clues?
> [image: image.png]
>
> On Thu, Dec 22, 2022 at 2:56 PM David H  wrote:
>
>> What OS ? How large is your QIF history file - perhaps it's still working
>> on it and you need to give it more time ?  Have you clicked on another
>> Window and taken the focus away from you dialog ?
>>
>> Cheers David H.
>>
>> On Fri, 23 Dec 2022 at 06:50, Amar Khalifeh 
>> wrote:
>>
>>> I just downloaded version 4.13 and am trying to import my QIF history. I
>>> go
>>> through the import process and it seems to be working fine, but when I
>>> get
>>> to the step where it asks if I want to load another file or continue
>>> (with
>>> "Next"), I find "Next" grayed out and none of the clickable buttons work.
>>> Any ideas why this is happening?
>>> I was able to load QIF files in the past from the same source in earlier
>>> attempts to use Gnu Cash.
>>> Thank you for your help.
>>>
>>> [image: image.png]
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>>
>>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing GIF: Unable to complete

[John Ralls]

> On Dec 22, 2022, at 8:41 AM, Amar Khalifeh  wrote:
> 
> I just downloaded version 4.13 and am trying to import my QIF history. I go
> through the import process and it seems to be working fine, but when I get
> to the step where it asks if I want to load another file or continue (with
> "Next"), I find "Next" grayed out and none of the clickable buttons work.
> Any ideas why this is happening?
> I was able to load QIF files in the past from the same source in earlier
> attempts to use Gnu Cash.
> Thank you for your help.
> 
> [image: image.png]

The screenshot shows that you haven't selected any files to import. Use the 
"load another file" button to select one. You can keep using that button to 
build up a list of QIF files to import into the same GnuCash account that you 
selected in the previous step.

The Next button will enable once you've selected at least one file.

Regards,
John Ralls


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing GIF: Unable to complete

[David H]

What OS ? How large is your QIF history file - perhaps it's still working
on it and you need to give it more time ?  Have you clicked on another
Window and taken the focus away from you dialog ?

Cheers David H.

On Fri, 23 Dec 2022 at 06:50, Amar Khalifeh  wrote:

> I just downloaded version 4.13 and am trying to import my QIF history. I go
> through the import process and it seems to be working fine, but when I get
> to the step where it asks if I want to load another file or continue (with
> "Next"), I find "Next" grayed out and none of the clickable buttons work.
> Any ideas why this is happening?
> I was able to load QIF files in the past from the same source in earlier
> attempts to use Gnu Cash.
> Thank you for your help.
>
> [image: image.png]
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Importing GIF: Unable to complete

[Amar Khalifeh]

I just downloaded version 4.13 and am trying to import my QIF history. I go
through the import process and it seems to be working fine, but when I get
to the step where it asks if I want to load another file or continue (with
"Next"), I find "Next" grayed out and none of the clickable buttons work.
Any ideas why this is happening?
I was able to load QIF files in the past from the same source in earlier
attempts to use Gnu Cash.
Thank you for your help.

[image: image.png]
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing Transactions from CSV

[M]

Ah ha.

I was opening my csv file in a spreadsheet editor and manipulating the 
data before importing.


I made a couple simple test csv files and they worked exactly as you 
described.


I think the issue may be a formatting error my spreadsheet software was 
doing.


Thanks for the help, I think I have it solved.

Mike

On 12/15/22 6:58 AM, Murugan Muruganandam wrote:
you dont need to change the file, if  it is negative, GNUCash will 
move it to debit column in this case.  Select the column as withdrawal




Saludos Cordiales


Murugan


*From:* gnucash-user 
 on 
behalf of M 

*Sent:* Wednesday, December 14, 2022 11:15 PM
*To:* gnucash-user@gnucash.org 
*Subject:* [GNC] Importing Transactions from CSV
My credit card company recently stopped publishing their transactions in
OFX format.  They now only offer the transactions in CSV format.

The issue I have is they list both deposits and withdrawals in the same
"Amount" column.  They signify deposits as negative amounts, and
withdrawals as positive amounts.

As far as I can tell, Gnucash only allows imports of a "Withdrawals" or
"Deposits" column type when importing transactions in CSV format.  Is
this correct?

Is there any way to streamline the import of this data without modifying
the CSV file to move negative numbers to another column? I suppose I
could write a python script to do this automatically, but I was
wondering if I am missing something in Gnucash.

Thanks!

Mike
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing Transactions from CSV

[Murugan Muruganandam]

you dont need to change the file, if  it is negative, GNUCash will move it to 
debit column in this case.  Select the column as withdrawal




Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of M 

Sent: Wednesday, December 14, 2022 11:15 PM
To: gnucash-user@gnucash.org 
Subject: [GNC] Importing Transactions from CSV

My credit card company recently stopped publishing their transactions in
OFX format.  They now only offer the transactions in CSV format.

The issue I have is they list both deposits and withdrawals in the same
"Amount" column.  They signify deposits as negative amounts, and
withdrawals as positive amounts.

As far as I can tell, Gnucash only allows imports of a "Withdrawals" or
"Deposits" column type when importing transactions in CSV format.  Is
this correct?

Is there any way to streamline the import of this data without modifying
the CSV file to move negative numbers to another column? I suppose I
could write a python script to do this automatically, but I was
wondering if I am missing something in Gnucash.

Thanks!

Mike
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing Transactions from CSV

[David Cousens]

Mike,

Gnucash can import a single amount column with deposits as negative amounts and
withdrawals as positive amounts without any problem. You may have to experiment
with whether to apply the Deposits or Withdrawals header to that data column
depending on how the bank has used the signs, to get a correct import.  I've
forgotten whether GnuCash remembers the header/column assignments in the stored
import conditions as I rarely import CSV data these days but I think it does, 
so once you have a set of import conditions that work you can save them and then
recall them anytime you need to import from that source.
https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html
https://wiki.gnucash.org/wiki/CSV_Import/Export

David Cousens


On Wed, 2022-12-14 at 21:15 -0500, M wrote:
> My credit card company recently stopped publishing their transactions in 
> OFX format.  They now only offer the transactions in CSV format.
> 
> The issue I have is they list both deposits and withdrawals in the same 
> "Amount" column.  They signify deposits as negative amounts, and 
> withdrawals as positive amounts.
> 
> As far as I can tell, Gnucash only allows imports of a "Withdrawals" or 
> "Deposits" column type when importing transactions in CSV format.  Is 
> this correct?
> 
> Is there any way to streamline the import of this data without modifying 
> the CSV file to move negative numbers to another column? I suppose I 
> could write a python script to do this automatically, but I was 
> wondering if I am missing something in Gnucash.
> 
> Thanks!
> 
> Mike
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing Transactions from CSV

[rovero]

I tried this myself and the positive dollars in the amount column does indeed 
go to the deposit column in gnucash and the negative dollars number goes into 
the withdraw column. I should also add the test account I used set up is a Type 
( bank). Have not tried this on other Types of accounts.

Joe

-Original Message-
From: gnucash-user  On 
Behalf Of Jim DeLaHunt
Sent: Wednesday, December 14, 2022 6:36 PM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Importing Transactions from CSV

On 2022-12-14 18:15, M wrote:

> My credit card company... only offer the transactions in CSV format.
>
> The issue I have is they list both deposits and withdrawals in the 
> same "Amount" column.  They signify deposits as negative amounts, and 
> withdrawals as positive amounts.
>
> As far as I can tell, Gnucash only allows imports of a "Withdrawals" 
> or "Deposits" column type when importing transactions in CSV format. 
> Is this correct?

Yes, but I believe (having not tried this recently) that Gnucash accepts 
negative amounts, as well as positive, in either column. When GnuCash finds a 
negative amount in a "Withdrawls" column, it makes the number positive and 
moves it to the "Deposits" column; and vice versa.

I suspect that if you assign the "Amount" column of your credit card company's 
CSV file to the withdrawls column of GnuCash's credit card account, then the 
correct numbers will end up in your GnuCash book. But try this experimentally 
before you commit to it. I have not tested this myself before writing this 
reply.

Best regards,
 —Jim DeLaHunt

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing Transactions from CSV

[Jim DeLaHunt]

On 2022-12-14 18:15, M wrote:


My credit card company... only offer the transactions in CSV format.

The issue I have is they list both deposits and withdrawals in the 
same "Amount" column.  They signify deposits as negative amounts, and 
withdrawals as positive amounts.


As far as I can tell, Gnucash only allows imports of a "Withdrawals" 
or "Deposits" column type when importing transactions in CSV format.  
Is this correct?


Yes, but I believe (having not tried this recently) that Gnucash accepts 
negative amounts, as well as positive, in either column. When GnuCash 
finds a negative amount in a "Withdrawls" column, it makes the number 
positive and moves it to the "Deposits" column; and vice versa.


I suspect that if you assign the "Amount" column of your credit card 
company's CSV file to the withdrawls column of GnuCash's credit card 
account, then the correct numbers will end up in your GnuCash book. But 
try this experimentally before you commit to it. I have not tested this 
myself before writing this reply.


Best regards,
    —Jim DeLaHunt

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.