{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Descriptions of Each Field"],"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":1,"n_cols":29,"rows_kept":1}
["CONSUMER ACCT ID","Service Provided","Resp Lname","Resp Fname","street1","city","state","zip","zip_plus4","birthdate","ssno","Main Phone","Work Phone","AltPhone","Email","amount due","date of service","Employment ","Date of Last Payment ","Co-signer Lname","Co-signer Fname","CoSSN","CoDOB","CoAddress","CoCity","CoState","CoZip","Cophone","NOTES/Comments"]

{"sheet":"Descriptions of Each Field","index":1,"n_rows":21,"n_cols":29,"rows_kept":21}
["CONSUMER ACCT ID","Service Provided","Resp Lname","Resp Fname","street1","city","state","zip","zip_plus4","birthdate","ssno","Main Phone","Work Phone","AltPhone","Email","amount due","date of service","Employment ","Date of Last Payment ","Co-signer Lname","Co-signer Fname","CoSSN","CoDOB","CoAddress","CoCity","CoState","CoZip","Cophone","NOTES/Comments"]
[]
["This is your account number that you use to reference and identify this patient/customer","What Service or Product was Provided to this Consumer?","Last name of the responsible party or guarantor ","First name of the responsible party or guarantor ","Street address of reponsible party or guarantor","City of responsible party or guarantor","2 letter state abbreviation of responsible party or guarantor address","5 digit zip code of responsible party or guarantor address","Additional 4 digits of extended zip (if available)","Month/date/year (mm/dd/yy) for responsible party or guarantor","9 digit social security number for responsible party or guaranor (with or without dashes)","10 digit main phone number for responsible party or guarantor","10 digit work phone number for responsible party or guarantor","10 digit alternative phone number for responsible party or guarantor","Email address of responsible party","Amount owed","Service date (date for which service was rendered or purchase was made)","Name of workplace of responsible party or guarantor","Date of last payment ?","For Rental Property, bank accounts, etc - Last name of co-signer/borrower","For Rental Property, bank accounts, etc - First name of co-signer/borrower","For Rental Property, bank accounts, etc - Social Security Number of co-signer/borrower","For Rental Property, bank accounts, etc - Date of Birth of co-signer/borrower","For Rental Property, bank accounts, etc - Mailing Address of co-signer/borrower","For Rental Property, bank accounts, etc - City of co-signer/borrower","For Rental Property, bank accounts, etc - State of co-signer/borrower","For Rental Property, bank accounts, etc - Zip Code of co-signer/borrower","For Rental Property, bank accounts, etc - Contact Phone of co-signer/borrower","Any notes or comments relevant to collection efforts"]
[]
["EXAMPLES:"]
[12345678,null,"Doe","John","123 Anywhere Lane","Town of Franklin","NY",12345,6789,"1990-01-01","123-45-6789","555-555-1234","555-555-5678","555-555-9012","john@xyz.com",{"v":1000,"d":"1000.00"},"2005-02-02","XYZ Plumbing","2005-04-02","Doe","Jane","123-45-6780","1992-12-01","123 Anyplace Ave","Clinton","NY",12345,"555-555-0001","Client made first payment of $100.00 on service date and never made another payment"]
[]
["Columns Highlighted in Yellow are \"Required Fields\""]
[]
["Columns C through O and column R reflect the information for the person identified as responsible for paying the debt - this is the Guarantor's information."]
[]
["Columns B and P through S provide information regarding the services or products provided to the consumer."]
[]
["Columns T through AB reflect the information for the person identified as a co-signer/borrower - For rental property, banking clients or co-signer accounts."]
[]
[]
[]
[]
[{"$nulls":3},"***PLEASE PLACE YOUR ACCOUNTS ON THE \"BLANK\" TAB***"]
[]
[{"$nulls":3},"***PLEASE DO NOT CHANGE COLUMN HEADERS IN THE \"BLANK\" TAB***"]