Recording Commitments and Actuals

Objectives

After completing this lesson, you will be able to:
  • Explain how budget consumption for commitment and actuals is recorded
  • Explain budget consumption type, budget consumption amount type
  • Explain how the creation and change of a commitment document is recorded
  • Explain how the recording of various actual documents is relevant

Introduction: Budget Consumption

Next, let's see what Sarah has to say about recording commitments and actuals! Select the following video!

In public sector organizations, no business activity, which leads to a future payment can be posted/approved without an available budget. Early (as soon as possible) earmarking of the budget consumption is paramount to plan accordingly. This means that when governments foresee future payments as a result of an operative commitment document, they must reserve their budget. This reservation of the budget needs to be documented through a financial budget consumption document, which is controlled by active availability checking.

This mechanism is referred to in this document as commitment updating.

In certain cases, a commitment document is not available, so the actual document is directly consuming the budget. In both cases (with and without a reference to a predecessor commitment document) this is referred to as actual updating. Commitment and actual postings together form the budget consumption.

PSM-specific commitment and actual information are recorded in the universal journal (table ACDOCA) by adding the respective PSM account assignments or master data and budgetary attributes to the universal journal entries during document posting.

In the case of commitment postings (such as purchase requisitions, purchase orders, earmarked funds), the ledger 0E is updated, whilst the ledger 0L is used for actual documents. Further ledgers are possible and described in a later chapter.

The main place where budgetary attributes are stored is in the general ledger account. In particular, expense and revenue accounts (with a few exceptions like assets and down payment accounts) contain the main attributes, which control budget consumption. During posting of a commitment or actual, the general ledger account is used to derive the budgetary attributes and store them in the respective ledger of universal journal.

To understand the key concepts of budgetary attributes, see the following chapter and also refer to the earlier master data chapter, which also describes the budget account concept.

Key Concepts of Recording Commitments and Actuals

Attributes

In addition to the recording of the budgetary account assignment elements (fund, budget period, grant, cost center, WBS (optional) and functional area), the following attributes are important for recording of the commitment and actuals, checking the budget, performing availability control, and other specific processes such as down payments and year end.

Most of the attributes are stored on the general ledger account/budget account, derived during posting (in some cases based on specific processes), recorded in the universal journal (ACDOCA and ACDOCP) and subsequently used for reporting. Those attributes are as follows:

  • Budget Consumption Type
  • Budget Relevancy and Expense/Revenue indicator
  • Budget Consumption Amount Type
  • Budget Consumption Date, Budget Consumption Period, and Budget Consumption Year

These attributes are further described in this chapter and where applicable are described in additional chapters referenced.

The following example shows how a document can be used for both budgetary reporting as well as financial reporting.

Reporting

The following figure illustrates that budgetary reporting and financial reporting are possible based on the same document recorded in the universal journal.

UI example of the Manage Journal Entries page accompanied by they budgetary and financial reporting possibilities according to the preceding and following text.

Key Concept: Budget Consumption Type

Budget consumption types (BCT) are used to interpret the financial transaction from a budgetary accounting perspective. They can be divided into commitment budget consumption types (such as purchase requisitions and purchase orders, which are both updated in the ledger 0E) and actual financial transactions (such as actual expenses or revenues, which are updated in the ledger 0L).

Only some BCTs are relevant for budgetary control purposes, whilst others are used to describe the status of a journal entry in the financial document chain or the internal or external nature of a journal entry transfer.

The process (such as purchase requisition, purchase order) determines the BCT for commitment type transactions. The BCT is retrieved from the general ledger account or from additional special processes (such as down payment, asset acquisition, transfer posting) for actual transactions.

The budget consumption type for an account is predelivered with the standard chart of account (YCOA) and cannot be changed by the user. Likewise, the budget consumption type assigned to a process is not changeable.

Budget consumption types are important for reporting. In general, (with some exceptions) only BCT’s classified as budgetary (see next table) are relevant for budgetary reporting. Additionally, see the Unit Exploring the Reporting Options (coming soon in a next update) for additional details.

Predelivered Budget Consumption Types (BCT)

BCTDescriptionClassification

Ledger

Commitment 0E

Actual 0L

Determined by

Influenced by Additional Logic

01UnassignedNot budgetary and none of the other journal entry status classifications apply.0L ActualG/L account 
50Purchase RequisitionsBudgetary0E CommitmentProcess 
51Purchase OrdersBudgetary0E CommitmentProcess 
54PayablesJournal entry status ‘invoice’0L ActualG/L account 
55ReceivablesJournal entry status ‘invoice’0L ActualG/L account 
56Zero Balance PostingsDue to/due from others0L ActualG/L accountBalancing in document split functionality- see (Fund Accounting Course - IPSC3)
57PaymentsJournal entry status 'cash’0L ActualG/L account 
61Down PaymentsBudgetary0E Commitment

0L Actual

G/L accountReference to purchase order, default assignment for down payments without reference to a purchase order
65Funds CommitmentBudgetary0E CommitmentProcess 
66FI Transfer PostingsBudgetary0L ActualProcessTransfer between two or more 99 BCTs within an FI or CO journal entry
81Funds ReservationBudgetary0E CommitmentProcess 
82Funds PrecommitmentBudgetary0E CommitmentProcess 
95CO PostingsBudgetary0L ActualG/L accountTransfer between two or more 95 BCTs that are assigned to secondary costs in CO – see Unit 5, Understanding Integrated Components.
99Expenses/RevenuesBudgetary0L ActualG/L accountSpecial Rules for fixed asset transactions – see Unit 5, Lesson 8, Understanding the Integration with Asset Accounting

Key Concept: Budget Relevancy and Expense/Revenue Setting

The Budget-Relevant indicator is an important setting in the general ledger/budget account and is updated as part of a journal entry in the Universal Journal (ACDOCA). It can be used to control whether and how a budget is consumed for various transactions and types of postings. This budget relevance setting can be used in several different areas, but it is interpreted differently in each case:

Budget Relevance for Commitment and Actual Expenses (ACDOCA)
For commitment and actual expenditure document lines, the budget relevant indicator determines whether a document line is consuming budget. Accounts classified in the general ledger as expense document lines are included in the availability control (AVC) and produce a decrease in budget.
Budget Relevance for Actual Revenues (ACDOCA)
Accounts classified in the general ledger as Revenue are not included in the availability control and do not increase or decrease the amount consumed. The delivered default setting for these revenue type accounts is Not Budget-Relevant. The budget-relevant indicator can however also be set for revenue accounts, which allows a distinction to be made in reporting.
Setting the Budget-Relevant Indicator
The budget-relevant indicator can be set in the G/L account master data in the section Public Sector Management Data.

You can overrule the G/L account settings for specific CO processes and remove budget-relevant indicator. In this case, the respective overhead postings are excluded from the availability control and any budget consumption.

You define the budget relevance of the CO processes in the configuration activity, Define Budget Relevance of CO Processes. In addition, see the Unit Understanding the Integration with Overhead Accounting and Project Management.

Key Concept: Budget Consumption Amount Type

The recording of a budget consumption amount type is important for documents in which the amounts can still be changed either by making direct changes or in subsequent documents and adjustments.

Budget consumption amount types are predelivered by SAP and recorded in the document. The following budget consumption amount types exist and are described in detail in the commitment section of this document and also in Unit Describing Year-End Processing.

Pre-Delivered Budget Consumption Amount Types

Amount TypeDescriptionUsageSee also
ORIGOriginal AmountUsed when a document is created.Recording of Commitments
CHINChange - IncreaseUsed when the amount for a commitment document is increased.Recording of Commitments
CHDEChange - DecreaseUsed when the amount for a commitment document is decreased.Recording of Commitments
CHAAAccount Assignment ChangeUsed when the account assignment for a commitment document is changed.Recording of Commitments
DELEDeletionUsed when the amount for a commitment document is deleted.Recording of Commitments
REDUReductionUsed when a subsequent document is posted, which references and reduces the original document.Recording of Commitments
REDPReduction from Down PaymentUsed when a down payment is posted, which references and reduces a commitment document.Recording of Commitments
DWADDownward AdjustmentUsed for document chains with a decrease of the expenditure amount that references a document with an expired budget period. Posting with this budget consumption amount type involves the expired budget period.Unit 6: "Identifying Upward/Downward Adjustments"
UWADUpward AdjustmentUsed for document chains with an increase of the expenditure amount that references a document with an expired budget period. Posting with this budget consumption amount type involves the new (unexpired) budget period.Unit 6: "Identifying Upward/Downward Adjustments"
UWOFUpward Adjustment OffsetUsed for document chains with an increase of the expenditure amount that references a document with an expired budget period. Posting with this budget consumption amount type involves the expired budget period.Unit 6: "Identifying Upward/Downward Adjustments"
BBPVTransfer - Previous Budget Period

Used to transfer open commitments from a previous budget period to the next budget period.

The transfer posting consists of a pair of line items with a sender item that has this amount type.

See Unit 6: "Describing Commitment Adjustments"
BPNXTransfer - New Budget Period

Used to transfer open commitments from a previous budget period to the next budget period.

The transfer posting consists of a pair of line items with a receiver item that has this amount type.

Unit 6: "Describing Commitment Adjustments"
FYPVTransfer - Previous Fiscal Year

Used to transfer open commitments from a previous fiscal year to the next fiscal year.

The transfer posting consists of a pair of line items with a sender item that has this amount type.

Unit 6: "Identifying Upward/Downward Adjustments"
FYNXTransfer - New Fiscal Year

Used to transfer open commitments from a previous fiscal year to the next fiscal year.

The transfer posting consists of a pair of line items with a receiver item that has this amount type.

Unit 6: "Describing Commitment Adjustments"

Recording of Commitments

Within a document chain, commitment documents are documents that are posted before a financial document. The generation of commitment documents is called commitment updating.

Commitment documents are created from the following:

  • Earmarked funds (reservations, precommitments, commitments, forecast of revenues)
  • Purchase requisitions
  • Purchase orders
  • Travel requests

Unlike financial documents, commitment documents can be changed and reduced by a successor document (either another commitment document or an FI document). The changes of commitments can be value increases or decreases, account assignment changes, setting a commitment to completion, or carrying a commitment forward to the next fiscal year. Different budget consumption amount types are used in order to classify the type of changes.

Like financial documents, commitments do reserve budget using active availability checking. They are updated in the universal ledger ACDOCA using ledger 0E.

At the end of the year open commitments (not completely reduced) can be carried forward. (see Unit 6, Lesson 2, Describing Commitment Adjustments).

Note

Every budget consumption line item in ACDOCA has an offset line where the flag ACDOCA-COMMITMENT is space. These lines are ignored for budget consumptions views (for example: reporting, availability control, and so on).

Document Chains

Commitment documents are usually followed by other commitment documents or actual documents. From a business perspective, a successor is usually more contractual than its predecessor. A document chain describes linked documents, for example:

Purchase Requisition – Purchase Order – Goods Receipt – Invoice Receipt – Payment

The linkage of the documents is usually created on a line item (not document header) level. It is important to understand that the relationship of commitment document and successor document is N:N. However, each commitment document line item can be reduced by multiple successor documents lines, but each successor document line refers to exactly one predecessor line item.

The account assignments can be different between commitment document and its successor. The account assignments are usually copied into the successor document, but they can then, depending on field status configuration, be changed.

The successor document does not need to consume the complete amount of its predecessor document. In this case, part of the predecessor document will remain open. However, if the successor document knows that this is a partial reduction, but there will be no more further successor documents, then the completion indicator can be used in order to reduce the complete open amount.

Flowchart representing possible document chains for commitment documents divided into four sections: Reservations, pre-encumbrances, encumbrances and actuals.

Budget Consumption Date During Commitment Updating

In general, each update of the budget consumption shall be posted with today’s posting date (or the posting date of the last newly created document) or with the due date (date of expected payment) as the budget consumption date.

Examples of this are the following:

  • For the creation of a commitment document, the posting date or due date of commitment document will be the budget consumption date.
  • For an invoice document (or any other actual document) reducing a commitment document, the posting date or due date of the actual document shall be the budget consumption date.
  • For a change of commitment documents, the current CPU date (or due date) is the budget consumption date.

In exceptional cases, it is possible to influence this date for all commitment documents, for an individual user or for an individual time range. The app to influence this is called Manage Users with Flexible Update Date (see the following figures).

In general, it is not possible for a document line to use a budget consumption date which is younger than existing persisted budget consumption dates (no backdating of updates).

UI example of the manage user with flexible update date app with the budget consumption date highlighted.

Examples: Recording of Commitments

Example 1 - Creation of Commitment, Changes and Reduction

Step 1
Creation of a purchase requisition PR1 with the purchase requisition date 01/01/2022; amount $100 against fund F1.
Step 2
Purchase requisition PR1 is being increased to $115 on 01/15/2022.
Step 3
The fund of purchase requisition PR1 is changed from F1 to F2 on 01/25/2022.
Step 4
Purchase requisition is transferred into a purchase order with a purchase order date of 02/10/2022.

Example 1

StepReference NumberBudget Consumption TypeFundBudget Consumption DateAmount TypeAmount
1PR1Purch. Requisition​F101/01/2022Original Amount+100
2​PR1Purch. Requisition​F101/15/2022​Increase+15
3PR1​Purch. Requisition​F1​01/25/2022Account Assignment Change-115
3PR1​Purch. Requisition​F201/25/2022​Account Assignment Change+115
4PR1​Purch. Requisition​F202/10/2022​Reduction-115
4PO1​Purch. OrderF202/10/2022Original Amount+115

Example 2 - Creation of a Commitment, Down Payment, Invoice and Down Payment Clearing

Step 1
Creation of a commitment (earmarked fund) CM1 with posting date 01/01/2022; amount $100 against fund F1.
Step 2
Down payment DP1 against commitment CM1; $10 on 02/20/2022.
Step 3
Invoice INV1 of $90 against CM1 setting the completion indicator on 03/15/2022.
Step 4
Down payment clearing DPC1 is clearing DP1 on 03/20/2022 (automatically referencing CM1).

Example 2

StepReference NumberBudget Consumption TypeFundBudget Consumption DateAmount TypeAmount
1CM1CommitmentF101/01/2022Original Amount+100
2CM1​CommitmentF102/10/2022​Reduction from Down Payments-10
2DP1​Down Payment​F102/10/2022​Original Amount+10
3CM1​Commitment​F103/15/2022​Reduction-100
3INV1ExpenseF103/15/2022​Original Amount+90
4CM1​Commitment​F103/20/2022​Reduction from Down Payments+10
4DPC1​Down Payment​F103/20/2022​Original Amount-10

Specific Considerations for Certain Types of Commitments

  • For certain types of commitments, specific behavior is described in Unit 5, Understanding Integrated Components.
  • Currently SAP S/4HANA Cloud does not provide the ability to forecast revenue, for example, from sales orders.

Usage of Due Dates

It is possible to update on due rather than posting dates based on configuration. For example, it might be that a funds commitment with a posting date in this year and a due date next year, shall immediately consume only next years budget. In your role as a configuration expert (business role SAP_BR_BPC_EXPERT), you can activate the due date updating for budget consumption in the configuration activity "Define Update Date for Budget Consumption" for selected commitment documents. In case the due date updating is active the following applies:

  • If due date is empty in the document, the posting date acts as budget consumption date
  • for commitment changes before the budget consumption/due date, the existing budget consumption date is used for the updates
  • -for changes after the budget consumption date, the logic applies for posting dates applies (CPU date or update date act as budget consumption date)

Recording of Actuals

Actual documents are in many cases financial documents referencing commitment documents but can also be recorded without reference.

Important for public sector organizations are the recording of expenses (with or without reference to a predecessor document) or revenue. The subsequent collections or payments are less important from a budgetary reporting standpoint and most of the budget consumption reports are based on line types with BCT classified as budgetary (see earlier table with budget consumption types).

The payment and collection of invoices are only of relevance for budgetary reporting if they contain additional expense/revenue adjustment lines for cash discounts or a foreign currency exchange gain/loss. These adjustments are referred to as online post-processing, which is a function of FI document splitting.

Note

Actual documents cannot be changed and hence budget consumption amount types are not of specific importance there unless used in year-end related processes, see Unit 6: "Upward/Downward Adjustments".

The following example demonstrates the basic concept of actual updating.

Example Recording of Actuals

Example 1: Actual Documents Invoice and Payment with Cash Discount

Step 1
Creation of a vendor invoice AP_INV1 without reference to a predecessor document in the amount $100 for fund F1.
Step 2
Payment of the vendor invoice using a 3% cash discount in the amount of $3.

From a budgetary reporting perspective, only lines with budget consumption type Expense/Revenue (99) are being reported here (blue lines) and the budget consumption is $97 (100-3).

Note that from a budgetary perspective, the original budget account Expense 1 is updated, while from a financial perspective, the general ledger account Cash Discount Taken is used.

Actual Example 1

StepDocument #Line ItemDR/CR AccountBudget Consumption TypeBudget AccountBudget RelevantFundAmount
1AP_INV11Debit Expense 1Expense/Revenue (99)Expense 1xF1+100
  2Credit Vendor/LiabilityPayable (54)  F1-100
2PAY11Debit Vendor/LiabilityPayable (54)  F1+100
  2Credit Cash/BankPayment (57)  F1- 97
  3Credit Discount TakenExpense/Revenue (99)Expense 1xF1- 3

Actual Example 2: Journal Entry Transfer

It might be necessary to do FI transfer postings to correct a posting which was mistakenly posted to fund F1 instead of fund F2 (or any other account assignments like cost center, WBS, and so on). Although the expense account used is typically budget consumption type Expense/Revenue (99), this leads to a budget consumption type FI Transfer Posting (66).

Step 1
Journal entry JE1 is recorded and fund F2 is debited, fund F1 is credited with $60.

Note

FI document splitting is used to balance such a document (in this example on the fund level) and this leads to additional lines in the document which are recorded as zero balance clearing lines from a general ledger perspective. From a budgetary update these lines are classified as budget consumption type Zero Balance Posting (56), and they are not relevant for budgetary reporting. Only the transfer lines (BCT 66) are relevant.

Actual Example 2

StepDocument #Line ItemDR/CR AccountBudget Consumption TypeBudget AccountBudget RelevantFundAmount
1JE11Debit Expense 1Transfer (66)Expense 1xF2+60
  2Credit Expense 1Transfer (66)Expense 1xF1-60
  3Zero Balance ClearingZero Balance Posting (56)  F1+60
  4Zero Balance ClearingZero Balance Posting (56)  F2-60

Other Documents Relevant for Recording of Actuals

Other typical actual documents which can occur and which are relevant for budgetary reporting and budget consumption are listed below.

Note that only the budget consumption types 'Expense/Revenue' (99) and 'Down Payment' (61) are used for budgetary reporting/budget consumption. The entries are highlighted in bold.

  • Goods receipts with reference to a purchase order:

    Debit 'Expense' (BCT 99 Expense/Revenue) Credit 'GR/IR' (BCT 54 Payables)

  • Invoice receipts (accounts payable) with reference to an earmarked fund or purchase order:

    Debit 'Expense' (BCT 99 Expense/Revenue) Credit 'AP Vendor/Liability' (BCT 54 Payables)

  • Accounts receivable invoices without a reference:

    Debit 'Customer/Receivable' (BCT 55 Receivable) Credit 'Revenue' (BCT 99 Expense/Revenue)

  • Accounts receivable invoices with reference to a sales order:

    Debit 'Customer/Receivable' (BCT 55 Receivable) Credit'Revenue' (BCT 99 Expense/Revenue)

  • Down payments (AP) without a reference:

    Debit 'Vendor/Special GL (BCT 61 Down Payment) Credit 'Bank/Cash' (BCT 57 Payment)

  • Down payments (AR) without a reference:

    Debit 'Bank/Cash' (BCT 57 Payment) Credit 'Customer/'Special GL' (BCT 61 Down Payment)

  • Down payments (AP) with reference to a purchase order or earmarked fund:

    Debit 'Vendor/Special GL (BCT 61 Down Payment) Credit 'Bank/Cash' (BCT 57 Payment)

  • Integrated documents with expenses/revenues from fixed assets, payroll, contract and lease management, treasury and risk management, travel, plant maintenance, overhead accounting and project management. See chapter see Unit 5: "Integrated Components" for integrated component to learn some more specifics about these documents.

The concept of updating the universal journal for both financial reporting and budgetary reporting (with additional PSM attributes described) allows for a simpler reporting and reconciliation.

Log in to track your progress & complete quizzes