l77OQ33       /  H          d 0 # gi( f$%&'(( PB)'*-qq;'CHECKS.wk1 - Check Registry v0.3 - 26Feb/23May05/JRA q' |*'Deposits, plus interest, less fees. q ' |+ 'Cols "F" and "L" contain IF formulas q q' |;q'Enter: Checks, Deposits, Cleared? y/n, Statement Bal q' |)'(Incl. any bank charge or credit.) q ' |) 'SUM'd to "Checks not cleared," and q' | ^Ck#'mm/dd/yyyy ^Payee ^Amount q q' |'mm/dd/yyyy ^Source ^Amount q  q ' |( '"Deposits not credited," (below). q' |-q'Check Registry:======================= qq"Cleared? q'y/n q q' |!q'Deposits:================= qq "Credited? q 'y/n q  q ' |,q 'Reconcile:=========================== q q q' |#q'Electronic accounts: =======     q" y ;3  q' | 'Opening Balance  q 'y" y ;3   q ' | ' Statement Balance  q' |#'(no paper records for these)     q"y ;3  q' |     q " y ;3   q ' | ' Checks not cleared P q' |      q"y ;3  q' |     q "  y ;3   q ' | ' Deposits not credited P q' |      q"y ;3  q' |     q " y ;3   q ' |"========= q' |      q" y ;3  q' |     q " y ;3   q ' | ' Trial Balance P q' |      q " y ;3  q ' |    q " y ;3  q ' | "--------- q ' |      q " y ;3  q ' |    q " y ;3  q ' | ' Check Registry Balance' PP  q ' |     q " y ;3  q ' |    q " y ;3  q ' | "--------- q ' |     q " y ;3  q ' |    q " y ;3  q ' | ' Variance (should be 0)   q ' |     q " y ;3  q ' |    q " y ;3  q ' |q \=q \=q "========== q ' |     q"y ;3  q' |     q " zy ;3   q ' | 'If Variance is not zero? q' |     q" y ;3  q' |     q " y ;3   q ' |& ' Look for a check or deposit q' |     q"y ;3  q' |     q "  y ;3   q ' |' 'incorrectly Cleared or Credited. q' |     q"y ;3  q' |     q " y ;3   q ' |     q"y ;3  q' |     q " y ;3   q ' |     q" y ;3  q' |     q " y ;3   q ' |     q"y ;3  q' |     q "  y ;3   q ' |     q"y ;3  q' |     q " y ;3   q ' |     q"y ;3  q' |     q " y ;3   q ' |     q" y ;3  q' |     q " y ;3   q ' |     q"y ;3  q' |     q "  y ;3   q ' |     q"y ;3  q' |     q " y ;3   q ' |     q"y ;3  q' |     q " y ;3   q ' |     q"zy ;3  q' |     q "  y ;3   q ' |     q"y ;3  q' |     q " y ;3   q ' |     q" y ;3  q' |     q " y ;3   q ' |     q"y ;3  q' |     q " y ;3   q ' |     q"y ;3  q' |     q "  y ;3   q ' |     q " y ;3  q ' |    q " y ;3  q ' | ! ! ! ! q!"! y ;3!  q!' | ! !  ! q !" !y ;3 !  q !' | " " " " q"""y ;3"  q"' | " "  " q "" "y ;3 "  q "' | # # # # q#"#y ;3#  q#' | # #  # q #" # y ;3 #  q #' | $ $ $ $ q$"$y ;3$  q$' |  $ q $" $y ;3 $  q $' | % % % % q%"% y ;3%  q%' |  % q %" %y ;3 %  q %' | & & & & q&"&y ;3&  q&' |  & q &" &y ;3 &  q &' | ' ' ' ' q'"'y ;3'  q'' |  ' q '" ' y ;3 '  q '' | ( ( ( ( q("(y ;3(  q(' |  ( q (" (y ;3 (  q (' | ) ) ) ) q)") y ;3)  q)' |  ) q )" )y ;3 )  q )' | * * * * q*"*y ;3*  q*' |  * q *" *y ;3 *  q *' | + + + + q+"+y ;3+  q+' |  + q +" + y ;3 +  q +' | , , , , q,",y ;3,  q,' |  , q ," ,y ;3 ,  q ,' | - - - - q-"-ߝ y ;3-  q-' |  - q -" -ߝy ;3 -  q -' | . . . . q.".ޝy ;3.  q.' |  . q ." .ޝy ;3 .  q .' | / / / / q/"/ޝy ;3/  q/' |  / q /" /ݝ y ;3 /  q /' | 0 0 0 0 q0"0z y ;30  q0' |  0 q 0" 0ݝy ;3 0  q 0' | 1 1 1 1 q1"1ݝy ;31  q1' |  1 q 1" 1ܝ y ;3 1  q 1' | 2 2 2 2 q2"2{y ;32  q2' |  2 q 2" 2ܝy ;3 2  q 2' | 3 3 3 3 q3"3{y ;33  q3' | 3 3  3 q 3" 3۝y ;3 3  q 3' | 4 4 4 4 q4"4{y ;34  q4' |  4 q 4" 4۝y ;3 4  q 4' | 5 5 5 5 q5"5|y ;35  q5' |  5 q 5" 5۝y ;3 5  q 5' | 6 6 6 6 q6"6| y ;36  q6' |  6 q 6" 6ڝ y ;3 6  q 6' | 7 7 7 7 q7"7}y ;37  q7' |  7 q 7" 7ڝy ;3 7  q 7' | 8 8 q8"8ڝy ;38  q8' |  8 q 8" 8ٝ y ;3 8  q 8' | 9 9 q9"9ٝy ;39  q9' |  9 q 9" 9؝y ;3 9  q 9' | : : q:":؝y ;3:  q:' |  : q :" :؝y ;3 :  q :' | ; ; q;";ם y ;3;  q;' |  ; q ;" ;םy ;3 ;  q ;' | < < q<"<םy ;3<  q<' |  < q <" <֝ y ;3 <  q <' | = = q="=֝y ;3=  q=' |  = q =" =՝y ;3 =  q =' | > > q>">՝y ;3>  q>' |  > q >" >՝y ;3 >  q >' | ? ? q?"?ԝ y ;3?  q?' |  ? q ?" ?ԝy ;3 ?  q ?' | @ @ q@"@ԝy ;3@  q@' |  @ q @" @ӝ y ;3 @  q @' | A A qA"Aӝy ;3A  qA' |  A q A" Aҝy ;3 A  q A' | B B qB"Bҝy ;3B  qB' |  B q B" Bҝy ;3 B  q B' | C C qC"Cѝ y ;3C  qC' |  C q C" Cѝy ;3 C  q C' | D D qD"Dѝy ;3D  qD' |  D q D" DН y ;3 D  q D' | E E qE"EНy ;3E  qE' |  E q E" Eϝy ;3 E  q E' | F F qF"Fϝy ;3F  qF' |  F q F" Fϝy ;3 F  q F' | G G qG"GΝ y ;3G  qG' |  G q G" GΝy ;3 G  q G' | H H qH"HΝy ;3H  qH' |  H q H" H͝ y ;3 H  q H' | I I qI"I͝y ;3I  qI' |  I q I" I̝y ;3 I  q I' | J J qJ"J̝y ;3J  qJ' |  J q J" J̝y ;3 J  q J' | K K qK"K˝ y ;3K  qK' |  K q K" K˝y ;3 K  q K' | L L qL"L˝y ;3L  qL' |  L q L" Lʝ y ;3 L  q L' | M M qM"Mʝy ;3M  qM' |  M q M" Mɝy ;3 M  q M' | N N qN"Nɝy ;3N  qN' |  N q N" Nɝy ;3 N  q N' | O O qO"Oȝ y ;3O  qO' |  O q O" Oȝy ;3 O  q O' | P qP"Pȝy ;3P  qP' |  P q P" Pǝ y ;3 P  q P' | Q qQ"Qǝy ;3Q  qQ' |  Q q Q" QƝy ;3 Q  q Q' | R"RƝy ;3R  qR' |  R q R" RƝy ;3 R  q R' | S"Sŝ y ;3S  qS' |  S q S" Sŝy ;3 S  q S' | T"Tŝy ;3T  qT' |  T q T" Tĝ y ;3 T  q T' | U"Uĝy ;3U  qU' |  U q U" UÝy ;3 U  q U' | V"VÝy ;3V  qV' |  V q V" VÝy ;3 V  q V' | W"W y ;3W  qW' |  W q W" Wy ;3 W  q W' | X"Xy ;3X  qX' |  X q X" X y ;3 X  q X' | Y"Yy ;3Y  qY' |  Y q Y" Yy ;3 Y  q Y' | Z"Zy ;3Z  qZ' |  Z q Z" Zy ;3 Z  q Z' | ["[ y ;3[  q[' |  [ q [" [y ;3 [  q [' | \"\y ;3\  q\' |  \ q \" \ y ;3 \  q \' | ]"]y ;3]  q]' |  ] q ]" ]y ;3 ]  q ]' | ^"^y ;3^  q^' |  ^ q ^" ^y ;3 ^  q ^' | _"_ y ;3_  q_' |  _ q _" _y ;3 _  q _' | `"`y ;3`  q`' |  ` q `" ` y ;3 `  q `' | a"ay ;3a  qa' |  a q a" ay ;3 a  q a' | b"by ;3b  qb' |  b q b" by ;3 b  q b' | c"c y ;3c  qc' |  c q c" cy ;3 c  q c' | d"dy ;3d  qd' |  d q d" d y ;3 d  q d' | e"ey ;3e  qe' |  e q e" ey ;3 e  q e' | f"fy ;3f  qf' |  f q f" fy ;3 f  q f' | g"g y ;3g  qg' |  g q g" gy ;3 g  q g' | h"hy ;3h  qh' |  h q h" h y ;3 h  q h' | i"iy ;3i  qi' |  i q i" iy ;3 i  q i' | j"jy ;3j  qj' |  j q j" jy ;3 j  q j' | k"k y ;3k  qk' |  k q k" ky ;3 k  q k' | l"ly ;3l  ql' |  l q l" l y ;3 l  q l' | m"my ;3m  qm' |  m q m" my ;3 m  q m' | n"ny ;3n  qn' |  n q n" ny ;3 n  q n' | o"o y ;3o  qo' |  o q o" oy ;3 o  q o' | p"py ;3p  qp' |  p q p" p y ;3 p  q p' | q"qy ;3q  qq' |  q q q" qy ;3 q  q q' | r"ry ;3r  qr' |  r q r" ry ;3 r  q r' | s"s y ;3s  qs' |  s q s" sy ;3 s  q s' | t"ty ;3t  qt' |  t q t" t y ;3 t  q t' | u"uy ;3u  qu' |  u q u" uy ;3 u  q u' | v"vy ;3v  qv' |  v q v" vy ;3 v  q v' | w"w y ;3w  qw' |  w q w" wy ;3 w  q w' | x"xy ;3x  qx' |  x q x" x y ;3 x  q x' | y"yy ;3y  qy' |  y q y" yy ;3 y  q y' | z"zy ;3z  qz' |  z q z" zy ;3 z  q z' | {"{ y ;3{  q{' |  { q {" {y ;3 {  q {' | |"|y ;3|  q|' |  | q |" | y ;3 |  q |' | }"}y ;3}  q}' |  } q }" }y ;3 }  q }' | ~"~y ;3~  q~' |  ~ q ~" ~y ;3 ~  q ~' | " y ;3  q' |   q " y ;3   q ' | "y ;3  q' |  q " y ;3  q ' | "y ;3  q' |  q " y ;3  q ' | "y ;3  q' |  q " y ;3  q ' | " y ;3  q' |  q " y ;3  q ' | "y ;3  q' |  q " y ;3  q ' | "y ;3  q' |  q " y ;3  q ' | "y ;3  q' |  q " y ;3  q ' | " y ;3  q' |  q " y ;3  q ' | "y ;3  q' |  q " y ;3  q ' | "y ;3  q' |  q " y ;3  q ' | "y ;3  q' |  q " y ;3  q ' | " y ;3  q' |  q " y ;3  q ' | "y ;3  q' |  q " y ;3  q ' | "y ;3  q' |  q " y ;3  q ' | "y ;3  q' |  q " y ;3  q ' | " y ;3  q' |  q " y ;3  q ' | "y ;3  q' |  q " y ;3  q ' | "y ;3  q' |  q " y ;3  q ' | "y ;3  q' |  q " y ;3  q ' | " y ;3  q' |  q " y ;3  q ' | "y ;3  q' |  q " y ;3  q ' | "y ;3  q' |  q " y ;3  q ' | "y ;3  q' |  q " y ;3  q ' | " y ;3  q' |  q " y ;3  q ' | "y ;3  q' |  q " y ;3  q ' | "y ;3  q' |  q " y ;3  q ' | "y ;3  q' |  q " y ;3  q ' | " y ;3  q' |  q " y ;3  q ' | "y ;3  q' |  q " y ;3  q ' | "y ;3  q' |  q " y ;3  q ' | "y ;3  q' |  q " y ;3  q ' | " y ;3  q' |  q " y ;3  q ' | "y ;3  q' |  q " y ;3  q ' | "y ;3  q' |  q " y ;3  q ' | "y ;3  q' |  q " y ;3  q ' | " y ;3  q' |  q " y ;3  q ' | "y ;3  q' |  q " y ;3  q ' | "y ;3  q' |  q " y ;3  q ' | "y ;3  q' |  q " y ;3  q ' | " y ;3  q' |  q " y ;3  q ' | "y ;3  q' |  q " y ;3  q ' | "y ;3  q' |  q " y ;3  q ' | "y ;3  q' |  q " y ;3  q ' | " y ;3  q' |  q " y ;3  q ' | "y ;3  q' |  q " y ;3  q ' | "y ;3  q' |  q " y ;3  q ' | "y ;3  q' |  q " y ;3  q ' | " y ;3  q' |  q " y ;3  q ' | "y ;3  q' |  q "  y ;3  q ' | "y ;3  q' |  q " ~y ;3  q ' | "~y ;3  q' |  q " ~y ;3  q ' | "} y ;3  q' |  q " }y ;3  q ' |A'If you write more checks than the registry can accomodate:D'Cells can be added by copying formulas down. Adjust the rangeC'of Reconciliation cells (P6, P7, P11) for Checks not clearedA'and Deposits not credited to include the additional cells..'Check numbers are entered by Data, Fill