Simple Ledger for Trade Shows/Conventions

I used to be notoriously bad at keeping track of my sales/expenses at comics conventions. In the past, it's been clumsy lists or even just hatch marks on paper. During a slow day at a recent Portland show, I decided to put my iPhone and Google Drive to use. I'm not a speadsheet expert, but I mangled together something that I think works a lot better than hash marks on a post-it.

Using multiple tabs inside a Google Sheet, I can keep running tallies on my expenses and my sales. The first tab, labelled "Report" keeps track of the totals of the other two, automatically subtracting "Expenses" from "Sales". If all goes well, the "Profit" cell amount is a positive number.

One of the advantages of working in Google Drive is that I can immediately open the file in my desktop's browser and see the data. Even though it is really handy to input data on my phone, it's a bit easier to edit formulas and format the spreadsheet on a computer with a keyboard.

I'm sure that this could be improved with tabs for Mailing List registrants, tax calculations, mail-orders, etc. If you'd like to take a stab at modifying my template, here's a link to my Convention Ledger Google Sheet. Here's a link to an XLS version of the sheet.

Northwest Appearances, Feb 22 - Mar 3

Cosplayers at Emerald City Comic Con

Later this month, I'll be appearing at Wizard World Portland Comic Con Look for me at table #2524 if you are planning to attend. I'll have lots of new prints, sketches, and secret goodies. The very next weekend, the Northwest tour continues with Emerald City Comic Con. I'll be tabling near Juscope and Real Gone Girl Studios. I hope to see some of you there.

Wizard World Portland Comic Con
Oregon Convention Center
Portland, OR
Fri Feb 22, 3pm - 8pm
Sat Feb 23, 10am - 7pm
Sun Feb 24, 10am - 5pm

Emerald City Comic Con
Washington State Convention Center
Seattle, WA
Fri Mar 1, 2pm - 8pm
Sat Mar 2, 10am - 7pm
Sun Mar 3,10am - 5pm

"BBWW", 12x18" Print

"BBWW", 12x18" Print

 

Even if you can't make it to the show, many of my prints are available online for puchase including "BBWW", featuring everyone's favorite Amazon. This print is ready to pop into any store-bought 11x14" frame and shipped signed & rolled in a tube. "BBWW" is $25 with $5 shipping (US domestic. Int'l shipping is $10).

"BBWW" 12x18" Archival Print $25

If you plan on being in the Portland/Seattle area on either of those weekends, please come to the shows! Pacific-Northwesterners know how to party. Put some spandex on under that flanel! Let's do this!