{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Key","Mixed Payments File","Physical Checks File","Digital Checks File","ACH Retrieve by Email","ACH Direct Deposit File"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Key","index":0,"n_rows":31,"n_cols":3,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Field","Specifications "]
["Client Transaction","Optional"]
["Payee Name","Required for all payments"]
["Reference","Optional"]
["Memo","Optional"]
["Payment Amount","Required for all payments"]
["Address","Required for all payments, is email address for checks and ACH bank account information retrieval"]
["City","Required for physical checks only"]
["State","Required for physical checks only"]
["Zip/Postal Code","Required for physical checks only"]
["Country","Required for physical checks only"]
["SSN/Tax ID","Optional"]
["Postage Code*","USPS 1st Class if blank"]
["Method ID","1 for ACH Direct Depost, 2 for Check, defaults to 2(check) if not specified"]
["Payee Account Number","Required  and only for ACH Direct Deposit"]
["Payee Routing Number","Required and only for ACH Direct Deposit"]
["Payee Account Type","Required and only for ACH Direct Deposit, CHECKING, SAVINGS or BUSINESS"]
["Addenda","Optional and only for ACH Direct Deposit"]
[]
[]
[]
[]
["*Postage Code","Description","Delivery Time"]
[7,"2 Day Courier Service with FedEx","2 Days"]
[6,"1 Day Courier Service with FedEx","1 Day"]
[4,"USPS Priority + Signature Confirmation","1-3 Days"]
[3,"USPS Priority + Delivery Confirmation","1-3 Days"]
[2,"USPS Priority","1-3 Days"]
[1,"USPS First-Class","2-5 Days"]
[8,"USPS Priority Express Overnight","1-2 Days"]
[9,"USPS Certified Mail","2-5 Days"]

{"sheet":"Mixed Payments File","index":1,"n_rows":5,"n_cols":17,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["(Not an actual Field/Header)","Client Transaction","Payee Name","Reference","Memo","Payment Amount","Address","City","State","Zip/Postal Code","Country","SSN/Tax ID","Postage Code","Method ID","Payee Account Number","Payee Routing Number","Payee Account Type"]
["(Physical Checks)",12345,"Jane Smith","Rebate 123",null,60,"123 Elm St. ","Warren","OH",43265,"US","321-32-5494",null,2]
["(Digital Checks)",12346,"John Doe","Refund 321",null,25.36,"johndoe@gmail.com",null,null,null,null,null,null,2]
["(ACH Direct Deposit)",12347,"Jason Bruce","Invoice 1324",null,934.95,"jasonbruce@gmail.com",null,null,null,null,"Optional",null,1,1234567,32076493,"CHECKING"]
["(ACH Retrieve by Email)",12346,"John Doe","Refund 321",null,25.36,"johndoe@gmail.com",null,null,null,null,null,null,1]

{"sheet":"Physical Checks File","index":2,"n_rows":2,"n_cols":11,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Client Transaction","Payee Name","Reference","Payment Amount","Address","City","State","Zip/Postal Code","Country","SSN/Tax ID","Method ID"]
[12345,"Jane Smith","Rebate 123",60,"123 Elm St. ","Warren","OH",43265,"US","321-32-5494",2]

{"sheet":"Digital Checks File","index":3,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Client Transaction","Payee Name","Reference","Memo","Payment Amount","Address","Method ID"]
[12346,"John Doe","Refund 321",null,25.36,"johndoe@gmail.com",2]

{"sheet":"ACH Retrieve by Email","index":4,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Client Transaction","Payee Name","Reference","Memo","Payment Amount","Address","Method ID"]
[12346,"John Doe","Refund 321",null,25.36,"johndoe@gmail.com",1]

{"sheet":"ACH Direct Deposit File","index":5,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Client Transaction","Payee Name","Addenda","Payment Amount","Method ID","Payee Account Number","Payee Routing Number","Account Type"]
[12345,"Jason Bruce","Invoice 1234",234.95,1,1234567,32076493,"CHECKING"]