Import data from SAP S4 HANA

You can import trial balance and general ledger data from SAP S4 HANA.

Export your data from SAP S4 HANA

If you want to import trial balance or general ledger data into your engagement from SAP S4 HANA, you must first export that data from SAP.

To export trial balance data from SAP:

  1. Log in to SAP.

  2. In the SAP menu bar, enter S_ALR_87012284 as the transaction code and then select Execute.

    The transaction code entered in the SAP menu bar.

  3. Enter the correct information for the data you want to export in the following fields:

    • Chart of Accounts

    • Company code

    • Financial statement version

    • Language

    • Reporting year

    • Reporting periods

    • Comparison year

    • Comparison periods

    The Financial Statements screen of SAP with the correct information entered in the required fields.

  1. Select Execute.

  2. From the top menu, select System | List | Save | Save to save the report.

  3. In the dialog, select Spreadsheet (XLSX) to save the report as a .xlsx file.

To export general ledger data from SAP:

  1. Log in to SAP.

  2. In the SAP menu bar, enter FAGLL03 as the transaction code and then select Execute.

    The transaction code entered in the SAP menu bar.

  3. Enter the Company code for the data you want to export.

  4. In the Line Item Selection section, select All Items and enter the ending date of the financial year for the data you want to export.

  5. Select Execute.

  6. From the toolbar, select the Change Layout () icon.

  7. In the Change Layout dialog, ensure the following fields are selected and then select Copy ().:

    • G/L Account

    • Amount in Local Currency

    • Text

    • Document Number

    • Document Type

    • Document Date

    • Posting Date

    • Posting Key

    • Local Currency

    • General Ledger Currency

    The Change Layout dialog.

  8. From the toolbar, select the Subtotal () icon.

  9. In the Define Sort Order dialog, ensure the Subtotal () boxes are unchecked for all fields and then select Copy ().

    The Define Sort Order dialog.

  10. You can save the customized layout to use it again later:

    1. Select the Save Layout () icon from the toolbar.

    2. In the Layout: Save as dialog, rename the layout, add a description and then select Save.

      The Layout: Save as dialog.

  11. To export the report, from the top menu, select List | Export | Spreadsheet.

  12. In the Export As dialog, enter a name for the file and ensure the file format is Spreadsheet (.xlsx).

  13. Select the Export to button to export your data.

Import your data

After you export your data, you can then import it into your engagement file.

To import the data into your engagement:

  1. On the Data page, go to the Import tab and select Accounting Software or Structured File.

  2. If you’ve previously imported data, select Add data.

  3. If your engagement is consolidated and has internal subsidiary entities, select which entity you want to import data for from the list.

  4. Select SAP (File) from the list of data sources.

    If the option is not visible, you can use the search box to find it.

  5. At the Upload stage of the import wizard, select or drag-drop the general ledger and trial balance data files you exported, then select Next.

  6. At the Configure Data stage of the import wizard:

    • Reporting period is automatically filled with the reporting period of the data.

    • Start Date is automatically filled with the start date of the data.

    • End Date is automatically filled with the end date of the data.

  7. In Select dataset type, choose the type of datasets you are importing.

    Note that only trial balance and general ledger datasets are currently available for import from SAP S4 HANA.

  8. If you selected Trial balance, select the Import the last 5 years of TB to import up to five years of trial balance data if it is available in the file you exported.

  9. Select Next.

  10. At the Confirmation stage of the import wizard, review the information and select Import.

To view the imported financial data, go to your engagement's Data page.

Reimport the trial balance

After you complete the import, you can reimport the trial balance data at any point in time by going to the Data page, and selecting Import, then one of the available options:

  • Reimport Trial Balance - Select this method to reimport the data with the original import method that you used. For example, if you previously used Xero to import the trial balance data, the Xero import method displays when you attempt a reimport.

  • Reimport from different source - Select this method to reimport the data with a different import method. For example, if you previously used Xero, but now want to import the trial balance data from a CSV file.

When you reimport data,

  • Account names and balances will be overwritten with the reimported data for accounts that already exist in the engagement

  • Any new accounts in the reimported data that do not already exist in the engagement will be added to the engagement.

  • Accounts that exist in the engagement that are not included in the reimported data will be deleted, unless:

    • The existing account has a balance for a period, balance type or other entity that is not included in the reimported data. For example, if the existing account has a prior year balance but the reimported data only includes data for current year balances, the existing account will not be deleted.

    • The existing account has a corresponding adjustment, issue or annotation.

  • Any adjustments, issues and annotations made prior to reimport will remain after the data is reimported.