{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["BLANK","DESCRIPTIONS OF EACH FIELD"],"read":"whole","date_system":"1900"}

{"sheet":"BLANK","index":0,"n_rows":1,"n_cols":23,"rows_kept":1}
["BUSINESS ACCT ID","Clients Tax ID#","Service Provided","Invoice or Ref #","Responsible Company Name","street1","city","state","zip","zip_plus4","Main Phone","Cell Phone","AltPhone","Email","amount","Date of Last Service","Date of Last Payment ","Contact Lname","Contact Fname","Contact Job Title","Delivery Received by","Personal Guarantee on File Y/N","NOTES/Comments"]

{"sheet":"DESCRIPTIONS OF EACH FIELD","index":1,"n_rows":23,"n_cols":23,"rows_kept":23}
["BUSINESS ACCT ID","Clients Tax ID#","Service Provided","Invoice or Ref #","Resp Company Name","street1","city","state","zip","zip_plus4","Main Phone","Cell Phone","AltPhone","Email","amount","Date of Last Service","Date of Last Payment ","Contact Lname","Contact Fname","Contact Job Title","Delivery Received by","Personal Guarantee on File Y/N","NOTES/Comments"]
[]
["This is your account number that you use to reference and identify this patient/customer","Your Client's Tax ID number","What Service was Provided for this Company?","Invoice Number, Reference Number, or most recent statement","Complete Name of the Company you provided the service to.","Street address of reponsible company","City of responsible company","2 letter state abbreviation of responsible company","5 digit zip code of responsible company","Additional 4 digits of extended zip (if available)","10 digit home phone number for responsible company","10 digit work phone number for responsible company contact","10 digit alternative phone number for responsible company","Email address for responsible party","Amount owed","Service date (date for which service was rendered or purchase was made)","Date of last payment ?","Last Name of Main Contact at Responsible company","First Name of Main Contact at Responsible company","Job Title of Main Contact at Responsible company","The Name of the Individual at Responsible company who Signed for the Delivery","Do you have a SIGNED Personal Guarantee on file from Owner or other Officer of Responsible Party?","Any notes or comments relevant to collection efforts"]
[]
["EXAMPLES:"]
[12345678,"16-1234567",null,12345,"ABC Company Inc","123 Anywhere Lane","Town of Franklin","NY",12345,6789,"555-555-1234","555-555-5678","555-555-9012","jdoe@abccompany.com",{"v":1000,"d":"$1,000.00"},"2005-02-02","2005-04-02","Doe","Jane","Purchasing Agent","John Hancock","no","Client made first payment of $100.00 on service date and never made another payment"]
[]
["Fields Highlighted in YELLOW are \"Required Fields\""]
[]
[]
["Columns E through N and column W reflect the information for the person or company identified as responsible for paying the debt - this is the Guarantor's information."]
[]
["Columns C, O, P and Q provide information regarding the services or products provided to the customer."]
[]
["Columns R through U reflect the information for the person who placed the Purchase Order, Authorized the Service, or otherwise provided approval for the services rendered."]
[]
["Column V reflects whether or not there is a personal signed guarantee from the owner."]
[]
[]
[]
[{"$nulls":3},"***PLEASE PLACE YOUR ACCOUNTS ON THE \"BLANK\" TAB***"]
[]
[{"$nulls":3},"***PLEASE DO NOT CHANGE COLUMN HEADERS IN THE \"BLANK\" TAB***"]