QuickBooks

Discuss the spreadsheet application

QuickBooks

Postby KAlmy » Thu Mar 17, 2011 11:24 pm

Quickbooks allows me to export reports to Excel. Does anybody know if there's a way to get it to export to OpenOffice instead of Excel? Thanks, Katherine
OpenOffice 2.0, Windos XP
KAlmy
 
Posts: 1
Joined: Thu Mar 17, 2011 11:20 pm

Re: QuickBooks

Postby TheGurkha » Thu Mar 17, 2011 11:45 pm

OPenOffice.org Calc can read Excel files.
Ubuntu 14.10 Utopic Unicorn, LibreOffice Version: 4.3.3.2
Gurkha Welfare Trust
User avatar
TheGurkha
Volunteer
 
Posts: 6482
Joined: Thu Mar 13, 2008 12:13 pm
Location: North Wales, UK.

Re: QuickBooks

Postby Hagar Delest » Fri Mar 18, 2011 3:37 pm

See also that query.

Please add '[Solved]' at beginning of your first post title (edit button) if your issue has been fixed.

NB: topic moved to the Calc section.
AOO 4.1.6 on Xubuntu 18.10 and 4.1.5 on Windows 7 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28388
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: QuickBooks

Postby pkrhonda » Fri Aug 02, 2013 11:21 pm

Calc will not import Quickbook's Excel export because Calc refuses to operate the macros built into the Excel sheet. I've tried turning off Calc macro security and it still won't import. If anyone else knows of a work-around or a way to create an environment to run it in, I would be ecstatic. In the interim I continue to modify the .CSV export... :? BTW I'm now running OO 4.0 on Win7 Pro 64-bit
OpenOffice 4.0 on Windows 7 Pro 64
pkrhonda
 
Posts: 4
Joined: Fri Aug 02, 2013 7:22 pm

Re: QuickBooks

Postby Villeroy » Sat Aug 03, 2013 11:48 am

Are you telling us that QB exports its data in VBA modules?

http://www.qodbc.com/default.htm is a solution to export from the QB database to any ODBC capable application (such as AOO)
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26410
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: QuickBooks

Postby pkrhonda » Sat Aug 03, 2013 7:46 pm

Villeroy, my apologies, while moderately tech savvy, I don't know what VBA module stands for. I can say, though, that the export function/package/module opens Excel and allow user to choose data range to import, will manipulate data, and can call a different data range. The issue with Calc arises with the inability to get it to run the macros. It opens Calc and responds that security needs to allow the macros to run. Even with the lowest security option to allow all macros to run, the same message displays. Frustrating. The ODBC package you mention appears to be a report generation package. I would prefer to use what they already provide and not have to build my own reports. Sigh...
OpenOffice 4.0 on Windows 7 Pro 64
pkrhonda
 
Posts: 4
Joined: Fri Aug 02, 2013 7:22 pm

Re: QuickBooks

Postby Villeroy » Sat Aug 03, 2013 8:51 pm

Thank you for the clarification. I did not imagine how crazy this data export is organized. Now it would be interesting to see the VBA code which surely utilizes the ODBC driver to dump the report data into spreadsheets.
You can not blame OpenOffice that Intuit developers write code which is understood by Excel and nothing but Excel.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26410
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: QuickBooks

Postby pkrhonda » Tue Aug 06, 2013 5:02 pm

Oh, goodness, Villeroy, I wouldn't blame OpenOffice! Intuit's designers are bound by their company's proprietary relationship to MS, as most common-use vendors are. Believe me, if our kitchen design package would easily run on Unix, I would have bid Windows a fond fare-thee-well long ago. Sorry, not very on point. I was hoping someone smarter than I had faced this and created a work-around or maybe a patch that would create an environment in which Calc could open the macros. Alas, it is manually editing the .CVS file for me.
OpenOffice 4.0 on Windows 7 Pro 64
pkrhonda
 
Posts: 4
Joined: Fri Aug 02, 2013 7:22 pm

Re: QuickBooks

Postby pkrhonda » Tue Aug 06, 2013 5:05 pm

As an aside, I believe I will post a similar request on Quickbooks' user BB and see if I get any bites there. I will advise if I have success and supply the gory details.
OpenOffice 4.0 on Windows 7 Pro 64
pkrhonda
 
Posts: 4
Joined: Fri Aug 02, 2013 7:22 pm

Re: QuickBooks

Postby Villeroy » Tue Aug 06, 2013 7:00 pm

There is an ODBC driver for QB.
There is a database component in AOO which is designed to connect this office suite to databases.
The problem is that virtually nobody is seriously interested in developing any solution.
Everybody nags someone else for a perfect solution which is always a claim like:
"Do exactly the same as Excel does"
or
"Make this program an 100% Excel clone for any 3rd-party software calling Excel".
Technologies do not work like this. Nobody will turn this software into a cloned Gigabyte monster and MS lives very well from being incompatible with the rest of the world. This used to be their business model. There is already a program which behaves exactly like Excel. If you can't afford it then you don't need financial software neither.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26410
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: QuickBooks

Postby jessicacain » Tue Dec 12, 2017 12:20 pm

Office 365 when exporting it.
Jessica Cain is an account manager at SageNext Infotech - one of the leading [url=https://www.thesagenext.com/solutions/quickbooks-hosting]QuickBooks hosting[/url] provider.
User avatar
jessicacain
Banned
 
Posts: 2
Joined: Tue Dec 12, 2017 8:38 am
Location: X: thesagenext.com/

Re: QuickBooks

Postby BRSCPA » Sat Feb 16, 2019 6:56 pm

One option is to export to csv.
Open the report.
Select the Excel drop-down at the top of the report.
Select Create New Worksheet.
On the Send Report to Excel window, select Create a comma separated values (.csv) file.
Select Export.
Assign a file name, then choose the location where you want to save the file.

This will bypass all the unnecessary VBA processing Quickbooks uses to create an Excel Sheet.
However, all formatting will be lost (e.g. fonts, extra column spaces, double underling of totals, etc...)
Also, if you are exporting with account numbers, you will notice a special character between the account number and the account name.
Now the challenge is to write a macro in openoffice to perform the formatting for us instead of having to manually do this.
BEN R SHULL CPA LLC
WIN 10
OPENOFFICE 3.1
BRSCPA
 
Posts: 1
Joined: Sat Feb 16, 2019 6:36 pm


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 18 guests