Weekly Bulletin No. 850
Tuesday 16th February
- Update from the Director of Finance
- Financial Users Group (FUG) Wednesday 17th February
- Fraud
- Deposit Account – Interest Payment & Emailed Enforced Movement Letters
- Forthcoming course (via Teams)
- Quick Tip – Excel, using Sum function when data is hidden
- Monthly Accounting Timetable
Update from the Director of Finance
Financial Users Group (FUG) Wednesday 17th February
The next meeting will be held via TEAMS starting at 10am on Wednesday 17 February.
The agenda and link to the meeting are available from the Financial Users Group webpage, along with recordings and presentaions from previous meetings.
This is an open meeting where everone is welcome.
Issued by Lesley Dent - System Administrator
Fraud
All departments are reminded about the risk of fraud.
If you receive suspicious emails please follow the instructions below.
Report Suspect Emails |
To report a suspect email and don't require a response send the emails as an attachment to spam@uis.cam.ac.uk |
Clicked on link |
If you have clicked on or opened a link, send the suspect email as an attachment to servicedesk@uis.cam.ac.uk |
UIS have secuity advice on their web page along with courses on cyber security awareness available here
Issued by Lesley Dent - System Administrator
Deposit Account – Interest Payment & Emailed Enforced Movement Letters
Please note Deposit Account interest has been credited for January 2021 in CUFS
As part of monthly monitoring the Treasury & Investments team have carried out deposit movements to correct debit balances on Sources of Funds. Affected departments will receive documentation indicating which accounts have been adjusted.
Departments will now receive enforced movement letters via email. If these are being received by the incorrect contact or you have not received a notification you were expecting, please contact Treasury & Investments.
Please ensure deposit movements for February 2021 have been processed by the close of 4th March 2021, and that overdrawn accounts have had funds taken off deposit by this time to avoid delays in crediting February’s Interest.
Queries Any queries should be addressed to: Treasury & Investments, treasury@admin.cam.ac.uk, Ext 64216
Forthcoming course (via Teams)
Cognos Introduction, Tue 23 & Wed 24 Feb
This course is the basis for GL and Grants reporting and introduces the functionality of Cognos. It is a practical course, with tips and shortcuts being demonstrated. You will need to ensure you have Cognos access setup before the course. NB. The objective is to familiarise participants with using Cognos. Report outputs are explained in detail in the GL or Grants reporting courses.
How to Excel (1 & 2) for Finance Staff, Tue 2 and Wed 3 Mar
The first of the Excel courses that aim to increase your spreadsheet skills in the context of working with CUFS data. Apart from extracting the data, learn how to manipulate and analyse it for reporting purposes, using a variety of Excel tools. Both sessions need to be attended.
Issued by Christine Rogerson - Finance Training
Quick Tip – Excel, using Sum function when data is hidden
The inbuilt sum functions in Excel don't account for hidden columns and rows. The subtotal option will ignore cells which are filtered out but not those which are hidden. However, it is possible to add in an extra function which will do this for us. Watch video here (1m33s). For the code, click here.
Issued by Helen Parker, Finance Training
Supplier Database - Browsers
We would like to remind users that the Supplier Database no longer works with Internet Explorer.
Issued by Paul Humphreys - Functional Analyst
Monthly Accounting Timetable
To view the status of the monthly process including the month end close dates please use the following link: Accounting Timetable
- Click here for Bulletin archives
- If you would like to receive the bulletin email please send your details to this address