In Progress

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 $[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]

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

Skills: PHP, Software Architecture

See more: would monthly payment, what graph, want create personal logo, want create chart, total bank, step create logo, pop graphs, pay cash account, opening logo free, bank account number, make graph chart, make free graph, logo free creation, logo creation free, link graphs, link graph, want create free logo, graph s, graph data type, full logo create free, free php calendar code, free logo creation marketing, free logo creating, free logo bank, free data input software

About the Employer:
( 16 reviews ) Greenvale, Australia

Project ID: #1155182

Awarded to:

rockerstech

PLEASE FIND OUT SOME OF MY WORK IN PM AND SP. RELATED TO YOUR PROJECT ONLY

$1500 AUD in 40 days
(77 Reviews)
7.6

12 freelancers are bidding on average $1292 for this job

zeke

Dear Customer! I am an expert web developer with over 6 years of experience and very interested in this project. Ready to start immediately and finish as soon as possible. My bid is for fast professional service exc More

$1100 AUD in 10 days
(141 Reviews)
6.8
souvikghosh

Sir, I think I stand a chance here! Please view PM for details!

$1500 AUD in 35 days
(20 Reviews)
5.6
lautaro

Hello! Please check your Private Message Board. Thank you.

$1500 AUD in 30 days
(18 Reviews)
5.3
Emadhal

i can do this.

$1500 AUD in 20 days
(31 Reviews)
5.1
Preethamms

Hi, Pls check the PM

$1100 AUD in 10 days
(14 Reviews)
4.5
teamme

READY TO START IMMEDIATELY, Please check your Pm

$1500 AUD in 45 days
(2 Reviews)
4.4
webmediaw2

Please check pmb

$750 AUD in 30 days
(1 Review)
2.0
nadeemkhan77

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

$1250 AUD in 20 days
(0 Reviews)
0.0
Phyxiusoftwares

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

$1200 AUD in 30 days
(0 Reviews)
0.0
raqibs

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 b More

$1100 AUD in 60 days
(0 Reviews)
0.0
msalman86

I am an experienced developer. I can certainly do this job.

$1500 AUD in 30 days
(0 Reviews)
0.0