Silent auction templates

Every auction committee builds the same five spreadsheets, badly, under time pressure, in the first week. Then somebody adds a column nobody understands, two people edit different copies, and by the week of the auction the tracker and reality have diverged.

The fields below are what those sheets actually need. Build them once at the start and they run the auction — and the item tracker becomes the most valuable thing you hand to next year's chair.

Part of our guide to running a silent auction.

The five documents

Two of these are only needed in some auctions. Bid sheets are redundant if all bidding happens on phones, and the volunteer sheet can be a shared note for a committee of three.

Donor solicitation tracker

This tracks asks, not items. Most committees skip it and track only what arrived, which loses the follow-up entirely — and follow-up is where most donations actually come from.

Fields:

• Business or individual name
• Contact person and role
• Email, phone, address
• Who on the committee owns this relationship
• Source — how you know them, or who suggested them
• Donated last year? What, and what it raised
• Date first asked, and how (in person, email, phone)
• Response — yes / no / not yet / no reply
• Follow-up date
• Notes — what they said, what they asked for, when to come back
• Recognition promised
• Thanked? Date
• Would donate again next year?

The last three fields are the ones that make this sheet worth keeping after the auction. A list of businesses who have already said yes in principle turns next year's procurement from cold outreach into confirmation. See asking local businesses.

Item tracker

The master record. Everything else references it, so build this one properly.

Fields:

• Item number — assigned on arrival, in category blocks with gaps, never reused
• Item title
• Full description, including all restrictions
• Category
• Donor name, and how it should appear in credit
• Date received
• Fair market value, and how you determined it
• Starting bid (roughly 40% of value)
• Bid increment (roughly 5% of value)
• Buy It Now price, if any
• Expiry / blackout dates / restrictions
• Shippable? Local only?
• Physical location — whose garage it is in
• Photographed? Uploaded?
• Bundled into which package, if any
• After the auction: number of bids, final price, bid-to-value ratio, winner, paid?, collected or shipped?

Those last fields are what make the sheet an asset rather than an administrative artefact. Item performance data tells next year's committee what to solicit and what to stop chasing. See reporting.

Volunteer assignments

Organize by function, not by name. Four functions need an owner even in a committee of three: item solicitation, auction setup and item entry, promotion, and checkout and distribution.

Fields:

• Function
• Owner
• Helpers
• Specific tasks under that function
• Deadline per task
• Status
• Event-day shift and time, if you are running an event
• Contact number for the day

The most useful column is owner, because it forces the question nobody asks until it is too late: who is doing shipping? Who is watching the zero-bid list? See committee roles.

Budget sheet

Two columns: planned and actual. The gap between them is the whole point.

Rows:

• Net revenue target
• Expected expenses
• Gross revenue required
• Combined item value needed (gross ÷ 0.65)
• Platform costs and add-ons
• Payment processing
• Venue, catering, decor, AV — if you are running an event
• Printing
• Purchased or consigned items
• Shipping
• Insurance and permits
• In-kind contributions, at value, on both sides
• Actual: gross raised, amount collected, total expenses, net

Gross raised and amount collected are different numbers and both belong on the sheet. See budgeting a silent auction.

Bid sheets

Only if some bidding happens on paper. Where guests bid by phone, display cards with QR codes replace these entirely — see scan-to-bid QR codes.

Each sheet needs: item number, title, description with restrictions, fair market value, starting bid, minimum increment, donor credit, pre-printed bid lines at fixed increments, and columns for name, contact and amount.

Pre-print the bid lines. Blank lines produce dollar raises, illegible handwriting and disputes. Print enough lines that a popular item does not run out of room. See silent auction bid sheets.

32auctions generates printable bid sheets and item display sheets with QR codes from your catalogue, which removes most of this work.

Rules that keep sheets usable

• One copy, shared, cloud-based. Emailed spreadsheets fork immediately and both versions become wrong.
• Editable from a phone. Half of this data is entered standing in a storeroom.
• One row per item, one row per donor. No merged cells, no notes in the margin.
• Dates as dates, money as money. Text columns break every sort you will want later.
• Never delete a row. Mark it withdrawn. Deleted rows break item numbering and lose history.
• One owner per sheet, with edit access for whoever needs it.

When a spreadsheet stops being enough

Spreadsheets are excellent for solicitation, planning and post-auction analysis. They are poor at running the auction itself, and the point at which that becomes painful is predictable:

• When you need to notify a bidder they have been outbid — the highest-value message in an auction, and impossible to send manually at any scale
• When bidding happens in two places at once and both need the current price
• When you need invoices for sixty winners the moment bidding closes
• When you want to know which items have no bids while there is still time to act
• When supporters who are not in the room want to participate

The practical division most committees settle on: spreadsheets for the tracking that happens before and after, the platform for the bidding, notifications, invoicing and reporting in between — then export the results back into the item tracker for the handover. See planning next year's auction.