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

budget vs actual report issue

I need to produce a p&l that includes a month as well as ytd. The issue is that I need to go back to the month of October 2020. When I run the report it gives me only October in the ytd if I choose that month for the report. If I choose ytd it picks up any transactions that have been done since October in the ytd. 

Can I get a budget vs actual for the month of October that gives me a yearly budget but does Not include transactions since October?

4 Comments 4
JamesDuanT
Moderator

budget vs actual report issue

Let's customize your reports to get the data you need, jstahl.

 

There's a possibility that the First month of fiscal year is October in the Account and Settings. Hence, the report only displays October transactions. Here's how to review the company settings:

  1. Click the Gear icon in the upper-right corner and select Account and Settings.
  2. Select the Advanced tab and go to the Accounting section.
  3. From there, you'll see the First month of fiscal year.
  4. Click Done if there are no changes.

For your Profit and Loss report, we can change the Report period and displayed columns to display the data by month. Here's how:

  1. Click Reports on the left menu and pull up the Profit and Loss.
  2. Change the Report period to Custom and enter the date range.
  3. In the Display columns by field, select Months.
  4. Click Run report.

Meanwhile, your Budget VS Actuals report will show the transactions if they are available within your register. Hence, we cannot exempt the October transactions while displaying the budget of the same month. Instead, we can export the report to Excel and customize it there. Here's how to do it:

  1. Open your Budget VS Actuals report.  
  2. Click the Export option (paper icon) and select Export to Excel.
  3. Save the file and open it through Excel.
  4. Customize the data.

You can use these links for reference when running and customizing reports in QuickBooks Online:

We'll be right here if you need additional assistance in getting your data through reports.

 

jstahl
Level 1

budget vs actual report issue

All the settings are correct. October is the first month of the fiscal year. The issue is when I go Back to run the October vs actual. When I include the total budget, the higher ups want actual budget just thru October (and as it stands it includes all entries including any made in November, December, etc.). 

jstahl
Level 1

budget vs actual report issue

The first month of the fiscal year is October and all settings are correct.  The issue is that they want me to go back and run October P&L and include budget vs actual. It includes all entries in QB since then (November, December) not just October. So I can either do a report with Just October and it gives me just that month's budget Or the fiscal year which includes all entries since then.

Trying to figure out how to give them the report they want.   

Pabz_L
QuickBooks Team

budget vs actual report issue

Hello there, @jtsahl.

 

 I understand that it would be easier to customize a report in QuickBooks Online t to show to them a specific account or customer format/layout. However, we cannot exempt the October transactions on a report while displaying the budget of the same month. 

 

 As a workaround, you can export the report to Excel and customize it there. To do that, you can follow the steps above.

 

I’ve added an article where you can get more information on customizing reports in QuickBooks: Customize Reports in QuickBooks Online.

 

Please let me know how it goes. You can also share your screenshot in this thread, and I'll get back to you as soon as possible. Thanks.

Need to get in touch?

Contact us