Banner Report

The Banner Report feature allows administrators to generate a consolidated list of pending user payments intended to be processed through an external Banner ERP system. Its primary purpose is to export this batch payment data for institutional processing and simultaneously mark those associated items as paid within OPS-COM. This article is intended for OPS-COM administrators.

Setup and Configuration

There is no specialized system configuration required to access this report, provided your institution utilizes a Banner system for student or staff financials. Generating the Reportreport is a standard administrative function available to users with the appropriate financial reporting and payment management permissions enabled on their account profile.

Using this Feature

ToAdministrators begincan lookuse this tool to define the payment batch parameters, export the data for Banner, and mark the items as resolved in OPS-COM.

Generating and Exporting the Report

1. Hover over Payments and click Banner Report menu item under the Payments Menu.

   

2. The screen will refresh and display the Banner Report Search page.

   
   

   On this page you select:

   User Types: Select the User Typedemographic you wish to report andon payfrom for.the
   User Types drop-down menu.

3. Select the specific item you are processing (e.g., yearly permits) from the Choose Item Type:Type Selectdrop-down themenu.

   item
you
4. wish to pay for. In our example we are paying for yearly permits.
   Up To and Including: 

   Select the end date of the billing period youusing wishthe toUp payTo for.
   Bannerand Code:Including date picker.

5. Enter the appropriate payment or identifyingidentification code thatinto youthe wishBanner toCode apply to this record in Banner.field (Codee.g., 100)
   Detail.

   Code:

6. Enter the exact item representation code that representsinto the itemDetail youCode are paying for. In our case it will be a yearly permit for 2020.field (e.g., YP2020)
   Admin.

   Code:

7. Enter your adminspecific administrator ID numberinto the Admin Code field to track who is making this payment report.

   

8. ThereClick are two functions you can perform here. Mark as Paid orthe Export to Excel.

   Exportingbutton to Excel

   The export to Excel functionality allows the admin to exportdownload a spreadsheet of the selected names and payments that will be made.

   

   Here is a sample of an exported spreadsheet.payments. This reportfile can then be imported directly into Banner to facilitate payment through acentral Studentstudent or Staffstaff account.
   accounts.

Mark

Marking Items as Paid

ToOnce markthe thesereport reportedparameters itemsare paidset and you are ready to resolve the balances in OPSCOMOPS-COM:

Select

1. Click the Mark as Paid.Paid button to begin the internal payment process.

   

2. AClick the Confirm button on the popup window will appear for the admin to confirmfinalize the transaction.

Export ClickBefore Paying: Always Confirmclick the Export to continue.Excel button before clicking the Mark as Paid button. Once you mark the items as paid in OPS-COM, they are cleared from the pending queue. If you do not have the exported spreadsheet saved, you will not be able to process the actual transfer of funds within your Banner system.

Key Information Displayed and Status Indicators

• ATransaction confirmationCode Generation: Once the bulk payment is confirmed, a final screen will appeardisplay displayinga theunique transaction code for the payment.batch.

  

• IfPayment youStatus: searchedSearching thefor this specific transaction code youusing wouldthe seestandard thisOPS-COM return.payment Note:search Alltools threewill return a list of all items hereincluded in the report, verifying that they are now successfully marked as paid for,in the system.

---

Best Practices and Considerations

• Code Accuracy: Coordinate closely with your finance department to ensure the values you enter into the Banner Code and Detail Code fields perfectly match your external system's current formatting requirements. Incorrect codes will cause the Excel import to fail in Banner.

• Record Keeping: Keep a log of the generated OPS-COM transaction codes alongside your Banner import records to ensure easy auditing and cross-system reconciliation.