Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

Blank Budget template _Xls_ - NGIN

VIEWS: 60 PAGES: 19

									                                      SCYHA Team Name
                                              Year Budget
 SAMPLE DATA!!! Enter your team's amounts at the beginning of your season.
          Date
                                                                      Budget     Actual      Difference
Revenues                      # of Athletes     Expense

 Entry Fees                              14          300              4,200.00        -        4,200.00
 Player Credits                                                            -          -            0.00
 Sponsorship                                                          2,500.00        -        2,500.00
 Parent Contributions                    14          950             13,300.00        -       13,300.00
 Coach Stipend - from SCYHA                                             500.00                   500.00
 Final Payments                                                            -          -            0.00
 Total Revenues                                                      20,500.00        -       20,500.00

                                                                     Budget      Actual      Difference
Expenses                                         Expense
 Ice Time                                45          130              5,850.00        -        5,850.00
 Acceleration Minnesota                  14          240              3,360.00        -        3,360.00
 District Referees                       10           41                410.00        -          410.00
 District Assessment                                                    300.00        -          300.00
 District Playoffs                                                      200.00        -          200.00
 Administration                          14           90              1,260.00        -        1,260.00
 Uniform Depreciation                    14           26                364.00        -          364.00
 Equipment Fee                           14           10                140.00        -          140.00
 Practice Jerseys                        14           10                140.00        -          140.00
 Socks                                   14           20                280.00        -          280.00
 Coaches /Helpers Gift Certificates                                     400.00        -          400.00
 Player of Game Trophies                                                250.00        -          250.00
 Coaches Travel - Per Diem                 8          25                200.00        -          200.00
 Coaches Travel - Hotel                    5         115                575.00        -          575.00
 Coaches Travel - Mileage              0.475         750                356.25        -          356.25
 Coaches Apparel                                                        100.00        -          100.00
 Coach Stipend                                                          500.00                   500.00
 Buses                                    1          575                575.00        -          575.00
 Insurance - Players                     14           33                462.00        -          462.00
 Insurance - Coaches                      4           25                100.00        -          100.00
 Dynamics                                14           20                280.00        -          280.00
 Tournaments                                                            650.00        -          650.00
 Tournaments                                                            500.00        -          500.00
 Tournaments                                                            500.00        -          500.00
 Raiser Fee                              14          100              1,400.00                 1,400.00
 Team Parties/Trophies                                                1,000.00        -        1,000.00
 Captains Letters                                                        20.00        -           20.00
 Postage                                                                 20.00        -           20.00
 Supplies                                                               100.00        -          100.00
 Bank Fees                                                               20.00        -           20.00
 Total Expenses                                                      20,312.25        -       20,312.25

 Net Income or (Deficit)                                                187.75        -          187.75

 Total Expense per Player                                             1,450.88        -       (1,450.88)

 Total Expense Paid per Player                                        1,236.59    (178.57)    (1,415.16)
            Payment Record                                  Balancing
11/1/2005

Player       Check #   Amount   Dated                     Check Book Balancing
                                        Player Payments                               $0.00
                                        Less Expenses


                                        Should Equal                                       -


                                        Checkbook Balance 11/5/05                          -
                                        Checkbook Balance 12/3/05                          -
                                        Checkbook Balance 1/5/06                           -
                                        Checkbook Balance 2/5/06                           -
                                        Checkbook Balance 3/5/06                           -
                                        Checkbook Balance 4/5/06                           -
                                                         SCYHA Account Balancing
                                        Checkbook Balance                                  -
                                        Plus Pending Deposits                              -
                                        Less Outstanding Checks                            -
                                        Plus SCYHA Account Balance                         -
                                                                                           -



                                        Reconciliation                                     -



                                           Player        Check #     Amount        Dated
                                                   SCYHA Team Name
                                                    2005-2006 Cost Statement
10/15/2005

 Jersey#      Last Name     First Name   Parents    Phone           Cell Phones       Address   Email address




             SCYHA Squirt A Black                           2005-2006 Team Contacts                             10/9/05
                                 SCYHA Team Name
                                   2005-2006 Team Payments

 11/1/2005

  Player's       Credits   Reg   Oct     Nov      Dec        Jan   Feb   Final   Total Pd
   Name          Forward   Fee                                                   to Team

             0                                                                       -

             0                                                                       -

             0                                                                       -

             0                                                                       -

             0                                                                       -

             0                                                                       -

             0                                                                       -

             0                                                                       -

             0                                                                       -

             0                                                                       -

             0                                                                       -

             0                                                                       -

             0                                                                       -

             0                                                                       -


Team Totals         -        -     -       -         -         -     -      -        -
                                   SCYHA Team Name
                                     2008-2009 Player Statements

11/1/2005                  Red Indicates Overdue Amount
                        change $$ amounts in green to your team's monthly amounts
                         Mark Pd if player has paid for that month
Player's                      Amount Owed                        Final Randys Amount   Total
 Name           Reg. Fee Oct     Nov      Dec     Jan     Feb          Credit  Paid    Owing

            0       -     175    200     200    200    200            0           -     975.00
                              SCYHA Team Name
                               2008-2009 Player Statements

11/1/2005             Red Indicates Overdue Amount
                   change $$ amounts in green to your team's monthly amounts
                    Mark Pd if player has paid for that month
Player's                 Amount Owed                        Final Randys Amount   Total
 Name      Reg. Fee Oct     Nov      Dec     Jan     Feb          Credit  Paid    Owing
         0      -    175    200      200     200     200            0         -    975.00
                              SCYHA Team Name
                               2008-2009 Player Statements

11/1/2005             Red Indicates Overdue Amount
                   change $$ amounts in green to your team's monthly amounts
                    Mark Pd if player has paid for that month
Player's                 Amount Owed                        Final Randys Amount   Total
 Name      Reg. Fee Oct     Nov      Dec     Jan     Feb          Credit  Paid    Owing
         0      -    175    200      200     200     200            0         -    975.00
                              SCYHA Team Name
                               2008-2009 Player Statements

11/1/2005             Red Indicates Overdue Amount
                   change $$ amounts in green to your team's monthly amounts
                    Mark Pd if player has paid for that month
Player's                 Amount Owed                        Final Randys Amount   Total
 Name      Reg. Fee Oct     Nov      Dec     Jan     Feb          Credit  Paid    Owing
         0      -    175    200      200     200     200            0         -    975.00
                              SCYHA Team Name
                               2008-2009 Player Statements

11/1/2005             Red Indicates Overdue Amount
                   change $$ amounts in green to your team's monthly amounts
                    Mark Pd if player has paid for that month
Player's                 Amount Owed                        Final Randys Amount   Total
 Name      Reg. Fee Oct     Nov      Dec     Jan     Feb          Credit  Paid    Owing
         0      -    175    200      200     200     200            0         -    975.00
                              SCYHA Team Name
                               2008-2009 Player Statements

11/1/2005             Red Indicates Overdue Amount
                   change $$ amounts in green to your team's monthly amounts
                    Mark Pd if player has paid for that month
Player's                 Amount Owed                        Final Randys Amount   Total
 Name      Reg. Fee Oct     Nov      Dec     Jan     Feb          Credit  Paid    Owing
         0      -    175    200      200     200     200            0         -    975.00
                              SCYHA Team Name
                               2008-2009 Player Statements

11/1/2005             Red Indicates Overdue Amount
                   change $$ amounts in green to your team's monthly amounts
                    Mark Pd if player has paid for that month
Player's                 Amount Owed                        Final Randys Amount   Total
 Name      Reg. Fee Oct     Nov      Dec     Jan     Feb          Credit  Paid    Owing
         0      -    175    200      200     200     200            0         -    975.00
                              SCYHA Team Name
                               2008-2009 Player Statements

11/1/2005             Red Indicates Overdue Amount
                   change $$ amounts in green to your team's monthly amounts
                    Mark Pd if player has paid for that month
Player's                 Amount Owed                        Final Randys Amount   Total
 Name      Reg. Fee Oct     Nov      Dec     Jan     Feb          Credit  Paid    Owing
         0      -    175    200      200     200     200            0         -    975.00
                              SCYHA Team Name
                               2008-2009 Player Statements

11/1/2005             Red Indicates Overdue Amount
                   change $$ amounts in green to your team's monthly amounts
                    Mark Pd if player has paid for that month
Player's                 Amount Owed                        Final Randys Amount   Total
 Name      Reg. Fee Oct     Nov      Dec     Jan     Feb          Credit  Paid    Owing
         0      -    175    200      200     200     200            0         -    975.00
                              SCYHA Team Name
                               2008-2009 Player Statements

11/1/2005             Red Indicates Overdue Amount
                   change $$ amounts in green to your team's monthly amounts
                    Mark Pd if player has paid for that month
Player's                 Amount Owed                        Final Randys Amount   Total
 Name      Reg. Fee Oct     Nov      Dec     Jan     Feb          Credit  Paid    Owing
         0      -    175    200      200     200     200            0         -    975.00
                              SCYHA Team Name
                               2008-2009 Player Statements

11/1/2005             Red Indicates Overdue Amount
                   change $$ amounts in green to your team's monthly amounts
                    Mark Pd if player has paid for that month
Player's                 Amount Owed                        Final Randys Amount   Total
 Name      Reg. Fee Oct     Nov      Dec     Jan     Feb          Credit  Paid    Owing
         0      -    175    200      200     200     200            0         -    975.00
                              SCYHA Team Name
                               2008-2009 Player Statements

11/1/2005             Red Indicates Overdue Amount
                   change $$ amounts in green to your team's monthly amounts
                    Mark Pd if player has paid for that month
Player's                 Amount Owed                        Final Randys Amount   Total
 Name      Reg. Fee Oct     Nov      Dec     Jan     Feb          Credit  Paid    Owing
         0      -    175    200      200     200     200            0         -    975.00
                              SCYHA Team Name
                               2008-2009 Player Statements

11/1/2005             Red Indicates Overdue Amount
                   change $$ amounts in green to your team's monthly amounts
                    Mark Pd if player has paid for that month
Player's                 Amount Owed                        Final Randys Amount   Total
 Name      Reg. Fee Oct     Nov      Dec     Jan     Feb          Credit  Paid    Owing
         0      -    175    200      200     200     200            0         -    975.00
                              SCYHA Team Name
                               2008-2009 Player Statements

11/1/2005             Red Indicates Overdue Amount
                   change $$ amounts in green to your team's monthly amounts
                    Mark Pd if player has paid for that month
Player's                 Amount Owed                        Final Randys Amount   Total
 Name      Reg. Fee Oct     Nov      Dec     Jan     Feb          Credit  Paid    Owing
         0      -    175    200      200     200     200            0         -    975.00
                                 SCYHA Team Name
                                   2008-2009 Player Statements

 11/1/2005               Red Indicates Overdue Amount
                      change $$ amounts in green to your team's monthly amounts
                       Mark Pd if player has paid for that month
  Player's                  Amount Owed                        Final Randys Amount    Total
   Name       Reg. Fee Oct     Nov      Dec     Jan     Feb          Credit  Paid     Owing

Team Totals       -      2450   2800   2800   2800    2800       0     0        -    13,650.00

								
To top