| Miscellaneous Notes: | ||||||||
| 7/30/2007 | ||||||||
| 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 | ||||||||
| 2007 / 2008 Specific Notes: | ||||||||
| Pls find attached Village 2006/2007 fiscal year spreadsheet file 'VillageBudget2007.2008_000007.xls'. | ||||||||
| Zeroed out spreadsheet, will need to be seeded with the closing numbers from the 2006/2007 fiscal. | ||||||||
| Updated the budget tab with 2007/2008 budget numbers, approved at 06/30/07 Annual owner meeting | ||||||||
| Pls use the Misc. notes box to keep all comments in same place, can be edited month -- New 2006/2007 | ||||||||
| Assoc. fees changed for 4 bedroom units from $1,068.58 to 1,068.62, all other unit fees stayed the same | ||||||||
| 06/30/07 Survey Billing Cycle Changes | ||||||||
| 125 Hempey MON to QTR | ||||||||
| 327 Williams MON to QTR | ||||||||
| 328 Brigham QTR to MON | ||||||||
| Updated Unit owner names | ||||||||
| The assessment fees have been updated and have changed for all owners, as insurance cost has gone down and Assoc. fees went 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. | ||||||||