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

When I run a class quickreport, the balance column appears to be a sum of transaction absolute values. How do I make it respect credits vs. debits?

 
6 Comments
JamesDuanT
Moderator

When I run a class quickreport, the balance column appears to be a sum of transaction absolute values. How do I make it respect credits vs. debits?

I know how we can get the data you need, skipper2.

 

When pulling up the Class QuickReport, we can customize it to add the Credit and Debit columns. Here's how to do it:

  1. Pull up the Class QuickReport.
  2. Click the Customize button and go to the Rows/Columns section.
  3. Click the Change columns hyperlink and mark Deposits and Credits.
  4. Click Run report.

You can use this link for reference in customizing reports: Customize reports in QuickBooks Online.

 

Here's also an article related to classes: Create and manage classes in QuickBooks Online.

 

We'll be right here if you have additional queries regarding the customization of class report. 

skipper2
Level 2

When I run a class quickreport, the balance column appears to be a sum of transaction absolute values. How do I make it respect credits vs. debits?

 James, thank you for your reply.  I have the credit and debit columns and that is helpful, but I would like to have a running balance column.  How can I fix the balance column so it respects debits and credits?

ChristieAnn
QuickBooks Team

When I run a class quickreport, the balance column appears to be a sum of transaction absolute values. How do I make it respect credits vs. debits?

Hi there, skipper2.

 

I appreciate you for coming back to add clarification with your concern.

 

To have a running balance column in the class Quickreport, I suggest customizing the report. This way, you'll have the option to checkmark the box for Balance to appear in the report. Please make sure to choose the correct report date range once the columns are already added to the report. That way, you're able to see the specific data for the balance column.

 

Here's how:

 

  1. From the Class QuickReport, click the Customize button.
  2. Click the Change columns link.
  3. Checkmark the Balance box.
  4. Hit the Run report button.
  5. Click the Report period drop-down and choose the right date.
  6. Click Run report.

 

For additional information on how you can customize a report to show the specific details that you want to see, you can click this article: Customize reports in QuickBooks Online.

 

Please keep me posted if you have any other concerns about the Class Quick report. I'd be happy to help you more.

skipper2
Level 2

When I run a class quickreport, the balance column appears to be a sum of transaction absolute values. How do I make it respect credits vs. debits?

Thank you very much for the quick responses.  I appreciate the instruction on how to add the balance column, however I think you have misunderstood the fundamental issue of my original post.  Please see the attached screen shot.  When I include the balance column in the class quickreport, the column seems to be a running summation of the absolute value of the transaction amount.  Both credits and debits increase the running balance.  This makes the number in the balance column reasonably arbitrary.  How can I make it so credits add, and debits subtract from the balance?

JessT
QuickBooks Team

When I run a class quickreport, the balance column appears to be a sum of transaction absolute values. How do I make it respect credits vs. debits?

Hi skipper2,

 

Thank you for the additional details. I'd like to shed light on the class quick report.

 

The BALANCE column is just showing the communicative sum of the in the AMOUNT column. It's not connected to the DEBIT and CREDIT columns like a journal.

 

In addition, the DEBIT and CREDIT columns are just showing the posting sides of the accounts in the ACCOUNT column.

 

Therefore, your option for this is to export the report to Excel and create a formula to calculate the balance like how you want it to be.

 

If you have other questions in mind, please let me know.

kirkjmiller
Level 1

When I run a class quickreport, the balance column appears to be a sum of transaction absolute values. How do I make it respect credits vs. debits?

I have reported this as a bug over a dozen times as well. The absolute value of all transactions is not a balance. A balance is the sum of the positive and negative transactions. In no world of accounting would anyone want to see the sum of income and expenses as a number. Every time I report this bug, I'm met with the same response - a way to do it elsewhere. Can someone at QBO, the makers of a piece of accounting software, please investigate the definition of 'balance'. At the very least rename the balance column as what it current tabulates is not a balance.

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us