Saturday, June 25, 2011

Profit and Loss - cumulative

Where to put the Profit & Loss Statement


Use a dedicated sheet for the Profit & Loss Statement.

A sample structure of a Profit & Loss Statement


Design the structure for the Profit and Loss Statement as you like.

Explaination on the sample structure of the Profit & Loss Statement



How to fill the structure



Formulas in use



Comparative figures



Checking for error in the Profit & Loss Statement



Checking the final amount of Profit or Loss



3. Use SUMIF function to sum total figures from Trial Balance sheet.

No comments:

Post a Comment