4 minute read
Financial facts
Reviewing the numbers
Financial facts
Workday finance has significantly enhanced Brock’s ability to understand and report on the financial transactions of the University. The following Workday facts only scratch the surface of the information available to users of the University’s financial information.
Tracking transactions and processes
Figure 35: Supplier invoice lifecycle (2021-22) The average time for an expense report to be fully approved from the day it is submitted is:
11 DAYS
2018-19 13 DAYS
2019-20
May June July Aug. Sept. Oct. Nov. Dec. Jan. Feb. March April 1,083 1,290 1,239 1,351 1,661 1,526 1,789 1,456 1,350 1,218 1,650 1,323 2 2 3 4 3 5 6 3 5 3 3 2 19 17 13 10 9 8 9 10 6 9 6 4
Monthly supplier invoices* Average approval time (days) Average payment time-cheques only (days)
*Excludes supplier invoices batch input by Finance.
6 DAYS
2020-21
7 DAYS
2021-22
(including weekend days).
1,762 81 1,083 603 142 1,083 91 1,290 687 705
886 74 1,239 776 71 852 86 1,351 705 85 1,410 89 1,661 854 209 1,240 56 1,526 1,024 140 1,021 191 1,789 1,180 188 955 117 1,456 1,017 531 1,521 119 1,350 1,090 356 976 106 1,218 1,042 538 1,969 123 1,650 1,613 179 1,316 129 1,323 2,492 746
Figure 36: Number of transactions processed in Workday in 2021-22 – by type
Total transactions processed: 50,162
May 2020 June 2020 July 2020 Aug. 2020 Sept. 2020 Oct. 2020 Nov. 2020 Dec. 2020 Jan. 2021 Feb. 2021 March 2021 April 2021
Manual journals, accruals, finance-adjusting journals and ad hoc bank transactions Customer invoices Supplier invoices Expense reports Ad hoc payments
Figure 37 2021-22 spending on external research grants by spending type ($000s) 2021-22 spending on external research grants by Unit (%)
External research grants
Total $12.9 million
0 2,000 4,000 6,000 8,000 10,000 12,000
Personnel costs* Scholarships, fellowships, bursaries and awards Equipment purchases and repairs and maintenance Travel costs and conference fees Materials and supplies Professional fees and contracted services Other
1
10 222
15 30
15 23
Faculty of Mathematics and Science Faculty of Social Sciences Research Services Faculty of Applied Health Sciences Scholarships, Bursaries and Student Awards Faculty of Humanities Goodman School of Business Leadership Faculty of Education
*External research grants spending includes the funding of Canada Research Chairs’ salaries recorded in operating.
Figure 38 2021-22 spending on expense reports by type* (%) 2021-22 spending on expense reports by funding source* (%)
6
10 5 4 22
31
Total Spend $8,348,000
19 21
Equipment purchases and repairs and maintenance Materials and supplies Other Travel and conference fees Marketing and advertising Memberships, dues and subscriptions Hospitality Contracted services Professional development/training
12 9 3
18 58
Operating External research grants Start-up and professional reimbursement accounts Internally restricted operating, capital and research projects Course fees
Operating**
Student Specific – 34% Shared Services – 13% Ancillary – 13% Space – 11% Faculty of Mathematics and Science – 9% Academic Support – 9% Faculty of Social Sciences – 3% Faculty of Humanities – 3% Faculty of Education – 2% Goodman School of Business – 2% Faculty of Applied Health Sciences – 1%
*Spending includes departmental purchases made on department purchasing cards and excludes central finance purchasing cards. ** See Figure 53 for detail of what units are included in the groups.
The following are the average values of transactions for 2021-22: Expense reports – $684 Supplier invoices – $9,705 Ad hoc payments – $741
Total active purchasing cards as of April 30, 2022 was 987, with spending on purchasing cards totalling more than $17.1 MILLION in 2021-22.
Figure 39: 2021-22 Scholarships, Fellowships, Bursaries and Awards by funding source (%)
1
9 8 3
79
Operating External research grants Endowments Non-endowed trust accounts Internal research projects
Figure 40: 2021-22 Software purchases by supplier(1) (%)
19
38 Total Spend
$3,184,000
16
22 22 3 4 4 4 4
(1) Does not include departmental P-card spending. Workday Limited Softchoice LP Echo360, Inc. Association Of Registrars of the Universities and Colleges of Canada Compugen Kainos Worksmart Ltd. Cinema Stage Inc. Ontario Research and Innovation Optical Network (ORION) Blackstone Energy Services Inc. Explorance Qualtrics LLC Other
Supplier Purchase
City of St. Catharines Sun Life Assurance Company of Canada
Water and taxes Insurance Canadian Research Knowledge Network Library acquisitions Twin Eagle Resource Management Canada, LLC Natural gas Brock Plaza Corporation Residence lease payments Council of Ontario Universities Library acquisitions Horizon Electricity WCPT Lofts II Inc. Residence lease payments CURIE Insurance Garda Security FirstOntario Performing Arts Centre Facilities rental Enbridge Natural gas
Lifeworks (Canada) Ltd.
Ethical Associates Inc. Counselling and mental health programs Professional services
Glacier Communications Online marketing and advertising
Figure 42
Grimsby
West Lincoln
Niagara West Niagara Centre Niagara East St. Catharines
Lincoln St. Catharines Niagara-on -the-Lake
Pelham
Wainfleet Thorold
Welland Niagara Falls
Port Colborne Fort Erie
Total spending* to NIAGARA REGION
suppliers for 2021-22 was more than $33.9 million to 331 suppliers. The average spend per supplier was more than $102,500 to each supplier.
* Included in spending amount are payments to suppliers relating to funds collected by Brock University on the suppliers’ behalf.
Figure 43
TOP NIAGARA REGION SUPPLIERS BY SPEND AMOUNT:
• BUSU Inc. • Merit Contractors Niagara • City of St. Catharines • Rankin Construction Inc. • Horizon • Brock University Faculty Association • The Regional Municipality of Niagara • Enbridge • FirstOntario Performing Arts Centre • Niagara College
Total collaborative buying in 2021-22 was
OECM – Ontario Educational Cooperative Marketplace NPPC – Niagara Public Procurement Committee CAUBO – Canadian Association of University Business Officers MGS- Ontario Ministry of Government Services OUPMA – Ontario University Procurement Management Association CRC – Campus Retail Canada OCUL – Ontario Council of University Libraries CRKN – Canadian Research Knowledge Network
