View source for Spectrum Deposit Reports

{{SampleContext|
name=MEMBERS-SHARE-PORTFOLIO-SUMMARY|
h1=Share Portfolio Summary by Description Abbrv.|
h2=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.|
link=MEMBERS-SHARE-PORTFOLIO-SUMMARY.ctx|
created=2016/09/01|
results={{Results_MEMBERS-SHARE-PORTFOLIO-SUMMARY|}}
}}
 
{{SampleContext|
name=TOP-100-DEPOSITORS-BY-ACCOUNT|
h1=Created in REPORT.  Uses Multi-Pass Reporting and contains 2 REPORTS.|
h2=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.|
link=TOP-100-DEPOSITORS-BY-ACCOUNT.ctx|
created=2016/09/01|
results={{Results_TOP-100-DEPOSITORS-BY-ACCOUNT|}}
}}
 
{{SampleContext|
name=TOP-100-DEPOSITORS-BY-SSN|
h1=Created in REPORT.  Uses Multi-Pass Reporting and contains 2 REPORTS.|
h2=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.|
link=TOP-100-DEPOSITORS-BY-SSN.ctx|
created=2016/09/01|
results={{Results_TOP-100-DEPOSITORS-BY-SSN|}}
}}
 
{{SampleContext|
name=CD-IRA-MATURITY-REPORT|
h1=Created in Report.  Lists all CDs and IRAs maturing from an as of date.|
h2=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|s and IRA|s.  It is broken down by 0-3 months, 4-6 months, 7-12 months, \n1-2 years, 2-3 years,\n3-5 years and 5+ years.|
link=CD-IRA-MATURITY-REPORT.ctx|
created=2016/09/01|
results={{Results_CD-IRA-MATURITY-REPORT|}}
}}
 
{{SampleContext|
name=Aggregate Share Balance by SSN|
link=AGG-SHARE-BY-SSN.ctx|
h1= Reports top 100 members by their aggregate share balance by SSN. Uses Multi-Pass Reporting and contains 3 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.|
created=2016/09/01|
updated=2020/07/09|
results={{ResultsAggShareBalanceBySSN}}
}}
 
{{SampleContext|
name=CHECKING-WITH-MONEY|
h1=Created in REPORT. Members with a Savings Balance Less Than $5.00 and Positive Checking Balance.|
h2=Members with a Savings (suffix 0) balance less than $5.00 and a positive balance in Checking (suffix 90).|
link=CHECKING-WITH-MONEY.ctx|
created=2016/09/01|
results={{Results_CHECKING-WITH-MONEY|}}
}}
 
{{SampleContext|
name=SHARES-BY-BEACON-SCORE|
h1=Created in REPORT.  Groups shares by Beacon Scores.|
h2=Groups shares by Beacon Scores.  There are 5 beacon groups: 700+, 650-699, 610-649, 590-609, LE 589.|
link=SHARES-BY-BEACON-SCORE.ctx|
created=2016/09/01|
results={{Results_SHARES-BY-BEACON-SCORE|}}
}}
 
{{SampleContext|
name=NEGATIVE-SHARES|
h1=Created in LIST.  Selects all shares not closed or charged off with a balance less than zero.|
h2=N/A|
link=NEGATIVE-SHARES.ctx|
created=2016/09/01|
results={{Results_NEGATIVE-SHARES|}}
}}
 
{{SampleContext|
name=BRANCH-SHARE-SUMMARY|
h1=This report prints a summary of the open SHARE-FILE accounts.|
h2=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.|
link=BRANCH-SHARE-SUMMARY.ctx|
created=2016/09/01|
results={{Results_BRANCH-SHARE-SUMMARY|}}
}}
 
{{SampleContext|
name=PAST3MO-AVG-CHK-BAL|
h1=Checking with avg balance in-between $500.01 and $1000.00.|
h2=The purpose of this report is to find checking accounts that have a three month average balance in-between 500.01-1000.00.|
link=PAST3MO-AVG-CHK-BAL.ctx|
created=2016/09/01|
results={{Results_PAST3MO-AVG-CHK-BAL|}}
}}
 
{{SampleContext|
name=BRANCH-SHARE-ACCOUNTS-DTL|
h1=New account summary report by branch.|
h2=This report pulls new accounts which have ENTRY-DATES in-between two user defined dates that are asked for upon running the report.|
link=BRANCH-SHARE-ACCOUNTS-DTL.ctx|
created=2016/09/01|
results={{Results_BRANCH-SHARE-ACCOUNTS-DTL|}}
}}
 
{{SampleContext|
name=CERTIFICATE-COST-PROJECTION|
h1=Certificate cost projection by month and rate.|
h2=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.|
link=CERTIFICATE-COST-PROJECTION.ctx|
created=2016/09/01|
results={{Results_CERTIFICATE-COST-PROJECTION|}}
}}
 
{{SampleContext|
name=CERTIFICATE-MATURITY-SUMMARY|
h1=Reports all open Certificates within a 6 year period.|
h2=This report pulls Certificate accounts that mature in-between dates that the user specifies and that have a balance greater than zero.|
link=CERTIFICATE-MATURITY-SUMMARY.ctx|
created=2016/09/01|
results={{Results_CERTIFICATE-MATURITY-SUMMARY|}}
}}
 
{{SampleContext|
name=SHARE-BALANCE-GTE-100K|
h1=Share balances >= 100K, totals by SSN.|
h2=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.|
link=SHARE-BALANCE-GTE-100K.ctx|
created=2016/09/01|
results={{Results_SHARE-BALANCE-GTE-100K|}}
}}
 
{{SampleContext|
name=NSF-REPORTING|
h1=NSF Report Sorted by DESC-ABRV, ACCOUNT.|
h2=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.|
link=NSF-REPORTING.ctx|
created=2016/09/01|
results={{Results_NSF-REPORTING|}}
}}

[[Spectrum Context Library | Back to Context Library]]