Category: Import/Export

QuickBooks Reporting is Simple with QQube

| January 7, 2011 | 13 Comments

Getting useful reports from QuickBooks, in the format that you want, can be a real chore. Your options are to use the built-in QuickBooks reports, struggle with a complicated data access tool, or use a complicated add-on product that has limitations. This is all about to change with the release of a product that I’m […]

Continue Reading

QuickBooks Add On Programs: IPP and the Intuit Workplace App Center

| May 20, 2010 | 9 Comments

I’ve been writing a series of articles on “add on” programs that can be used to expand the capabilities of your QuickBooks desktop program. This week I’ll talk about the Intuit Partner Program (IPP) and the Intuit Workplace App Center, Intuit’s new method for delivering “apps” to you that work on the web but work […]

Continue Reading

QuickBooks Add On Programs: SDK

| March 25, 2010 | 12 Comments

The capabilities of QuickBooks can be expanded by the addition of “add on” or “QuickBooks Compatible” programs. This week I’ll talk about how developers can use the QuickBooks SDK method of integration and what this means to you as a QuickBooks user.

Continue Reading

QuickBooks Add On Programs: IIF

| February 16, 2010 | 32 Comments

While QuickBooks is a very flexible software system, it probably doesn’t do everything that you need (as far as accounting and inventory control). Fortunately, you can expand the capabilities of your copy of QuickBooks by adding an “add on” or “QuickBooks compatible” program. This week I’ll talk about programs that use the IIF method of […]

Continue Reading

Importing QuickBooks Transactions with Transaction Pro Importer

| January 14, 2010 | 33 Comments

QuickBooks has a “closed” database – they control access to the data very tightly. While you have some limited ability to import list data (items, customers), it is generally difficult to import transaction data (invoices, checks). Today I’m reviewing an excellent tool that you can use to import transactions into QuickBooks (and lists as well), […]

Continue Reading

QuickBooks 2010 Rapid Data Entry

| September 29, 2009 | 18 Comments

Until now, if you wanted to quickly add a large number of records to a list in QuickBooks, you had to resort to using an Excel import or use a third party import tool. This often would be a tedious chore, requiring that you “map” your Excel spreadsheet to the fields in QuickBooks. In the […]

Continue Reading

Review: SmartVault Documentation Management for QuickBooks

| September 7, 2009 | 6 Comments

I’ve talked about documentation management systems (DMS) and their value to a business in my article on PaperSave Plus. Today I’ll review another DMS system that works with QuickBooks:SmartVault. This product takes a different approach than PaperSave Plus – it stores your information in an online server rather than in a database on your local […]

Continue Reading

Review: PaperSave Plus Documentation Management for QuickBooks

| August 22, 2009 | 30 Comments

A Documentation Management System (DMS) is a program that is used to store electronic documents and/or images of paper documents. In this article I’ll talk about PaperSave Plus, a QuickBooks Compatible documentation management system. If you are working with QuickBooks you may find that you have various documents that you want to associate with transactions. […]

Continue Reading

Exporting QuickBooks Transactions with Transaction Pro Exporter

| June 10, 2009 | 26 Comments

QuickBooks uses a “closed” database that you cannot access directly. If you want to extract transaction data, such as invoices or checks, you have to use a third party tool to extract the data (or get the SDK/ programming toolkit and write your own program). Today I’ll review the Transaction Pro Exporter from Baystate Consulting, […]

Continue Reading

Free QuickBooks Reports and Data Export

| July 24, 2008 | 38 Comments

Your QuickBooks company file contains a large part (if not all) of your important company data, but our understanding of that data is limited by the views that QuickBooks provides to us. They have a lot of “canned” reports that are very useful, but every business has its own unique situation that isn’t covered by […]

Continue Reading