Reporting on Shelterpay transactions made with Stax

  • Updated

Once your team has enrolled in Stax, you'll be able to report on transactions with the following three accounting quick reports. Depending on your accounting requirements, you may find that one report in particular will work best for your needs.

  • Shelterpay Summary by Batch/Payout Date (includes both summary chart and detailed transaction/item reports)
  • General Summary by Transaction Date (includes both summary chart and detailed transaction/item reports)
  • Payout Reconciliation (includes both the summary chart and itemized report)

(Please note that the General Summary by Transaction Date Report contains all transactions for all payment methods, even those made through Stax that have not yet been batched. The other two reports are limited to only Shelterpay transactions that have been batched.)

 

To find these reports, just navigate to the Settings Wheel > Analysis & Reports > Quick Reports > Accounting tab:

mceclip1.png

 

These three accounting quick reports are available only to organizations that have enrolled with Stax, the payment processing platform that Shelterluv is partnering with to power Shelterpay. Take a look at this article for details on what you need in order to enroll with Stax. And please reach out to us at help@shelterluv.com for help with enrollment or to get started if you haven't yet!

 

Configuration Note:

In order to make the most out of the Shelterpay Summary by Batch/Payout Date and General Summary by Transaction Date reports, be sure to configure your Funds / GL Codes and Departments properly, assign all items, hold groups, Recurring Donations / Donation Boost Widget donations, and adoption groups to the appropriate values, and set coding for donations made through checkout as on or required (depending on preference). You'll also want to configure your Cash Drawers if preferred. Please refer to the help articles below for instructions and reach out to help@shelterluv.com for assistance if needed:

 

Overview 

Shelterpay Summary by Batch/Payout Date (includes both summary chart and detailed transaction/item reports)

This report allows you to see all Stax transactions by the batch/payout date. It will not include transactions made via other payment methods. Once you select your report date range and click "Run Report," you'll see a summary chart that includes totals for transactions by both Fund / GL Code and Department. There will be a row for each combination of Fund / GL Code and Department codes. 

You can then filter your results by Cash Drawer and Payment Method (since this report will only include Stax transactions, it is not necessary for you to use the Payment Method filter). And if preferred, you can toggle on/off the additional columns that split the Payment Methods and Charges/Refunds separately. 

At the bottom of the report you'll see a separate set of automatically calculated totals that combines all transactions in the report results by Charges, Refunds/Voids, Total Gross, Total Fees, and Total Net.

 

mceclip2.png

 

You can run the Transaction Detail Report and Item Detail Report to see the individual transaction and line item information that makes up the summary chart.

Note: The screenshots for these reports do not include all of the available columns in the report. Please refer to the attached Excel reports if you'd like to review a sample of the entire report.

 

The Transaction Detail Report will show one row for every transaction that makes up the summary chart. The same filters applied to the the summary chart it was run from will apply here.

mceclip4.png

 

The Item Detail Report will show one row for every line item on all transactions that make up the summary chart. The same filters applied to the the summary chart it was run from will apply here.

mceclip5.png

 

General Summary by Transaction Date (includes both summary chart and detailed transaction/item reports)

This report will be very similar to the Shelterpay Summary by Batch/Payout Date above, except that this report allows you to see all transactions by the transaction date so it will include transactions for all payment methods. Once you select your report date range and click "Run Report," you'll see a summary chart that includes totals for transactions by both Fund / GL Code and Department. There will be a row for each combination of Fund / GL Code and Department codes. 

You can then filter your results by Cash Drawer and Payment Method. And if preferred, you can toggle on/off the additional columns that split the Payment Methods and Charges/Refunds separately. 

At the bottom of the report you'll see a separate set of automatically calculated totals that combines all transactions in the report results by Charges, Refunds/Voids, Total Gross, Total Fees, and Total Net.

Note: Fees calculated in this report will only include fees for transactions that have been batched (i.e. paid out to your bank account). It will not include fees for transactions that haven't been paid out yet, which occurs within two business days after the transactions have settled.

 

mceclip0.png

 

You can run the Transaction Detail Report and Item Detail Report to see the individual transaction and line item information that makes up the summary chart.

Note: The screenshots for these reports do not include all of the available columns in the report. Please refer to the attached Excel reports if you'd like to review a sample of the entire report.

 

The Transaction Detail Report will show one row for every transaction that makes up the summary chart. The same filters applied to the the summary chart it was run from will apply here.

mceclip2.png

 

The Item Detail Report will show one row for every line item on all transactions that make up the summary chart. The same filters applied to the the summary chart it was run from will apply here.

mceclip3.png

 

Payout Reconciliation (includes both the summary chart and itemized report)

This report will summarize the payouts from Stax by batch/payout date. (It simulates the Stripe Payout Reconciliation report that you may be used to seeing in your Stripe account.)

You'll see totals for Count, Gross Amount, Fees, and Net in separate rows by Charges, Refunds, and the Total Paid Out.

 

mceclip0.png

You can run the Itemized Report to see the individual transaction information that makes up the the  summary chart.

You'll have the option to customize the columns within this report. Or you can run it with the same columns you selected the last time you ran the report using the "Previous Download" option.

 

mceclip3.png

 

mceclip1.png

 

Important Batch and Refund Information

In the Transaction and Item Detail Reports run from the General Summary by Transaction Date Report, the columns for Payout Batch ID, Payout Batch Date, CC Processing Fee, and Net may say "Pending." This is because this report contains all transactions, including those that have not yet been paid out to your bank account (i.e. "batched") by Stax. Once a transaction has been paid out, these values will be available in the reports.

mceclip0.png

mceclip2.png

A partial refund (or refund of only some of the items on a transaction and not all items on a transaction) will only be available to use after 11pm ET the same day that the original transaction was processed. You can still void or fully refund the entire transaction at any point after the original transaction was processed. Take a look at this article here for more information about Partial Refunds with Stax.

If you refund a transaction before 11pm ET on the same day that the original transaction was processed, there will be no Credit Card Processing Fee. In reporting, a new row will be created to represent the Refund transaction and both rows will show a dash for the Payout Batch ID, Payout Batch Date, CC Processing Fee, and Net columns.

 

Additional Notes

  • There will be a Print and Excel button at the top of each of your reports. We recommend exporting this data to excel and uploading it directly into your accounting software if needed. 
  • You can also reference the attached excel reports which correspond to each of the new reports below.