- Excel Spreadsheet For Ebay Sales Unique Inventory Template For Mac Pro
- Excel Spreadsheet For Ebay Sales Unique Inventory Template For Mac Download
Otherwise, how would you know if you're really making any money or not? One of the most inexpensive ways to track your sales is with an excel eBay sales spreadsheet. Here is a breakdown of the columns your eBay sales spreadsheet should include and why. I've provided formulas where needed, however, if you decide not to use some of these columns or you rearrange the columns, the formulas will be different and you'll need to adjust for accuracy. If you need a little help or have questions, please leave a comment below!
This video is about Inventory Spreadsheet that I use to track all of my purchases, sales, and expenses for my eBay business. Use it for no matter what you're flipping. In this short video, I discuss how to keep track of you eBay financials (accounting and bookkeeping) using a simple Microsoft Excel spreadsheet. This spreadsheet will help you to determine your.
EBay Item Number Column G Yet another way to identify your item sold if you need to find your item quickly. Final Sale Amount Column H This the final amount that the item sold for, not including shipping (unless your item was free shipping). Shipping Amount Column I Not only will this help you track how much you collect for shipping but also how many of your sold items were free shipping. Sales Tax Column J You are charged fees on all money collected, including sales tax.
Excel Spreadsheet For Ebay Sales Unique Inventory Template For Mac Pro
Excel Spreadsheet For Ebay Sales Unique Inventory Template For Mac Download
Therefore, be sure to have a column so you can add sales tax to your total amount received. Total Received Column K If you have your formula properly set, you shouldn't need to touch this column.
The formula for this cell should look something like this: =SUM(H6:J6) adding your final amount, shipping, and sales tax together. See the example below. Listing Fees Column O If you paid any additional fees for your listing (insertion fees, listing upgrades, etc.) record them in this column. Actual Shipping Cost Column P This is where you need to record how much you spent to ship the item.
Delivery Confirm & Insurance Columns Q & R Create a separate column for each of these to record any additional shipping upgrades, if needed. Product Cost Column S You should have a separate inventory spreadsheet where you record how much the item cost you to buy. You want to record that amount in this column. Total Costs Column T Now we're going to use another formula to add all these columns together and record all of our costs.
The formula for this cell should look something like this: =SUM(L6:S6) adding final value fee, PayPal fee, listing fee, actual shipping cost, delivery confirmation/insurance, and product cost. See the example below.