Spectrum Deposit Reports

From Vital Soft Wiki
Revision as of 19:03, 23 August 2021 by Paulae (talk | contribs)
Jump to: navigation, search

Share Dividend Rates

  • 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

Aggregate Shares by Dollar Volume

  • 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

Share YTD-DIV totals by DESC-ABRV and ACC with GL Account Numbers

  • 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 \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

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

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.

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