Maintaining Treasury and Payroll Agency Fund for US and Local (Optional)

Objectives

After completing this lesson, you will be able to:
  • Discover receipts and payments using Treasury Fund
  • Discover equity in pooled cash
  • Discover payroll, third-party remittances, and employee payments posting using Payroll Agency Fund

Treasury Fund

Sarah and Daniel begin by discussing how to maintain treasury and payroll agency funds. Select the following video to get started!

It is common practice in public sector organizations to pool the cash of different funds into one fund called a Treasurer's or Treasury Fund. Cash relevant transactions, such as cash receipts, payments, and investments are transacted in the Treasury Fund. Using the equity in the pooled cash account (zero balance clearing account) each fund’s equity in the pool is identified. The Treasury Fund has a negative equity in the pool and an equivalent positive balance in the bank.

This Practice Provides Several Advantages:

  • There is no need to maintain separate bank accounts for each fund. Instead, bank balances are always maintained in the Treasury Fund. The consolidation of each fund’s cash leads to better returns on short-term investments.
  • Earned interest is distributed to each fund based on its average daily balance in the equity in pooled cash account.
  • The rates that can be paid on a single large bank account are better than the rates that can be paid on a number of smaller accounts.
  • Interfund transactions reduce or increase the equity in pooled cash immediately after recording the transaction. Further availability of partner funds in the equity in pooled cash account(s) facilitates accounting for any due to and due from transactions between funds.

Equity in Pooled Cash

Infographic of equity pooled cash moving into funds and into a bank balance.

When the Treasury Fund is enabled and respective funds balances are established, each participating fund has its equity in the pooled cash. Treasury Fund has a negative equity in the pool for the equivalent positive balance at the bank.

Infographic of equity pooled cash moving into funds and into a bank balance.

When the Library Fund makes a payment of $50 to a supplier, payment is accounted in the Treasury Fund in the bank account and the Library Fund’s equity in the pooled cash is reduced. 

Equity in Pooled Cash Using Treasury Fund

DR/CRAccountAmountFund*Partner Fund
DRSupplier Account (A/P)$50.00Library Fund-
CRBank Account$50.00Treasury Fund-
DREquity in Pooled Cash$50.00Treasury FundLibrary Fund
CREquity in Pooled Cash$50.00Library FundTreasury Fund

*Example shown for fund: Treasury and payroll agency are applicable for all document splitting characteristics, for example, grant and segment.

Accounting entry for supplier payment posting.

Note

Bank (cash relevant) account is posted on the Treasury Fund.

Constants from document splitting are used to post to the treasury fund. There are options for three different zero balance clearing accounts (equity in pooled cash) available, one for each of the following:

  • Cash relevant transactions, such as cash receipt and payments
  • Financial transactions
  • Postings from controlling transactions

In this way, you have the option to differentiate real cash transactions, such as cash receipts and payments, from cash equivalent transactions, such as interfund charges.

Infographic of equity pooled cash moving into funds and into a bank balance.

The general fund receives a payment of $100 from a customer. Payment is accounted in the Treasury Fund in the bank account and equity in the pooled cash is increased for the general fund.

Accounting Entry for Customer Payment Posting: Ledger View

DR/CRAccountAmountFund*Partner Fund
DRBank Account$100.00Treasury Fund-
CRCustomer Account (A/R)$100.00General Fund-
DREquity in Pooled Cash$100.00General FundTreasury Fund
CREquity in Pooled Cash$100.00Treasury FundGeneral Fund
Infographic of equity pooled cash moving into funds and into a bank balance.

When the Internal Service Fund charges the General Fund $25, equity in the pooled fund for the internal service fund increases and the general fund decreases by $25.

Accounting Entry for Interfund Charges Posting: Ledger View

DR/CRAccountAmountFund*Partner Fund
DRPrinting Services$25.00General Fund 
CRPrinting Services$25.00Internal Service Fund 
DREquity in Pooled Cash*$25.00Internal Service FundGeneral Fund
CREquity in Pooled Cash*$25.00General FundInternal Service Fund

*A separate zero balance clearing account (equity in pooled cash) is maintained for FI transactions that are not cash receipts and for CO transactions that are not cash payments. This helps identify real cash from cash equivalent transactions.

Payroll Agency Fund

If it is not necessary to manage payroll payables in the actual fund where expenditures are incurred. You have an option to use the payroll agency fund. The payroll agency fund is a clearing fund in which all balances posted from the SAP SuccessFactors Employee Central Payroll are accounted in the agency fund. It serves as a temporary bearer of payroll liabilities.

Payroll and benefit expenses are posted to the actual fund where the expenses are incurred. All payables are posted using the payroll agency fund. Equity in pooled cash (zero balance clearing) is generated between expending funds and the payroll agency funds.

The content of this course is only applicable for postings such as payroll, third-party remittances, and payment postings from SAP SuccessFactors Employee Central Payroll.

Details

  • Payroll agency activation flag is only considered for postings from SAP SuccessFactors Employee Central Payroll system. If you have payroll postings from any other interfaces, manual postings or upload via journal entry, the payroll agency fund would not be enabled (though activated) automatically and you need to provide fund input as per general document splitting and balancing standards.
  • Once the payroll agency fund is activated, payable postings from SAP SuccessFactors Employee Central Payroll, third party remittances and payments are posted with the payroll agency fund. Funds in expenditures remain unaffected by this.
  • All balance sheet line items, including the vendor line items and technical accounts, are posted with the payroll agency fund in the financial document. Zero balance clearing lines are also generated to balance the posting between the expending funds and the payroll agency fund plus other fields in the splitting and balancing criteria.
  • SAP SuccessFactors Employee Central Payroll system provides the option to split balances according to expenses, that is, the distribution of liabilities. Payroll agency fund activation takes precedence over the type of distribution maintained in the central settings for SAP SuccessFactors Employee Central Payroll. The payroll agency fund is only updated in the financial document in SAP S/4HANA Cloud and not in the documents that are stored in the SAP SuccessFactors Employee Central Payroll system.
  • If you need to manage your payroll payables in the actual expending fund or do not require the payroll agency fund, you can deactivate this setting in SAP S/4HANA Cloud and set up type of distribution settings in the SAP SuccessFactors Employee Central Payroll system.
Infographic depicting posting from Employee Central Payroll System to SAP S/4HANA Cloud for Public Sector.

SAP SuccessFactors Employee Central Payroll system posting programs (payroll, third-party remittances, and employee payment posting) would check the settings in SSCUI ID 180045 (Activate Pooled Funds) for payroll agency fund active status. If active, constants from SSCUI IDs 120100 (Edit Constant for Nonassigned Processes) and 180017 (Edit Constant for Expense or Revenue Account) are used in the balance sheet and vendor accounts in the postings. If the Treasury Fund is active, cash flow relevant accounts are posted to constants from 0CASH.

Posting with Agency Fund

The accounting entries in the table illustrate a payroll posting when an agency fund is active. Expenses such as payroll and benefits are posted to the fund to which the employee belongs and balances are posted to the payroll agency fund. Technical clearing accounts would also be posted to the agency fund.

Payroll Posting When Agency Fund Active: Ledger View

DR/CRG/L AccountCost CenterFundAmount
DRSalaries (P&L)AdministrationGeneral Fund$5,000.00
DRBenefits (P&L)AdministrationGeneral Fund$1,000.00
CRNetPay Payable (G/L)-Payroll Agency Fund$4,500.00
CRBenefits Payable (G/L)-Payroll Agency Fund$1,000.00
CRTax Payable (G/L)-Payroll Agency Fund$500.00
DREquity in Pooled Cash-Payroll Agency Fund$6,000.00
CREquity in Pooled Cash-General Fund$6,000.00

Posting with Agency Fund: Third-party Remittances

The accounting entries in the table illustrate third-party remittances posting from SAP SuccessFactors Employee Central Payroll. Both general ledger balances and vendor items are posted to payroll agency fund.

Payroll Posting When Agency Fund Active: Ledger View

DR/CRG/L AccountFundAmount
DRBenefits Payable (G/L)Payroll Agency Fund$1,000.00
CRBenefit Vendor (A/P)Payroll Agency Fund$1,000.00
DRTax Payable (G/L)Payroll Agency Fund$500.00
CRTax Vendor (A/P)Payroll Agency Fund$500.00

Posting with Agency Fund: Employee Payment Posting

The accounting entries in the table illustrate general ledger balances and the bank clearing posting when both payroll agency and Treasury Fund are active.

Employee Payment Posting: Ledger View

DR/CRG/L AccountFundAmount
DRNetPay Payable (G/L)Payroll Agency Fund$4,500.00
CRBank (cash)Treasury Fund$4,500.00
DREquity in Pooled CashTreasury Fund$4,500.00
CREquity in Pooled CashPayroll Agency Fund$4,500.00
UI example of a Company Code Assignment with highlighted Bank/Financial Details Relevant to Cash marked Yes.

When active, Treasury Fund posting is invoked for accounts that are set as cash flow relevant in cash payment and receipt document types.

Treasury and Payroll Agency Fund: Configuration

UI example of an Activate Pooled Funds: Change page displaying pooled funds activatoin check boxes for CoCd 1710.
  • Use self-service configuration UI ID: 180045 to Activate Pooled Funds.
  • Select TrsryFndAc for Treasury Fund
  • Select PayFndAct. for Payroll Agency Fund
UI example of an Edit Constant for Nonassigned... page with dialog structure folders for independent constants open.
  • Use self-service configuration UI ID: 120100 to Edit Constant for Non-assigned Processes.
  • Assign document splitting characteristics constants in 0PYRL for payroll agency fund and 0CASH for cash pooling with Treasury Fund.

Log in to track your progress & complete quizzes