I need to have 3 tables of quarterly historical financial statements Q1-Q4 2012 to through Q1 2014 from the separate xlsm files attached. (You will need to navigate to the Income Statement, Cash Flows and Balance Sheet tabs in each file.) Line items titles would be on the leftmost column, and 9 columns with financial data appearing to the right. Most recent year's data (Q1 2014) needs to be in the far right column
The line items may slightly vary between the years for each of the tabs, so they need to be added accordingly and aligned on the consolidated sheet(s).
Columns for individual historical years may appear repeatedly in the attached files. Each year needs to be included in the consolidated table only once. Do not repeat them.
Let me know if any questions.
36 freelancers are bidding on average $21 for this job
I have 8+ years of IT experience in ERP Finance system. I use to do monthly reconciliation in excel sheets. Prepare the documentation for process flows. I do my work with perfection.