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 <t...@tomolin.net> 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 <dbrei...@icloud.com> 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 >>> <gnucash-user@gnucash.org> 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 >>> <qbo2gc.awk><PastedGraphic-2.png> >>>> 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.
