Spreadsheet: 330e1a29-e1cb-4481-a2af-b7305c0c7738
Sheet: Funds

Enter certified levies for each year below
This data is used to report certified levies on Accounts tab
Also used to allocate adjustments and abatements on Accounts tab
 |  |  | Certified Levy
 | General |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Community Serv |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Debt Service |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | OPEB |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total Certified Levy
Enter data in green highlighted cells
If more columns are needed, insert between column M and S
Amounts will be allocated to funds based upon certified levies above
Settlements will be totaled by year and fund for carryover to Accounts tab
If settlement sheet from the county already shows settlements by fund:
Unprotect this tab and enter settlement data directly into cells [NAME] through S145, orange outlined section below
Caution:  You will be overriding the formulas in these cells
 |  |  |  | County | County | County | County | County | County | County | County | County | County | County | County | County | County | County
 |  |  | Total | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date
Taxes receivable |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Fiscal disparities |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Taconite homestead |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Miscellaneous taxes |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total settlement
Current Taxes receivable
 |  | General
 |  | Comm Serv
 |  | Debt Serv
 |  | OPEB
 |  | Subtotal
Delinquent Taxes receivable
 |  | General
 |  | General
 |  | General
 |  | General
 |  | General
 |  | General
 |  | General
 |  | Subtotal
 |  | Comm Serv
 |  | Comm Serv
 |  | Comm Serv
 |  | Comm Serv
 |  | Comm Serv
 |  | Comm Serv
 |  | Comm Serv
 |  | Subtotal
 |  | Debt Serv
 |  | Debt Serv
 |  | Debt Serv
 |  | Debt Serv
 |  | Debt Serv
 |  | Debt Serv
 |  | Debt Serv
 |  | Subtotal
 |  | OPEB
 |  | OPEB
 |  | OPEB
 |  | OPEB
 |  | OPEB
 |  | OPEB
 |  | OPEB
 |  | Subtotal
Fiscal disparities
 |  | General
 |  | Comm Serv
 |  | Debt Serv
 |  | OPEB
 |  | Subtotal
Fiscal disparities
 |  | General
 |  | Comm Serv
 |  | Debt Serv
 |  | OPEB
 |  | Subtotal
Taconite homestead credit
 |  | General
 |  | Comm Serv
 |  | Debt Serv
 |  | OPEB
 |  | Subtotal
Taconite homestead credit
 |  | General
 |  | Comm Serv
 |  | Debt Serv
 |  | OPEB
 |  | Subtotal
Miscellaneous taxes
 | Total settlement