Report on Fees - Stripe

Scroll down for the Step-by-Step Guide on how to build a report for Stripe payment fees

KEY TERMS & TIPS:

How do I report on Stripe fees?
By creating the fees as Adjusters and then running a report on them via the Reporting page.
You can then download the report for external use and duplicate it for multiple events and performances.
For full instructions, see our Step-by-Step Guide below.

What are Adjusters?
The commissions or fees that can be set inside or outside of a face value price. 
Payment fees, e.g. fees taken by Stripe will be Inside Adjusters.
For more info, see here.

What info can I see in this report?
You can include as many Fields and Metrics as you like, including Adjuster name, type, rate, plus the gross and net figures for each fee.
You can also add event and date filters to only show the data for certain events and performances.
For full instructions, see our Step-by-Step Guide below.

Can I send this report out?
Yes, either by exporting it (in CSV or PDF) and sending directly or creating a Report Schedule.

How do I reconcile this with figures from Stripe?
By pulling a Stripe export and combining it with your Line-Up report. You can use the transaction reference number fields to match the numbers.
See step 10 in our Step-by-Step Guide below for more info.

STEP-BY-STEP GUIDE:

1. Create Adjusters:

a) Go to the Tools page, click Adjusters and then New Adjuster. See here for full instructions on creating Adjusters

b) Add an Inside Adjuster for the Stripe Fees. Add your Stripe fee %, this is normally 1.5% but may be different if you have an alternative Stripe fee plan.  Add it to your Website Channel.

NOTE - Adjusters can be used for per item or percentage based fees. Any fixed fees per transaction would need to be calculated manually

2. Add Adjuster to Price Tables:

a) Go to the Prices tab of your Event(s)

b) Go to your Price Table and duplicate as draft to make changes

c) Right-click on the Variant that you'd like to add Adjuster to and click Manage Adjusters

d) Select your Adjuster fee and click Add Selected Adjusters

e) Save and Publish Price Table. For more info about Price Tables, go here

3. Create a Custom Report:

a) Go to the Reporting page and select Reports 

b) Click New Custom Report

c) On the pop-up, choose Performances as the data source you'd like to run the report with

NOTE - this will run the report by Transaction Items, e.g. tickets, products, fees. Orders will run a report by Payment Items, e.g. payments made with card/voucher. For more info about this, go here

d) In the top-left box, enter the name of the report. NOTE - changes are not automatically saved on Reports. When leaving the page, make sure to click Save in the top-right to make sure any changes are not lost

4. Add Fields:

NOTE - to create a report, you need to add at least one Field and one Metric

a) Click Manage Fields

b) On the pop-up, click on the Fields you'd like to report on and click Done. It is here where you can select your Price Adjuster fields.

NOTE - if you would like to reconcile this report with a Stripe export, make sure to add the Transaction Reference Number field

5. Add Metrics:

a) Click Manage Metrics

b) On the pop-up, click on the Metrics you'd like to report on and click Done. It is here where you can add your Inside Fee metrics

NOTE - You can order your Fields and Metrics how you like by moving them up and down in the Selected section on the right of the pop-up. Those at the top of this list will be the furthest to the left of your column headers:

6. Add Filters (optional):

NOTE - if you'd like to run fee reports for specific events, it's best to add an Event Name filter. This will only show the fees for that event

a) Click Manage Filters:

b) On the pop-up, click Add Filter and select the Fields/Metrics you'd like to filter by. You may want to use Event Name and Adjuster Name filters to whittle down Stripe fees for particular events

NOTE - to remove any filters, click the bin icon to remove the specific field/metric and then the red circle icon to remove the filter completely

7. Group your data (optional) - choose the Performance Start Date options to group by if you want to only see fees for performances within a certain date range, e.g. Today, Tomorrow, Last 7 Days, Last month, etc or choose your own custom options

8. Reporting data for a specific Event? Amend Report title accordingly

9. Save and Export:

a) Click Save to save your changes. NOTE - changes are not automatically saved on Reports. When leaving the page, make sure to click Save in the top-right to make sure any changes are not lost

b) Want to duplicate this report for a separate event? Click Manage Filters

c) On the pop-up, remove the current event filter 

d) Select the new event from the dropdown that you'd like to see fees for

e) To save as a separate report, click Save As

f) On the pop-up, enter the name of the new report you'd like to create and click Submit

NOTE - These will then appear in your Reporting list as two separate reports

g) To download a copy of the report, click Export

h) On the pop-up, select either CSV or PDF and click Export

10. Want to reconcile with Stripe figures? Combine your Line-Up report with a Stripe Export:

a) On your Stripe account, run a CSV export of successful payments

b) On this export, select the All columns option and this will include a meta data field where we add the Line-Up transaction reference number

c) On a new spreadsheet, combine this export with your Line-Up report. Create 3 tabs on the spreadsheet:

• Line-Up report - copy and paste the data from a CSV of your Line-Up report on one tab
• Stripe export - copy and paste a Stripe export of completed transactions only (no failed payments) onto another tab
• Combined report - create a new tab, pulling data from the above tabs. Insert columns you'd like to see data for here, e.g. Event Name, Performance Start Date/Time, Customer Email, Sold Gross Value, Transaction Reference Number etc

NOTE - it's important to add in Transaction Reference Number here. This is the way you'll be able to match transactions from both reports. It's also worth moving the Transaction Reference (from the Line-Up report) and line-up-transaction (metadata from Stripe report) columns next to each other, so you can match transactions

d) To pull data onto this tab from the Line-Up report tab, use the formula:

• =VLOOKUP
• Followed by the column which contains the transaction metadata from Stripe, e.g. I2
• 'Line-Up report'!
• The column range in your Line-Up report tab that contains the data you want to bring over, e.g. $A: $J
• The number of the column from your Line-Up report that you want to pull over - this will change as you go along the columns in the Combined report so that it looks at the corresponding columns in the Line-Up report
• The number 0 - so that the transaction reference columns will match

Example formula:

=VLOOKUP(I2,'Line-Up report'!$A:$J,5,0)

This formula then looks at each column on your Line-Up report tab and if something matches the transaction metadata column, it will bring that across and that will create the rows for Combined Report tab

Video for formula:

NEXT STEP: Schedule a report to be sent out to recipients of your choice