Account Summary Report

Account Summary Details

The Account Summary Details report is almost identical to the Invoice you receive from Blue Sombrero every week. The difference being that you can choose the date range for this report (two weeks is the maximum date range allowed). The report will give you the same details as the Invoice for the selected date range.

Steps to View/Export an Account Summary Report:

  1. Go to Reports >> then click on the Billing Reports tab.

    reports2.png
     
  2. Click on View next to the Account Summary Report. Select a Start Date and End Date (2 week maximum).

    Account_Summary_Report_1.png
     
  3. Click on View Report. See below for report summary explanations.
     
  4. Export the Account Summary Details by clicking on the Export Order Details button at the bottom of the page. Exporting the order details will show each order on a row. Every line item detail of that order will have its own column. 

    Account_Summary_Report_2.png
     
  5. Or export just the Account Summary at the top with the drop drop menu.

    Account_Summary_Report_3.png 

    Fee Summary:

    Total Credit Card Payments
    The sum of all Visa/MC and Amex credit card payments received in the given time frame.

    Visa/MC Processing Fees

    Processing fees charged by Blue Sombrero for all Visa and Mastercard Payments made in the current billing period. V/MC Rate can be viewed on Payment Configuration.

    Amex Processing Fees
    Processing fees charged by Blue Sombrero for all American Express Payments made in the current billing period. Amex Rate can be viewed on Payment Configuration.

    Total Processing Fees
    The sum of Visa/MC and Amex processing fees.

    Total Credit Card Refund
    The sum of all Visa/MC and Amex credit card refunds placed in the given time frame.

    Adjustment Amount
    Blue Sombrero may make adjustments to your invoice for fees or credits accumulated.

    Adjustment Memo
    Memo field explaining Blue Sombrero’s Adjustment Amount.

    Payment Summary:

    Total Visa/MC Transactions
    Total amount of Visa or Mastercard payments made in the current billing period. This will include payments made to New Orders AND payments made to orders placed in a previous billing period.

    Total Amex Transactions
    Total amount of American Express payments made in the current billing period. This will include payments made to New Orders AND payments made to orders placed in a previous billing period.

    Total Check Amt
    Total amount of check payments received in the current billing period. This will include payments made to New Orders AND payments made to orders placed in a previous billing period. It is important to note that Check Amt only includes check payments received by the Administrator and does NOT include “pending” check payments (occurs when a user chooses check as the method of payment).

    Total Payments
    The sum of all payments made: V/M + AM + Check Payments.

    Refund Summary:

    Total Visa/MC Refunds
    Total amount of Visa or Mastercard refunds made in the current billing period. This will include refunds made to New Orders AND refunds made to orders placed in a previous billing period.

    Total Amex Refunds
    Total amount of American Express refunds made in the current billing period. This will include refunds made to New Orders AND refunds made to orders placed in a previous billing period.

    Total Check Refunds
    Total amount of check refunds received in the current billing period. This will include refunds made to New Orders AND refunds made to orders placed in a previous billing period.

    Total Payments
    The sum of all refunds made: V/M + AM + Check refunds.

    Registration Summary:

    Total Registrations
    Total number of registrations that processed during the billing period.

    Order Summary:

    New Orders
    The sum of all orders placed during the billing period. You can use this to book your “sales” for the billing period.

    Canceled Regs from prev period (canceled or transfer)
    This is the sum of all orders placed in a previous billing period that were canceled during the current billing period. For example, if a $100 order was placed in Jan of 09 and canceled in the current billing period (May of 09), then there would be ($100) OR -$100 listed here. This is to account for the “loss” of revenue that occurred during the current billing period.

    Another example would be the case of a Transfer whereby the original order would be Canceled and a New Order would be placed in the current period. For example, a Player registered in Jan of 09 to Fall 2009 Soccer, U10 Boys for $100 is transferred in the current billing period (May of 09) to Fall 2009 Soccer, U12 Boys for $150. The result would be a ($100) or 0$100 listed in Canceled Regs from prev period (canceled or transfer) AND $150 listed in the New Orders.

    Total Adjusted Order Amt
    This is the sum of the New Orders and the Canceled Regs from prev period (canceled or transfer).

Have more questions? Submit a request

0 Comments

Article is closed for comments.