Inactive account showing on report

gappleb · ‎March 08, 2019

Hi. I have an old bank/cash account that was made inactive 3 years ago and there has been no activity in the account since (last transaction date in the account was in 2016). In my Balance Sheet - Detail report, the account appears and I can't seem to find a way to delete it from the report. If I am looking at a Balance Sheet - Standard report, the account does not appear. Over the years, I have made many accounts inactive and none of the others appear on any reports. thanks in advance for any assistance.

IamjuViel · ‎March 08, 2019

Hello there, @gappleb.

I want to make sure you’re able to view your Balance Sheet report with accurate information.

When generating reports whether an account is inactive or not as long as there are transactions recorded in it within the date range of the report then it will show in reports as it should.

To make sure there are no recent transactions on the account, you can run a quick report on the inactive account. Use the same date range you used in your Balance Sheet report.

If you don’t want to include this inactive account, here’s how:

Go to Reports menu.
Choose Balance Sheet.
Click on Customize Report.
Go to Filters.
Search and highlight Account in the Filter Section.
In the Account section, choose Multiple accounts.
Check to select accounts you want to show up on the report.
Once done, click on OK.
Click on OK in the Modify Report window.

For additional insights, you can check out these articles:

I'm just one post away if you have other questions about generating reports in QuickBooks Desktop. Feel free to click the Reply button below.

gappleb · ‎March 08, 2019

Hi,

That’s the problem. There are no transactions in the report date range but the account still shows up on the report. Last transaction in the inactive account was in 2016 and the date range for the report is the current month. In response to your reply, in filters, the inactive account does not appear. The only place that the inactive bank account appears is on the report.

gappleb · ‎March 08, 2019

I have tried to respond to your reply twice now but nothing appears in the string. Anyways, I will try to duplicate my response.

Hi,

That’s the problem. Within the inactive bank account here are no transactions in the report date range but the account still shows up on the report. Last transaction in the inactive account was in 2016 and the date range for the report is the current month. Also when going into the Filter window, the inactive bank account does not appear in the account list. The only place that the account appears is on the Balance Sheet Detail report.

IamjuViel · ‎March 08, 2019

Hello there, @gappleb.

I appreciate you for taking your time getting back to us and for sharing what you see on your end.

In addition to what I've shared on my initial response, your bank account whether active or not is an asset of your company. The Balance Sheet Standard report will only show accounts that has open running balance on it regardless if it is active or inactive.

While the Balance Sheet Detail report displays all the accounts listed in your Chart of Accounts with its starting and ending balance and the transactions based on the date range of the report.

On the other hand, make sure your QuickBooks has an updated software to ensure an accurate information when running your reports.

That's it! Let me know how it works on your end.I'm always here to help you with generating company financial reports in QuickBooks Desktop.

Topics

Training

Community

Resources

Inactive account showing on report