jump to main menu jump to subject menu jump to content jump to footer
go image

Division Director

Christina Smith

Assistant Director

Rick Sweet


Accounting and Auditing
200 East Gaines Street
Tallahassee, FL 32399-0318

(850) 413-5510
design placeholder only

DATE: May 7, 2004
TO: Agency Addressed (No. 05, 2003-2004)
FROM: Douglas A. Darling, Director
Division of Accounting & Auditing
Department of Financial Services
SUBJECT: Fiscal Year Closeout

The following dates and times have been established for processing transactions affecting the 2003-2004 fiscal year. All times are Eastern Daylight Savings Time.

MYFLORIDAMARKETPLACE (MFMP)

MFMP transactions must be received in the Bureau of Auditing's queue by June 25, 2004, in order to be processed as current year disbursements. Please note, that while paper vouchers may be submitted to the Bureau up to 5:00 P.M. on June 30, 2004, MFMP transactions received by the Bureau on June 30, 2004, will not be processed as current year transactions. This is because Central FLAIR will pick up no Departmental FLAIR transactions on June 30, 2004.

PAYROLLS

All payrolls and related transactions submitted in accordance with your Agency payroll calendar for June 2004 will be processed as 2003-04 transactions.

All negative balances must be cleared by the close of business June 30, 2004. Agencies must input their data into Departmental FLAIR by the close of business on June 28, 2004 in order for the voucher to be posted on June 30, 2004. Agencies that have negative balances on June 30, 2004, 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.

ON-DEMAND PAYROLLS

Any transactions entered and approved by 5:00 P.M. on June 30, 2004 will be processed as fiscal year 2003-04 disbursements.

CLASS C PAYROLLS

We await the final outcome of 2004 Legislation regarding Class C Travel. Last fiscal year, the Implementing Bill for fiscal year 2003-04 General Appropriations Act prohibited the reimbursement for Class C travel.

YEAR-END BONUSES

Agencies may submit year-end bonus payments through either COPES or the PC Payment System, (submission using the PC Payment System is required for the Awards Payrolls), on any of the following payrolls:

Processing Date Payroll Type Warrant Date
6/01/2004 Awards Payroll* 6/04/2004
6/02/2004 Supplemental Payroll 6/08/2004
6/07/2004 Biweekly Payroll 6/11/2004
6/09/2004 Awards Payroll* 6/14/2004
6/15/2004 Awards Payroll* 6/18/2004
6/16/2004 Supplemental Payroll 6/22/2004
6/21/2004 Biweekly Payroll 6/25/2004
6/23/2004 Awards Payroll* 6/28/2004
6/24/2004 Monthly Payroll 6/30/2004

* The Awards Payroll is a warrant only payroll and will not generate EFT payments. If the bonus payments are processed on any other payroll run, the payment will be disbursed according to the employees' Direct Deposit authorization status.

CASH DISBURSEMENTS

1. Vouchers presented to the Bureau of Auditing for payment by 5:00 P.M. June 30, 2004 will be processed as 2003-04 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 2003-04 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 2004-05 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, 2004.

5. Batch disbursement transactions processed through Departmental FLAIR must be presented to Production Control by 1:00 P.M. Tuesday, June 29 in order for the resulting voucher schedules to be available for printing on the morning of June 30. Batch transactions processed on file transfers by the State University System (SUS) must be received by FLAIR on the night of June 28 in order for the vouchers to be available for printing on 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, 2004. The Bureau of Auditing must receive the supporting documentation by 5:00 P.M. on the same day.

7. No SUS accounting file transfers will be accepted on the night of June 30, 2004. FLAIR will accept only Property update transfers the night of June 30.

CASH RECEIPTS

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 2003-04. The Treasury must be able to read the bank validation on the deposit slips.

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 2003-04.

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 25 for fiscal year 2003-04. The Treasury's last day of processing debit memorandums for returned EFT transactions will be on June 30 for fiscal year 2003-04.

WARRANT/EFT CANCELLATIONS

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. Monday, June 28 will be restored to agency accounts in June 2004.

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 2003-04. For more information, please access the Bureau of State Payrolls website at: http://www.dbf.state.fl.us/bosp/bsp.html. Click on "Payroll Preparation Manual" and go to Volume V, Section 6.

SETTLEMENT VOUCHERS

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 16. 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 2003-04 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 2004-05 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 2003-2004 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.dbf.state.fl.us/aadir/statewide_financial_reporting/index.htm. Prior to closing, each agency is required to perform the following tasks:

1. Review each trial balance to ensure that it is in balance. Actual accounts (General Ledger Codes 1XXXX through 7XXXX) must balance separately from budgetary accounts (General Ledger Codes 8XXXX and 9XXXXX).

2. Ensure operating transfers and federal transfers as well as due to/due from within your agency are in balance. Also, agencies should confirm and correctly record material interfund balances and transfers with other agencies. Additional instructions will be forthcoming regarding materiality thresholds.

3. Review your trial balance to ensure cash balances agree with those reported in Central Accounting and investment balances in the State Treasury agree with those reported by the State Treasury.

4. Review each trial balance to ensure that the general ledger codes used are appropriate for the particular Statewide GAAFR and for financial statements. For a list of valid general ledger codes by Statewide GAAFR, access the SFRS website.

5. Review each trial balance for atypical balances and make corrections as necessary.

6. Review each trial balance to ensure that the amounts recorded as fund balance (General Ledger Codes 549XX and 55XXX) or net assets (General Ledger Codes 535XX through 539XX) equal to last year's ending audited fund balance or net assets amount. Last year's ending audited balances can be confirmed using report AGNCYBS previously sent to your statewide financial statement contact.

7. Review each trial balance to ensure that all revenues (General Ledger Codes 6XXXX) in your agency's general revenue funds (State Fund 1) have been closed out to Collections, General Revenue (General Ledger Code 546XX).

8. At least the day before closing, ensure that depreciation has been run for all capital assets in the property subsystem. We recommend that you run simulated depreciation prior to running the actual depreciation in order to identify and correct errors. Agencies that choose to depreciate their capital assets using a method different from the straight-line method or using a system other than FLAIR are responsible for providing the Statewide Financial Reporting Section with the correctly calculated depreciation amounts for financial statements.

9. Review each trial balance to ensure that appropriate fund balance reserves have been established for applicable governmental funds.

10. Ensure that a GASB 34 Fund Questionnaire and a Restricted Fund Questionnaire are completed for each new fund established and/or activated and submitted to the Statewide Financial Reporting Section for review. The questionnaires can be obtained from the SFRS website.

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 within 10 days after receipt.

Except for Form P4 (Subsequent Events) and Form 49 (Compensated Absences), all statewide financial statement forms are due to the Statewide Financial Reporting Section 10 days after closing. Form P4 is due December 10, 2004. Form 49 is due September 7, 2004. All audited financial statements and applicable statewide financial statement forms pertaining to component units are due on the agency's closing date (for component units with a fiscal year-end before June 30, 2004) or September 30, 2004 (for component units with a fiscal year-end of June 30, 2004). A schedule of component unit information due dates will be sent to agency heads or their designee. If the component unit audit or forms are not available by the due date, the agency must contact the Statewide Financial Reporting Section with an expected date of availability.

Additional closing instructions and information requests will be sent to agency statewide financial statement contacts.

In addition to statewide financial statements, agencies are required to submit the form and certification for the preparation of the 2004 Schedule of Expenditures of Federal Awards (SEFA) to the Statewide Financial Reporting Section by October 1, 2004. The form, certification, and instructions are available on the SFRS website.

Agencies should contact Timothy Hsieh at 410-9675 or Suncom 210-9675 for questions related to statewide financial statements and Steven Wilson at 410-9346 or Suncom 210-9346 for questions related to the SEFA.

OTHER ITEMS

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 21.

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, 2004.

4. Statewide document numbers will be reset to begin with number x5000000001 on July 1, 2004, 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 19, and Saturday, June 26, 2004.

6. Special Instructions for the six Universities transitioning off FLAIR on 7/1/04: the processing deadline for specific transactions set forth in the approved Transition Plan should be followed. Any questions concerning this transitioning process should be directed to the University's designated DFS Transition Coordinator.

CERTIFICATION FORWARD AT JUNE 30, 2004

No changes are known for the Certifications Forward process on June 30, 2004. Below is a summary of the Certification Forward information:

1. As was done in prior years, the CFI (Certified Forward at June 30, 2003) and NCFI (Certified Forward at June 30, 2004) fields will be available in FLAIR. Certifications forward at June 30, 2004 will be processed based on the NCFI. All items marked for certification on or before June 30, 2004 will effectively be marked in both the CFI and NCFI. FLAIR will read all subsidiaries on the night of June 30, 2004 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, 2004 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 Wednesday, June 2, 2004. 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, 2004 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, 2004) regardless of PPI. However, to record the balance as of June 30, 2004, 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 2003-04 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 2003-04, 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, 2003, 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, 2004 to be used to mark certified forwards in MFMP.

SUMMARY

Each agency can assist with closing the 2003-04 fiscal year in the following manner:

1. Make every effort to submit all your vouchers to the Bureau of Auditing by Friday, June 18.

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 410-9951, SC 210-9951
Bureau of Auditing 410-9194, SC 210-9194
Bureau of State Payrolls 410-9416, SC 210-9416


Return to Agency Addressed Memoranda Index