Payments Reporter Column Descriptions

The following columns are available on the Payments Reporter. These columns are available via the column selector and can be grouped, filtered, and saved as templates. 

TIP

You can sort the Payments Report by clicking a column heading. Each click changes the data in ascending or descending order. When grouping specific columns, be sure to also sort the column headings to ensure you are viewing the report results in an organized manner.

ColumnDescription
Payment DateThe date on which the payment was made.
Payer NameThe name of the person who made the payment.
RecipientThe person receiving items purchased in the School Store or the student who was registered for an activity.
If an item was purchased and paid through the Campus Mobile Payments app, the student's name appears IF the student number was entered at the time of the purchase.
DescriptionA description of the fee.
Payment Reference NumberThis number is automatically generated by the payments platform and is a unique identifier for a specific transaction.
The Payment Reference Number for transactions from the new payment platform begins with p1_txn. To exclude Vanco transactions and only see transactions from the new payment platform, use p1_txn in the Payment Reference Number column to filter your report's results.
Payment MethodIndicates what was used to make the payment; e.g., type of credit card or eCheck.  
Card Entry TypeShows whether a credit/debit card payment was typed in manually, swiped, or processed through the Campus Mobile Payments app using a chip insert or tap (EMV). If the payment method was not a credit or debit card, this column will appear blank.
Payment SourceIdentifies where the transaction occurred.
  • Portal
  • Parent Portal
  • Student Portal
  • Employee Self Service
  • Card Present Processing
  • Public Store
  • Recurring
  • Refund
  • Reversal
  • Failed Transaction
  • Campus Payments App
  • Activity Roster
  • Fees
  • Food Service
  • POS Terminal
Transaction StatusThe current state of the transaction. See the Transaction Status topic for more information.
  • Completed
  • Exception
  • Canceled
  • Pending
  • Returned
  • Return Void
  • Revoked
  • Resolved
Return DateAfter a refund is made, the details include this Return Date and the Offset Transaction Reference Number.
Settlement DateThe date on which the payment was processed.
Deposit DateThe date when payment platform deposits the money into the bank accounts.
Deposit Request DateThe date when Campus requested payments to be disbursed to the bank accounts.
Deposit Request ReferenceThe ID the payment platform sends to Campus when Campus requests a disbursement.
Fund IDThe unique identifier for the Fund Account. Fund ID is unique and the same Fund ID cannot be used at different schools.
Fund DescriptionA description of the Fund Account.
Bank AccountThe bank account associated with the Fund ID.
Deposit AmountThe specific amount of money that constitutes the deposit. 
Tip: Turn the Show Full Value toggle to ON to see the Deposit Amount go to 5 decimal places.
Screenshot of the toggle Show Full Value in the Payments Reporter tool. The toggle is set to ON.Screenshot showing the Deposit Amount set to five decimal places when the Show Full Value toggle is set to ON.