Silent Auction Profit Toolkit: Run a Silent Auction Without Losing Money (Guide + Excel Profit Calculator)

Your silent auction can look like a success and still lose money.

A consigned trip sells right at its floor and the fees come out of your pocket. A wine basket you bought sells for less than you paid. A starting bid set at full value gets no bids at all. And nobody knows the real net until weeks after the event.

The Silent Auction Profit Toolkit fixes the math before the doors open.

It is a step-by-step guide plus an Excel calculator built for volunteer chairs and small-nonprofit staff who run a silent auction without a consultant.

What's inside

1. The guide (PDF, 19 pages): Run a Silent Auction Without Losing Money

• Where silent auctions quietly lose money
• A planning timeline from 12 weeks out to the thank-you notes
• Setting a goal and doing the math first
• Procurement: who to ask, how to ask, and how to track it
• Pricing rules for starting bids and increments, and the reasons behind them
• How to avoid money-losing consignment items
• Bundling items so people compete
• Display, bid sheets, closing, and checkout
• Donor thank-yous and receipts, including the IRS rules for items over $75 (IRS Publication 1771)
• Post-event analysis so next year is easier
• Printable templates: bid sheet, procurement request letter, two thank-you letters, volunteer checklist

2. The Silent Auction Profit Calculator (Excel workbook)

• Item Pricing: enter value and cost; get the starting bid, bid increment, Buy It Now price, break-even bid, expected net, and a status flag (OK, Thin Margin, High Risk, Loses Money) for up to 60 items
• Settings: change the starting bid percentage, increments, platform and card fees, and who pays the fees
• Event Budget and ROI: revenue, costs, net, ROI, and cost per dollar raised, budget versus actual
• Procurement Tracker: donor, contact, item, value, status, thank-you sent, receipt sent, and an automatic next step for up to 100 donors
• Bid Sheet Data: ready to mail merge into bid sheets, with pre-calculated bid lines
• Results Summary: one-page dashboard with a chart for your board or committee
• Labeled example data so you can see it working, then clear it and add your own

Who it's for

Small nonprofits, schools and PTAs, churches, rescues, clubs, and community groups running a silent auction with volunteers.

Who it's not for

Large galas with a professional auction firm already managing pricing and consignment.

Format: PDF guide and Excel .xlsx workbook. The workbook also opens in Google Sheets. Instant download.

This toolkit is for general education and is not tax, legal, or accounting advice.

Want the editable Word templates and the Animal Rescue Edition too? See the Complete Bundle.

About the Author

Rhonda Lamoureux has spent her career on the money side of doing good. As a business owner and nonprofit leader, she has worked in operations, fundraising, and executive leadership. She managed the finances of a $20 million membership organization, whose foundation ran its fundraising.

From that seat, she watched the foundation pour time and money into golf tournaments that lost money. Volunteers worked hard, the day looked like a success, and the numbers told a different story. That stuck with her. Every fundraiser runs on people's time and on a mission that needs every dollar to count.

Silent auctions can fall into the same trap. Rhonda created this toolkit to give event teams the financial lens she wished those tournaments had, so they can plan with confidence and see what actually comes back to the cause.

Today, Rhonda is a CEO. In her off hours she works as an executive and spiritual coach, helping leaders make clear, grounded decisions. She believes good stewardship is a form of service, and she wants every nonprofit that uses this toolkit to finish its event stronger than it started.