In this article, we will guide you on how to download your All Transactions Export which includes all the necessary information for your transactions.
The All Transactions Export offers a comprehensive overview of all the data you need in a single place, making it simple to access the necessary information. This report is also valuable for decision-making and developing strategies to engage with existing or new donors, or analyze the amounts raised for each fundraising driver.
It includes:
- Online transactions: checkouts made using Stripe or BBMS, and free checkouts
- Offline transactions: checkouts that were marked as paid via an offline method (cash, cheque, offline credit card, other).
Please Note:
- Pledges that have not yet been processed (online or offline) do not appear in the Sales Breakdown, Checkout Overview, or Summary sheets. They only appear in the Pledges sheet.
- Pre-Seeded Donations do not appear anywhere in the All Transactions Export.
Additional Reports:
If you need an exclusive report for your raffle only click this link.
If you need an exclusive report for your auction only click this link.
For reference, here's a link to a sample All Transactions Export you can view before exporting.
All Transactions Export Sheets
You can find the following sheets in the All Transactions Export:
- Sales Breakdown Sheet: This shows everything that was purchased on a separate line, with a breakdown of who purchased and the corresponding fees.
- Summary Sheet: This is an aggregate summary of your fundraiser data.
- Checkout Overview Sheet: This shows every checkout on a separate line. Use this sheet to see all checkouts that have been made on your fundraiser.
- Event Ticket Sheet (if applicable): This shows every event ticket that was purchased, who it was purchased by, and who it's assigned to.
- Refunded Attendees (if applicable): This shows any attendees that have been refunded, and thus deleted from Trellis.
- Attendees (if applicable): This shows all valid attendees for your event.
- Donation Sheet (if applicable): This shows all donations that have been made for your event, such as donation options and custom donations.
- Auction Sheet (if applicable): This shows all auction items that have been purchased.
- Item Sheet (if applicable): This shows all items that have been purchased
- Raffle Sheet (if applicable): This shows all ERS raffle tickets that have been purchased on your fundraiser. (Canada Only)
- Pledges Sheet (if applicable): This shows all pledges that have been made on your fundraiser, both paid and unpaid.
Extracting the Checkout Report
1. From your Dashboard, click Results
2. Under Results, select All Transactions
3. At the upper right area, select your fundraiser from the dropdown
4. Click Export beside the dropdown
5. You may select the date range, export format, and export options, then click Confirm.Pro Tips:
- You can find the same export by going to Dashboard > Results > Exports > Select Fundraiser > All Checkouts > Export
- If the file does not download to your computer you may need to allow pop-ups in this browser.
- The Excel (.xlsx) format is recommended, and provides you with a single file and different sheets inside. The Comma Separated Values (.csv) will have separate files for each sheet.
Did this answer your question? If not, please reach out to the Trellis Support team via the blue chat icon or email support@trellis.org.