{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Import","Returns","Payments","DishonoredPayments","ReasonCodes"],"not_rendered":{"macros":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Import","index":0,"n_rows":31,"n_cols":6,"rows_kept":31}
[null,null,"OneSpot Return & Payment File Import"]
[]
["Beginning Transaction Date","Ending Transaction Date",null,"Only Import Code:"]
["2013-07-01","9999-12-31",null,"0000"]
[]
[{"$f":"REPT(\"|\",C6*100)","v":""}]
["Files Imported:",null,"# of Rows From Returns File","Amount","# of Rows From Payments File","Amount"]
[null,"ACH Debit Method",0,{"v":0,"d":"0.00"},0,{"v":0,"d":"0.00"}]
[null,"Int'l ACH Transaction (IAT)",0,{"v":0,"d":"0.00"},0,{"v":0,"d":"0.00"}]
[null,"ACH Credit Method",0,{"v":0,"d":"0.00"},"XXXX","XXXX"]
[null,"Zero Tax Due",0,{"v":0,"d":"0.00"},"XXXX","XXXX"]
[null,"Total",{"$f":"SUM(C8:C11)","v":0},{"$f":"SUM(D8:D11)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(E8:E9)","v":0},{"$f":"SUM(F8:F9)","v":{"v":0,"d":"0.00"}}]
[]
[null,"     To import the return and payment files click the \"Import File(s)\" button above.  Multiple files can be selected at"]
[null,"once by holding down the \"Ctrl\" or the \"Shift\" key while selecting the files.  To select all files in a"]
[null,"folder press \"Ctrl + A\".  If the \"Import File(s)\" button does not work, make sure macros are enabled."]
[]
[null,"     To limit the data import to a specific range of transaction dates change the dates in the Beginning Transaction Date"]
[null,"and Ending Transaction Date fields above.  Leave them at their default values to import all records in the file."]
[]
[null,"     All return data will be placed on the Returns Tab.  All positive payments will be placed on the Payments"]
[null,"tab and all negative payments will be placed on the DishonoredPayments tab."]
[null,"If you don't see the tabs at the bottom of the screen you may need to maximize this window. "]
[]
[null,"     During the import, the program matches the payment information to the return information by copying"]
[null,"the payments from the payments file to columns AS (Payments) and AT (DishonoredPayments) on the Returns Tab.  "]
[null,"The payments and returns are matched using the Locality Code, Jurisdiction Account Number, Return Confirmation Number, "]
[null,"Tax Type, Rate Type and Amount."]
[]
[null,"If you want to import only a certain locality code enter that code in the \"Only Import Code:\" field above.  To import all"]
[null,"localities that are in the return and payment files leave the value at \"0000\"."]

{"sheet":"Returns","index":1,"n_rows":1,"n_cols":48,"rows_kept":1}
["Tax\nForm","Jurisdiction\nAccount #","ADOR\nAccount #","Vendor\nCode","Delinquent","Filing\nFrequency","Filing\nPeriod","Taxpayer's\nLegal Name","Confirmation / \nControl Number","Remit","Loc\nCode","Tax\nType","Gross\nAmount","Tax\nDue","Discount","Total\nDue","EFT\nFlag","Filing\nType","Rate\nType","Deductions","Net\nTaxable","Tax\nRate","Epay\nPayment Code","Settlement\nDate","Period\nEnd","Contact\nName","Contact\nPhone#","Contact\nEmail","PJ\nIndicator","Filing\nMethod","FTTF\nPenalty","FTTP\nPenalty","Interest","Transaction\nDate","Transaction\nTime","Administered\nBy","Pass Return/\nPayment File","Pass Payment","One Time\nFlag","Payment\nConfirmation #","FEIN","Taxpayer's\nDBA","FileName","Payment\nLookup","Total\nDue","Payment","Dishonored\nPayment","Balance"]

{"sheet":"Payments","index":2,"n_rows":1,"n_cols":39,"rows_kept":1}
["Record\nType","Payment\nMethod","Transaction\nDate","Transaction\nTime","Payment\nCode","Payment\nCommand Code","Payment\nAmount","Payment\nConfirmation #","Routing #","Account #","First\nName","Middle\nInitial","Last\nName","Account\nHolder Name","Email\nAddress","Street\nName 1","Street\nName 2","City","State","Zip","Authorization\nMedium Code","Jurisdiction\nAccount #","ALDOR\nAccount # ","Locality\nCode","Return\nConfirmation #","Filing\nFrequency","Period","Email","Phone #","Tax\nType","Rate\nType","PJ\nIndicator","FEIN","Taxpayer's\nLegal Name","Taxpayer's\nDBA","Filename","Payment\nLookup","Payment\nAmount","Matched To\nReturn?"]

{"sheet":"DishonoredPayments","index":3,"n_rows":1,"n_cols":40,"rows_kept":1}
["Record\nType","Payment\nMethod","Transaction\nDate","Transaction\nTime","Payment\nCode","Payment\nCommand Code","Payment\nAmount","Payment\nConfirmation #","Routing #","Account #","First\nName","Middle\nInitial","Last\nName","Account\nHolder Name","Email\nAddress","Street\nName 1","Street\nName 2","City","State","Zip","Authorization\nMedium Code","Jurisdiction\nAccount #","ALDOR\nAccount # ","Locality\nCode","Return\nConfirmation #","Filing\nFrequency","Period","Email","Phone #","Tax\nType","Rate\nType","PJ\nIndicator","FEIN","Taxpayer's\nLegal Name","Taxpayer's\nDBA","Filename","Payment\nLookup","Payment\nAmount","Dishonored Payment\nReason Code Description","Matched to\nReturn"]

{"sheet":"ReasonCodes","index":4,"n_rows":70,"n_cols":4,"rows_kept":70,"hidden":true}
["Code","Description"," "," "]
[0,"Invalid Characters in Account Number"]
[1,"Insufficient Funds"," "," "]
[2,"Account Closed"," "," "]
[3,"No Account / Unable to Locate Account"," "," "]
[4,"Invalid Account Number Structure"," "," "]
[5,"Unauthorized Debit to Consumer Account Using Corporate SEC Code"," "," "]
[6,"Returned per ODFI's Request"," "," "]
[7,"Authorization Revoked by Customer"," "," "]
[8,"Payment Stopped"," "," "]
[9,"Uncollected Funds"," "," "]
[10,"Customer Advises Not Authorized, Improper, Ineligible, or part of an Incomplete Transaction"," "," "]
[11,"Check Truncation Entry Return"]
[12,"Account Sold to Another DFI"]
[13,"Invalid ACH Routing Number"," "," "]
[14,"Representative Payee Deceased or Unable to Continue in That Capacity"," "," "]
[15,"Beneficiary or Account Holder (Other Than a Representative Payee) Deceased"," "," "]
[16,"Account Frozen"," "," "]
[17,"File Record Edit Criteria"," "," "]
[18,"Improper Effective Entry Date"," "," "]
[19,"Amount Field Error"," "," "]
[20,"Non-Transaction Account"," "," "]
[21,"Invalid Company Identification"," "," "]
[22,"Invalid Individual ID Number"," "," "]
[23,"Credit Entry Refused by Receiver"," "," "]
[24,"Duplicate Entry"," "," "]
[25,"Addenda Error"," "," "]
[26,"Mandatory Field Error"," "," "]
[27,"Trace Number Error"," "," "]
[28,"Routing Number Check Digit Error"," "," "]
[29,"Corporate Customer Advises Not Authorized"," "," "]
[30,"RDFI Not Participant in Check Truncation Program"," "," "]
[31,"Permissible Return Entry (CCD and CTX  only)"," "," "]
[32,"RDFI Non-Settlement"," "," "]
[33,"Return of XCK Entry"," "," "]
[34,"Limited Participation DFI"," "," "]
[35,"Return of Improper Debit Entry"," "," "]
[36,"Return of Improper Credit Entry"," "," "]
[37,"Source Document Presented for Payment"," "," "]
[38,"Stop Payment on Source Document"," "," "]
[39,"Improper Source Document / Source Document Presented for Payment"," "," "]
[40,"Return of ENR Entry by Federal Government Agency"," "," "]
[41,"Invalid Transaction Code"," "," "]
[42,"Routing Number/Check Digit Error"," "," "]
[43,"Invalid DFI Account Number"," "," "]
[44,"Invalid Individual ID Number / Identification Number"," "," "]
[45,"Invalid Individual Name / Company Name"," "," "]
[46,"Invalid Representative Payee Indicator"," "," "]
[47,"Duplicate Enrollment"," "," "]
[50,"State Law Affecting RCK Acceptance"," "," "]
[51,"Item Related to RCK Entry is Ineligible or RCK Entry is Improper"," "," "]
[52,"Stop Payment on Item Related to RCK Entry"," "," "]
[53,"Item and RCK Entry Presented for Payment"," "," "]
[61,"Misrouted Return"," "," "]
[67,"Duplicate Return"," "," "]
[68,"Untimely Return"," "," "]
[69,"FieldError(s)"," "," "]
[70,"Permissible Return Entry Not Accepted / Return Not Requested by ODFI"," "," "]
[71,"Misrouted Dishonored Return"," "," "]
[72,"Untimely Dishonored Return"," "," "]
[73,"Timely Original Return"," "," "]
[74,"Corrected Return"," "," "]
[75,"Return Not a Duplicate"," "," "]
[76,"No Errors Found"," "," "]
[80,"IAT Entry Coding Error"," "," "]
[81,"Non-Participant in IAT Program"," "," "]
[82,"Invalid Foreign Receiving DFI Identification"," "," "]
[83,"Foreign Receiving DFI Unable to Settle"," "," "]
[84,"Entry Not Processed by Gateway"," "," "]
[85,"Incorrectly Coded Outbound International Payment"," "," "]