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