Understanding your All Transactions Export

Before getting started, you'll need to export your report. See the How to Download the All Transactions Export article for instructions.

Understanding the Sheets in Your Report

Sales Breakdown Sheet

This sheet provides a line-by-line breakdown of every purchase within each checkout, including fees and refunds. Each checkout may have multiple rows.

Key columns to be aware of:

Checkout ID - Column A
Date & Time of Purchase - Column B
First and Last Name of Purchaser - Columns C & D
Purchase Type -Column E
Item Price - Column I
Total Fees - Column L
Refund Amount - Column N
Fee Paid by Donor - Column Q
Fee Paid by Org - Column R
Tax Receiptable Amount - Column S
Custom Field Responses - Last columns on tab

Summary Sheet

This sheet provides a high-level overview of your fundraiser's financial totals:

Gross Total
Fees Processed During Event — Total Stripe fees charged
Refunds
Trellis Raffle Fee — If you ran a raffle, this field will be pre-filled in your copy of the report
Net Funds Raised

Pro Tip: The flat transaction fee under checkout summary is separated because this is charged per transaction and not per item on your donor's cart. That means if a donor adds multiple items to their cart(event ticket, donation, and raffle tickets) they will only be charged with one flat fee($.30 cents~)

Checkout Overview Sheet

Unlike the Sales Breakdown Sheet, this sheet shows one row per checkout rather than one row per item. It is useful for issuing tax receipts outside of the platform and reviewing responses to any custom fields you added to your checkout.

Event Ticket Sheet

This sheet contains a list of all ticket holders.

Please Note: Some tickets may appear under the same name if the purchaser used their own information to fill out a guest's details.

Pro Tip: All custom fields you added to your event will appear as columns in this sheet.

Attendees Sheet

This sheet lists all attendees for your event.

Please Note: Duplicate names may appear if a purchaser used their own information to fill out a guest's details.

Donation Sheet

This sheet contains all donations and donor information, including corresponding tax receipt numbers and fees.

Auction Sheet

This sheet contains all paid auction items and donor information, including winning bid amounts and fees.

Item Sheet

This sheet contains all items purchased and purchaser information, including corresponding fees.

Pledges

This sheet contains all donations and item pledges, including if the pledge is paid, unpaid or deleted.

Raffle Sheet

This sheet contains all raffle tickets purchased and the corresponding purchaser information.

Next Step: Once you're familiar with the report, see How to Reconcile Your Payouts to match your deposits to your report.

Frequently Asked Questions

Why does my Sales Breakdown Sheet have multiple rows for the same checkout?

Each checkout is broken into individual line items, one per purchase, fee, or refund. This is by design so you can see exactly what was included in each transaction.

Where can I find responses to custom fields I added?

Custom field responses appear in the Sales Summary Sheet tab and Attendees tab.

Need Help?

If you have questions or need assistance, reach out to our Product Engagement Team via the blue chat icon or email support@trellis.org.