TO: Agency Addressed (No. 11, 2004-05)
FROM: Douglas A. Darling
Division of Accounting and Auditing
Department of Financial Services
SUBJECT: FISCAL YEAR CLOSEOUT
The following dates and times have been established for processing transactions affecting the 2004-2005 fiscal year. All times are Eastern Daylight Savings Time.
MFMP transactions must be received in the Bureau of Auditing’s queue by 5:00 P.M. on June 24, 2005, in order to be processed as current year disbursements.
All payrolls and related transactions submitted in accordance with your Agency payroll calendar for June 2005 will be processed as 2004-05 transactions.
All negative balances must be cleared by the close of business June 30, 2005. Agencies must input their data into Departmental FLAIR by the close of business on June 28, 2005 in order for the voucher to be posted on June 30, 2005. Agencies that have negative balances on June 30, 2005, and no vouchers pending, must provide the Bureau of State Payrolls with one account code so that these balances can be cleared. We will be unable to post to multiple accounts.
We strongly recommend that agencies closely monitor account balances in order to avoid delays in paying employees at the end of the fiscal year.
Any transactions entered and approved by 5:00 P.M. on June 30, 2005 will be processed as fiscal year 2004-05 disbursements.
CLASS C PAYROLLS
We await the final outcome of 2005 Legislation regarding
Class C Travel. Last fiscal year, the
Implementing Bill for fiscal year 2004-05 General Appropriations Act prohibited
the reimbursement for Class C travel.
1. Vouchers presented to the Bureau of Auditing for payment by 5:00 P.M. June 30, 2005
will be processed as 2004-05 disbursements.
2. Disbursement transactions below the voucher audit threshold must be input into Departmental FLAIR by 6:00 P.M. June 29, in order to be processed as 2004-05 disbursements.
3. Vouchers input into Departmental FLAIR on or before June 29, but not delivered to the Bureau of Auditing by 5:00 P.M. June 30 will be deleted from the Department of Financial Services’ pre-audit file. These vouchers will have to be corrected in FLAIR and resubmitted as 2005-06 vouchers.
4. Departmental FLAIR will not process disbursement transactions entered on June 30. Departmental FLAIR will generate a Transaction 58 for all vouchers producing disbursements. Consequently, all disbursement transactions including purchasing card and invoice tracking entered into Departmental FLAIR on June 30 will return to approval level 008. FLAIR will purge the voucher print file on the night of June 30 to ensure that no vouchers will print on July 1, 2005.
5. Batch disbursement transactions processed through Departmental FLAIR must be presented to Production Control by 1:00 P.M. Wednesday, June 29 in order for the resulting voucher schedules to be available for printing on the morning of June 30.
6. Expense tape batch input into the Central Accounting System must be delivered to Production Control by 1:00 P.M. June 30, 2005. The Bureau of Auditing must receive the supporting documentation by 5:00 P.M. on the same day.
1. The Treasury will receive bank deposit slips that have been validated by 2:00 P.M. June 30 via facsimile or hand delivery until 5:00 P.M. June 30. These will be processed if the Treasury receives a confirmation and the deposit is entered into a “T” status in FLAIR prior to 5:00 P.M. June 30. At 5:00 P.M. June 30, unverified receipts on the Treasury’s file will be rejected (placed in “R” status) and returned to the agencies by the Treasury. On the night of June 30, Departmental FLAIR will purge all outstanding cash receipts records from the cash receipts file. FLAIR will produce a report for each agency that had outstanding records purged. Agencies need to make correcting entries in Departmental FLAIR for all records purged from the cash receipts file.
2. Cash receipts may be input on June 30, transmitted to the Treasury, and verified on June
30. Supporting documentation that is validated by 2:00 P.M. June 30 must be
delivered to the Treasury by 5:00 P.M. June 30 in order for the deposit to be posted to
fiscal year 2004-05. The Treasury must be able to read the bank validation on the
3. Those agencies depositing through the Treasury’s concentration system must deliver a bank validated deposit slip on deposits made before 2:00 P.M. June 30 to the Treasury by 5:00 P.M. June 30. Except for wire transfers, the Treasury will not accept deposits made after 2:00 P.M. June 30 for fiscal year 2004-05.
4. Cash receipt transactions for current year refunds must be verified by the Treasury no later than 3:00 P.M., June 28. The resulting JT-2 will then be available for printing on June 29 and should be delivered to the Bureau of Auditing by 5:00 P.M., June 30. Expense refunds verified by the Treasury on June 30 will remain in the Refund account (001800).
5. Cash refunds in Clearing Accounts must be cleared to the Treasury by the close of business on June 28 in order to be transferred to the Treasury and verified on June 29. Expense refunds cleared from Clearing Accounts after this time will remain in the Refund account (001800).
6. Agencies should review all uncleared Clearing Fund deposits by requesting the Immediate Detail of Clearing Funds Deposits report through the CP function. A report of Clearing Funds not cleared is also available in the standard logon.
7. The Treasury’s last day of processing debit memorandums for returned checks for agencies will be on June 29 for fiscal year 2004-05. The Treasury’s last day of processing debit memorandums for returned EFT transactions will be on June 30 for fiscal year 2004-05.
1. Warrants cancelled by the agencies using the on-line cancellation system must be added
and approved by 5:00 P.M. June 30.
2. Warrants to be cancelled by the Reconciliation Section must be received and entered into
the system by 5:00 P.M. June 30.
3. Note: cancellations for payroll warrants are performed by the agencies and must be entered and approved online by 5:00 P.M. June 30.
4. EFT’s marked for deletion by 11:00 A.M. Tuesday, June 28 will be restored to agency accounts in June 2005.
5. Agencies should review their accounts to ensure the appropriate prior year cancellation revenue category code, 003700, has been established.
REFUND OF OVERPAYMENT OF SALARY
Any online refund of overpayment of salary approved by entering the deposit number online by 5:00 P.M. June 30 will be processed in fiscal year 2004-05. For more information, please access the Bureau of State Payrolls website at: http://www.myfloridacfo.com/aadir/bosp/bsp.html. Click on "Payroll Preparation Manual" and go to Volume V, Section 6.
Proposed or provisional settlement agreements must be received by the Bureau of Auditing, Room 448Q, Fletcher Building, or the Bureau of State Payrolls, Room 364, Fletcher Building, no later than 5:00 P.M. June 3. Previously approved, proposed or provisional settlement agreements, attached to payment vouchers received by the Bureau of Auditing by 5:00 P.M. June 30 will be processed as 2004-05 disbursements.
Timely resolution of settlement agreements is encouraged and recommended; however, settlement agreements must be submitted with sufficient detail and in a form sufficient to enable a prompt pre-audit. Those settlement agreements with voluminous detail that may hinder timely processing of other settlement agreements should be considered for processing as Certified Forward items. All settlement agreement payment vouchers not meeting the requirements of the Reference Guide for State Expenditures, page S-1, or the Payroll Preparation Manual, Volume IV, Section 13, will be returned for rescheduling as charges against FY 2005-06 appropriations or certifications forward. Any questions relating to this process and/or documentation requirements should be directed to the Bureau of Auditing or the Bureau of State Payrolls.
STATEWIDE FINANCIAL STATEMENTS
The 2004-05 fiscal year closing schedule by agency for statewide financial statements can be found by accessing the Statewide Financial Reporting Section (SFRS) website at http://www.myfloridacfo.com/aadir/statewide_financial_reporting/. Each agency is required to complete the Statewide Financial Statements Checklist. The checklist shall be signed by the agency’s chief fiscal officer (or equivalent) and submitted to SFRS by September 30, 2005. The following items are contained on the checklist:
1. The trial balance for every fund within the agency is in balance by agency’s closing date. Any necessary adjustments to balance a fund after closing have been submitted to the Statewide Financial Reporting Section (SFRS) by September 2, 2005.
2. All interfund balances and transfers within the agency are in balance by agency’s closing
3. All material interfund balances ($20,000 or more) and transfers ($50,000 or more) with other agencies have been confirmed and necessary adjustments to agency records have been made to reflect the correct amounts by agency’s closing date.
4. Cash balances for all funds agree with those reported in Central Accounting by agency’s closing date.
5. Treasury investment balances for all funds agree with those reported by the State Treasury by agency’s closing date.
6. For all funds, amounts reported as fund balance (GL 549XX and 55XXX) and net assets (GL 535XX through 539XX) equal last year’s ending audited fund balance and net asset amounts by agency’s closing date. Fund balance and net asset amounts have been confirmed using the report AGNCYBS previously received from the Statewide Financial Reporting Section.
7. All revenues in general revenue funds (State Fund 1) have been closed out to Collections, General Revenue (GL 546XX) by agency’s closing date.
8. Depreciation has been run for all capital assets in the property subsystem at least the day before agency closing. Agencies that choose to depreciate their capital assets using a method different from the straight-line method or using a system other than FLAIR have correctly calculated depreciation amounts for financial statements and properly reported the amounts in agency records by agency’s closing date.
9. All fund balance reserves except for fund balance reserved for encumbrances and fund balance reserved for fixed capital outlay for applicable governmental funds have been properly reported in agency records by agency’s closing date. All adjustments for correcting fund balance reserved for encumbrances and fund balance reserved for fixed capital outlay have been submitted to the SFRS by September 16, 2005.
10. All Net Assets Invested in Capital Assets, Net of Related Debt (GL 536XX) for proprietary funds (SWGF 50 and 60) have been properly reported in agency records by agency’s closing date. Amount for Net Assets Invested in Capital Assets, Net of Related Debt of a fund should equal total capital assets of the fund less accumulated depreciation and less any related debt associated with the capital assets.
11. Short-term and long-term compensated absences for applicable funds have been properly calculated and reported in agency records by September 2, 2005. Statewide Financial Statement Form 49 (Compensated Absences) for applicable funds along with necessary adjustments have been completed and submitted to the SFRS by September 2, 2005.
12. All revenues and expenditures recorded from the Sale of Fixed Assets (GL 622XX), Operating Capital Outlay (OCO) Expenditures (GL 721XX), Fixed Capital Outlay (FCO) Expenditures GL 722XX), Installment Purchase Acquisitions (GL 723XX), and Capital Lease Acquisitions (GL 724XX) in your operating funds (SWGF 10, 20, 30, or 40) have been offset in your Fixed Assets Account (SWGF 80) with the same amounts by agency’s closing date.
13. All revenues and expenditures recording Installment Purchase Note Proceeds (GL 693XX), Capital Lease Inceptions (GL 694XX), Proceeds of Refunding Bonds (GL 695XX), Principal Retirement (GL 731XX), Advance Refunding Escrow Payment (GL 733XX), and Payments to Refunded Bond Escrow Agent (GL 795XX) in your operating funds (SWGF 10, 20, 30, or 40) have been offset in your Long-Term Debt Account (SWGF 90) with the same amount by agency’s closing date.
14. Analytical procedures have been performed for all funds to identify invalid general ledger codes, atypical general ledger balances, inconsistent general ledger code usage from prior year, etc. Any necessary correcting adjustments have been submitted to the SFRS by September 2, 2005.
15. For fiduciary funds only (SWGF 71, 73, 74, and 76), all 5-digit general ledger codes used are included in the “GL Matrix for Fiduciary Fund Statements” published on the SFRS web site at http://www.myfloridacfo.com/aadir/statewide_financial_reporting/. The following information for all newly established 5-digit general ledger codes necessary for fiduciary funds have been provided to the SFRS by agency’s closing date: (1) the new 5-digit general ledger code, (2) its title, (3) agency’s proposed roll up (financial statement line item) for this new general ledger code.
16. A GASB 34 Fund Questionnaire and a Restricted Fund Questionnaire for each new fund established and/or activated during the fiscal year ended June 30, 2005 have been completed and submitted to the SFRS by the agency’s closing date.
17. All applicable statewide financial statement forms (including e-forms) except Form P4 (Subsequent Events) and Form 49 (Compensated Absences) for the primary government have been completed and submitted to the SFRS by August 25, 2005. Form P4 is due December 1, 2005. Form 49 is due September 2, 2005. Amounts reported on all forms have been tied to amounts reported in applicable general ledger codes in the trial balance for each fund. Applicable general ledger codes are indicated on the forms themselves. All adjustments necessary to ensure agreement of form amounts to trial balance amounts or vice versa have been submitted to the SFRS by September 2,2005.
18. All audited financial statements, adjustments, and applicable completed statewide financial statement forms pertaining to component units have been submitted to the SFRS by the agency’s closing date (for component units with a fiscal year-end before June 30, 2005) or by September 30, 2005 (for component units with a fiscal year-end of June 30, 2005).
19. The data form and certification for the 2005 Schedule of Expenditures of Federal Awards (SEFA) have been properly completed and submitted to the SFRS by September 15, 2005. If the agency does not receive Federal funding, only submit the certification.
20. The Consideration of Fraud in Financial Reporting Certification (SAS No.99) has been signed by the agency head and submitted to the SFRS by July 8, 2005.
Closing reports will be sent to agencies subsequent to closing. These reports should be reviewed and any required adjustments should be submitted to the Statewide Financial Reporting Section by September 2, 2005. Additional closing instructions and information requests will be sent to agency statewide financial statement contacts. Agencies should contact Timothy Hsieh at 410-9675 or Suncom 210-9675 for questions related to items contained on the checklist.
1. Because of the heavy workload experienced at year-end, it is our intent to not accept manually prepared vouchers. Requests for exceptions should be directed to the appropriate Bureau Chief. Your cooperation in minimizing these exception requests will help us close out the fiscal year in a timely manner.
2. All old negative balances should be cleared no later than June 20.
3. All functions of FLAIR will be operational for the entire day on June 30 except as noted in the above paragraphs. FLAIR will purge the voucher print file on the night of June 30 to ensure that no vouchers will print on July 1, 2005.
4. Statewide document numbers will be reset to begin with number x6000000001 on July 1, 2005, where x denotes the data base on which the number is used. The number in the first position is incremented each year to avoid duplication of statewide document numbers across fiscal years.
5. Departmental FLAIR will be available on Saturday, June 18, and Saturday, June 25, 2005.
CERTIFICATION FORWARD AT JUNE 30, 2005
No changes are known for the Certifications Forward process on June 30, 2005. Below is a summary of the Certification Forward information:
1. As was done in prior years, the CFI (Certified Forward at June 30, 2004) and NCFI (Certified Forward at June 30, 2005) fields will be available in FLAIR. Certifications forward at June 30, 2005 will be processed based on the NCFI. All items marked for certification on or before June 30, 2005 will effectively be marked in both the CFI and NCFI. FLAIR will read all subsidiaries on the night of June 30, 2005 and set the NCFI to a blank.
2. At the agency’s request, FLAIR will reset the NCFI-C on all non-FCO state fund items (except those in SF-8) on the accounts payable and/or encumbrances subsidiaries at 6:00 P.M. June 30, 2005 for certifications forward. Agencies must “unmark” those items not to be certified. Receivables and memo encumbrances with no vendor will not be automatically marked.
Agencies should request automatic marking of subsidiary files in writing by Thursday, June 2, 2005. Letters should identify which subsidiaries should be marked. Mail requests to:
Mr. Herb Fillyaw
Division of Information Systems
200 E Gaines Street
Tallahassee, Florida 32399-4237
No subsidiaries will be marked for requests received after June 9, and telephone requests will not be honored. The letter should also include a request for FLAIR to create an FCO Certifications Forward file from your Projected Information file records. Otherwise, these records will have to be built manually as part of the FCO Certification process. FCO Certification records from last year have been purged from the file and are not available for update.
3. For those agencies not using the FLAIR automated marking, certifications forward may
be manually marked in one of the following ways:
a. Enter the “C” on the appropriate 60, 80, or 90 transaction (NOT 6S, 8S, or
9S subsidiary updates) as part of the original input. Use this method only after June
30, 2005 because FLAIR will reset the NCFI to a blank on that night and any
markings prior to that action will be lost. After June 30, transactions 60, 80, or 90
that carry a “C” will update NCFI (Certification Forward at June 30, 2005)
regardless of PPI. However, to record the balance as of June 30, 2005, the
appropriate PPI must be entered.
b. Call up the items on subsidiary inquiry/update screens and update them with a blank
PPI to carry the “C” in a single update mode. Subsidiary inquiry screens will show
both the CFI and NCFI fields.
c. Call up the items on the 1S-X screen and update them to carry the “C” and the date
received for accounts payable in a multiple update mode. 1S-X may be used only
for items that have no 2004-05 activity.
4. To “unmark” items that will not be certified forward, the item should be retrieved using the appropriate subsidiary update with a Blank PPI, or the IS-X screen (if there has been no current year activity), and erase the “C” in the CF field. This will remove the “C” from the NCFI.
5. Memo Accounts Receivable and Memo Encumbrances without Vendors may not be marked for certifications forward.
6. NCFI will be retrieved from the appropriate subsidiary Payment/Receipt in 2004-05, but may be overridden before processing.
7. As was done last year, Fixed Capital Outlay will be certified forward through the FLAIR Certified Forward system. Consult the EOG, Office of Policy and Budget for instructions in this area. In keeping with the policy of prior years, no FCO accounts will carry a certified forward indicator, but instead, will utilize the year indicator to identify appropriations to a specific year.
8. Certified forward processing must run before you close the fiscal year and cannot be run on the night of your year-end closing. This process is requested through the PE function. Certified forward information will be transferred to EOG upon request to the FLAIR Help Desk.
Requests must be called into the Help Desk by 2:00 P.M. on the day that you wish the transfer to occur. Only subsidiary records with positive balances will be processed and reflected on the certified forward reports. The certified forward processing and EOG transfers are separate, independent processes and must be scheduled/requested as such. If you close the year without first completing the certified forward processing, the transaction 07s to record GLs 122xx, 131xx, 134xx, 911xx, and 931xx will not be recorded.
9. You do not have to run certified forward processing before you pay items to be certified. The prior year, or June 30, 2004, subsidiary file balances are utilized for certified forward processing, but the current year on-line subsidiary function continues with updates to current year balances. Records with prior year balances will not be purged while you are in dual-year processing.
10. For agencies using FLAIR automated certified forward marking, a file will be prepared and sent to the MyFloridaMarketPlace (MFMP) system on June 30, 2005 to be used to mark certified forwards in MFMP.
Each agency can assist with closing the 2004-05 fiscal year in the following manner:
1. Make every effort to submit all your vouchers to the Bureau of Auditing by Friday, June 17.
2. Carefully check cash and appropriation balances in all accounts to ensure that sufficient amounts are available. This will eliminate delays or rejections of payments due to funds shortages.
3. Agencies using selected operating accounts for consolidating salary payments must adjust these accounts to reflect the correct salary disbursements before the close of the fiscal year. Transfers of salary charges must be made to the applicable accounts to eliminate year-to-date negative disbursement balances.
4. Carefully review year-to-date balances in all accounts to ensure that appropriations are not over-expended and that atypical balances do not exist. Generally, accounts must not be closed out showing atypical year-to-date balances.
5. For additional information, please contact the following:
Bureau of Accounting 413-5511, SC 293-5511
Bureau of Auditing 413-5512, SC 293-5512
Bureau of State Payrolls 413-5513, SC 293-5513