NCAS

Agency End of Year Calendar and Checklist - Fiscal Year Ended 2008

DATE

ACTIVITY

COMMENTS

DATE COMPLETED

JUNE TASKS

6/1 - 6/29

 

Review SBM Validation Report

SBM Validation Report is used to detect detail line errors in an SBM batch. The report is available daily in the Systemware report group OSCOP* GL EOY SBM VALIDATE ERROR or can be run out of the GLPUBLIC IE library as C-U-GL-SBM-VALIDATION-REPORT.

 

6/2 - 6/30

Override payment terms to pay invoices by June 30, where appropriate

Agencies must override payment terms on invoices for all payments to be issued in FY 2008 by June 28. (All AP transactions to be paid from current year appropriations must have a PCC payment date no later than June 28.)

 

6/2 - 6/30 

Verify PO multi-year indicators

Run PSPUBLIC IE reports C-U-PS-LIST-FUTURE -PO and C-U-PS-LIST-FUTURE-REQ and make any necessary corrections to the multi-year indicators. Only documents with 09 indicators will be converted to a current encumbrance in the next fiscal year. Review all requisitions and POs containing a prior year indicator.

 

6/2 - 6/30 

Review open requisitions

Review all open requisitions by running PSPUBLIC IE report C-U-PS-REQUISITION-AGING.  Convert open requisitions to PO 's, where appropriate.

 

6/2 - 6/30 

Delete all requisition headers and purchase order headers with no attached lines

Use the C-U-PS-REQ-MAINT report to list all requisition headers with no attached lines and the C-U-PS-PO- MAINT-REPORT to list all purchase order headers with no attached lines.

 

6/2 - 6/30

Manually close all purchase orders where no more activity (receiving or invoicing) will take place

The NCAS closes these automatically only when payments are within tolerances.  Agencies can use report C-U-AP-INVOICE-STATUS (in the APPUBLIC Library) to help identify candidates for manual closing.

 

6/12

Submit CI budget code requisitions for CI's funded by COPS

Capital Improvements requisitions funded by COPS must be submitted by 11:00 a.m. on this date. 

 

6/12

Submit CI budget code requisitions for other CI’s and bond appropriations /Submit certifications of deposit

Capital Improvement budget code requisitions for other CI’s and those funded by bond appropriations must be submitted by 11:00 a.m. on this date. Certifications of deposit must be received by 2 pm.

 

6/13

Process cash transfers for CI reversions

Cash transfers for CI reversions to the general fund must be received at OSC by 11:00 a.m. on this date. The IGO vendor # for the reversion is 561611588-08 (OSCGENFUNDREV)Remittance message should be: FY 2008 CI Reversion. For those not processing through the A/P module in NCAS please prepare a CMCS transfer to Dept 9973 with budget code in explanation of transfer section.

 

6/20 - 6/30

Zero $ invoices extracted

Bank Account Policy is updated to post zero $ checks to GL.

 

6/23

Deadline for submitting CI certified reports to Central Managers

Certified CI reports for June are due to Central Managers on this date.

 

6/20

Deadline for transfer of net proceeds from sale, lease or rental of lands

Net proceeds from sale, lease or rental of property should be transferred to OSC by 11:00 a.m. on this date. The IGO vendor # for the transfer is 561611588-08 (OSCGENFUNDREV). Remittance message should be: Net proceeds from sale, lease or rental. For those not processing through the A/P module in NCAS please prepare a CMCS transfer to Dept. 9978 with the message in the explanation of transfer section.

 

6/20

Deadline for transfer of funds for sale of surplus property

Receipts in excess of the amount budgeted from the sale of surplus property should be transferred to OSC by 11:00 a.m. on this date. The IGO vendor # for the transfer is 561611588-08 (OSCGENFUNDREV). Remittance message should be: FY 2008 Sale of Surplus. For those not processing through the A/P module in NCAS please prepare a CMCS transfer to Dept 9978 with the message in the explanation of transfer section.

 

6/28

Reconcile all clearing accounts

All clearing accounts should have a zero balance before certification.

 

6/28

Clear all suspense balances

All suspense accounts should have a zero balance before certification.

 

6/28

Review the Suspended Batch Master file

All FY 2008 SBM entries need to be corrected and released.

 

6/27

Deadline for closing out travel advances

All permanent and temporary travel advances need to be closed. Travel advance account (532799) must have a zero balance. Outstanding Employee advance Report (AP-I0005) must show no advances and the Negative Balance Report (I-0004) must have no negative balances for employees. Reports are in XPTR - OSCOPX MM122-6 AP BALANCE/MAINT..

 

6/28

Deadline for Reviewing and resolving outstanding credit/debit memos.

Resolve all credit/debit memos that have been outstanding for more than a year. Review all credit/debit memos for collection. Use Negative Balance Report (I-0004) in XPTR - OSCOPX MM122-6 AP BALANCE/MAINT and the Credit Memo List report (I-004A) in XPTR - MM122-6 CREDIT MEMO LIST.

 

6/28

Deadline for reconciling Procurement-Card Transactions

Reconcile all charges in PC module associated with payments that have a payment date prior to 6/30/08. All transactions on PUTL and PILS with a P in the Pay Indicator field must have a status 1 on PILS screen prior to 6/30/08.

 

6/28

End all BC documents

End all FY 2008 unfinished BC documents: ON HOLD AWAITING COMPLETION, ON HOLD AWAITING APPROVAL, and IN PROGRESS.

 

6/30 

Year-end check run processed

Check runs set on this date can be printed on July 1, but may not legally be issued until approved by CMCS on Tuesday, July 1.  All payments with a PCC payment date of June 30 will post to GL with a June 29 effective date.

 

6/30

FY 2009 Company Fund Table created

FY 2009 budget funds will appear on the Batch Proof List dated 06/30.

 

6/30

Reimburse and close imprest cash accounts

Imprest cash should be reimbursed and closed out. NCAS effective date should be June 29.

 

JULY TASKS

7/1

NCAS system unavailable

NCAS system down for year-end processing.

 

7/2

EOY Trial Balances available for Fiscal Year Ended 2008

Begin reviewing June 30 (13th month) trial balances available daily in the following Systemware report groups:                                                                  OSCOP* GL EOY TB/BUDGET
OSCOP* GL EOY TB/BUDGET FUND
OSCOP* GL EOY TB/GASB
OSCOP* GL EOY TB/GASB FUND 

 

7/2 - 7/7

Automated accrual reversals posted

Verify prior fiscal year accrual reversals have been released from SBM.

 

7/2 - 7/7

Process manual reversing entries

Key and update any manual reversing entries.

 

7/2 - 7/15

Deadline for pre-certifying final budgetary reports

Certified June cash basis reports due to Central Managers by July 16.

 

7/2 - 7/31

Flag Accounts Receivable accruals for automated posting to June 30

Use BC to flag AR accruals for posting back to June 30.

 

7/2 - 7/31

Flag AP accruals for automated posting to June 30

Use accrual indicators to flag AP invoices for posting back to June 30.

 

7/3 - 8/13

Post manual accruals

Post manual accruals and adjustments for fiscal year ended June 30.

 

7/2 - 7/7

Carry cash forward

Perform cash carry forward procedures

 

7/2 - 7/7

Change GED dates

Request OSC to change date on GED screen to process cash carry forward checks.

 

7/2 - 7/31

Audit tape available

FY 2008 cash basis audit tape (periods 1-12) generated by request after cash is certified and closed.

 

7/7

Deadline for transferring fixed assets

Deadline for submitting FY 2008 asset transfers to OSC Support Services

 

7/8

FY 2008 Cash Close deadline

Final day to process cash entries in the Cash Management System (Post fourth quarter allotment reversion entry to NCAS with an effective date of June 30) Final requisitions must be rec’d by OSC on or before 11 am on this date.

 

7/31

Deadline for processing non-system checks

Process Non-system check deletes and cancellations

 

AUGUST TASKS

8/1 - 8/5

Review flagged accrual report for completion and correctness.

All accruals flagged during the month of July should be reviewed for accuracy and completeness.

 

8/1 - 8/6

Post flagged AP accruals
Post flagged AR accruals
Post Items Received Not Invoiced accruals

Request injection of flagged accruals.  Only one processing run can occur for each agency:


 

 

8/8

Fixed asset deadline

Last day to enter asset data for fiscal year ended June 30. Year ending reports are available in Systemware (refer to the Fixed Asset memo number 080009 for a detailed listing of reports). THE FA SYSTEM WILL BE DOWN UNTIL AUGUST 11, 2008.

 

8/15

Review CAFR information

Review GASB trial balances and DSS financial statements for completion and correctness

 

8/18

Year-end close packages

Prepare year-end close packages

 

8/29

CAFR Statements

Agency financial statements due to OSC.