Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Johnnysiii
Level 1

Budget reports

We are in planning season for 2025 and I want to run a report that compares next year's budget with this years actuals (2024).   I am working with the report "Budget vs Actual", but I cannot figure out how to select a date range for the Budget (2025 or "next year") and a separate date Range for the Actual (2024 or "this year").   This seems like it would be such straightforward methodology, but I cannot figure it out.   Please help. 

1 Comment 1
KimberlyS
Moderator

Budget reports

You can create a report for the years 2024 to 2025, Johnny. Allow me to discuss this further and guide you through the step-by-step process.

 

Selecting a different date range for budget (2025) and actual (2024) is currently unavailable in the Budget vs. Actual report. Alternatively, you can generate data starting from 2024 to 2025. Since this will show both the budget and the actual for the same years, you'll want to export it and manually remove the unnecessary columns.

 

Here's how:

 

  1. Head to the Reports menu at the top.
  2. Select Budges & Forecasts, then Budget vs. Actual.
  3. Choose the budget to use and click Next.
  4. Pick a layout, hit Next, then Finish.
  5. Click the Customize Report tab and select Custom in the Dates dropdown.
  6. Set the appropriate date range in the From and To fields.
  7. In the Display columns by, choose Year.
  8. Uncheck the $ Difference and % of Budget check boxes.
  9. Hit Ok.

 

Budget vs. Actuals.jpg

 

After that, refer to this material for guidance on exporting the report to decide which data to display on your file: Export reports as Excel workbooks in QuickBooks Desktop.

 

Moreover, consider memorizing your reports to save their current settings. This will prevent you from going through the same customization process when you need the same data in the future.

 

Update us anytime you need further assistance creating reports in QuickBooks Desktop. We're here to help you and address any questions you may have.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us