Description
Seven Video Lessons With Excel Workbook Download
Unit 1 – Introduction
You’ll find a safe place to take a breath and calm the chaos. It’s not as bad as it looks.
Unit 2 – Setting a Course
There’s a plan and we’ll work the plan. It’s a workbook, but don’t worry if you are not super Excel savvy. We’ll start slowly so nobody gets left behind. Yes, it works with Google Sheets too.
Unit 3 – Sales, Selling Fees and Sales Tax
We have a love/hate relationship with these guys, but they are no match for our method.
Unit 4 – Cost of Goods Sold
We’ll discover how Cost of Goods Sold is calculated and where to find the figures we need. Even if you are using Cash Basis accounting and deducting inventory as it is purchased, knowing the COGS is important to judge your Profit & Loss.
Unit 5 – COGS Continued
We’ll learn how to pull the reports and calculate Beginning Inventory, Ending Inventory, Purchases and COGS. This worksheet will provide your CPA with all the necessary sales numbers for either accounting method, Cash or Accural Basis .
Unit 6 – Chasing Rabbits
We could just go get a cup of coffee and call it done, but some of us will want to verify one more thing. Amazon pays the way Amazon pays and we have to deal with that. So in this unit we will show how to reconcile our bank deposits with the total monthly report summary from Amazon. Sounds fun, huh?
Unit 7 – 1099-K
The tax form can be a terrifying thing at first because of the unknown aspects, but really it is just a piece of paper the IRS uses as a little heads-up for what they expect to see reported on our returns.
I’d like to take a minute to introduce myself.
My name is Vicki McCay. With many years in automotive (double-entry) accounting under my belt, QuickBooks was a logical solution when we started a 401(c)3 mission organization almost twenty years ago.
In 2017, I started investigating options for what we’d do when my husband retires. We’ll be debt free, except for living expenses – utilities and food. We won’t need much, but we will need some. So, one day I stumbled upon Amazon FBA. It intrigued me because I liked the fact that it was something I could do without being tied to the house or inventory. We want to be able to travel on the spur of the moment, you know. Since we homeschool, this is a great option for us too.
So, I bought some courses and set sail on a great adventure.
Uh,oh…storms ahead. Amazon is an animal that didn’t play well with my accounting system. There had to be some adjustments. Slowly, the fog cleared. Falling back on my automotive accounting years, I was able to create a process and a posting worksheet that was the solution to the payment statement issues. Then I came up with a process of posting mass invoices. That sealed the deal, QuickBooks is the way to go for me.
However, some folks don’t love accounting as much as I do! I had many clients year after year coming to me in desperation. They’d put off their bookkeeping for months because they didn’t have the skills or time to complete it. There had to be a way to help them even if they didn’t want to use QuickBooks. That’s how this course came about.
Important: Information in this document does not constitute tax or legal advice and must not be used as such. If you have tax or legal questions, please contact your professional adviser. Any course offered here is simply to demonstrate how to use accounting software or spreadsheets. QuickBooks for Amazon Sellers and QuickBooks for Beginners courses have a 30-day refund policy. Spreadsheets and courses for spreadsheets are not included in the 30-day refund policy. I am happy to help with use issues with spreadsheets and courses.
© Southern Mom Flair - All template designs and courses are for your personal business use only and may not be resold or redistributed under any circumstances.
Reviews
There are no reviews yet.