Docstoc

Expenses Template.xlsx

Document Sample
Expenses Template.xlsx Powered By Docstoc
					             2012 DEPT Expenses - CODE
  Date                                                             Remaining $
Code 222          IT Equipment Lease                                  Ck #



                                            Sub total: $       -   $         -

Code 270          Capital Equipment




                                            Sub total: $       -   $         -

Code 411   Office Supplies - Budgeted Amount                           Ck#




                      Prepared by Onnalee O'Connor 3/24/2013                     Page 1
                                            Sub total: $      -   $         -

Code 415   Uniform and Cleaning Allowance                             Ck#




                                            Sub total: $      -   $         -

Code 418     Other Contractual Expenses                               Ck#




                                            Sub total: $      -   $         -

Code 421         Telephone/Internet                                   Ck#




                                            Sub total: $      -   $         -


Code 422           Electric Costs                                     Ck#




                     Prepared by Onnalee O'Connor 3/24/2013                     Page 2
                                 Sub total: $       -   $         -

Code 423     Water                                          Ck#




                                 Sub total: $       -   $         -


Code 424   Food Costs                                       Ck#




                                 Sub total: $       -   $         -

Code 427   Natural Gas                                      Ck#



           Prepared by Onnalee O'Connor 3/24/2013                     Page 3
                                                Sub total: $       -   $         -

Code 429               Cleaning Supplies                                   Ck#




                                                Sub total: $       -   $         -

Code 431                   Insurance                                       Ck#




                                                Sub total: $       -   $         -

Code 441          Printing - Budgeted Amount                               Ck#




                                                Sub total: $       -   $         -

Code 443   Repair to office equipment - Budgeted Amt.                      Ck#


                                                Sub total: $       -   $         -

Code 444          Repairs to Equip & Property                              Ck#




                                                Sub total: $       -   $         -




                          Prepared by Onnalee O'Connor 3/24/2013                     Page 4
Code 447   Contracted Services & Equipment - Budgeted Amt.                    Ck#




                                                   Subtotal: $        -   $         -

Code 452               Personal Svs Contracts                                 Ck#




                                                   Sub total: $       -   $         -

Code 460               Training & Educational                                 Ck#




                                                   Sub total: $       -   $         -

Code 461                      Postage                                         Ck#




                             Prepared by Onnalee O'Connor 3/24/2013                     Page 5
                                        Sub total: $       -   $         -

Code 462           Mileage                                         Ck#




                                        Sub total: $       -   $         -

Code 463   Travel Other than Mileage                               Ck#




                                        Sub total: $       -   $         -

Code 489      Professional Dues                                    Ck#




                  Prepared by Onnalee O'Connor 3/24/2013                     Page 6
                      Sub total: $       -   $    -


                             Total Budgeted: $    -
                                 Total spent: $   -
                            Total Remaining: $    -




Prepared by Onnalee O'Connor 3/24/2013                Page 7
Instructions:

You will have to save this to your documents using "Save As" before using it.

This sheet may or may not have all of your necessary budget lines. This is setup as a general template.

Enter each line required with the amount that has been budgeted in the blue area.
As expenses occur, mark them down with the date, description, and check #.
The amount of the check goes in the third column and will automatically total down and subtract from the originally budgeted figu
At the bottom, all of the blue areas are added and should equal the total budget at the beginning.
All of the red areas are added to show all of the expenses.
These are then calculated to show the total remaining for the entire budget.

Quarterly this should be compared to the quarterly expense report distributed by the Treasurer's office, to be sure it all matches.

This is a great tool used for Budget purposes.
e originally budgeted figure.




o be sure it all matches.

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:3/22/2013
language:English
pages:9