{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Reconcile Example","Worksheet ExampleOld","Worksheet Example","Worksheet (blank) template","Tax Codes"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":3,"defined_names":19,"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":"Reconcile Example","index":0,"n_rows":49,"n_cols":5,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["Facts:"]
[null,"Accounts Receivable"]
[null,null,null,"Opening","Closing"]
[]
[null,"Wheat",null,50000,30000]
[null,"Crop Insurance",null,20000,"-"]
[null,"Barley",null,10000,"-"]
[null,null,null,80000,30000]
[]
[null,"Accounts Payable"]
[null,null,null,"Opening","Closing"]
[]
[null,"Cattle",null,150000,25000]
[null,"Equipment rental",null,"-",5000]
[null,"Accounting fees",null,5000,3000]
[null,"Fuel & oil",null,2000,"-"]
[null,"Agriculture contract work",null,2000]
[null,null,null,159000,263000]
[]
[null,"Prepaid Expenses"]
[null,null,null,"Opening","Closing"]
[]
[null,"Fertilizer",null,20000,50000]
[]
[]
["Reconciliation of Net Income for Tax Purposes T2 Schedule 1"]
[]
[null,"Net Income per Financial Statements",null,null,90000]
[]
["Add:","Depreciation",null,70000]
[null,"Opening inventory",null,800000]
[null,"Opening accounts receivable / prepaid",null,100000]
[null,"Closing accounts payable",null,263000]
[null,"Current year optional inventory adj",null,120000]
[null,null,null,null,1353000]
[]
["Deduct:","Dividend income",null,50000]
[null,"Closing inventory",null,60000]
[null,"Closing accounts receivable / prepaid",null,80000]
[null,"Opening accounts payable",null,159000]
[null,"Prior year optional inventory adj",null,140000]
[null,"Gain on sale",null,4000]
[null,"Capital cost allowance",null,80000]
[null,null,null,null,1113000]
[]
["Income from Business or Property"]
[null,"Taxable capital gain",null,null,3000]
[]
["Net Income for Tax Purposes",null,null,null,333000]

{"sheet":"Worksheet ExampleOld","index":1,"n_rows":132,"n_cols":10,"rows_kept":132,"cut":false,"hidden":true,"merged":[[11,1,11,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[0,4,0,6],[0,8,0,9],[30,1,30,2],[12,1,12,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[32,1,32,3],[38,1,38,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[52,1,52,2],[53,1,53,2],[54,1,54,2],[55,1,55,2],[56,1,56,2],[60,1,60,2],[39,1,39,2],[47,1,47,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[51,1,51,2],[67,1,67,2],[68,1,68,2],[69,1,69,2],[70,1,70,2],[71,1,71,2],[73,1,73,2],[61,1,61,2],[62,1,62,2],[63,1,63,2],[64,1,64,2],[65,1,65,2],[66,1,66,2],[72,1,72,2],[74,1,74,2],[75,1,75,2],[79,1,79,2],[92,1,92,2],[93,1,93,2],[94,1,94,2],[85,1,85,2],[86,1,86,2],[87,1,87,2],[88,1,88,2],[80,1,80,2],[81,1,81,2],[82,1,82,2],[83,1,83,2],[84,1,84,2],[95,1,95,2],[96,1,96,2],[97,1,97,2],[98,1,98,2],[89,1,89,2],[90,1,90,2],[91,1,91,2],[104,1,104,2],[109,4,109,5],[101,1,101,2],[102,1,102,2],[103,1,103,2],[105,1,105,2],[99,1,99,2],[100,1,100,2],[113,6,113,7],[114,6,114,7],[115,6,115,7],[116,6,116,7],[111,1,111,2],[112,1,112,2],[113,1,113,2],[114,1,114,2],[115,1,115,2],[116,1,116,2],[131,1,131,2],[125,1,125,2],[109,8,109,9],[125,6,125,7],[127,1,127,2],[129,1,129,2],[130,1,130,2],[117,6,117,7],[118,6,118,7],[119,6,119,7],[120,6,120,7],[122,6,122,7],[123,6,123,7],[121,6,121,7],[117,1,117,2],[118,1,118,2],[119,1,119,2],[123,1,123,2],[121,1,121,2],[120,1,120,2],[122,1,122,2],[110,6,110,7],[111,6,111,7],[112,6,112,7]]}
[null,null,null,null,"Financial Statements:\nStatement of Income (Loss)",null,null,null,"Net Income (Loss)\nfor Income Tax Purposes"]
[null,"Revenue"]
[]
[null,null,null,"T1163",null,"Opening",null,"Closing"]
[null,"Commodity Sales and Program Payments",null,"Code","Accrual   +","Receivables","-","Receivables","=","Cash/Tax"]
[null,"Wheat",null,56,200000,50000,null,30000,null,{"$f":"E6+F6-H6","v":220000}]
[null,"Barley",null,3,300000,10000,null,null,null,{"$f":"E7+F7-H7","v":310000}]
[null,"Oats",null,45,56000,null,null,null,null,56000]
[null,"Cattle, Feeder",null,721,1200000,null,null,null,null,1200000]
[null,"Crop Insurance: Grains & Oilseeds",null,401,40000,20000,null,null,null,60000]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,"Total A",null,9950,{"$f":"SUM(E6:E12)","v":1796000},{"$f":"SUM(F6:F12)","v":80000},null,{"$f":"SUM(H6:H12)","v":30000},null,{"$f":"SUM(J6:J12)","v":1846000}]
[]
[null,null,null,null,null,"Opening",null,"Closing"]
[null,"Other Farming Income",null,"Line","Accrual +","Receivables","-","Receivables","=","Cash/Tax"]
[null,"Other program payments",null,9540]
[null,"Business Risk Management (BRM) and disaster assistance program payments",null,9544]
[null,"Resales, Rebates, GST/HST for allowable exp",null,9574]
[null,"Resales, Rebates, GST/HST for non-allowable expenses",null,9575]
[null,"Agricultural contract work",null,9601]
[null,"Patronage dividends",null,9605]
[null,"Interest",null,9607]
[null,"Gravel",null,9610]
[null,"Trucking (farm - related only)",null,9611]
[null,"Resales of commodities purchased",null,9612]
[null,"Leases (gas, oil well, surface, etc.)",null,9613]
[null,"Machine rentals",null,9614]
[null,"Other (specify)",null,9600]
[]
[null,"Total B",null,null,"-","-",null,"-",null,"-"]
[]
[null,"Total Revenue (Total A + Total B)",null,null,1796000,80000,null,30000,null,1846000]
[]
[null,"Inventory"]
[]
[null,null,null,null,"Accrual",null,"Opening",null,"Closing"]
[null,null,null,null,null,null,"Inventories",null,"Inventories","Cash/Tax"]
[null,"Opening Inventory",null,null,800000,null,-800000]
[null,"Closing Inventory",null,null,600000,null,null,null,-600000]
[]
[null,"Change in Inventory",null,null,-200000,null,800000,null,-600000]
[]
[null,"Expenses"]
[]
[null," Commodity Purchases and",null,"T1163",null,"Opening","Closing","Closing","Opening"]
[null,"Repayment of Program Benefits",null,"Code","Accrual","+ Payables","+ Prepaids","- Payables","- Prepaids","Cash/Tax"]
[null,"Point of Sale Adjustments",null,575,null,null,null,null,null,{"$f":"F48+G48-H48-I48","v":0}]
[null,"Forage (Including Pellets, Silage)",null,{"$f":"IF(B49=\"\",\"\",VLOOKUP(B49,[3]!AllowableCode,2,FALSE))","v":264},675000,null,null,null,null,{"$f":"F49+G49-H49-I49","v":0}]
[null,"Wheat",null,{"$f":"IF(B50=\"\",\"\",VLOOKUP(B50,[3]!AllowableCode,2,FALSE))","v":56},10000,null,null,null,null,0]
[null,"Barley",null,{"$f":"IF(B51=\"\",\"\",VLOOKUP(B51,[3]!AllowableCode,2,FALSE))","v":3},10000,null,null,null,null,0]
[null,"Oats",null,{"$f":"IF(B52=\"\",\"\",VLOOKUP(B52,[3]!AllowableCode,2,FALSE))","v":45},5000,null,null,null,null,0]
[null,"Cattle, Feeder",null,{"$f":"IF(B53=\"\",\"\",VLOOKUP(B53,[3]!AllowableCode,2,FALSE))","v":721},500000,150000,null,250000,null,-100000]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,"Total C",null,null,{"$f":"SUM(E48:E56)","v":1200000},{"$f":"SUM(F48:F56)","v":150000},0,250000,0,{"$f":"SUM(J48:J56)","v":-100000}]
[]
[null,null,null,null,null,"Opening","Closing","Closing","Opening"]
[null,"Allowable Expenses",null,"Line","Accrual","+ Payables  ","+ Prepaids  ","- Payables  ","- Prepaids  ","= Cash/Tax"]
[null,"Containers and twine",null,9661,60000,null,50000,null,20000,{"$f":"F61+G61-H61-I61","v":30000}]
[null,"Fertilizers and soil supplements",null,9662,null,null,null,null,null,{"$f":"F62+G62-H62-I62","v":0}]
[null,"Pesticides and chemical treatments",null,9663,7000,null,null,null,null,0]
[null,"Insurance premiums (crop or production)",null,9665,null,null,null,null,null,0]
[null,"Veterinary fees, medicine, and breeding fees",null,9713,null,null,null,null,null,0]
[null,"Minerals and salts",null,9714,null,null,null,null,null,0]
[null,"Machinery (gasoline, diesel fuel, oil)",null,9764,80000,2000,null,null,null,2000]
[null,"Electricity",null,9799,4000,null,null,null,null,0]
[null,"Freight and shipping",null,9801,null,null,null,null,null,0]
[null,"Heating fuel",null,9802,null,null,null,null,null,0]
[null,"Arm's length salaries",null,9815,null,null,null,null,null,0]
[null,"Storage and drying",null,9822,null,null,null,null,null,0]
[null,"Commissions and levies",null,9836,null,null,null,null,null,0]
[null,"Private insurance premiums for commodities",null,9953,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,"Total D",null,null,{"$f":"SUM(E61:E75)","v":151000},2000,50000,0,20000,{"$f":"SUM(J61:J75)","v":32000}]
[]
[null,null,null,null,null,"Opening","Closing","Closing","Opening"]
[null,"Non-Allowable Expenses",null,"Line","Accrual","+ Payables    ","+ Prepaids   ","- Payables  ","- Prepaids  ","= Cash/Tax"]
[null,"Machinery (repairs, licenses, insurance)",null,9760,null,null,null,null,null,{"$f":"F80+G80-H80-I80","v":0}]
[null,"Machinery lease/rental",null,9765,6000,null,null,5000,null,{"$f":"F81+G81-H81-I81","v":-5000}]
[null,"Advertising and promotion costs",null,9792,null,null,null,null,null,0]
[null,"Building and fence repairs",null,9795,1000,null,null,null,null,0]
[null,"Land clearing and draining",null,9796,null,null,null,null,null,0]
[null,"Agricultural contract work",null,9798,45000,2000,null,5000,null,-3000]
[null,"Other insurance premiums",null,9804,1000,null,null,null,null,0]
[null,"Interest (real estate, mortgage, other)",null,9805,46000,null,null,null,null,0]
[null,"Memberships/subscription fees",null,9807,null,null,null,null,null,0]
[null,"Office expenses",null,9808,null,null,null,null,null,0]
[null,"Legal and accounting fees",null,9809,5000,5000,null,3000,null,2000]
[null,"Property taxes",null,9810,null,null,null,null,null,0]
[null,"Rent (land, buildings, pastures)",null,9811,30000,null,null,null,null,0]
[null,"Non-arm's length salaries",null,9816,null,null,null,null,null,0]
[null,"Motor vehicle expenses",null,9819,null,null,null,null,null,0]
[null,"Small tools",null,9820,3000,null,null,null,null,0]
[null,"Soil testing",null,9821,null,null,null,null,null,0]
[null,"Licenses/permits",null,9823,null,null,null,null,null,0]
[null,"Telephone",null,9824,null,null,null,null,null,0]
[null,"Quota rental (tobacco, dairy)",null,9825,null,null,null,null,null,0]
[null,"Gravel",null,9826,null,null,null,null,null,0]
[null,"Purchases of commodities resold",null,9827,null,null,null,null,null,0]
[null,"Motor vehicle interest and leasing costs",null,9829,null,null,null,null,null,0]
[null,"Other (specify)",null,9896,2000,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,"Total E",null,null,{"$f":"SUM(E80:E105)","v":139000},{"$f":"SUM(F80:F105)","v":7000},0,13000,0,-6000]
[]
[null,"Total Expense (Total C + Total D + Total E)",null,null,{"$f":"E57+E76+E106","v":1490000},{"$f":"F57+F76+F106","v":159000},50000,263000,20000,-74000]
[]
[null,"Other Adjustments",null,null,"Accrual",null,null,null,"Cash/Tax"]
[null,null,"`",null,"Add","Deduct",null,null,"Add","Deduct"]
[null,"Depreciation",null,null,null,70000]
[null,"Gain on sale",null,null,4000]
[null,"Loss on sale"]
[null,"Dividend Income",null,null,50000]
[]
[null,"Taxable capital gains",null,9600,null,null,null,null,3000]
[null,"Allowance on eligible capital property",null,9935]
[null,"Capital cost allowance",null,9936,null,null,null,null,null,80000]
[null,"Mandatory Inventory Adjustment Prior Year",null,9937]
[null,"Optional Inventory Adjustment Prior Year",null,9938,null,null,null,null,null,140000]
[null,"Optional Inventory Adjustment Current Year",null,9941,null,null,null,null,120000]
[null,"Mandatory Inventory Adjustment Current Year",null,9942]
[]
[]
[null,"Total Other Adjustments",null,null,{"$f":"SUM(E112:E124)","v":54000},{"$f":"-SUM(F112:F124)","v":-70000},null,null,{"$f":"SUM(I112:I124)","v":123000},{"$f":"-SUM(J112:J124)","v":-220000}]
[]
[null,"Accrual Income/Loss"]
[]
[null,"Worksheet",null,null,{"$f":"E33+E42-E108+E126+F126","v":90000},null,null,"Worksheet",null,{"$f":"J33+J42-J108+I126+J126","v":1823000}]
[null,"T2 (Sch 1)",null,null,90000,null,null,"T2 (Sch 1)",null,333000]
[null,"Difference",null,null,null,null,null,"Difference"]

{"sheet":"Worksheet Example","index":2,"n_rows":196,"n_cols":10,"rows_kept":196,"cut":false,"hidden":false,"merged":[[194,1,194,9],[195,3,195,4],[195,5,195,6],[195,8,195,9],[181,1,181,2],[181,6,181,7],[184,1,184,2],[186,1,186,2],[187,1,187,2],[188,1,188,2],[191,1,191,9],[177,1,177,2],[177,6,177,7],[178,1,178,2],[178,6,178,7],[179,1,179,2],[179,6,179,7],[174,1,174,2],[174,6,174,7],[175,1,175,2],[175,6,175,7],[176,1,176,2],[176,6,176,7],[171,1,171,2],[171,6,171,7],[172,1,172,2],[172,6,172,7],[173,1,173,2],[173,6,173,7],[168,1,168,2],[168,6,168,7],[169,1,169,2],[169,6,169,7],[170,1,170,2],[170,6,170,7],[165,1,165,2],[165,6,165,7],[166,1,166,2],[166,6,166,7],[167,1,167,2],[167,6,167,7],[162,1,162,2],[162,6,162,7],[163,1,163,2],[163,6,163,7],[164,1,164,2],[164,6,164,7],[158,6,158,7],[159,1,159,2],[159,6,159,7],[160,1,160,2],[160,6,160,7],[161,1,161,2],[161,6,161,7],[149,1,149,2],[150,1,150,2],[151,1,151,2],[152,1,152,2],[157,4,157,5],[157,8,157,9],[143,1,143,2],[144,1,144,2],[145,1,145,2],[146,1,146,2],[147,1,147,2],[148,1,148,2],[137,1,137,2],[138,1,138,2],[139,1,139,2],[140,1,140,2],[141,1,141,2],[142,1,142,2],[131,1,131,2],[132,1,132,2],[133,1,133,2],[134,1,134,2],[135,1,135,2],[136,1,136,2],[125,1,125,2],[126,1,126,2],[127,1,127,2],[128,1,128,2],[129,1,129,2],[130,1,130,2],[116,1,116,2],[117,1,117,2],[118,1,118,2],[122,1,122,2],[123,1,123,2],[124,1,124,2],[110,1,110,2],[111,1,111,2],[112,1,112,2],[113,1,113,2],[114,1,114,2],[115,1,115,2],[104,1,104,2],[105,1,105,2],[106,1,106,2],[107,1,107,2],[108,1,108,2],[109,1,109,2],[95,1,95,2],[96,1,96,2],[97,1,97,2],[101,1,101,2],[102,1,102,2],[103,1,103,2],[89,1,89,2],[90,1,90,2],[91,1,91,2],[92,1,92,2],[93,1,93,2],[94,1,94,2],[83,1,83,2],[84,1,84,2],[85,1,85,2],[86,1,86,2],[87,1,87,2],[88,1,88,2],[77,1,77,2],[78,1,78,2],[79,1,79,2],[80,1,80,2],[81,1,81,2],[82,1,82,2],[56,1,56,2],[58,1,58,3],[60,1,61,1],[60,8,61,9],[66,1,66,2],[67,1,67,2],[50,1,50,2],[51,1,51,2],[52,1,52,2],[53,1,53,2],[54,1,54,2],[55,1,55,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[47,1,47,2],[48,1,48,2],[49,1,49,2],[34,1,34,2],[35,1,35,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[7,4,7,6],[7,7,7,9],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[3,1,3,2],[3,3,3,4],[3,5,3,6],[3,7,3,8],[4,1,4,2],[4,3,4,4],[4,5,4,6],[4,7,4,8],[16,1,16,2]]}
[null,null,null,"Fiscal Period:","Year",null,"Month",null,"Day"]
[]
[]
[null,"Business Name",null,"Identification Number",null,"Subscription",null,"AgriStability PIN",null,"Year"]
[]
[]
[]
[null,null,null,null,"Financial Statements:\nStatement of Income (Loss)",null,null,"Net Income (Loss)\nfor Income Tax Purposes"]
[null,"Revenue"]
[]
[null,null,null,"T1163",null,"Opening",null,"Closing"]
[null,"Commodity Sales and Program Payments",null,"Code","Accrual   +","Receivables","-","Receivables","=","Cash/Tax"]
[null,null,null,{"$f":"IF(ISBLANK(B13),\"\",VLOOKUP(B13,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,{"$f":"(E13+F13-H13)","v":0}]
[null,null,null,{"$f":"IF(ISBLANK(B14),\"\",VLOOKUP(B14,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,{"$f":"(E14+F14-H14)","v":0}]
[null,null,null,{"$f":"IF(ISBLANK(B15),\"\",VLOOKUP(B15,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B16),\"\",VLOOKUP(B16,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B17),\"\",VLOOKUP(B17,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B18),\"\",VLOOKUP(B18,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B19),\"\",VLOOKUP(B19,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B20),\"\",VLOOKUP(B20,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B21),\"\",VLOOKUP(B21,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B22),\"\",VLOOKUP(B22,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B23),\"\",VLOOKUP(B23,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B24),\"\",VLOOKUP(B24,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B25),\"\",VLOOKUP(B25,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B26),\"\",VLOOKUP(B26,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B27),\"\",VLOOKUP(B27,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B28),\"\",VLOOKUP(B28,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B29),\"\",VLOOKUP(B29,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B30),\"\",VLOOKUP(B30,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B31),\"\",VLOOKUP(B31,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B32),\"\",VLOOKUP(B32,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B33),\"\",VLOOKUP(B33,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B34),\"\",VLOOKUP(B34,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B35),\"\",VLOOKUP(B35,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,"Total A",null,null,{"$f":"SUM(E13:E35)","v":0},{"$f":"SUM(F13:F35)","v":0},null,{"$f":"SUM(H13:H35)","v":0},null,{"$f":"SUM(J13:J35)","v":0}]
[]
[null,null,null,null,null,"Opening",null,"Closing"]
[null,"Other Farming Income",null,"Line","Accrual +","Receivables","-","Receivables","=","Cash/Tax"]
[null,"Other program payments",null,9540,null,null,null,null,null,{"$f":"(E40+F40-H40)","v":0}]
[null,"Business Risk Management (BRM) and disaster assistance program payments",null,9544,null,null,null,null,null,{"$f":"(E41+F41-H41)","v":0}]
[null,"Resales, Rebates, GST/HST for allowable exp",null,9574,null,null,null,null,null,0]
[null,"Resales, Rebates, GST/HST for non-allowable expenses",null,9575,null,null,null,null,null,0]
[null,"Agricultural contract work",null,9601,null,null,null,null,null,0]
[null,"Patronage dividends",null,9605,null,null,null,null,null,0]
[null,"Interest",null,9607,null,null,null,null,null,0]
[null,"Gravel",null,9610,null,null,null,null,null,0]
[null,"Trucking (farm - related only)",null,9611,null,null,null,null,null,0]
[null,"Resales of commodities purchased",null,9612,null,null,null,null,null,0]
[null,"Leases (gas, oil well, surface, etc.)",null,9613,null,null,null,null,null,0]
[null,"Machine rentals",null,9614,null,null,null,null,null,0]
[null,"Other (specify)",null,9600,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,{"$f":"(E55+F55-H55)","v":0}]
[null,null,null,null,null,null,null,null,null,0]
[null,"Total B",null,null,{"$f":"SUM(E40:E56)","v":0},{"$f":"SUM(F40:F56)","v":0},null,{"$f":"SUM(H40:H56)","v":0},null,{"$f":"SUM(J40:J56)","v":0}]
[]
[null,"Total Revenue (Total A + Total B)",null,null,{"$f":"(E36+E57)","v":0},{"$f":"(F36+F57)","v":0},null,{"$f":"(H36+H57)","v":0},null,{"$f":"(J36+J57)","v":0}]
[]
[null,"AB3007",null,null,null,null,null,null,"Form A5013-01"]
[]
[]
[null,"Inventory"]
[null,null,null,null,null,null,"Opening",null,"Closing"]
[null,null,null,null,"Accrual",null,"Inventories",null,"Inventories","Cash/Tax"]
[null,"Opening Inventory",null,null,null,null,{"$f":"-E67","v":0},null,null,{"$f":"(E67+G67)","v":0}]
[null,"Closing Inventory",null,null,null,null,null,null,{"$f":"-E68","v":0},{"$f":"(E68+I68)","v":0}]
[]
[null,"Change in Inventory",null,null,{"$f":"E68-E67","v":0},null,{"$f":"G68-G67","v":0},null,{"$f":"(I68-I67)","v":0},{"$f":"(J68-J37)","v":0}]
[]
[]
[]
[null,"Expenses"]
[]
[null,"Commodity Purchases and",null,"T1163",null,"Opening","Closing","Closing","Opening"]
[null,"Repayment of Program Benefits",null,"Code","Accrual","+ Payables","+ Prepaids","- Payables","- Prepaids","Cash/Tax"]
[null,"Point of Sale Adjustments",null,575,null,null,null,null,null,{"$f":"E78+F78+G78-H78-I78","v":0}]
[null,null,null,{"$f":"IF(ISBLANK(B79),\"\",VLOOKUP(B79,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,{"$f":"E79+F79+G79-H79-I79","v":0}]
[null,null,null,{"$f":"IF(ISBLANK(B80),\"\",VLOOKUP(B80,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B81),\"\",VLOOKUP(B81,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B82),\"\",VLOOKUP(B82,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B83),\"\",VLOOKUP(B83,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B84),\"\",VLOOKUP(B84,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B85),\"\",VLOOKUP(B85,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B86),\"\",VLOOKUP(B86,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B87),\"\",VLOOKUP(B87,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B88),\"\",VLOOKUP(B88,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B89),\"\",VLOOKUP(B89,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B90),\"\",VLOOKUP(B90,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B91),\"\",VLOOKUP(B91,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B92),\"\",VLOOKUP(B92,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B93),\"\",VLOOKUP(B93,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B94),\"\",VLOOKUP(B94,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B95),\"\",VLOOKUP(B95,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B96),\"\",VLOOKUP(B96,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B97),\"\",VLOOKUP(B97,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,"Total C",null,null,{"$f":"SUM(E78:E97)","v":0},{"$f":"SUM(F78:F97)","v":0},0,0,0,0]
[]
[null,null,null,null,null,"Opening","Closing","Closing","Opening"]
[null,"Allowable Expenses",null,"Line","Accrual","+ Payables  ","+ Prepaids  ","- Payables  ","- Prepaids  ","= Cash/Tax"]
[null,"Containers and twine",null,9661,null,null,null,null,null,{"$f":"(E102+F102+G102-H102-I102)","v":0}]
[null,"Fertilizers and soil supplements",null,9662,null,null,null,null,null,{"$f":"(E103+F103+G103-H103-I103)","v":0}]
[null,"Pesticides and chemical treatments",null,9663,null,null,null,null,null,0]
[null,"Insurance premiums (crop or production)",null,9665,null,null,null,null,null,0]
[null,"Veterinary fees, medicine, and breeding fees",null,9713,null,null,null,null,null,0]
[null,"Minerals and salts",null,9714,null,null,null,null,null,0]
[null,"Machinery (gasoline, diesel fuel, oil)",null,9764,null,null,null,null,null,0]
[null,"Electricity",null,9799,null,null,null,null,null,0]
[null,"Freight and shipping",null,9801,null,null,null,null,null,0]
[null,"Heating fuel",null,9802,null,null,null,null,null,0]
[null,"Arm's length salaries",null,9815,null,null,null,null,null,0]
[null,"Storage and drying",null,9822,null,null,null,null,null,0]
[null,"Commissions and levies",null,9836,null,null,null,null,null,0]
[null,"Private insurance premiums for commodities",null,9953,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,{"$f":"(E118+F118+G118-H118-I118)","v":0}]
[null,"Total D",null,null,{"$f":"SUM(E102:E118)","v":0},0,0,0,0,0]
[]
[null,null,null,null,null,"Opening","Closing","Closing","Opening"]
[null,"Non-Allowable Expenses",null,"Line","Accrual","+ Payables    ","+ Prepaids   ","- Payables  ","- Prepaids  ","= Cash/Tax"]
[null,"Machinery (repairs, licenses, insurance)",null,9760,null,null,null,null,null,{"$f":"(E123+F123+G123-H123-I123)","v":0}]
[null,"Machinery lease/rental",null,9765,null,null,null,null,null,{"$f":"(E124+F124+G124-H124-I124)","v":0}]
[null,"Advertising and promotion costs",null,9792,null,null,null,null,null,0]
[null,"Building and fence repairs",null,9795,null,null,null,null,null,0]
[null,"Land clearing and draining",null,9796,null,null,null,null,null,0]
[null,"Agricultural contract work",null,9798,null,null,null,null,null,0]
[null,"Other insurance premiums",null,9804,null,null,null,null,null,0]
[null,"Interest (real estate, mortgage, other)",null,9805,null,null,null,null,null,0]
[null,"Memberships/subscription fees",null,9807,null,null,null,null,null,0]
[null,"Office expenses",null,9808,null,null,null,null,null,0]
[null,"Legal and accounting fees",null,9809,null,null,null,null,null,0]
[null,"Property taxes",null,9810,null,null,null,null,null,0]
[null,"Rent (land, buildings, pastures)",null,9811,null,null,null,null,null,0]
[null,"Non-arm's length salaries",null,9816,null,null,null,null,null,0]
[null,"Motor vehicle expenses",null,9819,null,null,null,null,null,0]
[null,"Small tools",null,9820,null,null,null,null,null,0]
[null,"Soil testing",null,9821,null,null,null,null,null,0]
[null,"Licenses/permits",null,9823,null,null,null,null,null,0]
[null,"Telephone",null,9824,null,null,null,null,null,0]
[null,"Quota rental (tobacco, dairy)",null,9825,null,null,null,null,null,0]
[null,"Gravel",null,9826,null,null,null,null,null,0]
[null,"Purchases of commodities resold",null,9827,null,null,null,null,null,0]
[null,"Motor vehicle interest and leasing costs",null,9829,null,null,null,null,null,0]
[null,"Other (specify)",null,9896,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,"Total E",null,null,{"$f":"SUM(E123:E152)","v":0},{"$f":"SUM(F123:F152)","v":0},0,0,0,0]
[]
[null,"Total Expense (Total C + Total D + Total E)",null,null,{"$f":"(E98+E119+E153)","v":0},{"$f":"(F98+F119+F153)","v":0},0,0,0,0]
[]
[]
[null,"Other Adjustments",null,null,"Accrual",null,null,null,"Cash/Tax"]
[null,null,"`",null,"Add","Deduct",null,null,"Add","Deduct"]
[null,"Depreciation"]
[null,"Gain on sale"]
[null,"Loss on sale"]
[null,"Dividend Income"]
[]
[]
[]
[]
[]
[null,"Taxable capital gains",null,9600]
[null,"Allowance on eligible capital property",null,9935]
[null,"Capital cost allowance",null,9936]
[null,"Mandatory Inventory Adjustment Prior Year",null,9937]
[null,"Optional Inventory Adjustment Prior Year",null,9938]
[null,"Optional Inventory Adjustment Current Year",null,9941]
[null,"Mandatory Inventory Adjustment Current Year",null,9942]
[]
[]
[]
[]
[]
[]
[null,"Total Other Adjustments",null,null,{"$f":"SUM(E160:E180)","v":0},{"$f":"-SUM(F160:F180)","v":0},null,null,{"$f":"SUM(I160:I180)","v":0},{"$f":"-SUM(J160:J180)","v":0}]
[]
[]
[null,"Accrual Income/Loss",null,null,null,null,null,"Cash Income/Loss"]
[]
[null,"Worksheet",null,null,{"$f":"(E59+E70-E155+E182+F182)","v":0},null,null,"Worksheet",null,{"$f":"(J59+J70-J155+J182+I182)","v":0}]
[null,"Income (Loss) before Income Taxes",null,null,null,null,null,"T2 (Sch 1)"]
[null,"Difference",null,null,{"$f":"E187-E188","v":0},null,null,"Difference",null,{"$f":"J187-J188","v":0}]
[]
[null,"Disclaimer of Use"]
[null,"The 2024 Corporate Accrual to Tax Conversion Worksheet is a preliminary form containing RC4060 codes from 2023. The 2024 Corporate Accrual to Tax Conversion Worksheet is subject to change following the release of the 2024 RC4060 commodity and program payment codes as provided by the Canadian Revenue Agency (CRA). The CRA release date for RC4060 codes is unknown. The form will be updated following the release of RC4060 codes. AFSC does not warrant or represent that the information within the preliminary form is entirely accurate."]
[]
[null,"Freedom of Information and Protection of Privacy"]
[null,"The information on this form and any information you provide to us in the future related to this form is collected under the authority of the Agriculture Financial Services Act and the Freedom of Information and Protection of Privacy Act (the FOIP Act).  The collected information, whether personal information or business information, will be used: (i) to evaluate your eligibility for the program to which this form relates; (ii) for the administration of the program; and/ or (iii) for the administration of any other AFSC program or benefit in which you participate.  Your personal information is subject to the provisions of the FOIP Act.  \n\nBy signing this form below, you are providing your consent to AFSC disclosing and sharing the information contained on this form, whether personal information or business information, or any other information that will be provided in the future by you or your authorized representative, to the following third parties: Alberta Agriculture and Forestry, Agriculture and Agri-Food Canada, Canada Revenue Agency and Statistics Canada.  You consent that such disclosed and shared personal information and business information may be used in the following ways: (i) for the administration of all current and future AFSC federal and provincial programs related to agriculture, AFSC lending programs and AFSC insurance programs; (ii) for AFSC, federal and provincial policy and program development; and (iii) AFSC, federal, and provincial policy and program evaluation; (iv) for research and statistical development; and (v) for statistical purposes.  \n\nIf you have any questions about this form and the collection and use of your information, please contact the AFSC Client Contact Centre, 5718 - 56 Avenue, Lacombe AB   T4L 1B1, 1.877.899.2372."]
[null,"Print Name",null,"Client Signature",null,null,null,"Date","2023-04-26"]

{"sheet":"Worksheet (blank) template","index":3,"n_rows":196,"n_cols":10,"rows_kept":196,"cut":false,"hidden":false,"merged":[[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[3,1,3,2],[3,3,3,4],[3,5,3,6],[3,7,3,8],[16,1,16,2],[4,3,4,4],[17,1,17,2],[34,1,34,2],[35,1,35,2],[40,1,40,2],[41,1,41,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[51,1,51,2],[55,1,55,2],[56,1,56,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[47,1,47,2],[54,1,54,2],[52,1,52,2],[53,1,53,2],[58,1,58,3],[66,1,66,2],[67,1,67,2],[77,1,77,2],[86,1,86,2],[87,1,87,2],[60,1,61,1],[78,1,78,2],[79,1,79,2],[80,1,80,2],[81,1,81,2],[82,1,82,2],[83,1,83,2],[84,1,84,2],[85,1,85,2],[97,1,97,2],[101,1,101,2],[102,1,102,2],[103,1,103,2],[104,1,104,2],[105,1,105,2],[88,1,88,2],[89,1,89,2],[94,1,94,2],[95,1,95,2],[96,1,96,2],[91,1,91,2],[92,1,92,2],[93,1,93,2],[90,1,90,2],[112,1,112,2],[113,1,113,2],[114,1,114,2],[118,1,118,2],[122,1,122,2],[117,1,117,2],[115,1,115,2],[116,1,116,2],[106,1,106,2],[107,1,107,2],[108,1,108,2],[109,1,109,2],[110,1,110,2],[111,1,111,2],[140,1,140,2],[129,1,129,2],[130,1,130,2],[131,1,131,2],[132,1,132,2],[133,1,133,2],[134,1,134,2],[123,1,123,2],[124,1,124,2],[125,1,125,2],[126,1,126,2],[127,1,127,2],[128,1,128,2],[135,1,135,2],[136,1,136,2],[137,1,137,2],[138,1,138,2],[139,1,139,2],[157,8,157,9],[158,6,158,7],[159,1,159,2],[159,6,159,7],[141,1,141,2],[142,1,142,2],[143,1,143,2],[144,1,144,2],[145,1,145,2],[150,1,150,2],[146,1,146,2],[147,1,147,2],[148,1,148,2],[149,1,149,2],[151,1,151,2],[152,1,152,2],[157,4,157,5],[187,1,187,2],[188,1,188,2],[173,1,173,2],[173,6,173,7],[174,1,174,2],[174,6,174,7],[179,1,179,2],[179,6,179,7],[178,6,178,7],[177,1,177,2],[177,6,177,7],[181,1,181,2],[175,1,175,2],[186,1,186,2],[175,6,175,7],[176,1,176,2],[176,6,176,7],[178,1,178,2],[160,1,160,2],[161,1,161,2],[162,1,162,2],[164,1,164,2],[181,6,181,7],[184,1,184,2],[160,6,160,7],[161,6,161,7],[162,6,162,7],[170,6,170,7],[171,6,171,7],[172,6,172,7],[167,6,167,7],[168,6,168,7],[169,6,169,7],[170,1,170,2],[171,1,171,2],[172,1,172,2],[168,1,168,2],[169,1,169,2],[191,1,191,9],[167,1,167,2],[195,5,195,6],[195,8,195,9],[4,1,4,2],[4,5,4,6],[4,7,4,8],[194,1,194,9],[195,3,195,4],[7,4,7,6],[60,8,61,9],[7,7,7,9],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[166,1,166,2],[166,6,166,7],[165,1,165,2],[165,6,165,7],[163,1,163,2],[163,6,163,7],[164,6,164,7]]}
[null,null,null,"Fiscal Period:","Year",null,"Month",null,"Day"]
[]
[]
[null,"Business Name",null,"Identification Number",null,"Subscription",null,"AgriStability PIN",null,"Year"]
[]
[]
[]
[null,null,null,null,"Financial Statements:\nStatement of Income (Loss)",null,null,"Net Income (Loss)\nfor Income Tax Purposes"]
[null,"Revenue"]
[]
[null,null,null,"T1163",null,"Opening",null,"Closing"]
[null,"Commodity Sales and Program Payments",null,"Code","Accrual   +","Receivables","-","Receivables","=","Cash/Tax"]
[null,null,null,{"$f":"IF(ISBLANK(B13),\"\",VLOOKUP(B13,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,{"$f":"(E13+F13-H13)","v":0}]
[null,null,null,{"$f":"IF(ISBLANK(B14),\"\",VLOOKUP(B14,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,{"$f":"(E14+F14-H14)","v":0}]
[null,null,null,{"$f":"IF(ISBLANK(B15),\"\",VLOOKUP(B15,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B16),\"\",VLOOKUP(B16,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B17),\"\",VLOOKUP(B17,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B18),\"\",VLOOKUP(B18,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B19),\"\",VLOOKUP(B19,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B20),\"\",VLOOKUP(B20,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B21),\"\",VLOOKUP(B21,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B22),\"\",VLOOKUP(B22,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B23),\"\",VLOOKUP(B23,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B24),\"\",VLOOKUP(B24,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B25),\"\",VLOOKUP(B25,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B26),\"\",VLOOKUP(B26,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B27),\"\",VLOOKUP(B27,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B28),\"\",VLOOKUP(B28,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B29),\"\",VLOOKUP(B29,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B30),\"\",VLOOKUP(B30,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B31),\"\",VLOOKUP(B31,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B32),\"\",VLOOKUP(B32,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B33),\"\",VLOOKUP(B33,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B34),\"\",VLOOKUP(B34,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B35),\"\",VLOOKUP(B35,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,"Total A",null,null,{"$f":"SUM(E13:E35)","v":0},{"$f":"SUM(F13:F35)","v":0},null,{"$f":"SUM(H13:H35)","v":0},null,{"$f":"SUM(J13:J35)","v":0}]
[]
[null,null,null,null,null,"Opening",null,"Closing"]
[null,"Other Farming Income",null,"Line","Accrual +","Receivables","-","Receivables","=","Cash/Tax"]
[null,"Other program payments",null,9540,null,null,null,null,null,{"$f":"(E40+F40-H40)","v":0}]
[null,"Business Risk Management (BRM) and disaster assistance program payments",null,9544,null,null,null,null,null,{"$f":"(E41+F41-H41)","v":0}]
[null,"Resales, Rebates, GST/HST for allowable exp",null,9574,null,null,null,null,null,0]
[null,"Resales, Rebates, GST/HST for non-allowable expenses",null,9575,null,null,null,null,null,0]
[null,"Agricultural contract work",null,9601,null,null,null,null,null,0]
[null,"Patronage dividends",null,9605,null,null,null,null,null,0]
[null,"Interest",null,9607,null,null,null,null,null,0]
[null,"Gravel",null,9610,null,null,null,null,null,0]
[null,"Trucking (farm - related only)",null,9611,null,null,null,null,null,0]
[null,"Resales of commodities purchased",null,9612,null,null,null,null,null,0]
[null,"Leases (gas, oil well, surface, etc.)",null,9613,null,null,null,null,null,0]
[null,"Machine rentals",null,9614,null,null,null,null,null,0]
[null,"Other (specify)",null,9600,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,{"$f":"(E55+F55-H55)","v":0}]
[null,null,null,null,null,null,null,null,null,0]
[null,"Total B",null,null,{"$f":"SUM(E40:E56)","v":0},{"$f":"SUM(F40:F56)","v":0},null,{"$f":"SUM(H40:H56)","v":0},null,{"$f":"SUM(J40:J56)","v":0}]
[]
[null,"Total Revenue (Total A + Total B)",null,null,{"$f":"(E36+E57)","v":0},{"$f":"(F36+F57)","v":0},null,{"$f":"(H36+H57)","v":0},null,{"$f":"(J36+J57)","v":0}]
[]
[null,"AB3007",null,null,null,null,null,null,"Form A5013-01"]
[]
[]
[null,"Inventory"]
[null,null,null,null,null,null,"Opening",null,"Closing"]
[null,null,null,null,"Accrual",null,"Inventories",null,"Inventories","Cash/Tax"]
[null,"Opening Inventory",null,null,null,null,{"$f":"-E67","v":0},null,null,{"$f":"(E67+G67)","v":0}]
[null,"Closing Inventory",null,null,null,null,null,null,{"$f":"-E68","v":0},{"$f":"(E68+I68)","v":0}]
[]
[null,"Change in Inventory",null,null,{"$f":"E68-E67","v":0},null,{"$f":"G68-G67","v":0},null,{"$f":"(I68-I67)","v":0},{"$f":"(J68-J37)","v":0}]
[]
[]
[]
[null,"Expenses"]
[]
[null,"Commodity Purchases and",null,"T1163",null,"Opening","Closing","Closing","Opening"]
[null,"Repayment of Program Benefits",null,"Code","Accrual","+ Payables","+ Prepaids","- Payables","- Prepaids","Cash/Tax"]
[null,"Point of Sale Adjustments",null,575,null,null,null,null,null,{"$f":"E78+F78+G78-H78-I78","v":0}]
[null,null,null,{"$f":"IF(ISBLANK(B79),\"\",VLOOKUP(B79,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,{"$f":"E79+F79+G79-H79-I79","v":0}]
[null,null,null,{"$f":"IF(ISBLANK(B80),\"\",VLOOKUP(B80,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B81),\"\",VLOOKUP(B81,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B82),\"\",VLOOKUP(B82,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B83),\"\",VLOOKUP(B83,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B84),\"\",VLOOKUP(B84,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B85),\"\",VLOOKUP(B85,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B86),\"\",VLOOKUP(B86,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B87),\"\",VLOOKUP(B87,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B88),\"\",VLOOKUP(B88,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B89),\"\",VLOOKUP(B89,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B90),\"\",VLOOKUP(B90,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B91),\"\",VLOOKUP(B91,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B92),\"\",VLOOKUP(B92,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B93),\"\",VLOOKUP(B93,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B94),\"\",VLOOKUP(B94,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B95),\"\",VLOOKUP(B95,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B96),\"\",VLOOKUP(B96,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,null,null,{"$f":"IF(ISBLANK(B97),\"\",VLOOKUP(B97,'Tax Codes'!$A$2:$B$305,2,FALSE))","v":""},null,null,null,null,null,0]
[null,"Total C",null,null,{"$f":"SUM(E78:E97)","v":0},{"$f":"SUM(F78:F97)","v":0},0,0,0,0]
[]
[null,null,null,null,null,"Opening","Closing","Closing","Opening"]
[null,"Allowable Expenses",null,"Line","Accrual","+ Payables  ","+ Prepaids  ","- Payables  ","- Prepaids  ","= Cash/Tax"]
[null,"Containers and twine",null,9661,null,null,null,null,null,{"$f":"(E102+F102+G102-H102-I102)","v":0}]
[null,"Fertilizers and soil supplements",null,9662,null,null,null,null,null,{"$f":"(E103+F103+G103-H103-I103)","v":0}]
[null,"Pesticides and chemical treatments",null,9663,null,null,null,null,null,0]
[null,"Insurance premiums (crop or production)",null,9665,null,null,null,null,null,0]
[null,"Veterinary fees, medicine, and breeding fees",null,9713,null,null,null,null,null,0]
[null,"Minerals and salts",null,9714,null,null,null,null,null,0]
[null,"Machinery (gasoline, diesel fuel, oil)",null,9764,null,null,null,null,null,0]
[null,"Electricity",null,9799,null,null,null,null,null,0]
[null,"Freight and shipping",null,9801,null,null,null,null,null,0]
[null,"Heating fuel",null,9802,null,null,null,null,null,0]
[null,"Arm's length salaries",null,9815,null,null,null,null,null,0]
[null,"Storage and drying",null,9822,null,null,null,null,null,0]
[null,"Commissions and levies",null,9836,null,null,null,null,null,0]
[null,"Private insurance premiums for commodities",null,9953,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,{"$f":"(E117+F117+G117-H117-I117)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"(E118+F118+G118-H118-I118)","v":0}]
[null,"Total D",null,null,{"$f":"SUM(E102:E118)","v":0},0,0,0,0,0]
[]
[null,null,null,null,null,"Opening","Closing","Closing","Opening"]
[null,"Non-Allowable Expenses",null,"Line","Accrual","+ Payables    ","+ Prepaids   ","- Payables  ","- Prepaids  ","= Cash/Tax"]
[null,"Machinery (repairs, licenses, insurance)",null,9760,null,null,null,null,null,{"$f":"(E123+F123+G123-H123-I123)","v":0}]
[null,"Machinery lease/rental",null,9765,null,null,null,null,null,{"$f":"(E124+F124+G124-H124-I124)","v":0}]
[null,"Advertising and promotion costs",null,9792,null,null,null,null,null,0]
[null,"Building and fence repairs",null,9795,null,null,null,null,null,0]
[null,"Land clearing and draining",null,9796,null,null,null,null,null,0]
[null,"Agricultural contract work",null,9798,null,null,null,null,null,0]
[null,"Other insurance premiums",null,9804,null,null,null,null,null,0]
[null,"Interest (real estate, mortgage, other)",null,9805,null,null,null,null,null,0]
[null,"Memberships/subscription fees",null,9807,null,null,null,null,null,0]
[null,"Office expenses",null,9808,null,null,null,null,null,0]
[null,"Legal and accounting fees",null,9809,null,null,null,null,null,0]
[null,"Property taxes",null,9810,null,null,null,null,null,0]
[null,"Rent (land, buildings, pastures)",null,9811,null,null,null,null,null,0]
[null,"Non-arm's length salaries",null,9816,null,null,null,null,null,0]
[null,"Motor vehicle expenses",null,9819,null,null,null,null,null,0]
[null,"Small tools",null,9820,null,null,null,null,null,0]
[null,"Soil testing",null,9821,null,null,null,null,null,0]
[null,"Licenses/permits",null,9823,null,null,null,null,null,0]
[null,"Telephone",null,9824,null,null,null,null,null,0]
[null,"Quota rental (tobacco, dairy)",null,9825,null,null,null,null,null,0]
[null,"Gravel",null,9826,null,null,null,null,null,0]
[null,"Purchases of commodities resold",null,9827,null,null,null,null,null,0]
[null,"Motor vehicle interest and leasing costs",null,9829,null,null,null,null,null,0]
[null,"Other (specify)",null,9896,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,"Total E",null,null,{"$f":"SUM(E123:E152)","v":0},{"$f":"SUM(F123:F152)","v":0},0,0,0,0]
[]
[null,"Total Expense (Total C + Total D + Total E)",null,null,{"$f":"(E98+E119+E153)","v":0},{"$f":"(F98+F119+F153)","v":0},0,0,0,0]
[]
[]
[null,"Other Adjustments",null,null,"Accrual",null,null,null,"Cash/Tax"]
[null,null,"`",null,"Add","Deduct",null,null,"Add","Deduct"]
[null,"Depreciation"]
[null,"Gain on sale"]
[null,"Loss on sale"]
[null,"Dividend Income"]
[]
[]
[]
[]
[]
[null,"Taxable capital gains",null,9600]
[null,"Allowance on eligible capital property",null,9935]
[null,"Capital cost allowance",null,9936]
[null,"Mandatory Inventory Adjustment Prior Year",null,9937]
[null,"Optional Inventory Adjustment Prior Year",null,9938]
[null,"Optional Inventory Adjustment Current Year",null,9941]
[null,"Mandatory Inventory Adjustment Current Year",null,9942]
[]
[]
[]
[]
[]
[]
[null,"Total Other Adjustments",null,null,{"$f":"SUM(E160:E180)","v":0},{"$f":"-SUM(F160:F180)","v":0},null,null,{"$f":"SUM(I160:I180)","v":0},{"$f":"-SUM(J160:J180)","v":0}]
[]
[]
[null,"Accrual Income/Loss",null,null,null,null,null,"Cash Income/Loss"]
[]
[null,"Worksheet",null,null,{"$f":"(E59+E70-E155+E182+F182)","v":0},null,null,"Worksheet",null,{"$f":"(J59+J70-J155+J182+I182)","v":0}]
[null,"Income (Loss) before Income Taxes",null,null,null,null,null,"T2 (Sch 1)"]
[null,"Difference",null,null,{"$f":"E187-E188","v":0},null,null,"Difference",null,{"$f":"J187-J188","v":0}]
[]
[null,"Disclaimer of Use"]
[null,"The 2024 Corporate Accrual to Tax Conversion Worksheet is a preliminary form containing RC4060 codes from 2023. The 2024 Corporate Accrual to Tax Conversion Worksheet is subject to change following the release of the 2024 RC4060 commodity and program payment codes as provided by the Canadian Revenue Agency (CRA). The CRA release date for RC4060 codes is unknown. The form will be updated following the release of RC4060 codes. AFSC does not warrant or represent that the information within the preliminary form is entirely accurate."]
[]
[null,"Freedom of Information and Protection of Privacy"]
[null,"The information on this form and any information you provide to us in the future related to this form is collected under the authority of the Agriculture Financial Services Act and the Freedom of Information and Protection of Privacy Act (the FOIP Act).  The collected information, whether personal information or business information, will be used: (i) to evaluate your eligibility for the program to which this form relates; (ii) for the administration of the program; and/ or (iii) for the administration of any other AFSC program or benefit in which you participate.  Your personal information is subject to the provisions of the FOIP Act.  \n\nBy signing this form below, you are providing your consent to AFSC disclosing and sharing the information contained on this form, whether personal information or business information, or any other information that will be provided in the future by you or your authorized representative, to the following third parties: Alberta Agriculture and Forestry, Agriculture and Agri-Food Canada, Canada Revenue Agency and Statistics Canada.  You consent that such disclosed and shared personal information and business information may be used in the following ways: (i) for the administration of all current and future AFSC federal and provincial programs related to agriculture, AFSC lending programs and AFSC insurance programs; (ii) for AFSC, federal and provincial policy and program development; and (iii) AFSC, federal, and provincial policy and program evaluation; (iv) for research and statistical development; and (v) for statistical purposes.  \n\nIf you have any questions about this form and the collection and use of your information, please contact the AFSC Client Contact Centre, 5718 - 56 Avenue, Lacombe AB   T4L 1B1, 1.877.899.2372."]
[null,"Print Name",null,"Client Signature",null,null,null,"Date","2023-04-26"]

{"sheet":"Tax Codes","index":4,"n_rows":305,"n_cols":2,"rows_kept":305,"cut":false,"hidden":false,"merged":[]}
["Commodity and Allowable Program Payment Tax Codes","Code"]
["(CFIA) Payment for allowable commodities",663]
["(CFIA) Payment for other amounts",665]
["(CFIA) Payment for supply managed commodities",664]
["2021 CAN-AB Hog Recovery Initiative",778]
["2021 CAN-AB Livestock Feed Assist. Initiative (Allowable) ",776]
["2021 CAN-AB Livestock Feed Assist. Initiative (Non-Allowable)",775]
["AgriRecovery Bee Assistance Payments (allowable portion)",800]
["AgriRecovery Drought Assist. Payments (Allowable)",774]
["AgriRecovery Drought Assist. Payments (Non-Allowable) ",773]
["AgriRecovery Feed Assistance Payments (allowable portion)",801]
["AgriRecovery Flood Assistance Payments (allowable portion)",802]
["Alberta Spring Price Endorsement",495]
["Alpacas",370]
["Alternate Land Use Services (ALUS)",557]
["Anise",101]
["Apples",60]
["Apricots",91]
["Artichokes",160]
["Arugula / Rocket",195]
["Asparagus",161]
["Barley",3]
["Basil",102]
["Beans (Dry Edible)",4]
["Beans, Fresh",25]
["Bedding Plants",132]
["Bee By-Products",375]
["Bees, Honey",374]
["Bees, Leaf Cutter",312]
["Beets",162]
["Bison",350]
["Blackberries",66]
["Blueberries",67]
["Bok Choi",163]
["Borage",6]
["Broccoflower",164]
["Broccoli",165]
["Brussels Sprouts",166]
["Buckwheat",7]
["Cabbage",167]
["Camelina",282]
["CAN Food Inspection Agency (CFIA) Payment for Non-Allowable commodities",587]
["Canadian Agricultural Skills Service (CASS)",561]
["Canadian Wheat Board Payments",2]
["Canary Seed",8]
["Cannabis",382]
["Canola",10]
["Cantaloupe",168]
["Caraway Seed",103]
["Carrots",169]
["Cattle, Calves",719]
["Cattle, Cows and Bulls",706]
["Cattle, Custom Feedlot Operator Income (Itemized) - Other feed charges",576]
["Cattle, Custom Feedlot Operator Income (Itemized) - Qualifying Feed",243]
["Cattle, Custom Feedlot Operator Income (Non Itemized) - Qualifying Feed",246]
["Cattle, Fat / Slaughter",720]
["Cattle, Feeder",721]
["Cattle, Livestock Owners Custom Feeding Expense (Itemized) - Other",572]
["Cattle, Livestock Owners Custom Feeding Expense (Itemized) - Qualifying Feed and Protein Supplements",577]
["Cattle, Livestock Owners Custom Feeding Expense (Non Itemized)",573]
["Cattle, Prepared Feed - Other Feed Charges (Itemized)",570]
["Cattle, Prepared Feed and Protein Supplements (Itemized)",46]
["Cattle, Prepared Feed and Purchases (Non Itemized)",571]
["Cattle, Purebred Breeding",722]
["Cauliflower",170]
["Celery",171]
["Cherries (Sweet, Sour)",92]
["Cherry Tomatoes, Greenhouse",233]
["Chervil",158]
["Chick Peas / Garbanzo Beans",23]
["Chicken, Eggs (Non-Supply Managed)",589]
["Chickens",366]
["Chickens (Non-Supply Managed)",590]
["Chickens, Eggs for Consumption",343]
["Chickens, Eggs for Hatching",344]
["Chinchilla",240]
["Chinese Vegetables",173]
["Chives",104]
["Cilantro",105]
["Collards",174]
["Comfrey",106]
["Coriander",107]
["Corn",11]
["Cover Crop Protection Program",473]
["COVID-19 - AgriRecovery - Livestock set aside programs",699]
["COVID-19 - Other assistance payments (allowable income)",687]
["COVID-19 - Other assistance payments (non-allowable income)",688]
["COVID-19 - Temporary foreign worker subsidy payments",686]
["COVID-19 - Wage subsidy payments for arm's length salaries",684]
["COVID-19 - Wage subsidy payments for non-arm's length salaries",685]
["Cranberries",68]
["Crop Insurance: Edible Horticulture",402]
["Crop Insurance: Grains & Oilseeds",401]
["Crop Insurance: Non Edible Horticulture",470]
["Crop/Hail Insurance: Other Commodities, including livestock",463]
["Cucumbers",175]
["Cucumbers, Greenhouse",234]
["Cull Breeding Swine Program",582]
["Cumin",144]
["Currants (Black, Red)",65]
["Dairy Direct Payment Program (DDPP)",683]
["Dairy Farm Investment Program (DFIP)",682]
["Dairy Subsidies",435]
["Deer",352]
["Deferred bison          ",151]
["Deferred Bovine Cattle",150]
["Deferred deer",154]
["Deferred elk",155]
["Deferred goat",152]
["Deferred horses for PMU sales",156]
["Deferred other breeding animals",157]
["Deferred sheep",153]
["Dill",108]
["Dogs (Kennels and Pet Breeding Excluded)",313]
["Donkeys / Mules",367]
["Ducks",332]
["Echinacea",142]
["Eggplant",176]
["Elderberries",74]
["Elk",353]
["Elk Velvet",764]
["Emus",373]
["Endive",177]
["Faba Beans",12]
["Fennel",110]
["Fenugreek",111]
["Fiddleheads",179]
["Field Peas",13]
["Fireweed",377]
["Fish Meal",263]
["Flaxseed",14]
["Flowers (Edible)",180]
["Flowers and Ornamental Foliage",133]
["Forage (Including Pellets, Silage)",264]
["Forage Seed",15]
["Fox",241]
["Fruit Juice",81]
["Fruits and Vegetables (Non-Edible)",134]
["Garlic",113]
["Geese",333]
["Gherkins",221]
["Gingko Biloba",380]
["Ginseng",114]
["Goats",354]
["Gooseberries",69]
["Grain (Pellets, Screenings, Silage)",39]
["Grapefruit",82]
["Grapes",83]
["Green Peas",223]
["Green Plan, Farm Based Program - Permanent cover practices",466]
["Groundhogs / Hedgehogs",369]
["Haskap",75]
["Hemp",30]
["Honey",129]
["Horseradish",181]
["Horses",316]
["Kale",214]
["Kenaf",317]
["Khorasan Wheat / Kamut",36]
["Kiwi Fruit",84]
["Kohlrabi",182]
["Lathyrus",40]
["Lavender",379]
["Leeks",183]
["Lemon Balm",378]
["Lemons",85]
["Lentils",41]
["Lettuce",184]
["Lettuce, Greenhouse",235]
["Livestock Feed Insurance Program",412]
["Llamas",355]
["Loganberries",70]
["Lupins",42]
["Manure",318]
["Maple Products",130]
["Marjoram",115]
["Market Revenue Insurance (MRI): Edible Horticulture",411]
["Market Revenue Insurance (MRI): Grains & Oilseeds",410]
["Market Revenue Insurance (MRI): Non-Edible Horticulture",474]
["Melons",185]
["Milk and Cream (Cattle)",319]
["Milk and Cream (Non-Supply Managed)",592]
["Millet",43]
["Mink",242]
["Mint",116]
["Mixed Grain",24]
["Monarada",117]
["Mushrooms (Including Spawn)",131]
["Mustard Leaves",186]
["Mustard Seed",44]
["Nectarines",93]
["Niger Seed / Niger Thistle",283]
["Nuts (All)",140]
["Oats",45]
["Oilseed Radish",38]
["Okra",227]
["Onions",187]
["Oranges",86]
["Oregano",118]
["Ostriches",371]
["Other AgriRecovery Program (allowable income)",627]
["Other AgriRecovery Program (Non-allowable income)",632]
["Parsley",119]
["Parsnip",190]
["Partridge",323]
["Peaches",94]
["Pears",95]
["Pepper (Spice)",120]
["Peppers",191]
["Peppers - Greenhouse",236]
["Pheasants",338]
["Pigeons",327]
["Plums",96]
["Pollination Services Fee",376]
["Pot Bellied Pigs",239]
["Potatoes and By-Products",147]
["Prairie Watershed Climate Program (PWCP)",798]
["Pregnant Mare Urine (PMU)",322]
["Prepared Feed and Protein Supplements (Itemized)",46]
["Private Hail Insurance",407]
["Private Insurance Proceeds for Allowable Commodities",661]
["Private Insurance Proceeds for the Replacement of Allowable Commodities",681]
["Private Insurance proceeds for the replacement of allowable expense items        ",406]
["Production Insurance Premium Adjustment",499]
["Prunes",97]
["Pumpkins",192]
["Quail",324]
["Quinoa",47]
["Rabbits",356]
["Radish",193]
["Ranch Fur Operators Feed Purchases (Non Itemized)",574]
["Ranch Fur Operators Other Feed Expenses (Itemized)",310]
["Ranch Fur Operators, Prepared Feed and Protein Supplements (Itemized)",46]
["Raspberries",71]
["Reindeer",244]
["Resilient Agricultural Landscapes Program (RALP)",797]
["Rheas",372]
["Rhubarb",194]
["Rice",48]
["Rosemary",121]
["Rutabagas",197]
["Rye",49]
["Safflower",50]
["Sage",122]
["Salsify",123]
["Saskatchewan Cattle and Hog Support Program",593]
["Saskatchewan Crop Insurance Premium Adjustment",619]
["Saskatoon Berries",72]
["Seabuckthorn",76]
["Seeds and Bulbs",135]
["Semen and Embryos",712]
["Shallots",198]
["Sheep, Ewes and Rams",734]
["Sheep, Lambs",723]
["Shrubs",136]
["Silkies",326]
["Sod",137]
["Soybeans",53]
["Special Farm Assistance",560]
["Spelt",37]
["Spinach",201]
["Squash",202]
["St. Johns Wort",381]
["Stevia",230]
["Straw",267]
["Strawberries",73]
["Sugar Beets (Including Molasses)",268]
["Summer Savory",125]
["Sunflowers",54]
["Sweet Corn",203]
["Sweet Peas",204]
["Sweet Potatoes / Yams",205]
["Swine",341]
["Swiss Chard",206]
["Taiwanese Chickens",325]
["Tarragon",126]
["Thyme",127]
["Tobacco",269]
["Tomatoes",207]
["Tomatoes, Greenhouse",237]
["Transitional Financial Assistance Program (TFA)",427]
["Trees (Cultivated Christmas)",138]
["Trees (Fruit and Ornamental)",139]
["Triticale",55]
["Turkey Eggs",342]
["Turkeys",334]
["Turkeys (Non-Supply Managed)",591]
["Turnips",208]
["Vegetable Marrow",209]
["Vegetable Seed (Seed Production Only)",51]
["Watercress",128]
["Waterfowl/Wildlife Damage Compensation - Grains, oilseeds, and special crops",418]
["Waterfowl/Wildlife Damage Compensation - Horticulture",419]
["Waterfowl/Wildlife Damage Compensation - Other commodities",425]
["Watermelon",87]
["Weeds (Edible)",211]
["Western Livestock Price Insurance Program (WLPIP)",667]
["Wheat",56]
["Wild Boar",247]
["Wine",88]
["Witloof Chicory",212]
["Wood",259]
["Wool",328]
["Young Farmer Rebate",559]
["Zucchini - Field Fresh      ",213]