ࡱ> Root EntryRoot Entry F@RdFk@CompObjfWorkbookI]$MSDigSig(Author)$> \  !"#$%&'()*+,-./0123456789:;<=?@ABCDEFGHJKLMNOPQRSTUVWXYZ[SummaryInformation(hlDocumentSummaryInformation8՜.+,D՜.+, PXd lt| : Debtors' Schedule  Worksheets 8@ _PID_HLINKSAdmsbpz://-r:276DB148/ FMicrosoft Excel WorksheetBiOh+'08l X`| Debtors' ScheduleeMicrosoft CorporationMicrosoft CorporationMicrosoft Excel@ky@7)+@wG0k+ 5&" WMFC" * Jdf+ EMF J @    !" !" !  " !  g'%    &% 6% Ld!??% 6% Ld!??% 969% Ld999!??% J6J% LdJJJ!??% [6[% Ld[[[!??% l6l% Ldlll!??% }6}% Ld}}}!??% 6% Ld!??% 6% Ld!??% 6% Ld!??% 6g% Ldff!??% #6#% Ld###!??% 6% Ld!??% "6"% Ld"""!??% f6f% Ldfff!??'%  Ld!??'%  ( &% 6% Ld!??% 6% Ld!??%  ( &% 6% Ld!??% 6% Ld!??% % RLArialArial# WXw F\lP@$0 F\l|pd+%w0%    TT AA LP1re   ( &% 6% Ld!??   TT (7AA (LP2/@   %  6 % Ld   !??   TT :IAA :LP3ic   % :6:% Ld:::!??   TT KZAA KLP4ԟ   % K6K% LdKKK!??   TT \kAA \LP5   % \6\% Ld\\\!??   TT m|AA mLP6   % m6m% Ldmmm!??   TT ~AA ~LP7v   % ~6~% Ld~~~!??   TT AA LP8F0   % 6% Ld!??   TT AA LP9   % 6% Ld!??   TT"AAL#PA0    % 6% Ld!??   TT}AA}LPB    % $6$% Ld$$$!??   TTAALPC    % 6% Ld!??   TT@HAA@LPDer    % #6#% Ld###!??% % " !% %&" WMFC J   g'%    Ld#9 )!??'% (  Ld#f9#)!??'% (  Ld9#9 !??'% (  Ld#9f#9!??RL Tahoma Tahomadhۍ0WXw 8\@$0 8\ 0%    T3 +8AA3 LMicrosoft Business Planner       RL Verdana Verdanadhۍ0WXw 9\@$0 9\0%  T2MYAA2MLhGo to Article:   RL  Verdana Ref Verdana Refdhۍ0WXw ?\@$0 ?\3 0% T2^kAA2^LhCredit ControlRL  Verdana Verdanadhۍ0WXw ;\@$0 ;\ 0%   RL  Verdana VerdanaDhۍ0WXw 1\@$0 1\ D0% %  % % % % " !% %   $g%   T3AA3LpDebtors' Schedule      % %  % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % " !% %   $g% % % % % % % % % % % % %   T2fAA2cLThis template provides a form for monitoring debtors by the age of the debt. Enter the name of the     T2fAA2cLdebtor in the left-hand column and the amount of the debt in the appropriate column for the age of    T2fAA2GLthe debt. You can customize the form by adding extra rows if necessary.   T2fAA2bLTo add a row, select the row labelled "Other", click Insert on the Excel menu bar, and then click     T2fAA2gLRows. You will then need to use the fill handle (see Excel Help) to fill in the formula in the "Total"    T2fAA2cLcolumn. The cells displaying zeroes contain formulae to perform automatic calculations on the data     &. WMFC JTL2fAA2ULyou enter. Do not enter data into these cells as you will erase the formulae in them.    % % % " !% %   g% % " !% %   g' % (     ( &% % Ld!??% % Ld#!??% % Ld!??% % Ld"!??% % Ldf!??'%   ( &% #}6h}% Ld#}f}#}E!??% ( % " !%   g% " !%   g'%    ( &% 6g% Ldfg!??% 6% Ld!??% "   g  '' ' ,g-  -- @ !-- @ !-99- @ !9-JJ- @ !J-[[- @ ![-ll- @ !l-}}- @ !}-- @ !-- @ !-- @ !-g- @ !f-##- @ !#-- @ !-""- @ !"-ff- @ !f-  @ !- -- @ !-- @ !- -- @ !-- @ !--Arial-  2  1 -- @ !  2 ( 2 -  - @ !   2 : 3i -::- @ !:  2 K 4] -KK- @ !K  2 \ 5 -\\- @ !\  2 m 6 -mm- @ !m  2 ~ 7i -~~- @ !~  2 8] -- @ !  2 9 -- @ !  2 #A  -- @ !  2 }Bi  -$$- @ !$  2 C]  -- @ !  2 @D  -##- @ !#-"System-'-- ,g-   @ !) -    @ !)#-    @ ! 9-    @ !9# Tahoma-  .2 3Microsoft Business Planner        Verdana-  2 M2Go to Article:    Verdana Ref- 2 ^2Credit Control Verdana-    Verdana--  - - --'- -  ,g$-  !2 3Debtors' Schedule      - - --------------------------------------------------'--  ,g$------------- 2 2cThis template provides a form for monitoring debtors by the age of the debt. Enter the name of the     2 2cdebtor in the left-hand column and the amount of the debt in the appropriate column for the age of    r2 2Gthe debt. You can customize the form by adding extra rows if necessary.r   2 2bTo add a row, select the row labelled "Other", click Insert on the Excel menu bar, and then click     2 2gRows. You will then need to use the fill handle (see Excel Help) to fill in the formula in the "Total"    2 2ccolumn. The cells displaying zeroes contain formulae to perform automatic calculations on the data a    2 2Uyou enter. Do not enter data into these cells as you will erase the formulae in them.s    ---'--  ,g--'--  ,g-   -- @ !-- @ !#-- @ !-- @ !"-- @ !f-  -}#}h- @ !E}#- -'- ,g-'- ,g-   -g- @ !g-- @ !-'0 *H  010 *H 0g +7Y0W03 +70%7)O•0 0 *H w4_&O5ƺ%c?00)ъĽ5ǛSV0  *H 010U VeriSign Trust Network10U VeriSign, Inc.1,0*U #VeriSign Time Stamping Service Root1402U +NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.0 970512070000Z 991231070000Z010U VeriSign Trust Network10U VeriSign, Inc.1,0*U #VeriSign Time Stamping Service Root1402U +NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.00  *H 0. h|,-.  WSu3* [4 Z%}XsjxqX)X^-bXq"X/6MJ;"V~!lJGj6 -Ӵ90  *H :>{թy=q#+(ߌe,ZbVkbEƢ5"r-| CMlX 5ʉp*}a qfbB="2"d$006C!FXF%`0  *H 010U VeriSign Trust Network10U VeriSign, Inc.1,0*U #VeriSign Time Stamping Service Root1402U +NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.0 970512070000Z 991231070000Z01'0%U VeriSign Time Stamping Service10U VeriSign Trust Network1402U +NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.10U VeriSign, Inc.10UInternet00  *H 0aGܴ^i b1FI:?xZcEO n06- o' Q`5OTOз,B Ѝ^㖴"IBlӘV.:X"e匫xGBh[-}0  *H m`_i{p+b#D Q#tI'\q5+ൖ苧KsH ڋ %VNGWF8V!&;-%2Λ@GmGv0;~*1+ݰUApF-,~0 0 yfnжneq0  *H 0a10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CA0 980416000000Z 990416235959Z0]10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CA1F0DU =www.verisign.com/repository/CPS Incorp. by Ref.,LIAB.LTD(c)961>0<U 5Digital ID Class 3 - Microsoft Software Validation v21 0 UUS10U Washington10URedmond10UMicrosoft Corporation10U Microsoft Corporation0 0  *H  0&dm{AO o*q.S26h5IؖeS zpm̳*02X|k%gw #1D0@0u0a10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CAyfnжneq0 *H 0 *H  1  +70 +7 10  +70 *H  11x[cB7α "0r +7 1d0b" Debtors Schedule<:http://bookshelf.msn.com/z/msbp/teleport/fromCD/office.asp0  *H $fˆд \`q:n-x ʒ/ B~=0yo Omc} Y@YmPpC2ƀ_^(3#g,p)FzH>\ĿGa.'_Fȉv@ŦctU{ɽ1L[ikhײc1c\Z ٟ0%HT9k3((+>{0 *H  100010U VeriSign Trust Network10U VeriSign, Inc.1,0*U #VeriSign Time Stamping Service Root1402U +NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.C!FXF%`0 *H Y0 *H  1  *H 0 *H  1 981201010554Z0 *H  1>v:c=\0  *H m ca )}px&r-;NB-LnrZ۫δxɾԧPRYuT2Mֺ]EBTs&nnZA a3$W @`\pMicrosoft Corporation Ba==-j,8X@"1Arial1Arial1Arial1Arial1 Verdana1Verdana1 Tahoma1Tahoma1Tahoma1 Arial1@ Tahoma1Tahoma1@ Tahoma1Verdana1Verdana1Verdana1Verdana1& Verdana Ref1& Verdana Ref1& Verdana Ref1& Verdana Ref1&? Verdana Ref"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)"IR"#,##0;\-"IR"#,##0!"IR"#,##0;[Red]\-"IR"#,##0""IR"#,##0.00;\-"IR"#,##0.00'""IR"#,##0.00;[Red]\-"IR"#,##0.00;6_-"IR"* #,##0_-;\-"IR"* #,##0_-;_-"IR"* "-"_-;_-@_-,'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-C>_-"IR"* #,##0.00_-;\-"IR"* #,##0.00_-;_-"IR"* "-"??_-;_-@_-4/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00#""#,##0.00;[Red]\-""#,##0.0050_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-=8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_- "$"#,##0.00 "$"#,##0#,##0;\ \(#,##0\)#,##0_);\ \(#,##0\)                 %@@   7 % @ %@"@     D  $ 7 # ! ! ) )  % @   !7  7     @ %!`@  %   % 7 %!`@   % 7   % 7 7  %  a` a` a`    h@@  `@  ` @ %! @ a`7   %  %!(@  %   @  ` ap ap7  A    % 7  %! @  %1(  %1(   !7   H7 !  @ ! !  `  `7 X P  %(7 h `  `   !7 #  %  ) ) ) )  amount Body text header Header Total Header1 Header2 Header3 Header4NonPrint_copyrightNonPrint_HeadingNonPrint_HyperlinkNonPrint_TemTitle NonPrint_Text Normal 2 Product Title Text !Title`Debtors' Schedule  ; g 2 months Over (or less)3 months4 monthsTotal Company NameGo to Article:Credit ControlOtherThis template provides a form for monitoring debtors by the age of the debt. Enter the name of the debtor in the left-hand column and the amount of the debt in the appropriate column for the age of the debt. You can customize the form by adding extra rows if necessary. To add a row, select the row labelled "Other", click Insert on the Excel menu bar, and then click Rows. You will then need to use the fill handle (see Excel Help) to fill in the formula in the "Total" column. The cells displaying zeroes contain formulae to perform automatic calculations on the data you enter. Do not enter data into these cells as you will erase the formulae in them.Debtors' ScheduleMicrosoft Business PlannerNote: When you save this template as a workbook, note the workbook's file name and location. To edit the workbook next time, you must open it using Excel. Every time you open this template from Business Planner, a new workbook is created.M Colin Barrow 1998, Accounting: Financial Management for the Small Business,published by Kogan Page. _\ @ b#  dMbP?_*+% &LDate: &D&~?'~?(~?)~?MHP LaserJet 5Si/5Si MX7@ `@dXX7@XXEXCELDCourier New (X7\\proliant\pro_frontHP5SI" dXX `? `?U} I5} }  } I5  @ @       @  @ L L L                 ">??????"" M ??????""@AAAAAA"" BAAAAAA"" C AAAAAA""DDDDDDD""EEEEEEE"" P QQQQQQ"" R QQQQQQ" "FGGGGGG" " S QQQQQQ" KIJJJJJJK KIJJJJJ N K KIJJJJJ N K"-..../*"" 3 0###&*""67++71*" "6 7 ++ 7 1*" "6 + + + + 8 *"" 9 , , , , 8 *""O2222#: %? 4"")$$$$' -? 4"")$$$$' 4"")$$$$' 4"")$$$$' 4"")$$$$' 4"" H %%%%( 4" ";#< %#< %#< %#< %#= % 4"""""""""""""""""""@! D000000000HblK^CCCCW>@   7^yK yK *msbpz://-r:276DB148/ ff8Excel.Sheet.89q