- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
How to exclude inactive accounts from reports
how to exclude inactive accounts from the P&L reports? or how can I delete the inactive accounts?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
You can not delete an inactive account
if an inactive account has transactions for the report period, then it will show in reports as it should. If the inactive account has a zero balance, some reports in customize allow you exclude zero balance accounts.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
<a rel="nofollow" target="_blank" href="https://community.intuit.com/questions/1620928-how-to-exclude-inactive-accounts-from-reports">https:...>
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
If you are running a report that does not have that option in customize, let us know what report it is
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
Rustler,
You're always on top of this stuff, so here's a question for you-
How do I track accumulated adjustment for shareholders for tax purposes (basis) w/o that account affect equity on reports? I thought an inactive account might work, but alas, that has not solved my problem.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
But, the inactive account is showing a negative $15,000. Why is this happening?
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
Hello there, Bethery.
There might be transactions in that account that made it negative. You can open the account and check all transactions.
I've attached screenshots as your reference.
Get back to this thread if you need more help. We're just around.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
I have customized by report to only include active accounts and some not all of the inactive accounts still show up on the report. I can't figure out what I am doing wrong.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
Welcome to the Community, @Jean9.
I tried this on my end and you didn't do anything wrong. The reason the inactive accounts are still showing in the report is there are transactions assigned to them. These accounts will appear even if you customize to report to show only the active ones.
I've added a screenshots as your reference.
Check out this article for more information about chart of accounts: Understand QuickBooks Chart of Accounts.
Just in case, you may check this article for future reference about customizing a report in QuickBooks Desktop: Customize reports in QuickBooks Desktop.
lease know that you're always welcome to post if you have any other concerns. Community Team will always here to help.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
I'm trying to run Budget to Actual, and accounts with inactive accounts with no transactions and no budget still appear. There doesn't seem to be that zero option in customize.
Iva
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
Hi there, @ibrimmer.
I'll share information about inactive accounts on your reports in QuickBooks Desktop.
As of the moment, there isn't an integrated way to generate a report showing only zero or inactive accounts. Yes, you may be able to generate a report with accounts including inactive ones but not the other way around.
While the said options are not yet available, I suggest letting our product developers know about your request by sending feedback. I'll show you how.
- Go to Help.
- Select Send Feedback Online.
- Click Product Suggestion.
- Under Product Area, choose Reports.
- Enter a few words describing how you wanted to maximize the feature of customizing your reports in QuickBooks Desktop.
- Select Send Feedback.
- Click Close Window.
For now, I'm including this reference so you're able to use all the features and functions of QuickBooks: Help Articles in QuickBooks Desktop. Also, you're able to read subtopics that will describe how a feature is used and how to accomplish tasks related to its functions.
I've got you covered if you have other questions aside from generating reports in QuickBooks. Use the Reply option below and don't forget to include my name, @JonpriL, so that I can get back here and assist you. Take care always and stay safe!
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
i have an inactive account with zero balance that keeps showing up on my reports...how can I fix this?
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
I'm running the Job Progress Invoices vs Estimates Report, but I can't figure out how to omit inactive customers. I don't see an option to exclude zero amounts when I go into customize reports. Nor can I find an option to exclude inactive customers. Seems like that should be a standard option. Any advice?
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
We can customize the report to exclude inactive customers and zero amounts, @AlidaR. I'm here to provide the steps to omit them.
First, we need to manually choose the active customers to exclude the inactive ones from the report:
- Go to Reports and choose Report Center.
- Open the Job Progress Invoices vs Estimates report.
- Click Customize Report and choose the Filters tab.
- In the Search Filters field, type in Name.
- Choose Multiple names in the All names dropdown.
- A Select Name page will pop up.
- Put a checkmark for the active customers from the list.
- Click OK.
Then, let's exclude the zero amounts:
- Still on the Job Progress Invoices vs Estimates report.
- Click Customize Report and choose the Filters tab.
- In the Search Filters field, type in Amount.
- Tick the greater than radio button (>=) and put 0 in the field beside it.
- Click OK.
Additionally, you can memorize your reports for future use to save the personalization you've made.
Let us know if you have other queries about customizing your reports in QuickBooks Desktop. We'll be here to lend a hand.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
Is there an option to filter the report by customers that are marked "Inactive" without my having to choose the individual names myself? IF they are marked inactive in QB desktop, I do not want them in my customer contact report, my sales summary report or basically any customer based report. They are already marked as INACTIVE.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
Thanks for joining this thread, tnpmommy.
I can certainly understand how an ability to automatically prevent inactive customers from showing up in customer-based reports could be useful and have submitted a suggestion about it as of today.
You can also submit your own feature requests while using QuickBooks.
Here's how:
- In the top menu bar, go to Help, Send Feedback Online, then Product Suggestion....
- Choose a Type of Feedback and Product Area (optional) from your available drop-down menus.
- Enter any suggestions/feedback in the Here is my suggestion: field.
- If you'd like, include your name/email in the My name is: (optional) and My e-mail address is: (optional) fields.
- Select Send Feedback.
Your feedback's definitely valuable to Intuit. It will be reviewed by our Product Development team and considered in future updates. You can stay up-to-date with the latest news about your product by reviewing Intuit's Product Updates webpage.
You also have the option of checking our QuickBooks Desktop Marketplace for apps which may be able to help you achieve what you're looking to do.
For the time being, you can manually filter out inactive customers from reports they're displayed on.
Please don't hesitate to send a reply if there's any additional questions. Have a great Wednesday!