[GNC] Importing data from QuickBooks Online

[Tom Olin]

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 <dbreiser at 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
> dbreiser at icloud.com
> 
> 
> 
> 
>> On Jul 3, 2023, at 11:59 AM, Tom Olin via gnucash-user <gnucash-user at 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+gnucash at 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
>>> 
>