Define Cash Balancing Rules for Cash Transactions
- Process all open transactions and payments that generate cash accounting.
- Security:Set Up: Worktag Balancingdomain in the Common Financial Management functional area.
You can configure cash balancing rules to automatically account for all usage of a bank account against a specified primary balancing worktag. This reduces the need to create manual journal entries to balance between funds at period close. Example: You designate a bank account for a given fund or region.
When you add a cash balancing rule to your worktag balancing transaction rule set, the cash balancing rule takes precedence over financial balancing rules that you configure for transaction types.
When you configure cash balancing rules, you can:
Option | Impact |
|---|---|
Specify a primary balancing worktag for bank accounts. | When generating accounting for cash transactions that use these bank accounts, Workday:
|
Set bank accounts to inherit the same balancing worktags as the operational transaction side (spend or revenue). | For transactions that use these bank accounts, Workday applies the option that you configure for the corresponding transaction type in your worktag balancing transaction rule set. Example: A financial balancing rule. |
Cash balancing rules apply to these cash transactions:
- Ad hoc bank transactions.
- Ad hoc payments.
- Miscellaneous payments.
- Prenote payments
For bank account transfers and transfers for settlement, Workday derives the associated balancing worktag when generating the transactions.
- Access theCreate Cash Balancing Ruletask.
- Complete the task:
Option Description Worktag TypeWorktag types are groupings of worktags by a business dimension: Cost center, business unit, region, fund, and custom organization. Select the type to use to balance journals for transactions subject to this rule.Your choice determines the worktags available for selection within this balancing rule.You can use only 1 balancing worktag type for all companies.Note that when the cash balancing rule isIn Useas part of your worktag balancing configuration, you can't change the worktag type.Default OptionDefault ValueSelect the option to apply to cash transactions with a bank account that you don't explicitly configure in theBalancing Worktag Offsetgrid. - (Optional) In theBalancing Worktag Offsetgrid, map a specific bank account to a primary balancing worktag.Workday applies the primary balancing worktag to the cash entries with the matching bank account worktag.
- Add the cash balancing rule to your worktag balancing transaction rule set:
- Edit the worktag balancing transaction rule set.
- Clear theAlways Inheritcheck box in theCash Transaction Typegrid.
- Select the cash balancing rule to apply it to all cash entries associated with a bank account.
When generating cash accounting or settling cash transactions with a bank account that the cash balancing rule maps to a primary balancing worktag, Workday uses the worktag to create interworktag balancing entries.
Your proposed amount of $100,000 for your project that uses Fund A is approved for budget. You receive a federal grant of $100,000 for the approved budget in your Treasury Fund. This intermediary fund assigned to the Treasury bank account pays and receives on behalf of other funds. In turn, Fund A has a claim on cash with the Treasury Fund.
When you create the customer invoice for the federal agency, Workday uses the worktag balancing transaction rule to generate accrual accounting entries with the inherited
Fund A
worktag:
Ledger Account | Debit | Credit | Worktag |
|---|---|---|---|
Accounts Receivable | 100K | Fund A
| |
Revenue | 100K | Fund A
|
When you receive the grant, you record the customer payment and apply the payment to the agency invoice. Workday generates the cash entry with the
Treasury Fund
worktag mapped to the Treasury bank account defined in the cash balancing rule. Workday also generates initial claim on cash (interworktag) entries between the Treasury Fund
and Fund A
worktags:
Ledger Account | Debit | Credit | Worktag |
|---|---|---|---|
Cash | 100K | Treasury Bank Account
Treasury Fund | |
Accounts Receivable | 100K | Fund A
| |
Claim on Cash | 100K | Treasury Fund
| |
Claim on Cash | 100K | Fund A
|
You expend the grant funds and record a supplier invoice for Fund A. Workday uses the worktag balancing transaction rule to generate accrual accounting entries with the inherited
Fund A
worktag:
Ledger Account | Debit | Credit | Worktag |
|---|---|---|---|
Spend | 100K | Fund A
| |
Accounts Payable | 100K | Fund A
|
When you settle the supplier invoice, Workday generates the cash entry with the
Treasury Fund
worktag mapped to the Treasury bank account. Workday also generates claim on cash entries to balance between Treasury Fund and Fund A:
Ledger Account | Debit | Credit | Worktag | Interworktag Affiliate |
|---|---|---|---|---|
Accounts Payable | 100K | Fund A
| ||
Cash | 100K | Treasury Bank Account
Treasury Fund | ||
Claim on Cash | 100K | Treasury Fund
| Fund A
| |
Claim on Cash | 100K | Fund A
| Treasury Fund
|
To help ensure manual cash accounting entries post with the correct balancing worktag, use the
Worktag doesn’t match Cash Balancing Rule
report field to create:
- A custom validation to inform you when a manually entered balancing worktag on a cash journal line doesn't match the rule definition.
- A custom report to identify manual cash journal lines with a bank account and balancing worktag that doesn't match the rule definition.