{"text_format":"1","workbook":"xlsx","n_sheets":29,"sheets":["General Info - STEP 1","Income Statement - STEP 2","Codes","Balance Sheet - STEP 3","Vehicle Expense Info - STEP 4","1120S Import","1065 Import","Rental Property 1","Rental Property 2","Rental Property 3","Rental Property 4","Rental Property 5","Rental Property 6","Rental Property 7","Rental Property 8","1120C Import","Apport Info Property","Apport Info Payroll","Apport Info Sales","1120 Shareholder Information","Shareholder Basis","Weighted Average","1065 Spreadsheet","Profit Transfers","Loss Transfers","Capital Transfers","990 Import","1041 Import","Dropdowns"],"not_rendered":{"charts":0,"images":25,"macros":1,"external_links":1,"defined_names":30,"comments":9,"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 - STEP 1","index":0,"n_rows":104,"n_cols":4,"rows_kept":104,"cut":false,"hidden":false,"merged":[[103,1,105,2],[55,3,62,3],[85,3,92,3],[0,0,0,1],[101,0,101,1],[4,3,10,3],[16,3,23,3],[32,3,39,3]]}
[{"$f":"IF(B2=\"\",\"General Information for…\",\"General Information for \" &B2)","v":"General Information for…"}]
["Company Name as stated on the State's Arcticles",null,null,"<------START HERE!"]
["Filing Year: 20XX??"]
["Tax ID #:"]
["Mailing (Street) Address of Corp (International OK):",null,null,"If we have all this on file, you can leave it blank, but the more data you input, the less back and forth we would have, reducing processing time."]
["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"},null,null,"Please try to fill in as much as possible. Even if we have a lot of this info, this info can change from year to year. "]
["Percentage of Time Devoted to Business"]
["Social Security # or ITIN #"]
["Date of Birth xx/xx/xxxx",null,"<---------"]
["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",null,null,"Please fill all this info for other shareholders/partners as well, as best as you can. "]
["Social Security # or ITIN #"]
["Date of Birth xx/xx/xxxx"]
["Address"]
["City, State, Zip",null,"<---------"]
["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",null,"<---------","keep filling for rest of the partners/shareholders, as needed. "]
[]
[]
[]
["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",null,"<---------","KEEP GOING, AS NECESSARY…."]
[]
[]
[]
["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….***"]
[]
[null,"Great work! Now onto the Income Statement (yellow) tab!"]

{"sheet":"Income Statement - STEP 2","index":1,"n_rows":87,"n_cols":4,"rows_kept":87,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1],[81,0,83,0],[81,1,83,1],[24,0,24,1],[34,0,34,1],[2,0,2,1],[25,3,31,3],[72,3,79,3],[81,3,85,3],[8,3,10,3],[15,3,17,3]]}
["COMPLETE THE SKY BLUE FIELDS"]
[]
["Profit Loss Info "]
["Category","Amount"]
["Consulting Income, General Revenue",null,"<------START HERE!"]
["Commissions"]
["Lottery"]
["ATM"]
["Total Income/Gross Sales",{"$f":"SUM(B5,B6,B7,B8)","v":0},null,"<--Then keep entering data as you scroll down in blue fields."]
[]
["Other Income (State tax refund, etc)"]
[]
["INVENTORY SECTION"]
["Returns & Allowances"]
["Inventory at beginning of year"]
["Inventory Purchased",null,null,"<--If you're a service company, skip the inventory section here, and go to Interest income line."]
["Personal use of inventory"]
["Cost of labor"]
["Merchant (Credit Card) Costs"]
["Other Inventory Costs"]
["Inventory left at end of year"]
["Cost of Goods Sold",{"$f":"B15+B16-B17+B18+B19+B20-B21","v":0}]
["Gross Profit",{"$f":"B9-B14-B22","v":0}]
[]
["1099 Consolidated (Brokerage) Income Section [total for all brokerages here]"]
["Interest Income",null,null,"<--This section is lifted from your company's 1099 Conslidated Brokerage Statement, if your company has a brokerage account.  Otherwise, if you don't havea brokerage in your company name, skip this."]
["Other Income"]
["US Obligation Interest"]
["Total Ordinary Dividend Income"]
["Qualified Dividend Income"]
["US Obligation reported as dividend"]
["Section 199A REIT dividends"]
["Investment Interest Expense"]
[]
["EXPENSES"]
[{"$f":"IF('General Info - STEP 1'!$B$16=\"YES\",\"Compensation (W2 Salary - Box 5) for \"&'General Info - STEP 1'!$B$15,\"Compensation (W2 Salary - Box 5) - Officer 1\")","v":"Compensation (W2 Salary - Box 5) - Officer 1"}]
[{"$f":"IF('General Info - STEP 1'!$B$31=\"YES\",\"Compensation (W2 Salary - Box 5) for \"&'General Info - STEP 1'!$B$30,\"Compensation (W2 Salary - Box 5) - Officer 2\")","v":"Compensation (W2 Salary - Box 5) - Officer 2"}]
[{"$f":"IF('General Info - STEP 1'!$B$46=\"YES\",\"Compensation (W2 Salary - Box 5) for \"&'General Info - STEP 1'!$B$45,\"Compensation (W2 Salary - Box 5) Officer 3\")","v":"Compensation (W2 Salary - Box 5) Officer 3"}]
[{"$f":"IF('General Info - STEP 1'!$B$61=\"YES\",\"Compensation (W2 Salary - Box 5) for \"&'General Info - STEP 1'!$B$60,\"Compensation (W2 Salary - Box 5) Officer 4\")","v":"Compensation (W2 Salary - Box 5) Officer 4"}]
[{"$f":"IF('General Info - STEP 1'!$B$76=\"YES\",\"Compensation (W2 Salary - Box 5) for \"&'General Info - STEP 1'!$B$75,\"Compensation (W2 Salary - Box 5) - Officer 5\")","v":"Compensation (W2 Salary - Box 5) - Officer 5"}]
[{"$f":"IF('General Info - STEP 1'!$B$91=\"YES\",\"Compensation (W2 Salary - Box 5) for \"&'General Info - STEP 1'!$B$90,\"Compensation (W2 Salary - Box 5) Officer 6\")","v":"Compensation (W2 Salary - Box 5) Officer 6"}]
["Advertising"]
["Bank Charges"]
["Cash Shortages"]
["Cleaning & Laundry"]
["Commissions"]
["Dues & Subscriptions"]
["Insurance (Except Auto)"]
["Legal & Professional"]
["Taxes (Employer Payroll Taxes, State Income, Excise, Etc) & Licenses",null,"<---------","You will get this from year end payroll report from the payroll provider, else, if we run your payroll, you can leave blank."]
["Office Expenses"]
["Office Supplies"]
["Outside Services"]
["Parking"]
["Postage"]
["Supplies"]
["Telephone"]
["Utilities"]
["Salaries & Wages to Employees"]
["Repairs & Maintenance [NOT FOR VEHICLES]"]
["Bad Debts (If Included in Income)",null,"<---------","ONLY fill this if you included this in income above, the same amount which you are now writing off as uncollectible. Else, leave blank."]
["Rents"]
["Loan Interest (Except Auto)"]
["Profit Sharing Plan (401K/SEP-IRA/Simple IRA/Pension) Contribution, Accrued or Paid"]
["Employee Benefit Programs"]
["Meals and Entertainment"]
["Travel (Airlines, Hotels, Conferences)"]
["TENTATIVE AUTO EXPENSES DEDUCTION (SEE VEHICLE EXPENSE INFO TAB)",{"$f":"'Vehicle Expense Info - STEP 4'!B32:B33","v":0}]
["Fines & Penalties (Parking Tickets, etc)",0]
["Charity [Cash, Check, Credit Card)"]
["Charity [NONCASH - i.e., Goods]"]
["Charity [Capital Gain Property like Stock]"]
["Other Expense, or Rename here",null,null,"<-----You can rename the categories for \"Other Expense, or Rename here.\" Just be sure it is not already a category above. Vehicle expense categories are on the \"Vehicle Expense Info\" tab."]
["Other Expense, or Rename here"]
["Other Expense, or Rename here"]
["Other Expense, or Rename here"]
["Other Expense, or Rename here"]
["Other Expense, or Rename here"]
["Other Expense, or Rename here"]
["Other Expense, or Rename here"]
["Total Expenses",{"$f":"SUM(B36:B80)-B70-B71-B72","v":0}]
["Tentative Corporate Profit / -Loss",{"$f":"B23-B81","v":0},null,"Great! Income Statement Complete! Now onto the \"Balance Sheet\" (Orange) tab & finally the \"Vehicle Expense Info\" (Purple) tab."]
[]
[]
[]
[]
[{"$f":"IF('General Info - STEP 1'!B2<>\"\",'General Info - STEP 1'!B2,\"\")","v":""}]

{"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":"'Income Statement - STEP 2'!B9","v":0},100,null,"Gross receipts or sales",null,100]
[null,"Returns and allowances",{"$f":"'Income Statement - STEP 2'!B14","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":"Balance Sheet - STEP 3","index":3,"n_rows":78,"n_cols":5,"rows_kept":78,"cut":false,"hidden":false,"merged":[[0,0,0,4],[2,0,2,4],[3,0,3,4],[77,3,78,4],[9,4,14,4],[61,1,61,3],[5,4,6,4],[36,0,37,0],[36,1,37,4],[43,0,43,4],[45,0,46,0],[45,1,46,1]]}
["COMPLETE THE SKY BLUE FIELDS & Provide 12/31 Year Ending Statements"]
[]
["Balance Sheet Info "]
["ASSETS SECTION BELOW"]
["Bank Balance Info (All Banks)","Bank 1","Bank 2","Bank 3","<-------RENAME IF DESIRED"]
[{"$f":"IF('General Info - STEP 1'!B3<>\"\", \"January 1st \" &'General Info - STEP 1'!B3, \"January 1st of Tax Year\")","v":"January 1st of Tax Year"},null,null,null,"<------START HERE WITH BANK 1 COLUMN!"]
[{"$f":"IF('General Info - STEP 1'!B3<>\"\", \"Dec. 31st \" &'General Info - STEP 1'!B3, \"Dec. 31st of Tax Year\")","v":"Dec. 31st of Tax Year"}]
[]
["Accounts (Trade) Receivables ","AR Amount","Allowance for Bad Debt"]
[{"$f":"IF('General Info - STEP 1'!B3<>\"\", \"January 1st \" &'General Info - STEP 1'!B3, \"January 1st of Tax Year\")","v":"January 1st of Tax Year"},null,null,null,"<---------- If any asset or liability category is zero, just ignore it. Fill out what you do have and provide year end statements for the loans and \"sales invoices\" for the  new assets (like vehicles)."]
[{"$f":"IF('General Info - STEP 1'!B3<>\"\", \"Dec. 31st \" &'General Info - STEP 1'!B3, \"Dec. 31st of Tax Year\")","v":"Dec. 31st of Tax Year"}]
[]
["Inventories","AR Amount"]
[{"$f":"IF('General Info - STEP 1'!B3<>\"\", \"January 1st \" &'General Info - STEP 1'!B3, \"January 1st of Tax Year\")","v":"January 1st of Tax Year"}]
[{"$f":"IF('General Info - STEP 1'!B3<>\"\", \"Dec. 31st \" &'General Info - STEP 1'!B3, \"Dec. 31st of Tax Year\")","v":"Dec. 31st of Tax Year"}]
[null,null,null,null,"Continue Down….."]
["Investments held in Co. name.","US Government Obligations","Tax-Exempt Securities","Stocks, Mutual Funds","Other Current Assets (Liquidatable within 1  year)"]
[{"$f":"IF('General Info - STEP 1'!B3<>\"\", \"January 1st \" &'General Info - STEP 1'!B3& \" COST BASIS Balance\", \"January 1st of Tax Year, COST BASIS Balance\")","v":"January 1st of Tax Year, COST BASIS Balance"}]
[{"$f":"IF('General Info - STEP 1'!B3<>\"\", \"Dec. 31st \" &'General Info - STEP 1'!B3& \" COST BASIS Balance\", \"Dec. 31s of Tax Year, COST BASIS balance\")","v":"Dec. 31s of Tax Year, COST BASIS balance"}]
[]
["Loans to Shareholders/Partners",{"$f":"IF('General Info - STEP 1'!B15=\"\",\"Shareholder 1 / Partner 1\",'General Info - STEP 1'!B15)","v":"Shareholder 1 / Partner 1"},{"$f":"IF('General Info - STEP 1'!B30=\"\",\"Shareholder 2 / Partner 2\",'General Info - STEP 1'!B30)","v":"Shareholder 2 / Partner 2"},{"$f":"IF('General Info - STEP 1'!B45=\"\",\"Shareholder 3 / Partner 3\",'General Info - STEP 1'!B45)","v":"Shareholder 3 / Partner 3"},{"$f":"IF('General Info - STEP 1'!B60=\"\",\"Shareholder 4 / Partner 4\",'General Info - STEP 1'!B60)","v":"Shareholder 4 / Partner 4"}]
[{"$f":"IF('General Info - STEP 1'!B3<>\"\", \"January 1st \" &'General Info - STEP 1'!B3, \"January 1st of Tax Year\")","v":"January 1st of Tax Year"}]
[{"$f":"IF('General Info - STEP 1'!B3<>\"\", \"Dec. 31st \" &'General Info - STEP 1'!B3, \"Dec. 31st of Tax Year\")","v":"Dec. 31st of Tax Year"}]
[]
["Loan Notes (& Mortgages) Receivable","Loan 1","Loan 2","Loan 3","Loan 4"]
[{"$f":"IF('General Info - STEP 1'!B3<>\"\", \"January 1st \" &'General Info - STEP 1'!B3, \"January 1st of Tax Year\")","v":"January 1st of Tax Year"}]
[{"$f":"IF('General Info - STEP 1'!B3<>\"\", \"Dec. 31st \" &'General Info - STEP 1'!B3, \"Dec. 31st of Tax Year\")","v":"Dec. 31st of Tax Year"}]
[]
["Other Investments","OI 1","OI 2","OI 3","OI 4"]
[{"$f":"IF('General Info - STEP 1'!B3<>\"\", \"January 1st \" &'General Info - STEP 1'!B3, \"January 1st of Tax Year\")","v":"January 1st of Tax Year"}]
[{"$f":"IF('General Info - STEP 1'!B3<>\"\", \"Dec. 31st \" &'General Info - STEP 1'!B3, \"Dec. 31st of Tax Year\")","v":"Dec. 31st of Tax Year"}]
[]
["Other Assets (Goodwill, NonCompete, etc, 179 carryover, etc.)","OA 1","OA 2","OA 3","OA 4"]
[{"$f":"IF('General Info - STEP 1'!B3<>\"\", \"January 1st \" &'General Info - STEP 1'!B3, \"January 1st of Tax Year\")","v":"January 1st of Tax Year"}]
[{"$f":"IF('General Info - STEP 1'!B3<>\"\", \"Dec. 31st \" &'General Info - STEP 1'!B3, \"Dec. 31st of Tax Year\")","v":"Dec. 31st of Tax Year"}]
[]
["FIXED ASSETS (Vehicles, Machinery, Equipment Computers, etc.)","Attach another sheet for more assets, if necessary with same grid info:"]
[]
["ASSET TYPE:","Goodwill","Res. Rental Furn. & Fixture","Asset Type","Asset Type"]
["Purchase Price:"]
["Date Bought:"]
["DESCRIPTION OF ASSET (CAR MODEL, MAKE, YEAR, for e.g.)"]
[]
["LIABILITIES SECTION BELOW"]
[]
["Accounts Payable","Amount"]
[]
[{"$f":"IF('General Info - STEP 1'!B3<>\"\", \"January 1st \" &'General Info - STEP 1'!B3, \"January 1st of Tax Year\")","v":"January 1st of Tax Year"}]
[{"$f":"IF('General Info - STEP 1'!B3<>\"\", \"Dec. 31st \" &'General Info - STEP 1'!B3, \"Dec. 31st of Tax Year\")","v":"Dec. 31st of Tax Year"}]
[]
["Loans (short term) - payable <  1 yr","Loan 1","Loan 2","Loan 3","Loan 4"]
[{"$f":"IF('General Info - STEP 1'!B3<>\"\", \"January 1st \" &'General Info - STEP 1'!B3, \"January 1st of Tax Year\")","v":"January 1st of Tax Year"}]
[{"$f":"IF('General Info - STEP 1'!B3<>\"\", \"Dec. 31st \" &'General Info - STEP 1'!B3, \"Dec. 31st of Tax Year\")","v":"Dec. 31st of Tax Year"}]
[]
["Other Current Liabilities (payable < 1 yr)","Payroll Tax Payable","Fed Income Tax Payable","State Income Tax Payable","Local (City) Tax Payable"]
[{"$f":"IF('General Info - STEP 1'!B3<>\"\", \"January 1st \" &'General Info - STEP 1'!B3, \"January 1st of Tax Year\")","v":"January 1st of Tax Year"}]
[{"$f":"IF('General Info - STEP 1'!B3<>\"\", \"Dec. 31st \" &'General Info - STEP 1'!B3, \"Dec. 31st of Tax Year\")","v":"Dec. 31st of Tax Year"}]
[]
["Loans from Shareholders/Partners",{"$f":"IF('General Info - STEP 1'!B15=\"\",\"Shareholder 1 / Partner 1\",'General Info - STEP 1'!B15)","v":"Shareholder 1 / Partner 1"},{"$f":"IF('General Info - STEP 1'!B30=\"\",\"Shareholder 2 / Partner 2\",'General Info - STEP 1'!B30)","v":"Shareholder 2 / Partner 2"},{"$f":"IF('General Info - STEP 1'!B45=\"\",\"Shareholder 3 / Partner 3\",'General Info - STEP 1'!B45)","v":"Shareholder 3 / Partner 3"},{"$f":"IF('General Info - STEP 1'!B60=\"\",\"Shareholder 4 / Partner 4\",'General Info - STEP 1'!B60)","v":"Shareholder 4 / Partner 4"}]
[{"$f":"IF('General Info - STEP 1'!B3<>\"\", \"January 1st \" &'General Info - STEP 1'!B3, \"January 1st of Tax Year\")","v":"January 1st of Tax Year"}]
[{"$f":"IF('General Info - STEP 1'!B3<>\"\", \"Dec. 31st \" &'General Info - STEP 1'!B3, \"Dec. 31st of Tax Year\")","v":"Dec. 31st of Tax Year"}]
[]
["Loans (LONG term) / Mortgages","Loan 1","Loan 2","Loan 3","Loan 4"]
[{"$f":"IF('General Info - STEP 1'!B3<>\"\", \"January 1st \" &'General Info - STEP 1'!B3, \"January 1st of Tax Year\")","v":"January 1st of Tax Year"}]
[{"$f":"IF('General Info - STEP 1'!B3<>\"\", \"Dec. 31st \" &'General Info - STEP 1'!B3, \"Dec. 31st of Tax Year\")","v":"Dec. 31st of Tax Year"}]
[]
["Other Liabilities","OL 1","OL 2","OL 3","OL 4"]
[{"$f":"IF('General Info - STEP 1'!B3<>\"\", \"January 1st \" &'General Info - STEP 1'!B3, \"January 1st of Tax Year\")","v":"January 1st of Tax Year"}]
[{"$f":"IF('General Info - STEP 1'!B3<>\"\", \"Dec. 31st, \" &'General Info - STEP 1'!B3, \"Dec. 31st of Tax Year\")","v":"Dec. 31st of Tax Year"}]
[]
[{"$f":"IF('General Info - STEP 1'!B3<>\"\", \"CAPITAL CONTRIBUTIONS / DISTRIBUTIONS in \"&'General Info - STEP 1'!B3,\"CAPITAL CONTRIBUTIONS / DISTRIBUTIONS in Tax Year\")","v":"CAPITAL CONTRIBUTIONS / DISTRIBUTIONS in Tax Year"},{"$f":"IF('General Info - STEP 1'!B27=\"\",\"Shareholder 1 / Partner 1\",'General Info - STEP 1'!B27)","v":"Shareholder 1 / Partner 1"},{"$f":"IF('General Info - STEP 1'!B42=\"\",\"Shareholder 2 / Partner 2\",'General Info - STEP 1'!B42)","v":"Shareholder 2 / Partner 2"},{"$f":"IF('General Info - STEP 1'!B57=\"\",\"Shareholder 3 / Partner 3\",'General Info - STEP 1'!B57)","v":"Shareholder 3 / Partner 3"},{"$f":"IF('General Info - STEP 1'!B72=\"\",\"Shareholder 4 / Partner 4\",'General Info - STEP 1'!B72)","v":"Shareholder 4 / Partner 4"}]
["EXPENSES (NON VEHICLE) From Personal Bank Accounts & Personal Credit Cards"]
["CASH MONIES GIVEN TO COMPANY"]
["Vehicle Auto Expenses Spent from Personal Accounts:",{"$f":"'Vehicle Expense Info - STEP 4'!B24","v":0},{"$f":"'Vehicle Expense Info - STEP 4'!D24","v":0},{"$f":"'Vehicle Expense Info - STEP 4'!F24","v":0},{"$f":"'Vehicle Expense Info - STEP 4'!H24","v":0}]
["Total Paid in Capital",{"$f":"SUM(B72:B74)","v":0},{"$f":"SUM(C72:C74)","v":0},{"$f":"SUM(D72:D74)","v":0},{"$f":"SUM(E72:E74)","v":0}]
["Distributions ($) -- (Monies withdrawn from company checking account)"]
[]
[null,null,null,"GREAT WORK! NOW TO THE \"VEHICLE EXPENSE\" (PURPLE) INFO TAB!"]

{"sheet":"Vehicle Expense Info - STEP 4","index":4,"n_rows":38,"n_cols":9,"rows_kept":38,"cut":false,"hidden":false,"merged":[[35,2,40,6],[37,0,38,0],[37,1,38,1],[28,0,29,0],[31,0,32,0],[31,1,32,1],[28,1,29,1]]}
["ANNUAL AUTO EXPENSES","Enter Vehicle 1 (Make, Model, year) BELOW","From Which Account Were Monies Spent?","Enter Vehicle 2 (Make, Model, year) BELOW","From Which Account Were Monies Spent?","Enter Vehicle 3 (Make, Model, year) BELOW","From Which Account Were Monies Spent?","Enter Vehicle 4 (Make, Model, year) BELOW","From Which Account Were Monies Spent?"]
["START HERE ---->","TYPE HERE","Company Checking/Personal?","TYPE HERE","Company Checking/Personal?","TYPE HERE","Company Checking/Personal?","TYPE HERE","Company Chrcking/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 known)"]
["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/Acutal Expenses & 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}]
["IRS Business Mileage Rate",0.625,"<---ENTER BUSINESS MILEAGE RATE",{"$f":"B22","v":0.625},null,{"$f":"D22","v":0.625},null,{"$f":"F22","v":0.625}]
["Auto Expenses Mileage Method",{"$f":"(B22*B15)+B3","v":0},null,{"$f":"(D22*D15)+D3","v":0},null,{"$f":"(F22*F15)+F3","v":0},null,{"$f":"(H22*H15)+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}]
[]
[]
[]
[]
["Tentative Auto Expense (HIGHER OF MILEAGE OR ACTUAL) PER Vehicle",{"$f":"MAX(B21,B23)","v":0}]
[null,null,null,{"$f":"MAX(D21,D23)","v":0},null,{"$f":"MAX(F21,F23)","v":0},null,{"$f":"MAX(H21,H23)","v":0}]
[]
["Total Tentative Auto Expenses",{"$f":"B29+D30+F30+H30","v":0}]
[]
[]
[]
[null,null,"GREAT WORK!  IF YOU HAVE RENTAL PROPERTIES, HOP OVER THERE TO THOSE TABS, AND START INPUTTING THE INFO THERE.    ELSE, YOU CAN SAVE THIS SHEET, AND UPLOAD IT TO US ON WWW.VIMLANTAX.COM, INTO YOUR TAX ORGANIZER, IN THE \"UPLOADED TAX DOCUMENTS\" SECTION ALONG WITH THE REST OF YOUR PERSONAL TAX DOCS. GREAT JOB!"]
[]
["Total Personal Capital Infusion for Auto Expenses",{"$f":"B24+D24+F24+H24","v":0}]

{"sheet":"1120S Import","index":5,"n_rows":308,"n_cols":5,"rows_kept":308,"cut":false,"hidden":true,"merged":[]}
["Tax Code","Ultra Tax CS Description [1120S S CORP]","Form, Line #","Account Number","Amount"]
[100,"Gross receipts","1120S, L1a",null,{"$f":"-'Income Statement - STEP 2'!B9","v":0}]
[101,"Return and allowances","1120S, L1b",null,{"$f":"'Income Statement - STEP 2'!B14","v":0}]
[102,"Other income","1120S, L5",null,{"$f":"-'Income Statement - STEP 2'!B11","v":0}]
[103,"State tax refunds","1120S, L5"]
[104,"Capital gain distribution","Sch D, L13"]
[105,"Capital gain distribution 28%","Sch D, L13"]
[121,"GST-Net ord gain(loss) 4797 II","1120S, L4"]
[122,"GST-COGS:Beginning inventory","Sch A, L1"]
[124,"GST-Royalty income","Sch K, L6"]
[125,"GST-Net ST cap gain(loss)","Sch K, L7"]
[126,"GST-Net LT cap gain(loss)","Sch K, L8"]
[127,"GST-Net Sec 1231 gain(loss)","Sch K, L9"]
[128,"GST-Foreign taxes","Sch K, L14l"]
[130,"Meals subject to 50% limit","Sch F, L32"]
[131,"Meals subject to 50% limit","Rent, var"]
[150,"Non-US interest income","Sch K, L4"]
[151,"US interest income","Sch K, L4",null,{"$f":"'Income Statement - STEP 2'!B26","v":0}]
[153,"Other Portfolio Income (Loss)","Sch K, L10"]
[154,"Other income","Sch K, L10",null,{"$f":"'Income Statement - STEP 2'!B27","v":0}]
[155,"Mining exploration costs recap","Sch K, L10"]
[156,"Ordinary dividends","Sch K, L5a",null,{"$f":"'Income Statement - STEP 2'!B29","v":0}]
[200,"Compensation of officers","1125-E, L1",null,{"$f":"SUM('Income Statement - STEP 2'!B36:'Income Statement - STEP 2'!B41)","v":0}]
[201,"Salaries and wages","1120S, L8",null,{"$f":"'Income Statement - STEP 2'!B59","v":0}]
[202,"Repairs","1120S, L9",null,{"$f":"'Income Statement - STEP 2'!B60","v":0}]
[203,"Bad debts","1120S, L10",null,{"$f":"'Income Statement - STEP 2'!B61","v":0}]
[204,"Rents","1120S, L11",null,{"$f":"'Income Statement - STEP 2'!B62","v":0}]
[205,"Taxes","1120S, L12",null,{"$f":"'Income Statement - STEP 2'!B50","v":0}]
[206,"Interest","1120S, L13",null,{"$f":"'Income Statement - STEP 2'!B63","v":0}]
[207,"Book depr-other than COGS","Sch M-1, var"]
[208,"Page 1 depletion - book","1120S, L15"]
[209,"Advertising","1120S, L16",null,{"$f":"'Income Statement - STEP 2'!B42","v":0}]
[210,"Pension, profit sharing","1120S, L17",null,{"$f":"'Income Statement - STEP 2'!B64","v":0}]
[211,"Employee benefit programs","1120S, L18",null,{"$f":"'Income Statement - STEP 2'!B65","v":0}]
[212,"Other deductions","1120S, L19",null,{"$f":"SUM('Income Statement - STEP 2'!B43:'Income Statement - STEP 2'!B49)+SUM('Income Statement - STEP 2'!B51:'Income Statement - STEP 2'!B58)+SUM('Income Statement - STEP 2'!B67,'Income Statement - STEP 2'!B73:'Income Statement - STEP 2'!B80)","v":0}]
[213,"Meals fully deductible","1120S, L19",null,{"$f":"'Income Statement - STEP 2'!B66","v":0}]
[214,"Total book amortization","1120S, L19"]
[215,"Meals (DOT)","1120S, L19"]
[216,"Meals subject to 50% limit","1120S, L19"]
[217,"Meals subject to 50% limit","4835, L30"]
[218,"Org / start-up book expense","Sch M-1, L3"]
[219,"Pension, profit-sharing accr","1120S, L 17"]
[225,"Cash contributions (60%)","Sch K, L12a",null,{"$f":"'Income Statement - STEP 2'!B70","v":0}]
[226,"Cash contributions (30%)","Sch K, L12a"]
[227,"Capital gain property (20%)","Sch K, L12a",null,{"$f":"'Income Statement - STEP 2'!B72","v":0}]
[228,"Book Section 179 amount","Sch M, var"]
[230,"Other deductions","Sch K, L12d"]
[231,"Investment interest expense","Sch K, L12b",null,{"$f":"'Income Statement - STEP 2'!B33","v":0}]
[234,"Section 59(e) expenditures","Sch K, L12c"]
[237,"Preproductive period expenses","Sch K, L12d"]
[238,"Penalty on early withdrawal","Sch K, L12d"]
[242,"Sec 951(a) income inclusions","Sch K, L10"]
[245,"Deduct - portfolio (Other)","Sch K, L12d"]
[246,"Reforestation expenses","Sch K, L12d"]
[247,"Noncash contributions (50%)","Sch K, L12a",null,{"$f":"'Income Statement - STEP 2'!B71","v":0}]
[248,"Noncash contributions (30%)","Sch K, L12a"]
[249,"Cap gain prop (30%)","Sch K, L12a"]
[275,"Purchases","1125-A, L2",null,{"$f":"'Income Statement - STEP 2'!B16","v":0}]
[276,"Cost of labor","1125-A, L3",null,{"$f":"'Income Statement - STEP 2'!B18","v":0}]
[277,"Additional Section 263A costs","1125-A, L4",null,{"$f":"'Income Statement - STEP 2'!B19","v":0}]
[278,"Other costs","1125-A, L5",null,{"$f":"-'Income Statement - STEP 2'!B17+'Income Statement - STEP 2'!B20","v":0}]
[280,"Inventory at end of year","1125-A, L7",null,{"$f":"'Income Statement - STEP 2'!B21","v":0}]
[281,"Meals fully deductible","1125-A, L4"]
[282,"Meals (DOT)","1125-A, L4"]
[283,"Book depreciation-COGS","Sch M-1, var"]
[284,"Meals subject to 50% limit","1125-A, L4"]
[300,"Estimated tax payments","1120S, L23a"]
[390,"Qualified conservation (50%)","Sch K, L12a"]
[391,"Qualified conservation (100%)","Sch K, L12a"]
[400,"Cash","Sch L, L1",null,{"$f":"'Balance Sheet - STEP 3'!B7+'Balance Sheet - STEP 3'!C7+'Balance Sheet - STEP 3'!D7","v":0}]
[401,"Accounts receivable","Sch L, L2a",null,{"$f":"'Balance Sheet - STEP 3'!B11","v":0}]
[402,"Less allowance for bad debts","Sch L, L2b",null,{"$f":"'Balance Sheet - STEP 3'!C11","v":0}]
[403,"Inventories","Sch L, L3",null,{"$f":"'Balance Sheet - STEP 3'!B15","v":0}]
[404,"US government obligations","Sch L, L4",null,{"$f":"'Balance Sheet - STEP 3'!B19","v":0}]
[405,"Tax exempt securities","Sch L, L5",null,{"$f":"'Balance Sheet - STEP 3'!C19","v":0}]
[406,"Other current assets","Sch L, L6",null,{"$f":"'Balance Sheet - STEP 3'!D19+'Balance Sheet - STEP 3'!E19","v":0}]
[407,"Prepaid federal income tax","Sch L, L6"]
[408,"Prepaid state tax","Sch L, L6"]
[409,"Loans to shareholders","Sch L, L7",null,{"$f":"'Balance Sheet - STEP 3'!B23+'Balance Sheet - STEP 3'!C23+'Balance Sheet - STEP 3'!D23+'Balance Sheet - STEP 3'!E23","v":0}]
[420,"Prepaid city tax","Sch L, L6"]
[415,"Mortgage and real estate loans","Sch L, L8",null,{"$f":"'Balance Sheet - STEP 3'!B27+'Balance Sheet - STEP 3'!C27+'Balance Sheet - STEP 3'!D27+'Balance Sheet - STEP 3'!E27","v":0}]
[416,"Other investments","Sch L, L9",null,{"$f":"'Balance Sheet - STEP 3'!B31+'Balance Sheet - STEP 3'!C31+'Balance Sheet - STEP 3'!D31+'Balance Sheet - STEP 3'!E31","v":0}]
[425,"Buildings, other deprec assets","Sch L, L10a",null,{"$f":"'Balance Sheet - STEP 3'!B40+'Balance Sheet - STEP 3'!C40+'Balance Sheet - STEP 3'!D40+'Balance Sheet - STEP 3'!E40","v":0}]
[426,"Less accumulated depreciation","Sch L, L10b"]
[427,"Depletable assets","Sch L, L11a"]
[428,"Less accumulated depletion","Sch L, L11b"]
[429,"Land (net of any amortizations)","Sch L, L12"]
[430,"Intangible assets","Sch L, L13a"]
[431,"Less accumulated amortization","Sch L, L13b"]
[432,"Other assets","Sch L, L14",null,{"$f":"'Balance Sheet - STEP 3'!B35+'Balance Sheet - STEP 3'!C35+'Balance Sheet - STEP 3'!D35+'Balance Sheet - STEP 3'!E35","v":0}]
[440,"Accounts payable","Sch L, L16",null,{"$f":"'Balance Sheet - STEP 3'!B49","v":0}]
[441,"Mortg, notes, bonds pay < 1 yr","Sch L, L17",null,{"$f":"'Balance Sheet - STEP 3'!B53+'Balance Sheet - STEP 3'!C53+'Balance Sheet - STEP 3'!D53+'Balance Sheet - STEP 3'!E53","v":0}]
[442,"Other current liabilities","Sch L, L18",null,{"$f":"'Balance Sheet - STEP 3'!B57","v":0}]
[443,"Federal income tax payable","Sch L, L18",null,{"$f":"'Balance Sheet - STEP 3'!C57","v":0}]
[444,"State tax payable","Sch L, L18",null,{"$f":"'Balance Sheet - STEP 3'!D57","v":0}]
[445,"Loans from shareholders","Sch L, L19",null,{"$f":"'Balance Sheet - STEP 3'!B61+'Balance Sheet - STEP 3'!C61+'Balance Sheet - STEP 3'!D61+'Balance Sheet - STEP 3'!E61","v":0}]
[446,"City tax payable","Sch L, L18",null,{"$f":"'Balance Sheet - STEP 3'!E57","v":0}]
[450,"Mortg, notes, bonds pay => 1 yr","Sch L, L20",null,{"$f":"'Balance Sheet - STEP 3'!B65+'Balance Sheet - STEP 3'!C65+'Balance Sheet - STEP 3'!D65+'Balance Sheet - STEP 3'!E65","v":0}]
[451,"Other liabilities","Sch L, L21",null,{"$f":"'Balance Sheet - STEP 3'!B69+'Balance Sheet - STEP 3'!C69+'Balance Sheet - STEP 3'!D69+'Balance Sheet - STEP 3'!E69","v":0}]
[465,"Capital stock - common","Sch L, L22"]
[466,"Paid in or capital surplus","Sch L, L23",null,{"$f":"'Balance Sheet - STEP 3'!B75+'Balance Sheet - STEP 3'!C75+'Balance Sheet - STEP 3'!D75+'Balance Sheet - STEP 3'!E75","v":0}]
[467,"Retained earnings - unappr","Sch L, L24"]
[468,"Accumulated Adjustments Acct","Sch L, L24"]
[469,"Other Adjustments Account","Sch L, L24"]
[470,"Previously Taxed Income","Sch L, L24"]
[471,"Adjustments to S/Hs' equity","Sch L, L25"]
[472,"Less cost of treasury stock","Sch L, L26"]
[479,"Fines and penalties","Sch M-1, L3",null,{"$f":"'Income Statement - STEP 2'!B69","v":0}]
[481,"Sch K income not on books","Sch M-1, L2"]
[482,"Expenses on books, not Sch K","Sch M-1, L3"]
[483,"Exps related to tax exempt inc","Sch M-1, L3"]
[484,"Officer life ins. premiums","Sch M-1, L3"]
[485,"Income on books, not on Sch K","Sch M-1, L5"]
[486,"Tax exempt interest","Sch M-1, L5"]
[487,"Cash surrender - officer life","Sch M-1, L5"]
[488,"4797 gain/loss - book","Sch M-1, var"]
[489,"Deductions on K not on books","Sch M-1, L6"]
[490,"AAA-Other additions","Sch M-2, L3a",null,{"$f":"'Balance Sheet - STEP 3'!B75+'Balance Sheet - STEP 3'!C75+'Balance Sheet - STEP 3'!D75+'Balance Sheet - STEP 3'!E75","v":0}]
[491,"OAA-Other additions","Sch M-2, L3d"]
[492,"AAA-Other reductions","Sch M-2, L5a"]
[493,"OAA-Other reductions","Sch M-2, L5b"]
[494,"AAA-Nondividend distributions","Sch M-2, L7a",null,{"$f":"'Balance Sheet - STEP 3'!B76+'Balance Sheet - STEP 3'!C76+'Balance Sheet - STEP 3'!D76+'Balance Sheet - STEP 3'!E76","v":0}]
[495,"OAA-Nondividend distributions","Sch M-2, L7d"]
[496,"UTI-Nondividend distributions","Sch M-2, L7b"]
[497,"Nondividend distributions","R/E Wrk, var"]
[498,"Dividend distributions","R/E Wrk, var"]
[499,"Oil & gas depletion – book","Sch M-1, L3"]
[502,"Gross rental income","Rent, var"]
[503,"Advertising","Rent, var"]
[504,"Auto and travel","Rent, var"]
[505,"Cleaning and maintenance","Rent, var"]
[506,"Commissions","Rent, var"]
[507,"Insurance","Rent, var"]
[508,"Legal and other prof fees","Rent, var"]
[509,"Interest","Rent, var"]
[510,"Repairs","Rent, var"]
[511,"Taxes","Rent, var"]
[512,"Utilities","Rent, var"]
[513,"Wages and salaries","Rent, var"]
[515,"Other expenses","Rent, var"]
[582,"Gross royalties","Rent, var"]
[585,"Meals fully deductible","Rent, var"]
[586,"Meals (DOT)","Rent, var"]
[590,"Other income","Rent, var"]
[601,"Sales of items bought","Sch F, var"]
[602,"Cost/basis of items bought","Sch F, L1b"]
[604,"Sales of items you raised","Sch F, L2"]
[605,"Total cooperative distribution","Sch F, var"]
[606,"Agricultural program payments","Sch F, var"]
[607,"CCC loans reported under elec","Sch F, var"]
[608,"Crop ins proceeds","Sch F, var"]
[609,"Custom hire income","Sch F, var"]
[610,"Other income","Sch F, var"]
[612,"Car and truck expenses","Sch F, L10"]
[613,"Chemicals","Sch F, L11"]
[614,"Conservation expenses","Sch F, L12"]
[615,"Custom hire","Sch F, L13"]
[617,"Employee benefits programs","Sch F, L15"]
[618,"Feed purchased","Sch F, L16"]
[619,"Fertilizers and lime","Sch F, L17"]
[620,"Freight and trucking","Sch F, L18"]
[621,"Gasoline","Sch F, L19"]
[622,"Insurance","Sch F, L20"]
[623,"Interest - financial inst","Sch F, L21a"]
[624,"Labor hired","Sch F, L22"]
[625,"Pension and profit sharing","Sch F, L23"]
[626,"Rent - machinery","Sch F, L24a"]
[627,"Repairs and maintenance","Sch F, L25"]
[628,"Seeds and plants","Sch F, L26"]
[629,"Storage and warehousing","Sch F, L27"]
[630,"Supplies","Sch F, L28"]
[631,"Taxes","Sch F, L29"]
[632,"Utilities","Sch F, L30"]
[633,"Veterinary fees","Sch F, L31"]
[634,"Other expenses","Sch F, L32"]
[646,"Inventory - beg of year","Sch F, L45"]
[647,"Cost of items for resale","Sch F, L46"]
[649,"Inventory - end of year","Sch F, L48"]
[650,"Tax-exempt interest income","8916A PII, L1a"]
[651,"Interest inc from hybrid sec","8916A PII, L2a"]
[652,"Sale/lease interest income","8916A PII, L3a"]
[653,"Interco int inc outside tax gr","8916A PII, L4a"]
[654,"Interco int inc tax affil gr","8916A PII, L4b"]
[655,"Other interest income","8916A PII, 5a"]
[668,"Interest exp from hybrid sec","8916A PIII, L1a"]
[669,"Lease/purchase interest exp","8916A PIII, L2a"]
[670,"Interco int exp outside tax gr","8916A PIII, L3a"]
[671,"Interco int exp tax affil gr","8916A PIII, L3b"]
[672,"Other interest expense","8916A PIII, L4a"]
[683,"Interest expense - other","Sch F, L21b"]
[684,"Meals fully deductible","Sch F, L32"]
[685,"Preproductive expenses","Sch F, L32"]
[686,"Rental expense - other","Sch F, L24b"]
[687,"CCC loans forfeited","Sch F, var"]
[688,"Crop insurance deferred","Sch F, L6d"]
[689,"Meals (DOT)","Sch F, L32"]
[696,"Sec 263A: Parachute payments","8916A, L2da"]
[701,"Income from production","4835, L1"]
[702,"Distr rec from cooperatives","4835, L2a"]
[703,"Agricultural program payments","4835, L3a"]
[704,"CCC loans reported under elec","4835, L4a"]
[705,"Crop ins proceeds - current yr","4835, L5a"]
[706,"Other income","4835, L6"]
[708,"Car/truck expense","4835, L8"]
[709,"Chemicals","4835, L9"]
[710,"Conservation","4835, L10"]
[711,"Custom hire","4835, L11"]
[713,"Employee benefits","4835, L13"]
[714,"Feed purchased","4835, L14"]
[715,"Fertilizers and lime","4835, L15"]
[716,"Freight and trucking","4835, L16"]
[717,"Gasoline","4835, L17"]
[718,"Insurance","4835, L18"]
[719,"Interest - financial","4835, L19a"]
[720,"Labor hired","4835, L20"]
[721,"Pension & profit sharing","4835, L21"]
[722,"Rent - machinery","4835, L22a"]
[723,"Repairs","4835, L23"]
[724,"Seeds","4835, L24"]
[725,"Storage","4835, L25"]
[726,"Supplies","4835, L26"]
[727,"Taxes","4835, L27"]
[728,"Utilities","4835, L28"]
[729,"Veterinary","4835, L29"]
[730,"Other expenses","4835, L30"]
[731,"Amts attrib cost flow assump","8916A, L1a"]
[732,"Sec 263A: Stock option exp","8916A, L2aa"]
[733,"Sec 263A: Oth eq based comp","8916A, L2ba"]
[734,"Sec 263A: Meals & entertain","8916A, L2ca"]
[735,"Inc/loss eqty meth fgn corp","M3 PII, L1a"]
[736,"Gross fgn div not prev tax","M3 PII, L2a"]
[737,"Subpart F, QEF income","M3 PII, L3a"]
[739,"Gross fgn dist prev taxed","M3 PII, L4a"]
[740,"Inc/loss eqty meth US corp","M3 PII, L5a"]
[741,"US div not elimin in consol","M3 PII, L6a"]
[743,"Inc/loss from US partnerships","M3 PII, L7a"]
[744,"Inc/loss from fgn partnerships","M3 PII, L8a"]
[745,"Inc/loss from other P/T","M3 PII, L9a"]
[746,"Items related to report trans","M3 PII, L10a"]
[748,"Accrual to cash adjustments","M3 PII, L12a"]
[749,"Hedging transactions","M3 PII, L13a"]
[750,"Mark-to-market income/loss","M3 PII, L14a"]
[752,"Sale versus lease","M3 PII, L16a"]
[753,"Section 481(a) adjustments","M3 PII, L17a"]
[754,"Unearned/deferred revenue","M3 PII, L18a"]
[755,"Income rec long-term contracts","M3 PII, L19a"]
[756,"OID and imputed interest","M3 PII, L20a"]
[757,"Inc stmt gain/loss on assets","M3 PII, L21aa"]
[758,"Capital gains from Sch D","M3 PII, L21ba"]
[759,"Capital losses from Sch D","M3 PII, L21ca"]
[760,"Gain/loss on Form 4797","M3 PII, L21da"]
[761,"Abandonment losses","M3 PII, L21ea"]
[762,"Worthless stock losses","M3 PII, L21fa"]
[763,"Other gain/loss on assets","M3 PII, L21ga"]
[766,"Other inc/loss with difference","M3 PII, L22a"]
[767,"Other items w/ no differences","M3 PII, L25a"]
[768,"Sec 263A: Comp w/162 limit","8916A, L2ea"]
[769,"Sec 263A: Pension & profit sh","8916A, L2fa"]
[770,"Sec 263A: Oth post-retire bene","8916A, L2ga"]
[771,"Sec 263A: Deferred comp","8916A, L2ha"]
[773,"Sec 263A: Amortization","8916A, L2ja"]
[774,"Sec 263A: Depletion","8916A, L2ka"]
[775,"Sec 263A: Depreciation","8916A, L2la"]
[776,"Sec 263A: Corp life ins prem","8916A, L2ma"]
[777,"Other section 263A costs","8916A, L2na"]
[778,"Inventory shrinkage accruals","8916A, L3a"]
[779,"Excess inv & obsolescence res","8916A, L4a"]
[780,"Meals fully deductible","4835, L30"]
[781,"Preproductive expenses","4835, L30"]
[782,"Rent expense - other","4835, L22b"]
[783,"LCM write-downs","8916A, L5a"]
[784,"CCC loans forf/repaid w/ cert","4835, L4b"]
[785,"Crop ins amt def from prior yr","4835, L5d"]
[786,"Meals (DOT)","4835, L30"]
[788,"Other items w/ differences","8916A, L6a"]
[789,"Interest expense - other","4835, L19b"]
[790,"Other items w/ no differences","8916A, L7a"]
[810,"Research & development costs","M3, PIII, L29a"]
[811,"US current income tax expense","M3 PIII, L1a"]
[812,"US deferred income tax expense","M3 PIII, L2a"]
[813,"State/local current tax exp","M3 PIII, L3a"]
[814,"State/local defer tax exp","M3 PIII, L4a"]
[815,"Foreign current inc tax exp","M3 PIII, L5a"]
[816,"Foreign deferred inc tax exp","M3 PIII, L6a"]
[818,"Section 118 exclusion","M3, PIII, L30a"]
[820,"Equity-based compensation","M3 PIII, L7a"]
[821,"Meals subject to 50% limit","M3 PIII, L8a"]
[822,"Fines and penalties","M3 PIII, L9a"]
[823,"Judgments, penalties, awards","M3 PIII, L10a"]
[826,"Pension and profit-sharing","M3 PIII, L11a"]
[827,"Other post-retirement benefits","M3 PIII, L12a"]
[828,"Deferred compensation","M3 PIII, L13a"]
[829,"Char contr cash/tang property","M3 PIII, L14a"]
[830,"Char contr intangible property","M3 PIII, L15a"]
[833,"Acq/reorg invest bank fees","M3 PIII, L16a"]
[834,"Acq/reorg acctg/legal fees","M3 PIII, L17a"]
[835,"Acq/reorg other costs","M3 PIII, L18a"]
[836,"Amort/impairment of goodwill","M3 PIII, L19a"]
[837,"Amort of acq, reorg startup","M3 PIII, L20a"]
[838,"Other amort or impairment","M3 PIII, L21a"]
[839,"Retained earnings -timing diff","Sch, L, L24"]
[840,"Depletion other than oil/gas","M3 PIII, L23ba"]
[841,"Depreciation","M3 PIII, L24a"]
[842,"Bad debt expense","M3 PIII, L25a"]
[843,"Corp owned life insurance","M3 PIII, L27a"]
[844,"Purchase versus lease","M3 PIII, L28a"]
[845,"Other exp items w/difference","M3 PIII, L31a"]
[855,"Nondeductible entertainment","Sch M1, L3"]

{"sheet":"1065 Import","index":6,"n_rows":303,"n_cols":5,"rows_kept":303,"cut":false,"hidden":true,"merged":[]}
["Tax Code","Ultra Tax CS Description [1065 LLC]","Form, Line #","Account Number","Amount"]
[100,"Gross receipts or sales","1065, L1a",null,{"$f":"-'Income Statement - STEP 2'!B9","v":0}]
[101,"Returns and allowances","1065, L1b",null,{"$f":"'Income Statement - STEP 2'!B14","v":0}]
[103,"Other income","1065, L7",null,{"$f":"-'Income Statement - STEP 2'!B11","v":0}]
[104,"Retirement plans: accrued","1065, L18"]
[110,"Interest income","Sch K, L5"]
[111,"Ordinary dividends","Sch K, L6a",null,{"$f":"'Income Statement - STEP 2'!B29","v":0}]
[112,"Other portfolio income","Sch K, L11"]
[114,"Other income","Sch K, L11",null,{"$f":"'Income Statement - STEP 2'!B27","v":0}]
[115,"U.S. interest","Sch K, L5",null,{"$f":"'Income Statement - STEP 2'!B26","v":0}]
[116,"Mining exploration cost recap","Sch K, L11"]
[117,"Cancellation of debt","Sch K, L11"]
[118,"Section 951(a) inc inclusions","Sch K, L11"]
[120,"GST-Ord inc (loss) from fiduciar","1065, L4"]
[121,"GST-Net ord gain (loss) 4797 II","1065, L6"]
[122,"GST-COGS:Beginning inventory","Sch A, L1"]
[123,"GST-Qualified dividend – invest","Sch K, L6b"]
[124,"GST-Net ST cap gain (loss)","Sch K, L8"]
[125,"GST-Net LT cap gain (loss)","Sch K, L9a"]
[126,"GST-Net Sec 1231 gain (loss)","Sch K, L10"]
[155,"Tax-exempt interest","Sch K, L18a"]
[200,"Salaries and wages","1065, L9",null,{"$f":"'Income Statement - STEP 2'!B59","v":0}]
[201,"Guaranteed payments","1065, L10"]
[202,"Repairs and maintenance","1065, L11",null,{"$f":"'Income Statement - STEP 2'!B60","v":0}]
[203,"Bad debts","1065, L12",null,{"$f":"'Income Statement - STEP 2'!B61","v":0}]
[204,"Rent","1065, L13",null,{"$f":"'Income Statement - STEP 2'!B62","v":0}]
[205,"Taxes and licenses","1065, L14",null,{"$f":"'Income Statement - STEP 2'!B50","v":0}]
[206,"Interest expense","1065, L15",null,{"$f":"'Income Statement - STEP 2'!B63","v":0}]
[207,"Book depr-other than COGS","Sch M-1, var"]
[208,"Depletion (other than oil/gas)","1065, L17"]
[209,"Retirement plans: paid","1065, L18",null,{"$f":"'Income Statement - STEP 2'!B64","v":0}]
[210,"Employee benefit programs","1065, L19",null,{"$f":"'Income Statement - STEP 2'!B65","v":0}]
[211,"Other deductions","1065, L20",null,{"$f":"'Income Statement - STEP 2'!B42+SUM('Income Statement - STEP 2'!B43:'Income Statement - STEP 2'!B49)+SUM('Income Statement - STEP 2'!B51:'Income Statement - STEP 2'!B58)+SUM('Income Statement - STEP 2'!B67,'Income Statement - STEP 2'!B73:'Income Statement - STEP 2'!B80)","v":0}]
[212,"Meals subject to 50% limit","1065, L20"]
[213,"Meals (DOT)","1065, L20"]
[214,"Amortization – book","Sch M-1, var"]
[215,"Start-up/org costs – book","Sch M-1, var"]
[224,"Contributions (100%)","Sch K, L13a"]
[225,"Cash contributions (60%)","Sck K, L13a",null,{"$f":"'Income Statement - STEP 2'!B70","v":0}]
[226,"Cash contributions (30%)","Sch K, L13a"]
[227,"Capital gain property (20%)","Sch K, L13a",null,{"$f":"'Income Statement - STEP 2'!B72","v":0}]
[228,"Section 179 expense - book","Sch K, var"]
[229,"Meals fully deductible","1065, L20",null,{"$f":"'Income Statement - STEP 2'!B66","v":0}]
[230,"Other deductions","Sch K, L13d"]
[231,"OD-Pensions/IRAs considered GP","Sch K, L13d"]
[232,"Investment interest expense","Sch K, L13b",null,{"$f":"'Income Statement - STEP 2'!B33","v":0}]
[233,"Total foreign taxes paid or accrued","Sch K, L21"]
[234,"Section 59(e) (2) expenditures","Sch K, L13c2"]
[235,"OD-Educational assist benefits","Sch K, L13d"]
[236,"OD-Dependent care benefits","Sch K, L13d"]
[238,"OD-Penalty on early withdrawal","Sch K, L13d"]
[239,"OD-Other pensions and IRAs","Sch K, L13d"]
[240,"Noncash contributions (50%)","Sch K, L13a",null,{"$f":"'Income Statement - STEP 2'!B71","v":0}]
[241,"Noncash contributions (30%)","Sch K, L13a"]
[242,"Capital gain property (30%)","Sch K, L13a"]
[243,"Portfolio ded - other","Sch K, L13d"]
[244,"OD-Health ins considered GPs","Sch K, 13d"]
[245,"OD-Other health insurance","Sch K, L13d"]
[248,"Portfolio ded – guaranteed pay","Sch K, L13d"]
[267,"Guar pymts – health insurance","1065, L10"]
[268,"Guar pymts – pensions and IRAs","1065, L10"]
[275,"Purchases","1125-A, L2",null,{"$f":"'Income Statement - STEP 2'!B16","v":0}]
[276,"Cost of labor","1125-A, L3",null,{"$f":"'Income Statement - STEP 2'!B18","v":0}]
[277,"Additional section 263A costs","1125-A, L4",null,{"$f":"'Income Statement - STEP 2'!B19","v":0}]
[278,"Other costs","1125-A, L5",null,{"$f":"-'Income Statement - STEP 2'!B17+'Income Statement - STEP 2'!B20","v":0}]
[279,"Ending inventory","1125-A, L7",null,{"$f":"'Income Statement - STEP 2'!B21","v":0}]
[280,"Book depreciation-COGS","Sch M-1, var"]
[399,"Capital gain distributions","Sch D, L14"]
[400,"Cash","Sch L, L1",null,{"$f":"'Balance Sheet - STEP 3'!B7+'Balance Sheet - STEP 3'!C7+'Balance Sheet - STEP 3'!D7","v":0}]
[401,"Accounts receivable","Sch L, L2a",null,{"$f":"'Balance Sheet - STEP 3'!B11","v":0}]
[402,"Allowance for bad debts","Sch L, L2b",null,{"$f":"'Balance Sheet - STEP 3'!C11","v":0}]
[403,"Inventories","Sch L, L3",null,{"$f":"'Balance Sheet - STEP 3'!B15","v":0}]
[404,"U.S. government obligations","Sch L, L4",null,{"$f":"'Balance Sheet - STEP 3'!B19","v":0}]
[405,"Tax-exempt securities","Sch L, L5",null,{"$f":"'Balance Sheet - STEP 3'!C19","v":0}]
[406,"Other current assets","Sch L, L6",null,{"$f":"'Balance Sheet - STEP 3'!D19+'Balance Sheet - STEP 3'!E19","v":0}]
[407,"Loans to partners","Sch L, L7a",null,{"$f":"'Balance Sheet - STEP 3'!B23+'Balance Sheet - STEP 3'!C23+'Balance Sheet - STEP 3'!D23+'Balance Sheet - STEP 3'!E23","v":0}]
[415,"Mortage and real estate loans","Sch L, L7b",null,{"$f":"'Balance Sheet - STEP 3'!B23+'Balance Sheet - STEP 3'!C23+'Balance Sheet - STEP 3'!D23+'Balance Sheet - STEP 3'!E23","v":0}]
[416,"Other investments","Sch L, L8",null,{"$f":"'Balance Sheet - STEP 3'!B31+'Balance Sheet - STEP 3'!C31+'Balance Sheet - STEP 3'!D31+'Balance Sheet - STEP 3'!E31","v":0}]
[425,"Buildings and other deprec ast","Sch L, L9a",null,{"$f":"'Balance Sheet - STEP 3'!B40+'Balance Sheet - STEP 3'!C40+'Balance Sheet - STEP 3'!D40+'Balance Sheet - STEP 3'!E40","v":0}]
[426,"Accumulated depreciation","Sch L, L9b"]
[427,"Depletable assets","Sch L, L10a"]
[428,"Accumulated depletion","Sch L, L10b"]
[429,"Land","Sch L, L11"]
[430,"Intangible assets","Sch L, L12a"]
[431,"Accumulated amortization","Sch L, L12b"]
[432,"Other assets","Sch L, L13",null,{"$f":"'Balance Sheet - STEP 3'!B35+'Balance Sheet - STEP 3'!C35+'Balance Sheet - STEP 3'!D35+'Balance Sheet - STEP 3'!E35","v":0}]
[440,"Accounts payable","Sch L, L15",null,{"$f":"'Balance Sheet - STEP 3'!B45","v":0}]
[441,"Mort, etc less than 1 year","Sch L, L16",null,{"$f":"'Balance Sheet - STEP 3'!B49+'Balance Sheet - STEP 3'!C49+'Balance Sheet - STEP 3'!D49+'Balance Sheet - STEP 3'!E49","v":0}]
[442,"Other current liabilities","Sch L, L17",null,{"$f":"'Balance Sheet - STEP 3'!B53","v":0}]
[443,"All nonrecourse loans","Sch L, L18"]
[444,"Loans from partners","Sch L, L19a",null,{"$f":"'Balance Sheet - STEP 3'!B57+'Balance Sheet - STEP 3'!C57+'Balance Sheet - STEP 3'!D57+'Balance Sheet - STEP 3'!E57","v":0}]
[450,"Mort, etc 1 year or more","Sch L, L19b",null,{"$f":"'Balance Sheet - STEP 3'!B61+'Balance Sheet - STEP 3'!C61+'Balance Sheet - STEP 3'!D61+'Balance Sheet - STEP 3'!E61","v":0}]
[451,"Other liabilities","Sch L, L20",null,{"$f":"'Balance Sheet - STEP 3'!C53+'Balance Sheet - STEP 3'!D53+'Balance Sheet - STEP 3'!E53","v":0}]
[465,"Partners' capital accounts","Sch L, L21"]
[480,"Taxable income  not on books","Sch M-1, L2"]
[481,"Nondeductible expenses","Sch M-1, L4"]
[482,"Other tax-exempt income","Sch M-1, L6"]
[483,"Return deductions not on books","Sch M-1, L7"]
[485,"Capital contributed: cash","Sch M-2, L2a",null,{"$f":"'Balance Sheet - STEP 3'!B75+'Balance Sheet - STEP 3'!C75+'Balance Sheet - STEP 3'!D75+'Balance Sheet - STEP 3'!E75","v":0}]
[486,"Other capital increases","Sch M-2, L4"]
[487,"Distributions: cash","Sch M-2, L6a",null,{"$f":"'Balance Sheet - STEP 3'!B72+'Balance Sheet - STEP 3'!C72+'Balance Sheet - STEP 3'!D72+'Balance Sheet - STEP 3'!E72","v":0}]
[488,"Distributions: property","Sch M-2, L6b"]
[489,"Other capital decreases","Sch M-2, L7"]
[490,"Capital contributed: property","Sch M-2, L2b"]
[491,"4797 gain/loss - book","Sch M-1, var"]
[492,"Distributions: section 737","Sch M-2, L6b"]
[502,"Gross rents","Rent, var"]
[503,"Advertising","Rent, var"]
[504,"Auto and travel","Rent, var"]
[505,"Cleaning and maintenance","Rent, var"]
[506,"Commissions","Rent, var"]
[507,"Insurance","Rent, var"]
[508,"Legal and professional","Rent, var"]
[509,"Interest","Rent, var"]
[510,"Repairs","Rent, var"]
[511,"Taxes","Rent, var"]
[512,"Utilities","Rent, var"]
[513,"Wages and salaries","Rent, var"]
[514,"Depreciation","Rent, var"]
[515,"Other expenses","Rent, var"]
[582,"Gross royalties","Rent, var"]
[584,"Guaranteed payments","Rent, var"]
[585,"Meals subject to 50% limit","Rent, var"]
[586,"Meals (DOT)","Rent, var"]
[587,"Amortization","Rent, var"]
[588,"Guar pymts – pensions and IRAs","Rent, var"]
[589,"Guar pymts – health insurance","Rent, var"]
[590,"Other income","Rent, var"]
[591,"Meals fully deductible","Rent, var"]
[601,"Sales of resale items","Sch F, var"]
[602,"Cost/basis of resale items","Sch F, L1b"]
[604,"Sales of items raised","Sch F, L2"]
[605,"Cooperative distributions","Sch F, var"]
[606,"Agricultural program payments","Sch F, var"]
[607,"CCC loans reported under elec.","Sch F, var"]
[608,"Crop insurance proceeds","Sch F, var"]
[609,"Custom hire income","Sch F, var"]
[610,"Other income","Sch F, var"]
[612,"Car and truck expenses","Sch F, L10"]
[613,"Chemicals","Sch F, L11"]
[614,"Conservation expenses","Sch F, L12"]
[615,"Custom hire (machine work)","Sch F, L13"]
[616,"Depreciation","Sch F, L14"]
[617,"Employee benefit programs","Sch F, L15"]
[618,"Feed purchased","Sch F, L16"]
[619,"Fertilizers and lime","Sch F, L17"]
[620,"Freight and trucking","Sch F, L18"]
[621,"Gasoline, fuel, oil","Sch F, L19"]
[622,"Insurance","Sch F, L20"]
[623,"Interest – mortage (banks)","Sch F, L21a"]
[624,"Labor hired","Sch F, L22"]
[625,"Pension and profit sharing","Sch F, L23"]
[626,"Rent – vehicles, machinery","Sch F, L24a"]
[627,"Repairs and maintenance","Sch F, L25"]
[628,"Seeds and plants","Sch F, L26"]
[629,"Storage and warehousing","Sch F, L27"]
[630,"Supplies purchased","Sch F, L28"]
[631,"Taxes","Sch F, L29"]
[632,"Utilities","Sch F, L30"]
[633,"Veterinary, breeding, medicine","Sch F, L31"]
[634,"Other expenses","Sch F, L32"]
[635,"Guar pymts – pensions and IRAs","Sch F, var"]
[636,"Guar pymts – health insurance","Sch F, var"]
[646,"Beginning inventory (Farm)","Sch F, L45"]
[647,"Cost of items purchased","Sch F, L46"]
[649,"Ending inventory (Farm)","Sch F, L48"]
[683,"Interest - other","Sch F, L21b"]
[684,"Guaranteed payments","Sch F, L32"]
[685,"Preproductive period expenses","Sch F, L32"]
[686,"Rent - other","Sch F, L24b"]
[687,"CCC loans forfeited","Sch F, L6d"]
[688,"Crop ins. proceeds deferred","Sch F, L6d"]
[689,"Meals subject to 50% limit","Sch F, L32"]
[690,"Meals (DOT)","Sch F, L32"]
[691,"Amortization","Sch F, L32"]
[692,"Meals fully deductible","Sch F, L32"]
[701,"Income from production","FRent, L1"]
[702,"Cooperative distributions","FRent, L2a"]
[703,"Agricultural program payments","FRent, L3a"]
[704,"CCC loans reported under elec","FRent, L4a"]
[705,"Crop insurance proceeds","FRent, L5a"]
[706,"Other income (Farm rent)","FRent, L6"]
[708,"Car and truck expenses","FRent, L8"]
[709,"Chemicals","FRent, L9"]
[710,"Conservation expenses","FRent, L10"]
[711,"Custom hire (machine work)","FRent, L11"]
[712,"Depreciation","FRent, L12"]
[713,"Employee benefit programs","FRent, L13"]
[714,"Feed purchased","FRent, L14"]
[715,"Fertilizers and lime","FRent, L15"]
[716,"Freight and trucking","FRent, L16"]
[717,"Gasoline, fuel, oil","FRent, L17"]
[718,"Insurance","FRent, L18"]
[719,"Interest – mortgage (banks)","FRent, L19a"]
[720,"Labor hired","FRent, L20"]
[721,"Pension and profit sharing","FRent, L21"]
[722,"Rent – vehicles, machinery","FRent, L22a"]
[723,"Repairs and maintenance","FRent, L23"]
[724,"Seeds and plants","FRent, L24"]
[725,"Storage and warehousing","FRent, L25"]
[726,"Supplies purchased","FRent, L26"]
[727,"Taxes","FRent, L27"]
[728,"Utilities","FRent, L28"]
[729,"Veterinary, breeding, medicine","FRent, L29"]
[730,"Other expenses","FRent, L30"]
[778,"Guar pymts – pension and IRAs","FRent, var"]
[779,"Guar pymts – health insurance","FRent, var"]
[780,"Guaranteed payments","FRent, L30"]
[781,"Preproductive period expenses","FRent, L30"]
[782,"Rent – other","FRent, L22b"]
[783,"Meals subject to 50% limit","FRent, L30"]
[784,"CCC loans forfeited","FRent, L4b"]
[785,"Crop ins. proceeds deferred","FRent, L5d"]
[786,"Meals (DOT)","FRent, L30"]
[787,"Amortization","FRent, L30"]
[789,"Interest – other","FRent, L19b"]
[811,"Equity method foreigncorp","M3 PII, L1a"]
[812,"Gross fgn div not prev taxed","M3 PII, L2a"]
[813,"Subpart F, QEF income incl","M3 PII, L3a"]
[814,"Gross fgn dist prev taxed","M3 PII, L4a"]
[815,"Equity method US corps","M3 PII, L5a"]
[816,"US dividends","M3 PII, L6a"]
[817,"US partnerships","M3 PII, L7a"]
[818,"Foreign partnerships","M3 PII, L8a"]
[819,"Other pass-through entities","M3 PII, L9a"]
[820,"Reportable transactions","M3 PII, L10a"]
[822,"Accrual to cash adjustment","M3 PII, L12a"]
[823,"Hedging transactions","M3 PII, L13a"]
[824,"Mark-to-market income/loss","M3 PII, L14a"]
[826,"Sale versus lease","M3 PII, L16a"]
[827,"Section 481(a) adjustments","M3 PII, L17a"]
[828,"Unearned/deferred revenue","M3 PII, L18a"]
[829,"Income rec long term contracts","M3 PII, L19a"]
[830,"OID and imputed interest","M3 PII, L20a"]
[831,"Inc stmt gain/loss on assets","M3 PII, L21aa"]
[832,"Capital gains from Sch D","M3 PII, L21ba"]
[833,"Capital losses from Sch D","M3 PII, L21ca"]
[834,"Gain/loss on Form 4797","M3 PII, L21da"]
[835,"Abandonment losses","M3 PII, L21ea"]
[836,"Worthless stock losses","M3 PII, L21fa"]
[837,"Other gain/loss on assets","M3 PII, L21ga"]
[838,"Other income/loss w/diffs","M3 PII, L22a"]
[839,"Other items w/no differences","M3 PII, L25a"]
[842,"State/local current tax exp","M3 PIII, L1a"]
[843,"State/local deferred tax exp","M3 PIII, L2a"]
[844,"Foreign current inc tax exp","M3 PIII, L3a"]
[845,"Foreign deferred tax exp","M3 PIII, L4a"]
[846,"Equity-based compensation","M3 PIII, L5a"]
[847,"Meals subject to 50% limit","M3 PIII, L6a"]
[848,"Fines and penalties","M3 PIII, L7a",null,{"$f":"'Income Statement - STEP 2'!B69","v":0}]
[849,"Judgments, damages, awards","M3 PIII, L8a"]
[850,"Entertainment","M3 PIII, L6a"]
[851,"Pension and profit-sharing","M3 PIII, L10a"]
[852,"Other post-retirement benefits","M3 PIII, L11a"]
[853,"Deferred compensation","M3 PIII, L12a"]
[854,"Char contr cash/tang property","M3 PIII, L13a"]
[855,"Char contr intangible property","M3 PIII, L14a"]
[856,"Organizational expenses","M3 PIII, L15a"]
[857,"Syndication expenses","M3 PIII, L16a"]
[858,"Acq/reorg invest bank fees","M3 PIII, L17a"]
[859,"Acq/reorg legal/acctg fees","M3 PIII, L18a"]
[860,"Amort/impairment of goodwill","M3 PIII, L19a"]
[861,"Amort of acq, reorg, startup","M3 PIII, L20a"]
[862,"Other amort or impairment","M3 PIII, L21a"]
[864,"Depletion-oil & gas","M3 PIII, L23aa"]
[865,"Depletion other than oil/gas","M3 PIII, L23ba"]
[866,"Intangible drilling costs","M3 PIII, L24"]
[867,"Depreciation","M3 PIII, L25a"]
[868,"Bad debt expense","M3 PIII, L26a"]
[870,"Purchase versus lease","M3 PIII, L28a"]
[871,"Other exp items w/differences","M3 PIII, L30a"]
[872,"Research development costs","M3, PIII, L29"]
[876,"Amts attrib cost flow assump","8916A, L1a"]
[877,"Sec 263A: Stock option exp","8916A, L2aa"]
[878,"Sec 263A: Equity based comp","8916A, L2ba"]
[879,"Sec 263A: Meals & entertain","8916A, L2ca"]
[880,"Sec 263A: Parachute payments","8916A, L2da"]
[881,"Sec 263A: Comp w/162 limit","8916A, L2ea"]
[882,"Sec 263A: Pension/profit-share","8916A, L2fa"]
[883,"Sec 263A: Oth post-retire bene","8916A, L2ga"]
[884,"Sec 263A: Deferred comp","8916A, L2ha"]
[886,"Sec 263A: Amortization","8916A, L2ja"]
[887,"Sec 263A: Depletion","8916A, L2ka"]
[888,"Sec 263A: Depreciation","8916A, L2la"]
[889,"Sec 263A: Corporate life ins","8916A, L2ma"]
[890,"Other section 263A costs","8916A, L2na"]
[891,"Inventory shrinkage accruals","8916A, L3a"]
[892,"Excess inv & obsol reserves","8916A, L4a"]
[893,"LCM write-downs","8916A, L5a"]
[894,"Other items w/differences","8916A, L6a"]
[895,"Other items w/no differences","8916A, L7a"]
[896,"Tax-exempt interest income","8916A PII, L1a"]
[897,"Interest inc from hybrid secs","8916A PII, L2a"]
[898,"Sale/lease interest income","8916A PII, L3a"]
[899,"Interco int inc outside tax gr","8916A PII, L4a"]
[900,"Interco int inc tax affil gr","8916A PII, L4b"]
[901,"Other interest income","8916A PII, L5a"]
[902,"Interest exp from hybrid sec","8916A PIII, L1a"]
[903,"Lease/purchase interest exp","8916A PIII, L2a"]
[904,"Interco int exp outside tax gr","8916A PIII, L3a"]
[905,"Interco int exp gax affil gr","8916A PIII, L3b"]
[906,"Other interest expense","8916A PIII, L4a"]
[995,"Nondeductible Entertainment","Sch M1, L4"]

{"sheet":"Rental Property 1","index":7,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[[8,0,8,1],[20,5,20,7],[5,5,5,6],[9,5,9,7],[8,2,8,3],[8,5,8,7],[11,5,11,7],[15,5,15,7],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[19,5,19,7],[19,2,19,3],[34,5,34,7],[35,5,35,7],[36,5,36,7],[27,5,27,7],[33,5,33,7],[34,2,34,3],[35,2,35,3],[36,2,36,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[31,2,31,3],[21,5,21,7],[22,5,22,7],[32,2,32,3],[32,5,32,7],[33,2,33,3],[28,5,28,7],[29,5,29,7],[30,5,30,7],[31,5,31,7],[30,2,30,3],[3,2,3,7],[6,2,7,7],[16,5,16,7],[17,5,17,7],[18,5,18,7],[17,2,17,3],[18,2,18,3],[12,5,12,7],[0,1,0,7],[10,0,10,7],[5,2,5,4],[25,5,25,7],[26,5,26,7],[9,2,9,3],[1,1,1,7],[13,5,13,7],[14,5,14,7],[2,1,2,4],[23,5,23,7],[24,5,24,7],[4,6,4,7],[20,2,20,3],[21,2,21,3],[22,2,22,3]]}
[null,"Property 1  -- Annual Income/Exp (Jan 1 - Dec 31)"]
["Address:"]
["Property Type:"]
["Days Rented In Year:"]
["Ownership Percentage of Property:",1,null,null,null,{"$f":"\"Mileage Rate for \"&'General Info - STEP 1'!B3&\":\"","v":"Mileage Rate for :"},0.625]
["Business Use Percentage if less than 100%:",null,"EXAMPLE FOREIGN EXCHANGE RATE IS FOR INDIA. PLEASE PROVIDE APPLICABLE FIGURE.",null,null,"Foreign Currency Exchange Rate to $1 US:"]
["Purchase Price + Net Closing Costs:",null,"Provide HUD or Closing Disclosure statement if newly bought last year; else, provide purchase price + closing costs minus any credits received at closing. If property was NEWLY rented out last year, provide lower of value or original purchase price on date first rented. "]
["Lower of Value or Original Purchase Price:"]
["Provide the following figures without adjusting for your ownership percentage.",null,"In Foreign Currency",null,"Calculated US $ Value, after Allocation","You can specify the explantion or vendor name, if needed below"]
["GROSS TOTAL Rents: ",null,null,null,{"$f":"IF(ISNUMBER($C10),($C10/$H$6)*$B$5,\"\")","v":""}]
["--Expenses--"]
["     Advertising (for e.g., Craigslist, newspaper):",null,null,null,{"$f":"IF(ISNUMBER($C12),($C12/$H$6)*$B$5,\"\")","v":""}]
["  Miles Driven in Year to Property, stores, etc.",null,null,null,{"$f":"IF(ISNUMBER($C13),($C13*$G$5)*$B$5,\"\")","v":""}]
["Airfares to & From Hotel:",null,null,null,{"$f":"IF(ISNUMBER($C14),($C14/$H$6)*$B$5,\"\")","v":""}]
["Hotels stayed at while visiting property:",null,null,null,""]
["     Cleaning and Maintenance:",null,null,null,""]
["     Commissions Paid:",null,null,null,""]
["Depreciation Per US Standards (Estimated):",null,null,null,""]
["     Property Insurance:",null,null,null,""]
["     Legal & Professional (E.g., Village License):",null,null,null,""]
["     Management Fees:",null,null,null,""]
["     Mortgage Interest:",null,null,null,""]
["     Other Mortgage Interest:",null,null,null,""]
["     Other Interest:",null,null,null,""]
["Pest Control:",null,null,null,""]
["Salary or Contractor Salary Paid to Anyone:",null,null,null,""]
["     Repairs (NOT MAJOR IMPROVEMENTS):",null,null,null,""]
["     Supplies (Furniture, Sheets, Paint, etc.):",null,null,null,""]
["     Taxes: Real Estate:",null,null,null,""]
["     Taxes: Personal Property:",null,null,null,""]
["     Taxes: Other:",null,null,null,""]
["     Utilities:",null,null,null,""]
["     Points Paid on Refinance:",null,null,null,""]
["     Association/Society:",null,null,null,""]
["     Other Miscellaneous Expenses:",null,null,null,""]
["Total Expenses:",{"$f":"IF($B12+($B$13*$G$5)+SUM(B$15:B$35)>0,$B12+($B$13*$G$5)+SUM(B$15:B$35),\"\")","v":""},{"$f":"IF(C12+(C13*$G$5*$H$6)+SUM($C14:$D35)>0,C12+(C13*$G$5*$H$6)+SUM($C14:$D35),\"\")","v":""},null,""]
["NET PROFIT/ LOSS:",{"$f":"IF(OR($B$10=\"\",$B$10=0),IF(OR($B$36=\"\",$B$36=0),0,$B$10-$B36),IF($B$10>0,IF($B$36=\"\",$B$10,$B$10-$B$36),\"ERROR\"))","v":0},{"$f":"IF(OR($C$10=\"\",$C$10=0),IF(OR($C$36=\"\",$C$36=0),0,$C$10-$C36),IF($C$10>0,IF($C$36=\"\",$C$10,$C$10-$C$36),\"ERROR\"))","v":0},null,{"$error":"#DIV/0!"}]

{"sheet":"Rental Property 2","index":8,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[[35,2,35,3],[35,5,35,7],[36,2,36,3],[36,5,36,7],[32,2,32,3],[32,5,32,7],[33,2,33,3],[33,5,33,7],[34,2,34,3],[34,5,34,7],[29,2,29,3],[29,5,29,7],[30,2,30,3],[30,5,30,7],[31,2,31,3],[31,5,31,7],[26,2,26,3],[26,5,26,7],[27,2,27,3],[27,5,27,7],[28,2,28,3],[28,5,28,7],[23,2,23,3],[23,5,23,7],[24,2,24,3],[24,5,24,7],[25,2,25,3],[25,5,25,7],[20,2,20,3],[20,5,20,7],[21,2,21,3],[21,5,21,7],[22,2,22,3],[22,5,22,7],[17,2,17,3],[17,5,17,7],[18,2,18,3],[18,5,18,7],[19,2,19,3],[19,5,19,7],[14,2,14,3],[14,5,14,7],[15,2,15,3],[15,5,15,7],[16,2,16,3],[16,5,16,7],[13,2,13,3],[13,5,13,7],[6,2,7,7],[8,0,8,1],[8,2,8,3],[8,5,8,7],[9,2,9,3],[9,5,9,7],[10,0,10,7],[11,2,11,3],[11,5,11,7],[12,2,12,3],[12,5,12,7],[5,2,5,4],[5,5,5,6],[0,1,0,7],[1,1,1,7],[2,1,2,4],[3,2,3,7],[4,6,4,7]]}
[null,"Property 2  -- Annual Income/Exp (Jan 1 - Dec 31)"]
["Address:"]
["Property Type:"]
["Days Rented In Year:"]
["Ownership Percentage of Property:",1,null,null,null,{"$f":"\"Mileage Rate for \"&'General Info - STEP 1'!B3&\":\"","v":"Mileage Rate for :"},0.625]
["Business Use Percentage if less than 100%:",null,"EXAMPLE FOREIGN EXCHANGE RATE IS FOR INDIA. PLEASE PROVIDE APPLICABLE FIGURE.",null,null,"Foreign Currency Exchange Rate to $1 US:"]
["Purchase Price + Net Closing Costs:",null,"Provide HUD or Closing Disclosure statement if newly bought last year; else, provide purchase price + closing costs minus any credits received at closing. If property was NEWLY rented out last year, provide lower of value or original purchase price on date first rented. "]
["Lower of Value or Original Purchase Price:"]
["Provide the following figures without adjusting for your ownership percentage.",null,"In Foreign Currency",null,"Calculated US $ Value, after Allocation","You can specify the explantion or vendor name, if needed below"]
["GROSS TOTAL Rents: ",null,null,null,{"$f":"IF(ISNUMBER($C10),($C10/$H$6)*$B$5,\"\")","v":""}]
["--Expenses--"]
["     Advertising (for e.g., Craigslist, newspaper):",null,null,null,{"$f":"IF(ISNUMBER($C12),($C12/$H$6)*$B$5,\"\")","v":""}]
["  Miles Driven in Year to Property, stores, etc.",null,null,null,{"$f":"IF(ISNUMBER($C13),($C13*$G$5)*$B$5,\"\")","v":""}]
["Airfares to & From Hotel:",null,null,null,{"$f":"IF(ISNUMBER($C14),($C14/$H$6)*$B$5,\"\")","v":""}]
["Hotels stayed at while visiting property:",null,null,null,""]
["     Cleaning and Maintenance:",null,null,null,""]
["     Commissions Paid:",null,null,null,""]
["Depreciation Per US Standards (Estimated):",null,null,null,""]
["     Property Insurance:",null,null,null,""]
["     Legal & Professional (E.g., Village License):",null,null,null,""]
["     Management Fees:",null,null,null,""]
["     Mortgage Interest:",null,null,null,""]
["     Other Mortgage Interest:",null,null,null,""]
["     Other Interest:",null,null,null,""]
["Pest Control:",null,null,null,""]
["Salary or Contractor Salary Paid to Anyone:",null,null,null,""]
["     Repairs (NOT MAJOR IMPROVEMENTS):",null,null,null,""]
["     Supplies (Furniture, Sheets, Paint, etc.):",null,null,null,""]
["     Taxes: Real Estate:",null,null,null,""]
["     Taxes: Personal Property:",null,null,null,""]
["     Taxes: Other:",null,null,null,""]
["     Utilities:",null,null,null,""]
["     Points Paid on Refinance:",null,null,null,""]
["     Association/Society:",null,null,null,""]
["     Other Miscellaneous Expenses:",null,null,null,""]
["Total Expenses:",{"$f":"IF($B12+($B$13*$G$5)+SUM(B$15:B$35)>0,$B12+($B$13*$G$5)+SUM(B$15:B$35),\"\")","v":""},{"$f":"IF(C12+(C13*$G$5*$H$6)+SUM($C14:$D35)>0,C12+(C13*$G$5*$H$6)+SUM($C14:$D35),\"\")","v":""},null,""]
["NET PROFIT/ LOSS:",{"$f":"IF(OR($B$10=\"\",$B$10=0),IF(OR($B$36=\"\",$B$36=0),0,$B$10-$B36),IF($B$10>0,IF($B$36=\"\",$B$10,$B$10-$B$36),\"ERROR\"))","v":0},{"$f":"IF(OR($C$10=\"\",$C$10=0),IF(OR($C$36=\"\",$C$36=0),0,$C$10-$C36),IF($C$10>0,IF($C$36=\"\",$C$10,$C$10-$C$36),\"ERROR\"))","v":0},null,{"$error":"#DIV/0!"}]

{"sheet":"Rental Property 3","index":9,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[[5,2,5,4],[5,5,5,6],[0,1,0,7],[1,1,1,7],[2,1,2,4],[3,2,3,7],[4,6,4,7],[13,2,13,3],[13,5,13,7],[6,2,7,7],[8,0,8,1],[8,2,8,3],[8,5,8,7],[9,2,9,3],[9,5,9,7],[10,0,10,7],[11,2,11,3],[11,5,11,7],[12,2,12,3],[12,5,12,7],[14,2,14,3],[14,5,14,7],[15,2,15,3],[15,5,15,7],[16,2,16,3],[16,5,16,7],[17,2,17,3],[17,5,17,7],[18,2,18,3],[18,5,18,7],[19,2,19,3],[19,5,19,7],[20,2,20,3],[20,5,20,7],[21,2,21,3],[21,5,21,7],[22,2,22,3],[22,5,22,7],[23,2,23,3],[23,5,23,7],[24,2,24,3],[24,5,24,7],[25,2,25,3],[25,5,25,7],[26,2,26,3],[26,5,26,7],[27,2,27,3],[27,5,27,7],[28,2,28,3],[28,5,28,7],[29,2,29,3],[29,5,29,7],[30,2,30,3],[30,5,30,7],[31,2,31,3],[31,5,31,7],[35,2,35,3],[35,5,35,7],[36,2,36,3],[36,5,36,7],[32,2,32,3],[32,5,32,7],[33,2,33,3],[33,5,33,7],[34,2,34,3],[34,5,34,7]]}
[null,"Property 3  -- Annual Income/Exp (Jan 1 - Dec 31)"]
["Address:"]
["Property Type:"]
["Days Rented In Year:"]
["Ownership Percentage of Property:",1,null,null,null,{"$f":"\"Mileage Rate for \"&'General Info - STEP 1'!B3&\":\"","v":"Mileage Rate for :"},0.625]
["Business Use Percentage if less than 100%:",null,"EXAMPLE FOREIGN EXCHANGE RATE IS FOR INDIA. PLEASE PROVIDE APPLICABLE FIGURE.",null,null,"Foreign Currency Exchange Rate to $1 US:"]
["Purchase Price + Net Closing Costs:",null,"Provide HUD or Closing Disclosure statement if newly bought last year; else, provide purchase price + closing costs minus any credits received at closing. If property was NEWLY rented out last year, provide lower of value or original purchase price on date first rented. "]
["Lower of Value or Original Purchase Price:"]
["Provide the following figures without adjusting for your ownership percentage.",null,"In Foreign Currency",null,"Calculated US $ Value, after Allocation","You can specify the explantion or vendor name, if needed below"]
["GROSS TOTAL Rents: ",null,null,null,{"$f":"IF(ISNUMBER($C10),($C10/$H$6)*$B$5,\"\")","v":""}]
["--Expenses--"]
["     Advertising (for e.g., Craigslist, newspaper):",null,null,null,{"$f":"IF(ISNUMBER($C12),($C12/$H$6)*$B$5,\"\")","v":""}]
["  Miles Driven in Year to Property, stores, etc.",null,null,null,{"$f":"IF(ISNUMBER($C13),($C13*$G$5)*$B$5,\"\")","v":""}]
["Airfares to & From Hotel:",null,null,null,{"$f":"IF(ISNUMBER($C14),($C14/$H$6)*$B$5,\"\")","v":""}]
["Hotels stayed at while visiting property:",null,null,null,""]
["     Cleaning and Maintenance:",null,null,null,""]
["     Commissions Paid:",null,null,null,""]
["Depreciation Per US Standards (Estimated):",null,null,null,""]
["     Property Insurance:",null,null,null,""]
["     Legal & Professional (E.g., Village License):",null,null,null,""]
["     Management Fees:",null,null,null,""]
["     Mortgage Interest:",null,null,null,""]
["     Other Mortgage Interest:",null,null,null,""]
["     Other Interest:",null,null,null,""]
["Pest Control:",null,null,null,""]
["Salary or Contractor Salary Paid to Anyone:",null,null,null,""]
["     Repairs (NOT MAJOR IMPROVEMENTS):",null,null,null,""]
["     Supplies (Furniture, Sheets, Paint, etc.):",null,null,null,""]
["     Taxes: Real Estate:",null,null,null,""]
["     Taxes: Personal Property:",null,null,null,""]
["     Taxes: Other:",null,null,null,""]
["     Utilities:",null,null,null,""]
["     Points Paid on Refinance:",null,null,null,""]
["     Association/Society:",null,null,null,""]
["     Other Miscellaneous Expenses:",null,null,null,""]
["Total Expenses:",{"$f":"IF($B12+($B$13*$G$5)+SUM(B$15:B$35)>0,$B12+($B$13*$G$5)+SUM(B$15:B$35),\"\")","v":""},{"$f":"IF(C12+(C13*$G$5*$H$6)+SUM($C14:$D35)>0,C12+(C13*$G$5*$H$6)+SUM($C14:$D35),\"\")","v":""},null,""]
["NET PROFIT/ LOSS:",{"$f":"IF(OR($B$10=\"\",$B$10=0),IF(OR($B$36=\"\",$B$36=0),0,$B$10-$B36),IF($B$10>0,IF($B$36=\"\",$B$10,$B$10-$B$36),\"ERROR\"))","v":0},{"$f":"IF(OR($C$10=\"\",$C$10=0),IF(OR($C$36=\"\",$C$36=0),0,$C$10-$C36),IF($C$10>0,IF($C$36=\"\",$C$10,$C$10-$C$36),\"ERROR\"))","v":0},null,{"$error":"#DIV/0!"}]

{"sheet":"Rental Property 4","index":10,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[[5,2,5,4],[5,5,5,6],[0,1,0,7],[1,1,1,7],[2,1,2,4],[3,2,3,7],[4,6,4,7],[13,2,13,3],[13,5,13,7],[6,2,7,7],[8,0,8,1],[8,2,8,3],[8,5,8,7],[9,2,9,3],[9,5,9,7],[10,0,10,7],[11,2,11,3],[11,5,11,7],[12,2,12,3],[12,5,12,7],[14,2,14,3],[14,5,14,7],[15,2,15,3],[15,5,15,7],[16,2,16,3],[16,5,16,7],[17,2,17,3],[17,5,17,7],[18,2,18,3],[18,5,18,7],[19,2,19,3],[19,5,19,7],[20,2,20,3],[20,5,20,7],[21,2,21,3],[21,5,21,7],[22,2,22,3],[22,5,22,7],[23,2,23,3],[23,5,23,7],[24,2,24,3],[24,5,24,7],[25,2,25,3],[25,5,25,7],[26,2,26,3],[26,5,26,7],[27,2,27,3],[27,5,27,7],[28,2,28,3],[28,5,28,7],[29,2,29,3],[29,5,29,7],[30,2,30,3],[30,5,30,7],[31,2,31,3],[31,5,31,7],[35,2,35,3],[35,5,35,7],[36,2,36,3],[36,5,36,7],[32,2,32,3],[32,5,32,7],[33,2,33,3],[33,5,33,7],[34,2,34,3],[34,5,34,7]]}
[null,"Property 4  -- Annual Income/Exp (Jan 1 - Dec 31)"]
["Address:"]
["Property Type:"]
["Days Rented In Year:"]
["Ownership Percentage of Property:",1,null,null,null,{"$f":"\"Mileage Rate for \"&'General Info - STEP 1'!B3&\":\"","v":"Mileage Rate for :"},0.625]
["Business Use Percentage if less than 100%:",null,"EXAMPLE FOREIGN EXCHANGE RATE IS FOR INDIA. PLEASE PROVIDE APPLICABLE FIGURE.",null,null,"Foreign Currency Exchange Rate to $1 US:"]
["Purchase Price + Net Closing Costs:",null,"Provide HUD or Closing Disclosure statement if newly bought last year; else, provide purchase price + closing costs minus any credits received at closing. If property was NEWLY rented out last year, provide lower of value or original purchase price on date first rented. "]
["Lower of Value or Original Purchase Price:"]
["Provide the following figures without adjusting for your ownership percentage.",null,"In Foreign Currency",null,"Calculated US $ Value, after Allocation","You can specify the explantion or vendor name, if needed below"]
["GROSS TOTAL Rents: ",null,null,null,{"$f":"IF(ISNUMBER($C10),($C10/$H$6)*$B$5,\"\")","v":""}]
["--Expenses--"]
["     Advertising (for e.g., Craigslist, newspaper):",null,null,null,{"$f":"IF(ISNUMBER($C12),($C12/$H$6)*$B$5,\"\")","v":""}]
["  Miles Driven in Year to Property, stores, etc.",null,null,null,{"$f":"IF(ISNUMBER($C13),($C13*$G$5)*$B$5,\"\")","v":""}]
["Airfares to & From Hotel:",null,null,null,{"$f":"IF(ISNUMBER($C14),($C14/$H$6)*$B$5,\"\")","v":""}]
["Hotels stayed at while visiting property:",null,null,null,""]
["     Cleaning and Maintenance:",null,null,null,""]
["     Commissions Paid:",null,null,null,""]
["Depreciation Per US Standards (Estimated):",null,null,null,""]
["     Property Insurance:",null,null,null,""]
["     Legal & Professional (E.g., Village License):",null,null,null,""]
["     Management Fees:",null,null,null,""]
["     Mortgage Interest:",null,null,null,""]
["     Other Mortgage Interest:",null,null,null,""]
["     Other Interest:",null,null,null,""]
["Pest Control:",null,null,null,""]
["Salary or Contractor Salary Paid to Anyone:",null,null,null,""]
["     Repairs (NOT MAJOR IMPROVEMENTS):",null,null,null,""]
["     Supplies (Furniture, Sheets, Paint, etc.):",null,null,null,""]
["     Taxes: Real Estate:",null,null,null,""]
["     Taxes: Personal Property:",null,null,null,""]
["     Taxes: Other:",null,null,null,""]
["     Utilities:",null,null,null,""]
["     Points Paid on Refinance:",null,null,null,""]
["     Association/Society:",null,null,null,""]
["     Other Miscellaneous Expenses:",null,null,null,""]
["Total Expenses:",{"$f":"IF($B12+($B$13*$G$5)+SUM(B$15:B$35)>0,$B12+($B$13*$G$5)+SUM(B$15:B$35),\"\")","v":""},{"$f":"IF(C12+(C13*$G$5*$H$6)+SUM($C14:$D35)>0,C12+(C13*$G$5*$H$6)+SUM($C14:$D35),\"\")","v":""},null,""]
["NET PROFIT/ LOSS:",{"$f":"IF(OR($B$10=\"\",$B$10=0),IF(OR($B$36=\"\",$B$36=0),0,$B$10-$B36),IF($B$10>0,IF($B$36=\"\",$B$10,$B$10-$B$36),\"ERROR\"))","v":0},{"$f":"IF(OR($C$10=\"\",$C$10=0),IF(OR($C$36=\"\",$C$36=0),0,$C$10-$C36),IF($C$10>0,IF($C$36=\"\",$C$10,$C$10-$C$36),\"ERROR\"))","v":0},null,{"$error":"#DIV/0!"}]

{"sheet":"Rental Property 5","index":11,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[[5,2,5,4],[5,5,5,6],[0,1,0,7],[1,1,1,7],[2,1,2,4],[3,2,3,7],[4,6,4,7],[13,2,13,3],[13,5,13,7],[6,2,7,7],[8,0,8,1],[8,2,8,3],[8,5,8,7],[9,2,9,3],[9,5,9,7],[10,0,10,7],[11,2,11,3],[11,5,11,7],[12,2,12,3],[12,5,12,7],[14,2,14,3],[14,5,14,7],[15,2,15,3],[15,5,15,7],[16,2,16,3],[16,5,16,7],[17,2,17,3],[17,5,17,7],[18,2,18,3],[18,5,18,7],[19,2,19,3],[19,5,19,7],[20,2,20,3],[20,5,20,7],[21,2,21,3],[21,5,21,7],[22,2,22,3],[22,5,22,7],[23,2,23,3],[23,5,23,7],[24,2,24,3],[24,5,24,7],[25,2,25,3],[25,5,25,7],[26,2,26,3],[26,5,26,7],[27,2,27,3],[27,5,27,7],[28,2,28,3],[28,5,28,7],[29,2,29,3],[29,5,29,7],[30,2,30,3],[30,5,30,7],[31,2,31,3],[31,5,31,7],[35,2,35,3],[35,5,35,7],[36,2,36,3],[36,5,36,7],[32,2,32,3],[32,5,32,7],[33,2,33,3],[33,5,33,7],[34,2,34,3],[34,5,34,7]]}
[null,"Property 5  -- Annual Income/Exp (Jan 1 - Dec 31)"]
["Address:"]
["Property Type:"]
["Days Rented In Year:"]
["Ownership Percentage of Property:",1,null,null,null,{"$f":"\"Mileage Rate for \"&'General Info - STEP 1'!B3&\":\"","v":"Mileage Rate for :"},0.625]
["Business Use Percentage if less than 100%:",null,"EXAMPLE FOREIGN EXCHANGE RATE IS FOR INDIA. PLEASE PROVIDE APPLICABLE FIGURE.",null,null,"Foreign Currency Exchange Rate to $1 US:"]
["Purchase Price + Net Closing Costs:",null,"Provide HUD or Closing Disclosure statement if newly bought last year; else, provide purchase price + closing costs minus any credits received at closing. If property was NEWLY rented out last year, provide lower of value or original purchase price on date first rented. "]
["Lower of Value or Original Purchase Price:"]
["Provide the following figures without adjusting for your ownership percentage.",null,"In Foreign Currency",null,"Calculated US $ Value, after Allocation","You can specify the explantion or vendor name, if needed below"]
["GROSS TOTAL Rents: ",null,null,null,{"$f":"IF(ISNUMBER($C10),($C10/$H$6)*$B$5,\"\")","v":""}]
["--Expenses--"]
["     Advertising (for e.g., Craigslist, newspaper):",null,null,null,{"$f":"IF(ISNUMBER($C12),($C12/$H$6)*$B$5,\"\")","v":""}]
["  Miles Driven in Year to Property, stores, etc.",null,null,null,{"$f":"IF(ISNUMBER($C13),($C13*$G$5)*$B$5,\"\")","v":""}]
["Airfares to & From Hotel:",null,null,null,{"$f":"IF(ISNUMBER($C14),($C14/$H$6)*$B$5,\"\")","v":""}]
["Hotels stayed at while visiting property:",null,null,null,""]
["     Cleaning and Maintenance:",null,null,null,""]
["     Commissions Paid:",null,null,null,""]
["Depreciation Per US Standards (Estimated):",null,null,null,""]
["     Property Insurance:",null,null,null,""]
["     Legal & Professional (E.g., Village License):",null,null,null,""]
["     Management Fees:",null,null,null,""]
["     Mortgage Interest:",null,null,null,""]
["     Other Mortgage Interest:",null,null,null,""]
["     Other Interest:",null,null,null,""]
["Pest Control:",null,null,null,""]
["Salary or Contractor Salary Paid to Anyone:",null,null,null,""]
["     Repairs (NOT MAJOR IMPROVEMENTS):",null,null,null,""]
["     Supplies (Furniture, Sheets, Paint, etc.):",null,null,null,""]
["     Taxes: Real Estate:",null,null,null,""]
["     Taxes: Personal Property:",null,null,null,""]
["     Taxes: Other:",null,null,null,""]
["     Utilities:",null,null,null,""]
["     Points Paid on Refinance:",null,null,null,""]
["     Association/Society:",null,null,null,""]
["     Other Miscellaneous Expenses:",null,null,null,""]
["Total Expenses:",{"$f":"IF($B12+($B$13*$G$5)+SUM(B$15:B$35)>0,$B12+($B$13*$G$5)+SUM(B$15:B$35),\"\")","v":""},{"$f":"IF(C12+(C13*$G$5*$H$6)+SUM($C14:$D35)>0,C12+(C13*$G$5*$H$6)+SUM($C14:$D35),\"\")","v":""},null,""]
["NET PROFIT/ LOSS:",{"$f":"IF(OR($B$10=\"\",$B$10=0),IF(OR($B$36=\"\",$B$36=0),0,$B$10-$B36),IF($B$10>0,IF($B$36=\"\",$B$10,$B$10-$B$36),\"ERROR\"))","v":0},{"$f":"IF(OR($C$10=\"\",$C$10=0),IF(OR($C$36=\"\",$C$36=0),0,$C$10-$C36),IF($C$10>0,IF($C$36=\"\",$C$10,$C$10-$C$36),\"ERROR\"))","v":0},null,{"$error":"#DIV/0!"}]

{"sheet":"Rental Property 6","index":12,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[[5,2,5,4],[5,5,5,6],[0,1,0,7],[1,1,1,7],[2,1,2,4],[3,2,3,7],[4,6,4,7],[13,2,13,3],[13,5,13,7],[6,2,7,7],[8,0,8,1],[8,2,8,3],[8,5,8,7],[9,2,9,3],[9,5,9,7],[10,0,10,7],[11,2,11,3],[11,5,11,7],[12,2,12,3],[12,5,12,7],[14,2,14,3],[14,5,14,7],[15,2,15,3],[15,5,15,7],[16,2,16,3],[16,5,16,7],[17,2,17,3],[17,5,17,7],[18,2,18,3],[18,5,18,7],[19,2,19,3],[19,5,19,7],[20,2,20,3],[20,5,20,7],[21,2,21,3],[21,5,21,7],[22,2,22,3],[22,5,22,7],[23,2,23,3],[23,5,23,7],[24,2,24,3],[24,5,24,7],[25,2,25,3],[25,5,25,7],[26,2,26,3],[26,5,26,7],[27,2,27,3],[27,5,27,7],[28,2,28,3],[28,5,28,7],[29,2,29,3],[29,5,29,7],[30,2,30,3],[30,5,30,7],[31,2,31,3],[31,5,31,7],[35,2,35,3],[35,5,35,7],[36,2,36,3],[36,5,36,7],[32,2,32,3],[32,5,32,7],[33,2,33,3],[33,5,33,7],[34,2,34,3],[34,5,34,7]]}
[null,"Property 6  -- Annual Income/Exp (Jan 1 - Dec 31)"]
["Address:"]
["Property Type:"]
["Days Rented In Year:"]
["Ownership Percentage of Property:",1,null,null,null,{"$f":"\"Mileage Rate for \"&'General Info - STEP 1'!B3&\":\"","v":"Mileage Rate for :"},0.625]
["Business Use Percentage if less than 100%:",null,"EXAMPLE FOREIGN EXCHANGE RATE IS FOR INDIA. PLEASE PROVIDE APPLICABLE FIGURE.",null,null,"Foreign Currency Exchange Rate to $1 US:"]
["Purchase Price + Net Closing Costs:",null,"Provide HUD or Closing Disclosure statement if newly bought last year; else, provide purchase price + closing costs minus any credits received at closing. If property was NEWLY rented out last year, provide lower of value or original purchase price on date first rented. "]
["Lower of Value or Original Purchase Price:"]
["Provide the following figures without adjusting for your ownership percentage.",null,"In Foreign Currency",null,"Calculated US $ Value, after Allocation","You can specify the explantion or vendor name, if needed below"]
["GROSS TOTAL Rents: ",null,null,null,{"$f":"IF(ISNUMBER($C10),($C10/$H$6)*$B$5,\"\")","v":""}]
["--Expenses--"]
["     Advertising (for e.g., Craigslist, newspaper):",null,null,null,{"$f":"IF(ISNUMBER($C12),($C12/$H$6)*$B$5,\"\")","v":""}]
["  Miles Driven in Year to Property, stores, etc.",null,null,null,{"$f":"IF(ISNUMBER($C13),($C13*$G$5)*$B$5,\"\")","v":""}]
["Airfares to & From Hotel:",null,null,null,{"$f":"IF(ISNUMBER($C14),($C14/$H$6)*$B$5,\"\")","v":""}]
["Hotels stayed at while visiting property:",null,null,null,""]
["     Cleaning and Maintenance:",null,null,null,""]
["     Commissions Paid:",null,null,null,""]
["Depreciation Per US Standards (Estimated):",null,null,null,""]
["     Property Insurance:",null,null,null,""]
["     Legal & Professional (E.g., Village License):",null,null,null,""]
["     Management Fees:",null,null,null,""]
["     Mortgage Interest:",null,null,null,""]
["     Other Mortgage Interest:",null,null,null,""]
["     Other Interest:",null,null,null,""]
["Pest Control:",null,null,null,""]
["Salary or Contractor Salary Paid to Anyone:",null,null,null,""]
["     Repairs (NOT MAJOR IMPROVEMENTS):",null,null,null,""]
["     Supplies (Furniture, Sheets, Paint, etc.):",null,null,null,""]
["     Taxes: Real Estate:",null,null,null,""]
["     Taxes: Personal Property:",null,null,null,""]
["     Taxes: Other:",null,null,null,""]
["     Utilities:",null,null,null,""]
["     Points Paid on Refinance:",null,null,null,""]
["     Association/Society:",null,null,null,""]
["     Other Miscellaneous Expenses:",null,null,null,""]
["Total Expenses:",{"$f":"IF($B12+($B$13*$G$5)+SUM(B$15:B$35)>0,$B12+($B$13*$G$5)+SUM(B$15:B$35),\"\")","v":""},{"$f":"IF(C12+(C13*$G$5*$H$6)+SUM($C14:$D35)>0,C12+(C13*$G$5*$H$6)+SUM($C14:$D35),\"\")","v":""},null,""]
["NET PROFIT/ LOSS:",{"$f":"IF(OR($B$10=\"\",$B$10=0),IF(OR($B$36=\"\",$B$36=0),0,$B$10-$B36),IF($B$10>0,IF($B$36=\"\",$B$10,$B$10-$B$36),\"ERROR\"))","v":0},{"$f":"IF(OR($C$10=\"\",$C$10=0),IF(OR($C$36=\"\",$C$36=0),0,$C$10-$C36),IF($C$10>0,IF($C$36=\"\",$C$10,$C$10-$C$36),\"ERROR\"))","v":0},null,{"$error":"#DIV/0!"}]

{"sheet":"Rental Property 7","index":13,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[[5,2,5,4],[5,5,5,6],[0,1,0,7],[1,1,1,7],[2,1,2,4],[3,2,3,7],[4,6,4,7],[13,2,13,3],[13,5,13,7],[6,2,7,7],[8,0,8,1],[8,2,8,3],[8,5,8,7],[9,2,9,3],[9,5,9,7],[10,0,10,7],[11,2,11,3],[11,5,11,7],[12,2,12,3],[12,5,12,7],[14,2,14,3],[14,5,14,7],[15,2,15,3],[15,5,15,7],[16,2,16,3],[16,5,16,7],[17,2,17,3],[17,5,17,7],[18,2,18,3],[18,5,18,7],[19,2,19,3],[19,5,19,7],[20,2,20,3],[20,5,20,7],[21,2,21,3],[21,5,21,7],[22,2,22,3],[22,5,22,7],[23,2,23,3],[23,5,23,7],[24,2,24,3],[24,5,24,7],[25,2,25,3],[25,5,25,7],[26,2,26,3],[26,5,26,7],[27,2,27,3],[27,5,27,7],[28,2,28,3],[28,5,28,7],[29,2,29,3],[29,5,29,7],[30,2,30,3],[30,5,30,7],[31,2,31,3],[31,5,31,7],[35,2,35,3],[35,5,35,7],[36,2,36,3],[36,5,36,7],[32,2,32,3],[32,5,32,7],[33,2,33,3],[33,5,33,7],[34,2,34,3],[34,5,34,7]]}
[null,"Property 7  -- Annual Income/Exp (Jan 1 - Dec 31)"]
["Address:"]
["Property Type:"]
["Days Rented In Year:"]
["Ownership Percentage of Property:",1,null,null,null,{"$f":"\"Mileage Rate for \"&'General Info - STEP 1'!B3&\":\"","v":"Mileage Rate for :"},0.625]
["Business Use Percentage if less than 100%:",null,"EXAMPLE FOREIGN EXCHANGE RATE IS FOR INDIA. PLEASE PROVIDE APPLICABLE FIGURE.",null,null,"Foreign Currency Exchange Rate to $1 US:"]
["Purchase Price + Net Closing Costs:",null,"Provide HUD or Closing Disclosure statement if newly bought last year; else, provide purchase price + closing costs minus any credits received at closing. If property was NEWLY rented out last year, provide lower of value or original purchase price on date first rented. "]
["Lower of Value or Original Purchase Price:"]
["Provide the following figures without adjusting for your ownership percentage.",null,"In Foreign Currency",null,"Calculated US $ Value, after Allocation","You can specify the explantion or vendor name, if needed below"]
["GROSS TOTAL Rents: ",null,null,null,{"$f":"IF(ISNUMBER($C10),($C10/$H$6)*$B$5,\"\")","v":""}]
["--Expenses--"]
["     Advertising (for e.g., Craigslist, newspaper):",null,null,null,{"$f":"IF(ISNUMBER($C12),($C12/$H$6)*$B$5,\"\")","v":""}]
["  Miles Driven in Year to Property, stores, etc.",null,null,null,{"$f":"IF(ISNUMBER($C13),($C13*$G$5)*$B$5,\"\")","v":""}]
["Airfares to & From Hotel:",null,null,null,{"$f":"IF(ISNUMBER($C14),($C14/$H$6)*$B$5,\"\")","v":""}]
["Hotels stayed at while visiting property:",null,null,null,""]
["     Cleaning and Maintenance:",null,null,null,""]
["     Commissions Paid:",null,null,null,""]
["Depreciation Per US Standards (Estimated):",null,null,null,""]
["     Property Insurance:",null,null,null,""]
["     Legal & Professional (E.g., Village License):",null,null,null,""]
["     Management Fees:",null,null,null,""]
["     Mortgage Interest:",null,null,null,""]
["     Other Mortgage Interest:",null,null,null,""]
["     Other Interest:",null,null,null,""]
["Pest Control:",null,null,null,""]
["Salary or Contractor Salary Paid to Anyone:",null,null,null,""]
["     Repairs (NOT MAJOR IMPROVEMENTS):",null,null,null,""]
["     Supplies (Furniture, Sheets, Paint, etc.):",null,null,null,""]
["     Taxes: Real Estate:",null,null,null,""]
["     Taxes: Personal Property:",null,null,null,""]
["     Taxes: Other:",null,null,null,""]
["     Utilities:",null,null,null,""]
["     Points Paid on Refinance:",null,null,null,""]
["     Association/Society:",null,null,null,""]
["     Other Miscellaneous Expenses:",null,null,null,""]
["Total Expenses:",{"$f":"IF($B12+($B$13*$G$5)+SUM(B$15:B$35)>0,$B12+($B$13*$G$5)+SUM(B$15:B$35),\"\")","v":""},{"$f":"IF(C12+(C13*$G$5*$H$6)+SUM($C14:$D35)>0,C12+(C13*$G$5*$H$6)+SUM($C14:$D35),\"\")","v":""},null,""]
["NET PROFIT/ LOSS:",{"$f":"IF(OR($B$10=\"\",$B$10=0),IF(OR($B$36=\"\",$B$36=0),0,$B$10-$B36),IF($B$10>0,IF($B$36=\"\",$B$10,$B$10-$B$36),\"ERROR\"))","v":0},{"$f":"IF(OR($C$10=\"\",$C$10=0),IF(OR($C$36=\"\",$C$36=0),0,$C$10-$C36),IF($C$10>0,IF($C$36=\"\",$C$10,$C$10-$C$36),\"ERROR\"))","v":0},null,{"$error":"#DIV/0!"}]

{"sheet":"Rental Property 8","index":14,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[[5,2,5,4],[5,5,5,6],[0,1,0,7],[1,1,1,7],[2,1,2,4],[3,2,3,7],[4,6,4,7],[13,2,13,3],[13,5,13,7],[6,2,7,7],[8,0,8,1],[8,2,8,3],[8,5,8,7],[9,2,9,3],[9,5,9,7],[10,0,10,7],[11,2,11,3],[11,5,11,7],[12,2,12,3],[12,5,12,7],[14,2,14,3],[14,5,14,7],[15,2,15,3],[15,5,15,7],[16,2,16,3],[16,5,16,7],[17,2,17,3],[17,5,17,7],[18,2,18,3],[18,5,18,7],[19,2,19,3],[19,5,19,7],[20,2,20,3],[20,5,20,7],[21,2,21,3],[21,5,21,7],[22,2,22,3],[22,5,22,7],[23,2,23,3],[23,5,23,7],[24,2,24,3],[24,5,24,7],[25,2,25,3],[25,5,25,7],[26,2,26,3],[26,5,26,7],[27,2,27,3],[27,5,27,7],[28,2,28,3],[28,5,28,7],[29,2,29,3],[29,5,29,7],[30,2,30,3],[30,5,30,7],[31,2,31,3],[31,5,31,7],[35,2,35,3],[35,5,35,7],[36,2,36,3],[36,5,36,7],[32,2,32,3],[32,5,32,7],[33,2,33,3],[33,5,33,7],[34,2,34,3],[34,5,34,7]]}
[null,"Property 8  -- Annual Income/Exp (Jan 1 - Dec 31)"]
["Address:"]
["Property Type:"]
["Days Rented In Year:"]
["Ownership Percentage of Property:",1,null,null,null,{"$f":"\"Mileage Rate for \"&'General Info - STEP 1'!B3&\":\"","v":"Mileage Rate for :"},0.625]
["Business Use Percentage if less than 100%:",null,"EXAMPLE FOREIGN EXCHANGE RATE IS FOR INDIA. PLEASE PROVIDE APPLICABLE FIGURE.",null,null,"Foreign Currency Exchange Rate to $1 US:"]
["Purchase Price + Net Closing Costs:",null,"Provide HUD or Closing Disclosure statement if newly bought last year; else, provide purchase price + closing costs minus any credits received at closing. If property was NEWLY rented out last year, provide lower of value or original purchase price on date first rented. "]
["Lower of Value or Original Purchase Price:"]
["Provide the following figures without adjusting for your ownership percentage.",null,"In Foreign Currency",null,"Calculated US $ Value, after Allocation","You can specify the explantion or vendor name, if needed below"]
["GROSS TOTAL Rents: ",null,null,null,{"$f":"IF(ISNUMBER($C10),($C10/$H$6)*$B$5,\"\")","v":""}]
["--Expenses--"]
["     Advertising (for e.g., Craigslist, newspaper):",null,null,null,{"$f":"IF(ISNUMBER($C12),($C12/$H$6)*$B$5,\"\")","v":""}]
["  Miles Driven in Year to Property, stores, etc.",null,null,null,{"$f":"IF(ISNUMBER($C13),($C13*$G$5)*$B$5,\"\")","v":""}]
["Airfares to & From Hotel:",null,null,null,{"$f":"IF(ISNUMBER($C14),($C14/$H$6)*$B$5,\"\")","v":""}]
["Hotels stayed at while visiting property:",null,null,null,""]
["     Cleaning and Maintenance:",null,null,null,""]
["     Commissions Paid:",null,null,null,""]
["Depreciation Per US Standards (Estimated):",null,null,null,""]
["     Property Insurance:",null,null,null,""]
["     Legal & Professional (E.g., Village License):",null,null,null,""]
["     Management Fees:",null,null,null,""]
["     Mortgage Interest:",null,null,null,""]
["     Other Mortgage Interest:",null,null,null,""]
["     Other Interest:",null,null,null,""]
["Pest Control:",null,null,null,""]
["Salary or Contractor Salary Paid to Anyone:",null,null,null,""]
["     Repairs (NOT MAJOR IMPROVEMENTS):",null,null,null,""]
["     Supplies (Furniture, Sheets, Paint, etc.):",null,null,null,""]
["     Taxes: Real Estate:",null,null,null,""]
["     Taxes: Personal Property:",null,null,null,""]
["     Taxes: Other:",null,null,null,""]
["     Utilities:",null,null,null,""]
["     Points Paid on Refinance:",null,null,null,""]
["     Association/Society:",null,null,null,""]
["     Other Miscellaneous Expenses:",null,null,null,""]
["Total Expenses:",{"$f":"IF($B12+($B$13*$G$5)+SUM(B$15:B$35)>0,$B12+($B$13*$G$5)+SUM(B$15:B$35),\"\")","v":""},{"$f":"IF(C12+(C13*$G$5*$H$6)+SUM($C14:$D35)>0,C12+(C13*$G$5*$H$6)+SUM($C14:$D35),\"\")","v":""},null,""]
["NET PROFIT/ LOSS:",{"$f":"IF(OR($B$10=\"\",$B$10=0),IF(OR($B$36=\"\",$B$36=0),0,$B$10-$B36),IF($B$10>0,IF($B$36=\"\",$B$10,$B$10-$B$36),\"ERROR\"))","v":0},{"$f":"IF(OR($C$10=\"\",$C$10=0),IF(OR($C$36=\"\",$C$36=0),0,$C$10-$C36),IF($C$10>0,IF($C$36=\"\",$C$10,$C$10-$C$36),\"ERROR\"))","v":0},null,{"$error":"#DIV/0!"}]

{"sheet":"1120C Import","index":15,"n_rows":403,"n_cols":3,"rows_kept":403,"cut":false,"hidden":true,"merged":[]}
["Tax Code","Description","Form, Line #"]
[100,"Gross receipts","1120, L1a"]
[101,"Returns and allowances","1120, L1b"]
[105,"Non-US interest","1120, L5"]
[106,"US interest","1120, L5"]
[107,"Dividends domestic 50% deduct","Sch C, L1"]
[108,"Dividends domestic 65% deduct","Sch C, L2"]
[109,"Dividends debt-financed stock","Sch C, L3"]
[110,"Preferred stk pub util 23.3%","Sch C, L4"]
[111,"Preferred stk pub util 26.7%","Sch C, L5"]
[112,"Dividends foreign 50% deduct","Sch C, L6"]
[113,"Dividends foreign 65% deduct","Sch C, L7"]
[114,"Owned foreign subs 100% deduct","Sch C, L8"]
[115,"Domestic corp; SBIC 100%","Sch C, L10"]
[116,"Div from affiliated group 100%","Sch C, L11"]
[118,"Dividends from foreign corps","Sch C, L13"]
[120,"Gross-up on foreign taxes","Sch C, L15"]
[121,"IC-DISC & former DISC dividend","Sch C, L16"]
[122,"Other dividends","Sch C, L17"]
[123,"Div from certain FSCs 100% ded","Sch C, L12"]
[125,"Capital gain distribution","Sch D, L14"]
[130,"Gross rents","1120, L6"]
[131,"Gross royalties","1120, L7"]
[140,"Other income","1120, L10"]
[141,"State tax refunds","1120, L10"]
["142 *","GST-Cap gain net inc (Sch D)","1120C, L8"]
["143 *","GST-Net ord gain(loss) 4797 II","1120C, L9"]
["144 *","GST-COGS:Beginning inventory","Sch A, L1"]
["145 *","GST-Domestic prod activ deduc","1120C, L25"]
["146 *","GST-Excess cap loss over gain","Sch M-1, L3"]
["147 *","GST-Federal tax provision","1120C, L17"]
[150,"Meals subject to 50% limit","Rent, var"]
[151,"Section 250 deduction","Sch C, L22c"]
[152,"Global intang low-taxed Income","Sch C, L17"]
[153,"Div 10% Foreign corp","Sch C, L13"]
[154,"Meals subject to 50% limit","4835, L30"]
[155,"Meals subject to 50% limit","1120, L26"]
[200,"Compensation of officers","1125-E, L1"]
[201,"Salaries and wages","1120, L13"]
[202,"Repairs","1120, L14"]
[203,"Bad debts","1120, L15"]
[204,"Rents","1120, L16"]
[205,"Taxes","1120, L17"]
[206,"Interest","1120, L18"]
[207,"Contributions","1120, L19"]
[208,"Book depr-other than COGS","Sch M-1, var"]
[209,"Page 1 depletion – book","1120, L21"]
[210,"Advertising","1120, L22"]
[211,"Pension, profit-sharing plan","1120, L23"]
[212,"Employee benefit programs","1120, L24"]
[213,"Other deductions","1120, L26"]
[214,"Meals fully deductible","1120, L26"]
[215,"Total book amortization","1120, L26"]
[216,"Meals (DOT)","1120, L26"]
[217,"Pg 1 depln other than oil/gas","1120, L21"]
[218,"Org / start-up book expense","Sch M-1, L5"]
[219,"Pension, profit-sharing accr","1120, L23"]
[225,"Market studies (DISC)","Sch E, L1a"]
[226,"Sales commissions (DISC)","Sch E, L1f"]
[227,"Warehousing (DISC)","Sch E, L1g"]
[228,"Freight (DISC)","Sch E, L1h"]
[229,"Freight insurance (DISC)","Sch E, L2f"]
[230,"Meals & ent export exp (DISC)","Sch E, L1m"]
[231,"Other non export ded (DISC)","Sch E, L2g"]
[234,"Meals subject to 50% limit","1125-A, L4"]
[237,"Trustee / administrator fees","1120SF, L7"]
[238,"Accounting and legal services","1120SF, L9"]
[240,"Claim processing expenses","1120SF, L10"]
[241,"Meals subject to 50% limit","Sch F, L32"]
[275,"Purchases","1125-A, L2"]
[276,"Cost of labor","1125-A, L3"]
[277,"Additional section 263A costs","1125-A, L4"]
[278,"Other costs","1125-A, L5"]
[280,"Inventory end of year","1125-A, L7"]
[281,"Meals fully deductible","1125-A, L4"]
[282,"Meals (DOT)","1125-A, L4"]
[283,"Book depreciation-COGS","Sch M-1, var"]
[284,"Qual per-unit cert (Co-op)","1125-A, L5"]
[285,"Money or other prop (Co-op)","1125-A, L5"]
[286,"Nonqual per-unit cert (Co-op)","1125-A, L5"]
[301,"Estimated tax payments","Sch J, L14"]
[366,"Dividends, distributions","PC, Sch G, L1"]
[367,"Expenses paid","PC, Sch G, L3"]
[368,"Mutual fire ins premiums","PC, Sch A, L8"]
[369,"Special income/deduction accts","PC, Sch A, L9"]
[370,"Inc from protect against loss","PC, Sch A, L10"]
[371,"Mutual interinsurers-decrease","PC, Sch A, L11"]
[372,"Inc exp related to tax-exempt","PC, Sch A, L20"]
[373,"Dividends to policyholders","PC, Sch A, L29"]
[374,"Mutual interinsurers-increase","PC, Sch A, L30"]
[375,"Amounts cap under Sec 848","PC, Sch A, L32"]
[376,"Deduction of spec income","PC, Sch A, L34"]
[377,"Gross inc trade/business","PC, Sch B, L5"]
[378,"Income from leases","PC, Sch B, L6"]
[379,"Trade/business deductions","PC, Sch B, L13"]
[380,"Investment expenses","PC, Sch B, L17"]
[381,"Net premiums written","PC, Sch E, L1"]
[382,"Losses paid during year","PC, Sch F, L1"]
[383,"Tax-exempt interest","PC, Sch F, L9"]
[384,"Health care claims incurred","PC, Sch H, L1"]
[385,"Expenses incurred with claims","PC, Sch H, L2"]
[386,"Insurance liabilities","PC, Sch L, L18"]
[400,"Cash","Sch L, L1"]
[401,"Accounts receivable","Sch L, L2a"]
[402,"Less allowance for bad debts","Sch L, L2b"]
[403,"Inventories","Sch L, L3"]
[404,"US government obligations","Sch L, L4"]
[405,"Tax-exempt securities","Sch L, L5"]
[406,"Other current assets","Sch L, L6"]
[407,"Prepaid federal income tax","Sch L, L6"]
[408,"Prepaid state tax","Sch L, L6"]
[409,"Loans to stockholders","Sch L, L7"]
[410,"Prepaid city tax","Sch L, L6"]
[415,"Mortgage and real estate loans","Sch L, L8"]
[416,"Other investments","Sch L, L9"]
[425,"Buildings, other deprec assets","Sch L, L10a"]
[426,"Less accumulated depreciation","Sch L, L10b"]
[427,"Depletable assets","Sch L, L11a"]
[428,"Less accumulated depletion","Sch L, L11b"]
[429,"Land (net of any amortization)","Sch L, L12"]
[430,"Intangible assets","Sch L, L13a"]
[431,"Less accumulated amortization","Sch L, L13b"]
[432,"Other assets","Sch L, L14"]
[433,"Assets held in trust (1120-F)","Sch L, L14"]
[434,"Temporary investments (DISC)","Sch L, L1a"]
[435,"Funds waiting investmnt (DISC)","Sch L, L1b"]
[436,"Bank obligations (DISC)","Sch L, L1c"]
[437,"Other export property (DISC)","Sch L, L1e"]
[438,"Producer's loans (DISC)","Sch L, L1f"]
[439,"Rel fgn export invest (DISC)","Sch L, L1g"]
[440,"Accounts payable","Sch L, L16"]
[441,"Mortg, notes, bonds pay < 1 yr","Sch L, L17"]
[442,"Other current liabilities","Sch L, L18"]
[443,"Federal income tax payable","Sch L, L18"]
[444,"State tax payable","Sch L, L18"]
[445,"Loans from stockholders","Sch L, L19"]
[446,"City tax payable","Sch L, L18"]
[447,"Other qual export asset (DISC)","Sch L, L1i"]
[448,"Nonqualified assets (DISC)","Sch L, L2"]
[449,"State & local govt oblig (SF)","Sch L, L3"]
[450,"Mortg, notes, bonds pay => 1 yr","Sch L, L20"]
[451,"Other liabilities","Sch L, L21"]
[452,"Liabilities held in trust (1120-F)","Sch L, L23"]
[453,"Fund balance (SF)","Sch L, L8"]
[454,"Other E&P (DISC)","Sch L, L10"]
[455,"Previously taxed income (DISC)","Sch L, L11"]
[456,"Accum pre-1985 DISC income","Sch L, L12"]
[457,"Accumulated IC-DISC income","Sch L, L13"]
[465,"Capital stock – preferred","Sch L, L22a"]
[466,"Capital stock – common","Sch L, L22b"]
[467,"Paid-in or capital surplus","Sch L, L23"]
[468,"Retained earnings-Appropriated","Sch L, L24"]
[469,"Retained earnings-Unappropriat","Sch L, L25"]
[470,"Adjustments to S/Hs’ equity","Sch L, L26"]
[471,"Less cost of treasury stock","Sch L, L27"]
[473,"Patronage div alloc (Co-op)","Sch L, L22"]
[474,"Per-unit retain alloc (Co-op)","Sch L, L23"]
[475,"Other E&P increases (DISC)","Sch M-2, L2"]
[476,"Other E&P decreases (DISC)","Sch M-2, L6"]
[477,"PTI  increases (DISC)","Sch M-3, L3"]
[478,"PTI decreases (DISC)","Sch M-3, L7"]
[479,"Fines and penalties","Sch M-1, L5"]
[480,"Federal income tax","Sch M-1, L2"]
[481,"Taxable income not on books","Sch M-1, L4"]
[482,"Book expenses not on return","Sch M-1, L5"]
[483,"Accum IC-DISC income increases","Sch M-4, L2"]
[484,"Exps related to tax exempt inc","Sch M-1, L5"]
[485,"Officer life ins. Premiums","Sch M-1, L5"]
[486,"Income on books not on return","Sch M-1, L7"]
[487,"Tax-exempt interest","Sch M-1, L7"]
[488,"Cash surrender – officer life","Sch M-1, L7"]
[489,"4797 gain/loss – book","Sch M-1, var"]
[490,"Deductions on return not book","Sch M-1, L8"]
[491,"Other increases","Sch M-2, L3"]
[492,"Cash distributions","Sch M-2, L5a"]
[493,"Stock distributions","Sch M-2, L5d"]
[494,"Property distributions","Sch M-2, L5c"]
[495,"Other decreases","Sch M-2, L6"]
[496,"Accum IC-DISC income decreases","Sch M-4, L8"]
[502,"Gross rental income","Rent, var"]
[503,"Advertising","Rent, var"]
[504,"Auto and travel","Rent, var"]
[505,"Cleaning and maintenance","Rent, var"]
[506,"Commissions","Rent, var"]
[507,"Insurance","Rent, var"]
[508,"Legal and other prof fees","Rent, var"]
[509,"Interest","Rent, var"]
[510,"Repairs","Rent, var"]
[511,"Taxes","Rent, var"]
[512,"Utilities","Rent, var"]
[513,"Wages and salaries","Rent, var"]
[515,"Other expenses","Rent, var"]
[516,"Direct fgn sales-unrel pur","Sch B, L1aic"]
[517,"Direct fgn sales-unrel pur oth","Sch B, L1aid"]
[518,"Fgn sales-unrel pur","Sch B, L1aiic"]
[519,"Fgn sales-unrel pur other","Sch B, L1aiid"]
[520,"Sales US persons-unrel pur","Sch B, L1aiiic"]
[521,"Sales US persons-unrel pur oth","Sch B, L1aiiid"]
[522,"Sale unrel DISC-unrel pur","Sch B, L1aivc"]
[523,"Sale unrel DISC-unrel pur oth","Sch B, L1aivd"]
[524,"Direct fgn sales-rel pur","Sch B, L1bic"]
[525,"Direct fgn sales-rel pur oth","Sch B, L1bid"]
[526,"Sales US persons-rel pur","Sch B, L1biic"]
[527,"Sales US persons-rel pur oth","Sch B, L1biid"]
[528,"Oth qual export-leasing","Sch B, L2a(c)"]
[529,"Oth qual export-leasing oth","Sch B, L2a(d)"]
[530,"Oth qual export-services","Sch B, L2b(c)"]
[531,"Oth qual export-services oth","Sch B, L2b(d)"]
[532,"Oth qual exp-engineer svc","Sch B, L2c(c)"]
[533,"Oth qual exp-engineer svc oth","Sch B, L2c(d)"]
[534,"Oth qual export-mgt svc","Sch B, L2d(c)"]
[535,"Oth qual export-mgt svc oth","Sch B, L2d(d)"]
[536,"Interest on producer's loan","Sch B, L2f(d)"]
[537,"Oth qualified exp receipts","Sch B, L2j(c)"]
[538,"Oth qualified exp receipts-oth","Sch B, L2j(d)"]
[539,"Nonqual rec-use in US","Sch B, L3a(c)"]
[540,"Nonqual rec-use in US oth","Sch B, L3a(d)"]
[541,"Nonqual rec-US subsidized","Sch B, L3b(c)"]
[542,"Nonqual rec-US subsidized oth","Sch B, L3b(d)"]
[543,"Nonqual rec-US govt use","Sch B, L3c(c)"]
[544,"Nonqual rec-US govt use oth","Sch B, L3c(d)"]
[545,"Nonqual rec-IC DISC sale","Sch B, L3d(c)"]
[546,"Nonqual rec-IC-DISC sale oth","Sch B, L3d(d)"]
[547,"Other nonqual receipts","Sch B, L3g(c)"]
[548,"Other nonqual receipts-oth","Sch B, L3g(d)"]
[582,"Gross royalties","Rent, var"]
[585,"Meals fully deductible","Rent, var"]
[586,"Meals (DOT)","Rent, var"]
[588,"Depletion","Rent, var"]
[590,"Other income","Rent, var"]
[601,"Sales of items bought","Sch F, var"]
[602,"Cost/basis of items bought","Sch F, L1b"]
[604,"Sales of items you raised","Sch F, L2"]
[605,"Total cooperative distribution","Sch F, var"]
[606,"Agricultural program payments","Sch F, var"]
[607,"CCC loans reported under elec","Sch F, var"]
[608,"Crop ins proceeds","Sch F, var"]
[609,"Custom hire income","Sch F, var"]
[610,"Other income","Sch F, var"]
[612,"Car and truck expenses","Sch F, L10"]
[613,"Chemicals","Sch F, L11"]
[614,"Conservation expenses","Sch F, L12"]
[615,"Custom hire","Sch F, L13"]
[617,"Employee benefit programs","Sch F, L15"]
[618,"Feed purchased","Sch F, L16"]
[619,"Fertilizers and lime","Sch F, L17"]
[620,"Freight and trucking","Sch F, L18"]
[621,"Gasoline","Sch F, L19"]
[622,"Insurance","Sch F, L20"]
[623,"Interest - financial inst","Sch F, L21a"]
[624,"Labor hired","Sch F, L22"]
[625,"Pension and profit sharing","Sch F, L23"]
[626,"Rent - machinery","Sch F, L24a"]
[627,"Repairs and maintenance","Sch F, L25"]
[628,"Seeds and plants","Sch F, L26"]
[629,"Storage and warehousing","Sch F, L27"]
[630,"Supplies","Sch F, L28"]
[631,"Taxes","Sch F, L29"]
[632,"Utilities","Sch F, L30"]
[633,"Veterinary fees","Sch F, L31"]
[634,"Other expenses","Sch F, L32"]
[646,"Inventory - beg of year","Sch F, L45"]
[647,"Cost of items for resale","Sch F, L46"]
[649,"Inventory - end of year","Sch F, L48"]
[650,"Tax-exempt interest income","8916A PII, L1a"]
[651,"Interest inc from hybrid sec","8916A PII, L2a"]
[652,"Sale/lease interest income","8916A PII, L3a"]
[653,"Interco int inc outside tax gr","8916A PII, L4a"]
[654,"Interco int inc tax affil gr","8916A PII, L4b"]
[655,"Other interest income","8916A PII, L5a"]
[668,"Interest exp from hybrid sec","8916A PIII, L1a"]
[669,"Lease/purchase interest exp","8916A PIII, L2a"]
[670,"Interco int exp outside tax gr","8916A PIII, L3a"]
[671,"Interco int exp tax affil gr","8916A PIII, L3b"]
[672,"Other interest expense","8916A PIII, L4a"]
[683,"Interest expense - other","Sch F, L21b"]
[684,"Meals fully deductible","Sch F, L32"]
[685,"Preproductive expenses","Sch F, L32"]
[686,"Rental expense - other","Sch F, L24b"]
[687,"CCC loans forfeited","Sch F, var"]
[688,"Crop insurance deferred","Sch F, L6d"]
[689,"Meals (DOT)","Sch F, L32"]
[696,"Sec 263A: Parachute payments","8916A, L2da"]
[701,"Income from production","4835, L1"]
[702,"Distr rec from cooperatives","4835, L2a"]
[703,"Agricultural program payments","4835, L3a"]
[704,"CCC loans reported under elec","4835, L4a"]
[705,"Crop ins proceeds - current yr","4835, L5a"]
[706,"Other income","4835, L6"]
[708,"Car/truck expense","4835, L8"]
[709,"Chemicals","4835, L9"]
[710,"Conservation","4835, L10"]
[711,"Custom hire","4835, L11"]
[713,"Employee benefits","4835, L13"]
[714,"Feed purchased","4835, L14"]
[715,"Fertilizers and lime","4835, L15"]
[716,"Freight and trucking","4835, L16"]
[717,"Gasoline","4835, L17"]
[718,"Insurance","4835, L18"]
[719,"Interest - financial","4835, L19a"]
[720,"Labor hired","4835, L20"]
[721,"Pension & profit sharing","4835, L21"]
[722,"Rent - machinery","4835, L22a"]
[723,"Repairs","4835, L23"]
[724,"Seeds","4835, L24"]
[725,"Storage","4835, L25"]
[726,"Supplies","4835, L26"]
[727,"Taxes","4835, L27"]
[728,"Utilities","4835, L28"]
[729,"Veterinary","4835, L29"]
[730,"Other expenses","4835, L30"]
[731,"Amts attrib cost flow assump","8916A, L1a"]
[732,"Sec 263A: Stock option exp","8916A, L2aa"]
[733,"Sec 263A: Oth eq based comp","8916A, L2ba"]
[734,"Sec 263A: Meals & entertain","8916A, L2ca"]
[735,"Inc(loss) eqty meth fgn corp","Sch M-3 PII, L1a"]
[736,"Gross fgn div not prev taxed","Sch M-3 PII, L2a"]
[737,"Subpart F, PFIC, QEF income","Sch M-3 PII, L3a"]
[738,"Section 78 gross-up","Sch M-3 PII, L4a"]
[739,"Gross fgn dist prev taxed","Sch M-3 PII, L5a"]
[740,"Inc/loss eqty meth US corp","Sch M-3 PII, L6a"]
[741,"US div not elimin in consol","Sch M-3 PII, L7a"]
[742,"Minor int for include corp","Sch M-3 PII, L8a"]
[743,"Inc/loss from US partnerships","Sch M-3 PII, L9a"]
[744,"Inc/loss from fgn partnerships","Sch M-3 PII, L10a"]
[745,"Inc/loss from other P/T","Sch M-3 PII, L11a"]
[746,"Items related to report trans","Sch M-3 PII, L12a"]
[748,"Accrual to cash adjustment","Sch M-3 PII, L14a"]
[749,"Hedging transactions","Sch M-3 PII, L15a"]
[750,"Mark-to-market income/loss","Sch M-3 PII, L16a"]
[752,"Sale versus lease","M3 PII, L18a"]
[753,"Section 481(a) adjustments","M3 PII, L19a"]
[754,"Unearned/deferred revenue","M3 PII, L20a"]
[755,"Income rec long-term contracts","M3 PII, L21a"]
[756,"OID and imputed interest","M3 PII, L22a"]
[757,"Inc stmt gain/loss on assets","M3 PII, L23aa"]
[758,"Capital gains from Sch D","M3 PII, L23ba"]
[759,"Capital losses from Sch D","M3 PII, L23ca"]
[760,"Gain/loss on Form 4797","M3 PII, L23da"]
[761,"Abandonment losses","M3 PII, L23ea"]
[762,"Worthless stock losses","M3 PII, L23fa"]
[763,"Other gain/loss on assets","M3 PII, L23ga"]
[764,"Disall cap loss excess gain","M3 PII, L24a"]
[765,"Utilize capital loss C/F","M3 PII, L24a"]
[766,"Other inc/loss with difference","M3 PII, L25a"]
[767,"Other items w/ no differences","M3 PII, L28a"]
[768,"Sec 263A: Comp w/ 162 limit","8916A, L2ea"]
[769,"Sec 263A: Pension & profit sh","8916A, L2fa"]
[770,"Sec 263A: Oth post-retire bene","8916A, L2ga"]
[771,"Sec 263A: Deferred comp","8916A, L2ha"]
[773,"Sec 263A: Amortization","8916A, L2ja"]
[774,"Sec 263A: Depletion","8916A, L2ka"]
[775,"Sec 263A: Depreciation","8916A, L2la"]
[776,"Sec 263A: Corp life ins premium","8916A, L2ma"]
[777,"Other section 263A costs","8916A, L2na"]
[778,"Inventory shrinkage accruals","8916A, L3a"]
[780,"Meals fully deductible","4835, L30"]
[781,"Preproductive expenses","4835, L30"]
[782,"Rent expense - other","4835, L22b"]
[783,"LCM write-downs","8916A, L5a"]
[784,"CCC loans forf/repaid w/ cert","4835, L4b"]
[785,"Crop ins amt def from prior yr","4835, L5d"]
[786,"Meals (DOT)","4835, L30"]
[788,"Other items w/ differences","8916A, L6a"]
[789,"Interest expense - other","4835, L19b"]
[790,"Other items w/ no differences","8916A, L7a"]
[810,"Research & development costs","M3 PIII, L35a"]
[811,"US current income tax expense","M3 PIII, L1a"]
[812,"US deferred income tax expense","M3 PIII, L2a"]
[813,"State/local current tax exp","M3 PIII, L3a"]
[814,"State/local defer tax exp","M3 PIII, L4a"]
[815,"Foreign current inc tax exp","M3 PIII, L5a"]
[816,"Foreign deferred inc tax exp","M3 PIII, L6a"]
[817,"Foreign withholding taxes","M3 PIII, L7a"]
[818,"Section 188 exclusion","M3 PIII, L36a"]
[819,"Stock options expense","M3 PIII, L9a"]
[820,"Other equity-based comp","M3 PIII, L10a"]
[821,"Meals subject to 50% limit","M3 PIII, L11a"]
[822,"Fines and penalties","M3 PIII, L12a"]
[823,"Judgments, damages, awards","M3 PIII, L13a"]
[824,"Parachute payments","M3 PIII, L14a"]
[825,"Comp with sec 163(m) limit","M3 PIII, L15a"]
[826,"Pension and profit-sharing","M3 PIII, L16a"]
[827,"Other post-retirement benefits","M3 PIII, L17a"]
[828,"Deferred compensation","M3 PIII, L18a"]
[829,"Char contr cash/tang property","M3 PIII, L19a"]
[830,"Char contr intangible property","M3 PIII, L20a"]
[831,"Char contr limitation/carryfwd","M3 PIII, L21a"]
[832,"Domestic prod activities ded","M3 PIII, L22a"]
[833,"Acq/reorg invest bank fees","M3 PIII, L23a"]
[834,"Acq/reorg acctg/legal fees","M3 PIII, L24a"]
[835,"Acq/reorg other costs","M3 PIII, L25a"]
[836,"Amort/impairment of goodwill","M3 PIII, L26a"]
[837,"Amort of acq, reorg startup","M3 PIII, L27a"]
[838,"Other amort or impairment","M3 PIII, L28a"]
[840,"Depletion","M3 PIII, L30a"]
[841,"Depreciation","M3 PIII, L31a"]
[842,"Bad debt expense","M3 PIII, L32a"]
[843,"Corp owned life insurance","M3 PIII, L33a"]
[844,"Purchase versus lease","M3 PIII, L34a"]
[845,"Other exp items w/differences","M3 PIll, L38a"]
[855,"Nondeductible entertainment","Sch M1, L3"]
[943,"Sec 162(r) FDIC premiums","M3 PIII, L37a"]

{"sheet":"Apport Info Property","index":16,"n_rows":52,"n_cols":3,"rows_kept":52,"cut":false,"hidden":true,"merged":[[49,0,51,0],[0,0,0,2]]}
["                                   "]
[]
["Property Component","Everywhere","Other"]
["54b9c2ab-2d9f-4c1a-8ab8-1482987e57de"]
["Buildings - BOY",{"$f":"SUM(C5)","v":0}]
["Buildings - EOY",0]
["  Less: Accumulated Depreciation - BOY",0]
["  Less: Accumulated Depreciation - EOY",0]
["Leasehold Improvements - BOY",0]
["Leasehold Improvements - EOY",0]
["  Less: Accumulated Depreciation - BOY",0]
["  Less: Accumulated Depreciation - EOY",0]
["Machinery - BOY",0]
["Machinery - EOY",0]
["  Less: Accumulated Depreciation - BOY",0]
["  Less: Accumulated Depreciation - EOY",0]
["Equipment - BOY",0]
["Equipment - EOY",0]
["  Less: Accumulated Depreciation - BOY",0]
["  Less: Accumulated Depreciation - EOY",0]
["Transportation/Delivery Equipment - BOY",0]
["Transportation/Delivery Equipment - EOY",0]
["  Less: Accumulated Depreciation - BOY",0]
["  Less: Accumulated Depreciation - EOY",0]
["Furniture and Fixtures - BOY",0]
["Furniture and Fixtures - EOY",0]
["  Less: Accumulated Depreciation - BOY",0]
["  Less: Accumulated Depreciation - EOY",0]
["Construction in Progress - BOY",0]
["Construction in Progress - EOY",0]
["Other Tangible Assets - BOY",0]
["Other Tangible Assets - EOY",0]
["  Less: Accumulated Depreciation - BOY",0]
["  Less: Accumulated Depreciation - EOY",0]
["Depletable Assets - BOY",0]
["Depletable Assets - EOY",0]
["  Less: Accumulated Depletion - BOY",0]
["  Less: Accumulated Depletion - EOY",0]
["Other Property/Assets - BOY",0]
["Other Property/Assets - EOY",0]
["  Less: Accumulated Depreciation - BOY",0]
["  Less: Accumulated Depreciation - EOY",0]
["Land - BOY",0]
["Land - EOY",0]
["Inventories - BOY",0]
["Inventories - EOY",0]
["Supplies - BOY",0]
["Supplies - EOY",0]
["Rent - Annual Expense",0]
["Property Amount",{"$f":"SUM(B51,B52)","v":0}]
[null,{"$f":"IF(CEILING(SUM(B5:B6)/2,1)-CEILING(SUM(B7:B8)/2,1)>0,CEILING(SUM(B5:B6)/2,1)-CEILING(SUM(B7:B8)/2,1),0)","v":0}]
[null,{"$f":"IF(CEILING(SUM(B9:B10)/2,1)-CEILING(SUM(B11:B12)/2,1)>0,CEILING(SUM(B9:B10)/2,1)-CEILING(SUM(B11:B12)/2,1),0)+IF(CEILING(SUM(B13:B14)/2,1)-CEILING(SUM(B15:B16)/2,1)>0,CEILING(SUM(B13:B14)/2,1)-CEILING(SUM(B15:B16)/2,1),0)+IF(CEILING(SUM(B17:B18)/2,1)-CEILING(SUM(B19:B20)/2,1)>0,CEILING(SUM(B17:B18)/2,1)-CEILING(SUM(B19:B20)/2,1),0)+IF(CEILING(SUM(B21:B22)/2,1)-CEILING(SUM(B23:B24)/2,1)>0,CEILING(SUM(B21:B22)/2,1)-CEILING(SUM(B23:B24)/2,1),0)+IF(CEILING(SUM(B25:B26)/2,1)-CEILING(SUM(B27:B28)/2,1)>0,CEILING(SUM(B25:B26)/2,1)-CEILING(SUM(B27:B28)/2,1),0)+CEILING(SUM(B29:B30)/2,1)+IF(CEILING(SUM(B31:B32)/2,1)-CEILING(SUM(B33:B34)/2,1)>0,CEILING(SUM(B31:B32)/2,1)-CEILING(SUM(B33:B34)/2,1),0)+IF(CEILING(SUM(B35:B36)/2,1)-CEILING(SUM(B37:B38)/2,1)>0,CEILING(SUM(B35:B36)/2,1)-CEILING(SUM(B37:B38)/2,1),0)+IF(CEILING(SUM(B39:B40)/2,1)-CEILING(SUM(B41:B42)/2,1)>0,CEILING(SUM(B39:B40)/2,1)-CEILING(SUM(B41:B42)/2,1),0)+CEILING(SUM(B43:B44)/2,1)+CEILING(SUM(B45:B46)/2,1)+CEILING(SUM(B47:B48)/2,1)+(SUM(B49)*8)","v":0}]

{"sheet":"Apport Info Payroll","index":17,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":true,"merged":[[7,0,9,0],[0,0,0,2]]}
["                                   "]
[]
["Payroll Component","Everywhere","Other"]
["54b9c2ab-2d9f-4c1a-8ab8-1482987e57df"]
["Salaries and Wages",{"$f":"SUM(C5)","v":0}]
["Cost of Goods Sold Salaries and Wages",{"$f":"SUM(C6)","v":0}]
["Officer's Compensation",{"$f":"SUM(C7)","v":0}]
["Payroll Amount",{"$f":"SUM(B5)+SUM(B6)+SUM(B7)","v":0}]

{"sheet":"Apport Info Sales","index":18,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":true,"merged":[[22,0,24,0],[0,0,0,2]]}
["                                   "]
[]
["Sales Component","Everywhere","Other"]
["54b9c2ab-2d9f-4c1a-8ab8-1482987e57e0"]
["Destination Sales w/in State/Gross Receipts",{"$f":"SUM(C5)","v":0}]
["  Less: Returns and Allowances",0]
["Destination Sales from Outside State",0]
["  Less: Returns and Allowances",0]
["Origin Sales Shipped to US Government",0]
["  Less: Returns and Allowances",0]
["Origin Sales Shipped to Non-taxable Juris",0]
["  Less: Returns and Allowances",0]
["Receipts for Services Performed",0]
["Interest",0]
["Dividends",0]
["Rental of Property",0]
["Royalties",0]
["Gross Proceeds - Sale of Real/Tangible Prop",{"$f":"SUM(C18)","v":0}]
["  Less: Adjusted Basis of Property",0]
["Gross Proceeds - Sale of Intangible Pers Prop",0]
["  Less: Adjusted Basis of Property",0]
["Other Revenue/Receipts",0]
["Sales Amount",{"$f":"IF(SUM(B5)-SUM(B6)>0,SUM(B5)-SUM(B6),0)+IF(SUM(B7)-SUM(B8)>0,SUM(B7)-SUM(B8),0)+IF(SUM(B9)-SUM(B10)>0,SUM(B9)-SUM(B10),0)+IF(SUM(B11)-SUM(B12)>0,SUM(B11)-SUM(B12),0)+SUM(B13)+SUM(B14)+SUM(B15)+SUM(B16)+SUM(B17)+IF(SUM(B18)-SUM(B19)>0,SUM(B18)-SUM(B19),0)+IF(SUM(B20)-SUM(B21)>0,SUM(B20)-SUM(B21),0)+SUM(B22)","v":0}]

{"sheet":"1120 Shareholder Information","index":19,"n_rows":23,"n_cols":45,"rows_kept":23,"cut":false,"hidden":true,"merged":[[1,42,3,42],[1,43,3,43],[1,44,3,44],[0,2,0,44],[1,36,3,36],[1,37,3,37],[1,38,3,38],[1,39,3,39],[1,40,3,40],[1,41,3,41],[1,30,3,30],[1,31,3,31],[1,32,3,32],[1,33,3,33],[1,34,3,34],[1,35,3,35],[1,29,3,29],[1,18,3,18],[1,19,3,19],[1,20,3,20],[1,21,3,21],[1,22,3,22],[1,23,3,23],[1,24,3,24],[1,25,3,25],[1,26,3,26],[1,27,3,27],[1,28,3,28],[1,17,3,17],[1,6,3,6],[1,7,3,7],[1,8,3,8],[1,9,3,9],[1,10,3,10],[1,11,3,11],[1,12,3,12],[1,13,3,13],[1,14,3,14],[1,15,2,15],[1,16,2,16],[1,5,3,5],[1,0,3,0],[1,1,3,1],[1,2,3,2],[1,3,3,3],[1,4,3,4]]}
[]
["Shareholder name","Shr GUID","SSN/EIN","Address 1","Address 2","City","State","Zip code","Country code","Country name","Province or State","Postal code","Resident state","Phone number","Email address","Beginning of year shares","Override percent","Salutation","Final K1","Rounding shr","Tax matters person","1040 client","Officer","Print shr letter in Spanish","Exclude shr from 1120-S p1 count","Shareholder health insurance","Distributions including cash (force)","Deemed dividend (force)","Supplemental information","Salutation","Final K1","Rounding shr","1040 client","Print shr letter in Spanish","Deemed distributions under Section 995(b)(1) (force)","Deemed distributions annual installment under Section 995(b)(2) (force)","Actual taxable distributions (force)","Distributions entitled to Section 243   (force)","Distributions not entitled to Section 243 (force)","Taxable dividends (force)","Accumulated DISC income","Gain on disposition of stock","Gain on excess distribution","Deferred DISC income (force)","Supplemental information"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P5:P65540)","v":0},{"$f":"SUM(Q5:Q65540)","v":0}]
[{"$f":"IF(ISNUMBER(SEARCH(\" \",'General Info - STEP 1'!B15,SEARCH(\" \",'General Info - STEP 1'!B15)+1)),PROPER(RIGHT('General Info - STEP 1'!B15,LEN('General Info - STEP 1'!B15)-SEARCH(\" \",'General Info - STEP 1'!B15,SEARCH(\" \",'General Info - STEP 1'!B15,SEARCH(\" \",'General Info - STEP 1'!B15)+1))))&\", \"&PROPER(LEFT('General Info - STEP 1'!B15,SEARCH(\" \",'General Info - STEP 1'!B15)))&\" \"&PROPER(MID('General Info - STEP 1'!B15,SEARCH(\" \",'General Info - STEP 1'!B15,1)+1,SEARCH(\" \",'General Info - STEP 1'!B15,SEARCH(\" \",'General Info - STEP 1'!B15,1)+1)-SEARCH(\" \",'General Info - STEP 1'!B15,1))),PROPER(MID('General Info - STEP 1'!B15&\", \"&'General Info - STEP 1'!B15,FIND(\" \",'General Info - STEP 1'!B15)+1,LEN('General Info - STEP 1'!B15)+1)))","v":{"$error":"#VALUE!"}},null,{"$f":"'General Info - STEP 1'!B19","v":0},{"$f":"'General Info - STEP 1'!B21","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'General Info - STEP 1'!B24","v":0},{"$f":"'General Info - STEP 1'!B23","v":0},null,null,null," "," ",null," ",null,null," ",null,null,null,null,null," "," "," "]
[{"$f":"IF(ISNUMBER(SEARCH(\" \",'General Info - STEP 1'!B30,SEARCH(\" \",'General Info - STEP 1'!B30)+1)),PROPER(RIGHT('General Info - STEP 1'!B30,LEN('General Info - STEP 1'!B30)-SEARCH(\" \",'General Info - STEP 1'!B30,SEARCH(\" \",'General Info - STEP 1'!B30,SEARCH(\" \",'General Info - STEP 1'!B30)+1))))&\", \"&PROPER(LEFT('General Info - STEP 1'!B30,SEARCH(\" \",'General Info - STEP 1'!B30)))&\" \"&PROPER(MID('General Info - STEP 1'!B30,SEARCH(\" \",'General Info - STEP 1'!B30,1)+1,SEARCH(\" \",'General Info - STEP 1'!B30,SEARCH(\" \",'General Info - STEP 1'!B30,1)+1)-SEARCH(\" \",'General Info - STEP 1'!B30,1))),PROPER(MID('General Info - STEP 1'!B30&\", \"&'General Info - STEP 1'!B30,FIND(\" \",'General Info - STEP 1'!B30)+1,LEN('General Info - STEP 1'!B30)+1)))","v":{"$error":"#VALUE!"}},null,{"$f":"'General Info - STEP 1'!B34","v":0},{"$f":"'General Info - STEP 1'!B36","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'General Info - STEP 1'!B39","v":0},{"$f":"'General Info - STEP 1'!B38","v":0}]
[{"$f":"IF(ISNUMBER(SEARCH(\" \",'General Info - STEP 1'!B45,SEARCH(\" \",'General Info - STEP 1'!B45)+1)),PROPER(RIGHT('General Info - STEP 1'!B45,LEN('General Info - STEP 1'!B45)-SEARCH(\" \",'General Info - STEP 1'!B45,SEARCH(\" \",'General Info - STEP 1'!B45,SEARCH(\" \",'General Info - STEP 1'!B45)+1))))&\", \"&PROPER(LEFT('General Info - STEP 1'!B45,SEARCH(\" \",'General Info - STEP 1'!B45)))&\" \"&PROPER(MID('General Info - STEP 1'!B45,SEARCH(\" \",'General Info - STEP 1'!B45,1)+1,SEARCH(\" \",'General Info - STEP 1'!B45,SEARCH(\" \",'General Info - STEP 1'!B45,1)+1)-SEARCH(\" \",'General Info - STEP 1'!B45,1))),PROPER(MID('General Info - STEP 1'!B45&\", \"&'General Info - STEP 1'!B45,FIND(\" \",'General Info - STEP 1'!B45)+1,LEN('General Info - STEP 1'!B45)+1)))","v":{"$error":"#VALUE!"}},null,{"$f":"'General Info - STEP 1'!B49","v":0},{"$f":"'General Info - STEP 1'!B51","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'General Info - STEP 1'!B54","v":0},{"$f":"'General Info - STEP 1'!B53","v":0}]
[{"$f":"IF(ISNUMBER(SEARCH(\" \",'General Info - STEP 1'!B60,SEARCH(\" \",'General Info - STEP 1'!B60)+1)),PROPER(RIGHT('General Info - STEP 1'!B60,LEN('General Info - STEP 1'!B60)-SEARCH(\" \",'General Info - STEP 1'!B60,SEARCH(\" \",'General Info - STEP 1'!B60,SEARCH(\" \",'General Info - STEP 1'!B60)+1))))&\", \"&PROPER(LEFT('General Info - STEP 1'!B60,SEARCH(\" \",'General Info - STEP 1'!B60)))&\" \"&PROPER(MID('General Info - STEP 1'!B60,SEARCH(\" \",'General Info - STEP 1'!B60,1)+1,SEARCH(\" \",'General Info - STEP 1'!B60,SEARCH(\" \",'General Info - STEP 1'!B60,1)+1)-SEARCH(\" \",'General Info - STEP 1'!B60,1))),PROPER(MID('General Info - STEP 1'!B60&\", \"&'General Info - STEP 1'!B60,FIND(\" \",'General Info - STEP 1'!B60)+1,LEN('General Info - STEP 1'!B60)+1)))","v":{"$error":"#VALUE!"}},null,{"$f":"'General Info - STEP 1'!B64","v":0},{"$f":"'General Info - STEP 1'!B66","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'General Info - STEP 1'!B69","v":0},{"$f":"'General Info - STEP 1'!B68","v":0}]
[{"$f":"IF(ISNUMBER(SEARCH(\" \",'General Info - STEP 1'!B75,SEARCH(\" \",'General Info - STEP 1'!B75)+1)),PROPER(RIGHT('General Info - STEP 1'!B75,LEN('General Info - STEP 1'!B75)-SEARCH(\" \",'General Info - STEP 1'!B75,SEARCH(\" \",'General Info - STEP 1'!B75,SEARCH(\" \",'General Info - STEP 1'!B75)+1))))&\", \"&PROPER(LEFT('General Info - STEP 1'!B75,SEARCH(\" \",'General Info - STEP 1'!B75)))&\" \"&PROPER(MID('General Info - STEP 1'!B75,SEARCH(\" \",'General Info - STEP 1'!B75,1)+1,SEARCH(\" \",'General Info - STEP 1'!B75,SEARCH(\" \",'General Info - STEP 1'!B75,1)+1)-SEARCH(\" \",'General Info - STEP 1'!B75,1))),PROPER(MID('General Info - STEP 1'!B75&\", \"&'General Info - STEP 1'!B75,FIND(\" \",'General Info - STEP 1'!B75)+1,LEN('General Info - STEP 1'!B75)+1)))","v":{"$error":"#VALUE!"}},null,{"$f":"'General Info - STEP 1'!B79","v":0},{"$f":"'General Info - STEP 1'!B81","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'General Info - STEP 1'!B84","v":0},{"$f":"'General Info - STEP 1'!B83","v":0}]
[{"$f":"IF(ISNUMBER(SEARCH(\" \",'General Info - STEP 1'!B90,SEARCH(\" \",'General Info - STEP 1'!B90)+1)),PROPER(RIGHT('General Info - STEP 1'!B90,LEN('General Info - STEP 1'!B90)-SEARCH(\" \",'General Info - STEP 1'!B90,SEARCH(\" \",'General Info - STEP 1'!B90,SEARCH(\" \",'General Info - STEP 1'!B90)+1))))&\", \"&PROPER(LEFT('General Info - STEP 1'!B90,SEARCH(\" \",'General Info - STEP 1'!B90)))&\" \"&PROPER(MID('General Info - STEP 1'!B90,SEARCH(\" \",'General Info - STEP 1'!B90,1)+1,SEARCH(\" \",'General Info - STEP 1'!B90,SEARCH(\" \",'General Info - STEP 1'!B90,1)+1)-SEARCH(\" \",'General Info - STEP 1'!B90,1))),PROPER(MID('General Info - STEP 1'!B90&\", \"&'General Info - STEP 1'!B90,FIND(\" \",'General Info - STEP 1'!B90)+1,LEN('General Info - STEP 1'!B90)+1)))","v":{"$error":"#VALUE!"}},null,{"$f":"'General Info - STEP 1'!B94","v":0},{"$f":"'General Info - STEP 1'!B96","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'General Info - STEP 1'!B99","v":0},{"$f":"'General Info - STEP 1'!B98","v":0}]
[]
[]
[]
[]
[]
[]
[]
["JOHN SMITH","test"]
[{"$f":"PROPER(LEFT(A18,SEARCH(\" \",A18)))","v":"John "},"LEFT","https://www.exceltip.com/excel-text/extract-the-first-middle-and-last-name-in-microsoft-excel.html"]
[{"$f":"PROPER(MID(A18,SEARCH(\" \",A18,1)+1,SEARCH(\" \",A18,SEARCH(\" \",A18,1)+1)-SEARCH(\" \",A18,1)))","v":{"$error":"#VALUE!"}},"MIDDLE","https://www.exceltip.com/excel-text/extract-the-first-middle-and-last-name-in-microsoft-excel.html"]
[{"$f":"PROPER(RIGHT(A18,LEN(A18)-SEARCH(\" \",A18,SEARCH(\" \",A18,SEARCH(\" \",A18)+1))))","v":{"$error":"#VALUE!"}},"right with middle","https://www.exceltip.com/excel-text/extract-the-first-middle-and-last-name-in-microsoft-excel.html"]
[{"$f":"RIGHT(A18,LEN(A18)-SEARCH(\" \",A18))","v":"SMITH"},"right without middle","https://www.wps.com/academy/how-to-flip-first-and-last-names-in-excel-(3-easiest-ways)-quick-tutorials-1863852/"]
[{"$f":"IF(ISNUMBER(SEARCH(\" \",A18,SEARCH(\" \",A18)+1)),PROPER(RIGHT(A18,LEN(A18)-SEARCH(\" \",A18,SEARCH(\" \",A18,SEARCH(\" \",A18)+1))))&\", \"& PROPER(LEFT(A18,SEARCH(\" \",A18)))&\" \"&PROPER(MID(A18,SEARCH(\" \",A18,1)+1,SEARCH(\" \",A18,SEARCH(\" \",A18,1)+1)-SEARCH(\" \",A18,1))),PROPER(MID(A18&\", \" &A18,FIND(\" \",A18)+1,LEN(A18)+1)))","v":"Smith, John"},"WHOLE NAME"]

{"sheet":"Shareholder Basis","index":20,"n_rows":11,"n_cols":62,"rows_kept":11,"cut":false,"hidden":true,"merged":[[2,60,3,60],[2,61,3,61],[1,2,1,14],[1,15,1,29],[1,30,1,61],[2,54,3,54],[2,55,3,55],[2,56,3,56],[2,57,3,57],[2,58,3,58],[2,59,3,59],[2,48,3,48],[2,49,3,49],[2,50,3,50],[2,51,3,51],[2,52,3,52],[2,53,3,53],[2,42,3,42],[2,43,3,43],[2,44,3,44],[2,45,3,45],[2,46,3,46],[2,47,3,47],[2,41,3,41],[2,30,3,30],[2,31,3,31],[2,32,3,32],[2,33,3,33],[2,34,3,34],[2,35,3,35],[2,36,3,36],[2,37,3,37],[2,38,3,38],[2,39,3,39],[2,40,3,40],[2,29,3,29],[2,18,3,18],[2,19,3,19],[2,20,3,20],[2,21,3,21],[2,22,3,22],[2,23,3,23],[2,24,3,24],[2,25,3,25],[2,26,3,26],[2,27,3,27],[2,28,3,28],[2,17,3,17],[2,6,3,6],[2,7,3,7],[2,8,3,8],[2,9,3,9],[2,10,3,10],[2,11,3,11],[2,12,3,12],[2,13,3,13],[2,14,3,14],[2,15,3,15],[2,16,3,16],[2,5,3,5],[1,0,3,0],[1,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4]]}
[]
["Shareholder name","Shr GUID","Stock basis",null,null,null,null,null,null,null,null,null,null,null,null,"Loan basis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Suspended losses"]
[null,null,"Beginning of year stock","Capital contributions","Other increase description 1","Other increase amount 1","Other increase description 2","Other increase amount 2","Gain on Sec179 assets (Force)","Other decrease description 1","Other decrease amount 1","Other decrease description 2","Other decrease amount 2","Loss on Sec179 assets (Force)","Gain on excess dist. (Force)","Beginning of year loan","Loans to corporation","Other increase description 1","Other increase amount 1","Other increase description 2","Other increase amount 2","Other decrease description 1","Other decrease amount 1","Other decrease description 2","Other decrease amount 2","Beg of yr shr loan","Loan repayments","Loan basis restored (Force)","Basis used gain calc (Force)","Gain on repay sh loan (Force)","Reg 1.1367-1(g) election","Supp. 1367 election stmt","Supp. data share of basis","Data share BOY basis","Nondeduct/ noncapital expense","Ordinary loss","Rental real estate","Other rental activities","Short-term capital loss","Long-term capital loss","Section 1231 loss","Other portfolio loss","Other losses","Section 179 expense","Cash contributions (50%)","Cash contributions (30%)","Noncash contributions (50%)","Qual contributions (50%)","Noncash contributions (30%)","Cap gain prop 50% org (30%)","Cap gain prop (20%)","Qual contributions (100%)","Portfolio deductions (other)","Investment interest expense","Deductions royalty income","Section 59e expenses","Reforestation exp deductions","Preproductive period expense","Comm revitalization deds","Other deductions","Foreign tax","Loss on disposal 179 assets"]
[]
[null,"BFFFEA4E-D74B-4B98-8FDC-ADD53BD9253A"]
[{"$f":"'1120 Shareholder Information'!A5","v":{"$error":"#VALUE!"}}]
[{"$f":"'1120 Shareholder Information'!A6","v":{"$error":"#VALUE!"}}]
[{"$f":"'1120 Shareholder Information'!A7","v":{"$error":"#VALUE!"}}]
[{"$f":"'1120 Shareholder Information'!A8","v":{"$error":"#VALUE!"}}]
[{"$f":"'1120 Shareholder Information'!A9","v":{"$error":"#VALUE!"}}]
[{"$f":"'1120 Shareholder Information'!A10","v":{"$error":"#VALUE!"}}]

{"sheet":"Weighted Average","index":21,"n_rows":11,"n_cols":26,"rows_kept":11,"cut":false,"hidden":true,"merged":[[1,24,2,24],[1,25,2,25],[1,18,2,18],[1,19,2,19],[1,20,2,20],[1,21,2,21],[1,22,2,22],[1,23,2,23],[1,17,2,17],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,9,2,9],[1,10,2,10],[1,11,2,11],[1,12,2,12],[1,13,2,13],[1,14,2,14],[1,15,2,15],[1,16,2,16],[1,5,2,5],[1,0,3,0],[1,1,3,1],[1,2,2,2],[1,3,2,3],[1,4,2,4]]}
[]
["Shareholder name","Shr GUID","2022-01-01"]
[]
[null,null,{"$f":"SUM(C6:C255)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"8A205451-E34F-4710-81D2-2F0BDE0AD7A5"]
[{"$f":"'1120 Shareholder Information'!A5","v":{"$error":"#VALUE!"}}]
[{"$f":"'1120 Shareholder Information'!A6","v":{"$error":"#VALUE!"}}]
[{"$f":"'1120 Shareholder Information'!A7","v":{"$error":"#VALUE!"}}]
[{"$f":"'1120 Shareholder Information'!A8","v":{"$error":"#VALUE!"}}]
[{"$f":"'1120 Shareholder Information'!A9","v":{"$error":"#VALUE!"}}]
[{"$f":"'1120 Shareholder Information'!A10","v":{"$error":"#VALUE!"}}]

{"sheet":"1065 Spreadsheet","index":22,"n_rows":10,"n_cols":60,"rows_kept":10,"cut":false,"hidden":true,"merged":[[1,54,3,54],[1,55,3,55],[0,3,0,59],[1,48,3,48],[1,49,3,49],[1,50,3,50],[1,51,3,51],[1,52,3,52],[1,53,3,53],[1,42,3,42],[1,43,3,43],[1,44,3,44],[1,45,3,45],[1,46,3,46],[1,47,3,47],[1,36,3,36],[1,37,3,37],[1,38,3,38],[1,39,3,39],[1,40,3,40],[1,41,3,41],[1,35,3,35],[1,24,3,24],[1,25,3,25],[1,26,3,26],[1,27,3,27],[1,28,3,28],[1,29,3,29],[1,30,3,30],[1,31,3,31],[1,32,3,32],[1,33,3,33],[1,34,3,34],[1,23,3,23],[1,12,3,12],[1,13,3,13],[1,14,3,14],[1,15,3,15],[1,16,3,16],[1,17,3,17],[1,18,3,18],[1,19,3,19],[1,20,3,20],[1,21,3,21],[1,22,3,22],[1,11,3,11],[1,0,3,0],[1,1,3,1],[1,2,3,2],[1,3,3,3],[1,4,3,4],[1,5,3,5],[1,6,3,6],[1,7,3,7],[1,8,3,8],[1,9,3,9],[1,10,3,10]]}
[]
["Ptr Num","Partner Name","Ptr GUID","SSN/EIN","Address 1","Address 2","City","State","Zip","Resident State","Province or state","Foreign Country Code","Country","Postal code","Email address","Entity","Nominee","Partnership Rep","Rep Phone","Des Individ SSN","Des Individ Phone","Des Individ Last","Des Individ First","Des Individ Address","Des Individ City","Des Individ State","Des Individ Zip","Type","LLC Member Manager","Active","Final K1","Foreign","Rounding Ptr","Salutation","1040 Client","Print partner's letter in Spanish","Disreg entity TIN","Missing ID reason","Disreg entity Name","Bene Owner Entity","Indirect pct for max profit, loss or capital","Country code   (if not US)","Country            (if not US)","Report grantor trust as an individual","Eligible Foreign Entity","Decr Due to Trans","Group At-risk","Group Passive","Reportable Entity Partner","Max Deemed Ownership Percent","8805 Frgn Country","8805 Account Num","8805 Tax Exempt","8805 De Minimis Partner Certificate","Suppress basis worksheet","8938 specified individual","%  US","%  US","%  US","$  US"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Profit","Loss","Ownership capital","Capital account - beginning of year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BE6:BE65536)","v":0},{"$f":"SUM(BF6:BF65536)","v":0},{"$f":"SUM(BG6:BG65536)","v":0},{"$f":"SUM(BH6:BH65536)","v":0}]
["1",{"$f":"IF(ISNUMBER(SEARCH(\" \",'General Info - STEP 1'!B15,SEARCH(\" \",'General Info - STEP 1'!B15)+1)),PROPER(RIGHT('General Info - STEP 1'!B15,LEN('General Info - STEP 1'!B15)-SEARCH(\" \",'General Info - STEP 1'!B15,SEARCH(\" \",'General Info - STEP 1'!B15,SEARCH(\" \",'General Info - STEP 1'!B15)+1))))&\", \"&PROPER(LEFT('General Info - STEP 1'!B15,SEARCH(\" \",'General Info - STEP 1'!B15)))&\" \"&PROPER(MID('General Info - STEP 1'!B15,SEARCH(\" \",'General Info - STEP 1'!B15,1)+1,SEARCH(\" \",'General Info - STEP 1'!B15,SEARCH(\" \",'General Info - STEP 1'!B15,1)+1)-SEARCH(\" \",'General Info - STEP 1'!B15,1))),PROPER(MID('General Info - STEP 1'!B15&\", \"&'General Info - STEP 1'!B15,FIND(\" \",'General Info - STEP 1'!B15)+1,LEN('General Info - STEP 1'!B15)+1)))","v":{"$error":"#VALUE!"}},null,{"$f":"'General Info - STEP 1'!B75","v":0},{"$f":"'General Info - STEP 1'!B21","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'General Info - STEP 1'!B24","v":0},null,null,null,{"$f":"'General Info - STEP 1'!B23","v":0}," "," ",null," ",null,null," "]
["2",{"$f":"IF(ISNUMBER(SEARCH(\" \",'General Info - STEP 1'!B30,SEARCH(\" \",'General Info - STEP 1'!B30)+1)),PROPER(RIGHT('General Info - STEP 1'!B30,LEN('General Info - STEP 1'!B30)-SEARCH(\" \",'General Info - STEP 1'!B30,SEARCH(\" \",'General Info - STEP 1'!B30,SEARCH(\" \",'General Info - STEP 1'!B30)+1))))&\", \"&PROPER(LEFT('General Info - STEP 1'!B30,SEARCH(\" \",'General Info - STEP 1'!B30)))&\" \"&PROPER(MID('General Info - STEP 1'!B30,SEARCH(\" \",'General Info - STEP 1'!B30,1)+1,SEARCH(\" \",'General Info - STEP 1'!B30,SEARCH(\" \",'General Info - STEP 1'!B30,1)+1)-SEARCH(\" \",'General Info - STEP 1'!B30,1))),PROPER(MID('General Info - STEP 1'!B30&\", \"&'General Info - STEP 1'!B30,FIND(\" \",'General Info - STEP 1'!B30)+1,LEN('General Info - STEP 1'!B30)+1)))","v":{"$error":"#VALUE!"}},null,{"$f":"'General Info - STEP 1'!B34","v":0},{"$f":"'General Info - STEP 1'!B36","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'General Info - STEP 1'!B39","v":0},null,null,null,{"$f":"'General Info - STEP 1'!E38","v":0}]
["3",{"$f":"IF(ISNUMBER(SEARCH(\" \",'General Info - STEP 1'!B45,SEARCH(\" \",'General Info - STEP 1'!B45)+1)),PROPER(RIGHT('General Info - STEP 1'!B45,LEN('General Info - STEP 1'!B45)-SEARCH(\" \",'General Info - STEP 1'!B45,SEARCH(\" \",'General Info - STEP 1'!B45,SEARCH(\" \",'General Info - STEP 1'!B45)+1))))&\", \"&PROPER(LEFT('General Info - STEP 1'!B45,SEARCH(\" \",'General Info - STEP 1'!B45)))&\" \"&PROPER(MID('General Info - STEP 1'!B45,SEARCH(\" \",'General Info - STEP 1'!B45,1)+1,SEARCH(\" \",'General Info - STEP 1'!B45,SEARCH(\" \",'General Info - STEP 1'!B45,1)+1)-SEARCH(\" \",'General Info - STEP 1'!B45,1))),PROPER(MID('General Info - STEP 1'!B45&\", \"&'General Info - STEP 1'!B45,FIND(\" \",'General Info - STEP 1'!B45)+1,LEN('General Info - STEP 1'!B45)+1)))","v":{"$error":"#VALUE!"}},null,{"$f":"'General Info - STEP 1'!B49","v":0},{"$f":"'General Info - STEP 1'!B51","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'General Info - STEP 1'!B54","v":0},null,null,null,{"$f":"'General Info - STEP 1'!E53","v":0}]
["4",{"$f":"IF(ISNUMBER(SEARCH(\" \",'General Info - STEP 1'!B60,SEARCH(\" \",'General Info - STEP 1'!B60)+1)),PROPER(RIGHT('General Info - STEP 1'!B60,LEN('General Info - STEP 1'!B60)-SEARCH(\" \",'General Info - STEP 1'!B60,SEARCH(\" \",'General Info - STEP 1'!B60,SEARCH(\" \",'General Info - STEP 1'!B60)+1))))&\", \"&PROPER(LEFT('General Info - STEP 1'!B60,SEARCH(\" \",'General Info - STEP 1'!B60)))&\" \"&PROPER(MID('General Info - STEP 1'!B60,SEARCH(\" \",'General Info - STEP 1'!B60,1)+1,SEARCH(\" \",'General Info - STEP 1'!B60,SEARCH(\" \",'General Info - STEP 1'!B60,1)+1)-SEARCH(\" \",'General Info - STEP 1'!B60,1))),PROPER(MID('General Info - STEP 1'!B60&\", \"&'General Info - STEP 1'!B60,FIND(\" \",'General Info - STEP 1'!B60)+1,LEN('General Info - STEP 1'!B60)+1)))","v":{"$error":"#VALUE!"}},null,{"$f":"'General Info - STEP 1'!B64","v":0},{"$f":"'General Info - STEP 1'!B66","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'General Info - STEP 1'!B69","v":0},null,null,null,{"$f":"'General Info - STEP 1'!E68","v":0}]
["5",{"$f":"IF(ISNUMBER(SEARCH(\" \",'General Info - STEP 1'!B75,SEARCH(\" \",'General Info - STEP 1'!B75)+1)),PROPER(RIGHT('General Info - STEP 1'!B75,LEN('General Info - STEP 1'!B75)-SEARCH(\" \",'General Info - STEP 1'!B75,SEARCH(\" \",'General Info - STEP 1'!B75,SEARCH(\" \",'General Info - STEP 1'!B75)+1))))&\", \"&PROPER(LEFT('General Info - STEP 1'!B75,SEARCH(\" \",'General Info - STEP 1'!B75)))&\" \"&PROPER(MID('General Info - STEP 1'!B75,SEARCH(\" \",'General Info - STEP 1'!B75,1)+1,SEARCH(\" \",'General Info - STEP 1'!B75,SEARCH(\" \",'General Info - STEP 1'!B75,1)+1)-SEARCH(\" \",'General Info - STEP 1'!B75,1))),PROPER(MID('General Info - STEP 1'!B75&\", \"&'General Info - STEP 1'!B75,FIND(\" \",'General Info - STEP 1'!B75)+1,LEN('General Info - STEP 1'!B75)+1)))","v":{"$error":"#VALUE!"}},null,{"$f":"'General Info - STEP 1'!B79","v":0},{"$f":"'General Info - STEP 1'!B81","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'General Info - STEP 1'!B84","v":0},null,null,null,{"$f":"'General Info - STEP 1'!E83","v":0}]
["6",{"$f":"IF(ISNUMBER(SEARCH(\" \",'General Info - STEP 1'!B90,SEARCH(\" \",'General Info - STEP 1'!B90)+1)),PROPER(RIGHT('General Info - STEP 1'!B90,LEN('General Info - STEP 1'!B90)-SEARCH(\" \",'General Info - STEP 1'!B90,SEARCH(\" \",'General Info - STEP 1'!B90,SEARCH(\" \",'General Info - STEP 1'!B90)+1))))&\", \"&PROPER(LEFT('General Info - STEP 1'!B90,SEARCH(\" \",'General Info - STEP 1'!B90)))&\" \"&PROPER(MID('General Info - STEP 1'!B90,SEARCH(\" \",'General Info - STEP 1'!B90,1)+1,SEARCH(\" \",'General Info - STEP 1'!B90,SEARCH(\" \",'General Info - STEP 1'!B90,1)+1)-SEARCH(\" \",'General Info - STEP 1'!B90,1))),PROPER(MID('General Info - STEP 1'!B90&\", \"&'General Info - STEP 1'!B90,FIND(\" \",'General Info - STEP 1'!B90)+1,LEN('General Info - STEP 1'!B90)+1)))","v":{"$error":"#VALUE!"}},null,{"$f":"'General Info - STEP 1'!B94","v":0},{"$f":"'General Info - STEP 1'!B96","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'General Info - STEP 1'!B99","v":0},null,null,null,{"$f":"'General Info - STEP 1'!E98","v":0}]

{"sheet":"Profit Transfers","index":23,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":true,"merged":[[1,6,2,6],[1,0,3,0],[1,1,3,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5]]}
[null,"PINKY'S FAST PANI PURIS"]
["Partner Name","Partner Name","Beginning of Year"]
[]
[null,null,{"$f":"SUM(C6:C65536)","v":0},{"$f":"SUM(D6:D65536)","v":0},{"$f":"SUM(E6:E65536)","v":0},{"$f":"SUM(F6:F65536)","v":0},{"$f":"SUM(G6:G65536)","v":0}]
[null,null,"E942A1A5-AB56-4cc6-8DAB-B11AA2BA5198"]
[{"$f":"'1065 Spreadsheet'!B5","v":{"$error":"#VALUE!"}}]
[{"$f":"'1065 Spreadsheet'!B6","v":{"$error":"#VALUE!"}}]
[{"$f":"'1065 Spreadsheet'!B7","v":{"$error":"#VALUE!"}}]
[{"$f":"'1065 Spreadsheet'!B8","v":{"$error":"#VALUE!"}}]
[{"$f":"'1065 Spreadsheet'!B9","v":{"$error":"#VALUE!"}}]
[{"$f":"'1065 Spreadsheet'!B10","v":{"$error":"#VALUE!"}}]

{"sheet":"Loss Transfers","index":24,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":true,"merged":[[1,6,2,6],[1,0,3,0],[1,1,3,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5]]}
[null,"PINKY'S FAST PANI PURIS"]
["Partner Name","Partner Name","Beginning of Year"]
[]
[null,null,{"$f":"SUM(C6:C65536)","v":0},{"$f":"SUM(D6:D65536)","v":0},{"$f":"SUM(E6:E65536)","v":0},{"$f":"SUM(F6:F65536)","v":0},{"$f":"SUM(G6:G65536)","v":0}]
[null,null,"8A205451-E34F-4710-81D2-2F0BDE0AD7A5"]
[{"$f":"'1065 Spreadsheet'!B5","v":{"$error":"#VALUE!"}}]
[{"$f":"'1065 Spreadsheet'!B6","v":{"$error":"#VALUE!"}}]
[{"$f":"'1065 Spreadsheet'!B7","v":{"$error":"#VALUE!"}}]
[{"$f":"'1065 Spreadsheet'!B8","v":{"$error":"#VALUE!"}}]
[{"$f":"'1065 Spreadsheet'!B9","v":{"$error":"#VALUE!"}}]
[{"$f":"'1065 Spreadsheet'!B10","v":{"$error":"#VALUE!"}}]

{"sheet":"Capital Transfers","index":25,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":true,"merged":[[1,6,2,6],[1,0,3,0],[1,1,3,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5]]}
[null,"PINKY'S FAST PANI PURIS"]
["Partner Name","Partner Name","Beginning of Year"]
[]
[null,null,{"$f":"SUM(C6:C65536)","v":0},{"$f":"SUM(D6:D65536)","v":0},{"$f":"SUM(E6:E65536)","v":0},{"$f":"SUM(F6:F65536)","v":0},{"$f":"SUM(G6:G65536)","v":0}]
[null,null,"F09731D1-86D4-4829-AB44-DEA097BD5591"]
[{"$f":"'1065 Spreadsheet'!B5","v":{"$error":"#VALUE!"}}]
[{"$f":"'1065 Spreadsheet'!B6","v":{"$error":"#VALUE!"}}]
[{"$f":"'1065 Spreadsheet'!B7","v":{"$error":"#VALUE!"}}]
[{"$f":"'1065 Spreadsheet'!B8","v":{"$error":"#VALUE!"}}]
[{"$f":"'1065 Spreadsheet'!B9","v":{"$error":"#VALUE!"}}]
[{"$f":"'1065 Spreadsheet'!B10","v":{"$error":"#VALUE!"}}]

{"sheet":"990 Import","index":26,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"1041 Import","index":27,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Dropdowns","index":28,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["Asset Type","Select Property Type…",null,"Which Account?",null,null,"Tax Status",null,"Officer?"]
["Land","Single Family",null,"Company Checking/Savings",null,null,"S-Corp",null,"Yes"]
["Residential Building","Mutli - Family",null,"Personal Checking/Savings",null,null,"LLC",null,"No"]
["Res. Rental Furn. & Fixture","Vacation Home",null,null,null,null,"C-Corp"]
["Commercial Building","Commerical",null,null,null,null,"GP"]
["Machinery & Equipment","Land",null,null,null,null,"LLP"]
["Furniture & Fixtures","Royalties",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"]