Course curriculum

    1. 1010 Access Software to Practice With - Options

    2. 1020 New Company Test File - Free 30 Trial

    3. 2080 E Commerce – Shopify, Amazon, eBay - Overview

    4. 2090 E Commerce & QuickBooks - Flow Chart

    5. 2100 Enter Purchase Cycle in QuickBooks Online for Comparison to E-Commerce

    6. 2110 Enter Sales Cycle in QuickBooks Online for Comparison to E-Commerce

    1. 2300 E-Commerce Sales Data to QuickBooks Methods

    2. 2310 E-Commerce Sales Data to QuickBooks Methods Part 2 - Demonstration

    1. 2320 Upload Bank Feed Practice Data

    2. 2330 E Commerce - Sales - Simple Bank Feeds Only Method

    1. 2340 E Commerce Sales - Manual Journal Entry Method - Excel Example

    2. 2350 E Commerce Sales - Upload Example Bank Feed Data from Excel - CSV File

    3. 2360 E Commerce Sales - Manual Journal Entry Method Example

    4. 2370 E Commerce Amazon Sales - Manual Journal Entry Method - Excel Example

    5. 2380 E Commerce Amazon Sales - Manual Journal Entry Method

    1. 2390 E Commerce - QBO Commerce

    1. 2420 E Commerce - Inventory Tracking Methods

    2. 2440 E Commerce – Inventory & COGS Cash Basis Practice Problem

    3. 2450 E Commerce - Inventory Excel FIFO Practice Problem Part 1

    4. 2460 E Commerce - Inventory Excel FIFO Practice Problem Part 2

    5. 2470 E Commerce - Inventory Excel Weighted Practice Problem Part 1

    6. 2480 E Commerce - Inventory Excel Weighted Average Practice Problem Part 2

About this course

  • $49.99
  • 22 lessons
  • 9.5 hours of video content

Description

This comprehensive course introduces students to the specialized accounting practices for e-commerce businesses, primarily focusing on the utilization of QuickBooks Online. In the digital marketplace, e-commerce businesses—entities that engage in online sales of goods or services—often rely on third-party platforms such as Shopify, Amazon, or eBay. This course is designed to address common challenges that arise in managing accounting data in this unique business model.

Students will learn about data selection from third-party platforms and payment processors for their accounting systems, methodologies to organize the data efficiently, and strategies for effective inventory management. A key objective is to determine what level of sales data detail should be transferred into QuickBooks to ensure a balance between comprehensive financial reporting and system performance. The course emphasizes the importance of data summarization to streamline the accounting process and avoid software slow-downs due to data overaccumulation.

We will delve into the principal methods of importing sales data from third-party e-commerce platforms into QuickBooks: utilizing bank feeds, manual journal entry, or employing integration software. The course will provide a detailed analysis of each method, discussing their benefits and drawbacks, and offering guidance on the appropriate circumstances for each use. QuickBooks Online's built-in integration capabilities with e-commerce platforms such as Shopify, Amazon, and eBay will also be explored.

The course additionally addresses the complexities of inventory tracking in an e-commerce environment. We will cover diverse inventory management strategies, evaluating the advantages and potential downsides of each, along with recommendations on the suitability of each method under varying scenarios.

By the conclusion of this course, students will possess a robust understanding of e-commerce accounting principles, equipped with practical tools to effectively manage accounting tasks in an e-commerce setting using QuickBooks Online.