cancel
Showing results for 
Search instead for 
Did you mean: 
JWhidd25
Level 1

Profit and Loss Report

Hello,

 

I wanted to see if there was a way to create a monthly display column report with custom dates in QB Online? I own 5 restaurants and it would be nice to see our period dates together as the year goes on.

If this isn't possible in QB is there a program that will help do this for you?

 

Thank you,

5 Comments 5
ChristieAnn
QuickBooks Team

Profit and Loss Report

Hi there, JWhidd25.

 

Welcome to the QuickBooks Community. I'll share steps that ensure will help you create a monthly display column report with custom dates in QuickBooks Online

 

There are various Profit and Loss reports in QBO to compare your income and expenses for different time periods. With this, I suggest running the Profit and Loss by Month report and customize it. This way, you'll see a monthly comparison of sales or revenues for an entire year.

 

  1. From QuickBooks Online, Go to the Reports tab menu at the left panel.
  2. Choose  Profit and Loss by Month in the search bar.
  3. Go to the Report period drop-down and choose Custom.
  4. Select Months in the Display columns by field.
  5. Hit the Run report button.

 

 

To see additional information on how you can customize various reports and focus on the details that you want to view, you can click on this article: Customize reports in QuickBooks Online.

 

Just in case you want to memorize your current customized report, feel free to check out this article for the detailed steps and details: Memorize reports in QuickBooks Online.

 

Let me know if there are other details you need to see in the report. I'll be happy to assist you again. Have a nice day!

JWhidd25
Level 1

Profit and Loss Report

Is there a way to do this with custom 4 week and 5 week period dates instead of monthly? This same view but for these dates- 12/28/20-1/24/21, 1/25/21-2/21/21, 2/22/21-3/28/21, and so on. It's a 4week, 4week, 5week pattern for the year. Would be great if I could get this monthly view but in the format I need.

DebSheenD
QuickBooks Team

Profit and Loss Report

Hi, JWhidd25.

I understand that you want to customize the date periods in the Profit and Loss report to show 4 and 5 weeks ranges. As of now, we're unable to show that info in the said report. I've got two options to get the details you need.

Option 1: Create a custom report inside QuickBooks for each period and save and memorized that report.

Here's how:

  1. Click Report menu.
  2. Choose Profit and Loss report.
  3. Select the customize.
  4. Edit the columns to by week and hit Run report.
  5. Click Save customization to memorize the report.


Option 2: External reporting apps can be used for more versatile reporting options. You can check for the available apps in Intuit apps store or online.
 

For more details about customizing your report, check out this article: Customize reports and create Custom Summary Reports in QuickBooks


For future reference, read through this article to learn more about how to print a report: Print a report in QuickBooks Online.

Please post in the Community, if you have questions or clarifications in running the Profit and Loss report. We are always here to help.

Fiat Lux - ASIA
Level 15

Profit and Loss Report

@JWhidd25 

Have you explored any BI app as a workaround?

JWhidd25
Level 1

Profit and Loss Report

I have been trying to find some apps to help with what I need, so far I haven't found one that will let you do custom dates for the monthly view. It will just take too much time hand entering or copy and paste all that data.

Need to get in touch?

Contact us