{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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":"Sheet1","index":0,"n_rows":125,"n_cols":13,"rows_kept":125,"cut":false,"hidden":false,"merged":[[85,12,85,15],[117,12,117,15],[118,12,118,15],[20,12,20,15],[20,18,20,21],[21,12,21,15],[73,12,73,15],[74,12,74,15],[84,12,84,15],[11,3,11,4],[12,3,12,4],[15,3,15,4],[54,3,54,4],[0,3,0,4],[1,3,1,4],[4,3,4,4],[5,3,5,4],[6,3,6,4],[38,3,38,4],[40,3,40,4],[43,3,43,4],[48,3,48,4],[45,3,45,6]]}
["CalFresh Income Calculator: Valid from Oct 2025 - Sept 2026",null,null,"*Note: This calculator is designed to give an estimate that is accurate for most CalFresh and/or CFAP scenarios. There are other rules and regulations to consider when determining eligiblity. This calculator does not provide legal advice."]
[null,null,null,"*Note: This calculator automatically assigns a SUA pursuant to CA's \"Heat & Eat\" option rules & standard medical deduction. "]
["I. Gross Income Eligibility Test"]
["You must complete HH(a) through HH(c) for the rest of the calculator to work.  "]
["HH(a): Number of people in the \"purchase & prepare together\" household (see Column D note):",null,null,"Include people on SSI and any ineligible noncitizen in \"purchase & prepare together\" household. DO NOT Include ineligible Students or people ineligible due to ABAWD status. "]
["HH(b): Number of people in the \"purchase & prepare\" household who have a qualifying citizen/noncitizen status AND applying w/household? (see Column D note)",null,null,"Include people on SSI, but DO NOT Include ineligible students, sanctioned hh members, an ineligible ABAWD or any ineligible noncitizen or \"uncooperative\" members in \"eat & prepare together\" household. This number must not be zero or the calculator will not work."]
["HH(c): Number of these people in the \"purchase and prepare\" household who are ineligible for reasons other than sanction or immigration status?",null,null,"Need to know in order to pro-rate shelter expenses appropriately. "]
[]
["Are any members of the household a senior or disabled?",null,"Y or N","Definition of Elderly or Disabled Household"]
[]
[]
["A1 (a). Gross Monthly Earned Income for Eligible HH Members Including Income of Sanctioned Ineligible:",null,null,"Click here for Income rules. Do not include earned income for children 18 going to school at least part-time or for ineligible students.  "]
["A1 (b). Gross Monthly Earned Income for Ineligible Noncitizen HH (or SSN/citizenship Un-Cooperative) Members:",null,null,"Click here for exemptions and deductions available to ineligible HH members. This calculator only pro-rates the earned income deduction and shelter deductions and does not automatically apply other deductions for non-HH members. "]
["A1.   Gross Monthly Earned Income of all Members in Household",{"$f":"B12+(B13*(B6/B5))","v":{"$error":"#DIV/0!"}},"(A1)"]
[]
["A2 (a). Gross Monthly Un-Earned Income for HH Members with Eligible Immigration Status Including Income of Sanctioned Ineligible:",null,null,"Do not include any income from a person ineligible due to Student Rule or ABAWD Time Limit - the whole amount is NOT listed/that person is NOT eligible. "]
["A2 (b). Gross Monthly Un-Earned Income for Ineligible Noncitizen HH Members:"]
["A2.   Gross Monthly Un-Earned Income of all Members in Household",{"$f":"B16+(B17*(B6/B5))","v":{"$error":"#DIV/0!"}},"(A2)"]
[]
["B. Amount PAID in child support by Eligible CF HH Member ",null,"(B)","200% FPL","Source: https://www.cdss.ca.gov/Portals/9/Additional-Resources/Letters-and-Notices/ACINs/2025/I-46_25.pdf?ver=KfyywOVXv5fZDkjuw5l9AA%3d%3d"]
[null,null,null,"Household Size ",1,2,3,4,5,6,7,8,"For each additional household member add…"]
["C.   Gross Monthly Income",{"$f":"((B14+B18)-B20)","v":{"$error":"#DIV/0!"}},"(C)","Maximum Gross Limit",2610,3526,4442,5360,6276,7192,8110,9026,918]
[]
["Does the family's gross income fall under the 200% gross income test?",{"$f":"IF(OR(AND(B22<=E22,B5=E21),AND(B22<=F22,B5=F21),AND(B22<=G22,B5=G21),AND(B22<=H22,B5=H21),AND(B22<=I22,B5=I21),AND(B22<=J22,B5=J21),AND(B22<=K22,B5=K21),AND(B22<=L22,B5=L21),AND(B22<=(L22+((B5-L21)*M22)),B5>L21)),\"YES\",IF(OR(B9=\"Yes\",B9=\"Y\"),\"YES\",\"NO\"))","v":{"$error":"#DIV/0!"}},null,"IF \"NO\" STOP HERE. UNLESS there is someone in the household who is Senior or Disabled. They have no gross income test and are eligible with a Gross Income ABOVE 200% as long as their assets are below Asset Test. "]
[]
["II. Net Income Eligibility Test"]
[]
[]
["D.   Gross Monthly Earned Income - Pro-rated (A1) ",{"$f":"B14","v":{"$error":"#DIV/0!"}},"(D)"]
[]
["E.   Earned Income Deduction [20% of D]",{"$f":"B29*0.2","v":{"$error":"#DIV/0!"}},"(E)"]
[]
["F.   Net Earned Income (D) - (E)",{"$f":"B29-B31","v":{"$error":"#DIV/0!"}},"(F)"]
[]
["G.   Add Unearned Income (A2) to Net Earned Income (F) Subtract (B). ",{"$f":"(B18+B33)-B20","v":{"$error":"#DIV/0!"}},"(G)",null,"Source: https://www.cdss.ca.gov/Portals/9/Additional-Resources/Letters-and-Notices/ACINs/2025/I-46_25.pdf?ver=KfyywOVXv5fZDkjuw5l9AA%3d%3d"]
[null,null,null,"Household Size","1,2,3",4,5,"6+"]
["H.   Enter the Standard Deduction",{"$f":"IF(AND(B6>0,B6<F36),E37,IF(B6=F36,F37,IF(B6=G36,G37,IF(B6>G36,H37,0))))","v":0},"(H)","Standard Deduction",209,223,261,299]
[]
["I.   Enter Dependent Care Deduction: Total $ paid in child care or adult care by Eligible HH Member (self-certified)",null,"(I)","If these expenses are shared among eligible and inelgible hh members - use pro-rated percentage. "]
[]
["J. Monthly medical expenses: ONLY for senior or disabled member applying for CalFresh",null,null,"Enter only the expenses of senior or disabled members of CalFresh HH who are eligible & applying for CalFresh."]
[]
["J2. Excess Medical Deduction = J - $35",{"$f":"IF(AND(OR(B9=\"Yes\",B9=\"Y\"),B41>35),B41-35,0)","v":0}]
["J3. Standard Medical Deduction of $150 minimally",{"$f":"IF(AND(OR(B9=\"Yes\",B9=\"Y\"),B41>185.001),B41-35,IF(AND(OR(B9=\"Yes\",B9=\"Y\"),B41>35.001),150,0))","v":0},"(J)","For more about Medical Deductions, see: http://calfresh.guide/medical-expense-deductions/ "]
[]
["Is household homeless and paying un-verified Shelter Costs?",null,"Y or N","If no, skip to Excess Shelter Deduction section. If yes, take homeless Shelter Deduction. For homeless people living in vehicles, consider claiming shelter costs. See: https://www.cdss.ca.gov/Portals/9/Additional-Resources/Letters-and-Notices/ACINs/2023/I-15_23.pdf?ver=2023-05-10-091342-920"]
[]
["K.   Homeless Shelter Deduction - Only if applicable",{"$f":"IF(OR(B46=\"Yes\",B46=\"Y\"),E48,0)","v":0},"(K)","Homeless Shelter Deduction:",198.99]
[null,null,null,"NOTE: Cannot claim homeless shelter deduction & SUA, but sometimes Homeless Shelter Deduction results in more aid. HH should select the more advantageous deduction. "]
[]
["L.   Adjusted income = (G) - (H) - (I) - (J)",{"$f":"B35-B37-B39-B44-B48","v":{"$error":"#DIV/0!"}},"(L)"]
[]
["M. Shelter Deduction"]
[]
["M1   Housing Costs (i.e. rent, mortgage, taxes, insurance, etc.) Paid by person with eligible cit/noncit status.",null,"(M)1"]
["M2   Housing Costs (i.e. rent, mortgage, taxes, insurance, etc.) Paid by ineligible noncitizen person.",null,"(M)2"]
["M3   Pro-rated Housing Costs: Prorated using numbers in B5 through B7 - if error, make sure B5 through B7 are filled in",{"$f":"IF(AND(B5>0,B6>0),(B55*(B6)/(B6+B7))+B56*B6/(B5+B7),\"\")","v":""},"M3"]
[]
[]
["N1.   Utility Deduction  - Note: Calculator No Longer Applies \"Heat & Eat\" Provision to all.  For Elderly or Disabled households, enter SUA on Line N2. All others, choose SUA, LUA, or TUA as appropriate.  ",null,null,"Source: https://www.cdss.ca.gov/Portals/9/Additional-Resources/Letters-and-Notices/ACINs/2025/I-46_25.pdf?ver=KfyywOVXv5fZDkjuw5l9AA%3d%3d"]
["N2.  Utility Allowance - Choose: SUA, LUA or TUA and enter amount from E60,F60, or G60",null,"(N)","Utility Cost","SUA","LUA","TUA"]
[null,null,null,"Deduction",663,170,20]
["O.   Adjusted Shelter Costs (M3+N)",{"$f":"B57+B61","v":{"$error":"#VALUE!"}},"(O)"]
[]
["P.   ½ of Adjusted Income (L)",{"$f":"0.5*B51","v":{"$error":"#DIV/0!"}},"(P)"]
[]
["Q.   Shelter cost difference (subtract line P from O)",{"$f":"MAX(B63-B65,0)","v":{"$error":"#VALUE!"}},"(Q)"]
[null,null,null,"Homeless Shelter Allowance",198.99,"Source: https://www.cdss.ca.gov/Portals/9/Additional-Resources/Letters-and-Notices/ACINs/2025/I-46_25.pdf?ver=KfyywOVXv5fZDkjuw5l9AA%3d%3d"]
["R.   Excess Shelter Deduction Enter (1) or (2)",{"$f":"IF(OR(B9=\"Yes\",B9=\"Y\"),B67,IF(B67<E69,B67,E69))","v":{"$error":"#VALUE!"}},"(R)","Shelter Deduction Maximum",744,"Source: https://www.cdss.ca.gov/Portals/9/Additional-Resources/Letters-and-Notices/ACINs/2025/I-46_25.pdf?ver=KfyywOVXv5fZDkjuw5l9AA%3d%3d"]
["      (1) For Non-elderly, Non-Disabled Shelter cost difference (Q) or Shelter Deduction Maximum,",null,null,"For non-Elderly & Disabled Only"]
["           whichever smaller"]
["      (2) Full shelter cost difference (Q) if elderly or disabled member in CalFresh household"]
[null,null,null,"If (S) exceeds Max. 100% Net Income Limit, HH is ineligibile. ",null,null,"Source: https://cdss.ca.gov/Portals/9/Additional-Resources/Letters-and-Notices/ACINs/2024/I-45_24.pdf?ver=2024-09-23-131451-143"]
["S.   Monthly Net Income ",null,null,"Household Size",1,2,3,4,5,6,7,8,"For each additional household member add…"]
["      Subtract Excess Shelter Deduction (R1 or R2) from Adjusted Income (L)",{"$f":"IF(OR(B46=\"Yes\",B46=\"Y\"),B51,B51-B69)","v":{"$error":"#DIV/0!"}},"(S)","Max. Net Income Limit",1305,1763,2221,2680,3138,3596,4055,4513,459]
[]
["Does the family's net income meet net income test?",{"$f":"IF(OR(AND(B75<=E75,B6=E74),AND(B75<=F75,B6=F74),AND(B75<=G75,B6=G74),AND(B75<=H75,B6=H74),AND(B75<=I75,B6=I74),AND(B75<=J75,B6=J74),AND(B75<=K75,B6=K74),AND(B75<=L75,B6=L74),AND(B75<=(L75+((B75-L75)*M75)),B6>L75)),\"YES\",\"NO\")","v":{"$error":"#DIV/0!"}},null,"IF \"NO\" STOP HERE"]
[]
["III. CalFresh Allotment "]
[]
["T.   Multiply the Household's Net Income (S) by 0.3",{"$f":"B75*0.3","v":{"$error":"#DIV/0!"}},"(T)"]
[]
["U.   Adjusted Food Income (round up to next $)",{"$f":"ROUNDUP(B81,0)","v":{"$error":"#DIV/0!"}},"(U)"]
[null,null,null,null,null,null,"Source:  https://www.cdss.ca.gov/Portals/9/Additional-Resources/Letters-and-Notices/ACINs/2025/I-46_25.pdf?ver=KfyywOVXv5fZDkjuw5l9AA%3d%3d"]
["V.   Max. CalFresh Allotment for Family Size",{"$f":"IF(B6=1,E86,IF(B6=2,F86,IF(B6=3,G86,IF(B6=4,H86,IF(B6=5,I86,IF(B6=6,J86,IF(B6=7, K86,IF(B6=8, L86,IF(B6>8, L86+220*(B6-8))))))))))","v":false},"(V)","Household Size",1,2,3,4,5,6,7,8,"For each additional household member add…"]
["       If (U) higher than (V) - HH of 3+ not eligible for CalFresh",null,null,"Max. CalFresh Allotment",298,546,785,994,1183,1421,1571,1789,218]
["    "]
["W. Amount in CalFresh ",{"$f":"IF(B83<0,B85,IF(B83>B85,0,IF(B83<B85,(B85-B83))))","v":{"$error":"#DIV/0!"}},"(W)"]
[]
["X.   For HH of 3+, "]
["       add $1 if (W) is $1, $3 or $5.",{"$f":"IF(B6>2,IF(OR(B88=1,B88=3,B88=5),B88+1,B88),0)","v":0},"(X)"]
[]
[" Y.   For HH of 1-2, enter $23 if the Adjusted Food Income (U) is greater  than the Max. CalFresh Allotment or if (V) is less than $23.00.",{"$f":"IF(AND(OR(B6=1,B6=2)),IF(AND(B77=\"YES\",B88<19),23,B88),0)","v":0},"(Y)","Note: if less meets Net Income Test, but HH size is less than 3 and (W) is less than $23, then they will receive minimum benefit of $23"]
[]
["Z.   Monthly CalFresh Allotment:",{"$f":"IF(OR(B6=1,B6=2),B93,B91)","v":0},"(Z)"]
[]
[]
["IV. Pro Rated First Month's Allotment"]
[]
["Enter the number of days in the month plus 1",null,"(Z)"]
[]
["Day of the month the household applied for CalFresh:"]
[]
["AA.   Subtract the day of the month the household applied",{"$f":"B100-B102","v":0},"(AA)"]
[]
["AB.   Divide by 30",{"$f":"B104/30","v":0},"(AB)"]
[]
["AC.   Multiply (AB) by (Z)",{"$f":"B106*B95","v":0},"(AC)"]
[]
["AD.   Unrounded CalFresh allotment:",{"$f":"B108","v":0},"(AD)"]
["        Round down to next whole dollar:",{"$f":"ROUNDDOWN(B110, 0)","v":0},"(AD)"]
[]
["         First Month's CalFresh Allotment",{"$f":"B111","v":0}]
[]
["Monthly Interim Report Threshold (IRT)",{"$f":"IF(B6=1,E119,IF(B6=2,F119,IF(B6=3,G119,IF(B6=4,H119,IF(B6=5,I119,IF(B6=6,J119,IF(B6=7, K119,IF(B6=8, L119,IF(B6>8, L119+583*(B6-8))))))))))","v":false}]
[]
[null,null,null,"130% FPL","Source:  https://www.cdss.ca.gov/Portals/9/Additional-Resources/Letters-and-Notices/ACINs/2025/I-46_25.pdf?ver=KfyywOVXv5fZDkjuw5l9AA%3d%3d"]
[null,null,null,"Household Size ",1,2,3,4,5,6,7,8,"For each additional household member add…"]
[null,null,null,"Interim Report Threshold ",1696,2292,2888,3483,4079,4675,5271,5867,596]
[]
["Updated: January 2026"]
["For questions or errata, contact Lisa Newstrom, lnewstrom@baylegal.org"]
[]
["The state guidance for this calculator can be found here"]
["The federal guidance for this calculator can be found here"]