Ka

Bill

Notes:
To avoid erasing formulas, do NOT upload this workbook to Google Sheets/Drive. It must rem

This template was created as a resource for House Corporations as you track y

This template assumes that your House Corporation uses BillHighway as your billing service provi
If you do not use Bill Highway as your billing service provider, plea

Many of the cells on this spreadsheet are LOCKED. This means that values are not able to be entered in to
If you need to access any locked cells or have any issues, please

Instructions:
Enter the requested data in to the yellow cells.
Many of the cells will autopopulate.

Income Tab:

Fill in general House Corporation Information name, contact information

and phone numbers.
Fill in fall and spring member totals at the top.
Fill in the remaining yellow cells.
Change the room configurations if needed.

Annual Schedule of Charges Tab:

Fill in general information.
Fill in information regarding late fee amounts and instructions.

Budget Tab:

Fill in "green" Fall 2019 and Spring 2020 actuals. These are there for you
to reference as you budget for Fall 2020 and Spring 2021.
Fill in expense cells in columns D and G.

Notes Tab:
Fill in notes in "Column D" as needed for your HRS to reference.
 Housing Financial Transparency Tab:

Many of these cells will autopopulate. This page is for chapter use during
recruitment.
Fill in the green colored cells.

Member Obligations Tab:

Fill in contact information in the yellow colored cell.

Replace "XXXX"s in the introduction box with applicable information.

Budgetary Breakdown Tab

Input your house corporation's name into the title of the pie chart.

The expense titles will autopopulate. They are linked to the budget tab. If
you would like to condense the titles, you must condense the titles on the
budget tab.
The percentages will autopopulate as information is entered.
 Kappa Delta House Corporation
Budget Template
Billing Period: Fall XXXX-Spring XXXX

tes: Colo
Sheets/Drive. It must remain an Excel document for formulas to work. Pink cells are to be en
Green cells are lin
porations as you track your finances for the fiscal year. Peach cells are c

our billing service provider and includes Bill Highway's 3% service charge.
g service provider, please contact your HRS.

t able to be entered in to the cell. You should not need access to these locked cells.
have any issues, please contact your HRS.

Chapter Communication: Final B

It is expected that you communicate with the chapter and CAB at least once
during the budgeting process. You will need to work with the chapter and
CAB when compiling the following information: Prior to submitting the final ve
approved by your Housing Resour
# of members on EFMS and IMS final draft to her, at least two week
# of members adequate time to review the

Please remember that you will need to present this budget to the chapter in Once approved, the bu
order to provide financial transparency. chapter.housing@kappadelta.org.
HR

We strongly encourage you to present this budget at the chapter's first chapter
meeting and at a new member meeting. Final approved budget
 Color Key
Pink cells are to be entered by House Corp
Green cells are linked to Budget Tab
Peach cells are calculated for you

Final Budgets:

Prior to submitting the final version of the budget, it must be

pproved by your Housing Resource Specialist (HRS). Please send a
nal draft to her, at least two weeks prior to the due date, to give her
adequate time to review the budget and give feedback.

Once approved, the budget should be sent to

hapter.housing@kappadelta.org. Copies should also be sent to your
HRS.

Final approved budgets are due by August 15.

 Kappa Delta Sorority
Schedule of HC Income - Semester Schools
Billing Period: Fall XXXX - Spring XXXX

House Corp Legal Name:

House Corp Treasurer & Phone Number: New Members

House Corp President & Phone Number: Active Members

To be entered by House Corp

Linked to Budget Tab In House Members

Calculated for you Out of House Members

Total Roster

The Totals will be automatically transferred to Budget tab

Room & Board

Number
Term Charge Total by Term
of Beds
Fall Single 0 $0.00 $0.00
Fall Double 0 $0.00 $0.00
Fall Triple 0 $0.00 $0.00
Fall Quadruple 0 $0.00 $0.00
$0.00
Spring Single 0 $0.00 $0.00
Spring Double 0 $0.00 $0.00
Spring Triple 0 $0.00 $0.00
Spring Quadruple 0 $0.00 $0.00

Empty Bed Charge Fall $0.00

Empty Bed Charge Spring $0.00

Other Room & Board Charge(s)

FALL Room Income $0.00 Should match Budget tab cell D21
SPRING Room Income $0.00 Should match budget tab cell G21
EFMS Status $0.00 notate discount(s)
Total Room & Board $0.00

Meal Plans - In House

Term Number Charge Total by Term
Fall - $0.00 $0.00
Spring - $0.00 $0.00
New Member - Fall - $0.00 $0.00
New Member - Spring - $0.00 $0.00
Total Meal Plans $0.00
Meal Plans - Out of House
Term Number Charge Total by Term
Fall - $0.00 $0.00
Spring - $0.00 $0.00

Total Meal Plans $0.00

Facility Fee - National Charge

Term Number Charge Total by Term
Fall 0 $0.00 $0.00
Spring 0 $0.00 $0.00

Total Facility Fees $0.00

CAM Fees - Out Of House

Term Number Charge Total by Term
Fall $0.00 $0.00
Spring $0.00 $0.00

Total Out of House CAM/ Parlor Fees $0.00

*Only to be used by corporations that charge a different parlor/housing fee for

new members. If a corporation charges the same amount for new members
and initiated members, leave this section blank.

OTHER - Per Term Charges

Number Charge Total

Storage $0.00 $0.00

Chapter Rent $0.00 $0.00
Parking $0.00 $0.00
Security $0.00 $0.00
Total Other $0.00

TOTAL MEMBER INCOME $0.00

Metrics on Income Tab must match metrics listed on Member Obligations Output Tab
Delta Sorority
ncome - Semester Schools
all XXXX - Spring XXXX

Fall Spring Fall Spring

0 0 EFMS Members (#) 0 0

0 0 IMS Members (#) 0 0

0 0

0 0
0 0

ch Budget tab cell D21

ch budget tab cell G21
 Annual Schedule of Charges
XXXX - XXXX

This schedule of charges will be used to help you in preparing the annual house corporation budget and by the Local House Cor
corporation. If the corporation does not charge room & board to residents, use only the portions of the schedule that are applica

Chapter
College/University
House capacity

Corporation Contact: This information will be provided to students and parents

Name
Email
Phone

Your budget figures will be calculated based on the estimated chapter membership reported here. Please work closely with col
accurate estimate possible.
Important Note: To avoid erasing formulas, do NOT upload this workbook to Google Drive
Initiation Date - Fall
Initiation Date - Spring
Does the chapter plan on participating in continuous open bidding throughout the school year?

Invoicing Information

Amount due each # Members Month(s) payments are due

semester Billed (billing instructions)

Resident Members
Room and Board Single $ - 0
Room and Board Double $ - 0
Room and Board Triple $ - 0
Room and Board Quad $ - 0
Meal Plan $ - 0
Parking $ -
Security $ -
Key/fob deposit
Other
SUB TOTAL $ - 0
Non-Resident Members

CAM $ -
Meal plan $ - 3
Parking $ -
Security $ -
Other
SUB TOTAL $ -
Fall New Members
Facility Fee $ -
Meal plan
CAM $ -
Parking $ -
Security $ -
SUB TOTAL $ -
FALL TOTAL = $ - Should match Budget tab cell D37 (with IMS/EFMS)
Spring New Members
Facility Fee $ -
Meal plan
CAM
Parking $ -
Security $ -
SUB TOTAL #VALUE!
SPRING TOTAL = #VALUE! Should match Budget tab cell G37 (with IMS/EFMS)
Additional Fees
Empty Bed Charge $ -
budget and by the Local House Corporation (LHC) in setting up member billing for your
ons of the schedule that are applicable to your situation.

here. Please work closely with collegiate chapter personnel, CAB, HRS, and CAS to ascertain the most

(MM/DD/YYYY)
(MM/DD/YYYY)
(Yes / No)

Late Fee Amount &

Late Fee (Yes/No)
Instructions
et tab cell D37 (with IMS/EFMS)

et tab cell G37 (with IMS/EFMS)

 KD YEAR: July 1, XXXX - June 30, XXXX

KEY

Amount linked to Income/Schedule of Charges

tab Instructions: Figures are carried over from other tabs. You can override
based on any variables for which you have plans by entering an integer
Actual metrics from previous year - manually directly into column H and altering expenses in columns D and G.
entered.
Enter budget data here

In House Members 0 0
New Members 0 0
Out of House Members 0 0

Fall XXXX
Acctg Fall XXXX Spring XXXX Spring XXXX TOTAL XXXX- Percentage of
Account Name Budgeted
Code Actual Actual Budgeted Amount XXXX Budget TOTAL Budget
Amount

National Kappa Delta Charges

4190 Facility Fees (New Members) $0.00 $0.00 $0.00 $0.00 $0.00

Starting Cash Balance, 7/01/21 $0.00 - - $0.00

INCOME
4110-1 Room $0.00 $0.00 $0.00 $0.00 $0.00
4195 CAM $0.00 $0.00 $0.00 $0.00
2030 Total Board / Meal Plan $0.00 $0.00 $0.00 $0.00 $0.00
New Member $0.00 $0.00 $0.00 $0.00 $0.00
In House $0.00 $0.00 $0.00 $0.00 $0.00
Out Of House $0.00 $0.00 $0.00 $0.00 $0.00
less IMS (if applicable) $0.00 $0.00 $0.00
less EFMS discount (if applicable) $0.00 $0.00 $0.00
Empty Bed Fee $0.00 $0.00
2060 Parking $0.00 $0.00 $0.00 $0.00 $0.00
2060 Security $0.00 $0.00 $0.00 $0.00 $0.00
Storage $0.00 $0.00 $0.00 $0.00
Rent $0.00 $0.00 $0.00 $0.00
2060 Other $0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00

Total Income $0.00 $0.00 $0.00 $0.00 $0.00

EXPENSES
5110 Mortgage Debt Payment (Principal) $0.00 $0.00 $0.00

$0.00 $0.00 $0.00

5110 Second Mortgage, Loan, or LOC payments
5111 Interest Expense $0.00 $0.00
5115 Total Utilities $0.00 $0.00 $0.00 $0.00 $0.00
Water $0.00 $0.00 $0.00
Trash $0.00 $0.00 $0.00
Cable/Satellite/Internet/Phone $0.00 $0.00 $0.00
Electric $0.00 $0.00 $0.00
Gas $0.00 $0.00 $0.00
5155 Landscaping $0.00 $0.00 $0.00
5160 Billing System Fees $0.00 $0.00 $0.00 $0.00 $0.00
5162 Professional Accounting Fees $0.00 $0.00 $0.00
5175 Vending Expense $0.00 $0.00 $0.00
5196 Storage Room Rent $0.00 $0.00 $0.00
5241 Accountant / Accounting Fees $0.00 $0.00 $0.00

751526528.xlsx
5251 Bank Fees/ Credit Card Fees $0.00 $0.00 $0.00
5261 Payroll $0.00 $0.00 $0.00
5290 Food / Food Service $0.00 $0.00 $0.00
5290 Cleaning Service / Supplies $0.00 $0.00 $0.00
5291 Legal $0.00 $0.00 $0.00
5315 Property Taxes $0.00 $0.00 $0.00
5410 Other Taxes & Filing Fees $0.00 $0.00 $0.00
5420 Total Insurance $0.00 $0.00 $0.00 $0.00 $0.00
Property Insurance $0.00 $0.00 $0.00
Liability Insurance $0.00 $0.00 $0.00
Health ins / Workers Comp $0.00 $0.00 $0.00
5440 Administrative Expenses $0.00 $0.00 $0.00
5440 Alarm System/ Security $0.00 $0.00 $0.00
5520 Repairs $0.00 $0.00 $0.00
5520 Maintenance & Service Agreements $0.00 $0.00 $0.00
5530 Permits & Inspections $0.00 $0.00 $0.00
5540 Pest Control $0.00 $0.00 $0.00
5620-1 Bad Debt $0.00 $0.00 $0.00
5775 Other Expenses $0.00 $0.00 $0.00

TOTAL EXPENSES $0.00 $0.00 $0.00 $0.00 $0.00 0.00%

SURPLUS $0.00 $0.00 $0.00 $0.00 $0.00

ENDING CASH BALANCE $0.00 $0.00 $0.00 $0.00 $0.00

ANNUAL TOTALS
Total Income $0.00
Total Expenses $0.00
Total Surplus $0.00 THIS MUST BE A POSITIVE NUMBER

751526528.xlsx
 Accounting Code Account Name Chapter Specific Notes

National Facility Fee

National Kappa Delta Charges
2020 CAM
INCOME
4110-1 Room
4110-2
Board / Meal Plan

5748 Parking
4120 Security
4130 Other
4135

4140
5110 Mortgage Debt Payment (Principal)

5112 Second Mortgage, Loan, or LOC payments

5115 Interest Expense
5125 Utilities
5130 Water
5140 Trash
5150 Cable/Satellite/Internet/Phone
5155 Electric
5160 Gas
5161 Landscaping
5162 Billing System Fees
5162-1 Professional Accounting Fees
5163 Vending Expense
5165 Storage Room Rent
5166-1 Accountant / Accounting Fees
5166-2 Bank Fees/ Credit Card Fees
5175 Payroll
5190 Food / Food Service
5196 Cleaning Service / Supplies
5199 Legal
5211-1 Property Taxes
5211-2 Other Taxes & Filing Fees
5221-1 Insurance
5221-2 Property Insurance
5241 Liability Insurance
5251 Health ins / Workers Comp
5261 Administrative Expenses
5271 Alarm System/ Security
5281 Repairs
5284 Maintenance & Service Agreements
5290-1 Permits & Inspections
5290-2 Pest Control
5291 Bad Debt
5310-1 Other Expenses
FINANCIAL AND HOUSING INFORMATION
Sorority: Kappa Delta EIN: New member Date & Fees Charged:

Campus: Facility Fee: $ -

Housing Fees Meal Plan: $0.00

Other: $
I. New Member Facility
Fees: $ - Fall

II. Members Residing IN HOUSE: #VALUE! Semester

(This total amount includes all items listed below.)

Room Fee / Rent $ Parking $ - Other $

Meal Plan $ - Security $ -

Sorority residency requirement: Number of Semesters you must live in:

Housing Agreement Breakage Fee:
Other:

III. Members Residing OUT OF HOUSE: #VALUE! *

(This total amount includes all items listed below.)

CAM $ - Parking $ - Other $

Meal Plan $ - Security $ -

Campus/University Fees
Campus housing, including room and board per term: $ - *

*Fees quoted are based on estimates at the time of document preparation. Chapter payment plans may be offered; please
discuss financial questions with the chapter VP-Finance or House Corporation Chair.

See financial definitions on back

FINANCIAL DEFINITIONS
Parking permit: Parking is typically limited at chapter houses. Spaces are allocated by each chapter to members based on
criteria set by the leadership and/or chapter corporation.

Facility fee: a One-Time per member fee designated to be part of a long-term savings account that provides funds to modify
and update chapter facilities in the future. Often this is a one-time fee paid prior to initiation.

CAM usage fee: Common Area Maintenance fees are collected to pay expenses for operating and maintaining the facility
and furnishings. Typically, the entire membership, alumnae, and campus visitors have access to the house and thus the
property is subject to wear and tear. This is a reoccurring fee while you are a collegiate member
CAM usage fee: Common Area Maintenance fees are collected to pay expenses for operating and maintaining the facility
and furnishings. Typically, the entire membership, alumnae, and campus visitors have access to the house and thus the
property is subject to wear and tear. This is a reoccurring fee while you are a collegiate member

Security fee: Special security systems/staff may be employed to protect chapter property, members and guests. Typically, all
members, not just those living in the house, would be asked to help cover this expense.
 Like most membership organizations, membership in Kappa Delta includes a financial commitment.
As a new or existing member of the sorority, you must agree to meet the financial obligations noted
below. On the XXXX of each month, you will receive an XXXXXX; payment is due by the 15th.
Payment can be made by mailing a check or money order to XXXXXX or by XXXXXXXX. A XXX
late fee will be applied to past due bills. If your parents wish to receive a copy of the statement, you can
XXXXXX. Below are the amounts set for the XXXX-XX school year. Note: New member fees are only
paid for one academic term while you are a new member. A fall new member would begin paying
initiated member dues in the spring.

Per Semester
New Member Initiated Member
Fees Semester In House Out of House
Facility Fee (One Time) $ - $0 $0
CAM $ - $0 $ -
Room $0
Board / Meal Plan
Parking $ - $ - $ -
Security $ - $ - $ -
Other (specify:_______________
Other
Other
Total $ - $ - $ -

Fee Descriptions
Facility Fee: a One-Time per member fee designated to be part of a long-term savings account that provides
funds to modify and update chapter facilities in the future. Often this is a one-time fee paid prior to initiation.

Common Area Maintenance(CAM) Fee: Common Area Maintenance fees are collected to pay expenses for
operating and maintaining the facility and furnishings. Typically, the entire membership, alumnae, and campus
visitors have access to the house and thus the property is subject to wear and tear. This is a reoccurring fee while you
are a collegiate member.
Room: Cost for in-residence housing (bedroom space)
Board / Meal Plan: Fee to allow for the provision of meals at the House or on the go, regardless of if the
member exercises that privilege.

Parking: A fee paid to cover the cost of providing parking on behalf of all members, regardless of whether or not you
are assigned a parking spot or are utilize the parking spot.

Security: Special security systems/staff may be employed to protect chapter property, members and guests.
Typically, all members, not just those living in the house, would be asked to help cover this expense.
Other Income: Enter description of other fee here or delete this text.
Other Income: Enter description of other fee here or delete this text.
Chapter's House Corp Contact: Enter Name, Email Address, & Phone Number Here!
HOUSE CORPORATION 2020-2021 Budget Breakdown

Mortgage D
Second Mo
Interest Exp
Total Utiliti
Landscapin
Billing Sys
Professiona
Vending Ex
Storage Ro
Accountant
Bank Fees/
Payroll
Food / Foo
Cleaning S
Legal
Property Ta
Other Taxe
Total Insur
Administra
Alarm Syst
Repairs
Maintenanc
Permits & I
Pest Contro
Bad Debt
Other Expe
get Breakdown

Mortgage Debt Payment (Principal)

Second Mortgage, Loan, or LOC payments
Interest Expense
Total Utilities
Landscaping
Billing System Fees
Professional Accounting Fees
Vending Expense
Storage Room Rent
Accountant / Accounting Fees
Bank Fees/ Credit Card Fees
Payroll
Food / Food Service
Cleaning Service / Supplies
Legal
Property Taxes
Other Taxes & Filing Fees
Total Insurance
Administrative Expenses
Alarm System/ Security
Repairs
Maintenance & Service Agreements
Permits & Inspections
Pest Control
Bad Debt
Other Expenses