HDTutorial
EN

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to do your Amazon Monthly Bookkeeping, Amazon Seller Central, QuickBooks Online, 2020

72,359 views June 14, 2020 28:29

Watch on YouTube
ChannelSarah Korhnak

Chapters

Description from the creator

🎁 FREE: Amazon Money Launch — the simple money setup every new Amazon seller needs → smallbusinesssarah.com/amazonmoneylaunch?utm_so…

**Update** New Updated Video Available: youtu.be/QnZlGKHmZyM

I recommend QuickBooks Online for your Amazon Seller bookkeeping. Get the current QuickBooks Online deal through my referral link: SmallBusinessSarah.com/quickbooks

I love QBO but my Amazon Bookkeeping Spreadsheet is a great fit for smaller sellers who want a low-cost, accurate way to track income and expenses—and it’s easy to set up and start using right away. shop.smallbusinesssarah.com/products/bookkeepin…

Let me show you how to do your Amazon Monthly Bookkeeping in this QuickBooks Online tutorial. This method does not use any apps or integrations. It's fast, easy, accurate, and done once a month. This is a great bookkeeping solution for every Amazon Seller in Amazon Seller Central. It's the method I use every month for all of my bookkeeping clients.

I'm using QuickBooks Online for my bookkeeping. It's the program I love to use and highly recommend. Here's my referral link: SmallBusinessSarah.com/quickbooks

If you need to set up your Amazon Chart of Accounts, watch this video first: youtu.be/QCmUNOW3g90

Here's how to tie out your Profit & Loss report at year end to the 1099 you receive from Amazon: youtu.be/0Ze8mduCDHk

For more e-commerce tax and bookkeeping help head to:
SmallBusinessSarah.com

Time Stamps
0:00 Let's get started with Amazon Seller Bookkeeping!
0:40 Method relies on inputting monthly activity from Amazon in the form of a journal entry
0:55 Find the information from the Amazon home screen (Choose Reports → Payments → Date Range Reports → Generate Reports → Summary → Choose the Month → Generate → Refresh → Download)
1:45 Summary of Amazon Report
3:07 Highlight specific accounts that are reported in Amazon that we want to separate out in the journal entry so the QBO Profit & Loss matches Amazon’s numbers on the 1099.
4:40 Numbers to break out for income
8:41 Numbers to break out for expenses
10:19 Notes on sales tax
11:32 What to do with this information in QBO
11:48 Categorize Amazon transactions in QBO
12:55 Make the Journal Entry (Click New → Journal Entry)
17:05 How this works together in the Register
19:58 How the journal entry appears on Profit & Loss statements (Reports → Profit & Loss → This Year → Run Report) and compares to the Amazon report
21:37 How the journal entry appears on the Balance Sheet (Reports → Balance Sheet → This Year → Run Report)
22:34 Review of process and big picture concepts and how this all works together

This video is for informational purposes only and does not constitute accounting or tax advice.

About this tutorial

Sarah Korhnak published this 28:29 video tutorial on June 14, 2020. It has been watched 72,359 times on YouTube.

Category
Education
Duration
28:29
Published
June 14, 2020
Views
72,359
Likes
1,765

Tags

Share

This tutorial in other languages