Updated Financial Reports

Financial SummaryWe have done a refresh of our Financial Summary page as well as a number of the reports and spreadsheets that you can download. The result is a simpler and more consistent way to see your financial information and drill down on items you care about.

The Financial Summary page at the right has a new layout. We default to this year’s race, but you can select other years in the drop down, or you can select “Advanced Search” at the top right to select specific dates.

Next,we have moved the Payments to the top. The View Payments report has been updated (we review that below).

We have also moved the buttons for Detailed Summary and Show Summary by Race Date to the right above the Transaction summary table.

Detailed Summary ButtonDetailed Summary
This will give you an overview of the Transactions included in the race date range contained in the summary table. It is a great way to get a quick summary, and we now have links for most of the items like Coupons or Registrations that take you to the separate reports for those things directly. Here is a screenshot of a sample race:

Detailed Summary

If you download the Excel, it looks like this:

Detailed Summary

The Financial Account Number column is something that you can set up in case your race enters the details into a financial accounting system like Quickbooks. Read more here.

The smaller table on the upper right shows the amount in “Escrow”. These are essentially transactions that have not yet cleared thru the credit card networks for customers using Braintree Marketplace for payments.

Total Transactions GraphTransaction Breakdown Graphs
We also include an easy link on the Financial Summary page under the Transaction breakdown summary table. It provides a view by year of transaction volume as well as a Participant Count by month graph as shown below:

Year over Year Transaction Graph

Participant Year over Year by Month

Payments Report
The Payments report contains several new drill down reports. Note that it will appear slightly differently depending on your payment system – Manual, Braintree Direct, and Vantiv PayFac. Some are able to show specific transaction date ranges, but Braintree is not able to provide us with that information for example:

Payment Report

The PaymentID on the left column will show the specific payment. Some payment accounts have multiple races, so clicking on that link will show this report in this case with 2 races with their names hidden (again slightly differently depending on your Payment Account Type):

Payment Overview

The second link on the right of the main Payment Report “Race Payment Summary” shows the details for a specific payment for a specific race:

Race Payment Details

The View Race Transactions produces a list of all of the transactions included in the report:

Transactions within a Payment

You can also see the detailed transaction account balance by downloading the CSV of the transactions:

Transaction Journal

In summary, the new Financial System work we have been doing over the past several months has resulted in us being able to track and report in a much cleaner fashion for our customers.

Author: RunSignUp

RunSignUp is the leading innovator of online tools for race registration, race day solutions, and running clubs. Services include RunSignUp for registration, RunSignUp Go for Race Day, RunSignUp RD Go for Timers, RunSignUp Clubs to enable membership management, and RaceJoy for mobile experiences. More than 10,000 race directors, timers, running club officers and running stores use these services today, including leading organizations like the Boilermaker Road Race, Crim Festival of Races, Pittsburgh Three Rivers Marathon, Inc., Fifth Third River Bank Run, Blacklight Run, Bubble Run, Night Nation, Mercedes Marathon, Kentucky Derby Festival, Leone Timing, KC Running Company, Compuscore Timing, Knoxville Track Club, Pikes Peak Road Runners, Gulf Coast Runners, Columbus Running Company, Playmakers Running Store and many more. In 2015, over 10,000 races used the system to register more than 2.7 million participants. In 2016 over 14,000 races will use the system to process over 4.3 million paid registrations. Services are free except for processing fees when conducting monetary transactions such as race registration or club membership renewal. RunSignUp is founded by runners for runners, using technical capabilities to bring the power of cloud computing to benefit the running community. For more information, visit www.RunSignUp.com.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s