Book cash pool assets and liabilities at month end

Modified on Wed, 18 Nov at 10:47 AM

Print

At each month end, subsidiaries with sub-accounts in a cash pool book an asset or a liability towards the cash pool owner, and the cash pool owner books the opposite. You can set up TS to create these bookings as unrealised accounting and export them with your usual accounting file.

Steps

Check the amount types

  1. Go to Accounting › Amount Types.
  2. Select the Net accounting model.
  3. Check that the cash pool amount types are listed under the accounting program type Bank Balance. TS includes them by default.

    Amount Types for the Net accounting model, with eight cash pool amount types under the accounting program type Bank Balance

These are the cash pool amount types. All of them have the event time Unrealised, the event type Bank Balance, the accounting principle Settlement Date and the FX rate principle Due Date FX Rate.

NameReport column IDDebit creditBank account revaluation principle
CP Subsidiary Liability CashBooked Balance (Less Than Zero)DebitInclude
CP Subsidiary LiabilityBooked Balance (Less Than Zero)CreditExclude
CP Owner Asset CashBooked Balance (Less Than Zero)CreditInclude
CP Owner AssetBooked Balance (Less Than Zero)DebitExclude
CP Subsidiary Asset CashBooked Balance (Greater Than Zero)CreditInclude
CP Subsidiary AssetBooked Balance (Greater Than Zero)DebitExclude
CP Owner LiabilityBooked Balance (Greater Than Zero)CreditExclude
CP Owner Liability CashBooked Balance (Greater Than Zero)DebitInclude

Create the accounting rule

  1. Go to Accounting › Accounting Rules.
  2. Add a new accounting rule with the accounting program type Bank Balance.
  3. In the rule's setup, select the accounts for the cash pool amount types: BANK for the subsidiaries' checking account, and a separate BANKCP account for the cash pool owner.

    Accounting Rules with a Bank Balance rule for cash pool assets and liabilities at month end, its selection summary and its account setup

Set the cash pool owner's bank accounts

  1. Go to Accounting › Dimension Rules.
  2. Create a dimension rule for BANK, or add the condition to an existing rule. The rule sets the bank accounts for the cash pool owner automatically.
  3. For example, use the dimension type Bank Account with the condition expression StartsWith([Account], 'BANK').

    Dimension Rules with a Bank Accounts rule of dimension type Bank Account and the condition StartsWith([Account], 'BANK')

Create the month-end accounting

  1. Go to Accounting › Unrealised accounting.
  2. Select Add Report to create a new selection, for example CP Asset and Liability.

    Accounting of unrealised with the CP Asset and Liability selection open, showing its dates, FX rate fields and selection summary

  3. In Balance Date, enter the month-end date.
  4. In FXRate End, select the month-end rate.
  5. Select Run.
Check the balance date in the selection before you run the accounting. It must be the month-end date.

Check and export the accounting

  1. Open Accounting view and check that the accounting is correct.
  2. Approve the accounting.
  3. Export the accounting file as in your usual accounting process.
In Accounting view, ignore Legal entity and Counterparty on the accounting lines for the cash pool owner. TS sets them correctly in the export file.

Result

TS creates the month-end asset and liability bookings for the subsidiaries and the cash pool owner. The unrealised accounting and its reversal are created in the same run, and are included in the accounting file you export.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article

More in Master data

Still need help? Reach people who already know your configuration.

Submit a ticket