June's Stuff You Need to Know Forum Contest

What are YOUR favorite resources you use when working in Financial Reports? What tips and tricks do you share to WOW your fellow RE users?
Leave them in the comments below, and then the tip or resource with the most likes at the end of the month will receive a gift card. We'll be accepting suggestions all month, but the sooner you post, the more time your post has to generate likes.
Also, don't forget to join us for our Financial Reports Live Chat this Wednesday, June 8!
Comments
-
I use Pivot Reports to compare YTD numbers against the last fiscal YTD. It takes some setting up and upkeep, but it works fairly well.2
-
I think the most useful tip I've received has to do with the small checked options under the Financial Reports "Gift Types" tab. Specifically, the last one - "Calculate gift balance based on date range, campaign, fund, and appeal". Our last DBA never noticed that button (or else didn't know what it meant) and thought she HAD to run all our fiscal year-end reports the last day of the fiscal year, or else her numbers would be errant. Little did she know all she had to do was click one little button, and she could have run them at her leisure anytime over the next two months.
So, my tip is: watch those small button settings! They make a huge difference in report results.7 -
I see that button but it's grayed out on my existing reports. Tried creating a new report and it's grayed out on that template as well.0
-
Because it applies specifically to pledges, it only becomes active when you select a "Pledge" gift type, and then click on the "Use gift balance instead of gift amount" button right above it. So what it does is, if you are needing to run a report that includes pledge balances as of fiscal year's end, it will calculate the balance remaining as of fiscal year end, instead of the date you are currently running the report.1
-
Sunshine Watson:
I use Pivot Reports to compare YTD numbers against the last fiscal YTD. It takes some setting up and upkeep, but it works fairly well.0 -
we use the pledge status report (summary) on a monthly basis and like the ability to use it in conjunction with the activity report (detail) to make sure our monthly figures equal and match our FE general ledger reports.1
-
Utilizing the Donor Category Report to export for the honor roll of donors, include the soft credit because they are flagged with a symbol, and then you can be sure that everyone is recognized at the right level and using their "for publications/recognition" name. And then if there are other donor lists that are alphabetical, you can run them sorted alpha.
Gift Detail and Summary has been great for reconcilation when you are not linked with your finance department software. Export the report and sort it by Fund and Batch. Easy to find the discrepencies, if there are any.1 -
I use the Gift Detail and Summary Report far more than any other report, but this tip is useful in many different reports: When filtering on campaigns, funds or appeals, you can select each one specifically OR use a query. I find this helpful especially for limiting gifts included to those with specific types of funds or appeals that I can easily query. On the Filters tab, change filter option to "Include Selected" and a window opens with two buttons at the top - "Selected" which is the default and "Query". If you click "Query" another window opens that allows you to then choose the query you want to use. Finding this has made it easy to do highly specific reporting on funds and appeals.
0 -
I love the Summary version of the Cash Receipts Journal as a means to balance at the end of the month with the GL. If you've entered your GL numbers on the Fund records, the report can even list those.0
-
Faith Murray:
I think the most useful tip I've received has to do with the small checked options under the Financial Reports "Gift Types" tab. Specifically, the last one - "Calculate gift balance based on date range, campaign, fund, and appeal". Our last DBA never noticed that button (or else didn't know what it meant) and thought she HAD to run all our fiscal year-end reports the last day of the fiscal year, or else her numbers would be errant. Little did she know all she had to do was click one little button, and she could have run them at her leisure anytime over the next two months.
So, my tip is: watch those small button settings! They make a huge difference in report results.Thanks for all the great tips, everyone! With the most votes last month, Faith Murray is the winner of June's Need to Know Forum Contest with her reminder to allways check the checkboxes on your reports. I'll follow up with Faith, but in the meantime, check out this month's Query Need to Know resources and Forum Contest for another chance to share your wisdom and win a sweet prize! Also, please join me in our Query LiveChat later this month!
For more info on the suggestions in the contest, check out these Knowledgebase articles:0 -
Faith Murray:
I think the most useful tip I've received has to do with the small checked options under the Financial Reports "Gift Types" tab. Specifically, the last one - "Calculate gift balance based on date range, campaign, fund, and appeal". Our last DBA never noticed that button (or else didn't know what it meant) and thought she HAD to run all our fiscal year-end reports the last day of the fiscal year, or else her numbers would be errant. Little did she know all she had to do was click one little button, and she could have run them at her leisure anytime over the next two months.
So, my tip is: watch those small button settings! They make a huge difference in report results.Under Financial Reports, I don't have a "Gift Types" tab. We are on 7.93 and are self hosted. Are you on RE NXT?
0 -
Jill Freidmutter:
Under Financial Reports, I don't have a "Gift Types" tab. We are on 7.93 and are self hosted. Are you on RE NXT?
Not on NXT, but we are on 7.95. I was referring to the Gift Types tab within a specific report, like when creating a new Gift Detail and Summary Report - sorry if I wasn't clear!
0 -
Faith Murray:
Jill Freidmutter:
Under Financial Reports, I don't have a "Gift Types" tab. We are on 7.93 and are self hosted. Are you on RE NXT?
Not on NXT, but we are on 7.95. I was referring to the Gift Types tab within a specific report, like when creating a new Gift Detail and Summary Report - sorry if I wasn't clear!ah! thank you for clarifying.
0
Categories
- All Categories
- Shannon parent
- shannon 2
- shannon 1
- 21 Advocacy DC Users Group
- 14 BBCRM PAG Discussions
- 89 High Education Program Advisory Group (HE PAG)
- 28 Luminate CRM DC Users Group
- 8 DC Luminate CRM Users Group
- Luminate PAG
- 5.9K Blackbaud Altru®
- 58 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 409 bbcon®
- 2.1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- donorCentrics®
- 1.1K Blackbaud eTapestry®
- 2.8K Blackbaud Financial Edge NXT®
- 1.1K Blackbaud Grantmaking™
- 527 Education Management Solutions for Higher Education
- 1 JustGiving® from Blackbaud®
- 4.6K Education Management Solutions for K-12 Schools
- Blackbaud Luminate Online & Blackbaud TeamRaiser
- 16.4K Blackbaud Raiser's Edge NXT®
- 4.1K SKY Developer
- 547 ResearchPoint™
- 151 Blackbaud Tuition Management™
- 1 YourCause® from Blackbaud®
- 61 everydayhero
- 3 Campaign Ideas
- 58 General Discussion
- 115 Blackbaud ID
- 87 K-12 Blackbaud ID
- 6 Admin Console
- 949 Organizational Best Practices
- 353 The Tap (Just for Fun)
- 235 Blackbaud Community Feedback Forum
- 55 Admissions Event Management EAP
- 18 MobilePay Terminal + BBID Canada EAP
- 36 EAP for New Email Campaigns Experience in Blackbaud Luminate Online®
- 109 EAP for 360 Student Profile in Blackbaud Student Information System
- 41 EAP for Assessment Builder in Blackbaud Learning Management System™
- 9 Technical Preview for SKY API for Blackbaud CRM™ and Blackbaud Altru®
- 55 Community Advisory Group
- 46 Blackbaud Community Ideas
- 26 Blackbaud Community Challenges
- 7 Security Testing Forum
- 1.1K ARCHIVED FORUMS | Inactive and/or Completed EAPs
- 3 Blackbaud Staff Discussions
- 7.7K ARCHIVED FORUM CATEGORY [ID 304]
- 1 Blackbaud Partners Discussions
- 1 Blackbaud Giving Search™
- 35 EAP Student Assignment Details and Assignment Center
- 39 EAP Core - Roles and Tasks
- 59 Blackbaud Community All-Stars Discussions
- 20 Blackbaud Raiser's Edge NXT® Online Giving EAP
- Diocesan Blackbaud Raiser’s Edge NXT® User’s Group
- 2 Blackbaud Consultant’s Community
- 43 End of Term Grade Entry EAP
- 92 EAP for Query in Blackbaud Raiser's Edge NXT®
- 38 Standard Reports for Blackbaud Raiser's Edge NXT® EAP
- 12 Payments Assistant for Blackbaud Financial Edge NXT® EAP
- 6 Ask an All Star (Austen Brown)
- 8 Ask an All-Star Alex Wong (Blackbaud Raiser's Edge NXT®)
- 1 Ask an All-Star Alex Wong (Blackbaud Financial Edge NXT®)
- 6 Ask an All-Star (Christine Robertson)
- 21 Ask an Expert (Anthony Gallo)
- Blackbaud Francophone Group
- 22 Ask an Expert (David Springer)
- 4 Raiser's Edge NXT PowerUp Challenge #1 (Query)
- 6 Ask an All-Star Sunshine Reinken Watson and Carlene Johnson
- 4 Raiser's Edge NXT PowerUp Challenge: Events
- 14 Ask an All-Star (Elizabeth Johnson)
- 7 Ask an Expert (Stephen Churchill)
- 2025 ARCHIVED FORUM POSTS
- 322 ARCHIVED | Financial Edge® Tips and Tricks
- 164 ARCHIVED | Raiser's Edge® Blog
- 300 ARCHIVED | Raiser's Edge® Blog
- 441 ARCHIVED | Blackbaud Altru® Tips and Tricks
- 66 ARCHIVED | Blackbaud NetCommunity™ Blog
- 211 ARCHIVED | Blackbaud Target Analytics® Tips and Tricks
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- Luminate CRM DC Users Group
- 225 ARCHIVED | Blackbaud eTapestry® Tips and Tricks
- 1 Blackbaud eTapestry® Know How Blog
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)
- 1 Blackbaud K-12 Education Solutions™ Blog
- 280 ARCHIVED | Mixed Community Announcements
- 3 ARCHIVED | Blackbaud Corporations™ & Blackbaud Foundations™ Hosting Status
- 1 npEngage
- 24 ARCHIVED | K-12 Announcements
- 15 ARCHIVED | FIMS Host*Net Hosting Status
- 23 ARCHIVED | Blackbaud Outcomes & Online Applications (IGAM) Hosting Status
- 22 ARCHIVED | Blackbaud DonorCentral Hosting Status
- 14 ARCHIVED | Blackbaud Grantmaking™ UK Hosting Status
- 117 ARCHIVED | Blackbaud CRM™ and Blackbaud Internet Solutions™ Announcements
- 50 Blackbaud NetCommunity™ Blog
- 169 ARCHIVED | Blackbaud Grantmaking™ Tips and Tricks
- Advocacy DC Users Group
- 718 Community News
- Blackbaud Altru® Hosting Status
- 104 ARCHIVED | Member Spotlight
- 145 ARCHIVED | Hosting Blog
- 149 JustGiving® from Blackbaud® Blog
- 97 ARCHIVED | bbcon® Blogs
- 19 ARCHIVED | Blackbaud Luminate CRM™ Announcements
- 161 Luminate Advocacy News
- 187 Organizational Best Practices Blog
- 67 everydayhero Blog
- 52 Blackbaud SKY® Reporting Announcements
- 17 ARCHIVED | Blackbaud SKY® Reporting for K-12 Announcements
- 3 Luminate Online Product Advisory Group (LO PAG)
- 81 ARCHIVED | JustGiving® from Blackbaud® Tips and Tricks
- 1 ARCHIVED | K-12 Conference Blog
- Blackbaud Church Management™ Announcements
- ARCHIVED | Blackbaud Award Management™ and Blackbaud Stewardship Management™ Announcements
- 1 Blackbaud Peer-to-Peer Fundraising™, Powered by JustGiving® Blogs
- 39 Tips, Tricks, and Timesavers!
- 56 Blackbaud Church Management™ Resources
- 154 Blackbaud Church Management™ Announcements
- 1 ARCHIVED | Blackbaud Church Management™ Tips and Tricks
- 11 ARCHIVED | Blackbaud Higher Education Solutions™ Announcements
- 7 ARCHIVED | Blackbaud Guided Fundraising™ Blog
- 2 Blackbaud Fundraiser Performance Management™ Blog
- 9 Foundations Events and Content
- 14 ARCHIVED | Blog Posts
- 2 ARCHIVED | Blackbaud FIMS™ Announcement and Tips
- 59 Blackbaud Partner Announcements
- 10 ARCHIVED | Blackbaud Impact Edge™ EAP Blogs
- 1 Community Help Blogs
- Diocesan Blackbaud Raiser’s Edge NXT® Users' Group
- Blackbaud Consultant’s Community
- Blackbaud Francophone Group
- 1 BLOG ARCHIVE CATEGORY
- Blackbaud Community™ Discussions
- 8.3K Blackbaud Luminate Online® & Blackbaud TeamRaiser® Discussions
- 5.7K Jobs Board