Part 2: Extract and Upload Trial Balance Data for Adaptive Planning - Part 2

Learn how to properly erase old data, import new actuals from SAP BO into Adaptive Planning, and validate the results against a Consolidated Trial Balance.

May 12, 2026 By Dimitri Aroney

This guide walks you through replacing existing trial balance data from SAP BO into Adaptive Planning. You will learn how to erase previous data safely, import updated actuals, and validate the new data against the Consolidated Trial Balance.

Step 1: Erase Previous Data

Before loading a new dataset, clear the existing data for the target period.

Step #1: Click Erase Data. — Click **Erase Data**.

Step #2: Select the Actuals version. — Select the **Actuals** version.

Selecting the wrong version will permanently erase incorrect data. Always double-check your version selection.

Step #3: Under the Accounts section, select GL accounts. — Under the Accounts section, select **GL accounts**.

Do not select any other account types, as this could negatively impact system expectations.

Step #4: Select the specific time range you intend to erase and replace, such as Apr - 2026. — Select the specific time range you intend to erase and replace, such as **Apr - 2026**.

Set the levels to All levels to ensure all appropriate cost centers are cleared.

Step #5: Click Erase Data at the bottom of the page. — Click **Erase Data** at the bottom of the page.

Step #6: Review the warning prompt carefully. If the version, time period, and account scope are correct, click OK. — Review the warning prompt carefully. If the version, time period, and account scope are correct, click OK.

Step 2: Import New Actuals

Step #7: Navigate back to the Integration dashboard and click Import Data. — Navigate back to the Integration dashboard and click **Import Data**.

Ensure you are importing into the Actuals version and the Standard sheet.

Step #8: Click Choose File. — Click **Choose File**.

Step #9: Select your updated GL data template file. — Select your updated GL data template file.

Never delete the auxiliary tabs (Instructions, Versions) from the Excel template before uploading. The import will fail if these tabs are missing.

Step #10: Click Import. — Click **Import**.

Step #11: Review the Dimension Value mapping and click Continue. — Review the Dimension Value mapping and click **Continue**.

Step #12: Review the Account Codes mapping and click Continue. — Review the Account Codes mapping and click **Continue**.

Step #13: Review the Levels mapping and click Continue. — Review the Levels mapping and click **Continue**.

If there are any mapping errors, they will appear in red text at the top and highlight the missing values in yellow. If an unknown code appears, check with the FP&A team before proceeding.

Step #14: When asked if you want to make the newly imported actuals visible on sheets, select No for now. — When asked if you want to make the newly imported actuals visible on sheets, select No for now.

Step #15: Click Import Actuals. — Click **Import Actuals**.

Step 3: Review the Import Results

Once the import completes, thoroughly read the results page. You may encounter warning messages regarding dimension values or implied splits on balance sheet accounts. Often, these data splits are ignored for balance sheet imports without significantly impacting P&L forecasting.

You can verify the data was successfully loaded by navigating to your Sheets and reviewing the Income Statement for the imported month.

Step 4: Validate Data Against SAP BO

To ensure the import was successful, compare the imported Adaptive Planning data against the Consolidated Trial Balance exported from SAP BO.

Step #16: In Adaptive Planning, go to the Reports interface and select Shared. — In Adaptive Planning, go to the Reports interface and select **Shared**.

Step #17: Click the FY26 Coates folder. — Click the **FY26 Coates** folder.

Step #18: Open the Integration Check Reports folder. — Open the **Integration Check Reports** folder.

Step #19: Select the FY26 Actuals by Entity (CTA P&L Check expanded) report. — Select the **FY26 Actuals by Entity (CTA P&L Check expanded)** report.

Step #20: Change the time parameter to the month you just imported (e.g., Apr - 2026). — Change the time parameter to the month you just imported (e.g., **Apr - 2026**).

Step #21: Click Run Report to generate the data, then download the file. — Click **Run Report** to generate the data, then download the file.

Step #22: Open the downloaded report in Excel. — Open the downloaded report in Excel.

Compare the Net Income for each entity in its local currency against the SAP BO Consolidated Trial Balance. Tying off amounts in local currency ensures differences in FX rates between the two systems do not cause reconciliation discrepancies.