ࡱ> kj \p johnirvin Ba==Z.~8X@"1LArial1LArial1LArial1LArial1LArial1LArial1LArial1LArial1LArial1LArial1LArial1LArial1LArial1LArial1dLArial1LArial1.LTimes New Roman1"L Wingdings1&L Courier New1LArial"$"#,##0;\-"$"#,##0"$"#,##0;[Red]\-"$"#,##0"$"#,##0.00;\-"$"#,##0.00#"$"#,##0.00;[Red]\-"$"#,##0.005*0_-"$"* #,##0_-;\-"$"* #,##0_-;_-"$"* "-"_-;_-@_-,)'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=,8_-"$"* #,##0.00_-;\-"$"* #,##0.00_-;_-"$"* "-"??_-;_-@_-4+/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-0.0 "$"#,##0.00                + ) , *    $` "4`     " Header and Footer > Custom Header&  insert your name in the header: 6. Click  Move or Copy , tick  make a copy , then OK 7. Rename this new sheet (right click and follow prompts. A useful hint is to use the date format YYMMDD; it keeps everything orderly. _8. In Cell A3, insert a date indicator which reflects period since last GST/Cash Recovery  10. Hit Delete  yes Delete!  11. If all the totals have turned to  0.00 , then that is correct & you are now ready to begin with your Tax Invoices/ receipts on a clean slate! !12. Pick a Tax Invoice/receipt L16. The remaining cells will be automatically calculated, including totals :17. Repeat steps 12.-15. for other Tax Invoices/receipts,18. Save the file619. At the end of each month (or convenient period), 1. open the working file, O2. confirm the two internal checks are valid (i.e. 9.1% and Check Totals Box), 20. To create a new worksheet, open your working file, repeat steps 5.-11. and begin entering data for a new and exciting cycle of GST/Cash Recovery.  The  Sample Recovery.xls spreadsheet downloaded from the Ministry & Mission Website contains two worksheets identified by the tabs at the bottom left labeled  MASTER and  080113 Example .o 5. Right click on tab  080113 Example (-near bottom left); or after the first time, the most recent tab.  9. In the first 3 columns, highlight the cells with previously entered data (Cell A4  Woolies to C10  7.50 ) (Hint  to highlight, click on cell A4 and hold down left button while draggin<g to cell C10)D 13. In cell A4,enter the description of the purchase, eg  Woolies I14. In cell B4,enter the total cost recorded on the Tax Invoice/receipt @15. In cell C4,enter the total GST on the Tax Invoice/receipt L3. print the current worksheet & sign the substantiation statement (page 2) 4. submit page 2 only to Treasurer (page 1 is exclusively for your files - neither the Treasuerer, Committee or Auditor should have a copy).~ Updated 13 Jan 2008#GST Recovery Claim This is to certify that I have, and will retain, the Tax Invoices/Receipts to substantiate the above GST &/ Cash Recovery from the Minister's Benefit Account, and that I have not received cash from the Ministers Benefit Accountnenter this amount on BAS; and credit to Minister's Benefit Account/ ** Sign this page and present to Treasurer **b .c$   '-,-1bh5^9occr  R@AZCkzo  dMbP?_*+%>;&C&"Arial,Bold"&11GST Cash Recovery Claim [enter your name]&CPrepared &D&Rpage &P')\(?((\?)= ףp=?MvLexmark Optra S 1650@ XX⤗Lexmark Optra S 1650Lexmark Optra S 1650+Lexmark Optra S 1650f>.tBA>⤗X,X =⤗" dXX?{Gz?cU} I}  } m}  R    @                                           !  ""#$#%&'  (|@)X@*(\)@,*LL +,#@,*LLL-/袋."@ ,*LLLd.#@,* L /!,*LLLL  0ܯ@10w@2 Q34̌B@5.袋."@6̌B@7  0<@1i@2@344@5/袋."@64@7 0y@1h@2 Gz?34v@5/袋."@6v@7 0@1|@2 Q?34fffff&G@5/袋."@6fffff&G@7 0@1@2ףp= @349@5/袋."@69@7   0@1@ 2 @  3 4R@  5/袋."@  6R@  7  01 2  3 4  5.  6  7  01 2  3 4  5.  6  7  01 2  3 4  5.  6  7  01 2  3 4  5.  6  7 012345.67 012345.67 012345.67 012345.67 012345.67 012345.67 012345.67 012345.67 012345.67 012345.67 012345.67 012345.67 012345.67 012345.67 012345.67 012345.67 012345.67 012345.67 DlBz(i ! " # $ % & ' ( ) * + ,  - 0. 0/ 00 1  2 03 h@ 4  5  6 @7 8 9 : ; < ,@= > ,?  01 2  3 4  5.  6  7! !01!2!!3!4!!5.!!6!!7" "01"2""3"4""5.""6""7# #01#2##3#4##5.##6##7$ $01$2$$3$4$$5.$$6$$7% %01%2%%3%4%%5.%%6%%7& &01&2&&3&4&&5.&&6&&7' '01'2''3'4''5.''6''7( (01(2((3(4((5.((6((7) )01)2))3)4))5.))6))7* *01*2**3*4**5.**6**7+ +01+2++8+9++:.++;++<, ,=>,?,,@,,A.,,B,,C- -#-D{Gʄ@- %,#-G> ףpL@- %,#-EGzT>@- %,ͫ-F#-Gfffff @- %,-H#-Gfffff @- %,#-I0 %,.JKKKKLMK /NO /m/lnno 0P 00-0Q{Gʄ@1D-D-D-D- 1NPR 1 1-1S{Gʄ@:D-D-D-D-2TPPP2PUVP3 334PPP4PUV5 5Z56 6W6WXYXZ[Y7WWXYXZ[Y8 8\8\\\\\\\ 9W 99Y :W : :]:?>D Feb 2008 :[Y;WWXYXZ[Y< <W <^_ <Y <= >>> ףpL@BD->`Y?WWWabbcYDRl .__$0$,002hFC@ A B ,@C @D E F G H ;@I @J K L M @N @O @Pf@Q@@WWWabbcYAWWXYXZ[YB BrBd!B ףp=؃@$ D-D-Be B BC CCfgDEhisFttgssssGttgssssHWWXYYYYYI IXIYJYKYLYMNOkkk OjP PpPk PqPj Qkkk(To00": B k>@b CEBE1100IN3399::::55<><> 7gg,H  R?vBy  dMbP?_*+%>;&C&"Arial,Bold"&11GST Cash Recovery Claim [enter your name]&CPrepared &D&Rpage &P')\(?((\?)= ףp=?MvLexmark Optra S 1650@ XX⤗Lexmark Optra S 1650Lexmark Optra S 1650+Lexmark Optra S 1650f>.tBA>⤗X,X =⤗" dXX?{Gz?cU} I}  } m}  R    @                                           !  ""#$#%&'  (|@)X@*(\)@,*LL +,#@,*LLL-/袋."@ ,*LLLd.#@,* L /!,*LLLL  0ܯ@10w@2 Q34̌B@5.袋."@6̌B@7  0<@1i@2@344@5/袋."@64@7 0y@1h@2 Gz?34v@5/袋."@6v@7 0@1|@2 Q?34fffff&G@5/袋."@6fffff&G@7 0@1@2ףp= @349@5/袋."@69@7   0@1@ 2 @  3 4R@  5/袋."@  6R@  7  01 2  3 4  5.  6  7  01 2  3 4  5.  6  7  01 2  3 4  5.  6  7  01 2  3 4  5.  6  7 012345.67 012345.67 012345.67 012345.67 012345.67 012345.67 012345.67 012345.67 012345.67 012345.67 012345.67 012345.67 012345.67 012345.67 012345.67 012345.67 012345.67 012345.67 DlBz(i ! " # $ % & ' ( ) * + ,  - 0. 0/ 00 1  2 03 h@ 4  5  6 @7 8 9 : ; < ,@= > ,?  01 2  3 4  5.  6  7! !01!2!!3!4!!5.!!6!!7" "01"2""3"4""5.""6""7# #01#2##3#4##5.##6##7$ $01$2$$3$4$$5.$$6$$7% %01%2%%3%4%%5.%%6%%7& &01&2&&3&4&&5.&&6&&7' '01'2''3'4''5.''6''7( (01(2((3(4((5.((6((7) )01)2))3)4))5.))6))7* *01*2**3*4**5.**6**7+ +01+2++8+9++:.++;++<, ,=>,?,,@,,A.,,B,,C- -#-D{Gʄ@- %,#-G> ףpL@- %,#-EGzT>@- %,ͫ-F#-Gfffff @- %,-H#-Gfffff @- %,#-I0 %,.JKKKKLMK /NO /m/lnno 0P 00-0Q{Gʄ@1D-D-D-D- 1NPR 1 1-1S{Gʄ@:D-D-D-D-2TPPP2PUVP3 334PPP4PUV5 5Z56 6W6WXYXZ[Y7WWXYXZ[Y8 8\8\\\\\\\ 9W 99Y :W : :]: ?>D Feb 2008 :[Y;WWXYXZ[Y< <W <^_ <Y <= >>> ףpL@BD->`Y?WWWabbcYDRl .__$0$,002hFC@ A B ,@C @D E F G H ;@I @J K L M @N @O @Pf@Q@@WWWabbcYAWWXYXZ[YB BrBd!B ףp=؃@ D-D-Be B BC CCfgDEhisFttgssssGttgssssHWWXYYYYYI IXIYJYKYLYMNOkkk OjP PpPk PqPj Qkkk(To00":  k>@b 1100IN3399::::55<><>CEBE 7gg,H  :sG  dMbP?_*+%MvLexmark Optra S 1650@ XX⤗Lexmark Optra S 1650Lexmark Optra S 1650+Lexmark Optra S 1650f>.tBA>⤗X,X =⤗" dXX??U:  h h  ,  ,    ,      ,       , J ,      h   ! u  ~V v" w# v$ x% x& x' v( w) y* x+ w, w- v. zN z/ z0 x1 z2 z3 {4 |5 {6 z7 x8 x9xx : ; Dl*, * ! " # $ % & ' ( ) * + , - . / 0123456789 <  !w "x= #x> $x? %x@ &xO 'xA (xB )xC *xP +xD ,xE -xF .xQ /xR 0xS 1xG 2xH 3xI 4xJ 5}K 6}L 7}T 8}U 9xM8* >@*     7 Oh+'0HPdx  johnirvin johnirvinMicrosoft Excel@8X@fU@=ZX՜.+,0 PX|  Presbyterian Church Offices 080113 Example MASTER INSTRUCTIONS  Worksheets  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXY[\]^_`acdefghiRoot Entry FY