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

Is anyone having issues with Transaction List By account report?

When I ran standard report "Transaction by Account" and Transactions by Date" and add 2 fields, "debit" and "credit", the values are switched. Debits are in credit, Credits are in Debit column
4 Comments 4
Adrian_A
Moderator

Is anyone having issues with Transaction List By account report?

Hello user00552,

 

Thank you for posting in the Community!

 

I've tried running the same report on my sample file, and it works fine. With that, your system may have encountered browser-related issues.

 

We can resolve this by running some troubleshooting steps. To start with, try opening the report on an incognito window. Here is a list of keyboard shortcuts to open one:

 

  • For Google Chrome: Ctrl Shift N
  • For Mozilla Firefox: Ctrl Shift P
  • For Microsoft Edge: Ctrl Shift P
  • For Safari: Shift N

 

If the report shows the correct data, you can go back to a regular browser and clear its cache. Piled browser history can be the reason for some issues on the page. You may also switch to a different browser like Google Chrome, Mozilla Firefox, Safari, or Microsoft Edge.

 

If you want to add or remove some columns on the report, you can modify it. I've added this article as your guide: Customize Reports.

 

You can also save the same settings of customization by memorizing the report.

 

I want to ensure that you can continue working on your QuickBooks. That said, let me know how these steps work on your end. I'll be happy to help you.

user00552
Level 2

Is anyone having issues with Transaction List By account report?

I tried in private windows in Safari, Firefox and Chrome.  No difference in presentation.  See screen shot.  Notice that some sales receipts (deposits) on some transactions are showing up in the debit column.  Also note that these same sales receipts are not presenting the Class.  All our transactions have class assigned.  Notice expenses (debits) are showing up in the credit column.  We are a non-profit, all sales receipts are credits.

user00552
Level 2

Is anyone having issues with Transaction List By account report?

screen shot

MarsStephanieL
QuickBooks Team

Is anyone having issues with Transaction List By account report?

Thank you for sharing a screenshot regarding your concern, @user00552. I can share some insights about the debits and credits that appeared on the report in QuickBooks Online (QBO).

 

Looking at your screenshot, I wasn't able to see which account it was found. I can only see the Transaction Type, Name, Debit, Credit, and Class column.

 

Let's focus on the credit and debit column. The amount on the Sales receipt is in the Debit column because Cash is an asset account that debits when there's an increase. And it will balance out to your Sales Revenue account. 
 

I've included some screenshots for your reference:

 

 

Another account that debits the amount on Sales Receipt is the Cost of Goods Sold because it shows an increase.

 

For more information about double-entry accounting, check out this article: How accounts are affected by debits and credits. It will help you understand the functions behind transactions and what to expect when entering them.
 

I also recommend speaking with your accountant to give you more tips on how to assess your books in the future. If you don't have one, you can visit quickbooks.intuit.com

 

I'm always here if you have any questions. Please don't hesitate to let me know in the comments section. Have a great weekend!

Need to get in touch?

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