Skip to main content
All CollectionsCRM / Donor ManagementTransactions
How to export / download transaction details
How to export / download transaction details

Export your transaction data with custom filters right from your dashboard into a neatly organized CSV.

Sunny avatar
Written by Sunny
Updated over 2 months ago

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 user.

Exporting transaction details πŸ’Ύ

Applying filters βž•

  • On your dashboard, head to your Transactions page, located in the left-hand sidebar.

  • At the top of the page, there will be pre-selected filters that you can use.

    filters
  • To add additional filters (if you want to sort transactions by multiple criteria at once), click More filters. You can add as many simultaneous filters as you like.

Want to export transactions for a specific contact? You can do this directly from the contact's page. Click the Actions menu 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.

  • Choose which data columns you'd like to export:

  • 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 or copy and paste the provided link into your browser.

You must be logged in to Givebutter to view/download your CSV. If you’re having trouble opening your link, double-check that you are logged in, as your email client may have redirected you to a different device/browser than the one you exported the CSV from.

The CSV file will then download to your device. Check your Downloads folder to open 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

Custom fields are found at the end of the list of columns unless items are included. In this case, item columns will follow after custom fields.

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

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, they are appended after the custom field columns (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

  • Campaign

  • Campaign Slug

  • Team – The team this transaction is credited to

  • Team member –  The team member this transaction is credited to

  • Reference # – Transaction ID

  • First Name

  • Last Name

  • Email

  • Phone

  • Address Line 1

  • Address Line 2

  • City

  • State

  • Zipcode

  • Country

  • Company

  • Status – succeeded, authorized, canceled, failed

  • Fund ID

  • Fund Code

  • Fund Name

  • 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

  • Credit card last four digits

  • 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)

  • Donated – amount donated after fees have been applied

  • Payout – final amount to be paid out for this transaction ($0 means offline donation)

  • Currency

  • Recurring Plan ID

  • Frequency

  • 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

  • Anonymous Hide Name – TRUE or FALSE (TRUE = donor requested their name stay hidden from public view)

  • Anonymous 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 local timezone – timezone of the specific transaction

  • Captured at (donor's local timezone)

  • UTM Source

  • UTM Medium

  • UTM Campaign

  • UTM Term

  • UTM Content

  • Referer URL

  • Widget ID

  • Match information (if applicable)

    • Match name

    • Match amount

  • External label

  • External ID

  • Internal notes

  • Household ID

  • Household name

  • 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

  • Campaign

  • Campaign Slug

  • Team

  • Team member

  • Reference # – Transaction ID

  • First Name

  • Last Name

  • Email

  • Phone

  • Address Line 1

  • Address Line 2

  • City

  • State

  • Zipcode

  • Country

  • Company

  • Status – succeeded, authorized, cancelled, failed

  • Fund ID

  • Fund Code

  • Fund Name

  • Dedication Type – In honor of, In memory of

  • Dedication Name

  • Dedication Recipient Name

  • Dedication Recipient Email

  • Method – card, check, cash, Venmo, Paypal, digital wallet (Apple Pay, Google Pay)

  • Method subtype

  • Credit card last four digits

  • Credit card expiration date

  • Discount Code

  • Amount – 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)

  • Donated – amount donated after all fees have been applied

  • Payout – final amount to be paid out for this transaction ($0 means offline donation)

  • Currency

  • Recurring Plan ID

  • Frequency

  • 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

  • Anonymous Hide Name – TRUE or FALSE (TRUE = donor requested their name stay hidden from public view)

  • Anonymous 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 Local Timezone – timezone of the specific transaction

  • Captured at – date and time the transaction is submitted in the donor's local timezone

  • UTM Source

  • UTM Medium

  • UTM Campaign

  • UTM Term

  • UTM Content

  • Referer URL

  • Widget ID

  • Match information (if applicable)

    • Match name

    • Match amount

  • External label

  • External ID

  • Household ID

  • Household name

  • Subtype – Donation, Ticket, or Fee

  • Description – Ticket Type, Processing Fee, or Donation to Campaign

  • Quantity

  • Price

  • Discount – if promo code was used

  • Total – total after discount = Price - Discount

  • Custom Fields - This is a varying number of columns dependent on the custom fields you've created for the included campaigns

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 Actions menu in the upper right corner of the contact profile.

  • Click Export transactions.

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.

export options
  • 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!


Related content πŸ“š

Did this answer your question?