Spreadsheet: 525519d1498755577-sumif-dont-understand-that-purpose-of-the-offset-inside-sumif-excel_forum_qus
Sheet: Report

 |  |  |  |  |  |  |  |  |  | Instructions
 |  |  |  |  |  |  |  |  |  | Customize the categories as needed. Update the Categories and Budget worksheets to match the categories you define.
Year Begins: | 2014-01-01 00:00:00 | Begin: |  |  | Year-To-Date: | No
Month: | 1 | End:
BUDGET SUMMARY |  |  |  |  | EXPENSE SUMMARY | Budget | Actual | Difference |  | - In the Year Begins field, enter the date of the first day of the month corresponding to the first month in the Budget worksheet. If your financial year starts in July, you would enter 7/1/2013.
 | Budget | Actual | Difference
Total Income
Total Expenses
NET |  |  |  |  |  |  |  |  |  | - Use the Month field to display the budget report for a specific month. If your financial year starts in July, month 2 would be August.
 |  |  |  |  |  |  |  |  |  | - Select "Yes" from the Year-To-Date drop-down box to see the Year-To-Date Budget Report.
INCOME | Budget | Actual | Difference
Wages & Tips
Interest Income
Dividends
[NAME]
Refunds/Reimbursements
Financial Aid
Rental Income
INCOME-Other
TO SAVINGS | Budget | Actual | Difference
Emergency Fund
Retirement Fund
College Fund
Investments
Taxes
Vacation Fund
SAVINGS -Other
% of Income
CHARITY/GIFTS | Budget | Actual | Difference
Tithing
Charitable Donations
Religious Donations
Gifts
Christmas
CHARITY - Other
% of Income
HOUSING | Budget | Actual | Difference
Mortgage/Rent
Home/Rental Insurance
Real Estate Taxes
Furnishings/Appliances
Lawn/Garden
Maintenance/Supplies
Improvements
HOUSING - Other
% of Income
UTILITIES | Budget | Actual | Difference
Electricity
Gas/Oil
Water/Sewer/Trash
Phone
Cable/Satellite
Internet
UTILITIES - Other
% of Income
FOOD | Budget | Actual | Difference
Groceries
Dining/Eating Out
Pet Food
FOOD - Other
% of Income
TRANSPORTATION | Budget | Actual | Difference
Vehicle Payments
Auto Insurance
Fuel
Bus/Taxi/Train Fare
Repairs/Tires
Registration/License
TRANSPORTATION - Other
% of Income
HEALTH | Budget | Actual | Difference
Health Insurance
Disability Insurance
Doctor/Dentist/Optometrist
Medicine/Drugs
Health Club Dues
Life Insurance
Veterinarian/Pet Care
HEALTH - Other
% of Income
DAILY LIVING | Budget | Actual | Difference
Education
Clothing
Personal Supplies
Cleaning Services
Laundry / Dry Cleaning
Salon/Barber
DAILY LIVING - Other
% of Income
CHILDREN | Budget | Actual | Difference
Children:Clothing
Medical
Music Lessons
School Tuition
School Lunch
School Supplies
Babysitting/Child Care
Toys/Games
CHILDREN - Other
% of Income
OBLIGATIONS | Budget | Actual | Difference
Student Loan
Other Loan
Credit Card #1
Credit Card #2
Credit Card #3
Alimony/Child Support
Federal Taxes
State/Local Taxes
Legal Fees
OBLIGATIONS - Other
% of Income
BUSINESS EXPENSE | Budget | Actual | Difference
Deductible Expenses
Non-Deductible Expenses
BUSINESS - Other
% of Income
ENTERTAINMENT | Budget | Actual | Difference
Vacation/Travel
Videos/DVDs
Music
Games
Rentals
Movies/Theater
Concerts/Plays
Books
Hobbies
Film/Photos
Sports
Outdoor Recreation
Toys/Gadgets
ENTERTAINMENT - Other
% of Income
SUBSCRIPTIONS | Budget | Actual | Difference
Newspaper
Magazines
Dues/Memberships
SUBSCRIPTIONS - Other
% of Income
[NAME] | Budget | Actual | Difference
Bank Fees
Postage
MISC - Other
% of Income