Difference between revisions of "Spectrum Deposit Reports"
| (15 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{SampleContext| | {{SampleContext| | ||
| − | name= | + | name=Share Dividend Rates| |
| − | h1= | + | h1=This context calculates dividends for every share suffix.| |
| − | h2=This | + | h2=This context is a multi-pass context. It reads four different rate tables from the DFILES database and generates the DIV-RATE for each suffix.| |
| − | link= | + | h3=Each Task/tab must be run in the order they appear.| |
| − | created= | + | link=Share Dividend Rates.ctx| |
| − | results={{ | + | created=2021/08/23| |
| + | results={{Results_Share Dividend Rates|}} | ||
}} | }} | ||
| Line 25: | Line 26: | ||
results={{Results_YTD Dividends by DESC-ABRV and ACC|}} | results={{Results_YTD Dividends by DESC-ABRV and ACC|}} | ||
}} | }} | ||
| − | |||
{{SampleContext| | {{SampleContext| | ||
name=TOP-100-DEPOSITORS-BY-ACCOUNT| | name=TOP-100-DEPOSITORS-BY-ACCOUNT| | ||
h1=Created in REPORT. Uses Multi-Pass Reporting and contains 2 REPORTS.| | h1=Created in REPORT. Uses Multi-Pass Reporting and contains 2 REPORTS.| | ||
| − | h2=The first REPORT, or pass, will aggregate all open and | + | h2=The first REPORT, or pass, will aggregate all open and non-charged-off shares per ACCOUNT. The second report will sort the aggregate balances descending and print the top 100 depositors.| |
link=TOP-100-DEPOSITORS-BY-ACCOUNT.ctx| | link=TOP-100-DEPOSITORS-BY-ACCOUNT.ctx| | ||
created=2016/09/01| | created=2016/09/01| | ||
| Line 39: | Line 39: | ||
name=TOP-100-DEPOSITORS-BY-SSN| | name=TOP-100-DEPOSITORS-BY-SSN| | ||
h1=Created in REPORT. Uses Multi-Pass Reporting and contains 2 REPORTS.| | h1=Created in REPORT. Uses Multi-Pass Reporting and contains 2 REPORTS.| | ||
| − | h2=The first REPORT, or pass, will aggregate all open and | + | h2=The first REPORT, or pass, will aggregate all open and non-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.| |
link=TOP-100-DEPOSITORS-BY-SSN.ctx| | link=TOP-100-DEPOSITORS-BY-SSN.ctx| | ||
created=2016/09/01| | created=2016/09/01| | ||
results={{Results_TOP-100-DEPOSITORS-BY-SSN|}} | results={{Results_TOP-100-DEPOSITORS-BY-SSN|}} | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
}} | }} | ||
{{SampleContext| | {{SampleContext| | ||
name=Aggregate Share Balance by SSN| | name=Aggregate Share Balance by SSN| | ||
| − | link= | + | link=AGGREGATE-SHARE-BY-SSN.ctx| |
| − | h1= Reports | + | h1= Reports members who have an aggregate share balance of $100,000.00 or more by SSN. Uses Multi-Pass Reporting and contains 2 reports. | |
h2=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.| | h2=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.| | ||
created=2016/09/01| | created=2016/09/01| | ||
| − | updated= | + | updated=2021/08/23| |
| − | results={{ | + | results={{Results_AggShareBalanceBySSN}} |
}} | }} | ||
| Line 85: | Line 76: | ||
name=NEGATIVE-SHARES| | name=NEGATIVE-SHARES| | ||
h1=Created in LIST. Selects all shares not closed or charged off with a balance less than zero.| | h1=Created in LIST. Selects all shares not closed or charged off with a balance less than zero.| | ||
| − | |||
link=NEGATIVE-SHARES.ctx| | link=NEGATIVE-SHARES.ctx| | ||
created=2016/09/01| | created=2016/09/01| | ||
| Line 110: | Line 100: | ||
{{SampleContext| | {{SampleContext| | ||
| − | name= | + | name=Certificate Maturity Reports| |
| − | h1= | + | h1=Certificates Maturing by Day, Month and Year.| |
| − | h2= | + | h2=These reports print both Summary and Detail information for all open Certificates.| |
| − | link= | + | link=CD Maturity by Day, Month,Year Summary and Detail.ctx| |
| − | created= | + | created=2024/05/20| |
| − | results={{ | + | results={{Results_CD-MATURITY|}} |
}} | }} | ||
| − | + | ||
{{SampleContext| | {{SampleContext| | ||
name=CERTIFICATE-COST-PROJECTION| | name=CERTIFICATE-COST-PROJECTION| | ||
h1=Certificate cost projection by month and rate.| | h1=Certificate cost projection by month and rate.| | ||
| − | h2=This report gathers certificate accounts where the balance is greater than zero | + | h2=This report gathers certificate accounts where the balance is greater than zero.| |
link=CERTIFICATE-COST-PROJECTION.ctx| | link=CERTIFICATE-COST-PROJECTION.ctx| | ||
created=2016/09/01| | created=2016/09/01| | ||
| Line 130: | Line 120: | ||
name=CERTIFICATE-MATURITY-SUMMARY| | name=CERTIFICATE-MATURITY-SUMMARY| | ||
h1=Reports all open Certificates within a 6 year period.| | h1=Reports all open Certificates within a 6 year period.| | ||
| − | h2=This report pulls | + | h2=This report pulls Certificates that will mature between the current year and the next 6 years and have a balance greater than zero.| |
link=CERTIFICATE-MATURITY-SUMMARY.ctx| | link=CERTIFICATE-MATURITY-SUMMARY.ctx| | ||
created=2016/09/01| | created=2016/09/01| | ||
results={{Results_CERTIFICATE-MATURITY-SUMMARY|}} | results={{Results_CERTIFICATE-MATURITY-SUMMARY|}} | ||
| + | }} | ||
| + | |||
| + | {{SampleContext| | ||
| + | name=IRA Required Minimum Distribution - RMD| | ||
| + | h1=This report contains the calculations for RMD using the "Life Expectancy Table 2024".| | ||
| + | link=IRA Required Minimum Distribution - RMD.ctx| | ||
| + | created=2024/05/20| | ||
| + | results={{Results_IRA Required Minimum Distribution - RMD|}} | ||
}} | }} | ||
| Line 144: | Line 142: | ||
results={{Results_SHARE-BALANCE-GTE-100K|}} | results={{Results_SHARE-BALANCE-GTE-100K|}} | ||
}} | }} | ||
| − | + | ||
{{SampleContext| | {{SampleContext| | ||
name=NSF-REPORTING| | name=NSF-REPORTING| | ||
Latest revision as of 20:23, 20 May 2024
Contents
- 1 Share Dividend Rates
- 2 Aggregate Shares by Dollar Volume
- 3 Share YTD-DIV totals by DESC-ABRV and ACC with GL Account Numbers
- 4 TOP-100-DEPOSITORS-BY-ACCOUNT
- 5 TOP-100-DEPOSITORS-BY-SSN
- 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 Certificate Maturity Reports
- 13 CERTIFICATE-COST-PROJECTION
- 14 CERTIFICATE-MATURITY-SUMMARY
- 15 IRA Required Minimum Distribution - RMD
- 16 SHARE-BALANCE-GTE-100K
- 17 NSF-REPORTING
- This context calculates dividends for every share suffix.
- This context is a multi-pass context. It reads four different rate tables from the DFILES database and generates the DIV-RATE for each suffix.
- Each Task/tab must be run in the order they appear.
Sample Report Output
DATE: 08/23/2021 TIME: 9:25 AM Page: 1
The dividends for this report were calculated using the following date:
JUL-31-2021
CURR-BRANCH ACCOUNT MEM-FULL-NAME SUFFIX DESC-ABRV DESCRIPTION BALANCE DIV-RATE
1 40166 ALLI R DOUGLAS 71 IOY 1 YR IRA CERT 4,563.80 5.3000%
40166 ALLI R DOUGLAS 90 IOY 1 YR IRA CERT 4,584.51 5.3000%
40168 NANCY E GILL 71 IOY IRA ONE YEAR CERT 319.77 5.3000%
40168 NANCY E GILL 72 IOY 1 YR IRA CERT 575.82 5.3000%
40168 NANCY E GILL 73 IOY ONE YEAR IRA CERT 472.77 5.4000%
40168 NANCY E GILL 74 IOY ONE YEAR IRA CERT 400.58 5.7000%
40251 JAYNE K KERR 71 IOY ONE YEAR IRA CERT 4,147.88 5.5000%
40274 KENNETH DODD 71 IOY 1 YR IRA CERT 3,931.34 5.4000%
40274 KENNETH DODD 72 IOY ONE YEAR IRA CERT 3,796.36 5.4000%
40274 KENNETH DODD 74 IOY ONE YEAR IRA CERT 3,501.33 5.4000%
41039 MELODY DALLES 50 OYC ONE YEAR CERT 4,682.58 5.0500%
41039 MELODY DALLES 60 TYC TWO YEAR CERT 19,753.72 6.1000%
41039 MELODY DALLES 61 TYC TWO YEAR CERT 19,340.08 5.5500%
644 GUY MORRIS 50 OYC ONE YEAR CERT 10,467.91 5.0500%
2972 TRISH MILLER 61 TYC TWO YEAR CERT 30,275.79 5.5000%
Download Share Dividend Rates
Created: 2021/08/23
- 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: 2021/1/25
- YTD Dividends, counts and totals by DESC-ABRV and ACC with GL Account Numbers.
- 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 Page: 1 Time: 10:52 AM YTD Dividends by DESC-ABRV and ACC DESC-ABRV ACC Description No. Shares Total Dividends G/L Account 12C 26 12 MONTH CERT 56 $4,320.00 908.000 12I 14 12 MONTH IRA CERT 18 $361.35 906.000 BDA 7 BASIC CHECKING 84 $31,555.86 902.000 COS 1 CHARGED OFF SHARE 9 $3,416.11 131.100 CPS 2 COMMERCIAL PRIME SHR 1 $353.53 907.000 CPS 90 COMMERCIAL PRIME SHR 1 $10.12 907.000 HOL 4 HOLIDAY ACCOUNT 62 $571.36 903.000 HYA 23 HIGH YIELD ACCOUNT 45 $11,419.96 911.000 IOY 14 IRA ONE YEAR CERT 13 $77.57 906.000 IRA 6 IRA REGULAR SHARES 67 $5,039.65 906.000 OYC 26 ONE YEAR CERT 3 $54.34 908.000 RSA 1 REGULAR SHARE ACCT 323 $150,195.94 901.000 RSA 22 REGULAR SHARE ACCT 1 $19.13 901.000 SDA 2 DIVIDEND CHECKING 84 $17,156.64 902.000 SMC 25 6 MONTH CERT 23 $3,698.37 908.000 SPC 90 SPECIAL SHARE ACCT 30 $95,973.04 904.000 SSA 21 SECONDARY SHARE ACCT 29 $1,648.54 904.000 TYC 27 TWO YEAR CERT 2 $69.13 908.000 VAC 5 VACATION ACCOUNT 33 $924.56 903.000
Download Share YTD-DIV totals by DESC-ABRV and ACC with GL Account Numbers
Created: 2021/1/25
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 non-charged-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 non-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
- Reports members who have an aggregate share balance of $100,000.00 or more by SSN. Uses Multi-Pass Reporting and contains 2 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
Date: 12/09/2021 Page: 1
Time: 8:55 AM 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
888-55-2222 DENNIS STEIGMANN 291,868.08
252-98-8282 BEVERLY HOLLIS 288,157.15
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
852-69-5874 DEBORAH PITZER 138,749.40
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
466-41-6188 HARRY BANK 129,553.97
555-12-1212 MARY WHITE 125,820.32
540-87-3226 KENT M POLADERD 124,317.70
540-07-5536 DONALD E PELPER 120,783.25
222-95-6839 JERRY R LEYTON 107,853.29
540-43-4900 KATHY MASON 104,474.46
528-87-8880 TED LARCHMONT 103,757.76
===============
Credit Union Total: 21,744,850.70
Date: 12/09/2021 Page: 1
Time: 8:47 AM Members Aggregate Share report by SSN
$100,000.00 Plus Members
(All Suffix's)
SSN# Member Name Account-Sfx Balance
__________________________________________________________________________
238-38-5192 CHERYL M ALTENHEISS
53835-00 555,472.90
53835-15 4.33-
Account Total: 555,468.57
SSN Total: 555,468.57
888-55-2222 DENNIS STEIGMANN
632-00 71,624.10
Account Total: 71,624.10
634-00 107,484.22
634-15 97,481.50
634-30 15,278.26
Account Total: 220,243.98
SSN Total: 291,868.08
252-98-8282 BEVERLY HOLLIS
622-00 3,394.79
622-40 264,202.63
622-43 7,521.85
622-44 5,014.57
622-45 8,023.31
Account Total: 288,157.15
SSN Total: 288,157.15
Download Aggregate Share Balance by SSN
Created: 2016/09/01
Last Updated: 2021/08/23
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.
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
Certificate Maturity Reports
- Certificates Maturing by Day, Month and Year.
- These reports print both Summary and Detail information for all open Certificates.
Sample Report Output
DATE: 05/20/2024 TIME: 10:38 AM Page: 1
ALL Open Certificates by Maturity Date
~Summary by Month~
Maturity Date No. Certs. Total Balance
2022/09 1 3,166.09
2022/10 16 197,322.88
2022/11 3 47,433.41
2022/12 10 467,659.99
2023/01 3 27,454.92
2023/02 2 5,139.62
2023/03 31 146,614.84
2023/04 26 71,566.41
2023/05 4 55,667.44
2023/06 40 1,191,817.33
2023/07 4 16,701.97
2023/08 1 10,539.46
2023/09 2 8,295.76
2023/10 1 819.37
2023/12 1 19,340.08
2024/09 3 61,738.55
148 Cnt 2,331,278.12 Tot
DATE: 05/20/2024 TIME: 10:39 AM Page: 1
ALL Open Certificates by Maturity Date
~Details by Month~
Maturity Date Account Age Name Suffix Desc Abrv Balance
2022/09 47264 14 BRANDON AMEN 60 TYC 3,166.09
1 Cnt 3,166.09 Tot
2022/10 620 50 BRETT BUTLER 30 SMC 10,185.51
2022/10 626 43 JOHN WILLIAMS 30 SMC 10,694.77
2022/10 629 40 DAVID TANK 30 SMC 5,092.76
2022/10 632 64 DEBORAH PITZER 30 SMC 13,241.14
2022/10 633 47 JOHN PATTERSON 30 SMC 6,111.29
2022/10 634 56 DENNIS STEIGMANN 30 SMC 15,278.26
2022/10 7228 62 JANE ANDERSON 60 12C 2,500.00
2022/10 7228 62 JANE ANDERSON 70 12I 10,000.00
2022/10 7228 62 JANE ANDERSON 71 12I 6,000.00
2022/10 7228 62 JANE ANDERSON 72 12I 911.11
2022/10 41239 13 KIMBERLY N LAMBER 60 TYC 1,860.75
2022/10 41290 72 SHIRLEY J GEIGER 30 SMC 51,141.00
2022/10 45138 50 EDWARD A OLIVER 31 SMC 14,323.26
2022/10 48272 73 IRIS GOLDBLATT 50 OYC 15,216.14
2022/10 49674 87 LOUIS T GOLDENWOOD 33 SMC 30,692.69
2022/10 888999 54 MARY SMITH 30 SMC 4,074.20
16 Cnt 197,322.88 Tot
2022/11 35024 58 KENNETH H JEFFERSON 30 SMC 25,985.36
2022/11 49674 87 LOUIS T GOLDENWOOD 30 SMC 18,182.22
2022/11 54014 53 JOHANN SORENSON 30 SMC 3,265.83
3 Cnt 47,433.41 Tot
Download Certificate Maturity Reports
Created: 2024/05/20
CERTIFICATE-COST-PROJECTION
- Certificate cost projection by month and rate.
- This report gathers certificate accounts where the balance is greater than zero.
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 Certificates that will mature between the current year and the next 6 years and 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
IRA Required Minimum Distribution - RMD
- This report contains the calculations for RMD using the "Life Expectancy Table 2024".
Sample Report Output
Date: 05/20/2024 IRA - Required Minimum Distribution Page: 1
Time: 1:07 PM RMD using 2024 Life Expectancy Table
Account SSN Member Name Birth Date Age
600 544-74-3017 EDDIE MURPHY 08-01-1950 73
Plan #: 1 Desc: IRA SFX: 40 Balance: 1,130.31
Plan #: 1 Desc: 12I SFX: 43 Balance: 50,968.60
Total: 52,098.91 RMD: 4,407.69
601 258-62-3100 BRENDA BROWN 12-25-1946 77
Plan #: 1 Desc: IRA SFX: 40 Balance: 1,130.31
Plan #: 1 Desc: 12I SFX: 43 Balance: 8,154.98
Total: 9,285.29 RMD: 978.43
602 544-74-3018 ROBIN WILLIAMS 08-02-1950 73
Plan #: 1 Desc: IRA SFX: 40 Balance: 565.15
Plan #: 1 Desc: 12I SFX: 43 Balance: 510.50
Total: 1,075.65 RMD: 91.00
603 258-62-3101 JACK JONES 02-02-1950 74
Plan #: 1 Desc: IRA SFX: 40 Balance: 2,260.54
Plan #: 1 Desc: 12I SFX: 43 Balance: 1,000.00
Total: 3,260.54 RMD: 290.86
Download IRA Required Minimum Distribution - RMD
Created: 2024/05/20
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
