Skip to content
Live Classes and Webinars

eCommerce in QBO

For someone else
Alicia Katz Pollock
For someone else
Purchase for $74 or enter access code

QuickBooks Online has free built-in integrations to manage your PayPal, Square, eBay, and Amazon e-commerce sales & electronic payments. Learn how each app works, as well as alternatives for when you don’t want to import every sale into QBO.

You’ll Learn About

  • PayPal and Square vs. QuickBooks Payments to receive money
  • Why Venmo isn’t a good idea
  • Managing transaction fees
  • Do you want to bring in every transaction or a summary?
  • Do you want to bring in every customer name, or put all sales under each channel?
  • Importing PayPal transactions
  • QBO’s Square integration
  • QBO’s Commerce center for importing Amazon, Shopify, and eBay
  • How to use a clearing account for minimal management


After completing this course, you will be able to: 

  • Describe the process to connect common payment gateways to QBO
  • Recall how QBO manages eCommerce imports
  • Identify the considerations for importing individual transactions or daily summaries
  • Recall the purpose of clearing accounts for bulk entry
  • List the methods for managing merchant service fees


Instructional Level


Course Length

2 hours

Course Credits

2 CPE, Certificate of Completion

Field of Study

Computer Software & Applications

Delivery Method

Group Internet Based

Who should take this class?

  • Bookkeepers and Accountants with e-commerce clients.
  • Business owners who take payments using PayPal and Square
  • Businesses who sell on Amazon and eBay
  • Prior QuickBooks® Online experience

Advance Preparation 



Preview this course:

Get a sneak peek of what's inside this value-packed training. Watch the brief video below to explore the topics we'll cover and see the quality of content you can expect. Your journey to mastering the material starts here!


Course Description 

E-commerce has become the new normal. Nowadays, everyone is shopping online or paying for everything electronically.  Today more than 13% of ALL transactions in the United States are made online or go through an e-commerce based point-of-sale system, and it’s just going to increase from here.

If you’re in business today, it’s crucial that you know how to integrate e-commerce with your QuickBooks® Online, or you’re going to waste a lot of time and make a lot of financial mistakes. 

Whether you’re selling your products on Amazon and eBay, using Shopify for your own company’s website, managing a retail store using Square as a point-of-sale system, or taking payments via PayPal and Venmo, you need a way of recording your income in QuickBooks Online...and do it without creating duplicated systems. 

QBO to the rescue! QuickBooks Online simplifies the process and has pretty much done the work for you.
Intuit has banking integrations and a Commerce center that imports your PayPal, Square, Amazon, Shopify, and eBay sales.

Some companies want to import every transaction with customer detail. Others only need a daily or monthly summary. We’ll explore the pros and cons of each approach and then demonstrate all the integrations so you can set them up on your own.

Importing your sales from e-commerce websites and electronic payment methods into QBO has never been easier!
If these apps aren’t right for you, we’ll also explain clearing accounts, a simplified “sledgehammer” approach to e-commerce bookkeeping. We'll also talk about what to do with transaction fees!

If you need even more robust or automated solutions, we’ll also explore third-party apps including Bookkeep and A2X.
Whether you’re just starting to sell online, or you’re a seasoned pro that just wants to make their process a little more streamlined, this course is for you!


Learners rave: Find out why people love this course!

Discover the overwhelming praise as past learners share their experiences with this course. See all the reviews by clicking the 'Reviews' tab near the top of this page.


Watch it again later

You'll have lifetime access to the on-demand course including all handouts and class material. You'll also be able to ask questions in the Q&A forum and get answers, even years later. You can pause, rewind, speed up, and watch again and again as you apply what you learn to each situation as it crops up.


Want this course for FREE? Unlock this course & more for no extra cost with an OWLS Membership!

Get instant access to ALL of Alicia's QuickBooks courses for FREE when you become a silver member - it's the perfect way to maximize your learning!

OWLfred says, "Silver membership pays for itself in just two courses per month!"






Refunds & Cancellations

Please view our Terms of Service, for information on refunds, cancellations, and complaint resolution. To request a refund, please contact us.


Royalwise Solutions Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website:


Course Credits: 2 CPE, Certificate of Completion. Must be awarded within one year of enrollment.

Course Updated: April 2024
Course Page Updated: April 2024

Here is the course outline:

1. How to Join the Live Zoom Webinar

Zoom Webinar

Click the link to learn how to join the webinar, on Tuesday April 30 at 10am to 12pm pacific time

How to connect to the Zoom webinar

2. Download the Handout

Download the handout that goes with the course.

Download the handout here
Glossary of Terms

3. Watch the Videos: Connect to PayPal, Square, and Etsy

QuickBooks Online has free built-in integrations to manage your PayPal, Square, and Etsy e-commerce sales and electronic payments. Learn how each app works, as well as alternatives for when you don’t want to import every sale into QBO.

Intro and Agenda: Connect to PayPal, Square, and Etsy
Biz View vs Accountant View
eCommerce Considerations
How to Import Sales
QBO's Built-in Integrations
How to Sync with Square
Sync with Etsy
Conclusion. What's next? Learn something, need more help?
Review Questions: PayPal, Square, and Etsy

4. Take the Quiz

Take this quiz to demonstrate your mastery of the material. Pass the quiz with an 80% or higher to complete the Course, earn your Certificate, and win points!

Quiz: Connect to PayPal, Square, and Etsy
Evaluation & Participation Survey


The following certificates are awarded when the course is completed:

Royalwise CPE Certificate
Back to top