| Miscellaneous Notes: | ||||||||
| 8/21/2006 | ||||||||
| Joe and Terri, I need your suggestions and comments to continually improve our budget projections. | ||||||||
| Village Fiscal Year Quarterly Breakdown: | ||||||||
| -Q1 July/Aug/Sep | ||||||||
| -Q2 Oct/Nov/Dec | ||||||||
| -Q3 Jan/Feb/March | ||||||||
| -Q4 April/May/June | ||||||||
| General rule of thumb for spreadsheet | ||||||||
| -If the font is colored is should not be changed | ||||||||
| -Balances are propagated from one month to the next | ||||||||
| -Monthly Assessment fees all reference the Unit Tab | ||||||||
| -Need date in file name | ||||||||
| -Unit Owner names all reference the Unit tab | ||||||||
| -Change the date on the Village Finical spreadsheet each time it is saved | ||||||||
| -Change the date on the Unit, budget tab if modified | ||||||||
| -Change Expense categories only from budget tab | ||||||||
| -Do not modify the owner name on the monthly tabs, Unit tab updates all | ||||||||
| -Keep all tabs saved in the A1 position | ||||||||
| -Avoid using Misc. expense | ||||||||
| 2006 / 2007 Specific Notes: | ||||||||
| Pls find attached Village 2006/2007 fiscal year spreadsheet file 'VillageBudget2006.2007_000006.xls'. | ||||||||
| Pls use the attached template moving forward from 07/01/06 for the started of Village fiscal year | ||||||||
| Zeroed out spreadsheet, will need to be seeded with the closing numbers from the 2005/2006 fiscal. | ||||||||
| Expense categories are in alphabetical order - New for 2006/2007 | ||||||||
| Updated the budget tab with 2006/2007 budget numbers, approved at 06/24/06 Annual owner meeting | ||||||||
| Change all expense categories from budget tab only, will propagate to other months - new for 2006/2007 | ||||||||
| Added Misc. notes box to keep all comments in same place, can be edited month -- New 2006/2007 | ||||||||
| 06/24/06 Survey Billing Cycle Changes | ||||||||
| 327 Thibault QTR to MON | ||||||||
| 326 Foti QTR to MON | ||||||||
| 226 Donahue MON to QTR | ||||||||
| 125 Hempey QTR to Mon | ||||||||
| 322 Arnold QTR to MON | ||||||||
| Updated Unit owner names | ||||||||
| Updated Unit Insurance cost $12,352 2006/2007 premium | ||||||||
| The assessment fees have been updated and have changed for all owners, as insurance cost has gone up | ||||||||
| Water and Sewer Expense category now is Storm Water Permit | ||||||||
| Things We Miss: | ||||||||
| Keep all tabs saved in the A1 position, causes issues when posting to web | ||||||||
| Avoid using Misc. expense | ||||||||
| Property Agent 10% should be included with repair cost, not split out, not in prop agent fees | ||||||||
| Fire Sprinkler repair and monitor cost should be split out | ||||||||
| General Usage Info: | ||||||||
| Only change owner names, assessment costs, and insurance cost from the unit tab, these values will be automatically pushed out to the monthly tabs. | ||||||||
| If the unit tab is updated, ie new owner, change the date upper left corner, in this way we have revision history | ||||||||
| Change all expense categories from budget tab only, will propagate to other months - new for 2006/2007 | ||||||||
| Use the comments on the budget tab as guidelines to what costs should go in what category. | ||||||||
| Avoid using Misc. expense | ||||||||
| Keep in mind bank loan is Bank payment + Contractor payment | ||||||||
| Keep repair and monitoring/inspection/fixed cost split out on fire sprinkler expenses. | ||||||||
| If the font is in color, we should probably not be changing it | ||||||||
| File Naming Conventions: | ||||||||
| Note the last portion of the file name is a date, this portion of the file name should change with each distribution of the spreadsheet. | ||||||||
| This is important for disaster recovery and for my archiving of the documents. | ||||||||
| Keep all tabs saved in the A1 position. | ||||||||
| Future Enhancements: | ||||||||
| Special Assessment not in column Q total formulas | ||||||||