Manage cash pool and loan management proposal

Create cash pool and loan management proposals in 'Cash/Loan Pool Proposal. Open' (MFS300)

Cash pooling describes the scenario where currency transfers within a company, and interest invoicing, are managed by a centrally located treasury department accessing the currency accounts of the divisions belonging to the company.

Loan management describes the scenario where a local division lends money to and is invoicing another division, without a centrally located treasury department acting as a middleman.

Outcome

A proposal that can be invoiced is created. The basis for the proposal is the cash pool and loan management IDs defined in 'Cash and Loan Pool ID. Open' (MFS025).

See Create cash pool and loan management ID.

When creating the proposal, all cash pool and loan management IDs defined in (MFS025) are included unless one of these scenarios apply:
  • The cash pool and loan management ID is already included in another proposal for the selected period.
  • The account defined on the cash pool and loan management ID has no balance during the selected period.

Before you start

These common starting conditions apply:
  • Bank transactions using the accounts selected in (MFS025) for contra entries are recorded.
  • You must create one or more interest rate IDs in 'Interest Rate ID. Open' (CMS460) with associated interest rates defined in 'Interest Rate ID. Define Rates' (CMS461). See the related documents.
  • You must create cash pool and loan management IDs in (MFS025). For details, see the related documents.
  • FAM functions and accounting rules are updated for MF30 (Cash pooling) or MF40 (Loan management), or both, in 'FAM Function. Open' (CRS405) and 'Accounting Rule. Set' (CRS395) respectively. You must generate accounting types 641 and 642 in 'Accounting Type. Open' (CRS385).

Create cash pool or loan management proposal

  1. Open 'Cash/Loan Pool Proposal. Open' (MFS300/B).
  2. Specify an ID consisting of up to 10 alphanumeric characters for the proposal. Select option 1='Create'.
  3. Optionally, on the E panel, specify a report description.
  4. Select whether to create the proposal for 'Cash pool and loan management IDs' defined for cash pooling or loan management.
  5. Specify the period.
  6. Click Next to create the report proposal.
Each day in the selected period, an opening, daily, and closing balance is retrieved and calculated on the account defined on the cash pool and loan management ID. Based on the closing balance, daily interest is calculated using the interest rate ID, invoicing currency and exchange rate type.
Note: The lending or borrowing interest rate ID is used, depending on whether the closing balance is positive (lending) or negative (borrowing).

Review and confirm proposal

You can review the proposal in two ways: On screen, see steps 1-10, or by printing two different layouts, see steps 11-13, or both.
  1. On (MFS300/B), select related option 11='Details per date' for the proposal when it is in status '1-Proposal is created'.
  2. On 'Cash/Loan Pool Proposal. Det per Date' (MFS301/B), review the proposal details per customer, cash pool and loan management ID, and date.
  3. Close (MFS301) to return to (MFS300/B).
  4. On (MFS300/B), select related option 12='Details per pool'.
  5. On 'Cash/Loan Pool Proposal. Det per Pool' (MFS302/B), review the proposal details per customer, cash pool and loan management ID, and income or cost type. On this panel, the calculated interest is summarized per cash and loan management ID, and split to income or cost. The simulated accounting string for each income and cost transaction is displayed.
  6. Close (MFS302) to return to (MFS300/B).
  7. On (MFS300/B), select related option 13='Details per invoice'.
  8. On 'Cash/Loan Pool Proposal. Det per Invoice' (MFS303/B), review the proposal details per customer, invoicing currency, and cash pool and loan management ID. On this panel, the cash pool and loan management IDs included in the proposal are grouped by a substitute invoice number as the purpose of the program is to see which pools are included on the same invoice. The break level for an invoice is the customer and invoicing currency.
    Note: When confirming the proposal and thereby creating the invoices, an invoice number is retrieved, according to the settings on the FAM function.
  9. On (MFS303/B), you can delete a record. When deleting a record, all information belonging to that customer and invoicing currency are deleted from the proposal, including the information displayed in (MFS301) and (MFS302). When a new proposal for the same period is created, the cash pool and loan management ID related to the deleted record are included.
  10. Close (MFS303) to return to (MFS300/B).
  11. On (MFS300/B), select related option 6='Print'.
  12. On 'Cash/Loan Pool Proposal. Print' (MFS304/E), select one of these reports layout to print:
    • 1-'Details per date' (MFS305PF): The calculated values are displayed per customer, cash pool and loan management ID, and date. The information in this layout is similar to the information available in (MFS301).
    • 2-'Details per invoice' (MFS306PF): The calculated values are summarized per cash pool and loan management ID, and are grouped per customer and invoicing currency, which is the break level of an invoice. The information in this layout is a mix of the information available in (MFS302) and (MFS303).
  13. When the review is finished, return to (MFS300/B).
  14. On (MFS300/B), select related option 9='Confirm'. Select the accounting date and invoice date and click Next to create customer invoices, printed in ARS121PF, and update ledgers.

Proposal review fields

This table shows the various fields used in the proposal review process:

Field Field description
Opening balance The daily opening balance on the account of the cash pool and loan management ID. The opening balance is together with the daily balance summing up to the closing balance.
Daily balance The total amount of the transactions per day on the account of the cash pool and loan management ID. The daily balance is together with the opening balance summing up to the closing balance.
Closing balance The sum of the opening balance and daily balance. This amount is the base for calculation of the daily interest amount.
Income/cost type Indicates whether the closing balance and calculated interest is an income (positive balance) or a cost (negative balance).
Interest rate The interest rate defined in (CMS461) that has been used to calculate the daily interest amount. Which rate is used depends whether the closing balance is positive or negative. If positive, the interest rate ID for lending is used. If negative, the interest rate ID for borrowing is used.
Interest amount The calculated interest amount expressed in the currency of the account connected to the cash pool and loan management ID.
Currency The currency of the account connected to the cash pool and loan management ID.
Interest amount in invoicing currency The calculated interest amount expressed in the invoicing currency. The invoicing currency and exchange rate type is defined per cash pool and loan management ID in (MFS025) and the rate selected depends on the interest rate method, daily rate or end of period rate, selected in (MFS025).
Invoicing currency The currency in which the interest is invoiced to the customer.
Related topics