Monthly billing for JV and cash customers
On the 23rd 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
Add current bill charges (Main > Reporting > Bills/Calls > View Bill) for For each active cash customers 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 billing period, Due date = add 30 daysthis 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
Content: Attached is your PSU Telecom billing for your PSU OIT/Telecom billing for the month of XXXX. 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.
...