{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Tax Report","QB Report","BEA Report"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":"Tax Report","index":0,"n_rows":105,"n_cols":9,"rows_kept":105,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Prior Balance Adjusted 12/31/11","Unadjusted 12/31/12","Adjustments","Adjusted 12/31/12","Tax Adjustments","Tax 12/31/12"]
[]
[111,"A ","Cash in Bank ",1230.08,-5100.28,0,-5100.28,0,-5100.28]
[]
[132,"A ","Inventory - Livestock - Other ",5250,5250,0,5250,0,5250]
[]
[151,"A ","Homes ",2040882.58,2040882.58,0,2040882.58,0,2040882.58]
[152,"A ","Ranch Improvements ",580713.16,618323.16,5527.84,623851,0,623851]
[153,"A ","Guest Improvements ",350951.65,350951.65,0,350951.65,0,350951.65]
[154,"A ","Ranch Equipment ",176013.53,320013.53000000003,0,320013.53000000003,0,320013.53000000003]
[155,"A ","Autos & Trucks ",128986.68,128986.68,0,128986.68,0,128986.68]
[156,"A ","Livestock - Bulls ",227186.54,246636.54,-122415,124221.54,0,124221.54]
[157,"A ","Livestock - Commercial Cows ",419930,419930,-419930,0,0,0]
[158,"A ","Livestock - Horses ",600,600,-600,0,0,0]
[161,"A ","Misc Assets ",38417.71,38417.71,0,38417.71,0,38417.71]
[]
[159,"A ","Accumulated Depreciation ",-2081284.22,-2265187.63,609530.61,-1655657.02,0,-1655657.02]
[]
[150,"A ","Land ",2524985,2524985,0,2524985,0,2524985]
[]
[160,"A ","Capitalized Settlement Charges ",61402,61402,0,61402,0,61402]
[]
[169,"A ","Accumulated Amortization ",-15706.03,-17527.8,0,-17527.8,0,-17527.8]
[]
[177,"A ","Loan - La Prestamo",105000,105000,0,105000,0,105000]
[]
[269,"L ","Note Payable - Monte Christo",-150000,-150000,0,-150000,0,-150000]
[]
[222,"L ","FICA & FWH Tax Payable ",0,-2330.0100000000002,0,-2330.0100000000002,0,-2330.0100000000002]
[224,"L ","State Unemploy. Tax Payab ",-51.4,-21.6,0,-21.6,0,-21.6]
[225,"L ","Federal Unemploy. Tax Pay ",-112,-84,0,-84,0,-84]
[]
[252,"L ","Note Payable - MetLife (New) ",-4600000,-4300000,0,-4300000,0,-4300000]
[254,"L ","Note Payable - ABC",0,-300000,0,-300000,0,-300000]
[255,"L ","Note Payable - Markers",0,-150000,0,-150000,0,-150000]
[261,"L ","Revolving Credit Line #1111",0,-114746.15,0,-114746.15,0,-114746.15]
[272,"L ","N/P Adams Brothers (Swather) ",0,-108000,0,-108000,0,-108000]
[277,"L ","Note Payable State Bank LOC #456",-25000,0,0,0,0,0]
[]
[321,"L ","Draws - Benjamin",47940.97,57923.7,0,57923.7,0,57923.7]
[]
[425,"R ","Rental Income ",-4200,0,0,0,0,0]
[]
[410,"R ","Sales - Heifer Feeders ",-473863.85,-498650.33,0,-498650.33,0,-498650.33]
[]
[820,"E ","Contract Labor ",1830,0,0,0,0,0]
[]
[717,"E ","Depreciation ",110659.67,183903.41,-66585.61,117317.8,0,117317.8]
[]
[629,"E ","Feed - Supplements, Cubes, Etc. ",24485.19,45926.25,0,45926.25,0,45926.25]
[]
[632,"E ","Fuels ",29690.85,13562.77,0,13562.77,0,13562.77]
[]
[640,"E ","Insurance - General Ranch ",6305.3,6375.75,0,6375.75,0,6375.75]
[641,"E ","Insurance - Unemployment Insuranc ",0,8866.43,0,8866.43,0,8866.43]
[642,"E ","Insurance - Workers Comp ",9381.4500000000007,0,0,0,0,0]
[643,"E ","Insurance Life ",10543.72,12652.56,0,12652.56,-12652.56,0]
[]
[905,"E ","Interest Expense ",335208.21000000002,254850.03,0,254850.03,0,254850.03]
[]
[675,"E ","Wages ",74624,83388.06,0,83388.06,0,83388.06]
[]
[740,"E ","Truck Rental ",8314.68,13990.86,0,13990.86,0,13990.86]
[]
[672,"E ","Repairs & Maintenance - Autos ",22363.15,18480.04,0,18480.04,0,18480.04]
[673,"E ","Repairs & Maintenance - Improvements",5539.98,10177.84,-10177.84,0,0,0]
[]
[685,"E ","Supplies - General Ranch ",23619.99,18837.13,0,18837.13,0,18837.13]
[]
[691,"E ","Taxes - Payroll ",7428.79,7003.19,0,7003.19,0,7003.19]
[791,"E ","Taxes ",19862.34,30952.57,0,30952.57,0,30952.57]
[]
[700,"E ","Utilities - Propane ",211.37,3055.23,0,3055.23,0,3055.23]
[701,"E ","Utilities - Electricity ",12284.19,10093.25,0,10093.25,0,10093.25]
[]
[705,"E ","Vet Services and Supplies ",3315.75,7351.64,0,7351.64,0,7351.64]
[]
[605,"E ","Advertising ",3500,5500,0,5500,0,5500]
[610,"E ","Commissions ",2960,0,0,0,0,0]
[652,"E ","Grazing Permits - State ",1900.15,180,0,180,0,180]
[653,"E ","Grazing Permits - BLM ",1469.88,3323.8,0,3323.8,0,3323.8]
[654,"E ","Grazing Permits - USFS ",612.9,1430.1,0,1430.1,0,1430.1]
[660,"E ","Miscellaneous ",47.01,1569.19,0,1569.19,0,1569.19]
[665,"E ","Licenses and Permits ",0,62.25,0,62.25,0,62.25]
[669,"E ","Reconciliation Discrepanices ",0,-0.36,0,-0.36,0,-0.36]
[695,"E ","Telephone & TV ",3380.82,3793.63,0,3793.63,0,3793.63]
[699,"E ","Water Commissioner & DNRC Tax ",313.13,1064.3,0,1064.3,0,1064.3]
[712,"E ","Bank Charges ",467.66,100.56,0,100.56,0,100.56]
[720,"E ","Dues & Subscriptions ",313,83,0,83,0,83]
[730,"E ","Equipment Rentals ",5112.7,1341.22,0,1341.22,0,1341.22]
[755,"E ","Legal, Accounting & Mgmt. Fees ",11733.98,29004.06,0,29004.06,0,29004.06]
[756,"E ","Management Fees ",0,1500,0,1500,0,1500]
[780,"E ","Ranch Consulting ",0,0,4650,4650,0,4650]
[810,"E ","Shipping ",1500,1500,0,1500,0,1500]
[]
[716,"E ","Amortization ",1821.77,1821.77,0,1821.77,0,1821.77]
[]
[320,"L ","Benjamin Capital ",-14100.58,99524.84,0,99524.84,0,99524.84]
[325,"L ","Crystal Capital ",-12214.85,37048.480000000003,0,37048.480000000003,0,37048.480000000003]
[330,"L ","Robert Capital ",-7189.86,42073.47,0,42073.47,0,42073.47]
[335,"L ","Christina Capital ",-25189.87,24073.46,0,24073.46,0,24073.46]
[340,"L ","Brigham Capital ",-41878.870000000003,7384.47,0,7384.47,0,7384.47]
[399,"L ","Non-Deductible Expenses ",0,0,0,0,12652.56,12652.56]
[]
[999,null,"Profit/Loss",-262737.78000000003,-283090.2,7211345,-210976.75,12652.56,-198324.19]

{"sheet":"QB Report","index":1,"n_rows":65,"n_cols":6,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,"Dec 31, 12"]
["ASSETS"]
[null,"Current Assets"]
[null,null,"Checking/Savings"]
[null,null,null,"111 · Checking",null,{"$f":"-5100.28","v":-5100.28}]
[null,null,null,"112 · Stockman Checking",null,0]
[null,null,null,"113 · Money Market Stockman",null,0]
[null,null,null,"114 · Stockman Petty Cash",null,0]
[null,null,"Total Checking/Savings",null,null,{"$f":"ROUND(SUM(F5:F9),5)","v":-5100.28}]
[null,null,"Other Current Assets"]
[null,null,null,"132 · Inventory- Livestock (Other)",null,5250]
[null,null,"Total Other Current Assets",null,null,{"$f":"ROUND(SUM(F11:F12),5)","v":5250}]
[null,"Total Current Assets",null,null,null,{"$f":"ROUND(F4+F10+F13,5)","v":149.72}]
[null,"Fixed Assets"]
[null,null,"150 · Land",null,null,2524985]
[null,null,"151 · Homes",null,null,2040882.58]
[null,null,"152 · Ranch Improvments",null,null,623851]
[null,null,"153 · Guest Improvements",null,null,350951.65]
[null,null,"154 · Ranch Equipment",null,null,320013.53000000003]
[null,null,"155 · Autos & Trucks",null,null,128986.68]
[null,null,"156 · Livestock- Bulls",null,null,124221.54]
[null,null,"159 · Accumulated Depreciation",null,null,-1655857.02]
[null,null,"160 · Capitalized Settlement Charges",null,null,61402]
[null,null,"161 · Miscellaneous Assets",null,null,38417.71]
[null,null,"169 · Accumulated Amortization",null,null,-17527.8]
[null,"Total Fixed Assets",null,null,null,{"$f":"ROUND(SUM(F15:F26),5)","v":4540326.87}]
[null,"Other Assets"]
[null,null,"177 · Loan - La Prestamo",null,null,105000]
[null,"Total Other Assets",null,null,null,{"$f":"ROUND(SUM(F28:F29),5)","v":105000}]
["TOTAL ASSETS",null,null,null,null,{"$f":"ROUND(F3+F14+F27+F30,5)","v":4645476.59}]
["LIABILITIES & EQUITY"]
[null,"Liabilities"]
[null,null,"Current Liabilities"]
[null,null,null,"Accounts Payable"]
[null,null,null,null,"200 · Accounts Payable",1500]
[null,null,null,"Total Accounts Payable",null,{"$f":"ROUND(SUM(F35:F36),5)","v":1500}]
[null,null,null,"Other Current Liabilities"]
[null,null,null,null,"222 · FICA & FWH Tax Payable",2330.0100000000002]
[null,null,null,null,"224 · SUTA Payable",21.6]
[null,null,null,null,"225 · FUTA Payable",84]
[null,null,null,null,"255 · NP Markers",150000]
[null,null,null,null,"269 · NP Monte Christo",150000]
[null,null,null,"Total Other Current Liabilities",null,{"$f":"ROUND(SUM(F38:F43),5)","v":302435.61}]
[null,null,"Total Current Liabilities",null,null,{"$f":"ROUND(F34+F37+F44,5)","v":303935.61}]
[null,null,"Long Term Liabilities"]
[null,null,null,"252 · N/P- MetLife",null,4300000]
[null,null,null,"254 · N/P- ABC",null,300000]
[null,null,null,"261 · Revolving Credit Line #1111",null,114746.15]
[null,null,null,"272 · N/P Adams Brothers (Swather)",null,108000]
[null,null,"Total Long Term Liabilities",null,null,{"$f":"ROUND(SUM(F46:F50),5)","v":4822746.1500000004}]
[null,"Total Liabilities",null,null,null,{"$f":"ROUND(F33+F45+F51,5)","v":5126681.76}]
[null,"Equity"]
[null,null,"320 · Benjamin Capital"]
[null,null,null,"321 · Benjamin Distributions",null,-57923.7]
[null,null,null,"320 · Benjamin Capital - Other",null,-99524.84]
[null,null,"Total 320 · Benjamin Capital",null,null,{"$f":"ROUND(SUM(F54:F56),5)","v":-157448.54}]
[null,null,"32000 · Retained Earnings",null,null,0]
[null,null,"325 · Crystal Capital",null,null,-37048.480000000003]
[null,null,"330 · Robert Equity",null,null,-42073.47]
[null,null,"335 · Christina Equity",null,null,-24073.46]
[null,null,"340 · Brigham Capital",null,null,-7384.47]
[null,null,"Net Income",null,null,-212676.75]
[null,"Total Equity",null,null,null,{"$f":"ROUND(F53+SUM(F57:F63),5)","v":-480705.17}]
["TOTAL LIABILITIES & EQUITY",null,null,null,null,{"$f":"ROUND(F32+F52+F64,5)","v":4645976.59}]

{"sheet":"BEA Report","index":2,"n_rows":41,"n_cols":4,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["Account","QB Amount","Tax Report Amount","Difference"]
["111 · Checking",-5100.28,-5100.28,0]
["132 · Inventory- Livestock (Other)",5250,5250,0]
["150 · Land",2524985,2524985,0]
["151 · Homes",2040882.58,2040882.58,0]
["152 · Ranch Improvments",623851,623851,0]
["153 · Guest Improvements",350951.65,350951.65,0]
["154 · Ranch Equipment",320013.53000000003,320013.53000000003,0]
["155 · Autos & Trucks",128986.68,128986.68,0]
["156 · Livestock- Bulls",124221.54,124221.54,0]
["159 · Accumulated Depreciation",-1655857.02,-1655657.02,200]
["160 · Capitalized Settlement Charges",61402,61402,0]
["161 · Miscellaneous Assets",38417.71,38417.71,0]
["169 · Accumulated Amortization",-17527.8,-17527.8,0]
["177 · Loan - La Prestamo",105000,105000,0]
["200 · Accounts Payable",1500,null,1500]
["222 · FICA & FWH Tax Payable",2330.0100000000002,2330.0100000000002,0]
["224 · SUTA Payable",21.6,21.6,0]
["225 · FUTA Payable",84,84,0]
["255 · NP Markers",150000,150000,0]
["269 · NP Monte Christo",150000,150000,0]
["252 · N/P- MetLife",4300000,4300000,0]
["254 · N/P- ABC",300000,300000,0]
["261 · Revolving Credit Line #1111",114746.15,114746.15,0]
["272 · N/P Adams Brothers (Swather)",108000,108000,0]
["321 · Benjamin Distributions",-57923.7,-57923.7,0]
["320 · Benjamin Capital - Other",-99524.84,-99524.84,0]
["325 · Crystal Capital",-37048.480000000003,-37048.480000000003,0]
["330 · Robert Equity",-42073.47,-42073.47,0]
["335 · Christina Equity",-24073.46,-24073.46,0]
["340 · Brigham Capital",-7384.47,-7384.47,0]
["999 · Profit/Loss",-212677,-210977,-1700]
[]
[]
["Journal Entries"]
["159 · Accumulated Depreciation",-200]
["200 · Accounts Payable",-1500]
["        ### · Retained Earnings",null,1700]
[]
["### · Expense Account",-1500]
["        200 · Accounts Payable",null,1500]