Quickbooks to GnuCASH

[Charles Day]

On Wed, Apr 2, 2008 at 9:04 PM, Tony Nelson <tonyn at openlearning.com> wrote:

> Thanks Charles.
>
> I replaced the existing file, so I now presumably have the latest and
> greatest.
>
> But it appears that this only works with Quicken and not Quickbooks
> files, can you confirm?  My QuickBooks2008 file has a .qbw extension.
>
> Is there any automated way to convert this type of file or am I out of
> luck?
>

I believe that the .qbw file is a proprietary, binary format, perhaps even
encrypted. Judging by the QuickBooks Community
forum<http://quickbooksgroup.com/.ee8e2e6/>,
a cottage industry has developed around the challenge of removing the Intuit
handcuffs. I really don't know anything about how to get your data out of
QuickBooks, I'm afraid. I recall some attempts by exporting an IIF file from
QuickBooks to Excel or OpenOffice Calc, massaging the data, then converting
to QIF with a free tool. Someone has recently been attempting it by
generating .csv files from their QuickBook reports, then converting to QIF,
but I don't know the current status of that. I would suggest searching the
mailing list archives to find out what others have tried.

Cheers,
Charles

Thanks!
> --tony
>
> On Wed, 2008-04-02 at 20:30 -0700, Charles Day wrote:
> > On Wed, Apr 2, 2008 at 7:55 PM, Tony Nelson <tonyn at openlearning.com>
> > wrote:
> >         Forgive me, but how do I determine if I have an
> >         updated qif-to-gnc.scm?
> >
> > The version you need can be downloaded from here. Replace your
> > existing, installed copy of qif-to-gnc.scm and restart GnuCash.
> >
> > -Charles
> >
> >         --Tony
> >
> >         On Wed, 2008-04-02 at 14:46 -0400, Michael DeBusk wrote:
> >         > Derek Atkins wrote:
> >         >
> >         > >> I couldn't get it all imported without massive errors.
> >         > >
> >         > > When was this?  There's been a lot of work on the QIF
> >         Importer
> >         > > recently and it really seems to do a MUCH better job,
> >         thanks to
> >         > > Charles Day.  But you need to be running 2.2.4 (plus an
> >         updated
> >         > > qif-to-gnc.scm) to get all the fixes.
> >         >
> >         > It was at the beginning of 2007, or maybe the end of 2006.
> >         >
> >         > Although the QIF Importer may have been buggy, I imagine my
> >         complete
> >         > inability to get my data imported had quite a bit to do with
> >         my lack of
> >         > patience at the time. I had switched to Linux from OS/2 at
> >         the same
> >         > time, so I was feeling like a complete n00b (and I hadn't
> >         felt that way
> >         > since the early 1990s, when I first experienced the cold
> >         starkness of
> >         > the DOS prompt). Anything that didn't "just work" I had to
> >         put aside
> >         > until I felt at home in Linux. Quicken 98 worked fine under
> >         Wine.
> >         >
> >         > Now, I compile GnuCash from the tarball*, routinely edit QIF
> >         files by
> >         > hand, and am reviewing my old college Accounting textbooks.
> >         (Anybody
> >         > remember doing double-entry on paper? Those were the days!)
> >         So it's all
> >         > good. All that's left is to learn to code in C so I can
> >         pitch in.
> >         >
> >         > Oh, I do have 2.2.4 and the updated qif-to-gnc.scm.
> >         >
> >         > *I am running Ubuntu and I want OFX import capabilities
> >         >
> >
> >
>
>