Skip to main content
R
rmcneill
May 20, 2021
Question

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

  • May 20, 2021
  • 2 replies
  • 0 views

I know there's a report with Actual versus Previous Year (including dollar and % variances), AND there's a separate P&L report for Actuals versus Budget (including dollar and % variances).  But with several companies over my career I've been used to being able to generate ONE report with Actual vs BOTH Prev year AND versus Budget, including dollar and % variances for both.  Is it possible to create a custom report in this format?

2 replies

C
Charies_M
May 20, 2021

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:

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.

C
Charies_M
May 22, 2021

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!

P
PeterD1
June 28, 2024

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

C
ChristineJoieR
June 28, 2024

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!

Terms & ConditionsAccessibility statement