LHT banner graphic,Too
Preserving the Legacy of 2000-2003

Analysis of Uncollectible Reserve

This is one of a series of educational webpages intended to educate the public about some of the more complex aspects of the municipal budget.

Once we settle on an expense budget, we have to be absolutely certain we collect enough in taxes to cover those expenses.  But some property owners will not pay their taxes, or won't pay them on time.  If some don't pay, then the town's checkbook will come up short at the end of the year.

The way we make certain to collect enough to cover expenses is to tax the honest taxpayers a little more than their fair share.  We measure the Collection Ratio, and in Long Hill it is generally over 98%.  That means the uncollectible rate is 2%.  Then we ask the honest taxpayers to cover the 2% shortage.  That means we have to inflate the tax rate for EVERYBODY by 2% before the tax bills are mailed.

The mechanism we use is to artificially increase expenses and thus artificially increase the tax rate for everybody.  This fictitious expense account is called the Reserve for Uncollectibles.  It isn't really an expense. It's just a fudge factor added on top of the REAL expenses, to increase taxes for the honest taxpayers and thus cover the shortfall that will be created by the "deadbeats".

Currently, our TOTAL annual tax collection in Long Hill (including collecting taxes for the schools and the county) is about $30,000,000, and the Reserve for Uncollectibles is about 2% of that, or about $600,000.

Then what happens?

  • Some taxpayers, who we didn't expect to pay, actually DO pay.  This means the Collection Ratio is greater than expected, and it means we overestimated the amount the honest taxpayers had to cover.  Since the expense budget was already approved, and we fudged in enough "Reserve" to cover all the expenses, these unexpected tax payments are gravy.  And since the expense budget was already approved and the expected shortfall has been covered by the Reserve, we don't have any place to spend this unanticipated tax revenue.  So we put it in the bank, in a separate account we call "Surplus".
  • Other taxpayers, who didn't pay LAST YEAR (or the years before that), decide to get caught up.  Maybe they hit the Lottery or they got a better job.  Maybe they sell their house, and the town gets first crack at the money the buyer pays, because the town holds a Tax Lien for the past due tax amount.  Since we already balanced the books in the prior year, and closed those books, then this money obviously can't be spent in the prior year, and isn't needed to cover expenses in the current year.  So again, we deposit it into the "Surplus" account.
  • Some tax bills have to be cancelled.  Perhaps the property is bought by the Great Swamp Wildlife Refuge, after the tax bills are issued.  The federal government does not pay local taxes, so that tax collection is lost.  Or perhaps the owner is successful in appealing his assessment.  We must restate his tax bill downward, and again, we must cancel the difference.
  • Finally, there are a few who never pay.  We never give up, but we might have to foreclose, then sell the property in order to recover the back taxes.  If the property is undevelopable wetland, foreclosure and resale may not be practical, either.

Now back to the Uncollectible Reserve.

Every year, we inflate the budget by about $600,000 to create the Uncollectible Reserve.  The exact amount is determined by state formula and by prudent financial judgment.  Some years, the Tax Collection ratio is better than expected.  Some years, it is MUCH better.  Some years, the back taxes come in strong, other years, they don't.

All the unexpected tax payments that come in are put into Surplus.  Then, at the beginning of the NEXT budget cycle, we take that money out of Surplus and use it to "seed" the revenue side of our budget.  In other words, the Surplus we accumulate this year goes toward meeting the NEXT budget's revenue requirement, and thus reducing taxes NEXT year.  And the cycle repeats itself.

We can never be sure how much money will be at stake in any given year, but AVERAGED OVER THE PAST SIX YEARS, 90% of the money that the honest taxpayers have chipped into the Uncollectible Reserve has come back to them the following year by flushing the late tax paymrnts out Surplus.  Specifically, over the past six years, the sum total of uncollected taxes that were NEVER (or at least, not yet) recovered totalled $305,000, or an average of $50,000 per year.

That means that the PERMANENT Uncollectible Rate is less than 10% of the annual Uncollectible Reserve (2%). The other 90% of the anticipated Uncollectible Reserve IS recaptured, and IS credited to our wallets the following year.  ON AVERAGE.  That works out to a NET Uncollectible Ratio of less than 2/10 of 1%, which isn't bad for any business.

If you want to follow the math involved, you can see it all worked out in the table below.

  • At line "B", note that the Actual Collection Ratio gets a little better every year.
  • At line "E" and "E2", note that Collection Ratio used to set the Uncollectible Reserve in the budget ALSO gets better every year, and is conservatively about 3/4 of 1% lower than the actual experience.  Not that it matters, since we "get the money back" out of Surplus in the next budget year.
  • At line "C", note that the total taxes billed has increased by 50% over the six year period, while the Uncollectible Reserve (line "D") is consistently budgetted at a constant level of about $600,000.  This is possible because the Collection Ratio improves every year.  But we know it won't get too much better, because it can't possibly go over 100%.
  2000 2001 2002 2003 2004 2005 Avg 2000-2005 2006 2006+/-
A 2310200 Reported Actual Tax Collection - current year $19,965,680 $21,184,007 $23,040,676 $24,496,823 $26,712,855 $28,776,789      
B pg 39 Reported actual Collection rate 97.98% 97.85% 97.94% 98.21% 98.29% 98.59%      
    We ratchet up the actual current-year tax collection to determine the total taxes billed (A/B). NOTE: This is imprecise because the ACTUAL taxes collected includes taxes on new assessments which were not known at the time the budget was prepared and the original TAX RATE was computed. The Apparent Total Taxes Billed (and Collected !) will be HIGHER than the sum of the component tax levies known as of July. But both those windfall amounts cancel out in the "Reported Actual Collection Rate (line B).      
C   Apparent Total Taxes Billed $20,377,301 $21,649,471 $23,525,297 $24,943,308 $27,177,592 $29,188,345      
D 50-899 Reserve for uncoll $667,197 $642,000 $665,000 $676,000 $568,000 $633,000 $641,866.17 $610,000 -$31,866.17
    The apparent budgeted collection rate is the ratio of the "budgetted uncollectible reserve" to the Total Taxes Billed. (1-D/C) This calculation is imprecise, because we are doing it after-the-fact, based on ACTUALS. In fact, when uncollectible reserve is first computed in February, NONE of the actual TAX LEVIES (muni, school, county) are actually known - and the windfall assessments are not known. So they probably apply a "round" factor (ex: 98%) to some estimated growth from the previous year. I can't know the exact factors used in the estimate (at the time), but these "apparent" factors are probably good enough. This factor is NOT used in later calculations.      
E   Apparent budgeted collection rate (1-D/C) 96.73% 97.03% 97.17% 97.29% 97.91% 97.83%      
E2   Budget Overestimate of the true uncoll factor (B-E) 1.25% 0.82% 0.77% 0.92% 0.38% 0.76% 0.82%    
F   Actual uncollectible - current year (C-A) $411,621 $465,464 $484,621 $446,485 $464,737 $411,556 $447,413.99    
    "Excess Tax Collection" is the amount of the budgetted Uncollectible Reserve that was actually collected in the current year. It goes into surplus, because there is nowhere to spend it (I.e. the expense budget is frozen to match the revenue BUDGET). This includes windfalls and the effect of underestimating the collection rate.      
G   "Excess Tax Collection" - to surplus (D-F) $255,576 $176,536 $180,379 $229,515 $103,263 $221,444 $194,452.18    
H 15-499 Back Taxes Collected Budget $285,000 $340,000 $340,000 $340,000 $360,000 $360,000 $337,500.00 $360,000 $22,500.00
I   Back Taxes Collected Actual $315,093 $362,214 $493,513 $433,124 $382,914 $391,967 $396,470.83    
J   +/- $30,093 $22,214 $153,513 $93,124 $22,914 $31,967 $58,970.83    
K   Total to surplus (G+I) $570,669 $538,750 $673,892 $662,639 $486,177 $613,411 $590,923.01    
    "Net Uncollected" is the amount of Back Taxes Collected (line I) to partially offset the amount of Current Year Actual Uncollected (line F). Admittedly, it is an apples and oranges calculation. But over a period of years, it shows the amount of tax money "permanently lost". This money is the ACTUAL cost (of the deadbeats) to the law-abiding taxpayers The "windfall collected" current taxes & the back taxes flows from surplus into revenue in a later year, and thus reduces taxes in that later year. The "permanently lost" taxes are the only amount that the taxpayers actually must make up sooner or later. Note that this is MUCH smaller than the annual Uncollectible Reserve (line D). The accounting system makes it seem worse than it really is. 6 year Cumulative "Lost Taxes"    
L   Net uncollected (F-I) $96,528 $103,250 -$8,892 $13,361 $81,823 $19,589 $305,659    
The mouseover pop-ups can not be printed directly.  For convenience, the contents of these pop-ups are repeated below.
"2001 Breakeven Rates"

The reassessment of 2001 increased the TOTAL Assessment of Long Hill by a factor of 2.24 times.
  • REASSESSMENT does not change the BUDGETS, and it does not change the total TAX DOLLARS that are collected.
  • When the total ASSESSMENTS go up, the TAX RATES go down by the same factor.
This column "adjusts" each of the 2001 tax rates to a theoretical or breakeven rate that would keep the total TAX COLLECTION (for 2001) constant, IF the new assessments had been in effect for the 2001 tax collection.  This "restatement" of the 2001 TAX RATES is only presented as a base for comparison of the 2002 TAX RATES.
"Township Tax Rate"

Township tax rate computed from the 2002 Budget introduced at the Township Committee meeting on March 13, 2002 and adopted by the Committee on July 10, 2001.
"Township Open Space Tax Rate"

Township Open Space Tax was adopted by public referendum in 1997, and was specified as $.02 per $100 of Assessed Valuation.  Due to computer rounding, it may be on the tax bills as $.021.
"Morris County Tax Rate"

Adopted by the county Freeholders on March 13, 2002.
"Morris County Open Space Tax Rate"

This rate was enacted by the county Freeholders on January 9, 2002.  The County Open Space Tax was raised by public referendum in November 2001, and was approved as up to $.06 per $100 of Assessed Valuation.
"School District Tax Rates"

Approved by voters at the School Elections on April 16, 2002.
"Total Tax Rate"

Tentative, pending final approval of the Township Budgets.

Return
Please send comments to the webmaster from this or any other page.
This is not an official government website.  © 2003-2012