Online Arbitrage Tracking Google Sheet - V2
This is the Google sheet I use to track all my online arbitrage purchases for resale on Amazon. I have created it with some automations to save time and make receiving easier for my helpers.
You'll get the most benefit if you are already using either the AZ insight extension or Rev Seller and Inventory Lab. It can be used without, but was made primarily to complement these tools. Those tools are not free, and are not sold by me.
Features:
Custom created MSKU
Automatic allocation of tax/shipping/discounts to landed cost per unit
Ability to track your purchases by source, for example by leads list, VA, employee, etc
Receiving tab with automatic Amazon Images pulled in, showing only outstanding orders
Nearly automatic creation of your Inventory Lab import file
Dashboard showing purchases/cost/margin/ROI per day, per store and per source
Dashboard showing total purchased not yet received by store
Macros, queries, drop downs, lookups that make data entry quick and efficient.
A walkthrough on how to use version 1 of this google sheet can be found at:
There are some updates in this version 2 not discussed in the YouTube video, so read the instructions tab!