{"text_format":"3","workbook":"xls","n_sheets":16,"sheets":["Please Turn on Macros","Detail","Register","Exp Summary","Exp Charts","YTD Summary","Comparison","Tax Balances","Scratch","Welcome","Supporting Settings","Data","DataPriorYear","DataComparison","EE_Data","TempData"],"not_rendered":{"charts":3,"images":2,"macros":1,"external_links":1,"defined_names":58},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Please Turn on Macros","index":0,"n_rows":7,"n_cols":1,"rows_kept":7,"flags":["formulas_cached_only"]}
[]
["You must enable macros to run these payroll reports. To enable macros, make sure your macro security settings are set properly, change them if necessary, and then close and re-open this workbook."]
["Excel 2000, 2002, and 2003 users\n  Step 1. Confirm security level\n    1. Go to the Excel Tools menu, click Macro, then click Security. \n    2. If the security level is set to:\n       • Very High: Click any option except Very High, then Click OK to save the new settings.\n       • High, Medium, or Low: Leave the option selected as is, then click OK to close the window. \n    3. Close this workbook.\n\n  Step 2. Enable macros\n    1. Re-open this workbook. \n    2. If you selected any setting except Low, you’ll be prompted to enable macros.  \n    3. Click Enable Macros.\n    4. Depending on your Excel version and security settings, click Always trust macros from this publisher \n        to trust the macros in this workbook in the future."]
["Excel 2007 users\n  If you see a security alert like the one pictured here,"]
[]
["    1. Click the Enable Content button and then click one of the following:\n       • Enable this content\n       • Trust all documents from this publisher"]
["  If you don't see an alert, \n    1. From the Developer tab on the Ribbon, click Macro Security in the Code group.\n    2. Click one of the following options:\n       • Enable all macros \n       • Disable all macros except digitally signed macros\n       • Disable all macros with nofitication\n    3. Click the OK to save the settings.\n    4. Close this workbook.\n\n  The next time you open this workbook, a security alert like the one above will appear."]

{"sheet":"Detail","index":1,"n_rows":50,"n_cols":14,"rows_kept":50,"hidden":true,"merged":[[0,0,0,3],[0,11,0,13],[1,0,1,3],[1,4,1,6],[1,7,1,9],[1,11,1,13],[3,0,3,2],[3,3,3,4],[3,8,3,9],[17,0,17,2],[17,3,17,4],[17,8,17,9],[31,0,31,13],[32,0,32,2],[32,3,32,4]],"flags":["formulas_cached_only"]}
["Paycheck Detail Report",{"$nulls":10},"For Paychecks Issued on: Aug 31, 2006"]
["Earnings",{"$nulls":3},"Taxes",null,null,"Other Additions/Deductions",{"$nulls":3},"Company Taxes & Contributions"]
[]
["Deanna A Ecker",null,null,"***-**-1234",{"$nulls":4},"Chk # 1615"]
["Earnings Item","Hours","Current","YTD","Tax","Current","YTD","Item","Current","YTD",null,"Item","Current","YTD"]
["Regular",{"v":80,"d":"80.00"},{"v":1180,"d":"1,180.00"},{"v":2360,"d":"2,360.00"},"Federal Withholding",{"v":-114,"d":"-114.00"},{"v":-244,"d":"-244.00"},"Simple IRA",{"v":-100,"d":"-100.00"},{"v":-100,"d":"-100.00"},null,"Social Security Company",73.16,146.32]
[{"$nulls":4},"Social Security Employee",-73.16,-146.32,"Health Insurance",{"v":-25,"d":"-25.00"},{"v":-50,"d":"-50.00"},null,"Medicare Company",17.11,34.22]
[{"$nulls":4},"Medicare Employee",-17.11,-34.22,{"$nulls":4},"Federal Unemployment",9.44,18.88]
[{"$nulls":4},"CA - Withholding",0,-28.96,{"$nulls":4},"CA - Unemployment Company",0,61.95]
[{"$nulls":4},"CA - Disability Employee",0,-12.75,{"$nulls":4},"CA - Employee Training Tax",0,1.18]
[{"$nulls":4},"OR - Withholding",{"v":-74,"d":"-74.00"},{"v":-74,"d":"-74.00"},{"$nulls":4},"OR - Unemployment Company",{"v":35.4,"d":"35.40"},{"v":35.4,"d":"35.40"}]
[{"$nulls":4},"OR - WBF Assessment Emp.",{"v":-10,"d":"-10.00"},{"v":-10,"d":"-10.00"},{"$nulls":4},"OR - Transit District (LTD)",7.08,7.08]
[{"$nulls":11},"OR - WBF Assessment Co.",{"v":240,"d":"240.00"},{"v":240,"d":"240.00"}]
[{"$nulls":11},"OR - Transit Dist. (Tri-Met)",7.58,7.58]
[{"$nulls":11},"Workers Compensation",{"v":70.8,"d":"70.80"},{"v":70.8,"d":"70.80"}]
["Total Earnings",{"v":80,"d":"80.00"},{"v":1180,"d":"1,180.00"},{"v":2360,"d":"2,360.00"},"Total Taxes",-288.27,-550.25,"Total Other",{"v":-125,"d":"-125.00"},{"v":-150,"d":"-150.00"},null,"Total Company",460.57,623.41]
[{"$nulls":7},"Net Pay",766.73,{"v":1659.75,"d":"1,659.75"}]
["Mark R Hamlin",null,null,"***-**-4567",{"$nulls":4},"Chk # 1616"]
["Earnings Item","Hours","Current","YTD","Tax","Current","YTD","Item","Current","YTD",null,"Item","Current","YTD"]
["Sick Hourly",{"v":10,"d":"10.00"},{"v":10000,"d":"10,000.00"},{"v":10000,"d":"10,000.00"},"Federal Withholding",{"v":-2761,"d":"-2,761.00"},{"v":-2761,"d":"-2,761.00"},{"$nulls":4},"Social Security Company",{"v":620,"d":"620.00"},{"v":620,"d":"620.00"}]
[{"$nulls":4},"Social Security Employee",{"v":-620,"d":"-620.00"},{"v":-620,"d":"-620.00"},{"$nulls":4},"Medicare Company",{"v":145,"d":"145.00"},{"v":145,"d":"145.00"}]
[{"$nulls":4},"Medicare Employee",{"v":-145,"d":"-145.00"},{"v":-145,"d":"-145.00"},{"$nulls":4},"Federal Unemployment",0,0]
[{"$nulls":4},"NJ - Withholding",-610.77,-610.77,{"$nulls":4},"NJ - Unemployment Company",{"v":200,"d":"200.00"},{"v":200,"d":"200.00"}]
[{"$nulls":4},"NJ - Unemployment Employee",{"v":-300,"d":"-300.00"},{"v":-300,"d":"-300.00"},{"$nulls":4},"NJ - Disability Company",{"v":75,"d":"75.00"},{"v":75,"d":"75.00"}]
[{"$nulls":4},"NJ - Disability Employee",{"v":-50,"d":"-50.00"},{"v":-50,"d":"-50.00"},{"$nulls":4},"NJ - Health Care Subsidy Co.",{"v":300,"d":"300.00"},{"v":300,"d":"300.00"}]
[{"$nulls":4},"NJ - Health Care Subsidy Emp.",{"v":-5,"d":"-5.00"},{"v":-5,"d":"-5.00"},{"$nulls":4},"NJ - WF/SWF Company",{"v":11.8,"d":"11.80"},{"v":11.8,"d":"11.80"}]
[{"$nulls":4},"NJ - WF/SWF Employee",{"v":-4.2,"d":"-4.20"},{"v":-4.2,"d":"-4.20"},{"$nulls":4},"Workers Compensation",{"v":600,"d":"600.00"},{"v":600,"d":"600.00"}]
["Total Earnings",{"v":10,"d":"10.00"},{"v":10000,"d":"10,000.00"},{"v":10000,"d":"10,000.00"},"Total Taxes",{"v":-4495.97,"d":"-4,495.97"},{"v":-4495.97,"d":"-4,495.97"},"Total Other",0,0,null,"Total Company",{"v":1951.8,"d":"1,951.80"},{"v":1951.8,"d":"1,951.80"}]
[{"$nulls":7},"Net Pay",{"v":5504.03,"d":"5,504.03"},{"v":5504.03,"d":"5,504.03"}]
[]
[]
["Company Totals"]
["Employee Count: 2",null,null,"Check Count: 2"]
["Earnings Item","Hours","Current","YTD","Tax","Current","YTD","Item","Current","YTD",null,"Item","Current","YTD"]
["Bonus",0,0,{"v":150,"d":"150.00"},"Federal Withholding",{"v":-2875,"d":"-2,875.00"},{"v":-3315,"d":"-3,315.00"},"Simple IRA",{"v":-100,"d":"-100.00"},{"v":-100,"d":"-100.00"},null,"Social Security Company",693.16,932.36]
["Commission",0,0,{"v":1200,"d":"1,200.00"},"Social Security Employee",-693.16,-932.36,"Health Insurance",{"v":-25,"d":"-25.00"},{"v":-50,"d":"-50.00"},null,"Medicare Company",162.11,218.05]
["Regular",{"v":80,"d":"80.00"},{"v":1180,"d":"1,180.00"},{"v":3260,"d":"3,260.00"},"Medicare Employee",-162.11,-218.05,{"$nulls":4},"Federal Unemployment",9.44,{"v":40.3,"d":"40.30"}]
["Sick Hourly",{"v":10,"d":"10.00"},{"v":10000,"d":"10,000.00"},{"v":10300,"d":"10,300.00"},"CA - Withholding",0,-188.25,{"$nulls":4},"CA - Unemployment Company",0,202.55]
["Vacation Hourly",0,0,{"v":128,"d":"128.00"},"CA - Disability Employee",0,-34.17,{"$nulls":4},"CA - Employee Training Tax",0,3.86]
[{"$nulls":4},"NJ - Withholding",-610.77,-610.77,{"$nulls":4},"NJ - Unemployment Company",{"v":200,"d":"200.00"},{"v":200,"d":"200.00"}]
[{"$nulls":4},"NJ - Unemployment Employee",{"v":-300,"d":"-300.00"},{"v":-300,"d":"-300.00"},{"$nulls":4},"NJ - Disability Company",{"v":75,"d":"75.00"},{"v":75,"d":"75.00"}]
[{"$nulls":4},"NJ - Disability Employee",{"v":-50,"d":"-50.00"},{"v":-50,"d":"-50.00"},{"$nulls":4},"NJ - Health Care Subsidy Co.",{"v":300,"d":"300.00"},{"v":300,"d":"300.00"}]
[{"$nulls":4},"NJ - WF/SWF Employee",{"v":-4.2,"d":"-4.20"},{"v":-4.2,"d":"-4.20"},{"$nulls":4},"NJ - WF/SWF Company",{"v":11.8,"d":"11.80"},{"v":11.8,"d":"11.80"}]
[{"$nulls":4},"NJ - Health Care Subsidy Emp.",{"v":-5,"d":"-5.00"},{"v":-5,"d":"-5.00"},{"$nulls":4},"OR - Unemployment Company",{"v":35.4,"d":"35.40"},{"v":35.4,"d":"35.40"}]
[{"$nulls":4},"OR - Withholding",{"v":-74,"d":"-74.00"},{"v":-74,"d":"-74.00"},{"$nulls":4},"OR - Transit Dist. (Tri-Met)",7.58,7.58]
[{"$nulls":4},"OR - WBF Assessment Emp.",{"v":-10,"d":"-10.00"},{"v":-10,"d":"-10.00"},{"$nulls":4},"OR - Transit District (LTD)",7.08,7.08]
[{"$nulls":11},"OR - WBF Assessment Co.",{"v":240,"d":"240.00"},{"v":240,"d":"240.00"}]
[{"$nulls":11},"Workers Compensation",{"v":670.8,"d":"670.80"},{"v":670.8,"d":"670.80"}]
["Total Earnings",{"v":90,"d":"90.00"},{"v":11180,"d":"11,180.00"},{"v":15038,"d":"15,038.00"},"Total Taxes",{"v":-4784.24,"d":"-4,784.24"},{"v":-5741.8,"d":"-5,741.80"},"Total Other",{"v":-125,"d":"-125.00"},{"v":-150,"d":"-150.00"},null,"Total Company",{"v":2412.37,"d":"2,412.37"},{"v":2944.7799999999997,"d":"2,944.78"}]
[{"$nulls":7},"Net Pay",{"v":6270.76,"d":"6,270.76"},{"v":9146.2,"d":"9,146.20"}]

{"sheet":"Register","index":2,"n_rows":9,"n_cols":16,"rows_kept":9,"hidden":true,"merged":[[0,0,0,2],[0,12,0,15],[1,0,1,1],[1,2,1,3],[1,4,1,7]],"flags":["formulas_cached_only"]}
["Payroll Register",{"$nulls":11},"Aug 31, 2006 - Aug 31, 2006"]
["Employee",null,"Check Info",null,"Payroll Details"]
["Name","SSN","Date","Chk","Hours","Gross","Fed W/H","Soc Sec","Med Care","State W/H","SUI","SDI","Other Tax","Simple IRA","Health Insurance","Net Pay"]
[]
["Deanna A Ecker","***-**-1234","2006-08-31",1615,{"v":80,"d":"80.00"},{"v":1180,"d":"1,180.00"},{"v":-114,"d":"-114.00"},-73.16,-17.11,{"v":-74,"d":"-74.00"},0,0,{"v":-10,"d":"-10.00"},{"v":-100,"d":"-100.00"},{"v":-25,"d":"-25.00"},766.73]
[]
["Mark R Hamlin","***-**-4567","2006-08-31",1616,{"v":10,"d":"10.00"},{"v":10000,"d":"10,000.00"},{"v":-2761,"d":"-2,761.00"},{"v":-620,"d":"-620.00"},{"v":-145,"d":"-145.00"},-610.77,{"v":-300,"d":"-300.00"},{"v":-50,"d":"-50.00"},{"v":-9.2,"d":"-9.20"},0,0,{"v":5504.03,"d":"5,504.03"}]
[]
["Company Totals",{"$nulls":3},{"v":90,"d":"90.00"},{"v":11180,"d":"11,180.00"},{"v":-2875,"d":"-2,875.00"},-693.16,-162.11,-684.77,{"v":-300,"d":"-300.00"},{"v":-50,"d":"-50.00"},{"v":-19.2,"d":"-19.20"},{"v":-100,"d":"-100.00"},{"v":-25,"d":"-25.00"},{"v":6270.76,"d":"6,270.76"}]

{"sheet":"Exp Summary","index":3,"n_rows":27,"n_cols":11,"rows_kept":27,"hidden":true,"merged":[[0,0,0,3],[0,6,0,10],[23,3,23,4],[23,6,23,7]],"flags":["formulas_cached_only"]}
["Payroll Expense Summary",{"$nulls":5},"Aug 31, 2006 - Aug 31, 2006"]
[]
["Summary",null,"% Earn"]
["Earnings Expense",{"v":11180,"d":"11,180"},{"v":1,"d":"100%"}]
["Company Tax Expense",{"v":1741.57,"d":"1,742"},{"v":0.15577549194991056,"d":"16%"}]
["Benefit Expense",{"v":670.8,"d":"671"},{"v":0.06,"d":"6%"}]
["Total Expenses",{"v":13592.369999999999,"d":"13,592"},{"v":1.2157754919499104,"d":"122%"}]
[]
["Earnings Details",null,null,"Company Tax Details",null,null,"Benefit Details"]
["Sick Hourly",{"v":10000,"d":"10,000"},{"v":0.8944543828264758,"d":"89%"},"Social Security Company",{"v":693.16,"d":"693"},{"v":0.39800869330546573,"d":"40%"},"Workers Compensation",{"v":670.8,"d":"671"},{"v":1,"d":"100%"}]
["Regular",{"v":1180,"d":"1,180"},{"v":0.10554561717352415,"d":"11%"},"NJ - Health Care Subsidy Co.",300,{"v":0.1722583645790867,"d":"17%"}]
[{"$nulls":3},"OR - WBF Assessment Co.",240,{"v":0.13780669166326937,"d":"14%"}]
[{"$nulls":3},"NJ - Unemployment Company",200,{"v":0.11483890971939113,"d":"11%"}]
[{"$nulls":3},"Medicare Company",{"v":162.11,"d":"162"},{"v":0.09308267827305249,"d":"9%"}]
[{"$nulls":3},"NJ - Disability Company",75,{"v":0.04306459114477167,"d":"4%"}]
[{"$nulls":3},"OR - Unemployment Company",{"v":35.4,"d":"35"},{"v":0.02032648702033223,"d":"2%"}]
[{"$nulls":3},"NJ - WF/SWF Company",{"v":11.8,"d":"12"},{"v":0.006775495673444077,"d":"1%"}]
[{"$nulls":3},"Federal Unemployment",{"v":9.44,"d":"9"},{"v":0.005420396538755261,"d":"1%"}]
[{"$nulls":3},"OR - Transit Dist. (Tri-Met)",{"v":7.58,"d":"8"},{"v":0.004352394678364924,"d":"0%"}]
[{"$nulls":3},"OR - Transit District (LTD)",{"v":7.08,"d":"7"},{"v":0.004065297404066446,"d":"0%"}]
["Total Earnings",{"v":11180,"d":"11,180"},null,"Total Company Taxes",{"v":1741.57,"d":"1,742"},null,"Total Benefits",{"v":670.8,"d":"671"}]
[]
["Employee Details"]
["Name","Earnings","%","Co Taxes",null,"%","Benefits",null,"%","Ttl Exp","%"]
["Mark R Hamlin",{"v":10000,"d":"10,000"},{"v":0.8944543828264758,"d":"89%"},null,{"v":1351.8,"d":"1,352"},{"v":0.7761961907933647,"d":"78%"},null,600,{"v":0.8944543828264759,"d":"89%"},{"v":11951.8,"d":"11,952"},{"v":0.879302137890596,"d":"88%"}]
["Deanna A Ecker",{"v":1180,"d":"1,180"},{"v":0.10554561717352415,"d":"11%"},null,{"v":389.77,"d":"390"},{"v":0.2238038092066354,"d":"22%"},null,{"v":70.8,"d":"71"},{"v":0.10554561717352415,"d":"11%"},{"v":1640.57,"d":"1,641"},{"v":0.12069786210940403,"d":"12%"}]
["Totals",{"v":11180,"d":"11,180"},null,null,{"v":1741.57,"d":"1,742"},null,null,{"v":670.8,"d":"671"},null,{"v":13592.369999999999,"d":"13,592"}]

{"sheet":"Exp Charts","index":4,"n_rows":1,"n_cols":13,"rows_kept":1,"hidden":true,"merged":[[0,0,0,4],[0,12,0,15]],"flags":["formulas_cached_only"]}
["Payroll Expense Charts",{"$nulls":11},"Aug 31, 2006 - Aug 31, 2006"]

{"sheet":"YTD Summary","index":5,"n_rows":16,"n_cols":14,"rows_kept":16,"hidden":true,"merged":[[0,0,0,3],[0,9,0,13]],"flags":["formulas_cached_only"]}
["Employee YTD Summary",{"$nulls":8},"Aug 31, 2006 - Aug 31, 2006 (last pay on Aug 31)"]
["Employee","Period","Hours","Gross","Fed W/H","Soc Sec","Med Care","State W/H","SUI","SDI","Other Tax","Simple IRA","Other","Net Pay"]
["Deanna A Ecker","MTD",{"v":80,"d":"80.00"},{"v":1180,"d":"1,180.00"},{"v":-114,"d":"-114.00"},-73.16,-17.11,{"v":-74,"d":"-74.00"},0,0,{"v":-10,"d":"-10.00"},{"v":-100,"d":"-100.00"},{"v":-25,"d":"-25.00"},766.73]
["***-**-1234","QTD",{"v":160,"d":"160.00"},{"v":2360,"d":"2,360.00"},{"v":-244,"d":"-244.00"},-146.32,-34.22,-102.96,0,-12.75,{"v":-10,"d":"-10.00"},{"v":-100,"d":"-100.00"},{"v":-50,"d":"-50.00"},{"v":1659.75,"d":"1,659.75"}]
[null,"YTD",{"v":160,"d":"160.00"},{"v":2360,"d":"2,360.00"},{"v":-244,"d":"-244.00"},-146.32,-34.22,-102.96,0,-12.75,{"v":-10,"d":"-10.00"},{"v":-100,"d":"-100.00"},{"v":-50,"d":"-50.00"},{"v":1659.75,"d":"1,659.75"}]
["Jacint P Tumacder","MTD",{"v":88,"d":"88.00"},{"v":2678,"d":"2,678.00"},{"v":-310,"d":"-310.00"},-166.04,-38.83,-159.29,0,-21.42,0,0,0,{"v":1982.42,"d":"1,982.42"}]
["***-**-4567","QTD",{"v":88,"d":"88.00"},{"v":2678,"d":"2,678.00"},{"v":-310,"d":"-310.00"},-166.04,-38.83,-159.29,0,-21.42,0,0,0,{"v":1982.42,"d":"1,982.42"}]
[null,"YTD",{"v":88,"d":"88.00"},{"v":2678,"d":"2,678.00"},{"v":-310,"d":"-310.00"},-166.04,-38.83,-159.29,0,-21.42,0,0,0,{"v":1982.42,"d":"1,982.42"}]
["Mark R Hamlin","MTD",{"v":10,"d":"10.00"},{"v":10000,"d":"10,000.00"},{"v":-2761,"d":"-2,761.00"},{"v":-620,"d":"-620.00"},{"v":-145,"d":"-145.00"},-610.77,{"v":-300,"d":"-300.00"},{"v":-50,"d":"-50.00"},{"v":-9.2,"d":"-9.20"},0,0,{"v":5504.03,"d":"5,504.03"}]
["***-**-4567","QTD",{"v":10,"d":"10.00"},{"v":10000,"d":"10,000.00"},{"v":-2761,"d":"-2,761.00"},{"v":-620,"d":"-620.00"},{"v":-145,"d":"-145.00"},-610.77,{"v":-300,"d":"-300.00"},{"v":-50,"d":"-50.00"},{"v":-9.2,"d":"-9.20"},0,0,{"v":5504.03,"d":"5,504.03"}]
[null,"YTD",{"v":10,"d":"10.00"},{"v":10000,"d":"10,000.00"},{"v":-2761,"d":"-2,761.00"},{"v":-620,"d":"-620.00"},{"v":-145,"d":"-145.00"},-610.77,{"v":-300,"d":"-300.00"},{"v":-50,"d":"-50.00"},{"v":-9.2,"d":"-9.20"},0,0,{"v":5504.03,"d":"5,504.03"}]
[]
[]
["Company Totals","MTD",{"v":178,"d":"178.00"},{"v":13858,"d":"13,858.00"},{"v":-3185,"d":"-3,185.00"},{"v":-859.2,"d":"-859.20"},-200.94,-844.06,{"v":-300,"d":"-300.00"},-71.42,{"v":-19.2,"d":"-19.20"},{"v":-100,"d":"-100.00"},{"v":-25,"d":"-25.00"},{"v":8253.18,"d":"8,253.18"}]
[null,"QTD",{"v":258,"d":"258.00"},{"v":15038,"d":"15,038.00"},{"v":-3315,"d":"-3,315.00"},-932.36,-218.05,-873.02,{"v":-300,"d":"-300.00"},-84.17,{"v":-19.2,"d":"-19.20"},{"v":-100,"d":"-100.00"},{"v":-50,"d":"-50.00"},{"v":9146.2,"d":"9,146.20"}]
[null,"YTD",{"v":258,"d":"258.00"},{"v":15038,"d":"15,038.00"},{"v":-3315,"d":"-3,315.00"},-932.36,-218.05,-873.02,{"v":-300,"d":"-300.00"},-84.17,{"v":-19.2,"d":"-19.20"},{"v":-100,"d":"-100.00"},{"v":-50,"d":"-50.00"},{"v":9146.2,"d":"9,146.20"}]

{"sheet":"Comparison","index":6,"n_rows":58,"n_cols":13,"rows_kept":58,"hidden":true,"merged":[[0,0,0,3],[2,1,2,3],[2,4,2,6],[2,7,2,12],[3,1,3,3],[3,4,3,6]],"flags":["formulas_cached_only"]}
["Employee Cost Comparison"]
[]
[null,"Prior Period",null,null,"This Period",null,null,"Period/Period Change"]
[null,"Aug 31, 2005 - Aug 31, 2005",null,null,"Aug 31, 2006 - Aug 31, 2006"]
[]
["Deanna A Ecker","***-**-1234"]
["Earnings","Hours","Amount","Average/Hour","Hours","Amount","Average/Hour","Hours","%","Amount","%","Average/Hour","%"]
["Regular",0,0,null,{"v":80,"d":"80.00"},{"v":1180,"d":"1,180.00"},14.75,{"v":80,"d":"80.00"},null,{"v":1180,"d":"1,180.00"},null,0]
["Employer Tax Expenses"]
["Social Security Company",null,0,null,null,73.16,{"$nulls":3},73.16]
["Medicare Company",null,0,null,null,17.11,{"$nulls":3},17.11]
["Federal Unemployment",null,0,null,null,9.44,{"$nulls":3},9.44]
["OR - Unemployment Company",null,0,null,null,{"v":35.4,"d":"35.40"},{"$nulls":3},{"v":35.4,"d":"35.40"}]
["OR - Transit Dist. (Tri-Met)",null,0,null,null,7.58,{"$nulls":3},7.58]
["OR - WBF Assessment Co.",null,0,null,null,{"v":240,"d":"240.00"},{"$nulls":3},{"v":240,"d":"240.00"}]
["OR - Transit District (LTD)",null,0,null,null,7.08,{"$nulls":3},7.08]
[null,null,0,null,null,389.77,{"$nulls":3},389.77]
["Employer Paid Benefits"]
["Workers Compensation",null,0,null,null,{"v":70.8,"d":"70.80"},{"$nulls":3},{"v":70.8,"d":"70.80"}]
["Total Employer Expense",null,0,null,null,{"v":1640.57,"d":"1,640.57"},{"$nulls":3},{"v":1640.57,"d":"1,640.57"}]
[]
["Mark R Hamlin","***-**-4567"]
["Earnings","Hours","Amount","Average/Hour","Hours","Amount","Average/Hour","Hours","%","Amount","%","Average/Hour","%"]
["Sick Hourly",0,0,null,{"v":10,"d":"10.00"},{"v":10000,"d":"10,000.00"},{"v":1000,"d":"1,000.00"},{"v":10,"d":"10.00"},null,{"v":10000,"d":"10,000.00"},null,0]
["Employer Tax Expenses"]
["Social Security Company",null,0,null,null,{"v":620,"d":"620.00"},{"$nulls":3},{"v":620,"d":"620.00"}]
["Medicare Company",null,0,null,null,{"v":145,"d":"145.00"},{"$nulls":3},{"v":145,"d":"145.00"}]
["Federal Unemployment",null,0,null,null,0,{"$nulls":3},0]
["NJ - Unemployment Company",null,0,null,null,{"v":200,"d":"200.00"},{"$nulls":3},{"v":200,"d":"200.00"}]
["NJ - Disability Company",null,0,null,null,{"v":75,"d":"75.00"},{"$nulls":3},{"v":75,"d":"75.00"}]
["NJ - Health Care Subsidy Co.",null,0,null,null,{"v":300,"d":"300.00"},{"$nulls":3},{"v":300,"d":"300.00"}]
["NJ - WF/SWF Company",null,0,null,null,{"v":11.8,"d":"11.80"},{"$nulls":3},{"v":11.8,"d":"11.80"}]
[null,null,0,null,null,{"v":1351.8,"d":"1,351.80"},{"$nulls":3},{"v":1351.8,"d":"1,351.80"}]
["Employer Paid Benefits"]
["Workers Compensation",null,0,null,null,{"v":600,"d":"600.00"},{"$nulls":3},{"v":600,"d":"600.00"}]
["Total Employer Expense",null,0,null,null,{"v":11951.8,"d":"11,951.80"},{"$nulls":3},{"v":11951.8,"d":"11,951.80"}]
[]
["Company Totals"]
["Earnings","Hours","Amount","Average/Hour","Hours","Amount","Average/Hour","Hours","%","Amount","%","Average/Hour","%"]
["Regular",0,0,null,{"v":80,"d":"80.00"},{"v":1180,"d":"1,180.00"},14.75,{"v":80,"d":"80.00"},null,{"v":1180,"d":"1,180.00"},null,0]
["Sick Hourly",0,0,null,{"v":10,"d":"10.00"},{"v":10000,"d":"10,000.00"},{"v":1000,"d":"1,000.00"},{"v":10,"d":"10.00"},null,{"v":10000,"d":"10,000.00"},null,0]
[null,0,0,null,{"v":90,"d":"90.00"},{"v":11180,"d":"11,180.00"},null,{"v":90,"d":"90.00"},null,{"v":11180,"d":"11,180.00"}]
["Employer Tax Expenses"]
["Social Security Company",null,0,null,null,693.16,{"$nulls":3},693.16]
["Medicare Company",null,0,null,null,162.11,{"$nulls":3},162.11]
["Federal Unemployment",null,0,null,null,9.44,{"$nulls":3},9.44]
["NJ - Unemployment Company",null,0,null,null,{"v":200,"d":"200.00"},{"$nulls":3},{"v":200,"d":"200.00"}]
["NJ - Disability Company",null,0,null,null,{"v":75,"d":"75.00"},{"$nulls":3},{"v":75,"d":"75.00"}]
["NJ - Health Care Subsidy Co.",null,0,null,null,{"v":300,"d":"300.00"},{"$nulls":3},{"v":300,"d":"300.00"}]
["NJ - WF/SWF Company",null,0,null,null,{"v":11.8,"d":"11.80"},{"$nulls":3},{"v":11.8,"d":"11.80"}]
["OR - Unemployment Company",null,0,null,null,{"v":35.4,"d":"35.40"},{"$nulls":3},{"v":35.4,"d":"35.40"}]
["OR - Transit District (LTD)",null,0,null,null,7.08,{"$nulls":3},7.08]
["OR - Transit Dist. (Tri-Met)",null,0,null,null,7.58,{"$nulls":3},7.58]
["OR - WBF Assessment Co.",null,0,null,null,{"v":240,"d":"240.00"},{"$nulls":3},{"v":240,"d":"240.00"}]
[null,null,0,null,null,{"v":1741.57,"d":"1,741.57"},{"$nulls":3},{"v":1741.57,"d":"1,741.57"}]
["Employer Paid Benefits"]
["Workers Compensation",null,0,null,null,{"v":670.8,"d":"670.80"},{"$nulls":3},{"v":670.8,"d":"670.80"}]
["Total Employer Expense",null,0,null,null,{"v":13592.369999999999,"d":"13,592.37"},{"$nulls":3},{"v":13592.369999999999,"d":"13,592.37"}]

{"sheet":"Tax Balances","index":7,"n_rows":43,"n_cols":12,"rows_kept":43,"hidden":true,"merged":[[0,0,0,3],[0,9,0,11],[2,3,2,4],[2,5,2,6],[2,7,2,8],[2,9,2,10],[7,3,7,4],[7,5,7,6],[7,7,7,8],[7,9,7,10],[19,0,19,3],[19,9,19,11],[21,3,21,4],[26,3,26,4],[32,0,32,3],[32,9,32,11],[34,3,34,4],[34,5,34,6],[34,7,34,8],[34,9,34,10],[39,3,39,4],[39,5,39,6],[39,7,39,8],[39,9,39,10]],"flags":["formulas_cached_only"]}
["941 Payroll Liabilities and Payments",{"$nulls":8},"Aug 31, 2006 - Aug 31, 2006"]
[]
["Wages & Accrued Taxes",null,null,"Federal W/H",null,"AEIC",null,"Social Security",null,"Medicare"]
[null,null,"Payroll Date","Wagebase","Amount","Wagebase","Amount","Wagebase","Amount","Wagebase","Amount","Total Tax"]
[null,null,"2006-08-31",{"v":11080,"d":"11,080.00"},{"v":2875,"d":"2,875.00"},null,null,{"v":11180,"d":"11,180.00"},{"v":1386.32,"d":"1,386.32"},{"v":11180,"d":"11,180.00"},324.22,{"v":4585.54,"d":"4,585.54"}]
["Total Wages & Accrued Taxes",null,null,{"v":11080,"d":"11,080.00"},{"v":2875,"d":"2,875.00"},0,0,{"v":11180,"d":"11,180.00"},{"v":1386.32,"d":"1,386.32"},{"v":11180,"d":"11,180.00"},324.22,{"v":4585.54,"d":"4,585.54"}]
[]
["Tax Payments",null,null,"Federal W/H",null,"AEIC",null,"Social Security",null,"Medicare"]
["Paid to","Check Date","Payroll Date",null,"Amount",null,"Amount",null,"Amount",null,"Amount","Total Tax"]
["Total Tax Payments"]
["Unpaid Tax Liability",{"$nulls":3},{"v":2875,"d":"2,875.00"},null,0,null,{"v":1386.32,"d":"1,386.32"},null,324.22,{"v":4585.54,"d":"4,585.54"}]
[]
["Federal 941 Tax Summary",null,"54-2003714"]
["Payment Amount Due",null,{"v":4585.54,"d":"4,585.54"}]
["001 Social Security",null,{"v":1386.32,"d":"1,386.32"}]
["002 Medicare",null,324.22]
["003 Tax Withholding",null,{"v":2875,"d":"2,875.00"}]
[]
[]
["940 Payroll Liabilities and Payments",{"$nulls":8},"Aug 31, 2006 - Aug 31, 2006"]
[]
["Wages & Accrued Taxes",null,null,"FUTA"]
[null,null,"Payroll Date","Wagebase","Amount"]
[null,null,"2006-08-31",{"v":1180,"d":"1,180.00"},9.44]
["Total Wages & Accrued Taxes",null,null,{"v":1180,"d":"1,180.00"},9.44]
[]
["Tax Payments",null,null,"FUTA"]
["Paid to","Check Date","Payroll Date",null,"Amount"]
["Total Tax Payments"]
["Unpaid Tax Liability",{"$nulls":3},9.44]
[]
[]
["State Payroll Liabilities and Payments",{"$nulls":8},"Aug 31, 2006 - Aug 31, 2006"]
[]
["Wages & Accrued Taxes",null,null,"State W/H",null,"SUI",null,"SDI",null,"Other Taxes"]
[null,null,"Payroll Date","Wagebase","Amount","Wagebase","Amount","Wagebase","Amount","Wagebase","Amount","Total Tax"]
[null,null,"2006-08-31",{"v":1080,"d":"1,080.00"},{"v":74,"d":"74.00"},{"v":1180,"d":"1,180.00"},{"v":35.4,"d":"35.40"},{"v":10000,"d":"10,000.00"},{"v":125,"d":"125.00"},"Various",585.66,{"v":1930.83,"d":"1,930.83"}]
["Total Wages & Accrued Taxes",null,null,{"v":1080,"d":"1,080.00"},{"v":74,"d":"74.00"},{"v":1180,"d":"1,180.00"},{"v":35.4,"d":"35.40"},{"v":10000,"d":"10,000.00"},{"v":125,"d":"125.00"},0,585.66,{"v":1930.83,"d":"1,930.83"}]
[]
["Tax Payments",null,null,"State W/H",null,"SUI",null,"SDI",null,"Other Taxes"]
["Paid to","Check Date","Payroll Date",null,"Amount",null,"Amount",null,"Amount",null,"Amount","Total Tax"]
["Total Tax Payments"]
["Unpaid Tax Liability",{"$nulls":3},{"v":74,"d":"74.00"},null,{"v":35.4,"d":"35.40"},null,{"v":125,"d":"125.00"},null,585.66,{"v":1930.83,"d":"1,930.83"}]

{"sheet":"Scratch","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true,"flags":["formulas_cached_only"]}

{"sheet":"Welcome","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true,"flags":["formulas_cached_only"]}

{"sheet":"Supporting Settings","index":10,"n_rows":40,"n_cols":7,"rows_kept":40,"hidden":true,"flags":["formulas_cached_only"]}
["DateRange","31-Aug-2006 to 31-Aug-2006"]
["Version Number",0.61,{"$nulls":4},"QBCurrentFiscalYear"]
["StartDate","2006-08-31",{"$nulls":4},"QBCurrentTaxYear"]
["EndDate","2006-08-31",{"$nulls":4},"QBFederalID"]
["LastStartDate","2006-08-31",{"$nulls":4},"QBLegalCompanyName"]
["LastEndDate","2006-08-31",{"$nulls":4},"QBLegalAddress1"]
["ShowNewUserMessage",false,{"$nulls":4},"QBLegalAddress2"]
["ShowFinishedMessage",true,{"$nulls":4},"QBLegalCity"]
["ShowUpdateOnOpen",true,{"$nulls":4},"QBLegalState"]
["OnErrorResume",true,{"$nulls":4},"QBLegalZip"]
["HideActivity",true,{"$nulls":4},"QBRegistrationNumber"]
["HideData",true,{"$nulls":4},"QBSKU"]
["UpdateReportColumnWidths",true]
["MinimumWage",5.15]
["maskSSN","Mask ***-**-1234"]
[]
[]
[]
[]
["DateRangeSelected","This Year"]
["ToolBarView",1]
["ToolBarTop",200]
["ToolBarLeft",0]
["ConvertNamesUpper",false]
["ClipFirstName",25]
["ClipMI",5]
["ClipLastName",25]
["LastUpdateFromQB","Never"]
["FirstUsedDate"]
["UseQBCoInfo",true]
["DrillDownSupport",true]
["GetDataStartTime","2006-08-16T21:16:36"]
["GetDataEndTime","2006-08-16T21:16:37"]
["ConsolidateData",false]
["EECustomData",false]
["ToolBarRowIndex",50]
[]
[]
["These are the user titles for EE custom settings. Don't move them:"]
["Custom1","Custom2","Custom3","Custom4"]

{"sheet":"Data","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true,"flags":["formulas_cached_only"]}

{"sheet":"DataPriorYear","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true,"flags":["formulas_cached_only"]}

{"sheet":"DataComparison","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true,"flags":["formulas_cached_only"]}

{"sheet":"EE_Data","index":14,"n_rows":1,"n_cols":1,"rows_kept":1,"hidden":true,"flags":["formulas_cached_only"]}
["extra"]

{"sheet":"TempData","index":15,"n_rows":1,"n_cols":1,"rows_kept":1,"hidden":true,"flags":["formulas_cached_only"]}
["extra"]