Solved

SPLIT Transactions not appearing in ANY reports.

Forum|Forum|6 years ago
May 19, 2020
2 replies
0 views

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.

QuickBooks Desktop

Best answer by BigRedConsulting

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.

Tori B

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.

3. Hit Customize report in the top left corner.

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

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"

P

PAWM-TreasurerAuthor

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.

P

PAWM-TreasurerAuthor

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.

BigRedConsultingAnswer