Spreadsheet: 004b25a5-77c3-4e08-b8da-20bc4db4f615
Sheet: Funds

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