cancel
Showing results for 
Search instead for 
Did you mean: 
ixAmjadxi
Level 2

Statement for Donor contributions.

Hi everyone,

So I'm using QBO and I do the booking for non-profit organization, any donation come to the bank account I recorder it Received From the Donor "Customer" name. I manage to run a report called revenue by Donor summary showing the total amount the donors contributed during a specific period.

What I'm trying to do is running a report showing the details, meaning each contribution received during the period from a donor. Whenever I try to run such a report it comes out empty. I looked into some discussions here for help, but I end up with same results.

Any idea please? Am I doing something wrong? 

Thanks in advance! 

Amjad

Solved
Best answer March 02, 2024

Best Answers
FateCandylaneT
QuickBooks Team

Statement for Donor contributions.

I appreciate your prompt response and for performing the steps above, ixAmjadxi. Let me provide detailed insight to make sure you'll get to review each contribution received from a donor during a specific period.

 

As shared by my colleague CharleneMaeF above, the steps and information are the details you need to view each contribution you receive. However, this data is shown under the Transaction List by Donor report. To guide you with the process, I've included screenshots for your reference:

 

  1. In your QBO account, go to Reports and enter Transaction List by Donor report from the search field section.
  2. Click on the Switch to Classic View button for an easier process.
  3. Select the Customize icon and enter a specific date under the Report period section.
  4. From the Change Columns section, choose how you want to display the data.
  5. Under the Filter dropdown, modify all specific information you need.
  6. Review all details and click Run Report.

 

Transaction List by Donor reprot.png

 

customized transaction list by donor report.png

 

If you want to save all customizations made to your reports, you can memorize them and export these data to an Excel file.

 

I'll be leaving this forum available, so you can always reply to this post whenever you require additional assistance managing business finances in your account. Just let me know anytime, and I'll ensure to get you covered. Keep safe and have a good one!

View solution in original post

11 Comments 11
CharleneMaeF
QuickBooks Team

Statement for Donor contributions.

I appreciate you for sharing a detailed explanation of your concern, ixAmjadxi. Let's work together to run and modify the report that you're looking for.

 

The Revenue by Donor Summary only shows the revenue minus your expenditures (net income) for each donor, not the lists of transactions. To view each contribution you receive, we can run the Transaction Detail by Donor instead. I'll show you how:

 

  1. Go to Reports.
  2. Type in Transaction Detail by Donor in the Search field.
    1.PNG
  3. Click the Switch to classic view button to easily personalize it.
    3.PNG
  4. Select Customize.
    4.PNG
  5. In the Report period section, enter the correct dates.
    5.PNG
  6. Then, choose Change columns to decide how you like to display the data.
    6.PNG
  7. On the Filter part, click Transaction type and add the entries you want to view under All
  8. Modify the other filters.
  9. Once done, hit Run report.
    7.PNG

 

You also have the option to access and personalize the Transaction Detail by Account as an alternative. For visual reference, I've added a screenshot below.
8.PNG

 

If you still want to pull up the Revenue by Donor Summary data, please ensure the correct Accounting method (Cash or Accrual) is selected. It could be the reason why it's empty. 

 

Finally, QuickBooks Online provides the flexibility to export your reports to Microsoft Excel. It allows you to use your data outside of QuickBooks or modify how the details are displayed.

 

Please know that you're always welcome to reach out for further inquiries about the process. I'm always ready to assist you.

BigRedConsulting
Community Champion

Statement for Donor contributions.

QuickBooks Online won't create real donor statements.

 

When you're ready do to that, one way is to use our BRC Donor Statements - QB Online, which uses a collection of reports send from QB Online to Excel to collect and reformat the donation data into proper donor statements. It will include donations entered in various ways, including those entered as sales receipts and deposits. 

 

The tool includes a free trial, so you can try before you buy. No strings attached.

ixAmjadxi
Level 2

Statement for Donor contributions.

Hi,

Thank you for your detailed reply, although when I search for Transaction Detail by Donor, I couldn't find it. Is it something I need to build from the scratch?

Thank you!

Snag_1767a84.png

ixAmjadxi
Level 2

Statement for Donor contributions.

Hi,

Thank you for your detailed reply, although when I search for Transaction Detail by Donor, I couldn't find it. Is it something I need to build from the scratch?

Thank you!

Snag_187ffbe.png

Candice C
QuickBooks Team

Statement for Donor contributions.

Good afternoon, @ixAmjadxi

 

Thanks for chiming back in and giving us additional information. 

 

My colleague's screenshot and details show a report that is actually referred to as another name that what they stated. They changed the label/name of the report to say donor instead of customer. 

 

With that being said, I recommend running the Transaction List by Customer report and customizing it to your liking. 

 

If you have any other questions, feel free to ask. Have a wonderful day! 

ixAmjadxi
Level 2

Statement for Donor contributions.

Hi @Candice C ,

Thank you for your reply, but even with Transaction List by Customer name I still can't find the report.

 

Please see below:

FateCandylaneT
QuickBooks Team

Statement for Donor contributions.

I appreciate your prompt response and for performing the steps above, ixAmjadxi. Let me provide detailed insight to make sure you'll get to review each contribution received from a donor during a specific period.

 

As shared by my colleague CharleneMaeF above, the steps and information are the details you need to view each contribution you receive. However, this data is shown under the Transaction List by Donor report. To guide you with the process, I've included screenshots for your reference:

 

  1. In your QBO account, go to Reports and enter Transaction List by Donor report from the search field section.
  2. Click on the Switch to Classic View button for an easier process.
  3. Select the Customize icon and enter a specific date under the Report period section.
  4. From the Change Columns section, choose how you want to display the data.
  5. Under the Filter dropdown, modify all specific information you need.
  6. Review all details and click Run Report.

 

Transaction List by Donor reprot.png

 

customized transaction list by donor report.png

 

If you want to save all customizations made to your reports, you can memorize them and export these data to an Excel file.

 

I'll be leaving this forum available, so you can always reply to this post whenever you require additional assistance managing business finances in your account. Just let me know anytime, and I'll ensure to get you covered. Keep safe and have a good one!

DonorStatements
Level 1

Statement for Donor contributions.

QuickBooks itself does not currently include a way to do this natively. We faced the same problem ourselves. After trying many different third-party solutions, none of which met our needs, finally we built our own powerful web app to make it extremely simple to bulk generate beautiful IRS-compliant statements for all your donors as once, or create a statement for an individual donor.

 

We also have many powerful filters to tailor make statements according to your own criteria.

 

You can set our app to automatically email statements to each donor, or print a PDF to mail them out as you prefer. Please take a look at www.donorstatements.com

HPHH
Level 1

Statement for Donor contributions.

There is no transaction by donor report.  I run a nonprofit, and I can't seem to find a report anywhere that lists both income by donor AND which donor was used for transactions.  I need an itemized list that says what each donor's money was used for.  

HPHH
Level 1

Statement for Donor contributions.

There is no transaction by donor report.  I don't understand how there is a way to add which donor you are using money from for a transaction, and yet you can't find a report to run that shows income by donor AND which transaction was linked to donor.  I run a nonprofit and I need an itemized list that shows not only donor income (I can find that), but also shows a list of transactions that were linked to donor.  Some grants/foundations ask for reports to see where their money is going to, it would be nice to have a report to run  to show each transaction so a donor would see where and how their money is being spent.    

Candice C
QuickBooks Team

Statement for Donor contributions.

Hey there, @HPHH

 

Thanks for chiming on this thread. I'd be more than happy to help you find this list within your QuickBooks Online account. 

 

To gather some additional information, can you provide me with the names of the reports that you search, "Transaction List by ...?"

 

This will help us determine why you're not able to see the report and what to do in your next steps. I'll be waiting for your response! 

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

Need to get in touch?

Contact us