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 <dbrei...@icloud.com> 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 <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.
