Artist Alley Income & Expense Ledger – Bookkeeping, Mileage Log, Sales Tax Collected, Profit by Con (Google Sheets + Excel)
INSTANT DOWNLOAD: you get the download link right after checkout. Nothing is shipped.
Con receipts, online orders, commissions and print bills end up everywhere. Log each one in a single ledger with a category and event, record sales tax collected separately, and add your mileage. The Summary works out income, expenses and net by month, by category and by con, so year-end is a few minutes, not a weekend of digging.
AI disclosure: made by LB3 Trackers with AI assistance. AI tools helped write the code that builds the files, plus the layouts and wording; every file was checked before listing.
What's included:
- Ledger tab: date, income or expense, 16 categories (table fees, printing, packaging, display, hotel, meals, card fees, shipping and more), event/channel, amount, sales tax collected, payment method (1,000 rows)
- Mileage tab: trips by event with from/to, purpose, miles and an estimated amount at your own rate (300 rows)
- Events tab: your cons, markets and online shop (feeds the drop-downs)
- Summary + Dashboard: income, expenses, net and sales tax by month, totals by category, net and miles by event, best month and best con for the year you pick
Format: one .zip with a SAMPLE and a BLANK .xlsx (Excel 2019 or newer, or Google Sheets).
Spreadsheet files: one SAMPLE copy with made-up example data and one BLANK copy. Open the .xlsx in Excel, or upload it to Google Sheets (File > Import > Upload). Standard formulas only; no macros, add-ons or links to other files.
Pairs with our Artist Alley Inventory & Sales Tracker (per-con sales) and Convention Trip Budget & Break-Even Planner. A record-keeping tool, not tax advice; ask a tax professional about your situation.
Generic, original design: no show, character, studio or brand names, and no copyrighted art. Not affiliated with or endorsed by any company, event or service.
Free sample: Artist Alley Break-Even Quick Sheet (printable) (free on our Payhip shop).
You may also like:
- Artist Alley Inventory & Sales Tracker
- Convention Trip Budget & Break-Even Planner
- Artist Alley Pricing & Margin Calculator
Questions or a problem with a file? Message us through the store contact page. If a file doesn't work for you, we'll fix it or refund you.
License: personal use. Please don't resell, share or re-upload the files.