I have entered my budgets for our new fiscal year and when I create a new Profit & Loss Budget Overview report, it's including three old and inactive accounts (& their past budgets) that haven't been used in at least 3 fiscal years. This is the first year this has happened and my software is up-to-date.
I'll help you remove the inactive account from your Profit and Loss Budget Report.
The only time an inactive account will show up on your report, is when it contains a transaction dated for the new fiscal year. With that said, let's take a closer look in each of these accounts individually and check if we can find any of these transactions.
Allow me to guide you through the process:
Once you've found the transactions using the wrong date, you can either edit them and enter the right date, or delete them. After this, try to pull up the report again and check if you can still see the inactive accounts.
Let me know how it goes. I'll be here if you need more help removing these accounts from the report.
This is also happening to me on P&L reports. These old accounts are inactive and have no transactions for the current fiscal year. There is a closing entry for fiscal year end 2016 if I change the date range of the Account QuickReport.
Does the closing entry cause the issue?
I'd be glad to help you run the Profit & Loss Budget report excluding the inactive accounts.
You may need to filter the report to just include the active accounts and exclude the inactive accounts. Let me show you how.
That would allow you to run the report with all active accounts. Feel free to add a comment below if you have any other concerns, we're always here to help. Have a wonderful day!
Yes, selecting your active accounts under the Multiple accounts filter works, but it's cumbersome. Too bad QB doesn't have a checkbox to select only active accounts. It would save a lot of time if you have a lot of accounts.
I can see how that checkbox will make your work faster, rogerlautz1746.
I'll share this idea with our product development team. I would also encourage you to send one from QuickBooks. You can click on the Help menu and choose Send Feedback Online.
Feedback makes us aware of the options our users need to add convenience to their work.
If you have other questions in mind, you can go back to this thread.
For now, you'll have to filter the report to remove the inactive account, cchoabookkeeper.
Just click Help, Send Feedback Online, and then Product Suggestion.
Visit us here anytime if you need help with anything else.
If you Customize the Budget vs Actuals report by clicking the Advanced button and select "Non zero accounts", you will find the inactive accounts disappear. Using the "Multiple Accounts" filter could cause problems if you forget to change the report after a new account is added. This is what I have used to get around the issue. In the Advanced section, you will see a radio button for "All Active Accounts" which doesn't seem to work, hence using the "Non zero accounts" does work.
As far as I'm concerned, this is a bug in QB desktop and should have been fixed long ago.
If you Customize the Budget vs Actuals report by clicking the Advanced button and select the "Non zero" accounts under "Display Rows" and save the changes, you will find that the inactive accounts disappear. On the Advanced screen, you will see a radio button under "Display Rows" for Active accounts only but this doesn't work. I suspect this is a bug in QB desktop.
Filtering the Accounts to select only active accounts, is cumbersome and can cause problems if a new account is added and you forget to update the "Multiple Accounts" filter.
Hope this helps.
I agree with kathy_graysls. The inactive accounts won't show in the Profit & Loss Budget vs. Actuals report after changing the Advanced filter. To identify why it is still showing up, you can verify the inactive account's register. Check if there are transactions created within the customized date of the report.
If the inactive account will still show on the report, let's try to verify and rebuild data to fix the issue.
I'd be here if you need further help.
Two of the inactive accounts that show up on my report shows amounts budgeted for a similar account. For example, we have 48000 and 61500, both labeled "Music"; 61500 was put in our budget , 48000 was made inactive and hasn't had activity in 4 years. The Budget v Actual report shows both accounts and identical amounts in each column. For some reason they're linked and I can't get rid of either one of them.
Hi there, RoxanneT.
Thanks for dropping by the Community space. Allow me to chime in for a moment and clarify why you’re unable to remove one of the accounts on the Budget vs. Actual Report.
Inactive accounts are only removed from the Chart of Accounts, and other areas where you can choose them. If the account contains transactions, they remain as part of your company data.
While we don't have any reported issues about this, let's run the Verify and Rebuild Data Utilities to get this sorted out. The Verify Data utility identifies any potential data damage issues that might've caused the accounts to show the same amount on the report.
On the other hand, the Rebuild Data utility repairs damaged data in your company file.
Before this process begins, please secure a backup copy of your company file.
To Verify data:
To Rebuild Data:
For additional about the process check out the Verify and Rebuild Data in QuickBooks Desktop article.
These steps should help you run the report showing the correct information.
Let me know if you get the chance to try all these suggestions and what the results are. I'll be right here with you.
Were you able to resolve this issue? I am having the same problem. Inactive accounts from two years ago are showing up on budget reports with an old budget amount. The reports were pulling from our current fiscal budget fine until January 2019. I have looked to see if any transactions were placed in the inactive accounts by mistake, I have verified data and rebuilt data and I have checked that our fiscal year dates are still correct. This seems to be a glitch in the software.
Hello there, @Jo22.
Please allow me to share a little more information about running budget reports that include the inactive accounts.
One reason why inactive accounts are showing up on the Profit and Loss Budget reports is if you've created the budget from the previous year's actual data. In your case, it's possible that you've included/copied the data from the previous year which includes the inactive accounts.
To exclude the inactive accounts, you may need to create a new budget again. For additional reference, you may check this article: Create a budget or forecast in QuickBooks Desktop.
On the other hand, in case you have any other QuickBooks questions in the future, you can also check our help articles: Help articles for QuickBooks Desktop.
Please feel free to drop a post if you have any other questions about budget, I'll be always here to help you. Wishing you the best!
Thank you for your response @Angelyn_T
The budget report was accurate until January, our fiscal year ends in May. The inactive accounts that are now showing on reports, were not on last years budget to pull into this years budget, nor do they appear on the budget in the "set up budget" screen; they only appear on the reports starting half way through our fiscal year. I am not sure how the reports can show something the budget does not?
It seems there is a possible bug in the program?
Thanks for checking some related reports to isolate the issue. Allow me to chime in for a moment and get you the right support for your concern.
Since this only happened recently and none of the steps shared by my colleagues worked, I recommend giving our Customer Care Team a call for further assistance. They have tools like screen-sharing to verify the root cause of the inactive accounts showing on the P&L Budget report and can also send a ticket to open an investigation.
Here’s how to get in touch with our phone support:
That should do it. Leave a comment below and let me know how the call goes. I'm always here to help. Take care!
This also happens on the P&L report as well. There doesn't seem to be a way to run the report and get all active accounts including zeros. If you use the Advanced Options under Display and click on Active under Display Rows, the report will only show active accounts with activity. If you click on All, the report will show all active AND inactive accounts including accounts with zeros. If you click on Non-zero, the report will show only active accounts with activity. There is no difference on the reports if you click on Active or Non-zero. They both give the same results.
If you use a filter and click on Multiple Accounts and click on all of the accounts (which are only the active accounts), and have All selected under Display Rows, the report still shows inactive accounts. It doesn't make sense that inactive accounts show up on the report.
Hello there, WBT137.
Thanks for joining this thread. I appreciate you sharing your concern about the Profit and Loss (P&l) report and for providing the steps you've taken so far.
The above steps and recommendations should make inactive accounts not show up on the P&L Reports. Make sure the transactions are under the correct date range and you choose the correct accounting method when you run the report.
If none of the steps works for you, I suggest you get in touch with our Care Support Team so they conduct a deeper investigation on why you're unable to run the P&L report and get all active accounts including zeros.
You can follow the steps shared by my colleague KhimG. Or you can check out this link for the steps: Contact the QuickBooks Desktop Customer Support Team.
Don't hesitate to let me know if you have any other questions about this concern. I want to ensure you're taken care of. Have a nice day ahead.
Thanks Charies! I ended up contacting Customer Support and they couldn't figure a way to get only active accounts including zeros on a report without also getting inactive accounts. It seems odd, however, there doesn't seem to be a solution. If you find a solution, please let me know.
Hi there, WBT137.
On behalf of my colleague, I'm here with some additional details about removing inactive accounts on the Profit and Loss report.
An inactive account will show on the reports if it contains transactions for that period. To check, you can review the Chart of Accounts, and I'd be happy to walk you through how:
Once you've found the transactions, you can either delete them or change the account it is associated with. After that, recreate the report and check if you can still see the inactive accounts.
If the inactive account has a zero balance, you can customize the report to exclude the zero balance accounts.
I've got some articles for you to check out about Chart of Accounts and customizing a report:
Let me know how it works on your end. I'm always here to help you with generating company financial reports in QuickBooks Desktop. Have a wonderful day.