New Race Financial Reports

DollarWe have done a major overhaul on our Financial Reports. The Summary page now gives a quick overview with 3 tabs to drill down on:

  • Transactions – these are focused on the individual transactions that have been processed on behalf of your race.
  • Payments – These are a list of all the payments that have been made to your race with many drill down reports.
  • Payment Accounts – This is where you can get information about the account we make payment to. This is also helpful for organizations that have multiple races and allows you to see how a payment was broken between multiple races.

Financial Summary

The above screen shot shows a financial summary page for a race. In the middle, there is a button to view a Detailed Summary:

Detailed Summary

Clicking on the “Show Excel” button downloads this report:

Excel Financial Summary

If you click the Show Quantities button in the upper right corner it shows the quantities:

Detailed Financial Summary with Counts

Payments
The second major tab shows Payment Information. This will look slightly different depending on your Payment Account type and payment frequency. It shows a quick summary of how many payments for the selected period (defaults to current race period – typically this year’s race, but you can switch event dates at the top of the page). Below are a variety of ways to look at your payment information, as well as drill down on specific areas like donations:

Payments

The Summary Payment Report downloads an Excel spreadsheet that shows each payment in rows, and the various types of transactions that your race had as columns (there can be about 30 if you have a lot of options) like registrations, donations, store items, coupons, etc. To the right it shows the breakdown by event. Note the Tabs at the bottom of the spreadsheet that allow you to drill down on each payment:

Summary Payment Excel

We spent a LOT of time working on the Detailed Payment Report. It first asks you to select a specific payment and then shows you all of the details of that payment. It shows a unit price, quantity and total for each type of thing your race offers, as well as anything like refund account holdbacks that affect your individual payment:

Detailed Payment Excel 1

Detailed Payment Excel 2

The Individual Payment Summary can be used if you do not have Excel or want a quicker and higher level view of the payment:

Individual Payment Summary

Note the Overall version of this is useful for organizations with multiple races on the same payment account. For example:

Multi-Race Payment Summary

The Event Summary shows a similar version of the above two reports for the race by event (5K, 10K, etc.). The Race Date Summary shows multiple years on a single page in summary fashion.

Race Payments List shows a list of Payments with quick links by each payment to the various reports above:

Race Payments List

One of the links on the right – View Race Transactions – shows the transactions that make up that payment. This works best for races using Advanced Payment since we are able to specifically match a a transaction.

Transactions in a Payment

The second section of Payment Reports drill down into specific transaction types. These are fairly self-explanatory and cover:

  • Transactions
  • Registrations
  • Donations
  • Store Items (not Add-ons – those can be seen either int he Add-on report or the detailed reports shown in the first section)
  • Corporate Team Payments
  • Refunds
  • Holdbacks
  • Adjustments

The final tab is the Payment Account information.

Payment Account

If you have multiple races, this can be a useful tab to understand payments being made for multiple races, for example:

Payment Account

Thanks to all of the races who helped feed us requirements for these changes. We hope you find them useful (because we spent a lot of time on them)!

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.

One thought on “New Race Financial Reports”

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