How to create a monthly Profit & Loss report in QuickBooks

How to create a monthly Profit & Loss report in QuickBooks

Often, I see the question “how do I create a monthly Profit & Loss Statement in QuickBooks”.  I thought I’d write a quick post to show you how to do it.  You can use this same method on the Balance Sheet if you would like to see it monthly. 1.  Create the Standard Profit & Loss report (Reports > Company & Financial > Profit & Loss Standard).

2.  Change the dates to the year desired (for a calendar year from January 1 to December 31 for the year desired)

3.  Change the Columns to Display to Month (as indicated by the arrow below)

4. Optionally, click Collapse to see just the main accounts and one column for each month

Your report will look like this:You could memorize this report if desired.  Also, you could use this report to create charts or graphs with the trend in monthly sales or net income.  If you use Intuit Statement Writer, you could create a template with the monthly Profit & Loss and charts and graphs which would be linked to the QuickBooks data.  This allows you to reuse the template in future periods or with other clients.  You may want to read about What’s New for Intuit Statement Writer 2011 to learn more about it and how it could help your practice.

21 thoughts on “How to create a monthly Profit & Loss report in QuickBooks

  1. ben

    Is there a way to do a monthly report by class? Specifically, I want to each month and under that each class for that month. I have 2 different classes and I want to tack them each by month in a trend report. So at the end of the year, I would be able to see all 12 months with 2 classes detailed under each. A total of 24 columns.

  2. Janet

    Is there a way to create a monthly Profit & Loss by Job for ONLY jobs that were billed that month?

  3. Joan

    THANK YOU SO MUCH FROM A TIRED NON-ACCOUNTING PROFESSIONAL. AND YES! I”M YELLING!! 🙂

  4. Mary Ellen

    Is there a way to do a monthly report by class? Specifically, I want to each month and under that each class for that month. I have 2 different classes and I want to tack them each by month in a trend report. So at the end of the year, I would be able to see all 12 months with 2 classes detailed under each. A total of 24 columns.

    1. Michelle Long Post author

      It depends on how things are set up — you could create a report of just those accounts or a report of memorized transactions, etc.

  5. Brandi

    Can you add discounts to this PL report. I have saved % disconts under pay bills vendors. However now the discounds do not show up under my PL like they used to when I would break down the expenses in pay bills.

  6. Hilary

    Thanks Michelle,
    Often times we tend to concentrate on what we already know and we end up not exploiting QBs full potential.Tips like this will further quicken the financial reporting exercise as well as enlightening the users of how Quickbooks can be user friendly.

  7. KazooJan

    Just saved me hours of work. Can’t thank you enough! I’ll be back for more tips at budget time!

  8. Robin

    This monthly P/L report tip is great Michelle! Yesterday, a client asked for something exactly like this and I remembered reading this last week and I pulled it out for him and he was so excited! Thanks!

  9. Julia

    As a CPA and running a business you are greatly appreciated for your contributions to LIve Community and the additional assistance you provide with your blogs. Thank you for sharing.

  10. Bill Simon

    Posts like this about monthly reports are always interesting because of their possible inference that business owners are not creating these reports and not getting all the information available to make them more successful. Which always leads me to the next question…What are they using for information?

  11. Cynthia Huber

    I agree – the more we are reminded of even the “simple” things… the more efficient we will become. I totally forgot about expand/collapse and it is really handy. Thanks Michelle.

  12. Denice Hogan

    Michelle, thank you for sharing these great tips. The more information that we learn from one another, the more efficient we become, and ultimately raising the level of service to our clients!

  13. Pingback: Tweets that mention How to create a monthly Profit & Loss report in QuickBooks | Long for Success -- Topsy.com