Spectrum Deposit Reports
Contents
- 1 MEMBERS-SHARE-PORTFOLIO-SUMMARY
- 2 Aggregate Shares by Dollar Volume
- 3 TOP-100-DEPOSITORS-BY-ACCOUNT
- 4 TOP-100-DEPOSITORS-BY-SSN
- 5 CD-IRA-MATURITY-REPORT
- 6 Aggregate Share Balance by SSN
- 7 CHECKING-WITH-MONEY
- 8 SHARES-BY-BEACON-SCORE
- 9 NEGATIVE-SHARES
- 10 BRANCH-SHARE-SUMMARY
- 11 PAST3MO-AVG-CHK-BAL
- 12 BRANCH-SHARE-ACCOUNTS-DTL
- 13 CERTIFICATE-COST-PROJECTION
- 14 CERTIFICATE-MATURITY-SUMMARY
- 15 SHARE-BALANCE-GTE-100K
- 16 NSF-REPORTING
MEMBERS-SHARE-PORTFOLIO-SUMMARY
- Share Portfolio Summary by Description Abbrv.
- This report pulls all shares that are on the system that have a balance > 0. It sorts the shares by MEMBRS.SHARE-FILE.DESC-ABRV. It displays the description abbreviation, full description, # of shares, total balance and average rate.
Sample Report Output
Download MEMBERS-SHARE-PORTFOLIO-SUMMARY
Created: 2016/09/01
- All open, non charged off shares are grouped by aggregate amounts into nine different ranges. There are total counts, balances and percent of total for each range.
- This context was created with the Report Design and is multipass. A host file is created in the first pass, for use in the second pass.
Sample Report Output
Date: 01/25/2021 Aggregate Shares by Dollar Volume Page: 1
Time: 10:03 AM
Group Counts Dollar Volume % of Total
---------------------------------------------------------------------------------
Negative 5 1,101.07- 0.00%
Zero 3 0.00 0.00%
.01 - $4.99 0 0.00 0.00%
$5.00 - $499.99 5 1,682.87 0.00%
$500.00 - $999.99 4 2,833.52 0.00%
$1,000.00 - $4,999.99 47 151,066.71 0.46%
$5,000.00 - $9,999.99 38 279,082.20 0.85%
$10,000.00 - $49,999.99 165 4,673,236.31 14.36%
$50,000.00 - $99,999.99 70 4,777,766.19 14.68%
$100,000.00+ 32 22,641,398.91 69.61%
===================================================================
Credit Union Totals: 369 32,525,965.64
Download Aggregate Shares by Dollar Volume
Created: 2020/12/30
TOP-100-DEPOSITORS-BY-ACCOUNT
- Created in REPORT. Uses Multi-Pass Reporting and contains 2 REPORTS.
- The first REPORT, or pass, will aggregate all open and \nnon-harged-off shares per ACCOUNT. The second report will sort the aggregate balances descending and print the top 100 depositors.
Sample Report Output
Date: 08/23/2021 Top 100 Depositors Page: 1
Time: 11:01 AM Total by Account
Aggregate Balance Member Name Account
________________________________________________________________
12,527,505.06 TIMOTHY BLESS 19137
3,745,162.29 SCOTT R ERNEST 46799
899,544.87 LARRY D PAULSON 56000
745,256.14 JUDY PANDS 35016
555,468.57 CHERYL M ALTENHEISS 53835
288,157.15 BEVERLY HOLLIS 622
233,499.66 JAMES N PADDOCK 207
220,243.98 DENNIS STEIGMANN 634
210,373.50 DEBORAH PITZER 632
197,437.00 KATHY MASON 273
189,695.12 JOHN PATTERSON 633
184,244.96 MURIEL HEMMINGWAY 630
169,139.28 MARY SMITH 888999
167,920.20 HARRY BANK 5098
165,148.46 DAVID TANK 629
165,134.77 TOMMY JONES 11477
Download TOP-100-DEPOSITORS-BY-ACCOUNT
Created: 2016/09/01
TOP-100-DEPOSITORS-BY-SSN
- Created in REPORT. Uses Multi-Pass Reporting and contains 2 REPORTS.
- The first REPORT, or pass, will aggregate all open and \nnon-charged-off shares per SSN. The second report will sort the aggregate balances descending and print the top 100 depositors. This report displays up to 10 ACCOUNT numbers associated with the SSN.
Sample Report Output
Time: 11:28 AM Total by SSN
Aggregate Balance Member Name SSN Account #1 Account #2 Account #3 Account #4 Account #5 Account #6 Account #7 Account #8 Account #9 Account #10
_____________________________________________________________________________________________________________________________________________________________________________________
12,527,505.06 TIMOTHY BLESS 540-81-0270 19137 45354 45954
3,745,162.29 SCOTT R ERNEST 541-89-2858 46799
899,544.87 LARRY D PAULSON 540-73-2166 56000
745,256.14 JUDY PANDS 528-95-2050 35016
555,468.57 CHERYL M ALTENHEISS 238-38-5192 53835
288,157.15 BEVERLY HOLLIS 252-98-8282 622
220,243.98 DENNIS STEIGMANN 888-55-2222 634
210,373.50 DEBORAH PITZER 852-69-5874 632
189,695.12 JOHN PATTERSON 444-44-4444 633
184,244.96 MURIEL HEMMINGWAY 856-98-6598 630
180,529.36 JAMES N PADDOCK 142-57-8555 207
169,139.28 MARY SMITH 888-88-8888 888999
165,148.46 DAVID TANK 111-22-3333 629
Download TOP-100-DEPOSITORS-BY-SSN
Created: 2016/09/01
CD-IRA-MATURITY-REPORT
- Created in Report. Lists all CDs and IRAs maturing from an as of date.
- The Share Control flags 22 and 26 along with a balance greater than zero are used to select all CDs and IRAs. The report shows counts and total dollar amounts for CD
Sample Report Output
Download CD-IRA-MATURITY-REPORT
Created: 2016/09/01
- Reports top 100 members by their aggregate share balance by SSN. Uses Multi-Pass Reporting and contains 3 reports.
- The first report, or pass, will aggregate all open and non-charged-off shares per SSN. The second report is a Summary listing the SSN and the Aggregate Dollar Amount. The third report is a detail listing of each SSN with all of the associated accounts, suffixes and balance.
Sample Report Output
**** Summary Report ****
Date: 08/23/2021 Page: 1
Time: 12:26 PM Members Aggregate Share report by SSN
$100,000.00 Plus Members
(Totals Only)
SSN# Member Name Total Shares
______________________________________________________________________
540-81-0270 TIMOTHY BLESS 12,527,505.06
541-89-2858 SCOTT R ERNEST 3,745,162.29
540-73-2166 LARRY D PAULSON 899,544.87
528-95-2050 JUDY PANDS 745,256.14
238-38-5192 CHERYL M ALTENHEISS 555,468.57
252-98-8282 BEVERLY HOLLIS 288,157.15
888-55-2222 DENNIS STEIGMANN 220,243.98
852-69-5874 DEBORAH PITZER 210,373.50
444-44-4444 JOHN PATTERSON 189,695.12
856-98-6598 MURIEL HEMMINGWAY 184,244.96
142-57-8555 JAMES N PADDOCK 180,529.36
888-88-8888 MARY SMITH 169,139.28
111-22-3333 DAVID TANK 165,148.46
543-71-3252 CAROLYN LERAY 164,885.94
535-63-5637 TOMMY JONES 140,923.02
558-72-5234 GEORGIA WALLACE 140,442.71
541-83-5998 CLYDE A FRIED 135,076.87
565-93-5808 RICHARD A ANDERSON 134,884.75
505-77-1550 DONALD L SAINERBECK 131,607.92
**** Detail Report ****
Date: 08/23/2021 Page: 1
Time: 12:50 PM Members Aggregate Share report by SSN
$100,000.00 Plus Members
(All Suffix's)
SSN# Member Name Account-Sfx Balance
__________________________________________________________________________
540-81-0270 TIMOTHY BLESS
19137-00 12,491,780.40
19137-10 35,724.66
_______________
Account Total: 12,527,505.06
SSN Total: 12,527,505.06
541-89-2858 SCOTT R ERNEST
46799-00 3,745,162.29
_______________
Account Total: 3,745,162.29
SSN Total: 3,745,162.29
540-73-2166 LARRY D PAULSON
56000-00 874,155.10
56000-01 2,886.14
56000-02 654.90
56000-03 2,352.51
56000-04 2,669.08
56000-05 4,108.96
56000-06 11,738.38
56000-16 979.80
_______________
Account Total: 899,544.87
SSN Total: 899,544.87
Download Aggregate Share Balance by SSN
Created: 2016/09/01
Last Updated: 2020/07/09
CHECKING-WITH-MONEY
- Created in REPORT. Members with a Savings Balance Less Than $5.00 and Positive Checking Balance.
- Members with a Savings (suffix 0) balance less than $5.00 and a positive balance in Checking (suffix 90).
Sample Report Output
Date: 12/09/2021 Page: 1
Time: 9:09 AM
Members with a Savings (suffix 0) Balance Less Than $5.00
and Positive Balance in Checking (suffix 90)
Account Name Suffix Balance
--------------------------------------------------------------
609 MYRNA WARREN 00 $2.00
01 $1.00
90 $350.00
20 $1,017.75
40 $565.15
43 $1,530.28
91 $0.00
92 $0.00
Number of Accounts 1
Download CHECKING-WITH-MONEY
Created: 2016/09/01
SHARES-BY-BEACON-SCORE
- Created in REPORT. Groups shares by Beacon Scores.
- Groups shares by Beacon Scores. There are 5 beacon groups: 700+, 650-699, 610-649, 590-609, LE 589.
Sample Report Output
Total Shares by Beacon Score
December 9, 2021
Beacon Total Balance # of Accounts
700 + $8,776,345.31 307
650 - 699 $15,595,418.07 154
610 - 649 $1,814,174.24 117
590 - 609 $1,370,759.53 64
LESS 589 $4,993,384.86 259
--------------------------------------------
TOTAL: 32,550,082.01 901
Download SHARES-BY-BEACON-SCORE
Created: 2016/09/01
NEGATIVE-SHARES
- Created in LIST. Selects all shares not closed or charged off with a balance less than zero.
- N/A
Sample Report Output
DATE: 12/09/2021 TIME: 9:32 AM Page: 1
Negative Shares by Branch
Branch Member Name Account SFX Balance Phone No. Last Activity
Date
1 KATHY MASON 273 00 9,395.47- (581) 532-4070 09/13/2002
GERALD G GOLF 3757 10 608.22- (503) 555-3467 09/30/2002
JOHN B MICHEALS 6815 15 2,479.80- (503) 555-5865 01/07/1997
CHARLENE A REED 47285 15 317.67- (503) 555-7020 09/26/2002
JULIE ANN PAULSON 48812 15 5.00- (503) 555-0070 11/27/1996
RICHARD D SCHWINN 50980 00 150.00- (307) 555-4102 03/14/1997
DOMINIC ODONNELL 53778 15 5.00- (503) 555-7432 11/27/1996
TOM STUDENT 540022222 02 267.82- (541) 758-5888 09/30/2002
BRUCE STUDENT 540033333 02 268.41- (541) 758-5888 09/30/2002
MARK STUDENT 540044444 02 268.41- (541) 758-5888 09/30/2002
JAMES STUDENT 540055555 02 268.41- (541) 758-5888 09/30/2002
ERIC STUDENT 540066666 02 268.41- (541) 758-5888 09/30/2002
DAVE STUDENT 540077777 02 268.41- (541) 758-5888 09/30/2002
JASON STUDENT 540088888 02 268.41- (541) 758-5888 09/30/2002
SCOTT STUDENT 540099999 02 268.41- (541) 758-5888 09/30/2002
RICH STUDENT 540100000 02 268.41- (541) 758-5888 09/30/2002
15,376.26- Tot
2 JEFFREY P ANDER 20993 00 517.22- (704) 555-7588 09/13/2002
CHARLES A RICKS 48952 00 147.43- (901) 555-1941 09/13/2002
CHERYL M ALTENHEISS 53835 15 4.33- (704) 555-9789 11/08/1996
GEORGE W HARRIS 54801 00 18.83- (704) 555-1940 09/13/2002
687.81- Tot
16,064.07- Tot
Download NEGATIVE-SHARES
Created: 2016/09/01
BRANCH-SHARE-SUMMARY
- This report prints a summary of the open SHARE-FILE accounts.
- This report prints a summary of the open SHARE-FILE accounts and summarizes them into user defined account types (i.e. savings, checking, money market, CDs etc.). It prints the number of accounts and total dollar amount for each account type by branch and then a final count and dollar amount for each account type for the entire credit union at the end of the report.
Sample Report Output
Date: 12/09/2021 Time: 10:44 AM Page: 1
Branch SHARE-FILE Summary by Suffix
Branch: 1 Everybody'S Cu - Main Office
Suffix Summary per Branch: Suffix Count Suffix Balance
------------------------------------------------------------------|
Regular SHARE (SFX 00) 314 | $23,499,341.41 |
SPECIAL SAVINGS (SFX 01-09) 224 | $1,417,202.04 |
OTHER SAVINGS (SFX 30-39) 32 | $677,990.27 |
CERTIFICATES (SFX 10-29) 232 | $4,592,303.65 |
IRAs (SFX 60-69) 14 | $124,462.50 |
CHECKING (SFX 80) 0 | $0.00 |
MMAs (SFX 88) 0 | $0.00 |
OTHER 'misc' 134 | $653,697.12 |
------------------------------------------------------------------|
Total Suffixes for branch 1 : 950 | $30,964,996.99 |
Date: 12/09/2021 Time: 10:44 AM Page: 1
Branch SHARE-FILE Summary by Suffix
Branch: 2 Everybody'S Cu - Timberhill
Suffix Summary per Branch: Suffix Count Suffix Balance
------------------------------------------------------------------|
Regular SHARE (SFX 00) 54 | $1,499,601.24 |
SPECIAL SAVINGS (SFX 01-09) 1 | $168.18 |
OTHER SAVINGS (SFX 30-39) 1 | $5,109.51 |
CERTIFICATES (SFX 10-29) 33 | $377,025.43 |
IRAs (SFX 60-69) 0 | $0.00 |
CHECKING (SFX 80) 0 | $0.00 |
MMAs (SFX 88) 0 | $0.00 |
OTHER 'misc' 0 | $0.00 |
------------------------------------------------------------------|
Total Suffixes for branch 2 : 89 | $1,881,904.36 |
Date: 12/09/2021 Time: 10:44 AM Page: 1
Branch SHARE-FILE Summary by Suffix
Grand Totals for All Branches: Suffix Count Suffix Balance
---------------------------------------------------------------------|
Regular SHARE (SFX 00) 368 | $24,998,942.65 |
SPECIAL SAVINGS (SFX 01,09) 225 | $1,417,370.22 |
OTHER SAVINGS (SFX 30-39) 33 | $683,099.78 |
CERTIFICATES (SFX 10-29) 265 | $4,969,329.08 |
IRAs (SFX 60-69) 14 | $124,462.50 |
CHECKING (SFX 80) 0 | $0.00 |
MMAs (SFX 88) 0 | $0.00 |
OTHER 'misc' 134 | $653,697.12 |
---------------------------------------------------------------------|
Total ALL ACCOUNTS: 1,039 | $32,846,901.35 |
Download BRANCH-SHARE-SUMMARY
Created: 2016/09/01
PAST3MO-AVG-CHK-BAL
- Checking with avg balance in-between $500.01 and $1000.00.
- The purpose of this report is to find checking accounts that have a three month average balance in-between 500.01-1000.00.
Sample Report Output
DATE:12/09/2021 PAGE: 1
TIME:10:56 AM
THREE MONTH CHECKING AVERAGE BALANCE
BETWEEN $500.01 AND $1,000.00
ACCOUNT SFX CUR BAL NOVEMBER BAL OCTOBER BAL SEPTEMBER BAL AVG BAL
-----------------------------------------------------------------------------------------------------------
7228 72 $911.11 $911.11 $911.11 $911.11 $911.11
40168 72 $575.82 $575.82 $575.82 $575.82 $575.82
40551 71 $598.66 $598.66 $598.66 $598.42 $598.58
40551 72 $819.37 $819.25 $819.25 $819.25 $819.25
-----------------------------------------------------------------------------------------------------------
TOTALS: 4 $2,904.96 $2,904.84 $2,904.84 $2,904.60 $726.19
Download PAST3MO-AVG-CHK-BAL
Created: 2016/09/01
BRANCH-SHARE-ACCOUNTS-DTL
- New account summary report by branch.
- This report pulls new accounts which have ENTRY-DATES in-between two user defined dates that are asked for upon running the report.
Sample Report Output
Download BRANCH-SHARE-ACCOUNTS-DTL
Created: 2016/09/01
CERTIFICATE-COST-PROJECTION
- Certificate cost projection by month and rate.
- This report gathers certificate accounts where the balance is greater than zero and the maturity date of the certificate is greater than or equal to the date inputted by the user via a user prompt.
Sample Report Output
Date: 12/10/2021 Time: 7:46 AM Page: 1
Certificate Cost Projection by Month and Rate
All OPEN Certificates
Mat-Month | Div Rate | Balance | Count |
----------|----------|----------------|----------|
2002/09 | 5.45 | $3,166.09 | 1 |
-------------------------------------------------|
Totals : 5.45 | $3,166.09 | 1 |
-------------------------------------------------|
2002/10 | .00 | $16,911.11 | 3 |
2002/10 | .75 | $2,500.00 | 1 |
2002/10 | 5.15 | $45,015.95 | 2 |
2002/10 | 5.34 | $15,216.14 | 1 |
2002/10 | 5.39 | $53,001.75 | 2 |
2002/10 | 6.00 | $64,677.93 | 7 |
-------------------------------------------------|
Totals : 5.01 | $197,322.88 | 16 |
-------------------------------------------------|
2002/11 | 4.90 | $18,182.22 | 1 |
2002/11 | 5.10 | $3,265.83 | 1 |
2002/11 | 5.15 | $25,985.36 | 1 |
-------------------------------------------------|
Totals : 5.05 | $47,433.41 | 3 |
-------------------------------------------------|
2002/12 | 5.10 | $1,461.48 | 1 |
2002/12 | 5.25 | $30,290.13 | 3 |
2002/12 | 5.35 | $55,623.77 | 1 |
2002/12 | 5.60 | $68,101.07 | 1 |
2002/12 | 6.00 | $312,183.54 | 4 |
-------------------------------------------------|
Totals : 5.81 | $467,659.99 | 10 |
-------------------------------------------------|
Download CERTIFICATE-COST-PROJECTION
Created: 2016/09/01
CERTIFICATE-MATURITY-SUMMARY
- Reports all open Certificates within a 6 year period.
- This report pulls Certificate accounts that mature in-between dates that the user specifies and that have a balance greater than zero.
Sample Report Output
Date: 12/08/2002 Time: 11:46 AM Page: 1
6 Year Certificate Maturity Summary Report
Dates: 01-01-2002 - 12-31-2007
2002 | 2003 | 2004 | 2005 | 2006 | 2007 |
-------------------|------------------|------------------|------------------|------------------|------------------|
1 JANUARY | 0.00 | 55,731.16 | 0.00 | 0.00 | 1,077,644.88 | 0.00 |
2 FEBRUARY | 0.00 | 9,703.42 | 0.00 | 0.00 | 470,135.42 | 0.00 |
3 MARCH | 0.00 | 3,221,605.16 | 0.00 | 0.00 | 7,287,099.01 | 0.00 |
4 APRIL | 0.00 | 693,140.57 | 0.00 | 0.00 | 6,111,760.46 | 0.00 |
5 MAY | 0.00 | 110,222.62 | 0.00 | 0.00 | 940,270.84 | 0.00 |
6 JUNE | 0.00 | 24,821,001.16 | 0.00 | 0.00 | 9,402,708.40 | 0.00 |
7 JULY | 0.00 | 53,383.94 | 0.00 | 0.00 | 940,270.84 | 0.00 |
8 AUGUST | 0.00 | 10,539.46 | 0.00 | 0.00 | 235,067.71 | 0.00 |
9 SEPTEMBER | 3,166.09 | 37,330.92 | 273,280.17 | 0.00 | 1,410,406.26 | 0.00 |
10 OCTOBER | 1,916,293.31 | 149,221.62 | 1,049,555.35 | 0.00 | 3,996,151.07 | 0.00 |
11 NOVEMBER | 117,586.35 | 27,345.39 | 185,215.65 | 0.00 | 705,203.13 | 0.00 |
12 DECEMBER | 3,090,117.22 | 293,667.23 | 679,124.05 | 0.00 | 2,585,744.81 | 0.00 |
-------------------------------------------------------------------------------------------------------------------------------|
Total | 5,127,162.97 | 29,482,892.65 | 2,187,175.22 | 0.00 | 35,162,462.83 | 0.00 |
--------------------------------------------------------------------------------------------------------------------------------
Download CERTIFICATE-MATURITY-SUMMARY
Created: 2016/09/01
SHARE-BALANCE-GTE-100K
- Share balances >= 100K, totals by SSN.
- This report pulls open share accounts that have a balance greater than or equal to $100,000.00 (MEMBRS.SHARE-FILE.BALANCE >= 10000000). The information is grouped by SSN.
Sample Report Output
DATE: 12/10/2021 PAGE: 1
TIME: 8:07 AM TOTAL SHARES BY SSN
FOR ACCOUNTS OVER 100K.
-------------------------------------------------
| ACCOUNT | SUFFIX | BALANCE |
|------------------------------------------------|
| 273 | 30 | $102,358.01 |
| 503 | 50 | $100,000.00 |
-------------------------------------------------|
|SSN: 140-43-4901 SHARES BAL: $202,358.01 |
-------------------------------------------------
-------------------------------------------------
| ACCOUNT | SUFFIX | BALANCE |
|------------------------------------------------|
| 207 | 0 | $180,529.36 |
-------------------------------------------------|
|SSN: 142-57-8555 SHARES BAL: $180,529.36 |
-------------------------------------------------
-------------------------------------------------
| ACCOUNT | SUFFIX | BALANCE |
|------------------------------------------------|
| 48400 | 0 | $105,672.43 |
-------------------------------------------------|
|SSN: 222-95-6839 SHARES BAL: $105,672.43 |
-------------------------------------------------
Download SHARE-BALANCE-GTE-100K
Created: 2016/09/01
NSF-REPORTING
- NSF Report Sorted by DESC-ABRV, ACCOUNT.
- This report pulls all checking suffixes and finds all checking accounts that have a balance greater than 0, have at least one YTD NSF and has a recent NSF before the user input last nsf date.
Sample Report Output
DATE: 12/10/2021 TIME: 8:46 AM PAGE: 1
NSF REPORT SORTED BY DESC ABRV & ACCOUNT
ACCOUNT-SFX ABRV CHECKING DESCRIPTION TOTAL NSFS MTD-NSF YTD-NSF LAST NSF
-------------- ---- -------------------- ---------- ------- ------- ----------
10903-15 SDA DIVIDEND CHECKING 64 1 15 10/03/2002
47285-15 SDA DIVIDEND CHECKING 35 0 6 09/26/2002
Download NSF-REPORTING
Created: 2016/09/01
