negative and positive checkbook entries

fgerbode · ‎March 09, 2022

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?

MaryLandT · ‎March 10, 2022

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.

Open the report that you need.
Click Customize Report.
Go to the Filters tab.
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

BigRedConsulting · ‎March 09, 2022

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 · ‎March 10, 2022

@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 · ‎March 10, 2022

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.

Open the report that you need.
Click Customize Report.
Go to the Filters tab.
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 · ‎March 12, 2022

Thanks so much for your replies!

--Sarge

Topics

Training

Community

Resources

negative and positive checkbook entries