cancel
Showing results for 
Search instead for 
Did you mean: 
fgerbode
Level 2

negative and positive checkbook entries

My check register report shows every entry as a positive and a negative, which clutters up the report. Is there an easy way of dealing with this so I can get a clean report, with deposits as positive and withdrawals as negative?

Solved
Best answer March 10, 2022

Best Answers
MaryLandT
Moderator

negative and positive checkbook entries

I can show you the Detail Level filter, fgerbode.

 

When running a report in QuickBooks, the output is controlled by the Filters set for that report.

 

The Detail Level is one such filter and it has 3 settings. These are the levels:

 

  • All - shows both the individual line items and the total.
  • Summary only - shows only the transaction total.
  • All except summary - shows only the detail lines and excludes the transaction total.

 

To filter the report, you can follow the steps below.

 

  1. Open the report that you need.
  2. Click Customize Report.
  3. Go to the Filters tab.
  4. Select Detail Level filter, then Summary Only.

 

I've collected some articles where you can get additional details about managing reports.

 

 

I'm always here whenever you need help with QuickBooks Desktop reports. Stay safe and have a good one!

View solution in original post

6 Comments 6
BigRedConsulting
Community Champion

negative and positive checkbook entries

I don't know of any canned report named "check register".

 

If you're using a standard transaction detail report, you can filter it to show only the summary row for each transaction. Set the Detail Level filter to Summary Only.

 

Alternately, filter the report for the bank account, which may work better, and then it'll only include detail rows that use the bank account.

fgerbode
Level 2

negative and positive checkbook entries


@BigRedConsulting wrote:

I don't know of any canned report named "check register".

 

If you're using a standard transaction detail report, you can filter it to show only the summary row for each transaction. Set the Detail Level filter to Summary Only.

 

Alternately, filter the report for the bank account, which may work better, and then it'll only include detail rows that use the bank account.


I wanted to include all accounts, so did not want to filter out my credit card accounts.

I could not find the Detail level filter.  Can you give me a steer?

 

Thanks!

--Sarge

MaryLandT
Moderator

negative and positive checkbook entries

I can show you the Detail Level filter, fgerbode.

 

When running a report in QuickBooks, the output is controlled by the Filters set for that report.

 

The Detail Level is one such filter and it has 3 settings. These are the levels:

 

  • All - shows both the individual line items and the total.
  • Summary only - shows only the transaction total.
  • All except summary - shows only the detail lines and excludes the transaction total.

 

To filter the report, you can follow the steps below.

 

  1. Open the report that you need.
  2. Click Customize Report.
  3. Go to the Filters tab.
  4. Select Detail Level filter, then Summary Only.

 

I've collected some articles where you can get additional details about managing reports.

 

 

I'm always here whenever you need help with QuickBooks Desktop reports. Stay safe and have a good one!

fgerbode
Level 2

negative and positive checkbook entries

Thanks so much for your replies!

--Sarge

ksmish
Level 1

negative and positive checkbook entries

hello!  I have a follow up question on this. 

 

In QuickBooks online, the Transaction Detail Report and Check Detail Report both do not include the Filter for Summary Only and I am having trouble removing the negative transaction from the report. 

 

Can you assist?

 

Heide DC
QuickBooks Team

negative and positive checkbook entries

Having these reports in QuickBooks Online (QBO) is to provide comprehensive insights into your financial transactions, ksmish.

 

Filtering the Summary only in the Transaction Detail and Check Detail reports is unavailable. As an alternative, we can export the report to an Excel file. From there, you sort out all negative transactions within the report.

 

Here's how to access and export the report.

 

  1. Go to the Reports menu.
  2. Type in Transaction Detail/Check Detail report in the Search bar.
  3. Set the Report period, and the desired Columns and Filter sections.
  4. Click Export/Print, then choose Export to Excel.

 

export.png

 

 

For more detailed information, see this article: Export your reports to Excel from QuickBooks Online. This resource provides detailed instructions and tips to help you navigate the process effectively.

 

Moreover, exploring QuickBooks Live Bookkeeping could be beneficial for your business. This service offers personalized financial expertise by connecting you with certified bookkeepers who can manage your accounting tasks in real-time, ensuring your financial records are accurate and up-to-date. Embracing this service could streamline your bookkeeping processes and allow you to focus more on growing your business.

 

Come again if you have questions about customizing reports or any other part of QuickBooks. We're determined to help your business with the benefits of QBO. Stay in touch.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us