Year End 2021 Gantt Chart

…… ……

31 1 2 3 4 7 8 9 10 11 28 29 30 1 2 5 6 7 8 9 12 13 14 15 16 19 20 21 22 23 26 27 28 29 30 2 3 4 5 6 9 10 11 12 13 16 17 18 19 20 23 24 25 26 27 30 31 1 2 3 6 7 8 9 10 20 21 22 23 24

Final date for new staff contracts to be with HR

Review final dept monthly payroll to ensure correct account codes

Final date for overtime claims input to Payroll

Final monthly payroll posting N/A

Final input for weekly payroll posting for 2020/21 YE

Final date for making UPS payments for 2020/21 financial year (pay run 13 Aug)

Final weekly payroll posting 2020/21 N/A

Final date for UPS payroll posting N/A

Coronavirus Job Retention Scheme Credit (July posting) N/A

Accrue for costs to be included in the 2020/21 financial year that missed the deadline

Run and review Open Purchase Order report (Excel version)

Run and review Purchasing Requisition Status report

Complete, cancel or finally close open or incomplete purchase orders and requisitions

Final date to process all PO transactions (NB PO close 5 pm)

Complete Cash Holding Confirmation form for balances as at 30 June

Identify and bank all cash, cheques received up until the end of July

Module opened for 2021/22 financial year N/A

Process all cash, cheque and (if possible) PDQ receipts relating to 2020/21

Last date for raising Internal Trading invoices and sending backing

Submit invoice write off forms to Credit Control

Bank charges and small balance adjustments posted N/A

Receipt any remaining BACS receipts and unclaimed PDQ income

Raise, complete and dispatch all external AR invoices  (NB AR closes 5pm)

Last date for issuing invoices to Group-defined organisations

Departments notified of resolved Internal trading disputes N/A

Full individual debt statements emailed to departments N/A

2021/22 internal trading invoices can be raised N/A

Last date to review for bad debts and notify Credit Control

Final posting of bad debt provision N/A

Supplier statement reconciliations instructions sent out to departments - 4 Jun N/A

July Barclaycard statements available to print N/A

Submit 2020/21 AP items to Shared Services by c.o.b.

Clear all remaining Invoices on Hold

Recode all 2020/21 Internal Trading AP invoices

Notify Finance Division of any disputed Internal Trading invoices

Code all remaining Barclaycard expense forms

Process all invoices related to Group-defined organisations

Process all remaining staff and visitor expenses

Resolved Internal Trading disputes notified to Depts N/A

Process all remaining AP invoices (NB AP closes 5pm)

Return supplier statement reconciliation to Finance Division (Distributed 5 Jun)

Physical stocktake

Update Inventory balances with results of stock take

Process all receipts and issues of stock up to 31 July (NB INV closes 5pm)

Provide departments with inventory reconciliation N/A

Distribution of Grants Report (version 1) N/A

Review and clear grants fund check failures and exceptions

Correct research grant VAT errors

Post EC PI time journals N/A

Clear suspense account

Distribution of Grants Report (version 2) N/A

Unreconciled suspense items cleared to department GL overhead accounts N/A

Unresolved Fund Check Failures cleared to original Grant

Finalise and release all research grants journals, including EC PI Time journals

Review final grants position BEFORE 5 pm (NB Grants close 5pm)

Overheads, revenue and the EC FW7 Price adjustments re-run N/A

Distribution of Grants Report (version 3) N/A

Distribution of Fixed Asset Register as at 30 Jun to departments N/A

Review all departmental assets against the Fixed Asset Register

Physically verify assets against the Fixed Asset Register

Notify FA helpdesk of disposals/amendments

Return the amended departmental Fixed Asset Register

Exception spreadsheet sent out to departments N/A

Ensure that July not tracked additions are included on register

Notify FA helpdesk of July missed assets (Dept close)

Processing of all amendments to FA register (NB Module close 5pm) N/A

July 2021 Chest Allocation (5 Postings plus Final) Budget field frozen in CUFS 25 Aug N/A

Trust fund overheads posted (1st, 2nd, Final)

Appropriations in Aid

Balance and post petty cash for 2020/21 N/A

Process Barclaycard expenses BEFORE AP close

Carbon Reduction Charge (CRC) journal posted N/A

Last date for funds on deposit movement

EC PI Time adjustment N/A

July CUEF distribution accrual and deposit account interest posted N/A

Clear trust fund deficits (Trust Fund Statement #2 issued 24 Aug )

Final journal for Jul-21 VAT return adjustments that impact departments N/A

CUEF valuation journal posted and departments notified N/A

Process journals for any remaining credit card expenditure

Ensure expenditure is coded against the same SoF as related income and clear deficits

Complete spreadsheets for income and expense accruals - last date 1 Sep

Process remaining departmental journals (NB GL closes 5 pm)

ICC overhead journals processed (Ver 1 and Final) N/A

CUEF Revaluation posted for June and July (Into July GL period) N/A

Actual July CUEF Distribution posted into Adjustment Period 1 N/A

NB Last CUEF unit trading date for 2020/21: June 17 N/A

Departmental Summary Reports (1, 2 & 3) N/A

Trust Fund Statements (June, 1st, 2nd and Final) N/A

Basic roll forward of balances N/A

Special roll forward of balances N/A

Departmental Certificates N/A

Key Dates

w/c 28 Junw/c 14 Jun w/c 6 Sep w/c 20 Sepw/c 23 Augw/c 19 Jul w/c 26 Jul w/c 2 Aug w/c 9 Aug w/c 16 AugComplete

Purchasing

w/c 30 Augw/c 12 Julw/c 5 Jul

Payroll

w/c 31 May

General

Ledger

Accounts

receivable

Inventory

Grants

Accounts

payable

Fixed

Assets

Version 1.0 May-2021