Applies to: GC Events with GC Auctions enabled
Roles: Events administrators
Location: Events > [Your event] > Custom Reports; Auction > Closeouts/Checkouts (Download Results); Reports > Deposit Reports
Outcome: You can pull auction and paddle raise results for reconciliation, stewardship, and your gift processing team.
Summary: After the event, use Custom Reports to build auction reports by item, bid, or bidder. You can also download a quick results file from Closeouts or Checkouts, and deposit reports include auction payments.
This article covers
- Auction reports in Custom Reports
- Choosing a report type
- FMV and gift fields
- Downloading results from the auction admin
- Auction deposit reports
Auction reports in Custom Reports
Auction data is available in Custom Reports, which works the same way as your other GC Events custom reports.
- Go to your event's Custom Reports and create a new report.
- Select Auction Report ("View auction data organized by item, bid, or bidder.").
- Choose a report type (see below).
- Choose the fields you want, then run or save the report.
Choosing a report type
| Report | One row per… | Great for |
|---|---|---|
| Item Report | Auction item, with its winning bid and donor | Reconciling what sold, for how much, and who donated each item |
| Bid Report | Bid placed, including every automatic (proxy) increment | Troubleshooting bid history and analyzing bidding activity |
| Bidder Report | Bidder, with their ticket spend, items won, and paddle raise pledge | Stewardship and understanding each guest's total event giving |
Helpful fields
- Item Report:
- Item details, starting bid, reserve, and fair market value
- Winning bidder and amount
- Invoice and payment status, and deposit information
- Donor and refund details
- Bid Report: bid amount, max amount, bid type, bid state, and time placed
- Bidder Report:
- Paddle number, contact information, and constituent ID
- Items won, and invoice and payment details
- Paddle raise designation and giving form
- Spend totals: Registration and Ticket Spend, Won Item Spend, Paddle Raise Spend, and Total Event Spend
FMV and gift fields
The Item Report includes Fair Market Value, FMV Portion, and Gift Portion, so your gift processing team can record the tax-deductible amount correctly. As with other GC Events reports, you can show FMV and gift on the same row or split them into separate rows. This option is only available for the Item Report.
[Screenshot: Sample Item Report with FMV and gift fields]
Download results from the auction admin
For a quick export, select Download Results in Closeouts or Checkouts after you've selected Confirm & Notify. The file has one row per winning item or pledge, with:
- The appeal and designation
- Winner contact information, paddle number, and constituent ID
- Winning amount, reserve, fair market value, and tax-deductible amount
- The item's donor
- Payment status and method
Auction deposit reports
Auction payments appear in your deposit reports. For deposits that include auction payments, look for the Event Auctions Deposit Report. You can view or download a breakdown that includes item FMV and gift totals, refunds, and designations.
Keywords: auction report, custom reports, item report, bid report, bidder report, FMV, fair market value, gift portion, tax-deductible, download results, deposit report, reconciliation
Comments
0 comments
Please sign in to leave a comment.