Fiscal Year-End 2020 Deadlines

April 16, 2020

Overview

COMMUNITY NOTIFICATION: Harvard University is closely monitoring the ongoing Coronavirus Disease 2019 (COVID-19) pandemic. If any deadlines change in response to the evolving situation, we will update the information as soon as we are notified by the associated department. The information herein is accurate as of April 16, 2020.

Harvard's fiscal year 2020 will end on Tuesday, June 30, 2020. As in the past, the University will close the books through a series of steps called "closings." Download a printable version of the Summary Schedule for FY2020 Transactions and Reporting. 

Please note the FY2020 year-end closing dates:

  • First closing:                        Thursday, July 2nd
  • Second closing:                   Friday, July 10th
  • Third closing:                       Friday, July 17th

In the following paragraphs, you will find closing deadlines and submission information for these financial transactions:

  • Accounts Payable
  • Vendor Setup, Maintenance & Reactivation
  • Credit Vouchers (Cash Receipts)
  • Credit Vouchers (Validated Deposit Slips)
  • Massachusetts Taxable Sales Deposits
  • Foreign Check Deposits on Credit Vouchers
  • Voided Checks
  • Stopped Checks
  • Escheat Checks
  • Foreign Currency Drafts and Wires
  • U.S. Wire Transfers
  • ACH Payments (Benefits/Tax)
  • Purchasing Card Sweeps
  • Web Reimbursements Reports with Advance Settlements
  • Concur Reports
  • Central Accounts Receivable
  • Journal Entries
  • Interdepartmental Billings
  • Cost Transfer Requests on Sponsored Funds
  • Chart of Accounrts Maintenance Requests
  • Year-end Reporting Guidance & Tips
  • CAPS deadlines
  • Fixed Assets

NOTE: In order to allow the tubs more time to process manual and spreadsheet (ADI) journal entries on the day of the first 3 closings, the manual/ADI journal entry deadline will be 2 p.m. Any journals uploaded to the General Ledger by 2 p.m. will be included in that close and will be available in the HDW the next day.

In addition, in order to provide the tubs with more timely information during the FY2020 year end, there will be three additional data refreshes to the Data Warehouse (HDW):

  • Sunday night, June 28th
  • Sunday night, July 5th
  • Sunday night, July 12th

June journals entered after the Friday, June 26th nightly processing and before 6:30 p.m. on Sunday, June 28th will be in the HDW on the morning of Monday, June 29th. June journals entered after the 2 p.m. deadline on the Thursday of the first close and Friday of the second close and before 6:30 p.m. on the following Sunday night will be posted and reflected in the HDW on Monday morning. Note that there will not be a data refresh on Sunday, July 19th after the third close. Any regular invoice batches and invoice imports that have been processed by the Accounts Payable department from Friday, June 26th through Sunday, June 28th will be uploaded on Sunday evening June 28th and reflected in the HDW on Monday morning, June 29th.

These are the Central Financial Administration deadlines. Since some departments have internal deadlines that may be earlier than these, you should check with your local tub financial office to obtain any departmentally defined deadlines.

We are expecting high reporting demands during the year-end closings so we have included in this newsletter some reporting tips to help improve the efficiency of running reports and reduce the time required to run those reports.

Closing Deadlines and Submission Deadlines Image 1

Closing Deadlines and Submission Deadlines Image 2

Closing Deadlines and Submission Deadlines Image 3

Closing Deadlines and Submission Deadlines Image 4

Journal Entries

Journal Data Entry Deadlines

Please keep in mind the following:

  • The University is closed on Friday, July 3rd in observance of the Independence Day holiday. Therefore, there will be no journal vouchers posted to the General Ledger or recorded in the Data Warehouse on that day. Rather these journals will be posted to the General Ledger on Sunday, July 5th and will be in the HDW on Monday, July 6th.
  • Any June journals entered into the system after 6:30 p.m. on Friday, June 26th and before 6:30 p.m. on Sunday, June 28th will be posted to the GL on Sunday night and be available in the HDW on the morning of Monday, June 29th.  This includes any entries processed over the weekend by Accounts Payable.
  • Any June journals entered between Thursday, July 2nd after the 1st close at 2 p.m. and 6:30 p.m. on Sunday, July 5th will be posted to the GL on Sunday night and available in the HDW on the morning of Monday, July 6th.
  • Any June journals entered between Friday, July 10th after the 2ndclose at 2 p.m. and before 6:30 p.m. on Sunday, July 12th will be posted to the GL on Sunday night and available in the HDW on the morning of Monday, July 13th.
  • The JUN-20 period will remain open and an option for journal preparers to select after the 3rd close at 2 p.m. on Friday, July 17th. This option remains until the 5th close on Wednesday, July 29th. However, any journals uploaded using the JUN-20 period WILL NOT be automatically posted to the general ledger but rather require manual posting by Financial Accounting and Reporting (FAR) staff in Central Administration.  Only the tubs’ central financial offices can arrange with FAR to have a journal posted in the 4th and 5th closes.  Any other journals uploaded by Oracle users will automatically get deleted by the automated deletion program 45 days after journal submission unless it gets moved to another period (JUL-20 or later) or is deleted before then by the submitter.
  • Be careful to select the proper period (JUN-20 or JUL-20) when you are entering a journal.  Beginning July 1st, the default period will be JUL-20 (FY2021). If you want to post a journal to FY2020 during July 2020 you will need to select JUN-20 as the proper period.
  • A journal should only be reversed by the person who created the journal, or with the permission of that person.
  • IMPORTANT NOTE FOR UNITS PROCESSING INTERTUB JOURNALS! If an interdepartmental journal needs to be processed in the 3rd closing, permission MUST BE obtained from the Central financial office of the tubs being both charged and credited.  It no longer is acceptable to have the approvals coming from tub departments. Departments needing to get such journals processed need to contact their tub’s central finance office. Individuals processing journals have personal responsibility to ensure they follow this requirement.

NOTE: Based upon departmental activity and the reports you run through the month of May, please make any necessary adjustments as early in June as possible.

Interdepartmental Billings

  • All interdepartmental billings, whether entered manually, via an ADI template or via a feed to the General Ledger, must be processed by the end of the 2nd closing. (GL billing feeds are generally submitted by service centers like HUIT and UOS.)
  • If an interdepartmental billing journal needs to be processed in the 3rd closing, permission MUST BE obtained from the Central financial office of the tubs being both charged and credited.  It no longer is acceptable to have the approvals coming from tub departments. Departments needing to get such journals processed need to contact their tub’s central finance office.
  • Interdepartmental billings should provide a name and contact number on the journal for questions or concerns the tub being billed may have.

Cost Transfer Requests

Cost Transfer Request Submission Deadlines

  • These dates apply to ALL requests for cost transfers to federally sponsored funds (funds in the range from 100000-199999). Note that these requests require supporting documentation.
  • Cost transfer requests should be submitted directly to OSP. OSP will review the request and documentation for appropriateness. OSP will enter cost transfer journals for departments during the year-end closing process, if necessary, due to school-specific closing deadlines.

Chart of Account Maintenance Requests

Disable Requests:

Friday, June 5th (MAY-20 close), is the last date that values will be disabled in FY2020. Any CSMA requests not successfully disabled on June 5th will be held until the final JUL-20 close.

Requests to disable CoA values that require approval should be submitted through CSMA before 5 p.m. on Friday, May 22nd. Disable requests that do not require approval should be submitted through CSMA before 5 p.m. on Wednesday, June 3rd.

Funds and sub activities with the status of "Ready to be disabled" in GMAS will be sent to CSMA on Wednesday, June 3rd, for processing. This is the last time sponsored funds and sub activities will be sent to CSMA to be disabled in FY2020. The next time "Ready to be disabled" sponsored values will be sent to CSMA is September 2nd.

Add / Modify / Re-enable Requests:

Requests to add, modify, or re-enable CoA. values submitted through CSMA will be processed according to the normal daily schedule (7 a.m. - 5 p.m., Monday - Friday) throughout the year-end. CSMA requestors wishing to specifically designate for the JUN-20 period any CoA changes entered from July 1st through July 29th should enter 30-JUN-2020 as the effective date for their request. 

GMAS will continue to send Add/Modify requests as usual during year-end. Requests to re-enable a sponsored fund or sub activity should be sent to the OSP Financial Analyst for approval by the OSP Portfolio Team Manager.

General Ledger Closings and Information Availability

General Ledger Closings ScheduleAs the fiscal year end comes to a close, many individuals have additional reporting responsibilities. Creating financial reports is few people's idea of a good time. Here's how to make your fiscal year-end reporting using HART a bit easier.

System Availability

  • The HDW nightly loads run from 8 p.m. to 7 a.m. Do not run dashboards during this time, as an incomplete nightly close process may provide you with incomplete data.

Tips and Tricks for Fiscal Year End Reporting in HART

Performance Tips

  • For speedier results, consider using the Transaction Listing All-Lite dashboard.
    • The dashboard includes only child object codes in order to find your chart values faster!
    • It has the Fiscal Year prompt to make it easier to obtain your FY2020 or FY2021 entries.
    • You will still be able to take advantage of all the HART features you love: exclude columns, subtotal, move columns to prompts and sections, export, print, save customizations and send bookmarks links!
  • If using the Transaction Listing dashboards, use the Period prompt to obtain your results faster.

Period to Period Prompt: Use Carefully!

  • During the fiscal Year-End period, two fiscal years will be open after Tuesday, June 30th. This will affect the results that you get when using the Period-to-Period prompts which means that:
    • HART will consider the current fiscal year as FY2021.
    • The Prior Fiscal Year selection will return FY2020 data.
    • The Current Fiscal Year to Last Closed Period selection will not return any data because there is no closed period in FY2021 until the July 2020 close.
    • The Current Fiscal Year to Current Open Period selection will show transactions posted to the month of July 2020.

Closing Selection Prompt

  • Use the Closing Selection prompt in conjunction with the appropriate Period or Fiscal Year prompt selection(s) for faster results. The Closing Selection prompt will update with the closing selection dates on July 1, 2020.
  • When you select one of the Closing Selection prompt ranges, you get everything that was posted during that time frame, whether it posted to June or July. Use the Closing Selection prompt in conjunction with the appropriate Period prompt selection(s) to ensure you are getting only the data you want.

Add in the Posted Date Column to Your Search Results

  • Consider adding the Posted Date column to your search results (available via right-click) so that you will be able to see the date that something was posted to the General Ledger. This can help you determine whether the transaction has been posted for the previous fiscal year or the current fiscal year.

Exporting Data

  • When exporting large amounts of data, use the Export link under your search results and select the Data>>CSV Format option.

CAPS Fiscal Year End 2020 Deadlines

To ensure that all necessary approvals are in place and all accounting entries are completed on time, appropriate CAPS forms must be submitted to Central Administration by your School/Unit's Authorized Requestor through the CAPS automated system by the dates set forth below.

  • Friday, May 22nd - Completed Project Proposals (PPs) and Construction Authorizations (CAs) submitted by this date will be processed, and CIP activities enabled where applicable, for FY2020.
  • Friday, June 12th - Completed Construction Close Requests (CCRs) submitted by this date will be processed for FY2020. Please note that Oracle Fixed Assets (OFA), GL, and CCR balances must be equal and have no future charges pending and no invoices in Mass Additions.

Forms submitted after the dates listed above will be held in a queue and processed in FY2021 when the CAPS system re-opens for approval. To coordinate with Fixed Assets closing, CAPS is extending the year-end blackout period to July 9th.

Oracle Assets Fiscal Year End 2020 Deadlines

The following dates represent the deadlines for activity related to or in the Oracle Assets sub-ledger.

Oracle Assets Fiscal Year End Deadlines

Contact List for Closings

Please click on the Print button found at the bottom of this article if you wish to print a version for quick reference.

Contact List for Closings

Summary Schedule for FY2020 Transactions and Reporting

This is the summary schedule for all FY2020 transactions and reporting which you can print and use as a quick reference.

Summary Schedule Image 1

Summary Schedule Image 2

Summary Schedule Image 3

Summary Schedule Image 4