Consignment Tracker Spreadsheet | Google Sheets, Excel | Artist Sales Commission Template

Track every piece, across every gallery, shop, and booth -- and always know exactly what you're owed. This consignment inventory and sales tracker handles location tracking, commission splits, payment aging, and tax-time income in one beautiful spreadsheet. No $144/year software required.

WHO IT'S FOR

Built for artists, makers, and consignment sellers who are tired of:

- Losing track of which pieces are sitting in which gallery, shop, or booth
- Doing commission-split math by hand every time something sells (and getting it wrong)
- Galleries that pay late, pay short, or close owing you money -- with no record to prove it
- Paying $6-$12 a month for art software that does more than you need

Whether you consign paintings, prints, ceramics, jewelry, or vintage finds to one gallery or a dozen venues, this template replaces messy notebooks and scattered emails with one organized system.

WHAT'S INCLUDED

- Google Sheets template (make a copy, start using immediately)
- Excel (.xlsx) file for offline use
- PDF Quick-Start Guide with the Google Sheets copy link and setup steps
- Free updates for life

ALL 10 TABS

Start Here -- A quick guided setup so you're tracking in minutes

Dashboard -- Piece counts by location, amount owed by venue, overdue alerts, and year-to-date income at a glance

Venues -- A profile for each gallery, shop, booth, or boutique: commission rate, payment terms, contact, and status. Set the commission once and it flows everywhere

Inventory -- Every piece you make or own: title, medium, price, where it is now, and which venue holds it. Commission and your cut auto-fill from the venue

Sales -- Record a sale once; your cut, the venue's cut, and the payment-due date calculate automatically from that venue's split

Payments -- Log payments as they arrive; outstanding balances and 30/60/90 aging update on their own, with a side panel that surfaces every venue that still owes you

Consignment Report -- Pick a venue and print a signed delivery record -- your proof of what's consigned where if a gallery closes

Tax Summary -- Sales, commissions paid, and net income by venue, ready for your Schedule C

Expenses -- Business expenses across 13 categories with IRS Schedule C auto-mapping and a deductible flag

Settings -- Business info, default commission split, tax set-aside rate, and fully editable dropdown lists

KEY FEATURES

Automatic Commission Splits -- enter a sale price and the spreadsheet splits it into your cut and the venue's cut using that venue's rate (50/50, 60/40, 70/30 -- whatever you set)

Location Tracking -- know instantly whether each piece is in the studio, consigned, on display, sold, returned, or damaged, with counts by location on the Dashboard

Payment Aging -- outstanding balances bucket into Current / 30-59 / 60-89 / 90+ days so slow-paying venues can't slip through the cracks

Printable Consignment Report -- a signed, per-venue delivery record you can hand to a gallery -- documentation if a venue closes or loses your work

Stale-Inventory Alerts -- pieces sitting at a venue too long get flagged so you can rotate or pull them

Schedule C Tax Summary -- income by venue plus a net-income and tax-set-aside calculation for painless filing

HOW TO USE

1. Purchase and download instantly
2. Open in Google Sheets or Excel
3. On the Settings tab, enter your business name and default commission split
4. Add your venues, then log your pieces -- commissions auto-fill
5. Record sales and payments as they happen; the Dashboard updates itself

IMPORTANT -- DIGITAL DOWNLOAD

This is a DIGITAL DOWNLOAD -- no physical product will be shipped. You'll receive instant access to your files after purchase.

- Google Sheets: Open the included PDF, click the link, then go to File > Make a Copy
- Excel: Download the .xlsx file directly
- Works on Mac, PC, phones, and tablets

FAQ

Q: Do I need to be good with spreadsheets?
A: No. Everything is pre-built with formulas, dropdowns, and color-coding. Enter your data in the input cells -- the rest calculates automatically.

Q: Can I set a different commission rate per gallery?
A: Yes. Each venue has its own commission rate on the Venues tab, and every sale uses the right split automatically.

Q: I sell vintage and antiques, not art -- will this work?
A: Absolutely. Venue types, mediums, and categories are all editable, so it fits booths, antique malls, craft shows, and resale just as well.

Q: Will it work on my phone?
A: Yes -- Google Sheets and Excel both have mobile apps, so you can update from the gallery or booth.

Q: What if I need help?
A: Message us anytime -- we respond within 24 hours.

REPLACES $72-$144/YEAR SOFTWARE

Dedicated art inventory apps charge $6-$12 a month, forever. This spreadsheet covers inventory, commission splits, payment aging, consignment reports, and tax-time income for a one-time purchase of $16.99.

Add to cart and start tracking every piece with confidence.