Weekly Bulletin No. 824
Tuesday11th August
- Year End - tasks to be completed this week
- Office Supplies
- University email accounts receiving high volumes of phishing/malware emails
- Spam Telecoms emails
- Quick Tip : Joining text in Excel
Year End
Year end tasks to be completed this week
Last date
|
Module
|
Task
|
Actioned
|
Wed 12 Aug
|
AR:
|
Last date for raising Internal Invoices and sending backing
|
|
Wed 12 Aug
|
FA
|
Deadline for Departments to provide Fixed Asset Register
|
|
Fri 14 Aug
|
PAY
|
Final UPS payroll posting
|
|
Mon 17 Aug
|
AR
|
Receipt any remaining BACS receipts and unclaimed PDQ income
|
|
Mon 17 Aug
|
AR
|
Raise, complete and dispatch all external AR invoices (NB AR closes 5pm)
|
|
Mon 17 Aug
|
AR
|
Last date for issuing invoices to University Group-defined organisations
|
|
Mon 17 Aug
|
AP
|
Process all 2019/20 Internal Trading AP invoices
|
|
Mon 17 Aug
|
AP
|
Process all staff and visitors’ expenses
|
|
Mon 17 Aug
|
AP
|
Resolved Internal Trading disputes notified to departments
|
N/A
|
Mon 17 Aug
|
AP
|
Process all remaining AP invoices (NB AP closes 5pm)
|
|
Mon 17 Aug
|
GL
|
July 2020 Chest Allocation (Fourth Posting)
|
N/A
|
Mon 17 Aug
|
GMS
|
Review and clear research grant funds check failures and exceptions
|
|
Mon 17 Aug
|
GMS
|
Correct research grant VAT errors
|
|
Mon 17 Aug
|
GMS
|
Clear suspense grants on Grants module
|
|
Mon 17 Aug
|
GMS
|
Post EC ‘PI Time’ journals on Grants module
|
|
Mon 17 Aug
|
GMS/GL
|
Process monthly Barclaycard expenses before AP closes, if using this option
|
|
For detailed guidance please refer to the Year End Instructions pages on the Finance Division website. The link to the Year end video presentation is also available on these pages, as well as the FAQs arising from the Q&A sessions.
Issued by Christine Rogerson - Finance Training
Office Supplies
It has recently been announced Spicer’s the office supplies wholesaler has gone into administration. We don’t purchase directly from Spicer’s but their administration will affect the 5 star brand of products as they will no longer be manufactured.
Alternative products to five star will be made available to purchase through marketplace. Anyone with outstanding orders for five star products will be contacted directly and offered replacements.
Issued by Anita Wilson - Category Manager
University email accounts receiving high volumes of phishing/malware emails
University email accounts are currently receiving a high number of convincing phishing emails that contain attached files – typically Word documents– or a link to a website prompting the viewer to download a file. If opened, these files cam lead to a malware infection.
Once it has infected a machine, this malware spreads by sending out fictitious replies to genuine emails it finds on that machine. Users need to be aware that if they receive an unexpected reply to an old email conversation from a colleague or friend containing a suspicious attachment or link, it may not be genuine.
Recommended advice for users
- Be wary of suspicious emails from external sources and even those that appear to come from a University colleague. Check the sender’s email address is correct (press ‘Reply’ and check in the ‘To’ field). UIS provides advice on how to spot phishing emails. If in doubt, delete the email and do not open attachments or download files from website links.
- Don’t run macros when opening a Word document sent to you as an email attachment or downloaded from a website. Malware requires macros to infect your computer.
- Please ensure that all anti-virus software is patched and up to date on all your machines. McAfee anti-virus software is available free of charge to all University staff and students, and you can use it on work and home computers.
- If you have downloaded and opened a file that you believe may have caused a malware infection, contact the UIS Service Desk ( www.uis.cam.ac.uk/self-service) for advice. If you require urgent advice you may call the service desk on 01223 332999.
Issued by Richard Kruller - UIS Customer Service Manager
Spam Telecoms emails
As an example of the above, the University has received a number of emails from Rosaline.santos@mobiletellecom.com.br advising urgent information and/or data is attached, or advising a customer statement can be downloaded. CSIRT confirm these are malicious and the link contained within downloads a word document which contains a ‘nasty payload’.
Anyone receiving such emails should delete them without opening.
Issued by Tony Fish - Senior Category Manager
Quick Tip : Joining text in Excel
Combining text from multiple cells can be useful for creating summary tables. In this video we look at ways we can join data into lists using Excel’s TEXTJOIN formula.
Click the link to watch a demo Excel – Joining text in Excel
Issued by Max Smith - Finance Training
Monthly Accounting Timetable
To view the status of the monthly process including the month end close dates please use the following link: Accounting Timetable
UFS Bulletin
- Click here for Bulletin archives
- If you would like to receive the bulletin email please send your details to this address