Just One Tab logoJust One TabAll walkthroughs
YOUR WORKBOOK, STEP BY STEP

Online Seller Profit Calculator

Alex, your spreadsheet guide

Follow the screens at your own pace. Replace fictional examples with your own information.

Visual and written guide available below. Recorded narration is being prepared.

Online Seller Profit Calculator example screen for Start with one sale
STEP 1 OF 5

Start with one sale

Use the calculator to review one sale at a time. Save your workbook copy and replace the example figures. Use a consistent tax basis throughout.

Enlarge the screenshot
Online Seller Profit Calculator example screen for Enter what the buyer pays
STEP 2 OF 5

Enter what the buyer pays

Enter the item sale price and the postage charged to your buyer. These amounts make up the receipts used by the calculator.

Enlarge the screenshot
Online Seller Profit Calculator example screen for Include every selling cost
STEP 3 OF 5

Include every selling cost

Add the item cost, postage you pay, packaging and other costs. Enter your marketplace and advertising percentages, plus any fixed fee. Use your own applicable rates. Both percentage fees in this model apply to the item price plus postage charged.

Enlarge the screenshot
Online Seller Profit Calculator example screen for Read the result
STEP 4 OF 5

Read the result

Review estimated profit, the break-even item price and the price needed for your target profit. The example returns twenty-four dollars and two cents. This is a planning result based on the costs entered.

Enlarge the screenshot
Online Seller Profit Calculator example screen for Compare before you sell
STEP 5 OF 5

Compare before you sell

Change the item price or postage cost and check the difference. Set your target profit before accepting an offer. Keep the formulas intact and save your changes.

Enlarge the screenshot

These instructions cover the workbook version shown. Check the product listing for included formats. Google Sheets import and feature compatibility have not been independently verified for these versions.

Download the quick-start steps