merging qb files
Hi, can I migrate my QB Enterprise files?
Comments are currently closed for this discussion. You can start a new one.
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
1 Posted by dwg on 11 Jun, 2024 11:12 PM
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 Posted by Sandi Crabtree on 13 Jun, 2024 04:06 PM
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 Posted by dwg on 13 Jun, 2024 09:58 PM
What I outlined is all I have been able to find regarding getting the transaction data out of Quickbooks.
System closed this discussion on 12 Sep, 2024 10:00 PM.