FY 16 Year End Best Practices Bob Daley
FY 16 Year End Best Practices Bob Daley, Jen Edmonds, Stephanie Nasson FAS Office of Finance/Admin Ops June 2016
Year End Review Payroll
Payroll Year-End Review and Reminders • July 1 Reappointments and New Appointments • Year End Payroll Posting Dates, Accruals and Paycheck Details • 7/1/16 Salary Increase Schedule • Payroll Salary Defaults • Absence Management Year-End Reminders • FY 16 Floating Holiday Balances to Expire on 6/30/16 • Harvard Student Summer Object Code Change Page 3
July 1 Reappointments and New Appointments • People. Soft Auto-Term is scheduled to run on Saturday, June 25 th terminating all appointments with a June 30, 2016 end date. • All FY 17 reappointments must be completed and approved in Asperin by Monday, June 20 th to ensure that they are uploaded to People. Soft prior to the auto-term running. • Any Asperin generated reappointments received and processed after the auto-term runs will fail because we cannot reappoint on a terminated position. • Inadvertently terminating a position may have an impact on employee benefits. Page 4
July 1 Reappointments and New Appointments • Please take special note of reappointments for Research and Emeritus Professors who have annual paid appointments. If they are inadvertently terminated, it will affect their retirement benefits. • Review and monitor your current scheduled Term Appointments in CREW by running the Departmental-Term Appointments (HRTRMDP 038) report. • New 7/1/16 appointments should be entered into Asperin as soon as possible to avoid system and building access delays. Page 5
Year End Payroll Posting Dates, Accruals and Paycheck Details • University Central Administration will be responsible for posting yearend payroll accruals. • These accruals are done to record expenses for time worked in June in the proper fiscal year (FY 16). • The accrual will debit the payroll expense object codes and credit 2190 (accrued expenses). The FY 16 year-end accruals relate to two distinct payroll cycles. Page 6
Year End Payroll Posting Dates, Accruals and Paycheck Details Pay Run ID Pay Frequency Check Date Pay Period Accrual Based Percentage of on Check Accrual BW 070216 Bi-weekly 7/8/16 6/19/16 – 7/02/16 6/24/16 9/10 or 90% WKLY 070216 Weekly 7/8/16 6/26/16 - 7/2/16 6/24/16 4/5 or 80% The weekly paycheck paid to employees on Friday, July 1 includes the work performed from June 19 -25. Because the weekly payroll comprises FY 16 work in its entirety, the check itself will be posted to the General Ledger in June 2016 as a 6/30/16 entry. As this is not an accrual entry, it will not be reversed in July. Page 7
7/1/16 Salary Increase Schedule Exempt employees receiving a 7/1/16 increase can expect the following: First Check After Increase: 7/8/16 (Pay period 6/19 – 7/2/16) Increase Days In First Check: 7/1/16 (One business day) Bonus-in-lieu: 7/8/16 First Full Check at New Rate: 7/22/16 (Pay period 7/3– 7/16/16) Monthly employees receiving a 7/1/16 increase will see the full amount reflected in their 7/29/16 paycheck. Page 8
Payroll Salary Defaults • FAS Payroll will be providing a list of all employees from your department or center currently in default that require a journal transfer. • Payroll default account review - Summary Actual report for activity 799599. • The Summary Actual will return payroll object codes that have been charged to default. A detail listing report will provide the detail of individual employee payments that must be corrected. Page 9
Payroll Salary Defaults Select your department’s ‘Student/Temp’ People. Soft department number, not the ‘Parent’ number. Costing for all students hires should include the following earnings codes (Earn Code): Ø Regular (Leave Earn Code blank) Ø OTP – Overtime Premium Ø WST – Enter even if the student is not currently work-study eligible Ø Enter the % Distribution (One line of costing must have 100% entered. Multiple lines must add up to 100%) Page 10
Absence Management Year-End Reminders • All reported paid time off for FY 16 through June 30, 2016 must be approved by 3: 00 pm on Thursday, June 30 th. • This will ensure accurate reporting of the University's vacation liability and full reimbursement as we close out the year. • Please take a moment to review any new or outstanding requests and take the appropriate action. Page 11
FY 15 Floating Holiday Balances to Expire on 6/30/16 • All floating holiday balances expire at the end of each fiscal year. • Any unused floating holiday time will be forfeited. • Employee balances are eligible for payout upon transfer or termination only. • We encourage you to run the Comp Time Balance report in People. Soft (Main Menu>Harvard Reports>Time and Labor Reports>HU Comp Time Balances Report) to view floating holiday balances by Time & Labor group(s) or by individual employee. • Employees can view their balances in both Time & Labor and Absence Management. Page 12
Harvard Student Summer Object Code Change • On Sunday, May 25 th, Harvard students in object code 6110 changed to 6120 and FICA eligible status. • The Temp fringe rate will be applied. • There is no change to the student job code and eligible returning students will automatically be returned to object code 6110 in September. Page 13
New in FY 17 • Time and Labor Exceptions § Weekly Review and Clean-up • Massachusetts Sick Time Law § Temporary Employees Page 14
Year End Review Best Practices
Chart of Account Review & Cleanup • Review your department’s chart of accounts for unused chart values • To close UD funds, activity, sub activities, roots - FAS Applications Security • To close a gift fund - Keith Bitely • Identify funds with zero/low dollar balances and spend down/close funds • Write off remaining gift balances via Journal Voucher • Review fund balances and move expenses to clear deficits • Review Centrally-controlled funds to ensure charges are correct: • 000760, 000775, 000780, 000795, 000800 -000802 Page 16
Chart of Account Review & Cleanup • Review Budget to Actuals for current fiscal year • Budget Variance • Summaries Actual and Budget • If you are a Service Center, ensure your Internal Billings are up to date • Can be processed through the second close (Friday, July 15 @ 2: 00 p. m. ) Page 17
How to Write Off a Gift Balance • If a restricted gift fund is no longer being used and every effort has been made to spend a positive balance to zero, the balance can be written off using object code 7765, Fund Balance Write-Offs. • The balance can be a deficit or surplus of up to $50. 00 • These balances should be transferred to the 000001 fund. If this fund is not available, use a general Unrestricted Designated fund. Please contact Linda Kuros if you believe you have a situation that warrants a write-off. • Example of a write-off entry for a fund with a positive balance: • • DR Tub-Org-7765 -3 XXXXX-600300 -XXXXX CR Tub-Org-7765 -000001 -600300 -XXXXX • If you have a fund with a negative balance, then your entry will be the reverse of the example above. • AEA will be processed by the FAS Office of Finance in the 4 th close. Page 18
How to Write Off a Gift Balance • Once the account has a zero balance, a determination by the Department should be made to keep the account open or to close it. • If the fund terms are general and there’s a possibility that future gifts will be received, it’s permissible to keep the account open. • If additional gifts will not be received, it’s best to close the account. • Questions related to this issue can be directed to Keith Bitely. Page 19
How to Close a Gift Fund • Restricted gift funds can be only closed once the fund balance is zero. • If a determination to close an account is made, please send an email to Keith Bitely with the following information: • Tub • Fund name and number • Confirmation that the balance is indeed $0. • If you have cross val’d your fund and transferred monies to other FAS departments, FAS Schools or other tubs, the balances in their Tub/Org (within the account) must also be zero. • A CSMA chart request will be submitted to disable/close the account value provided. The request usually takes a few days to complete. Page 20
Unclaimed Wires Report • Provides a listing of all unclaimed wires for the entire University • Review this OBI report to look for receipts from external parties related to your department. While you may be anticipating a check payment, the vendor may have paid via wire. • Please review this report throughout the year and claim wires as funds are received. • To claim a wire, email Cash Receipts (cash_receipts@harvard. edu) and provide the following information to process the income transfer: • • Receipt number (IW#) and receipt date Actual amount of the wire Complete 33 digit string of coding Description of wire to be recorded on GL • The deadline for claiming a wire for FY 16 is Friday, July 8 th at noon. Page 21
Unclaimed Wires Report - Description • Please keep the descriptions brief but include enough information that others would know what it is for, like these examples: Reimb from XXX for J. Smith travel 4/1 -4/15 (code to expense) Refund from XXX for overpmt of invoice XXX (code to expense) Income from XXX for rent Jan-Mar (code to income) • Questions related to coding can be directed to Miguelina Rodriguez. Page 22
(Not so) New Credit Voucher Form • As of April 30, 2015, the Credit Voucher form was updated • The new credit voucher is available on the Office of Treasury Management website: • http: //otm. finance. harvard. edu/complete-credit-voucherform • Remember to use separate vouchers for cash and checks! • Cash Receipts Office is located at 1033 Mass Ave. , 2 nd floor. • Questions related to coding can be directed to Miguelina Rodriguez. Page 23
General Reminders • The minimum amount for an AP accrual, Prepaid Expenses, Deferred Revenue and Accrued Revenue is $10 k, consistent with prior years • Don’t forget accruals for recovery of salary, fringe and awards! • Use a new template each time you submit an ADI journal • Review journals prior to submission for coding, amount and policy compliance • Do not post journals beyond the 2: 00 p. m. deadline of the 3 rd close! • Save the envelopes for gifts received though the U. S. mail for proof of receipt of late June gifts. Please include the envelope when sending gifts to the ADS for processing. Gifts postmarked after June 30, 2016 will be processed as FY 17 donations. Page 24
Mark your calendars! • Final Spectra Drop In Session § Wednesday, June 8 from 10: 00 – Noon, Science Center B-09 § FY 17 requests due on June 6 th for A & H division § FY 17 requests due on June 10 th Science & Social Science divisions • Aurora TF/TA appointment trainings / Clinics coming in Sept § § Tuesday, August 2 from 1: 30 -3: 30 p. m. Thursday, August 11 from 10: 00 - Noon Wednesday, August 17 from 10: 00 – Noon To be held in the Science Center, B-09 • Please sign up at http: //finance. fas. harvard. edu/calendar/upcoming Page 25
AP Adjustment Form (for Equipment) Capital equipment coding corrections • The purpose of the form is to correct any errors within the 33 digit G/L coding for equipment charged to the 68 xx series • At year-end the priority is getting the object code correct since it impacts depreciation expense • Since the AP Adjustment Form flows through AP, it follows the AP closing deadlines • If you are aware of adjustments now, please start processing them before July • Do NOT journal corrections involving 68 xx! These will be found and will need to be reversed and processed via the AP Adjustment Form. Questions on how to use the form? Refer to the job aids on Eureka under the Fixed Assets section Page 26
Year End Review Accounting
Capital Assets / Oracle Assets Science Depts – Jess Mc. Call and Connor Crowley from the Capital Assets Team are scrubbing the data (purchases coded to 68 xx) sitting in Mass Additions within Oracle Assets. They are reaching out to depts to gather additional information if they have questions. Please respond to them quickly so they have time to do their work in the system. Questions regarding Oracle Assets? Refer to the job aids on Eureka under the Fixed Assets section Page 28
Capital Assets / Inventory Equipment Inventory – FY 16 is an inventory year for sponsored and non-sponsored assets [that meet certain criteria]. Below is a list of who is coordinating the inventories. Please respond back if you hear from these folks as we need to complete the inventory in Oracle Assets by 6/30/16. • • FAS affiliate tubs – Tub Officers Physical Resources assets in FAS tubs – OPRP Science Division – Jess and Connor All other divisions – FAS Finance Office (Maria Geovanos and Jen Edmonds) Need a copy of the Property, Plant and Equipment Policy? Refer to the link on the University Financial Administration website: http: //policies. fad. harvard. edu/pages/facilities-and-equipment Page 29
General Reminders for AP • Submit FY 16 payments & reimbursements in a timely manner; contact ASAP for assistance • Hold FY 17 payments & reimbursements until after FY 16 has closed; less paper for AP to manage. • Transfer all low dollar, high volume transactions to PCard (Fed. Ex, Data Shredder, Poland Spring) • When an invoice is not provided, use the FAS Payment Request template and type the necessary information • Be mindful of additional PCard sweeps during the year end close • Review the ‘Receiving’ tab in HCOM to confirm all of your FY 16 POs have been received. Page 30
Committed Funds Report • Not just for FY End! • Unbilled Items (“Quantity Received” > “Quantity Billed”) • Invoices on hold (“Unposted Amt” > 0) • Unspent POs/Remaining Balances (“Open Commitment” > 0) • Payment Requests (PR), Nonemployee Reimbursements (NR), Employee Reimbursements (WR) – should only appear for a few days Page 31
CFR Tips • Report DOES NOT show POs where invoices are on hold only for price • Sort and remove the following: Amounts less than a dollar Fed. Ex App POs BCD Transactions with minimal amounts remaining Foreign Wire Transfer balances • Posted Amount = 0 - Nothing was processed (lost in the mail, never turned in, processed against something else) • Marketplace PO Receiving Amount = 0 - Nothing was received. If this true, please follow up with vendor • Email AP customer service to close out POs - ap_customerservice@harvard. edu Page 32
New Accounts Payable forms § “In Lieu of” – to be used to process a Payment Request when an invoice is not provided by the vendor. § “Emergency Check Pickup” – allows you to pick up a check at 1033 Mass Ave. § “Deposit/Partial Payment, Enclosure and Special Mailing” – replaces the current Non-Standard Check Processing form Page 33
How to… • Clear a gift fund deficit : http: //hwpi. harvard. edu/files/fas_finance/files/how_to_clean_up_a_re stricted_gift_fund_deficit. pdf • To accept a credit card as payment (one time or ongoing): • http: //otm. finance. harvard. edu/credit-card-merchant-accounts • To deposit a check: • http: //otm. finance. harvard. edu/complete-credit-voucher-form • To use A/R: • If your department is a Service Center, please consider using Oracle A/R to bill recurring customers. Contact Jen Edmonds for details Page 34
Resources • General information & questions: • FAS Office of Finance website - http: //finance. fas. harvard. edu • Access to HU systems: • FAS Applications Security – appsec@fas. harvard. edu • Accounting: • • Maria Geovanos – geovanos@fas. harvard. edu Miguelina Rodriguez – mrodriguez@fas. harvard. edu • Procurement & Reimbursement: • Andry Mc. Fall – andry_mcfall@harvard. edu • Journals & AP Adjustments: • FAS Finance journal mailbox – finjrnl@fas. harvard. edu • Gifts & Endowments: • • Linda Kuros – l_kuros@harvard. edu Keith Bitely – keith_bitely@harvard. edu • To claim a wire: • Cash Receipts – cash_receipts@harvard. edu Page 35
- Slides: 35