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:
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.
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?
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.
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.
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?
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.
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.