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

Budget Question

We are using Quickbooks Desktop 2019.  We made a budget by manually entering in all the figures.  When we print the budget out, there are five accounts that have been included on the budget report that have been inactive for the current year, but when doing some investigating, the figures associated with those specific five accounts are actual 2019 amounts.  We are confused as to why they are showing up on the budget report when setting up the budget these accounts were not included and why they would pick up the 2019 amounts.

1 Comment 1
ReyJohn_D
Moderator

Budget Question

Let me get you back on track, @GloriaDuda.

 

The Budget report will show the inactive accounts if:

 

  • The fiscal year is incorrect.
  • It contains the previous year's actual data.
  • These accounts have transactions for the reporting period.
  • The date and accounting method filters selected when running it.

I can share the steps needed to fix the issue you're getting. First, let's ensure to select the correct fiscal year before setting up your budget report.

 

Here's how:

 

  1. Go to the Company menu.
  2. Select My Company, and then click the pencil icon.
  3. Choose Report Information, and then make sure the first month of your fiscal year is correct.
  4. Click OK when you're ready.
    d690.PNG

To learn more about it, please review this handy article: Create a budget in QuickBooks Desktop.

 

Second, please check if the said report contains the past year's actual data. In your case, you may have copied or included the previous year's (2019) info that has the inactive accounts.

 

If this is the case, then the report will pick up the 2019 details of your five inactive accounts.

 

Third, please ensure to choose the correct date and accounting method filters. To do that, you can select one from the Dates and Report Basis drop-down, respectively. See the screenshot below for a visual guide:

 

Lastly, we can customize your report further to ensure only the active accounts will show up. Here's how to do it:

 

  1. Go to Reports, and then choose the desired budget report from the Budgets and Forecasts section.
  2. Click the Customize button, and then go to the Display tab.
  3. Select the Advanced button.
  4. Choose Active for the display columns and rows, and then choose Fiscal year as the reporting period.
  5. Click OK twice to confirm.

You can also memorize the said report. This way, you can save it for later use.

 

You can count on me if you need more help with managing your reports in QuickBooks. Have a good one.

Need to get in touch?

Contact us