Aged debtor's report Example

RJLasap      Aged Debtors Report     Printed 31/05/16 19:59 By Ellie     Page : 1
Ageing Date 31/05/16  Summary Format
 A/C      NAME                             CURRENT    7 DAYS   14 DAYS   21 DAYS      TOTAL
--------  ------------------------------ --------- --------- --------- --------- ----------
ALB001    THE ALBION                       1029.48    802.02   1090.53   1892.55    4814.58
ANV001    THE ANVIL                           6.00      4.00      6.00     10.00      26.00
ASD001    ASDORIA STORES (SOUTHAMPTON)      578.76    546.60    698.40   1122.44    2946.20
ASD003    ASDORIA STORES (BASINGSTOKE)      465.26    428.36    494.96    911.57    2300.15
ASD004    ASDORIA STORES (FARNHAM)         2410.01   2101.51   2481.00   4582.51   11575.03
ASD005    ASDORIA STORES (EXETER)          2945.02   1983.15   2945.02   4928.18   12801.37
ASD006    ASDORIA STORES BOURNEMOUTH        630.69    445.96    669.27   1103.48    2849.40
BRI001    BRITANNIC SKYWAYS                   0.00   3965.32   8644.96  14728.46   27338.74
CHR001    CHRSALIS STUDIOS                    0.00    277.10    882.64   2497.06    3656.80
COU001    COUNTY ARMS                       444.72      0.00    480.06    480.06    1404.84
CRO001    THE CROWN AND ANCHOR              492.38      0.00    524.19    524.19    1540.76
DUM001    DUMAS FOODS                         0.00      1.10      3.30      6.60      11.00
ECL001    THE ECLIPSE                       606.54    164.26    641.88    806.14    2218.82
FUL001    FULLFLOOD ARMS                    565.96     16.80    602.37    617.49    1802.62
GEO001    ST GEORGES HOTEL                  543.45     44.39    578.79    618.74    1785.37
GRE001    THE GREEN MAN                     592.36    115.10    627.70    742.80    2077.96
GUI001    GUILDHALL TAVERN                 1070.61    120.78   1144.72   1247.20    3583.30
HCC001    JENNER LANE COMPREHENSIVE SCH      90.50   1040.54    596.75   2291.52    4019.31
HOS001    LYMINGTON HOSPITAL               1472.20   1132.74    770.78   1903.52    5279.24
HOS002    WINCHESTER GENERAL HOSPITAL       674.97   1132.74    719.23   1851.97    4378.91
HOS004    FARNHAM ROYAL INFIRMARY             0.00    696.67    555.40   2164.31    3416.38
HOS005    EXETER HOSPITAL                   643.18   1263.07    692.35   1955.42    4554.02
HYD001    THE HYDE TAVERN                   447.87      0.00    483.21    483.21    1414.29
JOL001    THE JOLLY FARMER                  826.07    145.53    876.56   1022.09    2870.25
MAS001    MASH TUN                          560.02    156.06    595.36    751.43    2062.87
MOA001    THE MOATHOUSE                     536.22     49.35    571.57    615.98    1773.12
MON001    CAFE MONDE                        792.28     81.73    848.05    929.78    2651.84
RAI001    RAILWAY INN                       602.29     41.30    641.56    682.85    1968.00
RIS001    THE RISING SUN                    356.25    447.42    372.85    820.27    1996.79
ROE001    ROEBUCK INN                       543.12     40.32    578.47    614.75    1776.66
ROY001    ROYAL HOTEL                       747.81      0.00    798.30    798.30    2344.41
SCH003    ROSEHILL PRIMARY SCHOOL             0.00     69.99    331.07   1494.08    1895.14
SCH004    ST AGATHAS CONVENT SCHOOL           0.00    259.96    686.01   2038.99    2984.96
SCH005    TOFFINS SCHOOL                      0.00    172.00    510.09   1775.11    2457.20
SCH006    NORTH DANESBRIDGE MIDDLE SCH        0.00    179.96    486.01   1758.99    2424.96
SCH007    SPARSHOLT PRIMARY                   0.00    277.96    722.01   2092.99    3092.96
SCH008    MICHELDEVER PRIMARY                 0.00    249.00    654.09   1996.11    2899.20
SLU001    THE SLUG AND LETTUCE              523.47      0.00    558.81    558.81    1641.09
SOU001    SOUTHGATE HOTEL                   747.81      0.00    798.30    798.30    2344.41
TES001    TESMART (SOUTHAMPTON)             444.40    706.56    477.67   1184.23    2812.86
TES002    TESMART (WINCHESTER)              444.40      1.44    477.67    478.68    1402.19
TES003    TESMART (BASINGSTOKE)             972.47    100.62   1049.08   1137.13    3259.30
TES004    TESMART (FARNHAM)                 631.75    423.00    767.45   1590.51    3412.71
TES005    TESMART (EXETER)                  972.47    152.11   1049.08   1201.18    3374.84
WES001    WESTGATE HOTEL                    747.81      1.00    798.30    799.20    2346.31
WES002    WESSEX HOTEL                      810.66     93.82    861.14    945.59    2711.21
WHI001    THE WHITE SWAN INN                523.47      0.00    558.81    558.81    1641.09
WIL001    THE WILLOW TREE                   579.22    111.51    614.56    726.07    2031.36
                                         --------- --------- --------- ---------   --------
                                          28071.95  20042.85  43016.38  74839.65  165970.82