Create a P&L report with comparisons versus BOTH the budget and prior year?

Good day, rmcneill.

QuickBooks Desktop doesn't have a report showing with Actual vs both previous year and versus budget that includes dollar and % variances for both.

Alternatively, you can export both reports to Excel and merge them from there while filtering the information you need. In case you need steps in running the two reports, you can follow the steps below:

Budget vs. Actual:

1. Go to Reports.
2. Click Budgets & Forecasts.
3. Choose Budget vs. Actual.
   
   
   

Profit & Loss Prev Year Comparison:

1. Go to Reports.
2. Click Company & Financial.
3. Choose Profit & Loss Prev Year Comparison.
   
   
   

To export the reports:

1. Go to the Reports menu and open any report on the list.
2. Select the Excel button. All export options, including Excel, should be available

To know more about running budget reports in QBDT, you can check this article: Create a budget or forecast in QuickBooks Desktop

Find out more about managing reports in QuickBooks Desktop through the following articles:

• Understand reports.
• Customize reports in QuickBooks Desktop.

If you need other helpful articles in the future, you can always visit our site: Help articles for QuickBooks Desktop.

Feel free to drop a comment below if you have any other questions. I'm always happy to help. Have a good day.

Hi, rmcneill.

Hope you’re doing great. I wanted to see how everything is going about creating a report for P&L report with comparisons versus both the budget and prior year you had the other day. Was it resolved? Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at any time.

Looking forward to your reply. Have a pleasant day ahead!

Hi,

Is there a way in Quickbooks to get this report generated for current YTD, Budget YTD and prior YTD (for the same month we are running the report?  i.e. 5/31/24 YTD and 5/31/23 YTD.

Thank you

There isn't a direct way to pull up the budget year-to-date report specific for May 2023 and May 2024, PeterD1. No worries, I can share some workaround on how to do it QuickBooks Desktop.

We can manually pull up a Budget report and sort them by custom date. After that, export it to an Excel file.

Here's how:

1. Navigate to the Report menu, then the Report Center.
2. Locate or choose the budget report you want to export.
3. Pick the Excel dropdown, then Create New Worksheet or Update Existing Worksheet. 
4. In the Export to Excel screen, click the Export button.
5. Lastly, choose where you want to keep the file.

Once done, you can add columns to compare data within one sheet.

Moreover, you'll need guidance on how to customize your financial reports, visit this article for your reference: Customize reports in QuickBooks Desktop.

Additionally, QuickBooks can save your data by memorizing reports. It allows us to generate this report automatically at any time.

Rest assured, I'll help you with financial and budget report preferences and other QuickBooks-related cases. Stay safe!

can this be done in Quickbooks Online? (current YTD, Budget YTD and prior YTD)

And without doing extra steps in Excel.

can this be done in Quickbooks Online? (current YTD, Budget YTD and prior YTD)

And without doing extra steps in Excel.

Currently, you still have to export the Budget vs. Actuals report to Excel to see the current YTD, budget YTD, and prior YTD in one report, AJC_7.

We're committed to delivering a product that our customers can consistently rely on for their business. Having a built-in report that shows this information will surely enhance the user experience and be very helpful. Let's forward this product suggestion straight to our engineers for inclusion in upcoming releases.

Here's how:

1. Head to the Gear icon and choose Feedback under Profile.
2. Share your comments or product suggestions.
3. Click Next to submit.
   
   

To stay updated on the most recent product updates and improvements implemented by our engineers, we invite you to explore the QuickBooks Blog. In case you need guidance on how to create the Profit and Loss budget and Balance Sheet buget report, open the following link for detailed instructions: Create budgets.

If you wish to save the customization settings in your report, follow the instructions in this article to carry out this task: Memorize reports in QuickBooks Online.

Visit the Community if you have other product-related concerns or questions on how to generate reports in QBO. We'll get back to you and provide the assistance you need.