Accounting Cash Pool Asset/Liabilities Month end

In each month end the Subsidiaries that has Sub accounts in a cash pool needs to book an asset or Liability towards the cash pool owner and the Cash pool owner needs to do the opposite. This can be done in Treasury systems. 

Below is instruction how this can be set up in Treasury systems. 

Accounting / Amount Types

Accounting Rules

Create new accounting rule for Bank Balance and select the accounts. Bank for Subsidiaries checking account and a separate BANKCP for the cash pool owner (see Dimension Rules below). 

Dimension Rules

Create a Dimension rule for "BANK" or add to an existing rule to automatically set the bank accounts for the cash pool owner. Example of Dimension rule: 

Accounting / Unrealised accounting

To create the accounting in month end go to Unrealised accounting and create a new selection CP assets and liability (screen shot below). Select month end date and in FX rate table end select the month end rate. Note, check the balance date in selection before you run the accounting, it needs to be the Month end date! 

Click run and all the accountings are created and are now shown in Accounting view. 

Accounting view

Check the accounting that it looks correct. 

Ignore Legal entity and Counterparty for the counting Lines with cash pool owner. This will be set correctly in the export file. 

Accounting file

Approve accounting and export the file according to the usual accounting process. Unrealised and Reversal is created in the same run.