Spectrum Deposit Reports

From Vital Soft Wiki

Revision as of 18:19, 25 January 2021 by Paulae (talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to: navigation, search

Contents

[hide]

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

Aggregate Shares by Dollar Volume

This context was created with the Report Design and is multipass.

h2= This report selects all open, non-charged off shares and totals by Account. A host file is created for use in the second pass. h3=The final report groups the account balances by nine different ranges. There are total counts, balances and percent of total for each range.

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

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

Aggregate Share Balance by SSN

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

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

Back to Context Library

Retrieved from "https://wiki.vital-soft.com/index.php?title=Spectrum_Deposit_Reports&oldid=3128"