--- title: AI data mapping for rent rolls description: Pereview empowers you to create time-saving data mapping templates for new trial balance file types. Now, if a property manager, LP, or sponsor uses a source system Pereview doesn’t recognize, you can create, save, and reuse the template. This saves you time and gives you more control. --- [Skip to content](https://academy.pereviewsoftware.com/knowledge-base/ai-data-mapping-for-rent-rolls#main-content) [![Pereview Logo Dark Blue](https://academy.pereviewsoftware.com/hs-fs/hubfs/Pereview%20Logo%20Dark%20Blue.png?width=250&height=73&name=Pereview%20Logo%20Dark%20Blue.png)](https://academy.pereviewsoftware.com/knowledge-base?hsLang=en) Open main navigation Close main navigation How can we help you? - There are no suggestions because the search field is empty. 1. [Pereview Knowledge Base](https://academy.pereviewsoftware.com/knowledge-base?hsLang=en) 2. [Data Ingestion & Management](https://academy.pereviewsoftware.com/knowledge-base/data-ingestion-management?hsLang=en) 3. [AI Data Mapping](https://academy.pereviewsoftware.com/knowledge-base/data-ingestion-management?hsLang=en#ai-data-mapping) September 3, 2026 # AI data mapping for rent rolls Pereview empowers you to create time-saving data mapping templates for new rent roll file types. Now rather than attempting to manually convert unsupported file types, leverage Pereview’s AI data mapping tool to quickly create and save your new mapping that will be automatically applied the next time a rent roll is loaded from that source system. Before you get started, please note the following do’s and don’ts to help ensure success. **Do:** - Upload an Excel file with a single month’s rent roll. - Choose “New Rent Roll Template” from the template selection drop-down.   [![rent-roll-tempalte-drop-down](https://academy.pereviewsoftware.com/hs-fs/hubfs/rent-roll-tempalte-drop-down.png?width=582&height=260&name=rent-roll-tempalte-drop-down.png)](https://academy.pereviewsoftware.com/hubfs/rent-roll-tempalte-drop-down.png?hsLang=en)   **Don't:** - Add linked workbooks. - Upload an Excel file with multiple sheets. - Add the same file more than once. - Add files with nested rows or tables. ### **AI Data Mapping Walkthrough** **Step 1: Data Upload** **Go to Admin \> Data Upload** Begin by dragging the selected file into the Import With AI upload box. A check mark will appear once the file is ready to be mapped. **Note:** If it does not automatically appear, select “New Rent Roll Template” from the drop-down box. By selecting “New Rent Roll Template,” you are telling Pereview that this is a new file type that you would like to map through the data mapping wizard. When you are ready to proceed in creating the mapping for the file, click save and continue. [![](https://academy.pereviewsoftware.com/hs-fs/hubfs/undefined-Sep-03-2026-02-24-17-7429-PM.png?width=670&height=337&name=undefined-Sep-03-2026-02-24-17-7429-PM.png)](https://academy.pereviewsoftware.com/hubfs/undefined-Sep-03-2026-02-24-17-7429-PM.png?hsLang=en) **Step 2: Selection** Pereview will now walk you through a guided wizard to assist in mapping the file beginning on the Selection page. On this page, you will see all of the rows from your spreadsheet. The table range is already selected based on the AI’s suggestion and usually will not need to be changed. Scroll to the bottom of the section to confirm that all rows are present. [![](https://academy.pereviewsoftware.com/hs-fs/hubfs/undefined-Sep-03-2026-02-24-20-9085-PM.png?width=670&height=334&name=undefined-Sep-03-2026-02-24-20-9085-PM.png)](https://academy.pereviewsoftware.com/hubfs/undefined-Sep-03-2026-02-24-20-9085-PM.png?hsLang=en) In this example, the values show “48 rows, 48 selected.” [![](https://academy.pereviewsoftware.com/hs-fs/hubfs/undefined-Sep-03-2026-02-24-19-5459-PM.png?width=670&height=341&name=undefined-Sep-03-2026-02-24-19-5459-PM.png)](https://academy.pereviewsoftware.com/hubfs/undefined-Sep-03-2026-02-24-19-5459-PM.png?hsLang=en) If the highlighted start or end is wrong, click the correct first row, then the last row to reset the range. Click save and continue. **Step 3: Mapping** The mapping page gives you the opportunity to review Pereview’s suggested mappings and make any necessary changes, so your file’s data is correctly mapped in Pereview.  Specifically, the mappings page is divided into three columns as seen below. The **Source** column shows the name of the data from your Excel file. The **Pereview** column shows the name for that information in Pereview. The **Example** column shows the corresponding cell from your Excel file.  Pereview will suggest a mapping for each source field. To change the suggested mapping or exclude a source field, click the drop-down in the **Pereview** column. For advanced conversion options, click the gear icon. Now, save and continue.  [![](https://academy.pereviewsoftware.com/hs-fs/hubfs/undefined-Sep-03-2026-02-24-18-8942-PM.png?width=670&height=336&name=undefined-Sep-03-2026-02-24-18-8942-PM.png)](https://academy.pereviewsoftware.com/hubfs/undefined-Sep-03-2026-02-24-18-8942-PM.png?hsLang=en) **Note:** To avoid accidentally mapping the same field to multiple rows, a red outline and a warning message will appear around the fields that need to be updated. [![](https://academy.pereviewsoftware.com/hs-fs/hubfs/undefined-Sep-03-2026-02-24-17-4824-PM.png?width=670&height=344&name=undefined-Sep-03-2026-02-24-17-4824-PM.png)](https://academy.pereviewsoftware.com/hubfs/undefined-Sep-03-2026-02-24-17-4824-PM.png?hsLang=en) **Step 4: Grouping** **This section will only appear when groups are identified in your file.** Here, you can click a column header to choose the column that identifies each group, then flag the row where each group begins. A group runs until the next flagged row. Collapse groups to review the overall structure, or expand one to see its rows. Click save and continue. [![](https://academy.pereviewsoftware.com/hs-fs/hubfs/undefined-Sep-03-2026-02-24-21-5135-PM.png?width=670&height=341&name=undefined-Sep-03-2026-02-24-21-5135-PM.png)](https://academy.pereviewsoftware.com/hubfs/undefined-Sep-03-2026-02-24-21-5135-PM.png?hsLang=en) **Step 5: Exclusions** On the exclusions page of the wizard, you can select any rows you do not want to import by checking the box next to each row. Total and empty rows should be excluded. Click save and continue. [![](https://academy.pereviewsoftware.com/hs-fs/hubfs/undefined-Sep-03-2026-02-24-20-2205-PM.png?width=670&height=341&name=undefined-Sep-03-2026-02-24-20-2205-PM.png)](https://academy.pereviewsoftware.com/hubfs/undefined-Sep-03-2026-02-24-20-2205-PM.png?hsLang=en) **Step 6: Submit** After you complete this process, you will be prompted to name the mapping. Pereview displays the file name in this format: Pereview AI for Rent Roll: \[Saved Mapping Name\]. Replace the bracketed text with the source system name, such as “\[Yardi Breeze\].” The next time you upload this file, Pereview will recognize your saved mapping and suggest that you use it to apply your configuration automatically. Click save and continue. ![Step-6-save-mapping-RR-Yardi](https://academy.pereviewsoftware.com/hs-fs/hubfs/Step-6-save-mapping-RR-Yardi.png?width=670&height=340&name=Step-6-save-mapping-RR-Yardi.png) **Step 7: Queuing and Loading Data** Once AI identifies the file and organizes the data, it is queued for upload. When the Status column shows “Committed,” the data has passed the initial validation checks and has been successfully loaded into Pereview for reporting and analysis. [![step-7-rr-que](https://academy.pereviewsoftware.com/hs-fs/hubfs/step-7-rr-que.png?width=670&height=337&name=step-7-rr-que.png)](https://academy.pereviewsoftware.com/hubfs/undefined-Sep-03-2026-02-24-17-9922-PM.png?hsLang=en) The next time you upload this file type, the saved mapping will be applied automatically, saving you time while helping ensure consistency and accuracy. - [Pereview 101](https://academy.pereviewsoftware.com/knowledge-base/pereview-101?hsLang=en#main-content) - [Navigation](https://academy.pereviewsoftware.com/knowledge-base/pereview-101?hsLang=en#navigation) - [Add Records](https://academy.pereviewsoftware.com/knowledge-base/pereview-101?hsLang=en#add-records) - [Support](https://academy.pereviewsoftware.com/knowledge-base/pereview-101?hsLang=en#support) - [Product Features](https://academy.pereviewsoftware.com/knowledge-base/product-features?hsLang=en#main-content) - [Workflow](https://academy.pereviewsoftware.com/knowledge-base/product-features?hsLang=en#workflow) - [Custom Forms](https://academy.pereviewsoftware.com/knowledge-base/product-features?hsLang=en#custom-forms) - [Updates and User Experience](https://academy.pereviewsoftware.com/knowledge-base/product-features?hsLang=en#updates-and-user-experience) - [Reports](https://academy.pereviewsoftware.com/knowledge-base/reports?hsLang=en#main-content) - [Formatted Reports](https://academy.pereviewsoftware.com/knowledge-base/reports?hsLang=en#formatted-reports) - [Pereview Analytics](https://academy.pereviewsoftware.com/knowledge-base/reports?hsLang=en#pereview-analytics) - [Custom Forms Reports](https://academy.pereviewsoftware.com/knowledge-base/reports?hsLang=en#custom-forms-reports) - [Data Validation](https://academy.pereviewsoftware.com/knowledge-base/data-validation?hsLang=en#main-content) - [Overview](https://academy.pereviewsoftware.com/knowledge-base/data-validation?hsLang=en#overview) - [Data Validation Process](https://academy.pereviewsoftware.com/knowledge-base/data-validation?hsLang=en#data-validation-process) - [Data Ingestion & Management](https://academy.pereviewsoftware.com/knowledge-base/data-ingestion-management?hsLang=en#main-content) - [Data Management](https://academy.pereviewsoftware.com/knowledge-base/data-ingestion-management?hsLang=en#data-management) - [AI Data Mapping](https://academy.pereviewsoftware.com/knowledge-base/data-ingestion-management?hsLang=en#ai-data-mapping) - [System Admin & Technical Documentation](https://academy.pereviewsoftware.com/knowledge-base/system-admin-technical-documentation?hsLang=en#main-content) - [User Management](https://academy.pereviewsoftware.com/knowledge-base/system-admin-technical-documentation?hsLang=en#user-management) - [Configuration Options](https://academy.pereviewsoftware.com/knowledge-base/system-admin-technical-documentation?hsLang=en#configuration-options) - [Pereview Outbound API](https://academy.pereviewsoftware.com/knowledge-base/system-admin-technical-documentation?hsLang=en#pereview-outbound-api) - [SSO](https://academy.pereviewsoftware.com/knowledge-base/system-admin-technical-documentation?hsLang=en#sso) - [Pereview Newsletters](https://academy.pereviewsoftware.com/knowledge-base/pereview-newsletters?hsLang=en#main-content) - [2026 Newsletters](https://academy.pereviewsoftware.com/knowledge-base/pereview-newsletters?hsLang=en#2026-newsletters) - [2025 Newsletters](https://academy.pereviewsoftware.com/knowledge-base/pereview-newsletters?hsLang=en#2025-newsletters) - [2024 Newsletters](https://academy.pereviewsoftware.com/knowledge-base/pereview-newsletters?hsLang=en#2024-newsletters) [![Pereview Logo Dark Blue](https://academy.pereviewsoftware.com/hs-fs/hubfs/Pereview%20Logo%20Dark%20Blue.png?width=150&height=44&name=Pereview%20Logo%20Dark%20Blue.png "Pereview Logo Dark Blue")](http://pereviewsoftware.com) 12400 Coit Rd, Suite 570, Dallas, TX 75251 [mailto:support@pereviewsoftware.com](mailto:support@pereviewsoftware.com) Copyright © 2026, Pereview Software