Income statement raw data consolidator

Income statement raw data consolidator is project number 238848 posted at GetAFreelancer.com. Click here to post your own project.

Status:	Closed (Selected Service Provider)
Selected Providers:	selected service provider carlestops
Budget:	$30-250
Created:	03/18/2008 at 8:07 EDT
Bidding Ends:	03/28/2008 at 8:07 EDT
Project Creator:	pminuk   Buyer Rating: (2 reviews)
Description:	My company runs each of it’s “segments” via Quickbooks online. I need a way to consolidate, compress and simplify the data into a better organized format to present to my superiors. I would like an Income statement overview + 1 key “supporting schedule” (I have tried to create an example) Ideally if each line on a primary “top sheet” was supported by a pivot table which contained the “realms of mindless data” I would be satisfied. For instance at the top level I need a simplified income statement. At the 2nd level I need a key schedule of cost overview by segment; additionally it must show my unit cost (per oz) I need to be able to plug in the data from various QuickBooks generated excel statements to make this work. I have no issue with having to sub organize if need be. My 2 business segments run separate sets of books that need to be combined. I have my “Direct costs” (anything “cogs” relating to my mining operation) I have my indirect or overhead costs (essentially all other costs Part 1 from mining part 2 from my admin office both of whom have separate books that need combining) I am including a sample of “what I want” + a few examples of the kind of data I have available to me. I can designate which expense category the items belong to, but have tried to code them COGS or Admin to assist. I figure if a separate worksheet is used for each “category” it will be easy for me to simply plug in data later on. Best of luck Additional files submitted: help me-3.xls
Job Type:	Excel
Database:	(I don't know)
Operating system:	MS Windows
Bid count:	21
Average bid:	$ 121