--- title: AI data mapping for trial balances 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-trial-balances#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 trial balances Pereview empowers you to create time-saving data mapping templates for new trial balance 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 trial balance is loaded from that source system. Before you get started, please review the requirements below to ensure seamless processing: **Do:** - Upload an Excel file with a single month’s trial balance. - Choose “New Trial Balance Template” from the template selection drop-down. ![](https://academy.pereviewsoftware.com/hs-fs/hubfs/undefined-Sep-03-2026-02-30-44-8485-PM.png?width=582&height=360&name=undefined-Sep-03-2026-02-30-44-8485-PM.png)   **Don't:** - Add linked workbooks. - Add the same file more than once. - Upload an Excel file with multiple sheets. - Add files with nested rows or tables. ### **AI Data Mapping Walkthrough** **Step 1: Data Upload** **Go to Admin \> Data Upload** Begin by dragging and dropping 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 Trial Balance Template” from the drop-down box. By selecting “New Trial Balance 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-30-42-8033-PM.png?width=670&height=335&name=undefined-Sep-03-2026-02-30-42-8033-PM.png)](https://academy.pereviewsoftware.com/hubfs/undefined-Sep-03-2026-02-30-42-8033-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.  In the example, the values show “119 rows, 119 selected.” [![](https://academy.pereviewsoftware.com/hs-fs/hubfs/undefined-Sep-03-2026-02-30-44-1639-PM.png?width=670&height=340&name=undefined-Sep-03-2026-02-30-44-1639-PM.png)](https://academy.pereviewsoftware.com/hubfs/undefined-Sep-03-2026-02-30-44-1639-PM.png?hsLang=en) If the highlighted start or end row is incorrect, click on the correct first row, then the last row to reset the range. When you are satisfied with the selection, click save and continue. **Step 3: Mappings** The mappings page of the wizard 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 outlined 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 however you should always review for accuracy. 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-30-43-6097-PM.png?width=670&height=340&name=undefined-Sep-03-2026-02-30-43-6097-PM.png)](https://academy.pereviewsoftware.com/hubfs/undefined-Sep-03-2026-02-30-43-6097-PM.png?hsLang=en) **Step 4: 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-30-42-5065-PM.png?width=670&height=336&name=undefined-Sep-03-2026-02-30-42-5065-PM.png)](https://academy.pereviewsoftware.com/hubfs/undefined-Sep-03-2026-02-30-42-5065-PM.png?hsLang=en) **Step 5: 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 Trial Balance: \[Saved Mapping Name\]**.  Replace the bracketed text with the source system name, such as “\[Acumatica Trial Balance\].”  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. [![Step5-submit](https://academy.pereviewsoftware.com/hs-fs/hubfs/Step5-submit.png?width=623&height=312&name=Step5-submit.png)](https://academy.pereviewsoftware.com/hubfs/undefined-Sep-03-2026-02-30-42-2003-PM.png?hsLang=en) **Step 6: 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. [![scene-7-status-que-2](https://academy.pereviewsoftware.com/hs-fs/hubfs/scene-7-status-que-2.png?width=623&height=299&name=scene-7-status-que-2.png)](https://academy.pereviewsoftware.com/hubfs/undefined-Sep-03-2026-02-30-43-3299-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