Uploading Reported Financial Data

In the upload file, there are several special characters that are used by the system:

• * – Comment
• P – Parameter
• D – Data structure
• 2 – Data rows

In addition, there are the following parameters that are included in the file as well:

• Periodical – import period or YTD data
• Update mode – delete or overwrite
• NSEP – number format
• DOCTY – document type used for this file

The flexible upload file parameters are described in detail as follows:

• Periodical:
  • If you enter x, the data of the file is interpreted as period data. The data of the file is written to the period specified in the file with no additional calculation.
  • If you leave the Periodical field blank, the data of the file is interpreted as cumulative (year-to-date) data. The system subtracts the cumulative data from the previous period and stores the periodic value.
• Update Mode:
  • Enter 1 to delete all: All existing records in a block (consisting of ledger, consolidation chart of accounts, version, fiscal year, period, and consolidation unit) are reset to zero before loading the new data.
  • Enter 2 to overwrite: Only the uploaded records are written. Any existing records that share the same item and all of the same subassignments are overwritten.
• NSEP - Number separator:
  • Enter 1 for number format 1,000.00.
  • Enter 2 for number format 1.000,00.
• DOCTY - Document type: You can use different document types to distinguish source systems.

Note

The order of the columns can be changed by users. You can add other columns to the file such as group currency and amount to the file if needed.

If you use AmountInTransactionCurrency you also have to provide TransactionCurrency. If you use QuantityInBaseUnit you also need to provide BaseUnit. LocalCurrency is derived from the currency assigned to the consolidation unit automatically. Group Currency is derived from the currency assigned to the version.

This note contains the standard template: 2659672 - FAQ About SAP S/4HANA Finance for Group Reporting (On Premise).

Note

The source file for the class does not include annual net income or current year retained earnings. Therefore, the Calculate Net Income task should be run after the import.

In case there’s new data in the source system, the flat file can be imported again. There are two update options in the flat file: delete mode and overwrite mode.

If the second source file represents the correct result for all FS items for CU01 (consolidation unit 01), use Delete mode:

• Cash is increased by 500. The resulting net amount is 120,500.
• AR (accounts receivable) is decreased by 25,000 so the net amount is 0.

If the second source file represents the correct result for FS item 111100 and existing FS item 121100 values should be retained, use Overwrite mode:

• Cash is increased by 500. The resulting net amount is 120,500.
• AR (accounts receivable) is not changed.

To perform a flexible upload run, follow these steps:

1. In the data monitor, choose Data Collection for the Consolidation Group → Right-click and select Update.
2. In the Enter / transfer data screen, choose Import.

To upload reported financial data, the following prerequisites apply:

• Open all periods that are included in the upload file.
• Unblock the Data Entry task for the respective consolidation units.

To make your flexible upload selections, complete the following steps:

1. Select the Upload Method (in the File area, not in the header).
2. Select the file.
3. Select the file format such as ASC (depending on the product release, this may not be an option).
4. Choose Execute.

Note

During the flexible upload, the general selections are inherited from the data monitor and global parameters. The upload method contains the data separator.​​

In the following image:

1. The uploaded amount is from the flat file.
2. The journal entry amount is written to ACDOCU.

The flexible upload log is interactive:

• The search features let you filter the log to a particular consolidation unit or consolidation group.
• Click on the blue hyperlinks for more information to aid the debugging effort if needed.
• Clicking on a hyperlink takes you to the group journal entry in ACDOCU.
  Note

  Reported financial data is booked to posting level 00 along with a document number.
• You can change the display of the log format using the settings option.
• In addition, the numbers next to the consolidation unit / consolidation group represent the number of messages in the log related to that consolidation unit / consolidation group. Messages can be informational, warnings, or errors and are helpful in diagnosing root-cause issues with the data if needed.

Logs can also be exported to Microsoft Excel for analysis.

If the source file doesn’t include annual net income and current year retained earnings, then the calculate net income task should be run from the data monitor.

Flexible uploads write to posting level 00 and the document type specified in the file.

As we proceed through the corporate close process, we'll need to run reports to check the results and other items. Most reporting is performed with the Group Data Analysis app.

With the Group Data Analysis app, you can display different views of consolidated data. You can use a group view based on the group structure that includes consolidation groups and units. Alternatively, you can use a hierarchy view based on hierarchies of profit centers, segments, and consolidation units. By selecting different FS item hierarchies within the app, you can generate consolidated financial statements.

From any measure, you can drill through to the Display Group Journal Entries - With Reporting Logic app to view the posting details at the line item level.

The Group Data Analysis report includes the following options:

1. Defer layout update
2. Bookmark your filter and layout settings
3. Open the filter area
4. Navigate to line items
5. Download to Microsoft Excel
6. Hide the navigation panel
7. Select any dimension in ACDOCU

Now that you've learned some basic reporting features, let's see how a group data analysis report can be used to analyze imported data.

In the following image, the two source records for the 111100 cash FS item: 222,129 for opening balance/transaction type 900 plus -1,800 for variation / transaction type 915 = 220,239 in the ACDOCU table.

To validate imported data:

1. Select the document type used in the source file.
2. Select posting level 00.