Automagical Convention Spending Tracker
Sheet1 Table, Badge, Flight, Hotel, Printing, Misc., Misc., Total Expense, Amount Made, Total, Profit,
I posted this to Twitter earlier this week and it kind of blew up, but I want to post it here too. Just a little something I use to help myself keep track of spending during convention season, made into a rainbow because why not make more things rainbow?
Whether you’re tabling or just attending for fun, conventions can get expensive - especially when you include travel costs! I’m no spreadsheet wizard so you still have to enter everything manually, but it takes very little time and it’s worth checking your numbers. I’ve used this sheet for about three years now. It’s nice to look back on and compare to, and helps me make decisions for future conventions. Sometimes it turns out I did better at a con than I thought I did! Or maybe I didn’t do so great compared to last year and need to think about coming back again. Oh, and everything listed are purchases that you get e-mail reminders about, so if you can’t remember the cost of a table or flight, it’s probably somewhere in your e-mail. I try to fill mine out as I buy flights and order prints, but sometimes I’m digging up old e-mails after the con is over.
Some things worth considering that are not on this sheet: food costs, gas if you drive to cons, baggage fees, and shipping if you ship your supplies in advance. Please feel free to download and edit this sheet as you see fit for your own needs! I hope it helps. And let me know if you have any questions, I’m happy to answer them!
EDIT: HOLY SMOKES, lenalibrarian on Twitter took my convention spending tracker and made it 100x better!!
–> SMART CONVENTION SPENDING TRACKER <– (original link edited too!)
It now calculates your costs and total profits AUTOMATICALLY!! Which is super useful for someone who’s terrible with numbers like me. I just finished importing all my 2017 convention spending so far, and this smart sheet caught a few mistakes already. I’ll be using this sheet for years to come, thank you lenalibrarian!!