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