How to Use Our Reseller Spreadsheet Template to Optimize Your Reselling Business

Are you looking for a way to streamline and optimize your reselling business on platforms like Poshmark, eBay, Mercari, and Etsy? Our Reseller Spreadsheet Template is here to help! In this instructional blog post, we'll walk you through how to use each tab of the spreadsheet to effectively track your inventory, sales, and business performance.

Step 1: Track Your Inventory with the Inventory Tab

1. Date Selector: Start by using the date selector to pick the date you purchased each item. This helps you keep a chronological record of your inventory.

2. Item Details: Add a description of the item, quantity, and select the appropriate category. Categories can be edited under the "Categories" tab, which is the third tab in the workbook.

3. Purchase Price: Enter your purchase price. If you have more than one item, the spreadsheet will automatically calculate the cost per item.

4. Source Location: Enter where you purchased the item. This helps you track your best sourcing spots, allowing you to identify which locations provide the best returns.

5. Storage Tracking: Use the next column to track where you store each item. This ensures you can quickly locate items when needed.

6. Sold Checkbox: Once an item is sold, click the sold checkbox. This will automatically move the item to your sales spreadsheet.

7. Listing Details: The last two columns are for a link to your listing and the platform it is listed on (e.g., Poshmark, eBay, Mercari, Etsy).

8. Inventory Dashboard: The dashboard at the top of the page will automatically track how long items have been in inventory and categorize your items. This helps you make informed decisions about what items sell the best for you.

Step 2: Manage Your Sales with the Sales Spreadsheet

1. Sold Items: Once an item is moved to the sales spreadsheet, enter the sold date, sold price, and your listing costs. These entries will automatically calculate your profit.

2. Order Fulfillment: Use the last column to track the order fulfillment process, ensuring you stay on top of each sale.

3. Additional Costs: You can also add any additional business costs in the far right column.

4. Sales Dashboard: The dashboard at the top automatically displays your costs, profit, and sales by category. It also includes a simple cost analysis to help you find ways to optimize profit and reduce costs.

By following these steps, you can efficiently manage your inventory and sales, making data-driven decisions to boost your reselling business.

Happy Selling!