Saturday, June 25, 2011

Profit and Loss - monthly

Where to put the monthly accounts

Location 1 - In a separate sheet, all by itself.
Location 2 - In a separate sheet, together with other months analysia.
Location 3 - In the same sheet with the cumulative Profit & Loss Statement.

sample structure

Special attention to items

Opening Stock
Closing Stock
Cumulative Profit and Loss Brought Forward

Formulas in use

Use SUMPRODUCT function

No comments:

Post a Comment