Re: [GNC] Importing data from QuickBooks Online

2023-07-06 Thread Tom Olin via gnucash-user
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. >>

Re: [GNC] Importing data from QuickBooks Online

2023-07-05 Thread Tom Olin via gnucash-user
h 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 >> mailto:gnucash-user@gnucash.org>> wrote: >> >> Vincent, >

Re: [GNC] Importing data from QuickBooks Online

2023-07-04 Thread Tom Olin via gnucash-user
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

Re: [GNC] Importing data from QuickBooks Online

2023-07-04 Thread Tom Olin via gnucash-user
gt; 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

Re: [GNC] Importing data from QuickBooks Online

2023-07-03 Thread Tom Olin via gnucash-user
d 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

Re: [GNC] Importing data from QuickBooks Online

2023-07-03 Thread Tom Olin via gnucash-user
t 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

Re: [GNC] Importing data from QuickBooks Online

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

Re: [GNC] Importing data from QuickBooks Online

2023-07-03 Thread Tom Olin via gnucash-user
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 >> >> O

Re: [GNC] Importing data from QuickBooks Online

2023-07-03 Thread Tom Olin via gnucash-user
nce? 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 >>> >>> >>>

Re: [GNC] Importing data from QuickBooks Online

2023-07-03 Thread Tom Olin via gnucash-user
t; > -- > 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. Answe

Re: [GNC] Importing data from QuickBooks Online

2023-07-03 Thread Tom Olin via gnucash-user
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 >>

[GNC] Importing data from QuickBooks Online

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