Spreadsheet: 8ad43ea5-8f2c-4042-824b-a0f9534971e9
Sheet: Report

 |  |  | PROPERTY TAX SHIFT YEAR-END RECONCILIATION |  |  |  |  | 2014-07-08 00:00:00
1 | Enter District Number
 |  | 1 | 2 | 3 | 4 |  | 5 | 6
 |  |  |  |  |  |  | State Aid Adjustment Src Code 299 | Revenue Adjustment Src Code 299
A | General - Shift & Adjust Aid
B | General - Operating Referendum (with aid adjust)
C | General - Operating Referendum (no aid adjust)
D | General - Addl Referendum Shift
E | General - Career Technical
F | General - 100% Shift, No Adjust
G | General - Reemploy Ins (Reserved)
H | General - Reemploy Ins (Unreserved)
I | General - Legislative Changes
J | General Fund Total
K | Comm Serv - Shift & Adjust Aid
L | Comm Serv - 100% Shift, No Adjust | 0 | 0
M | Comm Serv - Legislative Change
N | Comm Serv Fund Total
O | Total
Definitions of levy categories within funds
The following categories are mutually exclusive, that is, each levy appears in one category only.
 | Shift & Adjust Aid
 | Operating referendum (with aid adjust)
 | Operating referendum (no aid adjust) | This category is the Pay 2001 referendum [NAME] shifted at 31%.  This amount will be constant from year to year.
 | Addl referendum shift | This is an additional revenue shift for districts that had a decrease in Pay 1994 referendum levy
 |  | due to the net of changes in the allocation of HACA and the increase in referendum equalization aid.
 |  | This amount will be constant from year to year.
 | Career Technical | Career technical levy and adjustment shifted at 100% with no aid adjustment.
 | 100% shift, no adjust | Includes levies that are shifted at 100% and for which there is no reduction to state aid.  This category
 |  | includes integration for first class districts, additional retirement, health benefits, and related adjustments.
 | [NAME] (reserved) | Includes reemployment insurance levy adjustments for FY 2003 shifted at 100% with no aid adjustment.
 | [NAME] (unreserved) | Includes reemployment insurance levy and adjustments for FY 2004 and later shifted at 100% with no aid adjustment.
 | Legislative changes | Includes selected levies that have been adjusted based on legislation that changes a levy authority after the levy has
 |  | been certified (See Minnesota Statutes, section 126C.48, subdivision 6).  The revenue shift is at 100% and there is
ASSUMPTIONS:
1) | Property Taxes for Subsequent Years (GNL 235) entries have already taken place.  Prior to the tax shift entries the balance
2)
 | have been coded to 214 to zero out the account.  If not, the following entry should be made:
 |  |  |  | Debit | Credit
REV | 01-005-000-000-211-000 | [NAME]
REV | 04-005-000-000-211-000 | [NAME]
GNL | 01-214 | Adv of Unearned [NAME]
GNL | 04-214 | Adv of Unearned [NAME]
3)
 | If not, the following entries should be made:
 |  |  |  | Debit | Credit
REV | 01-005-000-000-299-000 | Prop Tax Shift Adjustment
REV | 04-005-000-000-299-000 | Prop Tax Shift Adjustment
REV | 01-005-000-XXX-XXX-000 | State Aid Receivable or State Aid Revenue
REV | 04-005-000-XXX-XXX-000 | State Aid Receivable or State Aid Revenue
 |  |  |  | General Fund | Comm Service Fund
 |  |  |  |  |  |  | Note:  District should override when actual data is available
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 | Mobile Home Taxes |  |  | 0 | 0
 | Total May/June/July Tax Settlement Receipts
 |  |  |  | Debit (Credit) | Credit (Debit)
GNL | 01-235 | Prop Tax Sub Years
 | 01-214 | Adv of Unearned [NAME]
GNL | 04-235 | Prop Tax Sub Years
 | 04-214 | Adv of Unearned [NAME]
line left blank intentionally
REV | 01-005-000-000-001-000 | Local Property Taxes--Reemployment
REV | 01-005-000-830-001-000 | Local Property Taxes--Career Technical
REV | 01-005-000-830-211-000 (if not enough tax receipts) | [NAME]--Career Technical
REV | 01-005-000-000-001-000 | Local Property Taxes
REV | 01-005-000-000-211-000 (if not enough tax receipts) | [NAME]
REV | 04-005-000-XXX-001-000 | Local Property Taxes
REV | 04-005-000-XXX-211-000 | [NAME]
line left blank intentionally
REV | 01-005-000-000-211-000 | [NAME] |  |  |  |  | Entry to GNL 214 minus entries to SRC 211
REV | 01-005-000-000-296-000 | Property Tax Shift Offset Adjustment
REV | 04-005-000-000-211-000 | [NAME] |  |  |  |  | Entry toGNL 214 minus entries to SRC 211
REV | 04-005-000-000-296-000 | Property Tax Shift Offset Adjustment
 | (adjustment to balance GNL 214 account with SRC 211)
line left blank intentionally
REV | 01-005-000-000-001-000 | Local Property Taxes
REV | 04-005-000-XXX-001-000 | Local Property Taxes
 | (reverse prior year shift)
line left blank intentionally
REV | 01-005-000-000-020-000 | Prop Tax Shift Revenue
REV | 04-005-000-000-020-000 | Prop Tax Shift Revenue
line left blank intentionally
 | Total
line left blank intentionally
REV | 01-005-000-000-299-000 | State Aid Adjustment for Shift
GNL | 01-101 | Cash
REV | 04-005-000-000-299-000 | State Aid Adjustment for Shift
GNL | 04-101 | Cash
GNL | 01-213 | Property Tax Shift Adjustment
GNL | 01-101 | Cash
 | (modification by fund to correct (increase or decrease) property tax shift adjustment and redistribution of prior adjustment per Ideas report)
line left blank intentionally
 | Total
End of worksheet