{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","1) Corporate Data","2) Admin Access","3) Preferences","4) Property Information","Copy of FinalHeader 1","Sheet1"],"not_rendered":{"charts":0,"images":2,"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":"Instructions","index":0,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Instructions:"]
["Complete each tab on this worksheet to provide Aptexx with your customer information. "]
["Email your Aptexx rep when complete. "]

{"sheet":"1) Corporate Data","index":1,"n_rows":32,"n_cols":1,"rows_kept":32,"cut":false,"hidden":false,"merged":[[27,0,27,7]]}
["DBA"]
["Legal Name (\"Merchant\")"]
["State of Incorporation"]
["In Business Since"]
["Physical Address (No PO Boxes)"]
["City"]
["State"]
["Zip"]
["Website Address"]
["Customer Support Phone"]
["Tax ID"]
["Corporate Contact Person"]
["Home Address"]
["City"]
["State"]
["Zip"]
["Phone"]
["Date of Birth"]
["DL#"]
["DL State"]
["Authorized Contact - Signatory Name"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Electronic Signature"]

{"sheet":"2) Admin Access","index":2,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Super User - Please add only one user. We will train the 'Super User' how to add additional users"]
["First Name","Last Name ","Email Address","Phone"]

{"sheet":"3) Preferences","index":3,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
["Appendix A – Payments Anywhere"]
["Please select desired Client preferences:"]
["FEATURE","ANSWER",null,"DETAIL:",null,"Aptexx Resident Payment StatusesThere are 3 payment statuses for each resident profile. The payment status indicates if and how a resident can make a payment to their Aptexx profile."]
["Payment Amount (Must Choose One);",null,null,null,null,"Accept Payments Indicates that a resident can make a payment online with any payment method accepted by the property ."]
["Any Amount","Yes","No","Resident can make payments of any amount at any time (DEFAULT)",null,"Certified Funds Only Indicates that a resident can make a payment with Aptexx, but only with payment methods that guarantee the funds are available. These include Debit Cards, Credit Cards, Money Orders, Netspend Accounts. For integrated properties, Aptexx reads the resident's current 'Cash Equivalent' setting on the resident's profile in your property management software."]
["Current Balance","Yes","No","Resident can pay ONLY their balance as of the current date",null,"Do Not Accept Payments Indicates that a resident cannot make a payment in Aptexx For integrated properties, Aptexx reads the resident's 'Do Not Accept Payments', 'Eviction' or equivalent setting on the resident's profile in your property management software."]
["Prepay","Yes","No","Resident can pay their balance as of the current date or more.\nResident CANNOT pay less than their current balance"]
["Scheduled Payments (Choose one of three Options):",null,null,null,null,"* Data from integrated external accounting/property management systems is pulled on a recurring basis (normally once per day). Additions or changes made in these external systems such as balances, names, resident status, etc. do not immediately appear."]
["Fixed","Yes","No","Resident will be able to set up scheduled payments to pay a fixed amount, as entered during setup.\nThe payment will be processed on the scheduled date regardless of whether a balance is due or not. "]
["Balance","Yes","No","(DEFAULT SETTING)Resident will only be able to set up scheduled payments to pay the full balance on their account. \nThe resident will be asked to specify a maximum amount as a failsafe. \nIf the balance at the time the payment is scheduled to process exceeds the maximum amount set by the resident, no payment will be processed. \nIf the balance is $0 at the time the payment is scheduled to process, no payment will be processed."]
["Both","Yes","No","Resident can choose to either set up scheduled payments for a fixed amount each month or schedule to pay the full balance each month."]
["Payment Blackouts","1 – 31",null,"Restrict the dates you accept scheduled payments. If restricting, residents CANNOT make ANY payments during the selected days.Example: Payment blackout 6-28 means that residents will not be able to make any payments on the 6 through the 28th of any month and will only be able to make payments on the 29th through the 5th, e.g. for October rent, they would be able to make a payment on Sept 29, Sept 30, Oct 1, Oct 2, Oct 3 and Oct 4)."]
["ACH Blackout (Guaranteed Funds)","1 – 31",null,"If restricting, residents can ONLY make payments with Certified Funds (either credit card or debit card) during the selected days."]
["Partial Blackout","1 – 31",null,"Restricts partial payments during dates selected so that full balance payments are required."]
["In Person Payments (Application Fees, Deposits)"]
["In Person Payments Accepted?","Yes","No","*Per Services Agreement:In Person Payments can be taken in the property office for application fees and security deposits."]
["Fees payable to?","Property","Applicant","*Per Services Agreement:In Person Payment fees can be paid by the property or by the applicant."]
["First time Resident Account Login - Account Access"]
["Resident Code","Yes","No","(DEFAULT SETTING)Property Manager will be required to provide the resident their unique resident code (as indicated in your property management software). \n\nThe resident will only be able to log in and sign up to make payments if they know their resident code."]
["Search Capability - Last name and Unit #","Yes","No","Allow the resident to find themselves (for the first time) by searching. Search results are based on resident’s name and unit # as specified in Aptexx. \n\nAll residents that match (and who do not have a payment history) will be displayed.Note: Search results will show all resident names that have not yet made a payment and that fit the search criteria. \nIt is possible for a resident to choose an incorrect profile and make a payment to that account. \nThe resident will be responsible for selecting their correct profile."]
["ACCOUNT INTEGRATION"]
["Deposit","Yes","No","Residents must be set up in your property management software to show up in Aptexx. \nPayments will be integrated on a nightly basis into your property management software as an un-posted A/R batch.Note: This setting will allow you to take a deposit payment only if the resident is set up in your property management software first. \nSome integrations update Aptexx the next day. You will not be able to create an applicant in Aptexx on the fly."]
["Application","Yes","No","Residents must be set up in your property management software to show up in Aptexx. \nPayments will be integrated on a nightly basis into your property management software as an un-posted A/R batch.Note: This setting will allow you to take an application payment only if the resident is set up in your property management software first. \nSome integrations update Aptexx the next day. You will not be able to create an applicant in Aptexx on the fly."]

{"sheet":"4) Property Information","index":4,"n_rows":1,"n_cols":68,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["*Property Name","*Legal Name","*First name","*Last Name","Integration ID","*Address","*City","*State","*Zip","*Phone","*Timezone","*Tax ID","*Average Rent","*Num Units","Key Bank Billing Account","Key Bank Billing Routing","Key Bank Start","Key Bank Billing Element","Rent Bank Account","Rent Bank Routing","Rent BankServ Client ID","Rent BankServ Client Code","Rent BankServ ICL Code","Rent ProPay ACH Tier","Rent ProPay Card Tier","Rent Balance Type","*Rent Amount Type","Rent Schedule Amount Type","Rent ACH","Rent Card","Rent ICL","Rent ACH Flat Fee","Rent Debit Flat Fee","Rent Credit Percentage Fee","Rent Max Amt","Application Bank Account","Application Bank Routing","Application BankServ Client ID","Application BankServ Client Code","Application BankServ ICL Code","Application ProPay Card Tier","Application ACH","Application Card","Application ACH Flat Fee","Application Debit Flat Fee","Application Credit Percentage Fee","Application Max Amt","Deposit Bank Account","Deposit Bank Routing","Deposit BankServ Client ID","Deposit BankServ Client Code","Deposit BankServ ICL Code","Deposit ProPay Card Tier","Deposit ACH","Deposit Card","Deposit ICL","Deposit ACH Flat Fee","Deposit Debit Flat Fee","Deposit Credit Percentage Fee","Deposit Max Amt","Result Limit","Engagement Days","Search Type","Messaging","Payments","Scanning","Maintenance","Surveys"]

{"sheet":"Copy of FinalHeader 1","index":5,"n_rows":40,"n_cols":68,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
["*Property Name","*Legal Name","*First name","*Last Name","Integration ID","*Address","*City","*State","*Zip","*Phone","*Timezone","*Tax ID","*Average Rent","*Num Units","Key Bank Billing Account","Key Bank Billing Routing","Key Bank Start","Key Bank Billing Element","Rent Bank Account","Rent Bank Routing","Rent BankServ Client ID","Rent BankServ Client Code","Rent BankServ ICL Code","Rent ProPay ACH Tier","Rent ProPay Card Tier","Rent Balance Type","*Rent Amount Type","Rent Schedule Amount Type","Rent ACH","Rent Card","Rent ICL","Rent ACH Flat Fee","Rent Debit Flat Fee","Rent Credit Percentage Fee","Rent Max Amt","Application Bank Account","Application Bank Routing","Application BankServ Client ID","Application BankServ Client Code","Application BankServ ICL Code","Application ProPay Card Tier","Application ACH","Application Card","Application ACH Flat Fee","Application Debit Flat Fee","Application Credit Percentage Fee","Application Max Amt","Deposit Bank Account","Deposit Bank Routing","Deposit BankServ Client ID","Deposit BankServ Client Code","Deposit BankServ ICL Code","Deposit ProPay Card Tier","Deposit ACH","Deposit Card","Deposit ICL","Deposit ACH Flat Fee","Deposit Debit Flat Fee","Deposit Credit Percentage Fee","Deposit Max Amt","Result Limit","Engagement Days","Search Type","Messaging","Payments","Scanning","Maintenance","Surveys"]
[{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"QUERY('2) Property Information'!A2:N40)\"),\"\")","v":""},"","","","","","","","","","","","","",null,null,null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"QUERY('2) Property Information'!O2:P40)\"),\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"QUERY('2) Property Information'!Q2:R40)\"),\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"QUERY('2) Property Information'!S2:T40)\"),\"\")","v":""},""]
["","","","","","","","","","","","","","",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,"",""]
["","","","","","","","","","","","","","",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,"",""]
["","","","","","","","","","","","","","",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,"",""]
["","","","","","","","","","","","","","",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,"",""]
["","","","","","","","","","","","","","",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,"",""]
["","","","","","","","","","","","","","",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,"",""]
["","","","","","","","","","","","","","",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,"",""]
["","","","","","","","","","","","","","",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,"",""]
["","","","","","","","","","","","","","",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,"",""]
["","","","","","","","","","","","","","",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,"",""]
["","","","","","","","","","","","","","",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,"",""]
["","","","","","","","","","","","","","",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,"",""]
["","","","","","","","","","","","","","",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,"",""]
["","","","","","","","","","","","","","",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,"",""]
["","","","","","","","","","","","","","",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,"",""]
["","","","","","","","","","","","","","",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,"",""]
["","","","","","","","","","","","","","",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,"",""]
["","","","","","","","","","","","","","",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,"",""]
["","","","","","","","","","","","","","",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,"",""]
["","","","","","","","","","","","","","",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,"",""]
["","","","","","","","","","","","","","",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,"",""]
["","","","","","","","","","","","","","",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,"",""]
["","","","","","","","","","","","","","",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,"",""]
["","","","","","","","","","","","","","",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,"",""]
["","","","","","","","","","","","","","",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,"",""]
["","","","","","","","","","","","","","",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,"",""]
["","","","","","","","","","","","","","",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,"",""]
["","","","","","","","","","","","","","",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,"",""]
["","","","","","","","","","","","","","",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,"",""]
["","","","","","","","","","","","","","",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,"",""]
["","","","","","","","","","","","","","",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,"",""]
["","","","","","","","","","","","","","",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,"",""]
["","","","","","","","","","","","","","",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,"",""]
["","","","","","","","","","","","","","",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,"",""]
["","","","","","","","","","","","","","",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,"",""]
["","","","","","","","","","","","","","",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,"",""]
["","","","","","","","","","","","","","",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,"",""]
["","","","","","","","","","","","","","",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,"",""]

{"sheet":"Sheet1","index":6,"n_rows":52,"n_cols":1,"rows_kept":52,"cut":false,"hidden":true,"merged":[]}
["US/Alaska"]
["US/Aleutian"]
["US/Arizona"]
["US/Central"]
["US/East-Indiana"]
["US/Eastern"]
["US/Hawaii"]
["US/Indiana-Starke"]
["US/Michigan"]
["US/Mountain"]
["US/Pacific"]
["US/Pacific-New"]
["US/Samoa"]
["DDAAPTXP"]
["DDAAPTXR"]
["ACH0"]
["echeck195"]
["eCheck2"]
["Key_Ach0"]
["wells0"]
["CURRENT"]
["ITEMIZED"]
["FORWARD"]
["CURRENT_FUTURE"]
["CURRENT_FUTURE_BALANCE"]
["ANY"]
["BALANCE_ONLY"]
["BALANCE_OVER"]
["FIXED"]
["BALANCE"]
["FIXED_BALANCE"]
["BANK_SERV"]
["PRO_PAY"]
["KEY_BANK"]
["PRO_PAY"]
["BANK_SERV"]
["KEY_BANK"]
["GrossSettle"]
["InPerson"]
["wells0"]
["key_GrossSettle"]
["key_InPerson"]
["key_wells0"]
["BANK_SERV"]
["KEY_BANK"]
["PRO_PAY"]
["UNIT"]
["ADDRESS"]
["CODE"]
["CODE_EMAIL"]
[false]
[true]