TCG VENDOR WORKBOOK

What did that sale
actually earn?

Try the numbers below. See what’s left after card costs and selling fees.

Try adding a fee. The profit changes as you type.

One purchase. One sale.Fictional example · USD

Inventory LOT-001 · Example card

Cards boughtCost per card ($)

Sales Using LOT-001

Cards soldSale price per card ($)Fees for this sale ($)Shipping you paid ($)

Change any amber cell to try your own example.

Cards left in stock7

Profit on this sale$7.50

$15.00 sale − $7.50 card cost = $7.50 profit

Amber cells: you enter · Gray cells: calculated

INSIDE THE DOWNLOAD

A workbook you can keep using.

Inventory, Sales, Summary and Guide. Here’s the actual Summary tab with the included sample data.

The preview below includes several fictional transactions. Its monthly total is different from the single sale above.

Actual workbook Summary tab with example monthly sales of 33 dollars and net transaction profit of 15 dollars 90 cents

The full workbook keeps the history.

500 purchase lots. 1,000 sale or return lines. Monthly totals, stock at purchase cost, and review messages for missing costs or duplicate IDs.

Open it in a few minutes.

Download the ZIP from Etsy, unzip it, and open the .xlsx in Excel. For Google Sheets, upload the .xlsx to Drive and open it with Google Sheets. Start with the Guide tab. Clear the amber sample inputs: Inventory A7:G9 and Sales A7:J10. Keep the gray formula columns.

Try fictional numbers here. This demo does not store your entries. Purchases and support stay on Etsy.