| Miscellaneous Notes: | ||||||||
| 7/31/2008 | ||||||||
| Joe and Terri, I need your suggestions and comments to continually improve our budget projections. | ||||||||
| 2008 / 2009 Specific Notes: | ||||||||
| Pls find attached Village 2008/2009 fiscal year spreadsheet file VillageBudget2007.2008_xxxx2008.xls'. | ||||||||
| Zeroed out spreadsheet, will need to be seeded with the closing numbers from the 2007/2008 fiscal. | ||||||||
| Updated the budget tab with 2008/2009 budget numbers, approved at 06/28/08 Annual owner meeting | ||||||||
| Pls use the Misc. notes box to keep all comments all in same place, can be edited by month | ||||||||
| Assoc. fees changed for 4 bedroom units from $1,068.62 to $1,068.64, all other unit fees stayed the same | ||||||||
| 06/28/08 Survey Billing Cycle Changes | ||||||||
| 324 Angier QTR, previous owner was mon | ||||||||
| Things we have been missing: | ||||||||
| 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 | ||||||||
| 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. | ||||||||
| 07/31/08 - Be careful not to change automated cell, found Monthly Receipt Total and owners name McCullough manually changed in the 2007/2008 P&L | ||||||||
| If an automated cell needs to be manually changed, be certain to add comment of why in the comment box | ||||||||
| 07/3/08 - Pls use the Misc. Notes box more to record the whats and why of expenses, this will help mitigate expense questions | ||||||||
| 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 | ||||||||
| 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. | ||||||||
| Misc. Notes | ||||||||
| 07/31/08 - Jul Q9 cell =M9+N9+O9+P9, verses rest of the months are =M9+P9 | ||||||||