cancel
Showing results for 
Search instead for 
Did you mean: 
PAWM-Treasurer
Level 2

SPLIT Transactions not appearing in ANY reports.

I have been running QB DT 2017 since 2017. This problem has been present since 2017 and earlier. I recently upgraded to QB Premier DT 2020 because I was told the reporting fixed this problem. That is not true. My problem still exists...

We use QB for managing our non-profit's finances. We get donations by checks and most of the time, we deposit the checks in batches. Her is a fictitious example. Yesterday (05-18-2020), I deposited three checks totaling $1000: John ($250); Mary ($250); Larry $500. This is reflected as a single transaction SPLIT with three entries.

At the end of the month (and at the end of the year) I need to run a report on all donors that contribute to our mission. When I look at the transactions, these three transactions DO NOT APPEAR. When I go to Customer List and specifically look at these three customers, this 5-18 transaction is not on the list.

This is a SERIOUS FLAW in the software. It makes it look like we are getting fewer donations than what is actually true. I cannot run accurate reports. For FEDERAL TAX REPORTING, I need to document anyone who donates $600 or more. NOT ONE REPORT will let me do this. The ONLY way I can make this work is to make three separate transactions and avoid using the SPLIT capability. This is NOT REASONABLE and not always possible. The SPLIT transaction is designed for this EXACT situation. It should work.

Attached screenshots prove what I am trying to explain for a real 05-30-2019 transaction. (names altered)

I have NEVER been able to get this to work. Please help.

Solved
Best answer June 17, 2020

Best Answers
BigRedConsulting
Community Champion

SPLIT Transactions not appearing in ANY reports.

I can understand your frustration, but your exact accusation isn't really correct, though it is a common complaint.

 

SPLIT appears in the account field on reports and tables where the report is showing you one row of the transaction and there are multiple detail rows that make up the transaction, and so there are multiple accounts.  And so, in the column for the detail account (the other account used on the transaction) QB displays SPLIT instead of, say, the first detail account.  This is normal.

 

RE: We get donations by checks and most of the time, we deposit the checks in batches. Her is a fictitious example. Yesterday (05-18-2020), I deposited three checks totaling $1000: John ($250); Mary ($250); Larry $500. This is reflected as a single transaction SPLIT with three entries.

 

When you enter your income directly on deposits, it will not appear in sales reports, or in the customer center in most cases, because deposits are not sales.  They may be income (or may not be) but they are not sales. 

 

RE: At the end of the month (and at the end of the year) I need to run a report on all donors that contribute to our mission. When I look at the transactions, these three transactions DO NOT APPEAR. When I go to Customer List and specifically look at these three customers, this 5-18 transaction is not on the list.

 

Yes, the customer center is designed to show sales, which you're bypassing by recording your income directly on deposits.

 

Also, QuickBooks will not create Donor Statements, but I do have a great way to do that. See below.

Still, you can create a report that will show you the deposits you record this way, in detail, by customer.  This is actually pretty easy to do:

- Start with a Custom Transaction Detail report: Reports | Custom Reports | Transaction Detail

- On the Filters tab of the Customize Report/Modify Report window , add these filters:

  - Detail Level: All Except Summary

 - Transaction Type: Deposit (or, all of the types or transactions where you record money received)

- On the Display tab:

  - pick Total By Customer.

  - Remove the Spit column, if desired. It is not really useful and will just show the bank account for the deposit.

 

Run the report.  You'll see each customer as a section on the report with each deposit line item and a total for the period. I think this is just what you're asking for.

 

------------------

Regarding Donor Statements, QB will not create a proper Donor Statement.  However, you can create them using our BRC Donor Statements - Desktop  tool, which gives you a lot of options to decide how your data will appear and will create statements in batch with no need for additional data entry.

 

It will include your donations entered as sales using invoices/payments, or as sales receipts, or as deposits, or even as Journals, or all of the above.

View solution in original post

16 Comments 16
Tori B
QuickBooks Team

SPLIT Transactions not appearing in ANY reports.

Good afternoon, @PAWM-Treasurer.

 

Thanks for reaching out to us here in the Community. 

 

The ability to view split transactions in the customer center as your screenshot shows, is currently unavailable. However, you can include split transactions on reports in QuickBooks. For example, if you run a quick report for said customer, you can customize the report to have split as a column. I've included the steps below to customize a report.

 

1. Open the customer center and choose a customer that has a split transaction.

2. Click Quick Report on the right-hand side.  

 

2020-05-19 12_16_41-Window.png

 

3. Hit Customize report in the top left corner. 

 

2020-05-19 12_22_12-Window.png

 

4. Type in Split at the bottom left corner. Then, hit OK.

2020-05-19 12_18_21-Window.png

 

2020-05-19 12_04_20-Window.png

 

That's all there is to it. However, I can see how viewing the split transactions from the customer center could be beneficial for you and your business. If you'd like, I can submit feedback to our development team, which could be considered in a future update. 

 

Please let me know if you have further questions or concerns. You can reach out to the Community or me anytime you need a helping hand. Take care!

 

 

 

**Say "Thanks" by clicking the thumb icon in a post

**Mark the post that answers your question by clicking on "Accept as solution" 

PAWM-Treasurer
Level 2

SPLIT Transactions not appearing in ANY reports.

With all due respect, that is an UNACCEPTABLE solution.  As a non-profit organization, we get donation checks deposited weekly.  As just one example as to how important this capability is, we are REQUIRED BY LAW to track donors that contribute $600 or more.  Do you honestly expect ANYONE to run this useless report with the hopes of being able to identify these types of donors?

 

There is NO REASON why I should not be able to run a customer report and filter all transactions of $600 or more for a specific date range.  This report is showing SPLITS ONLY.  I do not want to isolate SPLITS.

 

Attached is part 2 of the 4.  I was not able to supply all four screenshots in the beginning because your tool only allows for one file to be attached at a time.

PAWM-Treasurer
Level 2

SPLIT Transactions not appearing in ANY reports.

To answer your question, "I can submit feedback to our development team, which could be considered in a future update."  The answer is YES, please submit my documentation to your Development Team.  This question has been asked multiple times by other users.  I have found MULTIPLE postings on your Community website to have this problem addressed. I know it has been addressed at least three years ago when I was using QB DT 2017.  Why?  Because I raised the issue then, just like I am raising it again now.  This needs to be taken seriously and addressed with HIGH PRIORITY.

 

Here is Screenshot 3 of 4 to help your Development Team.  

PAWM-Treasurer
Level 2

SPLIT Transactions not appearing in ANY reports.

Here is screenshot 4 of 4.  Please provide a case number or anything possible for progress tracking.  Thanks!

 

PAWM-Treasurer
Level 2

SPLIT Transactions not appearing in ANY reports.

I did not hear back from anyone.  The previous response from "Tori B" was inappropriate.  Yes, this report does show split transactions but that is the only connection to this reporting problem.  This was not an adequate solution. Please respond back back as to whether or not your Development Team has been notified of this problem. Thanks!

PAWM-Treasurer
Level 2

SPLIT Transactions not appearing in ANY reports.

I have not heard from anyone.  The response from "Tori B" is an inappropriate answer.  This has nothing to do with the reporting problem or visibility issue related to SPLIT transactions.  The only connection to this problem is that Tori's reporting suggestion can not make certain SPLIT transactions visible.  In her proposal, if there are 1000 records displayed, I need to manually open all 1000 transactions to identify/find or manually filter what I am trying to report.  This is the proverbial "needle in the haystack" situation.  THIS IS UNACCEPTABLE.

 

Has this information been given to your Development Team?  Please provide a response as to when your Development Team will be addressing this SERIOUS issue.

 

SarahannC
Moderator

SPLIT Transactions not appearing in ANY reports.

Hi there, PAWM-Treasurer.

 

I wouldn't like you to come up with that situation. 

 

I can see you're putting a lot of effort to get this kind of report in QuickBooks Desktop (QBDT). I got your point on how ideal and useful it is to help you manage the lists of transactions from every donor.
 

For now, I cannot tell as to when our development team will be releasing an update for this new display for the reports. You may consider checking our blog website to keep you up-to-date for the feature release.

 

If there's anything I can help you with, please tap me on my shoulder. I hope you're okay. Stay safe.

PAWM-Treasurer
Level 2

SPLIT Transactions not appearing in ANY reports.

Thank you for responding.  I will be monitoring the Blog, and community postings.  However, I DO NOT want this ticket closed until there is a solution.  I know that once a ticket is closed, visibility is no longer on the issue.

 

BigRedConsulting
Community Champion

SPLIT Transactions not appearing in ANY reports.

I can understand your frustration, but your exact accusation isn't really correct, though it is a common complaint.

 

SPLIT appears in the account field on reports and tables where the report is showing you one row of the transaction and there are multiple detail rows that make up the transaction, and so there are multiple accounts.  And so, in the column for the detail account (the other account used on the transaction) QB displays SPLIT instead of, say, the first detail account.  This is normal.

 

RE: We get donations by checks and most of the time, we deposit the checks in batches. Her is a fictitious example. Yesterday (05-18-2020), I deposited three checks totaling $1000: John ($250); Mary ($250); Larry $500. This is reflected as a single transaction SPLIT with three entries.

 

When you enter your income directly on deposits, it will not appear in sales reports, or in the customer center in most cases, because deposits are not sales.  They may be income (or may not be) but they are not sales. 

 

RE: At the end of the month (and at the end of the year) I need to run a report on all donors that contribute to our mission. When I look at the transactions, these three transactions DO NOT APPEAR. When I go to Customer List and specifically look at these three customers, this 5-18 transaction is not on the list.

 

Yes, the customer center is designed to show sales, which you're bypassing by recording your income directly on deposits.

 

Also, QuickBooks will not create Donor Statements, but I do have a great way to do that. See below.

Still, you can create a report that will show you the deposits you record this way, in detail, by customer.  This is actually pretty easy to do:

- Start with a Custom Transaction Detail report: Reports | Custom Reports | Transaction Detail

- On the Filters tab of the Customize Report/Modify Report window , add these filters:

  - Detail Level: All Except Summary

 - Transaction Type: Deposit (or, all of the types or transactions where you record money received)

- On the Display tab:

  - pick Total By Customer.

  - Remove the Spit column, if desired. It is not really useful and will just show the bank account for the deposit.

 

Run the report.  You'll see each customer as a section on the report with each deposit line item and a total for the period. I think this is just what you're asking for.

 

------------------

Regarding Donor Statements, QB will not create a proper Donor Statement.  However, you can create them using our BRC Donor Statements - Desktop  tool, which gives you a lot of options to decide how your data will appear and will create statements in batch with no need for additional data entry.

 

It will include your donations entered as sales using invoices/payments, or as sales receipts, or as deposits, or even as Journals, or all of the above.

murban15
Level 1

SPLIT Transactions not appearing in ANY reports.

Follow up on this because I am one of many people you cannot understand why what seems like such a simple request cannot be made.   It is pretty clear by the lack of any confirmation that this FIX is not going to be made.    I work in software development, so I know it is either on the the "to Do" list or it's not.

Can you please tell us if it is even going to be updated?

Fyi, I'm on QBP 2019 Desktop and there is NO WAY I'm paying for 2020 if it is in that version.

 

 

Rose-A
Moderator

SPLIT Transactions not appearing in ANY reports.

Hi, murban15.

 

At this time, there isn’t a specific time frame as to when this feature is available. QuickBooks aims to find new ways to make sure that your product meets your needs.

 

While we haven’t added this option yet, we are working on big improvements that will be helpful for the majority of our customers. I'd suggest visiting the QuickBooks Blog website to stay up-to-date on any improvements in the online version.

 

You can visit the What's New section on your QuickBooks Desktop, to be updated with our latest news including product refinement.

 

 

Additionally, I recommend visiting this link: Resource Hub. This will provide you with resources and videos about managing your QuickBooks Desktop account, income, expenses, inventory, and running reports.

 

If you have any other questions or need anything else in QuickBooks, let me know in the comment below. I'll be more than happy to help you in any ways I can. Have a good one.

djmichaud
Level 1

SPLIT Transactions not appearing in ANY reports.

When can someone give us a straight answer. This SPLIT Transaction problem is just that... A PROBLEM. These split transactions have not been able to be viewed in ANY REPORTS for a number of years.  This has REALLY created a mess when it comes to running any type of reporting.  I DO NOT UNDERSTAND WHY THIS IS NOT TAKEN MORE SERIOUSLY!!!

 

When reports are generated any SPLIT transaction is completely IGNORED as if that transaction NEVER EXISTED. THIS IS A SERIOUS ISSUE. HOW CAN I STRESS IT ANY MORE CLEARLY.

 

PLEASE LET ME KNOW WHO I NEED TO HAVE THIS RAISED TO.  IT NEEDS TO BE A TOP PRIORITY.

SarahannC
Moderator

SPLIT Transactions not appearing in ANY reports.

Hello djmichaud, 

 

I can see how challenging it is for you and important to generate the split transactions on the report. 
 

Let's go through the steps below and send feedback about the current report design.  You can input a few details that make them aware of the other features you're looking on the report. Here's how:
 

  1. Go to the Help menu in your company file.
  2. Select Send Feedback Online and choose Product Suggestion.
  3. Click the Type of Feedback drop-down arrow and select Product Suggestion.
  4. Choose Reports in the Product Area.
  5. You can then add brief information in the box.
  6. Enter your name and e-mail address.
  7. Then, click the Send Feedback button.

 

Also, you may consider checking the articles below for additional guide about handling reports in QuickBooks Desktop:

 

 

If you have suggestions or other feedback to share, feel free to post them. We'll take them as an opportunity to improve QuickBooks. Keep safe.

Unhappy_User_27609
Level 1

SPLIT Transactions not appearing in ANY reports.

There is no benefit to using the split deposit function if you cannot aggregate a donors deposits for the year. I will stop using the split deposit function; all the answers are BS

vvildcard
Level 1

SPLIT Transactions not appearing in ANY reports.

Hey all... I'm happy to report there is a good workaround for this split nonsense... it's described in this article: 

Record and make bank deposits in QuickBooks Online 

 

Don't use the split feature (it's still garbage in 2022)... instead, record a Payment Received for each donation and put it in the Payments to Deposit account (they call it Undeposited Funds in the video). Then go to your deposit and check the box for each donation that was included in that deposit. 

NonProfitSteph
Level 1

SPLIT Transactions not appearing in ANY reports.

Unfortunately, this is not a great solution, as it adds a significant amount of data entry. The other problem with splits is that they don't appear in any of the transaction records that are attached to individual donors. We are working on moving to a CRM and the transactions recorded as splits aren't attached in the files.

Need to get in touch?

Contact us