Managing Fund Accounting for SAP Treasury and Risk Management

Objectives

After completing this lesson, you will be able to:
  • Explain Fund Accounting for SAP Treasury and Risk Management
  • Explain how modified and full accrual can be used in SAP Treasury and Risk Management in support of Fund Accounting

Fund Accounting in SAP Treasury and Risk Management

Next, Sarah, and Daniel review how to manage fund accounting for SAP treasury and risk management. Select the following video to learn more!

Modified and Full Accrual in SAP Treasury and Risk Management for Debt Instruments

Modified Accrual:

  • Long-term debt issued is shown as "Other Financing Sources", with premium or discount reported as current financial resources.
  • Long-term debt principal repayment is reported as a debt service expense when paid.

Full Accrual:

  • Long-term liabilities are included on the statement of net position (balance sheet), with premium or discount on long-term debt deferred and amortized over the life of the debt issuance.
  • Payments of long-term liabilities reduce the balances reported on the balance sheet.

Fund Accounting in Treasury: Financial Transactions for Debt

In SAP Treasury and Risk Management, a securities transaction (transaction TS01) is created to define the lifecycle of a debt. Based on this initial transaction, subsequent postings to accounting can be created. The lifecycle includes, for example, initial debt issuance, interest calculations, and accruals and amortization. Subsequently, the 'post flows' transaction (TBB1) posts to G/L.

Account assignments, such as Fund, Grant, Profit Center, Cost Center, WBS, and Functional Area, are typically required fields in the securities transaction (based on the configuration of differentiation criteria). It is possible to enter the account assignments manually or derive them from the associated cost object, such as cost center or WBS element.

It is also possible to split a securities transaction in different funds and other account assignments.

All subsequent postings in treasury use account assignments from this securities transaction.

Note

For general information about Treasury integration to Public Sector Management, refer to IPSC1 and the SAP Treasury and Risk Management section in the unit on integrated components.

Valuation Areas

In SAP Treasury and Risk Management, valuation areas are defined and mapped to accounting principles (GASB modified accrual and full accrual accounting or in some cases US GAAP).

The valuation areas and mapping to respective accounting principles are delivered by SAP and the selection of the accounting principle is done during the scoping phase. To understand the options of how the accounting principle(s) can be mapped to ledgers, refer to the lesson on modified and full accrual accounting principles in unit 1.

Valuation Areas in SAP Treasury and Risk Management

Valuation AreaAccounting Principle
USM (US GASB Modified Accrual)UGSM (US GASB Modified Accrual)
USF (US GASB Full Accrual)UGSF (US GASB Full Accrual)
US0 (US GAAP)USAP (US GAAP)

Note

The focus of this section is on long-term debt for modified accrual. Short-term debt and investments can also be recorded in SAP Treasury and Risk Management but do not require special handling. Some organizations might not need GASB full and modified accrual, but US GAAP (for example, US0) instead. Non-US countries can use their local GAAP, which is represented in a different valuation area (for example, CA0 for local GAAP in Canada).

Specific G/L Accounts and Postings for Treasury Transactions

Additional G/L accounts are provided for postings that are specific to modified accrual. Full accrual follows the standard GAAP accounting principle posting and the accounts are not listed here.

Note

It is possible to change the G/L account numbers at the beginning of an implementation. Refer to section on the Public Sector Chart of Accounts.

While most of the postings are initiated by SAP Treasury and Risk Management transactions, some manual ledger specific FI postings (transaction FB50L) have to be recorded after the initial debt issuance and repayment. This can also be used to move the funds from funds such as Debt Service Funds to Capital Project Funds and similar.

Here is an example of how SAP Treasury and Risk Management configuration has been setup for specific G/L account postings in valuation area for modified accrual (USM). This is done with the configuration activity Define Account Determination for SAP Treasury and Risk Management. Refer to the Treasury training material for more information on how to configure the account determination.

The following configuration shows that accounts can be maintained independent of the valuation area (valuation areas blank), but different accounts can be used specifically for a valuation area (valuation area USM for modified accrual).

UI example Define Account Determination page with open dialog structure and Assignment of G/L Accounts to Account symbols.

US PSM-Specific G/L Accounts for Debt Issuance and Debt Repayment

G/L Account NameWhere is it used?
22549100 Technical Clearing Account (SAP Treasury and Risk Management) - long-term debtUGSM:

SAP Treasury and Risk Management posts to Technical Clearing Account (TRM)

  • Debt issuance: Use ledger specific posting in FI to transfer to Other Financing Sources (CR)
  • Debt repayment: Use ledger specific posting to transfer to Bond Principal Expenses (DR)
71000300 - Other Financing Sources (Public Sector Management)
71102000 - Bond Principal Expenses (Public Sector Management)

US PSM-Specific G/L Accounts for Debt Issuance Costs in Supplier Invoice

G/L Account NameWhere is it used?
22549200 - Debt Issuance Cost Clearing (Public Sector Management)

UGSM, UGSF:

Clearing account used in Supplier Invoice to post debt issuance costs for full and modified accrual. Ledger specific postings can be done to reclassify.

71000310 - Debt Issuance Cost (Public Sector Management)

UGSM:

Use ledger-specific posting.

Debt Issuance Cost (DR)

Debt Issuance Cost Clearing (CR)

29141000 - Bond Payable, Long term

UGSF:

Use ledger-specific posting. Use ledger-specific posting. BondPayable, Long Term (DR) Cost of Issuance Clearing (CR)

US PSM-Specific G/L Accounts for Interest Accrual or other Fund Transfers

G/L Account NameWhere is it used?
71000320 – Transfer In (Public Sector Management)

UGSM:

Accounts can be used after SAP Treasury and Risk Management interest accrual posting.

Ledger-specific transfer posting between, for example, General Fund and Debt Service Fund

71000330 – Transfer Out (Public Sector Management)

Transfers are accounting transactions between funds, which are neither revenues nor expenditures. Therefore, transfers are in essence a movement of fund balance from one fund to another. Transfers have a similar effect as revenues (transfers in) or expenses (transfers out), but from an institutional perspective, transfers do not represent "real" revenues or expenses, and must net to zero.

The following chart shows the transaction and full and modified accrual accounting entries for Debt Issuance:

UI example of Debt Posting with Modified and Full Accrual Accounting: Debt Issuance.

Note

For the sake of simplicity, the use of the Treasury Fund (optional for US organizations) is not shown in the figure, Debt Posting with Modified, and Full Accrual Accounting: Debt Issuance.

Note

Zero balance clearing account is automatically posted because the document needs to balance by fund.

Subsequently, Dept Repayment also has specific accounting entries for full and modified accrual.

UI example of Debt Posting with Modified and Full Accrual Accounting: Bond Principal Repayment

Treasury Posting Journal App

The Treasury Posting Journal app shows a list of the accounting documents that have been created for the various updates that can occur and for each valuation area.

In the example in the figure, Posting Journal Modified Accrual (USM) and Full Accrual (USF) valuation areas, we use valuation area for modified accrual (USM) and full accrual (USF). Different accounts can be used for posting in these two areas as show in the example provided for bond issuance.

The debt in this example is also split into two funds, which is a common practice for US. In a modified accrual environment (Valuation Area USM - in the current configuration assigned to ledger 0L), the debt related to bond issuance is used to finance, for example, capital projects and is made to 'Technical Clearing Account (TRM) - long-term debt (PSM). This differs from full accrual (Valuation Area USF - assigned to ledger 2L), where we post to 'Bond Payable Long Term' posting.

The ledger assignment to 0L and 2L is one possible option and based on the ledger to accounting principle assignment explained in the beginning of this course.

UI example of a Posting Journal page with highlighted lines USF and USM.

Log in to track your progress & complete quizzes