Proceed

You are asked if you want to proceed with creating the payments/charges report or export file.

+Proceed-+ | Yes | | No | +--------+

Select "Yes" to generate the report or export file.

Select "No" to return to the previous prompt.

Press <ESC> to abort this procedure.

60.2 Report Examples

15-Apr-2009 United Brotherhood of Carpenters and Joiners of America Page 1 Charges and Payments Report Payments Applied from 03/01/2009 thru LAST Post Finance Dues Applied Payment Lcl# Member ID Member Name By Code Month Date Amount ----- ----------- --------------- ----- ---------- ------- ---------- ---------- 1111 U-6431-2011 Bauer, Tom 1111 DUES 01/2009 03/10/2009 25.00 1111 U-6431-2011 Bauer, Tom 1111 DUES 03/2009 03/10/2009 25.00 1111 U-6431-2011 Bauer, Tom 1111 DUES 02/2009 03/10/2009 25.00 1111 U-3934-0698 Rabbit, Jack J 1111 DUES 04/2009 04/12/2009 25.00 ========== ========== Grand Total 100.00

The following is an example of a CHARGES report sorted by finance code.

26-Oct-2008 United Brotherhood of Carpenters and Joiners of America Page 1 Charges and Payments Report Charges Posted from 10/01/2008 thru 10/25/2008 Chrg Finance Charge Charge Total Still Lcl# Member ID Member Name By Code Date Amount Paid Owed ----- ----------- -------------- ----- --------- ---------- ------ ------ ------ 1444 U-2771-0438 Bays, Carter 1444 BOOKS 10/23/2008 7.00 7.00 0.00 ====== ====== ====== Finance Code Total 7.00 7.00 0.00 1444 U-6770-3845 Coons, Wayne 1444 CHARITY 10/21/2008 1.00 1.00 0.00 ====== ====== ====== Finance Code Total 1.00 1.00 0.00 1444 U-2771-0438 Bays, Carter 1444 DUES 10/22/2008 26.00 26.00 0.00 1444 U-6689-1182 Black, Terry 1444 DUES 10/22/2008 26.00 26.00 0.00 1444 U-6689-1182 Black, Terry 1444 DUES 10/22/2008 26.00 26.00 0.00 1444 U-6689-1182 Black, Terry 1444 DUES 10/22/2008 26.00 26.00 0.00 1444 U-6689-1182 Black, Terry 1444 DUES 10/22/2008 26.00 26.00 0.00 1444 U-6689-1182 Black, Terry 1444 DUES 10/22/2008 26.00 26.00 0.00 1444 U-6689-1182 Black, Terry 1444 DUES 10/22/2008 26.00 26.00 0.00 1444 U-6689-1182 Black, Terry 1444 DUES 10/22/2008 26.00 26.00 0.00 1444 U-6689-1182 Black, Terry 1444 DUES 10/22/2008 26.00 26.00 0.00 1444 U-6689-1182 Black, Terry 1444 DUES 10/22/2008 26.00 26.00 0.00 ====== ====== ====== Finance Code Total 260.00 260.00 0.00 ====== ====== ====== ====== ====== ====== Grand Total 268.00 268.00 0.00

+------------Inquiry/Report Procedures-------------+ | | | Membership Inquiries/Reports | | ... | | | | Other Inquiries/Reports | | BILLTRANS Billing Transaction Inquiry | | AFFINQ Affiliate Inquiry | | AFFROSTER Member Roster with Address | | SUMAFFINQ Summary Affiliate Inquiry | | OPTIONS Reports, Letters, Labels | | MEMLTRLAB Member Letters and Labels | | DAYBOOK Day Book Report | | TRSTEEDB Trustee Day Book | | CHRGPAY Charges & Payments Report | | FUNDALLOC Dues Fund Allocation Report | | QTRFUNDALLOC Quarterly Dues Fund Allocation | | PERMITSINQ Traveler Inquiry | | PRINTOBLIFORM Reprint Obligation Form | | EMPBILL Employer Billing for Dues | | DUESPAID Dues Paid Statement Letters | | ESTDELEGATE Convention Delegate Estimate R | | AFFREPLAB Affiliate Report and Labels | | FINADJUST Financial Adjustments Report | | 10YRSTATS 10-Year Statistics Report | | 12MOSTATS 12-Month Active Membership | | GROWTH Growth Reporting | | CERTIFICATE Delegate Goodstanding Certific | | USERAUDIT User Audit Report | | LM2_REPORT LM2 Report | +--------------------------------------------------+

The FUNDALLOC - Dues Fund Allocation Report menu option allows you to create a report of counter dues received, and which funds the dues were allocated to. You specify the time period you want to report on.

The breakdown amounts are derived from the counter dues codes and the breakdown amounts set up for each of them.

This chapter explains how to create dues fund allocation reports.

61.1 Dues Fund Allocation Report Input Screen

ULTRA United Brotherhood of Carpenters and Joiners of America (date) Tucson Local UBC01444 Dues Fund Allocation This reporting process includes: - all payments for dues during the entered date range regardless of the dues month. Affiliate ID: Start Date : End Date : Affiliate ID? ________ <ESC>=Exit Dues Fund Allocation Report <F2>=Back <F1>=Help

61.2 Prompts and Responses

Affiliate ID

Note: If you are a local affiliate user, the affiliate ID and name are displayed, and this prompt is skipped.

Affiliate ID? ________

If a default affiliate ID is provided and it is correct, you can press [Enter] to accept the default. Otherwise, enter the appropriate affiliate ID.

The affiliate ID is required. The affiliate must be active, and exist in the affiliate file.

You can enter the affiliate number or enter the entire affiliate ID.

After the affiliate ID is entered, the affiliate name is displayed.

Start and End Dates

You specify the time period you want to include on this dues fund allocation report. For example, you might want to report on a day's activity, or for a week, or for a month, etc.

First, you are asked for the start date of the time period you want to report on.

Start date (MMDDYYYY)? ________

Enter a start date in the format of MMDDYYYY.

After you enter the start date, you are asked for the time period end date.

End date (MMDDYYYY)? ________

Enter an end date in the format of MMDDYYYY.

Proceed

You are asked if you want to proceed with creating the dues fund allocation report.

+Proceed-+ | Yes | | No | +--------+

Select "Yes" to generate the report.

Select "No" to return to the previous prompt.

Press <ESC> to abort this report procedure.

If "Yes", the dues fund allocation report is generated.

61.3 Sample Report

26-Jul-2004 United Brotherhood of Carpenters and Joiners of America Page 1 Dues Receipt Fund Allocation -- Affiliate UBC01444 Money Applied to Dues 06/01/2004 - 06/30/2004 Total Dues Applied by Dues Code: Code Aff Dues Code Description Total Applied Code Has Bkdwn -------- ---------- ------------------------------ -------------- -------------- UBC01444 CTR_APP1 counter dues - apprentice 1 189.00 UBC01444 CTR_APP3 Counter dues - apprentice 3 150.00 N UBC01444 CTR_APP4 Counter dues - apprentice 4 51.00 N UBC01444 CTR_JOUR Counter dues - journeyman 5,044.00 UBC01444 CTR_JOUR2 Counter dues 2 journeyman 81.00 N ============== 5,515.00 26-Jul-2004 United Brotherhood of Carpenters and Joiners of America Page 2 Dues Receipt Fund Allocation -- Affiliate UBC01444 Money Applied to Dues 06/01/2004 - 06/30/2004 Fund Allocation from Dues Breakdowns: Allocation Total Amount -------------------- -------------- Health Insur 18.00 Life Insur 9.00 Misc 162.00 Dues reg 4,850.00 Dues extra 194.00 Unallocated to Funds 282.00 ============== 5,515.00

+------------Inquiry/Report Procedures-------------+ | | | Membership Inquiries/Reports | | ... | | | | Other Inquiries/Reports | | BILLTRANS Billing Transaction Inquiry | | AFFINQ Affiliate Inquiry | | AFFROSTER Member Roster with Address | | SUMAFFINQ Summary Affiliate Inquiry | | OPTIONS Reports, Letters, Labels | | MEMLTRLAB Member Letters and Labels | | DAYBOOK Day Book Report | | TRSTEEDB Trustee Day Book | | CHRGPAY Charges & Payments Report | | FUNDALLOC Dues Fund Allocation Report | | QTRFUNDALLOC Quarterly Dues Fund Allocation | | PERMITSINQ Traveler Inquiry | | PRINTOBLIFORM Reprint Obligation Form | | EMPBILL Employer Billing for Dues | | DUESPAID Dues Paid Statement Letters | | ESTDELEGATE Convention Delegate Estimate R | | AFFREPLAB Affiliate Report and Labels | | FINADJUST Financial Adjustments Report | | 10YRSTATS 10-Year Statistics Report | | 12MOSTATS 12-Month Active Membership | | GROWTH Growth Reporting | | CERTIFICATE Delegate Goodstanding Certific | | USERAUDIT User Audit Report | | LM2_REPORT LM2 Report | +--------------------------------------------------+

The QTRFUNDALLOC - Quarterly Dues Fund Allocation menu option provides quarterly fund allocation information on payments to dues codes with breakdowns that were made during the specified quarter. You select the quarter time period that you want to report on.

The breakdown amounts are derived from the counter dues codes and the breakdown amounts set up for each of them.

This chapter explains how to create quarterly dues fund allocation reports.

62.1 Quarterly Dues Fund Allocation Input Screen

ULTRA United Brotherhood of Carpenters and Joiners of America (date) Arizona State District Council UBC04003 Quarterly Fund Allocation This reporting process includes: - all payments for dues months in the reporting quarter, regardless of date paid - all payments posted in the reporting quarter for dues months prior to the quarter - payments for dues months after the end date are excluded - actual payment money and credit adjustments applied to dues are included Affiliate ID: Start Date : End Date : Report Type : Affiliate ID? ________ Enter individual local or leave council ID for council reporting <ESC>=Exit Quarterly Dues Fund Allocation <F2>=Back <F1>=Help

62.2 Prompts and Responses

Affiliate ID

Note: If you are a local affiliate user, the affiliate ID and name are displayed, and this prompt is skipped.

Affiliate ID? ________

If a default affiliate ID is provided and it is correct, you can press [Enter] to accept the default. Otherwise, enter the appropriate affiliate ID.

The affiliate ID is required. The affiliate must be active, and exist in the affiliate file.

You can enter the affiliate number or enter the entire affiliate ID.

After the affiliate ID is entered, the affiliate name is displayed.

Quarter Start and End Dates

You specify the quarter time period you want to include on this quarterly dues fund allocation report.

First, you are asked for the start date of the quarter period you want to report on.

Quarter start date (MMDDYYYY)? ________

Enter a quarter start date in the format of MMDDYYYY. The valid month/days are: 01/01, 04/01, 07/01, 10/01.

After you enter the start date, you are asked for the quarter end date.

Quarter end date (MMDDYYYY)? ________

Enter the quarter end date in the format of MMDDYYYY. The valid month/days are: 03/31, 06/30, 09/30, 12/31.

Report Type

You are asked for the report type that you want to create.

+----Reporting Type----+ | Summary Reporting | | Detail Reporting | +----------------------+

Select the "Summary" or "Detail" report option.

62.2.1 Summary Report

The following is an example of the report:

21-Mar-2010 United Brotherhood of Carpenters and Joiners of America Page 1 Quarterly Dues Fund Allocation -- Affiliate UBC0448L Summary Reporting for Quarter 01/01/2010 - 03/31/2010 Total Dues Applied by Dues Code: Code Aff Dues Code Description Total Applied Code Has Bkdwn -------- ---------- ------------------------------ -------------- -------------- UBC0448L JOUR_ALL Journeyman counter dues 300.00 ============== 300.00 21-Mar-2010 United Brotherhood of Carpenters and Joiners of America Page 2 Quarterly Dues Fund Allocation -- Affiliate UBC0448L Summary Reporting for Quarter 01/01/2010 - 03/31/2010 Fund Allocation from Dues Breakdowns: Allocation Total Amount -------------------- -------------- Item 1 225.00 Item 2 75.00 Unallocated to Funds 0.00 ============== 300.00

62.2.2 Detail Report

If you select "Detail Reporting", you are asked for the output type.

+--------------------------Output Type--------------------------+ | Detail Report of members with payments in the quarter | | Export File of end of quarter active members with payments | +---------------------------------------------------------------+

You can create a detail report of all the members who made fund payments in the selected quarter, or create an export file that includes end of quarter, active members with payments.

Select one of the menu options.

The following is an example of part of a Quarterly Dues Fund Allocation detail report:

21-Mar-2010 United Brotherhood of Carpenters and Joiners of America Page 1 Quarterly Dues Fund Allocation -- Affiliate UBC0448L Detail Reporting for Quarter 01/01/2010 - 03/31/2010 UBC ID Member Name Paid Date Total Paid Month ----------- ------------------------------ ---------- ---------- ------- U-3795-2232 Allwell, Jackson 12/31/2009 20.00 01/2010 Fund: Item 1 15.00 Fund: Item 2 5.00 12/31/2009 20.00 02/2010 Fund: Item 1 15.00 Fund: Item 2 5.00 03/21/2010 20.00 03/2010 Fund: Item 1 15.00 Fund: Item 2 5.00 U-2688-7484 Arts, Sam 03/21/2010 20.00 11/2009 Fund: Item 1 15.00 Fund: Item 2 5.00 03/21/2010 20.00 12/2009 Fund: Item 1 15.00 Fund: Item 2 5.00 U-5743-8431 Card, Ace 12/31/2009 20.00 01/2010 Fund: Item 1 15.00 Fund: Item 2 5.00 12/31/2009 20.00 02/2010 Fund: Item 1 15.00 Fund: Item 2 5.00 12/31/2009 20.00 03/2010 Fund: Item 1 15.00 Fund: Item 2 5.00 U-2933-7643 Carpenter, Daniel 12/31/2009 20.00 01/2010 Fund: Item 1 15.00 Fund: Item 2 5.00 12/31/2009 20.00 02/2010 Fund: Item 1 15.00 Fund: Item 2 5.00 . . . . . .

Export File

If you elect to create an export file, you are asked for the file name.

Export File Name? _______________ The ID makes the file name unique - Please use only letters and numbers

Enter an export file name using only letters and numbers.

Proceed

You are asked if you want to proceed with creation of the export file.

+Proceed-+ | Yes | | No | +--------+

Select "Yes" to create the export file.

Select "No" to return to the previous prompt.

If "Yes", the export file is generated and can be downloaded to your PC.