Monthly billing for JV and cash customers
On the 22nd of each month, Jira automation creates a Task for SMO →
Assign the Task to yourself and mark it In Progress.
Generate the month’s bill and Banner JV export: Admin tab > Billing > Bills > Generate Bill (uncheck Test bill, verify date range)
Wait a few minutes, reload list to see a Complete billing run, select it & Approve
Email Alex/Michele/Margaret Hernandez/Dan Weiss/Karen Erwin to inform them that OIT/Telecom billing has processed (to trigger them to look for errors)
Create and send statements to cash customers
For each active cash customer on the Cash customers Google sheet (those shown in Receivables tab = those before the STOP BOOKEND tab), add this month’s charges from the current bill (Main > Reporting > Bills/Calls > View Bill), hiding previous charges and payments when they’re paid
Date = end of this month’s billing period (just change on the first sheet)
Print each active customer tab as a PDF and save locally to your computer.
Email PDFs to GLA Primary contacts shown in https://docs.google.com/spreadsheets/d/19ekCxUVFmVKtCUqLM7sLxKjYcSCeG-VsafVrGJeSIVc/edit#gid=0
Subject: PSU OIT/Telecom Billing MONTH YEAR
Content: Attached is your PSU OIT/Telecom bill for MONTH. Please remit payment as soon as possible. If you have any questions, direct them to me at help-billing@pdx.edu.
Update latest billing column to show current month was billed
Copy all PDF statements to Cash customer bills folder
Note that monthly billing is complete and resolve the Task.
The JV export is automatically transferred and processed into Banner overnight, as described here. If there are errors in the Banner JV import (usually index code expirations) →
Dan or Michele notices
Michele researches and determines how to update or fix
Michele repairs the current Banner JV import
Michele emails SMO with corresponding index codes to change in PCR for future billing periods →
Make requested index code changes, creating a PCR work order for Telecom services (Owner Change > New Owner, referencing JSM issue in Description) or directly modifying Expense GLA for non-Telecom services (referencing JSM issue in a Remark)