Automation of budget & variance of actual expenses
$750-1500 AUD
Selesai
Dibuat lebih dari 12 tahun yang lalu
$750-1500 AUD
Dibayar ketika dikirim
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
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
We have also business professional as consultant which make us best out put in this kind of similar job.
We are experiencing 5+ years in consumer goods marketing company automation. I attached a pic of our work. We believe you will never understand convenience of using our software. I can understand your difficulties and inconvenience. Please try our software before make any decision. To try 1 please add my skype name raqibul.
Thank you