NOTE: Bonterra Payments only processes disbursements on business days, and the "cut-off" time for processing is at 7pm ET. In other words, any transactions processed on a day before 7pm ET should be disbursed to an account five business days later, and any transactions processed on a weekend or after 7pm will begin that disbursement "countdown" from the next business day.

In your Donor Management platform, you have the ability to easily generate filters and export out customizable reports on any transactions processed through Bonterra Payments. This helps your nonprofit better understand and track the disbursements you recieve through Bonterra Payments for those specific transactions.

To learn how to create and manage those reports, please follow the steps below.

First, from your Donor Management system, click on the "Giving" tab from the available options in the left-hand menu.

Once the "Giving" page has loaded, select the option to "Create a Filter."

For the first drop-down field on the filter, please select "Online Transaction" from the available options. Then, select the option for "is true" from the second drop-down field (it should be located next to that first set of drop-down options!).

Then, click the option to "Add a Condition," which can be found towards the bottom of the filter creation "box." You should see a new set of blank drop-down options appear below the ones you just selected.

For the first drop-down field on this second set of options, please select "Payment Gateway Processor". Then, select the option for "equals" from the second drop-down field, and select "Stripe" from the third drop-down field.

Bonterra Payments is powered by Stripe. To learn more, please see our related guide.

Your filter should look like this now:

This filter, when run, will now give you all of the transactions made via Bonterra Payments that have been processed across donations, events, and auctions for your organization.

We highly recommend saving this filter if your organization will frequently be reporting on this data, so you don't have to create the filter all over every time you need it! You can do so by clicking the option to "Save Filter" in the filter creation box.

If you want to report on a specific date range, you're going to need to add two more conditions to the filter you just created.

First, click the option to "Add a Condition". You'll want to click this twice, to add two new row of available drop-down options.

For the first drop-down field on this third set of options, please select "Donation Date".

Then, select the option for "greater than or equal to" from the second drop-down field. The third field should now allow you to select the first (or earliest) date within that date range.

For the first drop-down field on the final set of options, please select "Donation Date". (Yes, you're selecting it again!)

Then, select the option for "less than or equal to" from the second drop-down field. You can then select the last (or latest) date within that date range for the third field.

For example, if you wanted to report on all transactions from February 1st through February 5th, the two additional fields should look like this:

We also highly recommend saving this filter if your organization will frequently be reporting on this data. You can do so by clicking the option to "Save Filter" in the filter creation box.

Once you've created a filter with the transactions you'd like to report on, you'll want to click on the green "Search" button to run the filter. You should then see the results of this filter displayed on the page.

(Not seeing any results? Make sure you've followed the steps above to create the filter in the Giving tab - or check out our related article on filtering and reporting here.)

As a note, this list of totals does not include transaction fees. If you are trying to reconcile an amount transferred to your bank, you can include those fees in the following steps.

First, you'll want to select all of the records produced by that filter, by clicking on the small checkbox next to the word "Contact" (right above the first results).

Next, you'll want to select the option for "Bulk Actions", which can be found towards the top of the page. From the drop-down menu, please select the "Export" option.

At this point, a pop-up should appear on your screen - this pop-up allows you to select which specific fields you'd like included once you download your report.

You are welcome to include any fields you'd like, but in order to ensure that you are including all necessary fees, we strongly recommend including the "Total Amount Received" option.

We also recommend selecting the option to "Save these settings for future exports," which can be found at the bottom of that pop-up message. This will ensure that next time you pull a report, it will include that field and all related details.

We're in the home stretch! You'll now want to select "Export" from that pop-up message to begin generating that report.

You'll be brought to a page titled "Exports" while the report processes - you're welcome to refresh the page for updates if you'd like, or you can wait for an automated email that will let you know once the report is ready.

Once you've downloaded that report, it can be opened in any spreadsheet program, such as Excel. You can also adjust those filters you've created as needed, to further filter by date - or to determine exactly what's been included in a specific disbursement!

​
​