Cancelled

Financial Reporting Dashboard

I have several cost centres that I manage for a company. Each month we receive a report on how the cost centres are reporting. I want to create a "dashboard" view of each of the cost centres, the major parameters using a macro such that when I load a new report into the excel, I can run the dashboard view and it automatically updates with new information, comparing year on year, month on month and a summary of the key performance indicators. I want it to come up with graphics of the key indicators on the cost centre and also the detail behind it summarised within excel. (usingMicrosoft Excel 2010).

Please send example work so I can see what you would be able to create here.

Attached here is an example of what we currently get.

Each month is a report issued for year to date. The first tab is the summary of all the cost centres. We can then request the detail for the year which has costs in and out, accruals etc. I want to be able to pull the detail out of the detailed pages in an efficient way, using the macro to get it to highlight the key areas.

Skills: Excel, Finance, Payroll

See more: financial reporting dashboard, dashboard financial reporting, excel financial dashboard reporting, excel financial dashboard, excel dashboard financial reporting, financial dashboard excel, Financial report, finance report excel dashboard, Dashboard, dashboard for company, load excel, dashboard report, finance excel macro, excel report macro, company dashboard, report dashboard, finance reporting, dashboard excel using, macro report, key performance indicators excel, excel create macro, performance report company excel, macro dashboard, company performance report excel, performance dashboard excel

About the Employer:
( 1 review ) Reigate, United Kingdom

Project ID: #1281952

21 freelancers are bidding on average £159 for this job

nagybatonyi

Such jobs are my daily practice. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing o More

£200 GBP in 7 days
(38 Reviews)
5.3
vbexcel

Excel/VBA expert with over ten years of hands on financial management experience.

£160 GBP in 2 days
(25 Reviews)
5.2
Krusche

Our quote is not only for a qualified solution in terms of business analysis but a very advanced and user friendly interface to quickly obtain the needed slices of information.

£240 GBP in 4 days
(21 Reviews)
5.1
FIBIN

Hi, I am an expert in Excel and VBA Programming in Excel. I have lot of experience handling report generation and dashboard project. I am interested to work for your project. Please see my PM for more details and th More

£100 GBP in 5 days
(37 Reviews)
5.1
binaryromel

##### Experienced! Please check PM. #####

£175 GBP in 4 days
(34 Reviews)
4.9
SaraHailes

UK qualified accountant with over twenty years financial reporting and Excel experience. I've already built a similar model for another client. Please see PMB for further details of bid.

£200 GBP in 2 days
(4 Reviews)
3.9
jadinv

Hello, I have an extensive financial background -- both academically and practically -- with an equally extensive programming background. Specifically, Excel automation is something that I have done many times -- p More

£200 GBP in 14 days
(1 Review)
2.8
SilviaT

Please check PM.

£150 GBP in 10 days
(5 Reviews)
2.4
LIMEXS

Please, check my PM.

£200 GBP in 3 days
(3 Reviews)
2.2
guevanjr

Please consider my bid. Thanks

£60 GBP in 3 days
(2 Reviews)
1.9
RedPeaceEU

Please check PM

£200 GBP in 5 days
(0 Reviews)
0.0
mgm05267

Experienced in Dashboard creation & Data consolidation of 75000 entries

£75 GBP in 1 day
(0 Reviews)
0.0
online2610

Hi Sir, I read your all of the details of your Project. I have two years experience as a virtual assistant, and I am able to do this project in less days... Please read PM... Thanks

£100 GBP in 10 days
(0 Reviews)
0.0
amargandhi

Hello, Professionally, I am a Project Manager at a Financial Institution. I have created (Project, Program, Financial) dashboards templates for two major banks in Canada. I have previous experience in creation of t More

£150 GBP in 5 days
(0 Reviews)
0.0
ValentinAnd

I have extensive experience working with Excel I think you want something like

£100 GBP in 3 days
(0 Reviews)
0.0
Alishanuj

Please check my PM..

£100 GBP in 2 days
(0 Reviews)
1.4
gaganbijan

Hello Please view PM. Regards Gagandeep Singh Bijan

£200 GBP in 3 days
(0 Reviews)
0.0
aviket

Sir, Word/Excel macro expert here !!! Please view private message.

£175 GBP in 10 days
(0 Reviews)
0.0
Dashalytics

I understand that you need KPI reporting for your monthly call center data displayed in an Excel dashboard format. I have developed many excel spreadsheet dashboards that have included multiple data sets with over 25 More

£200 GBP in 2 days
(0 Reviews)
0.0
isaacattias

I have many years experience doing financial reporting

£100 GBP in 6 days
(0 Reviews)
0.0