Sample Report Writer reports
The following are out-of-the-box reports created with Report Writer.
Note: Report Writer - Basic is available to all users and is not a licensed feature. Basic includes ExpressView reports. Report Writer - Plus is a licensed feature. Plus includes ExpressView, AdvancedReports, and Dashboards. Contact your CPIL or AiSP for more information.
In addition, any sample report can be duplicated and tailored to your organizations needs. This can be accomplished by using a Template. See Creating an Advanced Report based on a template for more information.
To find these reports, go to Reports > Report Writer.
Commerce Reports
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Lists detail for all orders in the system with filters for order type and status.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Prints order system invoices, including credit memos and debit memos. Can be filtered by invoice date, Bill to contact, Ship to contact, order number, invoice number, or invoice balance. VAT information will appear if applicable.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
ExpressView report showing orders since the beginning of year by country and state/province.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
ExpressView report showing orders since the beginning of year by order type.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Displays order details in a printer-friendly format.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Displays order details in a printer-friendly format.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Prints order system invoices, including credit memos and debit memos. VAT information will appear if applicable. Intended for use in the Print tab of the Invoice detail screen (filtered to InvoiceId specified in the URL).
Tip! Do not run this report in Report Writer. To use this report on the Print tab, see Using Report Writer invoices on the Print tab of the invoice display.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
List of order product sales grouped by category and then title within the date range specified. Includes only orders that have been ordered within the selected date range.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Cross tab report showing the quantity of products sold by category and month for the specified date range.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Prints a quotation for orders in the QUOTEREADY stage.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Comprehensive summary of promotions including revenue received by item, number of times used by item, and items purchased.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Comprehensive summary of promotions including revenue received by promotion and number of times used by promotion.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Prints a packing slip for the selected order.
Contacts Reports
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
This report prints labels on letter-size (8.5 x 11 inches) Avery 5162 or 5262 stock. Contacts are included only if their Status starts with A.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
This report prints labels on A4-size (210 x 297 mm) Avery L7162 stock.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
This report prints 3-column labels on letter-size stock.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
This report prints 3-column labels on A4-size stock.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Prints a full resume-like profile for a selected record including all available fields and activities.
Events Reports
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Prints event badge and tickets for any registration options and program items for the selected event that have Print tickets enabled. Separate page for each registrant.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Prints event badges 6 per page.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Prints event badges 8 per page.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Prints a certificate of completion for each attendee of the selected event. Choose whether or not to include the event dates.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Prints event invoices for the specified event. Can be filtered by invoice date, Bill to contact, Ship to contact, order number, invoice number, or invoice balance. VAT information will appear if applicable.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Sends event registrants an invoice as an attachment to a communication template.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Displays a list of all event registrants for the selected event. Includes the attendee's name, company, email, city, state/province, and country.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Prints event invoices for the event and registrant specified in the URL. VAT information will appear if applicable. See Using the Report Writer event invoice report for details.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Prints event invoices. VAT information will appear if applicable. Intended for use in the Print tab of the Invoice detail screen (filtered to InvoiceId specified in the URL).
Tip! Do not run this report in Report Writer. To use this report on the Print tab, see Using Report Writer invoices on the Print tab of the invoice display.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Prints a certificate of completion for each attendee of the selected program item. Text of the certificate can be customized using parameters, including a logo.
Note: The Include Financial Entity Logo parameter uses the logo of the Financial entity for the selected event, if there is one defined. If there is no Financial Entity defined for the event, the logo parameter uses the Meetings entity. If there is no entity defined for Meetings, the entity defined as the default Financial Entity for the system will be used.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Displays valuable event information such as, total event revenue, number of events, total registrations across all events, cancellations, revenue by event, and more.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Displays who registered for the program items of an event. Contains the registrant's name, organization, quantity purchased, and email address.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Prints event tickets for the program items of the selected event that have Print tickets enabled. Separate page for each registrant.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Prepares a formal registration list suitable for vendor hand-out. Filters allow the user to include or exclude the registrant's phone number, full address, email address, and if they have any guests. There is also an option to include or exclude registrants who have canceled their registration.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Displays who registered for the registration options of an event. Contains the registrant's name, organization, quantity purchased, and email address.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
ExpressView report showing event registrations by chapter.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Displays the number of registrants for the selected event by the number of weeks prior to the event's begin date.
Finance Reports
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
A statement of a contact's outstanding invoice balances. This report excludes invoices with zero balances, future dates (i.e. pledges), AutoPay invoices, and invoices using the Cash accounting method.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
The Invoice Attachment report can be used as an attachment in a communication template with with any recipient query that has an Invoice Number display column.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Default invoice report, intended for use with Membership (DUES) and Fundraising (FR) invoices. Displays invoice details without any special formatting for events, orders, or taxation. Can be filtered by invoice date, invoice number, bill to contact, or open balance amount.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
A statement of a contact's outstanding invoice balances attached to a communication template. This report excludes invoices with zero balances, future dates (for example, pledges), AutoPay invoices, and invoices using the Cash accounting method.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Payment detail report that displays information about the specified payment and what it was applied to. Excludes payments that are pending, reversed, voided, or fully refunded.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Default invoice report, intended for use with Membership (DUES) and Fundraising (FR) invoices. Displays invoice details without any special formatting for events, orders, or taxation. Intended for use in the Print tab of the Invoice detail screen (filtered to InvoiceId specified in the URL).
Tip! Do not run this report in Report Writer. To use this report on the Print tab, see Using Report Writer invoices on the Print tab of the invoice display.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Payment detail report that displays information about the specified payment and what it was applied to. Excludes payments that are pending, reversed, voided, or fully refunded. Intended to be used from a location where a specific payment ID is passed in the URL.
Do not run this report in Report Writer. To run this report, navigate to one of the following locations:
- Transactions tab on staff account pages in the Payments section
- Transactions tab on public user account pages in the Payments section
- Finance > Pay Central > Find payments using the Find Payments query
To use a custom version of this report in the above locations, see Creating and using a custom payment receipt.
From the Find payments query:
From the Staff account pages (Transactions tab):
Fundraising Reports
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
ExpressView report showing donors by country and state/province.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Comprehensive summary of Fund results and statistics for a specified date range. Provides a snapshot of each Fund with a summary of number of donors, number of gifts, and amount for Gifts and Pledges separately.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Displays information such as, amount of funds raised, amount of donations, number of donors, average amount of donation, donations by fund, donations by campaign, and donations over time. Use the drop-down in the top-right to change the year.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Provides details for each Gift from Fundraising, Events, and Dues, grouped by donor.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Comprehensive summary of gift item results and statistics for a specified date range. Provides a snapshot of each gift item with a summary of number of donors, number of gifts, and amount for gifts and pledges separately. Split gifts created in iMIS Desktop are not included
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Total gift amounts for the specified date range with Fair Market Value and Eligible Amount for Receiptable and Non-Receiptable gifts, broken out by payment method. Gifts with voided receipts are excluded. Optionally filter by one or more payment methods, or by Individuals or Organizations. This report can be used to report on total gift amounts for tax reporting purposes, with the ability to break out the totals by receiptable vs. non-receiptable gifts, In Kind vs. non-In Kind gifts, and gifts by Individuals vs. Organizations.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
ExpressView report showing gift amounts by fund for the current year.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Lists donors who made donations (including charitable dues and event functions) during a given time frame but have not given since that time frame (“Last Year But Not This Year”). Includes information about the last gift, and the total count and amount of lifetime gifts.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Lists gifts which are given as a tribute to someone, including the tribute type, honoree, message and notify contact. Can be filtered by gift date or amount, donor, honoree or notify contact.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Provides a summary of all pledge amounts, total amount paid, and the total outstanding balance for each donor, as well as the amount of expected pledge payments broken into each year.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Comprehensive summary of source code results and statistics. Provides a snapshot of each source code with a summary of number of donors, number of gifts, and amount for Gifts and Pledges separately.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Lists donors who made donations “Some Year But Unfortunately Not This Year”. Donors will be included if their last gift was more than two years prior to the run date of the report (based on calendar year; fiscal year is not taken into consideration).
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Prints a list of the top donors based on their gift amounts (including pledge payments) for the specified date range. User can select the number of donors to return, up to a maximum of 100 donors. This list can be filtered by donors only or organizations only.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Prints a grid of gift and pledge counts and totals for the current year and the preceding four calendar years. Categorized by New Donors (the year the donor made their first contribution), Established Donors, and Total.
Membership Reports
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Lists the number of members expiring in each month and year by customer type.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
ExpressView report showing active members by country and state/province.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Prints membership cards formatted for Avery 5392 badge stock with a barcode for the member's ID. Export to PDF template for correct formatting.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Lists all unpaid members with the membership fee lines and amounts outstanding.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Lists all unpaid membership fees grouped by member, including the amounts outstanding.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Prints a renewal notice invoice for a member's dues.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Generates a membership renewal notice invoice that can be attached to a communication template.