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 in PCR-360: Admin (orange) 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). The JV export is automatically transferred and processed into Banner overnight, as described /wiki/spaces/ICAT/pages/2205647320.
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)
Date = end of this month’s billing period
...
(just change on the first sheet)
Chartwells and CBRE get the special “single invoice format”: maintain their main tab normally, then copy only the latest invoice’s charges onto their second tab, which is the one that should be printed and sent.
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 Bill 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
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 →
...
Wait for Dan or Michele to confirm that the JV export was successfully processed.
If so, note that monthly billing is complete and resolve the Task. You’re done!
If they instead discover errors (invalid or expired index codes):
Find all charges billed against each failed index code.
Searching the report at Main > Services > View / Report > All Services will find all services that bill to that index, which in almost all cases will catch all recurring charges that bill to that index.
Who could help find the correct new index code – a PCR contact? a TC? the Reporter of the ticket that created the charge? Contact likely people and perhaps follow a chain of them until someone can tell you the best new index code to replace the expired one. Complete this with some urgency, since we need to get the Banner JV repaired and imported this calendar month.
Once you know the new index code:
Tell Michele the new index code (in email chain with her and Dan), so she can update the Banner JV
(For Adobe Sign charges only) create a subtask to update the Adobe Sign account with the new index code:
Set Support Team to “OIT ICAT Infrastructure and Cloud Applications”
In PCR-360, update every affected charge to use the new index code for future billing periods:
Directly modify the Expense GLA for each affected Service (referencing JSM issue in a Remark), verifying that they disappear from the All Services report above
Note that monthly billing is complete and resolve the Task. You’re done!
| Page Properties | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| |||||||||
|
...
|