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 <[email protected]> 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
> [email protected]
>
>
>
>
>> On Jul 3, 2023, at 11:59 AM, Tom Olin via gnucash-user
>> <[email protected]> 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 <[email protected]> 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
[email protected]
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.
