Login to B2G: https://utsystemutexas.diversitycompliancegob2g.com/
- Click on the Reporting Tab (on the left side of the screen)
- Then click Full List
- Under Contracts, click TPASS HUB Report
- Enter start/end dates (09012018 - 08312019) - Department: select UT Austin (only) - click view report.
- Lookout for projects that are not suppose to be reported under UT Austin (Austin State Hospital, New Arena, Block 164, P3s)
Export the report into Excel or PDF (document will have to be edited for reporting purposes
- In excel, separate: 00720 00721 / 11 digit VID / Vendor Name / Obj Code / Dollar Amount / S (subcontracting) or N (non-treasury)
00720 - each line needs to be updated to 00721
11 digit VID - any vendor number with "No Vendor ID" needs to be replaced with 00000000000
Vendor Name -
Obj Code - 4 digits either 7256, 7341 or 7256, 7343
Dollar Amount -
S or N - S (subcontracting) or N (non-treasury)
Verify HUB and Non-HUB vendors
- Identify who is HUB and Non-HUB: https://mycpa.cpa.state.tx.us/tpasscmblsearch/
- Break out vendors based on object code (7256, 7341, 7343)
Then add all N expenditures for each object code, and add all S expenditures for each object code
Subtract N from S (do this for both object codes)
Take the sum (offset) and add it with all S Non-HUB
Add all HUB expenditures (both N and S) and divide it against the offset. - 7256 will be added to Professional Services on the Semi-Annual / Annual Report
- 7341 will be added to Building Construction on the Semi-Annual / Annual Report
- 7343 will be added to Building Construction on the Semi-Annual / Annual Report
...
- Make notation of every addition and deletion for reference.
- Save reports in UT Box under HUB Performance Report FY "
F Drive Key
...
400
...
A&E projects
...
HUB folder has HSPs
...
500
...
Construction projects
...
HUB folder has HSPs
...
...
2304 – AE invoices |
2305 – CMR invoices |
...
Check to ensure PAR submitted with invoice. Invoices are reportable (in B2G) when signed PAID by Andi Ault. Expectation is that B2G entries will match PAR of PAID invoices
PAR reporting is the responsibility of the prime. If prime has not input payments by deadline CPC HUB Associate should follow procedure below to input data
Per invoice, download PAR only from F Drive (file://flint/CPC/Austin)
Enter payments into B2G per PAR
Attach PAR document to each payment entered (this is for documentation)
CPC HUB Associate only enters HUB payments.
Double-check 2nd tier payments. If 2nd tier not recorded it is best practice to follow-up with HUB contact at prime firm (cc: CPC project manager, and exec at prime firm). If prime neglects to respond after 3 days send reminder email. If prime neglects to respond after 7 days contact 1st tier sub (cc: CPC project manager, HUB contract at prime firm, and exec at prime firm)