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.
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.
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.”
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.
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.
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.
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.
The next time you upload this file type, the saved mapping will be applied automatically, saving you time while helping ensure consistency and accuracy.