skip to content

UFS

 

Weekly Bulletin No. 823

Tuesday 4th August 

Procurement heading

Vector Laboratories Ltd / 2B Scientific

We have received notification from Vector Laboratories Ltd to inform us that the have been removed from the Marketplace and that 2B Scientific has been nominated as their distributor in the UK. 

2B Scientific have been asked to add the Vector Laboratories products to their Marketplace catalogue but at the moment any items required will have to be requested using  a non-catalogue order.  Notification will be sent out in the CUFS bulletin when this has been completed.

Issued by Heather Twinn - Procurement Service

Top

General Finance heading

Year End

Year end tasks to be completed this week

Last date

Module

Task

Actioned

Mon 3 Aug

AR

Process all cash, cheque and (if possible) PDQ receipts relating to 2019/20 and run the Receipt Register report(s).

 

Mon 3 Aug

GL

Indirect Cost Contribution (ICC) journal posted (Version 1)

N/A

Mon 3 Aug

GL

July 2020 Chest Allocation (Second Posting)

N/A

Mon 3 Aug

GMS

Distribution of Grants Report (version 1)

N/A

Mon 3 Aug

PAY

Final input for weekly payroll posting for 2019/20 YE

 

Tue 4 Aug

 

Interim summary reports sent out to departments (Interim report 1)

N/A

Wed 5 Aug

GL

Appropriations in Aid

N/A

Wed 5 Aug

GL

Trust Fund overheads posted (1st posting)

N/A

Wed 5 Aug

GL

Balance and post petty cash journal

 

Thu 6 Aug

PAY

Final date for UPS input for 2019/20 (pay run 14 Aug)

 

Fri 7 Aug

INV

Process all Inventory transactions (NB INV closes 5pm)

 

Fri 7 Aug

PAY

Final weekly payroll posting for 2019/20 YE

N/A

Fri 7 Aug

PO

Process all PO transactions (NB PO closes 5pm)

 

Mon 10 Aug

AP

Submit 2019/20 items to Shared Services for processing by 5 pm

 

Mon 10 Aug

GL

July 2020 Chest Allocation (Third Posting)

N/A

Mon 10 Aug

 

1st interim Trust Fund statement send out to Departments

N/A

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

Top

Department Name Changes

As advised in the Reporter, the departments listed below have changed their names.

These changes will be affective in CUFS from Monday 13th September, after year end reporting has been completed,

Department Code

From

To

AJ

Registrary's Office

Governance and Compliance Division

AN

Occupational Health and Safety Service

Health, Safety, and Regulated Facilities Division

AY

Legal Services Office

Legal Services Division

BY

EM Administration

Estates Division

Links to Reporter articles:

Grace 1 of 23 January 2020 (Governance and Compliance Division, Legal Services Division, and Estates Division): https://www.admin.cam.ac.uk/reporter/2019-20/weekly/6574/section7.shtml

Grace 1 of 10 June 2015 (Health, Safety, and Regulated Facilities Division): https://www.admin.cam.ac.uk/reporter/2014-15/weekly/6390/section7.shtml

Issued by Mike Sinclair - Central and Research Accounting

Top

Key Contacts- Users and Responsibilities Audit - Final Reminder

Users and Responsibilities Audit reports were emailed to Key Contacts on 3rd July.

A reminder was posted in Bulletin 322 and reports resent where necessary on Monday 3rd August.

Please note that failure to reply by Friday 7th August may result in access to CUFS being removed.

If you have any questions or unsure if your department has completed the audit please email UFS Audit 

Issued by Lesley Dent - System Administrator

Top

Cambridge University Endowment Fund – Notification of Revaluation & Purchases & Sales

Revaluation as at 30 June 2020
Please note that the Cambridge University Endowment Fund has been revalued as at 30 June 2020.

CUFS has been updated to reflect the new valuation in the July 2020 accounting period.  The new Unit value is £57.44 (rounded). The unit value at the end of the previous quarter was £52.27 (rounded) which represents an increase in value of 9.89%.

Revaluation as at 30 March 2020 Adjustment
Due to the exceptional financial market movements which took place during March, this meant the unit value calculated in April was only able to reflect part of the decrease in value because the illiquid assets in the fund only report with a delay. The Valuation Committee considered the question once the full information had been received, and in the light of the amounts involved on this occasion, it used the discretion given to the Investment Manager in the Information Memorandum “to make such adjustments or use such alternative valuation methods as it deems appropriate” in the interests of fairness to all investors.

The March 2020 unit price has therefore been updated from £53.31 to £52.27. Consequently, there will be additional entries in CUFS General Ledger codes correcting the capital valuation and distributions. New contract notes will be sent out to any departments that purchased or sold units at March 2020.

Purchases & Sales
Unit purchases and sales as at 30 June 2020 will also be processed within the CUFS July 2020 accounting period. Contract Notes for purchases & sales will be despatched in due course.

Next Quarter
Could all non-Trust Fund purchase and sale request be sent to treasury@admin.cam.ac.uk. All Trust Fund requests should be sent to UFS_TF@admin.cam.ac.uk.

The deadline for the requests to be received is the 17th September 2020.

Queries
Any queries should be addressed to:Scott Maclaren, Treasury & Investments, Finance Division, Ext 64216

Issued by Scott Maclaren - Treasury & Investments

Top

Data Conversion in CUFS - Warning

Please be aware that users should NEVER  use the keyboard combination Shift + 2 to enter quote marks in any field in CUFS.

An example where quote marks might be used would be to represent inches such as 21" monitor.

The quote marks may course some processes to fail along with other system issues.

Issued by Lesley Dent - System Administrator.

 Top

Latest Java Release update

The latest certified and tested version is 1.8.01_241, not 231 as stated in n bulletin 822.

The following are available from the Technical Download page

  • Latest certified and tested version - 1.8.0_241  

  • Latest Certified Version - 1.8.0_261

  • Certified Version  - 1.8.0_251

It is advised to have Automatic Downloads Disabled as new versions of browsers, some versions of JAVA or OS may not be compatible or supported.

Issued by Lesley Dent - System Administrator

Top

Training header

Quick Tip

Text to columns is used to split the text into multiple columns. This can be really helpful when you get your data from databases or you import it from other file formats such as Text or CSV.

Click the link to watch a demo Excel – Text to columns

Issued by Helen Parker - Finance Training

Top

FAQ heading

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

Top

Vulnerable Periods

Some systems may be unavailable between 6.00am to 9.00am Tuesdays and Thursdays. Users will be notified of planned vulnerable periods here and in the latest bulletin.