Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.

Reply to message

View discussion in a popup

Replying to:
JamaicaA
QuickBooks Team

Reply to message

I  appreciate the detailed example of your concern regarding the Received From and Client fields in bank deposits when running reports, Nola. We can run the Transaction Detail by Account report to display payments Company X has made to your company or the total amount they paid during a specific timeframe. Let me share the specifics below.

 

The Transaction Detail by Account report is only available for QuickBooks Online Essentials, Plus, and Advanced versions. If you're using the Simple Start version, consider upgrading your subscription.

 

However, if you're subscribed to one of these plans, let's tailor the report to get the data you need. I'll show you how.

 

  1. Go to the Reports menu on the left panel and search for Transaction Detail by Account.
  2. Select Switch to Classic View (optional) or continue with the Modern View, then click the Customize button.
  3. Set the Report Period.
  4. Go to the Rows/Columns section to choose Account under the Group by.
  5. On the Select and reorder columns section, tick the Date, Transaction Type, Customer, and Vendor checkboxes. You can organize them by dragging the specific columns.
  6. Scroll down to the Filter option and select Deposit as the Transaction type, Y as Customer, and X as Vendor.
  7. Click Run Report.

 

I'm adding some screenshots for reference for both Classic View and Modern View:

3.png

 

4.png

 

Moreover, check out this article for more ways to fine-tune report layout and data: Customize reports in QuickBooks Online.

 

Furthermore, you can always memorize reports to save the current setting or print them for your copy. Refer to this guide for the details: Save a customized report in QuickBooks Online.

 

We aim to help you get the most out of your financial reports, especially the accuracy of reflecting transactions and tracking payments. Drop me a comment below if you have any other questions about managing entries or generating reports. We'll be here to help you more.

Need to get in touch?

Contact us