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:
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 $[url removed, login to view]
Jul 2011 28/07/2011 Send to Client Aussie Loans Debt -$[url removed, login to view] $[url removed, login to view]
Jul 2011 28/07/2011 Deposit Centre Link Govt Benefit $[url removed, login to view] $[url removed, login to view]
Jul 2011 28/07/2011 Pay Pay - Loretta Pay $[url removed, login to view] $1,[url removed, login to view]
Jul 2011 28/07/2011 Cash to Personal A/C Weekly Allowance Personal -$[url removed, login to view] $[url removed, login to view]
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)
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)
I need to create a section where I can input client information such as:
Client First Name
Client Last Name
Client Creation Date
Client End Date
Sales code / marketing type
Personal Account Name
Personal Account - Bank
Personal Account BSB
Personal Account #
YCFO Account Name
Trust Account #
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.
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.
Notes section, free text section where I can input notes by date.
Please let me know if you have any questions.
12 freelancers are bidding on average $1292 for this job
Dear Sir, We have done lot of work on international projects and have provided best solution to our clients and have long term relationship with them. Please see your PM
Dear sir, we are a reputed softwareindustry providing solutions all over the world.We believe in best quality and customer satisfaction and we assure you for longterm relation with us.Please see your PM