The Microsoft Word and Excel templates provided on this page are designed to help local governments with different aspects of their accounting and financial reporting for FY2022 and prior. The templates should be used in conjunction with the appropriate BARS Manuals, which contain additional information and instructions for the preparation of the financial reports.
Schedules Designed for Online Filing:
Schedule 19 – Labor Relations Consultant schedule (for annual report filing of fiscal years before Fiscal Year 2022)
Pension/OPEB Templates for Fiscal Year 2022
- (Cash) Pension Worksheet
- (GAAP) Pension Worksheet
- (GAAP) RSI for State Sponsored Plans
- (GAAP) RSI for Single Employers (Qualifying Trust)
- (GAAP) RSI for Single Employer (No Qualifying Trust)
- (GAAP) RSI OPEB (No Trust)
- (GAAP) RSI OPEB (Qualifying Trust)
Pension/OPEB Templates for Fiscal Year 2021
- (Cash) Pension Worksheet
- (GAAP) Pension Worksheet
- (GAAP) Pension Note for State Sponsored Plans
- (GAAP) RSI for State Sponsored Plans
- (GAAP) Pension Note for Single Employers (Qualifying Trust)
- (GAAP) RSI for Single Employers (Qualifying Trust)
- (GAAP) Pension Note for Single Employer (No Qualifying Trust)
- (GAAP) RSI for Single Employer (No Qualifying Trust)
- (GAAP) Defined Benefit Other Postemployment Benefit (OPEB) Plans – No Qualifying Trust
- (GAAP) RSI OPEB (No Trust)
- (GAAP) Defined Benefit Other Postemployment Benefit (OPEB) Plans – Qualifying Trust
- (GAAP) RSI OPEB (Qualifying Trust)
Pension/OPEB Templates for Fiscal Year 2020
- (Cash) Pension Illustration 1
- (GAAP) Pension Worksheet
- (GAAP) Pension Note for State Sponsored Plans
- (GAAP) RSI for State Sponsored Plans
- (GAAP) Pension Note for Single Employers (Qualifying Trust)
- (GAAP) RSI for Single Employers (Qualifying Trust)
- (GAAP) Pension Note for for Single Employer (No Qualifying Trust)
- (GAAP) RSI for Single Employer (No Qualifying Trust)
- (GAAP) Defined Benefit Other Postemployment Benefit (OPEB) Plans – No Qualifying Trust
- (GAAP) RSI OPEB (No Trust)
- (GAAP) Defined Benefit Other Postemployment Benefit (OPEB) Plans – Qualifying Trust
- (GAAP) RSI OPEB (Qualifying Trust)
Pension/OPEB Templates for Fiscal Year 2019
- (Cash) Pension Illustration 1
- (GAAP) Pension Worksheet
- (GAAP) Pension Note for State Sponsored Plans
- (GAAP) RSI for State Sponsored Plans
- (GAAP) Pension Note for Single Employers
- (GAAP) RSI for Single Employers
- (GAAP) Defined Benefit Other Postemployment Benefit (OPEB) Plans – No Qualifying Trust
- (GAAP) RSI OPEB No Trust
- (GAAP) Defined Benefit Other Postemployment Benefit (OPEB) Plans – Qualifying Trust
- (GAAP) RSI OPEB Qualifying Trust
Pension/OPEB Templates for Fiscal Year 2018
- (Cash) Pension Illustration 1
- (GAAP) Pension Worksheet
- (GAAP) Pension Note for State Sponsored Plans
- (GAAP) RSI for State Sponsored Plans
- (GAAP) Pension Note for Single Employers
- (GAAP) RSI for Single Employers
- (GAAP) Defined Benefit Other Postemployment Benefit (OPEB) Plans – No Qualifying Trust
- (GAAP) RSI OPEB No Trust
- (GAAP) Defined Benefit Other Postemployment Benefit (OPEB) Plans – Qualifying Trust
- (GAAP) RSI OPEB Qualifying Trust