Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

KeyAccount Analysys 2011 by xdKhg06

VIEWS: 0 PAGES: 36

									Kristen M. Scalise CPA, CFE
County of Summit Fiscal Office
Account Analysis Statement Activity

                                               r   y                ry
                                            ua                    ua           ch
                                         n                   b  r
                                                                           ar           ril      ay
Fiscal Year 2011                       Ja                 Fe              M           Ap        M

FDIC ASSESSMENT
DEFERRED BILLING FEE                    1                    1             1           1         1
MAINTENANCE                             5                    5             5           5         5
ZBA CONCENTRATION ACCOUNT               1                    1             1           1         1
ZBA SUBSIDIARY ACCOUNTS                 3                    3             3           3         3
DDA PAPER STATEMENT
ANALYSIS CHARGE                         1                    1             1           1         1
LOCKBOX BASE FEE                        1                    1
LOCKBOX ITEMS
LOCKBOX CASH RECEIVED                   2
INCOMING EXPRESS PACKAGE                                    28
LOCKBOX SCANNABLE ITEMS          20,250                54,412
LOCKBOX CORRESPONDENCE              656                 2,448
LBX IMAGE CHECK SCAN             16,687                38,922
LBX IMAGE REMIT SCAN             20,250                54,412
LBX IMAGE TRANSMISSION FEE           14                     15
LOCKBOX SORT                     16,687                38,922
LOCKBOX WEEKEND PROCESSING            1                     1
LOCKBOX HARD COPY REPORT
LBX DEPOSITED ITEM CLEARING      16,687                38,922
LOCKBOX DATA TRANSMISSION            14                    15
LBX IMAGE CDROM CREATION FEE          8                    14
LOCKBOX MAIL DELIVERY                                       2
LOCKBOX MISC DELIVERY                 560                 773
Miscellaneous Deposit Tickets
BRANCH DEPOSITED CASH
Deposits Branch/ Night Drop          26                    28             30          26        24
Deoposits Key Capture Plus          157                   185            177         117       118
DEPOSITS LOCKBOX                      9                    15
ELECTRONIC ITEM CLEARING AGENT    9,364                10,697        11946          7372      7355
PREENCODE CHECK OTHER FED           313      467     489
ELECTRONIC ITEM ONUS              1,717    1,692    1922    1154    1130
PREENCODE CHECK ONUS                160      353     188      17
PREENCODE CHECK LOCAL CITY          757    1,711    1175     145
PREENCODE CHECK IN-DISTRICT          79      161     192      24
PREENCODE CHECK LOCAL RCPC          511    1,523    1044     100
PREENCODE CHECKS DEPOSITED                                   798    1294
ELECTRONIC ITEM DIRECT SEND      14,299   15,838   16872   11011   10804
UNENCODED CHECK ON US
UNENCODED CHECK LOCAL CITY
UNENCODED CHECK IN-DISTRICT
UNENCODED CHECK OTHER FED
UNENCODED CHECK LOCAL RCPC
CANADIAN DEPOSITED ITEM              1                 2
CHECK CHARGE BACKS                  23       63       65      22      14
REDEPOSITED RETURNED                30       62       83      22      23
KTT RETURN ITEM REPORT               1        1        1       1       1
KTT RETURNED ITEM DETAIL                                              14
KEY CAPTURE PLUS MONTHLY FEE         1        1        1       1       1
DEPOSIT ERROR SVC CHG
CDA ADMIN FEE                         2        2       2       2       2
KTT SAMEDAY POSITIVE PAY              1        1       1       1       1
CDA CHECKS <500                   1,000      980     976    1000    1000
CDA CHECKS >500                   3,851    5,271    5854    4940    5869
CHECK QUALITY SVC CHG
KTT STOP PAYMENT ENTRY              15        7       13       8      10
IMAGE SHORT-TERM BASE FEE            1        1        1       1       1
IMAGE LONG TERM BASE FEE
KTT SHORT TERM IMAGE BASE FEE
KTT CHECK IMAGE MAINTENANCE
Deposit Key Capture Plus
KEYIMAGE ITEM CAPTURE W/TRUN
CHECK IMAGE VIEWING (TRUNCATE)
CHECK ENCLOSURE FEE
KEYIMAGE CDROM CREATION FEE
CD Item Capture                   4,247    5,771    6353    5437    6158
IMAGE LONG-TERM CAPTURE FEE         602      480     476     502     711
ARP IMAGE STMT DELIVERY FEE          1       1       1
ARP FULL RECON MAINTENANCE           2       2       2      2      2
ARP FULL PAYEE PER ITEM          4,849   6,251    6829   5939   6869
ARP TRANSMISSION INPUT/OUTPUT       20      20      20     20     20
ARP DAILY TRANSMISSION INPUT         1       1       1      1      1
ACH MONTHLY FEE                      1       1       1      1      1
ARP Paid No Issue (Per Item)
Orig ACH Dr Via Direct Send         2       2        3      2      2
ORIGINATED ACH DEBIT VIA KTT        2       2        2      2      3
Originated ACH Credit Via KTT
Org ACH Cr Via Direct Send       8,633   8,802   13225   8830   8861
Org ACH Credit Via KTT             176     162     306    259    126
ACH Item Min Per File (<250)         1       1       1      1      1
ACH REVERSAL OR DELETION             3                             2
ACH ORIGINATED DEBIT ITEM
ACH ORIGINATED CREDIT ITEM
ACH ADDENDA ORIGINATED            155     136      285    232    103
ACH RECEIVED ADDENDA                                      150    129
ORIGINATED LATE FILE SURCHARGE
INCOMING ACH DEBIT ITEM             9      51       11     10     10
INCOMING ACH CREDIT ITEM          211     225      199    206    190
ACH RETURN ITEMS                    4       2        4      3      3
CAR REPORT FOR KTT ACH              1       1        1      1      1
CAR REPORT VIA MAIL OR FAX          4       1        3      3      4
ACH DATA TRANSMISSION               3       3        4      3      3
CAR REPORT VIA KTT IR               1       1        1      1      1
EPA ADMIN FEE W/ ACH DIRECT         2       2        2      2      2
ACH DIRECT MONTHLY MAINT            1       1        1      1      1
ACH NOC'S                                                   2      1
KTT ACH MONTHLY BASE FEE            1       1        1      1      1
WIRETRANSFERS- OUTGOING             6       4        3      6      3
INCOMING FED-MANUAL
WIRE TRANSFERS- INCOMING            9       8        8     13      7
Internal Xfer Non Rep Deb                                          1
WIRE OUTGOING REPEAT
WIRE MAIL CREDIT ADVICE                                    13      7
KTT PREVIOUS DAY REPORT             1       1        1      1      5
KTT CURRENT DAY REPORT                                              4        4
KTT INTRADAY REPORT                     1         1        1
KTT FILE TRANSFER BASE FEE              1         1        1        1        1
KTT ACCOUNT MANAGEMENT BASE FEE         1         1        1        1        1
KTT INFO REPORTING BASE FEE             5         5        5        5
KTT PREVIOUS DAY DETAIL ITEMS       5,472     7,175     7406     6781     6783
KTT INTRADAY DETAIL ITEMS           1,042     1,036      959      953      908
KTT Corp Banking Statement              4         4        4        4        4
OVERNIGHT REPO SWEEP
KTT INVESTMENT CONFIRM REPORT
PHOTOCOPY PER ITEM
INFO. RPTG.-CLIENT
Stop Payments
Check Book Charges
EPA Authorize Fee
Uncollected Funds Direct Charge
Branch Strap out                                 1
Branch Change Order                    2         1
Branch Roll Out                        2        14
EPA CORRECTION FEE
Checks paid to 500                               1
ARP Paid No Issue (Per Item)
CD CREATION FEE                         1        1         1        1        1
Image Statement Delivery Fee                     1         1        1
KTT ACH BATCH REVERSAL FEE              1
TOTAL: MONTHLY DETAIL             149,625   298,132   77,168   56,168   58,603
                                                            r                          r              r
                                                       be              r             be          be
                                        st          te
                                                      m              be             m          em
  il
        ay
                   e        ly        gu                          to              e                            al
pr     M       Ju
                  n
                         Ju        Au          Se
                                                 p
                                                                Oc           No
                                                                                v
                                                                                           D ec            T ot


                                                                                                              0
                 1         1        1           1                1            1             1                12
                 5         5        5           5                6            6             7                64
                 1         1        1           1                1            1             1                12
                 3         3        3           3                4            4             4                39
                 4         4        4           4                5            5             6
                 1         1        1           1                1            1             1                12
                 1         1        1                                                                         5
                                                                                                              0
                                                                                                              2
                           5
             27009     45282                                                                        146,953
              1368      2893                                                                          7,365
             21654     32357                                                                        109,620
             27009     45282                                                                        146,953
                                                                                                         29
             21654     32357                                                                        109,620
                 1         1        1                                                                     5
                                                                                                          0
             21654     32357                                                                        109,620
                19        13                                                                             61
                13        15                                                                             50

              1037       770                                                                              3,140
                           1
                                                                                                              0
                28        28       27          25           25               23            24
               134       168      139         124          113              122           164
                15        13                                                                             52
              8272     10159     9232        7346         6988             7796     10991           107,518
                                                          1,269
 1247    1494    1554    1138    1265    1326    2011    15,933
                                                            558
                                                          3,788
                                                            456
                                                          3,178
 1685    3699    1399     801     772     820    1136
12755   16049   13802   11620   11192   12302   15546   162,090
                                                              0
                                                              0
                                                              0
                                                              0
                                                              0
                                                              3
   31      58      60      31      14      27      31       439
   30      98      57      32      18      22      35       512
    1       1       1       1       1       1       1        12
   63     158     113      66      32      48      68
    1       1       1       1       1       1       1        12
                                                              0
    2       2       2       2       2       2       2        24
    1       1       1       1       1       1       1        12
 1000    1000    1000    1000    1000     890    1000    11,846
 5588    5126    5737    4852    6187    4933    7690    65,898
                                                              0
    8       9      10      10      10       7      11       118
    1       1       1       1       1                        10
                                            1       1
    1       1               1       1       1       1
                                                              0
                                                              0
                                                              0
                                                              0
                                                              0
                                                              0
 5929    5247    6102    5290    6552    5432    8162    70,680
 6588    6126    6737    5852    7187    5823    8690    49,774
                                                        3
   2      2       2      2      2      2      2        24
6588   6125    6736   5852   7187   5822   8690    77,737
  20     20      20     20     20     20     20       240
   1      1       1      1      1      1      1        12
   1      1       1      1      1      1      1        12
                                     264
   2      2       3      2      2      2      3        27
   2      3       2      1      2      1      2        24
                                                        0
8926   8893   13290   8772   8751   8751   8734   114,468
 211    220     227    318    151    226    133     2,515
   1      1       1      1      1      1      1        12
   2      1       3                           4        15
                                                        0
                                                        0
 188    198     207    297    125    204    114     2,244
 121    139     126    164    126    134    146
                                                        0
   7     29      12      8     12      7     11       177
 210    269     211    221    196    238    279     2,655
                  3      5      1      1               26
   1              1      1      1      1      1        11
   2      3       3      3      4      2      4        36
   3      3       4      3      3      3      3        38
   1      1       1      1      1      1      1        12
   2      2       2      2      2      2      2        24
   1      1       1      1      1      1      1        12
          1              2      7      3               16
   1      1       1      1      1      1      1        12
   3      4                     2      3      2        36
                                       1                1
   8      4              4      5      1      4        71
                                              1         2
                                                        0
  13      4       1      4      5      2      4
   5      5       5      5      5      5      5       44
      5         5        5        5        5        6        6
                                                                        3
      1         1        1        1        1        1        1         12
      1         1        1        1        1        1        1         12
                                                                       20
   7666      7409     6843     6605     7625     6542     9574     85,881
   1260      1461     1037      984      884      948     1092     12,564
      5         5        5        5        5        6        6         57
                                                                        0
                                                                        0
                                                                        0
                                                                        0
                                                                        0
                                                                        0
                                                                        0
                                                                        0
                                                                        1
                                                                        3
                                                                       16
                                                                        0
                                                                        1
                                                                        0
      1         1     1.00        1        1        1        1         12
                                                                        3

190,075   265,604   74,749   61,503   66,516   62,801   84,436   1,445,380
                                                                         0
     r
be
             al        g.
         T ot        Av

                          0
                          1
                          5
                          1
                          3

                          1
                          0
                          0
                          0

                  12,246
                     614
                   9,135
                  12,246
                       2
                   9,135
                       0
                       0
                   9,135
                       5
                       4

                    262

                       0
                     314
                   1,718
                       4
                   8,960
   106
 1,328
    47
   316
    38
   265

13,508
     0
     0
     0
     0
     0
     0
    37
    43
     1

     1
     0
     2
     1
   987
 5,492
     0
    10
     1


     0
     0
     0
     0
     0
     0
 5,890
 4,148
    0
    2
6,478
   20
    1
    1

    2
    2
    0
9,539
  210
    1
    1
    0
    0
  187

   0
  15
 221
   2
   1
   3
   3
   1
   2
   1
   1
   1
   3
   0
   6
   0
   0

   4
      0
      1
      1
      2
  7,157
  1,047
      5
      0
      0
      0
      0
      0
      0
      0
      0
      0
      0
      1
      0
      0
      0
      1
      0

120,448
      0
                                        r   y            ry
                                     ua                ua         ch
                                    n               br
                                                                ar        ril
Fiscal Year 2011                  Ja             Fe            M        Ap

FDIC ASSESSMENT
DEFERRED BILLING FEE             10.00          10.00         10.00    10.00
MAINTENANCE                      13.00          13.00         13.00    13.00
ZBA CONCENTRATION ACCOUNT        25.00          25.00         25.00    25.00
ZBA SUBSIDIARY ACCOUNTS          25.00          25.00         25.00    25.00
ANALYSIS CHARGE                  13.50          13.50         13.50    13.50
LOCKBOX BASE FEE                 90.00          90.00
LOCKBOX ITEMS
LOCKBOX CASH RECEIVED             5.00
LOCKBOX SCANNABLE ITEMS           0.25           0.25
INCOMING EXPRESS PACKAGE                        10.00
LOCKBOX CORRESPONDENCE            0.20           0.20
LBX IMAGE CHECK SCAN              0.03           0.03
LBX IMAGE REMIT SCAN              0.03           0.03
LBX IMAGE TRANSMISSION FEE        5.00           5.00
LOCKBOX SORT                      0.03           0.03
LOCKBOX WEEKEND PROCESSING        5.00           5.00
LOCKBOX HARD COPY REPORT
LBX DEPOSITED ITEM CLEARING       0.08           0.08
LOCKBOX DATA TRANSMISSION         7.00           7.00
LBX IMAGE CDROM CREATION FEE     25.00          25.00
LOCKBOX MAIL DELIVERY                            1.70
LOCKBOX MISC DELIVERY             0.04           0.03
BRANCH DEPOSITED CASH
DEPOSITS LOCKBOX                  0.40           0.40
Deposits Branch/ Night Drop       0.40           0.40          0.40     0.40
Deposits Key Capture Plus         0.40           0.40          0.40     0.40
ELECTRONIC ITEM CLEARING AGENT    0.07           0.07          0.07     0.07
PREENCODE CHECK OTHER FED         0.03           0.03          0.03
ELECTRONIC ITEM ONUS              0.03           0.03          0.03     0.03
PREENCODE CHECK ONUS              0.03           0.03          0.03     0.03
PREENCODE CHECK LOCAL CITY        0.04           0.04          0.04     0.04
PREENCODE CHECK IN-DISTRICT       0.03           0.03          0.03     0.03
PREENCODE CHECK LOCAL RCPC        0.03           0.03          0.03     0.03
PREENCODE CHECKS DEPOSITED                                              0.03
ELECTRONIC ITEM DIRECT SEND       0.03           0.03          0.03     0.03
UNENCODED CHECK ON US
UNENCODED CHECK LOCAL CITY
UNENCODED CHECK IN-DISTRICT
UNENCODED CHECK OTHER FED
UNENCODED CHECK LOCAL RCPC
CANADIAN DEPOSITED ITEM            2.00              2.00
CHECK CHARGE BACKS                 7.00     7.00     7.00     7.00
REDEPOSITED RETURNED                        0.00     0.00
KTT RETURN ITEM REPORT            30.00    30.00    30.00    30.00
KEY CAPTURE PLUS MONTHLY FEE     300.00   300.00   300.00   300.00
DEPOSIT ERROR SVC CHG
CDA ADMIN FEE                    100.00   100.00   100.00   100.00
KTT SAMEDAY POSITIVE PAY                    0.00     0.00
CDA CHECKS <500                    0.05     0.05     0.05     0.05
CDA CHECKS >500                    0.05     0.05     0.05     0.05
CHECK QUALITY SVC CHG
KTT STOP PAYMENT ENTRY            10.00    10.00    10.00    10.00
IMAGE SHORT-TERM BASE FEE         30.00    30.00    30.00     0.00
KTT CHECK IMAGE MAINTENANCE
KEYIMAGE ITEM CAPTURE W/TRUN
CHECK IMAGE VIEWING (TRUNCATE)
CHECK ENCLOSURE FEE
CD Item Capture                    0.04     0.04     0.04     0.04
IMAGE LONG-TERM CAPTURE FEE        0.03     0.03     0.03     0.03
ARP IMAGE STMT DELIVERY FEE       20.00    20.00    20.00
ARP Paid No Issue (Per Item)
KEYIMAGE CDROM CREATION FEE       25.00    25.00    25.00    25.00
ARP FULL RECON MAINTENANCE        30.00    30.00    30.00    30.00
ARP FULL PAYEE PER ITEM            0.05     0.05     0.05     0.05
ARP TRANSMISSION INPUT/OUTPUT      5.00     5.00     5.00     5.00
ARP DAILY TRANSMISSION INPUT      75.00    75.00    75.00    75.00
ACH MONTHLY FEE                   35.00    35.00    35.00    35.00
Org ACH Dr Via Direct Send         0.13     0.13     0.13     0.13
Org ACH Debit Via KTT              0.13     0.13     0.13     0.13
Org ACH Cr Via Direct Send         0.04     0.04     0.04     0.04
Originated ACH Credit Via KTT      0.04     0.04     0.04     0.04
ACH REVERSAL OR DELETION          20.00
ACH ORIGINATED DEBIT ITEM          0.12
ACH ORIGINATED CREDIT ITEM         0.12
ACH ITEM MIN PER FILE (<250)      25.00    25.00    25.00    25.00
ACH ADDENDA ORIGINATED             0.03     0.03     0.03     0.03
ACH RECEIVED ADDENDA                                          0.03
ORIGINATED LATE FILE SURCHARGE
INCOMING ACH DEBIT ITEM                    0.12    0.12    0.12
INCOMING ACH CREDIT ITEM                   0.12    0.12    0.12
ACH RETURN ITEMS                   4.00    4.00    4.00    4.00
CAR REPORT FOR KTT ACH            30.00   30.00   30.00   30.00
CAR REPORT VIA MAIL OR FAX         5.00    5.00    5.00    5.00
ACH DATA TRANSMISSION              5.00    5.00    5.00    5.00
CAR REPORT VIA KTT IR             30.00   30.00   30.00
EPA ADMIN FEE W/ ACH DIRECT       10.00   10.00   10.00   10.00
ACH DIRECT MONTHLY MAINT          35.00   35.00   35.00   35.00
ACH NOC'S                                                  4.00
KTT ACH MONTHLY BASE FEE          50.00   50.00   50.00   50.00
WIRE TRANSFERS- OUTGOING          10.00   10.00   10.00   10.00
INCOMING FED-MANUAL
WIRE TRANSFERS- INCOMING          10.00   10.00   10.00   10.00
WIRE MAIL CRDIT ADVICE                                     3.00
Internal Xfer Non Rep Deb
WIRE OUTGOING REPEAT
KTT PREVIOUS DAY REPORT           30.00   30.00   30.00   30.00
KTT INTRADAY REPORT               30.00   30.00   30.00
KTT CURRENT DAY REPORT                                    30.00
KTT FILE TRANSFER BASE FEE                         0.00
KTT ACCOUNT MANAGEMENT BASE FEE   50.00   50.00   50.00   50.00
KTT INFO REPORTING BASE FEE       30.00   30.00   30.00
KTT PREVIOUS DAY DETAIL ITEMS      0.03    0.03    0.03    0.03
KTT INTRADAY DETAIL ITEMS          0.10    0.10    0.10     0.1
KTT Corp Banking Statement                 0.00    0.00       0
OVERNIGHT REPO SWEEP
KTT INVESTMENT CONFIRM REPORT
FDIC ASSESSMENT
PHOTOCOPY PER ITEM
INFO. RPTG.-CLIENT
Stop Payments
Check Book Charges
EPA Authorize Fee
Miscellaneous Deposit Tickets
Uncollected Funds Direct Charge
Branch Strap out                   0.50    0.50
Branch Change Order                        0.00
Branch Roll Out                            0.13
EPA CORRECTION FEE
Checks paid to 500                         0.20
ARP Paid No Issue (Per Item)
Image Statement Delivery Fee                   7.00        7.00
TOTAL: MONTHLY DETAIL          1,270.09   1,262.11    1,118.53    1,006.56
                                                               r                              r              r
                                                          be                 r              be          be
                                             st       te
                                                        m                  be              m          em
    il                 e        ly       gu                            to                e
   r      ay          n                              p                                v             ec
Ap       M         Ju        Ju       Au           Se                Oc            No             D


         10.00    10.00     10.00     0.00         0.00
         13.00    13.00     13.00    13.00        13.00            13.00         13.00      13.00
         25.00    25.00     25.00    25.00        25.00            25.00         25.00      25.00
         25.00    25.00     25.00    25.00        25.00            25.00         25.00      25.00
         13.50    13.50     13.50    13.50        13.50            13.50         13.50      13.50
                 250.00    250.00


                   0.25      0.25
                            10.00
                   0.25      0.25
                   0.04      0.04
                   0.04      0.04

                   0.12      0.12
                  75.00     75.00     5.00

                   0.08
                  15.00     15.00
                  25.00     25.00

                   1.00      1.00

                   1.00      1.00
          0.40     0.40      0.40     0.40         0.40             0.40          0.40       0.40
          0.40     0.40      0.40     0.40         0.40             0.40          0.40       0.40
          0.07     0.07      0.08     0.07         0.07             0.07          0.07       0.07

          0.03     0.03      0.03                  0.03             0.03          0.03       0.03




          0.03     0.03      0.03     0.03         0.03             0.03          0.03       0.03
          0.03     0.03      0.03     0.03         0.03             0.03          0.03       0.03
  7.00     7.00     7.00     7.00     7.00     7.00     7.00     7.00

 30.00    30.00    30.00    30.00    30.00    30.00    30.00    30.00
300.00   300.00   300.00   300.00   300.00   300.00   300.00   300.00

100.00   100.00   100.00   100.00   100.00   100.00   100.00   100.00
  0.00
  0.05     0.05     0.05     0.05     0.05     0.05     0.05     0.05
  0.05     0.05     0.05     0.05     0.05     0.05     0.05     0.05

 10.00    10.00    10.00    10.00    10.00    10.00    10.00    10.00




  0.04     0.04     0.04     0.04     0.04     0.04     0.04     0.04
  0.03     0.03     0.03     0.03     0.03     0.03     0.03     0.03

                                               2.00
 25.00    25.00    25.00    25.00    25.00    25.00    25.00    25.00
 30.00    30.00    30.00    30.00    30.00    30.00    30.00    30.00
  0.05     0.05     0.05     0.05     0.05     0.05     0.05     0.05
 5.00     5.00     5.00      5.00     5.00     5.00       5        5
 75.00    75.00    75.00    75.00    75.00    75.00    75.00       75
 35.00    35.00    35.00    25.00    25.00    25.00       25       25
  0.13     0.13     0.13     0.04     0.04     0.04     0.04     0.04
  0.13     0.13       0      0.04     0.04     0.04     0.04     0.04
  0.04     0.04     0.04     0.04     0.04     0.04     0.04     0.04
  0.04     0.04     0.04     0.04     0.04     0.04     0.04     0.04
 20.00    20.00    20.00       20                                  20


 25.00    25.00    25.00    25.00    25.00    25.00       25       25
  0.03     0.03     0.03     0.03     0.03     0.03     0.03     0.03
  0.03     0.03     0.03     0.03        0
 0.12    0.12    0.12    0.04    0.04    0.04    0.04    0.04
 0.12    0.12    0.12    0.04    0.04    0.04    0.04    0.04
 4.00                       4       4    4.00       4
30.00   30.00   30.00    5.00    5.00    5.00       5      5
 5.00    5.00    5.00    5.00    5.00    5.00       5      5
 5.00    5.00    5.00    5.00    5.00    5.00       5      5

10.00   10.00   10.00   10.00   10.00   10.00     10      10
35.00   35.00   35.00   35.00   35.00   35.00     35      35
 4.00            4.00            4.00    4.00      4
50.00   50.00   50.00   25.00   25.00   25.00     25      25
10.00   10.00   10.00                   10.00     10      10
                                                  13
10.00   10.00   10.00           10.00   10.00     10      10
 3.00    3.00    3.00
 6.00                                                      6

30.00   30.00   30.00   30.00   30.00   30.00     30      30

30.00   30.00   30.00   30.00   30.00   30.00   28.33   28.33
 0.00
50.00   50.00   50.00   50.00   50.00   50.00     50      50

 0.03    0.03    0.03    0.03    0.03    0.03    0.03    0.03
  0.1    0.10    0.10    0.10     0.1    0.10     0.1     0.1




                 0.60
1,032.44   1,386.22   1,400.74   934.07   923.07   935.07 944.40   949.40
       r              r
     be          be
    m          em
  e                            al       g.
ov         D ec            T ot       Av

                      0.00           0.00
                     70.00           5.83
                    156.00          13.00
                    300.00          25.00
                    300.00          25.00
                    162.00          13.50
                    680.00          56.67
                      0.00           0.00
                      5.00           0.42
                      1.00           0.08

                      0.90           0.08
                      0.14           0.01
                      0.14           0.01
                     10.00           0.83
                      0.30           0.03
                    165.00          13.75
                      0.00           0.00
                      0.24           0.02
                     44.00           3.67
                    100.00           8.33

                          2.08       0.17
                          0.00       0.00
                          2.80       0.23
                          4.80       0.40
                          4.80       0.40
                          0.85       0.07
                          0.09       0.01
                          0.28       0.02
                          0.12       0.01
                          0.14       0.01
                          0.12       0.01
                          0.12       0.01

                          0.36       0.03
                          0.00       0.00
   0.00     0.00
   0.00     0.00
   0.00     0.00
   0.00     0.00
   4.00     0.33
  84.00     7.00
   0.00     0.00
 360.00    30.00
3600.00   300.00
   0.00     0.00
1200.00   100.00
   0.00     0.00
   0.60     0.05
   0.60     0.05
   0.00     0.00
 120.00    10.00
  90.00     7.50
   0.00     0.00
   0.00     0.00
   0.00     0.00
   0.00     0.00
   0.42     0.04
   0.30     0.03
  60.00     5.00

 300.00    25.00
 360.00    30.00
   0.60     0.05
  60.00     5.00
 900.00    75.00
 370.00    30.83
   1.11     0.09
   1.11     0.09
   0.48     0.04
   0.48     0.04
 120.00    10.00
   0.12     0.01
   0.12     0.01
 300.00    25.00
   0.36     0.03

   0.00     0.00
  0.92    0.08
  0.92    0.08
 36.00    3.00
235.00   19.58
 60.00    5.00
 60.00    5.00
 90.00    7.50
120.00   10.00
420.00   35.00
 24.00    2.00
475.00   39.58
100.00    8.33
 13.00    1.08
110.00    9.17

 12.00    1.00
  0.00    0.00
360.00   30.00
 90.00    7.50

  0.00    0.00
600.00   50.00
 90.00    7.50
  0.36    0.03
  1.20    0.10
  0.00    0.00
  0.00    0.00
  0.00    0.00
  0.00    0.00
  0.00    0.00
  0.00    0.00
  0.00    0.00
  0.00    0.00
  0.00    0.00

  0.00    0.00
  1.00    0.08
  0.00    0.00
  0.13    0.01
  0.00    0.00
  0.20    0.02
  0.00    0.00
   14.00    1.17
13162.68 ######
Kristen M. Scalise CPA, CFE
County of Summit Fiscal Office
Account Analysis Statement Activity

                                               r   y                ry
                                            ua                    ua            ch
                                           n                   br
                                                                              ar            ril
Fiscal Year 2011                         Ja                 Fe               M            Ap

FDIC ASSESSMENT                       2802.42           12359.30         6,955.16    1,948.19
DEFERRED BILLING FEE                    10.00              10.00            10.00       10.00
MAINTENANCE                             65.00              65.00            65.00       65.00
ZBA CONCENTRATION ACCOUNT               25.00              25.00            25.00       25.00
ZBA SUBSIDIARY ACCOUNTS                 75.00              75.00            75.00       75.00
ARP Image Stmt Delivery Fee             20.00              20.00            20.00
ANALYSIS CHARGE                         13.50              13.50            13.50      13.50
LOCKBOX BASE FEE                        90.00              90.00
LOCKBOX ITEMS
LOCKBOX CASH RECEIVED                 10.00
LOCKBOX SCANNABLE ITEMS           5,062.50             13,603.00
INCOMING EXPRESS PACKAGE                                  280.00
LOCKBOX CORRESPONDENCE                 131.20              489.60
LBX IMAGE CHECK SCAN                   500.61           1,167.66
LBX IMAGE REMIT SCAN                   607.50           1,632.36
LBX IMAGE TRANSMISSION FEE              70.00               75.00
LOCKBOX SORT                           500.61           1,167.66
LOCKBOX WEEKEND PROCESSING               5.00                5.00
LOCKBOX HARD COPY REPORT
LBX DEPOSITED ITEM CLEARING           1334.96           3,113.76
LOCKBOX DATA TRANSMISSION               98.00              105.00
LBX IMAGE CDROM CREATION FEE           200.00              350.00
LOCKBOX MAIL DELIVERY                                        3.40
LOCKBOX MISC DELIVERY                   25.00               25.00
BRANCH DEPOSITED CASH
DEPOSITS LOCKBOX                         3.60               6.00
Deposits Branch/ Night Drop             10.40              11.20           12.00       10.40
Deposits Key Capture Plus               62.80              74.00           70.80       46.80
Miscellaneous Deposit Tickets
ELECTRONIC ITEM CLEARING AGENT         655.48            748.79           836.22      516.04
PREENCODE CHECK OTHER FED                9.39             14.01            14.67
ELECTRONIC ITEM ONUS                    42.93             42.30            48.05       28.85
PREENCODE CHECK ONUS                     4.80             10.59             5.64        0.51
PREENCODE CHECK LOCAL CITY              26.50             59.89            41.13        5.08
PREENCODE CHECK IN-DISTRICT        2.37     4.83      5.76      0.72
PREENCODE CHECK LOCAL RCPC        15.33    45.69     31.32      3.00
PREENCODE CHECKS DEPOSITED                                     23.94
ELECTRONIC ITEM DIRECT SEND      428.97   475.14    506.16    330.33
UNENCODED CHECK ON US
UNENCODED CHECK LOCAL CITY
UNENCODED CHECK IN-DISTRICT
UNENCODED CHECK OTHER FED
UNENCODED CHECK LOCAL RCPC
CANADIAN DEPOSITED ITEM            2.00               4.00
CHECK CHARGE BACKS               161.00   441.00    455.00    154.00
REDEPOSITED RETURNED
KTT RETURN ITEM REPORT            30.00    30.00     30.00     30.00
KEY CAPTURE PLUS MONTHLY FEE     300.00   300.00    300.00    300.00
DEPOSIT ERROR SVC CHG
CDA ADMIN FEE                    200.00   200.00    200.00    200.00
KTT SAMEDAY POSITIVE PAY
CDA CHECKS <500                   50.00    49.00     48.80     50.00
CDA CHECKS >500                  192.55   263.55    292.70    247.00
CHECK QUALITY SVC CHG
KTT STOP PAYMENT ENTRY           150.00    70.00    130.00     80.00
IMAGE SHORT-TERM BASE FEE         30.00     30.00     30.00
KTT CHECK IMAGE MAINTENANCE
KEYIMAGE ITEM CAPTURE W/TRUN
CHECK IMAGE VIEWING (TRUNCATE)
CHECK ENCLOSURE FEE
CD Item Capture                  148.65   201.99    222.36    190.30
IMAGE LONG-TERM CAPTURE FEE       15.05    12.00     11.90     12.55
KEYIMAGE CDROM CREATION FEE       25.00    25.00     25.00     25.00
ARP FULL RECON MAINTENANCE        60.00    60.00     60.00     60.00
ARP FULL PAYEE PER ITEM          242.45   312.55    341.45    296.95
ARP TRANSMISSION INPUT/OUTPUT    100.00   100.00    100.00    100.00
ARP DAILY TRANSMISSION INPUT      75.00    75.00     75.00     75.00
ACH MONTHLY FEE                   35.00    35.00     35.00     35.00
Orig ACH Dr Via Direct Send        0.26     0.26      0.39      0.26
Orig ACH Debit Via KTT             0.26     0.26      0.26      0.26
Orig ACH Cr Via Direct Send      345.32   352.08    529.00    353.20
Org ACH Credit Via KTT             7.04     6.48     12.24     10.36
ACH REVERSAL OR DELETION          20.00
ACH ORIGINATED DEBIT ITEM
ACH ORIGINATED CREDIT ITEM
ACH ITEM MIN PER FILE (<250)      25.00    25.00     25.00     25.00
ACH ADDENDA ORIGINATED              4.65     4.08     8.55     6.96
ACH RECEIVED ADDENDA                                           4.50
ORIGINATED LATE FILE SURCHARGE
INCOMING ACH DEBIT ITEM             1.08     6.12     1.32     1.20
INCOMING ACH CREDIT ITEM           25.32    27.00    23.88    24.72
ACH RETURN ITEMS                   16.00     8.00    16.00    12.00
CAR REPORT FOR KTT ACH             30.00    30.00    30.00    30.00
CAR REPORT VIA MAIL OR FAX         20.00     5.00    15.00    15.00
ACH DATA TRANSMISSION              15.00    15.00    20.00    15.00
CAR REPORT VIA KTT IR              30.00    30.00    30.00      -
EPA ADMIN FEE W/ ACH DIRECT        20.00    20.00    20.00    20.00
ACH DIRECT MONTHLY MAINT           35.00    35.00    35.00    35.00
ACH NOC'S                                                      8.00
KTT ACH MONTHLY BASE FEE           50.00    50.00    50.00    50.00
WIRETRANSFERS- OUTGOING            60.00    40.00    30.00    60.00
Internal Xfer Non Rep Deb
INCOMING FED-MANUAL
WIRE TRANSFERS- INCOMING           90.00    80.00    80.00   130.00
WIRE OUTGOING REPEAT
WIRE MAIL CREDIT ADVICE                                       39.00
KTT PREVIOUS DAY REPORT            30.00    30.00    30.00   150.00
KTT INTRADAY REPORT                30.00    30.00    30.00
CURRENT DAY REPORT                                           120.00
KTT FILE TRANSFER BASE FEE
KTT ACCOUNT MANAGEMENT BASE FEE    50.00    50.00    50.00    50.00
KTT INFO REPORTING BASE FEE       150.00   150.00   150.00
KTT PREVIOUS DAY DETAIL ITEMS     164.16   215.25   222.18   203.43
KTT INTRADAY DETAIL ITEMS         104.20   103.60    95.90    95.30
KTT Corp Banking Statement
OVERNIGHT REPO SWEEP
KTT INVESTMENT CONFIRM REPORT
FDIC ASSESSMENT
PHOTOCOPY PER ITEM
INFO. RPTG.-CLIENT
Stop Payments
Check Book Charges
EPA Authorize Fee
Uncollected Funds Direct Charge
Branch Strap out                    1.00     0.50
Branch Change Order
Branch Roll Out                              1.82
EPA CORRECTION FEE
Checks paid to 500                              0.20
ARP Paid No Issue (Per Item)
Image Statement Delivery Fee                    7.00        7.00
TOTAL: MONTHLY DETAIL          16,049.86   39,695.42   12,608.34   6,417.35
                                                                             r                               r
                                                                        be                 r               be
                                                     st              te
                                                                       m                 be               m
  ril        ay          ne          ly         gu               p                   to             v   e
Ap          M          Ju          Ju         Au               Se                  Oc             No

        1,539.79   3,981.27    9,483.97   3,555.53        2,595.35     2,870.55            2,866.60
           10.00      10.00       10.00
           65.00      65.00       65.00     65.00           65.00           78.00               78.00
           25.00      25.00       25.00     25.00           25.00           25.00               25.00
           75.00      75.00       75.00     75.00           75.00          100.00              100.00

          13.50      13.50       13.50      13.50           13.50                13.50          13.50
                    250.00      250.00


                   6,752.25   11,320.50
                                  50.00
                     342.00      723.25
                     866.16    1,294.28
                   1,080.36    1,811.28

                   2,598.48    3,882.84
                      75.00       75.00       5.00

                   1,732.32    2,588.56
                     285.00      195.00
                     325.00      375.00

                   1,037.00     770.00

                     15.00       13.00
           9.60      11.20       11.20      10.80           10.00                10.00           9.20
          47.20      53.60       67.20      55.60           49.60                45.20          48.80
                                  0.60
         514.85     579.04      711.13     646.24          514.22          489.16              545.72

          28.25      31.18       37.35      38.85           28.45                31.63          33.15
 38.82    50.55   110.97    41.97    24.03    23.16    24.60
324.12   382.65   481.47   414.06   348.60   335.76   369.06




 98.00   217.00   406.00   420.00   217.00    98.00   189.00

 30.00    30.00    30.00    30.00    30.00    30.00    30.00
300.00   300.00   300.00   300.00   300.00   300.00   300.00

200.00   200.00   200.00   200.00   200.00   200.00   200.00

 50.00    50.00    50.00    50.00    50.00    50.00    44.50
293.45   279.40   256.30   286.85   242.60   309.35   246.65

100.00    80.00    90.00   100.00   100.00   100.00    70.00




215.53   207.52   183.65   213.57   185.15   229.32   190.12
 17.78   164.71   153.15   168.43   146.30   179.68   145.58
 25.00    25.00    25.00    25.00    25.00    25.00    25.00
 60.00    60.00    60.00    60.00    60.00    60.00    60.00
343.45   329.40   306.25   336.80   292.60   359.35   291.10
100.00   100.00   100.00   100.00   100.00   100.00   100.00
 75.00    75.00    75.00    75.00    75.00    75.00    75.00
 35.00    35.00    35.00    25.00    25.00    25.00    25.00
  0.26     0.26     0.26     0.12     0.08     0.08     0.08
  0.39     0.26     0.39     0.08     0.04     0.08     0.04
354.44   357.04   355.72   531.60   350.88   350.04   350.04
  5.04     8.44     8.80     9.08    12.72     6.04     9.04
 40.00    40.00    20.00    60.00


 25.00    25.00    25.00    25.00    25.00    25.00    25.00
  3.09     5.64     5.94     6.21     8.91     3.75     6.12
  3.87     3.63     4.17

  1.20     0.84     3.48     0.48     0.32     0.48     0.28
 22.80    25.20    32.28     8.44     8.84     7.84     9.52
 12.00                      12.00    20.00     4.00     4.00
 30.00    30.00    30.00     5.00     5.00     5.00     5.00
 20.00    10.00    15.00    15.00    15.00    20.00    10.00
 15.00    15.00    15.00    20.00    15.00    15.00    15.00

 20.00    20.00    20.00    20.00    20.00    20.00    20.00
 35.00    35.00    35.00    35.00    35.00    35.00    35.00
  4.00              4.00              8.00    28.00    12.00
 50.00    50.00    50.00    25.00    25.00    25.00    25.00
 30.00    30.00    40.00                      20.00    30.00
  6.00
                                                       13.00
 70.00    80.00    40.00             40.00    50.00    10.00

 21.00    39.00    12.00
150.00   150.00   150.00   150.00   150.00   150.00   150.00

120.00   150.00   150.00   150.00   150.00   150.00   170.00

 50.00    50.00    50.00    50.00    50.00    50.00    50.00

203.49   229.98   222.27   205.29   198.15   228.75   196.26
 90.80   126.00   146.10   103.70    98.40    88.40    94.80
                                                                     528.00

6,017.72   24,270.88   38,146.86   8,769.20   7,033.74   7,445.12   7,873.76
              r                r
er          be            be
           m            em
        ve                                 al         g.
     No             D ec               T ot         Av

            2,614.55               53,572.68    4,464.39
                                       70.00        5.83
                  91.00               832.00       69.33
                  25.00               300.00       25.00
                 100.00               975.00       81.25
                                       60.00        5.00
                  13.50               162.00       13.50
                                      680.00       56.67
                                        0.00        0.00
                                       10.00        0.83
                                   36,738.25    3,061.52

                                    1,686.05     140.50
                                    3,828.71     319.06
                                    5,131.50     427.63
                                      145.00      12.08
                                    8,149.59     679.13
                                      165.00      13.75
                                        0.00       0.00
                                    8,769.60     730.80
                                      683.00      56.92
                                    1,250.00     104.17

                                    1,857.00     154.75
                                        0.00       0.00
                                       37.60       3.13
                   9.60               125.60      10.47
                  65.60               687.20      57.27

                 769.37             7,526.26     627.19
                                       38.07       3.17
                  50.28               441.27      36.77
                                       21.54       1.80
                                      132.60      11.05
           13.68      1.14
           95.34      7.95
 34.08
466.38   4,862.70   405.23
             0.00     0.00
             0.00     0.00
             0.00     0.00
             0.00     0.00
             0.00     0.00
             6.00     0.50
217.00   3,073.00   256.08
             0.00     0.00
 30.00     360.00    30.00
300.00   3,600.00   300.00
             0.00     0.00
200.00   2,400.00   200.00
             0.00     0.00
 50.00     592.30    49.36
384.50   3,294.90   274.58
             0.00     0.00
110.00   1,180.00    98.33
            90.00     7.50
             0.00     0.00
             0.00     0.00
             0.00     0.00
             0.00     0.00
285.67   2,473.83   206.15
217.25   1,244.38   103.70
 25.00     300.00    25.00
 60.00     720.00    60.00
434.50   3,886.85   323.90
100.00   1,200.00   100.00
 75.00     900.00    75.00
 25.00     370.00    30.83
  0.12       2.43     0.20
  0.08       2.40     0.20
349.36   4,578.72   381.56
  5.32     100.60     8.38
 80.00     260.00    21.67
             0.00     0.00
             0.00     0.00
 25.00     300.00    25.00
  3.42     67.32      5.61

            0.00      0.00
  0.44     17.24      1.44
 11.16    227.00     18.92
          104.00      8.67
  5.00    235.00     19.58
 20.00    180.00     15.00
 15.00    190.00     15.83
           90.00      7.50
 20.00    240.00     20.00
 35.00    420.00     35.00
           64.00      5.33
 25.00    475.00     39.58
 20.00    360.00     30.00
  6.00     12.00      1.00
           13.00      1.08
 40.00    710.00     59.17
            0.00      0.00

150.00   1,440.00   120.00
            90.00     7.50
170.00
             0.00     0.00
 50.00     600.00    50.00
           450.00    37.50
287.22   2,576.43   214.70
109.20   1,256.40   104.70
             0.00     0.00
             0.00     0.00
             0.00     0.00
             0.00     0.00
             0.00     0.00
             0.00     0.00
             0.00     0.00
             0.00     0.00
             0.00     0.00
             0.00     0.00
             1.50     0.13
             0.00     0.00
             1.82     0.15
             0.00     0.00
                 0.20        0.02
               528.00       44.00
                14.00        1.17
8,180.60   182,508.85   15,209.07

								
To top