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

PROPERTY TAX SHIFT |  |  |  |  | n/a | n/a | n/a | n/a | n/a | n/a | n/a |  | coulumn left blank intentionally | 2014 | Pay 2014 | 13 Pay 14 | FY 2015
n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a |  | rest of coulumn left blank intentionally | Pay 2013 | 12 Pay 13 | FY 2014 | 06/30/14 | 07/01/2013 to 06/30/2014
n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a |  |  | Pay 2012 | rest of column left blank intentionally | FY 2013 | 06/30/13 | 07/01/2013 to 04/30/2014
n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a |  |  | Pay 2011 |  | rest of column left blank intentionally | rest of column left blank intentionally | 05/01/2014 to 06/30/2014
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pay 2010 |  |  |  | rest of column left blank intentionally
n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a |  | n/a | Pay 2009
n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a |  | n/a | Pay 2008
Notes: |  | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a |  | n/a | Pay 2007
line left blank intentionally
line left blank intentionally
line left blank intentionally
line left blank intentionally
Early Recognition Levies |  |  |  | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a
Certain levies have been--and will continue to be--shifted 100% with no aid reduction.  Recognizing these levies early gets the revenue into the same fiscal year as the related expenditures.  There is no state aid adjustment for this portion of the shift.
line left blank intentionally
Other Levies |  |  | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a
Starting in fiscal year 2004, the shift was expanded to include all other general and community service fund levies, net of tax credits.  There is a corresponding state aid adjustment for this portion of the property tax shift, making this portion of the shift revenue neutral to school districts each year.  If the shift at the end of the current year is larger than the shift at the end of the previous year, state aid for the current year is reduced for the net increase in the shift.  If the shift at the end of the current year is less than the shift at the end of the previous year, state aid for the current year is increased for the net decrease in the shift.
line left blank intentionally
Starting in fiscal year 2006, the shift percentage for other levies was set to zero percent.
Starting in fiscal year 2011, the shift percentage for other levies was set to 48.6 percent, and based on gross levies (before subtraction of credits).
Starting in fiscal year 2014, the shift percentage for other levies was again set to zero percent.
line left blank intentionally
The "Reports" tab shows the property tax shift report for a selected school district. |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a | n/a
 | To select a specific district, type the district number in cell [NAME]  (use 1.2 for Minneapolis) and press enter.  Information for the selected district will then appear in the report.  Running a macro is not required.
line left blank intentionally
n/a | The first section shows the property tax shift report for the school district, with a definition for each tax shift category. |  |  |  |  |  |  |  |  | n/a | n/a | n/a
n/a | n/a |  |  |  |  |  |  | n/a | n/a | n/a | n/a | n/a
n/a | n/a |  |  |  |  |  |  | n/a | n/a | n/a | n/a | n/a
n/a | n/a | Column 3 is the revenue change to be recognized as a result of the levies shifted with with no aid reduction (net of column 1 and column 2 for these categories).
n/a | n/a | Column 4 is the net shift amount to be recognized as a result of levies shifted with an aid reduction.  A negative amount in this column represents a debit balance in source 020 and related crebit balance in source 299.
line left blank intentionally
n/a | n/a | Column 5 is the state aid payment (reduction) that is being made in the current year for the property tax shift.
n/a | n/a | Column 6 represents the state aid payment (reduction) that will be made next year, for this year's tax shift.  Column 4 plus column 5 plus column 6 should equal zero.
line left blank intentionally
n/a | The second section discusses the assumptions that have been made in generating the entries to record the tax shift.  Also review the Accounts tab and Entries tab.
line left blank intentionally
n/a
line left blank intentionally
n/a
line left blank intentionally
Enter data on the Funds tab if you want to use the reconciliation feature in the Accounts tab. |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a | n/a
n/a
line left blank intentionally
n/a
line left blank intentionally
The Accounts tab provides a year-end reconciliation for each tax-related account. |  |  |  |  |  |  | n/a | n/a | n/a | n/a | n/a | n/a
n/a | This section shows how to determine the balance to be reflected in each account at year-end after all tax entries (including the property tax shift entries) have been made.  Balance sheet accounts are listed first and then revenue source codes.  Also shown is the source document where the data for each step of the reconcilation can be obtained.
line left blank intentionally
 | This tab can serve as a year-end reconcilation tool.  Enter data in the highlighted fields on this tab and in the Funds tab.  All other fields in this tab will automatically be computed.
line left blank intentionally
The Entries tab shows standard accounting entries for recording property taxes.
n/a | The entries start with the levy being certified by the school board and work through a full year of accounting entries.
line left blank intentionally
The other tabs in this spreadsheet provide the data that is used to create the tax shift report shown in the Reports tab. |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a
line left blank intentionally
If you have questions about the property tax shift or about using  this spreadsheet, contact [NAME] by phone at [PHONE] or by e-mail at [EMAIL].
End of worksheet