Integrating PSM with Contract Accounting

Objectives

After completing this lesson, you will be able to:
  • Understand the integration contract accounting (FI-CA) with Budgetary Accounting
  • Understand the specific handling of PSM master data and attributes within this integration
  • Define the derivation of PSM account assignments for the data transfer of FI-CA postings to General Ledger

SAP Contract Accounting - Cloud

Sarah and Daniel now discuss integrating PSM with contract accounting.

Contract Accounting (FI-CA) is an accounting subledger designed and built for high-volume business. The integration of Contract Accounting with Public Sector Management (PSM) enables public sector organizations to receive and manage large numbers of documents and to upload these postings (total records) to the general ledger (GL). Typical use cases are tax and fee collections.

While the calculation of taxes / fees are done outside FI-CA, the focus here is on automated revenue collection processes. Typical functions such as posting, payment processing, dunning, and interest calculation for multiple business partners are supported.

PSM Data Handling During the Integration

Documents within contract accounting are updated without PSM-specific data. PSM account assignments like fund, functional area and grant can neither be entered nor displayed in FI-CA documents.

Basic derivation and validations involving PSM account assignments are performed during postings within contract accounting to ensure that the data transferred to the general ledger (FI-GL) will include the required PSM-specific data.

UI example of a display message displaying an error stating Posting with account 41005100 requires an assigned functional area.

PSM Derivation and Validation

PSM Data Handling During the Integration

The complete PSM derivation and validation is performed during the data transfer from FI-CA (totals table DFKKSUM) to the general ledger (table ACDOCA) where PSM-specific account assignments and attributes are also added to the related journal entries.

Infographic depicting PSM data for two business partner positions BP1 and BP2 and their corresponding G/L positions feeding into a total table DFKKSUM which then feeds via a PSM derivation into a general ledger (FI-GL) universal journal ACDOCA.

Derivation of PSM Account Assignments and Attributes

As is also the case for other financial transactions like customer invoices in accounts receivable (FI-AR), lines transferred from contract accounting are classified using the G/L account (budget account) regarding their relevance for Public Sector Management. For details on the classification see Unit 4, Lesson 1, Recording Commitments and Actuals.

In non-contract accounting financial transactions, lines with the budget consumption types 54 (liabilities), 55 (receivables), 57 (payments) and 01 (not relevant) typically receive the balancing PSM account assignments (fund, grant, cash origin account -RE_ACCOUNT) from general ledger document splitting. Since document splitting is not executed for documents transferred from contract accounting, these PSM account assignments need to be derived using a GL substitution rule. To do this, a contract accounting-specific business context is provided.

The contract accounting-specific business context Public Sector - FICA is available using the BPC EXPERT role in the Manage Substitution and Validation Rules app (F4406).

Substitution Rule with Business Context, Public Sector-FI-CA

Take note that if the treasury fund is active, lines with the budget consumption types 57 (payments) are automatically provided with the values defined as the constants (0CASH) for the fund, grant, and cash origin account.

UI example of a Manage Substitution and Validation Rules page with the General Information table selected displaying Precondition and Substitution fields.

Cash origin account and treasury fund / pool cash are functions specific to Fund Accounting. For more details, see the related training course.

The complete standard PSM derivation rules are executed for lines with budget consumption type 99 (revenue / expenditure) - for example, derivation of PSM account assignments from the cost center master data and derivation of the budget period from the fund and posting date. For details on account assignment derivation, see Unit 2, Lesson 2, Explaining Account Assignment Derivation.

Therefore, for lines with budget consumption type 99 you can decide, if you want to derive fund, grant, and cash origin account from a contract accounting-specific substitution rule or using different sources.

To avoid or limit the creation of zero-balance clearing lines, SAP recommends keeping the number of balancing entities (funds, grants, cash origin account, and segments) used for the FI-CA integration to a minimum.

Define CO Accounting Key

Lines with budget consumption type 99 (revenues / expenditures) require, besides the balancing entities and budget period, a cost center and functional area. While the cost center can directly be maintained in the FI-CA document, the functional area needs to be derived. This is typically done using the cost center master.

To ensure the existence of a cost center (and therefore the derivation of the functional area) in the respective FI-CA lines, you have the option to define and assign CO account assignment keys with cost centers in the configuration of contract accounting.

UI example of a Define CO Account Assignment Keys: Change page with a populated Cost Center field.
UI example of a Maintain Account Assignment Data Relevant to Transactions: Overview page with a populated CO Acct Assignment field.

The following table provides an overview of the determination of account assignments:

Determination of PSM Account Assignments During Transfer to General Ledger

       
Expense, Revenue (99)

Required, 1 to 1 from G/L account

Required, Derived

Required,

From cost center

Required, Derived (from fund + posting date)

Required, From FI-CAC

Required, Derived
Unassigned (01)Not requiredRequired, DerivedNot requiredNot requiredNot requiredRequired, Derived
Payable, Receivables (54/55)Not requiredRequired, DerivedNot requiredNot requiredNot requiredRequired, Derived
Payments (57)Not requiredRequired, Derived or Pooled cash constantsNot requiredNot requiredNot requiredRequired, Derived or Pooled cash constants
Zero Balancing (56) (done by FI balancing)Not requiredRequired, Derived-BalancingNot requiredNot requiredNot requiredRequired, Derived-Balancing

Derived in the case means using a substitution rule with Business Context Public Sector - FICA.

Reconciliation Key

Example to Illustrate the Integration

In the following example, two receivables (one with 100 USD, one with 200 USD) are posted within contract accounting using the same reconciliation key. This is done using the role APR_ACCOUNTANT_FICA and the Post document app (FPE1).

UI example of two Display Document Overview pages sharing the same reconciliation key.

Reconciliation Key

These FI-CA documents include within the GL item (revenue) a cost center but no PSM account assignments. The cost center is the same for both documents.

UI example of a Display Document: G/L Item page with a populated Cost Center field.

Reconciliation Key

The reconciliation key including both documents is closed and transferred to General Ledger. This is done using the RECONC_SPEC_APR_FICA role and the following apps: Delete and Close Reconciliation Key (FPG4) and Transfer Total Records to G/L (FPG1).

UI example of a Delete and Close Reconciliation Key page and a Transfer of FI-CA Totals Records to General Ledger page sharing the same reconciliation key.

Transfer Result to the G/L Document

Transfer Result to the G/L Document

You can directly navigate from the transfer result to the G/L document.

UI example of a List of Documents in Accounting window with an accounting document selected.

Transfer Result to the G/L Document

The resulting journal entry includes the complete PSM information (account assignments and attributes). The balancing entities fund, grant and cash origin account are derived for all lines using a substitution rule (business context Public Sector-FI-CA).

Budget period is derived from fund and posting date.

Functional area is derived from the cost center master.

UI example of a Display Document General Ledger View page with several account assignments under the Ledger OL.

Log in to track your progress & complete quizzes