Voucher Transaction Operational Report

Purpose

Enables institutions to view charges made to student voucher accounts and monitor bookstore spending associated with student vouchers. This dashboard provides users with two views: 

  • Voucher Payments by Transaction – Provides a detailed, line-item view of all transactions that meet the selected filter criteria.
  • Daily Transactions by Voucher – Displays a summarized version of all transactions that meet the selected filter criteria, grouped by voucher and aggregated by day.

Dashboard Notes

  • Scholarship payments are not included.
  • Pending and Cancelled Returns are not included.
  • The Voucher Balance is updated when the payment is fully processed, so the listed transactions may not be included in the balance total if they are still pending.

Definition of filters

Filter NameDescriptionUsage Notes
Transaction DateDate of the transactionDefaulted to “Last 7 Days”
Voucher CodeUnique identifier for the voucher supplied by the InstitutionUse to search for a specific voucher
Student IDUnique identifier for the student associated with the voucherUse to narrow results to a specific student by ID number
Student NameName of the student associated with the voucherUse to narrow results to a specific student by name
Term Name (Institution)Name of the term supplied by the Institution (Connect Catalog Name)Use to narrow results to a specific term

Definition of tiles

 Tile NameDescription
1Daily Transactions by VoucherProvides a summarized view of voucher transactions, aggregated by day
2Voucher Payments by TransactionProvides a detailed report of all orders and specific lines that the voucher was used to purchase materials.

Definition of fields

Field NameDescription
Transaction DateDate of the transaction
Voucher IDUnique identifier for the voucher in the VitalSource Voucher Tool
Voucher CodeUnique identifier for the voucher supplied by the Institution
Voucher Expiration DateDate the voucher funds will expire
Student IDUnique identifier for the student associated with the voucher
Student NameName of the student associated with the voucher
Order IDUnique identifier for the order processed by VitalSource
Line Item IDUnique identifier for the line item processed in the order by VitalSource
QuantityNumber of items purchased for the specific line item
Course CodeName of the course for purchased material 
Section IDName of the section for purchased material 
Purchased ItemUnique identifier for the purchased material

Transaction Amount

(Voucher Payments by Transaction only)

Amount paid for that line item

Daily Transaction Amount

(Daily Transactions by Voucher only)

Total transacted amount for that specific day
Voucher Balance

Current balance of the voucher (excluding any pending transactions)

🔵 In the Voucher Payments by Transaction view, if a student has more than one transaction you will see the Voucher Balance repeating the value for each line item.  For example:

Student Name | Transaction Amount | Voucher Balance

John Smith | $20.00 | $50.00
John Smith | $30.00 | $50.00

Term Name (Institution)Name of the term supplied by the Institution (Connect Catalog Name)
Term Name (Normalized)

Standardized term name, based on term start date:

  • Fall (Aug - December)
  • Winter/Spring (January - April)
  • Summer (May- July)
📄 Normalized term names bring parity to institutions, reseller partners, and content providers when conversing. The inclusion of this field is to help facilitate easier conversation and create a bridge between institutional catalog and schedule structure and reseller/content provider planning, preparations, and support.
Was this article helpful?