United States United Kingdom Australia Canada (English) Canada (French) France Singapore South Africa Global Ireland
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
bmcc1200
Level 3
posted
‎November 16, 2023 01:56 PM
last updated ‎November 16, 2023 1:56 PM

Donor Report

We moved from DT to QBO 6 months ago and while I can see all my deposits which come from our customers (donors) they will not show up in any report that I can figure out.  The other problem I see is many of our deposits are splits in which they are a received from or a payee for a single deposit.  Is there a transaction type report that allows me to list customer (they do show up in the customer list) to these deposits?  Also, how do I get these deposits to associate with the customer when you look at the customer list.?  Thanks

Reply Join the conversation
4 Comments 4
jeanbiverly_
QuickBooks Team
QuickBooks Team
‎November 16, 2023 02:51 PM

Donor Report

I'm here to help you run a report for all deposits assigned to your customers, @bmcc1200.

 

You can access the Deposit Detail report, which displays specific transactions and linked invoices and payments. Let me guide you how.

 

  1. From the left navigation panel, open the Reports menu.
  2. In the Find report by name search bar, enter Deposit Detail and click on it.

 

Also, you can open the Transaction List by Customer report. This displays all the charges for a customer. To do so, you can follow these steps:

 

  1. Go to Reports.
  2. Type and select Transaction List by Report in the Find report by name field.

 

Currently, the option to view customer deposits in the customer list is unavailable in QuickBooks Online (QBO). To see a customer's deposits, go to their profile and filter the transaction type to all plus deposits.

 

  1. Pull up the Sales menu.
  2. Go to the Customers tab.
  3. Select a customer.
  4. In the Transaction list tab, click the Type dropdown and choose All plus deposits.

 

In case you want to print deposit slips, you can check out this article for more guidance: Set up and print deposit slips.

 

I'm still here to back you up if you need further assistance with your customers' deposits. Just hit the Reply button.

Reply Join the conversation
BigRedConsulting
Community Champion
Community Champion
‎November 16, 2023 03:07 PM

Donor Report

You've discovered some of the many report limitations in QB Online compared to QB Desktop. You've essentially moved from a Rolls Royce to a Chevy.

 

QuickBooks online won't create proper donor statements. Instead, try our BRC Donor Statements - QB Online , which uses several QB Online reports, exported to Excel, to create proper statements for you with no additional data entry.

 

It will include data from sales like invoices and sales receipts, as well as details from your deposits, and allocate them to each donor.

 

It features a 30-day free trial so you can try before you buy. You can download and install it using the link above.

Reply Join the conversation
bmcc1200
Level 3
‎November 18, 2023 03:16 AM

Donor Report

I'm here to help you run a report for all deposits assigned to your customers, @bmcc1200.

 

You can access the Deposit Detail report, which displays specific transactions and linked invoices and payments. Let me guide you how.

 

From the left navigation panel, open the Reports menu. In the Find report by name search bar, enter Deposit Detail and click on it.

[Bob:] this seem to have the most promise,

bmcc1200_0-1700306195626.png

 

But I need to eliminate the second line with check number.  Is there a way to do that.  From there I can push it to excel and do a pivot table.  I suppose I don’t need to tell you how nice the summary reports are in desktop.

 

Also, you can open the Transaction List by Customer report. This displays all the charges for a customer. To do so, you can follow these steps:

 

Go to Reports. Type and select Transaction List by Report in the Find report by name field.

[Bob:] This also has promise.  I got it to one lone, but there is no way I could see to add customer name as one of the columns.  Is there a way? Is there an API I can buy to get to the SQL?

bmcc1200_1-1700306195633.png

 

 

Currently, the option to view customer deposits in the customer list is unavailable in QuickBooks Online (QBO). To see a customer's deposits, go to their profile and filter the transaction type to all plus deposits.

[Bob:] No practical for what I need.

 

Pull up the Sales menu. Go to the Customers tab. Select a customer. In the Transaction list tab, click the Type dropdown and choose All plus deposits.

[Bob:] Not practical and to boot the deposits are not associated it this report with my customers.  I think it is because so many deposits are made together and the deposit become a split.  Serious deficiency in QBO!  Thanks again for reaching out.  Hope you have some more answers

 

In case you want to print deposit slips, you can check out this article for more guidance: Set up and print deposit slips.

 

I'm still here to back you up if you need further assistance with your customers' deposits. Just hit the Reply button.

Reply Join the conversation
Shania_C
QuickBooks Team
QuickBooks Team
‎November 18, 2023 04:49 AM

Donor Report

Hi, there @bmcc1200. 

 

Thank you for the detailed explanation. I understand the importance of resolving your issue concerning running a report for all deposits assigned to your customers, and I am here to provide some insights.

 

The ability to eliminate the second line with the check number in the Deposit Detail Report, and also adding the customer's name as one of the columns in the Transaction List Report is not yet available in QuickBooks Online. As a workaround, you can export the reports and manually edit them according to your preferences.

 

Moreover, regarding your concern about purchasing SQL in API, we have a platform dedicated to addressing API-related concerns. Here is an article that offers solutions. I suggest contacting Intuit Development Support for further assistance, as they can guide the necessary steps and actions.

 

Here's how:

 

  1. Go to this link: https://help.developer.intuit.com/s/.
  2. Choose your QuickBooks product.
  3. Click on Ask a Question.
  4. Please sign in and follow the prompts appearing on the screen to continue.

 

Our collection of self-help articles offers valuable guidance for utilizing QuickBooks in the future. For QuickBooks Support, please refer to our website.

 

Feel free to reach out if you need additional guidance with your QuickBooks Reports. Stay safe!

Reply Join the conversation
Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us