ࡱ>  vdShowOnOpenorShowUpdateOnOpen$#Dateslue@! hempPageBreakspenShowUpdateOnOpen -./0 Microsoft Forms 2.0 FormEmbedded Object9qJKLMNOPVERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} UpdateReports Caption = "Update" ClientHeight = 3090 ClientLeft = 45 ClientTop = 330 ClientWidth = 6720 StartUpPosition = 1 'CenterOwner TypeInfoVer = 82 End w(H  @}(6R KQDBTahoma$;4MyOK,(OK quTahomaueDFF0Show when opening Workbook5Tahoma @H,1.025Tahoma(Use this workbook to create ' \pIntuit Ba=  ThisWorkbook=GN xK28@"1Arial1Arial1Arial1Arial1Arial1Arial1h>Cambria1,>Calibri1>Calibri1>Calibri1Calibri1Calibri1<Calibri1Calibri1>Calibri1?Calibri15Calibri15Calibri1 Calibri1 Calibri1Arial1 Calibri1Calibri1Tahoma1$Arial1 Arial1Tahoma1Tahoma15Tahoma1Tahoma1Tahoma"$"#,##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\);_(* "-"??_);_(@_)#,##0.00;\-#,##0.00#,##0.00###;\-#,##0.00####,##0.0#%;\-#,##0.0#%m/dmmm 0.000% 0.0000%0.00%;\-0.00%;\-0.0000%;\-0.0000%;\-0.0000%;0.0000%;\-#,##0.00###;\-#,\-#,##0.00;\-#,##0.00;\- #,##0.00000.000%;0.000%;\- ###,0?? #,##0.???? #,##0.00???m/d/yy\ h:mm\ AM/PM #,##0.### #,##0.0###,##0.0#;\-#,\- mm/dd/yy #,##0.00## #,##0.00#$[$-409]dddd\,\ mmmm\ dd\,\ yyyy[$-409]h:mm:ss\ AM/PM#,##0;\-#,##0;\-"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\) 0.#% #,##0.00.0000000000000 0.00000 0.000000000000.000000000000#,##0.000;\-#,##0.000#,##0.00;\-;\-#,##0.00#0.0                 6   ,           *   6          , 4        ff+ ) , *  8 8 8   * P  P        `          a6            )   )          Accent1 Accent1 - 20% Accent1 - 40% Accent1 - 60% Accent2 Accent2 - 20% Accent2 - 40% Accent2 - 60% Accent3 Accent3 - 20% Accent3 - 40% Accent3 - 60% Accent4 Accent4 - 20% Accent4 - 40% Accent4 - 60% Accent5! Accent5 - 20%" Accent5 - 40%# Accent5 - 60% $Accent6% Accent6 - 20%& Accent6 - 40%' Accent6 - 60%(Bad) Calculation* Check Cell+,-./ Emphasis 10 Emphasis 21 Emphasis 32  3Good4 Heading 15 Heading 26 Heading 37 Heading 48 9Input: Linked Cell ;Neutral <Note =Output>? Sheet Title @TotalA Warning Text`tvWelcomePlease Turn on MacrosJTime Off1 Detail DataUSupporting SettingsTempData1QB Payroll Link for Accountants 193e working.xlsPlease Turn on MacrosDetailRegister Exp Summary Exp Charts YTD Summary Comparison Tax BalancesScratchWelcomeSupporting SettingsData DataPriorYearDataComparisonEE_DataTempDataYYYYYYYYYY Y Y Y Y YY array# ClipFirstName:" ClipLastName:ClipMI:%ConsolidateData:!'ConvertNamesUpper:'DateRangeSelected:&DrillDownSupport:" EECustomData:"6!eeList#TimGeorgeWalter"EndDate:! FilterDates:# FirstUsedDate:$GetDataEndTime: &GetDataStartTime:" HideActivity: HideData: ! LastEndDate:# LastStartDate:&LastUpdateFromQB:! MinimumWage: # OnErrorResume: )QBCurrentFiscalYear:&QBCurrentTaxYear:! QBFederalID:%QBLegalAddress1:%QBLegalAddress2:! QBLegalCity:(QBLegalCompanyName:" QBLegalState:  QBLegalZip: *QBRegistrationNumber: QBSKU: 2 QuickBooksComparisonData=E( QuickBooksData; )ShowFinishedMessage:(ShowNewUserMessage:&ShowUpdateOnOpen: StartDate:! ToolBarLeft:%ToolBarRowIndex:#  ToolBarTop:! ToolBarView:.UpdateReportColumnWidths: ! UseQBCoInfo:$Version_Number:" 5.Le^ ?S-b"1S[p#4zdn"1S[p#4zdPNG  IHDR+!] sRGB pHYs[Y(&IDATx^]-xLUkdd"y8pI]qDF׸/2u}3@=s'lvfgf6ۍiql#apq`0_Ł0DsYxƁ9`0 u^$7eƁ9`0IVz.80_٧s9`0^ O8In2g80s9s=J5>%Xȟ#0#=$J`OF`Fd<*Oz\fs98@ɳZ =eq`sp gWFvT[yvOtY?svKRoz=ij?^[|Q9w.L IƁq`|拥8|\a*>E+geZ1,={\x:<;rr=[˔80?LOK]' SZב%LGퟓ{wUnkJ &. FQ,v;M:L=`0~f _@d~֝siP=gF-W_2',fWldr:Ite{ .$r'80́s@@4tܑ˒߈CFh> |r|%=!gOSfezZV~5 R\8 80ˁtb'}~?UZ.gYA!|:lWqj(WE\;=Vէ^鳫>,80́@WS+bKldW]8;=}" r/,!kE,gyև>;mцx]\ؽףZ-|8mA{ڇv/:)ncrU}VQջ"䋤rZE|nO+wy$앥lϰr“Ϝ\ <7sx_]?ih<&Gy\Lp|Σ3txIʥ7ZׯK0ķkxx^bl mxqi]:y7w[AOo,6e.st=>Bpi;YlXpTG:t] Z{[b{uB{Ɵ8s*pBO!gն "Ѱt;GOcwFCơaIF>I gyw:dq8Η ݉~: ?Ϭ}4f.`NX֣lt>7%^|_1E(wso}Og(T'"~%iyد`+̷)sAzp C7* ) e^Ch}Eupfۗ_pP;hNc©: h͟CzB&ha OQܨ,JO| ->iA)~a5_yQ L:7vI<Otu֚bxF}7 YO7벬Zve*#gq4E0me,q02`*Ⱦ?AfHhG+Yl'Krl` @{3mTEh^ ΕT$E58Np'=T\IAwG&H&ԙ)R3/]v:L1>oZ]kx/bv!\ʶ`Q Ms&MX*h4lwNmړ"exܢYy-75DkVN yjPn0_- Gx ʍcCfz먨{uߠuG8'.揌^_\a s0vnqo፳%6javc/ΰ doMv6b޷_ICnd{œvi_%H(j۩`I3sԹeca8mSO^-\srD3LPOkhj{Wu1Ngq, s:hC;c[,ZLcRgu`F/d*w~AfUs(c$R;"۔ZA;p2v=^/{9>zfq㜎sm}W1C,w]։)9qQ nJTS/ WI>yt{ISpxUq;Ekq2t{>zvy[V>=,؇%0_JfQSlG=Ӱ%_1᫷ I?reںУMY˫(l^*خõnV[5ol;a*1w$3p t`jw+meh٦6Kӱ[> W8eDA▖0X3g4i?b61B̸c=GJZ;,kNٷ!mveq#}"2@q 9^K=\yį8ZRL* V#}d%|A@'M6څoP/G&6T3l08[]b]ɲ®>M);jXá\;5-=|{W [f%6̲=*c^D2H |:$8Uҿ )=옳qnKEq#Cv~%q I:FΨiP2`\`[VskdS0i/9$"#&M0^pNCrΙ=Qs<5om0IP71@rLXa̢QE'3D+4'/Xu1pW3uYD$2Ƅ40~jN|c~0\7ϳī]h{F kiK{O ^YFoj#Q^ {G02 ̵^ w}+4 R>dnX> duxN Ǯ'd<6z3Xb"ʷvv8p<>:(Yel!X2ig2to6.wOFf{{1pJ ׺Us#H_? S]/>t^>>μ7'${sq ېg3xRlbHʎlW$'O>s|_r*{\͎ăDS{xR:f{c$kwf:q1u_vtYڋ|vZ_]4j9Z}l˵<.{ψnji({u\M&6gSf[K c{1>$\=:gv=Lpܟ_l7~W,TorwIX_y[>d vT:@4x7ĩ׬R{ya_'*3:.7^BqW}XcL~{ۂ/b_hIl |1'Kס .7덭$Y`aUCzG5+h]NeYwN$ ZO3]cesCeՎև&uSr\Vp!GIҡ=Y{:gOٸERδ$Y?y=ΠUhܘ[ P$^'8F(!Jg4*FB֍l-#Wff+։>99qV v7!K>s5IM>͍B~&:O!Oee+.њM~d,n4'Y0"…cXc7&S<=n=L"[ꖖ5q*߁g^IK;8քuP8o5́4]y+DPG͍ WNv}h8,s0_p:2z,#'Xg#IYw^j'zԽ7Mp_8DǺ!|sa|ZDZeZoY?u1+^y&Sz@:303p.}DZ9""FO0_-׼{xuu\Ć?sopRQi㖟 &=l+gÖ1-"-Vgk=&<nÑ[C8:>iڇm)gG?ScDfojA*ÙڃP"Pr?Wl.oKۍ́pיxUөyI<8xt`UZX7Q#v<6FVtȝLfFp e5 jZ1`^Y\'heM7?w0pP]Y.s*hs|͜]P$ˌq@C]~u |>g9R(,ɟ_3#zb}_w?é1j9`|-q0^Udӱ+'^1^zeΞwʌ#4K\3 }cg{+ߩ{]U*ትXƧ?'9y.ˌs9c8 j陑r=jp5g"S%W^Sk٫_w'{?͛a}F`,7s]ZN/L eNq`s9ߍ޼~g֥$D[tN|!80wp ٫ =HQuT,|c˜09iW9{.˳ `0гc{gS3r~.?z1ѿqF DM1c98@s_`cs9&ȳgxs9`%zdF` ig$IENDB`b 9zw`Ub nZ 9zw`UPNG  IHDR)(^DsRGB pHYs+ IDATXGX{\Wy?kO!N (* )UҺ*5E*DKD(P&(3׏3;3w{=~gg4G~s޻w=Ǐvj7zV4y6D]]YXzڟ{Moފ5,FX(Fg؀^ޟ:PP5 _mm숉w0wo.ɞQKHaQ{dܵil`{m;;l;vzsߎ'oflV~\12m*mvB!hT4lO.w2-[Q]AsNߎW*_߿/~!#_ =:#'%Va (;}Lmk!0xPW_]jZ7-Q@;wsxQi=c @mO邆BX߃\-'3evժP Oق7O=7q ֧"~UG(qq/$ʐVponzѼ.jiԔ=F gt ~˿4CoՂl0RPWRrƎ§F.wiKr"Er)#P<^MMd3؎7h! BU!PF AƽE*kţ?8(Ibv(hT CF<&jY"7RJT(6qqғPks Zp!ᤓp͕86GB#/=&?Vau2 J EݬG܍0>occG@.f.R51%oPf6k^0s~{Y/f>~]g|4^~㇒3]I0i#ݯ-v(Kʺ-y{s.\ 7_Q14ae5w#^[k+QgܱBSu#*;u/?kq~|i dzʭ%KpPo_?벞?oʛW#CǶl[ "1(`PHa0eVא WC8x+@>a(H(psz䁇美0hB >,Yrh(QH\-^ɕX&訮b#S!caBpFjǧ y[>7cą %-3w(E\Rc3AUEYK$t=8=Y8.~mx| M \7[dFRd \!g6dSapgs 0 WQi Ve+Q,B_Ȥ3E}ݧcL 0Qh z8E$tD#PTs%v+dw]`LP$%.ֲĶh?I{cTa...Q心 v5uz*aƦ=5%1Ab1;p29'3;S!AΈ];98Pt"* \>`p=>ӈ7N9XǍTFOtQMxVS=8$%JXc8_?A2n+вC*e*"7N5(.B05dcq-[21X # %0Ykt I֑4{Jn18')DA\S`_-ڳ55h|lb!PBab ^L驽tL1U7# 2[7믺!/+LQۍlu$rh=R?Y̒󆇳/˩d07TeY)n1JCq/ڋ\9;L4i랬KgźTUckZ?ZRDyX.|  EOú6N'B7HNXԯ+W3b% )2U&5*U/V?7K}LEe@.,}՝2"jjw::k^e"IENDB`3  @@  ~ GG DateRangeVersion NumberQBCurrentFiscalYear StartDateQBCurrentTaxYearEndDate QBFederalID LastStartDateQBLegalCompanyName LastEndDateQBLegalAddress1ShowNewUserMessageQBLegalAddress2ShowFinishedMessage QBLegalCityShowUpdateOnOpen QBLegalState OnErrorResume QBLegalZip HideActivityQBRegistrationNumberHideDataDateRangeSelected ToolBarView ToolBarTop ToolBarLeftConvertNamesUpper ClipFirstNameClipMI ClipLastNameLastUpdateFromQB FirstUsedDate UseQBCoInfoDrillDownSupportGetDataStartTimeGetDataEndTimeConsolidateData EECustomDataToolBarRowIndexCustom1Custom2Custom3Custom4BThese are the user titles for EE custom settings. Don't move them:UpdateReportColumnWidths MinimumWageQBSKUConfirm security level Enable macros5 to always trust the macros used in this workbook.Before QuickBooks can generate these payroll reports, you must enable macros in Microsoft Excel. To do so, use one of the following procedures to make sure your macro security settings are set properly, and then close and re-open the workbook.bExcel 2000, 2002, and 2003;1. Go to the Tools menu, click Macro, then click Security.  $19:#2. If the security level is set to:o  " Very High: Click another option (any option but Very High) and then click OK to save the new settings.CDSU`  " High, Medium, or Low: Leave the option selected and then click OK to close the window. GJ3. Close this workbook. 1. Re-open the QuickBooks Payroll Reports Workbook. If you selected any setting except Low, you ll be prompted to enable macros. 2. Click Enable Macros. h3. Depending on your Excel version and security settings, click Always trust macros from this publisher @ Excel 2007 X1. Click the Office button located at the top-left corner of the Microsoft Excel window:>2. Click the Excel Options button at the bottom of the window: 03. Click Trust Center from the list on the left. *4. Click the Trust Center Settings button. #N5. In the Trust Center window, click Macro Settings from the list on the left.%3X6. Select either Disable all macros except digitally signed macros or Enable all macros.BFWI7. Click OK to save the settings and then click OK in the message window.  02%8. Close and Re-launch this workbook. Never This YearJM M'NN OOOPA TV ccj||=h}-}= 00\);_(*}A}3 00\);_(*;_(@_) }A}4 00\);_(*?;_(@_) }A}5 00\);_(*23;_(@_) }-}6 00\);_(*}U}2 a00\);_(*;_(@_)  }U}( 00\);_(*;_(@_)  }U}9 e00\);_(*;_(@_)  }U}/ 00\);_(*;_(@_)  }U}0 00\);_(*;_(@_)  }U}1 00\);_(*;_(@_)  }}7 ??v00\);_(*̙;_(@_) ̙    }}; ???00\);_(*;_(@_)  ??? ??? ??? ???}}) }00\);_(*;_(@_)     }A}8 }00\);_(*;_(@_) }}* 00\);_(*;_(@_)  ??? ??? ??? ???}-}? 00\);_(*}}:00\);_(*;_( ??? ??? ???}U}> 00\);_(*;_( }U} 00\);_(*;_( }U} 00\);_(*ef;_(ef }U} 00\);_(*L;_(L }U} 00\);_(*23;_(23 }U} 00\);_(*;_( }U} 00\);_(*ef;_(ef }U} 00\);_(*L;_(L }U} 00\);_(*23;_(23 }U} 00\);_(*;_( }U} 00\);_(*ef;_(ef }U} 00\);_(*L;_(L }U} 00\);_(*23;_(23 }U} 00\);_(*;_( }U} 00\);_(*ef;_(ef }U} 00\);_(*L;_(L }U} 00\);_(*23;_(23 }U}  00\);_(*;_( }U}! 00\);_(*ef;_(ef }U}" 00\);_(*L;_(L }U}# 00\);_(*23;_(23 }U}$ 00\);_(* ;_( }U}% 00\);_(*ef ;_(ef }U}& 00\);_(*L ;_(L }U}' 00\);_(*23 ;_(23 XTableStyleMedium9PivotStyleLight16 PK![Content_Types].xmlj0Eжr(΢Iw},-j4 wP-t#bΙ{UTU^hd}㨫)*1P' ^W0)T9<l#$yi};~@(Hu* Dנz/0ǰ $ X3aZ,D0j~3߶b~i>3\`?/[G\!-Rk.sԻ..a濭?PK!֧6 _rels/.relsj0 }Q%v/C/}(h"O = C?hv=Ʌ%[xp{۵_Pѣ<1H0ORBdJE4b$q_6LR7`0̞O,En7Lib/SeеPK!TGtheme/theme/themeManager.xml A 0@ѽDд;wC3dRP=Y~qv.5dp4(% 8AF(fa aL[9</R YX[ b]RKֳxt"^PK!wtheme/theme/theme1.xmlYOo7/߁֒'d)i7葚0S"=.Ph{âmKӤb +hTA- s8?㏏o^ ]F+B"<DN'؋Ҙ' Nћw~@ suQuyb QR! Qf;ė `;VS`#qr) ѝZ#tL$ay BD "Д)Ν;0Z(Rd{ݿugLh^ʳ0ڗٝ쵇LG^=5ao Zn Ѩ-kɭ~7[P(?_Co2/!`{kU "\oʤ?rdXS$)!GGI|@ujB*ԃCxg_Ϟ>'|ϟ|da~֌W>/Ϳ>ijݟ3>QrNEs -'3FLsLj 1[!Rjz$GQ {FycR琢? 17%AgwiJf.M,.(1Ff( #C؟Ľxxe _?9?!; poMy[],) \lbcR 6df= ̡Y|$c=Pl##$SLRAԲݍ  v=sxp|>c3kE#`[e[P(kֶY - 1\t. ܇Q Hb6:,6 3D* qZki 6N%CyjaֶM@7 Sheet1ggDT '  )  dMbP?_*+%M \\mtvps01\MTVPR375CP  ߁ odXLetterCanon   Canon iR C4080/C4580 PCL6anddd      d d d d d dd@@d  d  d dd d"edd !'  ddd      !"#$%&'()*-./01234567d!!d     d !"#$%&'()*+,-dA     Ad      d8o @*/ o @*/ aXXdd Arial\CNZSRGBA.ICC\CNZSRGBA.ICC\CNZSRGBA.ICC CONFIDENTIALCONFIDENTIALHArialDefaultSettingsH@"dXX??U} IY} m@@@     @@E F2 G3 F/ F4 F5 F6 F7 F8 F F0 F9 F: F; H1 G< F=H I> F? F@ FA FB JC JD6F   @z(  @R @ C A?]&`7xp @ 6A@AA?]]&7 xp @ 6A@AA?[-]&7 >@7 Sheet17 '  /  dMbP?_*+%74&C&"Arial,Bold"&13Employee Time off Accrued and Used&ffffff?'ffffff?(?)?M \\mtvps01\MTVPR375CP  ߁ odXLetterCanon   Canon iR C4080/C4580 PCL6anddd      d d d d d dd@@d  d  d dd d"edd !'  ddd      !"#$%&'()*-./01234567d!!d     d !"#$%&'()*+,-dA     Ad      d8o @*/ o @*/ aXXdd Arial\CNZSRGBA.ICC\CNZSRGBA.ICC\CNZSRGBA.ICC CONFIDENTIALCONFIDENTIALHArialDefaultSettingsH@"dXX??U} $ C} $ M}  C}  C} } m} m }  } } } $   (  R  C ]F!x7 d ZR  C ]F!ؘ7 d P>@<K7 Sheet41ggDT '    dMbP?_*+%74&C&"Arial,Bold"&13Employee Time off Accrued and UsedM \\mtvps01\MTVPR375CP  ߁ odXLetterCanon   Canon iR C4080/C4580 PCL6anddd      d d d d d dd@@d  d  d dd d"edd !'  ddd      !"#$%&'()*-./01234567d!!d     d !"#$%&'()*+,-dA     Ad      d8o @*/ o @*/ aXXdd Arial\CNZSRGBA.ICC\CNZSRGBA.ICC\CNZSRGBA.ICC CONFIDENTIALCONFIDENTIALHArialDefaultSettingsH@"dXX??U} L} $ L} mL} $ L} $ L} I L} m L}  L} m L} L} IL} $L} K} $K} $K} $K} K} mL}  L} $ L} IL}  L} L} K}  K} I K} mL} ! L} "+ L} ,$ LTax Tracking Type?tHt ,PH0D0(  DP>@A @7 Sheet12ggDT '  (*  dMbP?_*+%74&C&"Arial,Bold"&13Employee Time off Accrued and Used(Q?)?M \\mtvps01\MTVPR375CP  ߁ odXLetterCanon   Canon iR C4080/C4580 PCL6anddd      d d d d d dd@@d  d  d dd d"edd !'  ddd      !"#$%&'()*-./01234567d!!d     d !"#$%&'()*+,-dA     Ad      d8o @*/ o @*/ aXXdd Arial\CNZSRGBA.ICC\CNZSRGBA.ICC\CNZSRGBA.ICC CONFIDENTIALCONFIDENTIALHArialDefaultSettingsH@"dXX??U} $} }  } } (@@      SVD=C@ DD-MMM-YYYYA0 to C@ DD-MMM-YYYYA001-Jan-2008 to 31-Dec-2008 ~ Y@ BC ~ CC@ BC ~ Cp@ B ~ CC@ B  ~ Cp@ B   B   B  B B  B B  B B  . ,  -~ @  F ~ ? ~ i@ ~   ~ 9@ ~ @ ~ 9@  DE D   ! "DS5`@:44***(((((( !"#&' # Ds5`@ !$! "%" #&~ #I@ &+ '' '( ') '*.d P>4@7 Sheet2ggDT" '  =  dMbP?_*+%M \\mtvps01\MTVPR375CP  ߁ odXLetterCanon   Canon iR C4080/C4580 PCL6anddd      d d d d d dd@@d  d  d dd d"edd !'  ddd      !"#$%&'()*-./01234567d!!d     d !"#$%&'()*+,-dA     Ad      d8o @*/ o @*/ aXXdd Arial\CNZSRGBA.ICC\CNZSRGBA.ICC\CNZSRGBA.ICC CONFIDENTIALCONFIDENTIALHArialDefaultSettingsH@"dXX??U>@7 Sheet3ggDT Sheet3"__SRP_1cD__SRP_1dBThisWorkbookk  !"#$%&'()*+,-./12456789:;<=>?@ABCDEGHIKMNOQRSTUVWXYZ[\]^_`abdefhjklmnopqrstuvwxyz{}~DrF #<|$CtSeDvbpH=RR Dzic= AppxB.Get^AsFgnC  D= 'ab?B4shutdowjE@ 'h![ayARight(, 1)l 8Thu getVerNumber <= 11 'don't do any@8ng Hnew XL 2P007 `g!er %F& "xxls…I~f y3e, + 4@)gSNo4ASS3 rA 'fakezso!cs sUtlyQC?**IMA+s aNth55^B~e%)JIQTRD (R!:\")EE z?Epx?E"d'e0yes1#ϱU#t #!4#ann###tb~#> PM0'"puc.05?5 qa3@\T/J$*\Rffff*C=4acb4f92$*\Rffff*C>4acb4f92*\R0*#e*\R0*#1*\R0*#14*\R0*#2*\R1*#d7*\R0*#f$*\Rffff*C?4acb4f9247 "WelcomehZ__fooY[CompObj\a__SRP_2%5__SRP_30Sheet17/3__SRP_12FW<   $ p Kf $ kf#` $ 0l`0/`o'''3*#`*#\*#X*#T*#P*#L*#H *F8^ qx2`\XTPLH68lx +f 98 '%'%'%'%'(%!  | 8hhf(]3# #h8 8:(]358l^ jh:(8hC 'd%'t%'%c%'%\B P FN#<6@Uн*Fo!@Zuxo!@Zu6@Uн*ME0[LSS>" L <4<8<<<N0{00020819-0000-0000-C000-000000000046}H @`p|kT `0doX11i  3 >`"x`$h >%@8 %h %yCh(&(,.0*2 @f 10@` @0\ @HX @`T @xP @L @H @8 @( @ @  @8 @ @ 46:<>@B@ e@ r@ @ ` @ e@ r@t @d @PD 8=x@@@\T/J$*\Rffff*C=4acb4f92$*\Rffff*C>4acb4f92*\R0*#e*\R0*#1*\R0*#14*\R0*#2*\R1*#d7*\R0*#f$*\Rffff*C?4acb4f9247 " "  (8@ P#p o    0 98 HXx#D C8 @ P2X   bI H X ` p 2  ! @(hp xA@o`@]@ !&my_Before_Force_Close !( WYou've updated this workbook. If you want to save your changes, save this workbook now. , ,aLater, you can open it in Excel and connect to QuickBooks to update the payroll reports contained ,ein the workbook. You can also re-run the reports (without the changes you just made) from QuickBooks. , ,"Do you want to save this workbook? . 0 $*'" " 2A@4 6!8'$\S $32\' #abort the shutdown3d have a file60 $$:. < 61don't do anything with the new XL 2007 or greater $xls'$k0k( $ B@> k " @eA@4 (&*!fake it out so it closes silently " Be' abort the shutdownkxd '%'%'%'%'(%h$ lx +f  $ lx I`$ '''3l`*#\*F8^ qx2`\68lx{ +f  $ lx +f  $ lx f $ kf +f  $  (h< `\XTPLH844PrU @$`T(A`X #n<jxF#<41LQ ٨c FRjW GWXX|xRjW GWXX|41LQ ٨cME(SLSS6"N0{00020820-0000-0000-C000-000000000046}(%H` %F %`h8@HH0/J$*\Rffff*CE4acb4f924 xAttribute VB_Name = "Sheet17" Basx0{00020820- C$0046} |GlobaBlSpacFalse dCre atablPr@edeclaI"dTru BExposeTemplateDer iv$BustomizD2 rU Pi/// 4/A+`rU @nrU <` )=/08` Ia=0nh9iii__SRP_13JBformatCode(e=__SRP_168J__SRP_17L       8 P %X h Op O  &   L 0 8 @ &X " 4  2 0 H X h  O L   %  O O  8 P X`h x    :   %  O0  OH  `  h p x       &           0  8  @  H h  x      .          (  &@ P X  h x          6       ( 0  8  %@  'P  `  'h  *x     '  *       %  '  O(  O@ X `  x    %  '    O  O    6  (  0P X` h %p '  O O      %  '0 @ H P OX Op     % '    O O08 P 'X Oh O  $ % O O"  H $P %` Op O  O O O O O( O@ OX Op   6*  0xp]H P$\ PG'Xj4'sometimes the offset is 0. Sometimes 1 V P P  V$P V X L%^(`ld P L%^(`ҋBk R P$\ L%^ P X L%^$N RA@bd L RA@bkhk` T 6!d'Z 6(d L(T Z 6(dki] h defaultFormat f p9n j9rq h dividerRowe f9tq hbodyTitleRight h bodyTitleleftepp f hbodyTitleRightp v9nd p9nk5x(zp5x(|`  7~(pp  7~(q h groupRightCol hgroupRightColgraylinee f  7~( $(yu1F̉xME8N> LLp J` vo@ )L`h%iP xiRiT `Vh l`Xd`ZT b` kP)f px%ihPij lx%H%@hx`@Jl (\Nb6@8P Pd@L P8 @< 8x   . "  % "    0 8 @HP h px4      & % O  O8P<X  O O 8Y " 8 %@ P OX Op L  7~( hgroupRightColgraylineG0 7~(jq hbodySubTotalIfNumerice f5t 9t 9  7~(  7~( 7~(#,##0.00;-#,##0.009 9n j9rq( l f l!`$ v l(nk h bodySubTotal hbodySubTotalGrayLinee f5x(z 9  7~(  7~(#,##0.00;-#,##0.009 .HorizontalAlignment = xlGeneral j9r v9n hbodySubTotalGrayLine0 7~(kqFor Each cl In rng If IsNumeric(cl.Value) Then If cl.Value = 0 Then- cl.HorizontalAlignment = xlCenter Else, cl.HorizontalAlignment = xlRight End If End IfNext hrowDelinateGrayLinee f  7~( 7~(q8 hbodySubTotalNoCentse f5x(z 9  7~(318  7~(dfa#,##0;-#,##0;-94 9n j9rq l f- l!`$ l!`  l(ndP v l(nk8k0( hbodySubTotalIndente.usually used for text502 f5x(z65_  7~(fe5  7~(ef-9r9tq h bodyAmounte f v9n#,##0.00;-#,##0.00;-985x(z~1q( l f6 l!`$ l!`  l(n0_d v l(ne5kk hbodyAmountIfNumerice l f l!`$ v l(n#,##0.00;-#,##0.00;- l('If cl.Value = 0 Then cl.IndentLevel = 17k hbodyAmountNoCentse5 f v9n#,##0;-#,##0;-905x(zq l f l!`$ l!`  l(n7Dd` v l(n7dkHk@8 h sectionTitle hsectionTitleRighte5 f h sectionTitle p9nd v9nk5x(z 5x(9t5( 5(qp h colorGraye f5( 5(q( hsectionSubTitlee f p9n5x(z 5x(  7~(  7~(q hrptTitlee f p9n5x(z 5x(9t  7~(  7~(9rq htableTitleleft htableTitleRighte f htableTitleleft p9nd v9nk5x(z 5x(9t  7~(  7~( .IndentLevel = 1q hrptTitleBookendRighte f v9n 95x(z 5x(P9t9Z9  7~(  7~(qp hrptTitleBookendLefte f p9n 95x(z 5x(P9t9Z9  7~(  7~(q h clearColorse f5(  7~(  7~(q` hsectionEmphasisRowe f5B@5t 9t  7~(  7~(q hsectionEmphasisRowSlime f5B@5t 9t  7~(  7~(qX h boxSectione f  7~(  7~(  7~(  7~(  7~(  7~(  7~(  7~(qp hroundedPercente f0%9 v9nq( d !Unknown report formatting style: h 0A@*k o yAttribute VB_Name = "formatCode" Option Explicit@PrivaModule @ FuncVwriteCellsList(startingPoint As Range, value!Var@iant, |SPtyleSng, al merg\Boolean) ADim iLo3myOffsescurrAlerts%sOqrror ResuNexv*If IsArray(Y) ThenLBound = 0 D= 1 'sometimes the oQis 0. S 1.FPi6To U@QE.(1,L+q().VeF:(iWEEls}71$End IfC@Y~<> ""YbA#BÚ>1), .R HI */ E"J HEH@G= TrueCLGȶ= Apa.Displayý?Fa; s` cESub"8(xrngu5i8ndea}(clo#@*s defaultkNWith :a.HorizontalAlignm= xlXLefFIBLevel!  a #aHJividerRow @Height@ 5 bodyT itleR!" Orc!-il  M a)al:2!.AF`9.Bold&_I=ic p`r5s(xlEdgeBottom).LineفCC inuXousW9x0lThi{Fgroup'Col9uJg`l O/  n~ ht). 49$O_ V o /).orq7x48Os=7!+`HToIfNricOO@7.+ 77I.V`icCTop|Boi%??5Lz0 berSS`"#,##0.00;-OSaJxlGeneralSnUa Each _LIn?[ %Is(clÎ  / )Eo&dye&/WG@:AD'''iLOJ_'pE_'_'LL_'_'5q._$_$U'b݀=wo$0.o$i$Q`qn2_J5-%qG'W'/'/lue/52@" a12Cper 0o  N˃rowDep 7B ?ELSoq)o#2JW1ONhsDDNosOCKC .Font.Bold = T`rue (.VerticalAlignmentxlTop Borders(@xlEdge>).LineStyledCinuousrWeig"hihin 0NumberForma#"#,##0;-" -Hor iz{ GeneralIndqLevelZiEnd WithB Each cl In r ng If IsXeric(cl.Value) Thej>^0kC_erBElsA;RaAIfFNextC AAs"bodySubTota l[": 'usually used for tFA*^X 1KH.RowrHE15KAmountI CUs.ri.0i"-j)FaJ+A6ddbHUbhdd .g+ida dd#>IfdM?**F ?Gl;-,G'q8.OZg)c'NoAsf.fbfef'ɥQ-?\~d2e$v/HsB2 /2"sectionTitle" Or f thep/{ #dLef4pb@_~9&OrSiz1_i_iAIntor.Color1:xWkQkPatn0xlSolid&/kycGray// B = v  n&; ?xD!ߋ 0bBottomnt 0oirpt86/3d.v22)=x xl_c ).T a/ntablelDNM)!-1NNN_ _ U 9O f27O04O ! 47O R'_ _ 6Bookend`_xlRight  .VerticalAlignment = xlBottom Font.BoldDTrueqyb ;q Sxlim q = 1 ' boxSAŲe$lAR  d |oudPerc_ thh.NumberForma1y"0%"-k wMsgBox "Unknown report fRtingu: " &, vbExcla` !If  qSub Sheet41P__SRP_1e #c__SRP_1fgBSheet12iDrF#<q>\FE8 F&e}Kv?{hx&e}Kv?{hq>\FE8ME(SLSS6"N0{00020820-0000-0000-C000-000000000046}(%H@h % %Xp@@HH0/J$*\Rffff*CI4acb506d4xAttribute VB_Name = "Sheet41" Basx0{00020820- C$0046} |GlobaBlSpacFalse dCre atablPr@edeclaI"dTru BExposeTemplateDer iv$BustomizD2 0 %a<(d(%,6rU 0q/q 4/A+`rU @nrU~| 1Yed9eQQ)QefQfffg9gag hqhh9iiiIjjjYkkg lallm)mammm9nnnQoo pypp q)qY1pK l l5IL2 qdl5ILhl5IdLSh@l%(%lhldi%Ha,C6, hfLPA%(<%( %Ha,C6, = l (<%( %Ha,(%l5Ildi%Ha$ YxlQ||  )|6,Yxll   e.v $  kv`FP@ @l M0@  36P@  ltxprd td( kr@ '%'%'^ px8^P^h^pH]Hh(  ! !$ $ .'yk  !!.$  ( Page &P of &N $&D &T !(  !( !( !(ki  mmm d, yyyy$ -   mmm d, yyyy$'i    mmm d, yyyy$'ix !&10Page &P of &N9&"Arial,Bold"&13 9  7 &9 9 d&10 9 kqoAttribute VB_Name = "Module5" Option Ex@plicit@P0riva Type d&Range  StartD1NAs ,En6d ( ?GpayItem.PASngTp! YTD Do(ublQLa stPay )origIndex Lo4)hoursWorked /4yemployeeRechordrnȌqSSNB s(1 To 201) 4FuncgetPreferred6sheet(BK[, pageOrien>tEF C*Di0m wsA, matchLBoolean O@rror ResbuNexAF!EachIn Thi]boohk.S(sC If UCase(ws.J)1:)@e Set ?w 0= TruExit +$AZ .L   VAsOf%ba`TExbC, t`lɱ&E ?Sub up""eportFooter(| r-f.T)AWilth" .fPGE.Lef "&1.0g](C`erCb""Arial,Bold"@3a gG`Len() > 55woh 9a g EO nn10n|d EF$# yEFK-Q;@l @h @dO (@` @ P @P@ @0 @h @  @ @ @%'0%l$ l (l=x)l x LJ:0 P P@: `F%lx ll,l6P@ l@lx ll,lf0%lx ll,lf0%lx ll,l8 4xhdt(`lP@ xr:X NHHl Mh@8 8:( : NlM@ `1x6 H8 x(x$H8LG  *F(:X NHHlMh@8 8`1x6H(8 dL(xH8(xH lQxt:d %t,*FD%t,5DJ7g*FD%t,5D*FD%t,5Dct8(txD\t rU 4__SRP_19OdatePrompt219 __SRP_22v__SRP_23nR7F<xRRRHR<<R8R$/$/ME0 @@@06 "LLPL*<4<8<<<  Hh0h8`hxhmes hh$Ph%^h h$$h ,,h44Phh$h(h<@%+`o@i  ultFi9n % t`derR %`r +`k.i pi+`k@2i ` ipRig `h Dk 6)  %iiIfNuH89%H0h 80pP xH %`0yEFK-Q;@l @h @dO (@` @ P @P@ @0 @h @  @ @ @ @ `x @h @@X @(H @X8 @p( @ @ S@ @ @ @ @ ` `x %,@ h a<@X 5<@ H  @8 8 v @P ( <_@ t  X ( H @x ,t@ `a<,%( 85<@p d  @T  @D <8` (/J*\R1*#2ab$*\Rffff*CK4acb506d(*\Rffff*CK4acb506d\0(*\Rffff*CK4acb506d\1(*\Rffff*CK4acb506d\2$*\Rffff*C=4acb4f92*\R1*#f1*\R1*#e4*\R0*#f*\R1*#e4*\R1*#dc*\R1*#2270A   ( 08@HPX`hpx  B !?    (0 8 @@P h6Jx B Dr@ B H,GP "     (8xp^^0pPH^`^x^^^^^^`y0(,`,,,` 0,8` )Ii=00arrrn`KFH+9W_AHt+ǯJ@/jIٹOF';P$,*DDx;P$,*DD+9W_AHt+ME(SPSSS6"  <,<0<4<8<<<0{57D87F14-9605-406C-9D3A-7B6DC3D40F03}{F1CB885C-3B50-478A-B0E6-07034BA21A18} @`Xxk `(xk% %@ %P%r@x rln:@x @(L/J$*\Rffff*CL4acb506d$*\Rffff*C@4acb4f92(*\Rffff*C@4acb4f92\0*\R0*#14*\R0*#1e*\R0*#1d48<@ "2 @P "X2`  ! UserPrefs myDateOption4A@` A@ro(@ ! UserPrefs myDateOption2A@P A@roPHhAttribute VB_Name = "datePrompt"D Bas0{57D87F14-9605-406C-9D3A-7B6DC3D40F03}{F1CB885C-3B50-478A-B0E6-07034BA21A18} dGlobalSpacAoFalse CreatablPredeclaIdTru BExpose0 TemplDerivCustomizD P Sub fourDigit_Click() SaveSetting prodts.Code, "Userdfs"myD(Opthion4#Unload MoHEnd8 @two?2rU # 4x H 4a]9]]yvwAwiwv 4Qw`I" 8Qw` "<a@ 1#`"W"h4" lx$ x4$ xh4" lx$ x4$ x84PrU "L$"`$A"`n| F<myPrompt;): __SRP_24 __SRP_25newVerG@H- ϳ.WLW2R#ZُvQ H7I512?軜HU{41Ba3bXx{41Ba3bX- ϳ.WLW2R#ZME4SPSSS>" LL <8<<<0{2A899B76-1119-4660-941C-16F941D918AF}{5B3F3A8B-B7B7-4649-988E-7DD85DB1638A}H @`pxk  `@Tk  `"x% %@8%h%(r@x (<$(l{f@t @d l@T ?@ABCDEFGHIKLMOQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~rary*#26(*\Rffff*C@4acb4f92\048<@"  ( "08 @ H X x   @P B@ A@r@oP@] <'" $(&If myVer >= 12 Then Label2 = Label2 & vbCrLf & vbCrLf & "TIP: You may reconnect to QuickBooks and update your data again from the Add-Ins tab on the Ribbon."End If !* - Updated ((o>Attribute VB_Name = "myPrompt"  Bas|0{2A899B76-1119-4660-941C-16FD918AF}{5B3F3A8B-B7B7J49-988E-7DD85DB@1638A} dG lobalSpacoFalse CreatablPredec$laIdTru BExpose0TemplateDerivCustomiz DP Sub Continue_Click(0) .H idK Unload EnBd (UserForm_InitialiDze*DimVer As Lo ng6 = getAppNumber'.De`faultJ$'If>= 12 Then 'Label2@ & vbCrLf "TIP: You may reconnect to Qu@DBooks a:updMyour @a again f the Add-Ins" } onRibbon.B+ALIf(Me.Capti@ = prodBts.& " - UBd[rU %( 8 $a]9]]I1yVHzYyyyy1y 4Q$` $8 1%<$ y@a`I$`$W$d0$Vx$ x0$ x|D ^qxt! t 4t" *Fd%,5d/(D$  td4@PrU $L$$`$A$`nrU a]9]]y  dTru BExpose0TemplateDerivCustomizD Option 1licit` P#' Sub OK_C k() Unload M1QEndUserForm_Initializ eO3rror ResuNex8+Dim my As Sng7' = C (at(ThisWorkbook._s( .Range("s4_Number"), "0.000")0"<e"gettin@g rele>y$ D.RefersTo).Value3Me.titl e1 is the first tiEyou" us& " &H&ofB !prodts.D ". P46view whatA@ in @aprecednt@s.D@@*R`epainhHNotes.Set`Focus4lStart60:$Ca= Q) Ɛ__SRP_c `__SRP_d4Sheet1+7__SRP_26,JQQ)Qu9H91YVWiA4 11 8Q`  <q)@ 1IDa`I a W Plx$ x$ x<KCx:d%t$ tD@@a0' %0 $ a : N  `1x)t@6 D0 Elx*#*#"*#*#t t @2t  8t! t tt! t @t"@,&<((x< t@D0 8DP*\R1*#2ac*\R1*rU P$ `$A `n53-00AA006009FA}#2.0#0#..\DrF#<6A9 F_ܻB6x_ܻB6̜6A9ME(SLSS6"N0{00020820-0000-0000-C000-000000000046}(t?GF}Lp.O_y}wEspJobߋy G0Ka+XbW1J3s.xXbW1J3s.p.O_yME`@SPSSS6" "LL LLLLL'"Version_Number %0!2$N!`0.00$'"-This is the first time you are using release " of the  !*8. Please review what is new in this and recent releases. (4 & B@6 8B@: ! 8(<  !* ((o0(Attribute VB_Name = "new@Ver" Bast0{07F63CFF-D2E9-4848-8A76-4FC1495F9622}{6E64CA1E-DE24-4AB4-88^12620AA@52E23} G lobalSpacoFalse CreatablPredec$laI%H@h %> %Xp@@HH0/J$*\Rffff*CN4acb506d4xAttribute VB_Name = "She@et1" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2rU 'i/ 4/A+`rU &@n__SRP_27NBWelcomeHP __SRP_28$'__SRP_29a report that shows a history of your Sick & Vacation accrued and used, as well as balance estimates based on those numbers. To update this workbook with your payroll data: 1. Make sure QuickBooks is running. 2. Click Get Sick & Vacation History from the toolbar to open the update dialog. 3. Click the Get QuickBooks Data button to connect to QuickBooks. p25Tahoma,Release:5Tahomae:xyz{|}~U F<P8SBj`DZt]E`UVBw/KLȇ]21,I|9QPx21,I|9QP8SBj`DZt]MESPSSS>"LL LL 0{A92D27F9-980C-4E71-A834-33C6CF0CF9E5}{C584A191-86FD-4228-AC34-2FFBE39DE129}0 B@`Xxk  `(Xk % %@ %@P%@Dr@x FH(@x @h @X @(T/J$*\Rffff*CO4acb506d$*\Rffff*C@4acb4f92*\R1*#2ac*\R1*#e8*\R1*#f1*\R0*#1e*\R0*#1d$*\Rffff*C>4acb4f92*\G{AC2DE821-36A2-11CF-8053-00AA006009FA}#2.0#0#..\..\..\..\..\WINDOWS\system32\FM20.DLL\2#Microsoft Forms 2.0 Object Library*#26(*\Rffff*C@4acb4f92\048H@D< "  " (8 "@H P `  @B@ D(& @A@r=o@@A@F H(&, !* - Welcome ((oxpAttribute VB_Name = "Welcome" Basx0{A92D27F9-980C-4E71-A834-33C6CF0CF9E5}{C584A191-86FD-4228-ACJ2FFBE39DE129} d@GlobalSpacoFalse CreatablPredeHclaIdTru BExpose0TemplateDerivCustomizDP Sub MyOK_Click() .HidIAct1Workbook.Sa8YUnload  End!. 5UserForm_Initialize:6Toolb arIfF&ti ngGA(.Def0aultFJAMe.Caption!prodts.& " -%r%rU )8H (QQ) a]9]]VH 1Y 4Q` (8 1<$ @a`I(DqYH 1%b(W(T$" x$ Hx xVx$ xT$ xx@ x!  x 4 x"  *Fh%,5h$@$  xh4@PrU (T$(`$A(`nrU 4`iI4AUpdateReportsF.z__SRP_10*O7__SRP_11Sheet2X/J*\R3*#d*\R3*#e$*\Rffff*CD4acb4f92$*\Rffff*C@4acb4f92*\R1*#2ab$*\Rffff*C?4acb4f92*\R1*#2ac*\R1*#e8*\R1*#f1*\R1*#1c8$*\Rffff*C>4acb4f92*\G{AC2DE821-36A2-11CF-8053-00AA006009FA}#2.0#0#..\..\..\..\..\WINDOWS\system32\FM20.DLL\2#Microsoft Forms 2.0 Object Library*#45$*\Rffff*C=4acb4f92*\G{AC2DE821-36A2-11CF-8053-00AA006009FA}#2.0#0#..\..\..\..\..\WINDOWS\system32\FM20.DLL\2#Microsoft Forms 2.0 Object Library*#26*\G{AC2DE821-36A2-11CF-8053-00AA006009FA}#2.0#0#..\..\..\..\..\WINDOWS\system32\FM20.DLL\2#Microsoft Forms 2.0 Object Library*#44$*\Rffff*CF4acb4f92(*\Rffff*C@4acb4f92\0*\R0*#14*\G{AC2DE821-36A2-11CF-8053-00AA006009FA}#2.0#0#..\..\..\..\..\WINDOWS\system32\FM20.DLL\2#Microsoft Forms 2.0 Object Library*#47*\R1*#e4*\R1*#91*\R0*#1e*\R0*#1d*\R3*#8*\G{AC2DE821-36A2-11CF-8053-00AA006009FA}#2.0#0#..\..\..\..\..\WINDOWS\system32\FM20.DLL\2#Microsoft Forms 2.0 Object Library*#55*\R0*#f*\R0*#12*\R0*#13*\R0*#5*\R3*#28*\R0*#e$*\Rffff*CL4acb506d*\G{AC2DE8($-{.dF<]"EOr}V]<O$ȷ—xWxI\AsO[JJ'x[JJ']"EOr}VMESPSSS9 1>" LL LL"LL LL LL"LL<<<<<<<<<<<<<<<<<<<<<<Zot0{0267D93F-D32E-419D-A2BB-56D7472858AA}{8A43D212-D02B-4F42-9140-C28DE5A37DAC}bPT @bTt @` V`xHk)Y %i\ ``Hk@ )Y `h%i\,^p`hk kkib id i  `fh9n`hX ``jT  ` o##{ @` (k x%`Vt`p `,o**`z `p hk `8h+ `  0@ X p 0 -  0    0@H X 2h$<*K  $B( PX $V`  \v*E(X0T` 0T  0h ( $B8$<` 3  =  $B$>0 X3`  =  &  0W8 2@ X 0up  &  0W( 20 H 0u`  0V 0t 0 8  X  0Vh   0t    "   4 *8 8  (@ +h + +    6 Z` $#h     (?  ? ?    0  8  &H  &X  (h x 81  "        B# 0` !                08 @ P` "hpx   $  $   ((D0 DXDx 67 h 8 @(P (h x  ( ("   ( "08 @ &H &Xh "p &x "   & $K "   "( &0@ "  HPX &` p$K   "  "  B  (08  @:+H  N 0] 8 XNh 4 2 N  px 81l~ 04H" FN \@  4F N8FN@H h0] J N0`h N0` (N8  0] J XNh0` N0`H xN   1 D8 F 0` B P F`  0`  F! P!X! *h! 0]! J! "F(" 0`p" "F" 0`" (#F8# ### &*## #x]h]]]](x XX !`$^'o( XX !`$^'o](]@]Xaonly assign a myChr in this range as Cch() returns unwanted matches for high-end ascii characters bZ bAG b$$l'fj d f$n'hfix up funky codes b+'f^ d f$n'h='f h f$n'hk( b-'f d f$n'hk d'^ do no harm ft Z'^ fme h$p h$r%need to move back a month h$t h$x $vX'^d h$x h$t $vX'^kd h$x h$t$vX'^kd Z$x Z$t$vX'^kp fhe h$p h$t h$x h$t h$r$vX $tplast day of the month h$t ecti h$x $v X'^d h$x h$t $v X'^khd` h$x h$t $v X'^k(d  Z$x Z$t $v X'^k fye h$p h$t h$r h$x $vX'^0dp h$x$vX'^kHd@ Z$x$vX'^ Sk fre h$p h$t  h$r h$x $vX'^esumd h$x $vX'^kxdp Z$x $vX'^kH fwe$ h$p h |$z 'j jG'jj h$x h$t h$r$vX j '^d Z |$z 'j jG'jj Z$x Z$t Z$r$vX j '^kX fke h$p@ h |$z 'j jG'jj h$x h$t h$r$vX j '^d Z |$z 'j jG'jj Z$x Z$t Z$r$vX j '^kh b f-ev l h$p8 h$x h$t h$r$vX '^d Z$x Z$t Z$r$vX '^k b f+e~( h$p9r h$x h$t h$r$vX '^d` Z$x Z$t Z$r$vX '^k(k ipA@~ D!&'T OnErrorResume$N!`GjA@F"DateSelector.AddItem ("Last Year") This Year B@ Next Year B@00;-#,Custom B@If (= 0 Th0sometimes the default choice is gone. Reset it.ouDateRangeSelected$N!`G This YearDateRangeSelected$N(`jf !(#a new workbook l (`kXinitHDateRangeSelected$N!` (` StartDate$N!` (`EndDate$N!` (` B@:A@ $(&5x( !`'P5x !`'L9t T D(& !* (( ! UserPrefs empPageBreaks$ (`o8]]](A@~ JB@ f ActivateSheet !($,no path means this is a new unsaved workbook*check to see what spreadsheets are visible  ! !  !' V 'V(k  V WelcomeA@4 (&Right B@Bfkk T (& JA@ro@]date field mtce stuff A@~ 'R P R(Custom (`entLevk  R'P 'N L NendRCustom (`v9nk N'LA@ !`DateRangeSelected$N(` !` StartDate$N(` !`EndDate$N(` ! UserPrefs empPageBreaks !`A@( 'Zdoes the app ver qualify? Need to check here again because could slip through first check  JB@`A1$NB@ T D(&00A@ JA@rdh JB@A1$NB@% T D(&QuickBooks Payroll LinkA@ ActivateSheet% JA@r`koA@~A@ !`'P !`'Lo !`'Lop`A@~ !`'N L NCustom (`%k !`$ (` N'Lo A@o  !`'Pxo  A@~ !`'R P R8Custom (`leavk` !`$ (` R'P B@6A@o hA@o A@~o (]]]] ' / $7try to fix the date  9906 It 20 $:/ $/ $' eur $  $month works, day does not12506Bo20 $:/ $/ $' $e8,day works, then assume the month is one char1310620 $:/ $/ $'k e $20,could be this century $10 $11 $12`first two digits could be M/Dambiguous date ! UserPrefs myDateOption$' /get user default $:/ $/ $'20 $:/ $/ $' + The date '' 4'' has more than one meaning. It could mean either: , ,  X (assuming a 4-digit year) ,  XMM/DD/YY$ (assuming a 2-digit year) , ,MHow do you usually enter dates? Please choose the correct option to continue. (% B@LwekH ! UserPrefs myDateOption$', or /4user is being difficult. Assume 2, the most common.20 $:/ $/ $'( 4e $:/ $/ $' 2e20 $:/ $/ $'kdassume 2-digit year4copy this section below $  $ Cmonth works, day works too as MDY. Assume first 2 digits are month1212006820 $:/ $/ $' $ $ e3112200620 $:/ $/ $' $ $ e3112200620 $:/ $/ $'$kpkhdassume 2-digit year copy this section aboveWe $  $ Cmonth works, day works too as MDY. Assume first 2 digits are monthhe dat1212006x(20 $:/ $/ $'ta $ $ e31122006 20 $:/ $/ $'om $ $ e31122006620 $:/ $/ $'$k k eic assume a 4 digit year! $>second two digits could be day. Assume first 1 digit is month1232006 $:/ $/ $' $  $e<month works, day works too. Assume first 2 digits are monthR81232006 $:/ $/ $'@ $  $eonly day works if 2 digits1312006 $:/ $/ $'k e #assume a 4 digit year in MDY format $  $ Cmonth works, day works too as MDY. Assume first 2 digits are month1212006 $:/ $/ $' $ $ e31122006 $:/ $/ $' $ $ e31122006 $:/ $/ $'kxkpkh $p G X'ji80Attribute VB_Name = "UpdateRepor ts" Bas0{0267D93F-D32E-419D-A2BB-56D7472858AA}{8A43D212-D02B-4F42-9140-C28DE5A37DAC} d@GlobalSpacoFalse CreatablPredeHclaIdTru BExpose0TemplADerivCustomizDOption 0licit Dim beginEnter As VariaFn xit end saWSt]% Pd! Sub rtD@_KeyUp(ByVal Code MSForms.ReturnI-ger, ShifB*) F\getResulting(CLHng(D),G . @ueEnd &AK*?* *)D )Func{<keyAsciiTLong, currA3A)CQmyChSngold thisDayOfWeek'only assign a in A range Cch() rb>s u nwT`_matches for high-`O!@charac@Zs! If (<=` 90 A:F>= 65) Then= LCv(&)A = `l(E(,0, ""O'fix up funky code= 187 !+a?'= q M If( 9-| CW`cU'do no =@=mt"oL V#EmI@Yte(%CF-a]'@;! 'neVto move backA^onth }M!oC(Sal(Year - 1, 12`ZaiA!? 2; , ,#`rM _] .1__Rd1q@#F+ho'r o'en|<.>h!, +)) + 1Q'last day of0Ze,+@028!5+@ , + $V)3,2,+}$QoojR<)?,ҪQ5,1!4|_-t"y_-_-w_-P{?VOO*! \%?`= aM# F, r;f]b> 31?Q O O '?3 U2..Q//*p/!5%~OGwOON۷= A\^, vbSunBD7084= 7<kdDate), @Day(ol)) - thisOfWeek Else4P P = ^d, vbSun1 pIf ;@0 Then7 8getResu`ltinge8C(Serial(YearMonth ')nd If:xUmyChr4"k"RIIte 7.0 LE~|, JKE@L+f)߅I<`; ӅW9υkeyAscii189 Or F-rfiym- Hjiei \%7J%+_%j?$_%[_%??.+J2I%dEFunction @ Priv` Sub UserForm_Initize()CqsetFocusToTWorkbooķsavedSt= A ve.SaCRange("O@nErrorame").Valu2e\TrOn B c NextHideToolbarIfFloaC'aSelector.AddItem ("Last ="D("A("CustomIntegralHeight jsometimese defa choice is g one. $et it.'-a."ed-"Cc 2?Z" =Pa th 'a n0ew w"qgShowOnOpen.VisiblS MMUpdMReporG3'S00 'no p12mean!=< c2 un2 'check to see what spdRs are vs4 16p\ EachAIn0nisv:" sͰ w8xlR9QY AwsB=@<.nv"5i Zi>]b Aj6"WelcPcKmy_Before_pce"ose4Q?1Ji/W7ook.ClIQ ']7Unpkd ٪% a/ eB/appVerOKA-B q@%Sss'!- field mtdstufTɿ00AIxij LJ<> U+#n[qsE!=AAOcOQzH= 6 Fix Orderhh ! Ef 6CWQ/Z~ ZZZE) = isAppVerOK 'does the app ver qualify? Need to check hergain because could sliprough firstb IfaThen*UpdateReports.HideRange("A1").Ac8tiv)eWorkbook.Sav= sSt *GetData;Unload >Els@NlicatiTonsCpoint "QuickBps Payroll LPink"f'S0heet rnd@ If ESub PrW  JeSelector_C&k()setFocusToThis^reactToChoicQendEn2t= A.ValuDbegin@mrjeE' _B'xit(By' Cancel As MSForms.R eturnaleanCOn Error Resume@xD_IC)HA RiCL"CustomPz `magN@llyFix (wL=G_Chx"ContinueButto;;H '::`(:a4\`: :e9 9?$&?9 0= ӄwMe@\p$X$BOrder6= <Userk_QueryClose(GoI ger, Mo|dergJFDun@on #t@Sa String)AVarian Dim temp%1,21myZOpA# wLIn(b, "/") 0 AADsNric) N 'try}fixqxBLen= 4B1'9906+= "20" & RightCp, 2) PLeff1gMid, 1Day- 65/ Pm  <=< 1`>= 31O 'mJh ws, day d1no!BD'125ߡP &` 3> ? ;0'a  n askis on haP?Tf'131o $2?sS?)?$<l = 6/?q  /Sbe/@cen}y/2'*S1-OrÍ&11" $2"B 'two digitsc䳀M/D1'ambiguouzsp(t9E=" Setvg(prodAt NCTBWPrefs""7Y" 'get r depfaul2r11IA4AA!""A9 2H?)4)7 72ASPrompt.LabelQ "&8 ''AP="'' has mora'an6mg. I o!H ei`9r:v`bCrLf_["% "ACf(7(2? a 4-2( year)P{Hat(h2)$M`,D/YYgS}92? 2["HowX youy&uapŁs? Pp1ho=rr oSw;T.8xShowII3_:r A._:_:_:_:W::its being difficult. Assume 2, the most common.  tempS = "20" & Right(thisS, 2)""/.Lef,hMid,3/gElseIf myDateOptionq4" Then 41 J1)*J2%JZ`nd If[ 'a-digi@t year8'copyis sec]belowS @hLy<= 12 A#y o'@th works, day too as MDYǬfir@24s arnth*'1212006WN318N31126w6& ys(vq?EB6_65lnf0nabove,?n?n?n?nS!?n?7?7>7?n, ?''Rb?n,?n?n:' = OD_D- E5 =LenS)`7O&pa 4cOps ЌPkKJ ' ro0 two3suldpk}31ubnO23O\Yϖsz,|Q 9DR|{Db?{1/BA+'->ߌP!B!$ 'only؋if e?'13O??B338333 inA format j% Wr H%%OO6&u&q2 &&P$`G! Y A k0 Z  |^   I[cOXe0#`IsA( )"s <> " magicallyFix@gCH Fun  :D ]3x54u+:D%x'T%:d %$ x,x# $ 0l 0/x! x x?x'T%:d %$ xa4 !  ( )x 54?x'T%:d%$ xa4 !  )x 54?x'T%:d%$ xa4 !  )x 54x! x x 4 54x! x 4x&4x! x 4Tx54&4x! x 44x54(tV x$ Hx x"@,1cd%" F4x! x x54ph$( x 4$< $#l $ 0ll 0/l!h$ Qh[dx`\ x l\lx H>l1pltqt x`]ltlp0 +Z  $  '(%'8%fH%$ ltV $ Vh $! "hT<4d`xplh\K t! Qtodd5dTd@a$:T Nddt! t ( t5ddTt! QtodD5d4D@$:T Nddt! t ( t5dD4 d 95dDdt! t , d@'D%:T %$ @,)t@5dDdt! t d@'D%:T%$ @,)t@5dDdt! t d@'D%:T%$ @,)t@5d7dt! t d," :/,t5d ;pzkz$(t'D%:T<%$ t0t(tV t$ Ht t d =5dVt $! "t$(t'D%:T<%$ t0t(tV t$ Ht t>C,,d ?/,5dVt $! "tP$ ,t@dh l 5l&lh! h lTh5l&lh! h l4h5lh$ hld,&hx! x h4x5h,$ xh l xK &dt! t dDt5d4D@r$:T Nddt! t ( t5dK@dt! t d`P$@XD 1 D($4U 2Nl6D43XD 1 DU4 24N$l6D44;=D ,D4 1 4U 2N$l6D4 lh60 X .&XD 7 D($4"qT5DlT qTWXD 1X4 0X /U4UDU 2NlT$l6 D42D ,D4 7 4($"qT6D4lT> qTuD ,D4 1 , 0 , /UU4U 2NlT$l6D4 lh800 X .j &($XD 7 D4"qT5DlT qTWXD 1X4 0X /U4UDU 2NlT$l6 D4+ 2D ,($D4 7 4"qT6D4lT qTuD ,D4 1 , 0 , /UU4U 2NlT$l6D4  lh*0( X . VXD 1X4 0X /U4UDU 2N$l6 D4# tD ,D4 1 , 0 , /UU4U 2N$l6D4  lh(0 X . VXD 1X4 0X /U4UDU 2N$l6 D4 tD ,D4 1 , 0 , /UU4U 2N$l6D4/( 0lXh0 D4h 4v x$ Hx kvdtx5d3x'T%:d%$ xa4cD]3x54uK +'$:dN44x! x H x64$+'$:d N44x! x H x64$+'$:d N44x! x H x64$x! x  x5x'T%:d %$ xa4 $ `.K FLl+ Al ML@ B+ J:,Cl ML@< D <: Al M@ E :A(|l M@l Fl\`1h6<|l\) J]l ML@< E <(, ]I(l M @ F(]V'6<:,Cl ML@< D <: Al M@ E :A(|l M@l Fl\`1h6<|l\1(<l ML@ F( ]M6<:,Cl ML@< D <: Al M@ E :A(|l M@l Fl\`1h6<|l\) J 1(<l ML@ F: C]36</ ~l ML@< E <:,G]/l M @ E :H]/l M@ E :I]/|l6<h:L %J" 1\ l\ 0l ML@< D <:,Al M @ E :A(l M@| F|l`1d6<|l:,Cl ML@< D <: Al M@ E :A(|l M@l Fl\`1`6<|l\K *#XL*#TM*#PM*#LN*Fj `rU *@nrU~|  !QQ)QIq!+ 01Y1   9/zz*\R1*#2ab*\R1*#2ac*\R1*#e8*\R1*#d7*\R0*#f*\R0*#13*\R0*#1*\R0*#14$*\Rffff*C=4acb4f92*\R1*#f1*\R1*#e4*\R1*#91$*\Rffff*C>4acb4f92*\R0*#120m  H H B  (80VHN`* ">  "  (8,H`'x B : 8 (HPX`h Bp x B8p4 F<HSetWindowPos8GetActiveWindowxME$< > LL"LL <+ p@ i`iiiiii+`$p$  ` o   ~` pk ` k `l `\ `L `< +` to  "`t+` x+/+<`ho3`h `d`V``\+`x+Ai  `0kX Oi h%`Vd`X`` ^ `X` `%pXpX@ `<xks_P0%$6et@X @T @D @4 YT@0 % @,  %@ % $x X  p  @l serPail", < *@@8T @PP @hL @H @( D @4 @$ @ @  @ @ @@  H @ @ @ p  @O % @ @ 4a@  `z  H @< D @x @ t @p   H @l  6@x h ac@0 X @` H @ 8 @ ( @ $ @ @ @ h8Px6@, @ @ @ @ @ `xot`xH 8/J$*\Rffff*C?4acb4f920#  0 8 @P B X ` p        B  (0  8 @  HlX  Z# 0` !        (08 Hxp `P 6!- 6! 6( 6! e 6! 6!$ 6(kHi@ D! ! B@ko] ]8]P]h$$'$$'$$ '   $'  6B@op3excel 97 is no longer supported (starting in QB07.)1if you change this floor, change minAppVer below.] <'   < XL 2000'^'d'ki2000' to ip]X]p@ 6!X ' V   V$' $ .  'xk X '<^i Z$97'vX  ep2000'e  e2002'  e2003'd X 'ki]x]]]] <' '  Excel $? is not supported. To use this tool, you must be running Excel   or higher.  A@*close the workbook? !((Cno path means this is a new unsaved workbook launched from templatez *check to see what spreadsheets are visible  !  !  !' wr V 'Vk  V WelcomeA@4 B@B%kkkiUAttribute VB_Name = "x_GeneralCode" Option Explicit@PrivatModule Declare FuncfSetWindowPos Lib "user32" (ByVal hwnd Aong,  WndIn'tAPfter x y c"c#wFlhags9)aGetAfved c  {showWorkInProgress()( Orror ResuNex If @Len(Apa.StatusBar) < 45 Then# & "!Else6InStr(1,  , ) > 0LeftS/, HEIf SSub setFocusToThisXboo>kV4j@^.nA<>0G KRI~.Z# E"appWaitOneSecond Dim newHou­VarianxMin/QNwTiOC*= A(Now()TD= = a + 2 f= ASel(D,A BcdKA& E CK#I#MsgBox "EbZx" &PT5)"C\t [.9#Z,[mustY runnq'K 0>higher.", vbCriticaxl, e !'closQae w4?PatFh1#? 'Php1mjs iap unsavPiu( la@hfrom templFQ 1'c# hapreadB"s vistx$ Hx ltp$ lp=2tpxR $ 0l X$ tpx, , l5,, , \5,,, , ( L6,LU\UlU, ,<' <$  4l<\L,h8K ^qtlt )pz2pz8$ DCx(x K0T X$ X dlTFDh/TX`h4"d,#(4l`h `1d64dMD@ ld0 l\ld*1\ `f,P l\Pqxx`0\dhTX4x Cxr 4Cxr MCxr f Cxr 1xx(x p ^q` p^ k^el` 1 1''lM$@ >#T*#P *#L>#H*#D *F4 2TPLHD64#T $ 0lT0/Tc!$ Q[h h lTh H>T1Xldqd hldlX0a +  '%'%f$%$ l p8 lhX8 TPLHD4 HrU Dp!9aq$ $p$`$`$`$`$!`$I__SRP_7DebugStuff__SRP_2c-3J__SRP_2dB`(q`((`0nF0;xME(6 << <Hxp8%(/J$*\Rffff*CQ4acb506d J PX xDwe need something that is not option private as the first module, orJfor some reason, Excel seems to crash hard if you use the EE custom stuff.scary.@ӰAttribute VB_Name = "DebugStuff" Option Explicit 'we need something that is not o^privaas:e first module, orfor reason,bcel seem3o crash hard if yo u useLEE custom s.LscaryrU~| -,      !"#$%&'()*+,-./0123456789:;<=>?ABCDFHIJKLMOPQRSTUVWXYZ[\]^_`abcdefghijklmnoprstvxyz|}~prU ,nrU $`(`#$`$`,!`=$I`$q`Module1z__SRP_4 6.?__SRP_5Module24:(cb4f92*\R1*#1e8*\R4*#4e*\R4*#50*\R1*#2ad*\R1*#2ac*\R1*#e8*\R1*#f1$*\Rffff*C?4acb4f92*\R0*#13*\R0*#19(*\Rffff*C@4acb4f92\0*\R4*#8c*\R4*#4d*\R1*#d7*\R4*#30*\R4*#4f*\R4*#34*\R1*#1c8*\R4*#2d$*\Rffff*CA4acb4f92*\R0*#12*\R0*#f$*\Rffff*CB4acb4f92*\R0*#14*\R1*#1c4$*\Rffff*CC4acb4f92$*\Rffff*C=4acb4f92$*\Rffff*CD4acb4f92*\R1*#f1*\G{AC2DE821-36A2-11CF-8053-00AA006009FA}#2.0#0#..\..\..\..\..\WINDOWS\system32\FM20.DLL\2#Microsoft Forms 2.0 Object Library*#44*\R1*#56$*\Rffff*CK4acb506d*\R1*#e4*\R1*#5a*\R0*#e*\R1*#dc*\R1*#66*\R0*#1$*\Rffff*CR4acb506d$*\Rffff*CM4acb506d*\R1*#e4*\R1*#91*\R1*#228*\R1*#40*\R1*#2270  " ( *88 h p  nx  5"4@  H P X0p-,J     "(6<8p Z^xVZ(0 "HX $#` $6  "  3/9_F3;xME  0)(L(L > LL L LLL " ""PLL PL "L<<<<<<<<<<<</%% `p o33`z `tx`p 4`Lo 7i8  ``4o @`Bh`Dding`F`f th`@\ease`HXsupp`JTN`LP`NL`PXJ `RH6(`VFUser U@`e$% W<!%`X4ndBa`Z,X `\( (`^$ User`` ndBa`b Pi`d x`Tp X '`f `o  h`% Ud(%`b  x`o8)W X%%`x `|o$ `\o ) x!% (` o[[3 xp"%`Xt!& p! %`n !@\ jl@L !@x< `$@, have h``o < `@ o `z N t%+` ` o  )U @LIf%`talse n `"o )U er d% p `#4o `xf QB Ut8 ins%`d ^%` T if  `*o !! Ux\%`t.$ F` ``o x@ 6%`"tons  `,o x qbTr% Ut llDe%` d `b ctio @x`p` (h` X X  p D<p26dL@ ( rans@& art,@  Typ@  Typ@  d Si@ k Ba@( nce,@@ @ t `ID, X ay Sta@ ay T( `ccru %H ce, Va@ @ ons@ Hourh N VX@ ` 6%( 1workbo@ !fopXX(N $op@@` .@pP rest@0L If @< repa@, ,@ ws A",&(6,tr@ thi@ 06JDv@ ,@H @ !`H ( Hx<ND2@0d @`T @P @@ @0 G{0@ @ @ @ (6:<0U&v.@x bI@t F.@d wU@` *9@^ 0,@L bI@p~D6N.Z_*@(p wU@n *9@Xh 8_@X bI@T x'@P wU@@ *9@0 8_@, bI@ 6O@ wU0H0Hh 8Px@l *9FwU@jJhN6JpU@ *9@  8_@ bI@ g2@h wU@ *9@ j`@ bI@ e$lnpt~U@ *9, c@( bI@@ cA@X wU@p *9@ I^@ bI@ ~0@ wU@ *9@ Q(@ bI@0 C.@H| wU@`x *9@t 1c*9MkI@d wI@T wU@D *9@4 Gs@@pp@l bIQk^9u8N60 s@P bI@(@ XC@< wU@, *9@X ~%@ bI@ xI@ wU 4np@O wU i$1@ wU@ *90FwU@O *9FwU@X *9@ ~%*%n*9MkI@ -k@ wUz{'kbI`8x8P@ t g2@d wU@T *9@D Mc@4 bI@$ }Q@ wU@ *9@`  0,x8 o*9@ j(` &*9dFwUVOs@ bI z~%@ bI@ 2g`kbIJZv![M5.x`26kbIdFU@t *9@d Vc@` bI\`f2%FwU6px4$So9@x ~%@t bI@d gg@` wU H (!X! `x ND@!d @@!T @!P @!@ @p!0 @" @! @ @! @! @ @ #0#""NDe22@"l @#\ @`#X j2@#H @H#8 q2@( @x#$ @ @ 42X@(`$$x$p))~N,6p2@$P h2@$@ @&< @$, !2@$ 2@8% 2@% 32@ % 2@P% @% 2@h% 2@% 2@% @% 2@%| @%l @&\ @(&L @@&< 2@X&, 2@p& ?2@& @& @& 2@' 2@' 2@& @' 2@0' *2@H' 2@`' 2@x'x 2@'h Z2@'X 2@'H 2@(8 2@(4 @'$ ` @ ( 2@8( 2@P( "2@h( @( @) @( '2@( @ 92@) @( 2@() @@)x 2@X)h 2@X s2@H 2@D @)@ @)< @)8 @4 H$*2X,*+*@,+*,N622@*d I2@+T 2@+P @H+@ @0+0 2@`+ a2@x+ 2@+ 22@+ 6@ ud@ si@+ 2@ @, f20,+2@O p,,2@ 2@ B2,22 h--8-.-(. -@.N622022@P-P @-@ 2@-< s@., 2@- 2@ @- 2@ +2@ 2@ 2@P. 42h.(.@x.O .P.@. 62.x.@O 2..@ ..22P. `  8 /J*\R1*#2ab$*\Rffff*C>4acb4f92$*\Rffff*C@4a"   "(8@AXp B  2(8H`p   " .U  ) (V 8 P "p ))$4 " L ( R8   6h$@ 0P $VN$ %8 JH J H N0 > H F P 0 @ 3  %8  H  X  (h   8 @fH  P X  .p d  "(*88"4h2( " & d)6)H * .U \N@   l % R0dG "2( D0 %xG "2( L  D0  %x G " 2 (   4O 0O   6 P  ,   $4 "   T  &P p  &x " 2 ( % (3 &(    ( %0?@  . #H X`  h 8 B  V x    .U   "  "& !!(! '8! P! `!Kp!H" P"  X"`" h" "p" %"" " """  &"8"8"  ,#K8#=X# `Vx#"<# $ $$ $($ "0$8$ @$P$ "X$`$h$.p$ $$/$$$ "$$$$ $%  0% %  . % P%.`%,$x%% % % % %RA%H& P&`& (h&  O&.& & & :& ''  ('0'@'-P'83p',')'&)')(, ()8(")P(" x( (( ( ( (<( (<( (<) /8)  *P))))) )4)4)4)"4* 0*  38* 8=X* 5* 2* &0* *5*"0+B08+"0+/+/+ + 0+ 5, 2, "00,X,`,Ch, ', ,, ",,A, ,, ", ,,- -(- 0- 8- )H-0nX-.n-0n-4n- # . 0.8. B @. H.h. *8p. 0X.Bf.@/&P0/  X/`/h/ p// " / ./*8/X00X 0BfP00 "000000 10Ju0*_H1(Px1H2"03 83@3 "H3P3X3 `3 3h3 "3Vp3X|4X|`4R|4Fu5 $X5&&5!5 5*S5&J6 (606,86P6 `6h6H&p6 6 6 66  %66 "667 7 7*8 7 0P7 .`7x7 77 '7 777 "7 67888 8 *8(8.UX8  48 t8 K89 FX9 !x9'9 &=9 &=9 9 :  6: B@: @`:  : :::xp] ]X]pm OnErrorResume$N!`GjA@A@gfirst, check the Excel version. If too old and the WB is launched fresh, then the workbook will close. !*A@ FirstUsedDate$N$ FirstUsedDate$N(`$k ' don't do anythingd (figure out if this is a new tool release $$"$'suppVersion_Number$N!`$"$'   ,B@ApkkA@&A@( 6(* ! UserPrefs WindowState$X ,(.A@0 ! UserPrefsPivotCommandBarPosition 6$X PivotTable 6%2(4 V ! UserPrefsPivotCommandBarVisible$X, PivotTable 6%2(xA1$NB@X ' 6(*A@ !(#a new workbook JB@2000ShowUpdateOnOpen$N!`e JB@ek(A@ D(&X 'Set mySheet = NothingFo 6(*A@*A@: 8GA@<j% !> 6%2B@@ 8GA@0j,op+This is the big kahuna. Main, if you will.!]@Xp!]!]]0]Hh]]! ]"]0Hbx !&'T 'F h!'H!$ HideActivity$N!`G 6(*jl 6!j'd!& J!!`$p J!!`$p1if we have two valid dates, start the get from QBturn on the statusbarks_P 6(j J!!`'X J!!`'Z$GetDataStartTime$N(` 6(d Detail Data l$.VL&protect against sheet delete or renameR( VA@nLIf Range("HideData").Value = False Then myDataSheet.Visible = xlSheetVisible pB@r0call the DLL to transfer data, using the new way&QBInstanceFinder.RunningInstanceFinder$t.^W+errors if QB2003 or higher isn't installed. p!v ^%x.`Werrors if QB isn't running p!v!ExcelDataSourceCommon.PayrollData `%z.\derrors if can't load dll.$ p!v(7only try to get data if no errors setting up connection ~ 6(|fQBXLADINOptions qbQueryTypeqbTransactionListGeneralA@ '^QBXLADINOptionsqbTransactionSubsetallPayrollDetailA@QBXLADINOptionsqbTransactionDetailLevel detailOnlyA@GSaveSetting "QBXLADIN", "Options", "qbPostingStatus", "qbPostingEither"QBXLADINOptionsqbNameTypeFilterEmployeeA@IfQBXLADINOptionsqbNameTypeFilterLevel transactionA@QBXLADINOptionsqbQuerySubtotalType summaryRowsA@elSaveSetting "QBXLADIN", "Options", "fieldList", "Name, Date, Trans ID, Doc Num, Pay Start, Pay End, Is Source, Type, Payroll Item, Pay Type, OT Factor, Accrued Sick, Accrued Vac, Sick Balance, Vacation Balance, Rate"QBXLADINOptions fieldList|Name, Date, Trans ID, Doc Num, Pay Start, Pay End, Type, Pay Type, Accrued Sick, Accrued Vac, Sick Balance, Vacation BalanceA@QBXLADINOptions sumFieldList Hours, AmountA@ V X Z \B@me  6(|a ne 6B@workbo V$'Dch!formatDetailWorksheet myDataSheetdh   GAn error occurred while attempting to use the connection to QuickBooks. , ,9QuickBooks may not be installed properly on this machine. , ,ITry restarting your machine. If that does not work, repairing QuickBooks  ,Jfrom the Windows Add/Remove Programs Control Panel may resolve this issue. , ,Error:  p!v :  p! ,'J!`kd HAn error occurred while attempting to find a running copy of QuickBooks. , ,WIf QuickBooks is running, try restarting your machine. If that does not work, repairing ,UQuickBooks from the Windows Add/Remove Programs Control Panel may resolve this issue. , ,Error:  p!v :  p! ,'J$kHd@  6An error occurred while attempting to find QuickBooks. , ,9QuickBooks may not be installed properly on this machine. , ,ITry restarting your machine. If that does not work, repairing QuickBooks  ,Jfrom the Windows Add/Remove Programs Control Panel may resolve this issue. , ,Error:  p!v :  p! ,'Jk D G'Jj(kill all the objects that connect to QB..\.`.^A@A@Xnot sure if this is a good place for this or not. Need to check older sum data workbook 6(d OnErrorResume$N!`Gj$GetDataEndTime$N(` H %B@ It A1$NB@ 6(*$ 6( F @ A@>'Bring Excel to the front. WinAPI call.work F @ A@$myDataSheet.Visible = xlSheetVisible$ HideActivity$N!`G 6(*jdaA@PAdded this wait time to prevent the activesheet from getting deleted due to some A@BExcel/VBA timing issue when the debugger is open on a fast machine'Pd` 'PkP DYthe connection failed completely. It only does this when there is an error of some sort.ts c  6( JG9Be sure QuickBooks is running and a company file is open.'Jj Could not connect to QuickBooks. , , J Unable to connect to QuickBooksA@* 6(*$ H %B@$A1$NB@ D e"2we didn't get any **new** data, then tell the usere th  6(ng.  <Microsoft Excel didn't receive any new data from QuickBooks. , ,qMake sure payroll transactions exist within the selected date range, then click Get QuickBooks Data to try again. (No Transactions Received From QuickBooksA@*ntinue 6(*% H %B@HA1$NB@efs JB@tion Pe@we asked for data (and got some) then update what the user sees.st c D "2we didn't get any **new** data, then tell the user  6((<Microsoft Excel didn't receive any new data from QuickBooks. , ,qMake sure payroll transactions exist within the selected date range, then click Get QuickBooks Data to try again. (No Transactions Received From QuickBooksA@* 6(*  H %B@A1$NB@ day w JB@s MDY.d StartDate$N!` LastStartDate$N(`20 EndDate$N!` LastEndDate$N(`A@)calls the single report for this workbook VA@n8don't need the data anymore$$LastUpdateFromQB$N(`/ 6(*$A@ MIf Range("HideActivity").Value = True Then Application.ScreenUpdating = FalseEvent Processing 6( A@ 6($ 6(*h H %B@it yA1$NB@ this  6(eWeShowFinishedMessage$N!` If Len(statusmessages) > 10 Thenoo myPrompt.Label2 = "To view the worksheets in this workbook, click the tabs at the bottom of this window." & vbCrLf & ' statusmessageseEnd If06 B@$kk Pe$A@  6( QData wasn't requested from QuickBooks because the dates you entered aren't valid. , ,ZEnter a valid date range format in the From and To fields, then click Get QuickBooks Data.A@*k(put the statusbar back to the way it waswo d 6(jd be.VA@only do this if the workbook is not saved to disk, so that updates to a saves workbook, even with code, are sconsidered changes6 !(G T (&ji`Ofor each sheet in the file, and for each pivot on each sheet, update the pivot.]]]h HideActivity$N!`G 6(*jA@0 6(dA@Updating PivotTables: 6( T ! T!   T! !' EExcel was unable to update the Pivot Table report on the worksheet '' T!I''. There may be too much data for this Pivot Table to function properly.   Problem updating Pivot ReportA@*kA@k 6(d 6(ih]`P myDataSheet.UsedRange.AutoFilter V%!x(z V!!B@%format known columns in specific ways  V!!!  V%^$AMOUNTKDEBITKCREDITKWAGEBASEK WAGE BASEKINCOME SUBJECT TO TAXKT#,##0.00  V%!(S do nothingnox JB@o] !>$2.  6945%(qHo@]X]x]] D!&' <'(first, see if the toolbar already exists pB@r !>$2. p!vtoolbar exists already' !4' !' !' !' !> 6%2B@@A4delete it, as it may belong to another workbook copyd pB@rk"now, add new one for this workbook !> 6!2%( !>$2.  XL 2007+  l5B@5%. 5B@5B@ !5%(( !*: Connect to QuickBooks.5%( 5%(h5%(ShowUpdateDialog5%(About5%(( 5%(h15%( ShowAboutBox5%(QB Payroll Summary Reports9(qXqPdH  l 5B@ l 5B@ l 5B@5%( #re-create it in the same spot 94 9 9 9dX ToolBarView$N!`94 ToolBarLeft$N!`9 ToolBarTop$N!`9ToolBarRowIndex$N!`9k !5%(( !*: Connect to QuickBooks.5%( 5%(h5%(ShowUpdateDialog5%(54  5%(h Dock Toolbar5%((+Move this toolbar to the upper toolbar area5%( dockToolbar5%(5%(5%(k About5%(( 5%(h15%( ShowAboutBox5%(qk !> 6%2(  D(&.o`(P !> 6%2B@@ pB@ro h%saves the position of the commandbar.]]A@~ D. D!&' !> 6%2!4 ToolBarView$N(` !> 6%2! ToolBarTop$N(` !> 6%2! ToolBarLeft$N(` !> 6%2!ToolBarRowIndex$N(`  D(&.oDim mySheet As Worksheet]H OnErrorResume$N!`GjQuickBooksData T! D!0B@HideData$N!`GQuickBooksData$N!(j T!!!'  T%^'k 'Set mySheet = Nothingih`(for the data sheet, delete all the rows. OnErrorResume$N!`Gj  T!!!B@@QuickBooksData T! D!0B@HideData$N!`GQuickBooksData$N!(jo`]] ]@X0A@~ Detail Data %.TGetDataEndTime$NGetDataStartTime$N \&' T!!! ' %0 Version: Version_Number$N , , QuickBooks Registration Number: QBRegistrationNumber$N!` , , Created:  FirstUsedDate$N , ,Last Import from QuickBooks: LastUpdateFromQB$N , , File Name:  6!D! , ,' p!vG Current Error:  p!v  p!'j  About !*A@*.To p]] UseQBCoInfo$N!`Assemble the Company AddressQBLegalCompanyName$N!`GQBLegalCompanyName$N!` 'jQBLegalAddress1$N!`G QBLegalAddress1$N!` 'jQBLegalAddress2$N!`G QBLegalAddress2$N!` 'j QBLegalCity$N!`G  QBLegalCity$N!`, 'j  QBLegalState$N!`  QBLegalZip$N!`'write it to the sheet headersUpdating Report Headers: 6( T ! T!  T!! FilterDates$N!` FilterDates$N!` T!(A@k T!!   T!(A@k &"Arial,Bold"&13"Employee Time off Accrued and Used T!(k@ A@0 k( 6(o ]( ]H <'" "  OnErrorResume$N!`Gj D!&' !>$2. !4  (k`  D(&.k@o8` 0Sets the drill-down option in the pivot reports.] ] ] ] OnErrorResume$N!`Gj HideActivity$N!`G 6(*j.remember the pivot commandbar before starting,nas the following code causes Excel to move it to front & center, a bad user experience if not compensated for. PivotTable 6%2!4'  PivotTable 6%2!' T !  T!DrillDownSupport$N!` (DrillDownSupport$N!` (/put the pivot commandbar back where it started.  PivotTable 6%2(4  PivotTable 6%2(.T.oh`طAttribute VB_Name = "Module1" Option Ex@plicit@P0riva Dim saveSt*As Varian` Sub Auto_Open()  `isFirst .BooleanlastBuildSng, this 1If Range("OnErrorResume").ValuTrTheXn O"  8NexVL%Se tProdts showWelcomeSh$ee'ff, checkUecel vers. OtooD ojandWB is laund freshsPthe workbook will cloHse.DapaV0C;point p\.UsedDm")" H CTL TNowtE5IfCCEx~=@9" 'don't do any}ng Else @Zgure out ifQPa new @Xl re@se 1= UCase(Trim(A?) G BD\_Numxberŗ6Fa +ActiveWindow.z= CLng(GetSetti@ MCode, "@*rPrefs"ˀ("E$MaT`CustomSortLists sDHCommfBars("PivotTabl{Posi”b `mso 8TopI(Visi *C& &? #%$QA1?O6wo&<,DoEvenAaFCV T@W.Path"C '#lcHeRep9~s(Yu` d!\#OnAf ̎v DBC^t}WZSdd C'W my"NomՁ _Before_ForcHe_C(p@er ݩw_p#|Curr3y@*ٯ= Bx( #?c uW9nc2DOHideityO`/AOI3Zz qDisplayfIs!(lU c) AUs.;ug'we hP two valid I8esrtЏe getЭom QB# 1 'turn Q?bar l-qhK/$K@rtTiň yAle~r@dS5ia;=e@`d<("DetailF xlLscape) '\t: ag`RA dR\ `IdU*1AQuick5kQa"Dg'-r*hmy1yxlgV.C 8ca!"DLL transf@H_, us2waysKP҂K("Q:B .LO 'orshQB2003ahigh)isiQRlledTj  `+0G 1 }T=@ QInyE();J ua rZ;r r.Number = 0 Then Set dsourcemyRunningInstance.GetModule("ExcelDataS\Common.@Payrol.")'errors if can't load dll.If Er 'on ly tro gxQno ^sett up connect ioIApplica.CalculxxlManual S"Save9"QBXLADIN", "Op,sqbQuer yTypeTransaMListGeneral"0)Sub4alletai02DLeveldO@l6"'NPosAWStatuSEitherMNameaeFiltmEmployee{Dt}bAtotalsummaryRows0"fieldaU!;&, ~e, N IDHoc , @N 5rtCEnd, Is  ""! Item!@, OT F cor, Accrued SickVac,B Barl, @#w&Rdat8g v DC #?4Dadi "AFI9 Hs+moun~t a myhee?ńrt@CendD3[?=Autom ceSd@ReceivM= QuNBooksTable@Range()Ó 'forWorksa$% /ElsmyorS@"AnC occurrwhile at7ing to use @TrQ." & vbCrLf_ !&5 may not be i 1llprop$er|on isPchine/'/ "Tre[R'1y-V @tDhaoesw@, repaivrW X "fromWindV Add/Remove Programs 0Cont2Rnel ysol thissu": %` GDescrirX{/%AY$or$$f a rP%py of $$^,S$?/PALfnd:Bo:o: /A/A/A H9@r@d@@4 /*!!!!!!!! !?P6Zp>jDe'kill Pobj@sV$M2eB NoOn~g^@m0m:yuFGr~DoEvents'showUserSxs@jsurjfP Y0Mgood pla | 3. Ne+tcheck old`  qG&b DisyAlertzsTЯ7"$OnRee").Valuq On " 3 xtp Range("GetDataEndTime").Value = Now()  ThisWorkbook.Sheets(curr).Act`ivate`A1:Application.ScreenUpdngzTruH *tatusBa2r%""l SetWindowP os my , -1, 01 (+ 2364!p'Bri=Excel to the front. !API call.323 'my.Visibl3_A "MakE payroransons exipwitp! sc @geDc k   u=try again."aBInformaBNo ToFrom C[=  CCHeRe ports@ow#*F"FF `C5(apg`j)#Fue whaG-es@g6R)2)q) )FH͡ **ve*CBD*_* t #_*_*_*Q_*_*"_*Tb_*DI*Aϙ_+_+ LyStarOA/" 0PS8 '1wL@r97K`/3KA!Tj 'ddo`ne@2ata.morBqQ#QB?|!$N cEHeaders 'FD PU# x  tx Process@X_Q% ȹ 14999ُӆY ShowFini dM|ag5f1!LPen(sms`) > 1Ӯ/' qmy0mpt.@Label2T@o viewwg 6 i 3!, 2tabs $nbott~C:[a`  9  'E žV {-~aB/1*ov&vqGsGreq8ues츑!s because the dates you entered aren't valid." & vbCrLf _ & "2Et af range for@mat inFrom and To fields,n click Get Qu Books @Data."kE4If 'putTstatus@bar baDtoway it was.Appcation.DisplaySB= old%SFmyAShe= NothingDoEv. 'only d@is ifDorkbg not savRdisk, sup as w, e5 with code, sconsidchEIf This"W.Pa= "" en S#F=%@e ZFuncJ  (Pivot@s() 'w each sBHyfil(lp onH ,H.Vim myB As Excel.Tabl'AD f : +SuccessleanCCOn Error Resume NextCPRT(("HXABvity").Value = Tr ThS Scre8enUr Fals,MaintCustomSortListsBAler= KtAF"F!Ns: FE!7my(I C!:J."D.Visi1xl!#!a  _7=B.Refresh(Ae &_ MsgBoxLѡ unL pc T rep7ϡYt_''anaJ ''.Pre m b`oo muf}a/ @) `fp properly.",itical +DefaultButton1, "Pro3m#kP R$?e%showAjIn g.Ad'Yg1WG]A ISub$De`il~() aindex!\Lo' .Used.AutoFilRows(1).Font.Bd Column>s D$`knowspecific`Vy3cm= 1A Coun!Sel@ect CapUQ9.Cellp ,P)dq1B"AMOUNTp* "DEBICREDWAGEBXASE INCOME SUBJECT TOp TAX* @x.%().ЇireC.Numbera`o#,##0.00," EYە q'|zh4C?A(#3.Rubar)S3rWeDialogQr&f:s.xEdockTool',cb,Comm0_c I0= 's(EdAttrits.t0pNKW 1 1.PosH| YsoTop C@/rols.Item(2rb=aAc Cre`@bspDVer=m>y$ D qaldyEx yЙD, rowTB, ptopaleftTBCuQ@e;Kq.2S = xgetc -S' firsteee1 e Ai@.Cr r uA 0"u 'U c?usG0cb%3LB߃J(sXIA_GOV00.DPQte 'diPjat|ldaC(5pysKF70u'0^dd newӁe7S d@Pddd(ч:==r=(h9o!o!lk!!+ >g2!XL 2007+s!.EA)\ntrCAType:=msoT:Popup, Bep1Q W>= 2H1j#Temary:=7|a5  .Capq*?SO >.atipT̬aQ":_nne{ct to QuickBooks ." .Controls.Item(1).style = msoButtonIconAndCaption!@FaceId964!/OnAc[1"ShowUpdateDialog2).?About"4=t;yt49ssUBoxWiQB Payl Summary Re ports End WithEKaElseG cbGAdd Type:=Ċ, Id:=2950, Befor1, T em&(:=TrVu2n+3BǀpVisib9FaQ7 QIf already@ExisteRhen 're-cte it in the sabmpotLP(osiDpTB LeftlToptopRowIndex@rowMkFMRange("ToolBarView").ValM@DkxK`8Hsaf ""6}G=ek_ 1?] Fz.dda02d Yc$'~City ` Zg*)2$t@"aZipC5 'wrihi`t to $l h/wyAusBar"F4pTJT3=FpEachjIn&lj.+Ec|AAFC[Page?up.Right  /OterDSsOA1_BOqqDInProgQ+ 9JIfLe~f8"/ e/ 8=ED+  1 Q* . CaerC4~&""Al,Bold""&13!"Empl oyee q o@ff Accdl aqu"  DoEvs?//Sub ToolbarIfFlo`jdngidcbbXm C1my Lo%#= ge~t`v3R !<= 112\1)On@uor.saveQ?A\Sd7wK1$mts(yt hTD cb.0Posi@5msoPe,Bq1 ed0 q%İDrillDownSupP'pJsRUd-d "oR inpi vot rs. PExcel.TaIb"6pleanS?$?$?8?W1Bs(6creenf=  'rem`erco&7 be`Xe sQ0j,DaCfollowkcode cau0ses pmo8ve qP`& cJ, a bad r exp@eriencf npens0ed Dmy= y@ۇ@ 2./d0-2ble For Each mySheet In ThisWorkboo4k.Ts Pi,vo`v. Ta'`hmy4.SaveData = Range("DrillDownSupport").Valu7?En\3d3)FNext 'put the pgcommandbar back where it st@arted.Application.CBars("ePosiTmy!Visi!Sم= Nothing/ G End Sub kbKd Hg'':PN  l*#*F }26   5 h# dg" <$ <  <%fP% <$ <  < L@(ldh(< K8c4%(d%tH gtD=Ct6D8t H gtaD)t5DKxt H gtaDav")t6Dd(d%lxi4%tH gtD ,t5DV:d]3U:T]3U:4]3U:$]3U:]3U:]3<:4%lxid%tH gtD=Ct6D xf(tDLK=$>$ K.`" Fd%t$ dt HQ`xt lx\\ /`(d%t\ t , ` )t`c\ ,\xt`L K0& ($ H( k&( ^qt ((H(." F%($ d( HQx($ (( l (Qpn x l iL x l i, x l i< x l i\A" F%($ ( d  H )(f ((H(O'%'%'%" F%($ ( d  , )(." F%($ d( HQx(lt E lx:'%(%'%'% %( ( $ )('(%( ( , Qp( lpc%W  5c%W  5-"F%(%W >C63"*F%(%W >C6,%(%W >C6)(%(%W >C6):%(%W >C6):%(%W >C6,%(%W >C6)(1%(%W >C6):%(%W >C6  ccb  lx<c%(%'%( %%( ( $ )(<c%(%'%( %%( ( $ )(<c%(%'%( %%( ( $ )(/(%( ( ,  )(knzL" ," <" \" L4('%:%$ (a" (54('%:%$ (a" (54('%:%$ (a" (54('%:%$ (a" (53"(%( ( ,  )(="*#(%( ( ,  /)(5%(%( ( , )(2(%(%( ( , )(0(%( ( ,  )(  l 5%(%( ( , )(0rU~| QQ) IH)Qy 1)! I Qq  ) y)) ! ! Y*!!1""*  (  }9."W \~i~9~Y y9 р 4Q!a I!q)  ^91 Iy yI ю.! Y1) V9W1138 $ aQi 1d1aQѓi 4/Y1٥iu1qѧ Y Q 1vI3L'P%:`"%$ La,c<]3L5,:K # $", %5,5L'P%:`&%$ La,:<']3L5,4, (,L'P%:`&%$ L,L5, )pzkzs- *F, + , `1t6, JL'P%:`-%$ La, + , `1pL6, ltlpdq.$/ 0 1" L$ L  L<'`%23" 4#PiP%L$ DL,/L+, 55,^`%63" 4#P:P7%L$ L d  H /)LZc`%83" 4#W:P7%L$ L d  H /)L(L'P%:`9%$ L0L" L$ L  L :# ;$< 0l'0/2=$>u3L'P%:`?%$ La,c<]3L5,u=$> @" L$ HL L,pt(L, K" x$ x  x A  B BA`" Fd%tx$ x d t H` )xt`  +^L 55L0$ xt`LK ;$< kp^Dq G H I=$> G H I)6" $   )=$> G HOt45)=$> G HOt,54 ('%:J%$ ,5" $   Y KC LkJld % $   G'T'd:~N@j*#j*#*F }26dT" $   2lXF%;$<  dvw)('%:9%$ 0=$>O'%:%$ a%'D%:%$ ,)5O'%:%$ a%'D%:%$ ,)5  5 < M4 ('%:%$ ,5" $    &:% $    :&:'% $   " $   2lXF%;$<  dvw)('%:9%$ 0% $   3'%:%$ ac]35$ kJ :% $   ?'T'd'j*#j*#*F }26dT#k $    c=g< :# ;$< 0l'0/k ;$< HP8 l@$ (PT<XLd|xtdTpK3<'@%:PF%$ F:xjh:XjH`1x) P<460\<xX$hH D PP lDRP)`lx*#D PP lD#@*#<*#48 << ,l8*1x2 @<48)P<0''"*F@xM@@ }6 c=gt/CHh4Ttxd#@<84P<4\<xX$hHdK3P'T%:d%$ Pa0c@]3P50:5P'T%:d%$ Pa0:@']@P50;P'T%:d%$ Pa0:@ `1tP60 5P'T%:d%$ Pa0:@']@P50&GltF@P'T%:d%$ Pa0 :`1tP60 5P'T%:d%$ Pa0:@']@P50GltF@P'T%:d%$ Pa0 :`1tP60 5P'T%:d%$ Pa0:@']@P50GltF@P'T%:d%$ Pa0 :`1tP60 ultF@P'T%:d%$ Pa0 :'%:%$ a`1t)P6 0 &:d% P$ P  P!P;$< QP[xg: x gl$SPx lgPa0`F ]'T%:d%$ a@)P60 JP'T%:d%$ Pa0`F %x lg,)P60 0 50,Px lgPa0`#lt=/P50t@Px lgP,P 0 50&*F0%Px lgP,P50 : xg%fd% P$ P  Pd4tx,P0 T ^qtlt 3P'T%:d"%$ Pa0c@]3P50RK0 P$ HP kdP." Fd%P$ dP HQxPx l x 'V P$ HP P c= x:h(xP0 3<'@%:P"%$ _K3'`("F<xME4> LL"LLLL<8<<<@ ` $o `dor c`\@@L x `Do   `Hlo ^^ `d@ T %@"D @$4 %@&P$ @( .0`po ~I$ I" 8`d 0`op I$  I"  Mon`d`4b `6`0@% h8h8X@l '$ 0Nt6Jx.0@P `@ x@ @ @ @( @ @ @ @@ 8@| P@l h  %@8hxH (@.l 8 X@`T p@D @4 @$ @ @ @ @ @P 02J $@@ `@ x@  p X8@l  insH ^%Jp f @h @X @T @D %pp  p @0l  p @ P %@ @ llDe@ 0 vt2J@P @8  @h @ h@ @ @ @ @  X@p @l  Jp@ H @ 8 @4 @$ 0/J$*\Rffff*CF4acb4f92*\R1*#2ac*\R1*#e8*\R1*#1c8*\R0*#12*\R1*#d7*\R1*#1c7$*\Rffff*CD4acb4f92*\G{AC2DE821-36A2-11CF-8053-00AA006009FA}#2.0#0#..\..\..\..\..\WINDOWS\system32\FM20.DLL\2#Microsoft Forms 2.0 Object Library*#45*\G{AC2DE821-36A2-11CF-8053-00AA006009FA}#2.0#0#..\..\..\..\..\WINDOWS\system32\FM20.DLL\2#Microsoft Forms 2.0 Object Library*#44*\R0*#13*\G{AC2DE821-36A2-11CF-8053-00AA006009FA}#2.0#0#..\..\..\..\..\WINDOWS\system32\FM20.DLL\2#Microsoft Forms 2.0 Object Library*#420  B  Jhx ((V 0))  ( %8 >H% +   IfC9 ContinueButtonE@#AS MQ'.End;TrueD7lsDFa!a$"reactToChoice"awtodayvC$Qu`erse`archYmM/h c`/Range("OnEaC")c)5# W ل#= xNow dA paaa.Wor@ksheet%.RoundUp((B) / 3, 0dc 2)Selector#"Last  "CO = 1,./- 1g 'B @12EE: E OEuCtBegin$ #,' `w! ,>,߬B,\?)r߭# i08rO2%M?ch8t{m| 3/,4/*6k/rp4/,7/*9(1$fS+M+x+#? A0=+_?) ?Z?5 w 57nt^h s $$ tB_ This qp a>3 0 hO rl82p  ? Pv) +Z ((/)_ _U/)?1a B/eO E   b ( T/dU-8QC 'TTZ-T(T,Z-T+TqZ-1m;[NNrL/Mǰ'  (Cĥ| On Error Resume Next temp = DateValue(searchY & "/"$Month&"1")UpdxReports@.Start.a End Functio n  set1zg,CgDim K \As}mI@ntegerdy= 27'plus 2 (below) i9, t he shtest ma dtay"my While  6<1+ 1AifF /oneAn;En we phaveKwan!8T(AXSerialxY\@@ )\WendC#]0dyˈ{Z__SRP_14 9 __SRP_15@Module3=. __SRP_e!<;`QQ) ) ZQ "UXyZ!YIYUUYYZ[[W \[y\PKV8H$  H 8 $4$  4 $ )H468$G)8H$  H 8OtdH58)8H$  H 8Ot\H58 odo\E%8H$  H 8LH>8H$  H 84$  4 )H458'L88H$  H H58XP,lLH48$KVXh$  h X DT$  T D )hT6XD}h$  h 8hh$  h 8h8(lhTXD3'%:%$ ac]35:K Otd5idM@ (Bk%k%$  |@BklT)6|%$   , : ]3#dM@ (]35C%dM@ (D5 ( 4dM@ D%dM@ (45D4 5D4  5:]3T(]3%dM@ (D5dM@ DT(]3< ( 4 ( $T(]3e (4 ($T(]3 (4 ($T(]3 (4 ( $D4 5D$  5:]3S%dM@ (D5 (4D4 5 ( 4D4  5:]3dM@ D (4D4 5 ( 4D4  5:]3/%dM@ (D5 (4D4 5 ( 4D4  5:]3dM@ DdM@ 4D4 5D4  5:]3dM@ DT(]3 (4 ($dT(]3 (4 ($dT(]3> (4 ( $dT(]3d ( 4 ( $D4 5D$  5  5<$lT$4D |KQD:T4$:: Otd/6 4%od4$   54(l(4DKp` PUpbkbDP]@3u k`p`7k`@UPU0 0  Upb60 R@:P0 :k`D Otd/6 0 %od0$   50(l(0 WrU $`$`$`,`a//,!`a//nrU (`#n6I7rU $ ng ExpenseQualified Moving ExpenseMedical Savings BenefitPremium Only PlanMedical Care Flex SpendDependent Care Flex SpendOtherNoneD1'< < 6%@'>? > 6B@B :G <F 6B@Dj second array,(:L^p1-Jan2-Jan3-Jan4-Jan5-Jan6-Jan7-Jan8-Jan9-Jan1-Feb2-Feb3-Feb4-Feb5-Feb6-Feb7-Feb8-Feb9-Feb1-Mar2-Mar3-Mar4-Mar5-Mar6-Mar7-Mar8-Mar9-Mar1-Apr2-Apr3-Apr4-Apr5-Apr6-Apr7-Apr8-Apr9-Apr1-May2-May3-May4-May5-May6-May7-May8-May9-May1-Jun2-Jun3-Jun4-Jun5-Jun6-Jun7-Jun8-Jun9-Jun1-Jul2-Jul3-Jul4-Jul5-Jul6-Jul7-Jul8-Jul9-Jul1-Aug2-Aug3-Aug4-Aug5-Aug6-Aug7-Aug8-Aug9-Aug1-Sep2-Sep3-Sep4-Sep5-Sep6-Sep7-Sep8-Sep9-Sep1-Oct2-Oct3-Oct4-Oct5-Oct6-Oct7-Oct8-Oct9-Oct1-Nov2-Nov3-Nov4-Nov5-Nov6-Nov7-Nov8-Nov9-Nov1-Dec2-Dec3-Dec4-Dec5-Dec6-Dec7-Dec8-Dec9-DecDl'< < 6%@'> > 6B@B :G <F 6B@Dji6Attribute VB_Name = "Module3" Option Ex@plicit@P0riva @ FuncVMaintCustomSortLists(add As Boolean) 'If a "matching" c5 l2 ex, AutosH a+ically s various pivot fie@lds usM theI Orror ResuNex Dim myArray, nPInteger'first a("Compensa", "Allocd TipsRepde axable Group Ter@m LifeFrbe BenefitAdo+ -NT"Si@ck Payederal WithholdC- Soci Securit A7anEmploye+Med]@fr FUTA!AEICm#t,S ,UrIJ$UI @SDD I D6@Lid OrEK LsQ401-kARoth @(k)403-bQ3(b8 457 57 DW@5cSBiTe IREDe@dent Care DeduA AddiE-Quali@d Plan7Mov@{W6o7l SaxRPremium Onr!bFlex Sϋbe"atnmpl.Get#Num(drAHDeletre nxa= True Th~eH*~:=  'second:1-JanU2345U6789_CA#i"1-TFeP234U56789 Mar3-456789 Ap 3-456789"2 Ju@@@@@@@@ lMu   qqqqb'&AugsuSepSs3-45U6789'uOcv2-U3456Յ7891uNov 3-U4567u89uDRee2-34U56789X1gXXXLXXddXayXEnd A@ @0 @H @` @x @ @ @ @ | @__SRP_fEpModule4:c7__SRP_aA?c__SRP_bG@F<xMEP6 LL<<<` 0`|o@ i:h @<@\ `>Z"if8%x`h@0l h6 T  @D @ 4 @8$ @P @h @ @ @ @@ @ @ @ @( @@t @Xd @pT @D @4 @$ @ @ @ @ @0 @H @` @x @ @ @t @d @T @D @ 4 @8$ @P @h %@ @ @ p@ @ @ @ @( @@t @Xd @pT @D @4 @0 YT@, %@ @ @ @0 $@H @` @x @ @ @ @| @l @\ @ L @8< @P, @h @ @ @ @ @ @ @ @( @@ @X | @p l @ \ @ L @ < @ , @  @ @ @0 @H @` @x @ @ @ @ | @ l @ \ @ L @8 < @P , @h  @ @ @ @ @ @ @ @( @@ @| /J$*\Rffff*CC4acb4f92*\R0*#17*\R1*#2ac*\R1*#e8*\R1*#d70  B  l .@$X 3h `r. $0  3@ ` p xpeIf a "matching" custom lists exists, Autosort automatically sorts various pivot fields using the listxp]`x first array CompensationAllocated TipsTips Reported TipsTaxable Group Term LifeFringe BenefitAdoption BenefitsNon Taxable Sick Pay Federal TaxFederal WithholdingSocial SecuritySocial Security CompanySocial Security EmployeeMedicareMedicare CompanyMedicare EmployeeFUTAAEIC State TaxState Withholding SUI CompanySUI SUI EmployeeSDI SDI Company SDI EmployeeCompany Paid Other Tax Other Tax Local Tax401-k Roth 401(k)403-b Roth 403(b)408-k457457 Distribution501-c Simple IRADependent Care DeductionDependent Care AdditionNon-Qualified Plan DistributionOther Movi*\R1*#2ab$*\Rffff*CA4acb4f92$*\Rffff*C@4acb4f92*\R1*#2ac*\R1*#e8*\R1*#1c8*\R1*#d7$*\Rffff*C=4acb4f92*\R1*#f1*\R1*#dc*\R1*#91*\R1*#e4*\R1*#e4*\R0*#14(*\Rffff*C@4acb4f92\0*\R1*#1b*\R4*#8c*\R4*#4d*\R4*#4e*\R1*#1c4*\R0*#f*\R1*#5a*\R0*#13*\R1*#2270  B pD' B 228p "x R D'HB(pJ'xLBJ' PBpH'FBXF'`'-F<xME`@0> LL"LLPLrU~| )5q5551666I77 8i88)9991::::;i;; <Q<q<<<i===>A>i>>>>I?q? @@@AAaBB)C DDD!UQQ)QDD!EIEqEEEEF9FaFFFFG)GQGyGGGCC??;3 H1HYHHHHH!IIIqIIIIJ9JaJJJJK)KQKyKKK L1LYLLLLL!MIMqMMMMN9NaNNNNO)OQOyOOO P1PYPPPPP!QIQqQQQQR9RaRRRRS)SQSySSS T1TYTTTTT K0T:DlT:4lT:$lT:lT:lT:lT:lT:lT:lT: lT: lT: lT: lT:t lT:dlT:TlT:DlT:4lT:$lT:lT:lT:lT:lT:lT:lT:lT:lT:lT:lT:tlT:dlT:TlT:D lT:4!!lT:$""lT:##lT:$$lT:%%lT:&&lT:''lT:((lT:))lT:**lT:++lT:,,lT:t--lT:d..lT:T//lT:D00lTT4 1TZ4\., \02$3 40 t5l,pZ0$ kZ02$3 40 50 ( 'D%\02$3 40 50kT:D6lT:47lT:$8lT:9lT::lT:;lT:<lT:=lT:>lT:? lT:@ lT:A lT:B lT:tC lT:dDlT:TElT:DFlT:4GlT:$HlT:IlT:JlT:KlT:LlT:MlT:NlT:OlT:PlT:QlT:RlT:tSlT:dTlT:TUlT:DV lT:4W!lT:$X"lT:Y#lT:Z$lT:[%lT:\&lT:]'lT:^(lT:_)lT:`*lT:a+lT:b,lT:tc-lT:dd.lT:Te/lT:Df0lT:g1lT: h2lT:i3lT:j4lT:k5lT:l6lT:m7lT:n8lT:o9lT:p:lT:|q;lT:lr<lT:\s=lT:Lt>lT:B 0 8 -@ ,JX  .   " | ` PCh TC XC LCh JC NC NCX FC  " 88 *8@.Up Z :!@ 2X x ,88  " 1  ( "08@ *8H.Ux0A1 ,8 "@PX B `h p % "/   %/   0@ "H X "hxxpjfigures out if we've ever used this tool before on this machine by looking for one of the default settings ! UserPrefsWelcomeNotFound$NotFound0' d ' ki@+returns the last build used on this machine% ! UserPrefs LastBuild$'$&iLCreate machine options; if they don't exist then use those in this workbook. ! UserPrefsWelcomeNotFound$NotFound ! UserPrefsWelcomeShowNewUserMessage$N!`A@k ! UserPrefs UpdateReportsNotFound$NotFound ! UserPrefs UpdateReportsShowUpdateOnOpen$N!`A@k ! UserPrefsFinishedPromptNotFound$NotFound ! UserPrefsFinishedPromptShowFinishedMessage$N!`A@k8 ! UserPrefs ToolBarViewNotFound$NotFound ! UserPrefs ToolBarView ToolBarView$N!`A@ k ! UserPrefs ToolBarTopNotFound$NotFound" ! UserPrefs ToolBarTop ToolBarTop$N!`A@.k ! UserPrefs ToolBarLeftNotFound$NotFound ! UserPrefs ToolBarLeft ToolBarLeft$N!`A@xkp ! UserPrefs ToolBarRowNotFound$NotFounde ! UserPrefs ToolBarRowToolBarRowIndex$N!`A@k ! UserPrefs WindowStateNotFound$NotFound ! UserPrefs WindowState JA@kXoPFCall this routine to save the current workbook settings to the machine ! UserPrefsWelcomeShowNewUserMessage$N!`A@ ! UserPrefs UpdateReportsShowUpdateOnOpen$N!`A@9if ! UserPrefsFinishedPromptShowFinishedMessage$N!`A@ ! UserPrefs ToolBarView !> 6%2!4A@ ! UserPrefs ToolBarTop !> 6%2!A@ ! UserPrefs ToolBarLeft !> 6%2!A@ ! UserPrefs ToolBarRow !> 6%2!A@ ! UserPrefs WindowState ,!.A@ ! UserPrefsPivotCommandBarPosition PivotTable 6%2!4A@ ! UserPrefsPivotCommandBarVisible PivotTable 6%2!A@ ! UserPrefsHideDataHideData$N!`A@]] $$"$'Version_Number$N!`$"$'   ! UserPrefs LastBuild A@k0o(0vUpdate workbook preference based on the machine settings. Essentially, ignore any conflicting setting in the workbook. ! UserPrefsWelcomeTrue$ShowNewUserMessage$N(` ! UserPrefs UpdateReportsTrue$ShowUpdateOnOpen$N(` ! UserPrefsFinishedPromptTrue$ShowFinishedMessage$N(` ! UserPrefs ToolBarView4$ ToolBarView$N(` ! UserPrefs ToolBarTop100$ ToolBarTop$N(` ! UserPrefs ToolBarLeft100$ ToolBarLeft$N(` ! UserPrefs ToolBarRow3$ToolBarRowIndex$N(` ! UserPrefsHideDataTrue$HideData$N(`op1Show all the user sheets, if macro's are running.] OnErrorResume$N!`Gj HideActivity$N!`G 6(*j Please Turn on Macros %! Welcome %! 4show each sheet that is hidden (but not very_hidden) T ! T! LG  T(jkx NPlease Turn on Macros %( NWelcome %( 6(*A@Time Off %.T, TB@Hooks f.To] OnErrorResume$N!`Gj , HideActivity$N!`G 6(*j,Please Turn on Macros %! Welcome %.Tng t  T(Bookk NPlease Turn on Macros %(oper 6(* machiA@o0 R setForSpeed ~ 6(|work 6(*g Quic T$Vd T!(X T!(e k  R setForDisplaye this  6(| T$V T!(X T!(k  6(* 6B@G 6(*(kik ix p Attribute VB_Name = "Module4" Option Ex@plicit@P0riva @ FuncVisFirstUse() As Boolean  'figures out if we've ever used this t1 before |machine by looking "f6e default set tspIf GetS(pro"dts. Co de, "UrP refs"We lcomeNotFound")Á ThegiCxTrue > uu cg gd5gptions() 'Update workbook preference based on the machine settings. Essentially, ignore any con0flicJZ iC. On Error Resume NextRange("ShowNewUserMessage").Value = GetS(prodAttrits. Code, "7Ps" Welcome 8Tru$4On0Open3"Re0port<6Finished>l$@PromptoToolBarView7m @T4"qDkTop@100Left>YRowIpndex~e3 3HideDataF1řEnd Sub  sSheetl'Ak `w{ul@yf}@ro's a@zrunn~DvDim myb As 6WXeviIf AOnb{C{( Then A`vity(Appa.Screenp @`FalseTXhis.""Ple TurnMacrosA isiblx lbVOr _C )r   r'A5 ec1@3at is hidd%(but not very_׃$pFE3In,  -.E= d`/b5 QIf#/n x/c ?.HUDoEvsφaB=q-("TiO ff%(SeleFcNotg x"Q!87rwl# 6:cv:zWe: G: "s(:::;6/@$/@. .7V*?OH7*#FunSPULevels(&sM\SГng, OᲡal r&^G%= "`ISpeed"902en ai Ca0lculr\[xlManualo0/_(_!IsMissa(( )ag, 1h.P00#up.Zoom@ geFitTosW@~"E@jO@Displayo'oofAutomcW}t 3t1 ..$q2 %:h%$ Ta4cD]3T54?K3T'X%:h%$ Ta4cD]3T54" T$ T TA :h%T$  T d  W4 X]3)T 541 :h %T$  T d l = x)T  x 8X% :h%T$  T d  )T " T$ T T \(xT 4$ K 00% h$ h $h" h$ h h/hhMX @ 1pVlh= /kVh(Xd%hH l h,hfX%hH l h,h 20% h$ h $h/hhMX @ 1pVlh= /kVhffX%hH l h,h(X%hH l h,h" h$ h h h$ h Th" h$ h h8(lhH$ TaDh" /hT5D':l%" #h0/hBT'X%:l%$ TaDh" /hT5D':l%" #h0/hBT'X%:l%$ TaDh" /hT5D':l%" #h0/hBT'X%:l%$ TaDh" /hT5D':l% " #h0/h; #h " /h8@$ hTDx`$ `$ `$ `$! `$I `$q `0 `0n%@X$ X d@ H&< 'l8#D"fWFa<prodIDN__SRP_80Bq__SRP_9uqdefaultReportrgFxRRME(H\> < <\h0h*H0h`h>x h^!rU~|  3QQ)9.Q.  ./9/ *1 HY*292 42(213I 3 !y44444)!!1" y))Ay xD':h% " #d0/d3pz<pzD$ dX$:h%" 1x$(x |@K':l% " #h0/hpBT'X%:l%$ TaDh " /hT5D':l%" #h0/hBT'X%:l%$ TaDh" /hT5D':l%" #h0/hFBT'X%:l%$ TaDh" /hT5D':l%" #h0/hBT'X%:l%$ TaDh" /hT5D':l%" #h0/hBT'X%:l%$ TaDh" /hT5D':l%" #h0/hBT'X%:l%$ TaDh" /hT5D':l%" #h0/hBT'X%:l%$ TaDh" /hT5D':l% " #h0/h; #h " /h8@$ hTDx$KBX'\%:l%$ XaHD " /DX5HBX'\%:l%$ XaHD" /DX5HBX'\%:l%$ XaHD" /DX5H`8<" Fl%@X$ X d@ H&< 'l8#D" /D)X@<`8<" Fl%@X$ X d@ H&< 'l8#D" /D)X@<`8<" Fl%@X$ X d@ H&< 'l8#D" /D)X@<`8<" Fl%@X$ X d@ H&< 'l8#D" /D)X@<;X$ DXaH"#D " /DX5H\8<:l(%@X$ X d@ H&< 'l8#D)" /D)X@<\6<:l(%@X$ X d@ H&< 'k6#D*" /D)X@<BX'\%:l%%$ XaHD%" /DX5H- +FH , - `106H JX'\%:l.%$ XaH , - `1,X6H l,l0ql," p$,,0(DX@<H \$KC:l!% " F8%H'L%:\%$ H,H58C:l!%" F8%H'L%:\%$ H,H58C:l!%" F8%H'L%:\%$ H,H58C:l"%" F8%H'L%:\%$ H,H58C:l#%" F8%H'L%:\%$ H,H58C:l#%" F8%H'L%:\%$ H,H58C:l$%" F8%H'L%:\%$ H,H58C:l!%%" F8%H'L%:\%%$ H,H58T$$ H8`3T'X%:h%$ Ta4cD]3T54:K3T'X%:h%$ Ta4cD]3T54" T$ T T :h%T$  T d  W4 X]/$:D %$   d W ]/)T 64t!T$  QT[x t x lg x x 58X% :h%T$  T d  )T 8X% :h %T$  T d  )T " T$ T T 1 :h/%T$  T d l = x)T  'h%x c= x`0x0 T 4$K3T'Xlcom@% `H|+ @Z@%/J$*\Rffff*C@4acb4f92(*\Rffff*C@4acb4f92\0   (08 @ "H& P: x0 (  ( 8x^^0^H^`^xp@] QuickBooks_Payroll_Vac_1x (-QuickBooks Payroll Sick and Vacation Workbook (*teOpti#QB Payroll Sick and Vacation Report (>Get Sick && Vacation History ( Transaction (^oEAttribute VB_Name = "prodID" Option Explicit @ Type u ctAtrs &Code As Sng. .getButtontoolBardataDescriptor mEnd Pub ts) Sub SetPxl()[ .mQuickBooks_Payroll_Vac_1x_a  S$ aZ aWorkb-% 'B#Report" #Get!&& F!HisVy _TransacA/ `TA`rU~| 9+ ,,q--h8 T T T T T8$ krU $`nrU $20 ClientLeft = 45 ClientTop = 330 ClientWidth = 7860 StartUpPosition = 1 'CenterOwner TypeInfoVer = 30 End (H  @})R KQDBTahoma(24Label1ue( ' 5Tahomael( 2-digit year  @Tahomael( 4-digit year  @Tahomaelfff*CK4acb506d*\R1*#e4$*\Rffff*C=4acb4f92*\R1*#f1*\R1*#dc$*\Rffff*CA4acb4f92*\R1*#e4*\R1*#1c8*\R0*#17$*\Rffff*CH4acb506d*\R1*#10*\R1*#1cc*\R0*#f-0   (08@HPX`hpx    (08 B @&H p&  nRF?6FxRRLLRR$$R@RxxMEX @HbHH0>  P"LL L <\<`@ABCD 4  10 ,P    N NKP2<p   $B $; $;  4Hh px  RK&; 6< X.Hp  2$; $;H$;p$;$;$;  4 "8 4Q` &;4Q  ";4Q( `h p 6!x  b" O@ X x H    *@  @  :8  4x     .  6     d 9 9 L h`  D `! p 2# 9 9 9 9 98 9X 4Qx 4Q &> &> D8   "O  <   0 0( 0H0h8 *d*d 660 h    B    K=   ( @ P ` p    !     8 H ` p            ( @ P h  x     H   0xp^^0^H^`^x^^^^^^^ ^8^P^h^^^^pH^^^(p @^X^p^^^^^^^^0pH]](H`x] ]8]P( ! UserPrefs empPageBreaks$'nd$Time Off $. Detail Data %.%ActiveWindow.DisplayGridlines = False setForSpeed A@Prts  A@Hspin through the source data sheet and figure out all the used EmployeesOnHcache key data per employee, so we don't have to dig around for it later  !!!   !d %^<a new employee %  ' @  !d %^ $(  !v %^ $(  !x %^ $(eWWW  !d %^'k'Lspin through the source data sheet create a list of transactions by employee  !!!  !t %^Paycheck   ! %^Ba new transaction   $!  !d %^GyjX  ' @+these things we just load once. Saves time.  $(  !r %^ $(  !p %^ $(  !| %^ $(  !~ %^ $(  ! %^ $(  ! %^ $(k  ! %^' accumulate time totals here $!  ! %^ $(  ! %^Vacation $!  ! %^ $(k  ! %^Sick!> $!  ! %^ $(olBakk  @(3add blank to the end [now, write out each transaction, adding subtotals and line breaks when the EE index changes User=R[1]C-R[1]C[-2]+R[1]C[-1]' !!!B@@   Pi  $!A@ Bneed an employee section title every time the name is new employee  ' $!$!  ,^Hi  %^!x(z  %^!x!  %^!x(`$"  %^  %^ %N(Ts and some report titles0  '  %^DateChk Num Period Start Period EndHours Vac AccruedVac Used Vac Bal Est. Sick Accrued Sick Used Sick Bal Est.D sectionSubTitleA@Jsage$ v  %^  %^ %N(nue  'Upk  ' (F  %^ $! $! $! $! $! $! $! $! $! D A@Js   %^( To   %^(!  %^  %^ %NbodyAmountIfNumericA@b!   G  %^  %^ %NrowDelinateGrayLineA@bj=subtotal here, after writing the last thing for each employeell t $!  $!C4a new employee or we just wrote the last transaction  'ty=SUM(R[   ]C[0]:R[-1]C[0])' Turn   %^(`   %^(`   %^(`eet th   %^(`_hidde   %^(`   %^(`(j  $!$!  %^(`  $!$!  %^(`=R[1]C   %^(=R[1]C  %^(  %^  %^ %N bodySubTotalA@b   % !B@kHk@ $!'($remember this transaction's employee mm/dd/yyyy %( mm/dd/yyyy %( mm/dd/yyyy %(# %( !!B@ %!  %( %! %( p %^  %^ %N(n  %^  %^ %N(n setForDisplay A@P..i` 0]H (t  !!!  %^$NAMEKT  (d6 PAYROLL ITEMKTim  (fsAMOUNTKT  (nINCOME SUBJECT TO TAXKT  (l WAGE BASEKT  (jNUMKDOC NUMKT  (rDATEKT  (pTAX TRACKING TYPEKT  (h SICK BALANCEKT  (vVACATION BALANCEKT  (x IS SOURCEKT  (z PAY STARTKT  (|PAY ENDKT  (~TRANS IDKT  ( ACCRUED VACKT  ( ACCRUED SICKKT  (HOURSKT  (PAY TYPEKT  (TYPEKT !tG  (tj=!there are two type columns. Oops.n i Attribute VB_Name = "defaultReport" Option Explicit@PrivatModule Type myRptC@ols n As Long(pItem*TTEamtWageBaseaISTTdcheckNdum Rtxg \s@ickBal vac isSourcYpaySt arayEnd/transID GAccrueI ?h@+s $  yEmpx0Sw!IanceVaprian@%aoKTA>CempIndexuPayYR3w 'chŁhrsTtlADoubD2XUse>dPkT IDFunccre()GDim r ptSht)Worksheet, pref:h, s `+ub-0geS 7)=!FsF, e myMatchBoolean, 6Filt er., qtrglast`Ow!BC!I2D txTblBformullaPa.kjCGList$()amy, \txIYOrror ResuqNexdK= GetSettA(prodts.aCode,$ "`HrP@>s"TrueE F= getA!erredH("TiOffxlP`raitI= Thisbook.SaOs("Detail Data" D'AXveWindow.DisplayGrid linesFals!lset UpELevels "@ForSpeed^f Ђ]YDC'spin t@hrougheL sbRa g and figure out aTllu{ ;loyee 'ca keypZ/Bo we don't have to di8g aa @it4 lzr s`hx"2 To.Range.Rows.Cou3%If c<>Cells( )D .n)6en 'a new 1P3=p+ 1Re?q #ser .1  }#. v . 9f=/ I.T  iE~ Ig !^If?~"0!o+o+a a lH of acs by&a&&s)"@y"& *Z*xw* O[ g= (UB2d('< ()/*4A%4Ex < WqRi=b5c5d o 'thesEhRsGjusA`Eoad o.D SGs t].o .G?/ Numo ErQ<#<S~x  : HD{ I_3 EH1!H9/ % 9!'acc^uѕ'ot0~ hert~%D2XT+^^5FKKBKVacOKc J 0Ay   2  ;VR S@ .s%ickUsedTtl = txList(txCt).s+ sSht.Cells(sIndx, sCols.hour) End If& 0Next2 ReDim Preserve1 To UBound) + 1) 'add blank to t@he end O'now, write out each transaction, Aing subtotals aWline breaks when-EE index changes3formulaS"=R [1]C-[-2]+1]"XrptR!.Rows.Entire.DeleteForCt/- 1If lastEmp <>empԀ]Tf'needz loyee seF titl@Tverymc Xnais nstd@olerh%^*\G{00020430-;C 0046}#2.0#0#C:\WINDOWS\sys@tem32\e2.tlb#OLE Automation0MSForms>SFFrms3 ED452EE1-E08F-101A-8-02608C4 D0BB4EFM20.DLL#Microsoft rU~| LQX HY*Ai~  . y dAyi ѸI)q!Uamu9giq9eɳ9i Ia)1Q )Yٽ!yQٿ AKc%" FYC h/1:%$   d l= `)h C /5`  5KX `  aapv")6pdhG:(0%l\i%(H%h C)5>:(0%l\i%(H %h C)5l\i%(H%h l\i(%( %h pph  Y1CQ  + /) 6p Ol\i%h  4oH%h  )5llA1 f Y0:H2%(%h C350:H2%(%h C350:H2%(%h C350:H4%(%h C358 h  a)5d(%h Ap5(H%(8%h C5)6pd( %h Ap5(H%(8 %h C5)6p(%(H%h l\i(%(%h p%ph  ,)6p(%(H%h l\i(%(%h p%ph  ,)6ph6C /5 c= h c= `` ldh!i =T !a) =  ` F  p|x.dAy<K  Khd H  daTPPa@v")dP6T@d8((%lhi%dH dT@ 7@d5T:(8]3 lh:(9]3 lh:(:]3 lh:(;]3 lh:(<]3, lh :(=]3J:>]3W lh:(?]3t lh:(@8xh0 H`ZطaIF7}YC[^ ^ Eo7<ClN?pH7LWbk{ =/@J+0^J0 a'C=ᘵFE>9|`T(LMBEIQbMЧ1}mw^@Z]4acb4f92Module13; P eModule2CF4acb4f92Module2< "Module3CC4acb4f928Module3<Module4CA4acb4f92HModule4<- prodIDC@4acb4f92Z prodIDa<]defaultReportCR4acb506d`defaultReportH6Png (prodAttrits[prodCode-^twoDigit_ClickX myPromptoContinue_Click5Hide9zUserForm_Initialize5cmyVertContinueTDefaultCaptionxprodName# newVer mOK_ClickRNamesοRefersTotitle1{RepaintrelNotesSetFocusSelStartZ Sheet1 Welcome MyOK_ClickActiveWorkbook(HideToolbarIfFloatingMyOKW UpdateReports beginEnterf beginExit#endEnterendExitm savedState4StartDate_KeyUpaKeyCode ReturnIntegerShiftgetResultingDateQ EndDate_KeyUpJkkeyAscii#currDateHmyChrHjoldDate thisDayOfWeekgLCase:ReplacefIsDate2DayMonth DateSerialUYear6nWeekdayvbSunday&(setFocusToThisWorkbook~ DateSelectorAddItem IntegralHeight| ShowOnOpencVisible(reactToDateChoice? empPageBreaks  GetSetting Cancel_ClickwsName؀xlSheetVisibleappVerOK (FixDateOrder@ (isAppVerOK Activate|(GetData((applicationVersionCheckpointDateSelector_ClickT8StartDate_Enter5sStartDate_Exitl ReturnBooleanemagicallyFixDateStartDate_Change1~(setContinueButtona EndDate_Enter] EndDate_ExiteEndDate_ChangehUserForm_QueryClose CloseMode؟thisStempSnCtempS1tempS2 myDateOptionLabel1,Show Sheet2 x_GeneralCodeU' (SetWindowPosNhwnd/hWndInsertAfterxoylcx\cy\wFlags܋user32*(GetActiveWindownE(showWorkInProgress7 StatusBarʜ(appWaitOneSecondVnewHourC newMinute newSecond**waitTimeHourќNow%MinuteamSeconds TimeSerialWaitappNum (minAppVer.appVer-ch\builtSI>version(getVersionStringwtoolName]isOKv vbCritical+} DebugStuff:u Module1b saveState" (Auto_OpenV isFirst~ lastBuild thisBuildp4(SetProdAttrits(showWelcomeSheet3? (isFirstUsetTrim@ (lastUsedBuild*(setDefaultMachineOptions\m(readMachineOptions&ScreenUpdating!  ActiveWindow+ WindowState|(MaintainCustomSortListsI CommandBars Position msoBarTopypreserveSaveState(setCurrentMachineOptionsf(commandBarSave( toolBarNameDeletexnRowso dataReceived!{myWin currSheet myErrorS[ dllSourcePath lastSeparatorf askedForData firstColumn'YmySheetb myDataSheetnstartD endDCdsourcemyInstanceFinderEmyRunningInstancemyErrlv oldStatusBar:statusmessagesՊ ActiveSheet%NDisplayStatusBar xlLandscape&(deleteQuickBooksDataTableRangeǓErroClear CreateObjectNumber-GetAnyInstance GetModule CalculationhxlCalculationManualGetPayrollDataxlCalculationAutomatic Calculate(setQuickBooksDataTableRange Description (showUserSheetsICursorl xlDefaultwQ vbInformationn (createReport[^(updateReportHeadersU (updatePivotsmyPivotsc PivotTable updateSuccessV PivotTablesw RefreshTable.vbDefaultButton1(formatDetailWorksheetIindex UsedRangeȉColumnsp9Count0v EntireColumn(ShowUpdateDialogF (dockToolbarcb\ CommandBarControlsKItemz thisAppVer myControl{CommandBarControlPalreadyExisted@rowTB positionTB}1topTB leftTBjTop5RowIndex6dmsoControlPopupl)Before Temporary getButtonName TooltipTextb?msoButtonIconAndCaption1lFaceIdiOnActionmsoControlButtonnId]msoBarFloatingmsoButtonCaption BeginGroup(commandBarDeleteemyBookWorkbookk realUsedRows RefersToR1C1c EntireRow xlShiftUp (showAboutBoxtempR transferTime#R transferRate"FullNameО CoAddressvbCr$ LeftHeader CenterHeaderD(SetDrillDownSupportI myBarPosition{ myBarVisibleTSaveDataEnableDrilldown+7 Module2c d_StartDate d_EndDatetemp3NCEnabled۪today  todayQuarterp] searchYear searchMonthsearchEndMonthchoice{WorksheetFunction&RoundUph (setBeginDate< (setEndDateiT DateValue/mddy\ Module3daddList8myArrayneGetCustomListNumDeleteCustomList AddCustomList listArray# Module4e xlMaximizedZp xlSheetHidden4xlSheetVeryHidden(setUpdatingLevels#thisMode reportSheet{ IsMissingZoom prodID;(!productAtrribsCdataDescriptor defaultReport* (!myRptColsτnameColGpItemColΥpItemTTTypeColPamtWageBaseCol: amtISTTColamtCol dateColBcheckNumhtxTypeF: sickBalCols vacBalCol^ isSourceCols payStartCol payEndCole  transIDColf sickAccruedCol  vacAccruedColJ payTypeColhoursCol P(!myEmpu sickBalanceMvacationBalance(!myTrans-empIndexcdatePay dateStart dateEndMchkNum[hrsTtlO vacAccTtlh vacUsedTtl=" sickAccTtl6 sickUsedTtlrptShtqprefName!sSht.rptIndexnsIndxrangeSsColsC0eIndexZmyMatchs dateFilter qtrFilterlastEmp>empCt{lastIDtxCt@ empTblStartformulaSempListtxListi xlPortraitD (findRptCols`c FormulaR1C1S HPageBreaks`v ColumnWidthtargWS Icols0 BeforeClose~; _B_var_Midp_Defaultj _B_var_TrimmT _B_var_UCaseaUserFormNOK^Label3,Click InitializeNLabel2,Dates1KeyUpMEnterChange QueryCloseT _B_var_Right9twoDigit fourDigit ShowFinished2 ShowWelcomeZoVerLabel/ _B_var_Chr\; _B_var_Format _B_var_LeftQ _B_var_LCase' _B_var_DatevPI 7  G4I  - [a$? A K % ,% *9"8    @H @@@: ^ Object Libr@ary/;D1?u00}#0#kh0 A7E640F79- 4F0E-22-B28A-F3689336432F6DOCUME~1\tteichma\LOCALS@Temp\VBE\T.exd d=ePrmp?>'>1O>Qmye Bmyi2q/fN<1newVerGn/wVPrG_M>}_XO.F ?XO._a.S5W`elcom>q}WlPcop}e'' _[0Up$ReportsG `&$Rp'r's*8/' d?( 1W @Qh?? x_Genera lW/x_Gp!&r9lX./% BDebugStuffBD bug~tpABBf_R_R0;J9+CPaIPa_R1_e?3Thta!9I 3ouaA3Ͽ4i4944-ɿ6pro(dIDXphdIDs8.v]p aT%A5defaultIsIM!f7tI?L*s8/I 6zqnrU~~~~~~~~~~~~~~~~~]      !  # % ' )  +  - __SRP_0Ic__SRP_1myPromptb]L`<_Pٯ_f dockToolbarcommandBarCreatecommandBarDeletecommandBarSavesetQuickBooksDataTableRangedeleteQuickBooksDataTableRange showAboutBoxupdateReportHeadersHideToolbarIfFloatingSetDrillDownSupport FF) SetWindowPos user32 SetWindowPos GetActiveWindow GetActiveWindowAddItem showWorkInProgresssetFocusToThisWorkbookappWaitOneSecond isAppVerOK minAppVergetAppVerNumbergetVersionStringapplicationVersionCheckpoint  , SetProdAttrits ((i < FfĤIx8< FF FControlsTemporaryCaption 0: Connect to QuickBooks.TooltipText style FaceId ShowUpdateDialogOnAction About ShowAboutBox 4QB Payroll Summary Reports F ToolBarView ToolBarLeft ToolBarTop ToolBarRowIndexreadMachineOptions Dock Toolbar VMove this toolbar to the upper toolbar area dockToolbarVBE6.DLL i  . ix  i1  OnErrorResume isFirstUse lastUsedBuildsetDefaultMachineOptionssetCurrentMachineOptionsshowUserSheetsshowWelcomeSheetsetUpdatingLevels FirstUsedDate Version_NumberVFA!z _p.O_y}wEspJobߋy G0Ka+XbW1J3s."-?@title1!-6S` I8{lFWJOOKҋB `relNotesLabel3ȏ[qJ eUserForm>}!EzF F3Dynamic  HOK_ClickUserForm_Initialize P UserPrefs WindowStateMaintainCustomSortLists .PivotCommandBarPosition PivotTable ,PivotCommandBarVisible A1 B爢1V]"EOr}V]<O$ȷ—xWxI\AsO[JJ'Cancel"ҋB ` DateSelectorLabel1E4 $  StartDateBҋB K*y0          rU~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~h :5qF%6M  a  a  i a  1a deIa  ia a Qsss[a "xaxxa $xy& a a a & a (q !a i(%%!& Q&y&&&&I'y''' (9(9a * aa 0 yay1Qyya ,a    I a  9 i  A q a iWWW X1Xa XI!a 9Y 1a a HY!a 9 !)  QBPayrollLinkSheet3 ThisWorkbookSheet17 formatCodeSheet41Sheet12Module5 datePromptmyPromptnewVerSheet1Welcome UpdateReportsSheet2 x_GeneralCode DebugStuffModule1Module2Module3Module4prodID defaultReportF /C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLLVBA a 0F9C:\Program Files\Microsoft Office 2003\OFFICE11\EXCEL.EXEExcel a @0FC:\WINDOWS\system32\stdole2.tlbstdole yP.E .`M C:\WINDOWS\system32\FM20.DLLMSForms YY`yd~OMh6C/ 2C:\DOCUME~1\tteichma\LOCALS~1\Temp\VBE\MSForms.exdShowUpdateDialog 9YapL-[DR?C:\Program Files\Common Files\Microsoft Shared\office11\mso.dllOffice a F6@Uн*Fo!@ZuDFWorkbookWorkbook_ActivateWorkbook_BeforeClose @ Auto_Openmy_Before_Force_CloseGetData updatePivotsformatDetailWorksheetF` ShowOnOpenContinueLabel2EndDate?F`Dates empPageBreaksStartDate_KeyUpp#t EndDate_KeyUpgetResultingDate Cancel_ClickContinue_ClickDateSelector_ClickStartDate_EnterStartDate_Exitq#tStartDate_Change EndDate_Enter EndDate_ExitEndDate_ChangeUserForm_QueryClosemagicallyFixDate 4DTdt ShowUpdateOnOpen i"  i  i  i  iV 0 2QuickBooks_Payroll_Vac_1x Worksheet Excel  ZQuickBooks Payroll Sick and Vacation Workbook FQB Payroll Sick and Vacation Report 8Get Sick && Vacation History Transaction HideActivity *Please Turn on MacrosFVisible Welcome41LQ ٨c FRjW GWXX|DF! ~ is not supported. To use this tool, you must be running Excel   or higher. iS  NotFound LastBuild $ShowNewUserMessage UpdateReports FinishedPrompt &ShowFinishedMessage ToolBarRow 8-Mar i  True 4 100 3 HideData Compensation Allocated Tips Tips Reported Tips .Taxable Group Term Life Fringe Benefit "Adoption Benefits (Non Taxable Sick Pay Federal Tax &Federal Withholding Social Security .Social Security Company 0Social Security Employee Medicare Medicare Company "Medicare Employee FUTA AEIC State Tax "State Withholding SUI Company SUI 7-Mar SUI Employee SDI SDI Company SDI Employee ,Company Paid Other Tax Other Tax Local Tax 401-k Roth 401(k) 403-b Roth 403(b) 408-k 457 457 Distribution 501-c Simple IRA 5-Mar 6-Mar 0Dependent Care Deduction .Dependent Care Addition >Non-Qualified Plan Distribution (Other Moving Expense 0Qualified Moving Expense .Medical Savings Benefit "Premium Only Plan .Medical Care Flex Spend 3-Mar 4-Mar 2Dependent Care Flex Spend Other None 1-Jan 2-Jan 3-Jan 4-Jan 5-Jan 6-Jan 7-Jan 8-Jan 9-Jan 1-Feb 2-Feb 3-Feb 4-Feb 5-Feb 6-Feb 7-Feb 8-Feb 9-Feb 1-Mar 2-Mar 9-Mar 1-Apr 2-Apr 3-Apr 4-Apr 5-Apr 6-Apr 7-Apr 8-Apr 9-Apr 1-May 2-May 3-May 4-May 5-May 6-May 7-May 8-May 9-May 1-Jun 2-Jun 3-Jun 4-Jun 5-Jun 6-Jun 7-Jun 8-Jun 9-Jun 1-Jul 2-Jul 3-Jul 4-Jul 5-Jul 6-Jul 7-Jul 8-Jul 9-Jul 1-Aug 2-Aug 3-Aug 4-Aug 5-Aug 6-Aug 7-Aug 8-Aug 9-Aug 1-Sep 2-Sep 3-Sep 4-Sep 5-Sep 6-Sep 7-Sep 8-Sep 9-Sep 1-Oct 2-Oct 3-Oct 4-Oct 5-Oct 6-Oct 7-Oct 8-Oct 9-Oct 1-Nov 2-Nov 3-Nov 4-Nov 5-Nov 6-Nov 7-Nov 8-Nov 9-Nov 1-Dec 2-Dec 3-Dec 4-Dec 5-Dec 6-Dec 7-Dec 8-Dec 9-Dec iY  This Year#ҋB ` Next Year Custom "DateRangeSelectedƏYl| StartDateҋB ` EndDate FixDateOrdersetContinueButtonreactToDateChoice setBeginDate setEndDate empPageBreaksCҋB ` Last Month Last Quarter Last Year This Month This Quarter i!  i) ( / 1 i HďYl| )?updateReportFooter i- h i #=h8+3qG?,2qL\]\- You've updated this workbook. If you want to save your changes, save this workbook now.   nDo you want to save the changes you made to this file (2 Later, you can open it in Excel and connect to QuickBooks to update the payroll reports contained4 in the workbook. You can also re-run the reports (without the changes you just made) from QuickBooks. DDo you want to save this workbook? xls ik |$CtS\FE8&e}Kv?{hz7vFlo swJkC6&  <<, LL$/$/< -i P<{lFWJO<rgetPreferredWorksheetdateRangeAsLabeldateAsOfAsLabel Page &P of &N &D &T i`  mmm d, yyyy  - i   &10Page &P of &N &"Arial,Bold"&13 &9 &10DW1tNBYS+9W_AHt+J@/jIٹOF';P$,*DDtwoDigit fourDigitϜu9Ihd w fourDigit_ClicktwoDigit_Click L myDateOption 25W{J]mRrK)- ϳ.WLW2R#ZُvQ H7I512?軜HU{41Ba3bX ShowFinishedp‡,aLD !z X  - Updated " ii h i  i   i#  i  2000 97 2002 2003name GetDataStartTime Detail Data LQBInstanceFinder.RunningInstanceFinderGetAnyInstance *qbNameTypeFilterLevel BExcelDataSourceCommon.PayrollDataGetModule QBXLADIN Options qbQueryType 0qbTransactionListGeneral &qbTransactionSubset allPayrollDetail 0qbTransactionDetailLevel detailOnly qbNameTypeFilter Employee transaction &qbQuerySubtotalType summaryRows fieldList@ Name, Date, Trans ID, Doc Num, Pay Start, Pay End, Type, Pay Type, Accrued Sick, Accrued Vac, Sick Balance, Vacation Balance sumFieldList Hours, Amount GetPayrollData% An error occurred while attempting to use the connection to QuickBooks. rQuickBooks may not be installed properly on this machine.& Try restarting your machine. If that does not work, repairing QuickBooks EntireColumnNumberFormat h' from the Windows Add/Remove Programs Control Panel may resolve this issue. Error:   : & An error occurred while attempting to find a running copy of QuickBooks. GetDataEndTimeActivate WAGE BASE *INCOME SUBJECT TO TAX y- If QuickBooks is running, try restarting your machine. If that does not work, repairing, QuickBooks from the Windows Add/Remove Programs Control Panel may resolve this issue. lAn error occurred while attempting to find QuickBooks. #,##0.00 rBe sure QuickBooks is running and a company file is open. @Could not connect to QuickBooks. >Unable to connect to QuickBooks xMicrosoft Excel didn't receive any new data from QuickBooks. LastUpdateFromQB Event Processing k: Make sure payroll transactions exist within the selected date range, then click Get QuickBooks Data to try again. PNo Transactions Received From QuickBooks LastStartDate LastEndDate LL $$, xx  0@ createReport findRptCols* Data wasn't requested from QuickBooks because the dates you entered aren't valid./ Enter a valid date range format in the From and To fields, then click Get QuickBooks Data. i  ,Updating PivotTables: rF w$ Excel was unable to update the Pivot Table report on the worksheet ''& ''. There may be too much data for this Pivot Table to function properly. :Problem updating Pivot ReportFontBold AMOUNT DEBIT CREDIT WAGEBASE r QuickBooksData Version:  @QuickBooks Registration Number: (QBRegistrationNumber Created:  <Last Import from QuickBooks:  File Name: Current Error:  About  UseQBCoInfo $QBLegalCompanyName   m QBLegalAddress1 QBLegalAddress2 QBLegalCity ,  QBLegalState QBLegalZip 2Updating Report Headers:  FilterDates DEmployee Time off Accrued and Used DrillDownSupport Time Off setForSpeed setForDisplay iP @ .<error getting release>F 0.00 ZThis is the first time you are using release   of the  p. Please review what is new in this and recent releases.E}HvC%Yl|pj).` + = - t i ` i  ib  i  i(  .QuickBooks Payroll Link 20 10 11 12 The date '' Vacation Sick =R[1]C h'' has more than one meaning. It could mean either:   > (assuming a 4-digit year) MM/DD/YY > (assuming a 2-digit year)( How do you usually enter dates? Please choose the correct option to continue. Paycheck 4=R[1]C-R[1]C[-2]+R[1]C[-1]Size Date Chk Num Period Start Period End Hours Vac Accrued Vac Used Vac Bal Est. Sick Accrued Sick Used Sick Bal Est.FormulaR1C1 =SUM(R[ ]C[0]:R[-1]C[0]) mm/dd/yyyy #ColumnWidth NAME PAYROLL ITEM NUM DOC NUM DATE "TAX TRACKING TYPE SICK BALANCE VACATION BALANCE IS SOURCE PAY START PAY END TRANS ID ACCRUED VAC ACCRUED SICK HOURS PAY TYPE TYPE6A9_ܻB6n,lF`@yb8SBj`DZt]E`UVBw/KLȇ]21,I|9QPMyOKVerLabel ShowWelcomeNY''Gv! hversion MyOK_Click T  - Welcome)CI;+P:@ .{C۫V{(    !! CancelpreserveSaveState !  myDataSheetmySheethwndhWndInsertAfterxycxcywFlagsappNumtoolNamethisMode reportSheet q ( q8 qH aXaddList q#h 1$ax q$ qA% %KeyCodeShiftkeyAsciicurrDate !'rng CloseModethisS !/ searchMonth searchYear !d startingPoint valueList formatStyle mergeCellsstyleindent sheetName pageOrientStartDtEndDtasOfTExtthisDate thisSheet reportName footerText xa IzatargWScols a(H  @ }7'R KQDBTahoma(2Label2(Notes: On this report, balance columns are calculated based on the actual ending balances for each employee and the actual accrued and used hours in the report period. If theroKMCompObjNaVBFrame,UpdateReportsQPٯ__e are paychecks after the end date of the report, and an employee has accrued or used sick or vacation time on those checks, the ending balances on this report will be correct but the estimated historic balances will not be accurate. Manual adjustments are not tracked. 4U 5TahomaD(OK _uTahomaD@F,1Show after each update5Tahoma(?4Continuez-1@! `ShowFinished{1ShowFinishedMessagea  Microsoft Forms 2.0 FormEmbedded Object9qVERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} myPrompt Caption = "Workbook - Updated" ClientHeight = 3360 ClientLeft = 45 ClientTop = 330 ClientWidth = 8100 StartUpPosition = 1 'CenterOwner TypeInfoVer = 10 End (H  @R}M.JR KQDBTahoma(7LContinue$(Get QuickBooks Data @Tahoma(CanceluTahomaDF[F1Show when opening Workbook5TahomaHF(;DtwoDigitvC, ;DfourDigitear C O Microsoft Forms 2.0 FormEmbedded Object9qVERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} datePrompt Caption = "Ambiguous Date " ClientHeight = 2745 ClientLeft = 45 ClientTop = 330 ClientWidth = 6075 StartUpPosition = 1 'CefooPVPi15T n``Pٯ_Pٯ_fQ| u !"#$%&'        -!"#$%&`()*+,a/01234567'9LD<=>?@ABCEFGHIJK8MNOPQRSTUVWXYZ[\^_bkdefghij]lmnq}stuvwxyz{p~oSU CompObjpCompObjRWaVBFrame%  ei  !  "#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHJKLMN[PQRSTUVWXYZI\]^_`abcdfghjlwnopqrstuvkxyz{|}~o{   !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstxyz|}~ n``Microsoft Forms 2.0 FrameEmbedded ObjectForms.Frame.19q$@H,  {9/30/1999heduTahoma @H, {9/1/1999uTahoma99(From|5Tahoma99(To {|5Tahoma99`] 5Tahoma998H  }} DatesaR Root Entry FP_w@Workbook_VBA_PROJECT_CUR"iJ- _P_VBA- _`<_KQ_Tahoma$DEndDate9("( @StartDateBol((24Label1e9 >(24Label2e9i( 4DateSelector> Ci1Page breaks between Employees5Tahoma( ;8Cancelue<! CompObjaaVBFrame+newVerXd_p _f nterOwner TypeInfoVer = 22 End (H  @ }98%R KQDBTahoma$?<OK,}( OK, Thanksar uTahomael 4i@Tahomael!@HЬ4Release 1.02: Signed the template with a new digital signature. Release 1.01: The first version of this workbook template.5Tahomael( New releoce lCompObjfaVBFrame'PROJECTwmfase!4@Tahomael!(20title1it$relNotesq(2@Label3es  Microsoft Forms 2.0 FormEmbedded Object9qVERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} newVer Caption = "Report Workbook" ClientHeight = 5505 ClientLeft = 45 ClientTop = 435 ClientWidth = 8160 StartUpPosition = 1 'CenterOwner TypeInfoVer = 13 End ThisWorkbookThisWorkbookSheet41Sheet41Sheet2Sheet2Sheet12Sheet12Sheet3Sheet3DebugStuffDebugStuffModule1Module1Module2Module2Module3Module3Module4Module4Module5Module5myPromptmyPromptUpdateReportsUpdateReportsWelcomeWelcomex_GeneralCodex_GeneralCodeSheet1Sheet1datePromptdatePromptformatCodeformatCodenewVernewVerSheet17Sheet17prodIDprodIDdefaultReportdefaultReportID="{BFE7911E-2DCC-11D5-A32A-0010A48D0BBD}" Document=ThisWorkbook/&H00000000 Document=Sheet41/&H00000000 Document=Sheet2/&H00000000 Document=Sheet12/&H00000000 Document=Sheet3/&H00000000 PROJECT%SSummaryInformation(j?XDocumentSummaryInformation8 Module=DebugStuff Module=Module1 Module=Module2 Module=Module3 Module=Module4 Module=Module5 BaseClass=myPrompt BaseClass=UpdateReports BaseClass=Welcome Module=x_GeneralCode Package={AC9F2F90-E877-11CE-9F68-00AA00574A4F} Document=Sheet1/&H00000000 BaseClass=datePrompt Module=formatCode BaseClass=newVer Document=Sheet17/&H00000000 Module=prodID Module=defaultReport HelpFile="" Name="QBPayrollLink" HelpContextID="0" VersionCompatible32="393222000" CMG="4E4CB6F3DA1D9521952194229422" DPB="0507FD4803F909F909B73E43CAD743" GC="BCBE44014CB94DB94DB9" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] ThisWorkbook=44, 58, 693, 575, Z Sheet41=0, 0, 0, 0, C Sheet2=88, 116, 741, 709, Z Sheet12=0, 0, 0, 0, C Sheet3=0, 0, 0, 0, C DebugStuff=176, 232, 940, 718, C Module1=-1, 349, 1001, 793, Z Module2=22, 29, 740, 520, C Module3=110, 145, 810, 631, Module4=132, 174, 832, 660, Module5=154, 203, 854, 689, myPrompt=0, 0, 685, 539, C, 22, 29, 992, 468, C UpdateReports=198, 261, 959, 824, , 66, 87, 1036, 526, C Welcome=110, 145, 753, 738, C, 88, 116, 1058, 555, C x_GeneralCode=0, 0, 748, 516, Sheet1=0, 0, 0, 0, C datePrompt=0, 0, 551, 563, C, 88, 116, 812, 679, C formatCode=66, 87, 718, 571, newVer=0, 0, 798, 473, C, 154, 203, 952, 676, C Sheet17=0, 0, 0, 0, C prodID=0, 0, 1145, 584, defaultReport=88, 116, 1202, 675, Oh+'0( X`   QuickBooks Payroll Reports Intuit Dev4Created by Intuit Inc. to work with QuickBooks 2007IntuitMicrosoft Excel@!@@n_՜.+,0 X`p x Intuit' WelcomePlease Turn on Macros Time Off  WorksheetsA՜.+,0 X`p x Intuit' WelcomePlease Turn on Macros Time Off  WorksheetsA,n=0  *H 010 *H 0R +7D0B0 +7t~ƭ?VM0 0 *H Ɉ-bG/ȯ #0<0p)48{̺0  *H 0_1 0 UUS10U VeriSign, Inc.1705U .Class 3 Public Primary Certification Authority0 960129000000Z 280801235959Z0_1 0 UUS10U VeriSign, Inc.1705U .Class 3 Public Primary Certification Authority00  *H 0\Y@WjE@ 3X%*Dx#}֬cEr'Luq9OBu Ǝ o#_p)6Ɇ籚 S=}$E3vqdLe.hE0  *H L+,&Oݦ (g/|蕼l,QsؤSN&vW^!ѱ!XiDD9\ܜVEL=2Qb}r6:kNd d0z0b8%a&Z0  *H 0S1 0 UUS10U VeriSign, Inc.1+0)U"VeriSign Time Stamping Services CA0 070615000000Z 120614235959Z0\1 0 UUS10U VeriSign, Inc.1402U+VeriSign Time Stamping Services Signer - G200  *H 0ĵR`)J[/Kk5TX56^bMRQ4q{f*j 7٘tvJcEG.k NK+XJ,XB-uލǎlLgrIž`<cxi{-004+(0&0$+0http://ocsp.verisign.com0 U003U,0*0(&$"http://crl.verisign.com/tss-ca.crl0U% 0 +0U0U0010 UTSA1-20  *H PK$ $- 7 ,Za񑑳V@뒾89u6t:O7ʕBǠWdB5N3M'L8MxSݤ^ ⥾`߭(ǥKd[98"3/!?DA e$HDT\y>]r},CS}=*:Om ]^SWp`+nx'4[^I2300-GߍRFCmH 10  *H 01 0 UZA10U Western Cape10U Durbanville10 U Thawte10U Thawte Certification10UThawte Timestamping CA0 031204000000Z 131203235959Z0S1 0 UUS10U VeriSign, Inc.1+0)U"VeriSign Time Stamping Services CA0"0  *H 0 ʲ }uNgadڻ30X~k6xw~o< hlʽR-H=]_/kLR`@~ ?Ǵ߇_zj1.G 1s W-x43h/Š*Ë!fXWou<&]'x1"ijGC_^|}bM "Vͮv M٠h;004+(0&0$+0http://ocsp.verisign.com0U00AU:0806420http://crl.verisign.com/ThawteTimestampingCA.crl0U% 0 +0U0$U0010U TSA2048-1-530  *H JkXD1y+LͰXn)^ʓR G'/8ɓN"b?7!Op18UN$ҩ'NzaA*^ݻ+>W~ +;R8'?J00(AZ9xIef8Lu0  *H 0_1 0 UUS10U VeriSign, Inc.1705U .Class 3 Public Primary Certification Authority0 040716000000Z 140715235959Z01 0 UUS10U VeriSign, Inc.10U VeriSign Trust Network1;09U 2Terms of use at https://www.verisign.com/rpa (c)041.0,U%VeriSign Class 3 Code Signing 2004 CA0"0  *H 0 ~7O8Ҍ} kBRH%czQeӪ;+f$n96Уv"'$l8'I%,0q(wJQTom dc-N'm)G|-Wg32 #m„Kvhq,]! &-+UMm5(k\٪_̓c";Bi:^,(Sݵ Qp7HRHo8l{D00U00DU =0;09 `HE0*0(+https://www.verisign.com/rpa01U*0(0&$" http://crl.verisign.com/pca3.crl0U%0++0U0 `HB0)U"0 010UClass3CA2048-1-430UQ==d6|h[x߹70U#y0wca0_1 0 UUS10U VeriSign, Inc.1705U .Class 3 Public Primary Certification Authorityp)48{̺0  *H :J{UdU@IA.x#h2و8?Ӊ?Z.&|n H @yg#$P.̀lROuU"Au/cU}TZY4_^z00X>sWĸ0  *H 01 0 UUS10U VeriSign, Inc.10U VeriSign Trust Network1;09U 2Terms of use at https://www.verisign.com/rpa (c)041.0,U%VeriSign Class 3 Code Signing 2004 CA0 081204000000Z 101207235959Z01 0 UUS10U California10U Mountain View10U  Intuit, Inc.1B0@U 9Digital ID Class 3 - Microsoft VBA Software Validation v21 0 U QBR10U Intuit, Inc.00  *H 0.]crH,> U jK*n, crk%&BgY#m(. &`ʖ\fJE~\w7`j^ߓzR28O"2*A1lS^0Z0 U00U0@U9070531/http://CSC3-2004-crl.verisign.com/CSC3-2004.crl0DU =0;09 `HE0*0(+https://www.verisign.com/rpa0U% 0 +0u+i0g0$+0http://ocsp.verisign.com0?+03http://CSC3-2004-aia.verisign.com/CSC3-2004-aia.cer0 `HB0 +700  *H F`\mLz*fmBG^Nf` '!:1tgrD&i Nrhs`%(8I5UH~󷥋-Mj? &x"GWG|}!U) xYHlG}gZjDl w++5NЊ%˻~8;7;X@s@wG:ʧkS(s l ѡH[+r1h0d001 0 UUS10U VeriSign, Inc.10U VeriSign Trust Network1;09U 2Terms of use at https://www.verisign.com/rpa (c)041.0,U%VeriSign Class 3 Code Signing 2004 CAX>sWĸ0 *H p0 +7 100 *H  1  +70 +7 10  +70 *H  1x;:,LDY ^8w0  *H /ۮ\Sif GWË>AR[Ob){;y"zi,ZMYVe$m& 43uKe,a@WcSX=P_p?EIUH7 Б0{ *H  1l0h0g0S1 0 UUS10U VeriSign, Inc.1+0)U"VeriSign Time Stamping Services CA8%a&Z0 +]0 *H  1  *H 0 *H  1 081215221415Z0# *H  1 ?G@'O!0  *H Ek)Wڑ6X"FTmM29 ئ <(q[HAIIjd)wBDm%XCF͹?S+944%¦CB¾N䰮j`V0oqN>CERTcM ^sWĸ0  *H 01 0 UUS10U VeriSign, Inc.10U VeriSign Trust Network1;09U 2Terms of use at https://www.verisign.com/rpa (c)041.0,U%VeriSign Class 3 Code Signing 2004 CA0 081204000000Z 101207235959Z01 0 UUS10U California10U Mountain View10U  Intuit, Inc.1B0@U 9Digital ID Class 3 - Microsoft VBA Software Validation v21 0 U QBR10U Intuit, Inc.00  *H 0.]crH,> U jK*n, crk%&BgY#m(. &`ʖ\fJE~\w7`j^ߓzR28O"2*A1lS^0Z0 U00U0@U9070531/http://CSC3-2004-crl.verisign.com/CSC3-2004.crl0DU =0;09 `HE0*0(+https://www.verisign.com/rpa0U% 0 +0u+i0g0$+0http://ocsp.verisign.com0?+03http://CSC3-2004-aia.verisign.com/CSC3-2004-aia.cer0 `HB0 +700  *H F`\mLz*fmBG^Nf` '!:1tgrD&i Nrhs`%(8I5UH~󷥋-Mj? &x"GWG|}!U) xYHlG}gZjDl w++5NЊ%˻~8;7;X@s@wG:ʧkS(s l ѡH[+r