Skip to main content
January 14, 2024
Question

Is there a Transaction Register report that will show split details - online version?

  • January 14, 2024
  • 2 replies
  • 0 views

Is there a Transaction Register report that will show split details - online version?

2 replies

January 14, 2024

Great to have you here, @COD1I can definitely share some insights to help you run a report with the split details in QuickBooks Online (QBO).

 

In QBO, we can pull up the Transaction List with Splits report and then customize it to show the specific details of your transactions. However, please know that this report is exclusive to QBO Essentials, Plus, and Advanced subscriptions. Follow the steps below to proceed:

 

  1. Go to the Reports menu.
  2. In the search field, you can enter and click on Transaction List with Splits report.
  3. Select the date range from the Report period.
  4. Choose the correct Accounting method.
  5. Tap on the Customize button, then click Filter.
  6. You can also click the Change columns link, then place a checkmark next to the information you want to see.
  7. Choose Run report.

 

If you want to view the complete transaction details, simply click on the amounts to display the details.

 

Additionally, you can modify your reports in QuickBooks to show the correct data based on your specific business needs. I've attached the article you can use to change your reports' filters and other information: Customize reports in QuickBooks Online.

 

Feel free to let me know if you have any further questions or concerns regarding managing your reports in QBO. I'll be available to assist you. Have a great day ahead!

February 8, 2024

How can I do transaction list with splits report  with QB enterprise 24? How do I generate a report showing all inputs of every split entered into an account that can be exported into excel? Ideally, I want this to be included in the transaction report but can’t figure it out. 

January 31, 2024

It is a shame that the data we put into SPLIT transactions is not available to us when using Simple Start. Is there any way to get a full dump of data in another way since Intuit holds our data hostage and only allows us to report on it correctly by paying a much higher monthly fee. There should be a way for us to access the data.

 

 

January 31, 2024

I hear your sentiments, Kinstone. I completely understand the importance of having a report that'll help you view all your split transactions.

 

While the Transaction List with Splits is unavailable in the Simple Start version, we can run and customize the Transaction List by Date instead. I'll show you how:

 

  1. Go to the Reports menu.
  2. Type in Transaction List by Date in the Search field.

  3. If you're in the modern interface, click Switch to classic view.

  4. Select Customize.

  5. Modify the dates.
  6. Under Row/Columns, place a checkmark beside Split, then reorder the other fields.
  7. You can also go to Filter to decide which data you want to view.
  8. Once done, hit Run report.

 

Once the modification is complete, the report will reflect the changes as shown in the screenshot I've included below. 

 

In addition, QuickBooks Online allows you to generate reports to view snapshots of your business. And you can export them to Excel to modify the data further. 

 

Is there anything else you'd like me to address regarding reports or other areas in QuickBooks? Please let me know, and I'll get back to you soon.