merging qb files

sandi c's Avatar

sandi c

11 Jun, 2024 10:53 PM

Hi, can I migrate my QB Enterprise files?

  1. 1 Posted by dwg on 11 Jun, 2024 11:12 PM

    dwg's Avatar

    I'm a fellow Moneydance user.

    No software is going to work with a QBB file, it a proprietary format to start with and Quickbooks is geared toward business finance rather than personal.

    When migrating to or between personal finance programs the preferred format to use is QIF, these files contain raw transaction data, at times you can also use CSV files, with some limitations.

    QuickBooks however does not allow exporting to QIF. Only the Intuit Interchange Format (IIF) is supported.

    An IIF to QIF converter will not solve the problem either, as journal entries can not be exported in IIF format, only lists are exportable and it is the journal entries that are needed.

    A potentially viable way to overcome this problem is to set up a journal report, to show all journal entries. Print the report using the "print to file" option. Set the file type to Excel before printing. Rename the extension of the resulting file from PRN to CSV.

    A well structured CSV file may work as an import for Moneydance, however you may need to use macros in Excel to convert it to the QIF format - especially Investment data, as investment accounts do not work with CSV files.

    To use something like the XL2QIF Excel macro to convert to QIF. the Excel file may need to be reorganized to generate the appropriate format for the macro to work, such as separating cheque accounts from term deposits, etc. The above referenced Excel macro does support split transactions.

    In other words it is not easy, and likely to require some work, even if what comes out of Quickbooks is usable.

  2. 2 Posted by Sandi Crabtree on 13 Jun, 2024 04:06 PM

    Sandi Crabtree's Avatar

    Hi there and thanks for the response. Yea, I’ve been using Enterprise the
    accountants version offered by my accountant for FREE which is on his server.
    It’s been nothing but trouble. We are retired now and I just need something
    simple. My fear is that in the event of an audit I won’t have access to the data
    so I’m just looking for something that can store the data.

     

    It’s $2000 a year for Enterprise desktop, and Intuit stopped the desktop version
    of QuickBooks. Since we are retired I can’t justify spending an enormous amount
    of money just to have the data available. I’m wiling to pay but not $2000 a
    year. Any ideas?

     

    Thanks again,

    Sandi

     

    Sent from Mail [https://go.microsoft.com/fwlink/?LinkId=550986] for Windows

  3. 3 Posted by dwg on 13 Jun, 2024 09:58 PM

    dwg's Avatar

    What I outlined is all I have been able to find regarding getting the transaction data out of Quickbooks.

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac