Profit/Lost

Job ID: 35953137

Budget: $250 – $750 CAD

I get reports in excel for hundreds of projects worked on by my team for a given month. The excel reports the same 7 headers for Job # / Job Description / Labor / Material / Total Costs / Revenue / Income / Mark Up %

Once the excel report is created, I want to be able to import the nexts months job details and it would show me the p&l of each project. You might have a project that goes for say 7 months. So each month the relevant charges will be added to report, but I would still be able to see the overall p&l.
I have issues with projects completed 6 months ago that have expenses charged them months later.
Related categories: Data Processing Data Entry Accounting Excel Finance