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 Fiscal Years 2019 - 2023. 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 2023
- (Cash) For prior year cash pension, use the current year template which has the prior year tab
- (GAAP) Pension Worksheet
- (GAAP) For prior year RSI, use the current year template
Pension/OPEB Templates for Fiscal Year 2022
- (Cash) For prior year cash pension, use the current year template which has the prior year tab
- (GAAP) Pension Worksheet
- (GAAP) For prior year RSI, use the current year template
Pension/OPEB Templates for Fiscal Year 2021
- (Cash) For prior year cash pension, use the current year template which has the prior year tab
- (GAAP) Pension Worksheet
- (GAAP) Pension Note for State Sponsored Plans
- (GAAP) Pension Note for Single Employers (Qualifying Trust)
- (GAAP) Pension Note for Single Employer (No Qualifying Trust)
- (GAAP) Defined Benefit Other Postemployment Benefit (OPEB) Plans Note – No Qualifying Trust
- (GAAP) Defined Benefit Other Postemployment Benefit (OPEB) Plans Note – Qualifying Trust
- (GAAP) For prior year RSI, use the current year template
Pension/OPEB Templates for Fiscal Year 2020
- (Cash) For prior year cash pension, use the current year template which has the prior year tab
- (GAAP) Pension Worksheet
- (GAAP) Pension Note for State Sponsored Plans
- (GAAP) Pension Note for Single Employers (Qualifying Trust)
- (GAAP) Pension Note for for Single Employer (No Qualifying Trust)
- (GAAP) Defined Benefit Other Postemployment Benefit (OPEB) Plans Note – No Qualifying Trust
- (GAAP) Defined Benefit Other Postemployment Benefit (OPEB) Plans Note – Qualifying Trust
- (GAAP) For prior year RSI, use the current year template
Pension/OPEB Templates for Fiscal Year 2019
- (Cash) For prior year cash pension, use the current year template which has the prior year tab
- (GAAP) Pension Worksheet
- (GAAP) Pension Note for State Sponsored Plans
- (GAAP) Pension Note for Single Employers
- (GAAP) Defined Benefit Other Postemployment Benefit (OPEB) Plans Note – No Qualifying Trust
- (GAAP) Defined Benefit Other Postemployment Benefit (OPEB) Plans Note – Qualifying Trust
- (GAAP) For prior year RSI, use the current year template