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 FY2021 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 16 (FY2019) – Schedule of Expenditures of Federal Awards (SEFA)
Schedule 19 – Labor Relations Consultant schedule (for annual report filing of fiscal years before 2022)
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