This report is very useful when working with Payment related information. Some useful ways to use this are:
Most of the other basic reports list one row in the report for each registrant, but this report lists one row for each 'transaction' that is done for each registrant. This is similar to what is shown on the 'Payment Summary' tab for a registrant. Examples of 'transactions' include the following:
Getting the data you want
The filters boxes at the top of each column in the report can be used to drill down into specific details you may be interested in.
NOTE: Remember that entering a 'to' date of June 1, 2015 will list transactions up to midnight on June 1, which is essentially the end of the day on May 31. Also keep in mind that the dates are referenced to Pacific Time.
After seeing the data you want, you can further sort or summarize it by downloading to csv or Excel.
When you download the report using csv or Excel format, the report provides a number of additional fields you may mind useful. The pdf download does not include these additional fields. Some of the additional columns are:
Warning regarding 'Form Pay Type'
Many people have asked for the 'Form Pay Type' to be included in reports, so we are now including it on this report. But it is important to remember that this field can be misleading if not understood.
'Form Pay Type' refers to the original payment type picked by the registrant when they first registered, and it may not match the method they paid with.
For example, the person might choose 'Pay by Cash' on the form, but then later called in on the phone and made a payment by credit card. In this case, the 'Form Pay Type' will still indicate 'Cash', but the 'Adjustment Type' column would indicate 'Receive Credit Card'.
Another example is that a person may owe $100, and decide to pay $50 by Cash, and the balance by Credit Card. In this case, the report would include separate rows for the $50 cash payment and $50 credit card payment, but the Form Pay Type would indicate 'Cash' for both entries.