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