This CSV file is an excellent way to analyze your transactional data. You can download all data (or a custom selection of data) and open it in third-party software like Excel or Google Sheets. You can export transaction data for all transactions or transactions from a specific contact.
Exporting transaction details 💾
Log into your Givebutter dashboard and click on Transactions.
If you want to add Filters to the data, do so now.
Applying filters ➕
On your dashboard, head to your Transactions page, located in the left-hand sidebar.
At the top of the page, you will find pre-selected filters that you can use.
Click More filters to add additional filters (if you want to sort transactions by multiple criteria at once). You can add as many simultaneous filters as you like.
Need to mix "and" and "or" logic? You can add more filter groups and choose whether they're joined by "and" or "or." Click More filters, then select Filter group to start a new group.
Want to export transactions for a specific contact? You can do this directly from the contact's page. Click the three dots [...] in the upper right corner and select Export transactions.
Click the Export button and choose an option:
All Transactions (most common)
All Transactions with Item Breakdown (a breakdown of donations, items, tickets, and fees)
Choose whether you want to group your transactions by campaign. If you choose this option, separate CSV files will be generated for each campaign.
Choose which data columns you'd like to export:
All columns (default)
Custom (select the columns you'd like to export from the available options)
Click Export.
Navigate to your email, and in a few moments, you will receive a message from Givebutter saying that your export is ready to download. In the email, click the Download button (good for 72 hours) or copy and paste the provided link into your browser.
The CSV file (or a ZIP file for multiple files) will then download to your device. Check your Downloads folder to open it in a file reader like Excel, Numbers, or Google Sheets.
File formats and custom fields 📁
The structure of your exported document depends on the options you selected when exporting your file.
Ungrouped
Ungrouped
Custom fields are found at the end of the list of columns. If items are included, custom fields will follow after the item columns.
The custom fields for all campaigns will appear as columns, but only some of those may apply to any given transaction.
When a custom field is relevant to a transaction, it will either be empty (if the donor did not fill it out) or filled. When a custom field is not a member of a transaction's campaign, the cell will be represented with a dash (-).
In the image below, the blue cells highlight custom fields that apply to the corresponding record, while the red cells with dashes are not part of that campaign. (Highlighting is for demonstration purposes only.)
Grouped
Grouped
When you select the group by campaign option, you can expect a different layout for your document.
Each campaign group follows the same format: a row with the campaign's title, a row of headers, and the transactions belonging to that campaign (1 per row).
The headers row has custom fields at the end, similar to ungrouped exports. The difference is that only custom fields belonging to that campaign are in the header.
When item breakdowns are included, custom field columns are appended after them (same as ungrouped).
The image below shows the custom field column outlined in a blue box. You'll notice that a campaign with no custom fields has a blank column. The blue highlighted rows are the headers for each group. (Highlighting is for demonstration purposes only.)
Data included in this report 🤓
Expand an option below to view a full list of all the data columns included in a transaction export.
Full list of export data: All Transactions
Full list of export data: All Transactions
Campaign Title
Campaign Slug
Team – The team this transaction is credited to
Team Member – The team member this transaction is credited to
Reference Number – Transaction ID
First Name
Last Name
Email
Phone
Address Line 1
Address Line 2
City
State
Postal Code
Country
Company
Status Friendly – succeeded, authorized, canceled, failed
Offline – TRUE or FALSE (TRUE = offline transaction, such as cash, check, or in-kind)
Fund ID
Fund Code
Fund Name
Appeal ID
Appeal Name
Appeal Code
Dedication Type – In honor of, In memory of
Dedication Name – the name of the dedication honoree
Dedication Recipient Name
Dedication Recipient Email
Method – card, check, cash, Venmo, Paypal, digital wallet (Apple Pay, Google Pay)
Method Subtype
CC Last Four – credit card last four digits
CC Expiration Date – credit card expiration date
Discount Code
Amount – the amount the donor chose to donate
Fee – full transaction fee for donation
Fee Covered – fee amount that was covered by the donor (zero means they chose not to cover the fee)
Givebutter Fee Covered
Donated – amount donated after fees have been applied
Payout – final amount to be paid out for this transaction ($0 means offline donation)
Payout Ref – reference number of the payout this transaction was included in (blank for offline transactions and transactions that haven't been paid out yet)
Currency
Plan ID – recurring plan ID
Frequency
Plan Start Date (UTC) – start date of the recurring plan
Check Number
Check Deposited (UTC)
Dispute Status – won, open, lost, closed
Payment Captured (UTC) – date and time payment is captured in UTC (this will be blank for offline transactions since no processing takes place)
Refund Date (UTC)
Transaction Date (UTC) – date and time the transaction is submitted in UTC
Acknowledged
Hide Name – TRUE or FALSE (TRUE = donor requested their name stay hidden from public view)
Hide Amount – TRUE or FALSE (TRUE = donor requested their donation amount stay hidden from public view)
Public Name – the name the supporter entered to show on the supporter feed
Public Message – the message the supporter entered to show on the supporter feed
Donor's Local Timezone – timezone of the specific transaction
Payment Captured (Donor's Local Timezone) – date and time the transaction is submitted in the donor's local timezone
UTM Source
UTM Medium
UTM Campaign
UTM Term
UTM Content
Referrer – referrer URL
Widget Id
Match information (if applicable)
Match Name
Match Amount
External Label
Transaction External ID
Contact ID
Contact External ID
Contact details (from the contact's profile)
Contact First Name
Contact Last Name
Contact Preferred First Name
Contact Type
Contact Company Name
Contact Email
Contact Phone
Contact Address Line 1
Contact Address Line 2
Contact City
Contact State
Contact Postal Code
Contact Country
Household ID
Household Name
Soft Credits
Total Soft Credits
Internal Note
Custom Fields - This is a varying number of columns, dependent on the custom fields you've created for the included campaigns
Full list of export data: All Transactions with Item Breakdown
Full list of export data: All Transactions with Item Breakdown
Campaign Title
Campaign Slug
Team – The team this transaction is credited to
Team Member – The team member this transaction is credited to
Reference Number – Transaction ID
First Name
Last Name
Email
Phone
Address Line 1
Address Line 2
City
State
Postal Code
Country
Company
Status Friendly – succeeded, authorized, canceled, failed
Offline – TRUE or FALSE (TRUE = offline transaction, such as cash, check, or in-kind)
Fund ID
Fund Code
Fund Name
Appeal ID
Appeal Name
Appeal Code
Dedication Type – In honor of, In memory of
Dedication Name – the name of the dedication honoree
Dedication Recipient Name
Dedication Recipient Email
Method – card, check, cash, Venmo, Paypal, digital wallet (Apple Pay, Google Pay)
Method Subtype
CC Last Four – credit card last four digits
CC Expiration Date – credit card expiration date
Discount Code
Amount – the amount the donor chose to donate
Fee – full transaction fee for donation
Fee Covered – fee amount that was covered by the donor (zero means they chose not to cover the fee)
Givebutter Fee Covered
Donated – amount donated after fees have been applied
Payout – final amount to be paid out for this transaction ($0 means offline donation)
Payout Ref – reference number of the payout this transaction was included in (blank for offline transactions and transactions that haven't been paid out yet)
Currency
Plan ID – recurring plan ID
Frequency
Plan Start Date (UTC) – start date of the recurring plan
Check Number
Check Deposited (UTC)
Dispute Status – won, open, lost, closed
Payment Captured (UTC) – date and time payment is captured in UTC (this will be blank for offline transactions since no processing takes place)
Refund Date (UTC)
Transaction Date (UTC) – date and time the transaction is submitted in UTC
Acknowledged
Hide Name – TRUE or FALSE (TRUE = donor requested their name stay hidden from public view)
Hide Amount – TRUE or FALSE (TRUE = donor requested their donation amount stay hidden from public view)
Public Name – the name the supporter entered to show on the supporter feed
Public Message – the message the supporter entered to show on the supporter feed
Donor's Local Timezone – timezone of the specific transaction
Payment Captured (Donor's Local Timezone) – date and time the transaction is submitted in the donor's local timezone
UTM Source
UTM Medium
UTM Campaign
UTM Term
UTM Content
Referrer – referrer URL
Widget Id
Match information (if applicable)
Match Name
Match Amount
External Label
Transaction External ID
Contact ID
Contact External ID
Contact details (from the contact's profile)
Contact First Name
Contact Last Name
Contact Preferred First Name
Contact Type
Contact Company Name
Contact Email
Contact Phone
Contact Address Line 1
Contact Address Line 2
Contact City
Contact State
Contact Postal Code
Contact Country
Household ID
Household Name
Soft Credits
Total Soft Credits
Internal Note
Item Subtype – Donation, Ticket, or Fee
Item ID
Item Description – Ticket Type, Processing Fee, or Donation to Campaign
Item Quantity
Item Price
Item Discount – if a promo code was used
Item Total – total after discount = Item Price - Item Discount
Item Fair Market Value
Custom Fields - This is a varying number of columns, dependent on the custom fields you've created for the included campaigns
Reconciling payouts 🧾
You can use the transaction export to reconcile your payouts with your bank deposits or accounting software. Every transaction that has been paid out includes a Payout Ref, which matches the reference number of its payout in your Payout History.
Export All Transactions with All columns, using a date range that starts a few days before your reporting period.
In your spreadsheet, sort or filter by the Payout Ref column, then add up the Payout column for each reference number to match each payout's total.
Funds become available for withdrawal on a 48–72 hour rolling basis, so a payout often includes transactions from a few days before it was created.
All dates in the export are in UTC, so transactions made late in the day in US time zones may show on the next calendar day.
Offline transactions and transactions that haven't been paid out yet won't have a Payout Ref.
Exporting transactions for a specific contact 👤
If you want to export transactions for just one specific contact, you can do so directly from their contact profile.
Click the three dots [...] in the upper right corner of the contact profile.
Click Export transactions.
Select the data you want to export from the dropdown menu. This list will include an option for All transactions, plus any year that a donation was made by this contact.
Click Export to confirm.
Navigate to your email, and in a few moments, you will receive a message from Givebutter saying that your export is ready to download. In the email, click the Download button or copy and paste the provided link into your browser.
Troubleshooting 🛠
If you're generating reports but aren't receiving our emails, please do the following troubleshooting steps before contacting us:
Ensure you've checked your email spam/junk box. Because these emails are sent from no-reply address, email providers may categorize them as junk mail.
Sometimes, these messages are filtered into folders previously set up in email accounts, or they're deleted automatically. Check any relevant folders.
Search your inbox for "[email protected]".
Check your email settings to be sure the address [email protected] is whitelisted, a firewall isn't blocking us, or there isn't some server issue.
If you've tried all of these options and you're still having trouble receiving export emails, please contact our team – we'd be happy to assist!