{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["General Info","P&L&BS","Codes","Auto Expense Info","Dropdowns"],"not_rendered":{"charts":0,"images":17,"macros":1,"external_links":0,"defined_names":3,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"General Info","index":0,"n_rows":102,"n_cols":2,"rows_kept":102,"cut":false,"hidden":false,"merged":[[0,0,0,1],[101,0,101,1]]}
[{"$f":"IF(B2=\"\",\"General Information for…\",\"General Information for \" &B2)","v":"General Information for…"}]
["Company Name as stated on the State's Arcticles"]
["Filing Year: 20XX??"]
["Tax ID #:"]
["Mailing (Street) Address of Corp (International OK):"]
["City, State, Zip"]
["State of Incorporation:"]
["Tax Status:","Tax Status"]
["S-Election Date with IRS, if applicable"]
["S-Election Date with State of Incorp, if applicable"]
["Preferred Person of Contact for Corporation:"]
[]
["Shareholder/Partner Info"]
[]
["Shareholder/Partner 1 Legal Name:"]
["Officer? (Pres/VP/Treasurer/Director, etc)","Officer?"]
[{"$f":"IF($B$3=\"\",\"Percentage Ownership as of 12/31/XX\",\"Percentage Ownership as of 12/31/\" &RIGHT($B$3,2))","v":"Percentage Ownership as of 12/31/XX"}]
["Percentage of Time Devoted to Business"]
["Social Security # or ITIN #"]
["Date of Birth xx/xx/xxxx"]
["Address"]
["City, State, Zip"]
["Email"]
["Phone #:"]
[{"$f":"IF($B$3=\"\",\"Capital Invested in company before filing year ('BASIS')\",\"Capital Invested in Company before \"&$B$3)","v":"Capital Invested in company before filing year ('BASIS')"}]
["Percentage of Company Debt Fully Liable for (Recourse Debt) if Business Fails"]
[]
[]
[]
["Shareholder/Partner 2 Legal Name:"]
["Officer? (Pres/VP/Treasurer/Director, etc)","Officer?"]
[{"$f":"IF($B$3=\"\",\"Percentage Ownership as of 12/31/XX\",\"Percentage Ownership as of 12/31/\" &RIGHT($B$3,2))","v":"Percentage Ownership as of 12/31/XX"}]
["Percentage of Time Devoted to Business"]
["Social Security # or ITIN #"]
["Date of Birth xx/xx/xxxx"]
["Address"]
["City, State, Zip"]
["Email"]
["Phone #:"]
[{"$f":"IF($B$3=\"\",\"Capital Invested in company before filing year ('BASIS')\",\"Capital Invested in Company before \"&$B$3)","v":"Capital Invested in company before filing year ('BASIS')"}]
["Percentage of Company Debt Fully Liable for (Recourse Debt) if Business Fails"]
[]
[]
[]
["Shareholder/Partner 3 Legal Name:"]
["Officer? (Pres/VP/Treasurer/Director, etc)","Officer?"]
[{"$f":"IF($B$3=\"\",\"Percentage Ownership as of 12/31/XX\",\"Percentage Ownership as of 12/31/\" &RIGHT($B$3,2))","v":"Percentage Ownership as of 12/31/XX"}]
["Percentage of Time Devoted to Business"]
["Social Security # or ITIN #"]
["Date of Birth xx/xx/xxxx"]
["Address"]
["City, State, Zip"]
["Email"]
["Phone #:"]
[{"$f":"IF($B$3=\"\",\"Capital Invested in company before filing year ('BASIS')\",\"Capital Invested in Company before \"&$B$3)","v":"Capital Invested in company before filing year ('BASIS')"}]
["Percentage of Company Debt Fully Liable for (Recourse Debt) if Business Fails"]
[]
[]
[]
["Shareholder/Partner 4 Legal Name:"]
["Officer? (Pres/VP/Treasurer/Director, etc)","Officer?"]
[{"$f":"IF($B$3=\"\",\"Percentage Ownership as of 12/31/XX\",\"Percentage Ownership as of 12/31/\" &RIGHT($B$3,2))","v":"Percentage Ownership as of 12/31/XX"}]
["Percentage of Time Devoted to Business"]
["Social Security # or ITIN #"]
["Date of Birth xx/xx/xxxx"]
["Address"]
["City, State, Zip"]
["Email"]
["Phone #:"]
[{"$f":"IF(B46=\"\",\"Capital Invested in company before filing year ('BASIS')\",\"Capital Invested in Company before \"&B46)","v":"Capital Invested in Company before Officer?"}]
["Portion of Company Debt Fully Liable for (Recourse Debt)"]
[]
[]
[]
["Shareholder/Partner 5 Legal Name:"]
["Officer? (Pres/VP/Treasurer/Director, etc)","Officer?"]
[{"$f":"IF($B$3=\"\",\"Percentage Ownership as of 12/31/XX\",\"Percentage Ownership as of 12/31/\" &RIGHT($B$3,2))","v":"Percentage Ownership as of 12/31/XX"}]
["Percentage of Time Devoted to Business"]
["Social Security # or ITIN #"]
["Date of Birth xx/xx/xxxx"]
["Address"]
["City, State, Zip"]
["Email"]
["Phone #:"]
[{"$f":"IF($B$3=\"\",\"Capital Invested in company before filing year ('BASIS')\",\"Capital Invested in Company before \"&$B$3)","v":"Capital Invested in company before filing year ('BASIS')"}]
["Percentage of Company Debt Fully Liable for (Recourse Debt) if Business Fails"]
[]
[]
[]
["Shareholder/Partner 6 Legal Name:"]
["Officer? (Pres/VP/Treasurer/Director, etc)","Officer?"]
[{"$f":"IF($B$3=\"\",\"Percentage Ownership as of 12/31/XX\",\"Percentage Ownership as of 12/31/\" &RIGHT($B$3,2))","v":"Percentage Ownership as of 12/31/XX"}]
["Percentage of Time Devoted to Business"]
["Social Security # or ITIN #"]
["Date of Birth xx/xx/xxxx"]
["Address"]
["City, State, Zip"]
["Email"]
["Phone #:"]
[{"$f":"IF($B$3=\"\",\"Capital Invested in company before filing year ('BASIS')\",\"Capital Invested in Company before \"&$B$3)","v":"Capital Invested in company before filing year ('BASIS')"}]
["Percentage of Company Debt Fully Liable for (Recourse Debt) if Business Fails"]
["***Attach more sheets as necessary, for additional shareholders/partners….***"]

{"sheet":"P&L&BS","index":1,"n_rows":102,"n_cols":15,"rows_kept":102,"cut":false,"hidden":false,"merged":[[0,1,0,3],[0,7,0,9],[1,1,1,3],[68,1,70,1],[68,2,70,2],[3,7,3,10],[2,2,3,3],[63,1,63,2],[15,2,15,3],[15,8,15,11],[22,7,23,7],[22,8,23,8],[30,8,30,10],[33,8,33,10],[41,8,41,10],[36,8,36,10],[29,7,29,10],[25,7,25,10],[26,8,26,10]]}
[null,{"$f":"IF('General Info'!B2<>\"\", 'General Info'!B2& \" Profit Loss & Balance Sheet Info for the Year Ended Dec 31st, \" &'General Info'!B3,\"Profit Loss & Balance Sheet Info for the Year ended 12/31/xx\")","v":"Profit Loss & Balance Sheet Info for the Year ended 12/31/xx"},null,null,null,null,null,{"$f":"IF('General Info'!B2<>\"\", 'General Info'!B2& \" Profit Loss & Balance Sheet Info for the Year Ended Dec 31st, \" &'General Info'!B3,\"Profit Loss & Balance Sheet Info for the Year ended 12/31/xx\")","v":"Profit Loss & Balance Sheet Info for the Year ended 12/31/xx"}]
[null,"Do the best you can!!!  The more you tell us, the lower your tax bill!"]
[null,{"$f":"IF(OR('General Info'!B2=0,'General Info'!B2=\"\"),\"\",'General Info'!B2)","v":""},"Mention the amount expensed from the correct account. If you have expensed it on a credit card (\"CC\"), mention from which account that month's CC bill was paid.",null,null,null,null,{"$f":"IF(OR('General Info'!B2=0,'General Info'!B2=\"\"),\"\",'General Info'!B2)","v":""}]
["Acct #","Profit Loss Info ",null,null,"Tax Code 1120S","Tax Code 1065","Tax Code 1120","Balance Sheet Info ",null,null,null,null,"Tax Code 1120S","Tax Code 1065","Tax Code 1120"]
["TB1","Total Income/Gross Sales",null,null,100]
[null,null,"Company Checking/Savings ($)","Personal Checking/Savings ($)"]
["TB2","Returns & Allowances",null,null,101,null,null,"Bank Balance Info (All Banks)","Bank 1","Bank 2","Bank 3"]
[null,"Inventory at beginning of year",null,null,null,null,null,{"$f":"IF('General Info'!B2<>\"\", \"Bank Balance as of Dec. 31st, \" &'General Info'!B2, \"Balance as of Beginning of Tax Year\")","v":"Balance as of Beginning of Tax Year"}]
["TB3","Inventory Purchased",null,null,275,null,null,{"$f":"IF('General Info'!B3<>\"\", \"Bank Balance as of Dec. 31st, \" &'General Info'!B3, \"Balance as of 12/31/xx\")","v":"Balance as of 12/31/xx"},null,null,null,null,400]
[null,"Personal use of inventory"]
["TB4","Cost of labor",null,null,276,null,null,"Investments held in Co. name.","Brokerage House 1","Brokerage House 2","Brokerage House 3"]
["TB5","Merchant (Credit Card) Costs",null,null,276,null,null,"Beginning Bal last (year for filing) year:"]
[null,"Other Inventory Costs"]
["TB6","Inventory left at end of year",null,null,280,null,null,{"$f":"IF('General Info'!B3<>\"\", \"Bank Balance as of Dec. 31st, \" &'General Info'!B3, \"Balance as of 12/31/xx\")","v":"Balance as of 12/31/xx"}]
[null,"Cost of Goods Sold",{"$f":"C8+C9-C10+C11+C12+C13-C14","v":0},{"$f":"D8+D9-D10+D11+D12-D14","v":0}]
[null,"Gross Profit",{"$f":"C5-C7-D7-C15-D15","v":0},null,null,null,null,"Any new Vehicles, Machinery, Equipment (Computers, etc.) Bought","Attach another sheet for more assets, if necessary…"]
[null,null,null,null,null,null,null,null,"Asset 1 Description:","Asset 2 Description:","Asset 3 Description:","Asset 4 Description:"]
["TB7",{"$f":"IF('General Info'!$B$16=\"YES\",\"Compensation (W2 Salary - Box 5) for \"&'General Info'!$B$15,\"Compensation (W2 Salary - Box 5) - Officer 1\")","v":"Compensation (W2 Salary - Box 5) - Officer 1"},null,null,200,null,null,"Asset 1 Description:","Asset Type","Asset Type","Asset Type","Asset Type"]
["TB8",{"$f":"IF('General Info'!$B$31=\"YES\",\"Compensation (W2 Salary - Box 5) for \"&'General Info'!$B$30,\"Compensation (W2 Salary - Box 5) - Officer 2\")","v":"Compensation (W2 Salary - Box 5) - Officer 2"},null,null,200,null,null,"Purchase Price:"]
["TB9",{"$f":"IF('General Info'!$B$46=\"YES\",\"Compensation (W2 Salary - Box 5) for \"&'General Info'!$B$45,\"Compensation (W2 Salary - Box 5) Officer 3\")","v":"Compensation (W2 Salary - Box 5) Officer 3"},null,null,200,null,null,"Date Bought:"]
["TB10",{"$f":"IF('General Info'!$B$61=\"YES\",\"Compensation (W2 Salary - Box 5) for \"&'General Info'!$B$60,\"Compensation (W2 Salary - Box 5) Officer 4\")","v":"Compensation (W2 Salary - Box 5) Officer 4"},null,null,200,null,null,"If car give Year, Make, and Model:"]
["TB11",{"$f":"IF('General Info'!$B$76=\"YES\",\"Compensation (W2 Salary - Box 5) for \"&'General Info'!$B$75,\"Compensation (W2 Salary - Box 5) - Officer 5\")","v":"Compensation (W2 Salary - Box 5) - Officer 5"},null,null,200]
["TB12",{"$f":"IF('General Info'!$B$91=\"YES\",\"Compensation (W2 Salary - Box 5) for \"&'General Info'!$B$90,\"Compensation (W2 Salary - Box 5) Officer 6\")","v":"Compensation (W2 Salary - Box 5) Officer 6"},null,null,200,null,null,{"$f":"IF('General Info'!B3<>\"\", \"Accounts Payable as of Dec. 31st (To Vendors or Suppliers) \" &'General Info'!B3, \"Accounts Payable as of 12/31/xx (To Vendors or Suppliers)\")","v":"Accounts Payable as of 12/31/xx (To Vendors or Suppliers)"},null,null,null,null,440]
["TB13","Advertising",null,null,209]
["OD1","Bank Charges"]
["OD2","Cash Shortages",null,null,null,null,null,"Short Term Loan or Lease 1 payable in less than 1 year"]
["OD3","Cleaning & Laundry",null,null,null,null,null,"Short Term Loan Description (Lender, Original Loan Amount, Maturity Date, Amortization Period):"]
["OD4","Commissions",null,null,null,null,null,"Loan/Lease Balance as of Dec 31st, 2018",null,null,null,null,441]
["OD5","Dues & Subscriptions"]
["OD6","Insurance (Except Auto)",null,null,null,null,null,"Long Term Loans or Leases (E.g., car, machinery, bldg, etc. payable in more than 1 year)"]
["OD7","Legal & Professional",null,null,null,null,null,"Loan or Lease 1 Description (Lender, Original Loan Amount, Maturity Date, Amortization Period):"]
["TB14","Taxes (Employer Payroll Taxes, State Income, Excise, Etc) & Licenses",null,null,205,null,null,"Beginning Bal last (year for filing) year:"]
["OD8","Office Expenses",null,null,null,null,null,{"$f":"IF('General Info'!B3<>\"\", \"Loan/Lease Balance as of Dec. 31st, \" &'General Info'!B3, \"Loan/Lease as of 12/31/xx\")","v":"Loan/Lease as of 12/31/xx"},null,null,null,null,450]
["OD9","Office Supplies",null,null,null,null,null,"Loan or Lease 2 Description (Lender, Original Loan Amount, Maturity Date, Amortization Period):"]
["OD10","Outside Services",null,null,null,null,null,"Beginning Bal last (year for filing) year:"]
["OD11","Parking",null,null,null,null,null,{"$f":"IF('General Info'!B3<>\"\", \"Loan/Lease Balance as of Dec. 31st, \" &'General Info'!B3, \"Loan/Lease as of 12/31/xx\")","v":"Loan/Lease as of 12/31/xx"},null,null,null,null,450]
["OD12","Postage",null,null,null,null,null,"Loan or Lease 3 Description (Lender, Original Loan Amount, Maturity Date, Amortization Period):"]
["OD13","Supplies",null,null,null,null,null,"Beginning Bal last (year for filing) year:"]
["OD14","Telephone",null,null,null,null,null,{"$f":"IF('General Info'!B3<>\"\", \"Loan/Lease Balance as of Dec. 31st, \" &'General Info'!B3, \"Loan/Lease as of 12/31/xx\")","v":"Loan/Lease as of 12/31/xx"},null,null,null,null,450]
["OD15","Utilities"]
["OD16","Salaries to Officers"]
["OD17","Salaries & Wages to Employees",null,null,null,null,null,"Other Liabilities (Give Description Here)"]
["TB15","Repairs & Maintenance",null,null,202,null,null,"Amount of Liabilities (NOT LOANS):"]
["TB16","Bad Debts (If Included in Income)",null,null,203]
["TB17","Rents",null,null,204]
["TB18","Loan Interest (Except Auto)",null,null,206,null,null,{"$f":"IF('General Info'!B2<>\"\", \" Monies Contributed & Withdrawn in the Year for \" &'General Info'!B2,\"Monies Contributed & Withdrawn in the Year\")","v":"Monies Contributed & Withdrawn in the Year"}]
["TB19","Profit Sharing Plan Contribution",null,null,null,null,null,"Capital Contributions by Shareholders/Partners (FILL FIRST 6 SHAREHOLDERS / PARTNER NAME ON GEN INFO TAB)","For Expenses Paid from Personal Accounts","CASH MONIES GIVEN TO COMPANY"]
["TB20","Employee Benefit Programs",null,null,211,null,null,{"$f":"IF('General Info'!B15=\"\",\"Shareholder/Partner 1, enter name in General Info Tab, or here\",'General Info'!B15)","v":"Shareholder/Partner 1, enter name in General Info Tab, or here"}]
["OD18","Meals and Entertainment",null,null,null,null,null,{"$f":"IF('General Info'!B30=\"\",\"Shareholder/Partner 2, enter name in General Info Tab, or here\",'General Info'!B30)","v":"Shareholder/Partner 2, enter name in General Info Tab, or here"}]
["OD19","Travel (Airlines, Hotels, Conferences)",null,null,null,null,null,{"$f":"IF('General Info'!B45=\"\",\"Shareholder/Partner 3, enter name in General Info Tab, or here\",'General Info'!B45)","v":"Shareholder/Partner 3, enter name in General Info Tab, or here"}]
["OD20","Depreciation (from Auto ExpenseTab)",null,null,null,null,null,{"$f":"IF('General Info'!B60=\"\",\"Shareholder/Partner 4, enter name in General Info Tab, or here\",'General Info'!B60)","v":"Shareholder/Partner 4, enter name in General Info Tab, or here"}]
["OD21","Other Expense, or Rename here",null,null,null,null,null,{"$f":"IF('General Info'!B75=\"\",\"Shareholder/Partner 5, enter name in General Info Tab, or here\",'General Info'!B75)","v":"Shareholder/Partner 5, enter name in General Info Tab, or here"}]
["OD22","Other Expense, or Rename here",null,null,null,null,null,{"$f":"IF('General Info'!B90=\"\",\"Shareholder/Partner 6, enter name in General Info Tab, or here\",'General Info'!B90)","v":"Shareholder/Partner 6, enter name in General Info Tab, or here"}]
["OD23","Other Expense, or Rename here",null,null,null,null,null,"SHAREHOLDER / PARTNER 7 (IF APPLICABLE)"]
["OD24","Other Expense, or Rename here",null,null,null,null,null,"SHAREHOLDER / PARTNER 8 (IF APPLICABLE)"]
["OD25","Other Expense, or Rename here",null,null,null,null,null,"SHAREHOLDER / PARTNER 9 (IF APPLICABLE)"]
["OD26","Other Expense, or Rename here",null,null,null,null,null,"SHAREHOLDER / PARTNER 10 (IF APPLICABLE)"]
["OD27","Other Expense, or Rename here",null,null,null,null,null,"SHAREHOLDER / PARTNER 11 (IF APPLICABLE)"]
["OD28","Other Expense, or Rename here",null,null,null,null,null,"SHAREHOLDER / PARTNER 12 (IF APPLICABLE)"]
["OD29","Other Expense, or Rename here",null,null,null,null,"OVERWRITE NAME HERE-->","SHAREHOLDER / PARTNER 13 (IF APPLICABLE)"]
["OD30","Other Expense, or Rename here",null,null,null,null,"OVERWRITE NAME HERE-->","SHAREHOLDER / PARTNER 14 (IF APPLICABLE)"]
["OD31","Other Expense, or Rename here",null,null,null,null,"OVERWRITE NAME HERE-->","SHAREHOLDER / PARTNER 15 (IF APPLICABLE)"]
["OD32","Other Expense, or Rename here",null,null,null,null,"OVERWRITE NAME HERE-->","SHAREHOLDER / PARTNER 16 (IF APPLICABLE)"]
[null,"Capital Infusion for Expenses by Shareholders/Partners---------------->",null,{"$f":"SUM(D6:D63)","v":0},null,null,"OVERWRITE NAME HERE-->","SHAREHOLDER / PARTNER 17 (IF APPLICABLE)"]
[null,null,null,null,null,null,"OVERWRITE NAME HERE-->","SHAREHOLDER / PARTNER 18 (IF APPLICABLE)"]
[null,null,null,null,null,null,"OVERWRITE NAME HERE-->","SHAREHOLDER / PARTNER 19 (IF APPLICABLE)"]
[null,"Total Expenses",{"$f":"SUM(C24:D58)","v":0},null,null,null,"OVERWRITE NAME HERE-->","SHAREHOLDER / PARTNER 20 (IF APPLICABLE)"]
[null,null,null,null,null,null,"OVERWRITE NAME HERE-->",null,{"$f":"SUM(I48:I67)","v":0},{"$f":"SUM(J48:J67)","v":0}]
[null,"Corporate Profit",{"$f":"C16-C67","v":0},null,null,null,"OVERWRITE NAME HERE-->"]
[null,null,null,null,null,null,"OVERWRITE NAME HERE-->","Capital for Expense Infusion should be close to total expense capital Cell D64."]
[null,null,null,null,null,null,"OVERWRITE NAME HERE-->","Auto Expense Capital Infusion by All",{"$f":"'Auto Expense Info'!B29","v":0}]
[null,{"$f":"IF('General Info'!B2<>\"\",'General Info'!B2,\"\")","v":""},null,null,null,null,"OVERWRITE NAME HERE-->","Total Expense Capital Infusion by All",{"$f":"I68+I71","v":0}]
[null,null,null,null,null,null,"OVERWRITE NAME HERE-->","Total Capital Infusion by All",{"$f":"I72+J68","v":0}]
[null,null,null,null,null,null,null,"Total Capital Infusion (Expense & Capital)",{"$f":"I71+I72+I73","v":0}]
[]
[null,null,null,null,null,null,null,"Capital Contributions by Shareholders/Partners (FILL FIRST 6 SHAREHOLDERS / PARTNER NAME ON GEN INFO TAB)","Distributions ($) -- (Means money withdrawn during year  from company checking account)"]
[null,null,null,null,null,null,null,{"$f":"IF('General Info'!B15=\"\",\"\",'General Info'!B15)","v":""},null,null,null,null,466]
[null,null,null,null,null,null,null,{"$f":"IF('General Info'!B30=\"\",\"\",'General Info'!B30)","v":""},null,null,null,null,466]
[null,null,null,null,null,null,null,{"$f":"IF('General Info'!B45=\"\",\"\",'General Info'!B45)","v":""},null,null,null,null,466]
[null,null,null,null,null,null,null,{"$f":"IF('General Info'!B60=\"\",\"\",'General Info'!B60)","v":""},null,null,null,null,466]
[null,null,null,null,null,null,null,{"$f":"IF('General Info'!B75=\"\",\"\",'General Info'!B75)","v":""},null,null,null,null,466]
[null,null,null,null,null,null,null,{"$f":"IF('General Info'!B90=\"\",\"\",'General Info'!B90)","v":""},null,null,null,null,466]
[null,null,null,null,null,null,null,"SHAREHOLDER / PARTNER 7 (IF APPLICABLE)",null,null,null,null,466]
[null,null,null,null,null,null,null,"SHAREHOLDER / PARTNER 8 (IF APPLICABLE)",null,null,null,null,466]
[null,null,null,null,null,null,null,"SHAREHOLDER / PARTNER 9 (IF APPLICABLE)",null,null,null,null,466]
[null,null,null,null,null,null,null,"SHAREHOLDER / PARTNER 10 (IF APPLICABLE)",null,null,null,null,466]
[null,null,null,null,null,null,null,"SHAREHOLDER / PARTNER 11 (IF APPLICABLE)",null,null,null,null,466]
[null,null,null,null,null,null,null,"SHAREHOLDER / PARTNER 12 (IF APPLICABLE)",null,null,null,null,466]
[null,null,null,null,null,null,"OVERWRITE NAME HERE-->","SHAREHOLDER / PARTNER 13 (IF APPLICABLE)",null,null,null,null,466]
[null,null,null,null,null,null,"OVERWRITE NAME HERE-->","SHAREHOLDER / PARTNER 14 (IF APPLICABLE)",null,null,null,null,466]
[null,null,null,null,null,null,"OVERWRITE NAME HERE-->","SHAREHOLDER / PARTNER 15 (IF APPLICABLE)",null,null,null,null,466]
[null,null,null,null,null,null,"OVERWRITE NAME HERE-->","SHAREHOLDER / PARTNER 16 (IF APPLICABLE)",null,null,null,null,466]
[null,null,null,null,null,null,"OVERWRITE NAME HERE-->","SHAREHOLDER / PARTNER 17 (IF APPLICABLE)",null,null,null,null,466]
[null,null,null,null,null,null,"OVERWRITE NAME HERE-->","SHAREHOLDER / PARTNER 18 (IF APPLICABLE)",null,null,null,null,466]
[null,null,null,null,null,null,"OVERWRITE NAME HERE-->","SHAREHOLDER / PARTNER 19 (IF APPLICABLE)",null,null,null,null,466]
[null,null,null,null,null,null,"OVERWRITE NAME HERE-->","SHAREHOLDER / PARTNER 20 (IF APPLICABLE)",null,null,null,null,466]
[null,null,null,null,null,null,"OVERWRITE NAME HERE-->",null,{"$f":"SUM(I77:I96)","v":0}]
[null,null,null,null,null,null,"OVERWRITE NAME HERE-->"]
[null,null,null,null,null,null,"OVERWRITE NAME HERE-->"]
[null,null,null,null,null,null,"OVERWRITE NAME HERE-->"]
[null,null,null,null,null,null,"OVERWRITE NAME HERE-->"]
[null,null,null,null,null,null,"OVERWRITE NAME HERE-->"]

{"sheet":"Codes","index":2,"n_rows":148,"n_cols":9,"rows_kept":148,"cut":false,"hidden":true,"merged":[]}
["Account Number","Account Description","Amount","1120S Codes",null,"Account Description","Amount","1065 Codes","1120 Codes"]
[null,"Gross receipts or sales",{"$f":"'P&L&BS'!C5","v":0},100,null,"Gross receipts or sales",null,100]
[null,"Returns and allowances",{"$f":"'P&L&BS'!C7","v":0},101,null,"Returns and allowances",null,101]
[null,"Other Income",null,102,null,"Other Income",null,103]
[null,"State Tax Refunds",null,103,null,"Salareis and wages",null,200]
[null,"Salareis and wages",null,201,null,"Guaranteed payments to partners",null,201]
[null,"Repairs and maintenance",null,202,null,"Repairs and maintenance",null,202]
[null,"Bad debts",null,203,null,"Bad debts",null,203]
[null,"Rents",null,204,null,"Rents",null,204]
[null,"Taxes and licenses",null,205,null,"Taxes and licenses",null,205]
[null,"Interest",null,206,null,"Interest",null,206]
[null,"Depletion (other than oil  gas, Book amount)",null,208,null,"Book depreciation",null,207]
[null,"Advertising",null,209,null,"Depletion (other than oil & gas)",null,208]
[null,"Pension, Profit sharing paid",null,210,null,"Retirement Plans, etc.",null,209]
[null,"Employee benefit programs",null,211,null,"Employee benefit programs",null,210]
[null,"Other Deductions",null,212,null,"Other Deductions",null,211]
[null,"Meals",null,213,null,"Meals (50%)",null,212]
[null,"Total Book Amortization",null,214,null,"Meals (DOT)",null,213]
[null,"Meals (DOT)",null,215,null,"Book amortization",null,214]
[null,"Pension, Proit sharing accrued",null,219,null,"Book depreciation (COGS)",null,280]
[null,"Estimated tax payments and overpayment credited",null,300,null,"Interest Income",null,110]
[null,"Other Interest (Income)",null,150,null,"Dividends and dividend equivalents",null,111]
[null,"US Obligation Interest (Income)",null,151,null,"Other portfolio inc (loss)",null,112]
[null,"Ordinary dividends",null,156,null,"Other income",null,114]
[null,"Qualified dividends",null,152,null,"Mining expl. costs recap.",null,116]
[null,"Portfolio Income (Loss)",null,153,null,"Cancellation of debt",null,117]
[null,"Other Income (Loss)",null,154,null,"Start up / org costs - book",null,215]
[null,"Mining Exploration Cost Recapture",null,155,null,"Contributions (100%)",null,224]
[null,"Section 179-Book Deduction",null,228,null,"Cash contributions (60%)",null,225]
[null,"Cash Contribution (Charity) 50%",null,225,null,"Cash contributions (30%)",null,226]
[null,"Cash Contribution (Charity) 30%",null,226,null,"Capital gain property (20%)",null,227]
[null,"Capital Gain Property (20%)",null,227,null,"Sec 179 exp. Book",null,228]
[null,"Investment interest expense",null,231,null,"Other Deductions",null,230]
[null,null,null,234,null,"Investment interest expense",null,232]
[null,"Noncash Contribution (Charity) 50%",null,247,null,"Section 59(e)(2) expenditures(1)",null,234]
[null,"Noncash Contribution (Charity) 30%",null,248,null,"Foreign Taxes Paid",null,233]
[null,"Capital Gain Property to 50% Organization (30%)",null,249,null,"Educational asst. benefits",null,235]
[null,"Qualified Conservation Contribution (50%)",null,390,null,"Dependent care benefits",null,236]
[null,"Qualified Conservation Contribution (100%)",null,391,null,"Penalty early withdrawal of savings",null,238]
[null,"Other Portfolio Deductions",null,245,null,"Pensions and IRAs",null,239]
[null,"Preproductive Period Expenses",null,237,null,"Deductions-portfolio (other)",null,243]
[null,"Penalty on Early Withdrawals",null,238,null,"Health insurance as guaranteed payments",null,244]
[null,"Other Deductions",null,230,null,"Health insurance as guaranteed payments",null,245]
[null,"Commercial Revitalization Deduction",null,236,null,"Foreign Taxes Accrued",null,246]
[null,"Reforestation Expenses",null,246,null,"Comm. Revitalization ded. ",null,247]
[null,"Gross income rom all sources",null,141,null,"Noncash Contributions (Charity) 50%",null,240]
[null,"Gross income sourced at shareholder level",null,140,null,"Noncash Contributions (Charity) 30%",null,241]
[null,"Interest expense",null,240,null,"Cap. Gain prop to 50% org.",null,242]
[null,"Other",null,241,null,"Pensoins and IRAs as guaranteed payments",null,268]
[null,"Section 951A category",null,242,null,"Purchases",null,275]
[null,"Foreign Branch category",null,242,null,"Cost of Labor",null,276]
[null,"Passive category",null,242,null,"Additional Section 263A costs",null,277]
[null,"General category",null,242,null,"Other Costs",null,278]
[null,"Other",null,242,null,"Inventory at end of year",null,279]
[null,"Dividend distributions from accumulated earnings and profits",null,498,null,"Pensoins and IRAs as guaranteed payments",null,635]
[null,"Cash",null,400,null,"Pensoins and IRAs as guaranteed payments",null,588]
[null,"Trade notes and accounts receivable",null,401,null,"Pensoins and IRAs as guaranteed payments",null,778]
[null,"Less allowances for bad debts",null,402,null,"Cash",null,400]
[null,"Inventories",null,280,null,"Trade notes and AR",null,401]
[null,"US government obligations",null,404,null,"Less allowance for bad debts",null,402]
[null,"Tax-exempt securities",null,405,null,"Inventories",null,279]
[null,"Other Current Assets",null,406,null,"US government obligations",null,404]
[null,"Prepaid Federal Income Tax",null,407,null,"Tax-exempt securities",null,405]
[null,"Prepaid State Tax",null,408,null,"Other current assets",null,406]
[null,"Prepaid City Tax",null,410,null,"Loans to partners",null,407]
[null,"Loans to shareholders",null,409,null,"Mortgage and real estate loans",null,415]
[null,"Mortgage and real estate loans",null,415,null,"Other investments",null,416]
[null,"Other investments",null,416,null,"Buildings and other depreciable assets",null,425]
[null,"Buildings and other depreciable assets",null,425,null,"Less accumulated depreciation",null,426]
[null,"Less accumulated depreciation",null,426,null,"Depletable assets",null,427]
[null,"Depletable assets",null,427,null,"Less accumulated depletion",null,428]
[null,"Less accumulated depletion",null,428,null,"Land (net of any amortization)",null,429]
[null,"Land (net of any amortization)",null,429,null,"Intangible assets (amortizable only)",null,430]
[null,"Intangible assets (amortizable only)",null,430,null,"Less accumulated amortization",null,431]
[null,"Less accumulated amortization",null,431,null,"Other assets",null,432]
[null,"Other assets",null,432,null,"Accounts payable",null,440]
[null,"Accounts payable",null,440,null,"Mortgages, notes, bonds payable in less than 1 year",null,441]
[null,"Mortgages, notes, bonds payable in less than 1 y ear",null,441,null,"Other current liabilities",null,442]
[null,"Other Current Liability",null,442,null,"All nonrecourse loans",null,443]
[null,"Federal Income Tax Payable",null,443,null,"Loans from partners (or persons related to partners)",null,444]
[null,"State Tax Payable",null,444,null,"Mortgages, notes, bonds payable in 1 year or more",null,450]
[null,"City Tax Payable",null,446,null,"Other liabilities",null,451]
[null,"Loans from shareholders",null,445,null,"Partners capital accounts",null,465]
[null,"Mortgages, notes, bonds payable in 1 y ear or more",null,450,null,"Income included on Schedule K, lines 1, 2, 3c, 5, 6a, 7, 8, 9a, 10, & 11, no trecorded on books this  year",null,480]
[null,"Other liabilities",null,451,null,"Travel & entertainment",null,481]
[null,"Capital stock",null,465,null,"Capital contributed (Cash)",null,485]
[null,"Additional paid-in capital",null,466,null,"Capital contributed (property)",null,490]
[null,"Retained Earnings-Unappropriated",null,467,null,"Other increases",null,486]
[null,"Accumulated Adjustments Account",null,468,null,"Tax-exempt securities",null,482]
[null,"Other Adjustments Account",null,469,null,"Depreciation",null,483]
[null,"Undistributed Taxed Income",null,470,null,"Distributions (cash)",null,487]
[null,"Retained Earnings Timing Differences",null,839,null,"Distributions (Property)",null,488]
[null,"Adjustments to shareholders' equity",null,471,null,"Other decreases ",null,489]
[null,"Less cost of treasury stock",null,472,null,"4797 gain/loss - book",null,491]
[null,"Fines & Penalties",null,479,null,"Capital gain distributions",null,399]
[null,"Book Expenses",null,482,null,"Gross rents",null,502]
[null,"Exp Related to Tax Exempt Income",null,483,null,"Gross royalties",null,582]
[null,"Amortization",null,214,null,"Other income",null,590]
[null,"Nondeductible entertainment",null,855,null,"Advertising",null,503]
[null,"Organization/start-up Book Expense",null,218,null,"Auto and travel",null,504]
[null,"Officer's Life-Insurance Premiums",null,484,null,"Cleaning and maintenance",null,505]
[null,"Oil & Gas Depltion-Book",null,499,null,"Commissions",null,506]
[null,"Book Income",null,485,null,"Insurance",null,507]
[null,"Cash Surrender Value Officer's Life",null,487,null,"Legal and professional",null,508]
[null,"Unappropriated/Timing Differences",null,"RE",null,"Interest",null,509]
[null,"Nondividend Distributions",null,497,null,"Repairs",null,510]
[null,"Amortization",null,214,null,"Taxes",null,511]
[null,"Deductions",null,489,null,"Utilities",null,512]
[null,"4797 Gain/Loss-Book",null,488,null,"Wages and salaries",null,513]
[null,"Other additions AAA",null,490,null,"Depletion (C Corporation)",null,514]
[null,"Other reductions AAA",null,492,null,"Other Expenses",null,515]
[null,"Distributions AAA",null,494,null,"Meals",null,585]
[null,"Distributions Shareholders' Undistributable taxa le income previously taxed",null,496,null,"Meals (DOT)",null,586]
[null,"Other additions OAA",null,491,null,"Guaranteed payments to partners",null,588]
[null,"Other reductions OAA",null,493,null,"Guaranteed payments to partners",null,589]
[null,"Distributions OAA",null,495,null,"Guaranteed payments to partners",null,584]
[null,"Purchases",null,275,null,"Amortization",null,587]
[null,"Cost of Labor",null,276]
[null,"Additional Section 263A Costs",null,277]
[null,"Meals & Entertianment",null,281]
[null,"Meals (DOT)",null,282]
[null,"Other Costs",null,278]
[null,"Per-unit retain allocations paid in qualified per-unit retain certificates (Cooperative Associaiton only)",null,284]
[null,"Per-unit retain allocations paid in money or other property (Cooperative Associaiton only)",null,285]
[null,"Nonqualified per-unit retain certificates redeemed this year (Cooperative Association only)",null,286]
[null,"Inventory at end of year",null,280]
[null,"Compensation (Officers)",null,200]
[null,"Capital gain distributions",null,125]
[null,"Capital gain distribution ",null,104]
[null,"Capital gain distribution (28%)",null,105]
[null,"Gross rents",null,502]
[null,"Gross royalties",null,582]
[null,"Other income",null,590]
[null,"Advertising",null,503]
[null,"Auto and travel",null,504]
[null,"Cleaning and maintenance",null,505]
[null,"Commissions",null,506]
[null,"Insurance",null,507]
[null,"Legal and professional",null,508]
[null,"Interest",null,509]
[null,"Repairs",null,510]
[null,"Taxes",null,511]
[null,"Utilities",null,512]
[null,"Wages and salaries",null,513]
[null,"Depletion (C Corporation)",null,588]
[null,"Other Expenses",null,515]
[null,"Meals",null,585]
[null,"Meals (DOT)",null,586]

{"sheet":"Auto Expense Info","index":3,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[[28,0,29,0],[28,1,29,1],[22,0,23,7],[0,1,1,1],[0,3,1,3],[0,5,1,5],[0,7,1,7]]}
["ANNUAL AUTO EXPENSES:",{"$f":"IF(OR('P&L&BS'!I18=Dropdowns!A8,'P&L&BS'!I18=Dropdowns!A9,'P&L&BS'!I18=Dropdowns!A10,'P&L&BS'!I18=Dropdowns!A11),'P&L&BS'!I21,\"\")","v":""},"From Which Account Spent?",{"$f":"IF(OR('P&L&BS'!J18=Dropdowns!A8,'P&L&BS'!J18=Dropdowns!A9,'P&L&BS'!J18=Dropdowns!A10,'P&L&BS'!J18=Dropdowns!A11),'P&L&BS'!J18,\"\")","v":""},"From Which Account??",{"$f":"IF(OR('P&L&BS'!K18=Dropdowns!A8,'P&L&BS'!K18=Dropdowns!A9,'P&L&BS'!K18=Dropdowns!A10,'P&L&BS'!K18=Dropdowns!A11),'P&L&BS'!K18,\"\")","v":""},"From Which Account??",{"$f":"IF(OR('P&L&BS'!L18=Dropdowns!A8,'P&L&BS'!L18=Dropdowns!A9,'P&L&BS'!L18=Dropdowns!A10,'P&L&BS'!L18=Dropdowns!A11),'P&L&BS'!L18,\"\")","v":""},"From Which Account??"]
["Or name your vehicles here:",null,"Company    Chcking/Personal?",null,"Company Chcking/Personal?",null,"Company   Chcking/Personal?",null,"Company Chcking/Personal?"]
["Parking & Tolls",null,"",null,"",null,"",null,""]
["Car Loan Interest",null,"",null,"",null,"",null,""]
["Gasoline & Oil",null,"",null,"",null,"",null,""]
["Repairs",null,"",null,"",null,"",null,""]
["Sales Tax (if bought new)",null,"",null,"",null,"",null,""]
["Registraiton Fees",null,"",null,"",null,"",null,""]
["Auto Insurance",null,"",null,"",null,"",null,""]
["Other (Car tax, misc., etc.)",null,"",null,"",null,"",null,""]
["Annual Lease Payments"]
["Inclusion Amount (if you know)"]
["Net Lease Payments Made",{"$f":"B11-B12","v":0},"",{"$f":"D11-D12","v":0},"",{"$f":"F11-F12","v":0},"",{"$f":"H11-H12","v":0},""]
["Depreciation this year (if known)"]
["Business Mileage in Year"]
["Personal Mileage in Year"]
["Commuting Mileage in Year"]
["Total Mileage Driven in Year",{"$f":"SUM(B15:B17)","v":0},null,{"$f":"SUM(D15:D17)","v":0},null,{"$f":"SUM(F15:F17)","v":0},null,{"$f":"SUM(H15:H17)","v":0}]
["Ratio of Business Use:",{"$f":"IF(B18<>0,B15/B18,0)","v":0},null,{"$f":"IF(D18<>0,D15/D18,0)","v":0},null,{"$f":"IF(F18<>0,F15/F18,0)","v":0},null,{"$f":"IF(H18<>0,H15/H18,0)","v":0}]
["Total Auto Expenses Paid",{"$f":"SUM(B3:B11)","v":0},null,{"$f":"SUM(D3:D11)","v":0},null,{"$f":"SUM(F3:F11)","v":0},null,{"$f":"SUM(H3:H11)","v":0}]
["Auto Expenses Deducted w/Dep",{"$f":"B19*(SUM(B4:B10)+B13)+B14+B3","v":0},null,{"$f":"D19*(SUM(D4:D10)+D13)+D14+D3","v":0},null,{"$f":"F19*(SUM(F4:F10)+F13)+F14+F3","v":0},null,{"$f":"H19*(SUM(H4:H10)+H13)+H14+H3","v":0}]
["Personal Capital Infusion:",{"$f":"B19*(SUMIF(C4:C10,Dropdowns!$D$3,B4:B10)+SUMIF(C13,Dropdowns!$D$3,B13))+SUMIF(C3,Dropdowns!$D$3,B3)","v":0},null,{"$f":"D19*(SUMIF(E4:E10,Dropdowns!$D$3,D4:D10)+SUMIF(E13,Dropdowns!$D$3,D13))+SUMIF(E3,Dropdowns!$D$3,D3)","v":0},null,{"$f":"F19*(SUMIF(G4:G10,Dropdowns!$D$3,F4:F10)+SUMIF(G13,Dropdowns!$D$3,F13))+SUMIF(G3,Dropdowns!$D$3,F3)","v":0},null,{"$f":"H19*(SUMIF(I4:I10,Dropdowns!$D$3,H4:H10)+SUMIF(I13,Dropdowns!$D$3,H13))+SUMIF(I3,Dropdowns!$D$3,H3)","v":0}]
["****Please provide us your last year's tax return so we can see how much you have already depreciated your vehicles, or to see if you have removed business use of some vehicles whilst adding any others.*****                           IF YOU SPLIT ANY OF THE ABOVE ANNUAL EXPENSES BETWEEN YOUR PERSONAL & BUSINESS ACCOUNT, DO MENTION IT TO US, OR PROVIDE ANOTHER SHEET WHICH SHOWS THAT.."]
[]
[]
[]
[]
[]
["Total Personal Capital Infusion for Auto Expenses",{"$f":"B22+D22+F22+H22","v":0}]

{"sheet":"Dropdowns","index":4,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["Asset Type",null,null,"Which Account?",null,null,"Tax Status",null,"Officer?"]
["Land",null,null,"Company Checking/Savings",null,null,"S-Corp",null,"Yes"]
["Residential Building",null,null,"Personal Checking/Savings",null,null,"LLC",null,"No"]
["Res. Rental Furn. & Fixture",null,null,null,null,null,"C-Corp"]
["Commercial Building",null,null,null,null,null,"GP"]
["Machinery & Equipment",null,null,null,null,null,"LLP"]
["Furniture & Fixtures",null,null,null,null,null,"LP"]
["Vehicle Under 6,000 lbs.",null,null,null,null,null,"Sole-Proprietor"]
["Trucks & Vans (6,000 lbs or less)"]
["Vehicles Over 6,000 lbs."]
["SUV 6,000 to 14,000 lbs"]
["Computer Systems"]
["Purchased Computer Software"]
["Goodwill"]
["Building Improvements"]
["Leasehold Improvements"]
["Qualified Restaurant"]
["Qualified Retail Improvement"]