cancel
Showing results for 
Search instead for 
Did you mean: 
Beverly B
Level 1

Statement of Activity for nonprofit in QB Desktop

How is it possible to modify reports in QB Desktop to produce a Statement of Activity for a small local nonprofit?

 

5 Comments 5
JoesemM
Moderator

Statement of Activity for nonprofit in QB Desktop

 Hi there, @Beverly B.

 

Can you share more details about  the report you'll want to modify? I just want to make sure that we're giving you the right steps and information to address the issue.

 

Just leave it in the comments section below. It's my priority to help. Take good care!

Beverly B
Level 1

Statement of Activity for nonprofit in QB Desktop

A "Statement of Activity" is a standard of reporting for a nonprofit  . . . see attached . . . I am trying to run the books of a nonprofit in QBDT Pro 2023 . . . 

 

 

The purpose of the nonprofit statement of activities is to provide detailed information about the organization’s transactions and how those activities help further the organization’s mission through various initiatives and programs.

 

When your statement of activities is complete, it will look something like this:

JaeAnnC
QuickBooks Team

Statement of Activity for nonprofit in QB Desktop

I've got you covered, Beverly.

 

Currently, we're unable to customize the Statement of Activity report to display the Restricted and Unrestricted funds. However, I can walk you through exporting it to Excel so you can manually input the data.

 

To do that:

 

  1. Go to Reports, select Company & Financial, and click Statement of Activity.
  2. Select the Excel dropdown and click Create New Worksheet.
  3. Choose how you'd like to export and select Export.

 

Furthermore, you can set up a memorized report in QBDT if you want the same settings available for future use. It saves you from having to repeat the customization procedure. 

 

Feel free to return to this thread if you need additional assistance customizing reports. I'm available anytime to answer your concerns. Keep safe.

Beverly B
Level 1

Statement of Activity for nonprofit in QB Desktop

Yes, however, in my dropdown on desktop QB Pro 2023 under Reports, Company and Financials there is no Statement of Activity option . . . 

LeizylM
QuickBooks Team

Statement of Activity for nonprofit in QB Desktop

Hi there,Beverly B. 

 

Allow me to share some clarification about modifying reports in QuickBooks Desktop (QBDT).  

 

The Statement of Activity provided by the previous agent applies to QuickBooks Online (QBO). In QBDT, we can run a Statement of Cash Flows and export it to Excel. This way, you can manually input the Data.

 

I've added a screenshot for your reference. 

 

 

 

Additionally, I've added these articles that'll help you learn more about reports and help you personalized them:
 

 

I'll be right here to continue helping if you have any other concerns about customizing reports in QBDT. Have a good one. 

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

Need to get in touch?

Contact us