Customer Entry Roll Balances Report sample

06/15/17 Wed 12:02  Co:  4   H & H Distributing   NxTrend Technology     arer        Oper: sld  Page:2

Accounts Receivable Roll Balances

Period Dates                     Rate
(1) 06/15/17   7/15/17
(2) 05/15/17   06/14/17         1.50    %
(3) 04/14/17   05/14/17         1.50    %
(4) 03/14/17   03/14/17         1.50    %
(5) Older      03/13/17         1.50    %

Minimum Balance to Service Charge: 10.00
Minimum Service Charge: 1.5
Journal #: 5456

06/15/17 Wed 12:02  Co: 4   H & H Distributing   NxTrend Technology     arer         Oper: sld  Page:3
Accounts Receivable Roll Balances

                                                                                         Service           End
Customer #     Name           Period  2   Period  3   Period 4   Period 5   Net to S/C   Charge      Post  Mth
101            Grandview Mfg     335.84        0.00       0.00       0.00    311573.61   1557.87 (c) yes   no
111            George’s Bikes      0.00        0.00       0.00      10.66        10.66      1.50     yes   no
151            Clarkspn Elect      0.00      268.39       0.00   81035.89     18184.28   1219.57     yes   no
201            Powell Brothers     0.00        0.00       0.00   18184.20     18184.28    272.75     yes   no
252            Dave’s Shop      3541.33     2747.88       0.00   90466.21     96755.42   1451.33     yes   no
301            Corporate One     156.00        0.00       0.00   13088.70     13244.70    198.67     yes   no
401            Briargate           0.00        0.00       0.00  142888.46    143888.46   2158.33     yes   no
501            USA Construc        0.00        0.00       0.00   25526.22     25526.22    382.89     yes   no
999            AP Supply, Inc.     0.00        0.00       0.00    3541.17      3541.17     53.12     yes   no
1975           DJM, Inc            0.00        0.00       0.00       9.50         9.50      1.50     yes   no
2000           Borson Mfg.       223.00      150.00       0.00     157.80       540.80     10.82 (c) yes   no
2004           Jake’s Plumb        0.00        0.00       0.00      10.00        10.00      1.50     yes   no

Customers w/ Serv. Charges:   12                     Total  # of Customers Rolled:     213
Total  # Service Charges:   12                       Total  # Service Charges Posted:     12
Total  Service Charges:   7309.86                    Total  Service Charges Posted:     7309.86

Service Charge Percent Exception – (S)tate,  (C)ustomer, or shipto/(J)ob