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 <t...@tomolin.net> Sent: Monday, July 03, 2023 12:14 PM To: Jean L <rip...@gmail.com> 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 <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 > 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<list+gnuc...@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 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 Reply-All.
