Sample Payment Reports
Analyzing payment reports for various races, including detailed transaction data and summaries. The 'Partner Level Detail' tab provides insights into transaction IDs, payment amounts, and associated fees, while the 'All Payments' tab aggregates total race profits and refunds. Key metrics such as race fees, donations, and adjustments are clearly outlined, allowing for comprehensive financial tracking. This resource is valuable for partners managing race payments and reconciling financial records.
Content article
The Sample Payment Reports cover various payment transactions related to race events, detailing over 300 individual entries across multiple tabs.
Partner Level: Race Payments outlines that the Race Payment tab provides a comprehensive view of payments associated with different races, tied to partner accounts, regardless of the payment or bank accounts used. Users can export the report in its entirety or filter it by specific date ranges. Notably, clicking on the Payment ID link allows users to access detailed transaction information related to each race payment, while the Funds transfer link under the "Invoice No." column offers an alternative breakdown of payments.
Report Downloads includes several downloadable reports. The Partner Level: Detailed Payment Report allows users to download transaction details for all races, including specifics such as transaction numbers, registration IDs, participant names, charity names, processing fees, discounts, coupon codes, and the total amount. The Race Level: Summary Payment Report provides a summary of all payments for the current year's race, detailing amounts, registration numbers, race fees, add-ons, and refunds, with additional tabs for each specific payment automatically populated upon download. The Race Level: Detailed Payment Report is also available for payment reconciliation.
In the Partner Level Detail tab, transaction records begin with headers such as Transaction ID, Date, Credit Card Transaction ID, Client, Payer/Description, Event, and various fee categories. For instance, on July 6, 2018, Transaction #XXXX2510 recorded a race fee of $29.99 with a processing fee of $6.99 for one registration. Another entry, Transaction #XXXX2516, shows a race fee of $49.99 with a processing fee of $9.61. Refunds are also documented, such as Refund #XXX282, which indicates a refund for a race name with no associated fees.
The All Payments tab provides a summary of payments made, including Payment V1037233 on July 10, 2018, totaling $10,229.21 for 290 registrations, with race fees amounting to $10,337.10. In contrast, Payment V1028994 on July 3, 2018, totaled $9,475.39 for 252 registrations, with race fees of $9,117.53. The report also includes totals for refunds, donations, and adjustments, with the overall total of payments reaching $44,990.10 across all entries.
Each payment has a dedicated tab, such as Payment V1037233, which details the payment date, amount, and breakdown of race payments by wave. Wave 1 accounted for 156 registrations totaling $4,678.44, while Wave 2 had 104 registrations for $4,158.96, and Wave 3 had 30 registrations totaling $1,499.70. The report also notes 140 registrations with add-ons amounting to $1,241.00 and 33 donations totaling $33.00.
In Payment V1028994, the payment date is July 3, 2018, with a total of $9,475.39. Wave 1 had 123 registrations at $3,598.80, Wave 2 had 87 registrations for $3,479.13, and Wave 3 had 42 registrations totaling $2,039.60. This payment also includes 89 registrations with add-ons worth $742.00 and 20 donations amounting to $20.00.
Payment V1019712 on June 26, 2018, shows a total of $9,213.29, with Wave 1 having 96 registrations for $2,819.06, Wave 2 with 106 registrations totaling $4,238.94, and Wave 3 with 35 registrations for $1,719.66. This payment also includes 90 registrations with add-ons amounting to $913.00 and 37 donations totaling $37.00.
Continuing with Payment V1010499, dated June 19, 2018, the total is $7,592.06, with Wave 1 accounting for 119 registrations at $3,538.82, Wave 2 for 74 registrations totaling $2,899.28, and Wave 3 for 21 registrations at $1,049.79. This payment also includes 72 registrations with add-ons worth $663.00 and 20 donations totaling $20.00.
Lastly, Payment V1002537, dated June 12, 2018, totals $8,480.15, with Wave 1 having 124 registrations for $3,688.77, Wave 2 with 86 registrations totaling $3,439.14, and Wave 3 with 23 registrations at $1,149.77. This payment includes 119 registrations with add-ons worth $997.00, 20 donations totaling $20.00, and a refund of $61.35.
The Payment Details for V1037233 tab elaborates on event registrations, showing that Wave 1 had a race fee of $29.99 for 156 registrations, totaling $4,678.44. Wave 2 had a fee of $39.99 for 104 registrations, totaling $4,158.96, and Wave 3 had a fee of $49.99 for 30 registrations, totaling $1,499.70. The total race profit for this payment was $10,229.21, reflecting the comprehensive financial activity associated with the race events.