jagomart
digital resources
picture1_Financial Spreadsheet 32909 | Esd 113 F 185 1819


 142x       Filetype XLSX       File size 0.35 MB       Source: www.k12.wa.us


File: Financial Spreadsheet 32909 | Esd 113 F 185 1819
sheet 1 instructions f185 instructions purpose form f185 requires esds to display amounts in a prescribed format to ospi this facilitates an accurate compilation of the esds financial activities into ...

icon picture XLSX Filetype Excel XLSX | Posted on 09 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: Instructions
F-185 Instructions

PURPOSE
Form F-185 requires ESDs to display amounts in a prescribed format to OSPI. This facilitates an accurate compilation of the ESDs' financial activities into a statewide financial summary. These instructions contain information for preparing and submitting Educational Service District (ESD) Annual Financial Statements (F-185) for Fiscal Year (FY) 2018–19.

TIME SCHEDULE—FORM SPI F-185
According to WAC 392-125-085, each ESD must submit a financial report to the Office of Superintendent of Public Instruction (OSPI) within 90 calendar days following the end of its fiscal year. For FY 2018–19, due to the timing of the Thanksgiving holiday, this due date is December 2, 2019. If financial information, applicable to all ESDs, is not available in a timely fashion and deprives the ESDs of the ability to complete their financial reporting by this deadline, OSPI is prepared to extend this due date by up to 30 calendar days.

Utilization of—FORM SPI F-185

Form SPI F-185, ESD Annual Financial Statements, is the format specified by OSPI. The F-185 is a spreadsheet-driven report. The completed F-185 excel workbook should be returned without modifications to row descriptions or cells containing formulas. Row and columns in the F-185 worksheets should remain intact. Spreadsheets not applicable to an individual ESD should remain intact and not deleted. Adding rows or columns in any worksheets is not authorized without prior notification and approval from OSPI.
F-185 financial reports not submitted to OSPI in the original format will not be accepted and will require resubmission. A number of informational edits can be found on the F-185. These should be corrected before the F-185 is submitted to OSPI.
The F-185 Annual Financial Statements and the F-185 template are available on the OSPI website by selecting the “ESD Reports and Resources” link from the School Apportionment website at
ESD Reports and Resources
Because the ESDs prepare the F-185 on an excel template, each ESD may need to modify their financial statements for GAAP presentation. If circumstances require the district to modify financial reports, retain a copy of the completed F-185 as submitted to OSPI and prepare appropriate financial statements for other reporting purposes.
Immaterial differences are anticipated between the F-185 reports prepared for OSPI and other financial reporting requirements. These differences include, but are not limited to: converting the documents to PDF or Word format; modifications to row descriptions; changing cell formulas to values; deleting blank rows or columns; deleting spreadsheets or supplemental reports which are not applicable; adding rows or columns as necessary for appropriate financial statement presentation.
PLEASE NOTE: SAO provides their observations about the F-185 and the ESD Financial Statements prepared for audit purposes — below.

FILING
Filing of the Annual Financial Statements is with School Apportionment and Financial Services at OSPI and with Audit Services at the Office of the State Auditor. Form F-185 may be filed electronically via email, with an attached file.
The signed Certification Page must still be mailed to: OSPI, School Financial Services, Old Capitol Building, PO Box 47200, Olympia, WA; 98504-7200.

If an ESD has a Property, Casualty, and Liability Risk Pool, please file that portion of the Annual Financial Statements within 150 days with State Risk Management, Office of Financial Management 360-902-7311, PO Box 41027, Olympia, WA 98504, and with each participating member of your insurance pool. The part of the statement concerning the Industrial Insurance Fund is to be filed with Certification Services Manager, Department of Labor and Industries, within six months after the end of the fiscal year 360-902-6867.

ASSISTANCE
If you have any questions regarding the ESD Annual Financial Statements, please contact Ralph Fortunato, Supervisor ESD Financial Reporting, at 360-725-6304 or Paul Stone, Supervisor ESD Accounting at 360-725-6303. The agency TTY number is 360-664-3631.

GENERAL OBSERVATIONS ABOUT THE F-185 TEMPLATE FROM THE STATE AUDITOR'S OFFICE

Since ESDs are proprietary fund type entities, they can also refer to SAO’s guidance on
proprietary fund financial statements
in BARS to help ensure their statements are fairly presented.

The GFOA checklist is also an excellent resource.

The template does not include a column for discreetly presented component units (if applicable).
The template does not include a line for Improvements other than buildings (or Other Improvements) capital assets. Also, “Land” is typically used (instead of “Land and Land Improvements”).
Intangible assets and infrastructure are not included in the template (if applicable).
The template does not include other deferred outflows/inflows of resources prescribed by GAAP (i.e. Grants Paid in Advance”).
The template does not include asset line items for OPEB and Pensions (if applicable).
Amounts in the financial statements and notes should be reported in whole dollars only, no cents. 
Lines with nothing to report should not be included.

Several line items include a “_” (i.e. “Unemployment_”). This isn’t a typical presentation. 
From OSPI: The “_” in the title description is necessary for reports submitted to OSPI. The tag segregates data for state-wide compilation. This departure from the typical presentation is noted for ESD financial preparers.

On the Statement of Revenues, Expenses, and Changes in Fund Net Position
“Pension Expense” and “OPEB Expense” balances could be misleading. Pension and OPEB expense are generally not noticeable on the operating statement because they are components of salaries and benefits, which are allocated across other balances/activities and funds. By not allocating these adjustments to the balances/activities and funds where salaries and benefits costs are reported, the ESD could be misstating these expense categories on the financial statements.
“Change in Compensated Absences” balance could be misleading. Wages and benefits are an operating expense and we would expect any adjustment to be allocated to General Operations and Administration, Instructional Support Programs, and Non-Instructional Support Programs.

Sheet 2: CERTIFICATION-COVER
ANNUAL FINANCIAL REPORT














Educational Service District #113
For the Fiscal Year Ended August 31, 2019







Submitted pursuant to WAC 392-117-035 to the Office of Superintendent of Public Instruction














Certified correct this
day of
, 20
to the best of my knowledge and belief.




























ESD Address 6005 Tyee Drive SW

Tumwater, WA 98512










ESD Website www.esd113.org




























Preparer Information





Name Calvin W. Brodie
Phone 360 464 6700
E-Mail cbrodie@esd113.org














Signature


Sheet 3: NET POSITION
Educational Service District #113


Note to preparer: Please be sure to hide rows that contain all zeros as well as the "check" rows when printing.
STATEMENT OF NET POSITION - ALL FUNDS


AUGUST 31, 2019











NOTE REF OPERATING WORKERS COMPENSATION FUND UNEMPLOYMENT FUND TOTAL ALL FUNDS
Paul Stone: Note References are removed from the financial reporting template. They are copied here as a resource for future use. Note numbers may have changed. NOTE REF




ASSETS













CURRENT ASSETS













Cash and Cash Equivalents Note 1
$10,006,109 $22,829,270 $4,972,357 $37,807,736
Note 1
Would be equal to Imprest Cash + Cash on Hand + Cash and Cash Equivalents - Warrants Outstanding 200, 230, 240 241


Accounts Receivable Note 1
$3,276,070 $478,604 $32,982 $3,787,656
Note 1

340


TOTAL CURRENT ASSETS

$13,282,179 $23,307,873 $5,005,339 $41,595,391






















NONCURRENT ASSETS













Land and Land Improvements Note 3
$1,500,000

$1,500,000



490


Building Note 3
$9,713,825

$9,713,825



491


Equipment Note 3
$2,453,881

$2,453,881



492 493


Less: Accumulated Depreciation Note 3
$(4,306,427)

$(4,306,427)



498 499


Net Capital Assets

$9,361,278 $- $- $9,361,278






















Net Cash/Investments Held for Compensated Absences Note 10
$892,236

$892,236



452


TOTAL NONCURRENT ASSETS

$10,253,514 $- $- $10,253,514






















TOTAL ASSETS

$23,535,693 $23,307,873 $5,005,339 $51,848,906






















DEFERRED OUTFLOWS OF RESOURCES













Deferred OutFlows Related to Pensions Note 5
$1,642,477

$1,642,477


Deferred OutFlows – Pension Plans The line item description is changed. 711

Deferred OutFlows Related to OPEB Note 6
$1,617,933

$1,617,933


Deferred OutFlows – OPEB Plans The line item description is changed.


TOTAL DEFERRED OUTFLOWS OF RESOURCES

$3,260,410 $- $- $3,260,410
Note 1




















LIABILITIES













CURRENT LIABILITIES













Accounts Payable Note 1
$842,586 $462,710 $107,113 $1,412,408
Note 1

601 600 650


Accrued Interest Payable Note 1
$50,488

$50,488
Note 5

604


Accrued Salaries Note 1
$160,058

$160,058
Note 1

605


Payroll Deductions & Taxes Payable Note 1
$76,673

$76,673
Note 1

610 613 619


Public Employees' Retirement System Note 1
$323,107

$323,107



616


Deferred Compensation Note 1
$17,483

$17,483



617


Bonds Payable Note 4
$235,000

$235,000
Note 5

670


Capital Leases Payable Note 4
$10,178

$10,178
Note 5

602


IBNR


$1,209,663 $138,478 $1,348,141







Open Claims


$1,369,050
$1,369,050



603


Unallocated Loss Adjustment Expenses


$425,000 $26,000 $451,000







Future L&I Assessments


$871,000
$871,000







OPEB Liability, short term Note 6
$278,600

$278,600
Note 1
CY Net Costs from Actuarial Report



TOTAL CURRENT LIABILITIES

$1,994,171 $4,337,423 $271,591 $6,603,184






















NONCURRENT LIABILITIES













Compensated Absences_ Note 10
$1,153,973

$1,153,973
Note 1
Please note: Dash Lines " _ " in the title descriptions are necessary for OSPI F-185 data reporting compilation. 452 261,737.00

IBNR_


$2,200,066 $2,838 $2,202,904







Open Claims_


$942,221
$942,221



604


Net Pension Liability_ Note 5
$6,509,364

$6,509,364
Note 6
Net Pension Liability The line item description is changed. 660

OPEB Liability_ Note 6
$9,049,485

$9,049,485
Note 7
Total OPEB Liability The line item description is changed. 661

Bonds Payable_ Note 4
$3,880,000

$3,880,000
Note 5

680


Investment in Joint Venture Note 11
$92,915

$92,915
Note X

453


TOTAL NONCURRENT LIABILITIES

$20,685,737 $3,142,287 $2,838 $23,830,862






















TOTAL LIABILITIES

$22,679,908 $7,479,710 $274,429 $30,434,046






















DEFERRED INFLOWS OF RESOURCES






Note 1





Deferred InFlows Related to Pensions Note 5
$2,301,887

$2,301,887
Note 6
Deferred InFlows – Pension Plans The line item description is changed. 751

Deferred InFlows Related to OPEB Note 6
$359,048

$359,048
Note 7
Deferred InFlows – OPEB Plans The line item description is changed. 756

TOTAL DEFERRED INFLOWS OF RESOURCES

$2,660,935 $- $- $2,660,935






















NET POSITION








Fund Balance Report Diff


Net Investment in Capital Assets Note 3
$5,246,278 $- $- $5,246,278


$5,246,278.00 $(0.28)


Restricted for Debt Service Note 4
$431,750

$431,750
Note 10
$431,750.00 $- 830

Restricted for Support Programs Note 9
$1,312,436

$1,312,436
Note 10
$1,312,436.00 $- 6405 1201 0264

Restricted for Risk Pool Net Position Note 8

$15,828,163 $4,730,910 $20,559,074



$-


Restricted for Joint Venture Note 11
$(92,915) $- $- $(92,915)
Note 12
$(92,915.00) $-


Unrestricted Note 9
$(5,442,289) $- $- $(5,442,289)


$(5,749,164.00) $(306,875.11) $3,606,875.00 $306,875.00 $(0.11)
TOTAL NET POSITION

$1,455,260 $15,828,163 $4,730,910 $22,014,334


$1,455,260.00 $(0.39)

















CHECK (should be zero)

$- $- $- $-





































Unrestricted for Net Pension Liability

$-










Unrestricted for Net OPEB Liability

$-










Unrestricted for Other

$-










Unrestricted Combined

$-

























Unrestricted on Financial Statement

$(5,442,289)










CHECK (should be zero)

$5,442,289











The words contained in this file might help you see if this file matches what you are looking for:

...Sheet instructions f purpose form requires esds to display amounts in a prescribed format ospi this facilitates an accurate compilation of the financial activities into statewide summary these contain information for preparing and submitting educational service district esd annual statements fiscal year fy ndash time schedule mdash spi according wac each must submit report office superintendent public instruction within calendar days following end its due timing thanksgiving holiday date is december if applicable all not available timely fashion deprives ability complete their reporting by deadline prepared extend up utilization specified spreadsheetdriven completed excel workbook should be returned without modifications row descriptions or cells containing formulas columns worksheets remain intact spreadsheets individual deleted adding rows any authorized prior notification approval from reports submitted original will accepted require resubmission number informational edits can found...

no reviews yet
Please Login to review.