Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
QuickBooks For Amazon Online Merchant Sellers
Rating: 4.4 out of 5(18 ratings)
1,925 students

QuickBooks For Amazon Online Merchant Sellers

Help For Those Who Sell Merchandise Inventory Through The Amazon Interface Platform
Created byMark Smolen
Last updated 5/2021
English

What you'll learn

  • How To Use QuickBooks Desktop With An Amazon Online Store Selling Merchandise Onlie Via Amazon
  • How To Set Up A QuickBooks Desktop File For An Amazon Online Merchnat Store
  • How To Record The Bi Monthly Deposit From The Bi-Monthly Deposit Statement That Amazon Gives To Sellers
  • How To Use The Periodic Inventory System To Adjust For Cost Of Goods Sold And Find Gross Profit From Sales
  • How To Correctly Adjust Inventory And See An Overview Of The Amazon Inventory Lab
  • How An Amazon Merchant Seller Should Record General Non-Amazon, Expenses
  • How To Find Ant Recorded Transaction In QuickBooks Desktop; Very Easily

Course content

1 section8 lectures1h 45m total length
  • Introduction And Overvew Of The Amazon Desktop QuickBooks Course2:55

    In this learn QuickBooks training tutorial, you will learn how to set up QuickBooks for an amazon online store. QuickBooks is perfect if you have an online Amazon store. When you receive your Amazon Deposit statement, you can enter it directly in to QuickBooks with this simple, step by step, video that will make everything work perfectly. All of the different Amazon fees are accounted for as they are deducted from the bi-monthly amazon deposit. Some Amazon fees are the product cost, and some are for other services that amazon provides for you like free shipping to the customer. The net amount is what they put in to the account that you associated with your amazon account online store. If you set up your QuickBooks file this way and input the statement 2 times a month as demonstrated, your QuickBooks financial records will always be correct, and you will be able to use QuickBooks reports to really see the status and progress of your amazon online store. I assure you that all other transaction will be exactly the same as any other business. If you are recording your amazon income in to QuickBooks, then everything else on the expense and payment side of your company can be recorded in to QuickBooks the way any other business does.

  • Set Up A QuickBooks File For An Amazon Online Merchant Store20:35

    This Amazon Learn QuickBooks video training tutorial you will see a very fast, abbreviated demonstration of each step in the basic file set up of an Amazon online merchant store that uses QuickBooks desktop. This is the first video in the Amazon QuickBooks playlist. After following each set up part step by step, you will be able to replicate the next video that follows this one. That’s the video where you record your Bi-monthly deposit from amazon for your net sales minus expenses. Each of these will be listed on your amazon statement. You need to put an account in the chart of accounts for each item listed on your amazon bi-monthly deposit statement. You will also see how to manage the icon bar, preference settings and file creation for a fast and easy set up to your Amazon online emrchant business.

  • Recording The Amazon Bi-Monthly Deposit From The Amazon Statemnt16:32

    In this learn QuickBooks training tutorial, you will learn how to set up QuickBooks for an amazon online store. QuickBooks is perfect if you have an online Amazon store. When you receive your Amazon Deposit statement, you can enter it directly in to QuickBooks with this simple, step by step, video that will make everything work perfectly. All of the different Amazon fees are accounted for as they are deducted from the bi-monthly amazon deposit. Some Amazon fees are the product cost, and some are for other services that amazon provides for you like free shipping to the customer. The net amount is what they put in to the account that you associated with your amazon account online store. If you set up your QuickBooks file this way and input the statement 2 times a month as demonstrated, your QuickBooks financial records will always be correct, and you will be able to use QuickBooks reports to really see the status and progress of your amazon online store. I assure you that all other transaction will be exactly the same as any other business. If you are recording your amazon income in to QuickBooks, then everything else on the expense and payment side of your company can be recorded in to QuickBooks the way any other business does.

  • Understanding Inventory And Cost Of Goods Sold In Your Amazon QuickBooks File17:36

    This Amazon Learn QuickBooks lesson explains how the “periodic inventory system” works for your Amazon Online Store. Since you cannot keep a continues running count of the quantity of your merchandise as it comes in and goes out, you must use the periodic inventory system. This system requires that you physically count and value your inventory on hand at the end of each month. You must find the amount that you paid for the inventory on hand each month. Then, you will have to make 3 adjusting entries to properly calculate the cost of goods sold. That’s what you paid for the goods you sold the customer. Then, you will subtract that from your gross sales to find your gross profit from selling merchandise.

  • Adjusting Inventory In QuickBooks To Find Your Profit In An Amzon Online Store15:39

    This Amazon Learn QuickBooks video training tutorial demonstrates and explains how to make your inventory adjustment at the end of each month so that you can know your gross profit and net income. Amazon sellers and online merchants must use the “periodic” inventory system or method. This is because it is usually impossible to track the quantity after each individual sale or each individual purchase. Therefore, you must physically count the items that are on hand as of the last day of the month and find out what you paid to purchase them. When you adjust inventory, the ending inventory of 1 month becomes the beginning inventory of the new month. You record all your merchandise inventory purchases in to the “purchases” account. This is an account that is part of “cost of goods sold”. To find your profit, you must use the textbook accounting end of month adjustment to update the inventory asset account balance for the new month and ‘zero out” the purchases account so you can clearly see how much of purchases you have for each separate individual month. The cost of goods sold will be identified in each separate month so that you can compare the profit and loss across each separate individual month.

  • Preparing Inventory And Using The Inventory Lab9:42

    This Amazon Learn QuickBooks video training tutorial you will learn 2 things: how to make the beginning inventory adjustment if you had inventory available to sell before you started using QuickBooks, AND you will get an overview of the Amazon Inventory Lab. This Inventory lab is an add on app that Amazon charges about $50 per month to Amazon merchants so that they can see and manage the merchandise that they sell to their final amazon customers. This video is a brief overview of what it is and how it works. Only an overview is necessary to at least see how to identify your purchase costs of the ending inventory so that you can use that number to adjust and calculate your cost of goods sold and your gross profit

  • Recording General, Non-Amazon Expenses And Finding Transactions In Quickbooks14:21

    This Amazon Learn QuickBooks video training tutorial you will see a very fast, abbreviated demonstration of how to record general administrative expenses for your Amazon Online Merchant store. Amazon sellers would record expenses in the” write checks” window the same way that any other company would. The expenses lower the balance of the bank account that you paid from as well as increasing the amount recorded in the expense account. The administrative non-amazon expenses will show up in the bottom of the profit and loss stamen to decrease your monthly net income. This video QuickBooks lesson will also show the best ways to find transactions that you have already entered and recorded in your amazon QuickBooks merchant file. You can use the trial balance, the “find” window and the Journal report to quickly and easily find anything in the QuickBooks Amazon Merchant store file.

  • Unavailable Balance Matching Adjustment8:06

    This Amazon Learn QuickBooks video training tutorial you will learn how to make your “unavailable balance” asset account equal to exactly the amount that you will receive in the future. If you started doing the QuickBooks dude procedures for your amazon online merchant store, then the amount withheld for unavailable balance was zero in the first deposit statement. So, your balance in your QuickBooks records should match the balance shown for unavailable in the bottom of each amazon statement. However, if you started doing the QuickBooks dude procedures when you already had some unavailable balance, then your account in QuickBooks is not reflecting the actual amount receivable in the future from amazon. The way to fix this is to make a journal entry that corrects the balance of your asset account and the balancing account, as in all set up journal entries, is ‘opening balance equity”.

Requirements

  • Very Basic Computer Skills
  • Have The Need To Use QuickBooks Desktop to Mamage Finanaces Of An Amazon merchant Online Store

Description

This QuickBooks Video Course will show and teach the owners of Amazon online stores how to use QuickBooks Desktop for their Amazon online merchant store.

This QuickBooks Desktop Training tutorial series will give Amazon Merchants everything they need to use QuickBooks Desktop to keep financial records of their Amazon Online Merchant Store. This is a follow along, step-by-step training class that shows exactly what to do for each thing that Amazon sellers would need when using QuickBooks.

You will see how to:

Set up a company file in QuickBooks desktop specifically for an Amazon Online Selling Store.

You will see exactly how to record the bi-monthly statement that Amazon gives to their merchant sellers to explain the net amount of the bi-monthly deposit that they put in to our company bank account. You will also learn how to make the monthly adjustment to Inventory and cost of goods sold to be able to find the gross profit and net income of your company. Then, you will see how to establish your beginning inventor number for your first month as well as getting an overview of the Amazon Inventory Lab.

Lastly, you will the see examples of how any typical company would pay general expenses as well as use QuickBooks reports and the “find” window to find any transaction you put in to you Amazon QuickBooks desktop file.

This playlist assumes that Amazon buying, and selling is the only thing your company does. If you do more, then you may need more of the QuickBooks instructional videos right here on this very website. This Amazon playlist is the result of popular demand from Udemy students who sell merchandise via Amazon Online. Amazon traders are essential in these difficult times and I wish to help them in any way I can.

Please contact me through Udemy Q&A or messaging if you need any help with the course or have any issue or question.

-Mark

Who this course is for:

  • All Amazon Merchnat Sellers Who Sell Products Online Via Amazon
  • All Amazon merchants Who Wish To Use QuickBooks Desktop To manage Their Company Finances