SIZ Approved Course| Amazon VA Dropshipping|Lecture 05|20% beneficiary to @siz-official

in Steem Infinity Zone3 years ago

Assalam-o-Alaikum!
Stemians I hope you all are fine.

I am here again for you guyz with my 5th Lecture of course Dropshipping.
In the last tutorial we have been learning about CRM and its tasks. In the last tutorial we had learnt about how to update tracking. Today we are going to learn about Accounts, in which we are learning about how to make reports.
So, Let's start.

a1.jpg
Image Source

The very first report that we have to make is Order Report.

Order Report


Order Report is basically has two portions:

  • Amazon Detail
  • Supplier Detail
    Let me show you with an example. First step is to make an excel sheet with following headings:

a2.png

a3.png

Let's start with the Amazon Detail.

a4.png

The things that we need is highlighted now we can add these data in our sheet.

a5.png

Formulas:

Sub Total = Price x Qty

Amazon Tax is 15% on Products whose price is greater than 15 and 8% on products whose price is less than15.
To calculate Amazon Tax we apply the formula:

Amazon Tax = If(Price>15,Sub Total x 15/100, Sub Total x 8/100)

Balance Price = Sub Total - Amazon Tax

Now let's deal with Supplier Detail.

a6.png

Copy the seller id from your sheet and search it on your sams membership, then add the details you require.

a7.png

a9.png

Note: Here the saving is basically a discount if any product has discount on it then it will be automatically calculated.

Formulas:

Total Cost = Sub Total + Tax + Shipping - Saving

Profit = Balance Price - Total Cost

Delivery Report

a10.png

Status is depend on order status, basically there are 4 types of status:

  • In Progressing: This is first state after placing an order.
  • Shipping: The second state is shipping state.
  • Shipped: When your supplier gave you a tracking then the status of order changes to Shipped.
  • Delivered: This is the final status when order is delivered.

This is all for today. I hope you guyz have learnt it. Actually Report Management is very important in this business. If you don't keep an eye on every in coming and out goings properly then it will be really difficult for you to manage a business. You can say it is the core of business.

l2.png

Steem Infinity Zone Team

@cryptokraze | @arie.steem | @qasimwaqar | @vvarishayy

footer.png

Sort:  
 3 years ago 

Tou have a great knowledge about Amazon VA drop shipping .
Keep sharing posting with us.

Regards, Faran Nabeel