BARS Account Exports In this section, governments can access a report providing information on the allowability of BARS codes in fund types as well as export a chart of accounts specific to a government type.
BARS Codes to Fund Type BARS codes may be restricted for use in the annual report filing system. The following matrix “Codes to Funds” identifies which fund group(s) that each active BARS code may be reported in.
Download FY2022 Codes to Funds here. Codes are as of November 30, 2022.
Note: It is recommended to use this matrix in conjunction with the government specific BARS Account Export provided below.
BARS Account Export Download a government specific BARS Chart of Accounts in the export box at the bottom of this page.
Your annual report requires seven digits for all account codes however, their display in the chart of accounts export varies. The expenditure or expense accounts are presented in the export without object codes. Object codes will need to be added to the BARS Code to complete the required seven digits for the annual report. Additional details about object codes are available in the BARS Manual 1.4. The reporting at the subobject level is not required.
How to use the BARS Account Export
Select a government type The government type selection will limit the BARS accounts that are applicable to the selected government type. If allis selected, the export will include BARS accounts for all government types.
Select basis of accounting The basis of accounting selection will limit the BARS accounts that are applicable to the basis of accounting selected (GAAP or Cash). If allis selected, the export will include all the BARS codes regardless of their applicability to a specific basis.
Select export type The Excel option provides a spreadsheet which you can format. The PDF is formatted to highlight the different categories of account codes and for printing. For display purposes, the account codes contain decimal points which should be excluded in your annual report. Select a reporting level Above and Prescribed option includes all the accounts, including the accounts in which other codes are rolled up into for category presentation. These above prescribed codes are not valid for reporting, however they provide detailed information on the category of the codes. This listing also provides the Prescribed accounts, which are the required accounts for annual report filing. The Prescribed option includes only the accounts which are the valid BARS account codes for annual report filing.
2.4.1.10 A budget is a legal document that forecasts the financial resources of a government and authorizes the spending of those resources for a fiscal period. At a minimum, local governments’ budget must meet the requirements of Washington state law and the State Auditor’s Office. The SAO does not prescribe how to budget or what a budget should look like. The adopted budget should be of sufficient detail to be meaningful and meet the intention of the law. The SAO considers budgets showing revenues and expenditures at the legal fund level to be the minimum acceptable level of detail.
2.4.1.20 Budgeting is more than just an activity to satisfy state law. It is a sophisticated process of strategic planning, communication and policy development resulting in a detailed plan of operations for allocating and monitoring the use of limited resources among various competing demands. Teaching how to budget is outside the scope of the BARS. However, there are many educational resources available to local governments, such as the Municipal Research and Services Center (mrsc.org) and the Government Finance Officers Association (gfoa.org).
2.4.1.30 Glossary of budgetary terms:
Annual/biennial appropriated budget – A fixed budget adopted for the government’s fiscal period. The appropriated budget was traditionally used to determine a government’s property tax levy, and a ceiling on expenditures was made absolute so that the expenditures of a government unit would not exceed its revenues. This budget was also historically a balanced budget, estimated revenues equaling appropriations. The appropriated budget is still used to set tax levies and some budget statutes still require balanced budgets, but it is more generally used to authorize a specific amount of expenditures regardless of whether estimated resources meet or exceed that amount. Appropriated budgets are required by statute in cities (Chapter 35.32A RCW, Chapter 35.33 RCW and Chapter 35A.33 RCW), counties (Chapter 36.40 RCW), and most other local governments in Washington State. These budgets are also called legal budgets, adopted budgets, or formal budgets. The appropriated budgets should be adopted by ordinance or resolution.
Appropriation – The legal spending level authorized by a budget ordinance or resolution. Spending should not exceed this level without prior approval of the governing body.
Capital improvement budget – Consists of two elements: the annual/biennial portion of capital projects and annual/biennial appropriations for the purchase, construction or replacement of major fixed assets in the current fiscal period.
Comprehensive budget – A government-wide budget that includes all resources the government expects and everything it intends to spend or encumber during a fiscal period. The comprehensive budget contains annual/biennial appropriated budgets, the annual/biennial portion of continuing appropriations such as the capital improvement projects, debt amortization schedules, and grant projects, flexible budgets and all non-budgeted funds.
Continuing appropriation – A fixed budget which authorizes expenditures for a fiscal period that differs from the government’s fiscal year, such as capital projects, debt issues, grant awards, and other service projects. These expenditures require an ordinance or resolution to authorize the project, establish the assessment roll, adopt the debt amortization schedule, or accept the grant award. Such ordinances or resolutions set an absolute maximum or ceiling on the expenditures, but the time period for incurring expenditures does not coincide with the government’s fiscal year; it may even cover several years. The major difference between annual/biennial appropriated budgets and continuing appropriations is that the latter do not lapse at fiscal period end; this implies that no legislative action is required to amend the annual/biennial portion of a continuing appropriation, unless the total authorized expenditures would exceed the entire appropriation.
Encumbrances – Commitments related to unperformed (executory) contracts for goods or services should be utilized to the extent necessary to assure effective budgetary control and to facilitate cash planning. Encumbrances outstanding at year end represent the estimated amount of expenditures ultimately to result if unperformed contracts in process are completed; they do not constitute expenditures or liabilities.
Final amended budget – The original budget adjusted by all reserves, transfers, allocations, supplemental appropriations, and other legally authorized legislative and executive changes applicable to the fiscal year, whenever signed into law or otherwise legally authorized.
Fixed budget – Those budgets which set an absolute maximum or ceiling on the expenditures of a particular fund, department, or other specific category. A fixed budget can be either an annual/biennial appropriated budget or a continuing appropriation. Fixed budgets must be adopted by ordinance or resolution, either for the government’s fiscal period or at the outset of a service project, debt issue, grant award, or capital project.
Flexible budgets – Are usually regarded as managerial tools, which do not set a ceiling on expenses or expenditures but establish a plan for them at various levels of service. They are especially appropriate for the day-to-day operations of a public utility where it is essential to plan fluctuations in the demand for services and where revenues will automatically increase with demand, so that a balanced budget does not depend on establishing a ceiling for expenses.
Operating budget – Presents the estimated expenditures and available resources necessary to provide the services for which the government was created. An operating budget will contain flexible budgets and fixed budgets; the fixed budgets will include annual/biennial appropriations for services and the annual/biennial portion of continuing appropriations for debt service and for service projects.
Original budget – The first complete appropriated budget. The original budget may be adjusted by reserves, transfers, allocations, supplemental appropriations, and other legally authorized legislative and executive changes before the beginning of the fiscal year. The original budget should also include actual appropriation amounts automatically carried over from prior years by law.
Working capital budget – Combines flexible and fixed budget elements in one document for enterprise and internal service funds. Current operations are flexibly budgeted based on the estimated level of services to be provided and long-range sources and uses of assets are controlled by annual/biennial appropriations and continuing appropriations.
3.9.5.10 Overhead costs consist of the costs of central services or support functions shared across departments. They may include accounting, human resources, payroll, information technology, janitorial services and others. Overhead costs may include not only the salaries, wages and benefits of the employees who work in these departments, but the utilities, supplies, information technology, building maintenance and other costs that support these employees. Typically, such services are initially paid through the general fund or an internal service fund and charged back to the departments and programs that directly benefited from them. The cost allocation process must be guided by an overhead cost allocation plan that describes how the organization will allocate costs reasonably and equitably across funds and departments and identifies the documentation required to support the charges.
Laws and requirements applicable to cost allocations
3.9.5.20 Under state law, government officials may charge a portion of the costs for their central overhead services to restricted funds, like utility funds or special revenue funds, only to the extent that each fund benefits from those services. Utilities charge user fees based on the cost of operating the utilities, and deposit those fees into utility operating accounts. Other restricted funds have dedicated revenue streams that can only be used for specific purposes. Governments must not allocate general government service costs, such as public safety, parks, law enforcement, community and economic development, or worker apprenticeship programs to the utilities or to other funds with restricted revenue sources that cannot pay for such charges.
3.9.5.30 RCW 43.09.210 indicates that when one fund is charging another, the fund being charged may only pay for the actual costs of the services it receives. Governments are expected to document those services and the costs of providing them to demonstrate these charges are fair, equitable and valid and reflect services provided.
All service rendered by…one department, public improvement, undertaking, institution and public service industry to another, shall be paid for at its true and full value by the department…receiving the same, and no department, public improvement, undertaking, institution or public service industry shall benefit in any financial manner whatever by an appropriation or fund made for the support of another...
3.9.5.50 Unlike all other funds, the general fund’s revenues consist largely of unrestricted sales taxes and property taxes that can be used to support any fund or undertaking of the government, including utilities or other restricted funds and their share of government-wide overhead costs. In contrast, a utility fund’s revenues consist of user fees that are restricted to paying for the costs of operating the utility, including necessary capital and debt service costs. These user fees cannot be used to support other funds or general government activities that benefit the public at large. Utility funds and other funds with restricted revenue sources should only reimburse the general fund for costs incurred to render services to those funds. Overhead allocation plans that equitably share overhead costs facilitate compliance with the above statute.
3.9.5.60 Similar to RCW 43.09.210, RCW 35A.33.122, RCW 35A.34.205 and RCW 35.33.123 indicate that a city may only charge its utilities for the value of services provided by general government staff:
RCW 35A.33.122 Administration, oversight, or supervision of utility - Reimbursement from utility budget authorized . . . Whenever any code city apportions a percentage ofthe city manager's, administrator's, or supervisor's time, orthe timeof other management orgeneral government staff, for administration, oversight, or supervision of a utility operated by the city, or to provide services to the utility,the utility budget may identify such services and budget for reimbursement of the city's current expense fundfor the value of such services.
3.9.5.70 Consistent with state law, local government is not allowed to charge general government costs that benefit the public at large to the utilities or to other funds with restricted revenues that cannot pay for such costs. General government costs that benefit the public at large, such as police, parks and recreation, community and economic development, worker apprenticeship programs, and other similar costs should not be charged to the utilities or to other funds with restricted funding sources that cannot be used for such expenditures. These costs do not benefit the utilities and may not benefit other funds with restricted revenue sources. In most instances, these costs must be charged to the general fund.
3.9.5.80 Local governments should carefully consider whether to charge the costs associated with elected officials to the utilities or other funds with legally restricted revenues. Ask the following question: “Do elected officials benefit the public at large in the form of citizen representation, or do they benefit the funds they oversee or legislate (municipal code, budget, etc.)?” If governments choose to allocate executive and legislative costs to the utilities or other funds with restricted revenues sources, they should exercise caution and should maintain documentation to show that those charges are equitable and reflect the cost of actual services provided to the utilities and other funds with restricted revenues.
If local governments decide to allocate council/commission/oversight board costs across funds, the use of agenda items as the basis to allocate these costs across funds likely results in a fairer and more equitable allocation than one based solely on budgeted expenditures. Cities, counties and other local governments are typically prohibited by the cost principles requirements located in Subpart E of 2 CFR 200 – Uniform Guidance from allocating the costs of elected officials to federal awards.
3.9.5.90 Local governments must allocate overhead costs fairly and equitably to those funds that benefit from overhead services. Charges to the benefiting funds must not exceed the cost and level of service that each fund receives.
Sound practices for fairly and equitably allocating overhead costs to benefiting funds
3.9.5.100 The beneficiary pays principle provides a foundation for cost allocation. Under this principle, the extent to which a support service provides a benefit to a fund/department, and the cost of providing those benefits, guides how much of the cost is paid by the fund/department. To achieve equity, the overhead allocation process must be well designed. By using leading practices for allocating overhead, local governments ensure they charge their utilities and other funds fairly. Such practices for allocating overhead among funds are discussed in our performance audit on Local Government Allocating Overhead Costs published November 28, 2011.
3.9.5.110 Sound practices start with a written cost allocation plan. Written overhead allocation plans document why and how an organization allocates overhead costs. The sound practices identified by our performance audit for accurately and equitably allocating overhead costs are summarized in Exhibit 1. These practices and requirements apply to all overhead cost allocations, including those that are accomplished through the use of internal service funds.
Sound practices and requirements for allocating overhead costs
1. Develop and maintain an overhead allocation plan that reflects decisions about which overhead costs will be allocated to which funds or departments and on what basis. A well-developed plan must: a. Include relevant, up-to-date information about overhead and how to allocate it equitably. It must describe each overhead cost center, which costs are allocable and which are not, and what allocation factors and data sources will be used to calculate the allocations. It must describe the decisions made and the rationale for those decisions. It must contain the calculations of overhead charges to each fund and department. Cities, counties and other local governments should update the plan annually.
b. Use factors that equitably allocate central overhead costs to each fund or department. Allocation factors are used to allocate overhead costs to departments and funds that benefit from overhead services. Different factors are necessary to equitably allocate the various overhead costs. For example, square footage is an appropriate factor to allocate maintenance and janitorial costs. The number of transactions is an appropriate factor to allocate accounting costs. Good allocation factors result in each fund and department paying only for the overhead services it received. Local governments must ensure that allocation factors are based on current and accurate information. If estimates or budgeted figures are used, governments should adjust them to actual at least annually. Exhibit 2 shows appropriate allocation factors for common types of overhead costs.
c. Allocate overhead to all benefitting funds and departments for overhead services received. If governments decide not to charge overhead to a particular fund or department, the general fund must absorb that fund or department’s share of the costs. Excluding a fund or department from the calculation results in overcharges to all remaining funds and departments. d. Ensure that general government costs or questionable costs that do not clearly benefit the utilities (or other funds with legally restricted revenues) are charged entirely to the general fund. The primary purpose of general government programs is to serve the public at large. Charging such costs to the utilities or other funds with restricted revenue sources that cannot pay for such expenses is questionable because they do not support these funds. The costs of such programs are typically paid for by the general fund.
2. Properly charge departments: a. Charge departments and funds only after overhead services are provided. Overhead allocation plans allow a government to forecast the amount of overhead it will charge each department in a given year. Although costs can be charged quarterly, monthly or more frequently, they must always be charged after services are rendered. If the general fund charges overhead costs before services are rendered, it has borrowed money from other funds, and interfund loan rules must be followed (BARS Manual 3.9.1, Loans).
b. Charge departments and funds only for actual costs. If local governments charge departments and funds based on estimated overhead costs, they should reconcile and adjust those estimates to actual costs at least once a year. Similarly, the administrative requirements, cost principles, and audit requirements located in2 CFR 200 – Uniform Guidance requires such reconciliation and adjustment if estimated overhead costs have been allocated to federal grants.
3. Maintain appropriate documentation to support what overhead costs were charged to each department and fund, the amount of the charge and how it was determined. State law (RCW 43.09.210) says that when one fund charges another for services provided, the receiving fund should pay the full value of the services. Governments cannot demonstrate compliance with this law unless they maintain documentation that shows (1) the cost of each overhead cost center, (2) the level of service each provided to benefitting funds and departments and how it was determined, and (3) the amount charged to each fund and department.
Exhibit 2 Sound allocation factors to equitably allocate overhead costs across multiple funds and departments
Type of costs
Factors used to calculate overhead costs
Maintenance and janitorial
Square footage
Electric and other externally provided utilities
Square footage
Accounting
Actual expenses or number of transactions
Budget
Actual expenses, budgeted expenses or number of staff (FTE) (a)
Payroll
Number of staff (FTE) or payroll warrants
Human resources
Number of staff (FTE)
IT services
Number of computers, servers, databases or ports (b)
Legal – indirect costs
Actual expenses or hours worked
Insurance
Number of staff (FTE), claims or loss history, square footage, property values insured, and risk factor
Accounts payable
Number of transactions (including vouchers or invoices)
Purchasing
Number of transactions (procurements)
Notes: If local governments are allocating other overhead costs not shown above, they must choose allocation factors that result in allocations that are fair, equitable and reflect the cost of services actually received by the benefiting funds. (a) Using actual expenses, budgeted expenses, the number of staff – or a combination of the three – can all result in fair and equitable allocations. Governments must document why the approach they selected results in fair and equitable allocations that best reflect the cost of services actually received by the benefiting funds. (b) Ports alone may not be the best basis for organizations that have moved to a wireless network model.
4.1.2.10 Pursuant to RCW43.09.230, Annual Reports are to be certified and filed with the State Auditor’s Office within 150 days after the close of each fiscal year.
4.1.2.20 The legal reporting requirements prescribed by the State Auditor’s Office for local governments in Washington State are consistent with the national standards of financial reporting prescribed by the GASB. These requirements for GAAP local governments are as follows:
Basic Financial Statements, including notes to financial statements.
Required Supplementary Information (including MD&A)
Supplemental Schedules
4.1.2.30 For the basic financial statements, the local government needs to prepare worksheets to summarize the general ledger trial balances, the resources and the expenditures schedules at the required account level. Most of these worksheets do not need to be submitted as part of the annual report, but they must be available for audit. The matrixes in BARS Manual 4.1.4, Summary of Reporting Requirementsidentify the statutory reporting requirements for GAAP local governments.
4.1.2.35 Local governments are required to update the materially incorrect financial statements. The requirement applies to all errors found prior or during an audit.
4.1.2.40 If a local government elects to prepare the Annual Comprehensive Financial Report (ACFR), it will have to produce additional schedules and statements that are NOT described in this Manual. However, the statements and schedules required for BARS reporting can be placed directly in the ACFR, and nearly all of the additional financial requirements of the ACFR are readily met by formally preparing the data used to satisfy BARS requirements. No duplication of effort is necessary to produce the ACFR from BARS reports. For additional information on preparation of a ACFR see BARS Manual 4.9, GFOA Financial Reporting Recognition Programs.
4.1.2.45 The Department of Health (DOH) Accounting and Reporting Manual for Hospitals, which contains uniform accounting, budgeting and reporting for licensed hospitals in the state of Washington, is available from the DOH Office of Hospital and Patient Data Systems at (360) 236-4210 or from the Department’s website. The requirements in this Manual do not substitute the reporting requirements contained in the Department of Health (DOH) Accounting and Reporting Manual for Hospitals.
Filing instructions
4.1.2.50 Electronic reporting is encouraged when filing annual reports. Annual reports should be submitted via the Online Filing option on the State Auditor’s website at: www.sao.wa.gov. Acceptable file should adhere to the prescribed record layout and should be an Excel file. It should include column headings. All columns must be formatted as text except the Actual Amount column which is numeric. More details are provided on the website.
For questions and/or support, please use the HelpDesk through our Online Services.
If the local government cannot provide the annual report in the electronic format mail the annual report to:
Annual Report State Auditor’s Office Local Government Support Team PO Box 40031 Olympia, WA 98504-0031
Certification
Prepare the certification and sign and date the certification before submitting the report.
Annual Report Disclosure Form
MCAG No. _______
(City/County/District)
(This form is not required if you are submitting your annual report electronically.)
Please check if the statements/schedules are attached. Use the column which is appropriate for your government type. If Schedule 17 is not applicable mark the spot NA (not applicable). An unmarked spot in your government type column will indicate that a schedule is not attached due to lack of activities described in this schedule in reported year.
Checklist Footnotes
[1] Local governments with no financial activity, defined as having neither expenditures, other than small automatic bank fees (such as dormant account fees) and the state auditor’s office audit billings, nor revenues other than interest income on any cash balances, have the option to submit summarized annual reports. These governments need to submit a Schedule 01 reporting cash balances at the beginning and end of the reporting year as well as any investment income received on those balances if applicable. These governments also will be required to submit no activity supporting documents such as meeting minutes and county reports and/or bank statements verifying no activity. Note that by selecting this submission option, preparers of the annual reports are certifying that their government meets the definition of no activity as explained above.
[3] Only cities and special purpose districts with revenue usually less than $300,000 are required to prepare this schedule. However, conservation districts, fire districts, transportation benefit districts, local/regional trauma care councils and industrial development corporations are required to prepare the Schedule regardless of the amount of revenue. However, no financial activity reports do not require a formal Schedule 22 to be submitted. Governments who file a no activity report will be required to submit supporting documents to confirm no activity, such as meeting minutes, county reports and/or bank statements.
512.52 New Code – This code is to be used when a municipal government contracts out their court services and should also be used by governments providing the court services to another municipality.
Added instructions and a new resource "Codes to Funds"
Added instructions for chart of accounts export. All codes from the Chart of Accounts as of November 30th are included in the resource with the allowable fund types indicated.
3.4.7 Intergovernmental and Forgivable Loans – Moved accounting for forgivable loans out of the Schedule 09 instructions and added information on intergovernmental loans.
3.5.1.40 – Added a definition and more examples for unearned revenue (Liability). 3.5.1.50 – Added additional examples for unearned revenue (deferred inflow) and deferred inflow unavailable revenues.
3.9.1.10 – Added when interfund loans could be used and requirements for interfund loans from the General Fund. 3.9.1.31 – Added information on negative fund balances and the accounting for those balances. 3.9.1.32 – Added information on when interfund payments become interfund loans.
3.10.5.60 – Changed capital leases to installment purchases 3.10.5.70 – Added leases to the obligations that do not constitute debt for debt limitation.
4.2.4 Added footnote 2 that the government should have a policy to address the assignment of revenues that could be classified under multiple functions.
4.3.7 Added determinations for Flexible Savings and Health Savings Accounts, both when a government controls the asset and when the government does not.
4.9 Removed the listing of requirements for the GFOA ACFR certificate. Created a link for accessing the official GFOA website and requirements for the certificate program.
Moved note template from the templates page to the notes section. Updates, changes, and clarifications for disclosing pensions made throughout (annual updates).
Fiscal year 2021 Pension and OPEB templates are available for download
Schedule 19 – Labor Relations
BARS Reporting Templates
Removed due to change in state law.
BARS Alerts
12/17/2021
Hot Topic - GAAP Proprietary Fund schedule 01 reporting: Proprietary funds reported in the SAO annual report must include the following: - Actual depreciation amounts reported in each proprietary fund (501XX) - Actual expense amounts for capital expenditures (594XX and 595XX) - Actual expense amounts for principal debt repayments (591XX, 593XX, 599XX)
12/17/2021
Leases accounting is effective for fiscal year 2022 reporting in 2023. See the Leases project page for more information.
12/17/2021
Annual update, see changes in table below
Overview of Changes – Applicable to the Reporting Year 2021
344.71 (Transits, Railroads and Other Transportation Systems Services)
344.71 New Code - Include private vanpool charges, streetcar and monorail fares, disabled/aging transportation fees, etc. For cities/counties: this code is not reported on the road/street report to WSDOT.
369.70 (Pension/OPEB Contributions) Should only be used for contributions made to a pension/OPEB plan administered by the reporting government. Not for use in the fiduciary funds.
395.30 New code - Use for any proceeds received for the sale of capital assets. Examples: real estate (land and buildings), equipment, street vacations, timber sales (timber owned by the municipality). Relatively insignificant proceeds from sales of capital assets should be coded as other revenue. If the money is further distributed to other local governments, such distributions should be coded 337 by these receiving governments.
For GAAP enterprise funds, see 372-373 for applicable coding.
395.40 (Compensation for Loss/Impairment of Capital Asset)
395.40 New code - Include insurance and other recoveries for damaged, destroyed, stolen, or lost governmental capital assets. If the recoveries meet the criteria of extraordinary items, they should be reported as such in the financial statements. Insurance recoveries that are related to storm cleanup and are realized, or are measurable and available, in the same year as the related cleanup expenditures should be netted against those expenditures. Insurance recoveries that are related to cleanup and are recognized in subsequent periods should be reported as other financing sources or extraordinary items, as appropriate. FEMA grants are not insurance recoveries and should be coded as direct/indirect federal grants.
For GAAP enterprise funds, see 372-373 for applicable coding.
547.10 (Transits, Railroads and Other Transportation Systems Services)
547.10 New Code - This account should be used only if the local government operates its own, or with other governments, transit, railroad or other transportation system. These expenditures are related to public transportation. For cities/counties: this code is not reported on the road/street report to WSDOT.
3.7.1 Changed title to Federal Awards to include all items that must be reported on the Expenditures of Federal Awards (Schedule 16). Updates, changes, and clarifications for reporting awards made throughout.
4.8.14.10 Added clarification that governments who file a no activity report will not be required to submit a formal Schedule 22, but will need to submit supporting documents.
Added Quick Links to specific guidance 4.14.5.70 Added additional information on COVID-19 Expenditures including donated personal protective equipment purchased with COVID-19 federal financial assistance, COVID 19 Vaccines - Immunization Cooperative Agreements CFDA #93.268, Provider Relief Fund (PRF) CFDA #93.498 4.14.5.155 Moved and retitled 4.14.5.230 to Preparing the preformatted SEFA template for upload to Online Filing 4.14.5.180 Added yellow flag caution under column 4 instructions. 4.14.5.230 Changed to example of finalized Schedule of Expenditures of Federal Awards.
348.00 (Internal Service Funds Sales and Services)
348.00 (Internal Service Funds Sales and Services) – Allowed only in internal service funds. Read more about the use of 348.00 and internal service funds in the audit connection blog, “BARS Code Spotlight".
541 (Roads/Streets Construction – Preservation Projects)
541 (Roads/Streets Construction – Preservation Projects) – This code is for modified approach to infrastructure. Allowed in all fund types except fiduciary and permanent.
GAAP Fund Balance and Net Position Codes – 308.20/508.20, 308.30/508.30, 308.40/508.40, 308.50/508.50, 308.90/508.90 – allowed only in governmental funds. 308.60/508.60, 308.19/508.19, 308.89/508.89 – allowed only in proprietary funds. Exception: 308.19/508.19 allowed in GAAP fiduciary funds.
Other Increases and Other Decreases in Fund Resources Removed BARS Codes 3821000, Refundable Deposits, 3822000, Retainage Deposits, and 5821000, Refund of Deposits, 5822000, Refund of Retainage Deposits. These should be reported as liability accounts for GAAP basis.
Fiduciary funds – Added a reference to the new Determining Fiduciary Activities to be Reported in Custodial Funds Fiduciary funds – Added a GASB 34, Paragraph 106 reference for capital assets reported in fiduciary funds
3.6.8.10 Changed "Programs must be approved by the behavioral health organization and the secretary of the Department of Social and Health Services" to "…secretary of the Department of Health" to match RCW 71.24.555
3.7.1 Updated references to Office of Management and Budget (OMB) Circulars 3.7.1.20 Included other federal financial assistance guidance 3.7.1.30 Removed reference to the American Recovery and Reinvestment Act (ARRA) 3.7.1.30 Added Identification of COVID-19 related awards requirements 3.7.1.41 Removed the Common Rule Administrative Requirements section 3.7.1.51 Removed the OMB Circular A-87 Cost Principals section
4.1.1.210 Clarified the definition of "financially accountable" 4.1.1.220 Clarified the reporting of component units Financial Reporting Entity Flowchart updated for determining fiduciary trust funds and defined compensation plans
Clarified requirements for reporting and calculations of the components of net position 4.2.8.10 Created a downloadable worksheet for converting governmental fund balances to net position
Removed this section from proprietary fund financial statement section and created a new section for the additional reporting requirements for risk pools.
Section number updated to 4.14.3 (from 4.8.3). 4.83.100 Updated information on reporting pension (264.30) and OPEB liabilities (264.40) 4.8.3.110 Updated the due date instructions to list I.D. Numbers that do not require a due date to be reported.
Section number updated to 4.14.5 (from 4.8.5). Annual update for SEFA requirements including updated notes and COVID-19/CARES Act reporting requirements.
The templates for the online filing schedules have been updated for Fiscal Year 2020 reporting. Schedule templates updated are: Schedule 01, Schedule 16, Schedule 16 Notes, Schedule 21
3952000, Compensation for Loss/Impairment of Capital Assets
3952000, Compensation for Loss/Impairment of Capital Assets Added the following information: Insurance recoveries that are related to storm cleanup and are realized, or are measurable and available, in the same year as the related cleanup expenditures should be netted against those expenditures. Insurance recoveries that are related to cleanup and are recognized in subsequent periods should be reported as other financing sources or extraordinary items, as appropriate.
3132700, Affordable and Supportive Housing Sales and Use Tax
3132700, Affordable and Supportive Housing Sales and Use Tax A new BARS code 3132700 was assigned to code the sales and use tax authroized by the SHB 1406, Laws of 2019.
BARS codes 5990000, Payments for Refunded Debt, these codes should be used for payments to an escrow agent for refunding debt payments and direct payments of refunded debt (e.g., BANs, refinancing or loans, etc.). Note this correlates to current refundings, advanced refundings utilize 5930000 codes.
Other Increases and Other Decreases in Fund Resources Added BARS Codes 3821000, Refundable Deposits, 3822000, Retainage Deposits, and 5821000, Refund of Deposits, 5822000, Refund of Retainage Deposits to be used for deposits that are not custodial activities. These codes are replacing 3891000, 5891000, 3892000, 5892000 which are no longer valid BARS codes.
3.1.3.10 Updated information about the "Green Book." 3.1.3.30 Added information that states the SAO is not part of the internal control functions of a government. 3.1.3.40 Updated the five components of internal controls. 3.1.3.90 Updated information about the different areas that should be reviewed for creating internal controls.
Removed "signed" in 3.6.620 b. which now says "A file must be maintained of those payers who have authorized to add moneys to your account electronically including the proceeds form third party vendors for credit card remittances."
Removed "signed" in 3.8.11.20 b. which now says "A file must be maintained of authorizations by payees who have therby agreed to have moneys added to their accounts electronically."
Added the fourth bullet in 3.8.11.30 which now says "Policies and procedures should be in place to validate these authorization to protect resources being transferred electronically."
Other Postemployment Benefit (OPEB) Plan Schedules, 4.7.340 - 4.7.410 - Updated the requirements to match GASB 74 and 75. Added links to the appropriate templates.
4.8.5.40 Removed reference to the fact that the SEFA must be prepared on the same basis of accounting since Uniform Guidance does not require the SEFA. 4.8.5.50 Removed references to CFDA 10.665: Title I - Schools and Roads, Title II - Special Projects on Federal Land, Title III - County Projects in the Direct costs of expenditure transactions associated with grants, cost-reimbursement contracts, cooperative agreements, and direct appropriations. 4.8.5.128 Revised the requirements for Disbursements to Subrecipients to "expended" rather than "paid." 4.8.5.130 Updated the exceptions for EPA Drinking Water State Revolving Fund (CFDA 66.468) and Clean Water State Revolving Fund (CFDA 66.458). 4.8.5.230 Removed Note 8 American Recovery and Reinvestment Act (ARRA) of 2009 from the SEFA Notes Template.
New account for revenues for Medicaid payments related to an implementation of the Transformation Plans. The addition was communicated on August 1, 2018 in BARS Alert
The account was divided between internal and external legal services. Within each category were created more separate accounts for different specific legal expenditures. The change will allow governments to analyze and compare costs much more effectively. This also aligns accounting records with procedures auditors are required by professional standards to perform an audit on legal liabilities, so it will help make the audit process more efficient. This change was already announced in 2016 and was not required for the FY 2017 reports; however, the new accounts will be required for 2018 reporting.
Object code 50 was removed and the definitions of object codes 30 and 40 adjusted to include the transactions which were previously reported using object 50. For other details see BARS Alert issued August 1, 2018.
GASB Statement 84, Fiduciary Activities – the Statement is effective for reporting periods beginning after December 15, 2018; however we incorporated the required changes in this version of manual. The additional information will be available on our website under Fiduciary Funds in BARS manual.
Also, updated was the discussion of enterprise [400] funds. There are no new reporting requirements and the update expands the current prescription.
The update incorporates the changes to RCW 36.32.210 which removed the annual inventory requirement. The change was communicated on March 21, 2018 in BARS Alert.
Removed requirement to capitalize interests during construction. This is an early implementation of GASBS 89, Accounting for Interest Cost Incurred before the End of Construction Period which is applicable for reporting periods beginning after December 15, 2019.
Added GASBS 86, Certain Debt Extinguishment Issues update regarding accounting and reporting when the debt is refunded with the government’s own resources.
Removed requirement to capitalize interests during construction. This is an early implementation of GASBS 89, Accounting for Interest Cost Incurred before the End of Construction Period which is applicable for reporting periods beginning after December 15, 2019.
New section was added regarding Equipment Rental and Revolving (ER&R) Fund. This guidance was previously available outside the BARS manual and it is now incorporated into the manual allowing an easy access.
Added a new section to provide a general overview of interfund transactions.
REPORTING
GASB Statement 84, Fiduciary Activities – the statement is effective for reporting periods beginning after December 15, 2018; however we incorporated the required changes in this version of manual. The following sections were updated: 4.1.1.150 (removed due to the changes in reporting requirements for custodial funds and their impact on financial reports); 4.1.4.20, 4.3.1.40, 4.3.2.70, 4.8.3.50, and 4.9.140. These changes involved only a title change from the agency to custodial funds.
The most significant change involves changes in financial reporting and these are incorporated into 4.3.5, Fiduciary Funds Financial Statements.
Removed requirement to capitalize interests during construction. This is an early implementation of GASBS 89, Accounting for Interest Cost Incurred before the End of Construction Period which is applicable for reporting periods beginning after December 15, 2019.
Removed requirement to capitalize interests during construction. This is an early implementation of GASBS 89, Accounting for Interest Cost Incurred before the End of Construction Period which is applicable for reporting periods beginning after December 15, 2019.
Removed requirement to capitalize interests during construction. This is an early implementation of GASBS 89, Accounting for Interest Cost Incurred before the End of Construction Period which is applicable for reporting periods beginning after December 15, 2019.
Added reporting requirements of GASBS 88, Certain Disclosures Related to Debt, Including Direct Borrowings and Direct Placements. This Statement is applicable for reporting periods beginning after June 15, 2018.
Added link to the WA State Department of Revenue page containing information regarding state’s abatements. This update was communicated on March 7, 2018 in the BARS Alert.
Clarified that the governments should be reporting both short- and long-term liabilities on the Schedule. Also added new ID. Numbers for registered warrants and lines of credits.
Revision reflect the clarification for reporting federal grants provided by federal agencies.
Remove discussion of ARRA grants.
The example of reporting FEMA grants was updated.
Updated for changes related to reporting the following grants: EPA Drinking Water (CFDA 66.468), Clean Water (CFDA 66.458), USDA Interim Financing (CFDA10.760) and (CFDA 10.766).
Revised rules for reporting grants with missing CFDA numbers.
The Schedule was revised to provide relevant information needed in assessing and auditing governments’ risk management circumstances.
ONLINE FILING
Schedule 09
The Schedule 09, Schedule of Liabilities, includes a new validation check for net pension liabilities. Governments will receive a red flag if they have pension related liabilities but do not report them on the Schedule 09 or if they are using the incorrect ID No.
