Accounting Cash Pool Asset/Liabilities Month end (only SM)

Created by Erik Åkerlund, Modified on Mon, 20 Feb 2023 at 02:31 PM by Erik Åkerlund

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 new Dimension rule for BANKCP to automatically set the bank accounts for the cash pool owner. Usually per currency see below. 


Accounting / Unrealised accounting

To create the accounting in month end go to Unrealised accounting and create a new selection CP assets and liability. 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 see below. 


Accounting view

Check the accounting that it looks correct. 

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



Integration

In integrations it is possible to set the correct Legal entity and Counterpart for the Cash pool owner accounting. See e.g. below. 




Accounting file Example

Approve and export the file as usually in accounting view and below is an example of an accounting file created with correct accounts and Legal entity and Counterparty codes. Note Treasury systems does not automatically creates a reversal file for these accountings yet. They needs to be reversed in the ERP system. 




 





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 atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article