cancel
Showing results for 
Search instead for 
Did you mean: 
onmarketins
Level 1

I need transaction list with splits by account. How do I set a filter to indicate just one account I need to see?

 
5 Comments
Anonymous
Not applicable

I need transaction list with splits by account. How do I set a filter to indicate just one account I need to see?

Great to see you today, onmarketins,

 

I can help you customize your Transaction List with Splits report.

 

First, we can add a filter to show the desired account you'd like to view. Once done, we can save your customizations to keep the report modifications, so you don't have to redo it the next time.

 

Let me guide you how to do that:

  1. On the report, click the Customize button.
  2. Click the Filter tab to expand the options.
  3. Locate the Account filter.
  4. In the Account drop-down, select the account you'd like to view.
  5. Click Run report.
  6. Once done, click Save Customization.
  7. Enter the report name in the Custom report name field.
  8. Fill out the Add this report to a group field if you already have a report group.
  9. Click Save.

That should get you on the right track, onmarketins.

 

Please let me know if there's anything I can do to help. I'm always around to assist you. Have a good day!

melissa66
Level 1

I need transaction list with splits by account. How do I set a filter to indicate just one account I need to see?

Good morning!

 

Is there a way to do this on Quickbooks Desktop? 

JasroV
QuickBooks Team

I need transaction list with splits by account. How do I set a filter to indicate just one account I need to see?

Good day to you, @melissa66.

 

I’m happy to tell you that there’s a way to filter a report to show splits by account in QuickBooks Desktop (QBDT).

 

QBDT offers a variety of reports that you can customize to show the data that matters to you and to your business. Allow me to grab this opportunity to help you achieve this. Here's how:

 

  1. From your QBDT software, navigate to the Reports menu.
  2. Select Custom Reports, and click Transaction Detail.
  3. Click the Customize Report button from the top menu of the report.
  4. Go to the Filters tab.
  5. Type in and select Account under the FILTER field.
  6. From the Account drop-down menu, select your preferred account. 3.JPG
  7. Select the Display tab.
  8. From the COLUMNS field, type in and select Split then click OK4.JPG

You can also read this resource for more details about personalizing reports in QBDT: Customize reports in QuickBooks Desktop.

 

It’s also great to save the current settings of your report. That way, you won’t have to go to the customization process again in case you need the same information in the future.

 

Furthermore, I’m attaching this article that you use for future reference. This link can guide you through the steps in reconciling your accounts effectively: Reconcile an account in QuickBooks Desktop

 

Let me know if you have other questions about reports in QBDT. I’ll be more than happy to assist you. Have a great day ahead!

melissa66
Level 1

I need transaction list with splits by account. How do I set a filter to indicate just one account I need to see?

@JasroV  Thank you so much! Is it also possible to show the detail for the split? Like to show every account that the split is going to?

Jovychris_A
QuickBooks Team

I need transaction list with splits by account. How do I set a filter to indicate just one account I need to see?

Yes, of course, it's possible in QuickBooks, @melissa66.

 

You can customize this report again and ensure to set the Filter for Account into All Accounts. Also, make use of the columns by checking the AccountAccount Type, and Split under Column selection to see where you can locate the split amounts.


 

You can also reorder the columns by dragging the column headers.

Then utilize the Memorize button to save the customization of the report.

To view the saved report, you can go to Reports, then select the Memorized Reports.

 

If there's anything else I can help you with Reports, feel free to place a comment here. I'll get back to you as fast as I can. Have a safe day ahead!

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