Introduction to the Budget/Expenditures Tracking Spreadsheet:

There is currently an empty budget worksheet available for download and use in addition to two example files. They are all Excel files using MS Office 2010 and are each about 800K in size. These files are Release 1.10 - the empty worksheet should be fully functional. As I make changes to the spreadsheet in response to suggestions, I intend that new versions will be compatible with Release 1.10 so budget data can be migrated easily to a new worksheet – typically at the beginning of a new year.

There are many considerations that go into the process of designing a monthly and yearly budget that will successfully balance income (which may be fixed or variable) with monthly and yearly expenses that frequently are not entirely fixed.  Expenses can be: predictable and fixed; variable and driven by changing needs, desires and emotions; or they can be in response to emergencies, over which there is little control.  A budget that will work effectively (by that I mean a budget that will balance income and expenses AND will actually be followed) for any individual (or partnership) must be thought out very carefully to realistically plan for all the known components, reduce emotionally-driven expenditures, and establish contingency plans that will be sufficient to handle most emergencies. 

If the budget process and resulting plan is not realistic, individuals (&/or partners) will either not be able to follow it or they will not have sufficient motivation to continue using it.

If your monthly income does not change (you have the same number of paychecks each month and you receive no significant bonuses or additional income throughout the year) you can skip the next irregular income budget discussion below, read through the suggestions following the irregular income section, and begin your budgeting process.


Start of irregular income budget discussion (26 paychecks a year, commissions, bonuses, etc.).

If your monthly income is variable, the budget program will still be very useful, but there are some steps that will help you use it more effectively.

This spreadsheet was developed to implement an electronic version of Dave Ramsey's zero-based budget that will work, not only for non-variable incomes that are easily averaged by month, but for variable incomes that do not easily fit into a monthly average schedule.

For example, if you are paid every other week, most months will have two paychecks, but two months will have three paychecks – consequently, a fixed monthly budget that’s based on a 12 month average will show a monthly income that is higher than actually comes in most months.  That makes budgeting for 10 of the months (with a lower income than the average) difficult.  Then the extra pay checks come in during two months and provide an irregular monthly surplus.  People can also have irregular income based on periodic bonuses or jobs with income from commissions.  Dealing with both known and unknown income fluctuations can be a budgeting challenge.

The strategy that has worked for Carol and me is:

First, read suggestions 1 - 8 below.  Then download the working and example spreadsheets, look through them and perhaps experiment with changing numbers in the example spreadsheet to see what happens. 

Second, instead of immediately entering your income, go to step (9j), enter all budget category and sub-category names you are aware of and categorize them according to how you plan to track and manage the funds for each category - do not enter any values yet - just the budget category and sub-category names

Third, go back to step (9a) and begin entering your income sources.  For this first pass, just enter the portion of your income that is stable from month-to-month.  If you have 26 paychecks , for example, enter 24 in step (9f) instead of 26 (you will change this later).  If you receive periodic expected bonuses or other expected periodic income over and above a regular, stable pay check do not enter them at this time (you will enter them later).  If you have an extremely variable monthly income from commissions, enter the lowest monthly income you can count on (you will change this value later).  This step allows you to budget for fairly regular, necessary and important monthly expenses using a lower stable income value than if you entered all income.  The example_a worksheet demonstrates this strategy.

Fourth, follow steps (9k-n) below and enter your regular, necessary and important monthly expenses (rent/mortgage, insurance, phone, cable, etc.) into the Budget Worksheet (BW).  For necessary monthly expenses like groceries, gas, water, electricity, etc. that vary somewhat from month to month, enter your best guess average monthly expense.  This process will allocate your dependable income to your basic, necessary expenses.  Zero this preliminary budget by allocating incomes from the most important to the least important budget categories.  It is my suggestion to not address big, non-essential savings categories like vacation funds, Christmas/holiday savings, new car savings, and even emergency savings during this step.  If you budget for your essential category expenses and still have funds to allocate, begin budgeting for the important savings categories.

Fifth, after all of your monthly dependable income has been allocated to necessary expenditures, go back to the Income Worksheet (IW) tab, step (9a), and modify your income to include the irregular income amounts.  If you are paid bi-weekly you can change the number of paychecks from the initial 24 to the real value of 26.  You can add new income categories for expected bonuses,  and if you are paid on commissions and have entered a low, reliable value for preliminary budgeting, you can increase it to higher, hopefully more realistic values.  That will increase your monthly income value.

Sixth, open the Budget Worksheet (BW) tab again, and you will notice that the monthly budgeted income will again be larger and the Difference line will no longer = zero.  Work through the budget categories and fill in estimated expenses for the remaining savings category or categories - most important to least important - until the Difference line is again zero, and all of your expected yearly income has been allocated - either to ongoing monthly expenses or to savings for irregular expenses throughout the year.

Any income that comes in as extra (irregular) monthly paychecks is now allocated to specific budget categories that are not part of your normal monthly living expenses. If those extra income allocations are for long term, relatively large value savings categories (like vacations, property taxes, etc.), the program seems to work effectively without too much impact on the stable monthly budget categories. 

Note:
All expected irregular income that has been used in the budgeting process will need to be entered into the monthly tracking sections as it is received (step 9q).

 

The only caveat is that you will need to plan your savings so that you will have sufficient funds saved BEFORE the category expenses are required.  This will probably take some experimentation and practice, and you will need to figure out how to save for large irregular expenses (property taxes, vacations, car repairs/purchases, major household expenses, etc.) whether or not you use this budget program.

 

As noted elsewhere, you may wish to set up one or more separate savings accounts and move money out of your checking account every month for the larger budgeted savings categories - once funds have been transferred out of your checking account into savings and the transaction entered into the monthly expenditure record, any further use of funds in separate savings accounts is not tracked in the budget program.

 

End of irregular income discussion.

 


Budget Program Instructions:

 

My suggestions for getting started with the budget program are to:

  1. Print these instructions - there are a lot of initial steps to create a successful, accurate budget. The ongoing expense tracking process is relatively straight forward.
     
  2. Prepare a budget folder on your computer in which to save the Budget Worksheet. 
     
  3. Click on the Working Budget Worksheet link below
     
  4. In IE you should have the option of opening or saving the file. The 'Save As' option will allow you to save the spreadsheet in the appropriate location with an appropriate name.  Save the worksheet into the "budget" folder you created in step 2
     
  5. Open your budget folder and make a copy of the downloaded empty worksheet for a backup (and to use next year unless it is replaced by Release 2.0) - the budget worksheet tracks income and expenses for a calendar year, and then a new empty worksheet can be populated with the final budget and end-of-year values from the previous year.
  6. Open the copy of the Working Budget Worksheet you downloaded and look through it as you read the description below to familiarize yourself with the features. Click on the tabs and open the specific spreadsheet as they are described. 
    Specifically, there is an Income Worksheet (IW), a Budget Worksheet (BW), an Income and Budget Summary (IBS), a Year To Date Worksheet (YTD), Twelve Monthly Expense Worksheets (Jan - Dec), an End of Year (EOY) sheet, a Question/Answer (QA) sheet, a Printable Budget summary page (BP) you can print and use as you enter monthly expenses and income values, and a Notes sheet that is unprotected where you can record information you might wish to remember.
  7. Open the example spreadsheet and review how information has been entered and how it displays - as you look through the features list.
  8. It is important to remember that most of the values on these spreadsheets describe expenditures relative to your Net Income.  Consequently, if you enter your Gross Income in the Income Worksheet (IW), and you enter an amount that is withheld every pay period – resulting in a Total Net Yearly (Take Home) Budgeted Income – the income vs. budget displayed in most graphs will NOT reflect expenses relative to your Gross Income.
    However, those calculations are provided on the Budget Worksheet (BW) for reference.
  9. Begin filling in your own budget information on the Empty Worksheet:
    Note: Remember to save your work often while you are working with your budget program so you don't have to re-enter data in the event you have a computer problem.
    1. Income Worksheet (IW) tab: At the top of the worksheet enter the year for which the budget will be used and the starting month you intend to begin tracking all expenses & income.  Part of the functionality of this worksheet is to track expenses and compare them to the budgeted amount.  This will only work with full month entries – all income and all expenses for all months in the budget cycle must be entered into the Monthly Budget worksheets (Jan – Dec as appropriate).  I preset the starting month to 3 (March), but if you have records of all income and expenses for January or February you could reset the value to 1 or 2) - that will be a quick way to become acquainted with the Budget Worksheet and help you see more quickly if your preliminary budget is accurate.
      Obviously, when you start a new year, the Budget Year must match the new year and the "Month Budget Was Started" should equal 1 (January).

      Please note: I have protected (locked) all non-entry cells in the budget program.  If you try to enter a value or text in a "protected" cell, a pop-up will let you know.  The locked cells are to preserve the integrity of formulas that are used to manage data transfer between the different spreadsheets.  Summary information, for example, is frequently locked.  There will be another place to enter the data that will not compromise the data.  If you keep getting cell-locked messaged, review the data entry directions in step #9.
    2. Add any comments (2) or description (3) for each of the income values you plan to enter on the worksheet. Expected bonuses and irregular payments can be added here as well and allocated as described in section (f) below.
    3. Enter each gross income value per pay period for each source of income (4).
    4. Enter the amount of any automatic withholding (5). The withholding amount(s) are not used in the budget worksheet, but are entered to provide a complete, accessible picture of your income.
    5. Verify that the calculated Net Income value(s) (6) are accurate.  This is your "take home" pay.
    6. Enter the number of paychecks a year for each of your income sources (7), 26 for every other week, 24 for twice a month, 52 for weekly, 12 for monthly, 1 or 2 for annual or semiannual bonuses, etc.  If your income is not the same each month, you may want to read the irregular budgeting section.
    7. The amount that will be automatically used in the Monthly Budget will be displayed in column (8)
    8. If you wish, you can change the "Budgeted Income - After Withholding (Take Home)" Category Title (9).
    9. The Category #s 90 - 95 for income used in the regular budget will be used when income is entered into the monthly budget spreadsheets.

      Save your work regularly
    10. Budget Worksheet (BW) tab: This spreadsheet allows entry of the Monthly Budget categories, sub-categories and values. Note that, although you are entering monthly spending plans for various categories, and you have entered monthly income expectations on the (IW) tab, the budget plan you are developing is for the entire year and except for the fixed monthly budget items, expenses in many categories will be variable month-to-month, so you will need enter monthly averages - actual averages if you have them, or estimated averages.

      My first recommendation - before you begin entering budget values - would be to go through the categories and subcategories on the BW and make them fit your specific budget items - you can rename entire categories if the existing categories do not have a sufficient number of subcategories.  One of the limitations of this spreadsheet program is that the basic organization layout has a fixed number of subcategories within any given category - some have as few as three, and others have as many as nine subcategories.

      Next, particularly if you have irregular income, for each subcategory, you may want to notate in the Category Description column how funds in the category will be managed.  You can use these choices or figure out your own classification system.
      (FX) - A fixed monthly expense (rent/mortgage, insurance, cable, Internet, trash pickup, etc.) that you plan to pay with check, debit card or cash.  These category values do not normally change month to month, although some, like trash pickup may be charged every other month.
      (Var) - A monthly expense that is ongoing and fairly regular but somewhat variable month-to-month (groceries, eating out, household expenses, etc.) that you plan to pay with a debit card or check instead of cash.  These categories will probably vary from slightly negative to slightly positive month to month. Many of these expense categories could also use the Cash Envelope system.
      (SSA) - Separate Savings Accounts:  An infrequent, rather large expected/planned expense you need to save for (property tax, non-withheld IRS tax, vacations, Christmas/holiday expenses, car or emergency savings, etc.), that you plan to pay with a debit card or check, but you would plan to move out of your checking account into one or more bank accounts to keep the savings from building up in your checking account and tempting you to spend.  These categories will be treated as monthly expenses, since regular transfers will be recorded as monthly expenditures.  Details of how the money in these accounts is actually spent would need to be managed separately.
      (SFS) - Sinking Fund Savings:  These expenses are similar to the Var category except that there is more variability and less ability to plan, but, unlike SSA categories, the funds are kept in the checking account, accumulate until needed and are managed by the budget program.  This category can include things like home and car repairs that happen randomly, expenses that can vary significantly seasonally like electricity, water bills, lawn and garden purchases, etc. 
      (CE) - Cash Envelope:  Many expenses can be placed in one of the categories above or you can use the CE option. In the same manner as SSA expenses, the entire budgeted amount is removed from your checking account and entered into the monthly expenses, but details of how the money is actually spent would need to be managed separately.
    11. The steps described in sections l - n below are the key to developing a zero-based yearly budget - this differs from Dave Ramsey's zero-based monthly budget because it includes up-front planning to save each month for known expenses that happen irregularly thoroughly the year and for budgeted emergency savings.  As described in the instructions above, you can budget for irregular income by first going through the budget steps using a stable income value to budget fixed and critical monthly expenses.  After your basic budget is established - zeroed out, you can add your irregular income (extra paychecks , expected bonuses, anticipated higher-than-normal commissions, etc.) and re-zero the budget by adding savings categories for planned expenses like vacations, Christmas, etc.
    12. There are four "User Input" columns and an additional column that can be used to input comments:
      On the left are several columns that will display the percentage of your budgeted and total income comprised by each budget entry:
      • The Category Description column contains the main category headers (Charity, Savings, Housing, etc.). Each category name can be changed to meet your needs. You can also add descriptive details to each line within the categories. As described above (and on the BW page), codes can be added to show how each budget item is handled – fixed/variable expenses, transfer to external savings account, budgeted sinking fund category, cash envelopes, auto-pay, etc. – whatever coding helps manage your expenses.
      • The Budget Sub-Categories column contains 73 numbered budget items. The Category Numbers (Cat # column) can't be changed and are used to enter expenses and assign them to specific categories. A number of specific Budget Sub-Category items have already been named, but, like Category Description names, Sub-Category names can be changed as desired. All budget possibilities within a given category do not have to be used - you can use only one or two Savings budget categories, for example instead of the 5 provided.
      • The Monthly Budget Allocation column is where you enter the monthly amount allocated to each budget category.  As values are entered into the specific categories, the columns on the left will keep track of % allocation and the Difference value at the top will decrease to $0.00 at which point the budget allocation will equal the monthly income (the columns will reflect whether the income allocated to your monthly budget is an overall average or is based on SBI income that is not factored into the monthly budget).
      • The Starting YTD Status column is provided as a way to track funds that are in your checking account that you may want to assign to specific categories as part of your initial budgeting process.  As you fill in expenditures throughout the year some categories may have variable month-to-month values.  Consequently, expenses for these categories will routinely vary above or below the monthly expected average – accumulating a surplus, unspent amount in some months and perhaps a deficit in other months. The Current YTD Budget Status column in the Year To Date (YTD) sheet tracks this amount.  The Starting YTD Status column on the Budget Worksheet (BW) will be populated automatically if you choose to use the End Of Year (EOY) content to populate a new year’s budget, but you can use it to pre-populate your new budget category status values as well.
    13. As you begin to enter budget amounts for each category, the "Difference" value displayed at the top of the worksheet will begin to decrease to the goal of $0.00 where budgeted expenses will equal the budgeted amount from the (IW).
      • Note: the $0.00 budget goal (income = expenses) is ONLY for the budgeted income amount you entered.  Any amounts entered into the % Withholding column are not used in the budgeting calculations.

      Save your work regularly so you don't lose your work.

    1. Continue entering monthly budget values until the "Difference" amount = $0.00. Remember, you can rename budget items and add descriptions.
    2. Income Budget Summary (IBS) tab:  This worksheet provides a view of how your monthly allocated expenses (and SBI allocations, if appropriate) align with your monthly budget/income and total yearly income.
    3. Year To Date (YTD) tab: Until a month's expenses have been added, this sheet does not provide much value, but it would be instructive to review some of the examples to get an idea of how the Current YTD Status column can be used as a category-specific sinking fund tracker – as long as the money has not been moved into a separate savings account.
      Remember to make sure the Month Budget was Started at the upper right of the sheet (and set on the (IW) page) displays the month you started entering all of your transaction information.
    4. Monthly Budget Worksheets (Jan - Dec): This process should be relatively straight forward - particularly if you do not change any budget details throughout the year. To the right of the budget summary columns are the Income/Expense entry columns described below. 
      This section is where you will enter each expenditure and deposit throughout the month.  The summary area to the right will enable you to track where expenses in each category stand relative to the budget.
      The Monthly Budget Worksheets only provides accurate information when all expenses and income are known for a month.  I do not recommend starting the monthly tracking process until you have documentation for all transactions for a full month.
      You can sort the monthly transactions by number, date or description if desired. 
      All monthly transactions (income deposits and expenditures) along with allocation category information, dates and other details are entered in the following columns:
      • Category Number - This assigns specific expenditures to the correct categories 1 - 73 and the income deposits to the appropriate categories 90 - 95 (or 96 for SBI income).
      • Income Deposits - The amount of a specific deposit.
      • Expenditures - The amount of a specific expense.  If an expense is canceled - a returned item credited to your debit card, for example - and you need to keep a record of the transactions - you can enter a negative value for the refund using the same category number and the budget will be adjusted accordingly.  Do not put refunds into the deposit column.
      • Payment Type - (optional) the type of expense (or deposit). Was it a check, a debit card, an auto payment, or ??). On the January worksheet you have the option of changing the reminders (in white text in the row above "Payment Type").
      • Date - Date of deposit or expenditure.
      • Details - Any notes you wish to make about any transaction are entered in this column.
      • Category Check - This column is automatically populated so you can double check that the category # you entered for the transaction was correct.
      • Note: If you do not need to keep track of your budget status during a given month - but just review it at month's end, you can enter all of your fixed deposits and expenses at the top of the monthly transaction section and then copy the entire list to the next month - you would then change the dates and make minor tweaks to the values if necessary.  In order to be able to sort them to the top of the list, you can add a number in front of the Details or Payment Type text for these fixed monthly transactions.
    1. As expenses and income values are entered, the monthly worksheet summarizes and displays them by category and/sub-category.
    2. You can change monthly budget/income amounts and category descriptions throughout the year as needed/required (see examples).
      Any changes are highlighted and will be carried over into the following month worksheets. This feature, while helpful to track changing income/budget requirements, can make interpretation of the budget summary sheets significantly more complicated – use with caution.  An advantage of this feature is that budget changes throughout the year will be saved and transferred to a new yearly budget if contents from the old-year (EOY) sheet are copied into the new-year (BW) sheet.
    3. Evaluate the impact of each transaction entered on the affected sub categories and categories - particularly as you begin the process.
    4. End Of Year (EOY) tab: This sheet collects all expense budget information from the December budget worksheet (including cumulative changes in budget categories &/or amounts throughout the year). The intent of this sheet is to allow transfer of budget year-end details to the start of the next year. The income information for the new year, at this time, will need to be re-input, but that is only a few lines. A very important component of this sheet is the "Current YTD" column. This tracks all budgeted accumulations and deficits as displayed in the same-named column on the (YTD) worksheet. After closeout of a year's budgeting process, these columns can be copied, along with the other end-of-budget details, directly into the (BW) tab of the new worksheet to avoid having to re-enter your budget details.
    5. Budget Print (BP) tab:  This sheet can be printed to use as a reference (list of categories, sub-categories, and category numbers) for entering monthly expenses.
  1. This worksheet tracks over/under budget use in relatively minor variable spending categories like transportation, groceries, clothing, medical, personal, and household/yard where one might drive more one month than another, garden in the summer and not in the winter, use more electricity in the winter than summer, etc.

    Categories where large variations in certain sub-categories can be expected like non-withheld tax, car replacement, repairs and maintenance, vacations etc. are also tracked. In some of the sub-categories the unused allocated funds can build up substantially and quickly before they are actually used - saving for a car for example. In other categories like tax savings, an expense (April 15th) can occur early in the year before the budgeted amount can be saved - the intent, of course, will be to have savings carry over from one year into the new year as described in the (EOY) section above. A recommendation would be to use the zero-based cash envelope method to remove funds from your active checking account.

    An alternative for budget items that accumulate large savings would be to establish a virtual "cash envelope" savings account where the money can be transferred and saved until needed. However, whether the money is removed from the budget as cash or moved into a separate savings account, the funds will no longer be tracked in the spreadsheet - these "external savings" must be allocated in the budget as they are extracted.

Good luck.

Randy

http://www.cyber-nook.com/Budget/BudgetWorksheetBasic_2016.xlsx - Empty Worksheet to start your budget:

This Budget Worksheet provides the following features:

  • Manages up to six income sources with the ability to specify the number of paychecks each income receives during the year and how many paychecks there are a year: i.e. monthly = 12; 1st & 15th = 24; every other week= 26.
     
  • Budget and track up to 73 separate user-defined budget items in thirteen categories. If these are not enough, some categories may need to be combined (yard/garden as one category, for example instead of two).
  • Automatic zeroing of the monthly budget expense values (against net income) as they are entered.
  • Provides an automatic display of the % of yearly budget for each budget category and sub-category.
  • Tracks itemized income and expenses for up to one calendar year (January - December) with the ability to start tracking expenses at any month.
  • Provides the ability to view differences in budgeted income vs. expenditures for each category and sub-category for each month. Also provides calculations for budgeted expenses vs. total gross income.
  • Tracks Year To Date (YTD) income vs. expenditures for each category - displays the amount over or under budget for each category & sub-category (Current YTD Status column). The Current YTD Status column provides a monitor of:
    • Surpluses in any categories where YTD budgeted income is greater than expenses. This can either indicate a budget that needs adjusting or a savings category with variable expenses where funds may be accumulating for a planned expenditure during the year.
      - This feature can be used as a category-specific sinking fund to track variable expenses that need to be saved for.
    • Deficits in any categories where expenses are greater than budgeted income. This can either indicate a chronic over-spending problem (and the budget requires adjusting), or in the case of categories where major expenses are irregular throughout the year (taxes, vacations, savings for cars/furniture, etc.) this can mean that an expense happened early in the year before savings had been completed for the item.
    • The YTD tracking feature is designed to give you an accurate picture of your funds at the end of each month. As soon as a new month begins, however, the YTD income fields are populated with the new month's budgeted income. Until all expenses have been added for the current month, the Current YTD Status column will show a month's excess of available cash.
  • Allows modification of budget expense/income amounts throughout the year to match changing circumstances.
  • Enables user to copy the December monthly budget categories/values to the starting budget for the next year.

Example Budget:  This example demonstrate how the spreadsheet works for those with regular monthly incomes (equal payments once or twice a month) or for those who would like to use an average monthly income even though you might be paid weekly or every other week (where several months will have an extra paycheck), or for those who earn irregular pay or bonuses where you still would like to average all income over all 12 months.

http://www.cyber-nook.com/Budget/BudgetWorksheet_Example.xlsx - This example is intended to illustrate various features.

·         This example shows a budget using two salaries:

o   Income 1: $2,400.00 gross | $400.00 withholding (16.7%) | $2,000.00 net per paycheck | 26 paychecks | $52,000.00 budgeted income | $62,400.00 total yearly income.

o   Income 2:  $200.00 | $0. 00 withholding | $200.00 net per paycheck | 12 paychecks | $2,400.00 budgeted income | $2,400.00 total yearly income.

·         In this example allocated funds in the Separate Savings Account (SSA) categories (Not Withheld Income Tax, #4, and Emergency Fund, #5 for example) would be moved from the primary checking account into a separate savings account to remove the funds that are being saved up from the monthly budget funds.  This is not a budget requirement, but it may help some people manage their money.

·         SFS categories home gas (#16) and water (#17) that normally vary throughout the year are illustrated.  You can track their status from month to month.  In a normal budget sheet that progresses through the year, the status of these categories will be tracked on the Year To Date (YTD) sheet.

·         The Maint./Repairs/Tires SFS category (#30) illustrates how funds can accumulate if they are not required.  In this example, the funds budgeted for savings for vehicle maintenance have not been used during the course of the year and can either be moved out of the checking account into a separate savings account until needed or they can be carried over into the next year.

·         The Vehicle license tax SFS category (#31) is $0.00 until July when the full budget amount was spent – even though starting from January only half of the budgeted amount would have been saved – the rest would be saved July through December.  This is an example of starting a budget with some pre-allocated savings in specific categories if possible.  This example shows how $100 that was in the checking account when the budget was created could be allocated to paying the license fees before the full budget collection cycle had completed.

·         The YTD sheet shows that as of November, even though home gas expenses (#16) are high for November, the average monthly expenses have been about $35. 

o   November shows how a budget item can be changed to reflect new circumstances.  New categories can be added, and changes can be made to existing categories – descriptions and amounts. 

o   If you look at the EOY worksheet you will see that the value in category #16 (home gas) will be $35 instead of the original $40 in the BW sheet. 

o   If you populate a new budget worksheet with values from the EOY worksheet, any changes made throughout the year to descriptions &/or values will be copied. 

o   You can, of course, wait and adjust your budget at the beginning of a new year.

·         This budget example is not realistic: values have been chosen to illustrate as clearly as possible how the budget worksheet functions.  In the example many categories that would normally be quite variable have fixed expenditures to match the budgeted amounts and only a couple of categories are manipulated to show how variation in expenses is tracked.
 

http://www.cyber-nook.com/Budget/BudgetWorksheet_Example_a.xlsx - Example budget for first budget pass for irregular income.  This is a very simple illustration of the process of initially using 24 paychecks on the income worksheet page (IW) page (instead of 26) which reduces the monthly amount available for budgeting to $4,000 from $4,333.  On the budget worksheet (BW), all expenses are filled in except for the emergency fund - and the difference between income to budgeted expenses in zero.  Other non-critical budget categories (one or several) can be left at zero during this stage - only the Emergency Fund was selected in this example for simplicity.

 

After the zero budget has been entered with the lower monthly amount, the number of paychecks is increased from 24 to the actual 26 - you could add expected bonus payments, additional periodic income or other income that would bring the yearly total above the basic budget amount.  This example results in a monthly income increased by $333.  Now, since the main budget has been completed with the lower amount, all that needs to be done is decide which categories in which to use the extra income - in this example, since the Emergency Fund was left blank and everything else was covered, the entire amount can be allocated to that category as demonstrated in the complete example.

 

Disclaimer:  This automated budget worksheet was created to meet a personal need of the developer.  The program has been tested thoroughly and appears to be functioning correctly and providing accurate summary values.   Descriptions, instructions and example worksheets have been made as accurate as possible.  However, this worksheet program and all supporting information is provided “as is”.  It is the responsibility of the user to verify that All budgets derived by using any of the provided worksheets are accurate in all respects.  The developer/provider assumes no responsibility for any calculation, functional, descriptive or other errors made by the budget worksheet or for any entry or interpretive errors made by the user of the budget worksheet.  Use of this worksheet implies complete agreement with the stated conditions.