Integrating QuickBooks with Your Online Store — eCommerce-Guide.com

You are in the: Small Business Computing Channel

ť ECommerce-Guide | Small Business Computing | Webopedia | WinPlanet

News, reviews and practical solutions for your online business

Selling on eBay

Advertising & Marketing

ECommerce Building

Secure Payment Processing

Customer Relations

Search
ECommerce-Guide

Search internet.com

Become a Partner

Free Newsletters

ECommerce-Guide Daily

Small Business Computing

WinPlanet

Webopedia

E-mail Offers

Newsletter Address Changes

internet.commerce

Be a Commerce Partner

internet.com

IT
Developer
Internet News
Small Business
Personal Technology

Search internet.com
Advertise
Corporate Info
Newsletters
Tech Jobs
E-mail Offers

You are in: ECommerce-Guide > Solutions > ECommerce Building

ECommerce-Guide Essentials

eBiz FAQ
Everything you need to know to start your own successful e-business.

Selling on eBay
How to make money in the online marketplace.

PayPal Payments and More
What's new in secure payments for your online store.

Shopping Cart Software
Solutions to close, process and track your online sales.

Related Articles
• eBay Watch: ProStores 9.0, Listing Tools, New Ad Site
• Review: Volusion 5 Delivers the Goods So You Can Too
• Intuit Makes E-tail-to-QuickBooks Connection

ecommerce-guide solutions

Integrating QuickBooks with Your Online Store
By Wayne Kawamoto
April 15, 2008

Streamlined accounting is an e-commerce holy grail — financial transactions, as well as contact and product information, that flows freely between your online store and bookkeeping application. If you rely on a fully integrated online application such as NetSuite, you already have this capability. But if you started with QuickBooks and later added sales capabilities through an e-commerce provider, you may feel that your online store and accounting application have as much in common as oil and water.

Early on, Peachtree provided its customers with built-in, online selling capabilities that it still offers today. Meanwhile, Intuit chose to rely on other companies to provide e-commerce services. And while QuickBooks provides some means to work with others, the e-commerce providers are mostly responsible for making these updates work.

Related Articles

» Intuit Makes E-tail-to-QuickBooks Connection

»
eBay Watch: ProStores 9.0, Listing Tools, New Ad Site

»
Volusion 5.0 Delivers the Goods So You Can Too

We chose three online storefronts to profile: ProStore, Volusion and Yahoo! to demonstrate three different approaches to integrating sales information into QuickBooks.

Integrate What?
To start, what does integration between an accounting application and e-commerce store do for you? At the low end, with no integration at all, you have to physically record all sales that you make through an online store and manually enter them, one by one, into your accounting program.

Full integration, in theory, allows information to flow both ways and automatically update each application. Thus, when you fire-up your accounting program, you can see all of your online sales already entered and displayed, as well as credit card deposits and fees and adjusted inventory.

And vice versa, when you update prices or adjust physical inventory in your accounting program, these are reflected in your online catalog. It's a convenience that removes tedious data entry and the potential for errors from the process.

QuickBooks at Your Service
These days, Intuit recommends a select group of e-commerce providers through its QuickBooks Merchant Services program that includes: Go Daddy, Homestead, Network Solutions, ProStores, ValueWeb and Website Pros. These providers are well known market leaders and the level of integration varies with each provider.

"We give our customers the most efficient way to enable their Web store to work with QuickBooks and QuickBooks Merchant Services," said Dan Wernikoff, vice president of product management for QuickBooks Merchant Services. "With close integration between a Web store and our accounting solutions, users save precious time and benefit from greater accuracy. They never have to re-enter sales data from their Web store in QuickBooks or manually reconcile transaction fees and expenses associated with credit card sales."

In addition, QuickBooks Merchant Service allows your business to accept credit cards through a Web store. Customers can use credit cards to make purchases and potentially, these sales can be immediately processed and reflected in QuickBooks.

Going Pro with ProStores
With powerful eBay ties, ProStores offers an excellent, stand-alone, Web-based service that allows small businesses to sell goods on the Web. ProStores is one of the six Intuit-blessed providers and offers integrated support for QuickBooks and QuickBooks Merchant Services.

Two-way integration comes via the company's "StoreSync technology," which allows you to build an online store based on your existing QuickBooks database. This transfers all product related information — descriptions, prices and quantities in stock — from QuickBooks into your online catalog. And likewise, you can transfer invoices and customer records from ProStores into QuickBooks so that they are entered and displayed and view related credit card fees that are separate from sales.

(Continue to Page 2 for Volusion and Yahoo Details)

Go to page: 1 2 Next

Tools:

Add ecommerce-guide.com to your favorites

Add ecommerce-guide.com to your browser search box
IE 7 | Firefox 2.0 | Firefox 1.5.x
Receive news via our XML/RSS feed

WebMediaBrands Corporate Info

Legal Notices, Licensing, Reprints, Permissions, Privacy Policy.
Advertise | Newsletters | Shopping | E-mail Offers | Freelance Jobs

Whitepapers and eBooks

Adobe Article: Adobe Helps PHP Developers Create Rich Internet Applications
Adobe Article: Java Developers Finding a Home at Adobe Flex
IBM Articles: A Smarter Business Needs Smarter Technology
Intel Xeon Processor Increases Server Efficiency and Capabilities
Intel Tech Brief: Automated Energy Efficiency for the Intelligent Enterprise
Oracle Whitepaper: Using Oracle In-Memory Database Cache to Accelerate the Oracle Database
Oracle Whitepapers - Innovation for IT Leaders
Avaya Article: Communication-Enabled Mashups--Empowering Both Business Owners and IT

Internet.com eBook: IT Manager's Guide to Social Networking
Internet.com eBook: Get Ready for Windows 7
Microsoft Article: Expression Web 3--New Features for PHP Developers
Whitepapers: Manage Your Business Infrastracture with IBM
Whitepaper: Maximize Your Storage Investment with HP
Internet.com eBook: Becoming a Better Project Manager
Microsoft Article: Stress Free and Efficient Designer/Developer Collaboration
MORE WHITEPAPERS, EBOOKS, AND ARTICLES

Webcasts

Webcast: Connecting PHP to Microsoft Technologies
Video: Microsoft Partner Program Benefits
Video: Windows Azure Debugging Tips
SAP BusinessObjects Webcast: Unlock the Power of Reporting with Crystal Reports

IBM Webcast: Speed Business Innovation with Reduced Cost and Risk
Video: Deploy Applications on Windows Azure
MORE WEBCASTS, PODCASTS, AND VIDEOS

Downloads and eKits

Downloads & Free Trials: Microsoft's New Efficiency Resource Center
Get the Windows 7 SDK
Free Trial: Red Gate SQL Backup Pro 6

Iron Speed Designer Application Generator
MORE DOWNLOADS, EKITS, AND FREE TRIALS

Tutorials and Demos

Virtual Lab: Migrating PHP Applications
Enabling Web Slices and Accelerators with a PHP Site
Internet.com Hot List: Get the Inside Scoop on the Hottest IT and Developer Products

All About Botnets
MORE TUTORIALS, DEMOS AND STEP-BY-STEP GUIDES