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.
