{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Sheet1","Validations","Lists","Errors"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"Sheet1","index":0,"n_rows":4,"n_cols":72,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,53,0,71],[0,0,0,19],[0,20,0,36],[0,37,0,52]]}
["Property/Unit Info",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tenant info",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tenant Address and Contact Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rental Owner Info"]
["Property name *","Unit number *","Sub type *","Operating bank account *","Property reserve amount (optional)","Property address line 1 *","Property address line 2 (optional)","Property address line 3 (optional)","Unit address line 1 *","Unit address line 2 (optional)","Unit address line 3 (optional)","City/Locality *","State/Province/Territory *","Postal code *","Building description (Used for listings) (optional)","Unit description (Used for listings) (optional)","Size (optional)","Bedrooms (optional)","Bathrooms (optional)","Market rent (optional)","Tenant First Name *","Tenant Last Name *","Lease Start Date (optional)","Lease End Date (optional)","Rent Frequency (optional)"," Rent Amount ","Rent Account","Rent Next Due Date","Rent Memo"," Rent 2 Amount ","Rent 2 Account","Rent 2 Next Due Date","Rent 2 Memo"," Rent 3 Amount ","Rent 3 Account","Rent 3 Next Due Date","Rent 3 Memo","Login email (optional)","Alternate email (optional)","Tenant Street Address Line 1 (optional)","Tenant Street Address Line 2 (optional)","Tenant Street Address Line 3 (optional)","City/Locality (optional)","State/Province/Territory (optional)","Postal Code (optional)","Tenant Home Phone (optional)","Tenant Work Phone (optional)","Tenant Mobile (optional)","Tenant Fax (optional)","Emergency Contact Name (optional)","Emergency Contact Phone (optional)","Date Of Birth (optional)","Comments (optional)","Rental owner name *","Rental Owner Street Address Line 1 (optional)","Rental Owner Street Address Line 2 (optional)","Rental Owner Street Address Line 3 (optional)","Rental Owner City/Locality (optional)","Rental Owner State/Province/Territory (optional)","Postal code (optional)","Rental Owner Login email (optional)","Alternate email (optional)","Tax payer ID (TIN) (optional)","Eligible for 1099 (optional)","Rental Owner Home phone (optional)","Rental Owner Work phone (optional)","Rental Owner Mobile (optional)","Rental Owner Fax (optional)","Rental Owner Date of birth (optional)","Comments (optional)","Rental Owner Agreement start date (optional)","Rental Owner Agreement end date (optional)"]
["10 School Street",1,"Multi-Family","Bank of America Operating",null,"10 School St.",null,null,"10 School St., 1",null,null,"Medford","MA","01234","Single family home near elementary school.","Spacious home with finished basement.",1500,null,"1 Bath",1850,"Jim","Herbert","2019-01-01",null,"Monthly",2000,"Rent Income","2022-01-01",null,null,null,null,null,null,null,null,null,"emma@test.com",null,"123 Main St. - B",null,null,"Boston","MA","02115","(617) 098-9827","(987) 838-8383","(781) 555-5847","(781) 555-8547",null,null,null,null,"Mike Kelley"]
["10 School Street",2,"Multi-Family","Bank of America Operating",null,"10 School St.",null,null,"10 School St., 2",null,null,"Medford","MA","01234","Single family home near elementary school.","Spacious home with finished basement.",1500,null,"3 Bath",1900,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Millie Wilson","45 Park Ave.",null,null,"Somerville","MA","02129","millie@test.com",null,"12-3456789","No","(978) 555-3456","(617) 555-2349","(617) 555-3368","(633) 555-3449","1964-01-16",null,"2001-04-16","2019-12-31"]

{"sheet":"Validations","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Lists","index":2,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Buildium lists"]
[]
[null,"Property subtype","Rent frequency","Eligible for 1099","Bedrooms","Bathrooms","Standard income accounts"]
[null,"Single-Family","Monthly","Yes","1 Bed","1 Bath","Rent Income",null,"Association Fee Income"]
[null,"Multi-Family","Daily","No","2 Bed","1.5 Bath","Renters Insurance Income",null,"Late Fee Income"]
[null,"Condo/Townhome","Weekly",null,"3 Bed","2 Bath","Laundry Income",null,"Application Fee Income"]
[null,"Industrial","Every two weeks",null,"4 Bed","2.5 Bath","Cleaning and Maint Income",null,"NSF Fee Income"]
[null,"Office","Every two months",null,"5 Bed","3 Bath","Other Income",null,"Convenience Fee"]
[null,"Retail","Quarterly",null,"6 Bed","3.5 Bath","Parking Income",null,"Owner Contribution Convenience Fee"]
[null,"Shopping center",null,null,"7 Bed","4 Bath","Repairs Income",null,"Interest Income"]
[null,"Storage",null,null,"8 Bed","4.5 Bath","Utility Income"]
[null,"Parking space",null,null,"9 Bed+","5 Bath","Affordable Housing Income"]
[null,null,null,null,"Studio","5+ Bath"]

{"sheet":"Errors","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}