In Progress

Income statement raw data consolidator

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

Skills: Excel

See more: income statement raw data, quickbooks consolidator, raw data income, income statement pivot table, pivot table income statement, income raw data, data consolidator, top segment, top data, segment table example, segments line, quickbooks admin, primary data, online business easy way, want line business, expense items, cost format, business income statement, best online income, best income online, admin mining, line segments, sample income statement excel, business raw data excel, quickbooks sample income statement

About the Employer:
( 2 reviews ) toronto, Canada

Project ID: #238848

Awarded to:

carlestops

Hello Pminuk.. I can do this. 10 yrs of Accounting and 6 years of Excel-VBA, VB and Access solid experience. check PM

$125 USD in 3 days
(0 Reviews)
0.0

21 freelancers are bidding on average $121 for this job

AmitKumarCal

Hi, Check PM

$250 USD in 10 days
(2 Reviews)
3.4
BALAJOJI

Hi, I have strong experience in accounting/finance. I have good knowledge of cost accounting. If given chance to work with you, I will deliver the project within the time you specify. Joji

$150 USD in 10 days
(0 Reviews)
0.0
excelexpert

I am an IT professional by having my Bachelor and Master degrees in Computer Sciences. Above all I am also working as a system engineer in NADRA (National Database and Registration Authority) Pakistan the biggest organ More

$100 USD in 10 days
(0 Reviews)
0.0
raoshahbazali

i want to this job. i am the best for it.

$110 USD in 5 days
(0 Reviews)
0.0
bilalbinrais

i am quite expert in such tasks

$40 USD in 2 days
(0 Reviews)
0.0
koushik1977

I can do the project very quickly.

$50 USD in 2 days
(0 Reviews)
0.0
aamirsayeed2000

plz accept my bid

$100 USD in 20 days
(0 Reviews)
0.0
richardson2008

i want thwe job

$100 USD in 2 days
(0 Reviews)
0.0
Jo03alsph

I know excel very well, i can help u to organize the format. REGARD

$50 USD in 1 day
(0 Reviews)
0.0
Pudipeddi

I promise u that i will do what u want

$30 USD in 10 days
(0 Reviews)
0.0
kingbill

Sir, I could see your requirement in GAF.com. I 'm interested in the offer. I possess 13+ years experience in office works, especially in finance industry at different levels and had good skill in Data analyzing More

$100 USD in 7 days
(0 Reviews)
0.0
ultimate21

HI, I AM INTERESTED TO DO THE JOB NEATLY AND CORRECTLY. I HAD SEEN YOU SAMPLE. IF YOU WISH I CAN DO THE SAME AS SAMPLE.

$165 USD in 10 days
(0 Reviews)
0.0
ankur1979

Hi, I am interested in doing your work. I am an MBA in Finance and have 3.5yrs of Industry experience in Financial Planning & Analysis, Forecasting, MIS reporting etc.

$150 USD in 7 days
(0 Reviews)
0.0
Jyotilsavi

Dear Sir, Please give us a chance to project for you and will see our proficiency and accuracy in this project. Thanking You Jyoti Prakash

$120 USD in 5 days
(0 Reviews)
0.0
sidhun

I'll do this..

$110 USD in 15 days
(0 Reviews)
0.0
nasucuroz

Hi! I'm very interested in your project and I'm ready to start as soon as possible.

$150 USD in 8 days
(0 Reviews)
1.4
khfaisal

Hi, I have expeience o working in Accounnts / Finance and especially in developing and interpreting the financial statements for teh last more than 15 years. And is very conversent in using excel. Hope to complete t More

$175 USD in 4 days
(0 Reviews)
0.0
ciels007

I believe I can have this done in excel file. I have advanced knowledge in this skill. thanks.

$190 USD in 3 days
(0 Reviews)
0.0
RajshreeDugar

i can do this

$250 USD in 2 days
(0 Reviews)
0.0
Khanz

I am ready to do this job.

$30 USD in 3 days
(0 Reviews)
0.0