More information

Reporting World

Standard Daily Reports

The Daily Reports Template Group contains templates for creating the reports necessary to process, balance, acknowledge, and receipt daily transactions.

When you activate the New Criteria item under the Reporting World in the Millennium Explorer, you will see the names of the standard reporting groups (libraries). When the Daily group is selected, all standard templates available for that group will appear in an indexed page in the display frame to the right. Each template name in the group will appear in an alphabetical listing. You may scroll or use the index letters at the top of the page to locate the name of the desired template.

Each name appears as a hyperlink to the display of a Report Form, showing the suggested criteria and report options, which can be modified as necessary. Standard formats have also been established for each template.

Each report template in this library is described in the following document, with suggestions for user modifications. All report templates utilize the Millennium standard Generic Worktable. Each utilizes a standard Millennium format definition of the same name as the report template. These were created using the third party software, Crystal Reports.

In this document, each template description includes a thumbnail view of a sample report that was produced using the report template that is being described. For a larger view of the sample report, click the thumbnail and an additional browser will open, showing a scanned image of the print version of the sample report. When you are finished viewing the larger image, close that browser and return to this document in the original browser.

 

A   B   C   D   E   F   G    H   I   J    K   L   M    N   O   P    Q   R   S    T   U   V    W   X   Y    Z

 

B

Batch Control Log - Dues

Purpose and Description:

This report prints out a list of all dues, payments, bequests, and any journals of those transactions, processed on the specified date. They are grouped first by the User ID of the operator who entered the transactions, and then by Batch Number. A total is shown for each batch and a notation shows whether that calculated total shown in the report matches the total amount for that Dues Batch Number lookup table entry. The report is used to track batch and user transaction totals.

Criteria:

The standard criteria selects all dues, pledge payments, bequests and dues, payment, or bequest journals and voids processed on the current day.

Report Options:

Do not combine spouse names, Allow Multiples, Include deceased

Parameters:

None

Sorting/Grouping:

This primary sort for this report is by the User ID of the operators who created the transactions. Within User ID, transactions are sorted by batch and then transaction number.

HTML Compatibility:

This report is optimized for printing, but it may also be published in HTML. The spacing and alignment of the HTML version may differ from the print version somewhat.

Customization Tips

Criteria:

The criteria could be modified to prompt the user for the desired date when the report is run. Other transaction types could also be included in the criteria. Criteria could be edited to use the Effective Date rather than the Process Date.

Options:

To ensure proper transaction counts and dollar amounts, options should not be changed.

TOP

Batch Control Log - Giving

Purpose and Description:

This report prints out a list of all gifts, payments, bequests, and any journals of those transactions, processed on the specified date. They are grouped first by the User ID of the operator who entered the transactions, and then by Batch Number. A total is shown for each batch and a notation shows whether that calculated total shown in the report matches the total amount for that Gift Batch Number lookup table entry. The report is used to track batch and user transaction totals.

Criteria:

The standard criteria selects all gifts, pledge payments, bequests and gift, payment, or bequest journals and voids processed on the current day.

Report Options:

Do not combine spouse names, Allow Multiples, Include deceased

Parameters:

None

Sorting/Grouping:

This primary sort for this report is by the User ID of the operators who created the transactions. Within User ID, transactions are sorted by batch and then transaction number.

HTML Compatibility:

This report is optimized for printing, but it may also be published in HTML. The spacing and alignment of the HTML version may differ slightly from the optimized version.

Customization Tips

Criteria:

The criteria could be modified to prompt the user for the desired date when the report is run. Other transaction types could also be included in the criteria. Criteria could be edited to use the Effective Date rather than the Process Date.

Options:

To ensure proper transaction counts and dollar amounts, options should not be changed.

TOP

D

Daily Acknowledgment Letters - Giving

Purpose and Description:

This report is designed to print letters of acknowledgment and thanks to those constituents who have made a donation or pledge on the current day. The standard report template includes a text reference to the amount of the donation or pledge and the name of the account to which it was designated, and the campaign. It also includes a statement concerning any matching gifts, quid pro quo items, honorees, credits, or joint transactions.

Criteria:

The standard criteria selects all bequests, credits, expectancy, gifts, honor, match pledge, pledge, and pledge payments, received on the current day.

Report Options:

Do not combine spouses, Allow Multiples, Exclude deceased

Parameters:

None

Sorting/Grouping:

The standard sort for this format is alphabetical by constituent name.

HTML Compatibility:

This report has been optimized for printing on standard stationery. It is not suitable for viewing in HTML.

Customization Tips

Criteria:

The criteria could be altered to prompt the user for the desired date instead of defaulting to 'Today's date'. The transaction types might be edited according to your institution's wants regarding acknowledgments.

Options:

The Options could be changed to include deceased if the text of the letter and the addressee were adapted accordingly.

Format:

The format must be edited to use text that is appropriate for your institution. Note that if your institution allows the transactions to have blank entries in the Chart of Accounts and Campaign columns, then the wording of your letter should be constructed accordingly.

TOP

Daily Receipts - Giving

Purpose and Description:

This report is designed to print receipts for all transactions representing actual money received on the current day. Because they are designed to print on a standard preprinted form, each receipt will show the information for a single allocation. Therefore, if a transaction has multiple allocations, it will also generate multiple receipts. As appropriate, the receipt will show joint, honor, credit quid pro quo, and matching notations. The constituent's preferred address is shown on the receipt.

Criteria:

The standard criteria selects all gifts, pledge payments, and bequests received on the current day.

Report Options:

Do not combine spouses, Allow Multiples, Include deceased

Parameters:

None

Sorting/Grouping:

The standard sort for this format is alphabetical by constituent name.

HTML Compatibility:

This report is optimized for printing on a preprinted form. It is not suitable for viewing in HTML format.

Customization Tips

Criteria:

The criteria could be modified to select gifts from specific campaigns or solicitations, or could include pledges. The criteria could be altered to prompt the user for the desired date instead of defaulting to 'Today's date'.

Options:

Options should not be changed.

Format:

The format should be edited to conform to the size and spacing of your site's form.

TOP

Daily Report - Dues

Purpose and Description:

This report shows a list of donations and pledges for the current day to the Dues table, and provides detail on whether each is matched by, joint with, in honor of, or credited to another constituent. It is designed to provide a catalog of the day's giving for the fundraising officer. The transactions are organized by constituent type within Campaigns and a subtotal is shown for each constituent type within the Campaign, for each Campaign, and then a Grand Total for the entire set of transactions is shown.

Criteria:

The standard criteria selects bequest, credit, dues, expectancy, pledge, payment, and write-off transaction types processed on the current day in the Dues table.

Report Options:

Do not combine spouses, Allow Multiples, Include deceased

Parameters:

None

Sorting/Grouping:

The standard sort for this format is by Campaign, then by Constituent Type, and then Name.

HTML Compatibility:

This report is optimized for printing, but it may also be published in HTML. The spacing and alignment of the HTML version may differ slightly from the optimized version, and some extraneous HTML symbols may appear.

Customization Tips

Criteria:

Criteria can be modified to prompt the user for the desired transaction date, or to select a different set of transaction types.

Options:

Options should not be changed.

 TOP

Daily Report - Giving

Purpose and Description:

This report shows a list of donations and pledges for the current day to the Gift table, and provides detail on whether each is matched by, joint with, in honor of, or credited to another constituent. It is designed to provide a catalog of the day's giving for the fundraising officer. The transactions are organized by constituent type within Campaigns and a subtotal is shown for each constituent type within the Campaign, for each Campaign, and then a Grand Total for the entire set of transactions is shown.

Criteria:

The standard criteria selects bequest, credit, expectancy, gift, pledge, payment, and write-off transaction types processed on the current day in the Gift table.

Report Options:

Do not combine spouses, Allow Multiples, Include deceased

Parameters:

None

Sorting/Grouping:

The standard sort for this format is by Campaign, then by Constituent Type, and then by Name.

HTML Compatibility:

This report is optimized for printing, but it may also be published in HTML. The spacing and alignment of the HTML version may differ slightly from the optimized version, and some extraneous HTML symbols may appear.

Customization Tips

Criteria:

Criteria can be modified to prompt the user for the desired transaction date.

Options:

Options should not be changed.

 TOP

Daily Transmittal Detail - Dues

Purpose and Description:

This report shows a daily total of the dues, payments, bequests, and journals and voids of those transaction types for the current day in the Dues table. This report shows the individual transactions grouped first by date, then method of Tender, then Account Name, and finally by constituent name. Subtotals are shown for each Account's transactions within Tender grouping, a subtotal for each Tender, and a daily total.

It is designed for use to ensure the Gift Processing Office deposit balances with the Business Office each day.

Criteria:

The standard criteria selects dues, bequests, and pledge payments and any journals and voids for those transaction types, processed on the current day.

Report Options:

Do not combine spouses, Allow Multiples, Include deceased

Parameters:

None

Sorting/Grouping:

The standard sort for this format is by date, then tender, then account, and then by constituent name.

HTML Compatibility:

This report is optimized for printing, but it may also be published in HTML. The spacing and alignment of the HTML version may differ somewhat from the print version.

Customization Tips

Criteria:

Criteria can be modified to prompt the user for the desired transaction date(s).

Options:

Options should not be changed.

 TOP

Daily Transmittal Detail - Giving

Purpose and Description:

This report shows a daily total of the dues, payments, bequests, and journals and voids of those transaction types for the current day in the Giving table. This report shows the individual transactions grouped first by date, then method of Tender, then Account Name, and finally by constituent name. Subtotals are shown for each Account's transactions within Tender grouping, a subtotal for each Tender, and a daily total.

It is designed for use to ensure the Gift Processing Office deposit balances with the Business Office each day.

Criteria:

The standard criteria selects gifts, bequests, and pledge payments and any journals and voids for those transaction types, processed on the current day.

Report Options:

Do not combine spouses, Allow Multiples, Include deceased

Parameters:

None

Sorting/Grouping:

The standard sort for this format is by date, then tender, then account, and then by constituent name.

HTML Compatibility:

This report is optimized for printing, but it may also be published in HTML. The spacing and alignment of the HTML version may differ somewhat from the print version.

Customization Tips

Criteria:

Criteria can be modified to prompt the user for the desired transaction date(s).

Options:

Options should not be changed.

 TOP

Daily Transmittal Summary - Dues

Purpose and Description:

This report is designed for use to ensure that the Gift Processing Office deposit balances with the Business Office each day. It shows summary totals for each method of Tender, and each account represented within that the Tender groups.

This report prints out summary totals for each account of the dues, payments, bequests, and journals and voids of those transaction types for the current day.

Criteria:

The standard criteria selects dues, bequests, and pledge payments and any journals and voids for those transaction types, processed on the current day.

Report Options:

Do not combine spouses, Allow Multiples, Include deceased

Parameters:

None

Sorting/Grouping:

The standard sort for this format is first by process date, then method of tender, then by account name.

HTML Compatibility:

This report is optimized for printing, but it may also be published in HTML. The spacing and alignment of the HTML version may differ from the print version somewhat.

Customization Tips

Criteria:

Criteria can be modified to prompt the user for the desired transaction date.

Options:

Options should not be changed.

 TOP

Daily Transmittal Summary - Giving

Purpose and Description:

This report is designed for use to ensure that the Gift Processing Office deposit balances with the Business Office each day. It shows summary totals for each method of Tender, and each account represented within that the Tender groups.

This report prints out summary totals for each account of the gifts, payments, bequests, and journals and voids of those transaction types for the current day.

Criteria:

The standard criteria selects gifts, bequests, and pledge payments and any journals and voids for those transaction types, processed on the current day.

Report Options:

Do not combine spouses, Allow Multiples, Include deceased

Parameters:

None

Sorting/Grouping:

The standard sort for this format is first by process date, then method of tender, then by account name.

HTML Compatibility:

This report is optimized for printing, but it may also be published in HTML. The spacing and alignment of the HTML version may differ from the print version somewhat.

Customization Tips

Criteria:

Criteria can be modified to prompt the user for the desired transaction date.

Options:

Options should not be changed.

 TOP

Departmental Notification - Giving

Purpose and Description:

This report is used to notify departments of donations that have been received on their behalf on a daily basis. Departments often use this report to write their own letters of appreciation to the donors. The report groups the transactions first by department, and then shows the transactions by donor name. The date, transaction type, account name and amount of each transaction is shown, along with the donor's name and preferred address. Individual and yearly totals for each account are also shown.

Criteria:

The standard criteria selects gifts, bequests, and pledge payments processed on the current day, which are associated with accounts that have the Notify flag active.

Report Options:

Do not combine spouses, Allow Multiples, Include deceased

Parameters:

None

Sorting/Grouping:

The standard sort for this format is by account and then by constituent name.

HTML Compatibility:

This report is optimized for printing, but it may also be published in HTML. The spacing and alignment of the HTML version may differ somewhat from the print version.

Customization Tips

Criteria:

Criteria can be modified to prompt the user for the desired transaction date, or to restrict the selection to a particular set of departments.

Options:

Options should not be changed.

Top of Page