Free Convention Inventory Spreadsheet Template

If you sell at conventions, anime expos, comic cons, or artist alley events, keeping track of your inventory is one of the most important things you can do. Knowing what you have, what it costs, and what it sells for is the difference between guessing and actually understanding your business.

We put together a free spreadsheet template you can use to organize your products. It has built-in formulas that automatically calculate remaining stock and profit as you fill in your sales. It works with Excel, Google Sheets, Numbers, or any spreadsheet app. You can also import it directly into Conventory if you want automatic inventory tracking and sales reconciliation.

What's in the template

The template has nine columns. The first six are your product data, and the last three are for tracking sales and profit:

• name- The product name (e.g., "Totoro Sticker Pack")
• category- The IP or franchise (e.g., "Studio Ghibli", "Original")
• type- The product type (e.g., "Sticker", "Print", "Pin")
• quantity- How many you have in stock
• price- Your selling price
• cost- What it costs you to make or buy each unit
• sold- How many you sold at the convention (fill this in after)
• remaining- Auto-calculates how many are left (quantity minus sold)
• item profit- Auto-calculates profit for that product (sold x margin)

There's also a total profit sum at the bottom that adds up all your item profits.

How to use it

1. Download the spreadsheet above
2. Open it in Excel, Google Sheets, or Numbers
3. Delete the sample rows and add your own products
4. Before each convention, update your quantities
5. After each convention, fill in the sold column

The remaining, item profit, and total profit columns update automatically as you fill in your sales. The formulas are pre-built for 30 rows, so just add your products and go.

This works fine for getting started. But once you're doing multiple conventions, the manual updates get tedious and error-prone. That's where dedicated tools help.

Why convention artists switch from spreadsheets

Spreadsheets work until they don't. The common pain points convention artists run into:

• Forgetting to update quantities after a convention, so your next count is wrong
• No easy way to track sales per convention or compare performance across events
• Manually calculating profit after accounting for costs, expenses, and table fees
• Restocking math, like figuring out what to reorder and how many
• Managing the spreadsheet on your phone at a booth is painful

Import into Conventory

If you want to skip the spreadsheet workflow entirely, you can import this template directly into Conventory. It accepts both Excel and CSV files, and handles inventory tracking, live sales counting at your booth, convention-by-convention profit breakdowns, and automatic quantity updates, all from your phone.

The free trial is 30 days, no credit card required. Import your products in under a minute.