A sample P&L Format in Excel
 
An Excel based sample of what a Monthly Operating Statement (often called the P&L) should look like.
 
This is the format you are looking for in creating your report. NOTE: This is a sample format only.  It does not contain any formulas, and is not intended to use as YOUR report. 
 
We can help you with developing a report for actual use if you would like.