{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Introduction","Data Entry","Penalty Computation"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":14,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":29,"n_cols":2,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,9],[13,0,13,9],[14,0,14,9],[15,1,15,9],[16,1,16,9],[8,1,8,9],[9,1,9,9],[5,1,5,9],[10,1,10,9],[11,1,11,9],[1,1,1,9],[2,1,2,9],[3,1,3,9],[4,1,4,9],[6,1,6,9],[7,1,7,9],[18,1,18,9],[12,0,12,9],[19,1,19,9],[20,1,20,9],[21,1,21,9],[17,1,17,9],[25,1,25,9],[26,1,26,9],[27,1,27,9],[28,1,28,9],[22,1,22,9],[23,1,23,9],[24,1,24,9]]}
["The Basics"]
["•","IRC 6651(a)(1) provides a penalty for failure to file certain taxable returns."]
["•","Impacted returns are available via a drop-down menu."]
["•","The penalty is 5% of tax required to be shown on the return that is not paid by the last day"]
[null,"provided for payment, and it's charged each month or part of a month the return is late."]
["•","Unless the minimum penalty applies, the maximum penalty is 25%."]
["•","For income tax returns filed 60 days or more after the due date a minimum penalty may apply."]
["•","IRC sections 7508 and 7508A provide for periods to be disregarded in determining whether or"]
[null,"not a required action was performed on time, and the disregarded period is also taken into"]
[null,"account in determining the amount of a penalty.  In other words, they operate to move the "]
["•","When the penalty for filing late, and the penalty for paying late both apply with respect to"]
[null,"the same month, the penlaty for filing late is reduced by the penalty for paying late."]
[]
["The Worksheet"]
["In order for this worksheet to work properly, certain information must be entered:"]
["•","Total tax per taxpayer.  Needed to calculate tax shown on the return."]
["•","Refundable tax credits per taxpayer.  Needed to calculate tax shown on the return."]
["•","Adjusted tax and refundable tax credits.  Needed to calculate tax required to be shown"]
[null,"on the return."]
["•","All allowable payments and payment equivalent credits (e.g. credit for withheld income tax,"]
[null,"excess social security tax, backup withholding, or regulated investment company credit from"]
[null,"Form 2439.)  Needed to calculate unpaid tax and penalty for paying late."]
["•","If return is short period return with a due date other than the normal due date, then the return"]
[null,"due date has to be overlaid manually."]
["•","Return due date must be entered manually for Form 706 and for Form 2290."]
["•","Return received date must be entered on the return."]
["•","Periods disregarded under IRC 7508 and IRC 7508A must be entered, except as provided under"]
[null,"Notice 2020-23 (related to COVID-19)."]
["•","Any extension to file or pay must be entered."]

{"sheet":"Data Entry","index":1,"n_rows":106,"n_cols":11,"rows_kept":106,"cut":false,"hidden":false,"merged":[[0,4,1,4],[1,1,1,2],[4,8,6,8],[4,9,6,9],[4,10,6,10],[0,5,1,5],[0,6,1,6],[0,1,0,2]]}
["Taxpayer identification number:",null,null,null,"Allowable payments & payment equivalent credits:","Amount","Date",null,"Extensions","Date"]
["Tax form:",null,null,null,null,null,null,null,"Extension of time to file:"]
["Taxable year ended:",null,null,null,"Credit for withheld income tax:",null,{"$f":"IF(RDD=\"\",\"\",RDD)","v":""},null,"Extension of time to pay:"]
["Return due date:",null,null,null,"Credit for excess social security tax:",null,{"$f":"IF(RDD=\"\",\"\",RDD)","v":""}]
["Return received date:",null,null,null,"Credit from Form 2439:",null,{"$f":"IF(RDD=\"\",\"\",RDD)","v":""},null,"Disregarded Periods\nIRC 7508 & IRC 7508A\nSee IRM 20.1.2.2.2","From","To"]
[null,null,null,null,"Payment:"]
["Total tax on return:","Per taxpayer","Adjusted",null,"Payment:"]
["Total tax on return:",null,null,null,"Payment:"]
[null,null,null,null,"Payment:"]
["Refundable tax credits on return:","Per taxpayer","Adjusted",null,"Payment:"]
[null,null,null,null,"Payment:"]
[null,null,null,null,"Payment:"]
[null,null,null,null,"Payment:"]
[null,null,null,null,"Payment:"]
[null,null,null,null,"Payment:"]
[null,null,null,null,"Payment:",null,null,null,"Penalty history:","Amount"]
[null,null,null,null,"Payment:",null,null,null,"Net previously assessed FTF penalty:"]
[null,null,null,null,"Payment:"]
[null,null,null,null,"Timely payments - IRC 6651(b)(1):",null,null,null,"Penalty start dates:","File","Pay"]
["Tax shown / Required to be shown:",{"$f":"B8-SUM(B11:B19)","v":0},{"$f":"C8-SUM(C11:C19)","v":0},null,"Paid at begin of overlapping period:",null,{"$f":"IF(OR(J20=\"\",K20=\"\"),\"\",IF(J20>K20,IF(DAY(K20)<DAY(J20),DATE(YEAR(J20),MONTH(J20)+1,DAY(K20)),DATE(YEAR(J20),MONTH(J20),DAY(K20))),K20))","v":""},null,"Last Day to file or pay:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"VLOOKUP(TxForm,RtnInfo,3,FALSE)","v":{"$error":"#N/A"}}]
[null,"Notice 2020-23","Income tax",{"$f":"IF(ISERROR(VLOOKUP(TxForm,RtnInfo,4,FALSE)),\"\",VLOOKUP(TxForm,RtnInfo,4,FALSE))","v":""}]
["Form CT-1",false,false,{"$f":"DATE(YEAR(TxYrEnd),MONTH(TxYrEnd)+3,1)-1","v":"1900-03-31"},0]
["Form 706",true,false,null,0]
["Form 709",true,false,{"$f":"DATE(YEAR(TxYrEnd),MONTH(TxYrEnd)+4,15)","v":"1900-05-15"},0]
["Form 720",false,false,{"$f":"DATE(YEAR(TxYrEnd),MONTH(TxYrEnd)+2,1)-1","v":60},4]
["Form 730",false,false,60,0]
["Form 940",false,false,60,0]
["Form 941",false,false,60,3]
["Form 943",false,false,60,3]
["Form 944",false,false,60,3]
["Form 945",false,false,60,0]
["Form 990-PF",false,true,{"$f":"DATE(YEAR(TxYrEnd),MONTH(TxYrEnd)+5,15)","v":"1900-06-15"},0]
["Form 990-T",true,true,{"$f":"DATE(YEAR(TxYrEnd),MONTH(TxYrEnd)+5,15)","v":"1900-06-15"},2]
["Form 1040",true,true,{"$f":"DATE(YEAR(TxYrEnd),MONTH(TxYrEnd)+4,15)","v":"1900-05-15"},1]
["Form 1040NR w/o withholding",true,true,{"$f":"DATE(YEAR(TxYrEnd),MONTH(TxYrEnd)+6,15)","v":"1900-07-15"},1]
["Form 1040NR with withholding",true,true,{"$f":"DATE(YEAR(TxYrEnd),MONTH(TxYrEnd)+4,15)","v":"1900-05-15"},1]
["Form 1041",true,true,{"$f":"DATE(YEAR(TxYrEnd),MONTH(TxYrEnd)+4,15)","v":"1900-05-15"},0]
["Form 1042",false,false,{"$f":"DATE(YEAR(TxYrEnd),MONTH(TxYrEnd)+3,15)","v":"1900-04-15"},0]
["Form 1065-B",false,false,{"$f":"DATE(YEAR(TxYrEnd),MONTH(TxYrEnd)+3,15)","v":"1900-04-15"},0]
["Form 1120",true,true,{"$f":"IF(OR(MONTH(TxYrEnd)=6,TxYrEnd<DATE(2016,12,1)),DATE(YEAR(TxYrEnd),MONTH(TxYrEnd)+3,15),DATE(YEAR(TxYrEnd),MONTH(TxYrEnd)+4,15))","v":"1900-04-15"},2]
["Form 1120-C per 6072(d)",true,true,{"$f":"DATE(YEAR(TxYrEnd),MONTH(TxYrEnd)+9,15)","v":"1900-10-15"},2]
["Form 1120-C not 6072(d)",true,true,{"$f":"IF(OR(MONTH(TxYrEnd)=6,TxYrEnd<DATE(2016,12,1)),DATE(YEAR(TxYrEnd),MONTH(TxYrEnd)+3,15),DATE(YEAR(TxYrEnd),MONTH(TxYrEnd)+4,15))","v":"1900-04-15"},2]
["Form 1120-F with US Office",true,true,{"$f":"IF(OR(MONTH(TxYrEnd)=6,TxYrEnd<DATE(2016,12,1)),DATE(YEAR(TxYrEnd),MONTH(TxYrEnd)+3,15),DATE(YEAR(TxYrEnd),MONTH(TxYrEnd)+4,15))","v":"1900-04-15"},2]
["Form 1120-F w/o US Office",true,true,{"$f":"DATE(YEAR(TxYrEnd),MONTH(TxYrEnd)+6,15)","v":"1900-07-15"},2]
["Form 1120-FSC",true,true,{"$f":"IF(OR(MONTH(TxYrEnd)=6,TxYrEnd<DATE(2016,12,1)),DATE(YEAR(TxYrEnd),MONTH(TxYrEnd)+3,15),DATE(YEAR(TxYrEnd),MONTH(TxYrEnd)+4,15))","v":"1900-04-15"},2]
["Form 1120-H",true,true,"1900-04-15",2]
["Form 1120-L",true,true,"1900-04-15",2]
["Form 1120-ND",true,true,"1900-04-15",2]
["Form 1120-PC",true,true,"1900-04-15",2]
["Form 1120-POL",true,true,"1900-04-15",2]
["Form 1120-REIT",true,true,"1900-04-15",2]
["Form 1120-RIC",true,true,"1900-04-15",2]
["Form 1120-SF",true,true,"1900-04-15",2]
["Form 2290",false,false,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(TxForm=\"\",0,VLOOKUP(TxForm,RtrnType,5,FALSE))","v":0}]
["Additional Child Tax Credit:"]
["Earned Income Credit:"]
["Employee Retention Credit:"]
["First time homebuyer credit:"]
["Fuel tax credit:"]
["Health coverage tax credit:"]
["Making work pay credit:"]
["Recovery rebate credit:"]
["Refundable education credit:"]
["Sick & Family Leave Credit:"]
["Prior year minimum tax credit:"]
["Fuel tax credit:"]
["Employee Retention Credit:"]
["Sick & Family Leave Credit:"]
["Fuel tax credit:"]

{"sheet":"Penalty Computation","index":2,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[[19,1,20,2],[21,1,21,2],[0,5,0,9],[5,9,6,9]]}
[null,"Taxpayer Identification Number:",{"$f":"'Data Entry'!B1:C1","v":0},0,null,"Computation of IRC 6651(c)(1) Penalty Reduction Amount"]
[null,"Tax form:",{"$f":"IF('Data Entry'!B2=\"\",\"\",'Data Entry'!B2)","v":""}]
[null,"Taxable period ended:",{"$f":"IF('Data Entry'!B3=\"\",\"\",'Data Entry'!B3)","v":""}]
[1,"Last date for timely filing:",{"$f":"IF('Data Entry'!J20=\"\",\"\",'Data Entry'!J20)","v":""},null,1,"Tax shown on the return:",{"$f":"'Data Entry'!B20","v":0}]
[2,"Return received date:",{"$f":"IF(Rcvd_Dt=\"\",\"\",Rcvd_Dt)","v":""},null,2,"Begin of overlapping penalty period:",{"$f":"'Data Entry'!G20","v":""}]
[3,"Months delinquent:",{"$f":"IF(OR(C5=\"\",C4=\"\"),\"\",IF(C5<=C4+7,0,((YEAR(C5)-YEAR(C4))*12)+(MONTH(C5)-MONTH(C4))+IF(DAY(C5)>DAY(C4),1,0)))","v":""},null,3,"Total paid by date above:",{"$f":"'Data Entry'!F20","v":0},null,null,"Penalty under IRC 6651(a)(2)"]
[4,"Penalty rate:",{"$f":"MIN(C6*0.05,0.25)","v":{"$error":"#VALUE!"}},null,null,null,"Principal","From","To"]
[5,"Tax required to be shown on the return:",{"$f":"'Data Entry'!C20","v":0},null,4,"Amount subject to IRC 6651(a)(2) penalty:",{"$f":"IF(G4>G6,G4-G6,0)","v":0}]
[6,"Timely payments & payment credits:",{"$f":"'Data Entry'!F19","v":0},null,5,"Penalty for paying late:"]
[7,"Net tax subject to penalty - IRC 6651(b)(1):",{"$f":"C8-C9","v":0}]
[8,"Gross tentative penalty:",{"$f":"C7*C10","v":{"$error":"#VALUE!"}}]
[9,"Penalty reduction under IRC 6651(c)(1):"]
[10,"Net tentative penalty:",{"$f":"C11-C12","v":{"$error":"#VALUE!"}}]
[11,"Days return was late:",{"$f":"IF(OR(C4=\"\",C5=\"\"),\"\",C5-C4)","v":""}]
[12,"(1)Minimum penalty if aplicable:",186]
[13,"(2)Penalty for filing late - IRC 6651(a)(1):",{"$f":"MAX(C15,C13)","v":{"$error":"#VALUE!"}}]
[{"$f":"IF('Data Entry'!J17=\"\",\"\",14)","v":""},{"$f":"IF('Data Entry'!J17=\"\",\"\",\"Penalty for failure to file previously assessed:\")","v":""},{"$f":"IF('Data Entry'!J17=\"\",\"\",'Data Entry'!J17)","v":""}]
[{"$f":"IF(C17=\"\",\"\",15)","v":""},{"$f":"IF(B17=\"\",\"\",IF(C16>=C17,\"Penalty increase:\",\"Penalty decrease:\"))","v":""},{"$f":"IF(C17=\"\",\"\",C16-C17)","v":""}]
[]
[1,"The minimum penalty applies to income tax returns that were filed at least 60 days after the last date to file timely."]
[]
[2,"The larger of line 10 or line 12."]