Automation of budget & variance of actual expenses

Hi there Step 1: I am looking at the creating the following via automation to provide a listing of transactions (budget by day) for a 12 month period: 1. Select an expense/income category i.e. Debt (select from 7 categories). I need to be able to manually add catergories 2. Input the name/vendor (Free Text) 3. Budget amount ($) 4. When is income/expense next due (Calendar to pop up to select date) 5. Recurrence/Frequency (weekly, fortnightly, monthly, bi-monthly, quarterly, yearly) 6. Payment/Income Method, i.e. direct debit, manual, send to client 7. Running/cummulative balance of their budget (or bank balance of their budget) The data is to be grouped by category to create a graph by calendar month (budget) including income to stipulate income, expenses and savings for the 12 months (1 total for each in a column graph). Expenses are to be classified as negative number and income as a positive. From the above, I would like to have in the background each transaction listed for the full year by date (by row). The following columns are to be creating by using the above fields to input data: Month Date Method Transaction Category Amount Balance I want to be able to hit a button of some sort that will then create a table of income and expenses for the full year by category and still be able to amend and repeat the above after hitting the summary button to make any necessary changes. See below of what the output should look like, it should be sorted by date. Month Date Method Transaction Category Amount Balance Opening Balance $280.00 Jul 2011 28/07/2011 Send to Client Aussie Loans Debt -$246.00 $34.00 Jul 2011 28/07/2011 Deposit Centre Link Govt Benefit $110.00 $144.00 Jul 2011 28/07/2011 Pay Pay - Loretta Pay $960.00 $1,104.00 Jul 2011 28/07/2011 Cash to Personal A/C Weekly Allowance Personal -$350.00 $754.00 Graph's required: 1. Budget - Stacked bar chart by calendar month (12 months) 2. Budget Expense by category 3. Line graph: Savings balance (using balance column) (to pick up the closing balance for the last day of the calendar month) 4. Actuals - Stacked bar chart by calendar month (12 months) (see below, Step 2) Step 2: From an actuals point of view I want to be able to input actual transactions (expenses/income) for the below fields as they come through. Client ref Client Name Description Category Transaction date Month Amount Balance Note: Transaction date is to be a calendar pop us. Each calendar month, I need a graph that groups the expenses by category and compares the actuals against the budget (from step 1) Step 3: I need to create a section where I can input client information such as: Client Number Individual/Couple Title Client First Name Client Last Name Client Creation Date Client End Date Address Suburb State Postcode Primary ph Secondary ph Email DOB Password Status Sales code / marketing type Personal Account Name Personal Account - Bank Personal Account BSB Personal Account # YCFO Account Name Trust BSB Trust Account # Step 4: I need to create an email alert each time an item is input into step 2, using the information (email) from step 3, using a dedicated email address. Step 5: Monthly report. At the end of each calendar month I need a report to show the closing balance for the month from step 2 and the 4 graphs above on one page (dashboard report) The report needs to show the month the report is for, the 4 graphs and the closing balance as well as my logo. Step 6: Notes section, free text section where I can input notes by date. Please let me know if you have any questions. Thank you