Skip to content
QuickBooks® Training Library: The KnOWLedge Base

eCommerce in QBO


Course
Quantity
For someone else
Alicia Katz Pollock
Quantity
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
  • 3rd party apps that automate e-commerce imports into QBO

 

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
  • Distinguish when 3rd party apps would be helpful to automate ecommerce imports

 

Instructional Level

Intermediate

Course Length

1.75 hours

Course Credits

1.75 CPE, Certificate of Completion

Field of Study

Computer Software & Applications

Delivery Method

QAS Self Study

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

Pre-requisites 

  • QuickBooks Online experience

  • Familiarity with an eCommerce platform such as Shopify or Amazon

Sponsored by Bookkeep.com!

The smarter e-commerce and retail accounting automation platform!

Bookkeep.co logo

 

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. We'll even do a demo of how Bookkeep works to import your daily sales as a journal entry.

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: www.nasbaregistry.org.

 





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

Course Updated: May 2024
Course Page Updated: May 2024

Here is the course outline:

1. Download the Handout (Required for CPE Credit)

Download the handout that goes with the course.

Download the handout here (Required for CPE Credit)
Transcript: eCommerce in QBO
Glossary of Terms

2. Watch the Videos: eCommerce in QBO (2024)

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 like Bookkeep for when you don’t want to import every sale into QBO.

Intro and Agenda
eCommerce Considerations
Sales Transactions Types
Sales Summaries
e-Commerce Review 1
How To Import Sales
QBO's Built-in Integrations
App Transactions
QBO Commerce
3rd Party Integrations, Bookkeep Demo, and Conclusion
e-Commerce Review 2

3. 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: eCommerce in QBO
Evaluation & Participation Survey

Completion

The following certificates are awarded when the course is completed:

Royalwise CPE Certificate
Back to top