Accounts Receivable (AR)

All departments need to confirm their petty cash, float balances and any advance balances as at 30 June 2020 by completing the 2020 Cash holding confirmation form. Completed forms (including NIL returns) should be returned to the Finance Division by 21 July marked for the attention of the Cashiers

In case of queries please email the Cashiers, or call Tel: 48867 

Cash and cheque receipts

Identify all monies received up to close of business on 31 July 2020, whether received via the post or over the counter. This includes monies from the emptying of all vending machines, key deposits and other collection items.

Departments should continue to bank cash and cheques received in relation to the new financial year but will not be able to enter receipt batches on UFS until 6 August, when the AR module is opened for the 2020/21 financial year.

Receipt batches

For all AR transactions please ensure the correct dates are used:

• Receipt batches, receipts and transactions relating to the old financial year must have both GL and receipt/transaction dates of JUL-20.
• Receipt batches, receipts and transactions relating to the new financial year must have both GL and receipt/transaction dates of AUG-20.
• Complete all receipt batches for cash, cheques (and if possible PDQ transactions) received by the University on or before 31 July 2020, using an accounting date of July 2020.

NB. All cheques need to be dated July 2020 or earlier.

• Run the Receipt Register Report (UFS) for each receipt batch and bank as normal.

NB. It may be that your first visit to the Cashier after the year end includes two receipt forms, one for each year. This is expected and acceptable.

• Run the Unapplied Receipts Register report to see where receipts have not been matched to an invoice. Apply receipts created against customers to clear outstanding invoices as necessary. 

Review for bad debts

A bad-debt provision will be posted into the General Ledger by the Finance Division Credit Control team once AR has closed on the 17 August. The value of the bad-debt provision posted against an invoice is determined by the age of the invoice and the balance due, as per the followi

The bad-debt provision is posted to the original sale's cost centre and Source of Funds using a transaction code of FJNA.

The dates for the processing of the bad debt provision for July 2020 are:

On 18 August, Credit Control will distribute the full individual debt statements to departments. These statements detail all overdue debt, and should be reviewed in conjunction with the Ageing–7 Buckets–by Account Report (UFS). Please email Credit Control about any additional doubtful or irrecoverable debtor items on or before 27 August.

BACS receipts, bank transfers and unclaimed PDQ receipts

Please ensure that all income is claimed and receipted from the twice weekly BACS list that Finance Division distribute for GBP, EURO and US Dollars, before AR is closed. July or earlier BACS, any previously unclaimed PDQ bank deposits and counter credits can be claimed by receipting them in the usual way. Ensure you use a July 2020 receipt and GL date.

Internal AR invoices

To send backup documentation to receiving department, use the relevant contact from the list of email addresses.

External invoicing – all departments

• Ensure that all external sales invoices, together with credit memos, have been raised in order to record all income due and all monies owed to the department.
• Run Incomplete Invoices Report to check there are no un-posted invoices.
• Refer to Other Debtors  if the final date for AR invoices has been missed.

Invoicing – departments with interfaces

Review all AR invoices pulled into the Accounts Receivable module through the Auto-Invoice process to ensure there are no errors. Make adjustments if these invoices need to be dated 31 July or earlier.

Group finance transactions

All AR transactions with the entities listed in Appendix E should be completed before the AR closure date of 17 August 2020.

As part of the Group consolidation process, any transactions which occur between these entities and the Academic University, are required to be separately identified as Group-related i.e. inter-company transactions.

The Central and Research Accounting section must be informed of any invoices in dispute with the listed entities as at the 31 July that have not been processed.