Spreadsheet: 79741d1279920257-adding-multiple-if-statements-budget-template
Sheet: June Budget

 | Personal Monthly Budget
 |  |  |  | 1st | 2nd | Total |  |  |  |  | 1st | 2nd | Total
 | PROJECTED MONTHLY INCOME | Income 1 |  | 1300 | 1300 |  |  | PROJECTED BALANCE                                                       (Projected income minus expenses)
 |  | Extra income
 |  | Total income |  |  |  |  |  | ACTUAL BALANCE                                                               (Actual income minus expenses)
 | ACTUAL MONTHLY INCOME | Income 1 |  | 1300 | 1300 |  |  | ACTUAL PROJECTED BALANCE                                           (Actual income minus projected expense)
 |  | Extra income
 |  | Total income
 | EXTRA INCOME | 1st Projected | 1st Actual | 2nd Projected | 2nd Actual | Difference |  | TOTAL PROJECTED COST
 | Overtime | 0 | 0
 | Specify |  |  |  |  |  |  | TOTAL ACTUAL COST
 | Specify
 | Specify |  |  |  |  |  |  | TOTAL DIFFERENCE
 | Specify
 | Specify
 | Specify
 | Subtotals
 | HOUSING | 1st Projected | 1st Actual | 2nd Projected | 2nd Actual | Difference |  | ENTERTAINMENT | 1st Projected | 1st Actual | 2nd Projected | 2nd Actual | Difference
 | Mortgage or rent | 0 |  | 0 |  |  |  | Video/DVD
 | Phone | 0 |  | 0 |  |  |  | CDs
 | Electricity | 0 |  | 0 |  |  |  | Movies
 | Gas | 0 |  | 0 |  |  |  | Concerts
 | Water and sewer | 0 |  | 0 |  |  |  | Sporting events
 | Cable | 0 |  | 55 |  |  |  | Live theater
 | Waste removal | 0 |  | 0 |  |  |  | Other
 | Maintenance or repairs | 0 |  | 0 |  |  |  | Other
 | Supplies | 50 |  | 0 |  |  |  | Other
 | Other | 0 |  | 0 |  |  |  | Subtotals
 | Subtotals
 |  |  |  |  |  |  |  | LOANS | 1st Projected | 1st Actual | 2nd Projected | 2nd Actual | Difference
 | TRANSPORTATION | 1st Projected | 1st Actual | 2nd Projected | 2nd Actual | Difference |  | Personal
 | Car Payment | 0 |  | 0 |  |  |  | Student
 | Insurance | 20 |  |  |  |  |  | Credit Card
 | Licensing | 0 |  |  |  |  |  | Credit Card
 | Fuel | 0 |  | 50 |  |  |  | Credit Card
 | Maintenance | 0 |  |  |  |  |  | Other
 | Other | 0 |  |  |  |  |  | Subtotals
 | Subtotals
 |  |  |  |  |  |  |  | TAXES | 1st Projected | 1st Actual | 2nd Projected | 2nd Actual | Difference
 | INSURANCE | 1st Projected | 1st Actual | 2nd Projected | 2nd Actual | Difference |  | Federal
 | Home |  |  |  |  |  |  | State
 | Health |  |  |  |  |  |  | Local
 | Life |  |  |  |  |  |  | Other
 | Other |  |  |  |  |  |  | Subtotals
 | Subtotals
 |  |  |  |  |  |  |  | SAVINGS OR INVESTMENTS | 1st Projected | 1st Actual | 2nd Projected | 2nd Actual | Difference
 | FOOD | 1st Projected | 1st Actual | 2nd Projected | 2nd Actual | Difference |  | Retirement account | 100
 | Groceries | 150 |  | 150 |  |  |  | Investment account | 100
 | Dining out | 150 |  | 150 |  |  |  | Emergency Fund | 100
 | Other | 0 |  | 0 |  |  |  | Subtotals
 | Subtotals
 |  |  |  |  |  |  |  | GIFTS AND DONATIONS | 1st Projected | 1st Actual | 2nd Projected | 2nd Actual | Difference
 | PETS | 1st Projected | 1st Actual | 2nd Projected | 2nd Actual | Difference |  | Charity 1
 | Food | 10 |  | 10 |  |  |  | Charity 2
 | Other | 0 |  | 0 |  |  |  | Charity 3
 | Subtotals |  |  |  |  |  |  | Subtotals
 | PERSONAL CARE | 1st Projected | 1st Actual | 2nd Projected | 2nd Actual | Difference |  | LEGAL | Projected Cost | Actual Cost |  |  | Difference
 | Medical | 0 |  |  |  |  |  | Attorney
 | Hair/nails | 0 |  | 40 |  |  |  | Alimony
 | Clothing | 75 |  |  |  |  |  | Payments on lien or judgment
 | Dry cleaning | 20 |  |  |  |  |  | Other |  | 0
 | Health club | 0 |  |  |  |  |  | Subtotals
 | Organization dues or fees | 0
 | Other | 0 |  |  |  |  |  | Travel | 1st Projected | 1st Actual | 2nd Projected | 2nd Actual | Difference
 | Subtotals |  |  |  |  |  |  | Hotel
 |  |  |  |  |  |  |  | Alimony
 | BUSINESS | 1st Projected | 1st Actual | 2nd Projected | 2nd Actual | Difference |  | Payments on lien or judgment
 | Expenses | 0 | 0 |  |  |  |  | Other |  | 0
 | Other | 0 |  |  |  |  |  | Subtotals
 | Subtotals