HomeMy WebLinkAbout6.g. Budget Amendments � CITY OF ROSEMOUNT
EXECUTIVE SUMMARY FOR ACTION
CITY COUNCIL MEETING DATE: December 21, 1999
AGENDA ITEM: Budget Amendments AGENDA SECTION:
Consent
PREPARED BY: Jeff May, Finance Director AGENDA
. . '�� �'� �
ATTACHMENTS: APPROVED BY:
Council Memo, Resolution, Donation Worksheets �
This item is on the agenda for Council to formally amend the 1999 General Fund budget by
resolution for donation items that Council has previously authorized, covering expenditures made
during the fourth quarter of 1999.
Rather than bringing a resolution before the Council each time there is a need to spend money from
donations previously received, we have developed procedures that allow us to have you authorize
the expenditure and amend the budgets at the time the expenditure is made and then periodically
bring to you a resolution that formally amends the budgets for a number of these donation
expenditures. The attached memo and donation worksheets support the figures given in the
resolution.
RECOMMENDED ACTION:
Motion to adopt A RESOLUTION APPROVING THE AMENDMENT OF CERTAIN 1999 BUDGET
ITEMS for the General Fund as outlined in the attached memo.
COUNCIL ACTION:
MEMORANDUM
DATE: December 16, 1999
TO: Mayor Busho
Council Members Caspar, Cisewski, Edwards & Klassen
FROM: Jeff May, Finance Director
SUBJECT: Budget Amendments
This is a request to amend both the revenue and expenditure budgets for the General
Fund and to formally approve the expenditures of donations previously received. This
memo is to show the line by line detail of the actuat changes to be made to the budgets,
of which the totals are summarized in the Resolution before you.
GENERAL FUND DETAIL
Detail for Revenues:
101-36230-00-000 (Donations) $33,976.20
Total Revenues $33,976.20
Detail for Expenditures:
101-41110-01-439 (Other Miscellaneous Charges) $ 6,293.71
101-45100-01-439 (Other Miscellaneous Charges) 27,682.49
Total Expenditures $33,976.20
CITY OF ROSEMOUNT
DAKOTA COUNTY, MINNESOTA
RESOLUTION 1999 -
A RESOLUTION APPROVING THE AMENDMENT OF
CERTAIN 1999 BUDGET ITEMS
WHEREAS, the City Council recognizes the need to amend certain items from the 1999
General Fund Operating Budget, the totals which are as follows:
(1) General operating revenues, the total which reflects an increase of$33,976.20;
(2) General operating expenditures, the total which reflects an increase of
$33,976.20;
NOW, THEREFORE, BE IT RESOLVED, that the City Council of the City of Rosemount
hereby approves the amendment of the above listed budget items for the 1999 General
Fund Operating Budget.
ADOPTED this 21 st day of December, 1999.
Cathy Busho, Mayor
ATTEST:
Susan M. Walsh, City Clerk
Motion by: Seconded by:
Voted in favor:
Voted Against:
DONATION REVENUE WORKSHEET
RECE T OF DONATION
Donation Received on: � �� � . �
� . . : Ainount Received: � � � ���� �� .
` Receipt # for ponation:
. Purpose of Donation: � �`
Account # for ponation: �`�� � � °� �' �'��
(Must be Liability # assigned for each individual Department) .
EXPENDITURE OF DONATION
�,
Amount to be Spent: $ ���
To be Spent from Acct #co�.fZ( S ondi g to ind d�ual Department)
(Must be Expenditure # �
Purpose of Expenditure: c ��'��- �
� AMENDMENT OF BUDGETS � �� '
. � f �— .
mend Donation Revenue Acct #101-36230-00-000 : $ I� � —
A �---
Amend Expenditure Acct ���� — `�1 l 1 o DI--�3�= $ � � `
(The two dollar amounts should be the same)
GENER.AL JOURNAL ENTRY TO ADJUST DONATION LIABILIT� �
Debit: �t7�� -- a��•�� (Donation Liability #) $ ��• �_
'" $ . �� � .
Credit: 101-36230-00-000
� • � � Journal entry �to.reduce deferred donation revenue .and -increase
. t�-� -- q
donation revenue to actual per council action on
,
DONATION REVENUE WORKSAEET
RECEI OF DONATION � .
Donation Received on: �r � �� � � .
.--, .
� Amount .Received: � $��s
Receipt # for ponation: ��2.
Purpose of Donation: ���lD �``'� , �`r
Account # for ponation: ��l'—��� aS'
� (Must be Liability # assigned for each individual Department)
EXPENDITURE OF DONATION
,�.
Amount to be Spent: $ ��
� To be Spent f rom Acct #� ��D � �' `�"` � � U '� a � ��� .
(Must be Expenditure # corresponding to i�ividual Department)
Purpose of Expenditure: �,I �v�'L� ��'�
� AMENDMENT OF BUDGETS .
� �,
Amend Donation Revenue Acct #101-36230-00-000 : $ ��d� �
Amend Expenditure Acct # I D L la be tD �ame��• $ �
(The two dollar amounts sho
GENERAL JOURNAL ENTRY TO ADJUST DONATION LIA�ITY #
Debit • (�� — `�� o�.� (Donation Liability #) $�b� �
Credit : 101•-36230-00-000 $ .�
� ' Journal entry to reduce cleferred donation. revenue and �increase �
donation revenue to actual per council action on
��.'��' " f
DONATION REVENUE WORRSHEET
RECEIPT OF DONATION
Donation Received on: b�-• � ► � t `�
" Amount Received: $ � ��� � ��
. n
Receipt # f or ponation: ��(� 1 � , _.
Purpose of Donation: o��GU�Q � � �-�'�/�
Account # f or ponation: b� ' �'.���
(Must be Liability # assigned for each individual Department)
EXPENDITURE OF DONATION
Amount to be Spent: $ ��d� � � �
To be Spent from Acct # : �� �'' `i �( � ��' � � �' `� 3 /
(Must be Expenditure # corresponding to individual Department)
cn� ���-�-
Pu ose of Expenditure : c�-r �f.l� � ���✓u/�
�P
AMENDMENT OF BIIDGETS
Amend Donation Revenue Acct #101-36230-00-000 : $ 1��� � �0
Amend Expenditure Acct # 1��- N 1110-01 - �3°l � $�D00 � ��
(The two dollar a�ounts should be the same)
GENERp,I, �7ptTRNAL ENTRY TO ADJIIST DONATION LIABILITY # .
Debit • ����o2ad��s (Donation Liability #) $ �O�O, �O
Credit: 101-36230-00-000 $...�.�00` ��
Journal entry to reduce deferred donation revenue and increase
donation revenue to actual per council action on la-ai` 9�
DONATION REVENUE WORKSHEET
. RECEIPT OF DONATION ��
Donation Received on: /�r���� `1 � � ��
. � -
Amount Received: � $ ���� � �
Receipt # for ponation: � CQ3
- ,
Purpose of Donation: �l�r �— r�
Account # f or ponat ion: ��1-"' �� a a�
(Must be Liability # assigned for each individual Department)
EXPENDITURE OF DONATION
Amount to be Spent : $ ����
To be Spent from Acct #: �4.��-- � 1�_� tr -- d1 --4-� � �
(M u s t b e Ex penditure # corresponding to individual D partment)
� �Purpose of Expenditure : ar'�.� r ►
� AMENDMENT OF BUDGETS .
��
Amend Donation Revenue Acct #101-36230-00-000 : $���i� ►
• ��
Amend Expenditure Acct #Jb�!'�L � � � "b�`�'�'�� $ � SD� �
(The two dollar amounts should be the same)
GENERAL JOURNAL ENTRY TO ADJUST DONATION LIABILITY #
Debit : ��� — `�+'��,� (Donation Liability #) $ ������^
Credit : 101-36230-00-000 $ �� ���� �
� Journal entry to reduce deferred donation revenue and increase
donation revenue to actual per council action on a— �" _1
norrATzox x�v�x� WORRSHEET
RECEIPT OF DONATION
Donation Received on: �`—�" � �7
Amount Received: $ �-i Q�'- `7 ( _
Receipt � for ponation: ���� � �
purpose of Donation: � �'� � � �`S��
Account r for ponation: �f�[ `- � ���
(Must be Liability T assigned for each individual Department)
E%PE2�IDITIIRE OF DONATIOII �
Amount ta be Spent: $ ' �( � �t�� �
To be Spent fron Acct n: �fl� " `f I ! � � `� �' `�"3`�
(Must be Expenditure ; corresponding to individual Department)
purpose of Expenditure: t' 1��7 C��n m���.Y�e � �
A2�,ENDbiELFT OF BIIDGETS
Amend Donation Revenue ALct *101-36230-00-000: $� � �3�7 �
Amend Expenditure Acct ; �� � ""�� � �8 �D� " ��� = $ ����p ���
(The two dollar amounts should be the same)
GENERAL JOIIRNAL ENTRY TO AD.TIIST DONATION LIABILITY � �
Debit: �E� � � � �' �S f Donation Liability ;) $ J� ' � `
Credit: 101-36230-00-000 $ �l ��' `�
J�_L. 1 /1'i�n A^l/1 A � �
`�� � Jvv
Journal entry to reduce deferred donation revenue and increase
donation revenue to actual per council action on ��`' �� ��
DONATION REVENUE WORKSHEET
RECEIPT OF DONATION
Donation Received on: 1-29-99
Amount Received: � 1,000.00
Receipt# for ponation: �
Purpose of Donation: Adopt-a-park(RAAA soccer)
Account# for ponation: 101.22223.5
(Must be Liability # assigned for each individual Department.)
EXPENDITURE OF DONATION
Amount to be Spent: S 240.60
To be Spent from Acct#: 101-45100-01-439
(Must be Expenditure # corresponding to individual Department.)
Purpose of Expenditure: Adopt -a- Park (RAAA soccer)
AMENDMENT OF BUDGETS
Amend Donation Revenue Acct#101-36230-00-000: S 240.60
Amend Expenditure Acct#�101-45100-01-439 S 240.60
(The two dollar amounts should be the same.)
GENERAL JOURNAL ENTRY TO ADJUST DONATION LIABILITY#
Debit: 101-22223.5 (Donation Liability#) S 240.60
Credit: 101-36230-00-000 S 240.60
Journal entry to reduce deferred donation revenue and increase donation revenue to actual per
council action on 12/21/99
DONATION REVENUE WORKSHEET
RECEIPT OF DONATION
Donation Received on: August 10, 1999
Amount Received: $ 300.00
Receipt#for ponation: # 55754
Purpose of Donation: Leprechaun Days
Account# for ponation: 101.22223.8
(Must be Liability# assigned for each individual Department.)
EXPENDITURE OF DONATION
Amount to be Spent: $ 300.00
To be Spent from Acct#: 101-45100-01-439
(Must be Expenditure�t corresponding to individual Department.)
Purpose of Expenditure: Leprechaun Days Supplies
A11�IEh'DI�NT OF BUDGETS
Amend Donation Revenue Acct#101-36230-00-000: $ 300.00
Amend Expenditure Acct#101-45100-01-439 $ 300.00
(The two dollar amounts should be the same.)
GENERAL JOURNAL ENTRY TO ADJUST DONATION LIA.BILITY#
:����
Debit: 101-22223.8 (Donation Liabiliry�) $ 300.00
Credit: 101-36230-00-000 $ 300.00
Journal entry to reduce deferred donation revenue and increase donation revenue to actual per
council action on 11/2/99
o ���-;;►�_ ,
i�' � �i , .
DONATION REVENUE WORKSHEET
RECEIPT OF DONATION
Donation Received on: January 27, 1999, June 28, 1999
Amount Received: $ 1,000.00 & $ 50.00
Receipt# for ponation: # 54102 & 55685
Purpose of Donation: Rosemount Teen Night
Account# for ponation: 101.22223.21
(Must be Liability # assigned for each individual Department.)
EXPENDITURE OF DONATION
Amount to be Spent: $ 524.21
To be Spent from Acct#: 101-45100-01-439
(Must be Expenditure # corresponding to individual Department.)
Purpose of Expenditure: Rosemount Teen Night
A1�iENDMENT OF BUDGETS
Amend Donation Revenue Acct#101-36230-00-000: $ 524.21
Amend Expenditure Acct#101-45100-01-439 $ 524.21
(The two dollar amounts should be the same.)
GENERAL JOURNAL ENTRY TO ADJUST DONATION LIABILITY#
Debit: 101-22223.21 (Donation Liability tf) $ 52421
Credit: 101-36230-00-000 $ 524.21
Journal entry to reduce deferred donation revenue and increase donation revenue to actual per
council action on 12/21/99
DONATION REVENUE WORKSHEET
RECEIPT OF DONATION
Donation Received on: January 27, 1999, June 28, 1999
Amount Received: �a 1,000.00 & $ 50.00
Receipt# for ponation: # 54102 & 55685
Purpose of Donation: . Rosemount Teen Night
Account# for ponation: 101.22223.21
(Must be Liability # assigned for each individual Department.)
EXPENDITURE OF DONATION �
Amount to be Spent: �a 559.50
To be Spent from Acct#: 101-45100-01-439
(Must be Expenditure # corresponding to individual Department.)
Purpose of Expenditure: Rosemount Teen Night �
. AMENDMENT OF BUDGETS
Amend Donation Revenue Acct�101-36230-00-000: $ 559.50
Amend Expenditure Acct#101-45100-01-439 $ 559.50
(The two dollar amounts s�ould be the same.) �
GENERAL JOURl'�'AL ENTRY TO ADNST DONATION LIABILITY#
��-1�3
Debit: 101-22223.21 (Donation Liabiliry#) $ 559.50
Credit: 101-36230-00-000 $ 559.50
Journal entry to reduce deferred donation revenue and increase donation revenue to actual per
council action on 11/2/99
o ° �' �. _ \
1�—Y S �
DONATION REVENUE WORK�SHEET -
. ',,
' �
' RECEIPT OF DONATION
Donation Re�eived on: August 20,1999
Amount Received: $ 900.00
Receipt� for ponation: #55753($500.00)#55833($200.00)�
($200.00)
Purpose of Donation: Safety Camp 1999
Account�for ponation: 101.22223.25
(Must be Liability# assigned for each individual Department.)
EXPENDIT'URE OF DONATION
Amount to be Spent: $ 656.25
To be Spent from Acct#: 101-45100-01-439
(Must be Expenditure# corresponding to individual Department.) �
Purpose of Expenditure: Camp t-shirts . .
AMENDMENT OF BUDGETS
Amend Donation Revenue Acct#101-36230-00-000: $656.25
Amend Expenditure Acct#101-45100-01-439 $ 656.25
(The two dollar amounts should be the same.)
GENERAI�JOURNAL ENTRY TO ADNST DONATION LIA.BILITY#
�3��`
Debit: 101-22223.25 (Donation Liabiliry� $ 656.25
Credit: 101-36230-00-000 $ 656.25
Journal entry to reduce deferred donation revenue and increase donation revenue to actual per
council action on 10/5/99
� 0 2 �
►�-�-ss
DONATION REVENUE WORKSHEET
RECEIPT OF DONATION
Donation Received on: November 18, 1998
Amount Received: �2,343.00
Receipt# for ponation: # 53589
Purpose of Donation: Community Center
Account# for ponation: 101.22223.11 �
(Must be Liability # assigned for each individual Department.)
EXPENDITURE OF DONATION
Amount to be Spent: $ 743.37
To be Spent from Acct#: 101-45100-01-439
. (Must be Expenditure# corresponding to individual Department.) �
Purpose of Expenditure: Community Center �
AMENDI�NT OF BUDGETS
Amend Donation Revenue Acct#101-36230-00-000: $ 743.37
Amend Expenditure Acct#101-45100-01-439 $743.37
(The two dollar amounts should be the same.)
GENERAL JOURNAL ENTRY TO ADJUST DONATION LIABILITY#
�y�►�(
Debit: 101-22223.11 (Donation Liability#) $743.37
Credit: 101-36230-00-000 $743.37
Journal entry to reduce deferred donation revenue and increase donation revenue to actual per
council action on 11/2/99
Q -r----
� �,_�_ss D
I�ONATION REVENUE WORK.SHEET �
. �,
. �
RECEIPT OF DONATION
Donation Received on: 5\5\99 �
Amount Received: $ 812.92
Receipt# for ponation: #
Purpose of Donation: Arbor Day
Account# for ponation: 101.22223
(Must be Liability#assigned for each individual Department.)
� EXPENDITURE OF DONATION
Amount to be Spent: $�;��- �I d.c.,�
To be Spent from Acct�#: 101-45100-01-439
(Must be Expenditure# corresponding to individual Department.)
Purpose of Expenditure: Arbor Day �
� AMENDMENT OF BUDGETS
Amend Donation Revenue Acct#101-36230-00-000: $ 812.92
Amend Expenditure Acct#101-45100-01-439 $ 812.92
(The two dollar amounts should be the same.)
GENERAI,JOURNAL ENTRY TO ADNST DONATION LIABILITY#
.� �
Debit: 101-22223 (Donation Liability� $ 812.92
Credit: 101-36230-00-000 $ 812.92
Joumal entry to reduce deferred donation revenue and increase donation revenue to actual per
council action on 10/5/99 .
o ° D
��-�-5
DONATION REVENUE tiVORhSHEET _
. •,�
. �
• RECEIPT OF DONATION
Donation Received on: 116199
Amount Received: �a 1,300.00
Receipt#{ for ponation: �
Purpose of Donation: Brick Patio
Account# for ponation: 101.22223.23
, (Must be Liability # assigned for each individual Department.)
EXPENDITURE OF DONATION
Amount to be Spent: $ 1, 300.00
To be Spent from Acct#: 101-45100-01-439
(Must be Expenditure# corresponding to individual Department.)
Purpose of Expenditure: Veteran's Memorial
� AMENDMENT OF BUDGETS
Amend Donation Revenue Acct#101-36230-00-000: � 1,300.00
Amend Expenditure Acct#101-45100-01-439 �a 1,300.00
(The two dollar amounts should be the same.)
' �.�ENERAL JOUKNAL ENTRY TO ADNST DONATION LIABILITY#
�-1 ��7
Debit: 101-22223.23 (Donation Liability#) $ 1,300.00
Credit: 101-36230-00-000 a� 1,300.00
Journal entry to reduce deferred donation revenue and increase donation revenue to actual per
council action on 10I5/99
o ° ❑►� -�-5 �
DONATION REVENUE WORKSHEET
RECEIPT OF DONATION
Donation Received on: September 16, 1999
Amount Received: $ 15,000.00
Receipt# for ponation: #56052
Purpose of Donation: Community Center equipment
Account# for ponation: 101.22223.20
(Must be Liability# assigned for each individual Department.)
EXPENDITURE OF DONATION
Amount to be Spent: $ 5,727.50
To be Spent from Acct#: 101-45100-01-439
(Must be Expenditure # corresponding to individual Department.)
Purpose of Expenditure: Community Center equipment
AMENDMENT OF BUDGETS
Amend Donation Revenue Acct#101-36230-00-000: $ 5,727.50
Amend Expenditure Acct#101-45100-01-439 $ 5,727.50
(The two dollar amounts should be the same.)
GENERAL JOURNAL ENTRY TO ADJUST DONATION LIABILITY#
Debit: 101-22223.20 (Donation Liability #) $ 5,727.50
Credit: 101-36230-00-000 $ 5,727.50
Journal entry to reduce deferred donation revenue and increase donation revenue to actual per ouncil
action on 12/21/99
DONATION REVENUE WORKSHEET
RECEIPT OF DONATION
Donation Received on: 12/16/98/ - 10/28/99
Amount Received: $ 18,435.50
Receipt# for ponation: #
Purpose of Donation: Veteran's Memorial
Account# for ponation: 101.22223.24
(Must be Liability # assigned for each individual Department.)
EXPENDITURE OF DONATION
Amount to be Spent: $ 6,400.00
To be Spent from Acct#: 101-45100-01-439
(Must be Expenditure # corresponding to individual Department.)
Purpose of Expenditure: Veteran's Memorial
AMENDMENT OF BUDGETS
Amend Donation Revenue Acct#101-36230-00-000: $ 6,400.00
Amend Expenditure Acct#101-45100-01-439 $ 6,400.00
(The two dollar amounts should be the same.)
GENERAL JOURNAL ENTRY TO ADJUST DONATION LIABILITY#
Debit: 101-22223.24 (Donation Liability �{) $ 6,400.00
Credit: 101-36230-00-000 $ 6,400.00
Journal entry to reduce deferred donation revenue and increase donation revenue to actual per
council action on 12/21/99 •
D.ONATION REVENUE WORhSHEET �
. . ,,
. �
� RECEIPT OF DONATION
Donation Received on:
Amount Received: �a 17,239.50
Receipt# for ponation: �
Purpose of Donation: Veterans Memorial
Account# for ponation: 101.22223.24
(Must be Liability# assigned for each individual Departrnent.)
� EXPENDTI'URE OF DONATION
Amount to be Spent: v� 10, 418.14
To be Spent from Acct#: 101-45100-01-439
(Must be Expenditure#conesponding to individual Department.) �
Purpose of Expenditure: Veterans Memorial
AMENDMENT OF BUDGETS
Amend Donation Revenue Acct#101-36230-00-000: $ 10,418.14
Amend Expenditure Acct#101-45100-01-439 $ 10,418.14
(The two dollar amounts should be the same.)
GENERAI�JOURNAL ENTRY TO ADNST DONATION LIABILITY# .
-�=',�
De it: 101-22223.24 (Donation Liability� $ 10,418.14
Credit: 101-36230-00-000 $ 10,418.14
Journal entry to reduce deferred donation revenue and increase donation revenue to actual per
council action on 10/5/99
0
. D ��_.�s