[GNC] Importing data from QuickBooks Online

[Jim DeLaHunt]

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