This may be slightly off topic, or too late to help, but...
In github, there is a repository
https://github.com/tim-rohrer/move2gnucash
That seems pretty well setup to migrate your data from a quicken csv
export to GC. I haven't used it, but I looked at it for a friend and it
looked interesting.
Jean
On 7/3/2023 8:59 AM, Tom Olin via gnucash-user 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
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.
_______________________________________________
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.
_______________________________________________
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.
